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

DROP TABLE IF EXISTS `cialpackemb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cialpackemb` (
  `num_pkl` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº Packing List',
  `num_emb` int(11) NOT NULL DEFAULT '0' COMMENT 'Línea Embalaje',
  `cod_und_emb` char(3) NOT NULL DEFAULT '' COMMENT 'Unidad Embalaje',
  `cantidad_emb` decimal(18,9) NOT NULL DEFAULT '0.000000000' COMMENT 'Unidades por Embalaje',
  `alto` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT 'Alto',
  `cod_unidad_alto` char(5) NOT NULL DEFAULT 'cm' COMMENT 'Unidad alto',
  `largo` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT 'Largo',
  `cod_unidad_largo` char(5) NOT NULL DEFAULT 'cm' COMMENT 'Unidad largo',
  `ancho` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT 'Ancho',
  `cod_unidad_ancho` char(5) NOT NULL DEFAULT 'cm' COMMENT 'Unidad ancho',
  `peso_neto` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'Peso neto',
  `peso_bruto` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'Peso bruto',
  `unidad_min` decimal(18,9) NOT NULL DEFAULT '0.000000000' COMMENT 'Capacidad unids mín.',
  `unidad_max` decimal(18,9) NOT NULL DEFAULT '0.000000000' COMMENT 'Capacidad unids máx.',
  `peso_min` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'Capacidad peso mín.',
  `peso_max` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'Capacidad peso máx.',
  `cod_unidad_peso` char(5) NOT NULL DEFAULT 'g' COMMENT 'Unidad peso',
  `longitud_min` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT 'Capacidad longitud mín.',
  `longitud_max` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT 'Capacidad longitud máx.',
  `cod_unidad_long` char(5) NOT NULL DEFAULT 'cm' COMMENT 'Unidad longitud',
  `superficie_min` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT 'Capacidad superficie mín.',
  `superficie_max` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT 'Capacidad superficie máx.',
  `cod_unidad_supe` char(5) NOT NULL DEFAULT 'cm2' COMMENT 'Unidad superficie',
  `volumen_min` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'Capacidad volumen mín.',
  `volumen_max` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'Capacidad volumen máx.',
  `cod_unidad_volu` char(5) NOT NULL DEFAULT 'cm3' COMMENT 'Unidad volumen',
  `id_cialpackemb` int(11) NOT NULL DEFAULT '0' COMMENT 'Id Embalaje',
  `volumen` decimal(10,4) NOT NULL DEFAULT '0.0000' COMMENT 'Volumen (m3)',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `cialpackemb_barcode` char(30) NOT NULL DEFAULT '' COMMENT 'Código barras bulto',
  UNIQUE KEY `key0` (`id_tenant`,`id_cialpackemb`),
  UNIQUE KEY `key1` (`id_tenant`,`num_pkl`,`num_emb`),
  KEY `key2` (`id_tenant`,`cialpackemb_barcode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cialpackemb` WRITE;
/*!40000 ALTER TABLE `cialpackemb` DISABLE KEYS */;
INSERT INTO `cialpackemb` (`num_pkl`, `num_emb`, `cod_und_emb`, `cantidad_emb`, `alto`, `cod_unidad_alto`, `largo`, `cod_unidad_largo`, `ancho`, `cod_unidad_ancho`, `peso_neto`, `peso_bruto`, `unidad_min`, `unidad_max`, `peso_min`, `peso_max`, `cod_unidad_peso`, `longitud_min`, `longitud_max`, `cod_unidad_long`, `superficie_min`, `superficie_max`, `cod_unidad_supe`, `volumen_min`, `volumen_max`, `cod_unidad_volu`, `id_cialpackemb`, `volumen`, `id_tenant`, `cialpackemb_barcode`) VALUES (1,1,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',1,0.0000,1,''),(2,1,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',2,0.0000,1,''),(2,2,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',3,0.0000,1,''),(3,1,'1',48.000000000,90.00,'cm',200.00,'cm',90.00,'cm',380.0000,380.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',4,1.6200,1,''),(4,2,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',5,0.0000,1,''),(5,100,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',6,0.0000,1,''),(5,101,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',7,0.0000,1,''),(5,102,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',8,0.0000,1,''),(5,200,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',9,0.0000,1,''),(5,201,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',10,0.0000,1,''),(5,202,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',11,0.0000,1,''),(5,203,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',12,0.0000,1,''),(5,300,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',13,0.0000,1,''),(5,301,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',14,0.0000,1,''),(5,302,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',15,0.0000,1,''),(5,303,'',0.000000000,0.00,'',0.00,'',0.00,'',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'',0.00,0.00,'',0.00,0.00,'',0.0000,0.0000,'',16,0.0000,1,''),(6,1,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',17,0.0000,1,''),(7,1,'',0.000000000,60.00,'cm',5900.00,'cm',50.00,'cm',230.0000,230.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',18,17.7000,1,''),(8,1,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',19,0.0000,1,''),(9,1,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',20,0.0000,1,''),(9,2,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',21,0.0000,1,''),(10,1,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',22,0.0000,1,''),(11,1,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',23,0.0000,1,''),(11,2,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',24,0.0000,1,''),(12,1,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',25,0.0000,1,''),(12,2,'',0.000000000,0.00,'cm',0.00,'cm',0.00,'cm',0.0000,0.0000,0.000000000,0.000000000,0.0000,0.0000,'g',0.00,0.00,'cm',0.00,0.00,'cm2',0.0000,0.0000,'cm3',26,0.0000,1,'');
/*!40000 ALTER TABLE `cialpackemb` 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:40:59
