convert all 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 07:12 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: `mlsdmgm2`
--
CREATE DATABASE IF NOT EXISTS `mlsdmgm2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `mlsdmgm2`;

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

--
-- Table structure for table `attachmentcpdtraining`
--

DROP TABLE IF EXISTS `attachmentcpdtraining`;
CREATE TABLE IF NOT EXISTS `attachmentcpdtraining` (
  `AttachmentsId` int NOT NULL,
  `CPDTrainingsId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`CPDTrainingsId`),
  KEY `IX_AttachmentCPDTraining_CPDTrainingsId` (`CPDTrainingsId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachmentcpdtrainingregistration`
--

DROP TABLE IF EXISTS `attachmentcpdtrainingregistration`;
CREATE TABLE IF NOT EXISTS `attachmentcpdtrainingregistration` (
  `AttachmentsId` int NOT NULL,
  `CPDTrainingRegistrationsId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`CPDTrainingRegistrationsId`),
  KEY `IX_AttachmentCPDTrainingRegistration_CPDTrainingRegistrationsId` (`CPDTrainingRegistrationsId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachmentlicenseapplication`
--

DROP TABLE IF EXISTS `attachmentlicenseapplication`;
CREATE TABLE IF NOT EXISTS `attachmentlicenseapplication` (
  `AttachmentsId` int NOT NULL,
  `LicenseApplicationsId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`LicenseApplicationsId`),
  KEY `IX_AttachmentLicenseApplication_LicenseApplicationsId` (`LicenseApplicationsId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachmentmemberqualification`
--

DROP TABLE IF EXISTS `attachmentmemberqualification`;
CREATE TABLE IF NOT EXISTS `attachmentmemberqualification` (
  `AttachmentsId` int NOT NULL,
  `MemberQualificationsId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`MemberQualificationsId`),
  KEY `IX_AttachmentMemberQualification_MemberQualificationsId` (`MemberQualificationsId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachmentmessage`
--

DROP TABLE IF EXISTS `attachmentmessage`;
CREATE TABLE IF NOT EXISTS `attachmentmessage` (
  `AttachmentsId` int NOT NULL,
  `MessagesId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`MessagesId`),
  KEY `IX_AttachmentMessage_MessagesId` (`MessagesId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `attachmentpenalty`
--

DROP TABLE IF EXISTS `attachmentpenalty`;
CREATE TABLE IF NOT EXISTS `attachmentpenalty` (
  `AttachmentsId` int NOT NULL,
  `PenaltiesId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`PenaltiesId`),
  KEY `IX_AttachmentPenalty_PenaltiesId` (`PenaltiesId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachmentpenaltypayment`
--

DROP TABLE IF EXISTS `attachmentpenaltypayment`;
CREATE TABLE IF NOT EXISTS `attachmentpenaltypayment` (
  `AttachmentsId` int NOT NULL,
  `PenaltyPaymentsId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`PenaltyPaymentsId`),
  KEY `IX_AttachmentPenaltyPayment_PenaltyPaymentsId` (`PenaltyPaymentsId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachmentprobono`
--

DROP TABLE IF EXISTS `attachmentprobono`;
CREATE TABLE IF NOT EXISTS `attachmentprobono` (
  `AttachmentsId` int NOT NULL,
  `ProBonosId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`ProBonosId`),
  KEY `IX_AttachmentProBono_ProBonosId` (`ProBonosId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachmentprobonoapplication`
--

DROP TABLE IF EXISTS `attachmentprobonoapplication`;
CREATE TABLE IF NOT EXISTS `attachmentprobonoapplication` (
  `AttachmentsId` int NOT NULL,
  `ProBonosApplicationsId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`ProBonosApplicationsId`),
  KEY `IX_AttachmentProBonoApplication_ProBonosApplicationsId` (`ProBonosApplicationsId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachmentprobonoreport`
--

DROP TABLE IF EXISTS `attachmentprobonoreport`;
CREATE TABLE IF NOT EXISTS `attachmentprobonoreport` (
  `AttachmentsId` int NOT NULL,
  `ProBonoReportsId` int NOT NULL,
  PRIMARY KEY (`AttachmentsId`,`ProBonoReportsId`),
  KEY `IX_AttachmentProBonoReport_ProBonoReportsId` (`ProBonoReportsId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachments`
--

DROP TABLE IF EXISTS `attachments`;
CREATE TABLE IF NOT EXISTS `attachments` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `FileName` varchar(200) NOT NULL,
  `FilePath` varchar(250) NOT NULL,
  `AttachmentTypeId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `PropertyName` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Attachments_AttachmentTypeId` (`AttachmentTypeId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `attachmenttypes`
--

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

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

--
-- Table structure for table `committeemembers`
--

DROP TABLE IF EXISTS `committeemembers`;
CREATE TABLE IF NOT EXISTS `committeemembers` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `CommitteeID` int NOT NULL,
  `MemberID` int NOT NULL,
  `JoinedDate` datetime(6) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_CommitteeMembers_CommitteeID` (`CommitteeID`),
  KEY `IX_CommitteeMembers_MemberID` (`MemberID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `committees`
--

DROP TABLE IF EXISTS `committees`;
CREATE TABLE IF NOT EXISTS `committees` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `CommitteeName` longtext NOT NULL,
  `Description` longtext NOT NULL,
  `CreationDate` datetime(6) NOT NULL,
  `ChairpersonID` int DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `CreatedById` varchar(200) NOT NULL DEFAULT '',
  `YearOfOperationId` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_Committees_ChairpersonID` (`ChairpersonID`),
  KEY `IX_Committees_CreatedById` (`CreatedById`),
  KEY `IX_Committees_YearOfOperationId` (`YearOfOperationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `countries`
--

DROP TABLE IF EXISTS `countries`;
CREATE TABLE IF NOT EXISTS `countries` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `ShortCode` varchar(10) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `cpdtrainingregistrations`
--

DROP TABLE IF EXISTS `cpdtrainingregistrations`;
CREATE TABLE IF NOT EXISTS `cpdtrainingregistrations` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `MemberId` int NOT NULL,
  `RegistrationStatus` varchar(100) NOT NULL,
  `CPDTrainingId` int NOT NULL,
  `CreatedById` varchar(200) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `DeniedReason` varchar(250) DEFAULT NULL,
  `DateOfPayment` datetime(6) DEFAULT NULL,
  `Fee` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_CPDTrainingRegistrations_CPDTrainingId` (`CPDTrainingId`),
  KEY `IX_CPDTrainingRegistrations_CreatedById` (`CreatedById`),
  KEY `IX_CPDTrainingRegistrations_MemberId` (`MemberId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `cpdtrainings`
--

DROP TABLE IF EXISTS `cpdtrainings`;
CREATE TABLE IF NOT EXISTS `cpdtrainings` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Title` varchar(100) NOT NULL,
  `Description` varchar(250) NOT NULL,
  `Duration` double NOT NULL,
  `DateToBeConducted` datetime(6) NOT NULL,
  `ProposedUnits` int NOT NULL,
  `CPDUnitsAwarded` int NOT NULL,
  `AccreditingInstitution` varchar(200) NOT NULL,
  `CreatedById` varchar(200) NOT NULL,
  `YearOfOperationId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `ApprovalStatus` longtext NOT NULL,
  `NonMemberVirtualAttandanceFee` double DEFAULT NULL,
  `IsFree` tinyint(1) NOT NULL DEFAULT '0',
  `MemberVirtualAttendanceFee` double DEFAULT NULL,
  `NonMemberPhysicalAttendanceFee` double DEFAULT NULL,
  `PhysicalVenue` varchar(250) DEFAULT NULL,
  `RegistrationDueDate` datetime(6) DEFAULT NULL,
  `MemberPhysicalAttendanceFee` double DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_CPDTrainings_CreatedById` (`CreatedById`),
  KEY `IX_CPDTrainings_YearOfOperationId` (`YearOfOperationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `cpdunitsearned`
--

DROP TABLE IF EXISTS `cpdunitsearned`;
CREATE TABLE IF NOT EXISTS `cpdunitsearned` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `MemberId` int NOT NULL,
  `CPDTrainingId` int NOT NULL,
  `UnitsEarned` int NOT NULL,
  `YearOfOperationId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_CPDUnitsEarned_CPDTrainingId` (`CPDTrainingId`),
  KEY `IX_CPDUnitsEarned_YearOfOperationId` (`YearOfOperationId`),
  KEY `IX_CPDUnitsEarned_MemberId` (`MemberId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `departments`
--

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

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

--
-- Table structure for table `errorlogs`
--

DROP TABLE IF EXISTS `errorlogs`;
CREATE TABLE IF NOT EXISTS `errorlogs` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `UserFriendlyMessage` longtext NOT NULL,
  `DetailedMessage` longtext NOT NULL,
  `DateOccurred` datetime(6) NOT NULL,
  `CreatedById` varchar(200) DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ErrorLogs_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `firms`
--

DROP TABLE IF EXISTS `firms`;
CREATE TABLE IF NOT EXISTS `firms` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `PostalAddress` varchar(250) NOT NULL,
  `PhysicalAddress` varchar(250) NOT NULL,
  `PrimaryContactPerson` varchar(100) NOT NULL,
  `PrimaryPhoneNumber` varchar(15) NOT NULL,
  `SecondaryContactPerson` varchar(100) NOT NULL,
  `SecondaryPhoneNumber` varchar(15) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `CreatedById` varchar(200) DEFAULT NULL,
  `DenialReason` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Firms_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `identitytypes`
--

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

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

--
-- Table structure for table `licenseapplicationapprovals`
--

DROP TABLE IF EXISTS `licenseapplicationapprovals`;
CREATE TABLE IF NOT EXISTS `licenseapplicationapprovals` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `LicenseApplicationID` int NOT NULL,
  `LicenseApprovalLevelID` int NOT NULL,
  `Approved` tinyint(1) NOT NULL,
  `Reason_for_Rejection` varchar(250) NOT NULL,
  `CreatedById` varchar(200) DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_LicenseApplicationApprovals_CreatedById` (`CreatedById`),
  KEY `IX_LicenseApplicationApprovals_LicenseApplicationID` (`LicenseApplicationID`),
  KEY `IX_LicenseApplicationApprovals_LicenseApprovalLevelID` (`LicenseApprovalLevelID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `licenseapplications`
--

DROP TABLE IF EXISTS `licenseapplications`;
CREATE TABLE IF NOT EXISTS `licenseapplications` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `YearOfOperationId` int NOT NULL,
  `ApplicationStatus` longtext NOT NULL,
  `CurrentApprovalLevelID` int NOT NULL,
  `MemberId` int NOT NULL,
  `FirstApplicationForLicense` tinyint(1) NOT NULL,
  `RenewedLicensePreviousYear` tinyint(1) NOT NULL,
  `ObtainedLeaveToRenewLicenseOutOfTime` tinyint(1) NOT NULL,
  `PaidAnnualSubscriptionToSociety` tinyint(1) NOT NULL,
  `MadeContributionToFidelityFund` tinyint(1) NOT NULL,
  `ExplanationForNoContributionToFidelityFund` varchar(250) DEFAULT NULL,
  `RemittedSocietysLevy` tinyint(1) NOT NULL,
  `ExplanationForNoSocietysLevy` varchar(250) DEFAULT NULL,
  `MadeContributionToMLSBuildingProjectFund` tinyint(1) NOT NULL,
  `ExplanationForNoContributionToMLSBuildingProjectFund` varchar(250) DEFAULT NULL,
  `PerformedFullMandatoryProBonoWork` tinyint(1) NOT NULL,
  `ExplanationForNoFullMandatoryProBonoWork` varchar(250) DEFAULT NULL,
  `AttainedMinimumNumberOfCLEUnits` tinyint(1) NOT NULL,
  `ExplanationForNoMinimumNumberOfCLEUnits` varchar(250) DEFAULT NULL,
  `HasValidAnnualProfessionalIndemnityInsuranceCover` tinyint(1) NOT NULL,
  `ExplanationForNoProfessionalIndemnityInsuranceCover` varchar(250) DEFAULT NULL,
  `SubmittedValidTaxClearanceCertificate` tinyint(1) NOT NULL,
  `ExplanationForNoValidTaxClearanceCertificate` varchar(250) DEFAULT NULL,
  `SubmittedAccountantsCertificate` tinyint(1) NOT NULL,
  `ExplanationForNoAccountantsCertificate` varchar(250) DEFAULT NULL,
  `CompliedWithPenaltiesImposedUnderTheAct` tinyint(1) NOT NULL,
  `ExplanationForNoComplianceWithPenalties` varchar(250) DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `CreatedById` varchar(200) NOT NULL DEFAULT '',
  `ExplanationForNoAnnualSubscriptionToSociety` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_LicenseApplications_CurrentApprovalLevelID` (`CurrentApprovalLevelID`),
  KEY `IX_LicenseApplications_MemberId` (`MemberId`),
  KEY `IX_LicenseApplications_YearOfOperationId` (`YearOfOperationId`),
  KEY `IX_LicenseApplications_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `licenseapprovalcomments`
--

DROP TABLE IF EXISTS `licenseapprovalcomments`;
CREATE TABLE IF NOT EXISTS `licenseapprovalcomments` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ApprovalHistoryId` int NOT NULL,
  `Comment` varchar(1000) NOT NULL,
  `CommentedById` varchar(200) NOT NULL,
  `CommentDate` datetime(6) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_LicenseApprovalComments_ApprovalHistoryId` (`ApprovalHistoryId`),
  KEY `IX_LicenseApprovalComments_CommentedById` (`CommentedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `licenseapprovalhistories`
--

DROP TABLE IF EXISTS `licenseapprovalhistories`;
CREATE TABLE IF NOT EXISTS `licenseapprovalhistories` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `LicenseApplicationId` int NOT NULL,
  `ChangeDate` datetime(6) NOT NULL,
  `ApprovalLevelId` int NOT NULL,
  `Status` longtext NOT NULL,
  `ChangedById` varchar(200) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  `DeletedDate` datetime(6) DEFAULT NULL,
  `UpdatedDate` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  PRIMARY KEY (`Id`),
  KEY `IX_LicenseApprovalHistories_ApprovalLevelId` (`ApprovalLevelId`),
  KEY `IX_LicenseApprovalHistories_ChangedById` (`ChangedById`),
  KEY `IX_LicenseApprovalHistories_LicenseApplicationId` (`LicenseApplicationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `licenseapprovallevels`
--

DROP TABLE IF EXISTS `licenseapprovallevels`;
CREATE TABLE IF NOT EXISTS `licenseapprovallevels` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Level` int NOT NULL,
  `DepartmentId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_LicenseApprovalLevels_DepartmentId` (`DepartmentId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `licenses`
--

DROP TABLE IF EXISTS `licenses`;
CREATE TABLE IF NOT EXISTS `licenses` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `LicenseNumber` longtext NOT NULL,
  `MemberId` int NOT NULL,
  `ExpiryDate` datetime(6) NOT NULL,
  `YearOfOperationId` int NOT NULL,
  `LicenseApplicationId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `IX_Licenses_LicenseApplicationId` (`LicenseApplicationId`),
  KEY `IX_Licenses_MemberId` (`MemberId`),
  KEY `IX_Licenses_YearOfOperationId` (`YearOfOperationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `memberprobono`
--

DROP TABLE IF EXISTS `memberprobono`;
CREATE TABLE IF NOT EXISTS `memberprobono` (
  `MembersId` int NOT NULL,
  `ProBonosId` int NOT NULL,
  PRIMARY KEY (`MembersId`,`ProBonosId`),
  KEY `IX_MemberProBono_ProBonosId` (`ProBonosId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `memberqualifications`
--

DROP TABLE IF EXISTS `memberqualifications`;
CREATE TABLE IF NOT EXISTS `memberqualifications` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` longtext NOT NULL,
  `MemberId` int NOT NULL,
  `IssuingInstitution` varchar(250) NOT NULL,
  `DateObtained` datetime(6) NOT NULL,
  `QualificationTypeId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_MemberQualifications_MemberId` (`MemberId`),
  KEY `IX_MemberQualifications_QualificationTypeId` (`QualificationTypeId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `memberqualificationtype`
--

DROP TABLE IF EXISTS `memberqualificationtype`;
CREATE TABLE IF NOT EXISTS `memberqualificationtype` (
  `MembersId` int NOT NULL,
  `QualificationTypesId` int NOT NULL,
  PRIMARY KEY (`MembersId`,`QualificationTypesId`),
  KEY `IX_MemberQualificationType_QualificationTypesId` (`QualificationTypesId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `members`
--

DROP TABLE IF EXISTS `members`;
CREATE TABLE IF NOT EXISTS `members` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `UserId` varchar(200) NOT NULL,
  `PostalAddress` varchar(250) NOT NULL,
  `PermanentAddress` varchar(250) NOT NULL,
  `ResidentialAddress` varchar(250) NOT NULL,
  `DateOfAdmissionToPractice` datetime(6) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `FirmId` int DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Members_UserId` (`UserId`),
  KEY `IX_Members_FirmId` (`FirmId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `CommitteeID` int NOT NULL,
  `SenderID` int NOT NULL,
  `Timestamp` datetime(6) NOT NULL,
  `Content` longtext NOT NULL,
  `ThreadID` int DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_Messages_CommitteeID` (`CommitteeID`),
  KEY `IX_Messages_SenderID` (`SenderID`),
  KEY `IX_Messages_ThreadID` (`ThreadID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `penalties`
--

DROP TABLE IF EXISTS `penalties`;
CREATE TABLE IF NOT EXISTS `penalties` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `MemberId` int NOT NULL,
  `PenaltyTypeId` int NOT NULL,
  `Reason` longtext NOT NULL,
  `CreatedById` varchar(200) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `Fee` double NOT NULL DEFAULT '0',
  `PenaltyStatus` varchar(100) NOT NULL DEFAULT '',
  `ResolutionComment` varchar(250) DEFAULT NULL,
  `YearOfOperationId` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_Penalties_CreatedById` (`CreatedById`),
  KEY `IX_Penalties_MemberId` (`MemberId`),
  KEY `IX_Penalties_YearOfOperationId` (`YearOfOperationId`),
  KEY `IX_Penalties_PenaltyTypeId` (`PenaltyTypeId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `penaltypayments`
--

DROP TABLE IF EXISTS `penaltypayments`;
CREATE TABLE IF NOT EXISTS `penaltypayments` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `PenaltyId` int NOT NULL,
  `PaymentStatus` longtext NOT NULL,
  `Description` longtext,
  `Fee` double NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_PenaltyPayments_PenaltyId` (`PenaltyId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `penaltytypes`
--

DROP TABLE IF EXISTS `penaltytypes`;
CREATE TABLE IF NOT EXISTS `penaltytypes` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) NOT NULL,
  `Description` varchar(250) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `probonoapplications`
--

DROP TABLE IF EXISTS `probonoapplications`;
CREATE TABLE IF NOT EXISTS `probonoapplications` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `NatureOfDispute` varchar(200) NOT NULL,
  `CaseDetails` longtext NOT NULL,
  `CreatedById` varchar(200) DEFAULT NULL,
  `ProbonoClientId` int NOT NULL,
  `ApplicationStatus` longtext NOT NULL,
  `ApprovedDate` datetime(6) DEFAULT NULL,
  `DenialReason` varchar(200) DEFAULT NULL,
  `SummaryOfDispute` longtext NOT NULL,
  `YearOfOperationId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ProBonoApplications_CreatedById` (`CreatedById`),
  KEY `IX_ProBonoApplications_ProbonoClientId` (`ProbonoClientId`),
  KEY `IX_ProBonoApplications_YearOfOperationId` (`YearOfOperationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `probonoclients`
--

DROP TABLE IF EXISTS `probonoclients`;
CREATE TABLE IF NOT EXISTS `probonoclients` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) NOT NULL,
  `NationalId` varchar(200) NOT NULL,
  `PostalAddress` varchar(250) NOT NULL,
  `PermanentAddress` varchar(250) NOT NULL,
  `ResidentialAddress` varchar(250) NOT NULL,
  `PhoneNumber` varchar(20) NOT NULL,
  `OtherContacts` varchar(150) NOT NULL,
  `ApprovedDate` datetime(6) NOT NULL,
  `Occupation` varchar(150) NOT NULL,
  `AnnualIncome` decimal(18,2) NOT NULL,
  `CreatedById` varchar(200) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ProbonoClients_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `probonoreports`
--

DROP TABLE IF EXISTS `probonoreports`;
CREATE TABLE IF NOT EXISTS `probonoreports` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ProBonoId` int NOT NULL,
  `ProBonoProposedHours` double NOT NULL,
  `ProBonoHours` double NOT NULL,
  `ReportStatus` longtext NOT NULL,
  `ApprovedById` varchar(200) DEFAULT NULL,
  `CreatedById` varchar(200) NOT NULL,
  `Description` varchar(250) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ProBonoReports_ApprovedById` (`ApprovedById`),
  KEY `IX_ProBonoReports_CreatedById` (`CreatedById`),
  KEY `IX_ProBonoReports_ProBonoId` (`ProBonoId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `probonos`
--

DROP TABLE IF EXISTS `probonos`;
CREATE TABLE IF NOT EXISTS `probonos` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `FileNumber` varchar(100) NOT NULL,
  `NatureOfDispute` varchar(200) NOT NULL,
  `CaseDetails` longtext NOT NULL,
  `CreatedById` varchar(200) DEFAULT NULL,
  `ProbonoClientId` int NOT NULL,
  `ProBonoApplicationId` int NOT NULL,
  `SummaryOfDispute` longtext NOT NULL,
  `YearOfOperationId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_ProBonos_CreatedById` (`CreatedById`),
  KEY `IX_ProBonos_ProBonoApplicationId` (`ProBonoApplicationId`),
  KEY `IX_ProBonos_ProbonoClientId` (`ProbonoClientId`),
  KEY `IX_ProBonos_YearOfOperationId` (`YearOfOperationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `propbonoreportfeedbacks`
--

DROP TABLE IF EXISTS `propbonoreportfeedbacks`;
CREATE TABLE IF NOT EXISTS `propbonoreportfeedbacks` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ProBonoReportId` int NOT NULL,
  `Feedback` varchar(250) NOT NULL,
  `FeedBackById` varchar(200) DEFAULT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_PropBonoReportFeedbacks_FeedBackById` (`FeedBackById`),
  KEY `IX_PropBonoReportFeedbacks_ProBonoReportId` (`ProBonoReportId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `qualificationtypes`
--

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

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

--
-- 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) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_RoleClaims_RoleId` (`RoleId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
  `Id` varchar(85) NOT NULL,
  `Discriminator` varchar(13) NOT NULL,
  `CreatedDate` datetime(6) DEFAULT NULL,
  `CreatedById` longtext,
  `Status` longtext,
  `UpdatedDate` datetime(6) DEFAULT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `Name` varchar(256) DEFAULT NULL,
  `NormalizedName` varchar(85) DEFAULT NULL,
  `ConcurrencyStamp` longtext,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `RoleNameIndex` (`NormalizedName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `threads`
--

DROP TABLE IF EXISTS `threads`;
CREATE TABLE IF NOT EXISTS `threads` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `CommitteeId` int NOT NULL,
  `Subject` longtext NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `CreatedById` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`Id`),
  KEY `IX_Threads_CommitteeId` (`CommitteeId`),
  KEY `IX_Threads_CreatedById` (`CreatedById`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `titles`
--

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

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

--
-- 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) NOT NULL,
  `ClaimType` longtext,
  `ClaimValue` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_UserClaims_UserId` (`UserId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

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

DROP TABLE IF EXISTS `userroles`;
CREATE TABLE IF NOT EXISTS `userroles` (
  `UserId` varchar(85) NOT NULL,
  `RoleId` varchar(85) NOT NULL,
  PRIMARY KEY (`UserId`,`RoleId`),
  KEY `IX_UserRoles_RoleId` (`RoleId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `Id` varchar(200) NOT NULL,
  `FirstName` varchar(100) NOT NULL,
  `LastName` varchar(100) NOT NULL,
  `OtherName` varchar(100) DEFAULT NULL,
  `Gender` varchar(15) NOT NULL,
  `PhoneNumber` varchar(15) NOT NULL,
  `IdentityNumber` varchar(50) NOT NULL,
  `IdentityExpiryDate` datetime(6) NOT NULL,
  `DateOfBirth` datetime(6) NOT NULL,
  `DepartmentId` int NOT NULL,
  `IdentityTypeId` int NOT NULL,
  `TitleId` int NOT NULL,
  `CountryId` int NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `CreatedById` longtext,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  `LastLogin` datetime(6) NOT NULL,
  `Pin` int DEFAULT NULL,
  `FirmId` int DEFAULT NULL,
  `UserName` varchar(256) DEFAULT NULL,
  `NormalizedUserName` varchar(200) DEFAULT NULL,
  `Email` varchar(256) DEFAULT NULL,
  `NormalizedEmail` varchar(200) DEFAULT NULL,
  `EmailConfirmed` tinyint(1) NOT NULL,
  `PasswordHash` longtext,
  `SecurityStamp` longtext,
  `ConcurrencyStamp` varchar(200) DEFAULT NULL,
  `PhoneNumberConfirmed` tinyint(1) NOT NULL,
  `TwoFactorEnabled` tinyint(1) NOT NULL,
  `LockoutEnd` datetime DEFAULT NULL,
  `LockoutEnabled` tinyint(1) NOT NULL,
  `AccessFailedCount` int NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `UserNameIndex` (`NormalizedUserName`),
  KEY `EmailIndex` (`NormalizedEmail`),
  KEY `IX_Users_CountryId` (`CountryId`),
  KEY `IX_Users_DepartmentId` (`DepartmentId`),
  KEY `IX_Users_FirmId` (`FirmId`),
  KEY `IX_Users_IdentityTypeId` (`IdentityTypeId`),
  KEY `IX_Users_TitleId` (`TitleId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

DROP TABLE IF EXISTS `usertokens`;
CREATE TABLE IF NOT EXISTS `usertokens` (
  `UserId` varchar(85) NOT NULL,
  `LoginProvider` varchar(85) NOT NULL,
  `Name` varchar(85) NOT NULL,
  `Value` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`UserId`,`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `yearofoperations`
--

DROP TABLE IF EXISTS `yearofoperations`;
CREATE TABLE IF NOT EXISTS `yearofoperations` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `StartDate` datetime(6) NOT NULL,
  `EndDate` datetime(6) NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `Status` longtext NOT NULL,
  `UpdatedDate` datetime(6) NOT NULL,
  `DeletedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

DROP TABLE IF EXISTS `__efmigrationshistory`;
CREATE TABLE IF NOT EXISTS `__efmigrationshistory` (
  `MigrationId` varchar(150) NOT NULL,
  `ProductVersion` varchar(32) NOT NULL,
  PRIMARY KEY (`MigrationId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
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 */;
"