Convert the table names to PASCAL case  "-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jun 08, 2024 at 06:32 AM
-- Server version: 8.0.27
-- PHP Version: 8.2.13

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `mentallabdb2`
--
CREATE DATABASE IF NOT EXISTS `mentallabdb2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `mentallabdb2`;

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

--
-- Table structure for table `acceptedserviceproviderareaofexpertise`
--

DROP TABLE IF EXISTS `acceptedserviceproviderareaofexpertise`;
CREATE TABLE IF NOT EXISTS `acceptedserviceproviderareaofexpertise` (
  `AcceptedServiceProvidersId` int NOT NULL,
  `AreaOfExpertiseId` int NOT NULL,
  PRIMARY KEY (`AcceptedServiceProvidersId`,`AreaOfExpertiseId`),
  KEY `IX_AcceptedServiceProviderAreaOfExpertise_AreaOfExpertiseId` (`AreaOfExpertiseId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `acceptedserviceproviders`
--

DROP TABLE IF EXISTS `acceptedserviceproviders`;
CREATE TABLE IF NOT EXISTS `acceptedserviceproviders` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Email` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `Gender` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `LocationId` int NOT NULL,
  `FirstName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `LastName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `OtherName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `PhoneNumber` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_AcceptedServiceProviders_CreatedById` (`CreatedById`),
  KEY `IX_AcceptedServiceProviders_LocationId` (`LocationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `applicationusergroup`
--

