MWX/SpamFerret/tables/pattern archive: Difference between revisions
< MWX | SpamFerret | tables
Jump to navigation
Jump to search
(Created page with '==About== * '''History''': ** '''2009-08-05''' Created for Special:SpamFerret ==SQL== <mysql>CREATE TABLE `pattern_archive` ( `ID` INT NOT NULL AUTO_INCREMENT, `ID_Pattern` I…') |
("ID_Pattern" is unnecessary; removing it. Added field for human-entered notes.) |
||
| Line 5: | Line 5: | ||
<mysql>CREATE TABLE `pattern_archive` ( | <mysql>CREATE TABLE `pattern_archive` ( | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`isURL` TINYINT(1) COMMENT "TRUE indicates that additional URL-related stats may be collected", | `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())", | `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", | `isDiff` TINYINT(1) DEFAULT FALSE COMMENT "TRUE = pattern should be compared to the diff, not the edit contents", | ||
`Count` INT DEFAULT 0 COMMENT "number of attempts", | `Count` INT DEFAULT 0 COMMENT "number of attempts", | ||
`Notes` VARCHAR(255) COMMENT "human-entered notes", | |||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = MYISAM;</mysql> | ENGINE = MYISAM;</mysql> | ||
Revision as of 20:54, 5 August 2009
About
- History:
- 2009-08-05 Created for Special:SpamFerret
SQL
<mysql>CREATE TABLE `pattern_archive` (
`ID` INT NOT NULL AUTO_INCREMENT, `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", `Count` INT DEFAULT 0 COMMENT "number of attempts", `Notes` VARCHAR(255) COMMENT "human-entered notes", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>