-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------


-- Dumping structure for table rastepup_new.about
CREATE TABLE IF NOT EXISTS `about` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.about: ~0 rows (approximately)
INSERT INTO `about` (`id`, `title`, `content`, `created_at`, `updated_at`) VALUES
	(1, 'About Us', 'This is about us for', '2025-01-21 19:52:27', '2025-01-21 19:52:27');

-- Dumping structure for table rastepup_new.bcc_recipients
CREATE TABLE IF NOT EXISTS `bcc_recipients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bcc_recipients_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.bcc_recipients: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.categories: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.contact
CREATE TABLE IF NOT EXISTS `contact` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code_id` bigint unsigned DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `added_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contact_country_code_id_foreign` (`country_code_id`),
  KEY `contact_added_by_foreign` (`added_by`),
  KEY `contact_updated_by_foreign` (`updated_by`),
  CONSTRAINT `contact_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `contact_country_code_id_foreign` FOREIGN KEY (`country_code_id`) REFERENCES `country_codes` (`id`),
  CONSTRAINT `contact_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.contact: ~0 rows (approximately)
INSERT INTO `contact` (`id`, `mobile`, `country_code_id`, `email`, `address`, `latitude`, `longitude`, `added_by`, `updated_by`, `created_at`, `updated_at`) VALUES
	(1, '97789098888', 1, 'test@gmail.com', 'New jersey, USA', '39.471905', '-74.562200', NULL, NULL, '2025-01-21 19:52:27', '2025-01-21 19:52:27');

-- Dumping structure for table rastepup_new.contributors
CREATE TABLE IF NOT EXISTS `contributors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.contributors: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.country_codes
CREATE TABLE IF NOT EXISTS `country_codes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_length` int NOT NULL,
  `country_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.country_codes: ~2 rows (approximately)
INSERT INTO `country_codes` (`id`, `country_code`, `mobile_length`, `country_name`, `created_at`, `updated_at`) VALUES
	(1, '+1', 10, 'USA', '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(2, '+91', 10, 'India', '2025-01-21 19:52:27', '2025-01-21 19:52:27');

-- Dumping structure for table rastepup_new.course
CREATE TABLE IF NOT EXISTS `course` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `course_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration_sec` bigint DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_added_by_foreign` (`added_by`),
  KEY `course_updated_by_foreign` (`updated_by`),
  CONSTRAINT `course_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `course_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.course: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.course_quiz
CREATE TABLE IF NOT EXISTS `course_quiz` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `course_id` bigint unsigned NOT NULL,
  `quiz_id` bigint unsigned NOT NULL,
  `answer_option` int DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_quiz_course_id_foreign` (`course_id`),
  KEY `course_quiz_quiz_id_foreign` (`quiz_id`),
  KEY `course_quiz_added_by_foreign` (`added_by`),
  KEY `course_quiz_updated_by_foreign` (`updated_by`),
  CONSTRAINT `course_quiz_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `course_quiz_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `course_quiz_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quiz` (`id`),
  CONSTRAINT `course_quiz_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.course_quiz: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.course_stages
CREATE TABLE IF NOT EXISTS `course_stages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `course_id` bigint unsigned NOT NULL,
  `stage_id` bigint unsigned NOT NULL,
  `order_id` int unsigned DEFAULT NULL,
  `duration_sec` bigint DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `course_stages_course_id_foreign` (`course_id`),
  KEY `course_stages_stage_id_foreign` (`stage_id`),
  KEY `course_stages_added_by_foreign` (`added_by`),
  KEY `course_stages_updated_by_foreign` (`updated_by`),
  CONSTRAINT `course_stages_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `course_stages_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `course_stages_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`),
  CONSTRAINT `course_stages_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.course_stages: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.evaluations
CREATE TABLE IF NOT EXISTS `evaluations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` int NOT NULL COMMENT '1-choice, 2-input',
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.evaluations: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.evaluation_choices
CREATE TABLE IF NOT EXISTS `evaluation_choices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `evaluation_id` bigint unsigned NOT NULL,
  `choice` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `choice_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `evaluation_choices_evaluation_id_foreign` (`evaluation_id`),
  CONSTRAINT `evaluation_choices_evaluation_id_foreign` FOREIGN KEY (`evaluation_id`) REFERENCES `evaluations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.evaluation_choices: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.faqs
