Compare commits

...

3 Commits

View File

@@ -4,3 +4,7 @@ set status = coalesce(s.status, 'unknown')
from public.plesk_subscriptions s from public.plesk_subscriptions s
where d.subscription_id = s.id where d.subscription_id = s.id
and d.agency_id = s.agency_id; and d.agency_id = s.agency_id;
update public.plesk_subscriptions
set status = 'unknown'
where status is null;