--
-- Host: localhost    Database: ipanaderosos
-- ------------------------------------------------------


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

CREATE TABLE `aplicaciones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `codigo` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nombre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `serial` char(48) COLLATE utf8_unicode_ci NOT NULL,
  `tipo` char(1) COLLATE utf8_unicode_ci DEFAULT 'F',
  `instalada` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_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(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `serial` char(48) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_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(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
  `aplicaciones_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_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(10) unsigned NOT NULL AUTO_INCREMENT,
  `perfiles_id` int(10) unsigned NOT NULL,
  `permisos_id` int(10) unsigned DEFAULT NULL,
  `aplicaciones_id` int(10) unsigned NOT NULL,
  `controller` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `action` varchar(100) COLLATE utf8_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=14577 DEFAULT CHARSET=utf8 COLLATE=utf8_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'),(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'),(12102,4,NULL,2,'ordenes','index'),(12103,4,NULL,2,'ordenes','new'),(12104,4,NULL,2,'ordenes','edit'),(12105,4,NULL,2,'ordenes','delete'),(12106,4,NULL,2,'ordenes','search'),(12107,4,NULL,2,'ordenes','report'),(12108,4,NULL,2,'ordenes','puedeReAbrir'),(12109,4,NULL,2,'entradas','index'),(12110,4,NULL,2,'entradas','new'),(12111,4,NULL,2,'entradas','edit'),(12112,4,NULL,2,'entradas','delete'),(12113,4,NULL,2,'entradas','search'),(12114,4,NULL,2,'entradas','report'),(12115,4,NULL,2,'salidas','index'),(12116,4,NULL,2,'salidas','new'),(12117,4,NULL,2,'salidas','edit'),(12118,4,NULL,2,'salidas','delete'),(12119,4,NULL,2,'salidas','search'),(12120,4,NULL,2,'salidas','report'),(12121,4,NULL,2,'ajustes','index'),(12122,4,NULL,2,'ajustes','new'),(12123,4,NULL,2,'ajustes','edit'),(12124,4,NULL,2,'ajustes','delete'),(12125,4,NULL,2,'ajustes','search'),(12126,4,NULL,2,'ajustes','report'),(12127,4,NULL,2,'traslados','index'),(12128,4,NULL,2,'traslados','new'),(12129,4,NULL,2,'traslados','edit'),(12130,4,NULL,2,'traslados','delete'),(12131,4,NULL,2,'traslados','search'),(12132,4,NULL,2,'traslados','report'),(12133,4,NULL,2,'fisico','index'),(12134,4,NULL,2,'fisico','consultar'),(12135,4,NULL,2,'salidas','index'),(12136,4,NULL,2,'salidas','new'),(12137,4,NULL,2,'salidas','edit'),(12138,4,NULL,2,'salidas','delete'),(12139,4,NULL,2,'salidas','search'),(12140,4,NULL,2,'salidas','report'),(12141,4,NULL,2,'pedidos','index'),(12142,4,NULL,2,'pedidos','new'),(12143,4,NULL,2,'pedidos','edit'),(12144,4,NULL,2,'pedidos','delete'),(12145,4,NULL,2,'pedidos','search'),(12146,4,NULL,2,'pedidos','report'),(12147,4,NULL,2,'transformaciones','index'),(12148,4,NULL,2,'transformaciones','new'),(12149,4,NULL,2,'transformaciones','edit'),(12150,4,NULL,2,'transformaciones','delete'),(12151,4,NULL,2,'transformaciones','search'),(12152,4,NULL,2,'transformaciones','report'),(12153,4,NULL,2,'kardex','index'),(12154,4,NULL,2,'saldos_almacen','index'),(12155,4,NULL,2,'saldos_almacen_consolidado','index'),(12156,4,NULL,2,'stocks','index'),(12157,4,NULL,2,'comportamiento','index'),(12158,4,NULL,2,'movimientos','index'),(12159,4,NULL,2,'consecutivos','index'),(12160,4,NULL,2,'trasunto','index'),(12161,4,NULL,2,'consumos','index'),(12162,4,NULL,2,'listado_referencias','index'),(12163,4,NULL,2,'listado_proveedores','index'),(12164,4,NULL,2,'horti','index'),(12165,4,NULL,2,'impresion','index'),(12166,4,NULL,2,'cerrar','index'),(12167,4,NULL,2,'reabrir','index'),(12168,4,NULL,2,'referencias','index'),(12169,4,NULL,2,'referencias','queryByItemAction'),(12170,4,NULL,2,'referencias','queryByNameAction'),(12171,4,NULL,2,'referencias','new'),(12172,4,NULL,2,'referencias','edit'),(12173,4,NULL,2,'referencias','delete'),(12174,4,NULL,2,'referencias','search'),(12175,4,NULL,2,'referencias','report'),(12176,4,NULL,2,'lineas','index'),(12177,4,NULL,2,'lineas','new'),(12178,4,NULL,2,'lineas','edit'),(12179,4,NULL,2,'lineas','delete'),(12180,4,NULL,2,'lineas','search'),(12181,4,NULL,2,'lineas','report'),(12182,4,NULL,2,'producto','index'),(12183,4,NULL,2,'producto','new'),(12184,4,NULL,2,'producto','edit'),(12185,4,NULL,2,'producto','delete'),(12186,4,NULL,2,'producto','search'),(12187,4,NULL,2,'producto','report'),(12188,4,NULL,2,'almacenes','index'),(12189,4,NULL,2,'almacenes','new'),(12190,4,NULL,2,'almacenes','edit'),(12191,4,NULL,2,'almacenes','delete'),(12192,4,NULL,2,'almacenes','search'),(12193,4,NULL,2,'almacenes','report'),(12194,4,NULL,2,'almacenes','import'),(12195,4,NULL,2,'centros','index'),(12196,4,NULL,2,'centros','new'),(12197,4,NULL,2,'centros','edit'),(12198,4,NULL,2,'centros','delete'),(12199,4,NULL,2,'centros','search'),(12200,4,NULL,2,'centros','report'),(12201,4,NULL,2,'centros','import'),(12202,4,NULL,2,'formapago','index'),(12203,4,NULL,2,'formapago','new'),(12204,4,NULL,2,'formapago','edit'),(12205,4,NULL,2,'formapago','delete'),(12206,4,NULL,2,'formapago','search'),(12207,4,NULL,2,'formapago','report'),(12208,4,NULL,2,'formapago','import'),(12209,4,NULL,2,'terceros','index'),(12210,4,NULL,2,'terceros','new'),(12211,4,NULL,2,'terceros','edit'),(12212,4,NULL,2,'terceros','delete'),(12213,4,NULL,2,'terceros','search'),(12214,4,NULL,2,'terceros','report'),(12215,4,NULL,2,'terceros','import'),(12216,4,NULL,2,'matriz_proveedores','index'),(12217,4,NULL,2,'criterios','index'),(12218,4,NULL,2,'criterios','new'),(12219,4,NULL,2,'criterios','edit'),(12220,4,NULL,2,'criterios','delete'),(12221,4,NULL,2,'criterios','search'),(12222,4,NULL,2,'criterios','report'),(12223,4,NULL,2,'criterios','import'),(12224,4,NULL,2,'unidades','index'),(12225,4,NULL,2,'unidades','new'),(12226,4,NULL,2,'unidades','edit'),(12227,4,NULL,2,'unidades','delete'),(12228,4,NULL,2,'unidades','search'),(12229,4,NULL,2,'unidades','report'),(12230,4,NULL,2,'unidades','import'),(12231,4,NULL,2,'magnitudes','index'),(12232,4,NULL,2,'magnitudes','new'),(12233,4,NULL,2,'magnitudes','edit'),(12234,4,NULL,2,'magnitudes','delete'),(12235,4,NULL,2,'magnitudes','search'),(12236,4,NULL,2,'magnitudes','report'),(12237,4,NULL,2,'magnitudes','import'),(12238,4,NULL,2,'conversion','index'),(12239,4,NULL,2,'conversion','new'),(12240,4,NULL,2,'conversion','edit'),(12241,4,NULL,2,'conversion','delete'),(12242,4,NULL,2,'conversion','search'),(12243,4,NULL,2,'conversion','report'),(12244,4,NULL,2,'conversion','import'),(12245,4,NULL,2,'cuentas','index'),(12246,4,NULL,2,'cuentas','queryCuenta'),(12247,4,NULL,2,'settings','index'),(12248,4,NULL,2,'settings','save'),(13145,3,NULL,6,'usuarios','index'),(13146,3,NULL,6,'usuarios','save'),(13147,3,NULL,6,'usuarios','delete'),(13148,3,NULL,6,'usuarios','search'),(13149,3,NULL,6,'usuarios','rcs'),(13150,3,NULL,6,'usuarios','config'),(13151,3,NULL,6,'sucursal','index'),(13152,3,NULL,6,'sucursal','save'),(13153,3,NULL,6,'sucursal','delete'),(13154,3,NULL,6,'sucursal','search'),(13155,3,NULL,6,'sucursal','rcs'),(13156,3,NULL,6,'perfiles','index'),(13157,3,NULL,6,'perfiles','save'),(13158,3,NULL,6,'perfiles','delete'),(13159,3,NULL,6,'perfiles','search'),(13160,3,NULL,6,'perfiles','rcs'),(13161,3,NULL,6,'perfiles_usuarios','index'),(13162,3,NULL,6,'perfiles_usuarios','save'),(13163,3,NULL,6,'perfiles_usuarios','delete'),(13164,3,NULL,6,'perfiles_usuarios','search'),(13165,3,NULL,6,'perfiles_usuarios','rcs'),(13166,3,NULL,6,'permisos_perfiles','index'),(13167,3,NULL,6,'permisos_perfiles','save'),(13168,3,NULL,6,'permisos_perfiles','delete'),(13169,3,NULL,6,'permisos_perfiles','search'),(13170,3,NULL,6,'permisos_perfiles','rcs'),(13171,3,NULL,6,'permisos_comprob','index'),(13172,3,NULL,6,'permisos_centros','index'),(13173,3,NULL,6,'magenta','index'),(13174,3,NULL,6,'console','index'),(13346,2,NULL,2,'ordenes','index'),(13347,2,NULL,2,'ordenes','new'),(13348,2,NULL,2,'ordenes','edit'),(13349,2,NULL,2,'ordenes','delete'),(13350,2,NULL,2,'ordenes','search'),(13351,2,NULL,2,'ordenes','report'),(13352,2,NULL,2,'ordenes','puedeReAbrir'),(13353,2,NULL,2,'entradas','index'),(13354,2,NULL,2,'entradas','new'),(13355,2,NULL,2,'entradas','edit'),(13356,2,NULL,2,'entradas','delete'),(13357,2,NULL,2,'entradas','search'),(13358,2,NULL,2,'entradas','report'),(13359,2,NULL,2,'salidas','index'),(13360,2,NULL,2,'salidas','new'),(13361,2,NULL,2,'salidas','edit'),(13362,2,NULL,2,'salidas','delete'),(13363,2,NULL,2,'salidas','search'),(13364,2,NULL,2,'salidas','report'),(13365,2,NULL,2,'ajustes','index'),(13366,2,NULL,2,'ajustes','new'),(13367,2,NULL,2,'ajustes','edit'),(13368,2,NULL,2,'ajustes','delete'),(13369,2,NULL,2,'ajustes','search'),(13370,2,NULL,2,'ajustes','report'),(13371,2,NULL,2,'traslados','index'),(13372,2,NULL,2,'traslados','new'),(13373,2,NULL,2,'traslados','edit'),(13374,2,NULL,2,'traslados','delete'),(13375,2,NULL,2,'traslados','search'),(13376,2,NULL,2,'traslados','report'),(13377,2,NULL,2,'fisico','index'),(13378,2,NULL,2,'fisico','consultar'),(13379,2,NULL,2,'salidas','index'),(13380,2,NULL,2,'salidas','new'),(13381,2,NULL,2,'salidas','edit'),(13382,2,NULL,2,'salidas','delete'),(13383,2,NULL,2,'salidas','search'),(13384,2,NULL,2,'salidas','report'),(13385,2,NULL,2,'salidas_buffet','index'),(13386,2,NULL,2,'salidas_buffet','new'),(13387,2,NULL,2,'salidas_buffet','edit'),(13388,2,NULL,2,'salidas_buffet','delete'),(13389,2,NULL,2,'salidas_buffet','search'),(13390,2,NULL,2,'salidas_buffet','report'),(13391,2,NULL,2,'pedidos','index'),(13392,2,NULL,2,'pedidos','new'),(13393,2,NULL,2,'pedidos','edit'),(13394,2,NULL,2,'pedidos','delete'),(13395,2,NULL,2,'pedidos','search'),(13396,2,NULL,2,'pedidos','report'),(13397,2,NULL,2,'transformaciones','index'),(13398,2,NULL,2,'transformaciones','new'),(13399,2,NULL,2,'transformaciones','edit'),(13400,2,NULL,2,'transformaciones','delete'),(13401,2,NULL,2,'transformaciones','search'),(13402,2,NULL,2,'transformaciones','report'),(13403,2,NULL,2,'kardex','index'),(13404,2,NULL,2,'saldos_almacen','index'),(13405,2,NULL,2,'saldos_almacen_consolidado','index'),(13406,2,NULL,2,'stocks','index'),(13407,2,NULL,2,'comportamiento','index'),(13408,2,NULL,2,'movimientos','index'),(13409,2,NULL,2,'consecutivos','index'),(13410,2,NULL,2,'trasunto','index'),(13411,2,NULL,2,'consumos','index'),(13412,2,NULL,2,'listado_referencias','index'),(13413,2,NULL,2,'listado_proveedores','index'),(13414,2,NULL,2,'horti','index'),(13415,2,NULL,2,'impresion','index'),(13416,2,NULL,2,'cerrar','index'),(13417,2,NULL,2,'reabrir','index'),(13418,2,NULL,2,'referencias','index'),(13419,2,NULL,2,'referencias','queryByItemAction'),(13420,2,NULL,2,'referencias','queryByNameAction'),(13421,2,NULL,2,'referencias','new'),(13422,2,NULL,2,'referencias','edit'),(13423,2,NULL,2,'referencias','delete'),(13424,2,NULL,2,'referencias','search'),(13425,2,NULL,2,'referencias','report'),(13426,2,NULL,2,'lineas','index'),(13427,2,NULL,2,'lineas','new'),(13428,2,NULL,2,'lineas','edit'),(13429,2,NULL,2,'lineas','delete'),(13430,2,NULL,2,'lineas','search'),(13431,2,NULL,2,'lineas','report'),(13432,2,NULL,2,'producto','index'),(13433,2,NULL,2,'producto','new'),(13434,2,NULL,2,'producto','edit'),(13435,2,NULL,2,'producto','delete'),(13436,2,NULL,2,'producto','search'),(13437,2,NULL,2,'producto','report'),(13438,2,NULL,2,'almacenes','index'),(13439,2,NULL,2,'almacenes','new'),(13440,2,NULL,2,'almacenes','edit'),(13441,2,NULL,2,'almacenes','delete'),(13442,2,NULL,2,'almacenes','search'),(13443,2,NULL,2,'almacenes','report'),(13444,2,NULL,2,'almacenes','import'),(13445,2,NULL,2,'centros','index'),(13446,2,NULL,2,'centros','new'),(13447,2,NULL,2,'centros','edit'),(13448,2,NULL,2,'centros','delete'),(13449,2,NULL,2,'centros','search'),(13450,2,NULL,2,'centros','report'),(13451,2,NULL,2,'centros','import'),(13452,2,NULL,2,'formapago','index'),(13453,2,NULL,2,'formapago','new'),(13454,2,NULL,2,'formapago','edit'),(13455,2,NULL,2,'formapago','delete'),(13456,2,NULL,2,'formapago','search'),(13457,2,NULL,2,'formapago','report'),(13458,2,NULL,2,'formapago','import'),(13459,2,NULL,2,'terceros','index'),(13460,2,NULL,2,'terceros','new'),(13461,2,NULL,2,'terceros','edit'),(13462,2,NULL,2,'terceros','delete'),(13463,2,NULL,2,'terceros','search'),(13464,2,NULL,2,'terceros','report'),(13465,2,NULL,2,'terceros','import'),(13466,2,NULL,2,'matriz_proveedores','index'),(13467,2,NULL,2,'criterios','index'),(13468,2,NULL,2,'criterios','new'),(13469,2,NULL,2,'criterios','edit'),(13470,2,NULL,2,'criterios','delete'),(13471,2,NULL,2,'criterios','search'),(13472,2,NULL,2,'criterios','report'),(13473,2,NULL,2,'criterios','import'),(13474,2,NULL,2,'unidades','index'),(13475,2,NULL,2,'unidades','new'),(13476,2,NULL,2,'unidades','edit'),(13477,2,NULL,2,'unidades','delete'),(13478,2,NULL,2,'unidades','search'),(13479,2,NULL,2,'unidades','report'),(13480,2,NULL,2,'unidades','import'),(13481,2,NULL,2,'magnitudes','index'),(13482,2,NULL,2,'magnitudes','new'),(13483,2,NULL,2,'magnitudes','edit'),(13484,2,NULL,2,'magnitudes','delete'),(13485,2,NULL,2,'magnitudes','search'),(13486,2,NULL,2,'magnitudes','report'),(13487,2,NULL,2,'magnitudes','import'),(13488,2,NULL,2,'conversion','index'),(13489,2,NULL,2,'conversion','new'),(13490,2,NULL,2,'conversion','edit'),(13491,2,NULL,2,'conversion','delete'),(13492,2,NULL,2,'conversion','search'),(13493,2,NULL,2,'conversion','report'),(13494,2,NULL,2,'conversion','import'),(13495,2,NULL,2,'cuentas','index'),(13496,2,NULL,2,'cuentas','queryCuenta'),(13497,2,NULL,2,'regimen_cuentas','index'),(13498,2,NULL,2,'regimen_cuentas','new'),(13499,2,NULL,2,'regimen_cuentas','edit'),(13500,2,NULL,2,'regimen_cuentas','delete'),(13501,2,NULL,2,'regimen_cuentas','search'),(13502,2,NULL,2,'regimen_cuentas','report'),(13503,2,NULL,2,'regimen_cuentas','import'),(13504,2,NULL,2,'consumos_internos','index'),(13505,2,NULL,2,'consumos_internos','new'),(13506,2,NULL,2,'consumos_internos','edit'),(13507,2,NULL,2,'consumos_internos','delete'),(13508,2,NULL,2,'consumos_internos','search'),(13509,2,NULL,2,'consumos_internos','report'),(13510,2,NULL,2,'retecompras','index'),(13511,2,NULL,2,'retecompras','save'),(13512,2,NULL,2,'retecompras','delete'),(13513,2,NULL,2,'retecompras','search'),(13514,2,NULL,2,'retecompras','rcs'),(13515,2,NULL,2,'settings','index'),(13516,2,NULL,2,'settings','save'),(13941,2,NULL,2,'movinventario','index'),(13942,4,NULL,2,'movinventario','index'),(13944,2,NULL,2,'docsop_resolucion','index'),(13945,4,NULL,2,'docsop_resolucion','index'),(14366,1,NULL,1,'movimiento','index'),(14367,1,NULL,1,'movimiento','buscar'),(14368,1,NULL,1,'movimiento','guardar'),(14369,1,NULL,1,'movimiento','eliminar'),(14370,1,NULL,1,'movimiento','cambiarFecha'),(14371,1,NULL,1,'movimiento','copiar'),(14372,1,NULL,1,'movimiento_niif','index'),(14373,1,NULL,1,'movimiento_niif','buscar'),(14374,1,NULL,1,'movimiento_niif','guardar'),(14375,1,NULL,1,'movimiento_niif','eliminar'),(14376,1,NULL,1,'movimiento_niif','cambiarFecha'),(14377,1,NULL,1,'movimiento_niif','copiar'),(14378,1,NULL,1,'consultas','index'),(14379,1,NULL,1,'cambio_nit','index'),(14380,1,NULL,1,'incluir','index'),(14381,1,NULL,1,'excluir','index'),(14382,1,NULL,1,'aura','index'),(14383,1,NULL,1,'aura','save'),(14384,1,NULL,1,'aura','getComprobByDate'),(14385,1,NULL,1,'balance','index'),(14386,1,NULL,1,'informe_balance_consolidado','index'),(14387,1,NULL,1,'libro_auxiliar','index'),(14388,1,NULL,1,'consecutivos','index'),(14389,1,NULL,1,'movimiento_terceros','index'),(14390,1,NULL,1,'movimiento_centros','index'),(14391,1,NULL,1,'balance_centros','index'),(14392,1,NULL,1,'comprobante_diario','index'),(14393,1,NULL,1,'listado_movimiento','index'),(14394,1,NULL,1,'listado_retencion','index'),(14395,1,NULL,1,'listado_comprob','index'),(14396,1,NULL,1,'retencion','index'),(14397,1,NULL,1,'balance_general','index'),(14398,1,NULL,1,'libro_diario','index'),(14399,1,NULL,1,'libro_mayor','index'),(14400,1,NULL,1,'libro_terceros','index'),(14401,1,NULL,1,'numeracion','index'),(14402,1,NULL,1,'certificado_retencion','index'),(14403,1,NULL,1,'certificado_iva','index'),(14404,1,NULL,1,'certificado_ica','index'),(14405,1,NULL,1,'pyg','index'),(14406,1,NULL,1,'caratulas','index'),(14407,1,NULL,1,'movimiento_documentos','index'),(14408,1,NULL,1,'cartera_edades','index'),(14409,1,NULL,1,'corregir_cartera','index'),(14410,1,NULL,1,'activos','index'),(14411,1,NULL,1,'activos','save'),(14412,1,NULL,1,'activos','delete'),(14413,1,NULL,1,'activos','search'),(14414,1,NULL,1,'activos','rcs'),(14415,1,NULL,1,'grupos','index'),(14416,1,NULL,1,'grupos','save'),(14417,1,NULL,1,'grupos','delete'),(14418,1,NULL,1,'grupos','search'),(14419,1,NULL,1,'grupos','rcs'),(14420,1,NULL,1,'tipos_activos','index'),(14421,1,NULL,1,'tipos_activos','save'),(14422,1,NULL,1,'tipos_activos','delete'),(14423,1,NULL,1,'tipos_activos','search'),(14424,1,NULL,1,'tipos_activos','rcs'),(14425,1,NULL,1,'ubicacion','index'),(14426,1,NULL,1,'ubicacion','save'),(14427,1,NULL,1,'ubicacion','delete'),(14428,1,NULL,1,'ubicacion','search'),(14429,1,NULL,1,'ubicacion','rcs'),(14430,1,NULL,1,'depreciacion','index'),(14431,1,NULL,1,'anular_depreciacion','index'),(14432,1,NULL,1,'traslado_activos','index'),(14433,1,NULL,1,'novedad_activos','index'),(14434,1,NULL,1,'consulta_depreciacion','index'),(14435,1,NULL,1,'ordenes','index'),(14436,1,NULL,1,'refe','index'),(14437,1,NULL,1,'refe','save'),(14438,1,NULL,1,'refe','delete'),(14439,1,NULL,1,'refe','search'),(14440,1,NULL,1,'refe','rcs'),(14441,1,NULL,1,'lineaser','index'),(14442,1,NULL,1,'lineaser','save'),(14443,1,NULL,1,'lineaser','delete'),(14444,1,NULL,1,'lineaser','search'),(14445,1,NULL,1,'lineaser','rcs'),(14446,1,NULL,1,'presupuesto','index'),(14447,1,NULL,1,'ejecucion_pres','index'),(14448,1,NULL,1,'recibo_caja','index'),(14449,1,NULL,1,'recibo_caja','buscar'),(14450,1,NULL,1,'recibo_caja','ver'),(14451,1,NULL,1,'recibo_caja','nuevo'),(14452,1,NULL,1,'recibo_caja','generar'),(14453,1,NULL,1,'recibo_caja','anular'),(14454,1,NULL,1,'recibo_caja','imprimir'),(14455,1,NULL,1,'cheque','index'),(14456,1,NULL,1,'chequeras','index'),(14457,1,NULL,1,'chequeras','save'),(14458,1,NULL,1,'chequeras','delete'),(14459,1,NULL,1,'chequeras','search'),(14460,1,NULL,1,'chequeras','rcs'),(14461,1,NULL,1,'cuentas_bancos','index'),(14462,1,NULL,1,'cuentas_bancos','save'),(14463,1,NULL,1,'cuentas_bancos','delete'),(14464,1,NULL,1,'cuentas_bancos','search'),(14465,1,NULL,1,'cuentas_bancos','rcs'),(14466,1,NULL,1,'banco','index'),(14467,1,NULL,1,'banco','save'),(14468,1,NULL,1,'banco','delete'),(14469,1,NULL,1,'banco','search'),(14470,1,NULL,1,'banco','rcs'),(14471,1,NULL,1,'formato_cheque','index'),(14472,1,NULL,1,'medios','index'),(14473,1,NULL,1,'campos_medios','index'),(14474,1,NULL,1,'codigos_medios','index'),(14475,1,NULL,1,'codigos_medios','save'),(14476,1,NULL,1,'codigos_medios','delete'),(14477,1,NULL,1,'codigos_medios','search'),(14478,1,NULL,1,'codigos_medios','rcs'),(14479,1,NULL,1,'diferidos','index'),(14480,1,NULL,1,'diferidos','save'),(14481,1,NULL,1,'diferidos','delete'),(14482,1,NULL,1,'diferidos','search'),(14483,1,NULL,1,'diferidos','rcs'),(14484,1,NULL,1,'grupos_diferidos','index'),(14485,1,NULL,1,'grupos_diferidos','save'),(14486,1,NULL,1,'grupos_diferidos','delete'),(14487,1,NULL,1,'grupos_diferidos','search'),(14488,1,NULL,1,'grupos_diferidos','rcs'),(14489,1,NULL,1,'amortizacion','index'),(14490,1,NULL,1,'consulta_causacion','index'),(14491,1,NULL,1,'interface_siigo','index'),(14492,1,NULL,1,'cierre_contable','index'),(14493,1,NULL,1,'reabrir_mes','index'),(14494,1,NULL,1,'cierre_cuentas','index'),(14495,1,NULL,1,'reabrir_cuentas','index'),(14496,1,NULL,1,'comprobante_cierre','index'),(14497,1,NULL,1,'cierre_anual','index'),(14498,1,NULL,1,'reabrir_ano','index'),(14499,1,NULL,1,'niif','index'),(14500,1,NULL,1,'niif','save'),(14501,1,NULL,1,'niif','delete'),(14502,1,NULL,1,'niif','search'),(14503,1,NULL,1,'niif','rcs'),(14504,1,NULL,1,'nic','index'),(14505,1,NULL,1,'nic','save'),(14506,1,NULL,1,'nic','delete'),(14507,1,NULL,1,'nic','search'),(14508,1,NULL,1,'nic','rcs'),(14509,1,NULL,1,'cuentas','index'),(14510,1,NULL,1,'cuentas','queryCuenta'),(14511,1,NULL,1,'terceros','index'),(14512,1,NULL,1,'terceros','save'),(14513,1,NULL,1,'terceros','delete'),(14514,1,NULL,1,'terceros','search'),(14515,1,NULL,1,'terceros','rcs'),(14516,1,NULL,1,'tipodoc','index'),(14517,1,NULL,1,'tipodoc','save'),(14518,1,NULL,1,'tipodoc','delete'),(14519,1,NULL,1,'tipodoc','search'),(14520,1,NULL,1,'tipodoc','rcs'),(14521,1,NULL,1,'comprobantes','index'),(14522,1,NULL,1,'comprobantes','save'),(14523,1,NULL,1,'comprobantes','delete'),(14524,1,NULL,1,'comprobantes','search'),(14525,1,NULL,1,'comprobantes','rcs'),(14526,1,NULL,1,'diarios','index'),(14527,1,NULL,1,'diarios','save'),(14528,1,NULL,1,'diarios','delete'),(14529,1,NULL,1,'diarios','search'),(14530,1,NULL,1,'diarios','rcs'),(14531,1,NULL,1,'documentos','index'),(14532,1,NULL,1,'documentos','save'),(14533,1,NULL,1,'documentos','delete'),(14534,1,NULL,1,'documentos','search'),(14535,1,NULL,1,'documentos','rcs'),(14536,1,NULL,1,'formapago','index'),(14537,1,NULL,1,'formapago','save'),(14538,1,NULL,1,'formapago','delete'),(14539,1,NULL,1,'formapago','search'),(14540,1,NULL,1,'formapago','rcs'),(14541,1,NULL,1,'regimen_cuentas','index'),(14542,1,NULL,1,'regimen_cuentas','save'),(14543,1,NULL,1,'regimen_cuentas','delete'),(14544,1,NULL,1,'regimen_cuentas','search'),(14545,1,NULL,1,'regimen_cuentas','rcs'),(14546,1,NULL,1,'ica','index'),(14547,1,NULL,1,'ica','save'),(14548,1,NULL,1,'ica','delete'),(14549,1,NULL,1,'ica','search'),(14550,1,NULL,1,'ica','rcs'),(14551,1,NULL,1,'comcier','index'),(14552,1,NULL,1,'comcier','save'),(14553,1,NULL,1,'comcier','delete'),(14554,1,NULL,1,'comcier','search'),(14555,1,NULL,1,'comcier','rcs'),(14556,1,NULL,1,'cuentas_cree','index'),(14557,1,NULL,1,'cuentas_cree','save'),(14558,1,NULL,1,'cuentas_cree','delete'),(14559,1,NULL,1,'cuentas_cree','search'),(14560,1,NULL,1,'cuentas_cree','rcs'),(14561,1,NULL,1,'centros','index'),(14562,1,NULL,1,'centros','save'),(14563,1,NULL,1,'centros','delete'),(14564,1,NULL,1,'centros','search'),(14565,1,NULL,1,'centros','rcs'),(14566,1,NULL,1,'consolidados','index'),(14567,1,NULL,1,'consolidados','save'),(14568,1,NULL,1,'consolidados','delete'),(14569,1,NULL,1,'consolidados','search'),(14570,1,NULL,1,'consolidados','rcs'),(14571,1,NULL,1,'settings','index'),(14572,1,NULL,1,'settings','save'),(14573,1,NULL,1,'docsop_resolucion','index'),(14574,1,NULL,1,'docsop_resolucion','save'),(14575,1,NULL,1,'docsop','index'),(14576,1,NULL,1,'docsop','save');

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

