Mercurial > eagle-eye
diff ikariam.sql @ 103:6804e9c3c589
added ally and report table.
| author | "Rex Tsai <chihchun@kalug.linux.org.tw>" |
|---|---|
| date | Wed, 29 Oct 2008 12:34:18 +0800 |
| parents | 34749e907405 |
| children | 839d8ad81cde |
line wrap: on
line diff
--- 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);