[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_feed.feed_storydata (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) BINARY NOT NULL,
   4    UNIQUE KEY (phid),
   5    chronologicalKey BIGINT UNSIGNED NOT NULL,
   6    UNIQUE KEY (chronologicalKey),
   7    storyType varchar(64) NOT NULL,
   8    storyData LONGBLOB NOT NULL,
   9    authorPHID varchar(64) BINARY NOT NULL,
  10    dateCreated INT UNSIGNED NOT NULL,
  11    dateModified INT UNSIGNED NOT NULL
  12  );
  13  
  14  CREATE TABLE {$NAMESPACE}_feed.feed_storyreference (
  15    objectPHID varchar(64) BINARY NOT NULL,
  16    chronologicalKey BIGINT UNSIGNED NOT NULL,
  17    UNIQUE KEY (objectPHID, chronologicalKey),
  18    KEY (chronologicalKey)
  19  );