--
-- Host: localhost    Database: iilar74
-- ------------------------------------------------------


--
-- Table structure for table `aplicaciones`
--

CREATE TABLE `aplicaciones` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `codigo` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `nombre` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `serial` char(48) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `tipo` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'F',
  `instalada` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `aplicaciones`
--

INSERT INTO `aplicaciones` VALUES (1,'CO','Contabilidad','','B','S'),(2,'IN','Inventarios','','B','S'),(3,'NO','Nomina','','B','N'),(4,NULL,'Front-Office','','F','N'),(5,NULL,'Punto de Venta','','F','N'),(6,'IM','Administracion','','B','S');

--
-- Table structure for table `aplicativos`
--

CREATE TABLE `aplicativos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `serial` char(48) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `aplicativos`
--

INSERT INTO `aplicativos` VALUES (1,'Contabilidad',''),(2,'Inventarios',''),(3,'Nomina',''),(4,'Front-Office',''),(5,'Punto de Venta','');

--
-- Table structure for table `perfiles`
--

CREATE TABLE `perfiles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(70) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `aplicaciones_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `perfiles`
--

INSERT INTO `perfiles` VALUES (1,'Administrador Contable',1),(2,'Administrador Inventarios',2),(3,'Administrador del Sistema',6),(4,'Pedidos',2),(5,'Recepcionista',1),(8,'Auxiliar Contable',1),(9,'Mensajero',1),(10,'Auxiliar Contable',2);

--
-- Table structure for table `perfiles_permisos`
--

CREATE TABLE `perfiles_permisos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `perfiles_id` int unsigned NOT NULL,
  `permisos_id` int unsigned DEFAULT NULL,
  `aplicaciones_id` int unsigned NOT NULL,
  `controller` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `action` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `perfiles_id` (`perfiles_id`,`permisos_id`),
  KEY `aplicaciones_id` (`aplicaciones_id`),
  CONSTRAINT `perfiles_permisos_ibfk_1` FOREIGN KEY (`aplicaciones_id`) REFERENCES `aplicaciones` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17294 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `perfiles_permisos`
--

