summaryrefslogtreecommitdiffstats
path: root/src/sql/mysql/updates
diff options
context:
space:
mode:
authorYohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>2011-09-08 23:59:59 +0200
committerYohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>2011-09-08 23:59:59 +0200
commit40a31c52aebc19221cc9da8a0f764d21e672937b (patch)
tree9b9f9df81828f3674838c3f01154e1fa194abee6 /src/sql/mysql/updates
parentfbd91b3538eb486df428f48fb9c47b7c5596ec73 (diff)
parent082a88a7ac74e52fd5d239e1e974731a9a7b3fdc (diff)
downloadmanaserv-40a31c52aebc19221cc9da8a0f764d21e672937b.tar.gz
manaserv-40a31c52aebc19221cc9da8a0f764d21e672937b.tar.xz
manaserv-40a31c52aebc19221cc9da8a0f764d21e672937b.zip
Merge github.com:mana/manaserv
Conflicts: src/account-server/storage.cpp src/game-server/mapreader.cpp src/sql/mysql/createTables.sql
Diffstat (limited to 'src/sql/mysql/updates')
-rw-r--r--src/sql/mysql/updates/update_15_to_16.sql7
1 files changed, 7 insertions, 0 deletions
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';