From 7078651cd26d4d80c8259563fc45b46da523eff7 Mon Sep 17 00:00:00 2001 From: Erik Schilling Date: Thu, 15 Mar 2012 18:55:11 +0800 Subject: Fixed createTables scripts --- src/sql/mysql/createTables.sql | 6 +++--- src/sql/sqlite/createTables.sql | 6 +++--- 2 files changed, 6 insertions(+), 6 deletions(-) (limited to 'src/sql') diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index dc405d9..07f3c67 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -435,9 +435,9 @@ AUTO_INCREMENT=0 ; -- initial world states and database version -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,'19', NOW()); +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()); -- all known transaction codes diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index a5822f3..1d22244 100644 --- a/src/sql/sqlite/createTables.sql +++ b/src/sql/sqlite/createTables.sql @@ -419,9 +419,9 @@ AS -- initial world states and database version -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,'19', strftime('%s','now')); +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')); -- all known transaction codes -- cgit