[Summary view] [Print] [Text view]

   1  CREATE TABLE `{$NAMESPACE}_ponder`.`ponder_question` (
   2    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   3    `title` varchar(255) NOT NULL,
   4    `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   5    `voteCount` int(10) NOT NULL,
   6    `authorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   7    `content` longtext CHARACTER SET utf8 NOT NULL,
   8    `dateCreated` int(10) unsigned NOT NULL,
   9    `dateModified` int(10) unsigned NOT NULL,
  10    `contentSource` varchar(255) DEFAULT NULL,
  11    `heat` float NOT NULL,
  12    `answerCount` int(10) unsigned NOT NULL,
  13    PRIMARY KEY (`id`),
  14    UNIQUE KEY `phid` (`phid`),
  15    KEY `authorPHID` (`authorPHID`),
  16    KEY `heat` (`heat`)
  17  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11;
  18  
  19  CREATE TABLE `{$NAMESPACE}_ponder`.`ponder_answer` (
  20    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  21    `questionID` int(10) unsigned NOT NULL,
  22    `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  23    `voteCount` int(10) NOT NULL,
  24    `authorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  25    `content` longtext CHARACTER SET utf8 NOT NULL,
  26    `dateCreated` int(10) unsigned NOT NULL,
  27    `dateModified` int(10) unsigned NOT NULL,
  28    `contentSource` varchar(255) DEFAULT NULL,
  29    PRIMARY KEY (`id`),
  30    UNIQUE KEY `phid` (`phid`),
  31    KEY `questionID` (`questionID`),
  32    KEY `authorPHID` (`authorPHID`)
  33  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  34  
  35  CREATE TABLE `{$NAMESPACE}_ponder`.`edge` (
  36    `src` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  37    `type` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  38    `dst` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  39    `dateCreated` int(10) unsigned NOT NULL,
  40    `seq` int(10) unsigned NOT NULL,
  41    `dataID` int(10) unsigned DEFAULT NULL,
  42    PRIMARY KEY (`src`,`type`,`dst`),
  43    KEY `src` (`src`,`type`,`dateCreated`,`seq`)
  44  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  45  
  46  CREATE TABLE `{$NAMESPACE}_ponder`.`edgedata` (
  47    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  48    `data` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  49    PRIMARY KEY (`id`)
  50  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;