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

START TRANSACTION;




--
-- Database: `sabetiay_topskills`
--

DELIMITER $$
--
-- Procedures
--
$$

$$

DELIMITER ;

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

--
-- Table structure for table `cf_blogs`
--

CREATE TABLE `cf_blogs` (
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `blog_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(200) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` tinyint(4) 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 `cf_blogs`
--

INSERT INTO `cf_blogs` (`blog_id`, `blog_category_id`, `employer_id`, `title`, `description`, `image`, `status`, `created_at`, `updated_at`) VALUES
(5, 6, 2, 'Frequently Asked Questions', '<h2>What is Lorem Ipsum?</h2>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p\r\n\r\n<h2>Why do we use it?</h2>\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n\r\n<h2>Where does it come from?</h2>\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p>\r\n\r\n<p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<h2>Where can I get some?</h2>\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'employers/sabeti-ayan-inc/blogs/faqs.jpg', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(6, 6, 2, 'How to Apply', '<h2>What is Lorem Ipsum?</h2>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p\r\n\r\n<h2>Why do we use it?</h2>\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n\r\n<h2>Where does it come from?</h2>\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p>\r\n\r\n<p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<h2>Where can I get some?</h2>\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'employers/sabeti-ayan-inc/blogs/how-to-apply.jpg', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(7, 6, 2, 'Quiz Timings', '<h2>What is Lorem Ipsum?</h2>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p\r\n\r\n<h2>Why do we use it?</h2>\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n\r\n<h2>Where does it come from?</h2>\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p>\r\n\r\n<p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<h2>Where can I get some?</h2>\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'employers/sabeti-ayan-inc/blogs/quiz-timings.jpg', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(8, 6, 2, 'Privacy Policy', '<h2>What is Lorem Ipsum?</h2>\r\n<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p\r\n\r\n<h2>Why do we use it?</h2>\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n\r\n<h2>Where does it come from?</h2>\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p>\r\n\r\n<p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n\r\n<h2>Where can I get some?</h2>\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>', 'employers/sabeti-ayan-inc/blogs/privacy-policy.jpg', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10');

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

--
-- Table structure for table `cf_blog_categories`
--

CREATE TABLE `cf_blog_categories` (
  `blog_category_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` tinyint(4) 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 `cf_blog_categories`
--

INSERT INTO `cf_blog_categories` (`blog_category_id`, `employer_id`, `title`, `status`, `created_at`, `updated_at`) VALUES
(4, 2, 'Category 1', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(5, 2, 'Category 2', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(6, 2, 'Category 3', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10');

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

--
-- Table structure for table `cf_candidate_favorites`
--

CREATE TABLE `cf_candidate_favorites` (
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) 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 `cf_candidate_interviews`
--

CREATE TABLE `cf_candidate_interviews` (
  `candidate_interview_id` bigint(20) UNSIGNED NOT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `interviewer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `interview_title` varchar(250) DEFAULT NULL,
  `interview_data` text DEFAULT NULL,
  `answers_data` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `total_questions` tinyint(4) DEFAULT NULL,
  `overall_rating` tinyint(4) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `interview_time` datetime 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 `cf_candidate_memberships`
--

CREATE TABLE `cf_candidate_memberships` (
  `candidate_membership_id` bigint(20) UNSIGNED NOT NULL,
  `candidate_id` bigint(20) UNSIGNED NOT NULL,
  `candidate_package_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `payment_type` varchar(50) DEFAULT NULL,
  `package_type` varchar(30) DEFAULT NULL,
  `transaction_id` varchar(150) DEFAULT NULL,
  `payment_status` varchar(50) DEFAULT NULL,
  `payment_currency` varchar(50) DEFAULT NULL,
  `receiver_email` varchar(150) DEFAULT NULL,
  `payer_email` varchar(150) DEFAULT NULL,
  `price_paid` double(15,8) DEFAULT NULL,
  `response` text DEFAULT NULL,
  `details` text DEFAULT NULL,
  `show_hide_personal_info` tinyint(4) NOT NULL DEFAULT 0,
  `file` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `expiry` datetime 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 `cf_candidate_memberships`
--

INSERT INTO `cf_candidate_memberships` (`candidate_membership_id`, `candidate_id`, `candidate_package_id`, `title`, `payment_type`, `package_type`, `transaction_id`, `payment_status`, `payment_currency`, `receiver_email`, `payer_email`, `price_paid`, `response`, `details`, `show_hide_personal_info`, `file`, `message`, `status`, `expiry`, `created_at`, `updated_at`) VALUES
(1, 1, 4, 'Gold 1', 'manual', 'annual', '0', NULL, NULL, NULL, NULL, 100.00000000, NULL, '{\"title\":\"Gold\",\"currency_for_api\":\"usd\",\"image\":null,\"allowed_job_applications\":-1,\"allowed_resumes\":-1,\"show_hide_personal_info\":1}', 1, NULL, NULL, 0, '2027-12-31 00:00:00', '2025-02-18 10:11:16', '2025-12-06 08:32:27');

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

--
-- Table structure for table `cf_candidate_packages`
--

CREATE TABLE `cf_candidate_packages` (
  `candidate_package_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `currency_for_api` varchar(10) DEFAULT NULL,
  `image` varchar(150) DEFAULT NULL,
  `monthly_price` double(15,2) DEFAULT NULL,
  `yearly_price` double(15,2) DEFAULT NULL,
  `allowed_job_applications` int(11) DEFAULT 0,
  `allowed_resumes` int(11) DEFAULT 0,
  `show_hide_personal_info` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `is_free` tinyint(4) NOT NULL DEFAULT 0,
  `is_top_sale` tinyint(4) 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;

--
-- Dumping data for table `cf_candidate_packages`
--

INSERT INTO `cf_candidate_packages` (`candidate_package_id`, `title`, `currency`, `currency_for_api`, `image`, `monthly_price`, `yearly_price`, `allowed_job_applications`, `allowed_resumes`, `show_hide_personal_info`, `status`, `is_free`, `is_top_sale`, `created_at`, `updated_at`) VALUES
(1, 'Free', 'USD', 'usd', NULL, 0.00, 0.00, -1, 1, 1, 1, 1, 0, '2025-02-18 10:01:09', '2025-11-30 19:16:36'),
(2, 'Silver', 'USD', 'usd', NULL, 6.00, 70.00, -1, 5, 1, 0, 0, 0, '2025-02-18 10:02:58', '2025-12-06 08:32:01'),
(3, 'Bronze', 'USD', 'usd', NULL, 11.00, 100.00, -1, 20, 1, 0, 0, 0, '2025-02-18 10:04:22', '2025-12-06 08:32:05'),
(4, 'Gold', 'USD', 'usd', NULL, 17.00, 120.00, -1, -1, 1, 0, 0, 1, '2025-02-18 10:07:08', '2025-12-06 08:32:07');

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

--
-- Table structure for table `cf_candidate_quizes`
--

CREATE TABLE `cf_candidate_quizes` (
  `candidate_quiz_id` bigint(20) UNSIGNED NOT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_quiz_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `quiz_title` varchar(150) DEFAULT NULL,
  `quiz_data` text DEFAULT NULL,
  `answers_data` text DEFAULT NULL,
  `total_questions` tinyint(4) NOT NULL,
  `allowed_time` tinyint(4) NOT NULL,
  `correct_answers` tinyint(4) NOT NULL,
  `attempt` tinyint(4) NOT NULL DEFAULT 0,
  `started_at` datetime 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 `cf_departments`
--

CREATE TABLE `cf_departments` (
  `department_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` tinyint(4) 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 `cf_departments`
--

INSERT INTO `cf_departments` (`department_id`, `employer_id`, `title`, `image`, `status`, `created_at`, `updated_at`) VALUES
(13, 2, 'Accounting', 'employers/sabeti-ayan-inc/departments/accounting.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(14, 2, 'Administration', 'employers/sabeti-ayan-inc/departments/administration.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(15, 2, 'Information Technology', 'employers/sabeti-ayan-inc/departments/information-tech.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(16, 2, 'Human Resource', 'employers/sabeti-ayan-inc/departments/human-resource.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(17, 2, 'Finance', 'employers/sabeti-ayan-inc/departments/finance.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(18, 2, 'Marketing', 'employers/sabeti-ayan-inc/departments/marketing.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(19, 2, 'Advertising', 'employers/sabeti-ayan-inc/departments/advertising.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(20, 2, 'Sales', 'employers/sabeti-ayan-inc/departments/sales.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(21, 2, 'Business Development', 'employers/sabeti-ayan-inc/departments/business-dev.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(22, 2, 'Customer Service', 'employers/sabeti-ayan-inc/departments/customer-service.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(23, 2, 'Procurement', 'employers/sabeti-ayan-inc/departments/procurement.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(24, 2, 'Maintenance', 'employers/sabeti-ayan-inc/departments/maintenance.png', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10');

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

--
-- Table structure for table `cf_emails`
--

CREATE TABLE `cf_emails` (
  `email_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED NOT NULL,
  `to` varchar(250) DEFAULT NULL,
  `subject` varchar(250) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `sent_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cf_emails`
--

INSERT INTO `cf_emails` (`email_id`, `employer_id`, `to`, `subject`, `message`, `status`, `created_at`, `sent_at`) VALUES
(1, 0, 'contact@topskills-experts.com', ' : Job Referred', '<div lang=\"en\"><figure class=\"table\"><table style=\"border-spacing:0;width:100%;\"><tbody><tr><td style=\"padding:0;\"><figure class=\"table\"><table style=\"border-spacing:0;color:#363636;font-family:Arial, sans-serif;font-size:16px;line-height:22px;max-width:600px;text-align:left;width:94%;\"><tbody><tr><td style=\"font-size:24px;padding:40px 30px 30px 30px;text-align:center;\"><a href=\"https://topskills-experts.com/public/company/sabeti-ayan-inc\"><img class=\"image_resized\" style=\"border-style:none;color:#ffffff;height:auto;text-decoration:none;\" src=\"https://topskills-experts.com/public/uploads/employers/sabeti-ayan-inc/branding/identities/site-logo.png\" alt=\"Logo\" /></a></td></tr><tr><td style=\"background-color:#ffffff;padding:30px;\"><h2>Dear contact@topskills-experts.com</h2><p>Your friend test test has referred you a job. Please click on the link below to view detail <a href=\"https://topskills-experts.com/public/company/sabeti-ayan-incjob/bHJnTVBuZkE4UTN1ZVFsZFJ1Tksydz09\">Detail</a></p><p> </p><p>Best Regards,</p><p>Admin Top Skills Experts.</p><p> </p></td></tr><tr><td style=\"background-color:#404040;color:#cccccc;font-size:12px;padding:30px;text-align:center;\">Topskills-experts.com 2025 © All Rights Reserved.</td></tr></tbody></table></figure></td></tr></tbody></table></figure></div>', 0, '2025-02-18 12:18:44', NULL),
(2, 0, 'sabetiayan@gmail.com', 'New Site Message : testers test test', 'test testers test test', 0, '2025-02-18 12:22:01', NULL);

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

--
-- Table structure for table `cf_employer_candidates`
--

CREATE TABLE `cf_employer_candidates` (
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cf_employer_roles`
--

CREATE TABLE `cf_employer_roles` (
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `role_id` bigint(20) UNSIGNED DEFAULT NULL,
  `id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cf_employer_roles`
--

INSERT INTO `cf_employer_roles` (`employer_id`, `role_id`, `id`) VALUES
(2, 14, 1),
(2, 15, 2),
(2, 12, 3),
(3, 13, 4),
(3, 15, 5),
(3, 2, 6);

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

--
-- Table structure for table `cf_error_logs`
--

CREATE TABLE `cf_error_logs` (
  `error_log_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cf_failed_jobs`
--

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

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

--
-- Table structure for table `cf_faqs`
--

CREATE TABLE `cf_faqs` (
  `faqs_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `question` text DEFAULT NULL,
  `answer` text DEFAULT NULL,
  `status` tinyint(4) 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 `cf_faqs`
--

INSERT INTO `cf_faqs` (`faqs_id`, `category_id`, `question`, `answer`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Do I get any discount on selecting the annual plan?', 'Just like any other SaaS system, our annual plans price is less than the actual accumulated amount for all months.', 1, '2023-05-09 17:07:54', NULL),
(2, 1, 'Do employers have access to each other data ?', 'Every employer will have their separate site/interface where only their jobs and other content will appear. Employers can also select to have their own branding information based on their membership.', 1, '2023-05-09 17:11:50', NULL),
(3, 1, 'What happens when the memberships expire?', 'Your login and all the information will remain intact but you can not create any more content, nor if the limit for any item is zero then it will not appear unless renewed.', 1, '2023-05-09 17:13:14', NULL),
(4, 1, 'How do I get to test the system before choosing membership plan?', 'When you do the initial registration, you have access to free account which has all feature active but but limited to a number of sessions. this the best way to try the tool. If you need more detailed testing you can contact us for demo through contact@topskills-experts.com.', 1, '2023-05-09 17:16:45', NULL),
(5, 1, 'What other services do you offer', 'We offer a variety of services as listed on our service page and also ATS resume writing through our other website https://wewritepros.com/', 1, '2023-05-11 18:14:51', '2025-02-14 13:00:49'),
(6, 7, 'How can I contact TopSkills-Experts.com?', 'For general inquiries, reach us at contact@topskills-experts.com.', 1, '2025-02-14 13:05:18', NULL),
(7, 7, 'Do you offer customer support?', 'Yes, our support team is available to assist with any questions or issues. Contact us via email or our support page.', 1, '2025-02-14 13:06:14', NULL),
(8, 6, 'I forgot my password. How do I reset it?', 'Click on the Forgot Password link on the login page and follow the instructions to reset your password.', 1, '2025-02-14 13:07:16', NULL),
(9, 6, 'The website is not working properly. What should I do?', 'Try clearing your browser cache, refreshing the page, or using a different browser. If the issue persists, contact contact@topskills-experts.com.', 1, '2025-02-14 13:07:53', NULL),
(10, 6, 'Can I access the platform on mobile devices?', 'Yes, TopSkills-Experts.com is fully optimized for mobile use, allowing both job seekers and employers to manage applications on the go.', 1, '2025-02-14 13:08:41', NULL),
(11, 5, 'Is my personal information secure?', 'Yes, we implement strict data security measures to protect your personal information from unauthorized access, loss, or misuse.', 1, '2025-02-15 08:02:10', NULL),
(12, 5, 'Does TopSkills-Experts.com sell my data?', 'No, we do not sell, trade, or rent your personal information to third parties. Your data is used only as outlined in our Privacy Policy.', 1, '2025-02-15 08:02:39', NULL),
(14, 5, 'Can I delete my account?', 'Yes, you can delete your account by contacting contact@topskills-experts.com or using the account settings on your dashboard.', 1, '2025-02-15 08:03:23', NULL),
(15, 4, 'How do employers use TopSkills-Experts.com?', 'Employers can post job vacancies, search for top candidates, and manage recruitment using our Applicant Tracking System (ATS) and other advanced tools.', 1, '2025-02-15 08:05:46', NULL),
(16, 4, 'What recruitment tools do you offer?', 'We offer interactive dashboards, candidate pre-application questionnaires, resume screening tools, interview scheduling, quiz assessments, and executive search features.', 1, '2025-02-15 08:06:38', NULL),
(17, 4, 'Can employers access candidate assessments?', 'Yes, employers can use our built-in skills gap analysis and quiz designer to assess candidates before making hiring decisions.', 1, '2025-02-15 08:07:21', NULL),
(18, 4, 'How can I improve my employer branding?', 'We provide employer branding services such as customized career pages, job advertisements, and company profile enhancements to attract top talent.', 1, '2025-02-15 08:07:46', NULL),
(19, 4, 'What industries do you support?', 'We cater to a diverse range of industries, including IT, healthcare, finance, engineering, marketing, and more. Just register and post your vacancies.', 1, '2025-02-15 08:09:07', NULL),
(20, 3, 'How do I create a job seeker account?', 'Simply click on the Sign Up button, fill in your details, upload your resume, and start applying for jobs.', 1, '2025-02-15 08:09:42', NULL),
(21, 3, 'Can I set up job alerts?', 'Yes, you can customize job alerts based on your skills, industry, and location to receive notifications about relevant job openings.', 1, '2025-02-15 08:10:05', NULL),
(22, 3, 'How do I improve my job applications?', 'Use our resume builder, ensure your profile is complete, and take advantage of our skills assessment tools to enhance your chances of getting hired.', 1, '2025-02-15 08:10:32', NULL),
(23, 3, 'How do I apply for a job?', 'Once logged in, you can browse job listings, click on a preferred job, and follow the application instructions.', 1, '2025-02-15 08:10:59', NULL),
(24, 3, 'Can I edit my resume or profile after submission?', 'Yes, you can update your resume and profile anytime to reflect new skills, experiences, or achievements.', 1, '2025-02-15 08:11:28', NULL),
(25, 2, 'What is TopSkills-Experts.com?', 'TopSkills-Experts.com is a premier online platform connecting highly skilled job seekers with businesses looking for top-tier talent. We provide recruitment solutions, job matching, and career development tools for candidates and employers.', 1, '2025-02-15 08:12:17', NULL),
(26, 2, 'How does TopSkills-Experts.com work?', 'Our platform allows job seekers to create profiles, upload resumes, and apply for jobs. Employers can post job vacancies, search for candidates, and manage applications and onboarding processes using our advanced recruitment tools.', 1, '2025-02-15 08:13:26', NULL),
(27, 2, 'Is TopSkills-Experts.com free to use?', 'Creating an account and browsing job listings is free for job seekers. Employers may have access to both free and premium recruitment services.', 1, '2025-02-15 08:13:55', NULL);

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

--
-- Table structure for table `cf_faqs_categories`
--

CREATE TABLE `cf_faqs_categories` (
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` tinyint(4) 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 `cf_faqs_categories`
--

INSERT INTO `cf_faqs_categories` (`category_id`, `title`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Pricing', 1, '2023-05-09 17:06:11', NULL),
(2, 'General', 1, '2023-05-09 17:06:25', NULL),
(3, 'Job Seekers', 1, '2025-02-14 13:03:42', NULL),
(4, 'Employers & Recruitment', 1, '2025-02-14 13:03:56', NULL),
(5, 'Privacy & Security', 1, '2025-02-14 13:04:09', NULL),
(6, 'Technical Support', 1, '2025-02-14 13:04:28', NULL),
(7, 'Contact & Support', 1, '2025-02-14 13:04:41', NULL);

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

--
-- Table structure for table `cf_industries`
--

CREATE TABLE `cf_industries` (
  `industry_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `status` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cf_interviews`
--

CREATE TABLE `cf_interviews` (
  `interview_id` bigint(20) UNSIGNED NOT NULL,
  `interview_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `cf_interview_categories`
--

CREATE TABLE `cf_interview_categories` (
  `interview_category_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `cf_interview_questions`
--

CREATE TABLE `cf_interview_questions` (
  `interview_question_id` bigint(20) UNSIGNED NOT NULL,
  `interview_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` text DEFAULT NULL,
  `image` varchar(250) DEFAULT NULL,
  `order` tinyint(4) NOT 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 `cf_jobs`
--

CREATE TABLE `cf_jobs` (
  `job_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `department_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `combined_filters` varchar(255) DEFAULT NULL,
  `is_static_allowed` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_date` date DEFAULT NULL,
  `hide_job_after_last_date` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cf_job_applications`
--

CREATE TABLE `cf_job_applications` (
  `job_application_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `resume_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('applied','shortlisted','interviewed','hired','rejected') NOT NULL DEFAULT 'applied',
  `traites_result` int(10) UNSIGNED DEFAULT 0,
  `quizes_result` int(10) UNSIGNED DEFAULT 0,
  `interviews_result` int(10) UNSIGNED DEFAULT 0,
  `overall_result` int(10) UNSIGNED 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 `cf_job_assignments`
--

CREATE TABLE `cf_job_assignments` (
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cf_job_custom_fields`
--

CREATE TABLE `cf_job_custom_fields` (
  `custom_field_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `value` varchar(255) 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 `cf_job_favorites`
--

CREATE TABLE `cf_job_favorites` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) 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 `cf_job_filters`
--

CREATE TABLE `cf_job_filters` (
  `job_filter_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `order` tinyint(4) NOT NULL DEFAULT 1,
  `admin_filter` tinyint(4) NOT NULL DEFAULT 1,
  `front_filter` tinyint(4) NOT NULL DEFAULT 1,
  `front_value` tinyint(4) NOT NULL DEFAULT 1,
  `type` varchar(100) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `status` tinyint(4) 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 `cf_job_filters`
--

INSERT INTO `cf_job_filters` (`job_filter_id`, `employer_id`, `title`, `order`, `admin_filter`, `front_filter`, `front_value`, `type`, `icon`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 'Location', 5, 1, 1, 1, 'dropdown', NULL, 1, '2023-05-09 17:23:18', '2023-05-09 17:51:12'),
(2, 0, 'Job Type', 1, 1, 1, 1, 'dropdown', NULL, 1, '2023-05-09 17:27:00', NULL),
(3, 0, 'Salary Level', 1, 1, 1, 1, 'dropdown', NULL, 1, '2023-05-09 17:30:07', '2025-02-11 05:53:39'),
(4, 0, 'Experience', 4, 1, 1, 1, 'dropdown', NULL, 1, '2023-05-09 17:32:12', '2023-05-09 17:50:58'),
(5, 0, 'Organization type', 3, 1, 1, 1, 'dropdown', NULL, 1, '2023-05-09 17:40:48', '2023-05-09 17:50:46'),
(6, 0, 'Career category', 2, 1, 1, 1, 'dropdown', NULL, 1, '2023-05-09 17:47:42', '2023-05-09 17:50:25');

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

--
-- Table structure for table `cf_job_filter_values`
--

CREATE TABLE `cf_job_filter_values` (
  `job_filter_value_id` bigint(20) UNSIGNED NOT NULL,
  `job_filter_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cf_job_filter_values`
--

INSERT INTO `cf_job_filter_values` (`job_filter_value_id`, `job_filter_id`, `employer_id`, `title`) VALUES
(1, 1, 0, 'New Delhi'),
(2, 1, 0, 'Nairobi'),
(3, 1, 0, 'Abuja'),
(4, 1, 0, 'New York'),
(5, 1, 0, 'Moscow'),
(6, 1, 0, 'Oslo'),
(7, 1, 0, 'Paris'),
(8, 1, 0, 'Kampla'),
(9, 1, 0, 'Beijing'),
(10, 1, 0, 'Dubai'),
(11, 2, 0, 'On Site'),
(12, 2, 0, 'Remote'),
(13, 2, 0, 'Freelance'),
(14, 2, 0, 'Full Time'),
(15, 2, 0, 'On Call'),
(16, 2, 0, 'Internship'),
(17, 2, 0, 'Consultancy'),
(18, 2, 0, 'Volunteer'),
(19, 3, 0, '$100-500'),
(20, 3, 0, '$500-5000'),
(21, 3, 0, '$More than 5000'),
(22, 4, 0, '0 - 2 years'),
(23, 4, 0, '3 - 4 years'),
(24, 4, 0, '5 - 9 years'),
(25, 4, 0, '10+ Years'),
(26, 5, 0, 'Academic and Research Institution'),
(27, 5, 0, 'Government'),
(28, 5, 0, 'International Organization'),
(29, 5, 0, 'Media'),
(30, 5, 0, 'Non-governmental Organization'),
(31, 5, 0, 'Other'),
(32, 5, 0, 'Agricultural'),
(33, 5, 0, 'Technology'),
(34, 5, 0, 'Humanitarian'),
(35, 6, 0, 'Administration/Finance'),
(36, 6, 0, 'Advocacy/Communications'),
(37, 6, 0, 'Donor Relations/Grants Management'),
(38, 6, 0, 'Human Resources'),
(39, 6, 0, 'Information and Communications Technology'),
(40, 6, 0, 'Information Management'),
(41, 6, 0, 'Logistics/Procurement'),
(42, 6, 0, 'Monitoring and Evaluation'),
(43, 6, 0, 'Program/Project Management');

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

--
-- Table structure for table `cf_job_filter_value_assignments`
--

CREATE TABLE `cf_job_filter_value_assignments` (
  `job_filter_value_assignment_id` bigint(20) UNSIGNED NOT NULL,
  `job_filter_value_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_filter_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cf_job_quizes`
--

CREATE TABLE `cf_job_quizes` (
  `job_quiz_id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `quiz_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `quiz_title` varchar(150) DEFAULT NULL,
  `total_questions` int(11) DEFAULT NULL,
  `allowed_time` int(11) DEFAULT NULL,
  `quiz_data` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cf_job_referred`
--

CREATE TABLE `cf_job_referred` (
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cf_job_traites`
--

CREATE TABLE `cf_job_traites` (
  `job_traite_id` bigint(20) UNSIGNED NOT NULL,
  `job_id` bigint(20) UNSIGNED DEFAULT NULL,
  `traite_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) 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 `cf_job_traite_answers`
--

CREATE TABLE `cf_job_traite_answers` (
  `job_traite_answer_id` bigint(20) UNSIGNED NOT NULL,
  `job_traite_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_application_id` bigint(20) UNSIGNED DEFAULT NULL,
  `job_traite_title` varchar(255) DEFAULT NULL,
  `rating` tinyint(4) 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 `cf_languages`
--

CREATE TABLE `cf_languages` (
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `is_main` tinyint(4) NOT NULL DEFAULT 0,
  `is_selected` tinyint(4) NOT NULL DEFAULT 0,
  `is_default` tinyint(4) NOT NULL DEFAULT 0,
  `flag` varchar(5) DEFAULT NULL,
  `display` varchar(15) DEFAULT 'both',
  `direction` varchar(5) DEFAULT 'ltr',
  `status` tinyint(4) 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 `cf_languages`
--

INSERT INTO `cf_languages` (`language_id`, `employer_id`, `title`, `slug`, `is_main`, `is_selected`, `is_default`, `flag`, `display`, `direction`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'English', 'english', 0, 1, 1, NULL, 'both', 'ltr', 1, '2023-05-09 01:15:40', '2025-02-11 06:24:55');

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

--
-- Table structure for table `cf_memberships`
--

CREATE TABLE `cf_memberships` (
  `membership_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `payment_type` varchar(50) DEFAULT NULL,
  `package_type` varchar(30) DEFAULT NULL,
  `transaction_id` varchar(150) DEFAULT NULL,
  `payment_status` varchar(50) DEFAULT NULL,
  `payment_currency` varchar(50) DEFAULT NULL,
  `receiver_email` varchar(150) DEFAULT NULL,
  `payer_email` varchar(150) DEFAULT NULL,
  `price_paid` double(15,8) DEFAULT NULL,
  `response` text DEFAULT NULL,
  `details` text DEFAULT NULL,
  `separate_site` tinyint(4) NOT NULL DEFAULT 0,
  `file` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `expiry` datetime 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 `cf_memberships`
--

INSERT INTO `cf_memberships` (`membership_id`, `employer_id`, `package_id`, `title`, `payment_type`, `package_type`, `transaction_id`, `payment_status`, `payment_currency`, `receiver_email`, `payer_email`, `price_paid`, `response`, `details`, `separate_site`, `file`, `message`, `status`, `expiry`, `created_at`, `updated_at`) VALUES
(1, 2, 3, 'Sabeti Ayan Inc', 'manual', 'annual', '0', NULL, NULL, NULL, NULL, 100.00000000, NULL, '{\"title\":\"Gold\",\"currency_for_api\":\"usd\",\"active_jobs\":-1,\"active_users\":20,\"active_custom_filters\":-1,\"active_traites\":-1,\"active_quizes\":-1,\"active_interviews\":-1,\"separate_site\":1,\"branding\":1,\"role_permissions\":1,\"custom_emails\":1,\"image\":\"general\\/gold-1683661841.png\"}', 1, NULL, NULL, 1, '2030-12-31 00:00:00', '2025-01-28 11:55:06', '2025-02-16 08:05:00'),
(2, 3, 3, 'Top Skills', 'manual', 'annual', '0', NULL, NULL, NULL, NULL, 100.00000000, NULL, '{\"title\":\"Gold\",\"currency_for_api\":\"usd\",\"active_jobs\":-1,\"active_users\":20,\"active_custom_filters\":-1,\"active_traites\":-1,\"active_quizes\":-1,\"active_interviews\":-1,\"separate_site\":1,\"branding\":1,\"role_permissions\":1,\"custom_emails\":1,\"image\":\"general\\/gold-1683661841.png\"}', 1, NULL, NULL, 1, '2027-12-31 00:00:00', '2025-02-18 09:39:17', NULL);

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

--
-- Table structure for table `cf_menus`
--

CREATE TABLE `cf_menus` (
  `menu_id` bigint(20) UNSIGNED NOT NULL,
  `menu_item_id` varchar(255) DEFAULT NULL,
  `parent_id` varchar(255) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `link` text DEFAULT NULL,
  `type` varchar(20) DEFAULT 'admin',
  `alignment` varchar(10) DEFAULT 'left',
  `order` tinyint(4) 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 `cf_menus`
--

INSERT INTO `cf_menus` (`menu_id`, `menu_item_id`, `parent_id`, `title`, `link`, `type`, `alignment`, `order`, `created_at`, `updated_at`) VALUES
(1, 'home_main', '0', 'message.home', 'http://topskills-experts.com/public', 'home_main', 'left', 1, '2023-05-09 01:15:40', '2025-12-04 07:38:46'),
(2, 'all_jobs_page', '0', 'message.jobs', 'http://topskills-experts.com/public/jobs', 'all_jobs_page', 'left', 2, '2023-05-09 01:15:40', '2025-12-04 07:38:46'),
(6, 'features', '0', 'message.features', 'http://topskills-experts.com/public/features', 'features', 'left', 5, '2023-05-09 01:15:40', '2025-12-04 07:38:46'),
(7, 'pricing', '0', 'message.pricing', 'http://topskills-experts.com/public/pricing', 'pricing', 'left', 6, '2023-05-09 01:15:40', '2025-12-04 07:38:46'),
(10, 'select_page', '0', 'message.about_us', 'http://topskills-experts.com/public/pages/about-us', 'select_page', 'left', 7, '2023-05-09 01:15:40', '2025-12-04 07:38:46'),
(15, 'login_button', '0', 'message.login', '#', 'login_button', 'right', 16, '2023-05-09 01:15:40', '2023-05-09 01:15:40'),
(16, 'dark_mode_button', '0', 'message.dark_mode_button', '#dark-mode', 'dark_mode_button', 'right', 17, '2023-05-09 01:15:40', '2023-05-09 01:15:40'),
(18, 'select_page', '0', 'Our Services', 'http://topskills-experts.com/public/pages/our-services', 'select_page', 'left', 4, NULL, '2025-12-04 07:38:46'),
(20, 'faqs', '0', 'message.faqs', 'http://topskills-experts.com/public/faqs', 'faqs', 'left', 8, NULL, '2025-12-04 07:38:46'),
(22, 'all_candidates_page', '0', 'message.candidates', 'http://topskills-experts.com/public/candidates', 'all_candidates_page', 'left', 3, NULL, '2025-12-04 07:38:46');

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

--
-- Table structure for table `cf_messages`
--

CREATE TABLE `cf_messages` (
  `message_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `subject` varchar(100) DEFAULT NULL,
  `description` text 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 `cf_messages`
--

INSERT INTO `cf_messages` (`message_id`, `name`, `email`, `subject`, `description`, `created_at`, `updated_at`) VALUES
(1, 'test', 'contact@topskills-experts.com', 'testers test test', 'test testers test test', '2025-02-18 10:22:01', NULL);

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

--
-- Table structure for table `cf_news`
--

CREATE TABLE `cf_news` (
  `news_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `keywords` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `cf_news_categories`
--

CREATE TABLE `cf_news_categories` (
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `cf_notifications`
--

CREATE TABLE `cf_notifications` (
  `notification_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `is_read` tinyint(4) 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;

--
-- Dumping data for table `cf_notifications`
--

INSERT INTO `cf_notifications` (`notification_id`, `title`, `description`, `type`, `is_read`, `created_at`, `updated_at`) VALUES
(1, 'testers test test', '<a href=\"https://topskills-experts.com/public/admin/messages\">View Message</a>', 'message', 0, '2025-02-18 10:22:01', NULL);

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

--
-- Table structure for table `cf_packages`
--

CREATE TABLE `cf_packages` (
  `package_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `currency` varchar(100) DEFAULT NULL,
  `currency_for_api` varchar(10) DEFAULT NULL,
  `monthly_price` double(15,2) DEFAULT NULL,
  `yearly_price` double(15,2) DEFAULT NULL,
  `active_jobs` int(11) DEFAULT 0,
  `active_users` int(11) DEFAULT 0,
  `active_custom_filters` int(11) DEFAULT 0,
  `active_traites` int(11) DEFAULT 0,
  `active_quizes` int(11) DEFAULT 0,
  `active_interviews` int(11) DEFAULT 0,
  `separate_site` tinyint(4) NOT NULL DEFAULT 1,
  `branding` tinyint(4) NOT NULL DEFAULT 1,
  `role_permissions` tinyint(4) NOT NULL DEFAULT 1,
  `custom_emails` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `is_free` tinyint(4) NOT NULL DEFAULT 0,
  `is_top_sale` tinyint(4) NOT NULL DEFAULT 0,
  `image` varchar(150) 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 `cf_packages`
--

INSERT INTO `cf_packages` (`package_id`, `title`, `currency`, `currency_for_api`, `monthly_price`, `yearly_price`, `active_jobs`, `active_users`, `active_custom_filters`, `active_traites`, `active_quizes`, `active_interviews`, `separate_site`, `branding`, `role_permissions`, `custom_emails`, `status`, `is_free`, `is_top_sale`, `image`, `created_at`, `updated_at`) VALUES
(1, 'Silver', '$', 'usd', 38.00, 199.00, 20, 5, 15, 20, 20, 20, 0, 1, 1, 0, 0, 0, 0, 'general/silver-1683660755.png', '2023-05-09 16:32:35', '2026-01-11 09:47:50'),
(2, 'Bronze', '$', 'usd', 49.00, 249.00, 60, 10, 60, 60, 60, 60, 1, 1, 1, 1, 1, 0, 1, 'general/bronze-1683661398.png', '2023-05-09 16:43:18', '2025-11-30 19:00:16'),
(3, 'Gold', '$', 'usd', 70.00, 499.00, -1, 40, -1, -1, -1, -1, 1, 1, 1, 1, 1, 0, 0, 'general/gold-1683661841.png', '2023-05-09 16:50:41', '2025-11-30 19:00:16'),
(4, 'Trial/Free', '$', 'usd', 0.00, 0.00, 3, 3, 3, 3, 3, 3, 1, 1, 1, 1, 1, 1, 0, 'general/free-1683662454.png', '2023-05-09 17:00:54', '2025-11-30 19:00:16'),
(5, 'Pay-Per-Post', '$', 'usd', 25.00, 0.00, 10, 5, 10, 10, 10, 10, 1, 1, 1, 1, 1, 0, 0, 'general/one-offi-1764529544.jpg', '2025-02-15 20:37:09', '2025-11-30 19:14:37');

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

--
-- Table structure for table `cf_pages`
--

CREATE TABLE `cf_pages` (
  `page_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `keywords` text DEFAULT NULL,
  `summary` text DEFAULT NULL,
  `status` tinyint(4) 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 `cf_pages`
--

INSERT INTO `cf_pages` (`page_id`, `title`, `slug`, `description`, `keywords`, `summary`, `status`, `created_at`, `updated_at`) VALUES
(1, 'About Us', 'about-us', '<p class=\"MsoNormal\" style=\"margin-bottom:0in;\">Welcome to Topskills-experts.com, your premier online destination for recruitment and job seeking. As a leading platform designed to connect highly skilled professionals with businesses seeking top-tier talent, we bridge the gap between ambition and opportunity. Our mission is to empower individuals and organizations alike, regardless of background, by providing a comprehensive, user-friendly, and inclusive recruitment experience.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>For Job Seekers</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">At Top Skills Experts, we understand that finding the right job is more than just a search—it’s a journey. Our platform offers an intuitive interface that simplifies profile creation, delivers customized job alerts, and streamlines the application process. Job seekers can showcase their unique skills, experiences, and qualifications to potential employers while exploring a vast database of job openings across diverse industries. Whether you’re taking the next step in your career or exploring new opportunities, we’re here to help you achieve your professional goals.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>For Employers</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">For businesses, Top Skills Experts is a powerful recruitment tool designed to simplify hiring. Our advanced filtering options enable you to pinpoint the best-fit candidates for your specific needs. From posting job vacancies to managing applications and conducting interviews, our platform offers a seamless experience. We provide access to a pool of highly skilled professionals, ensuring you find the talent that drives your organization forward.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>Key Features</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We take pride in offering a robust suite of features tailored to meet the needs of both job seekers and employers:</p><ul><li style=\"margin-top:0in;\">Interactive Dashboards for Employers: Manage recruitment processes efficiently.</li><li style=\"margin-top:0in;\">Advanced Job Board: Discover unique job openings with tailored search options.</li><li style=\"margin-top:0in;\">Candidate Pre-Application Questionnaire: Streamline candidate screening.</li><li style=\"margin-top:0in;\">Resume Builder: Create professional resumes with ease.</li><li style=\"margin-top:0in;\">Interview &amp; Quiz Designers: Customize interviews and assessments with reusable templates.</li><li style=\"margin-top:0in;\">Traits Management: Evaluate candidate attributes for better hiring decisions.</li><li style=\"margin-top:0in;\">Quiz Wizard for Candidates: Enhance skills assessment and preparation.</li><li style=\"margin-top:0in;\">Multiple Resume Builder: Tailor resumes for different job applications.</li><li style=\"margin-top:0in;\">News &amp; Announcements: Stay updated with industry insights via our blog.</li><li style=\"margin-top:0in;\">Jobs Management: Simplify job posting and applicant tracking.</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>Our Commitment to Equality</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">Top Skills Experts is proud to be an Equal Opportunity Recruitment Platform. We are committed to providing equal job opportunities for everyone, regardless of race, color, religion, age, gender, national origin, disability status, genetic information, veteran status, sexual orientation, gender identity, or any other protected characteristic. Our nondiscriminatory policy applies to all aspects of employment, including recruitment, hiring, placement, promotion, termination, compensation, and professional development.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>Your Trusted Recruitment Partner</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">Whether you’re an individual seeking your next career opportunity or a business looking to hire top talent, Top Skills Experts is your trusted partner in recruitment and career advancement. Together, we build bridges that connect talent to opportunity, fostering growth and success for all.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">Join us today and experience a smarter, more inclusive way to recruit and job search.</p><p> </p><p> </p>', 'about us', 'Topskills-experts.com is a leading online recruitment hub, bridging highly skilled professionals with businesses in need of top-tier talent, transcending all backgrounds.', 1, '2023-05-09 01:15:40', '2025-02-13 09:42:59'),
(2, 'Terms & Conditions', 'terms-conditions', '<p class=\"MsoNormal\" style=\"margin-bottom:0in;\">1. Acceptance of Terms</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">By accessing and using <a href=\"https://topskills-experts.com/\">https://topskills-experts.com</a> (the \"Site\"), you agree to be bound by these Terms and Conditions (\"Terms\"). If you do not agree to these Terms, you must refrain from using the Site.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">2. Eligibility</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">You must be at least 18 years of age to use this Site. By accessing the Site, you confirm and warrant that you meet this age requirement.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">3. Permitted Use of the Site</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">The Site is to be used solely for lawful purposes and in accordance with these Terms. You agree not to use the Site:</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(a) In violation of any applicable federal, state, local, or international law or regulation.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(b) To exploit, harm, or attempt to exploit or harm minors, including through the exposure to inappropriate content or unauthorized collection of personal information.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(c) To transmit unauthorized advertising, including junk mail, spam, chain letters, or similar solicitations.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(d) To impersonate <a href=\"https://topskills-experts.com/\">https://topskills-experts.com</a>, its employees, other users, or any other individual or entity.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(e) To engage in conduct that restricts or inhibits others\' use and enjoyment of the Site or that may expose <a href=\"https://topskills-experts.com/\">https://topskills-experts.com</a> to liability.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">4. User Content</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">The Site may allow you to submit content, including resumes, job postings, and other materials (\"User Content\"). By submitting User Content, you grant <a href=\"https://topskills-experts.com/\">https://topskills-experts.com</a> a non-exclusive, royalty-free, perpetual, irrevocable, and fully sublicensable license to use, reproduce, modify, adapt, publish, translate, create derivative works from, distribute, and display such content globally in any media format.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">5. Prohibited User Content</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">You agree not to submit content that:</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(a) Is false, misleading, or deceptive.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(b) Is defamatory, obscene, vulgar, or offensive.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(c) Infringes on any third-party intellectual property rights.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(d) Promotes or engages in illegal activities.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">(e) Is otherwise inappropriate or objectionable.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">6. Intellectual Property Rights</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">All content on the Site, including text, software, images, videos, and design elements, is owned by <a href=\"https://topskills-experts.com/\">https://topskills-experts.com</a> or its licensors and is protected under copyright, trademark, patent, and trade secret laws. Unauthorized reproduction or distribution is strictly prohibited.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">7. Links to Third-Party Websites</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">The Site may contain links to third-party websites. <a href=\"https://topskills-experts.com/\">https://topskills-experts.com</a> does not control and is not responsible for the content, privacy policies, or practices of these external sites. Your use of such third-party websites is at your own risk.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">8. Disclaimer of Warranties</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">The Site is provided \"as is\" and \"as available\" without warranties of any kind. <a href=\"https://topskills-experts.com/\">https://topskills-experts.com</a> does not guarantee the accuracy, reliability, or completeness of the Site’s content and disclaims all warranties, whether express or implied, including but not limited to merchantability and fitness for a particular purpose.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">For any questions or concerns regarding these Terms, please contact us at <a href=\"mailto:contact@topskills-experts.com\"><span style=\"background-color:rgb(243,243,243);color:rgb(96,105,123);float:none;font-family:poppins, sans-serif;font-size:14px;font-style:normal;font-weight:400;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;\">contact@topskills-experts.com </span></a></p>', 'terms conditions', 'Acceptance of Terms\r\nBy using https://topskills-experts.com (the \"Site\"), you agree to be bound by these Terms and Conditions (\"Terms\"), which govern your use of the Site. If you do not agree to these Terms, please do not use the Site.', 1, '2023-05-09 01:15:40', '2025-02-13 12:35:37'),
(3, 'Privacy Policy', 'privacy-policy', '<p class=\"MsoNormal\">Effective Date: May 9, 2023</p><p class=\"MsoNormal\">At TopSkills-Experts.com, we are committed to protecting your privacy. This Privacy Policy explains the types of personal information we collect, how we use it, and the measures we take to safeguard your data. By using <a href=\"https://topskills-experts.com/\">https://topskills-experts.com</a>, you consent to the collection, use, and disclosure of your personal information as outlined in this policy.</p><p class=\"MsoNormal\"> 1. Information We Collect</p><p class=\"MsoNormal\">We collect personal information that you voluntarily provide when registering, applying for jobs, subscribing to newsletters, or using other services on our site. This information may include, but is not limited to:</p><ul><li style=\"margin-top:0in;\">Name</li><li style=\"margin-top:0in;\">Contact details (email address, phone number, mailing address)</li><li style=\"margin-top:0in;\">Professional experience, skills, and qualifications</li><li style=\"margin-top:0in;\">Employment history</li><li style=\"margin-top:0in;\">Resume or CV</li><li style=\"margin-top:0in;\">Job-specific information as required</li><li style=\"margin-top:0in;\">Any other information you voluntarily provide</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;margin-left:0.5in;margin-right:0in;margin-top:0in;\"> </p><p class=\"MsoNormal\">Additionally, we collect non-personally identifiable information, such as IP address, browser type, pages visited, and session duration, to enhance site performance and user experience.</p><p class=\"MsoNormal\"> 2. How We Use Your Information</p><p class=\"MsoNormal\">We use your personal information to:</p><ul><li style=\"margin-top:0in;\">Provide access to our services</li><li style=\"margin-top:0in;\">Match candidates with job opportunities</li><li style=\"margin-top:0in;\">Communicate job-related updates and promotional materials</li><li style=\"margin-top:0in;\">Improve website functionality and services</li><li style=\"margin-top:0in;\">Analyze usage trends and optimize user experience</li><li style=\"margin-top:0in;\">Comply with legal obligations and protect our legal rights</li></ul><p class=\"MsoNormal\"> 3. Disclosure of Your Information</p><p class=\"MsoNormal\">We may share your personal information in the following situations:</p><ul><li style=\"margin-top:0in;\">With potential employers or recruiters to facilitate job placements</li><li style=\"margin-top:0in;\">With service providers who assist in operating our platform and services</li><li style=\"margin-top:0in;\">As required by law, to comply with legal obligations or protect rights</li></ul><p class=\"MsoNormal\">We do not sell, trade, or rent personal information to third parties.</p><p class=\"MsoNormal\"> 4. Security of Your Information</p><p class=\"MsoNormal\">We implement appropriate security measures to safeguard your personal information from unauthorized access, disclosure, alteration, or destruction. However, no method of transmission or storage is entirely secure, and we cannot guarantee absolute security.</p><p class=\"MsoNormal\"> 5. Third-Party Websites</p><p class=\"MsoNormal\">Our website may include links to third-party websites. We are not responsible for their privacy policies or practices. Please review the policies of external sites before providing personal data.</p><p class=\"MsoNormal\"> 6. Accessing and Updating Your Information</p><p class=\"MsoNormal\">You can access, update, or delete your personal information by logging into your TopSkills-Experts.com account. Alternatively, you can request updates or deletions by contacting us at <a href=\"mailto:contact@topskills-experts.com\">contact@topskills-experts.com</a>.</p><p class=\"MsoNormal\"> 7. Changes to This Privacy Policy</p><p class=\"MsoNormal\">We may update this Privacy Policy periodically. Any changes will be posted on our website, and continued use of our services constitutes acceptance of the updated terms.</p><p class=\"MsoNormal\"> 8. Contact Us</p><p class=\"MsoNormal\">If you have any questions regarding this Privacy Policy, please contact us:</p><p class=\"MsoNormal\"><a href=\"https://topskills-experts.com/\">https://topskills-experts.com/</a></p><p class=\"MsoNormal\">Email: <a href=\"mailto:contact@topskills-experts.com\">contact@topskills-experts.com</a> </p><p><span style=\"font-family:Aptos, sans-serif;font-size:12pt;line-height:115%;\">Last Updated: 01.02.2025</span></p>', 'privacy policy', 'Welcome to TopSkills Experts (“weâ€, “usâ€, “ourâ€). We respect your privacy and are committed to protecting your personal data.', 1, '2023-05-09 01:15:40', '2025-02-14 09:06:47'),
(4, 'Services', 'our-services', '<p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>1. Talent Acquisition</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We identify and attract top talent through multiple channels, including job boards, social media, professional networks, and industry-specific platforms. Our team crafts compelling job descriptions, screens resume, conducts interviews, and assesses candidates\' skills and qualifications to ensure the perfect match.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>2. Candidate Screening &amp; Assessment</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We conduct comprehensive evaluations to ensure candidates are well-suited for specific roles. Our process includes initial phone/Teams/Skype/Google Meet screenings, assessments, reference checks, and background verification, ensuring high-quality hires for your organization.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>3. Skills Gap Analysis</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We work closely with clients to analyze talent requirements and conduct a skills gap analysis to identify necessary competencies for various positions. This process helps align your hiring strategies with long-term business objectives.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>4. Recruitment Technology &amp; Tools</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We utilize cutting-edge recruitment software, applicant tracking systems (ATS), and AI-driven tools to streamline and automate the talent sourcing process. Our technology-driven approach helps with candidate sourcing, database management, and recruitment performance tracking.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>5. Talent Pipeline Development</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We build and maintain a strong network of potential candidates, including passive professionals who may not be actively job searching but possess valuable skills and expertise. Our proactive approach ensures quick access to top talent when new opportunities arise.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>6. Executive Search</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We specialize in headhunting for senior-level and executive positions, using a targeted approach to identify, assess, and recruit high-caliber professionals with the leadership qualities your organization needs.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>7. Interview &amp; Selection Support</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We assist clients throughout the interview and selection process, offering training for hiring managers, facilitating interview panels, and providing expert guidance on candidate evaluation and selection.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>8. Onboarding Assistance</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">Our team helps design and implement effective onboarding processes to ensure a seamless transition for new hires. We provide resources, templates, and orientation strategies that enhance employee retention and engagement.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>9. Employer Branding</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We assist businesses in enhancing their employer brand to attract and retain top talent. This includes developing a strong employee value proposition, creating engaging careers pages, and promoting company culture and values to prospective candidates.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>10. Market Insights &amp; Hiring Trends</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We stay updated on market trends, industry developments, and emerging skill sets. Sharing these insights helps clients understand the competitive landscape and refine their talent acquisition and retention strategies.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\"><span class=\"text-big\">What Are Your Hiring Needs?</span></p><p><span style=\"font-family:Aptos, sans-serif;font-size:12pt;line-height:115%;\">Let us help you find the right talent!</span></p><p><a href=\"http://topskills-experts.com/public/contact\"><span class=\"text-huge\"><span style=\"font-family:\'Segoe UI\', sans-serif;\">contact us today</span></span></a></p><p> </p>', 'Service, Resume Design, Talent Acquisition, Candidate Screening and Assessment, Skills Gap Analysis, Employer Branding, Talent Pipeline Development, Executive Search, Interview and Selection Support, Onboarding Assistance, Market Insights and Trends, Recruitment Technology and Tools', 'As a HR skill sourcing firm, our objective is to help you identify and recruit highly skilled and talented individuals for your agency and organization. To effectively provide you services, we offer a range of key services.', 1, '2023-05-11 18:10:29', '2026-01-14 06:15:34'),
(5, 'Acceptable Use Policy', 'acceptable-use-policy', '<p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>Acceptable Use Policy (AUP) – Top Skills-Experts</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">Welcome to <strong>Top Skills-Experts</strong>. This Acceptable Use Policy (\"AUP\") outlines the guidelines and prohibited activities when using our platform, services, and website (<a href=\"https://topskills-experts.com/\">https://topskills-experts.com/</a>) Effective Date: 01.02.2025. By accessing or using our services, you agree to comply with this AUP.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>1. Purpose</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">This AUP is designed to protect users, ensure a secure and efficient experience, and maintain the integrity of <strong>Top Skills-Experts</strong>. We reserve the right to take appropriate action against any violations.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>2. Prohibited Activities</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">Users must not engage in the following activities while using our platform:</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>2.1. Illegal Activities</strong></p><ul><li style=\"margin-top:0in;\">Engaging in or promoting unlawful, fraudulent, or deceptive activities.</li><li style=\"margin-top:0in;\">Violating any applicable laws, regulations, or third-party rights.</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>2.2. Misuse of Platform</strong></p><ul><li style=\"margin-top:0in;\">Attempting to gain unauthorized access to the platform, data, or user accounts.</li><li style=\"margin-top:0in;\">Introducing malware, viruses, or harmful code.</li><li style=\"margin-top:0in;\">Scraping, data mining, or automated extraction of content.</li><li style=\"margin-top:0in;\">Disrupting platform operations through excessive traffic or other harmful means.</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>2.3. Misrepresentation &amp; Fraud</strong></p><ul><li style=\"margin-top:0in;\">Providing false or misleading information in profiles, job postings, or resumes.</li><li style=\"margin-top:0in;\">Impersonating another individual, organization, or entity.</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>2.4. Harassment &amp; Harmful Behavior</strong></p><ul><li style=\"margin-top:0in;\">Engaging in hate speech, discrimination, harassment, or threats.</li><li style=\"margin-top:0in;\">Posting or transmitting abusive, defamatory, or offensive content.</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>2.5. Unauthorized Commercial Use</strong></p><ul><li style=\"margin-top:0in;\">Selling, reselling, or distributing platform access without authorization.</li><li style=\"margin-top:0in;\">Using the platform for spam, phishing, or unsolicited advertising.</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>3. Security &amp; Privacy</strong></p><ul><li style=\"margin-top:0in;\">Users must protect their account credentials and notify us of any unauthorized access.</li><li style=\"margin-top:0in;\">Collecting or distributing personal information of others without consent is prohibited.</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>4. Content Guidelines</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">Users must ensure that all content posted or shared:</p><ul><li style=\"margin-top:0in;\">Is accurate, lawful, and relevant.</li><li style=\"margin-top:0in;\">Does not infringe upon intellectual property rights.</li><li style=\"margin-top:0in;\">Does not include offensive, obscene, or inappropriate material.</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>5. Enforcement &amp; Consequences</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">Violations of this AUP may result in:</p><ul><li style=\"margin-top:0in;\">Warning or content removal</li><li style=\"margin-top:0in;\">Temporary or permanent account suspension</li><li style=\"margin-top:0in;\">Legal action if necessary</li></ul><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We reserve the right to investigate any violations and take appropriate action to maintain platform integrity.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>6. Reporting Violations</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">To report a violation of this AUP, please contact us at <a href=\"mailto:contact@topskills-experts.com\">contact@topskills-experts.com</a> with details and supporting evidence.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>7. Changes to this AUP</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">We may update this AUP periodically. Continued use of our platform constitutes acceptance of the revised policy.</p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\">For any questions or concerns regarding this policy, please contact us at <a href=\"mailto:contact@topskills-experts.com\">contact@topskills-experts.com</a> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><strong>Top Skills-Experts Team.</strong></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"><span class=\"text-tiny\"><strong>Last Updated: </strong>01.02.2025</span></p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p><p class=\"MsoNormal\" style=\"margin-bottom:0in;\"> </p>', 'Acceptable Use Policy (AUP), Terms of Use, User Agreement, Platform Integrity, Service Guidelines, Illegal Activities, Fraudulent Behavior, Unauthorized Access, Hacking, Security Breach, Phishing, Scamming, Spam, Unsolicited Advertising, Impersonation, Misrepresentation, Harassment, Hate Speech, Malware, Viruses, Data Mining, Scraping, User Data Protection, Confidential Information, Intellectual Property Rights, Privacy Policy Compliance, Personal Information Misuse, User-Generated Content, Inappropriate Material, False Information, Misleading Information, Offensive Content, Defamation, Harmful Speech, Policy Violation Consequences, Warning, Content Removal, Account Suspension, Account Termination, Legal Action, Investigation, Reporting Violations, Compliance Monitoring, Regulatory Updates, Policy Amendments, Cybersecurity, Online Safety, Digital Trust, Ethical Use, Fair Use, Recruitment Compliance, HR Policy Compliance, Employment Platform Security, Talent Acquisition Protection, Job Seeker Privacy, Secure Hiring Practices, Ethical Recruitment, Transparent Hiring, Anti-Fraud Measures, Compliance Enforcement, Workforce Integrity, Industry Regulations, Data Protection Policies.', 'The Acceptable Use Policy (AUP) for Top Skills-Experts ensures ethical, secure, and transparent recruitment practices while protecting users and maintaining platform integrity. By using our services, users must comply with legal, professional, and cybersecurity standards to foster a safe and efficient hiring environment.', 1, '2025-02-13 09:09:05', '2025-02-13 09:29:55');
INSERT INTO `cf_pages` (`page_id`, `title`, `slug`, `description`, `keywords`, `summary`, `status`, `created_at`, `updated_at`) VALUES
(6, 'Employer guide', 'employer-guide', '<div class=\"container\"><h2 class=\"docs-header\">Top Skills- Experts - Employer Guide</h2></div><div class=\"container\"><ul><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#navigation\">Navigation</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#dashboard\">Dashboard</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#jobboard\">Job Board</a></li><li class=\"docs-nav\" style=\"height:600px;\"><strong>Team</strong></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_team\">Listing</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_team_actions\">Actions</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_team_roles\">Roles</a></li><li class=\"docs-nav\" style=\"height:600px;\"><strong>Jobs</strong></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_jobs\">Listing</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_jobs_actions\">Actions</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_jobs_filters\">Filters</a></li><li class=\"docs-nav\" style=\"height:600px;\"><strong>Departments</strong></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_departments\">Listing</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_departments_actions\">Actions</a></li><li class=\"docs-nav\" style=\"height:600px;\"><strong>Companies</strong></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_companies\">Listing</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_companies_actions\">Actions</a></li><li class=\"docs-nav\" style=\"height:600px;\"><strong>Quiz Designer</strong></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#quiz_questions\">Questions</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#quizes\">Quizes</a></li><li class=\"docs-nav\" style=\"height:600px;\"><strong>Interview Designer</strong></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#interview_questions\">Questions</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#interviews\">Interviews</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#interview_conduct\">Interview Conduct</a></li><li class=\"docs-nav\" style=\"height:600px;\"><strong>Traits</strong></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_traits\">Listing</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_traits_actions\">Actions</a></li><li class=\"docs-nav\" style=\"height:600px;\"><strong>Question Categories</strong></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_question_categories\">Listing</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_question_categories_actions\">Actions</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#listing_other_categories\">Other</a></li><li class=\"docs-nav\" style=\"height:600px;\"><strong>Settings</strong></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#setting_branding\">Branding</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#setting_custom_emails\">Custom Email Templates</a></li><li class=\"docs-nav\" style=\"height:600px;\"><a href=\"#setting_css\">Css</a></li><li class=\"docs-nav\" style=\"height:600px;\"> </li></ul><div class=\"docs-content\"><p>Top</p><div> </div><h3>Navigation</h3><p>The system is built together with a bunch of modules to acheive the intended results. Eeach item in a menu is a module to control different aspects of system. Below all the features are explained for what those can do and how you can use these.<a class=\"img-link\" href=\"images/employer-menu.jpg\"><img src=\"images/employer-menu.jpg\" alt=\"employer-menu.jpg\" /></a></p><div> </div><h3>Dashboard</h3><p>The dashboard gives you summary of the whole system in one picture. It has stats for total jobs, candidates and applications. There are charts and to do list for each team members. Dashboard can be accessed from the main navigation menu via the \"Dashboard\" item<a class=\"img-link\" href=\"images/dashboard.jpg\"><img src=\"images/dashboard.jpg\" alt=\"dashboard.jpg\" /></a></p><div> </div><h3>Job Board</h3><p>The Job Board is a unique feature with which you can do assesement and analysis against the applying candidates for a job. <strong>Left</strong> On left is the listing of all jobs. There is search and pagination with which you can filter through jobs. Click on any job title to view applying candidates for that job in the right section. <strong>Right</strong> On right is the listing of all candidates who have applied for the selected job.<a class=\"img-link\" href=\"images/job-board.png\"><img src=\"images/job-board.png\" alt=\"job-board.png\" /></a></p><p>There is a list of actions on right from where you can do several actions like marking candidates as shortilisted or hired. Also you can export their results for interviews or quizes. From here, interviews or quizes can be assigned to selected candidates. For these actions, you need to first select the records and then click on the resepection item in the \"Actions Menu\".<a class=\"img-link\" href=\"images/job-board-single.png\"><img src=\"images/job-board-single.png\" alt=\"job-board-single.png\" /></a></p><div> </div><h3>Team Listing</h3><p>Team listing is where you can see all the team members on the system with their roles. It can be accessed from the \"Team\" item in navigation menu. From this page, you can add, edit, delete a member. There are some advance filters integrated in this screen for the ease of use.</p><p><a class=\"img-link\" href=\"images/users-listing.png\"><img src=\"images/users-listing.png\" alt=\"users-listing.png\" /></a></p><div> </div><h3>Team Actions</h3><ol><li><strong>Create</strong> -&gt; A member can be created by clicking the blue \"Add Team Member\" button on top in the listing screen. On clicking this, a popup form will appear. Filling all the information will create the member</li><li><strong>Update</strong> -&gt; If you need to update a member, you can simply do so by clicking the \"blue pencil button\" on the corresponding member row in the listing screen. On clicking it, a popup form will appear. Filling all the information will update the member <a class=\"img-link\" href=\"images/users-single.jpg\"><img src=\"images/users-single.jpg\" alt=\"users-single.jpg\" /></a></li><li><strong>Delete</strong> -&gt; If you need to delete a member for some reason, you can simply do so by clicking the \"red trash button\" on the corresponding member row in the listing screen. On clicking it, a popup screen will appear for confirmation. On confirmation, the member will be permanently deleted.</li><li><strong>Activate/Deactivate</strong> -&gt; If you need to temporarily block a member from loggin in, you can simply do so by clicking the \'green/red\' button in the status column on the corresponding member row in the listing screen. On clicking it, the member will be activated or deactivated. This action is reversible and can be done as many times as you like. Also, this action can be done from the \"Bulk Action\" option by selecting multiple records at a time.</li><li><strong>Role Assignment</strong> -&gt; Roles can be assigned to some selected or all team members from the bulk actions feature. To do so, you have to first select some records in the listing screen and then click on \'Assign Role\' item in the actions menu. Clicking on the item will open a popup. From there you can select the desired role and assign to all or the selected ones. <a class=\"img-link\" href=\"images/assign-role.jpg\"><img src=\"images/assign-role.jpg\" alt=\"assign-role.jpg\" /></a></li></ol><div> </div><h3>Roles</h3><ol><li>There are around 70 permissions in the system to control team members access. Multiples roles can be created with all or selected permissions. These roles can then be assigned to team members from the create / edit or bulk action feature in the listing screen.</li></ol><div> </div><h3>Jobs Listing</h3><p>With the jobs module, you can create as many jobs as you like. Jobs listing shows you all jobs in system with the ability to activate/deactivate a job. It can be accessed from the \"Jobs -&gt; Listing\" from the navigation menu. There are a number of \"Bulk Actions\" and advance filters built in this screen to give you an ease of use.</p><p><a class=\"img-link\" href=\"images/jobs-listing.jpg\"><img src=\"images/jobs-listing.jpg\" alt=\"jobs-listing.jpg\" /></a></p><div> </div><h3>Jobs Actions</h3><ol><li><strong>Create</strong> -&gt; A job can be created by clicking the blue \"Add Job\" button on top in the listing screen. On clicking this, you\'ll be redirected to job creation screen. Fill all the information and click the save button to create the job.</li><li><strong>Update</strong> -&gt; If you need to update a job, you can simply do so by clicking the \"blue pencil button\" on the corresponding job row in the listing screen. On clicking it, you\'ll be redirected to job edit screen. Fill all the information and click on the save button to update the job. <a class=\"img-link\" href=\"images/job-single.png\"><img src=\"images/job-single.png\" alt=\"job-single.png\" /></a> </li><li><strong>Delete</strong> -&gt; If you need to delete a job for some reason, you can simply do so by clicking the \"red trash button\" on the corresponding job row in the listing screen. On clicking it, a popup screen will appear for confirmation. On confirmation, the job will be permanently deleted.</li><li><strong>Activate/Deactivate</strong> -&gt; If you need to temporarily deactivate a job, you can simply do so by clicking the \'green/red\' button in the \'Status Column\' on the corresponding job row in the listing screen. On clicking it, the job will be activated or deactivated. This action is reversible and can be done as many times as you like. Also, this action can be done from the \"Bulk Action\" option by selecting multiple records at a time.</li></ol><div> </div><h3>Filters</h3><ol><li><strong>Create</strong> -&gt; A job filter can be created by clicking the blue \"+\" button on top in the listing screen. On clicking this, a pop up screen will appear where you can enter title, select type and other preferencecs. Fill all the information and click the save button to create the job filter.</li><li><strong>Update</strong> -&gt; Then enter values against the created filter. <a class=\"img-link\" href=\"images/filters-2.jpg\"><img src=\"images/filters-2.jpg\" alt=\"filters-2.jpg\" /></a> </li><li><strong>Assign to Jobs</strong> -&gt; Once you are done creating filters and their values, you can assign these to jobs as indicated in the below image. <a class=\"img-link\" href=\"images/filters-3.jpg\"><img src=\"images/filters-3.jpg\" alt=\"filters-3.jpg\" /></a> </li></ol><div> </div><h3>Departments</h3><p>With the job departments module, you can create as many departments as you like. Departments listing shows you all departments in system with the ability to activate/deactivate. It can be accessed from the \"Jobs -&gt; Departments\" item in navigation menu. There are a number of \"Bulk Actions\" bu<a class=\"img-link\" href=\"images/filters-1.jpg\"><img src=\"images/filters-1.jpg\" alt=\"filters-1.jpg\" /></a>ilt in this screen to give you an ease of use. These departments will also appear on home page and jobs listing screen on front from where the candidates can filter jobs by department.</p><p><a class=\"img-link\" href=\"images/listing-departments.jpg\"><img src=\"images/listing-departments.jpg\" alt=\"listing-departments.jpg\" /></a></p><div> </div><h3>Departments Actions</h3><ol><li><strong>Create</strong> -&gt; A department can be created by clicking the blue \"Add Department\" button on top in the listing screen. On clicking this, a popup form will appear. Fill all the information and click on save button to create the department</li><li><strong>Update</strong> -&gt; If you need to update a department, you can simply do so by clicking the \"blue pencil button\" on the corresponding department row in the listing screen. On clicking it, the popup form will appear. Fill all the information and click on save button to update the department.<a class=\"img-link\" href=\"images/departments-single.jpg\"><img src=\"images/departments-single.jpg\" alt=\"departments-single.jpg\" /></a> </li><li><strong>Delete</strong> -&gt; If you need to delete a department for some reason, you can simply do so by clicking the \"red trash button\" on the corresponding department row in the listing screen. On clicking it, a popup screen will appear for confirmation. On confirmation, the job will be permanently deleted. </li><li><strong>Activate/Deactivate</strong> -&gt; If you need to temporarily deactivate a department, you can simply do so by clicking the \'green/red\' button in the \'Status Column\' on the corresponding job row in the listing screen. On clicking it, the department will be activated or deactivated. This action is reversible and can be done as many times as you like. Also, this action can be done from the \"Bulk Action\" option by selecting multiple records at a time.</li></ol><div> </div><h3>Companies</h3><p>With the job companies module, you can create as many companies as you like. Companies listing shows you all companies in system with the ability to activate/deactivate. It can be accessed from the \"Jobs -&gt; Companies\" item in navigation menu. There are a number of \"Bulk Actions\" built in this screen to give you an ease of use. The companies will also appear on jobs listing screen on front from where the candidates can filter jobs by company.</p><p><a class=\"img-link\" href=\"images/companies-listing.jpg\"><img src=\"images/companies-listing.jpg\" alt=\"companies-listing.jpg\" /></a></p><div> </div><h3>Companies Actions</h3><ol><li><strong>Create</strong> -&gt; A company can be created by clicking the blue \"Add Company\" button on top in the listing screen. On clicking this, a popup form will appear. Fill all the information and click on save button to create the company</li><li><strong>Update</strong> -&gt; If you need to update a company, you can simply do so by clicking the \"blue pencil button\" on the corresponding company row in the listing screen. On clicking it, the popup form will appear. Fill all the information and click on save button to update the company.<a class=\"img-link\" href=\"images/companies-single.jpg\"><img src=\"images/companies-single.jpg\" alt=\"companies-single.jpg\" /></a> </li><li><strong>Delete</strong> -&gt; If you need to delete a company for some reason, you can simply do so by clicking the \"red trash button\" on the corresponding company row in the listing screen. On clicking it, a popup screen will appear for confirmation. On confirmation, the job will be permanently deleted. </li><li><strong>Activate/Deactivate</strong> -&gt; If you need to temporarily deactivate a company, you can simply do so by clicking the \'green/red\' button in the \'Status Column\' on the corresponding job row in the listing screen. On clicking it, the company will be activated or deactivated. This action is reversible and can be done as many times as you like. Also, this action can be done from the \"Bulk Action\" option by selecting multiple records at a time.</li></ol><div> </div><h3>Quiz Designer</h3><p><a class=\"img-link\" href=\"images/quiz-designer.jpg\"><img src=\"images/quiz-designer.jpg\" alt=\"quiz-designer.jpg\" /></a></p><p>Quiz Designer screen is a unique one which has two sections </p><p><strong>Left</strong></p><p>There is question bank from where you can add / edit questions in the system. Questions can be added as \"Single Choice\" and \"Multiple Choice\". You just need to click on the \"Two Arrow\" button besides the \"Answers\" to switch between single and multi correct.When making \"multi correct\", you have to select multiple answers as correct, where as whem making \"single corect\", you have to select single answer as correct. Below you can see the action steps.</p><p><strong>Questions -&gt; Add </strong></p><p>A new question can be added by clicking the blue \"+\" button by the \"Questions Bank\" heading.</p><p><a class=\"img-link\" href=\"images/quiz-question-single-left.jpg\"><img src=\"images/quiz-question-single-left.jpg\" alt=\"quiz-question-single-left.jpg\" /></a></p><p>The \"+ Add\" button can be used to add as many options for a question as you like. Similarly the trash icon can be clicked against any answer to be deleted if not needed.</p><div> </div><p><strong>Right</strong></p><p>On right of the quiz designer screen is the \"Quizes\" section where as many quizes can be added by clicking on blue \"+\" button on top. Following screen will appear when you click the \"+\" button</p><p><a class=\"img-link\" href=\"images/quizes-single.jpg\"><img src=\"images/quizes-single.jpg\" alt=\"quizes-single.jpg\" /></a></p><p>Fill all the information and click on \"save\" button to create quiz.The newly created quiz will appear in the \"Select Quiz dropdown\". Now when the quiz is selected, any number of questions can be added from the questions bank to the selected quiz by \"DRAG AND DROP\".</p><p><a class=\"img-link\" href=\"images/quiz-drag.jpg\"><img src=\"images/quiz-drag.jpg\" alt=\"quiz-drag.jpg\" /></a></p><p>Note : Questions once added to the quiz can also be edited the same way as in the \"Questions Bank\" section. Editing the questions here will not affect the original questions in the questions bank.</p><p><strong>Edit / Delete Quiz</strong></p><p>A quiz can be edited or selected by the blue and red buttons besides the quiz drop down.</p><div> </div><h3>Interview Designer</h3><p><a class=\"img-link\" href=\"images/interview-designer.jpg\"><img src=\"images/interview-designer.jpg\" alt=\"interview-designer.jpg\" /></a></p><p>Interviews Designer screen has two sections similar to quiz designer </p><p><strong>Left</strong></p><p>There is question bank from where you can add / edit questions in the system. Below you can see the action steps.</p><p><strong>Questions -&gt; Add </strong></p><p>A new question can be added by clicking the blue \"+\" button by the \"Questions Bank\" heading.</p><p><a class=\"img-link\" href=\"images/interview-question-single.jpg\"><img src=\"images/interview-question-single.jpg\" alt=\"interview-question-single.jpg\" /></a></p><div> </div><p><strong>Right</strong></p><p>On right of the interview designer screen is the \"Interviews\" section where as many interviews can be added by clicking on blue \"+\" button on top. Following screen will appear when you click the \"+\" button</p><p><a class=\"img-link\" href=\"images/interview-single.jpg\"><img src=\"images/interview-single.jpg\" alt=\"interview-single.jpg\" /></a></p><p>Fill all the information and click on \"save\" button to create interview.The newly created interview will appear in the \"Select Interview dropdown\". Now when the interview is selected, any number of questions can be added from the questions bank to the selected interview by \"DRAG AND DROP\".</p><p>Note : Questions once added to the interview can also be edited the same way as in the \"Questions Bank\" section. Editing the questions here will not affect the original questions in the questions bank.</p><p><strong>Edit / Delete Interview</strong></p><p>A interview can be edited or selected by the blue and red buttons besides the interview drop down.</p><div> </div><p><strong>Interview Conducts</strong></p><p>The interviews first created from the \"Interview Designer\" module, after being assigned from job board against any job to a candidate will appear in the \"Interviews\" (3rd in the navigation) module. From there, the interviewer to whom the interview is assigned can do the markings against several interview questions.Once the interview markings are submitted, they will appear on the \"Job Board\" in the row of that particular candidate against the job.</p><p><a class=\"img-link\" href=\"images/interview-conduct.jpg\"><img src=\"images/interview-conduct.jpg\" alt=\"interview-conduct.jpg\" /></a></p><p>On clicking the \"View/Conduct\" button, a modal will appear where the interviewer can enter the marks and comments against all questions.Note : Interview pdfs can be downloaded from \"Interview Designer\"</p><div> </div><h3>Traits</h3><p>With the traits module, you can create as many traits as you like. Traits listing shows you all traits in system with the ability to activate/deactivate. It can be accessed from the \"Traits\" item in navigation menu. There are a number of \"Bulk Actions\" built in this screen to give you an ease of use.</p><p><a class=\"img-link\" href=\"images/traits-listing.jpg\"><img src=\"images/traits-listing.jpg\" alt=\"traits-listing.jpg\" /></a></p><div> </div><h3>Traits Actions</h3><ol><li><strong>Create</strong> -&gt; A department can be created by clicking the blue \"Add Department\" button on top in the listing screen. On clicking this, a popup form will appear. Fill all the information and click on save button to create the department</li><li><strong>Update</strong> -&gt; If you need to update a department, you can simply do so by clicking the \"blue pencil button\" on the corresponding department row in the listing screen. On clicking it, the popup form will appear. Fill all the information and click on save button to update the department.<a class=\"img-link\" href=\"images/traits-single.jpg\"><img src=\"images/traits-single.jpg\" alt=\"traits-single.jpg\" /></a> </li><li><strong>Delete</strong> -&gt; If you need to delete a department for some reason, you can simply do so by clicking the \"red trash button\" on the corresponding department row in the listing screen. On clicking it, a popup screen will appear for confirmation. On confirmation, the job will be permanently deleted. </li><li><strong>Activate/Deactivate</strong> -&gt; If you need to temporarily deactivate a department, you can simply do so by clicking the \'green/red\' button in the \'Status Column\' on the corresponding job row in the listing screen. On clicking it, the department will be activated or deactivated. This action is reversible and can be done as many times as you like. Also, this action can be done from the \"Bulk Action\" option by selecting multiple records at a time.</li></ol><div> </div><h3>Question Categories</h3><p>With the question categories module, you can create as many question categories as you like. Question Categories listing shows you all question categories in system with the ability to activate/deactivate. It can be accessed from the \"Question Categories\" item in navigation menu. There are a number of \"Bulk Actions\" built in this screen to give you an ease of use.  </p><p><a class=\"img-link\" href=\"images/question-categories-listing.jpg\"><img src=\"images/question-categories-listing.jpg\" alt=\"question-categories-listing.jpg\" /></a></p><div> </div><h3>Question Categories Actions</h3><ol><li><strong>Create</strong> -&gt; A category can be created by clicking the blue \"Add Question Category\" button on top in the listing screen. On clicking this, a popup form will appear. Fill all the information and click on save button to create the category</li><li><strong>Update</strong> -&gt; If you need to update a category, you can simply do so by clicking the \"blue pencil button\" on the corresponding category row in the listing screen. On clicking it, the popup form will appear. Fill all the information and click on save button to update the category. </li><li><strong>Delete</strong> -&gt; If you need to delete a category for some reason, you can simply do so by clicking the \"red trash button\" on the corresponding category row in the listing screen. On clicking it, a popup screen will appear for confirmation. On confirmation, the category will be permanently deleted. </li><li><strong>Activate/Deactivate</strong> -&gt; If you need to temporarily deactivate a category, you can simply do so by clicking the \'green/red\' button in the \'Status Column\' on the corresponding category row in the listing screen. On clicking it, the category will be activated or deactivated. This action is reversible and can be done as many times as you like. Also, this action can be done from the \"Bulk Action\" option by selecting multiple records at a time.</li></ol><div> </div><h3>Quiz &amp; Interview Categories</h3><p>All actions will be same as in the questions categories module.</p><div> </div><h3>Settings : Branding</h3><p><a class=\"img-link\" href=\"images/settings-branding.png\"><img src=\"images/settings-branding.png\" alt=\"settings-branding.png\" /></a> </p><p>An employer can edit these settings as their branding preferences but for these settings to take effects, branding feature need to be enabled in their current membership.</p><div> </div><h3>Settings : Home</h3><p><a class=\"img-link\" href=\"images/employer-setting-custom-email.png\"><img src=\"images/employer-setting-custom-email.png\" alt=\"employer-setting-custom-email.png\" /></a> </p><p>An employer can have custom emails and would be able to edit the template, if they have \"Custom Emails\" enabled in their membership.</p><div> </div><h3>Settings : Css</h3><p><a class=\"img-link\" href=\"images/settings-css.jpg\"><img src=\"images/settings-css.jpg\" alt=\"settings-css.jpg\" /></a> </p><p>Any custom css can be inserted here like font colors, background images etc. This is for the front end section only. This css will take effect if the employer have Branding enabled in their membership.</p></div></div> ', 'employer guide', 'employer user guide', 0, '2025-02-18 07:13:37', '2025-02-18 07:15:16');

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

--
-- Table structure for table `cf_permissions`
--

CREATE TABLE `cf_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `slug` varchar(100) DEFAULT NULL,
  `category` varchar(50) DEFAULT NULL,
  `type` varchar(20) DEFAULT 'employer'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cf_permissions`
--

INSERT INTO `cf_permissions` (`permission_id`, `title`, `slug`, `category`, `type`) VALUES
(1, 'View Dashboard Stats', 'view_dashboard_stats', 'Dashboard', 'admin'),
(2, 'View Sales chart', 'view_sales_chart', 'Dashboard', 'admin'),
(3, 'View Signups chart', 'view_signups_chart', 'Dashboard', 'admin'),
(4, 'View Jobs', 'view_jobs', 'Jobs', 'admin'),
(5, 'Create Jobs', 'create_jobs', 'Jobs', 'admin'),
(6, 'Edit Jobs', 'edit_jobs', 'Jobs', 'admin'),
(7, 'Delete Jobs', 'delete_jobs', 'Jobs', 'admin'),
(8, 'View Quizes', 'view_quizes', 'Quizes', 'admin'),
(9, 'Add Quizes', 'create_quizes', 'Quizes', 'admin'),
(10, 'Edit Quizes', 'edit_quizes', 'Quizes', 'admin'),
(11, 'Delete Quizes', 'delete_quizes', 'Quizes', 'admin'),
(12, 'View Interviews', 'view_interviews', 'Interviews', 'admin'),
(13, 'Add Interviews', 'create_interviews', 'Interviews', 'admin'),
(14, 'Edit Interviews', 'edit_interviews', 'Interviews', 'admin'),
(15, 'Delete Interviews', 'delete_interviews', 'Interviews', 'admin'),
(16, 'View Traites', 'view_traites', 'Traites', 'admin'),
(17, 'Create Traites', 'create_traites', 'Traites', 'admin'),
(18, 'Edit Traites', 'edit_traites', 'Traites', 'admin'),
(19, 'Delete Traites', 'delete_traites', 'Traites', 'admin'),
(20, 'View Packages', 'view_packages', 'Packages', 'admin'),
(21, 'Create Packages', 'create_package', 'Packages', 'admin'),
(22, 'Edit Packages', 'edit_package', 'Packages', 'admin'),
(23, 'Delete Packages', 'delete_package', 'Packages', 'admin'),
(24, 'View Memberships', 'view_memberships', 'Memberships', 'admin'),
(25, 'Create Memberships', 'create_membership', 'Memberships', 'admin'),
(26, 'Edit Memberships', 'edit_membership', 'Memberships', 'admin'),
(27, 'Delete Memberships', 'delete_membership', 'Memberships', 'admin'),
(28, 'View Testimonials', 'view_testimonials', 'Testimonials', 'admin'),
(29, 'Create Testimonials', 'create_testimonial', 'Testimonials', 'admin'),
(30, 'Edit Testimonials', 'edit_testimonial', 'Testimonials', 'admin'),
(31, 'Delete Testimonials', 'delete_testimonial', 'Testimonials', 'admin'),
(32, 'View Pages', 'view_pages', 'Pages', 'admin'),
(33, 'Create Pages', 'create_page', 'Pages', 'admin'),
(34, 'Edit Pages', 'edit_page', 'Pages', 'admin'),
(35, 'Delete Pages', 'delete_page', 'Pages', 'admin'),
(36, 'View Users Listing', 'view_user_listing', 'Users', 'admin'),
(37, 'Add Users', 'create_user', 'Users', 'admin'),
(38, 'Edit Users', 'edit_user', 'Users', 'admin'),
(39, 'Delete Users', 'delete_user', 'Users', 'admin'),
(40, 'View Roles', 'view_roles', 'Users', 'admin'),
(41, 'Add Role', 'create_role', 'Users', 'admin'),
(42, 'Edit Role', 'edit_role', 'Users', 'admin'),
(43, 'Delete Role', 'delete_role', 'Users', 'admin'),
(44, 'View Candidate Listing', 'view_candidate_listing', 'Candidates', 'admin'),
(45, 'Add Candidate', 'create_candidate', 'Candidates', 'admin'),
(46, 'Edit Candidate', 'edit_candidate', 'Candidates', 'admin'),
(47, 'Delete Candidate', 'delete_candidate', 'Candidates', 'admin'),
(48, 'Login as Candidate', 'login_as_candidate', 'Candidates', 'admin'),
(49, 'View Employer Listing', 'view_employer_listing', 'Employers', 'admin'),
(50, 'Add Employer', 'create_employer', 'Employers', 'admin'),
(51, 'Edit Employer', 'edit_employer', 'Employers', 'admin'),
(52, 'Delete Employer', 'delete_employer', 'Employers', 'admin'),
(53, 'Login as Employer', 'login_as_employer', 'Employers', 'admin'),
(54, 'View News Listing', 'view_news_listing', 'News', 'admin'),
(55, 'Add News', 'create_news', 'News', 'admin'),
(56, 'Edit News', 'edit_news', 'News', 'admin'),
(57, 'Delete News', 'delete_news', 'News', 'admin'),
(58, 'View News Categories', 'view_news_categories', 'News', 'admin'),
(59, 'Add News Categories', 'create_news_categories', 'News', 'admin'),
(60, 'Edit News Categories', 'edit_news_categories', 'News', 'admin'),
(61, 'Delete News Categories', 'delete_news_categories', 'News', 'admin'),
(62, 'View Faqs Listing', 'view_faqs_listing', 'News', 'admin'),
(63, 'Add Faqs', 'create_faqs', 'Faqs', 'admin'),
(64, 'Edit Faqs', 'edit_faqs', 'Faqs', 'admin'),
(65, 'Delete Faqs', 'delete_faqs', 'Faqs', 'admin'),
(66, 'View Faqs Categories', 'view_faqs_categories', 'Faqs', 'admin'),
(67, 'Add Faqs Categories', 'create_faqs_categories', 'Faqs', 'admin'),
(68, 'Edit Faqs Categories', 'edit_faqs_categories', 'Faqs', 'admin'),
(69, 'Delete Faqs Categories', 'delete_faqs_categories', 'Faqs', 'admin'),
(70, 'View Departments (admin)', 'admin_view_departments', 'Departments (Admin)', 'admin'),
(71, 'Create Departments (admin)', 'admin_create_departments', 'Departments (Admin)', 'admin'),
(72, 'Edit Departments (admin)', 'admin_edit_departments', 'Departments (Admin)', 'admin'),
(73, 'Delete Departments (admin)', 'admin_delete_departments', 'Departments (Admin)', 'admin'),
(74, 'View Job Filters', 'admin_view_job_filters', 'Job Filters (Admin)', 'admin'),
(75, 'Create Job Filters', 'admin_create_job_filters', 'Job Filters (Admin)', 'admin'),
(76, 'Edit Job Filters', 'admin_edit_job_filters', 'Job Filters (Admin)', 'admin'),
(77, 'Delete Job Filters', 'admin_delete_job_filters', 'Job Filters (Admin)', 'admin'),
(78, 'Home Page', 'home_page_settings', 'CMS', 'admin'),
(79, 'Menu', 'menu_settings', 'CMS', 'admin'),
(80, 'View Messages Listing', 'view_messages_listing', 'CMS', 'admin'),
(81, 'Job Portal Vs SaaS', 'portal_vs_multitenancy', 'Settings', 'admin'),
(82, 'General', 'general_settings', 'Settings', 'admin'),
(83, 'Display', 'display_settings', 'Settings', 'admin'),
(84, 'Emails', 'email_settings', 'Settings', 'admin'),
(85, 'Email Templates', 'email_template_settings', 'Settings', 'admin'),
(86, 'Apis', 'apis_settings', 'Settings', 'admin'),
(87, 'Css', 'css_settings', 'Settings', 'admin'),
(88, 'Languages', 'languages_settings', 'Settings', 'admin'),
(89, 'Roles', 'roles_settings', 'Settings', 'admin'),
(90, 'Refresh Memberships', 'refresh_memberships', 'Settings', 'admin'),
(91, 'Employer Overrides', 'employer_override_settings', 'Settings', 'admin'),
(92, 'View Dashboard Stats', 'view_dashboard_stats', 'Dashboard', 'employer'),
(93, 'View Job chart', 'view_job_chart', 'Dashboard', 'employer'),
(94, 'View Candidate chart', 'view_candidate_chart', 'Dashboard', 'employer'),
(95, 'View Jobs Status', 'view_jobs_status', 'Dashboard', 'employer'),
(96, 'To Do List', 'to_do_list', 'Dashboard', 'employer'),
(97, 'View Job Board', 'view_job_board', 'Job Board', 'employer'),
(98, 'Actions Job Board', 'actions_job_board', 'Job Board', 'employer'),
(99, 'View & Conduct Interviews', 'view_conduct_interviews', 'Interviews', 'employer'),
(100, 'View Jobs', 'view_jobs', 'Jobs', 'employer'),
(101, 'Create Jobs', 'create_jobs', 'Jobs', 'employer'),
(102, 'Edit Jobs', 'edit_jobs', 'Jobs', 'employer'),
(103, 'Delete Jobs', 'delete_jobs', 'Jobs', 'employer'),
(104, 'View Job Filters', 'view_job_filters', 'Job Filters', 'employer'),
(105, 'Create Job Filters', 'create_job_filters', 'Job Filters', 'employer'),
(106, 'Edit Job Filters', 'edit_job_filters', 'Job Filters', 'employer'),
(107, 'Delete Job Filters', 'delete_job_filters', 'Job Filters', 'employer'),
(108, 'View Departments', 'view_departments', 'Departments', 'employer'),
(109, 'Create Departments', 'create_departments', 'Departments', 'employer'),
(110, 'Edit Departments', 'edit_departments', 'Departments', 'employer'),
(111, 'Delete Departments', 'delete_departments', 'Departments', 'employer'),
(112, 'View Quiz Questions', 'view_quiz_questions', 'Quizes', 'employer'),
(113, 'Edit Quiz Questions', 'edit_quiz_questions', 'Quizes', 'employer'),
(114, 'Delete Quiz Questions', 'delete_quiz_questions', 'Quizes', 'employer'),
(115, 'View Quizes', 'view_quizes', 'Quizes', 'employer'),
(116, 'Add Quizes', 'create_quizes', 'Quizes', 'employer'),
(117, 'Edit Quizes', 'edit_quizes', 'Quizes', 'employer'),
(118, 'Delete Quizes', 'delete_quizes', 'Quizes', 'employer'),
(119, 'Clone Quizes', 'clone_quizes', 'Quizes', 'employer'),
(120, 'Download Quizes', 'download_quizes', 'Quizes', 'employer'),
(121, 'View Interview Questions', 'view_interview_questions', 'Interviews', 'employer'),
(122, 'Edit Interview Questions', 'edit_interview_questions', 'Interviews', 'employer'),
(123, 'Delete Interview Questions', 'delete_interview_questions', 'Interviews', 'employer'),
(124, 'View Interviews', 'view_interviews', 'Interviews', 'employer'),
(125, 'Add Interviews', 'create_interviews', 'Interviews', 'employer'),
(126, 'Edit Interviews', 'edit_interviews', 'Interviews', 'employer'),
(127, 'Delete Interviews', 'delete_interviews', 'Interviews', 'employer'),
(128, 'Clone Interviews', 'clone_interviews', 'Interviews', 'employer'),
(129, 'Download Interviews', 'download_interviews', 'Interviews', 'employer'),
(130, 'All Candidate Interviews', 'all_candidate_interviews', 'Interviews', 'employer'),
(131, 'View Traites', 'view_traites', 'Traites', 'employer'),
(132, 'Create Traites', 'create_traites', 'Traites', 'employer'),
(133, 'Edit Traites', 'edit_traites', 'Traites', 'employer'),
(134, 'Delete Traites', 'delete_traites', 'Traites', 'employer'),
(135, 'View Question Categories', 'view_question_categories', 'Question Categories', 'employer'),
(136, 'Create Question Categories', 'create_question_categories', 'Question Categories', 'employer'),
(137, 'Edit Question Categories', 'edit_question_categories', 'Question Categories', 'employer'),
(138, 'Delete Question Categories', 'delete_question_categories', 'Question Categories', 'employer'),
(139, 'View Quiz Categories', 'view_quiz_categories', 'Quiz Categories', 'employer'),
(140, 'Create Quiz Categories', 'create_quiz_categories', 'Quiz Categories', 'employer'),
(141, 'Edit Quiz Categories', 'edit_quiz_categories', 'Quiz Categories', 'employer'),
(142, 'Delete Quiz Categories', 'delete_quiz_categories', 'Quiz Categories', 'employer'),
(143, 'View Interview Categories', 'view_interview_categories', 'Interview Categories', 'employer'),
(144, 'Create Interview Categories', 'create_interview_categories', 'Interview Categories', 'employer'),
(145, 'Edit Interview Categories', 'edit_interview_categories', 'Interview Categories', 'employer'),
(146, 'Delete Interview Categories', 'delete_interview_categories', 'Interview Categories', 'employer'),
(147, 'View Questions', 'view_questions', 'Questions', 'employer'),
(148, 'Create Questions', 'create_questions', 'Questions', 'employer'),
(149, 'Edit Questions', 'edit_questions', 'Questions', 'employer'),
(150, 'Delete Questions', 'delete_questions', 'Questions', 'employer'),
(151, 'View Team Listing', 'view_team_listing', 'Team', 'employer'),
(152, 'Add Team Member', 'create_team_member', 'Team', 'employer'),
(153, 'Edit Team Member', 'edit_team_member', 'Team', 'employer'),
(154, 'Delete Team Member', 'delete_team_member', 'Team', 'employer'),
(155, 'View Roles', 'view_roles', 'Team', 'employer'),
(156, 'Add Role', 'create_role', 'Team', 'employer'),
(157, 'Edit Role', 'edit_role', 'Team', 'employer'),
(158, 'Delete Role', 'delete_role', 'Team', 'employer'),
(159, 'View Candidate Listing', 'view_candidate_listing', 'Candidates', 'employer'),
(160, 'Email Candidates', 'email_candidates', 'Candidates', 'employer'),
(161, 'View Blog Listing', 'view_blog_listing', 'Blog', 'employer'),
(162, 'Add Blog', 'create_blog', 'Blog', 'employer'),
(163, 'Edit Blog', 'edit_blog', 'Blog', 'employer'),
(164, 'Delete Blog', 'delete_blog', 'Blog', 'employer'),
(165, 'View Blog Categories', 'view_blog_categories', 'Blog', 'employer'),
(166, 'Add Blog Categories', 'create_blog_categories', 'Blog', 'employer'),
(167, 'Edit Blog Categories', 'edit_blog_categories', 'Blog', 'employer'),
(168, 'Delete Blog Categories', 'delete_blog_categories', 'Blog', 'employer'),
(169, 'View Memberships', 'view_memberships', 'Memberships', 'employer'),
(170, 'Create Memberships', 'create_memberships', 'Memberships', 'employer'),
(171, 'General', 'general', 'Settings', 'employer'),
(172, 'Branding', 'branding', 'Settings', 'employer'),
(173, 'Emails', 'emails', 'Settings', 'employer'),
(174, 'Css', 'css', 'Settings', 'employer');

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

--
-- Table structure for table `cf_questions`
--

CREATE TABLE `cf_questions` (
  `question_id` bigint(20) UNSIGNED NOT NULL,
  `question_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` text DEFAULT NULL,
  `image` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `nature` varchar(20) DEFAULT 'quiz',
  `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 `cf_questions`
--

INSERT INTO `cf_questions` (`question_id`, `question_category_id`, `employer_id`, `title`, `image`, `type`, `nature`, `created_at`, `updated_at`) VALUES
(3, 2, 2, 'A computer basically constitutes of _______ integral components', NULL, NULL, 'quiz', '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(4, 2, 2, 'Computers have secondary storage devices known as', NULL, NULL, 'quiz', '2025-01-28 11:51:10', '2025-01-28 11:51:10');

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

--
-- Table structure for table `cf_question_answers`
--

CREATE TABLE `cf_question_answers` (
  `question_answer_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `question_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `is_correct` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cf_question_answers`
--

INSERT INTO `cf_question_answers` (`question_answer_id`, `employer_id`, `question_id`, `title`, `is_correct`) VALUES
(1, NULL, 1, 'Two', 0),
(2, NULL, 1, 'Four', 0),
(3, NULL, 1, 'Three', 1),
(4, NULL, 1, 'Eight', 0),
(5, NULL, 2, 'ALU', 0),
(6, NULL, 2, 'Auxiliary Storage', 1),
(7, NULL, 2, 'CPU', 0),
(8, NULL, 2, 'None of the above', 0),
(9, NULL, 3, 'Two', 0),
(10, NULL, 3, 'Four', 0),
(11, NULL, 3, 'Three', 1),
(12, NULL, 3, 'Eight', 0),
(13, NULL, 4, 'ALU', 0),
(14, NULL, 4, 'Auxiliary Storage', 1),
(15, NULL, 4, 'CPU', 0),
(16, NULL, 4, 'None of the above', 0);

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

--
-- Table structure for table `cf_question_categories`
--

CREATE TABLE `cf_question_categories` (
  `question_category_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `status` tinyint(4) 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 `cf_question_categories`
--

INSERT INTO `cf_question_categories` (`question_category_id`, `employer_id`, `title`, `status`, `created_at`, `updated_at`) VALUES
(2, 2, 'General', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10');

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

--
-- Table structure for table `cf_quizes`
--

CREATE TABLE `cf_quizes` (
  `quiz_id` bigint(20) UNSIGNED NOT NULL,
  `quiz_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(150) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `allowed_time` int(11) NOT NULL,
  `status` tinyint(4) 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 `cf_quizes`
--

INSERT INTO `cf_quizes` (`quiz_id`, `quiz_category_id`, `employer_id`, `title`, `description`, `allowed_time`, `status`, `created_at`, `updated_at`) VALUES
(3, 2, 2, 'Marketing Position Quiz', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 30, 0, '2025-01-28 11:51:10', '2025-02-11 06:25:17'),
(4, 2, 2, 'General Knowledge Quiz', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.', 30, 0, '2025-01-28 11:51:10', '2025-02-18 10:35:41');

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

--
-- Table structure for table `cf_quiz_categories`
--

CREATE TABLE `cf_quiz_categories` (
  `quiz_category_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `status` tinyint(4) 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 `cf_quiz_categories`
--

INSERT INTO `cf_quiz_categories` (`quiz_category_id`, `employer_id`, `title`, `status`, `created_at`, `updated_at`) VALUES
(2, 2, 'General', 1, '2025-01-28 11:51:10', '2025-01-28 11:51:10');

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

--
-- Table structure for table `cf_quiz_questions`
--

CREATE TABLE `cf_quiz_questions` (
  `quiz_question_id` bigint(20) UNSIGNED NOT NULL,
  `quiz_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `image` varchar(250) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL,
  `order` tinyint(4) 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 `cf_quiz_questions`
--

INSERT INTO `cf_quiz_questions` (`quiz_question_id`, `quiz_id`, `employer_id`, `title`, `image`, `type`, `order`, `created_at`, `updated_at`) VALUES
(3, 4, 2, 'A computer basically constitutes of _______ integral components', NULL, 'radio', 0, '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(4, 4, 2, 'Computers have secondary storage devices known as', NULL, 'radio', 0, '2025-01-28 11:51:10', '2025-01-28 11:51:10');

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

--
-- Table structure for table `cf_quiz_question_answers`
--

CREATE TABLE `cf_quiz_question_answers` (
  `quiz_question_answer_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `quiz_question_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `is_correct` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cf_quiz_question_answers`
--

INSERT INTO `cf_quiz_question_answers` (`quiz_question_answer_id`, `employer_id`, `quiz_question_id`, `title`, `is_correct`) VALUES
(1, NULL, 1, 'Two', 0),
(2, NULL, 1, 'Four', 0),
(3, NULL, 1, 'Three', 1),
(4, NULL, 1, 'Eight', 0),
(5, NULL, 2, 'ALU', 0),
(6, NULL, 2, 'Auxiliary Storage', 1),
(7, NULL, 2, 'CPU', 0),
(8, NULL, 2, 'None of the above', 0),
(9, NULL, 3, 'Two', 0),
(10, NULL, 3, 'Four', 0),
(11, NULL, 3, 'Three', 1),
(12, NULL, 3, 'Eight', 0),
(13, NULL, 4, 'ALU', 0),
(14, NULL, 4, 'Auxiliary Storage', 1),
(15, NULL, 4, 'CPU', 0),
(16, NULL, 4, 'None of the above', 0);

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

--
-- Table structure for table `cf_resumes`
--

CREATE TABLE `cf_resumes` (
  `resume_id` bigint(20) UNSIGNED NOT NULL,
  `candidate_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `designation` varchar(100) DEFAULT NULL,
  `objective` text DEFAULT NULL,
  `type` varchar(30) DEFAULT 'detailed',
  `file` varchar(255) DEFAULT NULL,
  `experience` int(11) DEFAULT 0,
  `experiences` int(11) DEFAULT 0,
  `qualifications` int(11) DEFAULT 0,
  `languages` int(11) DEFAULT 0,
  `achievements` int(11) DEFAULT 0,
  `references` int(11) DEFAULT 0,
  `skills` int(11) NOT NULL DEFAULT 0,
  `is_default` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(4) 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 `cf_resumes`
--

INSERT INTO `cf_resumes` (`resume_id`, `candidate_id`, `title`, `designation`, `objective`, `type`, `file`, `experience`, `experiences`, `qualifications`, `languages`, `achievements`, `references`, `skills`, `is_default`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'My Resume', 'My Designation', 'My Objective', 'detailed', NULL, 0, 0, 0, 0, 0, 0, 0, 1, 1, '2023-05-10 18:24:24', '2023-05-10 18:24:24');

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

--
-- Table structure for table `cf_resume_achievements`
--

CREATE TABLE `cf_resume_achievements` (
  `resume_achievement_id` bigint(20) UNSIGNED NOT NULL,
  `resume_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `description` text 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 `cf_resume_experiences`
--

CREATE TABLE `cf_resume_experiences` (
  `resume_experience_id` bigint(20) UNSIGNED NOT NULL,
  `resume_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `from` datetime DEFAULT NULL,
  `to` datetime DEFAULT NULL,
  `description` text DEFAULT NULL,
  `is_current` tinyint(4) 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 `cf_resume_languages`
--

CREATE TABLE `cf_resume_languages` (
  `resume_language_id` bigint(20) UNSIGNED NOT NULL,
  `resume_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `proficiency` varchar(100) 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 `cf_resume_qualifications`
--

CREATE TABLE `cf_resume_qualifications` (
  `resume_qualification_id` bigint(20) UNSIGNED NOT NULL,
  `resume_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `institution` varchar(100) DEFAULT NULL,
  `marks` double(15,8) DEFAULT NULL,
  `out_of` varchar(100) DEFAULT NULL,
  `from` datetime DEFAULT NULL,
  `to` datetime 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 `cf_resume_references`
--

CREATE TABLE `cf_resume_references` (
  `resume_reference_id` bigint(20) UNSIGNED NOT NULL,
  `resume_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `relation` varchar(100) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `email` varchar(100) 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 `cf_resume_skills`
--

CREATE TABLE `cf_resume_skills` (
  `resume_skill_id` bigint(20) UNSIGNED NOT NULL,
  `resume_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `proficiency` varchar(100) 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 `cf_roles`
--

CREATE TABLE `cf_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `type` varchar(20) DEFAULT 'admin',
  `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 `cf_roles`
--

INSERT INTO `cf_roles` (`role_id`, `employer_id`, `title`, `type`, `created_at`, `updated_at`) VALUES
(1, 0, 'Admin', 'employer', '2023-05-09 18:10:47', NULL),
(2, 0, 'Interviewer', 'employer', '2023-05-09 18:26:40', NULL),
(3, 0, 'Super Admin', 'admin', '2023-05-09 18:28:12', '2023-05-09 18:28:34'),
(8, 0, 'Site Controller', 'admin', '2023-05-30 17:50:18', '2023-05-30 17:52:14'),
(9, 0, 'News Manager', 'admin', '2023-05-30 17:54:00', NULL),
(10, 0, 'Blog Manager', 'employer', '2023-05-30 17:54:51', '2023-05-30 17:55:04'),
(11, 0, 'Interviewer', 'employer', '2023-05-30 17:55:28', NULL),
(12, 0, 'Admin', 'employer', '2023-05-30 17:55:48', NULL),
(13, 2, 'Admin', 'employer', '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(14, 2, 'Interviewer', 'employer', '2025-01-28 11:51:10', '2025-01-28 11:51:10'),
(15, 2, 'Blog Manager', 'employer', '2025-01-28 11:51:10', '2025-01-28 11:51:10');

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

--
-- Table structure for table `cf_role_permissions`
--

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

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

--
-- Table structure for table `cf_search_logs`
--

CREATE TABLE `cf_search_logs` (
  `search_log_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `count` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cf_search_logs`
--

INSERT INTO `cf_search_logs` (`search_log_id`, `title`, `count`, `created_at`) VALUES
(1, 'marketing', 3, '2025-02-14 11:36:21'),
(2, 'software engineer', 0, '2025-02-15 13:00:02'),
(3, 'loremipsum0.589989012421068', 0, '2025-10-12 23:31:42'),
(4, 'fucidin', 1, '2025-10-12 23:32:46'),
(5, 'texas longhorns', 1, '2025-10-12 23:33:47'),
(6, 'innovative skincare clinical', 3, '2025-10-12 23:34:47'),
(7, 'fendi', 1, '2025-10-12 23:35:50'),
(8, 'chanel', 1, '2025-10-12 23:36:48'),
(9, 'loremipsum0.4033135873202165', 0, '2026-02-21 21:08:07');

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

--
-- Table structure for table `cf_sessions`
--

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

--
-- Dumping data for table `cf_sessions`
--

INSERT INTO `cf_sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('0z2gckF50XIB6cH4WGEzSZWbw5V9go3CCZSbGAnH', NULL, '205.169.39.20', 'Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiejJ1YUswbWxnQjFsSnc5VHNCTUtqNmxyZWJic2FIMGx3bDRxZ0h0UiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vdG9wc2tpbGxzLWV4cGVydHMuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1782738524),
('10WU2hCb0zv9VAOeXwobTTAo80LiN1GGZyOpFxs7', NULL, '91.224.92.87', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiU0J5Rk5aNGx3ZklhamRObDVod0oyQkliZU5OT01jcFk3ckgyMmxadiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDU6Imh0dHA6Ly93d3cudG9wc2tpbGxzLWV4cGVydHMuY29tL3B1YmxpYy9hYm91dCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1782744576),
('81qIvtHpVvJa0VmbOQk2ncwbj2epKWBb0rxYgb2y', NULL, '20.63.8.12', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOW5xVEZ1dG5BMnF5TnlQd1ZyOTJMTGoyUjlpbldXbVZWdk1Gc1FKNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjM6Imh0dHA6Ly9tYWlsLnRvcHNraWxscy1leHBlcnRzLmNvbS90aGlzX2lzX2FfbmV3X2hlbGxvX3dvcmxkLnBocCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1782739815),
('BXdVCeJwEFhRuAwhgC252YgAjuw68DnNIt7UxfQW', NULL, '20.215.65.5', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZDVOVWt2VG8yaUR1RFBYQUY1ZEZhVGlrWmxKR0t4dFVsd3FqeXlvbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly90b3Bza2lsbHMtZXhwZXJ0cy5jb20vcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1782738036),
('Ffq1JFE2spUMmxImhbyea2Veqd0ZrS31uDykmgJg', NULL, '20.215.65.5', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNVVvd0VkMENUbWM3azVRUVF2SEdaWGd3VmxpOThvVU9nVEgzb2VUMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly90b3Bza2lsbHMtZXhwZXJ0cy5jb20vcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1782737916),
('FrmSKJWFY1lLyAzCglBmjytQWmlhdn5AkltgrMRH', NULL, '20.63.8.12', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUWRHRFdKdmRwZFpVeTNrWW9EWk5TYldOR3JWbmFlVmQwUlNRMUVwNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly90b3Bza2lsbHMtZXhwZXJ0cy5jb20vcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1782739887),
('g2CbKnnI5WVHdrWObM3QhXb7GZNML9MQIpUTnCCK', NULL, '20.63.8.12', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMGt6V2lYMHd0RlladkZodURUMzZEZ2dpeXF1WUJBTHJlcVdnSklCaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9tYWlsLnRvcHNraWxscy1leHBlcnRzLmNvbS9sb2FkLnBocCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1782739886),
('IXgXEAGJLNfP9V61JIwOCDzajE7atZmEnoQgsZNL', NULL, '20.215.65.5', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNWYyUWVhOEk2OUZzZXVDVUpId2M4UWpRdXN6eDk1WDk4TmNUT0tUdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDY6Imh0dHA6Ly9tYWlsLnRvcHNraWxscy1leHBlcnRzLmNvbS93cC1saW5rcy5waHAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1782738036),
('j32NmcUEpfAvqXa0d4c5UpLGys8vc07nq67auYS1', NULL, '43.157.67.70', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTGpDODlSSWFybFp2ZWF6WEZuMjhnakwyQVd2Y2VEWEJabXY0cGFiTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly93d3cudG9wc2tpbGxzLWV4cGVydHMuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1782733437),
('jbrsFWyfzqX6tTDNc2QvOZRLmj9Ou5EU5uuGalv7', NULL, '52.167.144.183', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicmt2R2JzdmxiZ1lkRDgxR255Q3M0emhYTzN3TzFjNGhURFc1OWlvRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly90b3Bza2lsbHMtZXhwZXJ0cy5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1782743751),
('koKJN1wytghnQWRFkXC6D9QXHwhD15jtXOzWAWRy', NULL, '43.133.220.37', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ1ptTUpHNWdZVWI2UUI2RVk4UjR3YU5OdFlNdkdCTHhsaEJDVjRsaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vdG9wc2tpbGxzLWV4cGVydHMuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1782742052),
('rgi02KlRnyP4lxjz70wXpxyiHRF64uLWFPxeKHzE', NULL, '170.106.35.153', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYWtpNEd4emhtQUlDOTdjRThkUjJFZERrTldoSE5rMW9xdmxXSE52ayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly90b3Bza2lsbHMtZXhwZXJ0cy5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1782745080),
('rnz38Hoh1Jb4FEO0mF2T7tEJO7fK3QHYSjPsizbn', NULL, '43.135.211.148', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiU3B6ZzU3dFVtM1dxeDNsSnBLVWxaQnVsQ0lmMDFjZ2E3VTVFVHduUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly93d3cudG9wc2tpbGxzLWV4cGVydHMuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1782748256),
('RWmqBoZsm8yZnnngzJp6jM6BvVvN6KFSIiTxnVIa', NULL, '216.244.66.201', 'Mozilla/5.0 (compatible; DotBot/1.2; +https://opensiteexplorer.org/dotbot; help@moz.com)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoicDkyZXRqZnBvRGhZc3hSZW13TlRqMkZlcWNDSW5wMEsxZzloQ3dpaiI7czo4OiJzbHVnX2VtcCI7YTozOTp7czoxMToiZW1wbG95ZXJfaWQiO2k6MjtzOjk6InBhcmVudF9pZCI7TjtzOjc6ImNvbXBhbnkiO3M6MTU6IlNhYmV0aSBBeWFuIEluYyI7czo0OiJzbHVnIjtzOjE1OiJzYWJldGktYXlhbi1pbmMiO3M6MTA6ImZpcnN0X25hbWUiO3M6NjoiU2FiZXRpIjtzOjk6Imxhc3RfbmFtZSI7czo0OiJBeWFuIjtzOjEyOiJlbXBsb3llcm5hbWUiO3M6MjY6InNhYmV0aS1heWFuLWluYy0xNzM4MDcyMjcwIjtzOjU6ImVtYWlsIjtzOjE5OiJpbmZvQHNhYmV0aWF5YW4uY29tIjtzOjg6InBhc3N3b3JkIjtzOjYwOiIkMnkkMTAkQVhicG9xRi42aGhNbXQwQ0EvSm0vLkdTZ3JvSlovSnFiUnVFN1dFcHFOSFZWaXc2LlplSlciO3M6NToiaW1hZ2UiO047czo0OiJsb2dvIjtOO3M6NjoicGhvbmUxIjtzOjA6IiI7czo2OiJwaG9uZTIiO3M6MDoiIjtzOjQ6ImNpdHkiO047czo1OiJzdGF0ZSI7TjtzOjc6ImNvdW50cnkiO047czo3OiJhZGRyZXNzIjtOO3M6NjoiZ2VuZGVyIjtOO3M6MzoiZG9iIjtOO3M6MTc6InNob3J0X2Rlc2NyaXB0aW9uIjtzOjM3OiJOZXcgQWdlIHZhc3QgdGVjaG5vbG9neS1iYXNlZCBjb21wYW55IjtzOjM6InVybCI7TjtzOjE1OiJub19vZl9lbXBsb3llZXMiO047czo4OiJpbmR1c3RyeSI7TjtzOjEwOiJmb3VuZGVkX2luIjtOO3M6MTI6InR3aXR0ZXJfbGluayI7TjtzOjEzOiJmYWNlYm9va19saW5rIjtOO3M6MTQ6Imluc3RhZ3JhbV9saW5rIjtOO3M6MTE6Imdvb2dsZV9saW5rIjtOO3M6MTM6ImxpbmtlZGluX2xpbmsiO047czoxMjoieW91dHViZV9saW5rIjtOO3M6MTI6ImFjY291bnRfdHlwZSI7czo0OiJzaXRlIjtzOjExOiJleHRlcm5hbF9pZCI7TjtzOjQ6InR5cGUiO3M6NDoibWFpbiI7czo2OiJzdGF0dXMiO2k6MDtzOjU6InRva2VuIjtOO3M6MTA6ImNyZWF0ZWRfYXQiO3M6Mjc6IjIwMjUtMDEtMjhUMTM6NTE6MTAuMDAwMDAwWiI7czoxMDoidXBkYXRlZF9hdCI7czoyNzoiMjAyNS0xMi0wNlQxMDozMDozNC4wMDAwMDBaIjtzOjExOiJpbmR1c3RyeV9pZCI7TjtzOjEzOiJzZXBhcmF0ZV9zaXRlIjtpOjE7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjg5OiJodHRwOi8vdG9wc2tpbGxzLWV4cGVydHMuY29tL3B1YmxpYy9zYWJldGktYXlhbi1pbmMvYmxvZy9OVzVVY2tvd2QzWm1lVU00UjA0cmFWcEZVekZFWnowOSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1782738553),
('T6F9yC5e7FSfxbESOGIGrSChLZzfjARrZqOQ8uzB', NULL, '20.63.8.12', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSU54NW9BY2pjWFdDSmlVZUpRR0RFU3F6ZFRBWWpjVXEwVlBwcGM2WSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly90b3Bza2lsbHMtZXhwZXJ0cy5jb20vcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1782739826),
('ud4Gts2OKpqWuPZWQRt8qaRBVlnmeR9jAAcgLgT3', NULL, '43.157.158.178', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWkdsQTd4WUxDU1VITkJYaG4zTzN0TDkzT2dmU3JWekhpelpPOVBSQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly90b3Bza2lsbHMtZXhwZXJ0cy5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1782738965),
('ug3PmlaHm5OSXGYIoIB6pvw6uqSlDWELITvtbEKh', NULL, '43.163.86.65', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibHpvY1g2VlBVcHlBZ0NNVzFvQUpjQ0pxVmVDU2dlcXliaWpCdGQxayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly90b3Bza2lsbHMtZXhwZXJ0cy5jb20vcHJpY2luZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1782750791),
('uLaB2rWw7WBkpcNaXH8LMhDAw8gCTUQBVkE9dyXa', NULL, '43.136.86.241', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWjFaRDQyNGFpUG5vdzhqak85NmFGMk05ZEJvMG5Cc0tZODRoaFBaUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly90b3Bza2lsbHMtZXhwZXJ0cy5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1782750552),
('WQyvFIjo1zmBphvIocCwLLh6bYJSxlwrmwSOEqKB', NULL, '20.215.65.5', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRVBSUFdmNHFzV1BwZUhIV2RnR2RFT1ZSeHVWTG0yWURWNmx5amxFQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjM6Imh0dHA6Ly9tYWlsLnRvcHNraWxscy1leHBlcnRzLmNvbS90aGlzX2lzX2FfbmV3X2hlbGxvX3dvcmxkLnBocCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1782737913),
('Ypm5wKKTReyGPzBkHpDyM6gTQCigZFN1UWViBhzL', NULL, '34.224.5.136', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieWFtVDEyM2I2Y1hjMTF6TjRQazhVMFlxbldoaU10bmlkS2VTN3owYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vd3d3LnRvcHNraWxscy1leHBlcnRzLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1782739135);

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

--
-- Table structure for table `cf_testimonials`
--

CREATE TABLE `cf_testimonials` (
  `testimonial_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` text DEFAULT NULL,
  `rating` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `cf_to_dos`
--

CREATE TABLE `cf_to_dos` (
  `to_do_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(150) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `cf_traites`
--

CREATE TABLE `cf_traites` (
  `traite_id` bigint(20) UNSIGNED NOT NULL,
  `employer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `cf_updates`
--

CREATE TABLE `cf_updates` (
  `update_id` bigint(20) UNSIGNED NOT NULL,
  `version` varchar(50) DEFAULT NULL,
  `title` varchar(150) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `files` text DEFAULT NULL,
  `released_at` datetime DEFAULT NULL,
  `is_current` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(4) 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;

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

--
-- Table structure for table `cf_user_roles`
--

CREATE TABLE `cf_user_roles` (
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `role_id` bigint(20) UNSIGNED DEFAULT NULL,
  `id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cf_user_roles`
--

INSERT INTO `cf_user_roles` (`user_id`, `role_id`, `id`) VALUES
(2, 9, 1),
(2, 8, 2),
(2, 3, 3),
(3, 8, 4);

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

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

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

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

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

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

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cf_blogs`
--
ALTER TABLE `cf_blogs`
  ADD PRIMARY KEY (`blog_id`),
  ADD KEY `idx_employer_id` (`employer_id`),
  ADD KEY `idx_category_id` (`blog_category_id`);

--
-- Indexes for table `cf_blog_categories`
--
ALTER TABLE `cf_blog_categories`
  ADD PRIMARY KEY (`blog_category_id`);

--
-- Indexes for table `cf_candidate_favorites`
--
ALTER TABLE `cf_candidate_favorites`
  ADD KEY `idx_candidate_id` (`candidate_id`);

--
-- Indexes for table `cf_candidate_interviews`
--
ALTER TABLE `cf_candidate_interviews`
  ADD PRIMARY KEY (`candidate_interview_id`);

--
-- Indexes for table `cf_candidate_memberships`
--
ALTER TABLE `cf_candidate_memberships`
  ADD PRIMARY KEY (`candidate_membership_id`),
  ADD KEY `idx_candidate_id` (`candidate_id`);

--
-- Indexes for table `cf_candidate_packages`
--
ALTER TABLE `cf_candidate_packages`
  ADD PRIMARY KEY (`candidate_package_id`);

--
-- Indexes for table `cf_candidate_quizes`
--
ALTER TABLE `cf_candidate_quizes`
  ADD PRIMARY KEY (`candidate_quiz_id`);

--
-- Indexes for table `cf_departments`
--
ALTER TABLE `cf_departments`
  ADD PRIMARY KEY (`department_id`),
  ADD KEY `idx_employer_id` (`employer_id`),
  ADD KEY `idx_dept_employer` (`employer_id`),
  ADD KEY `idx_fix_dept_employer` (`employer_id`);

--
-- Indexes for table `cf_emails`
--
ALTER TABLE `cf_emails`
  ADD PRIMARY KEY (`email_id`);

--
-- Indexes for table `cf_employer_candidates`
--
ALTER TABLE `cf_employer_candidates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_fix_ec_employer` (`employer_id`),
  ADD KEY `idx_fix_ec_candidate` (`candidate_id`);

--
-- Indexes for table `cf_employer_roles`
--
ALTER TABLE `cf_employer_roles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_fix_er_employer` (`employer_id`),
  ADD KEY `idx_fix_er_role` (`role_id`);

--
-- Indexes for table `cf_error_logs`
--
ALTER TABLE `cf_error_logs`
  ADD PRIMARY KEY (`error_log_id`);

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

--
-- Indexes for table `cf_faqs`
--
ALTER TABLE `cf_faqs`
  ADD PRIMARY KEY (`faqs_id`);

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

--
-- Indexes for table `cf_industries`
--
ALTER TABLE `cf_industries`
  ADD PRIMARY KEY (`industry_id`);

--
-- Indexes for table `cf_interviews`
--
ALTER TABLE `cf_interviews`
  ADD PRIMARY KEY (`interview_id`);

--
-- Indexes for table `cf_interview_categories`
--
ALTER TABLE `cf_interview_categories`
  ADD PRIMARY KEY (`interview_category_id`);

--
-- Indexes for table `cf_interview_questions`
--
ALTER TABLE `cf_interview_questions`
  ADD PRIMARY KEY (`interview_question_id`);

--
-- Indexes for table `cf_jobs`
--
ALTER TABLE `cf_jobs`
  ADD PRIMARY KEY (`job_id`),
  ADD KEY `idx_employer_id` (`employer_id`),
  ADD KEY `idx_department_id` (`department_id`),
  ADD KEY `idx_slug` (`slug`),
  ADD KEY `idx_jobs_employer` (`employer_id`),
  ADD KEY `idx_jobs_department` (`department_id`),
  ADD KEY `idx_fix_jobs_employer` (`employer_id`),
  ADD KEY `idx_fix_jobs_department` (`department_id`);

--
-- Indexes for table `cf_job_applications`
--
ALTER TABLE `cf_job_applications`
  ADD PRIMARY KEY (`job_application_id`),
  ADD KEY `idx_candidate_id` (`candidate_id`),
  ADD KEY `idx_job_id` (`job_id`),
  ADD KEY `idx_apps_job` (`job_id`),
  ADD KEY `idx_apps_candidate` (`candidate_id`),
  ADD KEY `idx_fix_app_job` (`job_id`),
  ADD KEY `idx_fix_app_candidate` (`candidate_id`);

--
-- Indexes for table `cf_job_custom_fields`
--
ALTER TABLE `cf_job_custom_fields`
  ADD PRIMARY KEY (`custom_field_id`);

--
-- Indexes for table `cf_job_favorites`
--
ALTER TABLE `cf_job_favorites`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_candidate_id` (`candidate_id`),
  ADD KEY `idx_job_id` (`job_id`),
  ADD KEY `idx_fav_job` (`job_id`),
  ADD KEY `idx_fav_candidate` (`candidate_id`),
  ADD KEY `idx_fix_fav_job` (`job_id`),
  ADD KEY `idx_fix_fav_candidate` (`candidate_id`),
  ADD KEY `idx_fix_fav_employer` (`employer_id`);

--
-- Indexes for table `cf_job_filters`
--
ALTER TABLE `cf_job_filters`
  ADD PRIMARY KEY (`job_filter_id`);

--
-- Indexes for table `cf_job_filter_values`
--
ALTER TABLE `cf_job_filter_values`
  ADD PRIMARY KEY (`job_filter_value_id`);

--
-- Indexes for table `cf_job_filter_value_assignments`
--
ALTER TABLE `cf_job_filter_value_assignments`
  ADD PRIMARY KEY (`job_filter_value_assignment_id`),
  ADD KEY `idx_job_id` (`job_id`),
  ADD KEY `idx_job_filter_id` (`job_filter_id`),
  ADD KEY `idx_value_id` (`job_filter_value_id`);

--
-- Indexes for table `cf_job_quizes`
--
ALTER TABLE `cf_job_quizes`
  ADD PRIMARY KEY (`job_quiz_id`);

--
-- Indexes for table `cf_job_referred`
--
ALTER TABLE `cf_job_referred`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_jr_job` (`job_id`),
  ADD KEY `idx_jr_candidate` (`candidate_id`),
  ADD KEY `idx_jr_employer` (`employer_id`),
  ADD KEY `idx_fix_jr_job` (`job_id`),
  ADD KEY `idx_fix_jr_candidate` (`candidate_id`),
  ADD KEY `idx_fix_jr_employer` (`employer_id`);

--
-- Indexes for table `cf_job_traites`
--
ALTER TABLE `cf_job_traites`
  ADD PRIMARY KEY (`job_traite_id`),
  ADD KEY `idx_fix_jt_job` (`job_id`),
  ADD KEY `idx_fix_jt_traite` (`traite_id`),
  ADD KEY `idx_fix_jt_employer` (`employer_id`);

--
-- Indexes for table `cf_job_traite_answers`
--
ALTER TABLE `cf_job_traite_answers`
  ADD PRIMARY KEY (`job_traite_answer_id`),
  ADD KEY `idx_fix_jta_jobtraite` (`job_traite_id`),
  ADD KEY `idx_fix_jta_employer` (`employer_id`),
  ADD KEY `idx_fix_jta_candidate` (`candidate_id`),
  ADD KEY `idx_fix_jta_application` (`job_application_id`);

--
-- Indexes for table `cf_languages`
--
ALTER TABLE `cf_languages`
  ADD PRIMARY KEY (`language_id`);

--
-- Indexes for table `cf_memberships`
--
ALTER TABLE `cf_memberships`
  ADD PRIMARY KEY (`membership_id`),
  ADD KEY `idx_employer_id` (`employer_id`),
  ADD KEY `idx_member_employer` (`employer_id`),
  ADD KEY `idx_fix_member_employer` (`employer_id`);

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

--
-- Indexes for table `cf_messages`
--
ALTER TABLE `cf_messages`
  ADD PRIMARY KEY (`message_id`);

--
-- Indexes for table `cf_news`
--
ALTER TABLE `cf_news`
  ADD PRIMARY KEY (`news_id`);

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

--
-- Indexes for table `cf_notifications`
--
ALTER TABLE `cf_notifications`
  ADD PRIMARY KEY (`notification_id`);

--
-- Indexes for table `cf_packages`
--
ALTER TABLE `cf_packages`
  ADD PRIMARY KEY (`package_id`);

--
-- Indexes for table `cf_pages`
--
ALTER TABLE `cf_pages`
  ADD PRIMARY KEY (`page_id`);

--
-- Indexes for table `cf_permissions`
--
ALTER TABLE `cf_permissions`
  ADD PRIMARY KEY (`permission_id`);

--
-- Indexes for table `cf_questions`
--
ALTER TABLE `cf_questions`
  ADD PRIMARY KEY (`question_id`);

--
-- Indexes for table `cf_question_answers`
--
ALTER TABLE `cf_question_answers`
  ADD PRIMARY KEY (`question_answer_id`);

--
-- Indexes for table `cf_question_categories`
--
ALTER TABLE `cf_question_categories`
  ADD PRIMARY KEY (`question_category_id`);

--
-- Indexes for table `cf_quizes`
--
ALTER TABLE `cf_quizes`
  ADD PRIMARY KEY (`quiz_id`);

--
-- Indexes for table `cf_quiz_categories`
--
ALTER TABLE `cf_quiz_categories`
  ADD PRIMARY KEY (`quiz_category_id`);

--
-- Indexes for table `cf_quiz_questions`
--
ALTER TABLE `cf_quiz_questions`
  ADD PRIMARY KEY (`quiz_question_id`);

--
-- Indexes for table `cf_quiz_question_answers`
--
ALTER TABLE `cf_quiz_question_answers`
  ADD PRIMARY KEY (`quiz_question_answer_id`);

--
-- Indexes for table `cf_resumes`
--
ALTER TABLE `cf_resumes`
  ADD PRIMARY KEY (`resume_id`);

--
-- Indexes for table `cf_resume_achievements`
--
ALTER TABLE `cf_resume_achievements`
  ADD PRIMARY KEY (`resume_achievement_id`);

--
-- Indexes for table `cf_resume_experiences`
--
ALTER TABLE `cf_resume_experiences`
  ADD PRIMARY KEY (`resume_experience_id`);

--
-- Indexes for table `cf_resume_languages`
--
ALTER TABLE `cf_resume_languages`
  ADD PRIMARY KEY (`resume_language_id`);

--
-- Indexes for table `cf_resume_qualifications`
--
ALTER TABLE `cf_resume_qualifications`
  ADD PRIMARY KEY (`resume_qualification_id`);

--
-- Indexes for table `cf_resume_references`
--
ALTER TABLE `cf_resume_references`
  ADD PRIMARY KEY (`resume_reference_id`);

--
-- Indexes for table `cf_resume_skills`
--
ALTER TABLE `cf_resume_skills`
  ADD PRIMARY KEY (`resume_skill_id`);

--
-- Indexes for table `cf_roles`
--
ALTER TABLE `cf_roles`
  ADD PRIMARY KEY (`role_id`);

--
-- Indexes for table `cf_search_logs`
--
ALTER TABLE `cf_search_logs`
  ADD PRIMARY KEY (`search_log_id`);

--
-- Indexes for table `cf_sessions`
--
ALTER TABLE `cf_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cf_sessions_user_id_index` (`user_id`);

--
-- Indexes for table `cf_testimonials`
--
ALTER TABLE `cf_testimonials`
  ADD PRIMARY KEY (`testimonial_id`);

--
-- Indexes for table `cf_to_dos`
--
ALTER TABLE `cf_to_dos`
  ADD PRIMARY KEY (`to_do_id`);

--
-- Indexes for table `cf_traites`
--
ALTER TABLE `cf_traites`
  ADD PRIMARY KEY (`traite_id`);

--
-- Indexes for table `cf_updates`
--
ALTER TABLE `cf_updates`
  ADD PRIMARY KEY (`update_id`);

--
-- Indexes for table `cf_user_roles`
--
ALTER TABLE `cf_user_roles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_fix_ur_user` (`user_id`),
  ADD KEY `idx_fix_ur_role` (`role_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cf_blogs`
--
ALTER TABLE `cf_blogs`
  MODIFY `blog_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `cf_blog_categories`
--
ALTER TABLE `cf_blog_categories`
  MODIFY `blog_category_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cf_candidate_interviews`
--
ALTER TABLE `cf_candidate_interviews`
  MODIFY `candidate_interview_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_candidate_memberships`
--
ALTER TABLE `cf_candidate_memberships`
  MODIFY `candidate_membership_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cf_candidate_packages`
--
ALTER TABLE `cf_candidate_packages`
  MODIFY `candidate_package_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cf_candidate_quizes`
--
ALTER TABLE `cf_candidate_quizes`
  MODIFY `candidate_quiz_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_departments`
--
ALTER TABLE `cf_departments`
  MODIFY `department_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `cf_emails`
--
ALTER TABLE `cf_emails`
  MODIFY `email_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cf_employer_candidates`
--
ALTER TABLE `cf_employer_candidates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_employer_roles`
--
ALTER TABLE `cf_employer_roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cf_error_logs`
--
ALTER TABLE `cf_error_logs`
  MODIFY `error_log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_failed_jobs`
--
ALTER TABLE `cf_failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_faqs`
--
ALTER TABLE `cf_faqs`
  MODIFY `faqs_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `cf_faqs_categories`
--
ALTER TABLE `cf_faqs_categories`
  MODIFY `category_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `cf_industries`
--
ALTER TABLE `cf_industries`
  MODIFY `industry_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_interviews`
--
ALTER TABLE `cf_interviews`
  MODIFY `interview_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_interview_categories`
--
ALTER TABLE `cf_interview_categories`
  MODIFY `interview_category_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_interview_questions`
--
ALTER TABLE `cf_interview_questions`
  MODIFY `interview_question_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_jobs`
--
ALTER TABLE `cf_jobs`
  MODIFY `job_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `cf_job_applications`
--
ALTER TABLE `cf_job_applications`
  MODIFY `job_application_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_job_custom_fields`
--
ALTER TABLE `cf_job_custom_fields`
  MODIFY `custom_field_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_job_favorites`
--
ALTER TABLE `cf_job_favorites`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_job_filters`
--
ALTER TABLE `cf_job_filters`
  MODIFY `job_filter_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cf_job_filter_values`
--
ALTER TABLE `cf_job_filter_values`
  MODIFY `job_filter_value_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `cf_job_filter_value_assignments`
--
ALTER TABLE `cf_job_filter_value_assignments`
  MODIFY `job_filter_value_assignment_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `cf_job_quizes`
--
ALTER TABLE `cf_job_quizes`
  MODIFY `job_quiz_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `cf_job_referred`
--
ALTER TABLE `cf_job_referred`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_job_traites`
--
ALTER TABLE `cf_job_traites`
  MODIFY `job_traite_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_job_traite_answers`
--
ALTER TABLE `cf_job_traite_answers`
  MODIFY `job_traite_answer_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_languages`
--
ALTER TABLE `cf_languages`
  MODIFY `language_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cf_memberships`
--
ALTER TABLE `cf_memberships`
  MODIFY `membership_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cf_menus`
--
ALTER TABLE `cf_menus`
  MODIFY `menu_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `cf_messages`
--
ALTER TABLE `cf_messages`
  MODIFY `message_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cf_news`
--
ALTER TABLE `cf_news`
  MODIFY `news_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_news_categories`
--
ALTER TABLE `cf_news_categories`
  MODIFY `category_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_notifications`
--
ALTER TABLE `cf_notifications`
  MODIFY `notification_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cf_packages`
--
ALTER TABLE `cf_packages`
  MODIFY `package_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `cf_pages`
--
ALTER TABLE `cf_pages`
  MODIFY `page_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cf_permissions`
--
ALTER TABLE `cf_permissions`
  MODIFY `permission_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=175;

--
-- AUTO_INCREMENT for table `cf_questions`
--
ALTER TABLE `cf_questions`
  MODIFY `question_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cf_question_answers`
--
ALTER TABLE `cf_question_answers`
  MODIFY `question_answer_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `cf_question_categories`
--
ALTER TABLE `cf_question_categories`
  MODIFY `question_category_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cf_quizes`
--
ALTER TABLE `cf_quizes`
  MODIFY `quiz_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cf_quiz_categories`
--
ALTER TABLE `cf_quiz_categories`
  MODIFY `quiz_category_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cf_quiz_questions`
--
ALTER TABLE `cf_quiz_questions`
  MODIFY `quiz_question_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cf_quiz_question_answers`
--
ALTER TABLE `cf_quiz_question_answers`
  MODIFY `quiz_question_answer_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `cf_resumes`
--
ALTER TABLE `cf_resumes`
  MODIFY `resume_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cf_resume_achievements`
--
ALTER TABLE `cf_resume_achievements`
  MODIFY `resume_achievement_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_resume_experiences`
--
ALTER TABLE `cf_resume_experiences`
  MODIFY `resume_experience_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_resume_languages`
--
ALTER TABLE `cf_resume_languages`
  MODIFY `resume_language_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_resume_qualifications`
--
ALTER TABLE `cf_resume_qualifications`
  MODIFY `resume_qualification_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_resume_references`
--
ALTER TABLE `cf_resume_references`
  MODIFY `resume_reference_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_resume_skills`
--
ALTER TABLE `cf_resume_skills`
  MODIFY `resume_skill_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_roles`
--
ALTER TABLE `cf_roles`
  MODIFY `role_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `cf_search_logs`
--
ALTER TABLE `cf_search_logs`
  MODIFY `search_log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `cf_testimonials`
--
ALTER TABLE `cf_testimonials`
  MODIFY `testimonial_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_to_dos`
--
ALTER TABLE `cf_to_dos`
  MODIFY `to_do_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_traites`
--
ALTER TABLE `cf_traites`
  MODIFY `traite_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_updates`
--
ALTER TABLE `cf_updates`
  MODIFY `update_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cf_user_roles`
--
ALTER TABLE `cf_user_roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cf_departments`
--
ALTER TABLE `cf_departments`
  ADD CONSTRAINT `fk_fix_dept_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE SET NULL;

--
-- Constraints for table `cf_employer_candidates`
--
ALTER TABLE `cf_employer_candidates`
  ADD CONSTRAINT `fk_fix_ec_candidate` FOREIGN KEY (`candidate_id`) REFERENCES `cf_candidates` (`candidate_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_fix_ec_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE CASCADE;

--
-- Constraints for table `cf_employer_roles`
--
ALTER TABLE `cf_employer_roles`
  ADD CONSTRAINT `fk_fix_er_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_fix_er_role` FOREIGN KEY (`role_id`) REFERENCES `cf_roles` (`role_id`) ON DELETE CASCADE;

--
-- Constraints for table `cf_jobs`
--
ALTER TABLE `cf_jobs`
  ADD CONSTRAINT `fk_fix_jobs_department2` FOREIGN KEY (`department_id`) REFERENCES `cf_departments` (`department_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_fix_jobs_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_job_department` FOREIGN KEY (`department_id`) REFERENCES `cf_departments` (`department_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_job_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_jobs_department` FOREIGN KEY (`department_id`) REFERENCES `cf_departments` (`department_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_jobs_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE SET NULL;

--
-- Constraints for table `cf_job_applications`
--
ALTER TABLE `cf_job_applications`
  ADD CONSTRAINT `fk_app_candidate` FOREIGN KEY (`candidate_id`) REFERENCES `cf_candidates` (`candidate_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_app_job` FOREIGN KEY (`job_id`) REFERENCES `cf_jobs` (`job_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_apps_candidate` FOREIGN KEY (`candidate_id`) REFERENCES `cf_candidates` (`candidate_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_apps_job` FOREIGN KEY (`job_id`) REFERENCES `cf_jobs` (`job_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_fix_app_candidate` FOREIGN KEY (`candidate_id`) REFERENCES `cf_candidates` (`candidate_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_fix_app_job` FOREIGN KEY (`job_id`) REFERENCES `cf_jobs` (`job_id`) ON DELETE CASCADE;

--
-- Constraints for table `cf_job_favorites`
--
ALTER TABLE `cf_job_favorites`
  ADD CONSTRAINT `fk_fav_candidate` FOREIGN KEY (`candidate_id`) REFERENCES `cf_candidates` (`candidate_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_fav_job` FOREIGN KEY (`job_id`) REFERENCES `cf_jobs` (`job_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_fix_fav_candidate` FOREIGN KEY (`candidate_id`) REFERENCES `cf_candidates` (`candidate_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_fix_fav_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_fix_fav_job` FOREIGN KEY (`job_id`) REFERENCES `cf_jobs` (`job_id`) ON DELETE CASCADE;

--
-- Constraints for table `cf_job_referred`
--
ALTER TABLE `cf_job_referred`
  ADD CONSTRAINT `cf_job_referred_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `cf_jobs` (`job_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `cf_job_referred_ibfk_2` FOREIGN KEY (`candidate_id`) REFERENCES `cf_candidates` (`candidate_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `cf_job_referred_ibfk_3` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_fix_jr_candidate` FOREIGN KEY (`candidate_id`) REFERENCES `cf_candidates` (`candidate_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_fix_jr_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_fix_jr_job` FOREIGN KEY (`job_id`) REFERENCES `cf_jobs` (`job_id`) ON DELETE SET NULL;

--
-- Constraints for table `cf_job_traites`
--
ALTER TABLE `cf_job_traites`
  ADD CONSTRAINT `fk_fix_jt_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_fix_jt_job` FOREIGN KEY (`job_id`) REFERENCES `cf_jobs` (`job_id`) ON DELETE SET NULL;

--
-- Constraints for table `cf_job_traite_answers`
--
ALTER TABLE `cf_job_traite_answers`
  ADD CONSTRAINT `fk_fix_jta_application` FOREIGN KEY (`job_application_id`) REFERENCES `cf_job_applications` (`job_application_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_fix_jta_candidate` FOREIGN KEY (`candidate_id`) REFERENCES `cf_candidates` (`candidate_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_fix_jta_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_fix_jta_jobtraite` FOREIGN KEY (`job_traite_id`) REFERENCES `cf_job_traites` (`job_traite_id`) ON DELETE SET NULL;

--
-- Constraints for table `cf_memberships`
--
ALTER TABLE `cf_memberships`
  ADD CONSTRAINT `fk_fix_member_employer` FOREIGN KEY (`employer_id`) REFERENCES `cf_employers` (`employer_id`) ON DELETE CASCADE;

--
-- Constraints for table `cf_user_roles`
--
ALTER TABLE `cf_user_roles`
  ADD CONSTRAINT `fk_fix_ur_role` FOREIGN KEY (`role_id`) REFERENCES `cf_roles` (`role_id`) ON DELETE CASCADE;
COMMIT;

