20140722.audit.2.comments.sql
No OneTemporary
Actions

Size

1 KB

Subscribers

None

20140722.audit.2.comments.sql
View Options

	CREATE TABLE {$NAMESPACE}_audit.audit_transaction_comment (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	phid VARCHAR(64) COLLATE utf8_bin NOT NULL,
	transactionPHID VARCHAR(64) COLLATE utf8_bin,
	authorPHID VARCHAR(64) COLLATE utf8_bin NOT NULL,
	viewPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,
	editPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,
	commentVersion INT UNSIGNED NOT NULL,
	content longtext COLLATE utf8_bin NOT NULL,
	contentSource longtext COLLATE utf8_bin NOT NULL,
	isDeleted BOOL NOT NULL,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	commitPHID VARCHAR(64) COLLATE utf8_bin,
	pathID INT UNSIGNED,
	isNewFile BOOL NOT NULL,
	lineNumber INT UNSIGNED NOT NULL,
	lineLength INT UNSIGNED NOT NULL,
	fixedState VARCHAR(12) COLLATE utf8_bin,
	hasReplies BOOL NOT NULL,
	replyToCommentPHID VARCHAR(64) COLLATE utf8_bin,
	legacyCommentID INT UNSIGNED,
	UNIQUE KEY `key_phid` (phid),
	UNIQUE KEY `key_version` (transactionPHID, commentVersion),
	KEY `key_path` (pathID),
	KEY `key_draft` (authorPHID, transactionPHID),
	KEY `key_commit` (commitPHID),
	KEY `key_legacy` (legacyCommentID)
	) ENGINE=InnoDB, COLLATE utf8_general_ci;