
START TRANSACTION;



USE `pb_base`;


--
-- Volcar la base de datos para la tabla `idioma`
--

INSERT INTO `idioma` (`idi_id`, `idi_nombre`, `idi_i18n`, `idi_descripcion`, `idi_estado_activo`, `idi_fecha_creacion`, `idi_fecha_modificacion`, `idi_estado_logico`) VALUES
(1, 'Ingles', 'en', 'Idioma Ingles americano', '1', '2012-08-25 05:53:17', NULL, '1'),
(2, 'Español', 'es', 'Idioma español', '1', '2012-08-25 05:53:17', NULL, '1');

--
-- Volcar la base de datos para la tabla `plantilla`
--

INSERT INTO `plantilla` (`pla_id`, `pla_nombre`, `pla_dir_name`, `pla_estado_activo`, `pla_fecha_creacion`, `pla_fecha_modificacion`, `pla_estado_logico`) VALUES
(1, 'Axel', 'axel', '1', '2012-08-25 05:51:17', '2012-08-25 05:51:17', '1');


--
-- Volcar la base de datos para la tabla `accion`
--

INSERT INTO `accion` (`acc_id`, `acc_nombre`, `acc_url_accion`, `acc_tipo`, `acc_descripcion`, `acc_lang_file`, `acc_dir_imagen`, `acc_estado_activo`, `acc_fecha_creacion`, `acc_fecha_modificacion`, `acc_estado_logico`) VALUES
(1, 'Create', 'Create', 'General', 'Create', 'accion', 'fas fa-plus', '1', '2012-09-19 21:21:35', NULL, '1'),
(2, 'Update', 'Update', 'General', 'Update', 'accion', 'fas fa-floppy-disk', '1', '2012-09-19 21:21:35', NULL, '1'),
(3, 'Delete', 'Delete', 'General', 'Delete', 'accion', 'fas fa-trash', '1', '2012-09-19 21:21:35', NULL, '1'),
(4, 'Save', 'Save', 'General', 'Save', 'accion', 'fas fa-floppy-disk', '1', '2012-09-19 21:21:35', NULL, '1'),
(5, 'Search', 'Search', 'General', 'Search', 'accion', 'fas fa-search', '1', '2012-09-19 21:21:35', NULL, '1'),
(6, 'Print', 'Print', 'General', 'Print', 'accion', 'fas fa-print', '1', '2012-09-19 21:21:35', NULL, '1'),
(7, 'Import', 'Import', 'General', 'Import', 'accion', 'fas fa-file-import', '1', '2012-09-19 21:21:35', NULL, '1'),
(8, 'Export', 'Export', 'General', 'Export', 'accion', 'fas fa-file-export', '1', '2012-09-19 21:21:35', NULL, '1'),
(9, 'Back', 'Back', 'General', 'Back', 'accion', 'fas fa-triangle-right', '1', '2012-09-19 21:21:35', NULL, '1'),
(10, 'Next', 'Next', 'General', 'Next', 'accion', 'fas fa-triangle-left', '1', '2012-09-19 21:21:35', NULL, '1'),
(11, 'Clear', 'Clear', 'General', 'Clear', 'accion', 'fas fa-leaf', '1', '2012-09-19 21:21:35', NULL, '1'),
(12, 'Edit','Edit','General','Edit','accion','fas fa-pencil','1','2017-02-01 20:05:26',NULL,'1'),
(13, 'Logout','Logout','General','Logout','accion','fas fa-log-out','1','2017-02-01 20:05:26',NULL,'1'),
(14, 'Approve','Approve','General','Approve','accion','fas fa-thumbs-up','1','2017-02-01 20:05:26',NULL,'1');

--
-- Volcar la base de datos para la tabla `aplicacion`
--

INSERT INTO `aplicacion` (`apl_id`, `apl_nombre`, `apl_tipo`, `apl_estado_activo`, `apl_fecha_creacion`, `apl_fecha_modificacion`, `apl_estado_logico`) VALUES
(1, 'Framework', 'General', '1', '2012-08-25 00:01:57', NULL, '1');

--
-- Volcar la base de datos para la tabla `tipo_password`
--

INSERT INTO `tipo_password` (`tpas_id`, `tpas_tipo`, `tpas_validacion`, `tpas_descripcion`, `tpas_estado_activo`, `tpas_fecha_creacion`, `tpas_fecha_modificacion`, `tpas_estado_logico`) VALUES
(1, 'Simples', '/^(?=.*[a-z])(?=.*[A-Z]).{VAR,}$/', 'Las claves simples deben cumplir con lo mínimo: Caracteres alfabéticos (Mayúsculas y minúsculas).', '1', '2012-08-28 15:00:00', '2012-08-28 15:00:00', '1'),
(2, 'Semicomplejas', '/^(?=.*[a-z])(?=.*[A-Z])(?=.*\\d).{VAR,}$/', 'Las claves semicomplejas deben cumplir con lo mínimo: Caracteres alfabéticos (Mayúsculas y minúsculas). ', '1', '2012-08-29 02:57:58', '2012-08-29 02:57:58', '1'),
(3, 'Complejas', '/^(?=.*[a-z])(?=.*[A-Z])(?=.*\\d)(?=.*[@\\,\\;#¿\\?\\}\\{\\]\\[\\-_¡!\\=&\\^:<>\\.\\+\\*\\/\\$\\(\\)]).{VAR,}$/', 'Las claves complejas deben cumplir con lo mínimo: Caracteres alfabéticos (Mayúsculas y minúsculas).\nSímbolos: @ ,  ; # ¿ ? }  {  ]  [ - _ ¡  ! = & ^ : < > . + * / ( )', '1', '2012-08-29 02:57:58', '2012-08-29 02:57:58', '1');


--
-- Volcar la base de datos para la tabla `configuracion_seguridad`
--

INSERT INTO `configuracion_seguridad` (`cseg_id`, `tpas_id`, `cseg_long_pass`, `cseg_expiracion`, `cseg_descripcion`, `cseg_estado_activo`, `cseg_fecha_creacion`, `cseg_fecha_modificacion`, `cseg_estado_logico`) VALUES
(1, 1, '5', 0, 'Claves Simples min 5 caracteres. No tiene caducidad.', '1', '2013-10-15 09:19:35', '2012-08-28 15:00:00', '1'),
(2, 2, '6', 30, 'Claves SemiComplejas min 6 caracteres. Caducidad 30 dias.', '1', '2013-10-15 09:19:32', '2012-08-29 03:02:20', '1'),
(3, 3, '7', 60, 'Claves Complejas min 7 caracteres. Caducidad 60 dias.', '1', '2013-10-15 09:19:24', '2012-08-29 03:02:20', '1');



--
-- Volcar la base de datos para la tabla `tipo_empresa`
--

INSERT INTO `tipo_empresa` (`temp_id`, `temp_nombre`, `temp_descripcion`, `temp_estado_activo`, `temp_fecha_creacion`, `temp_fecha_modificacion`, `temp_estado_logico`) VALUES
(1, 'Empresa Pública', NULL, '1', '2014-12-11 15:17:35', NULL, '1'),
(2, 'Empresa Privada', NULL, '1', '2014-12-11 15:17:35', NULL, '1'),
(3, 'Institución Pública', NULL, '1', '2014-12-11 15:17:35', NULL, '1'),
(4, 'Privada', NULL, '1', '2014-12-11 15:17:35', NULL, '1');


