Mercurial > eagle-eye

comparison ikariam.sql @ 5:dbb97c4265ba

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
implemented the scores search tool
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Wed, 08 Oct 2008 01:51:28 +0800
parents
children e4b3168d0319
comparison
equal deleted inserted replaced
4:c0287e8ff168 5:dbb97c4265ba
1 CREATE TABLE cities (
2 cityId BIGINT PRIMARY KEY UNIQUE,
3 citylevel INTEGER,
4 cityname TEXT,
5 ownerId BIGINT,
6 owner TEXT,
7 ally TEXT, "island" INTEGER);
8 CREATE TABLE islands (
9 id BIGINT PRIMARY KEY UNIQUE,
10 x INTEGER,
11 y INTEGER,
12 name TEXT,
13 tradegood INTEGER,
14 wonder INTEGER,
15 people INTEGER);
16
17 CREATE TABLE users (
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);
29