--
-- Host: localhost    Database: apis
-- ------------------------------------------------------


--
-- Table structure for table `api_list`
--

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

--
-- Dumping data for table `api_list`
--

INSERT INTO `api_list` VALUES (1,11700,'ecommerce_skinfood','1XD4gQ5xkOe25gzeud2X3fLGD/VNmMaDuQW5BbyhSwwvSomE69fIijJ/DhkcvV+6','2020-12-18 10:00:00',24,'HPF2Bf0ebbA86JsCW0+/TA==','SXOYhPUaH7lCQYAbYR3j8g==','https://api.mintsoft.co.uk/api/',8,'Test (skinfood)','4498ba2f83fb74a98d5a251845abd018');


