diff options
Diffstat (limited to 'server/migrations/2020-05-05-210233_add_activitypub_for_private_messages/down.sql')
-rw-r--r-- | server/migrations/2020-05-05-210233_add_activitypub_for_private_messages/down.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/server/migrations/2020-05-05-210233_add_activitypub_for_private_messages/down.sql b/server/migrations/2020-05-05-210233_add_activitypub_for_private_messages/down.sql new file mode 100644 index 00000000..15c92859 --- /dev/null +++ b/server/migrations/2020-05-05-210233_add_activitypub_for_private_messages/down.sql @@ -0,0 +1,21 @@ +drop materialized view private_message_mview; +drop view private_message_view; + +alter table private_message +drop column ap_id, +drop column local; + +create view private_message_view as +select +pm.*, +u.name as creator_name, +u.avatar as creator_avatar, +u2.name as recipient_name, +u2.avatar as recipient_avatar +from private_message pm +inner join user_ u on u.id = pm.creator_id +inner join user_ u2 on u2.id = pm.recipient_id; + +create materialized view private_message_mview as select * from private_message_view; + +create unique index idx_private_message_mview_id on private_message_mview (id); |