7 lines
268 B
SQL
7 lines
268 B
SQL
-- P5-3705 Remove states from non-US contract customers
|
|
|
|
UPDATE contract_customers SET state = null WHERE state is not null and country != 'US';
|
|
|
|
UPDATE contract_customers SET "delivery-state" = null WHERE "delivery-state" is not null and "delivery-country" != 'US';
|
|
|