MWX/SpamFerret/tables/attempt: Difference between revisions
< MWX | SpamFerret | tables
Jump to navigation
Jump to search
(about - fields) |
(ID_Archive) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''History''': | |||
** '''2009-08-05''' Added '''ID_Archive''' | |||
* '''Fields''': | * '''Fields''': | ||
** '''Code''': | ** '''Code''': | ||
| Line 7: | Line 9: | ||
** '''MatchText''': mainly useful for regex filters and (especially) non-listable offenses | ** '''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_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. | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `attempts` ( | <mysql>CREATE TABLE `attempts` ( | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`When` DATETIME COMMENT "timestamp of attempt", | `When` DATETIME COMMENT "timestamp of attempt", | ||
`ID_Pattern` INT DEFAULT NULL COMMENT "(patterns.ID) | `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", | `ID_Client` INT NOT NULL COMMENT "(clients.ID) spamming client", | ||
`IDS_Session` varchar(255) COMMENT "PHP session ID from session_id()", | `IDS_Session` varchar(255) COMMENT "PHP session ID from session_id()", | ||
Revision as of 22:49, 5 August 2009
About
- History:
- 2009-08-05 Added ID_Archive
- 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.
- 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", `Diff` MEDIUMTEXT COMMENT "difference between original and attempted edit", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>