private static property Schema::$schemas in Anti Spam by CleanTalk 8.4
Same name and namespace in other branches
- 9.1.x src/lib/Cleantalk/Common/Schema.php \Cleantalk\Common\Schema::schemas
File
- src/
lib/ Cleantalk/ Common/ Schema.php, line 10
Class
Namespace
Cleantalk\CommonCode
private static $schemas = array(
'sfw' => 'CREATE TABLE IF NOT EXISTS `%scleantalk_sfw` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`network` int(11) unsigned NOT NULL,
`mask` int(11) unsigned NOT NULL,
`status` TINYINT(1) NOT NULL DEFAULT 0,
`source` TINYINT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
INDEX ( `network` , `mask` )
);',
'ua_bl' => 'CREATE TABLE IF NOT EXISTS `%scleantalk_ac_ua_bl` (
`id` INT(11) NOT NULL,
`ua_template` VARCHAR(255) NULL DEFAULT NULL,
`ua_status` TINYINT(1) NULL DEFAULT NULL,
PRIMARY KEY ( `id` ),
INDEX ( `ua_template` )
) DEFAULT CHARSET=utf8;',
// Don't remove the default charset!
'sfw_logs' => 'CREATE TABLE IF NOT EXISTS `%scleantalk_sfw_logs` (
`id` VARCHAR(40) NOT NULL,
`ip` VARCHAR(15) NOT NULL,
`status` ENUM(\'PASS_SFW\',\'DENY_SFW\',\'PASS_SFW__BY_WHITELIST\',\'PASS_SFW__BY_COOKIE\',\'DENY_ANTICRAWLER\',\'PASS_ANTICRAWLER\',\'DENY_ANTICRAWLER_UA\',\'PASS_ANTICRAWLER_UA\',\'DENY_ANTIFLOOD\',\'PASS_ANTIFLOOD\') NULL DEFAULT NULL,
`all_entries` INT NOT NULL,
`blocked_entries` INT NOT NULL,
`entries_timestamp` INT NOT NULL,
`ua_id` INT(11) NULL DEFAULT NULL,
`ua_name` VARCHAR(1024) NOT NULL,
`source` TINYINT(1) NULL DEFAULT NULL,
`network` VARCHAR(20) NOT NULL,
`first_url` VARCHAR(100) NOT NULL,
`last_url` VARCHAR(100) NOT NULL,
PRIMARY KEY (`id`));',
'ac_logs' => 'CREATE TABLE IF NOT EXISTS `%scleantalk_ac_logs` (
`id` VARCHAR(40) NOT NULL,
`ip` VARCHAR(40) NOT NULL,
`ua` VARCHAR(40) NOT NULL,
`entries` INT DEFAULT 0,
`interval_start` INT NOT NULL,
PRIMARY KEY (`id`));',
);