-- --------------------------------------------------------
-- Versione server:              10.3.14-MariaDB - mariadb.org binary distribution
-- S.O. server:                  Win64
-- HeidiSQL Versione:            12.5.0.6677
-- --------------------------------------------------------


-- Dump dei dati della tabella llg_staging01.admin_config: ~0 rows (circa)

-- Dump dei dati della tabella llg_staging01.admin_menu: ~18 rows (circa)
INSERT INTO `admin_menu` (`id`, `parent_id`, `order`, `title`, `icon`, `uri`, `permission`, `created_at`, `updated_at`) VALUES
	(1, 0, 1, 'Dashboard', 'fa-bar-chart', '/', NULL, NULL, '2023-06-08 08:18:26'),
	(2, 0, 5, 'Admin', 'fa-tasks', NULL, NULL, NULL, '2023-06-15 08:47:02'),
	(3, 2, 6, 'Utenti', 'fa-users', 'auth/users', NULL, NULL, '2023-06-14 13:37:47'),
	(4, 2, 7, 'Ruoli', 'fa-user', 'auth/roles', NULL, NULL, '2023-06-14 13:37:47'),
	(5, 2, 8, 'Permessi', 'fa-ban', 'auth/permissions', NULL, NULL, '2023-06-14 13:37:47'),
	(6, 2, 9, 'Menu', 'fa-bars', 'auth/menu', NULL, NULL, '2023-06-14 13:37:47'),
	(7, 2, 10, 'Audit interno', 'fa-history', 'auth/logs', NULL, NULL, '2023-06-14 13:37:47'),
	(8, 0, 11, 'Helpers', 'fa-gears', NULL, NULL, '2023-06-06 19:00:36', '2023-06-15 08:45:33'),
	(9, 8, 12, 'Scaffold', 'fa-keyboard-o', 'helpers/scaffold', NULL, '2023-06-06 19:00:36', '2023-06-14 13:37:47'),
	(10, 8, 13, 'Database terminal', 'fa-database', 'helpers/terminal/database', NULL, '2023-06-06 19:00:36', '2023-06-14 13:37:47'),
	(11, 8, 14, 'Laravel artisan', 'fa-terminal', 'helpers/terminal/artisan', NULL, '2023-06-06 19:00:36', '2023-06-14 13:37:47'),
	(12, 8, 15, 'Routes', 'fa-list-alt', 'helpers/routes', NULL, '2023-06-06 19:00:36', '2023-06-14 13:37:47'),
	(13, 8, 17, 'Log viewer', 'fa-database', 'logs', NULL, '2023-06-06 19:15:35', '2023-06-14 13:37:47'),
	(14, 8, 18, 'Scheduling', 'fa-clock-o', 'scheduling', NULL, '2023-06-06 19:20:37', '2023-06-14 13:37:47'),
	(15, 8, 16, 'EnvManager', 'fa-gears', 'env-manager', NULL, '2023-06-06 19:38:13', '2023-06-14 13:37:47'),
	(16, 0, 2, 'LOGS', 'fa-database', NULL, NULL, '2023-06-07 14:52:38', '2023-06-15 09:14:21'),
	(17, 16, 3, 'Syslog', 'fa-database', '/logs/syslog', 'llg.logs', '2023-06-07 14:53:18', '2023-06-15 08:51:03'),
	(18, 16, 4, 'Windows', 'fa-database', '/logs/windows', NULL, '2023-06-14 13:37:38', '2023-06-14 13:37:47');

-- Dump dei dati della tabella llg_staging01.admin_permissions: ~8 rows (circa)
INSERT INTO `admin_permissions` (`id`, `name`, `slug`, `http_method`, `http_path`, `created_at`, `updated_at`) VALUES
	(1, 'Tutti i permessi', '*', '', '*', NULL, '2023-06-07 06:28:29'),
	(2, 'Dashboard', 'dashboard', 'GET', '/', NULL, NULL),
	(3, 'Login', 'auth.login', '', '/auth/login\r\n/auth/logout', NULL, NULL),
	(4, 'User setting', 'auth.setting', 'GET,PUT', '/auth/setting', NULL, NULL),
	(5, 'Auth management', 'auth.management', '', '/auth/roles\r\n/auth/permissions\r\n/auth/menu\r\n/auth/logs', NULL, NULL),
	(6, 'Admin helpers', 'ext.helpers', '', '/helpers/*', '2023-06-06 19:00:36', '2023-06-06 19:00:36'),
	(7, 'Log Viewer', 'ext.log-viewer', '', '/logs*', '2023-06-06 19:15:35', '2023-06-14 18:47:55'),
	(8, 'Scheduling', 'ext.scheduling', '', '/scheduling*', '2023-06-06 19:20:37', '2023-06-06 19:20:37'),
	(9, 'LLG Logs', 'llg.logs', '', '/llg-logs*', '2023-06-14 18:42:11', '2023-06-14 18:42:11');

-- Dump dei dati della tabella llg_staging01.admin_roles: ~1 rows (circa)
INSERT INTO `admin_roles` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES
	(1, 'Superuser', 'superuser', '2023-06-06 16:09:21', '2023-06-06 19:52:33'),
	(2, 'Administrator', 'administrator', '2023-06-15 08:41:59', '2023-06-15 08:41:59'),
	(3, 'Cliente Admin', 'adminc', '2023-06-15 08:52:04', '2023-06-15 08:52:04'),
	(4, 'Operatore', 'operator', '2023-06-15 08:52:04', '2023-06-15 08:52:04');

-- Dump dei dati della tabella llg_staging01.admin_role_menu: ~0 rows (circa)
INSERT INTO `admin_role_menu` (`role_id`, `menu_id`, `created_at`, `updated_at`) VALUES
	(1, 2, NULL, NULL),
	(1, 8, NULL, NULL),
	(1, 3, NULL, NULL),
	(2, 3, NULL, NULL),
	(1, 5, NULL, NULL),
	(1, 6, NULL, NULL),
	(1, 7, NULL, NULL),
	(2, 7, NULL, NULL),
	(2, 2, NULL, NULL),
	(1, 16, NULL, NULL),
	(2, 16, NULL, NULL);

-- Dump dei dati della tabella llg_staging01.admin_role_permissions: ~0 rows (circa)
INSERT INTO `admin_role_permissions` (`role_id`, `permission_id`, `created_at`, `updated_at`) VALUES
	(1, 1, NULL, NULL),
	(2, 2, NULL, NULL),
	(2, 3, NULL, NULL),
	(2, 4, NULL, NULL),
	(2, 9, NULL, NULL),
	(3, 2, NULL, NULL),
	(3, 3, NULL, NULL),
	(3, 4, NULL, NULL),
	(3, 9, NULL, NULL);

-- Dump dei dati della tabella llg_staging01.admin_role_users: ~2 rows (circa)
INSERT INTO `admin_role_users` (`role_id`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 1, NULL, NULL),
	(2, 3, NULL, NULL);

-- Dump dei dati della tabella llg_staging01.admin_user_permissions: ~0 rows (circa)

-- Dump dei dati della tabella llg_staging01.password_reset_tokens: ~0 rows (circa)

-- Dump dei dati della tabella llg_staging01.personal_access_tokens: ~0 rows (circa)

-- Dump dei dati della tabella llg_staging01.users: ~0 rows (circa)

