From 34a2c7390ea9662d33258d384e72fff1912343ff Mon Sep 17 00:00:00 2001
From: Darkelarious <darkelarious@333networks.com>
Date: Sat, 13 May 2017 14:18:28 +0200
Subject: revised synchronization methods, config settings and bug fixes

---
 data/sql/tables-mysql.sql | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

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

diff --git a/data/sql/tables-mysql.sql b/data/sql/tables-mysql.sql
index c460b1b..0bdfc02 100755
--- a/data/sql/tables-mysql.sql
+++ b/data/sql/tables-mysql.sql
@@ -1,8 +1,18 @@
+CREATE TABLE appletlist(
+  id              INTEGER          NOT NULL AUTO_INCREMENT,
+  ip              VARCHAR(15)      NOT NULL DEFAULT '0.0.0.0',
+  port            INTEGER          NOT NULL DEFAULT 0,
+  gamename        VARCHAR(50)      NOT NULL DEFAULT ' ',
+  added           timestamptz      NOT NULL DEFAULT NOW(),
+  updated         timestamptz      NOT NULL DEFAULT NOW(),
+  PRIMARY KEY (id)
+);
+
 CREATE TABLE serverlist(
   id              INTEGER          NOT NULL AUTO_INCREMENT,
   ip              VARCHAR(15)      NOT NULL DEFAULT '0.0.0.0',
   port            INTEGER          NOT NULL DEFAULT 0,
-  gamename        VARCHAR(100)     NOT NULL DEFAULT ' ',
+  gamename        VARCHAR(50)      NOT NULL DEFAULT ' ',
   gamever         VARCHAR(50)      NOT NULL DEFAULT ' ',
   hostname        VARCHAR(100)     NOT NULL DEFAULT ' ',
   hostport        INTEGER          NOT NULL DEFAULT 0,
-- 
cgit v1.2.3

