1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
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(50) NOT NULL DEFAULT ' ',
gamever VARCHAR(50) NOT NULL DEFAULT ' ',
hostname VARCHAR(100) NOT NULL DEFAULT ' ',
hostport INTEGER NOT NULL DEFAULT 0,
country VARCHAR(5),
b333ms BOOLEAN NOT NULL DEFAULT 0,
blacklisted BOOLEAN NOT NULL DEFAULT 0,
added TIMESTAMP NOT NULL DEFAULT NOW(),
beacon TIMESTAMP NOT NULL DEFAULT NOW(),
updated TIMESTAMP NOT NULL DEFAULT NOW(),
PRIMARY KEY (id)
);
CREATE TABLE pending(
id INTEGER NOT NULL AUTO_INCREMENT,
ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
beaconport INTEGER NOT NULL DEFAULT 0,
heartbeat INTEGER NOT NULL DEFAULT 0,
gamename VARCHAR(25) NOT NULL DEFAULT ' ',
secure VARCHAR(12) NOT NULL DEFAULT ' ',
enctype INTEGER NOT NULL DEFAULT 0,
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
);
|
