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

DROP TABLE IF EXISTS `maesartiunimet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maesartiunimet` (
  `cod_unidad` char(5) NOT NULL DEFAULT '' COMMENT 'Unidad métrica',
  `id_unid` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Id.',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `siglas` char(10) NOT NULL DEFAULT '' COMMENT 'Siglas',
  `tipo_unidad` char(1) NOT NULL DEFAULT 'L' COMMENT 'Tipo magnitud',
  `factor_refe` decimal(20,8) NOT NULL DEFAULT '0.00000000' COMMENT 'Factor referencia',
  `observaciones` text NOT NULL COMMENT 'Observaciones',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `tipo_face` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'Tipo Factura-e',
  PRIMARY KEY (`id_tenant`,`id_unid`),
  UNIQUE KEY `key0` (`id_tenant`,`cod_unidad`),
  KEY `key1` (`id_tenant`,`tipo_unidad`,`cod_unidad`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `maesartiunimet` WRITE;
/*!40000 ALTER TABLE `maesartiunimet` DISABLE KEYS */;
INSERT INTO `maesartiunimet` (`cod_unidad`, `id_unid`, `nombre`, `siglas`, `tipo_unidad`, `factor_refe`, `observaciones`, `id_tenant`, `tipo_face`) VALUES ('dam3',138279159374754985,'Decámetros cúbicos','','V',0.00000000,'',1,1),('hg',141521876933175243,'Hectogramos','','P',0.00000000,'',1,1),('cg',184732811813684584,'Centigramos','','P',0.00000000,'',1,1),('m3',278945325733721794,'Metros cúbicos','','V',0.00000000,'',1,1),('mm2',279830734742159601,'Milímetros cuadrados','','S',0.00000000,'',1,1),('g',313057128532939427,'Gramos','','P',0.00000000,'',1,1),('km2',325185686318313272,'Kilómetros cuadrados','','S',0.00000000,'',1,1),('dam',372770561921957941,'Decámetros','','L',0.00000000,'',1,1),('dm',380074275844955050,'Decímetros','','L',0.00000000,'',1,1),('cm3',445188011864982587,'Centímetros cúbicos','','V',0.00000000,'',1,1),('hm3',447117150438134190,'Hectómetros cúbicos','','V',0.00000000,'',1,1),('dm3',473727856722918422,'Decímetros cúbicos (litros)','','V',0.00000000,'',1,1),('mm3',475972069195075178,'Milímetros cúbicos','','V',0.00000000,'',1,1),('dag',481625548714124844,'Decagramos','','P',0.00000000,'',1,1),('m2',496197459932060687,'Metros cuadrados','','S',0.00000000,'',1,1),('dam2',505669615343831177,'Decámetros cuadrados','','S',0.00000000,'',1,1),('mg',514632389589389175,'Miligramos','','P',0.00000000,'',1,1),('hm',555390839692976169,'Hectómetros','','L',0.00000000,'',1,1),('cm2',571630861174647938,'Centímetros cuadrados','','S',0.00000000,'',1,1),('m',571916598915309575,'Metros','','L',0.00000000,'',1,1),('km3',591275280226132713,'Kilómetros cúbicos','','V',0.00000000,'',1,1),('dm2',620042532651907076,'Decímetros cuadrados','','S',0.00000000,'',1,1),('cm',729206885351580751,'Centímetros','','L',0.00000000,'',1,1),('mm',776018037500294894,'Milímetros','','L',0.00000000,'',1,1),('dg',802196162982165920,'Decigramos','','P',0.00000000,'',1,1),('km',880183965578246231,'Kilómetros','','L',0.00000000,'',1,1),('kg',935866386841784801,'Kilogramos','','P',0.00000000,'',1,1),('hm2',991617010526104404,'Hectómetros cuadrados','','S',0.00000000,'',1,1);
/*!40000 ALTER TABLE `maesartiunimet` 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:15
