dump.sql

   1 BEGIN TRANSACTION;
   2 CREATE TABLE IF NOT EXISTS "accounts" (
   3         "id"    text,
   4         "username"      text UNIQUE,
   5         "password"      text,
   6         PRIMARY KEY("id")
   7 );
   8 CREATE TABLE IF NOT EXISTS "cities" (
   9         "id"    string,
  10         "owner" string,
  11   "icon" string,
  12         "totalSpace"    int,
  13         "usedSpace"     int,
  14         "credits"       int,
  15         "alloys"        int,
  16         "energy"        int,
  17         "food"  int,
  18         "population"    int,
  19         "soliders"      int,
  20         "attackers"     int,
  21         "defenders"     int,
  22         "sp_attackers"  int,
  23         "sp_defenders"  int,
  24         "soldiers"      int after population,
  25         "farms" int,
  26         "barracks"      int,
  27         "special_attacker_trainer"      int,
  28         "special_defender_trainer"      int,
  29         PRIMARY KEY("id")
  30 );
  31 CREATE TABLE IF NOT EXISTS "locations" (
  32         "sector_id"             int,
  33         "city_id"               text unique,
  34         "location_x"    int,
  35         "location_y"    int
  36 );
  37 CREATE TABLE IF NOT EXISTS "ticks" (
  38         "current_tick"  int,
  39         "last_tick_at"  int
  40 );
  41 CREATE TABLE IF NOT EXISTS "sessions" (
  42         "id"    text,
  43         "account_id"    TEXT,
  44         PRIMARY KEY("id")
  45 );
  46 CREATE TABLE IF NOT EXISTS "build_queues" (
  47         "id"    text,
  48         "building_type" text,
  49         "owner" text,
  50         "created"       int,
  51         "due"   int,
  52         "amount"        int,
  53         PRIMARY KEY("id")
  54 );
  55 CREATE TABLE IF NOT EXISTS "unit_training_queue" (
  56         "id"    string,
  57         "unit_type"     text,
  58         "owner" text,
  59         "created"       int,
  60         "due"   int,
  61         "amount"        int,
  62         PRIMARY KEY("id")
  63 );
  64 CREATE TABLE IF NOT EXISTS "buildings" (
  65         "slug"  text,
  66         "display"       text UNIQUE,
  67         "credits"       int,
  68         "alloys"        int,
  69         "energy"        int,
  70         "land"  int,
  71         "time"  int,
  72         PRIMARY KEY("slug")
  73 );
  74 CREATE TABLE IF NOT EXISTS "units" (
  75         "slug"  ,
  76         "display"       ,
  77         "credits"       ,
  78         "food"  ,
  79         "population"    ,
  80         "soldiers"      ,
  81         "attackers"     ,
  82         "defenders"     ,
  83         "time"  ,
  84         "attack"        int,
  85         "defence"       int
  86 );
  87 CREATE TABLE IF NOT EXISTS "army_queue" (
  88         "id"    text,
  89         "owner" text,
  90         "your_city"     text,
  91         "created"       int,
  92         "due"   int,
  93         "soldiers"      int,
  94         "attackers"     int,
  95         "defenders"     int,
  96         "sp_attackers"  int,
  97         "sp_defenders"  int,
  98         "attacked_city" text,
  99         PRIMARY KEY("id")
 100 );
 101 CREATE TABLE IF NOT EXISTS "mail" (
 102         "id"    text,
 103         "to_account"    text,
 104         "from_account"  text,
 105         "type"  text,
 106         "sent_at"       int,
 107         "read_at"       int,
 108         "subject"       text,
 109         "message"       text,
 110         PRIMARY KEY("id")
 111 );
 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);