db/ddl.sql in killbill-paypal-express-4.1.7 vs db/ddl.sql in killbill-paypal-express-5.0.0
- old
+ new
@@ -46,11 +46,12 @@
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`kb_account_id` varchar(255) NOT NULL,
`kb_tenant_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
- KEY `index_paypal_express_transactions_on_kb_payment_id` (`kb_payment_id`)
+ KEY `index_paypal_express_transactions_on_kb_payment_id` (`kb_payment_id`),
+ KEY `idx_paypal_express_transactions_on_paypal_express_response_id` (`paypal_express_response_id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE `paypal_express_responses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`api_call` varchar(255) NOT NULL,
@@ -110,7 +111,8 @@
`success` tinyint(1) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`kb_account_id` varchar(255) DEFAULT NULL,
`kb_tenant_id` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`),
+ KEY `idx_paypal_express_responses_on_kb_payment_id_kb_tenant_id` (`kb_payment_id`, `kb_tenant_id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;