20170907.ferret.20.project.field.sql
184f201ce29amaster

20170907.ferret.20.project.field.sql
View Options

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