summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-06-14 14:18:30 +0000
committerskotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-06-14 14:18:30 +0000
commit50df12f5c8f485b12944182a53c43df975edd4cb (patch)
treee2f1949f32c5dab7c45cc0d2946062ff28904a8e /sql-files
parent03cc029170d3ccdc02864d691b8aecd9d14ae7cd (diff)
downloadhercules-50df12f5c8f485b12944182a53c43df975edd4cb.tar.gz
hercules-50df12f5c8f485b12944182a53c43df975edd4cb.tar.bz2
hercules-50df12f5c8f485b12944182a53c43df975edd4cb.tar.xz
hercules-50df12f5c8f485b12944182a53c43df975edd4cb.zip
- Fixed main.sql adding a key on char_id rather than account_id for the char table.
- Cleaned up character saving in char-sql, it no longer needs to query the database to see if the player exists on each char-save, instead it checks the received data against the online-players db. - Added an error message on the char-server when the received player data size does not matches with the expected size (should avoid the crash that happens on such a memcpy). git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7160 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/main.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index c10ed7c15..f0350d929 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -78,7 +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 `account_id` (`account_id`),
KEY `party_id` (`party_id`),
KEY `guild_id` (`guild_id`)
) TYPE=InnoDB AUTO_INCREMENT=150000;