-- MySQL dump 10.13  Distrib 5.7.27, for Linux (x86_64)
--
-- Host: localhost    Database: hfs_master
-- ------------------------------------------------------
-- Server version	5.7.27-0ubuntu0.16.04.1


--
-- Table structure for table `agent_faq`
--

DROP TABLE IF EXISTS `agent_faq`;

CREATE TABLE `agent_faq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `slug` varchar(1000) NOT NULL,
  `answer` mediumtext NOT NULL,
  `category` int(11) NOT NULL DEFAULT '0',
  `displayOrder` int(11) NOT NULL,
  `createdBy` int(11) NOT NULL,
  `updatedBy` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;


--
-- Dumping data for table `agent_faq`
--

LOCK TABLES `agent_faq` WRITE;

INSERT INTO `agent_faq` VALUES (1,'How do I get leads delivered?','','All leads are delivered to your inbox and in addition, they’re displayed right here on the portal! Keep an eye out for other delivery methods, such as text alerts.',0,1,0,0,'2019-07-22 10:15:04','2019-09-06 19:27:42',1),(2,'Why did my charge go up for one of my zipcodes?','','Your charge usually goes up because a lead has been delivered to you. Congrats! You should see it displayed in the lead box below and it should also be present in your inbox. If you’re having trouble finding it, <a href=\"/contact\">contact us</a>.',0,11,0,0,'2019-07-22 10:16:55','2019-09-06 19:35:46',1),(3,'What’s your pricing?','','<span style=\"text-indent: -24px;\">We charge between $5 and $35 a zip code&nbsp;</span><u style=\"text-indent: -24px;\">per month.&nbsp;</u><span style=\"text-indent: -24px;\">All of our zip codes, once the reservation fee is paid, are at the $5 level until a valid lead is delivered to you. Then, the reservation fee pricing resumes.</span>',0,14,0,0,'2019-07-22 12:53:48','2019-09-06 19:36:03',1),(4,'How do I cancel?','','<div>You’ll need to reach out to <a href=\"mailto:support@housesforsale.com\">support@housesforsale.com</a> with a written request to cancel. We’re very sorry to see you go, but we have a no-hassle cancellation policy and will have your account closed within 48 hours.</div>',0,13,0,0,'2019-07-22 12:55:47','2019-09-06 19:35:58',1),(5,'Can I cancel anytime?','','Yes, you may cancel anytime, no questions asked!',0,12,0,0,'2019-07-22 12:56:41','2019-09-06 19:35:52',1),(6,'How do I buy more zips?','','You can simply click ‘buy more zips’ in the zip code box below to be taken to the zip code purchase page.',0,2,0,0,'2019-07-22 12:57:42','2019-09-06 19:27:59',1),(7,'Can I get leads texted to me?','','<p class=\"MsoNormal\" style=\"margin-bottom:12.0pt\">Currently, we do not have this functionality, but it is on our lengthy list of improvements we want to bring to our agents.<br></p>',0,3,0,0,'2019-07-22 12:58:37','2019-09-06 19:28:06',1),(8,'How do I change the city my bio page says I\'m located in?','','We are working on a more permanent solution for this, but for now, you can change the city in your agent bio details&nbsp;(located&nbsp;<a href=\"https://housesforsale.com/adminagent/managemyagent\" target=\"_blank\">here</a>). While this may make your information incorrect, your address is not something we share with others, so updating the city will not affect your account.&nbsp;',0,4,0,0,'2019-08-05 15:28:00','2019-09-06 19:28:13',1),(9,'What\'s included in my purchase?','','<p style=\"margin-right: 0px; margin-left: 0px; font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, Oxygen-Sans, Ubuntu, Cantarell, &quot;Helvetica Neue&quot;, Arial, sans-serif; font-size: 14px; line-height: 20px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; color: rgb(51, 51, 51);\">• An Exclusive Zip Code, we only sale the Zip Code to one Agent,</p><p style=\"margin-right: 0px; margin-left: 0px; font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, Oxygen-Sans, Ubuntu, Cantarell, &quot;Helvetica Neue&quot;, Arial, sans-serif; font-size: 14px; line-height: 20px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; color: rgb(51, 51, 51);\">• Your own Exclusive Hyper-location defined by your Zip Code, \"Houses for Sale in Dallas\" for example,</p><p style=\"margin-right: 0px; margin-left: 0px; font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, Oxygen-Sans, Ubuntu, Cantarell, &quot;Helvetica Neue&quot;, Arial, sans-serif; font-size: 14px; line-height: 20px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; color: rgb(51, 51, 51);\">• Passive and Active Lead Generation.</p><p style=\"margin-right: 0px; margin-left: 0px; font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, Oxygen-Sans, Ubuntu, Cantarell, &quot;Helvetica Neue&quot;, Arial, sans-serif; font-size: 14px; line-height: 20px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; color: rgb(51, 51, 51);\">• Your own Website with unlimited hyper-local landing pages including hyper-local neighborhood landing pages with Blogs and Vlogs,</p><p style=\"margin-right: 0px; margin-left: 0px; font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, Oxygen-Sans, Ubuntu, Cantarell, &quot;Helvetica Neue&quot;, Arial, sans-serif; font-size: 14px; line-height: 20px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; color: rgb(51, 51, 51);\">• All leads are automatically sent straight to you via email (text coming soon,) and;</p><p style=\"margin-right: 0px; margin-left: 0px; font-family: system-ui, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, Oxygen-Sans, Ubuntu, Cantarell, &quot;Helvetica Neue&quot;, Arial, sans-serif; font-size: 14px; line-height: 20px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; color: rgb(51, 51, 51);\">• Use of the patent pending agent share button which allows you to post on any digital format (Social Media, Facebook or email in two clicks) this is great for branding!</p>',0,5,0,0,'2019-08-08 17:28:11','2019-09-06 19:28:23',1),(10,'How do you verify our leads aren\'t bogus?','','Our leads all go through a rigorous 3-tier process to verify their legitimacy. <b>Sometimes a lead will show up in your inbox that doesn\'t count, </b>so no worries if you get a lead that is obviously fake - we didn\'t count it!&nbsp;<div><br></div><div>Step 1. A number verify system ensures the number is a valid format and a valid phone number.</div><div>Step 2. An email verification system ensures the email is valid in format.</div><div>Step 3. Leads that clear these two steps are sent to us and you. We put a set of eyeballs on them that see if the name, phone number, and email are actually valid. So while John McTest might clear our filters, it won\'t clear us! In addition, we look for emails that are obviously real estate emails - these are not counted as leads, either.&nbsp;</div>',0,6,0,0,'2019-08-08 17:39:38','2019-09-06 19:28:29',1),(11,'I was charged for a lead that turned out to be fake. What do I do?','','Please contact us so we can make it right and include the lead you received.&nbsp;',0,7,0,0,'2019-08-08 18:18:40','2019-09-06 19:28:35',1),(12,'I want to purchase another zip code, but it looks like it\'s pending. How do I purchase a pending zip code?','','Zip codes go into pending for a number of reasons, and sometimes a zip gets stuck there due to a failed or incomplete purchase. If this is the reason your zip code is pending, we\'ll be able to release it for you to purchase. Just drop us a line at support@housesforsale.com and we\'ll be happy to help.<div><br></div><div>Please keep in mind that not all zip codes that are pending are available for purchase. Some are locked up for because they were released to the waitlist for purchase. These zip codes, if not purchased by agents on the waitlist, will become available sooner or later.&nbsp;</div>',0,8,0,0,'2019-09-06 19:25:17','2019-09-06 19:28:41',1),(13,'I signed up for a DotLoop subscription - what comes with it?','','The DotLoop account you have access to now is DotLoop Premium, which is usually $29 a month. You\'re paying just $8, thanks to our partnership with this amazing company. You can read what that includes&nbsp;<a href=\"https://www.dotloop.com/products/plans-pricing/\" target=\"_blank\">here on their website</a>.&nbsp;',0,9,0,0,'2019-09-06 19:30:59','2019-09-06 19:31:18',1),(14,'There is incorrect information on my listing on your site. What do I do?','','If the incorrect information is located in the agent expert box, you can fix that by simply visiting your&nbsp;<a href=\"https://housesforsale.com/adminagent/managemyagent\" target=\"_blank\">agent info page</a>&nbsp;and updating the incorrect information.&nbsp;<div><br></div><div>If there is incorrect information in other parts of your listing, such as the description, broker, listing agent, or amenities, this is something that will have to be done through our syndication partner. We\'ll be happy to facilitate that update - reach out to us and we can make it happen!</div>',0,10,0,0,'2019-09-06 19:34:38','2019-09-06 19:35:05',1);

UNLOCK TABLES;

--
-- Table structure for table `agent_badges`
--

DROP TABLE IF EXISTS `agent_badges`;

CREATE TABLE `agent_badges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `badgeName` varchar(50) DEFAULT NULL,
  `badgeBGType` tinyint(4) NOT NULL,
  `badgeUrl` varchar(128) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `createdBy` int(11) NOT NULL,
  `updatedBy` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;


