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

DROP TABLE IF EXISTS `quliappsfam`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quliappsfam` (
  `id_quliapps` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº destino',
  `cod_articulo_fam_ori` char(30) NOT NULL DEFAULT '' COMMENT 'Familia orígen',
  `id_quliappsfam` int(11) NOT NULL DEFAULT '0' COMMENT 'Línea',
  `id_maesarti` int(11) NOT NULL DEFAULT '0' COMMENT 'Familia',
  `sw_send_fam` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Enviar familia',
  `sw_rece_fam` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Recibir familia',
  `order_view` int(11) NOT NULL DEFAULT '0' COMMENT 'Orden vista',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  UNIQUE KEY `key0` (`id_tenant`,`id_quliapps`,`id_quliappsfam`),
  UNIQUE KEY `key1` (`id_tenant`,`id_maesarti`,`id_quliapps`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `quliappsfam` WRITE;
/*!40000 ALTER TABLE `quliappsfam` DISABLE KEYS */;
INSERT INTO `quliappsfam` (`id_quliapps`, `cod_articulo_fam_ori`, `id_quliappsfam`, `id_maesarti`, `sw_send_fam`, `sw_rece_fam`, `order_view`, `id_tenant`) VALUES (1,'',1,11,0,1,0,1),(1,'',2,270,0,1,0,1),(1,'',3,271,0,1,0,1),(1,'',4,272,0,1,0,1),(1,'',5,275,0,1,0,1),(1,'',6,276,0,1,0,1),(1,'',7,277,0,1,0,1),(1,'',8,279,0,1,0,1),(1,'',9,280,0,1,0,1),(1,'',10,282,0,1,0,1),(1,'',11,284,0,1,0,1),(1,'',12,166,1,1,0,1),(1,'',13,148,1,1,0,1),(1,'',14,193,1,1,0,1),(1,'',15,1,1,1,0,1),(1,'',16,2,1,1,0,1),(1,'',17,303,1,1,0,1),(1,'',18,249,1,1,0,1),(1,'',19,251,1,1,0,1),(1,'',20,252,1,1,0,1),(1,'',21,253,1,1,0,1),(1,'',22,254,1,1,0,1),(1,'',23,256,1,1,0,1),(1,'',24,257,1,1,0,1),(1,'',25,255,1,1,0,1),(1,'',26,258,1,1,0,1),(1,'',27,260,1,1,0,1),(1,'',28,261,1,1,0,1),(1,'',29,262,1,1,0,1),(1,'',30,264,1,1,0,1),(1,'',31,265,1,1,0,1),(1,'',32,266,1,1,0,1),(1,'',33,310,1,1,0,1),(1,'',34,3,1,1,0,1),(1,'',35,4,1,1,0,1),(1,'',36,8,1,1,0,1),(1,'',37,9,1,1,0,1),(1,'',38,7,1,1,0,1),(1,'',39,10,1,1,0,1),(1,'',40,304,1,1,0,1),(1,'',41,5,1,1,0,1),(1,'',42,305,1,1,0,1),(1,'',43,306,1,1,0,1),(1,'',44,35,1,1,0,1),(1,'',45,36,1,1,0,1),(1,'',46,14,1,1,0,1),(1,'',47,15,1,1,0,1),(1,'',48,18,1,1,0,1),(1,'',49,19,1,1,0,1),(1,'',50,267,1,1,0,1),(1,'',51,268,1,1,0,1),(1,'',52,269,1,1,0,1),(1,'',53,273,1,1,0,1),(1,'',54,274,1,1,0,1),(1,'',55,278,1,1,0,1),(1,'',56,285,1,1,0,1),(1,'',57,297,1,1,0,1),(1,'',58,298,1,1,0,1),(1,'',59,299,1,1,0,1),(1,'',60,300,1,1,0,1),(1,'',61,301,1,1,0,1),(1,'',62,37,1,1,0,1),(1,'',63,38,1,1,0,1),(1,'',64,39,1,1,0,1),(1,'',65,43,1,1,0,1),(1,'',66,44,1,1,0,1),(1,'',67,45,1,1,0,1),(1,'',68,46,1,1,0,1),(1,'',69,48,1,1,0,1),(1,'',70,49,1,1,0,1),(1,'',71,50,1,1,0,1),(1,'',72,51,1,1,0,1),(1,'',73,54,1,1,0,1),(1,'',74,55,1,1,0,1),(1,'',75,58,1,1,0,1),(1,'',76,59,1,1,0,1),(1,'',77,60,1,1,0,1),(1,'',78,248,1,1,0,1),(1,'',79,65,1,1,0,1),(1,'',80,66,1,1,0,1),(1,'',81,67,1,1,0,1),(1,'',82,68,1,1,0,1),(1,'',83,69,1,1,0,1),(1,'',84,70,1,1,0,1),(1,'',85,71,1,1,0,1),(1,'',86,72,1,1,0,1),(1,'',87,73,1,1,0,1),(1,'',88,74,1,1,0,1),(1,'',89,75,1,1,0,1),(1,'',90,76,1,1,0,1),(1,'',91,77,1,1,0,1),(1,'',92,78,1,1,0,1),(1,'',93,79,1,1,0,1),(1,'',94,93,1,1,0,1),(1,'',95,94,1,1,0,1),(1,'',96,95,1,1,0,1),(1,'',97,96,1,1,0,1),(1,'',98,105,1,1,0,1),(1,'',99,20,1,1,0,1),(1,'',100,21,1,1,0,1),(1,'',101,26,1,1,0,1),(1,'',102,109,1,1,0,1),(1,'',103,22,1,1,0,1),(1,'',104,110,1,1,0,1),(1,'',105,111,1,1,0,1),(1,'',106,286,1,1,0,1),(1,'',107,287,1,1,0,1),(1,'',108,288,1,1,0,1),(1,'',109,308,1,1,0,1),(1,'',110,112,1,1,0,1),(1,'',111,289,1,1,0,1),(1,'',112,290,1,1,0,1),(1,'',113,291,1,1,0,1),(1,'',114,292,1,1,0,1),(1,'',115,113,1,1,0,1),(1,'',116,293,1,1,0,1),(1,'',117,307,1,1,0,1),(1,'',118,294,1,1,0,1),(1,'',119,114,1,1,0,1),(1,'',120,295,1,1,0,1),(1,'',121,115,1,1,0,1),(1,'',122,296,1,1,0,1),(1,'',123,116,1,1,0,1),(1,'',124,117,1,1,0,1),(1,'',125,118,1,1,0,1),(1,'',126,302,1,1,0,1),(1,'',127,309,1,1,0,1),(1,'',128,119,1,1,0,1),(1,'',129,120,1,1,0,1),(1,'',130,121,1,1,0,1),(1,'',131,283,1,1,0,1),(1,'',132,281,1,1,0,1),(1,'',133,259,1,1,0,1),(1,'',134,27,1,1,0,1),(1,'',135,124,1,1,0,1),(1,'',136,125,1,1,0,1),(1,'',137,126,1,1,0,1),(1,'',138,127,1,1,0,1),(1,'',139,128,1,1,0,1),(1,'',140,129,1,1,0,1),(1,'',141,130,1,1,0,1),(1,'',142,131,1,1,0,1),(1,'',143,132,1,1,0,1),(1,'',144,133,1,1,0,1),(1,'',145,134,1,1,0,1),(1,'',146,135,1,1,0,1),(1,'',147,136,1,1,0,1),(1,'',148,137,1,1,0,1),(1,'',149,138,1,1,0,1),(1,'',150,139,1,1,0,1),(1,'',151,144,1,1,0,1),(1,'',152,145,1,1,0,1),(1,'',153,146,1,1,0,1),(1,'',154,147,1,1,0,1),(1,'',155,149,1,1,0,1),(1,'',156,150,1,1,0,1),(1,'',157,151,1,1,0,1),(1,'',158,152,1,1,0,1),(1,'',159,153,1,1,0,1),(1,'',160,154,1,1,0,1),(1,'',161,155,1,1,0,1),(1,'',162,156,1,1,0,1),(1,'',163,157,1,1,0,1),(1,'',164,158,1,1,0,1),(1,'',165,159,1,1,0,1),(1,'',166,161,1,1,0,1),(1,'',167,162,1,1,0,1),(1,'',168,163,1,1,0,1),(1,'',169,164,1,1,0,1),(1,'',170,165,1,1,0,1),(1,'',171,167,1,1,0,1),(1,'',172,168,1,1,0,1),(1,'',173,169,1,1,0,1),(1,'',174,170,1,1,0,1),(1,'',175,171,1,1,0,1),(1,'',176,172,1,1,0,1),(1,'',177,173,1,1,0,1),(1,'',178,174,1,1,0,1),(1,'',179,175,1,1,0,1),(1,'',180,176,1,1,0,1),(1,'',181,177,1,1,0,1),(1,'',182,178,1,1,0,1),(1,'',183,180,1,1,0,1),(1,'',184,181,1,1,0,1),(1,'',185,182,1,1,0,1),(1,'',186,183,1,1,0,1),(1,'',187,188,1,1,0,1),(1,'',188,190,1,1,0,1),(1,'',189,191,1,1,0,1),(1,'',190,192,1,1,0,1),(1,'',191,194,1,1,0,1),(1,'',192,195,1,1,0,1),(1,'',193,196,1,1,0,1),(1,'',194,197,1,1,0,1),(1,'',195,198,1,1,0,1),(1,'',196,199,1,1,0,1),(1,'',197,200,1,1,0,1),(1,'',198,201,1,1,0,1),(1,'',199,202,1,1,0,1),(1,'',200,205,1,1,0,1),(1,'',201,206,1,1,0,1),(1,'',202,208,1,1,0,1),(1,'',203,219,1,1,0,1),(1,'',204,221,1,1,0,1),(1,'',205,222,1,1,0,1),(1,'',206,223,1,1,0,1),(1,'',207,224,1,1,0,1),(1,'',208,225,1,1,0,1),(1,'',209,226,1,1,0,1),(1,'',210,227,1,1,0,1),(1,'',211,228,1,1,0,1),(1,'',212,230,1,1,0,1),(1,'',213,247,1,1,0,1),(1,'',214,231,1,1,0,1),(1,'',215,232,1,1,0,1),(1,'',216,233,1,1,0,1),(1,'',217,234,1,1,0,1),(1,'',218,235,1,1,0,1),(1,'',219,236,1,1,0,1),(1,'',220,237,1,1,0,1),(1,'',221,238,1,1,0,1),(1,'',222,311,1,1,0,1),(1,'',223,239,1,1,0,1),(1,'',224,240,1,1,0,1),(1,'',225,241,1,1,0,1),(1,'',226,242,1,1,0,1),(1,'',227,243,1,1,0,1),(1,'',228,244,1,1,0,1),(1,'',229,24,1,1,0,1),(1,'',230,245,1,1,0,1),(1,'',231,25,1,1,0,1),(1,'',232,246,1,1,0,1);
/*!40000 ALTER TABLE `quliappsfam` 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:42:02
