--
-- Host: localhost    Database: secpay_global
-- ------------------------------------------------------


--
-- Table structure for table `productfinder`
--

CREATE TABLE `productfinder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `retailer_id` int(11) NOT NULL,
  `retailer_db` varchar(50) NOT NULL,
  `base_url` varchar(60) NOT NULL,
  `suffix_construct` varchar(60) NOT NULL,
  `failure_url` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `productfinder`
--

INSERT INTO `productfinder` VALUES (1,11700,'ecommerce_skinfood','https://www.skinfood.im','/prod_cat/P_<mechandise_name>_<product_id>.shtml','');


