diff options
| author | Erik Schilling <ablu.erikschilling@googlemail.com> | 2012-03-15 18:55:11 +0800 |
|---|---|---|
| committer | Erik Schilling <ablu.erikschilling@googlemail.com> | 2012-03-15 18:58:32 +0800 |
| commit | 7078651cd26d4d80c8259563fc45b46da523eff7 (patch) | |
| tree | 7bedb2696df6758da7569f07128480401f62adb8 /src/sql | |
| parent | dffeb1fa216e67edf52590c59dd44cfc6958e087 (diff) | |
| download | manaserv-7078651cd26d4d80c8259563fc45b46da523eff7.tar.gz manaserv-7078651cd26d4d80c8259563fc45b46da523eff7.tar.xz manaserv-7078651cd26d4d80c8259563fc45b46da523eff7.zip | |
Fixed createTables scripts
Diffstat (limited to 'src/sql')
| -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 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 |