Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/autopatches/20140619.chronicle.2.sql
- This file was added.
CREATE TABLE {$NAMESPACE}_chronicle.chronicle_triggertransaction ( | |||||
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, | |||||
phid VARCHAR(64) NOT NULL COLLATE utf8_bin, | |||||
authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin, | |||||
objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin, | |||||
viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin, | |||||
editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin, | |||||
commentPHID VARCHAR(64) COLLATE utf8_bin, | |||||
commentVersion INT UNSIGNED NOT NULL, | |||||
transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin, | |||||
oldValue LONGTEXT NOT NULL COLLATE utf8_bin, | |||||
newValue LONGTEXT NOT NULL COLLATE utf8_bin, | |||||
contentSource LONGTEXT NOT NULL COLLATE utf8_bin, | |||||
metadata LONGTEXT NOT NULL COLLATE utf8_bin, | |||||
dateCreated INT UNSIGNED NOT NULL, | |||||
dateModified INT UNSIGNED NOT NULL, | |||||
UNIQUE KEY `key_phid` (phid), | |||||
KEY `key_object` (objectPHID) | |||||
) ENGINE=InnoDB, COLLATE utf8_general_ci; |