| [ Index ] |
PHP Cross Reference of Phabricator |
[Summary view] [Print] [Text view]
1 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_audit` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2 3 USE `{$NAMESPACE}_audit`; 4 5 CREATE TABLE `audit_transaction` ( 6 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 7 `phid` varbinary(64) NOT NULL, 8 `authorPHID` varbinary(64) NOT NULL, 9 `objectPHID` varbinary(64) NOT NULL, 10 `viewPolicy` varbinary(64) NOT NULL, 11 `editPolicy` varbinary(64) NOT NULL, 12 `commentPHID` varbinary(64) DEFAULT NULL, 13 `commentVersion` int(10) unsigned NOT NULL, 14 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 15 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 16 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 17 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 18 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 19 `dateCreated` int(10) unsigned NOT NULL, 20 `dateModified` int(10) unsigned NOT NULL, 21 PRIMARY KEY (`id`), 22 UNIQUE KEY `key_phid` (`phid`), 23 KEY `key_object` (`objectPHID`) 24 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 25 26 CREATE TABLE `audit_transaction_comment` ( 27 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 28 `phid` varbinary(64) NOT NULL, 29 `transactionPHID` varbinary(64) DEFAULT NULL, 30 `authorPHID` varbinary(64) NOT NULL, 31 `viewPolicy` varbinary(64) NOT NULL, 32 `editPolicy` varbinary(64) NOT NULL, 33 `commentVersion` int(10) unsigned NOT NULL, 34 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 35 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 36 `isDeleted` tinyint(1) NOT NULL, 37 `dateCreated` int(10) unsigned NOT NULL, 38 `dateModified` int(10) unsigned NOT NULL, 39 `commitPHID` varbinary(64) DEFAULT NULL, 40 `pathID` int(10) unsigned DEFAULT NULL, 41 `isNewFile` tinyint(1) NOT NULL, 42 `lineNumber` int(10) unsigned NOT NULL, 43 `lineLength` int(10) unsigned NOT NULL, 44 `fixedState` varchar(12) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 45 `hasReplies` tinyint(1) NOT NULL, 46 `replyToCommentPHID` varbinary(64) DEFAULT NULL, 47 `legacyCommentID` int(10) unsigned DEFAULT NULL, 48 PRIMARY KEY (`id`), 49 UNIQUE KEY `key_phid` (`phid`), 50 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`), 51 KEY `key_path` (`pathID`), 52 KEY `key_draft` (`authorPHID`,`transactionPHID`), 53 KEY `key_commit` (`commitPHID`), 54 KEY `key_legacy` (`legacyCommentID`) 55 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 56 57 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_calendar` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 58 59 USE `{$NAMESPACE}_calendar`; 60 61 CREATE TABLE `calendar_event` ( 62 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 63 `phid` varbinary(64) NOT NULL, 64 `userPHID` varbinary(64) NOT NULL, 65 `dateFrom` int(10) unsigned NOT NULL, 66 `dateTo` int(10) unsigned NOT NULL, 67 `status` int(10) unsigned NOT NULL, 68 `dateCreated` int(10) unsigned NOT NULL, 69 `dateModified` int(10) unsigned NOT NULL, 70 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 71 PRIMARY KEY (`id`), 72 UNIQUE KEY `key_phid` (`phid`), 73 KEY `userPHID_dateFrom` (`userPHID`,`dateTo`) 74 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 75 76 CREATE TABLE `calendar_holiday` ( 77 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 78 `day` date NOT NULL, 79 `name` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 80 PRIMARY KEY (`id`), 81 UNIQUE KEY `day` (`day`) 82 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 83 84 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_chatlog` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 85 86 USE `{$NAMESPACE}_chatlog`; 87 88 CREATE TABLE `chatlog_channel` ( 89 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 90 `serviceName` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 91 `serviceType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 92 `channelName` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 93 `viewPolicy` varbinary(64) NOT NULL, 94 `editPolicy` varbinary(64) NOT NULL, 95 `dateCreated` int(10) unsigned NOT NULL, 96 `dateModified` int(10) unsigned NOT NULL, 97 PRIMARY KEY (`id`), 98 UNIQUE KEY `key_channel` (`channelName`,`serviceType`,`serviceName`) 99 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 100 101 CREATE TABLE `chatlog_event` ( 102 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 103 `epoch` int(10) unsigned NOT NULL, 104 `author` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 105 `type` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 106 `message` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 107 `loggedByPHID` varbinary(64) NOT NULL, 108 `channelID` int(10) unsigned NOT NULL, 109 PRIMARY KEY (`id`), 110 KEY `channel` (`epoch`) 111 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 112 113 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_conduit` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 114 115 USE `{$NAMESPACE}_conduit`; 116 117 CREATE TABLE `conduit_certificatetoken` ( 118 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 119 `userPHID` varbinary(64) NOT NULL, 120 `token` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 121 `dateCreated` int(10) unsigned NOT NULL, 122 `dateModified` int(10) unsigned NOT NULL, 123 PRIMARY KEY (`id`), 124 UNIQUE KEY `userPHID` (`userPHID`), 125 UNIQUE KEY `token` (`token`) 126 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 127 128 CREATE TABLE `conduit_connectionlog` ( 129 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 130 `client` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 131 `clientVersion` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 132 `clientDescription` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 133 `username` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 134 `dateCreated` int(10) unsigned NOT NULL, 135 `dateModified` int(10) unsigned NOT NULL, 136 PRIMARY KEY (`id`), 137 KEY `key_created` (`dateCreated`) 138 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 139 140 CREATE TABLE `conduit_methodcalllog` ( 141 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 142 `connectionID` bigint(20) unsigned DEFAULT NULL, 143 `method` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 144 `error` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 145 `duration` bigint(20) unsigned NOT NULL, 146 `dateCreated` int(10) unsigned NOT NULL, 147 `dateModified` int(10) unsigned NOT NULL, 148 `callerPHID` varbinary(64) DEFAULT NULL, 149 PRIMARY KEY (`id`), 150 KEY `key_method` (`method`), 151 KEY `key_callermethod` (`callerPHID`,`method`), 152 KEY `key_date` (`dateCreated`) 153 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 154 155 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_countdown` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 156 157 USE `{$NAMESPACE}_countdown`; 158 159 CREATE TABLE `countdown` ( 160 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 161 `phid` varbinary(64) NOT NULL, 162 `title` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 163 `authorPHID` varbinary(64) NOT NULL, 164 `epoch` int(10) unsigned NOT NULL, 165 `dateCreated` int(10) unsigned NOT NULL, 166 `dateModified` int(10) unsigned NOT NULL, 167 `viewPolicy` varbinary(64) NOT NULL, 168 PRIMARY KEY (`id`), 169 UNIQUE KEY `key_phid` (`phid`) 170 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 171 172 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_daemon` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 173 174 USE `{$NAMESPACE}_daemon`; 175 176 CREATE TABLE `daemon_log` ( 177 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 178 `daemon` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 179 `host` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 180 `pid` int(10) unsigned NOT NULL, 181 `argv` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 182 `explicitArgv` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 183 `dateCreated` int(10) unsigned NOT NULL, 184 `dateModified` int(10) unsigned NOT NULL, 185 `envHash` binary(40) NOT NULL, 186 `status` varchar(8) COLLATE {$COLLATE_TEXT} NOT NULL, 187 PRIMARY KEY (`id`), 188 KEY `status` (`status`), 189 KEY `dateCreated` (`dateCreated`) 190 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 191 192 CREATE TABLE `daemon_logevent` ( 193 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 194 `logID` int(10) unsigned NOT NULL, 195 `logType` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 196 `message` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 197 `epoch` int(10) unsigned NOT NULL, 198 PRIMARY KEY (`id`), 199 KEY `logID` (`logID`,`epoch`) 200 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 201 202 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_differential` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 203 204 USE `{$NAMESPACE}_differential`; 205 206 CREATE TABLE `differential_affectedpath` ( 207 `repositoryID` int(10) unsigned NOT NULL, 208 `pathID` int(10) unsigned NOT NULL, 209 `epoch` int(10) unsigned NOT NULL, 210 `revisionID` int(10) unsigned NOT NULL, 211 KEY `repositoryID` (`repositoryID`,`pathID`,`epoch`), 212 KEY `revisionID` (`revisionID`) 213 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 214 215 CREATE TABLE `differential_changeset` ( 216 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 217 `diffID` int(10) unsigned NOT NULL, 218 `oldFile` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 219 `filename` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 220 `awayPaths` longtext COLLATE {$COLLATE_TEXT}, 221 `changeType` int(10) unsigned NOT NULL, 222 `fileType` int(10) unsigned NOT NULL, 223 `metadata` longtext COLLATE {$COLLATE_TEXT}, 224 `oldProperties` longtext COLLATE {$COLLATE_TEXT}, 225 `newProperties` longtext COLLATE {$COLLATE_TEXT}, 226 `addLines` int(10) unsigned NOT NULL, 227 `delLines` int(10) unsigned NOT NULL, 228 `dateCreated` int(10) unsigned NOT NULL, 229 `dateModified` int(10) unsigned NOT NULL, 230 PRIMARY KEY (`id`), 231 KEY `diffID` (`diffID`) 232 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 233 234 CREATE TABLE `differential_changeset_parse_cache` ( 235 `id` int(10) unsigned NOT NULL, 236 `cache` longblob NOT NULL, 237 `dateCreated` int(10) unsigned NOT NULL, 238 PRIMARY KEY (`id`), 239 KEY `dateCreated` (`dateCreated`) 240 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 241 242 CREATE TABLE `differential_commit` ( 243 `revisionID` int(10) unsigned NOT NULL, 244 `commitPHID` varbinary(64) NOT NULL, 245 PRIMARY KEY (`revisionID`,`commitPHID`), 246 UNIQUE KEY `commitPHID` (`commitPHID`) 247 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 248 249 CREATE TABLE `differential_customfieldnumericindex` ( 250 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 251 `objectPHID` varbinary(64) NOT NULL, 252 `indexKey` binary(12) NOT NULL, 253 `indexValue` bigint(20) NOT NULL, 254 PRIMARY KEY (`id`), 255 KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`), 256 KEY `key_find` (`indexKey`,`indexValue`) 257 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 258 259 CREATE TABLE `differential_customfieldstorage` ( 260 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 261 `objectPHID` varbinary(64) NOT NULL, 262 `fieldIndex` binary(12) NOT NULL, 263 `fieldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 264 PRIMARY KEY (`id`), 265 UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`) 266 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 267 268 CREATE TABLE `differential_customfieldstringindex` ( 269 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 270 `objectPHID` varbinary(64) NOT NULL, 271 `indexKey` binary(12) NOT NULL, 272 `indexValue` longtext CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 273 PRIMARY KEY (`id`), 274 KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)), 275 KEY `key_find` (`indexKey`,`indexValue`(64)) 276 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 277 278 CREATE TABLE `differential_diff` ( 279 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 280 `phid` varbinary(64) NOT NULL, 281 `revisionID` int(10) unsigned DEFAULT NULL, 282 `authorPHID` varbinary(64) DEFAULT NULL, 283 `repositoryPHID` varbinary(64) DEFAULT NULL, 284 `sourceMachine` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 285 `sourcePath` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 286 `sourceControlSystem` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 287 `sourceControlBaseRevision` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 288 `sourceControlPath` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 289 `lintStatus` int(10) unsigned NOT NULL, 290 `unitStatus` int(10) unsigned NOT NULL, 291 `lineCount` int(10) unsigned NOT NULL, 292 `branch` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 293 `bookmark` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 294 `arcanistProjectPHID` varbinary(64) DEFAULT NULL, 295 `creationMethod` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 296 `dateCreated` int(10) unsigned NOT NULL, 297 `dateModified` int(10) unsigned NOT NULL, 298 `description` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 299 `repositoryUUID` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 300 PRIMARY KEY (`id`), 301 UNIQUE KEY `key_phid` (`phid`), 302 KEY `revisionID` (`revisionID`) 303 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 304 305 CREATE TABLE `differential_diffproperty` ( 306 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 307 `diffID` int(10) unsigned NOT NULL, 308 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 309 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 310 `dateCreated` int(10) unsigned NOT NULL, 311 `dateModified` int(10) unsigned NOT NULL, 312 PRIMARY KEY (`id`), 313 UNIQUE KEY `diffID` (`diffID`,`name`) 314 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 315 316 CREATE TABLE `differential_draft` ( 317 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 318 `objectPHID` varbinary(64) NOT NULL, 319 `authorPHID` varbinary(64) NOT NULL, 320 `draftKey` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 321 `dateCreated` int(10) unsigned NOT NULL, 322 `dateModified` int(10) unsigned NOT NULL, 323 PRIMARY KEY (`id`), 324 UNIQUE KEY `key_unique` (`objectPHID`,`authorPHID`,`draftKey`) 325 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 326 327 CREATE TABLE `differential_hunk` ( 328 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 329 `changesetID` int(10) unsigned NOT NULL, 330 `changes` longtext COLLATE {$COLLATE_TEXT}, 331 `oldOffset` int(10) unsigned NOT NULL, 332 `oldLen` int(10) unsigned NOT NULL, 333 `newOffset` int(10) unsigned NOT NULL, 334 `newLen` int(10) unsigned NOT NULL, 335 `dateCreated` int(10) unsigned NOT NULL, 336 `dateModified` int(10) unsigned NOT NULL, 337 PRIMARY KEY (`id`), 338 KEY `changesetID` (`changesetID`) 339 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 340 341 CREATE TABLE `differential_hunk_modern` ( 342 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 343 `changesetID` int(10) unsigned NOT NULL, 344 `oldOffset` int(10) unsigned NOT NULL, 345 `oldLen` int(10) unsigned NOT NULL, 346 `newOffset` int(10) unsigned NOT NULL, 347 `newLen` int(10) unsigned NOT NULL, 348 `dataType` binary(4) NOT NULL, 349 `dataEncoding` varchar(16) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 350 `dataFormat` binary(4) NOT NULL, 351 `data` longblob NOT NULL, 352 `dateCreated` int(10) unsigned NOT NULL, 353 `dateModified` int(10) unsigned NOT NULL, 354 PRIMARY KEY (`id`), 355 KEY `key_changeset` (`changesetID`), 356 KEY `key_created` (`dateCreated`) 357 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 358 359 CREATE TABLE `differential_revision` ( 360 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 361 `title` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 362 `originalTitle` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 363 `phid` varbinary(64) NOT NULL, 364 `status` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 365 `summary` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 366 `testPlan` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 367 `authorPHID` varbinary(64) DEFAULT NULL, 368 `lastReviewerPHID` varbinary(64) DEFAULT NULL, 369 `lineCount` int(10) unsigned DEFAULT NULL, 370 `dateCreated` int(10) unsigned NOT NULL, 371 `dateModified` int(10) unsigned NOT NULL, 372 `attached` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 373 `mailKey` binary(40) NOT NULL, 374 `branchName` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 375 `arcanistProjectPHID` varbinary(64) DEFAULT NULL, 376 `viewPolicy` varbinary(64) NOT NULL, 377 `editPolicy` varbinary(64) NOT NULL, 378 `repositoryPHID` varbinary(64) DEFAULT NULL, 379 PRIMARY KEY (`id`), 380 UNIQUE KEY `phid` (`phid`), 381 KEY `authorPHID` (`authorPHID`,`status`), 382 KEY `repositoryPHID` (`repositoryPHID`) 383 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 384 385 CREATE TABLE `differential_revisionhash` ( 386 `revisionID` int(10) unsigned NOT NULL, 387 `type` binary(4) NOT NULL, 388 `hash` binary(40) NOT NULL, 389 KEY `type` (`type`,`hash`), 390 KEY `revisionID` (`revisionID`) 391 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 392 393 CREATE TABLE `differential_transaction` ( 394 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 395 `phid` varbinary(64) NOT NULL, 396 `authorPHID` varbinary(64) NOT NULL, 397 `objectPHID` varbinary(64) NOT NULL, 398 `viewPolicy` varbinary(64) NOT NULL, 399 `editPolicy` varbinary(64) NOT NULL, 400 `commentPHID` varbinary(64) DEFAULT NULL, 401 `commentVersion` int(10) unsigned NOT NULL, 402 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 403 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 404 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 405 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 406 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 407 `dateCreated` int(10) unsigned NOT NULL, 408 `dateModified` int(10) unsigned NOT NULL, 409 PRIMARY KEY (`id`), 410 UNIQUE KEY `key_phid` (`phid`), 411 KEY `key_object` (`objectPHID`) 412 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 413 414 CREATE TABLE `differential_transaction_comment` ( 415 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 416 `phid` varbinary(64) NOT NULL, 417 `transactionPHID` varbinary(64) DEFAULT NULL, 418 `authorPHID` varbinary(64) NOT NULL, 419 `viewPolicy` varbinary(64) NOT NULL, 420 `editPolicy` varbinary(64) NOT NULL, 421 `commentVersion` int(10) unsigned NOT NULL, 422 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 423 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 424 `isDeleted` tinyint(1) NOT NULL, 425 `dateCreated` int(10) unsigned NOT NULL, 426 `dateModified` int(10) unsigned NOT NULL, 427 `revisionPHID` varbinary(64) DEFAULT NULL, 428 `changesetID` int(10) unsigned DEFAULT NULL, 429 `isNewFile` tinyint(1) NOT NULL, 430 `lineNumber` int(10) unsigned NOT NULL, 431 `lineLength` int(10) unsigned NOT NULL, 432 `fixedState` varchar(12) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 433 `hasReplies` tinyint(1) NOT NULL, 434 `replyToCommentPHID` varbinary(64) DEFAULT NULL, 435 PRIMARY KEY (`id`), 436 UNIQUE KEY `key_phid` (`phid`), 437 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`), 438 KEY `key_changeset` (`changesetID`), 439 KEY `key_draft` (`authorPHID`,`transactionPHID`), 440 KEY `key_revision` (`revisionPHID`) 441 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 442 443 CREATE TABLE `edge` ( 444 `src` varbinary(64) NOT NULL, 445 `type` int(10) unsigned NOT NULL, 446 `dst` varbinary(64) NOT NULL, 447 `dateCreated` int(10) unsigned NOT NULL, 448 `seq` int(10) unsigned NOT NULL, 449 `dataID` int(10) unsigned DEFAULT NULL, 450 PRIMARY KEY (`src`,`type`,`dst`), 451 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 452 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 453 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 454 455 CREATE TABLE `edgedata` ( 456 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 457 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 458 PRIMARY KEY (`id`) 459 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 460 461 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_draft` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 462 463 USE `{$NAMESPACE}_draft`; 464 465 CREATE TABLE `draft` ( 466 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 467 `authorPHID` varbinary(64) NOT NULL, 468 `draftKey` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 469 `draft` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 470 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 471 `dateCreated` int(10) unsigned NOT NULL, 472 `dateModified` int(10) unsigned NOT NULL, 473 PRIMARY KEY (`id`), 474 UNIQUE KEY `authorPHID` (`authorPHID`,`draftKey`) 475 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 476 477 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_drydock` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 478 479 USE `{$NAMESPACE}_drydock`; 480 481 CREATE TABLE `drydock_blueprint` ( 482 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 483 `phid` varbinary(64) NOT NULL, 484 `className` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 485 `blueprintName` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 486 `viewPolicy` varbinary(64) NOT NULL, 487 `editPolicy` varbinary(64) NOT NULL, 488 `details` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 489 `dateCreated` int(10) unsigned NOT NULL, 490 `dateModified` int(10) unsigned NOT NULL, 491 PRIMARY KEY (`id`), 492 UNIQUE KEY `key_phid` (`phid`) 493 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 494 495 CREATE TABLE `drydock_blueprinttransaction` ( 496 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 497 `phid` varbinary(64) NOT NULL, 498 `authorPHID` varbinary(64) NOT NULL, 499 `objectPHID` varbinary(64) NOT NULL, 500 `viewPolicy` varbinary(64) NOT NULL, 501 `editPolicy` varbinary(64) NOT NULL, 502 `commentPHID` varbinary(64) DEFAULT NULL, 503 `commentVersion` int(10) unsigned NOT NULL, 504 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 505 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 506 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 507 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 508 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 509 `dateCreated` int(10) unsigned NOT NULL, 510 `dateModified` int(10) unsigned NOT NULL, 511 PRIMARY KEY (`id`), 512 UNIQUE KEY `key_phid` (`phid`), 513 KEY `key_object` (`objectPHID`) 514 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 515 516 CREATE TABLE `drydock_lease` ( 517 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 518 `phid` varbinary(64) NOT NULL, 519 `resourceID` int(10) unsigned DEFAULT NULL, 520 `status` int(10) unsigned NOT NULL, 521 `until` int(10) unsigned DEFAULT NULL, 522 `ownerPHID` varbinary(64) DEFAULT NULL, 523 `attributes` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 524 `dateCreated` int(10) unsigned NOT NULL, 525 `dateModified` int(10) unsigned NOT NULL, 526 `taskID` int(10) unsigned DEFAULT NULL, 527 `resourceType` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 528 PRIMARY KEY (`id`), 529 UNIQUE KEY `phid` (`phid`) 530 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 531 532 CREATE TABLE `drydock_log` ( 533 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 534 `resourceID` int(10) unsigned DEFAULT NULL, 535 `leaseID` int(10) unsigned DEFAULT NULL, 536 `epoch` int(10) unsigned NOT NULL, 537 `message` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 538 PRIMARY KEY (`id`), 539 KEY `resourceID` (`resourceID`,`epoch`), 540 KEY `leaseID` (`leaseID`,`epoch`), 541 KEY `epoch` (`epoch`) 542 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 543 544 CREATE TABLE `drydock_resource` ( 545 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 546 `phid` varbinary(64) NOT NULL, 547 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 548 `ownerPHID` varbinary(64) DEFAULT NULL, 549 `status` int(10) unsigned NOT NULL, 550 `type` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 551 `attributes` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 552 `capabilities` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 553 `dateCreated` int(10) unsigned NOT NULL, 554 `dateModified` int(10) unsigned NOT NULL, 555 `blueprintPHID` varbinary(64) NOT NULL, 556 PRIMARY KEY (`id`), 557 UNIQUE KEY `phid` (`phid`) 558 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 559 560 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_feed` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 561 562 USE `{$NAMESPACE}_feed`; 563 564 CREATE TABLE `feed_storydata` ( 565 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 566 `phid` varbinary(64) NOT NULL, 567 `chronologicalKey` bigint(20) unsigned NOT NULL, 568 `storyType` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 569 `storyData` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 570 `authorPHID` varbinary(64) NOT NULL, 571 `dateCreated` int(10) unsigned NOT NULL, 572 `dateModified` int(10) unsigned NOT NULL, 573 PRIMARY KEY (`id`), 574 UNIQUE KEY `chronologicalKey` (`chronologicalKey`), 575 UNIQUE KEY `phid` (`phid`) 576 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 577 578 CREATE TABLE `feed_storynotification` ( 579 `userPHID` varbinary(64) NOT NULL, 580 `primaryObjectPHID` varbinary(64) NOT NULL, 581 `chronologicalKey` bigint(20) unsigned NOT NULL, 582 `hasViewed` tinyint(1) NOT NULL, 583 UNIQUE KEY `userPHID` (`userPHID`,`chronologicalKey`), 584 KEY `userPHID_2` (`userPHID`,`hasViewed`,`primaryObjectPHID`) 585 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 586 587 CREATE TABLE `feed_storyreference` ( 588 `objectPHID` varbinary(64) NOT NULL, 589 `chronologicalKey` bigint(20) unsigned NOT NULL, 590 UNIQUE KEY `objectPHID` (`objectPHID`,`chronologicalKey`), 591 KEY `chronologicalKey` (`chronologicalKey`) 592 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 593 594 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_file` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 595 596 USE `{$NAMESPACE}_file`; 597 598 CREATE TABLE `edge` ( 599 `src` varbinary(64) NOT NULL, 600 `type` int(10) unsigned NOT NULL, 601 `dst` varbinary(64) NOT NULL, 602 `dateCreated` int(10) unsigned NOT NULL, 603 `seq` int(10) unsigned NOT NULL, 604 `dataID` int(10) unsigned DEFAULT NULL, 605 PRIMARY KEY (`src`,`type`,`dst`), 606 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 607 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 608 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 609 610 CREATE TABLE `edgedata` ( 611 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 612 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 613 PRIMARY KEY (`id`) 614 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 615 616 CREATE TABLE `file` ( 617 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 618 `phid` varbinary(64) NOT NULL, 619 `name` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 620 `mimeType` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 621 `byteSize` bigint(20) unsigned NOT NULL, 622 `storageEngine` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 623 `storageFormat` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 624 `storageHandle` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 625 `dateCreated` int(10) unsigned NOT NULL, 626 `dateModified` int(10) unsigned NOT NULL, 627 `authorPHID` varbinary(64) DEFAULT NULL, 628 `secretKey` binary(20) DEFAULT NULL, 629 `contentHash` binary(40) DEFAULT NULL, 630 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 631 `ttl` int(10) unsigned DEFAULT NULL, 632 `isExplicitUpload` tinyint(1) DEFAULT '1', 633 `mailKey` binary(20) NOT NULL, 634 `viewPolicy` varbinary(64) NOT NULL, 635 PRIMARY KEY (`id`), 636 UNIQUE KEY `phid` (`phid`), 637 KEY `authorPHID` (`authorPHID`), 638 KEY `contentHash` (`contentHash`), 639 KEY `key_ttl` (`ttl`), 640 KEY `key_dateCreated` (`dateCreated`) 641 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 642 643 CREATE TABLE `file_imagemacro` ( 644 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 645 `phid` varbinary(64) NOT NULL, 646 `authorPHID` varbinary(64) DEFAULT NULL, 647 `filePHID` varbinary(64) NOT NULL, 648 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 649 `dateCreated` int(10) unsigned NOT NULL, 650 `dateModified` int(10) unsigned NOT NULL, 651 `isDisabled` tinyint(1) NOT NULL, 652 `audioPHID` varbinary(64) DEFAULT NULL, 653 `audioBehavior` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 654 `mailKey` binary(20) NOT NULL, 655 PRIMARY KEY (`id`), 656 UNIQUE KEY `key_phid` (`phid`), 657 UNIQUE KEY `name` (`name`), 658 KEY `key_disabled` (`isDisabled`), 659 KEY `key_dateCreated` (`dateCreated`) 660 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 661 662 CREATE TABLE `file_storageblob` ( 663 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 664 `data` longblob NOT NULL, 665 `dateCreated` int(10) unsigned NOT NULL, 666 `dateModified` int(10) unsigned NOT NULL, 667 PRIMARY KEY (`id`) 668 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 669 670 CREATE TABLE `file_transaction` ( 671 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 672 `phid` varbinary(64) NOT NULL, 673 `authorPHID` varbinary(64) NOT NULL, 674 `objectPHID` varbinary(64) NOT NULL, 675 `viewPolicy` varbinary(64) NOT NULL, 676 `editPolicy` varbinary(64) NOT NULL, 677 `commentPHID` varbinary(64) DEFAULT NULL, 678 `commentVersion` int(10) unsigned NOT NULL, 679 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 680 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 681 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 682 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 683 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 684 `dateCreated` int(10) unsigned NOT NULL, 685 `dateModified` int(10) unsigned NOT NULL, 686 PRIMARY KEY (`id`), 687 UNIQUE KEY `key_phid` (`phid`), 688 KEY `key_object` (`objectPHID`) 689 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 690 691 CREATE TABLE `file_transaction_comment` ( 692 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 693 `phid` varbinary(64) NOT NULL, 694 `transactionPHID` varbinary(64) DEFAULT NULL, 695 `authorPHID` varbinary(64) NOT NULL, 696 `viewPolicy` varbinary(64) NOT NULL, 697 `editPolicy` varbinary(64) NOT NULL, 698 `commentVersion` int(10) unsigned NOT NULL, 699 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 700 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 701 `isDeleted` tinyint(1) NOT NULL, 702 `dateCreated` int(10) unsigned NOT NULL, 703 `dateModified` int(10) unsigned NOT NULL, 704 PRIMARY KEY (`id`), 705 UNIQUE KEY `key_phid` (`phid`), 706 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`), 707 UNIQUE KEY `key_draft` (`authorPHID`,`transactionPHID`) 708 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 709 710 CREATE TABLE `file_transformedfile` ( 711 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 712 `originalPHID` varbinary(64) NOT NULL, 713 `transform` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 714 `transformedPHID` varbinary(64) NOT NULL, 715 `dateCreated` int(10) unsigned NOT NULL, 716 `dateModified` int(10) unsigned NOT NULL, 717 PRIMARY KEY (`id`), 718 UNIQUE KEY `originalPHID` (`originalPHID`,`transform`), 719 KEY `transformedPHID` (`transformedPHID`) 720 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 721 722 CREATE TABLE `macro_transaction` ( 723 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 724 `phid` varbinary(64) NOT NULL, 725 `authorPHID` varbinary(64) NOT NULL, 726 `objectPHID` varbinary(64) NOT NULL, 727 `viewPolicy` varbinary(64) NOT NULL, 728 `editPolicy` varbinary(64) NOT NULL, 729 `commentPHID` varbinary(64) DEFAULT NULL, 730 `commentVersion` int(10) unsigned NOT NULL, 731 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 732 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 733 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 734 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 735 `dateCreated` int(10) unsigned NOT NULL, 736 `dateModified` int(10) unsigned NOT NULL, 737 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 738 PRIMARY KEY (`id`), 739 UNIQUE KEY `key_phid` (`phid`), 740 KEY `key_object` (`objectPHID`) 741 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 742 743 CREATE TABLE `macro_transaction_comment` ( 744 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 745 `phid` varbinary(64) NOT NULL, 746 `transactionPHID` varbinary(64) DEFAULT NULL, 747 `authorPHID` varbinary(64) NOT NULL, 748 `viewPolicy` varbinary(64) NOT NULL, 749 `editPolicy` varbinary(64) NOT NULL, 750 `commentVersion` int(10) unsigned NOT NULL, 751 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 752 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 753 `isDeleted` tinyint(1) NOT NULL, 754 `dateCreated` int(10) unsigned NOT NULL, 755 `dateModified` int(10) unsigned NOT NULL, 756 PRIMARY KEY (`id`), 757 UNIQUE KEY `key_phid` (`phid`), 758 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 759 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 760 761 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_flag` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 762 763 USE `{$NAMESPACE}_flag`; 764 765 CREATE TABLE `flag` ( 766 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 767 `ownerPHID` varbinary(64) NOT NULL, 768 `type` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 769 `objectPHID` varbinary(64) NOT NULL, 770 `reasonPHID` varbinary(64) NOT NULL, 771 `color` int(10) unsigned NOT NULL, 772 `note` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 773 `dateCreated` int(10) unsigned NOT NULL, 774 `dateModified` int(10) unsigned NOT NULL, 775 PRIMARY KEY (`id`), 776 UNIQUE KEY `ownerPHID` (`ownerPHID`,`type`,`objectPHID`), 777 KEY `objectPHID` (`objectPHID`) 778 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 779 780 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_harbormaster` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 781 782 USE `{$NAMESPACE}_harbormaster`; 783 784 CREATE TABLE `edge` ( 785 `src` varbinary(64) NOT NULL, 786 `type` int(10) unsigned NOT NULL, 787 `dst` varbinary(64) NOT NULL, 788 `dateCreated` int(10) unsigned NOT NULL, 789 `seq` int(10) unsigned NOT NULL, 790 `dataID` int(10) unsigned DEFAULT NULL, 791 PRIMARY KEY (`src`,`type`,`dst`), 792 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 793 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 794 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 795 796 CREATE TABLE `edgedata` ( 797 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 798 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 799 PRIMARY KEY (`id`) 800 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 801 802 CREATE TABLE `harbormaster_build` ( 803 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 804 `phid` varbinary(64) NOT NULL, 805 `buildablePHID` varbinary(64) NOT NULL, 806 `buildPlanPHID` varbinary(64) NOT NULL, 807 `buildStatus` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 808 `dateCreated` int(10) unsigned NOT NULL, 809 `dateModified` int(10) unsigned NOT NULL, 810 `buildGeneration` int(10) unsigned NOT NULL DEFAULT '0', 811 PRIMARY KEY (`id`), 812 UNIQUE KEY `key_phid` (`phid`), 813 KEY `key_buildable` (`buildablePHID`), 814 KEY `key_plan` (`buildPlanPHID`), 815 KEY `key_status` (`buildStatus`) 816 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 817 818 CREATE TABLE `harbormaster_buildable` ( 819 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 820 `phid` varbinary(64) NOT NULL, 821 `buildablePHID` varbinary(64) NOT NULL, 822 `containerPHID` varbinary(64) DEFAULT NULL, 823 `buildableStatus` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 824 `dateCreated` int(10) unsigned NOT NULL, 825 `dateModified` int(10) unsigned NOT NULL, 826 `isManualBuildable` tinyint(1) NOT NULL, 827 PRIMARY KEY (`id`), 828 UNIQUE KEY `key_phid` (`phid`), 829 KEY `key_buildable` (`buildablePHID`), 830 KEY `key_container` (`containerPHID`), 831 KEY `key_manual` (`isManualBuildable`) 832 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 833 834 CREATE TABLE `harbormaster_buildabletransaction` ( 835 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 836 `phid` varbinary(64) NOT NULL, 837 `authorPHID` varbinary(64) NOT NULL, 838 `objectPHID` varbinary(64) NOT NULL, 839 `viewPolicy` varbinary(64) NOT NULL, 840 `editPolicy` varbinary(64) NOT NULL, 841 `commentPHID` varbinary(64) DEFAULT NULL, 842 `commentVersion` int(10) unsigned NOT NULL, 843 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 844 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 845 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 846 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 847 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 848 `dateCreated` int(10) unsigned NOT NULL, 849 `dateModified` int(10) unsigned NOT NULL, 850 PRIMARY KEY (`id`), 851 UNIQUE KEY `key_phid` (`phid`), 852 KEY `key_object` (`objectPHID`) 853 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 854 855 CREATE TABLE `harbormaster_buildartifact` ( 856 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 857 `artifactType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 858 `artifactIndex` binary(12) NOT NULL, 859 `artifactKey` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 860 `artifactData` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 861 `dateCreated` int(10) unsigned NOT NULL, 862 `dateModified` int(10) unsigned NOT NULL, 863 `buildTargetPHID` varbinary(64) NOT NULL, 864 PRIMARY KEY (`id`), 865 UNIQUE KEY `key_artifact` (`artifactType`,`artifactIndex`), 866 KEY `key_garbagecollect` (`artifactType`,`dateCreated`) 867 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 868 869 CREATE TABLE `harbormaster_buildcommand` ( 870 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 871 `authorPHID` varbinary(64) NOT NULL, 872 `targetPHID` varbinary(64) NOT NULL, 873 `command` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 874 `dateCreated` int(10) unsigned NOT NULL, 875 `dateModified` int(10) unsigned NOT NULL, 876 PRIMARY KEY (`id`), 877 KEY `key_target` (`targetPHID`) 878 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 879 880 CREATE TABLE `harbormaster_buildlog` ( 881 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 882 `phid` varbinary(64) NOT NULL, 883 `logSource` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 884 `logType` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 885 `duration` int(10) unsigned DEFAULT NULL, 886 `live` tinyint(1) NOT NULL, 887 `dateCreated` int(10) unsigned NOT NULL, 888 `dateModified` int(10) unsigned NOT NULL, 889 `buildTargetPHID` varbinary(64) NOT NULL, 890 PRIMARY KEY (`id`), 891 UNIQUE KEY `key_phid` (`phid`), 892 KEY `key_buildtarget` (`buildTargetPHID`) 893 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 894 895 CREATE TABLE `harbormaster_buildlogchunk` ( 896 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 897 `logID` int(10) unsigned NOT NULL, 898 `encoding` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 899 `size` int(10) unsigned DEFAULT NULL, 900 `chunk` longblob NOT NULL, 901 PRIMARY KEY (`id`), 902 KEY `key_log` (`logID`) 903 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 904 905 CREATE TABLE `harbormaster_buildmessage` ( 906 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 907 `authorPHID` varbinary(64) NOT NULL, 908 `buildTargetPHID` varbinary(64) NOT NULL, 909 `type` varchar(16) COLLATE {$COLLATE_TEXT} NOT NULL, 910 `isConsumed` tinyint(1) NOT NULL, 911 `dateCreated` int(10) unsigned NOT NULL, 912 `dateModified` int(10) unsigned NOT NULL, 913 PRIMARY KEY (`id`), 914 KEY `key_buildtarget` (`buildTargetPHID`) 915 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 916 917 CREATE TABLE `harbormaster_buildplan` ( 918 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 919 `phid` varbinary(64) NOT NULL, 920 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 921 `planStatus` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 922 `dateCreated` int(10) unsigned NOT NULL, 923 `dateModified` int(10) unsigned NOT NULL, 924 PRIMARY KEY (`id`), 925 UNIQUE KEY `key_phid` (`phid`), 926 KEY `key_status` (`planStatus`) 927 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 928 929 CREATE TABLE `harbormaster_buildplantransaction` ( 930 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 931 `phid` varbinary(64) NOT NULL, 932 `authorPHID` varbinary(64) NOT NULL, 933 `objectPHID` varbinary(64) NOT NULL, 934 `viewPolicy` varbinary(64) NOT NULL, 935 `editPolicy` varbinary(64) NOT NULL, 936 `commentPHID` varbinary(64) DEFAULT NULL, 937 `commentVersion` int(10) unsigned NOT NULL, 938 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 939 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 940 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 941 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 942 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 943 `dateCreated` int(10) unsigned NOT NULL, 944 `dateModified` int(10) unsigned NOT NULL, 945 PRIMARY KEY (`id`), 946 UNIQUE KEY `key_phid` (`phid`), 947 KEY `key_object` (`objectPHID`) 948 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 949 950 CREATE TABLE `harbormaster_buildstep` ( 951 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 952 `phid` varbinary(64) NOT NULL, 953 `buildPlanPHID` varbinary(64) NOT NULL, 954 `className` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 955 `details` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 956 `dateCreated` int(10) unsigned NOT NULL, 957 `dateModified` int(10) unsigned NOT NULL, 958 `sequence` int(10) unsigned NOT NULL, 959 `name` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 960 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 961 PRIMARY KEY (`id`), 962 UNIQUE KEY `key_phid` (`phid`), 963 KEY `key_plan` (`buildPlanPHID`) 964 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 965 966 CREATE TABLE `harbormaster_buildsteptransaction` ( 967 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 968 `phid` varbinary(64) NOT NULL, 969 `authorPHID` varbinary(64) NOT NULL, 970 `objectPHID` varbinary(64) NOT NULL, 971 `viewPolicy` varbinary(64) NOT NULL, 972 `editPolicy` varbinary(64) NOT NULL, 973 `commentPHID` varbinary(64) DEFAULT NULL, 974 `commentVersion` int(10) unsigned NOT NULL, 975 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 976 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 977 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 978 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 979 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 980 `dateCreated` int(10) unsigned NOT NULL, 981 `dateModified` int(10) unsigned NOT NULL, 982 PRIMARY KEY (`id`), 983 UNIQUE KEY `key_phid` (`phid`), 984 KEY `key_object` (`objectPHID`) 985 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 986 987 CREATE TABLE `harbormaster_buildtarget` ( 988 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 989 `phid` varbinary(64) NOT NULL, 990 `buildPHID` varbinary(64) NOT NULL, 991 `buildStepPHID` varbinary(64) NOT NULL, 992 `className` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 993 `details` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 994 `variables` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 995 `dateCreated` int(10) unsigned NOT NULL, 996 `dateModified` int(10) unsigned NOT NULL, 997 `targetStatus` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 998 `name` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 999 `dateStarted` int(10) unsigned DEFAULT NULL, 1000 `dateCompleted` int(10) unsigned DEFAULT NULL, 1001 `buildGeneration` int(10) unsigned NOT NULL DEFAULT '0', 1002 PRIMARY KEY (`id`), 1003 UNIQUE KEY `key_phid` (`phid`), 1004 KEY `key_build` (`buildPHID`,`buildStepPHID`) 1005 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1006 1007 CREATE TABLE `harbormaster_buildtransaction` ( 1008 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1009 `phid` varbinary(64) NOT NULL, 1010 `authorPHID` varbinary(64) NOT NULL, 1011 `objectPHID` varbinary(64) NOT NULL, 1012 `viewPolicy` varbinary(64) NOT NULL, 1013 `editPolicy` varbinary(64) NOT NULL, 1014 `commentPHID` varbinary(64) DEFAULT NULL, 1015 `commentVersion` int(10) unsigned NOT NULL, 1016 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1017 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1018 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1019 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1020 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1021 `dateCreated` int(10) unsigned NOT NULL, 1022 `dateModified` int(10) unsigned NOT NULL, 1023 PRIMARY KEY (`id`), 1024 UNIQUE KEY `key_phid` (`phid`), 1025 KEY `key_object` (`objectPHID`) 1026 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1027 1028 CREATE TABLE `harbormaster_object` ( 1029 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1030 `phid` varbinary(64) NOT NULL, 1031 `name` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1032 `dateCreated` int(10) unsigned NOT NULL, 1033 `dateModified` int(10) unsigned NOT NULL, 1034 PRIMARY KEY (`id`), 1035 UNIQUE KEY `key_phid` (`phid`) 1036 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1037 1038 CREATE TABLE `harbormaster_scratchtable` ( 1039 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1040 `data` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 1041 `dateCreated` int(10) unsigned NOT NULL, 1042 `dateModified` int(10) unsigned NOT NULL, 1043 `bigData` longtext COLLATE {$COLLATE_TEXT}, 1044 PRIMARY KEY (`id`), 1045 KEY `data` (`data`) 1046 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1047 1048 CREATE TABLE `lisk_counter` ( 1049 `counterName` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1050 `counterValue` bigint(20) unsigned NOT NULL, 1051 PRIMARY KEY (`counterName`) 1052 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1053 1054 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_herald` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1055 1056 USE `{$NAMESPACE}_herald`; 1057 1058 CREATE TABLE `herald_action` ( 1059 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1060 `ruleID` int(10) unsigned NOT NULL, 1061 `action` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1062 `target` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1063 PRIMARY KEY (`id`), 1064 KEY `ruleID` (`ruleID`) 1065 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1066 1067 CREATE TABLE `herald_condition` ( 1068 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1069 `ruleID` int(10) unsigned NOT NULL, 1070 `fieldName` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1071 `fieldCondition` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1072 `value` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1073 PRIMARY KEY (`id`), 1074 KEY `ruleID` (`ruleID`) 1075 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1076 1077 CREATE TABLE `herald_rule` ( 1078 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1079 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1080 `authorPHID` varbinary(64) NOT NULL, 1081 `contentType` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1082 `mustMatchAll` tinyint(1) NOT NULL, 1083 `configVersion` int(10) unsigned NOT NULL DEFAULT '1', 1084 `dateCreated` int(10) unsigned NOT NULL, 1085 `dateModified` int(10) unsigned NOT NULL, 1086 `repetitionPolicy` int(10) unsigned DEFAULT NULL, 1087 `ruleType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1088 `phid` varbinary(64) NOT NULL, 1089 `isDisabled` int(10) unsigned NOT NULL DEFAULT '0', 1090 `triggerObjectPHID` varbinary(64) DEFAULT NULL, 1091 PRIMARY KEY (`id`), 1092 UNIQUE KEY `key_phid` (`phid`), 1093 KEY `key_trigger` (`triggerObjectPHID`), 1094 KEY `key_author` (`authorPHID`), 1095 KEY `key_ruletype` (`ruleType`) 1096 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1097 1098 CREATE TABLE `herald_ruleapplied` ( 1099 `ruleID` int(10) unsigned NOT NULL, 1100 `phid` varbinary(64) NOT NULL, 1101 PRIMARY KEY (`ruleID`,`phid`), 1102 KEY `phid` (`phid`) 1103 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1104 1105 CREATE TABLE `herald_ruleedit` ( 1106 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1107 `ruleID` int(10) unsigned NOT NULL, 1108 `editorPHID` varbinary(64) NOT NULL, 1109 `dateCreated` int(10) unsigned NOT NULL, 1110 `dateModified` int(10) unsigned NOT NULL, 1111 `ruleName` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1112 `action` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1113 PRIMARY KEY (`id`), 1114 KEY `ruleID` (`ruleID`,`dateCreated`) 1115 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1116 1117 CREATE TABLE `herald_ruletransaction` ( 1118 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1119 `phid` varbinary(64) NOT NULL, 1120 `authorPHID` varbinary(64) NOT NULL, 1121 `objectPHID` varbinary(64) NOT NULL, 1122 `viewPolicy` varbinary(64) NOT NULL, 1123 `editPolicy` varbinary(64) NOT NULL, 1124 `commentPHID` varbinary(64) DEFAULT NULL, 1125 `commentVersion` int(10) unsigned NOT NULL, 1126 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1127 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1128 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1129 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1130 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1131 `dateCreated` int(10) unsigned NOT NULL, 1132 `dateModified` int(10) unsigned NOT NULL, 1133 PRIMARY KEY (`id`), 1134 UNIQUE KEY `key_phid` (`phid`), 1135 KEY `key_object` (`objectPHID`) 1136 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1137 1138 CREATE TABLE `herald_ruletransaction_comment` ( 1139 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1140 `phid` varbinary(64) NOT NULL, 1141 `transactionPHID` varbinary(64) DEFAULT NULL, 1142 `authorPHID` varbinary(64) NOT NULL, 1143 `viewPolicy` varbinary(64) NOT NULL, 1144 `editPolicy` varbinary(64) NOT NULL, 1145 `commentVersion` int(10) unsigned NOT NULL, 1146 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1147 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1148 `isDeleted` tinyint(1) NOT NULL, 1149 `dateCreated` int(10) unsigned NOT NULL, 1150 `dateModified` int(10) unsigned NOT NULL, 1151 PRIMARY KEY (`id`), 1152 UNIQUE KEY `key_phid` (`phid`), 1153 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 1154 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1155 1156 CREATE TABLE `herald_savedheader` ( 1157 `phid` varbinary(64) NOT NULL, 1158 `header` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1159 PRIMARY KEY (`phid`) 1160 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1161 1162 CREATE TABLE `herald_transcript` ( 1163 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1164 `phid` varbinary(64) NOT NULL, 1165 `time` int(10) unsigned NOT NULL, 1166 `host` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1167 `duration` double NOT NULL, 1168 `objectPHID` varbinary(64) NOT NULL, 1169 `dryRun` tinyint(1) NOT NULL, 1170 `objectTranscript` longblob NOT NULL, 1171 `ruleTranscripts` longblob NOT NULL, 1172 `conditionTranscripts` longblob NOT NULL, 1173 `applyTranscripts` longblob NOT NULL, 1174 `garbageCollected` tinyint(1) NOT NULL DEFAULT '0', 1175 PRIMARY KEY (`id`), 1176 UNIQUE KEY `phid` (`phid`), 1177 KEY `objectPHID` (`objectPHID`), 1178 KEY `garbageCollected` (`garbageCollected`,`time`) 1179 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1180 1181 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_maniphest` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1182 1183 USE `{$NAMESPACE}_maniphest`; 1184 1185 CREATE TABLE `edge` ( 1186 `src` varbinary(64) NOT NULL, 1187 `type` int(10) unsigned NOT NULL, 1188 `dst` varbinary(64) NOT NULL, 1189 `dateCreated` int(10) unsigned NOT NULL, 1190 `seq` int(10) unsigned NOT NULL, 1191 `dataID` int(10) unsigned DEFAULT NULL, 1192 PRIMARY KEY (`src`,`type`,`dst`), 1193 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 1194 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 1195 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1196 1197 CREATE TABLE `edgedata` ( 1198 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1199 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1200 PRIMARY KEY (`id`) 1201 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1202 1203 CREATE TABLE `maniphest_customfieldnumericindex` ( 1204 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1205 `objectPHID` varbinary(64) NOT NULL, 1206 `indexKey` binary(12) NOT NULL, 1207 `indexValue` bigint(20) NOT NULL, 1208 PRIMARY KEY (`id`), 1209 KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`), 1210 KEY `key_find` (`indexKey`,`indexValue`) 1211 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1212 1213 CREATE TABLE `maniphest_customfieldstorage` ( 1214 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1215 `objectPHID` varbinary(64) NOT NULL, 1216 `fieldIndex` binary(12) NOT NULL, 1217 `fieldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1218 PRIMARY KEY (`id`), 1219 UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`) 1220 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1221 1222 CREATE TABLE `maniphest_customfieldstringindex` ( 1223 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1224 `objectPHID` varbinary(64) NOT NULL, 1225 `indexKey` binary(12) NOT NULL, 1226 `indexValue` longtext CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1227 PRIMARY KEY (`id`), 1228 KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)), 1229 KEY `key_find` (`indexKey`,`indexValue`(64)) 1230 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1231 1232 CREATE TABLE `maniphest_nameindex` ( 1233 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1234 `indexedObjectPHID` varbinary(64) NOT NULL, 1235 `indexedObjectName` varchar(128) CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1236 PRIMARY KEY (`id`), 1237 UNIQUE KEY `key_phid` (`indexedObjectPHID`), 1238 KEY `key_name` (`indexedObjectName`) 1239 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1240 1241 CREATE TABLE `maniphest_task` ( 1242 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1243 `phid` varbinary(64) NOT NULL, 1244 `authorPHID` varbinary(64) NOT NULL, 1245 `ownerPHID` varbinary(64) DEFAULT NULL, 1246 `ccPHIDs` longtext COLLATE {$COLLATE_TEXT}, 1247 `attached` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1248 `status` varchar(12) COLLATE {$COLLATE_TEXT} NOT NULL, 1249 `priority` int(10) unsigned NOT NULL, 1250 `title` longtext CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1251 `originalTitle` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1252 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1253 `dateCreated` int(10) unsigned NOT NULL, 1254 `dateModified` int(10) unsigned NOT NULL, 1255 `projectPHIDs` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1256 `mailKey` binary(20) NOT NULL, 1257 `ownerOrdering` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1258 `originalEmailSource` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1259 `subpriority` double NOT NULL, 1260 `viewPolicy` varbinary(64) NOT NULL, 1261 `editPolicy` varbinary(64) NOT NULL, 1262 PRIMARY KEY (`id`), 1263 UNIQUE KEY `phid` (`phid`), 1264 KEY `priority` (`priority`,`status`), 1265 KEY `status` (`status`), 1266 KEY `ownerPHID` (`ownerPHID`,`status`), 1267 KEY `authorPHID` (`authorPHID`,`status`), 1268 KEY `ownerOrdering` (`ownerOrdering`), 1269 KEY `priority_2` (`priority`,`subpriority`), 1270 KEY `key_dateCreated` (`dateCreated`), 1271 KEY `key_dateModified` (`dateModified`), 1272 KEY `key_title` (`title`(64)) 1273 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1274 1275 CREATE TABLE `maniphest_tasksubscriber` ( 1276 `taskPHID` varbinary(64) NOT NULL, 1277 `subscriberPHID` varbinary(64) NOT NULL, 1278 PRIMARY KEY (`subscriberPHID`,`taskPHID`), 1279 UNIQUE KEY `taskPHID` (`taskPHID`,`subscriberPHID`) 1280 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1281 1282 CREATE TABLE `maniphest_transaction` ( 1283 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1284 `phid` varbinary(64) NOT NULL, 1285 `authorPHID` varbinary(64) NOT NULL, 1286 `objectPHID` varbinary(64) NOT NULL, 1287 `viewPolicy` varbinary(64) NOT NULL, 1288 `editPolicy` varbinary(64) NOT NULL, 1289 `commentPHID` varbinary(64) DEFAULT NULL, 1290 `commentVersion` int(10) unsigned NOT NULL, 1291 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1292 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1293 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1294 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1295 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1296 `dateCreated` int(10) unsigned NOT NULL, 1297 `dateModified` int(10) unsigned NOT NULL, 1298 PRIMARY KEY (`id`), 1299 UNIQUE KEY `key_phid` (`phid`), 1300 KEY `key_object` (`objectPHID`) 1301 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1302 1303 CREATE TABLE `maniphest_transaction_comment` ( 1304 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1305 `phid` varbinary(64) NOT NULL, 1306 `transactionPHID` varbinary(64) DEFAULT NULL, 1307 `authorPHID` varbinary(64) NOT NULL, 1308 `viewPolicy` varbinary(64) NOT NULL, 1309 `editPolicy` varbinary(64) NOT NULL, 1310 `commentVersion` int(10) unsigned NOT NULL, 1311 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1312 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1313 `isDeleted` tinyint(1) NOT NULL, 1314 `dateCreated` int(10) unsigned NOT NULL, 1315 `dateModified` int(10) unsigned NOT NULL, 1316 PRIMARY KEY (`id`), 1317 UNIQUE KEY `key_phid` (`phid`), 1318 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 1319 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1320 1321 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_meta_data` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1322 1323 USE `{$NAMESPACE}_meta_data`; 1324 1325 CREATE TABLE `patch_status` ( 1326 `patch` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 1327 `applied` int(10) unsigned NOT NULL, 1328 PRIMARY KEY (`patch`) 1329 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1330 1331 INSERT INTO `patch_status` VALUES ('phabricator:000.project.sql',1415307258),('phabricator:0000.legacy.sql',1415307258),('phabricator:001.maniphest_projects.sql',1415307258),('phabricator:002.oauth.sql',1415307258),('phabricator:003.more_oauth.sql',1415307258),('phabricator:004.daemonrepos.sql',1415307258),('phabricator:005.workers.sql',1415307258),('phabricator:006.repository.sql',1415307258),('phabricator:007.daemonlog.sql',1415307258),('phabricator:008.repoopt.sql',1415307258),('phabricator:009.repo_summary.sql',1415307258),('phabricator:010.herald.sql',1415307258),('phabricator:011.badcommit.sql',1415307258),('phabricator:012.dropphidtype.sql',1415307258),('phabricator:013.commitdetail.sql',1415307258),('phabricator:014.shortcuts.sql',1415307258),('phabricator:015.preferences.sql',1415307258),('phabricator:016.userrealnameindex.sql',1415307258),('phabricator:017.sessionkeys.sql',1415307258),('phabricator:018.owners.sql',1415307258),('phabricator:019.arcprojects.sql',1415307258),('phabricator:020.pathcapital.sql',1415307258),('phabricator:021.xhpastview.sql',1415307258),('phabricator:022.differentialcommit.sql',1415307258),('phabricator:023.dxkeys.sql',1415307259),('phabricator:024.mlistkeys.sql',1415307259),('phabricator:025.commentopt.sql',1415307259),('phabricator:026.diffpropkey.sql',1415307259),('phabricator:027.metamtakeys.sql',1415307259),('phabricator:028.systemagent.sql',1415307259),('phabricator:029.cursors.sql',1415307259),('phabricator:030.imagemacro.sql',1415307259),('phabricator:031.workerrace.sql',1415307259),('phabricator:032.viewtime.sql',1415307259),('phabricator:033.privtest.sql',1415307259),('phabricator:034.savedheader.sql',1415307259),('phabricator:035.proxyimage.sql',1415307259),('phabricator:036.mailkey.sql',1415307259),('phabricator:037.setuptest.sql',1415307259),('phabricator:038.admin.sql',1415307259),('phabricator:039.userlog.sql',1415307259),('phabricator:040.transform.sql',1415307259),('phabricator:041.heraldrepetition.sql',1415307259),('phabricator:042.commentmetadata.sql',1415307259),('phabricator:043.pastebin.sql',1415307259),('phabricator:044.countdown.sql',1415307259),('phabricator:045.timezone.sql',1415307259),('phabricator:046.conduittoken.sql',1415307259),('phabricator:047.projectstatus.sql',1415307259),('phabricator:048.relationshipkeys.sql',1415307259),('phabricator:049.projectowner.sql',1415307259),('phabricator:050.taskdenormal.sql',1415307259),('phabricator:051.projectfilter.sql',1415307259),('phabricator:052.pastelanguage.sql',1415307259),('phabricator:053.feed.sql',1415307259),('phabricator:054.subscribers.sql',1415307259),('phabricator:055.add_author_to_files.sql',1415307259),('phabricator:056.slowvote.sql',1415307259),('phabricator:057.parsecache.sql',1415307259),('phabricator:058.missingkeys.sql',1415307259),('phabricator:059.engines.php',1415307259),('phabricator:060.phriction.sql',1415307260),('phabricator:061.phrictioncontent.sql',1415307260),('phabricator:062.phrictionmenu.sql',1415307260),('phabricator:063.pasteforks.sql',1415307260),('phabricator:064.subprojects.sql',1415307260),('phabricator:065.sshkeys.sql',1415307260),('phabricator:066.phrictioncontent.sql',1415307260),('phabricator:067.preferences.sql',1415307260),('phabricator:068.maniphestauxiliarystorage.sql',1415307260),('phabricator:069.heraldxscript.sql',1415307260),('phabricator:070.differentialaux.sql',1415307260),('phabricator:071.contentsource.sql',1415307260),('phabricator:072.blamerevert.sql',1415307260),('phabricator:073.reposymbols.sql',1415307260),('phabricator:074.affectedpath.sql',1415307260),('phabricator:075.revisionhash.sql',1415307260),('phabricator:076.indexedlanguages.sql',1415307260),('phabricator:077.originalemail.sql',1415307260),('phabricator:078.nametoken.sql',1415307260),('phabricator:079.nametokenindex.php',1415307260),('phabricator:080.filekeys.sql',1415307260),('phabricator:081.filekeys.php',1415307260),('phabricator:082.xactionkey.sql',1415307260),('phabricator:083.dxviewtime.sql',1415307260),('phabricator:084.pasteauthorkey.sql',1415307260),('phabricator:085.packagecommitrelationship.sql',1415307260),('phabricator:086.formeraffil.sql',1415307260),('phabricator:087.phrictiondelete.sql',1415307260),('phabricator:088.audit.sql',1415307260),('phabricator:089.projectwiki.sql',1415307260),('phabricator:090.forceuniqueprojectnames.php',1415307260),('phabricator:091.uniqueslugkey.sql',1415307260),('phabricator:092.dropgithubnotification.sql',1415307260),('phabricator:093.gitremotes.php',1415307260),('phabricator:094.phrictioncolumn.sql',1415307260),('phabricator:095.directory.sql',1415307260),('phabricator:096.filename.sql',1415307260),('phabricator:097.heraldruletypes.sql',1415307260),('phabricator:098.heraldruletypemigration.php',1415307260),('phabricator:099.drydock.sql',1415307260),('phabricator:100.projectxaction.sql',1415307260),('phabricator:101.heraldruleapplied.sql',1415307260),('phabricator:102.heraldcleanup.php',1415307260),('phabricator:103.heraldedithistory.sql',1415307260),('phabricator:104.searchkey.sql',1415307260),('phabricator:105.mimetype.sql',1415307260),('phabricator:106.chatlog.sql',1415307260),('phabricator:107.oauthserver.sql',1415307260),('phabricator:108.oauthscope.sql',1415307260),('phabricator:109.oauthclientphidkey.sql',1415307260),('phabricator:110.commitaudit.sql',1415307260),('phabricator:111.commitauditmigration.php',1415307260),('phabricator:112.oauthaccesscoderedirecturi.sql',1415307260),('phabricator:113.lastreviewer.sql',1415307260),('phabricator:114.auditrequest.sql',1415307260),('phabricator:115.prepareutf8.sql',1415307260),('phabricator:116.utf8-backup-first-expect-wait.sql',1415307263),('phabricator:117.repositorydescription.php',1415307263),('phabricator:118.auditinline.sql',1415307263),('phabricator:119.filehash.sql',1415307263),('phabricator:120.noop.sql',1415307263),('phabricator:121.drydocklog.sql',1415307263),('phabricator:122.flag.sql',1415307263),('phabricator:123.heraldrulelog.sql',1415307263),('phabricator:124.subpriority.sql',1415307263),('phabricator:125.ipv6.sql',1415307263),('phabricator:126.edges.sql',1415307263),('phabricator:127.userkeybody.sql',1415307263),('phabricator:128.phabricatorcom.sql',1415307263),('phabricator:129.savedquery.sql',1415307263),('phabricator:130.denormalrevisionquery.sql',1415307263),('phabricator:131.migraterevisionquery.php',1415307263),('phabricator:132.phame.sql',1415307263),('phabricator:133.imagemacro.sql',1415307263),('phabricator:134.emptysearch.sql',1415307263),('phabricator:135.datecommitted.sql',1415307263),('phabricator:136.sex.sql',1415307263),('phabricator:137.auditmetadata.sql',1415307263),('phabricator:138.notification.sql',1415307263),('phabricator:20121209.pholioxactions.sql',1415307264),('phabricator:20121209.xmacroadd.sql',1415307264),('phabricator:20121209.xmacromigrate.php',1415307264),('phabricator:20121209.xmacromigratekey.sql',1415307264),('phabricator:20121220.generalcache.sql',1415307264),('phabricator:20121226.config.sql',1415307264),('phabricator:20130101.confxaction.sql',1415307264),('phabricator:20130102.metamtareceivedmailmessageidhash.sql',1415307264),('phabricator:20130103.filemetadata.sql',1415307264),('phabricator:20130111.conpherence.sql',1415307264),('phabricator:20130127.altheraldtranscript.sql',1415307264),('phabricator:20130131.conpherencepics.sql',1415307264),('phabricator:20130201.revisionunsubscribed.php',1415307264),('phabricator:20130201.revisionunsubscribed.sql',1415307264),('phabricator:20130214.chatlogchannel.sql',1415307264),('phabricator:20130214.chatlogchannelid.sql',1415307264),('phabricator:20130214.token.sql',1415307264),('phabricator:20130215.phabricatorfileaddttl.sql',1415307264),('phabricator:20130217.cachettl.sql',1415307264),('phabricator:20130218.longdaemon.sql',1415307264),('phabricator:20130218.updatechannelid.php',1415307264),('phabricator:20130219.commitsummary.sql',1415307264),('phabricator:20130219.commitsummarymig.php',1415307264),('phabricator:20130222.dropchannel.sql',1415307264),('phabricator:20130226.commitkey.sql',1415307264),('phabricator:20130304.lintauthor.sql',1415307264),('phabricator:20130310.xactionmeta.sql',1415307265),('phabricator:20130317.phrictionedge.sql',1415307265),('phabricator:20130319.conpherence.sql',1415307265),('phabricator:20130319.phabricatorfileexplicitupload.sql',1415307265),('phabricator:20130320.phlux.sql',1415307265),('phabricator:20130321.token.sql',1415307265),('phabricator:20130322.phortune.sql',1415307265),('phabricator:20130323.phortunepayment.sql',1415307265),('phabricator:20130324.phortuneproduct.sql',1415307265),('phabricator:20130330.phrequent.sql',1415307265),('phabricator:20130403.conpherencecache.sql',1415307265),('phabricator:20130403.conpherencecachemig.php',1415307265),('phabricator:20130409.commitdrev.php',1415307265),('phabricator:20130417.externalaccount.sql',1415307265),('phabricator:20130423.conpherenceindices.sql',1415307265),('phabricator:20130423.phortunepaymentrevised.sql',1415307265),('phabricator:20130423.updateexternalaccount.sql',1415307265),('phabricator:20130426.search_savedquery.sql',1415307265),('phabricator:20130502.countdownrevamp1.sql',1415307265),('phabricator:20130502.countdownrevamp2.php',1415307265),('phabricator:20130502.countdownrevamp3.sql',1415307265),('phabricator:20130507.releephrqmailkey.sql',1415307265),('phabricator:20130507.releephrqmailkeypop.php',1415307265),('phabricator:20130507.releephrqsimplifycols.sql',1415307265),('phabricator:20130508.releephtransactions.sql',1415307265),('phabricator:20130508.releephtransactionsmig.php',1415307265),('phabricator:20130508.search_namedquery.sql',1415307265),('phabricator:20130513.receviedmailstatus.sql',1415307265),('phabricator:20130519.diviner.sql',1415307265),('phabricator:20130521.dropconphimages.sql',1415307265),('phabricator:20130523.maniphest_owners.sql',1415307265),('phabricator:20130524.repoxactions.sql',1415307265),('phabricator:20130529.macroauthor.sql',1415307265),('phabricator:20130529.macroauthormig.php',1415307265),('phabricator:20130530.macrodatekey.sql',1415307265),('phabricator:20130530.pastekeys.sql',1415307265),('phabricator:20130530.sessionhash.php',1415307265),('phabricator:20130531.filekeys.sql',1415307265),('phabricator:20130602.morediviner.sql',1415307265),('phabricator:20130602.namedqueries.sql',1415307265),('phabricator:20130606.userxactions.sql',1415307265),('phabricator:20130607.xaccount.sql',1415307265),('phabricator:20130611.migrateoauth.php',1415307265),('phabricator:20130611.nukeldap.php',1415307265),('phabricator:20130613.authdb.sql',1415307265),('phabricator:20130619.authconf.php',1415307265),('phabricator:20130620.diffxactions.sql',1415307265),('phabricator:20130621.diffcommentphid.sql',1415307265),('phabricator:20130621.diffcommentphidmig.php',1415307265),('phabricator:20130621.diffcommentunphid.sql',1415307266),('phabricator:20130622.doorkeeper.sql',1415307266),('phabricator:20130628.legalpadv0.sql',1415307266),('phabricator:20130701.conduitlog.sql',1415307266),('phabricator:20130703.legalpaddocdenorm.php',1415307266),('phabricator:20130703.legalpaddocdenorm.sql',1415307266),('phabricator:20130709.droptimeline.sql',1415307266),('phabricator:20130709.legalpadsignature.sql',1415307266),('phabricator:20130711.pholioimageobsolete.php',1415307266),('phabricator:20130711.pholioimageobsolete.sql',1415307266),('phabricator:20130711.pholioimageobsolete2.sql',1415307266),('phabricator:20130711.trimrealnames.php',1415307266),('phabricator:20130714.votexactions.sql',1415307266),('phabricator:20130715.votecomments.php',1415307266),('phabricator:20130715.voteedges.sql',1415307266),('phabricator:20130716.archivememberlessprojects.php',1415307266),('phabricator:20130722.pholioreplace.sql',1415307266),('phabricator:20130723.taskstarttime.sql',1415307266),('phabricator:20130726.ponderxactions.sql',1415307266),('phabricator:20130727.ponderquestionstatus.sql',1415307266),('phabricator:20130728.ponderunique.php',1415307266),('phabricator:20130728.ponderuniquekey.sql',1415307266),('phabricator:20130728.ponderxcomment.php',1415307266),('phabricator:20130731.releephcutpointidentifier.sql',1415307266),('phabricator:20130731.releephproject.sql',1415307266),('phabricator:20130731.releephrepoid.sql',1415307266),('phabricator:20130801.pastexactions.php',1415307266),('phabricator:20130801.pastexactions.sql',1415307266),('phabricator:20130802.heraldphid.sql',1415307266),('phabricator:20130802.heraldphids.php',1415307266),('phabricator:20130802.heraldphidukey.sql',1415307266),('phabricator:20130802.heraldxactions.sql',1415307266),('phabricator:20130805.pasteedges.sql',1415307266),('phabricator:20130805.pastemailkey.sql',1415307266),('phabricator:20130805.pastemailkeypop.php',1415307266),('phabricator:20130814.usercustom.sql',1415307266),('phabricator:20130820.file-mailkey-populate.php',1415307266),('phabricator:20130820.filemailkey.sql',1415307266),('phabricator:20130820.filexactions.sql',1415307266),('phabricator:20130820.releephxactions.sql',1415307266),('phabricator:20130826.divinernode.sql',1415307266),('phabricator:20130912.maniphest.1.touch.sql',1415307266),('phabricator:20130912.maniphest.2.created.sql',1415307266),('phabricator:20130912.maniphest.3.nameindex.sql',1415307266),('phabricator:20130912.maniphest.4.fillindex.php',1415307266),('phabricator:20130913.maniphest.1.migratesearch.php',1415307266),('phabricator:20130914.usercustom.sql',1415307266),('phabricator:20130915.maniphestcustom.sql',1415307266),('phabricator:20130915.maniphestmigrate.php',1415307266),('phabricator:20130915.maniphestqdrop.sql',1415307267),('phabricator:20130919.mfieldconf.php',1415307266),('phabricator:20130920.repokeyspolicy.sql',1415307266),('phabricator:20130921.mtransactions.sql',1415307266),('phabricator:20130921.xmigratemaniphest.php',1415307266),('phabricator:20130923.mrename.sql',1415307266),('phabricator:20130924.mdraftkey.sql',1415307267),('phabricator:20130925.mpolicy.sql',1415307267),('phabricator:20130925.xpolicy.sql',1415307267),('phabricator:20130926.dcustom.sql',1415307267),('phabricator:20130926.dinkeys.sql',1415307267),('phabricator:20130926.dinline.php',1415307267),('phabricator:20130927.audiomacro.sql',1415307267),('phabricator:20130929.filepolicy.sql',1415307267),('phabricator:20131004.dxedgekey.sql',1415307267),('phabricator:20131004.dxreviewers.php',1415307267),('phabricator:20131006.hdisable.sql',1415307267),('phabricator:20131010.pstorage.sql',1415307267),('phabricator:20131015.cpolicy.sql',1415307267),('phabricator:20131020.col1.sql',1415307267),('phabricator:20131020.harbormaster.sql',1415307267),('phabricator:20131020.pcustom.sql',1415307267),('phabricator:20131020.pxaction.sql',1415307267),('phabricator:20131020.pxactionmig.php',1415307267),('phabricator:20131025.repopush.sql',1415307267),('phabricator:20131026.commitstatus.sql',1415307267),('phabricator:20131030.repostatusmessage.sql',1415307267),('phabricator:20131031.vcspassword.sql',1415307267),('phabricator:20131105.buildstep.sql',1415307267),('phabricator:20131106.diffphid.1.col.sql',1415307267),('phabricator:20131106.diffphid.2.mig.php',1415307267),('phabricator:20131106.diffphid.3.key.sql',1415307267),('phabricator:20131106.nuance-v0.sql',1415307267),('phabricator:20131107.buildlog.sql',1415307267),('phabricator:20131112.userverified.1.col.sql',1415307267),('phabricator:20131112.userverified.2.mig.php',1415307267),('phabricator:20131118.ownerorder.php',1415307267),('phabricator:20131119.passphrase.sql',1415307267),('phabricator:20131120.nuancesourcetype.sql',1415307267),('phabricator:20131121.passphraseedge.sql',1415307267),('phabricator:20131121.repocredentials.1.col.sql',1415307267),('phabricator:20131121.repocredentials.2.mig.php',1415307267),('phabricator:20131122.repomirror.sql',1415307267),('phabricator:20131123.drydockblueprintpolicy.sql',1415307267),('phabricator:20131129.drydockresourceblueprint.sql',1415307267),('phabricator:20131204.pushlog.sql',1415307268),('phabricator:20131205.buildsteporder.sql',1415307268),('phabricator:20131205.buildstepordermig.php',1415307268),('phabricator:20131205.buildtargets.sql',1415307268),('phabricator:20131206.phragment.sql',1415307268),('phabricator:20131206.phragmentnull.sql',1415307268),('phabricator:20131208.phragmentsnapshot.sql',1415307268),('phabricator:20131211.phragmentedges.sql',1415307268),('phabricator:20131217.pushlogphid.1.col.sql',1415307268),('phabricator:20131217.pushlogphid.2.mig.php',1415307268),('phabricator:20131217.pushlogphid.3.key.sql',1415307268),('phabricator:20131219.pxdrop.sql',1415307268),('phabricator:20131224.harbormanual.sql',1415307268),('phabricator:20131227.heraldobject.sql',1415307268),('phabricator:20131231.dropshortcut.sql',1415307268),('phabricator:20131302.maniphestvalue.sql',1415307264),('phabricator:20140104.harbormastercmd.sql',1415307268),('phabricator:20140106.macromailkey.1.sql',1415307268),('phabricator:20140106.macromailkey.2.php',1415307268),('phabricator:20140108.ddbpname.1.sql',1415307268),('phabricator:20140108.ddbpname.2.php',1415307268),('phabricator:20140109.ddxactions.sql',1415307268),('phabricator:20140109.projectcolumnsdates.sql',1415307268),('phabricator:20140113.legalpadsig.1.sql',1415307268),('phabricator:20140113.legalpadsig.2.php',1415307268),('phabricator:20140115.auth.1.id.sql',1415307268),('phabricator:20140115.auth.2.expires.sql',1415307268),('phabricator:20140115.auth.3.unlimit.php',1415307268),('phabricator:20140115.legalpadsigkey.sql',1415307268),('phabricator:20140116.reporefcursor.sql',1415307268),('phabricator:20140126.diff.1.parentrevisionid.sql',1415307268),('phabricator:20140126.diff.2.repositoryphid.sql',1415307268),('phabricator:20140130.dash.1.board.sql',1415307268),('phabricator:20140130.dash.2.panel.sql',1415307268),('phabricator:20140130.dash.3.boardxaction.sql',1415307268),('phabricator:20140130.dash.4.panelxaction.sql',1415307268),('phabricator:20140130.mail.1.retry.sql',1415307268),('phabricator:20140130.mail.2.next.sql',1415307268),('phabricator:20140201.gc.1.mailsent.sql',1415307268),('phabricator:20140201.gc.2.mailreceived.sql',1415307268),('phabricator:20140205.cal.1.rename.sql',1415307268),('phabricator:20140205.cal.2.phid-col.sql',1415307268),('phabricator:20140205.cal.3.phid-mig.php',1415307268),('phabricator:20140205.cal.4.phid-key.sql',1415307268),('phabricator:20140210.herald.rule-condition-mig.php',1415307268),('phabricator:20140210.projcfield.1.blurb.php',1415307268),('phabricator:20140210.projcfield.2.piccol.sql',1415307268),('phabricator:20140210.projcfield.3.picmig.sql',1415307268),('phabricator:20140210.projcfield.4.memmig.sql',1415307268),('phabricator:20140210.projcfield.5.dropprofile.sql',1415307268),('phabricator:20140211.dx.1.nullablechangesetid.sql',1415307268),('phabricator:20140211.dx.2.migcommenttext.php',1415307268),('phabricator:20140211.dx.3.migsubscriptions.sql',1415307268),('phabricator:20140211.dx.999.drop.relationships.sql',1415307268),('phabricator:20140212.dx.1.armageddon.php',1415307268),('phabricator:20140214.clean.1.legacycommentid.sql',1415307268),('phabricator:20140214.clean.2.dropcomment.sql',1415307268),('phabricator:20140214.clean.3.dropinline.sql',1415307268),('phabricator:20140218.differentialdraft.sql',1415307268),('phabricator:20140218.passwords.1.extend.sql',1415307268),('phabricator:20140218.passwords.2.prefix.sql',1415307268),('phabricator:20140218.passwords.3.vcsextend.sql',1415307268),('phabricator:20140218.passwords.4.vcs.php',1415307268),('phabricator:20140223.bigutf8scratch.sql',1415307268),('phabricator:20140224.dxclean.1.datecommitted.sql',1415307268),('phabricator:20140226.dxcustom.1.fielddata.php',1415307268),('phabricator:20140226.dxcustom.99.drop.sql',1415307268),('phabricator:20140228.dxcomment.1.sql',1415307268),('phabricator:20140305.diviner.1.slugcol.sql',1415307268),('phabricator:20140305.diviner.2.slugkey.sql',1415307268),('phabricator:20140311.mdroplegacy.sql',1415307268),('phabricator:20140314.projectcolumn.1.statuscol.sql',1415307268),('phabricator:20140314.projectcolumn.2.statuskey.sql',1415307268),('phabricator:20140317.mupdatedkey.sql',1415307268),('phabricator:20140321.harbor.1.bxaction.sql',1415307268),('phabricator:20140321.mstatus.1.col.sql',1415307268),('phabricator:20140321.mstatus.2.mig.php',1415307268),('phabricator:20140323.harbor.1.renames.php',1415307268),('phabricator:20140323.harbor.2.message.sql',1415307268),('phabricator:20140325.push.1.event.sql',1415307268),('phabricator:20140325.push.2.eventphid.sql',1415307268),('phabricator:20140325.push.3.groups.php',1415307268),('phabricator:20140325.push.4.prune.sql',1415307269),('phabricator:20140326.project.1.colxaction.sql',1415307269),('phabricator:20140328.releeph.1.productxaction.sql',1415307269),('phabricator:20140330.flagtext.sql',1415307269),('phabricator:20140402.actionlog.sql',1415307269),('phabricator:20140410.accountsecret.1.sql',1415307269),('phabricator:20140410.accountsecret.2.php',1415307269),('phabricator:20140416.harbor.1.sql',1415307269),('phabricator:20140420.rel.1.objectphid.sql',1415307269),('phabricator:20140420.rel.2.objectmig.php',1415307269),('phabricator:20140421.slowvotecolumnsisclosed.sql',1415307269),('phabricator:20140423.session.1.hisec.sql',1415307269),('phabricator:20140427.mfactor.1.sql',1415307269),('phabricator:20140430.auth.1.partial.sql',1415307269),('phabricator:20140430.dash.1.paneltype.sql',1415307269),('phabricator:20140430.dash.2.edge.sql',1415307269),('phabricator:20140501.passphraselockcredential.sql',1415307269),('phabricator:20140501.remove.1.dlog.sql',1415307269),('phabricator:20140507.smstable.sql',1415307269),('phabricator:20140509.coverage.1.sql',1415307269),('phabricator:20140509.dashboardlayoutconfig.sql',1415307269),('phabricator:20140512.dparents.1.sql',1415307269),('phabricator:20140514.harbormasterbuildabletransaction.sql',1415307269),('phabricator:20140514.pholiomockclose.sql',1415307269),('phabricator:20140515.trust-emails.sql',1415307269),('phabricator:20140517.dxbinarycache.sql',1415307269),('phabricator:20140518.dxmorebinarycache.sql',1415307269),('phabricator:20140519.dashboardinstall.sql',1415307269),('phabricator:20140520.authtemptoken.sql',1415307269),('phabricator:20140521.projectslug.1.create.sql',1415307269),('phabricator:20140521.projectslug.2.mig.php',1415307269),('phabricator:20140522.projecticon.sql',1415307269),('phabricator:20140524.auth.mfa.cache.sql',1415307269),('phabricator:20140525.hunkmodern.sql',1415307269),('phabricator:20140615.pholioedit.1.sql',1415307269),('phabricator:20140615.pholioedit.2.sql',1415307269),('phabricator:20140617.daemon.explicit-argv.sql',1415307269),('phabricator:20140617.daemonlog.sql',1415307269),('phabricator:20140624.projcolor.1.sql',1415307269),('phabricator:20140624.projcolor.2.sql',1415307269),('phabricator:20140629.dasharchive.1.sql',1415307269),('phabricator:20140629.legalsig.1.sql',1415307269),('phabricator:20140629.legalsig.2.php',1415307269),('phabricator:20140701.legalexemption.1.sql',1415307269),('phabricator:20140701.legalexemption.2.sql',1415307269),('phabricator:20140703.legalcorp.1.sql',1415307269),('phabricator:20140703.legalcorp.2.sql',1415307269),('phabricator:20140703.legalcorp.3.sql',1415307269),('phabricator:20140703.legalcorp.4.sql',1415307269),('phabricator:20140703.legalcorp.5.sql',1415307269),('phabricator:20140704.harbormasterstep.1.sql',1415307269),('phabricator:20140704.harbormasterstep.2.sql',1415307269),('phabricator:20140704.legalpreamble.1.sql',1415307269),('phabricator:20140706.harbormasterdepend.1.php',1415307269),('phabricator:20140706.pedge.1.sql',1415307269),('phabricator:20140711.pnames.1.sql',1415307269),('phabricator:20140711.pnames.2.php',1415307269),('phabricator:20140711.workerpriority.sql',1415307270),('phabricator:20140712.projcoluniq.sql',1415307270),('phabricator:20140721.phortune.1.cart.sql',1415307270),('phabricator:20140721.phortune.2.purchase.sql',1415307270),('phabricator:20140721.phortune.3.charge.sql',1415307270),('phabricator:20140721.phortune.4.cartstatus.sql',1415307270),('phabricator:20140721.phortune.5.cstatusdefault.sql',1415307270),('phabricator:20140721.phortune.6.onetimecharge.sql',1415307270),('phabricator:20140721.phortune.7.nullmethod.sql',1415307270),('phabricator:20140722.appname.php',1415307270),('phabricator:20140722.audit.1.xactions.sql',1415307270),('phabricator:20140722.audit.2.comments.sql',1415307270),('phabricator:20140722.audit.3.miginlines.php',1415307270),('phabricator:20140722.audit.4.migtext.php',1415307270),('phabricator:20140722.renameauth.php',1415307270),('phabricator:20140723.apprenamexaction.sql',1415307270),('phabricator:20140725.audit.1.migxactions.php',1415307270),('phabricator:20140731.audit.1.subscribers.php',1415307270),('phabricator:20140731.cancdn.php',1415307270),('phabricator:20140731.harbormasterstepdesc.sql',1415307270),('phabricator:20140805.boardcol.1.sql',1415307270),('phabricator:20140805.boardcol.2.php',1415307270),('phabricator:20140807.harbormastertargettime.sql',1415307270),('phabricator:20140808.boardprop.1.sql',1415307270),('phabricator:20140808.boardprop.2.sql',1415307270),('phabricator:20140808.boardprop.3.php',1415307270),('phabricator:20140811.blob.1.sql',1415307270),('phabricator:20140811.blob.2.sql',1415307270),('phabricator:20140812.projkey.1.sql',1415307270),('phabricator:20140812.projkey.2.sql',1415307270),('phabricator:20140814.passphrasecredentialconduit.sql',1415307270),('phabricator:20140815.cancdncase.php',1415307270),('phabricator:20140818.harbormasterindex.1.sql',1415307270),('phabricator:20140821.harbormasterbuildgen.1.sql',1415307270),('phabricator:20140822.daemonenvhash.sql',1415307270),('phabricator:20140902.almanacdevice.1.sql',1415307270),('phabricator:20140904.macroattach.php',1415307270),('phabricator:20140911.fund.1.initiative.sql',1415307270),('phabricator:20140911.fund.2.xaction.sql',1415307270),('phabricator:20140911.fund.3.edge.sql',1415307270),('phabricator:20140911.fund.4.backer.sql',1415307270),('phabricator:20140911.fund.5.backxaction.sql',1415307270),('phabricator:20140914.betaproto.php',1415307270),('phabricator:20140917.project.canlock.sql',1415307270),('phabricator:20140918.schema.1.dropaudit.sql',1415307270),('phabricator:20140918.schema.2.dropauditinline.sql',1415307270),('phabricator:20140918.schema.3.wipecache.sql',1415307270),('phabricator:20140918.schema.4.cachetype.sql',1415307270),('phabricator:20140918.schema.5.slowvote.sql',1415307270),('phabricator:20140919.schema.01.calstatus.sql',1415307270),('phabricator:20140919.schema.02.calname.sql',1415307270),('phabricator:20140919.schema.03.dropaux.sql',1415307270),('phabricator:20140919.schema.04.droptaskproj.sql',1415307270),('phabricator:20140926.schema.01.droprelev.sql',1415307270),('phabricator:20140926.schema.02.droprelreqev.sql',1415307270),('phabricator:20140926.schema.03.dropldapinfo.sql',1415307270),('phabricator:20140926.schema.04.dropoauthinfo.sql',1415307270),('phabricator:20140926.schema.05.dropprojaffil.sql',1415307270),('phabricator:20140926.schema.06.dropsubproject.sql',1415307270),('phabricator:20140926.schema.07.droppondcom.sql',1415307270),('phabricator:20140927.schema.01.dropsearchq.sql',1415307270),('phabricator:20140927.schema.02.pholio1.sql',1415307270),('phabricator:20140927.schema.03.pholio2.sql',1415307270),('phabricator:20140927.schema.04.pholio3.sql',1415307270),('phabricator:20140927.schema.05.phragment1.sql',1415307270),('phabricator:20140927.schema.06.releeph1.sql',1415307270),('phabricator:20141001.schema.01.version.sql',1415307270),('phabricator:20141001.schema.02.taskmail.sql',1415307270),('phabricator:20141002.schema.01.liskcounter.sql',1415307270),('phabricator:20141002.schema.02.draftnull.sql',1415307270),('phabricator:20141004.currency.01.sql',1415307270),('phabricator:20141004.currency.02.sql',1415307270),('phabricator:20141004.currency.03.sql',1415307270),('phabricator:20141004.currency.04.sql',1415307270),('phabricator:20141004.currency.05.sql',1415307270),('phabricator:20141004.currency.06.sql',1415307270),('phabricator:20141004.harborliskcounter.sql',1415307270),('phabricator:20141005.phortuneproduct.sql',1415307271),('phabricator:20141006.phortunecart.sql',1415307271),('phabricator:20141006.phortunemerchant.sql',1415307271),('phabricator:20141006.phortunemerchantx.sql',1415307271),('phabricator:20141007.fundmerchant.sql',1415307271),('phabricator:20141007.fundrisks.sql',1415307271),('phabricator:20141007.fundtotal.sql',1415307271),('phabricator:20141007.phortunecartmerchant.sql',1415307271),('phabricator:20141007.phortunecharge.sql',1415307271),('phabricator:20141007.phortunepayment.sql',1415307271),('phabricator:20141007.phortuneprovider.sql',1415307271),('phabricator:20141007.phortuneproviderx.sql',1415307271),('phabricator:20141008.phortunemerchdesc.sql',1415307271),('phabricator:20141008.phortuneprovdis.sql',1415307271),('phabricator:20141008.phortunerefund.sql',1415307271),('phabricator:20141010.fundmailkey.sql',1415307271),('phabricator:20141011.phortunemerchedit.sql',1415307271),('phabricator:20141012.phortunecartxaction.sql',1415307271),('phabricator:20141013.phortunecartkey.sql',1415307271),('phabricator:20141016.almanac.device.sql',1415307271),('phabricator:20141016.almanac.dxaction.sql',1415307271),('phabricator:20141016.almanac.interface.sql',1415307271),('phabricator:20141016.almanac.network.sql',1415307271),('phabricator:20141016.almanac.nxaction.sql',1415307271),('phabricator:20141016.almanac.service.sql',1415307271),('phabricator:20141016.almanac.sxaction.sql',1415307271),('phabricator:20141017.almanac.binding.sql',1415307271),('phabricator:20141017.almanac.bxaction.sql',1415307271),('phabricator:20141025.phriction.1.xaction.sql',1415307271),('phabricator:20141025.phriction.2.xaction.sql',1415307271),('phabricator:20141025.phriction.mailkey.sql',1415307271),('phabricator:20141103.almanac.1.delprop.sql',1415307271),('phabricator:20141103.almanac.2.addprop.sql',1415307271),('phabricator:20141104.almanac.3.edge.sql',1415307271),('phabricator:20141105.ssh.1.rename.sql',1415307271),('phabricator:20141106.dropold.sql',1415307271),('phabricator:daemonstatus.sql',1415307263),('phabricator:daemonstatuskey.sql',1415307264),('phabricator:daemontaskarchive.sql',1415307264),('phabricator:db.almanac',1415307257),('phabricator:db.audit',1415307257),('phabricator:db.auth',1415307257),('phabricator:db.cache',1415307257),('phabricator:db.calendar',1415307257),('phabricator:db.chatlog',1415307257),('phabricator:db.conduit',1415307257),('phabricator:db.config',1415307257),('phabricator:db.conpherence',1415307257),('phabricator:db.countdown',1415307257),('phabricator:db.daemon',1415307257),('phabricator:db.dashboard',1415307257),('phabricator:db.differential',1415307257),('phabricator:db.diviner',1415307257),('phabricator:db.doorkeeper',1415307257),('phabricator:db.draft',1415307257),('phabricator:db.drydock',1415307257),('phabricator:db.fact',1415307257),('phabricator:db.feed',1415307257),('phabricator:db.file',1415307257),('phabricator:db.flag',1415307257),('phabricator:db.fund',1415307257),('phabricator:db.harbormaster',1415307257),('phabricator:db.herald',1415307257),('phabricator:db.legalpad',1415307257),('phabricator:db.maniphest',1415307257),('phabricator:db.meta_data',1415307257),('phabricator:db.metamta',1415307257),('phabricator:db.nuance',1415307257),('phabricator:db.oauth_server',1415307257),('phabricator:db.owners',1415307257),('phabricator:db.passphrase',1415307257),('phabricator:db.pastebin',1415307257),('phabricator:db.phame',1415307257),('phabricator:db.phlux',1415307257),('phabricator:db.pholio',1415307257),('phabricator:db.phortune',1415307257),('phabricator:db.phragment',1415307257),('phabricator:db.phrequent',1415307257),('phabricator:db.phriction',1415307257),('phabricator:db.policy',1415307257),('phabricator:db.ponder',1415307257),('phabricator:db.project',1415307257),('phabricator:db.releeph',1415307257),('phabricator:db.repository',1415307257),('phabricator:db.search',1415307257),('phabricator:db.slowvote',1415307257),('phabricator:db.system',1415307257),('phabricator:db.timeline',1415307257),('phabricator:db.token',1415307257),('phabricator:db.user',1415307257),('phabricator:db.worker',1415307257),('phabricator:db.xhpastview',1415307257),('phabricator:db.xhprof',1415307257),('phabricator:differentialbookmarks.sql',1415307263),('phabricator:draft-metadata.sql',1415307264),('phabricator:dropfileproxyimage.sql',1415307264),('phabricator:drydockresoucetype.sql',1415307264),('phabricator:drydocktaskid.sql',1415307264),('phabricator:edgetype.sql',1415307264),('phabricator:emailtable.sql',1415307263),('phabricator:emailtableport.sql',1415307263),('phabricator:emailtableremove.sql',1415307263),('phabricator:fact-raw.sql',1415307264),('phabricator:harbormasterobject.sql',1415307263),('phabricator:holidays.sql',1415307263),('phabricator:ldapinfo.sql',1415307263),('phabricator:legalpad-mailkey-populate.php',1415307266),('phabricator:legalpad-mailkey.sql',1415307266),('phabricator:liskcounters-task.sql',1415307264),('phabricator:liskcounters.php',1415307264),('phabricator:liskcounters.sql',1415307264),('phabricator:maniphestxcache.sql',1415307263),('phabricator:markupcache.sql',1415307263),('phabricator:migrate-differential-dependencies.php',1415307263),('phabricator:migrate-maniphest-dependencies.php',1415307263),('phabricator:migrate-maniphest-revisions.php',1415307263),('phabricator:migrate-project-edges.php',1415307263),('phabricator:owners-exclude.sql',1415307264),('phabricator:pastepolicy.sql',1415307264),('phabricator:phameblog.sql',1415307263),('phabricator:phamedomain.sql',1415307264),('phabricator:phameoneblog.sql',1415307264),('phabricator:phamepolicy.sql',1415307264),('phabricator:phiddrop.sql',1415307263),('phabricator:pholio.sql',1415307264),('phabricator:policy-project.sql',1415307264),('phabricator:ponder-comments.sql',1415307264),('phabricator:ponder-mailkey-populate.php',1415307264),('phabricator:ponder-mailkey.sql',1415307264),('phabricator:ponder.sql',1415307264),('phabricator:releeph.sql',1415307265),('phabricator:repository-lint.sql',1415307264),('phabricator:statustxt.sql',1415307264),('phabricator:symbolcontexts.sql',1415307263),('phabricator:testdatabase.sql',1415307263),('phabricator:threadtopic.sql',1415307263),('phabricator:userstatus.sql',1415307263),('phabricator:usertranslation.sql',1415307263),('phabricator:xhprof.sql',1415307264); 1332 1333 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_metamta` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1334 1335 USE `{$NAMESPACE}_metamta`; 1336 1337 CREATE TABLE `edge` ( 1338 `src` varbinary(64) NOT NULL, 1339 `type` int(10) unsigned NOT NULL, 1340 `dst` varbinary(64) NOT NULL, 1341 `dateCreated` int(10) unsigned NOT NULL, 1342 `seq` int(10) unsigned NOT NULL, 1343 `dataID` int(10) unsigned DEFAULT NULL, 1344 PRIMARY KEY (`src`,`type`,`dst`), 1345 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 1346 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 1347 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1348 1349 CREATE TABLE `edgedata` ( 1350 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1351 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1352 PRIMARY KEY (`id`) 1353 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1354 1355 CREATE TABLE `metamta_mail` ( 1356 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1357 `parameters` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1358 `status` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1359 `message` longtext COLLATE {$COLLATE_TEXT}, 1360 `relatedPHID` varbinary(64) DEFAULT NULL, 1361 `dateCreated` int(10) unsigned NOT NULL, 1362 `dateModified` int(10) unsigned NOT NULL, 1363 PRIMARY KEY (`id`), 1364 KEY `relatedPHID` (`relatedPHID`), 1365 KEY `key_created` (`dateCreated`), 1366 KEY `status` (`status`) 1367 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1368 1369 CREATE TABLE `metamta_mailinglist` ( 1370 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1371 `phid` varbinary(64) NOT NULL, 1372 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 1373 `email` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 1374 `uri` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1375 `dateCreated` int(10) unsigned NOT NULL, 1376 `dateModified` int(10) unsigned NOT NULL, 1377 PRIMARY KEY (`id`), 1378 UNIQUE KEY `phid` (`phid`), 1379 UNIQUE KEY `email` (`email`), 1380 UNIQUE KEY `name` (`name`) 1381 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1382 1383 CREATE TABLE `metamta_receivedmail` ( 1384 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1385 `headers` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1386 `bodies` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1387 `attachments` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1388 `relatedPHID` varbinary(64) DEFAULT NULL, 1389 `authorPHID` varbinary(64) DEFAULT NULL, 1390 `message` longtext COLLATE {$COLLATE_TEXT}, 1391 `dateCreated` int(10) unsigned NOT NULL, 1392 `dateModified` int(10) unsigned NOT NULL, 1393 `messageIDHash` binary(12) NOT NULL, 1394 `status` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1395 PRIMARY KEY (`id`), 1396 KEY `relatedPHID` (`relatedPHID`), 1397 KEY `authorPHID` (`authorPHID`), 1398 KEY `key_messageIDHash` (`messageIDHash`), 1399 KEY `key_created` (`dateCreated`) 1400 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1401 1402 CREATE TABLE `sms` ( 1403 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1404 `providerShortName` varchar(16) COLLATE {$COLLATE_TEXT} NOT NULL, 1405 `providerSMSID` varchar(40) COLLATE {$COLLATE_TEXT} NOT NULL, 1406 `toNumber` varchar(20) COLLATE {$COLLATE_TEXT} NOT NULL, 1407 `fromNumber` varchar(20) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1408 `body` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1409 `sendStatus` varchar(16) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1410 `dateCreated` int(10) unsigned NOT NULL, 1411 `dateModified` int(10) unsigned NOT NULL, 1412 PRIMARY KEY (`id`), 1413 UNIQUE KEY `key_provider` (`providerSMSID`,`providerShortName`) 1414 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1415 1416 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_oauth_server` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1417 1418 USE `{$NAMESPACE}_oauth_server`; 1419 1420 CREATE TABLE `oauth_server_oauthclientauthorization` ( 1421 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1422 `phid` varbinary(64) NOT NULL, 1423 `userPHID` varbinary(64) NOT NULL, 1424 `clientPHID` varbinary(64) NOT NULL, 1425 `dateCreated` int(10) unsigned NOT NULL, 1426 `dateModified` int(10) unsigned NOT NULL, 1427 `scope` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1428 PRIMARY KEY (`id`), 1429 UNIQUE KEY `phid` (`phid`), 1430 UNIQUE KEY `userPHID` (`userPHID`,`clientPHID`) 1431 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1432 1433 CREATE TABLE `oauth_server_oauthserveraccesstoken` ( 1434 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1435 `token` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1436 `userPHID` varbinary(64) NOT NULL, 1437 `clientPHID` varbinary(64) NOT NULL, 1438 `dateCreated` int(10) unsigned NOT NULL, 1439 `dateModified` int(10) unsigned NOT NULL, 1440 PRIMARY KEY (`id`), 1441 UNIQUE KEY `token` (`token`) 1442 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1443 1444 CREATE TABLE `oauth_server_oauthserverauthorizationcode` ( 1445 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1446 `code` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1447 `clientPHID` varbinary(64) NOT NULL, 1448 `clientSecret` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1449 `userPHID` varbinary(64) NOT NULL, 1450 `dateCreated` int(10) unsigned NOT NULL, 1451 `dateModified` int(10) unsigned NOT NULL, 1452 `redirectURI` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1453 PRIMARY KEY (`id`), 1454 UNIQUE KEY `code` (`code`) 1455 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1456 1457 CREATE TABLE `oauth_server_oauthserverclient` ( 1458 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1459 `phid` varbinary(64) NOT NULL, 1460 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1461 `secret` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1462 `redirectURI` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1463 `creatorPHID` varbinary(64) NOT NULL, 1464 `dateCreated` int(10) unsigned NOT NULL, 1465 `dateModified` int(10) unsigned NOT NULL, 1466 PRIMARY KEY (`id`), 1467 UNIQUE KEY `phid` (`phid`), 1468 KEY `creatorPHID` (`creatorPHID`) 1469 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1470 1471 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_owners` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1472 1473 USE `{$NAMESPACE}_owners`; 1474 1475 CREATE TABLE `owners_owner` ( 1476 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1477 `packageID` int(10) unsigned NOT NULL, 1478 `userPHID` varbinary(64) NOT NULL, 1479 PRIMARY KEY (`id`), 1480 UNIQUE KEY `packageID` (`packageID`,`userPHID`), 1481 KEY `userPHID` (`userPHID`) 1482 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1483 1484 CREATE TABLE `owners_package` ( 1485 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1486 `phid` varbinary(64) NOT NULL, 1487 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 1488 `originalName` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1489 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1490 `primaryOwnerPHID` varbinary(64) DEFAULT NULL, 1491 `auditingEnabled` tinyint(1) NOT NULL DEFAULT '0', 1492 PRIMARY KEY (`id`), 1493 UNIQUE KEY `phid` (`phid`), 1494 UNIQUE KEY `name` (`name`) 1495 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1496 1497 CREATE TABLE `owners_path` ( 1498 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1499 `packageID` int(10) unsigned NOT NULL, 1500 `repositoryPHID` varbinary(64) NOT NULL, 1501 `path` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1502 `excluded` tinyint(1) NOT NULL DEFAULT '0', 1503 PRIMARY KEY (`id`), 1504 KEY `packageID` (`packageID`) 1505 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1506 1507 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_pastebin` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1508 1509 USE `{$NAMESPACE}_pastebin`; 1510 1511 CREATE TABLE `edge` ( 1512 `src` varbinary(64) NOT NULL, 1513 `type` int(10) unsigned NOT NULL, 1514 `dst` varbinary(64) NOT NULL, 1515 `dateCreated` int(10) unsigned NOT NULL, 1516 `seq` int(10) unsigned NOT NULL, 1517 `dataID` int(10) unsigned DEFAULT NULL, 1518 PRIMARY KEY (`src`,`type`,`dst`), 1519 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 1520 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 1521 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1522 1523 CREATE TABLE `edgedata` ( 1524 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1525 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1526 PRIMARY KEY (`id`) 1527 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1528 1529 CREATE TABLE `pastebin_paste` ( 1530 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1531 `title` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1532 `phid` varbinary(64) NOT NULL, 1533 `authorPHID` varbinary(64) NOT NULL, 1534 `filePHID` varbinary(64) NOT NULL, 1535 `dateCreated` int(10) unsigned NOT NULL, 1536 `dateModified` int(10) unsigned NOT NULL, 1537 `language` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 1538 `parentPHID` varbinary(64) DEFAULT NULL, 1539 `viewPolicy` varbinary(64) DEFAULT NULL, 1540 `mailKey` binary(20) NOT NULL, 1541 PRIMARY KEY (`id`), 1542 UNIQUE KEY `key_phid` (`phid`), 1543 KEY `parentPHID` (`parentPHID`), 1544 KEY `authorPHID` (`authorPHID`), 1545 KEY `key_dateCreated` (`dateCreated`), 1546 KEY `key_language` (`language`) 1547 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1548 1549 CREATE TABLE `pastebin_pastetransaction` ( 1550 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1551 `phid` varbinary(64) NOT NULL, 1552 `authorPHID` varbinary(64) NOT NULL, 1553 `objectPHID` varbinary(64) NOT NULL, 1554 `viewPolicy` varbinary(64) NOT NULL, 1555 `editPolicy` varbinary(64) NOT NULL, 1556 `commentPHID` varbinary(64) DEFAULT NULL, 1557 `commentVersion` int(10) unsigned NOT NULL, 1558 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1559 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1560 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1561 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1562 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1563 `dateCreated` int(10) unsigned NOT NULL, 1564 `dateModified` int(10) unsigned NOT NULL, 1565 PRIMARY KEY (`id`), 1566 UNIQUE KEY `key_phid` (`phid`), 1567 KEY `key_object` (`objectPHID`) 1568 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1569 1570 CREATE TABLE `pastebin_pastetransaction_comment` ( 1571 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1572 `phid` varbinary(64) NOT NULL, 1573 `transactionPHID` varbinary(64) DEFAULT NULL, 1574 `authorPHID` varbinary(64) NOT NULL, 1575 `viewPolicy` varbinary(64) NOT NULL, 1576 `editPolicy` varbinary(64) NOT NULL, 1577 `commentVersion` int(10) unsigned NOT NULL, 1578 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1579 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1580 `isDeleted` tinyint(1) NOT NULL, 1581 `dateCreated` int(10) unsigned NOT NULL, 1582 `dateModified` int(10) unsigned NOT NULL, 1583 `lineNumber` int(10) unsigned DEFAULT NULL, 1584 `lineLength` int(10) unsigned DEFAULT NULL, 1585 PRIMARY KEY (`id`), 1586 UNIQUE KEY `key_phid` (`phid`), 1587 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 1588 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1589 1590 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_phame` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1591 1592 USE `{$NAMESPACE}_phame`; 1593 1594 CREATE TABLE `edge` ( 1595 `src` varbinary(64) NOT NULL, 1596 `type` int(10) unsigned NOT NULL, 1597 `dst` varbinary(64) NOT NULL, 1598 `dateCreated` int(10) unsigned NOT NULL, 1599 `seq` int(10) unsigned NOT NULL, 1600 `dataID` int(10) unsigned DEFAULT NULL, 1601 PRIMARY KEY (`src`,`type`,`dst`), 1602 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 1603 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 1604 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1605 1606 CREATE TABLE `edgedata` ( 1607 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1608 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1609 PRIMARY KEY (`id`) 1610 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1611 1612 CREATE TABLE `phame_blog` ( 1613 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1614 `phid` varbinary(64) NOT NULL, 1615 `name` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 1616 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1617 `domain` varchar(128) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1618 `configData` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1619 `creatorPHID` varbinary(64) NOT NULL, 1620 `dateCreated` int(10) unsigned NOT NULL, 1621 `dateModified` int(10) unsigned NOT NULL, 1622 `viewPolicy` varbinary(64) DEFAULT NULL, 1623 `editPolicy` varbinary(64) DEFAULT NULL, 1624 `joinPolicy` varbinary(64) DEFAULT NULL, 1625 PRIMARY KEY (`id`), 1626 UNIQUE KEY `phid` (`phid`), 1627 UNIQUE KEY `domain` (`domain`) 1628 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1629 1630 CREATE TABLE `phame_post` ( 1631 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1632 `phid` varbinary(64) NOT NULL, 1633 `bloggerPHID` varbinary(64) NOT NULL, 1634 `title` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1635 `phameTitle` varchar(64) CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1636 `body` longtext COLLATE {$COLLATE_TEXT}, 1637 `visibility` int(10) unsigned NOT NULL DEFAULT '0', 1638 `configData` longtext COLLATE {$COLLATE_TEXT}, 1639 `datePublished` int(10) unsigned NOT NULL, 1640 `dateCreated` int(10) unsigned NOT NULL, 1641 `dateModified` int(10) unsigned NOT NULL, 1642 `blogPHID` varbinary(64) DEFAULT NULL, 1643 PRIMARY KEY (`id`), 1644 UNIQUE KEY `phid` (`phid`), 1645 UNIQUE KEY `phameTitle` (`bloggerPHID`,`phameTitle`), 1646 KEY `bloggerPosts` (`bloggerPHID`,`visibility`,`datePublished`,`id`) 1647 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1648 1649 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_phriction` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1650 1651 USE `{$NAMESPACE}_phriction`; 1652 1653 CREATE TABLE `edge` ( 1654 `src` varbinary(64) NOT NULL, 1655 `type` int(10) unsigned NOT NULL, 1656 `dst` varbinary(64) NOT NULL, 1657 `dateCreated` int(10) unsigned NOT NULL, 1658 `seq` int(10) unsigned NOT NULL, 1659 `dataID` int(10) unsigned DEFAULT NULL, 1660 PRIMARY KEY (`src`,`type`,`dst`), 1661 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 1662 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 1663 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1664 1665 CREATE TABLE `edgedata` ( 1666 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1667 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1668 PRIMARY KEY (`id`) 1669 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1670 1671 CREATE TABLE `phriction_content` ( 1672 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1673 `documentID` int(10) unsigned NOT NULL, 1674 `version` int(10) unsigned NOT NULL, 1675 `authorPHID` varbinary(64) NOT NULL, 1676 `title` longtext CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1677 `slug` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 1678 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1679 `dateCreated` int(10) unsigned NOT NULL, 1680 `dateModified` int(10) unsigned NOT NULL, 1681 `description` longtext COLLATE {$COLLATE_TEXT}, 1682 `changeType` int(10) unsigned NOT NULL DEFAULT '0', 1683 `changeRef` int(10) unsigned DEFAULT NULL, 1684 PRIMARY KEY (`id`), 1685 UNIQUE KEY `documentID` (`documentID`,`version`), 1686 KEY `authorPHID` (`authorPHID`), 1687 KEY `slug` (`slug`) 1688 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1689 1690 CREATE TABLE `phriction_document` ( 1691 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1692 `phid` varbinary(64) NOT NULL, 1693 `slug` varchar(128) CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1694 `depth` int(10) unsigned NOT NULL, 1695 `contentID` int(10) unsigned DEFAULT NULL, 1696 `status` int(10) unsigned NOT NULL DEFAULT '0', 1697 `mailKey` binary(20) NOT NULL, 1698 PRIMARY KEY (`id`), 1699 UNIQUE KEY `phid` (`phid`), 1700 UNIQUE KEY `slug` (`slug`), 1701 UNIQUE KEY `depth` (`depth`,`slug`) 1702 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1703 1704 CREATE TABLE `phriction_transaction` ( 1705 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1706 `phid` varbinary(64) NOT NULL, 1707 `authorPHID` varbinary(64) NOT NULL, 1708 `objectPHID` varbinary(64) NOT NULL, 1709 `viewPolicy` varbinary(64) NOT NULL, 1710 `editPolicy` varbinary(64) NOT NULL, 1711 `commentPHID` varbinary(64) DEFAULT NULL, 1712 `commentVersion` int(10) unsigned NOT NULL, 1713 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1714 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1715 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1716 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1717 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1718 `dateCreated` int(10) unsigned NOT NULL, 1719 `dateModified` int(10) unsigned NOT NULL, 1720 PRIMARY KEY (`id`), 1721 UNIQUE KEY `key_phid` (`phid`), 1722 KEY `key_object` (`objectPHID`) 1723 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1724 1725 CREATE TABLE `phriction_transaction_comment` ( 1726 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1727 `phid` varbinary(64) NOT NULL, 1728 `transactionPHID` varbinary(64) DEFAULT NULL, 1729 `authorPHID` varbinary(64) NOT NULL, 1730 `viewPolicy` varbinary(64) NOT NULL, 1731 `editPolicy` varbinary(64) NOT NULL, 1732 `commentVersion` int(10) unsigned NOT NULL, 1733 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1734 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1735 `isDeleted` tinyint(1) NOT NULL, 1736 `dateCreated` int(10) unsigned NOT NULL, 1737 `dateModified` int(10) unsigned NOT NULL, 1738 PRIMARY KEY (`id`), 1739 UNIQUE KEY `key_phid` (`phid`), 1740 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 1741 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1742 1743 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_project` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1744 1745 USE `{$NAMESPACE}_project`; 1746 1747 CREATE TABLE `edge` ( 1748 `src` varbinary(64) NOT NULL, 1749 `type` int(10) unsigned NOT NULL, 1750 `dst` varbinary(64) NOT NULL, 1751 `dateCreated` int(10) unsigned NOT NULL, 1752 `seq` int(10) unsigned NOT NULL, 1753 `dataID` int(10) unsigned DEFAULT NULL, 1754 PRIMARY KEY (`src`,`type`,`dst`), 1755 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 1756 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 1757 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1758 1759 CREATE TABLE `edgedata` ( 1760 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1761 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1762 PRIMARY KEY (`id`) 1763 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1764 1765 CREATE TABLE `project` ( 1766 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1767 `name` varchar(128) CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1768 `phid` varbinary(64) NOT NULL, 1769 `authorPHID` varbinary(64) NOT NULL, 1770 `dateCreated` int(10) unsigned NOT NULL, 1771 `dateModified` int(10) unsigned NOT NULL, 1772 `status` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1773 `subprojectPHIDs` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1774 `phrictionSlug` varchar(128) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1775 `viewPolicy` varbinary(64) DEFAULT NULL, 1776 `editPolicy` varbinary(64) DEFAULT NULL, 1777 `joinPolicy` varbinary(64) DEFAULT NULL, 1778 `isMembershipLocked` tinyint(1) NOT NULL DEFAULT '0', 1779 `profileImagePHID` varbinary(64) DEFAULT NULL, 1780 `icon` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1781 `color` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1782 PRIMARY KEY (`id`), 1783 UNIQUE KEY `phid` (`phid`), 1784 UNIQUE KEY `name` (`name`), 1785 UNIQUE KEY `phrictionSlug` (`phrictionSlug`), 1786 KEY `key_icon` (`icon`), 1787 KEY `key_color` (`color`) 1788 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1789 1790 CREATE TABLE `project_column` ( 1791 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1792 `phid` varbinary(64) NOT NULL, 1793 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 1794 `status` int(10) unsigned NOT NULL, 1795 `sequence` int(10) unsigned NOT NULL, 1796 `projectPHID` varbinary(64) NOT NULL, 1797 `dateCreated` int(10) unsigned NOT NULL, 1798 `dateModified` int(10) unsigned NOT NULL, 1799 `properties` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1800 PRIMARY KEY (`id`), 1801 UNIQUE KEY `key_phid` (`phid`), 1802 KEY `key_status` (`projectPHID`,`status`,`sequence`), 1803 KEY `key_sequence` (`projectPHID`,`sequence`) 1804 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1805 1806 CREATE TABLE `project_columnposition` ( 1807 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1808 `boardPHID` varbinary(64) NOT NULL, 1809 `columnPHID` varbinary(64) NOT NULL, 1810 `objectPHID` varbinary(64) NOT NULL, 1811 `sequence` int(10) unsigned NOT NULL, 1812 PRIMARY KEY (`id`), 1813 UNIQUE KEY `boardPHID` (`boardPHID`,`columnPHID`,`objectPHID`), 1814 KEY `objectPHID` (`objectPHID`,`boardPHID`), 1815 KEY `boardPHID_2` (`boardPHID`,`columnPHID`,`sequence`) 1816 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1817 1818 CREATE TABLE `project_columntransaction` ( 1819 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1820 `phid` varbinary(64) NOT NULL, 1821 `authorPHID` varbinary(64) NOT NULL, 1822 `objectPHID` varbinary(64) NOT NULL, 1823 `viewPolicy` varbinary(64) NOT NULL, 1824 `editPolicy` varbinary(64) NOT NULL, 1825 `commentPHID` varbinary(64) DEFAULT NULL, 1826 `commentVersion` int(10) unsigned NOT NULL, 1827 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1828 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1829 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1830 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1831 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1832 `dateCreated` int(10) unsigned NOT NULL, 1833 `dateModified` int(10) unsigned NOT NULL, 1834 PRIMARY KEY (`id`), 1835 UNIQUE KEY `key_phid` (`phid`), 1836 KEY `key_object` (`objectPHID`) 1837 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1838 1839 CREATE TABLE `project_customfieldnumericindex` ( 1840 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1841 `objectPHID` varbinary(64) NOT NULL, 1842 `indexKey` binary(12) NOT NULL, 1843 `indexValue` bigint(20) NOT NULL, 1844 PRIMARY KEY (`id`), 1845 KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`), 1846 KEY `key_find` (`indexKey`,`indexValue`) 1847 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1848 1849 CREATE TABLE `project_customfieldstorage` ( 1850 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1851 `objectPHID` varbinary(64) NOT NULL, 1852 `fieldIndex` binary(12) NOT NULL, 1853 `fieldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1854 PRIMARY KEY (`id`), 1855 UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`) 1856 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1857 1858 CREATE TABLE `project_customfieldstringindex` ( 1859 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1860 `objectPHID` varbinary(64) NOT NULL, 1861 `indexKey` binary(12) NOT NULL, 1862 `indexValue` longtext CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1863 PRIMARY KEY (`id`), 1864 KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)), 1865 KEY `key_find` (`indexKey`,`indexValue`(64)) 1866 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1867 1868 CREATE TABLE `project_datasourcetoken` ( 1869 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1870 `projectID` int(10) unsigned NOT NULL, 1871 `token` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 1872 PRIMARY KEY (`id`), 1873 UNIQUE KEY `token` (`token`,`projectID`), 1874 KEY `projectID` (`projectID`) 1875 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1876 1877 CREATE TABLE `project_slug` ( 1878 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1879 `projectPHID` varbinary(64) NOT NULL, 1880 `slug` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 1881 `dateCreated` int(10) unsigned NOT NULL, 1882 `dateModified` int(10) unsigned NOT NULL, 1883 PRIMARY KEY (`id`), 1884 UNIQUE KEY `key_slug` (`slug`), 1885 KEY `key_projectPHID` (`projectPHID`) 1886 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1887 1888 CREATE TABLE `project_transaction` ( 1889 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1890 `phid` varbinary(64) NOT NULL, 1891 `authorPHID` varbinary(64) NOT NULL, 1892 `objectPHID` varbinary(64) NOT NULL, 1893 `viewPolicy` varbinary(64) NOT NULL, 1894 `editPolicy` varbinary(64) NOT NULL, 1895 `commentPHID` varbinary(64) DEFAULT NULL, 1896 `commentVersion` int(10) unsigned NOT NULL, 1897 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1898 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1899 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1900 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1901 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1902 `dateCreated` int(10) unsigned NOT NULL, 1903 `dateModified` int(10) unsigned NOT NULL, 1904 PRIMARY KEY (`id`), 1905 UNIQUE KEY `key_phid` (`phid`), 1906 KEY `key_object` (`objectPHID`) 1907 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1908 1909 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_repository` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 1910 1911 USE `{$NAMESPACE}_repository`; 1912 1913 CREATE TABLE `edge` ( 1914 `src` varbinary(64) NOT NULL, 1915 `type` int(10) unsigned NOT NULL, 1916 `dst` varbinary(64) NOT NULL, 1917 `dateCreated` int(10) unsigned NOT NULL, 1918 `seq` int(10) unsigned NOT NULL, 1919 `dataID` int(10) unsigned DEFAULT NULL, 1920 PRIMARY KEY (`src`,`type`,`dst`), 1921 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 1922 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 1923 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1924 1925 CREATE TABLE `edgedata` ( 1926 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1927 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1928 PRIMARY KEY (`id`) 1929 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1930 1931 CREATE TABLE `repository` ( 1932 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1933 `phid` varbinary(64) NOT NULL, 1934 `name` varchar(255) CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1935 `callsign` varchar(32) CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 1936 `versionControlSystem` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 1937 `details` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1938 `dateCreated` int(10) unsigned NOT NULL, 1939 `dateModified` int(10) unsigned NOT NULL, 1940 `uuid` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1941 `viewPolicy` varbinary(64) NOT NULL, 1942 `editPolicy` varbinary(64) NOT NULL, 1943 `pushPolicy` varbinary(64) NOT NULL, 1944 `credentialPHID` varbinary(64) DEFAULT NULL, 1945 PRIMARY KEY (`id`), 1946 UNIQUE KEY `callsign` (`callsign`), 1947 UNIQUE KEY `phid` (`phid`), 1948 KEY `key_vcs` (`versionControlSystem`), 1949 KEY `key_name` (`name`(128)) 1950 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1951 1952 CREATE TABLE `repository_arcanistproject` ( 1953 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1954 `phid` varbinary(64) NOT NULL, 1955 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 1956 `repositoryID` int(10) unsigned DEFAULT NULL, 1957 `symbolIndexLanguages` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1958 `symbolIndexProjects` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1959 PRIMARY KEY (`id`), 1960 UNIQUE KEY `phid` (`phid`), 1961 UNIQUE KEY `name` (`name`) 1962 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1963 1964 CREATE TABLE `repository_auditrequest` ( 1965 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1966 `auditorPHID` varbinary(64) NOT NULL, 1967 `commitPHID` varbinary(64) NOT NULL, 1968 `auditStatus` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 1969 `auditReasons` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1970 PRIMARY KEY (`id`), 1971 KEY `commitPHID` (`commitPHID`), 1972 KEY `auditorPHID` (`auditorPHID`,`auditStatus`) 1973 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1974 1975 CREATE TABLE `repository_badcommit` ( 1976 `fullCommitName` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 1977 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 1978 PRIMARY KEY (`fullCommitName`) 1979 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1980 1981 CREATE TABLE `repository_branch` ( 1982 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1983 `repositoryID` int(10) unsigned NOT NULL, 1984 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 1985 `lintCommit` varchar(40) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 1986 `dateCreated` int(10) unsigned NOT NULL, 1987 `dateModified` int(10) unsigned NOT NULL, 1988 PRIMARY KEY (`id`), 1989 UNIQUE KEY `repositoryID` (`repositoryID`,`name`) 1990 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 1991 1992 CREATE TABLE `repository_commit` ( 1993 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 1994 `repositoryID` int(10) unsigned NOT NULL, 1995 `phid` varbinary(64) NOT NULL, 1996 `commitIdentifier` varchar(40) COLLATE {$COLLATE_TEXT} NOT NULL, 1997 `epoch` int(10) unsigned NOT NULL, 1998 `mailKey` binary(20) NOT NULL, 1999 `authorPHID` varbinary(64) DEFAULT NULL, 2000 `auditStatus` int(10) unsigned NOT NULL, 2001 `summary` varchar(80) COLLATE {$COLLATE_TEXT} NOT NULL, 2002 `importStatus` int(10) unsigned NOT NULL, 2003 PRIMARY KEY (`id`), 2004 UNIQUE KEY `phid` (`phid`), 2005 UNIQUE KEY `key_commit_identity` (`commitIdentifier`,`repositoryID`), 2006 KEY `repositoryID_2` (`repositoryID`,`epoch`), 2007 KEY `authorPHID` (`authorPHID`,`auditStatus`,`epoch`), 2008 KEY `repositoryID` (`repositoryID`,`importStatus`) 2009 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2010 2011 CREATE TABLE `repository_commitdata` ( 2012 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2013 `commitID` int(10) unsigned NOT NULL, 2014 `authorName` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2015 `commitMessage` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2016 `commitDetails` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2017 PRIMARY KEY (`id`), 2018 UNIQUE KEY `commitID` (`commitID`) 2019 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2020 2021 CREATE TABLE `repository_coverage` ( 2022 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2023 `branchID` int(10) unsigned NOT NULL, 2024 `commitID` int(10) unsigned NOT NULL, 2025 `pathID` int(10) unsigned NOT NULL, 2026 `coverage` longblob NOT NULL, 2027 PRIMARY KEY (`id`), 2028 KEY `key_path` (`branchID`,`pathID`,`commitID`) 2029 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2030 2031 CREATE TABLE `repository_filesystem` ( 2032 `repositoryID` int(10) unsigned NOT NULL, 2033 `parentID` int(10) unsigned NOT NULL, 2034 `svnCommit` int(10) unsigned NOT NULL, 2035 `pathID` int(10) unsigned NOT NULL, 2036 `existed` tinyint(1) NOT NULL, 2037 `fileType` int(10) unsigned NOT NULL, 2038 PRIMARY KEY (`repositoryID`,`parentID`,`pathID`,`svnCommit`), 2039 KEY `repositoryID` (`repositoryID`,`svnCommit`) 2040 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2041 2042 CREATE TABLE `repository_lintmessage` ( 2043 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2044 `branchID` int(10) unsigned NOT NULL, 2045 `path` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2046 `line` int(10) unsigned NOT NULL, 2047 `authorPHID` varbinary(64) DEFAULT NULL, 2048 `code` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2049 `severity` varchar(16) COLLATE {$COLLATE_TEXT} NOT NULL, 2050 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2051 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2052 PRIMARY KEY (`id`), 2053 KEY `branchID` (`branchID`,`path`(64)), 2054 KEY `branchID_2` (`branchID`,`code`,`path`(64)), 2055 KEY `key_author` (`authorPHID`) 2056 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2057 2058 CREATE TABLE `repository_mirror` ( 2059 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2060 `phid` varbinary(64) NOT NULL, 2061 `repositoryPHID` varbinary(64) NOT NULL, 2062 `remoteURI` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2063 `credentialPHID` varbinary(64) DEFAULT NULL, 2064 `dateCreated` int(10) unsigned NOT NULL, 2065 `dateModified` int(10) unsigned NOT NULL, 2066 PRIMARY KEY (`id`), 2067 UNIQUE KEY `key_phid` (`phid`), 2068 KEY `key_repository` (`repositoryPHID`) 2069 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2070 2071 CREATE TABLE `repository_parents` ( 2072 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2073 `childCommitID` int(10) unsigned NOT NULL, 2074 `parentCommitID` int(10) unsigned NOT NULL, 2075 PRIMARY KEY (`id`), 2076 UNIQUE KEY `key_child` (`childCommitID`,`parentCommitID`), 2077 KEY `key_parent` (`parentCommitID`) 2078 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2079 2080 CREATE TABLE `repository_path` ( 2081 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2082 `path` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2083 `pathHash` binary(32) NOT NULL, 2084 PRIMARY KEY (`id`), 2085 UNIQUE KEY `pathHash` (`pathHash`) 2086 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2087 2088 CREATE TABLE `repository_pathchange` ( 2089 `repositoryID` int(10) unsigned NOT NULL, 2090 `pathID` int(10) unsigned NOT NULL, 2091 `commitID` int(10) unsigned NOT NULL, 2092 `targetPathID` int(10) unsigned DEFAULT NULL, 2093 `targetCommitID` int(10) unsigned DEFAULT NULL, 2094 `changeType` int(10) unsigned NOT NULL, 2095 `fileType` int(10) unsigned NOT NULL, 2096 `isDirect` tinyint(1) NOT NULL, 2097 `commitSequence` int(10) unsigned NOT NULL, 2098 PRIMARY KEY (`commitID`,`pathID`), 2099 KEY `repositoryID` (`repositoryID`,`pathID`,`commitSequence`) 2100 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2101 2102 CREATE TABLE `repository_pushevent` ( 2103 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2104 `phid` varbinary(64) NOT NULL, 2105 `repositoryPHID` varbinary(64) NOT NULL, 2106 `epoch` int(10) unsigned NOT NULL, 2107 `pusherPHID` varbinary(64) NOT NULL, 2108 `remoteAddress` int(10) unsigned DEFAULT NULL, 2109 `remoteProtocol` varchar(32) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2110 `rejectCode` int(10) unsigned NOT NULL, 2111 `rejectDetails` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2112 PRIMARY KEY (`id`), 2113 UNIQUE KEY `key_phid` (`phid`), 2114 KEY `key_repository` (`repositoryPHID`) 2115 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2116 2117 CREATE TABLE `repository_pushlog` ( 2118 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2119 `phid` varbinary(64) NOT NULL, 2120 `epoch` int(10) unsigned NOT NULL, 2121 `pushEventPHID` varbinary(64) NOT NULL, 2122 `repositoryPHID` varbinary(64) NOT NULL, 2123 `pusherPHID` varbinary(64) NOT NULL, 2124 `refType` varchar(12) COLLATE {$COLLATE_TEXT} NOT NULL, 2125 `refNameHash` binary(12) DEFAULT NULL, 2126 `refNameRaw` longblob, 2127 `refNameEncoding` varchar(16) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2128 `refOld` varchar(40) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2129 `refNew` varchar(40) COLLATE {$COLLATE_TEXT} NOT NULL, 2130 `mergeBase` varchar(40) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2131 `changeFlags` int(10) unsigned NOT NULL, 2132 PRIMARY KEY (`id`), 2133 UNIQUE KEY `key_phid` (`phid`), 2134 KEY `key_repository` (`repositoryPHID`), 2135 KEY `key_ref` (`repositoryPHID`,`refNew`), 2136 KEY `key_pusher` (`pusherPHID`), 2137 KEY `key_name` (`repositoryPHID`,`refNameHash`), 2138 KEY `key_event` (`pushEventPHID`) 2139 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2140 2141 CREATE TABLE `repository_refcursor` ( 2142 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2143 `repositoryPHID` varbinary(64) NOT NULL, 2144 `refType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2145 `refNameHash` binary(12) NOT NULL, 2146 `refNameRaw` longblob NOT NULL, 2147 `refNameEncoding` varchar(16) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2148 `commitIdentifier` varchar(40) COLLATE {$COLLATE_TEXT} NOT NULL, 2149 PRIMARY KEY (`id`), 2150 KEY `key_cursor` (`repositoryPHID`,`refType`,`refNameHash`) 2151 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2152 2153 CREATE TABLE `repository_statusmessage` ( 2154 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2155 `repositoryID` int(10) unsigned NOT NULL, 2156 `statusType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2157 `statusCode` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2158 `parameters` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2159 `epoch` int(10) unsigned NOT NULL, 2160 PRIMARY KEY (`id`), 2161 UNIQUE KEY `repositoryID` (`repositoryID`,`statusType`) 2162 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2163 2164 CREATE TABLE `repository_summary` ( 2165 `repositoryID` int(10) unsigned NOT NULL, 2166 `size` int(10) unsigned NOT NULL, 2167 `lastCommitID` int(10) unsigned NOT NULL, 2168 `epoch` int(10) unsigned DEFAULT NULL, 2169 PRIMARY KEY (`repositoryID`), 2170 KEY `key_epoch` (`epoch`) 2171 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2172 2173 CREATE TABLE `repository_symbol` ( 2174 `arcanistProjectID` int(10) unsigned NOT NULL, 2175 `symbolContext` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2176 `symbolName` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2177 `symbolType` varchar(12) COLLATE {$COLLATE_TEXT} NOT NULL, 2178 `symbolLanguage` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2179 `pathID` int(10) unsigned NOT NULL, 2180 `lineNumber` int(10) unsigned NOT NULL, 2181 KEY `symbolName` (`symbolName`) 2182 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2183 2184 CREATE TABLE `repository_transaction` ( 2185 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2186 `phid` varbinary(64) NOT NULL, 2187 `authorPHID` varbinary(64) NOT NULL, 2188 `objectPHID` varbinary(64) NOT NULL, 2189 `viewPolicy` varbinary(64) NOT NULL, 2190 `editPolicy` varbinary(64) NOT NULL, 2191 `commentPHID` varbinary(64) DEFAULT NULL, 2192 `commentVersion` int(10) unsigned NOT NULL, 2193 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2194 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2195 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2196 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2197 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2198 `dateCreated` int(10) unsigned NOT NULL, 2199 `dateModified` int(10) unsigned NOT NULL, 2200 PRIMARY KEY (`id`), 2201 UNIQUE KEY `key_phid` (`phid`), 2202 KEY `key_object` (`objectPHID`) 2203 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2204 2205 CREATE TABLE `repository_vcspassword` ( 2206 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2207 `userPHID` varbinary(64) NOT NULL, 2208 `passwordHash` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2209 `dateCreated` int(10) unsigned NOT NULL, 2210 `dateModified` int(10) unsigned NOT NULL, 2211 PRIMARY KEY (`id`), 2212 UNIQUE KEY `key_phid` (`userPHID`) 2213 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2214 2215 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_search` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2216 2217 USE `{$NAMESPACE}_search`; 2218 2219 CREATE TABLE `search_document` ( 2220 `phid` varbinary(64) NOT NULL, 2221 `documentType` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 2222 `documentTitle` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2223 `documentCreated` int(10) unsigned NOT NULL, 2224 `documentModified` int(10) unsigned NOT NULL, 2225 PRIMARY KEY (`phid`), 2226 KEY `documentCreated` (`documentCreated`) 2227 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2228 2229 CREATE TABLE `search_documentfield` ( 2230 `phid` varbinary(64) NOT NULL, 2231 `phidType` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 2232 `field` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 2233 `auxPHID` varbinary(64) DEFAULT NULL, 2234 `corpus` longtext CHARACTER SET {$CHARSET_FULLTEXT} COLLATE {$COLLATE_FULLTEXT}, 2235 KEY `phid` (`phid`), 2236 FULLTEXT KEY `corpus` (`corpus`) 2237 ) ENGINE=MyISAM DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2238 2239 CREATE TABLE `search_documentrelationship` ( 2240 `phid` varbinary(64) NOT NULL, 2241 `relatedPHID` varbinary(64) NOT NULL, 2242 `relation` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 2243 `relatedType` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 2244 `relatedTime` int(10) unsigned NOT NULL, 2245 KEY `phid` (`phid`), 2246 KEY `relatedPHID` (`relatedPHID`,`relation`), 2247 KEY `relation` (`relation`,`relatedPHID`) 2248 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2249 2250 CREATE TABLE `search_namedquery` ( 2251 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2252 `userPHID` varbinary(64) NOT NULL, 2253 `engineClassName` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2254 `queryName` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2255 `queryKey` varchar(12) COLLATE {$COLLATE_TEXT} NOT NULL, 2256 `dateCreated` int(10) unsigned NOT NULL, 2257 `dateModified` int(10) unsigned NOT NULL, 2258 `isBuiltin` tinyint(1) NOT NULL DEFAULT '0', 2259 `isDisabled` tinyint(1) NOT NULL DEFAULT '0', 2260 `sequence` int(10) unsigned NOT NULL DEFAULT '0', 2261 PRIMARY KEY (`id`), 2262 UNIQUE KEY `key_userquery` (`userPHID`,`engineClassName`,`queryKey`) 2263 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2264 2265 CREATE TABLE `search_savedquery` ( 2266 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2267 `engineClassName` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2268 `parameters` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2269 `dateCreated` int(10) unsigned NOT NULL, 2270 `dateModified` int(10) unsigned NOT NULL, 2271 `queryKey` varchar(12) COLLATE {$COLLATE_TEXT} NOT NULL, 2272 PRIMARY KEY (`id`), 2273 UNIQUE KEY `key_queryKey` (`queryKey`) 2274 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2275 2276 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_slowvote` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2277 2278 USE `{$NAMESPACE}_slowvote`; 2279 2280 CREATE TABLE `edge` ( 2281 `src` varbinary(64) NOT NULL, 2282 `type` int(10) unsigned NOT NULL, 2283 `dst` varbinary(64) NOT NULL, 2284 `dateCreated` int(10) unsigned NOT NULL, 2285 `seq` int(10) unsigned NOT NULL, 2286 `dataID` int(10) unsigned DEFAULT NULL, 2287 PRIMARY KEY (`src`,`type`,`dst`), 2288 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 2289 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 2290 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2291 2292 CREATE TABLE `edgedata` ( 2293 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2294 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2295 PRIMARY KEY (`id`) 2296 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2297 2298 CREATE TABLE `slowvote_choice` ( 2299 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2300 `pollID` int(10) unsigned NOT NULL, 2301 `optionID` int(10) unsigned NOT NULL, 2302 `authorPHID` varbinary(64) NOT NULL, 2303 `dateCreated` int(10) unsigned NOT NULL, 2304 `dateModified` int(10) unsigned NOT NULL, 2305 PRIMARY KEY (`id`), 2306 KEY `pollID` (`pollID`), 2307 KEY `authorPHID` (`authorPHID`) 2308 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2309 2310 CREATE TABLE `slowvote_option` ( 2311 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2312 `pollID` int(10) unsigned NOT NULL, 2313 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2314 `dateCreated` int(10) unsigned NOT NULL, 2315 `dateModified` int(10) unsigned NOT NULL, 2316 PRIMARY KEY (`id`), 2317 KEY `pollID` (`pollID`) 2318 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2319 2320 CREATE TABLE `slowvote_poll` ( 2321 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2322 `question` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2323 `phid` varbinary(64) NOT NULL, 2324 `authorPHID` varbinary(64) NOT NULL, 2325 `responseVisibility` int(10) unsigned NOT NULL, 2326 `shuffle` int(10) unsigned NOT NULL, 2327 `method` int(10) unsigned NOT NULL, 2328 `dateCreated` int(10) unsigned NOT NULL, 2329 `dateModified` int(10) unsigned NOT NULL, 2330 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2331 `viewPolicy` varbinary(64) NOT NULL, 2332 `isClosed` tinyint(1) NOT NULL, 2333 PRIMARY KEY (`id`), 2334 UNIQUE KEY `phid` (`phid`) 2335 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2336 2337 CREATE TABLE `slowvote_transaction` ( 2338 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2339 `phid` varbinary(64) NOT NULL, 2340 `authorPHID` varbinary(64) NOT NULL, 2341 `objectPHID` varbinary(64) NOT NULL, 2342 `viewPolicy` varbinary(64) NOT NULL, 2343 `editPolicy` varbinary(64) NOT NULL, 2344 `commentPHID` varbinary(64) DEFAULT NULL, 2345 `commentVersion` int(10) unsigned NOT NULL, 2346 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2347 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2348 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2349 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2350 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2351 `dateCreated` int(10) unsigned NOT NULL, 2352 `dateModified` int(10) unsigned NOT NULL, 2353 PRIMARY KEY (`id`), 2354 UNIQUE KEY `key_phid` (`phid`), 2355 KEY `key_object` (`objectPHID`) 2356 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2357 2358 CREATE TABLE `slowvote_transaction_comment` ( 2359 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2360 `phid` varbinary(64) NOT NULL, 2361 `transactionPHID` varbinary(64) DEFAULT NULL, 2362 `authorPHID` varbinary(64) NOT NULL, 2363 `viewPolicy` varbinary(64) NOT NULL, 2364 `editPolicy` varbinary(64) NOT NULL, 2365 `commentVersion` int(10) unsigned NOT NULL, 2366 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2367 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2368 `isDeleted` tinyint(1) NOT NULL, 2369 `dateCreated` int(10) unsigned NOT NULL, 2370 `dateModified` int(10) unsigned NOT NULL, 2371 PRIMARY KEY (`id`), 2372 UNIQUE KEY `key_phid` (`phid`), 2373 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 2374 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2375 2376 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_user` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2377 2378 USE `{$NAMESPACE}_user`; 2379 2380 CREATE TABLE `edge` ( 2381 `src` varbinary(64) NOT NULL, 2382 `type` int(10) unsigned NOT NULL, 2383 `dst` varbinary(64) NOT NULL, 2384 `dateCreated` int(10) unsigned NOT NULL, 2385 `seq` int(10) unsigned NOT NULL, 2386 `dataID` int(10) unsigned DEFAULT NULL, 2387 PRIMARY KEY (`src`,`type`,`dst`), 2388 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 2389 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 2390 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2391 2392 CREATE TABLE `edgedata` ( 2393 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2394 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2395 PRIMARY KEY (`id`) 2396 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2397 2398 CREATE TABLE `phabricator_session` ( 2399 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2400 `userPHID` varbinary(64) NOT NULL, 2401 `type` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2402 `sessionKey` binary(40) NOT NULL, 2403 `sessionStart` int(10) unsigned NOT NULL, 2404 `sessionExpires` int(10) unsigned NOT NULL, 2405 `highSecurityUntil` int(10) unsigned DEFAULT NULL, 2406 `isPartial` tinyint(1) NOT NULL DEFAULT '0', 2407 PRIMARY KEY (`id`), 2408 UNIQUE KEY `sessionKey` (`sessionKey`), 2409 KEY `key_identity` (`userPHID`,`type`), 2410 KEY `key_expires` (`sessionExpires`) 2411 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2412 2413 CREATE TABLE `user` ( 2414 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2415 `phid` varbinary(64) NOT NULL, 2416 `userName` varchar(64) CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 2417 `realName` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2418 `sex` varchar(4) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2419 `translation` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2420 `passwordSalt` varchar(32) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2421 `passwordHash` varchar(128) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2422 `dateCreated` int(10) unsigned NOT NULL, 2423 `dateModified` int(10) unsigned NOT NULL, 2424 `profileImagePHID` varbinary(64) DEFAULT NULL, 2425 `consoleEnabled` tinyint(1) NOT NULL, 2426 `consoleVisible` tinyint(1) NOT NULL, 2427 `consoleTab` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 2428 `conduitCertificate` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2429 `isSystemAgent` tinyint(1) NOT NULL DEFAULT '0', 2430 `isDisabled` tinyint(1) NOT NULL, 2431 `isAdmin` tinyint(1) NOT NULL, 2432 `timezoneIdentifier` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2433 `isEmailVerified` int(10) unsigned NOT NULL, 2434 `isApproved` int(10) unsigned NOT NULL, 2435 `accountSecret` binary(64) NOT NULL, 2436 `isEnrolledInMultiFactor` tinyint(1) NOT NULL DEFAULT '0', 2437 PRIMARY KEY (`id`), 2438 UNIQUE KEY `userName` (`userName`), 2439 UNIQUE KEY `phid` (`phid`), 2440 KEY `realName` (`realName`), 2441 KEY `key_approved` (`isApproved`) 2442 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2443 2444 CREATE TABLE `user_configuredcustomfieldstorage` ( 2445 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2446 `objectPHID` varbinary(64) NOT NULL, 2447 `fieldIndex` binary(12) NOT NULL, 2448 `fieldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2449 PRIMARY KEY (`id`), 2450 UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`) 2451 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2452 2453 CREATE TABLE `user_customfieldnumericindex` ( 2454 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2455 `objectPHID` varbinary(64) NOT NULL, 2456 `indexKey` binary(12) NOT NULL, 2457 `indexValue` bigint(20) NOT NULL, 2458 PRIMARY KEY (`id`), 2459 KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`), 2460 KEY `key_find` (`indexKey`,`indexValue`) 2461 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2462 2463 CREATE TABLE `user_customfieldstringindex` ( 2464 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2465 `objectPHID` varbinary(64) NOT NULL, 2466 `indexKey` binary(12) NOT NULL, 2467 `indexValue` longtext CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 2468 PRIMARY KEY (`id`), 2469 KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)), 2470 KEY `key_find` (`indexKey`,`indexValue`(64)) 2471 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2472 2473 CREATE TABLE `user_email` ( 2474 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2475 `userPHID` varbinary(64) NOT NULL, 2476 `address` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2477 `isVerified` tinyint(1) NOT NULL DEFAULT '0', 2478 `isPrimary` tinyint(1) NOT NULL DEFAULT '0', 2479 `verificationCode` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2480 `dateCreated` int(10) unsigned NOT NULL, 2481 `dateModified` int(10) unsigned NOT NULL, 2482 PRIMARY KEY (`id`), 2483 UNIQUE KEY `address` (`address`), 2484 KEY `userPHID` (`userPHID`,`isPrimary`) 2485 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2486 2487 CREATE TABLE `user_externalaccount` ( 2488 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2489 `phid` varbinary(64) NOT NULL, 2490 `userPHID` varbinary(64) DEFAULT NULL, 2491 `accountType` varchar(16) COLLATE {$COLLATE_TEXT} NOT NULL, 2492 `accountDomain` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 2493 `accountSecret` longtext COLLATE {$COLLATE_TEXT}, 2494 `accountID` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 2495 `displayName` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2496 `dateCreated` int(10) unsigned NOT NULL, 2497 `dateModified` int(10) unsigned NOT NULL, 2498 `username` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2499 `realName` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2500 `email` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2501 `emailVerified` tinyint(1) NOT NULL, 2502 `accountURI` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2503 `profileImagePHID` varbinary(64) DEFAULT NULL, 2504 `properties` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2505 PRIMARY KEY (`id`), 2506 UNIQUE KEY `phid` (`phid`), 2507 UNIQUE KEY `account_details` (`accountType`,`accountDomain`,`accountID`) 2508 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2509 2510 CREATE TABLE `user_log` ( 2511 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2512 `actorPHID` varbinary(64) DEFAULT NULL, 2513 `userPHID` varbinary(64) NOT NULL, 2514 `action` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 2515 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2516 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2517 `details` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2518 `dateCreated` int(10) unsigned NOT NULL, 2519 `dateModified` int(10) unsigned NOT NULL, 2520 `remoteAddr` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 2521 `session` binary(40) DEFAULT NULL, 2522 PRIMARY KEY (`id`), 2523 KEY `actorPHID` (`actorPHID`,`dateCreated`), 2524 KEY `userPHID` (`userPHID`,`dateCreated`), 2525 KEY `action` (`action`,`dateCreated`), 2526 KEY `dateCreated` (`dateCreated`), 2527 KEY `remoteAddr` (`remoteAddr`,`dateCreated`), 2528 KEY `session` (`session`,`dateCreated`) 2529 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2530 2531 CREATE TABLE `user_nametoken` ( 2532 `token` varchar(255) CHARACTER SET {$CHARSET} COLLATE {$COLLATE_SORT} NOT NULL, 2533 `userID` int(10) unsigned NOT NULL, 2534 KEY `userID` (`userID`), 2535 KEY `token` (`token`(128)) 2536 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2537 2538 CREATE TABLE `user_preferences` ( 2539 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2540 `userPHID` varbinary(64) NOT NULL, 2541 `preferences` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2542 PRIMARY KEY (`id`), 2543 UNIQUE KEY `userPHID` (`userPHID`) 2544 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2545 2546 CREATE TABLE `user_profile` ( 2547 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2548 `userPHID` varbinary(64) NOT NULL, 2549 `title` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2550 `blurb` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2551 `profileImagePHID` varbinary(64) DEFAULT NULL, 2552 `dateCreated` int(10) unsigned NOT NULL, 2553 `dateModified` int(10) unsigned NOT NULL, 2554 PRIMARY KEY (`id`), 2555 UNIQUE KEY `userPHID` (`userPHID`) 2556 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2557 2558 CREATE TABLE `user_transaction` ( 2559 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2560 `phid` varbinary(64) NOT NULL, 2561 `authorPHID` varbinary(64) NOT NULL, 2562 `objectPHID` varbinary(64) NOT NULL, 2563 `viewPolicy` varbinary(64) NOT NULL, 2564 `editPolicy` varbinary(64) NOT NULL, 2565 `commentPHID` varbinary(64) DEFAULT NULL, 2566 `commentVersion` int(10) unsigned NOT NULL, 2567 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2568 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2569 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2570 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2571 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2572 `dateCreated` int(10) unsigned NOT NULL, 2573 `dateModified` int(10) unsigned NOT NULL, 2574 PRIMARY KEY (`id`), 2575 UNIQUE KEY `key_phid` (`phid`), 2576 KEY `key_object` (`objectPHID`) 2577 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2578 2579 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_worker` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2580 2581 USE `{$NAMESPACE}_worker`; 2582 2583 CREATE TABLE `lisk_counter` ( 2584 `counterName` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2585 `counterValue` bigint(20) unsigned NOT NULL, 2586 PRIMARY KEY (`counterName`) 2587 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2588 2589 INSERT INTO `lisk_counter` VALUES ('worker_activetask',2); 2590 2591 CREATE TABLE `worker_activetask` ( 2592 `id` int(10) unsigned NOT NULL, 2593 `taskClass` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 2594 `leaseOwner` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2595 `leaseExpires` int(10) unsigned DEFAULT NULL, 2596 `failureCount` int(10) unsigned NOT NULL, 2597 `dataID` int(10) unsigned DEFAULT NULL, 2598 `failureTime` int(10) unsigned DEFAULT NULL, 2599 `priority` int(10) unsigned NOT NULL, 2600 PRIMARY KEY (`id`), 2601 UNIQUE KEY `dataID` (`dataID`), 2602 KEY `leaseExpires` (`leaseExpires`), 2603 KEY `leaseOwner` (`leaseOwner`(16)), 2604 KEY `key_failuretime` (`failureTime`), 2605 KEY `taskClass` (`taskClass`), 2606 KEY `leaseOwner_2` (`leaseOwner`,`priority`,`id`) 2607 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2608 2609 CREATE TABLE `worker_archivetask` ( 2610 `id` int(10) unsigned NOT NULL, 2611 `taskClass` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 2612 `leaseOwner` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2613 `leaseExpires` int(10) unsigned DEFAULT NULL, 2614 `failureCount` int(10) unsigned NOT NULL, 2615 `dataID` int(10) unsigned NOT NULL, 2616 `result` int(10) unsigned NOT NULL, 2617 `duration` bigint(20) unsigned NOT NULL, 2618 `dateCreated` int(10) unsigned NOT NULL, 2619 `dateModified` int(10) unsigned NOT NULL, 2620 `priority` int(10) unsigned NOT NULL, 2621 PRIMARY KEY (`id`), 2622 KEY `dateCreated` (`dateCreated`), 2623 KEY `leaseOwner` (`leaseOwner`,`priority`,`id`) 2624 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2625 2626 CREATE TABLE `worker_taskdata` ( 2627 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2628 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2629 PRIMARY KEY (`id`) 2630 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2631 2632 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_xhpastview` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2633 2634 USE `{$NAMESPACE}_xhpastview`; 2635 2636 CREATE TABLE `xhpastview_parsetree` ( 2637 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2638 `authorPHID` varbinary(64) DEFAULT NULL, 2639 `input` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2640 `stdout` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2641 `dateCreated` int(10) unsigned NOT NULL, 2642 `dateModified` int(10) unsigned NOT NULL, 2643 PRIMARY KEY (`id`) 2644 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2645 2646 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_cache` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2647 2648 USE `{$NAMESPACE}_cache`; 2649 2650 CREATE TABLE `cache_general` ( 2651 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 2652 `cacheKeyHash` binary(12) NOT NULL, 2653 `cacheKey` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2654 `cacheFormat` varchar(16) COLLATE {$COLLATE_TEXT} NOT NULL, 2655 `cacheData` longblob NOT NULL, 2656 `cacheCreated` int(10) unsigned NOT NULL, 2657 `cacheExpires` int(10) unsigned DEFAULT NULL, 2658 PRIMARY KEY (`id`), 2659 UNIQUE KEY `key_cacheKeyHash` (`cacheKeyHash`), 2660 KEY `key_cacheCreated` (`cacheCreated`), 2661 KEY `key_ttl` (`cacheExpires`) 2662 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2663 2664 CREATE TABLE `cache_markupcache` ( 2665 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2666 `cacheKey` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2667 `cacheData` longblob NOT NULL, 2668 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2669 `dateCreated` int(10) unsigned NOT NULL, 2670 `dateModified` int(10) unsigned NOT NULL, 2671 PRIMARY KEY (`id`), 2672 UNIQUE KEY `cacheKey` (`cacheKey`), 2673 KEY `dateCreated` (`dateCreated`) 2674 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2675 2676 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_fact` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2677 2678 USE `{$NAMESPACE}_fact`; 2679 2680 CREATE TABLE `fact_aggregate` ( 2681 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 2682 `factType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2683 `objectPHID` varbinary(64) NOT NULL, 2684 `valueX` bigint(20) unsigned NOT NULL, 2685 PRIMARY KEY (`id`), 2686 UNIQUE KEY `factType` (`factType`,`objectPHID`) 2687 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2688 2689 CREATE TABLE `fact_cursor` ( 2690 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2691 `name` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 2692 `position` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 2693 PRIMARY KEY (`id`), 2694 UNIQUE KEY `name` (`name`) 2695 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2696 2697 CREATE TABLE `fact_raw` ( 2698 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 2699 `factType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2700 `objectPHID` varbinary(64) NOT NULL, 2701 `objectA` varbinary(64) NOT NULL, 2702 `valueX` bigint(20) NOT NULL, 2703 `valueY` bigint(20) NOT NULL, 2704 `epoch` int(10) unsigned NOT NULL, 2705 PRIMARY KEY (`id`), 2706 KEY `objectPHID` (`objectPHID`), 2707 KEY `factType` (`factType`,`epoch`), 2708 KEY `factType_2` (`factType`,`objectA`) 2709 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2710 2711 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_ponder` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2712 2713 USE `{$NAMESPACE}_ponder`; 2714 2715 CREATE TABLE `edge` ( 2716 `src` varbinary(64) NOT NULL, 2717 `type` int(10) unsigned NOT NULL, 2718 `dst` varbinary(64) NOT NULL, 2719 `dateCreated` int(10) unsigned NOT NULL, 2720 `seq` int(10) unsigned NOT NULL, 2721 `dataID` int(10) unsigned DEFAULT NULL, 2722 PRIMARY KEY (`src`,`type`,`dst`), 2723 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 2724 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 2725 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2726 2727 CREATE TABLE `edgedata` ( 2728 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2729 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2730 PRIMARY KEY (`id`) 2731 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2732 2733 CREATE TABLE `ponder_answer` ( 2734 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2735 `questionID` int(10) unsigned NOT NULL, 2736 `phid` varbinary(64) NOT NULL, 2737 `voteCount` int(10) NOT NULL, 2738 `authorPHID` varbinary(64) NOT NULL, 2739 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2740 `dateCreated` int(10) unsigned NOT NULL, 2741 `dateModified` int(10) unsigned NOT NULL, 2742 `contentSource` longtext COLLATE {$COLLATE_TEXT}, 2743 PRIMARY KEY (`id`), 2744 UNIQUE KEY `phid` (`phid`), 2745 UNIQUE KEY `key_oneanswerperquestion` (`questionID`,`authorPHID`), 2746 KEY `questionID` (`questionID`), 2747 KEY `authorPHID` (`authorPHID`) 2748 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2749 2750 CREATE TABLE `ponder_answertransaction` ( 2751 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2752 `phid` varbinary(64) NOT NULL, 2753 `authorPHID` varbinary(64) NOT NULL, 2754 `objectPHID` varbinary(64) NOT NULL, 2755 `viewPolicy` varbinary(64) NOT NULL, 2756 `editPolicy` varbinary(64) NOT NULL, 2757 `commentPHID` varbinary(64) DEFAULT NULL, 2758 `commentVersion` int(10) unsigned NOT NULL, 2759 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2760 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2761 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2762 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2763 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2764 `dateCreated` int(10) unsigned NOT NULL, 2765 `dateModified` int(10) unsigned NOT NULL, 2766 PRIMARY KEY (`id`), 2767 UNIQUE KEY `key_phid` (`phid`), 2768 KEY `key_object` (`objectPHID`) 2769 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2770 2771 CREATE TABLE `ponder_answertransaction_comment` ( 2772 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2773 `phid` varbinary(64) NOT NULL, 2774 `transactionPHID` varbinary(64) DEFAULT NULL, 2775 `authorPHID` varbinary(64) NOT NULL, 2776 `viewPolicy` varbinary(64) NOT NULL, 2777 `editPolicy` varbinary(64) NOT NULL, 2778 `commentVersion` int(10) unsigned NOT NULL, 2779 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2780 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2781 `isDeleted` tinyint(1) NOT NULL, 2782 `dateCreated` int(10) unsigned NOT NULL, 2783 `dateModified` int(10) unsigned NOT NULL, 2784 PRIMARY KEY (`id`), 2785 UNIQUE KEY `key_phid` (`phid`), 2786 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 2787 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2788 2789 CREATE TABLE `ponder_question` ( 2790 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2791 `title` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 2792 `phid` varbinary(64) NOT NULL, 2793 `voteCount` int(10) NOT NULL, 2794 `authorPHID` varbinary(64) NOT NULL, 2795 `status` int(10) unsigned NOT NULL, 2796 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2797 `dateCreated` int(10) unsigned NOT NULL, 2798 `dateModified` int(10) unsigned NOT NULL, 2799 `contentSource` longtext COLLATE {$COLLATE_TEXT}, 2800 `heat` double NOT NULL, 2801 `answerCount` int(10) unsigned NOT NULL, 2802 `mailKey` binary(20) NOT NULL, 2803 PRIMARY KEY (`id`), 2804 UNIQUE KEY `phid` (`phid`), 2805 KEY `authorPHID` (`authorPHID`), 2806 KEY `heat` (`heat`), 2807 KEY `status` (`status`) 2808 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2809 2810 CREATE TABLE `ponder_questiontransaction` ( 2811 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2812 `phid` varbinary(64) NOT NULL, 2813 `authorPHID` varbinary(64) NOT NULL, 2814 `objectPHID` varbinary(64) NOT NULL, 2815 `viewPolicy` varbinary(64) NOT NULL, 2816 `editPolicy` varbinary(64) NOT NULL, 2817 `commentPHID` varbinary(64) DEFAULT NULL, 2818 `commentVersion` int(10) unsigned NOT NULL, 2819 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2820 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2821 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2822 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2823 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2824 `dateCreated` int(10) unsigned NOT NULL, 2825 `dateModified` int(10) unsigned NOT NULL, 2826 PRIMARY KEY (`id`), 2827 UNIQUE KEY `key_phid` (`phid`), 2828 KEY `key_object` (`objectPHID`) 2829 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2830 2831 CREATE TABLE `ponder_questiontransaction_comment` ( 2832 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2833 `phid` varbinary(64) NOT NULL, 2834 `transactionPHID` varbinary(64) DEFAULT NULL, 2835 `authorPHID` varbinary(64) NOT NULL, 2836 `viewPolicy` varbinary(64) NOT NULL, 2837 `editPolicy` varbinary(64) NOT NULL, 2838 `commentVersion` int(10) unsigned NOT NULL, 2839 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2840 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2841 `isDeleted` tinyint(1) NOT NULL, 2842 `dateCreated` int(10) unsigned NOT NULL, 2843 `dateModified` int(10) unsigned NOT NULL, 2844 PRIMARY KEY (`id`), 2845 UNIQUE KEY `key_phid` (`phid`), 2846 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 2847 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2848 2849 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_xhprof` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2850 2851 USE `{$NAMESPACE}_xhprof`; 2852 2853 CREATE TABLE `xhprof_sample` ( 2854 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2855 `filePHID` varbinary(64) NOT NULL, 2856 `sampleRate` int(10) unsigned NOT NULL, 2857 `usTotal` bigint(20) unsigned NOT NULL, 2858 `hostname` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2859 `requestPath` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2860 `controller` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2861 `userPHID` varbinary(64) DEFAULT NULL, 2862 `dateCreated` int(10) unsigned NOT NULL, 2863 `dateModified` int(10) unsigned NOT NULL, 2864 PRIMARY KEY (`id`), 2865 UNIQUE KEY `filePHID` (`filePHID`) 2866 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2867 2868 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_pholio` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2869 2870 USE `{$NAMESPACE}_pholio`; 2871 2872 CREATE TABLE `edge` ( 2873 `src` varbinary(64) NOT NULL, 2874 `type` int(10) unsigned NOT NULL, 2875 `dst` varbinary(64) NOT NULL, 2876 `dateCreated` int(10) unsigned NOT NULL, 2877 `seq` int(10) unsigned NOT NULL, 2878 `dataID` int(10) unsigned DEFAULT NULL, 2879 PRIMARY KEY (`src`,`type`,`dst`), 2880 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 2881 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 2882 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2883 2884 CREATE TABLE `edgedata` ( 2885 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2886 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2887 PRIMARY KEY (`id`) 2888 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2889 2890 CREATE TABLE `pholio_image` ( 2891 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2892 `phid` varbinary(64) NOT NULL, 2893 `mockID` int(10) unsigned DEFAULT NULL, 2894 `filePHID` varbinary(64) NOT NULL, 2895 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2896 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2897 `sequence` int(10) unsigned NOT NULL, 2898 `dateCreated` int(10) unsigned NOT NULL, 2899 `dateModified` int(10) unsigned NOT NULL, 2900 `isObsolete` tinyint(1) NOT NULL DEFAULT '0', 2901 `replacesImagePHID` varbinary(64) DEFAULT NULL, 2902 PRIMARY KEY (`id`), 2903 UNIQUE KEY `keyPHID` (`phid`), 2904 KEY `mockID` (`mockID`,`isObsolete`,`sequence`) 2905 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2906 2907 CREATE TABLE `pholio_mock` ( 2908 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2909 `phid` varbinary(64) NOT NULL, 2910 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2911 `originalName` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 2912 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2913 `authorPHID` varbinary(64) NOT NULL, 2914 `viewPolicy` varbinary(64) NOT NULL, 2915 `coverPHID` varbinary(64) NOT NULL, 2916 `mailKey` binary(20) NOT NULL, 2917 `dateCreated` int(10) unsigned NOT NULL, 2918 `dateModified` int(10) unsigned NOT NULL, 2919 `status` varchar(12) COLLATE {$COLLATE_TEXT} NOT NULL, 2920 `editPolicy` varbinary(64) NOT NULL, 2921 PRIMARY KEY (`id`), 2922 UNIQUE KEY `phid` (`phid`), 2923 KEY `authorPHID` (`authorPHID`) 2924 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2925 2926 CREATE TABLE `pholio_transaction` ( 2927 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2928 `phid` varbinary(64) NOT NULL, 2929 `authorPHID` varbinary(64) NOT NULL, 2930 `objectPHID` varbinary(64) NOT NULL, 2931 `viewPolicy` varbinary(64) NOT NULL, 2932 `editPolicy` varbinary(64) NOT NULL, 2933 `commentPHID` varbinary(64) DEFAULT NULL, 2934 `commentVersion` int(10) unsigned NOT NULL, 2935 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 2936 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2937 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2938 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2939 `dateCreated` int(10) unsigned NOT NULL, 2940 `dateModified` int(10) unsigned NOT NULL, 2941 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2942 PRIMARY KEY (`id`), 2943 UNIQUE KEY `key_phid` (`phid`), 2944 KEY `key_object` (`objectPHID`) 2945 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2946 2947 CREATE TABLE `pholio_transaction_comment` ( 2948 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2949 `phid` varbinary(64) NOT NULL, 2950 `transactionPHID` varbinary(64) DEFAULT NULL, 2951 `authorPHID` varbinary(64) NOT NULL, 2952 `viewPolicy` varbinary(64) NOT NULL, 2953 `editPolicy` varbinary(64) NOT NULL, 2954 `commentVersion` int(10) unsigned NOT NULL, 2955 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2956 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2957 `isDeleted` tinyint(1) NOT NULL, 2958 `dateCreated` int(10) unsigned NOT NULL, 2959 `dateModified` int(10) unsigned NOT NULL, 2960 `imageID` int(10) unsigned DEFAULT NULL, 2961 `x` int(10) unsigned DEFAULT NULL, 2962 `y` int(10) unsigned DEFAULT NULL, 2963 `width` int(10) unsigned DEFAULT NULL, 2964 `height` int(10) unsigned DEFAULT NULL, 2965 PRIMARY KEY (`id`), 2966 UNIQUE KEY `key_phid` (`phid`), 2967 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`), 2968 UNIQUE KEY `key_draft` (`authorPHID`,`imageID`,`transactionPHID`) 2969 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2970 2971 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_conpherence` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 2972 2973 USE `{$NAMESPACE}_conpherence`; 2974 2975 CREATE TABLE `conpherence_participant` ( 2976 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2977 `participantPHID` varbinary(64) NOT NULL, 2978 `conpherencePHID` varbinary(64) NOT NULL, 2979 `participationStatus` int(10) unsigned NOT NULL DEFAULT '0', 2980 `dateTouched` int(10) unsigned NOT NULL, 2981 `behindTransactionPHID` varbinary(64) NOT NULL, 2982 `seenMessageCount` bigint(20) unsigned NOT NULL, 2983 `settings` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2984 `dateCreated` int(10) unsigned NOT NULL, 2985 `dateModified` int(10) unsigned NOT NULL, 2986 PRIMARY KEY (`id`), 2987 UNIQUE KEY `conpherencePHID` (`conpherencePHID`,`participantPHID`), 2988 KEY `unreadCount` (`participantPHID`,`participationStatus`), 2989 KEY `participationIndex` (`participantPHID`,`dateTouched`,`id`) 2990 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 2991 2992 CREATE TABLE `conpherence_thread` ( 2993 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 2994 `phid` varbinary(64) NOT NULL, 2995 `title` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 2996 `messageCount` bigint(20) unsigned NOT NULL, 2997 `recentParticipantPHIDs` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 2998 `mailKey` varchar(20) COLLATE {$COLLATE_TEXT} NOT NULL, 2999 `dateCreated` int(10) unsigned NOT NULL, 3000 `dateModified` int(10) unsigned NOT NULL, 3001 PRIMARY KEY (`id`), 3002 UNIQUE KEY `phid` (`phid`) 3003 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3004 3005 CREATE TABLE `conpherence_transaction` ( 3006 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3007 `phid` varbinary(64) NOT NULL, 3008 `authorPHID` varbinary(64) NOT NULL, 3009 `objectPHID` varbinary(64) NOT NULL, 3010 `viewPolicy` varbinary(64) NOT NULL, 3011 `editPolicy` varbinary(64) NOT NULL, 3012 `commentPHID` varbinary(64) DEFAULT NULL, 3013 `commentVersion` int(10) unsigned NOT NULL, 3014 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3015 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3016 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3017 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3018 `dateCreated` int(10) unsigned NOT NULL, 3019 `dateModified` int(10) unsigned NOT NULL, 3020 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3021 PRIMARY KEY (`id`), 3022 UNIQUE KEY `key_phid` (`phid`), 3023 KEY `key_object` (`objectPHID`) 3024 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3025 3026 CREATE TABLE `conpherence_transaction_comment` ( 3027 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3028 `phid` varbinary(64) NOT NULL, 3029 `transactionPHID` varbinary(64) DEFAULT NULL, 3030 `authorPHID` varbinary(64) NOT NULL, 3031 `viewPolicy` varbinary(64) NOT NULL, 3032 `editPolicy` varbinary(64) NOT NULL, 3033 `commentVersion` int(10) unsigned NOT NULL, 3034 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3035 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3036 `isDeleted` tinyint(1) NOT NULL, 3037 `dateCreated` int(10) unsigned NOT NULL, 3038 `dateModified` int(10) unsigned NOT NULL, 3039 `conpherencePHID` varbinary(64) DEFAULT NULL, 3040 PRIMARY KEY (`id`), 3041 UNIQUE KEY `key_phid` (`phid`), 3042 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`), 3043 UNIQUE KEY `key_draft` (`authorPHID`,`conpherencePHID`,`transactionPHID`) 3044 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3045 3046 CREATE TABLE `edge` ( 3047 `src` varbinary(64) NOT NULL, 3048 `type` int(10) unsigned NOT NULL, 3049 `dst` varbinary(64) NOT NULL, 3050 `dateCreated` int(10) unsigned NOT NULL, 3051 `seq` int(10) unsigned NOT NULL, 3052 `dataID` int(10) unsigned DEFAULT NULL, 3053 PRIMARY KEY (`src`,`type`,`dst`), 3054 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 3055 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 3056 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3057 3058 CREATE TABLE `edgedata` ( 3059 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3060 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3061 PRIMARY KEY (`id`) 3062 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3063 3064 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_config` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3065 3066 USE `{$NAMESPACE}_config`; 3067 3068 CREATE TABLE `config_entry` ( 3069 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3070 `phid` varbinary(64) NOT NULL, 3071 `namespace` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3072 `configKey` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3073 `value` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3074 `isDeleted` tinyint(1) NOT NULL, 3075 `dateCreated` int(10) unsigned NOT NULL, 3076 `dateModified` int(10) unsigned NOT NULL, 3077 PRIMARY KEY (`id`), 3078 UNIQUE KEY `key_phid` (`phid`), 3079 UNIQUE KEY `key_name` (`namespace`,`configKey`) 3080 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3081 3082 CREATE TABLE `config_transaction` ( 3083 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3084 `phid` varbinary(64) NOT NULL, 3085 `authorPHID` varbinary(64) NOT NULL, 3086 `objectPHID` varbinary(64) NOT NULL, 3087 `viewPolicy` varbinary(64) NOT NULL, 3088 `editPolicy` varbinary(64) NOT NULL, 3089 `commentPHID` varbinary(64) DEFAULT NULL, 3090 `commentVersion` int(10) unsigned NOT NULL, 3091 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3092 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3093 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3094 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3095 `dateCreated` int(10) unsigned NOT NULL, 3096 `dateModified` int(10) unsigned NOT NULL, 3097 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3098 PRIMARY KEY (`id`), 3099 UNIQUE KEY `key_phid` (`phid`), 3100 KEY `key_object` (`objectPHID`) 3101 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3102 3103 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_token` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3104 3105 USE `{$NAMESPACE}_token`; 3106 3107 CREATE TABLE `token_count` ( 3108 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3109 `objectPHID` varbinary(64) NOT NULL, 3110 `tokenCount` int(10) unsigned NOT NULL, 3111 PRIMARY KEY (`id`), 3112 UNIQUE KEY `key_objectPHID` (`objectPHID`), 3113 KEY `key_count` (`tokenCount`) 3114 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3115 3116 CREATE TABLE `token_given` ( 3117 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3118 `objectPHID` varbinary(64) NOT NULL, 3119 `authorPHID` varbinary(64) NOT NULL, 3120 `tokenPHID` varbinary(64) NOT NULL, 3121 `dateCreated` int(10) unsigned NOT NULL, 3122 `dateModified` int(10) unsigned NOT NULL, 3123 PRIMARY KEY (`id`), 3124 UNIQUE KEY `key_all` (`objectPHID`,`authorPHID`), 3125 KEY `key_author` (`authorPHID`), 3126 KEY `key_token` (`tokenPHID`) 3127 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3128 3129 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_releeph` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3130 3131 USE `{$NAMESPACE}_releeph`; 3132 3133 CREATE TABLE `releeph_branch` ( 3134 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3135 `dateCreated` int(10) unsigned NOT NULL, 3136 `dateModified` int(10) unsigned NOT NULL, 3137 `basename` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3138 `releephProjectID` int(10) unsigned NOT NULL, 3139 `createdByUserPHID` varbinary(64) NOT NULL, 3140 `cutPointCommitPHID` varbinary(64) NOT NULL, 3141 `isActive` tinyint(1) NOT NULL DEFAULT '1', 3142 `symbolicName` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3143 `details` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3144 `phid` varbinary(64) NOT NULL, 3145 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 3146 PRIMARY KEY (`id`), 3147 UNIQUE KEY `releephProjectID_2` (`releephProjectID`,`basename`), 3148 UNIQUE KEY `releephProjectID_name` (`releephProjectID`,`name`), 3149 UNIQUE KEY `key_phid` (`phid`), 3150 UNIQUE KEY `releephProjectID` (`releephProjectID`,`symbolicName`) 3151 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3152 3153 CREATE TABLE `releeph_branchtransaction` ( 3154 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3155 `phid` varbinary(64) NOT NULL, 3156 `authorPHID` varbinary(64) NOT NULL, 3157 `objectPHID` varbinary(64) NOT NULL, 3158 `viewPolicy` varbinary(64) NOT NULL, 3159 `editPolicy` varbinary(64) NOT NULL, 3160 `commentPHID` varbinary(64) DEFAULT NULL, 3161 `commentVersion` int(10) unsigned NOT NULL, 3162 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3163 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3164 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3165 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3166 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3167 `dateCreated` int(10) unsigned NOT NULL, 3168 `dateModified` int(10) unsigned NOT NULL, 3169 PRIMARY KEY (`id`), 3170 UNIQUE KEY `key_phid` (`phid`), 3171 KEY `key_object` (`objectPHID`) 3172 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3173 3174 CREATE TABLE `releeph_producttransaction` ( 3175 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3176 `phid` varbinary(64) NOT NULL, 3177 `authorPHID` varbinary(64) NOT NULL, 3178 `objectPHID` varbinary(64) NOT NULL, 3179 `viewPolicy` varbinary(64) NOT NULL, 3180 `editPolicy` varbinary(64) NOT NULL, 3181 `commentPHID` varbinary(64) DEFAULT NULL, 3182 `commentVersion` int(10) unsigned NOT NULL, 3183 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3184 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3185 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3186 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3187 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3188 `dateCreated` int(10) unsigned NOT NULL, 3189 `dateModified` int(10) unsigned NOT NULL, 3190 PRIMARY KEY (`id`), 3191 UNIQUE KEY `key_phid` (`phid`), 3192 KEY `key_object` (`objectPHID`) 3193 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3194 3195 CREATE TABLE `releeph_project` ( 3196 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3197 `dateCreated` int(10) unsigned NOT NULL, 3198 `dateModified` int(10) unsigned NOT NULL, 3199 `phid` varbinary(64) NOT NULL, 3200 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 3201 `trunkBranch` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 3202 `repositoryPHID` varbinary(64) NOT NULL, 3203 `arcanistProjectID` int(10) unsigned NOT NULL, 3204 `createdByUserPHID` varbinary(64) NOT NULL, 3205 `isActive` tinyint(1) NOT NULL DEFAULT '1', 3206 `details` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3207 PRIMARY KEY (`id`), 3208 UNIQUE KEY `projectName` (`name`), 3209 UNIQUE KEY `key_phid` (`phid`) 3210 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3211 3212 CREATE TABLE `releeph_request` ( 3213 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3214 `dateCreated` int(10) unsigned NOT NULL, 3215 `dateModified` int(10) unsigned NOT NULL, 3216 `phid` varbinary(64) NOT NULL, 3217 `branchID` int(10) unsigned NOT NULL, 3218 `requestUserPHID` varbinary(64) NOT NULL, 3219 `requestCommitPHID` varbinary(64) DEFAULT NULL, 3220 `commitIdentifier` varchar(40) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3221 `commitPHID` varbinary(64) DEFAULT NULL, 3222 `pickStatus` int(10) unsigned DEFAULT NULL, 3223 `details` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3224 `userIntents` longtext COLLATE {$COLLATE_TEXT}, 3225 `inBranch` tinyint(1) NOT NULL DEFAULT '0', 3226 `mailKey` binary(20) NOT NULL, 3227 `requestedObjectPHID` varbinary(64) NOT NULL, 3228 PRIMARY KEY (`id`), 3229 UNIQUE KEY `phid` (`phid`), 3230 UNIQUE KEY `requestIdentifierBranch` (`requestCommitPHID`,`branchID`), 3231 KEY `branchID` (`branchID`), 3232 KEY `key_requestedObject` (`requestedObjectPHID`) 3233 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3234 3235 CREATE TABLE `releeph_requesttransaction` ( 3236 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3237 `phid` varbinary(64) NOT NULL, 3238 `authorPHID` varbinary(64) NOT NULL, 3239 `objectPHID` varbinary(64) NOT NULL, 3240 `viewPolicy` varbinary(64) NOT NULL, 3241 `editPolicy` varbinary(64) NOT NULL, 3242 `commentPHID` varbinary(64) DEFAULT NULL, 3243 `commentVersion` int(10) unsigned NOT NULL, 3244 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3245 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3246 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3247 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3248 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3249 `dateCreated` int(10) unsigned NOT NULL, 3250 `dateModified` int(10) unsigned NOT NULL, 3251 PRIMARY KEY (`id`), 3252 UNIQUE KEY `key_phid` (`phid`), 3253 KEY `key_object` (`objectPHID`) 3254 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3255 3256 CREATE TABLE `releeph_requesttransaction_comment` ( 3257 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3258 `phid` varbinary(64) NOT NULL, 3259 `transactionPHID` varbinary(64) DEFAULT NULL, 3260 `authorPHID` varbinary(64) NOT NULL, 3261 `viewPolicy` varbinary(64) NOT NULL, 3262 `editPolicy` varbinary(64) NOT NULL, 3263 `commentVersion` int(10) unsigned NOT NULL, 3264 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3265 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3266 `isDeleted` tinyint(1) NOT NULL, 3267 `dateCreated` int(10) unsigned NOT NULL, 3268 `dateModified` int(10) unsigned NOT NULL, 3269 PRIMARY KEY (`id`), 3270 UNIQUE KEY `key_phid` (`phid`), 3271 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 3272 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3273 3274 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_phlux` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3275 3276 USE `{$NAMESPACE}_phlux`; 3277 3278 CREATE TABLE `phlux_transaction` ( 3279 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3280 `phid` varbinary(64) NOT NULL, 3281 `authorPHID` varbinary(64) NOT NULL, 3282 `objectPHID` varbinary(64) NOT NULL, 3283 `viewPolicy` varbinary(64) NOT NULL, 3284 `editPolicy` varbinary(64) NOT NULL, 3285 `commentPHID` varbinary(64) DEFAULT NULL, 3286 `commentVersion` int(10) unsigned NOT NULL, 3287 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3288 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3289 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3290 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3291 `dateCreated` int(10) unsigned NOT NULL, 3292 `dateModified` int(10) unsigned NOT NULL, 3293 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3294 PRIMARY KEY (`id`), 3295 UNIQUE KEY `key_phid` (`phid`), 3296 KEY `key_object` (`objectPHID`) 3297 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3298 3299 CREATE TABLE `phlux_variable` ( 3300 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3301 `phid` varbinary(64) NOT NULL, 3302 `variableKey` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3303 `variableValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3304 `viewPolicy` varbinary(64) NOT NULL, 3305 `editPolicy` varbinary(64) NOT NULL, 3306 `dateCreated` int(10) unsigned NOT NULL, 3307 `dateModified` int(10) unsigned NOT NULL, 3308 PRIMARY KEY (`id`), 3309 UNIQUE KEY `key_phid` (`phid`), 3310 UNIQUE KEY `key_key` (`variableKey`) 3311 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3312 3313 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_phortune` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3314 3315 USE `{$NAMESPACE}_phortune`; 3316 3317 CREATE TABLE `edge` ( 3318 `src` varbinary(64) NOT NULL, 3319 `type` int(10) unsigned NOT NULL, 3320 `dst` varbinary(64) NOT NULL, 3321 `dateCreated` int(10) unsigned NOT NULL, 3322 `seq` int(10) unsigned NOT NULL, 3323 `dataID` int(10) unsigned DEFAULT NULL, 3324 PRIMARY KEY (`src`,`type`,`dst`), 3325 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 3326 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 3327 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3328 3329 CREATE TABLE `edgedata` ( 3330 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3331 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3332 PRIMARY KEY (`id`) 3333 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3334 3335 CREATE TABLE `phortune_account` ( 3336 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3337 `phid` varbinary(64) NOT NULL, 3338 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 3339 `dateCreated` int(10) unsigned NOT NULL, 3340 `dateModified` int(10) unsigned NOT NULL, 3341 PRIMARY KEY (`id`), 3342 UNIQUE KEY `key_phid` (`phid`) 3343 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3344 3345 CREATE TABLE `phortune_accounttransaction` ( 3346 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3347 `phid` varbinary(64) NOT NULL, 3348 `authorPHID` varbinary(64) NOT NULL, 3349 `objectPHID` varbinary(64) NOT NULL, 3350 `viewPolicy` varbinary(64) NOT NULL, 3351 `editPolicy` varbinary(64) NOT NULL, 3352 `commentPHID` varbinary(64) DEFAULT NULL, 3353 `commentVersion` int(10) unsigned NOT NULL, 3354 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3355 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3356 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3357 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3358 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3359 `dateCreated` int(10) unsigned NOT NULL, 3360 `dateModified` int(10) unsigned NOT NULL, 3361 PRIMARY KEY (`id`), 3362 UNIQUE KEY `key_phid` (`phid`), 3363 KEY `key_object` (`objectPHID`) 3364 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3365 3366 CREATE TABLE `phortune_cart` ( 3367 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3368 `phid` varbinary(64) NOT NULL, 3369 `accountPHID` varbinary(64) NOT NULL, 3370 `authorPHID` varbinary(64) NOT NULL, 3371 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3372 `dateCreated` int(10) unsigned NOT NULL, 3373 `dateModified` int(10) unsigned NOT NULL, 3374 `status` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3375 `cartClass` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 3376 `merchantPHID` varbinary(64) NOT NULL, 3377 `mailKey` binary(20) NOT NULL, 3378 PRIMARY KEY (`id`), 3379 UNIQUE KEY `key_phid` (`phid`), 3380 KEY `key_account` (`accountPHID`), 3381 KEY `key_merchant` (`merchantPHID`) 3382 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3383 3384 CREATE TABLE `phortune_carttransaction` ( 3385 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3386 `phid` varbinary(64) NOT NULL, 3387 `authorPHID` varbinary(64) NOT NULL, 3388 `objectPHID` varbinary(64) NOT NULL, 3389 `viewPolicy` varbinary(64) NOT NULL, 3390 `editPolicy` varbinary(64) NOT NULL, 3391 `commentPHID` varbinary(64) DEFAULT NULL, 3392 `commentVersion` int(10) unsigned NOT NULL, 3393 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3394 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3395 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3396 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3397 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3398 `dateCreated` int(10) unsigned NOT NULL, 3399 `dateModified` int(10) unsigned NOT NULL, 3400 PRIMARY KEY (`id`), 3401 UNIQUE KEY `key_phid` (`phid`), 3402 KEY `key_object` (`objectPHID`) 3403 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3404 3405 CREATE TABLE `phortune_charge` ( 3406 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3407 `phid` varbinary(64) NOT NULL, 3408 `accountPHID` varbinary(64) NOT NULL, 3409 `authorPHID` varbinary(64) NOT NULL, 3410 `cartPHID` varbinary(64) NOT NULL, 3411 `paymentMethodPHID` varbinary(64) DEFAULT NULL, 3412 `amountAsCurrency` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3413 `status` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3414 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3415 `dateCreated` int(10) unsigned NOT NULL, 3416 `dateModified` int(10) unsigned NOT NULL, 3417 `merchantPHID` varbinary(64) NOT NULL, 3418 `providerPHID` varbinary(64) NOT NULL, 3419 `amountRefundedAsCurrency` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3420 `refundingPHID` varbinary(64) DEFAULT NULL, 3421 `refundedChargePHID` varbinary(64) DEFAULT NULL, 3422 PRIMARY KEY (`id`), 3423 UNIQUE KEY `key_phid` (`phid`), 3424 KEY `key_cart` (`cartPHID`), 3425 KEY `key_account` (`accountPHID`), 3426 KEY `key_merchant` (`merchantPHID`), 3427 KEY `key_provider` (`providerPHID`) 3428 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3429 3430 CREATE TABLE `phortune_merchant` ( 3431 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3432 `phid` varbinary(64) NOT NULL, 3433 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 3434 `viewPolicy` varbinary(64) NOT NULL, 3435 `dateCreated` int(10) unsigned NOT NULL, 3436 `dateModified` int(10) unsigned NOT NULL, 3437 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3438 PRIMARY KEY (`id`), 3439 UNIQUE KEY `key_phid` (`phid`) 3440 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3441 3442 CREATE TABLE `phortune_merchanttransaction` ( 3443 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3444 `phid` varbinary(64) NOT NULL, 3445 `authorPHID` varbinary(64) NOT NULL, 3446 `objectPHID` varbinary(64) NOT NULL, 3447 `viewPolicy` varbinary(64) NOT NULL, 3448 `editPolicy` varbinary(64) NOT NULL, 3449 `commentPHID` varbinary(64) DEFAULT NULL, 3450 `commentVersion` int(10) unsigned NOT NULL, 3451 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3452 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3453 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3454 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3455 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3456 `dateCreated` int(10) unsigned NOT NULL, 3457 `dateModified` int(10) unsigned NOT NULL, 3458 PRIMARY KEY (`id`), 3459 UNIQUE KEY `key_phid` (`phid`), 3460 KEY `key_object` (`objectPHID`) 3461 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3462 3463 CREATE TABLE `phortune_paymentmethod` ( 3464 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3465 `phid` varbinary(64) NOT NULL, 3466 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 3467 `status` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3468 `accountPHID` varbinary(64) NOT NULL, 3469 `authorPHID` varbinary(64) NOT NULL, 3470 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3471 `dateCreated` int(10) unsigned NOT NULL, 3472 `dateModified` int(10) unsigned NOT NULL, 3473 `brand` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3474 `expires` varchar(16) COLLATE {$COLLATE_TEXT} NOT NULL, 3475 `lastFourDigits` varchar(16) COLLATE {$COLLATE_TEXT} NOT NULL, 3476 `merchantPHID` varbinary(64) NOT NULL, 3477 `providerPHID` varbinary(64) NOT NULL, 3478 PRIMARY KEY (`id`), 3479 UNIQUE KEY `key_phid` (`phid`), 3480 KEY `key_account` (`accountPHID`,`status`), 3481 KEY `key_merchant` (`merchantPHID`,`accountPHID`) 3482 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3483 3484 CREATE TABLE `phortune_paymentproviderconfig` ( 3485 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3486 `phid` varbinary(64) NOT NULL, 3487 `merchantPHID` varbinary(64) NOT NULL, 3488 `providerClassKey` binary(12) NOT NULL, 3489 `providerClass` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 3490 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3491 `dateCreated` int(10) unsigned NOT NULL, 3492 `dateModified` int(10) unsigned NOT NULL, 3493 `isEnabled` tinyint(1) NOT NULL, 3494 PRIMARY KEY (`id`), 3495 UNIQUE KEY `key_phid` (`phid`), 3496 UNIQUE KEY `key_merchant` (`merchantPHID`,`providerClassKey`) 3497 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3498 3499 CREATE TABLE `phortune_paymentproviderconfigtransaction` ( 3500 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3501 `phid` varbinary(64) NOT NULL, 3502 `authorPHID` varbinary(64) NOT NULL, 3503 `objectPHID` varbinary(64) NOT NULL, 3504 `viewPolicy` varbinary(64) NOT NULL, 3505 `editPolicy` varbinary(64) NOT NULL, 3506 `commentPHID` varbinary(64) DEFAULT NULL, 3507 `commentVersion` int(10) unsigned NOT NULL, 3508 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3509 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3510 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3511 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3512 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3513 `dateCreated` int(10) unsigned NOT NULL, 3514 `dateModified` int(10) unsigned NOT NULL, 3515 PRIMARY KEY (`id`), 3516 UNIQUE KEY `key_phid` (`phid`), 3517 KEY `key_object` (`objectPHID`) 3518 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3519 3520 CREATE TABLE `phortune_product` ( 3521 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3522 `phid` varbinary(64) NOT NULL, 3523 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3524 `dateCreated` int(10) unsigned NOT NULL, 3525 `dateModified` int(10) unsigned NOT NULL, 3526 `productClassKey` binary(12) NOT NULL, 3527 `productClass` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 3528 `productRefKey` binary(12) NOT NULL, 3529 `productRef` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 3530 PRIMARY KEY (`id`), 3531 UNIQUE KEY `key_phid` (`phid`), 3532 UNIQUE KEY `key_product` (`productClassKey`,`productRefKey`) 3533 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3534 3535 CREATE TABLE `phortune_purchase` ( 3536 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3537 `phid` varbinary(64) NOT NULL, 3538 `productPHID` varbinary(64) NOT NULL, 3539 `accountPHID` varbinary(64) NOT NULL, 3540 `authorPHID` varbinary(64) NOT NULL, 3541 `cartPHID` varbinary(64) DEFAULT NULL, 3542 `basePriceAsCurrency` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3543 `quantity` int(10) unsigned NOT NULL, 3544 `status` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3545 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3546 `dateCreated` int(10) unsigned NOT NULL, 3547 `dateModified` int(10) unsigned NOT NULL, 3548 PRIMARY KEY (`id`), 3549 UNIQUE KEY `key_phid` (`phid`), 3550 KEY `key_cart` (`cartPHID`) 3551 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3552 3553 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_phrequent` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3554 3555 USE `{$NAMESPACE}_phrequent`; 3556 3557 CREATE TABLE `phrequent_usertime` ( 3558 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3559 `userPHID` varbinary(64) NOT NULL, 3560 `objectPHID` varbinary(64) DEFAULT NULL, 3561 `note` longtext COLLATE {$COLLATE_TEXT}, 3562 `dateStarted` int(10) unsigned NOT NULL, 3563 `dateEnded` int(10) unsigned DEFAULT NULL, 3564 `dateCreated` int(10) unsigned NOT NULL, 3565 `dateModified` int(10) unsigned NOT NULL, 3566 PRIMARY KEY (`id`) 3567 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3568 3569 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_diviner` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3570 3571 USE `{$NAMESPACE}_diviner`; 3572 3573 CREATE TABLE `diviner_liveatom` ( 3574 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3575 `symbolPHID` varbinary(64) NOT NULL, 3576 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3577 `atomData` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3578 PRIMARY KEY (`id`), 3579 UNIQUE KEY `symbolPHID` (`symbolPHID`) 3580 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3581 3582 CREATE TABLE `diviner_livebook` ( 3583 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3584 `phid` varbinary(64) NOT NULL, 3585 `name` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3586 `viewPolicy` varbinary(64) NOT NULL, 3587 `dateCreated` int(10) unsigned NOT NULL, 3588 `dateModified` int(10) unsigned NOT NULL, 3589 `configurationData` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3590 PRIMARY KEY (`id`), 3591 UNIQUE KEY `name` (`name`), 3592 UNIQUE KEY `phid` (`phid`) 3593 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3594 3595 CREATE TABLE `diviner_livesymbol` ( 3596 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3597 `phid` varbinary(64) NOT NULL, 3598 `bookPHID` varbinary(64) NOT NULL, 3599 `context` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3600 `type` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3601 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 3602 `atomIndex` int(10) unsigned NOT NULL, 3603 `identityHash` binary(12) NOT NULL, 3604 `graphHash` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3605 `title` longtext COLLATE {$COLLATE_TEXT}, 3606 `titleSlugHash` binary(12) DEFAULT NULL, 3607 `groupName` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3608 `summary` longtext COLLATE {$COLLATE_TEXT}, 3609 `isDocumentable` tinyint(1) NOT NULL, 3610 `nodeHash` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3611 PRIMARY KEY (`id`), 3612 UNIQUE KEY `identityHash` (`identityHash`), 3613 UNIQUE KEY `phid` (`phid`), 3614 UNIQUE KEY `graphHash` (`graphHash`), 3615 UNIQUE KEY `nodeHash` (`nodeHash`), 3616 KEY `key_slug` (`titleSlugHash`), 3617 KEY `bookPHID` (`bookPHID`,`type`,`name`(64),`context`(64),`atomIndex`), 3618 KEY `name` (`name`(64)) 3619 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3620 3621 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_auth` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3622 3623 USE `{$NAMESPACE}_auth`; 3624 3625 CREATE TABLE `auth_factorconfig` ( 3626 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3627 `phid` varbinary(64) NOT NULL, 3628 `userPHID` varbinary(64) NOT NULL, 3629 `factorKey` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3630 `factorName` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3631 `factorSecret` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3632 `properties` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3633 `dateCreated` int(10) unsigned NOT NULL, 3634 `dateModified` int(10) unsigned NOT NULL, 3635 PRIMARY KEY (`id`), 3636 UNIQUE KEY `key_phid` (`phid`), 3637 KEY `key_user` (`userPHID`) 3638 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3639 3640 CREATE TABLE `auth_providerconfig` ( 3641 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3642 `phid` varbinary(64) NOT NULL, 3643 `providerClass` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 3644 `providerType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3645 `providerDomain` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 3646 `isEnabled` tinyint(1) NOT NULL, 3647 `shouldAllowLogin` tinyint(1) NOT NULL, 3648 `shouldAllowRegistration` tinyint(1) NOT NULL, 3649 `shouldAllowLink` tinyint(1) NOT NULL, 3650 `shouldAllowUnlink` tinyint(1) NOT NULL, 3651 `shouldTrustEmails` tinyint(1) NOT NULL DEFAULT '0', 3652 `properties` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3653 `dateCreated` int(10) unsigned NOT NULL, 3654 `dateModified` int(10) unsigned NOT NULL, 3655 PRIMARY KEY (`id`), 3656 UNIQUE KEY `key_phid` (`phid`), 3657 UNIQUE KEY `key_provider` (`providerType`,`providerDomain`), 3658 KEY `key_class` (`providerClass`) 3659 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3660 3661 CREATE TABLE `auth_providerconfigtransaction` ( 3662 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3663 `phid` varbinary(64) NOT NULL, 3664 `authorPHID` varbinary(64) NOT NULL, 3665 `objectPHID` varbinary(64) NOT NULL, 3666 `viewPolicy` varbinary(64) NOT NULL, 3667 `editPolicy` varbinary(64) NOT NULL, 3668 `commentPHID` varbinary(64) DEFAULT NULL, 3669 `commentVersion` int(10) unsigned NOT NULL, 3670 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3671 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3672 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3673 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3674 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3675 `dateCreated` int(10) unsigned NOT NULL, 3676 `dateModified` int(10) unsigned NOT NULL, 3677 PRIMARY KEY (`id`), 3678 UNIQUE KEY `key_phid` (`phid`), 3679 KEY `key_object` (`objectPHID`) 3680 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3681 3682 CREATE TABLE `auth_sshkey` ( 3683 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3684 `userPHID` varbinary(64) NOT NULL, 3685 `name` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3686 `keyType` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3687 `keyBody` longtext COLLATE {$COLLATE_TEXT}, 3688 `keyHash` binary(32) NOT NULL, 3689 `keyComment` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3690 `dateCreated` int(10) unsigned NOT NULL, 3691 `dateModified` int(10) unsigned NOT NULL, 3692 PRIMARY KEY (`id`), 3693 UNIQUE KEY `keyHash` (`keyHash`), 3694 KEY `userPHID` (`userPHID`) 3695 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3696 3697 CREATE TABLE `auth_temporarytoken` ( 3698 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3699 `objectPHID` varbinary(64) NOT NULL, 3700 `tokenType` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3701 `tokenExpires` int(10) unsigned NOT NULL, 3702 `tokenCode` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3703 PRIMARY KEY (`id`), 3704 UNIQUE KEY `key_token` (`objectPHID`,`tokenType`,`tokenCode`), 3705 KEY `key_expires` (`tokenExpires`) 3706 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3707 3708 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_doorkeeper` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3709 3710 USE `{$NAMESPACE}_doorkeeper`; 3711 3712 CREATE TABLE `doorkeeper_externalobject` ( 3713 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3714 `phid` varbinary(64) NOT NULL, 3715 `objectKey` binary(12) NOT NULL, 3716 `applicationType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3717 `applicationDomain` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3718 `objectType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3719 `objectID` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 3720 `objectURI` varchar(128) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3721 `importerPHID` varbinary(64) DEFAULT NULL, 3722 `properties` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3723 `viewPolicy` varbinary(64) NOT NULL, 3724 `dateCreated` int(10) unsigned NOT NULL, 3725 `dateModified` int(10) unsigned NOT NULL, 3726 PRIMARY KEY (`id`), 3727 UNIQUE KEY `key_phid` (`phid`), 3728 UNIQUE KEY `key_object` (`objectKey`), 3729 KEY `key_full` (`applicationType`,`applicationDomain`,`objectType`,`objectID`) 3730 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3731 3732 CREATE TABLE `edge` ( 3733 `src` varbinary(64) NOT NULL, 3734 `type` int(10) unsigned NOT NULL, 3735 `dst` varbinary(64) NOT NULL, 3736 `dateCreated` int(10) unsigned NOT NULL, 3737 `seq` int(10) unsigned NOT NULL, 3738 `dataID` int(10) unsigned DEFAULT NULL, 3739 PRIMARY KEY (`src`,`type`,`dst`), 3740 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 3741 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 3742 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3743 3744 CREATE TABLE `edgedata` ( 3745 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3746 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3747 PRIMARY KEY (`id`) 3748 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3749 3750 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_legalpad` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3751 3752 USE `{$NAMESPACE}_legalpad`; 3753 3754 CREATE TABLE `edge` ( 3755 `src` varbinary(64) NOT NULL, 3756 `type` int(10) unsigned NOT NULL, 3757 `dst` varbinary(64) NOT NULL, 3758 `dateCreated` int(10) unsigned NOT NULL, 3759 `seq` int(10) unsigned NOT NULL, 3760 `dataID` int(10) unsigned DEFAULT NULL, 3761 PRIMARY KEY (`src`,`type`,`dst`), 3762 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 3763 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 3764 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3765 3766 CREATE TABLE `edgedata` ( 3767 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3768 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3769 PRIMARY KEY (`id`) 3770 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3771 3772 CREATE TABLE `legalpad_document` ( 3773 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3774 `phid` varbinary(64) NOT NULL, 3775 `title` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 3776 `contributorCount` int(10) unsigned NOT NULL DEFAULT '0', 3777 `recentContributorPHIDs` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3778 `creatorPHID` varbinary(64) NOT NULL, 3779 `versions` int(10) unsigned NOT NULL DEFAULT '0', 3780 `documentBodyPHID` varbinary(64) NOT NULL, 3781 `viewPolicy` varbinary(64) NOT NULL, 3782 `editPolicy` varbinary(64) NOT NULL, 3783 `dateCreated` int(10) unsigned NOT NULL, 3784 `dateModified` int(10) unsigned NOT NULL, 3785 `mailKey` binary(20) NOT NULL, 3786 `signatureType` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 3787 `preamble` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3788 PRIMARY KEY (`id`), 3789 UNIQUE KEY `key_phid` (`phid`), 3790 KEY `key_creator` (`creatorPHID`,`dateModified`) 3791 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3792 3793 CREATE TABLE `legalpad_documentbody` ( 3794 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3795 `phid` varbinary(64) NOT NULL, 3796 `creatorPHID` varbinary(64) NOT NULL, 3797 `documentPHID` varbinary(64) NOT NULL, 3798 `version` int(10) unsigned NOT NULL DEFAULT '0', 3799 `title` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 3800 `text` longtext COLLATE {$COLLATE_TEXT}, 3801 `dateCreated` int(10) unsigned NOT NULL, 3802 `dateModified` int(10) unsigned NOT NULL, 3803 PRIMARY KEY (`id`), 3804 UNIQUE KEY `key_phid` (`phid`), 3805 UNIQUE KEY `key_document` (`documentPHID`,`version`) 3806 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3807 3808 CREATE TABLE `legalpad_documentsignature` ( 3809 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3810 `documentPHID` varbinary(64) NOT NULL, 3811 `documentVersion` int(10) unsigned NOT NULL DEFAULT '0', 3812 `signatureType` varchar(4) COLLATE {$COLLATE_TEXT} NOT NULL, 3813 `signerPHID` varbinary(64) DEFAULT NULL, 3814 `signerName` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 3815 `signerEmail` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 3816 `signatureData` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3817 `dateCreated` int(10) unsigned NOT NULL, 3818 `dateModified` int(10) unsigned NOT NULL, 3819 `secretKey` binary(20) NOT NULL, 3820 `verified` tinyint(1) DEFAULT '0', 3821 `isExemption` tinyint(1) NOT NULL DEFAULT '0', 3822 `exemptionPHID` varbinary(64) DEFAULT NULL, 3823 PRIMARY KEY (`id`), 3824 KEY `key_signer` (`signerPHID`,`dateModified`), 3825 KEY `secretKey` (`secretKey`), 3826 KEY `key_document` (`documentPHID`,`signerPHID`,`documentVersion`) 3827 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3828 3829 CREATE TABLE `legalpad_transaction` ( 3830 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3831 `phid` varbinary(64) NOT NULL, 3832 `authorPHID` varbinary(64) NOT NULL, 3833 `objectPHID` varbinary(64) NOT NULL, 3834 `viewPolicy` varbinary(64) NOT NULL, 3835 `editPolicy` varbinary(64) NOT NULL, 3836 `commentPHID` varbinary(64) DEFAULT NULL, 3837 `commentVersion` int(10) unsigned NOT NULL, 3838 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3839 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3840 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3841 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3842 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3843 `dateCreated` int(10) unsigned NOT NULL, 3844 `dateModified` int(10) unsigned NOT NULL, 3845 PRIMARY KEY (`id`), 3846 UNIQUE KEY `key_phid` (`phid`), 3847 KEY `key_object` (`objectPHID`) 3848 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3849 3850 CREATE TABLE `legalpad_transaction_comment` ( 3851 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3852 `phid` varbinary(64) NOT NULL, 3853 `transactionPHID` varbinary(64) DEFAULT NULL, 3854 `authorPHID` varbinary(64) NOT NULL, 3855 `viewPolicy` varbinary(64) NOT NULL, 3856 `editPolicy` varbinary(64) NOT NULL, 3857 `commentVersion` int(10) unsigned NOT NULL, 3858 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3859 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3860 `isDeleted` tinyint(1) NOT NULL, 3861 `dateCreated` int(10) unsigned NOT NULL, 3862 `dateModified` int(10) unsigned NOT NULL, 3863 `documentID` int(10) unsigned DEFAULT NULL, 3864 `lineNumber` int(10) unsigned NOT NULL, 3865 `lineLength` int(10) unsigned NOT NULL, 3866 `fixedState` varchar(12) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3867 `hasReplies` tinyint(1) NOT NULL, 3868 `replyToCommentPHID` varbinary(64) DEFAULT NULL, 3869 PRIMARY KEY (`id`), 3870 UNIQUE KEY `key_phid` (`phid`), 3871 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`), 3872 UNIQUE KEY `key_draft` (`authorPHID`,`documentID`,`transactionPHID`) 3873 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3874 3875 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_policy` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3876 3877 USE `{$NAMESPACE}_policy`; 3878 3879 CREATE TABLE `policy` ( 3880 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3881 `phid` varbinary(64) NOT NULL, 3882 `rules` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3883 `defaultAction` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3884 `dateCreated` int(10) unsigned NOT NULL, 3885 `dateModified` int(10) unsigned NOT NULL, 3886 PRIMARY KEY (`id`), 3887 UNIQUE KEY `phid` (`phid`) 3888 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3889 3890 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_nuance` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 3891 3892 USE `{$NAMESPACE}_nuance`; 3893 3894 CREATE TABLE `edge` ( 3895 `src` varbinary(64) NOT NULL, 3896 `type` int(10) unsigned NOT NULL, 3897 `dst` varbinary(64) NOT NULL, 3898 `dateCreated` int(10) unsigned NOT NULL, 3899 `seq` int(10) unsigned NOT NULL, 3900 `dataID` int(10) unsigned DEFAULT NULL, 3901 PRIMARY KEY (`src`,`type`,`dst`), 3902 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 3903 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 3904 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3905 3906 CREATE TABLE `edgedata` ( 3907 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3908 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3909 PRIMARY KEY (`id`) 3910 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3911 3912 CREATE TABLE `nuance_item` ( 3913 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3914 `phid` varbinary(64) NOT NULL, 3915 `ownerPHID` varbinary(64) DEFAULT NULL, 3916 `requestorPHID` varbinary(64) NOT NULL, 3917 `sourcePHID` varbinary(64) NOT NULL, 3918 `sourceLabel` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3919 `status` int(10) unsigned NOT NULL, 3920 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3921 `mailKey` binary(20) NOT NULL, 3922 `dateCreated` int(10) unsigned NOT NULL, 3923 `dateModified` int(10) unsigned NOT NULL, 3924 `dateNuanced` int(10) unsigned NOT NULL, 3925 PRIMARY KEY (`id`), 3926 UNIQUE KEY `key_phid` (`phid`), 3927 KEY `key_source` (`sourcePHID`,`status`,`dateNuanced`,`id`), 3928 KEY `key_owner` (`ownerPHID`,`status`,`dateNuanced`,`id`), 3929 KEY `key_contacter` (`requestorPHID`,`status`,`dateNuanced`,`id`) 3930 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3931 3932 CREATE TABLE `nuance_itemtransaction` ( 3933 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3934 `phid` varbinary(64) NOT NULL, 3935 `authorPHID` varbinary(64) NOT NULL, 3936 `objectPHID` varbinary(64) NOT NULL, 3937 `viewPolicy` varbinary(64) NOT NULL, 3938 `editPolicy` varbinary(64) NOT NULL, 3939 `commentPHID` varbinary(64) DEFAULT NULL, 3940 `commentVersion` int(10) unsigned NOT NULL, 3941 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 3942 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3943 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3944 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3945 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3946 `dateCreated` int(10) unsigned NOT NULL, 3947 `dateModified` int(10) unsigned NOT NULL, 3948 PRIMARY KEY (`id`), 3949 UNIQUE KEY `key_phid` (`phid`), 3950 KEY `key_object` (`objectPHID`) 3951 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3952 3953 CREATE TABLE `nuance_itemtransaction_comment` ( 3954 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3955 `phid` varbinary(64) NOT NULL, 3956 `transactionPHID` varbinary(64) DEFAULT NULL, 3957 `authorPHID` varbinary(64) NOT NULL, 3958 `viewPolicy` varbinary(64) NOT NULL, 3959 `editPolicy` varbinary(64) NOT NULL, 3960 `commentVersion` int(10) unsigned NOT NULL, 3961 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3962 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 3963 `isDeleted` tinyint(1) NOT NULL, 3964 `dateCreated` int(10) unsigned NOT NULL, 3965 `dateModified` int(10) unsigned NOT NULL, 3966 PRIMARY KEY (`id`), 3967 UNIQUE KEY `key_phid` (`phid`), 3968 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 3969 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3970 3971 CREATE TABLE `nuance_queue` ( 3972 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3973 `phid` varbinary(64) NOT NULL, 3974 `name` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 3975 `mailKey` binary(20) NOT NULL, 3976 `viewPolicy` varbinary(64) NOT NULL, 3977 `editPolicy` varbinary(64) NOT NULL, 3978 `dateCreated` int(10) unsigned NOT NULL, 3979 `dateModified` int(10) unsigned NOT NULL, 3980 PRIMARY KEY (`id`), 3981 UNIQUE KEY `key_phid` (`phid`) 3982 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3983 3984 CREATE TABLE `nuance_queueitem` ( 3985 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3986 `queuePHID` varbinary(64) NOT NULL, 3987 `itemPHID` varbinary(64) NOT NULL, 3988 `itemStatus` int(10) unsigned NOT NULL, 3989 `itemDateNuanced` int(10) unsigned NOT NULL, 3990 `dateCreated` int(10) unsigned NOT NULL, 3991 `dateModified` int(10) unsigned NOT NULL, 3992 PRIMARY KEY (`id`), 3993 UNIQUE KEY `key_one_per_queue` (`itemPHID`,`queuePHID`), 3994 KEY `key_queue` (`queuePHID`,`itemStatus`,`itemDateNuanced`,`id`) 3995 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 3996 3997 CREATE TABLE `nuance_queuetransaction` ( 3998 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3999 `phid` varbinary(64) NOT NULL, 4000 `authorPHID` varbinary(64) NOT NULL, 4001 `objectPHID` varbinary(64) NOT NULL, 4002 `viewPolicy` varbinary(64) NOT NULL, 4003 `editPolicy` varbinary(64) NOT NULL, 4004 `commentPHID` varbinary(64) DEFAULT NULL, 4005 `commentVersion` int(10) unsigned NOT NULL, 4006 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4007 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4008 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4009 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4010 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4011 `dateCreated` int(10) unsigned NOT NULL, 4012 `dateModified` int(10) unsigned NOT NULL, 4013 PRIMARY KEY (`id`), 4014 UNIQUE KEY `key_phid` (`phid`), 4015 KEY `key_object` (`objectPHID`) 4016 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4017 4018 CREATE TABLE `nuance_queuetransaction_comment` ( 4019 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4020 `phid` varbinary(64) NOT NULL, 4021 `transactionPHID` varbinary(64) DEFAULT NULL, 4022 `authorPHID` varbinary(64) NOT NULL, 4023 `viewPolicy` varbinary(64) NOT NULL, 4024 `editPolicy` varbinary(64) NOT NULL, 4025 `commentVersion` int(10) unsigned NOT NULL, 4026 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4027 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4028 `isDeleted` tinyint(1) NOT NULL, 4029 `dateCreated` int(10) unsigned NOT NULL, 4030 `dateModified` int(10) unsigned NOT NULL, 4031 PRIMARY KEY (`id`), 4032 UNIQUE KEY `key_phid` (`phid`), 4033 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 4034 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4035 4036 CREATE TABLE `nuance_requestor` ( 4037 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4038 `phid` varbinary(64) NOT NULL, 4039 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4040 `dateCreated` int(10) unsigned NOT NULL, 4041 `dateModified` int(10) unsigned NOT NULL, 4042 PRIMARY KEY (`id`), 4043 UNIQUE KEY `key_phid` (`phid`) 4044 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4045 4046 CREATE TABLE `nuance_requestorsource` ( 4047 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4048 `requestorPHID` varbinary(64) NOT NULL, 4049 `sourcePHID` varbinary(64) NOT NULL, 4050 `sourceKey` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 4051 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4052 `dateCreated` int(10) unsigned NOT NULL, 4053 `dateModified` int(10) unsigned NOT NULL, 4054 PRIMARY KEY (`id`), 4055 UNIQUE KEY `key_source_key` (`sourcePHID`,`sourceKey`), 4056 KEY `key_requestor` (`requestorPHID`,`id`), 4057 KEY `key_source` (`sourcePHID`,`id`) 4058 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4059 4060 CREATE TABLE `nuance_requestortransaction` ( 4061 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4062 `phid` varbinary(64) NOT NULL, 4063 `authorPHID` varbinary(64) NOT NULL, 4064 `objectPHID` varbinary(64) NOT NULL, 4065 `viewPolicy` varbinary(64) NOT NULL, 4066 `editPolicy` varbinary(64) NOT NULL, 4067 `commentPHID` varbinary(64) DEFAULT NULL, 4068 `commentVersion` int(10) unsigned NOT NULL, 4069 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4070 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4071 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4072 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4073 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4074 `dateCreated` int(10) unsigned NOT NULL, 4075 `dateModified` int(10) unsigned NOT NULL, 4076 PRIMARY KEY (`id`), 4077 UNIQUE KEY `key_phid` (`phid`), 4078 KEY `key_object` (`objectPHID`) 4079 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4080 4081 CREATE TABLE `nuance_requestortransaction_comment` ( 4082 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4083 `phid` varbinary(64) NOT NULL, 4084 `transactionPHID` varbinary(64) DEFAULT NULL, 4085 `authorPHID` varbinary(64) NOT NULL, 4086 `viewPolicy` varbinary(64) NOT NULL, 4087 `editPolicy` varbinary(64) NOT NULL, 4088 `commentVersion` int(10) unsigned NOT NULL, 4089 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4090 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4091 `isDeleted` tinyint(1) NOT NULL, 4092 `dateCreated` int(10) unsigned NOT NULL, 4093 `dateModified` int(10) unsigned NOT NULL, 4094 PRIMARY KEY (`id`), 4095 UNIQUE KEY `key_phid` (`phid`), 4096 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 4097 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4098 4099 CREATE TABLE `nuance_source` ( 4100 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4101 `phid` varbinary(64) NOT NULL, 4102 `name` varchar(255) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 4103 `type` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4104 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4105 `mailKey` binary(20) NOT NULL, 4106 `viewPolicy` varbinary(64) NOT NULL, 4107 `editPolicy` varbinary(64) NOT NULL, 4108 `dateCreated` int(10) unsigned NOT NULL, 4109 `dateModified` int(10) unsigned NOT NULL, 4110 PRIMARY KEY (`id`), 4111 UNIQUE KEY `key_phid` (`phid`), 4112 KEY `key_type` (`type`,`dateModified`) 4113 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4114 4115 CREATE TABLE `nuance_sourcetransaction` ( 4116 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4117 `phid` varbinary(64) NOT NULL, 4118 `authorPHID` varbinary(64) NOT NULL, 4119 `objectPHID` varbinary(64) NOT NULL, 4120 `viewPolicy` varbinary(64) NOT NULL, 4121 `editPolicy` varbinary(64) NOT NULL, 4122 `commentPHID` varbinary(64) DEFAULT NULL, 4123 `commentVersion` int(10) unsigned NOT NULL, 4124 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4125 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4126 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4127 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4128 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4129 `dateCreated` int(10) unsigned NOT NULL, 4130 `dateModified` int(10) unsigned NOT NULL, 4131 PRIMARY KEY (`id`), 4132 UNIQUE KEY `key_phid` (`phid`), 4133 KEY `key_object` (`objectPHID`) 4134 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4135 4136 CREATE TABLE `nuance_sourcetransaction_comment` ( 4137 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4138 `phid` varbinary(64) NOT NULL, 4139 `transactionPHID` varbinary(64) DEFAULT NULL, 4140 `authorPHID` varbinary(64) NOT NULL, 4141 `viewPolicy` varbinary(64) NOT NULL, 4142 `editPolicy` varbinary(64) NOT NULL, 4143 `commentVersion` int(10) unsigned NOT NULL, 4144 `content` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4145 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4146 `isDeleted` tinyint(1) NOT NULL, 4147 `dateCreated` int(10) unsigned NOT NULL, 4148 `dateModified` int(10) unsigned NOT NULL, 4149 PRIMARY KEY (`id`), 4150 UNIQUE KEY `key_phid` (`phid`), 4151 UNIQUE KEY `key_version` (`transactionPHID`,`commentVersion`) 4152 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4153 4154 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_passphrase` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 4155 4156 USE `{$NAMESPACE}_passphrase`; 4157 4158 CREATE TABLE `edge` ( 4159 `src` varbinary(64) NOT NULL, 4160 `type` int(10) unsigned NOT NULL, 4161 `dst` varbinary(64) NOT NULL, 4162 `dateCreated` int(10) unsigned NOT NULL, 4163 `seq` int(10) unsigned NOT NULL, 4164 `dataID` int(10) unsigned DEFAULT NULL, 4165 PRIMARY KEY (`src`,`type`,`dst`), 4166 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 4167 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 4168 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4169 4170 CREATE TABLE `edgedata` ( 4171 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4172 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4173 PRIMARY KEY (`id`) 4174 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4175 4176 CREATE TABLE `passphrase_credential` ( 4177 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4178 `phid` varbinary(64) NOT NULL, 4179 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 4180 `credentialType` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 4181 `providesType` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 4182 `viewPolicy` varbinary(64) NOT NULL, 4183 `editPolicy` varbinary(64) NOT NULL, 4184 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4185 `username` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 4186 `secretID` int(10) unsigned DEFAULT NULL, 4187 `isDestroyed` tinyint(1) NOT NULL, 4188 `dateCreated` int(10) unsigned NOT NULL, 4189 `dateModified` int(10) unsigned NOT NULL, 4190 `isLocked` tinyint(1) NOT NULL, 4191 `allowConduit` tinyint(1) NOT NULL DEFAULT '0', 4192 PRIMARY KEY (`id`), 4193 UNIQUE KEY `key_phid` (`phid`), 4194 UNIQUE KEY `key_secret` (`secretID`), 4195 KEY `key_type` (`credentialType`), 4196 KEY `key_provides` (`providesType`) 4197 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4198 4199 CREATE TABLE `passphrase_credentialtransaction` ( 4200 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4201 `phid` varbinary(64) NOT NULL, 4202 `authorPHID` varbinary(64) NOT NULL, 4203 `objectPHID` varbinary(64) NOT NULL, 4204 `viewPolicy` varbinary(64) NOT NULL, 4205 `editPolicy` varbinary(64) NOT NULL, 4206 `commentPHID` varbinary(64) DEFAULT NULL, 4207 `commentVersion` int(10) unsigned NOT NULL, 4208 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4209 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4210 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4211 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4212 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4213 `dateCreated` int(10) unsigned NOT NULL, 4214 `dateModified` int(10) unsigned NOT NULL, 4215 PRIMARY KEY (`id`), 4216 UNIQUE KEY `key_phid` (`phid`), 4217 KEY `key_object` (`objectPHID`) 4218 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4219 4220 CREATE TABLE `passphrase_secret` ( 4221 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4222 `secretData` longblob NOT NULL, 4223 PRIMARY KEY (`id`) 4224 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4225 4226 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_phragment` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 4227 4228 USE `{$NAMESPACE}_phragment`; 4229 4230 CREATE TABLE `edge` ( 4231 `src` varbinary(64) NOT NULL, 4232 `type` int(10) unsigned NOT NULL, 4233 `dst` varbinary(64) NOT NULL, 4234 `dateCreated` int(10) unsigned NOT NULL, 4235 `seq` int(10) unsigned NOT NULL, 4236 `dataID` int(10) unsigned DEFAULT NULL, 4237 PRIMARY KEY (`src`,`type`,`dst`), 4238 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 4239 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 4240 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4241 4242 CREATE TABLE `edgedata` ( 4243 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4244 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4245 PRIMARY KEY (`id`) 4246 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4247 4248 CREATE TABLE `phragment_fragment` ( 4249 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4250 `phid` varbinary(64) NOT NULL, 4251 `path` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 4252 `depth` int(10) unsigned NOT NULL, 4253 `latestVersionPHID` varbinary(64) DEFAULT NULL, 4254 `viewPolicy` varbinary(64) NOT NULL, 4255 `editPolicy` varbinary(64) NOT NULL, 4256 `dateCreated` int(10) unsigned NOT NULL, 4257 `dateModified` int(10) unsigned NOT NULL, 4258 PRIMARY KEY (`id`), 4259 UNIQUE KEY `key_phid` (`phid`), 4260 UNIQUE KEY `key_path` (`path`) 4261 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4262 4263 CREATE TABLE `phragment_fragmentversion` ( 4264 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4265 `phid` varbinary(64) NOT NULL, 4266 `sequence` int(10) unsigned NOT NULL, 4267 `fragmentPHID` varbinary(64) NOT NULL, 4268 `filePHID` varbinary(64) DEFAULT NULL, 4269 `dateCreated` int(10) unsigned NOT NULL, 4270 `dateModified` int(10) unsigned NOT NULL, 4271 PRIMARY KEY (`id`), 4272 UNIQUE KEY `key_version` (`fragmentPHID`,`sequence`), 4273 UNIQUE KEY `key_phid` (`phid`) 4274 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4275 4276 CREATE TABLE `phragment_snapshot` ( 4277 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4278 `phid` varbinary(64) NOT NULL, 4279 `primaryFragmentPHID` varbinary(64) NOT NULL, 4280 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 4281 `dateCreated` int(10) unsigned NOT NULL, 4282 `dateModified` int(10) unsigned NOT NULL, 4283 PRIMARY KEY (`id`), 4284 UNIQUE KEY `key_phid` (`phid`), 4285 UNIQUE KEY `key_name` (`primaryFragmentPHID`,`name`) 4286 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4287 4288 CREATE TABLE `phragment_snapshotchild` ( 4289 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4290 `snapshotPHID` varbinary(64) NOT NULL, 4291 `fragmentPHID` varbinary(64) NOT NULL, 4292 `fragmentVersionPHID` varbinary(64) DEFAULT NULL, 4293 `dateCreated` int(10) unsigned NOT NULL, 4294 `dateModified` int(10) unsigned NOT NULL, 4295 PRIMARY KEY (`id`), 4296 UNIQUE KEY `key_child` (`snapshotPHID`,`fragmentPHID`,`fragmentVersionPHID`) 4297 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4298 4299 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_dashboard` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 4300 4301 USE `{$NAMESPACE}_dashboard`; 4302 4303 CREATE TABLE `dashboard` ( 4304 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4305 `phid` varbinary(64) NOT NULL, 4306 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 4307 `layoutConfig` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4308 `viewPolicy` varbinary(64) NOT NULL, 4309 `editPolicy` varbinary(64) NOT NULL, 4310 `dateCreated` int(10) unsigned NOT NULL, 4311 `dateModified` int(10) unsigned NOT NULL, 4312 PRIMARY KEY (`id`), 4313 UNIQUE KEY `key_phid` (`phid`) 4314 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4315 4316 CREATE TABLE `dashboard_install` ( 4317 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4318 `installerPHID` varbinary(64) NOT NULL, 4319 `objectPHID` varbinary(64) NOT NULL, 4320 `applicationClass` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 4321 `dashboardPHID` varbinary(64) NOT NULL, 4322 `dateCreated` int(10) unsigned NOT NULL, 4323 `dateModified` int(10) unsigned NOT NULL, 4324 PRIMARY KEY (`id`), 4325 UNIQUE KEY `objectPHID` (`objectPHID`,`applicationClass`) 4326 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4327 4328 CREATE TABLE `dashboard_panel` ( 4329 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4330 `phid` varbinary(64) NOT NULL, 4331 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 4332 `panelType` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 4333 `viewPolicy` varbinary(64) NOT NULL, 4334 `editPolicy` varbinary(64) NOT NULL, 4335 `isArchived` tinyint(1) NOT NULL DEFAULT '0', 4336 `properties` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4337 `dateCreated` int(10) unsigned NOT NULL, 4338 `dateModified` int(10) unsigned NOT NULL, 4339 PRIMARY KEY (`id`), 4340 UNIQUE KEY `key_phid` (`phid`) 4341 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4342 4343 CREATE TABLE `dashboard_paneltransaction` ( 4344 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4345 `phid` varbinary(64) NOT NULL, 4346 `authorPHID` varbinary(64) NOT NULL, 4347 `objectPHID` varbinary(64) NOT NULL, 4348 `viewPolicy` varbinary(64) NOT NULL, 4349 `editPolicy` varbinary(64) NOT NULL, 4350 `commentPHID` varbinary(64) DEFAULT NULL, 4351 `commentVersion` int(10) unsigned NOT NULL, 4352 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4353 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4354 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4355 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4356 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4357 `dateCreated` int(10) unsigned NOT NULL, 4358 `dateModified` int(10) unsigned NOT NULL, 4359 PRIMARY KEY (`id`), 4360 UNIQUE KEY `key_phid` (`phid`), 4361 KEY `key_object` (`objectPHID`) 4362 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4363 4364 CREATE TABLE `dashboard_transaction` ( 4365 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4366 `phid` varbinary(64) NOT NULL, 4367 `authorPHID` varbinary(64) NOT NULL, 4368 `objectPHID` varbinary(64) NOT NULL, 4369 `viewPolicy` varbinary(64) NOT NULL, 4370 `editPolicy` varbinary(64) NOT NULL, 4371 `commentPHID` varbinary(64) DEFAULT NULL, 4372 `commentVersion` int(10) unsigned NOT NULL, 4373 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4374 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4375 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4376 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4377 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4378 `dateCreated` int(10) unsigned NOT NULL, 4379 `dateModified` int(10) unsigned NOT NULL, 4380 PRIMARY KEY (`id`), 4381 UNIQUE KEY `key_phid` (`phid`), 4382 KEY `key_object` (`objectPHID`) 4383 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4384 4385 CREATE TABLE `edge` ( 4386 `src` varbinary(64) NOT NULL, 4387 `type` int(10) unsigned NOT NULL, 4388 `dst` varbinary(64) NOT NULL, 4389 `dateCreated` int(10) unsigned NOT NULL, 4390 `seq` int(10) unsigned NOT NULL, 4391 `dataID` int(10) unsigned DEFAULT NULL, 4392 PRIMARY KEY (`src`,`type`,`dst`), 4393 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 4394 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 4395 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4396 4397 CREATE TABLE `edgedata` ( 4398 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4399 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4400 PRIMARY KEY (`id`) 4401 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4402 4403 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_system` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 4404 4405 USE `{$NAMESPACE}_system`; 4406 4407 CREATE TABLE `system_actionlog` ( 4408 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4409 `actorHash` binary(12) NOT NULL, 4410 `actorIdentity` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 4411 `action` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4412 `score` double NOT NULL, 4413 `epoch` int(10) unsigned NOT NULL, 4414 PRIMARY KEY (`id`), 4415 KEY `key_epoch` (`epoch`), 4416 KEY `key_action` (`actorHash`,`action`,`epoch`) 4417 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4418 4419 CREATE TABLE `system_destructionlog` ( 4420 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4421 `objectClass` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 4422 `rootLogID` int(10) unsigned DEFAULT NULL, 4423 `objectPHID` varbinary(64) DEFAULT NULL, 4424 `objectMonogram` varchar(64) COLLATE {$COLLATE_TEXT} DEFAULT NULL, 4425 `epoch` int(10) unsigned NOT NULL, 4426 PRIMARY KEY (`id`), 4427 KEY `key_epoch` (`epoch`) 4428 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4429 4430 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_fund` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 4431 4432 USE `{$NAMESPACE}_fund`; 4433 4434 CREATE TABLE `edge` ( 4435 `src` varbinary(64) NOT NULL, 4436 `type` int(10) unsigned NOT NULL, 4437 `dst` varbinary(64) NOT NULL, 4438 `dateCreated` int(10) unsigned NOT NULL, 4439 `seq` int(10) unsigned NOT NULL, 4440 `dataID` int(10) unsigned DEFAULT NULL, 4441 PRIMARY KEY (`src`,`type`,`dst`), 4442 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 4443 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 4444 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4445 4446 CREATE TABLE `edgedata` ( 4447 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4448 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4449 PRIMARY KEY (`id`) 4450 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4451 4452 CREATE TABLE `fund_backer` ( 4453 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4454 `phid` varbinary(64) NOT NULL, 4455 `initiativePHID` varbinary(64) NOT NULL, 4456 `backerPHID` varbinary(64) NOT NULL, 4457 `status` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4458 `amountAsCurrency` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 4459 `properties` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4460 `dateCreated` int(10) unsigned NOT NULL, 4461 `dateModified` int(10) unsigned NOT NULL, 4462 PRIMARY KEY (`id`), 4463 UNIQUE KEY `key_phid` (`phid`), 4464 KEY `key_initiative` (`initiativePHID`), 4465 KEY `key_backer` (`backerPHID`) 4466 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4467 4468 CREATE TABLE `fund_backertransaction` ( 4469 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4470 `phid` varbinary(64) NOT NULL, 4471 `authorPHID` varbinary(64) NOT NULL, 4472 `objectPHID` varbinary(64) NOT NULL, 4473 `viewPolicy` varbinary(64) NOT NULL, 4474 `editPolicy` varbinary(64) NOT NULL, 4475 `commentPHID` varbinary(64) DEFAULT NULL, 4476 `commentVersion` int(10) unsigned NOT NULL, 4477 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4478 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4479 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4480 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4481 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4482 `dateCreated` int(10) unsigned NOT NULL, 4483 `dateModified` int(10) unsigned NOT NULL, 4484 PRIMARY KEY (`id`), 4485 UNIQUE KEY `key_phid` (`phid`), 4486 KEY `key_object` (`objectPHID`) 4487 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4488 4489 CREATE TABLE `fund_initiative` ( 4490 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4491 `phid` varbinary(64) NOT NULL, 4492 `name` varchar(255) COLLATE {$COLLATE_TEXT} NOT NULL, 4493 `ownerPHID` varbinary(64) NOT NULL, 4494 `description` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4495 `viewPolicy` varbinary(64) NOT NULL, 4496 `editPolicy` varbinary(64) NOT NULL, 4497 `status` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4498 `dateCreated` int(10) unsigned NOT NULL, 4499 `dateModified` int(10) unsigned NOT NULL, 4500 `merchantPHID` varbinary(64) DEFAULT NULL, 4501 `risks` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4502 `totalAsCurrency` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 4503 `mailKey` binary(20) NOT NULL, 4504 PRIMARY KEY (`id`), 4505 UNIQUE KEY `key_phid` (`phid`), 4506 KEY `key_status` (`status`), 4507 KEY `key_owner` (`ownerPHID`) 4508 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4509 4510 CREATE TABLE `fund_initiativetransaction` ( 4511 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4512 `phid` varbinary(64) NOT NULL, 4513 `authorPHID` varbinary(64) NOT NULL, 4514 `objectPHID` varbinary(64) NOT NULL, 4515 `viewPolicy` varbinary(64) NOT NULL, 4516 `editPolicy` varbinary(64) NOT NULL, 4517 `commentPHID` varbinary(64) DEFAULT NULL, 4518 `commentVersion` int(10) unsigned NOT NULL, 4519 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4520 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4521 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4522 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4523 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4524 `dateCreated` int(10) unsigned NOT NULL, 4525 `dateModified` int(10) unsigned NOT NULL, 4526 PRIMARY KEY (`id`), 4527 UNIQUE KEY `key_phid` (`phid`), 4528 KEY `key_object` (`objectPHID`) 4529 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4530 4531 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `{$NAMESPACE}_almanac` /*!40100 DEFAULT CHARACTER SET {$CHARSET} COLLATE {$COLLATE_TEXT} */; 4532 4533 USE `{$NAMESPACE}_almanac`; 4534 4535 CREATE TABLE `almanac_binding` ( 4536 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4537 `phid` varbinary(64) NOT NULL, 4538 `servicePHID` varbinary(64) NOT NULL, 4539 `devicePHID` varbinary(64) NOT NULL, 4540 `interfacePHID` varbinary(64) NOT NULL, 4541 `mailKey` binary(20) NOT NULL, 4542 `dateCreated` int(10) unsigned NOT NULL, 4543 `dateModified` int(10) unsigned NOT NULL, 4544 PRIMARY KEY (`id`), 4545 UNIQUE KEY `key_phid` (`phid`), 4546 UNIQUE KEY `key_service` (`servicePHID`,`interfacePHID`), 4547 KEY `key_device` (`devicePHID`), 4548 KEY `key_interface` (`interfacePHID`) 4549 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4550 4551 CREATE TABLE `almanac_bindingtransaction` ( 4552 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4553 `phid` varbinary(64) NOT NULL, 4554 `authorPHID` varbinary(64) NOT NULL, 4555 `objectPHID` varbinary(64) NOT NULL, 4556 `viewPolicy` varbinary(64) NOT NULL, 4557 `editPolicy` varbinary(64) NOT NULL, 4558 `commentPHID` varbinary(64) DEFAULT NULL, 4559 `commentVersion` int(10) unsigned NOT NULL, 4560 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4561 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4562 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4563 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4564 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4565 `dateCreated` int(10) unsigned NOT NULL, 4566 `dateModified` int(10) unsigned NOT NULL, 4567 PRIMARY KEY (`id`), 4568 UNIQUE KEY `key_phid` (`phid`), 4569 KEY `key_object` (`objectPHID`) 4570 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4571 4572 CREATE TABLE `almanac_device` ( 4573 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4574 `phid` varbinary(64) NOT NULL, 4575 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 4576 `dateCreated` int(10) unsigned NOT NULL, 4577 `dateModified` int(10) unsigned NOT NULL, 4578 `nameIndex` binary(12) NOT NULL, 4579 `mailKey` binary(20) NOT NULL, 4580 `viewPolicy` varbinary(64) NOT NULL, 4581 `editPolicy` varbinary(64) NOT NULL, 4582 PRIMARY KEY (`id`), 4583 UNIQUE KEY `key_phid` (`phid`), 4584 UNIQUE KEY `key_name` (`nameIndex`), 4585 KEY `key_nametext` (`name`) 4586 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4587 4588 CREATE TABLE `almanac_devicetransaction` ( 4589 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4590 `phid` varbinary(64) NOT NULL, 4591 `authorPHID` varbinary(64) NOT NULL, 4592 `objectPHID` varbinary(64) NOT NULL, 4593 `viewPolicy` varbinary(64) NOT NULL, 4594 `editPolicy` varbinary(64) NOT NULL, 4595 `commentPHID` varbinary(64) DEFAULT NULL, 4596 `commentVersion` int(10) unsigned NOT NULL, 4597 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4598 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4599 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4600 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4601 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4602 `dateCreated` int(10) unsigned NOT NULL, 4603 `dateModified` int(10) unsigned NOT NULL, 4604 PRIMARY KEY (`id`), 4605 UNIQUE KEY `key_phid` (`phid`), 4606 KEY `key_object` (`objectPHID`) 4607 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4608 4609 CREATE TABLE `almanac_interface` ( 4610 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4611 `phid` varbinary(64) NOT NULL, 4612 `devicePHID` varbinary(64) NOT NULL, 4613 `networkPHID` varbinary(64) NOT NULL, 4614 `address` varchar(64) COLLATE {$COLLATE_TEXT} NOT NULL, 4615 `port` int(10) unsigned NOT NULL, 4616 `dateCreated` int(10) unsigned NOT NULL, 4617 `dateModified` int(10) unsigned NOT NULL, 4618 PRIMARY KEY (`id`), 4619 UNIQUE KEY `key_phid` (`phid`), 4620 KEY `key_location` (`networkPHID`,`address`,`port`), 4621 KEY `key_device` (`devicePHID`) 4622 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4623 4624 CREATE TABLE `almanac_network` ( 4625 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4626 `phid` varbinary(64) NOT NULL, 4627 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 4628 `mailKey` binary(20) NOT NULL, 4629 `viewPolicy` varbinary(64) NOT NULL, 4630 `editPolicy` varbinary(64) NOT NULL, 4631 `dateCreated` int(10) unsigned NOT NULL, 4632 `dateModified` int(10) unsigned NOT NULL, 4633 PRIMARY KEY (`id`), 4634 UNIQUE KEY `key_phid` (`phid`) 4635 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4636 4637 CREATE TABLE `almanac_networktransaction` ( 4638 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4639 `phid` varbinary(64) NOT NULL, 4640 `authorPHID` varbinary(64) NOT NULL, 4641 `objectPHID` varbinary(64) NOT NULL, 4642 `viewPolicy` varbinary(64) NOT NULL, 4643 `editPolicy` varbinary(64) NOT NULL, 4644 `commentPHID` varbinary(64) DEFAULT NULL, 4645 `commentVersion` int(10) unsigned NOT NULL, 4646 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4647 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4648 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4649 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4650 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4651 `dateCreated` int(10) unsigned NOT NULL, 4652 `dateModified` int(10) unsigned NOT NULL, 4653 PRIMARY KEY (`id`), 4654 UNIQUE KEY `key_phid` (`phid`), 4655 KEY `key_object` (`objectPHID`) 4656 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4657 4658 CREATE TABLE `almanac_property` ( 4659 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4660 `objectPHID` varbinary(64) NOT NULL, 4661 `fieldIndex` binary(12) NOT NULL, 4662 `fieldName` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 4663 `fieldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4664 PRIMARY KEY (`id`), 4665 UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`) 4666 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4667 4668 CREATE TABLE `almanac_service` ( 4669 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4670 `phid` varbinary(64) NOT NULL, 4671 `name` varchar(128) COLLATE {$COLLATE_TEXT} NOT NULL, 4672 `nameIndex` binary(12) NOT NULL, 4673 `mailKey` binary(20) NOT NULL, 4674 `viewPolicy` varbinary(64) NOT NULL, 4675 `editPolicy` varbinary(64) NOT NULL, 4676 `dateCreated` int(10) unsigned NOT NULL, 4677 `dateModified` int(10) unsigned NOT NULL, 4678 PRIMARY KEY (`id`), 4679 UNIQUE KEY `key_phid` (`phid`), 4680 UNIQUE KEY `key_name` (`nameIndex`), 4681 KEY `key_nametext` (`name`) 4682 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4683 4684 CREATE TABLE `almanac_servicetransaction` ( 4685 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4686 `phid` varbinary(64) NOT NULL, 4687 `authorPHID` varbinary(64) NOT NULL, 4688 `objectPHID` varbinary(64) NOT NULL, 4689 `viewPolicy` varbinary(64) NOT NULL, 4690 `editPolicy` varbinary(64) NOT NULL, 4691 `commentPHID` varbinary(64) DEFAULT NULL, 4692 `commentVersion` int(10) unsigned NOT NULL, 4693 `transactionType` varchar(32) COLLATE {$COLLATE_TEXT} NOT NULL, 4694 `oldValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4695 `newValue` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4696 `contentSource` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4697 `metadata` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4698 `dateCreated` int(10) unsigned NOT NULL, 4699 `dateModified` int(10) unsigned NOT NULL, 4700 PRIMARY KEY (`id`), 4701 UNIQUE KEY `key_phid` (`phid`), 4702 KEY `key_object` (`objectPHID`) 4703 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4704 4705 CREATE TABLE `edge` ( 4706 `src` varbinary(64) NOT NULL, 4707 `type` int(10) unsigned NOT NULL, 4708 `dst` varbinary(64) NOT NULL, 4709 `dateCreated` int(10) unsigned NOT NULL, 4710 `seq` int(10) unsigned NOT NULL, 4711 `dataID` int(10) unsigned DEFAULT NULL, 4712 PRIMARY KEY (`src`,`type`,`dst`), 4713 UNIQUE KEY `key_dst` (`dst`,`type`,`src`), 4714 KEY `src` (`src`,`type`,`dateCreated`,`seq`) 4715 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT}; 4716 4717 CREATE TABLE `edgedata` ( 4718 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 4719 `data` longtext COLLATE {$COLLATE_TEXT} NOT NULL, 4720 PRIMARY KEY (`id`) 4721 ) ENGINE=InnoDB DEFAULT CHARSET={$CHARSET} COLLATE={$COLLATE_TEXT};
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Sun Nov 30 09:20:46 2014 | Cross-referenced by PHPXref 0.7.1 |