From dc409b9cb6e92fd9ff9ef18ab2ca825bd247b419 Mon Sep 17 00:00:00 2001 From: Darkelarious Date: Sun, 8 Nov 2015 22:29:50 +0100 Subject: Access ciphers and games through database instead of keeping them in memory --- data/database/tables-SQLite.sql | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'data/database/tables-SQLite.sql') 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 +); -- cgit v1.2.3