Mercurial > eagle-eye

changeset 103:6804e9c3c589

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added ally and report table.
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Wed, 29 Oct 2008 12:34:18 +0800
parents 94c9cde99e19
children b369fe3c1992
files ikariam.sql
diffstat 1 files changed, 19 insertions(+), 0 deletions(-) [+]
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);