Page MenuHomestyx hydra
Files F127420

No OneTemporary
Actions

View Options

diff --git a/resources/sql/init/initialize.sql b/resources/sql/init/initialize.sql
index 426dc9b589..05308bf8a9 100644
--- a/resources/sql/init/initialize.sql
+++ b/resources/sql/init/initialize.sql
@@ -1,638 +1,857 @@
-- MySQL dump 10.13 Distrib 5.5.8, for osx10.6 (i386)
--
-- Host: localhost Database: phabricator_conduit
-- ------------------------------------------------------
-- Server version 5.5.8
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `phabricator_conduit`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_conduit` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `phabricator_conduit`;
--
-- Table structure for table `conduit_connectionlog`
--
DROP TABLE IF EXISTS `conduit_connectionlog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `conduit_connectionlog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`client` varchar(255) DEFAULT NULL,
`clientVersion` varchar(255) DEFAULT NULL,
`clientDescription` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `conduit_methodcalllog`
--
DROP TABLE IF EXISTS `conduit_methodcalllog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `conduit_methodcalllog` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`connectionID` bigint(20) unsigned DEFAULT NULL,
`method` varchar(255) NOT NULL,
`error` varchar(255) NOT NULL,
`duration` bigint(20) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=454 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Current Database: `phabricator_differential`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_differential` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `phabricator_differential`;
--
-- Table structure for table `differential_changeset`
--
DROP TABLE IF EXISTS `differential_changeset`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `differential_changeset` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`diffID` int(10) unsigned NOT NULL,
`oldFile` varchar(255) DEFAULT NULL,
`fileName` varchar(255) NOT NULL,
`awayPaths` longblob,
`changeType` int(10) unsigned NOT NULL,
`fileType` int(10) unsigned NOT NULL,
`metadata` longblob,
`oldProperties` longblob,
`newProperties` longblob,
`addLines` int(10) unsigned NOT NULL,
`delLines` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=603 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `differential_changeset_parse_cache`
--
DROP TABLE IF EXISTS `differential_changeset_parse_cache`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `differential_changeset_parse_cache` (
`id` int(10) unsigned NOT NULL,
`cache` longblob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `differential_comment`
--
DROP TABLE IF EXISTS `differential_comment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `differential_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`revisionID` int(10) unsigned NOT NULL,
`authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`action` varchar(64) NOT NULL,
`content` longblob NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`cache` longblob,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `differential_diff`
--
DROP TABLE IF EXISTS `differential_diff`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `differential_diff` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`revisionID` int(10) unsigned DEFAULT NULL,
`authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`sourceMachine` varchar(255) DEFAULT NULL,
`sourcePath` varchar(255) DEFAULT NULL,
`sourceControlSystem` varchar(64) DEFAULT NULL,
`sourceControlBaseRevision` varchar(255) DEFAULT NULL,
`sourceControlpath` varchar(255) DEFAULT NULL,
`lintStatus` int(10) unsigned NOT NULL,
`unitStatus` int(10) unsigned NOT NULL,
`lineCount` int(10) unsigned NOT NULL,
`branch` varchar(255) DEFAULT NULL,
`parentRevisionID` int(10) unsigned DEFAULT NULL,
`arcanistProject` varchar(255) DEFAULT NULL,
`creationMethod` varchar(255) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `differential_diffproperty`
--
DROP TABLE IF EXISTS `differential_diffproperty`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `differential_diffproperty` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`diffID` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`data` longblob NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `differential_hunk`
--
DROP TABLE IF EXISTS `differential_hunk`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `differential_hunk` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changesetID` int(10) unsigned NOT NULL,
`changes` longblob,
`oldOffset` int(10) unsigned NOT NULL,
`oldLen` int(10) unsigned NOT NULL,
`newOffset` int(10) unsigned NOT NULL,
`newLen` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=603 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `differential_inlinecomment`
--
DROP TABLE IF EXISTS `differential_inlinecomment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `differential_inlinecomment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`revisionID` int(10) unsigned NOT NULL,
`commentID` int(10) unsigned DEFAULT NULL,
`authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`changesetID` int(10) unsigned NOT NULL,
`isNewFile` tinyint(1) NOT NULL,
`lineNumber` int(10) unsigned NOT NULL,
`lineLength` int(10) unsigned NOT NULL,
`content` longblob NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`cache` longblob,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `differential_relationship`
--
DROP TABLE IF EXISTS `differential_relationship`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `differential_relationship` (
`revisionID` int(10) unsigned NOT NULL,
`relation` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`objectPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`sequence` int(10) unsigned NOT NULL,
`reasonPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
PRIMARY KEY (`revisionID`,`relation`,`objectPHID`),
KEY `objectPHID` (`objectPHID`,`relation`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `differential_revision`
--
DROP TABLE IF EXISTS `differential_revision`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `differential_revision` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`status` varchar(32) NOT NULL,
`summary` longtext NOT NULL,
`testPlan` text NOT NULL,
`revertPlan` text NOT NULL,
`blameRevision` varchar(255) NOT NULL,
`authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`dateCommitted` int(10) unsigned DEFAULT NULL,
`lineCount` int(10) unsigned DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
+ `attached` longtext NOT NULL,
+ `unsubscribed` longblob NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Current Database: `phabricator_draft`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_draft` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `phabricator_draft`;
--
-- Table structure for table `draft`
--
DROP TABLE IF EXISTS `draft`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `draft` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`draftKey` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`draft` longblob NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `authorPHID` (`authorPHID`,`draftKey`)
-) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Current Database: `phabricator_file`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_file` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `phabricator_file`;
--
-- Table structure for table `file`
--
DROP TABLE IF EXISTS `file`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`name` varchar(255) DEFAULT NULL,
`mimeType` varchar(255) DEFAULT NULL,
`byteSize` bigint(20) unsigned NOT NULL,
`storageEngine` varchar(32) NOT NULL,
`storageFormat` varchar(32) NOT NULL,
`storageHandle` varchar(255) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `file_storageblob`
--
DROP TABLE IF EXISTS `file_storageblob`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_storageblob` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longblob NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Current Database: `phabricator_metamta`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_metamta` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `phabricator_metamta`;
--
-- Table structure for table `metamta_mail`
--
DROP TABLE IF EXISTS `metamta_mail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `metamta_mail` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parameters` longblob NOT NULL,
`status` varchar(255) NOT NULL,
`message` text,
`retryCount` int(10) unsigned NOT NULL,
`nextRetry` int(10) unsigned NOT NULL,
`relatedPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `metamta_mailinglist`
--
DROP TABLE IF EXISTS `metamta_mailinglist`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `metamta_mailinglist` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`uri` varchar(255) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Current Database: `phabricator_phid`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_phid` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `phabricator_phid`;
--
-- Table structure for table `phid`
--
DROP TABLE IF EXISTS `phid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phid` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`phidType` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`parentPHID` varchar(64) DEFAULT NULL,
`ownerPHID` varchar(64) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `phid` (`phid`)
-) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `phid_type`
--
DROP TABLE IF EXISTS `phid_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phid_type` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(4) NOT NULL,
`name` varchar(255) NOT NULL,
`description` text,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `type` (`type`)
-) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Current Database: `phabricator_user`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_user` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `phabricator_user`;
--
-- Table structure for table `phabricator_session`
--
DROP TABLE IF EXISTS `phabricator_session`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phabricator_session` (
`userPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`type` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`sessionKey` varchar(40) NOT NULL,
`sessionStart` int(10) unsigned NOT NULL,
PRIMARY KEY (`userPHID`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`userName` varchar(64) NOT NULL,
`realName` varchar(128) NOT NULL,
`email` varchar(255) NOT NULL,
`passwordSalt` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`passwordHash` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`facebookUID` bigint(20) unsigned DEFAULT NULL,
`profileImagePHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`consoleEnabled` tinyint(1) NOT NULL,
`consoleVisible` tinyint(1) NOT NULL,
`consoleTab` varchar(64) NOT NULL,
`conduitCertificate` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `userName` (`userName`),
UNIQUE KEY `email` (`email`),
UNIQUE KEY `facebookUID` (`facebookUID`)
-) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `user_profile`
+--
+
+DROP TABLE IF EXISTS `user_profile`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user_profile` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `userPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `title` varchar(255) NOT NULL,
+ `blurb` text NOT NULL,
+ `profileImagePHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
+ `dateCreated` int(10) unsigned NOT NULL,
+ `dateModified` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `userPHID` (`userPHID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Current Database: `phabricator_file`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_file` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `phabricator_file`;
--
-- Table structure for table `file`
--
DROP TABLE IF EXISTS `file`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`name` varchar(255) DEFAULT NULL,
`mimeType` varchar(255) DEFAULT NULL,
`byteSize` bigint(20) unsigned NOT NULL,
`storageEngine` varchar(32) NOT NULL,
`storageFormat` varchar(32) NOT NULL,
`storageHandle` varchar(255) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `file_storageblob`
--
DROP TABLE IF EXISTS `file_storageblob`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `file_storageblob` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longblob NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Current Database: `phabricator_repository`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_repository` /*!40100 DEFAULT CHARACTER SET latin1 */;
+
+USE `phabricator_repository`;
+
+--
+-- Table structure for table `repository`
+--
+
+DROP TABLE IF EXISTS `repository`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `repository` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `callsign` varchar(32) NOT NULL,
+ `description` text,
+ `versionControlSystem` varchar(32) NOT NULL,
+ `details` longblob NOT NULL,
+ `dateCreated` int(10) unsigned NOT NULL,
+ `dateModified` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `callsign` (`callsign`),
+ UNIQUE KEY `phid` (`phid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `repository_githubnotification`
+--
+
+DROP TABLE IF EXISTS `repository_githubnotification`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `repository_githubnotification` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `repositoryPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `remoteAddress` varchar(32) NOT NULL,
+ `payload` longblob NOT NULL,
+ `dateCreated` int(10) unsigned NOT NULL,
+ `dateModified` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `repositoryPHID` (`repositoryPHID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Current Database: `phabricator_search`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_search` /*!40100 DEFAULT CHARACTER SET latin1 */;
+
+USE `phabricator_search`;
+
+--
+-- Table structure for table `search_document`
+--
+
+DROP TABLE IF EXISTS `search_document`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `search_document` (
+ `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `documentType` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `documentTitle` varchar(255) NOT NULL,
+ `documentCreated` int(10) unsigned NOT NULL,
+ `documentModified` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`phid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `search_documentfield`
+--
+
+DROP TABLE IF EXISTS `search_documentfield`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `search_documentfield` (
+ `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `phidType` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `field` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `auxPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
+ `corpus` text,
+ KEY `phid` (`phid`),
+ FULLTEXT KEY `corpus` (`corpus`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `search_documentrelationship`
+--
+
+DROP TABLE IF EXISTS `search_documentrelationship`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `search_documentrelationship` (
+ `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `relatedPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `relation` varchar(4) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `relatedType` varchar(4) NOT NULL,
+ `relatedTime` int(10) unsigned NOT NULL,
+ KEY `phid` (`phid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `search_query`
+--
+
+DROP TABLE IF EXISTS `search_query`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `search_query` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
+ `query` varchar(255) NOT NULL,
+ `parameters` text NOT NULL,
+ `dateCreated` int(10) unsigned NOT NULL,
+ `dateModified` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Current Database: `phabricator_maniphest`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_maniphest` /*!40100 DEFAULT CHARACTER SET latin1 */;
+
+USE `phabricator_maniphest`;
+
+--
+-- Table structure for table `maniphest_task`
+--
+
+DROP TABLE IF EXISTS `maniphest_task`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `maniphest_task` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `ownerPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
+ `ccPHIDs` text,
+ `attached` longtext NOT NULL,
+ `status` int(10) unsigned NOT NULL,
+ `priority` int(10) unsigned NOT NULL,
+ `title` text NOT NULL,
+ `description` longtext NOT NULL,
+ `dateCreated` int(10) unsigned NOT NULL,
+ `dateModified` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `maniphest_touch`
+--
+
+DROP TABLE IF EXISTS `maniphest_touch`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `maniphest_touch` (
+ `userPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `taskID` int(10) unsigned NOT NULL,
+ `touchedAt` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`userPHID`,`taskID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `maniphest_transaction`
+--
+
+DROP TABLE IF EXISTS `maniphest_transaction`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `maniphest_transaction` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `taskID` int(10) unsigned NOT NULL,
+ `authorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
+ `transactionType` varchar(16) NOT NULL,
+ `oldValue` longblob,
+ `newValue` longblob,
+ `comments` longblob,
+ `dateCreated` int(10) unsigned NOT NULL,
+ `dateModified` int(10) unsigned NOT NULL,
+ `cache` longblob,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2011-02-11 13:54:33
+-- Dump completed on 2011-02-20 13:25:52
-- MySQL dump 10.13 Distrib 5.5.8, for osx10.6 (i386)
--
-- Host: localhost Database: phabricator_directory
-- ------------------------------------------------------
-- Server version 5.5.8
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `phabricator_directory`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phabricator_directory` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `phabricator_directory`;
--
-- Table structure for table `directory_category`
--
DROP TABLE IF EXISTS `directory_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `directory_category` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`sequence` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `directory_category`
--
LOCK TABLES `directory_category` WRITE;
/*!40000 ALTER TABLE `directory_category` DISABLE KEYS */;
INSERT INTO `directory_category` VALUES (1,'Configuration',1000,1295321201,1295830501),(2,'Developer Documentation',9000,1295318729,1295318851),(4,'Engineering Workflow',0,1295321164,1295321209),(5,'Utilities',100,1295321217,1295321217),(6,'Internals',2000,1295888559,1295888569);
/*!40000 ALTER TABLE `directory_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `directory_item`
--
DROP TABLE IF EXISTS `directory_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `directory_item` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
`href` varchar(255) NOT NULL,
`categoryID` int(10) unsigned NOT NULL,
`sequence` int(10) unsigned NOT NULL,
`imagePHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `directory_item`
--
LOCK TABLES `directory_item` WRITE;
/*!40000 ALTER TABLE `directory_item` DISABLE KEYS */;
INSERT INTO `directory_item` VALUES (1,'Repositories','Configure tracked source code repositories.','/repository/',1,0,NULL,0,0),(5,'libphutil Docs','Developer documentation for libphutil.','http://phutil.com/libphutil/docs/',2,0,'',1295312416,1295320996),(12,'Files','Blob store for files.','/file/',5,0,'',1295321244,1295816742),(13,'Differential','Code review tool.','/differential/',4,0,'',1295321263,1295321263),(14,'PHID Manager','Manage PHIDs and types.','/phid/',6,0,'',1295762315,1295888577),(15,'People','User directory.','/people/',4,3000,'',1295830520,1295830528),(16,'Conduit Console','Web console for Conduit API.','/conduit/',6,0,'',1295888593,1295888593),(17,'MetaMTA','Yo dawg, we heard you like MTAs...','/mail/',6,0,'',1296006261,1296056065),(18,'XHProf','PHP profiling tool.','/xhprof/',6,0,NULL,1296684238,1296684238),(20,'Maniphest','Construct lists of lists.','/maniphest/',4,0,NULL,1297190663,1297190663);
/*!40000 ALTER TABLE `directory_item` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2011-02-11 13:54:33
+-- Dump completed on 2011-02-20 13:25:52

File Metadata

Mime Type
text/x-diff
Expires
Mon, Apr 28, 12:46 PM (1 d, 2 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
107972
Default Alt Text
(32 KB)

Event Timeline

styx copyright 2020 sirocyl / ellie (kymkdd) / ncommander / styx contributors
Use of other names and brands is not intended to reflect a claim of, or right to, use the name or brand.
styx is an operating system using the Linux kernel and components, and "styx Linux" as a phrase does not reflect the inclusion of the Linux brand or trademark in the styx project.
Linux® is the registered trademark of Linus Torvalds in the U.S. and other countries.
Terms and Conditions (TODO: fix this!)