From c4b4c52fc1d26e52da8eda5f93c05e1ff2dd3eb2 Mon Sep 17 00:00:00 2001
From: Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>
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 a76cc33..84a3530 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 

