MWX/SpamFerret/tables/pattern log
< MWX | SpamFerret | tables
Jump to navigation
Jump to search
About
- Rules:
- adding a new pattern:
- if new pattern not in archive, add an entry for it
- log event: ID_Old=NULL, ID_New= new pattern
- add the pattern record to Template:Spamferret
- modifying a pattern:
- if old pattern not in archive, add an entry for it
- if new pattern not in archive, add an entry for it
- log event: ID_Old= old pattern, ID_New= new pattern
- modify the record in Template:Spamferret
- retiring a pattern:
- if old pattern not in archive, add an entry for it
- log event: ID_Old= old pattern, ID_New = NULL
- delete the record in Template:Spamferret
- adding a new pattern:
- History:
- 2009-08-05 Created for Special:SpamFerret
SQL
<mysql>CREATE TABLE `pattern_log` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Pattern` INT NOT NULL COMMENT "patterns.ID of pattern being altered", `ID_Old` INT DEFAULT NULL COMMENT "pattern_archive.ID of old value of pattern being edited", `ID_New` INT DEFAULT NULL COMMENT "pattern_archive.ID of new value of pattern being edited", `Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes explaining reason for change"
)ENGINE = MYISAM;</mysql>