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


--
-- Table structure for table `api_mintsoft`
--

CREATE TABLE `api_mintsoft` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `retailer_id` int(11) NOT NULL,
  `retailer_db` varchar(32) CHARACTER SET latin1 NOT NULL,
  `apiKey` varchar(128) CHARACTER SET latin1 NOT NULL,
  `keyObtained` datetime NOT NULL,
  `keyValidity` int(11) NOT NULL,
  `username` varchar(64) CHARACTER SET latin1 NOT NULL,
  `password` varchar(64) CHARACTER SET latin1 NOT NULL,
  `baseUrl` varchar(64) CHARACTER SET latin1 NOT NULL,
  `warehouse_id` int(2) NOT NULL,
  `warehouseName` varchar(32) CHARACTER SET latin1 NOT NULL,
  `spToken` varchar(32) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `spToken` (`spToken`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `api_mintsoft`
--

INSERT INTO `api_mintsoft` VALUES (1,11700,'ecommerce_skinfood','737b37a3-395c-465c-afd9-feb96be45ef0','2021-07-07 16:57:11',24,'HPF2Bf0ebbA86JsCW0+/TA==','SXOYhPUaH7lCQYAbYR3j8g==','https://api.mintsoft.co.uk/api/',8,'Test (skinfood)','4498ba2f83fb74a98d5a251845abd018');

--
-- 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','');


