MWX/SpamFerret/tables/text

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>