db/ddl.sql in killbill-paypal-express-1.6.0 vs db/ddl.sql in killbill-paypal-express-1.6.1
- old
+ new
@@ -9,11 +9,11 @@
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_paypal_express_payment_methods_on_kb_account_id` (`kb_account_id`),
KEY `index_paypal_express_payment_methods_on_kb_payment_method_id` (`kb_payment_method_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE `paypal_express_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`paypal_express_response_id` int(11) NOT NULL,
`api_call` varchar(255) NOT NULL,
@@ -22,11 +22,11 @@
`amount_in_cents` int(11) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_paypal_express_transactions_on_kb_payment_id` (`kb_payment_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) 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,
`kb_payment_id` varchar(255) DEFAULT NULL,
@@ -82,6 +82,6 @@
`success` tinyint(1) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `index_paypal_express_responses_on_token_and_api_call` (`token`, `api_call`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;