Mercurial > eagle-eye

comparison ikariam.sql @ 42:0644b53fd3af

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
updated documents
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Fri, 17 Oct 2008 01:33:52 +0800
parents e4b3168d0319
children 34749e907405
comparison
equal deleted inserted replaced
41:5849b6fdc76c 42:0644b53fd3af
3 citylevel INTEGER, 3 citylevel INTEGER,
4 cityname TEXT, 4 cityname TEXT,
5 user INTEGER, 5 user INTEGER,
6 owner TEXT, 6 owner TEXT,
7 ally TEXT, 7 ally TEXT,
8 island INTEGER); 8 island INTEGER, "status" CHAR, "time" INTEGER);
9 CREATE TABLE "island" ( 9 CREATE TABLE "island" (
10 id BIGINT PRIMARY KEY UNIQUE, 10 id BIGINT PRIMARY KEY UNIQUE,
11 x INTEGER, 11 x INTEGER,
12 y INTEGER, 12 y INTEGER,
13 name TEXT, 13 name TEXT,
14 tradegood INTEGER, 14 tradegood INTEGER,
15 wonder INTEGER, 15 wonder INTEGER,
16 people INTEGER); 16 people INTEGER, "time" INTEGER);
17 CREATE TABLE "user" ( 17 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 id INTEGER PRIMARY KEY UNIQUE,
19 name VARCHAR,
20 ally VARCHAR,
21 allyId INTEGER,
22 score INTEGER,
23 building_score_main INTEGER,
24 building_score_secondary INTEGER,
25 research_score_main INTEGER,
26 research_score_secondary INTEGER,
27 army_score_main INTEGER,
28 trader_score_secondary INTEGER);