[Summary view] [Print] [Text view]

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