summaryrefslogtreecommitdiff
path: root/src/sql/mysql
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/mysql
parent22142fd2cc8dd262ca1202ffeb5f4ef714870c4c (diff)
downloadmanaserv-fba5a19e5885e3f4ddca2c249a96fbbe24c846b8.tar.gz
manaserv-fba5a19e5885e3f4ddca2c249a96fbbe24c846b8.tar.bz2
manaserv-fba5a19e5885e3f4ddca2c249a96fbbe24c846b8.tar.xz
manaserv-fba5a19e5885e3f4ddca2c249a96fbbe24c846b8.zip
Renamed the db update 15 to 18 as requested by Bjorn.
Diffstat (limited to 'src/sql/mysql')
-rw-r--r--src/sql/mysql/createTables.sql2
-rw-r--r--src/sql/mysql/updates/update_17_to_18.sql (renamed from src/sql/mysql/updates/update_14_to_15.sql)4
2 files changed, 3 insertions, 3 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index b75fc0ed..dffbf8f0 100644
--- a/src/sql/mysql/createTables.sql
+++ b/src/sql/mysql/createTables.sql
@@ -437,7 +437,7 @@ AUTO_INCREMENT=0 ;
INSERT INTO mana_world_states VALUES('accountserver_startup',NULL,NULL, NOW());
INSERT INTO mana_world_states VALUES('accountserver_version',NULL,NULL, NOW());
-INSERT INTO mana_world_states VALUES('database_version', NULL,'17', NOW());
+INSERT INTO mana_world_states VALUES('database_version', NULL,'18', NOW());
-- all known transaction codes
diff --git a/src/sql/mysql/updates/update_14_to_15.sql b/src/sql/mysql/updates/update_17_to_18.sql
index 1036817b..9614389c 100644
--- a/src/sql/mysql/updates/update_14_to_15.sql
+++ b/src/sql/mysql/updates/update_17_to_18.sql
@@ -17,6 +17,6 @@ DEFAULT CHARSET=utf8;
-- Update database version.
UPDATE mana_world_states
-SET value = '15',
+SET value = '18',
moddate = UNIX_TIMESTAMP()
-WHERE state_name = 'database_version';
+WHERE state_name = 'database_version';