Compare commits
3 Commits
feature/su
...
feature/pl
| Author | SHA1 | Date | |
|---|---|---|---|
| f2ad5c9d7d | |||
| 3bc2cf09c3 | |||
| e619c12c35 |
@@ -3,4 +3,8 @@ update public.plesk_domains d
|
||||
set status = coalesce(s.status, 'unknown')
|
||||
from public.plesk_subscriptions s
|
||||
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;
|
||||
Reference in New Issue
Block a user