
--
-- 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 (1267,5,0),(1280,5,0),(1317,5,0),(1351,5,0),(1498,6,0),(1516,7,0),(1517,7,0),(1518,7,0),(1519,7,0),(1520,7,0),(1521,7,0),(1522,7,0),(1523,7,0),(1524,7,0),(1526,2,0),(1527,2,0),(1528,2,0),(1529,2,0),(1530,2,0),(1531,2,0),(1532,2,0),(1533,2,0),(1576,5,0),(1626,2,0),(1627,2,0),(1628,7,0),(1629,7,0),(1693,2,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=8 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,11),(5,5,'elementor_library_type','',0,1),(6,6,'elementor_library_type','',0,1),(7,7,'nav_menu','',0,11);

--
-- 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');

--
-- 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'Main menu','main-menu',0),(5,'header','header',0),(6,'footer','footer',0),(7,'Device Menu','device-menu',0);

--
-- 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=33 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:\"405c4e366c25abc4d9fadf3cd69c4dde5ffe8182818dbf522d38244f4cf8c67c\";a:4:{s:10:\"expiration\";i:1712578950;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:1711369350;}}'),(17,1,'wp_dashboard_quick_press_last_post_id','1694'),(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,'closedpostboxes_dashboard','a:0:{}'),(23,1,'metaboxhidden_dashboard','a:10:{i:0;s:27:\"wpforms_reports_widget_lite\";i:1;s:20:\"e-dashboard-overview\";i:2;s:21:\"dashboard_site_health\";i:3;s:19:\"dashboard_right_now\";i:4;s:18:\"dashboard_activity\";i:5;s:18:\"custom_help_widget\";i:6;s:24:\"wpseo-dashboard-overview\";i:7;s:32:\"wpseo-wincher-dashboard-overview\";i:8;s:21:\"dashboard_quick_press\";i:9;s:17:\"dashboard_primary\";}'),(25,1,'elementor_introduction','a:3:{s:27:\"ai-get-started-announcement\";b:1;s:20:\"globals_introduction\";b:1;s:18:\"yoast-introduction\";b:1;}'),(26,1,'wp_elementor_connect_common_data','a:7:{s:9:\"client_id\";s:32:\"hAjxWNn7pOEgUtPgVuPtbhRgUKp3cxfL\";s:11:\"auth_secret\";s:32:\"qgPxFsSeZr97QsHD0MLv2URVGA3XpZTO\";s:12:\"access_token\";s:297:\"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOjI4NTI5LCJhdWQiOiJodHRwczovL2Rldi5zaXRlc21hcnQuaW8vc2NhbGVzLyIsImNsaWVudF9pZCI6ImhBanhXTm43cE9FZ1V0UGdWdVB0YmhSZ1VLcDNjeGZMIiwiY29ubmVjdF90eXBlIjoibGlicmFyeSIsImlhdCI6MTcwNTY1OTg3NSwiZXhwIjozMTcyNTAxMDIyNzV9.hWN2sjnaNcj5RQlaPO3b8KTJIc86G5dcwqPvi9qiJjc\";s:19:\"access_token_secret\";s:32:\"nULHtELiDn6LmPA6U76RvjALGAHv8RZC\";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;}'),(27,1,'wp_user-settings','libraryContent=browse&editor=tinymce&hidetb=1'),(28,1,'wp_user-settings-time','1705919308'),(29,1,'nav_menu_recently_edited','2'),(30,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\";}'),(31,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\";}'),(32,1,'elementor_admin_notices','a:1:{s:20:\"design_not_appearing\";a:2:{s:9:\"is_viewed\";b:1;s:4:\"meta\";a:1:{s:7:\"version\";s:6:\"3.19.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$BcD.ii/3dvJxj3XVofV8zL2nIoVcM31','kobault','hello@kobault.com','https://dev.sitesmart.io/scales','2024-01-19 09:26:50','',0,'kobault');

--
-- 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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

INSERT INTO `wp_wpforms_tasks_meta` VALUES (1,'wpforms_process_forms_locator_scan','W10=','2024-02-04 10:22:12'),(3,'wpforms_admin_addons_cache_update','W10=','2024-03-25 12:22:42'),(4,'wpforms_admin_builder_templates_cache_update','W10=','2024-03-25 12:22:42');

