diff options
author | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-06-14 14:18:30 +0000 |
---|---|---|
committer | skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-06-14 14:18:30 +0000 |
commit | 50df12f5c8f485b12944182a53c43df975edd4cb (patch) | |
tree | e2f1949f32c5dab7c45cc0d2946062ff28904a8e /sql-files/main.sql | |
parent | 03cc029170d3ccdc02864d691b8aecd9d14ae7cd (diff) | |
download | hercules-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/main.sql')
-rw-r--r-- | sql-files/main.sql | 2 |
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;
|