X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Ftables%2Fgovernments.sql;fp=database%2Ftables%2Fgovernments.sql;h=584e2d360129b549a82cce48367fa859b65a4fda;hp=0000000000000000000000000000000000000000;hb=3dc80cedd5deba53a4082992de317fbc3acf805c;hpb=23e133163ef06e0afc2000152df31c966f4929b2

diff --git a/database/tables/governments.sql b/database/tables/governments.sql
new file mode 100644
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
+);