db/migrations/1.86_step_228_raumanfragen.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

<?php
class Step228Raumanfragen extends Migration
{
    public function description()
    {
        return 'adds field metadate_id to resources_requests';
    }

    public function up()
    {
        $db = DBManager::get();
        $db->exec(
            "ALTER TABLE `resources_requests` ADD `metadate_id` VARCHAR(32) NOT NULL DEFAULT '' AFTER `termin_id`");
        $db->exec(
            "ALTER TABLE `resources_requests` DROP INDEX  `closed` , ADD INDEX  `closed` (`closed` , `request_id`, `resource_id`)");
        $db->exec(
            "ALTER TABLE `resources_requests` ADD INDEX (`metadate_id`)");
    }

    public function down()
    {
        $db = DBManager::get();
        $db->exec(
            "ALTER TABLE `resources_requests` " .
            "DROP COLUMN `metadate_id`");
    }
}