diff options
Diffstat (limited to 'data/database/tables-mysql.sql')
| -rwxr-xr-x | data/database/tables-mysql.sql | 9 |
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 +); |
