4 files changed, 16 insertions, 2 deletions
diff --git a/src/account-server/storage.cpp b/src/account-server/storage.cpp
index 96601207..3d6d4f51 100644
--- a/src/account-server/storage.cpp
+++ b/src/account-server/storage.cpp
@@ -41,7 +41,7 @@ static const char *DEFAULT_ITEM_FILE = "items.xml";
 
 // Defines the supported db version
 static const char *DB_VERSION_PARAMETER = "database_version";
-static const char *SUPPORTED_DB_VERSION = "14";
+static const char *SUPPORTED_DB_VERSION = "16";
 
 /*
  * MySQL specificities:
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`),
diff --git a/src/sql/mysql/updates/update_15_to_16.sql b/src/sql/mysql/updates/update_15_to_16.sql
new file mode 100644
index 00000000..df94f995
--- /dev/null
+++ b/src/sql/mysql/updates/update_15_to_16.sql
@@ -0,0 +1,7 @@
+ALTER TABLE mana_characters CHANGE map_id map_id smallint(5);
+
+-- Update database version.
+UPDATE mana_world_states
+SET value = '16',
+moddate = UNIX_TIMESTAMP()
+WHERE state_name = 'database_version'; 
diff --git a/src/sql/sqlite/updates/update_15_to_16.sql b/src/sql/sqlite/updates/update_15_to_16.sql
new file mode 100644
index 00000000..aa5d4646
--- /dev/null
+++ b/src/sql/sqlite/updates/update_15_to_16.sql
@@ -0,0 +1,7 @@
+-- No changes required. It was only an issue with mysql.
+
+-- Update the database version, and set date of update
+UPDATE mana_world_states
+   SET value      = '16',
+       moddate    = strftime('%s','now')
+   WHERE state_name = 'database_version';