/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `admin_role_permission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin_role_permission` (
  `admin_role_id` bigint unsigned NOT NULL,
  `permission_id` bigint unsigned NOT NULL,
  KEY `admin_role_permission_admin_role_id_foreign` (`admin_role_id`),
  KEY `admin_role_permission_permission_id_foreign` (`permission_id`),
  CONSTRAINT `admin_role_permission_admin_role_id_foreign` FOREIGN KEY (`admin_role_id`) REFERENCES `admin_roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `admin_role_permission_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `admin_role_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin_role_user` (
  `admin_role_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  KEY `admin_role_user_admin_role_id_foreign` (`admin_role_id`),
  KEY `admin_role_user_user_id_foreign` (`user_id`),
  CONSTRAINT `admin_role_user_admin_role_id_foreign` FOREIGN KEY (`admin_role_id`) REFERENCES `admin_roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `admin_role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `admin_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin_roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `api_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `api_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `applications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `applications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `vacancy_id` bigint unsigned NOT NULL,
  `shortlisted` tinyint(1) NOT NULL DEFAULT '0',
  `cover_letter` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `applications_user_id_foreign` (`user_id`),
  KEY `applications_vacancy_id_foreign` (`vacancy_id`),
  CONSTRAINT `applications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `applications_vacancy_id_foreign` FOREIGN KEY (`vacancy_id`) REFERENCES `vacancies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `articles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `articles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `meta_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  UNIQUE KEY `articles_slug_unique` (`slug`),
  FULLTEXT KEY `full` (`title`,`content`,`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `billing_addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `billing_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `city` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `zip` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint unsigned NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `billing_addresses_user_id_foreign` (`user_id`),
  KEY `billing_addresses_country_id_foreign` (`country_id`),
  CONSTRAINT `billing_addresses_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `billing_addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `blog_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blog_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `blog_category_blog_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blog_category_blog_post` (
  `blog_category_id` bigint unsigned NOT NULL,
  `blog_post_id` bigint unsigned NOT NULL,
  KEY `blog_category_blog_post_blog_category_id_foreign` (`blog_category_id`),
  KEY `blog_category_blog_post_blog_post_id_foreign` (`blog_post_id`),
  CONSTRAINT `blog_category_blog_post_blog_category_id_foreign` FOREIGN KEY (`blog_category_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `blog_category_blog_post_blog_post_id_foreign` FOREIGN KEY (`blog_post_id`) REFERENCES `blog_posts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `blog_posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blog_posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cover_photo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_date` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `meta_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_posts_user_id_foreign` (`user_id`),
  FULLTEXT KEY `full` (`title`,`content`,`meta_title`,`meta_description`),
  CONSTRAINT `blog_posts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `candidate_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidate_category` (
  `candidate_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  KEY `candidate_category_candidate_id_foreign` (`candidate_id`),
  KEY `candidate_category_category_id_foreign` (`category_id`),
  CONSTRAINT `candidate_category_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `candidate_category_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `candidate_email`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidate_email` (
  `candidate_id` bigint unsigned NOT NULL,
  `email_id` bigint unsigned NOT NULL,
  KEY `candidate_email_candidate_id_foreign` (`candidate_id`),
  KEY `candidate_email_email_id_foreign` (`email_id`),
  CONSTRAINT `candidate_email_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `candidate_email_email_id_foreign` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `candidate_field_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidate_field_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '1',
  `registration` tinyint(1) DEFAULT '0',
  `visible` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `candidate_field_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidate_field_user` (
  `candidate_field_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  KEY `candidate_field_user_candidate_field_id_foreign` (`candidate_field_id`),
  KEY `candidate_field_user_user_id_foreign` (`user_id`),
  FULLTEXT KEY `full` (`value`),
  CONSTRAINT `candidate_field_user_candidate_field_id_foreign` FOREIGN KEY (`candidate_field_id`) REFERENCES `candidate_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `candidate_field_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `candidate_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidate_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `candidate_field_group_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `placeholder` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `filter` tinyint(1) NOT NULL DEFAULT '0',
  `ai` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `candidate_fields_candidate_field_group_id_foreign` (`candidate_field_group_id`),
  CONSTRAINT `candidate_fields_candidate_field_group_id_foreign` FOREIGN KEY (`candidate_field_group_id`) REFERENCES `candidate_field_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `candidate_interview`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidate_interview` (
  `interview_id` bigint unsigned NOT NULL,
  `candidate_id` bigint unsigned NOT NULL,
  KEY `candidate_interview_interview_id_foreign` (`interview_id`),
  KEY `candidate_interview_candidate_id_foreign` (`candidate_id`),
  CONSTRAINT `candidate_interview_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `candidate_interview_interview_id_foreign` FOREIGN KEY (`interview_id`) REFERENCES `interviews` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `candidate_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidate_order` (
  `order_id` bigint unsigned NOT NULL,
  `candidate_id` bigint unsigned NOT NULL,
  KEY `candidate_order_order_id_foreign` (`order_id`),
  KEY `candidate_order_candidate_id_foreign` (`candidate_id`),
  CONSTRAINT `candidate_order_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `candidate_order_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `candidates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `candidates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `display_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_birth` datetime DEFAULT NULL,
  `gender` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employed` tinyint(1) NOT NULL DEFAULT '0',
  `shortlisted` tinyint(1) NOT NULL DEFAULT '0',
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `public` tinyint(1) NOT NULL DEFAULT '0',
  `video_code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cv_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about` text COLLATE utf8mb4_unicode_ci,
  `country_id` bigint unsigned DEFAULT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `zip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `restricted` tinyint(1) DEFAULT '0',
  `notifications_vacancies` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `candidates_user_id_foreign` (`user_id`),
  KEY `candidates_country_id_foreign` (`country_id`),
  FULLTEXT KEY `full` (`display_name`),
  CONSTRAINT `candidates_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `candidates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sort_order` int DEFAULT NULL,
  `public` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `category_sms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category_sms` (
  `sms_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  KEY `category_sms_sms_id_foreign` (`sms_id`),
  KEY `category_sms_category_id_foreign` (`category_id`),
  CONSTRAINT `category_sms_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `category_sms_sms_id_foreign` FOREIGN KEY (`sms_id`) REFERENCES `sms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `contract_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contract_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `contract_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contract_user` (
  `user_id` bigint unsigned NOT NULL,
  `contract_id` bigint unsigned NOT NULL,
  `signed` tinyint(1) NOT NULL DEFAULT '0',
  KEY `contract_user_user_id_foreign` (`user_id`),
  KEY `contract_user_contract_id_foreign` (`contract_id`),
  CONSTRAINT `contract_user_contract_id_foreign` FOREIGN KEY (`contract_id`) REFERENCES `contracts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `contract_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `contracts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contracts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso_code_2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso_code_3` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_format` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `postcode_required` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `currency_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `symbol_left` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `symbol_right` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `course_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `parent_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_categories_parent_id_foreign` (`parent_id`),
  CONSTRAINT `course_categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `course_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `course_course_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course_course_category` (
  `course_id` bigint unsigned NOT NULL,
  `course_category_id` bigint unsigned NOT NULL,
  KEY `course_course_category_course_id_foreign` (`course_id`),
  KEY `course_course_category_course_category_id_foreign` (`course_category_id`),
  CONSTRAINT `course_course_category_course_category_id_foreign` FOREIGN KEY (`course_category_id`) REFERENCES `course_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `course_course_category_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `course_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `course_id` bigint unsigned NOT NULL,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_files_course_id_foreign` (`course_id`),
  CONSTRAINT `course_files_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `course_instructor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course_instructor` (
  `course_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  KEY `course_instructors_course_id_foreign` (`course_id`),
  KEY `course_instructors_user_id_foreign` (`user_id`),
  CONSTRAINT `course_instructors_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `course_instructors_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `course_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course_invoice` (
  `course_id` bigint unsigned NOT NULL,
  `invoice_id` bigint unsigned NOT NULL,
  KEY `course_invoice_course_id_foreign` (`course_id`),
  KEY `course_invoice_invoice_id_foreign` (`invoice_id`),
  CONSTRAINT `course_invoice_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `course_invoice_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `course_test`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course_test` (
  `course_id` bigint unsigned NOT NULL,
  `test_id` bigint unsigned NOT NULL,
  KEY `course_test_course_id_foreign` (`course_id`),
  KEY `course_test_test_id_foreign` (`test_id`),
  CONSTRAINT `course_test_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `course_test_test_id_foreign` FOREIGN KEY (`test_id`) REFERENCES `tests` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `course_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course_user` (
  `course_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `started` timestamp NULL DEFAULT NULL,
  `ended` timestamp NULL DEFAULT NULL,
  KEY `course_user_course_id_foreign` (`course_id`),
  KEY `course_user_user_id_foreign` (`user_id`),
  CONSTRAINT `course_user_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `course_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `courses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `courses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `short_description` text COLLATE utf8mb4_unicode_ci,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `introduction` text COLLATE utf8mb4_unicode_ci,
  `effort` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `length` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `public` tinyint(1) NOT NULL DEFAULT '1',
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `closes_on` timestamp NULL DEFAULT NULL,
  `capacity` int DEFAULT NULL,
  `payment_required` tinyint(1) NOT NULL DEFAULT '0',
  `fee` double DEFAULT NULL,
  `enforce_capacity` tinyint(1) NOT NULL,
  `enforce_order` tinyint(1) DEFAULT '0',
  `certificate_html` text COLLATE utf8mb4_unicode_ci,
  `certificate_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `certificate_orientation` char(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'l',
  `pinned` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `courses_name_description_short_description_fulltext` (`name`,`description`,`short_description`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `education`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `education` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `candidate_id` bigint unsigned NOT NULL,
  `institution` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `degree` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_obtained` timestamp NULL DEFAULT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `education_candidate_id_foreign` (`candidate_id`),
  CONSTRAINT `education_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `email_attachments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_attachments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `email_id` bigint unsigned NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `email_attachments_email_id_foreign` (`email_id`),
  CONSTRAINT `email_attachments_email_id_foreign` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `email_email_resource`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_email_resource` (
  `email_id` bigint unsigned NOT NULL,
  `email_resource_id` bigint unsigned NOT NULL,
  KEY `email_email_resource_email_id_foreign` (`email_id`),
  KEY `email_email_resource_email_resource_id_foreign` (`email_resource_id`),
  CONSTRAINT `email_email_resource_email_id_foreign` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE CASCADE,
  CONSTRAINT `email_email_resource_email_resource_id_foreign` FOREIGN KEY (`email_resource_id`) REFERENCES `email_resources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `email_invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_invoice` (
  `email_id` bigint unsigned NOT NULL,
  `invoice_id` bigint unsigned NOT NULL,
  KEY `email_invoice_email_id_foreign` (`email_id`),
  KEY `email_invoice_invoice_id_foreign` (`invoice_id`),
  CONSTRAINT `email_invoice_email_id_foreign` FOREIGN KEY (`email_id`) REFERENCES `emails` (`id`) ON DELETE CASCADE,
  CONSTRAINT `email_invoice_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `email_resources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_resources` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `full` (`name`,`file_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `email_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `emails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cc` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `send_date` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `sender_id` bigint unsigned DEFAULT NULL,
  `recipient_email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_type` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'p',
  PRIMARY KEY (`id`),
  KEY `emails_user_id_foreign` (`user_id`),
  KEY `emails_sender_id_foreign` (`sender_id`),
  FULLTEXT KEY `full` (`subject`,`message`),
  CONSTRAINT `emails_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `emails_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `employer_field_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employer_field_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  `registration` tinyint(1) DEFAULT '0',
  `public` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `employer_field_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employer_field_user` (
  `employer_field_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  KEY `employer_field_user_employer_field_id_foreign` (`employer_field_id`),
  KEY `employer_field_user_user_id_foreign` (`user_id`),
  FULLTEXT KEY `full` (`value`),
  CONSTRAINT `employer_field_user_employer_field_id_foreign` FOREIGN KEY (`employer_field_id`) REFERENCES `employer_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `employer_field_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `employer_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employer_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `employer_field_group_id` bigint unsigned DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `placeholder` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `filter` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `employer_fields_employer_field_group_id_foreign` (`employer_field_group_id`),
  CONSTRAINT `employer_fields_employer_field_group_id_foreign` FOREIGN KEY (`employer_field_group_id`) REFERENCES `employer_field_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `employers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `gender` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `employers_user_id_foreign` (`user_id`),
  CONSTRAINT `employers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `employment_comment_attachments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employment_comment_attachments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `employment_comment_id` bigint unsigned NOT NULL,
  `file_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `employment_comment_attachments_employment_comment_id_foreign` (`employment_comment_id`),
  CONSTRAINT `employment_comment_attachments_employment_comment_id_foreign` FOREIGN KEY (`employment_comment_id`) REFERENCES `employment_comments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `employment_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employment_comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `employment_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `employment_comments_employment_id_foreign` (`employment_id`),
  KEY `employment_comments_user_id_foreign` (`user_id`),
  FULLTEXT KEY `full` (`content`),
  CONSTRAINT `employment_comments_employment_id_foreign` FOREIGN KEY (`employment_id`) REFERENCES `employments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `employment_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `employments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `employments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `employer_id` bigint unsigned NOT NULL,
  `candidate_id` bigint unsigned NOT NULL,
  `start_date` timestamp NULL DEFAULT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `salary` decimal(20,2) DEFAULT NULL,
  `salary_type` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'm',
  PRIMARY KEY (`id`),
  KEY `employments_employer_id_foreign` (`employer_id`),
  KEY `employments_candidate_id_foreign` (`candidate_id`),
  CONSTRAINT `employments_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE,
  CONSTRAINT `employments_employer_id_foreign` FOREIGN KEY (`employer_id`) REFERENCES `employers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `footer_menus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `footer_menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `parent_id` int NOT NULL DEFAULT '0',
  `new_window` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `header_menus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `header_menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  `parent_id` int NOT NULL DEFAULT '0',
  `new_window` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `interviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `interviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `interview_date` timestamp NULL DEFAULT NULL,
  `venue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `internal_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `employer_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `reminder` tinyint(1) NOT NULL DEFAULT '0',
  `feedback` tinyint(1) NOT NULL DEFAULT '0',
  `hash` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `interview_time` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employer_feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_virtual` tinyint(1) NOT NULL DEFAULT '0',
  `meeting_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meeting_password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meeting_instructions` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `interviews_user_id_foreign` (`user_id`),
  CONSTRAINT `interviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `invoice_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `invoice_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_order` (
  `invoice_id` bigint unsigned NOT NULL,
  `order_id` bigint unsigned NOT NULL,
  KEY `invoice_order_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_order_order_id_foreign` (`order_id`),
  CONSTRAINT `invoice_order_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoice_order_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `payment_method_id` bigint unsigned DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `paid` tinyint(1) DEFAULT '0',
  `user_id` bigint unsigned NOT NULL,
  `due_date` timestamp NULL DEFAULT NULL,
  `invoice_category_id` bigint unsigned DEFAULT NULL,
  `hash` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoices_payment_method_id_foreign` (`payment_method_id`),
  KEY `invoices_user_id_foreign` (`user_id`),
  KEY `invoices_invoice_category_id_foreign` (`invoice_category_id`),
  FULLTEXT KEY `full` (`title`,`description`),
  CONSTRAINT `invoices_invoice_category_id_foreign` FOREIGN KEY (`invoice_category_id`) REFERENCES `invoice_categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `invoices_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE SET NULL,
  CONSTRAINT `invoices_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `job_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `job_category_vacancy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_category_vacancy` (
  `vacancy_id` bigint unsigned NOT NULL,
  `job_category_id` bigint unsigned NOT NULL,
  KEY `job_category_vacancy_vacancy_id_foreign` (`vacancy_id`),
  KEY `job_category_vacancy_job_category_id_foreign` (`job_category_id`),
  CONSTRAINT `job_category_vacancy_job_category_id_foreign` FOREIGN KEY (`job_category_id`) REFERENCES `job_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `job_category_vacancy_vacancy_id_foreign` FOREIGN KEY (`vacancy_id`) REFERENCES `vacancies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `lecture_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lecture_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lecture_id` bigint unsigned NOT NULL,
  `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lecture_files_lecture_id_foreign` (`lecture_id`),
  CONSTRAINT `lecture_files_lecture_id_foreign` FOREIGN KEY (`lecture_id`) REFERENCES `lectures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `lecture_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lecture_pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lecture_id` bigint unsigned NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `type` char(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `lecture_pages_lecture_id_foreign` (`lecture_id`),
  CONSTRAINT `lecture_pages_lecture_id_foreign` FOREIGN KEY (`lecture_id`) REFERENCES `lectures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `lecture_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lecture_user` (
  `lecture_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  KEY `lecture_user_lecture_id_foreign` (`lecture_id`),
  KEY `lecture_user_user_id_foreign` (`user_id`),
  CONSTRAINT `lecture_user_lecture_id_foreign` FOREIGN KEY (`lecture_id`) REFERENCES `lectures` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lecture_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `lectures`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lectures` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lesson_id` bigint unsigned NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `lectures_lesson_id_foreign` (`lesson_id`),
  CONSTRAINT `lectures_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `lesson_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lesson_user` (
  `lesson_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  KEY `lesson_user_lesson_id_foreign` (`lesson_id`),
  KEY `lesson_user_user_id_foreign` (`user_id`),
  CONSTRAINT `lesson_user_lesson_id_foreign` FOREIGN KEY (`lesson_id`) REFERENCES `lessons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `lesson_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `lessons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lessons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `course_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `sort_order` int NOT NULL DEFAULT '0',
  `enforce_lecture_order` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `lessons_course_id_foreign` (`course_id`),
  CONSTRAINT `lessons_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `login_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `login_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `login_tokens_user_id_foreign` (`user_id`),
  CONSTRAINT `login_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `mailing_lists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mailing_lists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mailing_lists_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `newsletters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `newsletters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `send_date` timestamp NULL DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `mailing_list` tinyint(1) NOT NULL DEFAULT '0',
  `candidates` tinyint(1) NOT NULL DEFAULT '0',
  `employers` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `newsletters_subject_fulltext` (`subject`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `order_comment_attachments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_comment_attachments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order_comment_id` bigint unsigned NOT NULL,
  `file_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `order_comment_attachments_order_comment_id_foreign` (`order_comment_id`),
  CONSTRAINT `order_comment_attachments_order_comment_id_foreign` FOREIGN KEY (`order_comment_id`) REFERENCES `order_comments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `order_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `order_comments_order_id_foreign` (`order_id`),
  KEY `order_comments_user_id_foreign` (`user_id`),
  FULLTEXT KEY `full` (`content`),
  CONSTRAINT `order_comments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `order_field_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_field_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `order_form_id` bigint unsigned NOT NULL DEFAULT '1',
  `layout` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'v',
  `columns` int DEFAULT '2',
  PRIMARY KEY (`id`),
  KEY `order_field_groups_order_form_id_foreign` (`order_form_id`),
  CONSTRAINT `order_field_groups_order_form_id_foreign` FOREIGN KEY (`order_form_id`) REFERENCES `order_forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `order_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order_field_group_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `placeholder` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `filter` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `order_forms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_forms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `shortlist` tinyint(1) NOT NULL DEFAULT '1',
  `interview` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int NOT NULL DEFAULT '0',
  `auto_invoice` tinyint(1) NOT NULL DEFAULT '0',
  `invoice_amount` double DEFAULT NULL,
  `invoice_title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `invoice_category_id` bigint unsigned DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_forms_invoice_category_id_foreign` (`invoice_category_id`),
  CONSTRAINT `order_forms_invoice_category_id_foreign` FOREIGN KEY (`invoice_category_id`) REFERENCES `invoice_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `order_order_field`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_order_field` (
  `order_id` bigint unsigned NOT NULL,
  `order_field_id` bigint unsigned NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  KEY `order_order_field_order_id_foreign` (`order_id`),
  KEY `order_order_field_order_field_id_foreign` (`order_field_id`),
  CONSTRAINT `order_order_field_order_field_id_foreign` FOREIGN KEY (`order_field_id`) REFERENCES `order_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_order_field_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `interview_date` timestamp NULL DEFAULT NULL,
  `status` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'p',
  `interview_location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `interview_time` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `order_form_id` bigint unsigned DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_order_form_id_foreign` (`order_form_id`),
  CONSTRAINT `orders_order_form_id_foreign` FOREIGN KEY (`order_form_id`) REFERENCES `order_forms` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `payment_method_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_method_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `payment_method_id` bigint unsigned NOT NULL,
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `serialized` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `class` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payment_method_fields_payment_method_id_foreign` (`payment_method_id`),
  CONSTRAINT `payment_method_fields_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `payment_methods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_methods` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  `method_label` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `translate` tinyint(1) DEFAULT '0',
  `settings` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `pending_user_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pending_user_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `pending_user_id` bigint unsigned NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pending_user_files_pending_user_id_foreign` (`pending_user_id`),
  CONSTRAINT `pending_user_files_pending_user_id_foreign` FOREIGN KEY (`pending_user_id`) REFERENCES `pending_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `pending_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pending_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role_id` bigint unsigned NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hash` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pending_users_hash_unique` (`hash`),
  KEY `pending_users_role_id_foreign` (`role_id`),
  CONSTRAINT `pending_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `permission_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `permission_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `permission_group_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `permissions_name_unique` (`name`),
  KEY `permissions_permission_group_id_foreign` (`permission_group_id`),
  CONSTRAINT `permissions_permission_group_id_foreign` FOREIGN KEY (`permission_group_id`) REFERENCES `permission_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `placeholder` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `serialized` tinyint(1) NOT NULL DEFAULT '0',
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `class` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `skills`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `skills` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `candidate_id` bigint unsigned NOT NULL,
  `skill` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `skills_candidate_id_foreign` (`candidate_id`),
  CONSTRAINT `skills_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `send_date` timestamp NULL DEFAULT NULL,
  `sent` tinyint(1) NOT NULL,
  `sms_gateway_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sms_sms_gateway_id_foreign` (`sms_gateway_id`),
  FULLTEXT KEY `full` (`comment`,`message`),
  CONSTRAINT `sms_sms_gateway_id_foreign` FOREIGN KEY (`sms_gateway_id`) REFERENCES `sms_gateways` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sms_gateway_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_gateway_fields` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sms_gateway_id` bigint unsigned NOT NULL,
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `placeholder` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int DEFAULT NULL,
  `class` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sms_gateway_fields_sms_gateway_id_foreign` (`sms_gateway_id`),
  CONSTRAINT `sms_gateway_fields_sms_gateway_id_foreign` FOREIGN KEY (`sms_gateway_id`) REFERENCES `sms_gateways` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sms_gateways`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_gateways` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `gateway_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `settings` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sms_recipients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_recipients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sms_id` bigint unsigned NOT NULL,
  `telephone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sms_recipients_sms_id_foreign` (`sms_id`),
  CONSTRAINT `sms_recipients_sms_id_foreign` FOREIGN KEY (`sms_id`) REFERENCES `sms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sms_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sms_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_user` (
  `sms_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  KEY `sms_user_sms_id_foreign` (`sms_id`),
  KEY `sms_user_user_id_foreign` (`user_id`),
  CONSTRAINT `sms_user_sms_id_foreign` FOREIGN KEY (`sms_id`) REFERENCES `sms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sms_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `template_colors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `template_colors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `template_id` bigint unsigned NOT NULL,
  `original_color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `template_colors_template_id_foreign` (`template_id`),
  CONSTRAINT `template_colors_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `template_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `template_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `template_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `template_options_template_id_foreign` (`template_id`),
  CONSTRAINT `template_options_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `directory` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `directory` (`directory`),
  UNIQUE KEY `templates_directory_unique` (`directory`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `test_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `test_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `test_question_id` bigint unsigned NOT NULL,
  `option` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_correct` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `test_options_test_question_id_foreign` (`test_question_id`),
  CONSTRAINT `test_options_test_question_id_foreign` FOREIGN KEY (`test_question_id`) REFERENCES `test_questions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `test_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `test_questions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `test_id` bigint unsigned NOT NULL,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `test_questions_test_id_foreign` (`test_id`),
  FULLTEXT KEY `full` (`question`),
  CONSTRAINT `test_questions_test_id_foreign` FOREIGN KEY (`test_id`) REFERENCES `tests` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `tests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `minutes` int DEFAULT NULL,
  `allow_multiple` tinyint(1) NOT NULL DEFAULT '0',
  `passmark` double(8,2) DEFAULT NULL,
  `show_result` tinyint(1) NOT NULL DEFAULT '0',
  `private` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `full` (`name`,`description`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `unsubscribes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `unsubscribes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unsubscribes_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `user_attachments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_attachments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `author` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_attachments_user_id_foreign` (`user_id`),
  FULLTEXT KEY `full` (`name`),
  CONSTRAINT `user_attachments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `user_notes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_notes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `author` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_notes_user_id_foreign` (`user_id`),
  FULLTEXT KEY `full` (`title`,`content`),
  CONSTRAINT `user_notes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `user_test_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_test_options` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_test_id` bigint unsigned NOT NULL,
  `test_option_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_test_options_user_test_id_foreign` (`user_test_id`),
  KEY `user_test_options_test_option_id_foreign` (`test_option_id`),
  CONSTRAINT `user_test_options_test_option_id_foreign` FOREIGN KEY (`test_option_id`) REFERENCES `test_options` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_test_options_user_test_id_foreign` FOREIGN KEY (`user_test_id`) REFERENCES `user_tests` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `user_tests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_tests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned NOT NULL,
  `test_id` bigint unsigned NOT NULL,
  `score` double(8,2) DEFAULT NULL,
  `complete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_tests_user_id_foreign` (`user_id`),
  KEY `user_tests_test_id_foreign` (`test_id`),
  CONSTRAINT `user_tests_test_id_foreign` FOREIGN KEY (`test_id`) REFERENCES `tests` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_tests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `api_token` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `role_id` bigint unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `telephone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login_token_expires` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_api_token_unique` (`api_token`),
  KEY `users_role_id_foreign` (`role_id`),
  FULLTEXT KEY `full` (`name`,`email`,`telephone`),
  CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `vacancies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vacancies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `closes_at` timestamp NULL DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `location` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employer_id` bigint unsigned DEFAULT NULL,
  `approval_status` char(191) COLLATE utf8mb4_unicode_ci DEFAULT 'a',
  `notify` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `vacancies_employer_id_foreign` (`employer_id`),
  FULLTEXT KEY `full` (`title`,`description`),
  CONSTRAINT `vacancies_employer_id_foreign` FOREIGN KEY (`employer_id`) REFERENCES `employers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `work_experiences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `work_experiences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `candidate_id` bigint unsigned NOT NULL,
  `company` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_description` text COLLATE utf8mb4_unicode_ci,
  `start_date` timestamp NOT NULL,
  `end_date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `work_experiences_candidate_id_foreign` (`candidate_id`),
  CONSTRAINT `work_experiences_candidate_id_foreign` FOREIGN KEY (`candidate_id`) REFERENCES `candidates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'2014_10_12_000000_create_users_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (2,'2014_10_12_100000_create_password_resets_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (3,'2019_08_19_000000_create_failed_jobs_table',1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (4,'2019_10_29_134223_create_roles_table',2);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (5,'2019_10_29_135702_add_role_to_user',3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (6,'2019_10_29_135903_create_admin_roles_table',3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (7,'2019_10_29_140013_create_permission_groups_table',3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (8,'2019_10_29_140049_create_permissions_table',3);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (9,'2019_10_29_140217_create_admin_role_pivot',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (10,'2019_10_29_140245_create_admin_role_user_pivot',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (11,'2019_10_29_140324_create_employer_field_groups_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (12,'2019_10_29_140347_create_employer_fields_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (13,'2019_10_29_171459_create_employer_field_user_pivot',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (14,'2019_10_29_171535_create_candidates_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (15,'2019_10_29_171625_create_candidate_field_groups_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (16,'2019_10_29_171657_create_candidate_fields_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (17,'2019_10_29_171740_create_candidate_field_user_pivot',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (18,'2019_10_29_171909_create_order_field_groups_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (19,'2019_10_29_171923_create_order_fields_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (20,'2019_10_29_172043_create_orders_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (21,'2019_10_29_172158_create_order_order_field_pivot',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (22,'2019_10_29_172232_create_candidate_order_pivot',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (23,'2019_10_29_172249_create_invoices_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (24,'2019_10_29_172635_create_settings_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (25,'2019_10_29_172646_create_articles_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (26,'2019_10_29_172709_create_blog_categories_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (27,'2019_10_29_172755_create_blog_posts_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (28,'2019_10_29_172845_create_blog_category_blog_post_pivot',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (29,'2019_10_29_172904_create_user_notes_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (30,'2019_10_29_172929_create_user_attachments_table',4);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (31,'2019_10_31_142559_remove_label_settings',5);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (32,'2019_11_06_103020_add_status_to_users',6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (33,'2019_11_06_103056_add_flags_to_candidates',6);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (34,'2019_11_06_105111_add_tel_to_users',7);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (35,'2019_11_06_105504_create_employers_table',8);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (36,'2019_11_06_112620_add_public_flag_to_candidates',9);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (37,'2019_11_06_114220_add_created_by_to_user',10);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (38,'2019_11_08_122038_add_ft_to_users',11);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (39,'2019_11_08_122129_add_ft_to_candidates',12);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (40,'2019_11_08_151655_add_ft_to_candidate_field_user',13);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (41,'2019_11_12_141648_add_ft_to_user_notes',14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (42,'2019_11_12_142207_add_ft_to_user_attachments',14);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (43,'2019_11_13_141841_add_ft_to_employer_field_user',15);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (44,'2019_11_14_111906_add_author_to_user_notes',16);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (45,'2019_11_14_111932_add_author_to_user_attachments',16);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (46,'2019_11_14_113117_create_employments_table',17);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (47,'2019_11_14_113140_create_employment_comments_table',17);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (48,'2019_11_16_103316_add_video_to_candidate',18);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (49,'2019_11_16_124702_create_employment_comment_attachments_table',19);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (50,'2019_11_18_115735_add_ft_to_employment_comments',20);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (51,'2019_11_19_092611_create_categories_table',21);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (52,'2019_11_19_092804_create_category_candidate_pivot',21);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (53,'2019_11_19_102409_add_public_to_categories',22);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (54,'2019_11_22_113242_add_order_interview_date',23);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (55,'2019_11_25_112828_add_order_status',24);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (56,'2019_11_26_112623_change_invoice_order_id_to_user',25);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (57,'2019_11_26_120435_change_auto_increment_for_orders',26);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (58,'2019_11_26_124117_create_invoice_order_table',27);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (59,'2019_11_26_131056_change_invoice_auto_increment',28);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (60,'2019_11_26_141151_create_order_comments_table',29);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (61,'2019_11_26_141216_create_order_comment_attachments_table',29);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (62,'2019_11_27_122652_add_required_to_candidate_group',30);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (63,'2019_11_27_122723_add_required_to_employer_group',30);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (64,'2019_11_27_125158_remove_global_payment_methods',31);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (65,'2019_11_27_125602_add_translate_to_payment_method',32);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (66,'2019_11_27_125838_create_payment_method_fields_table',33);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (67,'2019_11_28_095312_add_ft_to_invoices',34);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (68,'2019_11_28_100654_add_due_date_to_invoices',35);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (69,'2019_11_28_130125_add_default_to_paid',36);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (70,'2019_11_28_142212_create_invoice_categories_table',37);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (71,'2019_11_28_143058_add_category_to_invoice',38);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (72,'2019_11_29_111326_create_vacancies_table',39);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (73,'2019_11_29_111338_create_applications_table',39);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (74,'2019_11_29_113306_create_job_categories_table',39);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (75,'2019_11_29_113504_add_job_category_pivot',39);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (76,'2019_11_29_132503_add_ft_to_vacancies',40);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (77,'2019_11_29_161015_remove_cv_name',41);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (82,'2019_12_03_103958_create_emails_table',42);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (83,'2019_12_03_104013_create_email_attachments_table',42);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (84,'2019_12_03_114410_create_email_resources_table',43);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (85,'2019_12_03_115214_add_ft_to_emails',44);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (86,'2019_12_03_121602_add_unique_to_permissions',45);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (87,'2019_12_03_124415_add_ft_to_email_resources',46);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (88,'2019_12_03_154156_create_candidate_email_pivot',47);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (89,'2019_12_03_154225_create_email_resource_pivot',47);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (90,'2019_12_03_154301_create_email_invoice_pivot',47);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (91,'2019_12_04_124804_add_ptype_to_email',48);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (92,'2019_12_05_140222_add_hash_to_invoice',49);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (99,'2019_12_09_105621_create_sms_gateways_table',50);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (100,'2019_12_09_105651_create_sms_gateway_fields_table',50);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (101,'2019_12_10_124328_create_sms_table',51);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (102,'2019_12_10_124403_create_sms_user_pivot',51);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (103,'2019_12_10_124422_create_sms_category_pivot',51);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (104,'2019_12_10_124451_create_sms__recipients_table',51);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (105,'2019_12_10_150454_add_ft_to_sms',52);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (106,'2019_12_11_105137_make_comment_nullable',53);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (107,'2019_12_11_130611_create_email_templates_table',54);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (108,'2019_12_11_130630_create_sms_templates_table',54);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (109,'2019_12_12_100159_create_interviews_table',55);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (110,'2019_12_12_100843_create_candidate_interview_pivot',55);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (111,'2019_12_12_112423_add_hash_to_interview',56);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (112,'2019_12_12_112819_add_time_to_intervew',57);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (113,'2019_12_12_131135_add_feedback_to_interview',58);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (114,'2019_12_14_110013_create_tests_table',59);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (115,'2019_12_14_110028_create_test_questions_table',59);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (116,'2019_12_14_110039_create_test_options_table',59);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (117,'2019_12_14_112655_create_user_tests_table',60);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (118,'2019_12_14_112708_create_user_test_options_table',60);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (119,'2019_12_14_123345_remove_private_flag',61);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (120,'2019_12_16_152534_add_ft_to_tests',62);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (121,'2019_12_16_152553_add_ft_to_test_questions',62);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (122,'2019_12_19_112932_add_unique_to_slug',63);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (123,'2019_12_19_113959_add_meta_to_articles',64);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (124,'2019_12_19_120636_add_ft_to_articles',65);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (126,'2019_12_19_123009_add_meta_to_blog',66);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (130,'2019_12_20_111515_create_templates_table',67);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (131,'2019_12_20_111527_create_template_options_table',67);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (132,'2019_12_20_111540_create_template_colors_table',67);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (133,'2019_12_21_125524_make_template_directory_unique',68);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (134,'2019_12_29_112309_make_color_nullable',69);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (143,'2019_12_29_132748_create_header_menus_table',70);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (144,'2019_12_29_132819_create_footer_menus_table',70);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (145,'2020_01_02_122445_add_ft_to_blog',71);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (146,'2020_01_02_124757_fix_blog_index',72);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (147,'2020_01_07_094423_add_order_fields',73);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (148,'2020_01_10_120812_create_countries_table',74);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (149,'2020_01_10_120832_create_billing_address_table',74);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (150,'2020_01_15_125407_create_pending_users_table',75);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (153,'2020_01_15_152738_create_pending_user_files_table',76);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (154,'2020_01_23_105902_add_token_to_users',77);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (155,'2020_01_28_110006_add_vacancy_fields',78);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (156,'2020_01_28_134245_remove_cv_from_applications',79);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (157,'2020_01_28_134404_add_cv_to_candidates',80);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (158,'2020_01_29_125809_add_complete_to_user_tests',81);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (159,'2020_02_06_161043_add_database_seeds',82);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (160,'2020_02_15_113532_fix_missing_registration',83);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (161,'2020_02_26_142053_add_demo_template',84);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (162,'2020_03_06_104328_create_order_forms_table',85);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (163,'2020_03_06_104857_modify_order_field_groups',86);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (164,'2020_03_06_111119_add_order_form_id_ot_orders',87);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (165,'2020_03_06_125515_add_columns_to_fields',88);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (166,'2020_03_06_155846_remove_order_forms',89);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (167,'2020_03_06_162057_add_shortlist_option_to_form',90);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (168,'2020_03_06_164228_add_interview_option_to_form',91);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (169,'2020_03_07_114618_add_public_to_employer_field',92);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (170,'2020_03_07_133244_add_full_profile',93);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (171,'2020_03_07_150633_change_candidate_db',94);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (172,'2020_03_07_152023_change_db_type',95);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (173,'2020_03_13_110726_add_salary_type_to_employments',96);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (174,'2020_03_13_130115_add_order_form_sort',97);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (175,'2020_03_14_120618_add_settings_to_order_forms',98);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (178,'2020_03_14_124000_remove_invoice_settings',99);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (179,'2020_04_21_152705_add_notice_settings',100);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (180,'2020_05_27_101809_add_language_setting',101);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (181,'2021_01_05_140051_add_payment_methods_settings',102);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (182,'2021_01_05_140144_add_sms_gateway_settings',102);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (183,'2021_01_05_141559_move_payment_settings',103);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (184,'2021_01_05_162555_move_sms_settings',104);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (185,'2021_03_26_173138_add_jobportal_settings',105);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (186,'2021_05_13_140933_add_captcha_settings',106);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (188,'2021_05_13_143951_move_captcha_values',107);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (189,'2021_08_11_145321_add_candidate_field_fk',108);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (192,'2021_09_01_134605_create_contracts_table',109);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (193,'2021_09_01_134624_create_contract_templates_table',109);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (194,'2021_09_01_172025_add_contract_user_pivot',110);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (195,'2021_09_01_180127_add_contract_description',111);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (196,'2021_09_01_180826_add_contract_permissions',112);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (197,'2021_09_01_182839_add_contract_template_permission',113);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (199,'2021_11_11_125402_add_api_token',114);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (200,'2021_11_23_145128_create_api_tokens_table',115);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (201,'2021_11_26_102851_add_frontend_setting',116);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (202,'2021_12_17_153347_remove_genera_captcha_settings',117);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (203,'2022_06_25_151101_create_mailing_lists_table',118);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (204,'2022_06_29_151555_create_newsletters_table',118);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (205,'2022_07_27_125038_modify_invoice_amount',119);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (206,'2022_07_27_125452_change_amount_length',120);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (207,'2023_01_03_091445_add_newsletter_sent',121);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (208,'2023_01_03_102526_add_newsletter_ft',122);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (209,'2023_01_03_103237_add_newsletter_permissions',123);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (210,'2023_01_03_122438_add_newsletter_from_email',124);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (211,'2023_01_03_132637_create_unsubscribes_table',125);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (212,'2023_02_10_145958_create_courses_table',126);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (213,'2023_02_17_123534_create_course_categories_table',127);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (214,'2023_02_17_123821_create_course_category_pivot',128);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (215,'2023_02_17_125745_course_test_pivot',129);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (216,'2023_02_17_141121_create_course_files_table',130);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (217,'2023_02_17_141346_create_lessons_table',131);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (218,'2023_02_17_142132_create_lectures_table',132);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (219,'2023_02_17_142655_create_lecture_pages_table',133);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (220,'2023_02_17_142853_create_lecture_files_table',134);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (221,'2023_02_27_132627_add_candidate_filter',135);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (223,'2023_03_09_135302_add_gender_setting',136);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (224,'2023_02_17_143116_create_course_user_pivot',137);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (225,'2023_02_17_143131_create_lecture_user_pivot',137);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (226,'2023_03_20_121636_add_course_file_name',137);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (227,'2023_03_20_121732_add_lecture_file_name',137);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (228,'2023_03_20_124458_create_course_instructors_table',138);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (229,'2023_04_03_142157_update_coure_instructor_table',139);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (230,'2023_05_26_145050_add_lecture_page_order',140);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (231,'2023_05_31_122019_add_user_course_status',141);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (232,'2023_05_31_124732_add_lesson_user',142);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (233,'2023_05_31_145822_add_certificate_fields',143);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (234,'2023_06_02_112655_rename_tests_permission_group',144);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (235,'2023_06_02_113214_add_training_permissions',145);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (236,'2023_06_02_114117_add_extra_course_permissions',146);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (237,'2023_06_02_120933_add_private_to_tests',147);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (238,'2023_06_02_121757_remove_test_from_lessons',148);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (239,'2023_06_05_100255_add_zoom_settings',149);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (240,'2023_06_05_101540_add_pinned_to_course',150);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (241,'2023_06_06_153536_add_course_invoice_pivot',151);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (243,'2023_06_12_121142_change_lecture_sort_default',152);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (244,'2023_06_12_121624_change_lecture_page_sort_order',153);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (245,'2023_06_12_121850_change_lessons_sort_order',154);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (246,'2023_06_12_155006_add_course_visibility',155);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (247,'2023_06_14_081821_alter_enforce_order',156);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (249,'2023_07_06_150952_change_salary_column',157);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (250,'2023_07_06_153222_change_invoices_amount',158);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (251,'2023_08_23_100301_add_candidate_fields',159);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (252,'2023_08_23_103748_create_work_experiences_table',160);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (253,'2023_08_25_182942_create_education_table',161);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (254,'2023_08_25_182954_create_skills_table',161);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (255,'2023_08_25_185023_add_file_to_education',162);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (256,'2023_08_29_102541_add_ai_settings',163);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (257,'2023_08_29_122546_add_ai_to_candidate_fields',164);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (258,'2023_09_06_105838_add_location_filter_setting',165);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (259,'2023_09_06_143057_add_max_per_batch_setting',166);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (260,'2023_09_11_144500_add_profile_visibility',167);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (261,'2023_09_11_160051_add_vacany_profile_filter',168);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (262,'2023_09_11_163259_add_recommendation_message',169);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (263,'2023_09_12_130427_add_employer_to_vacancies',170);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (264,'2023_09_21_094554_add_restriction',171);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (265,'2023_09_21_124936_add_report_setting',172);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (266,'2023_09_22_103702_add_vacancy_approval',173);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (268,'2023_09_22_104938_add_notification_option',174);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (270,'2023_09_22_105258_add_employer_application_permission',175);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (271,'2023_09_22_150955_add_admin_vacancy_setting',176);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (272,'2023_09_22_180839_add_cover_letter',177);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (273,'2024_01_29_095101_add_virtual_fields',178);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (274,'2025_03_04_134709_add_order_slug',179);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (275,'2025_03_04_141951_set_form_slugs',180);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (276,'2025_05_13_102302_update_ai_settings',181);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (277,'2025_06_10_113927_add_dates_to_course_user',181);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (278,'2025_07_04_120110_add_ai_bio',182);
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (279,'2025_07_15_152424_create_login_tokens_table',183);
