aboutsummaryrefslogtreecommitdiff
path: root/data/database/tables-SQLite.sql
diff options
context:
space:
mode:
Diffstat (limited to 'data/database/tables-SQLite.sql')
-rwxr-xr-xdata/database/tables-SQLite.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/data/database/tables-SQLite.sql b/data/database/tables-SQLite.sql
index cd904ed..7d68786 100755
--- a/data/database/tables-SQLite.sql
+++ b/data/database/tables-SQLite.sql
@@ -24,3 +24,12 @@ CREATE TABLE pending(
enctype INTEGER NOT NULL DEFAULT 0,
added timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP
);
+
+CREATE TABLE games(
+ gamename VARCHAR(50) NOT NULL,
+ cipher VARCHAR(10) NOT NULL DEFAULT ' ',
+ description VARCHAR(200) NOT NULL DEFAULT ' ',
+ default_qport INTEGER NOT NULL DEFAULT 0,
+ num_uplink INTEGER NOT NULL DEFAULT 0,
+ num_total INTEGER NOT NULL DEFAULT 0
+);