db/migrations/5.2.12_add_semwechsel_field.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 AddSemwechselField extends Migration
{
    public function description()
    {
        return 'Add field sem_wechsel to table semester_data';
    }


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

        $db->exec(
            "ALTER TABLE `semester_data`
            ADD `sem_wechsel` INT(11) UNSIGNED NULL AFTER `ende`"
        );
    }


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

        $db->exec(
            "ALTER TABLE `semester_data` DROP `sem_wechsel`"
        );

    }
}