From 50df12f5c8f485b12944182a53c43df975edd4cb Mon Sep 17 00:00:00 2001
From: skotlex <skotlex@54d463be-8e91-2dee-dedb-b68131a5f0ec>
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/main.sql')

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-70-g09d2

