db/migrations/5.5.22_add_feedback_anonymous_entries.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
final class AddFeedbackAnonymousEntries extends Migration
{
    public function description()
    {
        return 'Extend feedback tables for anonymous entries';
    }

    public function up()
    {
        \DBManager::get()->exec("ALTER TABLE `feedback` 
            ADD `anonymous_entries` TINYINT(1) NOT NULL DEFAULT 0 
            AFTER `commentable`
        ");

        \DBManager::get()->exec("ALTER TABLE `feedback_entries` 
            ADD `anonymous` TINYINT(1) NOT NULL DEFAULT 0
            AFTER `rating`
        ");
    }

    public function down()
    {
        \DBManager::get()->exec("ALTER TABLE `feedback` DROP `anonymous_entries`");
        \DBManager::get()->exec("ALTER TABLE `feedback_entries` DROP `anonymous`");
    }
}