-- Stephup Construction Report current data export
-- Import database/mysql-schema.sql first, then this file.
-- Runtime tables such as sessions, cache, and jobs are cleared but not imported.
-- Generated: 2026-06-22 13:57:32

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;

DELETE FROM `report_shares`;
ALTER TABLE `report_shares` AUTO_INCREMENT = 1;
DELETE FROM `audit_logs`;
ALTER TABLE `audit_logs` AUTO_INCREMENT = 1;
DELETE FROM `project_user`;
ALTER TABLE `project_user` AUTO_INCREMENT = 1;
DELETE FROM `report_status_logs`;
ALTER TABLE `report_status_logs` AUTO_INCREMENT = 1;
DELETE FROM `report_comments`;
ALTER TABLE `report_comments` AUTO_INCREMENT = 1;
DELETE FROM `report_files`;
ALTER TABLE `report_files` AUTO_INCREMENT = 1;
DELETE FROM `report_photos`;
ALTER TABLE `report_photos` AUTO_INCREMENT = 1;
DELETE FROM `reports`;
ALTER TABLE `reports` AUTO_INCREMENT = 1;
DELETE FROM `projects`;
ALTER TABLE `projects` AUTO_INCREMENT = 1;
DELETE FROM `app_settings`;
ALTER TABLE `app_settings` AUTO_INCREMENT = 1;
DELETE FROM `failed_jobs`;
ALTER TABLE `failed_jobs` AUTO_INCREMENT = 1;
DELETE FROM `job_batches`;
ALTER TABLE `job_batches` AUTO_INCREMENT = 1;
DELETE FROM `jobs`;
ALTER TABLE `jobs` AUTO_INCREMENT = 1;
DELETE FROM `cache_locks`;
ALTER TABLE `cache_locks` AUTO_INCREMENT = 1;
DELETE FROM `cache`;
ALTER TABLE `cache` AUTO_INCREMENT = 1;
DELETE FROM `sessions`;
ALTER TABLE `sessions` AUTO_INCREMENT = 1;
DELETE FROM `password_reset_tokens`;
ALTER TABLE `password_reset_tokens` AUTO_INCREMENT = 1;
DELETE FROM `users`;
ALTER TABLE `users` AUTO_INCREMENT = 1;
DELETE FROM `migrations`;
ALTER TABLE `migrations` AUTO_INCREMENT = 1;

