lemmy/migrations/2025-08-01-000068_local_user_trigger/down.sql

mirror of https://github.com/LemmyNet/lemmy.git synced 2025-09-02 03:03:57 +00:00
UPDATE
    local_site
SET
    users = (
        SELECT
            count(*)
        FROM
            local_user);
Update user count from local_user table instead of person table, and only count users with accepted application (#5495) * Update user count from local_user instead of person, and only count users with accepted application * fix * Update up.sql * Update down.sql 2025-03-11 15:37:40 +00:00			`UPDATE`
			`local_site`
			`SET`
			`users = (`
			`SELECT`
			`count(*)`
			`FROM`
			`local_user);`