diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/sql/mysql/createTables.sql | 6 | ||||
| -rw-r--r-- | src/sql/sqlite/createTables.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index dc405d95..07f3c67d 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 a5822f37..1d222442 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 |