20200416.paste.02.ferret.field.sql
ef1340bd3207master

20200416.paste.02.ferret.field.sql
View Options

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