2 CREATE TABLE IF NOT EXISTS "accounts" (
4 "username" text UNIQUE,
8 CREATE TABLE IF NOT EXISTS "cities" (
24 "soldiers" int after population,
27 "special_attacker_trainer" int,
28 "special_defender_trainer" int,
31 CREATE TABLE IF NOT EXISTS "locations" (
33 "city_id" text unique,
37 CREATE TABLE IF NOT EXISTS "ticks" (
41 CREATE TABLE IF NOT EXISTS "sessions" (
46 CREATE TABLE IF NOT EXISTS "build_queues" (
55 CREATE TABLE IF NOT EXISTS "unit_training_queue" (
64 CREATE TABLE IF NOT EXISTS "buildings" (
66 "display" text UNIQUE,
74 CREATE TABLE IF NOT EXISTS "units" (
87 CREATE TABLE IF NOT EXISTS "army_queue" (
101 CREATE TABLE IF NOT EXISTS "mail" (
112 INSERT INTO "accounts" VALUES ('-','Advisor','xos');
113 INSERT INTO "locations" VALUES (1, '-', -1, -1);
114 INSERT INTO "buildings" VALUES ('farms','Farms',20,0,40,1,14);
115 INSERT INTO "buildings" VALUES ('barracks','Barracks',40,10,60,1,16);
116 INSERT INTO "buildings" VALUES ('special_attacker_trainer','Sp. Attacker Trainer',80,40,100,2,20);
117 INSERT INTO "buildings" VALUES ('special_defender_trainer','Sp. Defender Trainer',100,60,80,2,20);
118 INSERT INTO "units" VALUES ('soldiers','Soldiers',2,1,1,0,0,0,2,2.1,1);
119 INSERT INTO "units" VALUES ('attackers','Attackers',5,2,0,1,0,0,3,4,1);
120 INSERT INTO "units" VALUES ('defenders','Defenders',4,2,0,1,0,0,5,1,4);
121 INSERT INTO "units" VALUES ('sp_attackers','Sp. Attacker',9,4,0,0,1,0,7,7,3);
122 INSERT INTO "units" VALUES ('sp_defenders','Sp. Defender',11,5,0,0,0,1,10,2,9);