Page MenuHomePhabricator
Files F1000244

storage.log
Public
Actions

Authored By
joshuaspence
Nov 24 2015, 8:45 PM
Size
212 KB
Referenced Files
None
Subscribers
None

storage.log
View Options

>>> [1] <connect>
<<< [1] <connect> 1,578 us
>>> [2] <query> SELECT 1
<<< [2] <query> 187 us
>>> [3] <connect>
<<< [3] <connect> 387 us
>>> [4] <query> SELECT 1
<<< [4] <query> 123 us
>>> [5] <connect> testT9773_4100_meta_data
<<< [5] <connect> 535 us
>>> [6] <connect> testT9773_4100_meta_data
<<< [6] <connect> 3,911 us
Loading quickstart template...
>>> [7] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [7] <query> 352 us
>>> [8] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_audit` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [8] <query> 2,594 us
>>> [9] <query> USE `testT9773_4100_audit`
<<< [9] <query> 180 us
>>> [10] <query> CREATE TABLE `audit_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE `
<<< [10] <query> 60,309 us
>>> [11] <query> CREATE TABLE `audit_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) unsig
<<< [11] <query> 104,577 us
>>> [12] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_calendar` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [12] <query> 504 us
>>> [13] <query> USE `testT9773_4100_calendar`
<<< [13] <query> 134 us
>>> [14] <query> CREATE TABLE `calendar_event` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`userPHID` varbinary(64) NOT NULL,
`dateFrom` int(10) unsigned NOT NULL,
`dateTo` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isCancelled` tinyint(1) NOT NULL,
`name` longtext COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy
<<< [14] <query> 94,199 us
>>> [15] <query> CREATE TABLE `calendar_eventinvitee` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`eventPHID` varbinary(64) NOT NULL,
`inviteePHID` varbinary(64) NOT NULL,
`inviterPHID` varbinary(64) NOT NULL,
`status` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_event` (`eventPHID`,`inviteePHID`),
KEY `key_invitee` (`inviteePHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`u
<<< [15] <query> 83,215 us
>>> [16] <query> CREATE TABLE `calendar_eventtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext C
<<< [16] <query> 63,280 us
>>> [17] <query> CREATE TABLE `calendar_eventtransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(1
<<< [17] <query> 74,390 us
>>> [18] <query> CREATE TABLE `calendar_holiday` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`day` date NOT NULL,
`name` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `day` (`day`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [18] <query> 71,826 us
>>> [19] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [19] <query> 73,343 us
>>> [20] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [20] <query> 69,971 us
>>> [21] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_chatlog` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [21] <query> 1,945 us
>>> [22] <query> USE `testT9773_4100_chatlog`
<<< [22] <query> 900 us
>>> [23] <query> CREATE TABLE `chatlog_channel` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`serviceName` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`serviceType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`channelName` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_channel` (`channelName`,`serviceType`,`servic
<<< [23] <query> 57,744 us
>>> [24] <query> CREATE TABLE `chatlog_event` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`epoch` int(10) unsigned NOT NULL,
`author` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`type` varchar(4) COLLATE `utf8mb4_bin` NOT NULL,
`message` longtext COLLATE `utf8mb4_bin` NOT NULL,
`loggedByPHID` varbinary(64) NOT NULL,
`channelID` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `channel` (`epoch`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [24] <query> 76,470 us
>>> [25] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_conduit` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [25] <query> 433 us
>>> [26] <query> USE `testT9773_4100_conduit`
<<< [26] <query> 133 us
>>> [27] <query> CREATE TABLE `conduit_certificatetoken` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userPHID` varbinary(64) NOT NULL,
`token` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `userPHID` (`userPHID`),
UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [27] <query> 79,211 us
>>> [28] <query> CREATE TABLE `conduit_connectionlog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`client` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`clientVersion` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`clientDescription` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`username` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `key_created` (`dateCreated`)
) ENGINE=InnoDB DEF
<<< [28] <query> 64,542 us
>>> [29] <query> CREATE TABLE `conduit_methodcalllog` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`connectionID` bigint(20) unsigned DEFAULT NULL,
`method` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`error` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`duration` bigint(20) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`callerPHID` varbinary(64) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `key_method` (`method`),
KEY `key_callermethod` (`callerP
<<< [29] <query> 89,210 us
>>> [30] <query> CREATE TABLE `conduit_token` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`tokenType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`token` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`expires` int(10) unsigned DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_token` (`token`),
KEY `key_object` (`objectPHID`,`tokenType`),
KEY `key_expires` (`expires`)
) ENGINE=InnoD
<<< [30] <query> 74,466 us
>>> [31] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_countdown` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [31] <query> 721 us
>>> [32] <query> USE `testT9773_4100_countdown`
<<< [32] <query> 444 us
>>> [33] <query> CREATE TABLE `countdown` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`title` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`epoch` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`spacePHID` varbinary(64) DEFAULT NULL,
`editPolicy` varbinary(64) NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`mailK
<<< [33] <query> 72,738 us
>>> [34] <query> CREATE TABLE `countdown_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLA
<<< [34] <query> 74,219 us
>>> [35] <query> CREATE TABLE `countdown_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) u
<<< [35] <query> 74,526 us
>>> [36] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [36] <query> 59,874 us
>>> [37] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [37] <query> 47,280 us
>>> [38] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_daemon` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [38] <query> 619 us
>>> [39] <query> USE `testT9773_4100_daemon`
<<< [39] <query> 1,754 us
>>> [40] <query> CREATE TABLE `daemon_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`daemon` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`host` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`pid` int(10) unsigned NOT NULL,
`argv` longtext COLLATE `utf8mb4_bin` NOT NULL,
`explicitArgv` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`envHash` binary(40) NOT NULL,
`status` varchar(8) COLLATE `utf8mb4_bin` NOT NULL,
`runni
<<< [40] <query> 70,105 us
>>> [41] <query> CREATE TABLE `daemon_logevent` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`logID` int(10) unsigned NOT NULL,
`logType` varchar(4) COLLATE `utf8mb4_bin` NOT NULL,
`message` longtext COLLATE `utf8mb4_bin` NOT NULL,
`epoch` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `logID` (`logID`,`epoch`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [41] <query> 58,547 us
>>> [42] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_differential` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [42] <query> 360 us
>>> [43] <query> USE `testT9773_4100_differential`
<<< [43] <query> 195 us
>>> [44] <query> CREATE TABLE `differential_affectedpath` (
`repositoryID` int(10) unsigned NOT NULL,
`pathID` int(10) unsigned NOT NULL,
`epoch` int(10) unsigned NOT NULL,
`revisionID` int(10) unsigned NOT NULL,
KEY `repositoryID` (`repositoryID`,`pathID`,`epoch`),
KEY `revisionID` (`revisionID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [44] <query> 74,517 us
>>> [45] <query> CREATE TABLE `differential_changeset` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`diffID` int(10) unsigned NOT NULL,
`oldFile` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`filename` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`awayPaths` longtext COLLATE `utf8mb4_bin`,
`changeType` int(10) unsigned NOT NULL,
`fileType` int(10) unsigned NOT NULL,
`metadata` longtext COLLATE `utf8mb4_bin`,
`oldProperties` longtext COLLATE `utf8mb4_bin`,
`newProperties` longtext COLLATE `utf8mb4
<<< [45] <query> 52,790 us
>>> [46] <query> CREATE TABLE `differential_changeset_parse_cache` (
`id` int(10) unsigned NOT NULL,
`cache` longblob NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `dateCreated` (`dateCreated`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [46] <query> 57,465 us
>>> [47] <query> CREATE TABLE `differential_commit` (
`revisionID` int(10) unsigned NOT NULL,
`commitPHID` varbinary(64) NOT NULL,
PRIMARY KEY (`revisionID`,`commitPHID`),
UNIQUE KEY `commitPHID` (`commitPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [47] <query> 50,040 us
>>> [48] <query> CREATE TABLE `differential_customfieldnumericindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`),
KEY `key_find` (`indexKey`,`indexValue`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [48] <query> 75,849 us
>>> [49] <query> CREATE TABLE `differential_customfieldstorage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`fieldIndex` binary(12) NOT NULL,
`fieldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [49] <query> 81,207 us
>>> [50] <query> CREATE TABLE `differential_customfieldstringindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` longtext CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)),
KEY `key_find` (`indexKey`,`indexValue`(64))
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [50] <query> 88,845 us
>>> [51] <query> CREATE TABLE `differential_diff` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`revisionID` int(10) unsigned DEFAULT NULL,
`authorPHID` varbinary(64) DEFAULT NULL,
`repositoryPHID` varbinary(64) DEFAULT NULL,
`sourceMachine` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`sourcePath` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`sourceControlSystem` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
`sourceControlBaseRevision` varchar(255) COLLATE `utf8
<<< [51] <query> 86,419 us
>>> [52] <query> CREATE TABLE `differential_diffproperty` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`diffID` int(10) unsigned NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `diffID` (`diffID`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [52] <query> 66,653 us
>>> [53] <query> CREATE TABLE `differential_difftransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtex
<<< [53] <query> 95,568 us
>>> [54] <query> CREATE TABLE `differential_draft` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`draftKey` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_unique` (`objectPHID`,`authorPHID`,`draftKey`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [54] <query> 79,407 us
>>> [55] <query> CREATE TABLE `differential_hiddencomment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userPHID` varbinary(64) NOT NULL,
`commentID` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_user` (`userPHID`,`commentID`),
KEY `key_comment` (`commentID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [55] <query> 83,378 us
>>> [56] <query> CREATE TABLE `differential_hunk` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changesetID` int(10) unsigned NOT NULL,
`changes` longtext COLLATE `utf8mb4_bin`,
`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`),
KEY `changesetID` (`changesetID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8m
<<< [56] <query> 63,957 us
>>> [57] <query> CREATE TABLE `differential_hunk_modern` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`changesetID` int(10) unsigned NOT NULL,
`oldOffset` int(10) unsigned NOT NULL,
`oldLen` int(10) unsigned NOT NULL,
`newOffset` int(10) unsigned NOT NULL,
`newLen` int(10) unsigned NOT NULL,
`dataType` binary(4) NOT NULL,
`dataEncoding` varchar(16) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dataFormat` binary(4) NOT NULL,
`data` longblob NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified`
<<< [57] <query> 79,340 us
>>> [58] <query> CREATE TABLE `differential_revision` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`originalTitle` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`phid` varbinary(64) NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`summary` longtext COLLATE `utf8mb4_bin` NOT NULL,
`testPlan` longtext COLLATE `utf8mb4_bin` NOT NULL,
`authorPHID` varbinary(64) DEFAULT NULL,
`lastReviewerPHID` varbinary(64) DEFAULT NULL,
`lineCount` int(1
<<< [58] <query> 98,889 us
>>> [59] <query> CREATE TABLE `differential_revisionhash` (
`revisionID` int(10) unsigned NOT NULL,
`type` binary(4) NOT NULL,
`hash` binary(40) NOT NULL,
KEY `type` (`type`,`hash`),
KEY `revisionID` (`revisionID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [59] <query> 74,629 us
>>> [60] <query> CREATE TABLE `differential_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext CO
<<< [60] <query> 71,311 us
>>> [61] <query> CREATE TABLE `differential_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10
<<< [61] <query> 79,481 us
>>> [62] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [62] <query> 57,497 us
>>> [63] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [63] <query> 44,278 us
>>> [64] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_draft` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [64] <query> 519 us
>>> [65] <query> USE `testT9773_4100_draft`
<<< [65] <query> 165 us
>>> [66] <query> CREATE TABLE `draft` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`authorPHID` varbinary(64) NOT NULL,
`draftKey` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`draft` longtext COLLATE `utf8mb4_bin` NOT NULL,
`metadata` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `authorPHID` (`authorPHID`,`draftKey`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [66] <query> 50,381 us
>>> [67] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_drydock` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [67] <query> 421 us
>>> [68] <query> USE `testT9773_4100_drydock`
<<< [68] <query> 121 us
>>> [69] <query> CREATE TABLE `drydock_blueprint` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`className` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`blueprintName` varchar(255) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`details` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`isDisabled` tinyint(1
<<< [69] <query> 54,029 us
>>> [70] <query> CREATE TABLE `drydock_blueprinttransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtex
<<< [70] <query> 58,550 us
>>> [71] <query> CREATE TABLE `drydock_command` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`authorPHID` varbinary(64) NOT NULL,
`targetPHID` varbinary(64) NOT NULL,
`command` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`isConsumed` tinyint(1) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `key_target` (`targetPHID`,`isConsumed`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [71] <query> 51,613 us
>>> [72] <query> CREATE TABLE `drydock_lease` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`until` int(10) unsigned DEFAULT NULL,
`ownerPHID` varbinary(64) DEFAULT NULL,
`attributes` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`resourceType` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`resourcePHID` varbinary(64) DEFAULT NULL,
PRIMARY K
<<< [72] <query> 55,756 us
>>> [73] <query> CREATE TABLE `drydock_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`resourceID` int(10) unsigned DEFAULT NULL,
`leaseID` int(10) unsigned DEFAULT NULL,
`epoch` int(10) unsigned NOT NULL,
`message` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
KEY `resourceID` (`resourceID`,`epoch`),
KEY `leaseID` (`leaseID`,`epoch`),
KEY `epoch` (`epoch`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [73] <query> 68,846 us
>>> [74] <query> CREATE TABLE `drydock_resource` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`ownerPHID` varbinary(64) DEFAULT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`type` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`attributes` longtext COLLATE `utf8mb4_bin` NOT NULL,
`capabilities` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned N
<<< [74] <query> 62,545 us
>>> [75] <query> CREATE TABLE `drydock_slotlock` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ownerPHID` varbinary(64) NOT NULL,
`lockIndex` binary(12) NOT NULL,
`lockKey` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_lock` (`lockIndex`),
KEY `key_owner` (`ownerPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [75] <query> 71,697 us
>>> [76] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_feed` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [76] <query> 321 us
>>> [77] <query> USE `testT9773_4100_feed`
<<< [77] <query> 177 us
>>> [78] <query> CREATE TABLE `feed_storydata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`chronologicalKey` bigint(20) unsigned NOT NULL,
`storyType` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`storyData` longtext COLLATE `utf8mb4_bin` NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `chronologicalKey` (`chronologicalKey`),
UNIQUE KEY `phid` (`phid`)
) E
<<< [78] <query> 67,983 us
>>> [79] <query> CREATE TABLE `feed_storynotification` (
`userPHID` varbinary(64) NOT NULL,
`primaryObjectPHID` varbinary(64) NOT NULL,
`chronologicalKey` bigint(20) unsigned NOT NULL,
`hasViewed` tinyint(1) NOT NULL,
UNIQUE KEY `userPHID` (`userPHID`,`chronologicalKey`),
KEY `userPHID_2` (`userPHID`,`hasViewed`,`primaryObjectPHID`),
KEY `key_object` (`primaryObjectPHID`),
KEY `key_chronological` (`chronologicalKey`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [79] <query> 81,609 us
>>> [80] <query> CREATE TABLE `feed_storyreference` (
`objectPHID` varbinary(64) NOT NULL,
`chronologicalKey` bigint(20) unsigned NOT NULL,
UNIQUE KEY `objectPHID` (`objectPHID`,`chronologicalKey`),
KEY `chronologicalKey` (`chronologicalKey`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [80] <query> 84,731 us
>>> [81] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_file` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [81] <query> 394 us
>>> [82] <query> USE `testT9773_4100_file`
<<< [82] <query> 149 us
>>> [83] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [83] <query> 84,617 us
>>> [84] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [84] <query> 52,614 us
>>> [85] <query> CREATE TABLE `file` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`mimeType` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`byteSize` bigint(20) unsigned NOT NULL,
`storageEngine` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`storageFormat` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`storageHandle` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified
<<< [85] <query> 96,786 us
>>> [86] <query> CREATE TABLE `file_chunk` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`chunkHandle` binary(12) NOT NULL,
`byteStart` bigint(20) unsigned NOT NULL,
`byteEnd` bigint(20) unsigned NOT NULL,
`dataFilePHID` varbinary(64) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `key_file` (`chunkHandle`,`byteStart`,`byteEnd`),
KEY `key_data` (`dataFilePHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [86] <query> 89,967 us
>>> [87] <query> CREATE TABLE `file_imagemacro` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) DEFAULT NULL,
`filePHID` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`isDisabled` tinyint(1) NOT NULL,
`audioPHID` varbinary(64) DEFAULT NULL,
`audioBehavior` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`mailKey` binary(20) NOT NULL,
P
<<< [87] <query> 113,824 us
>>> [88] <query> 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 DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [88] <query> 54,925 us
>>> [89] <query> CREATE TABLE `file_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE `u
<<< [89] <query> 71,168 us
>>> [90] <query> CREATE TABLE `file_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) unsign
<<< [90] <query> 87,799 us
>>> [91] <query> CREATE TABLE `file_transformedfile` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`originalPHID` varbinary(64) NOT NULL,
`transform` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`transformedPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `originalPHID` (`originalPHID`,`transform`),
KEY `transformedPHID` (`transformedPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [91] <query> 74,335 us
>>> [92] <query> CREATE TABLE `macro_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE `
<<< [92] <query> 80,160 us
>>> [93] <query> CREATE TABLE `macro_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) unsig
<<< [93] <query> 72,949 us
>>> [94] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_flag` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [94] <query> 301 us
>>> [95] <query> USE `testT9773_4100_flag`
<<< [95] <query> 107 us
>>> [96] <query> CREATE TABLE `flag` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ownerPHID` varbinary(64) NOT NULL,
`type` varchar(4) COLLATE `utf8mb4_bin` NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`reasonPHID` varbinary(64) NOT NULL,
`color` int(10) unsigned NOT NULL,
`note` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `ownerPHID` (`ownerPHID`,`type`,`objectPHID`),
KEY `objectPHID
<<< [96] <query> 72,182 us
>>> [97] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_harbormaster` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [97] <query> 506 us
>>> [98] <query> USE `testT9773_4100_harbormaster`
<<< [98] <query> 184 us
>>> [99] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [99] <query> 94,300 us
>>> [100] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [100] <query> 60,192 us
>>> [101] <query> CREATE TABLE `harbormaster_build` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`buildablePHID` varbinary(64) NOT NULL,
`buildPlanPHID` varbinary(64) NOT NULL,
`buildStatus` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`buildGeneration` int(10) unsigned NOT NULL DEFAULT '0',
`planAutoKey` varchar(32) COLLATE `utf8mb4_bin` DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_
<<< [101] <query> 120,820 us
>>> [102] <query> CREATE TABLE `harbormaster_buildable` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`buildablePHID` varbinary(64) NOT NULL,
`containerPHID` varbinary(64) DEFAULT NULL,
`buildableStatus` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`isManualBuildable` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
KEY `key_buildable` (`buildablePHID`),
KEY `key_
<<< [102] <query> 132,571 us
>>> [103] <query> CREATE TABLE `harbormaster_buildabletransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` lo
<<< [103] <query> 91,672 us
>>> [104] <query> CREATE TABLE `harbormaster_buildartifact` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`artifactType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`artifactIndex` binary(12) NOT NULL,
`artifactKey` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`artifactData` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`buildTargetPHID` varbinary(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `
<<< [104] <query> 91,167 us
>>> [105] <query> CREATE TABLE `harbormaster_buildcommand` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`authorPHID` varbinary(64) NOT NULL,
`targetPHID` varbinary(64) NOT NULL,
`command` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `key_target` (`targetPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [105] <query> 75,127 us
>>> [106] <query> CREATE TABLE `harbormaster_buildlintmessage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`buildTargetPHID` varbinary(64) NOT NULL,
`path` longtext COLLATE `utf8mb4_bin` NOT NULL,
`line` int(10) unsigned DEFAULT NULL,
`characterOffset` int(10) unsigned DEFAULT NULL,
`code` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`severity` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`properties` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCre
<<< [106] <query> 71,422 us
>>> [107] <query> CREATE TABLE `harbormaster_buildlog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`logSource` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`logType` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`duration` int(10) unsigned DEFAULT NULL,
`live` tinyint(1) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`buildTargetPHID` varbinary(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
KEY
<<< [107] <query> 88,563 us
>>> [108] <query> CREATE TABLE `harbormaster_buildlogchunk` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`logID` int(10) unsigned NOT NULL,
`encoding` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`size` int(10) unsigned DEFAULT NULL,
`chunk` longblob NOT NULL,
PRIMARY KEY (`id`),
KEY `key_log` (`logID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [108] <query> 74,963 us
>>> [109] <query> CREATE TABLE `harbormaster_buildmessage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`authorPHID` varbinary(64) NOT NULL,
`buildTargetPHID` varbinary(64) NOT NULL,
`type` varchar(16) COLLATE `utf8mb4_bin` NOT NULL,
`isConsumed` tinyint(1) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `key_buildtarget` (`buildTargetPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [109] <query> 78,947 us
>>> [110] <query> CREATE TABLE `harbormaster_buildplan` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(128) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`planStatus` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`planAutoKey` varchar(32) COLLATE `utf8mb4_bin` DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UNIQUE KEY `key_planautokey` (`planAu
<<< [110] <query> 114,032 us
>>> [111] <query> CREATE TABLE `harbormaster_buildplantransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` lo
<<< [111] <query> 78,515 us
>>> [112] <query> CREATE TABLE `harbormaster_buildstep` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`buildPlanPHID` varbinary(64) NOT NULL,
`className` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`details` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`sequence` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT
<<< [112] <query> 90,242 us
>>> [113] <query> CREATE TABLE `harbormaster_buildsteptransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` lo
<<< [113] <query> 80,060 us
>>> [114] <query> CREATE TABLE `harbormaster_buildtarget` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`buildPHID` varbinary(64) NOT NULL,
`buildStepPHID` varbinary(64) NOT NULL,
`className` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`details` longtext COLLATE `utf8mb4_bin` NOT NULL,
`variables` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`targetStatus` varchar(64) COLLATE `utf8mb4_bin` NOT
<<< [114] <query> 84,965 us
>>> [115] <query> CREATE TABLE `harbormaster_buildtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longte
<<< [115] <query> 80,505 us
>>> [116] <query> CREATE TABLE `harbormaster_buildunitmessage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`buildTargetPHID` varbinary(64) NOT NULL,
`engine` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`namespace` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`result` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`duration` double DEFAULT NULL,
`properties` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified
<<< [116] <query> 63,575 us
>>> [117] <query> CREATE TABLE `harbormaster_object` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [117] <query> 55,274 us
>>> [118] <query> CREATE TABLE `harbormaster_scratchtable` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`bigData` longtext COLLATE `utf8mb4_bin`,
`nonmutableData` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `data` (`data`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [118] <query> 62,453 us
>>> [119] <query> CREATE TABLE `lisk_counter` (
`counterName` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`counterValue` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`counterName`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [119] <query> 52,876 us
>>> [120] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_herald` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [120] <query> 371 us
>>> [121] <query> USE `testT9773_4100_herald`
<<< [121] <query> 147 us
>>> [122] <query> CREATE TABLE `herald_action` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ruleID` int(10) unsigned NOT NULL,
`action` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`target` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
KEY `ruleID` (`ruleID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [122] <query> 66,518 us
>>> [123] <query> CREATE TABLE `herald_condition` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ruleID` int(10) unsigned NOT NULL,
`fieldName` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`fieldCondition` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`value` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
KEY `ruleID` (`ruleID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [123] <query> 60,414 us
>>> [124] <query> CREATE TABLE `herald_rule` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`contentType` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`mustMatchAll` tinyint(1) NOT NULL,
`configVersion` int(10) unsigned NOT NULL DEFAULT '1',
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`repetitionPolicy` int(10) unsigned DEFAULT NULL,
`ruleType` varchar(32) COLLATE `utf8mb4_bin`
<<< [124] <query> 75,979 us
>>> [125] <query> CREATE TABLE `herald_ruleapplied` (
`ruleID` int(10) unsigned NOT NULL,
`phid` varbinary(64) NOT NULL,
PRIMARY KEY (`ruleID`,`phid`),
KEY `phid` (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [125] <query> 57,317 us
>>> [126] <query> CREATE TABLE `herald_ruletransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLL
<<< [126] <query> 58,183 us
>>> [127] <query> CREATE TABLE `herald_ruletransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10)
<<< [127] <query> 63,635 us
>>> [128] <query> CREATE TABLE `herald_savedheader` (
`phid` varbinary(64) NOT NULL,
`header` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [128] <query> 44,180 us
>>> [129] <query> CREATE TABLE `herald_transcript` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`time` int(10) unsigned NOT NULL,
`host` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`duration` double NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`dryRun` tinyint(1) NOT NULL,
`objectTranscript` longblob NOT NULL,
`ruleTranscripts` longblob NOT NULL,
`conditionTranscripts` longblob NOT NULL,
`applyTranscripts` longblob NOT NULL,
`garbageCollected` tinyint(1) NOT NULL
<<< [129] <query> 65,977 us
>>> [130] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_maniphest` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [130] <query> 330 us
>>> [131] <query> USE `testT9773_4100_maniphest`
<<< [131] <query> 140 us
>>> [132] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [132] <query> 57,315 us
>>> [133] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [133] <query> 44,449 us
>>> [134] <query> CREATE TABLE `maniphest_customfieldnumericindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`),
KEY `key_find` (`indexKey`,`indexValue`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [134] <query> 54,964 us
>>> [135] <query> CREATE TABLE `maniphest_customfieldstorage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`fieldIndex` binary(12) NOT NULL,
`fieldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [135] <query> 57,222 us
>>> [136] <query> CREATE TABLE `maniphest_customfieldstringindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` longtext CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)),
KEY `key_find` (`indexKey`,`indexValue`(64))
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [136] <query> 57,201 us
>>> [137] <query> CREATE TABLE `maniphest_nameindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`indexedObjectPHID` varbinary(64) NOT NULL,
`indexedObjectName` varchar(128) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`indexedObjectPHID`),
KEY `key_name` (`indexedObjectName`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [137] <query> 60,193 us
>>> [138] <query> CREATE TABLE `maniphest_task` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`ownerPHID` varbinary(64) DEFAULT NULL,
`attached` longtext COLLATE `utf8mb4_bin` NOT NULL,
`status` varchar(12) COLLATE `utf8mb4_bin` NOT NULL,
`priority` int(10) unsigned NOT NULL,
`title` longtext CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`originalTitle` longtext COLLATE `utf8mb4_bin` NOT NULL,
`description` longtext CO
<<< [138] <query> 145,444 us
>>> [139] <query> CREATE TABLE `maniphest_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLA
<<< [139] <query> 89,265 us
>>> [140] <query> CREATE TABLE `maniphest_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) u
<<< [140] <query> 79,883 us
>>> [141] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_meta_data` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [141] <query> 493 us
>>> [142] <query> USE `testT9773_4100_meta_data`
<<< [142] <query> 119 us
>>> [143] <query> CREATE TABLE `patch_status` (
`patch` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`applied` int(10) unsigned NOT NULL,
PRIMARY KEY (`patch`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [143] <query> 47,827 us
>>> [144] <query> INSERT INTO `patch_status` VALUES ('phabricator:000.project.sql',1443545049),('phabricator:0000.legacy.sql',1443545049),('phabricator:001.maniphest_projects.sql',1443545049),('phabricator:002.oauth.sql',1443545049),('phabricator:003.more_oauth.sql',1443545049),('phabricator:004.daemonrepos.sql',1443545049),('phabricator:005.workers.sql',1443545049),('phabricator:006.repository.sql',1443545049),('phabricator:007.daemonlog.sql',1443545049),('phabricator:008.repoopt.sql',1443545049),('phabricator:009.repo_summ
<<< [144] <query> 54,245 us
>>> [145] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_metamta` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [145] <query> 438 us
>>> [146] <query> USE `testT9773_4100_metamta`
<<< [146] <query> 118 us
>>> [147] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [147] <query> 89,524 us
>>> [148] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [148] <query> 63,712 us
>>> [149] <query> CREATE TABLE `metamta_applicationemail` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`applicationPHID` varbinary(64) NOT NULL,
`address` varchar(128) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`configData` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`spacePHID` varbinary(64) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_address` (`address`),
UNIQUE
<<< [149] <query> 10,879 us
>>> [150] <query> CREATE TABLE `metamta_applicationemailtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue`
<<< [150] <query> 86,126 us
>>> [151] <query> CREATE TABLE `metamta_mail` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`actorPHID` varbinary(64) DEFAULT NULL,
`parameters` longtext COLLATE `utf8mb4_bin` NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`message` longtext COLLATE `utf8mb4_bin`,
`relatedPHID` varbinary(64) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
KEY `relatedPH
<<< [151] <query> 110,630 us
>>> [152] <query> CREATE TABLE `metamta_mailinglist` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`email` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`uri` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `phid` (`phid`),
UNIQUE KEY `email` (`email`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHA
<<< [152] <query> 94,556 us
>>> [153] <query> CREATE TABLE `metamta_receivedmail` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`headers` longtext COLLATE `utf8mb4_bin` NOT NULL,
`bodies` longtext COLLATE `utf8mb4_bin` NOT NULL,
`attachments` longtext COLLATE `utf8mb4_bin` NOT NULL,
`relatedPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) DEFAULT NULL,
`message` longtext COLLATE `utf8mb4_bin`,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`messageIDHash` binary(12) NOT NULL,
`sta
<<< [153] <query> 89,342 us
>>> [154] <query> CREATE TABLE `sms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`providerShortName` varchar(16) COLLATE `utf8mb4_bin` NOT NULL,
`providerSMSID` varchar(40) COLLATE `utf8mb4_bin` NOT NULL,
`toNumber` varchar(20) COLLATE `utf8mb4_bin` NOT NULL,
`fromNumber` varchar(20) COLLATE `utf8mb4_bin` DEFAULT NULL,
`body` longtext COLLATE `utf8mb4_bin` NOT NULL,
`sendStatus` varchar(16) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT
<<< [154] <query> 59,905 us
>>> [155] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_oauth_server` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [155] <query> 584 us
>>> [156] <query> USE `testT9773_4100_oauth_server`
<<< [156] <query> 169 us
>>> [157] <query> CREATE TABLE `oauth_server_oauthclientauthorization` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`userPHID` varbinary(64) NOT NULL,
`clientPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`scope` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `phid` (`phid`),
UNIQUE KEY `userPHID` (`userPHID`,`clientPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_
<<< [157] <query> 62,701 us
>>> [158] <query> CREATE TABLE `oauth_server_oauthserveraccesstoken` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`token` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`userPHID` varbinary(64) NOT NULL,
`clientPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [158] <query> 59,897 us
>>> [159] <query> CREATE TABLE `oauth_server_oauthserverauthorizationcode` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`clientPHID` varbinary(64) NOT NULL,
`clientSecret` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`userPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`redirectURI` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB
<<< [159] <query> 58,098 us
>>> [160] <query> CREATE TABLE `oauth_server_oauthserverclient` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`secret` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`redirectURI` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`creatorPHID` varbinary(64) NOT NULL,
`isTrusted` tinyint(1) NOT NULL DEFAULT '0',
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`d
<<< [160] <query> 61,256 us
>>> [161] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_owners` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [161] <query> 392 us
>>> [162] <query> USE `testT9773_4100_owners`
<<< [162] <query> 218 us
>>> [163] <query> CREATE TABLE `owners_customfieldnumericindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`),
KEY `key_find` (`indexKey`,`indexValue`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [163] <query> 66,043 us
>>> [164] <query> CREATE TABLE `owners_customfieldstorage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`fieldIndex` binary(12) NOT NULL,
`fieldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [164] <query> 56,930 us
>>> [165] <query> CREATE TABLE `owners_customfieldstringindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` longtext CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)),
KEY `key_find` (`indexKey`,`indexValue`(64))
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [165] <query> 69,825 us
>>> [166] <query> CREATE TABLE `owners_owner` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`packageID` int(10) unsigned NOT NULL,
`userPHID` varbinary(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `packageID` (`packageID`,`userPHID`),
KEY `userPHID` (`userPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [166] <query> 73,182 us
>>> [167] <query> CREATE TABLE `owners_package` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`originalName` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`primaryOwnerPHID` varbinary(64) DEFAULT NULL,
`auditingEnabled` tinyint(1) NOT NULL DEFAULT '0',
`mailKey` binary(20) NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY
<<< [167] <query> 59,348 us
>>> [168] <query> CREATE TABLE `owners_packagetransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext C
<<< [168] <query> 71,516 us
>>> [169] <query> CREATE TABLE `owners_path` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`packageID` int(10) unsigned NOT NULL,
`repositoryPHID` varbinary(64) NOT NULL,
`path` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`excluded` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `packageID` (`packageID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [169] <query> 54,940 us
>>> [170] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_pastebin` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [170] <query> 285 us
>>> [171] <query> USE `testT9773_4100_pastebin`
<<< [171] <query> 268 us
>>> [172] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [172] <query> 66,756 us
>>> [173] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [173] <query> 51,405 us
>>> [174] <query> CREATE TABLE `pastebin_paste` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`filePHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`language` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`parentPHID` varbinary(64) DEFAULT NULL,
`viewPolicy` varbinary(64) DEFAULT NULL,
`editPolicy` varbinary(64) NOT NULL
<<< [174] <query> 121,593 us
>>> [175] <query> CREATE TABLE `pastebin_pastetransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext C
<<< [175] <query> 80,485 us
>>> [176] <query> CREATE TABLE `pastebin_pastetransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(1
<<< [176] <query> 78,055 us
>>> [177] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_phame` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [177] <query> 642 us
>>> [178] <query> USE `testT9773_4100_phame`
<<< [178] <query> 261 us
>>> [179] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [179] <query> 74,764 us
>>> [180] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [180] <query> 59,940 us
>>> [181] <query> CREATE TABLE `phame_blog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`domain` varchar(128) COLLATE `utf8mb4_bin` DEFAULT NULL,
`configData` longtext COLLATE `utf8mb4_bin` NOT NULL,
`creatorPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`viewPolicy` varbinary(64) DEFAULT NULL,
`edi
<<< [181] <query> 72,848 us
>>> [182] <query> CREATE TABLE `phame_blogtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLA
<<< [182] <query> 83,189 us
>>> [183] <query> CREATE TABLE `phame_post` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`bloggerPHID` varbinary(64) NOT NULL,
`title` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`phameTitle` varchar(64) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`body` longtext COLLATE `utf8mb4_bin`,
`visibility` int(10) unsigned NOT NULL DEFAULT '0',
`configData` longtext COLLATE `utf8mb4_bin`,
`datePublished` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsign
<<< [183] <query> 84,064 us
>>> [184] <query> CREATE TABLE `phame_posttransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLA
<<< [184] <query> 64,630 us
>>> [185] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_phriction` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [185] <query> 553 us
>>> [186] <query> USE `testT9773_4100_phriction`
<<< [186] <query> 133 us
>>> [187] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [187] <query> 66,964 us
>>> [188] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [188] <query> 44,436 us
>>> [189] <query> CREATE TABLE `phriction_content` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`documentID` int(10) unsigned NOT NULL,
`version` int(10) unsigned NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`title` longtext CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`slug` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`description` longtext COLLATE
<<< [189] <query> 66,087 us
>>> [190] <query> CREATE TABLE `phriction_document` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`slug` varchar(128) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`depth` int(10) unsigned NOT NULL,
`contentID` int(10) unsigned DEFAULT NULL,
`status` int(10) unsigned NOT NULL DEFAULT '0',
`mailKey` binary(20) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `phid` (`phid`),
UNIQUE KEY `
<<< [190] <query> 68,548 us
>>> [191] <query> CREATE TABLE `phriction_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLA
<<< [191] <query> 58,686 us
>>> [192] <query> CREATE TABLE `phriction_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) u
<<< [192] <query> 59,073 us
>>> [193] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_project` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [193] <query> 380 us
>>> [194] <query> USE `testT9773_4100_project`
<<< [194] <query> 345 us
>>> [195] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [195] <query> 57,385 us
>>> [196] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [196] <query> 45,078 us
>>> [197] <query> CREATE TABLE `project` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`subprojectPHIDs` longtext COLLATE `utf8mb4_bin` NOT NULL,
`phrictionSlug` varchar(128) COLLATE `utf8mb4_bin` DEFAULT NULL,
`viewPoli
<<< [197] <query> 76,693 us
>>> [198] <query> CREATE TABLE `project_column` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`status` int(10) unsigned NOT NULL,
`sequence` int(10) unsigned NOT NULL,
`projectPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`properties` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
KEY `key_status` (`projec
<<< [198] <query> 63,672 us
>>> [199] <query> CREATE TABLE `project_columnposition` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`boardPHID` varbinary(64) NOT NULL,
`columnPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`sequence` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `boardPHID` (`boardPHID`,`columnPHID`,`objectPHID`),
KEY `objectPHID` (`objectPHID`,`boardPHID`),
KEY `boardPHID_2` (`boardPHID`,`columnPHID`,`sequence`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [199] <query> 63,035 us
>>> [200] <query> CREATE TABLE `project_columntransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext C
<<< [200] <query> 64,198 us
>>> [201] <query> CREATE TABLE `project_customfieldnumericindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`),
KEY `key_find` (`indexKey`,`indexValue`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [201] <query> 57,728 us
>>> [202] <query> CREATE TABLE `project_customfieldstorage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`fieldIndex` binary(12) NOT NULL,
`fieldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [202] <query> 57,143 us
>>> [203] <query> CREATE TABLE `project_customfieldstringindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` longtext CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)),
KEY `key_find` (`indexKey`,`indexValue`(64))
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [203] <query> 63,850 us
>>> [204] <query> CREATE TABLE `project_datasourcetoken` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`projectID` int(10) unsigned NOT NULL,
`token` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `token` (`token`,`projectID`),
KEY `projectID` (`projectID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [204] <query> 88,310 us
>>> [205] <query> CREATE TABLE `project_slug` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`projectPHID` varbinary(64) NOT NULL,
`slug` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_slug` (`slug`),
KEY `key_projectPHID` (`projectPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [205] <query> 76,977 us
>>> [206] <query> CREATE TABLE `project_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE
<<< [206] <query> 75,078 us
>>> [207] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_repository` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [207] <query> 362 us
>>> [208] <query> USE `testT9773_4100_repository`
<<< [208] <query> 150 us
>>> [209] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [209] <query> 57,902 us
>>> [210] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [210] <query> 50,312 us
>>> [211] <query> CREATE TABLE `repository` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`callsign` varchar(32) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`versionControlSystem` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`details` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`uuid` varchar(64)
<<< [211] <query> 110,626 us
>>> [212] <query> CREATE TABLE `repository_auditrequest` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`auditorPHID` varbinary(64) NOT NULL,
`commitPHID` varbinary(64) NOT NULL,
`auditStatus` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`auditReasons` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_unique` (`commitPHID`,`auditorPHID`),
KEY `commitPHID` (`commitPHID`),
KEY `auditorPHID` (`auditorPHID`,`auditStatus`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin
<<< [212] <query> 98,026 us
>>> [213] <query> CREATE TABLE `repository_badcommit` (
`fullCommitName` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`fullCommitName`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [213] <query> 65,177 us
>>> [214] <query> CREATE TABLE `repository_branch` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`repositoryID` int(10) unsigned NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`lintCommit` varchar(40) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `repositoryID` (`repositoryID`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [214] <query> 74,712 us
>>> [215] <query> CREATE TABLE `repository_commit` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`repositoryID` int(10) unsigned NOT NULL,
`phid` varbinary(64) NOT NULL,
`commitIdentifier` varchar(40) COLLATE `utf8mb4_bin` NOT NULL,
`epoch` int(10) unsigned NOT NULL,
`mailKey` binary(20) NOT NULL,
`authorPHID` varbinary(64) DEFAULT NULL,
`auditStatus` int(10) unsigned NOT NULL,
`summary` varchar(80) COLLATE `utf8mb4_bin` NOT NULL,
`importStatus` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE
<<< [215] <query> 121,294 us
>>> [216] <query> CREATE TABLE `repository_commitdata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`commitID` int(10) unsigned NOT NULL,
`authorName` longtext COLLATE `utf8mb4_bin` NOT NULL,
`commitMessage` longtext COLLATE `utf8mb4_bin` NOT NULL,
`commitDetails` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `commitID` (`commitID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [216] <query> 59,337 us
>>> [217] <query> CREATE TABLE `repository_coverage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`branchID` int(10) unsigned NOT NULL,
`commitID` int(10) unsigned NOT NULL,
`pathID` int(10) unsigned NOT NULL,
`coverage` longblob NOT NULL,
PRIMARY KEY (`id`),
KEY `key_path` (`branchID`,`pathID`,`commitID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [217] <query> 62,034 us
>>> [218] <query> CREATE TABLE `repository_filesystem` (
`repositoryID` int(10) unsigned NOT NULL,
`parentID` int(10) unsigned NOT NULL,
`svnCommit` int(10) unsigned NOT NULL,
`pathID` int(10) unsigned NOT NULL,
`existed` tinyint(1) NOT NULL,
`fileType` int(10) unsigned NOT NULL,
PRIMARY KEY (`repositoryID`,`parentID`,`pathID`,`svnCommit`),
KEY `repositoryID` (`repositoryID`,`svnCommit`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [218] <query> 54,888 us
>>> [219] <query> CREATE TABLE `repository_lintmessage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`branchID` int(10) unsigned NOT NULL,
`path` longtext COLLATE `utf8mb4_bin` NOT NULL,
`line` int(10) unsigned NOT NULL,
`authorPHID` varbinary(64) DEFAULT NULL,
`code` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`severity` varchar(16) COLLATE `utf8mb4_bin` NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
KEY `bran
<<< [219] <query> 79,890 us
>>> [220] <query> CREATE TABLE `repository_mirror` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`repositoryPHID` varbinary(64) NOT NULL,
`remoteURI` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`credentialPHID` varbinary(64) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
KEY `key_repository` (`repositoryPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bi
<<< [220] <query> 67,461 us
>>> [221] <query> CREATE TABLE `repository_parents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`childCommitID` int(10) unsigned NOT NULL,
`parentCommitID` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_child` (`childCommitID`,`parentCommitID`),
KEY `key_parent` (`parentCommitID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [221] <query> 68,555 us
>>> [222] <query> CREATE TABLE `repository_path` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`path` longtext COLLATE `utf8mb4_bin` NOT NULL,
`pathHash` binary(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pathHash` (`pathHash`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [222] <query> 58,696 us
>>> [223] <query> CREATE TABLE `repository_pathchange` (
`repositoryID` int(10) unsigned NOT NULL,
`pathID` int(10) unsigned NOT NULL,
`commitID` int(10) unsigned NOT NULL,
`targetPathID` int(10) unsigned DEFAULT NULL,
`targetCommitID` int(10) unsigned DEFAULT NULL,
`changeType` int(10) unsigned NOT NULL,
`fileType` int(10) unsigned NOT NULL,
`isDirect` tinyint(1) NOT NULL,
`commitSequence` int(10) unsigned NOT NULL,
PRIMARY KEY (`commitID`,`pathID`),
KEY `repositoryID` (`repositoryID`,`pathID`,`commitS
<<< [223] <query> 56,504 us
>>> [224] <query> CREATE TABLE `repository_pushevent` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`repositoryPHID` varbinary(64) NOT NULL,
`epoch` int(10) unsigned NOT NULL,
`pusherPHID` varbinary(64) NOT NULL,
`remoteAddress` int(10) unsigned DEFAULT NULL,
`remoteProtocol` varchar(32) COLLATE `utf8mb4_bin` DEFAULT NULL,
`rejectCode` int(10) unsigned NOT NULL,
`rejectDetails` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`p
<<< [224] <query> 60,405 us
>>> [225] <query> CREATE TABLE `repository_pushlog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`epoch` int(10) unsigned NOT NULL,
`pushEventPHID` varbinary(64) NOT NULL,
`repositoryPHID` varbinary(64) NOT NULL,
`pusherPHID` varbinary(64) NOT NULL,
`refType` varchar(12) COLLATE `utf8mb4_bin` NOT NULL,
`refNameHash` binary(12) DEFAULT NULL,
`refNameRaw` longblob,
`refNameEncoding` varchar(16) COLLATE `utf8mb4_bin` DEFAULT NULL,
`refOld` varchar(40) COLLATE `utf8mb4_bin
<<< [225] <query> 83,360 us
>>> [226] <query> CREATE TABLE `repository_refcursor` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`repositoryPHID` varbinary(64) NOT NULL,
`refType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`refNameHash` binary(12) NOT NULL,
`refNameRaw` longblob NOT NULL,
`refNameEncoding` varchar(16) COLLATE `utf8mb4_bin` DEFAULT NULL,
`commitIdentifier` varchar(40) COLLATE `utf8mb4_bin` NOT NULL,
`isClosed` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `key_cursor` (`repositoryPHID`,`refType`,`refNameHash`)
) EN
<<< [226] <query> 51,219 us
>>> [227] <query> CREATE TABLE `repository_statusmessage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`repositoryID` int(10) unsigned NOT NULL,
`statusType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`statusCode` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`parameters` longtext COLLATE `utf8mb4_bin` NOT NULL,
`epoch` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `repositoryID` (`repositoryID`,`statusType`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [227] <query> 58,315 us
>>> [228] <query> CREATE TABLE `repository_summary` (
`repositoryID` int(10) unsigned NOT NULL,
`size` int(10) unsigned NOT NULL,
`lastCommitID` int(10) unsigned NOT NULL,
`epoch` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`repositoryID`),
KEY `key_epoch` (`epoch`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [228] <query> 64,510 us
>>> [229] <query> CREATE TABLE `repository_symbol` (
`repositoryPHID` varbinary(64) NOT NULL,
`symbolContext` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`symbolName` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`symbolType` varchar(12) COLLATE `utf8mb4_bin` NOT NULL,
`symbolLanguage` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`pathID` int(10) unsigned NOT NULL,
`lineNumber` int(10) unsigned NOT NULL,
KEY `symbolName` (`symbolName`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [229] <query> 55,033 us
>>> [230] <query> CREATE TABLE `repository_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLL
<<< [230] <query> 83,449 us
>>> [231] <query> CREATE TABLE `repository_vcspassword` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userPHID` varbinary(64) NOT NULL,
`passwordHash` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`userPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [231] <query> 75,520 us
>>> [232] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_search` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [232] <query> 510 us
>>> [233] <query> USE `testT9773_4100_search`
<<< [233] <query> 225 us
>>> [234] <query> CREATE TABLE `search_document` (
`phid` varbinary(64) NOT NULL,
`documentType` varchar(4) COLLATE `utf8mb4_bin` NOT NULL,
`documentTitle` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`documentCreated` int(10) unsigned NOT NULL,
`documentModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`phid`),
KEY `documentCreated` (`documentCreated`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [234] <query> 72,658 us
>>> [235] <query> CREATE TABLE `search_documentfield` (
`phid` varbinary(64) NOT NULL,
`phidType` varchar(4) COLLATE `utf8mb4_bin` NOT NULL,
`field` varchar(4) COLLATE `utf8mb4_bin` NOT NULL,
`auxPHID` varbinary(64) DEFAULT NULL,
`corpus` longtext CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci`,
KEY `phid` (`phid`),
FULLTEXT KEY `corpus` (`corpus`)
) ENGINE=MyISAM DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [235] <query> 9,268 us
>>> [236] <query> CREATE TABLE `search_documentrelationship` (
`phid` varbinary(64) NOT NULL,
`relatedPHID` varbinary(64) NOT NULL,
`relation` varchar(4) COLLATE `utf8mb4_bin` NOT NULL,
`relatedType` varchar(4) COLLATE `utf8mb4_bin` NOT NULL,
`relatedTime` int(10) unsigned NOT NULL,
KEY `phid` (`phid`),
KEY `relatedPHID` (`relatedPHID`,`relation`),
KEY `relation` (`relation`,`relatedPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [236] <query> 79,956 us
>>> [237] <query> CREATE TABLE `search_namedquery` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userPHID` varbinary(64) NOT NULL,
`engineClassName` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`queryName` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`queryKey` varchar(12) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`isBuiltin` tinyint(1) NOT NULL DEFAULT '0',
`isDisabled` tinyint(1) NOT NULL DEFAULT '0',
`sequence` int(10) unsigne
<<< [237] <query> 71,857 us
>>> [238] <query> CREATE TABLE `search_savedquery` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`engineClassName` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`parameters` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`queryKey` varchar(12) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_queryKey` (`queryKey`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [238] <query> 59,539 us
>>> [239] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_slowvote` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [239] <query> 260 us
>>> [240] <query> USE `testT9773_4100_slowvote`
<<< [240] <query> 102 us
>>> [241] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [241] <query> 84,385 us
>>> [242] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [242] <query> 64,368 us
>>> [243] <query> CREATE TABLE `slowvote_choice` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pollID` int(10) unsigned NOT NULL,
`optionID` int(10) unsigned NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `pollID` (`pollID`),
KEY `authorPHID` (`authorPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [243] <query> 72,057 us
>>> [244] <query> CREATE TABLE `slowvote_option` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pollID` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `pollID` (`pollID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [244] <query> 60,681 us
>>> [245] <query> CREATE TABLE `slowvote_poll` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`question` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`responseVisibility` int(10) unsigned NOT NULL,
`shuffle` int(10) unsigned NOT NULL,
`method` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NO
<<< [245] <query> 77,599 us
>>> [246] <query> CREATE TABLE `slowvote_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLAT
<<< [246] <query> 59,954 us
>>> [247] <query> CREATE TABLE `slowvote_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) un
<<< [247] <query> 64,388 us
>>> [248] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_user` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [248] <query> 503 us
>>> [249] <query> USE `testT9773_4100_user`
<<< [249] <query> 113 us
>>> [250] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [250] <query> 77,558 us
>>> [251] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [251] <query> 47,290 us
>>> [252] <query> CREATE TABLE `phabricator_session` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userPHID` varbinary(64) NOT NULL,
`type` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`sessionKey` binary(40) NOT NULL,
`sessionStart` int(10) unsigned NOT NULL,
`sessionExpires` int(10) unsigned NOT NULL,
`highSecurityUntil` int(10) unsigned DEFAULT NULL,
`isPartial` tinyint(1) NOT NULL DEFAULT '0',
`signedLegalpadDocuments` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `sessionKey` (
<<< [252] <query> 82,101 us
>>> [253] <query> CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`userName` varchar(64) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`realName` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`sex` varchar(4) COLLATE `utf8mb4_bin` DEFAULT NULL,
`translation` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
`passwordSalt` varchar(32) COLLATE `utf8mb4_bin` DEFAULT NULL,
`passwordHash` varchar(128) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dateCreat
<<< [253] <query> 80,221 us
>>> [254] <query> CREATE TABLE `user_authinvite` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`authorPHID` varbinary(64) NOT NULL,
`emailAddress` varchar(128) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`verificationHash` binary(12) NOT NULL,
`acceptedByPHID` varbinary(64) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`phid` varbinary(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_address` (`emailAddress`),
UNIQUE KEY `key_code
<<< [254] <query> 69,118 us
>>> [255] <query> CREATE TABLE `user_configuredcustomfieldstorage` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`fieldIndex` binary(12) NOT NULL,
`fieldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [255] <query> 55,562 us
>>> [256] <query> CREATE TABLE `user_customfieldnumericindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`),
KEY `key_find` (`indexKey`,`indexValue`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [256] <query> 68,699 us
>>> [257] <query> CREATE TABLE `user_customfieldstringindex` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`indexKey` binary(12) NOT NULL,
`indexValue` longtext CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
PRIMARY KEY (`id`),
KEY `key_join` (`objectPHID`,`indexKey`,`indexValue`(64)),
KEY `key_find` (`indexKey`,`indexValue`(64))
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [257] <query> 61,784 us
>>> [258] <query> CREATE TABLE `user_email` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userPHID` varbinary(64) NOT NULL,
`address` varchar(128) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`isVerified` tinyint(1) NOT NULL DEFAULT '0',
`isPrimary` tinyint(1) NOT NULL DEFAULT '0',
`verificationCode` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `address` (`address`),
<<< [258] <query> 63,274 us
>>> [259] <query> CREATE TABLE `user_externalaccount` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`userPHID` varbinary(64) DEFAULT NULL,
`accountType` varchar(16) COLLATE `utf8mb4_bin` NOT NULL,
`accountDomain` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`accountSecret` longtext COLLATE `utf8mb4_bin`,
`accountID` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`displayName` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModifi
<<< [259] <query> 72,720 us
>>> [260] <query> CREATE TABLE `user_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`actorPHID` varbinary(64) DEFAULT NULL,
`userPHID` varbinary(64) NOT NULL,
`action` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`details` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`remoteAddr` varchar(64) COLLATE `utf8mb4_bin` NOT NU
<<< [260] <query> 114,484 us
>>> [261] <query> CREATE TABLE `user_nametoken` (
`token` varchar(255) CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
`userID` int(10) unsigned NOT NULL,
KEY `token` (`token`(128)),
KEY `userID` (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [261] <query> 58,167 us
>>> [262] <query> CREATE TABLE `user_preferences` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userPHID` varbinary(64) NOT NULL,
`preferences` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `userPHID` (`userPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [262] <query> 63,177 us
>>> [263] <query> CREATE TABLE `user_profile` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userPHID` varbinary(64) NOT NULL,
`title` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`blurb` longtext COLLATE `utf8mb4_bin` NOT NULL,
`profileImagePHID` varbinary(64) 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=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [263] <query> 75,089 us
>>> [264] <query> CREATE TABLE `user_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE `u
<<< [264] <query> 77,440 us
>>> [265] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_worker` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [265] <query> 285 us
>>> [266] <query> USE `testT9773_4100_worker`
<<< [266] <query> 154 us
>>> [267] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [267] <query> 79,707 us
>>> [268] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [268] <query> 59,767 us
>>> [269] <query> CREATE TABLE `lisk_counter` (
`counterName` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`counterValue` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`counterName`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [269] <query> 69,346 us
>>> [270] <query> INSERT INTO `lisk_counter` VALUES ('worker_activetask',2)
<<< [270] <query> 11,058 us
>>> [271] <query> CREATE TABLE `worker_activetask` (
`id` int(10) unsigned NOT NULL,
`taskClass` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`leaseOwner` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
`leaseExpires` int(10) unsigned DEFAULT NULL,
`failureCount` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
`failureTime` int(10) unsigned DEFAULT NULL,
`priority` int(10) unsigned NOT NULL,
`objectPHID` varbinary(64) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `dataID` (`dataID`),
<<< [271] <query> 141,787 us
>>> [272] <query> CREATE TABLE `worker_archivetask` (
`id` int(10) unsigned NOT NULL,
`taskClass` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`leaseOwner` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
`leaseExpires` int(10) unsigned DEFAULT NULL,
`failureCount` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned NOT NULL,
`result` int(10) unsigned NOT NULL,
`duration` bigint(20) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`priority` int(10) un
<<< [272] <query> 98,694 us
>>> [273] <query> CREATE TABLE `worker_bulkjob` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`jobTypeKey` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`parameters` longtext COLLATE `utf8mb4_bin` NOT NULL,
`size` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
KEY `key
<<< [273] <query> 96,366 us
>>> [274] <query> CREATE TABLE `worker_bulkjobtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext C
<<< [274] <query> 73,325 us
>>> [275] <query> CREATE TABLE `worker_bulktask` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`bulkJobPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
KEY `key_job` (`bulkJobPHID`,`status`),
KEY `key_object` (`objectPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [275] <query> 86,737 us
>>> [276] <query> CREATE TABLE `worker_taskdata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [276] <query> 57,363 us
>>> [277] <query> CREATE TABLE `worker_trigger` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`triggerVersion` int(10) unsigned NOT NULL,
`clockClass` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`clockProperties` longtext COLLATE `utf8mb4_bin` NOT NULL,
`actionClass` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`actionProperties` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UNIQUE KEY `key_trigger` (`triggerVersion`)
) ENGINE
<<< [277] <query> 81,578 us
>>> [278] <query> CREATE TABLE `worker_triggerevent` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`triggerID` int(10) unsigned NOT NULL,
`lastEventEpoch` int(10) unsigned DEFAULT NULL,
`nextEventEpoch` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_trigger` (`triggerID`),
KEY `key_next` (`nextEventEpoch`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [278] <query> 88,058 us
>>> [279] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_xhpastview` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [279] <query> 340 us
>>> [280] <query> USE `testT9773_4100_xhpastview`
<<< [280] <query> 109 us
>>> [281] <query> CREATE TABLE `xhpastview_parsetree` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`authorPHID` varbinary(64) DEFAULT NULL,
`input` longtext COLLATE `utf8mb4_bin` NOT NULL,
`stdout` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [281] <query> 63,562 us
>>> [282] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_cache` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [282] <query> 608 us
>>> [283] <query> USE `testT9773_4100_cache`
<<< [283] <query> 160 us
>>> [284] <query> CREATE TABLE `cache_general` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`cacheKeyHash` binary(12) NOT NULL,
`cacheKey` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`cacheFormat` varchar(16) COLLATE `utf8mb4_bin` NOT NULL,
`cacheData` longblob NOT NULL,
`cacheCreated` int(10) unsigned NOT NULL,
`cacheExpires` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_cacheKeyHash` (`cacheKeyHash`),
KEY `key_cacheCreated` (`cacheCreated`),
KEY `key_ttl` (`cacheExpires`)
<<< [284] <query> 88,227 us
>>> [285] <query> CREATE TABLE `cache_markupcache` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cacheKey` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`cacheData` longblob NOT NULL,
`metadata` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `cacheKey` (`cacheKey`),
KEY `dateCreated` (`dateCreated`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [285] <query> 73,104 us
>>> [286] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_fact` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [286] <query> 334 us
>>> [287] <query> USE `testT9773_4100_fact`
<<< [287] <query> 136 us
>>> [288] <query> CREATE TABLE `fact_aggregate` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`factType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`valueX` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `factType` (`factType`,`objectPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [288] <query> 88,995 us
>>> [289] <query> CREATE TABLE `fact_cursor` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`position` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [289] <query> 71,168 us
>>> [290] <query> CREATE TABLE `fact_raw` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`factType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`objectA` varbinary(64) NOT NULL,
`valueX` bigint(20) NOT NULL,
`valueY` bigint(20) NOT NULL,
`epoch` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `objectPHID` (`objectPHID`),
KEY `factType` (`factType`,`epoch`),
KEY `factType_2` (`factType`,`objectA`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [290] <query> 88,402 us
>>> [291] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_ponder` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [291] <query> 436 us
>>> [292] <query> USE `testT9773_4100_ponder`
<<< [292] <query> 171 us
>>> [293] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [293] <query> 83,095 us
>>> [294] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [294] <query> 57,940 us
>>> [295] <query> CREATE TABLE `ponder_answer` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`questionID` int(10) unsigned NOT NULL,
`phid` varbinary(64) NOT NULL,
`voteCount` int(10) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`mailKey` binary(20) NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `phid` (`phid`),
UNIQ
<<< [295] <query> 97,787 us
>>> [296] <query> CREATE TABLE `ponder_answertransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext CO
<<< [296] <query> 74,119 us
>>> [297] <query> CREATE TABLE `ponder_answertransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10
<<< [297] <query> 82,499 us
>>> [298] <query> CREATE TABLE `ponder_question` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin`,
`answerCount` int(10) unsigned NOT NULL,
`mailKey` bin
<<< [298] <query> 106,597 us
>>> [299] <query> CREATE TABLE `ponder_questiontransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [299] <query> 81,571 us
>>> [300] <query> CREATE TABLE `ponder_questiontransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(
<<< [300] <query> 76,561 us
>>> [301] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_xhprof` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [301] <query> 247 us
>>> [302] <query> USE `testT9773_4100_xhprof`
<<< [302] <query> 103 us
>>> [303] <query> CREATE TABLE `xhprof_sample` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`filePHID` varbinary(64) NOT NULL,
`sampleRate` int(10) unsigned NOT NULL,
`usTotal` bigint(20) unsigned NOT NULL,
`hostname` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`requestPath` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`controller` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`userPHID` varbinary(64) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NO
<<< [303] <query> 63,627 us
>>> [304] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_pholio` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [304] <query> 280 us
>>> [305] <query> USE `testT9773_4100_pholio`
<<< [305] <query> 97 us
>>> [306] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [306] <query> 88,007 us
>>> [307] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [307] <query> 65,184 us
>>> [308] <query> CREATE TABLE `pholio_image` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`mockID` int(10) unsigned DEFAULT NULL,
`filePHID` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`sequence` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`isObsolete` tinyint(1) NOT NULL DEFAULT '0',
`replacesImagePHID` varbinary(64)
<<< [308] <query> 81,635 us
>>> [309] <query> CREATE TABLE `pholio_mock` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`originalName` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`coverPHID` varbinary(64) NOT NULL,
`mailKey` binary(20) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NO
<<< [309] <query> 102,054 us
>>> [310] <query> CREATE TABLE `pholio_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE
<<< [310] <query> 92,410 us
>>> [311] <query> CREATE TABLE `pholio_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) unsi
<<< [311] <query> 81,007 us
>>> [312] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_conpherence` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [312] <query> 1,991 us
>>> [313] <query> USE `testT9773_4100_conpherence`
<<< [313] <query> 203 us
>>> [314] <query> CREATE TABLE `conpherence_index` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`threadPHID` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) NOT NULL,
`previousTransactionPHID` varbinary(64) DEFAULT NULL,
`corpus` longtext CHARACTER SET `utf8mb4` COLLATE `utf8mb4_unicode_ci` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_transaction` (`transactionPHID`),
UNIQUE KEY `key_previous` (`previousTransactionPHID`),
KEY `key_thread` (`threadPHID`),
FULLTEXT KEY `key_corpus` (`corpus`)
)
<<< [314] <query> 9,856 us
>>> [315] <query> CREATE TABLE `conpherence_participant` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`participantPHID` varbinary(64) NOT NULL,
`conpherencePHID` varbinary(64) NOT NULL,
`participationStatus` int(10) unsigned NOT NULL DEFAULT '0',
`dateTouched` int(10) unsigned NOT NULL,
`behindTransactionPHID` varbinary(64) NOT NULL,
`seenMessageCount` bigint(20) unsigned NOT NULL,
`settings` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsig
<<< [315] <query> 82,762 us
>>> [316] <query> CREATE TABLE `conpherence_thread` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`title` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`imagePHIDs` longtext COLLATE `utf8mb4_bin` NOT NULL,
`messageCount` bigint(20) unsigned NOT NULL,
`recentParticipantPHIDs` longtext COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`joinPolicy` varbinary(64) NOT NULL,
`mailKey` varchar(20) COLLATE `utf8mb4_bin` N
<<< [316] <query> 65,135 us
>>> [317] <query> CREATE TABLE `conpherence_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COL
<<< [317] <query> 80,394 us
>>> [318] <query> CREATE TABLE `conpherence_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10)
<<< [318] <query> 86,409 us
>>> [319] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [319] <query> 65,079 us
>>> [320] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [320] <query> 51,661 us
>>> [321] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_config` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [321] <query> 519 us
>>> [322] <query> USE `testT9773_4100_config`
<<< [322] <query> 159 us
>>> [323] <query> CREATE TABLE `config_entry` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`namespace` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`configKey` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`value` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UNIQUE KEY `key_name` (`namespace`,`configKey`)
) ENG
<<< [323] <query> 62,435 us
>>> [324] <query> CREATE TABLE `config_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE
<<< [324] <query> 74,441 us
>>> [325] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_token` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [325] <query> 302 us
>>> [326] <query> USE `testT9773_4100_token`
<<< [326] <query> 135 us
>>> [327] <query> CREATE TABLE `token_count` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`tokenCount` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_objectPHID` (`objectPHID`),
KEY `key_count` (`tokenCount`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [327] <query> 56,891 us
>>> [328] <query> CREATE TABLE `token_given` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`tokenPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_all` (`objectPHID`,`authorPHID`),
KEY `key_author` (`authorPHID`),
KEY `key_token` (`tokenPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [328] <query> 68,228 us
>>> [329] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_releeph` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [329] <query> 467 us
>>> [330] <query> USE `testT9773_4100_releeph`
<<< [330] <query> 118 us
>>> [331] <query> CREATE TABLE `releeph_branch` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`basename` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`releephProjectID` int(10) unsigned NOT NULL,
`createdByUserPHID` varbinary(64) NOT NULL,
`cutPointCommitPHID` varbinary(64) NOT NULL,
`isActive` tinyint(1) NOT NULL DEFAULT '1',
`symbolicName` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
`details` longtext COLLATE `utf8m
<<< [331] <query> 83,580 us
>>> [332] <query> CREATE TABLE `releeph_branchtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext C
<<< [332] <query> 63,975 us
>>> [333] <query> CREATE TABLE `releeph_producttransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [333] <query> 71,840 us
>>> [334] <query> CREATE TABLE `releeph_project` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`phid` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`trunkBranch` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`repositoryPHID` varbinary(64) NOT NULL,
`createdByUserPHID` varbinary(64) NOT NULL,
`isActive` tinyint(1) NOT NULL DEFAULT '1',
`details` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMA
<<< [334] <query> 79,894 us
>>> [335] <query> CREATE TABLE `releeph_request` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`phid` varbinary(64) NOT NULL,
`branchID` int(10) unsigned NOT NULL,
`requestUserPHID` varbinary(64) NOT NULL,
`requestCommitPHID` varbinary(64) DEFAULT NULL,
`commitIdentifier` varchar(40) COLLATE `utf8mb4_bin` DEFAULT NULL,
`commitPHID` varbinary(64) DEFAULT NULL,
`pickStatus` int(10) unsigned DEFAULT NULL,
`details` longte
<<< [335] <query> 90,433 us
>>> [336] <query> CREATE TABLE `releeph_requesttransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [336] <query> 77,651 us
>>> [337] <query> CREATE TABLE `releeph_requesttransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(
<<< [337] <query> 76,913 us
>>> [338] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_phlux` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [338] <query> 402 us
>>> [339] <query> USE `testT9773_4100_phlux`
<<< [339] <query> 164 us
>>> [340] <query> CREATE TABLE `phlux_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE `
<<< [340] <query> 86,507 us
>>> [341] <query> CREATE TABLE `phlux_variable` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`variableKey` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`variableValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UNIQUE KEY `key_key` (`variableKey`)
) ENGINE=InnoDB DEF
<<< [341] <query> 85,376 us
>>> [342] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_phortune` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [342] <query> 426 us
>>> [343] <query> USE `testT9773_4100_phortune`
<<< [343] <query> 128 us
>>> [344] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [344] <query> 73,654 us
>>> [345] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [345] <query> 58,168 us
>>> [346] <query> CREATE TABLE `phortune_account` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [346] <query> 78,947 us
>>> [347] <query> CREATE TABLE `phortune_accounttransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [347] <query> 71,697 us
>>> [348] <query> CREATE TABLE `phortune_cart` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`accountPHID` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`metadata` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`cartClass` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`merchantPHID` varbinary(64) NOT NULL,
`mailKey` binary(20) N
<<< [348] <query> 93,117 us
>>> [349] <query> CREATE TABLE `phortune_carttransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext CO
<<< [349] <query> 64,765 us
>>> [350] <query> CREATE TABLE `phortune_charge` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`accountPHID` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`cartPHID` varbinary(64) NOT NULL,
`paymentMethodPHID` varbinary(64) DEFAULT NULL,
`amountAsCurrency` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`metadata` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModifie
<<< [350] <query> 92,253 us
>>> [351] <query> CREATE TABLE `phortune_merchant` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [351] <query> 51,144 us
>>> [352] <query> CREATE TABLE `phortune_merchanttransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtex
<<< [352] <query> 57,953 us
>>> [353] <query> CREATE TABLE `phortune_paymentmethod` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`status` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`accountPHID` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`metadata` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`brand` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`expi
<<< [353] <query> 65,511 us
>>> [354] <query> CREATE TABLE `phortune_paymentproviderconfig` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`merchantPHID` varbinary(64) NOT NULL,
`providerClassKey` binary(12) NOT NULL,
`providerClass` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`metadata` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`isEnabled` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UN
<<< [354] <query> 65,098 us
>>> [355] <query> CREATE TABLE `phortune_paymentproviderconfigtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newV
<<< [355] <query> 59,362 us
>>> [356] <query> CREATE TABLE `phortune_product` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`metadata` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`productClassKey` binary(12) NOT NULL,
`productClass` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`productRefKey` binary(12) NOT NULL,
`productRef` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`
<<< [356] <query> 57,615 us
>>> [357] <query> CREATE TABLE `phortune_purchase` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`productPHID` varbinary(64) NOT NULL,
`accountPHID` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`cartPHID` varbinary(64) DEFAULT NULL,
`basePriceAsCurrency` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`quantity` int(10) unsigned NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`metadata` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` in
<<< [357] <query> 63,714 us
>>> [358] <query> CREATE TABLE `phortune_subscription` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`accountPHID` varbinary(64) NOT NULL,
`merchantPHID` varbinary(64) NOT NULL,
`triggerPHID` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`subscriptionClassKey` binary(12) NOT NULL,
`subscriptionClass` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`subscriptionRefKey` binary(12) NOT NULL,
`subscriptionRef` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`status
<<< [358] <query> 79,332 us
>>> [359] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_phrequent` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [359] <query> 571 us
>>> [360] <query> USE `testT9773_4100_phrequent`
<<< [360] <query> 129 us
>>> [361] <query> CREATE TABLE `phrequent_usertime` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) DEFAULT NULL,
`note` longtext COLLATE `utf8mb4_bin`,
`dateStarted` int(10) unsigned NOT NULL,
`dateEnded` int(10) unsigned DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [361] <query> 46,154 us
>>> [362] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_diviner` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [362] <query> 414 us
>>> [363] <query> USE `testT9773_4100_diviner`
<<< [363] <query> 123 us
>>> [364] <query> CREATE TABLE `diviner_liveatom` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`symbolPHID` varbinary(64) NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`atomData` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `symbolPHID` (`symbolPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [364] <query> 51,466 us
>>> [365] <query> CREATE TABLE `diviner_livebook` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`repositoryPHID` varbinary(64) DEFAULT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`configurationData` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `ph
<<< [365] <query> 67,781 us
>>> [366] <query> CREATE TABLE `diviner_livebooktransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [366] <query> 57,816 us
>>> [367] <query> CREATE TABLE `diviner_livesymbol` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`bookPHID` varbinary(64) NOT NULL,
`repositoryPHID` varbinary(64) DEFAULT NULL,
`context` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`type` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`atomIndex` int(10) unsigned NOT NULL,
`identityHash` binary(12) NOT NULL,
`graphHash` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
<<< [367] <query> 140,264 us
>>> [368] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [368] <query> 87,828 us
>>> [369] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [369] <query> 60,147 us
>>> [370] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_auth` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [370] <query> 252 us
>>> [371] <query> USE `testT9773_4100_auth`
<<< [371] <query> 102 us
>>> [372] <query> CREATE TABLE `auth_factorconfig` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`userPHID` varbinary(64) NOT NULL,
`factorKey` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`factorName` longtext COLLATE `utf8mb4_bin` NOT NULL,
`factorSecret` longtext COLLATE `utf8mb4_bin` NOT NULL,
`properties` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phi
<<< [372] <query> 91,571 us
>>> [373] <query> CREATE TABLE `auth_providerconfig` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`providerClass` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`providerType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`providerDomain` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`isEnabled` tinyint(1) NOT NULL,
`shouldAllowLogin` tinyint(1) NOT NULL,
`shouldAllowRegistration` tinyint(1) NOT NULL,
`shouldAllowLink` tinyint(1) NOT NULL,
`shouldAllowUnlink` tinyint(1) NOT N
<<< [373] <query> 87,740 us
>>> [374] <query> CREATE TABLE `auth_providerconfigtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longt
<<< [374] <query> 73,187 us
>>> [375] <query> CREATE TABLE `auth_sshkey` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`keyType` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`keyBody` longtext COLLATE `utf8mb4_bin` NOT NULL,
`keyComment` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`keyIndex` binary(12) NOT NULL,
`isTrusted` tinyint(1) NOT NULL,
PRIMARY KEY (
<<< [375] <query> 85,368 us
>>> [376] <query> CREATE TABLE `auth_temporarytoken` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`tokenType` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`tokenExpires` int(10) unsigned NOT NULL,
`tokenCode` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_token` (`objectPHID`,`tokenType`,`tokenCode`),
KEY `key_expires` (`tokenExpires`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [376] <query> 80,268 us
>>> [377] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_doorkeeper` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [377] <query> 339 us
>>> [378] <query> USE `testT9773_4100_doorkeeper`
<<< [378] <query> 113 us
>>> [379] <query> CREATE TABLE `doorkeeper_externalobject` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`objectKey` binary(12) NOT NULL,
`applicationType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`applicationDomain` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`objectType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`objectID` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`objectURI` varchar(128) COLLATE `utf8mb4_bin` DEFAULT NULL,
`importerPHID` varbinary(64) DEFAULT NULL
<<< [379] <query> 83,189 us
>>> [380] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [380] <query> 72,497 us
>>> [381] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [381] <query> 52,258 us
>>> [382] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_legalpad` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [382] <query> 416 us
>>> [383] <query> USE `testT9773_4100_legalpad`
<<< [383] <query> 154 us
>>> [384] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [384] <query> 59,983 us
>>> [385] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [385] <query> 58,392 us
>>> [386] <query> CREATE TABLE `legalpad_document` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`title` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`contributorCount` int(10) unsigned NOT NULL DEFAULT '0',
`recentContributorPHIDs` longtext COLLATE `utf8mb4_bin` NOT NULL,
`creatorPHID` varbinary(64) NOT NULL,
`versions` int(10) unsigned NOT NULL DEFAULT '0',
`documentBodyPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NUL
<<< [386] <query> 68,912 us
>>> [387] <query> CREATE TABLE `legalpad_documentbody` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`creatorPHID` varbinary(64) NOT NULL,
`documentPHID` varbinary(64) NOT NULL,
`version` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`text` longtext COLLATE `utf8mb4_bin`,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UNIQUE KEY `key_do
<<< [387] <query> 63,219 us
>>> [388] <query> CREATE TABLE `legalpad_documentsignature` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`documentPHID` varbinary(64) NOT NULL,
`documentVersion` int(10) unsigned NOT NULL DEFAULT '0',
`signatureType` varchar(4) COLLATE `utf8mb4_bin` NOT NULL,
`signerPHID` varbinary(64) DEFAULT NULL,
`signerName` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`signerEmail` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`signatureData` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NO
<<< [388] <query> 76,908 us
>>> [389] <query> CREATE TABLE `legalpad_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLAT
<<< [389] <query> 61,534 us
>>> [390] <query> CREATE TABLE `legalpad_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) un
<<< [390] <query> 75,576 us
>>> [391] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_policy` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [391] <query> 403 us
>>> [392] <query> USE `testT9773_4100_policy`
<<< [392] <query> 203 us
>>> [393] <query> CREATE TABLE `policy` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`rules` longtext COLLATE `utf8mb4_bin` NOT NULL,
`defaultAction` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `phid` (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [393] <query> 65,870 us
>>> [394] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_nuance` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [394] <query> 682 us
>>> [395] <query> USE `testT9773_4100_nuance`
<<< [395] <query> 277 us
>>> [396] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [396] <query> 78,594 us
>>> [397] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [397] <query> 54,934 us
>>> [398] <query> CREATE TABLE `nuance_item` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`ownerPHID` varbinary(64) DEFAULT NULL,
`requestorPHID` varbinary(64) NOT NULL,
`sourcePHID` varbinary(64) NOT NULL,
`sourceLabel` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`status` int(10) unsigned NOT NULL,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
`mailKey` binary(20) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`qu
<<< [398] <query> 85,890 us
>>> [399] <query> CREATE TABLE `nuance_itemtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLL
<<< [399] <query> 69,661 us
>>> [400] <query> CREATE TABLE `nuance_itemtransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10)
<<< [400] <query> 64,567 us
>>> [401] <query> CREATE TABLE `nuance_queue` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`mailKey` binary(20) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [401] <query> 60,615 us
>>> [402] <query> CREATE TABLE `nuance_queuetransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COL
<<< [402] <query> 79,380 us
>>> [403] <query> CREATE TABLE `nuance_queuetransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10)
<<< [403] <query> 81,537 us
>>> [404] <query> CREATE TABLE `nuance_requestor` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [404] <query> 68,526 us
>>> [405] <query> CREATE TABLE `nuance_requestorsource` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`requestorPHID` varbinary(64) NOT NULL,
`sourcePHID` varbinary(64) NOT NULL,
`sourceKey` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_source_key` (`sourcePHID`,`sourceKey`),
KEY `key_requestor` (`requestorPHID`,`id`),
KEY `key_source` (
<<< [405] <query> 109,553 us
>>> [406] <query> CREATE TABLE `nuance_requestortransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [406] <query> 86,802 us
>>> [407] <query> CREATE TABLE `nuance_requestortransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int
<<< [407] <query> 76,518 us
>>> [408] <query> CREATE TABLE `nuance_source` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` DEFAULT NULL,
`type` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
`mailKey` binary(20) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`defaultQueuePHID` varbinary(64) NOT N
<<< [408] <query> 83,695 us
>>> [409] <query> CREATE TABLE `nuance_sourcetransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext CO
<<< [409] <query> 70,177 us
>>> [410] <query> CREATE TABLE `nuance_sourcetransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10
<<< [410] <query> 72,236 us
>>> [411] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_passphrase` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [411] <query> 365 us
>>> [412] <query> USE `testT9773_4100_passphrase`
<<< [412] <query> 205 us
>>> [413] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [413] <query> 68,679 us
>>> [414] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [414] <query> 47,742 us
>>> [415] <query> CREATE TABLE `passphrase_credential` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`credentialType` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`providesType` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`username` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`secretID` int(10)
<<< [415] <query> 87,723 us
>>> [416] <query> CREATE TABLE `passphrase_credentialtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` lon
<<< [416] <query> 57,794 us
>>> [417] <query> CREATE TABLE `passphrase_secret` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`secretData` longblob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [417] <query> 45,140 us
>>> [418] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_phragment` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [418] <query> 417 us
>>> [419] <query> USE `testT9773_4100_phragment`
<<< [419] <query> 132 us
>>> [420] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [420] <query> 57,926 us
>>> [421] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [421] <query> 47,774 us
>>> [422] <query> CREATE TABLE `phragment_fragment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`path` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`depth` int(10) unsigned NOT NULL,
`latestVersionPHID` varbinary(64) DEFAULT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UNIQUE KEY `key_path` (`path`)
<<< [422] <query> 61,657 us
>>> [423] <query> CREATE TABLE `phragment_fragmentversion` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`sequence` int(10) unsigned NOT NULL,
`fragmentPHID` varbinary(64) NOT NULL,
`filePHID` varbinary(64) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_version` (`fragmentPHID`,`sequence`),
UNIQUE KEY `key_phid` (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [423] <query> 62,456 us
>>> [424] <query> CREATE TABLE `phragment_snapshot` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`primaryFragmentPHID` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UNIQUE KEY `key_name` (`primaryFragmentPHID`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [424] <query> 69,204 us
>>> [425] <query> CREATE TABLE `phragment_snapshotchild` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`snapshotPHID` varbinary(64) NOT NULL,
`fragmentPHID` varbinary(64) NOT NULL,
`fragmentVersionPHID` varbinary(64) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_child` (`snapshotPHID`,`fragmentPHID`,`fragmentVersionPHID`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [425] <query> 50,554 us
>>> [426] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_dashboard` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [426] <query> 581 us
>>> [427] <query> USE `testT9773_4100_dashboard`
<<< [427] <query> 192 us
>>> [428] <query> CREATE TABLE `dashboard` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`layoutConfig` longtext COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`)
) ENGINE=InnoDB
<<< [428] <query> 52,793 us
>>> [429] <query> CREATE TABLE `dashboard_install` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`installerPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`applicationClass` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`dashboardPHID` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `objectPHID` (`objectPHID`,`applicationClass`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [429] <query> 52,475 us
>>> [430] <query> CREATE TABLE `dashboard_panel` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`panelType` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`isArchived` tinyint(1) NOT NULL DEFAULT '0',
`properties` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`
<<< [430] <query> 59,004 us
>>> [431] <query> CREATE TABLE `dashboard_paneltransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [431] <query> 60,716 us
>>> [432] <query> CREATE TABLE `dashboard_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLA
<<< [432] <query> 79,803 us
>>> [433] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [433] <query> 97,615 us
>>> [434] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [434] <query> 52,209 us
>>> [435] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_system` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [435] <query> 300 us
>>> [436] <query> USE `testT9773_4100_system`
<<< [436] <query> 113 us
>>> [437] <query> CREATE TABLE `system_actionlog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`actorHash` binary(12) NOT NULL,
`actorIdentity` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`action` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`score` double NOT NULL,
`epoch` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `key_epoch` (`epoch`),
KEY `key_action` (`actorHash`,`action`,`epoch`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [437] <query> 71,841 us
>>> [438] <query> CREATE TABLE `system_destructionlog` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectClass` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`rootLogID` int(10) unsigned DEFAULT NULL,
`objectPHID` varbinary(64) DEFAULT NULL,
`objectMonogram` varchar(64) COLLATE `utf8mb4_bin` DEFAULT NULL,
`epoch` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `key_epoch` (`epoch`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [438] <query> 63,071 us
>>> [439] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_fund` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [439] <query> 555 us
>>> [440] <query> USE `testT9773_4100_fund`
<<< [440] <query> 329 us
>>> [441] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [441] <query> 83,518 us
>>> [442] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [442] <query> 54,155 us
>>> [443] <query> CREATE TABLE `fund_backer` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`initiativePHID` varbinary(64) NOT NULL,
`backerPHID` varbinary(64) NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`amountAsCurrency` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`properties` longtext COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
<<< [443] <query> 100,250 us
>>> [444] <query> CREATE TABLE `fund_backertransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLL
<<< [444] <query> 84,861 us
>>> [445] <query> CREATE TABLE `fund_initiative` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`ownerPHID` varbinary(64) NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`merchantPHID` varbinary(6
<<< [445] <query> 89,981 us
>>> [446] <query> CREATE TABLE `fund_initiativetransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [446] <query> 70,851 us
>>> [447] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_almanac` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [447] <query> 297 us
>>> [448] <query> USE `testT9773_4100_almanac`
<<< [448] <query> 121 us
>>> [449] <query> CREATE TABLE `almanac_binding` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`servicePHID` varbinary(64) NOT NULL,
`devicePHID` varbinary(64) NOT NULL,
`interfacePHID` varbinary(64) NOT NULL,
`mailKey` binary(20) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UNIQUE KEY `key_service` (`servicePHID`,`interfacePHID`),
KEY `key_device` (`devicePHID`),
KEY
<<< [449] <query> 79,464 us
>>> [450] <query> CREATE TABLE `almanac_bindingtransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [450] <query> 59,974 us
>>> [451] <query> CREATE TABLE `almanac_device` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`nameIndex` binary(12) NOT NULL,
`mailKey` binary(20) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`isLocked` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
UNIQUE KEY `key_nam
<<< [451] <query> 66,335 us
>>> [452] <query> CREATE TABLE `almanac_devicetransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext C
<<< [452] <query> 58,888 us
>>> [453] <query> CREATE TABLE `almanac_interface` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`devicePHID` varbinary(64) NOT NULL,
`networkPHID` varbinary(64) NOT NULL,
`address` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`port` int(10) unsigned NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`),
KEY `key_location` (`networkPHID`,`address`,`port`),
KEY `key_device` (`devic
<<< [453] <query> 64,273 us
>>> [454] <query> CREATE TABLE `almanac_network` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`mailKey` binary(20) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_phid` (`phid`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [454] <query> 51,496 us
>>> [455] <query> CREATE TABLE `almanac_networktransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [455] <query> 57,439 us
>>> [456] <query> CREATE TABLE `almanac_property` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`objectPHID` varbinary(64) NOT NULL,
`fieldIndex` binary(12) NOT NULL,
`fieldName` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`fieldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `objectPHID` (`objectPHID`,`fieldIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [456] <query> 50,152 us
>>> [457] <query> CREATE TABLE `almanac_service` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(128) COLLATE `utf8mb4_bin` NOT NULL,
`nameIndex` binary(12) NOT NULL,
`mailKey` binary(20) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`serviceClass` varchar(64) COLLATE `utf8mb4_bin` NOT NULL,
`isLocked` tinyint(1) NOT NULL,
PRIMARY KEY (
<<< [457] <query> 75,438 us
>>> [458] <query> CREATE TABLE `almanac_servicetransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [458] <query> 62,259 us
>>> [459] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [459] <query> 64,965 us
>>> [460] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [460] <query> 53,020 us
>>> [461] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_multimeter` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [461] <query> 356 us
>>> [462] <query> USE `testT9773_4100_multimeter`
<<< [462] <query> 159 us
>>> [463] <query> CREATE TABLE `multimeter_context` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext COLLATE `utf8mb4_bin` NOT NULL,
`nameHash` binary(12) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_hash` (`nameHash`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [463] <query> 58,851 us
>>> [464] <query> CREATE TABLE `multimeter_event` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`eventType` int(10) unsigned NOT NULL,
`eventLabelID` int(10) unsigned NOT NULL,
`resourceCost` bigint(20) NOT NULL,
`sampleRate` int(10) unsigned NOT NULL,
`eventContextID` int(10) unsigned NOT NULL,
`eventHostID` int(10) unsigned NOT NULL,
`eventViewerID` int(10) unsigned NOT NULL,
`epoch` int(10) unsigned NOT NULL,
`requestKey` binary(12) NOT NULL,
PRIMARY KEY (`id`),
KEY `key_request` (`requestKey`),
<<< [464] <query> 60,033 us
>>> [465] <query> CREATE TABLE `multimeter_host` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext COLLATE `utf8mb4_bin` NOT NULL,
`nameHash` binary(12) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_hash` (`nameHash`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [465] <query> 62,916 us
>>> [466] <query> CREATE TABLE `multimeter_label` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext COLLATE `utf8mb4_bin` NOT NULL,
`nameHash` binary(12) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_hash` (`nameHash`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [466] <query> 74,810 us
>>> [467] <query> CREATE TABLE `multimeter_viewer` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` longtext COLLATE `utf8mb4_bin` NOT NULL,
`nameHash` binary(12) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `key_hash` (`nameHash`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [467] <query> 97,690 us
>>> [468] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_spaces` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [468] <query> 696 us
>>> [469] <query> USE `testT9773_4100_spaces`
<<< [469] <query> 367 us
>>> [470] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [470] <query> 94,463 us
>>> [471] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [471] <query> 74,890 us
>>> [472] <query> CREATE TABLE `spaces_namespace` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`namespaceName` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`isDefaultNamespace` tinyint(1) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isArchived` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNI
<<< [472] <query> 77,142 us
>>> [473] <query> CREATE TABLE `spaces_namespacetransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext
<<< [473] <query> 88,176 us
>>> [474] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_phurl` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [474] <query> 597 us
>>> [475] <query> USE `testT9773_4100_phurl`
<<< [475] <query> 166 us
>>> [476] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [476] <query> 94,480 us
>>> [477] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [477] <query> 61,925 us
>>> [478] <query> CREATE TABLE `phurl_url` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` longtext COLLATE `utf8mb4_bin` NOT NULL,
`longURL` longtext COLLATE `utf8mb4_bin` NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`spacePHID` varbinary(64) DEFAULT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`alias` varchar(64) CHARACTER SET
<<< [478] <query> 100,751 us
>>> [479] <query> CREATE TABLE `phurl_urltransaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLAT
<<< [479] <query> 84,317 us
>>> [480] <query> CREATE TABLE `phurl_urltransaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) un
<<< [480] <query> 80,332 us
>>> [481] <query> CREATE DATABASE /*!32312 IF NOT EXISTS*/ `testT9773_4100_badges` /*!40100 DEFAULT CHARACTER SET `utf8mb4` COLLATE `utf8mb4_bin` */
<<< [481] <query> 331 us
>>> [482] <query> USE `testT9773_4100_badges`
<<< [482] <query> 130 us
>>> [483] <query> CREATE TABLE `badges_badge` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`name` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`flavor` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`description` longtext COLLATE `utf8mb4_bin` NOT NULL,
`icon` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`quality` varchar(255) COLLATE `utf8mb4_bin` NOT NULL,
`status` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10)
<<< [483] <query> 81,917 us
>>> [484] <query> CREATE TABLE `badges_transaction` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`authorPHID` varbinary(64) NOT NULL,
`objectPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentPHID` varbinary(64) DEFAULT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`transactionType` varchar(32) COLLATE `utf8mb4_bin` NOT NULL,
`oldValue` longtext COLLATE `utf8mb4_bin` NOT NULL,
`newValue` longtext COLLATE
<<< [484] <query> 78,420 us
>>> [485] <query> CREATE TABLE `badges_transaction_comment` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`phid` varbinary(64) NOT NULL,
`transactionPHID` varbinary(64) DEFAULT NULL,
`authorPHID` varbinary(64) NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
`commentVersion` int(10) unsigned NOT NULL,
`content` longtext COLLATE `utf8mb4_bin` NOT NULL,
`contentSource` longtext COLLATE `utf8mb4_bin` NOT NULL,
`isDeleted` tinyint(1) NOT NULL,
`dateCreated` int(10) unsi
<<< [485] <query> 70,881 us
>>> [486] <query> CREATE TABLE `edge` (
`src` varbinary(64) NOT NULL,
`type` int(10) unsigned NOT NULL,
`dst` varbinary(64) NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`seq` int(10) unsigned NOT NULL,
`dataID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`src`,`type`,`dst`),
UNIQUE KEY `key_dst` (`dst`,`type`,`src`),
KEY `src` (`src`,`type`,`dateCreated`,`seq`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [486] <query> 81,835 us
>>> [487] <query> CREATE TABLE `edgedata` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`data` longtext COLLATE `utf8mb4_bin` NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=`utf8mb4` COLLATE=`utf8mb4_bin`
<<< [487] <query> 59,732 us
>>> [488] <connect> testT9773_4100_meta_data
<<< [488] <connect> 329 us
>>> [489] <query> SELECT patch FROM `patch_status`
<<< [489] <query> 608 us
Applying patch 'phabricator:db.xhpast'...
>>> [490] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [490] <query> 427 us
>>> [491] <query> CREATE DATABASE IF NOT EXISTS `testT9773_4100_xhpast` COLLATE `utf8mb4_bin`
<<< [491] <query> 299 us
>>> [492] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:db.xhpast', 1448397901)
<<< [492] <query> 13,656 us
>>> [493] <query> UPDATE `patch_status` SET duration = 1190 WHERE patch = 'phabricator:db.xhpast'
<<< [493] <query> 169 us
Applying patch 'phabricator:20150906.mailinglist.sql'...
>>> [494] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [494] <query> 338 us
>>> [495] <query> DROP TABLE testT9773_4100_metamta.metamta_mailinglist
<<< [495] <query> 31,159 us
>>> [496] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20150906.mailinglist.sql', 1448397901)
<<< [496] <query> 7,762 us
>>> [497] <query> UPDATE `patch_status` SET duration = 32064 WHERE patch = 'phabricator:20150906.mailinglist.sql'
<<< [497] <query> 293 us
Applying patch 'phabricator:20150930.drydock.log.1.sql'...
>>> [498] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [498] <query> 628 us
>>> [499] <query> TRUNCATE testT9773_4100_drydock.drydock_log
<<< [499] <query> 69,061 us
>>> [500] <query> ALTER TABLE testT9773_4100_drydock.drydock_log
DROP resourceID
<<< [500] <query> 111,477 us
>>> [501] <query> ALTER TABLE testT9773_4100_drydock.drydock_log
DROP leaseID
<<< [501] <query> 121,905 us
>>> [502] <query> ALTER TABLE testT9773_4100_drydock.drydock_log
DROP message
<<< [502] <query> 114,543 us
>>> [503] <query> ALTER TABLE testT9773_4100_drydock.drydock_log
ADD blueprintPHID VARBINARY(64)
<<< [503] <query> 133,632 us
>>> [504] <query> ALTER TABLE testT9773_4100_drydock.drydock_log
ADD resourcePHID VARBINARY(64)
<<< [504] <query> 121,599 us
>>> [505] <query> ALTER TABLE testT9773_4100_drydock.drydock_log
ADD leasePHID VARBINARY(64)
<<< [505] <query> 151,448 us
>>> [506] <query> ALTER TABLE testT9773_4100_drydock.drydock_log
ADD type VARCHAR(64) NOT NULL COLLATE `utf8mb4_bin`
<<< [506] <query> 134,755 us
>>> [507] <query> ALTER TABLE testT9773_4100_drydock.drydock_log
ADD data LONGTEXT NOT NULL COLLATE `utf8mb4_bin`
<<< [507] <query> 164,680 us
>>> [508] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20150930.drydock.log.1.sql', 1448397902)
<<< [508] <query> 12,355 us
>>> [509] <query> UPDATE `patch_status` SET duration = 1127245 WHERE patch = 'phabricator:20150930.drydock.log.1.sql'
<<< [509] <query> 335 us
Applying patch 'phabricator:20151001.drydock.rname.1.sql'...
>>> [510] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [510] <query> 762 us
>>> [511] <query> ALTER TABLE testT9773_4100_drydock.drydock_resource
DROP name
<<< [511] <query> 164,288 us
>>> [512] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151001.drydock.rname.1.sql', 1448397903)
<<< [512] <query> 21,346 us
>>> [513] <query> UPDATE `patch_status` SET duration = 168893 WHERE patch = 'phabricator:20151001.drydock.rname.1.sql'
<<< [513] <query> 416 us
Applying patch 'phabricator:20151002.dashboard.status.1.sql'...
>>> [514] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [514] <query> 800 us
>>> [515] <query> UPDATE testT9773_4100_dashboard.dashboard
SET status = 'active' WHERE status = 'open'
<<< [515] <query> 1,183 us
>>> [516] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151002.dashboard.status.1.sql', 1448397903)
<<< [516] <query> 10,137 us
>>> [517] <query> UPDATE `patch_status` SET duration = 3113 WHERE patch = 'phabricator:20151002.dashboard.status.1.sql'
<<< [517] <query> 324 us
Applying patch 'phabricator:20151002.harbormaster.bparam.1.sql'...
>>> [518] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [518] <query> 653 us
>>> [519] <query> ALTER TABLE testT9773_4100_harbormaster.harbormaster_build
ADD buildParameters LONGTEXT COLLATE `utf8mb4_bin` NOT NULL
<<< [519] <query> 174,132 us
>>> [520] <query> UPDATE testT9773_4100_harbormaster.harbormaster_build
SET buildParameters = '{}' WHERE buildParameters = ''
<<< [520] <query> 262 us
>>> [521] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151002.harbormaster.bparam.1.sql', 1448397903)
<<< [521] <query> 11,276 us
>>> [522] <query> UPDATE `patch_status` SET duration = 175951 WHERE patch = 'phabricator:20151002.harbormaster.bparam.1.sql'
<<< [522] <query> 349 us
Applying patch 'phabricator:20151009.drydock.auth.1.sql'...
>>> [523] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [523] <query> 401 us
>>> [524] <query> CREATE TABLE testT9773_4100_drydock.drydock_authorization (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
phid VARBINARY(64) NOT NULL,
blueprintPHID VARBINARY(64) NOT NULL,
blueprintAuthorizationState VARCHAR(32) NOT NULL COLLATE `utf8mb4_bin`,
objectPHID VARBINARY(64) NOT NULL,
objectAuthorizationState VARCHAR(32) NOT NULL COLLATE `utf8mb4_bin`,
dateCreated INT UNSIGNED NOT NULL,
dateModified INT UNSIGNED NOT NULL,
UNIQUE KEY `key_phid` (phid),
UNIQUE KEY `key_unique` (objectPHID
<<< [524] <query> 96,307 us
>>> [525] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151009.drydock.auth.1.sql', 1448397903)
<<< [525] <query> 7,668 us
>>> [526] <query> UPDATE `patch_status` SET duration = 97595 WHERE patch = 'phabricator:20151009.drydock.auth.1.sql'
<<< [526] <query> 182 us
Applying patch 'phabricator:20151010.drydock.auth.2.sql'...
>>> [527] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [527] <query> 348 us
>>> [528] <query> ALTER TABLE testT9773_4100_drydock.drydock_lease
ADD authorizingPHID VARBINARY(64) NOT NULL
<<< [528] <query> 108,568 us
>>> [529] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151010.drydock.auth.2.sql', 1448397903)
<<< [529] <query> 7,713 us
>>> [530] <query> UPDATE `patch_status` SET duration = 109568 WHERE patch = 'phabricator:20151010.drydock.auth.2.sql'
<<< [530] <query> 233 us
Applying patch 'phabricator:20151013.drydock.op.1.sql'...
>>> [531] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [531] <query> 355 us
>>> [532] <query> CREATE TABLE testT9773_4100_drydock.drydock_repositoryoperation (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
phid VARBINARY(64) NOT NULL,
authorPHID VARBINARY(64) NOT NULL,
objectPHID VARBINARY(64) NOT NULL,
repositoryPHID VARBINARY(64) NOT NULL,
repositoryTarget LONGBLOB NOT NULL,
operationType VARCHAR(32) NOT NULL COLLATE `utf8mb4_bin`,
operationState VARCHAR(32) NOT NULL COLLATE `utf8mb4_bin`,
properties LONGTEXT NOT NULL COLLATE `utf8mb4_bin`,
dateCreated INT UNSIGNED NOT N
<<< [532] <query> 78,890 us
>>> [533] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151013.drydock.op.1.sql', 1448397903)
<<< [533] <query> 6,057 us
>>> [534] <query> UPDATE `patch_status` SET duration = 79788 WHERE patch = 'phabricator:20151013.drydock.op.1.sql'
<<< [534] <query> 189 us
Applying patch 'phabricator:20151023.harborpolicy.1.sql'...
>>> [535] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [535] <query> 425 us
>>> [536] <query> ALTER TABLE testT9773_4100_harbormaster.harbormaster_buildplan
ADD viewPolicy VARBINARY(64) NOT NULL
<<< [536] <query> 113,042 us
>>> [537] <query> ALTER TABLE testT9773_4100_harbormaster.harbormaster_buildplan
ADD editPolicy VARBINARY(64) NOT NULL
<<< [537] <query> 113,185 us
>>> [538] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151023.harborpolicy.1.sql', 1448397903)
<<< [538] <query> 7,092 us
>>> [539] <query> UPDATE `patch_status` SET duration = 227943 WHERE patch = 'phabricator:20151023.harborpolicy.1.sql'
<<< [539] <query> 807 us
Applying patch 'phabricator:20151023.harborpolicy.2.php'...
>>> [540] <connect> testT9773_4100_harbormaster
<<< [540] <connect> 1,064 us
>>> [541] <query> UPDATE `harbormaster_buildplan` SET viewPolicy = 'public' WHERE viewPolicy = ''
<<< [541] <query> 337 us
>>> [542] <query> UPDATE `harbormaster_buildplan` SET editPolicy = 'admin' WHERE editPolicy = ''
<<< [542] <query> 602 us
>>> [543] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151023.harborpolicy.2.php', 1448397903)
<<< [543] <query> 6,705 us
>>> [544] <query> UPDATE `patch_status` SET duration = 6685 WHERE patch = 'phabricator:20151023.harborpolicy.2.php'
<<< [544] <query> 834 us
Applying patch 'phabricator:20151023.patchduration.sql'...
>>> [545] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [545] <query> 1,348 us
>>> [546] <query> ALTER TABLE testT9773_4100_meta_data.patch_status
ADD duration BIGINT UNSIGNED
<<< [546] <query> 115,374 us
>>> [547] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151023.patchduration.sql', 1448397904)
<<< [547] <query> 6,623 us
>>> [548] <query> UPDATE `patch_status` SET duration = 118669 WHERE patch = 'phabricator:20151023.patchduration.sql'
<<< [548] <query> 6,177 us
Applying patch 'phabricator:20151030.harbormaster.initiator.sql'...
>>> [549] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [549] <query> 324 us
>>> [550] <query> ALTER TABLE testT9773_4100_harbormaster.harbormaster_build
ADD COLUMN initiatorPHID VARBINARY(64)
<<< [550] <query> 125,341 us
>>> [551] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151030.harbormaster.initiator.sql', 1448397904)
<<< [551] <query> 12,655 us
>>> [552] <query> UPDATE `patch_status` SET duration = 126349 WHERE patch = 'phabricator:20151030.harbormaster.initiator.sql'
<<< [552] <query> 6,097 us
Applying patch 'phabricator:20151106.editengine.1.table.sql'...
>>> [553] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [553] <query> 833 us
>>> [554] <query> CREATE TABLE testT9773_4100_search.search_editengineconfiguration (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
phid VARBINARY(64) NOT NULL,
engineKey VARCHAR(64) NOT NULL COLLATE `utf8mb4_bin`,
builtinKey VARCHAR(64) COLLATE `utf8mb4_bin`,
name VARCHAR(255) NOT NULL COLLATE `utf8mb4_bin`,
viewPolicy VARBINARY(64) NOT NULL,
editPolicy VARBINARY(64) NOT NULL,
properties LONGTEXT NOT NULL COLLATE `utf8mb4_bin`,
isDisabled BOOL NOT NULL DEFAULT 0,
isDefault BOOL NOT NULL DEFAULT 0,
<<< [554] <query> 70,861 us
>>> [555] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151106.editengine.1.table.sql', 1448397904)
<<< [555] <query> 6,067 us
>>> [556] <query> UPDATE `patch_status` SET duration = 73280 WHERE patch = 'phabricator:20151106.editengine.1.table.sql'
<<< [556] <query> 6,039 us
Applying patch 'phabricator:20151106.editengine.2.xactions.sql'...
>>> [557] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [557] <query> 521 us
>>> [558] <query> CREATE TABLE testT9773_4100_search.search_editengineconfigurationtransaction (
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
phid VARBINARY(64) NOT NULL,
authorPHID VARBINARY(64) NOT NULL,
objectPHID VARBINARY(64) NOT NULL,
viewPolicy VARBINARY(64) NOT NULL,
editPolicy VARBINARY(64) NOT NULL,
commentPHID VARBINARY(64) DEFAULT NULL,
commentVersion INT UNSIGNED NOT NULL,
transactionType VARCHAR(32) COLLATE `utf8mb4_bin` NOT NULL,
oldValue LONGTEXT COLLATE `utf8mb4_bin` NOT NULL,
n
<<< [558] <query> 55,919 us
>>> [559] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151106.editengine.2.xactions.sql', 1448397904)
<<< [559] <query> 6,028 us
>>> [560] <query> UPDATE `patch_status` SET duration = 57250 WHERE patch = 'phabricator:20151106.editengine.2.xactions.sql'
<<< [560] <query> 6,649 us
Applying patch 'phabricator:20151106.phame.post.mailkey.1.sql'...
>>> [561] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [561] <query> 373 us
>>> [562] <query> ALTER TABLE testT9773_4100_phame.phame_post
ADD mailKey binary(20) NOT NULL
<<< [562] <query> 101,247 us
>>> [563] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151106.phame.post.mailkey.1.sql', 1448397904)
<<< [563] <query> 6,542 us
>>> [564] <query> UPDATE `patch_status` SET duration = 102327 WHERE patch = 'phabricator:20151106.phame.post.mailkey.1.sql'
<<< [564] <query> 6,263 us
Applying patch 'phabricator:20151106.phame.post.mailkey.2.php'...
>>> [565] <connect> testT9773_4100_phame
<<< [565] <connect> 437 us
>>> [566] <query> SELECT * FROM `phame_post` WHERE id > 0 ORDER BY id ASC LIMIT 100
<<< [566] <query> 485 us
>>> [567] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151106.phame.post.mailkey.2.php', 1448397904)
<<< [567] <query> 6,476 us
>>> [568] <query> UPDATE `patch_status` SET duration = 2670 WHERE patch = 'phabricator:20151106.phame.post.mailkey.2.php'
<<< [568] <query> 6,248 us
Applying patch 'phabricator:20151107.phame.blog.mailkey.1.sql'...
>>> [569] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [569] <query> 1,599 us
>>> [570] <query> ALTER TABLE testT9773_4100_phame.phame_blog
ADD mailKey binary(20) NOT NULL
<<< [570] <query> 101,171 us
>>> [571] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151107.phame.blog.mailkey.1.sql', 1448397904)
<<< [571] <query> 12,425 us
>>> [572] <query> UPDATE `patch_status` SET duration = 104078 WHERE patch = 'phabricator:20151107.phame.blog.mailkey.1.sql'
<<< [572] <query> 11,198 us
Applying patch 'phabricator:20151107.phame.blog.mailkey.2.php'...
>>> [573] <query> SELECT * FROM `phame_blog` WHERE id > 0 ORDER BY id ASC LIMIT 100
<<< [573] <query> 407 us
>>> [574] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151107.phame.blog.mailkey.2.php', 1448397904)
<<< [574] <query> 6,239 us
>>> [575] <query> UPDATE `patch_status` SET duration = 1660 WHERE patch = 'phabricator:20151107.phame.blog.mailkey.2.php'
<<< [575] <query> 7,404 us
Applying patch 'phabricator:20151108.phame.blog.joinpolicy.sql'...
>>> [576] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [576] <query> 621 us
>>> [577] <query> ALTER TABLE testT9773_4100_phame.phame_blog
DROP joinPolicy
<<< [577] <query> 103,652 us
>>> [578] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151108.phame.blog.joinpolicy.sql', 1448397904)
<<< [578] <query> 6,800 us
>>> [579] <query> UPDATE `patch_status` SET duration = 105082 WHERE patch = 'phabricator:20151108.phame.blog.joinpolicy.sql'
<<< [579] <query> 6,109 us
Applying patch 'phabricator:20151108.xhpast.stderr.sql'...
>>> [580] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [580] <query> 499 us
>>> [581] <query> ALTER TABLE testT9773_4100_xhpastview.xhpastview_parsetree
ADD returnCode INT NOT NULL AFTER input
<<< [581] <query> 120,617 us
>>> [582] <query> ALTER TABLE testT9773_4100_xhpastview.xhpastview_parsetree
ADD stderr longtext NOT NULL AFTER stdout
<<< [582] <query> 92,616 us
>>> [583] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151108.xhpast.stderr.sql', 1448397905)
<<< [583] <query> 12,583 us
>>> [584] <query> UPDATE `patch_status` SET duration = 215673 WHERE patch = 'phabricator:20151108.xhpast.stderr.sql'
<<< [584] <query> 7,282 us
Applying patch 'phabricator:20151109.phame.post.comments.1.sql'...
>>> [585] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [585] <query> 487 us
>>> [586] <query> CREATE TABLE testT9773_4100_phame.phame_posttransaction_comment (
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
phid VARCHAR(64) NOT NULL,
transactionPHID VARCHAR(64),
authorPHID VARCHAR(64) NOT NULL,
viewPolicy VARCHAR(64) NOT NULL,
editPolicy VARCHAR(64) NOT NULL,
commentVersion INT UNSIGNED NOT NULL,
content LONGTEXT NOT NULL COLLATE `utf8mb4_bin`,
contentSource LONGTEXT NOT NULL COLLATE `utf8mb4_bin`,
isDeleted BOOL NOT NULL,
dateCreated INT UNSIGNED NOT NULL,
dateModified
<<< [586] <query> 85,285 us
>>> [587] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151109.phame.post.comments.1.sql', 1448397905)
<<< [587] <query> 6,363 us
>>> [588] <query> UPDATE `patch_status` SET duration = 86471 WHERE patch = 'phabricator:20151109.phame.post.comments.1.sql'
<<< [588] <query> 7,117 us
Applying patch 'phabricator:20151109.repository.coverage.1.sql'...
>>> [589] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [589] <query> 662 us
>>> [590] <query> USE testT9773_4100_repository
<<< [590] <query> 188 us
>>> [591] <query> DELETE x FROM repository_coverage x
LEFT JOIN repository_coverage y
ON x.branchID = y.branchID
AND x.commitID = y.commitID
AND x.pathID = y.pathID
AND y.id > x.id
WHERE y.id IS NOT NULL
<<< [591] <query> 759 us
>>> [592] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151109.repository.coverage.1.sql', 1448397905)
<<< [592] <query> 7,519 us
>>> [593] <query> UPDATE `patch_status` SET duration = 2645 WHERE patch = 'phabricator:20151109.repository.coverage.1.sql'
<<< [593] <query> 6,943 us
Applying patch 'phabricator:20151109.xhpast.db.1.sql'...
>>> [594] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [594] <query> 831 us
>>> [595] <query> RENAME TABLE testT9773_4100_xhpastview.xhpastview_parsetree
TO testT9773_4100_xhpast.xhpast_parsetree
<<< [595] <query> 26,457 us
>>> [596] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151109.xhpast.db.1.sql', 1448397905)
<<< [596] <query> 11,837 us
>>> [597] <query> UPDATE `patch_status` SET duration = 30531 WHERE patch = 'phabricator:20151109.xhpast.db.1.sql'
<<< [597] <query> 7,565 us
Applying patch 'phabricator:20151109.xhpast.db.2.sql'...
>>> [598] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [598] <query> 375 us
>>> [599] <query> DROP DATABASE testT9773_4100_xhpastview
<<< [599] <query> 457 us
>>> [600] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151109.xhpast.db.2.sql', 1448397905)
<<< [600] <query> 8,701 us
>>> [601] <query> UPDATE `patch_status` SET duration = 1393 WHERE patch = 'phabricator:20151109.xhpast.db.2.sql'
<<< [601] <query> 8,803 us
Applying patch 'phabricator:20151110.daemonenvhash.sql'...
>>> [602] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [602] <query> 323 us
>>> [603] <query> ALTER TABLE testT9773_4100_daemon.daemon_log
DROP COLUMN envHash
<<< [603] <query> 136,579 us
>>> [604] <query> ALTER TABLE testT9773_4100_daemon.daemon_log
DROP COLUMN envInfo
<<< [604] <query> 119,879 us
>>> [605] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151110.daemonenvhash.sql', 1448397905)
<<< [605] <query> 9,078 us
>>> [606] <query> UPDATE `patch_status` SET duration = 257614 WHERE patch = 'phabricator:20151110.daemonenvhash.sql'
<<< [606] <query> 6,541 us
Applying patch 'phabricator:20151111.phame.blog.archive.1.sql'...
>>> [607] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [607] <query> 321 us
>>> [608] <query> ALTER TABLE testT9773_4100_phame.phame_blog
ADD status VARCHAR(32) NOT NULL COLLATE `utf8mb4_bin`
<<< [608] <query> 100,157 us
>>> [609] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151111.phame.blog.archive.1.sql', 1448397905)
<<< [609] <query> 7,098 us
>>> [610] <query> UPDATE `patch_status` SET duration = 101776 WHERE patch = 'phabricator:20151111.phame.blog.archive.1.sql'
<<< [610] <query> 5,948 us
Applying patch 'phabricator:20151111.phame.blog.archive.2.sql'...
>>> [611] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [611] <query> 348 us
>>> [612] <query> UPDATE testT9773_4100_phame.phame_blog
SET status = 'active' WHERE status = ''
<<< [612] <query> 250 us
>>> [613] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151111.phame.blog.archive.2.sql', 1448397905)
<<< [613] <query> 7,456 us
>>> [614] <query> UPDATE `patch_status` SET duration = 1276 WHERE patch = 'phabricator:20151111.phame.blog.archive.2.sql'
<<< [614] <query> 6,283 us
Applying patch 'phabricator:20151112.herald.edge.sql'...
>>> [615] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [615] <query> 2,821 us
>>> [616] <query> CREATE TABLE testT9773_4100_herald.edge (
src VARBINARY(64) NOT NULL,
type INT UNSIGNED NOT NULL,
dst VARBINARY(64) NOT NULL,
dateCreated INT UNSIGNED NOT NULL,
seq INT UNSIGNED NOT NULL,
dataID INT UNSIGNED,
PRIMARY KEY (src, type, dst),
KEY `src` (src, type, dateCreated, seq),
UNIQUE KEY `key_dst` (dst, type, src)
) ENGINE=InnoDB, COLLATE `utf8mb4_bin`
<<< [616] <query> 64,596 us
>>> [617] <query> CREATE TABLE testT9773_4100_herald.edgedata (
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
data LONGTEXT NOT NULL COLLATE `utf8mb4_bin`
) ENGINE=InnoDB, COLLATE `utf8mb4_bin`
<<< [617] <query> 51,102 us
>>> [618] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151112.herald.edge.sql', 1448397905)
<<< [618] <query> 6,012 us
>>> [619] <query> UPDATE `patch_status` SET duration = 121237 WHERE patch = 'phabricator:20151112.herald.edge.sql'
<<< [619] <query> 7,305 us
Applying patch 'phabricator:20151116.owners.edge.sql'...
>>> [620] <query> SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_NAME = 'utf8mb4'
<<< [620] <query> 452 us
>>> [621] <query> CREATE TABLE testT9773_4100_owners.edge (
src VARBINARY(64) NOT NULL,
type INT UNSIGNED NOT NULL,
dst VARBINARY(64) NOT NULL,
dateCreated INT UNSIGNED NOT NULL,
seq INT UNSIGNED NOT NULL,
dataID INT UNSIGNED,
PRIMARY KEY (src, type, dst),
KEY `src` (src, type, dateCreated, seq),
UNIQUE KEY `key_dst` (dst, type, src)
) ENGINE=InnoDB, COLLATE `utf8mb4_bin`
<<< [621] <query> 67,867 us
>>> [622] <query> CREATE TABLE testT9773_4100_owners.edgedata (
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
data LONGTEXT NOT NULL COLLATE `utf8mb4_bin`
) ENGINE=InnoDB, COLLATE `utf8mb4_bin`
<<< [622] <query> 46,700 us
>>> [623] <query> INSERT INTO `patch_status` (patch, applied) VALUES ('phabricator:20151116.owners.edge.sql', 1448397905)
<<< [623] <query> 6,189 us
>>> [624] <query> UPDATE `patch_status` SET duration = 116930 WHERE patch = 'phabricator:20151116.owners.edge.sql'
<<< [624] <query> 6,861 us
Storage is up to date. Use 'storage status' for details.
Declining to apply storage adjustments.

File Metadata

Mime Type
text/plain
Storage Engine
amazon-s3
Storage Format
Raw Data
Storage Handle
phabricator/np/at/nfrmejplohlpg7io
Default Alt Text
storage.log (212 KB)

Event Timeline

Phabricator · Built by Phacility