1 ALTER TABLE private_message
2 ADD COLUMN ap_id character varying(255) NOT NULL DEFAULT 'http://fake.com', -- This needs to be checked and updated in code, building from the site url if local
3 ADD COLUMN local boolean NOT NULL DEFAULT TRUE;
5 DROP MATERIALIZED VIEW private_message_mview;
7 DROP VIEW private_message_view;
9 CREATE VIEW private_message_view AS
12 u.name AS creator_name,
13 u.avatar AS creator_avatar,
14 u.actor_id AS creator_actor_id,
15 u.local AS creator_local,
16 u2.name AS recipient_name,
17 u2.avatar AS recipient_avatar,
18 u2.actor_id AS recipient_actor_id,
19 u2.local AS recipient_local
22 INNER JOIN user_ u ON u.id = pm.creator_id
23 INNER JOIN user_ u2 ON u2.id = pm.recipient_id;
25 CREATE MATERIALIZED VIEW private_message_mview AS
31 CREATE UNIQUE INDEX idx_private_message_mview_id ON private_message_mview (id);