20170907.ferret.23.phriction.field.sql
a25bbc1dcab4master

20170907.ferret.23.phriction.field.sql
View Options

			CREATE TABLE {$NAMESPACE}_phriction.phriction_document_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};