ALTER TABLE `engine4_payment_gateways` ADD `is_recurring` TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'If any gateway supports recurring, use 1; otherwise, use 0.';

ALTER TABLE `engine4_payment_orders` ADD `gateway_type` VARCHAR(255) NULL DEFAULT NULL;

UPDATE `engine4_payment_gateways` SET `is_recurring` = '1' WHERE `engine4_payment_gateways`.`plugin` = 'Payment_Plugin_Gateway_PayPal';
UPDATE `engine4_payment_gateways` SET `is_recurring` = '1' WHERE `engine4_payment_gateways`.`plugin` = 'Payment_Plugin_Gateway_Stripe';

INSERT IGNORE INTO `engine4_payment_gateways` (`gateway_id`, `title`, `description`, `enabled`, `plugin`, `test_mode`, `is_recurring`) VALUES
(3000, 'Wallet', NULL, 0, 'Payment_Plugin_Gateway_Wallet', 0, 1);