20171026.ferret.02.ponder.field.sql

CREATE TABLE {$NAMESPACE}_ponder.ponder_question_ffield (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  documentID INT UNSIGNED NOT NULL,
  fieldKey VARCHAR(4) NOT NULL COLLATE {$COLLATE_TEXT},
  rawCorpus LONGTEXT NOT NULL COLLATE {$COLLATE_SORT},
  termCorpus LONGTEXT NOT NULL COLLATE {$COLLATE_SORT},
  normalCorpus LONGTEXT NOT NULL COLLATE {$COLLATE_SORT}
) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};