CREATE TABLE IF NOT EXISTS `faqs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1:Active, 2:Blocked',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.faqs: ~2 rows (approximately)
INSERT INTO `faqs` (`id`, `question`, `answer`, `status`, `created_at`, `updated_at`) VALUES
	(1, 'What is a FAQ page?', 'Let’s begin by understanding what a FAQ or Frequently Asked Questions page means, because if you don’t understand this, then the rest of the article will be hard to understand.', 1, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(2, 'Why are FAQ pages important for ecommerce stores?', 'Look, here is the deal; many stores often get asked the same questions over and over again from potential customers and existing customers. For example, questions like “How long does shipping take?” or “Can I cancel my order?”', 1, '2025-01-21 19:52:27', '2025-01-21 19:52:27');

-- Dumping structure for table rastepup_new.feedbacks
CREATE TABLE IF NOT EXISTS `feedbacks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `feedback` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_id` bigint unsigned NOT NULL,
  `added_by` bigint unsigned NOT NULL,
  `type` int NOT NULL COMMENT '1:Course, 2:Stage, 3:Module, 4:Section, 5:Video',
  `type_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `feedbacks_added_by_foreign` (`added_by`),
  CONSTRAINT `feedbacks_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.feedbacks: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.feedback_recipients
CREATE TABLE IF NOT EXISTS `feedback_recipients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `feedback_recipients_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.forgot_token: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.gi_questions
CREATE TABLE IF NOT EXISTS `gi_questions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_of_choice` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.gi_questions: ~14 rows (approximately)
INSERT INTO `gi_questions` (`id`, `question`, `no_of_choice`, `created_at`, `updated_at`) VALUES
	(1, 'APP Type', 7, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(2, 'Would you Like to participate in a mentorship program? [Mentors are experienced faculty (Physicians/NPs/PAs) in the gastroenterology or hepatology field]', 2, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(3, 'How many years have you practiced in Gastroenterology or hepatology?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(4, 'If practicing, how many patients do you see per week?', 1, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(5, 'On a scale of 1-5 how confident do you feel in managing patients with GERD?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(6, 'On a scale of 1-5 how confident do you feel in managing patients with IBS?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(7, 'On a scale of 1-5 how confident do you feel in managing patients with MASH?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(8, 'On a scale of 1-5 how confident do you feel in managing patients with Hepatitis C?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(9, 'On a scale of 1-5 how confident do you feel in managing patients with diarrhea?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(10, 'On a scale of 1-5 how confident do you feel in managing patients with Primary Biliary Cholangitis?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(11, 'On a scale of 1-5 how confident do you feel in managing patients with Cirrhosis and/or ascites?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(12, 'On a scale of 1-5 how confident do you feel in managing patients presenting with epigastric pain?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(13, 'On a scale of 1-5 how confident do you feel in managing patients presenting with jaundice?', 5, '2025-01-21 19:52:28', '2025-01-21 19:52:28'),
	(14, 'How did you hear about A Step up To GI? ', 1, '2025-01-21 19:52:28', '2025-01-21 19:52:28');

-- Dumping structure for table rastepup_new.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.migrations: ~0 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(1, '2014_10_12_100000_create_password_reset_tokens_table', 1),
	(2, '2019_08_19_000000_create_failed_jobs_table', 1),
	(3, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(4, '2024_02_05_073502_create_roles_table', 1),
	(5, '2024_02_05_073512_create_country_codes_table', 1),
	(6, '2024_02_05_073522_create_organizations_table', 1),
	(7, '2024_02_05_073532_create_users_table', 1),
	(8, '2024_02_05_073545_create_sliders_table', 1),
	(9, '2024_02_05_073619_create_privacy_policy_table', 1),
	(10, '2024_02_05_073635_create_terms_table', 1),
	(11, '2024_02_05_073700_create_about_table', 1),
	(12, '2024_02_05_073820_create_settings_table', 1),
	(13, '2024_02_05_074021_create_faqs_table', 1),
	(14, '2024_02_05_074104_create_categories_table', 1),
	(15, '2024_02_05_074142_create_contributors_table', 1),
	(16, '2024_02_05_074209_create_videos_table', 1),
	(17, '2024_02_05_074229_create_video_resources_table', 1),
	(18, '2024_02_05_074247_create_quiz_table', 1),
	(19, '2024_02_05_074301_create_quiz_choices_table', 1),
	(20, '2024_02_05_074328_create_sections_table', 1),
	(21, '2024_02_05_074338_create_section_videos_table', 1),
	(22, '2024_02_05_074344_create_section_quiz_table', 1),
	(23, '2024_02_05_074351_create_modules_table', 1),
	(24, '2024_02_05_074353_create_module_sections_table', 1),
	(25, '2024_02_05_074355_create_module_quiz_table', 1),
	(26, '2024_02_05_074414_create_stages_table', 1),
	(27, '2024_02_05_074432_create_stage_modules_table', 1),
	(28, '2024_02_05_074454_create_stage_quiz_table', 1),
	(29, '2024_02_05_074556_create_course_table', 1),
	(30, '2024_02_05_074613_create_course_stages_table', 1),
	(31, '2024_02_05_074640_create_course_quiz_table', 1),
	(32, '2024_02_05_074656_create_organization_courses_table', 1),
	(33, '2024_02_05_075107_create_user_courses_table', 1),
	(34, '2024_02_05_075122_create_feedback_recipients_table', 1),
	(35, '2024_02_05_075208_create_notifications_table', 1),
	(36, '2024_02_05_075222_create_feedbacks_table', 1),
	(37, '2024_02_05_075242_create_evaluations_table', 1),
	(38, '2024_02_05_110508_create_evaluation_choices_table', 1),
	(39, '2024_02_05_113411_create_user_evaluation_table', 1),
	(40, '2024_02_06_082853_create_user_quiz_answers_table', 1),
	(41, '2024_02_28_073111_create_user_stages_table', 1),
	(42, '2024_02_28_073143_create_user_modules_table', 1),
	(43, '2024_02_28_073150_create_user_sections_table', 1),
	(44, '2024_03_01_063536_create_contact_table', 1),
	(45, '2024_03_01_080038_add_type_id_to_feedbacks_table', 1),
	(46, '2024_03_13_054833_create_user_certificates_table', 1),
	(47, '2024_03_14_051829_create_user_videos_table', 1),
	(48, '2024_04_01_051546_add_quiz_correct_to_user_sections_table', 1),
	(49, '2024_04_01_062453_add_quiz_correct_to_user_modules_table', 1),
	(50, '2024_04_01_065434_add_quiz_correct_to_user_stages_table', 1),
	(51, '2024_04_01_072712_add_quiz_correct_to_user_courses_table', 1),
	(52, '2024_04_18_104904_create_user_evaluation_status_table', 1),
	(53, '2024_04_22_091850_create_forgot_token_table', 1),
	(54, '2024_04_29_045256_add_order_id_to_course_stages_table', 1),
	(55, '2024_08_12_030323_create_quiz_criteria_table', 1),
	(56, '2025_01_06_233631_create_ra_questions_table', 1),
	(57, '2025_01_06_233645_create_gi_questions_table', 1),
	(58, '2025_01_07_005448_create_user_signup_evaluation_table', 1),
	(59, '2025_01_07_011455_create_user_details_table', 1),
	(60, '2025_01_08_234535_create_bcc_recipients_table', 1);

-- Dumping structure for table rastepup_new.modules
CREATE TABLE IF NOT EXISTS `modules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `module_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `modules_added_by_foreign` (`added_by`),
  KEY `modules_updated_by_foreign` (`updated_by`),
  CONSTRAINT `modules_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `modules_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.modules: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.module_quiz
CREATE TABLE IF NOT EXISTS `module_quiz` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `module_id` bigint unsigned NOT NULL,
  `quiz_id` bigint unsigned NOT NULL,
  `answer_option` int DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `module_quiz_module_id_foreign` (`module_id`),
  KEY `module_quiz_quiz_id_foreign` (`quiz_id`),
  KEY `module_quiz_added_by_foreign` (`added_by`),
  KEY `module_quiz_updated_by_foreign` (`updated_by`),
  CONSTRAINT `module_quiz_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `module_quiz_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`),
  CONSTRAINT `module_quiz_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quiz` (`id`),
  CONSTRAINT `module_quiz_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.module_quiz: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.module_sections
CREATE TABLE IF NOT EXISTS `module_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `module_id` bigint unsigned NOT NULL,
  `section_id` bigint unsigned NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `module_sections_module_id_foreign` (`module_id`),
  KEY `module_sections_section_id_foreign` (`section_id`),
  KEY `module_sections_added_by_foreign` (`added_by`),
  KEY `module_sections_updated_by_foreign` (`updated_by`),
  CONSTRAINT `module_sections_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `module_sections_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`),
  CONSTRAINT `module_sections_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`),
  CONSTRAINT `module_sections_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.module_sections: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.notifications
