Changeset View
Changeset View
Standalone 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}; |