db/migrations/5.1.24_biest_348.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 Biest348 extends Migration
{
    use DatabaseMigrationTrait;

    public function description ()
    {
        return 'Adds a column to the resources table to mark resources as lockable, default is 1.';
    }

    public function up()
    {
        if ($this->columnExists('resources', 'lockable')) {
            return;
        }

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

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