PHP Classes

File: update-dummy.sql

Recommend this page to a friend!
  Classes of Benjamin Falk  >  Flood Assassin  >  update-dummy.sql  >  Download  
File: update-dummy.sql
Role: Auxiliary data
Content type: text/plain
Description: For updating the old version
Class: Flood Assassin
Check whether a message can be spam
Author: By
Last change: Updated update-dummy.sql and fixed mistakes
Date: 13 years ago
Size: 748 bytes


Class file image Download
-- FloodAssassin UPDATED SQL-Dummy
-- For help visit
-- Tutorial under

-- 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, '', '', '', '', 0, 0, 0, 2.9, 'FLOODIP []');
For more information send a message to info at phpclasses dot org.