plugin_install.sql

CREATE TABLE IF NOT EXISTS !PREFIX!bad_behavior (`idbad_behavior` INT(11) NOT NULL auto_increment,`ip` TEXT NOT NULL,`date` DATETIME NOT NULL default '0000-00-00 00:00:00',`request_method` TEXT NOT NULL,`request_uri` TEXT NOT NULL,`server_protocol` TEXT NOT NULL,`http_headers` TEXT NOT NULL,`user_agent` TEXT NOT NULL,`request_entity` TEXT NOT NULL,`key` TEXT NOT NULL,INDEX (`ip`(15)),INDEX (`user_agent`(10)),PRIMARY KEY (`idbad_behavior`) );