20150105.conpsearch.sql
No OneTemporary
Actions

Size

578 B

Referenced Files

None

Subscribers

None

20150105.conpsearch.sql
View Options

	CREATE TABLE {$NAMESPACE}_conpherence.conpherence_index (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	threadPHID VARBINARY(64) NOT NULL,
	transactionPHID VARBINARY(64) NOT NULL,
	previousTransactionPHID VARBINARY(64),
	corpus longtext
	CHARACTER SET {$CHARSET_FULLTEXT}
	COLLATE {$COLLATE_FULLTEXT}
	NOT NULL,
	KEY `key_thread` (threadPHID),
	UNIQUE KEY `key_transaction` (transactionPHID),
	UNIQUE KEY `key_previous` (previousTransactionPHID),
	FULLTEXT KEY `key_corpus` (corpus)
	) ENGINE=MyISAM DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT};