From dc409b9cb6e92fd9ff9ef18ab2ca825bd247b419 Mon Sep 17 00:00:00 2001
From: Darkelarious <darkelarious@333networks.com>
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-mysql.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'data/database/tables-mysql.sql')

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
+);
-- 
cgit v1.2.3

