INSERT INTO systemsettings (type, value, description, active, created, createdById, updated, updatedById)
VALUES
('auspost_credentials', '', 'AusPost Production Credentials{"username" : "", "password" : "", "account_number" : "", "parcel_post_product_id": "", "express_post_product_id":"", "transit_cover":1, "signature_on_delivery":0, "branded":1}', '1', UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10'),
('startrack_credentials', '', 'StarTrack Production Credentials {"username" : "", "password" : "", "account_number" : "", "exp_product_id": "", "prm_product_id":""}', '1', UTC_TIMESTAMP, '10', UTC_TIMESTAMP, '10');

DELETE FROM systemsettings
where type = 'b2b_soap_timezone';
DELETE FROM systemsettings
where type = 'last_new_price_push';
DELETE FROM systemsettings
where type = 'last_new_product_pull';
DELETE FROM systemsettings
where type = 'last_full_product_pull';
DELETE FROM systemsettings
where type = 'warehouse_contact_email';
DELETE FROM systemsettings
where type = 'auto_send_inv_to_term_cus';
DELETE FROM systemsettings
where type = 'b2b_soap_last_import_ra_time';
DELETE FROM systemsettings
where type = 'xero_order_sync';
DELETE FROM systemsettings
where type = 'xero_credit_sync';
DELETE FROM systemsettings
where type = 'xero_bill_sync';

