db/migrations/1.119_init_termin_related_groups_table.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
25

<?php

class InitTerminRelatedGroupsTable extends Migration {

    function description() {
        return 'Thread can now be closed.';
    }

    function up() {
        DBManager::get()->exec(
            "CREATE TABLE IF NOT EXISTS `termin_related_groups` (
                `termin_id` VARCHAR(32) NOT NULL ,
                `statusgruppe_id` VARCHAR(45) NOT NULL ,
                UNIQUE KEY `unique` (`termin_id`,`statusgruppe_id`),
                INDEX `termin_id` (`termin_id` ASC) ,
                INDEX `statusgruppe_id` (`statusgruppe_id` ASC) 
            ) ENGINE=MyISAM;");
    }

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

}