-- Table structure for table `pcalendario`
--

CREATE TABLE `pcalendario` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `tipo` int(11) DEFAULT NULL,
  `entrada` varchar(50) DEFAULT NULL,
  `salida` varchar(50) DEFAULT NULL,
  `etiqueta` varchar(1000) DEFAULT NULL,
  `descripcion` varchar(2000) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `idsucursal` int(11) DEFAULT NULL,
  `iddepartamento` int(11) DEFAULT NULL,
  `idpuesto` int(11) DEFAULT NULL,
  `idempleado` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pcalendario`
--


--
-- Table structure for table `pcontrato`
--

CREATE TABLE `pcontrato` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nip` int(11) DEFAULT NULL,
  `iddireccion` int(11) DEFAULT NULL,
  `iddepartamento` int(11) DEFAULT NULL,
  `idpuesto` int(11) DEFAULT 1,
  `idtipocontrato` char(5) DEFAULT NULL,
  `idtipojornada` char(5) DEFAULT NULL,
  `fechainiciolab` date DEFAULT NULL,
  `fechainicionofiscal` date DEFAULT NULL,
  `sindicalizado` char(2) DEFAULT NULL,
  `idtiporegimen` char(5) DEFAULT NULL,
  `idriesgopuesto` char(5) DEFAULT NULL,
  `idperiodicidadpago` char(5) DEFAULT NULL,
  `salariobase` decimal(9,2) DEFAULT NULL,
  `salariodiario` decimal(9,2) DEFAULT NULL,
  `idbanco` char(5) DEFAULT NULL,
  `cuentabancaria` varchar(50) DEFAULT NULL,
  `subrfc` varchar(100) DEFAULT NULL,
  `subporcentaje` decimal(9,2) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) DEFAULT NULL,
  `fecha_ingreso` date DEFAULT NULL,
  `idtiempocontrato` int(11) DEFAULT NULL,
  `fechaBaja` date DEFAULT NULL,
  `sueldobruto` decimal(9,2) DEFAULT NULL,
  `aplicacalculo` int(11) DEFAULT 0,
  `sueldonf` decimal(9,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pcontrato`
--

INSERT INTO `pcontrato` VALUES (1,1,1,NULL,NULL,'','',NULL,NULL,'','','','',NULL,NULL,'','','',NULL,'2023-06-05 17:58:23',1,NULL,1,NULL,NULL,0,NULL),(2,2,2,17,1,'03','01','2020-11-10','2020-11-10','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 19:49:17',1,'2020-11-10',1,NULL,207.44,0,207.44),(3,3,3,18,2,'03','01','2023-01-16','2023-01-16','No','02','4','02',0.00,257.17,'','','',0.00,'2023-06-08 19:54:53',1,'2023-01-16',1,NULL,257.17,0,257.17),(4,4,4,18,2,'03','01','2023-04-27','2023-04-27','No','02','4','02',0.00,257.15,'','','',0.00,'2023-06-08 20:13:33',1,'2023-04-27',1,NULL,257.15,0,257.15),(5,5,5,19,4,'03','01','2023-04-24','2023-04-24','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 20:17:26',1,'2023-04-24',1,NULL,207.44,0,207.44),(6,6,6,19,5,'03','01','2020-06-05','2020-06-05','No','02','4','02',0.00,266.67,'','','',0.00,'2023-06-08 20:20:25',1,'2020-06-05',1,NULL,266.67,0,266.67),(7,7,7,19,4,'03','01','2022-08-01','2022-08-01','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 20:24:39',1,'2022-08-01',1,NULL,207.44,0,207.44),(8,8,8,19,6,'03','01','2022-08-01','2022-08-01','No','02','4','02',0.00,235.72,'','','',0.00,'2023-06-08 20:26:23',1,'2022-08-01',1,NULL,235.72,0,235.72),(9,9,9,19,4,'01','01','2022-12-21','2022-12-21','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 20:28:04',1,'2022-12-21',1,NULL,207.44,0,207.44),(10,10,10,19,7,'03','01','2022-03-28','2022-03-28','No','02','4','02',0.00,216.67,'','','',0.00,'2023-06-08 20:29:27',1,'2022-03-28',1,NULL,216.67,0,216.67),(11,11,11,19,8,'03','01','2023-05-31','2023-05-31','No','02','4','02',0.00,235.72,'','','',0.00,'2023-06-08 20:30:56',1,'2023-05-31',1,NULL,235.72,0,235.72),(12,12,12,19,4,'03','01','2023-05-11','2023-05-11','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 20:42:38',1,'2023-05-11',1,NULL,207.44,0,207.44),(13,13,13,19,5,'03','01','2022-11-15','2022-11-15','No','02','4','02',0.00,233.34,'','','',0.00,'2023-06-08 20:44:33',1,'2022-11-15',1,NULL,233.34,0,233.34),(14,14,14,19,9,'03','01','2023-04-17','2023-04-17','No','02','4','02',0.00,221.43,'','','',0.00,'2023-06-08 20:46:31',1,'2023-04-17',1,NULL,221.43,0,221.43),(15,15,15,19,4,'03','01','2023-01-26','2023-01-26','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 20:52:41',1,'2023-01-26',1,NULL,207.44,0,207.44),(16,16,16,19,10,'03','01','2023-02-02','2023-02-02','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 20:54:39',1,'2023-02-02',1,NULL,207.44,0,207.44),(17,17,17,19,4,'03','01','2023-02-27','2023-02-27','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 20:56:23',1,'2023-02-27',1,NULL,207.44,0,207.44),(18,18,18,19,8,'03','01','2023-02-25','2023-02-25','No','02','4','02',0.00,246.85,'','','',0.00,'2023-06-08 20:58:15',1,'2023-02-25',1,NULL,246.85,0,246.85),(19,19,19,19,9,'03','01','2023-02-28','2023-02-28','No','02','4','02',0.00,246.85,'','','',0.00,'2023-06-08 21:00:13',1,'2023-02-28',1,NULL,246.85,0,246.85),(20,20,20,19,4,'03','01','2023-05-29','2023-05-29','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 21:03:30',1,'2023-05-29',1,NULL,207.44,0,207.44),(21,21,21,17,1,'03','01','2023-01-30','2023-01-30','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 21:05:30',1,'2023-01-30',1,NULL,207.44,0,207.44),(22,22,22,19,9,'03','01','2023-03-23','2023-03-23','No','02','4','02',0.00,221.43,'','','',0.00,'2023-06-08 21:07:10',1,'2023-03-23',1,NULL,221.43,0,221.43),(23,23,23,19,4,'03','01','2023-04-27','2023-04-27','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 21:09:17',1,'2023-04-27',1,NULL,207.44,0,207.44),(24,24,24,19,4,'03','01','2023-03-20','2023-03-20','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 21:11:32',1,'2023-03-20',1,NULL,207.44,0,207.44),(25,25,25,19,4,'03','01','2023-05-08','2023-05-08','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 21:14:15',1,'2023-05-08',1,NULL,207.44,0,207.44),(26,26,26,19,4,'03','01','2023-05-22','2023-05-22','No','02','4','02',0.00,207.44,'','','',0.00,'2023-06-08 21:19:13',1,'2023-05-22',1,NULL,207.44,0,207.44),(27,27,27,19,9,'03','01','2023-05-29','2023-05-29','No','02','4','02',0.00,221.43,'','','',0.00,'2023-06-08 21:21:32',1,'2023-05-29',1,NULL,221.43,0,221.43),(28,28,28,19,12,'03','01','2021-07-26','2021-07-26','No','02','4','02',392.21,392.21,'002','1177023238','',0.00,'2023-06-08 21:30:29',1,'2021-07-26',1,NULL,373.29,1,0.00),(29,29,29,19,9,'03','01','2017-06-01','2017-06-01','No','02','4','02',260.72,260.72,'072','1051527377','',0.00,'2023-06-08 21:39:45',1,'2017-06-01',1,NULL,246.85,1,0.00),(30,30,30,19,8,'03','01','2022-08-20','2022-08-20','No','02','4','02',258.83,258.83,'072','1209382685','',0.00,'2023-06-08 22:26:48',1,'2022-08-20',1,NULL,246.67,1,0.00),(31,31,31,19,5,'03','01','2022-12-28','2022-12-28','No','02','4','02',245.37,245.37,'072','1223497035','',0.00,'2023-06-08 22:29:04',1,'2022-12-28',1,NULL,233.34,1,0.00),(32,32,32,19,9,'03','01','2021-11-19','2021-11-19','No','02','4','02',259.01,259.01,'072','1177023313','',0.00,'2023-06-08 22:31:38',1,'2021-11-19',1,NULL,246.85,1,0.00),(33,33,33,19,4,'03','01','2022-08-02','2022-08-02','No','02','4','02',241.70,241.70,'072','1212486435','',0.00,'2023-06-08 22:36:19',1,'2022-08-02',1,NULL,230.35,1,0.00),(34,34,34,19,6,'03','01','2019-06-19','2019-06-19','No','02','4','02',277.20,277.20,'072','1156061105','',0.00,'2023-06-08 22:38:55',1,'2019-06-19',1,NULL,263.15,1,0.00),(35,35,35,19,5,'03','01','2022-10-28','2022-10-28','No','02','4','02',244.84,244.84,'072','1224040764','',0.00,'2023-06-08 22:40:41',1,'2022-10-28',1,NULL,233.34,1,0.00),(36,36,36,19,7,'03','01','2020-10-15','2020-10-15','No','02','4','02',293.30,293.30,'012','153 680 2394','',0.00,'2023-06-08 22:42:46',1,'2020-10-15',1,NULL,279.15,1,0.00),(37,37,37,19,11,'03','01','2020-11-11','2020-11-11','No','02','4','02',294.24,294.24,'012','153 680 2386','',0.00,'2023-06-08 22:45:04',1,'2020-11-11',1,NULL,280.04,1,0.00),(38,38,38,19,5,'03','01','2021-03-04','2021-03-04','No','02','4','02',451.16,451.16,'012','155 777 9644','',0.00,'2023-06-08 22:48:24',1,'2021-03-04',1,NULL,429.40,1,0.00),(39,39,39,19,9,'03','01','2021-11-15','2021-11-15','No','02','4','02',217.67,217.67,'','','',0.00,'2023-06-08 22:50:26',1,'2021-11-15',1,NULL,207.44,1,0.00),(40,40,40,19,6,'03','01','2022-04-16','2022-04-16','No','02','4','02',272.97,272.97,'012','1568241419','',0.00,'2023-06-08 22:52:22',1,'2022-04-16',1,NULL,260.15,1,0.00),(41,41,41,19,7,'03','01','2022-01-17','2022-01-17','No','02','4','02',252.36,252.36,'012','1540244498','',0.00,'2023-06-08 22:54:36',1,'2022-01-17',1,NULL,240.51,1,0.00),(42,42,42,19,11,'03','01','2022-02-03','2022-02-03','No','02','4','02',293.85,293.85,'072','1180980144','',0.00,'2023-06-09 03:29:50',1,'2022-02-03',1,NULL,280.04,1,0.00),(43,43,43,19,5,'01','01','2021-11-01','2021-11-01','No','02','4','02',319.58,319.58,'072','1172030651','',0.00,'2023-06-09 03:32:18',1,'2021-11-01',1,NULL,300.00,1,0.00),(44,44,44,19,7,'03','01','2022-05-03','2022-05-03','No','02','4','02',314.79,314.79,'072','1188645131','',0.00,'2023-06-09 03:34:18',1,'2022-05-03',1,NULL,300.00,1,0.00),(45,45,45,19,6,'03','01','2022-12-19','2022-12-19','No','02','4','02',285.90,285.90,'072','1213621644','',0.00,'2023-06-09 03:36:36',1,'2022-12-19',1,NULL,272.46,1,0.00),(46,46,46,17,1,'03','01','2023-01-30','2023-01-30','No','02','4','02',217.67,217.67,'072','1189977437','',0.00,'2023-06-09 03:38:38',1,'2023-01-30',1,NULL,207.44,1,0.00),(47,47,47,2,13,'03','01','2023-01-16','2023-01-16','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 04:01:29',1,'2023-01-16',1,NULL,207.44,0,207.44),(48,48,48,2,14,'03','01','2023-05-22','2023-05-22','No','02','4','04',0.00,233.34,'','','',0.00,'2023-06-09 04:09:11',1,'2023-05-22',1,NULL,233.34,0,233.34),(49,49,49,1,15,'03','01','2023-02-01','2023-02-01','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 04:12:08',1,'2023-02-01',1,NULL,207.44,0,207.44),(50,50,50,1,16,'03','01','2020-10-06','2020-10-06','No','02','4','04',0.00,266.67,'','','',0.00,'2023-06-09 04:17:00',1,'2020-10-06',1,NULL,266.67,0,266.67),(51,51,51,1,17,'03','01','2022-01-06','2022-01-06','No','02','4','04',0.00,223.34,'','','',0.00,'2023-06-09 04:18:35',1,'2022-01-06',1,NULL,223.34,0,223.34),(52,52,52,1,15,'03','01','2022-01-06','2022-01-06','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 04:20:07',1,'2022-01-06',1,NULL,207.44,0,207.44),(53,53,53,1,15,'03','01','2023-05-01','2023-05-01','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 04:21:40',1,'2023-05-01',1,NULL,207.44,0,207.44),(54,54,54,1,18,'03','01','2023-05-01','2023-05-01','No','02','4','04',0.00,233.34,'','','',0.00,'2023-06-09 04:22:48',1,'2023-05-01',1,NULL,233.34,0,233.34),(55,55,55,2,13,'03','01','2023-05-12','2023-05-12','No','02','4','04',0.00,233.34,'','','',0.00,'2023-06-09 04:24:09',1,'2023-05-12',1,NULL,233.34,0,233.34),(56,56,56,1,15,'03','01','2022-02-15','2022-02-15','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 04:26:52',1,'2022-02-15',1,NULL,207.44,0,207.44),(57,57,57,1,16,'03','01','2022-02-15','2022-02-15','No','02','4','04',0.00,266.67,'','','',0.00,'2023-06-09 04:28:42',1,'2022-02-15',1,NULL,266.67,0,266.67),(58,58,58,19,8,'03','01','2022-07-14','2022-07-14','No','02','4','04',0.00,221.43,'','','',0.00,'2023-06-09 04:33:50',1,'2022-07-14',1,NULL,221.43,0,221.43),(59,59,59,19,11,'03','01','2023-01-02','2023-01-02','No','02','4','04',0.00,263.36,'','','',0.00,'2023-06-09 04:35:54',1,'2023-01-02',1,NULL,263.36,0,263.36),(60,60,60,19,4,'03','01','2023-01-30','2023-01-30','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 04:56:03',1,'2023-01-30',1,NULL,207.44,0,207.44),(61,61,61,1,18,'03','01','2023-02-01','2023-02-01','No','02','4','04',0.00,223.34,'','','',0.00,'2023-06-09 04:58:16',1,'2023-02-01',1,NULL,223.34,0,223.34),(62,62,62,1,15,'03','01','2023-01-30','2023-01-30','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:00:41',1,'2023-01-30',1,NULL,207.44,0,207.44),(63,63,63,1,15,'03','01','2023-02-15','2023-02-15','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:02:31',1,'2023-02-15',1,NULL,207.44,0,207.44),(64,64,64,19,11,'03','01','2023-04-25','2023-04-25','No','02','4','04',0.00,250.00,'','','',0.00,'2023-06-09 05:05:26',1,'2023-04-25',1,NULL,250.00,0,250.00),(65,65,65,19,9,'03','01','2023-03-06','2023-03-06','No','02','4','04',0.00,221.43,'','','',0.00,'2023-06-09 05:06:53',1,'2023-03-06',1,NULL,221.43,0,221.43),(66,66,66,1,15,'03','01','2023-04-12','2023-04-12','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:08:35',1,'2023-04-12',1,NULL,207.44,0,207.44),(67,67,67,19,4,'03','01','2023-04-25','2023-04-25','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:10:21',1,'2023-04-25',1,NULL,207.44,0,207.44),(68,68,68,17,1,'03','01','2023-05-02','2023-05-02','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:12:08',1,'2023-05-02',1,NULL,207.44,0,207.44),(69,69,69,19,4,'03','01','2023-05-03','2023-05-03','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:15:14',1,'2023-05-03',1,NULL,207.44,0,207.44),(70,70,70,1,18,'03','01','2000-01-01','2000-01-01','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:22:38',1,'2000-01-01',1,NULL,207.44,0,207.44),(71,71,71,2,13,'03','01','2000-01-01','2000-01-01','No','02','4','04',0.00,233.34,'','','',0.00,'2023-06-09 05:24:19',1,'2000-01-01',1,NULL,233.34,0,233.34),(72,72,72,1,15,'03','01','2000-01-01','2000-01-01','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:26:00',1,'2000-01-01',1,NULL,207.44,0,207.44),(73,73,73,2,13,'03','01','2021-05-24','2021-05-24','No','02','4','04',0.00,266.67,'012','152 292 6578','',0.00,'2023-06-09 05:28:40',1,'2021-05-24',1,NULL,266.67,0,266.67),(74,74,74,1,19,'03','01','2023-01-01','2023-01-01','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:30:38',1,'2023-01-01',1,NULL,207.44,0,207.44),(75,75,75,1,18,'03','01','2023-01-01','2023-01-01','No','02','4','04',0.00,223.34,'','','',0.00,'2023-06-09 05:32:19',1,'2023-01-01',1,NULL,223.34,0,223.34),(76,76,76,2,13,'03','01','2023-01-01','2023-01-01','No','02','4','04',0.00,233.34,'','','',0.00,'2023-06-09 05:34:22',1,'2023-01-01',1,NULL,233.34,0,233.34),(77,77,77,1,15,'03','01','2023-01-01','2023-01-01','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 05:36:19',1,'2023-01-01',1,NULL,207.44,0,207.44),(78,78,78,5,20,'03','01','1999-05-06','1999-05-06','No','02','4','04',558.90,558.90,'072','0644153144','',0.00,'2023-06-09 05:40:04',1,'1999-05-06',1,NULL,479.53,1,0.00),(79,79,79,5,20,'03','01','2015-08-16','2015-08-16','No','02','4','04',434.98,434.98,'072','0844194817','',0.00,'2023-06-09 05:41:42',1,'2015-08-16',1,NULL,392.15,1,0.00),(80,80,80,3,21,'03','01','2020-03-04','2020-03-04','No','02','4','04',526.05,526.05,'072','1103630822','',0.00,'2023-06-09 05:52:51',1,'2020-03-04',1,NULL,500.00,1,0.00),(81,81,81,15,22,'03','01','2020-01-06','2020-01-06','No','02','4','04',368.24,368.24,'072','1156061093','',0.00,'2023-06-09 05:55:13',1,'2020-01-06',1,NULL,350.00,1,0.00),(82,82,82,11,23,'03','01','2020-06-23','2020-06-23','No','02','4','04',561.11,561.11,'072','1180815581','',0.00,'2023-06-09 05:57:10',1,'2020-06-23',1,NULL,533.33,1,0.00),(83,83,83,12,30,'03','01','2020-07-20','2020-07-20','No','02','4','04',350.24,350.24,'072','1172967403','',0.00,'2023-06-09 05:59:05',1,'2020-07-20',1,NULL,333.34,1,0.00),(84,84,84,4,25,'03','01','2022-02-16','2022-02-16','No','02','4','04',858.41,858.41,'','','',0.00,'2023-06-09 06:00:41',1,'2022-02-16',1,NULL,818.08,1,0.00),(85,85,85,4,25,'03','01','2022-02-16','2022-02-16','No','02','4','04',858.41,858.41,'','','',0.00,'2023-06-09 06:01:55',1,'2022-02-16',1,NULL,818.08,1,0.00),(86,86,86,4,25,'03','01','2022-02-16','2022-02-16','No','02','4','04',858.41,858.41,'','','',0.00,'2023-06-09 06:03:17',1,'2022-02-16',1,NULL,818.08,1,0.00),(87,87,87,15,27,'03','01','2022-01-31','2022-01-31','No','02','4','04',281.46,281.46,'012','1592800809','',0.00,'2023-06-09 06:05:40',1,'2022-01-31',1,NULL,266.67,1,0.00),(88,88,88,2,28,'03','01','2022-10-03','2022-10-03','No','02','4','04',1318.12,1318.12,'012','1560530045','',0.00,'2023-06-09 06:08:18',1,'2022-10-03',1,NULL,1256.17,1,0.00),(89,89,89,15,29,'01','01','2022-10-01','2022-10-01','No','02','4','04',524.66,524.66,'012','1516147628','',0.00,'2023-06-09 06:09:40',1,'2022-10-01',1,NULL,500.00,1,0.00),(90,90,90,12,30,'03','01','2022-03-07','2022-03-07','No','02','4','04',314.79,314.79,'072','1182136329','',0.00,'2023-06-09 06:11:50',1,'2022-03-07',1,NULL,300.00,1,0.00),(91,91,91,5,20,'03','01','2020-10-23','2020-10-23','No','02','4','04',624.46,624.46,'012','','',0.00,'2023-06-09 06:13:13',1,'2020-10-23',1,NULL,597.46,1,0.00),(92,92,92,5,31,'03','01','2018-04-01','2018-04-01','No','02','4','04',227.85,227.85,'072','1156061066','',0.00,'2023-06-09 06:14:46',1,'2018-04-01',1,NULL,218.00,1,0.00),(93,93,93,9,32,'03','01','2023-03-07','2023-03-07','No','02','4','04',570.83,570.83,'072','1222749830','',0.00,'2023-06-09 06:16:33',1,'2023-03-07',1,NULL,544.00,1,0.00),(94,94,94,7,33,'03','01','2022-12-19','2022-12-19','No','02','4','04',349.78,349.78,'072','1226078891','',0.00,'2023-06-09 06:18:17',1,'2022-12-19',1,NULL,333.34,1,0.00),(95,95,95,1,34,'03','01','2018-11-30','2018-11-30','No','02','4','04',351.60,351.60,'072','1051527313','',0.00,'2023-06-09 06:21:20',1,'2018-11-30',1,NULL,333.34,1,0.00),(96,96,96,2,13,'03','01','2019-12-16','2019-12-16','No','02','4','04',272.67,272.67,'072','1183988776','',0.00,'2023-06-09 06:23:36',1,'2019-12-16',1,NULL,259.17,1,0.00),(97,97,97,1,18,'03','01','2021-09-01','2021-09-01','No','02','4','04',222.15,222.15,'072','1193544902','',0.00,'2023-06-09 06:25:34',1,'2021-09-01',1,NULL,211.72,1,0.00),(98,98,98,1,17,'03','01','2019-11-19','2019-11-19','No','02','4','04',222.75,222.75,'072','1051527144','',0.00,'2023-06-09 06:27:23',1,'2019-11-19',1,NULL,211.72,1,0.00),(99,99,99,1,15,'03','01','2021-08-10','2021-08-10','No','02','4','04',217.67,217.67,'072','1182637983','',0.00,'2023-06-09 06:28:57',1,'2021-08-10',1,NULL,207.44,1,0.00),(100,100,100,1,34,'03','01','1995-07-22','1995-07-22','No','02','4','04',946.10,946.10,'072','0644152987','',0.00,'2023-06-09 06:30:28',1,'1995-07-22',1,NULL,610.69,1,0.00),(101,101,101,1,34,'03','01','2021-07-02','2021-07-02','No','02','4','04',359.34,359.34,'012','1595521678','',0.00,'2023-06-09 06:34:53',1,'2021-07-02',1,NULL,333.34,1,0.00),(102,102,102,2,13,'03','01','2020-09-22','2020-09-22','No','02','4','04',272.05,272.05,'012','1543734776','',0.00,'2023-06-09 06:37:05',1,'2020-09-22',1,NULL,258.93,1,0.00),(103,103,103,19,7,'03','01','2021-11-01','2021-11-01','No','02','4','04',241.56,241.56,'012','1595521685','',0.00,'2023-06-09 06:38:51',1,'2021-11-01',1,NULL,230.21,1,0.00),(104,104,104,19,5,'03','01','2013-07-22','2013-07-22','No','02','4','04',313.22,313.22,'012','1529014558','',0.00,'2023-06-09 06:40:30',1,'2013-07-22',1,NULL,296.56,1,0.00),(105,105,105,19,6,'03','01','2016-08-01','2016-08-01','No','02','4','04',278.16,278.16,'012','1529014540','',0.00,'2023-06-09 06:42:13',1,'2016-08-01',1,NULL,263.36,1,0.00),(106,106,106,19,9,'03','01','2020-10-29','2020-10-29','No','02','4','04',259.16,259.16,'012','1557905316','',0.00,'2023-06-09 06:44:01',1,'2020-10-29',1,NULL,246.66,1,0.00),(107,107,107,19,10,'03','01','2020-06-15','2020-06-15','No','02','4','04',242.17,242.17,'012','1557900747','',0.00,'2023-06-09 06:45:57',1,'2020-06-15',1,NULL,230.18,1,0.00),(108,108,108,1,34,'03','01','2021-03-07','2021-03-07','No','02','4','04',350.24,350.24,'072','10362254863','',0.00,'2023-06-09 06:49:07',1,'2021-03-07',1,NULL,333.34,1,0.00),(109,109,109,1,16,'03','01','2020-07-17','2020-07-17','No','02','4','04',245.17,245.17,'012','','',0.00,'2023-06-09 06:50:56',1,'2020-07-17',1,NULL,233.34,1,0.00),(110,110,110,1,34,'03','01','2020-08-07','2020-08-07','No','02','4','04',370.27,370.27,'012','1157247595','',0.00,'2023-06-09 06:52:41',1,'2020-08-07',1,NULL,333.34,1,0.00),(111,111,111,2,13,'03','01','2021-08-04','2021-08-04','No','02','4','04',240.26,240.26,'072','1229576129','',0.00,'2023-06-09 06:57:09',1,'2021-08-04',1,NULL,228.67,1,0.00),(112,112,112,1,18,'03','01','2022-07-14','2022-07-14','No','02','4','04',217.67,217.67,'072','1229577443','',0.00,'2023-06-09 07:00:37',1,'2022-07-14',1,NULL,207.44,1,0.00),(113,113,113,1,34,'03','01','2016-10-12','2016-10-12','No','02','4','04',359.34,359.34,'012','1550730265','',0.00,'2023-06-09 07:02:26',1,'2016-10-12',1,NULL,333.34,1,0.00),(114,114,114,1,18,'03','01','2019-02-24','2019-02-24','No','02','4','04',250.44,250.44,'012','1536802424','',0.00,'2023-06-09 07:04:16',1,'2019-02-24',1,NULL,237.75,1,0.00),(115,115,115,1,35,'03','01','2020-09-22','2020-09-22','No','02','4','04',272.05,272.05,'012','1507065954','',0.00,'2023-06-09 07:05:52',1,'2020-09-22',1,NULL,258.93,1,0.00),(116,116,116,1,15,'03','01','2021-03-04','2021-03-04','No','02','4','04',217.95,217.95,'012','1596812272','',0.00,'2023-06-09 07:07:40',1,'2021-03-04',1,NULL,207.44,1,0.00),(117,117,117,1,15,'03','01','2021-10-22','2021-10-22','No','02','4','04',217.67,217.67,'012','1580026487','',0.00,'2023-06-09 07:09:29',1,'2021-10-22',1,NULL,207.44,1,0.00),(118,118,118,1,15,'03','01','2022-05-25','2022-05-25','No','02','4','04',217.67,217.67,'012','1568877895','',0.00,'2023-06-09 07:11:48',1,'2022-05-25',1,NULL,207.44,1,0.00),(119,119,119,1,16,'03','01','2022-06-16','2022-06-16','No','02','4','04',311.51,311.51,'012','1585684053','',0.00,'2023-06-09 07:13:20',1,'2022-06-16',1,NULL,296.87,1,0.00),(120,120,120,17,1,'03','01','2022-11-11','2022-11-11','No','02','4','04',217.67,217.67,'012','1566529474','',0.00,'2023-06-09 07:14:59',1,'2022-11-11',1,NULL,207.44,1,0.00),(121,121,121,1,16,'03','01','2021-10-29','2021-10-29','No','02','4','04',319.09,319.09,'072','1172030213','',0.00,'2023-06-09 07:17:04',1,'2021-10-29',1,NULL,299.14,1,0.00),(122,122,122,17,1,'03','01','2022-05-09','2022-05-09','No','02','4','04',229.41,229.41,'072','1189934962','',0.00,'2023-06-09 07:19:37',1,'2022-05-09',1,NULL,219.49,1,0.00),(123,123,123,1,35,'01','01','2021-11-08','2021-11-08','No','02','4','04',672.57,672.57,'012','1574961547','',0.00,'2023-06-09 07:21:39',1,'2021-11-08',1,NULL,271.51,1,0.00),(124,124,124,1,34,'03','01','2022-10-01','2022-10-01','No','02','4','04',349.78,349.78,'012','1545341470','',0.00,'2023-06-09 07:39:01',1,'2022-10-01',1,NULL,333.34,1,0.00),(125,125,125,1,36,'03','01','2022-10-01','2022-10-01','No','02','4','04',310.84,310.84,'072','1206462689','',0.00,'2023-06-09 07:40:50',1,'2022-10-01',1,NULL,296.23,1,0.00),(126,126,126,1,19,'03','01','2023-01-19','2023-01-19','No','02','4','04',217.67,217.67,'072','1229655761','',0.00,'2023-06-09 07:42:39',1,'2023-01-19',1,NULL,207.44,1,0.00),(127,127,127,4,26,'03','01','2023-03-16','2023-03-16','No','02','4','04',350.24,350.24,'002','','',0.00,'2023-06-09 07:46:09',1,'2023-03-16',1,NULL,333.34,1,0.00);

--
-- Table structure for table `pdeducciones`
--

CREATE TABLE `pdeducciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipodeduccion` char(5) DEFAULT NULL,
  `importe` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  `fechaCargo` date DEFAULT NULL,
  `fecuencia` int(11) DEFAULT -1,
  `vencimiento` date DEFAULT NULL,
  `idaccion_correctiva` int(11) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pdeducciones`
--

INSERT INTO `pdeducciones` VALUES (3,'002',414.72,1,81,'2023-05-30',-1,NULL,NULL,NULL),(4,'001',134.61,1,81,'2023-05-30',-1,NULL,NULL,NULL),(7,'002',387.53,1,83,'2023-05-15',-1,NULL,NULL,NULL),(8,'001',127.11,1,83,'2023-05-15',-1,NULL,NULL,NULL);

--
-- Table structure for table `pdeducciones_nf`
--

CREATE TABLE `pdeducciones_nf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipodeduccion` char(5) DEFAULT NULL,
  `importe` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  `fechaCargo` date DEFAULT NULL,
  `fecuencia` int(11) DEFAULT -1,
  `vencimiento` date DEFAULT NULL,
  `idaccion_correctiva` int(11) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pdeducciones_nf`
--


--
-- Table structure for table `pdireccion`
--

CREATE TABLE `pdireccion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nip` int(11) DEFAULT NULL,
  `calle` varchar(500) DEFAULT NULL,
  `numext` varchar(50) DEFAULT NULL,
  `numint` varchar(50) DEFAULT NULL,
  `colonia` varchar(200) DEFAULT NULL,
  `municipio` varchar(100) DEFAULT NULL,
  `cp` varchar(10) DEFAULT NULL,
  `idestado` char(5) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pdireccion`
--

INSERT INTO `pdireccion` VALUES (1,0,'AVENIDA CENTRAL SUR FRANCISCO SARABIA','1307','','CENTRO','MAPASTEPEC ESTACION','30560','CHP',1),(2,2,'CALLE SIN NOMBRE','','',' EJIDO JOSE MARIA PINO SUAREZ','MAPASTEPEC','30565','CHP',1),(3,3,'SIN NOMBRE','','','SIN COLONIA','MAPASTEPEC','','CHP',1),(4,4,'SIN DIRECCION','','','SIN COLONIA','','','CHP',1),(5,5,'MANZANA 5 LOTE 23','','','VIDA MEJOR','ESCUINTLA','30600','CHP',1),(6,6,'','','','','','','AGU',1),(7,7,'','','','','','','AGU',1),(8,8,'SIN CALLE','','','','MAPASTEPEC','','CHP',1),(9,9,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(10,10,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(11,11,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(12,12,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(13,13,'C 9A ORIENTE CENTRAL NORTE','204','','BARRIO LOS LAURELES','MAPASTEPEC','30560','CHP',1),(14,14,'C 8 AV SUR ','802','','BARRIO 15 DE ENERO','MAPASTEPEC','30560','CHP',1),(15,15,'JAVIER MINA Y JUAREZ','','','BARRIO NICATAN','TONALA','30500','CHP',1),(16,16,'SIN DIRECCION','','','COL. BELISARIO','TONALA','30500','CHP',1),(17,17,'AV. FERROCARRIL','','','BARRIO SAN FRANCISCO','TONALA','30500','CHP',1),(18,18,'SIN DIRECCION','','','COL.MAGISTERIAL','TONALA','30500','CHP',1),(19,19,'SIN DIRECCION','','','COL. SERDAN','TONALA','30500','CHP',1),(20,20,'POETA ENOCH CANCINO E149 D8','E149 D','D8','VIDA MEJOR','TUXTLA GUTIERREZ','29045','CHP',1),(21,21,'AV. SAN CRISTOBAL Y CALLE SIMOJOVEL ','MANZANA 17','LOTE 21','LA ESPERANZA','TUXTLA GUTIERREZ','29019','CHP',1),(22,22,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(23,23,'15 SUR ENTRE CALLE CENTRAL Y 1A ORIENTE','124','','SAN FRANCISCO ','TUXTLA GUTIERREZ','29066','CHP',1),(24,24,'AV.LOMA BONITA','MANZANA 2','LOTE 32','LOMAS DEL ORIENTE ','TUXTLA GUTIERREZ','29096','CHP',1),(25,25,'RIBERA ZIQUETE','','','RIBERA ZIQUETE','TUXTLA GUTIERREZ','29066','CHP',1),(26,26,'ALTOS DEL SUR ','MANZANA 2','LOTE 20','JARDINES DEL NORTE ','TUXTLA GUTIERREZ','39710','CHP',1),(27,27,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(28,28,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(29,29,'CENTRAL NORTE FCO IMADERO','','','EL TRIUNFO','ESCUINTLA','30600','CHH',1),(30,30,'ARTICULO 123','','','BARRIO SANTO DOMINGO','ESCUINTLA','30600','CHP',1),(31,31,'VIDA MEJOR','MANZANA 5 LOTE12','','VIDA MEJOR','ESCUINTLA','30600','CHP',1),(32,32,'SINDIRECCION','','','','MAPASTEPEC','','CHP',1),(33,33,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(34,34,'SIN DIRECCION','','','BARRANCON','MAPASTEPEC','30563','CHP',1),(35,35,'CALLE CENTRAL','','','BARRIO OLIMPICO','MAPASTEPEC','30590','CHP',1),(36,36,'SIN DIRECCION','','','RANCHERIA EL VERANO','TONALA','30500','CHP',1),(37,37,'C.24 DE FEBRERO Y AV. ANAHUAC','','','COCOTEROS','TONALA ','30500','CHP',1),(38,38,'JOAQUIN MIGUEL GUTIERREZ E ITURBIDE','','','NICATAN','TONALA ','30500','CHP',1),(39,39,'SIN DIRECCION','','','','TONALA ','','CHP',1),(40,40,'SIN DIRECCION','','','RANCHERIA HUACHIPILIN CALENTURA','TONALA ','30500','CHP',1),(41,41,'CALLE LIMON ','MANZANA 6','LOTE 02 ','CAPOLINES 3','TUXTLA GUTIERREZ','29017','CHP',1),(42,42,'KILOMETRO 12','','','RIBERA NANDAMBUA 2 SECCION ','TUXTLA GUTIERREZ','26160','CHP',1),(43,43,'AV.COLOSIO ','MANZANA 2.4','LOTE 15','BELLA VISTA TERAN ','TUXTLA GUTIERREZ','29050','CHP',1),(44,44,'FRANCISCO I MADERO MZ 27','383','','FRANCISCO I. MADERO ','TUXTLA GUTIERREZ','','CHP',1),(45,45,'CERRO HUECO CALZADA JORGE GOMEZ ','12','',' ZIQUETE','TUXTLA GUTIERREZ','29096','CHP',1),(46,46,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(47,47,'CALLE 13 ORIENTE SUR','638','','SANTA CRUZ','TUXTLA GUTIERREZ','29073','CHP',1),(48,48,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(49,49,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(50,50,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(51,51,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(52,52,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(53,53,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(54,54,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(55,55,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(56,56,'','','','NUEVO PIJIJIAPAN','PIJIJIAPAN','30540','CHP',1),(57,57,'4 Y 5 AV SUR ','','','SAN FRACISCO','PIJIJIAPAN','30540','CHP',1),(58,58,'SIN DIRECCION','','','BARRIO LAS VEGAS','PIJIJIAPAN','30540','CHP',1),(59,59,'3A AV. SUR ','','','COCAL','PIJIJIAPAN','30540','CHP',1),(60,60,'9A AV. SUR ORIENTE','','','SAN PEDRO','PIJIJIAPAN','30540','CHP',1),(61,61,'1A AV. SUR OTE ','28','','SAN FRANCISCO','PIJIJIAPAN','30540','CHP',1),(62,62,'4TA PNT NORTE','24','','LAS FLORES','PIJIJIAPAN','30540','CHP',1),(63,63,'8 AV. SURPONIENTE','','','OBRERA','PIJIJIAPAN','30540','CHP',1),(64,64,'SIN DIRECCION','','','','PIJIJIAPAN','','CHP',1),(65,65,'SIN DIRECCION','','','','PIJIJIAPAN','','CHP',1),(66,66,'6A AV. NTE PTE Y 7A NTE PNT','','','ARENAL','PIJIJIAPAN','30540','CHP',1),(67,67,'5A AV NORTE Y 6 AV. NORTE','','','ARENAL','PIJIJIAPAN','30540','CHP',1),(68,68,'1A AV SUR ORIENTE SUR','','','SAN FRANCISCO','PIJIJIAPAN','30540','CHP',1),(69,69,'','','','GALEANA','PIJIJIAPAN','30540','CHP',1),(70,70,'C JOSEFA ORTIZ ','','','BARRIO INDEPENDENCIA','MA','30560','CHP',1),(71,71,'C 14A PONIENTE','','','BARRIO SAN MIGUEL','MAPASTEPEC','30560','CHP',1),(72,72,'C. 13A PONIENTE','','','BARRIO MALUCAL','MAPASTEPEC','30560','CHP',1),(73,73,'SIN DIRECCION','','','EJ. LAZARO CARDENAS','PIJIJIAPAN','30540','CHP',1),(74,74,'AV. FRANCISCO I. MADERO','475','','BENITO JUAREZ ','TUXTLA GUTIERREZ','29080','CHP',1),(75,75,'C 2A ORIENTE SUR ENTRE 19 Y 20 SUR','2046','','SAN FRANCISCO ','TUXTLA GUTIERREZ','29066','CHP',1),(76,76,'AV. 6A NORTE PONIENTE','1430','','BARRIO JUY JUY ','TUXTLA GUTIERREZ','29038','CHP',1),(77,77,'AV.CHIAPAS','16','10','NUEVA ESTRELLA','TUXTLA GUTIERREZ','29010','CHP',1),(78,78,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(79,79,'SIN DIRECCION','','','','TU','','CHP',1),(80,80,'11 NTE OTE NO 457','','','LA PIMIENTA','TUXTLA GUTIERREZ','29000','CHP',1),(81,81,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(82,82,'GUALLABILLO','','30','EL REFUGIO ','CHIAPAS DE CORZO','29163','CHP',1),(83,83,'15 PONIENTE SUR ','1091','','XAMAIPAK','TUXTLA GUTIERREZ','29060','CHP',1),(84,84,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(85,85,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(86,86,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(87,87,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(88,88,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(89,89,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(90,90,'TULIPANES','255','','FRACC. LAS FLORES','TUXTLA GUTIERREZ','29049','CHP',1),(91,91,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(92,92,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','CHP',1),(93,93,'9A SUR PONIENTE ENTRE 5A Y 6A PONIENTE','646','10','CENTRO','TUXTLA GUTIERREZ','29000','CHP',1),(94,94,'HUIXTLA','150','1','KM4','TUXTLA GUTIERREZ','29019','CHP',1),(95,95,'COL. PIEDRAS NEGRAS','','','PIEDRAS NEGRAS','ESCUINTLA','30600','CHP',1),(96,96,'SIN DIRECCION','','','','ESCUINTLA','','CHP',1),(97,97,'8 DE SEPTIEMBRE','MZA 7','','NVA NUEVO MILENIO','ESCUINTLA','30604','CHP',1),(98,98,'ARTICULO 123','','','BARRIO SANTO DOMINGO','ESCUINTLA','30600','CHP',1),(99,99,'ARTICULO 123','','','BARRIO SANTO DOMINGO','ESCUINTLA','30600','CHP',1),(100,100,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(101,101,'3A AV NORTE','','','FLORES','PIJIJIAPAN','30540','CHP',1),(102,102,'2A AV NOTE','28','','FLORES','PIJIJIAPAN','30540','CHP',1),(103,103,'SIN DIRECCION','','','NUEVA GERUSALEN','PIJIJIAPAN','30540','CHP',1),(104,104,'SIN DIRECCION','','','RANCHGERIA LA ANONA','PIJIJIAPAN','30540','CHP',1),(105,105,'SIN DIRECCION','','','SAN JUAN','PIJIJIAPAN','30540','CHP',1),(106,106,'SIN DIRECCION','','','BARRIO SABNRTA CRUZ','PIJIJIAPAN','30540','CHP',1),(107,107,'LAS NORMAS','','','BAARIO LAS LIMAS','PIJIJIAPAN','30540','CHP',1),(108,108,'AV 1A NORTE','N. 404 ','','BARRIO SANTA CRUZ','MAPASTEPEC','30560','CHP',1),(109,109,'BARRANCON','','','RANCHERIA BARRANCON','MAPASTEPEC','30563','CHP',1),(110,110,'C SIN NOMBRE','','','EJ IBARRA','MAPASTEPEC','30565','CHP',1),(111,111,'5A NORTE','701','','BARRIO SANTA CRUZ','MAPASTEPEC','30560','CHP',1),(112,112,'8A CALLE PONIENTE','','','BARRIO SAN MIGUEL','MAPASTEPEC','30560','CHP',1),(113,113,'ROBLE','','','FRACC. EL TREBOL','TONALA ','30500','CHP',1),(114,114,'SIN DIRECCION','','','RANCHERIA BUENA VISTA','TONALA ','30500','CHP',1),(115,115,'AV, LAS CRUCES','','','BARRIO NICATAN','TONALA ','30500','CHP',1),(116,116,'AV LAS CRUCES','','','COL.EVOLUCION','TONALA ','30500','CHP',1),(117,117,'SIN DIRECCION','','','RANCHERIA LA LAGUNA','TONALA ','30500','CHP',1),(118,118,'C. GALEANA','','','BARRIO NUEVO','TONALA ','30500','CHP',1),(119,119,'BELIZARIO DOMIGUEZ','','','BARRIO NUEVA ESPERANZA','TONALA ','30500','CHP',1),(120,120,'AV LAS CRUCES','','','COL. EVOLUCION','TONALA','30500','CHP',1),(121,121,'AV.RIO SABINAL','MANZANA 2','LOTE 01','AMPLIACION ARROLLO BLANCO','TUXTLA GUTIERREZ','29049','CHP',1),(122,122,'AV. BENITO JUAREZ','','','MORELOS','TUXTLA GUTIERREZ','29160','CHP',1),(123,123,'CIRCUITO LAS CASAS SUR ','5','','LA MISION ','TUXTLA GUTIERREZ','','CHP',1),(124,124,'CALLE MAYA, RIBERA CHICHE ITZA','MANZANA 74 ','LOTE 08','IDEAL','TUXTLA GUTIERREZ','229086','CHP',1),(125,125,'AV COPAN','','','2 DE FEBRERO','TUXTLA GUTIERREZ','29086','CHP',1),(126,126,'19 AV SUR OTE.','1111','','BENITO JUAREZ ','TUXTLA GUTIERREZ','29080','CHP',1),(127,127,'2A CALLE PONIENTE  SUR ','568','','TERÀN','TUXTLA GUTIERREZ','29050','CHP',1);

--
-- Table structure for table `pdocumentos`
--

CREATE TABLE `pdocumentos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file` varchar(500) DEFAULT NULL,
  `idtipo` int(11) DEFAULT NULL,
  `idempleado` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pdocumentos`
--


--
-- Table structure for table `pempleado`
--

CREATE TABLE `pempleado` (
  `nip` int(11) NOT NULL AUTO_INCREMENT,
  `asistencia` int(11) DEFAULT NULL,
  `rfc` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `nombre` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `curp` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `nss` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `fechanac` date DEFAULT NULL,
  `edocivil` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `sexo` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `email` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `telefono` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `celular` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `extension` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `idpatron` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idsucursal` int(11) DEFAULT NULL,
  `foto` varchar(500) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `fecha_baja` date DEFAULT NULL,
  `tiposangre` varchar(45) DEFAULT NULL,
  `nivelestudios` text DEFAULT NULL,
  `numhijos` varchar(50) DEFAULT '0-0',
  `religion` text DEFAULT NULL,
  `alergias` text DEFAULT NULL,
  `asegurado` varchar(1) DEFAULT 'n',
  PRIMARY KEY (`nip`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

--
-- Dumping data for table `pempleado`
--

INSERT INTO `pempleado` VALUES (1,NULL,NULL,'ADMINISTRADOR',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'0-0',NULL,NULL,'n'),(2,NULL,'NOOES590902','NORIEGA OLIVERA EVIR','NOOES590902HCSRLV11','NOOES590902HCSRLV11','1959-09-02','SOLTERA(O)','HOMBRE','','','',NULL,1,1,8,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(3,NULL,'GOZM8702067U4','GONZALEZ ZETINA MANUEL','GOZM870206HVZNTN02','','1987-02-06','SOLTERA(O)','HOMBRE','','','',NULL,1,1,8,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(4,NULL,'','CRUZ MORALES JOSE ANTONIO','','','1994-05-04','SOLTERA(O)','HOMBRE','','','',NULL,1,1,8,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(5,NULL,'ROMN041016','RODRIGUEZ MONTES NESTOR EDUARDO','ROMN041016HCSDNSA8','24160490504','2004-10-16','CASADA(O)','HOMBRE','RMeduYT04@gmail.com','','9181143142',NULL,1,1,9,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','','','n'),(6,NULL,'','RIOS MORALES JESUS','','','1989-09-05','SOLTERA(O)','MUJER','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(7,NULL,'','HERNANDEZ KENETH JOEL','','','1999-02-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(8,NULL,'OAEJ020814JR3','OCAñA ESCOBAR JUAN MANUEL','OAEJ020814HCSCSNA2','','2002-08-14','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(9,NULL,'HEOA980830HG1','HERRERA OCHOA ALAN DAVID','HEOA980830HCSRCL03','','1998-08-30','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(10,NULL,'SORL920808UY5','SOLIS REYES LUIS IVAN','SORL920808HCSLYS02','','1992-08-08','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(11,NULL,'AUJM940425PG2','AGUILAR JIMENEZ MARCOS','AUJM940425HCSGMR06','','1994-04-25','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(12,NULL,'AERL860519DS7','ARREOLA ROMERO JOSé LUIS','AERL860519HCSRMS04','','1986-05-19','UNION LIBRE','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(13,NULL,'MOPY010825HCR','MORALES PALOMEQUE YONI','MOPY010825HCSRLNA5','60170101202','2001-08-25','UNION LIBRE','HOMBRE','yonielnayo01@gmail.com','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(14,NULL,'RASL790204TBA','RAMIREZ SANCHEZ LORENZO','RASL790204MCSMNRO4','3187904564','1979-04-02','SOLTERA(O)','HOMBRE','LORENZORAMIREZ042@GMAIL.COM','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(15,NULL,'LEZJ011228','DE LEON ZEPEDA JESUS NOLBERTO','LEZJ011228HCSNPSA4','','2021-12-28','CASADA(O)','HOMBRE','DELEONZEPEDA@GMAIL.COM','','771 235 24 83',NULL,1,1,2,NULL,NULL,'O POSITIVO','PRIMARIA','undefined-undefined','CRISTIANO','NINGUNA','n'),(16,NULL,'VADE941111A81','VAZQUEZ DURáN EDIVER','VADE941111HCSZRD01','49159447033','1994-11-11','CASADA(O)','HOMBRE','EDIVERDURAN66@GMAIL.COM','','966 218 1614',NULL,1,1,2,NULL,NULL,'B POSITIVO','PRIMARIA','undefined-undefined','CATOLICO','NINGUNA','n'),(17,NULL,'PEVT790718A30','PERES VELASQUES TEREZO ','PEVT790718HCSRLR06','33987932416','1979-07-18','SOLTERA(O)','HOMBRE','LLERRIVELAZQUEZ@GMAIL.COM','','812 921 9437',NULL,1,1,2,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','NINGUNA','n'),(18,NULL,'ROVJ9209026R2','RODRíGUEZ VáZQUEZ JUAN ALBERTO ','ROVJ920902HCSD2N03','33119255801','1992-09-02','CASADA(O)','HOMBRE','MARTINSANTIAGO545@OUTLOOK.COM','','961 702 5283',NULL,1,1,2,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','NINGUNA','n'),(19,NULL,'SARP880310541','SALAZAR RUIZ PEDRO NISAIN ','SARP880310HCSL2D09','71088822367','1988-03-10','SOLTERA(O)','HOMBRE','','','962 422 2046',NULL,1,1,2,NULL,NULL,'O POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(20,NULL,'OOAI020831','OCHOA ALBORES IRVING DANIEL','OOAI020831HARCLRA1','','2002-08-31','SOLTERA(O)','HOMBRE','DOOCHOA0820@gmail.com','','9611821511',NULL,1,1,1,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','NINGUNA ','NINGUNA','n'),(21,NULL,'VEMG740525747','VELAZQUEZ MOLINA GREGORIO URBANO','VEMG740525HCSLLR07','','1974-05-25','UNION LIBRE','HOMBRE','GV22535@gmail.com ','9612401630','9611616081',NULL,1,1,1,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','NINGUNA ','NINGUNA','n'),(22,NULL,'EIRA950706LQ1','ESPINOSA RABELO ADAN DE JESUS','GIRA950706HCSSBD00','','1985-04-01','UNION LIBRE','HOMBRE','','','',NULL,1,1,1,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA ','','n'),(23,NULL,'LATE901213','LARA TRINIDAD ERICK ALFREDO','LATE901213MCSRRR05','71099028871','1990-12-13','CASADA(O)','HOMBRE','','9613626106','9613626106',NULL,1,1,1,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(24,NULL,'CUFA751222','CRUZ FLORES JOSE ALFREDO','CUFA751222HCSRLL01','71967501637','1975-12-22','UNION LIBRE','HOMBRE','','9614680206','9616545550',NULL,1,1,1,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','NINGUNA ','NINGUNA','n'),(25,NULL,'SAAA050417','SANCHEZ ALVAREZ ALAN EDUARDO','SAAA050417HESNLLA0','','2005-04-17','SOLTERA(O)','HOMBRE','','9614550019','9612620605',NULL,1,1,1,NULL,NULL,'B POSITIVO','SECUNDARIA','undefined-undefined','CATOLICA','NINGUNA','n'),(26,NULL,'HEZD021224','HERNANDEZ ZARATE DIEGO DE JESúS','HEZD021224HCSRRG','','2002-12-24','SOLTERA(O)','HOMBRE','Diego12439@gmail.com','9614460487','2283749697',NULL,1,1,1,NULL,NULL,'','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(27,NULL,'','PEREZ GOMEZ RODIVER','','','1960-05-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,1,NULL,NULL,'','NINGUNO','undefined-undefined','CATOLICO','','n'),(28,NULL,'AUPO981209QY8','ARGUETA PEREZ OSWALDO','AUPO981209HCSRRS04','15169851191','1998-12-09','SOLTERA(O)','HOMBRE','','','',NULL,1,1,7,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(29,NULL,'ROGA8406046D4','ROBLERO GONZALEZ ABIEL','ROGA840604HCSBNB05','02208437166','1984-06-04','CASADA(O)','HOMBRE','','','9641130410',NULL,1,1,9,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(30,NULL,'NAEB791005MB2','NAVARRO ESCALANTE BENJAMIN','NAEB791005HCSVSN06','24067904722','1979-10-05','UNION LIBRE','HOMBRE','','','',NULL,1,1,9,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(31,NULL,'ZARM951010JJ9','ZAVALA RODRIGUEZ MARCO ANTONIO','ZARM951010HCSVDR01','05159559490','1995-10-10','UNION LIBRE','HOMBRE','','9613028983','9181253670',NULL,1,1,9,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(32,NULL,'SOCA990930JB0','SOLIS CANIZALEZ JOSE ANTONIO','SOCA990930HCSLNN09','51169987651','1999-09-30','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(33,NULL,'NIVL7704283EA','NIñO VERA JOSE LUIS','NIVL770428HCSXRS05','71977703827','1977-04-28','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(34,NULL,'HECI900330A29','HERNANDEZ CAL Y MAYOR IDAID','HECI900330HCSRLD08','26149013091','1990-03-30','CASADA(O)','HOMBRE','','918-100-38-91','918-217-00-82',NULL,1,1,5,NULL,NULL,'O POSITIVO','PRIMARIA','undefined-undefined','CATOLICO','','n'),(35,NULL,'OAVI8611075N0','OVANDO VILLALOBOS JOSE IVAN','OAVI861107HCSVLV08','71088625547','1986-11-07','CASADA(O)','HOMBRE','','','',NULL,1,1,5,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(36,NULL,'SAOI940819DI3','DE LOS SANTOS ORTIZ ISMAEL','SAOI940819HCSNRS03','21139437277','1994-08-19','CASADA(O)','HOMBRE','DELOSSANTOSISMAEL299@GMAI.COM','','966 105 87 04',NULL,1,1,2,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(37,NULL,'HEAV931021R56','HERNANDEZ AGUILAR VICTOR ALI','HEAV931021HCSRGC06','17149340931','1993-10-21','CASADA(O)','HOMBRE','ALI00CARMINE@GMAIL.COM','','961 263 9839',NULL,1,1,2,NULL,NULL,'O POSITIVO','PREPARATORIA','undefined-undefined','','','n'),(38,NULL,'LONA950216LC2','LOPEZ NUñEZ ADALBERTO DE JESUS','LONA950216HCSPXD03','38169582574','1995-02-16','UNION LIBRE','HOMBRE','ADAL_JESUS@OUTLOOK.COM','','966 115 65 13',NULL,1,1,2,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','','','n'),(39,NULL,'CISE751002TX4','CHIRINO SIMON EDUARDO','CISE751002HCSHMD05','01168247730','1955-01-03','SOLTERA(O)','HOMBRE','','','',NULL,1,1,2,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(40,NULL,'FUMM920211237','FUENTES MARTINEZ JOSE MIGUEL','FUMM920211HCSNRG09','38159268879','1992-02-11','UNION LIBRE','HOMBRE','JOSEFUENTES623@GMAIL.COM','','966 665 1446',NULL,1,1,2,NULL,NULL,'O POSITIVO','NINGUNO','undefined-undefined','','','n'),(41,NULL,'FICC7001299W9','FRIAS CRUZ CARLOS','FICC700129HCSRRR02','71877015058','1970-01-29','CASADA(O)','HOMBRE','','9613872242','9611685922',NULL,1,1,1,NULL,NULL,'','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(42,NULL,'SAPF6905261W7','SANCHEZ PEREZ FERNANDO','SAPF690526HCSNRR02','71886916544','1969-05-26','CASADA(O)','HOMBRE','','9616268232','9611118528',NULL,1,1,1,NULL,NULL,'O POSITIVO ','SECUNDARIA','undefined-undefined','CATOLICA','','n'),(43,NULL,'SATA891208MC9','SANCHEZ TAMAYO ANGEL DE JESUS','SATA891208HCSNMN07','3158995211','1989-12-08','CASADA(O)','HOMBRE','Angel189493@gmail.com ','9613432430','9614016441',NULL,1,1,1,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','NINGUNA','','n'),(44,NULL,'SAGJ931211N96','SANCHEZ GONZALEZ JULIO CESAR','SAGJ931211HCSMNL05','71129315090','1993-12-11','CASADA(O)','HOMBRE','','','9613323016',NULL,1,1,1,NULL,NULL,'0 POSITIVO','LICENCIATURA','undefined-undefined','NINGUNA','','n'),(45,NULL,'TECJ8101047H8','TECO CRUZ JUAN DE DIOS','TECJ8101044CSCRN08','71998103619','1981-01-04','CASADA(O)','HOMBRE','juandediostecocruz@gmail.com','9612900758','9612900758',NULL,1,1,1,NULL,NULL,'O POSITIVO','PRIMARIA','undefined-undefined','NINGUNA','','n'),(46,NULL,'PEJR611116M44','PERES JOSE RUBEN','PEJR611116HCSRSB03','71006104039','1961-11-16','CASADA(O)','HOMBRE','','','',NULL,1,1,1,NULL,NULL,'','PRIMARIA','undefined-undefined','NINGUNA','','n'),(47,NULL,'MOMJ010404','MOLINA MAZA JOSUE','MOMJ010404HCSLZSA9','','2001-04-04','SOLTERA(O)','MUJER','JOSUEMMAZA@GMAIL.COM','961 317 3011','961 317 3011',NULL,1,1,10,NULL,NULL,'A POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','','n'),(48,NULL,'','GORDILLO FLORES DAMARIS RUBI','','','1990-01-01','SOLTERA(O)','MUJER','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(49,NULL,'','DE PAZ ROBLERO BLANCA ISELA','','','2000-05-01','SOLTERA(O)','MUJER','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(50,NULL,'VEZN930812ME4','VEGA ZAMBRANO NORA ISELA','VEZN930812MCSGMR08','','1993-08-12','SOLTERA(O)','MUJER','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(51,NULL,'MOLD941113HJ9','MONTES LOPEZ DIEGO ALBERTO','MOLD941113HCSNPG09','','1994-11-13','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(52,NULL,'','ESPINOSA VALENCIA NAYELI','','','2000-08-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(53,NULL,'','TOSCANO MARTINEZ JOSé ANGEL','','','1998-09-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(54,NULL,'','ALEGRIA ORTIZ ANGEL','','','1997-02-09','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(55,NULL,'COGA810908C44','CHONG GEORGE ADRIAN ALBERTO','COGA810908HDFHRD04','','1981-09-08','CASADA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(56,NULL,'MECV950510','MERIDA CUETO VIVIANA JANETH','MECV950510MCSRTV08','73169563126','1995-05-10','DIVORCIADA(O)','MUJER','','918-159-5326','918-118-1876',NULL,1,1,3,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(57,NULL,'MOUVD980728','MORALES VELAZQUEZ DANIEL','MOUVD980728HCSRLN06','37169856186','1998-07-28','SOLTERA(O)','HOMBRE','','918 119 3064','918-120-1674',NULL,1,1,3,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(58,NULL,'','PEñA HERNANDEZ JUAN CARLOS','','','1990-06-26','CASADA(O)','HOMBRE','','','',NULL,1,1,3,NULL,NULL,'','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(59,NULL,'CUFE640915','CRUZ FERNANDEZ EDILBERTO','CUFE640915HCSRRD02','67816460900','1964-09-15','CASADA(O)','HOMBRE','','','918-126-2962',NULL,1,1,3,NULL,NULL,'AB POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(60,NULL,'U0GG940322','ULLOA GUTIéRREZ GILBERTO JAVIER','U0GG940322H65LTL00','71129417904','1994-03-22','SOLTERA(O)','HOMBRE','','','918-101-6609',NULL,1,1,3,NULL,NULL,'AB POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(61,NULL,'LOMJ970131','LORENZANA MARTINEZ JESUS NEVIT ','LOMJ970131HMCRRS02','86169794103','1997-01-31','SOLTERA(O)','HOMBRE','','961-240-8698','961-204-6959',NULL,1,1,3,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(62,NULL,'MORS981106','MONTES RUIZ SERGIO','MORS981106HCSNZR02','37169848068','1998-11-06','SOLTERA(O)','HOMBRE','','918-104-3111','918-107-1421',NULL,1,1,3,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(63,NULL,'AEAE960927','ALEGRíA ARIAS ERWIN ADOLFO','AEAE960927HCSLRR01','18179654085','1996-09-27','CASADA(O)','HOMBRE','','918-648-2377','918-159-8554',NULL,1,1,3,NULL,NULL,'AB POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(64,NULL,'','GONZALEZ PEREZ RICARDO','','','1990-08-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,3,NULL,NULL,'','NINGUNO','undefined-undefined','CATOLICO','','n'),(65,NULL,'','CASTRO CAMPERO ENOC','','','1960-08-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,3,NULL,NULL,'','NINGUNO','undefined-undefined','CATOLICO','','n'),(66,NULL,'MELM980820','MENDEZ LOPEZ MIRIAM YAMILETH','MELM980820MOCNPR06','34169852166','1998-08-20','SOLTERA(O)','MUJER','','287-889-2623','2818-69-9831',NULL,1,1,3,NULL,NULL,'AB POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(67,NULL,'CAVA941225','CABRERA VELASCO ANGEL DE JESUS','CAVA941225HCSBLN03','','1994-12-25','UNION LIBRE','HOMBRE','','918-137-2574','918-119-4795',NULL,1,1,3,NULL,NULL,'AB POSITIVO','PRIMARIA','undefined-undefined','CATOLICO','','n'),(68,NULL,'CUEM000130','CRUZ ESCOBAR JOSE MAURICIO','CUEM000130HCSRSRA8','23160050433','2000-01-30','UNION LIBRE','HOMBRE','jo244dc@gmail.com','966-712-9010','961-717-0008',NULL,1,1,3,NULL,NULL,'AB POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(69,NULL,'NAEA840430','NATAREN ESCOBAR ALBERTO','NAEA840430HCSTSL01','7107841465','1984-04-30','CASADA(O)','HOMBRE','','918-648-7201','918-110-9644',NULL,1,1,3,NULL,NULL,'AB POSITIVO','PRIMARIA','undefined-undefined','CATOLICO','','n'),(70,NULL,'VARM011123F2A','VAZQUEZ RAMON MISAEL ANTONIO','VARMO11123HCSZMSA4',' 7620010138','2001-11-23','SOLTERA(O)','HOMBRE','michavazquez2323@gmail.com','','',NULL,1,1,4,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(71,NULL,'DULY980811QW3','DUQUE DE LEON YURI LIZBETH','DULY980811MCSQNR06','75169831015','1998-08-11','UNION LIBRE','MUJER','yuriduque151@gmail.com','','',NULL,1,1,4,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(72,NULL,'ROCE030310FN4','RODRIGUEZ CRUZ EDGAR MARIN','ROCE030310HCSDRDA71','24160358883','2003-03-10','SOLTERA(O)','MUJER','edgar41576@gmail.com','','',NULL,1,1,4,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(73,NULL,'TITA9805113L5','TRINIDAD TRINIDAD ADRIANA LISETTE','TITA980511MCSRRD05','45169883266','1998-05-11','SOLTERA(O)','MUJER','ADRIANALISSET98@HOTMAILCOM','966  136 29 77','966 136 29 77',NULL,1,1,2,NULL,NULL,'A POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','','n'),(74,NULL,'HEGA001227','HERNANDEZ GOMEZ ALEJANDRA GUADALUPE','HEGA001227MCSRMLA8','81160071122','2002-12-27','SOLTERA(O)','MUJER','alejandraguadalupehernandezgom@gmail.com','9613904438','9613035697',NULL,1,1,1,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','','n'),(75,NULL,'TOPF020819PL2','TORRES PEREZ FATIMA ELIZABETH','TOPF020819MCSRRTA3','18160289171','2002-08-19','DIVORCIADA(O)','MUJER','fatimaelizabethtorrezperez@gmail.com','9612551026','9612179119',NULL,1,1,1,NULL,NULL,'B POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','','n'),(76,NULL,'GADC9407238G1','GALDAMEZ DIAZ CARLOS ALBERTO','GADC940723HCSLZR05','35169460405','1994-07-23','SOLTERA(O)','HOMBRE','caemm121116@gmail.com','9612989051','9614399166',NULL,1,1,1,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','NINGUNA','','n'),(77,NULL,'PEGK030906204','PEREZ GOMEZ KARIME GUADALUPE','PEGK030906MCSRMRA0','26170375344','2003-09-06','SOLTERA(O)','MUJER','Karimeguadalupeperezgomez@gmail.com','9611924925','9613355564',NULL,1,1,1,NULL,NULL,'O POSITIVO','PREPARATORIA','undefined-undefined','NINGUNA','','n'),(78,NULL,'LOPA740706AB5','LOZANO PALOMEQUE ALBERTO','LOPA740706HCSZLL09','71897402054','1974-07-06','SOLTERA(O)','HOMBRE','','','',NULL,1,1,8,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(79,NULL,'FADA8306139G4','FRANCISCO DOMINGUEZ ANTONIO','FADA830613HCSRMN07','71078313054','1983-06-13','SOLTERA(O)','HOMBRE','','','',NULL,1,1,7,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(80,NULL,'PEBM7610315K6','PEREZ BALLINAS MIGUEL ANGEL','PEBM761031HCSRLG05','71047602678','1976-10-31','CASADA(O)','HOMBRE','angelballinas31@gmail.com','961 201 11 00','',NULL,1,1,10,NULL,NULL,'B POSITIVO','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(81,NULL,'GAVL960713J41','GARCIA VARGAS LUIS HEBET','GAVL960713HCSRRS04','24169678513','1996-07-13','SOLTERA(O)','HOMBRE','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(82,NULL,'GATE970808F82','GARCIA TOLEDO ERICK FABIAN','GATE970808HCSRLR03','74169760480','1997-08-08','SOLTERA(O)','HOMBRE','erickgarciaconta@hotmail.com','9614521126','19645211262',NULL,1,1,10,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','NINGUNA','PENICILINA','n'),(83,NULL,'RUCA720621QX8','RUIZ CHACON MARIA DE LOS ANGELES','RUCA720621MCSZHN07','71957233506','1972-06-21','SOLTERA(O)','MUJER','angeles.ruiz21@msn.com','9611119916','9611119916',NULL,1,1,10,NULL,NULL,'O POSITIVO','POSGRADO','undefined-undefined','CATOLICA','','n'),(84,NULL,'MAPN850917D73','MARTINEZ PINEDA NAHUM NAPOLEON','MAPN850917HCSRNH07','03208540421','1985-09-17','SOLTERA(O)','HOMBRE','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(85,NULL,'MAPE870114EZA','MARTINEZ PINEDA ERNESTO ALONSO','MAPE870114HCSRNR08','02208768966    ','1987-01-14','SOLTERA(O)','HOMBRE','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(86,NULL,'MAPC9510133T8','MARTINEZ PINEDA CRISTINA GUADALUPE','MAPC951013MCSRNR08','05209562833    ','1995-10-13','SOLTERA(O)','MUJER','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(87,NULL,'SICY991120NU4','SILVA CUEVAS YAIR','SICY991120HTCLVR04','12139924869    ','1999-11-20','SOLTERA(O)','HOMBRE','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(88,NULL,'TOGO760703TW4','TOALA GENOVEZ OEL NELLY','TOGO760703HCSLNL00','71967640088    ','1976-07-03','SOLTERA(O)','HOMBRE','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(89,NULL,'OETJ771216SI6','ORTEGA TOVAR JULIO CESAR','OETJ771216HCSRVL05','71997702197    ','1977-12-16','SOLTERA(O)','HOMBRE','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(90,NULL,'HESN870226T75','HERRERA SALINAS NANCY CAROLINA','HESN870226MCSRLN01','71058708042','1987-02-26','DIVORCIADA(O)','MUJER','nchsalinas@gmail.com','5564947339','5564947339',NULL,1,1,10,NULL,NULL,'A POSITIVO','LICENCIATURA','undefined-undefined','CRISTIANA','PENICILINA, SULFAS, FENAZOPIRIDINA','n'),(91,NULL,'MOAA7106104U8','MOLINA ALBORES ALFRED','MOAA710610HCSLLL06','71907148945 ','1971-06-10','CASADA(O)','HOMBRE','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(92,NULL,'BALJ820308KL0','BRAVO LOPEZ JUANA DE DIOS','BALJ820308MCSRPN01','01168247730    ','1982-03-08','CASADA(O)','MUJER','','','',NULL,1,1,10,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(93,NULL,'SAGL840713NT2','SAMAYOA GALVEZ LOURDES DEL SOCORRO','SGL840713MCSMLR07','71058407124','1984-05-13','SOLTERA(O)','MUJER','lourdessamayoa@hotmail.com','961 267 9019','9621569207',NULL,1,1,10,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','','','n'),(94,NULL,'GOLM901005DB5','GONZALEZ LOPEZ MIGUEL','GOLM901005HCSNPG07','71099000565','1990-10-05','UNION LIBRE','HOMBRE','ing.miguelgl@gmail.com','','',NULL,1,1,10,NULL,NULL,'','LICENCIATURA','undefined-undefined','','','n'),(95,NULL,'PIMJ771004D77 ','PINEDA MARTINEZ JACOBO ABRAHAM','PIMJ771004HVZNRC03 ','71967707978','1977-10-04','CASADA(O)','HOMBRE','afgano200@hotmail.com','9622151149','9181040382',NULL,1,1,9,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(96,NULL,'RAMG650523C34','RAMIREZ MARTINEZ GONZALO','RAMG650523HCSMRN08','01856503501    ','1965-05-23','SOLTERA(O)','HOMBRE','','','',NULL,1,1,9,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(97,NULL,'GOPK940921TY7 ','GONZALEZ PEREZ KAMBLI','GOPK940921MCSNRM08','68169413173','1994-09-21','CASADA(O)','MUJER','kambligonzalez@gmail.com','','9613356202',NULL,1,1,9,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','','n'),(98,NULL,'LOMF950329MA7','LOPEZ MINA FRANCISCO ALFREDO','LOMF950329HCSPNR05 ','94109555949','1995-03-29','UNION LIBRE','HOMBRE','franciscoalfredolopezmina@gmail.com','9181191398','9181060911',NULL,1,1,9,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(99,NULL,'REMC970405EG6 ','REYNOSO MORALES CARLOS ALBERTO','REMC970405HCSYRR05 ','59159796693','1997-04-05','UNION LIBRE','HOMBRE','reynosomoracar05@gmail.com','9181073609','9181133596',NULL,1,1,9,NULL,NULL,'A POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(100,NULL,'CUFR751116GB0','CRUZ FLORES RAMON','CUFR751116HCSRLM03','71007504492','1975-11-16','CASADA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','CATOLICO','','n'),(101,NULL,'LOTR7008294Q2','LOPEZ TOLEDO ROSA','LOTR700829MCSPLS05','71887001361','1970-08-28','VIUDA(O)','MUJER','','','656-862-3731',NULL,1,1,3,NULL,NULL,'AB POSITIVO','LICENCIATURA','undefined-undefined','','','n'),(102,NULL,'MOUL9704271M3','MORENO URREA LUZ PAOLA','MOUL970427MASRRZ04','58169734157','1997-04-27','CASADA(O)','MUJER','','918-122-6648','966-108-9561',NULL,1,1,3,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','','','n'),(103,NULL,'SAPJ790811SP5','SANCHEZ DEL PORTE JAVIER','SAPJ790811HCSNRV08','9671574171','1969-08-11','SOLTERA(O)','HOMBRE','','918-694-8711','967-157-4171',NULL,1,1,3,NULL,NULL,'O POSITIVO','PRIMARIA','undefined-undefined','','','n'),(104,NULL,'RACM6801213W7','RAMON CELAYA MARTIN','RACM680121HCSMLR04','71896806131','1968-01-01','CASADA(O)','HOMBRE','','','961-700-6128',NULL,1,1,3,NULL,NULL,'O POSITIVO','PRIMARIA','undefined-undefined','','','n'),(105,NULL,'GOMJ9312141P4','GOMEZ MEDINA JUAN ANTONIO','GOMJ931214HCSMDN00','2209372768','1993-12-14','CASADA(O)','HOMBRE','','961-245-4284','918-122-4518',NULL,1,1,3,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','','','n'),(106,NULL,'RETS960913G16','RECINOS TORRES SANTIAGO EDUARDO','RETS960913HCSCRN08','38169642279','1996-09-13','SOLTERA(O)','HOMBRE','','','918 119-3956',NULL,1,1,3,NULL,NULL,'','SECUNDARIA','undefined-undefined','','','n'),(107,NULL,'SONC930211RI2','SOLIS NATAREN CRISTIAN ALEXIS','SONC930211HCSLTR06','71139347984','1993-02-11','SOLTERA(O)','HOMBRE','','','',NULL,1,1,3,NULL,NULL,'A POSITIVO','SECUNDARIA','undefined-undefined','','','n'),(108,NULL,'CUHJ830810B53','CRUZ HERNANDEZ JORGE ALBERTO','CUHJ830810CSRRR01','71978304781','1983-08-10','UNION LIBRE','HOMBRE','jolbertocruz00@gmail.com','','',NULL,1,1,5,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(109,NULL,'CULM990929PC8','DE LA CRUZ LOPEZ MONICA','CULM990929MCSRPN01','95169966587','1999-09-29','CASADA(O)','MUJER','monicalopez2894@gmail.com','','',NULL,1,1,5,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(110,NULL,'AOSP900809RN5','ALONSO SANCHEZ PAOLA','AOSP900809MCSLNL02','17159089899','1990-08-09','UNION LIBRE','MUJER','paolaalonsosanchez.1990@gmail.com','918-120-11-55','918-113-62-45',NULL,1,1,5,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','AMPICILINA','n'),(111,NULL,'CUOA000603BW6','CRUZ ORTIZ ANTONIO DE JESUS','CUOA000603HCSRRNA9','78160085623','2000-06-03','SOLTERA(O)','HOMBRE','antonioortiz698675@gmail.com','918-124-14-97','918-111-05-24',NULL,1,1,5,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICA','','n'),(112,NULL,'MALA030903FK1','MARTINEZ LOPEZ ABRAHAM ANTONIO','MALA030903HCSRPBA2','16160392375','2003-09-03','SOLTERA(O)','HOMBRE','martinezlopezabrahamantonio@gmail.com','918-100-74-29','918-125-36-69',NULL,1,1,5,NULL,NULL,'O POSITIVO','PREPARATORIA','undefined-undefined','CATOLICA','','n'),(113,NULL,'AUGI770601JX2','AGUILAR GARCIA IRMA DOLORES','AUGI770601MCSGRR03','71067702309','1977-06-01','SOLTERA(O)','MUJER','','','966 118 3497',NULL,1,1,2,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','POLVO','n'),(114,NULL,'LOAS880312SC3','LOPEZ ARREOLA MARIA SIRENIA','LOAS880312MCSPRR05','4168851691','1988-03-12','SOLTERA(O)','MUJER','SIRENIA_088HOTMAIL.COM','','966 106 3451',NULL,1,1,2,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','','n'),(115,NULL,'SAPK961115J97','SANCHO PALOMO KARLA LETICIA','SAPK961115MCSNLR03','4016967743','1996-11-15','SOLTERA(O)','MUJER','','','966 113 7677',NULL,1,1,2,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','','n'),(116,NULL,'GUHG960617M75','GUTIERREZ HERNANDEZ GERSON ABRAHAM','GUHG960617HCSTRR00','57149649477','1997-06-17','SOLTERA(O)','HOMBRE','GERSONGUTIERREZ@HOTMAIL.COM','','966 115 66 83',NULL,1,1,2,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(117,NULL,'ZALJ970906I5A','ZAVALA DE LUCIO JAQUELINE','ZALJ970906MCSVCQ08','7139752278','1997-11-06','CASADA(O)','MUJER','ZAVALADELUCIOJAQUELINE@GMAIL.COM','','9661090129',NULL,1,1,2,NULL,NULL,'O POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(118,NULL,'TOVY951102IX5','VASQUES TORRES MARIA YENI','TOVY951102MCSRSN07','86169544508','1995-11-02','CASADA(O)','MUJER','TONALA','','966 112 82 38',NULL,1,1,2,NULL,NULL,'A POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(119,NULL,'OICJ831105P83','ORTIZ CUETO JORGE ALBERTO','OICJ831105HCSRTR00','71008312184','1983-11-05','CASADA(O)','HOMBRE','ORTIZCUETO@HOTMAIL.COM','','966 105 24 76',NULL,1,1,2,NULL,NULL,'AB POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(120,NULL,'MOPM761022721','MORENO PEñA MARIO ALBERTO','MOPM761022HCSRXR03','33997622668','1976-10-22','UNION LIBRE','HOMBRE','','','966 109 89 00',NULL,1,1,2,NULL,NULL,'O POSITIVO','NINGUNO','undefined-undefined','CATOLICO','','n'),(121,NULL,'SALB920709JB8','SAMAYOA LOPEZ BERNARDO DANIEL','SALB920709HCSMPR05','71129243169','1993-07-09','SOLTERA(O)','HOMBRE','caleepkbra20@gmail.com','961337672','9613037672',NULL,1,1,1,NULL,NULL,'O POSITIVO','PRIMARIA','undefined-undefined','','NINGUNA ','n'),(122,NULL,'AAVC630512IZA','ALCAZAR VELAZQUEZ CONRADO','AAVC630512HCSLLN00','71026304528','1963-05-12','CASADA(O)','HOMBRE','alcazar1782conrado@gmail.com','9613559124','9611321427',NULL,1,1,1,NULL,NULL,'A POSITIVO','NINGUNO','undefined-undefined','CRISTIANA','','n'),(123,NULL,'RORM700155D4','ROBLERO ROBLERO MAURO OVENTINO','RORM700115HCSBBR02','67867052283','1970-01-15','CASADA(O)','HOMBRE','','9614364835','9614364835',NULL,1,1,1,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CRISTIANA','','n'),(124,NULL,'HEPL940503969','HERNANDEZ PALACIOS LUIS SANTIAGO','HELP940503HCSRLS00','7112942794','1994-05-03','SOLTERA(O)','HOMBRE','Santiagoh.palacios@hotmail.com','9611596142','9611938266',NULL,1,1,1,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(125,NULL,'JIPM970710F44','JIJON PEREZ MARIO ALBERTO','JIPM970710HCSJRR07','5149701194','1997-07-10','UNION LIBRE','HOMBRE','Mariojijon470@gmail.com','9617740921','9612090858',NULL,1,1,1,NULL,NULL,'A POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(126,NULL,'DOZL00093OC83','DOMINGUEZ ZAPOTECO LUIS ANGEL','DOZL000930HCSMPSA6','30190036613','2002-09-30','SOLTERA(O)','HOMBRE','luisangeldz28@gmail.com','9613234435','9613234435',NULL,1,1,1,NULL,NULL,'O POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(127,NULL,'GAGH800214AEA','HARVELL GARCìA GONZàLEZ','GAGH800214HCSRNR01','71958037112','1980-02-14','CASADA(O)','HOMBRE','harvellgg@hotmail.com','9616156239','9612518201',NULL,1,1,10,NULL,NULL,'O POSITIVO','DOCTORADO','undefined-undefined','CATOLICO','','n');

--
-- Table structure for table `pempleado_subida`
--

CREATE TABLE `pempleado_subida` (
  `codigoempleado` varchar(100) DEFAULT NULL,
  `nombre` varchar(500) DEFAULT NULL,
  `rfc` varchar(100) DEFAULT NULL,
  `curp` varchar(100) DEFAULT NULL,
  `nss` varchar(100) DEFAULT NULL,
  `correo` varchar(100) DEFAULT NULL,
  `telefono` varchar(100) DEFAULT NULL,
  `celular` varchar(100) DEFAULT NULL,
  `fechanacimiento` varchar(100) DEFAULT NULL,
  `estadocivil` varchar(100) DEFAULT NULL,
  `sexo` varchar(100) DEFAULT NULL,
  `calle` varchar(200) DEFAULT NULL,
  `numeroexterios` varchar(100) DEFAULT NULL,
  `numerointerior` varchar(100) DEFAULT NULL,
  `colonia` varchar(100) DEFAULT NULL,
  `codigopostal` varchar(100) DEFAULT NULL,
  `municipio` varchar(100) DEFAULT NULL,
  `estado` varchar(100) DEFAULT NULL,
  `sucursal` varchar(100) DEFAULT NULL,
  `departamento` varchar(100) DEFAULT NULL,
  `puesto` varchar(100) DEFAULT NULL,
  `tipocontrato` varchar(200) DEFAULT NULL,
  `tiempocontrato` varchar(200) DEFAULT NULL,
  `tipojornada` varchar(200) DEFAULT NULL,
  `tiponomina` varchar(100) DEFAULT NULL,
  `fechainicio` varchar(100) DEFAULT NULL,
  `periodicidad` varchar(100) DEFAULT NULL,
  `banco` varchar(100) DEFAULT NULL,
  `cuentabancaria` varchar(100) DEFAULT NULL,
  `salariodiariofiscal` varchar(100) DEFAULT NULL,
  `salariodiarionofiscal` varchar(100) DEFAULT NULL,
  `salariobase` varchar(100) DEFAULT NULL,
  `salariointegrado` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pempleado_subida`
--


--
-- Table structure for table `pempleadofaltas`
--

CREATE TABLE `pempleadofaltas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idempleado` int(11) DEFAULT NULL,
  `faltas` int(11) DEFAULT NULL,
  `fecini` date DEFAULT NULL,
  `fecfin` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pempleadofaltas`
--


--
-- Table structure for table `pevaluacion_socioeconomico`
--

CREATE TABLE `pevaluacion_socioeconomico` (
  `idpregunta` int(11) NOT NULL,
  `idsocioeconomico` int(11) NOT NULL,
  `respuesta` text DEFAULT NULL,
  UNIQUE KEY `idpregunta` (`idpregunta`,`idsocioeconomico`),
  KEY `fk_pregunta_socioeconomico_pevaluacion_idx` (`idpregunta`),
  KEY `fk_psocioeconomico_pevaluacion_idx` (`idsocioeconomico`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pevaluacion_socioeconomico`
--


--
-- Table structure for table `pformatos`
--

CREATE TABLE `pformatos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idformato` int(11) DEFAULT NULL,
  `texto` text DEFAULT NULL,
  `impresion` int(11) DEFAULT 1 COMMENT '1:Carta 2:Ticket',
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pformatos`
--

INSERT INTO `pformatos` VALUES (1,1,'[BLOB]',1,1);

--
-- Table structure for table `phorasextra`
--

CREATE TABLE `phorasextra` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipohoras` char(5) DEFAULT NULL,
  `dias` int(11) DEFAULT NULL,
  `horasextra` int(11) DEFAULT NULL,
  `importepagado` decimal(9,2) DEFAULT NULL,
  `gravado` decimal(9,2) DEFAULT NULL,
  `exento` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `phorasextra`
--


--
-- Table structure for table `phorasextra_nf`
--

CREATE TABLE `phorasextra_nf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipohoras` char(5) DEFAULT NULL,
  `dias` int(11) DEFAULT NULL,
  `horasextra` int(11) DEFAULT NULL,
  `importepagado` decimal(9,2) DEFAULT NULL,
  `gravado` decimal(9,2) DEFAULT NULL,
  `exento` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `phorasextra_nf`
--


--
-- Table structure for table `pincapacidades`
--

CREATE TABLE `pincapacidades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipoincapacidad` char(5) DEFAULT NULL,
  `dias` int(11) DEFAULT NULL,
  `importe` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pincapacidades`
--


--
-- Table structure for table `pincapacidades_nf`
--

CREATE TABLE `pincapacidades_nf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipoincapacidad` char(5) DEFAULT NULL,
  `dias` int(11) DEFAULT NULL,
  `importe` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pincapacidades_nf`
--


--
-- Table structure for table `pjubilaciones`
--

CREATE TABLE `pjubilaciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipopercepcion` char(5) DEFAULT NULL,
  `unaexhibicion` decimal(9,2) DEFAULT NULL,
  `parcialidades` decimal(9,2) DEFAULT NULL,
  `diario` decimal(9,2) DEFAULT NULL,
  `acumulable` decimal(9,2) DEFAULT NULL,
  `noacumulable` decimal(9,2) DEFAULT NULL,
  `gravado` decimal(9,2) DEFAULT NULL,
  `exento` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pjubilaciones`
--


--
-- Table structure for table `pjubilaciones_nf`
--

CREATE TABLE `pjubilaciones_nf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipopercepcion` char(5) DEFAULT NULL,
  `unaexhibicion` decimal(9,2) DEFAULT NULL,
  `parcialidades` decimal(9,2) DEFAULT NULL,
  `diario` decimal(9,2) DEFAULT NULL,
  `acumulable` decimal(9,2) DEFAULT NULL,
  `noacumulable` decimal(9,2) DEFAULT NULL,
  `gravado` decimal(9,2) DEFAULT NULL,
  `exento` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pjubilaciones_nf`
--


--
-- Table structure for table `pnomina`
--

CREATE TABLE `pnomina` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idempleado` int(11) DEFAULT NULL,
  `totalpercepciones` decimal(9,2) DEFAULT NULL,
  `totaldeducciones` decimal(9,2) DEFAULT NULL,
  `pagobancos` decimal(9,2) DEFAULT NULL,
  `pagoefectivo` decimal(9,2) DEFAULT NULL,
  `pagovales` decimal(9,2) DEFAULT NULL,
  `pagootros` decimal(9,2) DEFAULT NULL,
  `total` decimal(9,2) DEFAULT NULL,
  `fechainicial` date DEFAULT NULL,
  `fechafinal` date DEFAULT NULL,
  `usuario` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `sueldodiario` decimal(9,2) DEFAULT NULL,
  `diastrabajados` decimal(9,2) DEFAULT NULL,
  `uuid` varchar(500) DEFAULT NULL,
  `serie` varchar(100) DEFAULT NULL,
  `folio` int(11) DEFAULT NULL,
  `emisor` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pnomina`
--


--
-- Table structure for table `pnomina_incidencias`
--

CREATE TABLE `pnomina_incidencias` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idpnomina` int(11) DEFAULT NULL,
  `idincidencia` varchar(11) DEFAULT NULL,
  `tipoincidencia` varchar(100) DEFAULT NULL,
  `monto` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pnomina_incidencias`
--


--
-- Table structure for table `pnomina_incidencias_nf`
--

CREATE TABLE `pnomina_incidencias_nf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idpnomina` int(11) DEFAULT NULL,
  `idincidencia` varchar(11) DEFAULT NULL,
  `tipoincidencia` varchar(100) DEFAULT NULL,
  `monto` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pnomina_incidencias_nf`
--


--
-- Table structure for table `pnomina_nf`
--

CREATE TABLE `pnomina_nf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idempleado` int(11) DEFAULT NULL,
  `totalpercepciones` decimal(9,2) DEFAULT NULL,
  `totaldeducciones` decimal(9,2) DEFAULT NULL,
  `pagobancos` decimal(9,2) DEFAULT NULL,
  `pagoefectivo` decimal(9,2) DEFAULT NULL,
  `pagovales` decimal(9,2) DEFAULT NULL,
  `pagootros` decimal(9,2) DEFAULT NULL,
  `total` decimal(9,2) DEFAULT NULL,
  `fechainicial` date DEFAULT NULL,
  `fechafinal` date DEFAULT NULL,
  `usuario` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `sueldodiario` decimal(9,2) DEFAULT NULL,
  `diastrabajados` decimal(9,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pnomina_nf`
--


--
-- Table structure for table `porganigrama`
--

CREATE TABLE `porganigrama` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idhijo` int(11) NOT NULL,
  `iddepa_hijo` int(11) NOT NULL,
  `idsucursal` int(11) DEFAULT NULL,
  `idpadre` int(11) DEFAULT NULL,
  `iddepa_padre` int(11) DEFAULT NULL,
  `abstraccion` text DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uqe_relacion_padrehijo` (`idhijo`,`iddepa_hijo`,`idsucursal`,`idpadre`,`iddepa_padre`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `porganigrama`
--


--
-- Table structure for table `potrospagos`
--

CREATE TABLE `potrospagos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipootropago` char(5) DEFAULT NULL,
  `importe` decimal(9,2) DEFAULT NULL,
  `subsidiocausado` decimal(9,2) DEFAULT NULL,
  `saldofavor` decimal(9,2) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `remanente` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `potrospagos`
--


--
-- Table structure for table `potrospagos_nf`
--

CREATE TABLE `potrospagos_nf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipootropago` char(5) DEFAULT NULL,
  `importe` decimal(9,2) DEFAULT NULL,
  `subsidiocausado` decimal(9,2) DEFAULT NULL,
  `saldofavor` decimal(9,2) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `remanente` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `potrospagos_nf`
--


--
-- Table structure for table `ppatron`
--

CREATE TABLE `ppatron` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre_razsoc` varchar(500) DEFAULT NULL,
  `rfc` varchar(200) DEFAULT NULL,
  `curp` varchar(100) DEFAULT NULL,
  `registropatronal` varchar(100) DEFAULT NULL,
  `idregimenfiscal` char(5) DEFAULT NULL,
  `telefono` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `iddireccion` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `titulo` varchar(100) DEFAULT NULL,
  `background` varchar(50) DEFAULT NULL,
  `abreviatura` varchar(5) DEFAULT NULL,
  `template` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ppatron`
--

INSERT INTO `ppatron` VALUES (1,'CORPORATIVO NAERCRIS S.A. DE C.V.','CNA110221HI3','','1111111','601','','',1,1,'MARPIN','logomarpin','Marpi','light');

--
-- Table structure for table `ppercepciones`
--

CREATE TABLE `ppercepciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipopercepcion` char(5) DEFAULT NULL,
  `gravado` decimal(9,2) DEFAULT NULL,
  `excento` decimal(9,2) DEFAULT NULL,
  `valormercado` decimal(9,2) DEFAULT NULL,
  `preciootorgarse` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ppercepciones`
--

INSERT INTO `ppercepciones` VALUES (2,'001',5250.00,0.00,0.00,0.00,1,81),(4,'010',100.00,0.00,0.00,0.00,1,83),(5,'001',5000.10,0.00,0.00,0.00,1,83);

--
-- Table structure for table `ppercepciones_nf`
--

CREATE TABLE `ppercepciones_nf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipopercepcion` char(5) DEFAULT NULL,
  `gravado` decimal(9,2) DEFAULT NULL,
  `excento` decimal(9,2) DEFAULT NULL,
  `valormercado` decimal(9,2) DEFAULT NULL,
  `preciootorgarse` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ppercepciones_nf`
--

INSERT INTO `ppercepciones_nf` VALUES (1,'001',1800.10,0.00,0.00,0.00,1,4),(2,'001',1800.20,0.00,0.00,0.00,1,3),(3,'001',1452.10,0.00,0.00,0.00,1,2),(4,'001',1178.60,0.00,0.00,0.00,1,11),(5,'001',1452.10,0.00,0.00,0.00,1,12),(6,'001',1452.10,0.00,0.00,0.00,1,7),(7,'001',1452.10,0.00,0.00,0.00,1,9),(8,'001',1633.40,0.00,0.00,0.00,1,13),(9,'001',1650.00,0.00,0.00,0.00,1,8),(10,'001',1550.00,0.00,0.00,0.00,1,14),(11,'001',1866.70,0.00,0.00,0.00,1,6),(12,'001',1516.70,0.00,0.00,0.00,1,10);

--
-- Table structure for table `ppermisos`
--

CREATE TABLE `ppermisos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `idempleado` int(11) NOT NULL,
  `motivo` text CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `goce_sueldo` tinyint(4) DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 1,
  `puestoId` int(11) NOT NULL,
  `sucursalId` int(11) NOT NULL,
  `dias` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;

--
-- Dumping data for table `ppermisos`
--


--
-- Table structure for table `programacion_vacaciones`
--

CREATE TABLE `programacion_vacaciones` (
  `id` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `trabajador_id` int(11) NOT NULL,
  `estado` varchar(90) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
  `elaborado` timestamp NULL DEFAULT current_timestamp(),
  `periodo_vacacional` varchar(45) DEFAULT NULL,
  `usuario` varchar(200) DEFAULT NULL,
  `observaciones` varchar(2000) DEFAULT NULL,
  UNIQUE KEY `uq_vacaciones` (`fecha`,`trabajador_id`,`estado`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;

--
-- Dumping data for table `programacion_vacaciones`
--


--
-- Table structure for table `pseparaciones`
--

CREATE TABLE `pseparaciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipopercepcion` char(5) DEFAULT NULL,
  `pagado` decimal(9,2) DEFAULT NULL,
  `anios` int(11) DEFAULT NULL,
  `sueldo` decimal(9,2) DEFAULT NULL,
  `acumulable` decimal(9,2) DEFAULT NULL,
  `noacumulable` decimal(9,2) DEFAULT NULL,
  `gravado` decimal(9,2) DEFAULT NULL,
  `exento` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pseparaciones`
--


--
-- Table structure for table `pseparaciones_nf`
--

CREATE TABLE `pseparaciones_nf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipopercepcion` char(5) DEFAULT NULL,
  `pagado` decimal(9,2) DEFAULT NULL,
  `anios` int(11) DEFAULT NULL,
  `sueldo` decimal(9,2) DEFAULT NULL,
  `acumulable` decimal(9,2) DEFAULT NULL,
  `noacumulable` decimal(9,2) DEFAULT NULL,
  `gravado` decimal(9,2) DEFAULT NULL,
  `exento` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pseparaciones_nf`
--


--
-- Table structure for table `psocioeconomico`
--

CREATE TABLE `psocioeconomico` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idempleado` int(11) NOT NULL,
  `fechaRealizacion` date DEFAULT NULL,
  `evaluador` text DEFAULT NULL,
  `comentarios` text DEFAULT NULL,
  `firma_empleado` text DEFAULT NULL,
  `firma_evaluador` text DEFAULT NULL,
  `fechaCreacion` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `fk_pempleado_id_psocioeconomico_idempleado_idx` (`idempleado`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `psocioeconomico`
--


--
-- Table structure for table `ptimbrado`
--

CREATE TABLE `ptimbrado` (
  `serie` char(10) NOT NULL,
  `folio` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `hora` time DEFAULT NULL,
  `idcontrato` int(11) DEFAULT NULL,
  `fechaIni` date DEFAULT NULL,
  `fechaFin` date DEFAULT NULL,
  `fechaPago` date DEFAULT NULL,
  `idtiponomina` char(5) DEFAULT NULL,
  `diasPagados` int(11) DEFAULT NULL,
  `totalOtrosPagos` decimal(9,2) DEFAULT NULL,
  `totalDeducciones` decimal(9,2) DEFAULT NULL,
  `totalPercepciones` decimal(9,2) DEFAULT NULL,
  `subtotal` decimal(9,2) DEFAULT NULL,
  `descuento` decimal(9,2) DEFAULT NULL,
  `total` decimal(9,2) DEFAULT NULL,
  `sello` text DEFAULT NULL,
  `certificado` text DEFAULT NULL,
  `noCertificado` varchar(100) DEFAULT NULL,
  `cadenaOriginal` text DEFAULT NULL,
  `wssellocfd` text DEFAULT NULL,
  `wssellosat` text DEFAULT NULL,
  `wsuuid` varchar(200) DEFAULT NULL,
  `wsfecha` varchar(100) DEFAULT NULL,
  `wsrfc` varchar(100) DEFAULT NULL,
  `wsnoCertificado` varchar(100) DEFAULT NULL,
  `uuidanterior` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`serie`,`folio`),
  UNIQUE KEY `folio` (`folio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ptimbrado`
--


--
-- Table structure for table `pusuariosucursal`
--

CREATE TABLE `pusuariosucursal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) DEFAULT NULL,
  `idcsucursal` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pusuariosucursal`
--


--
-- Table structure for table `rusuariomodulo`
--

CREATE TABLE `rusuariomodulo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idtipousuario` int(11) DEFAULT 0,
  `usuario` varchar(100) DEFAULT NULL,
  `idmodulo` int(11) DEFAULT NULL,
  `guardar` tinyint(1) DEFAULT 0,
  `actualizar` tinyint(1) DEFAULT 0,
  `borrar` tinyint(1) DEFAULT 0,
  `ver` tinyint(1) DEFAULT 0,
  `imprimir` tinyint(1) DEFAULT 0,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `rusuariomodulo`
--

INSERT INTO `rusuariomodulo` VALUES (1,1,'admin',1,1,1,1,1,1,1),(2,1,'admin',2,1,1,1,1,1,1),(3,1,'admin',3,1,1,1,1,1,1),(4,1,'admin',4,1,1,1,1,1,1),(5,1,'admin',5,1,1,1,1,1,1),(6,1,'admin',6,1,1,1,1,1,1),(7,1,'admin',7,1,1,1,1,1,1),(8,1,'admin',8,1,1,1,1,1,1),(9,1,'admin',9,1,1,1,1,1,1),(10,1,'admin',10,1,1,1,1,1,1),(11,1,'admin',11,1,1,1,1,1,1),(12,1,'admin',12,1,1,1,1,1,1),(13,1,'admin',13,1,1,1,1,1,1),(14,1,'admin',14,1,1,1,1,1,1),(15,1,'admin',15,1,1,1,1,1,1),(16,1,'admin',16,1,1,1,1,1,1),(17,1,'admin',17,1,1,1,1,1,1),(18,1,'admin',18,1,1,1,1,1,1),(19,1,'admin',19,1,1,1,1,1,1),(20,1,'admin',20,1,1,1,1,1,1),(21,1,'admin',21,1,1,1,1,1,1),(22,1,'admin',22,1,1,1,1,1,1),(23,1,'admin',23,1,1,1,1,1,1),(24,1,'admin',24,1,1,1,1,1,1),(25,1,'admin',25,1,1,1,1,1,1);