INSERT INTO `perfiles_permisos` VALUES (369,1,NULL,2,'ordenes','new'),(370,1,NULL,2,'ordenes','edit'),(371,1,NULL,2,'ordenes','search'),(4044,6,NULL,1,'movimiento','buscar'),(4045,6,NULL,1,'movimiento','guardar'),(4046,6,NULL,1,'movimiento','eliminar'),(4047,6,NULL,1,'movimiento','cambiarFecha'),(4048,6,NULL,1,'movimiento','copiar'),(4049,6,NULL,1,'aura','save'),(4050,6,NULL,1,'aura','getComprobByDate'),(4051,6,NULL,1,'balance','index'),(4052,6,NULL,1,'libro_auxiliar','index'),(4053,6,NULL,1,'consecutivos','index'),(4054,6,NULL,1,'movimiento_terceros','index'),(4055,6,NULL,1,'movimiento_centros','index'),(4056,6,NULL,1,'balance_centros','index'),(4057,6,NULL,1,'comprobante_diario','index'),(4058,6,NULL,1,'listado_movimiento','index'),(4059,6,NULL,1,'listado_retencion','index'),(4060,6,NULL,1,'listado_comprob','index'),(4061,6,NULL,1,'retencion','index'),(4062,6,NULL,1,'balance_general','index'),(4063,6,NULL,1,'libro_diario','index'),(4064,6,NULL,1,'libro_mayor','index'),(4065,6,NULL,1,'libro_terceros','index'),(4066,6,NULL,1,'numeracion','index'),(4067,6,NULL,1,'certificado_retencion','index'),(4068,6,NULL,1,'certificado_ica','index'),(4069,6,NULL,1,'pyg','index'),(4070,6,NULL,1,'caratulas','index'),(4071,6,NULL,1,'movimiento_documentos','index'),(4072,6,NULL,1,'cartera_edades','index'),(4073,6,NULL,1,'activos','index'),(4074,6,NULL,1,'activos','save'),(4075,6,NULL,1,'activos','delete'),(4076,6,NULL,1,'activos','search'),(4077,6,NULL,1,'activos','rcs'),(4078,6,NULL,1,'grupos','index'),(4079,6,NULL,1,'grupos','save'),(4080,6,NULL,1,'grupos','delete'),(4081,6,NULL,1,'grupos','search'),(4082,6,NULL,1,'grupos','rcs'),(4083,6,NULL,1,'tipos_activos','index'),(4084,6,NULL,1,'tipos_activos','save'),(4085,6,NULL,1,'tipos_activos','delete'),(4086,6,NULL,1,'tipos_activos','search'),(4087,6,NULL,1,'tipos_activos','rcs'),(4088,6,NULL,1,'ubicacion','index'),(4089,6,NULL,1,'ubicacion','save'),(4090,6,NULL,1,'ubicacion','delete'),(4091,6,NULL,1,'ubicacion','search'),(4092,6,NULL,1,'ubicacion','rcs'),(4093,6,NULL,1,'depreciacion','index'),(4094,6,NULL,1,'anular_depreciacion','index'),(4095,6,NULL,1,'traslado_activos','index'),(4096,6,NULL,1,'novedad_activos','index'),(4097,6,NULL,1,'consulta_depreciacion','index'),(4098,6,NULL,1,'ordenes','index'),(4099,6,NULL,1,'refe','index'),(4100,6,NULL,1,'refe','save'),(4101,6,NULL,1,'refe','delete'),(4102,6,NULL,1,'refe','search'),(4103,6,NULL,1,'refe','rcs'),(4104,6,NULL,1,'lineaser','index'),(4105,6,NULL,1,'lineaser','save'),(4106,6,NULL,1,'lineaser','delete'),(4107,6,NULL,1,'lineaser','search'),(4108,6,NULL,1,'lineaser','rcs'),(4109,6,NULL,1,'presupuesto','index'),(4110,6,NULL,1,'ejecucion_pres','index'),(4111,6,NULL,1,'recibo_caja','index'),(4112,6,NULL,1,'recibo_caja','buscar'),(4113,6,NULL,1,'recibo_caja','ver'),(4114,6,NULL,1,'recibo_caja','nuevo'),(4115,6,NULL,1,'recibo_caja','generar'),(4116,6,NULL,1,'recibo_caja','anular'),(4117,6,NULL,1,'recibo_caja','imprimir'),(4118,6,NULL,1,'cheque','index'),(4119,6,NULL,1,'chequeras','index'),(4120,6,NULL,1,'chequeras','save'),(4121,6,NULL,1,'chequeras','delete'),(4122,6,NULL,1,'chequeras','search'),(4123,6,NULL,1,'chequeras','rcs'),(4124,6,NULL,1,'cuentas_bancos','index'),(4125,6,NULL,1,'cuentas_bancos','save'),(4126,6,NULL,1,'cuentas_bancos','delete'),(4127,6,NULL,1,'cuentas_bancos','search'),(4128,6,NULL,1,'cuentas_bancos','rcs'),(4129,6,NULL,1,'banco','index'),(4130,6,NULL,1,'banco','save'),(4131,6,NULL,1,'banco','delete'),(4132,6,NULL,1,'banco','search'),(4133,6,NULL,1,'banco','rcs'),(4134,6,NULL,1,'formato_cheque','index'),(4135,6,NULL,1,'medios','index'),(4136,6,NULL,1,'campos_medios','index'),(4137,6,NULL,1,'codigos_medios','index'),(4138,6,NULL,1,'codigos_medios','save'),(4139,6,NULL,1,'codigos_medios','delete'),(4140,6,NULL,1,'codigos_medios','search'),(4141,6,NULL,1,'codigos_medios','rcs'),(4142,6,NULL,1,'formatos_medios','index'),(4143,6,NULL,1,'formatos_medios','save'),(4144,6,NULL,1,'formatos_medios','delete'),(4145,6,NULL,1,'formatos_medios','search'),(4146,6,NULL,1,'formatos_medios','rcs'),(4147,6,NULL,1,'diferidos','index'),(4148,6,NULL,1,'diferidos','save'),(4149,6,NULL,1,'diferidos','delete'),(4150,6,NULL,1,'diferidos','search'),(4151,6,NULL,1,'diferidos','rcs'),(4152,6,NULL,1,'grupos_diferidos','index'),(4153,6,NULL,1,'grupos_diferidos','save'),(4154,6,NULL,1,'grupos_diferidos','delete'),(4155,6,NULL,1,'grupos_diferidos','search'),(4156,6,NULL,1,'grupos_diferidos','rcs'),(4157,6,NULL,1,'amortizacion','index'),(4158,6,NULL,1,'consulta_causacion','index'),(4159,6,NULL,1,'interface_siigo','index'),(4160,6,NULL,1,'cierre_contable','index'),(4161,6,NULL,1,'reabrir_mes','index'),(4162,6,NULL,1,'cierre_cuentas','index'),(4163,6,NULL,1,'reabrir_cuentas','index'),(4164,6,NULL,1,'comprobante_cierre','index'),(4165,6,NULL,1,'cierre_anual','index'),(4166,6,NULL,1,'reabrir_ano','index'),(4167,6,NULL,1,'cuentas','index'),(4168,6,NULL,1,'cuentas','queryCuenta'),(4169,6,NULL,1,'terceros','index'),(4170,6,NULL,1,'terceros','save'),(4171,6,NULL,1,'terceros','delete'),(4172,6,NULL,1,'terceros','search'),(4173,6,NULL,1,'terceros','rcs'),(4174,6,NULL,1,'tipodoc','index'),(4175,6,NULL,1,'tipodoc','save'),(4176,6,NULL,1,'tipodoc','delete'),(4177,6,NULL,1,'tipodoc','search'),(4178,6,NULL,1,'tipodoc','rcs'),(4179,6,NULL,1,'comprobantes','index'),(4180,6,NULL,1,'comprobantes','save'),(4181,6,NULL,1,'comprobantes','delete'),(4182,6,NULL,1,'comprobantes','search'),(4183,6,NULL,1,'comprobantes','rcs'),(4184,6,NULL,1,'diarios','index'),(4185,6,NULL,1,'diarios','save'),(4186,6,NULL,1,'diarios','delete'),(4187,6,NULL,1,'diarios','search'),(4188,6,NULL,1,'diarios','rcs'),(4189,6,NULL,1,'documentos','index'),(4190,6,NULL,1,'documentos','save'),(4191,6,NULL,1,'documentos','delete'),(4192,6,NULL,1,'documentos','search'),(4193,6,NULL,1,'documentos','rcs'),(4194,6,NULL,1,'formapago','index'),(4195,6,NULL,1,'formapago','save'),(4196,6,NULL,1,'formapago','delete'),(4197,6,NULL,1,'formapago','search'),(4198,6,NULL,1,'formapago','rcs'),(4199,6,NULL,1,'regimen_cuentas','index'),(4200,6,NULL,1,'regimen_cuentas','save'),(4201,6,NULL,1,'regimen_cuentas','delete'),(4202,6,NULL,1,'regimen_cuentas','search'),(4203,6,NULL,1,'regimen_cuentas','rcs'),(4204,6,NULL,1,'ica','index'),(4205,6,NULL,1,'ica','save'),(4206,6,NULL,1,'ica','delete'),(4207,6,NULL,1,'ica','search'),(4208,6,NULL,1,'ica','rcs'),(4209,6,NULL,1,'comcier','index'),(4210,6,NULL,1,'comcier','save'),(4211,6,NULL,1,'comcier','delete'),(4212,6,NULL,1,'comcier','search'),(4213,6,NULL,1,'comcier','rcs'),(4214,6,NULL,1,'cuentas_cree','index'),(4215,6,NULL,1,'cuentas_cree','save'),(4216,6,NULL,1,'cuentas_cree','delete'),(4217,6,NULL,1,'cuentas_cree','search'),(4218,6,NULL,1,'cuentas_cree','rcs'),(4219,6,NULL,1,'centros','index'),(4220,6,NULL,1,'centros','save'),(4221,6,NULL,1,'centros','delete'),(4222,6,NULL,1,'centros','search'),(4223,6,NULL,1,'centros','rcs'),(4224,6,NULL,1,'consolidados','index'),(4225,6,NULL,1,'consolidados','save'),(4226,6,NULL,1,'consolidados','delete'),(4227,6,NULL,1,'consolidados','search'),(4228,6,NULL,1,'consolidados','rcs'),(4229,6,NULL,1,'settings','index'),(4230,6,NULL,1,'settings','save'),(7306,3,NULL,6,'usuarios','index'),(7307,3,NULL,6,'usuarios','save'),(7308,3,NULL,6,'usuarios','delete'),(7309,3,NULL,6,'usuarios','search'),(7310,3,NULL,6,'usuarios','rcs'),(7311,3,NULL,6,'usuarios','config'),(7312,3,NULL,6,'sucursal','index'),(7313,3,NULL,6,'sucursal','save'),(7314,3,NULL,6,'sucursal','delete'),(7315,3,NULL,6,'sucursal','search'),(7316,3,NULL,6,'sucursal','rcs'),(7317,3,NULL,6,'perfiles','index'),(7318,3,NULL,6,'perfiles','save'),(7319,3,NULL,6,'perfiles','delete'),(7320,3,NULL,6,'perfiles','search'),(7321,3,NULL,6,'perfiles','rcs'),(7322,3,NULL,6,'perfiles_usuarios','index'),(7323,3,NULL,6,'perfiles_usuarios','save'),(7324,3,NULL,6,'perfiles_usuarios','delete'),(7325,3,NULL,6,'perfiles_usuarios','search'),(7326,3,NULL,6,'perfiles_usuarios','rcs'),(7327,3,NULL,6,'permisos_perfiles','index'),(7328,3,NULL,6,'permisos_perfiles','save'),(7329,3,NULL,6,'permisos_perfiles','delete'),(7330,3,NULL,6,'permisos_perfiles','search'),(7331,3,NULL,6,'permisos_perfiles','rcs'),(7332,3,NULL,6,'permisos_comprob','index'),(7333,3,NULL,6,'permisos_centros','index'),(7334,3,NULL,6,'magenta','index'),(7335,3,NULL,6,'console','index'),(13492,5,NULL,1,'movimiento','index'),(13493,5,NULL,1,'movimiento','buscar'),(13494,5,NULL,1,'movimiento','guardar'),(13689,9,NULL,1,'movimiento','index'),(13690,9,NULL,1,'movimiento','buscar'),(13691,9,NULL,1,'movimiento','guardar'),(13692,9,NULL,1,'consultas','index'),(13693,9,NULL,1,'balance','index'),(13694,9,NULL,1,'libro_auxiliar','index'),(13695,9,NULL,1,'movimiento_terceros','index'),(13696,9,NULL,1,'movimiento_centros','index'),(13697,9,NULL,1,'balance_centros','index'),(13698,9,NULL,1,'listado_comprob','index'),(13699,9,NULL,1,'movimiento_documentos','index'),(13700,9,NULL,1,'cartera_edades','index'),(13701,9,NULL,1,'terceros','index'),(13702,9,NULL,1,'terceros','save'),(13703,9,NULL,1,'terceros','search'),(13704,9,NULL,1,'comprobantes','index'),(13705,9,NULL,1,'comprobantes','search'),(13706,2,NULL,2,'ordenes','index'),(13707,2,NULL,2,'ordenes','new'),(13708,2,NULL,2,'ordenes','edit'),(13709,2,NULL,2,'ordenes','delete'),(13710,2,NULL,2,'ordenes','search'),(13711,2,NULL,2,'ordenes','report'),(13712,2,NULL,2,'ordenes','puedeReAbrir'),(13713,2,NULL,2,'entradas','index'),(13714,2,NULL,2,'entradas','new'),(13715,2,NULL,2,'entradas','edit'),(13716,2,NULL,2,'entradas','delete'),(13717,2,NULL,2,'entradas','search'),(13718,2,NULL,2,'entradas','report'),(13719,2,NULL,2,'salidas','index'),(13720,2,NULL,2,'salidas','new'),(13721,2,NULL,2,'salidas','edit'),(13722,2,NULL,2,'salidas','delete'),(13723,2,NULL,2,'salidas','search'),(13724,2,NULL,2,'salidas','report'),(13725,2,NULL,2,'ajustes','index'),(13726,2,NULL,2,'ajustes','new'),(13727,2,NULL,2,'ajustes','edit'),(13728,2,NULL,2,'ajustes','delete'),(13729,2,NULL,2,'ajustes','search'),(13730,2,NULL,2,'ajustes','report'),(13731,2,NULL,2,'traslados','index'),(13732,2,NULL,2,'traslados','new'),(13733,2,NULL,2,'traslados','edit'),(13734,2,NULL,2,'traslados','delete'),(13735,2,NULL,2,'traslados','search'),(13736,2,NULL,2,'traslados','report'),(13737,2,NULL,2,'fisico','index'),(13738,2,NULL,2,'fisico','consultar'),(13739,2,NULL,2,'salidas','index'),(13740,2,NULL,2,'salidas','new'),(13741,2,NULL,2,'salidas','edit'),(13742,2,NULL,2,'salidas','delete'),(13743,2,NULL,2,'salidas','search'),(13744,2,NULL,2,'salidas','report'),(13745,2,NULL,2,'salidas_buffet','index'),(13746,2,NULL,2,'salidas_buffet','new'),(13747,2,NULL,2,'salidas_buffet','edit'),(13748,2,NULL,2,'salidas_buffet','delete'),(13749,2,NULL,2,'salidas_buffet','search'),(13750,2,NULL,2,'salidas_buffet','report'),(13751,2,NULL,2,'pedidos','index'),(13752,2,NULL,2,'pedidos','new'),(13753,2,NULL,2,'pedidos','edit'),(13754,2,NULL,2,'pedidos','delete'),(13755,2,NULL,2,'pedidos','search'),(13756,2,NULL,2,'pedidos','report'),(13757,2,NULL,2,'transformaciones','index'),(13758,2,NULL,2,'transformaciones','new'),(13759,2,NULL,2,'transformaciones','edit'),(13760,2,NULL,2,'transformaciones','delete'),(13761,2,NULL,2,'transformaciones','search'),(13762,2,NULL,2,'transformaciones','report'),(13763,2,NULL,2,'kardex','index'),(13764,2,NULL,2,'saldos_almacen','index'),(13765,2,NULL,2,'saldos_almacen_consolidado','index'),(13766,2,NULL,2,'stocks','index'),(13767,2,NULL,2,'comportamiento','index'),(13768,2,NULL,2,'movimientos','index'),(13769,2,NULL,2,'consecutivos','index'),(13770,2,NULL,2,'trasunto','index'),(13771,2,NULL,2,'consumos','index'),(13772,2,NULL,2,'listado_referencias','index'),(13773,2,NULL,2,'listado_proveedores','index'),(13774,2,NULL,2,'horti','index'),(13775,2,NULL,2,'impresion','index'),(13776,2,NULL,2,'cerrar','index'),(13777,2,NULL,2,'reabrir','index'),(13778,2,NULL,2,'referencias','index'),(13779,2,NULL,2,'referencias','queryByItemAction'),(13780,2,NULL,2,'referencias','queryByNameAction'),(13781,2,NULL,2,'referencias','new'),(13782,2,NULL,2,'referencias','edit'),(13783,2,NULL,2,'referencias','delete'),(13784,2,NULL,2,'referencias','search'),(13785,2,NULL,2,'referencias','report'),(13786,2,NULL,2,'lineas','index'),(13787,2,NULL,2,'lineas','new'),(13788,2,NULL,2,'lineas','edit'),(13789,2,NULL,2,'lineas','delete'),(13790,2,NULL,2,'lineas','search'),(13791,2,NULL,2,'lineas','report'),(13792,2,NULL,2,'producto','index'),(13793,2,NULL,2,'producto','new'),(13794,2,NULL,2,'producto','edit'),(13795,2,NULL,2,'producto','delete'),(13796,2,NULL,2,'producto','search'),(13797,2,NULL,2,'producto','report'),(13798,2,NULL,2,'almacenes','index'),(13799,2,NULL,2,'almacenes','new'),(13800,2,NULL,2,'almacenes','edit'),(13801,2,NULL,2,'almacenes','delete'),(13802,2,NULL,2,'almacenes','search'),(13803,2,NULL,2,'almacenes','report'),(13804,2,NULL,2,'almacenes','import'),(13805,2,NULL,2,'centros','index'),(13806,2,NULL,2,'centros','new'),(13807,2,NULL,2,'centros','edit'),(13808,2,NULL,2,'centros','delete'),(13809,2,NULL,2,'centros','search'),(13810,2,NULL,2,'centros','report'),(13811,2,NULL,2,'centros','import'),(13812,2,NULL,2,'formapago','index'),(13813,2,NULL,2,'formapago','new'),(13814,2,NULL,2,'formapago','edit'),(13815,2,NULL,2,'formapago','delete'),(13816,2,NULL,2,'formapago','search'),(13817,2,NULL,2,'formapago','report'),(13818,2,NULL,2,'formapago','import'),(13819,2,NULL,2,'terceros','index'),(13820,2,NULL,2,'terceros','new'),(13821,2,NULL,2,'terceros','edit'),(13822,2,NULL,2,'terceros','delete'),(13823,2,NULL,2,'terceros','search'),(13824,2,NULL,2,'terceros','report'),(13825,2,NULL,2,'terceros','import'),(13826,2,NULL,2,'matriz_proveedores','index'),(13827,2,NULL,2,'criterios','index'),(13828,2,NULL,2,'criterios','new'),(13829,2,NULL,2,'criterios','edit'),(13830,2,NULL,2,'criterios','delete'),(13831,2,NULL,2,'criterios','search'),(13832,2,NULL,2,'criterios','report'),(13833,2,NULL,2,'criterios','import'),(13834,2,NULL,2,'unidades','index'),(13835,2,NULL,2,'unidades','new'),(13836,2,NULL,2,'unidades','edit'),(13837,2,NULL,2,'unidades','delete'),(13838,2,NULL,2,'unidades','search'),(13839,2,NULL,2,'unidades','report'),(13840,2,NULL,2,'unidades','import'),(13841,2,NULL,2,'magnitudes','index'),(13842,2,NULL,2,'magnitudes','new'),(13843,2,NULL,2,'magnitudes','edit'),(13844,2,NULL,2,'magnitudes','delete'),(13845,2,NULL,2,'magnitudes','search'),(13846,2,NULL,2,'magnitudes','report'),(13847,2,NULL,2,'magnitudes','import'),(13848,2,NULL,2,'conversion','index'),(13849,2,NULL,2,'conversion','new'),(13850,2,NULL,2,'conversion','edit'),(13851,2,NULL,2,'conversion','delete'),(13852,2,NULL,2,'conversion','search'),(13853,2,NULL,2,'conversion','report'),(13854,2,NULL,2,'conversion','import'),(13855,2,NULL,2,'cuentas','index'),(13856,2,NULL,2,'cuentas','queryCuenta'),(13857,2,NULL,2,'regimen_cuentas','index'),(13858,2,NULL,2,'regimen_cuentas','new'),(13859,2,NULL,2,'regimen_cuentas','edit'),(13860,2,NULL,2,'regimen_cuentas','delete'),(13861,2,NULL,2,'regimen_cuentas','search'),(13862,2,NULL,2,'regimen_cuentas','report'),(13863,2,NULL,2,'regimen_cuentas','import'),(13864,2,NULL,2,'consumos_internos','index'),(13865,2,NULL,2,'consumos_internos','new'),(13866,2,NULL,2,'consumos_internos','edit'),(13867,2,NULL,2,'consumos_internos','delete'),(13868,2,NULL,2,'consumos_internos','search'),(13869,2,NULL,2,'consumos_internos','report'),(13870,2,NULL,2,'retecompras','index'),(13871,2,NULL,2,'retecompras','save'),(13872,2,NULL,2,'retecompras','delete'),(13873,2,NULL,2,'retecompras','search'),(13874,2,NULL,2,'retecompras','rcs'),(13875,2,NULL,2,'settings','index'),(13876,2,NULL,2,'settings','save'),(14513,2,NULL,2,'movinventario','index'),(14515,7,NULL,2,'movinventario','index'),(14728,2,NULL,2,'docsop_resolucion','index'),(14730,7,NULL,2,'docsop_resolucion','index'),(15473,10,NULL,2,'ordenes','index'),(15474,10,NULL,2,'ordenes','new'),(15475,10,NULL,2,'ordenes','search'),(15476,10,NULL,2,'ordenes','report'),(15477,10,NULL,2,'ordenes','puedeReAbrir'),(15478,10,NULL,2,'entradas','index'),(15479,10,NULL,2,'entradas','new'),(15480,10,NULL,2,'entradas','search'),(15481,10,NULL,2,'entradas','report'),(15482,10,NULL,2,'salidas','index'),(15483,10,NULL,2,'salidas','new'),(15484,10,NULL,2,'salidas','search'),(15485,10,NULL,2,'salidas','report'),(15486,10,NULL,2,'ajustes','new'),(15487,10,NULL,2,'ajustes','edit'),(15488,10,NULL,2,'ajustes','search'),(15489,10,NULL,2,'ajustes','report'),(15490,10,NULL,2,'traslados','new'),(15491,10,NULL,2,'traslados','edit'),(15492,10,NULL,2,'traslados','delete'),(15493,10,NULL,2,'traslados','search'),(15494,10,NULL,2,'traslados','report'),(15495,10,NULL,2,'fisico','index'),(15496,10,NULL,2,'fisico','consultar'),(15497,10,NULL,2,'docsop','index'),(15498,10,NULL,2,'docsop','save'),(15499,10,NULL,2,'salidas','index'),(15500,10,NULL,2,'salidas','new'),(15501,10,NULL,2,'salidas','search'),(15502,10,NULL,2,'salidas','report'),(15503,10,NULL,2,'salidas_buffet','index'),(15504,10,NULL,2,'salidas_buffet','new'),(15505,10,NULL,2,'salidas_buffet','search'),(15506,10,NULL,2,'salidas_buffet','report'),(15507,10,NULL,2,'pedidos','index'),(15508,10,NULL,2,'pedidos','new'),(15509,10,NULL,2,'pedidos','search'),(15510,10,NULL,2,'pedidos','report'),(15511,10,NULL,2,'transformaciones','new'),(15512,10,NULL,2,'transformaciones','edit'),(15513,10,NULL,2,'transformaciones','delete'),(15514,10,NULL,2,'transformaciones','search'),(15515,10,NULL,2,'transformaciones','report'),(15516,10,NULL,2,'kardex','index'),(15517,10,NULL,2,'saldos_almacen','index'),(15518,10,NULL,2,'saldos_almacen_consolidado','index'),(15519,10,NULL,2,'stocks','index'),(15520,10,NULL,2,'comportamiento','index'),(15521,10,NULL,2,'movimientos','index'),(15522,10,NULL,2,'consecutivos','index'),(15523,10,NULL,2,'trasunto','index'),(15524,10,NULL,2,'consumos','index'),(15525,10,NULL,2,'listado_referencias','index'),(15526,10,NULL,2,'listado_proveedores','index'),(15527,10,NULL,2,'horti','index'),(15528,10,NULL,2,'movinventario','index'),(15529,10,NULL,2,'impresion','index'),(15530,10,NULL,2,'cerrar','index'),(15531,10,NULL,2,'reabrir','index'),(15532,10,NULL,2,'referencias','index'),(15533,10,NULL,2,'referencias','queryByItemAction'),(15534,10,NULL,2,'referencias','queryByNameAction'),(15535,10,NULL,2,'referencias','new'),(15536,10,NULL,2,'referencias','edit'),(15537,10,NULL,2,'referencias','search'),(15538,10,NULL,2,'referencias','report'),(15539,10,NULL,2,'lineas','index'),(15540,10,NULL,2,'lineas','search'),(15541,10,NULL,2,'lineas','report'),(15542,10,NULL,2,'producto','index'),(15543,10,NULL,2,'producto','search'),(15544,10,NULL,2,'producto','report'),(15545,10,NULL,2,'almacenes','index'),(15546,10,NULL,2,'almacenes','search'),(15547,10,NULL,2,'almacenes','report'),(15548,10,NULL,2,'almacenes','import'),(15549,10,NULL,2,'centros','index'),(15550,10,NULL,2,'centros','search'),(15551,10,NULL,2,'centros','report'),(15552,10,NULL,2,'centros','import'),(15553,10,NULL,2,'formapago','index'),(15554,10,NULL,2,'formapago','search'),(15555,10,NULL,2,'formapago','report'),(15556,10,NULL,2,'formapago','import'),(15557,10,NULL,2,'terceros','index'),(15558,10,NULL,2,'terceros','search'),(15559,10,NULL,2,'terceros','report'),(15560,10,NULL,2,'terceros','import'),(15561,10,NULL,2,'matriz_proveedores','index'),(15562,10,NULL,2,'criterios','index'),(15563,10,NULL,2,'criterios','search'),(15564,10,NULL,2,'criterios','report'),(15565,10,NULL,2,'criterios','import'),(15566,10,NULL,2,'unidades','index'),(15567,10,NULL,2,'unidades','search'),(15568,10,NULL,2,'unidades','report'),(15569,10,NULL,2,'unidades','import'),(15570,10,NULL,2,'magnitudes','index'),(15571,10,NULL,2,'magnitudes','search'),(15572,10,NULL,2,'magnitudes','report'),(15573,10,NULL,2,'magnitudes','import'),(15574,10,NULL,2,'conversion','index'),(15575,10,NULL,2,'conversion','search'),(15576,10,NULL,2,'conversion','report'),(15577,10,NULL,2,'conversion','import'),(15578,10,NULL,2,'cuentas','index'),(15579,10,NULL,2,'cuentas','queryCuenta'),(15580,10,NULL,2,'regimen_cuentas','index'),(15581,10,NULL,2,'regimen_cuentas','search'),(15582,10,NULL,2,'regimen_cuentas','report'),(15583,10,NULL,2,'regimen_cuentas','import'),(15584,10,NULL,2,'consumos_internos','index'),(15585,10,NULL,2,'consumos_internos','new'),(15586,10,NULL,2,'consumos_internos','search'),(15587,10,NULL,2,'consumos_internos','report'),(15588,10,NULL,2,'retecompras','index'),(15589,10,NULL,2,'retecompras','search'),(15590,10,NULL,2,'retecompras','rcs'),(15591,10,NULL,2,'settings','save'),(15592,10,NULL,2,'docsop_resolucion','index'),(15810,8,NULL,1,'movimiento','index'),(15811,8,NULL,1,'movimiento','buscar'),(15812,8,NULL,1,'movimiento','guardar'),(15813,8,NULL,1,'movimiento','cambiarFecha'),(15814,8,NULL,1,'movimiento','copiar'),(15815,8,NULL,1,'consultas','index'),(15816,8,NULL,1,'incluir','index'),(15817,8,NULL,1,'aura','save'),(15818,8,NULL,1,'aura','getComprobByDate'),(15819,8,NULL,1,'balance','index'),(15820,8,NULL,1,'libro_auxiliar','index'),(15821,8,NULL,1,'consecutivos','index'),(15822,8,NULL,1,'movimiento_terceros','index'),(15823,8,NULL,1,'movimiento_centros','index'),(15824,8,NULL,1,'balance_centros','index'),(15825,8,NULL,1,'comprobante_diario','index'),(15826,8,NULL,1,'listado_movimiento','index'),(15827,8,NULL,1,'listado_retencion','index'),(15828,8,NULL,1,'listado_comprob','index'),(15829,8,NULL,1,'retencion','index'),(15830,8,NULL,1,'balance_general','index'),(15831,8,NULL,1,'libro_diario','index'),(15832,8,NULL,1,'libro_mayor','index'),(15833,8,NULL,1,'libro_terceros','index'),(15834,8,NULL,1,'numeracion','index'),(15835,8,NULL,1,'certificado_retencion','index'),(15836,8,NULL,1,'certificado_iva','index'),(15837,8,NULL,1,'certificado_ica','index'),(15838,8,NULL,1,'pyg','index'),(15839,8,NULL,1,'caratulas','index'),(15840,8,NULL,1,'movimiento_documentos','index'),(15841,8,NULL,1,'cartera_edades','index'),(15842,8,NULL,1,'activos','index'),(15843,8,NULL,1,'activos','save'),(15844,8,NULL,1,'activos','delete'),(15845,8,NULL,1,'activos','search'),(15846,8,NULL,1,'activos','rcs'),(15847,8,NULL,1,'grupos','index'),(15848,8,NULL,1,'grupos','save'),(15849,8,NULL,1,'grupos','delete'),(15850,8,NULL,1,'grupos','search'),(15851,8,NULL,1,'grupos','rcs'),(15852,8,NULL,1,'tipos_activos','index'),(15853,8,NULL,1,'tipos_activos','save'),(15854,8,NULL,1,'tipos_activos','delete'),(15855,8,NULL,1,'tipos_activos','search'),(15856,8,NULL,1,'tipos_activos','rcs'),(15857,8,NULL,1,'ubicacion','index'),(15858,8,NULL,1,'ubicacion','save'),(15859,8,NULL,1,'ubicacion','delete'),(15860,8,NULL,1,'ubicacion','search'),(15861,8,NULL,1,'ubicacion','rcs'),(15862,8,NULL,1,'depreciacion','index'),(15863,8,NULL,1,'anular_depreciacion','index'),(15864,8,NULL,1,'traslado_activos','index'),(15865,8,NULL,1,'novedad_activos','index'),(15866,8,NULL,1,'consulta_depreciacion','index'),(15867,8,NULL,1,'ordenes','index'),(15868,8,NULL,1,'refe','index'),(15869,8,NULL,1,'refe','save'),(15870,8,NULL,1,'refe','delete'),(15871,8,NULL,1,'refe','search'),(15872,8,NULL,1,'refe','rcs'),(15873,8,NULL,1,'lineaser','index'),(15874,8,NULL,1,'lineaser','save'),(15875,8,NULL,1,'lineaser','delete'),(15876,8,NULL,1,'lineaser','search'),(15877,8,NULL,1,'lineaser','rcs'),(15878,8,NULL,1,'presupuesto','index'),(15879,8,NULL,1,'ejecucion_pres','index'),(15880,8,NULL,1,'recibo_caja','index'),(15881,8,NULL,1,'recibo_caja','buscar'),(15882,8,NULL,1,'recibo_caja','ver'),(15883,8,NULL,1,'recibo_caja','nuevo'),(15884,8,NULL,1,'recibo_caja','generar'),(15885,8,NULL,1,'recibo_caja','anular'),(15886,8,NULL,1,'recibo_caja','imprimir'),(15887,8,NULL,1,'cheque','index'),(15888,8,NULL,1,'chequeras','index'),(15889,8,NULL,1,'chequeras','save'),(15890,8,NULL,1,'chequeras','delete'),(15891,8,NULL,1,'chequeras','search'),(15892,8,NULL,1,'chequeras','rcs'),(15893,8,NULL,1,'cuentas_bancos','index'),(15894,8,NULL,1,'cuentas_bancos','save'),(15895,8,NULL,1,'cuentas_bancos','delete'),(15896,8,NULL,1,'cuentas_bancos','search'),(15897,8,NULL,1,'cuentas_bancos','rcs'),(15898,8,NULL,1,'banco','index'),(15899,8,NULL,1,'banco','save'),(15900,8,NULL,1,'banco','delete'),(15901,8,NULL,1,'banco','search'),(15902,8,NULL,1,'banco','rcs'),(15903,8,NULL,1,'formato_cheque','index'),(15904,8,NULL,1,'medios','index'),(15905,8,NULL,1,'campos_medios','index'),(15906,8,NULL,1,'codigos_medios','index'),(15907,8,NULL,1,'codigos_medios','save'),(15908,8,NULL,1,'codigos_medios','delete'),(15909,8,NULL,1,'codigos_medios','search'),(15910,8,NULL,1,'codigos_medios','rcs'),(15911,8,NULL,1,'diferidos','index'),(15912,8,NULL,1,'diferidos','save'),(15913,8,NULL,1,'diferidos','delete'),(15914,8,NULL,1,'diferidos','search'),(15915,8,NULL,1,'diferidos','rcs'),(15916,8,NULL,1,'grupos_diferidos','index'),(15917,8,NULL,1,'grupos_diferidos','save'),(15918,8,NULL,1,'grupos_diferidos','delete'),(15919,8,NULL,1,'grupos_diferidos','search'),(15920,8,NULL,1,'grupos_diferidos','rcs'),(15921,8,NULL,1,'amortizacion','index'),(15922,8,NULL,1,'consulta_causacion','index'),(15923,8,NULL,1,'interface_siigo','index'),(15924,8,NULL,1,'cierre_contable','index'),(15925,8,NULL,1,'reabrir_mes','index'),(15926,8,NULL,1,'cierre_cuentas','index'),(15927,8,NULL,1,'reabrir_cuentas','index'),(15928,8,NULL,1,'comprobante_cierre','index'),(15929,8,NULL,1,'cierre_anual','index'),(15930,8,NULL,1,'reabrir_ano','index'),(15931,8,NULL,1,'niif','index'),(15932,8,NULL,1,'niif','search'),(15933,8,NULL,1,'niif','rcs'),(15934,8,NULL,1,'nic','index'),(15935,8,NULL,1,'nic','search'),(15936,8,NULL,1,'nic','rcs'),(15937,8,NULL,1,'cuentas','index'),(15938,8,NULL,1,'cuentas','queryCuenta'),(15939,8,NULL,1,'terceros','index'),(15940,8,NULL,1,'terceros','search'),(15941,8,NULL,1,'terceros','rcs'),(15942,8,NULL,1,'tipodoc','index'),(15943,8,NULL,1,'tipodoc','search'),(15944,8,NULL,1,'tipodoc','rcs'),(15945,8,NULL,1,'comprobantes','index'),(15946,8,NULL,1,'comprobantes','search'),(15947,8,NULL,1,'comprobantes','rcs'),(15948,8,NULL,1,'diarios','index'),(15949,8,NULL,1,'diarios','search'),(15950,8,NULL,1,'diarios','rcs'),(15951,8,NULL,1,'documentos','index'),(15952,8,NULL,1,'documentos','search'),(15953,8,NULL,1,'documentos','rcs'),(15954,8,NULL,1,'formapago','index'),(15955,8,NULL,1,'formapago','search'),(15956,8,NULL,1,'formapago','rcs'),(15957,8,NULL,1,'regimen_cuentas','index'),(15958,8,NULL,1,'regimen_cuentas','search'),(15959,8,NULL,1,'regimen_cuentas','rcs'),(15960,8,NULL,1,'ica','index'),(15961,8,NULL,1,'ica','search'),(15962,8,NULL,1,'ica','rcs'),(15963,8,NULL,1,'comcier','index'),(15964,8,NULL,1,'comcier','save'),(15965,8,NULL,1,'comcier','search'),(15966,8,NULL,1,'comcier','rcs'),(15967,8,NULL,1,'cuentas_cree','save'),(15968,8,NULL,1,'cuentas_cree','delete'),(15969,8,NULL,1,'cuentas_cree','search'),(15970,8,NULL,1,'cuentas_cree','rcs'),(15971,8,NULL,1,'centros','index'),(15972,8,NULL,1,'centros','search'),(15973,8,NULL,1,'centros','rcs'),(15974,8,NULL,1,'settings','index'),(15975,8,NULL,1,'settings','save'),(15976,8,NULL,1,'docsop','index'),(15977,8,NULL,1,'docsop','save'),(17068,1,NULL,1,'movimiento','index'),(17069,1,NULL,1,'movimiento','buscar'),(17070,1,NULL,1,'movimiento','guardar'),(17071,1,NULL,1,'movimiento','eliminar'),(17072,1,NULL,1,'movimiento','cambiarFecha'),(17073,1,NULL,1,'movimiento','copiar'),(17074,1,NULL,1,'movimiento_niif','index'),(17075,1,NULL,1,'movimiento_niif','buscar'),(17076,1,NULL,1,'movimiento_niif','guardar'),(17077,1,NULL,1,'movimiento_niif','eliminar'),(17078,1,NULL,1,'movimiento_niif','cambiarFecha'),(17079,1,NULL,1,'movimiento_niif','copiar'),(17080,1,NULL,1,'consultas','index'),(17081,1,NULL,1,'cambio_nit','index'),(17082,1,NULL,1,'incluir','index'),(17083,1,NULL,1,'excluir','index'),(17084,1,NULL,1,'aura','index'),(17085,1,NULL,1,'aura','save'),(17086,1,NULL,1,'aura','getComprobByDate'),(17087,1,NULL,1,'movimiento_dian','index'),(17088,1,NULL,1,'balance','index'),(17089,1,NULL,1,'informe_balance_consolidado','index'),(17090,1,NULL,1,'libro_auxiliar','index'),(17091,1,NULL,1,'consecutivos','index'),(17092,1,NULL,1,'movimiento_terceros','index'),(17093,1,NULL,1,'movimiento_centros','index'),(17094,1,NULL,1,'balance_centros','index'),(17095,1,NULL,1,'comprobante_diario','index'),(17096,1,NULL,1,'listado_movimiento','index'),(17097,1,NULL,1,'listado_retencion','index'),(17098,1,NULL,1,'listado_comprob','index'),(17099,1,NULL,1,'retencion','index'),(17100,1,NULL,1,'balance_general','index'),(17101,1,NULL,1,'libro_diario','index'),(17102,1,NULL,1,'libro_mayor','index'),(17103,1,NULL,1,'libro_terceros','index'),(17104,1,NULL,1,'numeracion','index'),(17105,1,NULL,1,'certificado_retencion','index'),(17106,1,NULL,1,'certificado_iva','index'),(17107,1,NULL,1,'certificado_ica','index'),(17108,1,NULL,1,'pyg','index'),(17109,1,NULL,1,'caratulas','index'),(17110,1,NULL,1,'movimiento_documentos','index'),(17111,1,NULL,1,'cartera_edades','index'),(17112,1,NULL,1,'corregir_cartera','index'),(17113,1,NULL,1,'activos','index'),(17114,1,NULL,1,'activos','save'),(17115,1,NULL,1,'activos','delete'),(17116,1,NULL,1,'activos','search'),(17117,1,NULL,1,'activos','rcs'),(17118,1,NULL,1,'grupos','index'),(17119,1,NULL,1,'grupos','save'),(17120,1,NULL,1,'grupos','delete'),(17121,1,NULL,1,'grupos','search'),(17122,1,NULL,1,'grupos','rcs'),(17123,1,NULL,1,'tipos_activos','index'),(17124,1,NULL,1,'tipos_activos','save'),(17125,1,NULL,1,'tipos_activos','delete'),(17126,1,NULL,1,'tipos_activos','search'),(17127,1,NULL,1,'tipos_activos','rcs'),(17128,1,NULL,1,'ubicacion','index'),(17129,1,NULL,1,'ubicacion','save'),(17130,1,NULL,1,'ubicacion','delete'),(17131,1,NULL,1,'ubicacion','search'),(17132,1,NULL,1,'ubicacion','rcs'),(17133,1,NULL,1,'depreciacion','index'),(17134,1,NULL,1,'anular_depreciacion','index'),(17135,1,NULL,1,'traslado_activos','index'),(17136,1,NULL,1,'novedad_activos','index'),(17137,1,NULL,1,'consulta_depreciacion','index'),(17138,1,NULL,1,'ordenes','index'),(17139,1,NULL,1,'refe','index'),(17140,1,NULL,1,'refe','save'),(17141,1,NULL,1,'refe','delete'),(17142,1,NULL,1,'refe','search'),(17143,1,NULL,1,'refe','rcs'),(17144,1,NULL,1,'lineaser','index'),(17145,1,NULL,1,'lineaser','save'),(17146,1,NULL,1,'lineaser','delete'),(17147,1,NULL,1,'lineaser','search'),(17148,1,NULL,1,'lineaser','rcs'),(17149,1,NULL,1,'presupuesto','index'),(17150,1,NULL,1,'ejecucion_pres','index'),(17151,1,NULL,1,'recibo_caja','index'),(17152,1,NULL,1,'recibo_caja','buscar'),(17153,1,NULL,1,'recibo_caja','ver'),(17154,1,NULL,1,'recibo_caja','nuevo'),(17155,1,NULL,1,'recibo_caja','generar'),(17156,1,NULL,1,'recibo_caja','anular'),(17157,1,NULL,1,'recibo_caja','imprimir'),(17158,1,NULL,1,'cheque','index'),(17159,1,NULL,1,'chequeras','index'),(17160,1,NULL,1,'chequeras','save'),(17161,1,NULL,1,'chequeras','delete'),(17162,1,NULL,1,'chequeras','search'),(17163,1,NULL,1,'chequeras','rcs'),(17164,1,NULL,1,'cuentas_bancos','index'),(17165,1,NULL,1,'cuentas_bancos','save'),(17166,1,NULL,1,'cuentas_bancos','delete'),(17167,1,NULL,1,'cuentas_bancos','search'),(17168,1,NULL,1,'cuentas_bancos','rcs'),(17169,1,NULL,1,'banco','index'),(17170,1,NULL,1,'banco','save'),(17171,1,NULL,1,'banco','delete'),(17172,1,NULL,1,'banco','search'),(17173,1,NULL,1,'banco','rcs'),(17174,1,NULL,1,'formato_cheque','index'),(17175,1,NULL,1,'medios','index'),(17176,1,NULL,1,'campos_medios','index'),(17177,1,NULL,1,'codigos_medios','index'),(17178,1,NULL,1,'codigos_medios','save'),(17179,1,NULL,1,'codigos_medios','delete'),(17180,1,NULL,1,'codigos_medios','search'),(17181,1,NULL,1,'codigos_medios','rcs'),(17182,1,NULL,1,'nuevos_formatos_medios','index'),(17183,1,NULL,1,'nuevos_formatos_medios','save'),(17184,1,NULL,1,'nuevos_formatos_medios','delete'),(17185,1,NULL,1,'nuevos_formatos_medios','search'),(17186,1,NULL,1,'nuevos_formatos_medios','rcs'),(17187,1,NULL,1,'diferidos','index'),(17188,1,NULL,1,'diferidos','save'),(17189,1,NULL,1,'diferidos','delete'),(17190,1,NULL,1,'diferidos','search'),(17191,1,NULL,1,'diferidos','rcs'),(17192,1,NULL,1,'grupos_diferidos','index'),(17193,1,NULL,1,'grupos_diferidos','save'),(17194,1,NULL,1,'grupos_diferidos','delete'),(17195,1,NULL,1,'grupos_diferidos','search'),(17196,1,NULL,1,'grupos_diferidos','rcs'),(17197,1,NULL,1,'amortizacion','index'),(17198,1,NULL,1,'consulta_causacion','index'),(17199,1,NULL,1,'interface_siigo','index'),(17200,1,NULL,1,'interface_sinco','index'),(17201,1,NULL,1,'cierre_contable','index'),(17202,1,NULL,1,'reabrir_mes','index'),(17203,1,NULL,1,'cierre_cuentas','index'),(17204,1,NULL,1,'reabrir_cuentas','index'),(17205,1,NULL,1,'comprobante_cierre','index'),(17206,1,NULL,1,'cierre_anual','index'),(17207,1,NULL,1,'reabrir_ano','index'),(17208,1,NULL,1,'niif','index'),(17209,1,NULL,1,'niif','save'),(17210,1,NULL,1,'niif','delete'),(17211,1,NULL,1,'niif','search'),(17212,1,NULL,1,'niif','rcs'),(17213,1,NULL,1,'nic','index'),(17214,1,NULL,1,'nic','save'),(17215,1,NULL,1,'nic','delete'),(17216,1,NULL,1,'nic','search'),(17217,1,NULL,1,'nic','rcs'),(17218,1,NULL,1,'cuentas','index'),(17219,1,NULL,1,'cuentas','queryCuenta'),(17220,1,NULL,1,'terceros','index'),(17221,1,NULL,1,'terceros','save'),(17222,1,NULL,1,'terceros','delete'),(17223,1,NULL,1,'terceros','search'),(17224,1,NULL,1,'terceros','rcs'),(17225,1,NULL,1,'tipodoc','index'),(17226,1,NULL,1,'tipodoc','save'),(17227,1,NULL,1,'tipodoc','delete'),(17228,1,NULL,1,'tipodoc','search'),(17229,1,NULL,1,'tipodoc','rcs'),(17230,1,NULL,1,'comprobantes','index'),(17231,1,NULL,1,'comprobantes','save'),(17232,1,NULL,1,'comprobantes','delete'),(17233,1,NULL,1,'comprobantes','search'),(17234,1,NULL,1,'comprobantes','rcs'),(17235,1,NULL,1,'diarios','index'),(17236,1,NULL,1,'diarios','save'),(17237,1,NULL,1,'diarios','delete'),(17238,1,NULL,1,'diarios','search'),(17239,1,NULL,1,'diarios','rcs'),(17240,1,NULL,1,'documentos','index'),(17241,1,NULL,1,'documentos','save'),(17242,1,NULL,1,'documentos','delete'),(17243,1,NULL,1,'documentos','search'),(17244,1,NULL,1,'documentos','rcs'),(17245,1,NULL,1,'formapago','index'),(17246,1,NULL,1,'formapago','save'),(17247,1,NULL,1,'formapago','delete'),(17248,1,NULL,1,'formapago','search'),(17249,1,NULL,1,'formapago','rcs'),(17250,1,NULL,1,'regimen_cuentas','index'),(17251,1,NULL,1,'regimen_cuentas','save'),(17252,1,NULL,1,'regimen_cuentas','delete'),(17253,1,NULL,1,'regimen_cuentas','search'),(17254,1,NULL,1,'regimen_cuentas','rcs'),(17255,1,NULL,1,'ica','index'),(17256,1,NULL,1,'ica','save'),(17257,1,NULL,1,'ica','delete'),(17258,1,NULL,1,'ica','search'),(17259,1,NULL,1,'ica','rcs'),(17260,1,NULL,1,'comcier','index'),(17261,1,NULL,1,'comcier','save'),(17262,1,NULL,1,'comcier','delete'),(17263,1,NULL,1,'comcier','search'),(17264,1,NULL,1,'comcier','rcs'),(17265,1,NULL,1,'cuentas_cree','index'),(17266,1,NULL,1,'cuentas_cree','save'),(17267,1,NULL,1,'cuentas_cree','delete'),(17268,1,NULL,1,'cuentas_cree','search'),(17269,1,NULL,1,'cuentas_cree','rcs'),(17270,1,NULL,1,'centros','index'),(17271,1,NULL,1,'centros','save'),(17272,1,NULL,1,'centros','delete'),(17273,1,NULL,1,'centros','search'),(17274,1,NULL,1,'centros','rcs'),(17275,1,NULL,1,'consolidados','index'),(17276,1,NULL,1,'consolidados','save'),(17277,1,NULL,1,'consolidados','delete'),(17278,1,NULL,1,'consolidados','search'),(17279,1,NULL,1,'consolidados','rcs'),(17280,1,NULL,1,'settings','index'),(17281,1,NULL,1,'settings','save'),(17282,1,NULL,1,'docsop_resolucion','index'),(17283,1,NULL,1,'docsop_resolucion','save'),(17284,1,NULL,1,'docsop','index'),(17285,1,NULL,1,'docsop','save'),(17286,4,NULL,2,'pedidos','index'),(17287,4,NULL,2,'pedidos','new'),(17288,4,NULL,2,'pedidos','search'),(17289,4,NULL,2,'pedidos','report'),(17290,4,NULL,2,'kardex','index'),(17291,4,NULL,2,'saldos_almacen','index'),(17292,4,NULL,2,'movinventario','index'),(17293,4,NULL,2,'docsop_resolucion','index');

