Differential D17020 Diff 41522 resources/sql/autopatches/20161220.release.changes.sql

Changeset View

Standalone View

resources/sql/autopatches/20161220.release.changes.sql

This file was added.

Property	Old Value	New Value
File Mode	null	100755

				CREATE TABLE {$NAMESPACE}_release.release_changerequest (
				Lint: Invalid Executable Inline Actions Executable files should either be binary or contain a shebang. Lint: Invalid Executable: Executable files should either be binary or contain a shebang.
				id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
				phid VARBINARY(64) NOT NULL,
				requestedObjectPHID VARBINARY(64) NOT NULL,
				description longtext COLLATE {$COLLATE_TEXT} NOT NULL,
				status VARCHAR(32) COLLATE {$COLLATE_TEXT} NOT NULL,
				requestorPHID VARBINARY(64) NOT NULL,
				releasePHID VARBINARY(64) NOT NULL,
				details longtext COLLATE {$COLLATE_TEXT} NOT NULL,
				implementationKey VARCHAR(32) COLLATE {$COLLATE_TEXT} NOT NULL,
				dateCreated INT(10) UNSIGNED NOT NULL,
				dateModified INT(10) UNSIGNED NOT NULL,

				UNIQUE KEY `key_phid` (`phid`),
				KEY `key_release` (`releasePHID`)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

				CREATE TABLE {$NAMESPACE}_release.release_changerequesttransaction (
				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_changerequestcustomfieldstorage (
				id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
				objectPHID VARBINARY(64) NOT NULL,
				fieldIndex BINARY(12) NOT NULL,
				fieldValue LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT},
				UNIQUE KEY (objectPHID, fieldIndex)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

				CREATE TABLE {$NAMESPACE}_release.release_changerequestcustomfieldstringindex (
				id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
				objectPHID VARBINARY(64) NOT NULL,
				indexKey BINARY(12) NOT NULL,
				indexValue LONGTEXT NOT NULL COLLATE {$COLLATE_SORT},
				KEY `key_join` (objectPHID, indexKey, indexValue(64)),
				KEY `key_find` (indexKey, indexValue(64))
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};

				CREATE TABLE {$NAMESPACE}_release.release_changerequestcustomfieldnumericindex (
				id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
				objectPHID VARBINARY(64) NOT NULL,
				indexKey BINARY(12) NOT NULL,
				indexValue BIGINT NOT NULL,
				KEY `key_join` (objectPHID, indexKey, indexValue),
				KEY `key_find` (indexKey, indexValue)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};