--
-- 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/scales/','32:ddffec529356dc20fcf9f55fe9c5a84c',635,'post','page',1,0,NULL,NULL,'Home','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,90,0,NULL,0,NULL,NULL,NULL,NULL,'https://dev.sitesmart.io/scales/wp-content/uploads/elementor/thumbs/AdobeStock_100696123-scaled-qiompid5kz2wzlzd8vovw8zd550fbkaxftonv8uz1e.jpeg',NULL,NULL,'first-content-image',NULL,NULL,'https://dev.sitesmart.io/scales/wp-content/uploads/elementor/thumbs/AdobeStock_100696123-scaled-qiompid5kz2wzlzd8vovw8zd550fbkaxftonv8uz1e.jpeg',NULL,'first-content-image',NULL,3,NULL,NULL,'2024-01-19 10:09:02','2024-03-25 12:26:03',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-25 12:26:00','2021-06-11 14:11:42',0),(3,'https://dev.sitesmart.io/scales/scales-and-weighing-equipment/','62:42eccffbfc83cf59405bad38f24f7436',11,'post','page',1,0,NULL,NULL,'Scales and Weighing Equipment','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,3,NULL,NULL,'2024-01-19 10:09:04','2024-03-25 12:24:56',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-25 12:24:56','2021-06-12 06:25:44',0),(5,'https://dev.sitesmart.io/scales/contact-us/','43:8e8da7c621d59bfdff96200ad5600aab',17,'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,17,NULL,'2024-01-19 10:09:04','2024-03-26 08:57:49',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-26 08:57:49','2021-06-12 06:28:48',0),(6,'https://dev.sitesmart.io/scales/','32:ddffec529356dc20fcf9f55fe9c5a84c',NULL,'home-page',NULL,NULL,NULL,'%%sitename%% %%page%% %%sep%% %%sitedesc%%','Label &amp; Weights Solutions','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-19 10:09:23','2024-03-26 08:57:49',1,NULL,NULL,NULL,NULL,0,NULL,2,'2024-03-26 08:57:49',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-01-19 11:40:36','2024-01-19 11:40:36',1,NULL,NULL,NULL,NULL,0,NULL,1,NULL,NULL,NULL),(8,'https://dev.sitesmart.io/scales/label-printing-equipment-and-labels/','68:e7879ab1474e68e6c49c750f5eb14184',1386,'post','page',1,0,NULL,NULL,'Label Printing Equipment and Labels','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,3,NULL,NULL,'2024-01-19 14:57:43','2024-03-25 12:24:40',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-25 12:24:39','2024-01-19 14:59:33',0),(9,'https://dev.sitesmart.io/scales/calibration-services/','53:b944e148880db09d31d89640e6f7a00f',1388,'post','page',1,0,NULL,NULL,'Calibration 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,3,NULL,NULL,'2024-01-19 14:58:52','2024-03-25 12:25:08',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-25 12:25:07','2024-01-19 15:00:17',0),(10,'https://dev.sitesmart.io/scales/special-offers/','47:323f616e2b180981d90282d01bb070fc',1390,'post','page',1,0,NULL,NULL,'Special Offers','publish',NULL,0,NULL,NULL,NULL,NULL,NULL,90,0,NULL,0,NULL,NULL,NULL,NULL,'https://dev.sitesmart.io/scales/wp-content/uploads/2024/01/AdobeStock_545961513-1024x683.jpeg',NULL,NULL,'first-content-image',NULL,NULL,'https://dev.sitesmart.io/scales/wp-content/uploads/2024/01/AdobeStock_545961513-1024x683.jpeg',NULL,'first-content-image',NULL,1,NULL,NULL,'2024-01-19 14:59:20','2024-03-25 14:10:33',1,NULL,NULL,NULL,NULL,0,2,2,'2024-03-25 14:10:33','2024-01-19 15:55:12',0),(11,'https://dev.sitesmart.io/scales/barcode-services/','49:d638e681f48e6fdf444ce319d5bb2fde',1392,'post','page',1,0,NULL,NULL,'Barcode 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,3,NULL,NULL,'2024-01-19 14:59:37','2024-03-25 12:25:20',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-25 12:25:20','2024-01-19 15:45:40',0),(12,'https://dev.sitesmart.io/scales/butchery-equipment/','51:8bbee64348ba90205e3d83cfdee0c62c',1393,'post','page',1,0,NULL,NULL,'Butchery Equipment','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,3,NULL,NULL,'2024-01-19 14:59:57','2024-03-25 12:24:25',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-25 12:24:25','2024-01-19 14:59:57',0),(13,'https://dev.sitesmart.io/scales/batch-control/','46:7871dcd9ededb454c2851c2a72e34532',1397,'post','page',1,0,NULL,NULL,'Batch Control','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,3,NULL,NULL,'2024-01-19 15:01:01','2024-03-25 12:24:13',1,NULL,NULL,NULL,NULL,0,1,2,'2024-03-25 12:24:13','2024-01-19 15:01:01',0),(14,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-29 02:49:56','2024-01-29 02:49:56',1,NULL,NULL,NULL,NULL,0,NULL,1,NULL,NULL,NULL),(15,'https://dev.sitesmart.io/scales/category/uncategorized/','55:749f54f380abda60ec0aab64934613b2',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-02-21 13:31:35','2024-02-21 13:31:35',1,NULL,NULL,NULL,NULL,0,NULL,2,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-02-21 13:31:35','2024-02-21 13:31:35',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),(3,0,0,1),(5,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=75 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `wp_yoast_seo_links` VALUES (34,'https://dev.sitesmart.io/scales/contact-us/',11,17,'internal',3,5,NULL,NULL,NULL,NULL,NULL),(35,'https://dev.sitesmart.io/scales/contact-us/',11,17,'internal',3,5,NULL,NULL,NULL,NULL,NULL),(36,'https://dev.sitesmart.io/scales/contact-us/',1388,17,'internal',9,5,NULL,NULL,NULL,NULL,NULL),(37,'https://dev.sitesmart.io/scales/contact-us/',1388,17,'internal',9,5,NULL,NULL,NULL,NULL,NULL),(38,'https://dev.sitesmart.io/scales/contact-us/',1393,17,'internal',12,5,NULL,NULL,NULL,NULL,NULL),(39,'https://dev.sitesmart.io/scales/contact-us/',1393,17,'internal',12,5,NULL,NULL,NULL,NULL,NULL),(41,'https://dev.sitesmart.io/scales/contact-us/',1386,17,'internal',8,5,NULL,NULL,NULL,NULL,NULL),(42,'https://dev.sitesmart.io/scales/contact-us/',1386,17,'internal',8,5,NULL,NULL,NULL,NULL,NULL),(43,'https://dev.sitesmart.io/scales/contact-us/',1392,17,'internal',11,5,NULL,NULL,NULL,NULL,NULL),(44,'https://dev.sitesmart.io/scales/contact-us/',1392,17,'internal',11,5,NULL,NULL,NULL,NULL,NULL),(45,'https://dev.sitesmart.io/scales/contact-us/',1397,17,'internal',13,5,NULL,NULL,NULL,NULL,NULL),(46,'https://dev.sitesmart.io/scales/contact-us/',1397,17,'internal',13,5,NULL,NULL,NULL,NULL,NULL),(47,'https://dev.sitesmart.io/scales/contact-us/',1390,17,'internal',10,5,NULL,NULL,NULL,NULL,NULL),(48,'https://dev.sitesmart.io/scales/contact-us/',1390,17,'internal',10,5,NULL,NULL,NULL,NULL,NULL),(49,'https://dev.sitesmart.io/scales/contact-us/',635,17,'internal',1,5,NULL,NULL,NULL,NULL,NULL),(50,'https://dev.sitesmart.io/scales/contact-us/',635,17,'internal',1,5,NULL,NULL,NULL,NULL,NULL),(51,'https://dev.sitesmart.io/scales/contact-us/',635,17,'internal',1,5,NULL,NULL,NULL,NULL,NULL),(61,'https://dev.sitesmart.io/scales/wp-content/uploads/2024/01/AdobeStock_545961513-1024x683.jpeg',1390,1642,'image-in',10,NULL,1707,2560,307663,NULL,NULL),(63,'https://dev.sitesmart.io/scales/wp-content/uploads/elementor/thumbs/AdobeStock_100696123-scaled-qiompid5kz2wzlzd8vovw8zd550fbkaxftonv8uz1e.jpeg',635,NULL,'image-in',1,NULL,NULL,NULL,NULL,NULL,NULL),(64,'https://dev.sitesmart.io/scales/wp-content/uploads/elementor/thumbs/AdobeStock_195372855-scaled-qiomuadmbnme091icg1m2jkpunglg69t3h2iovrxeq.jpeg',635,NULL,'image-in',1,NULL,NULL,NULL,NULL,NULL,NULL),(65,'https://dev.sitesmart.io/scales/wp-content/uploads/elementor/thumbs/AdobeStock_200690090-scaled-qiomp8yromq1rid0rrmm7bcr7aar6l9m2j5t2h8wrm.jpeg',635,NULL,'image-in',1,NULL,NULL,NULL,NULL,NULL,NULL),(66,'https://dev.sitesmart.io/scales/wp-content/uploads/elementor/thumbs/AdobeStock_500363353-scaled-qion7x1df6a2cp8src4v83rbxsa726doyxlz7bkf6q.jpeg',635,NULL,'image-in',1,NULL,NULL,NULL,NULL,NULL,NULL),(67,'https://dev.sitesmart.io/scales/wp-content/uploads/elementor/thumbs/AdobeStock_545961513-scaled-qiomylgznbip7ws86t31zyfrv885q8diospmvjdyw2.jpeg',635,NULL,'image-in',1,NULL,NULL,NULL,NULL,NULL,NULL),(68,'https://dev.sitesmart.io/scales/wp-content/uploads/elementor/thumbs/AdobeStock_374624456-scaled-qion84k2xukcxkxvjfdvs1v0ov94rr7jnytv1j99sy.jpeg',635,NULL,'image-in',1,NULL,NULL,NULL,NULL,NULL,NULL),(69,'tel:0785%204586%20780',17,NULL,'external',5,NULL,NULL,NULL,NULL,NULL,NULL),(70,'tel:0780%201187%20175',17,NULL,'external',5,NULL,NULL,NULL,NULL,NULL,NULL),(71,'tel:0794%207848%20518',17,NULL,'external',5,NULL,NULL,NULL,NULL,NULL,NULL),(72,'tel:028%209267%201800',17,NULL,'external',5,NULL,NULL,NULL,NULL,NULL,NULL),(73,'tel:0779%20971%201538',17,NULL,'external',5,NULL,NULL,NULL,NULL,NULL,NULL),(74,'mailto:info@scalesandequipmentcentre.co.uk',17,NULL,'external',5,NULL,NULL,NULL,NULL,NULL,NULL);


