8 lines
266 B
MySQL
8 lines
266 B
MySQL
|
-- 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');
|