INSERT INTO `shop_payment_gateways` (`site_id`, `enabled`, `gateway_name`, `filename`, `configuration`, `sort`) VALUES (1, 1, 'Credit Card - Processed by <a href="https://stripe.com" target="_blank">Stripe</a>', 'stripe', 'private_key=\npublic_key=\n\n', 1);
INSERT INTO `shop_shipping_gateways` (`site_id`, `enabled`, `gateway_name`, `filename`, `configuration`, `sort`) VALUES (1, 1, 'Flat Rate', 'flatrate', 'rate=20\n', 1);
UPDATE `shop_payment_gateways` SET `gateway_name`='Credit Card - Processed by <a href="https://www.elavon.com" target="_blank">Elavon</a>' WHERE `filename`="creditcard";
INSERT INTO `shop_shipping_gateways` (`site_id`, `enabled`, `gateway_name`, `filename`, `configuration`, `sort`) VALUES (1, 1, 'Shippo', 'goshippo', 'api_key=shippo_live_40cdfb32a669e1b462df412a59adfc0397c9c8dc\naddress=\ncity=\nprovince=ON\npostalcode=\ncountry=CA\ndefault_length=10\ndefault_width=10\ndefault_height=10\ndefault_weight=3\n', 1);
ALTER TABLE `shop_orders` ADD IF NOT EXISTS `shipping_gateway_service` VARCHAR(255) AFTER `shipping_gateway_id`;
