1 -- Drop the materialized / built views
4 CREATE VIEW reply_view AS
8 c2.creator_id AS sender_id,
9 c.creator_id AS recipient_id
12 INNER JOIN comment c2 ON c.id = c2.parent_id
14 c2.creator_id != c.creator_id
15 -- Do union where post is null
19 c.creator_id AS sender_id,
20 p.creator_id AS recipient_id
26 AND c.parent_id IS NULL
27 AND c.creator_id != p.creator_id
31 closereply.recipient_id
36 closereply.id = cv.id;