From 50df12f5c8f485b12944182a53c43df975edd4cb Mon Sep 17 00:00:00 2001 From: skotlex Date: Wed, 14 Jun 2006 14:18:30 +0000 Subject: - 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 --- sql-files/main.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql-files') 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; -- cgit v1.2.3-60-g2f50