db/migrations/1.137_studygroup_invitations.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

<?php
class StudygroupInvitations extends Migration
{
    function description()
    {
        return 'Create database for studygroup invitations.';
    }

    function up()
    {
        $query = "CREATE TABLE IF NOT EXISTS `studygroup_invitations` (
                    `sem_id` varchar(32) NOT NULL,
                    `user_id` varchar(32) NOT NULL,
                    `mkdate` int(20) NOT NULL,
                    PRIMARY KEY (`sem_id`,`user_id`)
                  )";
        DBManager::get()->exec($query);
    }

    function down()
    {
        DBManager::get()->exec("DROP TABLE IF EXISTS `studygroup_invitations`");
    }
}