summaryrefslogtreecommitdiff
path: root/src/sql/mysql/updates/update_14_to_16.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/sql/mysql/updates/update_14_to_16.sql')
-rw-r--r--src/sql/mysql/updates/update_14_to_16.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/sql/mysql/updates/update_14_to_16.sql b/src/sql/mysql/updates/update_14_to_16.sql
new file mode 100644
index 00000000..df94f995
--- /dev/null
+++ b/src/sql/mysql/updates/update_14_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';