diff options
Diffstat (limited to 'sql-files/upgrade_svn9050.sql')
| -rw-r--r-- | sql-files/upgrade_svn9050.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn9050.sql b/sql-files/upgrade_svn9050.sql new file mode 100644 index 000000000..932bc3b38 --- /dev/null +++ b/sql-files/upgrade_svn9050.sql @@ -0,0 +1,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`);
|