recaptime.dev
@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.)
hq.recaptime.dev/wiki/Phorge
phorge
phabricator
1DROP TABLE {$NAMESPACE}_pholio.pholio_transaction;
2DROP TABLE {$NAMESPACE}_pholio.pholio_pixelcomment;
3
4CREATE TABLE {$NAMESPACE}_pholio.pholio_transaction (
5 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
6 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
7 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
8 objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
9 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
10 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
11 commentPHID VARCHAR(64) COLLATE utf8_bin,
12 commentVersion INT UNSIGNED NOT NULL,
13 transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
14 oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
15 newValue LONGTEXT NOT NULL COLLATE utf8_bin,
16 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
17 dateCreated INT UNSIGNED NOT NULL,
18 dateModified INT UNSIGNED NOT NULL,
19
20 UNIQUE KEY `key_phid` (phid),
21 KEY `key_object` (objectPHID)
22
23) ENGINE=InnoDB, COLLATE utf8_general_ci;
24
25CREATE TABLE {$NAMESPACE}_pholio.pholio_transaction_comment (
26 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
27 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
28 transactionPHID VARCHAR(64) COLLATE utf8_bin,
29 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
30 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
31 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
32 commentVersion INT UNSIGNED NOT NULL,
33 content LONGTEXT NOT NULL COLLATE utf8_bin,
34 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
35 isDeleted BOOL NOT NULL,
36 dateCreated INT UNSIGNED NOT NULL,
37 dateModified INT UNSIGNED NOT NULL,
38
39 mockID INT UNSIGNED,
40 imageID INT UNSIGNED,
41 x INT UNSIGNED,
42 y INT UNSIGNED,
43 width INT UNSIGNED,
44 height INT UNSIGNED,
45
46 UNIQUE KEY `key_phid` (phid),
47 UNIQUE KEY `key_version` (transactionPHID, commentVersion),
48 UNIQUE KEY `key_draft` (authorPHID, mockID, transactionPHID)
49
50) ENGINE=InnoDB, COLLATE utf8_general_ci;