--
-- Dumping data for table `agent_badges`
--

LOCK TABLES `agent_badges` WRITE;

INSERT INTO `agent_badges` VALUES (1,'Badge-1',1,'0b86b399414a70d6a318d7018dc2a1e8.png','2019-07-17 08:03:17','2019-07-17 08:04:29',4702,4702,1),(2,'Badge-2',1,'82262d32f4e01e23fcc46109eeb68604.png','2019-07-17 09:14:50','2019-07-17 09:14:51',4702,4702,1),(3,'Badge-3',1,'2aa0b69c81b4cb17673b3a107913800f.png','2019-07-17 09:15:57','2019-07-17 09:15:57',4702,4702,1),(4,'Badge-4',1,'dcac753819af7f741c0bf803f6a15a76.png','2019-07-17 09:16:17','2019-07-17 09:16:17',4702,4702,1),(5,'Badge-5',1,'129582e933508bfc72f4f48a1ecae314.png','2019-07-17 09:17:46','2019-07-17 09:17:46',4702,4702,1),(6,'Badge-6',1,'4538c6ead5ab351d8a557084e8c5e7ff.png','2019-07-17 09:18:25','2019-07-17 09:18:26',4702,4702,1),(7,'Badge-7',1,'9492362ac7d8510f181251532212b76c.png','2019-07-17 09:18:41','2019-07-17 09:18:41',4702,4702,1),(8,'Badge-8',1,'99de8763c371fe7e960bddd8d4b22215.png','2019-07-17 09:18:55','2019-07-17 09:18:55',4702,4702,1),(9,'Badge-9',1,'4f97ff1a1c59e1ab38f907d97537270c.png','2019-07-17 09:19:10','2019-07-17 09:19:11',4702,4702,1),(10,'Badge-10',1,'eb2d3ac9b7c0cb66649611a7d9b6afec.png','2019-07-17 09:19:29','2019-07-17 09:19:29',4702,4702,1),(11,'Badge-11',1,'5addc8b11c262f49ebcc3584d7aadd1c.png','2019-07-17 09:19:59','2019-07-17 09:19:59',4702,4702,1),(12,'Badge-12',1,'9c807beaf208c9f235aa895e5c7a58f2.png','2019-07-17 09:20:18','2019-07-17 09:20:18',4702,4702,1),(13,'Badge-13',1,'e8f34f928f26c94ad8e74e578543936b.png','2019-07-17 09:20:38','2019-07-17 09:20:39',4702,4702,1),(14,'Badge-14',1,'6a35c5de306454904a3deb260a317cb4.png','2019-07-17 09:20:54','2019-07-17 09:20:54',4702,4702,1),(15,'Badge-15',1,'afbd44e905d81e0f16303452b32feb5e.png','2019-07-17 09:21:10','2019-07-17 09:21:10',4702,4702,1),(16,'Badge-16',2,'2a9700c8199566617a5ea2b51cf9203c.png','2019-07-17 09:23:17','2019-07-17 09:23:18',4702,4702,1),(17,'Badge-17',2,'47e6b33a7133c3b4499840a560d97f1f.png','2019-07-17 09:25:30','2019-07-17 09:25:30',4702,4702,1),(18,'Badge-18',2,'caa754143e4a3434f05def10a747f8ad.png','2019-07-17 09:26:01','2019-07-17 09:26:01',4702,4702,1),(19,'Badge-19',2,'1cbb4dbfa59f5eb3b5ba0068b7384b27.png','2019-07-17 09:26:24','2019-07-17 09:26:24',4702,4702,1),(20,'Badge-20',2,'c146daaadbd0f92fe9fc03170f070ba3.png','2019-07-17 09:26:45','2019-07-17 09:26:45',4702,4702,1),(21,'Badge-21',2,'489176106e89efe6cdf8a96d18998d28.png','2019-07-17 09:27:15','2019-07-17 09:28:28',4702,4702,1),(22,'Badge-22',2,'79fbb930bf690c9289804090d2a19943.png','2019-07-17 09:29:25','2019-07-17 09:29:25',4702,4702,1),(23,'Badge-23',2,'df412ce81090edeacbd86cad3ed7db4f.png','2019-07-17 09:29:40','2019-07-17 09:29:40',4702,4702,1),(24,'Badge-24',2,'6a62a5efd33e349de47f4224e5aa2ff6.png','2019-07-17 09:30:07','2019-07-17 09:30:07',4702,4702,1),(25,'Badge-25',2,'e81414c467e5740d3899a8563f56b727.png','2019-07-17 09:30:39','2019-07-17 09:30:40',4702,4702,1),(26,'Badge-26',2,'f0a4c93fc1834c7edfbe816452a6e581.png','2019-07-17 09:30:57','2019-07-17 09:30:57',4702,4702,1),(27,'Badge-27',2,'1ee3c97f5ecd40832c08dc3285a8afea.png','2019-07-17 09:31:18','2019-07-17 09:31:18',4702,4702,1),(28,'Badge-28',2,'13cfe395de0dfe60bfa69157007c0228.png','2019-07-17 09:31:36','2019-07-17 09:31:36',4702,4702,1),(29,'Badge-29',2,'a8f201b3e950851f9cd3e8d415cc802f.png','2019-07-17 09:31:57','2019-07-17 09:31:57',4702,4702,1),(30,'Badge-30',2,'50efc25de8becdfa693eeb73c83e3a9a.png','2019-07-17 09:32:20','2019-09-06 10:46:03',4702,4702,1);

