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

DROP TABLE IF EXISTS `maesartipat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maesartipat` (
  `cod_parate` char(5) NOT NULL DEFAULT '' COMMENT 'Parámetro técnico',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `nombre_inter` text NOT NULL COMMENT 'Nombre internacional',
  `unidades` char(15) NOT NULL DEFAULT '' COMMENT 'Unidades',
  `cod_adicional` char(30) NOT NULL DEFAULT '' COMMENT 'Código alternativo',
  `orden` int(11) NOT NULL DEFAULT '0' COMMENT 'Orden en entradas',
  `cod_meme` char(10) NOT NULL DEFAULT '' COMMENT 'Método medición',
  `cod_patf` char(5) NOT NULL DEFAULT '' COMMENT 'Familia par.téc.',
  `tipo` char(1) NOT NULL DEFAULT 'A' COMMENT 'Tipo',
  `decimales` decimal(1,0) NOT NULL DEFAULT '0' COMMENT 'Decimales',
  `sw_componente` char(1) NOT NULL DEFAULT 'N' COMMENT 'Para componentes',
  `sw_fabricable` char(1) NOT NULL DEFAULT 'S' COMMENT 'Para fabricables',
  `sw_valida` char(1) NOT NULL DEFAULT 'S' COMMENT 'Valida valores',
  `sw_blanco` char(1) NOT NULL DEFAULT 'S' COMMENT 'Admite valores vacíos',
  `sw_ficha_tec_fab` char(1) NOT NULL DEFAULT 'S' COMMENT 'Uso ficha técnica fab.',
  `sw_ficha_tec_cal` char(1) NOT NULL DEFAULT 'S' COMMENT 'Uso ficha técnica cal.',
  `crpees_orden` int(11) NOT NULL DEFAULT '0' COMMENT 'Orden en pedidos',
  `crpees_char` char(1) NOT NULL DEFAULT '' COMMENT 'Carácter sub-artíc. en pedidos',
  `sw_of` char(1) NOT NULL DEFAULT 'N' COMMENT 'Uso O.F.',
  `sw_ver_en_pedido` char(1) NOT NULL DEFAULT 'S' COMMENT 'Ver en Pedidos',
  `observaciones` text NOT NULL COMMENT 'Observaciones',
  `exp_sw_usable` text NOT NULL COMMENT 'Expresión de si es usable',
  `exp_valor` text NOT NULL COMMENT 'Expresión valor final',
  `sw_tarifar_vta` char(1) NOT NULL DEFAULT 'N' COMMENT 'Para tarifar ventas',
  `sw_pedi_edit` char(1) NOT NULL DEFAULT 'S' COMMENT 'Editable en pedido',
  `subcadena` char(10) NOT NULL DEFAULT '' COMMENT 'Comodín para producto final',
  `filter_products_1` text NOT NULL COMMENT 'Filtro códigos productos',
  `filter_products_2` text NOT NULL COMMENT 'Filtro códigos familias',
  `lu_cols_add` char(250) NOT NULL DEFAULT 'stock_dis,stock_nod' COMMENT 'Campos añadir look-up productos',
  `sw_ver_en_imp_of` char(1) NOT NULL DEFAULT 'N' COMMENT 'Ver en impreso OF',
  `id_maesartipat` int(11) NOT NULL DEFAULT '0' COMMENT 'Id parámetro técnico',
  `sw_color` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Parámetro de colores',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `tipo_param` char(1) NOT NULL DEFAULT '1' COMMENT 'Tipo parámetro',
  `control_tipo` char(1) NOT NULL DEFAULT '1' COMMENT 'Tipo de control (B2B)',
  `control_filtros` text NOT NULL COMMENT 'Campos filtro',
  `campos_filtros` text NOT NULL COMMENT 'Nombre Campos filtro (B2B)',
  `sw_activo_b2b` char(1) NOT NULL DEFAULT 'S' COMMENT 'Activo en Avant',
  `maesartipat_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Tipo parámetro',
  UNIQUE KEY `key0` (`id_tenant`,`id_maesartipat`),
  UNIQUE KEY `key1` (`id_tenant`,`cod_parate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `maesartipat` WRITE;
/*!40000 ALTER TABLE `maesartipat` DISABLE KEYS */;
INSERT INTO `maesartipat` (`cod_parate`, `nombre`, `nombre_inter`, `unidades`, `cod_adicional`, `orden`, `cod_meme`, `cod_patf`, `tipo`, `decimales`, `sw_componente`, `sw_fabricable`, `sw_valida`, `sw_blanco`, `sw_ficha_tec_fab`, `sw_ficha_tec_cal`, `crpees_orden`, `crpees_char`, `sw_of`, `sw_ver_en_pedido`, `observaciones`, `exp_sw_usable`, `exp_valor`, `sw_tarifar_vta`, `sw_pedi_edit`, `subcadena`, `filter_products_1`, `filter_products_2`, `lu_cols_add`, `sw_ver_en_imp_of`, `id_maesartipat`, `sw_color`, `id_tenant`, `tipo_param`, `control_tipo`, `control_filtros`, `campos_filtros`, `sw_activo_b2b`, `maesartipat_type`) VALUES ('A','Altura','','cm','',0,'','','I',0,'N','S','S','S','S','S',165,'','S','S','','','','N','S','','','','stock_dis,stock_nod','S',1,0,1,'1','1','','','S',1),('AB','Ancho de Bobina','','cm','',0,'','','N',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',2,0,1,'1','1','','','S',1),('AP','Altura Pilar','','','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','S','','','','N','N','','','','stock_dis,stock_nod','N',3,0,1,'1','1','','','S',1),('CH','Color Herraje','','','',0,'','','A',0,'N','S','S','S','S','S',270,'','S','S','','','','N','S','hhh','','','stock_dis,stock_nod','N',4,0,1,'1','2','','','S',1),('CHI','Color Hilo              ','','','',0,'','','A',0,'N','S','S','S','S','S',560,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',5,0,1,'1','1','','','S',1),('CM','Color Manivela/Tapas','','','',0,'','','A',0,'N','S','S','S','S','S',925,'','S','N','','','','N','N','','','','stock_dis,stock_nod','N',7,0,1,'1','1','','','S',1),('CO','Corona','','','',0,'','','A',0,'N','S','S','S','S','S',991,'','S','N','','','','N','N','','','','stock_dis,stock_nod','N',8,0,1,'1','1','','','S',1),('CR','Color Ribete         ','','','',0,'','','A',0,'N','S','S','S','S','S',550,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',9,0,1,'1','1','','','S',1),('DT','Diámetro tubo      ','','mm','',0,'','','A',0,'N','S','S','S','S','S',980,'','S','N','','','','N','N','','','','stock_dis,stock_nod','N',10,0,1,'1','1','','','S',1),('FA','Bambalina             ','','','',0,'','','A',0,'N','S','S','S','S','S',510,'','S','S','','','','N','S','','','','stock_dis,stock_nod','N',11,0,1,'1','2','','','S',1),('GA','Número de Gayas','','','',0,'','','A',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',12,0,1,'1','1','','','S',1),('KC','Kit cruzado','','','',0,'','','A',0,'N','S','S','S','S','S',170,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',13,0,1,'1','1','','','S',1),('L','Línea','','cm','',0,'','','I',0,'N','S','S','S','S','S',110,'','S','S','','','','S','S','','','','stock_dis,stock_nod','S',14,0,1,'1','1','','','S',1),('LBC','Línea Barra Corte','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',15,0,1,'1','1','','','S',1),('LBP','Linea Barra Palillo','','','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',16,0,1,'1','1','','','S',1),('LCC','Línea Carga Corte','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',17,0,1,'1','1','','','S',1),('LL','Línea de Lona     ','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','S','','','','N','N','','','','stock_dis,stock_nod','N',18,0,1,'1','1','','','S',1),('LPC','Línea Perfil Corte','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',19,0,1,'1','1','','','S',1),('LPC2','L. Perf. Corte Carga','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',20,0,1,'1','1','','','S',1),('LPC3','L. Perf. Corte Cofre','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',21,0,1,'1','1','','','S',1),('LPC4','L.P. Corte Cofre Tapa','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',22,0,1,'1','1','','','S',1),('LPC5','L. Perfil Corte Patin PVC','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',23,0,1,'1','1','','','S',1),('LPS','Línea Perfil Stock','','cm','',0,'','','N',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',24,0,1,'1','1','','','S',1),('LT','Línea tarifa','','cm','',0,'','','N',0,'N','S','S','S','S','S',920,'','N','N','','','','N','N','lll','','','stock_dis,stock_nod','N',25,0,1,'1','1','','','S',1),('LTS','Línea Barra Stock','','cm','',0,'','','N',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',26,0,1,'1','1','','','S',1),('MA','Manivela','','cm','',0,'','','A',0,'N','S','S','S','S','S',320,'','S','S','','','','N','S','','','','stock_dis,stock_nod','N',27,0,1,'1','1','','','S',1),('ML','Mano D/I','','','',0,'','','A',0,'N','S','S','S','S','S',340,'','S','S','','','','N','S','','','','stock_dis,stock_nod','S',28,0,1,'1','1','','','S',1),('MM','Manual/Motorización','','','',0,'','','A',0,'N','S','S','S','S','S',310,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',29,0,1,'1','1','','','S',1),('MO','Motores','','','',0,'','','A',0,'N','S','S','S','S','S',330,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',30,0,1,'1','1','','','S',1),('RU','Rueda','','','',0,'','','A',0,'N','S','S','S','S','S',990,'','S','N','','','','N','N','','','','stock_dis,stock_nod','N',31,0,1,'1','1','','','S',1),('SC','Corte Lona','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',32,0,1,'1','1','','','S',1),('SCO','Salida co.','','cm','',0,'','','I',0,'N','S','S','S','S','S',160,'','S','S','','','','N','S','sss','','','stock_dis,stock_nod','S',33,0,1,'1','1','','','S',1),('SF','Salida','','cm','',0,'','','N',0,'N','S','S','S','S','S',150,'','S','S','','','','N','S','sss','','','stock_dis,stock_nod','S',34,0,1,'1','1','','','S',1),('SF2','Salida Perfil PVC','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',35,0,1,'1','1','','','S',1),('SF3','Salida Perfil Guias','','cm','',0,'','','A',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',36,0,1,'1','1','','','S',1),('SF4','Salida Cables','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',37,0,1,'1','1','','','S',1),('SL','Salida de Lona    ','','cm','',0,'','','I',0,'N','S','S','S','S','S',0,'','N','S','','','','N','N','','','','stock_dis,stock_nod','N',38,0,1,'1','1','','','S',1),('SO','Soporte Univ.','','','',0,'','','A',0,'N','S','S','S','S','S',999,'','S','N','','','','N','N','','','','stock_dis,stock_nod','N',39,0,1,'1','1','','','S',1),('TCS','Tejido                  ','','','',0,'','','A',0,'N','S','S','S','S','S',420,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',40,0,1,'1','1','','','S',1),('TP','Tipo Perfil','','','',0,'','','A',0,'N','S','S','S','S','S',210,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',41,0,1,'1','1','','','S',1),('TR','Acabado faldón              ','','','',0,'','','A',0,'N','S','S','S','S','S',540,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',42,0,1,'1','1','','','S',1),('TT','Tipo tejido','','','',0,'','','A',0,'N','S','P','S','S','S',410,'','S','S','','','','N','S','','','L-100..L-701','stock_dis,stock_nod','N',43,0,1,'1','3','FAB,TTT,DSG','$acceso$ : $nombre$','S',1),('TTT','Tipo de Tejido','','','',0,'','','A',0,'N','S','S','S','S','S',412,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',44,0,1,'1','1','','','S',1),('VAINA','VAINA','','','',0,'','','A',0,'N','S','S','S','S','S',0,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',45,0,1,'1','1','','','S',1),('X01','Mandos','','','',0,'','','A',0,'N','S','S','S','S','S',350,'','S','N','','','','S','S','','','','stock_dis,stock_nod','N',46,0,1,'1','2','','','S',1),('X02','Automatismos','','','',0,'','','A',0,'N','S','S','S','S','S',360,'','S','N','','','','S','S','','','','stock_dis,stock_nod','N',47,0,1,'1','2','','','S',1),('AF','Altura Bambalina','','cm','',0,'','','A',0,'N','S','S','S','S','S',515,'','S','S','','','','N','S','','','','stock_dis,stock_nod','S',48,0,1,'1','1','','','S',1),('CT','Caída Tejido','','','',0,'','','A',0,'N','S','S','S','S','S',170,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',49,0,1,'1','1','','','S',1),('INS','Instalación','','','',0,'','','A',0,'N','S','S','S','S','S',100,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',50,0,1,'1','1','','','S',1),('ADI','ADICIONAL','','','',0,'','','A',0,'N','S','S','S','S','S',610,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',52,0,1,'1','1','','','S',1),('TAP','Tapas','','','',0,'','','A',0,'N','S','S','S','S','S',640,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',53,0,1,'1','1','','','S',1),('CA','Cajón','','','',0,'','','A',0,'N','S','S','S','S','S',640,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',54,0,1,'1','1','','','S',1),('CCA','Corte Cadena','','','',0,'','','I',0,'N','S','S','S','S','S',330,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',55,0,1,'1','1','','','S',1),('TC','Tipo Cadena','','','',0,'','','A',0,'N','S','S','S','S','S',335,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',56,0,1,'1','1','','','S',1),('CP','Contrapeso','','','',0,'','','A',0,'N','S','S','S','S','S',680,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',57,0,1,'1','1','','','S',1),('CAM','Cadena/Manivela','','','',0,'','','A',0,'N','S','S','S','S','S',325,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',58,0,1,'1','1','','','S',1),('NODO','Nodo Padre','','','',0,'','','A',0,'N','S','S','S','S','S',0,'','N','N','','','','N','S','','','','stock_dis,stock_nod','N',60,0,1,'3','1','','','S',1),('INSC','Instalacion Cofre','','','',0,'','','A',0,'N','S','S','S','S','S',220,'','S','N','','','','N','S','','','','stock_dis,stock_nod','S',61,0,1,'1','1','','','S',1),('CHS','Colores Shadelab','','','',0,'','','A',0,'N','S','S','S','S','S',220,'','S','S','','','','N','S','chs','','','stock_dis,stock_nod','N',62,0,1,'1','1','','','S',1),('INSD','Anclaje ( Desert )','','','',0,'','','A',0,'N','S','S','S','S','S',220,'','S','N','','','','N','S','','','','stock_dis,stock_nod','S',63,0,1,'1','1','','','S',1),('MAMO','Manual/Motorización','','','',0,'','','A',0,'N','S','S','S','S','S',310,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',64,0,1,'1','2','','','S',1),('SEG','Clip Hipro','','','',0,'','','A',0,'N','S','S','S','S','S',315,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',65,0,1,'1','1','','','S',1),('MOMO','Exclusivamente Motorizado','','','',0,'','','A',0,'N','S','S','S','S','S',310,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',66,0,1,'1','2','','','S',1),('FAB','Fabricante','','','',0,'','','A',0,'N','N','S','S','S','N',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',67,0,1,'1','1','','','S',1),('DSG','Diseño del tejido','','','',0,'','','A',0,'N','N','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',68,0,1,'1','1','','','S',1),('CHL','Colores Llaza','','','',0,'','','A',0,'N','S','S','S','S','S',220,'','S','S','','','','N','S','chl','','','stock_dis,stock_nod','N',69,0,1,'1','2','','','S',1),('RAL','Color RAL','','','',0,'','','A',0,'N','N','S','S','N','N',0,'','N','S','','','','N','N','','','','stock_dis,stock_nod','N',70,0,1,'2','1','','','S',1),('CQ','Color Máquina','','','',0,'','','A',0,'N','S','S','S','S','S',0,'','N','N','','','','N','N','','','','stock_dis,stock_nod','N',71,0,1,'1','1','','','N',1),('LEDS','Iluminacion Led','','','',0,'','','A',0,'N','S','S','S','S','S',994,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',72,0,1,'1','2','','','S',1),('ALED','Automatismos Led','','','',0,'','','A',0,'N','S','S','S','S','S',995,'','S','N','','','','N','N','','','','stock_dis,stock_nod','N',73,0,1,'1','1','','','S',1),('MOLE','Tipo Motor','','','',0,'','','A',0,'N','S','S','S','S','S',993,'','S','N','','','','N','S','','','','stock_dis,stock_nod','N',74,0,1,'1','2','','','S',1),('CHB','Colores Bat','','','',0,'','','A',0,'N','S','S','S','S','S',270,'','S','S','','','','N','S','chb','','','stock_dis,stock_nod','N',75,0,1,'1','2','','','S',1);
/*!40000 ALTER TABLE `maesartipat` 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