--
-- Volcar la base de datos para la tabla `grupo`
--

INSERT INTO `grupo` (`gru_id`, `cseg_id`, `gru_nombre`, `gru_color`, `gru_descripcion`, `gru_estado_activo`, `gru_fecha_creacion`, `gru_fecha_modificacion`, `gru_estado_logico`) VALUES
(1, 1, 'Super Admin', '#75AFE1', 'Grupo Super Admin', '1', '2012-09-03 15:00:00', NULL, '1'),
(2, 1, 'Admin', '#60AFE1', 'Grupo Admin', '1', '2012-09-03 15:00:00', NULL, '1'),
(3, 1, 'Ventas', '#60AFE1', 'Ventas', '1', '2012-09-03 15:00:00', NULL, '1'),
(4, 1, 'Contabilidad', '#60AFE1', 'Contabilidad', '1', '2012-09-03 15:00:00', NULL, '1'),
(5, 1, 'Sistemas', '#60AFE1', 'Sistemas', '1', '2012-09-03 15:00:00', NULL, '1'),
(6, 1, 'Marketing', '#60AFE1', 'Marketing', '1', '2012-09-03 15:00:00', NULL, '1'),
(7, 1, 'Profesor', '#60AFE1', 'Profesor', '1', '2012-09-03 15:00:00', NULL, '1');

--
-- Volcar la base de datos para la tabla `rol`
--

INSERT INTO `rol` (`rol_id`, `rol_nombre`, `rol_color`, `rol_descripcion`, `rol_estado_activo`, `rol_fecha_creacion`, `rol_fecha_modificacion`, `rol_estado_logico`) VALUES
(1, 'Administrador', '#45E4B1', 'Rol Administrador', '1', '2012-09-03 15:00:00', NULL, '1'),
(2, 'Gerencia', '#1BA97C', 'Rol Gerencia', '1', '2012-09-03 15:00:00', NULL, '1'),
(3, 'Coordinador', '#4CCE35', 'Rol Coordinador', '1', '2012-09-03 15:00:00', NULL, '1'),
(4, 'Supervisor', '#CE3565', 'Rol Supervisor', '1', '2012-09-03 15:00:00', NULL, '1'),
(5, 'Operador', '#C735CE', 'Rol Operador', '1', '2012-09-03 15:00:00', NULL, '1'),
(6, 'Usuario', '#C735CE', 'Rol Usuario', '1', '2012-09-03 15:00:00', NULL, '1');

--
-- Volcar la base de datos para la tabla `empresa`
--

INSERT INTO `empresa` (`emp_id`, `temp_id`, `emp_razon_social`, `emp_nombre_comercial`, `emp_alias`, `emp_ruc`, `emp_dominio`, `emp_imap_domain`, `emp_imap_port`, `emp_imap_user`, `emp_imap_pass`, `emp_direccion`, `emp_telefono`, `emp_descripcion`, `emp_estado_activo`, `emp_fecha_creacion`, `emp_fecha_modificacion`, `emp_estado_logico`) VALUES
(1, 4, 'Federacion Estudiantil', 'FedeEstud', 'FedeEstud', '', 'fede.com.ec', 'fede.com', '587', '', '', NULL, NULL, NULL, '1', CURRENT_TIMESTAMP, NULL, '1');

--
-- Volcar la base de datos para la tabla `usuario`
--

INSERT INTO `persona` (`per_id`, `per_nombres`, `per_apellidos`, `per_cedula`, `per_ruc`, `per_pasaporte`, `pai_id_nacimiento`, `pro_id_nacimiento`, `can_id_nacimiento`, `par_id_nacimiento`, `per_fecha_nacimiento`, `per_domicilio_direccion`, `per_domicilio_telefono`, `pro_id_domicilio`, `can_id_domicilio`, `par_id_domicilio`, `per_celular`, `per_trabajo_nombre`, `per_trabajo_direccion`, `per_trabajo_telefono`, `prof_id`, `pro_id_trabajo`, `can_id_trabajo`, `par_id_trabajo`, `per_codigo_postal`, `per_genero`, `per_estado_civil`, `per_correo`, `per_foto`, `per_estado_activo`, `per_fecha_creacion`, `per_fecha_modificacion`, `per_estado_logico`) VALUES
(1, 'Sys', 'Admin', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'S', NULL, NULL, '1', CURRENT_TIMESTAMP, NULL, '1');

--
-- Volcar la base de datos para la tabla `usuario`
--

INSERT INTO `usuario`(`usu_id`, `per_id`, `usu_username`, `usu_password`, `usu_sha`, `usu_session`, `usu_last_login`, `usu_estado_activo`, `usu_fecha_creacion`, `usu_fecha_modificacion`, `usu_estado_logico`, `usu_agent_code`) VALUES
(1, 1, 'admin', 'Oe0XnfQV1rITyhra1D9NSTk2NzMyY2VhZDE2ZGY2NTM4NmM1ZGNkZmU2MTBjYjEyZjZkN2Q0ZWY0NjYxMmM5MGIwNDZjNjI1MzUxMzY5MWIXYpkgqqqFS/QKaxVARLLmArjJ7iD39CoAVhUhD69so1Aa/WoTy6Qvmatc2VKvXWc2b2npklLgwwBil3xKV8l1', 'gJzWo7FQ-zmMcuy4cpWrTrVDmTRCFJcs', NULL, NULL, '1', '2015-04-10 13:00:00', NULL, '1', NULL);

--
-- Volcar la base de datos para la tabla `empresa_persona`
--

INSERT INTO `empresa_persona`(`eper_id`, `emp_id`, `per_id`, `eper_estado_activo`, `eper_fecha_creacion`, `eper_fecha_modificacion`, `eper_estado_logico`) VALUES
(1, 1, 1, '1', '2015-04-10 13:00:00', NULL, '1');


--
-- Volcar la base de datos para la tabla `grup_rol`
--

INSERT INTO `grupo_rol` (`grol_id`, `gru_id`, `rol_id`, `grol_estado_activo`, `grol_fecha_creacion`, `grol_fecha_modificacion`, `grol_estado_logico`) VALUES
(1, 1, 1, '1', '2012-09-03 20:00:00', NULL, '1'),
(2, 2, 2, '1', '2012-09-03 20:00:00', NULL, '1'),
(3, 3, 2, '1', '2012-09-03 20:00:00', NULL, '1'),
(4, 3, 3, '1', '2012-09-03 20:00:00', NULL, '1'),
(5, 3, 4, '1', '2012-09-03 20:00:00', NULL, '1'),
(6, 3, 5, '1', '2012-09-03 20:00:00', NULL, '1'),
(7, 4, 2, '1', '2012-09-03 20:00:00', NULL, '1'),
(8, 4, 3, '1', '2012-09-03 20:00:00', NULL, '1'),
(9, 4, 4, '1', '2012-09-03 20:00:00', NULL, '1'),
(10, 4, 5, '1', '2012-09-03 20:00:00', NULL, '1'),
(11, 5, 2, '1', '2012-09-03 20:00:00', NULL, '1'),
(12, 5, 3, '1', '2012-09-03 20:00:00', NULL, '1'),
(13, 5, 4, '1', '2012-09-03 20:00:00', NULL, '1'),
(14, 5, 5, '1', '2012-09-03 20:00:00', NULL, '1'),
(15, 6, 2, '1', '2012-09-03 20:00:00', NULL, '1'),
(16, 6, 3, '1', '2012-09-03 20:00:00', NULL, '1'),
(17, 6, 4, '1', '2012-09-03 20:00:00', NULL, '1'),
(18, 6, 5, '1', '2012-09-03 20:00:00', NULL, '1'),
(19, 7, 6, '1', '2012-09-03 20:00:00', NULL, '1');