--
-- Table structure for table `perfiles_usuarios`
--

CREATE TABLE `perfiles_usuarios` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `usuarios_id` int unsigned NOT NULL,
  `perfiles_id` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `perfiles_id` (`perfiles_id`,`usuarios_id`)
) ENGINE=InnoDB AUTO_INCREMENT=505 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `perfiles_usuarios`
--

INSERT INTO `perfiles_usuarios` VALUES (457,1,1),(34,2,1),(345,3,1),(40,4,1),(196,5,1),(198,6,1),(65,7,1),(201,8,1),(206,12,1),(348,13,1),(212,14,1),(216,16,1),(223,18,1),(226,19,1),(231,20,1),(235,21,1),(238,22,1),(242,23,1),(264,34,1),(297,43,1),(405,46,1),(354,49,1),(357,50,1),(366,51,1),(436,52,1),(460,53,1),(408,56,1),(438,57,1),(434,58,1),(453,60,1),(455,61,1),(468,68,1),(474,69,1),(477,70,1),(483,71,1),(499,73,1),(502,74,1),(458,1,2),(35,2,2),(346,3,2),(41,4,2),(197,5,2),(199,6,2),(66,7,2),(202,8,2),(207,12,2),(349,13,2),(217,16,2),(224,18,2),(227,19,2),(232,20,2),(236,21,2),(239,22,2),(243,23,2),(265,34,2),(344,36,2),(406,46,2),(355,49,2),(358,50,2),(367,51,2),(437,52,2),(461,53,2),(409,56,2),(439,57,2),(435,58,2),(454,60,2),(456,61,2),(469,68,2),(475,69,2),(478,70,2),(484,71,2),(500,73,2),(503,74,2),(459,1,3),(36,2,3),(347,3,3),(42,4,3),(200,6,3),(208,12,3),(350,13,3),(218,16,3),(225,18,3),(233,20,3),(237,21,3),(240,22,3),(298,43,3),(407,46,3),(356,49,3),(359,50,3),(368,51,3),(462,53,3),(476,69,3),(479,70,3),(485,71,3),(495,72,3),(501,73,3),(504,74,3),(251,24,4),(245,25,4),(246,26,4),(247,27,4),(249,28,4),(289,35,4),(272,38,4),(292,41,4),(296,42,4),(301,45,4),(401,55,4),(463,62,4),(464,63,4),(465,64,4),(466,65,4),(467,66,4),(470,67,4),(250,24,5),(252,29,5),(254,30,5),(258,31,5),(256,32,5),(257,33,5),(291,40,5),(279,37,8),(290,39,8),(420,54,8),(442,59,8),(493,72,8),(299,44,9),(324,47,9),(421,54,10),(443,59,10),(494,72,10);

