View source for MWX/SpamFerret/tables/pattern log

==About==
* '''Rules''':
** '''adding a new pattern''':
**# if new pattern not in archive, add an entry for it
**# log event with isWrite=TRUE and ID_Archive pointing to new pattern
**# add the pattern record to {{spamferret|table|patterns}}
** '''modifying a pattern''':
**# if old pattern not in archive, add an entry for it
**# log event with isWrite=FALSE and ID_Archive pointing to old pattern
**# if new pattern not in archive, add an entry for it
**# log event with isWrite=TRUE and ID_Archive pointing to new pattern
**# modify the record in {{spamferret|table|patterns}}
** '''retiring a pattern''':
**# if old pattern not in archive, add an entry for it
**# log event with isWrite=FALSE and ID_Archive pointing to old pattern
**# log event with isWrite=TRUE and ID_Archive = NULL
* '''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_Archive` INT DEFAULT NULL COMMENT "pattern_archive.ID of archived pattern being accessed",
  `isWrite` TINYINT(1) NOT NULL COMMENT "type of event"
)ENGINE = MYISAM;</mysql>