MWX/SpamFerret/tables/text
< MWX | SpamFerret | tables
Jump to navigation
Jump to search
About
- Purpose: for storing complete text of edit attempts and page contents
- History:
- 2009-08-07 Designed; not deployed yet
SQL
<mysql>CREATE TABLE `text` (
`CRC` INT UNSIGNED NOT NULL COMMENT "crc32(text) for faster indexing", `ctext` MEDIUMBLOB COMMENT "compressed form of text", PRIMARY KEY(`CRC`)
) ENGINE = MYISAM;</mysql>