From 0b920a390e7ffbe77575f0c29c19ac286785929b Mon Sep 17 00:00:00 2001 From: Andreas Habel Date: Fri, 14 Nov 2008 18:28:51 +0100 Subject: 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. --- src/sql/sqlite/createTables.sql | 5 +++-- src/sql/sqlite/tmw.db | Bin 51200 -> 51200 bytes 2 files changed, 3 insertions(+), 2 deletions(-) (limited to 'src/sql/sqlite') diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index 253750a8..d22ba99b 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 ( diff --git a/src/sql/sqlite/tmw.db b/src/sql/sqlite/tmw.db index 93ae76d5..6e2da247 100644 Binary files a/src/sql/sqlite/tmw.db and b/src/sql/sqlite/tmw.db differ -- cgit v1.2.3-60-g2f50