mirror of
https://github.com/LemmyNet/lemmy.git
synced 2024-05-17 01:12:39 +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.
29 lines
637 B
SQL
29 lines
637 B
SQL
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);
|
|
|