mirror of
https://github.com/LemmyNet/lemmy.git
synced 2024-09-27 14:00:17 +00:00
be1389420b
* SQL format checking, 1. * SQL format checking, 2. * SQL format checking, 3. * SQL format checking, 4. * SQL format checking, 5. * Running pg_format * Getting rid of comment. * Upping pg_format version. * Using git ls-files for sql format check. * Fixing sql lints. * Addressing PR comments.
32 lines
946 B
SQL
32 lines
946 B
SQL
ALTER TABLE private_message
|
|
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
|
|
ADD COLUMN local boolean NOT NULL DEFAULT TRUE;
|
|
|
|
DROP MATERIALIZED VIEW private_message_mview;
|
|
|
|
DROP VIEW private_message_view;
|
|
|
|
CREATE VIEW private_message_view AS
|
|
SELECT
|
|
pm.*,
|
|
u.name AS creator_name,
|
|
u.avatar AS creator_avatar,
|
|
u.actor_id AS creator_actor_id,
|
|
u.local AS creator_local,
|
|
u2.name AS recipient_name,
|
|
u2.avatar AS recipient_avatar,
|
|
u2.actor_id AS recipient_actor_id,
|
|
u2.local AS recipient_local
|
|
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);
|
|
|