--- a/ikariam.sql	Fri Oct 17 01:27:10 2008 +0800
+++ b/ikariam.sql	Fri Oct 17 01:33:52 2008 +0800
@@ -5,7 +5,7 @@
  user INTEGER,
  owner TEXT,
  ally TEXT,
- island INTEGER);
+ island INTEGER, "status" CHAR, "time" INTEGER);
 CREATE TABLE "island" (
  id BIGINT PRIMARY KEY UNIQUE,
  x INTEGER,
@@ -13,16 +13,5 @@
  name TEXT,
  tradegood INTEGER,
  wonder INTEGER,
- people INTEGER);
-CREATE TABLE "user" (
-  id INTEGER PRIMARY KEY UNIQUE,
-  name VARCHAR,
-  ally VARCHAR,
-  allyId INTEGER,
-  score INTEGER,
-  building_score_main INTEGER,
-  building_score_secondary INTEGER,
-  research_score_main INTEGER,
-  research_score_secondary INTEGER,
-  army_score_main INTEGER,
-  trader_score_secondary INTEGER);
+ people INTEGER, "time" INTEGER);
+CREATE TABLE "user" ("id" INTEGER PRIMARY KEY ,"name" VARCHAR,"ally" VARCHAR,"allyId" INTEGER,"score" INTEGER,"building_score_main" INTEGER,"building_score_secondary" INTEGER,"research_score_main" INTEGER,"research_score_secondary" INTEGER,"army_score_main" INTEGER,"trader_score_secondary" INTEGER, "time" INTEGER);