20170907.ferret.05.fund.field.sql
No OneTemporary
Actions

Size

413 B

Referenced Files

None

Subscribers

None

20170907.ferret.05.fund.field.sql
View Options

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