Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P1429
(An Untitled Masterwork)
Active
Public
Actions
Authored by
cburroughs
on Nov 24 2014, 3:31 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F238119: file
Nov 24 2014, 3:31 PM
2014-11-24 15:31:21 (UTC+0)
Subscribers
None
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)
Event Timeline
cburroughs
edited the content of this paste.
(Show Details)
Nov 24 2014, 3:31 PM
2014-11-24 15:31:21 (UTC+0)
cburroughs
updated the paste's language from
autodetect
to
autodetect
.
Log In to Comment