summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn9050.sql
blob: 2e0c7248975e8d0256f8b34ae97f02641a945319 (plain) (blame)
1
2
3
4
5
6
ALTER TABLE `picklog` ADD INDEX (`type`);
ALTER TABLE `zenylog` ADD INDEX (`type`);
ALTER TABLE `branchlog` ADD INDEX (`account_id`), ADD INDEX (`char_id`);
ALTER TABLE `atcommandlog` ADD INDEX (`account_id`), ADD INDEX (`char_id`);
ALTER TABLE `npclog` ADD INDEX (`account_id`), ADD INDEX (`char_id`);
ALTER TABLE `chatlog` ADD INDEX (`src_accountid`), ADD INDEX (`src_charid`);