migrations/2020-05-05-210233_add_activitypub_for_private_messages/down.sql

   1 DROP MATERIALIZED VIEW private_message_mview;
   2
   3 DROP VIEW private_message_view;
   4
   5 ALTER TABLE private_message
   6     DROP COLUMN ap_id,
   7     DROP COLUMN local;
   8
   9 CREATE VIEW private_message_view AS
  10 SELECT
  11     pm.*,
  12     u.name AS creator_name,
  13     u.avatar AS creator_avatar,
  14     u2.name AS recipient_name,
  15     u2.avatar AS recipient_avatar
  16 FROM
  17     private_message pm
  18     INNER JOIN user_ u ON u.id = pm.creator_id
  19     INNER JOIN user_ u2 ON u2.id = pm.recipient_id;
  20
  21 CREATE MATERIALIZED VIEW private_message_mview AS
  22 SELECT
  23     *
  24 FROM
  25     private_message_view;
  26
  27 CREATE UNIQUE INDEX idx_private_message_mview_id ON private_message_mview (id);
  28