-- migrations
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('1', '0001_01_01_000000_create_users_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('2', '0001_01_01_000001_create_cache_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('3', '0001_01_01_000002_create_jobs_table', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('4', '2026_06_21_000001_create_reporting_domain_tables', '1');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('5', '2026_06_21_000002_add_references_and_project_assignments', '2');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('6', '2026_06_21_000003_create_audit_logs_table', '3');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('7', '2026_06_21_000004_create_app_settings_table', '4');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('8', '2026_06_21_000005_add_thumbnail_and_extra_settings', '5');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('9', '2026_06_21_000006_add_report_archive_fields', '6');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('10', '2026_06_21_000007_add_structured_checklist_to_reports', '7');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('11', '2026_06_21_000008_create_report_shares_table', '8');
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES ('12', '2026_06_21_000009_add_photo_metadata_and_custom_checklist', '9');

-- users
INSERT INTO `users` (`id`, `name`, `email`, `role`, `job_title`, `phone`, `is_active`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES ('1', 'Admin User', 'admin@stephup.test', 'admin', 'Operations Administrator', '+1.559.781.4314', '1', '2026-06-21 12:40:02', '$2y$12$EouHpOA0Vna7S6Obriky6e1CRagqHvETOSR9MH7p7RdTwi8hcjbz.', '5GE64a2gLPhyD4h08krMGLYJ8nmzKQaAqOmy432Cz8pd3I7dy1rQyWZxtW3E', '2026-06-21 12:40:03', '2026-06-21 12:40:03');
INSERT INTO `users` (`id`, `name`, `email`, `role`, `job_title`, `phone`, `is_active`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES ('2', 'Supervisor User', 'supervisor@stephup.test', 'supervisor', 'Site Supervisor', '+1-938-515-9488', '1', '2026-06-21 12:40:03', '$2y$12$EouHpOA0Vna7S6Obriky6e1CRagqHvETOSR9MH7p7RdTwi8hcjbz.', 'p6sdKNvn3RwCzRFVAoNnfVsm5DEe2JD4gojYyDey1gx4xQMKLQAXTWlDkRKZ', '2026-06-21 12:40:03', '2026-06-21 12:40:03');
INSERT INTO `users` (`id`, `name`, `email`, `role`, `job_title`, `phone`, `is_active`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES ('3', 'Technician User', 'technician@stephup.test', 'technician', 'Field Technician', '458.998.0989', '1', '2026-06-21 12:40:03', '$2y$12$EouHpOA0Vna7S6Obriky6e1CRagqHvETOSR9MH7p7RdTwi8hcjbz.', 'PBNx0XJtdndJw8dZfvcIbsOXqzWno5cFNjS8JVmA0AYCXwbyf3ISV1ca2Klz', '2026-06-21 12:40:03', '2026-06-21 12:40:03');
INSERT INTO `users` (`id`, `name`, `email`, `role`, `job_title`, `phone`, `is_active`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES ('4', 'E2E Admin', 'e2e.admin@stephup.test', 'admin', 'Admin', '000', '1', NULL, '$2y$12$tHe1O4H0OggvSvtbu428I.RyxqREkQzfhMeEge6AG4bcJ3jXQ1gBu', NULL, '2026-06-21 20:40:44', '2026-06-22 08:53:16');
INSERT INTO `users` (`id`, `name`, `email`, `role`, `job_title`, `phone`, `is_active`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES ('5', 'E2E Technician', 'e2e.tech@stephup.test', 'technician', 'Technician', '001', '1', NULL, '$2y$12$sjRA9SNgYKaNaWaD4bI10epU/kXIsSTvqaLsPbLL1bWp3ghB8rczi', NULL, '2026-06-21 20:40:45', '2026-06-22 08:53:16');

-- app_settings
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES ('1', 'company_name', 'Stephup Construction Report', '2026-06-21 13:33:35', '2026-06-21 13:33:35');
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES ('2', 'company_email', 'office@stephup.co.za', '2026-06-21 13:33:35', '2026-06-21 13:33:35');
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES ('3', 'company_phone', NULL, '2026-06-21 13:33:35', '2026-06-21 13:33:35');
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES ('4', 'pdf_header', 'Approved field report', '2026-06-21 13:33:35', '2026-06-21 13:33:35');
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES ('5', 'pdf_footer', 'Generated by Stephup Construction Report.', '2026-06-21 13:33:35', '2026-06-21 13:33:35');
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES ('6', 'logo_path', NULL, '2026-06-21 13:41:04', '2026-06-21 13:41:04');
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES ('7', 'favicon_path', NULL, '2026-06-21 13:41:04', '2026-06-21 13:41:04');
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES ('8', 'default_notification_emails', NULL, '2026-06-21 13:41:04', '2026-06-21 13:41:04');
INSERT INTO `app_settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES ('9', 'custom_checklist_fields', 'e2e_safety|E2E Safety Check
e2e_access|E2E Access Clear', '2026-06-21 20:40:45', '2026-06-21 20:40:45');

-- projects
INSERT INTO `projects` (`id`, `name`, `code`, `client_name`, `location`, `starts_on`, `ends_on`, `status`, `created_by`, `created_at`, `updated_at`) VALUES ('1', 'Riverside Mall Extension', 'RME-001', 'Riverside Developments', 'Johannesburg', '2026-06-07 00:00:00', '2026-10-21 00:00:00', 'active', '1', '2026-06-21 12:40:03', '2026-06-21 19:29:29');
INSERT INTO `projects` (`id`, `name`, `code`, `client_name`, `location`, `starts_on`, `ends_on`, `status`, `created_by`, `created_at`, `updated_at`) VALUES ('2', 'E2E Project', 'E2E-001', 'E2E Client', 'Johannesburg', NULL, NULL, 'active', '4', '2026-06-21 20:40:45', '2026-06-21 20:40:45');

-- reports
INSERT INTO `reports` (`id`, `project_id`, `technician_id`, `supervisor_id`, `title`, `work_date`, `weather`, `manpower_count`, `equipment`, `work_completed`, `issues`, `safety_notes`, `next_steps`, `status`, `submitted_at`, `reviewed_at`, `created_at`, `updated_at`, `reference_number`, `archived_at`, `archived_by`, `safety_briefing_completed`, `ppe_compliant`, `incidents_reported`, `incident_details`, `delays_reported`, `delay_details`, `materials_delivered`, `materials_used`, `quality_check_completed`, `quality_notes`, `client_instruction_received`, `client_instructions`, `snag_items_reported`, `snag_items`, `custom_checklist`) VALUES ('1', '1', '3', '2', 'Foundation pour inspection', '2026-06-20 00:00:00', 'Clear', '12', 'Concrete mixer, vibrator, laser level', 'Completed foundation pour for grid B and verified levels before curing.', 'Delivery truck arrived 40 minutes late.', 'Toolbox talk completed. No incidents recorded.', 'Begin curing checks and prepare rebar for grid C.', 'approved', '2026-06-20 14:40:03', '2026-06-20 17:40:03', '2026-06-21 12:40:03', '2026-06-21 19:43:12', 'RME-001-REP-0001', NULL, NULL, '0', '0', '0', NULL, '0', NULL, '0', NULL, '1', NULL, '1', NULL, '0', NULL, NULL);
INSERT INTO `reports` (`id`, `project_id`, `technician_id`, `supervisor_id`, `title`, `work_date`, `weather`, `manpower_count`, `equipment`, `work_completed`, `issues`, `safety_notes`, `next_steps`, `status`, `submitted_at`, `reviewed_at`, `created_at`, `updated_at`, `reference_number`, `archived_at`, `archived_by`, `safety_briefing_completed`, `ppe_compliant`, `incidents_reported`, `incident_details`, `delays_reported`, `delay_details`, `materials_delivered`, `materials_used`, `quality_check_completed`, `quality_notes`, `client_instruction_received`, `client_instructions`, `snag_items_reported`, `snag_items`, `custom_checklist`) VALUES ('2', '2', '5', NULL, 'E2E offline queued report', '2026-06-21 00:00:00', NULL, '0', NULL, 'Offline queued work.', NULL, NULL, NULL, 'draft', NULL, NULL, '2026-06-21 20:45:18', '2026-06-21 20:45:18', 'E2E-001-REP-0001', NULL, NULL, '0', '0', '0', NULL, '0', NULL, '0', NULL, '0', NULL, '0', NULL, '0', NULL, '{"e2e_safety":false,"e2e_access":false}');
INSERT INTO `reports` (`id`, `project_id`, `technician_id`, `supervisor_id`, `title`, `work_date`, `weather`, `manpower_count`, `equipment`, `work_completed`, `issues`, `safety_notes`, `next_steps`, `status`, `submitted_at`, `reviewed_at`, `created_at`, `updated_at`, `reference_number`, `archived_at`, `archived_by`, `safety_briefing_completed`, `ppe_compliant`, `incidents_reported`, `incident_details`, `delays_reported`, `delay_details`, `materials_delivered`, `materials_used`, `quality_check_completed`, `quality_notes`, `client_instruction_received`, `client_instructions`, `snag_items_reported`, `snag_items`, `custom_checklist`) VALUES ('3', '2', '5', NULL, 'E2E offline queued report', '2026-06-21 00:00:00', NULL, '0', NULL, 'Offline queued work.', NULL, NULL, NULL, 'draft', NULL, NULL, '2026-06-21 20:46:07', '2026-06-21 20:46:07', 'E2E-001-REP-0002', NULL, NULL, '0', '0', '0', NULL, '0', NULL, '0', NULL, '0', NULL, '0', NULL, '0', NULL, '{"e2e_safety":false,"e2e_access":false}');
INSERT INTO `reports` (`id`, `project_id`, `technician_id`, `supervisor_id`, `title`, `work_date`, `weather`, `manpower_count`, `equipment`, `work_completed`, `issues`, `safety_notes`, `next_steps`, `status`, `submitted_at`, `reviewed_at`, `created_at`, `updated_at`, `reference_number`, `archived_at`, `archived_by`, `safety_briefing_completed`, `ppe_compliant`, `incidents_reported`, `incident_details`, `delays_reported`, `delay_details`, `materials_delivered`, `materials_used`, `quality_check_completed`, `quality_notes`, `client_instruction_received`, `client_instructions`, `snag_items_reported`, `snag_items`, `custom_checklist`) VALUES ('4', '2', '5', NULL, 'E2E offline queued report', '2026-06-22 00:00:00', NULL, '0', NULL, 'Offline queued work.', NULL, NULL, NULL, 'draft', NULL, NULL, '2026-06-22 08:53:21', '2026-06-22 08:53:21', 'E2E-001-REP-0003', NULL, NULL, '0', '0', '0', NULL, '0', NULL, '0', NULL, '0', NULL, '0', NULL, '0', NULL, '{"e2e_safety":false,"e2e_access":false}');

-- report_comments
INSERT INTO `report_comments` (`id`, `report_id`, `user_id`, `body`, `created_at`, `updated_at`) VALUES ('1', '1', '2', 'Approved. Add curing photos to the next daily report.', '2026-06-21 12:40:03', '2026-06-21 12:40:03');

-- report_status_logs
INSERT INTO `report_status_logs` (`id`, `report_id`, `user_id`, `from_status`, `to_status`, `note`, `created_at`) VALUES ('1', '1', '3', NULL, 'draft', 'Draft created.', '2026-06-20 13:40:03');
INSERT INTO `report_status_logs` (`id`, `report_id`, `user_id`, `from_status`, `to_status`, `note`, `created_at`) VALUES ('2', '1', '3', 'draft', 'submitted', 'Submitted for supervisor review.', '2026-06-20 14:40:03');
INSERT INTO `report_status_logs` (`id`, `report_id`, `user_id`, `from_status`, `to_status`, `note`, `created_at`) VALUES ('3', '1', '2', 'submitted', 'approved', 'Approved.', '2026-06-20 17:40:03');
INSERT INTO `report_status_logs` (`id`, `report_id`, `user_id`, `from_status`, `to_status`, `note`, `created_at`) VALUES ('4', '2', '5', NULL, 'draft', 'Draft created.', '2026-06-21 20:45:18');
INSERT INTO `report_status_logs` (`id`, `report_id`, `user_id`, `from_status`, `to_status`, `note`, `created_at`) VALUES ('5', '3', '5', NULL, 'draft', 'Draft created.', '2026-06-21 20:46:08');
INSERT INTO `report_status_logs` (`id`, `report_id`, `user_id`, `from_status`, `to_status`, `note`, `created_at`) VALUES ('6', '4', '5', NULL, 'draft', 'Draft created.', '2026-06-22 08:53:21');

-- audit_logs
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('1', '2', 'report.viewed', 'App\Models\Report', '1', 'Viewed report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 13:52:48');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('2', '2', 'report.print.viewed', 'App\Models\Report', '1', 'Viewed print report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 13:52:54');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('3', '1', 'maintenance.test_email_sent', NULL, NULL, 'Sent system test email.', '{"recipient":"codestratdesigners@gmail.com"}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:10:22');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('4', '1', 'report.viewed', 'App\Models\Report', '1', 'Viewed report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:21:48');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('5', '1', 'report.viewed', 'App\Models\Report', '1', 'Viewed report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:26:39');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('6', '1', 'report.viewed', 'App\Models\Report', '1', 'Viewed report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:28:37');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('7', '1', 'project.archived', 'App\Models\Project', '1', 'Archived project RME-001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:29:03');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('8', '1', 'report.viewed', 'App\Models\Report', '1', 'Viewed report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:29:14');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('9', '1', 'project.updated', 'App\Models\Project', '1', 'Updated project RME-001', '{"before":{"name":"Riverside Mall Extension","code":"RME-001","client_name":"Riverside Developments","location":"Johannesburg","starts_on":"2026-06-07T00:00:00.000000Z","ends_on":"2026-10-21T00:00:00.000000Z","status":"archived"},"after":{"name":"Riverside Mall Extension","code":"RME-001","client_name":"Riverside Developments","location":"Johannesburg","starts_on":"2026-06-07T00:00:00.000000Z","ends_on":"2026-10-21T00:00:00.000000Z","status":"active"},"technician_ids":[],"supervisor_ids":[]}', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:29:29');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('10', '1', 'report.viewed', 'App\Models\Report', '1', 'Viewed report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:42:56');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('11', '1', 'report.updated', 'App\Models\Report', '1', 'Updated report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:43:12');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('12', '1', 'report.viewed', 'App\Models\Report', '1', 'Viewed report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:43:12');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('13', '1', 'report.viewed', 'App\Models\Report', '1', 'Viewed report RME-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 19:50:36');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('14', '5', 'report.created', 'App\Models\Report', '2', 'Created report E2E-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.7827.55 Safari/537.36', '2026-06-21 20:45:18');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('15', '5', 'report.created', 'App\Models\Report', '3', 'Created report E2E-001-REP-0002', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.7827.55 Safari/537.36', '2026-06-21 20:46:08');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('16', '1', 'report.viewed', 'App\Models\Report', '3', 'Viewed report E2E-001-REP-0002', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 20:48:49');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('17', '1', 'report.print.viewed', 'App\Models\Report', '3', 'Viewed print report E2E-001-REP-0002', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 20:49:19');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('18', '1', 'report.viewed', 'App\Models\Report', '2', 'Viewed report E2E-001-REP-0001', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', '2026-06-21 22:26:26');
INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `auditable_type`, `auditable_id`, `description`, `metadata`, `ip_address`, `user_agent`, `created_at`) VALUES ('19', '5', 'report.created', 'App\Models\Report', '4', 'Created report E2E-001-REP-0003', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.7827.55 Safari/537.36', '2026-06-22 08:53:21');

SET FOREIGN_KEY_CHECKS=1;