-
Notifications
You must be signed in to change notification settings - Fork 19
/
Copy pathdatabase.sql
45 lines (43 loc) · 2.1 KB
/
database.sql
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
DROP TABLE IF EXISTS banlist;
CREATE TABLE IF NOT EXISTS banlist (
license varchar(50) COLLATE utf8mb4_bin PRIMARY KEY,
identifier varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
liveid varchar(21) COLLATE utf8mb4_bin DEFAULT NULL,
xblid varchar(21) COLLATE utf8mb4_bin DEFAULT NULL,
discord varchar(30) COLLATE utf8mb4_bin DEFAULT NULL,
playerip varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
targetplayername varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
sourceplayername varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
reason varchar(255) NOT NULL,
timeat varchar(50) NOT NULL,
expiration varchar(50) NOT NULL,
permanent int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
DROP TABLE IF EXISTS banlisthistory;
CREATE TABLE IF NOT EXISTS banlisthistory (
id int(11) AUTO_INCREMENT PRIMARY KEY,
license varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
identifier varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
liveid varchar(21) COLLATE utf8mb4_bin DEFAULT NULL,
xblid varchar(21) COLLATE utf8mb4_bin DEFAULT NULL,
discord varchar(30) COLLATE utf8mb4_bin DEFAULT NULL,
playerip varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
targetplayername varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
sourceplayername varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
reason varchar(255) NOT NULL,
timeat int(11) NOT NULL,
added varchar(40) NOT NULL,
expiration int(11) NOT NULL,
permanent int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
DROP TABLE IF EXISTS baninfo;
CREATE TABLE IF NOT EXISTS baninfo (
id int(11) AUTO_INCREMENT PRIMARY KEY,
license varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
identifier varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
liveid varchar(21) COLLATE utf8mb4_bin DEFAULT NULL,
xblid varchar(21) COLLATE utf8mb4_bin DEFAULT NULL,
discord varchar(30) COLLATE utf8mb4_bin DEFAULT NULL,
playerip varchar(25) COLLATE utf8mb4_bin DEFAULT NULL,
playername varchar(32) COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;