From c4b4c52fc1d26e52da8eda5f93c05e1ff2dd3eb2 Mon Sep 17 00:00:00 2001 From: Yohann Ferreira Date: Wed, 15 Sep 2010 19:54:00 +0200 Subject: Fixed characters not being returned at character selection when using MySQL. The table mana_char_equips wasn't created due to an SQL error, this led the account server to not return the player's characters. Seen in the logs: [19:40:41] [ERR] (DALStorage::getCharacter #1) SQL query failure: Table 'bertram.mana_char_equips' doesn't exist [19:40:41] [ERR] Failed to get character 11 for account 1. Resolves: Manasource mantices: 189, 230. Reviewed-by: Thorbjorn. --- src/sql/mysql/createTables.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'src/sql/mysql/createTables.sql') diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index a76cc337..84a35308 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -181,14 +181,14 @@ AUTO_INCREMENT=1 ; -- table: `mana_char_equips` -- CREATE TABLE IF NOT EXISTS `mana_char_equips` ( - id int(10) unsigned NOT NULL auto_increment, - owner_id int(10) unsigned NOT NULL, - slot_type tinyint(3) unsigned NOT NULL, - inventory_slot tinyint(3) unsigned NOT NULL, + `id` int(10) unsigned NOT NULL auto_increment, + `owner_id` int(10) unsigned NOT NULL, + `slot_type` tinyint(3) unsigned NOT NULL, + `inventory_slot` tinyint(3) unsigned NOT NULL, -- PRIMARY KEY (`id`), - UNIQUE KEY `owner_id` (`owner_id`, ) - FOREIGN KEY (owner_id) REFERENCES mana_characters(id) + UNIQUE KEY `owner_id` (`owner_id`, `inventory_slot`), + FOREIGN KEY (`owner_id`) REFERENCES `mana_characters` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- cgit v1.2.3-70-g09d2