UNLOCK TABLES;

--
-- Table structure for table `agent_blogs_by_admin`
--

DROP TABLE IF EXISTS `agent_blogs_by_admin`;

CREATE TABLE `agent_blogs_by_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adminId` int(11) NOT NULL,
  `title` varchar(500) DEFAULT NULL,
  `slug` varchar(500) DEFAULT NULL,
  `content` text CHARACTER SET utf8,
  `metaPageTitle` varchar(500) DEFAULT NULL,
  `metaPageDesc` varchar(500) DEFAULT NULL,
  `metaKeyword` varchar(200) DEFAULT NULL,
  `blogImage` varchar(250) DEFAULT NULL,
  `plagiarism_result` mediumtext,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FK_admin_to_blog` (`adminId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;


--
-- Dumping data for table `agent_blogs_by_admin`
--

LOCK TABLES `agent_blogs_by_admin` WRITE;

INSERT INTO `agent_blogs_by_admin` VALUES (15,4833,'<h1>New Feature! - Agent Dashboard</h1>','New_Feature_Agent_Dashboard','<p>\n    The Agent Dashboard is here! We have been working on this feature for <i>months</i>&nbsp;and are very excited to finally present it to you all. It\'s in BETA mode, so please do let us know if there is anything you\'d like to see on it in the future. Now that it\'s created, it\'s going to be updated regularly depending on what YOU need!\n</p>\n<p>\n    <b>FAQ Section</b>\n</p>\n<p>\n    This section is going to eventually turn into a comprehensive knowledge base which tips, tricks, and many different questions and answers that we know you\'ll love. For now, we\'ve created a handy FAQ section, and would be happy to include any questions you think belong here.\n</p>\n<p>\n    <b>News</b>\n</p>\n<p>\n    This is where we\'ll include any updates we need to give you on how the site is doing, including new features, new milestones, and new ways to attract visitors and agents!\n</p>\n<p>\n    <b>Leads</b>\n</p>\n<p>\n    We know you\'ll LOVE this section. Now you can track all of your leads in one place without having to search for an email. Eventually, we\'d like to expand this into a texting service but for now, we\'re very excited to finally have leads all in one place.\n</p>\n<p>\n    <b>Zip Codes</b>\n</p>\n<p>\n    We found that a lot of agents were not sure which zips they had purchased, especially in highly populated areas with large areas covered by many zip codes. Fear no more - now you can easily view these from the agent dashboard and add to your current ones at any time.\n</p>\n<p>\n    <b>Badges and Original Artwork</b>\n</p>\n<p>\n    These two sections are fill of images you can use on your own website, on banners, on Facebook - anywhere you\'d like. As a bonus, when you use a badge from our site, anyone who clicks on it is tagged with YOUR agent share alias - they\'ll see you as they browse the site.\n</p>\n<p>\n    <b>Stats on Clicks</b>\n</p>\n<p>\n    Now you can see how many people have clicked on homes and pages in your zip, and how many people are tagged by your agent share alias.\n</p>\n<p>\n    <b>Google My Business</b>\n</p>\n<p>\n    Link your GMB to our site and see how your GMB listing is doing! We are hoping to eventually expand this to stats as well, straight from the search giant itself.\n</p>\n<p>\n    We hope you love the new Agent Dashboard, and we welcome your feedback!\n</p>\n<p>\n    - Katie\n</p>',NULL,NULL,NULL,NULL,NULL,'2019-08-14 03:20:14','2019-09-05 13:07:32',0,1),(16,4833,'<h1>New Feature! - Schedule a Showing Leads</h1>','New_Feature_Schedule_a_Showing_Leads','<p>\n    Hey, Agents. We have a new feature to show off - the ability to schedule showings from listings!\n</p>\n<p>\n    If people are interested in seeing a house in your zip and want to schedule a showing, they just have to click this button:\n</p>\n<img alt=\"\" height=\"152\" src=\"https://static1.housesforsale.com/content_images/e28562bee3c14c5007a12ee0c8af1077.png\" width=\"720\">\n<p>\n    And then they\'ll get a handy calendar popup so they can schedule a time with you:\n</p>\n<img alt=\"\" height=\"379\" src=\"https://static1.housesforsale.com/content_images/5614524d1904c8d1e0ee61590effd9f7.png\" width=\"720\">\n<p>\n    All of these leads will show up on your dashboard in addition to being emailed to you directly&nbsp;(or your CRM, if you have that hooked up to our platform).\n</p>\n<p>\n    What do you think? Let us know!\n</p>',NULL,NULL,NULL,NULL,NULL,'2019-08-19 20:52:09','2019-08-19 20:56:34',0,1),(17,4833,'<h1>We\'re Feeling a Lil\' Blue...In a Good Way</h1>','We_re_Feeling_a_Lil_Blue_In_a_Good_Way','<p>\n    Hey agents!\n</p>\n<p>\n    You might be noticing a new color in our parts - <b>blue.</b>\n</p>\n<p>\n    We decided that the orange and the black just weren\'t enough and decided to integrate a complementary blue to spice things up a little!\n</p>\n<p>\n    You\'ll see this color on the agent dashboard first, as it was built with the blue in mind - it\'s also present in a number of our badges and new artwork assets.\n</p>\n<p>\n    But you\'ll start seeing it pop up more soon!\n</p>\n<img alt=\"\" height=\"61\" src=\"https://static1.housesforsale.com/content_images/e72bf67083a0bb92b6201359cf90eec9.png\" width=\"168\">',NULL,NULL,NULL,NULL,NULL,'2019-08-19 20:58:39','2019-08-19 21:00:42',0,1),(18,4833,'<h1>New Feature! - Improved Search</h1>','New_Feature_Improved_Search','<p>\n    WHOAH!\n</p>\n<p>\n    The day has finally come: our improved search is up and running, and we think you\'ll like it. Most importantly, we think your potential clients will like it.\n</p>\n<p>\n    There will be more improvements later - such as more data on locations, geolocation, home appraisal information, and more - but the search was the first step.\n</p>\n<p>\n    Check out the video below!\n</p>\n<iframe frameborder=\"0\" height=\"300\" src=\"https://www.loom.com/share/866096cf9b3f4574ba0202c03ab68320\" width=\"400\"></iframe>',NULL,NULL,NULL,NULL,NULL,'2019-08-19 21:06:50','2019-08-19 21:08:08',0,1),(19,4833,'<h1>Dashboard Feature Overview - Google My Business</h1>','Dashboard_Feature_Overview_Google_My_Business','',NULL,NULL,NULL,NULL,NULL,'2019-09-06 19:42:57','2019-09-06 19:42:57',0,0);

