-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `country_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `country_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--


--
-- Table structure for table `crm_date`
--

CREATE TABLE `crm_date` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sync_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sync_link` text COLLATE utf8mb4_unicode_ci,
  `last_sync_date` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `crm_url` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `crm_date`
--

INSERT INTO `crm_date` VALUES (1,'components',NULL,'2024-07-01 00:00:00',NULL,NULL,NULL);

--
-- Table structure for table `crmsalescomponent`
--

CREATE TABLE `crmsalescomponent` (
  `component_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `component_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `component_slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `component_category_id` int DEFAULT NULL,
  `component_status` tinyint DEFAULT NULL,
  `component_description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `component_part_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `component_image` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `component_icon` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `component_price` decimal(10,2) NOT NULL,
  `component_parent_id` int DEFAULT NULL,
  `component_variation_component_id` int DEFAULT NULL,
  `description1` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description2` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sales_description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_synched` datetime NOT NULL,
  `modified_by` int DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `show_catelog` tinyint DEFAULT NULL,
  `component_properties` longtext COLLATE utf8mb4_unicode_ci,
  `property_values` longtext COLLATE utf8mb4_unicode_ci,
  `component_mtlFile` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `component_textureImages` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `component_proto_type` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_product_id` text COLLATE utf8mb4_unicode_ci,
  `crm_uom_id` text COLLATE utf8mb4_unicode_ci,
  `product_url` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unitprice` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unitcost` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `margin` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`component_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `crmsalescomponent`
--


--
-- Table structure for table `customer_shipping_details`
--

