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

DROP TABLE IF EXISTS `maesartipatpla`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maesartipatpla` (
  `cod_pla_par` int(11) NOT NULL DEFAULT '0' COMMENT 'Plant. relación',
  `id_patx` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Id.',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `cod_parate_ori` char(5) NOT NULL DEFAULT '' COMMENT 'Parámetro orígen',
  `cod_parate_des` char(5) NOT NULL DEFAULT '' COMMENT 'Parámetro destino',
  `sw_modifica_des` char(1) NOT NULL DEFAULT 'S' COMMENT 'Destino modificable',
  `cod_pla_par_add` int(11) NOT NULL DEFAULT '0' COMMENT 'Plant. adicionar',
  `cod_parate_pre_1` char(5) NOT NULL DEFAULT '' COMMENT 'Parám. 1 precios',
  `cod_parate_pre_3` char(5) NOT NULL DEFAULT '' COMMENT 'Parám. 3 precios',
  `cod_parate_pre_2` char(5) NOT NULL DEFAULT '' COMMENT 'Parám. 2 precios',
  `valor_pre_3` char(30) NOT NULL DEFAULT '' COMMENT 'Valor param.3 precios',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  UNIQUE KEY `key0` (`id_tenant`,`cod_pla_par`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `maesartipatpla` WRITE;
/*!40000 ALTER TABLE `maesartipatpla` DISABLE KEYS */;
INSERT INTO `maesartipatpla` (`cod_pla_par`, `id_patx`, `nombre`, `cod_parate_ori`, `cod_parate_des`, `sw_modifica_des`, `cod_pla_par_add`, `cod_parate_pre_1`, `cod_parate_pre_3`, `cod_parate_pre_2`, `valor_pre_3`, `id_tenant`) VALUES (1,0,'Base común general','','','S',0,'L','TTT','SF','',1),(2,0,'TOLDO TELON BOX ','','','S',1,'L','TTT','SCO','ACRILICO',1),(3,0,'TOLDO TELON ','','','S',1,'L','TTT','SF','SCREEN-S96',1),(4,0,'TOLDO BPR SEMITENSION','','','S',1,'L','TTT','SF','',1),(5,0,'PUNTO RECTO BOX ( DESERT )','','','S',1,'L','TTT','SF','',1),(6,0,'TOLDO B.I. CITY','','','S',1,'L','TTT','SF','',1),(7,0,'TOLDO B.I. LOGIA','','','S',1,'L','TTT','SF','',1),(8,0,'TOLDO B.I. ART 250','','','S',1,'L','TTT','SF','',1),(9,0,'TOLDO B.I. GOYA','','','S',1,'L','TTT','SF','',1),(10,0,' COFRE ARES','','','S',1,'L','TTT','SF','',1),(11,0,'COFRE IRIS','','','S',1,'L','TTT','SF','',1),(12,0,'COFRE 135','','','S',1,'L','TTT','SF','',1),(13,0,'COFRE STORBOX S-300','','','S',1,'L','TTT','SF','',1),(14,0,'COFRE STORBOX S-250','','','S',1,'L','TTT','SF','',1),(16,0,'TOLDO MONOBLOC 600 SUPER','','','S',1,'L','TTT','SF','',1),(17,0,' VERTICAL SCREEN ZIP 100','','','S',1,'L','TTT','A','',1),(18,0,'VERTICAL CABLE MINI','','','S',1,'L','TTT','A','',1),(19,0,'Corredero Miniguia 40x40','','','S',1,'L','TTT','SCO','',1),(20,0,'TOLDO GUIAS KLEIN 80x40','','','S',1,'L','TTT','SF','',1),(21,0,' VERTICAL VARILLA XL','','','S',1,'L','TTT','A','',1),(22,0,' VERTICAL PARAVENTO','','','S',1,'L','TTT','A','',1),(23,0,'TOLDO VERTICAL KEEPER','','','S',1,'L','TTT','SF','',1),(24,0,' VERTICAL SCREEN ZIP','','','S',1,'L','TTT','SF','',1),(25,0,'TOLDO B.I. SMART','','','S',1,'L','TTT','SF','',1),(26,0,' VERANDA MITJAVILA','','','S',1,'L','TTT','SCO','',1),(27,0,' VERANDA EOS','','','S',1,'L','TTT','SCO','',1),(28,0,'VERANDA EOS COMPLET','','','S',1,'L','TTT','SCO','',1),(29,0,' CORREDERO ONDAS I.P. 80x40 ','','','S',1,'L','TTT','SCO','',1),(30,0,'CORREDERO ONDAS 1P. 80x40 ','','','S',1,'L','TTT','SCO','',1),(31,0,' CORREDERO ONDAS 2 PORT. 80x40','','','S',1,'L','TTT','SCO','',1),(32,0,'CORREDERO ONDAS 80x40 2PORT. + REFU.','','','S',1,'L','TTT','SCO','',1),(33,0,'CORREDERO ZEN Nº1 ENTRE PAREDES','','','S',1,'L','TTT','SCO','',1),(34,0,'CORREDERO ZEN nº10  2 PORTERIAS','','','S',1,'L','TTT','SCO','',1),(35,0,'CORREDERO ZEN Nº13  2 PORTERIAS +REFUERZO','','','S',1,'L','TTT','SCO','',1),(36,0,'CORREDERO ONDAS 1P. 80x40 REFU.','','','S',1,'L','TTT','SCO','',1),(37,0,'CORREDERO ZEN Nº9  1 POR.+REF. INCLINACION','','','S',1,'L','TTT','SCO','',1),(38,0,'CORREDERO ZEN Nº4  1 PORTERIA CAPITEL','','','S',1,'L','TTT','SCO','',1),(39,0,'CORREDERO ZEN Nº3 1 PORTERIA','','','S',1,'L','TTT','SCO','',1),(40,0,'TOLDO B.I. AROND-350 LLAZA','','','S',1,'L','TTT','SF','',1),(41,0,'TOLDO BPR SIN TENSION','','','S',1,'L','TTT','SF','',1),(42,0,'TOLDO BPRS TENSION','','','S',1,'L','TTT','SF','',1),(43,0,'T-107 TOLDO MONOBLOC CITY','','','S',1,'L','TTT','SF','',1),(44,0,'TOL-052 TOLDO SEMICOFRE CITY','','','S',1,'L','TTT','SF','',1),(45,0,'VERANDA GIOTTO PLUS','','','S',1,'L','TTT','SCO','',1),(46,0,'CORREDERO ZEN Nº 2 ENTRE PAREDES INCLINACION','','','S',1,'L','TTT','SCO','',1),(47,0,'CORREDERO ZEN Nº 5   1 PORT. CAPITEL','','','S',1,'L','TTT','SCO','',1),(48,0,'CORREDEO ZEN Nº6 1 PORT. INCLINACION','','','S',1,'L','TTT','SF','',1),(49,0,'CORREDERO ZEN Nº 7 1PORT. CAPITEL/INCLINACION','','','S',1,'L','TTT','SCO','',1),(50,0,'CORREDERO ZEN Nº8 1PORT+REF.PER. FIJO','','','S',1,'L','TTT','SCO','',1),(51,0,'CORREDERO ZEN Nº11 2PORT. SUPERIOR','','','S',1,'L','TTT','SCO','',1),(52,0,'CORREDERO ZEN Nº 12 2 PORT. INTERIOR','','','S',1,'L','TTT','SCO','',1),(54,0,'VERTICAL  CABLE BOX','','','S',1,'L','TTT','A','',1),(55,0,'VERTICAL VARILLA BOX','','','S',1,'L','TTT','SF','',1),(56,0,'Lona Confeccionada','','','S',1,'L','TTT','SCO','',1),(57,0,'CAMBIO DE LONA ACRILICO SOLDADO','','','S',1,'L','TTT','SCO','',1),(58,0,'CAMBIO DE LONA B.I.','','','S',1,'L','TTT','SF','',1),(59,0,'CAMBIO DE LONA B.P.R.','','','S',1,'L','TTT','SF','',1),(60,0,'CAMBIO DE LONA TELON','','','S',1,'L','TTT','SF','',1),(61,0,'BAMBALINA EN LONA ACRILICA','','','S',1,'L','TTT','SCO','',1),(62,0,'LONA CONFECCIONADA','','','S',1,'L','TTT','SCO','',1),(63,0,'CAMBIO LONA CORREDERO MARINO','','','S',1,'L','TTT','SCO','',1),(64,0,'CAMBIO DE LONA DE HIERRO','','','S',1,'L','TTT','SCO','',1),(65,0,'CAMBIO DE LONA PVC','','','S',1,'L','TTT','SCO','',1),(66,0,'CAMBIO TEJIDO SCREEN / SOLTIS 96','','','S',1,'L','TTT','SF','',1),(67,0,'CAMBIO TEJIDO SOLTIS 92','','','S',1,'L','TTT','SF','',1),(68,0,'VERTICAL CABLE XL','','','S',1,'L','TTT','A','',1),(69,0,'COFRE SPLENBOX 300','','','S',1,'L','TTT','SF','',1),(70,0,'COFRE STORBOX 400','','','S',1,'L','TTT','SF','',1),(71,0,'Corredero tensado Zen Rain 1P ( Modulo Simple)','','','S',1,'L','TTT','SCO','',1),(72,0,'COFRE MATICBOX 350','','','S',1,'L','TTT','SF','',1),(73,0,'VERTICAL SCREEN ZIP 130','','','S',1,'L','TTT','A','',1),(74,0,'VERTICAL PARAVENTO + PERFILES REFUERZO','','','S',1,'L','TTT','A','',1),(75,0,'COFRE YUKI','','','S',1,'L','TTT','SF','',1),(76,0,'COFRE KUMO','','','S',1,'L','TTT','SF','',1),(77,0,'CORTINA CORREDERA','','','S',1,'L','TTT','A','',1),(78,0,'Metrajes','','','S',1,'L','TTT','SCO','',1),(80,0,'CORTINA ENROLLABLE C43','','','S',0,'','','','',1),(82,0,'VERTICAL CABLE SUPERIOR','','','S',1,'L','TTT','SF','',1),(83,0,'VERTICAL CAIDA LIBRE','','','S',1,'L','TTT','SCO','',1),(84,0,'VERTICAL PARABOX','','','S',1,'L','TTT','A','',1),(85,0,'SFERIC 90 X 96 I.P.','','','S',1,'L','TTT','SF','',1),(86,0,'CORREDERO SFERIC 90 X 96 1 PORT.','','','S',1,'L','TTT','SCO','',1),(87,0,'CORREDERO SFERIC 90 X 96 1 PORTE.+ REF.PER.','','','S',1,'L','TTT','SCO','',1),(88,0,'CORREDERO SFERIC 90 X 96 2 PORT.','','','S',1,'L','TTT','SCO','',1),(89,0,'CORREDERO SFERIC 90 X 96 2 PORT. + REF.PER.','','','S',1,'L','TTT','SCO','',1),(90,0,'CORREDERO 125 X 125 I.P.','','','S',1,'L','TTT','SCO','',1),(91,0,'CORREDERO 125 X 125 1 PORT.','','','S',1,'L','TTT','SCO','',1),(92,0,'CORREDERO 125 X 125 1 PORT. + REF. PER.','','','S',1,'L','TTT','SCO','',1),(93,0,'CORREDERO 125 X 125 2 PORT.','','','S',1,'L','TTT','SCO','',1),(94,0,'CORREDERO 125 X 125 2 PORT.+ REF. PER.','','','S',1,'L','TTT','SCO','',1),(95,0,'COFRE KYMA TIPO 1','','','S',1,'L','TTT','SF','',1),(96,0,'VERTIKO','','','S',1,'L','TTT','SF','',1),(97,0,'ECLIPSE 130','','','S',1,'','','','',1),(98,0,'COFRE SPLENBOX 400','','','S',1,'L','TTT','SF','',1),(99,0,'Cofre ARKO','','','S',1,'L','TTT','SF','',1),(100,0,'COFRE SHAN','','','S',1,'L','TTT','SF','',1),(101,0,'COFRE KYMA','','','S',1,'L','TTT','SF','',1),(102,0,'MONOBLOC STEIN','','','S',1,'','','','',1),(103,0,'verftical screen zip 100 guia estrecha','','','S',1,'','','','',1),(104,0,'Corredero Tensado Zen Rain Modulo Doble','','','S',1,'','','SCO','',1),(105,0,'VERTICAL CAIDA LIBRE','','','S',1,'L','TTT','SF','',1),(106,0,'MONOBLOC KLIP','','','S',1,'','','','',1),(107,0,'Corredero Zen Rain I.P. ( Modulo Simple)','','','S',1,'L','TTT','SCO','',1),(108,0,'GIOTTO','','','S',1,'L','TTT','SCO','',1),(109,0,'GIOTTO DOBLE','','','S',1,'L','TTT','SF','',1),(110,0,'VERANDA ECLIPSE 130 PLUS','','','S',1,'','','','',1),(111,0,'FENG','','','S',1,'L','TTT','SF','',1),(112,0,'VERTICAL IGLOO','','','S',1,'L','','A','',1),(113,0,'Clona Corredero Marino Simple','','','S',1,'','','','',1),(114,0,'MONOBLOC ARKO','','','S',1,'L','TTT','SF','',1),(115,0,'STILLA','','','S',1,'','','','',1),(116,0,'TOLDO B.I. CITY CON VERTIKO','','','S',1,'','','','',1),(117,0,'Cofre Aland','','','S',1,'L','TTT','SF','',1),(118,0,'Corredero Clima 120x120 IP','','','S',1,'L','TTT','SCO','',1),(119,0,'Corredero Clima 120x120 1 Porteria','','','S',1,'L','TTT','SCO','',1),(120,0,'Corredero 120x120 1P+RP','','','S',1,'L','TTT','SCO','',1),(121,0,'Corredero Clima 120x120 2 Porterias','','','S',1,'L','','SCO','',1),(122,0,'Corredero Clima 120x120 2 P + RP','','','S',1,'L','','SCO','',1),(123,0,'VERANDA HERA','','','S',1,'L','TTT','SCO','',1),(124,0,'TOLDO B.I. CITY CON LEDS','','','S',1,'','','','',1),(125,0,'Corredro Ondas 80x40 IP Motorizado','','','S',1,'','','','',1),(126,0,'CORREDERO ONDAS 1 Port. 80X40 MOTORIZADO','','','S',1,'','','','',1),(127,0,'CORREDERO DE ONDAS 1 Port.+RP MOTORIZADO','','','S',1,'','','','',1),(128,0,'CORREDERO ONDAS 2P 80X40 MOTORIZADO','','','S',1,'','','','',1),(129,0,'CORREDERO DE ONDAS (2 Port.+RP) 80X40 MOTORIZADO','','','S',1,'','','','',1),(130,0,'COFRE ARES CON LED EN BRAZO CONCEPT','','','S',1,'','','','',1),(131,0,'COFRE ALAND CON LEDS EN BRAZO CONCEPT','','','S',1,'','','','',1),(132,0,'COFRE ALAND CON LEDS EN BRAZOS Y CAJON','','','S',1,'','','','',1),(133,0,'COFRE ARKO CON LEDS EN CAJON','','','S',1,'','','','',1),(134,0,'Vertical Nimbus Varilla','','','S',1,'L','TTT','A','',1),(135,0,'Vertical Nimbus Box Varilla','','','S',1,'L','TTT','A','',1),(136,0,'Vertical Nimbus Cable','','','S',1,'L','TTT','A','',1),(137,0,'Vertical Nimbus Box Cable','','','S',1,'L','TTT','A','',1),(138,0,'Vertical Nexus 80 Guia','','','S',1,'L','TTT','A','',1),(139,0,'Vertical Nexus 80 Guia - Cable','','','S',1,'L','TTT','A','',1),(140,0,'Vertical Nexus 80 Guia Zip Estrecha','','','S',1,'L','TTT','A','',1),(141,0,'Vertical Nexus 100 guia','','','S',1,'L','TTT','A','',1),(142,0,'Vertical Nexus 100 Guia - Cable','','','S',1,'L','TTT','A','',1),(143,0,'Vertical Nexus 100 Guia  Zip Ancha','','','S',1,'L','TTT','A','',1),(144,0,'Vertical Nexus 130 Guia','','','S',1,'L','TTT','A','',1),(145,0,'Vertical Nexus 130 Guia - Cable','','','S',1,'L','TTT','A','',1),(146,0,'Vertical Nexus 130 Guia Zip Ancha','','','S',1,'L','TTT','A','',1),(147,0,'Bambalina Led','','','S',1,'L','TTT','SCO','',1),(148,0,'Pergola Solplay','','','S',1,'','','','',1),(149,0,'Varanda Sirio','','','S',1,'','','','',1);
/*!40000 ALTER TABLE `maesartipatpla` 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