CREATE TABLE IF NOT EXISTS `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` int NOT NULL COMMENT '1:Organization, 2:All Users, 3:Specific User, 4:Course',
  `user_id` bigint unsigned DEFAULT NULL,
  `course_id` bigint unsigned DEFAULT NULL,
  `organization_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_user_id_foreign` (`user_id`),
  KEY `notifications_course_id_foreign` (`course_id`),
  KEY `notifications_organization_id_foreign` (`organization_id`),
  CONSTRAINT `notifications_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `notifications_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`),
  CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.notifications: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.organizations
CREATE TABLE IF NOT EXISTS `organizations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code_id` bigint unsigned DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `organizations_country_code_id_foreign` (`country_code_id`),
  CONSTRAINT `organizations_country_code_id_foreign` FOREIGN KEY (`country_code_id`) REFERENCES `country_codes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.organizations: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.organization_courses
CREATE TABLE IF NOT EXISTS `organization_courses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `organization_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `stage_flow` int NOT NULL DEFAULT '2' COMMENT '1-yes, 2-no',
  `module_flow` int NOT NULL DEFAULT '2' COMMENT '1-yes, 2-no',
  `section_flow` int NOT NULL DEFAULT '2' COMMENT '1-yes, 2-no',
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `organization_courses_organization_id_foreign` (`organization_id`),
  KEY `organization_courses_course_id_foreign` (`course_id`),
  KEY `organization_courses_added_by_foreign` (`added_by`),
  KEY `organization_courses_updated_by_foreign` (`updated_by`),
  CONSTRAINT `organization_courses_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `organization_courses_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `organization_courses_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`),
  CONSTRAINT `organization_courses_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.personal_access_tokens: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.privacy_policy
CREATE TABLE IF NOT EXISTS `privacy_policy` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.privacy_policy: ~0 rows (approximately)
INSERT INTO `privacy_policy` (`id`, `title`, `content`, `created_at`, `updated_at`) VALUES
	(1, 'Privacy Policy', 'This is Privacy Policy for ', '2025-01-21 19:52:27', '2025-01-21 19:52:27');

-- Dumping structure for table rastepup_new.quiz
CREATE TABLE IF NOT EXISTS `quiz` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` time NOT NULL,
  `answer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer_explanation` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quiz_category_id_foreign` (`category_id`),
  KEY `quiz_added_by_foreign` (`added_by`),
  KEY `quiz_updated_by_foreign` (`updated_by`),
  CONSTRAINT `quiz_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `quiz_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `quiz_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.quiz: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.quiz_choices
