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

DROP TABLE IF EXISTS `promstrufasgfh`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `promstrufasgfh` (
  `cod_articulo_ela` char(30) NOT NULL DEFAULT '' COMMENT 'Artíc. elab.',
  `estruc_ela` int(11) NOT NULL DEFAULT '0' COMMENT 'Estructura',
  `fase` int(11) NOT NULL DEFAULT '0' COMMENT 'Fase',
  `cod_gfh` char(6) NOT NULL DEFAULT '' COMMENT 'Recurso',
  `precio_ext` decimal(18,9) NOT NULL DEFAULT '0.000000000' COMMENT 'Precio externo',
  `descuentos_ext` varchar(30) NOT NULL DEFAULT '' COMMENT 'Descuento externo',
  `tiempo_prepa` decimal(20,8) NOT NULL DEFAULT '0.00000000' COMMENT 'Tiempo preparación',
  `uni_tiempo_prepa` char(1) NOT NULL DEFAULT 'M' COMMENT 'Und tiempo prep.',
  `actividad_max` decimal(3,0) NOT NULL DEFAULT '133' COMMENT 'Actividad máxima',
  `ciclo` decimal(18,9) NOT NULL DEFAULT '1.000000000' COMMENT 'Unidades / Ciclo',
  `tiempo_ciclo` decimal(18,9) NOT NULL DEFAULT '0.000000000' COMMENT 'Tiempo / Ciclo',
  `uni_tiempo_ciclo` char(1) NOT NULL DEFAULT 'M' COMMENT 'Und tiempo ciclo',
  `tpc_redondeo_ciclo` decimal(4,2) NOT NULL DEFAULT '0.00' COMMENT '% redondeo 1 ciclo más',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `id_promstrufasgfh` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº recurso alternativo',
  `cod_operacion` char(5) NOT NULL DEFAULT '' COMMENT 'Operación',
  `sw_crono_revi` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Cronometraje revisado',
  `fecha_crono_revi` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha revisión crono',
  `id_promrecucro` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Tipo cronometraje',
  `fecha_ext_revi` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha revisión coste externo',
  UNIQUE KEY `key0` (`id_tenant`,`id_promstrufasgfh`),
  UNIQUE KEY `key1` (`id_tenant`,`cod_articulo_ela`,`estruc_ela`,`cod_operacion`,`cod_gfh`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `promstrufasgfh` WRITE;
/*!40000 ALTER TABLE `promstrufasgfh` DISABLE KEYS */;
INSERT INTO `promstrufasgfh` (`cod_articulo_ela`, `estruc_ela`, `fase`, `cod_gfh`, `precio_ext`, `descuentos_ext`, `tiempo_prepa`, `uni_tiempo_prepa`, `actividad_max`, `ciclo`, `tiempo_ciclo`, `uni_tiempo_ciclo`, `tpc_redondeo_ciclo`, `id_tenant`, `id_promstrufasgfh`, `cod_operacion`, `sw_crono_revi`, `fecha_crono_revi`, `id_promrecucro`, `fecha_ext_revi`) VALUES ('V-060hhh-lll-sss',1,0,'ENS',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,1,'ACC',0,'0000-00-00',0,'0000-00-00'),('V-060hhh-lll-sss',1,0,'ENV',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,2,'ENV',0,'0000-00-00',0,'0000-00-00'),('V-060hhh-lll-sss',1,0,'10',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,3,'COA',0,'0000-00-00',0,'0000-00-00'),('V-060hhh-lll-sss',1,0,'10',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,4,'COH',0,'0000-00-00',0,'0000-00-00'),('V-060hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,5,'MAC',0,'0000-00-00',0,'0000-00-00'),('V-060hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,6,'BAM',0,'0000-00-00',0,'0000-00-00'),('V-060hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,7,'MED',0,'0000-00-00',0,'0000-00-00'),('V-060hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,8,'UNI',0,'0000-00-00',0,'0000-00-00'),('V-060hhh-lll-sss',1,0,'COR',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,9,'COR',0,'0000-00-00',0,'0000-00-00'),('METRAJE090',1,0,'COR',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,10,'COR',0,'0000-00-00',0,'0000-00-00'),('TOL-067hhh-lll-sss',1,0,'ENS',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,11,'ACC',0,'0000-00-00',0,'0000-00-00'),('TOL-067hhh-lll-sss',1,0,'ENV',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,12,'ENV',0,'0000-00-00',0,'0000-00-00'),('TOL-067hhh-lll-sss',1,0,'10',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,13,'COA',0,'0000-00-00',0,'0000-00-00'),('TOL-067hhh-lll-sss',1,0,'10',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,14,'COH',0,'0000-00-00',0,'0000-00-00'),('TOL-067hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,15,'MAC',0,'0000-00-00',0,'0000-00-00'),('TOL-067hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,16,'BAM',0,'0000-00-00',0,'0000-00-00'),('TOL-067hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,17,'MED',0,'0000-00-00',0,'0000-00-00'),('TOL-067hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,18,'UNI',0,'0000-00-00',0,'0000-00-00'),('TOL-067hhh-lll-sss',1,0,'COR',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,19,'COR',0,'0000-00-00',0,'0000-00-00'),('TOL-161hhh-lll-sss',1,0,'ENS',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,20,'ACC',0,'0000-00-00',0,'0000-00-00'),('TOL-161hhh-lll-sss',1,0,'ENV',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,21,'ENV',0,'0000-00-00',0,'0000-00-00'),('TOL-161hhh-lll-sss',1,0,'10',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,22,'COA',0,'0000-00-00',0,'0000-00-00'),('TOL-161hhh-lll-sss',1,0,'10',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,23,'COH',0,'0000-00-00',0,'0000-00-00'),('TOL-161hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,24,'MAC',0,'0000-00-00',0,'0000-00-00'),('TOL-161hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,25,'BAM',0,'0000-00-00',0,'0000-00-00'),('TOL-161hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,26,'MED',0,'0000-00-00',0,'0000-00-00'),('TOL-161hhh-lll-sss',1,0,'CON',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,27,'UNI',0,'0000-00-00',0,'0000-00-00'),('TOL-161hhh-lll-sss',1,0,'COR',0.000000000,'',0.00000000,'M',133,1.000000000,0.000000000,'M',0.00,1,28,'COR',0,'0000-00-00',0,'0000-00-00');
/*!40000 ALTER TABLE `promstrufasgfh` 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:57
