db/migrations/1.115_performance_tic_3759.php


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

<?php
class PerformanceTic3759 extends Migration
{
    function description()
    {
        return 'changes index for plugins_activated,deputies';
    }

    function up()
    {
        DBManager::get()->exec("ALTER TABLE  `plugins_activated` CHANGE  `poiid`  `poiid` VARCHAR( 36 ) NOT NULL DEFAULT  ''");
        DBManager::get()->exec("ALTER TABLE  `plugins_activated` ADD UNIQUE (  `poiid` ,  `pluginid` ,  `state` )");
        DBManager::get()->exec("ALTER TABLE  `deputies` ADD INDEX (  `user_id` ,  `range_id` ,  `edit_about` )");
    }

    function down()
    {
    }
}