-- =============================================================================
-- Somalia Data Protection Authority (SDPA) — Complete MySQL schema + seed data
-- File: database.sql
-- Stack: React (frontend) + Laravel (backend) + MySQL
-- Database name: website_dp  (matches backend/.env DB_DATABASE)
--
-- How to import (fresh install):
--   1. Start MySQL / MariaDB (XAMPP)
--   2. In phpMyAdmin or CLI, import this file:
--        mysql -h 127.0.0.1 -P 3307 -u root < database.sql
--   3. Point backend/.env to DB_DATABASE=website_dp
--   4. Do NOT run `php artisan migrate` after import (migrations are already recorded)
--      Optional content seed only: php artisan db:seed
--
-- Default admin logins (password for both: Password123!):
--   admin@dpa.gov.so  →  Super Admin
--   post@dpa.gov.so   →  Post (News & Events)
--
-- Schema matches the final merged state of all Laravel migrations under
-- backend/database/migrations/ (including alters such as password_display,
-- contacts enhancements, news.user_id, guidances status/file_path, etc.).
-- =============================================================================

CREATE DATABASE IF NOT EXISTS `website_dp` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `website_dp`;

CREATE TABLE `advisory_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference_number` varchar(255) NOT NULL,
  `organization_name` varchar(255) NOT NULL,
  `contact_person` varchar(255) NOT NULL,
  `contact_email` varchar(255) NOT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `request_type` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `urgency` varchar(255) NOT NULL DEFAULT 'normal',
  `status` enum('pending','in_progress','completed','cancelled') NOT NULL DEFAULT 'pending',
  `assigned_to` bigint(20) unsigned DEFAULT NULL,
  `admin_notes` text DEFAULT NULL,
  `due_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `advisory_requests_reference_number_unique` (`reference_number`),
  KEY `advisory_requests_assigned_to_foreign` (`assigned_to`),
  KEY `advisory_requests_status_urgency_index` (`status`,`urgency`),
  CONSTRAINT `advisory_requests_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `announcements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title_en` varchar(255) NOT NULL,
  `title_so` varchar(255) NOT NULL,
  `content_en` longtext NOT NULL,
  `content_so` longtext NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `publish_date` date NOT NULL,
  `status` enum('draft','published','archived') NOT NULL DEFAULT 'draft',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `audience_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('individual','organization') NOT NULL,
  `title_en` varchar(255) NOT NULL,
  `title_so` varchar(255) DEFAULT NULL,
  `description_en` text NOT NULL,
  `description_so` text DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `order_column` int(11) NOT NULL DEFAULT 0,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `audit_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `model_type` varchar(255) DEFAULT NULL,
  `model_id` bigint(20) unsigned DEFAULT NULL,
  `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)),
  `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)),
  `ip_address` varchar(255) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_logs_user_id_created_at_index` (`user_id`,`created_at`),
  KEY `audit_logs_model_type_model_id_index` (`model_type`,`model_id`),
  CONSTRAINT `audit_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `breach_reports` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference_number` varchar(255) NOT NULL,
  `organization_name` varchar(255) NOT NULL,
  `contact_person` varchar(255) NOT NULL,
  `contact_email` varchar(255) NOT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `breach_description` text NOT NULL,
  `breach_type` varchar(255) NOT NULL,
  `breach_discovered_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `affected_individuals` int(11) NOT NULL DEFAULT 0,
  `data_types_affected` text NOT NULL,
  `containment_measures` text DEFAULT NULL,
  `severity` enum('low','medium','high','critical') NOT NULL DEFAULT 'medium',
  `status` enum('pending','under_review','resolved','closed') NOT NULL DEFAULT 'pending',
  `assigned_to` bigint(20) unsigned DEFAULT NULL,
  `admin_notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `breach_reports_reference_number_unique` (`reference_number`),
  KEY `breach_reports_assigned_to_foreign` (`assigned_to`),
  KEY `breach_reports_status_severity_index` (`status`,`severity`),
  CONSTRAINT `breach_reports_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `contacts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `reference_number` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) NOT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `admin_notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `contacts_reference_number_unique` (`reference_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `departments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name_en` varchar(255) NOT NULL,
  `name_so` varchar(255) NOT NULL,
  `description_en` text NOT NULL,
  `description_so` text NOT NULL,
  `head` varchar(255) DEFAULT NULL,
  `order_column` int(11) NOT NULL DEFAULT 0,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `faqs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `question_en` text NOT NULL,
  `question_so` text NOT NULL,
  `answer_en` text NOT NULL,
  `answer_so` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `faqs_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `guidances` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(255) NOT NULL,
  `title_en` varchar(255) NOT NULL,
  `title_so` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `url` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'published',
  `file_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `original_name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_url` varchar(255) NOT NULL,
  `mime_type` varchar(255) NOT NULL,
  `file_size` bigint(20) unsigned NOT NULL,
  `disk` varchar(255) NOT NULL DEFAULT 'public',
  `collection` varchar(255) NOT NULL DEFAULT 'general',
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_user_id_foreign` (`user_id`),
  KEY `media_collection_index` (`collection`),
  CONSTRAINT `media_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `slug` varchar(255) NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title_en` varchar(255) NOT NULL,
  `title_so` varchar(255) DEFAULT NULL,
  `excerpt_en` text DEFAULT NULL,
  `excerpt_so` text DEFAULT NULL,
  `content_en` longtext NOT NULL,
  `content_so` longtext DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `news_slug_unique` (`slug`),
  KEY `news_user_id_foreign` (`user_id`),
  CONSTRAINT `news_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `title_en` varchar(255) NOT NULL,
  `title_so` varchar(255) NOT NULL,
  `content_en` longtext NOT NULL,
  `content_so` longtext NOT NULL,
  `status` enum('draft','published') NOT NULL DEFAULT 'published',
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pages_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `permission_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permission_role_permission_id_role_id_unique` (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL DEFAULT 'general',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `excerpt` text DEFAULT NULL,
  `content` longtext NOT NULL,
  `category` varchar(255) NOT NULL DEFAULT 'general',
  `image` varchar(255) DEFAULT NULL,
  `status` enum('draft','published','archived') NOT NULL DEFAULT 'draft',
  `published_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `posts_slug_unique` (`slug`),
  KEY `posts_user_id_foreign` (`user_id`),
  KEY `posts_status_published_at_index` (`status`,`published_at`),
  KEY `posts_category_index` (`category`),
  CONSTRAINT `posts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `role_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_user_user_id_role_id_unique` (`user_id`,`role_id`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `service_info_cards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `service_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_so` varchar(255) NOT NULL,
  `desc` text NOT NULL,
  `desc_so` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `service_info_cards_service_id_foreign` (`service_id`),
  CONSTRAINT `service_info_cards_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `service_resources` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `service_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_so` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `service_resources_service_id_foreign` (`service_id`),
  CONSTRAINT `service_resources_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `order_column` int(11) NOT NULL DEFAULT 0,
  `title_en` varchar(255) NOT NULL,
  `title_so` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `short_desc_en` text NOT NULL,
  `short_desc_so` text NOT NULL,
  `long_desc_en` text NOT NULL,
  `long_desc_so` text NOT NULL,
  `hero_image` varchar(255) DEFAULT NULL,
  `hero_image_url` text DEFAULT NULL,
  `hero_tag` varchar(255) DEFAULT NULL,
  `hero_tag_so` varchar(255) DEFAULT NULL,
  `hero_title` varchar(255) DEFAULT NULL,
  `hero_title_so` varchar(255) DEFAULT NULL,
  `hero_desc` text DEFAULT NULL,
  `hero_desc_so` text DEFAULT NULL,
  `steps_en` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`steps_en`)),
  `steps_so` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`steps_so`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `services_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `team_members` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name_en` varchar(255) NOT NULL,
  `name_so` varchar(255) NOT NULL,
  `position_en` varchar(255) NOT NULL,
  `position_so` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description_en` text NOT NULL,
  `description_so` text NOT NULL,
  `order_column` int(11) NOT NULL DEFAULT 0,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Sample seed data

-- roles
INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (1,'super_admin','Super Admin','Full access to the entire system','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (2,'post','Post','Can create, edit, and manage their own News & Events only','2026-07-22 12:00:00','2026-07-22 12:00:00');

-- permissions
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (1,'view_users','View Users','users','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (2,'create_users','Create Users','users','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (3,'edit_users','Edit Users','users','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (4,'delete_users','Delete Users','users','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (5,'view_roles','View Roles','roles','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (6,'create_roles','Create Roles','roles','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (7,'edit_roles','Edit Roles','roles','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (8,'delete_roles','Delete Roles','roles','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (9,'view_posts','View Posts','posts','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (10,'create_posts','Create Posts','posts','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (11,'edit_posts','Edit Posts','posts','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (12,'delete_posts','Delete Posts','posts','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (13,'publish_posts','Publish Posts','posts','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (14,'view_breaches','View Breach Reports','breach_reports','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (15,'edit_breaches','Edit Breach Reports','breach_reports','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (16,'resolve_breaches','Resolve Breach Reports','breach_reports','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (17,'view_advisories','View Advisory Requests','advisory_requests','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (18,'edit_advisories','Edit Advisory Requests','advisory_requests','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (19,'resolve_advisories','Resolve Advisory Requests','advisory_requests','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (20,'view_contacts','View Contact Messages','contacts','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (21,'edit_contacts','Edit Contact Messages','contacts','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (22,'delete_contacts','Delete Contact Messages','contacts','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (23,'view_settings','View Settings','settings','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (24,'edit_settings','Edit Settings','settings','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (25,'view_audit_logs','View Audit Logs','audit_logs','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (26,'manage_pages','Manage Pages','pages','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (27,'manage_website','Manage Website Settings','website','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (28,'manage_team','Manage Team Members','team','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (29,'manage_departments','Manage Departments','departments','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (30,'manage_announcements','Manage Announcements','announcements','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (31,'manage_services','Manage Services','services','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (32,'view_news','View News & Events','news','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (33,'create_news','Create News & Events','news','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (34,'edit_news','Edit News & Events','news','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (35,'delete_news','Delete News & Events','news','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (36,'manage_news','Manage News & Events','news','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (37,'manage_faqs','Manage FAQs','faqs','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `permissions` (`id`, `name`, `display_name`, `group`, `created_at`, `updated_at`) VALUES (38,'manage_guidance','Manage Guidance','guidance','2026-07-22 12:00:00','2026-07-22 12:00:00');

-- permission_role
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (1,1,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (2,2,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (3,3,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (4,4,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (5,5,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (6,6,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (7,7,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (8,8,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (9,9,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (10,10,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (11,11,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (12,12,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (13,13,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (14,14,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (15,15,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (16,16,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (17,17,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (18,18,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (19,19,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (20,20,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (21,21,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (22,22,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (23,23,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (24,24,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (25,25,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (26,26,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (27,27,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (28,28,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (29,29,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (30,30,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (31,31,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (32,32,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (33,33,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (34,34,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (35,35,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (36,36,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (37,37,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (38,38,1,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (39,32,2,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (40,33,2,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (41,34,2,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (42,35,2,NULL,NULL);
INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES (43,36,2,NULL,NULL);

-- role_user
INSERT INTO `role_user` (`id`, `user_id`, `role_id`, `created_at`, `updated_at`) VALUES (1,1,1,NULL,NULL);
INSERT INTO `role_user` (`id`, `user_id`, `role_id`, `created_at`, `updated_at`) VALUES (2,2,2,NULL,NULL);

-- audience_items
INSERT INTO `audience_items` (`id`, `type`, `title_en`, `title_so`, `description_en`, `description_so`, `icon`, `order_column`, `status`, `created_at`, `updated_at`) VALUES (1,'individual','1. Right to be Informed',NULL,'Organizations must clearly explain how they collect, store, and share your personal data before gathering it. Usually outlined in a transparent Privacy Notice.',NULL,'FaFileAlt',1,'active','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `audience_items` (`id`, `type`, `title_en`, `title_so`, `description_en`, `description_so`, `icon`, `order_column`, `status`, `created_at`, `updated_at`) VALUES (2,'individual','2. Right of Access (Subject Access Request)',NULL,'You have the right to request copies of your personal records held by any public or private company in Somalia. They must respond within 30 days.',NULL,'FaUserCheck',2,'active','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `audience_items` (`id`, `type`, `title_en`, `title_so`, `description_en`, `description_so`, `icon`, `order_column`, `status`, `created_at`, `updated_at`) VALUES (3,'individual','3. Right to Rectification',NULL,'If any company has inaccurate or incomplete records about you, you can demand that they rectify and update your information immediately.',NULL,'FaBalanceScale',3,'active','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `audience_items` (`id`, `type`, `title_en`, `title_so`, `description_en`, `description_so`, `icon`, `order_column`, `status`, `created_at`, `updated_at`) VALUES (4,'individual','4. Right to Erasure (Deletion)',NULL,'Under certain criteria (e.g. data no longer needed, consent withdrawn), you can ask organizations to delete your personal databases permanently.',NULL,'FaUserShield',4,'active','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `audience_items` (`id`, `type`, `title_en`, `title_so`, `description_en`, `description_so`, `icon`, `order_column`, `status`, `created_at`, `updated_at`) VALUES (5,'organization','1. Mandated Registration',NULL,'All public and private organizations handling personal data must register with the SDPA as Data Controllers or Processors. Failure to do so will result in structural penalties.',NULL,'FaBuilding',1,'active','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `audience_items` (`id`, `type`, `title_en`, `title_so`, `description_en`, `description_so`, `icon`, `order_column`, `status`, `created_at`, `updated_at`) VALUES (6,'organization','2. Appoint Data Protection Officer (DPO)',NULL,'Major processors, telecoms, and financial institutions are legally required to appoint a certified DPO and register their credentials with the SDPA.',NULL,'FaUserTie',2,'active','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `audience_items` (`id`, `type`, `title_en`, `title_so`, `description_en`, `description_so`, `icon`, `order_column`, `status`, `created_at`, `updated_at`) VALUES (7,'organization','3. Perform Impact Assessments (DPIA)',NULL,'Before launching new systems, products, or technologies processing high-risk personal data, organizations must conduct and submit a DPIA report.',NULL,'FaClipboardList',3,'active','2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `audience_items` (`id`, `type`, `title_en`, `title_so`, `description_en`, `description_so`, `icon`, `order_column`, `status`, `created_at`, `updated_at`) VALUES (8,'organization','4. Report Breaches in 72 Hours',NULL,'If your database experiences a leak or hack affecting personal data, you must notify the SDPA within 72 hours of becoming aware of the incident.',NULL,'FaBullhorn',4,'active','2026-07-22 12:00:00','2026-07-22 12:00:00');

-- 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_07_19_135549_create_personal_access_tokens_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (5,'2026_07_19_135911_create_services_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (6,'2026_07_19_135913_create_service_info_cards_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (7,'2026_07_19_135914_create_service_resources_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (8,'2026_07_19_135915_create_news_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (9,'2026_07_19_135916_create_contacts_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (10,'2026_07_19_135917_create_faqs_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (11,'2026_07_19_135918_create_guidances_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (12,'2026_07_20_165135_create_roles_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (13,'2026_07_20_165136_create_permissions_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (14,'2026_07_20_165137_create_role_user_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (15,'2026_07_20_165138_create_permission_role_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (16,'2026_07_20_165139_create_posts_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (17,'2026_07_20_165140_create_advisory_requests_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (18,'2026_07_20_165140_create_breach_reports_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (19,'2026_07_20_165141_create_audit_logs_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (20,'2026_07_20_165142_create_media_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (21,'2026_07_20_165143_create_settings_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (22,'2026_07_21_000001_create_pages_table',2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (23,'2026_07_21_000002_create_team_members_table',2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (24,'2026_07_21_000003_create_departments_table',2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (25,'2026_07_21_000004_create_announcements_table',2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (26,'2026_07_21_095901_alter_team_members_image_nullable',3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (27,'2026_07_21_100001_add_hero_image_url_to_services_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (28,'2026_07_21_134351_alter_news_image_nullable',5);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (29,'2026_07_21_134707_alter_news_date_nullable',6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (30,'2026_07_21_134929_fix_news_nullable_columns',7);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (31,'2026_07_21_160000_create_audience_items_table',8);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (32,'2026_07_22_062136_add_status_and_order_to_services_table',9);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (33,'2026_07_22_000001_make_pages_content_nullable',10);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (34,'2026_07_22_000002_restore_pages_content_not_null',11);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (35,'2026_07_22_120000_add_status_and_file_path_to_guidances_table',12);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (36,'2026_07_22_140000_add_file_path_to_service_resources_table',13);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (37,'2026_07_22_150000_add_user_id_to_news_table',14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (38,'2026_07_22_140000_enhance_contacts_table',15);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (39,'2026_07_22_153700_add_password_display_to_users_table',16);

