Files

3 lines
195 B
SQL

ALTER TABLE app_users ADD COLUMN IF NOT EXISTS oidc_groups_json JSON NULL;
UPDATE app_users SET oidc_groups_json = JSON_ARRAY() WHERE oidc_identity_hash IS NOT NULL AND oidc_groups_json IS NULL;