Updates for round 100

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

diff --git a/database/tables/races.sql b/database/tables/races.sql
new file mode 100644 (file)
index 0000000..802e3ed
--- /dev/null
+++ b/database/tables/races.sql
@@ -0,0 +1,12 @@
+CREATE TABLE IF NOT EXISTS races (
+       race_id INTEGER UNIQUE NOT NULL,
+       race TEXT PRIMARY KEY,
+       race_name TEXT UNIQUE NOT NULL,
+       max_stealth INTEGER NOT NULL,
+       stealth_growth INTEGER NOT NULL,
+       base_construction INTEGER NOT NULL,
+       base_research INTEGER NOT NULL,
+       production_time INTEGER NOT NULL,
+       salvage INTEGER NOT NULL,
+       universe_trade_tax INTEGER NOT NULL
+);