--
-- Table structure for table `permisos`
--

CREATE TABLE `permisos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `codigo` char(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `aplicativos_id` int unsigned NOT NULL,
  `nombre` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `tipo` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `permisos_id` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `permisos`
--


--
-- Table structure for table `sesiones`
--

CREATE TABLE `sesiones` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `sid` char(35) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `usuarios_id` int unsigned NOT NULL,
  `ipaddress` char(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `creado` int unsigned NOT NULL,
  `modificado` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sid` (`sid`),
  KEY `usuarios_id` (`usuarios_id`),
  CONSTRAINT `sesiones_ibfk_1` FOREIGN KEY (`usuarios_id`) REFERENCES `usuarios` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5324 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sesiones`
--

INSERT INTO `sesiones` VALUES (5307,'daa287a9e1ca480c90149caf19eb6ea6',69,'127.0.0.1',1723036496,1723036496),(5308,'34a3c44ae4fe67572b76edaab1ea9926',69,'127.0.0.1',1723127259,1723145123),(5309,'ee86ad5531ca16b78446f4dc1baafb2b',1,'127.0.0.1',1723549509,1724419018),(5311,'ff9aad2cc470909fd58bcc666f479bd6',71,'127.0.0.1',1723569380,1723569380),(5323,'327e9c69c0ce1429d2a1d515a602d916',74,'127.0.0.1',1724447163,1724447163);

--
-- Table structure for table `sucursal`
--

CREATE TABLE `sucursal` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(70) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `predeterminado` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'N',
  PRIMARY KEY (`id`),
  KEY `predeterminado` (`predeterminado`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sucursal`
