Mercurial > eagle-eye
view ikariam.sql @ 35:d9d4aedc9e03
change the file mode
author | "Rex Tsai <chihchun@kalug.linux.org.tw>" |
---|---|
date | Sat, 11 Oct 2008 05:20:03 +0800 |
parents | e4b3168d0319 |
children | 0644b53fd3af |
line wrap: on
line source
CREATE TABLE cities ( cityId INTEGER PRIMARY KEY UNIQUE, citylevel INTEGER, cityname TEXT, user INTEGER, owner TEXT, ally TEXT, island INTEGER); CREATE TABLE "island" ( id BIGINT PRIMARY KEY UNIQUE, x INTEGER, y INTEGER, name TEXT, tradegood INTEGER, wonder INTEGER, people INTEGER); CREATE TABLE "user" ( id INTEGER PRIMARY KEY UNIQUE, 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);