comparison ikariam.sql @ 98:34749e907405

we now scan for ally
author "Rex Tsai <chihchun@kalug.linux.org.tw>"
date Wed, 29 Oct 2008 02:43:04 +0800
parents 0644b53fd3af
children 6804e9c3c589
comparison
equal deleted inserted replaced
97:5f9bb3042d0c 98:34749e907405
1 CREATE TABLE "ally" ("id" INTEGER PRIMARY KEY NOT NULL , "name" TEXT, "members" INTEGER, "url" TEXT, "time" DATETIME);
1 CREATE TABLE cities ( 2 CREATE TABLE cities (
2 cityId INTEGER PRIMARY KEY UNIQUE, 3 cityId INTEGER PRIMARY KEY UNIQUE,
3 citylevel INTEGER, 4 citylevel INTEGER,
4 cityname TEXT, 5 cityname TEXT,
5 user INTEGER, 6 user INTEGER,