--
-- Volcar la base de datos para la tabla `modulo`
--

INSERT INTO `modulo` (`mod_id`, `apl_id`, `mod_nombre`, `mod_tipo`, `mod_dir_imagen`, `mod_url`, `mod_orden`, `mod_lang_file`, `mod_estado_activo`, `mod_fecha_creacion`, `mod_fecha_modificacion`, `mod_estado_logico`) VALUES
(1, 1, 'Dashboard', 'General', 'glyphicon glyphicon-home', 'site/index', 1, 'dashboard', '1', '2012-08-26 01:47:23', NULL, '1'),
(2, 1, 'My Account', 'General', 'glyphicon glyphicon-user', 'perfil/index', 2, 'menu', '1', '2012-08-26 01:47:23', NULL, '1'),
-- (3, 1, 'Schedule', 'General', 'glyphicon glyphicon-calendar', 'calendar/index', 3, 'menu', '1', '2012-08-26 01:47:23', NULL, '1'),
-- (4, 1, 'Email', 'General', 'glyphicon glyphicon-envelope', 'email/index', 4, 'menu', '1', '2012-08-26 01:47:23', NULL, '1'),
(5, 1, 'Administration', 'General', 'glyphicon glyphicon-th-large', 'administracion/index', 5, 'menu', '1', '2012-08-26 01:47:23', NULL, '1');

--
-- Volcar la base de datos para la tabla `objeto_modulo`
--

