db/migrations/1.11_lock_rulez.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
33
34
35
36
37
38

<?
class LockRulez extends Migration
{

    public function description ()
    {
        return 'creates table for lock rules';
    }

    public function up ()
    {
        $this->announce(" creating table...");

        DBManager::get()->exec( "
            CREATE TABLE `lock_rules` (
                `lock_id` varchar(32) NOT NULL default '',
                `name` varchar(255) NOT NULL default '',
                `description` text NOT NULL,
                `attributes` text NOT NULL,
                PRIMARY KEY  (`lock_id`)
            ) ENGINE=MyISAM");

        DBManager::get()->exec("ALTER TABLE `seminare` ADD `lock_rule` VARCHAR( 32 ) NULL");

        $this->announce("done.");

    }

    public function down ()
    {
        $this->announce(" removing table...");
        DBManager::get()->exec("DROP TABLE `lock_rules`");
        DBManager::get()->exec("ALTER TABLE `seminare` DROP `lock_rule`");

        $this->announce("done.");

    }
}