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
1ALTER DATABASE `{$NAMESPACE}_audit` COLLATE utf8_general_ci;
2
3ALTER TABLE `{$NAMESPACE}_audit`.`audit_comment`
4 MODIFY `phid` varchar(64) CHARACTER SET binary,
5 MODIFY `targetPHID` varchar(64) CHARACTER SET binary,
6 MODIFY `actorPHID` varchar(64) CHARACTER SET binary,
7 MODIFY `action` varchar(64) CHARACTER SET binary,
8 MODIFY `content` longtext CHARACTER SET binary;
9ALTER TABLE `{$NAMESPACE}_audit`.`audit_comment`
10 COLLATE utf8_general_ci,
11 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
12 MODIFY `targetPHID` varchar(64) COLLATE utf8_bin NOT NULL,
13 MODIFY `actorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
14 MODIFY `action` varchar(64) COLLATE utf8_general_ci NOT NULL,
15 MODIFY `content` longtext COLLATE utf8_general_ci NOT NULL;
16
17
18
19ALTER DATABASE `{$NAMESPACE}_conduit` COLLATE utf8_general_ci;
20
21ALTER TABLE `{$NAMESPACE}_conduit`.`conduit_certificatetoken`
22 MODIFY `userPHID` varchar(64) CHARACTER SET binary,
23 MODIFY `token` varchar(64) CHARACTER SET binary;
24ALTER TABLE `{$NAMESPACE}_conduit`.`conduit_certificatetoken`
25 COLLATE utf8_general_ci,
26 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
27 MODIFY `token` varchar(64) COLLATE utf8_general_ci;
28
29ALTER TABLE `{$NAMESPACE}_conduit`.`conduit_connectionlog`
30 MODIFY `client` varchar(255) CHARACTER SET binary,
31 MODIFY `clientVersion` varchar(255) CHARACTER SET binary,
32 MODIFY `clientDescription` varchar(255) CHARACTER SET binary,
33 MODIFY `username` varchar(255) CHARACTER SET binary;
34ALTER TABLE `{$NAMESPACE}_conduit`.`conduit_connectionlog`
35 COLLATE utf8_general_ci,
36 MODIFY `client` varchar(255) COLLATE utf8_general_ci,
37 MODIFY `clientVersion` varchar(255) COLLATE utf8_general_ci,
38 MODIFY `clientDescription` varchar(255) COLLATE utf8_general_ci,
39 MODIFY `username` varchar(255) COLLATE utf8_general_ci;
40
41ALTER TABLE `{$NAMESPACE}_conduit`.`conduit_methodcalllog`
42 MODIFY `method` varchar(255) CHARACTER SET binary,
43 MODIFY `error` varchar(255) CHARACTER SET binary;
44ALTER TABLE `{$NAMESPACE}_conduit`.`conduit_methodcalllog`
45 COLLATE utf8_general_ci,
46 MODIFY `method` varchar(255) COLLATE utf8_general_ci NOT NULL,
47 MODIFY `error` varchar(255) COLLATE utf8_general_ci NOT NULL;
48
49
50
51ALTER DATABASE `{$NAMESPACE}_countdown` COLLATE utf8_general_ci;
52
53ALTER TABLE `{$NAMESPACE}_countdown`.`countdown_timer`
54 MODIFY `title` varchar(255) CHARACTER SET binary,
55 MODIFY `authorPHID` varchar(64) CHARACTER SET binary;
56ALTER TABLE `{$NAMESPACE}_countdown`.`countdown_timer`
57 COLLATE utf8_general_ci,
58 MODIFY `title` varchar(255) COLLATE utf8_general_ci NOT NULL,
59 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL;
60
61
62
63ALTER DATABASE `{$NAMESPACE}_daemon` COLLATE utf8_general_ci;
64
65ALTER TABLE `{$NAMESPACE}_daemon`.`daemon_log`
66 MODIFY `daemon` varchar(255) CHARACTER SET binary,
67 MODIFY `host` varchar(255) CHARACTER SET binary,
68 MODIFY `argv` varchar(512) CHARACTER SET binary;
69ALTER TABLE `{$NAMESPACE}_daemon`.`daemon_log`
70 COLLATE utf8_general_ci,
71 MODIFY `daemon` varchar(255) COLLATE utf8_general_ci NOT NULL,
72 MODIFY `host` varchar(255) COLLATE utf8_general_ci NOT NULL,
73 MODIFY `argv` varchar(512) COLLATE utf8_general_ci NOT NULL;
74
75ALTER TABLE `{$NAMESPACE}_daemon`.`daemon_logevent`
76 MODIFY `logType` varchar(4) CHARACTER SET binary,
77 MODIFY `message` longtext CHARACTER SET binary;
78ALTER TABLE `{$NAMESPACE}_daemon`.`daemon_logevent`
79 COLLATE utf8_general_ci,
80 MODIFY `logType` varchar(4) COLLATE utf8_general_ci NOT NULL,
81 MODIFY `message` longtext COLLATE utf8_bin NOT NULL;
82
83
84
85ALTER DATABASE `{$NAMESPACE}_differential` COLLATE utf8_general_ci;
86
87ALTER TABLE `{$NAMESPACE}_differential`.`differential_affectedpath`
88 COLLATE utf8_general_ci;
89
90ALTER TABLE `{$NAMESPACE}_differential`.`differential_auxiliaryfield`
91 MODIFY `revisionPHID` varchar(64) CHARACTER SET binary,
92 MODIFY `name` varchar(32) CHARACTER SET binary,
93 MODIFY `value` longtext CHARACTER SET binary;
94ALTER TABLE `{$NAMESPACE}_differential`.`differential_auxiliaryfield`
95 COLLATE utf8_general_ci,
96 MODIFY `revisionPHID` varchar(64) COLLATE utf8_bin NOT NULL,
97 MODIFY `name` varchar(32) COLLATE utf8_bin NOT NULL,
98 MODIFY `value` longtext COLLATE utf8_bin NOT NULL;
99
100ALTER TABLE `{$NAMESPACE}_differential`.`differential_changeset`
101 MODIFY `oldFile` varchar(255) CHARACTER SET binary,
102 MODIFY `filename` varchar(255) CHARACTER SET binary,
103 MODIFY `awayPaths` longtext CHARACTER SET binary,
104 MODIFY `metadata` longtext CHARACTER SET binary,
105 MODIFY `oldProperties` longtext CHARACTER SET binary,
106 MODIFY `newProperties` longtext CHARACTER SET binary;
107ALTER TABLE `{$NAMESPACE}_differential`.`differential_changeset`
108 COLLATE utf8_general_ci,
109 MODIFY `oldFile` varchar(255) COLLATE utf8_general_ci,
110 MODIFY `filename` varchar(255) COLLATE utf8_general_ci NOT NULL,
111 MODIFY `awayPaths` longtext COLLATE utf8_bin,
112 MODIFY `metadata` longtext COLLATE utf8_bin,
113 MODIFY `oldProperties` longtext COLLATE utf8_bin,
114 MODIFY `newProperties` longtext COLLATE utf8_bin;
115
116ALTER TABLE `{$NAMESPACE}_differential`.`differential_changeset_parse_cache`
117 MODIFY `cache` longtext CHARACTER SET binary;
118ALTER TABLE `{$NAMESPACE}_differential`.`differential_changeset_parse_cache`
119 COLLATE utf8_general_ci,
120 MODIFY `cache` longtext COLLATE utf8_bin NOT NULL;
121
122ALTER TABLE `{$NAMESPACE}_differential`.`differential_comment`
123 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
124 MODIFY `action` varchar(64) CHARACTER SET binary,
125 MODIFY `content` longtext CHARACTER SET binary,
126 MODIFY `cache` longtext CHARACTER SET binary,
127 MODIFY `metadata` longtext CHARACTER SET binary,
128 MODIFY `contentSource` varchar(255) CHARACTER SET binary;
129ALTER TABLE `{$NAMESPACE}_differential`.`differential_comment`
130 COLLATE utf8_general_ci,
131 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
132 MODIFY `action` varchar(64) COLLATE utf8_general_ci NOT NULL,
133 MODIFY `content` longtext COLLATE utf8_bin NOT NULL,
134 MODIFY `cache` longtext COLLATE utf8_bin,
135 MODIFY `metadata` longtext COLLATE utf8_bin NOT NULL,
136 MODIFY `contentSource` varchar(255) COLLATE utf8_general_ci;
137
138ALTER TABLE `{$NAMESPACE}_differential`.`differential_commit`
139 MODIFY `commitPHID` varchar(64) CHARACTER SET binary;
140ALTER TABLE `{$NAMESPACE}_differential`.`differential_commit`
141 COLLATE utf8_general_ci,
142 MODIFY `commitPHID` varchar(64) COLLATE utf8_bin NOT NULL;
143
144ALTER TABLE `{$NAMESPACE}_differential`.`differential_diff`
145 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
146 MODIFY `sourceMachine` varchar(255) CHARACTER SET binary,
147 MODIFY `sourcePath` varchar(255) CHARACTER SET binary,
148 MODIFY `sourceControlSystem` varchar(64) CHARACTER SET binary,
149 MODIFY `sourceControlBaseRevision` varchar(255) CHARACTER SET binary,
150 MODIFY `sourceControlPath` varchar(255) CHARACTER SET binary,
151 MODIFY `branch` varchar(255) CHARACTER SET binary,
152 MODIFY `arcanistProjectPHID` varchar(64) CHARACTER SET binary,
153 MODIFY `creationMethod` varchar(255) CHARACTER SET binary,
154 MODIFY `description` varchar(255) CHARACTER SET binary,
155 MODIFY `repositoryUUID` varchar(64) CHARACTER SET binary;
156ALTER TABLE `{$NAMESPACE}_differential`.`differential_diff`
157 COLLATE utf8_general_ci,
158 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin,
159 MODIFY `sourceMachine` varchar(255) COLLATE utf8_general_ci,
160 MODIFY `sourcePath` varchar(255) COLLATE utf8_general_ci,
161 MODIFY `sourceControlSystem` varchar(64) COLLATE utf8_general_ci,
162 MODIFY `sourceControlBaseRevision` varchar(255) COLLATE utf8_general_ci,
163 MODIFY `sourceControlPath` varchar(255) COLLATE utf8_general_ci,
164 MODIFY `branch` varchar(255) COLLATE utf8_general_ci,
165 MODIFY `arcanistProjectPHID` varchar(64) COLLATE utf8_bin,
166 MODIFY `creationMethod` varchar(255) COLLATE utf8_general_ci,
167 MODIFY `description` varchar(255) COLLATE utf8_general_ci,
168 MODIFY `repositoryUUID` varchar(64) COLLATE utf8_bin;
169
170ALTER TABLE `{$NAMESPACE}_differential`.`differential_diffproperty`
171 MODIFY `name` varchar(255) CHARACTER SET binary,
172 MODIFY `data` longtext CHARACTER SET binary;
173ALTER TABLE `{$NAMESPACE}_differential`.`differential_diffproperty`
174 COLLATE utf8_general_ci,
175 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
176 MODIFY `data` longtext COLLATE utf8_bin NOT NULL;
177
178ALTER TABLE `{$NAMESPACE}_differential`.`differential_hunk`
179 MODIFY `changes` longtext CHARACTER SET binary;
180ALTER TABLE `{$NAMESPACE}_differential`.`differential_hunk`
181 COLLATE utf8_general_ci,
182 MODIFY `changes` longtext COLLATE utf8_bin;
183
184ALTER TABLE `{$NAMESPACE}_differential`.`differential_inlinecomment`
185 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
186 MODIFY `content` longtext CHARACTER SET binary,
187 MODIFY `cache` longtext CHARACTER SET binary;
188ALTER TABLE `{$NAMESPACE}_differential`.`differential_inlinecomment`
189 COLLATE utf8_general_ci,
190 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
191 MODIFY `content` longtext COLLATE utf8_bin NOT NULL,
192 MODIFY `cache` longtext COLLATE utf8_bin;
193
194ALTER TABLE `{$NAMESPACE}_differential`.`differential_relationship`
195 MODIFY `relation` varchar(4) CHARACTER SET binary,
196 MODIFY `objectPHID` varchar(64) CHARACTER SET binary,
197 MODIFY `reasonPHID` varchar(64) CHARACTER SET binary;
198ALTER TABLE `{$NAMESPACE}_differential`.`differential_relationship`
199 COLLATE utf8_general_ci,
200 MODIFY `relation` varchar(4) COLLATE utf8_bin NOT NULL,
201 MODIFY `objectPHID` varchar(64) COLLATE utf8_bin NOT NULL,
202 MODIFY `reasonPHID` varchar(64) COLLATE utf8_bin;
203
204ALTER TABLE `{$NAMESPACE}_differential`.`differential_revision`
205 MODIFY `title` varchar(255) CHARACTER SET binary,
206 MODIFY `phid` varchar(64) CHARACTER SET binary,
207 MODIFY `status` varchar(32) CHARACTER SET binary,
208 MODIFY `summary` longtext CHARACTER SET binary,
209 MODIFY `testPlan` text CHARACTER SET binary,
210 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
211 MODIFY `lastReviewerPHID` varchar(64) CHARACTER SET binary,
212 MODIFY `attached` longtext CHARACTER SET binary,
213 MODIFY `unsubscribed` longtext CHARACTER SET binary,
214 MODIFY `mailKey` varchar(40) CHARACTER SET binary;
215ALTER TABLE `{$NAMESPACE}_differential`.`differential_revision`
216 COLLATE utf8_general_ci,
217 MODIFY `title` varchar(255) COLLATE utf8_general_ci NOT NULL,
218 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
219 MODIFY `status` varchar(32) COLLATE utf8_general_ci NOT NULL,
220 MODIFY `summary` longtext COLLATE utf8_general_ci NOT NULL,
221 MODIFY `testPlan` text COLLATE utf8_general_ci NOT NULL,
222 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin,
223 MODIFY `lastReviewerPHID` varchar(64) COLLATE utf8_bin,
224 MODIFY `attached` longtext COLLATE utf8_general_ci NOT NULL,
225 MODIFY `unsubscribed` longtext COLLATE utf8_bin NOT NULL,
226 MODIFY `mailKey` varchar(40) COLLATE utf8_bin NOT NULL;
227
228ALTER TABLE `{$NAMESPACE}_differential`.`differential_revisionhash`
229 MODIFY `type` char(4) CHARACTER SET binary,
230 MODIFY `hash` varchar(40) CHARACTER SET binary;
231ALTER TABLE `{$NAMESPACE}_differential`.`differential_revisionhash`
232 COLLATE utf8_general_ci,
233 MODIFY `type` char(4) COLLATE utf8_bin NOT NULL,
234 MODIFY `hash` varchar(40) COLLATE utf8_bin NOT NULL;
235
236
237
238ALTER DATABASE `{$NAMESPACE}_draft` COLLATE utf8_general_ci;
239
240ALTER TABLE `{$NAMESPACE}_draft`.`draft`
241 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
242 MODIFY `draftKey` varchar(64) CHARACTER SET binary,
243 MODIFY `draft` longtext CHARACTER SET binary;
244ALTER TABLE `{$NAMESPACE}_draft`.`draft`
245 COLLATE utf8_general_ci,
246 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
247 MODIFY `draftKey` varchar(64) COLLATE utf8_bin NOT NULL,
248 MODIFY `draft` longtext COLLATE utf8_bin NOT NULL;
249
250
251
252ALTER DATABASE `{$NAMESPACE}_drydock` COLLATE utf8_general_ci;
253
254ALTER TABLE `{$NAMESPACE}_drydock`.`drydock_lease`
255 MODIFY `phid` varchar(64) CHARACTER SET binary,
256 MODIFY `ownerPHID` varchar(64) CHARACTER SET binary,
257 MODIFY `attributes` longtext CHARACTER SET binary;
258ALTER TABLE `{$NAMESPACE}_drydock`.`drydock_lease`
259 COLLATE utf8_general_ci,
260 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
261 MODIFY `ownerPHID` varchar(64) COLLATE utf8_bin,
262 MODIFY `attributes` longtext COLLATE utf8_bin NOT NULL;
263
264ALTER TABLE `{$NAMESPACE}_drydock`.`drydock_resource`
265 MODIFY `phid` varchar(64) CHARACTER SET binary,
266 MODIFY `name` varchar(255) CHARACTER SET binary,
267 MODIFY `ownerPHID` varchar(64) CHARACTER SET binary,
268 MODIFY `blueprintClass` varchar(255) CHARACTER SET binary,
269 MODIFY `type` varchar(64) CHARACTER SET binary,
270 MODIFY `attributes` longtext CHARACTER SET binary,
271 MODIFY `capabilities` longtext CHARACTER SET binary;
272ALTER TABLE `{$NAMESPACE}_drydock`.`drydock_resource`
273 COLLATE utf8_general_ci,
274 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
275 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
276 MODIFY `ownerPHID` varchar(64) COLLATE utf8_bin,
277 MODIFY `blueprintClass` varchar(255) COLLATE utf8_general_ci NOT NULL,
278 MODIFY `type` varchar(64) COLLATE utf8_general_ci NOT NULL,
279 MODIFY `attributes` longtext COLLATE utf8_bin NOT NULL,
280 MODIFY `capabilities` longtext COLLATE utf8_bin NOT NULL;
281
282
283
284ALTER DATABASE `{$NAMESPACE}_feed` COLLATE utf8_general_ci;
285
286ALTER TABLE `{$NAMESPACE}_feed`.`feed_storydata`
287 MODIFY `phid` varchar(64) CHARACTER SET binary,
288 MODIFY `storyType` varchar(64) CHARACTER SET binary,
289 MODIFY `storyData` longtext CHARACTER SET binary,
290 MODIFY `authorPHID` varchar(64) CHARACTER SET binary;
291ALTER TABLE `{$NAMESPACE}_feed`.`feed_storydata`
292 COLLATE utf8_general_ci,
293 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
294 MODIFY `storyType` varchar(64) COLLATE utf8_general_ci NOT NULL,
295 MODIFY `storyData` longtext COLLATE utf8_bin NOT NULL,
296 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL;
297
298ALTER TABLE `{$NAMESPACE}_feed`.`feed_storyreference`
299 MODIFY `objectPHID` varchar(64) CHARACTER SET binary;
300ALTER TABLE `{$NAMESPACE}_feed`.`feed_storyreference`
301 COLLATE utf8_general_ci,
302 MODIFY `objectPHID` varchar(64) COLLATE utf8_bin NOT NULL;
303
304
305
306ALTER DATABASE `{$NAMESPACE}_file` COLLATE utf8_general_ci;
307
308ALTER TABLE `{$NAMESPACE}_file`.`file`
309 MODIFY `phid` varchar(64) CHARACTER SET binary,
310 MODIFY `name` varchar(255) CHARACTER SET binary,
311 MODIFY `mimeType` varchar(255) CHARACTER SET binary,
312 MODIFY `storageEngine` varchar(32) CHARACTER SET binary,
313 MODIFY `storageFormat` varchar(32) CHARACTER SET binary,
314 MODIFY `storageHandle` varchar(255) CHARACTER SET binary,
315 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
316 MODIFY `secretKey` varchar(20) CHARACTER SET binary;
317ALTER TABLE `{$NAMESPACE}_file`.`file`
318 COLLATE utf8_general_ci,
319 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
320 MODIFY `name` varchar(255) COLLATE utf8_general_ci,
321 MODIFY `mimeType` varchar(255) COLLATE utf8_general_ci,
322 MODIFY `storageEngine` varchar(32) COLLATE utf8_general_ci NOT NULL,
323 MODIFY `storageFormat` varchar(32) COLLATE utf8_general_ci NOT NULL,
324 MODIFY `storageHandle` varchar(255) COLLATE utf8_general_ci NOT NULL,
325 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin,
326 MODIFY `secretKey` varchar(20) COLLATE utf8_bin;
327
328ALTER TABLE `{$NAMESPACE}_file`.`file_imagemacro`
329 MODIFY `filePHID` varchar(64) CHARACTER SET binary,
330 MODIFY `name` varchar(255) CHARACTER SET binary;
331ALTER TABLE `{$NAMESPACE}_file`.`file_imagemacro`
332 COLLATE utf8_general_ci,
333 MODIFY `filePHID` varchar(64) COLLATE utf8_general_ci NOT NULL,
334 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL;
335
336ALTER TABLE `{$NAMESPACE}_file`.`file_proxyimage`
337 MODIFY `uri` varchar(255) CHARACTER SET binary,
338 MODIFY `filePHID` varchar(64) CHARACTER SET binary;
339ALTER TABLE `{$NAMESPACE}_file`.`file_proxyimage`
340 COLLATE utf8_general_ci,
341 MODIFY `uri` varchar(255) COLLATE utf8_bin NOT NULL,
342 MODIFY `filePHID` varchar(64) COLLATE utf8_bin NOT NULL;
343
344ALTER TABLE `{$NAMESPACE}_file`.`file_storageblob`
345 COLLATE utf8_general_ci;
346
347ALTER TABLE `{$NAMESPACE}_file`.`file_transformedfile`
348 MODIFY `originalPHID` varchar(64) CHARACTER SET binary,
349 MODIFY `transform` varchar(255) CHARACTER SET binary,
350 MODIFY `transformedPHID` varchar(64) CHARACTER SET binary;
351ALTER TABLE `{$NAMESPACE}_file`.`file_transformedfile`
352 COLLATE utf8_general_ci,
353 MODIFY `originalPHID` varchar(64) COLLATE utf8_bin NOT NULL,
354 MODIFY `transform` varchar(255) COLLATE utf8_bin NOT NULL,
355 MODIFY `transformedPHID` varchar(64) COLLATE utf8_bin NOT NULL;
356
357
358
359ALTER DATABASE `{$NAMESPACE}_herald` COLLATE utf8_general_ci;
360
361ALTER TABLE `{$NAMESPACE}_herald`.`herald_action`
362 MODIFY `action` varchar(255) CHARACTER SET binary,
363 MODIFY `target` text CHARACTER SET binary;
364ALTER TABLE `{$NAMESPACE}_herald`.`herald_action`
365 COLLATE utf8_general_ci,
366 MODIFY `action` varchar(255) COLLATE utf8_general_ci NOT NULL,
367 MODIFY `target` text COLLATE utf8_general_ci NOT NULL;
368
369ALTER TABLE `{$NAMESPACE}_herald`.`herald_condition`
370 MODIFY `fieldName` varchar(255) CHARACTER SET binary,
371 MODIFY `fieldCondition` varchar(255) CHARACTER SET binary,
372 MODIFY `value` text CHARACTER SET binary;
373ALTER TABLE `{$NAMESPACE}_herald`.`herald_condition`
374 COLLATE utf8_general_ci,
375 MODIFY `fieldName` varchar(255) COLLATE utf8_general_ci NOT NULL,
376 MODIFY `fieldCondition` varchar(255) COLLATE utf8_general_ci NOT NULL,
377 MODIFY `value` text COLLATE utf8_general_ci NOT NULL;
378
379ALTER TABLE `{$NAMESPACE}_herald`.`herald_rule`
380 MODIFY `name` varchar(255) CHARACTER SET binary,
381 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
382 MODIFY `contentType` varchar(255) CHARACTER SET binary,
383 MODIFY `ruleType` varchar(255) CHARACTER SET binary;
384ALTER TABLE `{$NAMESPACE}_herald`.`herald_rule`
385 COLLATE utf8_general_ci,
386 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
387 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
388 MODIFY `contentType` varchar(255) COLLATE utf8_general_ci NOT NULL,
389 MODIFY `ruleType` varchar(255) COLLATE utf8_general_ci NOT NULL DEFAULT 'global';
390
391ALTER TABLE `{$NAMESPACE}_herald`.`herald_ruleapplied`
392 MODIFY `phid` varchar(64) CHARACTER SET binary;
393ALTER TABLE `{$NAMESPACE}_herald`.`herald_ruleapplied`
394 COLLATE utf8_general_ci,
395 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL;
396
397ALTER TABLE `{$NAMESPACE}_herald`.`herald_ruleedit`
398 MODIFY `editorPHID` varchar(64) CHARACTER SET binary;
399ALTER TABLE `{$NAMESPACE}_herald`.`herald_ruleedit`
400 COLLATE utf8_general_ci,
401 MODIFY `editorPHID` varchar(64) COLLATE utf8_bin NOT NULL;
402
403ALTER TABLE `{$NAMESPACE}_herald`.`herald_savedheader`
404 MODIFY `phid` varchar(64) CHARACTER SET binary,
405 MODIFY `header` varchar(255) CHARACTER SET binary;
406ALTER TABLE `{$NAMESPACE}_herald`.`herald_savedheader`
407 COLLATE utf8_general_ci,
408 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
409 MODIFY `header` varchar(255) COLLATE utf8_general_ci NOT NULL;
410
411ALTER TABLE `{$NAMESPACE}_herald`.`herald_transcript`
412 MODIFY `phid` varchar(64) CHARACTER SET binary,
413 MODIFY `host` varchar(255) CHARACTER SET binary,
414 MODIFY `psth` varchar(255) CHARACTER SET binary,
415 MODIFY `objectPHID` varchar(64) CHARACTER SET binary,
416 MODIFY `objectTranscript` longtext CHARACTER SET binary,
417 MODIFY `ruleTranscripts` longtext CHARACTER SET binary,
418 MODIFY `conditionTranscripts` longtext CHARACTER SET binary,
419 MODIFY `applyTranscripts` longtext CHARACTER SET binary;
420ALTER TABLE `{$NAMESPACE}_herald`.`herald_transcript`
421 COLLATE utf8_general_ci,
422 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
423 MODIFY `host` varchar(255) COLLATE utf8_general_ci NOT NULL,
424 MODIFY `psth` varchar(255) COLLATE utf8_general_ci NOT NULL,
425 MODIFY `objectPHID` varchar(64) COLLATE utf8_bin NOT NULL,
426 MODIFY `objectTranscript` longtext COLLATE utf8_bin NOT NULL,
427 MODIFY `ruleTranscripts` longtext COLLATE utf8_bin NOT NULL,
428 MODIFY `conditionTranscripts` longtext COLLATE utf8_bin NOT NULL,
429 MODIFY `applyTranscripts` longtext COLLATE utf8_bin NOT NULL;
430
431
432
433ALTER DATABASE `{$NAMESPACE}_maniphest` COLLATE utf8_general_ci;
434
435ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_task`
436 MODIFY `phid` varchar(64) CHARACTER SET binary,
437 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
438 MODIFY `ownerPHID` varchar(64) CHARACTER SET binary,
439 MODIFY `ccPHIDs` text CHARACTER SET binary,
440 MODIFY `attached` longtext CHARACTER SET binary,
441 MODIFY `title` text CHARACTER SET binary,
442 MODIFY `description` longtext CHARACTER SET binary,
443 MODIFY `projectPHIDs` longtext CHARACTER SET binary,
444 MODIFY `mailKey` varchar(40) CHARACTER SET binary,
445 MODIFY `ownerOrdering` varchar(64) CHARACTER SET binary,
446 MODIFY `originalEmailSource` varchar(255) CHARACTER SET binary;
447ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_task`
448 COLLATE utf8_general_ci,
449 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
450 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
451 MODIFY `ownerPHID` varchar(64) COLLATE utf8_bin,
452 MODIFY `ccPHIDs` text COLLATE utf8_general_ci,
453 MODIFY `attached` longtext COLLATE utf8_general_ci NOT NULL,
454 MODIFY `title` text COLLATE utf8_general_ci NOT NULL,
455 MODIFY `description` longtext COLLATE utf8_general_ci NOT NULL,
456 MODIFY `projectPHIDs` longtext COLLATE utf8_bin NOT NULL,
457 MODIFY `mailKey` varchar(40) COLLATE utf8_bin NOT NULL,
458 MODIFY `ownerOrdering` varchar(64) COLLATE utf8_general_ci,
459 MODIFY `originalEmailSource` varchar(255) COLLATE utf8_general_ci;
460
461ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_taskauxiliarystorage`
462 MODIFY `taskPHID` varchar(64) CHARACTER SET binary,
463 MODIFY `name` varchar(255) CHARACTER SET binary,
464 MODIFY `value` varchar(255) CHARACTER SET binary;
465ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_taskauxiliarystorage`
466 COLLATE utf8_general_ci,
467 MODIFY `taskPHID` varchar(64) COLLATE utf8_bin NOT NULL,
468 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
469 MODIFY `value` varchar(255) COLLATE utf8_general_ci NOT NULL;
470
471ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_taskproject`
472 MODIFY `taskPHID` varchar(64) CHARACTER SET binary,
473 MODIFY `projectPHID` varchar(64) CHARACTER SET binary;
474ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_taskproject`
475 COLLATE utf8_general_ci,
476 MODIFY `taskPHID` varchar(64) COLLATE utf8_bin NOT NULL,
477 MODIFY `projectPHID` varchar(64) COLLATE utf8_bin NOT NULL;
478
479ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_tasksubscriber`
480 MODIFY `taskPHID` varchar(64) CHARACTER SET binary,
481 MODIFY `subscriberPHID` varchar(64) CHARACTER SET binary;
482ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_tasksubscriber`
483 COLLATE utf8_general_ci,
484 MODIFY `taskPHID` varchar(64) COLLATE utf8_bin NOT NULL,
485 MODIFY `subscriberPHID` varchar(64) COLLATE utf8_bin NOT NULL;
486
487ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_touch`
488 MODIFY `userPHID` varchar(64) CHARACTER SET binary;
489ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_touch`
490 COLLATE utf8_general_ci,
491 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL;
492
493ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_transaction`
494 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
495 MODIFY `transactionType` varchar(16) CHARACTER SET binary,
496 MODIFY `oldValue` longtext CHARACTER SET binary,
497 MODIFY `newValue` longtext CHARACTER SET binary,
498 MODIFY `comments` longtext CHARACTER SET binary,
499 MODIFY `cache` longtext CHARACTER SET binary,
500 MODIFY `metadata` longtext CHARACTER SET binary,
501 MODIFY `contentSource` varchar(255) CHARACTER SET binary;
502ALTER TABLE `{$NAMESPACE}_maniphest`.`maniphest_transaction`
503 COLLATE utf8_general_ci,
504 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
505 MODIFY `transactionType` varchar(16) COLLATE utf8_general_ci NOT NULL,
506 MODIFY `oldValue` longtext COLLATE utf8_bin,
507 MODIFY `newValue` longtext COLLATE utf8_bin,
508 MODIFY `comments` longtext COLLATE utf8_bin,
509 MODIFY `cache` longtext COLLATE utf8_bin,
510 MODIFY `metadata` longtext COLLATE utf8_bin NOT NULL,
511 MODIFY `contentSource` varchar(255) COLLATE utf8_general_ci;
512
513
514
515ALTER DATABASE `{$NAMESPACE}_meta_data` COLLATE utf8_general_ci;
516
517
518
519ALTER DATABASE `{$NAMESPACE}_metamta` COLLATE utf8_general_ci;
520
521ALTER TABLE `{$NAMESPACE}_metamta`.`metamta_mail`
522 MODIFY `parameters` longtext CHARACTER SET binary,
523 MODIFY `status` varchar(255) CHARACTER SET binary,
524 MODIFY `message` text CHARACTER SET binary,
525 MODIFY `relatedPHID` varchar(64) CHARACTER SET binary;
526ALTER TABLE `{$NAMESPACE}_metamta`.`metamta_mail`
527 COLLATE utf8_general_ci,
528 MODIFY `parameters` longtext COLLATE utf8_bin NOT NULL,
529 MODIFY `status` varchar(255) COLLATE utf8_general_ci NOT NULL,
530 MODIFY `message` text COLLATE utf8_general_ci,
531 MODIFY `relatedPHID` varchar(64) COLLATE utf8_bin;
532
533ALTER TABLE `{$NAMESPACE}_metamta`.`metamta_mailinglist`
534 MODIFY `phid` varchar(64) CHARACTER SET binary,
535 MODIFY `name` varchar(255) CHARACTER SET binary,
536 MODIFY `email` varchar(255) CHARACTER SET binary,
537 MODIFY `uri` varchar(255) CHARACTER SET binary;
538ALTER TABLE `{$NAMESPACE}_metamta`.`metamta_mailinglist`
539 COLLATE utf8_general_ci,
540 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
541 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
542 MODIFY `email` varchar(255) COLLATE utf8_general_ci NOT NULL,
543 MODIFY `uri` varchar(255) COLLATE utf8_general_ci;
544
545ALTER TABLE `{$NAMESPACE}_metamta`.`metamta_receivedmail`
546 MODIFY `headers` longtext CHARACTER SET binary,
547 MODIFY `bodies` longtext CHARACTER SET binary,
548 MODIFY `attachments` longtext CHARACTER SET binary,
549 MODIFY `relatedPHID` varchar(64) CHARACTER SET binary,
550 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
551 MODIFY `message` longtext CHARACTER SET binary;
552ALTER TABLE `{$NAMESPACE}_metamta`.`metamta_receivedmail`
553 COLLATE utf8_general_ci,
554 MODIFY `headers` longtext COLLATE utf8_bin NOT NULL,
555 MODIFY `bodies` longtext COLLATE utf8_bin NOT NULL,
556 MODIFY `attachments` longtext COLLATE utf8_bin NOT NULL,
557 MODIFY `relatedPHID` varchar(64) COLLATE utf8_bin,
558 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin,
559 MODIFY `message` longtext COLLATE utf8_bin;
560
561
562
563ALTER DATABASE `{$NAMESPACE}_oauth_server` COLLATE utf8_general_ci;
564
565ALTER TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthclientauthorization`
566 MODIFY `phid` varchar(64) CHARACTER SET binary,
567 MODIFY `userPHID` varchar(64) CHARACTER SET binary,
568 MODIFY `clientPHID` varchar(64) CHARACTER SET binary,
569 MODIFY `scope` text CHARACTER SET binary;
570ALTER TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthclientauthorization`
571 COLLATE utf8_general_ci,
572 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
573 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
574 MODIFY `clientPHID` varchar(64) COLLATE utf8_bin NOT NULL,
575 MODIFY `scope` text COLLATE utf8_general_ci NOT NULL;
576
577ALTER TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthserveraccesstoken`
578 MODIFY `token` varchar(32) CHARACTER SET binary,
579 MODIFY `userPHID` varchar(64) CHARACTER SET binary,
580 MODIFY `clientPHID` varchar(64) CHARACTER SET binary;
581ALTER TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthserveraccesstoken`
582 COLLATE utf8_general_ci,
583 MODIFY `token` varchar(32) COLLATE utf8_general_ci NOT NULL,
584 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
585 MODIFY `clientPHID` varchar(64) COLLATE utf8_bin NOT NULL;
586
587ALTER TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthserverauthorizationcode`
588 MODIFY `code` varchar(32) CHARACTER SET binary,
589 MODIFY `clientPHID` varchar(64) CHARACTER SET binary,
590 MODIFY `clientSecret` varchar(32) CHARACTER SET binary,
591 MODIFY `userPHID` varchar(64) CHARACTER SET binary,
592 MODIFY `redirectURI` varchar(255) CHARACTER SET binary;
593ALTER TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthserverauthorizationcode`
594 COLLATE utf8_general_ci,
595 MODIFY `code` varchar(32) COLLATE utf8_general_ci NOT NULL,
596 MODIFY `clientPHID` varchar(64) COLLATE utf8_bin NOT NULL,
597 MODIFY `clientSecret` varchar(32) COLLATE utf8_general_ci NOT NULL,
598 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
599 MODIFY `redirectURI` varchar(255) COLLATE utf8_general_ci NOT NULL;
600
601ALTER TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthserverclient`
602 MODIFY `phid` varchar(64) CHARACTER SET binary,
603 MODIFY `name` varchar(255) CHARACTER SET binary,
604 MODIFY `secret` varchar(32) CHARACTER SET binary,
605 MODIFY `redirectURI` varchar(255) CHARACTER SET binary,
606 MODIFY `creatorPHID` varchar(64) CHARACTER SET binary;
607ALTER TABLE `{$NAMESPACE}_oauth_server`.`oauth_server_oauthserverclient`
608 COLLATE utf8_general_ci,
609 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
610 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
611 MODIFY `secret` varchar(32) COLLATE utf8_general_ci NOT NULL,
612 MODIFY `redirectURI` varchar(255) COLLATE utf8_general_ci NOT NULL,
613 MODIFY `creatorPHID` varchar(64) COLLATE utf8_bin NOT NULL;
614
615
616
617ALTER DATABASE `{$NAMESPACE}_owners` COLLATE utf8_general_ci;
618
619ALTER TABLE `{$NAMESPACE}_owners`.`owners_owner`
620 MODIFY `userPHID` varchar(64) CHARACTER SET binary;
621ALTER TABLE `{$NAMESPACE}_owners`.`owners_owner`
622 COLLATE utf8_general_ci,
623 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL;
624
625ALTER TABLE `{$NAMESPACE}_owners`.`owners_package`
626 MODIFY `phid` varchar(64) CHARACTER SET binary,
627 MODIFY `name` varchar(255) CHARACTER SET binary,
628 MODIFY `description` text CHARACTER SET binary,
629 MODIFY `primaryOwnerPHID` varchar(64) CHARACTER SET binary;
630ALTER TABLE `{$NAMESPACE}_owners`.`owners_package`
631 COLLATE utf8_general_ci,
632 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
633 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
634 MODIFY `description` text COLLATE utf8_general_ci NOT NULL,
635 MODIFY `primaryOwnerPHID` varchar(64) COLLATE utf8_bin;
636
637ALTER TABLE `{$NAMESPACE}_owners`.`owners_path`
638 MODIFY `repositoryPHID` varchar(64) CHARACTER SET binary,
639 MODIFY `path` varchar(255) CHARACTER SET binary;
640ALTER TABLE `{$NAMESPACE}_owners`.`owners_path`
641 COLLATE utf8_general_ci,
642 MODIFY `repositoryPHID` varchar(64) COLLATE utf8_bin NOT NULL,
643 MODIFY `path` varchar(255) COLLATE utf8_general_ci NOT NULL;
644
645
646
647ALTER DATABASE `{$NAMESPACE}_pastebin` COLLATE utf8_general_ci;
648
649ALTER TABLE `{$NAMESPACE}_pastebin`.`pastebin_paste`
650 MODIFY `title` varchar(255) CHARACTER SET binary,
651 MODIFY `phid` varchar(64) CHARACTER SET binary,
652 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
653 MODIFY `filePHID` varchar(64) CHARACTER SET binary,
654 MODIFY `language` varchar(64) CHARACTER SET binary,
655 MODIFY `parentPHID` varchar(64) CHARACTER SET binary;
656ALTER TABLE `{$NAMESPACE}_pastebin`.`pastebin_paste`
657 COLLATE utf8_general_ci,
658 MODIFY `title` varchar(255) COLLATE utf8_general_ci NOT NULL,
659 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
660 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
661 MODIFY `filePHID` varchar(64) COLLATE utf8_bin NOT NULL,
662 MODIFY `language` varchar(64) COLLATE utf8_general_ci NOT NULL,
663 MODIFY `parentPHID` varchar(64) COLLATE utf8_bin;
664
665
666
667ALTER DATABASE `{$NAMESPACE}_phriction` COLLATE utf8_general_ci;
668
669ALTER TABLE `{$NAMESPACE}_phriction`.`phriction_content`
670 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
671 MODIFY `title` varchar(512) CHARACTER SET binary,
672 MODIFY `slug` varchar(512) CHARACTER SET binary,
673 MODIFY `content` longtext CHARACTER SET binary,
674 MODIFY `description` varchar(512) CHARACTER SET binary;
675ALTER TABLE `{$NAMESPACE}_phriction`.`phriction_content`
676 COLLATE utf8_general_ci,
677 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
678 MODIFY `title` varchar(512) COLLATE utf8_general_ci NOT NULL,
679 MODIFY `slug` varchar(512) COLLATE utf8_general_ci NOT NULL,
680 MODIFY `content` longtext COLLATE utf8_bin NOT NULL,
681 MODIFY `description` varchar(512) COLLATE utf8_general_ci;
682
683ALTER TABLE `{$NAMESPACE}_phriction`.`phriction_document`
684 MODIFY `phid` varchar(64) CHARACTER SET binary,
685 MODIFY `slug` varchar(128) CHARACTER SET binary;
686ALTER TABLE `{$NAMESPACE}_phriction`.`phriction_document`
687 COLLATE utf8_general_ci,
688 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
689 MODIFY `slug` varchar(128) COLLATE utf8_general_ci NOT NULL;
690
691
692
693ALTER DATABASE `{$NAMESPACE}_project` COLLATE utf8_general_ci;
694
695ALTER TABLE `{$NAMESPACE}_project`.`project`
696 MODIFY `name` varchar(255) CHARACTER SET binary,
697 MODIFY `phid` varchar(64) CHARACTER SET binary,
698 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
699 MODIFY `status` varchar(32) CHARACTER SET binary,
700 MODIFY `subprojectPHIDs` longtext CHARACTER SET binary,
701 MODIFY `phrictionSlug` varchar(128) CHARACTER SET binary;
702ALTER TABLE `{$NAMESPACE}_project`.`project`
703 COLLATE utf8_general_ci,
704 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
705 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
706 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
707 MODIFY `status` varchar(32) COLLATE utf8_general_ci NOT NULL,
708 MODIFY `subprojectPHIDs` longtext COLLATE utf8_bin NOT NULL,
709 MODIFY `phrictionSlug` varchar(128) COLLATE utf8_bin;
710
711ALTER TABLE `{$NAMESPACE}_project`.`project_affiliation`
712 MODIFY `projectPHID` varchar(64) CHARACTER SET binary,
713 MODIFY `userPHID` varchar(64) CHARACTER SET binary,
714 MODIFY `role` varchar(255) CHARACTER SET binary;
715ALTER TABLE `{$NAMESPACE}_project`.`project_affiliation`
716 COLLATE utf8_general_ci,
717 MODIFY `projectPHID` varchar(64) COLLATE utf8_bin NOT NULL,
718 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
719 MODIFY `role` varchar(255) COLLATE utf8_general_ci NOT NULL;
720
721ALTER TABLE `{$NAMESPACE}_project`.`project_profile`
722 MODIFY `projectPHID` varchar(64) CHARACTER SET binary,
723 MODIFY `blurb` longtext CHARACTER SET binary,
724 MODIFY `profileImagePHID` varchar(64) CHARACTER SET binary;
725ALTER TABLE `{$NAMESPACE}_project`.`project_profile`
726 COLLATE utf8_general_ci,
727 MODIFY `projectPHID` varchar(64) COLLATE utf8_bin NOT NULL,
728 MODIFY `blurb` longtext COLLATE utf8_general_ci NOT NULL,
729 MODIFY `profileImagePHID` varchar(64) COLLATE utf8_bin;
730
731ALTER TABLE `{$NAMESPACE}_project`.`project_subproject`
732 MODIFY `projectPHID` varchar(64) CHARACTER SET binary,
733 MODIFY `subprojectPHID` varchar(64) CHARACTER SET binary;
734ALTER TABLE `{$NAMESPACE}_project`.`project_subproject`
735 COLLATE utf8_general_ci,
736 MODIFY `projectPHID` varchar(64) COLLATE utf8_bin NOT NULL,
737 MODIFY `subprojectPHID` varchar(64) COLLATE utf8_bin NOT NULL;
738
739ALTER TABLE `{$NAMESPACE}_project`.`project_transaction`
740 MODIFY `authorPHID` varchar(64) CHARACTER SET binary,
741 MODIFY `transactionType` varchar(32) CHARACTER SET binary,
742 MODIFY `oldValue` longtext CHARACTER SET binary,
743 MODIFY `newValue` longtext CHARACTER SET binary;
744ALTER TABLE `{$NAMESPACE}_project`.`project_transaction`
745 COLLATE utf8_general_ci,
746 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
747 MODIFY `transactionType` varchar(32) COLLATE utf8_general_ci NOT NULL,
748 MODIFY `oldValue` longtext COLLATE utf8_bin NOT NULL,
749 MODIFY `newValue` longtext COLLATE utf8_bin NOT NULL;
750
751
752
753ALTER DATABASE `{$NAMESPACE}_repository` COLLATE utf8_general_ci;
754
755ALTER TABLE `{$NAMESPACE}_repository`.`repository`
756 MODIFY `phid` varchar(64) CHARACTER SET binary,
757 MODIFY `name` varchar(255) CHARACTER SET binary,
758 MODIFY `callsign` varchar(32) CHARACTER SET binary,
759 MODIFY `versionControlSystem` varchar(32) CHARACTER SET binary,
760 MODIFY `details` longtext CHARACTER SET binary,
761 MODIFY `uuid` varchar(64) CHARACTER SET binary;
762ALTER TABLE `{$NAMESPACE}_repository`.`repository`
763 COLLATE utf8_general_ci,
764 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
765 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
766 MODIFY `callsign` varchar(32) COLLATE utf8_general_ci NOT NULL,
767 MODIFY `versionControlSystem` varchar(32) COLLATE utf8_general_ci NOT NULL,
768 MODIFY `details` longtext COLLATE utf8_bin NOT NULL,
769 MODIFY `uuid` varchar(64) COLLATE utf8_bin;
770
771ALTER TABLE `{$NAMESPACE}_repository`.`repository_arcanistproject`
772 MODIFY `phid` varchar(64) CHARACTER SET binary,
773 MODIFY `name` varchar(255) CHARACTER SET binary,
774 MODIFY `symbolIndexLanguages` longtext CHARACTER SET binary,
775 MODIFY `symbolIndexProjects` longtext CHARACTER SET binary;
776ALTER TABLE `{$NAMESPACE}_repository`.`repository_arcanistproject`
777 COLLATE utf8_general_ci,
778 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
779 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
780 MODIFY `symbolIndexLanguages` longtext COLLATE utf8_bin NOT NULL,
781 MODIFY `symbolIndexProjects` longtext COLLATE utf8_bin NOT NULL;
782
783ALTER TABLE `{$NAMESPACE}_repository`.`repository_auditrequest`
784 MODIFY `auditorPHID` varchar(64) CHARACTER SET binary,
785 MODIFY `commitPHID` varchar(64) CHARACTER SET binary,
786 MODIFY `auditStatus` varchar(64) CHARACTER SET binary,
787 MODIFY `auditReasons` longtext CHARACTER SET binary;
788ALTER TABLE `{$NAMESPACE}_repository`.`repository_auditrequest`
789 COLLATE utf8_general_ci,
790 MODIFY `auditorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
791 MODIFY `commitPHID` varchar(64) COLLATE utf8_bin NOT NULL,
792 MODIFY `auditStatus` varchar(64) COLLATE utf8_general_ci NOT NULL,
793 MODIFY `auditReasons` longtext COLLATE utf8_bin NOT NULL;
794
795ALTER TABLE `{$NAMESPACE}_repository`.`repository_badcommit`
796 MODIFY `fullCommitName` varchar(255) CHARACTER SET binary,
797 MODIFY `description` longtext CHARACTER SET binary;
798ALTER TABLE `{$NAMESPACE}_repository`.`repository_badcommit`
799 COLLATE utf8_general_ci,
800 MODIFY `fullCommitName` varchar(255) COLLATE utf8_bin NOT NULL,
801 MODIFY `description` longtext COLLATE utf8_bin NOT NULL;
802
803ALTER TABLE `{$NAMESPACE}_repository`.`repository_commit`
804 MODIFY `phid` varchar(64) CHARACTER SET binary,
805 MODIFY `commitIdentifier` varchar(40) CHARACTER SET binary,
806 MODIFY `mailKey` varchar(20) CHARACTER SET binary,
807 MODIFY `authorPHID` varchar(64) CHARACTER SET binary;
808ALTER TABLE `{$NAMESPACE}_repository`.`repository_commit`
809 COLLATE utf8_general_ci,
810 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
811 MODIFY `commitIdentifier` varchar(40) COLLATE utf8_bin NOT NULL,
812 MODIFY `mailKey` varchar(20) COLLATE utf8_general_ci NOT NULL,
813 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin;
814
815ALTER TABLE `{$NAMESPACE}_repository`.`repository_commitdata`
816 MODIFY `authorName` varchar(255) CHARACTER SET binary,
817 MODIFY `commitMessage` longtext CHARACTER SET binary,
818 MODIFY `commitDetails` longtext CHARACTER SET binary;
819ALTER TABLE `{$NAMESPACE}_repository`.`repository_commitdata`
820 COLLATE utf8_general_ci,
821 MODIFY `authorName` varchar(255) COLLATE utf8_general_ci NOT NULL,
822 MODIFY `commitMessage` longtext COLLATE utf8_bin NOT NULL,
823 MODIFY `commitDetails` longtext COLLATE utf8_bin NOT NULL;
824
825ALTER TABLE `{$NAMESPACE}_repository`.`repository_filesystem`
826 COLLATE utf8_general_ci;
827
828ALTER TABLE `{$NAMESPACE}_repository`.`repository_path`
829 MODIFY `path` varchar(512) CHARACTER SET binary,
830 MODIFY `pathHash` varchar(32) CHARACTER SET binary;
831ALTER TABLE `{$NAMESPACE}_repository`.`repository_path`
832 COLLATE utf8_general_ci,
833 MODIFY `path` varchar(512) COLLATE utf8_bin NOT NULL,
834 MODIFY `pathHash` varchar(32) COLLATE utf8_bin NOT NULL;
835
836ALTER TABLE `{$NAMESPACE}_repository`.`repository_pathchange`
837 COLLATE utf8_general_ci;
838
839ALTER TABLE `{$NAMESPACE}_repository`.`repository_shortcut`
840 MODIFY `name` varchar(255) CHARACTER SET binary,
841 MODIFY `href` varchar(255) CHARACTER SET binary,
842 MODIFY `description` varchar(255) CHARACTER SET binary;
843ALTER TABLE `{$NAMESPACE}_repository`.`repository_shortcut`
844 COLLATE utf8_general_ci,
845 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL,
846 MODIFY `href` varchar(255) COLLATE utf8_general_ci NOT NULL,
847 MODIFY `description` varchar(255) COLLATE utf8_general_ci NOT NULL;
848
849ALTER TABLE `{$NAMESPACE}_repository`.`repository_summary`
850 COLLATE utf8_general_ci;
851
852ALTER TABLE `{$NAMESPACE}_repository`.`repository_symbol`
853 MODIFY `symbolName` varchar(128) CHARACTER SET binary,
854 MODIFY `symbolType` varchar(12) CHARACTER SET binary,
855 MODIFY `symbolLanguage` varchar(32) CHARACTER SET binary;
856ALTER TABLE `{$NAMESPACE}_repository`.`repository_symbol`
857 COLLATE utf8_general_ci,
858 MODIFY `symbolName` varchar(128) COLLATE utf8_general_ci NOT NULL,
859 MODIFY `symbolType` varchar(12) COLLATE utf8_bin NOT NULL,
860 MODIFY `symbolLanguage` varchar(32) COLLATE utf8_bin NOT NULL;
861
862
863
864ALTER DATABASE `{$NAMESPACE}_search` COLLATE utf8_general_ci;
865
866ALTER TABLE `{$NAMESPACE}_search`.`search_document`
867 MODIFY `phid` varchar(64) CHARACTER SET binary,
868 MODIFY `documentType` varchar(4) CHARACTER SET binary,
869 MODIFY `documentTitle` varchar(255) CHARACTER SET binary;
870ALTER TABLE `{$NAMESPACE}_search`.`search_document`
871 COLLATE utf8_general_ci,
872 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
873 MODIFY `documentType` varchar(4) COLLATE utf8_bin NOT NULL,
874 MODIFY `documentTitle` varchar(255) COLLATE utf8_general_ci NOT NULL;
875
876ALTER TABLE `{$NAMESPACE}_search`.`search_documentfield`
877 DROP INDEX corpus,
878 MODIFY `phid` varchar(64) CHARACTER SET binary,
879 MODIFY `phidType` varchar(4) CHARACTER SET binary,
880 MODIFY `field` varchar(4) CHARACTER SET binary,
881 MODIFY `auxPHID` varchar(64) CHARACTER SET binary,
882 MODIFY `corpus` text CHARACTER SET binary;
883ALTER TABLE `{$NAMESPACE}_search`.`search_documentfield`
884 COLLATE utf8_general_ci,
885 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
886 MODIFY `phidType` varchar(4) COLLATE utf8_bin NOT NULL,
887 MODIFY `field` varchar(4) COLLATE utf8_bin NOT NULL,
888 MODIFY `auxPHID` varchar(64) COLLATE utf8_bin,
889 MODIFY `corpus` text COLLATE utf8_general_ci,
890 ADD FULLTEXT (corpus);
891
892ALTER TABLE `{$NAMESPACE}_search`.`search_documentrelationship`
893 MODIFY `phid` varchar(64) CHARACTER SET binary,
894 MODIFY `relatedPHID` varchar(64) CHARACTER SET binary,
895 MODIFY `relation` varchar(4) CHARACTER SET binary,
896 MODIFY `relatedType` varchar(4) CHARACTER SET binary;
897ALTER TABLE `{$NAMESPACE}_search`.`search_documentrelationship`
898 COLLATE utf8_general_ci,
899 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
900 MODIFY `relatedPHID` varchar(64) COLLATE utf8_bin NOT NULL,
901 MODIFY `relation` varchar(4) COLLATE utf8_bin NOT NULL,
902 MODIFY `relatedType` varchar(4) COLLATE utf8_general_ci NOT NULL;
903
904ALTER TABLE `{$NAMESPACE}_search`.`search_query`
905 MODIFY `query` varchar(255) CHARACTER SET binary,
906 MODIFY `parameters` text CHARACTER SET binary,
907 MODIFY `queryKey` varchar(12) CHARACTER SET binary;
908ALTER TABLE `{$NAMESPACE}_search`.`search_query`
909 COLLATE utf8_general_ci,
910 MODIFY `query` varchar(255) COLLATE utf8_general_ci NOT NULL,
911 MODIFY `parameters` text COLLATE utf8_general_ci NOT NULL,
912 MODIFY `queryKey` varchar(12) COLLATE utf8_general_ci NOT NULL;
913
914
915
916ALTER DATABASE `{$NAMESPACE}_slowvote` COLLATE utf8_general_ci;
917
918ALTER TABLE `{$NAMESPACE}_slowvote`.`slowvote_choice`
919 MODIFY `authorPHID` varchar(64) CHARACTER SET binary;
920ALTER TABLE `{$NAMESPACE}_slowvote`.`slowvote_choice`
921 COLLATE utf8_general_ci,
922 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL;
923
924ALTER TABLE `{$NAMESPACE}_slowvote`.`slowvote_comment`
925 MODIFY `authorPHID` varchar(64) CHARACTER SET binary;
926ALTER TABLE `{$NAMESPACE}_slowvote`.`slowvote_comment`
927 COLLATE utf8_general_ci,
928 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL,
929 MODIFY `commentText` longtext COLLATE utf8_bin NOT NULL;
930
931ALTER TABLE `{$NAMESPACE}_slowvote`.`slowvote_option`
932 MODIFY `name` varchar(255) CHARACTER SET binary;
933ALTER TABLE `{$NAMESPACE}_slowvote`.`slowvote_option`
934 COLLATE utf8_general_ci,
935 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL;
936
937ALTER TABLE `{$NAMESPACE}_slowvote`.`slowvote_poll`
938 MODIFY `question` varchar(255) CHARACTER SET binary,
939 MODIFY `phid` varchar(64) CHARACTER SET binary,
940 MODIFY `authorPHID` varchar(64) CHARACTER SET binary;
941ALTER TABLE `{$NAMESPACE}_slowvote`.`slowvote_poll`
942 COLLATE utf8_general_ci,
943 MODIFY `question` varchar(255) COLLATE utf8_general_ci NOT NULL,
944 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
945 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin NOT NULL;
946
947
948
949ALTER DATABASE `{$NAMESPACE}_timeline` COLLATE utf8_general_ci;
950
951ALTER TABLE `{$NAMESPACE}_timeline`.`timeline_cursor`
952 MODIFY `name` varchar(255) CHARACTER SET binary;
953ALTER TABLE `{$NAMESPACE}_timeline`.`timeline_cursor`
954 COLLATE utf8_general_ci,
955 MODIFY `name` varchar(255) COLLATE utf8_general_ci NOT NULL;
956
957ALTER TABLE `{$NAMESPACE}_timeline`.`timeline_event`
958 MODIFY `type` char(4) CHARACTER SET binary;
959ALTER TABLE `{$NAMESPACE}_timeline`.`timeline_event`
960 COLLATE utf8_general_ci,
961 MODIFY `type` char(4) COLLATE utf8_bin NOT NULL;
962
963ALTER TABLE `{$NAMESPACE}_timeline`.`timeline_eventdata`
964 COLLATE utf8_general_ci,
965 MODIFY `eventData` longtext COLLATE utf8_bin NOT NULL;
966
967
968
969ALTER DATABASE `{$NAMESPACE}_user` COLLATE utf8_general_ci;
970
971ALTER TABLE `{$NAMESPACE}_user`.`phabricator_session`
972 MODIFY `userPHID` varchar(64) CHARACTER SET binary,
973 MODIFY `type` varchar(32) CHARACTER SET binary,
974 MODIFY `sessionKey` varchar(40) CHARACTER SET binary;
975ALTER TABLE `{$NAMESPACE}_user`.`phabricator_session`
976 COLLATE utf8_general_ci,
977 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
978 MODIFY `type` varchar(32) COLLATE utf8_bin NOT NULL,
979 MODIFY `sessionKey` varchar(40) COLLATE utf8_general_ci NOT NULL;
980
981ALTER TABLE `{$NAMESPACE}_user`.`user`
982 MODIFY `phid` varchar(64) CHARACTER SET binary,
983 MODIFY `userName` varchar(64) CHARACTER SET binary,
984 MODIFY `realName` varchar(128) CHARACTER SET binary,
985 MODIFY `email` varchar(255) CHARACTER SET binary,
986 MODIFY `passwordSalt` varchar(32) CHARACTER SET binary,
987 MODIFY `passwordHash` varchar(32) CHARACTER SET binary,
988 MODIFY `profileImagePHID` varchar(64) CHARACTER SET binary,
989 MODIFY `consoleTab` varchar(64) CHARACTER SET binary,
990 MODIFY `conduitCertificate` varchar(255) CHARACTER SET binary,
991 MODIFY `timezoneIdentifier` varchar(255) CHARACTER SET binary;
992ALTER TABLE `{$NAMESPACE}_user`.`user`
993 COLLATE utf8_general_ci,
994 MODIFY `phid` varchar(64) COLLATE utf8_bin NOT NULL,
995 MODIFY `userName` varchar(64) COLLATE utf8_general_ci NOT NULL,
996 MODIFY `realName` varchar(128) COLLATE utf8_general_ci NOT NULL,
997 MODIFY `email` varchar(255) COLLATE utf8_general_ci NOT NULL,
998 MODIFY `passwordSalt` varchar(32) COLLATE utf8_bin,
999 MODIFY `passwordHash` varchar(32) COLLATE utf8_bin,
1000 MODIFY `profileImagePHID` varchar(64) COLLATE utf8_bin,
1001 MODIFY `consoleTab` varchar(64) COLLATE utf8_general_ci NOT NULL,
1002 MODIFY `conduitCertificate` varchar(255) COLLATE utf8_general_ci NOT NULL,
1003 MODIFY `timezoneIdentifier` varchar(255) COLLATE utf8_general_ci NOT NULL;
1004
1005ALTER TABLE `{$NAMESPACE}_user`.`user_log`
1006 MODIFY `actorPHID` varchar(64) CHARACTER SET binary,
1007 MODIFY `userPHID` varchar(64) CHARACTER SET binary,
1008 MODIFY `action` varchar(64) CHARACTER SET binary,
1009 MODIFY `remoteAddr` varchar(16) CHARACTER SET binary,
1010 MODIFY `session` varchar(40) CHARACTER SET binary;
1011ALTER TABLE `{$NAMESPACE}_user`.`user_log`
1012 COLLATE utf8_general_ci,
1013 MODIFY `actorPHID` varchar(64) COLLATE utf8_bin,
1014 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
1015 MODIFY `action` varchar(64) COLLATE utf8_general_ci NOT NULL,
1016 MODIFY `oldValue` longtext COLLATE utf8_bin NOT NULL,
1017 MODIFY `newValue` longtext COLLATE utf8_bin NOT NULL,
1018 MODIFY `details` longtext COLLATE utf8_bin NOT NULL,
1019 MODIFY `remoteAddr` varchar(16) COLLATE utf8_general_ci NOT NULL,
1020 MODIFY `session` varchar(40) COLLATE utf8_general_ci;
1021
1022ALTER TABLE `{$NAMESPACE}_user`.`user_nametoken`
1023 MODIFY `token` varchar(255) CHARACTER SET binary;
1024ALTER TABLE `{$NAMESPACE}_user`.`user_nametoken`
1025 COLLATE utf8_general_ci,
1026 MODIFY `token` varchar(255) COLLATE utf8_general_ci NOT NULL;
1027
1028ALTER TABLE `{$NAMESPACE}_user`.`user_oauthinfo`
1029 MODIFY `oauthProvider` varchar(255) CHARACTER SET binary,
1030 MODIFY `oauthUID` varchar(255) CHARACTER SET binary,
1031 MODIFY `accountURI` varchar(255) CHARACTER SET binary,
1032 MODIFY `accountName` varchar(255) CHARACTER SET binary,
1033 MODIFY `token` varchar(255) CHARACTER SET binary,
1034 MODIFY `tokenScope` varchar(255) CHARACTER SET binary,
1035 MODIFY `tokenStatus` varchar(255) CHARACTER SET binary;
1036ALTER TABLE `{$NAMESPACE}_user`.`user_oauthinfo`
1037 COLLATE utf8_general_ci,
1038 MODIFY `oauthProvider` varchar(255) COLLATE utf8_general_ci NOT NULL,
1039 MODIFY `oauthUID` varchar(255) COLLATE utf8_general_ci NOT NULL,
1040 MODIFY `accountURI` varchar(255) COLLATE utf8_general_ci,
1041 MODIFY `accountName` varchar(255) COLLATE utf8_general_ci,
1042 MODIFY `token` varchar(255) COLLATE utf8_general_ci,
1043 MODIFY `tokenScope` varchar(255) COLLATE utf8_general_ci,
1044 MODIFY `tokenStatus` varchar(255) COLLATE utf8_general_ci;
1045
1046ALTER TABLE `{$NAMESPACE}_user`.`user_preferences`
1047 MODIFY `userPHID` varchar(64) CHARACTER SET binary;
1048ALTER TABLE `{$NAMESPACE}_user`.`user_preferences`
1049 COLLATE utf8_general_ci,
1050 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
1051 MODIFY `preferences` longtext COLLATE utf8_bin NOT NULL;
1052
1053ALTER TABLE `{$NAMESPACE}_user`.`user_profile`
1054 MODIFY `userPHID` varchar(64) CHARACTER SET binary,
1055 MODIFY `title` varchar(255) CHARACTER SET binary,
1056 MODIFY `blurb` text CHARACTER SET binary,
1057 MODIFY `profileImagePHID` varchar(64) CHARACTER SET binary;
1058ALTER TABLE `{$NAMESPACE}_user`.`user_profile`
1059 COLLATE utf8_general_ci,
1060 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
1061 MODIFY `title` varchar(255) COLLATE utf8_general_ci NOT NULL,
1062 MODIFY `blurb` text COLLATE utf8_general_ci NOT NULL,
1063 MODIFY `profileImagePHID` varchar(64) COLLATE utf8_bin;
1064
1065ALTER TABLE `{$NAMESPACE}_user`.`user_sshkey`
1066 MODIFY `userPHID` varchar(64) CHARACTER SET binary,
1067 MODIFY `name` varchar(255) CHARACTER SET binary,
1068 MODIFY `keyType` varchar(255) CHARACTER SET binary,
1069 MODIFY `keyBody` text CHARACTER SET binary,
1070 MODIFY `keyHash` varchar(32) CHARACTER SET binary,
1071 MODIFY `keyComment` varchar(255) CHARACTER SET binary;
1072ALTER TABLE `{$NAMESPACE}_user`.`user_sshkey`
1073 COLLATE utf8_general_ci,
1074 MODIFY `userPHID` varchar(64) COLLATE utf8_bin NOT NULL,
1075 MODIFY `name` varchar(255) COLLATE utf8_general_ci,
1076 MODIFY `keyType` varchar(255) COLLATE utf8_general_ci,
1077 MODIFY `keyBody` text COLLATE utf8_bin,
1078 MODIFY `keyHash` varchar(32) COLLATE utf8_bin NOT NULL,
1079 MODIFY `keyComment` varchar(255) COLLATE utf8_general_ci;
1080
1081
1082
1083ALTER DATABASE `{$NAMESPACE}_worker` COLLATE utf8_general_ci;
1084
1085ALTER TABLE `{$NAMESPACE}_worker`.`worker_task`
1086 MODIFY `taskClass` varchar(255) CHARACTER SET binary,
1087 MODIFY `leaseOwner` varchar(255) CHARACTER SET binary;
1088ALTER TABLE `{$NAMESPACE}_worker`.`worker_task`
1089 COLLATE utf8_general_ci,
1090 MODIFY `taskClass` varchar(255) COLLATE utf8_general_ci NOT NULL,
1091 MODIFY `leaseOwner` varchar(255) COLLATE utf8_general_ci;
1092
1093ALTER TABLE `{$NAMESPACE}_worker`.`worker_taskdata`
1094 COLLATE utf8_general_ci,
1095 MODIFY `data` longtext COLLATE utf8_bin NOT NULL;
1096
1097
1098
1099ALTER DATABASE `{$NAMESPACE}_xhpastview` COLLATE utf8_general_ci;
1100
1101ALTER TABLE `{$NAMESPACE}_xhpastview`.`xhpastview_parsetree`
1102 MODIFY `authorPHID` varchar(64) CHARACTER SET binary;
1103ALTER TABLE `{$NAMESPACE}_xhpastview`.`xhpastview_parsetree`
1104 COLLATE utf8_general_ci,
1105 MODIFY `authorPHID` varchar(64) COLLATE utf8_bin,
1106 MODIFY `input` longtext COLLATE utf8_bin NOT NULL,
1107 MODIFY `stdout` longtext COLLATE utf8_bin NOT NULL;