8 lines
266 B
SQL
8 lines
266 B
SQL
-- disable prod environment in all delivery carriers
|
|
UPDATE delivery_carrier
|
|
SET prod_environment = false;
|
|
-- disable delivery carriers from external providers
|
|
UPDATE delivery_carrier
|
|
SET active = false
|
|
WHERE delivery_type NOT IN ('fixed', 'base_on_rule');
|