db/migrations/5.2.1_add_pk_for_user_inst.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
26
27
28
29
30
31
32

<?php

class AddPkForUserInst extends Migration
{
    public function description()
    {
        return 'add simple pk for user_inst table';
    }

    public function up()
    {
        $db = DBManager::get();

        $sql = 'ALTER TABLE user_inst
                ADD id int(11) NOT NULL AUTO_INCREMENT FIRST,
                DROP PRIMARY KEY,
                ADD PRIMARY KEY (id),
                ADD UNIQUE KEY user_inst (Institut_id, user_id)';
        $db->exec($sql);
    }

    public function down()
    {
        $db = DBManager::get();

        $sql = 'ALTER TABLE user_inst
                DROP id,
                DROP KEY user_inst,
                ADD PRIMARY KEY (Institut_id, user_id)';
        $db->exec($sql);
    }
}