INSERT INTO `objeto_modulo` (`omod_id`, `mod_id`, `omod_padre_id`, `omod_nombre`, `omod_tipo`, `omod_tipo_boton`, `omod_accion`, `omod_function`, `omod_dir_imagen`, `omod_entidad`, `omod_orden`, `omod_estado_visible`, `omod_lang_file`, `omod_estado_activo`, `omod_fecha_creacion`, `omod_fecha_modificacion`, `omod_estado_logico`) VALUES
(1, 5, 1, 'Groups and Permissions', 'P', '0', 'Administration', '', '', '', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(2, 5, 1, 'Group', 'S', '0', 'Administration', '', '', 'grupo/index', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(3, 5, 2, 'Create Group', 'S', '0', 'Administration', '', '', 'grupo/new', 1, '0', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(4, 5, 2, 'Create Group', 'A', '0', 'Administration', '', '', '', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(5, 5, 3, 'Save Group', 'A', '0', 'Administration', '', '', 'grupo/save', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(6, 5, 2, 'View Group', 'S', '0', 'Administration', '', '', 'grupo/view', 1, '0', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(7, 5, 6, 'Edit Group', 'A', '0', 'Administration', '', '', '', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(8, 5, 2, 'Edit Group', 'S', '0', 'Administration', '', '', 'grupo/edit', 1, '0', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(9, 5, 8, 'Update Group', 'A', '0', 'Administration', '', '', 'grupo/update', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(10, 5, 1, 'Role', 'S', '0', 'Administration', '', '', 'rol/index', 2, '1', 'rol', '1', '2018-09-16 08:48:06', NULL, '1'),
(11, 5, 10, 'Create Role', 'S', '0', 'Administration', '', '', 'rol/new', 1, '0', 'rol', '1', '2018-09-16 08:48:06', NULL, '1'),
(12, 5, 10, 'Create Role', 'A', '0', 'Administration', '', '', '', 1, '1', 'rol', '1', '2018-09-16 08:48:06', NULL, '1'),
(13, 5, 11, 'Save Role', 'A', '0', 'Administration', '', '', 'rol/save', 1, '1', 'rol', '1', '2018-09-16 08:48:06', NULL, '1'),
(14, 5, 10, 'View Role', 'S', '0', 'Administration', '', '', 'rol/view', 1, '0', 'rol', '1', '2018-09-16 08:48:06', NULL, '1'),
(15, 5, 10, 'Edit Role', 'S', '0', 'Administration', '', '', 'rol/edit', 1, '0', 'rol', '1', '2018-09-16 08:48:06', NULL, '1'),
(16, 5, 14, 'Edit Role', 'A', '0', 'Administration', '', '', 'rol/edit', 1, '1', 'rol', '1', '2018-09-16 08:48:06', NULL, '1'),
(17, 5, 15, 'Update Role', 'A', '0', 'Administration', '', '', 'rol/update', 1, '1', 'rol', '1', '2018-09-16 08:48:06', NULL, '1'),
(18, 5, 1, 'Permissions', 'S', '0', 'Administration', '', '', 'permisos/index', 3, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(19, 5, 18, 'Create Permission', 'S', '0', 'Administration', '', '', 'permisos/new', 1, '0', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(20, 5, 18, 'Create Permission', 'A', '0', 'Administration', '', '', '', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(21, 5, 19, 'Save Permission', 'A', '0', 'Administration', '', '', 'permisos/save', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(22, 5, 18, 'View Permission', 'S', '0', 'Administration', '', '', 'permisos/view', 1, '0', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(23, 5, 18, 'Edit Permission', 'S', '0', 'Administration', '', '', 'permisos/edit', 1, '0', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(24, 5, 22, 'Edit Permission', 'A', '0', 'Administration', '', '', '', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(25, 5, 23, 'Update Permission', 'A', '0', 'Administration', '', '', 'permisos/update', 1, '1', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(26, 5, 1, 'Actions', 'S', '0', 'Administration', '', '', 'acciones/index', 4, '1', 'accion', '1', '2018-09-16 08:48:06', NULL, '1'),
(27, 5, 26, 'Create Action', 'S', '0', 'Administration', '', '', 'acciones/new', 1, '0', 'accion', '1', '2018-09-16 08:48:06', NULL, '1'),
(28, 5, 26, 'Create Action', 'A', '0', 'Administration', '', '', '', 1, '1', 'accion', '1', '2018-09-16 08:48:06', NULL, '1'),
(29, 5, 27, 'Save Action', 'A', '0', 'Administration', '', '', 'acciones/save', 1, '1', 'accion', '1', '2018-09-16 08:48:06', NULL, '1'),
(30, 5, 26, 'View Action', 'S', '0', 'Administration', '', '', 'acciones/view', 1, '0', 'accion', '1', '2018-09-16 08:48:06', NULL, '1'),
(31, 5, 26, 'Edit Action', 'S', '0', 'Administration', '', '', 'acciones/edit', 1, '0', 'accion', '1', '2018-09-16 08:48:06', NULL, '1'),
(32, 5, 30, 'Edit Action', 'A', '0', 'Administration', '', '', '', 1, '1', 'accion', '1', '2018-09-16 08:48:06', NULL, '1'),
(33, 5, 31, 'Update Action', 'A', '0', 'Administration', '', '', 'acciones/update', 1, '1', 'accion', '1', '2018-09-16 08:48:06', NULL, '1'),
(34, 5, 34, 'Module and SubModule', 'P', '0', 'Administration', '', '', '', 3, '1', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(35, 5, 34, 'Modules', 'S', '0', 'Administration', '', '', 'modulos/index', 1, '1', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(36, 5, 35, 'Create Module', 'S', '0', 'Administration', '', '', 'modulos/new', 1, '0', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(37, 5, 35, 'Create Module', 'A', '0', 'Administration', '', '', '', 1, '1', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(38, 5, 36, 'Save Module', 'A', '0', 'Administration', '', '', 'modulos/save', 1, '1', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(39, 5, 35, 'View Module', 'S', '0', 'Administration', '', '', 'modulos/view', 1, '0', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(40, 5, 35, 'Edit Module', 'S', '0', 'Administration', '', '', 'modulos/edit', 1, '0', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(41, 5, 39, 'Edit Module', 'A', '0', 'Administration', '', '', '', 1, '1', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(42, 5, 40, 'Update Module', 'A', '0', 'Administration', '', '', 'modulos/update', 1, '1', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(43, 5, 34, 'SubModules', 'S', '0', 'Administration', '', '', 'objetomodulos/index', 2, '1', 'objetomodulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(44, 5, 43, 'Create SubModule', 'S', '0', 'Administration', '', '', 'objetomodulos/new', 1, '0', 'objetomodulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(45, 5, 43, 'Create SubModule', 'A', '0', 'Administration', '', '', '', 1, '1', 'objetomodulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(46, 5, 44, 'Save SubModule', 'A', '0', 'Administration', '', '', 'objetomodulos/save', 1, '1', 'objetomodulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(47, 5, 43, 'View SubModule', 'S', '0', 'Administration', '', '', 'objetomodulos/view', 1, '0', 'objetomodulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(48, 5, 43, 'Edit SubModule', 'S', '0', 'Administration', '', '', 'objetomodulos/edit', 1, '0', 'objetomodulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(49, 5, 47, 'Edit SubModule', 'A', '0', 'Administration', '', '', '', 1, '1', 'objetomodulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(50, 5, 48, 'Update SubModule', 'A', '0', 'Administration', '', '', 'objetomodulos/update', 1, '1', 'objetomodulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(51, 5, 2, 'Delete Group', 'S', '0', 'Administration', '', '', 'grupo/delete', 1, '0', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(52, 5, 10, 'Delete Role', 'S', '0', 'Administration', '', '', 'rol/delete', 1, '0', 'rol', '1', '2018-09-16 08:48:06', NULL, '1'),
(53, 5, 26, 'Delete Action', 'S', '0', 'Administration', '', '', 'acciones/delete', 1, '0', 'accion', '1', '2018-09-16 08:48:06', NULL, '1'),
(54, 5, 18, 'Delete Permission', 'S', '0', 'Administration', '', '', 'permisos/delete', 1, '0', 'grupo', '1', '2018-09-16 08:48:06', NULL, '1'),
(55, 5, 35, 'Delete Module', 'S', '0', 'Administration', '', '', 'modulos/delete', 1, '0', 'modulo', '1', '2018-09-16 08:48:06', NULL, '1'),
(56, 5, 43, 'Delete SubModule', 'S', '0', 'Administration', '', '', 'objetomodulos/delete', 1, '0', 'objetomodulo', '1', '2018-09-16 08:48:06', NULL, '1'),

(57, 1, 57, 'Dashboard', 'P', '0', 'Dashboard', '', '', 'site/index', 1, '0', 'dashboard', '1', '2014-01-08 13:43:51', NULL, '1'),

-- (58, 4, 58, 'Email', 'P', '0', 'Email', '', '', 'email/index', 1, '0', 'menu', '1', '2014-01-08 13:43:51', NULL, '1'),

(59, 5, 59, 'Users', 'P', '0', 'Administration', '', '', 'usuario/index', 1, '1', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(60, 5, 59, 'View User', 'S', '0', 'Administration', '', '', 'usuario/view', 1, '0', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(61, 5, 59, 'Create User', 'S', '0', 'Administration', '', '', 'usuario/new', 1, '0', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(62, 5, 59, 'Edit User', 'S', '0', 'Administration', '', '', 'usuario/edit', 1, '0', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(63, 5, 59, 'Delete User', 'S', '0', 'Administration', '', '', 'usuario/delete', 1, '0', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(64, 5, 59, 'Create User', 'A', '0', 'Administration', '', '', '', 1, '1', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(65, 5, 60, 'Edit User', 'A', '0', 'Administration', '', '', '', 1, '1', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(66, 5, 61, 'Save User', 'A', '0', 'Administration', '', '', 'usuario/save', 1, '1', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(67, 5, 62, 'Update User', 'A', '0', 'Administration', '', '', 'usuario/update', 1, '1', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(68, 5, 61, 'Add Company to User', 'S', '0', 'Administration', '', '', 'usuario/addempresa', 1, '0', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),
(69, 5, 68, 'Save Company to User', 'A', '0', 'Administration', '', '', '', 1, '1', 'usuario', '1', '2014-01-08 13:43:51', NULL, '1'),

(70, 2, 70, 'Profile', 'P', '0', 'My Account', '', '', 'perfil/index', 1, '1', 'perfil', '1', '2014-01-08 13:43:51', NULL, '1'),
(71, 2, 70, 'Edit Profile', 'S', '0', 'My Account', '', '', 'perfil/edit', 1, '0', 'perfil', '1', '2014-01-08 13:43:51', NULL, '1'),
(72, 2, 70, 'Edit Profile', 'A', '0', 'My Account', '', '', '', 1, '1', 'perfil', '1', '2014-01-08 13:43:51', NULL, '1'),
(73, 2, 71, 'Update Profile', 'A', '0', 'My Account', '', '', 'perfil/save', 1, '1', 'perfil', '1', '2014-01-08 13:43:51', NULL, '1'),

-- (74, 3, 74, 'Calendar', 'P', '0', 'Schedule', '', '', 'calendar/index', 1, '1', 'calendario', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (75, 3, 74, 'View Event', 'S', '0', 'Schedule', '', '', 'calendar/view', 1, '0', 'calendario', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (76, 3, 74, 'Create Event', 'S', '0', 'Schedule', '', '', 'calendar/new', 1, '0', 'calendario', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (77, 3, 74, 'Edit Event', 'S', '0', 'Schedule', '', '', 'calendar/edit', 1, '0', 'calendario', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (78, 3, 74, 'Delete Event', 'S', '0', 'Schedule', '', '', 'calendar/delete', 1, '0', 'calendario', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (79, 3, 74, 'Create Event', 'A', '0', 'Schedule', '', '', '', 1, '1', 'calendario', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (80, 3, 75, 'Edit Event', 'A', '0', 'Schedule', '', '', '', 1, '1', 'calendario', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (81, 3, 76, 'Save Event', 'A', '0', 'Schedule', '', '', 'calendar/save', 1, '1', 'calendario', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (82, 3, 77, 'Update Event', 'A', '0', 'Schedule', '', '', 'calendar/update', 1, '1', 'calendario', '1', '2014-01-08 13:43:51', NULL, '1'),

(83, 5, 83, 'Company', 'P', '0', 'Administration', '', '', 'empresa/index', 1, '1', 'empresa', '1', '2014-01-08 13:43:51', NULL, '1'),
(84, 5, 83, 'View Company', 'S', '0', 'Administration', '', '', 'empresa/view', 1, '0', 'empresa', '1', '2014-01-08 13:43:51', NULL, '1'),
(85, 5, 83, 'Create Company', 'S', '0', 'Administration', '', '', 'empresa/new', 1, '0', 'empresa', '1', '2014-01-08 13:43:51', NULL, '1'),
(86, 5, 83, 'Edit Company', 'S', '0', 'Administration', '', '', 'empresa/edit', 1, '0', 'empresa', '1', '2014-01-08 13:43:51', NULL, '1'),
(87, 5, 83, 'Delete Company', 'S', '0', 'Administration', '', '', 'empresa/delete', 1, '0', 'empresa', '1', '2014-01-08 13:43:51', NULL, '1'),
(88, 5, 83, 'Create Company', 'A', '0', 'Administration', '', '', '', 1, '1', 'empresa', '1', '2014-01-08 13:43:51', NULL, '1'),
(89, 5, 84, 'Edit Company', 'A', '0', 'Administration', '', '', '', 1, '1', 'empresa', '1', '2014-01-08 13:43:51', NULL, '1'),
(90, 5, 85, 'Save Company', 'A', '0', 'Administration', '', '', 'empresa/save', 1, '1', 'empresa', '1', '2014-01-08 13:43:51', NULL, '1'),
(91, 5, 86, 'Update Company', 'A', '0', 'Administration', '', '', 'empresa/update', 1, '1', 'empresa', '1', '2014-01-08 13:43:51', NULL, '1');

-- (92, 3, 92, 'Meeting', 'P', '0', 'Schedule', '', '', 'meeting/index', 1, '1', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (93, 3, 92, 'View Meeting', 'S', '0', 'Schedule', '', '', 'meeting/view', 1, '0', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (94, 3, 92, 'Create Meeting', 'S', '0', 'Schedule', '', '', 'meeting/new', 1, '0', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (95, 3, 92, 'Edit Meeting', 'S', '0', 'Schedule', '', '', 'meeting/edit', 1, '0', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (96, 3, 92, 'Delete Meeting', 'S', '0', 'Schedule', '', '', 'meeting/delete', 1, '0', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (97, 3, 92, 'Create Meeting', 'A', '0', 'Schedule', '', '', '', 1, '1', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (98, 3, 93, 'Edit Meeting', 'A', '0', 'Schedule', '', '', '', 1, '1', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (99, 3, 94, 'Save Meeting', 'A', '0', 'Schedule', '', '', 'meeting/save', 1, '1', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (100, 3, 95, 'Update Meeting', 'A', '0', 'Schedule', '', '', 'meeting/update', 1, '1', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (101, 3, 92, 'Enter Meeting', 'S', '0', 'Schedule', '', '', 'meeting/conference', 1, '0', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1'),
-- (102, 3, 101, 'Logout Meeting', 'A', '0', 'Schedule', '', '', 'meeting/conference', 1, '1', 'meeting', '1', '2014-01-08 13:43:51', NULL, '1');

ALTER TABLE `objeto_modulo` AUTO_INCREMENT = 103;

--
-- Volcar la base de datos para la tabla `obmo_acci`
--

INSERT INTO `obmo_acci` (`oacc_id`, `omod_id`, `acc_id`, `oacc_tipo_boton`, `oacc_cont_accion`, `oacc_function`, `oacc_estado_activo`, `oacc_fecha_creacion`, `oacc_fecha_modificacion`, `oacc_estado_logico`) VALUES
(1, 4, 1, '0', 'grupo/new', '', '1', '2018-10-08 22:59:43', NULL, '1'),
(2, 5, 4, '1', '', 'save', '1', '2018-10-08 22:59:43', NULL, '1'),
(3, 7, 12, '1', '', 'edit', '1', '2018-10-08 22:59:43', NULL, '1'),
(4, 9, 4, '1', '', 'update', '1', '2018-10-08 22:59:43', NULL, '1'),
(5, 12, 1, '0', 'rol/new', '', '1', '2018-10-08 22:59:43', NULL, '1'),
(6, 13, 4, '1', '', 'save', '1', '2018-10-08 22:59:43', NULL, '1'),
(7, 16, 12, '1', '', 'edit', '1', '2018-10-08 22:59:43', NULL, '1'),
(8, 17, 4, '1', '', 'update', '1', '2018-10-08 22:59:43', NULL, '1'),
(9, 20, 1, '0', 'permisos/new', '', '1', '2018-10-08 22:59:43', NULL, '1'),
(10, 21, 4, '1', '', 'save', '1', '2018-10-08 22:59:43', NULL, '1'),
(11, 24, 12, '1', '', 'edit', '1', '2018-10-08 22:59:43', NULL, '1'),
(12, 25, 4, '1', '', 'update', '1', '2018-10-08 22:59:43', NULL, '1'),
(13, 28, 1, '0', 'acciones/new', '', '1', '2018-10-08 22:59:43', NULL, '1'),
(14, 29, 4, '1', '', 'save', '1', '2018-10-08 22:59:43', NULL, '1'),
(15, 32, 12, '1', '', 'edit', '1', '2018-10-08 22:59:43', NULL, '1'),
(16, 33, 4, '1', '', 'update', '1', '2018-10-08 22:59:43', NULL, '1'),
(17, 37, 1, '0', 'modulos/new', '', '1', '2018-10-08 22:59:43', NULL, '1'),
(18, 38, 4, '1', '', 'save', '1', '2018-10-08 22:59:43', NULL, '1'),
(19, 41, 12, '1', '', 'edit', '1', '2018-10-08 22:59:43', NULL, '1'),
(20, 42, 4, '1', '', 'update', '1', '2018-10-08 22:59:43', NULL, '1'),
(21, 45, 1, '0', 'objetomodulos/new', '', '1', '2018-10-08 22:59:43', NULL, '1'),
(22, 46, 4, '1', '', 'save', '1', '2018-10-08 22:59:43', NULL, '1'),
(23, 49, 12, '1', '', 'edit', '1', '2018-10-08 22:59:43', NULL, '1'),
(24, 50, 4, '1', '', 'update', '1', '2018-10-08 22:59:43', NULL, '1'),
(25, 64, 1, '0', 'usuario/new', '', '1', '2018-10-08 22:59:43', NULL, '1'),
(26, 66, 4, '1', '', 'save', '1', '2018-10-08 22:59:43', NULL, '1'),
(27, 65, 12, '1', '', 'edit', '1', '2018-10-08 22:59:43', NULL, '1'),
(28, 67, 4, '1', '', 'update', '1', '2018-10-08 22:59:43', NULL, '1'),
(29, 69, 4, '1', '', 'addCompany', '1', '2018-10-08 22:59:43', NULL, '1'),
(30, 72, 12, '0', 'perfil/edit', '', '1', '2014-06-12 07:43:33', NULL, '1'),
(31, 73, 4, '1', '', 'save', '1', '2014-06-12 12:43:33', NULL, '1'),
(32, 88, 1, '0', 'empresa/new', '', '1', '2018-10-08 22:59:43', NULL, '1'),
(33, 90, 4, '1', '', 'save', '1', '2018-10-08 22:59:43', NULL, '1'),
(34, 89, 12, '1', '', 'edit', '1', '2018-10-08 22:59:43', NULL, '1'),
(35, 91, 4, '1', '', 'update', '1', '2018-10-08 22:59:43', NULL, '1');

-- (36, 97, 1, '0', 'meeting/new', '', '1', '2018-10-08 22:59:43', NULL, '1'),
-- (37, 99, 4, '1', '', 'save', '1', '2018-10-08 22:59:43', NULL, '1'),
-- (38, 98, 12, '1', '', 'edit', '1', '2018-10-08 22:59:43', NULL, '1'),
-- (39, 100, 4, '1', '', 'update', '1', '2018-10-08 22:59:43', NULL, '1'),
-- (40, 102, 13, '1', '', 'logoutConference', '1', '2018-10-08 22:59:43', NULL, '1');

ALTER TABLE `obmo_acci` AUTO_INCREMENT = 41;

--
-- Volcar la base de datos para la tabla `grup_obmo`
--

INSERT INTO `grup_obmo` (`gmod_id`, `gru_id`, `omod_id`, `gmod_estado_activo`, `gmod_fecha_creacion`, `gmod_fecha_modificacion`, `gmod_estado_logico`) VALUES
(1, 1, 1, '1', '2014-03-17 21:34:50', NULL, '1'),
(2, 1, 2, '1', '2014-03-17 21:34:50', NULL, '1'),
(3, 1, 3, '1', '2014-03-17 21:34:50', NULL, '1'),
(4, 1, 4, '1', '2014-03-17 21:34:50', NULL, '1'),
(5, 1, 5, '1', '2014-03-17 21:34:50', NULL, '1'),
(6, 1, 6, '1', '2014-03-17 21:34:50', NULL, '1'),
(7, 1, 7, '1', '2014-03-17 21:34:50', NULL, '1'),
(8, 1, 8, '1', '2014-03-17 21:34:50', NULL, '1'),
(9, 1, 9, '1', '2014-03-17 21:34:50', NULL, '1'),
(10, 1, 10, '1', '2014-03-17 21:34:50', NULL, '1'),
(11, 1, 11, '1', '2014-03-17 21:34:50', NULL, '1'),
(12, 1, 12, '1', '2014-03-17 21:34:50', NULL, '1'),
(13, 1, 13, '1', '2014-03-17 21:34:50', NULL, '1'),
(14, 1, 14, '1', '2014-03-17 21:34:50', NULL, '1'),
(15, 1, 15, '1', '2014-03-17 21:34:50', NULL, '1'),
(16, 1, 16, '1', '2014-03-17 21:34:50', NULL, '1'),
(17, 1, 17, '1', '2014-03-17 21:34:50', NULL, '1'),
(18, 1, 18, '1', '2014-03-17 21:34:50', NULL, '1'),
(19, 1, 19, '1', '2014-03-17 21:34:50', NULL, '1'),
(20, 1, 20, '1', '2014-03-17 21:34:50', NULL, '1'),
(21, 1, 21, '1', '2014-03-17 21:34:50', NULL, '1'),
(22, 1, 22, '1', '2014-03-17 21:34:50', NULL, '1'),
(23, 1, 23, '1', '2014-03-17 21:34:50', NULL, '1'),
(24, 1, 24, '1', '2014-03-17 21:34:50', NULL, '1'),
(25, 1, 25, '1', '2014-03-17 21:34:50', NULL, '1'),
(26, 1, 26, '1', '2014-03-17 21:34:50', NULL, '1'),
(27, 1, 27, '1', '2014-03-17 21:34:50', NULL, '1'),
(28, 1, 28, '1', '2014-03-17 21:34:50', NULL, '1'),
(29, 1, 29, '1', '2014-03-17 21:34:50', NULL, '1'),
(30, 1, 30, '1', '2014-03-17 21:34:50', NULL, '1'),
(31, 1, 31, '1', '2014-03-17 21:34:50', NULL, '1'),
(32, 1, 32, '1', '2014-03-17 21:34:50', NULL, '1'),
(33, 1, 33, '1', '2014-03-17 21:34:50', NULL, '1'),
(34, 1, 34, '1', '2014-03-17 21:34:50', NULL, '1'),
(35, 1, 35, '1', '2014-03-17 21:34:50', NULL, '1'),
(36, 1, 36, '1', '2014-03-17 21:34:50', NULL, '1'),
(37, 1, 37, '1', '2014-03-17 21:34:50', NULL, '1'),
(38, 1, 38, '1', '2014-03-17 21:34:50', NULL, '1'),
(39, 1, 39, '1', '2014-03-17 21:34:50', NULL, '1'),
(40, 1, 40, '1', '2014-03-17 21:34:50', NULL, '1'),
(41, 1, 41, '1', '2014-03-17 21:34:50', NULL, '1'),
(42, 1, 42, '1', '2014-03-17 21:34:50', NULL, '1'),
(43, 1, 43, '1', '2014-03-17 21:34:50', NULL, '1'),
(44, 1, 44, '1', '2014-03-17 21:34:50', NULL, '1'),
(45, 1, 45, '1', '2014-03-17 21:34:50', NULL, '1'),
(46, 1, 46, '1', '2014-03-17 21:34:50', NULL, '1'),
(47, 1, 47, '1', '2014-03-17 21:34:50', NULL, '1'),
(48, 1, 48, '1', '2014-03-17 21:34:50', NULL, '1'),
(49, 1, 49, '1', '2014-03-17 21:34:50', NULL, '1'),
(50, 1, 50, '1', '2014-03-17 21:34:50', NULL, '1'),
(51, 1, 51, '1', '2014-03-17 21:34:50', NULL, '1'),
(52, 1, 52, '1', '2014-03-17 21:34:50', NULL, '1'),
(53, 1, 53, '1', '2014-03-17 21:34:50', NULL, '1'),
(54, 1, 54, '1', '2014-03-17 21:34:50', NULL, '1'),
(55, 1, 55, '1', '2014-03-17 21:34:50', NULL, '1'),
(56, 1, 56, '1', '2014-03-17 21:34:50', NULL, '1'),
(57, 1, 57, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (58, 1, 58, '1', '2014-03-17 21:34:50', NULL, '1'),
(59, 1, 59, '1', '2014-03-17 21:34:50', NULL, '1'),
(60, 1, 60, '1', '2014-03-17 21:34:50', NULL, '1'),
(61, 1, 61, '1', '2014-03-17 21:34:50', NULL, '1'),
(62, 1, 62, '1', '2014-03-17 21:34:50', NULL, '1'),
(63, 1, 63, '1', '2014-03-17 21:34:50', NULL, '1'),
(64, 1, 64, '1', '2014-03-17 21:34:50', NULL, '1'),
(65, 1, 65, '1', '2014-03-17 21:34:50', NULL, '1'),
(66, 1, 66, '1', '2014-03-17 21:34:50', NULL, '1'),
(67, 1, 67, '1', '2014-03-17 21:34:50', NULL, '1'),
(68, 1, 68, '1', '2014-03-17 21:34:50', NULL, '1'),
(69, 1, 69, '1', '2014-03-17 21:34:50', NULL, '1'),
(70, 1, 70, '1', '2014-03-17 21:34:50', NULL, '1'),
(71, 1, 71, '1', '2014-03-17 21:34:50', NULL, '1'),
(72, 1, 72, '1', '2014-03-17 21:34:50', NULL, '1'),
(73, 1, 73, '1', '2014-03-17 21:34:50', NULL, '1'),

-- (74, 1, 74, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (75, 1, 75, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (76, 1, 76, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (77, 1, 77, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (78, 1, 78, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (79, 1, 79, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (80, 1, 80, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (81, 1, 81, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (82, 1, 82, '1', '2014-03-17 21:34:50', NULL, '1'),

(83, 1, 83, '1', '2014-03-17 21:34:50', NULL, '1'),
(84, 1, 84, '1', '2014-03-17 21:34:50', NULL, '1'),
(85, 1, 85, '1', '2014-03-17 21:34:50', NULL, '1'),
(86, 1, 86, '1', '2014-03-17 21:34:50', NULL, '1'),
(87, 1, 87, '1', '2014-03-17 21:34:50', NULL, '1'),
(88, 1, 88, '1', '2014-03-17 21:34:50', NULL, '1'),
(89, 1, 89, '1', '2014-03-17 21:34:50', NULL, '1'),
(90, 1, 90, '1', '2014-03-17 21:34:50', NULL, '1'),
(91, 1, 91, '1', '2014-03-17 21:34:50', NULL, '1');

-- (92, 1, 92, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (93, 1, 93, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (94, 1, 94, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (95, 1, 95, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (96, 1, 96, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (97, 1, 97, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (98, 1, 98, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (99, 1, 99, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (100, 1, 100, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (101, 1, 101, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (102, 1, 102, '1', '2014-03-17 21:34:50', NULL, '1');

ALTER TABLE `grup_obmo` AUTO_INCREMENT = 103;

--
-- Volcar la base de datos para la tabla `grup_obmo_grup_rol`
--

INSERT INTO `grup_obmo_grup_rol` (`gogr_id`, `grol_id`, `gmod_id`, `gogr_estado_activo`, `gogr_fecha_creacion`, `gogr_fecha_modificacion`, `gogr_estado_logico`) VALUES
(1, 1, 1, '1', '2014-01-04 20:48:54', NULL, '1'),
(2, 1, 2, '1', '2014-01-04 20:48:54', NULL, '1'),
(3, 1, 3, '1', '2014-01-04 20:48:54', NULL, '1'),
(4, 1, 4, '1', '2014-01-04 20:48:54', NULL, '1'),
(5, 1, 5, '1', '2014-01-04 20:48:54', NULL, '1'),
(6, 1, 6, '1', '2014-01-04 20:48:54', NULL, '1'),
(7, 1, 7, '1', '2014-01-04 20:48:54', NULL, '1'),
(8, 1, 8, '1', '2014-01-04 20:48:54', NULL, '1'),
(9, 1, 9, '1', '2014-01-04 20:48:54', NULL, '1'),
(10, 1, 10, '1', '2014-01-04 20:48:54', NULL, '1'),
(11, 1, 11, '1', '2014-01-04 20:48:54', NULL, '1'),
(12, 1, 12, '1', '2014-01-04 20:48:54', NULL, '1'),
(13, 1, 13, '1', '2014-01-04 20:48:54', NULL, '1'),
(14, 1, 14, '1', '2014-01-04 20:48:54', NULL, '1'),
(15, 1, 15, '1', '2014-01-04 20:48:54', NULL, '1'),
(16, 1, 16, '1', '2014-01-04 20:48:54', NULL, '1'),
(17, 1, 17, '1', '2014-01-04 20:48:54', NULL, '1'),
(18, 1, 18, '1', '2014-01-04 20:48:54', NULL, '1'),
(19, 1, 19, '1', '2014-01-04 20:48:54', NULL, '1'),
(20, 1, 20, '1', '2014-01-04 20:48:54', NULL, '1'),
(21, 1, 21, '1', '2014-01-04 20:48:54', NULL, '1'),
(22, 1, 22, '1', '2014-01-04 20:48:54', NULL, '1'),
(23, 1, 23, '1', '2014-01-04 20:48:54', NULL, '1'),
(24, 1, 24, '1', '2014-01-04 20:48:54', NULL, '1'),
(25, 1, 25, '1', '2014-01-04 20:48:54', NULL, '1'),
(26, 1, 26, '1', '2014-01-04 20:48:54', NULL, '1'),
(27, 1, 27, '1', '2014-01-04 20:48:54', NULL, '1'),
(28, 1, 28, '1', '2014-01-04 20:48:54', NULL, '1'),
(29, 1, 29, '1', '2014-01-04 20:48:54', NULL, '1'),
(30, 1, 30, '1', '2014-01-04 20:48:54', NULL, '1'),
(31, 1, 31, '1', '2014-01-04 20:48:54', NULL, '1'),
(32, 1, 32, '1', '2014-01-04 20:48:54', NULL, '1'),
(33, 1, 33, '1', '2014-01-04 20:48:54', NULL, '1'),
(34, 1, 34, '1', '2014-01-04 20:48:54', NULL, '1'),
(35, 1, 35, '1', '2014-01-04 20:48:54', NULL, '1'),
(36, 1, 36, '1', '2014-01-04 20:48:54', NULL, '1'),
(37, 1, 37, '1', '2014-01-04 20:48:54', NULL, '1'),
(38, 1, 38, '1', '2014-01-04 20:48:54', NULL, '1'),
(39, 1, 39, '1', '2014-01-04 20:48:54', NULL, '1'),
(40, 1, 40, '1', '2014-01-04 20:48:54', NULL, '1'),
(41, 1, 41, '1', '2014-01-04 20:48:54', NULL, '1'),
(42, 1, 42, '1', '2014-01-04 20:48:54', NULL, '1'),
(43, 1, 43, '1', '2014-01-04 20:48:54', NULL, '1'),
(44, 1, 44, '1', '2014-01-04 20:48:54', NULL, '1'),
(45, 1, 45, '1', '2014-01-04 20:48:54', NULL, '1'),
(46, 1, 46, '1', '2014-01-04 20:48:54', NULL, '1'),
(47, 1, 47, '1', '2014-01-04 20:48:54', NULL, '1'),
(48, 1, 48, '1', '2014-01-04 20:48:54', NULL, '1'),
(49, 1, 49, '1', '2014-01-04 20:48:54', NULL, '1'),
(50, 1, 50, '1', '2014-01-04 20:48:54', NULL, '1'),
(51, 1, 51, '1', '2014-01-04 20:48:54', NULL, '1'),
(52, 1, 52, '1', '2014-01-04 20:48:54', NULL, '1'),
(53, 1, 53, '1', '2014-01-04 20:48:54', NULL, '1'),
(54, 1, 54, '1', '2014-01-04 20:48:54', NULL, '1'),
(55, 1, 55, '1', '2014-01-04 20:48:54', NULL, '1'),
(56, 1, 56, '1', '2014-01-04 20:48:54', NULL, '1'),
(57, 1, 57, '1', '2014-01-04 20:48:54', NULL, '1'),
-- (58, 1, 58, '1', '2014-01-04 20:48:54', NULL, '1'),
(59, 1, 59, '1', '2014-01-04 20:48:54', NULL, '1'),
(60, 1, 60, '1', '2014-01-04 20:48:54', NULL, '1'),
(61, 1, 61, '1', '2014-01-04 20:48:54', NULL, '1'),
(62, 1, 62, '1', '2014-01-04 20:48:54', NULL, '1'),
(63, 1, 63, '1', '2014-01-04 20:48:54', NULL, '1'),
(64, 1, 64, '1', '2014-01-04 20:48:54', NULL, '1'),
(65, 1, 65, '1', '2014-01-04 20:48:54', NULL, '1'),
(66, 1, 66, '1', '2014-01-04 20:48:54', NULL, '1'),
(67, 1, 67, '1', '2014-01-04 20:48:54', NULL, '1'),
(68, 1, 68, '1', '2014-01-04 20:48:54', NULL, '1'),
(69, 1, 69, '1', '2014-01-04 20:48:54', NULL, '1'),
(70, 1, 70, '1', '2014-01-04 20:48:54', NULL, '1'),
(71, 1, 71, '1', '2014-01-04 20:48:54', NULL, '1'),
(72, 1, 72, '1', '2014-01-04 20:48:54', NULL, '1'),
(73, 1, 73, '1', '2014-01-04 20:48:54', NULL, '1'),

-- (74, 1, 74, '1', '2014-01-04 20:48:54', NULL, '1'),
-- (75, 1, 75, '1', '2014-01-04 20:48:54', NULL, '1'),
-- (76, 1, 76, '1', '2014-01-04 20:48:54', NULL, '1'),
-- (77, 1, 77, '1', '2014-01-04 20:48:54', NULL, '1'),
-- (78, 1, 78, '1', '2014-01-04 20:48:54', NULL, '1'),
-- (79, 1, 79, '1', '2014-01-04 20:48:54', NULL, '1'),
-- (80, 1, 80, '1', '2014-01-04 20:48:54', NULL, '1'),
-- (81, 1, 81, '1', '2014-01-04 20:48:54', NULL, '1'),
-- (82, 1, 82, '1', '2014-01-04 20:48:54', NULL, '1'),

(83, 1, 83, '1', '2014-01-04 20:48:54', NULL, '1'),
(84, 1, 84, '1', '2014-01-04 20:48:54', NULL, '1'),
(85, 1, 85, '1', '2014-01-04 20:48:54', NULL, '1'),
(86, 1, 86, '1', '2014-01-04 20:48:54', NULL, '1'),
(87, 1, 87, '1', '2014-01-04 20:48:54', NULL, '1'),
(88, 1, 88, '1', '2014-01-04 20:48:54', NULL, '1'),
(89, 1, 89, '1', '2014-01-04 20:48:54', NULL, '1'),
(90, 1, 90, '1', '2014-01-04 20:48:54', NULL, '1'),
(91, 1, 91, '1', '2014-01-04 20:48:54', NULL, '1');

-- (92, 1, 92, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (93, 1, 93, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (94, 1, 94, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (95, 1, 95, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (96, 1, 96, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (97, 1, 97, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (98, 1, 98, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (99, 1, 99, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (100, 1, 100, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (101, 1, 101, '1', '2014-03-17 21:34:50', NULL, '1'),
-- (102, 1, 102, '1', '2014-03-17 21:34:50', NULL, '1');

ALTER TABLE `grup_obmo_grup_rol` AUTO_INCREMENT = 103;

--
-- Volcar la base de datos para la tabla `grup_obmo_grup_rol_obmo_acci`
--

INSERT INTO `grup_obmo_grup_rol_obmo_acci` (`ggoa_id`, `gogr_id`, `oacc_id`, `ggoa_estado_activo`, `ggoa_fecha_creacion`, `ggoa_fecha_modificacion`, `ggoa_estado_logico`) VALUES
(1, 1, 1, '1', '2014-01-05 01:48:54', NULL, '1');

--
-- Volcar la base de datos para la tabla `usua_grol_eper`
--

INSERT INTO `usua_grol_eper` (`ugep_id`, `eper_id`, `usu_id`, `grol_id`, `ugep_estado_activo`, `ugep_fecha_creacion`, `ugep_fecha_modificacion`, `ugep_estado_logico`) VALUES
(1, 1, 1, 1, '1', '2014-12-11 15:17:35', NULL, '1');

--
-- Volcar la base de datos para la tabla `dashboard`
--

INSERT INTO `dashboard` (`das_id`, `das_nombre`, `das_icon`, `das_lang_file`, `das_model_file`, `das_function_file`, `das_configuration`, `das_tipo`, `das_estado_activo`, `das_fecha_creacion`, `das_fecha_modificacion`, `das_estado_logico`) VALUES
-- (1, 'Calendar', 'fa fa-calendar-o', 'calendario', 'app\\models\\Calendario', NULL, '{\"Period\":[\"Today\",\"Tomorrow\",\"Week\",\"Month\"]}', '1', '0', '2020-06-02 21:04:18', NULL, '1');
-- (2, 'Meeting', 'fa fa-users', 'meeting', 'app\\models\\Conference', NULL, '{\"Period\": [\"Today\", \"Tomorrow\", \"Week\", \"Month\"], \"Meeting_Status\": [\"All\", \"Meeting Ended\", \"Meeting no Started\", \"Meeting in Process\"]}', '1', '1', '2020-06-04 22:54:50', NULL, '1'),
(3, 'Users', 'fa fa-line-chart', 'usuario', 'app\\models\\Usuario', NULL, '{\"Period\": [\"Day\", \"Week\", \"Month\", \"Year\"], \"Last\": [\"1\", \"2\", \"3\", \"4\", \"5\"]}', '4', '1', '2020-06-04 22:54:50', NULL, '1');

--
-- Volcar la base de datos para la tabla `dashboard_permision`
--
INSERT INTO `dashboard_permision` (`pper_id`, `das_id`, `usu_id`, `emp_id`, `grol_id`, `pper_admin`, `pper_descripcion`, `pper_estado_activo`, `pper_fecha_creacion`, `pper_fecha_modificacion`, `pper_estado_logico`) VALUES
-- (1, 1, 1, 1, 1, '1', NULL, '1', '2020-06-02 22:35:56', NULL, '1');
-- (2, 2, 1, 1, 1, '1', NULL, '1', '2020-06-02 22:35:56', NULL, '1'),
(3, 3, 1, 1, 1, '1', NULL, '1', '2020-06-02 22:35:56', NULL, '1');



COMMIT;
