Dont use sha hash for password reset token (fixes #3491) (#3795)

[lemmy.git] / migrations / 2023-06-22-051755_fix_local_communities_marked_non_local / up.sql

UPDATE
    community c
SET
    local = TRUE
FROM
    local_site ls
    JOIN site s ON ls.site_id = s.id
WHERE
    c.instance_id = s.instance_id
    AND NOT c.local;