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/updates/update_15_to_16.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 src/sql/mysql/updates/update_15_to_16.sql

(limited to 'src/sql/mysql/updates')

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 0000000..df94f99
--- /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'; 
-- 
cgit