[Summary view] [Print] [Text view]

   1  CREATE TABLE `{$NAMESPACE}_phame`.`phame_post` (
   2    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    `phid` VARCHAR(64) BINARY NOT NULL COLLATE utf8_bin,
   4    `bloggerPHID` VARCHAR(64) BINARY NOT NULL COLLATE utf8_bin,
   5    `title` VARCHAR(255) NOT NULL,
   6    `phameTitle` VARCHAR(64) NOT NULL,
   7    `body` LONGTEXT COLLATE utf8_general_ci,
   8    `visibility` INT UNSIGNED NOT NULL DEFAULT 0,
   9    `configData` LONGTEXT COLLATE utf8_general_ci,
  10    `datePublished` INT UNSIGNED NOT NULL,
  11    `dateCreated` INT UNSIGNED NOT NULL,
  12    `dateModified` INT UNSIGNED NOT NULL,
  13    KEY `bloggerPosts` (`bloggerPHID`, `visibility`, `datePublished`, `id`),
  14    UNIQUE KEY `phid` (`phid`),
  15    UNIQUE KEY `phameTitle` (`bloggerPHID`, `phameTitle`)
  16  ) ENGINE=InnoDB;