db/migrations/1.140_tic4450_archiv_protected_files.php


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

<?php
class Tic4450ArchivProtectedFiles extends Migration
{
    function description()
    {
        return 'ALTER TABLE `archiv` ADD `archiv_protected_file_id`';
    }

    function up()
    {
        $query = "ALTER TABLE `archiv` ADD `archiv_protected_file_id` VARCHAR(32) NOT NULL DEFAULT '' AFTER `archiv_file_id`";

        DBManager::get()->exec($query);
    }

    function down()
    {
        DBManager::get()->exec("ALTER TABLE `archiv` DROP `archiv_protected_file_id`");
    }
}