· 6 years ago · Oct 19, 2019, 01:38 PM
1DROP TABLE IF EXISTS `litebans_bans`;
2CREATE TABLE IF NOT EXISTS `litebans_bans` (
3`id` bigint(20) unsigned NOT NULL,
4 `uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
5 `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
6 `reason` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
7 `banned_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
8 `banned_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
9 `removed_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
10 `removed_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
11 `removed_by_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
12 `time` bigint(20) NOT NULL,
13 `until` bigint(20) NOT NULL,
14 `server_scope` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
15 `server_origin` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
16 `silent` bit(1) NOT NULL,
17 `ipban` bit(1) NOT NULL,
18 `active` bit(1) NOT NULL
19) ENGINE=InnoDB AUTO_INCREMENT=174 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
20
21INSERT INTO `litebans_bans` (`id`, `uuid`, `ip`, `reason`, `banned_by_uuid`, `banned_by_name`, `removed_by_uuid`, `removed_by_name`, `removed_by_date`, `time`, `until`, `server_scope`, `server_origin`, `silent`, `ipban`, `active`) VALUES
22(3, '234a56a4-ec23-4985-8711-c4bc5b089b0b', '1.1.1.1', 'dit is een test haha', '234a56a4-ec23-4985-8711-c4bc5b089b0b', 'Marcooo', NULL, '#expired', '2018-01-31 21:13:11', 1517405598055, 1517405658055, 'kingdom', 'kingdom', b'0', b'0', b'0'),
23
24DROP TABLE IF EXISTS `litebans_history`;
25CREATE TABLE IF NOT EXISTS `litebans_history` (
26`id` bigint(20) unsigned NOT NULL,
27 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
28 `name` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
29 `uuid` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
30 `ip` varchar(45) COLLATE utf8_unicode_ci NOT NULL
31) ENGINE=InnoDB AUTO_INCREMENT=1952 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
32
33INSERT INTO `litebans_history` (`id`, `date`, `name`, `uuid`, `ip`) VALUES
34(1, '2018-01-31 12:58:38', '_Rejox', '7aca088d-3f62-4a87-b4d6-f4fd111daf86', '84.82.56.52'),
35
36
37DROP TABLE IF EXISTS `litebans_kicks`;
38CREATE TABLE IF NOT EXISTS `litebans_kicks` (
39`id` bigint(20) unsigned NOT NULL,
40 `uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
41 `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
42 `reason` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
43 `banned_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
44 `banned_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
45 `time` bigint(20) NOT NULL,
46 `until` bigint(20) NOT NULL,
47 `server_scope` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
48 `server_origin` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
49 `silent` bit(1) NOT NULL,
50 `ipban` bit(1) NOT NULL,
51 `active` bit(1) NOT NULL
52) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
53
54INSERT INTO `litebans_kicks` (`id`, `uuid`, `ip`, `reason`, `banned_by_uuid`, `banned_by_name`, `time`, `until`, `server_scope`, `server_origin`, `silent`, `ipban`, `active`) VALUES
55(2, 'a18adcee-66fd-40ea-a5fc-93033d54e410', '1.1.1.1', 'Spullen terug, 1 warn', '645fc856-65d8-44ac-b252-08046cb2f80b', 'MrWasbeer', 1518099505958, -1, '*', 'kingdom', b'0', b'0', b'0'),
56
57DROP TABLE IF EXISTS `litebans_mutes`;
58CREATE TABLE IF NOT EXISTS `litebans_mutes` (
59`id` bigint(20) unsigned NOT NULL,
60 `uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
61 `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
62 `reason` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
63 `banned_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
64 `banned_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
65 `removed_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
66 `removed_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
67 `removed_by_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
68 `time` bigint(20) NOT NULL,
69 `until` bigint(20) NOT NULL,
70 `server_scope` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
71 `server_origin` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
72 `silent` bit(1) NOT NULL,
73 `ipban` bit(1) NOT NULL,
74 `active` bit(1) NOT NULL
75) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
76
77INSERT INTO `litebans_mutes` (`id`, `uuid`, `ip`, `reason`, `banned_by_uuid`, `banned_by_name`, `removed_by_uuid`, `removed_by_name`, `removed_by_date`, `time`, `until`, `server_scope`, `server_origin`, `silent`, `ipban`, `active`) VALUES
78(2, '234a56a4-ec23-4985-8711-c4bc5b089b0b', '1.1.1.1', 'test', '234a56a4-ec23-4985-8711-c4bc5b089b0b', 'Marcooo', NULL, '#expired', '2018-01-31 21:13:11', 1517408634215, 1517408694215, 'lobby', 'lobby', b'0', b'0', b'0'),
79
80
81
82DROP TABLE IF EXISTS `litebans_warnings`;
83CREATE TABLE IF NOT EXISTS `litebans_warnings` (
84`id` bigint(20) unsigned NOT NULL,
85 `uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
86 `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
87 `reason` varchar(2048) COLLATE utf8_unicode_ci NOT NULL,
88 `banned_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
89 `banned_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
90 `removed_by_uuid` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
91 `removed_by_name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
92 `removed_by_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
93 `time` bigint(20) NOT NULL,
94 `until` bigint(20) NOT NULL,
95 `server_scope` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
96 `server_origin` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
97 `silent` bit(1) NOT NULL,
98 `ipban` bit(1) NOT NULL,
99 `active` bit(1) NOT NULL,
100 `warned` bit(1) NOT NULL
101) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
102
103INSERT INTO `litebans_warnings` (`id`, `uuid`, `ip`, `reason`, `banned_by_uuid`, `banned_by_name`, `removed_by_uuid`, `removed_by_name`, `removed_by_date`, `time`, `until`, `server_scope`, `server_origin`, `silent`, `ipban`, `active`, `warned`) VALUES
104(2, '8fae6db3-8c16-4496-9540-bcd0a27709c5', '1.1.1.1', 'Spammen.', '645fc856-65d8-44ac-b252-08046cb2f80b', 'MrWasbeer', NULL, '#expired', '2018-02-07 18:12:21', 1517417211071, 1518022011071, '*', 'kingdom', b'0', b'0', b'0', b'1'),