CREATE TABLE `perfiles_usuarios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `usuarios_id` int(10) unsigned NOT NULL,
  `perfiles_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `perfiles_id` (`perfiles_id`,`usuarios_id`)
) ENGINE=InnoDB AUTO_INCREMENT=420 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `perfiles_usuarios` VALUES (414,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),(373,31,1),(417,32,1),(388,33,1),(382,34,1),(385,35,1),(391,37,1),(409,38,1),(415,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),(374,31,2),(418,32,2),(389,33,2),(383,34,2),(386,35,2),(392,37,2),(411,38,2),(416,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),(375,31,3),(419,32,3),(390,33,3),(384,34,3),(387,35,3),(413,38,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),(412,38,4),(183,7,5),(145,13,5),(192,17,5),(410,38,5);

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

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

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


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

CREATE TABLE `sesiones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` char(35) COLLATE utf8_unicode_ci NOT NULL,
  `usuarios_id` int(10) unsigned NOT NULL,
  `ipaddress` char(15) COLLATE utf8_unicode_ci NOT NULL,
  `creado` int(10) unsigned NOT NULL,
  `modificado` int(10) 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=4372 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `sesiones` VALUES (3323,'f14d3c19947c7e332890e2309ab80302',33,'127.0.0.1',1563638700,1564149229),(3325,'cde4d53691391d98f1c9e1b6918181e7',31,'127.0.0.1',1563932954,1563932954),(3328,'abebf3403b0bbf1139d0d536034d57f8',33,'127.0.0.1',1564073376,1564165748),(3331,'a1778b59d59c79a81091d3954d168df2',31,'127.0.0.1',1565316314,1565316314),(3333,'069273f3b96f2c3b722e0b7357b4e842',1,'127.0.0.1',1566960632,1676851345),(3334,'10d8b6d7cb81131571d7c63194afb467',31,'127.0.0.1',1567022491,1567023867),(3336,'ede138f7c0fd2d0128a572cc983a9ade',31,'127.0.0.1',1567032631,1567032631),(3338,'e54c44579dfdd6a3793e345dfc1192cf',31,'127.0.0.1',1567135508,1567135636),(3339,'9f3bc9895947528231d591ba8605b4c9',31,'127.0.0.1',1567220139,1567220391),(3342,'8675cbf00058bad9ccc903d7db61e20c',1,'127.0.0.1',1567507109,1567589092),(3345,'ba5f1bf342db013473dabca7a521012c',1,'127.0.0.1',1568213998,1568213998),(3348,'c2d2e7ed94b95f587ca65f033aa57dd5',31,'127.0.0.1',1568644833,1568644833),(3349,'52c76f68a2f686721231c7cd5ca08af3',31,'127.0.0.1',1568860456,1568860456),(3350,'5bd687d0b8d8e44a6e41f008f03f9592',31,'127.0.0.1',1568887062,1569032452),(3357,'d2c12edb0ab0df9e7d2f970fd7087969',1,'127.0.0.1',1569028417,1675370721),(3374,'c1ad1a1248302ec4f4fb4440b2c713c6',1,'127.0.0.1',1569094817,1569094817),(3382,'c0e71907801eb2eb496fe8d278d6175f',1,'127.0.0.1',1569275024,1569276077),(3384,'dd779d03eddfae307e7e7578156d75e9',1,'127.0.0.1',1569454152,1569454152),(3386,'0210208e1b592f2a0ff2de32765c7784',1,'127.0.0.1',1569519680,1569519680),(3388,'e824525fadb1816fe2ac8ca37631d061',1,'127.0.0.1',1569593911,1569593911),(3389,'9edefb724e0c5e893abbb508bb2afd30',1,'127.0.0.1',1569643512,1569643512),(3393,'9231002d8924350be26b61461ded415e',1,'127.0.0.1',1570158400,1570158400),(3394,'28aee7a1c1e982c4c109de312542a5f0',1,'127.0.0.1',1570461684,1570461684),(3398,'02c2fd80f5dfaccde63c3d80026fcb9d',1,'127.0.0.1',1570812594,1570840595),(3399,'b8f610aca1b04eb1d257ffd0055c17b6',1,'127.0.0.1',1571493004,1571493004),(3401,'53ee5076db15e74a21df96f7145c5a46',1,'127.0.0.1',1571793597,1571793597),(3402,'a5356f54459d2e93ee15320f42e91002',31,'127.0.0.1',1571861992,1571869441),(3403,'3166ba66b2944fc99620d9b565b57dc6',1,'127.0.0.1',1571882429,1571940471),(3405,'ca24d5374f7857aec17e370f5bef64c1',1,'127.0.0.1',1572370138,1572370138),(3406,'5231098d343efee888b27b98697c4de8',1,'127.0.0.1',1572479885,1572479885),(3407,'4f08b0138dd1353ea9e433139b042dc5',1,'127.0.0.1',1572534135,1572534135),(3408,'e585d2996d792a59e0dff4878037dfdb',1,'127.0.0.1',1572573166,1572573166),(3410,'b362b97d99ea5e8432a53d5e7b32e7ff',1,'127.0.0.1',1572637896,1572637896),(3411,'b6a65c87f8b629bf42adcec644fb6ebe',1,'127.0.0.1',1572642510,1572642510),(3413,'ffaadbf7e0c8ec12b91960b5c3d84969',1,'127.0.0.1',1572660966,1572660966),(3414,'32607c6b2d448028995dd62127369b2c',1,'127.0.0.1',1572702795,1573422522),(3426,'7e10c7ce545eceafa8bb3c6cd3e418be',36,'127.0.0.1',1573428905,1573429787),(3433,'a7767c334faac134945d8730696f1a60',32,'127.0.0.1',1573434764,1573833011),(3434,'56713f50c1118ff1949b633d9d845463',1,'127.0.0.1',1573739964,1573739964),(3441,'bb283822688b1254f506db465036e3d2',31,'127.0.0.1',1574794705,1574794705),(3444,'dcded98e54eb91571ce3281ee3120c63',32,'127.0.0.1',1574874474,1574874474),(3447,'0608d37999bd80d26bb0b3b5506c2d9a',1,'127.0.0.1',1575038316,1575038316),(3448,'743fb16200a13a55f5b50635d9aeaf98',1,'127.0.0.1',1575054327,1575054329),(3451,'6c128bd0c41cd0628ac243c140c03169',1,'127.0.0.1',1575149822,1575149824),(3454,'6b7a006d9744ff8918fb274ef23968b4',31,'127.0.0.1',1575216363,1575216363),(3455,'e4fca4d3fe60ff59be7d03d3daf8a723',1,'127.0.0.1',1576879576,1576879576),(3456,'2c483bd89b25c6d7062f4eaa78c211e4',1,'127.0.0.1',1576880870,1576880874),(3458,'003fe95060c879cbf61fbd614d60afc3',1,'127.0.0.1',1577825231,1577825232),(3459,'411655edfe0c554825f67e9b4728a6ef',1,'127.0.0.1',1578008851,1578008851),(3462,'ecb67e6423da0bba098fe85a1792f310',1,'127.0.0.1',1578075914,1578075914),(3463,'7eb88ce99415ad6c7446b4eb8d5d789e',1,'127.0.0.1',1578079492,1578079492),(3465,'bbb75ddbc6d8f750e6ca59a9828fba88',31,'127.0.0.1',1578327707,1578327707),(3469,'2ba11f995c227d144ef855783a9c5312',1,'127.0.0.1',1578755881,1578755881),(3474,'578aa359484ed1e29e99b3780d0dcf12',1,'127.0.0.1',1579011337,1579011337),(3475,'da077b26300b9d7b1f9e5552c112cbc1',1,'127.0.0.1',1579030330,1579030330),(3476,'766b366fa7010543945597046d1568f6',1,'127.0.0.1',1579122114,1579122114),(3479,'618a35ba066dbbc0265ef4dd298c36d1',1,'127.0.0.1',1579273780,1579273780),(3480,'e24b48b7546e3c39bfba336eb6cefb55',1,'127.0.0.1',1579288450,1579288563),(3481,'5301779e3dd870e3092d775e832299d0',1,'127.0.0.1',1579307117,1579307117),(3485,'63083887d18bc331d659ea113cec5503',32,'127.0.0.1',1579387547,1579661839),(3486,'185cc371773a60b37f018df960c25e07',1,'127.0.0.1',1579541386,1579541386),(3490,'983447d8067f531ffc883e8263f1d9a8',1,'127.0.0.1',1579699700,1579799143),(3492,'579a899ebb49ea01bcfede6abc70a90d',1,'127.0.0.1',1579727693,1579727694),(3497,'9aff161f92430b3a769343bb6b0cd994',1,'127.0.0.1',1579984005,1579984005),(3499,'b06570a2e51e1790caa7d5d3075d6f65',1,'127.0.0.1',1580133717,1580133717),(3503,'159ee5d3e32f7e1db600285b0b7fb34c',1,'127.0.0.1',1580309123,1580309123),(3506,'e4b9f58f37b0843d97cfd9f6710dfc5e',1,'127.0.0.1',1580429580,1580429580),(3508,'78141f9875e6d39a19a1c2d90d45cb81',1,'127.0.0.1',1580575055,1580575055),(3513,'38526ee5479225d786713c4d749d587b',1,'127.0.0.1',1581350775,1581350777),(3515,'b0c492f23cb61eb9782a4a2ecf057d8c',1,'127.0.0.1',1581434242,1581698120),(3516,'b1f2c3be75f8b5bdea1cff3500582b5f',1,'127.0.0.1',1581620881,1581620881),(3517,'aa6cb1174b056165505a0df4d784b81d',1,'127.0.0.1',1581621250,1581621250),(3518,'28cdb1bc1e226dc5f9114abeb6700602',1,'127.0.0.1',1581798603,1581798603),(3519,'75f19c349b24a34c4fbfb0019031645f',1,'127.0.0.1',1581959558,1581959558),(3521,'e3646370c3f0786b3d6df61a091cf86f',1,'127.0.0.1',1582152754,1582152754),(3522,'e9953875d2051cf420fdc772d88bff05',1,'127.0.0.1',1582218903,1582218903),(3523,'e91c18d80d4b9510765331788f8530de',1,'127.0.0.1',1582219302,1582219302),(3524,'db95a77d933903afe29fb4436ca6c1e7',1,'127.0.0.1',1582403584,1582403584),(3525,'d29fe33d9c696cf2ad68b674effe52c5',1,'127.0.0.1',1582573088,1582573089),(3530,'b6f40cde65d190ce07c30da75e0d5274',1,'127.0.0.1',1582839201,1582839201),(3531,'d7951d0de4d82a8da8daab01bf0585b4',1,'127.0.0.1',1583012374,1583012374),(3533,'1175fc10d10363027bbd4fa73f924ad2',1,'127.0.0.1',1583173985,1583173987),(3534,'ab0a7314b933c2894a87a601c23fb038',1,'127.0.0.1',1583251601,1583251601),(3535,'3657edf17557c0056f78e0b581bf3b26',1,'127.0.0.1',1583761511,1583761513),(3537,'1a8433d3d660b45ebd2c8941b6713f10',1,'127.0.0.1',1583944866,1583948287),(3539,'7ca01bd22df5b05dfed297e912974386',31,'127.0.0.1',1584029829,1584029829),(3541,'43adbeb9344f90bf2a1b395bcf0f07b2',1,'127.0.0.1',1584376668,1584376668),(3542,'445d9bca2b7d58a2217f50aae02ef94b',1,'127.0.0.1',1584400365,1584400365),(3543,'f27133f78cd247815a3d073dfe97f240',1,'127.0.0.1',1584486830,1584486830),(3544,'83fbb0ffaca3059fc14ba2af5b2293d7',1,'127.0.0.1',1584551918,1584551918),(3545,'a1466f706434463560c582500d3d4198',1,'127.0.0.1',1584739915,1584739915),(3546,'19576139338c92f09a1370457cb3d113',1,'127.0.0.1',1584753119,1584753122),(3551,'79cbe0395728943fc6e11ced052614f3',1,'127.0.0.1',1585711241,1585711241),(3552,'fd7f55a17ba8705f6ef51d22dbdce724',1,'127.0.0.1',1585805376,1585805376),(3553,'852a052ab3fa8cabc48d733e8c4569e2',31,'127.0.0.1',1587573486,1587573486),(3554,'7954c1ff21aab6440e854744e6173be7',31,'127.0.0.1',1588000260,1588000260),(3562,'c7337b44c994ba39339ecb63dfd0cbdb',31,'127.0.0.1',1590149396,1590149396),(3564,'8723183ffc1db0d7bb7816f5a2a0d4e0',31,'127.0.0.1',1591142498,1591142498),(3565,'05e3d0ad6549ed8b26b2216b6218ac62',31,'127.0.0.1',1592947219,1592947219),(3569,'fe10fefc8e34cfdcabcb42b2d0cd6924',31,'127.0.0.1',1596403779,1596403779),(3572,'26958472e20c8f064f6980d242717961',31,'127.0.0.1',1599515348,1599515348),(3576,'093bd9406526f48ac0083cbc753fbeda',1,'127.0.0.1',1599841020,1599841022),(3578,'e9b9edc4c948a20c268e8635e4d65408',1,'127.0.0.1',1599931498,1599931498),(3579,'643e26d9eddbd1a47a3e262ec7f6032c',1,'127.0.0.1',1599933240,1599933240),(3583,'f4aee750b54ad37f92a821a09d199e47',1,'127.0.0.1',1600882210,1600882210),(3584,'222493e466fd27f5444ddf3f58dd26be',32,'127.0.0.1',1600917993,1600917993),(3592,'9415b1d6734d669af12a5ca526cc93c5',1,'127.0.0.1',1601523818,1601523820),(3608,'898b4599d4e457ed8ab88b3f7e3af95d',1,'127.0.0.1',1602835354,1602835354),(3612,'69a18b7175946d858d9fbcee56b0abc8',32,'127.0.0.1',1602953700,1602953700),(3613,'39a728c9cd42f9ac33e4540b6634a77b',31,'127.0.0.1',1602989545,1602989545),(3621,'2be7556033a90408bfccb8af6e251d05',1,'127.0.0.1',1603742964,1603742964),(3622,'4168e66401dd7e1033130a33c0dc4f91',1,'127.0.0.1',1604191929,1604191929),(3624,'a3ee098eebc1ba2911421f4b56d49d92',1,'127.0.0.1',1604960627,1604960627),(3625,'16f2c7aa515680c4454d531af5a709b8',32,'127.0.0.1',1605192013,1605370298),(3626,'13ff3e47690b99c027fecaeec862efed',32,'127.0.0.1',1605280021,1605280021),(3627,'ebd508e1aa62e27b712ba8cfaaa11c81',32,'127.0.0.1',1605291665,1606529032),(3630,'5f6d7d318b9d6fa1d6fa34f85e393e21',31,'127.0.0.1',1605352271,1605371563),(3632,'cc18908c16abcc4d6f8ec2d75c570431',32,'127.0.0.1',1605393139,1605393139),(3634,'9f758bafc37c8c9c88f45aaf19ea2ef2',1,'127.0.0.1',1605975488,1605975488),(3638,'8c6ff9f100a00a5dc3e585da10d6d729',32,'127.0.0.1',1606352128,1606352128),(3640,'71cec745659d91c97a0f8147dfa3743e',32,'127.0.0.1',1606585621,1607817487),(3643,'e28f07f4ceffc231587aa60fc8cbef9e',1,'127.0.0.1',1606785985,1606785985),(3644,'7aeaa73e1625829fdad5978e6720147a',32,'127.0.0.1',1607394644,1608318239),(3645,'3f5369fb4435fe0853f8a1edc36e9972',1,'127.0.0.1',1607732697,1607732700),(3648,'3490f286011d4d6968c479ac58255371',32,'127.0.0.1',1608345486,1609771642),(3649,'2ece686a94a829500011214eb7c9a17d',1,'127.0.0.1',1608613413,1608613413),(3653,'e12457c329979a929329714e5c3340c4',1,'127.0.0.1',1609452524,1609452524),(3655,'35415dfa169b822524c92b43535ae742',32,'127.0.0.1',1610494978,1610993579),(3656,'26b187a4c1a495b12b5485ef467b4d0d',32,'127.0.0.1',1610647052,1610647052),(3657,'61e260f15f2695797cfa96d6a391c5b1',32,'127.0.0.1',1610810521,1610810521),(3659,'dc69b240af78b7d6d04b70be9e85d290',32,'127.0.0.1',1611197261,1613275482),(3661,'365a5d56f42349d59191268bfe0fbe8f',1,'127.0.0.1',1611588609,1611588609),(3662,'a87c024257397904ac17e10d0acbacae',1,'127.0.0.1',1611762805,1611762805),(3663,'4927a03b51d26c4e34de170f413f865f',1,'127.0.0.1',1611940701,1611940701),(3665,'87f271899369e391d2dfc2410662afec',31,'127.0.0.1',1612057415,1674358778),(3666,'f32e569ecf83cbbc736f56675ab46c87',1,'127.0.0.1',1612147662,1612147662),(3669,'f3ed66fc08cc5e3be6a018ee5bcd4819',1,'127.0.0.1',1612906746,1612906746),(3670,'6248c03f91d093bc381f33ee96f4ccad',32,'127.0.0.1',1613428255,1614305989),(3671,'14006e053732a6ebeb172100d6942cd9',1,'127.0.0.1',1613579247,1613579247),(3672,'92e15e2d4cc01c0c79442eea9be16d0c',31,'127.0.0.1',1614037832,1614037832),(3673,'6cf170d87c7df40ee71333b348a9548f',31,'127.0.0.1',1614383502,1614383502),(3674,'155ef1b0cd41028a4587a94e94ced0e0',32,'127.0.0.1',1614386885,1616720818),(3675,'239b8d03447b153af4c2c3c50d3ef9d3',32,'127.0.0.1',1614460587,1614460587),(3680,'7dc798f77f340843760252c29653e2c8',1,'127.0.0.1',1614561155,1614561155),(3681,'405621a84c60fcd7b2cb2de74a497b6c',1,'127.0.0.1',1614628559,1614628559),(3684,'d15d950d9e5b44823c800a27fea67129',1,'127.0.0.1',1614962321,1614962321),(3685,'7d47e153398e07ce3c0abbffe05ef86b',1,'127.0.0.1',1615042363,1615042363),(3687,'800c1f89949deeea18ee9dcd5602fb47',1,'127.0.0.1',1615333145,1615333145),(3688,'8a9988be437d1ec865aadc8894ab8253',1,'127.0.0.1',1615597556,1615597556),(3689,'4a3d8a97df39a50f937633adfae21d90',1,'127.0.0.1',1615827936,1615827936),(3695,'f6b12a774b9684f9ddec5e644a93cb5f',31,'127.0.0.1',1616277645,1616277645),(3696,'20a668318758326bbe53867bef5692ef',31,'127.0.0.1',1616603185,1616603185),(3697,'1a8328ad518c1dab06b8db728b920699',1,'127.0.0.1',1616607057,1616607057),(3699,'381de141386bdb978ce207f9b273e2f7',32,'127.0.0.1',1616636523,1619053426),(3700,'8a69d8ffef815dc4343364a258fc9fb5',31,'127.0.0.1',1616697161,1616697161),(3702,'61c07509787a79b3fc1694a5e59f460c',31,'127.0.0.1',1616973297,1617071972),(3703,'cae2d164b2cc18f94fe1bc5edc9b50b5',1,'127.0.0.1',1617121923,1617121923),(3705,'85d633574ed789a4cfb965a0d60491b8',1,'127.0.0.1',1617209730,1617209730),(3706,'4280456a95fd834796d76d34d2d2011e',1,'127.0.0.1',1617224491,1617224491),(3707,'a8b5155f8f83c1266927120101a9d217',1,'127.0.0.1',1617225695,1617225695),(3710,'2de9ff3ab3f89ca3916cdaa99de72223',31,'127.0.0.1',1617982319,1618027333),(3711,'ae85c332191deeb23468928db4e52ce3',1,'127.0.0.1',1617998936,1617998936),(3712,'140d1ec0789e8b2575a93a77173b780f',31,'127.0.0.1',1618023520,1618023520),(3713,'a762605c00ec40780f7954fa44d1226b',31,'127.0.0.1',1618086901,1618086901),(3719,'3c1b82bad95dd39f42ec6ded68f0ecfa',1,'127.0.0.1',1619473350,1619473350),(3720,'f911631bf2a6a4cba972d0a4358da60c',1,'127.0.0.1',1619481685,1621617298),(3721,'767d5d4ac58e51611f14462e0cd6a971',32,'127.0.0.1',1619482070,1619581868),(3725,'1188110d9ec8062fc5f5ed62683be059',31,'127.0.0.1',1619710761,1620229361),(3726,'40dd0a17285ab399635dc3a10a71c404',1,'127.0.0.1',1619803416,1619803416),(3727,'66f1d4596e513b46b013d29ecda3cacb',1,'127.0.0.1',1619813739,1619813739),(3728,'354d46f1c7e5daa01711864cc32acb13',32,'127.0.0.1',1619835293,1623293190),(3729,'37bcb7c059f08f4430762ca48795611b',32,'127.0.0.1',1620179068,1620179068),(3730,'3491ad9b905b4c21a58d03903b302e00',1,'127.0.0.1',1620312376,1620312376),(3733,'bb2d8f5f8701c52beb1ac9c489478968',1,'127.0.0.1',1620680012,1620680012),(3734,'f41f587817b2207435b15c72a54af25b',1,'127.0.0.1',1620687062,1620687062),(3735,'45c5984283717eb45d387fc1c681753d',1,'127.0.0.1',1620779030,1620779030),(3737,'e1dd1fff20286bca6f92d27304ee22c3',1,'127.0.0.1',1620833835,1620833835),(3738,'1fe7f6e874a31d0a0305de3968c4cc98',1,'127.0.0.1',1620834434,1620834435),(3739,'64a76ebeb5727e47b9284e3d99c20bce',1,'127.0.0.1',1620996855,1620996871),(3740,'f9e070cd5d4c133f4d91c2beceaaac53',32,'127.0.0.1',1621262255,1621262255),(3742,'d266f78d1698a6f2c735f7d72637740d',31,'127.0.0.1',1621375929,1621383995),(3743,'c679b29a6f50dd83e3887d4216f6fa9a',1,'127.0.0.1',1621376922,1622580050),(3745,'b40374b2504dbf1cc43550d6779cf1cc',1,'127.0.0.1',1621438261,1621438261),(3748,'ec40ce7338684d8be3fe01ced1d29cc3',1,'127.0.0.1',1621529813,1621529813),(3749,'88ab9a487bf85da07c1503f2d9044d6e',1,'127.0.0.1',1621544429,1621544429),(3750,'146856ab7a2760e5a484f651642d70f7',1,'127.0.0.1',1621608263,1621608263),(3753,'1306bddc720e7c54a958f230887809a2',1,'127.0.0.1',1621897768,1621897768),(3754,'45784898165e9624926f211a23aaca05',31,'127.0.0.1',1621957177,1622136491),(3755,'5267189e56e4353b071c0770362e2ce0',1,'127.0.0.1',1622040012,1622040014),(3756,'69a561864fe550e135040d187a127021',1,'127.0.0.1',1622041484,1622041484),(3757,'45d277a003f8ca0d04cd30f0c2a5d893',1,'127.0.0.1',1622061819,1622061819),(3758,'479d6dbf7ab08b0ca88c743bd762c572',32,'127.0.0.1',1622309786,1622309786),(3759,'34507f075329418a68895f9bb60b9b53',1,'127.0.0.1',1622325573,1622325573),(3760,'29fae9a417255f9cb74f2752afa08f69',31,'127.0.0.1',1622346453,1622346453),(3761,'535f53ad0be0c9bfe0aca3bd061310d9',31,'127.0.0.1',1622486986,1622486986),(3762,'4e90668b304bf6b4d316029401902e03',1,'127.0.0.1',1622496815,1622496815),(3763,'7c209478debfa094e23179329ae11da4',1,'127.0.0.1',1622499807,1622499807),(3764,'a492633e67bc529b2d16317f7adc4dad',1,'127.0.0.1',1622504617,1622504617),(3770,'b1356267046e0172e58b222823f1b0fa',1,'127.0.0.1',1622642439,1622642439),(3772,'0cd28d97c8130198db92f0fd54fd11b5',31,'127.0.0.1',1622727910,1622727910),(3775,'a49412eed149c1e8a3267b3a3e1abb09',1,'127.0.0.1',1622836160,1622836160),(3776,'43b261f47bc51c1dcf976eff1c68e903',1,'127.0.0.1',1622911994,1622911994),(3779,'c07767ee038883a45b3ee47555221cd2',1,'127.0.0.1',1623184296,1623184296),(3780,'270298768c58b32be492db914057fa7c',1,'127.0.0.1',1623278270,1623278270),(3781,'32969261eb38fff314c343d9103ee64d',1,'127.0.0.1',1623346169,1623346292),(3783,'e7ed26d461698fc253e10eb4f188aebe',32,'127.0.0.1',1623372767,1627004873),(3784,'7c23fd8a4fee9b09d5e09f2099c72e59',1,'127.0.0.1',1623455354,1623455354),(3786,'41228e8c08de97da1d47f6123dcd3206',1,'127.0.0.1',1623871237,1623871237),(3787,'b91b103560401750462a0232c517eae3',1,'127.0.0.1',1623878023,1623878023),(3788,'d3688097739d22371be16db0077e7c44',1,'127.0.0.1',1623957266,1623957266),(3790,'012125110dea970af2d99e32bd360853',1,'127.0.0.1',1624122431,1624982404),(3791,'3b6811b5471696abe56ae08639f9a96a',32,'127.0.0.1',1624123167,1624123167),(3793,'bf6fcdb8e2d0b2fb64d766b11e55d732',1,'127.0.0.1',1624125429,1624125429),(3794,'91af0d1100e3fbb813fa6844e184c2ca',1,'127.0.0.1',1624128715,1626123975),(3795,'cf85404fb676b36dd4b7c48f899f5334',1,'127.0.0.1',1624134101,1624134101),(3796,'0205e4d4f7ff866b0b2481d8baa0d311',1,'127.0.0.1',1624378414,1624378414),(3797,'3a746bbc1d18cd82285cce30db5a07e1',1,'127.0.0.1',1624567551,1624567551),(3798,'0b4a9d47afee7778e826a466ca99dbeb',1,'127.0.0.1',1624570752,1624570752),(3810,'359b07f0864490de1f4769cf9585c191',34,'127.0.0.1',1624644616,1625000992),(3812,'3dae1a63c01e79e09869d1c679500e88',1,'127.0.0.1',1624664916,1624664916),(3813,'ee7890f37988b8f6ce635de97d238d85',31,'127.0.0.1',1624704843,1624927819),(3814,'478454efdddb7d84f5874999aee3dd17',1,'127.0.0.1',1624984152,1624984152),(3816,'a15276a670e860a46216c1de2109edf9',1,'127.0.0.1',1625022310,1625022310),(3817,'351d6fff281eff417a34a85409ea6ae0',1,'127.0.0.1',1625072228,1625087139),(3819,'45504a5ac00ebe1dc634636a647374fb',1,'127.0.0.1',1625076703,1626211190),(3820,'05c371a202e2027833413d81c98560d6',34,'127.0.0.1',1625158127,1625236356),(3822,'2194a87be01dc9c7d3c2f6bfcfb2a7b9',1,'127.0.0.1',1625605201,1625605201),(3823,'f6ff6a47cd2a2d055a510908a4ef8e5b',1,'127.0.0.1',1625688023,1625688023),(3824,'ec3b65d9fb4191ead5081dd638918a9c',1,'127.0.0.1',1625690904,1625690905),(3825,'28d38b28702f3c95265e9b6bbce0864b',32,'127.0.0.1',1625793241,1625793241),(3826,'90d96b21b1e93321e2d0c2423c29b5b2',1,'127.0.0.1',1626125408,1626125408),(3827,'a96b082f7f36d18fba7dc6f38592eb21',34,'127.0.0.1',1626206181,1626206181),(3828,'6219eab702dcb32e68adb3029c6ae7f0',34,'127.0.0.1',1626290568,1626290568),(3830,'8583bc807e0f30b580c43d35f83019ba',1,'127.0.0.1',1626406691,1626406691),(3831,'335d35234c0c84c1088e13c1ed905245',1,'127.0.0.1',1626706672,1626706672),(3833,'fda6fa8549050063529c93df1e73df8e',1,'127.0.0.1',1626883819,1626883819),(3834,'81933a761656f376c4aba869a1b61192',1,'127.0.0.1',1626886083,1626886083),(3835,'e8b628ddcc16b1e2d99f4a3fbc0d626e',31,'127.0.0.1',1626908194,1626908194),(3836,'65b431e8406482388088e27fa1a34daa',1,'127.0.0.1',1626954923,1626954923),(3837,'168dbe21f9b91b6be9820d2542d74336',1,'127.0.0.1',1626966877,1626966877),(3838,'de3f05515807af0346a3817c77542f84',32,'127.0.0.1',1627096212,1627526581),(3839,'44160290cf9234113ed040d50b54748b',1,'127.0.0.1',1627332796,1627332796),(3840,'b3cfdc547b2ae2064d8767998f6de332',1,'127.0.0.1',1627339630,1627339630),(3841,'53c987753b200cb7bcf7102cde600484',1,'127.0.0.1',1627348804,1627348804),(3844,'f9a402553c5d341f6cb3c926fae1cd2d',1,'127.0.0.1',1627493316,1627596472),(3846,'9f4cd6a006519bc350b0bad7ae146cf9',1,'127.0.0.1',1627595273,1627595273),(3847,'86453ae0199f714dd6b39cbd4b5e7c7b',1,'127.0.0.1',1627664573,1627664573),(3848,'c6d06b20afa72f754b70089d67ddb556',34,'127.0.0.1',1627670429,1627670429),(3849,'72e45adb95afa64b9bfe06d86c524ef7',1,'127.0.0.1',1627763089,1627773119),(3853,'5654e7c72d5520a85659fc0a73290634',34,'127.0.0.1',1628044594,1692197084),(3854,'818d09bac797bd8d77e6159d469d0977',34,'127.0.0.1',1628046862,1628702710),(3855,'f6c692c723a5142e202dc8b2e5995b56',31,'127.0.0.1',1628203403,1628539058),(3856,'e82925b79d9a6b2f8c28b128ab7aff5d',1,'127.0.0.1',1628801779,1628801824),(3857,'39ee90ab6d0b955976e4fa9b40b34b0a',1,'127.0.0.1',1628883341,1630088471),(3860,'adf1492549160878a61e04745d0ad86f',34,'127.0.0.1',1628900774,1630627268),(3862,'3204f6a51cc97551bfac52544dfea469',1,'127.0.0.1',1628967355,1628967355),(3865,'8e59b91afe293324ba145a6f37633059',1,'127.0.0.1',1629344368,1630687141),(3866,'96601e6690c7362efeada219803e1245',34,'127.0.0.1',1629554736,1631418799),(3868,'c048e89f7d0daff614563763dc387713',1,'127.0.0.1',1629581130,1629581130),(3869,'1f908ee995236a5e32e7cb8f3cee1b76',1,'127.0.0.1',1629581616,1629581616),(3870,'e492efe67c9b2731a7117e04f698ef37',34,'127.0.0.1',1629589853,1629589854),(3873,'3af6315ab4c972fcbcc97ed9e2a0d662',1,'127.0.0.1',1629992672,1629992672),(3877,'1c1acfeed980708c8f048d7785e7cd7f',31,'127.0.0.1',1631290152,1631290152),(3878,'3498296ff572953eed05a8b8d2283466',34,'127.0.0.1',1631493216,1633833889),(3879,'b97db4804a77a9f0b6fa83d517c21525',34,'127.0.0.1',1631564293,1633534627),(3880,'bf259025a5b1472f8bbf085d4ff352e4',34,'127.0.0.1',1631564480,1633214293),(3883,'fd113fe9fd892085ed7ca2053a64ac15',1,'127.0.0.1',1631668201,1631668201),(3884,'ed439088ce209c7397fe95954247218f',31,'127.0.0.1',1631675101,1631675101),(3886,'446c7bd53129314f2b8fd3ceab9e96bb',1,'127.0.0.1',1631763905,1633187880),(3887,'bc947647245e4b3fdd5bd8f7e036b2dc',1,'127.0.0.1',1631829812,1631829812),(3888,'d83333d9250c3543113932b0c2ac51f0',34,'127.0.0.1',1631838311,1631838311),(3890,'2a080445d101677b5ee6e43ffb80ca03',1,'127.0.0.1',1633117276,1633117774),(3892,'60c71a51db8f596ab1251c3732bde1f3',1,'127.0.0.1',1633148842,1633148842),(3893,'4b181a2bc753a2311e37952857b42797',1,'127.0.0.1',1633188727,1633188727),(3894,'6decbf2381d194842a913042315fc4a2',1,'127.0.0.1',1633645745,1633645745),(3896,'baeb82efbf4787ef340764a870814bfc',34,'127.0.0.1',1633846314,1634163158),(3897,'83d7e1df511d6d0cd5918c3925cbc84c',34,'127.0.0.1',1633890844,1634156290),(3898,'29b64d4f0da166d41c541b5754af458d',34,'127.0.0.1',1633910879,1634162548),(3899,'a56f46a994887dfa02e83b2b5ff00ff9',1,'127.0.0.1',1633981474,1633981474),(3901,'4bb43d4c778df7f6db33249a863ea49e',1,'127.0.0.1',1634162215,1634162215),(3902,'d2319836abd4f2bd7e8f45f53411aa37',34,'127.0.0.1',1634175980,1634850993),(3903,'2903849b48d1bcbb82a6611f3bd469b8',34,'127.0.0.1',1634217426,1634756101),(3905,'c5b178e3109d4446e291883c63b15aff',34,'127.0.0.1',1634226854,1634923701),(3907,'1554075a12f6d2687fc70b09a0ecd266',1,'127.0.0.1',1634666303,1635999058),(3910,'d0691f9b91ea5162a2cc73b4ae9b49b2',34,'127.0.0.1',1634931842,1634931842),(3911,'1767268258ace9877780813501fce5a3',34,'127.0.0.1',1634985792,1634985792),(3912,'6559d692f03fa20ee3e61e590f5a914a',34,'127.0.0.1',1634997128,1635605864),(3915,'c6d8c0a4cf76b4d7d1d33c73ae41e700',34,'127.0.0.1',1635300368,1635634043),(3916,'c0162cf5bb1bd7ea90f4d1f25541d89d',34,'127.0.0.1',1635341463,1635341463),(3919,'1a3c02e65cf62f18f1ac29572dda057d',1,'127.0.0.1',1635442875,1635442875),(3921,'9c41072ff1aed9765950438c1d1c9f08',1,'127.0.0.1',1635621854,1635621854),(3922,'34e5576db5789f99c86e99471824eee1',1,'127.0.0.1',1635864511,1635864511),(3923,'00bd75dbc88f490c2407c89f9e0cf0c3',34,'127.0.0.1',1636044118,1637095331),(3924,'f21aca2185a26707c91bdc550caf6408',34,'127.0.0.1',1636151241,1637144756),(3926,'f11075606e5d2ca432dc79b51f3e8263',1,'127.0.0.1',1636651884,1636651886),(3931,'79cecc4154c64fc499e627b126984956',34,'127.0.0.1',1637157008,1637157008),(3933,'0d35fb3c254491b76541a01901466c80',1,'127.0.0.1',1637183994,1637183994),(3934,'ac95b397a55f4eb79a23c978ef2f84fa',1,'127.0.0.1',1637184585,1637184585),(3935,'9cba8b38126685607131e71a5336fd99',34,'127.0.0.1',1637245698,1638716560),(3936,'dfe43295455d31a5a4d59aac01886f55',34,'127.0.0.1',1637270377,1638825077),(3937,'6e3248aa0ba211d26e4247926a0498f4',34,'127.0.0.1',1637361682,1638483770),(3942,'0469875727eb426fb2f1f0cc090c6276',1,'127.0.0.1',1637703554,1637703554),(3943,'d06a16dd26cfe6087a0b9dce677cea2d',1,'127.0.0.1',1637784080,1637784080),(3944,'c75cc3d5cf5f14b7036925e9e7e588a4',1,'127.0.0.1',1637933085,1637933091),(3946,'6d98c01a199851d57cc3ddb2bf9c6573',1,'127.0.0.1',1638406343,1638406343),(3951,'5768af1a3de9bc29109724f3f0a43b02',1,'127.0.0.1',1638587944,1638587944),(3952,'4fcda14d616cba3a5739499933135be3',34,'127.0.0.1',1638858438,1638858438),(3953,'b1e71d10723c26726f42cf649da2ba66',34,'127.0.0.1',1638886111,1638886111),(3954,'1b2833f15e26f93f329768da9adcd09b',34,'127.0.0.1',1638900100,1638900100),(3956,'65fbd7a9819338df39984158237a1993',34,'127.0.0.1',1638933457,1638933457),(3957,'689c29266765e26b52826575ad58ca44',34,'127.0.0.1',1638935030,1641484921),(3961,'a740f3ccfabbe1b4ae968b7a56999fc4',34,'127.0.0.1',1638983167,1638983167),(3962,'238a49a95f3cb91938b1fbd3ed7be659',34,'127.0.0.1',1639068094,1641912078),(3964,'516d6e38bf160cd1ceea08acaba6613f',37,'127.0.0.1',1639099223,1639366066),(3966,'56902d33341ad6957fc356f6c73565f4',31,'127.0.0.1',1639413135,1639413135),(3967,'7f5bcf213ad4d67b1c0d7c53a086b353',31,'127.0.0.1',1639413957,1639413957),(3968,'5286d2cba0e5acc795598cfbd4c26ae4',31,'127.0.0.1',1639432897,1639446986),(3969,'5fb75184960c24c8ca64a3f775bd68ae',1,'127.0.0.1',1639505472,1639505472),(3970,'784a8254b13a5897d2799b854853b47d',31,'127.0.0.1',1639542400,1639711412),(3971,'14aa520b18d908388a77a09694dfeae6',1,'127.0.0.1',1639593974,1639593974),(3976,'68b0ca11a1e3a0e96033e34e611c5905',1,'127.0.0.1',1640087131,1640087131),(3978,'aa56b5f0089bfe0f75d1e236750c2ab5',1,'127.0.0.1',1640724337,1640724338),(3983,'5592fc4aa82603b37e7bfe3afe400562',1,'127.0.0.1',1641487512,1641487512),(3984,'facf2700abef0063eab817509e1990f2',1,'127.0.0.1',1641494979,1641494979),(3985,'7325d0f84fc1c34d27db130473ac06f6',34,'127.0.0.1',1641606883,1641606883),(3986,'cbc4e98de018e2f015f2fdaaf37c6a56',34,'127.0.0.1',1642019145,1643677422),(3988,'dace4b94e0ca622b047c6be5e7629a69',34,'127.0.0.1',1642129221,1644187683),(3989,'84cb142cdcd18aa077647266c6405c19',34,'127.0.0.1',1642169671,1644078448),(3991,'67eba12327091970a31a5db73f644c9a',34,'127.0.0.1',1642278431,1642278431),(3992,'4249eef9753d954295870f975799428c',34,'127.0.0.1',1642280203,1642280203),(3998,'781ee52f3c2ead1655def90ec2a869d0',34,'127.0.0.1',1642448297,1642448297),(3999,'39bc88aa991cb7b8921b4b4d1da4365d',1,'127.0.0.1',1642534454,1642534454),(4001,'c8836c2ae9af38e8ba61fbacaa6677c0',1,'127.0.0.1',1642794176,1642794176),(4002,'79ca0c035a40a89c1fe1226df66d4a6b',31,'127.0.0.1',1643242783,1643315276),(4004,'34cd8ba860d80aa996fb5a451766d484',1,'127.0.0.1',1643467293,1643467293),(4005,'777794f9d7d2dce23a51b38e0c5636b9',1,'127.0.0.1',1643672353,1643672353),(4008,'16e8c0cbf3c430a489b7acb137c73002',31,'127.0.0.1',1643740908,1643838609),(4009,'43a084ceac84e23a58fdec5bf5ec92c6',1,'127.0.0.1',1643755513,1643755513),(4010,'b56eb65960147c7c2f8680d8090300ad',1,'127.0.0.1',1643829401,1643831197),(4011,'a970a31e1ade09a00c975d97b47893a0',1,'127.0.0.1',1643990442,1643990442),(4012,'2a22c315a3b124974a68e6fd5f6295e3',1,'127.0.0.1',1644080783,1644080783),(4013,'31e539e8f058772161ec355c48f68693',1,'127.0.0.1',1644081490,1644081490),(4014,'8bcf7046aa6fe88656bfa0723b50e4d7',31,'127.0.0.1',1644273144,1644273144),(4016,'ebd65210813e3de6db5ce941c09f8cf8',1,'127.0.0.1',1644680220,1644680220),(4017,'1b117ecc77f3d3254de76da06e8c061b',1,'127.0.0.1',1644707659,1646150502),(4018,'4e60c12489af744bd250944911dc1aa5',34,'127.0.0.1',1644743738,1644743738),(4019,'e368a0534626437ac9f2e03d92a8a66e',34,'127.0.0.1',1644747007,1644759982),(4020,'050128ebce5cabf3f53c84b9242d69e8',34,'127.0.0.1',1644751801,1644751801),(4021,'983ce28040bb47c53c4a3574d37bb7c4',34,'127.0.0.1',1644758270,1644758270),(4022,'a86a65976bd374499f76f7a5740ed57d',34,'127.0.0.1',1644771702,1644772049),(4024,'af427f145758524073dc34498a670459',31,'127.0.0.1',1644938415,1645022692),(4027,'be146a704e252745a0e613bd4075e0b8',34,'127.0.0.1',1645224253,1645224253),(4028,'a090851656f53a0a168fa1abf9ffe136',34,'127.0.0.1',1645469231,1646923943),(4029,'018db237fc49a26a599b673146ee07a3',1,'127.0.0.1',1645556696,1646092084),(4032,'c39dae9cb3555e543f8ad62cb7274d7a',34,'127.0.0.1',1645738209,1645738209),(4033,'401af7d80f0ec39f3559945090ea06e0',1,'127.0.0.1',1645813966,1645814423),(4036,'421ba48f287446d4b9877fa42c2e81fa',31,'127.0.0.1',1646152286,1646403499),(4040,'c03cc26814b92f847607f4085f0fa5ab',31,'127.0.0.1',1647033978,1647033978),(4041,'e992d1bcc1d7b3688290a6de83192701',31,'127.0.0.1',1647272216,1647609896),(4042,'d66db5fe912a6f6ef62ff6f2d71d5724',1,'127.0.0.1',1647303546,1647303546),(4044,'bbe7d094b88682f8fb590a3a011410d9',34,'127.0.0.1',1647313759,1647701336),(4045,'008ec184d3013b6e0e4c8a59b63d21a2',1,'127.0.0.1',1647369582,1647634589),(4048,'1dc84e882ce433278067f85eb799094e',1,'127.0.0.1',1648130687,1648130687),(4051,'2bf76eb8ede215e87c80a6a2677f5a00',1,'127.0.0.1',1648474424,1648947856),(4053,'91d01421597ef6ff945d5b7138305c19',31,'127.0.0.1',1648672322,1648672322),(4054,'1b75c030bdc27aba7d767374a50000f0',1,'127.0.0.1',1648676441,1648676441),(4055,'a4a8026eb04c60c2238cddd296c25627',1,'127.0.0.1',1648854199,1648854199),(4056,'2e3d08b0a838b1bbf9da54116e96c6cb',1,'127.0.0.1',1648918043,1648918043),(4058,'ef30e74eb46fb183dfb04d7e6e1fd58c',34,'127.0.0.1',1649190678,1649190678),(4061,'2113de067a1d2b42c091a9bb1c01f4e7',31,'127.0.0.1',1649858775,1649858775),(4062,'b954847b97423e73f033a6c1618f263d',1,'127.0.0.1',1650142557,1651245627),(4067,'f3e9c18e94fb9f8883cf694a1f855919',31,'127.0.0.1',1650296143,1650336745),(4068,'921595c4f5dbe3c382b846816ec0f71f',34,'127.0.0.1',1650308840,1650725225),(4069,'bbba0ca3653211e4aaf9c4bc98e424f2',1,'127.0.0.1',1650490383,1650490383),(4071,'7f873c4eb789b76023eb604f45f75715',34,'127.0.0.1',1650735449,1650735449),(4073,'f929039d4d989b5daaa93a22ae66f903',34,'127.0.0.1',1650994438,1650994438),(4075,'69eaabea3fd9f906ec2c3203adcdb193',34,'127.0.0.1',1651177744,1651612141),(4076,'12831b2021bed52d3177114d0bba9634',31,'127.0.0.1',1651183996,1651183996),(4077,'e41f452789463426491444945406b65a',1,'127.0.0.1',1651264213,1651617141),(4078,'0cad885a589341ab71cf719e01bdbd70',34,'127.0.0.1',1651432830,1651432830),(4081,'787284c6e96f7dcfe8262f3c94bdd6c8',1,'127.0.0.1',1651588855,1651588855),(4082,'fa45c00497593dc5afd149ff62d9f36a',1,'127.0.0.1',1651617530,1651617738),(4084,'d91f8cfcc1effdd7f3b29c7ba4e37856',1,'127.0.0.1',1651784450,1654029621),(4087,'5f47346d320fe1427f517005710f663b',34,'127.0.0.1',1652280114,1653773730),(4089,'6d39a3ef9efc504802764e5d8d819164',1,'127.0.0.1',1652554849,1652554849),(4090,'e81a31ffb7b42216996ff5efebc0520d',1,'127.0.0.1',1652818656,1654190710),(4092,'83983ade8e9b43ce61e4f293f8588999',1,'127.0.0.1',1653333010,1654120040),(4093,'7d90db26ab28921915b01cf65efbcd40',1,'127.0.0.1',1653339699,1653339699),(4095,'b8d76741403a0951107a4970db2deba2',34,'127.0.0.1',1653746930,1654008499),(4096,'4fbcbab2bebfaf9b1b35c858d47b43ee',34,'127.0.0.1',1653765509,1653765509),(4098,'72421759b20408b7ddef17d74f9a0afd',34,'127.0.0.1',1653778954,1653778954),(4101,'655feade3b379e9ce74604508ec66cdb',34,'127.0.0.1',1654723457,1654723457),(4103,'4672a86ad431ad509bff40adde40c7df',1,'127.0.0.1',1654802748,1654802748),(4106,'11cf70ce0ce521f5b43828df66a4040d',34,'127.0.0.1',1655245950,1656513214),(4108,'9d1a2b7b7d700de818e4e84ede3e4ad6',1,'127.0.0.1',1655577874,1656086551),(4110,'147f36e8715283a50d205efe7f527631',1,'127.0.0.1',1655853504,1656004310),(4111,'d3f15d2e0aa629902b0df43203dc53c3',34,'127.0.0.1',1656163183,1656163183),(4115,'9ef315a11ad94bd2ab300ce2f02b61cf',1,'127.0.0.1',1656709042,1656709042),(4116,'b1624f03672e36d94c11035f477b1f2c',34,'127.0.0.1',1656908291,1657893174),(4118,'39032722ab056b517458e8121a6c5fea',1,'127.0.0.1',1657083321,1658949551),(4120,'7c38847df75683c79d4cc0cfc680df9b',34,'127.0.0.1',1657493488,1657493488),(4121,'93c8664a1029216ebede1fe77d08c0e0',34,'127.0.0.1',1657537919,1658580724),(4124,'d4e41b1eb7e83bb35f0558a660f66800',1,'127.0.0.1',1658266098,1658604263),(4125,'c00764e276893ad67e3b07a34dcfbb2d',31,'127.0.0.1',1658370737,1658544682),(4127,'ca07083f9e85ceb337cf327ecf1f12c1',34,'127.0.0.1',1658935200,1658935200),(4128,'aac731c0b0496c14775de8c1a2943572',1,'127.0.0.1',1658957065,1661024006),(4130,'e61bb5a8547457fc45c38177245ddbb7',34,'127.0.0.1',1658967977,1658967977),(4131,'1cdf81a71463a2b365b5107c4e9e8491',1,'127.0.0.1',1659232869,1661210402),(4132,'d5a8705d3b8359ab6333e3afb9a1e227',34,'127.0.0.1',1659375179,1659375179),(4133,'f56ce885b50145bb53bf31a7e55fce61',1,'127.0.0.1',1659452681,1659452681),(4135,'9588fe5455ad736b5587cb4ca0b711fe',1,'127.0.0.1',1659571965,1660068624),(4136,'aac1b0edb54a866974eb9f6b32de84db',31,'127.0.0.1',1660100319,1660100319),(4140,'67d5c3fbf2775a50ade451f449ccf6c3',1,'127.0.0.1',1660684769,1660684769),(4141,'afbf4b875a954681ca16a659d4a6cf32',34,'127.0.0.1',1660744214,1660744214),(4142,'7bfe6a869aa2ef7bcabb4f8f0dc83c17',31,'127.0.0.1',1660748134,1660748134),(4144,'38aa92a3f38a9c4e0c66e154849f4b84',34,'127.0.0.1',1661357837,1661357837),(4145,'5c43740ea065371f7e30fc2c5789366e',1,'127.0.0.1',1661363525,1662160889),(4146,'1ecc9a73e5807d55f79465b75ad5a056',34,'127.0.0.1',1661377252,1661377252),(4148,'9f99922c6da74486bb77c37286784b83',1,'127.0.0.1',1661775963,1663705408),(4149,'7e3cc5d1c8237f489b5c7c6d93ecb079',1,'127.0.0.1',1661906694,1661906694),(4151,'08864d5175a156cfeb0b35f033600d51',34,'127.0.0.1',1661964898,1661964898),(4153,'dfa75e764530b9bb6989d07d372ebdf8',1,'127.0.0.1',1662226065,1662226065),(4154,'6e5ed71ed5178a6e1635b3c8db1178d0',34,'127.0.0.1',1662226812,1662226812),(4155,'bc7721c27b83d77401410041a2485952',34,'127.0.0.1',1662309658,1662309658),(4156,'99ce6c9c5bcaa2d214d8db69141c550b',1,'127.0.0.1',1662400735,1662400735),(4157,'504a03839b3c0eb0250b3b95618d1f6c',34,'127.0.0.1',1662511246,1662511246),(4158,'a28cf9240f7de6803afcdd11bb482bcc',34,'127.0.0.1',1663198662,1663205532),(4160,'55bfb7e7ef8f5bc779c72a4f67070ac6',1,'127.0.0.1',1663862539,1666102121),(4161,'c7d347fc420d56989db256abe2358bd1',1,'127.0.0.1',1663868156,1666123191),(4165,'fbfc0b3df2e691682d010237fdf2477a',1,'127.0.0.1',1664232465,1664232465),(4169,'8ae5461f6bfd0f7f9d22ffa30b4a32bf',34,'127.0.0.1',1665005055,1665796811),(4171,'5b94ed7974fe122685208cc5b4705d0a',34,'127.0.0.1',1665431883,1665431883),(4172,'393b7433e5557aa7ca1485cf4edb190d',34,'127.0.0.1',1665436038,1665436038),(4173,'679e7e88251f44ee8d420590145e1c1b',1,'127.0.0.1',1665509343,1665509343),(4175,'550343e2b157706d52195cc2a1928bff',31,'127.0.0.1',1665761803,1665761803),(4177,'cb10f727c90458146b98ccb1ee2e6348',1,'127.0.0.1',1665852585,1665852585),(4183,'9598b4915162a2e7b8d34f51b10b1f71',34,'127.0.0.1',1666385342,1668202017),(4184,'4881a19fecf4fae4b235560a56ca3c9a',1,'127.0.0.1',1666904412,1666904412),(4186,'7b43152c8a05447de4d8576799ddcc4e',1,'127.0.0.1',1667428544,1667602819),(4187,'4d393636ee9af7d57511e9071221fe34',31,'127.0.0.1',1667961372,1667961372),(4192,'73b210771dfc823482e210be0c083bd7',34,'127.0.0.1',1668697080,1669773175),(4194,'9e9de7be5ae8d87e90be3d368a2060cd',1,'127.0.0.1',1668807413,1668807413),(4197,'74768ee32c5c1abe57ccfef6ea05c81b',34,'127.0.0.1',1669253297,1669253297),(4198,'0b3733853be486f017b27afa187ae12e',1,'127.0.0.1',1670256298,1670256298),(4200,'192912ff810720dd9fdd4d2c1ab79fdf',1,'127.0.0.1',1670433893,1670433893),(4201,'57cd0297c560fca8588d2e4cadd760a7',31,'127.0.0.1',1670538260,1670538260),(4203,'fa4e1fd5d5001d5d0efe7abf63b7151e',1,'127.0.0.1',1671123449,1674161101),(4205,'e6655be2c70b0f0dff3a3def4c526692',34,'127.0.0.1',1671477023,1671477023),(4206,'9cc169ace19b1355792e2bdc623479e1',34,'127.0.0.1',1671659136,1671659136),(4214,'1e570683e556060cb264721e25e30dcb',1,'127.0.0.1',1673459468,1673459468),(4215,'0a9f064f4b78a4343c9d78b4e9428b9c',31,'127.0.0.1',1673545448,1673545448),(4216,'a774745ecc4a9495ba5f5453ce2835e0',1,'127.0.0.1',1673556124,1673556124),(4217,'aa5742543428e325e5c0fa4854ddca68',34,'127.0.0.1',1673611515,1674043488),(4218,'3a862b320bacdf71782a4b163b4c485d',34,'127.0.0.1',1673616773,1674103063),(4219,'4df62bce0fcf01cab5ccc387e52541e0',34,'127.0.0.1',1674096500,1674098258),(4220,'8259c1868419b37b5dcc57455279e8db',34,'127.0.0.1',1674130820,1675267892),(4222,'58e5692c28886431be8b9f1d1b141463',1,'127.0.0.1',1674256878,1674256878),(4224,'dcedfc70e61ecc5eed27edd6ec0762d7',1,'127.0.0.1',1674397990,1674397990),(4225,'5e1ddfb05621bfd0d76c3f6e0ae720dd',1,'127.0.0.1',1674570305,1676508042),(4226,'74f5503739964b546740be8d077a6299',1,'127.0.0.1',1674828820,1674828820),(4227,'944410e9e17ea21a7478f9b0e1a66a46',1,'127.0.0.1',1674834072,1676508283),(4228,'a7262aacb6a2e447deebf08f4a1e2667',1,'127.0.0.1',1674836065,1674836065),(4231,'541004212dbc2111482614f35a579c6a',31,'127.0.0.1',1675307374,1675307374),(4232,'4be0809e67e298fc00fb40e54d4a997c',34,'127.0.0.1',1675363754,1676429370),(4233,'c793dc04794c3f67596379ca487d41d4',34,'127.0.0.1',1675371466,1675434372),(4234,'d49e49f9fe06cd80e170cfadabb58cd7',34,'127.0.0.1',1675704449,1676409085),(4235,'3e3fd21f11cd42b37c322ddcc72a1322',34,'127.0.0.1',1675909219,1675909219),(4236,'9c2b94c91c3b8ee3c4f3c52105eb2ad6',34,'127.0.0.1',1676046732,1676647179),(4237,'716fe09532825de8d4e5924e6f51e57b',34,'127.0.0.1',1676120382,1676290150),(4238,'b32b568c5c80d3e87851f1c219184cc8',34,'127.0.0.1',1676291294,1676291294),(4240,'6e3f21da96bc20b351a80e4f4b075b15',1,'127.0.0.1',1677158875,1677158875),(4241,'2f0e28e8d1b3f4a5f0120b07c1cb4470',1,'127.0.0.1',1677200573,1677763008),(4246,'ae4df4695699f7e111e15954a867c6df',1,'127.0.0.1',1677762969,1690584996),(4254,'6d544df64ef235cc9ebfcc210ae4e8b4',38,'127.0.0.1',1680189870,1680189870),(4258,'95468d816d9a03aeea44c37c56c6db17',38,'127.0.0.1',1680267957,1680267958),(4259,'0d9ca95d269ba67b688b5d2ac7d67a96',38,'127.0.0.1',1680270181,1680270181),(4260,'3f52bf7cd13b336a10e29b35d6ff2da5',38,'127.0.0.1',1680525467,1681130561),(4262,'e70e84632f6d1b9348efcc5c84aeb361',38,'127.0.0.1',1681217211,1681217217),(4263,'8d24b93ca75e1d7b364f74761e6c1666',38,'127.0.0.1',1681492863,1681925351),(4265,'d2e8665ee06312aedd380e795031bbd7',38,'127.0.0.1',1681758424,1681931752),(4269,'27065567f53ccd42f43e5c56705aaa60',38,'127.0.0.1',1681957163,1681957163),(4270,'953969d0d85737a6848ae68dc9c195b0',38,'127.0.0.1',1682461810,1682461810),(4271,'a5ed57b465c52359570e6acf4bb5e7c7',38,'127.0.0.1',1682690413,1682690413),(4272,'f1b3ce7035f1bebeb2ff53673f93f8ed',38,'127.0.0.1',1682691176,1682691176),(4274,'6c6d98a439a22d9b2c1dea4f19d8271a',38,'127.0.0.1',1683293979,1684595010),(4275,'6581fd42625df68f765b9f19f3a8cac8',34,'127.0.0.1',1683314070,1683636408),(4276,'8b2096a31f2be15641e06b0a8d612db2',34,'127.0.0.1',1683338119,1683338119),(4277,'015c699fa4991c3c3a5482dbec72c713',38,'127.0.0.1',1683553765,1683553767),(4279,'e3e43652795cc94ceb6d71dc3a53dafe',38,'127.0.0.1',1683815250,1685712387),(4280,'6b9548043c49f5a9b57918474e0f760d',38,'127.0.0.1',1683984147,1683984147),(4281,'909432c6d06cd6501ff23c35efd8f4ea',38,'127.0.0.1',1683984436,1684155277),(4284,'503a3ee4cbfce47476708571749c3c13',38,'127.0.0.1',1684333828,1691079387),(4287,'2d0e29079388621a578a02347d9b1885',34,'127.0.0.1',1684419065,1685470364),(4288,'e88d3512699b64e418f68d7266ac4170',38,'127.0.0.1',1684847424,1684933830),(4289,'3296d23d4e311f1fc46674ddf09d02e3',38,'127.0.0.1',1684942039,1685378383),(4290,'93aac7d928d04995de25799ab464c750',1,'127.0.0.1',1684944537,1684944537),(4291,'6f9ec1e03a86320ba6fd01c9b885db85',38,'127.0.0.1',1685133942,1686141456),(4292,'405c979fc4e9c82be85f0b52a93589f8',38,'127.0.0.1',1685365695,1685552016),(4293,'ba770770a1c4933fc41637d4428b991f',38,'127.0.0.1',1685377706,1685377706),(4295,'d46d6e6b35b94906dab91b276a0a388c',38,'127.0.0.1',1685461384,1685461385),(4296,'af6bc045549786cac27c38f516549373',38,'127.0.0.1',1685475438,1685475438),(4297,'08c94998a9fe55f19d2c18c7cfde5ab8',38,'127.0.0.1',1685476893,1685476893),(4298,'d769cb117ad868f1a9b3d011f792afc8',38,'127.0.0.1',1685477293,1685477293),(4299,'017ae4df9d6f9eae41d817ba1a1c1fd8',38,'127.0.0.1',1685480016,1685480016),(4300,'5f81dda961ab35975ac72f291a72596d',38,'127.0.0.1',1685502838,1685502838),(4302,'b116779928bdb535b27ba17530accd32',34,'127.0.0.1',1685741274,1685741274),(4303,'9ba44ebf87be1b586aa65f8d64b76668',38,'127.0.0.1',1685818009,1685818009),(4305,'6a9513d515bfd28328e706245cdd5e3b',38,'127.0.0.1',1685970794,1688562648),(4307,'367ec1a74ecea8d07f2cf7843fdedc6d',38,'127.0.0.1',1685983637,1685983637),(4308,'f6047401a5090b641f29fadc5158cfe5',38,'127.0.0.1',1686057113,1686057113),(4309,'9296fb26a34e963bca7f7e48f0d56f63',38,'127.0.0.1',1686662572,1686662572),(4310,'3cbf708d7169323991616d467c478a1e',38,'127.0.0.1',1687147783,1687147783),(4311,'c4fcd21cda0ce8f5f022e1fac5487d3d',38,'127.0.0.1',1687292343,1687298619),(4314,'cbd4665a3844f4759e0b0fd356dfe1cb',38,'127.0.0.1',1687367522,1687562493),(4317,'da56c57bc8f42c9ee1010fd8bf355d4c',38,'127.0.0.1',1687460188,1687460188),(4319,'23b323fee787d67f9a10f2837c7226d4',38,'127.0.0.1',1687881116,1687881117),(4320,'7302ae9d2eeb3bc57aab7c7cf42e37fb',38,'127.0.0.1',1688045428,1688045428),(4321,'7efa2ee0f7c6657d1c6790af1d54ec0e',38,'127.0.0.1',1688220645,1688220645),(4322,'1e082221788214ec06da11421cb09f29',38,'127.0.0.1',1688650732,1688650732),(4323,'4165a13eca66bee62f5860f32bd94d0e',38,'127.0.0.1',1688735609,1688735610),(4324,'86fb8ac641f1e1283acd04ce55844998',38,'127.0.0.1',1688754374,1690470380),(4325,'4f5d0a63469ccc6ebda24af018705438',38,'127.0.0.1',1689010415,1689010415),(4326,'7be445462144f54749d04db2341bf93c',34,'127.0.0.1',1689011926,1689011926),(4327,'7d961fc635eca44db1db634fa46176cb',38,'127.0.0.1',1689270722,1689270722),(4328,'0bc19514f252d31c14eafa461a533b96',38,'127.0.0.1',1689279350,1689280207),(4329,'05052c0377cc92529f0096b95ef07bb6',38,'127.0.0.1',1689691825,1689691825),(4330,'57a8d77a56f7a7615ffbf4e59fcfea3b',34,'127.0.0.1',1689696668,1689696668),(4332,'55ad0ec47ddd5bf1aec29ba3bce7eca1',38,'127.0.0.1',1689960340,1690228168),(4333,'79519d38db0e1a0369c10b432bff6346',38,'127.0.0.1',1689967967,1689967967),(4334,'53a97e76e032a8a1f24d660cbcd046ed',38,'127.0.0.1',1690155127,1690155127),(4336,'78f80f934d4afe2fe2cd0cdca2c8ac5d',38,'127.0.0.1',1690471246,1691069311),(4337,'44b31609973d97e6e9e744604565ca0d',38,'127.0.0.1',1690938431,1690938431),(4341,'6276cc0b93d048eb2d5c3c095179092e',34,'127.0.0.1',1692197234,1692197234),(4342,'2296a0d7fa5da38b5d094c04f665534b',38,'127.0.0.1',1692367344,1692801405),(4343,'e4929c5c01488dc7d1b3286215d5d3de',38,'127.0.0.1',1692375442,1692390442),(4344,'ee9068250fd12529f023e62a47bf30db',38,'127.0.0.1',1692727496,1692727497),(4345,'c8848a4c018684e93859db09467d0916',34,'127.0.0.1',1692739650,1692739650),(4346,'1271e458493256b78da6eb6c843e4e00',38,'127.0.0.1',1692763620,1692763621),(4347,'a47212e4f0e2eca342504ac7782a82aa',38,'127.0.0.1',1692850778,1692850779),(4349,'390e5eca4881079098d6183a33b296e4',38,'127.0.0.1',1693259749,1693259749),(4350,'7421976d730fa7431e42f6d1c596e682',34,'127.0.0.1',1693430193,1693430193),(4352,'38c7f35b63705dcd8fbbfd1646d2c207',38,'127.0.0.1',1693491518,1693491518),(4353,'beec5b2c52ad9edfa109a6122a4d1269',38,'127.0.0.1',1693515088,1693515088),(4354,'4acb7b9c0389288a43dfec26d3d31828',38,'127.0.0.1',1693579385,1693579385),(4355,'cc11203a947cfa5e787caf85b7108746',34,'127.0.0.1',1693622262,1693622263),(4356,'a0921149cf9952b46016760cc804e243',38,'127.0.0.1',1693660263,1693660263),(4360,'77ac0ebe41f750c909e115cbe0762a84',38,'127.0.0.1',1693857796,1693857796),(4361,'30a3ca9cd225f3362bdd3c69adfe5ec1',38,'127.0.0.1',1693879934,1693972432),(4363,'1117ad87b9d5cbafeda621f27b035d99',34,'127.0.0.1',1693947479,1693947479),(4364,'212e5ad983be08e53165098edf90ca19',38,'127.0.0.1',1693972882,1693972882),(4365,'1185ec7d2d8df3dc18711843d584fbb9',34,'127.0.0.1',1694008963,1694010208),(4366,'fb0e36ef02ada73d4cafccb996d08f97',38,'127.0.0.1',1694009717,1694011005),(4367,'e9fe3f2b65504360953ebbfeb5da038e',38,'127.0.0.1',1700498593,1700498593),(4369,'5c1f253d55a43f524b239a72b436eb47',38,'127.0.0.1',1701873779,1701873779),(4370,'1dda96c6985a57890670f0e5bdcbc53b',38,'127.0.0.1',1701955116,1702177516),(4371,'4611d678bdc11df49ce4ba5d84e3efec',38,'127.0.0.1',1702126051,1702209392);

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

