dsGwAw56

1CREATE TABLE IF NOT EXISTS banlist (
2  identifier varchar(50) COLLATE utf8mb4_bin PRIMARY KEY,
3  license varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
4  playerip varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
5  targetplayername varchar(32) COLLATE utf8mb4_bin NOT NULL,
6  sourceplayername varchar(32) COLLATE utf8mb4_bin NOT NULL,
7  reason varchar(255) NOT NULL,
8  timeat varchar(50) NOT NULL,
9  added datetime DEFAULT CURRENT_TIMESTAMP,
10  expiration varchar(50) NOT NULL,
11  permanent int(1) NOT NULL DEFAULT 0
12) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
13
14CREATE TABLE IF NOT EXISTS banlisthistory (
15  id int(11) AUTO_INCREMENT PRIMARY KEY,
16  identifier varchar(50) NOT NULL,
17  license varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
18  playerip varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
19  targetplayername varchar(32) COLLATE utf8mb4_bin NOT NULL,
20  sourceplayername varchar(32) COLLATE utf8mb4_bin NOT NULL,
21  reason varchar(255) NOT NULL,
22  timeat int(11) NOT NULL,
23  added datetime DEFAULT CURRENT_TIMESTAMP,
24  expiration int(11) NOT NULL,
25  permanent int(1) NOT NULL DEFAULT 0
26) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;