20160331.fund.comments.1.sql
No OneTemporary
Actions

Size

679 B

Referenced Files

None

Subscribers

None

20160331.fund.comments.1.sql
View Options

	CREATE TABLE {$NAMESPACE}_fund.fund_initiativetransaction_comment (
	id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
	phid VARCHAR(64) NOT NULL,
	transactionPHID VARCHAR(64),
	authorPHID VARCHAR(64) NOT NULL,
	viewPolicy VARCHAR(64) NOT NULL,
	editPolicy VARCHAR(64) NOT NULL,
	commentVersion INT UNSIGNED NOT NULL,
	content LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
	contentSource LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
	isDeleted BOOL NOT NULL,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,

	UNIQUE KEY `key_phid` (phid),
	UNIQUE KEY `key_version` (transactionPHID, commentVersion)

	) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

File Metadata

Mime Type: text/plain
Expires: Jan 19 2025, 21:13 (6 w, 1 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1128826
Default Alt Text: 20160331.fund.comments.1.sql (679 B)

Event Timeline