MWX/SpamFerret/tables/pattern archive: Difference between revisions

From Woozle Writes Code
< MWX‎ | SpamFerret‎ | tables
Jump to navigation Jump to search
m (3 revisions imported: moving here)
m (Woozle moved page SpamFerret/tables/pattern archive to MWX/SpamFerret/tables/pattern archive without leaving a redirect: most mediawiki extensions belong under MWX now)
 
(No difference)

Latest revision as of 20:14, 1 May 2022

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

<mysql>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;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=MWX/SpamFerret/tables/pattern_archive&oldid=1344"