db/migrations/1.40_add_index_to_log_events.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

<?php

class AddIndexToLogEvents extends Migration {
    function description() {
        return "adds an index to the log_events table";
    }

    function up() {
         DBManager::get()->query("ALTER TABLE `log_events` ADD INDEX `action_id` ( `action_id` )");
    }

    function down() {
         DBManager::get()->query("ALTER TABLE `log_events` DROP INDEX `action_id`");
    }
}