Mercurial > eagle-eye

comparison ikariam.sql @ 118:d7a17dc6dc27

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
removed unused files and update the sql schema.
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Thu, 30 Oct 2008 15:08:20 +0800
parents 839d8ad81cde
children dbefe10550cb
comparison
equal deleted inserted replaced
115:34ebf346f5b9 118:d7a17dc6dc27
4 citylevel INTEGER, 4 citylevel INTEGER,
5 cityname TEXT, 5 cityname TEXT,
6 user INTEGER, 6 user INTEGER,
7 owner TEXT, 7 owner TEXT,
8 ally TEXT, 8 ally TEXT,
9 island INTEGER, "status" CHAR, "time" INTEGER); 9 island INTEGER, "status" CHAR, "time" INTEGER, "allyId" INTEGER);
10 CREATE TABLE "island" ( 10 CREATE TABLE "island" (
11 id BIGINT PRIMARY KEY UNIQUE, 11 id BIGINT PRIMARY KEY UNIQUE,
12 x INTEGER, 12 x INTEGER,
13 y INTEGER, 13 y INTEGER,
14 name TEXT, 14 name TEXT,