20190410.portals.02.ferret.field.sql
89d038f53e8emaster

20190410.portals.02.ferret.field.sql
View Options

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