From 0b920a390e7ffbe77575f0c29c19ac286785929b Mon Sep 17 00:00:00 2001
From: Andreas Habel <mail@exceptionfault.de>
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 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'src/sql/sqlite/createTables.sql')

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
 (
-- 
cgit 