UNLOCK TABLES;

--
-- Table structure for table `artworks`
--

DROP TABLE IF EXISTS `artworks`;

CREATE TABLE `artworks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `artWorkName` varchar(50) DEFAULT NULL,
  `artWorkType` int(11) DEFAULT NULL,
  `artWorkUrl` varchar(128) NOT NULL,
  `artWorkVectorUrl` varchar(128) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `createdBy` int(11) NOT NULL,
  `updatedBy` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `artwork _typ_to_art_work` (`artWorkType`),
  CONSTRAINT `artwork _typ_to_art_work` FOREIGN KEY (`artWorkType`) REFERENCES `artwork_type` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;


--
-- Dumping data for table `artworks`
--

LOCK TABLES `artworks` WRITE;

INSERT INTO `artworks` VALUES (1,'logo 1',1,'e989949b8e506ed9cb19a29f84a28bb6.jpg',NULL,'2019-09-06 09:59:56','2019-09-06 09:59:56',4702,4702,1),(2,'logo 2',1,'c8791b199bf2acb4df0e0db652b5966e.jpg',NULL,'2019-09-06 10:04:35','2019-09-06 10:09:35',4702,4702,1),(3,'logo 3',1,'e7ecf3170ba0102a41b9a0736cf1e6b4.png',NULL,'2019-09-06 10:04:59','2019-09-06 10:10:13',4702,4702,1),(4,'logo 3',1,'35e07b50cb67d52e26b72a742b45f538.jpg',NULL,'2019-09-06 10:11:59','2019-09-06 10:11:59',4702,4702,1),(5,'house logo 1',2,'feb4b602d1631541651bdb857b6c70b8.jpg',NULL,'2019-09-06 10:14:35','2019-09-06 10:14:36',4702,4702,1),(6,'house logo 2',2,'666504b9b05a139b88c5bc7e9e8c926a.jpg',NULL,'2019-09-06 10:14:59','2019-09-06 10:14:59',4702,4702,1),(7,'house logo 3',2,'f5f6dd75a5b84a168d3786a7c9b1b26a.jpg',NULL,'2019-09-06 10:15:19','2019-09-06 10:15:19',4702,4702,1),(8,'house logo 4',2,'297352a40fdd7056d2543dd97dc30fdd.jpg',NULL,'2019-09-06 10:15:33','2019-09-06 10:15:33',4702,4702,1),(9,'house with word logo 1 (Edit)',3,'7d03eb915e57da9bbfd08a02049bb845.jpg','1ec256a6c3dce203b304a90777eb449f.ai','2019-09-06 10:16:43','2019-09-23 13:03:57',4702,4702,1),(10,'house with word logo 2',3,'93977ab14b7be725126c1fb156647a92.jpg','e8f09e505ad6bc666581199cce082129.ai','2019-09-06 10:16:54','2019-09-18 09:25:31',4702,4702,1),(11,'house with word logo 3',3,'440de5a54c7f5e45010bd38bf867a079.jpg',NULL,'2019-09-06 10:17:09','2019-09-06 10:17:09',4702,4702,1),(12,'house with word logo 4',3,'7eb08c34a2c8307ab4f79248fcf8da80.png',NULL,'2019-09-06 10:17:21','2019-09-06 10:17:22',4702,4702,1),(13,'house with word logo 5',3,'df6bde6f5da441b0623b62c5a9d34103.jpg','50e8499d6ca0b169fdff67b3a562d09f.svg','2019-09-06 10:17:39','2019-09-17 12:58:56',4702,4702,1),(14,'Impiger Test',1,'3ffae37bd938b6961382804bd70b7aa4.png','715952087d8d357d950c0f4307101320.ai','2019-09-18 12:46:27','2019-09-23 12:57:41',4702,4702,0),(15,'Impiger New Type Images',5,'eaf1c122e872aa13501316e720e0f58d.png','dc3912dd708eed2104a0380c2c7a67cc.ai','2019-09-18 12:50:19','2019-09-23 12:57:38',4702,4702,0),(16,'Test Artwork',5,'cd52081a9cc87c17bf508e255b32780d.png',NULL,'2019-09-24 13:09:48','2019-09-24 13:09:48',4702,4702,1);

UNLOCK TABLES;

--
-- Table structure for table `artwork_type`
--

DROP TABLE IF EXISTS `artwork_type`;

CREATE TABLE `artwork_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `typeName` varchar(128) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;


--
-- Dumping data for table `artwork_type`
--

LOCK TABLES `artwork_type` WRITE;
INSERT INTO `artwork_type` VALUES (1,'Elongated Logo','2019-09-16 09:32:25','2019-09-16 09:32:33',1),(2,'House Logo','2019-09-16 09:32:25','2019-09-16 09:32:37',1),(3,'House with Words Logo','2019-09-16 09:32:53','2019-09-16 09:32:53',1),(5,'Impiger Type','2019-09-18 12:50:19','2019-09-18 12:50:19',1);
UNLOCK TABLES;

CREATE TABLE `agent_gmb_details` (
  `id` int(11) NOT NULL,
  `agentId` int(11) NOT NULL,
  `businessName` varchar(258) NOT NULL,
  `accountName` varchar(128) NOT NULL,
  `businessLocationName` varchar(256) NOT NULL,
  `locationName` varchar(128) NOT NULL,
  `authToken` varchar(512) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;