annotate ikariam.sql @ 283:34fd5bcd4cf8

add some explan in README
author billy3321@f3svr.f3.csu.edu.tw.f3.csu.edu.tw
date Fri, 05 Dec 2008 15:39:49 +0800
parents fd6c3660cd38
children 071863adc14c
rev   line source
244
fd6c3660cd38 change the datatype of score in ally
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents: 240
diff changeset
1 CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY NOT NULL ,"name" TEXT,"members" INTEGER,"url" TEXT,"time" DATETIME,"score" BIGINT);
fd6c3660cd38 change the datatype of score in ally
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents: 240
diff changeset
2 CREATE TABLE cities ( cityId INTEGER PRIMARY KEY UNIQUE, citylevel INTEGER, cityname TEXT, user INTEGER, owner TEXT, ally TEXT, island INTEGER, "status" CHAR, "time" INTEGER, "allyId" INTEGER);
130
dbefe10550cb refined sql format
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents: 118
diff changeset
3 CREATE TABLE "island" ( id BIGINT PRIMARY KEY UNIQUE, x INTEGER, y INTEGER, name TEXT, tradegood INTEGER, wonder INTEGER, people INTEGER, "time" INTEGER);
103
6804e9c3c589 added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents: 98
diff changeset
4 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);
6804e9c3c589 added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents: 98
diff changeset
5 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);