CREATE TABLE `customer_shipping_details` (
  `customer_user_details_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_user_id` int DEFAULT NULL,
  `account_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_email` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_phone1` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_phone2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_phone3` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_lattitude` double(8,2) DEFAULT NULL,
  `account_longitude` double(8,2) DEFAULT NULL,
  `account_address` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_city` int DEFAULT NULL,
  `account_state` int DEFAULT NULL,
  `account_country` int DEFAULT NULL,
  `account_county` int DEFAULT NULL,
  `account_zipcode` int DEFAULT NULL,
  `contact_firstname` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_lastname` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_email` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone1` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone3` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_lattitude` double(8,2) DEFAULT NULL,
  `contact_longitude` double(8,2) DEFAULT NULL,
  `contact_address1` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_address2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_state` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_country` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_zipcode` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_county` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_jobtitle` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_description` text COLLATE utf8mb4_unicode_ci,
  `account_description` text COLLATE utf8mb4_unicode_ci,
  `account_website` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_zipcode` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_zip_id` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ship_crm_zip_id` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `city` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`customer_user_details_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_shipping_details`
--

INSERT INTO `customer_shipping_details` VALUES (1,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,NULL,'ceed8313-9c29-ef11-840a-000d3a148064','Selkirk',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'cded8313-9c29-ef11-840a-000d3a148064','Dana','dana@selkirk.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,NULL,'7242bcfc-9f9d-ee11-be37-0022482aa871','softnotion_test56account',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9a01791d-a09d-ee11-be37-0022482aa871','softnotion_test56customer','softnotion_test56contact@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,NULL,'7242bcfc-9f9d-ee11-be37-0022482aa871','softnotion_test56account',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9a01791d-a09d-ee11-be37-0022482aa871','softnotion_test56customer','softnotion_test56contact@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,NULL,'7242bcfc-9f9d-ee11-be37-0022482aa871','softnotion_test56account',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'9a01791d-a09d-ee11-be37-0022482aa871','softnotion_test56customer','softnotion_test56contact@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd','Softnottions_acc_June13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7a2ce6aa-6429-ef11-840a-000d3a148ddd','Softnotions_cust_June13','june13partner@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `device_types`
--

CREATE TABLE `device_types` (
  `device_type_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `device_type_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`device_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `device_types`
--


--
-- Table structure for table `drawing_component_properties`
--

CREATE TABLE `drawing_component_properties` (
  `drawing_component_property_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `drawing_component_id` bigint NOT NULL,
  `component_property_id` bigint NOT NULL,
  `status` tinyint DEFAULT NULL,
  `drawing_component_property_value` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`drawing_component_property_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawing_component_properties`
--


--
-- Table structure for table `drawing_components`
--

CREATE TABLE `drawing_components` (
  `drawing_component_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `drawing_id` bigint NOT NULL,
  `component_id` bigint NOT NULL,
  `status` tinyint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`drawing_component_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawing_components`
--


--
-- Table structure for table `drawing_logs`
--

CREATE TABLE `drawing_logs` (
  `drawing_logs_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `quote_id` bigint NOT NULL,
  `log_user` bigint NOT NULL,
  `info` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`drawing_logs_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawing_logs`
--

INSERT INTO `drawing_logs` VALUES (1,1,1,'Quote/Opportunity softnotions-test-cutpanels created by Super admin1 successfully!','2024-07-01 14:36:45','2024-07-01 14:36:45'),(2,1,1,'Quote/Opportunity softnotions-test-cutpanels01 Updated by Super admin1 successfully!','2024-07-01 14:40:35','2024-07-01 14:40:35'),(3,2,1,'Quote/Opportunity softnotions-test-cutpanels001 created by Super admin1 successfully!','2024-07-01 14:52:00','2024-07-01 14:52:00'),(4,4,1,'Quote/Opportunity softnotion_test1july created by Super admin1 successfully!','2024-07-01 21:39:53','2024-07-01 21:39:53'),(5,5,1,'Quote/Opportunity softnotions_gvk_saveasopp_stage1.2 created by Super admin1 successfully!','2024-07-01 23:50:17','2024-07-01 23:50:17'),(6,6,1,'Quote/Opportunity softnotion_testpublish12 created by Super admin1 successfully!','2024-07-02 00:20:52','2024-07-02 00:20:52'),(7,7,1,'Quote/Opportunity softnotions_gvk_July1_saveasopp created by Super admin1 successfully!','2024-07-02 00:21:11','2024-07-02 00:21:11'),(8,8,1,'Quote/Opportunity softnotions_hrisnkr_test_opportunity_nameeee created by Super admin1 successfully!','2024-07-02 10:20:45','2024-07-02 10:20:45');

--
-- Table structure for table `drawing_models`
--

CREATE TABLE `drawing_models` (
  `drawing_model_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `model_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_model_icon` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `building_story` tinyint DEFAULT NULL,
  `drawing_model_file_path` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`drawing_model_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawing_models`
--


--
-- Table structure for table `drawing_notes`
--

CREATE TABLE `drawing_notes` (
  `drawing_noteid` bigint unsigned NOT NULL AUTO_INCREMENT,
  `description` text COLLATE utf8mb4_unicode_ci,
  `is_deleted` tinyint(1) DEFAULT '0',
  `quote_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`drawing_noteid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawing_notes`
--


--
-- Table structure for table `drawing_settings`
--

CREATE TABLE `drawing_settings` (
  `drawing_setting_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `drawing_id` bigint NOT NULL,
  `drawing_setting_building_type` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_building_shape` int DEFAULT NULL,
  `drawing_setting_system` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_existing_floor` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_standard_height` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_interior_wall_material` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_interior_color` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_exterior_wall_material` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_settings_exterior_color` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_panel_core` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_aluminium_finish` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_template_id` int DEFAULT NULL,
  `wired_option` tinyint DEFAULT NULL,
  `varient_color` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_expiry_date` datetime NOT NULL,
  `show_price_details` int DEFAULT NULL,
  `building_story` tinyint DEFAULT NULL,
  `drawing_setting_system2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_existing_floor2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_standard_height2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_interior_wall_material2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_interior_color2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_exterior_wall_material2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_settings_exterior_color2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_panel_core2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_aluminium_finish2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `varient_color2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_interior_system2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_setting_interior_system` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`drawing_setting_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawing_settings`
--

INSERT INTO `drawing_settings` VALUES (1,1,'0',1,'2A','concrete','243.84','Gypsum','G01','Gypsum','G01','XX','CL',NULL,0,'SW','0000-00-00 00:00:00',0,0,'2A','wood',NULL,'Gypsum','G01','Gypsum','G01','XX','CL','SW',NULL,'2A',NULL,NULL),(2,2,NULL,NULL,'2A','concrete','243.84','Gypsum','G01','Gypsum','G01','XX','CL',NULL,0,'SW','0000-00-00 00:00:00',0,0,'2A','wood',NULL,'Gypsum','G01','Gypsum','G01','XX','CL','SW',NULL,'4',NULL,NULL),(3,3,'0',1,'2A','concrete','243.84','Gypsum','G01','Gypsum','G01','XX','CL',NULL,0,'SW','0000-00-00 00:00:00',0,0,'2A','wood',NULL,'Gypsum','G01','Gypsum','G01','XX','CL','SW',NULL,'2A',NULL,NULL),(4,4,'0',1,'2A','concrete','243.84','Gypsum','G01','Gypsum','G01','XX','CL',NULL,1,'SW','0000-00-00 00:00:00',0,0,'2A','wood',NULL,'Gypsum','G01','Gypsum','G01','XX','CL','SW',NULL,'2A',NULL,NULL),(5,5,'0',1,'4','concrete','243.84','Gypsum','G01','Gypsum','G01','XX','CL',NULL,0,'SW','0000-00-00 00:00:00',0,0,'2A','wood',NULL,'Gypsum','G01','Gypsum','G01','XX','CL','SW',NULL,'2A',NULL,NULL),(6,6,'0',1,'2A','concrete','243.84','Gypsum','G01','Gypsum','G01','XX','CL',NULL,1,'SW','0000-00-00 00:00:00',0,0,'2A','wood',NULL,'Gypsum','G01','Gypsum','G01','XX','CL','SW',NULL,'2A',NULL,NULL),(7,7,'0',1,'2A','concrete','243.84','Gypsum','G01','Gypsum','G01','XX','CL',NULL,0,'SW','0000-00-00 00:00:00',0,0,'2A','wood',NULL,'Gypsum','G01','Gypsum','G01','XX','CL','SW',NULL,'2A',NULL,NULL);

--
-- Table structure for table `drawing_templates`
--

CREATE TABLE `drawing_templates` (
  `drawing_template_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `template_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_template_file_path` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `drawing_template_icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `building_story` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`drawing_template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawing_templates`
--


--
-- Table structure for table `drawing_writinproducts`
--

CREATE TABLE `drawing_writinproducts` (
  `writin_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `part_no` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description1` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description2` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `info` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote_id` int DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`writin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawing_writinproducts`
--


--
-- Table structure for table `drawings`
--

CREATE TABLE `drawings` (
  `drawing_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `drawing_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_price` decimal(8,2) NOT NULL,
  `drawing_quote_id` int DEFAULT NULL,
  `drawing_template_id` int DEFAULT NULL,
  `drawing_file_path` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_notes` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT '0',
  `revision_title` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `published_date` datetime DEFAULT NULL,
  `expiry_date` datetime DEFAULT NULL,
  `hash_id` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote_status` tinyint DEFAULT NULL,
  `crm_quote_id` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revision_number` int DEFAULT NULL,
  `drawing_type` tinyint DEFAULT NULL,
  `delivery_type` tinyint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `quote_ship_id` int DEFAULT NULL,
  `quote_header_number` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drawing_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_of_published` int DEFAULT NULL,
  PRIMARY KEY (`drawing_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drawings`
--

INSERT INTO `drawings` VALUES (1,NULL,0.00,1,NULL,NULL,NULL,0,1,0,'V1',NULL,NULL,'2y10GyniXdxusm3u1O5gzd1ueUwrn76tmWZ81ko7Wqf1iHNj3H9rgHa',NULL,NULL,NULL,NULL,NULL,'2024-07-01 14:36:45','2024-07-01 14:36:45',NULL,NULL,NULL,NULL,NULL),(2,'2',23426.46,2,NULL,'drawing_2.json',NULL,2,1,0,'V1','2024-07-02 09:40:23','2024-08-15 00:00:00','2y10PyeSpeCMsesOhRNwKizIXObLj2hxcuP5NXrnABVD4o9atr41YNAAy',NULL,'379d15f9-2838-ef11-8409-000d3a148ddd',NULL,NULL,NULL,'2024-07-01 14:52:00','2024-07-02 09:45:05',NULL,'QH-06029 - 11',NULL,NULL,16),(3,'3',0.00,4,NULL,'drawing_3.json','softnotion_test1july',0,1,0,'V1',NULL,NULL,'2y10WpRQhiOHCGBAcGHjT4YUf7gmwvyeUx8Vpa0ov1WmpB1psqK7lxe',NULL,NULL,NULL,NULL,NULL,'2024-07-01 21:39:53','2024-07-01 23:49:09',NULL,NULL,NULL,NULL,1),(4,'4',4914.71,5,NULL,'drawing_4.json','saveasoppoppdcpt1',2,1,0,'V1','2024-07-01 23:51:16','2024-08-15 00:00:00','2y10wkFBlSD9BUlAKX8SHKAU5O3jJ0cBe1vZz3vwXK0Zon6QBQJVZD8nW',NULL,'748fcaa8-d637-ef11-8409-000d3a581419',NULL,NULL,NULL,'2024-07-01 23:50:17','2024-07-01 23:52:33',NULL,'QH-06040',NULL,NULL,1),(5,'5',8282.74,6,NULL,'drawing_5.json','softnotion_testpublish12',2,1,0,'V1','2024-07-02 00:21:44','2024-08-16 00:00:00','2y10tyNjiWi6WFbn1oVVBgMe3EqzLo6RwCpLDzTP1iqyKqupiZwgWey',NULL,'b4a933ea-da37-ef11-8409-000d3a148ddd',NULL,NULL,NULL,'2024-07-02 00:20:52','2024-07-02 00:40:38',NULL,'QH-06043',NULL,NULL,1),(6,'6',6514.50,7,NULL,'drawing_6.json',NULL,2,1,0,'V1','2024-07-02 00:22:19','2024-08-16 00:00:00','2y106CKZCr6SBZ5TIALvenoOK9GP2rGhG4jUCA0xKN21qZ1lZnVdItW',NULL,'ef3463fc-da37-ef11-8409-000d3a581419',NULL,NULL,NULL,'2024-07-02 00:21:11','2024-07-02 00:56:55',NULL,'QH-06044',NULL,NULL,1),(7,'7',0.00,8,NULL,'drawing_7.json',NULL,0,1,0,'V1',NULL,NULL,'2y10Vca7TEgAGUOksqh52MJeprlKLzuvWIC3JcFnd3QDQvwbugXS',NULL,NULL,NULL,NULL,NULL,'2024-07-02 10:20:45','2024-07-02 10:22:20',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `email_template_id` int NOT NULL AUTO_INCREMENT,
  `email_template_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_template_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_template_subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_template_body` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT '0',
  `template_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`email_template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` VALUES (1,'Order confirmation','Order confirmation','Order confirmation','Order confirmation',0,'2019-09-06 14:00:35','2021-08-02 14:29:35',0,'become_a_licensee'),(2,'New quote','New quote','New quote','New quote',0,'2019-09-06 14:00:35','2020-04-01 20:40:36',0,NULL),(4,'test',NULL,'test mail','fdgdfg',0,'2019-10-09 11:46:05','2020-04-01 20:40:31',1,NULL),(5,'test',NULL,'twret','dfgdfg',0,'2019-10-09 11:56:04','2020-04-01 20:40:31',1,NULL),(6,'test',NULL,'twret','dfgdfg',0,'2019-10-09 11:56:04','2020-04-01 20:40:31',1,NULL),(7,'test',NULL,'twret','dfgdfg',0,'2019-10-09 11:56:04','2020-04-01 20:40:31',1,NULL),(8,'test',NULL,'twret','dfgdfg',0,'2019-10-09 11:56:05','2020-04-01 20:40:31',1,NULL),(9,'test',NULL,'twret','dfgdfg',0,'2019-10-09 11:56:05','2020-04-01 20:40:31',1,NULL),(10,'Forgot Password','new description','[iDesigner] Password reset','<p>\n\nHello \n\n<!--StartFragment--><span style=\"color: rgb(106, 108, 111); font-family: Raleway, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">%user_name%</span><!--EndFragment-->\n\n<name>,</name></p><p><name></name><name>You\'ve recently asked to reset the password for this iDesigner account:&nbsp;\n\n<!--StartFragment--><span style=\"color: rgb(106, 108, 111); font-family: Raleway, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">%user_name%</span><!--EndFragment-->\n\n<span style=\"color: rgb(106, 108, 111); font-family: Raleway, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\"></span><!--EndFragment--></name></p><p><name><username>To update your password, click the link&nbsp;below:\n\n<!--StartFragment--><span style=\"color: rgb(106, 108, 111); font-family: Raleway, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">%reset_link%</span><!--EndFragment-->\n\n</username></name></p><p><name><username><reset my=\"\" password=\"\">Cheers,</reset></username></name></p><p><name><username><reset my=\"\" password=\"\"></reset></username></name><name><username><reset my=\"\" password=\"\">iDesigner Team\n\n</reset></username></name><br></p>',1,'2019-10-10 09:36:37','2022-09-13 14:20:42',0,'forgot_email'),(11,'test','dgdfg','dsgdfg','dfgdfgdfg',0,'2019-10-29 10:33:26','2020-04-01 20:40:31',1,NULL),(12,'Quote reminders','test','test','test',0,'2019-11-28 12:06:09','2020-04-07 15:59:16',1,NULL),(13,'Become a licensee','test','test','test',0,'2019-11-28 12:06:58','2020-04-01 20:40:31',1,NULL),(14,'Expiration reminder','fdg','Customer quote expiration reminder','fdg',0,'2019-11-28 12:08:25','2020-04-01 20:40:31',0,NULL),(15,'Quote expiration reminder','test','test','test',1,'2020-01-27 18:48:13','2020-01-27 18:48:37',1,'new_quote'),(16,'forgotmail','forgot','Subject: Reset your password','<p>Hello %user_name%,</p><p>We have received a request to reset your iDesigner account password associated with this email address.To reset your password, click the link below.</p><p> Click The Link To Reset Password: \"%link%\"</p><p>If you didn\'t request a password reset, please ignore this email.</p><p>Thank you,iDesigner Team</p>',0,'2020-03-02 17:15:18','2022-01-17 14:38:11',1,'forgot_email'),(17,'fdg','fdg','fdg','fdg',1,'2020-03-06 18:14:39','2020-03-06 18:16:51',1,'expiration_reminder'),(18,'fd',NULL,'fgd','fdgdfg',0,'2020-04-01 20:34:32','2021-08-02 14:29:35',1,'become_a_licensee'),(19,'Quote reminders',NULL,'test','trert',1,'2020-04-07 16:00:18','2021-08-02 14:29:35',0,'become_a_licensee'),(20,'safds','test','Notification','<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\"><div style=\"margin: 0px 14.3906px 0px 28.7969px; padding: 0px; width: 436.797px; text-align: left; float: left; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;\"><p style=\"margin: 0px 0px 15px; padding: 0px; text-align: justify;\"><strong style=\"margin: 0px; padding: 0px;\">Lorem Ipsum</strong><span>&nbsp;</span>is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p></div><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;\"><h2 style=\"margin: 0px 0px 10px; padding: 0px; font-weight: 400; font-family: DauphinPlain; font-size: 24px; line-height: 24px; text-align: left;\">Why do we use it?</h2><p style=\"margin: 0px 0px 15px; padding: 0px; text-align: justify;\">It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\"><div style=\"margin: 0px 14.3906px 0px 28.7969px; padding: 0px; width: 436.797px; text-align: left; float: left; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;\"><p style=\"margin: 0px 0px 15px; padding: 0px; text-align: justify;\"><strong style=\"margin: 0px; padding: 0px;\">Lorem Ipsum</strong><span>&nbsp;</span>is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p></div><div style=\"margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; text-align: left; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;\"><h2 style=\"margin: 0px 0px 10px; padding: 0px; font-weight: 400; font-family: DauphinPlain; font-size: 24px; line-height: 24px; text-align: left;\">Why do we use it?</h2><p style=\"margin: 0px 0px 15px; padding: 0px; text-align: justify;\">It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p></div></p></div>',1,'2020-04-13 20:52:56','2020-04-21 12:29:42',1,'quote_reminders'),(21,'tear','ar','ar','<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p>\n\n<!--StartFragment--><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 14.3906px 0px 28.7969px; padding: 0px; width: 436.797px; float: left; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\"><strong style=\"box-sizing: border-box; font-weight: bolder; margin: 0px; padding: 0px;\">Lorem Ipsum</strong><span style=\"box-sizing: border-box;\">&nbsp;</span>is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p></div><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><h2 style=\"box-sizing: border-box; margin: 0px 0px 10px; font-family: DauphinPlain; font-weight: 400; line-height: 24px; color: inherit; font-size: 24px; padding: 0px; text-align: left;\">Why do we use it?</h2><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p></div><br style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px; padding: 0px; clear: both; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; text-align: center; background-color: rgb(255, 255, 255);\"><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 14.3906px 0px 28.7969px; padding: 0px; width: 436.797px; float: left; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><h2 style=\"box-sizing: border-box; margin: 0px 0px 10px; font-family: DauphinPlain; font-weight: 400; line-height: 24px; color: inherit; font-size: 24px; padding: 0px; text-align: left;\">Where does it come from?</h2><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p></div><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><h2 style=\"box-sizing: border-box; margin: 0px 0px 10px; font-family: DauphinPlain; font-weight: 400; line-height: 24px; color: inherit; font-size: 24px; padding: 0px; text-align: left;\">Where can I get some?</h2><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p></div><!--EndFragment-->\n\n</p>',0,'2020-04-21 12:31:36','2022-03-23 12:23:44',1,'notification'),(23,'fdg','gd','dfg','<!--StartFragment--><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 14.3906px 0px 28.7969px; padding: 0px; width: 436.797px; float: left; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\"><strong style=\"box-sizing: border-box; font-weight: bolder; margin: 0px; padding: 0px;\">Lorem Ipsum</strong><span style=\"box-sizing: border-box;\">&nbsp;</span>is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p></div><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><h2 style=\"box-sizing: border-box; margin: 0px 0px 10px; font-family: DauphinPlain; font-weight: 400; line-height: 24px; color: inherit; font-size: 24px; padding: 0px; text-align: left;\">Why do we use it?</h2><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p></div><br style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px; padding: 0px; clear: both; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; text-align: center; background-color: rgb(255, 255, 255);\"><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 14.3906px 0px 28.7969px; padding: 0px; width: 436.797px; float: left; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><h2 style=\"box-sizing: border-box; margin: 0px 0px 10px; font-family: DauphinPlain; font-weight: 400; line-height: 24px; color: inherit; font-size: 24px; padding: 0px; text-align: left;\">Where does it come from?</h2><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p></div><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><h2 style=\"box-sizing: border-box; margin: 0px 0px 10px; font-family: DauphinPlain; font-weight: 400; line-height: 24px; color: inherit; font-size: 24px; padding: 0px; text-align: left;\">Where can I get some?</h2><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p><p>\n\n<!--StartFragment--><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 14.3906px 0px 28.7969px; padding: 0px; width: 436.797px; float: left; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\"><strong style=\"box-sizing: border-box; font-weight: bolder; margin: 0px; padding: 0px;\">Lorem Ipsum</strong><span style=\"box-sizing: border-box;\">&nbsp;</span>is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p></div><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><h2 style=\"box-sizing: border-box; margin: 0px 0px 10px; font-family: DauphinPlain; font-weight: 400; line-height: 24px; color: inherit; font-size: 24px; padding: 0px; text-align: left;\">Why do we use it?</h2><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p></div><br style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px; padding: 0px; clear: both; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; text-align: center; background-color: rgb(255, 255, 255);\"><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 14.3906px 0px 28.7969px; padding: 0px; width: 436.797px; float: left; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><h2 style=\"box-sizing: border-box; margin: 0px 0px 10px; font-family: DauphinPlain; font-weight: 400; line-height: 24px; color: inherit; font-size: 24px; padding: 0px; text-align: left;\">Where does it come from?</h2><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p></div><div style=\"box-sizing: border-box; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; margin: 0px 28.7969px 0px 14.3906px; padding: 0px; width: 436.797px; float: right; color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; font-weight: 400; background-color: rgb(255, 255, 255);\"><h2 style=\"box-sizing: border-box; margin: 0px 0px 10px; font-family: DauphinPlain; font-weight: 400; line-height: 24px; color: inherit; font-size: 24px; padding: 0px; text-align: left;\">Where can I get some?</h2><p style=\"box-sizing: border-box; margin: 0px 0px 15px; padding: 0px; text-align: justify;\">There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p></div><!--EndFragment-->\n\n</p></div><!--EndFragment-->',0,'2020-04-21 12:47:12','2020-04-21 12:49:19',1,'expiration_reminder'),(24,'Registration','Registration','Registration','<!--StartFragment--><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm; box-sizing: border-box;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">Hello \n\n<!--StartFragment--><span style=\"color: rgb(106, 108, 111); font-family: Raleway, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">%user_name%</span><!--EndFragment-->\n\n,</span><span style=\"font-size: 10pt; font-family: Verdana, sans-serif;\"><u></u><u></u></span></p><p class=\"MsoNormal\" style=\"margin: 0px; color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">We wanted to let you know that your iDesigner<span>&nbsp;</span></span><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">account<span>&nbsp;</span></span><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">is created. Please find the login credentials below.<u></u><u></u></span></p><span class=\"im\" style=\"color: rgb(80, 0, 80); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><p style=\"margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\"><u></u>&nbsp;<u></u></span></p><p style=\"margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">Click here to Login :<span>&nbsp;<span style=\"color: rgb(106, 108, 111); font-family: Raleway, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">%website_link%</span></span></span></p></span><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">Username&nbsp;\n\n<!--StartFragment--><span style=\"color: rgb(106, 108, 111); font-family: Raleway, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">%user_email%</span><!--EndFragment-->\n\n</span></p><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm; box-sizing: border-box;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">Password %password%</span></p><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm; box-sizing: border-box;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\"><u></u>&nbsp;<u></u></span></p><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">Cheers,</span><span style=\"font-size: 10pt; font-family: Verdana, sans-serif;\"><u></u><u></u></span></p><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm; box-sizing: border-box;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">iDesigner Team</span></p><!--EndFragment-->',1,'2020-06-05 19:00:17','2022-09-13 14:17:34',0,'registration'),(25,'test','test','test','tesr',0,'2020-06-25 20:35:35','2022-03-23 12:23:44',1,'notification'),(26,'Change Password','password change test','Subject: Password Changed','<!--StartFragment--><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm; box-sizing: border-box;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">Hello \n\n<!--StartFragment--><span style=\"color: rgb(106, 108, 111); font-family: Raleway, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">%user_name%</span><!--EndFragment-->&nbsp;,</span><span style=\"font-size: 10pt; font-family: Verdana, sans-serif;\"><u></u><u></u></span></p><p class=\"MsoNormal\" style=\"margin: 0px; color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">We wanted to let you know that your iDesigner password&nbsp;was&nbsp;reset.<u></u><u></u></span></p><p class=\"MsoNormal\" style=\"margin: 0px; color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\"><u></u>&nbsp;<u></u></span></p><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">New Password: %password%</span></p><p class=\"MsoNormal\" style=\"margin: 0px; color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">If you did not perform this action, please contact support at<span>&nbsp;</span><a href=\"mailto:contact@idesigner.com\" target=\"_blank\" style=\"color: rgb(17, 85, 204);\">contact@idesigner.com</a><u></u><u></u></span></p><p class=\"MsoNormal\" style=\"margin: 0px; color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\"><u></u>&nbsp;<u></u></span></p><p class=\"MsoNormal\" style=\"margin: 0px; color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">Please do not reply to this email with your&nbsp;password. We will never ask for your&nbsp;password, and we strongly discourage you from sharing it with anyone.<u></u><u></u></span></p><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\"><u></u>&nbsp;<u></u></span></p><p style=\"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">Cheers,</span><span style=\"font-size: 10pt; font-family: Verdana, sans-serif;\"><u></u><u></u></span></p><span class=\"im\" style=\"color: rgb(80, 0, 80); font-family: Arial, Helvetica, sans-serif; font-size: small; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><p style=\"margin-right: 0cm; margin-bottom: 7.5pt; margin-left: 0cm; box-sizing: border-box;\"><span style=\"font-size: 10pt; font-family: Verdana, sans-serif; color: black;\">iDesigner Team&nbsp; &nbsp;&nbsp;</span></p></span><!--EndFragment-->',1,'2020-09-30 11:23:18','2022-07-27 12:50:56',0,'change_password'),(27,'Change Email',NULL,'Email Changed','<span style=\"color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">Hello %user_name% ,</span><br style=\"box-sizing: inherit; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><span style=\"color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">We wanted to let you know that your iDesigner username is updated. Please find the username below.</span><span class=\"c-mrkdwn__br\" data-stringify-type=\"paragraph-break\" style=\"box-sizing: inherit; display: block; height: 8px; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></span><span style=\"color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">Click here to Login :<span>&nbsp;<span style=\"color: rgb(106, 108, 111); font-family: Raleway, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">%website_link%</span></span></span><br style=\"box-sizing: inherit; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><span style=\"color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">Username&nbsp; %user_email%</span><span class=\"c-mrkdwn__br\" data-stringify-type=\"paragraph-break\" style=\"box-sizing: inherit; display: block; height: 8px; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></span><span class=\"c-mrkdwn__br\" data-stringify-type=\"paragraph-break\" style=\"box-sizing: inherit; display: block; height: 8px; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"></span><span style=\"color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">Cheers,</span><br style=\"box-sizing: inherit; color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><span style=\"color: rgb(29, 28, 29); font-family: Slack-Lato, Slack-Fractions, appleLogo, sans-serif; font-size: 15px; font-style: normal; font-variant-ligatures: common-ligatures; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">iDesigner Team</span>',1,'2022-07-27 13:12:36','2022-09-13 14:16:38',0,'change_email');

--
-- Table structure for table `issue_comments`
--

CREATE TABLE `issue_comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `issues_comment` text COLLATE utf8mb4_unicode_ci,
  `issuecomment_image_path` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `issue_id` int NOT NULL,
  `created_by` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `issue_comments`
--


--
-- Table structure for table `issues`
--

CREATE TABLE `issues` (
  `issue_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `issue_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `issue_description` text COLLATE utf8mb4_unicode_ci,
  `issue_drawing_id` int DEFAULT NULL,
  `issue_assigned_to` int DEFAULT NULL,
  `issue_image_path` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT '0',
  `created_by` int DEFAULT NULL,
  `priority` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `issues_comment` text COLLATE utf8mb4_unicode_ci,
  `issue_file_path` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `issues`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2804 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (2723,'2019_12_14_000001_create_personal_access_tokens_table',1),(2724,'2022_08_01_103225_create_components_table',1),(2725,'2022_08_01_112939_create_countries_table',1),(2726,'2022_08_01_113202_create_crm_date_table',1),(2727,'2022_08_01_113452_create_customer_shipping_details_table',1),(2728,'2022_08_01_114716_create_device_types_table',1),(2729,'2022_08_01_123357_create_drawings_table',1),(2730,'2022_08_01_125704_create_drawing_components_table',1),(2731,'2022_08_01_125951_create_drawing_component_properties_table',1),(2732,'2022_08_01_130528_create_drawing_logs_table',1),(2733,'2022_08_01_130739_create_drawing_models_table',1),(2734,'2022_08_01_131136_create_drawing_notes_table',1),(2735,'2022_08_01_131553_create_drawing_settings_table',1),(2736,'2022_08_01_132851_create_drawing_templates_table',1),(2737,'2022_08_01_133155_create_drawing_writinproducts_table',1),(2738,'2022_08_01_134201_create_issues_table',1),(2739,'2022_08_01_134701_create_new_zip_codes',1),(2740,'2022_08_02_103434_create_notification_user_table',1),(2741,'2022_08_02_103434_create_notifications_table',1),(2742,'2022_08_02_103434_create_page_fields_table',1),(2743,'2022_08_02_103434_create_pages_table',1),(2744,'2022_08_02_103434_create_partner_brands_table',1),(2745,'2022_08_02_104648_create_partner_customers_table',1),(2746,'2022_08_02_104648_create_partner_user_details_table',1),(2747,'2022_08_02_104648_create_partner_user_locations_table',1),(2748,'2022_08_02_104648_create_password_resets_table',1),(2749,'2022_08_02_104648_create_product_keys_table',1),(2750,'2022_08_02_104648_create_product_properties_table',1),(2751,'2022_08_02_104648_create_product_property_item_codes_table',1),(2752,'2022_08_02_104919_create_pro_tips_table',1),(2753,'2022_08_02_104919_create_quote_revisions_table',1),(2754,'2022_08_02_104919_create_quotes_table',1),(2755,'2022_08_02_104919_create_role_permissions_table',1),(2756,'2022_08_02_104919_create_roles_table',1),(2757,'2022_08_02_104919_create_rule_categories_table',1),(2758,'2022_08_02_104919_create_rules_table',1),(2759,'2022_08_02_104919_create_shapes_table',1),(2760,'2022_08_02_105408_create_states_table',1),(2761,'2022_08_02_105408_create_todos_table',1),(2762,'2022_08_02_105408_create_transaction_table_table',1),(2763,'2022_08_02_105408_create_tutorials_table',1),(2764,'2022_08_02_105408_create_user_roles_table',1),(2765,'2022_08_02_105408_create_users_accounts_table',1),(2766,'2022_08_02_105408_create_users_table',1),(2767,'2022_08_02_105408_create_zip_codes_table',1),(2768,'2022_08_02_113727_create_brand_components_table',1),(2769,'2022_08_02_113727_create_brands_table',1),(2770,'2022_08_02_113727_create_cities_table',1),(2771,'2022_08_02_113727_create_cms_categories_table',1),(2772,'2022_08_02_113727_create_cms_pages_table',1),(2773,'2022_08_02_113727_create_component_categories_table',1),(2774,'2022_08_02_201611_create_products_table',1),(2775,'2022_08_02_201631_create_variants_table',1),(2776,'2022_08_18_162450_create_email_templates_table',1),(2777,'2022_09_12_145414_alter_comment_to_table_name',1),(2778,'2022_09_15_141725_create_issue_comments',1),(2779,'2022_11_11_122307_create_productservices_table',1),(2780,'2022_12_13_121140_create_producttypes_table',1),(2781,'2022_12_13_143415_add_producttype_to_quotes_table',1),(2782,'2022_12_13_143415_add_producttypebrin_to_quotes_table',1),(2783,'2022_12_16_200800_add_other_to_pages',1),(2784,'2022_12_19_122138_drop_productservices',1),(2785,'2022_12_19_151720_add_other_to_pages_table',1),(2786,'2022_12_21_110622_add_paid_to_customer_shipper_table',1),(2787,'2022_12_21_113254_add_paid_to_city_table',1),(2788,'2023_01_05_182332_crm_user',1),(2789,'2023_01_24_141439_add_vertical_market_to_users_table',1),(2790,'2023_01_25_110645_add_subtype_to_users_table',1),(2791,'2023_02_02_113924_add_issue_file_table',1),(2792,'2023_02_14_123304_add_leadsource_table',1),(2793,'2023_02_14_123448_add_secleadsource_table',1),(2794,'2023_02_20_123850_add_category_to_usersaccount_table',1),(2795,'2023_04_24_103059_add_crm_url_crmdate_table',1),(2796,'2023_10_29_105345_create_crmsalescomponent',1),(2797,'2024_01_07_102200_add_quotenumber_to_drawing_table',1),(2798,'2024_03_17_145204_add_column_product_table',1),(2799,'2024_03_19_145510_add_column_changes_component_table',1),(2800,'2024_04_20_150717_add_drawing_notes_to_users_table',1),(2801,'2024_04_27_103906_add_painted_quantity_to_components_table',1),(2802,'2024_05_19_150457_add_drawing_notes_to_drawing_table',1),(2803,'2024_06_01_182245_add_order_published',1);

--
-- Table structure for table `new_zip_codes`
--

CREATE TABLE `new_zip_codes` (
  `zip_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `zip_code` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city_id` int DEFAULT NULL,
  `country` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `zip_city` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `crm_zip_id` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `crm_country_id` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`zip_id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `new_zip_codes`
--

INSERT INTO `new_zip_codes` VALUES (101,'01080',NULL,'US','MA','01080 Three Rivers','Three Rivers','822591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:08','2019-12-17 03:03:59'),(102,'01081',NULL,'US','MA','01081 Wales','Wales','842591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:08','2019-12-17 03:03:59'),(103,'01082',NULL,'US','MA','01082 Ware','Ware','862591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:08','2019-12-17 03:03:59'),(104,'01083',NULL,'US','MA','01083 Warren','Warren','882591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:08','2019-12-17 03:03:59'),(105,'01084',NULL,'US','MA','01084 West Chesterfield','West Chesterfield','8a2591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:08','2019-12-17 03:03:59'),(106,'01085',NULL,'US','MA','01085 Westfield','Westfield','8c2591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:08','2019-12-17 03:03:59'),(107,'01086',NULL,'US','MA','01086 Westfield','Westfield','8e2591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:08','2019-12-17 03:03:59'),(108,'01088',NULL,'US','MA','01088 West Hatfield','West Hatfield','902591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:09','2019-12-17 03:03:59'),(109,'01089',NULL,'US','MA','01089 West Springfield','West Springfield','922591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:09','2019-12-17 03:03:59'),(110,'01090',NULL,'US','MA','01090 West Springfield','West Springfield','942591dd-7317-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2019-12-05 21:07:09','2019-12-17 03:03:59'),(111,'83815',NULL,'US','ID','83815 Coeur D Alene','Coeur D Alene','01832ed6-7417-ea11-a811-000d3a579cc4','399ff6d6-1912-ea11-a811-000d3a579b96','2024-07-01 21:22:37','2024-07-01 21:22:37');

--
-- Table structure for table `notification_user`
--

CREATE TABLE `notification_user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `notification_id` int NOT NULL,
  `notification_user_id` int NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `notification_user_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_user`
--


--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `notification_id` int NOT NULL AUTO_INCREMENT,
  `notification_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notification_message` text COLLATE utf8mb4_unicode_ci,
  `notification_assigned_to` int DEFAULT NULL,
  `notification_machine_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `page_fields`
--

CREATE TABLE `page_fields` (
  `page_field_id` int NOT NULL AUTO_INCREMENT,
  `page_field_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_id` int DEFAULT NULL,
  `page_field_description` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`page_field_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page_fields`
--

INSERT INTO `page_fields` VALUES (1,'Save As Shape',17,'Super admins can save a drawings as shapes. '),(2,'Save As Template',17,'Users can save a drawing as a template. If created by a partner, it will only get access to their internal users.'),(3,'Import Drawing',17,'Super admins can import a drawing as a JSON file.'),(4,'Export Drawing',17,'User can export drawing as JSON file. If a user faces any issue with drawing they can simply export it.  Later experts can use this file to import into the system and can easily sort out the issue.');

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `page_id` int NOT NULL AUTO_INCREMENT,
  `page_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other` tinyint(1) DEFAULT '0',
  `others` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'Roles','Super admin can manage other user roles, if selected. This includes view/add/edit/delete features. ',0,0),(2,'Email templates','All the emails sent to users can be set from the backend through the email templates. Super admin and Allied admins can edit/delete these mail contents. ',0,0),(3,'Users','Super / Allied / partners admins can create internal users and assign the roles to them. ',0,0),(4,'Locations','Super admins can manage locations where iDesigner is available, update will be saved inside iDesigner. Users have the option to add location by country, state, county, city, zip code.',1,0),(5,'Vertical Market','Super admins can manage all Vertical Market added inside iDesigner.',0,0),(6,'Components','This functionality allows the super admin to manage components needed for drawings inside iDesigner. This will get synched from the CRM.',0,0),(7,'Partner','iDesigner partners are added to the system by the Allied administrators. Only the partners have the ability to create drawings inside iDesigner. They will use iDesigner to sell our products to our customers.',0,0),(8,'Order','Users can manage the orders under them. ',1,0),(9,'Customer','Users can create customers inside iDesigner. While adding customers, there are required fields and optional fields that will need to be filled out like business name, add 1, add2, city, state, zip, notes, email, phone number etc.',0,0),(11,'Tutorials','Super admin and Allied admin can add/edit/delete video tutorials from backend. The tutorials are used to educate partners on how to use the application. ',0,0),(12,'Protips','Pro-tips are used in our iDesigner and are displayed while drawing.  Admin can add pro-tips for drawings in the backend. ',0,0),(13,'To - Dos','Users can manage To do items if this module is allowed.',0,0),(14,'Notifications','Super admins can create notifications from the backend and can send to users they want (I.e. all customers or to select ones).',0,0),(15,'Reports','Used to generate the reports for sales order, opportunities, brand, product type.',1,0),(16,'Logs','Super admin can view all logs created inside the application (adding user, deleting, quote creation, all info regarding drawing etc.). This information can be used to evaluate, if we have faced any problem inside the application.',1,0),(17,'Opportunities','Users can manage the opportunities associated with them, including the view/add/edit/delete of the opportunities.',0,0),(18,'Tickets','Users can raise issues through iDesigner application itself, if selected. ',0,0),(20,'View Deleted Drawings','View Deleted Drawings',1,0);

--
-- Table structure for table `partner_brands`
--

CREATE TABLE `partner_brands` (
  `partner_brand_id` int NOT NULL AUTO_INCREMENT,
  `partner_user_id` int NOT NULL,
  `brand_id` int NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`partner_brand_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partner_brands`
--

INSERT INTO `partner_brands` VALUES (2,3,1,'2022-08-10 14:47:17','2022-08-10 14:47:17');

--
-- Table structure for table `partner_customers`
--

CREATE TABLE `partner_customers` (
  `partner_customer_id` int NOT NULL AUTO_INCREMENT,
  `partner_customer_user_id` int DEFAULT NULL,
  `partner_user_id` int NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`partner_customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partner_customers`
--

INSERT INTO `partner_customers` VALUES (1,3,2,NULL,NULL,NULL),(2,6,3,NULL,NULL,NULL),(3,7,3,NULL,NULL,NULL),(4,8,3,NULL,NULL,NULL),(6,9,3,NULL,NULL,NULL),(7,8,3,NULL,NULL,NULL),(8,8,3,NULL,NULL,NULL),(9,8,3,NULL,NULL,NULL);

--
-- Table structure for table `partner_user_details`
--

CREATE TABLE `partner_user_details` (
  `partner_user_details_id` int NOT NULL AUTO_INCREMENT,
  `partner_user_id` int DEFAULT NULL,
  `partner_business_phone` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `partner_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_contact_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`partner_user_details_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partner_user_details`
--


--
-- Table structure for table `partner_user_locations`
--

CREATE TABLE `partner_user_locations` (
  `partner_user_location_id` int NOT NULL AUTO_INCREMENT,
  `partner_user_id` int NOT NULL,
  `partner_location_id` int DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  `state_id` int DEFAULT NULL,
  `county_id` int DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `is_territory` int DEFAULT NULL,
  `zip_id` int DEFAULT NULL,
  `address1` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(225) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_zip_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`partner_user_location_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partner_user_locations`
--

INSERT INTO `partner_user_locations` VALUES (1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1234 Main\nOrange, CA 92867\nUS',NULL,NULL),(2,1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `pro_tips`
--

CREATE TABLE `pro_tips` (
  `pro_tip_id` int NOT NULL AUTO_INCREMENT,
  `pro_tip_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pro_tip_description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  `component_id` int DEFAULT NULL,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`pro_tip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pro_tips`
--


--
-- Table structure for table `product_keys`
--

CREATE TABLE `product_keys` (
  `product_key_id` int NOT NULL AUTO_INCREMENT,
  `product_key` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`product_key_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_keys`
--


--
-- Table structure for table `product_properties`
--

CREATE TABLE `product_properties` (
  `product_property_id` int NOT NULL AUTO_INCREMENT,
  `product_key_id` int NOT NULL,
  `product_property_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`product_property_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_properties`
--


--
-- Table structure for table `product_property_item_codes`
--

CREATE TABLE `product_property_item_codes` (
  `product_property_item_id` int NOT NULL AUTO_INCREMENT,
  `product_key_id` int NOT NULL,
  `product_property_id` int NOT NULL,
  `product_property_item` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_property_item_code` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`product_property_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_property_item_codes`
--


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `productservices`
--

CREATE TABLE `productservices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `crmd_lastcost` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crmd_unitid_value` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crmdqe_ourproductcode` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crmd_productid_value` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crmdqe_descriptionfull` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crmd_unitstandard_value` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crmd_unitgroupid_value` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crmdqe_productsservicesid` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crmdqe_supplierproductcode` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `productservices`
--


--
-- Table structure for table `producttypes`
--

CREATE TABLE `producttypes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `producttype_id` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `producttype_name` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `producttypes`
--


--
-- Table structure for table `quote_revisions`
--

CREATE TABLE `quote_revisions` (
  `quote_revision_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `quote_revision_quote_id` int NOT NULL,
  `quote_revision_drawing_id` int NOT NULL,
  `quote_revision_drawing_template_id` int DEFAULT NULL,
  `quote_revision_status` tinyint(1) NOT NULL,
  `quote_revision_quote_status` tinyint(1) NOT NULL,
  `quote_revision_version_title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`quote_revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quote_revisions`
--


--
-- Table structure for table `quotes`
--

CREATE TABLE `quotes` (
  `quote_id` int NOT NULL AUTO_INCREMENT,
  `quote_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote_customer_id` int DEFAULT NULL,
  `quote_start_date` datetime DEFAULT NULL,
  `quote_end_date` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `partner_user_id` int DEFAULT NULL,
  `sales_order_no` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sales_user_id` int DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `building_type` int DEFAULT NULL,
  `expiry_date` datetime DEFAULT NULL,
  `order_date` datetime DEFAULT NULL,
  `brand_id` int DEFAULT NULL,
  `job_name` text COLLATE utf8mb4_unicode_ci,
  `is_deleted` tinyint NOT NULL DEFAULT '0',
  `quote_status` tinyint(1) DEFAULT NULL,
  `job_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote_ship_id` int DEFAULT NULL,
  `delivery_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote_number` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_quote_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `same_shipper` tinyint(1) DEFAULT NULL,
  `shipper_id` int DEFAULT NULL,
  `assigned_to` int DEFAULT NULL,
  `last_access_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `primary_drawing` int DEFAULT NULL,
  `won_drawing` int DEFAULT NULL,
  `is_archive` int DEFAULT '0',
  `product_type` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_typenew` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_leadsourcecode` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_secleadsourcecode` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`quote_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotes`
--

INSERT INTO `quotes` VALUES (1,'softnotions-test-cutpanels01',6,NULL,NULL,0,1,'2024-07-01 14:40:05','2024-07-01 14:51:12',NULL,NULL,NULL,NULL,0,'2025-01-01 14:36:45',NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,'311f44c4-8937-ef11-8409-6045bded681c',0,NULL,1,'2024-07-01 14:40:39',NULL,NULL,0,'1',NULL,'12','2'),(2,'softnotions-test-cutpanels001',7,NULL,NULL,4,1,'2024-07-01 14:52:00','2024-07-02 09:40:23',NULL,NULL,NULL,23426.46,0,NULL,NULL,1,NULL,0,5,NULL,20,'common_carrier','QH-06029 - 11','219b4d57-8b37-ef11-8409-000d3a581f06',0,NULL,1,'2024-07-01 14:57:42',2,NULL,0,'1',NULL,'100000015','16'),(3,NULL,8,NULL,NULL,NULL,NULL,'2024-07-01 18:03:12','2024-07-01 18:03:12',3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2024-07-01 18:03:12',NULL,NULL,0,NULL,NULL,NULL,NULL),(4,'softnotion_test1july',9,NULL,NULL,0,1,'2024-07-01 21:39:53','2024-07-01 23:49:10',NULL,NULL,NULL,NULL,0,NULL,NULL,2,'softnotion_test1july',0,5,NULL,14,'common_carrier',NULL,'69460652-c437-ef11-8409-000d3a581aff',0,NULL,1,'2024-07-01 23:46:22',3,NULL,0,'1',NULL,'1','100000017'),(5,'softnotions_gvk_saveasopp_stage1.2',8,NULL,NULL,0,1,'2024-07-01 23:50:17','2024-07-01 23:51:16',NULL,NULL,NULL,4914.71,0,NULL,NULL,1,NULL,0,5,NULL,15,'common_carrier','QH-06040','eb50a9e5-e235-ef11-8409-000d3a148ddd',0,NULL,1,'2024-07-01 23:50:17',4,NULL,0,'1',NULL,'100000007','100000013'),(6,'softnotion_testpublish12',8,NULL,NULL,0,1,'2024-07-02 00:20:52','2024-07-02 00:21:44',NULL,NULL,NULL,8282.74,0,NULL,NULL,1,'softnotion_testpublish12',0,5,NULL,16,'common_carrier','QH-06043','b68218d2-da37-ef11-8409-000d3a581419',0,NULL,1,'2024-07-02 00:20:52',5,NULL,0,'1',NULL,'100000007','100000013'),(7,'softnotions_gvk_July1_saveasopp',8,NULL,NULL,0,1,'2024-07-02 00:21:11','2024-07-02 00:22:19',NULL,NULL,NULL,6514.50,0,NULL,NULL,1,NULL,0,5,NULL,17,'common_carrier','QH-06044','3c7787da-da37-ef11-8409-000d3a581698',0,NULL,1,'2024-07-02 00:21:11',6,NULL,0,'1',NULL,'100000007','100000013'),(8,'softnotions_hrisnkr_test_opportunity_nameeee',NULL,NULL,NULL,2,1,'2024-07-02 10:20:45','2024-07-02 10:20:45',NULL,NULL,NULL,NULL,0,'2025-01-02 10:20:45',NULL,1,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2024-07-02 10:20:45',NULL,NULL,0,'1',NULL,NULL,NULL);

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `role_permission_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int DEFAULT NULL,
  `page_id` int DEFAULT NULL,
  `page_field_id` int DEFAULT NULL,
  `view` tinyint(1) DEFAULT NULL,
  `add` tinyint(1) DEFAULT NULL,
  `edit` tinyint(1) DEFAULT NULL,
  `delete` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`role_permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5938 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_permissions`
--

INSERT INTO `role_permissions` VALUES (72,3,2,NULL,NULL,1,NULL,NULL),(73,3,4,NULL,NULL,1,NULL,NULL),(75,3,14,NULL,NULL,1,1,NULL),(76,3,15,NULL,NULL,1,1,NULL),(77,3,16,NULL,NULL,1,1,NULL),(78,3,18,NULL,NULL,1,1,NULL),(122,14,1,NULL,NULL,NULL,NULL,1),(124,15,8,NULL,1,1,1,NULL),(126,15,17,NULL,1,1,1,NULL),(127,NULL,5,NULL,1,NULL,NULL,NULL),(128,NULL,5,NULL,1,NULL,NULL,NULL),(129,NULL,2,NULL,NULL,NULL,1,NULL),(183,17,2,NULL,1,NULL,NULL,NULL),(184,17,14,NULL,1,NULL,NULL,NULL),(185,9,13,NULL,1,NULL,NULL,NULL),(186,9,14,NULL,1,NULL,NULL,NULL),(187,9,16,NULL,1,NULL,NULL,NULL),(188,9,17,NULL,1,1,1,1),(195,11,11,NULL,1,NULL,NULL,NULL),(196,13,NULL,5,1,NULL,NULL,NULL),(197,13,8,NULL,1,1,NULL,NULL),(198,13,18,NULL,1,NULL,NULL,NULL),(211,6,5,NULL,1,NULL,1,NULL),(212,6,6,NULL,1,NULL,NULL,NULL),(213,6,8,NULL,1,1,1,NULL),(214,6,9,NULL,NULL,1,1,NULL),(216,6,13,NULL,1,1,1,1),(217,5,9,NULL,1,NULL,NULL,NULL),(223,12,7,NULL,1,NULL,NULL,NULL),(224,12,8,NULL,1,1,1,NULL),(231,8,17,NULL,1,1,1,NULL),(278,18,NULL,1,1,1,1,1),(279,18,NULL,2,1,1,1,1),(280,18,NULL,3,1,1,1,1),(281,18,NULL,4,1,1,1,1),(282,18,NULL,5,1,1,1,1),(283,18,1,NULL,1,1,1,1),(284,18,2,NULL,1,1,1,1),(285,18,3,NULL,1,1,1,1),(286,18,4,NULL,1,1,1,1),(287,18,5,NULL,1,1,1,1),(288,18,6,NULL,1,1,1,1),(289,18,7,NULL,1,1,1,1),(290,18,8,NULL,1,1,1,1),(291,18,9,NULL,1,1,1,1),(293,18,11,NULL,1,1,1,1),(294,18,12,NULL,1,1,1,1),(295,18,13,NULL,1,1,1,1),(296,18,14,NULL,1,1,1,1),(297,18,15,NULL,1,1,1,1),(298,18,16,NULL,1,1,1,1),(299,18,17,NULL,1,1,1,1),(300,18,18,NULL,1,1,1,1),(321,20,13,NULL,NULL,1,1,1),(322,21,2,NULL,1,1,1,1),(323,22,6,NULL,1,1,1,NULL),(324,23,1,NULL,NULL,1,1,NULL),(328,24,2,NULL,NULL,NULL,1,NULL),(329,24,3,NULL,NULL,1,1,NULL),(330,24,4,NULL,NULL,1,NULL,1),(331,25,6,NULL,NULL,NULL,1,1),(332,25,7,NULL,NULL,1,1,NULL),(345,19,1,NULL,1,1,NULL,NULL),(363,26,NULL,1,1,1,1,1),(364,26,NULL,2,1,1,1,1),(365,26,NULL,3,1,1,1,1),(366,26,NULL,4,1,1,1,1),(367,26,NULL,5,1,1,1,1),(368,26,1,NULL,1,1,1,1),(369,26,2,NULL,1,1,1,1),(370,26,3,NULL,1,1,1,1),(371,26,4,NULL,1,1,1,1),(372,26,5,NULL,1,1,1,1),(373,26,6,NULL,1,1,1,1),(374,26,7,NULL,1,1,1,1),(375,26,8,NULL,1,1,1,1),(376,26,9,NULL,1,1,1,1),(378,26,11,NULL,1,1,1,1),(379,26,12,NULL,1,1,1,1),(380,26,13,NULL,1,1,1,1),(381,26,14,NULL,1,1,1,1),(382,26,15,NULL,1,1,1,1),(383,26,16,NULL,1,1,1,1),(384,26,17,NULL,1,1,1,1),(385,26,18,NULL,1,1,1,1),(386,27,2,NULL,NULL,NULL,NULL,1),(409,28,1,NULL,NULL,NULL,1,1),(410,28,11,NULL,NULL,1,NULL,NULL),(413,29,2,NULL,1,NULL,NULL,NULL),(647,30,1,NULL,NULL,NULL,1,NULL),(648,10,7,NULL,1,1,1,NULL),(650,10,11,NULL,1,NULL,NULL,NULL),(651,10,17,NULL,1,NULL,NULL,NULL),(652,31,2,NULL,NULL,1,NULL,NULL),(653,31,3,NULL,1,NULL,NULL,NULL),(654,32,5,NULL,1,NULL,NULL,NULL),(655,32,6,NULL,NULL,1,NULL,NULL),(657,32,12,NULL,1,NULL,NULL,NULL),(666,7,8,NULL,1,1,1,1),(667,7,9,NULL,1,1,1,1),(669,7,17,NULL,1,1,1,NULL),(671,34,1,NULL,1,NULL,NULL,NULL),(684,35,6,NULL,1,NULL,NULL,NULL),(888,36,1,NULL,NULL,NULL,NULL,1),(889,37,1,NULL,NULL,NULL,1,NULL),(890,38,1,NULL,NULL,1,NULL,NULL),(906,16,8,NULL,1,1,1,NULL),(908,16,16,NULL,1,NULL,NULL,NULL),(932,39,1,NULL,NULL,NULL,1,NULL),(933,40,NULL,1,NULL,1,NULL,NULL),(934,40,NULL,2,NULL,1,NULL,NULL),(935,40,NULL,3,NULL,1,NULL,NULL),(936,40,NULL,4,NULL,1,NULL,NULL),(937,40,NULL,5,NULL,1,NULL,NULL),(938,40,13,NULL,1,1,NULL,NULL),(939,40,17,NULL,NULL,1,NULL,NULL),(1127,43,1,NULL,1,1,1,1),(1444,45,1,NULL,1,1,1,1),(1445,46,9,NULL,1,NULL,NULL,NULL),(1592,1,NULL,1,1,1,1,1),(1593,1,NULL,2,1,1,1,1),(1594,1,NULL,3,1,1,1,1),(1595,1,NULL,4,1,1,1,1),(1596,1,NULL,5,1,1,1,1),(1597,1,1,NULL,1,1,1,1),(1598,1,2,NULL,1,1,1,1),(1599,1,3,NULL,1,1,1,1),(1600,1,4,NULL,1,1,1,1),(1601,1,5,NULL,1,1,1,1),(1602,1,6,NULL,1,1,1,1),(1603,1,7,NULL,1,1,1,1),(1604,1,8,NULL,1,1,1,1),(1605,1,9,NULL,1,1,1,1),(1606,1,11,NULL,1,1,1,1),(1607,1,12,NULL,1,1,1,1),(1608,1,13,NULL,1,1,1,1),(1609,1,14,NULL,1,1,1,1),(1610,1,15,NULL,1,1,1,1),(1611,1,16,NULL,1,1,1,1),(1612,1,17,NULL,1,1,1,1),(1613,1,18,NULL,1,1,1,1),(1627,2,NULL,2,1,1,1,1),(1628,2,NULL,4,1,1,1,NULL),(1629,2,3,NULL,1,1,1,NULL),(1630,2,8,NULL,1,1,1,NULL),(1631,2,9,NULL,1,1,1,NULL),(1632,2,11,NULL,1,NULL,NULL,NULL),(1633,2,12,NULL,1,NULL,NULL,NULL),(1634,2,13,NULL,1,1,1,NULL),(1635,2,14,NULL,1,NULL,NULL,NULL),(1636,2,15,NULL,1,NULL,NULL,NULL),(1637,2,17,NULL,1,1,1,NULL),(1638,2,18,NULL,1,1,NULL,NULL),(1639,47,7,NULL,1,1,1,NULL),(1684,48,1,NULL,1,NULL,NULL,NULL),(1685,48,4,NULL,1,1,1,1),(1686,48,17,NULL,1,1,1,1),(1687,44,NULL,1,1,NULL,NULL,NULL),(1688,44,NULL,2,1,NULL,NULL,NULL),(1689,44,NULL,3,1,NULL,NULL,NULL),(1690,44,NULL,4,1,NULL,NULL,NULL),(1691,44,NULL,5,1,NULL,NULL,NULL),(1692,44,1,NULL,1,1,1,1),(1693,44,2,NULL,1,1,1,1),(1694,44,3,NULL,1,1,1,1),(1695,44,4,NULL,1,1,1,1),(1696,44,5,NULL,1,1,1,1),(1697,44,6,NULL,1,1,1,1),(1698,44,7,NULL,1,1,1,1),(1699,44,8,NULL,1,1,1,1),(1700,44,9,NULL,1,1,1,1),(1701,44,11,NULL,1,1,1,1),(1702,44,12,NULL,1,1,1,1),(1703,44,13,NULL,1,NULL,NULL,NULL),(1704,44,14,NULL,1,1,1,1),(1705,44,15,NULL,1,NULL,NULL,NULL),(1706,44,16,NULL,1,1,1,1),(1707,44,17,NULL,1,1,1,1),(1708,44,18,NULL,1,NULL,NULL,NULL),(1775,49,NULL,1,NULL,1,1,NULL),(1776,49,NULL,2,NULL,1,1,NULL),(1777,49,NULL,3,NULL,1,1,NULL),(1778,49,NULL,4,NULL,1,1,NULL),(1779,49,7,NULL,1,NULL,NULL,NULL),(1780,49,9,NULL,1,NULL,NULL,NULL),(1781,49,12,NULL,1,NULL,NULL,NULL),(1782,49,17,NULL,1,1,1,NULL),(1783,49,18,NULL,1,NULL,NULL,NULL),(1784,50,NULL,3,NULL,1,NULL,NULL),(1785,50,1,NULL,NULL,1,NULL,NULL),(1786,50,2,NULL,NULL,1,1,1),(1787,50,3,NULL,NULL,NULL,1,1),(1788,50,4,NULL,NULL,NULL,1,NULL),(1789,50,18,NULL,NULL,NULL,1,NULL),(1790,51,13,NULL,1,1,1,NULL),(1791,51,17,NULL,1,NULL,NULL,NULL),(1792,51,18,NULL,1,1,NULL,NULL),(1793,52,1,NULL,1,1,NULL,NULL),(1794,53,1,NULL,1,NULL,NULL,NULL),(1795,53,2,NULL,1,NULL,NULL,NULL),(1796,53,3,NULL,1,NULL,NULL,NULL),(1797,53,4,NULL,1,NULL,NULL,NULL),(1798,53,5,NULL,1,NULL,NULL,NULL),(1799,53,6,NULL,1,NULL,NULL,NULL),(1800,53,7,NULL,1,NULL,NULL,NULL),(1801,53,8,NULL,1,NULL,NULL,NULL),(1802,53,9,NULL,1,NULL,NULL,NULL),(1803,53,11,NULL,1,NULL,NULL,NULL),(1804,53,12,NULL,1,NULL,NULL,NULL),(1805,53,13,NULL,1,NULL,NULL,NULL),(1806,53,14,NULL,1,NULL,NULL,NULL),(1807,53,15,NULL,1,NULL,NULL,NULL),(1808,53,16,NULL,1,NULL,NULL,NULL),(1809,53,17,NULL,1,NULL,NULL,NULL),(1810,53,18,NULL,1,NULL,NULL,NULL),(2038,41,NULL,1,1,NULL,NULL,NULL),(2039,41,NULL,2,1,1,NULL,NULL),(2040,41,NULL,3,1,NULL,NULL,NULL),(2041,41,NULL,4,1,1,1,NULL),(2042,41,NULL,5,1,1,1,NULL),(2043,41,3,NULL,1,NULL,NULL,NULL),(2044,41,8,NULL,1,1,1,NULL),(2045,41,9,NULL,1,1,1,NULL),(2046,41,11,NULL,1,NULL,NULL,NULL),(2047,41,12,NULL,1,NULL,NULL,NULL),(2048,41,13,NULL,1,1,1,NULL),(2049,41,14,NULL,1,NULL,NULL,NULL),(2050,41,15,NULL,1,NULL,NULL,NULL),(2051,41,17,NULL,1,1,1,NULL),(2052,41,18,NULL,1,1,NULL,NULL),(3288,42,NULL,1,1,NULL,NULL,NULL),(3289,42,NULL,2,1,1,NULL,NULL),(3290,42,NULL,3,1,NULL,NULL,NULL),(3291,42,NULL,4,1,1,1,NULL),(3292,42,NULL,5,1,1,1,NULL),(3293,42,2,NULL,1,NULL,NULL,NULL),(3294,42,4,NULL,1,NULL,NULL,NULL),(3295,42,5,NULL,1,NULL,NULL,NULL),(3296,42,6,NULL,1,NULL,NULL,NULL),(3297,42,7,NULL,1,NULL,NULL,NULL),(3298,42,8,NULL,1,1,1,NULL),(3299,42,9,NULL,1,1,1,NULL),(3300,42,11,NULL,1,NULL,NULL,NULL),(3301,42,12,NULL,1,NULL,NULL,NULL),(3302,42,13,NULL,1,1,1,NULL),(3303,42,14,NULL,1,NULL,NULL,NULL),(3304,42,15,NULL,1,NULL,NULL,NULL),(3305,42,17,NULL,1,1,1,NULL),(3306,42,18,NULL,1,1,NULL,NULL),(5891,54,NULL,1,NULL,1,1,1),(5892,54,NULL,2,NULL,1,1,1),(5893,54,NULL,3,1,1,1,NULL),(5894,54,NULL,4,1,1,1,NULL),(5895,54,NULL,5,1,1,1,NULL),(5896,54,1,NULL,1,1,1,NULL),(5897,54,2,NULL,1,1,1,NULL),(5898,54,3,NULL,1,1,1,NULL),(5899,54,4,NULL,1,1,1,NULL),(5900,54,5,NULL,1,1,1,NULL),(5901,54,6,NULL,1,1,1,1),(5902,54,7,NULL,1,1,1,NULL),(5903,54,8,NULL,1,1,1,NULL),(5904,54,9,NULL,1,1,1,1),(5905,54,11,NULL,1,1,1,NULL),(5906,54,12,NULL,1,1,1,1),(5907,54,13,NULL,1,1,1,1),(5908,54,14,NULL,1,1,1,NULL),(5909,54,15,NULL,1,1,1,1),(5910,54,16,NULL,1,1,1,NULL),(5911,54,17,NULL,1,1,1,NULL),(5912,54,18,NULL,1,1,1,1),(5913,54,19,NULL,1,NULL,NULL,NULL),(5914,33,NULL,1,1,1,1,NULL),(5915,33,NULL,2,1,1,1,NULL),(5916,33,NULL,3,1,1,1,NULL),(5917,33,NULL,4,1,1,1,NULL),(5918,33,NULL,5,NULL,1,1,NULL),(5919,33,1,NULL,1,1,1,NULL),(5920,33,2,NULL,1,1,1,NULL),(5921,33,3,NULL,1,1,1,NULL),(5922,33,4,NULL,1,1,1,NULL),(5923,33,5,NULL,1,1,1,NULL),(5924,33,6,NULL,1,1,1,NULL),(5925,33,7,NULL,1,1,1,NULL),(5926,33,8,NULL,1,1,1,NULL),(5927,33,9,NULL,1,1,1,NULL),(5928,33,11,NULL,1,1,1,NULL),(5929,33,12,NULL,1,1,1,NULL),(5930,33,13,NULL,1,1,1,NULL),(5931,33,14,NULL,1,1,1,NULL),(5932,33,15,NULL,1,1,1,NULL),(5933,33,16,NULL,1,1,1,NULL),(5934,33,17,NULL,1,1,1,NULL),(5935,33,18,NULL,1,1,1,1),(5936,33,19,NULL,1,NULL,NULL,NULL),(5937,33,20,NULL,1,NULL,NULL,NULL);

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

CREATE TABLE `roles` (
  `role_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `owner_user` int DEFAULT NULL,
  `is_deleted` int NOT NULL DEFAULT '0',
  `user_type` tinyint(1) DEFAULT NULL,
  `is_published` int DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Super Admin','Super administrator of the site','2017-11-01 00:00:00','2020-05-11 16:02:24',NULL,0,NULL,NULL),(2,'Partner Admin','The core partner admin role','2020-09-02 00:00:00','2020-05-11 16:01:56',NULL,0,NULL,NULL),(3,'Customer','The core customer role','2020-09-17 00:00:00','2020-06-25 15:00:42',NULL,0,NULL,NULL),(5,'test','test role t','2019-09-06 07:53:15','2020-05-05 15:00:59',1,1,2,NULL),(6,'Estimator','estimator','2019-09-06 09:50:24','2020-05-05 15:02:07',1,1,2,NULL),(7,'Sales person','Sales person','2019-09-06 09:53:30','2020-05-05 15:07:47',1,1,1,NULL),(8,'Project manager','Project manager','2019-09-06 09:54:10','2020-05-05 15:01:52',1,1,2,NULL),(9,'Design manager','Design manager','2019-09-06 09:55:02','2020-01-09 18:35:31',1,1,1,NULL),(10,'Production clerk','Production clerk','2019-09-06 09:57:24','2020-05-05 15:03:15',1,1,1,NULL),(11,'Installer','Installer','2019-09-06 09:58:01','2020-05-05 15:02:33',1,1,2,NULL),(12,'Partner accounting','Partner accounting','2019-09-06 09:58:41','2020-05-05 15:03:22',1,1,1,NULL),(13,'Installer2','Installer2','2019-09-06 11:10:35','2020-05-05 15:02:26',6,1,2,NULL),(14,'sad','zdsfdf','2019-11-05 10:34:19','2019-11-08 12:42:20',17,1,NULL,NULL),(15,'Salesperson','test','2019-11-05 16:58:36','2020-01-03 16:06:16',17,1,NULL,NULL),(16,'sales manager','test','2019-12-26 11:40:03','2020-05-05 15:01:25',1,1,2,NULL),(17,'Role_tab','Test','2019-12-30 14:47:05','2020-01-03 16:06:07',1,1,1,NULL),(18,'dummy_admin','dummy admin','2020-01-10 10:43:11','2020-05-05 15:03:05',1,1,1,NULL),(19,'dummy_role','dummy role','2020-01-10 10:59:29','2020-04-19 13:12:12',1,1,1,NULL),(20,'del role','test','2020-01-10 17:07:58','2020-01-10 17:08:23',1,1,1,NULL),(21,'deletechk','dfdfd','2020-01-13 10:34:51','2020-01-13 10:35:55',1,1,1,NULL),(22,'role1','role1','2020-01-27 16:17:30','2020-01-27 17:34:34',1,1,1,NULL),(23,'test23','tes','2020-01-27 17:35:16','2020-01-27 17:35:31',1,1,2,NULL),(24,'role123','test','2020-01-27 17:36:06','2020-04-21 21:16:30',1,1,1,NULL),(25,'role_dumm','test','2020-01-28 11:44:01','2020-05-05 15:01:32',1,1,1,NULL),(26,'The Testing Admin','yesss','2020-02-17 17:56:41','2020-05-05 15:00:52',199,1,1,NULL),(27,'Product Development',NULL,'2020-02-19 18:09:32','2020-05-05 15:01:42',1,1,2,NULL),(28,'wholeprochk','test','2020-03-04 14:54:02','2020-03-04 14:54:22',1,1,2,NULL),(29,'test_123','Lorem Ipsum is simply dum','2020-03-06 16:37:51','2020-04-19 13:09:17',1,1,1,NULL),(30,'Product Development','test','2020-03-10 17:04:17','2020-04-03 12:46:50',1,1,2,NULL),(31,'admin_role','gg','2020-03-12 13:43:22','2020-05-05 15:00:24',1,1,1,NULL),(32,'partner_role','gg','2020-03-12 13:43:43','2020-05-05 15:02:17',1,1,2,NULL),(33,'Allied Admin','Allied admin','2020-04-03 11:11:25','2022-02-21 19:52:23',1,0,1,1),(34,'Lorem Ipsum is simply dummy text of the pr','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the i','2020-04-05 11:19:18','2020-04-05 11:19:34',1,1,1,NULL),(35,'Analyzer_new','test','2020-04-07 15:56:34','2020-04-19 13:08:31',325,1,2,NULL),(36,'delchk','vc nc','2020-04-19 13:13:04','2020-04-19 13:13:16',1,1,2,NULL),(37,'delchk','vcnvc','2020-04-19 13:14:11','2020-04-19 13:14:21',1,1,2,NULL),(38,'test233','test','2020-04-21 21:19:27','2020-04-21 21:20:47',1,1,1,NULL),(39,'test2331','tesr','2020-04-30 14:07:36','2020-04-30 14:08:03',1,1,2,NULL),(40,'Brand A Role','This role is sprcdsfsd sdfsdfsdfsdfsd','2020-04-30 19:13:53','2020-05-05 15:00:41',1,1,2,NULL),(41,'Partner User','Partner internal user','2020-05-05 15:10:29','2020-05-11 16:16:27',1,0,2,NULL),(42,'Allied User','Allied User','2020-05-11 15:58:06','2020-05-11 15:58:06',1,0,1,NULL),(43,'dummytest','test','2020-05-12 16:22:50','2020-05-12 17:09:49',1,1,1,NULL),(44,'Ed Test Admin','Ed Test Admin Full Access','2020-06-23 17:13:40','2021-02-19 12:24:19',1,1,1,NULL),(45,'uicheck','uichk','2020-06-25 12:22:15','2020-06-25 18:45:51',1,1,1,NULL),(46,'testui_role','test','2020-06-25 19:42:18','2020-06-25 19:43:25',1,1,1,NULL),(47,'Account Manager',NULL,'2020-09-24 19:36:15','2020-09-24 19:36:15',1,0,1,NULL),(48,'Test Role Admin','Test','2021-02-03 10:27:35','2021-04-13 12:19:48',1,1,1,NULL),(49,'test role import',NULL,'2021-04-13 12:20:37','2021-04-13 12:26:26',1,1,1,NULL),(50,'user',NULL,'2021-11-04 22:17:52','2021-11-04 22:18:47',1,1,1,NULL),(51,'allied user','allied user partner','2021-11-05 10:38:04','2021-11-05 12:58:39',226,1,2,NULL),(52,'abc',NULL,'2021-11-16 10:35:19','2021-11-16 10:35:29',1,1,2,NULL),(53,'publishrole','test','2022-02-21 17:57:22','2022-02-21 17:57:22',1,0,1,1),(54,'Test 23','Test roles','2022-03-11 15:31:55','2022-03-16 16:06:37',409,0,1,NULL);

--
-- Table structure for table `rule_categories`
--

CREATE TABLE `rule_categories` (
  `rule_category_id` int NOT NULL,
  `rule_id` int NOT NULL,
  `category_id` int NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rule_categories`
--


--
-- Table structure for table `rules`
--

CREATE TABLE `rules` (
  `rule_id` int NOT NULL,
  `rule_description` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rule_message` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rules`
--


--
-- Table structure for table `shapes`
--

CREATE TABLE `shapes` (
  `shape_id` int NOT NULL AUTO_INCREMENT,
  `shape_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shape_icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `building_story` tinyint(1) DEFAULT NULL,
  `shapescol` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`shape_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shapes`
--


--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `state_id` int NOT NULL AUTO_INCREMENT,
  `state_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  PRIMARY KEY (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--


--
-- Table structure for table `todos`
--

CREATE TABLE `todos` (
  `todo_id` int NOT NULL AUTO_INCREMENT,
  `todo_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `todo_description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `todo_assigned_to` int DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `todo_startdate` date DEFAULT NULL,
  `todo_enddate` date DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT '0',
  `note` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`todo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `todos`
--


--
-- Table structure for table `transaction_table`
--

CREATE TABLE `transaction_table` (
  `transaction_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `api_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `imei` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_on` datetime NOT NULL,
  `updated_on` datetime NOT NULL,
  `device_type` tinyint(1) DEFAULT NULL,
  `osversion` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction_table`
--

INSERT INTO `transaction_table` VALUES (1,1,'QVMyend5Sjk4RTZkZUxMMzF4RHV5c1U0MXJsYlNZbTY5TDJPMjh3SzdQYW9Tbk1nWGN4TFNOR1Y3bUda6682700755454',NULL,'2024-07-01 14:29:51','2024-07-01 14:29:51',NULL,NULL),(2,1,'MnE1bWRadGliYTVpeTZtdDJFVkM3MFkzdDljTzZQeFk5NkJ2MjZSMFpma3FEQWJ4TTNtV2loYng1bHRt6682767cc1833',NULL,'2024-07-01 14:57:24','2024-07-01 14:57:24',NULL,NULL),(3,1,'MXg2eVlieFdBbzVyajhsS2dlWGRtTGxKS2lQYTZKTUFEOVFaNThMQm1PejNKQnVtY0dnMlQxSnZ4Y3RP6682767cc771d',NULL,'2024-07-01 14:57:25','2024-07-01 14:57:25',NULL,NULL),(4,1,NULL,NULL,'2024-07-01 17:27:59','2024-07-01 17:27:59',NULL,NULL),(5,1,'QW95c3R6bVpxMEF0THRRNWN4dHlqSVd0VVJSMVppdmtFUEtLNGZFbnNHSW9Sb1NuMU1xUEc5TmdVWlFB6682a08250080',NULL,'2024-07-01 17:56:42','2024-07-01 17:56:42',NULL,NULL),(6,1,'czVrMU1uMDNFMElPVUNiT0FTdkxXQ2kyd0ptaVgyTDdORUY4bUJxeWc5SlhDNHdJUkFRTEdRYkhyRFk56682a1e85e021',NULL,'2024-07-01 18:02:40','2024-07-01 18:02:40',NULL,NULL),(7,1,'bnhGVlVKSlJTZU1jVkRZMTBSSVR5QVNLSmtxcHd6b09YYlQ5TUllemJVbHVGb1VObkFxSXBpUmxXdFhl6682d02f7ed5b',NULL,'2024-07-01 21:20:07','2024-07-01 21:20:07',NULL,NULL),(8,1,'a2dqcHdNQndJUFVYSDVvbTdkeFZlTnlSRjFCVkZvaXB0UDhFTmhnSmhwaklzWXhFN0JNRTA5blp3M3lH6682d3e57310a',NULL,'2024-07-01 21:35:57','2024-07-01 21:35:57',NULL,NULL),(9,1,'enU4TVhibjllT01KdzhMRmpPQ3NwVTNmb2pET1JCMjA5QU5aQlI4QjI2NE9kRW8zYUJRTDJna2trVzZn6682e49f11d9b',NULL,'2024-07-01 22:47:19','2024-07-01 22:47:19',NULL,NULL),(10,1,'cWZhajBTVllEUEtnaHRSckFURGZqR25UU1VUdXI0R05SandnOG9PZHFybEt6V2hpRnp6eFNicjY4RGJt6682f1b59adf8',NULL,'2024-07-01 23:43:09','2024-07-01 23:43:09',NULL,NULL),(11,1,'YU52clBOR0hDZnpiUWZ1aEhldWhXdXhOdENEMDk1RGhadmkwYWNMUXVZN2FOZEEwYzkwWWJ4Q2E0RXQ06683870786e57',NULL,'2024-07-02 10:20:15','2024-07-02 10:20:15',NULL,NULL);

--
-- Table structure for table `tutorials`
--

CREATE TABLE `tutorials` (
  `tutorial_id` int NOT NULL AUTO_INCREMENT,
  `tutorial_name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tutorial_description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tutorial_content` text COLLATE utf8mb4_unicode_ci,
  `tutorial_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`tutorial_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tutorials`
--

INSERT INTO `tutorials` VALUES (1,'Eco friendly modular','Stone Brewing Company recently worked with Allied Modular to maximize space in their warehouse.  Through the use of modular construction they were able to accomplish this construction incredibly quick using eco friendly building methods.','<!--StartFragment--><span style=\"color: rgb(13, 13, 13); font-family: Roboto, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(249, 249, 249); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">Stone Brewing Company recently worked with Allied Modular to maximize space in their warehouse.  Through the use of modular construction they were able to accomplish this construction incredibly quick using eco friendly building methods. qq</span><!--EndFragment-->','https://www.youtube.com/embed/g5yxt5G5DPY',1,1,'2019-09-06 06:55:59','2022-03-22 18:53:29',0),(2,'Allied modular overview - Youtube','Would you like to learn more about maximizing space and environmentally friendly construction?','<p>\n\n<span>Would you like to learn more about maximizing space and environmentally friendly construction?  \n\nCall us today at 888-836-7850 or visit our website: www.alliedmodular.com</span>\n\n</p><p></p><p>\n\n<span>Would you like to learn more about maximizing space and environmentally friendly construction?  \n\nCall us today at 888-836-7850 or visit our website: www.alliedmodular.com</span>\n\n</p><p></p><p>\n\n<span>Would you like to learn more about maximizing space and environmentally friendly construction?  \n\nCall us today at 888-836-7850 or visit our website: www.alliedmodular.com</span>\n\n</p>','https://www.youtube.com/embed/ObE5nFwHVMo',1,1,'2019-09-06 07:06:02','2019-09-06 07:06:50',0),(3,'Amazing Motorized Modular Machine Enclosure','Amazing Motorized Modular Machine Enclosure','<p>\n\n<span><em>Amazing Motorized Modular Machine Enclosure</em>\n</span></p><p><span>\n\n\nWould you like to learn more about maximizing space and environmentally friendly construction?</span></p><p></p><p><span> </span></p><p></p><p><span> \n\nCall us today at 888-836-7850 or visit our website: www.alliedmodular.com</span></p><p></p><p><span></span>\n\n</p>','https://www.youtube.com/embed/wxrIwCQVqRY',1,1,'2019-09-06 07:09:13','2019-09-06 07:09:23',0),(4,'Allied Modular Modular Buildings','Allied Modular Modular Buildings and Office Construction','<!--StartFragment--><p style=\"box-sizing: border-box; margin: 0px 0px 9px; line-height: 1.9; color: rgb(85, 85, 85); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" initial;\"=\"\">Most employers are looking to get the most productivity and hard work out of their employees. One of the unique ways to do this is to provide a break room. Many studies have actually shown that taking a break is great for productivity.</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; line-height: 1.9; color: rgb(85, 85, 85); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" initial;\"=\"\">Allied’s break rooms are made using state-of-the-art modular construction. This makes for a quick install and can be an easy addition to your facility. We love these<span>&nbsp;</span><a href=\"https://alliedmodular.com/products/lunch-rooms/\" style=\"box-sizing: border-box; text-decoration: none; color: rgb(118, 171, 232);\">break rooms</a><span>&nbsp;</span>so much that we have them installed at all of our facilities! It is where our staff takes their breaks and eat their meals. These lunch rooms are highly functional and customizable.</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; line-height: 1.9; color: rgb(85, 85, 85); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" initial;\"=\"\">Head over to our<span>&nbsp;</span><a href=\"https://alliedmodular.com/products/lunch-rooms/\" style=\"box-sizing: border-box; text-decoration: none; color: rgb(118, 171, 232);\">website</a><span>&nbsp;</span>to learn more!</p><!--EndFragment-->','https://www.youtube.com/embed/2lu412HOluI',1,1,'2019-09-06 07:14:31','2019-09-06 07:14:31',0),(5,'Wheel pros time lapse','Wheel pros time lapse','<!--StartFragment--><p style=\"box-sizing: border-box; margin: 0px 0px 10px; color: rgb(106, 108, 111); font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;\">Wheel pros time lapse</p><p style=\"box-sizing: border-box; margin: 0px 0px 10px; color: rgb(106, 108, 111); font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;\"><br style=\"box-sizing: border-box;\"><br style=\"box-sizing: border-box;\"></p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: 1.9; color: rgb(85, 85, 85); font-family: &quot;PT Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 200; text-align: start; background-color: rgb(255, 255, 255);\">One of the often-cited positive aspects of Allied’s modular building systems is the speed and ease of&nbsp;design, but just what does that actually suggest? One thing it indicates is cash savings. Speed has a genuine impact on the bottom line, in manner ins which are apparent and also in some that you could not understand.</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: 1.9; color: rgb(85, 85, 85); font-family: &quot;PT Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 200; text-align: start; background-color: rgb(255, 255, 255);\">First off, if the structure becomes part of a commercial enterprise, th<img class=\"wp-image-1728 alignleft\" src=\"https://alliedmodular.com/blog/wp-content/uploads/2016/02/WheelPros-3.jpg\" alt=\"\" width=\"500\" height=\"333\" style=\"box-sizing: border-box; vertical-align: middle; border: 0px; position: relative; float: left; margin: 5px 20px 20px 0px;\">en it’s component of the procedure of making money … when it is in solution. Whether it’s in solution or not, it’s setting you back cash in property taxes, insurance coverage, as well as perhaps financings, also while it’s still incomplete. So, the sooner you get a new structure right into service, the sooner it begins off-setting its prices and also assisting to make cash.</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: 1.9; color: rgb(85, 85, 85); font-family: &quot;PT Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 200; text-align: start; background-color: rgb(255, 255, 255);\">After that there’s the effect of speed on the expense of</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: 1.9; color: rgb(85, 85, 85); font-family: &quot;PT Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 200; text-align: start; background-color: rgb(255, 255, 255);\">building. When putting up a modular building, labor is the most significant cost savings. The longer it requires to create, the even more man-hours are invested, the greater the labor expenses. Jobsite labor is generally the most expensive. Prefabrication means quicker onsite building, and less onsite labor.</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: 1.9; color: rgb(85, 85, 85); font-family: &quot;PT Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 200; text-align: start; background-color: rgb(255, 255, 255);\">Quick construction additionally decreases service provider’s overhead. The service provider has insurance coverage, possibly leased tools, financings with mounting passion, and also other time-based costs that he needs to pass on to the proprietor. Fast design lowers those costs and also enables the professional to make a much more competitive proposal.</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: 1.9; color: rgb(85, 85, 85); font-family: &quot;PT Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 200; text-align: start; background-color: rgb(255, 255, 255);\">Where does the speed originated from? Primarily, from the performance of the system itself. Prefabrication in a manufacturing facility setting with contemporary manufacturing methods is quite quick. Onsite erection of premade parts is similarly quick, because it does away with a lot of the labor-intensive onsite jobs related to various other building systems.</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: 1.9; color: rgb(85, 85, 85); font-family: &quot;PT Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 200; text-align: start; background-color: rgb(255, 255, 255);\">Throughout design, there are certain critical points in the process whose timing has a huge impact on the general speed of conclusion. The concrete foundation needs to cure for 28 days to get to 90 % of its ultimate stamina, there’s no speeding it up. With a modular structure system, bulks of the framework are made in the manufacturing facility, and that could happen concurrently with concrete healing. By the time the concrete is ready, much of the building’s framework has actually currently been developed, and also simply awaits erecting onsite. This is among the resources of speed.</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: 1.9; color: rgb(85, 85, 85); font-family: &quot;PT Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 200; text-align: start; background-color: rgb(255, 255, 255);\">Since the building fasts to set up, it can be confined earlier, another crucial point. When the building is enclosed, the various professions function inside, shielded from the aspects. This is one more source of rate.</p><p style=\"box-sizing: border-box; margin: 0px 0px 9px; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: 1.9; color: rgb(85, 85, 85); font-family: &quot;PT Sans&quot;, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; font-weight: 200; text-align: start; background-color: rgb(255, 255, 255);\">So, when planning a new structure, it deserves considering the speed of a modular structure system as more than merely a comfort: it’s likewise an asset. – See even more at: http://www.alliedmodular.com</p><br style=\"box-sizing: border-box; color: rgb(106, 108, 111); font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;\"><!--EndFragment-->','https://www.youtube.com/embed/PePtCzANOWc',1,1,'2019-09-06 07:16:36','2019-09-06 10:55:55',0),(6,'test','test description','test','https://www.youtube.com/embed/PePtCzANOWc',1,1,'2019-09-09 14:49:16','2019-10-23 04:50:17',1),(7,'test tutorial','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and','https://www.youtube.com/embed/PePtCzANOWc',1,1,'2019-09-09 14:49:52','2019-10-23 04:50:28',1),(8,'test tutorial','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and','<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s\nstandard dummy text ever since the 1500s, when an unknown printer took a galley of type and</p>','https://www.youtube.com/embed/PePtCzANOWc',1,1,'2019-09-09 14:49:52','2019-10-23 04:50:47',1),(9,'test tutorial','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and','https://www.youtube.com/embed/PePtCzANOWc',1,1,'2019-09-09 14:49:52','2019-10-23 04:50:24',1),(10,'Allied Modular Modular Buildin','Allied Modular Modular Buildings and Office Construction','<p><meta content=\"text/html; charset=utf-8\">\n<meta content=\"Word.Document\">\n<meta content=\"Microsoft Word 12\">\n<meta content=\"Microsoft Word 12\">\n<link rel=\"File-List\" href=\"file:///C:\\Users\\STPL2\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_filelist.xml\">\n<link rel=\"themeData\" href=\"file:///C:\\Users\\STPL2\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_themedata.thmx\">\n<link rel=\"colorSchemeMapping\" href=\"file:///C:\\Users\\STPL2\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_colorschememapping.xml\">\n\n<style>\n\n</style>\n\n\n\n\n<span>Allied Modular Modular Buildings and Office\nConstruction</span></p><p>&lt;html&gt;<br>&lt;body&gt;<br>&lt;!--StartFragment--&gt;&lt;strong style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: &amp;quot;Open Sans&amp;quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;\"&gt;Lorem Ipsum&lt;/strong&gt;&lt;span style=\"color: rgb(0, 0, 0); font-family: &amp;quot;Open Sans&amp;quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\"&gt;&lt;span&gt;&nbsp;&lt;/span&gt;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum&lt;/span&gt;&lt;!--EndFragment--&gt;<br>&lt;/body&gt;<br>&lt;/html&gt;</p>','https://www.youtube.com/embed/C0DPdy98e4c',1,1,'2019-09-09 14:55:41','2019-10-23 04:50:39',1),(11,'AM4U & Allied Modular: Building the Plant v2','qwer',NULL,'https://www.youtube.com/watch?v=91FL_4uPwho',1,1,'2019-09-30 06:42:11','2019-09-30 06:42:11',0),(12,'Allied Modular Green Construction With AM4U','hdfh',NULL,'https://www.youtube.com/embed/jq8Pg8oKa9s',1,1,'2019-09-30 06:44:52','2019-09-30 06:47:56',0),(13,'dfgdf','dfgdfg','dfgdfg','https://youtu.be/C0DPdy98e4c',1,1,'2019-10-09 13:47:55','2019-10-23 06:43:27',1),(14,'How to create a drawing using sketch method?','test','&lt;html&gt;<br>&lt;body&gt;<br>&lt;!--StartFragment--&gt;&lt;strong style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: &amp;quot;Open Sans&amp;quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;\"&gt;Lorem Ipsum&lt;/strong&gt;&lt;span style=\"color: rgb(0, 0, 0); font-family: &amp;quot;Open Sans&amp;quot;, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\"&gt;&lt;span&gt;&nbsp;&lt;/span&gt;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.&lt;/span&gt;&lt;!--EndFragment--&gt;<br>&lt;/body&gt;<br>&lt;/html&gt;','https://www.youtube.com/embed/C0DPdy98e4c',1,1,'2019-10-22 11:01:17','2020-04-01 18:09:11',1),(15,'THE EXPERTS AGREE ABOUT MODULAR CONSTRUCTION','test ter','<!--StartFragment--><span style=\"color: rgb(85, 85, 85); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" display:=\"\" inline=\"\" !important;=\"\" float:=\"\" none;\"=\"\">The experts agree; construction is changing. What was once the standard of “stick- built” construction has shifted to modular construction for a wide variety of reasons.</span><br style=\"box-sizing: border-box; color: rgb(85, 85, 85); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" initial;\"=\"\"><span style=\"color: rgb(85, 85, 85); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" display:=\"\" inline=\"\" !important;=\"\" float:=\"\" none;\"=\"\">Modular construction is taking the industry by storm as it presents an alternative to construction that is not only more efficient to the build, but also a better solution for the environment. This is achieved through modular’s unique structural wall panels which are fabricated with materials that are resistant to termites, warping, and shrinking.</span><br style=\"box-sizing: border-box; color: rgb(85, 85, 85); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" initial;\"=\"\"><span style=\"color: rgb(85, 85, 85); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" display:=\"\" inline=\"\" !important;=\"\" float:=\"\" none;\"=\"\">While we here at Allied Modular focus on partnering with businesses to provide modular solutions, modular construction is growing in all sectors of construction. Global Construction did a wonderful write up on construction, and you can read more about it<span>&nbsp;</span></span><a href=\"http://www.constructionglobal.com/managementplanning/451/Tougher-stronger-and-longer:-Building-for-the-future\" style=\"box-sizing: border-box; text-decoration: none; color: rgb(118, 171, 232); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);\"=\"\">here</a><span style=\"color: rgb(85, 85, 85); font-family: \" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" display:=\"\" inline=\"\" !important;=\"\" float:=\"\" none;\"=\"\">.</span><!--EndFragment-->','https://youtu.be/PePtCzANOWc',0,1,'2020-04-01 18:07:43','2020-04-01 18:08:51',0),(16,'test','test','test','https://www.youtube.com/watch?v=2mDCVzruYzQ',1,1,'2020-05-12 16:46:54','2020-06-25 17:35:14',1),(17,'Allied','test','<br><br><!--StartFragment--><span pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" display:=\"\" inline=\"\" !important;=\"\" float:=\"\" none;\"=\"\" style=\"box-sizing: border-box; font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; color: rgb(85, 85, 85);\">The experts agree; construction is changing. What was once the standard of “stick- built” construction has shifted to modular construction for a wide variety of reasons.</span><br pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" initial;\"=\"\" style=\"box-sizing: border-box; font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; color: rgb(85, 85, 85);\"><span pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" display:=\"\" inline=\"\" !important;=\"\" float:=\"\" none;\"=\"\" style=\"box-sizing: border-box; font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; color: rgb(85, 85, 85);\">Modular construction is taking the industry by storm as it presents an alternative to construction that is not only more efficient to the build, but also a better solution for the environment. This is achieved through modular’s unique structural wall panels which are fabricated with materials that are resistant to termites, warping, and shrinking.</span><br pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" initial;\"=\"\" style=\"box-sizing: border-box; font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; color: rgb(85, 85, 85);\"><span pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" display:=\"\" inline=\"\" !important;=\"\" float:=\"\" none;\"=\"\" style=\"box-sizing: border-box; font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; color: rgb(85, 85, 85);\">While we here at Allied Modular focus on partnering with businesses to provide modular solutions, modular construction is growing in all sectors of construction. Global Construction did a wonderful write up on construction, and you can read more about it<span style=\"box-sizing: border-box;\">&nbsp;</span></span><a href=\"http://www.constructionglobal.com/managementplanning/451/Tougher-stronger-and-longer:-Building-for-the-future\" pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);\"=\"\" style=\"box-sizing: border-box; background-color: rgb(255, 255, 255); color: rgb(118, 171, 232); text-decoration: none; touch-action: manipulation; font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;\">here</a><span pt=\"\" sans\",=\"\" \"helvetica=\"\" neue\",=\"\" helvetica,=\"\" arial,=\"\" sans-serif;=\"\" font-size:=\"\" 14px;=\"\" font-style:=\"\" normal;=\"\" font-variant-ligatures:=\"\" font-variant-caps:=\"\" font-weight:=\"\" 200;=\"\" letter-spacing:=\"\" orphans:=\"\" 2;=\"\" text-align:=\"\" start;=\"\" text-indent:=\"\" 0px;=\"\" text-transform:=\"\" none;=\"\" white-space:=\"\" widows:=\"\" word-spacing:=\"\" -webkit-text-stroke-width:=\"\" background-color:=\"\" rgb(255,=\"\" 255,=\"\" 255);=\"\" text-decoration-style:=\"\" initial;=\"\" text-decoration-color:=\"\" display:=\"\" inline=\"\" !important;=\"\" float:=\"\" none;\"=\"\" style=\"box-sizing: border-box; font-family: Helvetica, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial; color: rgb(85, 85, 85);\">.</span><!--EndFragment--><br><br>','https://youtu.be/PePtCzANOWc',1,1,'2020-06-25 17:28:52','2022-03-16 18:48:23',0),(18,'test 23','nope','mhvgjhvbh','https://youtu.be/Y5dylh2aOiw',1,409,'2022-03-16 18:47:44','2022-03-16 18:47:56',1),(19,'Kitchen modular','Modullar','kajhfskjnas','https://youtu.be/UWw8sD2Zcls',1,1,'2022-03-22 18:56:18','2022-03-22 18:56:34',0);

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `user_role_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `role_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`user_role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` VALUES (1,1,1,'2020-05-04 00:00:00','2020-05-04 00:00:00'),(2,2,2,NULL,NULL),(3,3,3,NULL,NULL),(4,5,2,NULL,NULL),(5,4,33,NULL,NULL),(6,6,3,NULL,NULL),(7,7,3,NULL,NULL),(8,8,3,NULL,NULL),(9,9,3,NULL,NULL),(10,9,3,NULL,NULL),(11,8,3,NULL,NULL),(12,8,3,NULL,NULL),(13,8,3,NULL,NULL);

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

CREATE TABLE `users` (
  `user_id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `first_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `middle_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `state_id` int DEFAULT NULL,
  `county_id` int DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `last_synched_at` datetime DEFAULT NULL,
  `zip_code` int DEFAULT NULL,
  `avatar` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT 'NUll',
  `zip_id` int DEFAULT NULL,
  `owner_user` int DEFAULT NULL,
  `user_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT '0',
  `crm_contact_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lattitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `telephone2` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone3` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_account_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `api_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone1` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_owner` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner_crm_id` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_zip_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_user` tinyint(1) NOT NULL DEFAULT '0',
  `vertical_market` int DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'josephcaleb8@gmail.com','$2y$10$UiWRzxJqoRafUbnCH5.N.OcfoVA1wBltb6R9RLs7eWKB/Y9pJroTq',1,'Super',NULL,'admin1','address 1',2,2,2,2,'2020-04-03 14:14:14','2022-04-16 09:20:22',NULL,2,'1646214831.1_avatar.jpeg',2,1,'admin',0,'',150.729,150.729,NULL,NULL,'dsf','','sdfds','sdfsd',NULL,NULL,'897457','897456',NULL,NULL,NULL,0,NULL),(2,'idesign@gmail.com','$2y$10$eoAsNDWsDX7aIp2N.wktju1ottvhKr61AQvxGV6kIHeQuh5qMfmhG',1,'idesigner',NULL,'Contact 2','1234 Main\nOrange, CA 92867\nUS',NULL,NULL,NULL,NULL,'2022-08-10 14:47:16','2022-08-10 14:48:02',NULL,NULL,'NUll',NULL,1,'partner',0,'d537c271-eb6b-ee11-8df0-0022482d3d6c',NULL,NULL,NULL,NULL,NULL,'8a3c1b11-6a2d-ea11-a810-000d3a579caa','Corporate Director',NULL,'297956921_1025991744625910_5102789860058982115_n.jpg',NULL,NULL,'(714) 123-4567','CEC Team','5e082419-da29-eb11-a813-000d3a579ca8',NULL,0,NULL),(3,'idesignfsdf@gmail.com','$2y$10$bPB8Sb2W/DD22kL17CA7euOoAyZ2v9/v9kKHVJZPRfT1DrZDUDXxO',0,'Idesigner Customer',NULL,'Contact','12134 Main Street\nOrange, CA 92868\nUS',NULL,NULL,NULL,NULL,'2022-08-10 14:51:29','2022-08-10 14:51:29',NULL,NULL,'NUll',NULL,1,'customer',0,'f0147dae-6b2d-ea11-a810-000d3a579caa',NULL,NULL,NULL,NULL,NULL,'8a3c1b11-6a2d-ea11-a810-000d3a579caa','test',NULL,NULL,NULL,NULL,'7141234589',NULL,NULL,'842591dd-7317-ea11-a811-000d3a579cc4',0,NULL),(4,'djameson@ometro.com','$2y$10$OOd/AmOU.kzfqk7ohaHOz.XYmWTCcH7LEbC/A0m.LWRqB3QVdByrO',1,'David',NULL,'Jameson','2222 Cuming StreetOmaha, NE 68102US',NULL,NULL,NULL,NULL,'2022-08-10 14:53:26','2022-08-10 14:53:26',NULL,NULL,'NUll',NULL,1,'internal_user',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'40234108002510',NULL,NULL,NULL,NULL,0,NULL),(5,'kpeithman@alliedmodular.com','$2y$10$eoAsNDWsDX7aIp2N.wktju1ottvhKr61AQvxGV6kIHeQuh5qMfmhG',1,'Kevin',NULL,'Peithman','642 Nicolas AveOrange, CA 92868US',NULL,NULL,NULL,NULL,'2022-08-10 14:47:16','2022-08-10 14:48:02',NULL,NULL,'NUll',NULL,1,'partner',0,'5e9d7de2-6ba4-de11-88ac-00096b89559c',NULL,NULL,NULL,NULL,NULL,'fc7f59f7-d7c5-da11-8634-00096b89559d','Corporate Director',NULL,'297956921_1025991744625910_5102789860058982115_n.jpg',NULL,NULL,'(714) 123-4567','CEC Team','5e082419-da29-eb11-a813-000d3a579ca8',NULL,0,NULL),(6,'softnotions_devtestjun22@gmail.com','ztkLkH',0,'softnotions',NULL,'devtestjun2224','test Three Rivers MAUS01080\r\nThree Rivers, MA 01080\r\nUS',NULL,NULL,NULL,NULL,'2024-07-01 14:40:05','2024-07-01 14:40:42',NULL,NULL,'NUll',NULL,1,'customer',0,'b5701ee5-ab30-ef11-8409-000d3a581f06',NULL,NULL,NULL,NULL,'test Three Rivers MAUS01080\r\nThree Rivers, MA 01080\r\nUS','0954bf3d-b70d-ef11-9f8a-6045bdf0bc74','test',NULL,NULL,NULL,'203144556','203144556',NULL,NULL,'822591dd-7317-ea11-a811-000d3a579cc4',0,1001),(7,'june13partner@gmail.com','QqvHgH',0,'Softnotions_cust_June13',NULL,'Test','test Three Rivers MAUSThree Rivers, MA 01080US Wales MAUS\r\nWales, MA 01081\r\nUS',NULL,NULL,NULL,NULL,'2024-07-01 14:51:34','2024-07-01 14:55:23',NULL,NULL,'NUll',NULL,1,'customer',0,'7a2ce6aa-6429-ef11-840a-000d3a148ddd',NULL,NULL,NULL,NULL,'test Three Rivers MAUSThree Rivers, MA 01080US Wales MAUS\r\nWales, MA 01081\r\nUS','792ce6aa-6429-ef11-840a-000d3a148ddd',NULL,NULL,NULL,NULL,'8547474747','8547474747',NULL,NULL,'842591dd-7317-ea11-a811-000d3a579cc4',0,1001),(8,'softnotion_test56contact@gmail.com','P1oxDa',0,'softnotion_test56customer',NULL,'tester','testtesttesttest, test 01082United States',NULL,NULL,NULL,NULL,'2024-07-01 18:03:12','2024-07-01 18:03:12',NULL,NULL,'NUll',NULL,1,'customer',0,'9a01791d-a09d-ee11-be37-0022482aa871',NULL,NULL,NULL,NULL,NULL,'7242bcfc-9f9d-ee11-be37-0022482aa871','12345',NULL,NULL,NULL,NULL,'123123123123123',NULL,NULL,NULL,0,1001),(9,'dana@selkirk.com','R2dCo0',0,'Dana',NULL,'Hansen','181 West Aqua AveCoeur D\'Alene, ID 83815US',NULL,NULL,NULL,NULL,'2024-07-01 21:39:13','2024-07-01 23:46:19',NULL,NULL,'NUll',NULL,1,'customer',0,'cded8313-9c29-ef11-840a-000d3a148064',NULL,NULL,NULL,NULL,NULL,'ceed8313-9c29-ef11-840a-000d3a148064','Manufacturing Engineer',NULL,NULL,NULL,NULL,'6232511110',NULL,NULL,NULL,0,1002);

--
-- Table structure for table `users_accounts`
--

CREATE TABLE `users_accounts` (
  `account_id` int NOT NULL AUTO_INCREMENT,
  `account_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lattitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `state` int DEFAULT NULL,
  `city` int DEFAULT NULL,
  `zip_code` int DEFAULT NULL,
  `country` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `county` int DEFAULT NULL,
  `telephone1` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone2` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone3` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_account_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `account_website` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_zip_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` int DEFAULT '0',
  `new_leadsourcecode` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_secleadsourcecode` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accountcategorycode` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users_accounts`
--

INSERT INTO `users_accounts` VALUES (1,'idesign@gmail.com','Idesigner Partner 1','1234 Main\nOrange, CA 92867\nUS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7141234567',NULL,NULL,'8a3c1b11-6a2d-ea11-a810-000d3a579caa','test','2022-08-10 14:47:17','2022-08-10 14:47:17',NULL,'www.test.com','842591dd-7317-ea11-a811-000d3a579cc4',0,NULL,NULL,NULL),(2,'cust@gmail.com','Idesigner Customer','12134 Main Street\nOrange, CA 92868\nUS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7141234589',NULL,NULL,'483d8ec2-8d18-ed11-b83e-000d3a1b03be','sd','2022-08-10 14:51:29','2022-08-10 14:51:29',NULL,'www.test.com','862591dd-7317-ea11-a811-000d3a579cc4',0,NULL,NULL,NULL),(3,'all@alliedmodular.com','Allied Modular','642 W Nicolas Ave\n                Orange, CA 92868\n                US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'7141234589',NULL,NULL,'fc7f59f7-d7c5-da11-8634-00096b89559d','sd','2022-08-10 14:51:29','2022-08-10 14:51:29',NULL,'www.test.com','862591dd-7317-ea11-a811-000d3a579cc4',0,NULL,NULL,NULL),(4,'softnotions_testaccpt09@gmail.com','softnotions_testaccpt09','test Three Rivers MAUS01080\r\nThree Rivers, MA 01080\r\nUS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'203144556',NULL,NULL,'0954bf3d-b70d-ef11-9f8a-6045bdf0bc74',NULL,'2024-07-01 14:40:05','2024-07-01 14:40:44',1,'https://test.com','822591dd-7317-ea11-a811-000d3a579cc4',0,'12','2','100000001'),(5,'june13account@gmail.com','Softnottions_acc_June13','test Three Rivers MAUS01080Three Rivers, MA 01080US Warren MAUS01083\r\nWarren, MA 01083\r\nUS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8547474747',NULL,NULL,'792ce6aa-6429-ef11-840a-000d3a148ddd',NULL,'2024-07-01 14:51:34','2024-07-01 14:55:24',1,'www.partner.idesigner.com','882591dd-7317-ea11-a811-000d3a579cc4',0,'100000015','16','3'),(6,NULL,'softnotion_test56account','testWare, MA 01082US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1231231212',NULL,NULL,'7242bcfc-9f9d-ee11-be37-0022482aa871',NULL,'2024-07-01 18:03:12','2024-07-01 18:03:12',1,NULL,'862591dd-7317-ea11-a811-000d3a579cc4',0,'100000007','100000013','3'),(7,'dana@selkirk.com','Selkirk','181 West Aqua AveCoeur D\'Alene, ID 83815US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'6232511110',NULL,NULL,'ceed8313-9c29-ef11-840a-000d3a148064',NULL,'2024-07-01 21:39:13','2024-07-01 23:46:19',1,NULL,'01832ed6-7417-ea11-a811-000d3a579cc4',0,NULL,NULL,NULL);

--
-- Table structure for table `variants`
--

CREATE TABLE `variants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `variants`
--


--
-- Table structure for table `zip_codes`
--

CREATE TABLE `zip_codes` (
  `zip_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `zip_code` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  PRIMARY KEY (`zip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `zip_codes`
--



