db/migrations/1.134_step_00269_plugin_roles.php


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

<?
Class Step00269PluginRoles extends Migration {

    function description()
    {
        return 'adds column institut_id to table roles_user';
    }


    function up()
    {
        DBManager::get()->exec("ALTER TABLE `roles_user` ADD `institut_id` CHAR(32) NOT NULL DEFAULT ''");
        DBManager::get()->exec("ALTER TABLE `roles_user` DROP PRIMARY KEY");
        DBManager::get()->exec("ALTER TABLE `roles_user` ADD PRIMARY KEY( `roleid`, `userid`, `institut_id`)");
    }

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