Updates for round 100

[ndwebbie.git] / database / tables / governments.sql

diff --git a/database/tables/governments.sql b/database/tables/governments.sql
new file mode 100644 (file)
index 0000000..584e2d3
--- /dev/null
+++ b/database/tables/governments.sql
@@ -0,0 +1,11 @@
+CREATE TABLE IF NOT EXISTS governments (
+       gov TEXT PRIMARY KEY,
+       gov_name TEXT UNIQUE NOT NULL,
+       mining INTEGER NOT NULL DEFAULT 0,
+       research INTEGER NOT NULL DEFAULT 0,
+       construction INTEGER NOT NULL DEFAULT 0,
+       production_time INTEGER NOT NULL DEFAULT 0,
+       production_cost INTEGER NOT NULL DEFAULT 0,
+       alert INTEGER NOT NULL DEFAULT 0,
+       stealth INTEGER NOT NULL DEFAULT 0
+);