MWX/SpamFerret/tables/pattern log

About

• Rules:
  • adding a new pattern:
    1. if new pattern not in archive, add an entry for it
    2. log event: ID_Old=NULL, ID_New= new pattern
    3. add the pattern record to Template:Spamferret
  • modifying a pattern:
    1. if old pattern not in archive, add an entry for it
    2. if new pattern not in archive, add an entry for it
    3. log event: ID_Old= old pattern, ID_New= new pattern
    4. modify the record in Template:Spamferret and increment count in archive
  • retiring a pattern:
    1. if old pattern not in archive, add an entry for it
    2. log event: ID_Old= old pattern, ID_New = NULL
    3. delete the record in Template:Spamferret and increment count in archive
• 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",
 `UserName` VARCHAR(255)     NOT NULL COMMENT "username of administrator who made this pattern change",
 `UserSite` VARCHAR(63)  DEFAULT NULL COMMENT "identifier of site from which pattern is being changed (optional)",
 `Notes`    VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes explaining reason for change (optional)",
 PRIMARY KEY(`ID`)

)ENGINE = MYISAM;</mysql>