-- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for Win32 (AMD64)
--
-- Host: localhost    Database: excluded_order
-- ------------------------------------------------------
-- Server version	10.1.26-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `brand_anomilies_log`
--

DROP TABLE IF EXISTS `brand_anomilies_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brand_anomilies_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log` text NOT NULL,
  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `brand_anomilies_log`
--

LOCK TABLES `brand_anomilies_log` WRITE;
/*!40000 ALTER TABLE `brand_anomilies_log` DISABLE KEYS */;
INSERT INTO `brand_anomilies_log` VALUES (1,'sehat_pro_auto_increment_id = 7637lastword_pro_auto_increment_id = 7640b2b_pro_auto_increment_id = 7637','2017-07-04 10:58:08'),(2,'sehat_pro_auto_increment_id = 7638lastword_pro_auto_increment_id = 7640b2b_pro_auto_increment_id = 7638','2017-07-10 05:21:05'),(3,'sehat_brand_auto_increment_id = 7638lastword_brand_auto_increment_id = 7640b2b_brand_auto_increment_id = 7638','2017-07-11 06:46:03'),(4,'sehat_brand_auto_increment_id = 7639lastword_brand_auto_increment_id = 7640b2b_brand_auto_increment_id = 7639','2017-07-11 09:23:51');
/*!40000 ALTER TABLE `brand_anomilies_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `brand_autoincrements_anomalies`
--

DROP TABLE IF EXISTS `brand_autoincrements_anomalies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brand_autoincrements_anomalies` (
  `rec_id` int(11) NOT NULL AUTO_INCREMENT,
  `sehatdb_brandid` int(11) NOT NULL,
  `tlwdb_brandid` int(11) NOT NULL,
  `b2b_brandid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rec_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `brand_autoincrements_anomalies`
--

LOCK TABLES `brand_autoincrements_anomalies` WRITE;
/*!40000 ALTER TABLE `brand_autoincrements_anomalies` DISABLE KEYS */;
INSERT INTO `brand_autoincrements_anomalies` VALUES (1,7639,7639,7639,1,'2017-07-11 10:35:23');
/*!40000 ALTER TABLE `brand_autoincrements_anomalies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `brands_duplicates`
--

DROP TABLE IF EXISTS `brands_duplicates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brands_duplicates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `brand_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `brands_duplicates`
--

LOCK TABLES `brands_duplicates` WRITE;
/*!40000 ALTER TABLE `brands_duplicates` DISABLE KEYS */;
INSERT INTO `brands_duplicates` VALUES (1,6260,'2017-07-04 10:58:08'),(2,6262,'2017-07-04 10:58:08'),(3,6265,'2017-07-04 10:58:08'),(4,6266,'2017-07-04 10:58:08'),(5,6267,'2017-07-04 10:58:08'),(6,6269,'2017-07-04 10:58:08'),(7,6271,'2017-07-04 10:58:08'),(8,6646,'2017-07-04 10:58:08'),(9,6647,'2017-07-04 10:58:08'),(10,6648,'2017-07-04 10:58:08'),(11,6649,'2017-07-04 10:58:08'),(12,6650,'2017-07-04 10:58:08'),(13,6651,'2017-07-04 10:58:08'),(14,6652,'2017-07-04 10:58:08'),(15,7637,'2017-07-10 05:21:05'),(16,7638,'2017-07-11 09:23:51');
/*!40000 ALTER TABLE `brands_duplicates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customer_autoincrements_anomalies`
--

DROP TABLE IF EXISTS `customer_autoincrements_anomalies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer_autoincrements_anomalies` (
  `recid` int(11) NOT NULL AUTO_INCREMENT,
  `sehatdb_custid` int(11) NOT NULL,
  `tlwdb_custid` int(11) NOT NULL,
  `b2b_custid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`recid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer_autoincrements_anomalies`
--

LOCK TABLES `customer_autoincrements_anomalies` WRITE;
/*!40000 ALTER TABLE `customer_autoincrements_anomalies` DISABLE KEYS */;
/*!40000 ALTER TABLE `customer_autoincrements_anomalies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers_anomilies_log`
--

DROP TABLE IF EXISTS `customers_anomilies_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers_anomilies_log` (
  `rec_id` int(11) NOT NULL AUTO_INCREMENT,
  `log` text NOT NULL,
  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rec_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customers_anomilies_log`
--

LOCK TABLES `customers_anomilies_log` WRITE;
/*!40000 ALTER TABLE `customers_anomilies_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `customers_anomilies_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers_duplicates`
--

DROP TABLE IF EXISTS `customers_duplicates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers_duplicates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customers_duplicates`
--

LOCK TABLES `customers_duplicates` WRITE;
/*!40000 ALTER TABLE `customers_duplicates` DISABLE KEYS */;
/*!40000 ALTER TABLE `customers_duplicates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_autoincrements_anomalies`
--

DROP TABLE IF EXISTS `order_autoincrements_anomalies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_autoincrements_anomalies` (
  `recid` int(11) NOT NULL AUTO_INCREMENT,
  `sehatdb_ordid` int(11) NOT NULL,
  `tlwdb_ordid` int(11) NOT NULL,
  `b2b_ordid` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`recid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_autoincrements_anomalies`
--

LOCK TABLES `order_autoincrements_anomalies` WRITE;
/*!40000 ALTER TABLE `order_autoincrements_anomalies` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_autoincrements_anomalies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_duplicates`
--

DROP TABLE IF EXISTS `order_duplicates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_duplicates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_duplicates`
--

LOCK TABLES `order_duplicates` WRITE;
/*!40000 ALTER TABLE `order_duplicates` DISABLE KEYS */;
INSERT INTO `order_duplicates` VALUES (1,23070,'2017-07-04 10:58:07'),(2,21499,'2017-07-04 10:58:07'),(3,22981,'2017-07-04 10:58:07'),(4,23071,'2017-07-04 10:58:07'),(5,23862,'2017-07-10 05:21:05'),(6,24364,'2017-07-24 11:39:10'),(7,24602,'2017-08-02 08:05:27');
/*!40000 ALTER TABLE `order_duplicates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders_anomilies_log`
--

DROP TABLE IF EXISTS `orders_anomilies_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders_anomilies_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log` text NOT NULL,
  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders_anomilies_log`
--

LOCK TABLES `orders_anomilies_log` WRITE;
/*!40000 ALTER TABLE `orders_anomilies_log` DISABLE KEYS */;
INSERT INTO `orders_anomilies_log` VALUES (1,'sehat_order_auto_increment_id = 24042lastword_order_auto_increment_id = 24042b2b_order_auto_increment_id = 22200','2017-07-11 09:23:49');
/*!40000 ALTER TABLE `orders_anomilies_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pro_anomilies_log`
--

DROP TABLE IF EXISTS `pro_anomilies_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pro_anomilies_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log` text NOT NULL,
  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pro_anomilies_log`
--

LOCK TABLES `pro_anomilies_log` WRITE;
/*!40000 ALTER TABLE `pro_anomilies_log` DISABLE KEYS */;
INSERT INTO `pro_anomilies_log` VALUES (1,'sehat_pro_auto_increment_id = 41175lastword_pro_auto_increment_id = 41063b2b_pro_auto_increment_id = 41176','2017-08-02 08:05:28');
/*!40000 ALTER TABLE `pro_anomilies_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pro_autoincrements_anomalies`
--

DROP TABLE IF EXISTS `pro_autoincrements_anomalies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pro_autoincrements_anomalies` (
  `rec_id` int(11) NOT NULL AUTO_INCREMENT,
  `sehatdb_proid` int(11) NOT NULL,
  `tlwdb_proid` int(11) NOT NULL,
  `b2b_proid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rec_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pro_autoincrements_anomalies`
--

LOCK TABLES `pro_autoincrements_anomalies` WRITE;
/*!40000 ALTER TABLE `pro_autoincrements_anomalies` DISABLE KEYS */;
INSERT INTO `pro_autoincrements_anomalies` VALUES (1,41175,41063,41176,-1,'2017-08-02 08:05:28');
/*!40000 ALTER TABLE `pro_autoincrements_anomalies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products_duplicates`
--

DROP TABLE IF EXISTS `products_duplicates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products_duplicates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pro_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products_duplicates`
--

LOCK TABLES `products_duplicates` WRITE;
/*!40000 ALTER TABLE `products_duplicates` DISABLE KEYS */;
/*!40000 ALTER TABLE `products_duplicates` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-04-27 17:19:12
