db/migrations/1.77_step_00223_lockrules.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

<?php
class Step00223LockRules extends Migration
{
    public function description()
    {
        return 'Step00223: extend db table lock_rules';
    }

    public function up()
    {
        $db = DBManager::get();
        $db->exec("ALTER TABLE `lock_rules` CHANGE `permission` `permission` ENUM( 'autor', 'tutor', 'dozent', 'admin', 'root' ) NOT NULL DEFAULT 'dozent'");
        $db->exec("ALTER TABLE `lock_rules` ADD `object_type` ENUM( 'sem', 'inst', 'user' ) NOT NULL DEFAULT 'sem'");
        $db->exec("ALTER TABLE `lock_rules` ADD `user_id` VARCHAR( 32 ) NOT NULL DEFAULT ''");
        $db->exec("ALTER TABLE `user_info` ADD `lock_rule` VARCHAR( 32 ) NOT NULL DEFAULT ''");
        $db->exec("ALTER TABLE `Institute` ADD `lock_rule` VARCHAR( 32 ) NOT NULL DEFAULT ''");
    }

    public function down()
    {
        $db = DBManager::get();
        $db->exec("ALTER TABLE `lock_rules` CHANGE `permission` `permission` ENUM( 'tutor', 'dozent', 'admin', 'root' ) NOT NULL DEFAULT 'dozent'");
        $db->exec("ALTER TABLE `lock_rules` DROP `object_type`");
        $db->exec("ALTER TABLE `lock_rules` DROP `user_id`");
        $db->exec("ALTER TABLE `user_info` DROP `lock_rule`");
        $db->exec("ALTER TABLE `Institute` DROP `lock_rule`");
    }
}