/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `addresses` (
  `address_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `address_desc` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint(20) unsigned DEFAULT NULL,
  `address_region` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_street` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_building` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_floor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_addNotes` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_relatedId` bigint(20) unsigned DEFAULT NULL,
  `address_table` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_primary` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`address_id`) USING BTREE,
  KEY `addresses_country_id_foreign` (`country_id`) USING BTREE,
  CONSTRAINT `FK_addresses_1address_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `adjustment_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adjustment_dts` (
  `adjustmentDt_id` bigint(20) unsigned NOT NULL,
  `adjustment_id` bigint(20) unsigned DEFAULT NULL,
  `stockItem_id` bigint(20) unsigned DEFAULT NULL,
  `adjustmentDt_quantity` double DEFAULT NULL,
  `adjustmentDt_amount` double DEFAULT NULL,
  PRIMARY KEY (`adjustmentDt_id`) USING BTREE,
  KEY `adjustment_dts_adjustment_id_foreign` (`adjustment_id`) USING BTREE,
  KEY `adjustment_dts_stock_item_id_foreign` (`stockItem_id`),
  CONSTRAINT `adjustment_dts_adjustment_id_foreign` FOREIGN KEY (`adjustment_id`) REFERENCES `adjustments` (`adjustment_id`) ON DELETE CASCADE,
  CONSTRAINT `adjustment_dts_stock_item_id_foreign` FOREIGN KEY (`stockItem_id`) REFERENCES `stock_items` (`stockItem_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `adjustments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adjustments` (
  `adjustment_id` bigint(20) unsigned NOT NULL,
  `adjustment_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adjustment_date` datetime DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `currency_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `adjustment_remark` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`adjustment_id`) USING BTREE,
  KEY `adjustments_branch_id_foreign` (`branch_id`) USING BTREE,
  KEY `adjustments_currency_id_foreign` (`currency_id`) USING BTREE,
  KEY `adjustments_user_id_foreign` (`user_id`) USING BTREE,
  CONSTRAINT `adjustments_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`),
  CONSTRAINT `adjustments_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currency` (`CURRENCY_ID`),
  CONSTRAINT `adjustments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `banking_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banking_details` (
  `bankingDetail_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `bank_id` bigint(20) unsigned NOT NULL,
  `bankingDetail_desc` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bankingDetail_iban` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bankingDetail_account` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CURRENCY_ID` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`bankingDetail_id`) USING BTREE,
  KEY `banking_details_client_id_index` (`client_id`) USING BTREE,
  KEY `banking_details_supplier_id_index` (`supplier_id`) USING BTREE,
  KEY `banking_details_bank_id_index` (`bank_id`) USING BTREE,
  KEY `banking_details_currency_id_index` (`CURRENCY_ID`) USING BTREE,
  CONSTRAINT `banking_details_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`bank_id`) ON DELETE CASCADE,
  CONSTRAINT `banking_details_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`),
  CONSTRAINT `banking_details_currency_id_foreign` FOREIGN KEY (`CURRENCY_ID`) REFERENCES `currency` (`CURRENCY_ID`),
  CONSTRAINT `banking_details_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`supplier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `banks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banks` (
  `bank_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bank_code` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_altName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_id` bigint(20) unsigned NOT NULL,
  `bank_accountNo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_phone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`bank_id`) USING BTREE,
  KEY `banks_branch_id_index` (`branch_id`) USING BTREE,
  CONSTRAINT `banks_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `branches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `branches` (
  `branch_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `branch_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_id` bigint(20) unsigned DEFAULT NULL,
  `company_id` bigint(20) unsigned DEFAULT NULL,
  `contact_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`branch_id`) USING BTREE,
  KEY `branches_address_id_foreign` (`address_id`) USING BTREE,
  KEY `branches_company_id_foreign` (`company_id`) USING BTREE,
  KEY `branches_contact_id_foreign` (`contact_id`) USING BTREE,
  CONSTRAINT `branches_address_id_foreign` FOREIGN KEY (`address_id`) REFERENCES `addresses` (`address_id`),
  CONSTRAINT `branches_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`company_id`),
  CONSTRAINT `branches_contact_id_foreign` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clients` (
  `client_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_desc` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_id` bigint(20) unsigned NOT NULL,
  `client_vat` tinyint(1) DEFAULT '0',
  `client_tax` tinyint(1) DEFAULT '0',
  `client_redFlag` tinyint(1) DEFAULT '0',
  `client_abbreviation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_decimal` int(11) DEFAULT '1',
  PRIMARY KEY (`client_id`) USING BTREE,
  KEY `clients_branch_id_index` (`branch_id`) USING BTREE,
  CONSTRAINT `clients_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companies` (
  `company_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `company_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_desc` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_tax` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`company_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contacts` (
  `contact_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `contact_desc` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_mobile1` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_mobile2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_fax` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_email1` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_email2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_addNotes` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_relatedId` bigint(20) unsigned DEFAULT NULL,
  `contact_table` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_firstName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_lastName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_fatherName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_primary` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`contact_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `countries` (
  `country_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `country_code` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_altName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_enable` tinyint(1) DEFAULT '1',
  `country_phoneCode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`country_id`) USING BTREE,
  KEY `countries_currency_id_foreign` (`currency_id`) USING BTREE,
  CONSTRAINT `countries_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currency` (`CURRENCY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `curdt`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `curdt` (
  `Currency_code` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Curdt_date` date NOT NULL,
  `Curdt_rate` decimal(10,2) DEFAULT NULL,
  `Curdt_parity` decimal(10,4) DEFAULT NULL,
  `Synchronized` tinyint(1) NOT NULL DEFAULT '0',
  `Curdt_Posted` tinyint(1) NOT NULL DEFAULT '0',
  `curdt_id` bigint(20) unsigned DEFAULT NULL,
  `currency_id` bigint(20) unsigned DEFAULT NULL,
  `curdt_vatRate` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`Currency_code`,`Curdt_date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `currency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `currency` (
  `Currency_code` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Currency_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Currency_twos` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Currency_Plural` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Currency_nature` tinyint(1) DEFAULT '0',
  `CURRENCY_NAMEARAB` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Currency_countryaraB` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Currency_type` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Cur_DecimalName` varchar(31) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Cur_DecimalNameAra` varchar(31) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Synchronized` tinyint(1) DEFAULT '0',
  `Currency_Posted` tinyint(1) DEFAULT '0',
  `Currency_CreationDate` datetime DEFAULT NULL,
  `CURRENCY_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `Owner_Branch` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`CURRENCY_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `deliveries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `deliveries` (
  `delivery_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `quot_id` bigint(20) unsigned DEFAULT NULL,
  `delivery_deliveryNoteNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_receivedBy` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_date` datetime DEFAULT NULL,
  `delivery_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_boxNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`delivery_id`) USING BTREE,
  KEY `deliveries_quot_id_foreign` (`quot_id`) USING BTREE,
  KEY `deliveries_client_id_index` (`client_id`) USING BTREE,
  KEY `deliveries_user_id_foreign` (`user_id`) USING BTREE,
  CONSTRAINT `deliveries_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`),
  CONSTRAINT `deliveries_quot_id_foreign` FOREIGN KEY (`quot_id`) REFERENCES `quotations` (`quot_id`),
  CONSTRAINT `deliveries_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `delivery_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delivery_dts` (
  `deliverydt_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotProdItemDt_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemDt_sn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deliverydt_qty` bigint(20) DEFAULT NULL,
  `delivery_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`deliverydt_id`) USING BTREE,
  KEY `delivery_dts_quotproditemdt_id_foreign` (`quotProdItemDt_id`) USING BTREE,
  KEY `delivery_dts_delivery_id_foreign` (`delivery_id`) USING BTREE,
  CONSTRAINT `delivery_dts_delivery_id_foreign` FOREIGN KEY (`delivery_id`) REFERENCES `deliveries` (`delivery_id`) ON DELETE CASCADE,
  CONSTRAINT `delivery_dts_quotproditemdt_id_foreign` FOREIGN KEY (`quotProdItemDt_id`) REFERENCES `quot_prodItem_dts` (`quotProdItemDt_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `departments` (
  `department_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `department_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department_desc` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `department_parentId` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`department_id`) USING BTREE,
  KEY `departments_branch_id_index` (`branch_id`) USING BTREE,
  KEY `departments_department_parentid_index` (`department_parentId`) USING BTREE,
  CONSTRAINT `departments_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `modules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modules` (
  `module_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `module_code` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_desc` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_visible` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `processes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `processes` (
  `process_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `process_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `process_description` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unit_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`process_id`) USING BTREE,
  KEY `processes_unit_id_foreign` (`unit_id`) USING BTREE,
  CONSTRAINT `processes_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`unit_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `product_brands`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_brands` (
  `productBrand_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productBrand_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `productBrand_desc` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`productBrand_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `product_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_categories` (
  `productCategory_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productCategory_code` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `productCategory_desc` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unitScale_id` bigint(20) unsigned DEFAULT NULL,
  `productCategory_printDesc` tinyint(1) DEFAULT '0',
  `productCategory_isProduction` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`productCategory_id`) USING BTREE,
  KEY `product_categories_unitscale_id_index` (`unitScale_id`) USING BTREE,
  CONSTRAINT `product_categories_unitscale_id_foreign` FOREIGN KEY (`unitScale_id`) REFERENCES `unit_scales` (`unitScale_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `product_category_dt_brands`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_category_dt_brands` (
  `productCategoryDtBrand_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productCategoryDt_id` bigint(20) unsigned DEFAULT NULL,
  `productBrand_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`productCategoryDtBrand_id`) USING BTREE,
  KEY `product_category_dt_brands_productcategorydt_id_foreign` (`productCategoryDt_id`) USING BTREE,
  KEY `product_category_dt_brands_productbrand_id_foreign` (`productBrand_id`) USING BTREE,
  CONSTRAINT `product_category_dt_brands_productbrand_id_foreign` FOREIGN KEY (`productBrand_id`) REFERENCES `product_brands` (`productBrand_id`),
  CONSTRAINT `product_category_dt_brands_productcategorydt_id_foreign` FOREIGN KEY (`productCategoryDt_id`) REFERENCES `product_category_dts` (`productCategoryDt_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `product_category_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_category_dts` (
  `productCategoryDt_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productCategoryDt_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `productCategoryDt_desc` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `productCategoryDt_specs` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `productCategoryDt_thikness` double DEFAULT NULL,
  `productCategory_id` bigint(20) unsigned NOT NULL,
  `unit_id` bigint(20) unsigned DEFAULT NULL,
  `productBrand_id` bigint(20) unsigned DEFAULT NULL,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`productCategoryDt_id`) USING BTREE,
  KEY `product_category_dts_productcategory_id_index` (`productCategory_id`) USING BTREE,
  KEY `product_category_dts_unit_id_index` (`unit_id`) USING BTREE,
  KEY `product_category_dts_productbrand_id_index` (`productBrand_id`) USING BTREE,
  KEY `product_category_dts_productionitem_id_index` (`productionItem_id`) USING BTREE,
  CONSTRAINT `product_category_dts_productbrand_id_foreign` FOREIGN KEY (`productBrand_id`) REFERENCES `product_brands` (`productBrand_id`),
  CONSTRAINT `product_category_dts_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`) ON DELETE CASCADE,
  CONSTRAINT `product_category_dts_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`),
  CONSTRAINT `product_category_dts_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`unit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `product_category_processes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_category_processes` (
  `productCategoryProcess_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productCategory_id` bigint(20) unsigned NOT NULL,
  `process_id` bigint(20) unsigned DEFAULT NULL,
  `productCategoryProcess_sequence` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`productCategoryProcess_id`) USING BTREE,
  KEY `product_category_processes_productcategory_id_index` (`productCategory_id`) USING BTREE,
  KEY `product_category_processes_process_id_index` (`process_id`) USING BTREE,
  CONSTRAINT `product_category_processes_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`process_id`),
  CONSTRAINT `product_category_processes_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `production_item_dflt_processes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `production_item_dflt_processes` (
  `productionItemDfltProcess_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  `process_id` bigint(20) unsigned DEFAULT NULL,
  `productionItemDfltProcess_sequence` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`productionItemDfltProcess_id`) USING BTREE,
  KEY `production_item_dflt_processes_productionitem_id_index` (`productionItem_id`) USING BTREE,
  KEY `production_item_dflt_processes_process_id_index` (`process_id`) USING BTREE,
  CONSTRAINT `production_item_dflt_processes_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`process_id`),
  CONSTRAINT `production_item_dflt_processes_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `production_item_materials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `production_item_materials` (
  `productionItemMaterial_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  `productionItemMaterial_sequence` bigint(20) DEFAULT NULL,
  `productionItemMaterial_duplicate` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`productionItemMaterial_id`) USING BTREE,
  KEY `production_item_materials_productionitem_id_index` (`productionItem_id`) USING BTREE,
  KEY `production_item_materials_productcategory_id_index` (`productCategory_id`) USING BTREE,
  CONSTRAINT `production_item_materials_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `production_item_materials_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `production_item_materials_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `production_item_materials_dts` (
  `productionItemMaterialDt_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productionItemMaterial_id` bigint(20) unsigned DEFAULT NULL,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`productionItemMaterialDt_id`) USING BTREE,
  KEY `production_item_materials_dts_productionitemmaterial_id_index` (`productionItemMaterial_id`) USING BTREE,
  KEY `production_item_materials_dts_productionitem_id_index` (`productionItem_id`) USING BTREE,
  CONSTRAINT `production_item_materials_dts_productionitemmaterial_id_foreign` FOREIGN KEY (`productionItemMaterial_id`) REFERENCES `production_item_materials` (`productionItemMaterial_id`) ON DELETE CASCADE,
  CONSTRAINT `production_item_materials_dts_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `production_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `production_items` (
  `productionItem_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productionItem_code` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `productionItem_desc` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `productionItem_isPane` tinyint(1) NOT NULL DEFAULT '0',
  `productionItem_status` tinyint(1) NOT NULL DEFAULT '1',
  `productionItem_duplicate` tinyint(1) DEFAULT '0',
  `productionItem_descText` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`productionItem_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quot_prodCatDt_prcs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quot_prodCatDt_prcs` (
  `quotProdCatDtPrcs_id` bigint(20) unsigned NOT NULL,
  `quotProdCatDt_id` bigint(20) unsigned DEFAULT NULL,
  `process_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCatDtPrcs_priority` int(11) DEFAULT NULL,
  `quot_prodCatDt_checked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`quotProdCatDtPrcs_id`) USING BTREE,
  KEY `quot_prodcatdt_prcs_quotprodcatdt_id_foreign` (`quotProdCatDt_id`) USING BTREE,
  KEY `quot_prodcatdt_prcs_process_id_foreign` (`process_id`) USING BTREE,
  CONSTRAINT `quot_prodcatdt_prcs_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`process_id`),
  CONSTRAINT `quot_prodcatdt_prcs_quotprodcatdt_id_foreign` FOREIGN KEY (`quotProdCatDt_id`) REFERENCES `quot_prodCat_dts` (`quotProdCatDt_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quot_prodCat_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quot_prodCat_dts` (
  `quotProdCatDt_id` bigint(20) unsigned NOT NULL,
  `quotProdCat_id` bigint(20) unsigned DEFAULT NULL,
  `productCategoryDt_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCat_barcode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdCat_sequence` int(11) DEFAULT NULL,
  `quotProdCat_itemHeight` double DEFAULT NULL,
  `quotProdCat_itemWidth` double DEFAULT NULL,
  `quotProdCat_area` double DEFAULT NULL,
  `quotProdCat_costPerUnit` double DEFAULT NULL,
  `quotProdCat_costPerItem` double DEFAULT NULL,
  `quotProdItemDt_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCat_id` bigint(20) unsigned DEFAULT NULL,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCat_duplicate` tinyint(1) DEFAULT '0',
  `quotProdItemCatDt_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCat_isStepped` tinyint(1) DEFAULT '0',
  `quotProdCat_isShaped` tinyint(1) DEFAULT '0',
  `quotProdCat_shaped` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`quotProdCatDt_id`) USING BTREE,
  KEY `quot_prodcat_dts_quotprodcat_id_foreign` (`quotProdCat_id`) USING BTREE,
  KEY `quot_prodcat_dts_productcategorydt_id_foreign` (`productCategoryDt_id`) USING BTREE,
  KEY `quot_prodcat_dts_quotproditemdt_id_index` (`quotProdItemDt_id`) USING BTREE,
  KEY `quot_prodcat_dts_quotproditemcat_id_index` (`quotProdItemCat_id`) USING BTREE,
  KEY `quot_prodcat_dts_productcategory_id_index` (`productCategory_id`) USING BTREE,
  KEY `quot_prodcat_dts_quotproditemcatdt_id_foreign` (`quotProdItemCatDt_id`) USING BTREE,
  CONSTRAINT `quot_prodcat_dts_productcategorydt_id_foreign` FOREIGN KEY (`productCategoryDt_id`) REFERENCES `product_category_dts` (`productCategoryDt_id`),
  CONSTRAINT `quot_prodcat_dts_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `quot_prodcat_dts_quotprodcat_id_foreign` FOREIGN KEY (`quotProdCat_id`) REFERENCES `quot_prod_cats` (`quotProdCat_id`) ON DELETE CASCADE,
  CONSTRAINT `quot_prodcat_dts_quotproditemcatdt_id_foreign` FOREIGN KEY (`quotProdItemCatDt_id`) REFERENCES `quot_prodItem_cat_dts` (`quotProdItemCatDt_id`) ON DELETE CASCADE,
  CONSTRAINT `quot_prodcat_dts_quotproditemcat_id_foreign` FOREIGN KEY (`quotProdItemCat_id`) REFERENCES `quot_prodItem_cats` (`quotProdItemCat_id`) ON DELETE CASCADE,
  CONSTRAINT `quot_prodcat_dts_quotproditemdt_id_foreign` FOREIGN KEY (`quotProdItemDt_id`) REFERENCES `quot_prodItem_dts` (`quotProdItemDt_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quot_prodItem_cat_dt_processes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quot_prodItem_cat_dt_processes` (
  `quotProdItemCatDtProcess_id` bigint(20) unsigned NOT NULL,
  `quotProdItemCatDt_id` bigint(20) unsigned DEFAULT NULL,
  `process_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCatDtProcess_priority` int(11) DEFAULT NULL,
  `quotProdItemCatDtProcess_checked` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`quotProdItemCatDtProcess_id`) USING BTREE,
  KEY `quot_proditem_cat_dt_processes_quotproditemcatdt_id_foreign` (`quotProdItemCatDt_id`) USING BTREE,
  KEY `quot_proditem_cat_dt_processes_process_id_foreign` (`process_id`) USING BTREE,
  CONSTRAINT `quot_proditem_cat_dt_processes_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`process_id`),
  CONSTRAINT `quot_proditem_cat_dt_processes_quotproditemcatdt_id_foreign` FOREIGN KEY (`quotProdItemCatDt_id`) REFERENCES `quot_prodItem_cat_dts` (`quotProdItemCatDt_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quot_prodItem_cat_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quot_prodItem_cat_dts` (
  `quotProdItemCatDt_id` bigint(20) unsigned NOT NULL,
  `quotProdItemCat_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItem_id` bigint(20) unsigned DEFAULT NULL,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  `productCategoryDt_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCatDt_duplicate` tinyint(1) DEFAULT '0',
  `quotProdItemCatDt_isStepped` tinyint(1) DEFAULT '0',
  `quotProdItemCatDt_isShaped` tinyint(1) DEFAULT '0',
  `quotProdItemCatDt_shaped` text COLLATE utf8mb4_unicode_ci,
  `productionItemMaterial_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`quotProdItemCatDt_id`) USING BTREE,
  KEY `quot_proditem_cat_dts_quotproditemcat_id_foreign` (`quotProdItemCat_id`) USING BTREE,
  KEY `quot_proditem_cat_dts_quotproditem_id_foreign` (`quotProdItem_id`) USING BTREE,
  KEY `quot_proditem_cat_dts_productcategory_id_foreign` (`productCategory_id`) USING BTREE,
  KEY `quot_proditem_cat_dts_productcategorydt_id_foreign` (`productCategoryDt_id`) USING BTREE,
  KEY `quot_proditem_cat_dts_productionitemmaterial_id_index` (`productionItemMaterial_id`) USING BTREE,
  CONSTRAINT `quot_proditem_cat_dts_productcategorydt_id_foreign` FOREIGN KEY (`productCategoryDt_id`) REFERENCES `product_category_dts` (`productCategoryDt_id`),
  CONSTRAINT `quot_proditem_cat_dts_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `quot_proditem_cat_dts_productionitemmaterial_id_foreign` FOREIGN KEY (`productionItemMaterial_id`) REFERENCES `production_item_materials` (`productionItemMaterial_id`),
  CONSTRAINT `quot_proditem_cat_dts_quotproditemcat_id_foreign` FOREIGN KEY (`quotProdItemCat_id`) REFERENCES `quot_prodItem_cats` (`quotProdItemCat_id`) ON DELETE CASCADE,
  CONSTRAINT `quot_proditem_cat_dts_quotproditem_id_foreign` FOREIGN KEY (`quotProdItem_id`) REFERENCES `quot_prodItems` (`quotProdItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quot_prodItem_cats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quot_prodItem_cats` (
  `quotProdItemCat_id` bigint(20) unsigned NOT NULL,
  `quotProdItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCat_desc` text COLLATE utf8mb4_unicode_ci,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  `productCategoryDt_id` bigint(20) unsigned DEFAULT NULL,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCat_duplicate` tinyint(1) DEFAULT '0',
  `productionItemMaterial_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`quotProdItemCat_id`) USING BTREE,
  KEY `quot_proditem_cats_quotproditem_id_foreign` (`quotProdItem_id`) USING BTREE,
  KEY `quot_proditem_cats_productcategory_id_foreign` (`productCategory_id`) USING BTREE,
  KEY `quot_proditem_cats_productcategorydt_id_foreign` (`productCategoryDt_id`) USING BTREE,
  KEY `quot_proditem_cats_productionitem_id_index` (`productionItem_id`) USING BTREE,
  CONSTRAINT `quot_proditem_cats_productcategorydt_id_foreign` FOREIGN KEY (`productCategoryDt_id`) REFERENCES `product_category_dts` (`productCategoryDt_id`),
  CONSTRAINT `quot_proditem_cats_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `quot_proditem_cats_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`),
  CONSTRAINT `quot_proditem_cats_quotproditem_id_foreign` FOREIGN KEY (`quotProdItem_id`) REFERENCES `quot_prodItems` (`quotProdItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quot_prodItem_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quot_prodItem_dts` (
  `quotProdItemDt_id` bigint(20) unsigned NOT NULL,
  `quotProdItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemDt_sequence` int(11) DEFAULT NULL,
  `quotProdItemDt_code` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdItemDt_quantity` double DEFAULT NULL,
  `quotProdItemDt_height` double DEFAULT NULL,
  `quotProdItemDt_width` double DEFAULT NULL,
  `quotProdItemDt_area` double DEFAULT NULL,
  `quotProdItemDt_price` double DEFAULT NULL,
  `quotProdItemDt_total` double DEFAULT NULL,
  `quotProdItemDt_isShaped` tinyint(1) DEFAULT '0',
  `quotProdItemDt_isStepped` tinyint(1) DEFAULT '0',
  `quotProdItemDt_shaped` text COLLATE utf8mb4_unicode_ci,
  `quotProdItemDt_salesQty` bigint(20) DEFAULT NULL,
  `quotProdItemDt_relatedId` bigint(20) DEFAULT NULL,
  `quotProdItemDt_areaPerUnit` double DEFAULT NULL,
  `quotProdItemDt_sn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdItemDt_deliveryQty` bigint(20) DEFAULT '0',
  `quotProdItemDt_shapedHeight` double DEFAULT NULL,
  `quotProdItemDt_shapedWidth` double DEFAULT NULL,
  `quotProdItemDt_changePrice` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`quotProdItemDt_id`) USING BTREE,
  KEY `quot_proditem_dts_quotproditem_id_foreign` (`quotProdItem_id`) USING BTREE,
  CONSTRAINT `quot_proditem_dts_quotproditem_id_foreign` FOREIGN KEY (`quotProdItem_id`) REFERENCES `quot_prodItems` (`quotProdItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quot_prodItems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quot_prodItems` (
  `quotProdItem_id` bigint(20) unsigned NOT NULL,
  `quot_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItem_title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdItem_desc` text COLLATE utf8mb4_unicode_ci,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItem_price` double DEFAULT NULL,
  `status_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItem_salesOrderNo` bigint(20) DEFAULT NULL,
  `quotProdItem_invoiceNo` bigint(20) DEFAULT NULL,
  `quotProdItem_deliveryDate` datetime DEFAULT NULL,
  `quotProdItem_salesOrderDate` datetime DEFAULT NULL,
  `quotProdItem_poNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdItem_productionOrderNo` bigint(20) DEFAULT NULL,
  `quotProdItem_relatedId` bigint(20) DEFAULT NULL,
  `quotProdItem_salesQty` bigint(20) DEFAULT NULL,
  `quotProdItem_qty` double DEFAULT NULL,
  `quotProdItem_deliveryQty` bigint(20) NOT NULL DEFAULT '0',
  `quotProdItem_deliveryCount` bigint(20) NOT NULL DEFAULT '0',
  `quotProdItem_completed` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`quotProdItem_id`) USING BTREE,
  KEY `quot_proditems_quot_id_foreign` (`quot_id`) USING BTREE,
  KEY `quot_proditems_productionitem_id_foreign` (`productionItem_id`) USING BTREE,
  KEY `quot_proditems_status_id_foreign` (`status_id`) USING BTREE,
  CONSTRAINT `quot_proditems_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`),
  CONSTRAINT `quot_proditems_quot_id_foreign` FOREIGN KEY (`quot_id`) REFERENCES `quotations` (`quot_id`) ON DELETE CASCADE,
  CONSTRAINT `quot_proditems_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quot_prod_cats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quot_prod_cats` (
  `quotProdCat_id` bigint(20) unsigned NOT NULL,
  `quotProdItemDt_id` bigint(20) unsigned DEFAULT NULL,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCat_shape` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdCat_reference` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdCat_itemReference` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`quotProdCat_id`) USING BTREE,
  KEY `quot_prod_cats_quotproditemdt_id_foreign` (`quotProdItemDt_id`) USING BTREE,
  KEY `quot_prod_cats_productcategory_id_foreign` (`productCategory_id`) USING BTREE,
  KEY `quot_prod_cats_productionitem_id_index` (`productionItem_id`) USING BTREE,
  CONSTRAINT `quot_prod_cats_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `quot_prod_cats_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`),
  CONSTRAINT `quot_prod_cats_quotproditemdt_id_foreign` FOREIGN KEY (`quotProdItemDt_id`) REFERENCES `quot_prodItem_dts` (`quotProdItemDt_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quot_prod_item_processes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quot_prod_item_processes` (
  `quotProdItemProcess_id` bigint(20) unsigned NOT NULL,
  `quotProdItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCat_id` bigint(20) unsigned DEFAULT NULL,
  `process_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemProcess_priority` int(11) DEFAULT NULL,
  `quotProdItemProcess_checked` tinyint(1) DEFAULT '0',
  `quotProdItemProcess_note` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`quotProdItemProcess_id`) USING BTREE,
  KEY `quot_prod_item_processes_quotproditem_id_index` (`quotProdItem_id`) USING BTREE,
  KEY `quot_prod_item_processes_quotproditemcat_id_index` (`quotProdItemCat_id`) USING BTREE,
  KEY `quot_prod_item_processes_process_id_index` (`process_id`) USING BTREE,
  CONSTRAINT `quot_prod_item_processes_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`process_id`),
  CONSTRAINT `quot_prod_item_processes_quotproditemcat_id_foreign` FOREIGN KEY (`quotProdItemCat_id`) REFERENCES `quot_prodItem_cats` (`quotProdItemCat_id`) ON DELETE CASCADE,
  CONSTRAINT `quot_prod_item_processes_quotproditem_id_foreign` FOREIGN KEY (`quotProdItem_id`) REFERENCES `quot_prodItems` (`quotProdItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quotations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quotations` (
  `quot_id` bigint(20) unsigned NOT NULL,
  `quot_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_date` datetime DEFAULT NULL,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `currency_id` bigint(20) unsigned DEFAULT NULL,
  `quot_subject` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_project` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_paymentTerms` text COLLATE utf8mb4_unicode_ci,
  `quot_remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_grossTotal` double DEFAULT NULL,
  `quot_discPer` double DEFAULT NULL,
  `quot_discAmount` double DEFAULT NULL,
  `quot_vatcPer` double DEFAULT NULL,
  `quot_vatcAmount` double DEFAULT NULL,
  `quot_netTotal` double DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `status_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `quot_attention` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotation_vat` tinyint(1) DEFAULT '0',
  `quotation_tax` tinyint(1) DEFAULT '0',
  `quotation_vatValue` double DEFAULT NULL,
  `quotation_taxValue` double DEFAULT NULL,
  `quotation_taxAmount` double DEFAULT NULL,
  `quot_minArea` double DEFAULT NULL,
  `quot_termsAndConditions` text COLLATE utf8mb4_unicode_ci,
  `quot_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_completed` tinyint(1) DEFAULT '0',
  `quot_completedDate` datetime DEFAULT NULL,
  `quot_salesOrderNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_invoiceNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_deliveryDate` datetime DEFAULT NULL,
  `quot_salesOrderDate` datetime DEFAULT NULL,
  `quot_poNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_productionOrderNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_editedQuotations` bigint(20) NOT NULL DEFAULT '0',
  `quot_partReference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_note` text COLLATE utf8mb4_unicode_ci,
  `user_approvedId` bigint(20) unsigned DEFAULT NULL,
  `quot_printLabel` tinyint(1) DEFAULT '0',
  `quot_sendEmail` bigint(20) DEFAULT '0',
  `quot_printReport` bigint(20) DEFAULT '0',
  `quot_approved` tinyint(3) unsigned DEFAULT '0',
  `quot_canceled` tinyint(1) DEFAULT '0',
  `quot_creditNote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`quot_id`) USING BTREE,
  KEY `quotations_branch_id_foreign` (`branch_id`) USING BTREE,
  KEY `quotations_status_id_foreign` (`status_id`) USING BTREE,
  KEY `quotations_user_id_foreign` (`user_id`) USING BTREE,
  KEY `quotations_client_id_index` (`client_id`) USING BTREE,
  KEY `quotations_currency_id_index` (`currency_id`) USING BTREE,
  KEY `quotations_user_approvedid_foreign` (`user_approvedId`) USING BTREE,
  CONSTRAINT `quotations_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`),
  CONSTRAINT `quotations_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`),
  CONSTRAINT `quotations_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currency` (`CURRENCY_ID`),
  CONSTRAINT `quotations_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`),
  CONSTRAINT `quotations_user_approvedid_foreign` FOREIGN KEY (`user_approvedId`) REFERENCES `users` (`id`),
  CONSTRAINT `quotations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `role_accesses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_accesses` (
  `roleaccess_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) unsigned NOT NULL,
  `roleaccess_formcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roleaccess_view` tinyint(1) NOT NULL DEFAULT '0',
  `roleaccess_insert` tinyint(1) NOT NULL DEFAULT '0',
  `roleaccess_update` tinyint(1) NOT NULL DEFAULT '0',
  `roleaccess_delete` tinyint(1) NOT NULL DEFAULT '0',
  `roleaccess_preview` tinyint(1) NOT NULL DEFAULT '0',
  `roleaccess_excel` tinyint(1) NOT NULL DEFAULT '0',
  `roleaccess_print` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`roleaccess_id`) USING BTREE,
  KEY `role_accesses_role_id_index` (`role_id`) USING BTREE,
  CONSTRAINT `role_accesses_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `role_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_navigation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `screens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `screens` (
  `screen_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `screen_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `screen_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `screen_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `screen_group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` bigint(20) unsigned NOT NULL,
  `screen_show` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`screen_id`) USING BTREE,
  KEY `screens_company_id_index` (`company_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sequences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sequences` (
  `sequence_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sequence_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sequence_reference` bigint(20) NOT NULL DEFAULT '0',
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `sequence_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`sequence_id`) USING BTREE,
  KEY `sequences_branch_id_foreign` (`branch_id`) USING BTREE,
  CONSTRAINT `sequences_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `setup_tables`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `setup_tables` (
  `setup_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `setup_table` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `setup_code` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `setup_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `setup_startDate` datetime DEFAULT NULL,
  `setup_endDate` datetime DEFAULT NULL,
  `branch_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `setup_memo` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`setup_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status` (
  `status_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status_code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_sequence` int(11) DEFAULT NULL,
  `status_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`status_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `stock_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stock_items` (
  `stockItem_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `stockItem_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stockItem_ref` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stockItem_desc` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stockItem_width` double DEFAULT NULL,
  `stockItem_height` double DEFAULT NULL,
  `stockItem_area` double DEFAULT NULL,
  `stockItem_weight` double DEFAULT NULL,
  `stockItem_costPerUnit` double DEFAULT NULL,
  `stockItem_perItem` double DEFAULT NULL,
  `stockItem_quantity` double DEFAULT NULL,
  `stockItem_totalCost` double DEFAULT NULL,
  `stockItem_status` tinyint(1) DEFAULT NULL,
  `supplier_id` bigint(20) unsigned DEFAULT NULL,
  `productCategoryDt_id` bigint(20) unsigned DEFAULT NULL,
  `unit_id` bigint(20) unsigned DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `currency_id` bigint(20) unsigned DEFAULT NULL,
  `stockItem_thickness` double DEFAULT NULL,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`stockItem_id`) USING BTREE,
  KEY `stock_items_supplier_id_index` (`supplier_id`) USING BTREE,
  KEY `stock_items_productcategorydt_id_index` (`productCategoryDt_id`) USING BTREE,
  KEY `stock_items_unit_id_index` (`unit_id`) USING BTREE,
  KEY `stock_items_branch_id_index` (`branch_id`) USING BTREE,
  KEY `stock_items_currency_id_index` (`currency_id`) USING BTREE,
  KEY `stock_items_productcategory_id_foreign` (`productCategory_id`) USING BTREE,
  CONSTRAINT `stock_items_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`),
  CONSTRAINT `stock_items_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currency` (`CURRENCY_ID`),
  CONSTRAINT `stock_items_productcategorydt_id_foreign` FOREIGN KEY (`productCategoryDt_id`) REFERENCES `product_category_dts` (`productCategoryDt_id`),
  CONSTRAINT `stock_items_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `stock_items_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`supplier_id`),
  CONSTRAINT `stock_items_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`unit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `suppliers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suppliers` (
  `supplier_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `supplier_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `supplier_desc` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`supplier_id`) USING BTREE,
  KEY `suppliers_branch_id_index` (`branch_id`) USING BTREE,
  CONSTRAINT `suppliers_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_adjustment_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_adjustment_dts` (
  `adjustmentDt_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `adjustment_id` bigint(20) unsigned DEFAULT NULL,
  `stockItem_id` bigint(20) unsigned DEFAULT NULL,
  `adjustmentDt_quantity` double DEFAULT NULL,
  `adjustmentDt_amount` double DEFAULT NULL,
  PRIMARY KEY (`adjustmentDt_id`) USING BTREE,
  KEY `temp_adjustment_dts_adjustment_id_foreign` (`adjustment_id`) USING BTREE,
  KEY `temp_adjustment_dts_stock_item_id_foreign` (`stockItem_id`) USING BTREE,
  CONSTRAINT `temp_adjustment_dts_adjustment_id_foreign` FOREIGN KEY (`adjustment_id`) REFERENCES `temp_adjustments` (`adjustment_id`) ON DELETE CASCADE,
  CONSTRAINT `temp_adjustment_dts_stock_item_id_foreign` FOREIGN KEY (`stockItem_id`) REFERENCES `stock_items` (`stockItem_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_adjustments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_adjustments` (
  `adjustment_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `adjustment_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adjustment_date` datetime DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `currency_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `adjustment_remark` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`adjustment_id`) USING BTREE,
  KEY `temp_adjustments_branch_id_foreign` (`branch_id`) USING BTREE,
  KEY `temp_adjustments_currency_id_foreign` (`currency_id`) USING BTREE,
  KEY `temp_adjustments_user_id_foreign` (`user_id`) USING BTREE,
  CONSTRAINT `temp_adjustments_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`),
  CONSTRAINT `temp_adjustments_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currency` (`CURRENCY_ID`),
  CONSTRAINT `temp_adjustments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quot_prodCatDt_prcs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quot_prodCatDt_prcs` (
  `quotProdCatDtPrcs_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotProdCatDt_id` bigint(20) unsigned DEFAULT NULL,
  `process_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCatDtPrcs_priority` int(11) DEFAULT NULL,
  `quot_prodCatDt_checked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`quotProdCatDtPrcs_id`) USING BTREE,
  KEY `temp_quot_prodcatdt_prcs_process_id_foreign` (`process_id`) USING BTREE,
  KEY `temp_quot_prodcatdt_prcs_quotprodcatdt_id_foreign` (`quotProdCatDt_id`) USING BTREE,
  CONSTRAINT `temp_quot_prodcatdt_prcs_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`process_id`),
  CONSTRAINT `temp_quot_prodcatdt_prcs_quotprodcatdt_id_foreign` FOREIGN KEY (`quotProdCatDt_id`) REFERENCES `temp_quot_prodCat_dts` (`quotProdCatDt_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quot_prodCat_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quot_prodCat_dts` (
  `quotProdCatDt_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotProdCat_id` bigint(20) unsigned DEFAULT NULL,
  `productCategoryDt_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCat_barcode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdCat_sequence` int(11) DEFAULT NULL,
  `quotProdCat_itemHeight` double DEFAULT NULL,
  `quotProdCat_itemWidth` double DEFAULT NULL,
  `quotProdCat_area` double DEFAULT NULL,
  `quotProdCat_costPerUnit` double DEFAULT NULL,
  `quotProdCat_costPerItem` double DEFAULT NULL,
  `quotProdItemDt_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCat_id` bigint(20) unsigned DEFAULT NULL,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCat_duplicate` tinyint(1) DEFAULT '0',
  `quotProdItemCatDt_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCat_isStepped` tinyint(1) DEFAULT '0',
  `quotProdCat_isShaped` tinyint(1) DEFAULT '0',
  `quotProdCat_shaped` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`quotProdCatDt_id`) USING BTREE,
  KEY `temp_quot_prodcat_dts_quotprodcat_id_foreign` (`quotProdCat_id`) USING BTREE,
  KEY `temp_quot_prodcat_dts_productcategorydt_id_foreign` (`productCategoryDt_id`) USING BTREE,
  KEY `temp_quot_prodcat_dts_quotproditemdt_id_index` (`quotProdItemDt_id`) USING BTREE,
  KEY `temp_quot_prodcat_dts_quotproditemcat_id_index` (`quotProdItemCat_id`) USING BTREE,
  KEY `temp_quot_prodcat_dts_productcategory_id_index` (`productCategory_id`) USING BTREE,
  KEY `temp_quot_prodcat_dts_quotproditemcatdt_id_foreign` (`quotProdItemCatDt_id`) USING BTREE,
  CONSTRAINT `temp_quot_prodcat_dts_productcategorydt_id_foreign` FOREIGN KEY (`productCategoryDt_id`) REFERENCES `product_category_dts` (`productCategoryDt_id`),
  CONSTRAINT `temp_quot_prodcat_dts_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `temp_quot_prodcat_dts_quotprodcat_id_foreign` FOREIGN KEY (`quotProdCat_id`) REFERENCES `temp_quot_prod_cats` (`quotProdCat_id`) ON DELETE CASCADE,
  CONSTRAINT `temp_quot_prodcat_dts_quotproditemcatdt_id_foreign` FOREIGN KEY (`quotProdItemCatDt_id`) REFERENCES `temp_quot_prodItem_cat_dts` (`quotProdItemCatDt_id`) ON DELETE CASCADE,
  CONSTRAINT `temp_quot_prodcat_dts_quotproditemcat_id_foreign` FOREIGN KEY (`quotProdItemCat_id`) REFERENCES `temp_quot_prodItem_cats` (`quotProdItemCat_id`) ON DELETE CASCADE,
  CONSTRAINT `temp_quot_prodcat_dts_quotproditemdt_id_foreign` FOREIGN KEY (`quotProdItemDt_id`) REFERENCES `temp_quot_prodItem_dts` (`quotProdItemDt_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quot_prodItem_cat_dt_processes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quot_prodItem_cat_dt_processes` (
  `quotProdItemCatDtProcess_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotProdItemCatDt_id` bigint(20) unsigned DEFAULT NULL,
  `process_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCatDtProcess_checked` tinyint(1) DEFAULT '0',
  `quotProdItemCatDtProcess_priority` int(11) DEFAULT NULL,
  PRIMARY KEY (`quotProdItemCatDtProcess_id`) USING BTREE,
  KEY `temp_quot_proditem_cat_dt_processes_quotproditemcatdt_id_foreign` (`quotProdItemCatDt_id`) USING BTREE,
  KEY `temp_quot_proditem_cat_dt_processes_process_id_foreign` (`process_id`) USING BTREE,
  CONSTRAINT `temp_quot_proditem_cat_dt_processes_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`process_id`),
  CONSTRAINT `temp_quot_proditem_cat_dt_processes_quotproditemcatdt_id_foreign` FOREIGN KEY (`quotProdItemCatDt_id`) REFERENCES `temp_quot_prodItem_cat_dts` (`quotProdItemCatDt_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quot_prodItem_cat_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quot_prodItem_cat_dts` (
  `quotProdItemCatDt_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotProdItemCat_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItem_id` bigint(20) unsigned DEFAULT NULL,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  `productCategoryDt_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCatDt_duplicate` tinyint(1) DEFAULT '0',
  `quotProdItemCatDt_isStepped` tinyint(1) DEFAULT '0',
  `quotProdItemCatDt_isShaped` tinyint(1) DEFAULT '0',
  `quotProdItemCatDt_shaped` text COLLATE utf8mb4_unicode_ci,
  `productionItemMaterial_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`quotProdItemCatDt_id`) USING BTREE,
  KEY `temp_quot_proditem_cat_dts_quotproditemcat_id_foreign` (`quotProdItemCat_id`) USING BTREE,
  KEY `temp_quot_proditem_cat_dts_quotproditem_id_foreign` (`quotProdItem_id`) USING BTREE,
  KEY `temp_quot_proditem_cat_dts_productcategory_id_foreign` (`productCategory_id`) USING BTREE,
  KEY `temp_quot_proditem_cat_dts_productcategorydt_id_foreign` (`productCategoryDt_id`) USING BTREE,
  KEY `temp_quot_proditem_cat_dts_productionitemmaterial_id_index` (`productionItemMaterial_id`) USING BTREE,
  CONSTRAINT `temp_quot_proditem_cat_dts_productcategorydt_id_foreign` FOREIGN KEY (`productCategoryDt_id`) REFERENCES `product_category_dts` (`productCategoryDt_id`),
  CONSTRAINT `temp_quot_proditem_cat_dts_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `temp_quot_proditem_cat_dts_productionitemmaterial_id_foreign` FOREIGN KEY (`productionItemMaterial_id`) REFERENCES `production_item_materials` (`productionItemMaterial_id`),
  CONSTRAINT `temp_quot_proditem_cat_dts_quotproditemcat_id_foreign` FOREIGN KEY (`quotProdItemCat_id`) REFERENCES `temp_quot_prodItem_cats` (`quotProdItemCat_id`) ON DELETE CASCADE,
  CONSTRAINT `temp_quot_proditem_cat_dts_quotproditem_id_foreign` FOREIGN KEY (`quotProdItem_id`) REFERENCES `temp_quot_prodItems` (`quotProdItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quot_prodItem_cats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quot_prodItem_cats` (
  `quotProdItemCat_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotProdItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCat_desc` text COLLATE utf8mb4_unicode_ci,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  `productCategoryDt_id` bigint(20) unsigned DEFAULT NULL,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCat_duplicate` tinyint(1) DEFAULT '0',
  `productionItemMaterial_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`quotProdItemCat_id`) USING BTREE,
  KEY `temp_quot_proditem_cats_quotproditem_id_foreign` (`quotProdItem_id`) USING BTREE,
  KEY `temp_quot_proditem_cats_productcategory_id_foreign` (`productCategory_id`) USING BTREE,
  KEY `temp_quot_proditem_cats_productcategorydt_id_foreign` (`productCategoryDt_id`) USING BTREE,
  KEY `temp_quot_proditem_cats_productionitem_id_index` (`productionItem_id`) USING BTREE,
  CONSTRAINT `temp_quot_proditem_cats_productcategorydt_id_foreign` FOREIGN KEY (`productCategoryDt_id`) REFERENCES `product_category_dts` (`productCategoryDt_id`),
  CONSTRAINT `temp_quot_proditem_cats_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `temp_quot_proditem_cats_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`),
  CONSTRAINT `temp_quot_proditem_cats_quotproditem_id_foreign` FOREIGN KEY (`quotProdItem_id`) REFERENCES `temp_quot_prodItems` (`quotProdItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quot_prodItem_dts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quot_prodItem_dts` (
  `quotProdItemDt_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotProdItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemDt_sequence` int(11) DEFAULT NULL,
  `quotProdItemDt_code` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdItemDt_quantity` double DEFAULT NULL,
  `quotProdItemDt_height` double DEFAULT NULL,
  `quotProdItemDt_width` double DEFAULT NULL,
  `quotProdItemDt_area` double DEFAULT NULL,
  `quotProdItemDt_price` double DEFAULT NULL,
  `quotProdItemDt_total` double DEFAULT NULL,
  `quotProdItemDt_isShaped` tinyint(1) DEFAULT '0',
  `quotProdItemDt_isStepped` tinyint(1) DEFAULT '0',
  `quotProdItemDt_shaped` text COLLATE utf8mb4_unicode_ci,
  `quotProdItemDt_salesQty` bigint(20) DEFAULT NULL,
  `quotProdItemDt_relatedId` bigint(20) DEFAULT NULL,
  `quotProdItemDt_areaPerUnit` double DEFAULT NULL,
  `quotProdItemDt_sn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdItemDt_deliveryQty` bigint(20) DEFAULT '0',
  `quotProdItemDt_shapedHeight` double DEFAULT NULL,
  `quotProdItemDt_shapedWidth` double DEFAULT NULL,
  `quotProdItemDt_changePrice` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`quotProdItemDt_id`) USING BTREE,
  KEY `temp_quot_proditem_dts_quotproditem_id_foreign` (`quotProdItem_id`) USING BTREE,
  CONSTRAINT `temp_quot_proditem_dts_quotproditem_id_foreign` FOREIGN KEY (`quotProdItem_id`) REFERENCES `temp_quot_prodItems` (`quotProdItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quot_prodItems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quot_prodItems` (
  `quotProdItem_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quot_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItem_title` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdItem_desc` text COLLATE utf8mb4_unicode_ci,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItem_price` double DEFAULT NULL,
  `status_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItem_salesOrderNo` bigint(20) DEFAULT NULL,
  `quotProdItem_invoiceNo` bigint(20) DEFAULT NULL,
  `quotProdItem_deliveryDate` datetime DEFAULT NULL,
  `quotProdItem_salesOrderDate` datetime DEFAULT NULL,
  `quotProdItem_poNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdItem_productionOrderNo` bigint(20) DEFAULT NULL,
  `quotProdItem_relatedId` bigint(20) DEFAULT NULL,
  `quotProdItem_salesQty` bigint(20) DEFAULT NULL,
  `quotProdItem_qty` double DEFAULT NULL,
  `quotProdItem_deliveryQty` bigint(20) NOT NULL DEFAULT '0',
  `quotProdItem_deliveryCount` bigint(20) NOT NULL DEFAULT '0',
  `quotProdItem_completed` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`quotProdItem_id`) USING BTREE,
  KEY `temp_quot_proditems_quot_id_foreign` (`quot_id`) USING BTREE,
  KEY `temp_quot_proditems_productionitem_id_foreign` (`productionItem_id`) USING BTREE,
  KEY `temp_quot_proditems_status_id_foreign` (`status_id`) USING BTREE,
  CONSTRAINT `temp_quot_proditems_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`),
  CONSTRAINT `temp_quot_proditems_quot_id_foreign` FOREIGN KEY (`quot_id`) REFERENCES `temp_quotations` (`quot_id`) ON DELETE CASCADE,
  CONSTRAINT `temp_quot_proditems_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quot_prod_cats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quot_prod_cats` (
  `quotProdCat_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotProdItemDt_id` bigint(20) unsigned DEFAULT NULL,
  `productCategory_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdCat_shape` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdCat_reference` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotProdCat_itemReference` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `productionItem_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`quotProdCat_id`) USING BTREE,
  KEY `temp_quot_prod_cats_quotproditemdt_id_foreign` (`quotProdItemDt_id`) USING BTREE,
  KEY `temp_quot_prod_cats_productcategory_id_foreign` (`productCategory_id`) USING BTREE,
  KEY `temp_quot_prod_cats_productionitem_id_index` (`productionItem_id`) USING BTREE,
  CONSTRAINT `temp_quot_prod_cats_productcategory_id_foreign` FOREIGN KEY (`productCategory_id`) REFERENCES `product_categories` (`productCategory_id`),
  CONSTRAINT `temp_quot_prod_cats_productionitem_id_foreign` FOREIGN KEY (`productionItem_id`) REFERENCES `production_items` (`productionItem_id`),
  CONSTRAINT `temp_quot_prod_cats_quotproditemdt_id_foreign` FOREIGN KEY (`quotProdItemDt_id`) REFERENCES `temp_quot_prodItem_dts` (`quotProdItemDt_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quot_prod_item_processes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quot_prod_item_processes` (
  `quotProdItemProcess_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotProdItem_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemCat_id` bigint(20) unsigned DEFAULT NULL,
  `process_id` bigint(20) unsigned DEFAULT NULL,
  `quotProdItemProcess_priority` int(11) DEFAULT NULL,
  `quotProdItemProcess_checked` tinyint(1) DEFAULT '0',
  `quotProdItemProcess_note` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`quotProdItemProcess_id`) USING BTREE,
  KEY `temp_quot_prod_item_processes_quotproditem_id_index` (`quotProdItem_id`) USING BTREE,
  KEY `temp_quot_prod_item_processes_quotproditemcat_id_index` (`quotProdItemCat_id`) USING BTREE,
  KEY `temp_quot_prod_item_processes_process_id_index` (`process_id`) USING BTREE,
  CONSTRAINT `temp_quot_prod_item_processes_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`process_id`),
  CONSTRAINT `temp_quot_prod_item_processes_quotproditemcat_id_foreign` FOREIGN KEY (`quotProdItemCat_id`) REFERENCES `temp_quot_prodItem_cats` (`quotProdItemCat_id`) ON DELETE CASCADE,
  CONSTRAINT `temp_quot_prod_item_processes_quotproditem_id_foreign` FOREIGN KEY (`quotProdItem_id`) REFERENCES `temp_quot_prodItems` (`quotProdItem_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci DELAY_KEY_WRITE=1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `temp_quotations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temp_quotations` (
  `quot_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quot_reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_date` datetime DEFAULT NULL,
  `client_id` bigint(20) unsigned DEFAULT NULL,
  `currency_id` bigint(20) unsigned DEFAULT NULL,
  `quot_subject` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_project` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_paymentTerms` text COLLATE utf8mb4_unicode_ci,
  `quot_remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_grossTotal` double DEFAULT NULL,
  `quot_discPer` double DEFAULT NULL,
  `quot_discAmount` double DEFAULT NULL,
  `quot_vatcPer` double DEFAULT NULL,
  `quot_vatcAmount` double DEFAULT NULL,
  `quot_netTotal` double DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `status_id` bigint(20) unsigned DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `quot_attention` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quotation_vat` tinyint(1) DEFAULT '0',
  `quotation_tax` tinyint(1) DEFAULT '0',
  `quotation_vatValue` double DEFAULT NULL,
  `quotation_taxValue` double DEFAULT NULL,
  `quotation_taxAmount` double DEFAULT NULL,
  `quot_minArea` double DEFAULT NULL,
  `quot_termsAndConditions` text COLLATE utf8mb4_unicode_ci,
  `quot_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_completed` tinyint(1) DEFAULT '0',
  `quot_completedDate` datetime DEFAULT NULL,
  `quot_salesOrderNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_invoiceNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_deliveryDate` datetime DEFAULT NULL,
  `quot_salesOrderDate` datetime DEFAULT NULL,
  `quot_poNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_productionOrderNo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_editedQuotations` bigint(20) NOT NULL DEFAULT '0',
  `quot_partReference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quot_note` text COLLATE utf8mb4_unicode_ci,
  `user_approvedId` bigint(20) unsigned DEFAULT NULL,
  `quot_printLabel` tinyint(1) DEFAULT '0',
  `quot_sendEmail` bigint(20) DEFAULT '0',
  `quot_printReport` bigint(20) DEFAULT '0',
  `quot_approved` tinyint(3) unsigned DEFAULT '0',
  `quot_canceled` tinyint(1) DEFAULT '0',
  `quot_creditNote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`quot_id`) USING BTREE,
  KEY `temp_quotations_branch_id_foreign` (`branch_id`) USING BTREE,
  KEY `temp_quotations_status_id_foreign` (`status_id`) USING BTREE,
  KEY `temp_quotations_user_id_foreign` (`user_id`) USING BTREE,
  KEY `temp_quotations_client_id_index` (`client_id`) USING BTREE,
  KEY `temp_quotations_currency_id_index` (`currency_id`) USING BTREE,
  KEY `temp_quotations_user_approvedid_foreign` (`user_approvedId`) USING BTREE,
  CONSTRAINT `temp_quotations_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`),
  CONSTRAINT `temp_quotations_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`),
  CONSTRAINT `temp_quotations_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currency` (`CURRENCY_ID`),
  CONSTRAINT `temp_quotations_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `status` (`status_id`),
  CONSTRAINT `temp_quotations_user_approvedid_foreign` FOREIGN KEY (`user_approvedId`) REFERENCES `users` (`id`),
  CONSTRAINT `temp_quotations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `unit_scales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit_scales` (
  `unitScale_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `unitScale_name` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unitScale_desc` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`unitScale_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `units`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `units` (
  `unit_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `unit_code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit_desc` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unitScale_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`unit_id`) USING BTREE,
  KEY `units_unitscale_id_foreign` (`unitScale_id`) USING BTREE,
  CONSTRAINT `units_unitscale_id_foreign` FOREIGN KEY (`unitScale_id`) REFERENCES `unit_scales` (`unitScale_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `user_accesses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_accesses` (
  `useraccess_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `useraccess_formcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `useraccess_view` tinyint(1) NOT NULL DEFAULT '0',
  `useraccess_insert` tinyint(1) NOT NULL DEFAULT '0',
  `useraccess_update` tinyint(1) NOT NULL DEFAULT '0',
  `useraccess_delete` tinyint(1) NOT NULL DEFAULT '0',
  `useraccess_preview` tinyint(1) NOT NULL DEFAULT '0',
  `useraccess_excel` tinyint(1) NOT NULL DEFAULT '0',
  `user_id` bigint(20) unsigned NOT NULL,
  `company_id` bigint(20) unsigned DEFAULT NULL,
  `useraccess_print` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`useraccess_id`) USING BTREE,
  KEY `user_accesses_user_id_index` (`user_id`) USING BTREE,
  KEY `user_accesses_company_id_foreign` (`company_id`) USING BTREE,
  CONSTRAINT `user_accesses_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`company_id`) ON DELETE CASCADE,
  CONSTRAINT `user_accesses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `user_companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_companies` (
  `userCompany_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `company_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`userCompany_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `user_company_branches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_company_branches` (
  `userCompanyBranch_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`userCompanyBranch_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `branch_id` bigint(20) DEFAULT NULL,
  `user_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_isPublic` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1);
INSERT INTO `migrations` VALUES (2,'2014_10_12_100000_create_password_resets_table',2);
INSERT INTO `migrations` VALUES (3,'2019_08_19_000000_create_failed_jobs_table',2);
INSERT INTO `migrations` VALUES (4,'2019_12_14_000001_create_personal_access_tokens_table',2);
INSERT INTO `migrations` VALUES (5,'2023_10_11_063717_create_currencies_table',3);
INSERT INTO `migrations` VALUES (6,'2023_10_11_064643_create_countries_table',4);
INSERT INTO `migrations` VALUES (7,'2023_10_11_064851_create_curdts_table',5);
INSERT INTO `migrations` VALUES (8,'2023_10_11_082307_add_currency_id_to_country',6);
INSERT INTO `migrations` VALUES (9,'2023_10_11_114227_create_currency_histories_table',7);
INSERT INTO `migrations` VALUES (10,'2023_10_11_124053_create_country_histories_table',8);
INSERT INTO `migrations` VALUES (11,'2023_10_12_114616_create__company',9);
INSERT INTO `migrations` VALUES (12,'2023_10_13_090025_create_company_histories_table',10);
INSERT INTO `migrations` VALUES (13,'2023_10_16_064147_create_processes_table',11);
INSERT INTO `migrations` VALUES (14,'2023_10_16_064202_create_processes_histories_table',11);
INSERT INTO `migrations` VALUES (15,'2023_10_16_073345_update_table_process_history_columns',12);
INSERT INTO `migrations` VALUES (16,'2023_10_16_073503_create_setups_table',13);
INSERT INTO `migrations` VALUES (17,'2023_10_16_0735033_create_setups_table',14);
INSERT INTO `migrations` VALUES (18,'2023_10_16_093933_create_addresses_table',15);
INSERT INTO `migrations` VALUES (19,'2023_10_17_061930_create_address_histories_table',16);
INSERT INTO `migrations` VALUES (20,'2023_10_17_064243_create_contacts_table',17);
INSERT INTO `migrations` VALUES (21,'2023_10_17_065346_create_contact_histories_table',18);
INSERT INTO `migrations` VALUES (22,'2023_10_17_071926_create_branches_table',19);
INSERT INTO `migrations` VALUES (23,'2023_10_17_074725_create_branch_histories_table',20);
INSERT INTO `migrations` VALUES (24,'2023_10_17_084938_create_user_companies_table',21);
INSERT INTO `migrations` VALUES (25,'2023_10_17_085728_create_user_company_histories_table',22);
INSERT INTO `migrations` VALUES (26,'2023_10_17_102907_create_user_company_branches_table',23);
INSERT INTO `migrations` VALUES (27,'2023_10_19_071939_create_unit_scales_table',24);
INSERT INTO `migrations` VALUES (28,'2023_10_19_072012_create_unit_scale_histories_table',24);
INSERT INTO `migrations` VALUES (29,'2023_10_19_084613_create_roles_table',25);
INSERT INTO `migrations` VALUES (30,'2023_10_19_084955_create_role_histories_table',25);
INSERT INTO `migrations` VALUES (31,'2023_10_19_092726_create_role_accesses_table',26);
INSERT INTO `migrations` VALUES (32,'2023_10_19_121327_create_units_table',27);
INSERT INTO `migrations` VALUES (33,'2023_10_19_121433_create_unit_histories_table',27);
INSERT INTO `migrations` VALUES (34,'2023_10_20_051521_create_screens_table',28);
INSERT INTO `migrations` VALUES (37,'2023_10_20_091748_create_product_brands_table',29);
INSERT INTO `migrations` VALUES (38,'2023_10_20_091839_create_product_brand_histories_table',29);
INSERT INTO `migrations` VALUES (39,'2023_10_23_065032_add_related_id_to_address',30);
INSERT INTO `migrations` VALUES (40,'2023_10_23_065759_add_related_id_to_address_history',31);
INSERT INTO `migrations` VALUES (41,'2023_10_23_094607_add_related_id_and_table_to_contact',32);
INSERT INTO `migrations` VALUES (42,'2023_10_23_094807_add_related_id_and_table_to_contact_history',32);
INSERT INTO `migrations` VALUES (43,'2023_10_23_095614_add_name_to_contqact_table',33);
INSERT INTO `migrations` VALUES (44,'2023_10_23_095912_add_name_to_contqact_table_history',33);
INSERT INTO `migrations` VALUES (46,'2023_10_23_121749_create_departments_table',34);
INSERT INTO `migrations` VALUES (47,'2023_10_23_123653_create_department_histories_table',34);
INSERT INTO `migrations` VALUES (48,'2023_10_24_060758_update_table_process_history_columns',35);
INSERT INTO `migrations` VALUES (49,'2023_10_24_060937_update_table_process_columns',36);
INSERT INTO `migrations` VALUES (50,'2023_10_24_090451_create_product_categories_table',37);
INSERT INTO `migrations` VALUES (51,'2023_10_24_092913_create_product_category_histories_table',37);
INSERT INTO `migrations` VALUES (52,'2023_10_25_063109_create_product_category_processes_table',38);
INSERT INTO `migrations` VALUES (54,'2023_10_25_064134_create_product_category_process_histories_table',39);
INSERT INTO `migrations` VALUES (55,'2023_10_25_101914_create_product_category_dts_table',40);
INSERT INTO `migrations` VALUES (57,'2023_10_25_102633_create_product_category_dt_histories_table',41);
INSERT INTO `migrations` VALUES (58,'2023_10_27_095425_create_clients_table',42);
INSERT INTO `migrations` VALUES (59,'2023_10_27_095708_create_client_histories_table',43);
INSERT INTO `migrations` VALUES (60,'2023_10_30_080435_create_banks_table',44);
INSERT INTO `migrations` VALUES (61,'2023_10_30_080449_create_bank_histories_table',44);
INSERT INTO `migrations` VALUES (62,'2023_10_30_093411_create_banking_detail_histories_table',45);
INSERT INTO `migrations` VALUES (63,'2023_10_30_094441_create_suppliers_table',45);
INSERT INTO `migrations` VALUES (64,'2023_10_30_095640_create_supplier_histories_table',45);
INSERT INTO `migrations` VALUES (65,'2023_10_30_095641_create_banking_details_table',45);
INSERT INTO `migrations` VALUES (66,'2023_11_01_110705_create_production_items_table',46);
INSERT INTO `migrations` VALUES (67,'2023_11_01_110726_create_production_item_histories_table',46);
INSERT INTO `migrations` VALUES (68,'2023_11_02_081159_create_production_item_materials_table',47);
INSERT INTO `migrations` VALUES (69,'2023_11_02_081239_create_production_item_material_histories_table',47);
INSERT INTO `migrations` VALUES (70,'2023_11_02_085059_create_production_item_dflt_processes_table',48);
INSERT INTO `migrations` VALUES (71,'2023_11_02_085119_create_production_item_dflt_process_histories_table',48);
INSERT INTO `migrations` VALUES (72,'2023_11_03_065237_create_stock_items_table',49);
INSERT INTO `migrations` VALUES (73,'2023_11_03_082559_create_stock_item_histories_table',49);
INSERT INTO `migrations` VALUES (74,'2023_11_07_080211_create_adjustments_table',50);
INSERT INTO `migrations` VALUES (75,'2023_11_07_080236_create_adjustment_dts_table',50);
INSERT INTO `migrations` VALUES (76,'2023_11_07_080250_create_adjustment_histories_table',50);
INSERT INTO `migrations` VALUES (77,'2023_11_07_080322_create_adjustment_dt_histories_table',50);
INSERT INTO `migrations` VALUES (78,'2023_11_07_080353_create_temp_adjustments_table',50);
INSERT INTO `migrations` VALUES (79,'2023_11_07_080407_create_temp_adjustment_dts_table',50);
INSERT INTO `migrations` VALUES (80,'2023_11_15_062756_create_statuses_table',51);
INSERT INTO `migrations` VALUES (81,'2023_11_15_065150_create_status_histories_table',51);
INSERT INTO `migrations` VALUES (82,'2023_11_15_072334_create_quotations_table',51);
INSERT INTO `migrations` VALUES (83,'2023_11_15_074916_create_quotation_histories_table',51);
INSERT INTO `migrations` VALUES (84,'2023_11_16_121212_create_quot_prod_items_table',51);
INSERT INTO `migrations` VALUES (85,'2023_11_16_121233_create_quot_prod_item_histories_table',51);
INSERT INTO `migrations` VALUES (86,'2023_11_17_101220_add_name_company_branch_to_table_users',51);
INSERT INTO `migrations` VALUES (87,'2023_11_17_105025_create_user_histories_table',51);
INSERT INTO `migrations` VALUES (88,'2023_11_20_071124_create_temp_quotations_table',51);
INSERT INTO `migrations` VALUES (89,'2023_11_21_090015_create_sequences_table',51);
INSERT INTO `migrations` VALUES (90,'2023_11_21_135304_create_temp_quot_prod_items_table',51);
INSERT INTO `migrations` VALUES (91,'2023_11_23_075738_create_quot_prod_item_cats_table',51);
INSERT INTO `migrations` VALUES (92,'2023_11_23_075758_create_quot_prod_item_cat_histories_table',51);
INSERT INTO `migrations` VALUES (93,'2023_11_23_080516_create_temp_quot_prod_item_cats_table',51);
INSERT INTO `migrations` VALUES (94,'2023_11_23_085057_create_user_accesses_table',51);
INSERT INTO `migrations` VALUES (95,'2023_11_23_090555_create_user_access_histories_table',51);
INSERT INTO `migrations` VALUES (96,'2023_11_23_090610_create_role_access_histories_table',51);
INSERT INTO `migrations` VALUES (97,'2023_11_24_094420_create_quot_prod_item_dts_table',51);
INSERT INTO `migrations` VALUES (98,'2023_11_24_094521_create_quot_prod_item_dt_histories_table',51);
INSERT INTO `migrations` VALUES (99,'2023_11_24_094546_create_temp_quot_prod_item_dts_table',51);
INSERT INTO `migrations` VALUES (100,'2023_11_24_120946_create_quot_prod_cats_table',51);
INSERT INTO `migrations` VALUES (101,'2023_11_24_120958_create_temp_quot_prod_cats_table',51);
INSERT INTO `migrations` VALUES (102,'2023_11_24_121009_create_quot_prod_cat_histories_table',51);
INSERT INTO `migrations` VALUES (103,'2023_11_24_124112_create_quot_prod_cat_dts_table',51);
INSERT INTO `migrations` VALUES (104,'2023_11_24_124125_create_temp_quot_prod_cat_dts_table',51);
INSERT INTO `migrations` VALUES (105,'2023_11_24_124135_create_quot_prod_cat_dt_histories_table',51);
INSERT INTO `migrations` VALUES (106,'2023_11_24_133334_create_quot_prod_cat_dt_prcs_table',51);
INSERT INTO `migrations` VALUES (107,'2023_11_24_133345_create_temp_quot_prod_cat_dt_prcs_table',51);
INSERT INTO `migrations` VALUES (108,'2023_11_24_133422_create_quot_prod_cat_dt_prcs_histories_table',51);
INSERT INTO `migrations` VALUES (109,'2023_11_27_080425_update_quotations_attention',51);
INSERT INTO `migrations` VALUES (110,'2023_11_27_080443_update_temp_quotations_attention',51);
INSERT INTO `migrations` VALUES (111,'2023_11_27_080456_update_quotations_attention_history',51);
INSERT INTO `migrations` VALUES (112,'2023_11_27_095923_update_setup_table_branch_id',51);
INSERT INTO `migrations` VALUES (113,'2023_11_27_104217_update_quot_prod_cat',51);
INSERT INTO `migrations` VALUES (114,'2023_11_27_104358_update_quot_prod_cat_temp',51);
INSERT INTO `migrations` VALUES (115,'2023_11_27_104411_update_quot_prod_cat_history',51);
INSERT INTO `migrations` VALUES (116,'2023_11_27_124059_update_setup_table_memo_field',51);
INSERT INTO `migrations` VALUES (117,'2023_11_27_133822_update_table_users_user_title',51);
INSERT INTO `migrations` VALUES (118,'2023_11_27_133949_update_table_users_user_title_history',51);
INSERT INTO `migrations` VALUES (119,'2023_11_28_073143_upodate_quot_prod_item_cat_production_items_id_original',51);
INSERT INTO `migrations` VALUES (120,'2023_11_28_073233_upodate_quot_prod_item_cat_production_items_id_temp',51);
INSERT INTO `migrations` VALUES (121,'2023_11_28_073250_upodate_quot_prod_item_cat_production_items_id_history',51);
INSERT INTO `migrations` VALUES (122,'2023_11_28_095618_update_production_item_materials',51);
INSERT INTO `migrations` VALUES (123,'2023_11_28_095630_update_production_item_materials_history',51);
INSERT INTO `migrations` VALUES (124,'2023_11_28_125513_update_quot_prod_cat_dt',51);
INSERT INTO `migrations` VALUES (125,'2023_11_28_125528_update_quot_prod_cat_dt_temp',51);
INSERT INTO `migrations` VALUES (126,'2023_11_28_125543_update_quot_prod_cat_dt_history',51);
INSERT INTO `migrations` VALUES (127,'2023_11_29_064635_update_quot_prod_cat_dt_product_category_id',52);
INSERT INTO `migrations` VALUES (128,'2023_11_29_064706_update_quot_prod_cat_dt_product_category_id_temp',52);
INSERT INTO `migrations` VALUES (129,'2023_11_29_064721_update_quot_prod_cat_dt_product_category_id_history',52);
INSERT INTO `migrations` VALUES (130,'2023_11_29_091640_update_quot_cat_dt_process',52);
INSERT INTO `migrations` VALUES (131,'2023_11_29_091701_temp_update_quot_cat_dt_process',52);
INSERT INTO `migrations` VALUES (132,'2023_11_29_091720_temp_update_quot_cat_dt_process_history',52);
INSERT INTO `migrations` VALUES (133,'2023_11_29_105728_update_quot_prod_cat_dt_history',52);
INSERT INTO `migrations` VALUES (134,'2023_11_30_055052_update_prod_item_cat_duplicate',52);
INSERT INTO `migrations` VALUES (135,'2023_11_30_055112_update_prod_item_cat_duplicate_history',52);
INSERT INTO `migrations` VALUES (136,'2023_11_30_055130_tempupdate_prod_item_cat_duplicate',52);
INSERT INTO `migrations` VALUES (137,'2023_11_30_064801_update_quot_prod_cat_dt',52);
INSERT INTO `migrations` VALUES (138,'2023_11_30_064945_update_quot_prod_cat_dt_temp',52);
INSERT INTO `migrations` VALUES (139,'2023_11_30_065005_update_quot_prod_cat_dt_history',52);
INSERT INTO `migrations` VALUES (140,'2023_11_30_075125_update_history_for_quot_prod_cat_dt_prcs',52);
INSERT INTO `migrations` VALUES (141,'2023_12_04_062506_update_clients_vat',53);
INSERT INTO `migrations` VALUES (142,'2023_12_04_062519_update_clients_vat_history',53);
INSERT INTO `migrations` VALUES (143,'2023_12_04_063415_update_quotation_vat_origin',53);
INSERT INTO `migrations` VALUES (144,'2023_12_04_063431_update_quotation_vat_temp',53);
INSERT INTO `migrations` VALUES (145,'2023_12_04_063452_update_quotation_vat_history',53);
INSERT INTO `migrations` VALUES (146,'2023_12_04_081146_update_quotation_vat_tax_fields',53);
INSERT INTO `migrations` VALUES (147,'2023_12_04_081203_update_quotation_vat_tax_fields_temp',53);
INSERT INTO `migrations` VALUES (148,'2023_12_04_081220_update_quotation_vat_tax_fields_history',53);
INSERT INTO `migrations` VALUES (149,'2023_12_04_085720_create_quot_prod_item_cat_dts_table',53);
INSERT INTO `migrations` VALUES (150,'2023_12_04_085741_create_temp_quot_prod_item_cat_dts_table',53);
INSERT INTO `migrations` VALUES (151,'2023_12_04_085754_create_quot_prod_item_cat_dt_histories_table',53);
INSERT INTO `migrations` VALUES (152,'2023_12_04_111746_update_quotations_tax_amount',53);
INSERT INTO `migrations` VALUES (153,'2023_12_04_111803_update_quotations_tax_amount_temp',53);
INSERT INTO `migrations` VALUES (154,'2023_12_04_111817_update_quotations_tax_amount_history',53);
INSERT INTO `migrations` VALUES (155,'2023_12_04_113047_create_quot_prod_item_cat_dt_processes_table',53);
INSERT INTO `migrations` VALUES (156,'2023_12_04_113104_create_temp_quot_prod_item_cat_dt_processes_table',53);
INSERT INTO `migrations` VALUES (157,'2023_12_04_113120_create_quot_prod_item_cat_dt_process_histories_table',53);
INSERT INTO `migrations` VALUES (158,'2023_12_06_085433_update_quotations_original',53);
INSERT INTO `migrations` VALUES (159,'2023_12_06_085533_update_quotations_temp',53);
INSERT INTO `migrations` VALUES (160,'2023_12_06_085548_update_quotations_history',53);
INSERT INTO `migrations` VALUES (161,'2023_12_06_091356_update_quot_prod_cat_dt',53);
INSERT INTO `migrations` VALUES (162,'2023_12_06_091608_update_quot_prod_cat_dt_temp',53);
INSERT INTO `migrations` VALUES (163,'2023_12_06_091623_update_quot_prod_cat_dt_history',53);
INSERT INTO `migrations` VALUES (164,'2023_12_06_125253_update_quot_prod_items',53);
INSERT INTO `migrations` VALUES (165,'2023_12_06_125308_update_quot_prod_items_temp',53);
INSERT INTO `migrations` VALUES (166,'2023_12_06_125322_update_quot_prod_items_history',53);
INSERT INTO `migrations` VALUES (167,'2023_12_08_084323_add_terms_and_conditions_to_quotations_table',54);
INSERT INTO `migrations` VALUES (168,'2023_12_08_084343_add_terms_and_conditions_to_quotations_temp_table',54);
INSERT INTO `migrations` VALUES (169,'2023_12_08_084358_add_terms_and_conditions_to_quotations_history_table',54);
INSERT INTO `migrations` VALUES (170,'2023_12_11_073221_update_table_quotations',55);
INSERT INTO `migrations` VALUES (171,'2023_12_11_073237_update_table_quotations_temp',55);
INSERT INTO `migrations` VALUES (172,'2023_12_11_073307_update_table_quotations_history',55);
INSERT INTO `migrations` VALUES (173,'2023_12_11_074124_update_quot_prod_item',55);
INSERT INTO `migrations` VALUES (174,'2023_12_11_074148_update_quot_prod_item_temp',55);
INSERT INTO `migrations` VALUES (175,'2023_12_11_074201_update_quot_prod_item_history',55);
INSERT INTO `migrations` VALUES (176,'2023_12_11_075545_update_product_category_table',55);
INSERT INTO `migrations` VALUES (177,'2023_12_11_075839_update_product_category_table_history',55);
INSERT INTO `migrations` VALUES (178,'2023_12_11_094848_update_clients',55);
INSERT INTO `migrations` VALUES (179,'2023_12_11_094920_update_clients_history',55);
INSERT INTO `migrations` VALUES (180,'2023_12_11_104549_update_quot_prod_item_dt',55);
INSERT INTO `migrations` VALUES (181,'2023_12_11_104604_update_quot_prod_item_dt_temp',55);
INSERT INTO `migrations` VALUES (182,'2023_12_11_104622_update_quot_prod_item_dt_history',55);
INSERT INTO `migrations` VALUES (183,'2023_12_13_063246_add_production_order_no_to_quot_prod_items',56);
INSERT INTO `migrations` VALUES (184,'2023_12_13_063306_add_production_order_no_to_quot_prod_items_temp',56);
INSERT INTO `migrations` VALUES (185,'2023_12_13_063330_add_production_order_no_to_quot_prod_items_history',56);
INSERT INTO `migrations` VALUES (186,'2023_12_13_080646_update_quot_prod_items',56);
INSERT INTO `migrations` VALUES (187,'2023_12_13_080735_update_quot_prod_items_temp',56);
INSERT INTO `migrations` VALUES (188,'2023_12_13_080800_update_quot_prod_items_history',56);
INSERT INTO `migrations` VALUES (189,'2023_12_13_081757_update_quot_prod_item_dt',56);
INSERT INTO `migrations` VALUES (190,'2023_12_13_081821_update_quot_prod_item_dt_temp',56);
INSERT INTO `migrations` VALUES (191,'2023_12_13_081835_update_quot_prod_item_dt_history',56);
INSERT INTO `migrations` VALUES (192,'2023_12_13_091707_add_is_production_to_production_category',56);
INSERT INTO `migrations` VALUES (193,'2023_12_13_091730_add_is_production_to_production_category_history',56);
INSERT INTO `migrations` VALUES (194,'2023_12_13_110818_update_quot_prod_item_dt',56);
INSERT INTO `migrations` VALUES (195,'2023_12_13_110831_update_quot_prod_item_dt_temp',56);
INSERT INTO `migrations` VALUES (196,'2023_12_13_111011_update_quot_prod_item_dt_history',56);
INSERT INTO `migrations` VALUES (197,'2023_12_13_132814_update_quot_prod_items',57);
INSERT INTO `migrations` VALUES (198,'2023_12_13_132828_update_quot_prod_items_temp',57);
INSERT INTO `migrations` VALUES (199,'2023_12_13_132839_update_quot_prod_items_history',57);
INSERT INTO `migrations` VALUES (200,'2023_12_15_065150_update_quot_prod_item_dt',57);
INSERT INTO `migrations` VALUES (201,'2023_12_15_065212_update_quot_prod_item_dt_temp',57);
INSERT INTO `migrations` VALUES (202,'2023_12_15_065234_update_quot_prod_item_dt_history',57);
INSERT INTO `migrations` VALUES (203,'2023_12_15_072537_create_quot_prod_item_processes_table',57);
INSERT INTO `migrations` VALUES (204,'2023_12_15_072554_create_quot_prod_item_process_histories_table',57);
INSERT INTO `migrations` VALUES (205,'2023_12_15_072615_create_temp_quot_prod_item_processes_table',57);
INSERT INTO `migrations` VALUES (206,'2023_12_18_073415_add_completed_and_completed_date_to_quotation',58);
INSERT INTO `migrations` VALUES (207,'2023_12_18_074057_add_completed_and_completed_date_to_quotation_history',58);
INSERT INTO `migrations` VALUES (208,'2023_12_18_074508_add_completed_and_completed_date_to_temp_quotation',58);
INSERT INTO `migrations` VALUES (209,'2023_12_18_133018_add_production_item_to_product_category_dt',58);
INSERT INTO `migrations` VALUES (210,'2023_12_18_133036_add_production_item_to_product_category_dt_history',58);
INSERT INTO `migrations` VALUES (211,'2023_12_19_105919_update_quotations_original',59);
INSERT INTO `migrations` VALUES (212,'2023_12_19_105940_update_quotations_temp',59);
INSERT INTO `migrations` VALUES (213,'2023_12_19_105954_update_quotations_history',59);
INSERT INTO `migrations` VALUES (214,'2023_12_20_122610_create_production_item_materials_table',59);
INSERT INTO `migrations` VALUES (215,'2023_12_20_122621_create_production_item_material_histories_table',59);
INSERT INTO `migrations` VALUES (216,'2023_12_21_060040_update_quot_prod_item_cat_dt_original',59);
INSERT INTO `migrations` VALUES (217,'2023_12_21_060100_update_quot_prod_item_cat_dt_temp',59);
INSERT INTO `migrations` VALUES (218,'2023_12_21_060135_update_quot_prod_item_cat_dt_history',59);
INSERT INTO `migrations` VALUES (219,'2023_12_21_075728_add_edited_quotations',60);
INSERT INTO `migrations` VALUES (220,'2023_12_21_075746_add_edited_quotations_temp',60);
INSERT INTO `migrations` VALUES (221,'2023_12_21_075800_add_edited_quotations_history',60);
INSERT INTO `migrations` VALUES (222,'2023_12_21_091126_update_quot_prod_item_cat_product_material',61);
INSERT INTO `migrations` VALUES (223,'2023_12_21_091154_update_quot_prod_item_cat_product_material_temp',61);
INSERT INTO `migrations` VALUES (224,'2023_12_21_091218_update_quot_prod_item_cat_product_material_history',61);
INSERT INTO `migrations` VALUES (225,'2023_12_21_124504_update_quotations_remark_to',62);
INSERT INTO `migrations` VALUES (226,'2023_12_21_124629_update_quotations_remark_to',62);
INSERT INTO `migrations` VALUES (227,'2023_12_21_124859_update_quotations_ref_part',62);
INSERT INTO `migrations` VALUES (228,'2023_12_21_131459_update_sequences_table',62);
INSERT INTO `migrations` VALUES (229,'2023_12_21_133946_update_quot_prod_item_process_note',62);
INSERT INTO `migrations` VALUES (230,'2023_12_21_134121_update_quot_prod_item_process_note_temp',62);
INSERT INTO `migrations` VALUES (231,'2023_12_21_134137_update_quot_prod_item_process_note_original',62);
INSERT INTO `migrations` VALUES (232,'2023_12_21_134929_update_quotations_note',62);
INSERT INTO `migrations` VALUES (233,'2023_12_21_135008_update_quotations_note',62);
INSERT INTO `migrations` VALUES (234,'2023_12_21_135043_update_quotations_note_history',62);
INSERT INTO `migrations` VALUES (235,'2023_12_22_061554_change_quot_reference_type',63);
INSERT INTO `migrations` VALUES (236,'2023_12_22_061610_change_quot_reference_type_temp',63);
INSERT INTO `migrations` VALUES (237,'2023_12_22_061626_change_quot_reference_type_original',63);
INSERT INTO `migrations` VALUES (238,'2023_12_22_064954_update_quotations_prod_sales_reference',63);
INSERT INTO `migrations` VALUES (239,'2023_12_22_065020_update_quotations_prod_sales_reference_temp',63);
INSERT INTO `migrations` VALUES (240,'2023_12_22_065034_update_quotations_prod_sales_reference_original',63);
INSERT INTO `migrations` VALUES (241,'2023_12_22_105616_update_quot_prod_item_dt_serial',64);
INSERT INTO `migrations` VALUES (242,'2023_12_22_105638_update_quot_prod_item_dt_serial_temp',64);
INSERT INTO `migrations` VALUES (243,'2023_12_22_105655_update_quot_prod_item_dt_serial_history',64);
INSERT INTO `migrations` VALUES (244,'2023_12_26_062450_create_deliveries_table',64);
INSERT INTO `migrations` VALUES (245,'2023_12_26_062527_create_delivery_histories_table',64);
INSERT INTO `migrations` VALUES (246,'2023_12_26_062626_create_delivery_dts_table',64);
INSERT INTO `migrations` VALUES (247,'2023_12_26_062638_create_delivery_dt_histories_table',64);
INSERT INTO `migrations` VALUES (248,'2023_12_26_071750_update_deliveries',64);
INSERT INTO `migrations` VALUES (249,'2023_12_26_071802_update_deliveries_history',64);
INSERT INTO `migrations` VALUES (250,'2023_12_26_074100_update_delivery_dts',64);
INSERT INTO `migrations` VALUES (251,'2023_12_26_074117_update_delivery_dts_history',64);
INSERT INTO `migrations` VALUES (252,'2023_12_26_083133_update_quot_prod_item_dt_used_qty',64);
INSERT INTO `migrations` VALUES (253,'2023_12_26_083209_update_quot_prod_item_dt_used_qty_temp',64);
INSERT INTO `migrations` VALUES (254,'2023_12_26_083227_update_quot_prod_item_dt_used_qty_history',64);
INSERT INTO `migrations` VALUES (255,'2023_12_26_085402_update_delivery_date_in_deliveries',64);
INSERT INTO `migrations` VALUES (256,'2023_12_26_085458_update_delivery_date_in_deliveries_history',64);
INSERT INTO `migrations` VALUES (257,'2023_12_27_081749_update_duplicate_field_i_n_production_items',65);
INSERT INTO `migrations` VALUES (258,'2023_12_27_081800_update_duplicate_field_i_n_production_items_history',65);
INSERT INTO `migrations` VALUES (259,'2023_12_27_082700_add_field_desc_to_production_items',65);
INSERT INTO `migrations` VALUES (260,'2023_12_27_082712_add_field_desc_to_production_items_history',65);
INSERT INTO `migrations` VALUES (261,'2023_12_27_104700_update_deliveries',66);
INSERT INTO `migrations` VALUES (262,'2023_12_27_104710_update_deliveries_history',66);
INSERT INTO `migrations` VALUES (263,'2023_12_27_114130_update_companies_tax',67);
INSERT INTO `migrations` VALUES (264,'2023_12_27_114141_update_companies_tax_history',67);
INSERT INTO `migrations` VALUES (265,'2023_12_28_072710_update_clients_table',67);
INSERT INTO `migrations` VALUES (266,'2023_12_28_072737_update_clients_table_history',67);
INSERT INTO `migrations` VALUES (267,'2023_12_28_080319_update_quotations',67);
INSERT INTO `migrations` VALUES (268,'2023_12_28_080434_update_quotations_temp',67);
INSERT INTO `migrations` VALUES (269,'2023_12_28_080453_update_quotations_history',67);
INSERT INTO `migrations` VALUES (270,'2023_12_28_085649_update_quotations_user_approved',67);
INSERT INTO `migrations` VALUES (271,'2023_12_28_085711_update_quotations_user_approved_temp',67);
INSERT INTO `migrations` VALUES (272,'2023_12_28_085726_update_quotations_user_approved_history',67);
INSERT INTO `migrations` VALUES (273,'2023_12_28_095055_update_address_primary',67);
INSERT INTO `migrations` VALUES (274,'2023_12_28_095113_update_address_primary_history',67);
INSERT INTO `migrations` VALUES (275,'2023_12_28_095633_update_contacts_primary',67);
INSERT INTO `migrations` VALUES (276,'2023_12_28_095703_update_contacts_primary_history',67);
INSERT INTO `migrations` VALUES (277,'2023_12_28_132833_update_deliveries_user',68);
INSERT INTO `migrations` VALUES (278,'2023_12_28_132848_update_deliveries_user_history',68);
INSERT INTO `migrations` VALUES (279,'2023_12_28_134318_update_quot_prod_item',68);
INSERT INTO `migrations` VALUES (280,'2023_12_28_134332_update_quot_prod_item_temp',68);
INSERT INTO `migrations` VALUES (281,'2023_12_28_134357_update_quot_prod_item_original',68);
INSERT INTO `migrations` VALUES (282,'2023_12_29_094348_add_account_no_and_e_rmail_to_bank',69);
INSERT INTO `migrations` VALUES (283,'2023_12_29_094400_add_account_no_and_e_rmail_to_bankhistory',69);
INSERT INTO `migrations` VALUES (284,'2023_12_29_134725_update_users_access_by_company',69);
INSERT INTO `migrations` VALUES (285,'2023_12_29_134740_update_users_access_by_company_history',69);
INSERT INTO `migrations` VALUES (286,'2024_01_02_074127_add_phone_number_to_banks',70);
INSERT INTO `migrations` VALUES (287,'2024_01_02_074141_add_phone_number_to_bank_history',70);
INSERT INTO `migrations` VALUES (288,'2024_01_02_090933_update_quotations',70);
INSERT INTO `migrations` VALUES (289,'2024_01_02_090946_update_quotations_temp',70);
INSERT INTO `migrations` VALUES (290,'2024_01_02_091000_update_quotations_history',70);
INSERT INTO `migrations` VALUES (291,'2024_01_02_133450_add_branch_to_delivery',71);
INSERT INTO `migrations` VALUES (292,'2024_01_03_065052_add_category_dt_and_thickness_to_stocl_items',71);
INSERT INTO `migrations` VALUES (293,'2024_01_03_065117_add_category_dt_and_thickness_to_stocl_items_history',71);
INSERT INTO `migrations` VALUES (294,'2024_01_03_093935_update_quotations',71);
INSERT INTO `migrations` VALUES (295,'2024_01_03_093951_update_quotations_temp',71);
INSERT INTO `migrations` VALUES (296,'2024_01_03_094007_update_quotations_history',71);
INSERT INTO `migrations` VALUES (297,'2024_01_04_113148_update_quotations',72);
INSERT INTO `migrations` VALUES (298,'2024_01_04_113218_update_quotations_temp',72);
INSERT INTO `migrations` VALUES (299,'2024_01_04_113232_update_quotations_history',72);
INSERT INTO `migrations` VALUES (300,'2024_01_08_060916_create_product_category_dt_brands_table',73);
INSERT INTO `migrations` VALUES (301,'2024_01_08_110857_update_quot_prod_item',74);
INSERT INTO `migrations` VALUES (302,'2024_01_08_110911_update_quot_prod_item_temp',74);
INSERT INTO `migrations` VALUES (303,'2024_01_08_110926_update_quot_prod_item_history',75);
INSERT INTO `migrations` VALUES (304,'2024_01_09_073737_update_quot_prod_item_dt',76);
INSERT INTO `migrations` VALUES (305,'2024_01_09_073755_update_quot_prod_item_dt_temp',76);
INSERT INTO `migrations` VALUES (306,'2024_01_09_074016_update_quot_prod_item_dt_history',76);
INSERT INTO `migrations` VALUES (307,'2024_01_10_064020_update_quot_prod_item_dts',77);
INSERT INTO `migrations` VALUES (308,'2024_01_10_064137_update_quot_prod_item_dts_temp',77);
INSERT INTO `migrations` VALUES (309,'2024_01_10_064248_update_quot_prod_item_dts_history',77);
INSERT INTO `migrations` VALUES (310,'2024_01_11_063605_update_table_user_access',78);
INSERT INTO `migrations` VALUES (311,'2024_01_11_063619_update_table_user_access_history',78);
INSERT INTO `migrations` VALUES (312,'2024_01_11_063639_update_table_role_access',78);
INSERT INTO `migrations` VALUES (313,'2024_01_11_063900_update_table_role_access_history',78);
INSERT INTO `migrations` VALUES (314,'2024_01_11_095736_update_status_table',79);
INSERT INTO `migrations` VALUES (315,'2024_01_11_095755_update_status_table_history',79);
INSERT INTO `migrations` VALUES (316,'2024_01_11_102443_update_status_table_type',80);
INSERT INTO `migrations` VALUES (317,'2024_01_11_102453_update_status_table_type_history',80);
INSERT INTO `migrations` VALUES (318,'2024_01_11_135612_update_quotations_table',81);
INSERT INTO `migrations` VALUES (319,'2024_01_11_135650_update_quotations_table_history',81);
INSERT INTO `migrations` VALUES (320,'2024_01_11_135705_update_quotations_table_temp',81);
INSERT INTO `migrations` VALUES (321,'2024_01_12_101705_update_users_ip',82);
INSERT INTO `migrations` VALUES (322,'2024_01_12_101738_update_users_ip_history',82);
INSERT INTO `migrations` VALUES (323,'2024_01_15_065518_update_quotations_cancel',83);
INSERT INTO `migrations` VALUES (324,'2024_01_15_065732_update_quotations_cancel_temp',83);
INSERT INTO `migrations` VALUES (325,'2024_01_15_070020_update_quotations_cancel_history',83);
INSERT INTO `migrations` VALUES (326,'2024_01_15_084339_update_adjustments_table',84);
INSERT INTO `migrations` VALUES (327,'2024_01_15_084938_update_adjustments_table_temp',84);
INSERT INTO `migrations` VALUES (328,'2024_01_15_084949_update_adjustments_table_history',84);
INSERT INTO `migrations` VALUES (329,'2024_01_15_092347_add_is_publuc_to_table_user',85);
INSERT INTO `migrations` VALUES (330,'2024_01_15_092412_add_is_publuc_to_table_user_history',85);
INSERT INTO `migrations` VALUES (331,'2024_01_16_080342_update_adjustments_remark',86);
INSERT INTO `migrations` VALUES (332,'2024_01_16_080447_update_adjustments_remark_temp',86);
INSERT INTO `migrations` VALUES (333,'2024_01_16_080623_update_adjustments_remark_history',86);
INSERT INTO `migrations` VALUES (334,'2024_01_19_094249_add_client_decimal_for_table_clienmt',87);
INSERT INTO `migrations` VALUES (335,'2024_01_19_094327_add_client_decimal_for_table_client_history',87);
INSERT INTO `migrations` VALUES (336,'2024_01_22_110718_change_ivoice_no_to_string_in_quotations',88);
INSERT INTO `migrations` VALUES (337,'2024_01_22_110950_change_ivoice_no_to_string_in_quotations_temp',88);
INSERT INTO `migrations` VALUES (338,'2024_01_22_111007_change_ivoice_no_to_string_in_quotations_history',88);
INSERT INTO `migrations` VALUES (339,'2024_01_24_105615_add_credit_note_to_quotation',89);
INSERT INTO `migrations` VALUES (340,'2024_01_24_105752_add_credit_note_to_quotation_temp',89);
INSERT INTO `migrations` VALUES (341,'2024_01_24_105807_add_credit_note_to_quotation_history',90);
INSERT INTO `migrations` VALUES (342,'2024_01_29_072007_create_modules_table',91);
INSERT INTO `migrations` VALUES (343,'2024_02_02_123654_create_history_logs_table',92);
