20151106.editengine.2.xactions.sql
No OneTemporary
Actions

Size

863 B

Referenced Files

None

Subscribers

None

20151106.editengine.2.xactions.sql
View Options

	CREATE TABLE {$NAMESPACE}_search.search_editengineconfigurationtransaction (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	phid VARBINARY(64) NOT NULL,
	authorPHID VARBINARY(64) NOT NULL,
	objectPHID VARBINARY(64) NOT NULL,
	viewPolicy VARBINARY(64) NOT NULL,
	editPolicy VARBINARY(64) NOT NULL,
	commentPHID VARBINARY(64) DEFAULT NULL,
	commentVersion INT UNSIGNED NOT NULL,
	transactionType VARCHAR(32) COLLATE {$COLLATE_TEXT} NOT NULL,
	oldValue LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
	newValue LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
	contentSource LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
	metadata LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	UNIQUE KEY `key_phid` (`phid`),
	KEY `key_object` (`objectPHID`)
	) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

File Metadata

Mime Type: text/plain
Expires: Sun, Jan 19, 18:03 (1 w, 5 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1127227
Default Alt Text: 20151106.editengine.2.xactions.sql (863 B)

Event Timeline