MWX/SpamFerret/tables/text: Difference between revisions
< MWX | SpamFerret | tables
Jump to navigation
Jump to search
(Created page with '==About== * '''Purpose''': for storing complete text of edit attempts and page contents * '''History''': ** '''2009-08-07''' Designed; not deployed yet ==SQL== <mysql>CREATE TABL…') |
(No difference)
|
Revision as of 20:48, 7 August 2009
About
- Purpose: for storing complete text of edit attempts and page contents
- History:
- 2009-08-07 Designed; not deployed yet
SQL
<mysql>CREATE TABLE `attempts` (
`CRC` INT UNSIGNED NOT NULL COMMENT "crc32(text) for faster indexing", `ctext` MEDIUMBLOB COMMENT "compressed form of text", PRIMARY KEY(`CRC`)
) ENGINE = MYISAM;</mysql>