[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_feed.feed_storynotification (
   2    userPHID varchar(64) not null collate utf8_bin,
   3    primaryObjectPHID varchar(64) not null collate utf8_bin,
   4    chronologicalKey BIGINT UNSIGNED NOT NULL,
   5    hasViewed boolean not null,
   6    UNIQUE KEY (userPHID, chronologicalKey),
   7    KEY (userPHID, hasViewed, primaryObjectPHID)
   8  ) ENGINE=InnoDB, COLLATE utf8_general_ci;