CREATE TABLE IF NOT EXISTS `quiz_choices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `quiz_id` bigint unsigned NOT NULL,
  `choice` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `choice_id` int NOT NULL,
  `is_answer` int NOT NULL COMMENT '1:yes, 2:no',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quiz_choices_quiz_id_foreign` (`quiz_id`),
  KEY `quiz_choices_added_by_foreign` (`added_by`),
  KEY `quiz_choices_updated_by_foreign` (`updated_by`),
  CONSTRAINT `quiz_choices_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `quiz_choices_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quiz` (`id`),
  CONSTRAINT `quiz_choices_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.quiz_choices: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.quiz_criteria
CREATE TABLE IF NOT EXISTS `quiz_criteria` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `course_id` bigint unsigned NOT NULL,
  `course_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',
  `stage_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',
  `module_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',
  `section_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',
  `course_explanation` int NOT NULL DEFAULT '2' COMMENT '1-yes, 2-no',
  `stage_explanation` int NOT NULL DEFAULT '2' COMMENT '1-yes, 2-no',
  `module_explanation` int NOT NULL DEFAULT '2' COMMENT '1-yes, 2-no',
  `section_explanation` int NOT NULL DEFAULT '2' COMMENT '1-yes, 2-no',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quiz_criteria_course_id_foreign` (`course_id`),
  CONSTRAINT `quiz_criteria_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.quiz_criteria: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.ra_questions
