CREATE TABLE `activity_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `activity` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `activity_logs_user_id_foreign` (`user_id`),
  CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

INSERT INTO `permission_groups` (`name`, `created_at`, `updated_at`) VALUES
('Asset Management', '2024-02-14 16:59:18', '2024-02-14 16:59:18');

INSERT INTO `permissions` (`name`, `guard_name`, `created_at`, `updated_at`, `permission_group_id`) VALUES
('Asset Management', 'web', '2024-02-14 17:00:00', '2024-02-14 17:00:00', 7)
('Add Asset', 'web', '2024-02-14 17:01:16', '2024-02-14 17:01:16', 7)
('Edit Asset', 'web', '2024-02-14 17:02:02', '2024-02-14 17:02:02', 7)
('Delete Asset', 'web', '2024-02-14 17:02:40', '2024-02-14 17:02:40', 7)
('View Asset', 'web', '2024-02-14 17:03:18', '2024-02-14 17:03:18', 7)
('Assign Asset', 'web', '2024-02-14 17:04:17', '2024-02-14 17:04:17', 7)
('Add Assign Asset', 'web', '2024-02-14 17:05:55', '2024-02-14 17:05:55', 7)
('Edit Assign Asset', 'web', '2024-02-14 17:06:41', '2024-02-14 17:06:41', 7);