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