# ************************************************************
# Sequel Ace SQL dump
# Versión 20062
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# Equipo: localhost (MySQL 8.0.33)
# Base de datos: originacion_back_demo
# Tiempo de generación: 2024-01-16 05:27:53 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Volcado de tabla actions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `actions`;

CREATE TABLE `actions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `module_id` int NOT NULL,
  `shortname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `actions` WRITE;
/*!40000 ALTER TABLE `actions` DISABLE KEYS */;

INSERT INTO `actions` (`id`, `created_at`, `updated_at`, `module_id`, `shortname`, `description`, `deleted_at`)
VALUES
	(1,NULL,NULL,1,'list','Ver listado de empresas',NULL),
	(2,NULL,NULL,1,'edit','Editar empresas',NULL),
	(3,NULL,NULL,1,'activate','Activar empresa',NULL),
	(4,NULL,NULL,1,'desactivate','Desactivar empresa',NULL),
	(6,NULL,NULL,1,'delete','Eliminar empresa',NULL),
	(7,NULL,NULL,2,'list','Ver listado de roles y permisos',NULL),
	(8,NULL,NULL,2,'edit','Editar roles',NULL),
	(9,NULL,NULL,2,'add','Agregar rol',NULL),
	(10,NULL,NULL,2,'activate','Activar rol',NULL),
	(11,NULL,NULL,2,'desactivate','Desactivar rol',NULL),
	(12,NULL,NULL,2,'delete','Eliminar rol',NULL),
	(13,NULL,NULL,1,'add','Agregar empresa',NULL),
	(14,NULL,NULL,2,'view','Ver detalle del rol',NULL),
	(15,NULL,NULL,3,'birthday','Tablero Cumpleaños del día','2024-01-11 00:00:00'),
	(16,NULL,NULL,3,'employees-range','Tablero Total de empleados (Por rango)','2024-01-11 00:00:00'),
	(17,NULL,NULL,3,'employees-area','Tablero Total de empleados (Por área)','2024-01-11 00:00:00'),
	(18,NULL,NULL,3,'employees-job','Tablero Total de empleados (Por puesto)','2024-01-11 00:00:00'),
	(19,NULL,NULL,2,'add-employee-role','Asociar usuarios a rol',NULL),
	(20,NULL,NULL,1,'add-employee-company','Asociar usuarios a empresas',NULL),
	(21,NULL,NULL,4,'list','Ver listado',NULL),
	(23,NULL,NULL,4,'edit','Editar',NULL),
	(27,NULL,NULL,5,'list','Ver listado',NULL),
	(28,NULL,NULL,4,'add','Agregar nuevo',NULL),
	(29,NULL,NULL,4,'delete','Eliminar',NULL),
	(30,NULL,NULL,5,'edit','Editar',NULL),
	(31,NULL,NULL,5,'add','Agregar',NULL),
	(32,NULL,NULL,5,'delete','Eliminar',NULL),
	(34,NULL,NULL,6,'list','Ver listado',NULL),
	(35,NULL,NULL,6,'edit','Editar',NULL),
	(36,NULL,NULL,5,'list','Ver listado',NULL),
	(37,NULL,NULL,6,'add','Agregar',NULL),
	(38,NULL,NULL,6,'delete','Eliminar',NULL),
	(39,NULL,NULL,7,'list','Ver listado',NULL),
	(40,NULL,NULL,7,'edit','Editar',NULL),
	(41,NULL,NULL,7,'add','Agregar',NULL),
	(42,NULL,NULL,7,'delete','Eliminar',NULL),
	(43,NULL,NULL,8,'list','Ver listado',NULL),
	(45,NULL,NULL,8,'edit','Editar',NULL),
	(46,NULL,NULL,8,'add','Agregar',NULL),
	(47,NULL,NULL,8,'delete','Eliminar',NULL),
	(48,NULL,NULL,9,'list','Ver listado',NULL),
	(49,NULL,NULL,9,'edit','Editar',NULL),
	(50,NULL,NULL,9,'add','Agregar',NULL),
	(51,NULL,NULL,9,'delete','Eliminar',NULL),
	(52,NULL,NULL,10,'list','Ver listado',NULL),
	(53,NULL,NULL,10,'edit','Editar',NULL),
	(54,NULL,NULL,10,'add','Agregar',NULL),
	(55,NULL,NULL,10,'delete','Eliminar',NULL),
	(56,NULL,NULL,12,'list','Ver listado de empleados activos',NULL),
	(57,NULL,NULL,12,'edit','Editar',NULL),
	(58,NULL,NULL,12,'add','Agregar',NULL),
	(59,NULL,NULL,12,'delete','Eliminar',NULL),
	(60,NULL,NULL,12,'activate','Reactivar empleado',NULL),
	(61,NULL,NULL,12,'desactivate','Baja empleado',NULL),
	(62,NULL,NULL,12,'list-inactive','Ver listado de empleados inactivos',NULL),
	(63,NULL,NULL,12,'view','Ver detalle de empleado',NULL),
	(64,NULL,NULL,12,'profile','Ver perfil público de empleados',NULL),
	(65,NULL,NULL,13,'list','Ver listado',NULL),
	(66,NULL,NULL,13,'make-report','Generar reporte',NULL),
	(67,NULL,NULL,13,'add','Registrar movimiento',NULL),
	(68,NULL,NULL,13,'reports','Listado de reportes guardados',NULL),
	(69,NULL,NULL,14,'list','Ver listado',NULL),
	(70,NULL,NULL,14,'edit','Editar',NULL),
	(71,NULL,NULL,14,'add','Agregar',NULL),
	(72,NULL,NULL,14,'delete','Eliminar',NULL),
	(73,NULL,NULL,15,'list','Ver listado',NULL),
	(74,NULL,NULL,15,'authorize','Autorizar vacaciones',NULL),
	(75,NULL,NULL,15,'deny','Rechazar vacaciones',NULL),
	(76,NULL,NULL,15,'request','Solicitar vacaciones',NULL),
	(77,NULL,NULL,16,'list','Ver listado de proveedores activos',NULL),
	(78,NULL,NULL,16,'list-inactive','Ver listado de proveedores inactivos',NULL),
	(79,NULL,NULL,16,'add','Agregar proveedor',NULL),
	(80,NULL,NULL,16,'edit','Editar',NULL),
	(81,NULL,NULL,16,'delete','Eliminar',NULL),
	(82,NULL,NULL,16,'activate','Activar',NULL),
	(83,NULL,NULL,16,'desactivate','Desactivar',NULL),
	(84,NULL,NULL,16,'view','Ver detalle de proveedor',NULL),
	(85,NULL,NULL,16,'evaluate','Aplicar evaluación',NULL),
	(86,NULL,NULL,17,'dashboard','Dashboard de gastos',NULL),
	(87,NULL,NULL,17,'board-dashboard-by-year','Tablero Gastos de proveedores por año',NULL),
	(88,NULL,NULL,17,'board-refund','Tablero Reembolsos por año',NULL),
	(89,NULL,NULL,17,'board-expenses','Tablero Egresos por tipo de salida',NULL),
	(90,NULL,NULL,17,'add','Agregar gasto',NULL),
	(91,NULL,NULL,13,'list','Ver listado',NULL),
	(92,NULL,NULL,17,'edit','Editar',NULL),
	(93,NULL,NULL,17,'delete','Eliminar',NULL),
	(94,NULL,NULL,17,'clone','Clonar gasto',NULL),
	(95,NULL,NULL,18,'list','Ver listado de activos',NULL),
	(96,NULL,NULL,18,'list-inactive','Ver listado de inactivos',NULL),
	(97,NULL,NULL,18,'authorize','Autorizar bajas',NULL),
	(98,NULL,NULL,18,'add','Agregar activo',NULL),
	(99,NULL,NULL,18,'assign','Asignar activo a empleado',NULL),
	(100,NULL,NULL,18,'edit','Editar',NULL),
	(101,NULL,NULL,18,'delete','Baja de inventario',NULL),
	(102,NULL,NULL,18,'my-own','Ver mis activos asignados',NULL),
	(103,NULL,NULL,18,'add-maintenance','Agregar mantenimiento',NULL),
	(104,NULL,NULL,18,'view-maintenance','Ver historial de mantenimientos',NULL),
	(105,NULL,NULL,19,'list','Listado de certificaciones',NULL),
	(106,NULL,NULL,19,'add','Agregar',NULL),
	(107,NULL,NULL,19,'edit','Editar',NULL),
	(108,NULL,NULL,19,'delete','Eliminar',NULL),
	(109,NULL,NULL,19,'assign','Asignar a empleados',NULL),
	(110,NULL,NULL,19,'view','Detalle de certificación',NULL),
	(111,NULL,NULL,14,'assign','Asignar capacitación a empleados',NULL),
	(112,NULL,NULL,14,'my-own','Ver mis capacitaciones',NULL),
	(113,NULL,NULL,14,'view','Ver detalle de capacitación',NULL),
	(114,NULL,NULL,20,'list','Mis tareas',NULL),
	(115,NULL,NULL,20,'add','Agregar',NULL),
	(116,NULL,NULL,20,'delete','Eliminar',NULL),
	(117,NULL,NULL,20,'assign','Asignar tareas',NULL),
	(118,NULL,NULL,20,'finish','Finalizar tarea',NULL),
	(119,NULL,NULL,20,'add-tag','Agregar tags',NULL),
	(120,NULL,NULL,21,'list','Calendario',NULL),
	(121,NULL,NULL,21,'add','Agregar evento',NULL),
	(122,NULL,NULL,21,'assign','Agregar invitados',NULL),
	(123,NULL,NULL,3,'main','Ver dashboard principal',NULL),
	(124,NULL,NULL,22,'list','Listado de oficinas',NULL),
	(125,NULL,NULL,22,'add','Agregar oficina',NULL),
	(126,NULL,NULL,22,'edit','Editar',NULL),
	(127,NULL,NULL,22,'delete','Eliminar',NULL),
	(128,NULL,NULL,23,'list','Lista de logs',NULL),
	(129,NULL,NULL,12,'export','Exportar listado',NULL),
	(131,NULL,NULL,3,'complete-profile','Tablero Completar perfil','2024-01-11 00:00:00'),
	(132,NULL,NULL,3,'birthday-month','Tablero Cumpleaños del mes','2024-01-11 00:00:00'),
	(133,NULL,NULL,3,'employees-total','Tablero Total de empleados','2024-01-11 00:00:00'),
	(134,NULL,NULL,3,'upcoming-anniversaries','Tablero Próximos aniversarios','2024-01-11 00:00:00'),
	(135,NULL,NULL,3,'upcoming-anniversaries-three','Tablero Próximos a cumplir 3 meses','2024-01-11 00:00:00'),
	(136,NULL,NULL,3,'uses-news','Tablero Nuevos ingresos del mes','2024-01-11 00:00:00'),
	(137,NULL,NULL,17,'list','Grid de gastos por filtro',NULL),
	(138,NULL,NULL,17,'board-payments-by-q','Tablero Egresos por cuadrantes',NULL),
	(139,NULL,NULL,17,'search','Filtros de búsqueda',NULL),
	(140,NULL,NULL,17,'approve','Aprobar',NULL),
	(141,NULL,NULL,17,'reject','Rechazar',NULL),
	(142,NULL,NULL,24,'list','Ver listado',NULL),
	(143,NULL,NULL,24,'edit','Editar',NULL),
	(144,NULL,NULL,24,'add','Agregar',NULL),
	(145,NULL,NULL,24,'delete','Eliminar',NULL),
	(146,NULL,NULL,18,'dashboard','Dashboard activos',NULL),
	(147,NULL,NULL,18,'board-dashboard-type','Tablero Tipo de Activo',NULL),
	(148,NULL,NULL,18,'board-dashboard-upcoming-maintenance','Tablero Próximos mantenimientos',NULL),
	(149,NULL,NULL,18,'board-dashboard-pending-responsives','Tablero Resonsivas pendientes',NULL),
	(150,NULL,NULL,18,'unauthorize','Rechazar baja',NULL),
	(151,NULL,NULL,15,'edit','Editar solicitud',NULL),
	(152,NULL,NULL,15,'delete','Eliminar solicitud',NULL),
	(153,'2024-01-11 16:03:55','2024-01-11 16:03:55',20,'edit','Editar tareas',NULL),
	(154,'2024-01-11 16:04:11','2024-01-11 16:04:11',6,'view','Visualizar detalles del aviso',NULL),
	(155,'2024-01-11 16:04:11','2024-01-11 16:04:11',6,'activate','Activar el aviso',NULL),
	(156,'2024-01-11 16:04:11','2024-01-11 16:04:11',6,'desactivate','Desactivar el aviso',NULL),
	(157,'2024-01-11 16:04:29','2024-01-11 16:04:29',3,'task','Tablero Tareas pendientes del día',NULL),
	(158,NULL,NULL,25,'list','Listado de productos',NULL),
	(159,NULL,NULL,25,'add','Agregar producto',NULL),
	(160,NULL,NULL,25,'activate','Activar producto',NULL),
	(161,NULL,NULL,24,'delete','Eliminar',NULL),
	(162,NULL,NULL,25,'edit','Editar',NULL),
	(163,NULL,NULL,25,'activate','Activar producto',NULL),
	(164,NULL,NULL,25,'desactivate','Desactivar producto',NULL),
	(165,NULL,NULL,3,'advertisements-dashboard','Tablero de anuncios',NULL),
	(166,NULL,NULL,26,'view-my-own-request-credit','Ver mis propios trámites',NULL),
	(167,NULL,NULL,3,'employees-range','Tablero Total de empleados (Por rango)','2024-01-11 00:00:00'),
	(168,NULL,NULL,26,'edit-my-own-request-credit','Editar mis propios trámites',NULL),
	(169,NULL,NULL,3,'employees-range','Tablero Total de empleados (Por rango)','2024-01-11 00:00:00'),
	(170,NULL,NULL,26,'delete-my-own-request-credit','Eliminar mis propios trámites',NULL),
	(171,NULL,NULL,26,'list','Ver listado de trámites completo',NULL),
	(172,NULL,NULL,3,'employees-range','Tablero Total de empleados (Por rango)','2024-01-11 00:00:00'),
	(173,NULL,NULL,26,'edit','Editar cualquier trámite (no solo los propios)',NULL),
	(174,NULL,NULL,26,'delete','Eliminar cualquier trámite (no solo los propios)',NULL),
	(175,NULL,NULL,26,'approve','Aprovar un trámite',NULL),
	(176,NULL,NULL,26,'reject','Rechazar un trámite',NULL),
	(177,NULL,NULL,26,'view-files','Ver documentos',NULL),
	(178,NULL,NULL,26,'dowload-files','Descargar documentos',NULL),
	(179,NULL,NULL,26,'dowload-all','Descargar expediente',NULL),
	(180,NULL,NULL,26,'add','Crear nuevo trámite',NULL),
	(181,NULL,NULL,26,'upload-files','Cargar documentos de acuerdo a la etapa',NULL),
	(182,NULL,NULL,26,'garbage','Ver papelera',NULL),
	(183,NULL,NULL,25,'delete','Eliminar producto',NULL);

/*!40000 ALTER TABLE `actions` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
