summaryrefslogtreecommitdiffstats
path: root/src/sql/sqlite
diff options
context:
space:
mode:
authorYohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>2011-11-01 04:13:56 +0100
committerYohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer>2011-11-01 04:13:56 +0100
commitfba5a19e5885e3f4ddca2c249a96fbbe24c846b8 (patch)
tree3d0ca109837c444aa75f5021d8b45545cfd0b043 /src/sql/sqlite
parent22142fd2cc8dd262ca1202ffeb5f4ef714870c4c (diff)
downloadmanaserv-fba5a19e5885e3f4ddca2c249a96fbbe24c846b8.tar.gz
manaserv-fba5a19e5885e3f4ddca2c249a96fbbe24c846b8.tar.xz
manaserv-fba5a19e5885e3f4ddca2c249a96fbbe24c846b8.zip
Renamed the db update 15 to 18 as requested by Bjorn.
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';