 VALUES
   (1, 'shipping_item', 1, 1, 1),
   (2, 'shipping_item', 1, 2, 2);
-
-INSERT INTO `shipping_external_data` (`id`, `key`, `price`, `delivery_time`)
-VALUES
-  (1, 'd761e47991d9ab8926e9b5dc62bc6464', '10.00', '2|4');

  `state` varchar(100) NULL,
  `fax` varchar(100) NULL,
  `is_deleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `shipping_external_data`;
CREATE TABLE `shipping_external_data` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` varchar(100) NOT NULL,
  `price` DECIMAL(10,2) NOT NULL,
  `delivery_time` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


VALUES
  (1, 'shipping', 'Normal', 'GBP', '2|3', 3, 1),
  (2, 'shipping', 'Custom', 'GBP', '1|5', 4, 1),
  (3, 'shipping', 'Normal', 'GBP', '1|5', 4, 2);

INSERT INTO `shipping_groups` (`id`, `price`, `delivery_time`, `shipping_id`, `method_id`, `location_id`)
VALUES
