ANixuM9N

1CREATE TABLE IF NOT EXISTS `mg_klarna_kco_order` (
2  `kco_order_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Order Id',
3  `klarna_checkout_id` varchar(255) NULL COMMENT 'Klarna Checkout Id',
4  `klarna_reservation_id` varchar(255) NULL COMMENT 'Klarna Reservation Id',
5  `order_id` int UNSIGNED NOT NULL COMMENT 'Order Id',
6  `is_acknowledged` smallint NOT NULL default '0' COMMENT 'Is Acknowledged',
7  PRIMARY KEY (`kco_order_id`),
8  CONSTRAINT `MG_KLARNA_KCO_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `mg_sales_order` (`entity_id`) ON DELETE CASCADE
9) COMMENT = 'Klarna Checkout Order' ENGINE = INNODB charset = utf8 COLLATE = utf8_general_ci