1
CREATE TABLE {$NAMESPACE}_herald.herald_ruletransaction (
2
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
3
phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
4
authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
5
objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
6
viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
7
editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
8
commentPHID VARCHAR(64) COLLATE utf8_bin,
9
commentVersion INT UNSIGNED NOT NULL,
10
transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
11
oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
12
newValue LONGTEXT NOT NULL COLLATE utf8_bin,
13
contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
14
metadata LONGTEXT NOT NULL COLLATE utf8_bin,
15
dateCreated INT UNSIGNED NOT NULL,
16
dateModified INT UNSIGNED NOT NULL,
18
UNIQUE KEY `key_phid` (phid),
19
KEY `key_object` (objectPHID)
21
) ENGINE=InnoDB, COLLATE utf8_general_ci;
23
CREATE TABLE {$NAMESPACE}_herald.herald_ruletransaction_comment (
24
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
25
phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
26
transactionPHID VARCHAR(64) COLLATE utf8_bin,
27
authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
28
viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
29
editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
30
commentVersion INT UNSIGNED NOT NULL,
31
content LONGTEXT NOT NULL COLLATE utf8_bin,
32
contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
33
isDeleted BOOL NOT NULL,
34
dateCreated INT UNSIGNED NOT NULL,
35
dateModified INT UNSIGNED NOT NULL,
37
UNIQUE KEY `key_phid` (phid),
38
UNIQUE KEY `key_version` (transactionPHID, commentVersion)
40
) ENGINE=InnoDB, COLLATE utf8_general_ci;