Mercurial > eagle-eye

comparison ikariam.sql @ 109:839d8ad81cde

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
removed duplicated sql statement.
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Wed, 29 Oct 2008 16:03:43 +0800
parents 6804e9c3c589
children d7a17dc6dc27
comparison
equal deleted inserted replaced
108:d3bece9b06b2 109:839d8ad81cde
1 CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY NOT NULL , "name" TEXT, "members" INTEGER, "url" TEXT, "time" DATETIME);
2 CREATE TABLE cities (
3 cityId INTEGER PRIMARY KEY UNIQUE,
4 citylevel INTEGER,
5 cityname TEXT,
6 user INTEGER,
7 owner TEXT,
8 ally TEXT,
9 island INTEGER, "status" CHAR, "time" INTEGER);
10 CREATE TABLE "island" (
11 id BIGINT PRIMARY KEY UNIQUE,
12 x INTEGER,
13 y INTEGER,
14 name TEXT,
15 tradegood INTEGER,
16 wonder 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);
19 CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY NOT NULL , "name" TEXT, "members" INTEGER, "url" TEXT, "time" DATETIME); 1 CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY NOT NULL , "name" TEXT, "members" INTEGER, "url" TEXT, "time" DATETIME);
20 CREATE TABLE cities ( 2 CREATE TABLE cities (
21 cityId INTEGER PRIMARY KEY UNIQUE, 3 cityId INTEGER PRIMARY KEY UNIQUE,
22 citylevel INTEGER, 4 citylevel INTEGER,
23 cityname TEXT, 5 cityname TEXT,