@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
1CREATE TABLE {$NAMESPACE}_nuance.nuance_item (
2 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
3 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
4 ownerPHID VARCHAR(64) COLLATE utf8_bin,
5 requestorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
6 sourcePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
7 sourceLabel VARCHAR(255),
8 status INT UNSIGNED NOT NULL,
9 data longtext NOT NULL COLLATE utf8_bin,
10 mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin,
11 dateCreated INT UNSIGNED NOT NULL,
12 dateModified INT UNSIGNED NOT NULL,
13 dateNuanced INT UNSIGNED NOT NULL,
14 UNIQUE KEY `key_phid` (phid),
15 KEY `key_source` (sourcePHID, status, dateNuanced, id),
16 KEY `key_owner` (ownerPHID, status, dateNuanced, id),
17 KEY `key_contacter` (requestorPHID, status, dateNuanced, id)
18) ENGINE=InnoDB, COLLATE utf8_general_ci;
19
20CREATE TABLE {$NAMESPACE}_nuance.nuance_itemtransaction (
21 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
22 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
23 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
24 objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
25 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
26 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
27 commentPHID VARCHAR(64) COLLATE utf8_bin,
28 commentVersion INT UNSIGNED NOT NULL,
29 transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
30 oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
31 newValue LONGTEXT NOT NULL COLLATE utf8_bin,
32 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
33 metadata LONGTEXT NOT NULL COLLATE utf8_bin,
34 dateCreated INT UNSIGNED NOT NULL,
35 dateModified INT UNSIGNED NOT NULL,
36
37 UNIQUE KEY `key_phid` (phid),
38 KEY `key_object` (objectPHID)
39
40) ENGINE=InnoDB, COLLATE utf8_general_ci;
41
42CREATE TABLE {$NAMESPACE}_nuance.nuance_itemtransaction_comment (
43 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
44 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
45 transactionPHID VARCHAR(64) COLLATE utf8_bin,
46 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
47 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
48 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
49 commentVersion INT UNSIGNED NOT NULL,
50 content LONGTEXT NOT NULL COLLATE utf8_bin,
51 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
52 isDeleted BOOL NOT NULL,
53 dateCreated INT UNSIGNED NOT NULL,
54 dateModified INT UNSIGNED NOT NULL,
55
56 UNIQUE KEY `key_phid` (phid),
57 UNIQUE KEY `key_version` (transactionPHID, commentVersion)
58
59) ENGINE=InnoDB, COLLATE utf8_general_ci;
60
61CREATE TABLE {$NAMESPACE}_nuance.nuance_source (
62 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
63 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
64 name VARCHAR(255),
65 type INT UNSIGNED NOT NULL,
66 data longtext NOT NULL COLLATE utf8_bin,
67 mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin,
68 viewPolicy VARCHAR(64) NOT NULL,
69 editPolicy VARCHAR(64) NOT NULL,
70 dateCreated INT UNSIGNED NOT NULL,
71 dateModified INT UNSIGNED NOT NULL,
72 UNIQUE KEY `key_phid` (phid),
73 KEY `key_type` (type, dateModified)
74) ENGINE=InnoDB, COLLATE utf8_general_ci;
75
76CREATE TABLE {$NAMESPACE}_nuance.nuance_sourcetransaction (
77 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
78 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
79 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
80 objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
81 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
82 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
83 commentPHID VARCHAR(64) COLLATE utf8_bin,
84 commentVersion INT UNSIGNED NOT NULL,
85 transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
86 oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
87 newValue LONGTEXT NOT NULL COLLATE utf8_bin,
88 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
89 metadata LONGTEXT NOT NULL COLLATE utf8_bin,
90 dateCreated INT UNSIGNED NOT NULL,
91 dateModified INT UNSIGNED NOT NULL,
92
93 UNIQUE KEY `key_phid` (phid),
94 KEY `key_object` (objectPHID)
95
96) ENGINE=InnoDB, COLLATE utf8_general_ci;
97
98CREATE TABLE {$NAMESPACE}_nuance.nuance_sourcetransaction_comment (
99 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
100 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
101 transactionPHID VARCHAR(64) COLLATE utf8_bin,
102 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
103 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
104 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
105 commentVersion INT UNSIGNED NOT NULL,
106 content LONGTEXT NOT NULL COLLATE utf8_bin,
107 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
108 isDeleted BOOL NOT NULL,
109 dateCreated INT UNSIGNED NOT NULL,
110 dateModified INT UNSIGNED NOT NULL,
111
112 UNIQUE KEY `key_phid` (phid),
113 UNIQUE KEY `key_version` (transactionPHID, commentVersion)
114
115) ENGINE=InnoDB, COLLATE utf8_general_ci;
116
117CREATE TABLE {$NAMESPACE}_nuance.nuance_queue (
118 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
119 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
120 name VARCHAR(255),
121 mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin,
122 viewPolicy VARCHAR(64) NOT NULL,
123 editPolicy VARCHAR(64) NOT NULL,
124 dateCreated INT UNSIGNED NOT NULL,
125 dateModified INT UNSIGNED NOT NULL,
126 UNIQUE KEY `key_phid` (phid)
127) ENGINE=InnoDB, COLLATE utf8_general_ci;
128
129CREATE TABLE {$NAMESPACE}_nuance.nuance_queuetransaction (
130 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
131 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
132 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
133 objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
134 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
135 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
136 commentPHID VARCHAR(64) COLLATE utf8_bin,
137 commentVersion INT UNSIGNED NOT NULL,
138 transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
139 oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
140 newValue LONGTEXT NOT NULL COLLATE utf8_bin,
141 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
142 metadata LONGTEXT NOT NULL COLLATE utf8_bin,
143 dateCreated INT UNSIGNED NOT NULL,
144 dateModified INT UNSIGNED NOT NULL,
145
146 UNIQUE KEY `key_phid` (phid),
147 KEY `key_object` (objectPHID)
148
149) ENGINE=InnoDB, COLLATE utf8_general_ci;
150
151CREATE TABLE {$NAMESPACE}_nuance.nuance_queuetransaction_comment (
152 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
153 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
154 transactionPHID VARCHAR(64) COLLATE utf8_bin,
155 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
156 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
157 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
158 commentVersion INT UNSIGNED NOT NULL,
159 content LONGTEXT NOT NULL COLLATE utf8_bin,
160 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
161 isDeleted BOOL NOT NULL,
162 dateCreated INT UNSIGNED NOT NULL,
163 dateModified INT UNSIGNED NOT NULL,
164
165 UNIQUE KEY `key_phid` (phid),
166 UNIQUE KEY `key_version` (transactionPHID, commentVersion)
167
168) ENGINE=InnoDB, COLLATE utf8_general_ci;
169
170CREATE TABLE {$NAMESPACE}_nuance.nuance_queueitem (
171 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
172 queuePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
173 itemPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
174 itemStatus INT UNSIGNED NOT NULL,
175 itemDateNuanced INT UNSIGNED NOT NULL,
176 dateCreated INT UNSIGNED NOT NULL,
177 dateModified INT UNSIGNED NOT NULL,
178 UNIQUE KEY `key_one_per_queue` (itemPHID, queuePHID),
179 KEY `key_queue` (queuePHID, itemStatus, itemDateNuanced, id)
180) ENGINE=InnoDB, COLLATE utf8_general_ci;
181
182CREATE TABLE {$NAMESPACE}_nuance.nuance_requestor (
183 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
184 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
185 data longtext NOT NULL COLLATE utf8_bin,
186 dateCreated INT UNSIGNED NOT NULL,
187 dateModified INT UNSIGNED NOT NULL,
188 UNIQUE KEY `key_phid` (phid)
189) ENGINE=InnoDB, COLLATE utf8_general_ci;
190
191CREATE TABLE {$NAMESPACE}_nuance.nuance_requestortransaction (
192 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
193 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
194 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
195 objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
196 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
197 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
198 commentPHID VARCHAR(64) COLLATE utf8_bin,
199 commentVersion INT UNSIGNED NOT NULL,
200 transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
201 oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
202 newValue LONGTEXT NOT NULL COLLATE utf8_bin,
203 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
204 metadata LONGTEXT NOT NULL COLLATE utf8_bin,
205 dateCreated INT UNSIGNED NOT NULL,
206 dateModified INT UNSIGNED NOT NULL,
207
208 UNIQUE KEY `key_phid` (phid),
209 KEY `key_object` (objectPHID)
210
211) ENGINE=InnoDB, COLLATE utf8_general_ci;
212
213CREATE TABLE {$NAMESPACE}_nuance.nuance_requestortransaction_comment (
214 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
215 phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
216 transactionPHID VARCHAR(64) COLLATE utf8_bin,
217 authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
218 viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
219 editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
220 commentVersion INT UNSIGNED NOT NULL,
221 content LONGTEXT NOT NULL COLLATE utf8_bin,
222 contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
223 isDeleted BOOL NOT NULL,
224 dateCreated INT UNSIGNED NOT NULL,
225 dateModified INT UNSIGNED NOT NULL,
226
227 UNIQUE KEY `key_phid` (phid),
228 UNIQUE KEY `key_version` (transactionPHID, commentVersion)
229
230) ENGINE=InnoDB, COLLATE utf8_general_ci;
231
232CREATE TABLE {$NAMESPACE}_nuance.nuance_requestorsource (
233 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
234 requestorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
235 sourcePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
236 sourceKey VARCHAR(128) NOT NULL COLLATE utf8_bin,
237 data LONGTEXT NOT NULL COLLATE utf8_bin,
238 dateCreated INT UNSIGNED NOT NULL,
239 dateModified INT UNSIGNED NOT NULL,
240 KEY `key_requestor` (requestorPHID, id),
241 KEY `key_source` (sourcePHID, id),
242 UNIQUE KEY `key_source_key` (sourcePHID, sourceKey)
243) ENGINE=InnoDB, COLLATE utf8_general_ci;
244
245CREATE TABLE {$NAMESPACE}_nuance.edge (
246 src VARCHAR(64) NOT NULL COLLATE utf8_bin,
247 type VARCHAR(64) NOT NULL COLLATE utf8_bin,
248 dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
249 dateCreated INT UNSIGNED NOT NULL,
250 seq INT UNSIGNED NOT NULL,
251 dataID INT UNSIGNED,
252 PRIMARY KEY (src, type, dst),
253 KEY (src, type, dateCreated, seq)
254) ENGINE=InnoDB, COLLATE utf8_general_ci;
255
256CREATE TABLE {$NAMESPACE}_nuance.edgedata (
257 id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
258 data LONGTEXT NOT NULL COLLATE utf8_bin
259) ENGINE=InnoDB, COLLATE utf8_general_ci;