Mercurial > eagle-eye
diff ikariam.sql @ 5:dbb97c4265ba
implemented the scores search tool
author | "Rex Tsai <chihchun@kalug.linux.org.tw>" |
---|---|
date | Wed, 08 Oct 2008 01:51:28 +0800 |
parents | |
children | e4b3168d0319 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/ikariam.sql Wed Oct 08 01:51:28 2008 +0800 @@ -0,0 +1,29 @@ +CREATE TABLE cities ( + cityId BIGINT PRIMARY KEY UNIQUE, + citylevel INTEGER, + cityname TEXT, + ownerId BIGINT, + owner TEXT, + ally TEXT, "island" INTEGER); +CREATE TABLE islands ( + id BIGINT PRIMARY KEY UNIQUE, + x INTEGER, + y INTEGER, + name TEXT, + tradegood INTEGER, + wonder INTEGER, + people INTEGER); + +CREATE TABLE users ( + 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); +