diff options
Diffstat (limited to 'src/sql')
-rw-r--r-- | src/sql/mysql/createTables.sql | 2 | ||||
-rw-r--r-- | src/sql/postgresql/createTables.sql | 7 | ||||
-rw-r--r-- | src/sql/sqlite/createTables.sql | 2 |
3 files changed, 5 insertions, 6 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index 07f3c67d..4917ef47 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',-1,'0', NOW()); INSERT INTO mana_world_states VALUES('accountserver_version',-1,'0', NOW()); -INSERT INTO mana_world_states VALUES('database_version', -1,'19', NOW()); +INSERT INTO mana_world_states VALUES('database_version', -1,'20', NOW()); -- all known transaction codes diff --git a/src/sql/postgresql/createTables.sql b/src/sql/postgresql/createTables.sql index 53526dc3..a3d675ce 100644 --- a/src/sql/postgresql/createTables.sql +++ b/src/sql/postgresql/createTables.sql @@ -117,7 +117,6 @@ CREATE TABLE mana_world_states PRIMARY KEY (`state_name`, `map_id`) ); -INSERT INTO "mana_world_states" VALUES('accountserver_startup',NULL,NULL,1221633910); -INSERT INTO "mana_world_states" VALUES('accountserver_version',NULL,NULL,1221633910); - - +INSERT INTO "mana_world_states" VALUES('accountserver_startup',-1,'0',1221633910); +INSERT INTO "mana_world_states" VALUES('accountserver_version',-1,'0',1221633910); +INSERT INTO "mana_world_states" VALUES('database_version',-1,'20',1221633910); diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index 1d222442..b286467e 100644 --- a/src/sql/sqlite/createTables.sql +++ b/src/sql/sqlite/createTables.sql @@ -421,7 +421,7 @@ AS INSERT INTO mana_world_states VALUES('accountserver_startup',-1,'0', strftime('%s','now')); INSERT INTO mana_world_states VALUES('accountserver_version',-1,'0', strftime('%s','now')); -INSERT INTO mana_world_states VALUES('database_version', -1,'19', strftime('%s','now')); +INSERT INTO mana_world_states VALUES('database_version', -1,'20', strftime('%s','now')); -- all known transaction codes |