MWX/SpamFerret/tables/text: Difference between revisions
< MWX | SpamFerret | tables
Jump to navigation
Jump to search
m (fixed SQL for table name) |
m (2 revisions imported: moving here) |
(No difference)
| |
Revision as of 20:10, 1 May 2022
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>