-- =============================================================================
-- 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`;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
DROP TABLE IF EXISTS `advisory_requests`;
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;
DROP TABLE IF EXISTS `announcements`;
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;
DROP TABLE IF EXISTS `audience_items`;
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;
DROP TABLE IF EXISTS `audit_logs`;
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;
DROP TABLE IF EXISTS `breach_reports`;
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;
DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `contacts`;
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;
DROP TABLE IF EXISTS `departments`;
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;
DROP TABLE IF EXISTS `failed_jobs`;
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;
DROP TABLE IF EXISTS `faqs`;
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;
DROP TABLE IF EXISTS `guidances`;
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;
DROP TABLE IF EXISTS `job_batches`;
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;
DROP TABLE IF EXISTS `jobs`;
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;
DROP TABLE IF EXISTS `media`;
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;
DROP TABLE IF EXISTS `migrations`;
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;
DROP TABLE IF EXISTS `news`;
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;
DROP TABLE IF EXISTS `pages`;
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;
DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `permission_role`;
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;
DROP TABLE IF EXISTS `permissions`;
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;
DROP TABLE IF EXISTS `personal_access_tokens`;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` text NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`),
  KEY `personal_access_tokens_expires_at_index` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `posts`;
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;
DROP TABLE IF EXISTS `role_user`;
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;
DROP TABLE IF EXISTS `roles`;
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;
DROP TABLE IF EXISTS `service_info_cards`;
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;
DROP TABLE IF EXISTS `service_resources`;
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;
DROP TABLE IF EXISTS `services`;
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;
DROP TABLE IF EXISTS `sessions`;
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;
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'string',
  `group` varchar(255) NOT NULL DEFAULT 'general',
  `label` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `team_members`;
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;
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `password_display` text DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) 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);

-- users
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `password_display`, `remember_token`, `created_at`, `updated_at`) VALUES (1,'Admin User','admin@dpa.gov.so',NULL,'$2y$12$gYd1JTjC81CMV3EH7Qz57uThwcMLSpHG.y4VjLoC07c5sSBoXZHxu',NULL,NULL,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `password_display`, `remember_token`, `created_at`, `updated_at`) VALUES (2,'Post Author','post@dpa.gov.so',NULL,'$2y$12$gYd1JTjC81CMV3EH7Qz57uThwcMLSpHG.y4VjLoC07c5sSBoXZHxu',NULL,NULL,'2026-07-22 12:00:00','2026-07-22 12:00:00');

-- 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);

-- settings
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (1,'site_name','Somalia Data Protection Authority','string','general','Site Name','The official name of the organization.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (2,'site_tagline','Protecting Personal Data in Somalia','string','general','Site Tagline','Short tagline displayed on the website.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (3,'site_description','The Somalia Data Protection Authority (SDPA) is the national authority responsible for regulating and overseeing the processing of personal data in Somalia.','string','general','Site Description','Full description of the organization.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (4,'timezone','Africa/Mogadishu','string','general','Timezone','Server timezone for date/time display.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (5,'language','en','string','general','Language','Default display language (en or so).',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (6,'working_hours','Sun-Thu: 8:00 AM - 4:00 PM','string','general','Working Hours','Office working hours.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (7,'site_logo','/logo.png','string','branding','Logo URL','Path or URL to the site logo.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (8,'site_favicon','/favicon.ico','string','branding','Favicon URL','Path or URL to the favicon.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (9,'default_og_image','/og-image.png','string','branding','Default Website Image','Default image for social sharing and previews.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (10,'government_seal','','string','branding','Government Seal','Path or URL to the government seal image (optional).',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (11,'contact_address','Mogadishu, Somalia','string','contact','Office Address','Physical address of the office.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (12,'contact_email','info@dpa.gov.so','string','contact','Email','Primary contact email address.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (13,'contact_phone','+252 61 555 0000','string','contact','Phone','Primary phone number.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (14,'contact_map_url','','string','contact','Google Map URL','Google Maps embed URL for the office location.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (15,'meta_title','Somalia Data Protection Authority - SDPA','string','seo','Meta Title','Default HTML meta title.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (16,'meta_description','The official website of the Somalia Data Protection Authority (SDPA). Learn about data protection laws, your rights, and how to report breaches.','string','seo','Meta Description','Default HTML meta description.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (17,'og_image','/og-image.png','string','seo','Open Graph Image','Open Graph image for social sharing.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (18,'seo_robots','index, follow','string','seo','Robots','Robots meta tag content (e.g. index, follow).',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (19,'sitemap_url','https://dpa.gov.so/sitemap.xml','string','seo','Sitemap URL','URL path to the XML sitemap.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (20,'facebook_url','https://facebook.com/dpa.gov.so','string','social','Facebook URL','Facebook page URL.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (21,'twitter_url','https://twitter.com/dpa_gov_so','string','social','Twitter URL','Twitter/X profile URL.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (22,'linkedin_url','https://linkedin.com/company/dpa-so','string','social','LinkedIn URL','LinkedIn page URL.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (23,'youtube_url','','string','social','YouTube URL','YouTube channel URL.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (24,'hero_title','Protecting Your Personal Data in Somalia','string','home','Hero Title','Main headline on the home page.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (25,'hero_subtitle','The Somalia Data Protection Authority ensures your personal information is handled responsibly, transparently, and in accordance with the law.','string','home','Hero Subtitle','Subtitle text below the hero headline.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (26,'hero_cta_text','Learn About Your Rights','string','home','Hero CTA Text','Call-to-action button text.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (27,'hero_cta_link','/audience/individuals','string','home','Hero CTA Link','Call-to-action button URL.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (28,'hero_image','','string','home','Hero Image','Path or URL to the homepage hero background image.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (29,'stat_est_year','2019','string','home','Established Year','Year the authority was established (shown in stats).',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (30,'stat_total_services','5','integer','home','Total Services','Number of services offered (shown in stats).',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (31,'stat_coverage','100%','string','home','Coverage Stat','Coverage percentage (shown in stats).',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (32,'stat_response_time','48h','string','home','Response Time','Average response time (shown in stats).',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (33,'director_name','Hon. Abdirashid Mohamed Ali','string','home','Director Name','Name of the Director General.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (34,'director_title','Director General','string','home','Director Title','Title/position of the Director.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (35,'director_image','/director.jpg','string','home','Director Photo','Path or URL to the director photo.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (36,'director_quote','Our mission is to protect the fundamental right to data privacy for every individual in Somalia.','string','home','Director Quote','Short quote displayed on the home page.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (37,'mandate_1_title','Regulate Data Processing','string','home','Mandate 1 Title','Title of the first mandate.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (38,'mandate_1_desc','Ensure all organizations process personal data lawfully, fairly, and transparently.','string','home','Mandate 1 Description','Description of the first mandate.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (39,'mandate_2_title','Enforce Data Rights','string','home','Mandate 2 Title','Title of the second mandate.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (40,'mandate_2_desc','Protect individuals’ rights over their personal data, including access, correction, and deletion.','string','home','Mandate 2 Description','Description of the second mandate.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (41,'mandate_3_title','Investigate Breaches','string','home','Mandate 3 Title','Title of the third mandate.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (42,'mandate_3_desc','Investigate and respond to data breaches and privacy complaints from the public.','string','home','Mandate 3 Description','Description of the third mandate.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (43,'about_history','The Somalia Data Protection Authority (SDPA) was established in 2019 under the Somalia Data Protection Act to regulate the processing of personal data and protect the privacy rights of individuals in Somalia.','string','about','About History','History text for the About page.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (44,'about_vision','A Somalia where every individual’s personal data is protected and processed responsibly.','string','about','Vision','The organization’s vision statement.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (45,'about_mission','To regulate and oversee the processing of personal data, enforce data protection laws, and promote a culture of privacy across Somalia.','string','about','Mission','The organization’s mission statement.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (46,'privacy_policy','','text','legal','Privacy Policy','Full HTML content of the Privacy Policy page.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (47,'terms_of_service','','text','legal','Terms of Service','Full HTML content of the Terms of Service page.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (48,'cookie_policy','','text','legal','Cookie Policy','Full HTML content of the Cookie Policy page.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (49,'accessibility_statement','','text','legal','Accessibility Statement','Full HTML content of the Accessibility Statement.',1,'2026-07-22 12:00:00','2026-07-22 12:00:00');
INSERT INTO `settings` (`id`, `key`, `value`, `type`, `group`, `label`, `description`, `is_public`, `created_at`, `updated_at`) VALUES (50,'maintenance_mode','false','boolean','system','Maintenance Mode','Enable maintenance mode to show a holding page to visitors.',0,'2026-07-22 12:00:00','2026-07-22 12:00:00');

-- 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);

SET FOREIGN_KEY_CHECKS=1;