
--
-- 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 (4,2,0),(14,3,0),(987,5,0),(988,5,0),(989,5,0),(990,5,0),(1312,5,0),(1313,5,0),(1314,5,0),(1321,3,0),(1325,5,0),(1397,4,0),(1469,4,0),(1486,2,0),(1564,4,0),(1574,4,0),(1575,4,0),(1694,4,0),(1703,4,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=6 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,'elementor_library_type','',0,1),(3,3,'wp_theme','',0,2),(4,4,'nav_menu','',0,7),(5,5,'nav_menu','',0,8);

--
-- 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,3,'_astra_sites_imported_term','1'),(2,4,'_astra_sites_imported_term','1'),(3,5,'_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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'header','header',0),(3,'astra','astra',0),(4,'Primary Menu','primary-menu',0),(5,'Services','services',0);

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

CREATE TABLE `wp_trustindex_google_reviews` (
  `id` tinyint(1) NOT NULL AUTO_INCREMENT,
  `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=4 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `wp_trustindex_google_reviews` VALUES (1,'Nigel Lamont','https://lh3.googleusercontent.com/a/ACg8ocKVcIl6AzC9ubwzFo8Aj7XlGAUC0XI2vFsLF-gHDVo=s120-c-rp-mo-br100','More than   helpfull .\nAlways willing to go that extra bit to help and very friendly to deal with .',5.0,NULL,'2023-10-08','ChZDSUhNMG9nS0VJQ0FnSURadDlyaE53EAE',''),(2,'Adi Kirk','https://lh3.googleusercontent.com/a-/ALV-UjX7EvjtliUIHs9n1oglSyx9V3WJ-jy64MbrMeeWhTmrVV0=s120-c-rp-mo-br100','Good local stocks of essential items. Good replenishment service for business. Friendly to deal with.',5.0,NULL,'2020-07-18','ChdDSUhNMG9nS0VJQ0FnSUQ4OHAtT3F3RRAB',''),(3,'Michael Cunningham','https://lh3.googleusercontent.com/a/ACg8ocIBpcRDMMVaCeEurQj2Cj8Di5tv_b4CNKbKPSF2YIxD=s120-c-rp-mo-ba3-br100','Great team and quality products!',5.0,NULL,'2020-08-23','ChdDSUhNMG9nS0VJQ0FnSUNDN3BUdGdRRRAB','');

--
-- 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=36 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:1:{s:64:\"3ba55446a4721f1af2d9c19736ceaa8db526f8ef69ca0d6fb1beb2608851219a\";a:4:{s:10:\"expiration\";i:1712672290;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:1711462690;}}'),(17,1,'wp_dashboard_quick_press_last_post_id','1679'),(19,1,'community-events-location','a:1:{s:2:\"ip\";s:11:\"192.168.1.0\";}'),(20,1,'hide_secure_subs','1'),(21,1,'astra-sites-welcome-notice','notice-dismissed'),(22,1,'elementor_introduction','a:6:{s:27:\"ai-get-started-announcement\";b:1;s:14:\"ai_get_started\";b:1;s:18:\"yoast-introduction\";b:1;s:20:\"globals_introduction\";b:1;s:7:\"exit_to\";b:1;s:16:\"favorites-notice\";b:1;}'),(23,1,'wp_elementor_connect_common_data','a:7:{s:9:\"client_id\";s:32:\"xLojudeHo1WfstqpDDOfJy0UkVwBlTPP\";s:11:\"auth_secret\";s:32:\"EmiNzLiASgcwXJ2m4ImsxVFwWRt73atL\";s:12:\"access_token\";s:293:\"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOjI4NTI5LCJhdWQiOiJodHRwczovL2Rldi5zaXRlc21hcnQuaW8vbWVzLyIsImNsaWVudF9pZCI6InhMb2p1ZGVIbzFXZnN0cXBERE9mSnkwVWtWd0JsVFBQIiwiY29ubmVjdF90eXBlIjoibGlicmFyeSIsImlhdCI6MTcwNjYwNzgyNiwiZXhwIjozMTcyNTEwNTAyMjZ9.iEyDW8DNuneZgtq0p9sY20nHqb_7NyuhEUa9tBhwo5U\";s:19:\"access_token_secret\";s:32:\"elGZ5YxHcJGjaWzQXRnVomkfwRVdrR4f\";s:10:\"token_type\";s:6:\"bearer\";s:4:\"user\";O:8:\"stdClass\":1:{s:5:\"email\";s:19:\"russell@kobault.com\";}s:19:\"data_share_opted_in\";b:1;}'),(25,1,'uagb-admin-rating','delayed-notice'),(26,1,'wp_persisted_preferences','a:3:{s:14:\"core/edit-post\";a:3:{s:10:\"openPanels\";a:2:{i:0;s:11:\"post-status\";i:1;s:24:\"yoast-seo/document-panel\";}s:26:\"isComplementaryAreaVisible\";b:1;s:12:\"welcomeGuide\";b:0;}s:9:\"_modified\";s:24:\"2024-01-30T10:19:18.892Z\";s:22:\"core/customize-widgets\";a:1:{s:12:\"welcomeGuide\";b:0;}}'),(27,1,'nav_menu_recently_edited','4'),(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\";}'),(30,1,'wp_user-settings','editor=tinymce&libraryContent=browse'),(31,1,'wp_user-settings-time','1706613638'),(32,1,'elementor_dismissed_editor_notices','a:2:{i:0;s:23:\"image-optimization-once\";i:1;s:20:\"image_optimizer_hint\";}'),(34,1,'elementor_admin_notices','a:1:{s:20:\"design_not_appearing\";a:2:{s:9:\"is_viewed\";b:0;s:4:\"meta\";a:1:{s:7:\"version\";s:6:\"3.20.2\";}}}');

--
-- 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$B7WzMFJblm4rMSemqnk0mHmoPYfRsb/','kobault','hello@kobault.com','https://dev.sitesmart.io/mes','2024-01-29 15:21:02','',0,'kobault');

--
-- 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=23 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/mes/category/uncategorized/','52:ef3684b40d9722288919b22b6031c75b',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-01-30 09:39:29','2024-01-30 12:11:52',1,NULL,NULL,NULL,NULL,0,NULL,2,NULL,NULL,NULL),(2,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-01-30 09:39:29','2024-01-30 10:11:35',1,NULL,NULL,NULL,NULL,0,NULL,1,NULL,NULL,NULL),(3,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-01-30 09:39:29','2024-01-31 11:58:45',1,NULL,NULL,NULL,NULL,0,NULL,1,NULL,NULL,NULL),(4,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-01-30 09:39:29','2024-01-31 11:58:45',1,NULL,NULL,NULL,NULL,0,NULL,1,NULL,NULL,NULL),(5,'https://dev.sitesmart.io/mes/','29:cd5fe435b935679d86d5ae8e91e0d40c',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-01-30 09:39:29','2024-05-02 09:53:09',1,NULL,NULL,NULL,NULL,0,NULL,2,'2024-03-26 15:13:58',NULL,NULL),(14,'https://dev.sitesmart.io/mes/','29:cd5fe435b935679d86d5ae8e91e0d40c',1392,'post','page',1,0,NULL,NULL,'Home','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,60,0,NULL,0,NULL,NULL,NULL,NULL,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/vans-outside.jpg',NULL,NULL,'first-content-image',NULL,NULL,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/vans-outside.jpg',NULL,'first-content-image',NULL,5,NULL,NULL,'2024-01-30 12:11:53','2024-03-26 15:13:58',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-26 15:13:58','2024-01-30 12:11:53',0),(16,'https://dev.sitesmart.io/mes/services/','38:cef24e337346b82019604571de4b1636',1437,'post','page',1,0,NULL,NULL,'Services','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,9,0,NULL,'2024-01-30 14:25:02','2024-02-02 11:43:17',1,NULL,NULL,NULL,NULL,0,1,2,'2024-02-02 11:19:47','2024-01-30 14:25:30',0),(17,'https://dev.sitesmart.io/mes/contact-us/','40:fa26e179e5ae4b8b2e1dc37965a23166',1457,'post','page',1,0,NULL,NULL,'Contact Us','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,13,NULL,'2024-01-30 15:29:31','2024-05-02 09:53:09',1,NULL,NULL,NULL,NULL,0,1,2,'2024-02-05 09:30:04','2024-01-30 15:29:56',0),(18,'https://dev.sitesmart.io/mes/fasteners/','39:cf01c5b140afff5cf057071247e1a3c2',1513,'post','page',1,0,NULL,NULL,'Fasteners','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,30,0,NULL,0,NULL,NULL,NULL,NULL,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/pexels-photo-259988-scaled-1-1024x683.jpg',NULL,NULL,'first-content-image',NULL,NULL,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/pexels-photo-259988-scaled-1-1024x683.jpg',NULL,'first-content-image',NULL,1,3,NULL,'2024-02-02 10:17:54','2024-05-02 09:53:09',1,NULL,NULL,NULL,NULL,0,3,2,'2024-03-26 15:00:36','2024-02-02 10:20:56',0),(19,'https://dev.sitesmart.io/mes/tools-and-power-tools/','51:139cb465ee44b7af87106c3644fbc7ac',1525,'post','page',1,0,NULL,'Hand Tools Ballymena, Power Tools Northern Ireland, Quality Tools Supplier Ballymena, Professional Power Tools Northern Ireland, DIY Tools Ballymena.','Tools and Power Tools','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,3,NULL,'2024-02-02 10:31:52','2024-05-02 09:53:09',1,NULL,NULL,NULL,NULL,0,1,2,'2024-02-05 10:12:29','2024-02-02 10:32:17',0),(20,'https://dev.sitesmart.io/mes/consumables-and-ppe/','49:93fe51572ea98f0a6947caabdd93ae86',1537,'post','page',1,0,NULL,NULL,'Consumables and PPE','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,5,NULL,'2024-02-02 10:49:35','2024-05-02 09:53:09',1,NULL,NULL,NULL,NULL,0,2,2,'2024-02-05 10:09:21','2024-02-02 10:49:52',0),(21,'https://dev.sitesmart.io/mes/fluid-power-solutions/','51:3921838f10c1b776c749b0042a09f03d',1684,'post','page',1,0,NULL,'Hand Tools Ballymena, Power Tools Northern Ireland, Quality Tools Supplier Ballymena, Professional Power Tools Northern Ireland, DIY Tools Ballymena.','Fluid Power Solutions','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,1,NULL,NULL,'2024-03-26 14:29:11','2024-03-26 14:37:07',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-26 14:37:07','2024-03-26 14:29:21',0),(22,'https://dev.sitesmart.io/mes/industries-we-serve/','49:661f6cb9edd9762cc3279b2b0d58c946',1695,'post','page',1,0,NULL,NULL,'Industries We Serve','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,90,0,NULL,0,NULL,NULL,NULL,NULL,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/pexels-photo-259988-scaled-1-1024x683.jpg',NULL,NULL,'first-content-image',NULL,NULL,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/pexels-photo-259988-scaled-1-1024x683.jpg',NULL,'first-content-image',NULL,2,NULL,NULL,'2024-03-26 14:38:32','2024-03-26 14:42:09',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-26 14:42:07','2024-03-26 14:38:41',0);

--
-- 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),(3,0,0,1),(5,0,0,1),(14,0,0,1),(16,0,0,1),(17,0,0,1),(18,0,0,1),(19,0,0,1),(20,0,0,1),(21,0,0,1),(22,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=165 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `wp_yoast_seo_links` VALUES (38,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/vans-outside.jpg',1392,1352,'image-in',14,NULL,608,1000,145355,NULL,NULL),(39,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/screws_2.jpg',1392,1358,'image-in',14,NULL,385,542,106902,NULL,NULL),(40,'https://cdn.trustindex.io/assets/platform/Google/logo.svg',1392,NULL,'image-ex',14,NULL,NULL,NULL,NULL,NULL,NULL),(41,'https://lh3.googleusercontent.com/a/ACg8ocKVcIl6AzC9ubwzFo8Aj7XlGAUC0XI2vFsLF-gHDVo=s120-c-rp-mo-br100',1392,NULL,'image-ex',14,NULL,NULL,NULL,NULL,NULL,NULL),(42,'https://lh3.googleusercontent.com/a/ACg8ocIBpcRDMMVaCeEurQj2Cj8Di5tv_b4CNKbKPSF2YIxD=s120-c-rp-mo-ba3-br100',1392,NULL,'image-ex',14,NULL,NULL,NULL,NULL,NULL,NULL),(43,'https://lh3.googleusercontent.com/a-/ALV-UjX7EvjtliUIHs9n1oglSyx9V3WJ-jy64MbrMeeWhTmrVV0=s120-c-rp-mo-br100',1392,NULL,'image-ex',14,NULL,NULL,NULL,NULL,NULL,NULL),(89,'mailto:scott@mes-ltd.net',1457,NULL,'external',17,NULL,NULL,NULL,NULL,NULL,NULL),(100,'tel:028%209335%202462',1457,NULL,'external',17,NULL,NULL,NULL,NULL,NULL,NULL),(101,'mailto:info@agnewrecovery.com',1457,NULL,'external',17,NULL,NULL,NULL,NULL,NULL,NULL),(102,'mailto:sales@mes-ltd.net',1457,NULL,'external',17,NULL,NULL,NULL,NULL,NULL,NULL),(108,'https://dev.sitesmart.io/mes/contact-us/',1392,1457,'internal',14,17,NULL,NULL,NULL,NULL,NULL),(111,'https://dev.sitesmart.io/mes/contact-us/',1392,1457,'internal',14,17,NULL,NULL,NULL,NULL,NULL),(112,'https://www.ledlenser.com/uk/',1392,NULL,'external',14,NULL,NULL,NULL,NULL,NULL,NULL),(113,'https://www.tengtools.com/',1392,NULL,'external',14,NULL,NULL,NULL,NULL,NULL,NULL),(115,'https://www.sealey.co.uk/',1392,NULL,'external',14,NULL,NULL,NULL,NULL,NULL,NULL),(116,'https://www.sealey.co.uk/',1392,NULL,'external',14,NULL,NULL,NULL,NULL,NULL,NULL),(127,'https://dev.sitesmart.io/mes/contact-us/',1437,1457,'internal',16,17,NULL,NULL,NULL,NULL,NULL),(128,'https://dev.sitesmart.io/mes/contact-us/',1437,1457,'internal',16,17,NULL,NULL,NULL,NULL,NULL),(130,'https://dev.sitesmart.io/mes/contact-us/',1513,1457,'internal',18,17,NULL,NULL,NULL,NULL,NULL),(131,'https://dev.sitesmart.io/mes/contact-us/',1513,1457,'internal',18,17,NULL,NULL,NULL,NULL,NULL),(133,'https://dev.sitesmart.io/mes/contact-us/',1525,1457,'internal',19,17,NULL,NULL,NULL,NULL,NULL),(134,'https://dev.sitesmart.io/mes/contact-us/',1525,1457,'internal',19,17,NULL,NULL,NULL,NULL,NULL),(136,'https://dev.sitesmart.io/mes/fasteners/',1437,1513,'internal',16,18,NULL,NULL,NULL,NULL,NULL),(137,'https://dev.sitesmart.io/mes/fasteners/',1437,1513,'internal',16,18,NULL,NULL,NULL,NULL,NULL),(138,'https://dev.sitesmart.io/mes/tools-and-power-tools/',1437,1525,'internal',16,19,NULL,NULL,NULL,NULL,NULL),(139,'https://dev.sitesmart.io/mes/tools-and-power-tools/',1437,1525,'internal',16,19,NULL,NULL,NULL,NULL,NULL),(140,'https://dev.sitesmart.io/mes/contact-us/',1537,1457,'internal',20,17,NULL,NULL,NULL,NULL,NULL),(141,'https://dev.sitesmart.io/mes/contact-us/',1537,1457,'internal',20,17,NULL,NULL,NULL,NULL,NULL),(143,'https://dev.sitesmart.io/mes/consumables-and-ppe/',1437,1537,'internal',16,20,NULL,NULL,NULL,NULL,NULL),(144,'https://dev.sitesmart.io/mes/consumables-and-ppe/',1437,1537,'internal',16,20,NULL,NULL,NULL,NULL,NULL),(145,'https://dev.sitesmart.io/mes/consumables-and-ppe/',1437,1537,'internal',16,20,NULL,NULL,NULL,NULL,NULL),(146,'https://dev.sitesmart.io/mes/consumables-and-ppe/',1437,1537,'internal',16,20,NULL,NULL,NULL,NULL,NULL),(148,'https://dev.sitesmart.io/mes/fasteners/',1392,1513,'internal',14,18,NULL,NULL,NULL,NULL,NULL),(149,'https://dev.sitesmart.io/mes/tools-and-power-tools/',1392,1525,'internal',14,19,NULL,NULL,NULL,NULL,NULL),(150,'https://dev.sitesmart.io/mes/consumables-and-ppe/',1392,1537,'internal',14,20,NULL,NULL,NULL,NULL,NULL),(155,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/pexels-photo-259988-scaled-1-1024x683.jpg',1513,1442,'image-in',18,NULL,1707,2560,451141,NULL,NULL),(160,'https://dev.sitesmart.io/mes/contact-us/',1684,1457,'internal',21,17,NULL,NULL,NULL,NULL,NULL),(161,'https://dev.sitesmart.io/mes/contact-us/',1695,1457,'internal',22,17,NULL,NULL,NULL,NULL,NULL),(162,'https://dev.sitesmart.io/mes/contact-us/',1695,1457,'internal',22,17,NULL,NULL,NULL,NULL,NULL),(163,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/01/pexels-photo-259988-scaled-1-1024x683.jpg',1695,1442,'image-in',22,NULL,1707,2560,451141,NULL,NULL),(164,'https://dev.sitesmart.io/mes/wp-content/uploads/2024/02/qhhjkxare7a-1024x682.jpg',1513,1621,'image-in',18,NULL,1065,1600,216839,NULL,NULL);


