diff options
| author | Darkelarious <darkelarious@333networks.com> | 2017-05-13 14:18:28 +0200 |
|---|---|---|
| committer | Darkelarious <darkelarious@333networks.com> | 2017-05-13 14:20:49 +0200 |
| commit | 34a2c7390ea9662d33258d384e72fff1912343ff (patch) | |
| tree | d96ea33c0107e4906a152aa1de4b5c75b81ba0a8 /data/sql/tables-mysql.sql | |
| parent | 84af66aba26d2088d5d95c240d176f3edaf17b58 (diff) | |
| download | MasterServer-Perl-2.3.0.tar.gz MasterServer-Perl-2.3.0.zip | |
revised synchronization methods, config settings and bug fixesv2.3.0
Diffstat (limited to 'data/sql/tables-mysql.sql')
| -rwxr-xr-x | data/sql/tables-mysql.sql | 12 |
1 files changed, 11 insertions, 1 deletions
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, |