SpamFerret/tables/text

About

 * Purpose: for storing complete text of edit attempts and page contents
 * History:
 * 2009-08-07 Designed; not deployed yet

SQL
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;