db/migrations/1.14_step_00123_admission2.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

<?php
class StEP00123Admission2 extends Migration
{
    public function description ()
    {
        return 'modifies table seminare, adds field `admission_enable_quota`';
    }

    public function up ()
    {
        $this->announce(" modifying  table `seminare` adding field `admission_enable_quota`...");
        
        DBManager::get()->exec( "ALTER TABLE `seminare` ADD `admission_enable_quota` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `admission_disable_waitlist`");

        $this->announce(" update old entries...");

        DBManager::get()->exec("UPDATE `seminare` SET `admission_enable_quota` =1 WHERE admission_type IN ( 1, 2 )");

        $this->announce("done.");
    }
    
    public function down ()
    {
        $this->announce(" removing field `admission_enable_quota` from `seminare`...");

        DBManager::get()->exec("ALTER TABLE `seminare` DROP `admission_enable_quota` ");

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