--

INSERT INTO `sucursal` VALUES (1,'EL HOTEL','S'),(2,'RESERVAS','S');

--
-- Table structure for table `usuarios`
--

CREATE TABLE `usuarios` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `sucursal_id` int unsigned NOT NULL,
  `login` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `clave` char(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `clave_corta` char(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fingerprint` char(48) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `apellidos` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `nombres` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `nombre_completo` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(70) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `genero` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `usuarios_front_id` int unsigned DEFAULT NULL,
  `usuarios_pos_id` int unsigned DEFAULT NULL,
  `clave_fecha` date DEFAULT NULL,
  `creado_at` datetime DEFAULT NULL,
  `estado` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `login` (`login`),
  KEY `fingerprint` (`fingerprint`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `usuarios`
--

INSERT INTO `usuarios` VALUES (1,1,'admin','7c87806da77dfb2ff5fc22e84b0a86d032a70289',NULL,'43FE81B0994019ED811355170AB7CF3FFA1F1D9F35999685','Solution','Administrador','ADMINISTRADOR SOLUTION','admin@bhteck.com','M',1,NULL,'2010-07-05','2010-07-05 00:21:51','A'),(69,1,'contausaquen','2fa99571e21ac7a6fe2328dc5327ce2e5bde7cf2',NULL,'3AD6298937CD121CAD39DD8BD12BE12ECC976518682618DC','usaquen','contabilidad','CONTABILIDAD USAQUEN',NULL,'M',1,NULL,NULL,'2024-06-27 07:15:28','A'),(70,1,'calusaquen','39091ae797d9ebd6bc7af12c24a09667b4f5ec48',NULL,'9C0CC82E6009792E6481B4E4B8135E6DCB334890FEED7310','usaquen','inventarios','INVENTARIOS USAQUEN',NULL,'M',1,NULL,NULL,'2024-06-27 16:43:03','A'),(71,1,'1115861078','771f23f215ef02e7782e3cf82a423113a322c032',NULL,'924FEB11F2C7CC7D0BBC48F95167CAADB06A027726547A2B','jeison','jeison','JEISON JEISON',NULL,'M',1,NULL,NULL,'2024-08-13 06:45:48','A'),(72,1,'1014197187','6da2c97e79c477842f866f578cc86df9697ea840',NULL,'931AA9843AACBEF3C4B194F515C8F767CB1F933C137ECCD9','ORREGO CONTRERAS','KATHERIN MAYERLY','KATHERIN MAYERLY ORREGO CONTRERAS','contabilidad.74@hotelesilar.com','F',4,NULL,NULL,'2024-08-23 15:54:49','A'),(73,1,'1007491663','2ad51dd0dcfed6a30946ee66ad40342053e2e0d0',NULL,'7AD66A63182632C5A61FBF8B976D2AC4D0F1288D8D0FFCB3','FUENTES MARIN','JUAN DAVID','JUAN DAVID FUENTES MARIN','proveedores@calu.com.co','M',1,NULL,NULL,'2024-08-23 15:57:58','A'),(74,1,'19492634','770ef90192d23cab3d24f6a77c69b361835445a1',NULL,'8CD9C78DB5D8D2FA63F76B3D29C757A0015EC46EF047953A','ALTUZARRA AMADO','RODOLFO FRANCISCO','RODOLFO FRANCISCO ALTUZARRA AMADO','pachoaltu34@yahoo.com.co','M',1,NULL,NULL,'2024-08-23 16:05:08','A');

--
-- Dumping routines for database 'iilar74'
--


