diff options
| author | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-10-23 18:54:28 +0000 |
|---|---|---|
| committer | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-10-23 18:54:28 +0000 |
| commit | 3b0f46cd61c0398fbd52887f5db54da99aa4b150 (patch) | |
| tree | ad10fb810242a494b8a194104a855c0e2b31372b /sql-files | |
| parent | 7d9c60fd321696ac11aecbfcc008299d7625f418 (diff) | |
| download | hercules-3b0f46cd61c0398fbd52887f5db54da99aa4b150.tar.gz hercules-3b0f46cd61c0398fbd52887f5db54da99aa4b150.tar.bz2 hercules-3b0f46cd61c0398fbd52887f5db54da99aa4b150.tar.xz hercules-3b0f46cd61c0398fbd52887f5db54da99aa4b150.zip | |
- 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
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/logs.sql | 22 | ||||
| -rw-r--r-- | sql-files/upgrade_svn9050.sql | 6 |
2 files changed, 22 insertions, 6 deletions
diff --git a/sql-files/logs.sql b/sql-files/logs.sql index aae128398..7a27f8a6a 100644 --- a/sql-files/logs.sql +++ b/sql-files/logs.sql @@ -17,7 +17,8 @@ CREATE TABLE `picklog` ( `card2` int(11) NOT NULL default '0',
`card3` int(11) NOT NULL default '0',
`map` varchar(20) NOT NULL default 'prontera.gat',
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`),
+ INDEX (`type`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#ZenyLog types (M)onsters,(T)rade,(V)ending Sell/Buy,(S)hop Sell/Buy,(N)PC Change amount,(A)dministrators
@@ -31,7 +32,8 @@ CREATE TABLE `zenylog` ( `type` set('M','T','V','S','N','A') NOT NULL default 'S',
`amount` int(11) NOT NULL default '0',
`map` varchar(20) NOT NULL default 'prontera.gat',
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`),
+ INDEX (`type`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#Database: log
@@ -43,7 +45,9 @@ CREATE TABLE `branchlog` ( `char_id` int(11) NOT NULL default '0',
`char_name` varchar(30) NOT NULL default '',
`map` varchar(20) NOT NULL default 'prontera.gat',
- PRIMARY KEY (`branch_id`)
+ PRIMARY KEY (`branch_id`),
+ INDEX (`account_id`),
+ INDEX (`char_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#Database: log
@@ -69,7 +73,9 @@ CREATE TABLE `atcommandlog` ( `char_name` varchar(30) NOT NULL default '',
`map` varchar(20) NOT NULL default 'prontera.gat',
`command` varchar(50) NOT NULL default '',
- PRIMARY KEY (`atcommand_id`)
+ PRIMARY KEY (`atcommand_id`),
+ INDEX (`account_id`),
+ INDEX (`char_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#Database: log
@@ -82,7 +88,9 @@ CREATE TABLE `npclog` ( `char_name` varchar(30) NOT NULL default '',
`map` varchar(20) NOT NULL default 'prontera.gat',
`mes` varchar(255) NOT NULL default '',
- PRIMARY KEY (`npc_id`)
+ PRIMARY KEY (`npc_id`),
+ INDEX (`account_id`),
+ INDEX (`char_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#ChatLOG
@@ -98,5 +106,7 @@ CREATE TABLE `chatlog` ( `src_map_y` smallint(4) NOT NULL default '0',
`dst_charname` varchar(25) NOT NULL default '',
`message` varchar(150) NOT NULL default '',
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`),
+ INDEX (`src_accountid`),
+ INDEX (`src_charid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
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`);
|