[Summary view] [Print] [Text view]

   1  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
   2  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
   3  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
   4  /*!40101 SET NAMES utf8 */;
   5  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
   6  /*!40103 SET TIME_ZONE='+00:00' */;
   7  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
   8  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
   9  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  10  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  11  
  12  
  13  
  14  
  15  
  16  
  17  
  18  USE `{$NAMESPACE}_conduit`;
  19  
  20  
  21  
  22  
  23  
  24  DROP TABLE IF EXISTS `conduit_connectionlog`;
  25  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  26  /*!40101 SET character_set_client = utf8 */;
  27  CREATE TABLE `conduit_connectionlog` (
  28    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  29    `client` varchar(255) DEFAULT NULL,
  30    `clientVersion` varchar(255) DEFAULT NULL,
  31    `clientDescription` varchar(255) DEFAULT NULL,
  32    `username` varchar(255) DEFAULT NULL,
  33    `dateCreated` int(10) unsigned NOT NULL,
  34    `dateModified` int(10) unsigned NOT NULL,
  35    PRIMARY KEY (`id`)
  36  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  37  /*!40101 SET character_set_client = @saved_cs_client */;
  38  
  39  
  40  
  41  
  42  
  43  DROP TABLE IF EXISTS `conduit_methodcalllog`;
  44  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  45  /*!40101 SET character_set_client = utf8 */;
  46  CREATE TABLE `conduit_methodcalllog` (
  47    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  48    `connectionID` bigint(20) unsigned DEFAULT NULL,
  49    `method` varchar(255) NOT NULL,
  50    `error` varchar(255) NOT NULL,
  51    `duration` bigint(20) unsigned NOT NULL,
  52    `dateCreated` int(10) unsigned NOT NULL,
  53    `dateModified` int(10) unsigned NOT NULL,
  54    PRIMARY KEY (`id`)
  55  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  56  /*!40101 SET character_set_client = @saved_cs_client */;
  57  
  58  
  59  
  60  
  61  
  62  
  63  
  64  USE `{$NAMESPACE}_differential`;
  65  
  66  
  67  
  68  
  69  
  70  DROP TABLE IF EXISTS `differential_changeset`;
  71  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  72  /*!40101 SET character_set_client = utf8 */;
  73  CREATE TABLE `differential_changeset` (
  74    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  75    `diffID` int(10) unsigned NOT NULL,
  76    `oldFile` varchar(255) DEFAULT NULL,
  77    `fileName` varchar(255) NOT NULL,
  78    `awayPaths` longblob,
  79    `changeType` int(10) unsigned NOT NULL,
  80    `fileType` int(10) unsigned NOT NULL,
  81    `metadata` longblob,
  82    `oldProperties` longblob,
  83    `newProperties` longblob,
  84    `addLines` int(10) unsigned NOT NULL,
  85    `delLines` int(10) unsigned NOT NULL,
  86    `dateCreated` int(10) unsigned NOT NULL,
  87    `dateModified` int(10) unsigned NOT NULL,
  88    PRIMARY KEY (`id`)
  89  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  90  /*!40101 SET character_set_client = @saved_cs_client */;
  91  
  92  
  93  
  94  
  95  
  96  DROP TABLE IF EXISTS `differential_changeset_parse_cache`;
  97  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  98  /*!40101 SET character_set_client = utf8 */;
  99  CREATE TABLE `differential_changeset_parse_cache` (
 100    `id` int(10) unsigned NOT NULL,
 101    `cache` longblob NOT NULL,
 102    PRIMARY KEY (`id`)
 103  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 104  /*!40101 SET character_set_client = @saved_cs_client */;
 105  
 106  
 107  
 108  
 109  
 110  DROP TABLE IF EXISTS `differential_comment`;
 111  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 112  /*!40101 SET character_set_client = utf8 */;
 113  CREATE TABLE `differential_comment` (
 114    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 115    `revisionID` int(10) unsigned NOT NULL,
 116    `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 117    `action` varchar(64) NOT NULL,
 118    `content` longblob NOT NULL,
 119    `dateCreated` int(10) unsigned NOT NULL,
 120    `dateModified` int(10) unsigned NOT NULL,
 121    `cache` longblob,
 122    PRIMARY KEY (`id`)
 123  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 124  /*!40101 SET character_set_client = @saved_cs_client */;
 125  
 126  
 127  
 128  
 129  
 130  DROP TABLE IF EXISTS `differential_diff`;
 131  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 132  /*!40101 SET character_set_client = utf8 */;
 133  CREATE TABLE `differential_diff` (
 134    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 135    `revisionID` int(10) unsigned DEFAULT NULL,
 136    `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 137    `sourceMachine` varchar(255) DEFAULT NULL,
 138    `sourcePath` varchar(255) DEFAULT NULL,
 139    `sourceControlSystem` varchar(64) DEFAULT NULL,
 140    `sourceControlBaseRevision` varchar(255) DEFAULT NULL,
 141    `sourceControlpath` varchar(255) DEFAULT NULL,
 142    `lintStatus` int(10) unsigned NOT NULL,
 143    `unitStatus` int(10) unsigned NOT NULL,
 144    `lineCount` int(10) unsigned NOT NULL,
 145    `branch` varchar(255) DEFAULT NULL,
 146    `parentRevisionID` int(10) unsigned DEFAULT NULL,
 147    `arcanistProject` varchar(255) DEFAULT NULL,
 148    `creationMethod` varchar(255) DEFAULT NULL,
 149    `dateCreated` int(10) unsigned NOT NULL,
 150    `dateModified` int(10) unsigned NOT NULL,
 151    `description` varchar(255) DEFAULT NULL,
 152    PRIMARY KEY (`id`)
 153  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 154  /*!40101 SET character_set_client = @saved_cs_client */;
 155  
 156  
 157  
 158  
 159  
 160  DROP TABLE IF EXISTS `differential_diffproperty`;
 161  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 162  /*!40101 SET character_set_client = utf8 */;
 163  CREATE TABLE `differential_diffproperty` (
 164    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 165    `diffID` int(10) unsigned NOT NULL,
 166    `name` varchar(255) NOT NULL,
 167    `data` longblob NOT NULL,
 168    `dateCreated` int(10) unsigned NOT NULL,
 169    `dateModified` int(10) unsigned NOT NULL,
 170    PRIMARY KEY (`id`)
 171  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 172  /*!40101 SET character_set_client = @saved_cs_client */;
 173  
 174  
 175  
 176  
 177  
 178  DROP TABLE IF EXISTS `differential_hunk`;
 179  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 180  /*!40101 SET character_set_client = utf8 */;
 181  CREATE TABLE `differential_hunk` (
 182    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 183    `changesetID` int(10) unsigned NOT NULL,
 184    `changes` longblob,
 185    `oldOffset` int(10) unsigned NOT NULL,
 186    `oldLen` int(10) unsigned NOT NULL,
 187    `newOffset` int(10) unsigned NOT NULL,
 188    `newLen` int(10) unsigned NOT NULL,
 189    `dateCreated` int(10) unsigned NOT NULL,
 190    `dateModified` int(10) unsigned NOT NULL,
 191    PRIMARY KEY (`id`)
 192  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 193  /*!40101 SET character_set_client = @saved_cs_client */;
 194  
 195  
 196  
 197  
 198  
 199  DROP TABLE IF EXISTS `differential_inlinecomment`;
 200  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 201  /*!40101 SET character_set_client = utf8 */;
 202  CREATE TABLE `differential_inlinecomment` (
 203    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 204    `revisionID` int(10) unsigned NOT NULL,
 205    `commentID` int(10) unsigned DEFAULT NULL,
 206    `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 207    `changesetID` int(10) unsigned NOT NULL,
 208    `isNewFile` tinyint(1) NOT NULL,
 209    `lineNumber` int(10) unsigned NOT NULL,
 210    `lineLength` int(10) unsigned NOT NULL,
 211    `content` longblob NOT NULL,
 212    `dateCreated` int(10) unsigned NOT NULL,
 213    `dateModified` int(10) unsigned NOT NULL,
 214    `cache` longblob,
 215    PRIMARY KEY (`id`)
 216  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 217  /*!40101 SET character_set_client = @saved_cs_client */;
 218  
 219  
 220  
 221  
 222  
 223  DROP TABLE IF EXISTS `differential_relationship`;
 224  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 225  /*!40101 SET character_set_client = utf8 */;
 226  CREATE TABLE `differential_relationship` (
 227    `revisionID` int(10) unsigned NOT NULL,
 228    `relation` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 229    `objectPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 230    `sequence` int(10) unsigned NOT NULL,
 231    `reasonPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 232    PRIMARY KEY (`revisionID`,`relation`,`objectPHID`),
 233    KEY `objectPHID` (`objectPHID`,`relation`)
 234  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 235  /*!40101 SET character_set_client = @saved_cs_client */;
 236  
 237  
 238  
 239  
 240  
 241  DROP TABLE IF EXISTS `differential_revision`;
 242  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 243  /*!40101 SET character_set_client = utf8 */;
 244  CREATE TABLE `differential_revision` (
 245    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 246    `title` varchar(255) NOT NULL,
 247    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 248    `status` varchar(32) NOT NULL,
 249    `summary` longtext NOT NULL,
 250    `testPlan` text NOT NULL,
 251    `revertPlan` text NOT NULL,
 252    `blameRevision` varchar(255) NOT NULL,
 253    `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 254    `dateCommitted` int(10) unsigned DEFAULT NULL,
 255    `lineCount` int(10) unsigned DEFAULT NULL,
 256    `dateCreated` int(10) unsigned NOT NULL,
 257    `dateModified` int(10) unsigned NOT NULL,
 258    `attached` longtext NOT NULL,
 259    `unsubscribed` longblob NOT NULL,
 260    PRIMARY KEY (`id`)
 261  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 262  /*!40101 SET character_set_client = @saved_cs_client */;
 263  
 264  
 265  
 266  
 267  
 268  
 269  
 270  USE `{$NAMESPACE}_draft`;
 271  
 272  
 273  
 274  
 275  
 276  DROP TABLE IF EXISTS `draft`;
 277  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 278  /*!40101 SET character_set_client = utf8 */;
 279  CREATE TABLE `draft` (
 280    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 281    `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 282    `draftKey` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 283    `draft` longblob NOT NULL,
 284    `dateCreated` int(10) unsigned NOT NULL,
 285    `dateModified` int(10) unsigned NOT NULL,
 286    PRIMARY KEY (`id`),
 287    UNIQUE KEY `authorPHID` (`authorPHID`,`draftKey`)
 288  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 289  /*!40101 SET character_set_client = @saved_cs_client */;
 290  
 291  
 292  
 293  
 294  
 295  
 296  
 297  USE `{$NAMESPACE}_file`;
 298  
 299  
 300  
 301  
 302  
 303  DROP TABLE IF EXISTS `file`;
 304  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 305  /*!40101 SET character_set_client = utf8 */;
 306  CREATE TABLE `file` (
 307    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 308    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 309    `name` varchar(255) DEFAULT NULL,
 310    `mimeType` varchar(255) DEFAULT NULL,
 311    `byteSize` bigint(20) unsigned NOT NULL,
 312    `storageEngine` varchar(32) NOT NULL,
 313    `storageFormat` varchar(32) NOT NULL,
 314    `storageHandle` varchar(255) NOT NULL,
 315    `dateCreated` int(10) unsigned NOT NULL,
 316    `dateModified` int(10) unsigned NOT NULL,
 317    PRIMARY KEY (`id`)
 318  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 319  /*!40101 SET character_set_client = @saved_cs_client */;
 320  
 321  
 322  
 323  
 324  
 325  DROP TABLE IF EXISTS `file_storageblob`;
 326  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 327  /*!40101 SET character_set_client = utf8 */;
 328  CREATE TABLE `file_storageblob` (
 329    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 330    `data` longblob NOT NULL,
 331    `dateCreated` int(10) unsigned NOT NULL,
 332    `dateModified` int(10) unsigned NOT NULL,
 333    PRIMARY KEY (`id`)
 334  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 335  /*!40101 SET character_set_client = @saved_cs_client */;
 336  
 337  
 338  
 339  
 340  
 341  
 342  
 343  USE `{$NAMESPACE}_metamta`;
 344  
 345  
 346  
 347  
 348  
 349  DROP TABLE IF EXISTS `metamta_mail`;
 350  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 351  /*!40101 SET character_set_client = utf8 */;
 352  CREATE TABLE `metamta_mail` (
 353    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 354    `parameters` longblob NOT NULL,
 355    `status` varchar(255) NOT NULL,
 356    `message` text,
 357    `retryCount` int(10) unsigned NOT NULL,
 358    `nextRetry` int(10) unsigned NOT NULL,
 359    `relatedPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 360    `dateCreated` int(10) unsigned NOT NULL,
 361    `dateModified` int(10) unsigned NOT NULL,
 362    PRIMARY KEY (`id`)
 363  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 364  /*!40101 SET character_set_client = @saved_cs_client */;
 365  
 366  
 367  
 368  
 369  
 370  DROP TABLE IF EXISTS `metamta_mailinglist`;
 371  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 372  /*!40101 SET character_set_client = utf8 */;
 373  CREATE TABLE `metamta_mailinglist` (
 374    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 375    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 376    `name` varchar(255) NOT NULL,
 377    `email` varchar(255) NOT NULL,
 378    `uri` varchar(255) DEFAULT NULL,
 379    `dateCreated` int(10) unsigned NOT NULL,
 380    `dateModified` int(10) unsigned NOT NULL,
 381    PRIMARY KEY (`id`)
 382  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 383  /*!40101 SET character_set_client = @saved_cs_client */;
 384  
 385  
 386  DROP TABLE IF EXISTS `phid_type`;
 387  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 388  /*!40101 SET character_set_client = utf8 */;
 389  CREATE TABLE `phid_type` (
 390    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 391    `type` varchar(4) NOT NULL,
 392    `name` varchar(255) NOT NULL,
 393    `description` text,
 394    `dateCreated` int(10) unsigned NOT NULL,
 395    `dateModified` int(10) unsigned NOT NULL,
 396    PRIMARY KEY (`id`),
 397    UNIQUE KEY `type` (`type`)
 398  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 399  /*!40101 SET character_set_client = @saved_cs_client */;
 400  
 401  
 402  
 403  
 404  
 405  
 406  
 407  USE `{$NAMESPACE}_user`;
 408  
 409  
 410  
 411  
 412  
 413  DROP TABLE IF EXISTS `phabricator_session`;
 414  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 415  /*!40101 SET character_set_client = utf8 */;
 416  CREATE TABLE `phabricator_session` (
 417    `userPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 418    `type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 419    `sessionKey` varchar(40) NOT NULL,
 420    `sessionStart` int(10) unsigned NOT NULL,
 421    PRIMARY KEY (`userPHID`,`type`)
 422  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 423  /*!40101 SET character_set_client = @saved_cs_client */;
 424  
 425  
 426  
 427  
 428  
 429  DROP TABLE IF EXISTS `user`;
 430  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 431  /*!40101 SET character_set_client = utf8 */;
 432  CREATE TABLE `user` (
 433    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 434    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 435    `userName` varchar(64) NOT NULL,
 436    `realName` varchar(128) NOT NULL,
 437    `email` varchar(255) NOT NULL,
 438    `passwordSalt` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 439    `passwordHash` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 440    `dateCreated` int(10) unsigned NOT NULL,
 441    `dateModified` int(10) unsigned NOT NULL,
 442    `facebookUID` bigint(20) unsigned DEFAULT NULL,
 443    `profileImagePHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 444    `consoleEnabled` tinyint(1) NOT NULL,
 445    `consoleVisible` tinyint(1) NOT NULL,
 446    `consoleTab` varchar(64) NOT NULL,
 447    `conduitCertificate` varchar(255) NOT NULL,
 448    PRIMARY KEY (`id`),
 449    UNIQUE KEY `userName` (`userName`),
 450    UNIQUE KEY `email` (`email`),
 451    UNIQUE KEY `facebookUID` (`facebookUID`)
 452  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 453  /*!40101 SET character_set_client = @saved_cs_client */;
 454  
 455  
 456  
 457  
 458  
 459  DROP TABLE IF EXISTS `user_profile`;
 460  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 461  /*!40101 SET character_set_client = utf8 */;
 462  CREATE TABLE `user_profile` (
 463    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 464    `userPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 465    `title` varchar(255) NOT NULL,
 466    `blurb` text NOT NULL,
 467    `profileImagePHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 468    `dateCreated` int(10) unsigned NOT NULL,
 469    `dateModified` int(10) unsigned NOT NULL,
 470    PRIMARY KEY (`id`),
 471    UNIQUE KEY `userPHID` (`userPHID`)
 472  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 473  /*!40101 SET character_set_client = @saved_cs_client */;
 474  
 475  
 476  
 477  
 478  
 479  
 480  
 481  USE `{$NAMESPACE}_file`;
 482  
 483  
 484  
 485  
 486  
 487  DROP TABLE IF EXISTS `file`;
 488  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 489  /*!40101 SET character_set_client = utf8 */;
 490  CREATE TABLE `file` (
 491    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 492    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 493    `name` varchar(255) DEFAULT NULL,
 494    `mimeType` varchar(255) DEFAULT NULL,
 495    `byteSize` bigint(20) unsigned NOT NULL,
 496    `storageEngine` varchar(32) NOT NULL,
 497    `storageFormat` varchar(32) NOT NULL,
 498    `storageHandle` varchar(255) NOT NULL,
 499    `dateCreated` int(10) unsigned NOT NULL,
 500    `dateModified` int(10) unsigned NOT NULL,
 501    PRIMARY KEY (`id`)
 502  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 503  /*!40101 SET character_set_client = @saved_cs_client */;
 504  
 505  
 506  
 507  
 508  
 509  DROP TABLE IF EXISTS `file_storageblob`;
 510  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 511  /*!40101 SET character_set_client = utf8 */;
 512  CREATE TABLE `file_storageblob` (
 513    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 514    `data` longblob NOT NULL,
 515    `dateCreated` int(10) unsigned NOT NULL,
 516    `dateModified` int(10) unsigned NOT NULL,
 517    PRIMARY KEY (`id`)
 518  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 519  /*!40101 SET character_set_client = @saved_cs_client */;
 520  
 521  
 522  
 523  
 524  
 525  
 526  
 527  USE `{$NAMESPACE}_repository`;
 528  
 529  
 530  
 531  
 532  
 533  DROP TABLE IF EXISTS `repository`;
 534  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 535  /*!40101 SET character_set_client = utf8 */;
 536  CREATE TABLE `repository` (
 537    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 538    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 539    `name` varchar(255) NOT NULL,
 540    `callsign` varchar(32) NOT NULL,
 541    `description` text,
 542    `versionControlSystem` varchar(32) NOT NULL,
 543    `details` longblob NOT NULL,
 544    `dateCreated` int(10) unsigned NOT NULL,
 545    `dateModified` int(10) unsigned NOT NULL,
 546    PRIMARY KEY (`id`),
 547    UNIQUE KEY `callsign` (`callsign`),
 548    UNIQUE KEY `phid` (`phid`)
 549  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 550  /*!40101 SET character_set_client = @saved_cs_client */;
 551  
 552  
 553  
 554  
 555  
 556  DROP TABLE IF EXISTS `repository_githubnotification`;
 557  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 558  /*!40101 SET character_set_client = utf8 */;
 559  CREATE TABLE `repository_githubnotification` (
 560    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 561    `repositoryPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 562    `remoteAddress` varchar(32) NOT NULL,
 563    `payload` longblob NOT NULL,
 564    `dateCreated` int(10) unsigned NOT NULL,
 565    `dateModified` int(10) unsigned NOT NULL,
 566    PRIMARY KEY (`id`),
 567    KEY `repositoryPHID` (`repositoryPHID`)
 568  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 569  /*!40101 SET character_set_client = @saved_cs_client */;
 570  
 571  
 572  
 573  
 574  
 575  
 576  
 577  USE `{$NAMESPACE}_search`;
 578  
 579  
 580  
 581  
 582  
 583  DROP TABLE IF EXISTS `search_document`;
 584  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 585  /*!40101 SET character_set_client = utf8 */;
 586  CREATE TABLE `search_document` (
 587    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 588    `documentType` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 589    `documentTitle` varchar(255) NOT NULL,
 590    `documentCreated` int(10) unsigned NOT NULL,
 591    `documentModified` int(10) unsigned NOT NULL,
 592    PRIMARY KEY (`phid`)
 593  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 594  /*!40101 SET character_set_client = @saved_cs_client */;
 595  
 596  
 597  
 598  
 599  
 600  DROP TABLE IF EXISTS `search_documentfield`;
 601  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 602  /*!40101 SET character_set_client = utf8 */;
 603  CREATE TABLE `search_documentfield` (
 604    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 605    `phidType` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 606    `field` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 607    `auxPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 608    `corpus` text,
 609    KEY `phid` (`phid`),
 610    FULLTEXT KEY `corpus` (`corpus`)
 611  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 612  /*!40101 SET character_set_client = @saved_cs_client */;
 613  
 614  
 615  
 616  
 617  
 618  DROP TABLE IF EXISTS `search_documentrelationship`;
 619  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 620  /*!40101 SET character_set_client = utf8 */;
 621  CREATE TABLE `search_documentrelationship` (
 622    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 623    `relatedPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 624    `relation` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 625    `relatedType` varchar(4) NOT NULL,
 626    `relatedTime` int(10) unsigned NOT NULL,
 627    KEY `phid` (`phid`)
 628  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 629  /*!40101 SET character_set_client = @saved_cs_client */;
 630  
 631  
 632  
 633  
 634  
 635  DROP TABLE IF EXISTS `search_query`;
 636  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 637  /*!40101 SET character_set_client = utf8 */;
 638  CREATE TABLE `search_query` (
 639    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 640    `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 641    `query` varchar(255) NOT NULL,
 642    `parameters` text NOT NULL,
 643    `dateCreated` int(10) unsigned NOT NULL,
 644    `dateModified` int(10) unsigned NOT NULL,
 645    PRIMARY KEY (`id`)
 646  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 647  /*!40101 SET character_set_client = @saved_cs_client */;
 648  
 649  
 650  
 651  
 652  
 653  
 654  
 655  USE `{$NAMESPACE}_maniphest`;
 656  
 657  
 658  
 659  
 660  
 661  DROP TABLE IF EXISTS `maniphest_task`;
 662  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 663  /*!40101 SET character_set_client = utf8 */;
 664  CREATE TABLE `maniphest_task` (
 665    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 666    `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 667    `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 668    `ownerPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
 669    `ccPHIDs` text,
 670    `attached` longtext NOT NULL,
 671    `status` int(10) unsigned NOT NULL,
 672    `priority` int(10) unsigned NOT NULL,
 673    `title` text NOT NULL,
 674    `description` longtext NOT NULL,
 675    `dateCreated` int(10) unsigned NOT NULL,
 676    `dateModified` int(10) unsigned NOT NULL,
 677    PRIMARY KEY (`id`)
 678  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 679  /*!40101 SET character_set_client = @saved_cs_client */;
 680  
 681  
 682  
 683  
 684  
 685  DROP TABLE IF EXISTS `maniphest_touch`;
 686  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 687  /*!40101 SET character_set_client = utf8 */;
 688  CREATE TABLE `maniphest_touch` (
 689    `userPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 690    `taskID` int(10) unsigned NOT NULL,
 691    `touchedAt` int(10) unsigned NOT NULL,
 692    PRIMARY KEY (`userPHID`,`taskID`)
 693  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 694  /*!40101 SET character_set_client = @saved_cs_client */;
 695  
 696  
 697  
 698  
 699  
 700  DROP TABLE IF EXISTS `maniphest_transaction`;
 701  /*!40101 SET @saved_cs_client     = @@character_set_client */;
 702  /*!40101 SET character_set_client = utf8 */;
 703  CREATE TABLE `maniphest_transaction` (
 704    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 705    `taskID` int(10) unsigned NOT NULL,
 706    `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
 707    `transactionType` varchar(16) NOT NULL,
 708    `oldValue` longblob,
 709    `newValue` longblob,
 710    `comments` longblob,
 711    `dateCreated` int(10) unsigned NOT NULL,
 712    `dateModified` int(10) unsigned NOT NULL,
 713    `cache` longblob,
 714    PRIMARY KEY (`id`)
 715  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 716  /*!40101 SET character_set_client = @saved_cs_client */;
 717  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 718  
 719  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 720  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
 721  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 722  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 723  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 724  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 725  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;