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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
|
CREATE TABLE appletlist(
id INTEGER PRIMARY KEY AUTOINCREMENT,
ip inet NOT NULL,
hostport INTEGER NOT NULL,
gamename TEXT NOT NULL DEFAULT '',
added timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE serverlist(
id INTEGER PRIMARY KEY AUTOINCREMENT,
ip inet NOT NULL,
port INTEGER NOT NULL DEFAULT 0,
gamename TEXT NOT NULL DEFAULT '',
gamever TEXT,
hostname TEXT,
hostport INTEGER DEFAULT 0,
country TEXT,
b333ms INTEGER DEFAULT 0,
blacklisted INTEGER DEFAULT 0,
added timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
beacon timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX pendingaddress ON serverlist(ip, port);
CREATE INDEX updateaddress ON serverlist(ip, hostport);
CREATE INDEX directbeacons ON serverlist(gamename, b333ms);
CREATE TABLE games(
gamename TEXT NOT NULL,
cipher TEXT,
description TEXT,
default_qport INTEGER DEFAULT 0,
num_uplink INTEGER DEFAULT 0,
num_total INTEGER DEFAULT 0
);
CREATE INDEX gameprops ON games(gamename);
CREATE TABLE pending(
id INTEGER PRIMARY KEY AUTOINCREMENT,
ip inet NOT NULL,
heartbeat INTEGER NOT NULL DEFAULT 0,
added timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE extended_info(
server_id INTEGER PRIMARY KEY AUTOINCREMENT,
minnetver TEXT,
location TEXT,
listenserver TEXT,
adminname TEXT,
adminemail TEXT,
password TEXT,
gametype TEXT,
gamestyle TEXT,
changelevels TEXT,
maptitle TEXT,
mapname TEXT,
numplayers INTEGER DEFAULT 0,
maxplayers INTEGER DEFAULT 0,
minplayers INTEGER DEFAULT 0,
botskill TEXT,
balanceteams TEXT,
playersbalanceteams TEXT,
friendlyfire TEXT,
maxteams TEXT,
timelimit TEXT,
goalteamscore TEXT,
fraglimit TEXT,
mutators TEXT DEFAULT 'None',
updated timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY(server_id) REFERENCES serverlist(id)
);
CREATE TABLE player_info(
server_id INTEGER NOT NULL,
player TEXT DEFAULT 'Player',
team TEXT,
frags INTEGER DEFAULT 0,
mesh TEXT,
skin TEXT,
face TEXT,
ping INTEGER DEFAULT 0,
ngsecret TEXT,
updated timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE kfstats(
UTkey TEXT NOT NULL,
Username TEXT DEFAULT ' ',
CurrentVeterancy TEXT DEFAULT 'None',
TotalKills INTEGER NOT NULL DEFAULT 0,
DecaptedKills INTEGER NOT NULL DEFAULT 0,
TotalMeleeDamage INTEGER NOT NULL DEFAULT 0,
MeleeKills INTEGER NOT NULL DEFAULT 0,
PowerWpnKills INTEGER NOT NULL DEFAULT 0,
BullpupDamage INTEGER NOT NULL DEFAULT 0,
StalkerKills INTEGER NOT NULL DEFAULT 0,
TotalWelded INTEGER NOT NULL DEFAULT 0,
TotalHealed INTEGER NOT NULL DEFAULT 0,
TotalPlaytime INTEGER NOT NULL DEFAULT 0,
GamesWon INTEGER NOT NULL DEFAULT 0,
GamesLost INTEGER NOT NULL DEFAULT 0
);
|
