summaryrefslogtreecommitdiffstats
path: root/src/sql/sqlite
diff options
context:
space:
mode:
Diffstat (limited to 'src/sql/sqlite')
-rw-r--r--src/sql/sqlite/createTables.sql2
-rw-r--r--src/sql/sqlite/updates/update_17_to_18.sql (renamed from src/sql/sqlite/updates/update_14_to_15.sql)2
2 files changed, 2 insertions, 2 deletions
diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql
index 2d7360d..b2d94fb 100644
--- a/src/sql/sqlite/createTables.sql
+++ b/src/sql/sqlite/createTables.sql
@@ -419,7 +419,7 @@ AS
INSERT INTO mana_world_states VALUES('accountserver_startup',NULL,NULL, strftime('%s','now'));
INSERT INTO mana_world_states VALUES('accountserver_version',NULL,NULL, strftime('%s','now'));
-INSERT INTO mana_world_states VALUES('database_version', NULL,'17', strftime('%s','now'));
+INSERT INTO mana_world_states VALUES('database_version', NULL,'18', strftime('%s','now'));
-- all known transaction codes
diff --git a/src/sql/sqlite/updates/update_14_to_15.sql b/src/sql/sqlite/updates/update_17_to_18.sql
index 777764d..3fa75c6 100644
--- a/src/sql/sqlite/updates/update_14_to_15.sql
+++ b/src/sql/sqlite/updates/update_17_to_18.sql
@@ -16,6 +16,6 @@ CREATE TABLE mana_char_equips
-- Update the database version, and set date of update
UPDATE mana_world_states
- SET value = '15',
+ SET value = '18',
moddate = strftime('%s','now')
WHERE state_name = 'database_version';