CREATE TABLE `sucursal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
  `predeterminado` char(1) COLLATE utf8_unicode_ci DEFAULT 'N',
  PRIMARY KEY (`id`),
  KEY `predeterminado` (`predeterminado`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_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(10) unsigned NOT NULL AUTO_INCREMENT,
  `sucursal_id` int(10) unsigned NOT NULL,
  `login` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `clave` char(40) COLLATE utf8_unicode_ci NOT NULL,
  `clave_corta` char(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fingerprint` char(48) COLLATE utf8_unicode_ci DEFAULT NULL,
  `apellidos` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nombres` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `nombre_completo` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `genero` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `usuarios_front_id` int(10) unsigned DEFAULT NULL,
  `usuarios_pos_id` int(10) unsigned DEFAULT NULL,
  `clave_fecha` date DEFAULT NULL,
  `creado_at` datetime DEFAULT NULL,
  `estado` char(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `login` (`login`),
  KEY `fingerprint` (`fingerprint`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_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'),(31,1,'contador.cc','21aa42202665b5fe32105ecab588a70bdc1ed66d',NULL,'807DC9B8BE07A47B5838D40A85099D032F89A202C8E5E7FD','CONTADOR','HOTEL COSTA CHOCO','HOTEL COSTA CHOCO CONTADOR',NULL,'M',1,NULL,NULL,'2019-07-06 13:23:58','A'),(32,1,'contador.cc1','e6eeabc62f1b95d1bfb92914cb3211a392223656',NULL,'1661B11DE4E88671705245CB93961021C04E16DD0B481FFC','contador','1','1 CONTADOR',NULL,'M',1,NULL,NULL,'2019-07-08 21:45:35','A'),(33,1,'contador.cc2','11888176778588bfc97e85ee919e365e73a87be8',NULL,'8C9D30F57CD35943C34EAF6D282455594B49B20CF1BAF3BD','VALOYES','SEBASTIAN','SEBASTIAN VALOYES',NULL,'M',7,NULL,NULL,'2019-07-18 23:12:30','A'),(34,1,'contador.cc3','982be634f4a53a33bc19ed38cc27805ac01c81ed',NULL,'4C91B5AB4D9E1D155574C217371482DA12B360D464ABE5A7','CASTRO','MARCELA','MARCELA CASTRO',NULL,'F',1,NULL,NULL,'2019-07-18 23:13:00','A'),(35,1,'almacen.cc','3530db1ba60ca7b7526002af32e8fbfbe6a5e2d8',NULL,'B0D68E7F8484E8387C0C67079E8D37632836ED3CD854F554','costa choco','almacen','ALMACEN COSTA CHOCO',NULL,'M',7,NULL,NULL,'2019-08-29 05:56:21','A'),(36,1,'contador1.cc','e883ae64e4fd13c07589322315e0c3e2340e0f2d',NULL,'86885601E58FB2A088A8C894BCA14E5D540202F51043CFAF','LEON','DIEGO','DIEGO LEON','1','M',1,NULL,NULL,'2019-11-10 18:33:45','A'),(37,1,'presidencia','46a25636f470592f959e674e98c72ccf4c61957c',NULL,'EAF4918035CDC256DA7D48A5C4D447DC1D1BE32ECAE1D102','PRESIDENCIA','PRESIDENCIA','PRESIDENCIA PRESIDENCIA',NULL,'M',14,NULL,NULL,'2021-12-03 12:42:30','A'),(38,1,'contador.perini','2ae24741dd7c26fac0fcb4e8ae9d4ed5cf06d616',NULL,'C2E64CE09037954CA1849D7D6E08C5FE8029E8C584F6F1BD','panaderosos','contador','CONTADOR PANADEROSOS',NULL,'M',1,NULL,NULL,'2023-02-23 20:03:51','A');


