From 3b0f46cd61c0398fbd52887f5db54da99aa4b150 Mon Sep 17 00:00:00 2001
From: skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>
Date: Mon, 23 Oct 2006 18:54:28 +0000
Subject: - Added a bunch of important indexes when dealing with the log
 tables. Added upgrade_svn9050.sql for this purpose.

git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@9051 54d463be-8e91-2dee-dedb-b68131a5f0ec
---
 sql-files/upgrade_svn9050.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql-files/upgrade_svn9050.sql

(limited to 'sql-files/upgrade_svn9050.sql')

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`);
-- 
cgit v1.2.3-70-g09d2

