diff options
| author | Thorbjørn Lindeijer <thorbjorn@lindeijer.nl> | 2012-03-15 22:13:30 +0100 |
|---|---|---|
| committer | Erik Schilling <ablu.erikschilling@googlemail.com> | 2012-03-16 15:54:18 +0100 |
| commit | 6ba4653e1c0e7ee2315f57d0bb1363ab03db4496 (patch) | |
| tree | b80cea1fa2aacdb6d3e2960ff14ed1e2a3d1e91b /src/sql | |
| parent | 7078651cd26d4d80c8259563fc45b46da523eff7 (diff) | |
| download | manaserv-6ba4653e1c0e7ee2315f57d0bb1363ab03db4496.tar.gz manaserv-6ba4653e1c0e7ee2315f57d0bb1363ab03db4496.tar.xz manaserv-6ba4653e1c0e7ee2315f57d0bb1363ab03db4496.zip | |
Fixed the version in the createTables.sql scripts
Forgot this in 1afbfb7e5fb5c133924ed8d376c6064575fc1c36.
Reviewed-by: Bertram, Ablu.
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 07f3c67..4917ef4 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 53526dc..a3d675c 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 1d22244..b286467 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 |