DROP TABLE IF EXISTS `applicationusergroup`;
CREATE TABLE IF NOT EXISTS `applicationusergroup` (
  `GroupsId` int NOT NULL,
  `MembersId` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`GroupsId`,`MembersId`),
  KEY `IX_ApplicationUserGroup_MembersId` (`MembersId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `areaofexpertises`
--

DROP TABLE IF EXISTS `areaofexpertises`;
CREATE TABLE IF NOT EXISTS `areaofexpertises` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `Description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `CreatedById` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  `DeletedDate` datetime(6) DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `UpdatedDate` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  `LanguageId` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_AreaOfExpertises_CreatedById` (`CreatedById`),
  KEY `IX_AreaOfExpertises_LanguageId` (`LanguageId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `areaofexpertiseserviceprovider`
--

DROP TABLE IF EXISTS `areaofexpertiseserviceprovider`;
CREATE TABLE IF NOT EXISTS `areaofexpertiseserviceprovider` (
  `AreaOfExpertiseId` int NOT NULL,
  `ServiceProvidersId` int NOT NULL,
  PRIMARY KEY (`AreaOfExpertiseId`,`ServiceProvidersId`),
  KEY `IX_AreaOfExpertiseServiceProvider_ServiceProvidersId` (`ServiceProvidersId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Categories_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `channels`
--

DROP TABLE IF EXISTS `channels`;
CREATE TABLE IF NOT EXISTS `channels` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Platform` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ChannelId` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Key` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `Secrete` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `Default` tinyint(1) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Channels_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `clientsubscriptions`
--

DROP TABLE IF EXISTS `clientsubscriptions`;
CREATE TABLE IF NOT EXISTS `clientsubscriptions` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ClientId` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TranscritionId` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Amount` decimal(19,4) NOT NULL,
  `DatePaid` datetime(6) NOT NULL,
  `ExpiryDate` datetime(6) NOT NULL,
  `PaymentMode` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ClientSubscriptions_ClientId` (`ClientId`),
  KEY `IX_ClientSubscriptions_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `district`
--

DROP TABLE IF EXISTS `district`;
CREATE TABLE IF NOT EXISTS `district` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `RegionId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_District_CreatedById` (`CreatedById`),
  KEY `IX_District_RegionId` (`RegionId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `grouprequests`
--

DROP TABLE IF EXISTS `grouprequests`;
CREATE TABLE IF NOT EXISTS `grouprequests` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `GroupId` int NOT NULL,
  `UserId` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `RequestStatus` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `Reason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  PRIMARY KEY (`Id`),
  KEY `IX_GroupRequests_CreatedById` (`CreatedById`),
  KEY `IX_GroupRequests_GroupId` (`GroupId`),
  KEY `IX_GroupRequests_UserId` (`UserId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `groups`
--

DROP TABLE IF EXISTS `groups`;
CREATE TABLE IF NOT EXISTS `groups` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Restricted` tinyint(1) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `ImagePath` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MinimumAge` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_Groups_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `languages`
--

DROP TABLE IF EXISTS `languages`;
CREATE TABLE IF NOT EXISTS `languages` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Languages_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `locations`
--

DROP TABLE IF EXISTS `locations`;
CREATE TABLE IF NOT EXISTS `locations` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Locations_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `mentalhealthinstitutions`
--

DROP TABLE IF EXISTS `mentalhealthinstitutions`;
CREATE TABLE IF NOT EXISTS `mentalhealthinstitutions` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_MentalHealthInstitutions_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `GroupId` int NOT NULL,
  `Content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `UserId` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Messages_CreatedById` (`CreatedById`),
  KEY `IX_Messages_GroupId` (`GroupId`),
  KEY `IX_Messages_UserId` (`UserId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `myths`
--

DROP TABLE IF EXISTS `myths`;
CREATE TABLE IF NOT EXISTS `myths` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CategoryId` int DEFAULT NULL,
  `ImagePath` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ReadingMinutes` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `MinimumAge` int NOT NULL DEFAULT '0',
  `LanguageId` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_Myths_CategoryId` (`CategoryId`),
  KEY `IX_Myths_CreatedById` (`CreatedById`),
  KEY `IX_Myths_LanguageId` (`LanguageId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `news`
--

DROP TABLE IF EXISTS `news`;
CREATE TABLE IF NOT EXISTS `news` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CategoryId` int NOT NULL,
  `ImagePath` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ReadingMinutes` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `MinimumAge` int NOT NULL DEFAULT '0',
  `LanguageId` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_News_CategoryId` (`CategoryId`),
  KEY `IX_News_CreatedById` (`CreatedById`),
  KEY `IX_News_LanguageId` (`LanguageId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
CREATE TABLE IF NOT EXISTS `payments` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `OrderId` int NOT NULL,
  `TransactionId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `Amount` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_Payments_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `providerdays`
--

DROP TABLE IF EXISTS `providerdays`;
CREATE TABLE IF NOT EXISTS `providerdays` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ServiceProviderId` int NOT NULL,
  `Date` date NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ProviderDays_CreatedById` (`CreatedById`),
  KEY `IX_ProviderDays_ServiceProviderId` (`ServiceProviderId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `providerdayslots`
--

DROP TABLE IF EXISTS `providerdayslots`;
CREATE TABLE IF NOT EXISTS `providerdayslots` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ProviderDayId` int NOT NULL,
  `TimeSlot` datetime(6) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ProviderDaySlots_CreatedById` (`CreatedById`),
  KEY `IX_ProviderDaySlots_ProviderDayId` (`ProviderDayId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `questiontags`
--

DROP TABLE IF EXISTS `questiontags`;
CREATE TABLE IF NOT EXISTS `questiontags` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Question` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CategoryId` int NOT NULL,
  `Explanation` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Answer` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `MinimumAge` int NOT NULL DEFAULT '0',
  `LanguageId` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_QuestionTags_CategoryId` (`CategoryId`),
  KEY `IX_QuestionTags_CreatedById` (`CreatedById`),
  KEY `IX_QuestionTags_LanguageId` (`LanguageId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `regions`
--

DROP TABLE IF EXISTS `regions`;
CREATE TABLE IF NOT EXISTS `regions` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Regions_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `roleclaims`
--

DROP TABLE IF EXISTS `roleclaims`;
CREATE TABLE IF NOT EXISTS `roleclaims` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `RoleId` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ClaimType` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `ClaimValue` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`Id`),
  KEY `IX_RoleClaims_RoleId` (`RoleId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

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

DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
  `Id` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `NormalizedName` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ConcurrencyStamp` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `RoleNameIndex` (`NormalizedName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `serviceproviders`
--

DROP TABLE IF EXISTS `serviceproviders`;
CREATE TABLE IF NOT EXISTS `serviceproviders` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `UserId` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `MentalHealthInstitutionId` int DEFAULT NULL,
  `YearsOfExpirience` int NOT NULL,
  `Profession` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `BookingStatus` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  UNIQUE KEY `IX_ServiceProviders_UserId` (`UserId`),
  KEY `IX_ServiceProviders_CreatedById` (`CreatedById`),
  KEY `IX_ServiceProviders_MentalHealthInstitutionId` (`MentalHealthInstitutionId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `sessionprices`
--

DROP TABLE IF EXISTS `sessionprices`;
CREATE TABLE IF NOT EXISTS `sessionprices` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Institution` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `InitialPrice` double NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  `DeletedDate` datetime(6) DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `UpdatedDate` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  `FollowUpPrice` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_SessionPrices_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE IF NOT EXISTS `sessions` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ClientId` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ProviderDaySlotId` int NOT NULL,
  `CallType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Description` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `PaymentId` int DEFAULT NULL,
  `AreaOfExpertiseId` int NOT NULL DEFAULT '0',
  `IsFollowUp` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  UNIQUE KEY `IX_Sessions_PaymentId` (`PaymentId`),
  KEY `IX_Sessions_ClientId` (`ClientId`),
  KEY `IX_Sessions_CreatedById` (`CreatedById`),
  KEY `IX_Sessions_ProviderDaySlotId` (`ProviderDaySlotId`),
  KEY `IX_Sessions_AreaOfExpertiseId` (`AreaOfExpertiseId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `userclaims`
--

DROP TABLE IF EXISTS `userclaims`;
CREATE TABLE IF NOT EXISTS `userclaims` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `UserId` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ClaimType` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `ClaimValue` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`Id`),
  KEY `IX_UserClaims_UserId` (`UserId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `userlogins`
--

DROP TABLE IF EXISTS `userlogins`;
CREATE TABLE IF NOT EXISTS `userlogins` (
  `LoginProvider` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ProviderKey` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ProviderDisplayName` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `UserId` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`LoginProvider`,`ProviderKey`),
  KEY `IX_UserLogins_UserId` (`UserId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `userroles`
--

DROP TABLE IF EXISTS `userroles`;
CREATE TABLE IF NOT EXISTS `userroles` (
  `UserId` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `RoleId` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`UserId`,`RoleId`),
  KEY `IX_UserRoles_RoleId` (`RoleId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `Id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `FirstName` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LastName` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Gender` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Pin` int NOT NULL,
  `Address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `UpdatedDate` datetime(6) DEFAULT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `UserName` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `NormalizedUserName` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Email` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `NormalizedEmail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `EmailConfirmed` tinyint(1) NOT NULL,
  `PasswordHash` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `SecurityStamp` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ConcurrencyStamp` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `PhoneNumber` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `PhoneNumberConfirmed` tinyint(1) NOT NULL,
  `TwoFactorEnabled` tinyint(1) NOT NULL,
  `LockoutEnd` datetime(6) DEFAULT NULL,
  `LockoutEnabled` tinyint(1) NOT NULL,
  `AccessFailedCount` int NOT NULL,
  `DateOfBirth` date NOT NULL DEFAULT '0001-01-01',
  `ParentEmail` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `LastLogin` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  `ChatName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `DistrictId` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  UNIQUE KEY `UserNameIndex` (`NormalizedUserName`),
  KEY `EmailIndex` (`NormalizedEmail`),
  KEY `IX_Users_DistrictId` (`DistrictId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `usertokens`
--

DROP TABLE IF EXISTS `usertokens`;
CREATE TABLE IF NOT EXISTS `usertokens` (
  `UserId` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `LoginProvider` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Name` varchar(85) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Value` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  PRIMARY KEY (`UserId`,`LoginProvider`,`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `videos`
--

DROP TABLE IF EXISTS `videos`;
CREATE TABLE IF NOT EXISTS `videos` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `YoutubeVideoId` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `Description` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `CategoryId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Videos_CategoryId` (`CategoryId`),
  KEY `IX_Videos_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `zooms`
--

DROP TABLE IF EXISTS `zooms`;
CREATE TABLE IF NOT EXISTS `zooms` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Topic` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `JoinUrl` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `MeetingID` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `Password` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `StartUrl` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `Agenda` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `StartTime` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `Duration` int NOT NULL,
  `Time` int NOT NULL,
  `Date` datetime(6) NOT NULL,
  `TimeZone` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `ServiceProviderId` int NOT NULL,
  `UserId` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `SessionId` int DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `Status` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Zooms_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `__efmigrationshistory`
--

DROP TABLE IF EXISTS `__efmigrationshistory`;
CREATE TABLE IF NOT EXISTS `__efmigrationshistory` (
  `MigrationId` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `ProductVersion` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`MigrationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `__efmigrationshistory`
--

INSERT IGNORE INTO `__efmigrationshistory` (`MigrationId`, `ProductVersion`) VALUES
('20220318081829_Initial', '6.0.3'),
('20220407080153_Region', '6.0.3'),
('20220411123407_ProviderDayDateFormat', '6.0.3'),
('20220517143219_AddDateOfBirth', '6.0.3'),
('20220522214806_NullableMythCategory', '6.0.3'),
('20220528081123_Payment', '6.0.3'),
('20220530061306_SessionPayment', '6.0.3'),
('20220530124454_AddSessionPrice', '6.0.3'),
('20220530135918_UpdateSessionPrice', '6.0.3'),
('20220531094220_AddAmountToPayment', '6.0.3'),
('20220622071046_Added_booking_status_to_service_provider', '6.0.3'),
('20220627100000_added_last_login_to_user', '6.0.3'),
('20220707080621_add_chat_name_to_user', '6.0.3'),
('20220715121702_added-reason-to-group-request-status', '6.0.3'),
('20220722132302_added_meta_fields_to_language', '6.0.3'),
('20220913090301_added_area_of_expertise_model', '6.0.3'),
('20220913091504_added_meta_data_to_area_of_expertise', '6.0.3'),
('20220913120403_added_many_to_many_between_areas_of_expertise_and_service_provider', '6.0.3'),
('20220914082230_added_language_reference_to_area_of_expertise', '6.0.3'),
('20220919133050_updated_price_columns_to_session_price_table', '6.0.3'),
('20220919135210_updated_session_table_added_area_of_expertise_reference_and_follow_up_boolean', '6.0.3'),
('20220919144920_empty', '6.0.3'),
('20221107070528_added location&AcceptedAreaOfExpertiseModels', '6.0.3'),
('20221122175129_added_district_model', '6.0.3'),
('20221123122602_removed_profession_field_requirement_contranstraint', '6.0.3');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
"