db/migrations/6.0.12_tic_2715.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

<?php
class Tic2715 extends Migration
{
    public function description ()
    {
        return 'Add a column to mark resources as requestable via the booking plan, default is 1';
    }

    public function up()
    {
        $query = 'ALTER TABLE `resources`
                  ADD `booking_plan_request` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1 AFTER `lockable`';
        DBManager::get()->exec($query);
    }

    public function down()
    {
        $query = 'ALTER TABLE `resources` DROP `booking_plan_request`';
        DBManager::get()->exec($query);
    }
}