aboutsummaryrefslogtreecommitdiff
path: root/data/database/tables-mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'data/database/tables-mysql.sql')
-rwxr-xr-xdata/database/tables-mysql.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/data/database/tables-mysql.sql b/data/database/tables-mysql.sql
index 9c1d2fc..c460b1b 100755
--- a/data/database/tables-mysql.sql
+++ b/data/database/tables-mysql.sql
@@ -26,3 +26,12 @@ CREATE TABLE pending(
added TIMESTAMP NOT NULL DEFAULT NOW(),
PRIMARY KEY (id)
);
+
+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
+);