-- MySQL dump 10.16  Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------
-- Server version	10.1.48-MariaDB-0+deb9u2

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

DROP TABLE IF EXISTS `maesartiequlin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maesartiequlin` (
  `cod_articulo` char(30) NOT NULL DEFAULT '' COMMENT 'Artículo',
  `cod_equiva` char(6) NOT NULL DEFAULT '' COMMENT 'Equivalencia',
  `siglas` char(5) NOT NULL DEFAULT '' COMMENT 'Siglas',
  `ind_proceso` char(1) NOT NULL DEFAULT 'A' COMMENT 'Indicador de proceso',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `id_maesartiequlin` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº registro',
  `tip_equiva` char(4) NOT NULL DEFAULT 'GEN' COMMENT 'Tipo equivalencia',
  `maesartiequlin_orden` int(11) NOT NULL DEFAULT '0' COMMENT 'Orden producto/equiv.',
  UNIQUE KEY `key0` (`id_tenant`,`id_maesartiequlin`),
  UNIQUE KEY `key1` (`id_tenant`,`cod_articulo`,`tip_equiva`),
  KEY `key2` (`id_tenant`,`cod_equiva`,`maesartiequlin_orden`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maesartiequlin`
--
-- WHERE:  id_tenant='1'

LOCK TABLES `maesartiequlin` WRITE;
/*!40000 ALTER TABLE `maesartiequlin` DISABLE KEYS */;
INSERT INTO `maesartiequlin` (`cod_articulo`, `cod_equiva`, `siglas`, `ind_proceso`, `id_tenant`, `id_maesartiequlin`, `tip_equiva`, `maesartiequlin_orden`) VALUES ('TEL-100078-120','1','','A',1,2,'GEN',1),('TEL-100232-120','1','','A',1,3,'GEN',2),('TEL-103019-120','1','','A',1,4,'GEN',3),('TEL-200006-120','2','','A',1,5,'GEN',1),('TEL-205002-120','2','','A',1,6,'GEN',2),('TEL-200981-120','2','','A',1,7,'GEN',3),('TEL-100034-120','3','','A',1,8,'GEN',1),('TEL-100273-120','3','','A',1,9,'GEN',2),('TEL-106001-120','3','','A',1,10,'GEN',3),('TEL-103120-120','3','','A',1,11,'GEN',4),('TEL-100041-120','4','','A',1,12,'GEN',1),('TEL-106027-120','4','','A',1,13,'GEN',2),('TEL-100119-120','4','','A',1,14,'GEN',3),('TEL-100042-120','5','','A',1,15,'GEN',1),('TEL-106007-120','5','','A',1,16,'GEN',2),('TEL-100267-120','5','','A',1,17,'GEN',3),('TEL-100046-120','6','','A',1,18,'GEN',1),('TEL-106006-120','6','','A',1,19,'GEN',2),('TEL-100227-120','6','','A',1,20,'GEN',3),('TEL-100082-120','6','','A',1,21,'GEN',4),('TEL-100047-120','7','','A',1,22,'GEN',1),('TEL-106024-120','7','','A',1,23,'GEN',2),('TEL-100061-120','8','','A',1,24,'GEN',1),('TEL-106034-120','8','','A',1,25,'GEN',2),('TEL-100277-120','8','','A',1,26,'GEN',3),('TEL-100085-120','9','','A',1,27,'GEN',2),('TEL-106040-120','9','','A',1,28,'GEN',3),('TEL-100230-120','9','','A',1,29,'GEN',4),('TEL-100088-120','10','','A',1,30,'GEN',2),('TEL-106022-120','10','','A',1,31,'GEN',3),('TEL-100027-120','10','','A',1,32,'GEN',4),('TEL-100089-120','11','','A',1,33,'GEN',1),('TEL-106013-120','11','','A',1,34,'GEN',2),('TEL-100115-120','12','','A',1,35,'GEN',1),('TEL-100276-120','12','','A',1,36,'GEN',2),('TEL-106029-120','12','','A',1,37,'GEN',3),('TEL-100151-120','13','','A',1,38,'GEN',1),('TEL-100278-120','13','','A',1,39,'GEN',2),('TEL-106036-120','13','','A',1,40,'GEN',3),('TEL-100177-120','14','','A',1,41,'GEN',1),('TEL-100799-120','14','','A',1,42,'GEN',2),('TEL-106038-120','14','','A',1,43,'GEN',3),('TEL-100181-120','15','','A',1,44,'GEN',1),('TEL-106004-120','15','','A',1,45,'GEN',2),('TEL-100182-120','16','','A',1,46,'GEN',1),('TEL-106028-120','16','','A',1,47,'GEN',2),('TEL-100197-120','17','','A',1,48,'GEN',1),('TEL-100023-120','17','','A',1,49,'GEN',2),('TEL-106023-120','17','','A',1,50,'GEN',3),('TEL-100211-120','18','','A',1,51,'GEN',1),('TEL-100300-120','18','','A',1,52,'GEN',2),('TEL-106039-120','18','','A',1,53,'GEN',3),('TEL-100219-120','19','','A',1,54,'GEN',2),('TEL-106037-120','19','','A',1,55,'GEN',3),('TEL-100272-120','1','','A',1,56,'GEN',4),('TEL-106003-120','1','','A',1,57,'GEN',5),('TEL-100233-120','20','','A',1,58,'GEN',1),('TEL-100190-120','20','','A',1,59,'GEN',2),('TEL-106005-120','20','','A',1,60,'GEN',3),('TEL-100110-120','20','','A',1,61,'GEN',4),('TEL-100237-120','21','','A',1,62,'GEN',1),('TEL-106019-120','21','','A',1,63,'GEN',2),('TEL-100238-120','22','','A',1,64,'GEN',1),('TEL-106015-120','22','','A',1,65,'GEN',2),('TEL-100239-120','23','','A',1,66,'GEN',1),('TEL-100196-120','23','','A',1,67,'GEN',2),('TEL-106016-120','23','','A',1,68,'GEN',3),('TEL-100240-120','24','','A',1,69,'GEN',1),('TEL-106020-120','24','','A',1,70,'GEN',2),('TEL-100241-120','25','','A',1,71,'GEN',2),('TEL-106021-120','25','','A',1,72,'GEN',3),('TEL-100243-120','26','','A',1,73,'GEN',1),('TEL-100014-120','26','','A',1,74,'GEN',2),('TEL-106033-120','26','','A',1,75,'GEN',3),('TEL-100245-120','27','','A',1,76,'GEN',1),('TEL-100112-120','27','','A',1,77,'GEN',2),('TEL-106009-120','27','','A',1,78,'GEN',3),('TEL-100246-120','28','','A',1,79,'GEN',1),('TEL-100060-120','28','','A',1,80,'GEN',2),('TEL-106010-120','28','','A',1,81,'GEN',3),('TEL-100247-120','29','','A',1,82,'GEN',2),('TEL-100280-120','29','','A',1,83,'GEN',3),('TEL-106011-120','29','','A',1,84,'GEN',4),('TEL-100248-120','30','','A',1,85,'GEN',1),('TEL-100019-120','30','','A',1,86,'GEN',2),('TEL-106014-120','30','','A',1,87,'GEN',3),('TEL-100249-120','31','','A',1,88,'GEN',1),('TEL-100033-120','31','','A',1,89,'GEN',2),('TEL-106018-120','31','','A',1,90,'GEN',3),('TEL-100253-120','32','','A',1,91,'GEN',1),('TEL-100180-120','32','','A',1,92,'GEN',2),('TEL-106031-120','32','','A',1,93,'GEN',3),('TEL-100254-120','33','','A',1,94,'GEN',1),('TEL-100004-120','33','','A',1,95,'GEN',2),('TEL-106032-120','33','','A',1,96,'GEN',3),('TEL-100255-120','34','','A',1,97,'GEN',1),('TEL-106041-120','34','','A',1,98,'GEN',2),('TEL-100256-120','35','','A',1,99,'GEN',1),('TEL-100005-120','35','','A',1,100,'GEN',2),('TEL-106042-120','35','','A',1,101,'GEN',3),('TEL-100257-120','36','','A',1,102,'GEN',1),('TEL-106000-120','36','','A',1,103,'GEN',2),('TEL-100258-120','37','','A',1,104,'GEN',1),('TEL-100010-120','37','','A',1,105,'GEN',2),('TEL-106002-120','37','','A',1,106,'GEN',3),('TEL-100261-120','38','','A',1,107,'GEN',1),('TEL-100193-120','38','','A',1,108,'GEN',2),('TEL-106012-120','38','','A',1,109,'GEN',3),('TEL-106017-120','39','','A',1,112,'GEN',3),('TEL-100265-120','40','','A',1,113,'GEN',1),('TEL-100024-120','40','','A',1,114,'GEN',2),('TEL-106025-120','40','','A',1,115,'GEN',3),('TEL-100266-120','41','','A',1,116,'GEN',1),('TEL-100025-120','41','','A',1,117,'GEN',2),('TEL-106026-120','41','','A',1,118,'GEN',3),('TEL-100987-120','43','','A',1,122,'GEN',1),('TEL-106008-120','43','','A',1,123,'GEN',2),('TEL-101001-120','44','','A',1,124,'GEN',1),('TEL-106030-120','44','','A',1,125,'GEN',2),('TEL-208450-120','45','','A',1,126,'GEN',1),('TEL-106051-120','45','','A',1,127,'GEN',2),('TEL-208455-120','46','','A',1,128,'GEN',1),('TEL-106052-120','46','','A',1,129,'GEN',2),('TEL-100235-120','47','','A',1,130,'GEN',1),('TEL-106048-120','47','','A',1,131,'GEN',2),('TEL-2001028-120','48','','A',1,132,'GEN',1),('TEL-200027-120','48','','A',1,133,'GEN',2),('TEL-2001029-120','49','','A',1,134,'GEN',1),('TEL-200025-120','49','','A',1,135,'GEN',2),('TEL-200103-120','50','','A',1,136,'GEN',1),('TEL-200439-120','50','','A',1,137,'GEN',2),('TEL-200114-120','51','','A',1,138,'GEN',1),('TEL-200437-120','51','','A',1,139,'GEN',2),('TEL-200118-120','52','','A',1,140,'GEN',1),('TEL-200440-120','52','','A',1,141,'GEN',2),('TEL-200127-120','53','','A',1,142,'GEN',1),('TEL-200442-120','53','','A',1,143,'GEN',2),('TEL-200128-120','54','','A',1,144,'GEN',1),('TEL-200438-120','54','','A',1,145,'GEN',2),('TEL-200131-120','55','','A',1,146,'GEN',1),('TEL-200376-120','55','','A',1,147,'GEN',2),('TEL-200385-120','56','','A',1,148,'GEN',2),('TEL-200026-120','56','','A',1,149,'GEN',3),('TEL-200386-120','57','','A',1,150,'GEN',1),('TEL-200024-120','57','','A',1,151,'GEN',2),('TEL-200387-120','58','','A',1,152,'GEN',1),('TEL-200075-120','58','','A',1,153,'GEN',2),('TEL-200391-120','59','','A',1,154,'GEN',1),('TEL-200076-120','59','','A',1,155,'GEN',2),('TEL-200891-120','60','','A',1,156,'GEN',1),('TEL-200018-120','60','','A',1,157,'GEN',2),('TEL-201114-120','61','','A',1,158,'GEN',1),('TEL-200019-120','61','','A',1,159,'GEN',2),('TEL-201116-120','62','','A',1,160,'GEN',1),('TEL-200008-120','62','','A',1,161,'GEN',2),('TEL-100017-120','63','','A',1,162,'GEN',1),('TEL-106049-120','63','','A',1,163,'GEN',2),('TEL-100083-120','64','','A',1,164,'GEN',1),('TEL-106050-120','64','','A',1,165,'GEN',2),('TEL-200016-120','65','','A',1,166,'GEN',1),('TEL-205032-120','65','','A',1,167,'GEN',2),('TEL-200031-120','66','','A',1,168,'GEN',1),('TEL-205033-120','66','','A',1,169,'GEN',2),('TEL-200035-120','67','','A',1,170,'GEN',1),('TEL-205034-120','67','','A',1,171,'GEN',2),('TEL-200079-120','68','','A',1,172,'GEN',2),('TEL-205035-120','68','','A',1,173,'GEN',3),('TEL-200088-120','69','','A',1,174,'GEN',1),('TEL-205036-120','69','','A',1,175,'GEN',2),('TEL-200038-120','70','','A',1,176,'GEN',1),('TEL-205037-120','70','','A',1,177,'GEN',2),('TEL-200081-120','71','','A',1,178,'GEN',1),('TEL-205038-120','71','','A',1,179,'GEN',2),('TEL-200047-120','72','','A',1,180,'GEN',1),('TEL-205039-120','72','','A',1,181,'GEN',2),('TEL-100260-120','73','','A',1,182,'GEN',1),('TEL-100189-120','73','','A',1,183,'GEN',2),('TEL-100297-120','74','','A',1,184,'GEN',2),('TEL-100993-120','74','','A',1,185,'GEN',3),('TEL-100174-120','75','','A',1,186,'GEN',1),('TEL-100281-120','75','','A',1,187,'GEN',2),('TEL-100015-120','15','','A',1,188,'GEN',3),('TEL-100242-120','76','','A',1,189,'GEN',1),('TEL-100021-120','76','','A',1,190,'GEN',2),('TEL-205031-120','77','','A',1,191,'GEN',1),('TEL-200046-120','77','','A',1,192,'GEN',2),('TEL-100029-120','78','','A',1,193,'GEN',1),('TEL-100091-120','78','','A',1,194,'GEN',2),('TEL-201117-120','79','','A',1,195,'GEN',1),('TEL-205012-120','79','','A',1,196,'GEN',2),('TEL-200009-120','79','','A',1,197,'GEN',3),('TEL-200020-250','80','','A',1,198,'GEN',1),('TEL-201402-250','80','','A',1,199,'GEN',2),('TEL-200021-250','81','','A',1,200,'GEN',1),('TEL-201301-250','81','','A',1,201,'GEN',2),('TEL-205028-120','82','','A',1,202,'GEN',1),('TEL-200051-120','82','','A',1,203,'GEN',2),('TEL-100226-120','83','','A',1,204,'GEN',1),('TEL-100087-120','83','','A',1,205,'GEN',2),('TEL-100062-120','84','','A',1,206,'GEN',1),('TEL-100797-120','84','','A',1,207,'GEN',2),('TEL-103058-120','84','','A',1,208,'GEN',3),('TEL-100128-120','47','','A',1,209,'GEN',3),('TEL-201057-120','69','','A',1,211,'GEN',3),('TEL-100234-120','85','','A',1,213,'GEN',2),('TEL-100031-120','85','','A',1,214,'GEN',3),('TEL-100463-120','39','','A',1,215,'GEN',4),('TEL-100280-120R','29','','A',1,216,'GEN',5),('TEL-103020-120','32','','A',1,218,'GEN',4),('TEL-103021-120','40','','A',1,219,'GEN',4),('TEL-103022-120','31','','A',1,220,'GEN',4),('TEL-103023-120','24','','A',1,221,'GEN',3),('TEL-100026-120','24','','A',1,222,'GEN',4),('TEL-103024-120','30','','A',1,223,'GEN',4),('TEL-103025-120','22','','A',1,224,'GEN',3),('TEL-103026-120','29','','A',1,225,'GEN',6),('TEL-103027-120','37','','A',1,226,'GEN',4),('TEL-103016-120','12','','A',1,227,'GEN',4),('TEL-100901-120','86','','A',1,228,'GEN',1),('TEL-103028-120','86','','A',1,229,'GEN',2),('TEL-100003-120','86','','A',1,230,'GEN',3),('TEL-1001023-120','86','','A',1,231,'GEN',4),('TEL-103029-120','78','','A',1,232,'GEN',3),('TEL-103030-120','1','','A',1,233,'GEN',6),('TEL-103031-120','4','','A',1,234,'GEN',4),('TEL-103048-120','76','','A',1,235,'GEN',3),('TEL-103032-120','35','','A',1,236,'GEN',4),('TEL-103034-120','26','','A',1,238,'GEN',4),('TEL-103035-120','39','','A',1,239,'GEN',5),('TEL-103036-120','38','','A',1,240,'GEN',4),('TEL-100049-120','87','','A',1,241,'GEN',1),('TEL-103037-120','87','','A',1,242,'GEN',2),('TEL-100007-120','88','','A',1,243,'GEN',1),('TEL-103001-120','88','','A',1,244,'GEN',2),('TEL-103039-120','20','','A',1,245,'GEN',5),('TEL-103040-120','33','','A',1,246,'GEN',4),('TEL-103041-120','17','','A',1,247,'GEN',4),('TEL-100127-120','89','','A',1,248,'GEN',1),('TEL-103042-120','89','','A',1,249,'GEN',2),('TEL-103046-120','41','','A',1,250,'GEN',4),('TEL-1001033-120','90','','A',1,251,'GEN',1),('TEL-100059-120','90','','A',1,252,'GEN',2),('TEL-103073-120','90','','A',1,253,'GEN',3),('TEL-103014-120','85','','A',1,254,'GEN',4),('TEL-100098-120','91','','A',1,255,'GEN',2),('TEL-103043-120','91','','A',1,256,'GEN',1),('TEL-100214-120','92','','A',1,257,'GEN',1),('TEL-203133-120','92','','A',1,258,'GEN',2),('TEL-100044-120','93','','A',1,259,'GEN',1),('TEL-103045-120','93','','A',1,260,'GEN',2),('TEL-100210-120','94','','A',1,261,'GEN',1),('TEL-103049-120','94','','A',1,262,'GEN',2),('TEL-100236-120','95','','A',1,263,'GEN',1),('TEL-103008-120','95','','A',1,264,'GEN',2),('TEL-103056-120','85','','A',1,265,'GEN',1),('TEL-103057-120','56','','A',1,266,'GEN',1),('TEL-103067-120','9','','A',1,267,'GEN',1),('TEL-103061-120','10','','A',1,268,'GEN',1),('TEL-103062-120','95','','A',1,269,'GEN',3),('TEL-100250-120','96','','A',1,270,'GEN',1),('TEL-103063-120','96','','A',1,271,'GEN',2),('TEL-200136-120','97','','A',1,272,'GEN',1),('TEL-203024-120','97','','A',1,273,'GEN',2),('TEL-200107-120','98','','A',1,274,'GEN',1),('TEL-203026-120','98','','A',1,275,'GEN',2),('TEL-200109-120','99','','A',1,276,'GEN',1),('TEL-203053-120','99','','A',1,277,'GEN',2),('TEL-200159-120','100','','A',1,278,'GEN',1),('TEL-203070-120','100','','A',1,279,'GEN',2),('TEL-200137-120','101','','A',1,280,'GEN',1),('TEL-203021-120','101','','A',1,281,'GEN',2),('TEL-200155-120','102','','A',1,282,'GEN',1),('TEL-203127-120','102','','A',1,283,'GEN',2),('TEL-203011-120','68','','A',1,284,'GEN',1),('TEL-201115-120','103','','A',1,285,'GEN',1),('TEL-203132-120','103','','A',1,286,'GEN',2),('TEL-201118-120','104','','A',1,287,'GEN',1),('TEL-103121-120','104','','A',1,288,'GEN',2),('TEL-200888-120','105','','A',1,289,'GEN',1),('TEL-200580-120','105','','A',1,290,'GEN',2),('TEL-204012-120','106','','A',1,291,'GEN',1),('TEL-200039-120','106','','A',1,292,'GEN',2),('TEL-100319-120','19','','A',1,293,'GEN',1),('TEL-100342-120','25','','A',1,294,'GEN',1),('TEL-100464-120','39','','A',1,295,'GEN',1),('TEL-100465-120','39','','A',1,296,'GEN',2),('TEL-100788-120','107','','A',1,297,'GEN',1),('TEL-100020-120','107','','A',1,298,'GEN',2),('TEL-106035-120','107','','A',1,299,'GEN',3),('TEL-103033-120','107','','A',1,300,'GEN',4),('TEL-200050-120','108','','A',1,301,'GEN',1),('TEL-205024-120','108','','A',1,302,'GEN',2),('TEL-101072-120','13','','A',1,303,'GEN',4),('TEL-101994-120','9','','A',1,306,'GEN',5),('TEL-100002-120','29','','A',1,307,'GEN',1),('TEL-100690-120','74','','A',1,308,'GEN',1),('TEL-100020-120R','107','','A',1,309,'GEN',5),('TEL-103122-120','104','','A',1,310,'GEN',2),('TEL-100266-153','41','','A',1,311,'GEN',1);
/*!40000 ALTER TABLE `maesartiequlin` 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 2025-10-30  8:41:14
