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);
+