summaryrefslogtreecommitdiffstats
path: root/src/sql/sqlite
diff options
context:
space:
mode:
Diffstat (limited to 'src/sql/sqlite')
-rw-r--r--src/sql/sqlite/updates/update_11_to_12.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/src/sql/sqlite/updates/update_11_to_12.sql b/src/sql/sqlite/updates/update_11_to_12.sql
new file mode 100644
index 0000000..921bcf8
--- /dev/null
+++ b/src/sql/sqlite/updates/update_11_to_12.sql
@@ -0,0 +1,10 @@
+--
+-- SQLite - update 11 to 12 doesn't affect Sqlite,
+-- so we only change the database version number.
+--
+
+-- update the database version, and set date of update
+UPDATE mana_world_states
+ SET value = '12',
+ moddate = strftime('%s','now')
+ WHERE state_name = 'database_version';