-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `reddnres_dev`
--

-- --------------------------------------------------------

--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint UNSIGNED NOT NULL,
  `log_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject_id` bigint UNSIGNED DEFAULT NULL,
  `event` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `causer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `causer_id` bigint UNSIGNED DEFAULT NULL,
  `attribute_changes` json DEFAULT NULL,
  `properties` json DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activity_log`
--

INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `subject_id`, `event`, `causer_type`, `causer_id`, `attribute_changes`, `properties`, `url`, `ip_address`, `user_agent`, `created_at`, `updated_at`) VALUES
(3, 'Backend User Seeder', 'Backend user seeded successfully', 'App\\Models\\Backend\\BackendUser', 1, 'seeded', 'App\\Models\\Backend\\BackendUser', 1, '{\"old\": {\"email\": \"superadmin@example.com\", \"username\": \"superadmin\", \"is_active\": true, \"last_name\": \"Admin\", \"first_name\": \"Super\", \"last_login_at\": \"2026-05-19T22:06:48.399397Z\"}, \"attributes\": {\"email\": \"superadmin@example.com\", \"username\": \"superadmin\", \"is_active\": true, \"last_name\": \"Admin\", \"first_name\": \"Super\", \"last_login_at\": \"2026-05-19T22:06:48.399406Z\"}}', '[]', 'http://localhost', '127.0.0.1', 'Symfony', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(4, 'Backend User Seeder', 'Frontend user seeded successfully', 'App\\Models\\Backend\\FrontendUser', 1, 'seeded', 'App\\Models\\Backend\\FrontendUser', 1, '{\"old\": {\"email\": \"frontenduser@example.com\", \"username\": \"frontenduser\", \"is_active\": true, \"last_name\": \"User\", \"first_name\": \"Frontend\", \"last_login_at\": \"2026-05-19T22:06:48.628388Z\"}, \"attributes\": {\"email\": \"frontenduser@example.com\", \"username\": \"frontenduser\", \"is_active\": true, \"last_name\": \"User\", \"first_name\": \"Frontend\", \"last_login_at\": \"2026-05-19T22:06:48.628393Z\"}}', '[]', 'http://localhost', '127.0.0.1', 'Symfony', '2026-05-19 22:06:48', '2026-05-19 22:06:48');

-- --------------------------------------------------------

--
-- Table structure for table `backend_menu`
--

CREATE TABLE `backend_menu` (
  `menu_id` bigint UNSIGNED NOT NULL,
  `menu_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_param` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_class` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_active_route` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_parent_id` int NOT NULL DEFAULT '0',
  `menu_status` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `backend_menu`
--

INSERT INTO `backend_menu` (`menu_id`, `menu_name`, `menu_param`, `menu_class`, `menu_link`, `menu_active_route`, `menu_parent_id`, `menu_status`, `created_at`, `updated_at`) VALUES
(1, 'Backend', NULL, 'menu-icon-backend', '#', '[\"backend-user.index\",\"backend-user.create\",\"backend-user.edit\",\"roles.index\",\"roles.create\",\"roles.edit\",\"permissions.index\",\"permissions.create\",\"permissions.edit\",\"auto-permissions.index\",\"admin.routes.index\",\"admin.routes.create\",\"admin.routes.edit\",\"backend-menu.index\",\"backend-menu.create\",\"backend-menu.edit\",\"backend-menu.assign\",\"ref.index\",\"ref.create\",\"ref.edit\",\"activity-log.index\",\"visitor.index\"]', 0, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(2, 'User', NULL, NULL, 'backend-user.index', '[\"backend-user.index\",\"backend-user.create\",\"backend-user.edit\"]', 1, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(3, 'Parameters', NULL, NULL, 'ref.index', '[\"ref.index\",\"ref.create\",\"ref.edit\"]', 1, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(4, 'Roles & Permissions', NULL, NULL, '#', '[\"roles.index\",\"roles.create\",\"roles.edit\",\"permissions.index\",\"permissions.create\",\"permissions.edit\",\"auto-permissions.index\"]', 1, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(5, 'Roles', NULL, NULL, 'roles.index', '[\"roles.index\",\"roles.create\",\"roles.edit\"]', 4, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(6, 'Permissions', NULL, NULL, 'permissions.index', '[\"permissions.index\",\"permissions.create\",\"permissions.edit\"]', 4, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(7, 'Auto Permissions', NULL, NULL, 'auto-permissions.index', '[\"auto-permissions.index\"]', 4, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(8, 'Routes', NULL, NULL, 'admin.routes.index', '[\"admin.routes.index\",\"admin.routes.create\",\"admin.routes.edit\"]', 1, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(9, 'Menu', NULL, NULL, 'backend-menu.index', '[\"backend-menu.index\",\"backend-menu.create\",\"backend-menu.edit\"]', 1, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(10, 'Assign Menu', NULL, NULL, 'backend-menu.assign', '[\"backend-menu.assign\"]', 1, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(11, 'Activity Log', NULL, NULL, 'activity-log.index', '[\"activity-log.index\"]', 1, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(12, 'Visitor', NULL, NULL, 'visitor.index', '[\"visitor.index\"]', 1, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(13, 'Frontend', NULL, 'menu-icon-frontend', '#', '[\"frontend-user.index\",\"frontend-user.create\",\"frontend-user.edit\",\"file-manager.index\",\"frontend-menu.index\",\"frontend-menu.create\",\"frontend-menu.edit\",\"frontend-menu.assign\",\"menu-category.index\",\"menu-category.create\",\"menu-category.edit\"]', 0, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(14, 'User', NULL, NULL, 'frontend-user.index', '[\"frontend-user.index\",\"frontend-user.create\",\"frontend-user.edit\"]', 13, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(15, 'File Manager', NULL, NULL, 'file-manager.index', '[\"file-manager.index\"]', 13, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(16, 'Menu', NULL, NULL, 'frontend-menu.index', '[\"frontend-menu.index\",\"frontend-menu.create\",\"frontend-menu.edit\"]', 13, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(17, 'Assign Menu', NULL, NULL, 'frontend-menu.assign', '[\"frontend-menu.assign\"]', 13, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(18, 'Content', NULL, 'menu-icon-content', '#', '[\"content-article.index\",\"content-article.create\",\"content-article.edit\",\"content-application.index\",\"content-application.create\",\"content-application.edit\",\"content-download.index\",\"content-download.create\",\"content-download.edit\",\"content-photo-gallery.index\",\"content-photo-gallery.create\",\"content-photo-gallery.edit\",\"content-slider.index\",\"content-slider.create\",\"content-slider.edit\",\"content-image.index\",\"content-image.create\",\"content-image.edit\",\"content-video.index\",\"content-video.create\",\"content-video.edit\"]', 0, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(19, 'Articles', NULL, NULL, 'content-article.index', '[\"content-article.index\",\"content-article.create\",\"content-article.edit\"]', 18, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(20, 'Links', NULL, NULL, 'content-application.index', '[\"content-application.index\",\"content-application.create\",\"content-application.edit\"]', 18, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(21, 'Documents', NULL, NULL, 'content-download.index', '[\"content-download.index\",\"content-download.create\",\"content-download.edit\"]', 18, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(22, 'Photo Galleries', NULL, NULL, 'content-photo-gallery.index', '[\"content-photo-gallery.index\",\"content-photo-gallery.create\",\"content-photo-gallery.edit\"]', 18, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(23, 'Slider Images', NULL, NULL, 'content-slider.index', '[\"content-slider.index\",\"content-slider.create\",\"content-slider.edit\"]', 18, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(24, 'Images', NULL, NULL, 'content-image.index', '[\"content-image.index\",\"content-image.create\",\"content-image.edit\"]', 18, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(25, 'Videos', NULL, NULL, 'content-video.index', '[\"content-video.index\",\"content-video.create\",\"content-video.edit\"]', 18, 1, '2026-05-19 22:06:49', '2026-05-19 22:06:49');

-- --------------------------------------------------------

--
-- Table structure for table `backend_role_mapping`
--

CREATE TABLE `backend_role_mapping` (
  `id` bigint UNSIGNED NOT NULL,
  `role_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_id` bigint UNSIGNED NOT NULL,
  `parent_id` int NOT NULL DEFAULT '0',
  `sort` int NOT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `backend_role_mapping`
--

INSERT INTO `backend_role_mapping` (`id`, `role_code`, `menu_id`, `parent_id`, `sort`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES
(1, 'super-admin', 1, 0, 1, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(2, 'super-admin', 2, 1, 2, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(3, 'super-admin', 3, 1, 3, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(4, 'super-admin', 4, 1, 4, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(5, 'super-admin', 5, 4, 5, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(6, 'super-admin', 6, 4, 6, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(7, 'super-admin', 7, 4, 7, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(8, 'super-admin', 8, 1, 8, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(9, 'super-admin', 9, 1, 9, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(10, 'super-admin', 10, 1, 10, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(11, 'super-admin', 11, 1, 11, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(12, 'super-admin', 12, 1, 12, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(13, 'super-admin', 13, 0, 13, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(14, 'super-admin', 14, 13, 14, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(15, 'super-admin', 15, 13, 15, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(16, 'super-admin', 16, 13, 16, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(17, 'super-admin', 17, 13, 17, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(18, 'super-admin', 18, 0, 18, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(19, 'super-admin', 19, 18, 19, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(20, 'super-admin', 20, 18, 20, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(21, 'super-admin', 21, 18, 21, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(22, 'super-admin', 22, 18, 22, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(23, 'super-admin', 23, 18, 23, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(24, 'super-admin', 24, 18, 24, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49'),
(25, 'super-admin', 25, 18, 25, 'seeder', '2026-05-20 06:06:49', 'seeder', '2026-05-19 22:06:49');

-- --------------------------------------------------------

--
-- Table structure for table `content_applications`
--

CREATE TABLE `content_applications` (
  `application_id` int UNSIGNED NOT NULL,
  `application_cat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `application_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `application_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `application_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `application_sort` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_applications`
--

INSERT INTO `content_applications` (`application_id`, `application_cat`, `application_status`, `application_url`, `application_img`, `application_sort`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(1, NULL, 'ACTIVE', 'https://unfccc.int/', NULL, 1, '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(2, NULL, 'ACTIVE', 'https://www.un-redd.org/', NULL, 2, '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(3, NULL, 'ACTIVE', 'https://mtcc.com.my/', NULL, 3, '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(4, NULL, 'ACTIVE', 'https://www.forestry.gov.my/en/', NULL, 4, '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(5, NULL, 'ACTIVE', 'https://forestry.sarawak.gov.my/', NULL, 5, '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(6, NULL, 'ACTIVE', 'http://www.forest.sabah.gov.my/', NULL, 6, '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(7, NULL, 'ACTIVE', 'https://www.frim.gov.my/', NULL, 7, '2026-05-20 06:56:13', 1, '2026-05-20 06:56:40', 1),
(8, 'FOOTER_ABOUT', 'ACTIVE', '/what-is-redd-plus', NULL, 1, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(9, 'FOOTER_ABOUT', 'ACTIVE', '/redd-plus-malaysia', NULL, 2, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(10, 'FOOTER_ABOUT', 'ACTIVE', '/stakeholders', NULL, 3, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(11, 'FOOTER_ABOUT', 'ACTIVE', '/redd-plus-governance', NULL, 4, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(12, 'FOOTER_POLICY', 'ACTIVE', '/strategy', NULL, 1, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(13, 'FOOTER_POLICY', 'ACTIVE', '/mrv-framework', NULL, 2, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(14, 'FOOTER_POLICY', 'ACTIVE', '/redd-plus-finance-framework', NULL, 3, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(15, 'FOOTER_POLICY', 'ACTIVE', '/safeguard-information-system', NULL, 4, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(16, 'FOOTER_LIBRARY', 'ACTIVE', '/publications', NULL, 1, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(17, 'FOOTER_LIBRARY', 'ACTIVE', '/gallery', NULL, 2, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(18, 'FOOTER_LIBRARY', 'ACTIVE', '/sitemap', NULL, 3, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(19, 'FOOTER_LIBRARY', 'ACTIVE', '/enquiries', NULL, 4, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(20, 'FOOTER_LIBRARY', 'ACTIVE', '/feedback', NULL, 5, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(21, 'FOOTER_LINK', 'ACTIVE', 'https://unfccc.int/', NULL, 1, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(22, 'FOOTER_LINK', 'ACTIVE', 'https://www.un-redd.org/', NULL, 2, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(23, 'FOOTER_LINK', 'ACTIVE', 'https://mtcc.com.my/', NULL, 3, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(24, 'FOOTER_LINK', 'ACTIVE', 'https://www.forestry.gov.my/en/', NULL, 4, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(25, 'FOOTER_LINK', 'ACTIVE', 'https://forestry.sarawak.gov.my/', NULL, 5, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(26, 'FOOTER_LINK', 'ACTIVE', 'http://www.forest.sabah.gov.my/', NULL, 6, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(27, 'FOOTER_LINK', 'ACTIVE', 'https://www.frim.gov.my/', NULL, 7, '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1);

-- --------------------------------------------------------

--
-- Table structure for table `content_application_translations`
--

CREATE TABLE `content_application_translations` (
  `application_translation_id` int UNSIGNED NOT NULL,
  `application_translation_parent_id` int DEFAULT NULL,
  `application_translation_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `application_translation_main` int DEFAULT NULL,
  `application_translation_language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_application_translations`
--

INSERT INTO `content_application_translations` (`application_translation_id`, `application_translation_parent_id`, `application_translation_title`, `application_translation_main`, `application_translation_language`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(1, 1, 'UNFCCC', 1, 'EN', '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(2, 2, 'UN REDD', 1, 'EN', '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(3, 3, 'Malaysian Timber Certification Council', 1, 'EN', '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(4, 4, 'Forestry Department Peninsular Malaysia', 1, 'EN', '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(5, 5, 'Forestry Department Sarawak', 1, 'EN', '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(6, 6, 'Sabah Forestry Department', 1, 'EN', '2026-05-20 06:56:13', 1, '2026-05-20 06:56:13', 1),
(9, 7, 'Forest Research Institute Malaysia (FRIM)', 1, 'EN', '2026-05-20 06:56:40', 1, '2026-05-20 06:56:40', 1),
(10, 8, 'What is REDD Plus?', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(11, 9, 'REDD Plus Malaysia', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(12, 10, 'REDD Plus and Stakeholder Engagement', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(13, 11, 'REDD Plus Governance', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(14, 12, 'National REDD Plus Strategy', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(15, 13, 'MRV Framework', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(16, 14, 'REDD Plus Finance Framework (RFF)', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(17, 15, 'Safeguards Information System (SIS)', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(18, 16, 'Publications', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(19, 17, 'Gallery', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(20, 18, 'Sitemap', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(21, 19, 'General Enquiries', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(22, 20, 'Feedback/Complaint', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(23, 21, 'UNFCCC', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(24, 22, 'UN REDD', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(25, 23, 'Malaysian Timber Certification Council', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(26, 24, 'Forestry Department Peninsular Malaysia', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(27, 25, 'Forestry Department Sarawak', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(28, 26, 'Sabah Forestry Department', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1),
(29, 27, 'Forest Research Institute Malaysia (FRIM)', 1, 'EN', '2026-05-20 06:57:57', 1, '2026-05-20 06:57:57', 1);

-- --------------------------------------------------------

--
-- Table structure for table `content_article`
--

CREATE TABLE `content_article` (
  `article_id` bigint UNSIGNED NOT NULL,
  `article_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_date` date DEFAULT NULL,
  `article_category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_subcategory` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_sorting` int NOT NULL DEFAULT '0',
  `article_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_portal_category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_start_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_start_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_end_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `article_end_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_set` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_article`
--

INSERT INTO `content_article` (`article_id`, `article_code`, `article_date`, `article_category`, `article_subcategory`, `article_status`, `article_url`, `article_sorting`, `article_image`, `article_portal_category`, `article_start_date`, `article_start_time`, `article_end_date`, `article_end_time`, `menu_set`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 'home-about', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 1, 'content-article/home-about_20260520.jpg', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:45:34', '2026-05-19 22:45:34', NULL, NULL),
(2, 'home-objectives', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 2, 'content-article/home-objectives_20260520.png', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:45:34', '2026-05-19 22:45:34', NULL, NULL),
(3, 'what-is-redd-plus', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:54', '2026-05-19 22:48:54', NULL, NULL),
(4, 'strategy', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:54', '2026-05-19 22:48:54', NULL, NULL),
(5, 'stakeholders', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:54', '2026-05-19 22:48:54', NULL, NULL),
(6, 'redd-plus-malaysia', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:54', '2026-05-19 22:48:54', NULL, NULL),
(7, 'national-forest-monitoring-system', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:54', '2026-05-19 22:48:54', NULL, NULL),
(8, 'redd-plus-governance', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:54', '2026-05-19 22:48:54', NULL, NULL),
(9, 'forest-reference-level', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:54', '2026-05-19 22:48:54', NULL, NULL),
(10, 'safeguard-information-system', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(11, 'mrv-framework', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(12, 'malaysia-forest-fund', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(13, 'redd-plus-finance-framework', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(14, 'news', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(15, 'enquiries', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(16, 'disclaimer', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(17, 'privacy-policy', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(18, 'security-policy', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(19, 'web-policy', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL),
(20, 'sitemap', '2026-05-20', 'ARTICLE', NULL, 'ACTIVE', NULL, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:48:55', '2026-05-19 22:48:55', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `content_article_translation`
--

CREATE TABLE `content_article_translation` (
  `article_translation_id` bigint UNSIGNED NOT NULL,
  `article_translation_parent_id` int DEFAULT NULL,
  `article_translation_title` text COLLATE utf8mb4_unicode_ci,
  `article_translation_content` longtext COLLATE utf8mb4_unicode_ci,
  `article_translation_main` int DEFAULT NULL,
  `article_translation_language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_article_translation`
--

INSERT INTO `content_article_translation` (`article_translation_id`, `article_translation_parent_id`, `article_translation_title`, `article_translation_content`, `article_translation_main`, `article_translation_language`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(1, 1, 'Forests are the backbone of a healthy and sustainable natural environment.', '<p>They absorb carbon dioxide and produce oxygen, support biodiverse wildlife, regulate our water supply and provide a home for indigenous communities and cultures.</p><p>To protect our forests, however, we need strong frameworks and mechanisms that can unite diverse actors behind a common goal and maximise the effect of conservation efforts. This is where REDD Plus comes in.</p>', 1, 'EN', '2026-05-19 22:45:34', '2026-05-19 22:45:34', 1, 1),
(2, 2, 'Objectives of REDD Plus Malaysia', '<h2 class=\"green-text\">Objectives of REDD Plus Malaysia</h2><ol type=\"I\"><li>To promote consistency and synergies in the implementation of climate change, forest and biodiversity related policies between federal and state levels;</li><li>To measure, report and verify (MRV) REDD Plus results and as part of efforts to achieve the Nationally Determined Contribution (NDC); and</li><li>To develop a sustainable financing mechanism for REDD Plus implementation.</li></ol><h2 class=\"green-text\">REDD Plus Actions</h2><p>By implementing the National REDD Plus Strategy, Malaysia will contribute to the following national targets:</p><ul><li>Maintaining 50% forest cover;</li><li>Achieving the NDC pledge made under the UNFCCC&rsquo;s Paris Agreement for the period between 2020-2030;</li><li>Achieving National Policy on Biological Diversity (2016-2025); and</li><li>Forest policies.</li></ul>', 1, 'EN', '2026-05-19 22:45:34', '2026-05-19 22:45:34', 1, 1),
(3, 2, 'Objektif REDD Plus Malaysia', '<h2 class=\"green-text\">Objektif REDD Plus Malaysia</h2><ol type=\"I\"><li>Untuk menggalakkan konsistensi dan sinergi dalam pelaksanaan dasar perubahan iklim, hutan dan biodiversiti antara peringkat persekutuan dan negeri;</li><li>Untuk mengukur, melaporkan dan mengesahkan (MRV) hasil REDD Plus dan sebagai sebahagian daripada usaha untuk mencapai Sumbangan Ditentukan Nasional (NDC); dan</li><li>Untuk membangunkan mekanisme pembiayaan mampan untuk pelaksanaan REDD Plus.</li></ol><h2 class=\"green-text\">Tindakan REDD Plus</h2><p>Dengan melaksanakan Strategi REDD Plus Kebangsaan, Malaysia akan menyumbang kepada sasaran negara berikut:</p><ul><li>Mengekalkan 50% litupan hutan;</li><li>Mencapai ikrar NDC di bawah Perjanjian Paris UNFCCC untuk tempoh antara 2020-2030;</li><li>Mencapai Dasar Biokepelbagaian Kebangsaan (2016-2025); dan</li><li>Dasar hutan.</li></ul>', 0, 'BM', '2026-05-19 22:45:34', '2026-05-19 22:45:34', 1, 1),
(4, 3, 'What is REDD Plus? - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>WHAT IS REDD PLUS?</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / About / What is REDD Plus?</p></div></section><section class=\"content-section\"><div class=\"container\"><div class=\"highlight-box\"><p><strong>REDD+</strong> &mdash; <strong>R</strong>educing <strong>E</strong>missions from <strong>D</strong>eforestation and <strong>D</strong>eforestation <strong>+</strong> the role of conservation, sustainable management of forest and enhancement of forest carbon stocks in developing countries.</p></div><div class=\"about-grid\" style=\"margin-bottom:30px\"><div><h2>What is REDD Plus?</h2><p>Globally, deforestation and forest degradation account for 11 per cent of greenhouse gas (GHG) emissions</p></div><div><img src=\"/reddnres/src/img/GRM-pic.jpg\" alt=\"REDD Plus\" style=\"width:100%;border-radius:6px\"></div></div>, more than the entire global transportation sector and second only to the energy sector.</p><p>In response, Parties to the United Nations Framework Convention on Climate Change (UNFCCC), which Malaysia is one, have developed a climate change mitigation approach designed to incentivise developing countries to reduce carbon emissions from deforestation and forest degradation.</p><p>REDD Plus aims to incentivize developing countries to reduce emissions from deforestation and forest degradation, conserve forest carbon stocks, sustainably manage forests and enhance forest carbon stocks.</p><ul><li>Reducing carbon emissions from deforestation</li><li>Reducing carbon emissions from forest degradation</li><li>Conservation of forest carbon stocks</li><li>Sustainable management of forests</li><li>Enhancement of forest and carbon stocks</li></ul><h2>How does REDD Plus benefit Malaysia?</h2><p>Developing countries that meet UNFCCC REDD Plus requirements, including Malaysia, will receive results-based payments (RBPs) for verified emissions reductions.</p><p>By implementing REDD Plus actions, countries will contribute to conserving their national biodiversity and to the global fight against climate change.</p><h2>Why is REDD Plus important?</h2><p>Deforestation and forest degradation have long been recognized as significant sources of carbon emissions.</p><h2>What are the phases of REDD Plus?</h2><div class=\"phases-grid\"><div class=\"phase-card\"><h3>Phase 1: Readiness</h3><p>Countries design national strategies and action plans.</p></div><div class=\"phase-card\"><h3>Phase 2: Demonstration</h3><p>National strategies are demonstrated and tested.</p></div><div class=\"phase-card\"><h3>Phase 3: Implementation</h3><p>Results-based actions are implemented at the national level.</p></div></div><h2>What is the Plus in REDD?</h2><p>REDD Plus (or REDD-plus) refers to reducing emissions from deforestation and forest degradation, and the role of conservation, sustainable management of forests, and enhancement of forest carbon stocks.</p><p><em>Sources: UN REDD</em></p></div></section>', 1, 'EN', '2026-05-19 22:48:54', '2026-05-19 22:48:54', 1, 1),
(5, 4, 'Malaysia REDD Plus Strategy - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>NATIONAL REDD PLUS STRATEGY</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Elements / Malaysia REDD Plus Strategy</p></div></section><section class=\"content-section\"><div class=\"container\"><div style=\"text-align:center;margin-bottom:24px\"><img src=\"/reddnres/src/img/redd-plus-element-1.png\" alt=\"REDD Plus Strategy\" style=\"max-width:400px;border-radius:6px\"></div><p>The National REDD Plus Strategy (NRS) builds upon existing relevant policies.</p><h2>Main Objectives</h2><ul><li>To promote consistency and synergies in climate change policies</li><li>To measure, report and verify (MRV) REDD Plus results</li><li>To develop a sustainable financing mechanism</li></ul><h2>REDD Plus Actions</h2><ul><li>Maintaining 50% forest cover</li><li>Achieving the NDC pledge under the Paris Agreement</li><li>Achieving National Policy on Biological Diversity</li></ul><h2>Addressing</h2><ul><li>Identifying drivers of deforestation</li><li>Enhancing transparency of MRV system</li><li>Developing sustainable financing system</li></ul><h2>Eligible Activities</h2><ul><li>Reducing emissions from deforestation</li><li>Reducing emissions from forest degradation</li><li>Conservation of forest carbon stocks</li><li>Enhancement of forest carbon stocks</li><li>Sustainable management of forests</li></ul></div></section>', 1, 'EN', '2026-05-19 22:48:54', '2026-05-19 22:48:54', 1, 1),
(6, 5, 'REDD Plus and Stakeholders Engagement - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>REDD PLUS AND STAKEHOLDER ENGAGEMENT</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / About / Stakeholders</p></div></section><section class=\"content-section\"><div class=\"container\"><div class=\"about-grid\" style=\"margin-bottom:30px\"><div><h2>REDD Plus and Stakeholder Engagement</h2><p>Full and effective stakeholder engagement is indispensable to REDD Plus.</p></div><div><img src=\"/reddnres/src/img/resources.jpg\" alt=\"Stakeholders\" style=\"width:100%;border-radius:6px\"></div></div><p>UNFCCC decisions have consistently called for Parties to ensure the full and effective participation of relevant stakeholders.</p><h2>Stakeholder Engagement in Malaysia</h2><p>To contribute toward Malaysia pledge to maintain at least 50% forest cover, a detailed framework has been put in place.</p><h2>The role of stakeholders</h2><p>The land administration structure in Malaysia demarcates the power to manage land to the State Authority.</p></div></section>', 1, 'EN', '2026-05-19 22:48:54', '2026-05-19 22:48:54', 1, 1),
(7, 6, 'REDD Plus Malaysia - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>REDD PLUS MALAYSIA</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / About / REDD Plus Malaysia</p></div></section><section class=\"content-section\"><div class=\"container\"><div class=\"about-grid\" style=\"margin-bottom:30px\"><div><h2>UNFCCC and REDD Plus</h2><p>In 1992, countries adopted the United Nations Framework Convention on Climate Change (UNFCCC)</p></div><div><img src=\"/reddnres/src/img/about-eligible-activities.jpg\" alt=\"Eligible Activities\" style=\"width:100%;border-radius:6px\"></div></div><div class=\"timeline\"><div class=\"timeline-item\"><div class=\"timeline-year\">1972</div><div class=\"timeline-desc\">Malaysia NFI established</div></div><div class=\"timeline-item\"><div class=\"timeline-year\">1992</div><div class=\"timeline-desc\">Malaysia pledges 50% forest cover</div></div><div class=\"timeline-item\"><div class=\"timeline-year\">2007</div><div class=\"timeline-desc\">REDD mechanism adopted</div></div><div class=\"timeline-item\"><div class=\"timeline-year\">2011</div><div class=\"timeline-desc\">REDD Plus Malaysia established</div></div><div class=\"timeline-item\"><div class=\"timeline-year\">2014</div><div class=\"timeline-desc\">First FRL submitted</div></div><div class=\"timeline-item\"><div class=\"timeline-year\">2016</div><div class=\"timeline-desc\">Safeguards Summary submitted</div></div><div class=\"timeline-item\"><div class=\"timeline-year\">2017</div><div class=\"timeline-desc\">National Strategy published</div></div><div class=\"timeline-item\"><div class=\"timeline-year\">2020</div><div class=\"timeline-desc\">RFF endorsed by Cabinet</div></div><div class=\"timeline-item\"><div class=\"timeline-year\">2021</div><div class=\"timeline-desc\">SIS operational, MFF set up</div></div></div><h2>REDD Plus Malaysia</h2><p>Malaysia has so far achieved: National REDD Plus Strategy, NFRL, NFMS, and MY-SIS.</p><h2>Warsaw Framework on REDD Plus</h2><p>Seven important decisions adopted during COP 19, jointly known as the Warsaw Framework.</p><h2>Paris Agreement</h2><p>All efforts link REDD Plus back to Article 5 of the Paris Agreement.</p></div></section>', 1, 'EN', '2026-05-19 22:48:54', '2026-05-19 22:48:54', 1, 1),
(8, 7, 'National Forest Monitoring System - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>NATIONAL FOREST MONITORING SYSTEM (NFMS)</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Elements / MRV Framework / NFMS</p></div></section><section class=\"content-section\"><div class=\"container\"><div class=\"about-grid\" style=\"margin-bottom:30px\"><div><h2>What is NFMS?</h2><p>A National Forest Monitoring System (NFMS) is the key component in the management of information for national REDD+ programs.</p></div><div><img src=\"/reddnres/src/img/NFSM.jpg\" alt=\"NFMS\" style=\"width:100%;border-radius:6px\"></div></div><p>Malaysia NFMS was established in 1972 and has been updated every 10 years since.</p><h2>NFMS Practice in Malaysia</h2><p>The NFMS consists of two components:</p><ul><li><strong>Short term</strong> &ndash; geospatial images assessment</li><li><strong>Long term monitoring</strong> &ndash; national forest inventory</li></ul></div></section>', 1, 'EN', '2026-05-19 22:48:54', '2026-05-19 22:48:54', 1, 1),
(9, 8, 'REDD Plus Governance - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>REDD PLUS GOVERNANCE</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / About / REDD Plus Governance</p></div></section><section class=\"content-section\"><div class=\"container\"><div class=\"about-grid\" style=\"margin-bottom:30px\"><div><h2>Forest Governance</h2><p>Under the Federal Constitution, land matters are under the jurisdiction of the respective state governments.</p></div><div><img src=\"/reddnres/src/img/governance-structure-new.png\" alt=\"Governance Structure\" style=\"width:100%;border-radius:6px\"></div></div><h2>Malaysia Sustainable Forest Management</h2><p>Malaysian forests have been assessed by both FSC and MTCS.</p><h2>REDD Plus Governance Structure</h2><p>Ministry of NRES, through its REDD Plus Unit (URP) leads and coordinates REDD Plus.</p><h3>National Steering Committee</h3><p>The NSC provides key guidance and monitors implementation.</p><h3>National Technical Committee</h3><p>The NTC supports the NSC, providing methodological guidance.</p></div></section>', 1, 'EN', '2026-05-19 22:48:54', '2026-05-19 22:48:54', 1, 1),
(10, 9, 'Forest Reference Level (FRL) - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>FOREST REFERENCE LEVEL (FRL)</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Elements / FRL</p></div></section><section class=\"content-section\"><div class=\"container\"><div class=\"about-grid\" style=\"margin-bottom:30px\"><div><h2>What is FREL/FRL?</h2><p>A FREL/FRL is a benchmark for assessing REDD+ performance.</p></div><div><img src=\"/reddnres/src/img/MyREDDPlus-1-942x1024.jpg\" alt=\"REDD Plus\" style=\"width:100%;border-radius:6px\"></div></div><p><strong>FREL</strong> is a benchmark for activities that reduce emissions only.</p><p><strong>FRL</strong> is a benchmark for both activities that reduce emissions and increase removals.</p><h2>Malaysia Forest Reference Level</h2><p>Malaysia current FRL addresses annual biomass loss through annual removal.</p></div></section>', 1, 'EN', '2026-05-19 22:48:54', '2026-05-19 22:48:54', 1, 1),
(11, 10, 'Safeguards Information System - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>SAFEGUARDS INFORMATION SYSTEM (SIS)</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Elements / SIS</p></div></section><section class=\"content-section\"><div class=\"container\"><h2>The Seven Cancun Safeguards</h2><ol><li>Actions complement national forest programmes</li><li>Transparent forest governance structures</li><li>Respect for indigenous peoples rights</li><li>Full stakeholder participation</li><li>Conservation of natural forests and biodiversity</li><li>Address risks of reversals</li><li>Reduce displacement of emissions</li></ol><p>Malaysia has submitted its first Report on Summary of Information in 2016.</p></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(12, 11, 'MRV Framework - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>MEASUREMENT, REPORTING & VERIFICATION (MRV) FRAMEWORK</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Elements / MRV Framework</p></div></section><section class=\"content-section\"><div class=\"container\"><p>Decision 2/CP.15 requests countries to develop national forest monitoring systems that support MRV.</p><ul><li>Measuring impact in terms of reducing emissions</li><li>Monitoring with the aid of the NFMS</li><li>Reporting results to the UNFCCC</li><li>Applying a domestic verification process</li></ul><h2>MRV Institution Functions</h2><p><strong>Measurement:</strong> FRIM, Forestry Department</p><p><strong>Monitoring:</strong> Remote Sensing Department</p><p><strong>Reporting:</strong> NRES, FRIM</p><p><strong>Verification:</strong> MTCC, LULUCF Experts</p></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(13, 12, 'Malaysia Forest Fund - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>MALAYSIA FOREST FUND (MFF)</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Initiatives / MFF</p></div></section><section class=\"content-section\"><div class=\"container\"><p>The Malaysia Forest Fund (MFF) was established on 30 June 2021 to implement the REDD Plus Finance Framework (RFF).</p><p>MFF main role is to generate funding for the forestry sector through the transaction of carbon credits.</p></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(14, 13, 'REDD Plus Finance Framework - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>REDD PLUS FINANCE FRAMEWORK (RFF)</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Initiatives / RFF</p></div></section><section class=\"content-section\"><div class=\"container\"><h2>What is the RFF?</h2><p>The REDD Plus Finance Framework (RFF) was developed as a finance mechanism to incentivize activities that help keep forests standing.</p><h2>How Does the RFF Work?</h2><p><strong>Forest Carbon Offset (FCO):</strong> Market-based approach for carbon credits.</p><p><strong>Forest Conservation Certificate (FCC):</strong> Non market-based for non-carbon benefits.</p><h2>Registration and Benefit Distribution</h2><p>A registry ensures no double counting or double financing occurs.</p></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(15, 14, 'REDD Plus News - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>REDD PLUS NEWS</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / News</p></div></section><section class=\"content-section\"><div class=\"container\"><h2>REDD Plus News</h2><p>Coming Soon. Browse the latest news on REDD Plus implementation, projects and results in Malaysia.</p></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(16, 15, 'General Enquiries - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>GENERAL ENQUIRIES</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Contact Us / Enquiries</p></div></section><section class=\"content-section\"><div class=\"container\"><h2>General Enquiries</h2><div class=\"contact-info\"><h3>Ministry of Natural Resources and Environmental Sustainability (NRES)</h3><p>Block F11, Kompleks F, Lebuh Perdana Timur, Presint 1, 62000 Putrajaya, Malaysia.</p><p>Tel: +603 8091 7000 | Fax: +603 8889 2672</p><h3>The Ministry of Energy and Natural Resources (KeTSA)</h3><p>Wisma Sumber Asli, No. 25, Persiaran Perdana, Presint 4, 62574 Putrajaya, Malaysia</p><p>Tel: +603 8000 8000</p><p>Website: <a href=\"http://redd.ketsa.gov.my/\" target=\"_blank\">redd.ketsa.gov.my</a></p></div></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(17, 16, 'Disclaimer - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>DISCLAIMER</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Disclaimer</p></div></section><section class=\"content-section\"><div class=\"container\"><p>The information provided on this website is for general informational purposes only.</p></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(18, 17, 'Privacy Policy - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>PRIVACY POLICY</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Privacy Policy</p></div></section><section class=\"content-section\"><div class=\"container\"><p>This privacy policy sets out how we use and protect any information that you give us.</p></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(19, 18, 'Security Policy - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>SECURITY POLICY</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Security Policy</p></div></section><section class=\"content-section\"><div class=\"container\"><p>We are committed to ensuring that your information is secure.</p></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(20, 19, 'Web Policy - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>WEB POLICY</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Web Policy</p></div></section><section class=\"content-section\"><div class=\"container\"><p>This website is maintained by the Ministry of Natural Resources and Environmental Sustainability.</p></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1),
(21, 20, 'Sitemap - REDD PLUS', '<section class=\"page-header\"><div class=\"container\"><h1>SITEMAP</h1><p class=\"breadcrumb\"><a href=\"/\">Home</a> / Sitemap</p></div></section><section class=\"content-section\"><div class=\"container\"><ul><li><a href=\"/\">Home</a></li><li><a href=\"/what-is-redd-plus\">What is REDD Plus?</a></li><li><a href=\"/redd-plus-malaysia\">REDD Plus Malaysia</a></li><li><a href=\"/stakeholders\">Stakeholders</a></li><li><a href=\"/redd-plus-governance\">Governance</a></li><li><a href=\"/strategy\">Strategy</a></li><li><a href=\"/forest-reference-level\">FRL</a></li><li><a href=\"/mrv-framework\">MRV Framework</a></li><li><a href=\"/national-forest-monitoring-system\">NFMS</a></li><li><a href=\"/safeguard-information-system\">SIS</a></li><li><a href=\"/malaysia-forest-fund\">MFF</a></li><li><a href=\"/redd-plus-finance-framework\">RFF</a></li><li><a href=\"/publications\">Publications</a></li><li><a href=\"/news\">News</a></li><li><a href=\"/gallery\">Gallery</a></li><li><a href=\"/enquiries\">Enquiries</a></li><li><a href=\"/feedback\">Feedback</a></li></ul></div></section>', 1, 'EN', '2026-05-19 22:48:55', '2026-05-19 22:48:55', 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `content_downloads`
--

CREATE TABLE `content_downloads` (
  `download_id` bigint UNSIGNED NOT NULL,
  `download_main` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_parent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_date` date DEFAULT NULL,
  `download_source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_start_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_start_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_end_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_end_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `content_images`
--

CREATE TABLE `content_images` (
  `image_id` int UNSIGNED NOT NULL,
  `image_cat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_sort` int DEFAULT NULL,
  `image_main` int DEFAULT NULL,
  `image_parent_id` int DEFAULT NULL,
  `image_language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `content_photo_gallery`
--

CREATE TABLE `content_photo_gallery` (
  `gallery_id` int UNSIGNED NOT NULL,
  `gallery_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gallery_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gallery_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gallery_portal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gallery_thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gallery_cat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gallery_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gallery_sort` int NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `content_photo_gallery_translations`
--

CREATE TABLE `content_photo_gallery_translations` (
  `gallery_translation_id` bigint UNSIGNED NOT NULL,
  `gallery_translation_parent_id` int UNSIGNED NOT NULL,
  `gallery_translation_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gallery_translation_descr` text COLLATE utf8mb4_unicode_ci,
  `gallery_translation_main` tinyint(1) NOT NULL DEFAULT '0',
  `gallery_translation_language` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint UNSIGNED DEFAULT NULL,
  `updated_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `content_photo_list`
--

CREATE TABLE `content_photo_list` (
  `photo_id` int UNSIGNED NOT NULL,
  `photo_gallery_id` int DEFAULT NULL,
  `photo_main` int DEFAULT NULL,
  `photo_parent_id` int DEFAULT NULL,
  `photo_language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo_sort` int DEFAULT NULL,
  `photo_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo_descr` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `content_slider`
--

CREATE TABLE `content_slider` (
  `slider_id` int UNSIGNED NOT NULL,
  `slider_portal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_sort` int DEFAULT NULL,
  `slider_url_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_url_upload` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_dimension` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_transition` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_start_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_start_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_end_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_end_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_slider`
--

INSERT INTO `content_slider` (`slider_id`, `slider_portal`, `slider_status`, `slider_sort`, `slider_url_type`, `slider_url`, `slider_url_upload`, `slider_type`, `slider_dimension`, `slider_transition`, `slider_start_date`, `slider_start_time`, `slider_end_date`, `slider_end_time`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(1, NULL, 'ACTIVE', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-20 06:40:25', '1', '2026-05-20 06:40:25', '1'),
(2, NULL, 'ACTIVE', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-20 06:40:55', '1', '2026-05-20 06:41:02', '1'),
(3, NULL, 'ACTIVE', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-20 06:41:51', '1', '2026-05-20 06:41:51', '1'),
(4, NULL, 'ACTIVE', 1, 'INTERNAL', '/redd-plus-malaysia', NULL, 'background', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-20 06:45:34', '1', '2026-05-20 06:45:34', '1'),
(5, NULL, 'ACTIVE', 2, 'INTERNAL', '/redd-plus-finance-framework', NULL, 'background', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-20 06:45:34', '1', '2026-05-20 06:45:34', '1'),
(6, NULL, 'ACTIVE', 3, 'INTERNAL', '/strategy', NULL, 'background', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-20 06:45:34', '1', '2026-05-20 06:45:34', '1'),
(7, NULL, 'ACTIVE', 4, 'INTERNAL', '/strategy', NULL, 'background', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-20 06:45:34', '1', '2026-05-20 06:45:34', '1');

-- --------------------------------------------------------

--
-- Table structure for table `content_slider_translation`
--

CREATE TABLE `content_slider_translation` (
  `slider_translation_id` int UNSIGNED NOT NULL,
  `slider_translation_parent_id` int DEFAULT NULL,
  `slider_translation_title` text COLLATE utf8mb4_unicode_ci,
  `slider_translation_img` text COLLATE utf8mb4_unicode_ci,
  `slider_translation_main` int DEFAULT NULL,
  `slider_translation_language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_slider_translation`
--

INSERT INTO `content_slider_translation` (`slider_translation_id`, `slider_translation_parent_id`, `slider_translation_title`, `slider_translation_img`, `slider_translation_main`, `slider_translation_language`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(1, 1, 'Forests', 'content-slider/DSC_0488_20260520_64a8a.jpg', 1, 'BM', '2026-05-20 06:40:25', 1, '2026-05-20 06:40:25', 1),
(3, 2, 'Environment', 'content-slider/DSC_0435_20260520_5c5a0.jpg', 1, 'BM', '2026-05-20 06:41:02', 1, '2026-05-20 06:41:02', 1),
(4, 3, 'Activities', 'content-slider/about-eligible-activities_20260520_3384d.jpg', 1, 'BM', '2026-05-20 06:42:35', 1, '2026-05-20 06:42:35', 1),
(5, 4, 'SUSTAINING OUR FORESTS FOR FUTURE GENERATIONS', 'content-slider/banner3_20260520_slide1.jpg', 1, 'EN', '2026-05-20 06:45:34', 1, '2026-05-20 06:45:34', 1),
(6, 5, 'MAKE A LASTING ENVIRONMENTAL CONTRIBUTION', 'content-slider/2014_20260520_slide2.jpg', 1, 'EN', '2026-05-20 06:45:34', 1, '2026-05-20 06:45:34', 1),
(7, 6, 'WORKING TOGETHER FOR A GREENER FUTURE', 'content-slider/2007_20260520_slide3.jpg', 1, 'EN', '2026-05-20 06:45:34', 1, '2026-05-20 06:45:34', 1),
(8, 7, 'WORKING TOGETHER FOR A GREENER FUTURE', 'content-slider/myredd_20260520_slide4.jpg', 1, 'EN', '2026-05-20 06:45:34', 1, '2026-05-20 06:45:34', 1);

-- --------------------------------------------------------

--
-- Table structure for table `content_video`
--

CREATE TABLE `content_video` (
  `video_id` int NOT NULL,
  `video_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_date` date DEFAULT NULL,
  `video_source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_upload` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_external` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_sorting` int DEFAULT NULL,
  `meta_title` text COLLATE utf8mb4_unicode_ci,
  `meta_descr` text COLLATE utf8mb4_unicode_ci,
  `meta_keyword` text COLLATE utf8mb4_unicode_ci,
  `meta_author` text COLLATE utf8mb4_unicode_ci,
  `meta_img` text COLLATE utf8mb4_unicode_ci,
  `publish_date_start` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_time_start` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_date_end` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_time_end` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `content_video_translation`
--

CREATE TABLE `content_video_translation` (
  `video_translation_id` int NOT NULL,
  `video_translation_parent_id` int DEFAULT NULL,
  `video_translation_title` text COLLATE utf8mb4_unicode_ci,
  `video_translation_content` text COLLATE utf8mb4_unicode_ci,
  `video_translation_location` text COLLATE utf8mb4_unicode_ci,
  `video_translation_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_translation_main` int DEFAULT NULL,
  `video_translation_language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `frontend_menu`
--

CREATE TABLE `frontend_menu` (
  `menu_id` bigint UNSIGNED NOT NULL,
  `menu_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_status` tinyint(1) NOT NULL DEFAULT '1',
  `menu_class` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_field_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_descr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu_parent_id` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `frontend_menu_category`
--

CREATE TABLE `frontend_menu_category` (
  `category_id` bigint UNSIGNED NOT NULL,
  `category_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` date DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `frontend_role_mapping`
--

CREATE TABLE `frontend_role_mapping` (
  `id` bigint UNSIGNED NOT NULL,
  `role_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_set` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_id` bigint UNSIGNED NOT NULL,
  `parent_id` int NOT NULL DEFAULT '0',
  `sort` int DEFAULT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `page_id` int NOT NULL DEFAULT '0',
  `site_id` int NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `category` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_04_14_210645_create_backend_users_table', 1),
(5, '2026_04_22_220206_create_activity_log_table', 1),
(6, '2026_04_23_000000_create_frontend_users_table', 1),
(7, '2026_04_24_210705_create_permission_tables', 1),
(8, '2026_04_25_000001_create_backend_menu_table', 1),
(9, '2026_04_25_000002_create_backend_role_mapping_table', 1),
(10, '2026_04_25_000003_create_frontend_menu_table', 1),
(11, '2026_04_25_000004_create_frontend_role_mapping_table', 1),
(12, '2026_04_25_000005_create_frontend_menu_category_table', 1),
(13, '2026_05_11_104607_create_ref_table', 1),
(14, '2026_05_11_130658_create_content_applications_table', 1),
(15, '2026_05_11_130803_create_content_application_translations_table', 1),
(16, '2026_05_13_142707_create_content_article_table', 1),
(17, '2026_05_13_142708_create_content_article_translation_table', 1),
(18, '2026_05_14_112409_create_content_downloads_table', 1),
(19, '2026_05_14_172227_create_content_slider_table', 1),
(20, '2026_05_14_172233_create_content_slider_translation_table', 1),
(21, '2026_05_14_225313_create_content_images_table', 1),
(22, '2026_05_15_011242_create_content_video_table', 1),
(23, '2026_05_15_011337_create_content_video_translation_table', 1),
(24, '2026_05_16_172751_create_content_photo_gallery_table', 1),
(25, '2026_05_16_172752_create_content_photo_gallery_translations_table', 1),
(26, '2026_05_16_172753_create_content_photo_list_table', 1),
(27, '2026_05_17_000001_create_routes_table', 1),
(28, '2026_05_18_190730_create_visits_table', 1),
(29, '2026_05_18_194337_create_visitor_settings_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\Backend\\BackendUser', 1);

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'backend-user.view', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(2, 'backend-user.create', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(3, 'backend-user.update', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(4, 'backend-user.delete', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(5, 'backend-menu.view', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(6, 'backend-menu.create', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(7, 'backend-menu.update', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(8, 'backend-menu.delete', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(9, 'backend-menu.roledelete', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(10, 'backend-menu.assign', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(11, 'backend-menu.level', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(12, 'backend-menu.disabled', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(13, 'activity-log.view', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(14, 'auto-permission.view', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(15, 'auto-permission.create', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(16, 'ref.view', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(17, 'ref.create', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(18, 'ref.update', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(19, 'ref.delete', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(20, 'role.view', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(21, 'role.create', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(22, 'role.update', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(23, 'role.delete', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(24, 'permission.view', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(25, 'permission.create', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(26, 'permission.update', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(27, 'permission.delete', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(28, 'frontend-user.view', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(29, 'frontend-user.create', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(30, 'frontend-user.update', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(31, 'frontend-user.delete', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(32, 'frontend-menu.view', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(33, 'frontend-menu.create', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(34, 'frontend-menu.update', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(35, 'frontend-menu.delete', 'admin', '2026-05-19 22:01:23', '2026-05-19 22:01:23'),
(37, 'frontend-menu.roledelete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(38, 'frontend-menu.assign', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(39, 'frontend-menu.level', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(40, 'frontend-menu.disabled', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(41, 'frontend-menu.article-item', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(42, 'frontend-menu.slider-item', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(43, 'menu-category.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(44, 'menu-category.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(45, 'menu-category.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(46, 'menu-category.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(47, 'file.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(48, 'route.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(49, 'route.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(50, 'route.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(51, 'route.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(52, 'content-article.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(53, 'content-article.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(54, 'content-article.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(55, 'content-article.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(56, 'content-application.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(57, 'content-application.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(58, 'content-application.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(59, 'content-application.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(60, 'content-download.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(61, 'content-download.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(62, 'content-download.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(63, 'content-download.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(64, 'content-photo-gallery.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(65, 'content-photo-gallery.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(66, 'content-photo-gallery.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(67, 'content-photo-gallery.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(68, 'content-photo-list.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(69, 'content-photo-list.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(70, 'content-photo-list.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(71, 'content-photo-list.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(72, 'content-slider.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(73, 'content-slider.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(74, 'content-slider.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(75, 'content-slider.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(76, 'content-image.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(77, 'content-image.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(78, 'content-image.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(79, 'content-image.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(80, 'content-video.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(81, 'content-video.create', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(82, 'content-video.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(83, 'content-video.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(84, 'visitor.view', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(85, 'visitor.update', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48'),
(86, 'visitor.delete', 'admin', '2026-05-19 22:06:48', '2026-05-19 22:06:48');

-- --------------------------------------------------------

--
-- Table structure for table `ref`
--

CREATE TABLE `ref` (
  `id` bigint UNSIGNED NOT NULL,
  `cat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `descr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `descr_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int DEFAULT NULL,
  `parent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ref`
--

INSERT INTO `ref` (`id`, `cat`, `code`, `descr`, `descr_en`, `sort`, `parent`, `icon_name`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'LANGUAGE', 'BM', 'Bahasa Melayu', 'Malay', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(2, 'LANGUAGE', 'EN', 'English', 'English', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(3, 'PORTAL', 'MAIN', 'Portal Utama', 'Main Portal', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(4, 'PORTAL', 'NEWS', 'Portal Berita', 'News Portal', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(5, 'PORTAL', 'EVENTS', 'Portal Program', 'Events Portal', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(6, 'VIDEO_CAT', 'PROMO', 'Promosi', 'Promotional', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(7, 'VIDEO_CAT', 'TUTORIAL', 'Tutorial', 'Tutorial', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(8, 'VIDEO_CAT', 'NEWS', 'Berita', 'News', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(9, 'VIDEO_CAT', 'EVENT', 'Program', 'Event', 4, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(10, 'VIDEO_CAT', 'DOCUMENTARY', 'Dokumentari', 'Documentary', 5, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(11, 'VIDEO_STATUS', 'ACTIVE', 'Aktif', 'Active', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(12, 'VIDEO_STATUS', 'INACTIVE', 'Tidak Aktif', 'Inactive', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(13, 'VIDEO_STATUS', 'ARCHIVE', 'Arkib', 'Archive', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(14, 'SLIDER_STATUS', 'ACTIVE', 'Aktif', 'Active', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(15, 'SLIDER_STATUS', 'INACTIVE', 'Tidak Aktif', 'Inactive', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(16, 'SLIDER_STATUS', 'ARCHIVE', 'Arkib', 'Archive', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(17, 'SLIDER_TYPE', 'HERO', 'Hero Slider', 'Hero Slider', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(18, 'SLIDER_TYPE', 'FEATURED', ' ciri', 'Featured', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(19, 'SLIDER_TYPE', 'CAROUSEL', 'Carousel', 'Carousel', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(20, 'SLIDER_TYPE', 'BANNER', 'Banner', 'Banner', 4, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(21, 'SLIDER_DIMENSION', '1920X1080', 'Full HD (1920x1080)', 'Full HD (1920x1080)', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(22, 'SLIDER_DIMENSION', '1280X720', 'HD (1280x720)', 'HD (1280x720)', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(23, 'SLIDER_DIMENSION', '1600X600', 'Wide (1600x600)', 'Wide (1600x600)', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(24, 'SLIDER_DIMENSION', '800X600', 'Standard (800x600)', 'Standard (800x600)', 4, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(25, 'SLIDER_URL_TYPE', 'INTERNAL', 'Pautan Dalaman', 'Internal Link', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(26, 'SLIDER_URL_TYPE', 'EXTERNAL', 'Pautan Luaran', 'External Link', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(27, 'SLIDER_URL_TYPE', 'FILE', 'Muat Turun Fail', 'File Download', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(28, 'SLIDER_URL_TYPE', 'NONE', 'Tiada Pautan', 'No Link', 4, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(29, 'PHOTO_STATUS', 'ACTIVE', 'Aktif', 'Active', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(30, 'PHOTO_STATUS', 'INACTIVE', 'Tidak Aktif', 'Inactive', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(31, 'PHOTO_STATUS', 'ARCHIVE', 'Arkib', 'Archive', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(32, 'GALLERY_CAT', 'EVENT', 'Program', 'Event', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(33, 'GALLERY_CAT', 'ACTIVITY', 'Aktiviti', 'Activity', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(34, 'GALLERY_CAT', 'FACILITY', 'Fasiliti', 'Facility', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(35, 'GALLERY_CAT', 'STAFF', 'Kakitangan', 'Staff', 4, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(36, 'GALLERY_CAT', 'OTHER', 'Lain-lain', 'Other', 5, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(37, 'GALLERY_STATUS', 'ACTIVE', 'Aktif', 'Active', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(38, 'GALLERY_STATUS', 'INACTIVE', 'Tidak Aktif', 'Inactive', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(39, 'GALLERY_STATUS', 'ARCHIVE', 'Arkib', 'Archive', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(40, 'IMAGE_CAT', 'BANNER', 'Banner', 'Banner', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(41, 'IMAGE_CAT', 'ICON', 'Ikon', 'Icon', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(42, 'IMAGE_CAT', 'LOGO', 'Logo', 'Logo', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(43, 'IMAGE_CAT', 'BACKGROUND', 'Latar Belakang', 'Background', 4, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(44, 'IMAGE_CAT', 'THUMBNAIL', 'Thumbnail', 'Thumbnail', 5, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(45, 'IMAGE_CAT', 'OTHER', 'Lain-lain', 'Other', 6, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(46, 'IMAGE_STATUS', 'ACTIVE', 'Aktif', 'Active', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(47, 'IMAGE_STATUS', 'INACTIVE', 'Tidak Aktif', 'Inactive', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(48, 'IMAGE_STATUS', 'ARCHIVE', 'Arkib', 'Archive', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(49, 'DOWNLOAD_CAT', 'FORM', 'Borang', 'Form', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(50, 'DOWNLOAD_CAT', 'GUIDE', 'Panduan', 'Guide', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(51, 'DOWNLOAD_CAT', 'REPORT', 'Laporan', 'Report', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(52, 'DOWNLOAD_CAT', 'POLICY', 'Dasar', 'Policy', 4, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(53, 'DOWNLOAD_CAT', 'MANUAL', 'Manual', 'Manual', 5, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(54, 'DOWNLOAD_CAT', 'OTHER', 'Lain-lain', 'Other', 6, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(55, 'DOWNLOAD_STATUS', 'ACTIVE', 'Aktif', 'Active', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(56, 'DOWNLOAD_STATUS', 'INACTIVE', 'Tidak Aktif', 'Inactive', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(57, 'DOWNLOAD_STATUS', 'ARCHIVE', 'Arkib', 'Archive', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(58, 'ARTICLE_CAT', 'NEWS', 'Berita', 'News', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(59, 'ARTICLE_CAT', 'ANNOUNCEMENT', 'Pengumuman', 'Announcement', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(60, 'ARTICLE_CAT', 'ARTICLE', 'Artikel', 'Article', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(61, 'ARTICLE_CAT', 'BLOG', 'Blog', 'Blog', 4, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(62, 'ARTICLE_CAT', 'PRESS', 'Siaran Akhbar', 'Press Release', 5, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(63, 'ARTICLE_SUBCAT', 'GENERAL', 'Umum', 'General', 1, 'NEWS', NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(64, 'ARTICLE_SUBCAT', 'SPORTS', 'Sukan', 'Sports', 2, 'NEWS', NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(65, 'ARTICLE_SUBCAT', 'TECHNOLOGY', 'Teknologi', 'Technology', 3, 'NEWS', NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(66, 'ARTICLE_SUBCAT', 'BUSINESS', 'Perniagaan', 'Business', 4, 'NEWS', NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(67, 'ARTICLE_SUBCAT', 'OPINION', 'Pendapat', 'Opinion', 5, 'ARTICLE', NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(68, 'ARTICLE_SUBCAT', 'FEATURE', 'Ciri', 'Feature', 6, 'ARTICLE', NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(69, 'ARTICLE_STATUS', 'ACTIVE', 'Aktif', 'Active', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(70, 'ARTICLE_STATUS', 'INACTIVE', 'Tidak Aktif', 'Inactive', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(71, 'ARTICLE_STATUS', 'ARCHIVE', 'Arkib', 'Archive', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(72, 'APPLICATION_CAT', 'REGISTRATION', 'Pendaftaran', 'Registration', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(73, 'APPLICATION_CAT', 'REQUEST', 'Permintaan', 'Request', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(74, 'APPLICATION_CAT', 'FEEDBACK', 'Maklum Balas', 'Feedback', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(75, 'APPLICATION_CAT', 'COMPLAINT', 'Aduan', 'Complaint', 4, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(76, 'APPLICATION_CAT', 'ENQUIRY', 'Pertanyaan', 'Enquiry', 5, NULL, NULL, NULL, NULL, '2026-05-19 22:06:49', '2026-05-19 22:06:49', NULL),
(77, 'APPLICATION_STATUS', 'ACTIVE', 'Aktif', 'Active', 1, NULL, NULL, NULL, NULL, '2026-05-19 22:06:50', '2026-05-19 22:06:50', NULL),
(78, 'APPLICATION_STATUS', 'INACTIVE', 'Tidak Aktif', 'Inactive', 2, NULL, NULL, NULL, NULL, '2026-05-19 22:06:50', '2026-05-19 22:06:50', NULL),
(79, 'APPLICATION_STATUS', 'ARCHIVE', 'Arkib', 'Archive', 3, NULL, NULL, NULL, NULL, '2026-05-19 22:06:50', '2026-05-19 22:06:50', NULL),
(80, 'APPLICATION_CAT', 'FOOTER_ABOUT', 'About', 'About', 10, NULL, NULL, NULL, NULL, '2026-05-19 22:57:57', '2026-05-19 22:57:57', NULL),
(81, 'APPLICATION_CAT', 'FOOTER_POLICY', 'Dasar, Strategi & Pelan Tindakan', 'Policies, Strategy & Action Plans', 11, NULL, NULL, NULL, NULL, '2026-05-19 22:57:57', '2026-05-19 22:57:57', NULL),
(82, 'APPLICATION_CAT', 'FOOTER_LIBRARY', 'Perpustakaan', 'Library', 12, NULL, NULL, NULL, NULL, '2026-05-19 22:57:57', '2026-05-19 22:57:57', NULL),
(83, 'APPLICATION_CAT', 'FOOTER_LINK', 'Pautan Berkaitan', 'Related Link', 13, NULL, NULL, NULL, NULL, '2026-05-19 22:57:57', '2026-05-19 22:57:57', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'super-admin', 'admin', '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(2, 'editor', 'admin', '2026-05-19 22:06:49', '2026-05-19 22:06:49'),
(3, 'viewer', 'admin', '2026-05-19 22:06:49', '2026-05-19 22:06:49');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(51, 1),
(52, 1),
(53, 1),
(54, 1),
(55, 1),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1),
(61, 1),
(62, 1),
(63, 1),
(64, 1),
(65, 1),
(66, 1),
(67, 1),
(68, 1),
(69, 1),
(70, 1),
(71, 1),
(72, 1),
(73, 1),
(74, 1),
(75, 1),
(76, 1),
(77, 1),
(78, 1),
(79, 1),
(80, 1),
(81, 1),
(82, 1),
(83, 1),
(84, 1),
(85, 1),
(86, 1),
(1, 2),
(2, 2),
(3, 2),
(13, 2),
(1, 3),
(13, 3);

-- --------------------------------------------------------

--
-- Table structure for table `routes`
--

CREATE TABLE `routes` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uri` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `middleware` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'web',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `alias` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('fE88uuwsSrVqY6Y65h06tGp71Dggpmncw0Ht1Jjw', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJJVFRMeE0yTXAzU3VBdWVMSHVwa1N4NlJMS2EybktTcW9icEtBZ3YwIiwiZmxhc2hlcjo6ZW52ZWxvcGVzIjpbXSwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAwXC9hZG1pblwvY29udGVudC1hcHBsaWNhdGlvbj9wYWdlPTMiLCJyb3V0ZSI6ImNvbnRlbnQtYXBwbGljYXRpb24uaW5kZXgifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJ2aXNpdF8yMDI2LTA1LTIwXzEyNyI6W1t7IjEiOnRydWV9XV0sImxvZ2luX2FkbWluXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9', 1779231506),
('HfSTEZOFUT5vZ8yIXjhLTTKdbw1KLDBd7MrHHqIl', NULL, NULL, '', 'eyJfdG9rZW4iOiJCNTN2SXc5bmpVaFg1ajk3am9tdnFIWWRtME4xYTBuVTdUb1RkVjd3IiwidmlzaXRfMjAyNi0wNS0yMF8iOnRydWUsImZsYXNoZXI6OmVudmVsb3BlcyI6W10sIl9wcmV2aW91cyI6eyJ1cmwiOiJodHRwOlwvXC86Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1779229742),
('n5BwbgJYGm7yPujMTamjcbcQ1YVCTshGgR1NflEN', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJSSVFwNUV1anNiSXdwVlRsY0JhRFdkU3RSTU5qY1Y1a3VyaGpETWRtIiwidmlzaXRfMjAyNi0wNS0yMF8xMjciOltbeyIxIjp0cnVlfV1dLCJmbGFzaGVyOjplbnZlbG9wZXMiOltdLCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjgwMDBcL2FkbWluXC9sb2dpbiIsInJvdXRlIjoiYWRtaW4ubG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1779230188);

-- --------------------------------------------------------

--
-- Table structure for table `visitor_settings`
--

CREATE TABLE `visitor_settings` (
  `id` bigint UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `visitor_settings`
--

INSERT INTO `visitor_settings` (`id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `visits`
--

CREATE TABLE `visits` (
  `id` bigint UNSIGNED NOT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request` mediumtext COLLATE utf8mb4_unicode_ci,
  `url` mediumtext COLLATE utf8mb4_unicode_ci,
  `referer` mediumtext COLLATE utf8mb4_unicode_ci,
  `languages` text COLLATE utf8mb4_unicode_ci,
  `useragent` text COLLATE utf8mb4_unicode_ci,
  `headers` text COLLATE utf8mb4_unicode_ci,
  `device` text COLLATE utf8mb4_unicode_ci,
  `platform` text COLLATE utf8mb4_unicode_ci,
  `browser` text COLLATE utf8mb4_unicode_ci,
  `ip` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `geo_raw` json DEFAULT NULL COMMENT 'Optional GeoIP payload',
  `visitable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visitable_id` bigint UNSIGNED DEFAULT NULL,
  `visitor_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visitor_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `visits`
--

INSERT INTO `visits` (`id`, `method`, `request`, `url`, `referer`, `languages`, `useragent`, `headers`, `device`, `platform`, `browser`, `ip`, `geo_raw`, `visitable_type`, `visitable_id`, `visitor_type`, `visitor_id`, `created_at`, `updated_at`) VALUES
(1, 'GET', '[]', 'http://:', NULL, '[]', '', '[]', 'Desktop', 'Unknown', 'Unknown', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:29:01', '2026-05-19 22:29:01'),
(2, 'GET', '[]', 'http://127.0.0.1:8000', NULL, '[\"en_US\",\"en\"]', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', '{\"host\":[\"127.0.0.1:8000\"],\"connection\":[\"keep-alive\"],\"cache-control\":[\"max-age=0\"],\"sec-ch-ua\":[\"\\\"Chromium\\\";v=\\\"148\\\", \\\"Brave\\\";v=\\\"148\\\", \\\"Not\\/A)Brand\\\";v=\\\"99\\\"\"],\"sec-ch-ua-mobile\":[\"?0\"],\"sec-ch-ua-platform\":[\"\\\"Windows\\\"\"],\"upgrade-insecure-requests\":[\"1\"],\"user-agent\":[\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/148.0.0.0 Safari\\/537.36\"],\"accept\":[\"text\\/html,application\\/xhtml+xml,application\\/xml;q=0.9,image\\/avif,image\\/webp,image\\/apng,*\\/*;q=0.8\"],\"sec-gpc\":[\"1\"],\"accept-language\":[\"en-US,en;q=0.7\"],\"sec-fetch-site\":[\"none\"],\"sec-fetch-mode\":[\"navigate\"],\"sec-fetch-user\":[\"?1\"],\"sec-fetch-dest\":[\"document\"],\"accept-encoding\":[\"gzip, deflate, br, zstd\"],\"cookie\":[\"XSRF-TOKEN=eyJpdiI6InVGMFphMHpYKzZpRDdzYWsvVGgyUFE9PSIsInZhbHVlIjoieDFCcm5ia3ZIY1VLL0UvQ0tHQ1lsSGIxNEM4Q2ZxMEZmVkhiWXNxMDVCNWxLb1ZSRllNOU0rbkhYUWx4VkxOcUZsVW1ZY3ZldlFnRDB6S3h4TFYrV3NCaURWdE5oakgwMmE0Wlp0M21BdUw4ZXMrdGNzSFZOS3VGMkNXWGxTdU8iLCJtYWMiOiJlMTQ5MGNjODM1ZGMwOWU4ZWNiYWIwNjZjYzhhMTVkZDJkYTM4MDFiNTE4MWRkOWE5MTIwNzMwZjJiMWY0YTYxIiwidGFnIjoiIn0%3D; laravel-session=eyJpdiI6IkhWcEVBVGtxNkhuTVFXZitXaUxPSnc9PSIsInZhbHVlIjoiT3Ixa2Q1Wko0M0pSaVBIQXRjM016R0xyVGFpSEx5eGIzY1ZySVZWNjl0V1M0ZGxzVkZtMlhJKy96ZWE0ZW5HVUdtemxkZkZuWW9hRU5PK1FieE1HRC93ckEvL0FCZXBJVFV5T1M0M0J1V08rNE9WbHZWMmNqVlhPeGw5Qm5jNEIiLCJtYWMiOiJjMTAyNjE1NDljZDU1ZTk1MzJiODAxMjc0ZGI2OGQ2ZDViMDRlNmU1OTU2OTc1ZTUzNTEyOTExN2FjZmI4MTMwIiwidGFnIjoiIn0%3D\"]}', 'Desktop', 'Windows', 'Chrome', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:29:30', '2026-05-19 22:29:30'),
(3, 'GET', '[]', 'http://127.0.0.1:8000/admin', NULL, '[\"en_US\",\"en\"]', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', '{\"host\":[\"127.0.0.1:8000\"],\"connection\":[\"keep-alive\"],\"sec-ch-ua\":[\"\\\"Chromium\\\";v=\\\"148\\\", \\\"Google Chrome\\\";v=\\\"148\\\", \\\"Not\\/A)Brand\\\";v=\\\"99\\\"\"],\"sec-ch-ua-mobile\":[\"?0\"],\"sec-ch-ua-platform\":[\"\\\"Windows\\\"\"],\"upgrade-insecure-requests\":[\"1\"],\"user-agent\":[\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/148.0.0.0 Safari\\/537.36\"],\"accept\":[\"text\\/html,application\\/xhtml+xml,application\\/xml;q=0.9,image\\/avif,image\\/webp,image\\/apng,*\\/*;q=0.8,application\\/signed-exchange;v=b3;q=0.7\"],\"sec-fetch-site\":[\"none\"],\"sec-fetch-mode\":[\"navigate\"],\"sec-fetch-user\":[\"?1\"],\"sec-fetch-dest\":[\"document\"],\"accept-encoding\":[\"gzip, deflate, br, zstd\"],\"accept-language\":[\"en-US,en;q=0.9\"],\"cookie\":[\"XSRF-TOKEN=eyJpdiI6InMvTXZiOUFJdnN2bHU2dEFiNXQyU0E9PSIsInZhbHVlIjoiR3I1VWpXTzJsM3laaGE1MGlrdHpGK2Q5NFNVUHVodkp5UWFlbXNtRUc1a0plOFZaTGhwOVQ5TE1yNlU4VEpVTkxTUGR1ajBRY1RxQlpseU1sTVh3TENHWm0xMWJxRENCWTdsUHZyeGZRR0dDNzY5c2JrOFd6Vys0eW16dDIzd0UiLCJtYWMiOiJiZmUyY2E0MjgzOTkzMjBhMWEyMDJiYWExZTg0NDc0NmIyNDViZjAzZGJhYTU5NmM2ZjFiY2Y1ZGIzM2NhMmZkIiwidGFnIjoiIn0%3D; laravel-session=eyJpdiI6IjVmbjExaGIrbzJscTk5TkkyZi9vS0E9PSIsInZhbHVlIjoiMVN3cmN2OG91a2lIY2RwRWFkbkhFbTVGOEM1ejBSZnpaWjhhYytONUFuWHlMc1dnSGh3bXRObVZsVE1KelkySTRra1ZGYTE5dGMvVVhMZDF4aVhSR3B3S0RYUWdWeW9iOGVRMGNCWnVLaFN3WUpBZVVUMUFmbW9aczh2akZKT3QiLCJtYWMiOiJkOTdiOGJhNjAwOTNmNzZlNjAwNWMzYzUzYTk4NDcwYjkzNzI2MDI3MGFkNDM5MjNlNzkwNzU1ZmI4YjlmNWU4IiwidGFnIjoiIn0%3D\"]}', 'Desktop', 'Windows', 'Chrome', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, '2026-05-19 22:36:59', '2026-05-19 22:36:59');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subject` (`subject_type`,`subject_id`),
  ADD KEY `causer` (`causer_type`,`causer_id`),
  ADD KEY `activity_log_ip_address_index` (`ip_address`),
  ADD KEY `activity_log_created_at_index` (`created_at`),
  ADD KEY `activity_log_log_name_index` (`log_name`);

--
-- Indexes for table `backend_menu`
--
ALTER TABLE `backend_menu`
  ADD PRIMARY KEY (`menu_id`);

--
-- Indexes for table `backend_role_mapping`
--
ALTER TABLE `backend_role_mapping`
  ADD PRIMARY KEY (`id`),
  ADD KEY `backend_role_mapping_menu_id_foreign` (`menu_id`);

--
-- Indexes for table `content_applications`
--
ALTER TABLE `content_applications`
  ADD PRIMARY KEY (`application_id`);

--
-- Indexes for table `content_application_translations`
--
ALTER TABLE `content_application_translations`
  ADD PRIMARY KEY (`application_translation_id`);

--
-- Indexes for table `content_article`
--
ALTER TABLE `content_article`
  ADD PRIMARY KEY (`article_id`);

--
-- Indexes for table `content_article_translation`
--
ALTER TABLE `content_article_translation`
  ADD PRIMARY KEY (`article_translation_id`);

--
-- Indexes for table `content_downloads`
--
ALTER TABLE `content_downloads`
  ADD PRIMARY KEY (`download_id`);

--
-- Indexes for table `content_images`
--
ALTER TABLE `content_images`
  ADD PRIMARY KEY (`image_id`);

--
-- Indexes for table `content_photo_gallery`
--
ALTER TABLE `content_photo_gallery`
  ADD PRIMARY KEY (`gallery_id`);

--
-- Indexes for table `content_photo_gallery_translations`
--
ALTER TABLE `content_photo_gallery_translations`
  ADD PRIMARY KEY (`gallery_translation_id`),
  ADD KEY `fk_gallery_trans_parent` (`gallery_translation_parent_id`);

--
-- Indexes for table `content_photo_list`
--
ALTER TABLE `content_photo_list`
  ADD PRIMARY KEY (`photo_id`);

--
-- Indexes for table `content_slider`
--
ALTER TABLE `content_slider`
  ADD PRIMARY KEY (`slider_id`);

--
-- Indexes for table `content_slider_translation`
--
ALTER TABLE `content_slider_translation`
  ADD PRIMARY KEY (`slider_translation_id`);

--
-- Indexes for table `content_video`
--
ALTER TABLE `content_video`
  ADD PRIMARY KEY (`video_id`);

--
-- Indexes for table `content_video_translation`
--
ALTER TABLE `content_video_translation`
  ADD PRIMARY KEY (`video_translation_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `frontend_menu`
--
ALTER TABLE `frontend_menu`
  ADD PRIMARY KEY (`menu_id`);

--
-- Indexes for table `frontend_menu_category`
--
ALTER TABLE `frontend_menu_category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `frontend_role_mapping`
--
ALTER TABLE `frontend_role_mapping`
  ADD PRIMARY KEY (`id`),
  ADD KEY `frontend_role_mapping_menu_id_foreign` (`menu_id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `ref`
--
ALTER TABLE `ref`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ref_cat_index` (`cat`),
  ADD KEY `ref_code_index` (`code`),
  ADD KEY `ref_parent_index` (`parent`),
  ADD KEY `ref_sort_index` (`sort`),
  ADD KEY `ref_deleted_at_index` (`deleted_at`),
  ADD KEY `ref_cat_sort_index` (`cat`,`sort`),
  ADD KEY `ref_parent_sort_index` (`parent`,`sort`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `routes`
--
ALTER TABLE `routes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `routes_name_index` (`name`),
  ADD KEY `routes_uri_index` (`uri`),
  ADD KEY `routes_method_index` (`method`),
  ADD KEY `routes_type_index` (`type`),
  ADD KEY `routes_status_index` (`status`),
  ADD KEY `routes_deleted_at_index` (`deleted_at`),
  ADD KEY `routes_type_status_index` (`type`,`status`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `visitor_settings`
--
ALTER TABLE `visitor_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `visits`
--
ALTER TABLE `visits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `visits_visitable_type_visitable_id_index` (`visitable_type`,`visitable_id`),
  ADD KEY `visits_visitor_type_visitor_id_index` (`visitor_type`,`visitor_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_log`
--
ALTER TABLE `activity_log`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `backend_menu`
--
ALTER TABLE `backend_menu`
  MODIFY `menu_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `backend_role_mapping`
--
ALTER TABLE `backend_role_mapping`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `content_applications`
--
ALTER TABLE `content_applications`
  MODIFY `application_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `content_application_translations`
--
ALTER TABLE `content_application_translations`
  MODIFY `application_translation_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `content_article`
--
ALTER TABLE `content_article`
  MODIFY `article_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `content_article_translation`
--
ALTER TABLE `content_article_translation`
  MODIFY `article_translation_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `content_downloads`
--
ALTER TABLE `content_downloads`
  MODIFY `download_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_images`
--
ALTER TABLE `content_images`
  MODIFY `image_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_photo_gallery`
--
ALTER TABLE `content_photo_gallery`
  MODIFY `gallery_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_photo_gallery_translations`
--
ALTER TABLE `content_photo_gallery_translations`
  MODIFY `gallery_translation_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_photo_list`
--
ALTER TABLE `content_photo_list`
  MODIFY `photo_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_slider`
--
ALTER TABLE `content_slider`
  MODIFY `slider_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `content_slider_translation`
--
ALTER TABLE `content_slider_translation`
  MODIFY `slider_translation_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `content_video`
--
ALTER TABLE `content_video`
  MODIFY `video_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content_video_translation`
--
ALTER TABLE `content_video_translation`
  MODIFY `video_translation_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `frontend_menu`
--
ALTER TABLE `frontend_menu`
  MODIFY `menu_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `frontend_menu_category`
--
ALTER TABLE `frontend_menu_category`
  MODIFY `category_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `frontend_role_mapping`
--
ALTER TABLE `frontend_role_mapping`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;

--
-- AUTO_INCREMENT for table `ref`
--
ALTER TABLE `ref`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `routes`
--
ALTER TABLE `routes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `visitor_settings`
--
ALTER TABLE `visitor_settings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `visits`
--
ALTER TABLE `visits`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `backend_role_mapping`
--
ALTER TABLE `backend_role_mapping`
  ADD CONSTRAINT `backend_role_mapping_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `backend_menu` (`menu_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `content_photo_gallery_translations`
--
ALTER TABLE `content_photo_gallery_translations`
  ADD CONSTRAINT `fk_gallery_trans_parent` FOREIGN KEY (`gallery_translation_parent_id`) REFERENCES `content_photo_gallery` (`gallery_id`) ON DELETE CASCADE;

--
-- Constraints for table `frontend_role_mapping`
--
ALTER TABLE `frontend_role_mapping`
  ADD CONSTRAINT `frontend_role_mapping_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `frontend_menu` (`menu_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

