/*
SQLyog Ultimate v13.1.8 (64 bit)
MySQL - 8.0.34 : Database - levisrmserver_erpdev2_backup
*********************************************************************
*/



CREATE DATABASE /*!32312 IF NOT EXISTS*/`levisrmserver_erpdev2_backup` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `levisrmserver_erpdev2_backup`;

/*Table structure for table `azure` */


CREATE TABLE `azure` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `container` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `originalFileName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `createdBy` int DEFAULT NULL COMMENT 'the user''s public_user_id',
  `mappedModuleID` int DEFAULT NULL COMMENT 'connected module',
  `mappedRecordID` int DEFAULT NULL COMMENT 'and its record',
  `dateModified` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `permissions` int DEFAULT NULL,
  `asset` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fileSize` int DEFAULT NULL COMMENT 'size of file (bytes?)',
  `fileType` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `azure_settings` */


CREATE TABLE `azure_settings` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `accountName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accountKey` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `azureDomain` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `clientId` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `clientSecret` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `subscriptionId` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `resourceGroup` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `applicationID` int DEFAULT NULL COMMENT 'matching applicationID in domains table',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `blog` */


CREATE TABLE `blog` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `description` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `copy` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `postDate` date DEFAULT NULL,
  `postTime` time DEFAULT NULL,
  `youtubeVid` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `blogLink` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `authorID` int DEFAULT NULL,
  `imageGalleryID` int DEFAULT NULL,
  `galleryImageID` int DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT '0',
  `domainID` int DEFAULT '1',
  `groupID` int DEFAULT '0',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`),
  KEY `blogName` (`name`),
  FULLTEXT KEY `blog_name_IDX` (`name`,`copy`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `blog_recommended_map` */


CREATE TABLE `blog_recommended_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `blogID` int NOT NULL,
  `recommendedBlogID` int NOT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `brands` */


CREATE TABLE `brands` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '0',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `categories` */


CREATE TABLE `categories` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `description` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `copy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `moduleID` int DEFAULT NULL COMMENT 'The priKeyID of the listig module we are assigning the category to it',
  `companyID` int DEFAULT '0',
  `showInSidebar` tinyint DEFAULT '0',
  `rootCategory` tinyint DEFAULT '0',
  `domainID` int DEFAULT '1',
  `groupID` int DEFAULT '0',
  `colorCode` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `category_module_record_map` */


CREATE TABLE `category_module_record_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `catID` int DEFAULT NULL,
  `moduleID` int DEFAULT NULL COMMENT 'The priKeyID of the listig module we are assigning the category to it',
  `recordID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `category_module_record_map_recordID_IDX` (`recordID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `certificate_category_module_record_map` */


CREATE TABLE `certificate_category_module_record_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `catID` int DEFAULT NULL,
  `certCatID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `certificate_company_map` */


CREATE TABLE `certificate_company_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `mappedCompanyID` int DEFAULT NULL,
  `certificateID` int DEFAULT NULL,
  `issueDate` date DEFAULT NULL,
  `expiryDate` date DEFAULT NULL,
  `fileName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fileLibraryID` int DEFAULT NULL,
  `note` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `certificates` */


CREATE TABLE `certificates` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `courseLengthUnit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Year',
  `notificationLengthUnit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Week',
  `courseLength` int DEFAULT '1',
  `notificationLength` int DEFAULT '1',
  `moduleID` int DEFAULT NULL,
  `companyID` int DEFAULT '0',
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `check_in_check_out_log` */


CREATE TABLE `check_in_check_out_log` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT '0',
  `companyID` int DEFAULT '0',
  `jobSiteID` int DEFAULT '0',
  `publicUserID` int DEFAULT '0',
  `serialNumber` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `dateTimeStamp` timestamp NULL DEFAULT NULL,
  `action` tinyint(1) DEFAULT '0',
  `quantity` int DEFAULT '0',
  `uom` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'each',
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `source` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `expirationDate` date DEFAULT NULL,
  `checkoutReason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `cost` double DEFAULT '0',
  `batchNumber` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `sourceID` int DEFAULT '0',
  `destinationID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `class_security` */


CREATE TABLE `class_security` (
  `priKeyID` int NOT NULL AUTO_INCREMENT COMMENT 'SECURITY LEVELS\r\n 0 - everyone\r\n1 - logged in users\r\n2 - mapped to this user (actually nothing is setup for this yet, will require some methods to check data is mapped to user)\r\n3 - admin\r\n4 - super admin (devs, I''m not sure we''re using this one either ri',
  `classTableName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `getAllRecords` tinyint(1) DEFAULT '3',
  `getRecordByID` tinyint(1) DEFAULT '3',
  `getRecordLimit` tinyint(1) DEFAULT '3',
  `getConditionalRecord` tinyint(1) DEFAULT '3',
  `getConditionalRecordFromList` tinyint(1) DEFAULT '3',
  `getMaxRecord` tinyint(1) DEFAULT '3',
  `getFieldByPriKeyID` tinyint(1) DEFAULT '3',
  `getGroupFieldValues` tinyint(1) DEFAULT '3',
  `addRecord` tinyint(1) DEFAULT '3',
  `updateRecord` tinyint(1) DEFAULT '3',
  `bulkAddEdit` tinyint(1) DEFAULT '3',
  `setupRecord` tinyint(1) DEFAULT '3',
  `removeRecordByID` tinyint(1) DEFAULT '3',
  `removeLiveDraftByID` tinyint(1) DEFAULT '3',
  `removeRecordsByCondition` tinyint(1) DEFAULT '3',
  `recursiveDelete` tinyint(1) DEFAULT '3',
  `getPage` tinyint(1) DEFAULT '3',
  `createGalDirTree` tinyint(1) DEFAULT '3',
  `findOpenSession` tinyint(1) DEFAULT '3' COMMENT 'used in publicChat module',
  `checkUser` tinyint(1) DEFAULT '3' COMMENT 'used to login the user',
  `updateRecordOrder` tinyint(1) DEFAULT '3',
  `updateImgSize` tinyint(1) DEFAULT '3',
  `getOrderItemNVP` tinyint(1) DEFAULT '3',
  `expressCheckout` tinyint(1) DEFAULT '3',
  `getExpressCheckoutDetails` tinyint(1) DEFAULT '3',
  `doExpressCheckoutPayment` tinyint(1) DEFAULT '3',
  `logOut` tinyint(1) DEFAULT '3',
  `checkAccountAvail` tinyint(1) DEFAULT '3' COMMENT 'used for public_users',
  `notifyAdmin` tinyint(1) DEFAULT '3',
  `notifyUser` tinyint(1) DEFAULT '3',
  `sendActivationLink` tinyint(1) DEFAULT '3',
  `removeGal` tinyint(1) DEFAULT '3',
  `getPageTree` tinyint(1) DEFAULT '3',
  `mapChildGalleries` tinyint(1) DEFAULT '3',
  `mapPublicUsers` tinyint(1) DEFAULT '3',
  `addRating` tinyint(1) DEFAULT '0' COMMENT 'used for module_record_ratings',
  `resetForgottenPassword` tinyint(1) DEFAULT '0' COMMENT 'used for instance_password_reset',
  `getDisplayInfo` tinyint(1) DEFAULT '0',
  `getDisplayElements` tinyint(1) DEFAULT '3' COMMENT 'use in the module module, for setting up records in the public_module_page_map from the admin side',
  `getTableFieldJSON` tinyint(1) DEFAULT '3',
  `removeGalleryImage` tinyint(1) DEFAULT '3',
  `removeFile` tinyint(1) DEFAULT '3',
  `checkFileLocation` tinyint(1) DEFAULT '3' COMMENT 'used for fileLibrary module',
  `getModuleInstances` tinyint(1) DEFAULT '3' COMMENT 'used to get the public instances of a module',
  `getCartTaxTotal` tinyint(1) DEFAULT '0',
  `adjustCartItemQty` tinyint(1) DEFAULT '0',
  `getCartTotal` tinyint(1) DEFAULT '0',
  `setCartTaxTotal` tinyint(1) DEFAULT '0',
  `recurringPayment` tinyint(1) DEFAULT '0',
  `manageRecurringPaymentsProfileStatus` tinyint(1) DEFAULT '0',
  `getCartProductTotal` tinyint(1) DEFAULT '0',
  `orderEmailAdmin` tinyint(1) DEFAULT '3',
  `getSpecificProductTotal` tinyint(1) DEFAULT '0',
  `getImageInfo` tinyint(1) DEFAULT '3',
  `getAllLocations` tinyint(1) DEFAULT '3',
  `generateQrCode` tinyint(1) DEFAULT '3',
  `getLocationsJSON` tinyint(1) DEFAULT '3',
  `checkIn` tinyint(1) DEFAULT '3',
  `checkOut` tinyint(1) DEFAULT '3',
  `checkInventory` tinyint(1) DEFAULT '3',
  `updateCompanyID` tinyint(1) DEFAULT '3',
  `addProductSerialNumbers` tinyint(1) DEFAULT '3',
  `checkSerialNumber` tinyint(1) DEFAULT '3',
  `updateProductItemStatus` tinyint(1) DEFAULT '3',
  `archiveRecordByID` tinyint(1) DEFAULT '3',
  `checkOutSerializedProd` tinyint(1) DEFAULT '3',
  `setDefaultClient` tinyint(1) DEFAULT '3',
  `getCompanyListOptions` tinyint(1) DEFAULT '3',
  `updateVendorID` tinyint(1) DEFAULT '3',
  `getAvailableJobSites` tinyint(1) DEFAULT '3',
  `filterByClient` tinyint(1) DEFAULT '3',
  `getCompaniesJSON` tinyint(1) DEFAULT '3',
  `bulkDownloadQRCodes` tinyint(1) DEFAULT '3',
  `completeOnboarding` tinyint(1) DEFAULT '3' COMMENT 'Used when completing a self onboard',
  `getFileInfo` tinyint(1) DEFAULT '3',
  `bulkDownloadFileLibrary` tinyint(1) DEFAULT '3',
  `checkCertificate` tinyint(1) DEFAULT '3',
  `getUserRoles` tinyint(1) DEFAULT '3',
  `getUserIncompleteCerts` tinyint(1) DEFAULT '3' COMMENT 'Used to get certificates that are not complete',
  `modifyEmployeeCertMapEntries` tinyint(1) DEFAULT '3' COMMENT 'Creates employee_certificate_map entires based on the userID and what roles are assigned to them and deletes entries when roles are unassigned',
  `checkAndModifyCertificate` tinyint(1) DEFAULT '3',
  `updateAssetCertificate` tinyint(1) DEFAULT '3',
  `checkInspectionCertificate` tinyint(1) DEFAULT '3',
  `getNavImgPath` tinyint(1) DEFAULT '0',
  `getClientsJSON` tinyint(1) DEFAULT '3',
  `getAgentClientsJSON` tinyint(1) DEFAULT '3',
  `bulkRemoveRecordsByID` tinyint(1) DEFAULT '3',
  `generateReport` tinyint(1) DEFAULT '3',
  `generatePDF` tinyint(1) DEFAULT '3',
  `duplicateByID` tinyint(1) DEFAULT '3',
  `isUniqueField` tinyint(1) DEFAULT '3',
  `removeRecipeFromMenu` tinyint(1) DEFAULT '3',
  `getRecipeInfo` tinyint(1) DEFAULT '3',
  `emailOrderInfo` tinyint(1) DEFAULT '3',
  `getCost` tinyint(1) DEFAULT '3',
  `setHotel` tinyint(1) DEFAULT '3',
  `getHotelCode` tinyint(1) DEFAULT '3',
  `isUserMapped` tinyint(1) DEFAULT '3',
  `generate` tinyint(1) DEFAULT '3',
  `runQuery` tinyint(1) DEFAULT '3',
  `deleteModule` tinyint(1) DEFAULT '3',
  `completeModule` tinyint(1) DEFAULT '3',
  `addToPageArray` tinyint(1) DEFAULT '3',
  `getFormsJSON` tinyint(1) DEFAULT '3',
  `assignFormToModuleItem` tinyint(1) DEFAULT '3',
  `unassignFormFromModuleItem` tinyint(1) DEFAULT '3',
  `addJSContent` tinyint(1) DEFAULT '3',
  `updateMappedRecordID` tinyint(1) DEFAULT '3',
  `getFieldsFromFile` tinyint(1) DEFAULT '3',
  `updateFormLogRecord` tinyint(1) DEFAULT '3',
  `getTemplateAndReplace` tinyint(1) DEFAULT '1',
  `getInspectionCertificatesJSON` tinyint(1) DEFAULT '3',
  `changeHeaderText` tinyint(1) DEFAULT '3',
  `getAvailableInventoryLocations` tinyint(1) DEFAULT '3' COMMENT 'Used in product module to find jobsites that contain inventory for the current product.',
  `notifyAdminOfAccountChange` tinyint(1) DEFAULT '1',
  `setDefaultCompetitionData` tinyint(1) DEFAULT '1' COMMENT 'creating a new competition. call a php function',
  `getDisciplineUsers` tinyint(1) DEFAULT '0' COMMENT 'elev8, get all the users for a certain discipline',
  `getDLCByHoursYears` tinyint(1) DEFAULT '0' COMMENT 'elev8, get all discipline level classifications available for this group',
  `getTypeByAgeSize` tinyint(1) DEFAULT '0' COMMENT 'elev8, get the type/category for this group',
  `getScheduleConflictUsers` tinyint(1) DEFAULT '1' COMMENT 'elev8, gets users that have a conflicting time through multiple performance groups',
  `updateCompetitionGroups` tinyint(1) DEFAULT '1' COMMENT 'update all groups for a competition, studio parameter optional',
  `getEntriesCSV` tinyint DEFAULT '1' COMMENT 'elev8 registration download csv of enteries',
  `removeAllEntries` tinyint DEFAULT '0' COMMENT 'remove all enteries for a studio for a specific competition',
  `removeUserFromGroup` tinyint(1) DEFAULT '1' COMMENT 'elev8 remove user from a group',
  `unmapCompetitionEntries` tinyint(1) DEFAULT '1' COMMENT 'remove entries in a competition category',
  `adjustCompetitionCategoryStartEndTime` tinyint(1) DEFAULT '0' COMMENT 'elev8 update the competition categories',
  `getScheduleCSV` tinyint(1) DEFAULT '1' COMMENT 'get all the entries listed in the schedule',
  `getClassScheduleConflictUsers` tinyint(1) DEFAULT '1',
  `getScheduleConflictInstructors` tinyint(1) DEFAULT '1',
  `sendAppActivationLink` tinyint(1) DEFAULT '0',
  `duplicateCompetition` tinyint DEFAULT '1',
  `updateStageNames` tinyint DEFAULT '3',
  `getGroupFilterOptions` tinyint DEFAULT '3',
  `getSasURL` tinyint(1) DEFAULT '3' COMMENT 'get the URL to modify assets via API call',
  `mapAzureLink` tinyint(1) DEFAULT '3' COMMENT 'add an azure record and map it to another module simultaneously',
  `commitBlockList` tinyint(1) DEFAULT '3',
  `downloadFile` tinyint(1) DEFAULT '3',
  `getCompetitionAwards` tinyint DEFAULT '3',
  `addIndividualReel` tinyint(1) DEFAULT '3' COMMENT 'add an individual reel. should always be admin only',
  `getCompetitionStudioUsers` tinyint(1) DEFAULT '3' COMMENT 'get the users that are in entries of the competition, belonging to the specific studio',
  `mergeDancerAccounts` tinyint(1) DEFAULT '3',
  `getAccountInfo` tinyint(1) DEFAULT '3' COMMENT 'for merging accounts, display user info when selected in dropdown',
  `checkAssetCertificate` tinyint(1) DEFAULT '3',
  `generateJSONFile` tinyint(1) DEFAULT '3',
  `getProductOptionValues` tinyint(1) DEFAULT '3',
  `editOrderAddCart` tinyint(1) DEFAULT '3',
  `getProductOptions` tinyint(1) DEFAULT '3',
  `updateProductOptions` tinyint(1) DEFAULT '3',
  `updateCoordinates` tinyint(1) DEFAULT '3',
  `getProducts` tinyint(1) DEFAULT '3',
  `getProductFavouriteStats` tinyint(1) DEFAULT '3',
  `getSignUpStats` tinyint(1) DEFAULT '3',
  `toggleFavourite` tinyint(1) DEFAULT '3',
  `passwordChangeConfirmation` tinyint(1) DEFAULT '3' COMMENT 'for sending password change confirmation',
  `syncHamsterProducts` tinyint(1) DEFAULT '3',
  `setDefaultJobSite` tinyint(1) DEFAULT '3' COMMENT 'used by RM inventory tracking module',
  `checkPromoCode` tinyint(1) DEFAULT '3',
  `getRecurringPaymentProfileDetails` tinyint(1) DEFAULT '3',
  `updatePromoUser` tinyint(1) DEFAULT '3',
  `checkPromoCodeAndUpdateUser` tinyint(1) DEFAULT '3',
  `createFarmCompany` tinyint(1) DEFAULT '3',
  `removeFileLibraryFromRecordID` tinyint(1) DEFAULT '3',
  `BulkFileDownloadByCompany` tinyint(1) DEFAULT '3',
  `readPDF` tinyint(1) DEFAULT '3',
  `downloadCSV` tinyint(1) DEFAULT '3',
  `generateRateSheet` tinyint(1) DEFAULT '3',
  `bulkArchiveRecordsByID` tinyint DEFAULT '3',
  `getProductInfo` tinyint DEFAULT '3',
  `setSelectedTicket` tinyint DEFAULT '3',
  `validateTicket` tinyint DEFAULT '3',
  `generateScheduleDraft` tinyint(1) DEFAULT '3' COMMENT 'elev8 competition schedule drafts',
  `getCompetitionEntries` tinyint(1) DEFAULT '3',
  `sendNotification` tinyint(1) DEFAULT '3',
  `getCartItemQty` tinyint(1) DEFAULT '3' COMMENT 'used on cart module, check JS file',
  `getCropTypes` tinyint(1) DEFAULT '3',
  `getUserProductPrice` tinyint(1) DEFAULT '1',
  `addUserToMailChimp` tinyint(1) DEFAULT '3',
  `processHiveUser` tinyint(1) DEFAULT '3',
  `toggleResponse` tinyint(1) DEFAULT '3',
  `addEditStripeProduct` tinyint(1) DEFAULT '3',
  `setBillingPortal` tinyint(1) DEFAULT '3',
  `transferContainer` tinyint(1) DEFAULT '3',
  `adjustStoreOrderProductItems` tinyint(1) DEFAULT '3',
  `updateRecordContainer` tinyint(1) DEFAULT '3',
  `getReportData` tinyint(1) DEFAULT '3',
  `generateBulkQrCodePDF` tinyint(1) DEFAULT '3',
  `updatePublicUserCompetitionScheduleMap` tinyint(1) DEFAULT '3',
  `publicUserCompetitionScheduleMap` tinyint(1) DEFAULT '3',
  `removeGroupFromSchedule` tinyint(1) DEFAULT '3',
  `handleRegisterRequestAction` tinyint(1) DEFAULT '3',
  `handleAdminRequestAction` tinyint(1) DEFAULT '3',
  `downloadTicket` tinyint(1) DEFAULT '3' COMMENT 'download ecommerce ticket',
  `getCompetitionName` tinyint(1) DEFAULT '3',
  `setActiveUserGroup` tinyint(1) DEFAULT '1',
  `addDisciplineAll` tinyint(1) DEFAULT '3',
  `saveMark` tinyint(1) DEFAULT '3',
  `generateSessionsFromScheduler` tinyint(1) DEFAULT '3',
  `generateTicketsForSessions` tinyint(1) DEFAULT '3',
  `setUpAccessRecord` tinyint(1) DEFAULT '3' COMMENT 'function in cmsAPI/elev8/competitionStudioMap',
  `orderEmailCustomer` tinyint(1) DEFAULT '3',
  `inputsProSetUserDefaultBookSession` tinyint(1) DEFAULT '3',
  `getQRcodeFormatStyling` tinyint(1) DEFAULT '3',
  `cypressRemoveGeneratedFile` tinyint(1) DEFAULT '3',
  `processQuery` tinyint(1) DEFAULT '3',
  `writeFileContent` tinyint(1) DEFAULT '3',
  `expireUsersActiveSessions` tinyint(1) DEFAULT '3',
  `lui` tinyint(1) DEFAULT '3',
  `toggleFavouriteProduct` tinyint(1) DEFAULT '3',
  `getAllReportByType` tinyint(1) DEFAULT '3' COMMENT 'foodbank - API endpoint',
  `getCurrentInventory` tinyint(1) DEFAULT '3' COMMENT 'foodbank api endpoint',
  `getAvaiableProductOptionMap` tinyint(1) DEFAULT '3',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=341 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `cms_settings` */


