SpamFerret/tables/pattern archive

About

 * History:
 * 2009-08-05 Created for Special:SpamFerret
 * 2011-02-03 Substantial rework -- needed a field to store the text, for one thing. Decided not to collect any stats here, for another.

SQL
CREATE TABLE `pattern_archive` ( `ID` INT NOT NULL AUTO_INCREMENT,  `Pattern`   VARCHAR(255)     NOT NULL  COMMENT "pattern to match (regex or straight text match)",  `isURL`     TINYINT(1)                 COMMENT "TRUE indicates that additional URL-related stats may be collected",  `isRegex`   TINYINT(1)                 COMMENT "TRUE = regex (use preg_match); FALSE = normal string comparison (use stristr)",  `isDiff`    TINYINT(1)   DEFAULT FALSE COMMENT "TRUE = pattern should be compared to the diff, not the edit contents",  `Notes`     VARCHAR(255) DEFAULT NULL  COMMENT "human-entered notes",  PRIMARY KEY(`ID`) ) ENGINE = MYISAM;