mysql> SHOW CREATE TABLE phabricator_maniphest.maniphest_task;
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| maniphest_task | 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,
`ccPHIDs` longtext COLLATE utf8mb4_bin,
`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 COLLATE utf8mb4_bin NOT NULL,
`dateCreated` int(10) unsigned NOT NULL,
`dateModified` int(10) unsigned NOT NULL,
`projectPHIDs` longtext COLLATE utf8mb4_bin NOT NULL,
`mailKey` binary(20) NOT NULL,
`ownerOrdering` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL,
`originalEmailSource` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`subpriority` double NOT NULL,
`viewPolicy` varbinary(64) NOT NULL,
`editPolicy` varbinary(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `phid` (`phid`),
KEY `priority` (`priority`,`status`),
KEY `status` (`status`),
KEY `ownerPHID` (`ownerPHID`,`status`),
KEY `authorPHID` (`authorPHID`,`status`),
KEY `ownerOrdering` (`ownerOrdering`),
KEY `priority_2` (`priority`,`subpriority`),
KEY `key_dateCreated` (`dateCreated`),
KEY `key_dateModified` (`dateModified`),
KEY `key_title` (`title`(64))
) ENGINE=InnoDB AUTO_INCREMENT=50870 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)