--
-- Host: idesigner-live.chpbonrvs4ie.us-east-2.rds.amazonaws.com    Database: idesigner3
-- ------------------------------------------------------

SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;

--
-- GTID state at the beginning of the backup 
--

-- SET @@GLOBAL.GTID_PURGED='';

--
-- Table structure for table `brand_components`
--

CREATE TABLE `brand_components` (
  `brand_component_id` int(11) NOT NULL AUTO_INCREMENT,
  `brand_id` int(11) DEFAULT NULL,
  `component_id` int(11) DEFAULT NULL,
  `brand_component_status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`brand_component_id`),
  KEY `fk_brand_components_brand_id_idx` (`brand_id`),
  KEY `fk_brand_components_component_id_idx` (`component_id`),
  CONSTRAINT `fk_brand_components_brand_id` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`brand_id`),
  CONSTRAINT `fk_brand_components_component_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`component_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `brand_components`
--

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `brand_id` int(11) NOT NULL AUTO_INCREMENT,
  `brand_name` varchar(255) NOT NULL,
  `brand_description` varchar(255) DEFAULT NULL,
  `brand_status` tinyint(1) DEFAULT NULL,
  `brand_email` varchar(255) DEFAULT NULL,
  `brand_website` varchar(255) DEFAULT NULL,
  `brand_logo` varchar(255) DEFAULT NULL,
  `brand_phone` varchar(13) DEFAULT NULL,
  `brand_address` varchar(255) DEFAULT NULL,
  `brand_zipcode` varchar(45) DEFAULT NULL,
  `brand_city_id` int(11) DEFAULT NULL,
  `brand_state_id` int(11) DEFAULT NULL,
  `brand_county_id` int(11) DEFAULT NULL,
  `brand_country_id` int(11) DEFAULT NULL,
  `brand_expiry_timeframe` time DEFAULT NULL,
  `brand_terms_conditions` varchar(500) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`brand_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` VALUES (1,'Allied Modular','new description',1,'lindathomaslinda@gmail.com','https://alliedmodular.com','Allied icon.png','9894151524','asc',NULL,NULL,NULL,NULL,NULL,'12:09:00','we','2019-09-06 11:37:01','2019-09-06 13:03:01'),(2,'Privee designs','test',1,'techsupport@privee.com','https://priveedesigns.com','Untitled.png','345 567 5678','63 Meadow Lane Warner Robins, GA 31088',NULL,NULL,NULL,NULL,NULL,'14:00:00','test','2019-09-06 12:04:24','2019-09-06 12:04:24'),(3,'Tan wall','test',1,'support@tanwall.com','https://www.tanwall.com','tanwall icon.png','345 567 7890','63 Meadow Lane Warner Robins, GA 31088',NULL,NULL,NULL,NULL,NULL,'01:00:00','test','2019-09-06 13:08:10','2019-09-06 13:08:10'),(4,'Tan wall','test',0,'support@tanwall.com','https://www.tanwall.com','tanwall icon.png','345 567 7890','63 Meadow Lane Warner Robins, GA 31088',NULL,NULL,NULL,NULL,NULL,'01:09:00','test','2019-09-06 13:08:10','2019-09-23 11:46:20'),(5,'Tan wall','test',0,'support@tanwall.com','https://www.tanwall.com','tanwall icon.png','345 567 7890','63 Meadow Lane Warner Robins, GA 31088',NULL,NULL,NULL,NULL,NULL,'01:00:00','test','2019-09-06 13:08:36','2019-09-06 13:12:10'),(6,'Tan wall','test',0,'support@tanwall.com','https://www.tanwall.com','tanwall icon.png','345 567 7890','63 Meadow Lane Warner Robins, GA 31088',NULL,NULL,NULL,NULL,NULL,'01:00:00','test','2019-09-06 13:08:36','2019-09-06 13:12:10'),(7,'Tan wall','test',0,'support@tanwall.com','https://www.tanwall.com','tanwall icon.png','345 567 7890','63 Meadow Lane Warner Robins, GA 31088',NULL,NULL,NULL,NULL,NULL,'01:00:00','test','2019-09-06 13:08:37','2019-09-06 13:12:11'),(8,'Tan wall','test',0,'support@tanwall.com','https://www.tanwall.com','tanwall icon.png','345 567 7890','63 Meadow Lane Warner Robins, GA 31088',NULL,NULL,NULL,NULL,NULL,'01:00:00','test','2019-09-06 13:11:28','2019-09-06 13:12:12'),(9,'Tan wall','test',0,'support@tanwall.com','https://www.tanwall.com','tanwall icon.png','345 567 7890','63 Meadow Lane Warner Robins, GA 31088',NULL,NULL,NULL,NULL,NULL,'01:00:00','test','2019-09-06 13:11:28','2019-09-06 13:12:13'),(10,'test','test',1,'techsupport@privee.com','https://www.tanwall.com','400x600.jpg','345 654 5432','63 Meadow Lane Warner Robins, GA 31088',NULL,NULL,NULL,NULL,NULL,'01:00:00','test','2019-09-06 13:42:46','2019-09-06 13:42:46'),(11,'Aallied','test',1,'aallied@idesigner.com','http://www.tanwall.com','unit C.PNG','234 345 3456','test',NULL,NULL,NULL,NULL,NULL,'03:01:00','trete','2019-09-23 10:30:59','2019-09-23 10:30:59');

--
-- Table structure for table `breadcrumbs`
--

CREATE TABLE `breadcrumbs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(100) NOT NULL,
  `page_name` varchar(100) NOT NULL,
  `route` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `breadcrumbs`
--


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

CREATE TABLE `countries` (
  `country_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_name` varchar(255) NOT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

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

INSERT INTO `countries` VALUES (1,'India'),(2,'USA'),(4,'UK');

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

CREATE TABLE `states` (
  `state_id` int(11) NOT NULL AUTO_INCREMENT,
  `state_name` varchar(255) NOT NULL,
  `country_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`state_id`),
  KEY `fk_states_idx` (`country_id`),
  CONSTRAINT `fk_states` FOREIGN KEY (`country_id`) REFERENCES `countries` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

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

INSERT INTO `states` VALUES (1,'Kerala',1),(2,'New York',2),(3,'Alabama',2),(4,'Alaska',2),(7,'New jersey',2),(24,'TamilNadu',1),(25,'karnataka',1),(27,'Delhi',1),(28,'Punjab',1),(29,'Goa',1),(30,'Bengal',1),(31,'Maharashtra',1),(32,'Madhya Pradesh',1),(33,'J & K',1),(34,'Huston',2),(35,'London',4);

--
-- Table structure for table `counties`
--

CREATE TABLE `counties` (
  `county_id` int(11) NOT NULL AUTO_INCREMENT,
  `county_name` varchar(255) NOT NULL,
  `state_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`county_id`),
  KEY `fk_county_idx` (`state_id`),
  CONSTRAINT `fk_county` FOREIGN KEY (`state_id`) REFERENCES `states` (`state_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `counties`
--

INSERT INTO `counties` VALUES (1,'Trivandrum',1),(2,'New York',2),(8,'kollam',1),(21,'Thrissur',1),(22,'Thrissur',1),(23,'Cochin',1),(24,'EKM',1),(25,'EKM',1),(27,'Chennai',24),(28,'Cuddalor',24),(29,'pondy',24),(30,'Trichy',24),(31,'Madurai',24),(32,'banglore',25),(34,'Mysore',25),(35,'manglore',25),(36,'Hubli',25),(37,'Korba',32),(38,'Mumbai',31),(39,'Pune',31),(40,'New Delhi',27);
--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `city_id` int(11) NOT NULL AUTO_INCREMENT,
  `city_name` varchar(255) NOT NULL,
  `county_id` int(11) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`city_id`),
  KEY `fk_cities_idx` (`county_id`),
  CONSTRAINT `fk_cities` FOREIGN KEY (`county_id`) REFERENCES `counties` (`county_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` VALUES (3,'New York city',2,NULL),(4,'Kazhakoottam',1,NULL),(6,'Edapalli',24,NULL),(8,'Kollam',8,NULL),(9,'Karunagapalli',8,NULL),(10,'punular',8,NULL),(11,'Kottarakkara',8,NULL),(12,'Neyveli',28,NULL),(13,'aavadi',27,NULL),(14,'Chennai city',27,NULL),(15,'Thambaram',27,NULL),(16,'saidapett',27,NULL),(17,'vandaloor',27,NULL),(18,'pattom',1,NULL),(19,'ulloor',1,NULL),(20,'Electronic city',32,NULL),(21,'Kormangalam',32,NULL),(22,'New Hubli',36,NULL);

--
-- Table structure for table `cms_categories`
--

CREATE TABLE `cms_categories` (
  `cms_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `cms_category_name` varchar(100) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`cms_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms_categories`
--


--
-- Table structure for table `cms_pages`
--

CREATE TABLE `cms_pages` (
  `cms_page_id` int(11) NOT NULL AUTO_INCREMENT,
  `cms_page_title` varchar(100) DEFAULT NULL,
  `cms_page_body` longtext,
  `cms_page_category_id` int(11) DEFAULT NULL,
  `cms_page_machine_name` varchar(50) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`cms_page_id`),
  KEY `fk_cms_pages_category_id_idx` (`cms_page_category_id`),
  CONSTRAINT `fk_cms_pages_category_id` FOREIGN KEY (`cms_page_category_id`) REFERENCES `cms_categories` (`cms_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms_pages`
--


--
-- Table structure for table `component_categories`
--

CREATE TABLE `component_categories` (
  `component_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `component_category_name` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `icon` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`component_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `component_categories`
--

INSERT INTO `component_categories` VALUES (1,'Test',1,'2019-09-06 11:11:50','2019-09-06 11:11:50','featured_image.png'),(2,'Door',1,'2019-09-06 14:17:00','2019-09-06 14:17:00','unit C.PNG'),(3,'Window',1,'2019-09-06 14:17:25','2019-09-06 14:17:25','unit B.PNG');

--
-- Table structure for table `component_properties`
--

CREATE TABLE `component_properties` (
  `component_property_id` int(11) NOT NULL AUTO_INCREMENT,
  `component_property_type_id` int(11) NOT NULL,
  `component_property_value` varchar(100) NOT NULL,
  `component_property_widget_type` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`component_property_id`),
  KEY `fk_component_properties_property_type_idx` (`component_property_type_id`),
  CONSTRAINT `fk_component_properties_property_type` FOREIGN KEY (`component_property_type_id`) REFERENCES `component_property_type` (`component_property_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `component_properties`
--


--
-- Table structure for table `component_property_type`
--

CREATE TABLE `component_property_type` (
  `component_property_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `component_property_type_name` varchar(100) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`component_property_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `component_property_type`
--


--
-- Table structure for table `component_rules`
--

CREATE TABLE `component_rules` (
  `component_rule_id` int(11) NOT NULL AUTO_INCREMENT,
  `rule_id` int(11) NOT NULL,
  `component_id` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`component_rule_id`),
  KEY `fk_rules_rule_id_idx` (`rule_id`),
  KEY `fk_component_rules_component_id_idx` (`component_id`),
  CONSTRAINT `fk_component_rules_component_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`component_id`),
  CONSTRAINT `fk_component_rules_rule_id` FOREIGN KEY (`rule_id`) REFERENCES `rules` (`rule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `component_rules`
--


--
-- Table structure for table `components`
--

CREATE TABLE `components` (
  `component_id` int(11) NOT NULL AUTO_INCREMENT,
  `component_name` varchar(100) NOT NULL,
  `component_category_id` int(11) NOT NULL,
  `component_status` tinyint(1) DEFAULT '1',
  `component_description` varchar(500) DEFAULT NULL,
  `component_part_number` varchar(50) DEFAULT NULL,
  `component_image` varchar(255) DEFAULT NULL,
  `component_icon` varchar(255) DEFAULT NULL,
  `component_price` decimal(10,2) DEFAULT NULL,
  `component_parent_id` int(11) DEFAULT NULL,
  `component_variation_component_id` int(11) DEFAULT NULL,
  `notes` varchar(500) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `last_synched` datetime DEFAULT NULL,
  `modified_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`component_id`),
  KEY `fk_components_category_id_idx` (`component_category_id`),
  CONSTRAINT `fk_components_category_id` FOREIGN KEY (`component_category_id`) REFERENCES `component_categories` (`component_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `components`
--

INSERT INTO `components` VALUES (1,'Test',1,0,'test','45','featured_image.png','featured.png',85.00,NULL,NULL,'test','2019-09-06 11:13:36','2019-09-06 11:28:49',NULL,NULL),(2,'Test 2',1,1,NULL,'45','featured.png','flag.png',7.00,NULL,NULL,NULL,'2019-09-06 11:15:40','2019-09-06 11:15:40',NULL,NULL),(3,'Test 6',1,1,'test','45','featured_image.png','featured.png',8.00,NULL,NULL,NULL,'2019-09-06 11:29:28','2019-09-06 11:29:28',NULL,NULL),(4,'Side door',2,1,NULL,'ASD4349SD','unit C.PNG','unit C.PNG',20.00,NULL,NULL,NULL,'2019-09-06 14:18:42','2019-09-06 14:18:42',NULL,NULL);


--
-- Table structure for table `customer_user_details`
--

CREATE TABLE `customer_user_details` (
  `customer_user_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_user_id` int(11) NOT NULL,
  `customer_notes` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `company_name` varchar(25) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `customer_business_name` varchar(100) DEFAULT NULL,
  `customer_business_phone` varchar(15) DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `county_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `zip_code` int(11) DEFAULT NULL,
  PRIMARY KEY (`customer_user_details_id`),
  KEY `customer_user_id` (`customer_user_id`),
  CONSTRAINT `customer_user_details` FOREIGN KEY (`customer_user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customer_user_details`
--

INSERT INTO `customer_user_details` VALUES (5,21,NULL,'2019-09-10 06:03:59','2019-09-10 06:03:59','asc','dsfds',NULL,NULL,NULL,1,1,1,4,2),(6,22,NULL,'2019-09-10 09:07:20','2019-09-10 09:07:20','cLYMcu','NEW TEST',NULL,NULL,NULL,2,2,2,3,5),(7,23,NULL,'2019-09-17 09:02:26','2019-09-17 09:02:26','cLYMcu','rtrt',NULL,NULL,NULL,2,2,2,3,5),(8,24,NULL,'2019-09-17 09:36:00','2019-09-17 09:36:00','test','test',NULL,NULL,NULL,1,1,1,4,2),(12,25,'heyy',NULL,NULL,NULL,NULL,'zx\r\nasd\r\nqwer','zyx','787964654562131',NULL,NULL,NULL,NULL,NULL),(13,19,'erw',NULL,NULL,NULL,NULL,'63 Meadow Lane\r\nWarner Robins, GA 31088','John constructions','456 876 6543',NULL,NULL,NULL,NULL,NULL),(14,28,NULL,'2019-09-17 11:26:30','2019-09-17 11:26:30','cLYMcu','NEW TEST',NULL,NULL,NULL,2,2,2,3,5),(15,29,NULL,'2019-09-17 11:33:35','2019-09-17 11:33:35','adsfds','m3g',NULL,NULL,NULL,2,2,2,3,5),(16,30,NULL,'2019-09-17 11:34:54','2019-09-17 11:34:54','adsfds','m3g',NULL,NULL,NULL,2,2,2,3,5),(17,31,NULL,'2019-09-17 11:37:31','2019-09-17 11:37:31','asc','test',NULL,NULL,NULL,1,24,27,13,10),(18,32,NULL,'2019-09-17 11:51:21','2019-09-17 11:51:21','asc','test',NULL,NULL,NULL,1,24,27,14,11),(19,33,NULL,'2019-09-17 12:09:21','2019-09-17 12:09:21','cLYMcu','NEW TEST',NULL,NULL,NULL,2,2,2,3,5),(20,34,NULL,'2019-09-18 11:36:26','2019-09-18 11:36:26','cLYMcu','NEW TEST',NULL,NULL,NULL,2,2,2,3,5),(21,35,NULL,'2019-09-19 06:35:58','2019-09-19 06:35:58','hfghfgh','softnotions',NULL,NULL,NULL,1,1,8,8,7),(22,36,NULL,'2019-09-19 11:52:58','2019-09-19 11:52:58','12345678901234567890123456789012345678901234567890','FIFA',NULL,NULL,NULL,2,2,2,3,5),(23,37,NULL,'2019-09-19 11:55:19','2019-09-19 11:55:19','WKyAES','NEW TEST',NULL,NULL,NULL,2,2,2,3,5),(24,39,NULL,'2019-09-19 12:23:59','2019-09-19 12:23:59','TN','soft notions',NULL,NULL,NULL,1,24,27,14,11),(25,40,NULL,'2019-09-19 12:49:08','2019-09-19 12:49:08','cLYMcu','NEW TEST',NULL,NULL,NULL,2,2,2,3,5),(26,41,NULL,'2019-09-20 05:02:02','2019-09-20 05:02:02','trivandrum','yy',NULL,NULL,NULL,1,24,27,15,12),(27,42,NULL,'2019-09-20 05:06:30','2019-09-20 05:06:30','trivandrum','yy',NULL,NULL,NULL,1,24,27,15,12),(28,43,NULL,'2019-09-20 05:22:54','2019-09-20 05:22:54','gdfg','hfgsh',NULL,NULL,NULL,1,1,1,4,2),(29,44,NULL,'2019-09-20 06:54:24','2019-09-20 06:54:24','test','test',NULL,NULL,NULL,1,1,1,4,2),(30,45,NULL,'2019-09-20 07:56:42','2019-09-20 07:56:42','test','Test',NULL,NULL,NULL,1,1,1,4,2),(31,46,NULL,'2019-09-20 08:11:15','2019-09-20 08:11:15','ghkjkjghk','-890-',NULL,NULL,NULL,1,1,1,4,2),(32,47,NULL,'2019-09-20 09:45:01','2019-09-20 09:45:01','dasdsadas','qwew',NULL,NULL,NULL,1,1,1,4,2),(33,49,NULL,'2019-09-24 09:16:09','2019-09-24 09:16:09','New','idesign',NULL,NULL,NULL,1,1,1,4,4),(34,50,NULL,'2019-09-24 09:18:59','2019-09-24 09:18:59','llklkjlkjlkjl','sdfsd',NULL,NULL,NULL,1,24,27,13,10),(35,51,NULL,'2019-09-24 10:04:43','2019-09-24 10:04:43','trivandrum','softnotions',NULL,NULL,NULL,1,1,1,4,6),(36,52,NULL,'2019-09-24 10:10:42','2019-09-24 10:10:42','Kollam','softnotions',NULL,NULL,NULL,1,1,8,8,7),(37,53,NULL,'2019-09-24 10:25:25','2019-09-24 10:25:25','jlju','softnotions',NULL,NULL,NULL,1,1,1,4,2),(38,54,NULL,'2019-09-24 10:25:50','2019-09-24 10:25:50','jlju','softnotions',NULL,NULL,NULL,1,1,1,4,2),(39,55,NULL,'2019-09-24 10:26:51','2019-09-24 10:26:51','jlju','softnotions',NULL,NULL,NULL,1,1,1,4,2),(40,56,NULL,'2019-09-24 10:27:53','2019-09-24 10:27:53','jlju','softnotions',NULL,NULL,NULL,1,1,1,4,2),(41,57,NULL,'2019-09-24 10:29:03','2019-09-24 10:29:03','jlju','softnotions',NULL,NULL,NULL,1,1,1,4,2),(42,58,NULL,'2019-09-24 10:29:18','2019-09-24 10:29:18','ngl','newq',NULL,NULL,NULL,1,24,28,12,9),(43,59,NULL,'2019-09-24 10:31:36','2019-09-24 10:31:36','jlju','softnotions',NULL,NULL,NULL,1,1,1,4,2),(44,60,NULL,'2019-09-24 10:59:58','2019-09-24 10:59:58','jlju','softnotions',NULL,NULL,NULL,1,1,1,4,2),(45,61,NULL,'2019-09-24 11:01:40','2019-09-24 11:01:40','dhy\r\ndghdf\r\n4123423\r\n234523\r\n%^&%^&*%','zyx',NULL,NULL,NULL,1,1,1,4,2),(46,62,NULL,'2019-09-24 12:42:20','2019-09-24 12:42:20','township','softnotions',NULL,NULL,NULL,1,1,1,4,2),(47,63,NULL,'2019-09-26 05:34:47','2019-09-26 05:34:47','Address','Company name 123',NULL,NULL,NULL,2,2,2,3,5),(48,64,NULL,'2019-09-26 07:33:27','2019-09-26 07:33:27','asc','idesign',NULL,NULL,NULL,2,2,2,3,5),(49,65,NULL,'2019-09-26 10:09:16','2019-09-26 10:09:16','New','idesign',NULL,NULL,NULL,1,24,28,12,9),(50,66,NULL,'2019-09-26 10:55:30','2019-09-26 10:55:30','TN','soft notions',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL),(51,67,NULL,'2019-09-26 11:21:32','2019-09-26 11:21:32','ngl','quote',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL);

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

CREATE TABLE `device_types` (
  `device_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `device_type_name` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`device_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `drawing_component_properties` (
  `drawing_component_property_id` int(11) NOT NULL AUTO_INCREMENT,
  `drawing_component_id` int(11) NOT NULL,
  `component_property_id` int(11) NOT NULL,
  `drawing_component_property_value` varchar(100) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`drawing_component_property_id`),
  KEY `fk_drawing_component_property_drawing_component_id_idx` (`drawing_component_id`),
  KEY `fk_drawing_component_component_property_id_idx` (`component_property_id`),
  CONSTRAINT `fk_drawing_component_component_property_id` FOREIGN KEY (`component_property_id`) REFERENCES `component_properties` (`component_property_id`),
  CONSTRAINT `fk_drawing_component_property_drawing_component_id` FOREIGN KEY (`drawing_component_id`) REFERENCES `drawing_components` (`drawing_component_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `drawing_components` (
  `drawing_component_id` int(11) NOT NULL AUTO_INCREMENT,
  `drawing_id` int(11) DEFAULT NULL,
  `component_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`drawing_component_id`),
  KEY `fk_drawing_components_drawing_id_idx` (`drawing_id`),
  KEY `fk_drawing_components_component_id_idx` (`component_id`),
  CONSTRAINT `fk_drawing_components_component_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`component_id`),
  CONSTRAINT `fk_drawing_components_drawing_id` FOREIGN KEY (`drawing_id`) REFERENCES `drawings` (`drawing_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `drawing_settings` (
  `drawing_setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `drawing_id` int(11) DEFAULT NULL,
  `drawing_setting_building_type` varchar(255) DEFAULT NULL,
  `drawing_setting_building_shape` varchar(255) DEFAULT NULL,
  `drawing_setting_system` varchar(255) DEFAULT NULL,
  `drawing_setting_existing_floor` tinyint(1) DEFAULT NULL,
  `drawing_setting_standard_height` varchar(10) DEFAULT NULL,
  `drawing_setting_interior_wall_material` varchar(50) DEFAULT NULL,
  `drawing_setting_interior_color` varchar(50) DEFAULT NULL,
  `drawing_setting_exterior_wall_material` varchar(50) DEFAULT NULL,
  `drawing_settings_exterior_color` varchar(50) DEFAULT NULL,
  `drawing_setting_panel_core` varchar(50) DEFAULT NULL,
  `drawing_setting_aluminium_finish` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`drawing_setting_id`),
  KEY `fk_drawing_settings_drawing_id_idx` (`drawing_id`),
  CONSTRAINT `fk_drawing_settings_drawing_id` FOREIGN KEY (`drawing_id`) REFERENCES `drawings` (`drawing_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `drawing_settings` VALUES (1,NULL,'Interior','Interior','test',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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

CREATE TABLE `drawing_templates` (
  `drawing_template_id` int(11) NOT NULL AUTO_INCREMENT,
  `drawing_template_file_path` varchar(255) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`drawing_template_id`),
  KEY `drawing_templates_created_by_idx` (`created_by`),
  CONSTRAINT `drawing_templates_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `drawings` (
  `drawing_id` int(11) NOT NULL AUTO_INCREMENT,
  `drawing_name` varchar(100) DEFAULT NULL,
  `drawing_price` decimal(10,2) DEFAULT NULL,
  `drawing_quote_id` int(11) DEFAULT NULL,
  `drawing_template_id` int(11) DEFAULT NULL,
  `drawing_file_path` varchar(255) DEFAULT NULL,
  `drawing_notes` varchar(1000) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`drawing_id`),
  KEY `fk_drawings_created_by_idx` (`created_by`),
  KEY `fk_drawing_template_id_idx` (`drawing_template_id`),
  CONSTRAINT `fk_drawing_template_id` FOREIGN KEY (`drawing_template_id`) REFERENCES `drawing_templates` (`drawing_template_id`),
  CONSTRAINT `fk_drawings_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;

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

INSERT INTO `drawings` VALUES (1,NULL,NULL,1,NULL,'',NULL,0,1,NULL,NULL),(2,NULL,NULL,2,NULL,'featured_image.png',NULL,0,1,NULL,NULL),(3,NULL,NULL,3,NULL,'',NULL,0,1,NULL,NULL),(4,NULL,NULL,4,NULL,'unit b_small.png',NULL,0,1,NULL,NULL),(5,NULL,NULL,5,NULL,'',NULL,0,1,NULL,NULL),(6,NULL,NULL,6,NULL,'',NULL,0,1,NULL,NULL),(7,NULL,NULL,7,NULL,'unit B.PNG','fasdg',0,1,NULL,NULL),(8,NULL,NULL,8,NULL,'unit A.PNG','new description',0,5,NULL,NULL),(9,NULL,NULL,9,NULL,'unit C.PNG','new description',0,1,NULL,NULL),(10,NULL,NULL,10,NULL,'Allied icon.png','new description',0,1,NULL,NULL),(11,NULL,NULL,11,NULL,'',NULL,0,1,NULL,NULL),(12,NULL,NULL,12,NULL,'',NULL,0,17,NULL,NULL),(13,NULL,NULL,13,NULL,'','Housing Plan',0,1,NULL,NULL),(14,NULL,NULL,14,NULL,'','Housing Plan',0,1,NULL,NULL),(15,NULL,NULL,15,NULL,'','Housing Plan',0,1,NULL,NULL),(16,NULL,NULL,16,NULL,'','notice',0,1,NULL,NULL),(17,NULL,NULL,17,NULL,'unit C.PNG',NULL,0,1,NULL,NULL),(18,NULL,NULL,18,NULL,'unit C.PNG','DHGDJH',0,1,NULL,NULL),(19,NULL,NULL,19,NULL,'unit A.PNG',NULL,0,1,NULL,NULL),(20,NULL,NULL,20,NULL,'download-2.jpg','Main school',0,1,NULL,NULL),(21,NULL,NULL,21,NULL,'download-2.jpg','Buildings',0,1,NULL,NULL),(22,NULL,NULL,22,NULL,'download.jpg','Buildings',0,1,NULL,NULL),(23,NULL,NULL,23,NULL,'','test',0,1,NULL,NULL),(24,NULL,NULL,24,NULL,'','uiuyyuiuyi',0,1,NULL,NULL),(25,NULL,NULL,25,NULL,'','ee',0,1,NULL,NULL),(26,NULL,NULL,26,NULL,'','ads',0,1,NULL,NULL),(27,NULL,NULL,27,NULL,'download-3.jpg','Buildings',0,1,NULL,NULL),(28,NULL,NULL,28,NULL,'download (1).jpeg','new description',0,1,NULL,NULL),(29,NULL,NULL,29,NULL,'images.jpg','park',0,1,NULL,NULL),(30,NULL,NULL,30,NULL,'images.jpg','park',0,1,NULL,NULL),(31,NULL,NULL,31,NULL,'','Buildings',0,1,NULL,NULL),(32,NULL,NULL,32,NULL,'','Buildings',0,1,NULL,NULL),(33,NULL,NULL,33,NULL,'','Buildings',0,1,NULL,NULL),(34,NULL,NULL,34,NULL,'','sdks',0,1,NULL,NULL),(35,NULL,NULL,35,NULL,'','dfsdfd',0,1,NULL,NULL),(36,NULL,NULL,38,NULL,'download.jpeg','new description',0,1,NULL,NULL),(37,NULL,NULL,39,NULL,'',NULL,0,1,NULL,NULL),(38,NULL,NULL,40,NULL,'download.jpeg','new description',0,1,NULL,NULL);

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

CREATE TABLE `email_templates` (
  `email_template_id` int(11) NOT NULL AUTO_INCREMENT,
  `email_template_name` varchar(100) DEFAULT NULL,
  `email_template_description` varchar(255) DEFAULT NULL,
  `email_template_subject` varchar(255) DEFAULT NULL,
  `email_template_body` varchar(1500) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`email_template_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `email_templates` VALUES (1,'Order confirmation','Order confirmation','Order confirmation','Order confirmation',1,'2019-09-06 14:00:35','2019-09-06 14:00:35'),(2,'New quote','New quote','New quote','New quote',1,'2019-09-06 14:00:35','2019-09-06 14:01:15'),(3,'Registration','Registration','Registration','The service provider has insurance coverage, possibly leased tools, financing 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.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.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.',1,'2019-09-06 14:06:56','2019-09-06 14:06:56');

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

CREATE TABLE `issues` (
  `issue_id` int(11) NOT NULL AUTO_INCREMENT,
  `issue_name` varchar(100) DEFAULT NULL,
  `issue_description` varchar(500) DEFAULT NULL,
  `issue_drawing_id` int(11) DEFAULT NULL,
  `issue_assigned_to` int(11) DEFAULT NULL,
  `issue_image_path` varchar(256) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `priority` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`issue_id`),
  KEY `fk_issues_drawing_id_idx` (`issue_drawing_id`),
  KEY `fk_issues_created_by_idx` (`created_by`),
  CONSTRAINT `fk_issues_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`),
  CONSTRAINT `fk_issues_drawing_id` FOREIGN KEY (`issue_drawing_id`) REFERENCES `drawings` (`drawing_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

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

INSERT INTO `issues` VALUES (1,'test create','test',NULL,NULL,'',2,1,'2019-09-17 10:47:20','2019-09-17 10:47:20','low'),(2,'test','test',10,NULL,'',0,1,'2019-09-17 11:52:22','2019-09-17 11:52:22','lowest'),(3,'test','test',11,NULL,'',0,1,'2019-09-17 12:10:53','2019-09-17 12:10:53','lowest'),(4,'graph is on work','graph-graph',6,NULL,'20190423071717367.pdf',3,1,'2019-09-17 12:47:12','2019-09-24 10:33:54','lowest'),(5,'test new','new',3,NULL,'',2,1,'2019-09-18 08:12:13','2019-09-18 08:12:13','lowest'),(6,'test issue1','test issue1',4,NULL,'download (1).jpg',0,1,'2019-09-18 10:59:38','2019-09-18 11:21:22','medium'),(7,'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the','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 h',12,NULL,'',0,17,'2019-09-18 11:49:14','2019-09-18 11:49:14','lowest'),(8,'sttdgghvjjgjgj','fghfgh\r\ndfhdfh\r\ndhdfghj6534',15,NULL,'',0,1,'2019-09-19 06:47:05','2019-09-19 06:47:05','medium'),(9,'ty','rty',19,NULL,'20190423071717367.pdf',0,1,'2019-09-23 12:33:54','2019-09-23 12:33:54','low'),(10,'ty','rty',19,NULL,'20190423071717367.pdf',1,1,'2019-09-23 12:34:07','2019-09-24 10:39:48','high'),(11,'new29','test',NULL,NULL,'iDesigner phase 2 testcase_drawing module_v2_26062019.xlsx,iDesigner test cases_27052019_v2.xlsx',2,1,'2019-09-24 07:41:31','2019-09-24 10:46:35','medium'),(12,'CAD issue','issue in cad',NULL,NULL,'Functionality Document for iDesigner phase 2 v2.0 30042019.pdf',2,1,'2019-09-24 11:13:13','2019-09-25 11:05:17','medium'),(13,'Cadd','nila',NULL,NULL,'',1,1,'2019-09-24 11:15:56','2019-09-24 11:15:56','low'),(14,'sdgsg','fsdf',NULL,NULL,'0-1.jpg',0,1,'2019-09-24 12:07:51','2019-09-24 12:07:51','lowest'),(15,'sdgsg','fsdf',NULL,NULL,'0-1.jpg',0,1,'2019-09-24 12:07:55','2019-09-24 12:07:55','lowest'),(16,'yes','no',NULL,NULL,'',2,1,'2019-09-24 12:13:31','2019-09-24 12:13:31','high'),(17,'noo','yess',NULL,NULL,'cmm-enclosure_AlliedModular.com_02.jpg',0,1,'2019-09-24 12:15:02','2019-09-24 12:15:02','high'),(18,'Civil dept','dept of civil',NULL,NULL,'0-1.jpg',3,1,'2019-09-24 12:43:42','2019-09-24 12:49:15','medium'),(19,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:35','2019-09-24 12:47:35','lowest'),(20,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:37','2019-09-24 12:47:37','lowest'),(21,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:39','2019-09-24 12:47:39','lowest'),(22,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:40','2019-09-24 12:47:40','lowest'),(23,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:41','2019-09-24 12:47:41','lowest'),(24,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:42','2019-09-24 12:47:42','lowest'),(25,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:42','2019-09-24 12:47:42','lowest'),(26,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:42','2019-09-24 12:47:42','lowest'),(27,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:44','2019-09-24 12:47:44','lowest'),(28,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:44','2019-09-24 12:47:44','lowest'),(29,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:45','2019-09-24 12:47:45','lowest'),(30,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:46','2019-09-24 12:47:46','lowest'),(31,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:49','2019-09-24 12:47:49','lowest'),(32,'Road','road width',NULL,NULL,'0-1.jpg',1,1,'2019-09-24 12:47:49','2019-09-24 12:47:49','lowest'),(33,'fjjfgj','fhgjfj',NULL,NULL,'0-1.jpg',0,1,'2019-09-24 12:48:29','2019-09-24 12:48:29','lowest'),(34,'fjjfgj','fhgjfj',NULL,NULL,'0-1.jpg',0,1,'2019-09-24 12:48:32','2019-09-24 12:48:32','lowest'),(35,'fjjfgj','fhgjfj',NULL,NULL,'0-1.jpg',0,1,'2019-09-24 12:48:34','2019-09-24 12:48:34','lowest');

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

CREATE TABLE `locations` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_name` varchar(100) NOT NULL,
  `location_address` varchar(255) DEFAULT NULL,
  `location_zipcode` varchar(15) DEFAULT NULL,
  `location_city_id` int(11) DEFAULT NULL,
  `location_state_id` int(11) DEFAULT NULL,
  `location_county_id` int(11) DEFAULT NULL,
  `location_country_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`location_id`),
  KEY `location_city_id_idx` (`location_city_id`),
  KEY `location_state_id_idx` (`location_state_id`),
  KEY `location_county_id_idx` (`location_county_id`),
  KEY `location_country_id_idx` (`location_country_id`),
  CONSTRAINT `fk_locations_city_id` FOREIGN KEY (`location_city_id`) REFERENCES `cities` (`city_id`),
  CONSTRAINT `fk_locations_country_id` FOREIGN KEY (`location_country_id`) REFERENCES `countries` (`country_id`),
  CONSTRAINT `fk_locations_county_id` FOREIGN KEY (`location_county_id`) REFERENCES `counties` (`county_id`),
  CONSTRAINT `fk_locations_state_id` FOREIGN KEY (`location_state_id`) REFERENCES `states` (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `locations`
--


--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log_user_id` int(11) NOT NULL,
  `log_description` varchar(500) NOT NULL,
  `log_device_type_id` int(11) DEFAULT NULL,
  `module` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`log_id`),
  KEY `fk_logs_user_id_idx` (`log_user_id`),
  KEY `fk_logs_device_type_id_idx` (`log_device_type_id`),
  CONSTRAINT `fk_logs_device_type_id` FOREIGN KEY (`log_device_type_id`) REFERENCES `device_types` (`device_type_id`),
  CONSTRAINT `fk_logs_user_id` FOREIGN KEY (`log_user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logs`
--


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

CREATE TABLE `notification_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `notification_id` int(11) NOT NULL,
  `notification_user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `notification_user_status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `notification_id` (`notification_id`),
  KEY `notification_user_id` (`notification_user_id`),
  CONSTRAINT `fk_notification_user` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`notification_id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;

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

INSERT INTO `notification_user` VALUES (1,1,1,'2019-09-06 11:21:05','2019-09-25 10:12:03',1),(2,1,3,'2019-09-06 11:21:05','2019-09-06 11:21:05',0),(3,2,18,'2019-09-07 07:11:17','2019-09-07 07:11:17',0),(4,3,18,'2019-09-07 07:18:18','2019-09-07 07:18:18',0),(5,4,17,'2019-09-07 07:21:18','2019-09-07 07:21:18',0),(6,4,18,'2019-09-07 07:21:18','2019-09-07 07:21:18',0),(7,6,16,'2019-09-09 04:10:27','2019-09-09 04:10:27',0),(8,7,4,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(9,7,5,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(10,7,6,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(11,7,7,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(12,7,8,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(13,7,9,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(14,7,10,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(15,7,11,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(16,7,12,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(17,7,13,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(18,7,14,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(19,7,15,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(20,7,16,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(21,7,17,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(22,7,19,'2019-09-09 04:33:57','2019-09-09 04:33:57',0),(23,8,4,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(24,8,5,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(25,8,6,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(26,8,7,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(27,8,8,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(28,8,9,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(29,8,10,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(30,8,11,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(31,8,12,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(32,8,13,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(33,8,14,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(34,8,15,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(35,8,16,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(36,8,17,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(37,8,19,'2019-09-09 13:41:29','2019-09-09 13:41:29',0),(38,8,1,'2019-09-09 13:41:29','2019-09-25 10:12:07',1),(39,9,4,'2019-09-09 13:50:58','2019-09-09 13:50:58',0),(40,9,5,'2019-09-09 13:50:58','2019-09-09 13:50:58',0),(41,9,17,'2019-09-09 13:50:58','2019-09-09 13:50:58',0),(42,10,19,'2019-09-09 13:51:35','2019-09-09 13:51:35',0),(43,11,19,'2019-09-09 13:51:35','2019-09-09 13:51:35',0),(44,12,19,'2019-09-09 13:51:35','2019-09-09 13:51:35',0),(45,13,19,'2019-09-09 13:51:36','2019-09-09 13:51:36',0);

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

CREATE TABLE `notifications` (
  `notification_id` int(11) NOT NULL AUTO_INCREMENT,
  `notification_name` varchar(100) DEFAULT NULL,
  `notification_message` varchar(500) DEFAULT NULL,
  `notification_assigned_to` int(11) DEFAULT NULL,
  `notification_machine_name` varchar(50) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`notification_id`),
  KEY `fk_notifications_notification_assigned_to_idx` (`notification_assigned_to`),
  KEY `fk_notifications_created_by_idx` (`created_by`),
  CONSTRAINT `fk_notifications_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`),
  CONSTRAINT `fk_notifications_notification_assigned_to` FOREIGN KEY (`notification_assigned_to`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

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

INSERT INTO `notifications` VALUES (1,'test','test notification',NULL,NULL,NULL,1,'2019-09-06 11:21:05','2019-09-06 11:21:05'),(2,'Admin assigned brands to partners','Admin assigned brands to partners',NULL,NULL,NULL,1,'2019-09-07 07:11:17','2019-09-07 07:11:17'),(3,'test notification','test notification for parner',NULL,NULL,NULL,1,'2019-09-07 07:18:18','2019-09-07 07:18:18'),(4,'test','test noti',NULL,NULL,NULL,1,'2019-09-07 07:21:18','2019-09-07 07:21:18'),(5,'testing','notification on 90-09-19',NULL,NULL,NULL,1,'2019-09-09 03:45:30','2019-09-09 03:45:30'),(6,'test','test on 09-09-19',NULL,NULL,NULL,1,'2019-09-09 04:10:27','2019-09-09 04:10:27'),(7,'test on 09-09-19','test notification',NULL,NULL,NULL,1,'2019-09-09 04:33:57','2019-09-09 04:33:57'),(8,'Notification for all','Notification for all',NULL,NULL,NULL,1,'2019-09-09 13:41:29','2019-09-09 13:41:29'),(9,'test noti','test noti',NULL,NULL,NULL,1,'2019-09-09 13:50:58','2019-09-09 13:50:58'),(10,'Admin assigned brands to partners - 1','Admin assigned brands to partners - 1',NULL,NULL,NULL,1,'2019-09-09 13:51:35','2019-09-09 13:51:35'),(11,'Admin assigned brands to partners - 1','Admin assigned brands to partners - 1',NULL,NULL,NULL,1,'2019-09-09 13:51:35','2019-09-09 13:51:35'),(12,'Admin assigned brands to partners - 1','Admin assigned brands to partners - 1',NULL,NULL,NULL,1,'2019-09-09 13:51:35','2019-09-09 13:51:35'),(13,'Admin assigned brands to partners - 1','Admin assigned brands to partners - 1',NULL,NULL,NULL,1,'2019-09-09 13:51:36','2019-09-09 13:51:36');

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

CREATE TABLE `page_fields` (
  `page_field_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_field_name` varchar(100) NOT NULL,
  `page_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`page_field_id`),
  KEY `page_field_screen_id_idx` (`page_id`),
  CONSTRAINT `fk_page_fields_page_id` FOREIGN KEY (`page_id`) REFERENCES `pages` (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL AUTO_INCREMENT,
  `page_name` varchar(100) NOT NULL,
  `page_description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

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

INSERT INTO `pages` VALUES (1,'Roles','Roles\r\n'),(2,'Email templates','Email templates'),(3,'Users','Users'),(4,'Locations','Locations'),(5,'Brands','Brands'),(6,'Components','Components'),(7,'Partner','Partner'),(8,'Order','Order'),(9,'Customer','Customer'),(10,'Quotes','Quotes'),(11,'Tutorials','Tutorials'),(12,'Protips','Protips'),(13,'Todos','Todo'),(14,'Notifications','Notifications'),(15,'Reports','Reports'),(16,'Logs','Logs'),(17,'Drawings','Drawings'),(18,'Tickets','Tickets');

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

CREATE TABLE `partner_brands` (
  `partner_brand_id` int(11) NOT NULL AUTO_INCREMENT,
  `partner_user_id` int(11) NOT NULL,
  `brand_id` int(11) 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=39 DEFAULT CHARSET=latin1;

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

INSERT INTO `partner_brands` VALUES (1,5,1,'2019-09-06 11:37:49','2019-09-06 11:37:49'),(5,18,3,'2019-09-09 14:09:42','2019-09-09 14:09:42'),(26,26,1,'2019-09-17 10:37:45','2019-09-17 10:37:45'),(27,26,2,'2019-09-17 10:37:45','2019-09-17 10:37:45'),(28,26,3,'2019-09-17 10:37:45','2019-09-17 10:37:45'),(29,17,3,'2019-09-17 10:39:15','2019-09-17 10:39:15'),(34,27,1,'2019-09-17 10:45:43','2019-09-17 10:45:43'),(35,27,2,'2019-09-17 10:45:43','2019-09-17 10:45:43'),(36,38,1,'2019-09-19 12:11:36','2019-09-19 12:11:36'),(37,38,2,'2019-09-19 12:11:36','2019-09-19 12:11:36'),(38,38,10,'2019-09-19 12:11:36','2019-09-19 12:11:36');

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

CREATE TABLE `partner_customers` (
  `partner_customer_id` int(11) NOT NULL AUTO_INCREMENT,
  `partner_customer_user_id` int(11) DEFAULT NULL,
  `partner_user_id` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`partner_customer_id`),
  KEY `fk_partner_customers_user_id_idx` (`partner_customer_user_id`),
  KEY `fk_partner_customers_partner_user_id_idx` (`partner_user_id`),
  CONSTRAINT `fk_partner_customers_partner_user_id` FOREIGN KEY (`partner_user_id`) REFERENCES `partner_user_details` (`partner_user_id`),
  CONSTRAINT `fk_partner_customers_user_id` FOREIGN KEY (`partner_customer_user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

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

INSERT INTO `partner_customers` VALUES (7,25,5,NULL,NULL,NULL),(8,19,17,NULL,NULL,NULL);

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

CREATE TABLE `partner_user_details` (
  `partner_user_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `partner_user_id` int(11) DEFAULT NULL,
  `partner_business_phone` varchar(13) DEFAULT NULL,
  `partner_logo` varchar(255) DEFAULT NULL,
  `notes` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`partner_user_details_id`),
  KEY `partner_user_details_user_id_idx` (`partner_user_id`),
  CONSTRAINT `fk_partner_user_details_user_id` FOREIGN KEY (`partner_user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

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

INSERT INTO `partner_user_details` VALUES (1,5,'9685741265','cat.jpeg',NULL),(2,17,'567 567 6789','softnotions.jpeg','test'),(3,18,'567 567 6789','softnotions.jpeg','test'),(4,26,'14725836931','maxresdefault (8).jpg','boomm'),(5,27,'16345646745','maxresdefault (8).jpg',NULL),(6,38,'12345678901','4.jpg',NULL);

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

CREATE TABLE `partner_user_locations` (
  `partner_user_location_id` int(11) NOT NULL AUTO_INCREMENT,
  `partner_user_id` int(11) NOT NULL,
  `partner_location_id` int(11) DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `county_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `is_territory` int(11) DEFAULT NULL,
  `zip_id` int(11) DEFAULT NULL,
  `address1` varchar(225) DEFAULT NULL,
  `address2` varchar(225) DEFAULT NULL,
  PRIMARY KEY (`partner_user_location_id`),
  KEY `fk_partner_user_locations_user_id_idx` (`partner_user_id`),
  KEY `fk_partner_user_locations_location_id_idx` (`partner_location_id`),
  CONSTRAINT `fk_partner_user_locations_location_id` FOREIGN KEY (`partner_location_id`) REFERENCES `locations` (`location_id`),
  CONSTRAINT `fk_partner_user_locations_user_id` FOREIGN KEY (`partner_user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

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

INSERT INTO `partner_user_locations` VALUES (1,5,NULL,1,1,1,1,NULL,2,'Nagercoil',NULL),(4,5,NULL,1,1,1,1,1,NULL,NULL,NULL),(5,17,NULL,2,2,2,3,NULL,5,'63 Meadow Lane\r\nWarner Robins, GA 31088','63 Meadow Lane\r\nWarner Robins, GA 31088'),(7,18,NULL,2,3,NULL,3,NULL,NULL,'63 Meadow Lane\r\nWarner Robins, GA 31088','63 Meadow Lane\r\nWarner Robins, GA 31088'),(10,18,NULL,2,2,2,3,1,NULL,NULL,NULL),(11,26,NULL,1,24,27,16,NULL,13,'qwerty','asdfg'),(19,17,NULL,2,2,2,3,1,NULL,NULL,NULL),(20,26,NULL,1,1,1,4,1,NULL,NULL,NULL),(21,26,NULL,1,27,40,NULL,1,NULL,NULL,NULL),(22,26,NULL,2,2,2,3,1,NULL,NULL,NULL),(23,26,NULL,4,NULL,NULL,NULL,1,NULL,NULL,NULL),(24,27,NULL,1,1,1,4,NULL,4,'654','kjjkh'),(29,27,NULL,1,1,8,8,1,NULL,NULL,NULL),(30,27,NULL,1,1,8,9,1,NULL,NULL,NULL),(31,27,NULL,1,1,8,10,1,NULL,NULL,NULL),(32,27,NULL,1,1,8,11,1,NULL,NULL,NULL),(33,27,NULL,2,NULL,NULL,NULL,1,NULL,NULL,NULL),(34,27,NULL,4,NULL,NULL,NULL,1,NULL,NULL,NULL),(35,38,NULL,1,1,1,4,NULL,6,'qwerdas\r\ndasfds\r\nfdsgdfghdf\r\n132145235\r\n!@#$%!$%#@#$%^#^','!$@3452\r\n343125234\r\nsgsygtrt\r\nertg');

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

CREATE TABLE `pro_tips` (
  `pro_tip_id` int(11) NOT NULL AUTO_INCREMENT,
  `pro_tip_name` varchar(50) DEFAULT NULL,
  `pro_tip_description` varchar(500) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_at` datetime DEFAULT NULL,
  `component_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`pro_tip_id`),
  KEY `fk_pro_tips_created_by_idx` (`created_by`),
  CONSTRAINT `fk_pro_tips_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

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

INSERT INTO `pro_tips` VALUES (1,'Test protips','test',1,1,'2019-09-06 11:31:00','2019-09-06 11:32:17',1),(2,'test','test',1,1,'2019-09-06 12:13:47','2019-09-06 12:13:47',1),(3,'door can be added to a 2\" wall system','door can be added to a 2\" wall system\r\ndoor can be added to a 2\" wall system',1,1,'2019-09-07 06:01:56','2019-09-07 06:01:56',4),(4,'HVAC','HVAC can be added to windows.\r\nHVAC can be added to windows.',0,1,'2019-09-07 06:03:29','2019-09-07 06:03:29',2),(5,'HVAC','HVAC can be added to windows.\r\nHVAC can be added to windows.',0,1,'2019-09-07 06:03:29','2019-09-07 06:03:29',2),(6,'HVAC','HVAC can be added to windows.\r\nHVAC can be added to windows.',0,1,'2019-09-07 06:03:30','2019-09-07 06:03:30',2),(7,'HVAC','HVAC can be added to windows.\r\nHVAC can be added to windows.',0,1,'2019-09-07 06:03:30','2019-09-07 06:03:30',2),(8,'HVAC','HVAC can be added to windows.\r\nHVAC can be added to windows.',0,1,'2019-09-07 06:03:30','2019-09-07 06:03:30',2),(9,'HVAC','HVAC can be added to windows.\r\nHVAC can be added to windows.',0,1,'2019-09-07 06:03:30','2019-09-07 06:03:30',2),(10,'HVAC','HVAC can be added to windows.\r\nHVAC can be added to windows.',1,1,'2019-09-07 06:03:30','2019-09-07 06:03:30',2),(11,'door can be added to a 2\" wall systemUIUHGHJGHJGHJ','door can be added to a 2\" wall system\r\ndoor can be added to a 2\" wall system\r\ndoor can be added to a 2\" wall systemdoor can be added to a 2\" wall system\r\ndoor can be added to a 2\" wall systemdoor can be added to a 2\" wall system\r\ndoor can be added to a 2',1,1,'2019-09-07 06:10:43','2019-09-09 11:49:44',4),(12,'Lorem Ipsum is simply dummy text of the printing a','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 ytururutruruLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum',1,1,'2019-09-09 10:17:29','2019-09-09 10:17:29',4),(13,'latest pro tip','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',1,1,'2019-09-09 11:31:37','2019-09-09 11:36:06',4),(14,'latest pro tip','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',1,1,'2019-09-09 11:31:37','2019-09-09 11:31:37',4),(15,'test mulitplw','doblwchk',1,1,'2019-09-24 09:03:18','2019-09-24 09:03:18',3),(16,'in verify new','veri',0,1,'2019-09-24 09:03:53','2019-09-24 09:04:14',3),(17,'in verify','veri',1,1,'2019-09-24 09:03:53','2019-09-24 09:03:53',3);

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

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

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


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

CREATE TABLE `product_properties` (
  `product_property_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_key_id` int(11) NOT NULL,
  `product_property_name` varchar(100) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`product_property_id`),
  KEY `fk_product_properties_product_key_id_idx` (`product_key_id`),
  CONSTRAINT `fk_product_properties_product_key_id` FOREIGN KEY (`product_key_id`) REFERENCES `product_keys` (`product_key_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- 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(11) NOT NULL AUTO_INCREMENT,
  `product_key_id` int(11) NOT NULL,
  `product_property_id` int(11) NOT NULL,
  `product_property_item` varchar(50) NOT NULL,
  `product_property_item_code` varchar(15) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`product_property_item_id`),
  KEY `fk_product_property_item_codes_product_key_id_idx` (`product_key_id`),
  KEY `fk_product_property_item_codes_product_property_id_idx` (`product_property_id`),
  CONSTRAINT `fk_product_property_item_codes_product_key_id` FOREIGN KEY (`product_key_id`) REFERENCES `product_keys` (`product_key_id`),
  CONSTRAINT `fk_product_property_item_codes_product_property_id` FOREIGN KEY (`product_property_id`) REFERENCES `product_properties` (`product_property_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `quote_revisions` (
  `quote_revision_id` int(11) NOT NULL AUTO_INCREMENT,
  `quote_revision_quote_id` int(11) NOT NULL,
  `quote_revision_drawing_id` int(11) NOT NULL,
  `quote_revision_drawing_template_id` int(11) DEFAULT NULL,
  `quote_revision_status` tinyint(1) NOT NULL,
  `quote_revision_quote_status` tinyint(1) NOT NULL,
  `quote_revision_version_title` varchar(100) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`quote_revision_id`),
  KEY `fk_quote_revisions_quote_id_idx` (`quote_revision_quote_id`),
  KEY `fk_quote_revisions_drawing_id_idx` (`quote_revision_drawing_id`),
  KEY `fk_quote_revisions_drawing_template_id_idx` (`quote_revision_drawing_template_id`),
  CONSTRAINT `fk_quote_revisions_drawing_id` FOREIGN KEY (`quote_revision_drawing_id`) REFERENCES `drawings` (`drawing_id`),
  CONSTRAINT `fk_quote_revisions_drawing_template_id` FOREIGN KEY (`quote_revision_drawing_template_id`) REFERENCES `drawing_templates` (`drawing_template_id`),
  CONSTRAINT `fk_quote_revisions_quote_id` FOREIGN KEY (`quote_revision_quote_id`) REFERENCES `quotes` (`quote_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `quotes` (
  `quote_id` int(11) NOT NULL AUTO_INCREMENT,
  `quote_name` varchar(100) DEFAULT NULL,
  `quote_customer_id` int(11) DEFAULT NULL,
  `quote_start_date` datetime DEFAULT NULL,
  `quote_end_date` datetime DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `partner_user_id` int(11) DEFAULT NULL,
  `sales_order_no` varchar(15) DEFAULT NULL,
  `sales_user_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `building_type` int(11) DEFAULT NULL,
  `expiry_date` datetime DEFAULT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `job_name` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`quote_id`),
  KEY `fk_quotes_customer_id_idx` (`quote_customer_id`),
  KEY `fk_quotes_created_by_idx` (`created_by`),
  CONSTRAINT `fk_quotes_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`),
  CONSTRAINT `fk_quotes_customer_id` FOREIGN KEY (`quote_customer_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

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

INSERT INTO `quotes` VALUES (1,'IDQ-1',NULL,NULL,NULL,2,1,'2019-09-09 12:32:48','2019-09-09 12:32:48',17,NULL,NULL,NULL,1,NULL,2,'job 1'),(2,'test new',21,NULL,NULL,1,1,'2019-09-10 06:04:33','2019-09-17 10:44:15',5,NULL,NULL,NULL,1,NULL,1,'newjob'),(3,'IDQ-2',22,NULL,NULL,1,1,'2019-09-10 09:33:07','2019-09-18 08:11:48',17,'ndfghj',11,NULL,1,NULL,2,'job-2'),(4,'Tesy',NULL,NULL,NULL,2,1,'2019-09-17 08:16:59','2019-09-18 10:50:42',17,NULL,NULL,NULL,1,NULL,2,'test'),(5,'1d23',NULL,NULL,NULL,2,1,'2019-09-17 11:24:42','2019-09-17 11:24:42',5,NULL,NULL,NULL,1,NULL,1,'job23'),(6,'1dq43',28,NULL,NULL,0,1,'2019-09-17 11:27:23','2019-09-19 11:10:42',5,NULL,NULL,NULL,1,NULL,1,'job43'),(7,'5325',30,NULL,NULL,0,1,'2019-09-17 11:35:49','2019-09-18 10:49:03',5,NULL,NULL,NULL,1,NULL,1,'qwre'),(8,'test new',31,NULL,NULL,0,5,'2019-09-17 11:38:08','2019-09-18 11:49:47',5,NULL,NULL,NULL,1,NULL,1,'new'),(9,'Test 17',NULL,NULL,NULL,2,1,'2019-09-17 11:50:16','2019-09-18 10:47:51',5,NULL,NULL,NULL,1,NULL,1,'dr'),(10,'Dreaft test',32,NULL,NULL,1,1,'2019-09-17 11:51:56','2019-09-18 10:47:04',5,'45634fg*^&*%',NULL,NULL,1,NULL,1,'newjob'),(11,'IDQ11',33,NULL,NULL,0,1,'2019-09-17 12:08:43','2019-09-19 10:57:36',5,NULL,NULL,NULL,1,NULL,1,'Job11'),(12,'idq-1 part',34,NULL,NULL,0,17,'2019-09-18 11:36:00','2019-09-18 11:36:40',5,'so123',8,NULL,1,NULL,1,'job part'),(13,'House plan',43,NULL,NULL,0,1,'2019-09-19 05:10:56','2019-09-19 05:10:56',5,NULL,NULL,NULL,1,NULL,1,'Construction'),(14,'Home plan !',NULL,NULL,NULL,2,1,'2019-09-19 06:22:32','2019-09-19 06:22:32',5,NULL,NULL,NULL,1,NULL,1,'Construction'),(15,'Home plan 2',35,NULL,NULL,1,1,'2019-09-19 06:44:22','2019-09-19 06:44:22',5,NULL,NULL,NULL,1,NULL,1,'Construction'),(16,'Home paln 3',60,NULL,NULL,0,1,'2019-09-19 08:40:42','2019-09-19 08:40:42',5,NULL,NULL,NULL,1,NULL,1,'Construction'),(17,'SGFG',NULL,NULL,NULL,2,1,'2019-09-19 11:48:52','2019-09-24 10:33:46',5,NULL,NULL,NULL,1,NULL,1,'JO78'),(18,'TESTFH',37,NULL,NULL,0,1,'2019-09-19 11:58:28','2019-09-19 13:30:45',5,NULL,NULL,NULL,1,NULL,1,'JO89'),(19,'iDQ-123',40,NULL,NULL,0,1,'2019-09-19 11:59:23','2019-09-23 12:32:02',5,'1234567',11,NULL,1,NULL,1,'JO34'),(20,'School',NULL,NULL,NULL,2,1,'2019-09-20 05:00:04','2019-09-20 06:25:59',4,NULL,NULL,NULL,1,NULL,1,'Construction'),(21,'ITpark',41,NULL,NULL,1,1,'2019-09-20 05:04:01','2019-09-20 05:04:01',5,'testing 1',11,NULL,1,NULL,1,'Construction'),(22,'ITpark',42,NULL,NULL,0,1,'2019-09-20 05:07:27','2019-09-20 05:07:27',5,'OD124578',11,NULL,1,NULL,1,'Construction'),(23,'test',45,NULL,NULL,0,1,'2019-09-20 08:02:17','2019-09-20 08:02:17',5,NULL,NULL,NULL,1,NULL,1,'test'),(24,'uiyu',46,NULL,NULL,0,1,'2019-09-20 08:11:57','2019-09-20 08:11:57',5,NULL,NULL,NULL,1,NULL,1,'iyuiuyiy'),(25,'test',51,NULL,NULL,1,1,'2019-09-20 09:14:59','2019-09-20 09:14:59',5,'khjkl',11,NULL,1,NULL,1,'tes'),(26,'1das',47,NULL,NULL,1,1,'2019-09-20 09:49:44','2019-09-20 09:49:44',5,'123',8,NULL,1,NULL,1,'asdas'),(27,'Shop plan',52,NULL,NULL,0,1,'2019-09-24 10:12:35','2019-09-24 10:35:26',5,NULL,NULL,NULL,1,NULL,1,'Building constr'),(28,'test29an',58,NULL,NULL,0,1,'2019-09-24 10:32:39','2019-09-24 11:34:25',5,NULL,NULL,NULL,1,NULL,1,'new'),(29,'Kinfra park',61,NULL,NULL,0,1,'2019-09-24 11:03:22','2019-09-24 11:03:22',5,NULL,NULL,NULL,1,NULL,1,'Construction'),(30,'Kinfra park',61,NULL,NULL,0,1,'2019-09-24 12:14:34','2019-09-24 12:14:34',5,NULL,NULL,NULL,1,NULL,1,'Construction'),(31,'institution',62,NULL,NULL,0,1,'2019-09-24 12:43:01','2019-09-24 12:43:01',5,NULL,NULL,NULL,1,NULL,1,'Construction'),(32,'institution',62,NULL,NULL,0,1,'2019-09-24 12:48:10','2019-09-24 12:48:10',5,NULL,NULL,NULL,1,NULL,1,'Construction'),(33,'institution',62,NULL,NULL,0,1,'2019-09-24 12:48:37','2019-09-24 12:48:37',5,NULL,NULL,NULL,1,NULL,1,'Construction'),(34,'sdf',NULL,NULL,NULL,2,1,'2019-09-25 13:47:21','2019-09-25 13:47:21',5,NULL,NULL,NULL,1,NULL,1,'df'),(35,'dsfds',63,NULL,NULL,1,1,'2019-09-26 03:41:50','2019-09-26 03:41:50',5,'ODP564789132',11,NULL,1,NULL,1,'pdf'),(38,'draftdraw',NULL,NULL,NULL,2,1,'2019-09-26 10:09:53','2019-09-26 10:09:53',5,NULL,NULL,NULL,1,NULL,NULL,'new'),(39,'mymual',66,NULL,NULL,0,1,'2019-09-26 10:55:59','2019-09-26 10:56:25',5,NULL,NULL,NULL,1,NULL,1,'new'),(40,'testfor directorder',67,NULL,NULL,0,1,'2019-09-26 11:22:03','2019-09-26 11:22:03',5,NULL,NULL,NULL,1,NULL,1,'nrwinten');

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

CREATE TABLE `role_permissions` (
  `role_permission_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `page_id` int(11) DEFAULT NULL,
  `page_field_id` int(11) 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`),
  KEY `role_id_role_permissions_idx` (`role_id`),
  KEY `page_id_role_permissions_idx` (`page_id`),
  KEY `field_id_role_permissions_idx` (`page_field_id`),
  CONSTRAINT `fk_role_permissions_field_id` FOREIGN KEY (`page_field_id`) REFERENCES `page_fields` (`page_field_id`),
  CONSTRAINT `fk_role_permissions_page_id` FOREIGN KEY (`page_id`) REFERENCES `pages` (`page_id`),
  CONSTRAINT `fk_role_permissions_role_id` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=latin1;

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

INSERT INTO `role_permissions` VALUES (15,8,17,NULL,1,1,1,NULL),(20,9,13,NULL,1,NULL,NULL,NULL),(21,9,14,NULL,1,NULL,NULL,NULL),(22,9,16,NULL,1,NULL,NULL,NULL),(23,9,17,NULL,1,1,1,1),(29,10,7,NULL,1,NULL,NULL,NULL),(30,10,8,NULL,1,NULL,NULL,NULL),(31,10,9,NULL,1,NULL,NULL,NULL),(32,10,10,NULL,1,NULL,NULL,NULL),(33,10,11,NULL,1,NULL,NULL,NULL),(34,11,17,NULL,1,NULL,NULL,NULL),(35,12,7,NULL,1,NULL,NULL,NULL),(36,12,8,NULL,1,1,1,NULL),(37,12,10,NULL,1,1,1,NULL),(38,5,9,NULL,1,NULL,NULL,NULL),(39,6,1,NULL,1,1,NULL,NULL),(40,6,8,NULL,1,1,1,1),(41,6,10,NULL,1,1,1,1),(42,6,13,NULL,1,1,1,NULL),(43,7,8,NULL,1,1,1,1),(44,7,9,NULL,1,1,1,1),(45,7,10,NULL,1,1,1,1),(46,7,17,NULL,1,1,1,NULL),(55,2,1,NULL,1,1,1,1),(56,2,3,NULL,1,1,1,1),(57,2,9,NULL,1,1,1,1),(58,2,10,NULL,1,1,1,1),(59,2,11,NULL,1,1,1,1),(60,2,13,NULL,1,1,1,1),(61,2,15,NULL,1,1,1,1),(62,2,18,NULL,NULL,1,NULL,NULL);

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

CREATE TABLE `roles` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) NOT NULL,
  `role_description` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `owner_user` int(11) DEFAULT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

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

INSERT INTO `roles` VALUES (1,'Admin','Super administrator of the site',NULL,NULL,NULL),(2,'Partner','The core partner role',NULL,NULL,NULL),(3,'Customer','The core customer role',NULL,NULL,NULL),(5,'test','test role t','2019-09-06 07:53:15','2019-09-06 09:58:59',1),(6,'Estimator','estimator','2019-09-06 09:50:24','2019-09-06 09:50:24',1),(7,'Sales person','Sales person','2019-09-06 09:53:30','2019-09-06 09:53:30',1),(8,'Project manager','Project manager','2019-09-06 09:54:10','2019-09-06 09:54:10',1),(9,'Design manager','Design manager','2019-09-06 09:55:02','2019-09-06 09:55:02',1),(10,'Production clerk','Production clerk','2019-09-06 09:57:24','2019-09-06 09:57:38',1),(11,'Installer','Installer','2019-09-06 09:58:01','2019-09-06 09:58:01',1),(12,'Partner accounting','Partner accounting','2019-09-06 09:58:41','2019-09-06 09:58:41',1),(13,'Installer2','Installer2','2019-09-06 11:10:35','2019-09-06 11:10:35',6);

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

CREATE TABLE `rule_categories` (
  `rule_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `rule_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`rule_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `rules` (
  `rule_id` int(11) NOT NULL AUTO_INCREMENT,
  `rule_description` varchar(500) NOT NULL,
  `rule_message` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`rule_id`),
  KEY `fk_rules_created_by_idx` (`created_by`),
  CONSTRAINT `fk_rules_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

INSERT INTO `rules` VALUES (3,'Test Rule 1','Rule Message 1',1,1,NULL),(4,'Test Rule 2','Rule Message 2',1,1,NULL);

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

CREATE TABLE `todos` (
  `todo_id` int(11) NOT NULL AUTO_INCREMENT,
  `todo_name` varchar(50) DEFAULT NULL,
  `todo_description` varchar(500) DEFAULT NULL,
  `todo_assigned_to` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `todo_startdate` date DEFAULT NULL,
  `todo_enddate` date DEFAULT NULL,
  PRIMARY KEY (`todo_id`),
  KEY `fk_todos_created_by_idx` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

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

INSERT INTO `todos` VALUES (1,'customer order creation','customer order creation',1,0,1,'2019-09-06 06:00:44','2019-09-07 06:38:06','2019-09-04','2019-09-06'),(2,'test','test',1,1,1,'2019-09-06 12:06:10','2019-09-06 13:13:55','2019-09-06','2019-09-06'),(3,'customer order creation','customer order creation',17,1,1,'2019-09-07 07:18:01','2019-09-07 07:18:01','2019-09-05','2019-09-06'),(4,'Assign brands to partners','Assign brands to partners',18,1,1,'2019-09-07 07:18:36','2019-09-07 07:18:36','2019-09-06','2019-09-08'),(5,'To do\'s for all','To do\'s for all',19,1,17,'2019-09-09 13:49:52','2019-09-10 05:34:28','2019-09-09','2019-09-10'),(6,'test','test',19,1,1,'2019-09-09 13:50:18','2019-09-09 13:50:18','2019-09-09','2019-09-10'),(7,'test','test',19,1,1,'2019-09-09 13:50:18','2019-09-09 13:50:18','2019-09-09','2019-09-10'),(8,'new','gdhd',1,1,17,'2019-09-26 06:34:53','2019-09-26 06:34:53','2019-09-26','2019-09-30');

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

CREATE TABLE `tutorials` (
  `tutorial_id` int(11) NOT NULL AUTO_INCREMENT,
  `tutorial_name` varchar(50) DEFAULT NULL,
  `tutorial_description` varchar(500) DEFAULT NULL,
  `tutorial_content` text,
  `tutorial_url` varchar(500) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`tutorial_id`),
  KEY `fk_tutorials_created_by_idx` (`created_by`),
  CONSTRAINT `fk_tutorials_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- 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.</span><!--EndFragment-->','https://www.youtube.com/embed/g5yxt5G5DPY',1,1,'2019-09-06 06:55:59','2019-09-06 07:06:33'),(2,'Allied modular overview - Youtube','Would you like to learn more about maximizing space and environmentally friendly construction?','<p>\r\n\r\n<span>Would you like to learn more about maximizing space and environmentally friendly construction?  \r\n\r\nCall us today at 888-836-7850 or visit our website: www.alliedmodular.com</span>\r\n\r\n</p><p></p><p>\r\n\r\n<span>Would you like to learn more about maximizing space and environmentally friendly construction?  \r\n\r\nCall us today at 888-836-7850 or visit our website: www.alliedmodular.com</span>\r\n\r\n</p><p></p><p>\r\n\r\n<span>Would you like to learn more about maximizing space and environmentally friendly construction?  \r\n\r\nCall us today at 888-836-7850 or visit our website: www.alliedmodular.com</span>\r\n\r\n</p>','https://www.youtube.com/embed/ObE5nFwHVMo',1,1,'2019-09-06 07:06:02','2019-09-06 07:06:50'),(3,'Amazing Motorized Modular Machine Enclosure','Amazing Motorized Modular Machine Enclosure','<p>\r\n\r\n<span><em>Amazing Motorized Modular Machine Enclosure</em>\r\n</span></p><p><span>\r\n\r\n\r\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> \r\n\r\nCall us today at 888-836-7850 or visit our website: www.alliedmodular.com</span></p><p></p><p><span></span>\r\n\r\n</p>','https://www.youtube.com/embed/wxrIwCQVqRY',1,1,'2019-09-06 07:09:13','2019-09-06 07:09:23'),(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'),(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'),(6,'test','test description','test','https://www.youtube.com/embed/PePtCzANOWc',0,1,'2019-09-09 14:49:16','2019-09-09 14:49:59'),(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',0,1,'2019-09-09 14:49:52','2019-09-09 14:49:56'),(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','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-09-25 10:12:48'),(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-09-25 10:12:44'),(10,'Allied Modular Modular Buildin','Allied Modular Modular Buildings and Office Construction','<p><meta content=\"text/html; charset=utf-8\">\r\n<meta content=\"Word.Document\">\r\n<meta content=\"Microsoft Word 12\">\r\n<meta content=\"Microsoft Word 12\">\r\n<link rel=\"File-List\" href=\"file:///C:\\Users\\STPL2\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_filelist.xml\">\r\n<link rel=\"themeData\" href=\"file:///C:\\Users\\STPL2\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_themedata.thmx\">\r\n<link rel=\"colorSchemeMapping\" href=\"file:///C:\\Users\\STPL2\\AppData\\Local\\Temp\\msohtmlclip1\\01\\clip_colorschememapping.xml\">\r\n\r\n<style>\r\n\r\n</style>\r\n\r\n\r\n\r\n\r\n<span>Allied Modular Modular Buildings and Office\r\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',0,1,'2019-09-09 14:55:41','2019-09-25 10:12:57');

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

CREATE TABLE `user_roles` (
  `user_role_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`user_role_id`),
  KEY `fk_user_user_roles_idx` (`user_id`),
  KEY `fk_role_user_roles_idx` (`role_id`),
  CONSTRAINT `fk_user_roles_role` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`),
  CONSTRAINT `fk_user_roles_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;

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

INSERT INTO `user_roles` VALUES (1,1,1,NULL,NULL),(3,4,2,NULL,NULL),(4,5,2,NULL,NULL),(6,7,11,NULL,NULL),(9,10,3,NULL,NULL),(11,12,8,NULL,NULL),(13,14,12,NULL,NULL),(15,16,11,NULL,NULL),(16,15,11,NULL,NULL),(19,3,3,NULL,NULL),(20,17,2,NULL,NULL),(21,18,2,NULL,NULL),(23,6,6,NULL,NULL),(24,8,7,NULL,NULL),(25,9,13,NULL,NULL),(26,11,7,NULL,NULL),(27,13,10,NULL,NULL),(28,20,3,NULL,NULL),(29,21,3,NULL,NULL),(30,22,3,NULL,NULL),(31,23,3,NULL,NULL),(32,24,3,NULL,NULL),(33,26,2,NULL,NULL),(34,27,2,NULL,NULL),(35,28,3,NULL,NULL),(36,29,3,NULL,NULL),(37,30,3,NULL,NULL),(38,31,3,NULL,NULL),(39,32,3,NULL,NULL),(40,33,3,NULL,NULL),(41,34,3,NULL,NULL),(42,35,3,NULL,NULL),(43,36,3,NULL,NULL),(44,37,3,NULL,NULL),(45,38,2,NULL,NULL),(46,39,3,NULL,NULL),(47,40,3,NULL,NULL),(48,41,3,NULL,NULL),(49,42,3,NULL,NULL),(50,43,3,NULL,NULL),(51,44,3,NULL,NULL),(52,45,3,NULL,NULL),(53,46,3,NULL,NULL),(54,47,3,NULL,NULL),(55,48,3,NULL,NULL),(56,49,3,NULL,NULL),(57,50,3,NULL,NULL),(58,51,3,NULL,NULL),(59,52,3,NULL,NULL),(60,53,3,NULL,NULL),(61,54,3,NULL,NULL),(62,55,3,NULL,NULL),(63,56,3,NULL,NULL),(64,57,3,NULL,NULL),(65,58,3,NULL,NULL),(66,59,3,NULL,NULL),(67,60,3,NULL,NULL),(68,61,3,NULL,NULL),(69,62,3,NULL,NULL),(70,63,3,NULL,NULL),(71,64,3,NULL,NULL),(72,65,3,NULL,NULL),(73,66,3,NULL,NULL),(74,67,3,NULL,NULL),(75,19,3,NULL,NULL);

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

CREATE TABLE `zip_codes` (
  `zip_id` int(11) NOT NULL AUTO_INCREMENT,
  `zip_code` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`zip_id`),
  KEY `fk_zipCode_idx` (`city_id`),
  CONSTRAINT `fk_zip` FOREIGN KEY (`city_id`) REFERENCES `cities` (`city_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `zip_codes` VALUES (2,12345,4),(3,12346,4),(4,9876,4),(5,10234,3),(6,14565,4),(7,69156,8),(8,12356,9),(9,78945,12),(10,12311,13),(11,78945,14),(12,45636,15),(13,12321,16),(14,12458,4),(15,12457,18),(16,78965,19),(17,54689,20),(18,45687,21);


