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

   1 drop materialized view private_message_mview;
   2 drop view private_message_view;
   3
   4 alter table private_message
   5 drop column ap_id,
   6 drop column local;
   7
   8 create view private_message_view as
   9 select
  10 pm.*,
  11 u.name as creator_name,
  12 u.avatar as creator_avatar,
  13 u2.name as recipient_name,
  14 u2.avatar as recipient_avatar
  15 from private_message pm
  16 inner join user_ u on u.id = pm.creator_id
  17 inner join user_ u2 on u2.id = pm.recipient_id;
  18
  19 create materialized view private_message_mview as select * from private_message_view;
  20
  21 create unique index idx_private_message_mview_id on private_message_mview (id);