recaptime.dev / phorge
@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge
phorge phabricator
fork atom
phorge / resources / sql / patches / 138.notification.sql
at recaptime-dev/main 8 lines 372 B view raw
Keebuhm Park SQL patch for notification
207f101a
1CREATE 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;