Mercurial > eagle-eye

diff ikariam.sql @ 8:e4b3168d0319

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
implemented sheep and enemy scripts.
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Wed, 08 Oct 2008 04:23:01 +0800
parents dbb97c4265ba
children 0644b53fd3af
line wrap: on
line diff
--- a/ikariam.sql	Wed Oct 08 02:50:19 2008 +0800
+++ b/ikariam.sql	Wed Oct 08 04:23:01 2008 +0800
@@ -1,11 +1,12 @@
 CREATE TABLE cities (
- cityId BIGINT PRIMARY KEY UNIQUE,
+ cityId INTEGER PRIMARY KEY UNIQUE,
  citylevel INTEGER,
  cityname TEXT,
- ownerId BIGINT,
+ user INTEGER,
  owner TEXT,
- ally TEXT, "island" INTEGER);
-CREATE TABLE islands (
+ ally TEXT,
+ island INTEGER);
+CREATE TABLE "island" (
  id BIGINT PRIMARY KEY UNIQUE,
  x INTEGER,
  y INTEGER,
@@ -13,8 +14,7 @@
  tradegood INTEGER,
  wonder INTEGER,
  people INTEGER);
-
-CREATE TABLE users (
+CREATE TABLE "user" (
   id INTEGER PRIMARY KEY UNIQUE,
   name VARCHAR,
   ally VARCHAR,
@@ -26,4 +26,3 @@
   research_score_secondary INTEGER,
   army_score_main INTEGER,
   trader_score_secondary INTEGER);
-