[Summary view] [Print] [Text view]

   1  CREATE TABLE `{$NAMESPACE}_ponder`.`ponder_comment` (
   2    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   3    `authorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   4    `targetPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   5    `content` longtext CHARACTER SET utf8 NOT NULL,
   6    `dateCreated` int(10) unsigned NOT NULL,
   7    `dateModified` int(10) unsigned NOT NULL,
   8    PRIMARY KEY (`id`),
   9    KEY `authorPHID` (`authorPHID`),
  10    KEY `targetPHID` (`targetPHID`)
  11  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;