Mercurial > eagle-eye

comparison ikariam.sql @ 8:e4b3168d0319

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
implemented sheep and enemy scripts.
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Wed, 08 Oct 2008 04:23:01 +0800
parents dbb97c4265ba
children 0644b53fd3af
comparison
equal deleted inserted replaced
7:2040ccc95670 8:e4b3168d0319
1 CREATE TABLE cities ( 1 CREATE TABLE cities (
2 cityId BIGINT PRIMARY KEY UNIQUE, 2 cityId INTEGER PRIMARY KEY UNIQUE,
3 citylevel INTEGER, 3 citylevel INTEGER,
4 cityname TEXT, 4 cityname TEXT,
5 ownerId BIGINT, 5 user INTEGER,
6 owner TEXT, 6 owner TEXT,
7 ally TEXT, "island" INTEGER); 7 ally TEXT,
8 CREATE TABLE islands ( 8 island INTEGER);
9 CREATE TABLE "island" (
9 id BIGINT PRIMARY KEY UNIQUE, 10 id BIGINT PRIMARY KEY UNIQUE,
10 x INTEGER, 11 x INTEGER,
11 y INTEGER, 12 y INTEGER,
12 name TEXT, 13 name TEXT,
13 tradegood INTEGER, 14 tradegood INTEGER,
14 wonder INTEGER, 15 wonder INTEGER,
15 people INTEGER); 16 people INTEGER);
16 17 CREATE TABLE "user" (
17 CREATE TABLE users (
18 id INTEGER PRIMARY KEY UNIQUE, 18 id INTEGER PRIMARY KEY UNIQUE,
19 name VARCHAR, 19 name VARCHAR,
20 ally VARCHAR, 20 ally VARCHAR,
21 allyId INTEGER, 21 allyId INTEGER,
22 score INTEGER, 22 score INTEGER,
24 building_score_secondary INTEGER, 24 building_score_secondary INTEGER,
25 research_score_main INTEGER, 25 research_score_main INTEGER,
26 research_score_secondary INTEGER, 26 research_score_secondary INTEGER,
27 army_score_main INTEGER, 27 army_score_main INTEGER,
28 trader_score_secondary INTEGER); 28 trader_score_secondary INTEGER);
29