From 082a88a7ac74e52fd5d239e1e974731a9a7b3fdc Mon Sep 17 00:00:00 2001
From: Erik Schilling <ablu.erikschilling@googlemail.com>
Date: Fri, 2 Sep 2011 18:49:14 +0800
Subject: Fixed size of mapid field in mysql database.

Resolves: Mana-Mantis: #388.

Reviewed-by: Bertram.
---
 src/sql/mysql/createTables.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/sql/mysql/createTables.sql')

diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 9e1e31a6..3a5f5187 100644
--- a/src/sql/mysql/createTables.sql
+++ b/src/sql/mysql/createTables.sql
@@ -39,7 +39,7 @@ CREATE TABLE IF NOT EXISTS `mana_characters` (
     -- location on the map
     `x`            smallint(5)  unsigned NOT NULL,
     `y`            smallint(5)  unsigned NOT NULL,
-    `map_id`       tinyint(3)   unsigned NOT NULL,
+    `map_id`       smallint(5)  unsigned NOT NULL,
     `slot`         smallint(5)  unsigned NOT NULL,
     --
     PRIMARY KEY (`id`),
-- 
cgit v1.2.3-70-g09d2