CREATE TABLE IF NOT EXISTS `ra_questions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_of_choice` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.ra_questions: ~11 rows (approximately)
INSERT INTO `ra_questions` (`id`, `question`, `no_of_choice`, `created_at`, `updated_at`) VALUES
	(1, 'APP Type', 7, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(2, 'Would you like a complimentary membership to RhAPP?', 2, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(3, 'Would you like to be connected to a mentor? (Mentors are experienced RhAPP faculty)', 2, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(4, 'How many years of experience do you have in rheumatology?', 5, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(5, 'On a scale of 1-10 how confident do you feel managing patients with PsA?', 10, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(6, 'On a scale of 1-10 how confident do you feel managing patients with axSpA (AS & nr-axSpA)?', 10, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(7, 'On a scale of 1-10 how confident do you feel managing patients with SLE?', 10, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(8, 'On a scale of 1-10 how confident do you feel managing patients with gout?', 10, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(9, 'On a scale of 1-10 how confident do you feel managing patients with RA?', 10, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(10, 'On a scale of 1-10 how confident do you feel managing patients with vasculitis?', 10, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(11, 'On a scale of 1-10 how confident do you feel managing patients with inflammatory myopathies?', 10, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(12, 'On a scale of 1-10 how confident do you feel managing patients with pediatric rheumatologic conditions?', 10, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(13, 'On a scale of 1-10 how confident do you feel prescribing medications to your patients?', 10, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(14, 'How many patients do you see per week?', 1, '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(15, 'How did you hear about A Step Up to Rheumatology?', 1, '2025-01-21 19:52:27', '2025-01-21 19:52:27');

-- Dumping structure for table rastepup_new.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.roles: ~3 rows (approximately)
INSERT INTO `roles` (`id`, `role`, `created_at`, `updated_at`) VALUES
	(1, 'Admin', '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(2, 'Organization Admin', '2025-01-21 19:52:27', '2025-01-21 19:52:27'),
	(3, 'User', '2025-01-21 19:52:27', '2025-01-21 19:52:27');

-- Dumping structure for table rastepup_new.sections
CREATE TABLE IF NOT EXISTS `sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `section_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sections_added_by_foreign` (`added_by`),
  KEY `sections_updated_by_foreign` (`updated_by`),
  CONSTRAINT `sections_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `sections_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.sections: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.section_quiz
CREATE TABLE IF NOT EXISTS `section_quiz` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `section_id` bigint unsigned NOT NULL,
  `quiz_id` bigint unsigned NOT NULL,
  `answer_option` int DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `section_quiz_section_id_foreign` (`section_id`),
  KEY `section_quiz_quiz_id_foreign` (`quiz_id`),
  KEY `section_quiz_added_by_foreign` (`added_by`),
  KEY `section_quiz_updated_by_foreign` (`updated_by`),
  CONSTRAINT `section_quiz_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `section_quiz_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quiz` (`id`),
  CONSTRAINT `section_quiz_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`),
  CONSTRAINT `section_quiz_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.section_quiz: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.section_videos
CREATE TABLE IF NOT EXISTS `section_videos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `section_id` bigint unsigned NOT NULL,
  `video_id` bigint unsigned NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `section_videos_section_id_foreign` (`section_id`),
  KEY `section_videos_video_id_foreign` (`video_id`),
  KEY `section_videos_added_by_foreign` (`added_by`),
  KEY `section_videos_updated_by_foreign` (`updated_by`),
  CONSTRAINT `section_videos_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `section_videos_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`),
  CONSTRAINT `section_videos_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `section_videos_video_id_foreign` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.section_videos: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `course_expiration` int NOT NULL DEFAULT '1',
  `default_organization` bigint unsigned DEFAULT NULL,
  `maintenance_web` int NOT NULL DEFAULT '0' COMMENT '0:No ,1:Yes',
  `maintenance_reason_web` text COLLATE utf8mb4_unicode_ci,
  `added_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `settings_default_organization_foreign` (`default_organization`),
  KEY `settings_added_by_foreign` (`added_by`),
  KEY `settings_updated_by_foreign` (`updated_by`),
  CONSTRAINT `settings_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `settings_default_organization_foreign` FOREIGN KEY (`default_organization`) REFERENCES `organizations` (`id`),
  CONSTRAINT `settings_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.settings: ~0 rows (approximately)
INSERT INTO `settings` (`id`, `course_expiration`, `default_organization`, `maintenance_web`, `maintenance_reason_web`, `added_by`, `updated_by`, `created_at`, `updated_at`) VALUES
	(1, 2, NULL, 0, ' ', 1, 1, '2025-01-21 19:52:27', '2025-01-21 19:52:27');

-- Dumping structure for table rastepup_new.sliders
CREATE TABLE IF NOT EXISTS `sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` int DEFAULT '1' COMMENT '1:Main Slider, 2:Bottom Slider',
  `status` int NOT NULL DEFAULT '1' COMMENT '1:Active, 2:Blocked',
  `added_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sliders_added_by_foreign` (`added_by`),
  KEY `sliders_updated_by_foreign` (`updated_by`),
  CONSTRAINT `sliders_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `sliders_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.sliders: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.stages
CREATE TABLE IF NOT EXISTS `stages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `stage_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stages_added_by_foreign` (`added_by`),
  KEY `stages_updated_by_foreign` (`updated_by`),
  CONSTRAINT `stages_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `stages_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.stages: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.stage_modules
CREATE TABLE IF NOT EXISTS `stage_modules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `stage_id` bigint unsigned NOT NULL,
  `module_id` bigint unsigned NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stage_modules_stage_id_foreign` (`stage_id`),
  KEY `stage_modules_module_id_foreign` (`module_id`),
  KEY `stage_modules_added_by_foreign` (`added_by`),
  KEY `stage_modules_updated_by_foreign` (`updated_by`),
  CONSTRAINT `stage_modules_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `stage_modules_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`),
  CONSTRAINT `stage_modules_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`),
  CONSTRAINT `stage_modules_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.stage_modules: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.stage_quiz
CREATE TABLE IF NOT EXISTS `stage_quiz` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `stage_id` bigint unsigned NOT NULL,
  `quiz_id` bigint unsigned NOT NULL,
  `answer_option` int DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stage_quiz_stage_id_foreign` (`stage_id`),
  KEY `stage_quiz_quiz_id_foreign` (`quiz_id`),
  KEY `stage_quiz_added_by_foreign` (`added_by`),
  KEY `stage_quiz_updated_by_foreign` (`updated_by`),
  CONSTRAINT `stage_quiz_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `stage_quiz_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quiz` (`id`),
  CONSTRAINT `stage_quiz_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`),
  CONSTRAINT `stage_quiz_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.stage_quiz: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.terms
CREATE TABLE IF NOT EXISTS `terms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.terms: ~0 rows (approximately)
INSERT INTO `terms` (`id`, `title`, `content`, `created_at`, `updated_at`) VALUES
	(1, 'Terms and Conditions', 'This is Terms and Conditions for ', '2025-01-21 19:52:27', '2025-01-21 19:52:27');

-- Dumping structure for table rastepup_new.user_certificates
CREATE TABLE IF NOT EXISTS `user_certificates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `pdf` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_certificates_user_id_foreign` (`user_id`),
  KEY `user_certificates_course_id_foreign` (`course_id`),
  CONSTRAINT `user_certificates_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `user_certificates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_certificates: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.user_courses
CREATE TABLE IF NOT EXISTS `user_courses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `organization_id` bigint unsigned NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-pending, 2-ongoing, 3-completed',
  `quiz_result` int NOT NULL DEFAULT '0' COMMENT '0-pending, 1-completed',
  `quiz_correct` decimal(5,2) NOT NULL DEFAULT '0.00',
  `total_hours` time DEFAULT NULL,
  `completed_hours` time DEFAULT NULL,
  `completed_at` date DEFAULT NULL,
  `expire_on` date DEFAULT NULL,
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_courses_user_id_foreign` (`user_id`),
  KEY `user_courses_course_id_foreign` (`course_id`),
  KEY `user_courses_organization_id_foreign` (`organization_id`),
  KEY `user_courses_added_by_foreign` (`added_by`),
  KEY `user_courses_updated_by_foreign` (`updated_by`),
  CONSTRAINT `user_courses_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_courses_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `user_courses_organization_id_foreign` FOREIGN KEY (`organization_id`) REFERENCES `organizations` (`id`),
  CONSTRAINT `user_courses_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_courses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_courses: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.user_details
CREATE TABLE IF NOT EXISTS `user_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `practice_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_details_user_id_foreign` (`user_id`),
  CONSTRAINT `user_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_details: ~2 rows (approximately)
INSERT INTO `user_details` (`id`, `user_id`, `first_name`, `last_name`, `address_1`, `address_2`, `city`, `state`, `zip_code`, `practice_name`, `company_name`, `created_at`, `updated_at`) VALUES
	(1, 2, 'Kiran', 'Kannan', 'test address 1', 'test address 2', 'Alpy', 'Kerala', '7907530222', NULL, 'Sigosoft', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(2, 3, 'Kiran', 'Kannan', 'test address 1', 'test address 2', 'Alpy', 'Kerala', '7907530221', 'GI', NULL, '2025-01-21 20:01:33', '2025-01-21 20:01:33');

-- Dumping structure for table rastepup_new.user_evaluation
CREATE TABLE IF NOT EXISTS `user_evaluation` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `evaluation_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `type` int NOT NULL COMMENT '1-choice, 2-input',
  `choice_id` int DEFAULT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_evaluation_user_id_foreign` (`user_id`),
  KEY `user_evaluation_evaluation_id_foreign` (`evaluation_id`),
  KEY `user_evaluation_course_id_foreign` (`course_id`),
  CONSTRAINT `user_evaluation_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `user_evaluation_evaluation_id_foreign` FOREIGN KEY (`evaluation_id`) REFERENCES `evaluations` (`id`),
  CONSTRAINT `user_evaluation_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_evaluation: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.user_evaluation_status
CREATE TABLE IF NOT EXISTS `user_evaluation_status` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-Pending, 2-Completed',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_evaluation_status_user_id_foreign` (`user_id`),
  KEY `user_evaluation_status_course_id_foreign` (`course_id`),
  CONSTRAINT `user_evaluation_status_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `user_evaluation_status_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_evaluation_status: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.user_modules
CREATE TABLE IF NOT EXISTS `user_modules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `stage_id` bigint unsigned NOT NULL,
  `module_id` bigint unsigned NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-pending, 2-ongoing, 3-completed',
  `quiz_result` int NOT NULL DEFAULT '0' COMMENT '0-pending, 1-completed',
  `quiz_correct` decimal(5,2) NOT NULL DEFAULT '0.00',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_modules_user_id_foreign` (`user_id`),
  KEY `user_modules_course_id_foreign` (`course_id`),
  KEY `user_modules_stage_id_foreign` (`stage_id`),
  KEY `user_modules_module_id_foreign` (`module_id`),
  KEY `user_modules_added_by_foreign` (`added_by`),
  KEY `user_modules_updated_by_foreign` (`updated_by`),
  CONSTRAINT `user_modules_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_modules_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `user_modules_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`),
  CONSTRAINT `user_modules_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`),
  CONSTRAINT `user_modules_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_modules_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_modules: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.user_quiz_answers
CREATE TABLE IF NOT EXISTS `user_quiz_answers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `quiz_id` bigint unsigned NOT NULL,
  `choice_id` bigint unsigned NOT NULL,
  `answer_option` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_quiz_answers_user_id_foreign` (`user_id`),
  KEY `user_quiz_answers_quiz_id_foreign` (`quiz_id`),
  KEY `user_quiz_answers_choice_id_foreign` (`choice_id`),
  CONSTRAINT `user_quiz_answers_choice_id_foreign` FOREIGN KEY (`choice_id`) REFERENCES `quiz_choices` (`id`),
  CONSTRAINT `user_quiz_answers_quiz_id_foreign` FOREIGN KEY (`quiz_id`) REFERENCES `quiz` (`id`),
  CONSTRAINT `user_quiz_answers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_quiz_answers: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.user_sections
CREATE TABLE IF NOT EXISTS `user_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `stage_id` bigint unsigned NOT NULL,
  `module_id` bigint unsigned NOT NULL,
  `section_id` bigint unsigned NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-pending, 2-ongoing, 3-completed',
  `quiz_result` int NOT NULL DEFAULT '0' COMMENT '0-pending, 1-completed',
  `quiz_correct` decimal(5,2) NOT NULL DEFAULT '0.00',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_sections_user_id_foreign` (`user_id`),
  KEY `user_sections_course_id_foreign` (`course_id`),
  KEY `user_sections_stage_id_foreign` (`stage_id`),
  KEY `user_sections_module_id_foreign` (`module_id`),
  KEY `user_sections_section_id_foreign` (`section_id`),
  KEY `user_sections_added_by_foreign` (`added_by`),
  KEY `user_sections_updated_by_foreign` (`updated_by`),
  CONSTRAINT `user_sections_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_sections_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `user_sections_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`),
  CONSTRAINT `user_sections_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`),
  CONSTRAINT `user_sections_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`),
  CONSTRAINT `user_sections_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_sections_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_sections: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.user_signup_evaluation
CREATE TABLE IF NOT EXISTS `user_signup_evaluation` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `question_id` int NOT NULL,
  `answer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_signup_evaluation_user_id_foreign` (`user_id`),
  CONSTRAINT `user_signup_evaluation_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_signup_evaluation: ~28 rows (approximately)
INSERT INTO `user_signup_evaluation` (`id`, `user_id`, `question_id`, `answer`, `comments`, `created_at`, `updated_at`) VALUES
	(1, 2, 1, 'Other', 'test', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(2, 2, 2, 'Yes', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(3, 2, 3, '0-2 years', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(4, 2, 4, '13', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(5, 2, 5, '1', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(6, 2, 6, '2', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(7, 2, 7, '3', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(8, 2, 8, '4', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(9, 2, 9, '5', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(10, 2, 10, '4', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(11, 2, 11, '3', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(12, 2, 12, '2', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(13, 2, 13, '1', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(14, 2, 14, 'test', '', '2025-01-21 19:58:28', '2025-01-21 19:58:28'),
	(15, 3, 1, 'Other', 'test', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(16, 3, 2, 'Yes', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(17, 3, 3, '0-2 years', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(18, 3, 4, '13', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(19, 3, 5, '1', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(20, 3, 6, '2', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(21, 3, 7, '3', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(22, 3, 8, '4', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(23, 3, 9, '5', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(24, 3, 10, '4', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(25, 3, 11, '3', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(26, 3, 12, '2', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(27, 3, 13, '1', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33'),
	(28, 3, 14, 'test', '', '2025-01-21 20:01:33', '2025-01-21 20:01:33');

-- Dumping structure for table rastepup_new.user_stages
CREATE TABLE IF NOT EXISTS `user_stages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `stage_id` bigint unsigned NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-pending, 2-ongoing, 3-completed',
  `quiz_result` int NOT NULL DEFAULT '0' COMMENT '0-pending, 1-completed',
  `quiz_correct` decimal(5,2) NOT NULL DEFAULT '0.00',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_stages_user_id_foreign` (`user_id`),
  KEY `user_stages_course_id_foreign` (`course_id`),
  KEY `user_stages_stage_id_foreign` (`stage_id`),
  KEY `user_stages_added_by_foreign` (`added_by`),
  KEY `user_stages_updated_by_foreign` (`updated_by`),
  CONSTRAINT `user_stages_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_stages_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `user_stages_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`),
  CONSTRAINT `user_stages_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_stages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_stages: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.user_videos
CREATE TABLE IF NOT EXISTS `user_videos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `course_id` bigint unsigned NOT NULL,
  `stage_id` bigint unsigned NOT NULL,
  `module_id` bigint unsigned NOT NULL,
  `section_id` bigint unsigned NOT NULL,
  `video_id` bigint unsigned NOT NULL,
  `watch_status` int NOT NULL DEFAULT '2' COMMENT '1-yes, 2-no,',
  `quiz_result` int NOT NULL DEFAULT '0',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_videos_user_id_foreign` (`user_id`),
  KEY `user_videos_course_id_foreign` (`course_id`),
  KEY `user_videos_stage_id_foreign` (`stage_id`),
  KEY `user_videos_module_id_foreign` (`module_id`),
  KEY `user_videos_section_id_foreign` (`section_id`),
  KEY `user_videos_video_id_foreign` (`video_id`),
  KEY `user_videos_added_by_foreign` (`added_by`),
  KEY `user_videos_updated_by_foreign` (`updated_by`),
  CONSTRAINT `user_videos_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_videos_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `user_videos_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`),
  CONSTRAINT `user_videos_section_id_foreign` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`),
  CONSTRAINT `user_videos_stage_id_foreign` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`),
  CONSTRAINT `user_videos_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_videos_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `user_videos_video_id_foreign` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.user_videos: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.videos
CREATE TABLE IF NOT EXISTS `videos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `video_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `contributor_id` bigint unsigned NOT NULL,
  `video_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `duration` time NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `organization` int NOT NULL DEFAULT '0' COMMENT '0: All',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `videos_category_id_foreign` (`category_id`),
  KEY `videos_contributor_id_foreign` (`contributor_id`),
  KEY `videos_added_by_foreign` (`added_by`),
  KEY `videos_updated_by_foreign` (`updated_by`),
  CONSTRAINT `videos_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `videos_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `videos_contributor_id_foreign` FOREIGN KEY (`contributor_id`) REFERENCES `contributors` (`id`),
  CONSTRAINT `videos_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.videos: ~0 rows (approximately)

-- Dumping structure for table rastepup_new.video_resources
CREATE TABLE IF NOT EXISTS `video_resources` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `resource_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` bigint unsigned NOT NULL,
  `type` int NOT NULL COMMENT '1-pdf, 2-link',
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pdf` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '1-active, 2-blocked',
  `added_by` bigint unsigned NOT NULL DEFAULT '1',
  `updated_by` bigint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `video_resources_video_id_foreign` (`video_id`),
  KEY `video_resources_added_by_foreign` (`added_by`),
  KEY `video_resources_updated_by_foreign` (`updated_by`),
  CONSTRAINT `video_resources_added_by_foreign` FOREIGN KEY (`added_by`) REFERENCES `users` (`id`),
  CONSTRAINT `video_resources_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `video_resources_video_id_foreign` FOREIGN KEY (`video_id`) REFERENCES `videos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rastepup_new.video_resources: ~0 rows (approximately)

