-- MySQL dump 10.13  Distrib 5.7.42, for Linux (x86_64)
--
-- Host: localhost    Database: kostal
-- ------------------------------------------------------
-- Server version	5.7.42-0ubuntu0.18.04.1-log

/*!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 `descripcion`
--

DROP TABLE IF EXISTS `descripcion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `descripcion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contenido` longtext COLLATE utf8_spanish_ci NOT NULL,
  `date_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `descripcion`
--

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

--
-- Table structure for table `pedidos_alephcrm`
--

DROP TABLE IF EXISTS `pedidos_alephcrm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidos_alephcrm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ExternalOrderId` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
  `IdOrderAleph` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
  `orderId` int(11) DEFAULT NULL,
  `idSellerAccount` int(11) DEFAULT NULL,
  `SellerAccountName` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
  `date_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `custom_1` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
  `custom_2` int(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidos_alephcrm`
--

LOCK TABLES `pedidos_alephcrm` WRITE;
/*!40000 ALTER TABLE `pedidos_alephcrm` DISABLE KEYS */;
INSERT INTO `pedidos_alephcrm` VALUES (1,'2000006374565444','5914203',100034730,21908,'Elektro Bremse','2023-09-28 11:57:48','2000004786023051',NULL),(2,'2000006391369946','5927117',100034731,21908,'Elektro Bremse','2023-09-28 11:57:54','2000004794224081',NULL),(3,'2000006418967994','5952268',100034732,21908,'Elektro Bremse','2023-09-28 11:57:59','',NULL),(4,'2000006481188976','6007944',100034733,21908,'Elektro Bremse','2023-09-28 11:58:05','',NULL),(5,'2000006544193722','6063573',100034734,22240,'Carlos Andretich SA','2023-09-28 11:58:11','',NULL),(6,'2000006597078914','6114979',100035000,21909,'Jorge Micolini S.A','2023-10-04 09:58:29','',NULL),(7,'2000006692663414','6211221',100035372,21908,'Elektro Bremse','2023-10-17 18:58:39','',NULL),(8,'2000006830044192','6351377',100036036,22240,'Carlos Andretich SA','2023-11-06 18:58:37','',NULL),(9,'2000006864407828','6388220',100036255,21908,'Elektro Bremse','2023-11-10 18:58:38','',NULL),(10,'2000006919004188','6439419',100036570,21908,'Elektro Bremse','2023-11-17 20:58:41','',NULL),(11,'2000007141169630','6626896',100037412,21908,'Elektro Bremse','2023-12-13 15:58:42','',NULL),(12,'2000007157918964','6640774',100037525,21908,'Elektro Bremse','2023-12-15 09:58:42','',NULL),(13,'2000007174463634','6651891',100037599,21908,'Elektro Bremse','2023-12-18 07:58:42','',NULL),(14,'2000007279615802','6734101',100037988,22831,'BOGGIO ECG REP.','2024-01-03 10:59:18','2000005241389115',NULL),(15,'2000007282339876','6736191',100037989,21908,'Elektro Bremse','2024-01-03 10:59:22','',NULL),(16,'2000007318290684','6770269',100038102,21908,'Elektro Bremse','2024-01-08 07:58:51','',NULL),(17,'2000007350749330','6798032',100038270,21908,'Elektro Bremse','2024-01-10 15:58:58','',NULL),(18,'2000007440044430','6871597',100038736,21908,'Elektro Bremse','2024-01-22 20:59:00','',NULL),(19,'2000007611029494','7016589',100039646,21908,'Elektro Bremse','2024-02-15 16:58:59','',NULL),(20,'2000007997735188','7345683',100041567,21908,'Elektro Bremse','2024-04-08 19:59:06','',NULL),(21,'2000008103025086','7443654',100042097,21908,'Elektro Bremse','2024-04-22 19:59:01','',NULL),(22,'2000008146197004','7483660',100042318,21908,'Elektro Bremse','2024-04-29 07:59:07','',NULL);
/*!40000 ALTER TABLE `pedidos_alephcrm` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sellers_alephcrm`
--

DROP TABLE IF EXISTS `sellers_alephcrm`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sellers_alephcrm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idSellerAccount` smallint(6) NOT NULL,
  `codigoCliente` smallint(6) NOT NULL,
  `note` longtext NOT NULL,
  `date_add` datetime 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 `sellers_alephcrm`
--

LOCK TABLES `sellers_alephcrm` WRITE;
/*!40000 ALTER TABLE `sellers_alephcrm` DISABLE KEYS */;
/*!40000 ALTER TABLE `sellers_alephcrm` 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 2024-07-30 22:06:06
