--
-- Host: localhost    Database: dbnominaPivaz
-- ------------------------------------------------------


--
-- Table structure for table `amortizaciones`
--

CREATE TABLE `amortizaciones` (
  `id_con_cuentas` int(11) NOT NULL,
  `numeroPago` int(11) DEFAULT NULL,
  `fechaPago` date NOT NULL,
  `capital` double DEFAULT NULL,
  `interes` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `saldo` double DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  PRIMARY KEY (`id_con_cuentas`,`fechaPago`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `amortizaciones`
--


--
-- Table structure for table `asistencia`
--

CREATE TABLE `asistencia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idempleado` int(11) DEFAULT NULL,
  `foto` blob DEFAULT NULL,
  `latitud` varchar(500) DEFAULT NULL,
  `longitud` varchar(500) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `hora` time DEFAULT NULL,
  `aplicaIncidencia` decimal(9,2) DEFAULT -1.00,
  `status` int(11) DEFAULT 1,
  `tipomov` int(11) DEFAULT 1,
  `observaciones` text DEFAULT NULL,
  `justificada` int(11) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `FILTERS` (`fecha`,`hora`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `asistencia`
--


--
-- Table structure for table `asistenciaruta`
--

CREATE TABLE `asistenciaruta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nip` int(11) DEFAULT NULL,
  `latitude` varchar(500) DEFAULT NULL,
  `longitude` varchar(500) DEFAULT NULL,
  `accuracy` varchar(500) DEFAULT NULL,
  `altitude` varchar(500) DEFAULT NULL,
  `altitudeAccuracy` varchar(500) DEFAULT NULL,
  `heading` varchar(500) DEFAULT NULL,
  `speed` varchar(500) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `hora` time DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `asistenciaruta`
--


--
-- Table structure for table `cacciones`
--

CREATE TABLE `cacciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(60) DEFAULT NULL,
  `idsubmodulo` int(8) DEFAULT NULL,
  `status` int(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cacciones`
--

INSERT INTO `cacciones` VALUES (1,'GUARDAR',1,1),(2,'ELIMINAR',1,1);

--
-- Table structure for table `cambios_adscripcion`
--

CREATE TABLE `cambios_adscripcion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sucursal_salida_id` int(11) DEFAULT NULL,
  `sucursal_llegada_id` int(11) DEFAULT NULL,
  `puesto_id` int(11) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `trabajador_id` int(11) DEFAULT NULL,
  `tipo_movto` varchar(45) DEFAULT NULL,
  `sueldo` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cambios_adscripcion`
--

INSERT INTO `cambios_adscripcion` VALUES (1,1,-1,1,'0000-00-00',1,'ingreso',0),(2,1,-1,2,'0000-00-00',3,'ingreso',0),(3,2,-1,1,'0000-00-00',4,'ingreso',0),(4,2,-1,2,'0000-00-00',5,'ingreso',0),(5,3,-1,3,'0000-00-00',6,'ingreso',0),(6,2,-1,3,'0000-00-00',7,'ingreso',0),(7,3,-1,4,'2022-10-10',8,'ingreso',0),(8,5,-1,2,'2021-02-06',9,'ingreso',0),(9,1,-1,5,'2020-09-28',10,'ingreso',0),(10,1,-1,4,'2013-06-12',11,'ingreso',0),(11,1,-1,6,'2010-07-03',12,'ingreso',0),(12,2,-1,2,'2018-10-26',13,'ingreso',0),(13,4,-1,4,'2022-06-15',14,'ingreso',0),(14,4,-1,1,'2022-06-20',15,'ingreso',0),(15,4,-1,7,'2022-06-20',16,'ingreso',0),(16,4,-1,3,'2022-06-20',17,'ingreso',0),(17,4,-1,3,'2022-06-20',18,'ingreso',0),(18,4,-1,8,'2022-06-20',19,'ingreso',0),(19,1,-1,9,'2021-06-14',20,'ingreso',0);

--
-- Table structure for table `canio`
--

CREATE TABLE `canio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(256) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `canio`
--

INSERT INTO `canio` VALUES (1,'2022',1),(2,'2023',1),(3,'2024',99);

--
-- Table structure for table `cbadgets`
--

CREATE TABLE `cbadgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `campo` varchar(200) DEFAULT NULL,
  `tabla` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cbadgets`
--

INSERT INTO `cbadgets` VALUES (1,'empleado_nombre','pempleado',1),(3,'contrato_tipocontrato','pcontrato',1),(4,'contrato_puesto','pcontrato',1),(5,'empleado_edad','pempleado',1),(6,'empleado_edocivil','pempleado',1),(7,'contrato_fechainiciolab','pcontrato',1),(8,'empleado_nip','pempleado',1),(9,'empresa_calle','pempresa',1),(10,'empresa_numext','pempresa',1),(11,'empresa_numint','pempresa',1),(12,'empresa_colonia','pempresa',1),(13,'empresa_municipio','pempresa',1),(14,'empresa_estado','pempresa',1),(15,'empresa_cp','pempresa',1),(16,'empleado_rfc','pempleado',1),(17,'empleado_curp','pempleado',1),(18,'empleado_calle','pempleado',1),(19,'empleado_numext','pempleado',1),(20,'empleado_numint','pempleado',1),(21,'empleado_colonia','pempleado',1),(22,'empleado_municipio','pempleado',1),(23,'empleado_estado','pempleado',1),(24,'empleado_cp','pempleado',1),(25,'contrato_fechainiciolab','pcontrato',1),(26,'contrato_sueldoquincenal','pcontrato',1),(28,'empleado_nss','pempleado',1),(29,'contrato_fechainiciolab sumaFecha_30.days','pcontrato',1),(30,'contrato_sueldoquincenal importeEnLetras','pcontrato',1),(31,'fecha_texto','general',1),(32,'contrato_periodicidadpago','pcontrato',1);

--
-- Table structure for table `cbanco`
--

CREATE TABLE `cbanco` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `nombre` varchar(500) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cbanco`
--

INSERT INTO `cbanco` VALUES ('',' NO APLICA','',1),('002','BANAMEX','Banco Nacional de Mexico S.A. Institucion de Banca Multiple Grupo Financiero Banamex',1),('006','BANCOMEXT','Banco Nacional de Comercio Exterior Sociedad Nacional de Credito Institucion de Banca de Desarrollo',1),('009','BANOBRAS','Banco Nacional de Obras y Servicios Publicos Sociedad Nacional de Credito Institucion de Banca de Desarrollo',1),('012','BBVA BANCOMER','BBVA Bancomer S.A. Institucion de Banca Multiple Grupo Financiero BBVA Bancomer',1),('014','SANTANDER','Banco Santander (Mexico) S.A. Institucion de Banca Multiple Grupo Financiero Santander',1),('019','BANJERCITO','Banco Nacional del Ejercito Fuerza Aerea y Armada Sociedad Nacional de Credito Institucion de Banca de Desarrollo',1),('021','HSBC','HSBC Mexico S.A. institucion De Banca Multiple Grupo Financiero HSBC',1),('030','BAJIO','Banco del Bajio S.A. Institucion de Banca Multiple',1),('032','IXE','IXE Banco S.A. Institucion de Banca Multiple IXE Grupo Financiero',1),('036','INBURSA','Banco Inbursa S.A. Institucion de Banca Multiple Grupo Financiero Inbursa',1),('037','INTERACCIONES','Banco Interacciones S.A. Institucion de Banca Multiple',1),('042','MIFEL','Banca Mifel S.A. Institucion de Banca Multiple Grupo Financiero Mifel',1),('044','SCOTIABANK','Scotiabank Inverlat S.A.',1),('058','BANREGIO','Banco Regional de Monterrey S.A. Institucion de Banca Multiple Banregio Grupo Financiero',1),('059','INVEX','Banco Invex S.A. Institucion de Banca Multiple Invex Grupo Financiero',1),('060','BANSI','Bansi S.A. Institucion de Banca Multiple',1),('062','AFIRME','Banca Afirme S.A. Institucion de Banca Multiple',1),('072','BANORTE IXE','Banco Mercantil del Norte S.A. Institucion de Banca Multiple Grupo Financiero Banorte',1),('102','THE ROYAL BANK','The Royal Bank of Scotland Mexico S.A. Institucion de Banca Multiple',1),('103','AMERICAN EXPRESS','American Express Bank (Mexico) S.A. Institucion de Banca Multiple',1),('106','BAMSA','Bank of America Mexico S.A. Institucion de Banca Multiple Grupo Financiero Bank of America',1),('108','TOKYO','Bank of Tokyo-Mitsubishi UFJ (Mexico) S.A.',1),('110','JP MORGAN','Banco J.P. Morgan S.A. Institucion de Banca Multiple J.P. Morgan Grupo Financiero',1),('112','BMONEX','Banco Monex S.A. Institucion de Banca Multiple',1),('113','VE POR MAS','Banco Ve Por Mas S.A. Institucion de Banca Multiple',1),('116','ING','ING Bank (Mexico) S.A. Institucion de Banca Multiple ING Grupo Financiero',1),('124','DEUTSCHE','Deutsche Bank Mexico S.A. Institucion de Banca Multiple',1),('126','CREDIT SUISSE','Banco Credit Suisse (Mexico) S.A. Institucion de Banca Multiple Grupo Financiero Credit Suisse (Mexico)',1),('127','AZTECA','Banco Azteca S.A. Institucion de Banca Multiple.',1),('128','AUTOFIN','Banco Autofin Mexico S.A. Institucion de Banca Multiple',1),('129','BARCLAYS','Barclays Bank Mexico S.A. Institucion de Banca Multiple Grupo Financiero Barclays Mexico',1),('130','COMPARTAMOS','Banco Compartamos S.A. Institucion de Banca Multiple',1),('131','BANCO FAMSA','Banco Ahorro Famsa S.A. Institucion de Banca Multiple',1),('132','BMULTIVA','Banco Multiva S.A. Institucion de Banca Multiple Multivalores Grupo Financiero',1),('133','ACTINVER','Banco Actinver S.A. Institucion de Banca Multiple Grupo Financiero Actinver',1),('134','WAL-MART','Banco Wal-Mart de Mexico Adelante S.A. Institucion de Banca Multiple',1),('135','NAFIN','Nacional Financiera Sociedad Nacional de Credito Institucion de Banca de Desarrollo',1),('136','INTERCAM BANCO','Intercam Banco S.A. Institucion de Banca Multiple Intercam Grupo Financiero',1),('137','BANCOPPEL','BanCoppel S.A. Institucion de Banca Multiple',1),('138','ABC CAPITAL','ABC Capital S.A. Institucion de Banca Multiple',1),('139','UBS BANK','UBS Bank Mexico S.A. Institucion de Banca Multiple UBS Grupo Financiero',1),('140','CONSUBANCO','Consubanco S.A. Institucion de Banca Multiple',1),('141','VOLKSWAGEN','Volkswagen Bank S.A. Institucion de Banca Multiple',1),('143','CIBANCO','CIBanco S.A.',1),('145','BBASE','Banco Base S.A. Institucion de Banca Multiple',1),('147','BANKAOOL','Bankaool S.A. Institucion de Banca Multiple',1),('148','PAGATODO','Banco PagaTodo S.A. Institucion de Banca Multiple',1),('149','FORJADORES','Banco Forjadores S.A. Institucion de Banca Multiple',1),('150','INMOBILIARIO','Banco Inmobiliario Mexicano S.A. Institucion de Banca Multiple',1),('151','DONDe','Fundacion Donde Banco S.A. Institucion de Banca Multiple',1),('152','BANCREA','Banco Bancrea S.A. Institucion de Banca Multiple',1),('153','PROGRESO','Banco Progreso Chihuahua S.A.',1),('154','BANCO FINTERRA','Banco Finterra S.A. Institucion de Banca Multiple',1),('155','ICBC','Industrial and Commercial Bank of China Mexico S.A. Institucion de Banca Multiple',1),('156','SABADELL','Banco Sabadell S.A. Institucion de Banca Multiple',1),('157','SHINHAN','Banco Shinhan de Mexico S.A. Institucion de Banca Multiple',1),('158','MIZUHO BANK','Mizuho Bank Mexico S.A. Institucion de Banca Multiple',1),('159','BANK OF CHINA','Bank of China Mexico S.A. Institucion de Banca Multiple',1),('160','BANCO S3','Banco S3 Mexico S.A. Institucion de Banca Multiple',1),('166','BANSEFI','Banco del Ahorro Nacional y Servicios Financieros Sociedad Nacional de Credito Institucion de Banca de Desarrollo',1),('168','HIPOTECARIA FEDERAL','Sociedad Hipotecaria Federal Sociedad Nacional de Credito Institucion de Banca de Desarrollo',1),('600','MONEXCB','Monex Casa de Bolsa S.A. de C.V. Monex Grupo Financiero',1),('601','GBM','GBM Grupo Bursatil Mexicano S.A. de C.V. Casa de Bolsa',1),('602','MASARI','Masari Casa de Bolsa S.A.',1),('605','VALUE','Value S.A. de C.V. Casa de Bolsa',1),('606','ESTRUCTURADORES','Estructuradores del Mercado de Valores Casa de Bolsa S.A. de C.V.',1),('607','TIBER','Casa de Cambio Tiber S.A. de C.V.',1),('608','VECTOR','Vector Casa de Bolsa S.A. de C.V.',1),('610','B&B','B y B Casa de Cambio S.A. de C.V.',1),('614','ACCIVAL','Acciones y Valores Banamex S.A. de C.V. Casa de Bolsa',1),('615','MERRILL LYNCH','Merrill Lynch Mexico S.A. de C.V. Casa de Bolsa',1),('616','FINAMEX','Casa de Bolsa Finamex S.A. de C.V.',1),('617','VALMEX','Valores Mexicanos Casa de Bolsa S.A. de C.V.',1),('618','UNICA','Unica Casa de Cambio S.A. de C.V.',1),('619','MAPFRE','MAPFRE Tepeyac S.A.',1),('620','PROFUTURO','Profuturo G.N.P. S.A. de C.V. Afore',1),('621','CB ACTINVER','Actinver Casa de Bolsa S.A. de C.V.',1),('622','OACTIN','OPERADORA ACTINVER S.A. DE C.V.',1),('623','SKANDIA','Skandia Vida S.A. de C.V.',1),('626','CBDEUTSCHE','Deutsche Securities S.A. de C.V. CASA DE BOLSA',1),('627','ZURICH','Zurich CompaÃ±ia de Seguros S.A.',1),('628','ZURICHVI','Zurich Vida CompaÃ±ia de Seguros S.A.',1),('629','SU CASITA','Hipotecaria Su Casita S.A. de C.V. SOFOM ENR',1),('630','CB INTERCAM','Intercam Casa de Bolsa S.A. de C.V.',1),('631','CI BOLSA','CI Casa de Bolsa S.A. de C.V.',1),('632','BULLTICK CB','Bulltick Casa de Bolsa S.A. de C.V.',1),('633','STERLING','Sterling Casa de Cambio S.A. de C.V.',1),('634','FINCOMUN','Fincomun Servicios Financieros Comunitarios S.A. de C.V.',1),('636','HDI SEGUROS','HDI Seguros S.A. de C.V.',1),('637','ORDER','Order Express Casa de Cambio S.A. de C.V',1),('638','AKALA','Akala S.A. de C.V. Sociedad Financiera Popular',1),('640','CB JPMORGAN','J.P. Morgan Casa de Bolsa S.A. de C.V. J.P. Morgan Grupo Financiero',1),('642','REFORMA','Operadora de Recursos Reforma S.A. de C.V. S.F.P.',1),('646','STP','Sistema de Transferencias y Pagos STP S.A. de C.V.SOFOM ENR',1),('647','TELECOMM','Telecomunicaciones de Mexico',1),('648','EVERCORE','Evercore Casa de Bolsa S.A. de C.V.',1),('649','SKANDIA','Skandia Operadora de Fondos S.A. de C.V.',1),('651','SEGMTY','Seguros Monterrey New York Life S.A de C.V',1),('652','ASEA','Solucion Asea S.A. de C.V. Sociedad Financiera Popular',1),('653','KUSPIT','Kuspit Casa de Bolsa S.A. de C.V.',1),('655','SOFIEXPRESS','J.P. SOFIEXPRESS S.A. de C.V. S.F.P.',1),('656','UNAGRA','UNAGRA S.A. de C.V. S.F.P.',1),('659','OPCIONES EMPRESARIALES DEL NOROESTE','OPCIONES EMPRESARIALES DEL NORESTE S.A. DE C.V. S.F.P.',1),('670','LIBERTAD','Libertad Servicios Financieros S.A. De C.V.',1),('901','CLS','Cls Bank International',1),('902','INDEVAL','SD. Indeval S.A. de C.V.',1);

--
-- Table structure for table `cdepartamento`
--

CREATE TABLE `cdepartamento` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idpatron` int(11) DEFAULT NULL,
  `descripcion` varchar(500) DEFAULT NULL,
  `idpadre` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdepartamento`
--

INSERT INTO `cdepartamento` VALUES (1,1,'VENTAS',0,1),(2,1,'ADMINISTRACION',0,1),(3,1,'DISTRIBUCION',0,1),(4,1,'CREDITO Y COBRANZA',0,1),(5,1,'COMPRAS',0,1),(6,1,'CONTABILIDAD',0,1);

--
-- Table structure for table `cdiasvacaciones`
--

CREATE TABLE `cdiasvacaciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `limiteinferior` int(11) DEFAULT NULL,
  `limitesuperior` int(11) DEFAULT NULL,
  `dias` int(11) DEFAULT NULL,
  `factordeintegracion` decimal(9,4) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdiasvacaciones`
--


--
-- Table structure for table `cestado`
--

CREATE TABLE `cestado` (
  `id` char(5) NOT NULL,
  `cve_pais` char(5) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cestado`
--

INSERT INTO `cestado` VALUES ('AB','CAN','Â Alberta',0),('AGU','MEX','Aguascalientes',1),('AK','USA','Alaska',0),('AL','USA','Alabama',0),('AR','USA','Arkansas',0),('AZ','USA','Arizona',0),('BC','CAN','Â Columbia Britanica',0),('BCN','MEX','Baja California',1),('BCS','MEX','Baja California Sur',1),('CA','USA','California',0),('CAM','MEX','Campeche',1),('CHH','MEX','Chihuahua',1),('CHP','MEX','Chiapas',1),('CO','USA','Colorado',0),('COA','MEX','Coahuila',1),('COL','MEX','Colima',1),('CT','USA','Connecticut',0),('DE','USA','Delaware',0),('DIF','MEX','Ciudad de Mexico',1),('DUR','MEX','Durango',1),('FL','USA','Florida',0),('GA','USA','Georgia',0),('GRO','MEX','Guerrero',1),('GUA','MEX','Guanajuato',1),('HI','USA','Hawai',0),('HID','MEX','Hidalgo',1),('IA','USA','Iowa',0),('ID','USA','Idaho',0),('IL','USA','Illinois',0),('IN','USA','Indiana',0),('JAL','MEX','Jalisco',1),('KS','USA','Kansas',0),('KY','USA','Kentucky',0),('LA','USA','Luisiana',0),('MA','USA','Massachusetts',0),('MB','CAN','Â Manitoba',0),('MD','USA','Maryland',0),('ME','USA','Maine',0),('MEX','MEX','Estado de Mexico',1),('MI','USA','Michigan',0),('MIC','MEX','Michoacan',1),('MN','USA','Minnesota',0),('MO','USA','Misuri',0),('MOR','MEX','Morelos',1),('MS','USA','Misisipi',0),('MT','USA','Montana',0),('NAY','MEX','Nayarit',1),('NB','CAN','Nuevo BrunswickÂ ',0),('NC','USA','Carolina del Norte',0),('ND','USA','Dakota del Norte',0),('NE','USA','Nebraska',0),('NH','USA','Nuevo Hampshire',0),('NJ','USA','Nueva Jersey',0),('NL','CAN','Â Terranova y Labrador',0),('NLE','MEX','Nuevo Leon',1),('NM','USA','Nuevo Mexico',0),('NS','CAN','Â Nueva Escocia',0),('NT','CAN','Â Territorios del Noroeste',0),('NV','USA','Nevada',0),('NY','USA','Nueva York',0),('OAX','MEX','Oaxaca',1),('OH','USA','Ohio',0),('OK','USA','Oklahoma',0),('ON','CAN','OntarioÂ ',0),('OR','USA','Oregon',0),('PA','USA','Pensilvania',0),('PE','CAN','Â Isla del Principe Eduardo',0),('PUE','MEX','Puebla',1),('QC','CAN','Â QuebecÂ ',0),('QUE','MEX','Queretaro',1),('RI','USA','Rhode Island',0),('ROO','MEX','Quintana Roo',1),('SC','USA','Carolina del Sur',0),('SD','USA','Dakota del Sur',0),('SIN','MEX','Sinaloa',1),('SK','CAN','Â Saskatchewan',0),('SLP','MEX','San Luis Potosi',1),('SON','MEX','Sonora',1),('TAB','MEX','Tabasco',1),('TAM','MEX','Tamaulipas',1),('TLA','MEX','Tlaxcala',1),('TN','USA','Tennessee',0),('TX','USA','Texas',0),('UN','CAN','Â Nunavut',0),('UT','USA','Utah',0),('VA','USA','Virginia',0),('VER','MEX','Veracruz',1),('VT','USA','Vermont',0),('WA','USA','Washington',0),('WI','USA','Wisconsin',0),('WV','USA','Virginia Occidental',0),('WY','USA','Wyoming',0),('YT','CAN','Â Yukon',0),('YUC','MEX','Yucatan',1),('ZAC','MEX','Zacatecas',1);

--
-- Table structure for table `cestadocivil`
--

CREATE TABLE `cestadocivil` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcionEstadoCivil` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cestadocivil`
--

INSERT INTO `cestadocivil` VALUES (1,'SOLTERA(O)'),(2,'CASADA(O)'),(3,'DIVORCIADA(O)'),(4,'VIUDO(A)');

--
-- Table structure for table `cformato`
--

CREATE TABLE `cformato` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cformato`
--

INSERT INTO `cformato` VALUES (1,'Contrato',1),(2,'Renuncia voluntaria',0);

--
-- Table structure for table `cimss`
--

CREATE TABLE `cimss` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seguroyconcepto` varchar(255) DEFAULT NULL,
  `prestaciones` varchar(255) DEFAULT NULL,
  `cuotapatrondesc` varchar(255) DEFAULT NULL,
  `cuotapatron` decimal(9,4) DEFAULT NULL,
  `cuotatrabajador` decimal(9,4) DEFAULT NULL,
  `cuotatotal` decimal(9,4) DEFAULT NULL,
  `cuotabasesalarial` varchar(255) DEFAULT NULL,
  `anio` int(5) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` int(8) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cimss`
--

INSERT INTO `cimss` VALUES (1,'Riesgos de Trabajo','En especie y dinero','Conforme con su siniestralidad laboral',0.0000,0.0000,0.0000,'Salario base de cotizacion (SBC)',2022,'2023-02-21 04:16:36',1),(2,'Enfermedades y Maternidad','En especie','Cuota fija por cada colaborador hasta por tres veces la UMA vigente^2',20.4000,0.0000,20.4000,'UMA^2',2022,'2023-01-17 21:52:18',1),(3,'Enfermedades y Maternidad','En especie','Cuota adicional por la diferencia del SBC y de tres veces la UMA^2',1.1000,0.4000,1.5000,'Diferencia entre el SBC y tres veces la UMA^2',2022,'2023-01-17 21:52:19',1),(4,'Enfermedades y Maternidad','Gastos medicos para pensionados y beneficiarios',NULL,1.0500,0.3750,1.4250,'SBC',2022,'2023-02-21 04:17:22',1),(5,'Enfermedades y Maternidad','En dinero',NULL,0.7000,0.2500,0.9500,'SBC',2022,'2023-01-18 05:30:22',1),(6,'Invalidez y Vida','En especie y dinero',NULL,1.7500,0.6250,2.3750,'SBC',2022,'2023-01-17 21:52:22',1),(7,'Retiro, cesantia en Edad Avanzada y Vejez (CEAV)','Retiro',NULL,2.0000,0.0000,2.0000,'SBC',2022,'2023-01-17 21:52:25',1),(8,'Retiro, cesantia en Edad Avanzada y Vejez (CEAV)','CEAV',NULL,3.1500,1.1250,4.2750,'SBC',2022,'2023-01-17 21:57:26',1),(9,'Guarderias y Prestaciones Sociales','En especie',NULL,1.0000,0.0000,1.0000,'SBC',2022,'2023-02-21 04:20:32',1),(10,'Infonavit','Credito de vivienda',NULL,5.0000,0.0000,5.0000,'Salario Base de Aportacion',2022,'2023-01-17 21:57:28',1),(11,'Riesgos de Trabajo','En especie y dinero','Conforme con su siniestralidad laboral',0.0000,0.0000,0.0000,'Salario base de cotizacion (SBC)',2023,'2023-02-21 04:16:53',1),(12,'Enfermedades y Maternidad','En especie','Cuota fija por cada colaborador hasta por tres veces la UMA vigente^2',20.4000,0.0000,20.4000,'UMA^2',2023,'2023-02-11 19:30:47',1),(13,'Enfermedades y Maternidad','En especie','Cuota adicional por la diferencia del SBC y de tres veces la UMA^2',1.1000,0.4000,1.5000,'Diferencia entre el SBC y tres veces la UMA^2',2023,'2023-02-11 19:52:50',1),(14,'Enfermedades y Maternidad','Gastos medicos para pensionados y beneficiarios',NULL,1.0500,0.3750,1.4250,'SBC',2023,'2023-02-21 04:17:28',1),(15,'Enfermedades y Maternidad','En dinero',NULL,0.7000,0.2500,0.9500,'SBC',2023,'2023-02-11 19:21:11',1),(16,'Invalidez y Vida','En especie y dinero',NULL,1.7500,0.6250,2.3750,'SBC',2023,'2023-01-17 21:57:50',1),(17,'Retiro, cesantia en Edad Avanzada y Vejez (CEAV)','Retiro',NULL,2.0000,0.0000,2.0000,'SBC',2023,'2023-01-17 21:57:50',1),(18,'Retiro, cesantia en Edad Avanzada y Vejez (CEAV)','CEAV',NULL,3.1500,1.1250,4.2750,'SBC',2023,'2023-01-17 21:57:51',1),(19,'Guarderias y Prestaciones Sociales','En especie',NULL,1.0000,0.0000,1.0000,'SBC',2023,'2023-02-21 04:17:11',1),(20,'Infonavit','Credito de vivienda',NULL,5.0000,0.0000,5.0000,'Salario Base de Aportacion',2023,'2023-01-17 21:57:52',1);

--
-- Table structure for table `cisr`
--

CREATE TABLE `cisr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(100) DEFAULT NULL,
  `limiteinferior` decimal(9,2) DEFAULT NULL,
  `limitesuperior` decimal(9,2) DEFAULT NULL,
  `cuotafija` decimal(9,2) DEFAULT NULL,
  `porcentaje` decimal(9,2) DEFAULT NULL,
  `anio` int(5) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cisr`
--

INSERT INTO `cisr` VALUES (1,'quincenal',0.01,318.00,0.00,1.92,2022,1),(2,'quincenal',318.01,2699.40,6.15,6.40,2022,1),(3,'quincenal',2699.41,4744.05,158.55,10.88,2022,1),(4,'quincenal',4744.06,5514.75,381.00,16.00,2022,1),(5,'quincenal',5514.76,6602.70,504.30,17.92,2022,1),(6,'quincenal',6602.71,13316.70,699.30,21.36,2022,1),(7,'quincenal',13316.71,20988.90,2133.30,23.52,2022,1),(8,'quincenal',20988.91,40071.30,3937.80,30.00,2022,1),(9,'quincenal',40071.31,53428.50,9662.55,32.00,2022,1),(10,'quincenal',53428.51,160285.35,13936.80,34.00,2022,1),(11,'quincenal',160285.36,NULL,50268.15,35.00,2022,1),(12,'semanal',0.01,148.40,0.00,1.92,2022,1),(13,'semanal',148.41,1259.72,2.87,6.40,2022,1),(14,'semanal',1259.73,2213.89,73.99,10.88,2022,1),(15,'semanal',2213.90,2573.55,177.80,16.00,2022,1),(16,'semanal',2573.56,3081.26,235.34,17.92,2022,1),(17,'semanal',3081.27,6214.46,326.34,21.36,2022,1),(18,'semanal',6214.47,9794.82,995.54,23.52,2022,1),(19,'semanal',9794.83,18699.94,1837.64,30.00,2022,1),(20,'semanal',18699.95,24933.30,4509.19,32.00,2022,1),(21,'semanal',24933.31,74799.83,6503.84,34.00,2022,1),(22,'semanal',74799.84,0.00,23458.47,35.00,2022,1),(23,'diario',0.01,21.20,0.00,1.92,2022,1),(24,'diario',21.21,179.96,0.41,6.40,2022,1),(25,'diario',179.97,316.27,10.57,10.88,2022,1),(26,'diario',316.28,367.65,25.40,16.00,2022,1),(27,'diario',367.66,440.18,33.62,17.92,2022,1),(28,'diario',440.19,887.78,46.62,21.36,2022,1),(29,'diario',887.79,1399.26,142.22,23.52,2022,1),(30,'diario',1399.27,2671.42,262.52,30.00,2022,1),(31,'diario',2671.43,3561.90,644.17,32.00,2022,1),(32,'diario',3561.91,10685.69,929.12,34.00,2022,1),(33,'diario',10685.70,NULL,3351.21,35.00,2022,1),(34,'mensual',0.01,644.58,0.00,1.92,2022,1),(35,'mensual',644.59,5470.92,12.38,6.40,2022,1),(36,'mensual',5470.93,9614.66,321.26,10.88,2022,1),(37,'mensual',9614.67,11176.62,772.10,16.00,2022,1),(38,'mensual',11176.63,13381.47,1022.01,17.92,2022,1),(39,'mensual',13381.48,26988.50,1417.12,21.36,2022,1),(40,'mensual',26988.51,42537.58,4323.58,23.52,2022,1),(41,'mensual',42537.59,81211.25,7980.73,30.00,2022,1),(42,'mensual',81211.26,108281.67,19582.83,32.00,2022,1),(43,'mensual',108281.68,324845.01,28245.36,34.00,2022,1),(44,'mensual',324845.02,NULL,101876.90,35.00,2022,1),(45,'quincenal',0.01,368.10,0.00,1.92,2023,1),(46,'quincenal',368.11,3124.35,7.05,6.40,2023,1),(47,'quincenal',3124.36,5490.75,183.45,10.88,2023,1),(48,'quincenal',5490.76,6382.80,441.00,16.00,2023,1),(49,'quincenal',6382.81,7641.90,583.65,17.92,2023,1),(50,'quincenal',7641.91,15412.80,809.25,21.36,2023,1),(51,'quincenal',15412.81,24292.65,2469.15,23.52,2023,1),(52,'quincenal',24292.66,46378.50,4557.75,30.00,2023,1),(53,'quincenal',46378.51,61838.10,11183.40,32.00,2023,1),(54,'quincenal',61838.11,185514.30,16130.55,34.00,2023,1),(55,'quincenal',185514.31,0.00,58180.35,35.00,2023,1),(56,'semanal',0.01,171.78,0.00,1.92,2023,1),(57,'semanal',171.79,1458.03,3.29,6.40,2023,1),(58,'semanal',1458.04,2562.35,85.61,10.88,2023,1),(59,'semanal',2562.36,2978.64,205.80,16.00,2023,1),(60,'semanal',2978.65,3566.22,272.37,17.92,2023,1),(61,'semanal',3566.23,7192.64,377.65,21.36,2023,1),(62,'semanal',7192.65,11336.57,1152.27,23.52,2023,1),(63,'semanal',11336.58,21643.30,2126.95,30.00,2023,1),(64,'semanal',21643.31,28857.78,5218.92,32.00,2023,1),(65,'semanal',28857.79,86573.34,7527.59,34.00,2023,1),(66,'semanal',86573.35,0.00,27150.83,35.00,2023,1),(67,'diario',0.01,24.54,0.00,1.92,2023,1),(68,'diario',24.54,208.29,0.47,6.40,2023,1),(69,'diario',208.30,366.05,12.23,10.88,2023,1),(70,'diario',366.06,425.52,29.40,16.00,2023,1),(71,'diario',425.53,509.46,38.91,17.92,2023,1),(72,'diario',509.47,1027.52,53.95,21.36,2023,1),(73,'diario',1027.53,1619.51,164.61,23.52,2023,1),(74,'diario',1619.52,3091.90,303.85,30.00,2023,1),(75,'diario',3091.91,4122.54,745.56,32.00,2023,1),(76,'diario',4122.55,12367.62,1075.37,34.00,2023,1),(77,'diario',12367.63,0.00,3878.69,35.00,2023,1),(78,'mensual',0.01,746.04,0.00,1.92,2023,1),(79,'mensual',746.05,6332.05,14.32,6.40,2023,1),(80,'mensual',6332.06,11128.01,371.83,10.88,2023,1),(81,'mensual',11128.02,12935.82,893.63,16.00,2023,1),(82,'mensual',12935.83,15487.71,1182.88,17.92,2023,1),(83,'mensual',15487.72,31236.49,1640.18,21.36,2023,1),(84,'mensual',31236.50,49233.00,5004.12,23.52,2023,1),(85,'mensual',49233.01,93993.90,9236.89,30.00,2023,1),(86,'mensual',93993.91,125325.20,22665.17,32.00,2023,1),(87,'mensual',125325.21,375975.61,32691.18,34.00,2023,1),(88,'mensual',375975.62,0.00,117912.32,35.00,2023,1);

--
-- Table structure for table `cmodulo`
--

CREATE TABLE `cmodulo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(60) DEFAULT NULL,
  `status` int(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cmodulo`
--

INSERT INTO `cmodulo` VALUES (1,'Panel Inicial',1),(2,'Organizacion',1),(3,'Control',1),(4,'Nomina',1),(5,'Reclutamiento y Seleccion',1),(6,'Sistema y Seguridad',1),(7,'Reportes y Graficas',1);

--
-- Table structure for table `cmodulos`
--

CREATE TABLE `cmodulos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `href` varchar(200) DEFAULT NULL,
  `icon` varchar(200) DEFAULT NULL,
  `isdropdown` int(11) DEFAULT NULL,
  `idpadre` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cmodulos`
--

INSERT INTO `cmodulos` VALUES (1,'Dashboard','index','box',0,1,1),(2,'Empresa','empresa','globe',0,2,1),(3,'UDNs','udns','home',NULL,2,1),(4,'Empleados','empleados','briefcase',NULL,2,1),(5,'Estructuras','organigrama','share-2',NULL,2,1),(6,'Horarios','parametros','clock',NULL,3,1),(7,'Calendario Laboral','calendario','calendar',NULL,3,1),(8,'Incidencias','incidencias','info',NULL,3,1),(9,'Asistencia','asistencia','watch',NULL,3,1),(10,'Calculo','calculo','sliders',NULL,4,1),(11,'Pago y Timbrado','timbrado','pen-tool',NULL,4,1),(12,'Aspirantes','aspirantes','folder',NULL,5,99),(13,'Socioeconomicos','socioeconomicos','book',NULL,5,1),(14,'Seleccion','seleccion','check-circle',NULL,5,99),(15,'Usuarios','usuarios','users',NULL,6,1),(16,'Permisos y accesos','permisos','key',NULL,6,1),(17,'Bitacora','bitacora','activity',NULL,6,1),(18,'Vacaciones','vacaciones','sun',NULL,3,1),(19,'Formatos','formatos','file-text',NULL,6,1),(20,'Reportes','reportes','layers',NULL,7,1),(21,'Tablas','tabla','table',NULL,4,1),(22,'Rutas','rutas','map-pin',NULL,3,1),(23,'Incidencias N/F','incidenciasnf','info',NULL,3,1),(24,'Calculo N/F','calculonf','sliders',NULL,4,1),(25,'Recibos N/F','timbradonf','pen-tool',NULL,4,1);

--
-- Table structure for table `cnivelestudio`
--

CREATE TABLE `cnivelestudio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcionEscolaridad` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cnivelestudio`
--

INSERT INTO `cnivelestudio` VALUES (1,'PRESCOLAR'),(2,'PRIMARIA'),(3,'SECUNDARIA'),(4,'PREPARATORIA'),(5,'LICENCIATURA'),(6,'MAESTRIA'),(7,'DOCTORADO'),(8,'POSGRADO'),(9,'OTRO');

--
-- Table structure for table `copciones_socioeconomico`
--

CREATE TABLE `copciones_socioeconomico` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idpregunta` int(11) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  `tipo` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_cpregunta_socioeconomico_opcion_idx` (`idpregunta`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `copciones_socioeconomico`
--

INSERT INTO `copciones_socioeconomico` VALUES (1,32,'Alumbrado Público','checkbox'),(2,32,'Drenaje','checkbox'),(3,32,'Recolección de Basura','checkbox'),(4,32,'Vigilancia Policiaca','checkbox'),(5,32,'Agua Potable','checkbox'),(6,32,'Servicios de Salud','checkbox'),(7,32,'Mercado','checkbox'),(8,32,'Supermercado','checkbox'),(9,32,'Transporte Público','checkbox'),(10,32,'Tianguis','checkbox'),(11,34,'Propia','checkbox'),(12,34,'Pagandose','checkbox'),(13,34,'Rentada','checkbox'),(14,34,'Prestada','checkbox'),(15,35,'Tierra','checkbox'),(16,35,'Cemento','checkbox'),(17,35,'Mosaico','checkbox'),(18,56,'Agua Potable','checkbox'),(19,56,'Luz Eléctrica','checkbox'),(20,56,'Teléfono','checkbox'),(21,56,'Drenaje','checkbox'),(22,56,'TV por cable','checkbox'),(23,56,'Internet','checkbox'),(24,36,'Repellado','checkbox'),(25,36,'Sin Repello','checkbox'),(26,36,'Madera','checkbox'),(27,36,'Cartón','checkbox'),(28,37,'Concreto','checkbox'),(29,37,'Lámina','checkbox'),(30,37,'Teja de Barro','checkbox'),(31,37,'Teja de asbesto','checkbox'),(32,37,'Otro','text'),(33,38,'Estufa','checkbox'),(34,38,'Refrigereador','checkbox'),(35,38,'Horno de Microondas','checkbox'),(36,38,'Licuadora','checkbox'),(37,38,'Lavadora','checkbox'),(38,38,'Televisión','checkbox'),(39,38,'Grabadora/Stero','checkbox'),(40,38,'Computadora','checkbox'),(41,38,'No. Camas','text'),(42,39,'IMSS','checkbox'),(43,39,'ISSSTE','checkbox'),(44,39,'Particular','checkbox'),(45,39,'Cruz Roja','checkbox'),(46,39,'Otro','text'),(47,32,'Pavimento','checkbox');

--
-- Table structure for table `cparametros`
--

CREATE TABLE `cparametros` (
  `primavacacional` decimal(9,2) DEFAULT 0.25,
  `diasaguinaldo` decimal(9,2) DEFAULT 15.00,
  `diasmes` decimal(9,2) DEFAULT 30.00,
  `sueldominimo` decimal(9,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cparametros`
--

INSERT INTO `cparametros` VALUES (0.25,15.00,30.00,207.44);

--
-- Table structure for table `cparametrosasistencia`
--

CREATE TABLE `cparametrosasistencia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idpuesto` int(11) DEFAULT NULL,
  `entrada` varchar(50) DEFAULT NULL,
  `entradai` varchar(50) DEFAULT NULL,
  `salidai` varchar(50) DEFAULT NULL,
  `salida` varchar(50) DEFAULT NULL,
  `tolerancia` int(11) DEFAULT NULL,
  `toleranciafalta` int(11) DEFAULT NULL,
  `retardospfalta` int(11) DEFAULT NULL,
  `faltaspdescuento` int(11) DEFAULT NULL,
  `corrido` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `idsucursal` int(11) DEFAULT NULL,
  `idempleado` int(11) DEFAULT NULL,
  `iddepartamento` int(11) DEFAULT NULL,
  `diasemana` int(11) DEFAULT NULL,
  `montodescuento` decimal(9,2) DEFAULT 0.00,
  `limiteretardo` int(11) DEFAULT 60,
  `esruta` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cparametrosasistencia`
--


--
-- Table structure for table `cperiodicidadpago`
--

CREATE TABLE `cperiodicidadpago` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `dias` int(11) DEFAULT NULL,
  `division` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cperiodicidadpago`
--

INSERT INTO `cperiodicidadpago` VALUES ('01','Diario',1,30,30),('02','Semanal',1,7,4),('03','Catorcenal',1,14,2),('04','Quincenal',1,15,2),('05','Mensual',1,30,1),('06','Bimestral',1,60,NULL),('07','Unidad obra',1,NULL,NULL),('08','Comision',1,NULL,NULL),('09','Precio alzado',1,NULL,NULL),('10','Decenal',1,10,3),('99','Otra periodicidad',1,NULL,NULL);

--
-- Table structure for table `cpreguntas_socioeconomico`
--

CREATE TABLE `cpreguntas_socioeconomico` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` text DEFAULT NULL,
  `seccion` text DEFAULT NULL,
  `tipo` varchar(20) DEFAULT NULL,
  `depende_pregunta` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cpreguntas_socioeconomico`
--

INSERT INTO `cpreguntas_socioeconomico` VALUES (1,'Lugar de nacimiento','personales','text',1),(2,'Estado civil','personal','text',2),(3,'Fecha de Nacimiento','personal','date',1),(4,'Sueldo del Padre','economico','ingreso',4),(5,'Sueldo de la Madre','economico','ingreso',5),(6,'sueldo de los Hijos','economico','ingreso',6),(7,'Becas','economico','ingreso',7),(8,'Otras percepciones','economico','ingreso',8),(9,'Alimentación','economico','gasto',9),(10,'Renta','economico','gasto',10),(11,'Luz','economico','gasto',11),(12,'Agua','economico','gasto',12),(13,'Ropa','economico','gasto',13),(14,'Teléfono','economico','gasto',14),(15,'Colegiaturas','economico','gasto',15),(16,'Pago a acreedores','economico','gasto',16),(17,'Seguros/Medicinas','economico','gasto',17),(18,'Transporte','economico','gasto',18),(19,'Casa o Terrenos','economico','creditos',19),(20,'Automóvil(es)','economico','creditos',20),(21,'Tarjetas bancarisas','economico','creditos',21),(22,'Casas comerciales','economico','creditos',22),(23,'Otros','economico','creditos',23),(24,'Último grado de estudios','escolaridad','text',24),(25,'¿Actualmente cursa algún estudio?','escolaridad','text',25),(26,'Indique los estudios que está realizando','escolaridad','text',25),(27,'¿Cuánto tiempo tiene de conocerlo?','vecinales','text',27),(28,'¿Ha tenido problemas con su vecino?','vecinales','text',28),(29,'¿Cómo describiría la relación de la familia?','vecinales','text',29),(30,'¿Lo considera buen vecino?','vecinales','text',30),(31,'Si,no ¿Por qué?','vecinales','text',30),(32,'Tu colonia cuenta con','colonia_vivienda','check',32),(33,'Tu casa cuenta con','colonia_vivienda','empty',33),(34,'Condición','colonia_vivienda','check',33),(35,'Pisos','colonia_vivienda','check',33),(36,'Muros','colonia_vivienda','check',33),(37,'Techo','colonia_vivienda','check',33),(38,'Equipo de la vivienda','colonia_vivienda','check',38),(39,'Servicios médicos con los que cuentan','serv_medicos','empty',39),(40,'No. de personas que viven en la casa','familia','text',40),(41,'No. de personas que dependen de los ingresos familiares','familia','text',41),(42,'En la familia, ¿Padece alguien alguna enfermedad crónica?','medicos','text',42),(43,'¿Quién o quienes?','medicos','text',42),(44,'¿Qué tipo de enfermedad?','medicos','text',42),(45,'¿Con cuanta frecuencia viaja con su familia?','sociocultural','text',45),(46,'¿Qué lugares visitan?','sociocultural','text',46),(47,'¿Cuándo y en qué lugar pasó sus últimas vacaciones?','sociocultural','text',47),(48,'¿Con qué frecuencia come en restaurantes?','sociocultural','text',48),(49,'¿Cuantos libros ha leído este año?','sociocultural','text',49),(50,'¿Cuales?','sociocultural','text',49),(51,'¿Cuantos muesos ha visitado en los últimos años?','sociocultural','text',51),(52,'¿A cuantas obras de teatro ha asistido en el último año?','sociocultural','text',52),(53,'¿Practica algún deporte? ¿Cuál?','sociocultural','text',53),(54,'¿Sus familiares practican algún deporte?','sociocultural','text',54),(55,'¿Cuales?','sociocultural','text',54),(56,'Servicios','colonia_vivienda','check',33);

--
-- Table structure for table `cpuesto`
--

CREATE TABLE `cpuesto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iddepartamento` int(11) DEFAULT NULL,
  `descripcion` varchar(200) DEFAULT NULL,
  `idpadre` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cpuesto`
--

INSERT INTO `cpuesto` VALUES (1,1,'VENDEDOR DE PISO',0,1),(2,2,'AUXILIAR ADMINISTRATIVO',0,1),(3,1,'VENDEDOR FORANEO',0,1),(4,3,'CHOFER',0,1),(5,1,'GERENTE DE TIENDA',0,1),(6,4,'GESTOR DE COBRANZA',0,1),(7,1,'JEFE DE PISO',0,1),(8,4,'COBRADOR',0,1),(9,5,'AUXILIAR DE COMPRAS',0,1);

--
-- Table structure for table `cregimenfiscal`
--

CREATE TABLE `cregimenfiscal` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(500) DEFAULT NULL,
  `fisica` char(2) DEFAULT NULL,
  `moral` char(2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cregimenfiscal`
--

INSERT INTO `cregimenfiscal` VALUES ('601','General de Ley Personas Morales','N','S',1),('603','Personas Morales con Fines no Lucrativos','N','S',1),('605','Sueldos y Salarios e Ingresos Asimilados a Salarios','S','S',1),('606','Arrendamiento','S','S',1),('607','Regimen de Enajenacion o Adquisicion de Bienes','N','S',1),('608','Demas ingresos','S','S',1),('609','Consolidacion','N','S',1),('610','Residentes en el Extranjero sin Establecimiento Permanente en Mexico','N','S',1),('611','Ingresos por Dividendos','S','S',1),('612','Personas Fisicas con Actividades Empresariales y Profesionales','S','S',1),('614','Ingresos por intereses','S','S',1),('615','Regimen de los ingresos por obtencion de premios','S','S',1),('616','Sin obligaciones fiscales','S','S',1),('620','Sociedades Cooperativas de Produccion que optan por diferir sus ingresos','N','S',1),('621','Incorporacion Fiscal','S','S',1),('623','Opcional para Grupos de Sociedades','N','S',1),('624','Coordinados','N','S',1),('628','Hidrocarburos','N','S',1),('629','De los Regimenes Fiscales Preferentes y de las Empresas Multinacionales','S','S',1),('630','Enajenacion de acciones en bolsa de valores','S','S',1);

--
-- Table structure for table `criesgopuesto`
--

CREATE TABLE `criesgopuesto` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `criesgopuesto`
--

INSERT INTO `criesgopuesto` VALUES ('1','Clase I',1),('2','Clase II',1),('3','Clase III',1),('4','Clase IV',1),('5','Clase V',1);

--
-- Table structure for table `csexo`
--

CREATE TABLE `csexo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcionSexo` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `csexo`
--

INSERT INTO `csexo` VALUES (1,'HOMBRE'),(2,'MUJER');

--
-- Table structure for table `csubsidioempleo`
--

CREATE TABLE `csubsidioempleo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(100) DEFAULT 'quincenal',
  `limiteinferior` decimal(9,2) DEFAULT NULL,
  `limitesuperior` decimal(9,2) DEFAULT NULL,
  `importe` decimal(9,2) DEFAULT NULL,
  `anio` int(5) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `csubsidioempleo`
--

INSERT INTO `csubsidioempleo` VALUES (1,'quincenal',0.01,872.85,200.85,2022,1),(2,'quincenal',872.86,1309.20,200.70,2022,1),(3,'quincenal',1309.21,1713.60,200.70,2022,1),(4,'quincenal',1713.61,1745.70,193.80,2022,1),(5,'quincenal',1745.71,2193.75,188.70,2022,1),(6,'quincenal',2193.76,2327.55,174.75,2022,1),(7,'quincenal',2327.55,2632.65,160.35,2022,1),(8,'quincenal',2632.66,3071.40,145.35,2022,1),(9,'quincenal',3071.41,3510.15,125.10,2022,1),(10,'quincenal',3510.16,3642.60,107.40,2022,1),(11,'quincenal',3642.61,NULL,0.00,2022,1),(12,'semanal',0.01,407.33,93.73,2022,1),(13,'semanal',407.34,610.96,93.66,2022,1),(14,'semanal',610.97,799.68,93.66,2022,1),(15,'semanal',799.69,814.66,90.44,2022,1),(16,'semanal',814.67,1023.75,88.06,2022,1),(17,'semanal',1023.76,1086.19,81.55,2022,1),(18,'semanal',1086.20,1228.57,74.83,2022,1),(19,'semanal',1228.58,1433.32,67.83,2022,1),(20,'semanal',1433.33,1638.07,58.38,2022,1),(21,'semanal',1638.08,1699.88,50.12,2022,1),(22,'semanal',1699.89,NULL,0.00,2022,1),(23,'diario',0.01,58.19,13.39,2022,1),(24,'diario',58.20,87.28,13.38,2022,1),(25,'diario',87.29,114.24,13.38,2022,1),(26,'diario',114.25,116.38,12.92,2022,1),(27,'diario',116.39,146.25,12.58,2022,1),(28,'diario',146.26,155.17,11.65,2022,1),(29,'diario',155.18,175.51,10.69,2022,1),(30,'diario',175.52,204.76,9.69,2022,1),(31,'diario',204.77,234.01,8.34,2022,1),(32,'diario',234.02,242.84,7.16,2022,1),(33,'diario',242.85,NULL,0.00,2022,1),(34,'mensual',0.01,1768.96,407.02,2022,1),(35,'mensual',1768.97,2653.38,406.83,2022,1),(36,'mensual',2653.39,3472.84,406.62,2022,1),(37,'mensual',3472.85,3537.87,392.77,2022,1),(38,'mensual',3537.88,4446.15,382.46,2022,1),(39,'mensual',4446.16,4717.18,354.23,2022,1),(40,'mensual',4717.19,5335.42,324.87,2022,1),(41,'mensual',5335.43,6224.67,294.63,2022,1),(42,'mensual',6224.68,7113.90,253.54,2022,1),(43,'mensual',7113.91,7382.33,217.61,2022,1),(44,'mensual',7382.34,NULL,0.00,2022,1),(45,'quincenal',0.01,872.85,200.85,2023,1),(46,'quincenal',872.86,1309.20,200.70,2023,1),(47,'quincenal',1309.21,1713.60,200.70,2023,1),(48,'quincenal',1713.61,1745.70,193.80,2023,1),(49,'quincenal',1745.71,2193.75,188.70,2023,1),(50,'quincenal',2193.76,2327.55,174.75,2023,1),(51,'quincenal',2327.55,2632.65,160.35,2023,1),(52,'quincenal',2632.66,3071.40,145.35,2023,1),(53,'quincenal',3071.41,3510.15,125.10,2023,1),(54,'quincenal',3510.16,3642.60,107.40,2023,1),(55,'quincenal',3642.61,NULL,0.00,2023,1),(56,'semanal',0.01,407.33,93.73,2023,1),(57,'semanal',407.34,610.96,93.66,2023,1),(58,'semanal',610.97,799.68,93.66,2023,1),(59,'semanal',799.69,814.66,90.44,2023,1),(60,'semanal',814.67,1023.75,88.06,2023,1),(61,'semanal',1023.76,1086.19,81.55,2023,1),(62,'semanal',1086.20,1228.57,74.83,2023,1),(63,'semanal',1228.58,1433.32,67.83,2023,1),(64,'semanal',1433.33,1638.07,58.38,2023,1),(65,'semanal',1638.08,1699.88,50.12,2023,1),(66,'semanal',1699.89,NULL,0.00,2023,1),(67,'diario',0.01,58.19,13.39,2023,1),(68,'diario',58.20,87.28,13.38,2023,1),(69,'diario',87.29,114.24,13.38,2023,1),(70,'diario',114.25,116.38,12.92,2023,1),(71,'diario',116.39,146.25,12.58,2023,1),(72,'diario',146.26,155.17,11.65,2023,1),(73,'diario',155.18,175.51,10.69,2023,1),(74,'diario',175.52,204.76,9.69,2023,1),(75,'diario',204.77,234.01,8.34,2023,1),(76,'diario',234.02,242.84,7.16,2023,1),(77,'diario',242.85,NULL,0.00,2023,1),(78,'mensual',0.01,1768.96,407.02,2023,1),(79,'mensual',1768.97,2653.38,406.83,2023,1),(80,'mensual',2653.39,3472.84,406.62,2023,1),(81,'mensual',3472.85,3537.87,392.77,2023,1),(82,'mensual',3537.88,4446.15,382.46,2023,1),(83,'mensual',4446.16,4717.18,354.23,2023,1),(84,'mensual',4717.19,5335.42,324.87,2023,1),(85,'mensual',5335.43,6224.67,294.63,2023,1),(86,'mensual',6224.68,7113.90,253.54,2023,1),(87,'mensual',7113.91,7382.33,217.61,2023,1),(88,'mensual',7382.34,0.00,0.00,2023,1);

--
-- Table structure for table `csucursal`
--

CREATE TABLE `csucursal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `idreloj` int(11) DEFAULT NULL,
  `idprediction` int(11) DEFAULT NULL,
  `idherramienta` int(11) DEFAULT NULL,
  `prorrateo` decimal(9,2) DEFAULT NULL,
  `correo` text DEFAULT NULL,
  `filiacion` varchar(45) DEFAULT NULL,
  `zona` int(11) DEFAULT NULL,
  `preporte` int(11) DEFAULT 1,
  `latitud` varchar(200) DEFAULT NULL,
  `longitud` varchar(200) DEFAULT NULL,
  `rango` decimal(9,2) DEFAULT NULL,
  `menuapp` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `csucursal`
--

INSERT INTO `csucursal` VALUES (1,'CENTRO',1,NULL,NULL,NULL,NULL,NULL,NULL,3,1,'1','1',1.00,NULL),(2,'MAPASTEPEC',1,NULL,NULL,NULL,NULL,NULL,NULL,3,1,'1','1',1.00,NULL),(3,'MATRIZ',1,NULL,NULL,NULL,NULL,NULL,NULL,3,1,'1','1',1.00,NULL),(4,'TONALA',1,NULL,NULL,NULL,NULL,NULL,NULL,3,1,'1','1',1.00,NULL),(5,'BOULEVARD',1,NULL,NULL,NULL,NULL,NULL,NULL,3,1,'1','1',1.00,NULL),(6,'CORPORATIVO',1,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'1','1',1.00,NULL);

--
-- Table structure for table `ctiempocontrato`
--

CREATE TABLE `ctiempocontrato` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(200) DEFAULT NULL,
  `meses` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctiempocontrato`
--

INSERT INTO `ctiempocontrato` VALUES (1,'3 Meses',3,1),(2,'6 Meses',6,1),(3,'12 Meses',12,1),(4,'1 Mes',1,1);

--
-- Table structure for table `ctipocontrato`
--

CREATE TABLE `ctipocontrato` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctipocontrato`
--

INSERT INTO `ctipocontrato` VALUES ('01','Contrato de trabajo por tiempo indeterminado',1),('02','Contrato de trabajo para obra determinada',1),('03','Contrato de trabajo por tiempo determinado',1),('04','Contrato de trabajo por temporada',1),('05','Contrato de trabajo sujeto a prueba',1),('06','Contrato de trabajo con capacitacion inicial',1),('07','Modalidad de contratacion por pago de hora laborada',1),('08','Modalidad de trabajo por comision laboral',1),('09','Modalidades de contratacion donde no existe relacion de trabajo',1),('10','Jubilacion pension retiro',1),('99','Otro contrato',1);

--
-- Table structure for table `ctipodeduccion`
--

CREATE TABLE `ctipodeduccion` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(500) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctipodeduccion`
--

INSERT INTO `ctipodeduccion` VALUES ('00001','Desacato',1),('00002','Violencia',1),('00003','Alteracion del Orden',1),('00004','Perjuicios materiales',1),('00005','Actos inmorales',1),('00006','Estado de ebriedad',1),('0001','Retardos',1),('0002','Acciones correctivas',1),('0003','Pago de deuda interna',1),('0004','Pago de uniformes',1),('0005','Falta injustificada',1),('0006','Permiso sin goce de sueldo',1),('0007','Anticipo de salario',1),('0008','Faltante de inventario',1),('0009','Faltanta en corte de caja',1),('001','Seguridad social',1),('002','ISR',1),('003','Aportaciones a retiro cesantia en edad avanzada y vejez.',1),('004','Otros',1),('005','Aportaciones a Fondo de vivienda',1),('006','Descuento por incapacidad',1),('007','Pension alimenticia',1),('008','Renta',1),('009','Prestamos provenientes del Fondo Nacional de la Vivienda para los Trabajadores',1),('010','Pago por credito de vivienda',1),('011','Pago de abonos INFONACOT',1),('012','Anticipo de salarios',1),('013','Pagos hechos con exceso al trabajador',1),('014','Errores',1),('015','Perdidas',1),('016','Averias',1),('017','Adquisicion de articulos producidos por la empresa o establecimiento',1),('018','Cuotas para la constitucion y fomento de sociedades cooperativas y de cajas de ahorro',1),('019','Cuotas sindicales',1),('020','Ausencia (Ausentismo)',1),('021','Cuotas obrero patronales',1),('022','Impuestos Locales',1),('023','Aportaciones voluntarias',1),('024','Ajuste en Aguinaldo Exento',1),('025','Ajuste en Aguinaldo Gravado',1),('026','Ajuste en Participacion de los Trabajadores en las Utilidades PTU Exento',1),('027','Ajuste en Participacion de los Trabajadores en las Utilidades PTU Gravado',1),('028','Ajuste en Reembolso de Gastos Medicos Dentales y Hospitalarios Exento',1),('029','Ajuste en Fondo de ahorro Exento',1),('030','Ajuste en Caja de ahorro Exento',1),('031','Ajuste en Contribuciones a Cargo del Trabajador Pagadas por el Patron Exento',1),('032','Ajuste en Premios por puntualidad Gravado',1),('033','Ajuste en Prima de Seguro de vida Exento',1),('034','Ajuste en Seguro de Gastos Medicos Mayores Exento',1),('035','Ajuste en Cuotas Sindicales Pagadas por el Patron Exento',1),('036','Ajuste en Subsidios por incapacidad Exento',1),('037','Ajuste en Becas para trabajadores y o hijos Exento',1),('038','Ajuste en Horas extra Exento',1),('039','Ajuste en Horas extra Gravado',1),('040','Ajuste en Prima dominical Exento',1),('041','Ajuste en Prima dominical Gravado',1),('042','Ajuste en Prima vacacional Exento',1),('043','Ajuste en Prima vacacional Gravado',1),('044','Ajuste en Prima por antigÃ¼edad Exento',1),('045','Ajuste en Prima por antigÃ¼edad Gravado',1),('046','Ajuste en Pagos por separacion Exento',1),('047','Ajuste en Pagos por separacion Gravado',1),('048','Ajuste en Seguro de retiro Exento',1),('049','Ajuste en Indemnizaciones Exento',1),('050','Ajuste en Indemnizaciones Gravado',1),('051','Ajuste en Reembolso por funeral Exento',1),('052','Ajuste en Cuotas de seguridad social pagadas por el patron Exento',1),('053','Ajuste en Comisiones Gravado',1),('054','Ajuste en Vales de despensa Exento',1),('055','Ajuste en Vales de restaurante Exento',1),('056','Ajuste en Vales de gasolina Exento',1),('057','Ajuste en Vales de ropa Exento',1),('058','Ajuste en Ayuda para renta Exento',1),('059','Ajuste en Ayuda para articulos escolares Exento',1),('060','Ajuste en Ayuda para anteojos Exento',1),('061','Ajuste en Ayuda para transporte Exento',1),('062','Ajuste en Ayuda para gastos de funeral Exento',1),('063','Ajuste en Otros ingresos por salarios Exento',1),('064','Ajuste en Otros ingresos por salarios Gravado',1),('065','Ajuste en Jubilaciones pensiones o haberes de retiro Exento',1),('066','Ajuste en Jubilaciones pensiones o haberes de retiro Gravado',1),('067','Ajuste en Pagos por separacion Acumulable',1),('068','Ajuste en Pagos por separacion No acumulable',1),('069','Ajuste en Jubilaciones pensiones o haberes de retiro Acumulable',1),('070','Ajuste en Jubilaciones pensiones o haberes de retiro No acumulable',1),('071','Ajuste en Subsidio para el empleo (efectivamente entregado al trabajador)',1),('072','Ajuste en Ingresos en acciones o titulos valor que representan bienes Exento',1),('073','Ajuste en Ingresos en acciones o titulos valor que representan bienes Gravado',1),('074','Ajuste en Alimentacion Exento',1),('075','Ajuste en Alimentacion Gravado',1),('076','Ajuste en Habitacion Exento',1),('077','Ajuste en Habitacion Gravado',1),('078','Ajuste en Premios por asistencia',1),('079','Ajuste en Pagos distintos a los listados y que no deben considerarse como ingreso por sueldos salarios o ingresos asimilados.',1),('080','Ajuste en Viaticos gravados',1),('081','Ajuste en Viaticos',1),('082','Ajuste en Fondo de ahorro Gravado',1),('083','Ajuste en Caja de ahorro Gravado',1),('084','Ajuste en Prima de Seguro de vida Gravado',1),('085','Ajuste en Seguro de Gastos Medicos Mayores Gravado',1),('086','Ajuste en Subsidios por incapacidad Gravado',1),('087','Ajuste en Becas para trabajadores y o hijos Gravado',1),('088','Ajuste en Seguro de retiro Gravado',1),('089','Ajuste en Vales de despensa Gravado',1),('090','Ajuste en Vales de restaurante Gravado',1),('091','Ajuste en Vales de gasolina Gravado',1),('092','Ajuste en Vales de ropa Gravado',1),('093','Ajuste en Ayuda para renta Gravado',1),('094','Ajuste en Ayuda para articulos escolares Gravado',1),('095','Ajuste en Ayuda para anteojos Gravado',1),('096','Ajuste en Ayuda para transporte Gravado',1),('097','Ajuste en Ayuda para gastos de funeral Gravado',1),('098','Ajuste a ingresos asimilados a salarios gravados',1),('099','Ajuste a ingresos por sueldos y salarios gravados',1),('100','Ajuste en Viaticos exentos',1);

--
-- Table structure for table `ctipodoc`
--

CREATE TABLE `ctipodoc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctipodoc`
--

INSERT INTO `ctipodoc` VALUES (1,'SOLICITUD DE EMPLEO',1),(2,'CURRICULUM VITAE',1),(3,'INE',1),(4,'ACTA DE NACIMIENTO',1),(5,'COMPROBANTE DE ESTUDIOS',1),(6,'CURP',1),(7,'RFC',1),(8,'LICENCIA DE MANEJO',1),(9,'CARTA DE RECOMENDACION',1),(10,'COMPROBANTE DE DOMICILIO',1),(11,'NSS',1),(12,'LICENCIA DE MOTOCICLISTA',1),(13,'FOTOGRAFIA',0),(14,'CONTRATO',1),(15,'PAGARÉ',1),(16,'ACTA DE ENTREGA Y RECEPCION',1),(17,'OTROS',1),(18,'HOJA EN BLANCO',1);

--
-- Table structure for table `ctipoegreso`
--

CREATE TABLE `ctipoegreso` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` text DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Catálogo de los metodos de pagos que se realizan en la operación';

--
-- Dumping data for table `ctipoegreso`
--

INSERT INTO `ctipoegreso` VALUES (1,'Efectivo',1),(2,'Transferencia',1),(3,'Cheque',1),(4,'Depósito',1),(5,'Tarjeta de crédito',1),(6,'Tarjeta de débito',1);

--
-- Table structure for table `ctipohoras`
--

CREATE TABLE `ctipohoras` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctipohoras`
--

INSERT INTO `ctipohoras` VALUES ('01','Dobles',1),('02','Triples',1),('03','Simples',1);

--
-- Table structure for table `ctipoincapacidad`
--

CREATE TABLE `ctipoincapacidad` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctipoincapacidad`
--

INSERT INTO `ctipoincapacidad` VALUES ('01','Riesgo de trabajo.',1),('02','Enfermedad en general.',1),('03','Maternidad.',1);

--
-- Table structure for table `ctipojornada`
--

CREATE TABLE `ctipojornada` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctipojornada`
--

INSERT INTO `ctipojornada` VALUES ('01','Diurna',1),('02','Nocturna',1),('03','Mixta',1),('04','Por hora',1),('05','Reducida',1),('06','Continuada',1),('07','Partida',1),('08','Por turnos',1),('99','Otra Jornada',1);

--
-- Table structure for table `ctiponomina`
--

CREATE TABLE `ctiponomina` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `orden` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctiponomina`
--

INSERT INTO `ctiponomina` VALUES ('E','Nomina extraordinaria',2,1),('O','Nomina ordinaria',1,1);

--
-- Table structure for table `ctipootropago`
--

CREATE TABLE `ctipootropago` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(300) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctipootropago`
--

INSERT INTO `ctipootropago` VALUES ('001','Reintegro de ISR pagado en exceso',1),('002','Subsidio para el empleo',1),('003','Viaticos',1),('004','Aplicacion de saldo a favor por compensacion anual',1),('999','Pagos distintos a los listados y que no deben considerarse como ingreso por sueldos salarios o ingresos asimilados',1);

--
-- Table structure for table `ctipopercepcion`
--

CREATE TABLE `ctipopercepcion` (
  `id` char(5) NOT NULL,
  `descripcion` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctipopercepcion`
--

INSERT INTO `ctipopercepcion` VALUES ('001','Sueldos, Salarios,  Rayas y Jornales',1),('002','Aguinaldo',1),('003','Participacion de los Trabajadores en las Utilidades PTU',1),('004','Reembolso de Gastos Medicos Dentales y Hospitalarios',1),('005','Fondo de Ahorro',1),('006','Caja de ahorro',1),('009','Contribuciones a Cargo del Trabajador Pagadas por el Patron',1),('010','Premios por puntualidad',1),('011','Prima de Seguro de vida',1),('012','Seguro de Gastos Medicos Mayores',1),('013','Cuotas Sindicales Pagadas por el Patron',1),('014','Subsidios por incapacidad',1),('015','Becas para trabajadores y o hijos',1),('019','Horas extra',1),('020','Prima dominical',1),('021','Prima vacacional',1),('022','Prima por antigÃ¼edad',1),('023','Pagos por separacion',1),('024','Seguro de retiro',1),('025','Indemnizaciones',1),('026','Reembolso por funeral',1),('027','Cuotas de seguridad social pagadas por el patron',1),('028','Comisiones',1),('029','Vales de despensa',1),('030','Vales de restaurante',1),('031','Vales de gasolina',1),('032','Vales de ropa',1),('033','Ayuda para renta',1),('034','Ayuda para articulos escolares',1),('035','Ayuda para anteojos',1),('036','Ayuda para transporte',1),('037','Ayuda para gastos de funeral',1),('038','Otros ingresos por salarios',1),('039','Jubilaciones pensiones o haberes de retiro',1),('044','Jubilaciones pensiones o haberes de retiro en parcialidades',1),('045','Ingresos en acciones o titulos valor que representan bienes',1),('046','Ingresos asimilados a salarios',1),('047','Alimentacion',1),('048','Habitacion',1),('049','Premios por asistencia',1),('050','Viaticos',1),('051','Dias de vacaciones',1);

--
-- Table structure for table `ctiporegimen`
--

CREATE TABLE `ctiporegimen` (
  `id` char(5) DEFAULT NULL,
  `descripcion` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctiporegimen`
--

INSERT INTO `ctiporegimen` VALUES ('02','Sueldos',1),('03','Jubilados',1),('05','Asimilados Miembros Sociedades Cooperativas Produccion',1),('06','Asimilados Integrantes Sociedades Asociaciones Civiles',1),('07','Asimilados Miembros consejos',1),('08','Asimilados comisionistas',1),('09','Asimilados Honorarios',1),('10','Asimilados acciones',1),('11','Asimilados otros',1),('04','Pensionados',1),('12','Jubilados o Pensionados',1);

--
-- Table structure for table `ctiposangre`
--

CREATE TABLE `ctiposangre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcionSangre` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctiposangre`
--

INSERT INTO `ctiposangre` VALUES (1,'O POSITIVO'),(2,'O NEGATIVO'),(3,'A POSITIVO'),(4,'A NEGATIVO'),(5,'B POSITIVO'),(6,'B NEGATIVO'),(7,'AB POSITIVO'),(8,'AB NEGATIVO');

--
-- Table structure for table `ctipousuario`
--

CREATE TABLE `ctipousuario` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(400) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ctipousuario`
--

INSERT INTO `ctipousuario` VALUES (1,'ADMINISTRADOR',1),(2,'JEFE SUCURSAL',1),(3,'USUARIO',1),(4,'CONTABILIDAD',1),(5,'RH',1),(101,'EXTERNO',1);

--
-- Table structure for table `cumas`
--

CREATE TABLE `cumas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `anio` int(11) DEFAULT NULL,
  `diario` decimal(9,2) DEFAULT NULL,
  `mensual` decimal(9,2) DEFAULT NULL,
  `anual` decimal(9,2) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cumas`
--

INSERT INTO `cumas` VALUES (1,2016,73.04,2220.42,26645.04,1),(2,2017,75.49,2294.90,27538.80,1),(3,2018,80.60,2450.24,29402.88,1),(4,2019,84.49,2568.50,30822.00,1),(5,2020,86.88,2641.15,31693.80,1),(6,2021,89.62,2724.45,32693.40,1),(7,2022,96.22,2925.09,35101.08,1),(8,2023,103.74,3153.70,3744.40,1);

--
-- Table structure for table `czona`
--

CREATE TABLE `czona` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `czona`
--

INSERT INTO `czona` VALUES (1,'CENTRO',1),(2,'ALTOS',1),(3,'COSTA',1);

--
-- Table structure for table `pasistencia`
--

CREATE TABLE `pasistencia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nip` int(11) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `hora` time DEFAULT NULL,
  `tipo` varchar(100) DEFAULT NULL,
  `incidencia` varchar(100) DEFAULT NULL,
  `usuario` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pasistencia`
--


--
-- Table structure for table `pbitacora`
--

CREATE TABLE `pbitacora` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` varchar(100) DEFAULT NULL,
  `movimiento` varchar(200) DEFAULT NULL,
  `modulo` varchar(200) DEFAULT NULL,
  `query` text DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `hora` time DEFAULT NULL,
  `importancia` int(11) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pbitacora`
--

INSERT INTO `pbitacora` VALUES (1,'admin','CREA DEPARTAMENTO','EMPRESA','SU5TRVJUIElOVE8gY2RlcGFydGFtZW50byAoaWRwYXRyb24sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoMSwnRElTVFJJQlVDSU9OJywxLDAp','2023-06-09','01:55:04',2),(2,'admin','CREA DEPARTAMENTO','EMPRESA','SU5TRVJUIElOVE8gY2RlcGFydGFtZW50byAoaWRwYXRyb24sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoMSwnQ1JFRElUTyBZIENPQlJBTlpBJywxLDAp','2023-06-09','01:55:21',2),(3,'admin','CREA DEPARTAMENTO','EMPRESA','SU5TRVJUIElOVE8gY2RlcGFydGFtZW50byAoaWRwYXRyb24sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoMSwnQ09NUFJBUycsMSwwKQ==','2023-06-09','01:55:30',2),(4,'admin','CREA DEPARTAMENTO','EMPRESA','SU5TRVJUIElOVE8gY2RlcGFydGFtZW50byAoaWRwYXRyb24sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoMSwnQ09OVEFCSUxJREFEJywxLDAp','2023-06-09','01:55:39',2),(5,'admin','CREA PUESTO','EMPRESA','SU5TRVJUIElOVE8gY3B1ZXN0byAoaWRkZXBhcnRhbWVudG8sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoJzMnLCdDSE9GRVInLDEsMCk=','2023-06-09','01:56:04',2),(6,'admin','CREA PUESTO','EMPRESA','SU5TRVJUIElOVE8gY3B1ZXN0byAoaWRkZXBhcnRhbWVudG8sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoJzEnLCdHRVJFTlRFIERFIFRJRU5EQScsMSwwKQ==','2023-06-09','01:56:18',2),(7,'admin','CREA PUESTO','EMPRESA','SU5TRVJUIElOVE8gY3B1ZXN0byAoaWRkZXBhcnRhbWVudG8sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoJzQnLCdHRVNUT1IgREUgQ09CUkFOWkEnLDEsMCk=','2023-06-09','01:56:34',2),(8,'admin','CREA PUESTO','EMPRESA','SU5TRVJUIElOVE8gY3B1ZXN0byAoaWRkZXBhcnRhbWVudG8sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoJzEnLCdKRUZFIERFIFBJU08nLDEsMCk=','2023-06-09','01:56:50',2),(9,'admin','CREA PUESTO','EMPRESA','SU5TRVJUIElOVE8gY3B1ZXN0byAoaWRkZXBhcnRhbWVudG8sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoJzQnLCdDT0JSQURPUicsMSwwKQ==','2023-06-09','01:57:01',2),(10,'admin','CREA PUESTO','EMPRESA','SU5TRVJUIElOVE8gY3B1ZXN0byAoaWRkZXBhcnRhbWVudG8sZGVzY3JpcGNpb24sc3RhdHVzLGlkcGFkcmUpIFZBTFVFUyAoJzUnLCdBVVhJTElBUiBERSBDT01QUkFTJywxLDAp','2023-06-09','01:57:17',2),(11,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ1RPTVYwMzAxMTcnLA0KCQkJCQkJCQkJCQkJCQknVE9MRURPIE1BUlRJTkVaIFZJQ1RPUicsDQoJCQkJCQkJCQkJCQkJCSdUT01WMDMwMTE3SENTTFJDQTMnLA0KCQkJCQkJCQkJCQkJCQknNTIwMDAzNzMxOTgnLA0KCQkJCQkJCQkJCQkJCQknMjAwMy0wMS0xNycsDQoJCQkJCQkJCQkJCQkJCSdTT0xURVJBKE8pJywNCgkJCQkJCQkJCQkJCQkJJ0hPTUJSRScsDQoJCQkJCQkJCQkJCQkJCSd2ODY2OTc5MkBnbWFpbC5jb20nLA0KCQkJCQkJCQkJCQkJCQknOTE4MjE3MTg5NicsDQoJCQkJCQkJCQkJCQkJCSc5NjIyOTI3NDQwJywNCgkJCQkJCQkJCQkJCQkJMSwNCgkJCQkJCQkJCQkJCQkJJzEnLA0KCQkJCQkJCQkJCQkJCQkxLCdPIFBPU0lUSVZPJywnU0VDVU5EQVJJQScsJ3VuZGVmaW5lZC11bmRlZmluZWQnLCdDQVRPTElDTycsJycsICduJyAp','2023-06-09','02:03:34',2),(12,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ1RPTVYwMzAxMTcnLA0KCQkJCQkJCQkJCQkJCQkJCSdUT01WMDMwMTE3JywNCgkJCQkJCQkJCQkJCQkJCQknVE9MRURPIE1BUlRJTkVaIFZJQ1RPUicsDQoJCQkJCQkJCQkJCQkJCQkJJ3Y4NjY5NzkyQGdtYWlsLmNvbScsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCScxJywNCgkJCQkJCQkJCQkJCQkJCQkxKQ==','2023-06-09','02:03:34',2),(13,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMScsDQoJCQkJCQkJCQkJCQkJCQknUFJPTE9OR0FDSU9OIEdVRVJSRVJPICcsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJ0JBUlJJTyBTQU5UQSBDUlVaJywNCgkJCQkJCQkJCQkJCQkJCSdFU0NVSU5UTEEnLA0KCQkJCQkJCQkJCQkJCQkJJzMwNjAwJywNCgkJCQkJCQkJCQkJCQkJCSdDSFAnLA0KCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:03:34',2),(14,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0xPR0Y5MjA5MTBIWTEnLA0KCQkJCQkJCQkJCQkJCQknTE9QRVogR09OWkFMRVogRlJFRERZIE5JQ09MQVMnLA0KCQkJCQkJCQkJCQkJCQknTE9HRjkyMDkxMEhDU1BOUjA1JywNCgkJCQkJCQkJCQkJCQkJJzY0MTY5MjY2ODc3JywNCgkJCQkJCQkJCQkJCQkJJzExOTItMDktMTAnLA0KCQkJCQkJCQkJCQkJCQknU09MVEVSQShPKScsDQoJCQkJCQkJCQkJCQkJCSdIT01CUkUnLA0KCQkJCQkJCQkJCQkJCQkndHVjaGFwYXJyaXRvX2ZyZWRkeUBob3RtYWlsLmNvbScsDQoJCQkJCQkJCQkJCQkJCSc5NjQxMDc1MDQyJywNCgkJCQkJCQkJCQkJCQkJJzk2NDExMzIxMTEnLA0KCQkJCQkJCQkJCQkJCQkxLA0KCQkJCQkJCQkJCQkJCQknMScsDQoJCQkJCQkJCQkJCQkJCTEsJ08gUE9TSVRJVk8nLCdMSUNFTkNJQVRVUkEnLCd1bmRlZmluZWQtdW5kZWZpbmVkJywnQ1JJU1RJQU5PJywnJywgJ24nICk=','2023-06-09','02:07:00',2),(15,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0xPR0Y5MjA5MTBIWTEnLA0KCQkJCQkJCQkJCQkJCQkJCSdMT0dGOTIwOTEwSFkxJywNCgkJCQkJCQkJCQkJCQkJCQknTE9QRVogR09OWkFMRVogRlJFRERZIE5JQ09MQVMnLA0KCQkJCQkJCQkJCQkJCQkJCSd0dWNoYXBhcnJpdG9fZnJlZGR5QGhvdG1haWwuY29tJywNCgkJCQkJCQkJCQkJCQkJCQknMycsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:07:00',2),(16,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMycsDQoJCQkJCQkJCQkJCQkJCQknQ0FQVUxJTicsDQoJCQkJCQkJCQkJCQkJCQknTVpBIDE1IExUIDEnLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknQlVFTk9TIEFJUkVTJywNCgkJCQkJCQkJCQkJCQkJCSdIVUlYVExBJywNCgkJCQkJCQkJCQkJCQkJCSczMDY0MCcsDQoJCQkJCQkJCQkJCQkJCQknQ0hQJywNCgkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:07:01',2),(17,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0FBVkI5MDExMDcnLA0KCQkJCQkJCQkJCQkJCQknQUxGQVJPIFZFTEFaUVVFWiBCTEFOQ0EgSkFORVRIJywNCgkJCQkJCQkJCQkJCQkJJ0FBVkI5MDExMDdNQ1NMTEwwNScsDQoJCQkJCQkJCQkJCQkJCScyMjM5MDc1OTc3JywNCgkJCQkJCQkJCQkJCQkJJzE5OTAtMTEtMDcnLA0KCQkJCQkJCQkJCQkJCQknVU5JT04gTElCUkUnLA0KCQkJCQkJCQkJCQkJCQknTVVKRVInLA0KCQkJCQkJCQkJCQkJCQknamFuZXRoYWxmYXJvdmVsYXpxdWV6QGdtYWlsLmNvbScsDQoJCQkJCQkJCQkJCQkJCSc5MTgxMjQzNjEzJywNCgkJCQkJCQkJCQkJCQkJJzkxODEwMzQwNjMnLA0KCQkJCQkJCQkJCQkJCQkxLA0KCQkJCQkJCQkJCQkJCQknMicsDQoJCQkJCQkJCQkJCQkJCTEsJ08gUE9TSVRJVk8nLCdTRUNVTkRBUklBJywndW5kZWZpbmVkLXVuZGVmaW5lZCcsJ0NBVE9MSUNBJywnJywgJ24nICk=','2023-06-09','02:10:01',2),(18,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0FBVkI5MDExMDcnLA0KCQkJCQkJCQkJCQkJCQkJCSdBQVZCOTAxMTA3JywNCgkJCQkJCQkJCQkJCQkJCQknQUxGQVJPIFZFTEFaUVVFWiBCTEFOQ0EgSkFORVRIJywNCgkJCQkJCQkJCQkJCQkJCQknamFuZXRoYWxmYXJvdmVsYXpxdWV6QGdtYWlsLmNvbScsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCSc0JywNCgkJCQkJCQkJCQkJCQkJCQkxKQ==','2023-06-09','02:10:01',2),(19,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnNCcsDQoJCQkJCQkJCQkJCQkJCQknQ0FMTEUgU0lOIE5PTUJSRSAnLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdFSklETyBMQSBWQUlOSUxMQScsDQoJCQkJCQkJCQkJCQkJCQknTUFQQVNURVBFQycsDQoJCQkJCQkJCQkJCQkJCQknMzA1NjAnLA0KCQkJCQkJCQkJCQkJCQkJJ0NIUCcsDQoJCQkJCQkJCQkJCQkJCQkxKQ==','2023-06-09','02:10:01',2),(20,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0dVTVo4OTAzMjEnLA0KCQkJCQkJCQkJCQkJCQknR1VUSUVSUkVaIE1BUlRJTkVaIFpBSUxBIEpBRkZFTExFVCcsDQoJCQkJCQkJCQkJCQkJCSdHVU1aODkwMzIxTUNTVFJMMDMnLA0KCQkJCQkJCQkJCQkJCQknNzExMzg5MjQzMicsDQoJCQkJCQkJCQkJCQkJCScxOTg5LTAzLTIxJywNCgkJCQkJCQkJCQkJCQkJJ1NPTFRFUkEoTyknLA0KCQkJCQkJCQkJCQkJCQknTVVKRVInLA0KCQkJCQkJCQkJCQkJCQknSVBVS18xOEBIT1RNQUlMLkNPTScsDQoJCQkJCQkJCQkJCQkJCSc5MTgxMDUyNDI3JywNCgkJCQkJCQkJCQkJCQkJJzkxODEwNTI0MjcnLA0KCQkJCQkJCQkJCQkJCQkxLA0KCQkJCQkJCQkJCQkJCQknMicsDQoJCQkJCQkJCQkJCQkJCTEsJ08gUE9TSVRJVk8nLCdMSUNFTkNJQVRVUkEnLCd1bmRlZmluZWQtdW5kZWZpbmVkJywnQ0FUT0xJQ0EnLCcnLCAnbicgKQ==','2023-06-09','02:11:46',2),(21,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0dVTVo4OTAzMjEnLA0KCQkJCQkJCQkJCQkJCQkJCSdHVU1aODkwMzIxJywNCgkJCQkJCQkJCQkJCQkJCQknR1VUSUVSUkVaIE1BUlRJTkVaIFpBSUxBIEpBRkZFTExFVCcsDQoJCQkJCQkJCQkJCQkJCQkJJ0lQVUtfMThASE9UTUFJTC5DT00nLA0KCQkJCQkJCQkJCQkJCQkJCSczJywNCgkJCQkJCQkJCQkJCQkJCQknNScsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:11:46',2),(22,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnNScsDQoJCQkJCQkJCQkJCQkJCQknQ0FMTEUgSE9TUElUQUwgUy9OJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknRUwgTExBTklUTycsDQoJCQkJCQkJCQkJCQkJCQknTUFQQVNURVBFQycsDQoJCQkJCQkJCQkJCQkJCQknMzA1NjAnLA0KCQkJCQkJCQkJCQkJCQkJJ0NIUCcsDQoJCQkJCQkJCQkJCQkJCQkxKQ==','2023-06-09','02:11:46',2),(23,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0dVSks4NDgwMycsDQoJCQkJCQkJCQkJCQkJCSdHVUlMTEVOIEpJTUVORVogS0VJTEEgTUFSRVNBJywNCgkJCQkJCQkJCQkJCQkJJ0dVSks4NDgwM01DU0xNTDAyJywNCgkJCQkJCQkJCQkJCQkJJzcxMDU4NDExMzQwJywNCgkJCQkJCQkJCQkJCQkJJzE5ODQtMDgtMDMnLA0KCQkJCQkJCQkJCQkJCQknU09MVEVSQShPKScsDQoJCQkJCQkJCQkJCQkJCSdNVUpFUicsDQoJCQkJCQkJCQkJCQkJCSdtYXJycnJyZTAzMDhAZ21haWwuY29tJywNCgkJCQkJCQkJCQkJCQkJJzkxODExODYzMjYnLA0KCQkJCQkJCQkJCQkJCQknOTE4MTIzODcwMycsDQoJCQkJCQkJCQkJCQkJCTEsDQoJCQkJCQkJCQkJCQkJCSczJywNCgkJCQkJCQkJCQkJCQkJMSwnTyBQT1NJVElWTycsJ1NFQ1VOREFSSUEnLCd1bmRlZmluZWQtdW5kZWZpbmVkJywnQ1JJU1RJQU5BJywnJywgJ24nICk=','2023-06-09','02:13:48',2),(24,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ2d1ams4NDgwMycsDQoJCQkJCQkJCQkJCQkJCQkJJ2d1ams4NDgwMycsDQoJCQkJCQkJCQkJCQkJCQkJJ0dVSUxMRU4gSklNRU5FWiBLRUlMQSBNQVJFU0EnLA0KCQkJCQkJCQkJCQkJCQkJCSdtYXJycnJyZTAzMDhAZ21haWwuY29tJywNCgkJCQkJCQkJCQkJCQkJCQknMycsDQoJCQkJCQkJCQkJCQkJCQkJJzYnLA0KCQkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:13:48',2),(25,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnNicsDQoJCQkJCQkJCQkJCQkJCQknUFJJViA2QSBTVVInLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdCLiBTQU4gTUlHVUVMJywNCgkJCQkJCQkJCQkJCQkJCSdNQVBBU1RFUEVDJywNCgkJCQkJCQkJCQkJCQkJCSczMDU2MCcsDQoJCQkJCQkJCQkJCQkJCQknQ0hQJywNCgkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:13:48',2),(26,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0xBUkUwNDA3MDYnLA0KCQkJCQkJCQkJCQkJCQknRVZBIE1BUklBIExBUkEgUk9EUklHVUVaJywNCgkJCQkJCQkJCQkJCQkJJ0xBUkUwNDA3MDZNQ1NSRFZBOScsDQoJCQkJCQkJCQkJCQkJCScxNTE2MDQyOTA1NCcsDQoJCQkJCQkJCQkJCQkJCScyMDA0LTA3LTA2JywNCgkJCQkJCQkJCQkJCQkJJ1NPTFRFUkEoTyknLA0KCQkJCQkJCQkJCQkJCQknTVVKRVInLA0KCQkJCQkJCQkJCQkJCQknbGV2YTA0MTQxQGdtYWlsLmNvbScsDQoJCQkJCQkJCQkJCQkJCSc5MTgxMjI0OTY1JywNCgkJCQkJCQkJCQkJCQkJJzkxODExNzM2MjcnLA0KCQkJCQkJCQkJCQkJCQkxLA0KCQkJCQkJCQkJCQkJCQknMicsDQoJCQkJCQkJCQkJCQkJCTEsJ08gUE9TSVRJVk8nLCdQUkVQQVJBVE9SSUEnLCd1bmRlZmluZWQtdW5kZWZpbmVkJywnTklOR1VOQScsJycsICduJyAp','2023-06-09','02:15:30',2),(27,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0xBUkUwNDA3MDYnLA0KCQkJCQkJCQkJCQkJCQkJCSdMQVJFMDQwNzA2JywNCgkJCQkJCQkJCQkJCQkJCQknRVZBIE1BUklBIExBUkEgUk9EUklHVUVaJywNCgkJCQkJCQkJCQkJCQkJCQknbGV2YTA0MTQxQGdtYWlsLmNvbScsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCSc3JywNCgkJCQkJCQkJCQkJCQkJCQkxKQ==','2023-06-09','02:15:30',2),(28,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnNycsDQoJCQkJCQkJCQkJCQkJCQknQ0FMTEUgTEFTIFBBTE1BUyAnLA0KCQkJCQkJCQkJCQkJCQkJJ01BTlpBTkEgMjIgIExPVEUgMycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdOVUVWTyBNSUxFTklPIFZBTERJVklBJywNCgkJCQkJCQkJCQkJCQkJCSdNQVBBU1RFUEVDJywNCgkJCQkJCQkJCQkJCQkJCSczMDU2NycsDQoJCQkJCQkJCQkJCQkJCQknQ0hQJywNCgkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:15:30',2),(29,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJycsDQoJCQkJCQkJCQkJCQkJCSdSSU9TIEhFUk5BTkRFWiBGUkFOQ0lTQ08nLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScyMDAwLTAxLTAxJywNCgkJCQkJCQkJCQkJCQkJJ1NPTFRFUkEoTyknLA0KCQkJCQkJCQkJCQkJCQknSE9NQlJFJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJMSwNCgkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkxLCcnLCdOSU5HVU5PJywndW5kZWZpbmVkLXVuZGVmaW5lZCcsJ05JTkdVTkEnLCcnLCAnbicgKQ==','2023-06-09','02:18:19',2),(30,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ1JJT1NGJywNCgkJCQkJCQkJCQkJCQkJCQknUklPU0YnLA0KCQkJCQkJCQkJCQkJCQkJCSdSSU9TIEhFUk5BTkRFWiBGUkFOQ0lTQ08nLA0KCQkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJCSczJywNCgkJCQkJCQkJCQkJCQkJCQknOCcsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:18:19',2),(31,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnOCcsDQoJCQkJCQkJCQkJCQkJCQknU0lOIERJUkVDQ0lPTicsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknTUFQQVNURVBFQycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdDSFAnLA0KCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:18:19',2),(32,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0hFR0ExMTIyODUnLA0KCQkJCQkJCQkJCQkJCQknSEVSTkFOREVaIEdBUkNJQSBBTUFCRVRIJywNCgkJCQkJCQkJCQkJCQkJJ0hFR0ExMTIyODVNTlRSUk0wNycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknMTk4NS0xMS0yMicsDQoJCQkJCQkJCQkJCQkJCSdTT0xURVJBKE8pJywNCgkJCQkJCQkJCQkJCQkJJ01VSkVSJywNCgkJCQkJCQkJCQkJCQkJJ21heWJlb2xtb3NoZXJuYW5kZXpAZ21haWwuY29tJywNCgkJCQkJCQkJCQkJCQkJJzkxOC02ODgtMDMwMicsDQoJCQkJCQkJCQkJCQkJCSc5MTgtNjQ4LTgxMjEnLA0KCQkJCQkJCQkJCQkJCQkxLA0KCQkJCQkJCQkJCQkJCQknNScsDQoJCQkJCQkJCQkJCQkJCTEsJycsJ1BSRVBBUkFUT1JJQScsJ3VuZGVmaW5lZC11bmRlZmluZWQnLCdOSU5HVU5BJywnJywgJ24nICk=','2023-06-09','02:20:25',2),(33,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0hFR0ExMTIyODUnLA0KCQkJCQkJCQkJCQkJCQkJCSdIRUdBMTEyMjg1JywNCgkJCQkJCQkJCQkJCQkJCQknSEVSTkFOREVaIEdBUkNJQSBBTUFCRVRIJywNCgkJCQkJCQkJCQkJCQkJCQknbWF5YmVvbG1vc2hlcm5hbmRlekBnbWFpbC5jb20nLA0KCQkJCQkJCQkJCQkJCQkJCSczJywNCgkJCQkJCQkJCQkJCQkJCQknOScsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:20:25',2),(34,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnOScsDQoJCQkJCQkJCQkJCQkJCQknQVZFLkFMVkFSTyBPQlJFR09OJywNCgkJCQkJCQkJCQkJCQkJCSc1MycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdDRU5UUk8nLA0KCQkJCQkJCQkJCQkJCQkJJ0VTQ1VJTlRMQScsDQoJCQkJCQkJCQkJCQkJCQknMzA2MDAnLA0KCQkJCQkJCQkJCQkJCQkJJ0NIUCcsDQoJCQkJCQkJCQkJCQkJCQkxKQ==','2023-06-09','02:20:25',2),(35,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0dBUkM5MjA3MjNWNDInLA0KCQkJCQkJCQkJCQkJCQknR0FMTEVHT1MgUk9KQVMgQ1lOVEhJQSBERUwgQ0FSTUVOJywNCgkJCQkJCQkJCQkJCQkJJ0dBUkM5MjA3MjNNQ1NMSlkwOCcsDQoJCQkJCQkJCQkJCQkJCSc4MTg5Mjc3NTA1JywNCgkJCQkJCQkJCQkJCQkJJzE5OTItMDctMjMnLA0KCQkJCQkJCQkJCQkJCQknU09MVEVSQShPKScsDQoJCQkJCQkJCQkJCQkJCSdNVUpFUicsDQoJCQkJCQkJCQkJCQkJCSdnYXJvY3kyMzdAZ21haWwuY29tJywNCgkJCQkJCQkJCQkJCQkJJzk2MTE5MTY3NTYnLA0KCQkJCQkJCQkJCQkJCQknOTYyMTI1ODY2NicsDQoJCQkJCQkJCQkJCQkJCTEsDQoJCQkJCQkJCQkJCQkJCScxJywNCgkJCQkJCQkJCQkJCQkJMSwnTyBQT1NJVElWTycsJ1BSRVBBUkFUT1JJQScsJ3VuZGVmaW5lZC11bmRlZmluZWQnLCdDQVRPTElDTycsJycsICduJyAp','2023-06-09','02:22:03',2),(36,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0dBUkM5MjA3MjNWNDInLA0KCQkJCQkJCQkJCQkJCQkJCSdHQVJDOTIwNzIzVjQyJywNCgkJCQkJCQkJCQkJCQkJCQknR0FMTEVHT1MgUk9KQVMgQ1lOVEhJQSBERUwgQ0FSTUVOJywNCgkJCQkJCQkJCQkJCQkJCQknZ2Fyb2N5MjM3QGdtYWlsLmNvbScsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCScxMCcsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:22:03',2),(37,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTAnLA0KCQkJCQkJCQkJCQkJCQkJJ0JFTElTQVJJTyBET01JTkdVRVonLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdDRU5UUk8nLA0KCQkJCQkJCQkJCQkJCQkJJ0VTQ1VJTlRMQScsDQoJCQkJCQkJCQkJCQkJCQknMzA2MDAnLA0KCQkJCQkJCQkJCQkJCQkJJ0NIUCcsDQoJCQkJCQkJCQkJCQkJCQkxKQ==','2023-06-09','02:22:03',2),(38,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0FPR0Y3MjA2MDQnLA0KCQkJCQkJCQkJCQkJCQknQU5UT05JTyBHT05aQUxFWiBGUkFOQ0lTQ08nLA0KCQkJCQkJCQkJCQkJCQknQU9HRjcyMDYwNEhDU05OUjAzJywNCgkJCQkJCQkJCQkJCQkJJzk2OTI3MjA0OTMxJywNCgkJCQkJCQkJCQkJCQkJJzE5NzItMDYtMDQnLA0KCQkJCQkJCQkJCQkJCQknVU5JT04gTElCUkUnLA0KCQkJCQkJCQkJCQkJCQknSE9NQlJFJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknOTE4MTEyMTg0NScsDQoJCQkJCQkJCQkJCQkJCTEsDQoJCQkJCQkJCQkJCQkJCScxJywNCgkJCQkJCQkJCQkJCQkJMSwnTyBQT1NJVElWTycsJ1BSSU1BUklBJywndW5kZWZpbmVkLXVuZGVmaW5lZCcsJ0NSSVNUSUFOMCcsJ0tFVE9ST0xBQ08sIE5BUFJPWEVOTywgRkxBTkFYJywgJ24nICk=','2023-06-09','02:24:02',2),(39,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0FPR0Y3MjA2MDQnLA0KCQkJCQkJCQkJCQkJCQkJCSdBT0dGNzIwNjA0JywNCgkJCQkJCQkJCQkJCQkJCQknQU5UT05JTyBHT05aQUxFWiBGUkFOQ0lTQ08nLA0KCQkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJCSczJywNCgkJCQkJCQkJCQkJCQkJCQknMTEnLA0KCQkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:24:02',2),(40,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTEnLA0KCQkJCQkJCQkJCQkJCQkJJzVUQSBBVkVOSURBIFNVUicsDQoJCQkJCQkJCQkJCQkJCQknNycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdCQVJSSU8gU0FOIEpPU0UgRklMQVBBJywNCgkJCQkJCQkJCQkJCQkJCSdBQ0FQRVRBSFVBJywNCgkJCQkJCQkJCQkJCQkJCSczMDU4MCcsDQoJCQkJCQkJCQkJCQkJCQknQ0hQJywNCgkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:24:02',2),(41,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ1BBTEg4NDA2MTknLA0KCQkJCQkJCQkJCQkJCQknUEFMT01FUVVFIExPUEVaIEhFUklCRVJUTycsDQoJCQkJCQkJCQkJCQkJCSdQQUxIODQwNjE5SENTTFBSMDMnLA0KCQkJCQkJCQkJCQkJCQknNzEwMTg0MDA3MDYnLA0KCQkJCQkJCQkJCQkJCQknMTk4NC0wNi0xOScsDQoJCQkJCQkJCQkJCQkJCSdVTklPTiBMSUJSRScsDQoJCQkJCQkJCQkJCQkJCSdIT01CUkUnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCSc5MTgxMjQ4MTUyJywNCgkJCQkJCQkJCQkJCQkJMSwNCgkJCQkJCQkJCQkJCQkJJzEnLA0KCQkJCQkJCQkJCQkJCQkxLCcnLCdQUkVQQVJBVE9SSUEnLCd1bmRlZmluZWQtdW5kZWZpbmVkJywnQ0FUT0xJQ08nLCcnLCAnbicgKQ==','2023-06-09','02:25:42',2),(42,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ1BBTEg4NDA2MTknLA0KCQkJCQkJCQkJCQkJCQkJCSdQQUxIODQwNjE5JywNCgkJCQkJCQkJCQkJCQkJCQknUEFMT01FUVVFIExPUEVaIEhFUklCRVJUTycsDQoJCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCScxMicsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:25:42',2),(43,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTInLA0KCQkJCQkJCQkJCQkJCQkJJ0FWLiBDRU5UUkFMJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknRUpJRE8gT1ZBTkRPIFRVUlFVSUEnLA0KCQkJCQkJCQkJCQkJCQkJJ0VTQ1VJTlRMQScsDQoJCQkJCQkJCQkJCQkJCQknMzA2MDAnLA0KCQkJCQkJCQkJCQkJCQkJJ0NIUCcsDQoJCQkJCQkJCQkJCQkJCQkxKQ==','2023-06-09','02:25:42',2),(44,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ1JVUEI5NzA0MTUnLA0KCQkJCQkJCQkJCQkJCQknUlVJWiBQRVJFWiBCRUFUUklaJywNCgkJCQkJCQkJCQkJCQkJJ1JVUEI5NzA0MTVNQ1NaUlQwNicsDQoJCQkJCQkJCQkJCQkJCScxNTE2OTc5NTI3MycsDQoJCQkJCQkJCQkJCQkJCScxOTk3LTA0LTE1JywNCgkJCQkJCQkJCQkJCQkJJ1NPTFRFUkEoTyknLA0KCQkJCQkJCQkJCQkJCQknTVVKRVInLA0KCQkJCQkJCQkJCQkJCQknYmVhdHJpenJ1aXpwZXI3QGdtYWlsLmNvbScsDQoJCQkJCQkJCQkJCQkJCSc5MTgxMDA2MDg2JywNCgkJCQkJCQkJCQkJCQkJJzkxODEyNDc3NzgnLA0KCQkJCQkJCQkJCQkJCQkxLA0KCQkJCQkJCQkJCQkJCQknMicsDQoJCQkJCQkJCQkJCQkJCTEsJ08gUE9TSVRJVk8nLCdMSUNFTkNJQVRVUkEnLCd1bmRlZmluZWQtdW5kZWZpbmVkJywnQ0FUT0xJQ08nLCcnLCAnbicgKQ==','2023-06-09','02:28:07',2),(45,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ3J1cGI5NzA0MTUnLA0KCQkJCQkJCQkJCQkJCQkJCSdydXBiOTcwNDE1JywNCgkJCQkJCQkJCQkJCQkJCQknUlVJWiBQRVJFWiBCRUFUUklaJywNCgkJCQkJCQkJCQkJCQkJCQknYmVhdHJpenJ1aXpwZXI3QGdtYWlsLmNvbScsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCScxMycsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:28:07',2),(46,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTMnLA0KCQkJCQkJCQkJCQkJCQkJJ0FWIEZSQU5DSVNDTyBTQVJBQklBJywNCgkJCQkJCQkJCQkJCQkJCScxMzEwJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJ0IuIE1BUklMTElUQVMnLA0KCQkJCQkJCQkJCQkJCQkJJ01BUEFTVEVQRUMnLA0KCQkJCQkJCQkJCQkJCQkJJzMwNTYwJywNCgkJCQkJCQkJCQkJCQkJCSdDSFAnLA0KCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:28:07',2),(47,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJycsDQoJCQkJCQkJCQkJCQkJCSdWSUxMQUxPQk9TIE5BVEFSRU4gRElFR08gRURVQVJETycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJzIwMDAtMDEtMDEnLA0KCQkJCQkJCQkJCQkJCQknU09MVEVSQShPKScsDQoJCQkJCQkJCQkJCQkJCSdIT01CUkUnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkxLA0KCQkJCQkJCQkJCQkJCQknNCcsDQoJCQkJCQkJCQkJCQkJCTEsJycsJ05JTkdVTk8nLCd1bmRlZmluZWQtdW5kZWZpbmVkJywnJywnJywgJ24nICk=','2023-06-09','02:30:03',2),(48,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ1ZJTExBTE9CT1NCJywNCgkJCQkJCQkJCQkJCQkJCQknVklMTEFMT0JPU0InLA0KCQkJCQkJCQkJCQkJCQkJCSdWSUxMQUxPQk9TIE5BVEFSRU4gRElFR08gRURVQVJETycsDQoJCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCScxNCcsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:30:03',2),(49,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTQnLA0KCQkJCQkJCQkJCQkJCQkJJ1NJTiBESVJFQ0NJT04nLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJ1RPTkFMQScsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdDSFAnLA0KCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:30:03',2),(50,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJycsDQoJCQkJCQkJCQkJCQkJCSdHT05aQUxFWiBSQU1JUkVaIFlFU1NJQ0EgWU9BTkEnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScyMDAwLTAxLTAxJywNCgkJCQkJCQkJCQkJCQkJJ1NPTFRFUkEoTyknLA0KCQkJCQkJCQkJCQkJCQknTVVKRVInLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkxLA0KCQkJCQkJCQkJCQkJCQknNCcsDQoJCQkJCQkJCQkJCQkJCTEsJycsJ05JTkdVTk8nLCd1bmRlZmluZWQtdW5kZWZpbmVkJywnJywnJywgJ24nICk=','2023-06-09','02:31:12',2),(51,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0dPTlpBTEVaWScsDQoJCQkJCQkJCQkJCQkJCQkJJ0dPTlpBTEVaWScsDQoJCQkJCQkJCQkJCQkJCQkJJ0dPTlpBTEVaIFJBTUlSRVogWUVTU0lDQSBZT0FOQScsDQoJCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCScxNScsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:31:12',2),(52,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTUnLA0KCQkJCQkJCQkJCQkJCQkJJ1NJTiBESVJFQ0NJT04nLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJ1RPTkFMQSAnLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknQ0hQJywNCgkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:31:12',2),(53,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJycsDQoJCQkJCQkJCQkJCQkJCSdDT1VUScOxTyBQQVNDQUNJTyBNQVJJQSBKT1NFRkEnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScyMDAwLTAxLTAxJywNCgkJCQkJCQkJCQkJCQkJJ1NPTFRFUkEoTyknLA0KCQkJCQkJCQkJCQkJCQknTVVKRVInLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkxLA0KCQkJCQkJCQkJCQkJCQknNCcsDQoJCQkJCQkJCQkJCQkJCTEsJycsJ05JTkdVTk8nLCd1bmRlZmluZWQtdW5kZWZpbmVkJywnJywnJywgJ24nICk=','2023-06-09','02:32:31',2),(54,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ1BBU0NBQ0lPTScsDQoJCQkJCQkJCQkJCQkJCQkJJ1BBU0NBQ0lPTScsDQoJCQkJCQkJCQkJCQkJCQkJJ0NPVVRJw7FPIFBBU0NBQ0lPIE1BUklBIEpPU0VGQScsDQoJCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCScxNicsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:32:31',2),(55,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTYnLA0KCQkJCQkJCQkJCQkJCQkJJ1NJTiBESVJFQ0NJT04nLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJ1RPTkFMQSAnLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknQ0hQJywNCgkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:32:31',2),(56,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJycsDQoJCQkJCQkJCQkJCQkJCSdNQVJUSU5FWiBQRVJFWiBKRVNVUyBBTEVYQU5ERVJTJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknMjAwMC0wMS0wMScsDQoJCQkJCQkJCQkJCQkJCSdTT0xURVJBKE8pJywNCgkJCQkJCQkJCQkJCQkJJ0hPTUJSRScsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCTEsDQoJCQkJCQkJCQkJCQkJCSc0JywNCgkJCQkJCQkJCQkJCQkJMSwnJywnTklOR1VOTycsJ3VuZGVmaW5lZC11bmRlZmluZWQnLCcnLCcnLCAnbicgKQ==','2023-06-09','02:33:55',2),(57,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ01BUlRJTkVaSicsDQoJCQkJCQkJCQkJCQkJCQkJJ01BUlRJTkVaSicsDQoJCQkJCQkJCQkJCQkJCQkJJ01BUlRJTkVaIFBFUkVaIEpFU1VTIEFMRVhBTkRFUlMnLA0KCQkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJCSczJywNCgkJCQkJCQkJCQkJCQkJCQknMTcnLA0KCQkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:33:55',2),(58,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTcnLA0KCQkJCQkJCQkJCQkJCQkJJ1NJTiBESVJFQ0NJT04nLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJ1RPTkFMQScsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdDSFAnLA0KCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:33:55',2),(59,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJycsDQoJCQkJCQkJCQkJCQkJCSdTVVJJQU5PIERVUkFOIEFMREVOSVQgREFNQVJJUycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJzIwMDAtMDEtMDEnLA0KCQkJCQkJCQkJCQkJCQknU09MVEVSQShPKScsDQoJCQkJCQkJCQkJCQkJCSdNVUpFUicsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCTEsDQoJCQkJCQkJCQkJCQkJCSc0JywNCgkJCQkJCQkJCQkJCQkJMSwnJywnTklOR1VOTycsJ3VuZGVmaW5lZC11bmRlZmluZWQnLCcnLCcnLCAnbicgKQ==','2023-06-09','02:35:22',2),(60,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ1NVUklBTk9BJywNCgkJCQkJCQkJCQkJCQkJCQknU1VSSUFOT0EnLA0KCQkJCQkJCQkJCQkJCQkJCSdTVVJJQU5PIERVUkFOIEFMREVOSVQgREFNQVJJUycsDQoJCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCScxOCcsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:35:22',2),(61,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTgnLA0KCQkJCQkJCQkJCQkJCQkJJ1NJTiBESVJFQ0NJT04nLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJ1RPTkFMQSAnLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknQ0hQJywNCgkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:35:22',2),(62,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJycsDQoJCQkJCQkJCQkJCQkJCSdIRVJOQU5ERVogVkFaUVVFWiBSVUZJTk8nLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScyMDAwLTAxLTAxJywNCgkJCQkJCQkJCQkJCQkJJ1NPTFRFUkEoTyknLA0KCQkJCQkJCQkJCQkJCQknSE9NQlJFJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJMSwNCgkJCQkJCQkJCQkJCQkJJzQnLA0KCQkJCQkJCQkJCQkJCQkxLCcnLCdOSU5HVU5PJywndW5kZWZpbmVkLXVuZGVmaW5lZCcsJycsJycsICduJyAp','2023-06-09','02:36:35',2),(63,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ0hFUk5BTkRFWlInLA0KCQkJCQkJCQkJCQkJCQkJCSdIRVJOQU5ERVpSJywNCgkJCQkJCQkJCQkJCQkJCQknSEVSTkFOREVaIFZBWlFVRVogUlVGSU5PJywNCgkJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCQknMycsDQoJCQkJCQkJCQkJCQkJCQkJJzE5JywNCgkJCQkJCQkJCQkJCQkJCQkxKQ==','2023-06-09','02:36:35',2),(64,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMTknLA0KCQkJCQkJCQkJCQkJCQkJJ1NJTiBESVJFQ0NJT04nLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJ1RPTkFMQScsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCSdDSFAnLA0KCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:36:35',2),(65,'admin','CREACION DE EMPLEADO','EMPLEADOS','SU5TRVJUIElOVE8gcGVtcGxlYWRvICAgKHJmYywgDQoJCQkJCQkJCQkJCQkJCW5vbWJyZSwNCgkJCQkJCQkJCQkJCQkJY3VycCwNCgkJCQkJCQkJCQkJCQkJbnNzLA0KCQkJCQkJCQkJCQkJCQlmZWNoYW5hYywNCgkJCQkJCQkJCQkJCQkJZWRvY2l2aWwsDQoJCQkJCQkJCQkJCQkJCXNleG8sDQoJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQl0ZWxlZm9ubywNCgkJCQkJCQkJCQkJCQkJY2VsdWxhciwNCgkJCQkJCQkJCQkJCQkJaWRwYXRyb24sDQoJCQkJCQkJCQkJCQkJCWlkc3VjdXJzYWwsDQoJCQkJCQkJCQkJCQkJCXN0YXR1cywNCgkJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZSwNCgkJCQkJCQkJCQkJCQkJbml2ZWxlc3R1ZGlvcywNCgkJCQkJCQkJCQkJCQkJbnVtaGlqb3MsDQoJCQkJCQkJCQkJCQkJCXJlbGlnaW9uLA0KCQkJCQkJCQkJCQkJCQlhbGVyZ2lhcywNCgkJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvKQ0KCQkJCQkJCQkJCQkJCVZBTFVFUyAoJycsDQoJCQkJCQkJCQkJCQkJCSdNQUNJQVMgUkFNSVJFWiBFTE1BUiBPTUFSJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknMjAwMC0wMS0wMScsDQoJCQkJCQkJCQkJCQkJCSdTT0xURVJBKE8pJywNCgkJCQkJCQkJCQkJCQkJJ0hPTUJSRScsDQoJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCTEsDQoJCQkJCQkJCQkJCQkJCScxJywNCgkJCQkJCQkJCQkJCQkJMSwnJywnTklOR1VOTycsJ3VuZGVmaW5lZC11bmRlZmluZWQnLCcnLCcnLCAnbicgKQ==','2023-06-09','02:38:04',2),(66,'admin','CREACION DE USUARIO','EMPLEADOS','SU5TRVJUIElOVE8gcHVzdWFyaW9zIAkodXNlcm5hbWUsDQoJCQkJCQkJCQkJCQkJCQkJcGFzc3dvcmQsDQoJCQkJCQkJCQkJCQkJCQkJbm9tYnJlLA0KCQkJCQkJCQkJCQkJCQkJCWVtYWlsLA0KCQkJCQkJCQkJCQkJCQkJCXRpcG8sDQoJCQkJCQkJCQkJCQkJCQkJaWRlbXBsZWFkbywNCgkJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJCVZBTFVFUyAoJ01BQ0lBU08nLA0KCQkJCQkJCQkJCQkJCQkJCSdNQUNJQVNPJywNCgkJCQkJCQkJCQkJCQkJCQknTUFDSUFTIFJBTUlSRVogRUxNQVIgT01BUicsDQoJCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQkJJzMnLA0KCQkJCQkJCQkJCQkJCQkJCScyMCcsDQoJCQkJCQkJCQkJCQkJCQkJMSk=','2023-06-09','02:38:04',2),(67,'admin','CREACION DE DIRECCION','EMPLEADOS','SU5TRVJUIElOVE8gcGRpcmVjY2lvbiAJKG5pcCwNCgkJCQkJCQkJCQkJCQkJCWNhbGxlLA0KCQkJCQkJCQkJCQkJCQkJbnVtZXh0LA0KCQkJCQkJCQkJCQkJCQkJbnVtaW50LA0KCQkJCQkJCQkJCQkJCQkJY29sb25pYSwNCgkJCQkJCQkJCQkJCQkJCW11bmljaXBpbywNCgkJCQkJCQkJCQkJCQkJCWNwLA0KCQkJCQkJCQkJCQkJCQkJaWRlc3RhZG8sDQoJCQkJCQkJCQkJCQkJCQlzdGF0dXMpDQoJCQkJCQkJCQkJCQkJVkFMVUVTICgnMjAnLA0KCQkJCQkJCQkJCQkJCQkJJ1NJTiBESVJFQ0NJT04nLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknJywNCgkJCQkJCQkJCQkJCQkJCScnLA0KCQkJCQkJCQkJCQkJCQkJJ1RVWFRMQSBHVVRJRVJSRVonLA0KCQkJCQkJCQkJCQkJCQkJJycsDQoJCQkJCQkJCQkJCQkJCQknQ0hQJywNCgkJCQkJCQkJCQkJCQkJCTEp','2023-06-09','02:38:04',2),(68,'admin','ACTUALIZA DATOS DE EMPLEADO','EMPLEADOS','VVBEQVRFIHBlbXBsZWFkbyBTRVQgcmZjPScnLA0KCQkJCQkJCQkJCQkJCW5vbWJyZT0nTUFDSUFTIFJBTUlSRVogRUxNQVIgT01BUicsDQoJCQkJCQkJCQkJCQkJY3VycD0nJywNCgkJCQkJCQkJCQkJCQluc3M9JycsDQoJCQkJCQkJCQkJCQkJZmVjaGFuYWM9JzIwMDAtMDEtMDEnLA0KCQkJCQkJCQkJCQkJCWVkb2NpdmlsPSdTT0xURVJBKE8pJywNCgkJCQkJCQkJCQkJCQlzZXhvPSdIT01CUkUnLA0KCQkJCQkJCQkJCQkJCWVtYWlsPScnLA0KCQkJCQkJCQkJCQkJCXRlbGVmb25vPScnLA0KCQkJCQkJCQkJCQkJCWNlbHVsYXI9JycsDQoJCQkJCQkJCQkJCQkJaWRzdWN1cnNhbD0nNicsDQoJCQkJCQkJCQkJCQkJdGlwb3NhbmdyZT0nJywNCgkJCQkJCQkJCQkJCQluaXZlbGVzdHVkaW9zPSdOSU5HVU5PJywNCgkJCQkJCQkJCQkJCQlyZWxpZ2lvbj0nJywNCgkJCQkJCQkJCQkJCQludW1oaWpvcz0ndW5kZWZpbmVkLXVuZGVmaW5lZCcsDQoJCQkJCQkJCQkJCQkJYXNlZ3VyYWRvPSduJywNCgkJCQkJCQkJCQkJCQlhbGVyZ2lhcz0gJycNCgkJCQkJCQkJCQkJICBXSEVSRSBuaXA9JzIwJw==','2023-06-09','02:38:31',3),(69,'admin','ACTUALIZA USUARIO','EMPLEADOS','VVBEQVRFIHB1c3VhcmlvcyBTRVQgCXVzZXJuYW1lPSdNQUNJQVNPJywNCgkJCQkJCQkJCQkJCQkJCXBhc3N3b3JkPSdNQUNJQVNPJywNCgkJCQkJCQkJCQkJCQkJCW5vbWJyZT0nTUFDSUFTIFJBTUlSRVogRUxNQVIgT01BUicsDQoJCQkJCQkJCQkJCQkJCQl0aXBvPSczJw0KCQkJCQkJCQkJCQkJCVdIRVJFIGlkZW1wbGVhZG89JzIwJw==','2023-06-09','02:38:31',3),(70,'admin','ACTUALIZA DIRECCION','EMPLEADOS','VVBEQVRFIHBkaXJlY2Npb24gU0VUIAljYWxsZT0nU0lOIERJUkVDQ0lPTicsDQoJCQkJCQkJCQkJCQkJCW51bWV4dD0nJywNCgkJCQkJCQkJCQkJCQkJbnVtaW50PScnLA0KCQkJCQkJCQkJCQkJCQljb2xvbmlhPScnLA0KCQkJCQkJCQkJCQkJCQltdW5pY2lwaW89J1RVWFRMQSBHVVRJRVJSRVonLA0KCQkJCQkJCQkJCQkJCQljcD0nJywNCgkJCQkJCQkJCQkJCQkJaWRlc3RhZG89J0NIUCcNCgkJCQkJCQkJCQkJCVdIRVJFIG5pcD0nMjAn','2023-06-09','02:38:31',3),(71,'admin','ACTUALIZA CONTRATO','EMPLEADOS','VVBEQVRFIHBjb250cmF0byBTRVQJIAlpZGRlcGFydGFtZW50bz0nNScsDQoJCQkJCQkJCQkJCQkJCWlkcHVlc3RvPSc5JywNCgkJCQkJCQkJCQkJCQkJaWR0aXBvY29udHJhdG89JzAzJywNCgkJCQkJCQkJCQkJCQkJaWR0aXBvY29udHJhdG89JzAzJywNCgkJCQkJCQkJCQkJCQkJaWR0aWVtcG9jb250cmF0bz0nMScsDQoJCQkJCQkJCQkJCQkJCWZlY2hhaW5pY2lvbGFiPScyMDIxLTA2LTE0JywNCgkJCQkJCQkJCQkJCQkJZmVjaGFpbmljaW9ub2Zpc2NhbD0nMjAyMS0wNi0xNCcsDQoJCQkJCQkJCQkJCQkJCXNpbmRpY2FsaXphZG89J05vJywNCgkJCQkJCQkJCQkJCQkJaWR0aXBvcmVnaW1lbj0nMDInLA0KCQkJCQkJCQkJCQkJCQlpZHJpZXNnb3B1ZXN0bz0nNCcsDQoJCQkJCQkJCQkJCQkJCWlkcGVyaW9kaWNpZGFkcGFnbz0nMDQnLA0KCQkJCQkJCQkJCQkJCQlzYWxhcmlvYmFzZT0nNTY2LjMyJywNCgkJCQkJCQkJCQkJCQkJc2FsYXJpb2RpYXJpbz0nNTY2LjMyJywNCgkJCQkJCQkJCQkJCQkJc3VlbGRvYnJ1dG89JzUwMC4wMCcsDQoJCQkJCQkJCQkJCQkJCXN1ZWxkb25mPScwLjAwJywNCgkJCQkJCQkJCQkJCQkJaWRiYW5jbz0nMDEyJywNCgkJCQkJCQkJCQkJCQkJY3VlbnRhYmFuY2FyaWE9JycsDQoJCQkJCQkJCQkJCQkJCWFwbGljYWNhbGN1bG89JzEnLA0KCQkJCQkJCQkJCQkJCQlzdWJyZmM9JycsDQoJCQkJCQkJCQkJCQkJCXN1YnBvcmNlbnRhamU9JzAuMDAnDQoJCQkJCQkJCQkJCQlXSEVSRSAJIG5pcD0nMjAn','2023-06-09','02:38:31',3);

--
-- 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=21 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `pcontrato` VALUES (1,1,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-06-09 08:04:46',NULL,NULL,NULL,NULL,NULL,0,NULL),(2,2,2,1,1,'03','01','2022-04-13','2022-04-13','No','02','4','04',0.00,166.67,'','','',0.00,'2023-06-09 08:03:34',1,'2022-04-13',1,NULL,166.67,0,166.67),(3,3,3,2,2,'03','01','2023-05-01','2023-05-01','No','02','4','04',0.00,233.34,'','','',0.00,'2023-06-09 08:07:01',1,'2023-05-01',1,NULL,233.34,0,233.34),(4,4,4,1,1,'03','01','2021-11-16','2021-11-16','No','02','4','04',0.00,207.44,'','','',0.00,'2023-06-09 08:10:01',1,'2021-11-16',1,NULL,207.44,0,207.44),(5,5,5,2,2,'03','01','2023-03-27','2023-03-27','No','02','4','04',0.00,233.34,'','','',0.00,'2023-06-09 08:11:46',1,'2023-03-27',1,NULL,233.34,0,233.34),(6,6,6,1,3,'03','01','2023-05-08','2023-05-08','No','02','4','04',0.00,166.67,'','','',0.00,'2023-06-09 08:13:48',1,'2023-05-08',1,NULL,166.67,0,166.67),(7,7,7,1,3,'03','01','2023-05-03','2023-05-03','No','02','4','04',0.00,166.67,'','','',0.00,'2023-06-09 08:15:30',1,'2023-05-03',1,NULL,166.67,0,166.67),(8,8,8,3,4,'03','01','2022-10-10','2022-10-10','No','02','4','04',230.85,230.85,'012','','',0.00,'2023-06-09 08:18:19',1,'2022-10-10',1,NULL,220.00,1,0.00),(9,9,9,2,2,'03','01','2021-02-06','2021-02-06','No','02','4','04',279.82,279.82,'012','','',0.00,'2023-06-09 08:20:25',1,'2021-02-06',1,NULL,266.67,1,0.00),(10,10,10,1,5,'03','01','2020-09-28','2020-09-28','No','02','4','04',350.24,350.24,'012','','',0.00,'2023-06-09 08:22:03',1,'2020-09-28',1,NULL,333.34,1,0.00),(11,11,11,3,4,'02','01','2013-06-12','2013-06-12','No','02','4','04',230.85,230.85,'012','','',0.00,'2023-06-09 08:24:02',1,'2013-06-12',1,NULL,220.00,1,0.00),(12,12,12,4,6,'03','01','2010-07-03','2010-07-03','No','02','4','04',217.67,217.67,'012','','',0.00,'2023-06-09 08:25:42',1,'2010-07-03',1,NULL,207.44,1,0.00),(13,13,13,2,2,'03','01','2018-10-26','2018-10-26','No','02','4','04',280.91,280.91,'072','1051527395','',0.00,'2023-06-09 08:28:07',1,'2018-10-26',1,NULL,266.67,1,0.00),(14,14,14,3,4,'03','01','2022-06-15','2022-06-15','No','02','4','04',230.85,230.85,'012','','',0.00,'2023-06-09 08:30:03',1,'2022-06-15',1,NULL,220.00,1,0.00),(15,15,15,1,1,'03','01','2022-06-20','2022-06-20','No','02','4','04',217.67,217.67,'012','','',0.00,'2023-06-09 08:31:12',1,'2022-06-20',1,NULL,207.44,1,0.00),(16,16,16,1,7,'03','01','2022-06-20','2022-06-20','No','02','4','04',217.67,217.67,'012','','',0.00,'2023-06-09 08:32:31',1,'2022-06-20',1,NULL,207.44,1,0.00),(17,17,17,1,3,'03','01','2022-06-20','2022-06-20','No','02','4','04',217.67,217.67,'012','','',0.00,'2023-06-09 08:33:55',1,'2022-06-20',1,NULL,207.44,1,0.00),(18,18,18,1,3,'03','01','2022-06-20','2022-06-20','No','02','4','04',217.67,217.67,'012','','',0.00,'2023-06-09 08:35:22',1,'2022-06-20',1,NULL,207.44,1,0.00),(19,19,19,4,8,'03','01','2022-06-20','2022-06-20','No','02','4','04',217.67,217.67,'012','','',0.00,'2023-06-09 08:36:35',1,'2022-06-20',1,NULL,207.44,1,0.00),(20,20,20,5,9,'03','01','2021-06-14','2021-06-14','No','02','4','04',566.32,566.32,'012','','',0.00,'2023-06-09 08:38:04',1,'2021-06-14',1,NULL,500.00,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 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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


--
-- 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=21 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `pdireccion` VALUES (1,0,'AVENIDA CENTRAL SUR FRANCISCO SARABIA','1307',NULL,'CENTRO','MAPASTEPEC ESTACION','30560','CHP',1),(2,2,'PROLONGACION GUERRERO ','','','BARRIO SANTA CRUZ','ESCUINTLA','30600','CHP',1),(3,3,'CAPULIN','MZA 15 LT 1','','BUENOS AIRES','HUIXTLA','30640','CHP',1),(4,4,'CALLE SIN NOMBRE ','','','EJIDO LA VAINILLA','MAPASTEPEC','30560','CHP',1),(5,5,'CALLE HOSPITAL S/N','','','EL LLANITO','MAPASTEPEC','30560','CHP',1),(6,6,'PRIV 6A SUR','','','B. SAN MIGUEL','MAPASTEPEC','30560','CHP',1),(7,7,'CALLE LAS PALMAS ','MANZANA 22  LOTE 3','','NUEVO MILENIO VALDIVIA','MAPASTEPEC','30567','CHP',1),(8,8,'SIN DIRECCION','','','','MAPASTEPEC','','CHP',1),(9,9,'AVE.ALVARO OBREGON','53','','CENTRO','ESCUINTLA','30600','CHP',1),(10,10,'BELISARIO DOMINGUEZ','','','CENTRO','ESCUINTLA','30600','CHP',1),(11,11,'5TA AVENIDA SUR','7','','BARRIO SAN JOSE FILAPA','ACAPETAHUA','30580','CHP',1),(12,12,'AV. CENTRAL','','','EJIDO OVANDO TURQUIA','ESCUINTLA','30600','CHP',1),(13,13,'AV FRANCISCO SARABIA','1310','','B. MARILLITAS','MAPASTEPEC','30560','CHP',1),(14,14,'SIN DIRECCION','','','','TONALA','','CHP',1),(15,15,'SIN DIRECCION','','','','TONALA ','','CHP',1),(16,16,'SIN DIRECCION','','','','TONALA ','','CHP',1),(17,17,'SIN DIRECCION','','','','TONALA','','CHP',1),(18,18,'SIN DIRECCION','','','','TONALA ','','CHP',1),(19,19,'SIN DIRECCION','','','','TONALA','','CHP',1),(20,20,'SIN DIRECCION','','','','TUXTLA GUTIERREZ','','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=21 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,'TOMV030117','TOLEDO MARTINEZ VICTOR','TOMV030117HCSLRCA3','52000373198','2003-01-17','SOLTERA(O)','HOMBRE','v8669792@gmail.com','9182171896','9622927440',NULL,1,1,1,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICO','','n'),(3,NULL,'LOGF920910HY1','LOPEZ GONZALEZ FREDDY NICOLAS','LOGF920910HCSPNR05','64169266877','1192-09-10','SOLTERA(O)','HOMBRE','tuchaparrito_freddy@hotmail.com','9641075042','9641132111',NULL,1,1,1,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CRISTIANO','','n'),(4,NULL,'AAVB901107','ALFARO VELAZQUEZ BLANCA JANETH','AAVB901107MCSLLL05','2239075977','1990-11-07','UNION LIBRE','MUJER','janethalfarovelazquez@gmail.com','9181243613','9181034063',NULL,1,1,2,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CATOLICA','','n'),(5,NULL,'GUMZ890321','GUTIERREZ MARTINEZ ZAILA JAFFELLET','GUMZ890321MCSTRL03','7113892432','1989-03-21','SOLTERA(O)','MUJER','IPUK_18@HOTMAIL.COM','9181052427','9181052427',NULL,1,1,2,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICA','','n'),(6,NULL,'GUJK84803','GUILLEN JIMENEZ KEILA MARESA','GUJK84803MCSLML02','71058411340','1984-08-03','SOLTERA(O)','MUJER','marrrrre0308@gmail.com','9181186326','9181238703',NULL,1,1,3,NULL,NULL,'O POSITIVO','SECUNDARIA','undefined-undefined','CRISTIANA','','n'),(7,NULL,'LARE040706','EVA MARIA LARA RODRIGUEZ','LARE040706MCSRDVA9','15160429054','2004-07-06','SOLTERA(O)','MUJER','leva04141@gmail.com','9181224965','9181173627',NULL,1,1,2,NULL,NULL,'O POSITIVO','PREPARATORIA','undefined-undefined','NINGUNA','','n'),(8,NULL,'','RIOS HERNANDEZ FRANCISCO','','','2000-01-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,3,NULL,NULL,'','NINGUNO','undefined-undefined','NINGUNA','','n'),(9,NULL,'HEGA112285','HERNANDEZ GARCIA AMABETH','HEGA112285MNTRRM07','','1985-11-22','SOLTERA(O)','MUJER','maybeolmoshernandez@gmail.com','918-688-0302','918-648-8121',NULL,1,1,5,NULL,NULL,'','PREPARATORIA','undefined-undefined','NINGUNA','','n'),(10,NULL,'GARC920723V42','GALLEGOS ROJAS CYNTHIA DEL CARMEN','GARC920723MCSLJY08','8189277505','1992-07-23','SOLTERA(O)','MUJER','garocy237@gmail.com','9611916756','9621258666',NULL,1,1,1,NULL,NULL,'O POSITIVO','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(11,NULL,'AOGF720604','ANTONIO GONZALEZ FRANCISCO','AOGF720604HCSNNR03','96927204931','1972-06-04','UNION LIBRE','HOMBRE','','','9181121845',NULL,1,1,1,NULL,NULL,'O POSITIVO','PRIMARIA','undefined-undefined','CRISTIAN0','KETOROLACO, NAPROXENO, FLANAX','n'),(12,NULL,'PALH840619','PALOMEQUE LOPEZ HERIBERTO','PALH840619HCSLPR03','71018400706','1984-06-19','UNION LIBRE','HOMBRE','','','9181248152',NULL,1,1,1,NULL,NULL,'','PREPARATORIA','undefined-undefined','CATOLICO','','n'),(13,NULL,'RUPB970415','RUIZ PEREZ BEATRIZ','RUPB970415MCSZRT06','15169795273','1997-04-15','SOLTERA(O)','MUJER','beatrizruizper7@gmail.com','9181006086','9181247778',NULL,1,1,2,NULL,NULL,'O POSITIVO','LICENCIATURA','undefined-undefined','CATOLICO','','n'),(14,NULL,'','VILLALOBOS NATAREN DIEGO EDUARDO','','','2000-01-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,4,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(15,NULL,'','GONZALEZ RAMIREZ YESSICA YOANA','','','2000-01-01','SOLTERA(O)','MUJER','','','',NULL,1,1,4,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(16,NULL,'','COUTIñO PASCACIO MARIA JOSEFA','','','2000-01-01','SOLTERA(O)','MUJER','','','',NULL,1,1,4,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(17,NULL,'','MARTINEZ PEREZ JESUS ALEXANDERS','','','2000-01-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,4,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(18,NULL,'','SURIANO DURAN ALDENIT DAMARIS','','','2000-01-01','SOLTERA(O)','MUJER','','','',NULL,1,1,4,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(19,NULL,'','HERNANDEZ VAZQUEZ RUFINO','','','2000-01-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,4,NULL,NULL,'','NINGUNO','undefined-undefined','','','n'),(20,NULL,'','MACIAS RAMIREZ ELMAR OMAR','','','2000-01-01','SOLTERA(O)','HOMBRE','','','',NULL,1,1,6,NULL,NULL,'','NINGUNO','undefined-undefined','','','n');

--
-- 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,'PIVAZ','logopivaz','Piva','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 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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


--
-- 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 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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


--
-- 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),(26,0,NULL,NULL,0,0,0,0,0,1);


