From 6ba4653e1c0e7ee2315f57d0bb1363ab03db4496 Mon Sep 17 00:00:00 2001 From: Thorbjørn Lindeijer Date: Thu, 15 Mar 2012 22:13:30 +0100 Subject: Fixed the version in the createTables.sql scripts Forgot this in 1afbfb7e5fb5c133924ed8d376c6064575fc1c36. Reviewed-by: Bertram, Ablu. --- src/sql/mysql/createTables.sql | 2 +- src/sql/postgresql/createTables.sql | 7 +++---- src/sql/sqlite/createTables.sql | 2 +- 3 files changed, 5 insertions(+), 6 deletions(-) (limited to 'src') 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 -- cgit v1.2.3-70-g09d2