-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Nov 07, 2024 at 03:42 AM -- Server version: 8.0.40 -- PHP Version: 8.3.13 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `idipiaco_assignment_security` -- -- -------------------------------------------------------- -- -- Table structure for table `adblocker-settings` -- CREATE TABLE `adblocker-settings` ( `id` int NOT NULL, `detection` tinyint(1) NOT NULL DEFAULT '0', `redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pages/adblocker-detected.php' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `adblocker-settings` -- INSERT INTO `adblocker-settings` (`id`, `detection`, `redirect`) VALUES (1, 0, 'https://www.professionalassignmentshelp.com/security/pages/adblocker-detected.php'); -- -------------------------------------------------------- -- -- Table structure for table `bad-words` -- CREATE TABLE `bad-words` ( `id` int NOT NULL, `word` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `badbot-settings` -- CREATE TABLE `badbot-settings` ( `id` int NOT NULL, `protection` tinyint(1) NOT NULL DEFAULT '1', `protection2` tinyint(1) NOT NULL DEFAULT '1', `protection3` tinyint(1) NOT NULL DEFAULT '1', `logging` tinyint(1) NOT NULL DEFAULT '1', `autoban` tinyint(1) NOT NULL DEFAULT '0', `mail` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `badbot-settings` -- INSERT INTO `badbot-settings` (`id`, `protection`, `protection2`, `protection3`, `logging`, `autoban`, `mail`) VALUES (1, 1, 1, 1, 1, 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `bans` -- CREATE TABLE `bans` ( `id` int NOT NULL, `ip` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `time` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `redirect` tinyint(1) NOT NULL DEFAULT '0', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `autoban` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bans` -- INSERT INTO `bans` (`id`, `ip`, `date`, `time`, `reason`, `redirect`, `url`, `autoban`) VALUES (2, '', '', '', 'Bad Bot', 0, '', 1); -- -------------------------------------------------------- -- -- Table structure for table `bans-country` -- CREATE TABLE `bans-country` ( `id` int NOT NULL, `country` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `redirect` tinyint(1) NOT NULL DEFAULT '0', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bans-other` -- CREATE TABLE `bans-other` ( `id` int NOT NULL, `type` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `bans-ranges` -- CREATE TABLE `bans-ranges` ( `id` int NOT NULL, `ip_range` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `dnsbl-databases` -- CREATE TABLE `dnsbl-databases` ( `id` int NOT NULL, `database` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `dnsbl-databases` -- INSERT INTO `dnsbl-databases` (`id`, `database`) VALUES (1, 'sbl.spamhaus.org'), (2, 'xbl.spamhaus.org'); -- -------------------------------------------------------- -- -- Table structure for table `file-whitelist` -- CREATE TABLE `file-whitelist` ( `id` int NOT NULL, `path` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ip-whitelist` -- CREATE TABLE `ip-whitelist` ( `id` int NOT NULL, `ip` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `live-traffic` -- CREATE TABLE `live-traffic` ( `id` int NOT NULL, `ip` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `useragent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `browser_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `os_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `device_type` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `country` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `country_code` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'XX', `request_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `domain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `referer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `bot` tinyint(1) NOT NULL DEFAULT '0', `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `time` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `uniquev` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `logins` -- CREATE TABLE `logins` ( `id` int NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `ip` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `time` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `successful` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `logins` -- INSERT INTO `logins` (`id`, `username`, `ip`, `date`, `time`, `successful`) VALUES (1, 'Security-Assign', '172.68.39.179', '17 March 2022', '08:14', 1), (2, 'Security-Assign', '172.68.39.143', '17 March 2022', '08:44', 1), (3, 'Security-Assign', '172.70.162.179', '17 March 2022', '12:14', 1); -- -------------------------------------------------------- -- -- Table structure for table `logs` -- CREATE TABLE `logs` ( `id` int NOT NULL, `ip` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `time` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `page` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `query` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unknown', `browser_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unknown', `os_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `country` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unknown', `country_code` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'XX', `region` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unknown', `city` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unknown', `latitude` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `longitude` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `isp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unknown', `useragent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `referer_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `logs` -- INSERT INTO `logs` (`id`, `ip`, `date`, `time`, `page`, `query`, `type`, `browser`, `browser_code`, `os`, `os_code`, `country`, `country_code`, `region`, `city`, `latitude`, `longitude`, `isp`, `useragent`, `referer_url`) VALUES (4, '', '', '', '', '', 'Bad Bot', '', '', '', '', 'Canada', 'CA', 'Ontario', 'Mississauga', '43.5789', '-79.6583', 'Henico Inc', '', ''), (5, '', '', '', '', '', 'Missing User-Agent header', '', '', '', '', 'Canada', 'CA', 'Ontario', 'Mississauga', '43.5789', '-79.6583', 'Henico Inc', '', ''), (6, '', '', '', '', '', 'Fake Bot', '', '', '', '', 'Canada', 'CA', 'Ontario', 'Brampton', '43.68341', '-79.76633', 'Henico Inc', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `pages-layolt` -- CREATE TABLE `pages-layolt` ( `id` int NOT NULL, `page` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `pages-layolt` -- INSERT INTO `pages-layolt` (`id`, `page`, `text`) VALUES (1, 'Banned', 'You are banned and you cannot continue to the website'), (2, 'Blocked', 'Malicious request was detected'), (3, 'Proxy', 'Access to the website via Proxy, VPN, TOR is not allowed (Disable Browser Data Compression if you have it enabled)'), (4, 'Spam', 'You are in the Blacklist of Spammers and you cannot continue to the website'), (5, 'Banned_Country', 'Sorry, but your country is banned and you cannot continue to the website'), (6, 'Blocked_Browser', 'Access to the website through your Browser is not allowed, please use another Internet Browser'), (7, 'Blocked_OS', 'Access to the website through your Operating System is not allowed'), (8, 'Blocked_ISP', 'Your Internet Service Provider is blacklisted and you cannot continue to the website'), (9, 'Blocked_RFR', 'Your referrer url is blocked and you cannot continue to the website'), (10, 'AdBlocker', 'AdBlocker detected. Please support this website by disabling your AdBlocker'); -- -------------------------------------------------------- -- -- Table structure for table `proxy-settings` -- CREATE TABLE `proxy-settings` ( `id` int NOT NULL, `protection` tinyint(1) NOT NULL DEFAULT '0', `protection2` tinyint(1) NOT NULL DEFAULT '0', `api1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `api2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `api3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `logging` tinyint(1) NOT NULL DEFAULT '1', `autoban` tinyint(1) NOT NULL DEFAULT '0', `redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'https://www.professionalassignmentshelp.com/security/pages/proxy.php', `mail` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `proxy-settings` -- INSERT INTO `proxy-settings` (`id`, `protection`, `protection2`, `api1`, `api2`, `api3`, `logging`, `autoban`, `redirect`, `mail`) VALUES (1, 0, 0, '', '', '', 0, 0, 'https://www.professionalassignmentshelp.com/security/pages/proxy.php', 0); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `project_security` tinyint(1) NOT NULL DEFAULT '1', `mail_notifications` tinyint(1) NOT NULL DEFAULT '1', `dark_mode` int NOT NULL DEFAULT '0', `countryban_blacklist` tinyint(1) NOT NULL DEFAULT '1', `live_traffic` tinyint(1) NOT NULL DEFAULT '0', `badword_replace` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '[Censored]', `error_reporting` int NOT NULL DEFAULT '5', `display_errors` int NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `email`, `username`, `password`, `project_security`, `mail_notifications`, `dark_mode`, `countryban_blacklist`, `live_traffic`, `badword_replace`, `error_reporting`, `display_errors`) VALUES (1, 'admin@mail.com', 'Security-Assign', '58c9ddb8e879998fac3a79ac0e6f43fa017861a433976e1b1af54b33e0f01214', 1, 1, 0, 1, 0, '[Censored]', 5, 0); -- -------------------------------------------------------- -- -- Table structure for table `spam-settings` -- CREATE TABLE `spam-settings` ( `id` int NOT NULL, `protection` tinyint(1) NOT NULL DEFAULT '0', `logging` tinyint(1) NOT NULL DEFAULT '1', `redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'https://www.professionalassignmentshelp.com/security/pages/spammer.php', `autoban` tinyint(1) NOT NULL DEFAULT '0', `mail` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `spam-settings` -- INSERT INTO `spam-settings` (`id`, `protection`, `logging`, `redirect`, `autoban`, `mail`) VALUES (1, 1, 1, 'https://www.professionalassignmentshelp.com/security/pages/spammer.php', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `sqli-settings` -- CREATE TABLE `sqli-settings` ( `id` int NOT NULL, `protection` tinyint(1) NOT NULL DEFAULT '1', `protection2` tinyint(1) NOT NULL DEFAULT '1', `protection3` tinyint(1) NOT NULL DEFAULT '1', `protection4` tinyint(1) NOT NULL DEFAULT '1', `protection5` tinyint(1) NOT NULL DEFAULT '0', `protection6` tinyint(1) NOT NULL DEFAULT '1', `protection7` tinyint(1) NOT NULL DEFAULT '0', `protection8` tinyint(1) NOT NULL DEFAULT '0', `logging` tinyint(1) NOT NULL DEFAULT '1', `redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'https://www.professionalassignmentshelp.com/security/pages/blocked.php', `autoban` tinyint(1) NOT NULL DEFAULT '0', `mail` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sqli-settings` -- INSERT INTO `sqli-settings` (`id`, `protection`, `protection2`, `protection3`, `protection4`, `protection5`, `protection6`, `protection7`, `protection8`, `logging`, `redirect`, `autoban`, `mail`) VALUES (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'https://www.professionalassignmentshelp.com/security/pages/blocked.php', 1, 0); -- -- Indexes for dumped tables -- -- -- Indexes for table `adblocker-settings` -- ALTER TABLE `adblocker-settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bad-words` -- ALTER TABLE `bad-words` ADD PRIMARY KEY (`id`); -- -- Indexes for table `badbot-settings` -- ALTER TABLE `badbot-settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bans` -- ALTER TABLE `bans` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bans-country` -- ALTER TABLE `bans-country` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bans-other` -- ALTER TABLE `bans-other` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bans-ranges` -- ALTER TABLE `bans-ranges` ADD PRIMARY KEY (`id`); -- -- Indexes for table `dnsbl-databases` -- ALTER TABLE `dnsbl-databases` ADD PRIMARY KEY (`id`); -- -- Indexes for table `file-whitelist` -- ALTER TABLE `file-whitelist` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ip-whitelist` -- ALTER TABLE `ip-whitelist` ADD PRIMARY KEY (`id`); -- -- Indexes for table `live-traffic` -- ALTER TABLE `live-traffic` ADD PRIMARY KEY (`id`); -- -- Indexes for table `logins` -- ALTER TABLE `logins` ADD PRIMARY KEY (`id`); -- -- Indexes for table `logs` -- ALTER TABLE `logs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pages-layolt` -- ALTER TABLE `pages-layolt` ADD PRIMARY KEY (`id`); -- -- Indexes for table `proxy-settings` -- ALTER TABLE `proxy-settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `spam-settings` -- ALTER TABLE `spam-settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sqli-settings` -- ALTER TABLE `sqli-settings` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `adblocker-settings` -- ALTER TABLE `adblocker-settings` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `bad-words` -- ALTER TABLE `bad-words` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `badbot-settings` -- ALTER TABLE `badbot-settings` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `bans` -- ALTER TABLE `bans` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `bans-country` -- ALTER TABLE `bans-country` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bans-other` -- ALTER TABLE `bans-other` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bans-ranges` -- ALTER TABLE `bans-ranges` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `dnsbl-databases` -- ALTER TABLE `dnsbl-databases` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `file-whitelist` -- ALTER TABLE `file-whitelist` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ip-whitelist` -- ALTER TABLE `ip-whitelist` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `live-traffic` -- ALTER TABLE `live-traffic` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `logins` -- ALTER TABLE `logins` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `logs` -- ALTER TABLE `logs` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `pages-layolt` -- ALTER TABLE `pages-layolt` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `proxy-settings` -- ALTER TABLE `proxy-settings` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `spam-settings` -- ALTER TABLE `spam-settings` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sqli-settings` -- ALTER TABLE `sqli-settings` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;