--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------


--
-- Table structure for table `promrecu`
--

CREATE TABLE `promrecu` (
  `cod_gfh` char(6) NOT NULL DEFAULT '' COMMENT 'Recurso',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `tipo` char(1) NOT NULL DEFAULT 'M' COMMENT 'Tipo',
  `fecha_alta` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha alta',
  `fecha_baja` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha baja',
  `password` varchar(250) NOT NULL DEFAULT '' COMMENT 'Clave de paso',
  `cod_seccion` char(5) NOT NULL DEFAULT '' COMMENT 'Sección',
  `hora_ini_1` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora inicio 1',
  `hora_ini_2` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora inicio 2',
  `hora_ini_3` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora inicio 3',
  `hora_fin_1` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora final 1',
  `hora_fin_2` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora final 2',
  `hora_fin_3` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora final 3',
  `cod_almacen_mat` char(3) NOT NULL DEFAULT '' COMMENT 'Almacén materia prima',
  `cod_cuenta_ext` char(12) NOT NULL DEFAULT '' COMMENT 'Proveedor servicio',
  `cod_articulo_ext` char(30) NOT NULL DEFAULT '' COMMENT 'Artículo servicio',
  `cod_almacen_ext` char(3) NOT NULL DEFAULT '' COMMENT 'Almacén proveedor',
  `minutos_prepa` decimal(20,8) NOT NULL DEFAULT '0.00000000' COMMENT 'Minutos preparación',
  `direccion` text NOT NULL COMMENT 'Dirección',
  `cod_postal` char(10) NOT NULL DEFAULT '' COMMENT 'Código Postal',
  `poblacion` text NOT NULL COMMENT 'Población',
  `provincia` text NOT NULL COMMENT 'Provincia',
  `cod_nacion` char(4) NOT NULL DEFAULT 'ES' COMMENT 'País',
  `telefono` char(80) NOT NULL DEFAULT '' COMMENT 'Teléfono',
  `email` char(80) NOT NULL DEFAULT '' COMMENT 'Email',
  `fax` char(80) NOT NULL DEFAULT '' COMMENT 'Fax',
  `web` char(80) NOT NULL DEFAULT '' COMMENT 'Página Web',
  `movil` char(80) NOT NULL DEFAULT '' COMMENT 'Móvil',
  `observaciones` text NOT NULL COMMENT 'Observaciones',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `nombre_ext` text NOT NULL COMMENT 'Descripción servicio',
  `id_recurso` varchar(250) NOT NULL DEFAULT '' COMMENT 'Id único recurso',
  `id_recurso_alt` varchar(250) NOT NULL DEFAULT '' COMMENT 'Id único alternativo',
  `sw_id_recurso_alt` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Permitir Id alternativo',
  `id_maestrab` int(11) NOT NULL DEFAULT '0' COMMENT 'Nº trabajador empresa',
  `id_promrecupri` int(11) NOT NULL DEFAULT '0' COMMENT 'Grupo de primas',
  `num_partes_simu` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Nº partes simultáneos máx',
  `num_maquina` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Número de máquina',
  `sw_bloq_fase_init` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Bloquear cambiar recurso en fase iniciada',
  UNIQUE KEY `key0` (`id_tenant`,`cod_gfh`),
  KEY `key1` (`id_tenant`,`id_recurso`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `promrecu` (`cod_gfh`, `nombre`, `tipo`, `fecha_alta`, `fecha_baja`, `password`, `cod_seccion`, `hora_ini_1`, `hora_ini_2`, `hora_ini_3`, `hora_fin_1`, `hora_fin_2`, `hora_fin_3`, `cod_almacen_mat`, `cod_cuenta_ext`, `cod_articulo_ext`, `cod_almacen_ext`, `minutos_prepa`, `direccion`, `cod_postal`, `poblacion`, `provincia`, `cod_nacion`, `telefono`, `email`, `fax`, `web`, `movil`, `observaciones`, `id_tenant`, `nombre_ext`, `id_recurso`, `id_recurso_alt`, `sw_id_recurso_alt`, `id_maestrab`, `id_promrecupri`, `num_partes_simu`, `num_maquina`, `sw_bloq_fase_init`) VALUES ('1','Miguel','O','0000-00-00','0000-00-00','298d01b7e452636cd4a1e25529657d60f8','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('10','MAQUINA DE CORTE','M','0000-00-00','0000-00-00','832d6492d92a87b39f','S','08:00:00','15:00:00','00:00:00','14:00:00','20:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('11','Carlos Llach','O','0000-00-00','0000-00-00','08405f4f863e81a73e','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('12','Montse','O','0000-00-00','0000-00-00','867ab6199e5bc7973d8ad907fec410f0d9','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('13','David Bravo','O','0000-00-00','0000-00-00','a1d1ddb1cfe62090df9bec15e29345c034','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('14','Isabel','O','0000-00-00','0000-00-00','464745b172471078dc','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('15','Xavi','O','0000-00-00','0000-00-00','b9e0c7d5bde9b46c09','','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('16','Gloria','O','2017-02-15','0000-00-00','','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('17','Juana','O','2017-02-15','0000-00-00','','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('18','Josefa','O','2019-03-01','0000-00-00','','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('19','Andrés','O','2017-07-06','0000-00-00','2576764169874a8aa2','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('2','Adam','O','0000-00-00','0000-00-00','45f30e8f79d1f5f25825cc993914373488','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('20','MAQUINA CONFECCION 1','I','0000-00-00','0000-00-00','','','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('21','Isa','O','2019-03-04','0000-00-00','','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('22','Lucas','O','2020-02-10','0000-00-00','21c9b8f1054808a547e7b6b4330ff2a48b','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('23','Isaac','O','2020-02-10','0000-00-00','66ddfdff34cca28cc36e1ac7','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('24','Adrià','O','2020-02-10','0000-00-00','01f0ef661a44bf7b7e9a5337','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('25','Ana','O','2020-07-09','0000-00-00','d005d004cd4f29f02d','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('26','Adrià Lona','O','2020-07-09','0000-00-00','942342cc337de3becf','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('27','Victor','O','2021-04-28','0000-00-00','2b61d0df68622a006e','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('28','Cristian Nave2','O','0000-00-00','0000-00-00','6225a4c2559a125a96560a612857d7abb2','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('29','ANGEL','O','0000-00-00','0000-00-00','8416921eb31c0f24a694181c9151c38746','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('3','Lluís','O','0000-00-00','0000-00-00','e1af11e511d5cd6205adca8ffe51f57f4d','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('30','PEPI','O','0000-00-00','0000-00-00','24ab2e124d3ff3d7f0','','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('31','Pedro','O','0000-00-00','0000-00-00','a7818d3409bbebb7310c04a2739f132f52','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('32','David Domínguez','O','2018-03-15','0000-00-00','17fbab46908174c265','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('33','Rosa P.','O','2022-04-11','0000-00-00','fa47a1786a842e00328c55b3d6f9320444','S','06:00:00','14:00:00','00:00:00','14:00:00','22:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('34','Rosa','O','2018-03-15','0000-00-00','','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('35','Adrià','O','2018-03-20','0000-00-00','8b0d86d48f4beccf8471e1238a2aa4cd18','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('36','Cristian Poveda','O','2023-03-20','0000-00-00','533a1f20cf003cc065901401db09dd43','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('37','Javier García','O','2023-04-03','0000-00-00','41f4a6b8d285245841235857f3c93f0b','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('38','Derek','O','2023-04-12','0000-00-00','bb0e35bf4d7631efd95a04db3c61','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('39','Daniel Fabra','O','2023-04-19','0000-00-00','0d9bbc1fec1f4fe7cbd3d89830e4','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('4','Laura','O','0000-00-00','0000-00-00','bc510b9b9dcfe22898','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('40','Mª Teresa','O','2021-03-19','0000-00-00','88264104b05bc60939','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('41','Pere','O','2023-04-26','0000-00-00','736a38cda66fae6848f440b5df4f','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('42','Rosario','O','2021-03-19','0000-00-00','fc6695d9adba6e4cc2','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('43','Jesus','O','2024-06-28','0000-00-00','b5135e869bd50fb928cbd969','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('44','Alejandra','O','2021-03-19','0000-00-00','d99572f687710388f5','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('45','David Vela','O','2024-06-12','0000-00-00','6651ccd30a712334f5425a88601f','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('46','Montserrat Herrera','O','2021-03-19','0000-00-00','c25f1bf975b06bc0e2','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('47','Fabricio','O','2024-06-28','0000-00-00','e02ce882084abd6151cf29b90c70','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('48','Montserrat del Hoyo','O','2021-03-19','0000-00-00','d9a6bb4bfd7a502625','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('49','Laura Roc','O','2023-04-12','0000-00-00','40ea6baf1d4ad2138e146add6b72','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('5','NATI','O','0000-00-00','0000-00-00','d31c5e0b1c0c273e0f','','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('51','Mayra','O','2023-05-03','0000-00-00','b48df1ec23ac9d6489','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('52','Rafi','O','2023-05-03','0000-00-00','a00fa79e8280a0f2fc','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('53','Rodrigo','O','2023-05-03','0000-00-00','91301307e07cf20183','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('54','Selvio','O','2025-04-22','0000-00-00','07d3893b54b4ce790a501aaa4bae','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('55','Ferran','O','2021-03-19','0000-00-00','80b1091abe824f06bd2a69d4ddbba9d050','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('56','Erdal','O','2025-03-05','0000-00-00','5437657f3d2451061983a0910bb4','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('57','Jorge','O','2025-03-05','0000-00-00','c39db6686b097d19902576deb1ce','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('58','Tania','O','2025-03-05','0000-00-00','2aab0ac1822125e3bf5e5833','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('59','Evelin','O','2025-04-22','0000-00-00','54561744830bbdaca0479c3a','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','AGUS',0,0,0,0,0,0),('6','Edu','O','0000-00-00','0000-00-00','1a72556891cbe3e9c5bf4f0f59a2cce43b','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('69','David Segura','O','0000-00-00','0000-00-00','6d7f5b76a791e89ee472596b0bf3f536d6','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('7','Fiti','O','2019-02-14','0000-00-00','ecb43cf5590b7992257f767b467c6b96cb','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('71','Maria José','O','2022-04-11','0000-00-00','972fc6101a51eb584344ff341834','S','06:00:00','14:00:00','00:00:00','14:00:00','23:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('72','Joaquin','O','2020-03-02','0000-00-00','ebc05cb0d1645861ef','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('8','Dani','O','0000-00-00','0000-00-00','8a1832e58f5a6962a5','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('9','NEME','O','0000-00-00','0000-00-00','9beae503c4509ed8ca','','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('90','Ruben Taller','O','2019-10-11','0000-00-00','6fa318e9aab66076d6','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('93','Rosa Mari','O','2024-04-30','0000-00-00','7a0cd5d721c1e78fcf81386d5c05','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','lona',0,0,0,0,0,0),('99','LUIS','O','0000-00-00','0000-00-00','c9ad6b2644caed6f19','S','00:00:00','08:00:00','16:00:00','08:00:00','16:00:00','24:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('CON','Confección','M','2015-01-21','0000-00-00','e9b83ec98cb9eef003','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('COR','Máquina Corte Lona','M','2015-01-22','0000-00-00','53246f6018a18d43e3','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('ENS','ENSAMBLAJE','M','2015-01-22','0000-00-00','900d424ce21e33ecb2','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0),('ENV','Envisado','M','2016-04-05','0000-00-00','24ceea613486763651','S','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','00:00:00','','','','',0.00000000,'','','','','ES','','','','','','',1,'','','',0,0,0,0,0,0);


