--
-- Host: localhost    Database: isuites108
-- ------------------------------------------------------


--
-- 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=6 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,'bodega hotel',2),(5,'pasante.bogota',1);

--
-- 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=11906 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'),(8065,6,NULL,6,'usuarios','index'),(8066,6,NULL,6,'usuarios','save'),(8067,6,NULL,6,'usuarios','delete'),(8068,6,NULL,6,'usuarios','search'),(8069,6,NULL,6,'usuarios','rcs'),(8070,6,NULL,6,'usuarios','config'),(8071,6,NULL,6,'sucursal','index'),(8072,6,NULL,6,'sucursal','save'),(8073,6,NULL,6,'sucursal','delete'),(8074,6,NULL,6,'sucursal','search'),(8075,6,NULL,6,'sucursal','rcs'),(8076,6,NULL,6,'perfiles','index'),(8077,6,NULL,6,'perfiles','save'),(8078,6,NULL,6,'perfiles','delete'),(8079,6,NULL,6,'perfiles','search'),(8080,6,NULL,6,'perfiles','rcs'),(8081,6,NULL,6,'perfiles_usuarios','index'),(8082,6,NULL,6,'perfiles_usuarios','save'),(8083,6,NULL,6,'perfiles_usuarios','delete'),(8084,6,NULL,6,'perfiles_usuarios','search'),(8085,6,NULL,6,'perfiles_usuarios','rcs'),(8086,6,NULL,6,'permisos_perfiles','index'),(8087,6,NULL,6,'permisos_perfiles','save'),(8088,6,NULL,6,'permisos_perfiles','delete'),(8089,6,NULL,6,'permisos_perfiles','search'),(8090,6,NULL,6,'permisos_perfiles','rcs'),(8091,6,NULL,6,'permisos_comprob','index'),(8092,6,NULL,6,'permisos_centros','index'),(8093,6,NULL,6,'magenta','index'),(8094,6,NULL,6,'console','index'),(8125,4,NULL,2,'ordenes','index'),(8126,4,NULL,2,'ordenes','new'),(8127,4,NULL,2,'ordenes','edit'),(8128,4,NULL,2,'ordenes','delete'),(8129,4,NULL,2,'ordenes','search'),(8130,4,NULL,2,'ordenes','report'),(8131,4,NULL,2,'ordenes','puedeReAbrir'),(8132,4,NULL,2,'entradas','index'),(8133,4,NULL,2,'entradas','new'),(8134,4,NULL,2,'entradas','edit'),(8135,4,NULL,2,'entradas','delete'),(8136,4,NULL,2,'entradas','search'),(8137,4,NULL,2,'entradas','report'),(8138,4,NULL,2,'salidas','index'),(8139,4,NULL,2,'salidas','new'),(8140,4,NULL,2,'salidas','edit'),(8141,4,NULL,2,'salidas','delete'),(8142,4,NULL,2,'salidas','search'),(8143,4,NULL,2,'salidas','report'),(8144,4,NULL,2,'ajustes','index'),(8145,4,NULL,2,'ajustes','new'),(8146,4,NULL,2,'ajustes','edit'),(8147,4,NULL,2,'ajustes','delete'),(8148,4,NULL,2,'ajustes','search'),(8149,4,NULL,2,'ajustes','report'),(8150,4,NULL,2,'traslados','index'),(8151,4,NULL,2,'traslados','new'),(8152,4,NULL,2,'traslados','edit'),(8153,4,NULL,2,'traslados','delete'),(8154,4,NULL,2,'traslados','search'),(8155,4,NULL,2,'traslados','report'),(8156,4,NULL,2,'fisico','index'),(8157,4,NULL,2,'fisico','consultar'),(8158,4,NULL,2,'salidas','index'),(8159,4,NULL,2,'salidas','new'),(8160,4,NULL,2,'salidas','edit'),(8161,4,NULL,2,'salidas','delete'),(8162,4,NULL,2,'salidas','search'),(8163,4,NULL,2,'salidas','report'),(8164,4,NULL,2,'pedidos','index'),(8165,4,NULL,2,'pedidos','new'),(8166,4,NULL,2,'pedidos','edit'),(8167,4,NULL,2,'pedidos','delete'),(8168,4,NULL,2,'pedidos','search'),(8169,4,NULL,2,'pedidos','report'),(8170,4,NULL,2,'transformaciones','index'),(8171,4,NULL,2,'transformaciones','new'),(8172,4,NULL,2,'transformaciones','edit'),(8173,4,NULL,2,'transformaciones','delete'),(8174,4,NULL,2,'transformaciones','search'),(8175,4,NULL,2,'transformaciones','report'),(8176,4,NULL,2,'kardex','index'),(8177,4,NULL,2,'saldos_almacen','index'),(8178,4,NULL,2,'saldos_almacen_consolidado','index'),(8179,4,NULL,2,'stocks','index'),(8180,4,NULL,2,'comportamiento','index'),(8181,4,NULL,2,'movimientos','index'),(8182,4,NULL,2,'consecutivos','index'),(8183,4,NULL,2,'trasunto','index'),(8184,4,NULL,2,'consumos','index'),(8185,4,NULL,2,'listado_referencias','index'),(8186,4,NULL,2,'listado_proveedores','index'),(8187,4,NULL,2,'horti','index'),(8188,4,NULL,2,'impresion','index'),(8189,4,NULL,2,'cerrar','index'),(8190,4,NULL,2,'reabrir','index'),(8191,4,NULL,2,'referencias','index'),(8192,4,NULL,2,'referencias','queryByItemAction'),(8193,4,NULL,2,'referencias','queryByNameAction'),(8194,4,NULL,2,'referencias','new'),(8195,4,NULL,2,'referencias','edit'),(8196,4,NULL,2,'referencias','delete'),(8197,4,NULL,2,'referencias','search'),(8198,4,NULL,2,'referencias','report'),(8199,4,NULL,2,'lineas','index'),(8200,4,NULL,2,'lineas','new'),(8201,4,NULL,2,'lineas','edit'),(8202,4,NULL,2,'lineas','delete'),(8203,4,NULL,2,'lineas','search'),(8204,4,NULL,2,'lineas','report'),(8205,4,NULL,2,'producto','index'),(8206,4,NULL,2,'producto','new'),(8207,4,NULL,2,'producto','edit'),(8208,4,NULL,2,'producto','delete'),(8209,4,NULL,2,'producto','search'),(8210,4,NULL,2,'producto','report'),(8211,4,NULL,2,'almacenes','index'),(8212,4,NULL,2,'almacenes','new'),(8213,4,NULL,2,'almacenes','edit'),(8214,4,NULL,2,'almacenes','delete'),(8215,4,NULL,2,'almacenes','search'),(8216,4,NULL,2,'almacenes','report'),(8217,4,NULL,2,'almacenes','import'),(8218,4,NULL,2,'centros','index'),(8219,4,NULL,2,'centros','new'),(8220,4,NULL,2,'centros','edit'),(8221,4,NULL,2,'centros','delete'),(8222,4,NULL,2,'centros','search'),(8223,4,NULL,2,'centros','report'),(8224,4,NULL,2,'centros','import'),(8225,4,NULL,2,'formapago','index'),(8226,4,NULL,2,'formapago','new'),(8227,4,NULL,2,'formapago','edit'),(8228,4,NULL,2,'formapago','delete'),(8229,4,NULL,2,'formapago','search'),(8230,4,NULL,2,'formapago','report'),(8231,4,NULL,2,'formapago','import'),(8232,4,NULL,2,'terceros','index'),(8233,4,NULL,2,'terceros','new'),(8234,4,NULL,2,'terceros','edit'),(8235,4,NULL,2,'terceros','delete'),(8236,4,NULL,2,'terceros','search'),(8237,4,NULL,2,'terceros','report'),(8238,4,NULL,2,'terceros','import'),(8239,4,NULL,2,'matriz_proveedores','index'),(8240,4,NULL,2,'criterios','index'),(8241,4,NULL,2,'criterios','new'),(8242,4,NULL,2,'criterios','edit'),(8243,4,NULL,2,'criterios','delete'),(8244,4,NULL,2,'criterios','search'),(8245,4,NULL,2,'criterios','report'),(8246,4,NULL,2,'criterios','import'),(8247,4,NULL,2,'unidades','index'),(8248,4,NULL,2,'unidades','new'),(8249,4,NULL,2,'unidades','edit'),(8250,4,NULL,2,'unidades','delete'),(8251,4,NULL,2,'unidades','search'),(8252,4,NULL,2,'unidades','report'),(8253,4,NULL,2,'unidades','import'),(8254,4,NULL,2,'magnitudes','index'),(8255,4,NULL,2,'magnitudes','new'),(8256,4,NULL,2,'magnitudes','edit'),(8257,4,NULL,2,'magnitudes','delete'),(8258,4,NULL,2,'magnitudes','search'),(8259,4,NULL,2,'magnitudes','report'),(8260,4,NULL,2,'magnitudes','import'),(8261,4,NULL,2,'conversion','index'),(8262,4,NULL,2,'conversion','new'),(8263,4,NULL,2,'conversion','edit'),(8264,4,NULL,2,'conversion','delete'),(8265,4,NULL,2,'conversion','search'),(8266,4,NULL,2,'conversion','report'),(8267,4,NULL,2,'conversion','import'),(8268,4,NULL,2,'cuentas','index'),(8269,4,NULL,2,'cuentas','queryCuenta'),(8270,4,NULL,2,'settings','index'),(8271,4,NULL,2,'settings','save'),(8272,5,NULL,1,'movimiento','index'),(8273,5,NULL,1,'movimiento','buscar'),(8274,5,NULL,1,'movimiento','guardar'),(8275,5,NULL,1,'movimiento','eliminar'),(8276,5,NULL,1,'movimiento','cambiarFecha'),(8277,5,NULL,1,'movimiento','copiar'),(8278,5,NULL,1,'consultas','index'),(8279,5,NULL,1,'cambio_nit','index'),(8280,5,NULL,1,'incluir','index'),(8281,5,NULL,1,'excluir','index'),(8282,5,NULL,1,'aura','index'),(8283,5,NULL,1,'aura','save'),(8284,5,NULL,1,'aura','getComprobByDate'),(8285,5,NULL,1,'balance','index'),(8286,5,NULL,1,'libro_auxiliar','index'),(8287,5,NULL,1,'consecutivos','index'),(8288,5,NULL,1,'movimiento_terceros','index'),(8289,5,NULL,1,'movimiento_centros','index'),(8290,5,NULL,1,'balance_centros','index'),(8291,5,NULL,1,'comprobante_diario','index'),(8292,5,NULL,1,'listado_movimiento','index'),(8293,5,NULL,1,'listado_retencion','index'),(8294,5,NULL,1,'listado_comprob','index'),(8295,5,NULL,1,'retencion','index'),(8296,5,NULL,1,'balance_general','index'),(8297,5,NULL,1,'libro_diario','index'),(8298,5,NULL,1,'libro_mayor','index'),(8299,5,NULL,1,'libro_terceros','index'),(8300,5,NULL,1,'numeracion','index'),(8301,5,NULL,1,'certificado_retencion','index'),(8302,5,NULL,1,'certificado_ica','index'),(8303,5,NULL,1,'pyg','index'),(8304,5,NULL,1,'caratulas','index'),(8305,5,NULL,1,'movimiento_documentos','index'),(8306,5,NULL,1,'cartera_edades','index'),(8307,5,NULL,1,'activos','index'),(8308,5,NULL,1,'activos','save'),(8309,5,NULL,1,'activos','delete'),(8310,5,NULL,1,'activos','search'),(8311,5,NULL,1,'activos','rcs'),(8312,5,NULL,1,'grupos','index'),(8313,5,NULL,1,'grupos','save'),(8314,5,NULL,1,'grupos','delete'),(8315,5,NULL,1,'grupos','search'),(8316,5,NULL,1,'grupos','rcs'),(8317,5,NULL,1,'tipos_activos','index'),(8318,5,NULL,1,'tipos_activos','save'),(8319,5,NULL,1,'tipos_activos','delete'),(8320,5,NULL,1,'tipos_activos','search'),(8321,5,NULL,1,'tipos_activos','rcs'),(8322,5,NULL,1,'ubicacion','index'),(8323,5,NULL,1,'ubicacion','save'),(8324,5,NULL,1,'ubicacion','delete'),(8325,5,NULL,1,'ubicacion','search'),(8326,5,NULL,1,'ubicacion','rcs'),(8327,5,NULL,1,'depreciacion','index'),(8328,5,NULL,1,'anular_depreciacion','index'),(8329,5,NULL,1,'traslado_activos','index'),(8330,5,NULL,1,'novedad_activos','index'),(8331,5,NULL,1,'consulta_depreciacion','index'),(8332,5,NULL,1,'ordenes','index'),(8333,5,NULL,1,'refe','index'),(8334,5,NULL,1,'refe','save'),(8335,5,NULL,1,'refe','delete'),(8336,5,NULL,1,'refe','search'),(8337,5,NULL,1,'refe','rcs'),(8338,5,NULL,1,'lineaser','index'),(8339,5,NULL,1,'lineaser','save'),(8340,5,NULL,1,'lineaser','delete'),(8341,5,NULL,1,'lineaser','search'),(8342,5,NULL,1,'lineaser','rcs'),(8343,5,NULL,1,'presupuesto','index'),(8344,5,NULL,1,'ejecucion_pres','index'),(8345,5,NULL,1,'recibo_caja','index'),(8346,5,NULL,1,'cheque','index'),(8347,5,NULL,1,'chequeras','index'),(8348,5,NULL,1,'chequeras','save'),(8349,5,NULL,1,'chequeras','delete'),(8350,5,NULL,1,'chequeras','search'),(8351,5,NULL,1,'chequeras','rcs'),(8352,5,NULL,1,'cuentas_bancos','index'),(8353,5,NULL,1,'cuentas_bancos','save'),(8354,5,NULL,1,'cuentas_bancos','delete'),(8355,5,NULL,1,'cuentas_bancos','search'),(8356,5,NULL,1,'cuentas_bancos','rcs'),(8357,5,NULL,1,'banco','index'),(8358,5,NULL,1,'banco','save'),(8359,5,NULL,1,'banco','delete'),(8360,5,NULL,1,'banco','search'),(8361,5,NULL,1,'banco','rcs'),(8362,5,NULL,1,'formato_cheque','index'),(8363,5,NULL,1,'medios','index'),(8364,5,NULL,1,'campos_medios','index'),(8365,5,NULL,1,'codigos_medios','index'),(8366,5,NULL,1,'codigos_medios','save'),(8367,5,NULL,1,'codigos_medios','delete'),(8368,5,NULL,1,'codigos_medios','search'),(8369,5,NULL,1,'codigos_medios','rcs'),(8370,5,NULL,1,'formatos_medios','index'),(8371,5,NULL,1,'formatos_medios','save'),(8372,5,NULL,1,'formatos_medios','delete'),(8373,5,NULL,1,'formatos_medios','search'),(8374,5,NULL,1,'formatos_medios','rcs'),(8375,5,NULL,1,'diferidos','index'),(8376,5,NULL,1,'diferidos','save'),(8377,5,NULL,1,'diferidos','delete'),(8378,5,NULL,1,'diferidos','search'),(8379,5,NULL,1,'diferidos','rcs'),(8380,5,NULL,1,'grupos_diferidos','index'),(8381,5,NULL,1,'grupos_diferidos','save'),(8382,5,NULL,1,'grupos_diferidos','delete'),(8383,5,NULL,1,'grupos_diferidos','search'),(8384,5,NULL,1,'grupos_diferidos','rcs'),(8385,5,NULL,1,'amortizacion','index'),(8386,5,NULL,1,'consulta_causacion','index'),(8387,5,NULL,1,'interface_siigo','index'),(8388,5,NULL,1,'cierre_contable','index'),(8389,5,NULL,1,'reabrir_mes','index'),(8390,5,NULL,1,'cierre_cuentas','index'),(8391,5,NULL,1,'reabrir_cuentas','index'),(8392,5,NULL,1,'comprobante_cierre','index'),(8393,5,NULL,1,'cierre_anual','index'),(8394,5,NULL,1,'reabrir_ano','index'),(8395,5,NULL,1,'cuentas','index'),(8396,5,NULL,1,'cuentas','queryCuenta'),(8397,5,NULL,1,'terceros','index'),(8398,5,NULL,1,'terceros','save'),(8399,5,NULL,1,'terceros','delete'),(8400,5,NULL,1,'terceros','search'),(8401,5,NULL,1,'terceros','rcs'),(8402,5,NULL,1,'tipodoc','index'),(8403,5,NULL,1,'tipodoc','save'),(8404,5,NULL,1,'tipodoc','delete'),(8405,5,NULL,1,'tipodoc','search'),(8406,5,NULL,1,'tipodoc','rcs'),(8407,5,NULL,1,'comprobantes','index'),(8408,5,NULL,1,'comprobantes','save'),(8409,5,NULL,1,'comprobantes','delete'),(8410,5,NULL,1,'comprobantes','search'),(8411,5,NULL,1,'comprobantes','rcs'),(8412,5,NULL,1,'diarios','index'),(8413,5,NULL,1,'diarios','save'),(8414,5,NULL,1,'diarios','delete'),(8415,5,NULL,1,'diarios','search'),(8416,5,NULL,1,'diarios','rcs'),(8417,5,NULL,1,'documentos','index'),(8418,5,NULL,1,'documentos','save'),(8419,5,NULL,1,'documentos','delete'),(8420,5,NULL,1,'documentos','search'),(8421,5,NULL,1,'documentos','rcs'),(8422,5,NULL,1,'formapago','index'),(8423,5,NULL,1,'formapago','save'),(8424,5,NULL,1,'formapago','delete'),(8425,5,NULL,1,'formapago','search'),(8426,5,NULL,1,'formapago','rcs'),(8427,5,NULL,1,'regimen_cuentas','index'),(8428,5,NULL,1,'regimen_cuentas','save'),(8429,5,NULL,1,'regimen_cuentas','delete'),(8430,5,NULL,1,'regimen_cuentas','search'),(8431,5,NULL,1,'regimen_cuentas','rcs'),(8432,5,NULL,1,'ica','index'),(8433,5,NULL,1,'ica','save'),(8434,5,NULL,1,'ica','delete'),(8435,5,NULL,1,'ica','search'),(8436,5,NULL,1,'ica','rcs'),(8437,5,NULL,1,'comcier','index'),(8438,5,NULL,1,'comcier','save'),(8439,5,NULL,1,'comcier','delete'),(8440,5,NULL,1,'comcier','search'),(8441,5,NULL,1,'comcier','rcs'),(8442,5,NULL,1,'cuentas_cree','index'),(8443,5,NULL,1,'cuentas_cree','save'),(8444,5,NULL,1,'cuentas_cree','delete'),(8445,5,NULL,1,'cuentas_cree','search'),(8446,5,NULL,1,'cuentas_cree','rcs'),(8447,5,NULL,1,'centros','index'),(8448,5,NULL,1,'centros','save'),(8449,5,NULL,1,'centros','delete'),(8450,5,NULL,1,'centros','search'),(8451,5,NULL,1,'centros','rcs'),(8452,5,NULL,1,'consolidados','index'),(8453,5,NULL,1,'consolidados','save'),(8454,5,NULL,1,'consolidados','delete'),(8455,5,NULL,1,'consolidados','search'),(8456,5,NULL,1,'consolidados','rcs'),(8457,5,NULL,1,'settings','index'),(8458,5,NULL,1,'settings','save'),(9690,3,NULL,6,'usuarios','index'),(9691,3,NULL,6,'usuarios','save'),(9692,3,NULL,6,'usuarios','delete'),(9693,3,NULL,6,'usuarios','search'),(9694,3,NULL,6,'usuarios','rcs'),(9695,3,NULL,6,'usuarios','config'),(9696,3,NULL,6,'sucursal','index'),(9697,3,NULL,6,'sucursal','save'),(9698,3,NULL,6,'sucursal','delete'),(9699,3,NULL,6,'sucursal','search'),(9700,3,NULL,6,'sucursal','rcs'),(9701,3,NULL,6,'perfiles','index'),(9702,3,NULL,6,'perfiles','save'),(9703,3,NULL,6,'perfiles','delete'),(9704,3,NULL,6,'perfiles','search'),(9705,3,NULL,6,'perfiles','rcs'),(9706,3,NULL,6,'perfiles_usuarios','index'),(9707,3,NULL,6,'perfiles_usuarios','save'),(9708,3,NULL,6,'perfiles_usuarios','delete'),(9709,3,NULL,6,'perfiles_usuarios','search'),(9710,3,NULL,6,'perfiles_usuarios','rcs'),(9711,3,NULL,6,'permisos_perfiles','index'),(9712,3,NULL,6,'permisos_perfiles','save'),(9713,3,NULL,6,'permisos_perfiles','delete'),(9714,3,NULL,6,'permisos_perfiles','search'),(9715,3,NULL,6,'permisos_perfiles','rcs'),(9716,3,NULL,6,'permisos_comprob','index'),(9717,3,NULL,6,'permisos_centros','index'),(9718,3,NULL,6,'magenta','index'),(9719,3,NULL,6,'console','index'),(11518,2,NULL,2,'ordenes','index'),(11519,2,NULL,2,'ordenes','new'),(11520,2,NULL,2,'ordenes','edit'),(11521,2,NULL,2,'ordenes','delete'),(11522,2,NULL,2,'ordenes','search'),(11523,2,NULL,2,'ordenes','report'),(11524,2,NULL,2,'ordenes','puedeReAbrir'),(11525,2,NULL,2,'entradas','index'),(11526,2,NULL,2,'entradas','new'),(11527,2,NULL,2,'entradas','edit'),(11528,2,NULL,2,'entradas','delete'),(11529,2,NULL,2,'entradas','search'),(11530,2,NULL,2,'entradas','report'),(11531,2,NULL,2,'salidas','index'),(11532,2,NULL,2,'salidas','new'),(11533,2,NULL,2,'salidas','edit'),(11534,2,NULL,2,'salidas','delete'),(11535,2,NULL,2,'salidas','search'),(11536,2,NULL,2,'salidas','report'),(11537,2,NULL,2,'ajustes','index'),(11538,2,NULL,2,'ajustes','new'),(11539,2,NULL,2,'ajustes','edit'),(11540,2,NULL,2,'ajustes','delete'),(11541,2,NULL,2,'ajustes','search'),(11542,2,NULL,2,'ajustes','report'),(11543,2,NULL,2,'traslados','index'),(11544,2,NULL,2,'traslados','new'),(11545,2,NULL,2,'traslados','edit'),(11546,2,NULL,2,'traslados','delete'),(11547,2,NULL,2,'traslados','search'),(11548,2,NULL,2,'traslados','report'),(11549,2,NULL,2,'fisico','index'),(11550,2,NULL,2,'fisico','consultar'),(11551,2,NULL,2,'salidas','index'),(11552,2,NULL,2,'salidas','new'),(11553,2,NULL,2,'salidas','edit'),(11554,2,NULL,2,'salidas','delete'),(11555,2,NULL,2,'salidas','search'),(11556,2,NULL,2,'salidas','report'),(11557,2,NULL,2,'salidas_buffet','index'),(11558,2,NULL,2,'salidas_buffet','new'),(11559,2,NULL,2,'salidas_buffet','edit'),(11560,2,NULL,2,'salidas_buffet','delete'),(11561,2,NULL,2,'salidas_buffet','search'),(11562,2,NULL,2,'salidas_buffet','report'),(11563,2,NULL,2,'pedidos','index'),(11564,2,NULL,2,'pedidos','new'),(11565,2,NULL,2,'pedidos','edit'),(11566,2,NULL,2,'pedidos','delete'),(11567,2,NULL,2,'pedidos','search'),(11568,2,NULL,2,'pedidos','report'),(11569,2,NULL,2,'transformaciones','index'),(11570,2,NULL,2,'transformaciones','new'),(11571,2,NULL,2,'transformaciones','edit'),(11572,2,NULL,2,'transformaciones','delete'),(11573,2,NULL,2,'transformaciones','search'),(11574,2,NULL,2,'transformaciones','report'),(11575,2,NULL,2,'kardex','index'),(11576,2,NULL,2,'saldos_almacen','index'),(11577,2,NULL,2,'saldos_almacen_consolidado','index'),(11578,2,NULL,2,'stocks','index'),(11579,2,NULL,2,'comportamiento','index'),(11580,2,NULL,2,'movimientos','index'),(11581,2,NULL,2,'consecutivos','index'),(11582,2,NULL,2,'trasunto','index'),(11583,2,NULL,2,'consumos','index'),(11584,2,NULL,2,'listado_referencias','index'),(11585,2,NULL,2,'listado_proveedores','index'),(11586,2,NULL,2,'horti','index'),(11587,2,NULL,2,'impresion','index'),(11588,2,NULL,2,'cerrar','index'),(11589,2,NULL,2,'reabrir','index'),(11590,2,NULL,2,'referencias','index'),(11591,2,NULL,2,'referencias','queryByItemAction'),(11592,2,NULL,2,'referencias','queryByNameAction'),(11593,2,NULL,2,'referencias','new'),(11594,2,NULL,2,'referencias','edit'),(11595,2,NULL,2,'referencias','delete'),(11596,2,NULL,2,'referencias','search'),(11597,2,NULL,2,'referencias','report'),(11598,2,NULL,2,'lineas','index'),(11599,2,NULL,2,'lineas','new'),(11600,2,NULL,2,'lineas','edit'),(11601,2,NULL,2,'lineas','delete'),(11602,2,NULL,2,'lineas','search'),(11603,2,NULL,2,'lineas','report'),(11604,2,NULL,2,'producto','index'),(11605,2,NULL,2,'producto','new'),(11606,2,NULL,2,'producto','edit'),(11607,2,NULL,2,'producto','delete'),(11608,2,NULL,2,'producto','search'),(11609,2,NULL,2,'producto','report'),(11610,2,NULL,2,'almacenes','index'),(11611,2,NULL,2,'almacenes','new'),(11612,2,NULL,2,'almacenes','edit'),(11613,2,NULL,2,'almacenes','delete'),(11614,2,NULL,2,'almacenes','search'),(11615,2,NULL,2,'almacenes','report'),(11616,2,NULL,2,'almacenes','import'),(11617,2,NULL,2,'centros','index'),(11618,2,NULL,2,'centros','new'),(11619,2,NULL,2,'centros','edit'),(11620,2,NULL,2,'centros','delete'),(11621,2,NULL,2,'centros','search'),(11622,2,NULL,2,'centros','report'),(11623,2,NULL,2,'centros','import'),(11624,2,NULL,2,'formapago','index'),(11625,2,NULL,2,'formapago','new'),(11626,2,NULL,2,'formapago','edit'),(11627,2,NULL,2,'formapago','delete'),(11628,2,NULL,2,'formapago','search'),(11629,2,NULL,2,'formapago','report'),(11630,2,NULL,2,'formapago','import'),(11631,2,NULL,2,'terceros','index'),(11632,2,NULL,2,'terceros','new'),(11633,2,NULL,2,'terceros','edit'),(11634,2,NULL,2,'terceros','delete'),(11635,2,NULL,2,'terceros','search'),(11636,2,NULL,2,'terceros','report'),(11637,2,NULL,2,'terceros','import'),(11638,2,NULL,2,'matriz_proveedores','index'),(11639,2,NULL,2,'criterios','index'),(11640,2,NULL,2,'criterios','new'),(11641,2,NULL,2,'criterios','edit'),(11642,2,NULL,2,'criterios','delete'),(11643,2,NULL,2,'criterios','search'),(11644,2,NULL,2,'criterios','report'),(11645,2,NULL,2,'criterios','import'),(11646,2,NULL,2,'unidades','index'),(11647,2,NULL,2,'unidades','new'),(11648,2,NULL,2,'unidades','edit'),(11649,2,NULL,2,'unidades','delete'),(11650,2,NULL,2,'unidades','search'),(11651,2,NULL,2,'unidades','report'),(11652,2,NULL,2,'unidades','import'),(11653,2,NULL,2,'magnitudes','index'),(11654,2,NULL,2,'magnitudes','new'),(11655,2,NULL,2,'magnitudes','edit'),(11656,2,NULL,2,'magnitudes','delete'),(11657,2,NULL,2,'magnitudes','search'),(11658,2,NULL,2,'magnitudes','report'),(11659,2,NULL,2,'magnitudes','import'),(11660,2,NULL,2,'conversion','index'),(11661,2,NULL,2,'conversion','new'),(11662,2,NULL,2,'conversion','edit'),(11663,2,NULL,2,'conversion','delete'),(11664,2,NULL,2,'conversion','search'),(11665,2,NULL,2,'conversion','report'),(11666,2,NULL,2,'conversion','import'),(11667,2,NULL,2,'cuentas','index'),(11668,2,NULL,2,'cuentas','queryCuenta'),(11669,2,NULL,2,'regimen_cuentas','index'),(11670,2,NULL,2,'regimen_cuentas','new'),(11671,2,NULL,2,'regimen_cuentas','edit'),(11672,2,NULL,2,'regimen_cuentas','delete'),(11673,2,NULL,2,'regimen_cuentas','search'),(11674,2,NULL,2,'regimen_cuentas','report'),(11675,2,NULL,2,'regimen_cuentas','import'),(11676,2,NULL,2,'consumos_internos','index'),(11677,2,NULL,2,'consumos_internos','new'),(11678,2,NULL,2,'consumos_internos','edit'),(11679,2,NULL,2,'consumos_internos','delete'),(11680,2,NULL,2,'consumos_internos','search'),(11681,2,NULL,2,'consumos_internos','report'),(11682,2,NULL,2,'retecompras','index'),(11683,2,NULL,2,'retecompras','save'),(11684,2,NULL,2,'retecompras','delete'),(11685,2,NULL,2,'retecompras','search'),(11686,2,NULL,2,'retecompras','rcs'),(11687,2,NULL,2,'settings','index'),(11688,2,NULL,2,'settings','save'),(11689,1,NULL,1,'movimiento','index'),(11690,1,NULL,1,'movimiento','buscar'),(11691,1,NULL,1,'movimiento','guardar'),(11692,1,NULL,1,'movimiento','eliminar'),(11693,1,NULL,1,'movimiento','cambiarFecha'),(11694,1,NULL,1,'movimiento','copiar'),(11695,1,NULL,1,'movimiento_niif','index'),(11696,1,NULL,1,'movimiento_niif','buscar'),(11697,1,NULL,1,'movimiento_niif','guardar'),(11698,1,NULL,1,'movimiento_niif','eliminar'),(11699,1,NULL,1,'movimiento_niif','cambiarFecha'),(11700,1,NULL,1,'movimiento_niif','copiar'),(11701,1,NULL,1,'consultas','index'),(11702,1,NULL,1,'cambio_nit','index'),(11703,1,NULL,1,'incluir','index'),(11704,1,NULL,1,'excluir','index'),(11705,1,NULL,1,'aura','index'),(11706,1,NULL,1,'aura','save'),(11707,1,NULL,1,'aura','getComprobByDate'),(11708,1,NULL,1,'balance','index'),(11709,1,NULL,1,'informe_balance_consolidado','index'),(11710,1,NULL,1,'libro_auxiliar','index'),(11711,1,NULL,1,'consecutivos','index'),(11712,1,NULL,1,'movimiento_terceros','index'),(11713,1,NULL,1,'movimiento_centros','index'),(11714,1,NULL,1,'balance_centros','index'),(11715,1,NULL,1,'comprobante_diario','index'),(11716,1,NULL,1,'listado_movimiento','index'),(11717,1,NULL,1,'listado_retencion','index'),(11718,1,NULL,1,'listado_comprob','index'),(11719,1,NULL,1,'retencion','index'),(11720,1,NULL,1,'balance_general','index'),(11721,1,NULL,1,'libro_diario','index'),(11722,1,NULL,1,'libro_mayor','index'),(11723,1,NULL,1,'libro_terceros','index'),(11724,1,NULL,1,'numeracion','index'),(11725,1,NULL,1,'certificado_retencion','index'),(11726,1,NULL,1,'certificado_iva','index'),(11727,1,NULL,1,'certificado_ica','index'),(11728,1,NULL,1,'pyg','index'),(11729,1,NULL,1,'caratulas','index'),(11730,1,NULL,1,'movimiento_documentos','index'),(11731,1,NULL,1,'cartera_edades','index'),(11732,1,NULL,1,'corregir_cartera','index'),(11733,1,NULL,1,'activos','index'),(11734,1,NULL,1,'activos','save'),(11735,1,NULL,1,'activos','delete'),(11736,1,NULL,1,'activos','search'),(11737,1,NULL,1,'activos','rcs'),(11738,1,NULL,1,'grupos','index'),(11739,1,NULL,1,'grupos','save'),(11740,1,NULL,1,'grupos','delete'),(11741,1,NULL,1,'grupos','search'),(11742,1,NULL,1,'grupos','rcs'),(11743,1,NULL,1,'tipos_activos','index'),(11744,1,NULL,1,'tipos_activos','save'),(11745,1,NULL,1,'tipos_activos','delete'),(11746,1,NULL,1,'tipos_activos','search'),(11747,1,NULL,1,'tipos_activos','rcs'),(11748,1,NULL,1,'ubicacion','index'),(11749,1,NULL,1,'ubicacion','save'),(11750,1,NULL,1,'ubicacion','delete'),(11751,1,NULL,1,'ubicacion','search'),(11752,1,NULL,1,'ubicacion','rcs'),(11753,1,NULL,1,'depreciacion','index'),(11754,1,NULL,1,'anular_depreciacion','index'),(11755,1,NULL,1,'traslado_activos','index'),(11756,1,NULL,1,'novedad_activos','index'),(11757,1,NULL,1,'consulta_depreciacion','index'),(11758,1,NULL,1,'ordenes','index'),(11759,1,NULL,1,'refe','index'),(11760,1,NULL,1,'refe','save'),(11761,1,NULL,1,'refe','delete'),(11762,1,NULL,1,'refe','search'),(11763,1,NULL,1,'refe','rcs'),(11764,1,NULL,1,'lineaser','index'),(11765,1,NULL,1,'lineaser','save'),(11766,1,NULL,1,'lineaser','delete'),(11767,1,NULL,1,'lineaser','search'),(11768,1,NULL,1,'lineaser','rcs'),(11769,1,NULL,1,'presupuesto','index'),(11770,1,NULL,1,'ejecucion_pres','index'),(11771,1,NULL,1,'recibo_caja','index'),(11772,1,NULL,1,'recibo_caja','buscar'),(11773,1,NULL,1,'recibo_caja','ver'),(11774,1,NULL,1,'recibo_caja','nuevo'),(11775,1,NULL,1,'recibo_caja','generar'),(11776,1,NULL,1,'recibo_caja','anular'),(11777,1,NULL,1,'recibo_caja','imprimir'),(11778,1,NULL,1,'cheque','index'),(11779,1,NULL,1,'chequeras','index'),(11780,1,NULL,1,'chequeras','save'),(11781,1,NULL,1,'chequeras','delete'),(11782,1,NULL,1,'chequeras','search'),(11783,1,NULL,1,'chequeras','rcs'),(11784,1,NULL,1,'cuentas_bancos','index'),(11785,1,NULL,1,'cuentas_bancos','save'),(11786,1,NULL,1,'cuentas_bancos','delete'),(11787,1,NULL,1,'cuentas_bancos','search'),(11788,1,NULL,1,'cuentas_bancos','rcs'),(11789,1,NULL,1,'banco','index'),(11790,1,NULL,1,'banco','save'),(11791,1,NULL,1,'banco','delete'),(11792,1,NULL,1,'banco','search'),(11793,1,NULL,1,'banco','rcs'),(11794,1,NULL,1,'formato_cheque','index'),(11795,1,NULL,1,'medios','index'),(11796,1,NULL,1,'campos_medios','index'),(11797,1,NULL,1,'codigos_medios','index'),(11798,1,NULL,1,'codigos_medios','save'),(11799,1,NULL,1,'codigos_medios','delete'),(11800,1,NULL,1,'codigos_medios','search'),(11801,1,NULL,1,'codigos_medios','rcs'),(11802,1,NULL,1,'formatos_medios','index'),(11803,1,NULL,1,'formatos_medios','save'),(11804,1,NULL,1,'formatos_medios','delete'),(11805,1,NULL,1,'formatos_medios','search'),(11806,1,NULL,1,'formatos_medios','rcs'),(11807,1,NULL,1,'diferidos','index'),(11808,1,NULL,1,'diferidos','save'),(11809,1,NULL,1,'diferidos','delete'),(11810,1,NULL,1,'diferidos','search'),(11811,1,NULL,1,'diferidos','rcs'),(11812,1,NULL,1,'grupos_diferidos','index'),(11813,1,NULL,1,'grupos_diferidos','save'),(11814,1,NULL,1,'grupos_diferidos','delete'),(11815,1,NULL,1,'grupos_diferidos','search'),(11816,1,NULL,1,'grupos_diferidos','rcs'),(11817,1,NULL,1,'amortizacion','index'),(11818,1,NULL,1,'consulta_causacion','index'),(11819,1,NULL,1,'interface_siigo','index'),(11820,1,NULL,1,'cierre_contable','index'),(11821,1,NULL,1,'reabrir_mes','index'),(11822,1,NULL,1,'cierre_cuentas','index'),(11823,1,NULL,1,'reabrir_cuentas','index'),(11824,1,NULL,1,'comprobante_cierre','index'),(11825,1,NULL,1,'cierre_anual','index'),(11826,1,NULL,1,'reabrir_ano','index'),(11827,1,NULL,1,'niif','index'),(11828,1,NULL,1,'niif','save'),(11829,1,NULL,1,'niif','delete'),(11830,1,NULL,1,'niif','search'),(11831,1,NULL,1,'niif','rcs'),(11832,1,NULL,1,'nic','index'),(11833,1,NULL,1,'nic','save'),(11834,1,NULL,1,'nic','delete'),(11835,1,NULL,1,'nic','search'),(11836,1,NULL,1,'nic','rcs'),(11837,1,NULL,1,'cuentas','index'),(11838,1,NULL,1,'cuentas','queryCuenta'),(11839,1,NULL,1,'terceros','index'),(11840,1,NULL,1,'terceros','save'),(11841,1,NULL,1,'terceros','delete'),(11842,1,NULL,1,'terceros','search'),(11843,1,NULL,1,'terceros','rcs'),(11844,1,NULL,1,'tipodoc','index'),(11845,1,NULL,1,'tipodoc','save'),(11846,1,NULL,1,'tipodoc','delete'),(11847,1,NULL,1,'tipodoc','search'),(11848,1,NULL,1,'tipodoc','rcs'),(11849,1,NULL,1,'comprobantes','index'),(11850,1,NULL,1,'comprobantes','save'),(11851,1,NULL,1,'comprobantes','delete'),(11852,1,NULL,1,'comprobantes','search'),(11853,1,NULL,1,'comprobantes','rcs'),(11854,1,NULL,1,'diarios','index'),(11855,1,NULL,1,'diarios','save'),(11856,1,NULL,1,'diarios','delete'),(11857,1,NULL,1,'diarios','search'),(11858,1,NULL,1,'diarios','rcs'),(11859,1,NULL,1,'documentos','index'),(11860,1,NULL,1,'documentos','save'),(11861,1,NULL,1,'documentos','delete'),(11862,1,NULL,1,'documentos','search'),(11863,1,NULL,1,'documentos','rcs'),(11864,1,NULL,1,'formapago','index'),(11865,1,NULL,1,'formapago','save'),(11866,1,NULL,1,'formapago','delete'),(11867,1,NULL,1,'formapago','search'),(11868,1,NULL,1,'formapago','rcs'),(11869,1,NULL,1,'regimen_cuentas','index'),(11870,1,NULL,1,'regimen_cuentas','save'),(11871,1,NULL,1,'regimen_cuentas','delete'),(11872,1,NULL,1,'regimen_cuentas','search'),(11873,1,NULL,1,'regimen_cuentas','rcs'),(11874,1,NULL,1,'ica','index'),(11875,1,NULL,1,'ica','save'),(11876,1,NULL,1,'ica','delete'),(11877,1,NULL,1,'ica','search'),(11878,1,NULL,1,'ica','rcs'),(11879,1,NULL,1,'comcier','index'),(11880,1,NULL,1,'comcier','save'),(11881,1,NULL,1,'comcier','delete'),(11882,1,NULL,1,'comcier','search'),(11883,1,NULL,1,'comcier','rcs'),(11884,1,NULL,1,'cuentas_cree','index'),(11885,1,NULL,1,'cuentas_cree','save'),(11886,1,NULL,1,'cuentas_cree','delete'),(11887,1,NULL,1,'cuentas_cree','search'),(11888,1,NULL,1,'cuentas_cree','rcs'),(11889,1,NULL,1,'centros','index'),(11890,1,NULL,1,'centros','save'),(11891,1,NULL,1,'centros','delete'),(11892,1,NULL,1,'centros','search'),(11893,1,NULL,1,'centros','rcs'),(11894,1,NULL,1,'consolidados','index'),(11895,1,NULL,1,'consolidados','save'),(11896,1,NULL,1,'consolidados','delete'),(11897,1,NULL,1,'consolidados','search'),(11898,1,NULL,1,'consolidados','rcs'),(11899,1,NULL,1,'settings','index'),(11900,1,NULL,1,'settings','save'),(11901,2,NULL,2,'movinventario','index'),(11902,4,NULL,2,'movinventario','index'),(11904,2,NULL,2,'docsop_resolucion','index'),(11905,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=323 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `perfiles_usuarios` VALUES (317,1,1),(49,3,1),(33,4,1),(81,5,1),(121,8,1),(64,10,1),(124,11,1),(152,12,1),(157,14,1),(167,15,1),(177,16,1),(194,18,1),(214,19,1),(205,23,1),(211,24,1),(253,25,1),(223,26,1),(250,27,1),(285,28,1),(256,29,1),(271,30,1),(304,31,1),(307,32,1),(310,33,1),(313,34,1),(320,36,1),(318,1,2),(50,3,2),(34,4,2),(82,5,2),(122,8,2),(62,9,2),(65,10,2),(125,11,2),(153,12,2),(158,14,2),(168,15,2),(195,18,2),(215,19,2),(199,20,2),(206,23,2),(212,24,2),(254,25,2),(224,26,2),(251,27,2),(286,28,2),(257,29,2),(272,30,2),(305,31,2),(308,32,2),(311,33,2),(314,34,2),(316,35,2),(321,36,2),(319,1,3),(52,3,3),(84,5,3),(123,8,3),(127,11,3),(154,12,3),(169,15,3),(178,16,3),(196,18,3),(216,19,3),(207,23,3),(213,24,3),(255,25,3),(225,26,3),(252,27,3),(288,28,3),(258,29,3),(273,30,3),(306,31,3),(309,32,3),(312,33,3),(315,34,3),(322,36,3),(51,3,4),(83,5,4),(184,7,4),(63,9,4),(126,11,4),(159,14,4),(193,17,4),(287,28,4),(183,7,5),(145,13,5),(192,17,5);

--
-- 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=3345 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `sesiones` VALUES (3343,'069273f3b96f2c3b722e0b7357b4e842',1,'127.0.0.1',1566386176,1697534818),(3344,'e21010a0c9e356f2972c871f52dc6816',1,'127.0.0.1',1670885806,1670885806);

--
-- 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 NOT 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=2 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','soporte@bhteck.com','M',1,NULL,'2010-07-05','2010-07-05 00:21:51','A');

--
-- Dumping routines for database 'isuites108'
--


