db/migrations/1.95_extend_userstudiengang_primarykey.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

<?php
# refers to https://develop.studip.de/trac/ticket/2568
class ExtendUserstudiengangPrimarykey extends Migration
{
    /**
     * short description of this migration
     */
    function description()
    {
        return 'extends the primary key of table "user_studiengang" to include column "abschluss_id"';
    }

    /**
     * perform this migration
     */
    function up()
    {
        $query = "ALTER TABLE `user_studiengang`
                    DROP PRIMARY KEY,
                    ADD PRIMARY KEY (`user_id`, `studiengang_id`, `abschluss_id`)";
        DBManager::get()->exec($query);
    }

    /**
     * revert this migration
     */
    function down()
    {
        $query = "ALTER TABLE `user_studiengang`
                    DROP PRIMARY KEY,
                    ADD PRIMARY KEY (`user_id`, `studiengang_id`)";
        DBManager::get()->exec($query);
    }
}