Differential D16981 Diff 41128 resources/sql/autopatches/20161201.release.1.sql

Changeset View

Standalone View

resources/sql/autopatches/20161201.release.1.sql

This file was added.

				CREATE TABLE {$NAMESPACE}_release.release_release (
				`id` INT unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY ,
				`phid` VARBINARY(64) NOT NULL,
				`name` VARCHAR(128) COLLATE {$COLLATE_SORT} NOT NULL,
				`description` LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
				`state` VARCHAR(12) COLLATE {$COLLATE_TEXT} NOT NULL,
				`mailKey` BINARY(20) NOT NULL,
				`dateCreated` INT unsigned NOT NULL,
				`dateModified` INT unsigned NOT NULL,
				`details` LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
				`releaseTemplateKey` VARCHAR(12) COLLATE {$COLLATE_TEXT} NOT NULL,
				`viewPolicy` VARBINARY(64) NOT NULL,
				`editPolicy` VARBINARY(64) NOT NULL,

				UNIQUE KEY `key_phid` (`phid`),
				KEY `key_name` (`name`),
				KEY `key_state` (`state`)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

				CREATE TABLE {$NAMESPACE}_release.release_releasetransaction (
				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};

				CREATE TABLE {$NAMESPACE}_release.release_releasetransaction_comment (
				id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
				phid VARBINARY(64) NOT NULL,
				transactionPHID VARBINARY(64),
				authorPHID VARBINARY(64) NOT NULL,
				viewPolicy VARBINARY(64) NOT NULL,
				editPolicy VARBINARY(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};