MWX/SpamFerret/tables/attempt: Difference between revisions
< MWX | SpamFerret | tables
Jump to navigation
Jump to search
(ID_Archive) |
(8/7: "Edit" field) |
||
| Line 2: | Line 2: | ||
* '''History''': | * '''History''': | ||
** '''2009-08-05''' Added '''ID_Archive''' | ** '''2009-08-05''' Added '''ID_Archive''' | ||
** '''2009-08-07''' Added '''Edit''' | |||
* '''Fields''': | * '''Fields''': | ||
** '''Code''': | ** '''Code''': | ||
| Line 10: | Line 11: | ||
** '''ID_Pattern''' needs to allow NULL in order to log throttled saves with no pattern match | ** '''ID_Pattern''' needs to allow NULL in order to log throttled saves with no pattern match | ||
** '''ID_Archive''' means the same thing as ID_Pattern, but refers to {{spamferret|table|pattern_archive}} instead of {{spamferret|table|patterns}}. This is DEFAULT NULL for backward compatibility. | ** '''ID_Archive''' means the same thing as ID_Pattern, but refers to {{spamferret|table|pattern_archive}} instead of {{spamferret|table|patterns}}. This is DEFAULT NULL for backward compatibility. | ||
** '''Edit''': text of submitted edit | |||
** '''Diff''': diff between submitted edit and existing text | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `attempts` ( | <mysql>CREATE TABLE `attempts` ( | ||
| Line 23: | Line 26: | ||
`MatchText` varchar(255) DEFAULT NULL COMMENT "optional: text that triggered the filter", | `MatchText` varchar(255) DEFAULT NULL COMMENT "optional: text that triggered the filter", | ||
`didAllow` TINYINT(1) DEFAULT FALSE COMMENT "edit was allowed", | `didAllow` TINYINT(1) DEFAULT FALSE COMMENT "edit was allowed", | ||
`Edit` MEDIUMTEXT COMMENT "submitted text", | |||
`Diff` MEDIUMTEXT COMMENT "difference between original and attempted edit", | `Diff` MEDIUMTEXT COMMENT "difference between original and attempted edit", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
Revision as of 23:17, 7 August 2009
About
- History:
- 2009-08-05 Added ID_Archive
- 2009-08-07 Added Edit
- Fields:
- Code:
- NULL = normal filter match
- "AMP" = ampersandbot (to be eventually superceded by some kind of difference-pattern)
- "THR" = throttled: too many spam attempts, temporary blacklist of IP address
- MatchText: mainly useful for regex filters and (especially) non-listable offenses
- ID_Pattern needs to allow NULL in order to log throttled saves with no pattern match
- ID_Archive means the same thing as ID_Pattern, but refers to Template:Spamferret instead of Template:Spamferret. This is DEFAULT NULL for backward compatibility.
- Edit: text of submitted edit
- Diff: diff between submitted edit and existing text
- Code:
SQL
<mysql>CREATE TABLE `attempts` (
`ID` INT NOT NULL AUTO_INCREMENT, `When` DATETIME COMMENT "timestamp of attempt", `ID_Pattern` INT DEFAULT NULL COMMENT "(patterns.ID) pattern matched", `ID_Archive` INT DEFAULT NULL COMMENT "(pattern_archive.ID) pattern matched", `ID_Client` INT NOT NULL COMMENT "(clients.ID) spamming client", `IDS_Session` varchar(255) COMMENT "PHP session ID from session_id()", `Code` varchar(15) COMMENT "type of attempt", `PageServer` varchar(63) COMMENT "identifier of wiki being attacked (usually domain)", `PageName` varchar(255) COMMENT "name of page where the spam would have displayed", `MatchText` varchar(255) DEFAULT NULL COMMENT "optional: text that triggered the filter", `didAllow` TINYINT(1) DEFAULT FALSE COMMENT "edit was allowed", `Edit` MEDIUMTEXT COMMENT "submitted text", `Diff` MEDIUMTEXT COMMENT "difference between original and attempted edit", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>