Mercurial > eagle-eye

comparison ikariam.sql @ 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 34749e907405
children 839d8ad81cde
comparison
equal deleted inserted replaced
102:94c9cde99e19 103:6804e9c3c589
14 name TEXT, 14 name TEXT,
15 tradegood INTEGER, 15 tradegood INTEGER,
16 wonder INTEGER, 16 wonder INTEGER,
17 people INTEGER, "time" INTEGER); 17 people INTEGER, "time" INTEGER);
18 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); 18 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);
19 CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY NOT NULL , "name" TEXT, "members" INTEGER, "url" TEXT, "time" DATETIME);
20 CREATE TABLE cities (
21 cityId INTEGER PRIMARY KEY UNIQUE,
22 citylevel INTEGER,
23 cityname TEXT,
24 user INTEGER,
25 owner TEXT,
26 ally TEXT,
27 island INTEGER, "status" CHAR, "time" INTEGER);
28 CREATE TABLE "island" (
29 id BIGINT PRIMARY KEY UNIQUE,
30 x INTEGER,
31 y INTEGER,
32 name TEXT,
33 tradegood INTEGER,
34 wonder INTEGER,
35 people INTEGER, "time" INTEGER);
36 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);
37 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);