Mercurial > eagle-eye
view ikariam.sql @ 24:93d4e6ffe330
refined the SQL.
author | "Rex Tsai <chihchun@kalug.linux.org.tw>" |
---|---|
date | Fri, 10 Oct 2008 03:17:50 +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);