diff options
| author | Andreas Habel <mail@exceptionfault.de> | 2008-11-14 18:28:51 +0100 |
|---|---|---|
| committer | Andreas Habel <mail@exceptionfault.de> | 2008-11-14 18:28:51 +0100 |
| commit | 0b920a390e7ffbe77575f0c29c19ac286785929b (patch) | |
| tree | 5ecce4186e20267e239a6af8d4037b2c29bf0310 /src/sql/sqlite/createTables.sql | |
| parent | b5ef81d1bed0caa6fd71d63c9d6ae06e5fcd0d5e (diff) | |
| download | manaserv-0b920a390e7ffbe77575f0c29c19ac286785929b.tar.gz manaserv-0b920a390e7ffbe77575f0c29c19ac286785929b.tar.xz manaserv-0b920a390e7ffbe77575f0c29c19ac286785929b.zip | |
Added check for database version on startup of Accountserver.
The provided CreateTable.sql scripts store their versions inline of a database table. The account server checks this version number with its known
compatible version. If the numbers don't match, the account server raises an error and shuts down.
Diffstat (limited to 'src/sql/sqlite/createTables.sql')
| -rw-r--r-- | src/sql/sqlite/createTables.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index 253750a..d22ba99 100644 --- a/src/sql/sqlite/createTables.sql +++ b/src/sql/sqlite/createTables.sql @@ -140,8 +140,9 @@ CREATE TABLE tmw_world_states moddate INTEGER NOT NULL ); -INSERT INTO "tmw_world_states" VALUES('accountserver_startup',NULL,NULL,1221633910); -INSERT INTO "tmw_world_states" VALUES('accountserver_version',NULL,NULL,1221633910); +INSERT INTO tmw_world_states VALUES('accountserver_startup',NULL,NULL,1226042339); +INSERT INTO tmw_world_states VALUES('accountserver_version',NULL,NULL,1226042339); +INSERT INTO tmw_world_states VALUES('database_version', NULL,'1', 1226042339); CREATE TABLE tmw_auctions ( |