File: update-dummy.sql

-- FloodAssassin UPDATED SQL-Dummy
-- For help visit http://projects.citrosaft.com/floodassassin
-- Tutorial under http://projects.citrosaft.com/floodassassin/tutorial.php

-- change current table and add a new column
ALTER TABLE `floodrules` ADD `rule_contentcount` FLOAT NOT NULL AFTER `rule_content`;

-- insert new rule
INSERT INTO `floodrules` INSERT INTO `floodrules` (`rule_id`, `rule_content`, `rule_contentcount`, `rule_name`, `rule_mail`, `rule_ip`, `rule_modifier`, `rule_contentlevel`, `rule_namelevel`, `rule_maillevel`, `rule_iplevel`, `rule_description`) VALUES (NULL, '%link[\\s]*[\\w\\d]{20,}', '', '', '', '', '', 0, 0, 0, 0, 'LINK FOO'),
(11, '', 0, '', '', '60.190.240.73', '', 0, 0, 0, 2.9, 'FLOODIP [60.190.240.73]');