CREATE TABLE `cms_settings` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `googleAnalyticsCode` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `googleSiteVerification` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `googleDevKey` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `googlePublisherLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `youtubeUser` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `zohoClient` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `zohoSecret` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `zohoRefresh` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `zohoLeadOwner` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `siteName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `adminEmail` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `metaDesc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `reCAPTCHASecretKey` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reCAPTCHASiteKey` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `orderCompanyName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `orderCompanyAddress1` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `orderCompanyAddress2` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `orderCompanyAddress3` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `orderEmailAdmin` tinyint DEFAULT '0' COMMENT 'Email admin when ecommerce order is processed. 1 - yes 0 - no',
  `languageLabels` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `siteURL` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sharethis` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sharethisType` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `streetAddress` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `addressRegion` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `postalCode` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `addressCountry` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sameAs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowMultipleLogin` tinyint(1) DEFAULT '1',
  `manifestFileThemeColor` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '#FFFFFF',
  `manifestFileShortName` char(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `manifestFileCategories` char(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `manifestFileDisplay` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'standalone',
  `manifestFileOrientation` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'portrait-primary',
  `manifestFileScreenshots` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `manifestFileIcons` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `phpMailerSetting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `sitemapType` tinyint(1) DEFAULT '0' COMMENT '0 - XML 1 - HTML',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `colors` */


CREATE TABLE `colors` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '0',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `comment` */


CREATE TABLE `comment` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `recordID` int DEFAULT NULL,
  `postCopy` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `postTime` time DEFAULT NULL,
  `postDate` date DEFAULT NULL,
  `userID` int DEFAULT NULL,
  `validated` tinyint(1) DEFAULT NULL,
  `anonymousName` char(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `website` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `comment_module_map` */


CREATE TABLE `comment_module_map` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `companies` */


CREATE TABLE `companies` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `description` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '1',
  `address` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `phone` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `email` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `isVendor` tinyint(1) DEFAULT '0',
  `inventoryNotificationEmail` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `certificateNotificationEmail` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `country` int DEFAULT '0',
  `provState` int DEFAULT '0',
  `city` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `postalZip` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `imageGalleryID` int DEFAULT '4',
  `galleryImageID` int DEFAULT '0',
  `fileLibraryID` int DEFAULT '0',
  `storeFront` tinyint(1) DEFAULT '0' COMMENT '1- Storefront is active ',
  `compStorePrefix` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `secondarySiteColor` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `primarySiteColor` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `twitterLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `facebookLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `linkedInLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `instagramLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ecomHeaderText` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `ecomFooterText` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB AUTO_INCREMENT=1925 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPRESSED;

/*Table structure for table `company_application_map` */


CREATE TABLE `company_application_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `companyID` int NOT NULL COMMENT 'matching pk in companies table',
  `applicationID` int NOT NULL COMMENT 'matching pk in cms_settings',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `company_contact_map` */


CREATE TABLE `company_contact_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `contactID` int NOT NULL DEFAULT '0',
  `clientID` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='This table will be used to map employees (or contacts in RM''s case) to companies.';

/*Table structure for table `company_inventory_map` */


CREATE TABLE `company_inventory_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `companyID` int DEFAULT NULL,
  `jobSiteID` int DEFAULT NULL,
  `minStockLevel` int DEFAULT '0',
  `maxStockLevel` int DEFAULT '0',
  `currentStockLevel` int DEFAULT '0',
  `checkOutOption` tinyint(1) DEFAULT '0' COMMENT '0 - item,1 - unit',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `company_job_site_map` */


CREATE TABLE `company_job_site_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `companyID` int DEFAULT NULL,
  `jobSiteID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `company_product_price_map` */


CREATE TABLE `company_product_price_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `compID` int DEFAULT NULL,
  `productID` int DEFAULT NULL,
  `price` double DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `company_store_settings` */


CREATE TABLE `company_store_settings` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `companyID` int DEFAULT '0',
  `gpMerchantID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'Global Payments Merchant ID',
  `gpAccountID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'Global Payments Account ID',
  `gpSharedSecret` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'Global Payments Shared Secret',
  `gpServiceUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'Global Payments Service URL',
  `storeCurrency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'Should be 3 letters ex. USD,CAD',
  `monPaymentPageID` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `monTransactionKey` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `monppUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `monCancelUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `monReturnUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppUser` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppPassword` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppApiRequestDate` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppSignature` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppVersion` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppCancelUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppReturnUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppType` int DEFAULT '0' COMMENT '0 - none, 1 - website payment standard, 2 - website payment pro',
  `ppUserAction` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ppAddrOverride` int DEFAULT '0' COMMENT 'The value 1 indicates that the PayPal pages should display the shipping address set by you in this SetExpressCheckout request, not the shipping address on file with PayPal for this customer.',
  `ppNoShipping` int DEFAULT '0' COMMENT 'paypal api variable to enable\\diable displaying shipping fields',
  `cpServer` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `cpPort` int DEFAULT '0' COMMENT 'Canada Post',
  `cpMerchant_cpcid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `cpAjaxWaitingMessage` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `cpReadyToShip` int DEFAULT '0' COMMENT '1 - ship items as is, 0 - ship item as a 3d object, use boxes',
  `purKey` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purPass` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purBillingAccount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purRegisteredAccount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purGetQuickOrFull` tinyint DEFAULT '1' COMMENT '1- GetFullEstimate 0 - GetQuickEstimate',
  `purSenderPostCode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purSenderName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purSenderStreetNumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purSenderStreetName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purSenderCity` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purSenderProvState` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purSenderCountry` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purSenderPhoneNumber` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `purDefaultItemWeight` double DEFAULT '0' COMMENT 'Purolator how many kg a product is if no weight is defined',
  `manUsername` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `manPassword` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `manCompanyName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `manAuthUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `manEmail` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `activateGlobalPay` tinyint DEFAULT '0' COMMENT 'For activate fields 0 - off, 1 - on',
  `activateMoneris` tinyint DEFAULT '0',
  `activatePaypal` tinyint DEFAULT '0',
  `activateCanadaPost` tinyint DEFAULT '0',
  `activatePurolator` tinyint DEFAULT '0',
  `activateManitoulin` tinyint DEFAULT '0',
  `activateFlatShipping` tinyint DEFAULT '0',
  `activatePOOrder` tinyint DEFAULT '0',
  `flatRateTax` tinyint DEFAULT '0' COMMENT 'Whether to charge tax for flat rate shipping. 0 - no, 1 - yes',
  `activateHamster` tinyint DEFAULT '0' COMMENT 'Activate Hamster integration',
  `hamsterPassword` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `hamsterURL` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'https://secure.buroplus.ca/HTTPSNovexco/FileTransfert.asmx',
  `hamsterUser` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `activateChase` tinyint DEFAULT '0',
  `ppIsLive` tinyint DEFAULT '0',
  `activateNoShipping` tinyint(1) DEFAULT '0' COMMENT 'Switch for No shipping toggle',
  `gstNumber` int DEFAULT '0',
  `activateStripe` tinyint DEFAULT '0',
  `stripeAPIKey` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `stripeCancelUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `stripeReturnUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `stripeBillingPortalReturnUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `globalPaymentCheckoutBtn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `monerisCheckoutBtn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `paypalCheckoutBtn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `stripeCheckoutBtn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `poCheckoutBtn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `company_vendor_map` */


CREATE TABLE `company_vendor_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `companyID` int DEFAULT NULL,
  `vendorID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `countries` */


CREATE TABLE `countries` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `country` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `countryCode` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ordinal` int DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=273 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `country_tax_map` */


CREATE TABLE `country_tax_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `countryID` int DEFAULT NULL,
  `taxID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `country_tax_map_countryID_IDX` (`countryID`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `crud_builder` */


CREATE TABLE `crud_builder` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `modType` int DEFAULT '0' COMMENT 'The type of module this is on. Only used for generatedForms right now',
  `ccName` char(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `files` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `directories` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `addEditInfo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `listingInfo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `isModuleActive` tinyint(1) DEFAULT '0',
  `hasFileLibrary` tinyint(1) DEFAULT '0',
  `hasImageGallery` tinyint(1) DEFAULT '0',
  `hasCategories` tinyint(1) DEFAULT '0',
  `companyID` int DEFAULT '0',
  `adminAddEditPageID` int DEFAULT '0' COMMENT 'priKeyID of the AddEdit page',
  `adminListingPageID` int DEFAULT '0' COMMENT 'priKeyID of the created modules/forms listing page',
  `publicAddEditPageID` int DEFAULT '0' COMMENT 'priKeyID of the app add edit page',
  `publicListingPageID` int DEFAULT '0' COMMENT 'priKeyID of the app listing page',
  PRIMARY KEY (`priKeyID`),
  UNIQUE KEY `crud_builder_name_uindex` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `crud_builder_client_map` */


CREATE TABLE `crud_builder_client_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `crudBuilderID` int DEFAULT NULL,
  `clientID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `deals` */


CREATE TABLE `deals` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `description` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT '1',
  `companyID` int DEFAULT '0',
  `accountID` int DEFAULT NULL,
  `amount` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `closingDate` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `assignedTo` int DEFAULT '0',
  `fileLibraryID` int DEFAULT '0',
  `createdDate` tinytext CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `domains` */


CREATE TABLE `domains` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `desc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `domainName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `lng` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `defaultPageID` int DEFAULT '0',
  `applicationID` int DEFAULT NULL,
  `siteDirectory` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '' COMMENT 'The name of the site as used when looking for siteStyles or siteAssets',
  `isLive` tinyint(1) DEFAULT '0' COMMENT 'Is this a live domain? Then make it 1. Else 0',
  `appAssets` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '' COMMENT 'Assets shared by the app (images, etc)',
  `standardModulePageID` int DEFAULT '0' COMMENT 'Used as pageID in pmpm table for modules you want to load on every page for this domain',
  `siteURL` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '' COMMENT 'PWA - siteURL var in manifest file',
  `pageTransition` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `googleMapAPIKey` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `cmsSettingsID` int DEFAULT '0',
  `compStoreID` int DEFAULT '0' COMMENT 'we put the company ID for the apps that don''t use RM storefront but still needs the cart module',
  `useDefaultOfflineFuntionality` tinyint(1) DEFAULT '1' COMMENT '1 - the app uses default serviceWorker.php file , 0 - app handles loading serviceworker.php file in its own way',
  `logRocketAPIKey` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'put project name from LogRocket here. if it''s empty LogRocket stuff won''t kick in',
  PRIMARY KEY (`priKeyID`),
  KEY `domains_domainName_IDX` (`domainName`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `employees` */


CREATE TABLE `employees` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `phone` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `email` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT '0',
  `address` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isPrimaryContact` int DEFAULT '0',
  `imageGalleryID` int DEFAULT '0',
  `galleryImageID` int DEFAULT '0',
  `linkedInProfile` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ordinal` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `equipment` */


CREATE TABLE `equipment` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `unitIDNum` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `name` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `description` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `galleryImageID` int DEFAULT '0',
  `imageGalleryID` int DEFAULT '0',
  `year` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `make` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `price` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
  `model` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `datePurchased` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `rate` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `serialNum` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT '0',
  `manufacturer` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isCSAApproved` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'No',
  `license` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `replacementDate` date DEFAULT NULL,
  `dateManufactured` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`priKeyID`),
  FULLTEXT KEY `temp` (`unitIDNum`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPRESSED;

/*Table structure for table `equipment_job_site_map` */


CREATE TABLE `equipment_job_site_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `equipmentID` int DEFAULT NULL,
  `jobSiteID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `equipment_status` */


CREATE TABLE `equipment_status` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `equipmentID` int DEFAULT NULL,
  `employeeID` int DEFAULT NULL,
  `jobSiteID` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `assignmentStartDate` date DEFAULT NULL,
  `assignmentEndDate` date DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `qty` int DEFAULT '1',
  `fileLibraryID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `faq` */


CREATE TABLE `faq` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `faqAnswer` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `applicationID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `file_library` */


CREATE TABLE `file_library` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `fileName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fileDesc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `embedCode` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `isPrivate` tinyint(1) DEFAULT '0',
  `companyID` int DEFAULT NULL,
  `groupID` int DEFAULT '0',
  `domainID` int DEFAULT '1',
  `targetAttachment` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `dates` date DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `file_library_maintenance_log_map` */


CREATE TABLE `file_library_maintenance_log_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `fileLibraryID` int DEFAULT NULL,
  `maintenanceLogID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `file_library_notification_map` */


CREATE TABLE `file_library_notification_map` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `fileLibraryID` int NOT NULL DEFAULT '0',
  `notificationID` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `file_library_product_map` */


CREATE TABLE `file_library_product_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `fileLibraryID` int DEFAULT NULL,
  `productID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `file_library_user_map` */


CREATE TABLE `file_library_user_map` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `fileLibraryID` int NOT NULL DEFAULT '0',
  `publicUserID` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `flat_rate` */


CREATE TABLE `flat_rate` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `price` int DEFAULT NULL,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`),
  KEY `flat_rate_companyID_IDX` (`companyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `flat_rate_postal_map` */


CREATE TABLE `flat_rate_postal_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `flatRateID` int DEFAULT NULL,
  `postalID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `mapping id's` (`flatRateID`),
  KEY `flat_rate_postal_map_postalID_IDX` (`postalID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `flat_rate_product_map` */


CREATE TABLE `flat_rate_product_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `flatRateID` int DEFAULT NULL,
  `productID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `mapping id's` (`flatRateID`),
  KEY `flat_rate_product_map_productID_IDX` (`productID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `forms` */


CREATE TABLE `forms` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `formName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sentTo` blob,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `firstName` int DEFAULT '0',
  `firstNameReq` int DEFAULT '0',
  `lastName` int DEFAULT '0',
  `lastNameReq` int DEFAULT '0',
  `fullName` int DEFAULT '0',
  `fullNameReq` int DEFAULT '0',
  `companyName` int DEFAULT '0',
  `companyNameReq` int DEFAULT '0',
  `phoneNumber` int DEFAULT '0',
  `phoneNumberReq` int DEFAULT '0',
  `email` int DEFAULT '0',
  `emailReq` int DEFAULT '0',
  `comments` int DEFAULT '0',
  `commentsReq` int DEFAULT '0',
  `howToContact` int DEFAULT '0',
  `howToContactReq` int DEFAULT '0',
  `hasFileUpload` int DEFAULT '0',
  `fileUploadReq` int DEFAULT '0',
  `reCAPTCHA` int DEFAULT '0',
  `autoResponseBody` blob,
  `autoResponseSubject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `autoResponseActive` int DEFAULT '0',
  `feedbackType` int DEFAULT '0',
  `feedbackTypeReq` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `gallery_images` */


CREATE TABLE `gallery_images` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `groupID` int DEFAULT NULL,
  `domainID` int DEFAULT NULL,
  `galleryID` int DEFAULT '0',
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `imgDesc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `fileName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `imageCopy` longblob,
  `ordinal` int DEFAULT '0',
  `linkPageID` int DEFAULT '0' COMMENT 'What page the image links to',
  `orientation` int DEFAULT '1',
  `linkURL` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`),
  KEY `Gallery ID` (`galleryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `generated_forms` */


CREATE TABLE `generated_forms` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `crudBuilderID` int DEFAULT NULL COMMENT 'The generatedForm''s ID (entry in the crud_builder table)',
  `recordID` int DEFAULT NULL COMMENT 'The record this form is on. Ex. The assetID of the asset this form is on',
  `moduleType` int DEFAULT NULL COMMENT 'The ID of the module this form is on. (User->91, Asset->173)',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `generated_forms_maintenance_logs_map` */


CREATE TABLE `generated_forms_maintenance_logs_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `maintenanceLogID` int DEFAULT NULL,
  `generatedFormID` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '0',
  `formRecordID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `image_area_maps` */


CREATE TABLE `image_area_maps` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `imageAreaMapName` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `galleryImageID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `image_gallery` */


CREATE TABLE `image_gallery` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `groupID` int DEFAULT '0',
  `domainID` tinyint DEFAULT '0',
  `name` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ordinal` int DEFAULT '0',
  `thumbWidth` mediumint DEFAULT NULL,
  `thumbHeight` mediumint DEFAULT NULL,
  `thumbMethod` int NOT NULL DEFAULT '3',
  `thumbColour` int DEFAULT '0',
  `mediumWidth` mediumint DEFAULT NULL,
  `mediumHeight` mediumint DEFAULT NULL,
  `mediumMethod` int NOT NULL DEFAULT '0',
  `mediumColour` int DEFAULT '0',
  `largeWidth` mediumint DEFAULT NULL,
  `largeHeight` mediumint DEFAULT NULL,
  `largeMethod` int NOT NULL DEFAULT '0',
  `largeColour` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `image_gallery_map` */


CREATE TABLE `image_gallery_map` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `parentGalleryID` int NOT NULL,
  `childGalleryID` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `import` */


CREATE TABLE `import` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `moduleID` int DEFAULT '0',
  `moduleName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `importType` tinyint(1) DEFAULT '0',
  `dataBaseFields` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `csvFieldsName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `updateMapSec` tinyint(1) DEFAULT '1',
  `csvFieldsLine` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `domainID` int DEFAULT '0',
  `groupID` int DEFAULT '0',
  `includeMapTbl` tinyint DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_alphabetical_ordered_list` */


CREATE TABLE `instance_alphabetical_ordered_list` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `pmpmListID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_azure` */


CREATE TABLE `instance_azure` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mappedModuleID` int DEFAULT NULL COMMENT 'a module that is mapped to this instance',
  `mappedFields` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowedTypes` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `maxFileSize` int DEFAULT '500' COMMENT 'Max file size in MB',
  `extensions` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_blog` */


CREATE TABLE `instance_blog` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `blogTrim` smallint DEFAULT NULL COMMENT 'amount of characters that show in blog preview',
  `titleTrim` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `displayRecommended` tinyint(1) DEFAULT '0',
  `recommendedBlogInstanceID` int DEFAULT '0',
  `blogDateFormatType` tinyint(1) DEFAULT '0' COMMENT '0 - format the date as one string (day month year), 1 - format the date pieces individually',
  `blogDateFormat` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'F j, Y',
  `blogDayFormat` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'j',
  `blogMonthFormat` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'F',
  `blogYearFormat` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Y',
  `blogTimeFormat` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'g:i a',
  `blogButtonText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'View',
  `specificBlogPageID` smallint DEFAULT NULL COMMENT 'sets a page ID for when viewing a specific blog',
  `blogToQueryPmpmID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_blog_category` */


CREATE TABLE `instance_blog_category` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_blog_sidebar` */


CREATE TABLE `instance_blog_sidebar` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `blogPmpmID` int DEFAULT NULL,
  `blogListPmpmID` int DEFAULT '0' COMMENT 'the priKeyID of the public_module_page_map instance for listing articles',
  `blogSearchOn` tinyint(1) DEFAULT NULL,
  `rssEmailSubscribeOn` tinyint(1) DEFAULT NULL,
  `categoriesOn` tinyint(1) DEFAULT NULL COMMENT 'display category links',
  `recentBlogsOn` tinyint(1) DEFAULT NULL,
  `tagsOn` tinyint(1) DEFAULT NULL COMMENT 'display tag links',
  `datesOn` tinyint(1) DEFAULT NULL COMMENT 'display date links',
  `blogDateFormat` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `authorsOn` tinyint(1) DEFAULT NULL,
  `searchInputValue` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `categoriesHeader` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `recentBlogsHeader` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `tagsHeader` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `datesHeader` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `authorsHeader` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `searchResultsPageID` int DEFAULT NULL,
  `viewCategoriesPageID` int DEFAULT NULL COMMENT 'the pageID the link takes you to',
  `viewRecentBlogPageID` int DEFAULT NULL,
  `viewTagsPageID` int DEFAULT NULL COMMENT 'the pageID the link takes you to',
  `viewDatesPageID` int DEFAULT NULL COMMENT 'the pageID the link takes you to',
  `viewAuthorsPageID` int DEFAULT NULL,
  `feedBurnerURI` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `blogCategoryFormat` tinyint(1) DEFAULT NULL COMMENT '0- list categories as simple links 1- list categories as a drop down',
  `archiveFormat` tinyint(1) DEFAULT NULL COMMENT '0 - list all years and months\r\n1 - list active months and years (months and years that there is only one post for them)',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_brand` */


CREATE TABLE `instance_brand` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_bread_crumbs` */


CREATE TABLE `instance_bread_crumbs` (
  `priKeyID` int NOT NULL DEFAULT '0',
  `modulePriority` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `homePageID` int DEFAULT '0' COMMENT 'landing page id, can be anything ',
  `homePageName` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `listingPageID` int DEFAULT '0' COMMENT 'Main listing page id',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_cart` */


CREATE TABLE `instance_cart` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `description` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `orderCompletedPageID` int DEFAULT NULL COMMENT 'Cart page used in view-cart.js for the places we redirect user to orderCompleted page, if we need access to cart page viewCartPageID is what we use for',
  `displayFields` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'Empty is default. Can add others ',
  `productListPmpmID` int DEFAULT '0' COMMENT 'pmpmID for the product List that goes on the same page as cart module',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_category` */


CREATE TABLE `instance_category` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `moduleIDOptions` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'list of moduleIDs we want in the module dropdown in addEditForm, comma separated',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_certificate` */


CREATE TABLE `instance_certificate` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `viewCategoriesPageID` int DEFAULT '0',
  `viewUsersPageID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_certificate_company_map` */


CREATE TABLE `instance_certificate_company_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_check_in_check_out_log` */


CREATE TABLE `instance_check_in_check_out_log` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `goToPageJSON` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_clinic_dashboard` */


CREATE TABLE `instance_clinic_dashboard` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_cms_settings` */


CREATE TABLE `instance_cms_settings` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_company` */


CREATE TABLE `instance_company` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `recursiveModulePmpmID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_company_inventory_map` */


CREATE TABLE `instance_company_inventory_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `detailsPageID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_company_product_price_map` */


CREATE TABLE `instance_company_product_price_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_configure_certificates` */


CREATE TABLE `instance_configure_certificates` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_crud_builder` */


CREATE TABLE `instance_crud_builder` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `assignAssetPageID` int DEFAULT NULL COMMENT 'The priKeyID of the public_pages Assign-Asset-Form page',
  `nameFieldEntry` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `excludeFieldNames` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `parentDirName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `showReview` tinyint(1) DEFAULT '1' COMMENT 'Determines if the ''Review Module'' section is shown. Review Module shows what files and database entries were created',
  `showListing` tinyint(1) DEFAULT '1' COMMENT 'Determines if the ''Listing Module'' section is shown. Listing Module is where the user can select which fields are shown on the Listing page.',
  `fieldTypes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `fieldTags` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `moduleDefaultID` int DEFAULT NULL COMMENT 'The default value that the user can select',
  `fieldsToIgnore` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `queryCondition` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `userGroupIDs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'commma separated string of groupID',
  `mfmccClasses` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `hasPublicListingPage` tinyint(1) DEFAULT '0',
  `publicListingSetting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `hasDraftedRecord` tinyint(1) DEFAULT '0' COMMENT 'set to 1 to add draftedRecord into the created module table',
  `publicModuleQueryFile` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `listingPageID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `instance_cypress_Integration` */


CREATE TABLE `instance_cypress_Integration` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

/*Table structure for table `instance_deal` */


CREATE TABLE `instance_deal` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instance_description` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `linkToPageID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `instance_display_cart_qty` */


CREATE TABLE `instance_display_cart_qty` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `description` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cartPmpmID` int DEFAULT '1',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_employee_certificate_map` */


CREATE TABLE `instance_employee_certificate_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `backToPage` int DEFAULT '0',
  `goToPage` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_employees` */


CREATE TABLE `instance_employees` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `empButtonText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'View',
  `linkPageID` int DEFAULT NULL,
  `empToQueryPmpmID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_equipment` */


CREATE TABLE `instance_equipment` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `backToPage` int DEFAULT '0',
  `goToPage` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_equipment_status` */


CREATE TABLE `instance_equipment_status` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `backToPage` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_faq` */


CREATE TABLE `instance_faq` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `categoriesOnOff` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_file_library` */


CREATE TABLE `instance_file_library` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_file_search` */


CREATE TABLE `instance_file_search` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `defaultSearchFieldText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `buttonText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `resultPage` int DEFAULT '0' COMMENT 'What page we call a upc for to display the product results',
  `ListPmpmID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_forms` */


CREATE TABLE `instance_forms` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `instance_gallery` */


CREATE TABLE `instance_gallery` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `galleryID` int DEFAULT NULL,
  `imagePmpmID` int DEFAULT '0' COMMENT 'public_module_page_map ID of the images for the level 2 of this module',
  `imageListPageID` int DEFAULT NULL COMMENT 'page id of the image list, only used on the admin side to have a seperate page for gallery image list',
  `imageLinkText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `imgSize` tinyint(1) DEFAULT '0' COMMENT '0 - thumb, 1 - medium, 2 - large, 3 - original',
  `lightbox` tinyint(1) DEFAULT '0',
  `lightboxImgSize` int DEFAULT '0',
  `copyLen` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_gallery_image` */


CREATE TABLE `instance_gallery_image` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `desc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `galleryInstanceID` int DEFAULT NULL COMMENT 'If our images aren''t a level2 or greater module, we won''t have gallery instance parameteres set. this is the gallery instance ID we should be using then. an example of when this would be used is when you list the gallery images on the admin side',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_general_search` */


CREATE TABLE `instance_general_search` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `resultPageID` int DEFAULT '0' COMMENT '0 - code with use current pageID as the result page, otherwise goes to the page we set here',
  `categorySectionHeader` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_get_display_info` */


CREATE TABLE `instance_get_display_info` (
  `priKeyID` int NOT NULL DEFAULT '0',
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `inputPlaceHolder` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `submitButtonText` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `userDisplayInfo` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `gotoPage` int DEFAULT NULL COMMENT 'page to go to after data is submitted, null or empty doesn''t go anywhere, and will change the html element with class displayUserInfoInner',
  `htmlMarkup` tinyint(1) DEFAULT '0' COMMENT 'whether to include spans around the user text for styling',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_import` */


CREATE TABLE `instance_import` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `displayedModules` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_job_site` */


CREATE TABLE `instance_job_site` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `backToPage` int DEFAULT '0',
  `goToPage` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_job_site_certificate_map` */


CREATE TABLE `instance_job_site_certificate_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_language_select` */


CREATE TABLE `instance_language_select` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `displayType` tinyint(1) DEFAULT '0' COMMENT '0 - drop down, 1 - links/buttons',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_location_finder` */


CREATE TABLE `instance_location_finder` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_location_finder_map` */


CREATE TABLE `instance_location_finder_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `pmpmListID` int DEFAULT NULL,
  `listClassName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `mapCenterLat` decimal(24,20) DEFAULT '0.00000000000000000000' COMMENT 'map center latitude',
  `mapCenterLong` decimal(24,20) DEFAULT '0.00000000000000000000' COMMENT 'map center longitude',
  `countryID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_login` */


CREATE TABLE `instance_login` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `loginPageID` int DEFAULT '0' COMMENT 'what page to go to after we login, null doesn''t go anywhere',
  `logoutPageID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `loginBtnText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `logoutBtnText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `showHideBtnText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `defaultHidden` int DEFAULT NULL COMMENT 'login box hidden by default?',
  `showForgetPasswordOpt` int DEFAULT '0' COMMENT 'if you set this to 1, make sure password reset module is active for Admin landing page',
  `userModuleID` int DEFAULT '5' COMMENT 'Select the user module to use for this login instance. Defaults to 5 (public_users module)',
  `signUpMessage` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_manufacturer` */


CREATE TABLE `instance_manufacturer` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_mileage` */


CREATE TABLE `instance_mileage` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `backToPage` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_module_sidebar` */


CREATE TABLE `instance_module_sidebar` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `searchOn` tinyint(1) DEFAULT '0',
  `searchInputValue` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `searchResultsPageID` int DEFAULT NULL,
  `buttonText` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `categoriesOn` tinyint(1) DEFAULT '0',
  `categoriesHeader` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `categoriesFormat` tinyint(1) DEFAULT '0' COMMENT '0: link tag 1: select tag 2:tree format',
  `viewCategoriesPageID` int DEFAULT NULL COMMENT 'the pageID the link takes you to',
  `moduleID` int DEFAULT NULL,
  `moduleListPmpmID` int DEFAULT NULL COMMENT 'the priKeyID of the public_module_page_map instance for listing module records',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_modules` */


CREATE TABLE `instance_modules` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_nav` */


CREATE TABLE `instance_nav` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `navType` tinyint(1) DEFAULT '0' COMMENT '0 - top,  \r\n1 - side,  2 - bottom',
  `subNavParentPageID` int DEFAULT '0' COMMENT 'if nav on a sub page, what is the parent ID',
  `isSubNav` tinyint(1) DEFAULT '0' COMMENT 'its the sub navigation, probably on a content page',
  `isResponsive` tinyint(1) DEFAULT '0' COMMENT 'if this nav should act responsively or not.',
  `navBarClasses` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `navInnerClasses` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `navBrandType` tinyint(1) DEFAULT '0' COMMENT '0 - adds white logo image 1 - keeps it as link 2 - adds logo image',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_notifications` */


CREATE TABLE `instance_notifications` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `userModuleID` int DEFAULT '5',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_page_search` */


CREATE TABLE `instance_page_search` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `searchPageID` int DEFAULT NULL,
  `searchFieldText` char(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `searchBtnText` char(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `contentTrim` int DEFAULT NULL COMMENT 'how many characters to display, 0 is all',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_pages` */


CREATE TABLE `instance_pages` (
  `priKeyID` int NOT NULL DEFAULT '0',
  `instancePageDesc` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_pages_module` */


CREATE TABLE `instance_pages_module` (
  `priKeyID` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_password_reset` */


CREATE TABLE `instance_password_reset` (
  `priKeyID` int NOT NULL DEFAULT '0',
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `resetPasswordPageID` int DEFAULT '0' COMMENT 'to generate the link forreset password email',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_product_category` */


CREATE TABLE `instance_product_category` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `navType` tinyint(1) DEFAULT '0' COMMENT '0 - side tree, 1 - top tree',
  `toggleSpeed` int DEFAULT '250',
  `isSubNav` tinyint(1) DEFAULT '0',
  `onclickEvent` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `onclickParams` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `instanceProductListID` int DEFAULT '0',
  `instanceSubCatID` int DEFAULT NULL,
  `copyTrim` smallint DEFAULT NULL,
  `rootCats` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_product_certificate_map` */


CREATE TABLE `instance_product_certificate_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `backToPage` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_product_certification_log` */


CREATE TABLE `instance_product_certification_log` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_product_options` */


CREATE TABLE `instance_product_options` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `desc` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'describes instance',
  `goToPage` int DEFAULT NULL COMMENT 'Used for directing user to addEdit page of product when selecting a product option value',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_product_price_level` */


CREATE TABLE `instance_product_price_level` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `desc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_product_search` */


CREATE TABLE `instance_product_search` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `description` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `defaultSearchFieldText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `buttonText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `resultPage` int DEFAULT '0' COMMENT 'What page we call a upc for to display the product results',
  `productResultListPmpmID` int DEFAULT '0',
  `snResultListPmpmID` int DEFAULT '0',
  `productResultListClass` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `snResultListClass` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `assetResultListPmpmID` int DEFAULT '0',
  `assetResultListClass` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `jobSiteResultListPmpmID` int DEFAULT '0',
  `jobSiteResultListClass` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `publicUserResultListClass` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `publicUserResultListPmpmID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_product_serial_number_map` */


CREATE TABLE `instance_product_serial_number_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `goToPageJSON` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_products` */


CREATE TABLE `instance_products` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `copyLen` smallint DEFAULT '0' COMMENT 'length of our copy, 0 is display all',
  `viewProdBtnText` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `viewProdBtnText2` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `inventoryDisplayType` tinyint(1) DEFAULT '1' COMMENT '1 - displays inventory number\r\n2 - uses text in inventoryDisplayText',
  `inventoryInStockText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `inventoryOutStockText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `categoryLinkQty` tinyint DEFAULT '0' COMMENT 'the number of categories that are linked to for each product in this instance',
  `featureDisplayCount` smallint DEFAULT '0' COMMENT 'how many features to show, null is all',
  `productPageID` int DEFAULT '0',
  `viewCartPageID` int DEFAULT '0' COMMENT 'page ID of the view cart',
  `viewCartButtonText` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `prodCatPageID` int DEFAULT '0',
  `viewCartSetQty` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sendToCart` int DEFAULT '0',
  `backToPage` int DEFAULT '0',
  `goToPage` int DEFAULT '0',
  `acceptedFilesList` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `viewOptionPageID` int DEFAULT '0' COMMENT 'Page that will be linked to if you wish to display this products product options',
  `checkInPageID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `checkOutPageID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_properties` */


CREATE TABLE `instance_properties` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `copyLen` smallint DEFAULT '0' COMMENT 'length of our copy, 0 is display all',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_property_city` */


CREATE TABLE `instance_property_city` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `navType` tinyint(1) DEFAULT '0' COMMENT '0 - side tree, 1 - top tree',
  `toggleSpeed` int DEFAULT '250',
  `isSubNav` tinyint(1) DEFAULT '0',
  `onclickEvent` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `onclickParams` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `instanceProductListID` int DEFAULT '0',
  `rootCats` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_property_search` */


CREATE TABLE `instance_property_search` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `defaultSearchFieldText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `buttonText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `resultPage` int DEFAULT '0' COMMENT 'What page we call a upc for to display the product results',
  `ListPmpmID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_property_type` */


CREATE TABLE `instance_property_type` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `navType` tinyint(1) DEFAULT '0' COMMENT '0 - side tree, 1 - top tree',
  `toggleSpeed` int DEFAULT '250',
  `isSubNav` tinyint(1) DEFAULT '0',
  `onclickEvent` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `onclickParams` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `instanceProductListID` int DEFAULT '0',
  `rootCats` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_public_module_page_map` */


CREATE TABLE `instance_public_module_page_map` (
  `priKeyID` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_public_user_groups` */


CREATE TABLE `instance_public_user_groups` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_public_users` */


CREATE TABLE `instance_public_users` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `publicUserEmailText` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `adminEmailText` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `selfAddAlertText` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `adminApproveAlertText` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `selfAddPubUser` tinyint(1) DEFAULT '0',
  `unavailableUserNameText` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `createGoto` int DEFAULT '1' COMMENT 'What page to go to after a page is created. 0 is admin or don''t go anywhere',
  `autoLogin` tinyint(1) DEFAULT '0' COMMENT 'if the user creates a new account, automatically login after the account is created',
  `publicUser` tinyint(1) DEFAULT '0' COMMENT 'determines if the form is limited to editing the current user. 0 - not limited, 1 - limited',
  `isGuestInstance` tinyint(1) DEFAULT '0' COMMENT 'If the user is a guest this will grant then only access to the cart. This account will be deleted after login',
  `passwordRequriedOnUpdate` tinyint DEFAULT '0' COMMENT 'If the user is logged in and you want them to be able to update there own password then set this to 1',
  `sendActivationLink` tinyint(1) DEFAULT '0' COMMENT 'If you want to send the user a activation link that will add them to the public users group',
  `detailPage` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_qr_code_scanner` */


CREATE TABLE `instance_qr_code_scanner` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `GoToPage` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `instance_report` */


CREATE TABLE `instance_report` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `instance_standard_content` */


CREATE TABLE `instance_standard_content` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_store_order_product_map` */


CREATE TABLE `instance_store_order_product_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_store_orders` */


CREATE TABLE `instance_store_orders` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `productInstanceID` int DEFAULT '0' COMMENT 'The pmpmID of the products to list for this order',
  `orderPageID` int DEFAULT '0' COMMENT 'The priKeyID of the page to view all the order information',
  `orderPmpmID` int DEFAULT '0',
  `orderDetailsText` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `orderStatusOptions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'json contain the key:value for orderStatus options',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_store_taxes` */


CREATE TABLE `instance_store_taxes` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_tags` */


CREATE TABLE `instance_tags` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_testimonials` */


CREATE TABLE `instance_testimonials` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_uom` */


CREATE TABLE `instance_uom` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_user_group_certificate_map` */


CREATE TABLE `instance_user_group_certificate_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `backToPage` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_vehicle` */


CREATE TABLE `instance_vehicle` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `detailPage` int DEFAULT '0',
  `backToPage` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `instance_vendors` */


CREATE TABLE `instance_vendors` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `desc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `instanceGalleryID` int DEFAULT '0' COMMENT 'public module page map ID for the galler',
  `onclickEvent` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `onclickParams` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `onclickBtnText` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_videos` */


CREATE TABLE `instance_videos` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `instance_youtube_player` */


CREATE TABLE `instance_youtube_player` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `videoSource` tinyint(1) DEFAULT NULL COMMENT '0 - db table, 1 - user account, 2 - both',
  `youtubeSourceUser` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `thumbScroll` tinyint(1) DEFAULT NULL COMMENT '0 - x, 1 - y, 2 - no thumbs',
  `chromeless` tinyint(1) DEFAULT NULL COMMENT '0 - regular, 1 - chromeless',
  `youtubeClickSlideClassID` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `youtubeThumbQty` smallint DEFAULT NULL COMMENT 'how many thumb nails appear',
  `thumbPmpmID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `job_site_certificate_map` */


CREATE TABLE `job_site_certificate_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `jobSiteID` int DEFAULT NULL,
  `certificateID` int DEFAULT NULL,
  `issueDate` date DEFAULT NULL,
  `expiryDate` date DEFAULT NULL,
  `fileName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fileLibraryID` int DEFAULT NULL,
  `note` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `job_sites` */


CREATE TABLE `job_sites` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `address` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '0',
  `phone` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `parentJobSiteID` int DEFAULT '0' COMMENT 'job sites can exist within job sites, different rooms, carts, etc',
  `numberOfProcedureRooms` int DEFAULT '1',
  `comments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `lastAssessmentDate` date DEFAULT NULL,
  `fax` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `hoursOfOperations` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `clinicType` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `IHFLicenseNumber` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `country` int DEFAULT '0',
  `provState` int DEFAULT '0',
  `city` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `postalZip` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isContainer` tinyint DEFAULT '0',
  PRIMARY KEY (`priKeyID`),
  KEY `jobSites_isContainer_IDX` (`isContainer`),
  KEY `jobSites_parentJobSiteID_IDX` (`parentJobSiteID`),
  KEY `jobSites_priKeyID_IDX` (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `locations` */


CREATE TABLE `locations` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `storeCode` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `luName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `storeName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `corporateName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `owner` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `director` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `firstStore` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `directManagement` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `investmentClassification` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `postalCode` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `address` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `latitude` decimal(24,20) DEFAULT '0.00000000000000000000',
  `longitude` decimal(24,20) DEFAULT '0.00000000000000000000',
  `phoneNumber` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `fax` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `newSI` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `rn` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `openingDate` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `hoursOfOperation` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `regularHoliday` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `storeEmailAddress` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `city` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `googleMapLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '1',
  `markerColor` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `applicationID` int DEFAULT '0',
  `imageGalleryID` int DEFAULT '0',
  `galleryImageID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `login` */


CREATE TABLE `login` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `manufacturers` */


CREATE TABLE `manufacturers` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `description` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '0',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `module_benchmark` */


CREATE TABLE `module_benchmark` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `moduleID` int DEFAULT NULL,
  `moduleName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `execTime` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `instanceID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `module_record_ratings` */


CREATE TABLE `module_record_ratings` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `moduleID` int DEFAULT '0' COMMENT 'priKeyID of the module in the modules table',
  `moduleRecordPriKeyID` int DEFAULT '0' COMMENT 'priKeyID of the module record',
  `rating` tinyint DEFAULT '0' COMMENT 'the rating assigned by the user',
  `userIPAddress` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `modules` */


CREATE TABLE `modules` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `isTemplate` tinyint(1) DEFAULT '0' COMMENT '0 - add/edit module,\r\n1 - template module,\r\n2 - regular DOM, no special treatment\r\n3 - don''t load into a module frame, but setup the rest using the frame work... ex nav',
  `primaryPmpmAddEditID` int DEFAULT '0' COMMENT 'the pmpmID of the module we want to use to quick edit this module',
  `modInsPmpmID` int DEFAULT NULL COMMENT 'the module of of the add/edit form for the modules instance',
  `moduleName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `moduleHelp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `moduleDesc` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `includeFile` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `templateQueryFile` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `templateDOMFile` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `primaryAPIFile` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `jScript` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `jsObject` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `phpClass` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `runFunction` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `cssLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `miPrefix` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `moduleAlert` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `languageLabels` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `itemscope` tinyint(1) DEFAULT '0',
  `itemtype` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `importCSV` tinyint(1) DEFAULT '0',
  `hasCategory` tinyint(1) DEFAULT '0',
  `displayAMPElements` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `openGraphType` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '1',
  `defaultMiTag` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `tooltips` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `hasTags` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB AUTO_INCREMENT=18014 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `notification_public_user_group_map` */


CREATE TABLE `notification_public_user_group_map` (
  `prikeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserGroupID` int NOT NULL,
  `notificationID` int NOT NULL,
  PRIMARY KEY (`prikeyID`),
  KEY `notification_public_user_group_map_publicUserGroupID_IDX` (`publicUserGroupID`),
  KEY `notification_public_user_group_map_notificationID_IDX` (`notificationID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `notification_public_user_map` */


CREATE TABLE `notification_public_user_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserID` int NOT NULL,
  `notificationID` int NOT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `notification_public_user_map_publicUserID_IDX` (`publicUserID`),
  KEY `notification_public_user_map_notificationID_IDX` (`notificationID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `notifications` */


CREATE TABLE `notifications` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `applicationID` int DEFAULT '0',
  `companyID` int DEFAULT '0',
  `isActive` tinyint(1) DEFAULT '1',
  `openRecipientList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`priKeyID`),
  KEY `notifications_applicationID_IDX` (`applicationID`),
  KEY `notifications_companyID_IDX` (`companyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `option_category_product_map` */


CREATE TABLE `option_category_product_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `productOptionCategoryID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `order_products` */


CREATE TABLE `order_products` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT '0' COMMENT 'priKeyID of the product that this is a duplicate of',
  `productName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `sku` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `productCopy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `active` tinyint(1) DEFAULT '0',
  `price` double DEFAULT '0',
  `invtQty` int DEFAULT '0' COMMENT 'inventory quantity',
  `allowNegInvt` tinyint(1) DEFAULT '0',
  `negInvtMsg` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `prodLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `prodLen` double DEFAULT '0',
  `prodWidth` double DEFAULT '0',
  `prodHeight` double DEFAULT '0',
  `prodWeight` double DEFAULT '0',
  `ordinal` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`),
  KEY `priKeyID` (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `postal_code` */


CREATE TABLE `postal_code` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `postalCode` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`),
  KEY `blogName` (`postalCode`),
  KEY `postal_code_companyID_IDX` (`companyID`),
  KEY `postal_code_postalCode_IDX` (`postalCode`),
  FULLTEXT KEY `blogName_2` (`postalCode`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_categories` */


CREATE TABLE `product_categories` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `groupID` int DEFAULT NULL,
  `domainID` int DEFAULT '0',
  `ordinal` int DEFAULT NULL,
  `categoryName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `categoryDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `categoryCopy` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `imageGalleryID` int DEFAULT NULL,
  `galleryImageID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_category_map` */


CREATE TABLE `product_category_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `productCategoryID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `mapping id's` (`productID`,`productCategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_category_tree_settings` */


CREATE TABLE `product_category_tree_settings` (
  `priKeyID` int NOT NULL DEFAULT '0',
  `showProducts` tinyint(1) DEFAULT NULL,
  `onclickEvent` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_category_vendor_map` */


CREATE TABLE `product_category_vendor_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productCategoryID` int DEFAULT NULL,
  `vendorID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_certificate_map` */


CREATE TABLE `product_certificate_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `certificateID` int DEFAULT NULL,
  `issueDate` date DEFAULT NULL,
  `expiryDate` date DEFAULT NULL,
  `fileName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fileLibraryID` int DEFAULT NULL,
  `note` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `product_certification_log` */


CREATE TABLE `product_certification_log` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `testVoltage` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `maxUseVoltage` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `result` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `dateTested` date DEFAULT NULL,
  `expiryDate` date DEFAULT NULL,
  `serialNumber` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `comments` char(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `fileLibraryID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `product_features` */


CREATE TABLE `product_features` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `featureLabel` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `featureText` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `featureOrdinal` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_features2` */


CREATE TABLE `product_features2` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `featureLabel` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `featureText` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `featureOrdinal` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_gallery_map` */


CREATE TABLE `product_gallery_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `galleryID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  UNIQUE KEY `prodGalleryMap` (`productID`,`galleryID`),
  KEY `productID` (`productID`),
  KEY `gallery_map` (`galleryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_option_categories` */


CREATE TABLE `product_option_categories` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productOptionCategoryDesc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `optionGroupType` tinyint DEFAULT NULL COMMENT '0 - radio,  1 - check, 2 - select, 3 - list w/qty',
  `optionRequired` tinyint(1) DEFAULT NULL,
  `optionQtyField` tinyint(1) DEFAULT NULL COMMENT 'whether or not to display a qty field for product options',
  `allowInvOption` tinyint(1) DEFAULT NULL COMMENT 'allow it if its not in inventory',
  `notInvMessage` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ordinal` int DEFAULT '0',
  `productOptionCategoryDisplayName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_option_category_map` */


CREATE TABLE `product_option_category_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productOptionCategoryID` int DEFAULT NULL,
  `optionName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_option_category_value_map` */


CREATE TABLE `product_option_category_value_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `optionIDs` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'This will contain a list of values that map one or more options to a product to be used in the product_option_catgory_map',
  PRIMARY KEY (`priKeyID`),
  KEY `product_option_category_value_map_productID_IDX` (`productID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_price_level_user_group_map` */


CREATE TABLE `product_price_level_user_group_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserGroupID` int DEFAULT NULL,
  `productPriceLevelID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_price_levels` */


CREATE TABLE `product_price_levels` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `priceLevelDesc` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `levelPercentage` smallint DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_serial_number_map` */


CREATE TABLE `product_serial_number_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT NULL,
  `jobSiteID` int DEFAULT NULL,
  `manufactureDate` date DEFAULT NULL,
  `timesCertified` int DEFAULT '0',
  `lastDateTested` date DEFAULT NULL,
  `lastTestResult` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lastTestComment` char(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '1',
  `expiryDate` date DEFAULT NULL,
  `batchNumber` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`),
  KEY `mapping id's` (`productID`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `product_subcategories_map` */


CREATE TABLE `product_subcategories_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `prodCatID` int DEFAULT NULL,
  `prodSubCatID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_tax_map` */


CREATE TABLE `product_tax_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `taxID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `product_vendor_map` */


CREATE TABLE `product_vendor_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `productID` int DEFAULT NULL,
  `vendorID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `products` */


CREATE TABLE `products` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `sku` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `productCopy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `isActive` tinyint(1) DEFAULT '1',
  `galleryImageID` int DEFAULT '0',
  `imageGalleryID` int DEFAULT '0',
  `subscriptionPrice` double DEFAULT '0' COMMENT 'amount for recurring payments',
  `invtQty` int DEFAULT '0' COMMENT 'inventory quantity',
  `allowNegInvt` tinyint(1) DEFAULT '0',
  `negInvtMsg` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Out of Stock',
  `optionQty` tinyint(1) DEFAULT '0' COMMENT 'If this is true, then the options are all we use to determine the qty that we have. For example sizes of a product. The sizes are the product itself.',
  `prodLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `prodLen` double DEFAULT '0',
  `prodWidth` double DEFAULT '0',
  `prodHeight` double DEFAULT '0',
  `prodWeight` double DEFAULT '0',
  `isSubscription` tinyint(1) DEFAULT '0' COMMENT 'If a product is a subscription, it uses a different paypal function. We cannot pass subscription and non-subscription items through the checkout at the same time, so they generally required two different check out flows.',
  `trialBillingFrequency` smallint DEFAULT NULL COMMENT 'paypal TRIALBILLINGFREQUENCY',
  `trialBillingPeriod` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `billingPeriod` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `billingFrequency` smallint DEFAULT NULL COMMENT 'paypal BILLINGFREQUENCY',
  `subscriptionPlanID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `hasShipping` tinyint(1) DEFAULT '0' COMMENT '1 - has shipping, 0 no shipping. Can be used for virtual products as well',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `moq` int DEFAULT '1',
  `shippingNotes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `cost` double DEFAULT '0',
  `price` double DEFAULT '0',
  `isSerialized` tinyint(1) DEFAULT '0',
  `defaultPrice` double DEFAULT '0',
  `companyID` int DEFAULT '0',
  `primaryInvLocationID` int DEFAULT '0' COMMENT 'jobSiteID for ecommerce to use inventory levels from',
  `domainID` int DEFAULT '1',
  `groupID` int DEFAULT '0',
  `uom` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `itemsPerUnit` int DEFAULT '1',
  `isStripeProduct` tinyint DEFAULT '0',
  `stripePriceID` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
  `stripeProductID` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
  `hasProductOptions` tinyint(1) DEFAULT '0',
  `isSystemGenerated` tinyint(1) DEFAULT '0' COMMENT 'This field is used on product options and it is set to 1 for product options that get generated by PRISM automatically not the ones we link to an exisiting product',
  PRIMARY KEY (`priKeyID`),
  KEY `products_companyID_IDX` (`companyID`),
  KEY `products_name_IDX` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `products_rm` */


CREATE TABLE `products_rm` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `identifierCode` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `size` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `color` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `composition` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `unitDimensions` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `netWeight` double DEFAULT '0',
  `grossWeight` double DEFAULT '0',
  `brand` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `conformance` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `manufacturer` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `oemPartNum` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `class` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `cuffStyle` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `productID` int DEFAULT '0',
  `msrp` double DEFAULT '0',
  PRIMARY KEY (`priKeyID`),
  KEY `products_rm_name_IDX` (`productID`),
  KEY `products_rm_productID_IDX` (`productID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `properties` */


CREATE TABLE `properties` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `groupID` int DEFAULT '0',
  `domainID` int DEFAULT '1',
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `cityProv` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `isActive` tinyint(1) DEFAULT '0',
  `galleryImageID` int DEFAULT '0',
  `imageGalleryID` int DEFAULT '0',
  `price` double DEFAULT '0',
  `invtQty` int DEFAULT '0' COMMENT 'inventory quantity',
  `allowNegInvt` tinyint(1) DEFAULT '0',
  `negInvtMsg` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `optionQty` tinyint(1) DEFAULT '0' COMMENT 'If this is true, then the options are all we use to determine the qty that we have. For example sizes of a product. The sizes are the product itself.',
  `prodLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ordinal` int DEFAULT '0',
  `area` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `numOfBedrooms` int DEFAULT '0',
  `numOfGarage` int DEFAULT '0',
  `numOfBathrooms` int DEFAULT '0',
  `sku` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `completeAddress` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `latitude` decimal(24,20) DEFAULT NULL,
  `longitude` decimal(24,20) DEFAULT NULL,
  `contactEmail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `squareFoot` double DEFAULT '0',
  `contactPhone` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `contactName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `buildYear` double DEFAULT '0',
  `propertyPayType` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`),
  KEY `priKeyID` (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `property_city` */


CREATE TABLE `property_city` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `groupID` int DEFAULT NULL,
  `domainID` int DEFAULT '0',
  `ordinal` int DEFAULT NULL,
  `cityName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `imageGalleryID` int DEFAULT NULL,
  `galleryImageID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `property_city_map` */


CREATE TABLE `property_city_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `citiesID` int DEFAULT NULL,
  `propertyID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `mapping id's` (`citiesID`,`propertyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `property_type` */


CREATE TABLE `property_type` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `groupID` int DEFAULT NULL,
  `domainID` int DEFAULT '0',
  `ordinal` int DEFAULT NULL,
  `propertyType` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `propertyTypeDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `imageGalleryID` int DEFAULT NULL,
  `galleryImageID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `property_type_map` */


CREATE TABLE `property_type_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `propertyID` int DEFAULT NULL,
  `typeID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `mapping id's` (`propertyID`,`typeID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `provState_tax_map` */


CREATE TABLE `provState_tax_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `provStateID` int DEFAULT NULL,
  `countryID` int DEFAULT NULL,
  `taxID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `provState_tax_map_provStateID_IDX` (`provStateID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `prov_state` */


CREATE TABLE `prov_state` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `countryID` int DEFAULT NULL,
  `countryCode` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `provState` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `provStateCode` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ordinal` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `prov_state_provState_IDX` (`provState`)
) ENGINE=MyISAM AUTO_INCREMENT=4595 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `public_module_page_map` */


CREATE TABLE `public_module_page_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `instanceDescription` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '0',
  `pageID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `moduleID` int DEFAULT '0',
  `instanceID` int DEFAULT '0',
  `beforeAfter` tinyint(1) DEFAULT '0' COMMENT 'if its a standard item, if we dislpay it before or after the pcpy container\r\n\r\n0 - before\r\n1 - after',
  `headerText` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `className` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `instanceDisplayType` tinyint DEFAULT '0' COMMENT '0 - fade through\r\n1 - list\r\n2 - list with pagena\r\n3 - click slide',
  `expandContractMIs` tinyint(1) DEFAULT '0' COMMENT 'container class=expandWrap, expand button class=expandBtn, area to expand class=expandable. el with class=closeBtn will retract expandable. displayElements ex:  div.expandWrap,div.expandBtn,empName,/div,div.expandable,empBio,div.closeBtn,/div,/div,/div',
  `adminButtons` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'Module Header',
  `addEditPageID` int DEFAULT '0' COMMENT 'pageID of admin page where we add and edit records for this module',
  `listPageID` int DEFAULT '0' COMMENT 'Page that Save and Go button on addEditForm goes',
  `autoChange` tinyint(1) DEFAULT '0' COMMENT 'to auto fade\\slide through',
  `autoChangeDuration` smallint DEFAULT '0' COMMENT 'milliseconds on how long to to wait before changing',
  `autoChangeMouseOver` tinyint(1) DEFAULT '0' COMMENT '0 - Disable/Do Nothing \r\n1- When mouse over stop scrolling',
  `clickThumbs` tinyint(1) DEFAULT '0' COMMENT '0 - no thumb nails, 1 - thumb nails',
  `clickScroll` tinyint(1) DEFAULT '0' COMMENT 'direction for click slide 0 - x, 1 - y',
  `galleryThumbs` tinyint(1) DEFAULT '0' COMMENT '1 - images for thumbnails\r\n0/null - dots for thumbnails',
  `thumbItem` tinyint(1) DEFAULT '0' COMMENT 'number of thumbnails',
  `changeEffectDuration` float DEFAULT '0' COMMENT 'seconds with decimal places on how long the effect should take... 0.25, 0.5, 3.5 etc etc etc',
  `effectEasing` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `displayQty` tinyint DEFAULT '-1' COMMENT 'how many items to display for pagination and click slide, -1 is all',
  `paginateLinkQty` smallint DEFAULT '10' COMMENT 'How many pagination pages to show at a time.',
  `displayElements` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `showColumnTitles` tinyint DEFAULT '0' COMMENT 'Show titles as :before in display elements',
  `defURLString` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `overrideRequests` tinyint(1) DEFAULT '0' COMMENT 'instance will ignore other requests and always use defURLString',
  `isPrimaryPageModule` tinyint(1) DEFAULT '0' COMMENT '1 - change the page title to the specific primaryPageModuleTitleField',
  `primaryModulePage` int DEFAULT NULL COMMENT 'The priKeyID of the page this module will link to',
  `anchorText` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `recordQueryPmpmID` int DEFAULT '0' COMMENT 'the priKeyID of the public_module_page_map record that runs the instance to display one record of the module',
  `hasRatingRequireLogin` tinyint(1) DEFAULT '0' COMMENT 'require login to use rating system',
  `hasComments` tinyint(1) DEFAULT '0' COMMENT 'enables disqus comments',
  `disqusShortname` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `primaryPmpmAddEditID` int DEFAULT NULL COMMENT 'should override the primaryPmpmAddEditID from the modules table',
  `disMsg` tinyint(1) DEFAULT '1' COMMENT 'If the module should alert the user with the standard message when a record is added or edited',
  `galleryPmpmID` int DEFAULT NULL COMMENT 'the priKeyID of the public_module_page_map for this gallery to use',
  `imgPath` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'original',
  `defaultGalleryID` int DEFAULT NULL COMMENT 'If numeric that is the only gallery available for the user to change.',
  `fieldsToExport` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `displayElementsToExport` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `requiredEntry` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `recommendedEntry` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `sortOrder` tinyint(1) DEFAULT '0' COMMENT '0 - use default sorting on admin side, which is any level 1 module with an ordinal is sortable\r\n\r\n1 -  is sortable\r\n\r\n2 -  is not sortable',
  `miTag` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'div',
  `modalPreviewButton` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `previewModalPmpmID` int DEFAULT NULL COMMENT 'priKeyID of public_module_page_map for modal preview',
  `mfmcAdditionalClasses` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `mfmccAdditionalClasses` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `moduleFrameBtnTxt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `miAdditionalClasses` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `empQryDispMsg` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'No Results Found',
  `searchOptions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `addRecordIDToURL` tinyint DEFAULT '1',
  `lightSliderResponsive` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `qrcodeSize` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '2x4',
  PRIMARY KEY (`priKeyID`),
  KEY `moduleID` (`moduleID`),
  KEY `pageID` (`pageID`)
) ENGINE=InnoDB AUTO_INCREMENT=19007 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `public_pages` */


CREATE TABLE `public_pages` (
  `priKeyID` int NOT NULL AUTO_INCREMENT COMMENT 'negative - admin, -1 - 404 page, positive - public',
  `groupID` int DEFAULT '0' COMMENT 'group of records... example home page for the english/japanese/french would be in a group',
  `domainID` int DEFAULT '1' COMMENT 'the domain that this module belongs to, 0 - admin, 1 - primary/regular',
  `ordinal` int DEFAULT '0',
  `parentPageID` int DEFAULT '0',
  `pageLevel` int DEFAULT '1',
  `pageName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `pageTitle` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `navLabel` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `memberNavLabel` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `redirect301` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `pageCode` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `metaDesc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `linkPageID` int DEFAULT '0',
  `isMembersPage` tinyint(1) DEFAULT '0',
  `allMembers` tinyint(1) DEFAULT '1' COMMENT '1 - all members can view it, regardless of group, 0 - only selected group',
  `isTopStyle` tinyint(1) DEFAULT '0',
  `isSideStyle` tinyint(1) DEFAULT '0',
  `isBottomStyle` tinyint(1) DEFAULT '0',
  `navItemClass` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `navLinkClass` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isNullPage` tinyint(1) DEFAULT '0',
  `showSubNav` tinyint(1) DEFAULT '0',
  `subNavType` tinyint(1) DEFAULT '0' COMMENT '0 - top, 1 - side',
  `subNavCurrentLevel` tinyint(1) DEFAULT '0' COMMENT '0 - show the siblings of this page in a sub nav\r\n1 - show the children of this page in a sub nav',
  `textOnlyUpdate` tinyint(1) DEFAULT '0',
  `linkPageURL` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `nonMemberRedirect` int DEFAULT '1' COMMENT 'Page to redirect to if this is a members page and the user is not logged in.',
  `preUpdate` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `afterComplete` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `postUpdate` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `defPageURLParams` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `livePriKeyID` int DEFAULT NULL,
  `draftPriKeyID` int DEFAULT NULL,
  `isDraft` int DEFAULT '0',
  `anchorTag` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `pcClassName` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`),
  KEY `Page Names` (`pageName`),
  KEY `public_pages_domainID_IDX` (`domainID`),
  KEY `public_pages_groupID_IDX` (`groupID`),
  KEY `public_pages_parentPageID_IDX` (`parentPageID`)
) ENGINE=InnoDB AUTO_INCREMENT=19003 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `public_user_cookie_map` */


CREATE TABLE `public_user_cookie_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserID` int DEFAULT NULL,
  `cookie` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `timeStamp` timestamp NULL DEFAULT NULL,
  `userAgent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `public_user_group_map` */


CREATE TABLE `public_user_group_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserID` int DEFAULT NULL,
  `publicUserGroupID` int DEFAULT NULL,
  `companyID` int DEFAULT '0' COMMENT 'which company they have this role at. 0 for all',
  PRIMARY KEY (`priKeyID`),
  KEY `public_user_group_map_publicUserID_IDX` (`publicUserID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `public_user_group_page_map` */


CREATE TABLE `public_user_group_page_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserGroupID` int DEFAULT NULL,
  `pageID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=1727 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `public_user_groups` */


CREATE TABLE `public_user_groups` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `groupDesc` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `loginPageID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `groupCopy` longblob,
  `ordinal` int DEFAULT '0' COMMENT 'higher number = lower privilege/priority',
  `applicationID` int DEFAULT NULL COMMENT 'which application (cms_settings) this group is associated with',
  `isGeneralUserGroup` tinyint(1) DEFAULT '0' COMMENT 'a general user group that we need to have for every new app. All accounts added for an application will be added to this user group by default ',
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `public_user_job_site_map` */


CREATE TABLE `public_user_job_site_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserID` int DEFAULT NULL,
  `jobSiteID` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;

/*Table structure for table `public_user_reset_pass_token_map` */


CREATE TABLE `public_user_reset_pass_token_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserID` int DEFAULT NULL,
  `token` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `timeStamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `public_users` */


CREATE TABLE `public_users` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `loginPassword` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `firstName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lastName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fullName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `homePhone` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lastLogin` timestamp NULL DEFAULT NULL,
  `cellPhone` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `workPhone` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fax` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `city` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `provState` int DEFAULT NULL,
  `postalZip` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country` int DEFAULT NULL,
  `jobTitle` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `receiveUpdates` tinyint(1) DEFAULT '0',
  `notes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `isAdmin` tinyint(1) DEFAULT '0' COMMENT '0 - no , 1 - yes, 2 - super admin',
  `isActive` tinyint(1) DEFAULT '1',
  `website` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `userSignature` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `imageGalleryID` int DEFAULT NULL,
  `galleryImageID` int DEFAULT NULL,
  `isGuest` tinyint(1) DEFAULT NULL COMMENT 'If the user is a guest this will grant then only access to the cart. This account will be deleted after login',
  `memberSince` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sessionID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `dateOfBirth` date DEFAULT NULL,
  `organization` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `agreedToTermsAndConditions` tinyint(1) DEFAULT '0' COMMENT 'For the apps that need to track agreement to terms and conditions',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB AUTO_INCREMENT=789 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `public_users_favourite_products_map` */


CREATE TABLE `public_users_favourite_products_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserID` int DEFAULT '0',
  `productID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`),
  KEY `inputs_pro_favourites_productID_IDX` (`productID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `public_users_rm` */


CREATE TABLE `public_users_rm` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `userCompanyID` int DEFAULT '0',
  `workHours` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `recoverPatients` tinyint(1) DEFAULT '0',
  `withPatientsForOvernightStays` tinyint(1) DEFAULT '0',
  `administersAnesthesia` tinyint(1) DEFAULT '0',
  `monitorsPatientsIntraprocedure` tinyint(1) DEFAULT '0',
  `regulatoryBody` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `classification` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `supervisingPhysician` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `otherDutiesOrResponsibilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `publicUserID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `reports` */


CREATE TABLE `reports` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT NULL COMMENT 'Field responsible for judging which company this report is for',
  `jobSiteID` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `dateRangeStart` date DEFAULT NULL,
  `dateRangeEnd` date DEFAULT NULL,
  `selectedReportFields` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `tableHTML` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `galleryImageID` int DEFAULT NULL COMMENT 'This field is used for the logo on the first page of the report, if supplied the report will be generated with this custom logo, and not the default of the current companies logo.',
  `creatorCompanyID` int DEFAULT NULL COMMENT 'Field is responsible for holding the companyID of the user that created the report',
  `imageGalleryID` int DEFAULT '0',
  `sortByJobSite` int DEFAULT '0',
  `isActive` tinyint(1) DEFAULT '1',
  `reportDate` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `reportAddress` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `settings` */


CREATE TABLE `settings` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `googleAnalyticsCode` char(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `googleSiteVerification` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `metaWords` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `metaDesc` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `adminEmail` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `siteName` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `pageTransition` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `speedURL` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `googleDevKey` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `youtubeUser` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `shrinkScripts` tinyint(1) DEFAULT NULL COMMENT '0 - compresses and creates commonScriptsMini.js\r\n1 - doesn''t compress and creates commonScriptsMini.js\r\n2 - uses commonScriptsMini.js \r\n\r\n\r\nusing 1 for debugging, 0 to compress it, then 2 to use the compressed version',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `settings_blog_module` */


CREATE TABLE `settings_blog_module` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `blogPrevHeader` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `blogPrevCnt` tinyint DEFAULT NULL COMMENT 'how many blogs to preview',
  `blogPrevTrim` smallint DEFAULT NULL COMMENT 'how many characters to display in the blog preview',
  `landingArticleCnt` tinyint DEFAULT NULL COMMENT 'how many articles are displayed on the landing page for the blog',
  `landingArticleCharCnt` smallint DEFAULT NULL COMMENT 'How many characters to display for each blog article on the landing page',
  `landingArticleComments` tinyint(1) DEFAULT NULL COMMENT 'Toggle whether or not we display blog comments on the landing page',
  `landingHeader` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `landingDateFormat` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `landingTimeFormat` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `landingMoreBtnText` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `landingGalleryInstanceID` int DEFAULT NULL,
  `landingGalleryChildInstanceID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `settings_modules` */


CREATE TABLE `settings_modules` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `desc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `moduleName` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `instanceID` int DEFAULT '0' COMMENT 'instance ID for this setting',
  `paramName` varchar(120) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `paramType` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `paramValue` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `validateRules` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  PRIMARY KEY (`priKeyID`),
  KEY `settings_modules_instanceID_IDX` (`instanceID`),
  KEY `settings_modules_moduleName_IDX` (`moduleName`,`instanceID`)
) ENGINE=MyISAM AUTO_INCREMENT=195 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `settings_products_module` */


CREATE TABLE `settings_products_module` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `domainID` int DEFAULT '0',
  `viewCartRemoveOne` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `viewCartAddOne` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `viewCartRemoveFromCart` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `viewCartSetQty` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `dspCartPrefix` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `dspCartSuffix` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `baseMarkUp` double DEFAULT '0',
  `isFlatRate` tinyint(1) DEFAULT '0',
  `flatRateTax` tinyint(1) DEFAULT '0',
  `isCanadaPost` tinyint(1) DEFAULT '0',
  `isPurolator` tinyint(1) DEFAULT '0',
  `cartPageID` int DEFAULT '0' COMMENT 'cart page, used on our static elements such as topViewCart',
  `currencySymbol` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `priceCurrency` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'CAD' COMMENT 'ISO code of currency',
  `invocieCompanyName` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `invocieStreetAddress` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `invocieCity` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isManitoulin` tinyint(1) DEFAULT '0' COMMENT 'For Enabling Manitoulin Shipping Quotes',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `settings_store_orders` */


CREATE TABLE `settings_store_orders` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `devKey` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `devPass` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `liveKey` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `livePass` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `billingAccountDev` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `billingAccountLive` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `registeredAccount` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `getQuickOrFull` tinyint(1) DEFAULT NULL COMMENT '1- GetFullEstimate 0 - GetQuickEstimate',
  `senderStreetNameLive` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `defaultItemWeightLive` double(6,3) DEFAULT NULL COMMENT 'how many kg a product is if no weight is defined',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `settings_youtube_player` */


CREATE TABLE `settings_youtube_player` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `standard_contents` */


CREATE TABLE `standard_contents` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `footerContent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `headerContent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `store_order_product_map` */


CREATE TABLE `store_order_product_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `storeOrderID` int DEFAULT '0',
  `qty` int DEFAULT '0',
  `productID` int DEFAULT '0',
  `productName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `sku` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `productCopy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `active` tinyint(1) DEFAULT '0',
  `price` double NOT NULL DEFAULT '0',
  `invtQty` int DEFAULT '0' COMMENT 'inventory quantity',
  `allowNegInvt` tinyint(1) DEFAULT '0',
  `negInvtMsg` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `optionQty` tinyint(1) DEFAULT '0' COMMENT 'If this is true, then the options are all we use to determin',
  `prodLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `prodLen` double DEFAULT '0',
  `prodWidth` double DEFAULT '0',
  `prodHeight` double DEFAULT '0',
  `prodWeight` double DEFAULT '0',
  `ordinal` int DEFAULT '0',
  `primaryInvLocationID` int DEFAULT '0',
  `defaultPrice` double DEFAULT '0',
  `galleryImageID` int DEFAULT '0',
  `imageGalleryID` int DEFAULT '0',
  `expectedQty` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `store_order_product_option_map` */


CREATE TABLE `store_order_product_option_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `groupID` int DEFAULT '0',
  `domainID` int DEFAULT '1',
  `storeOrderProductMapID` int DEFAULT NULL COMMENT 'a mapping ID',
  `productID` int DEFAULT NULL COMMENT 'productID, so we  don''t have to query for this info',
  `productOptionID` int DEFAULT NULL COMMENT 'productOptionID, so we  don''t have to query for this info',
  `qty` int DEFAULT NULL,
  `productName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `sku` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `productCopy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `active` tinyint(1) DEFAULT '0',
  `price` double DEFAULT '0',
  `invtQty` int DEFAULT '0' COMMENT 'inventory quantity',
  `allowNegInvt` tinyint(1) DEFAULT '0',
  `negInvtMsg` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `optionQty` tinyint(1) DEFAULT '0' COMMENT 'If this is true, then the options are all we use to determin',
  `prodLink` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `prodLen` double DEFAULT '0',
  `prodWidth` double DEFAULT '0',
  `prodHeight` double DEFAULT '0',
  `prodWeight` double DEFAULT '0',
  `ordinal` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `store_orders` */


CREATE TABLE `store_orders` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserID` int DEFAULT '0',
  `orderDate` date DEFAULT NULL,
  `orderTime` time DEFAULT NULL,
  `paymentMethod` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `transactionID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `shipMethod` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `shippingTrackingNumber` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `shipName` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `shipStreet` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `shipCity` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `shipProvStateID` int DEFAULT '0',
  `shipPostalZip` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `shipCountryID` int DEFAULT '0',
  `primaryPhone` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `orderItemAmt` float DEFAULT '0',
  `orderShipAmt` float DEFAULT '0',
  `orderTaxAmt` float DEFAULT '0',
  `orderTotalAmt` float DEFAULT '0',
  `orderStatus` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'TBD',
  `lastUpdated` date DEFAULT NULL,
  `recurringPaymentID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `recurringIsActive` tinyint(1) DEFAULT '0',
  `companyID` int DEFAULT '0',
  `email` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `discountCode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `poNumber` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `notes` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `orderVendor` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `estArrivalDate` date DEFAULT NULL,
  `orderDestinationID` int DEFAULT '0' COMMENT 'Which location this order is made for',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `store_taxes` */


CREATE TABLE `store_taxes` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `taxDesc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `taxAmount` float DEFAULT NULL,
  `shipTax` tinyint(1) DEFAULT NULL,
  `ordinal` int DEFAULT '0',
  `stripeTaxID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`),
  KEY `store_taxes_shipTax_IDX` (`shipTax`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `store_vendors` */


CREATE TABLE `store_vendors` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `address` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `city` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `provState` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `postalZip` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `country` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `url` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `notes` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ordinal` int DEFAULT '0',
  `description` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `sub_module_map` */


CREATE TABLE `sub_module_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT COMMENT 'Mapping a module as a sub module to a primary module. Example a gallery to a product.',
  `primaryPmpmID` int DEFAULT '0',
  `subPmpmID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `subcategories_map` */


CREATE TABLE `subcategories_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT COMMENT 'Mapping a module as a sub module to a primary module. Example a gallery to a product.',
  `catID` int DEFAULT NULL,
  `subCatID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tag_module_record_map` */


CREATE TABLE `tag_module_record_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `tagID` int DEFAULT NULL,
  `recordID` int DEFAULT NULL,
  `moduleID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`),
  KEY `tag_module_record_map_recordID_IDX` (`recordID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `tags` */


CREATE TABLE `tags` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `applicationID` int DEFAULT NULL,
  `moduleID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `testimonials` */


CREATE TABLE `testimonials` (
  `priKeyID` int unsigned NOT NULL AUTO_INCREMENT,
  `testimonial` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `imageGalleryID` int DEFAULT NULL,
  `galleryImageID` int DEFAULT NULL,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `ordinal` int DEFAULT '0',
  `isActive` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `unit_of_measurements` */


CREATE TABLE `unit_of_measurements` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `isActive` tinyint(1) DEFAULT '0',
  `companyID` int DEFAULT '0',
  `applicationID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT;

/*Table structure for table `user_agent_client_map` */


CREATE TABLE `user_agent_client_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `publicUserID` int DEFAULT NULL,
  `clientID` int DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `user_group_certificate_map` */


CREATE TABLE `user_group_certificate_map` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `userGroupID` int DEFAULT NULL,
  `certificateID` int DEFAULT NULL,
  `issueDate` date DEFAULT NULL,
  `expiryDate` date DEFAULT NULL,
  `fileName` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fileLibraryID` int DEFAULT NULL,
  `note` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `companyID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

/*Table structure for table `videos` */


CREATE TABLE `videos` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `name` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `youtubeVidID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bannerTxt` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `imageGalleryID` int DEFAULT '0',
  `galleryImageID` int DEFAULT '0',
  `ordinal` int DEFAULT NULL,
  `videoFile1` int DEFAULT NULL,
  `videoFile2` int DEFAULT NULL,
  `bannerType` tinyint(1) DEFAULT NULL,
  `isActive` tinyint DEFAULT '1',
  `startTime` int DEFAULT '0',
  `endTime` int DEFAULT '0',
  `postDate` date DEFAULT NULL,
  `applicationID` int DEFAULT '0',
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `youtube_thumbs_temp` */


CREATE TABLE `youtube_thumbs_temp` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `videoTitle` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `videoDesc` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `videoID` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `videoURL` char(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

/*Table structure for table `youtube_videos` */


CREATE TABLE `youtube_videos` (
  `priKeyID` int NOT NULL AUTO_INCREMENT,
  `videoDesc` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `youtubeVidID` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`priKeyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

