diff options
| author | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2011-11-01 04:13:56 +0100 |
|---|---|---|
| committer | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2011-11-01 04:13:56 +0100 |
| commit | fba5a19e5885e3f4ddca2c249a96fbbe24c846b8 (patch) | |
| tree | 3d0ca109837c444aa75f5021d8b45545cfd0b043 /src/sql | |
| parent | 22142fd2cc8dd262ca1202ffeb5f4ef714870c4c (diff) | |
| download | manaserv-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')
| -rw-r--r-- | src/sql/mysql/createTables.sql | 2 | ||||
| -rw-r--r-- | src/sql/mysql/updates/update_17_to_18.sql (renamed from src/sql/mysql/updates/update_14_to_15.sql) | 4 | ||||
| -rw-r--r-- | src/sql/sqlite/createTables.sql | 2 | ||||
| -rw-r--r-- | src/sql/sqlite/updates/update_17_to_18.sql (renamed from src/sql/sqlite/updates/update_14_to_15.sql) | 2 |
4 files changed, 5 insertions, 5 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index b75fc0e..dffbf8f 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 1036817..9614389 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'; 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'; |