# HG changeset patch
# User "Rex Tsai <chihchun@kalug.linux.org.tw>"
# Date 1225254858 -28800
# Node ID 6804e9c3c589fb0105683faab0ca40028cd13f60
# Parent  94c9cde99e19b9d05ae8e13620395edcb1b845e3
added ally and report table.

diff -r 94c9cde99e19 -r 6804e9c3c589 ikariam.sql
--- a/ikariam.sql	Wed Oct 29 12:07:19 2008 +0800
+++ b/ikariam.sql	Wed Oct 29 12:34:18 2008 +0800
@@ -16,3 +16,22 @@
  wonder 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);
+CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY  NOT NULL , "name" TEXT, "members" INTEGER, "url" TEXT, "time" DATETIME);
+CREATE TABLE cities (
+ cityId INTEGER PRIMARY KEY UNIQUE,
+ citylevel INTEGER,
+ cityname TEXT,
+ user INTEGER,
+ owner TEXT,
+ ally TEXT,
+ island INTEGER, "status" CHAR, "time" INTEGER);
+CREATE TABLE "island" (
+ id BIGINT PRIMARY KEY UNIQUE,
+ x INTEGER,
+ y INTEGER,
+ name TEXT,
+ tradegood INTEGER,
+ wonder INTEGER,
+ people INTEGER, "time" INTEGER);
+CREATE TABLE "report" ("id" INTEGER PRIMARY KEY  NOT NULL , "cityLevel" INTEGER, "wallLevel" INTEGER, "attacker" TEXT, "defender" TEXT, "winner" TEXT, "targetCity" TEXT, "island" INTEGER NOT NULL , "city" INTEGER NOT NULL , "gold" INTEGER DEFAULT 0, "wood" INTEGER DEFAULT 0, "crystal" INTEGER DEFAULT 0, "wine" INTEGER DEFAULT 0, "sulfur" INTEGER DEFAULT 0, "date" DATETIME, "time" DATETIME);
+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);