mirror of
https://github.com/LemmyNet/lemmy
synced 2024-10-30 15:21:20 +00:00
a00313e680
* Merge /site_inbox into /inbox (fixes #4137) Get rid of different inboxes, only use /inbox Remove shared_inbox_url db columns add code migration move to db migration, fixes machete fix sql drop inbox url unique constraints Dont create auth cookie in backend (#4136) dont change individual inboxes to shared inbox Dont send comment reply to user who has community blocked. Fixes #3684 (#4096) * Dont send comment reply to user who has community blocked. Fixes #3684 * Adding source instance block check. * Adding api test. * Addressing PR comments. * move site inbox rewrite to db * fix test * clippy * clippy 2 * fix test
27 lines
561 B
SQL
27 lines
561 B
SQL
ALTER TABLE person
|
|
ADD CONSTRAINT idx_person_inbox_url UNIQUE (inbox_url);
|
|
|
|
ALTER TABLE community
|
|
ADD CONSTRAINT idx_community_inbox_url UNIQUE (inbox_url);
|
|
|
|
UPDATE
|
|
site
|
|
SET
|
|
inbox_url = inbox_query.inbox
|
|
FROM (
|
|
SELECT
|
|
format('https://%s/site_inbox', DOMAIN) AS inbox
|
|
FROM
|
|
instance,
|
|
site,
|
|
local_site
|
|
WHERE
|
|
instance.id = site.instance_id
|
|
AND local_site.id = site.id) AS inbox_query,
|
|
instance,
|
|
local_site
|
|
WHERE
|
|
instance.id = site.instance_id
|
|
AND local_site.id = site.id;
|
|
|