-- 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 `maesartiequ`
--

DROP TABLE IF EXISTS `maesartiequ`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maesartiequ` (
  `cod_equiva` char(6) NOT NULL DEFAULT '' COMMENT 'Equivalencia',
  `nombre` char(250) NOT NULL DEFAULT '' COMMENT 'Nombre',
  `siglas` char(5) NOT NULL DEFAULT '' COMMENT 'Siglas',
  `sw_bloqueo` char(1) NOT NULL DEFAULT 'N' COMMENT 'Bloqueo Equivalencia',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `tip_equiva` char(4) NOT NULL DEFAULT 'GEN' COMMENT 'Tipo equivalencia',
  UNIQUE KEY `key0` (`id_tenant`,`cod_equiva`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `maesartiequ` WRITE;
/*!40000 ALTER TABLE `maesartiequ` DISABLE KEYS */;
INSERT INTO `maesartiequ` (`cod_equiva`, `nombre`, `siglas`, `sw_bloqueo`, `id_tenant`, `tip_equiva`) VALUES ('1','R-117','','N',1,'GEN'),('10','Equivalencias de TEL-100088-120','','N',1,'GEN'),('100','Equivalencias de TEL-200159-120','','N',1,'GEN'),('101','Equivalencias de TEL-200137-120','','N',1,'GEN'),('102','Equivalencias de TEL-200155-120','','N',1,'GEN'),('103','Equivalencias de TEL-201115-120','','N',1,'GEN'),('104','Equivalencias de TEL-201118-120','','N',1,'GEN'),('105','Equivalencias de TEL-200888-120','','N',1,'GEN'),('106','Equivalencias de TEL-204012-120','','N',1,'GEN'),('107','Equivalencias de TEL-100788-120','','N',1,'GEN'),('108','Equivalencias de TEL-200050-120','','N',1,'GEN'),('109','Equivalencias de TEL-100206-120','','N',1,'GEN'),('11','Equivalencias de TEL-100089-120','','N',1,'GEN'),('12','Equivalencias de TEL-100115-120','','N',1,'GEN'),('13','Equivalencias de TEL-100151-120','','N',1,'GEN'),('14','Equivalencias de TEL-100177-120','','N',1,'GEN'),('15','Equivalencias de TEL-100181-120','','N',1,'GEN'),('16','Equivalencias de TEL-100182-120','','N',1,'GEN'),('17','Equivalencias de TEL-100197-120','','N',1,'GEN'),('18','Equivalencias de TEL-100211-120','','N',1,'GEN'),('19','Equivalencias de TEL-100219-120','','N',1,'GEN'),('2','Equivalencias de TEL-200006-120','','N',1,'GEN'),('20','Equivalencias de TEL-100233-120','','N',1,'GEN'),('21','Equivalencias de TEL-100237-120','','N',1,'GEN'),('22','Equivalencias de TEL-100238-120','','N',1,'GEN'),('23','Equivalencias de TEL-100239-120','','N',1,'GEN'),('24','Equivalencias de TEL-100240-120','','N',1,'GEN'),('25','Equivalencias de TEL-100241-120','','N',1,'GEN'),('26','Equivalencias de TEL-100243-120','','N',1,'GEN'),('27','Equivalencias de TEL-100245-120','','N',1,'GEN'),('28','Equivalencias de TEL-100246-120','','N',1,'GEN'),('29','Equivalencias de TEL-100247-120','','N',1,'GEN'),('3','Equivalencias de TEL-100034-120','','N',1,'GEN'),('30','Equivalencias de TEL-100248-120','','N',1,'GEN'),('31','Equivalencias de TEL-100249-120','','N',1,'GEN'),('32','Equivalencias de TEL-100253-120','','N',1,'GEN'),('33','Equivalencias de TEL-100254-120','','N',1,'GEN'),('34','Equivalencias de TEL-100255-120','','N',1,'GEN'),('35','Equivalencias de TEL-100256-120','','N',1,'GEN'),('36','Equivalencias de TEL-100257-120','','N',1,'GEN'),('37','Equivalencias de TEL-100258-120','','N',1,'GEN'),('38','Equivalencias de TEL-100261-120','','N',1,'GEN'),('39','Equivalencias de TEL-100263-120','','N',1,'GEN'),('4','Equivalencias de TEL-100041-120','','N',1,'GEN'),('40','Equivalencias de TEL-100265-120','','N',1,'GEN'),('41','Equivalencias de TEL-100266-120','','N',1,'GEN'),('42','Equivalencias de TEL-100788-120','','N',1,'GEN'),('43','Equivalencias de TEL-100987-120','','N',1,'GEN'),('44','Equivalencias de TEL-101001-120','','N',1,'GEN'),('45','Equivalencias de TEL-208450-120','','N',1,'GEN'),('46','Equivalencias de TEL-208455-120','','N',1,'GEN'),('47','Equivalencias de TEL-100235-120','','N',1,'GEN'),('48','Equivalencias de TEL-2001028-120','','N',1,'GEN'),('49','Equivalencias de TEL-2001029-120','','N',1,'GEN'),('5','Equivalencias de TEL-100042-120','','N',1,'GEN'),('50','Equivalencias de TEL-200103-120','','N',1,'GEN'),('51','Equivalencias de TEL-200114-120','','N',1,'GEN'),('52','Equivalencias de TEL-200118-120','','N',1,'GEN'),('53','Equivalencias de TEL-200127-120','','N',1,'GEN'),('54','Equivalencias de TEL-200128-120','','N',1,'GEN'),('55','Equivalencias de TEL-200131-120','','N',1,'GEN'),('56','Equivalencias de TEL-200385-120','','N',1,'GEN'),('57','Equivalencias de TEL-200386-120','','N',1,'GEN'),('58','Equivalencias de TEL-200387-120','','N',1,'GEN'),('59','Equivalencias de TEL-200391-120','','N',1,'GEN'),('6','Equivalencias de TEL-100046-120','','N',1,'GEN'),('60','Equivalencias de TEL-200891-120','','N',1,'GEN'),('61','Equivalencias de TEL-201114-120','','N',1,'GEN'),('62','Equivalencias de TEL-201116-120','','N',1,'GEN'),('63','Equivalencias de TEL-100017-120','','N',1,'GEN'),('64','Equivalencias de TEL-100083-120','','N',1,'GEN'),('65','Equivalencias de TEL-200016-120','','N',1,'GEN'),('66','Equivalencias de TEL-200031-120','','N',1,'GEN'),('67','Equivalencias de TEL-200035-120','','N',1,'GEN'),('68','Equivalencias de TEL-200079-120','','N',1,'GEN'),('69','Equivalencias de TEL-200088-120','','N',1,'GEN'),('7','Equivalencias de TEL-100047-120','','N',1,'GEN'),('70','Equivalencias de TEL-200038-120','','N',1,'GEN'),('71','Equivalencias de TEL-200081-120','','N',1,'GEN'),('72','Equivalencias de TEL-200047-120','','N',1,'GEN'),('73','Equivalencias de TEL-100260-120','','N',1,'GEN'),('74','Equivalencias de TEL-100297-120','','N',1,'GEN'),('75','Equivalencias de TEL-100174-120','','N',1,'GEN'),('76','Equivalencias de TEL-100242-120','','N',1,'GEN'),('77','Equivalencias de TEL-205031-120','','N',1,'GEN'),('78','Equivalencias de TEL-100029-120','','N',1,'GEN'),('79','Equivalencias de TEL-201117-120','','N',1,'GEN'),('8','Equivalencias de TEL-100061-120','','N',1,'GEN'),('80','Equivalencias de TEL-200020-250','','N',1,'GEN'),('81','Equivalencias de TEL-200021-250','','N',1,'GEN'),('82','Equivalencias de TEL-205028-120','','N',1,'GEN'),('83','Equivalencias de TEL-100226-120','','N',1,'GEN'),('84','Equivalencias de TEL-100062-120','','N',1,'GEN'),('85','Equivalencias de TEL-100234-120','','N',1,'GEN'),('86','Equivalencias de TEL-100901-120','','N',1,'GEN'),('87','Equivalencias de TEL-100049-120','','N',1,'GEN'),('88','Equivalencias de TEL-100007-120','','N',1,'GEN'),('89','Equivalencias de TEL-100127-120','','N',1,'GEN'),('9','Equivalencias de TEL-100085-120','','N',1,'GEN'),('90','Equivalencias de TEL-1001033-120','','N',1,'GEN'),('91','Equivalencias de TEL-100098-120','','N',1,'GEN'),('92','Equivalencias de TEL-100214-120','','N',1,'GEN'),('93','Equivalencias de TEL-100044-120','','N',1,'GEN'),('94','Equivalencias de TEL-100210-120','','N',1,'GEN'),('95','Equivalencias de TEL-100236-120','','N',1,'GEN'),('96','Equivalencias de TEL-100250-120','','N',1,'GEN'),('97','Equivalencias de TEL-200136-120','','N',1,'GEN'),('98','Equivalencias de TEL-200107-120','','N',1,'GEN'),('99','Equivalencias de TEL-200109-120','','N',1,'GEN');
/*!40000 ALTER TABLE `maesartiequ` 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
