db/migrations/6.1.16_remove_forum_configurations_from_sem_classes_table.php


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

<?php

final class RemoveForumConfigurationsFromSemClassesTable extends Migration
{
    public function up()
    {
        DBManager::get()->exec("
            ALTER TABLE `sem_classes`
                DROP COLUMN `write_access_nobody`,
                DROP COLUMN `topic_create_autor`
        ");
    }

    public function down()
    {
        DBManager::get()->exec("
            ALTER TABLE `sem_classes`
                ADD COLUMN `write_access_nobody` TINYINT(3) UNSIGNED NOT NULL AFTER `show_browse`,
                ADD COLUMN `topic_create_autor` TINYINT(3) UNSIGNED NOT NULL AFTER `write_access_nobody`
        ");
    }
}