KsHVkDuF

1-- --------------------------------------------------------
2-- Host:                         localhost
3-- Server version:               10.1.9-MariaDB-log - mariadb.org binary distribution
4-- Server OS:                    Win32
5-- HeidiSQL Version:             9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for boompanel
14CREATE DATABASE IF NOT EXISTS `mythical_panelserver` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
15USE `mythical_panelserver`;
16
17SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
18
19-- Dumping structure for table boompanel.bp_admins
20CREATE TABLE IF NOT EXISTS `bp_admins` (
21	`aid` INT(11) NOT NULL AUTO_INCREMENT,
22	`pid` INT(11) NOT NULL,
23	`sid` INT(11) NOT NULL,
24	`gid` INT(11) NOT NULL,
25	`add_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
26	PRIMARY KEY (`aid`),
27	INDEX `gid` (`gid`),
28	INDEX `sid` (`sid`),
29	INDEX `pid` (`pid`),
30	CONSTRAINT `bp_admins_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `bp_players` (`id`) ON UPDATE CASCADE,
31	CONSTRAINT `bp_admins_ibfk_2` FOREIGN KEY (`gid`) REFERENCES `bp_admin_groups` (`id`) ON UPDATE CASCADE,
32	CONSTRAINT `bp_admins_ibfk_3` FOREIGN KEY (`sid`) REFERENCES `bp_servers` (`id`) ON UPDATE CASCADE
33)
34COLLATE='utf8mb4_unicode_ci'
35ENGINE=InnoDB
36AUTO_INCREMENT=8
37;
38
39
40
41-- Dumping data for table boompanel.bp_admins: ~0 rows (approximately)
42/*!40000 ALTER TABLE `bp_admins` DISABLE KEYS */;
43/*!40000 ALTER TABLE `bp_admins` ENABLE KEYS */;
44
45
46-- Dumping structure for table boompanel.bp_admin_groups
47CREATE TABLE IF NOT EXISTS `bp_admin_groups` (
48	`id` INT(11) NOT NULL AUTO_INCREMENT,
49	`name` VARCHAR(50) NOT NULL COLLATE 'utf8_general_ci',
50	`flags` VARCHAR(25) NOT NULL COLLATE 'utf8_general_ci',
51	`immunity` INT(3) NOT NULL DEFAULT '0',
52	`usetime` INT(11) NOT NULL DEFAULT '0',
53	`isadmingroup` INT(1) NOT NULL DEFAULT '0',
54	PRIMARY KEY (`id`)
55)
56COLLATE='utf8mb4_unicode_ci'
57ENGINE=InnoDB
58AUTO_INCREMENT=11
59;
60
61
62
63-- Dumping data for table boompanel.bp_admin_groups: ~0 rows (approximately)
64/*!40000 ALTER TABLE `bp_admin_groups` DISABLE KEYS */;
65/*!40000 ALTER TABLE `bp_admin_groups` ENABLE KEYS */;
66
67
68-- Dumping structure for table boompanel.bp_bans
69CREATE TABLE IF NOT EXISTS `bp_bans` (
70  `bid` int(11) NOT NULL AUTO_INCREMENT,
71  `pid` int(11) NOT NULL,
72  `sid` int(11) NOT NULL,
73  `aid` int(11) NOT NULL,
74  `reason` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
75  `length` int(11) NOT NULL DEFAULT '0',
76  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
77  `unbanned` int(1) NOT NULL DEFAULT '0',
78  PRIMARY KEY (`bid`),
79  KEY `admin_id` (`aid`),
80  KEY `sid` (`sid`),
81  KEY `pid` (`pid`),
82  CONSTRAINT `bp_bans_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `bp_players` (`id`) ON UPDATE CASCADE,
83  CONSTRAINT `bp_bans_ibfk_2` FOREIGN KEY (`sid`) REFERENCES `bp_servers` (`id`) ON UPDATE CASCADE,
84  CONSTRAINT `bp_bans_ibfk_3` FOREIGN KEY (`aid`) REFERENCES `bp_players` (`id`) ON UPDATE CASCADE
85) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
86
87-- Dumping data for table boompanel.bp_bans: ~0 rows (approximately)
88/*!40000 ALTER TABLE `bp_bans` DISABLE KEYS */;
89/*!40000 ALTER TABLE `bp_bans` ENABLE KEYS */;
90
91
92-- Dumping structure for table boompanel.bp_chat
93CREATE TABLE IF NOT EXISTS `bp_chat` (
94  `lid` int(11) NOT NULL AUTO_INCREMENT,
95  `pid` int(11) NOT NULL,
96  `sid` int(11) NOT NULL,
97  `message` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
98  `type` int(1) NOT NULL DEFAULT '0',
99  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
100  PRIMARY KEY (`lid`),
101  KEY `player_id` (`pid`),
102  KEY `server_id` (`sid`),
103  CONSTRAINT `bp_chat_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `bp_players` (`id`) ON UPDATE CASCADE,
104  CONSTRAINT `bp_chat_ibfk_2` FOREIGN KEY (`sid`) REFERENCES `bp_servers` (`id`) ON UPDATE CASCADE
105) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
106
107-- Dumping data for table boompanel.bp_chat: ~0 rows (approximately)
108/*!40000 ALTER TABLE `bp_chat` DISABLE KEYS */;
109/*!40000 ALTER TABLE `bp_chat` ENABLE KEYS */;
110
111
112-- Dumping structure for table boompanel.bp_countries
113CREATE TABLE IF NOT EXISTS `bp_countries` (
114  `country_code` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
115  `country_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
116  UNIQUE KEY `country_uniqe` (`country_code`)
117) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
118
119-- Dumping data for table boompanel.bp_countries: ~246 rows (approximately)
120/*!40000 ALTER TABLE `bp_countries` DISABLE KEYS */;
121INSERT IGNORE INTO `bp_countries` (`country_code`, `country_name`) VALUES
122	('AD', 'Andorra'),
123	('AE', 'United-Arab-Emirates'),
124	('AF', 'Afghanistan'),
125	('AG', 'Antigua-and-Barbuda'),
126	('AI', 'Anguilla'),
127	('AL', 'Albania'),
128	('AM', 'Armenia'),
129	('AN', 'Netherlands-Antilles'),
130	('AO', 'Angola'),
131	('AQ', 'Antarctica'),
132	('AR', 'Argentina'),
133	('AT', 'Austria'),
134	('AU', 'Australia'),
135	('AW', 'Aruba'),
136	('AZ', 'Azerbaijan'),
137	('BA', 'Bosnia-and-Herzegovina'),
138	('BB', 'Barbados'),
139	('BD', 'Bangladesh'),
140	('BE', 'Belgium'),
141	('BF', 'Burkina-Faso'),
142	('BG', 'Bulgaria'),
143	('BH', 'Bahrain'),
144	('BI', 'Burundi'),
145	('BY', 'Belarus'),
146	('BJ', 'Benin'),
147	('BM', 'Bermuda'),
148	('BN', 'Brunei-Darussalam'),
149	('BO', 'Bolivia'),
150	('BR', 'Brazil'),
151	('BS', 'Bahamas'),
152	('BT', 'Bhutan'),
153	('BV', 'Bouvet-Island'),
154	('BW', 'Botswana'),
155	('BZ', 'Belize'),
156	('CA', 'Canada'),
157	('CC', 'Cocos-(Keeling)-Islands'),
158	('CF', 'Central-African-Republic'),
159	('CG', 'Congo'),
160	('CH', 'Switzerland'),
161	('CI', 'Ivory-Coast'),
162	('CY', 'Cyprus'),
163	('CK', 'Cook-Islands'),
164	('CL', 'Chile'),
165	('CM', 'Cameroon'),
166	('CN', 'China'),
167	('CO', 'Colombia'),
168	('CR', 'Costa-Rica'),
169	('CU', 'Cuba'),
170	('CV', 'Cape-Verde'),
171	('CX', 'Christmas-Island'),
172	('CZ', 'Czech-Republic'),
173	('DE', 'Germany'),
174	('DJ', 'Djibouti'),
175	('DK', 'Denmark'),
176	('DM', 'Dominica'),
177	('DO', 'Dominican-Republic'),
178	('DS', 'American-Samoa'),
179	('DZ', 'Algeria'),
180	('EC', 'Ecuador'),
181	('EE', 'Estonia'),
182	('EG', 'Egypt'),
183	('EH', 'Western-Sahara'),
184	('ER', 'Eritrea'),
185	('ES', 'Spain'),
186	('ET', 'Ethiopia'),
187	('FI', 'Finland'),
188	('FJ', 'Fiji'),
189	('FK', 'Falkland-Islands-(Malvinas)'),
190	('FM', 'Micronesia,-Federated-States-of'),
191	('FO', 'Faroe-Islands'),
192	('FR', 'France'),
193	('FX', 'France,-Metropolitan'),
194	('GA', 'Gabon'),
195	('GB', 'United-Kingdom'),
196	('GD', 'Grenada'),
197	('GE', 'Georgia'),
198	('GF', 'French-Guiana'),
199	('GH', 'Ghana'),
200	('GI', 'Gibraltar'),
201	('GY', 'Guyana'),
202	('GK', 'Guernsey'),
203	('GL', 'Greenland'),
204	('GM', 'Gambia'),
205	('GN', 'Guinea'),
206	('GP', 'Guadeloupe'),
207	('GQ', 'Equatorial-Guinea'),
208	('GR', 'Greece'),
209	('GS', 'South-Georgia-South-Sandwich-Islands'),
210	('GT', 'Guatemala'),
211	('GU', 'Guam'),
212	('GW', 'Guinea-Bissau'),
213	('HK', 'Hong-Kong'),
214	('HM', 'Heard-and-Mc-Donald-Islands'),
215	('HN', 'Honduras'),
216	('HR', 'Croatia-(Hrvatska)'),
217	('HT', 'Haiti'),
218	('HU', 'Hungary'),
219	('HZ', 'Unknown'),
220	('ID', 'Indonesia'),
221	('IE', 'Ireland'),
222	('IL', 'Israel'),
223	('IM', 'Isle-of-Man'),
224	('IN', 'India'),
225	('IO', 'British-Indian-Ocean-Territory'),
226	('IQ', 'Iraq'),
227	('IR', 'Iran-(Islamic-Republic-of)'),
228	('IS', 'Iceland'),
229	('IT', 'Italy'),
230	('YE', 'Yemen'),
231	('JE', 'Jersey'),
232	('JM', 'Jamaica'),
233	('JO', 'Jordan'),
234	('JP', 'Japan'),
235	('KE', 'Kenya'),
236	('KG', 'Kyrgyzstan'),
237	('KH', 'Cambodia'),
238	('KI', 'Kiribati'),
239	('KY', 'Cayman-Islands'),
240	('KM', 'Comoros'),
241	('KN', 'Saint-Kitts-and-Nevis'),
242	('KP', 'Korea,-Democratic-People\'s-Republic-of'),
243	('KR', 'Korea,-Republic-of'),
244	('KW', 'Kuwait'),
245	('KZ', 'Kazakhstan'),
246	('LA', 'Lao-People\'s-Democratic-Republic'),
247	('LB', 'Lebanon'),
248	('LC', 'Saint-Lucia'),
249	('LI', 'Liechtenstein'),
250	('LY', 'Libyan-Arab-Jamahiriya'),
251	('LK', 'Sri-Lanka'),
252	('LR', 'Liberia'),
253	('LS', 'Lesotho'),
254	('LT', 'Lithuania'),
255	('LU', 'Luxembourg'),
256	('LV', 'Latvia'),
257	('MA', 'Morocco'),
258	('MC', 'Monaco'),
259	('MD', 'Moldova,-Republic-of'),
260	('ME', 'Montenegro'),
261	('MG', 'Madagascar'),
262	('MH', 'Marshall-Islands'),
263	('MY', 'Malaysia'),
264	('MK', 'Macedonia'),
265	('ML', 'Mali'),
266	('MM', 'Myanmar'),
267	('MN', 'Mongolia'),
268	('MO', 'Macau'),
269	('MP', 'Northern-Mariana-Islands'),
270	('MQ', 'Martinique'),
271	('MR', 'Mauritania'),
272	('MS', 'Montserrat'),
273	('MT', 'Malta'),
274	('MU', 'Mauritius'),
275	('MV', 'Maldives'),
276	('MW', 'Malawi'),
277	('MX', 'Mexico'),
278	('MZ', 'Mozambique'),
279	('NA', 'Namibia'),
280	('NC', 'New-Caledonia'),
281	('NE', 'Niger'),
282	('NF', 'Norfolk-Island'),
283	('NG', 'Nigeria'),
284	('NI', 'Nicaragua'),
285	('NL', 'Netherlands'),
286	('NO', 'Norway'),
287	('NP', 'Nepal'),
288	('NR', 'Nauru'),
289	('NU', 'Niue'),
290	('NZ', 'New-Zealand'),
291	('OM', 'Oman'),
292	('PA', 'Panama'),
293	('PE', 'Peru'),
294	('PF', 'French-Polynesia'),
295	('PG', 'Papua-New-Guinea'),
296	('PH', 'Philippines'),
297	('PY', 'Paraguay'),
298	('PK', 'Pakistan'),
299	('PL', 'Poland'),
300	('PM', 'St.-Pierre-and-Miquelon'),
301	('PN', 'Pitcairn'),
302	('PR', 'Puerto-Rico'),
303	('PS', 'Palestine'),
304	('PT', 'Portugal'),
305	('PW', 'Palau'),
306	('QA', 'Qatar'),
307	('RE', 'Reunion'),
308	('RO', 'Romania'),
309	('RS', 'Serbia'),
310	('RU', 'Russian-Federation'),
311	('RW', 'Rwanda'),
312	('SA', 'Saudi-Arabia'),
313	('SB', 'Solomon-Islands'),
314	('SC', 'Seychelles'),
315	('SD', 'Sudan'),
316	('SE', 'Sweden'),
317	('SG', 'Singapore'),
318	('SH', 'St.-Helena'),
319	('SI', 'Slovenia'),
320	('SY', 'Syrian-Arab-Republic'),
321	('SJ', 'Svalbard-and-Jan-Mayen-Islands'),
322	('SK', 'Slovakia'),
323	('SL', 'Sierra-Leone'),
324	('SM', 'San-Marino'),
325	('SN', 'Senegal'),
326	('SO', 'Somalia'),
327	('SR', 'Suriname'),
328	('ST', 'Sao-Tome-and-Principe'),
329	('SV', 'El-Salvador'),
330	('SZ', 'Swaziland'),
331	('TC', 'Turks-and-Caicos-Islands'),
332	('TD', 'Chad'),
333	('TF', 'French-Southern-Territories'),
334	('TG', 'Togo'),
335	('TH', 'Thailand'),
336	('TY', 'Mayotte'),
337	('TJ', 'Tajikistan'),
338	('TK', 'Tokelau'),
339	('TM', 'Turkmenistan'),
340	('TN', 'Tunisia'),
341	('TO', 'Tonga'),
342	('TP', 'East-Timor'),
343	('TR', 'Turkey'),
344	('TT', 'Trinidad-and-Tobago'),
345	('TV', 'Tuvalu'),
346	('TW', 'Taiwan'),
347	('TZ', 'Tanzania,-United-Republic-of'),
348	('UA', 'Ukraine'),
349	('UG', 'Uganda'),
350	('UY', 'Uruguay'),
351	('UM', 'United-States-minor-outlying-islands'),
352	('US', 'United-States'),
353	('UZ', 'Uzbekistan'),
354	('VA', 'Vatican-City-State'),
355	('VC', 'Saint-Vincent-and-the-Grenadines'),
356	('VE', 'Venezuela'),
357	('VG', 'Virgin-Islands-(British)'),
358	('VI', 'Virgin-Islands-(U.S.)'),
359	('VN', 'Vietnam'),
360	('VU', 'Vanuatu'),
361	('WF', 'Wallis-and-Futuna-Islands'),
362	('WS', 'Samoa'),
363	('XK', 'Kosovo'),
364	('ZA', 'South-Africa'),
365	('ZM', 'Zambia'),
366	('ZR', 'Zaire'),
367	('ZW', 'Zimbabwe');
368/*!40000 ALTER TABLE `bp_countries` ENABLE KEYS */;
369
370
371-- Dumping structure for table boompanel.bp_flags
372CREATE TABLE IF NOT EXISTS `bp_flags` (
373  `flag` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
374  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
375  `importance` int(1) NOT NULL DEFAULT '1'
376) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
377
378-- Dumping data for table boompanel.bp_flags: ~21 rows (approximately)
379/*!40000 ALTER TABLE `bp_flags` DISABLE KEYS */;
380INSERT IGNORE INTO `bp_flags` (`flag`, `name`, `importance`) VALUES
381	('a', 'Reservation', 1),
382	('b', 'Generic', 1),
383	('c', 'Kick', 1),
384	('d', 'Ban', 1),
385	('e', 'Unban', 1),
386	('f', 'Slay', 1),
387	('g', 'Changemap', 1),
388	('h', 'Cvar', 1),
389	('i', 'Config', 1),
390	('j', 'Chat', 1),
391	('k', 'Vote', 1),
392	('l', 'Password', 1),
393	('m', 'Rcon', 1),
394	('n', 'Cheats', 1),
395	('z', 'Root', 1),
396	('o', 'Flag_custom', 1),
397	('p', 'Flag_custom', 1),
398	('q', 'Flag_custom', 1),
399	('r', 'Flag_custom', 1),
400	('s', 'Flag_custom', 1),
401	('t', 'Flag_custom', 1);
402/*!40000 ALTER TABLE `bp_flags` ENABLE KEYS */;
403
404
405-- Dumping structure for table boompanel.bp_mutegag
406CREATE TABLE IF NOT EXISTS `bp_mutegag` (
407  `bid` int(11) NOT NULL AUTO_INCREMENT,
408  `pid` int(11) NOT NULL,
409  `aid` int(11) NOT NULL,
410  `sid` int(11) NOT NULL,
411  `mgtype` int(1) NOT NULL DEFAULT '0',
412  `length` int(11) NOT NULL,
413  `reason` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
414  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
415  `unbanned` int(1) NOT NULL DEFAULT '0',
416  PRIMARY KEY (`bid`),
417  KEY `pid` (`pid`),
418  KEY `aid` (`aid`),
419  KEY `sid` (`sid`),
420  CONSTRAINT `bp_mutegag_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `bp_players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
421  CONSTRAINT `bp_mutegag_ibfk_2` FOREIGN KEY (`aid`) REFERENCES `bp_players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
422  CONSTRAINT `bp_mutegag_ibfk_3` FOREIGN KEY (`sid`) REFERENCES `bp_servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
423) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
424
425-- Dumping data for table boompanel.bp_mutegag: ~0 rows (approximately)
426/*!40000 ALTER TABLE `bp_mutegag` DISABLE KEYS */;
427/*!40000 ALTER TABLE `bp_mutegag` ENABLE KEYS */;
428
429
430-- Dumping structure for table boompanel.bp_panel_admins
431CREATE TABLE `bp_panel_admins` (
432	`id` INT(11) NOT NULL AUTO_INCREMENT,
433	`steamid` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
434	PRIMARY KEY (`id`),
435	UNIQUE INDEX `steamid` (`steamid`)
436)
437COLLATE='utf8mb4_unicode_ci'
438ENGINE=InnoDB
439AUTO_INCREMENT=10
440;
441
442-- Dumping data for table boompanel.bp_panel_admins: ~0 rows (approximately)
443/*!40000 ALTER TABLE `bp_panel_admins` DISABLE KEYS */;
444/*!40000 ALTER TABLE `bp_panel_admins` ENABLE KEYS */;
445
446
447-- Dumping structure for table boompanel.bp_players
448CREATE TABLE IF NOT EXISTS `bp_players` (
449  `id` int(11) NOT NULL AUTO_INCREMENT,
450  `steamid` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
451  `country` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
452  PRIMARY KEY (`id`),
453  UNIQUE KEY `steamid` (`steamid`),
454  KEY `country_id` (`country`),
455  CONSTRAINT `bp_players_ibfk_1` FOREIGN KEY (`country`) REFERENCES `bp_countries` (`country_code`) ON UPDATE CASCADE
456) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
457
458-- Dumping data for table boompanel.bp_players: ~1 rows (approximately)
459/*!40000 ALTER TABLE `bp_players` DISABLE KEYS */;
460INSERT IGNORE INTO `bp_players` (`id`, `steamid`, `country`) VALUES
461	(0, '0', 'HZ');
462/*!40000 ALTER TABLE `bp_players` ENABLE KEYS */;
463
464
465-- Dumping structure for table boompanel.bp_players_ip
466CREATE TABLE IF NOT EXISTS `bp_players_ip` (
467  `pid` int(11) NOT NULL,
468  `ip` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
469  `connections` int(6) NOT NULL DEFAULT '1',
470  `last_used` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
471  UNIQUE KEY `unique_index` (`pid`,`ip`),
472  CONSTRAINT `bp_players_ip_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `bp_players` (`id`) ON UPDATE CASCADE
473) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
474
475-- Dumping data for table boompanel.bp_players_ip: ~0 rows (approximately)
476/*!40000 ALTER TABLE `bp_players_ip` DISABLE KEYS */;
477/*!40000 ALTER TABLE `bp_players_ip` ENABLE KEYS */;
478
479
480-- Dumping structure for table boompanel.bp_players_online
481CREATE TABLE `bp_players_online` (
482	`pid` INT(11) NOT NULL,
483	`sid` INT(11) NOT NULL,
484	`connected` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
485	`disconnected` TIMESTAMP NOT NULL DEFAULT 0,
486	INDEX `server_id` (`sid`),
487	INDEX `player_id` (`pid`),
488	CONSTRAINT `bp_players_online_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `bp_servers` (`id`) ON UPDATE CASCADE,
489	CONSTRAINT `bp_players_online_ibfk_2` FOREIGN KEY (`pid`) REFERENCES `bp_players` (`id`) ON UPDATE CASCADE
490)
491COLLATE='utf8mb4_unicode_ci'
492ENGINE=InnoDB
493;
494
495-- Dumping data for table boompanel.bp_players_online: ~0 rows (approximately)
496/*!40000 ALTER TABLE `bp_players_online` DISABLE KEYS */;
497/*!40000 ALTER TABLE `bp_players_online` ENABLE KEYS */;
498
499
500-- Dumping structure for table boompanel.bp_players_username
501CREATE TABLE IF NOT EXISTS `bp_players_username` (
502  `pid` int(11) NOT NULL,
503  `username` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
504  `connections` int(6) NOT NULL DEFAULT '1',
505  `last_used` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
506  UNIQUE KEY `unique_index` (`username`,`pid`),
507  KEY `player_id` (`pid`),
508  CONSTRAINT `bp_players_username_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `bp_players` (`id`) ON UPDATE CASCADE
509) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
510-- last_used ON UPDATE CURRENT_TIMESTAMP
511
512-- Dumping data for table boompanel.bp_players_username: ~1 rows (approximately)
513/*!40000 ALTER TABLE `bp_players_username` DISABLE KEYS */;
514INSERT IGNORE INTO `bp_players_username` (`pid`, `username`, `connections`, `last_used`) VALUES
515	(0, 'Console', 0, '2017-10-28 14:58:41');
516/*!40000 ALTER TABLE `bp_players_username` ENABLE KEYS */;
517
518
519-- Dumping structure for table boompanel.bp_servers
520CREATE TABLE IF NOT EXISTS `bp_servers` (
521  `id` int(11) NOT NULL AUTO_INCREMENT,
522  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
523  `ip` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
524  `port` int(6) NOT NULL,
525  `rcon_pw` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
526  PRIMARY KEY (`id`),
527  UNIQUE KEY `fullIP` (`ip`,`port`)
528) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
529
530
531CREATE TABLE `bp_panel_permissions` (
532	`permissionid` INT(11) NOT NULL AUTO_INCREMENT,
533	`name` VARCHAR(40) NOT NULL COLLATE 'utf8mb4_unicode_ci',
534	PRIMARY KEY (`permissionid`),
535	UNIQUE INDEX `name` (`name`)
536)
537COLLATE='utf8mb4_unicode_ci'
538ENGINE=InnoDB
539AUTO_INCREMENT=34
540;
541
542
543CREATE TABLE `bp_panel_admin_permissions` (
544	`paneladmin` INT(11) NULL DEFAULT NULL,
545	`permissionid` INT(11) NULL DEFAULT NULL,
546	UNIQUE INDEX `paneladmin` (`paneladmin`, `permissionid`),
547	INDEX `pid` (`paneladmin`),
548	INDEX `permissionid` (`permissionid`),
549	CONSTRAINT `bp_panel_admin_permissions_ibfk_2` FOREIGN KEY (`permissionid`) REFERENCES `bp_panel_permissions` (`permissionid`) ON DELETE CASCADE,
550	CONSTRAINT `bp_panel_admin_permissions_ibfk_3` FOREIGN KEY (`paneladmin`) REFERENCES `bp_panel_admins` (`id`) ON DELETE CASCADE
551)
552COLLATE='utf8mb4_unicode_ci'
553ENGINE=InnoDB
554;
555
556
557
558
559-- Dumping data for table boompanel.bp_servers: ~1 rows (approximately)
560/*!40000 ALTER TABLE `bp_servers` DISABLE KEYS */;
561INSERT IGNORE INTO `bp_servers` (`id`, `name`, `ip`, `port`, `rcon_pw`) VALUES
562	(0, 'all servers', '', 0, '');
563/*!40000 ALTER TABLE `bp_servers` ENABLE KEYS */;
564/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
565/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
566/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;