summaryrefslogtreecommitdiff
path: root/src/sql/sqlite
diff options
context:
space:
mode:
authorErik Schilling <ablu.erikschilling@googlemail.com>2011-09-02 18:49:14 +0800
committerErik Schilling <ablu.erikschilling@googlemail.com>2011-09-05 16:05:45 +0800
commit082a88a7ac74e52fd5d239e1e974731a9a7b3fdc (patch)
tree18bf6d79b1e840f3f103682aca8e22dbd9627aa7 /src/sql/sqlite
parent4a9de81c1911c747f9ecff695de58b12d0dc4a71 (diff)
downloadmanaserv-082a88a7ac74e52fd5d239e1e974731a9a7b3fdc.tar.gz
manaserv-082a88a7ac74e52fd5d239e1e974731a9a7b3fdc.tar.bz2
manaserv-082a88a7ac74e52fd5d239e1e974731a9a7b3fdc.tar.xz
manaserv-082a88a7ac74e52fd5d239e1e974731a9a7b3fdc.zip
Fixed size of mapid field in mysql database.
Resolves: Mana-Mantis: #388. Reviewed-by: Bertram.
Diffstat (limited to 'src/sql/sqlite')
-rw-r--r--src/sql/sqlite/updates/update_15_to_16.sql7
1 files changed, 7 insertions, 0 deletions
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';