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