From c8b67a10b98d24a8c9ca365bb6171ad1419f6a6f Mon Sep 17 00:00:00 2001 From: skotlex Date: Tue, 13 Jun 2006 23:49:53 +0000 Subject: - Updated mob_db.sql and item_db.sql to latest. - Added account_id index to char table. Thanks to Buuyo for reporting it. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7146 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'sql-files/main.sql') diff --git a/sql-files/main.sql b/sql-files/main.sql index 4e7a00a54..7ade98b8f 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -78,6 +78,7 @@ CREATE TABLE `char` ( `child` int(11) unsigned NOT NULL default '0', `fame` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`char_id`), + KEY `char_id` (`char_id`) KEY `party_id` (`party_id`), KEY `guild_id` (`guild_id`) ) TYPE=InnoDB AUTO_INCREMENT=150000; -- cgit v1.2.3-70-g09d2