view ikariam.sql @ 107:554bdd49c703

we should also count the force which is coming back
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Wed, 29 Oct 2008 15:21:15 +0800
parents 6804e9c3c589
children 839d8ad81cde
line wrap: on
line source

CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY  NOT NULL , "name" TEXT, "members" INTEGER, "url" TEXT, "time" DATETIME);
CREATE TABLE cities (
 cityId INTEGER PRIMARY KEY UNIQUE,
 citylevel INTEGER,
 cityname TEXT,
 user INTEGER,
 owner TEXT,
 ally TEXT,
 island INTEGER, "status" CHAR, "time" INTEGER);
CREATE TABLE "island" (
 id BIGINT PRIMARY KEY UNIQUE,
 x INTEGER,
 y INTEGER,
 name TEXT,
 tradegood INTEGER,
 wonder INTEGER,
 people INTEGER, "time" INTEGER);
CREATE TABLE "user" ("id" INTEGER PRIMARY KEY ,"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, "time" INTEGER);
CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY  NOT NULL , "name" TEXT, "members" INTEGER, "url" TEXT, "time" DATETIME);
CREATE TABLE cities (
 cityId INTEGER PRIMARY KEY UNIQUE,
 citylevel INTEGER,
 cityname TEXT,
 user INTEGER,
 owner TEXT,
 ally TEXT,
 island INTEGER, "status" CHAR, "time" INTEGER);
CREATE TABLE "island" (
 id BIGINT PRIMARY KEY UNIQUE,
 x INTEGER,
 y INTEGER,
 name TEXT,
 tradegood INTEGER,
 wonder INTEGER,
 people INTEGER, "time" INTEGER);
CREATE TABLE "report" ("id" INTEGER PRIMARY KEY  NOT NULL , "cityLevel" INTEGER, "wallLevel" INTEGER, "attacker" TEXT, "defender" TEXT, "winner" TEXT, "targetCity" TEXT, "island" INTEGER NOT NULL , "city" INTEGER NOT NULL , "gold" INTEGER DEFAULT 0, "wood" INTEGER DEFAULT 0, "crystal" INTEGER DEFAULT 0, "wine" INTEGER DEFAULT 0, "sulfur" INTEGER DEFAULT 0, "date" DATETIME, "time" DATETIME);
CREATE TABLE "user" ("id" INTEGER PRIMARY KEY ,"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, "time" INTEGER);