20170907.ferret.08.passphrase.field.sql
4c5f0f007d75stable

20170907.ferret.08.passphrase.field.sql
View Options

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