
--
-- Table structure for table `wp_term_relationships`
--

CREATE TABLE `wp_term_relationships` (
  `object_id` bigint unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint unsigned NOT NULL DEFAULT '0',
  `term_order` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_term_relationships`
--

INSERT INTO `wp_term_relationships` VALUES (25,3,0),(26,3,0),(27,3,0),(288,4,0),(291,4,0),(292,4,0),(293,4,0),(294,4,0),(295,4,0),(296,2,0),(297,2,0),(298,2,0),(587,5,0),(702,6,0),(703,3,0),(704,3,0),(705,3,0),(706,3,0),(707,3,0),(708,3,0),(709,3,0);

--
-- Table structure for table `wp_term_taxonomy`
--

CREATE TABLE `wp_term_taxonomy` (
  `term_taxonomy_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `parent` bigint unsigned NOT NULL DEFAULT '0',
  `count` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_term_taxonomy`
--

INSERT INTO `wp_term_taxonomy` VALUES (1,1,'category','',0,0),(2,2,'nav_menu','',0,3),(3,3,'nav_menu','',0,10),(4,4,'nav_menu','',0,6),(5,5,'wp_theme','',0,1),(6,6,'elementor_library_type','',0,1);

--
-- Table structure for table `wp_termmeta`
--

CREATE TABLE `wp_termmeta` (
  `meta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_termmeta`
--

INSERT INTO `wp_termmeta` VALUES (1,2,'_astra_sites_imported_term','1'),(2,3,'_astra_sites_imported_term','1'),(3,4,'_astra_sites_imported_term','1');

--
-- Table structure for table `wp_terms`
--

CREATE TABLE `wp_terms` (
  `term_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `term_group` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_terms`
--

INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'Follow Us','follow-us',0),(3,'Menu','menu',0),(4,'Our Services','our-services',0),(5,'astra','astra',0),(6,'footer','footer',0);

--
-- Table structure for table `wp_trustindex_google_reviews`
--

CREATE TABLE `wp_trustindex_google_reviews` (
  `id` tinyint(1) NOT NULL AUTO_INCREMENT,
  `hidden` tinyint(1) NOT NULL DEFAULT '0',
  `user` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `user_photo` text,
  `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `rating` decimal(3,1) DEFAULT NULL,
  `highlight` varchar(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `reviewId` text,
  `reply` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `wp_trustindex_google_reviews`
--

INSERT INTO `wp_trustindex_google_reviews` VALUES (1,0,'karenj','https://lh3.googleusercontent.com/a/ACg8ocI4CYXfzRillrvieM1vJnkxzAsLv-lpZu6YQtWMttce=s120-c-rp-mo-br100','I can’t recommend Noel as he never provided us with a certificate for our woodworm treatment, even though when we requested the job we told him we’d need it and he confirmed that he would.  He also told us we had damp in various places with his meter reader that never had a problem with and several years later they’re still fine.  Unfortunately we had to pay another company to redo the woodworm treatment as we needed the certificate for insurance purposes.  We chased Noel for about a year but he never responded to any emails or phone calls.',1.0,NULL,'2023-10-26','ChZDSUhNMG9nS0VJQ0FnSUQ1eWIyTkd3EAE',''),(2,0,'Luke Mcgibbon','https://lh3.googleusercontent.com/a-/ALV-UjV3gae2CAj9RuTgwEKedd7IoAex9glqsa5Km9GLH0bGO94=s120-c-rp-mo-br100','Noel was fantastic. Quick, thorough, accurate, friendly and reasonably priced.',5.0,NULL,'2023-10-06','ChZDSUhNMG9nS0VJQ0FnSURaamM3b0VREAE',''),(3,0,'Glen Stewart','https://lh3.googleusercontent.com/a/ACg8ocI6ytVrIiJCtPRp_Pwp8ZtT3B3EHEIVo2fhZ1QaRLr5=s120-c-rp-mo-br100','I called as was worried about some water marks appearing in the house underneath the shower, Noel was out later than afternoon and diagnosed the issue - very helpful and professional, would certainly recommend.',5.0,NULL,'2023-09-05','ChdDSUhNMG9nS0VJQ0FnSUNadExUa2hBRRAB',''),(4,0,'Adam Armstrong','https://lh3.googleusercontent.com/a/ACg8ocIfFfNH537HGP4hSOC6eLvh5Ntd4ORnVheJ9CQwUO3r=s120-c-rp-mo-br100','Contacted Noel for some advice on a damp issue with a house. Called out the same day and offered some professional advice and help. A fantastic example of how to give great customer service and support. Would happily recommend and use again.',5.0,NULL,'2023-07-24','ChdDSUhNMG9nS0VJQ0FnSURKMTlicHFnRRAB',''),(5,0,'Kerry Kenny','https://lh3.googleusercontent.com/a/ACg8ocKKVZWRGZ-8NO7Nxn4mMHJbhFlytWIp58aMUDJ3eWXR=s120-c-rp-mo-br100','Noel called out at really short notice to assess what I suspected was rising damp around my front door. After inspection Noel was able to tell me that it wasn\'t rising damp but another issue, and advised how I could get it fixed. He was thorough, professional and honest, would defo recommend',5.0,NULL,'2023-07-11','ChZDSUhNMG9nS0VJQ0FnSURKNVBfUFdREAE',''),(6,0,'Allan Sloan','https://lh3.googleusercontent.com/a/ACg8ocKsN5ZpnO6mQBXjc-xzdz5kYaPbD0BtqJwZdr4-Tu0j=s120-c-rp-mo-br100','Spoke to noel earlier today about damp concerns and was with me around 30 mins later. First genuine advice on the issue and actual causes rather than defaulting to damp course and didn\'t charge at all for the call out and advice. Will be taking him up on what was advised m and reviewing again after work. Highly recommended. Thanks Noel',5.0,NULL,'2023-07-05','ChdDSUhNMG9nS0VJQ0FnSUNKMjl5UXlBRRAB',''),(7,0,'Sean Finton','https://lh3.googleusercontent.com/a/ACg8ocIaYqz_QBkkbMJHE3XjsBAA09qAEFuO3C1gRsFJk1eH=s120-c-rp-mo-br100','DampdoctorNi AKA Noel thank you for your resolving what was a very stressful time for me and my wife when buying a new home.  Noel was professional and very knowledgeable about damp and was able to fix the problem swiftly and not charging the earth!  Cheers again!  Thanks to you we can enjoy our new home!',5.0,NULL,'2023-07-04','ChdDSUhNMG9nS0VJQ0FnSUNKaTlpSHhBRRAB',''),(8,0,'Neileo Mag','https://lh3.googleusercontent.com/a-/ALV-UjV2dsfksrbymPXBdafZXHlRaIZJCYOpwtBie2BTxQarB0l6=s120-c-rp-mo-ba3-br100','I contacted Noel spoke to him about my issue told me he would be around my direction in 2 weeks , 2weeks past no contact I tried several times through phone and text to contact him again but nothing',1.0,NULL,'2022-07-05','ChZDSUhNMG9nS0VJQ0FnSURPenNTbVRBEAE','');

--
-- Table structure for table `wp_usermeta`
--

CREATE TABLE `wp_usermeta` (
  `umeta_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_usermeta`
--

INSERT INTO `wp_usermeta` VALUES (1,1,'nickname','kobault'),(2,1,'first_name',''),(3,1,'last_name',''),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'syntax_highlighting','true'),(7,1,'comment_shortcuts','false'),(8,1,'admin_color','fresh'),(9,1,'use_ssl','0'),(10,1,'show_admin_bar_front','true'),(11,1,'locale',''),(12,1,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(13,1,'wp_user_level','10'),(14,1,'dismissed_wp_pointers',''),(15,1,'show_welcome_panel','0'),(16,1,'session_tokens','a:2:{s:64:\"e55b1e6a9c63f52baaf3ea1e33ae66fa17e8a4b3b5e94f9aa30f47b9f341cac4\";a:4:{s:10:\"expiration\";i:1712567307;s:2:\"ip\";s:12:\"192.168.1.20\";s:2:\"ua\";s:117:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36\";s:5:\"login\";i:1711357707;}s:64:\"e704884b31d21e1d47f7d5ac9b3bee1e17b05dab412deaf22e6f7c636c2cce89\";a:4:{s:10:\"expiration\";i:1711536475;s:2:\"ip\";s:12:\"192.168.1.20\";s:2:\"ua\";s:111:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36\";s:5:\"login\";i:1711363675;}}'),(17,1,'wp_dashboard_quick_press_last_post_id','2'),(19,1,'community-events-location','a:1:{s:2:\"ip\";s:12:\"81.107.101.0\";}'),(20,1,'hide_secure_subs','1'),(21,1,'wp_user-settings','libraryContent=browse&editor=tinymce'),(22,1,'wp_user-settings-time','1711371647'),(23,1,'elementor_introduction','a:3:{s:27:\"ai-get-started-announcement\";b:1;s:18:\"yoast-introduction\";b:1;s:20:\"globals_introduction\";b:1;}'),(26,1,'wp_yoast_notifications','a:1:{i:0;a:2:{s:7:\"message\";s:307:\"<p>Because of a change in your permalink structure, some of your SEO data needs to be reprocessed.</p><p>We estimate this will take less than a minute.</p><a class=\"button\" href=\"https://dev.sitesmart.io/dampdoctorni/wp-admin/admin.php?page=wpseo_tools&start-indexation=true\">Start SEO data optimization</a>\";s:7:\"options\";a:10:{s:4:\"type\";s:7:\"warning\";s:2:\"id\";s:13:\"wpseo-reindex\";s:7:\"user_id\";i:1;s:5:\"nonce\";N;s:8:\"priority\";d:0.8;s:9:\"data_json\";a:0:{}s:13:\"dismissal_key\";N;s:12:\"capabilities\";s:20:\"wpseo_manage_options\";s:16:\"capability_check\";s:3:\"all\";s:14:\"yoast_branding\";b:0;}}}'),(27,1,'nav_menu_recently_edited','3'),(28,1,'managenav-menuscolumnshidden','a:5:{i:0;s:11:\"link-target\";i:1;s:11:\"css-classes\";i:2;s:3:\"xfn\";i:3;s:11:\"description\";i:4;s:15:\"title-attribute\";}'),(29,1,'metaboxhidden_nav-menus','a:3:{i:0;s:28:\"add-post-type-e-landing-page\";i:1;s:12:\"add-post_tag\";i:2;s:15:\"add-post_format\";}');

--
-- Table structure for table `wp_users`
--

CREATE TABLE `wp_users` (
  `ID` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_login` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_pass` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_nicename` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_url` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `user_status` int NOT NULL DEFAULT '0',
  `display_name` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  KEY `user_login_key` (`user_login`),
  KEY `user_nicename` (`user_nicename`),
  KEY `user_email` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_users`
--

INSERT INTO `wp_users` VALUES (1,'kobault','$P$BJUeFTsNOYnjVaqdVtZo8NW4GSIBWp.','kobault','hello@kobault.com','https://dev.sitesmart.io/dampdoctorni','2024-03-25 09:07:35','',0,'kobault');

--
-- Table structure for table `wp_wpforms_logs`
--

CREATE TABLE `wp_wpforms_logs` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `types` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `create_at` datetime NOT NULL,
  `form_id` bigint DEFAULT NULL,
  `entry_id` bigint DEFAULT NULL,
  `user_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wpforms_logs`
--


--
-- Table structure for table `wp_wpforms_payment_meta`
--

CREATE TABLE `wp_wpforms_payment_meta` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `payment_id` bigint NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`id`),
  KEY `payment_id` (`payment_id`),
  KEY `meta_key` (`meta_key`(191)),
  KEY `meta_value` (`meta_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wpforms_payment_meta`
--


--
-- Table structure for table `wp_wpforms_payments`
--

CREATE TABLE `wp_wpforms_payments` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `form_id` bigint NOT NULL,
  `status` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `subtotal_amount` decimal(26,8) NOT NULL DEFAULT '0.00000000',
  `discount_amount` decimal(26,8) NOT NULL DEFAULT '0.00000000',
  `total_amount` decimal(26,8) NOT NULL DEFAULT '0.00000000',
  `currency` varchar(3) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `entry_id` bigint NOT NULL DEFAULT '0',
  `gateway` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `type` varchar(12) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `mode` varchar(4) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `transaction_id` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `customer_id` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `subscription_id` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `subscription_status` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `title` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `date_created_gmt` datetime NOT NULL,
  `date_updated_gmt` datetime NOT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `form_id` (`form_id`),
  KEY `status` (`status`(8)),
  KEY `total_amount` (`total_amount`),
  KEY `type` (`type`(8)),
  KEY `transaction_id` (`transaction_id`(32)),
  KEY `customer_id` (`customer_id`(32)),
  KEY `subscription_id` (`subscription_id`(32)),
  KEY `subscription_status` (`subscription_status`(8)),
  KEY `title` (`title`(64))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wpforms_payments`
--


--
-- Table structure for table `wp_wpforms_tasks_meta`
--

CREATE TABLE `wp_wpforms_tasks_meta` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `action` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `data` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wpforms_tasks_meta`
--


--
-- Table structure for table `wp_yoast_indexable`
--

CREATE TABLE `wp_yoast_indexable` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `permalink` longtext COLLATE utf8mb4_unicode_520_ci,
  `permalink_hash` varchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `object_id` bigint DEFAULT NULL,
  `object_type` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `object_sub_type` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `author_id` bigint DEFAULT NULL,
  `post_parent` bigint DEFAULT NULL,
  `title` text COLLATE utf8mb4_unicode_520_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_520_ci,
  `breadcrumb_title` text COLLATE utf8mb4_unicode_520_ci,
  `post_status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `is_public` tinyint(1) DEFAULT NULL,
  `is_protected` tinyint(1) DEFAULT '0',
  `has_public_posts` tinyint(1) DEFAULT NULL,
  `number_of_pages` int unsigned DEFAULT NULL,
  `canonical` longtext COLLATE utf8mb4_unicode_520_ci,
  `primary_focus_keyword` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `primary_focus_keyword_score` int DEFAULT NULL,
  `readability_score` int DEFAULT NULL,
  `is_cornerstone` tinyint(1) DEFAULT '0',
  `is_robots_noindex` tinyint(1) DEFAULT '0',
  `is_robots_nofollow` tinyint(1) DEFAULT '0',
  `is_robots_noarchive` tinyint(1) DEFAULT '0',
  `is_robots_noimageindex` tinyint(1) DEFAULT '0',
  `is_robots_nosnippet` tinyint(1) DEFAULT '0',
  `twitter_title` text COLLATE utf8mb4_unicode_520_ci,
  `twitter_image` longtext COLLATE utf8mb4_unicode_520_ci,
  `twitter_description` longtext COLLATE utf8mb4_unicode_520_ci,
  `twitter_image_id` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `twitter_image_source` text COLLATE utf8mb4_unicode_520_ci,
  `open_graph_title` text COLLATE utf8mb4_unicode_520_ci,
  `open_graph_description` longtext COLLATE utf8mb4_unicode_520_ci,
  `open_graph_image` longtext COLLATE utf8mb4_unicode_520_ci,
  `open_graph_image_id` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `open_graph_image_source` text COLLATE utf8mb4_unicode_520_ci,
  `open_graph_image_meta` mediumtext COLLATE utf8mb4_unicode_520_ci,
  `link_count` int DEFAULT NULL,
  `incoming_link_count` int DEFAULT NULL,
  `prominent_words_version` int unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `blog_id` bigint NOT NULL DEFAULT '1',
  `language` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `region` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `schema_page_type` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `schema_article_type` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `has_ancestors` tinyint(1) DEFAULT '0',
  `estimated_reading_time_minutes` int DEFAULT NULL,
  `version` int DEFAULT '1',
  `object_last_modified` datetime DEFAULT NULL,
  `object_published_at` datetime DEFAULT NULL,
  `inclusive_language_score` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `object_type_and_sub_type` (`object_type`,`object_sub_type`),
  KEY `object_id_and_type` (`object_id`,`object_type`),
  KEY `permalink_hash_and_object_type` (`permalink_hash`,`object_type`),
  KEY `subpages` (`post_parent`,`object_type`,`post_status`,`object_id`),
  KEY `prominent_words` (`prominent_words_version`,`object_type`,`object_sub_type`,`post_status`),
  KEY `published_sitemap_index` (`object_published_at`,`is_robots_noindex`,`object_type`,`object_sub_type`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_yoast_indexable`
--

INSERT INTO `wp_yoast_indexable` VALUES (1,'https://dev.sitesmart.io/dampdoctorni/','38:697a028fb15805b54308e09ae62034c8',289,'post','page',1,0,NULL,NULL,'Home','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,90,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,'2024-03-25 09:10:10','2024-03-25 15:05:40',1,NULL,NULL,NULL,NULL,0,3,2,'2024-03-25 15:05:40','2020-07-20 08:26:11',0),(2,'https://dev.sitesmart.io/dampdoctorni/damp-proofing/','52:a07cd1d5ca895a1ac0a05e8017efbcf8',290,'post','page',1,0,NULL,NULL,'Damp Proofing','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,90,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2024-03-25 09:10:11','2024-03-25 15:07:05',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-25 15:07:05','2020-07-20 08:46:21',0),(3,'https://dev.sitesmart.io/dampdoctorni/contact/','46:cd9009db03d058ef2ccc5b573f18bea6',13,'post','page',1,0,NULL,NULL,'Contact','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,90,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,NULL,'2024-03-25 09:10:11','2024-03-25 15:49:38',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-25 15:49:38','2020-07-20 08:47:06',0),(6,'https://dev.sitesmart.io/dampdoctorni/','38:697a028fb15805b54308e09ae62034c8',NULL,'home-page',NULL,NULL,NULL,'%%sitename%% %%page%% %%sep%% %%sitedesc%%','','Home',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,'%%sitename%%','','','0',NULL,NULL,NULL,NULL,NULL,'2024-03-25 09:11:36','2024-05-03 03:50:27',1,NULL,NULL,NULL,NULL,0,NULL,2,'2024-03-25 15:49:38',NULL,NULL),(7,NULL,NULL,NULL,'system-page','404',NULL,NULL,'Page not found %%sep%% %%sitename%%',NULL,'Error 404: Page not found',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-03-25 13:14:55','2024-03-25 13:14:55',1,NULL,NULL,NULL,NULL,0,NULL,1,NULL,NULL,NULL),(8,'https://dev.sitesmart.io/dampdoctorni/damp-surveys/','51:61881b4c96864a1832607aab0011da19',591,'post','page',1,0,NULL,NULL,'Damp Surveys','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,90,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2024-03-25 13:17:54','2024-03-25 14:54:37',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-25 14:54:37','2024-03-25 13:19:01',0),(9,'https://dev.sitesmart.io/dampdoctorni/category/uncategorized/','61:27e7d7a1592875b153be220da368a25c',1,'term','category',NULL,NULL,NULL,NULL,'Uncategorized',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2024-03-25 13:19:00','2024-04-04 07:08:23',1,NULL,NULL,NULL,NULL,0,NULL,2,NULL,NULL,NULL),(10,'https://dev.sitesmart.io/dampdoctorni/dehumidifier-hire/','56:7d7f928dd3bb54a714836ba9f0feb50c',622,'post','page',1,0,NULL,NULL,'Dehumidifier Hire','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,90,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2024-03-25 13:34:22','2024-03-25 15:18:12',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-25 15:18:12','2024-03-25 13:34:43',0),(11,'https://dev.sitesmart.io/dampdoctorni/wet-and-dry-rot/','54:96cac251a22e3758cc83d8610aaa41e3',637,'post','page',1,0,NULL,NULL,'Wet and Dry Rot','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,60,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2024-03-25 13:56:03','2024-03-25 14:05:09',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-25 14:05:09','2024-03-25 13:56:24',0),(12,'https://dev.sitesmart.io/dampdoctorni/plastering-and-building/','62:506b3ce3881099c74747ea2a5a42ba4e',664,'post','page',1,0,NULL,NULL,'Plastering and Building','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,60,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2024-03-25 14:27:45','2024-03-25 15:15:35',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-25 15:15:34','2024-03-25 14:28:26',0),(13,'https://dev.sitesmart.io/dampdoctorni/flood-water-damage/','57:e86dd699127c69139b9903bfefbe1302',670,'post','page',1,0,NULL,NULL,'Flood &#038; Water Damage','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,60,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2024-03-25 14:33:29','2024-03-25 14:44:20',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-25 14:44:19','2024-03-25 14:35:54',0),(14,'https://dev.sitesmart.io/dampdoctorni/woodworm-treatments/','58:8b68bcb7fa14c26c4f04881b0a2c1162',676,'post','page',1,0,NULL,NULL,'Woodworm Treatments','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,90,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'2024-03-25 14:44:56','2024-03-25 14:51:44',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-25 14:51:43','2024-03-25 14:45:45',0),(15,NULL,NULL,NULL,'system-page','search-result',NULL,NULL,'You searched for %%searchphrase%% %%page%% %%sep%% %%sitename%%',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-03-31 09:05:20','2024-03-31 09:05:20',1,NULL,NULL,NULL,NULL,0,NULL,1,NULL,NULL,NULL),(16,NULL,NULL,NULL,'date-archive',NULL,NULL,NULL,'%%date%% %%page%% %%sep%% %%sitename%%','',NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2024-04-04 07:08:23','2024-04-04 07:08:23',1,NULL,NULL,NULL,NULL,0,NULL,1,NULL,NULL,NULL);

--
-- Table structure for table `wp_yoast_indexable_hierarchy`
--

CREATE TABLE `wp_yoast_indexable_hierarchy` (
  `indexable_id` int unsigned NOT NULL,
  `ancestor_id` int unsigned NOT NULL,
  `depth` int unsigned DEFAULT NULL,
  `blog_id` bigint NOT NULL DEFAULT '1',
  PRIMARY KEY (`indexable_id`,`ancestor_id`),
  KEY `indexable_id` (`indexable_id`),
  KEY `ancestor_id` (`ancestor_id`),
  KEY `depth` (`depth`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_yoast_indexable_hierarchy`
--

INSERT INTO `wp_yoast_indexable_hierarchy` VALUES (1,0,0,1),(2,0,0,1),(3,0,0,1),(6,0,0,1),(8,0,0,1),(9,0,0,1),(10,0,0,1),(11,0,0,1),(12,0,0,1),(13,0,0,1),(14,0,0,1),(15,0,0,1);

--
-- Table structure for table `wp_yoast_migrations`
--

CREATE TABLE `wp_yoast_migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `version` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `wp_yoast_migrations_version` (`version`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_yoast_migrations`
--

INSERT INTO `wp_yoast_migrations` VALUES (1,'20171228151840'),(2,'20171228151841'),(3,'20190529075038'),(4,'20191011111109'),(5,'20200408101900'),(6,'20200420073606'),(7,'20200428123747'),(8,'20200428194858'),(9,'20200429105310'),(10,'20200430075614'),(11,'20200430150130'),(12,'20200507054848'),(13,'20200513133401'),(14,'20200609154515'),(15,'20200616130143'),(16,'20200617122511'),(17,'20200702141921'),(18,'20200728095334'),(19,'20201202144329'),(20,'20201216124002'),(21,'20201216141134'),(22,'20210817092415'),(23,'20211020091404'),(24,'20230417083836');

--
-- Table structure for table `wp_yoast_primary_term`
--

CREATE TABLE `wp_yoast_primary_term` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint DEFAULT NULL,
  `term_id` bigint DEFAULT NULL,
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `blog_id` bigint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `post_taxonomy` (`post_id`,`taxonomy`),
  KEY `post_term` (`post_id`,`term_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_yoast_primary_term`
--


--
-- Table structure for table `wp_yoast_seo_links`
--

CREATE TABLE `wp_yoast_seo_links` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `post_id` bigint unsigned DEFAULT NULL,
  `target_post_id` bigint unsigned DEFAULT NULL,
  `type` varchar(8) DEFAULT NULL,
  `indexable_id` int unsigned DEFAULT NULL,
  `target_indexable_id` int unsigned DEFAULT NULL,
  `height` int unsigned DEFAULT NULL,
  `width` int unsigned DEFAULT NULL,
  `size` int unsigned DEFAULT NULL,
  `language` varchar(32) DEFAULT NULL,
  `region` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `link_direction` (`post_id`,`type`),
  KEY `indexable_link_direction` (`indexable_id`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `wp_yoast_seo_links`
--

INSERT INTO `wp_yoast_seo_links` VALUES (24,'https://lh3.googleusercontent.com/a-/ALV-UjV3gae2CAj9RuTgwEKedd7IoAex9glqsa5Km9GLH0bGO94=s120-c-rp-mo-br100',289,NULL,'image-ex',1,NULL,NULL,NULL,NULL,NULL,NULL),(25,'https://lh3.googleusercontent.com/a/ACg8ocI6ytVrIiJCtPRp_Pwp8ZtT3B3EHEIVo2fhZ1QaRLr5=s120-c-rp-mo-br100',289,NULL,'image-ex',1,NULL,NULL,NULL,NULL,NULL,NULL),(26,'https://lh3.googleusercontent.com/a/ACg8ocIfFfNH537HGP4hSOC6eLvh5Ntd4ORnVheJ9CQwUO3r=s120-c-rp-mo-br100',289,NULL,'image-ex',1,NULL,NULL,NULL,NULL,NULL,NULL),(27,'https://lh3.googleusercontent.com/a/ACg8ocKKVZWRGZ-8NO7Nxn4mMHJbhFlytWIp58aMUDJ3eWXR=s120-c-rp-mo-br100',289,NULL,'image-ex',1,NULL,NULL,NULL,NULL,NULL,NULL),(28,'https://lh3.googleusercontent.com/a/ACg8ocKsN5ZpnO6mQBXjc-xzdz5kYaPbD0BtqJwZdr4-Tu0j=s120-c-rp-mo-br100',289,NULL,'image-ex',1,NULL,NULL,NULL,NULL,NULL,NULL),(29,'https://lh3.googleusercontent.com/a/ACg8ocIaYqz_QBkkbMJHE3XjsBAA09qAEFuO3C1gRsFJk1eH=s120-c-rp-mo-br100',289,NULL,'image-ex',1,NULL,NULL,NULL,NULL,NULL,NULL),(32,'tel:07856161614',591,NULL,'external',8,NULL,NULL,NULL,NULL,NULL,NULL),(33,'tel:07856161614',290,NULL,'external',2,NULL,NULL,NULL,NULL,NULL,NULL),(34,'tel:07856161614',622,NULL,'external',10,NULL,NULL,NULL,NULL,NULL,NULL),(35,'tel:07856161614',637,NULL,'external',11,NULL,NULL,NULL,NULL,NULL,NULL),(36,'tel:07856161614',664,NULL,'external',12,NULL,NULL,NULL,NULL,NULL,NULL),(37,'tel:07856161614',670,NULL,'external',13,NULL,NULL,NULL,NULL,NULL,NULL),(38,'tel:07856161614',676,NULL,'external',14,NULL,NULL,NULL,NULL,NULL,NULL),(39,'https://dev.sitesmart.io/dampdoctorni/contact/',289,13,'internal',1,3,NULL,NULL,NULL,NULL,NULL),(40,'https://dev.sitesmart.io/dampdoctorni/contact/',289,13,'internal',1,3,NULL,NULL,NULL,NULL,NULL);


