Mercurial > eagle-eye
annotate ikariam.sql @ 117:5a66fea952fe
implemented a dirty hack to fixed the stupid highscore search function.
author | "Rex Tsai <chihchun@kalug.linux.org.tw>" |
---|---|
date | Thu, 30 Oct 2008 15:00:17 +0800 |
parents | 839d8ad81cde |
children | d7a17dc6dc27 |
rev | line source |
---|---|
103
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
1 CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY NOT NULL , "name" TEXT, "members" INTEGER, "url" TEXT, "time" DATETIME); |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
2 CREATE TABLE cities ( |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
3 cityId INTEGER PRIMARY KEY UNIQUE, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
4 citylevel INTEGER, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
5 cityname TEXT, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
6 user INTEGER, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
7 owner TEXT, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
8 ally TEXT, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
9 island INTEGER, "status" CHAR, "time" INTEGER); |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
10 CREATE TABLE "island" ( |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
11 id BIGINT PRIMARY KEY UNIQUE, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
12 x INTEGER, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
13 y INTEGER, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
14 name TEXT, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
15 tradegood INTEGER, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
16 wonder INTEGER, |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
17 people INTEGER, "time" INTEGER); |
6804e9c3c589
added ally and report table.
"Rex Tsai <chihchun@kalug.linux.org.tw>"
parents:
98
diff
changeset
|
18 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
|
19 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); |