INSERT INTO `cchp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES
(3336, 3, '2022-02-04 14:32:55', '2022-02-04 19:32:55', '', 'WC - Hide the “X Has Been Removed From Your Cart” Message', '', 'publish', 'closed', 'closed', '', 'wc-hide-the-x-has-been-removed-from-your-cart-message', '', '', '2022-02-04 14:32:55', '2022-02-04 19:32:55', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/wc-hide-the-x-has-been-removed-from-your-cart-message/', 10, 'wpcb_snippet_post', '', 0),
(3337, 3, '2022-02-04 14:35:00', '2022-02-04 19:35:00', 'This Code Snippet prevents Listing Owners from leaving a review for their own Listings.', 'ML - Hide the Reviews Quick Action From the Listing Owner', '', 'publish', 'closed', 'closed', '', 'ml-hide-the-reviews-quick-action-from-the-listing-owner', '', '', '2022-02-04 14:35:00', '2022-02-04 19:35:00', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/ml-hide-the-reviews-quick-action-from-the-listing-owner/', 10, 'wpcb_snippet_post', '', 0),
(3338, 3, '2022-02-04 14:35:37', '2022-02-04 19:35:37', 'By default, if someone leaves a review on a Listing, the Review will post and there is no notification that goes out to the website admin.', 'ML - Hold All Reviews for Moderation and Notify Website Admin', '', 'publish', 'closed', 'closed', '', 'ml-hold-all-reviews-for-moderation-and-notify-website-admin', '', '', '2022-02-04 14:35:37', '2022-02-04 19:35:37', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/ml-hold-all-reviews-for-moderation-and-notify-website-admin/', 10, 'wpcb_snippet_post', '', 0),
(3339, 3, '2022-02-04 14:36:23', '2022-02-04 19:36:23', 'The Limit Image Upload Size code snippet helps preserve the performance and disk storage of a MyListing website. \n\nIf image governance is not performed, users can upload massive image sizes, so we recommend that you put this snippet in place before you launch your website. \n\nThis code snippet limits the max file upload size to 600KB.\n\nGuide: \nhttps://mylisting.club/mylisting-image-optimization/', 'ML - Limit Image Upload Size', '', 'publish', 'closed', 'closed', '', 'ml-limit-image-upload-size', '', '', '2022-02-04 14:36:23', '2022-02-04 19:36:23', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/ml-limit-image-upload-size/', 10, 'wpcb_snippet_post', '', 0),
(3340, 3, '2022-02-04 14:37:04', '2022-02-04 19:37:04', 'The Open Social Media Links in New Browser Tab code snippet provides additional functionality for MyListing websites. ', 'ML - Open Social Media Links in New Browser Tab', '', 'publish', 'closed', 'closed', '', 'ml-open-social-media-links-in-new-browser-tab', '', '', '2022-02-04 14:37:04', '2022-02-04 19:37:04', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/ml-open-social-media-links-in-new-browser-tab/', 0, 'wpcb_snippet_post', '', 0),
(3341, 3, '2022-02-04 14:38:26', '2022-02-04 19:38:26', 'While MyListing does offer a bit of flexibility with permalink structure and automation of that structure, from an SEO standpoint there are still shortcomings.', 'MyListing Add-on for Permalink Manager Pro', '', 'publish', 'closed', 'closed', '', 'pmp-parent-and-child-region-page-custom-links', '', '', '2022-11-03 16:26:46', '2022-11-03 20:26:46', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/pmp-parent-and-child-region-page-custom-links/', 10, 'wpcb_snippet_post', '', 0),
(3342, 3, '2022-02-04 14:40:51', '2022-02-04 19:40:51', 'The Remove Social Link Options from the Submit Form code snippet allows for additional design options within a MyListing website. \n\nFor the Social Links that you want to keep on the form, remove them from the snippet below or comment it out.', 'ML - Remove Social Link Options from the Submit Form', '', 'publish', 'closed', 'closed', '', 'ml-remove-social-link-options-from-the-submit-form', '', '', '2022-10-31 09:24:54', '2022-10-31 13:24:54', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/ml-remove-social-link-options-from-the-submit-form/', 10, 'wpcb_snippet_post', '', 0),
(3343, 3, '2022-02-04 14:41:24', '2022-02-04 19:41:24', 'If the Contact Email field is not filled in by the listing owner, the form will send to the listing owner. If the Contact Email field is filled in, the form will send to the email addresses entered, rather than the listing owner.\n', 'ML - Replace MyListing\'s Contact Form 7 With Elementor Pro', '', 'publish', 'closed', 'closed', '', 'ml-replace-mylistings-contact-form-7-with-elementor-pro', '', '', '2022-02-04 14:41:24', '2022-02-04 19:41:24', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/ml-replace-mylistings-contact-form-7-with-elementor-pro/', 10, 'wpcb_snippet_post', '', 0),
(3345, 3, '2022-02-04 14:44:49', '2022-02-04 19:44:49', 'As it\'s currently configured, this code snippet combines the Billing Address and Payment Methods Endpoints', 'WC - Combine Endpoints', '', 'publish', 'closed', 'closed', '', 'wc-combine-endpoints', '', '', '2022-02-04 14:44:49', '2022-02-04 19:44:49', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/wc-combine-endpoints/', 0, 'wpcb_snippet_post', '', 0),
(3364, 3, '2022-03-09 09:07:16', '2022-03-09 14:07:16', 'By default, Listing Packages that are FREE will display as $0 within the MyListing Pricing Tables and this code snippet allows for more flexibility.', 'ML - Change $0 to Free', '', 'publish', 'closed', 'closed', '', 'ml-change-0-to-free', '', '', '2022-03-09 09:07:16', '2022-03-09 14:07:16', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/ml-change-0-to-free/', 10, 'wpcb_snippet_post', '', 0),
(3390, 0, '2022-04-24 21:49:33', '2022-04-25 01:49:33', '', '', '', 'publish', 'closed', 'closed', '', '3390', '', '', '2022-04-24 21:49:33', '2022-04-25 01:49:33', '', 0, 'https://charlotte.mylisting.club/?claim=3390', 0, 'claim', '', 0),
(3455, 3, '2022-07-06 09:29:25', '2022-07-06 13:29:25', '', 'placeholder.png', '', 'inherit', 'open', 'closed', '', 'placeholder-png', '', '', '2022-07-06 09:29:25', '2022-07-06 13:29:25', '', 0, 'https://charlotte.mylisting.club/wp-content/uploads/2022/07/placeholder.png', 0, 'attachment', 'image/png', 0),
(3456, 3, '2022-07-06 09:29:25', '2022-07-06 13:29:25', '<a href=\"https://mylisting.club/product/termageddon/\" target=\"_blank\" rel=\"noopener\">\n				<h2>Termageddon</h2>\n						The Privacy Policy on this page was dynamically created, using Termageddon, to show you an example of how your own policies would look with this powerful and time-saving solution.\n<br><br>\nTermageddon helps protect MyListing websites from fines and lawsuits in less than 30 minutes and is currently available for businesses formed in the <strong>United States</strong>,\n<strong>Canada</strong>, <strong>Ireland</strong>, <strong>United Kingdom</strong>, and <strong>Australia</strong>.\n<br><br>\nGenerate any website policy, fast! <strong>Privacy Policy</strong>, <strong>Terms and Conditions</strong>, <strong>End-User License Agreement (EULA)</strong>, and <strong>Disclaimers</strong>.					\n						Get 20% OFF Termageddon					\n						</a>\n			<h1>Legal</h1>', 'MyCity Charlotte Privacy Policy', '', 'publish', 'closed', 'closed', '', 'mycity-charlotte-privacy-policy', '', '', '2022-07-06 09:29:52', '2022-07-06 13:29:52', '', 0, 'https://charlotte.mylisting.club/?elementor_library=vow-legal-page', 0, 'elementor_library', '', 0),
(3476, 3, '2022-09-08 09:29:51', '2022-09-08 13:29:51', '', 'Bypass WooCommerce Logout Confirmation', '', 'publish', 'closed', 'closed', '', 'wc-bypass-logout-confirmation', '', '', '2022-10-31 10:26:28', '2022-10-31 14:26:28', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/wc-bypass-logout-confirmation/', 10, 'wpcb_snippet_post', '', 0),
(3486, 0, '2022-09-27 15:41:19', '2022-09-27 19:41:19', '', '', '', 'publish', 'closed', 'closed', '', '3486', '', '', '2022-09-27 15:41:19', '2022-09-27 19:41:19', '', 0, 'https://charlotte.mylisting.club/?claim=3486', 0, 'claim', '', 0),
(3493, 3, '2022-10-24 11:07:25', '2022-10-24 15:07:25', '', 'placeholder.png', '', 'inherit', 'open', 'closed', '', 'placeholder-png-2', '', '', '2022-10-24 11:07:25', '2022-10-24 15:07:25', '', 0, 'https://charlotte.mylisting.club/wp-content/uploads/2022/10/placeholder.png', 0, 'attachment', 'image/png', 0),
(3504, 3, '2022-10-31 09:46:28', '2022-10-31 13:46:28', 'https://mylisting.club/ultimate-add-ons/single-listing-character-counter/', 'Single Listing Character Counter', '', 'publish', 'closed', 'closed', '', 'single-listing-word-counter', '', '', '2022-10-31 09:57:11', '2022-10-31 13:57:11', '', 0, 'https://charlotte.mylisting.club/wpcb_snippet_post/single-listing-word-counter/', 10, 'wpcb_snippet_post', '', 0),
(3562, 279, '2022-11-19 21:36:46', '2022-11-19 20:36:46', '', 'Spisested', '', 'publish', 'closed', 'closed', '', 'spisested', '', '', '2022-11-19 21:36:46', '2022-11-19 20:36:46', '', 0, 'https://spisesteder.dk/?post_type=case27_listing_type&#038;p=3562', 0, 'case27_listing_type', '', 0),
(3564, 279, '2022-11-19 21:38:02', '2022-11-19 20:38:02', '', 'Overnatningssted', '', 'publish', 'closed', 'closed', '', 'overnatningssted', '', '', '2022-11-19 21:38:15', '2022-11-19 20:38:15', '', 0, 'https://spisesteder.dk/?post_type=case27_listing_type&#038;p=3564', 0, 'case27_listing_type', '', 0),
(3583, 279, '2022-11-20 22:24:28', '2022-11-20 21:24:28', '', 'mycity-charlotte-bed-and-breakfast-demo-gallery.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-bed-and-breakfast-demo-gallery-jpg-2', '', '', '2022-11-20 22:24:28', '2022-11-20 21:24:28', '', 2029, 'https://spisesteder.dk/wp-content/uploads/listing-uploads/gallery/2020/06/mycity-charlotte-bed-and-breakfast-demo-gallery.jpg', 0, 'attachment', 'image/jpeg', 0),
(3584, 279, '2022-11-20 22:24:29', '2022-11-20 21:24:29', '', 'mycity-charlotte-bed-and-breakfast-demo-gallery-1.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-bed-and-breakfast-demo-gallery-1-jpg-2', '', '', '2022-11-20 22:24:29', '2022-11-20 21:24:29', '', 2029, 'https://spisesteder.dk/wp-content/uploads/listing-uploads/gallery/2020/06/mycity-charlotte-bed-and-breakfast-demo-gallery-1.jpg', 0, 'attachment', 'image/jpeg', 0),
(3585, 279, '2022-11-20 22:24:29', '2022-11-20 21:24:29', '', 'mycity-charlotte-bed-and-breakfast-demo-gallery-2.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-bed-and-breakfast-demo-gallery-2-jpg-2', '', '', '2022-11-20 22:24:29', '2022-11-20 21:24:29', '', 2029, 'https://spisesteder.dk/wp-content/uploads/listing-uploads/gallery/2020/06/mycity-charlotte-bed-and-breakfast-demo-gallery-2.jpg', 0, 'attachment', 'image/jpeg', 0),
(3586, 279, '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 'mycity-charlotte-bed-and-breakfast-demo-gallery-3.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-bed-and-breakfast-demo-gallery-3-jpg-2', '', '', '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 2029, 'https://spisesteder.dk/wp-content/uploads/listing-uploads/gallery/2020/06/mycity-charlotte-bed-and-breakfast-demo-gallery-3.jpg', 0, 'attachment', 'image/jpeg', 0),
(3587, 279, '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 'mycity-charlotte-add-your-listing-dining.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-add-your-listing-dining-jpg-2', '', '', '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 2029, 'https://spisesteder.dk/wp-content/uploads/2020/05/mycity-charlotte-add-your-listing-dining.jpg', 0, 'attachment', 'image/jpeg', 0),
(3588, 279, '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 'mycity-charlotte-add-your-listing-events.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-add-your-listing-events-jpg-2', '', '', '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 2029, 'https://spisesteder.dk/wp-content/uploads/2020/05/mycity-charlotte-add-your-listing-events.jpg', 0, 'attachment', 'image/jpeg', 0),
(3589, 279, '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 'mycity-charlotte-restaurant-demo-gallery-2.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-restaurant-demo-gallery-2-jpg', '', '', '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 2029, 'https://spisesteder.dk/wp-content/uploads/2020/05/mycity-charlotte-restaurant-demo-gallery-2.jpg', 0, 'attachment', 'image/jpeg', 0),
(3590, 279, '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 'mycity-charlotte-skyline-bw.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-skyline-bw-jpg-2', '', '', '2022-11-20 22:24:30', '2022-11-20 21:24:30', '', 2029, 'https://spisesteder.dk/wp-content/uploads/2020/05/mycity-charlotte-skyline-bw.jpg', 0, 'attachment', 'image/jpeg', 0),
(3591, 279, '2022-11-20 22:24:31', '2022-11-20 21:24:31', '', 'mycity-charlotte-event-demo-gallery-4.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-event-demo-gallery-4-jpg-3', '', '', '2022-11-20 22:24:31', '2022-11-20 21:24:31', '', 2029, 'https://spisesteder.dk/wp-content/uploads/2020/05/mycity-charlotte-event-demo-gallery-4.jpg', 0, 'attachment', 'image/jpeg', 0),
(3592, 279, '2022-11-20 22:24:31', '2022-11-20 21:24:31', '', 'mycity-charlotte-coffee-house-demo-gallery-2.jpg', '', 'inherit', 'open', 'closed', '', 'mycity-charlotte-coffee-house-demo-gallery-2-jpg-3', '', '', '2022-11-20 22:24:31', '2022-11-20 21:24:31', '', 2029, 'https://spisesteder.dk/wp-content/uploads/2020/05/mycity-charlotte-coffee-house-demo-gallery-2.jpg', 0, 'attachment', 'image/jpeg', 0);

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_seopress_significant_keywords`
--

CREATE TABLE `cchp_seopress_significant_keywords` (
  `id` bigint(20) NOT NULL,
  `post_id` bigint(20) DEFAULT NULL,
  `word` varchar(100) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `tf` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Data dump for tabellen `cchp_seopress_significant_keywords`
--

INSERT INTO `cchp_seopress_significant_keywords` (`id`, `post_id`, `word`, `count`, `tf`) VALUES
(781, 2, 'demo', 18, 0.0032591),
(782, 2, 'ballantyne', 8, 0.00144849),
(783, 2, 'charlotte', 8, 0.00144849),
(784, 2, 'listing', 8, 0.00144849),
(785, 2, 'open', 7, 0.00126743),
(786, 2, 'dilworth', 6, 0.00108637),
(787, 2, 'februar', 6, 0.00108637),
(788, 2, 'hotel', 5, 0.000905305),
(789, 2, 'breakfast', 4, 0.000724244),
(790, 2, 'shop', 4, 0.000724244),
(791, 2, 'street', 4, 0.000724244),
(792, 2, 'conference', 4, 0.000724244),
(793, 2, 'festival', 4, 0.000724244),
(794, 2, 'noda', 4, 0.000724244),
(795, 2, 'park', 4, 0.000724244),
(796, 2, 'bed', 4, 0.000724244),
(797, 2, 'pizza', 4, 0.000724244),
(798, 2, 'events', 4, 0.000724244),
(799, 2, 'explore', 3, 0.000543183),
(800, 2, 'experience', 3, 0.000543183),
(801, 1972, 'amet', 4, 0.0430108),
(802, 1972, 'ipsum', 4, 0.0430108),
(803, 1972, 'sit', 3, 0.0322581),
(804, 1972, 'lorem', 2, 0.0215054),
(805, 1972, 'magna', 2, 0.0215054),
(806, 1972, 'tellus', 2, 0.0215054),
(807, 1972, 'nunc', 2, 0.0215054),
(808, 1972, 'risus', 2, 0.0215054),
(809, 1972, 'convallis', 2, 0.0215054),
(810, 1972, 'volutpat', 2, 0.0215054),
(811, 1972, 'elementum', 2, 0.0215054),
(812, 1972, 'consequat', 2, 0.0215054),
(813, 1972, 'aliqua', 2, 0.0215054),
(814, 1972, 'nibh', 2, 0.0215054),
(815, 1972, 'dolore', 2, 0.0215054),
(816, 1972, 'eiusmod', 2, 0.0215054),
(817, 1972, 'dolor', 2, 0.0215054),
(818, 1972, 'consectetur', 2, 0.0215054),
(819, 1972, 'adipiscing', 2, 0.0215054),
(820, 1972, 'labore', 2, 0.0215054),
(821, 842, 'ipsum', 6, 0.0625),
(822, 842, 'sit', 4, 0.0416667),
(823, 842, 'amet', 4, 0.0416667),
(824, 842, 'nullam', 2, 0.0208333),
(825, 842, 'neque', 2, 0.0208333),
(826, 842, 'volutpat', 2, 0.0208333),
(827, 842, 'tincidunt', 2, 0.0208333),
(828, 842, 'ullamcorper', 2, 0.0208333),
(829, 842, 'risus', 2, 0.0208333),
(830, 842, 'lorem', 2, 0.0208333),
(831, 842, 'nisl', 2, 0.0208333),
(832, 842, 'enim', 2, 0.0208333),
(833, 842, 'fermentum', 2, 0.0208333),
(834, 842, 'odio', 2, 0.0208333),
(835, 842, 'feugiat', 2, 0.0208333),
(836, 842, 'pretium', 2, 0.0208333),
(837, 842, 'nibh', 2, 0.0208333),
(838, 842, 'nunc', 2, 0.0208333),
(839, 842, 'pulvinar', 2, 0.0208333),
(840, 842, 'integer', 2, 0.0208333),
(841, 799, 'amet', 4, 0.0430108),
(842, 799, 'ipsum', 4, 0.0430108),
(843, 799, 'sit', 3, 0.0322581),
(844, 799, 'lorem', 2, 0.0215054),
(845, 799, 'magna', 2, 0.0215054),
(846, 799, 'tellus', 2, 0.0215054),
(847, 799, 'nunc', 2, 0.0215054),
(848, 799, 'risus', 2, 0.0215054),
(849, 799, 'convallis', 2, 0.0215054),
(850, 799, 'volutpat', 2, 0.0215054),
(851, 799, 'elementum', 2, 0.0215054),
(852, 799, 'consequat', 2, 0.0215054),
(853, 799, 'aliqua', 2, 0.0215054),
(854, 799, 'nibh', 2, 0.0215054),
(855, 799, 'dolore', 2, 0.0215054),
(856, 799, 'eiusmod', 2, 0.0215054),
(857, 799, 'dolor', 2, 0.0215054),
(858, 799, 'consectetur', 2, 0.0215054),
(859, 799, 'adipiscing', 2, 0.0215054),
(860, 799, 'labore', 2, 0.0215054),
(861, 583, 'ipsum', 6, 0.0625),
(862, 583, 'sit', 4, 0.0416667),
(863, 583, 'amet', 4, 0.0416667),
(864, 583, 'nullam', 2, 0.0208333),
(865, 583, 'neque', 2, 0.0208333),
(866, 583, 'volutpat', 2, 0.0208333),
(867, 583, 'tincidunt', 2, 0.0208333),
(868, 583, 'ullamcorper', 2, 0.0208333),
(869, 583, 'risus', 2, 0.0208333),
(870, 583, 'lorem', 2, 0.0208333),
(871, 583, 'nisl', 2, 0.0208333),
(872, 583, 'enim', 2, 0.0208333),
(873, 583, 'fermentum', 2, 0.0208333),
(874, 583, 'odio', 2, 0.0208333),
(875, 583, 'feugiat', 2, 0.0208333),
(876, 583, 'pretium', 2, 0.0208333),
(877, 583, 'nibh', 2, 0.0208333),
(878, 583, 'nunc', 2, 0.0208333),
(879, 583, 'pulvinar', 2, 0.0208333),
(880, 583, 'integer', 2, 0.0208333),
(881, 542, 'amet', 4, 0.0430108),
(882, 542, 'ipsum', 4, 0.0430108),
(883, 542, 'sit', 3, 0.0322581),
(884, 542, 'lorem', 2, 0.0215054),
(885, 542, 'magna', 2, 0.0215054),
(886, 542, 'tellus', 2, 0.0215054),
(887, 542, 'nunc', 2, 0.0215054),
(888, 542, 'risus', 2, 0.0215054),
(889, 542, 'convallis', 2, 0.0215054),
(890, 542, 'volutpat', 2, 0.0215054),
(891, 542, 'elementum', 2, 0.0215054),
(892, 542, 'consequat', 2, 0.0215054),
(893, 542, 'aliqua', 2, 0.0215054),
(894, 542, 'nibh', 2, 0.0215054),
(895, 542, 'dolore', 2, 0.0215054),
(896, 542, 'eiusmod', 2, 0.0215054),
(897, 542, 'dolor', 2, 0.0215054),
(898, 542, 'consectetur', 2, 0.0215054),
(899, 542, 'adipiscing', 2, 0.0215054),
(900, 542, 'labore', 2, 0.0215054),
(1101, 2029, 'ipsum', 6, 0.0625),
(1102, 2029, 'sit', 4, 0.0416667),
(1103, 2029, 'amet', 4, 0.0416667),
(1104, 2029, 'nullam', 2, 0.0208333),
(1105, 2029, 'neque', 2, 0.0208333),
(1106, 2029, 'volutpat', 2, 0.0208333),
(1107, 2029, 'tincidunt', 2, 0.0208333),
(1108, 2029, 'ullamcorper', 2, 0.0208333),
(1109, 2029, 'risus', 2, 0.0208333),
(1110, 2029, 'lorem', 2, 0.0208333),
(1111, 2029, 'nisl', 2, 0.0208333),
(1112, 2029, 'enim', 2, 0.0208333),
(1113, 2029, 'fermentum', 2, 0.0208333),
(1114, 2029, 'odio', 2, 0.0208333),
(1115, 2029, 'feugiat', 2, 0.0208333),
(1116, 2029, 'pretium', 2, 0.0208333),
(1117, 2029, 'nibh', 2, 0.0208333),
(1118, 2029, 'nunc', 2, 0.0208333),
(1119, 2029, 'pulvinar', 2, 0.0208333),
(1120, 2029, 'integer', 2, 0.0208333);

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_snippets`
--

CREATE TABLE `cchp_snippets` (
  `id` bigint(20) NOT NULL,
  `name` tinytext NOT NULL DEFAULT '',
  `description` text NOT NULL DEFAULT '',
  `code` longtext NOT NULL DEFAULT '',
  `tags` longtext NOT NULL DEFAULT '',
  `scope` varchar(15) NOT NULL DEFAULT 'global',
  `priority` smallint(6) NOT NULL DEFAULT 10,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `modified` datetime NOT NULL DEFAULT '1999-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_snippets`
--

INSERT INTO `cchp_snippets` (`id`, `name`, `description`, `code`, `tags`, `scope`, `priority`, `active`, `modified`) VALUES
(2, 'Master CSS', '', 'add_action( \'wp_head\', function () { ?>\r\n<style>\r\n\r\n\r\n\r\n	\r\n\r\n/*************** NOTHING GOES BELOW THIS LINE ***************/\r\n	\r\n</style>\r\n<?php } );\r\n', 'css, master', 'front-end', 10, 0, '2022-02-04 19:14:59'),
(3, 'Change Package Selection Button Text for Free Packages', '', 'add_action( \'wp_head\', function () { ?>\r\n<script>\r\n\r\njQuery(document).ready(function($) {\r\n    $(\'.c27-packages .pricing-item .plan-name:contains(\"Basic\")\').siblings(\'.select-package\').find(\'a\').html(\'Free <i class=\"mi arrow_forward\">\')\r\n});\r\n\r\n</script>\r\n<?php } );\r\n', 'javascript, package selection, pricing tables, free, packages, button', 'front-end', 10, 0, '2020-06-06 21:48:37'),
(4, '~Order snippets by name', 'Order snippets by name by default in the snippets table.', 'add_filter( \'code_snippets/list_table/default_orderby\', function () {\r\n	return \'name\';\r\n} );\r\n', 'code-snippets-plugin', 'admin', 10, 1, '2020-06-06 22:21:42'),
(5, '~Order snippets by date', 'Order snippets by last modification date by default in the snippets table.', 'add_filter( \'code_snippets/list_table/default_orderby\', function () {\r\n	return \'modified\';\r\n} );\r\n\r\nadd_filter( \'code_snippets/list_table/default_order\', function () {\r\n	return \'desc\';\r\n} );\r\n', 'code-snippets-plugin', 'admin', 10, 0, '2020-06-06 22:21:22'),
(6, 'WooCommerce - Autocomplete Orders', 'By default, virtual orders will sit for extended periods of time and a \"processing\' state, which can delay invoices and order confirmations from being sent out.', 'add_action( \'woocommerce_thankyou\', \'custom_woocommerce_auto_complete_order\' );\r\nfunction custom_woocommerce_auto_complete_order( $order_id ) {\r\nif ( ! $order_id ) {\r\nreturn;\r\n}\r\n\r\n$order = wc_get_order( $order_id );\r\n$order->update_status( \'completed\' );\r\n}', 'functions.php, woocommerce, autocomplete, orders, automate', 'admin', 10, 0, '2020-09-02 13:25:58'),
(8, 'Hold All Reviews for Moderation and Notify Website Admin', 'By default, if someone leaves a review on a Listing, the Review will post and there is no notification that goes out to the website admin.', 'add_filter( \'pre_comment_approved\', function( $commentstatus, $commentdata ) {\r\n    $commentstatus = 0;\r\n    return $commentstatus;\r\n}, 10, 2 );\r\n\r\nadd_filter( \'wp_update_comment_data\', function( $data, $comment, $commentarr ) {\r\n \r\n    if ( isset( $data[\'comment_approved\'] ) ) {\r\n        $data[\'comment_approved\'] = 0;\r\n    }\r\n \r\n    return $data;\r\n \r\n}, 99, 3 );', 'functions.php, reviews, mylisting, moderation', 'front-end', 10, 0, '2020-06-06 21:22:55'),
(9, 'Replace MyListing\'s Contact Form 7 With Elementor Pro', 'If the Contact Email field is <strong>not filled in by the listing owner</strong>, the form will send to the listing owner. If the Contact Email field <strong>is filled in</strong>, the form will send to the email addresses entered, rather than the listing owner.\r\n\r\n<strong>Guide:</strong>  <a href=\"https://mylisting.club/replace-contact-form-7-with-elementor-pro/\" target=\"_blank\" rel=\"noopener\">Replace MyListing\'s Contact Form 7 With Elementor Pro</a>', 'function contact_form_email_func( $atts ){\r\n	$postID = get_the_ID();\r\n	$job_email = get_post_meta($postID, \'_job_email\')[0];\r\n	if(!$job_email){\r\n		$author_id = get_post_field(\'post_author\', $postID);\r\n		$job_email = get_the_author_meta(\'user_email\', $author_id);\r\n	}\r\n	return $job_email;\r\n}\r\nadd_shortcode( \'contact-form-email\', \'contact_form_email_func\' );', 'contact email, elementor pro, form, replace, functions.php, single listing', 'front-end', 10, 0, '2022-01-10 20:02:20'),
(10, 'Remove Social Links From Submit Form', '', 'add_filter( \'mylisting\\links-list\', function( $links ) {\r\n    // Remove a link\r\n    unset( $links[\'VKontakte\'] );\r\n	unset( $links[\'DeviantArt\'] );\r\n	unset( $links[\'SoundCloud\'] );\r\n    unset( $links[\'Website\'] );\r\n    unset( $links[\'Other\'] );\r\n    return $links;\r\n} );\r\n', 'functions.php, remove, submit form, mylisting', 'front-end', 10, 0, '2020-10-19 22:06:46'),
(11, 'WooCommerce Subscriptions Switch Plans', 'MyListing integrates with WooCommerce Subscriptions to provide Listing Subscription packages. This code snippet allows for the native switching capability of WC Subscriptions.', 'add_filter( \'mylisting/enable-subscription-switch\', \'__return_true\' );', 'functions.php, woocommerce, subscriptions, woocommerce subscriptions', 'front-end', 10, 1, '2020-10-09 15:09:38'),
(12, 'Elementor - Search Archives - Use Listing Gallery Image for Featured Image', 'When you create search archives with Elementor, Listings that appear in the archives will not have any image associated unless the Listing Type uses the Cover Image cover style.\r\n\r\nIf a Listing Type uses the Gallery Slider cover style, this snippet is important for search archives.', 'add_action( \'mylisting/submission/save-listing-data\', function( $listing_id, $fields ){\r\n    $listing = \\MyListing\\Src\\Listing::force_get( $listing_id );\r\n    if ( ! $listing ) {\r\n         return;\r\n     }\r\n \r\n    if ( ! $fields[\'job_gallery\'] || empty( $fields[\'job_gallery\'][\'value\'] ) ) {\r\n     return;\r\n    }\r\n \r\n    global $wpdb;\r\n    $attachment = $wpdb->get_col( $wpdb->prepare(\"SELECT ID FROM $wpdb->posts WHERE guid=\'%s\';\", $fields[\'job_gallery\'][\'value\'][0] ));\r\n    set_post_thumbnail( $listing_id, $attachment[0] );\r\n}, 10e4, 2 );', 'functions.php, elementor, search archives, search, featured image, gallery slider, cover style', 'front-end', 10, 0, '2022-02-04 19:22:33'),
(14, 'Default Map Zoom', '', 'add_action( \'wp_head\', function () { ?>\r\n<script>\r\n\r\njQuery(document).ready(function($) {\r\n    if ( $(\'.single-listing .map-block\').length ) {\r\n        var mapZoom = setInterval( function() {\r\n            if ( MyListing.Maps.instances.length ) {\r\n                MyListing.Maps.instances[0].map.setZoom(15);\r\n                clearInterval(mapZoom);\r\n            }\r\n        }, 500 );\r\n    }\r\n});\r\n	\r\n</script>\r\n<?php } );\r\n', 'javascript, map zoom, single listing, submit form', 'front-end', 10, 0, '2020-06-06 21:46:55'),
(15, 'Open Social Media Links in a New Browser Tab', '', 'add_action( \'wp_head\', function () { ?>\r\n<script>\r\n\r\njQuery(document).ready(function($){\r\n$(\'.block-type-social_networks ul > li a\').attr(\'target\', \'_blank\');\r\n});\r\n\r\n</script>\r\n<?php } );\r\n', 'javascript, social media links, single listing', 'front-end', 10, 0, '2020-06-06 21:50:36'),
(16, 'Open Listings in a New Browser Tab', '', 'add_action( \'wp_head\', function () { ?>\r\n<script>\r\n\r\njQuery( function($) {\r\n$(\'body.page-id-34\').on(\'click\', \'.lf-item > a\', function(e) {\r\ne.preventDefault();\r\nwindow.open( $(this).attr(\'href\'), \'_blank\' );\r\n});\r\n} );\r\n\r\n</script>\r\n<?php } );\r\n', 'javascript, single listings', 'front-end', 10, 0, '2020-06-06 21:51:55'),
(17, 'WooCommerce - Remove Order Notes and Additional Information', '', '// REMOVE ADDITIONAL INFORMATION\r\nadd_filter( \'woocommerce_enable_order_notes_field\', \'__return_false\' );\r\n\r\n// REMOVE THE ORDER NOTES\r\nadd_filter( \'woocommerce_checkout_fields\' , \'remove_order_notes\' );\r\n\r\nfunction remove_order_notes( $fields ) {\r\nunset($fields[\'order\'][\'order_comments\']);\r\nreturn $fields;\r\n}', 'functions.php, woocommerce, order notes, remove, additional information', 'front-end', 10, 0, '2021-05-28 13:53:17'),
(18, 'WooCommerce - Combine Billing Address and Payment Methods Endpoints', '', 'add_filter( \'woocommerce_account_menu_items\', function( $items ) {\r\n    unset($items[\'edit-address\']);\r\n    unset($items[\'payment-methods\']);\r\n    return $items;\r\n}, 999 );\r\n\r\nadd_action( \'woocommerce_account_edit-account_endpoint\', \'woocommerce_account_payment_methods\' );\r\nadd_action( \'woocommerce_account_edit-account_endpoint\', \'woocommerce_account_edit_address\' );', 'functions.php, woocommerce, combine, billing address, payment methods, endpoints', 'front-end', 10, 0, '2020-06-06 21:54:46'),
(19, 'Enable Calendly Integration', 'Calendly functionality can easily be added to MyListing websites, to give a free booking option for users.\r\n\r\n<strong>Guide: </strong><a href=\"https://mylisting.club/calendly-booking-for-single-listings-and-mylisting-websites/\"><span style=\"color: #000000; font-family: -apple-system, BlinkMacSystemFont, \'Segoe UI\', Roboto, Oxygen-Sans, Ubuntu, Cantarell, \'Helvetica Neue\', sans-serif; font-size: 15px;\">Calendly Booking for Single Listings and MyListing Websites</span></a>', 'add_action( \'wp_head\', function () { ?>\r\n\r\n<!-- CALENDLY INTEGRATION -->\r\n<script type=\"text/javascript\" src=\"https://assets.calendly.com/assets/external/widget.js\"></script>\r\n\r\n<?php } );', 'calendly, integration, booking, raw code', 'front-end', 10, 0, '2022-02-04 19:24:55'),
(29, 'Limit Image Upload Size', '<strong>Guide:</strong> <a href=\"https://mylisting.club/mylisting-image-optimization/\" target=\"_blank\" rel=\"noopener\">Image Optimization for MyLisitng Websites</a>', '// LIMIT IMAGE UPLOAD SIZE\r\nfunction max_image_size( $file ) {\r\n  $size = $file[\'size\'];\r\n  $size = $size / 1024;\r\n  $type = $file[\'type\'];\r\n  $is_image = strpos( $type, \'image\' ) !== false;\r\n  $limit = 600;\r\n  $limit_output = \'600KB\';\r\n  if ( $is_image && $size > $limit ) {\r\n    $file[\'error\'] = \'Image files must be smaller than \' . $limit_output;\r\n  }//end if\r\n  return $file;\r\n}//end max_image_size()\r\nadd_filter( \'wp_handle_upload_prefilter\', \'max_image_size\' );', 'functions.php, image governance', 'admin', 10, 0, '2021-07-08 16:04:52'),
(31, 'Hide the Reviews Quick Action From the Listing Owner', 'This Code Snippet prevents Listing Owners from leaving a review for their own Listings.', 'add_filter( \'body_class\', function( $classes ) {\n    if ( is_singular( \'job_listing\' ) ) {\n        global $post;\n        if ( absint( get_current_user_id() ) === absint( $post->post_author ) ) {\n            $classes[] = \'is-listing-author\';\n        }\n    }\n \n    return $classes;\n} );', 'functions.php, reviews, mylisting', 'front-end', 10, 0, '2021-04-07 14:08:40'),
(32, 'Hide Elements When Logged Out', '<strong>Instructions:</strong> Add the \'hideifloggedout\' class to any element you wish to hide.', 'add_action( \'wp_head\', function () { ?>\n<style>\n\nbody:not(.logged-in) .hideifloggedout {\n    display: none !important;\n}\n\n/*************** NOTHING GOES BELOW THIS LINE ***************/\n	\n</style>\n<?php } );\n', 'css, menu, logout', 'front-end', 10, 0, '2021-04-08 19:42:25'),
(33, 'Bypass WooCommerce Logout Confirmation', '', '// BYPASS WOOCOMMERCE LOGOUT CONFIRMATION\nfunction wc_bypass_logout_confirmation() {\nglobal $wp;\n\nif ( isset( $wp->query_vars[\'customer-logout\'] ) ) {\nwp_redirect( str_replace( \'&amp;\', \'&\', wp_logout_url( wc_get_page_permalink( \'myaccount\' ) ) ) );\nexit;\n}\n}\n\nadd_action( \'template_redirect\', \'wc_bypass_logout_confirmation\' );\n', 'javascript, functions.php, bypass, logout, woocommerce', 'front-end', 10, 0, '2021-04-21 12:19:13'),
(34, 'Fixes the \'Has been removed from your cart...\' Message', '', 'add_filter( \'woocommerce_cart_item_removed_message\', \'__return_false\' );', 'functions.php, cart, woocommerce', 'global', 10, 0, '2021-07-06 18:54:05'),
(35, 'Parent Region Page Custom Links w/ Permalink Manager Pro', 'While MyListing does offer a bit of flexibility with permalink structure and automation of that structure, <strong>from an SEO standpoint there are still shortcomings</strong>.\r\n\r\nIn short, if you want to specify and Parent/Child taxonomy relationship in MyLisiting URLs, you’re out of luck without a custom solution.\r\n\r\nWe called upon the <a href=\"https://mylisting.club/permalink-manager-pro\" target=\"_blank\" rel=\"noopener\">Permalink Manager Pro</a> plugin again, to make this happen. With the inclusion of this plugin in the Starter Site, <strong>MyListing website owners can now get granular with their permalinks, as well as automate that process</strong>.', '// PERMALINK MANAGER PRO - PART 1 - DO NOT USE PERMALINK MANAGER TO REWRITE REGION TAXONOMY PERMALINKS\r\nfunction bis_exclude_region_tax($taxs) {\r\n    if(is_array($taxs)) {\r\n        $taxs[] = \'region\';\r\n    }\r\n   \r\n    return $taxs;\r\n}\r\nadd_filter(\'permalink_manager_disabled_taxonomies\', \'bis_exclude_region_tax\');\r\n \r\n// PERMALINK MANAGER PRO - PART 2 - REWRITE REGION TAXONOMY PERMALINKES WITH REGION PAGES\r\nfunction bis_rewrite_region_tax_permalinks($link, $term, $taxonomy) {\r\n    if($taxonomy == \'region\' && function_exists(\'get_field\')) {\r\n        // A. Use \"Custom Landing Page\" ACF field\r\n        $region_page = get_field(\'_landing_page\', $term->taxonomy . \'_\' . $term->term_id);\r\n       \r\n        // B. Find the page with the same slug\r\n        if(empty($region_page)) {\r\n            $region_page = get_page_by_path($term->slug);\r\n        }\r\n       \r\n        // Change the term permalink to page permalink\r\n        if(!empty($region_page->ID)) {\r\n            $link = get_permalink($region_page->ID);\r\n        }\r\n \r\n    }\r\n   \r\n    return $link;\r\n}\r\nadd_filter(\'term_link\', \'bis_rewrite_region_tax_permalinks\', 100, 3);\r\n\r\n\r\n// PERMALINK MANAGER PRO - DO NOT USE PERMALINK MANAGER TO REWRITE LISTING CATEGORY TAXONOMY PERMALINKS\r\nfunction bis_exclude_category_tax($taxs) {\r\n    if(is_array($taxs)) {\r\n        $taxs[] = \'job_listing_category\';\r\n    }\r\n   \r\n    return $taxs;\r\n}\r\nadd_filter(\'permalink_manager_disabled_taxonomies\', \'bis_exclude_category_tax\');', 'functions.php, permalink manager pro, region pages', 'global', 10, 0, '2021-06-26 13:37:32');

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_termmeta`
--

CREATE TABLE `cchp_termmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_termmeta`
--

INSERT INTO `cchp_termmeta` (`meta_id`, `term_id`, `meta_key`, `meta_value`) VALUES
(181, 15, 'product_count_product_cat', '3'),
(182, 36, 'icon_type', 'icon'),
(183, 36, '_icon_type', 'field_5a32118560854'),
(184, 36, 'icon', 'fa fa-beer'),
(185, 36, '_icon', 'field_595b74be15f19'),
(186, 36, 'color', ''),
(187, 36, '_color', 'field_595b74f315f1a'),
(188, 36, 'text_color', ''),
(189, 36, '_text_color', 'field_595b750215f1b'),
(190, 36, 'image', '768'),
(191, 36, '_image', 'field_595b751015f1c'),
(192, 36, 'listing_type', 'a:1:{i:0;s:3:\"766\";}'),
(193, 36, '_listing_type', 'field_5a04e1d7362f5'),
(194, 36, '_landing_page', ''),
(195, 36, '__landing_page', 'field_5b4158c76e7dd'),
(210, 36, 'listings_full_count', '{\"restaurant\":1}'),
(212, 38, 'icon_type', 'icon'),
(213, 38, '_icon_type', 'field_5a32118560854'),
(214, 38, 'icon', 'fa fa-building'),
(215, 38, '_icon', 'field_595b74be15f19'),
(216, 38, 'color', ''),
(217, 38, '_color', 'field_595b74f315f1a'),
(218, 38, 'text_color', ''),
(219, 38, '_text_color', 'field_595b750215f1b'),
(220, 38, 'image', '854'),
(221, 38, '_image', 'field_595b751015f1c'),
(222, 38, 'listing_type', 'a:1:{i:0;s:3:\"785\";}'),
(223, 38, '_listing_type', 'field_5a04e1d7362f5'),
(224, 38, '_landing_page', ''),
(225, 38, '__landing_page', 'field_5b4158c76e7dd'),
(226, 38, 'listings_full_count', '{\"lodging\":1}'),
(227, 39, 'icon_type', 'icon'),
(228, 39, '_icon_type', 'field_5a32118560854'),
(229, 39, 'icon', 'mi music_note'),
(230, 39, '_icon', 'field_595b74be15f19'),
(231, 39, 'color', ''),
(232, 39, '_color', 'field_595b74f315f1a'),
(233, 39, 'text_color', ''),
(234, 39, '_text_color', 'field_595b750215f1b'),
(235, 39, 'image', '428'),
(236, 39, '_image', 'field_595b751015f1c'),
(237, 39, 'listing_type', 'a:1:{i:0;s:3:\"586\";}'),
(238, 39, '_listing_type', 'field_5a04e1d7362f5'),
(239, 39, '_landing_page', ''),
(240, 39, '__landing_page', 'field_5b4158c76e7dd'),
(256, 41, 'icon_type', 'icon'),
(257, 41, '_icon_type', 'field_5a32118560854'),
(258, 41, 'icon', ''),
(259, 41, '_icon', 'field_595b74be15f19'),
(260, 41, 'color', ''),
(261, 41, '_color', 'field_595b74f315f1a'),
(262, 41, 'text_color', ''),
(263, 41, '_text_color', 'field_595b750215f1b'),
(264, 41, 'image', ''),
(265, 41, '_image', 'field_595b751015f1c'),
(266, 41, 'listing_type', ''),
(267, 41, '_listing_type', 'field_5a04e1d7362f5'),
(268, 41, '_landing_page', ''),
(269, 41, '__landing_page', 'field_5b4158c76e7dd'),
(396, 41, 'listings_full_count', '{\"neighborhood\":1,\"overnatningssted\":1,\"place\":1,\"spisested\":1}'),
(397, 51, 'icon_type', 'icon'),
(398, 51, '_icon_type', 'field_5a32118560854'),
(399, 51, 'icon', 'mi directions_bike'),
(400, 51, '_icon', 'field_595b74be15f19'),
(401, 51, 'color', ''),
(402, 51, '_color', 'field_595b74f315f1a'),
(403, 51, 'text_color', ''),
(404, 51, '_text_color', 'field_595b750215f1b'),
(405, 51, 'image', ''),
(406, 51, '_image', 'field_595b751015f1c'),
(407, 51, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(408, 51, '_listing_type', 'field_5a04e1d7362f5'),
(409, 51, '_landing_page', ''),
(410, 51, '__landing_page', 'field_5b4158c76e7dd'),
(411, 52, 'icon_type', 'icon'),
(412, 52, '_icon_type', 'field_5a32118560854'),
(413, 52, 'icon', 'fa fa-road'),
(414, 52, '_icon', 'field_595b74be15f19'),
(415, 52, 'color', ''),
(416, 52, '_color', 'field_595b74f315f1a'),
(417, 52, 'text_color', ''),
(418, 52, '_text_color', 'field_595b750215f1b'),
(419, 52, 'image', ''),
(420, 52, '_image', 'field_595b751015f1c'),
(421, 52, 'listing_type', 'a:2:{i:0;s:4:\"3562\";i:1;s:4:\"3564\";}'),
(422, 52, '_listing_type', 'field_5a04e1d7362f5'),
(423, 52, '_landing_page', ''),
(424, 52, '__landing_page', 'field_5b4158c76e7dd'),
(425, 53, 'icon_type', 'icon'),
(426, 53, '_icon_type', 'field_5a32118560854'),
(427, 53, 'icon', 'mi local_parking'),
(428, 53, '_icon', 'field_595b74be15f19'),
(429, 53, 'color', ''),
(430, 53, '_color', 'field_595b74f315f1a'),
(431, 53, 'text_color', ''),
(432, 53, '_text_color', 'field_595b750215f1b'),
(433, 53, 'image', ''),
(434, 53, '_image', 'field_595b751015f1c'),
(435, 53, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(436, 53, '_listing_type', 'field_5a04e1d7362f5'),
(437, 53, '_landing_page', ''),
(438, 53, '__landing_page', 'field_5b4158c76e7dd'),
(439, 54, 'icon_type', 'icon'),
(440, 54, '_icon_type', 'field_5a32118560854'),
(441, 54, 'icon', 'mi wifi'),
(442, 54, '_icon', 'field_595b74be15f19'),
(443, 54, 'color', ''),
(444, 54, '_color', 'field_595b74f315f1a'),
(445, 54, 'text_color', ''),
(446, 54, '_text_color', 'field_595b750215f1b'),
(447, 54, 'image', ''),
(448, 54, '_image', 'field_595b751015f1c'),
(449, 54, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(450, 54, '_listing_type', 'field_5a04e1d7362f5'),
(451, 54, '_landing_page', ''),
(452, 54, '__landing_page', 'field_5b4158c76e7dd'),
(453, 55, 'icon_type', 'icon'),
(454, 55, '_icon_type', 'field_5a32118560854'),
(455, 55, 'icon', 'mi flag'),
(456, 55, '_icon', 'field_595b74be15f19'),
(457, 55, 'color', ''),
(458, 55, '_color', 'field_595b74f315f1a'),
(459, 55, 'text_color', ''),
(460, 55, '_text_color', 'field_595b750215f1b'),
(461, 55, 'image', ''),
(462, 55, '_image', 'field_595b751015f1c'),
(463, 55, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(464, 55, '_listing_type', 'field_5a04e1d7362f5'),
(465, 55, '_landing_page', ''),
(466, 55, '__landing_page', 'field_5b4158c76e7dd'),
(467, 56, 'icon_type', 'icon'),
(468, 56, '_icon_type', 'field_5a32118560854'),
(469, 56, 'icon', 'fab fa-cc-apple-pay'),
(470, 56, '_icon', 'field_595b74be15f19'),
(471, 56, 'color', ''),
(472, 56, '_color', 'field_595b74f315f1a'),
(473, 56, 'text_color', ''),
(474, 56, '_text_color', 'field_595b750215f1b'),
(475, 56, 'image', ''),
(476, 56, '_image', 'field_595b751015f1c'),
(477, 56, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(478, 56, '_listing_type', 'field_5a04e1d7362f5'),
(479, 56, '_landing_page', ''),
(480, 56, '__landing_page', 'field_5b4158c76e7dd'),
(481, 57, 'icon_type', 'icon'),
(482, 57, '_icon_type', 'field_5a32118560854'),
(483, 57, 'icon', 'fa fa-credit-card'),
(484, 57, '_icon', 'field_595b74be15f19'),
(485, 57, 'color', ''),
(486, 57, '_color', 'field_595b74f315f1a'),
(487, 57, 'text_color', ''),
(488, 57, '_text_color', 'field_595b750215f1b'),
(489, 57, 'image', ''),
(490, 57, '_image', 'field_595b751015f1c'),
(491, 57, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(492, 57, '_listing_type', 'field_5a04e1d7362f5'),
(493, 57, '_landing_page', ''),
(494, 57, '__landing_page', 'field_5b4158c76e7dd'),
(495, 58, 'icon_type', 'icon'),
(496, 58, '_icon_type', 'field_5a32118560854'),
(497, 58, 'icon', 'fa fa-dog'),
(498, 58, '_icon', 'field_595b74be15f19'),
(499, 58, 'color', ''),
(500, 58, '_color', 'field_595b74f315f1a'),
(501, 58, 'text_color', ''),
(502, 58, '_text_color', 'field_595b750215f1b'),
(503, 58, 'image', ''),
(504, 58, '_image', 'field_595b751015f1c'),
(505, 58, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(506, 58, '_listing_type', 'field_5a04e1d7362f5'),
(507, 58, '_landing_page', ''),
(508, 58, '__landing_page', 'field_5b4158c76e7dd'),
(509, 59, 'icon_type', 'icon'),
(510, 59, '_icon_type', 'field_5a32118560854'),
(511, 59, 'icon', 'fa fa-child'),
(512, 59, '_icon', 'field_595b74be15f19'),
(513, 59, 'color', ''),
(514, 59, '_color', 'field_595b74f315f1a'),
(515, 59, 'text_color', ''),
(516, 59, '_text_color', 'field_595b750215f1b'),
(517, 59, 'image', ''),
(518, 59, '_image', 'field_595b751015f1c'),
(519, 59, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(520, 59, '_listing_type', 'field_5a04e1d7362f5'),
(521, 59, '_landing_page', ''),
(522, 59, '__landing_page', 'field_5b4158c76e7dd'),
(523, 60, 'icon_type', 'icon'),
(524, 60, '_icon_type', 'field_5a32118560854'),
(525, 60, 'icon', 'fa fa-train'),
(526, 60, '_icon', 'field_595b74be15f19'),
(527, 60, 'color', ''),
(528, 60, '_color', 'field_595b74f315f1a'),
(529, 60, 'text_color', ''),
(530, 60, '_text_color', 'field_595b750215f1b'),
(531, 60, 'image', ''),
(532, 60, '_image', 'field_595b751015f1c'),
(533, 60, 'listing_type', 'a:2:{i:0;s:4:\"3562\";i:1;s:4:\"3564\";}'),
(534, 60, '_listing_type', 'field_5a04e1d7362f5'),
(535, 60, '_landing_page', ''),
(536, 60, '__landing_page', 'field_5b4158c76e7dd'),
(551, 62, 'icon_type', 'icon'),
(552, 62, '_icon_type', 'field_5a32118560854'),
(553, 62, 'icon', 'mi event_seat'),
(554, 62, '_icon', 'field_595b74be15f19'),
(555, 62, 'color', ''),
(556, 62, '_color', 'field_595b74f315f1a'),
(557, 62, 'text_color', ''),
(558, 62, '_text_color', 'field_595b750215f1b'),
(559, 62, 'image', ''),
(560, 62, '_image', 'field_595b751015f1c'),
(561, 62, 'listing_type', 'a:1:{i:0;s:3:\"586\";}'),
(562, 62, '_listing_type', 'field_5a04e1d7362f5'),
(563, 62, '_landing_page', ''),
(564, 62, '__landing_page', 'field_5b4158c76e7dd'),
(565, 63, 'icon_type', 'icon'),
(566, 63, '_icon_type', 'field_5a32118560854'),
(567, 63, 'icon', 'fa fa-wine-glass-alt'),
(568, 63, '_icon', 'field_595b74be15f19'),
(569, 63, 'color', ''),
(570, 63, '_color', 'field_595b74f315f1a'),
(571, 63, 'text_color', ''),
(572, 63, '_text_color', 'field_595b750215f1b'),
(573, 63, 'image', ''),
(574, 63, '_image', 'field_595b751015f1c'),
(575, 63, 'listing_type', 'a:3:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";}'),
(576, 63, '_listing_type', 'field_5a04e1d7362f5'),
(577, 63, '_landing_page', ''),
(578, 63, '__landing_page', 'field_5b4158c76e7dd'),
(579, 64, 'icon_type', 'icon'),
(580, 64, '_icon_type', 'field_5a32118560854'),
(581, 64, 'icon', 'fa fa-smoking-ban'),
(582, 64, '_icon', 'field_595b74be15f19'),
(583, 64, 'color', ''),
(584, 64, '_color', 'field_595b74f315f1a'),
(585, 64, 'text_color', ''),
(586, 64, '_text_color', 'field_595b750215f1b'),
(587, 64, 'image', ''),
(588, 64, '_image', 'field_595b751015f1c'),
(589, 64, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(590, 64, '_listing_type', 'field_5a04e1d7362f5'),
(591, 64, '_landing_page', ''),
(592, 64, '__landing_page', 'field_5b4158c76e7dd'),
(593, 65, 'icon_type', 'icon'),
(594, 65, '_icon_type', 'field_5a32118560854'),
(595, 65, 'icon', 'fa fa-smoking'),
(596, 65, '_icon', 'field_595b74be15f19'),
(597, 65, 'color', ''),
(598, 65, '_color', 'field_595b74f315f1a'),
(599, 65, 'text_color', ''),
(600, 65, '_text_color', 'field_595b750215f1b'),
(601, 65, 'image', ''),
(602, 65, '_image', 'field_595b751015f1c'),
(603, 65, 'listing_type', ''),
(604, 65, '_listing_type', 'field_5a04e1d7362f5'),
(605, 65, '_landing_page', ''),
(606, 65, '__landing_page', 'field_5b4158c76e7dd'),
(607, 66, 'icon_type', 'icon'),
(608, 66, '_icon_type', 'field_5a32118560854'),
(609, 66, 'icon', 'fa fa-toilet'),
(610, 66, '_icon', 'field_595b74be15f19'),
(611, 66, 'color', ''),
(612, 66, '_color', 'field_595b74f315f1a'),
(613, 66, 'text_color', ''),
(614, 66, '_text_color', 'field_595b750215f1b'),
(615, 66, 'image', ''),
(616, 66, '_image', 'field_595b751015f1c'),
(617, 66, 'listing_type', 'a:2:{i:0;s:4:\"3564\";i:1;s:4:\"3562\";}'),
(618, 66, '_listing_type', 'field_5a04e1d7362f5'),
(619, 66, '_landing_page', ''),
(620, 66, '__landing_page', 'field_5b4158c76e7dd'),
(621, 67, 'icon_type', 'icon'),
(622, 67, '_icon_type', 'field_5a32118560854'),
(623, 67, 'icon', 'fa fa-wine-bottle'),
(624, 67, '_icon', 'field_595b74be15f19'),
(625, 67, 'color', ''),
(626, 67, '_color', 'field_595b74f315f1a'),
(627, 67, 'text_color', ''),
(628, 67, '_text_color', 'field_595b750215f1b'),
(629, 67, 'image', ''),
(630, 67, '_image', 'field_595b751015f1c'),
(631, 67, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(632, 67, '_listing_type', 'field_5a04e1d7362f5'),
(633, 67, '_landing_page', ''),
(634, 67, '__landing_page', 'field_5b4158c76e7dd'),
(635, 68, 'icon_type', 'icon'),
(636, 68, '_icon_type', 'field_5a32118560854'),
(637, 68, 'icon', 'fa fa-truck'),
(638, 68, '_icon', 'field_595b74be15f19'),
(639, 68, 'color', ''),
(640, 68, '_color', 'field_595b74f315f1a'),
(641, 68, 'text_color', ''),
(642, 68, '_text_color', 'field_595b750215f1b'),
(643, 68, 'image', ''),
(644, 68, '_image', 'field_595b751015f1c'),
(645, 68, 'listing_type', 'a:2:{i:0;s:4:\"3562\";i:1;s:4:\"3564\";}'),
(646, 68, '_listing_type', 'field_5a04e1d7362f5'),
(647, 68, '_landing_page', ''),
(648, 68, '__landing_page', 'field_5b4158c76e7dd'),
(649, 69, 'icon_type', 'icon'),
(650, 69, '_icon_type', 'field_5a32118560854'),
(651, 69, 'icon', 'mi music_note'),
(652, 69, '_icon', 'field_595b74be15f19'),
(653, 69, 'color', ''),
(654, 69, '_color', 'field_595b74f315f1a'),
(655, 69, 'text_color', ''),
(656, 69, '_text_color', 'field_595b750215f1b'),
(657, 69, 'image', ''),
(658, 69, '_image', 'field_595b751015f1c'),
(659, 69, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(660, 69, '_listing_type', 'field_5a04e1d7362f5'),
(661, 69, '_landing_page', ''),
(662, 69, '__landing_page', 'field_5b4158c76e7dd'),
(663, 70, 'auto_update_uri', '-1'),
(664, 71, 'auto_update_uri', '-1'),
(665, 70, 'product_count_product_tag', '1'),
(666, 71, 'product_count_product_tag', '1'),
(667, 56, 'listings_full_count', '{\"overnatningssted\":1,\"place\":2,\"spisested\":3}'),
(668, 57, 'listings_full_count', '{\"overnatningssted\":3,\"place\":2,\"spisested\":3}'),
(669, 63, 'listings_full_count', '{\"spisested\":2}'),
(670, 67, 'listings_full_count', '{\"overnatningssted\":3,\"place\":1,\"spisested\":2}'),
(671, 51, 'listings_full_count', '{\"overnatningssted\":3,\"place\":3,\"spisested\":3}'),
(672, 58, 'listings_full_count', '{\"overnatningssted\":1,\"place\":1,\"spisested\":3}'),
(674, 54, 'listings_full_count', '{\"overnatningssted\":3,\"place\":1,\"spisested\":3}'),
(675, 59, 'listings_full_count', '{\"overnatningssted\":3,\"place\":1,\"spisested\":2}'),
(676, 69, 'listings_full_count', '{\"spisested\":1}'),
(677, 55, 'listings_full_count', '{\"overnatningssted\":3,\"place\":2,\"spisested\":3}'),
(678, 60, 'listings_full_count', '{\"neighborhood\":1,\"overnatningssted\":1,\"place\":3,\"spisested\":3}'),
(679, 64, 'listings_full_count', '{\"overnatningssted\":3,\"place\":2,\"spisested\":3}'),
(680, 53, 'listings_full_count', '{\"overnatningssted\":2,\"place\":1,\"spisested\":1}'),
(682, 66, 'listings_full_count', '{\"neighborhood\":1,\"overnatningssted\":2,\"place\":1,\"spisested\":3}'),
(683, 52, 'listings_full_count', '{\"neighborhood\":1,\"overnatningssted\":3,\"place\":3,\"spisested\":3}'),
(685, 73, 'auto_update_uri', '-1'),
(686, 73, 'product_count_product_tag', '1'),
(687, 74, 'auto_update_uri', '-1'),
(688, 75, 'auto_update_uri', '-1'),
(689, 76, 'auto_update_uri', '-1'),
(690, 74, 'product_count_product_tag', '1'),
(691, 75, 'product_count_product_tag', '1'),
(692, 76, 'product_count_product_tag', '1'),
(694, 78, 'icon_type', 'icon'),
(695, 78, '_icon_type', 'field_5a32118560854'),
(696, 78, 'icon', 'fa fa-utensils'),
(697, 78, '_icon', 'field_595b74be15f19'),
(698, 78, 'color', ''),
(699, 78, '_color', 'field_595b74f315f1a'),
(700, 78, 'text_color', ''),
(701, 78, '_text_color', 'field_595b750215f1b'),
(702, 78, 'image', ''),
(703, 78, '_image', 'field_595b751015f1c'),
(704, 78, 'listing_type', 'a:3:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3564\";}'),
(705, 78, '_listing_type', 'field_5a04e1d7362f5'),
(706, 78, '_landing_page', ''),
(707, 78, '__landing_page', 'field_5b4158c76e7dd'),
(708, 78, 'listings_full_count', '{\"overnatningssted\":3}'),
(709, 79, 'icon_type', 'icon'),
(710, 79, '_icon_type', 'field_5a32118560854'),
(711, 79, 'icon', 'fa fa-spa'),
(712, 79, '_icon', 'field_595b74be15f19'),
(713, 79, 'color', ''),
(714, 79, '_color', 'field_595b74f315f1a'),
(715, 79, 'text_color', ''),
(716, 79, '_text_color', 'field_595b750215f1b'),
(717, 79, 'image', ''),
(718, 79, '_image', 'field_595b751015f1c'),
(719, 79, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:4:\"2015\";i:2;s:3:\"879\";i:3;s:4:\"3564\";}'),
(720, 79, '_listing_type', 'field_5a04e1d7362f5'),
(721, 79, '_landing_page', ''),
(722, 79, '__landing_page', 'field_5b4158c76e7dd'),
(723, 80, 'icon_type', 'icon'),
(724, 80, '_icon_type', 'field_5a32118560854'),
(725, 80, 'icon', 'mi directions_run'),
(726, 80, '_icon', 'field_595b74be15f19'),
(727, 80, 'color', ''),
(728, 80, '_color', 'field_595b74f315f1a'),
(729, 80, 'text_color', ''),
(730, 80, '_text_color', 'field_595b750215f1b'),
(731, 80, 'image', ''),
(732, 80, '_image', 'field_595b751015f1c'),
(733, 80, 'listing_type', 'a:1:{i:0;s:4:\"3564\";}'),
(734, 80, '_listing_type', 'field_5a04e1d7362f5'),
(735, 80, '_landing_page', ''),
(736, 80, '__landing_page', 'field_5b4158c76e7dd'),
(737, 81, 'icon_type', 'icon'),
(738, 81, '_icon_type', 'field_5a32118560854'),
(739, 81, 'icon', 'fa fa-swimmer'),
(740, 81, '_icon', 'field_595b74be15f19'),
(741, 81, 'color', ''),
(742, 81, '_color', 'field_595b74f315f1a'),
(743, 81, 'text_color', ''),
(744, 81, '_text_color', 'field_595b750215f1b'),
(745, 81, 'image', ''),
(746, 81, '_image', 'field_595b751015f1c'),
(747, 81, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:4:\"2015\";i:2;s:3:\"879\";i:3;s:4:\"3564\";}'),
(748, 81, '_listing_type', 'field_5a04e1d7362f5'),
(749, 81, '_landing_page', ''),
(750, 81, '__landing_page', 'field_5b4158c76e7dd'),
(751, 80, 'listings_full_count', '{\"overnatningssted\":2}'),
(752, 81, 'listings_full_count', '{\"overnatningssted\":2}'),
(753, 79, 'listings_full_count', '{\"overnatningssted\":2}'),
(754, 82, 'icon_type', 'icon'),
(755, 82, '_icon_type', 'field_5a32118560854'),
(756, 82, 'icon', 'fa fa-bread-slice'),
(757, 82, '_icon', 'field_595b74be15f19'),
(758, 82, 'color', ''),
(759, 82, '_color', 'field_595b74f315f1a'),
(760, 82, 'text_color', ''),
(761, 82, '_text_color', 'field_595b750215f1b'),
(762, 82, 'image', ''),
(763, 82, '_image', 'field_595b751015f1c'),
(764, 82, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(765, 82, '_listing_type', 'field_5a04e1d7362f5'),
(766, 82, '_landing_page', ''),
(767, 82, '__landing_page', 'field_5b4158c76e7dd'),
(768, 82, 'listings_full_count', '{\"overnatningssted\":2}'),
(769, 83, 'icon_type', 'icon'),
(770, 83, '_icon_type', 'field_5a32118560854'),
(771, 83, 'icon', 'fa fa-coffee'),
(772, 83, '_icon', 'field_595b74be15f19'),
(773, 83, 'color', ''),
(774, 83, '_color', 'field_595b74f315f1a'),
(775, 83, 'text_color', ''),
(776, 83, '_text_color', 'field_595b750215f1b'),
(777, 83, 'image', ''),
(778, 83, '_image', 'field_595b751015f1c'),
(779, 83, 'listing_type', 'a:2:{i:0;s:4:\"3562\";i:1;s:4:\"3564\";}'),
(780, 83, '_listing_type', 'field_5a04e1d7362f5'),
(781, 83, '_landing_page', ''),
(782, 83, '__landing_page', 'field_5b4158c76e7dd'),
(783, 83, 'listings_full_count', '{\"neighborhood\":1,\"overnatningssted\":2}'),
(784, 84, 'icon_type', 'icon'),
(785, 84, '_icon_type', 'field_5a32118560854'),
(786, 84, 'icon', 'mi mic'),
(787, 84, '_icon', 'field_595b74be15f19'),
(788, 84, 'color', ''),
(789, 84, '_color', 'field_595b74f315f1a'),
(790, 84, 'text_color', ''),
(791, 84, '_text_color', 'field_595b750215f1b'),
(792, 84, 'image', ''),
(793, 84, '_image', 'field_595b751015f1c'),
(794, 84, 'listing_type', 'a:2:{i:0;s:4:\"3562\";i:1;s:4:\"3564\";}'),
(795, 84, '_listing_type', 'field_5a04e1d7362f5'),
(796, 84, '_landing_page', ''),
(797, 84, '__landing_page', 'field_5b4158c76e7dd'),
(798, 84, 'listings_full_count', '{\"overnatningssted\":2}'),
(799, 85, 'icon_type', 'icon'),
(800, 85, '_icon_type', 'field_5a32118560854'),
(801, 85, 'icon', 'fa fa-coffee'),
(802, 85, '_icon', 'field_595b74be15f19'),
(803, 85, 'color', ''),
(804, 85, '_color', 'field_595b74f315f1a'),
(805, 85, 'text_color', ''),
(806, 85, '_text_color', 'field_595b750215f1b'),
(807, 85, 'image', '808'),
(808, 85, '_image', 'field_595b751015f1c'),
(809, 85, 'listing_type', 'a:1:{i:0;s:3:\"766\";}'),
(810, 85, '_listing_type', 'field_5a04e1d7362f5'),
(811, 85, '_landing_page', ''),
(812, 85, '__landing_page', 'field_5b4158c76e7dd'),
(813, 85, 'listings_full_count', '{\"restaurant\":1}'),
(815, 86, 'icon_type', 'icon'),
(816, 86, '_icon_type', 'field_5a32118560854'),
(817, 86, 'icon', 'fa fa-glass-cheers'),
(818, 86, '_icon', 'field_595b74be15f19'),
(819, 86, 'color', ''),
(820, 86, '_color', 'field_595b74f315f1a'),
(821, 86, 'text_color', ''),
(822, 86, '_text_color', 'field_595b750215f1b'),
(823, 86, 'image', '770'),
(824, 86, '_image', 'field_595b751015f1c'),
(825, 86, 'listing_type', 'a:1:{i:0;s:3:\"586\";}'),
(826, 86, '_listing_type', 'field_5a04e1d7362f5'),
(827, 86, '_landing_page', ''),
(828, 86, '__landing_page', 'field_5b4158c76e7dd'),
(858, 89, 'icon_type', 'icon'),
(859, 89, '_icon_type', 'field_5a32118560854'),
(860, 89, 'icon', ''),
(861, 89, '_icon', 'field_595b74be15f19'),
(862, 89, 'color', ''),
(863, 89, '_color', 'field_595b74f315f1a'),
(864, 89, 'text_color', ''),
(865, 89, '_text_color', 'field_595b750215f1b'),
(866, 89, 'image', ''),
(867, 89, '_image', 'field_595b751015f1c'),
(868, 89, 'listing_type', ''),
(869, 89, '_listing_type', 'field_5a04e1d7362f5'),
(870, 89, '_landing_page', ''),
(871, 89, '__landing_page', 'field_5b4158c76e7dd'),
(886, 91, 'icon_type', 'icon'),
(887, 91, '_icon_type', 'field_5a32118560854'),
(888, 91, 'icon', ''),
(889, 91, '_icon', 'field_595b74be15f19'),
(890, 91, 'color', ''),
(891, 91, '_color', 'field_595b74f315f1a'),
(892, 91, 'text_color', ''),
(893, 91, '_text_color', 'field_595b750215f1b'),
(894, 91, 'image', ''),
(895, 91, '_image', 'field_595b751015f1c'),
(896, 91, 'listing_type', ''),
(897, 91, '_listing_type', 'field_5a04e1d7362f5'),
(898, 91, '_landing_page', ''),
(899, 91, '__landing_page', 'field_5b4158c76e7dd'),
(914, 93, 'icon_type', 'icon'),
(915, 93, '_icon_type', 'field_5a32118560854'),
(916, 93, 'icon', 'fa fa-microphone'),
(917, 93, '_icon', 'field_595b74be15f19'),
(918, 93, 'color', ''),
(919, 93, '_color', 'field_595b74f315f1a'),
(920, 93, 'text_color', ''),
(921, 93, '_text_color', 'field_595b750215f1b'),
(922, 93, 'image', '844'),
(923, 93, '_image', 'field_595b751015f1c'),
(924, 93, 'listing_type', 'a:1:{i:0;s:3:\"586\";}'),
(925, 93, '_listing_type', 'field_5a04e1d7362f5'),
(926, 93, '_landing_page', ''),
(927, 93, '__landing_page', 'field_5b4158c76e7dd'),
(930, 94, 'icon_type', 'icon'),
(931, 94, '_icon_type', 'field_5a32118560854'),
(932, 94, 'icon', 'fa fa-wheelchair'),
(933, 94, '_icon', 'field_595b74be15f19'),
(934, 94, 'color', ''),
(935, 94, '_color', 'field_595b74f315f1a'),
(936, 94, 'text_color', ''),
(937, 94, '_text_color', 'field_595b750215f1b'),
(938, 94, 'image', ''),
(939, 94, '_image', 'field_595b751015f1c'),
(940, 94, 'listing_type', 'a:2:{i:0;s:4:\"3562\";i:1;s:4:\"3564\";}'),
(941, 94, '_listing_type', 'field_5a04e1d7362f5'),
(942, 94, '_landing_page', ''),
(943, 94, '__landing_page', 'field_5b4158c76e7dd'),
(944, 95, 'icon_type', 'icon'),
(945, 95, '_icon_type', 'field_5a32118560854'),
(946, 95, 'icon', 'fa fa-car-side'),
(947, 95, '_icon', 'field_595b74be15f19'),
(948, 95, 'color', ''),
(949, 95, '_color', 'field_595b74f315f1a'),
(950, 95, 'text_color', ''),
(951, 95, '_text_color', 'field_595b750215f1b'),
(952, 95, 'image', ''),
(953, 95, '_image', 'field_595b751015f1c'),
(954, 95, 'listing_type', 'a:1:{i:0;s:4:\"3562\";}'),
(955, 95, '_listing_type', 'field_5a04e1d7362f5'),
(956, 95, '_landing_page', ''),
(957, 95, '__landing_page', 'field_5b4158c76e7dd'),
(958, 96, 'icon_type', 'icon'),
(959, 96, '_icon_type', 'field_5a32118560854'),
(960, 96, 'icon', 'fa fa-clipboard-list'),
(961, 96, '_icon', 'field_595b74be15f19'),
(962, 96, 'color', ''),
(963, 96, '_color', 'field_595b74f315f1a'),
(964, 96, 'text_color', ''),
(965, 96, '_text_color', 'field_595b750215f1b'),
(966, 96, 'image', ''),
(967, 96, '_image', 'field_595b751015f1c'),
(968, 96, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:3:\"879\";i:2;s:4:\"3562\";i:3;s:4:\"3564\";}'),
(969, 96, '_listing_type', 'field_5a04e1d7362f5'),
(970, 96, '_landing_page', ''),
(971, 96, '__landing_page', 'field_5b4158c76e7dd'),
(974, 98, 'icon_type', 'icon'),
(975, 98, '_icon_type', 'field_5a32118560854'),
(976, 98, 'icon', 'fab fa-airbnb'),
(977, 98, '_icon', 'field_595b74be15f19'),
(978, 98, 'color', ''),
(979, 98, '_color', 'field_595b74f315f1a'),
(980, 98, 'text_color', ''),
(981, 98, '_text_color', 'field_595b750215f1b'),
(982, 98, 'image', '850'),
(983, 98, '_image', 'field_595b751015f1c'),
(984, 98, 'listing_type', 'a:1:{i:0;s:3:\"785\";}'),
(985, 98, '_listing_type', 'field_5a04e1d7362f5'),
(986, 98, '_landing_page', ''),
(987, 98, '__landing_page', 'field_5b4158c76e7dd'),
(988, 99, 'icon_type', 'icon'),
(989, 99, '_icon_type', 'field_5a32118560854'),
(990, 99, 'icon', 'fa fa-tree'),
(991, 99, '_icon', 'field_595b74be15f19'),
(992, 99, 'color', ''),
(993, 99, '_color', 'field_595b74f315f1a'),
(994, 99, 'text_color', ''),
(995, 99, '_text_color', 'field_595b750215f1b'),
(996, 99, 'image', '853'),
(997, 99, '_image', 'field_595b751015f1c'),
(998, 99, 'listing_type', 'a:1:{i:0;s:3:\"785\";}'),
(999, 99, '_listing_type', 'field_5a04e1d7362f5'),
(1000, 99, '_landing_page', ''),
(1001, 99, '__landing_page', 'field_5b4158c76e7dd'),
(1002, 100, 'icon_type', 'icon'),
(1003, 100, '_icon_type', 'field_5a32118560854'),
(1004, 100, 'icon', 'mi local_movies'),
(1005, 100, '_icon', 'field_595b74be15f19'),
(1006, 100, 'color', ''),
(1007, 100, '_color', 'field_595b74f315f1a'),
(1008, 100, 'text_color', ''),
(1009, 100, '_text_color', 'field_595b750215f1b'),
(1010, 100, 'image', '358'),
(1011, 100, '_image', 'field_595b751015f1c'),
(1012, 100, 'listing_type', 'a:1:{i:0;s:3:\"586\";}'),
(1013, 100, '_listing_type', 'field_5a04e1d7362f5'),
(1014, 100, '_landing_page', ''),
(1015, 100, '__landing_page', 'field_5b4158c76e7dd'),
(1016, 101, 'icon_type', 'icon'),
(1017, 101, '_icon_type', 'field_5a32118560854'),
(1018, 101, 'icon', 'fa fa-road'),
(1019, 101, '_icon', 'field_595b74be15f19'),
(1020, 101, 'color', ''),
(1021, 101, '_color', 'field_595b74f315f1a'),
(1022, 101, 'text_color', ''),
(1023, 101, '_text_color', 'field_595b750215f1b'),
(1024, 101, 'image', '856'),
(1025, 101, '_image', 'field_595b751015f1c'),
(1026, 101, 'listing_type', 'a:1:{i:0;s:3:\"586\";}'),
(1027, 101, '_listing_type', 'field_5a04e1d7362f5'),
(1028, 101, '_landing_page', ''),
(1029, 101, '__landing_page', 'field_5b4158c76e7dd'),
(1030, 102, 'icon_type', 'icon'),
(1031, 102, '_icon_type', 'field_5a32118560854'),
(1032, 102, 'icon', 'fa fa-hamburger'),
(1033, 102, '_icon', 'field_595b74be15f19'),
(1034, 102, 'color', ''),
(1035, 102, '_color', 'field_595b74f315f1a'),
(1036, 102, 'text_color', ''),
(1037, 102, '_text_color', 'field_595b750215f1b'),
(1038, 102, 'image', '857'),
(1039, 102, '_image', 'field_595b751015f1c'),
(1040, 102, 'listing_type', 'a:1:{i:0;s:3:\"766\";}'),
(1041, 102, '_listing_type', 'field_5a04e1d7362f5'),
(1042, 102, '_landing_page', ''),
(1043, 102, '__landing_page', 'field_5b4158c76e7dd'),
(1044, 103, 'icon_type', 'icon'),
(1045, 103, '_icon_type', 'field_5a32118560854'),
(1046, 103, 'icon', 'fa fa-pizza-slice'),
(1047, 103, '_icon', 'field_595b74be15f19'),
(1048, 103, 'color', ''),
(1049, 103, '_color', 'field_595b74f315f1a'),
(1050, 103, 'text_color', ''),
(1051, 103, '_text_color', 'field_595b750215f1b'),
(1052, 103, 'image', '858'),
(1053, 103, '_image', 'field_595b751015f1c'),
(1054, 103, 'listing_type', 'a:1:{i:0;s:3:\"766\";}'),
(1055, 103, '_listing_type', 'field_5a04e1d7362f5'),
(1056, 103, '_landing_page', ''),
(1057, 103, '__landing_page', 'field_5b4158c76e7dd'),
(1058, 104, 'icon_type', 'icon'),
(1059, 104, '_icon_type', 'field_5a32118560854'),
(1060, 104, 'icon', 'fa fa-fish'),
(1061, 104, '_icon', 'field_595b74be15f19'),
(1062, 104, 'color', ''),
(1063, 104, '_color', 'field_595b74f315f1a'),
(1064, 104, 'text_color', ''),
(1065, 104, '_text_color', 'field_595b750215f1b'),
(1066, 104, 'image', '859'),
(1067, 104, '_image', 'field_595b751015f1c'),
(1068, 104, 'listing_type', 'a:1:{i:0;s:3:\"766\";}'),
(1069, 104, '_listing_type', 'field_5a04e1d7362f5'),
(1070, 104, '_landing_page', ''),
(1071, 104, '__landing_page', 'field_5b4158c76e7dd'),
(1072, 105, 'icon_type', 'icon'),
(1073, 105, '_icon_type', 'field_5a32118560854'),
(1074, 105, 'icon', 'fa fa-umbrella-beach'),
(1075, 105, '_icon', 'field_595b74be15f19'),
(1076, 105, 'color', ''),
(1077, 105, '_color', 'field_595b74f315f1a'),
(1078, 105, 'text_color', ''),
(1079, 105, '_text_color', 'field_595b750215f1b'),
(1080, 105, 'image', '855'),
(1081, 105, '_image', 'field_595b751015f1c'),
(1082, 105, 'listing_type', 'a:1:{i:0;s:3:\"785\";}'),
(1083, 105, '_listing_type', 'field_5a04e1d7362f5'),
(1084, 105, '_landing_page', ''),
(1085, 105, '__landing_page', 'field_5b4158c76e7dd'),
(1086, 106, 'icon_type', 'icon'),
(1087, 106, '_icon_type', 'field_5a32118560854'),
(1088, 106, 'icon', 'fa fa-bed'),
(1089, 106, '_icon', 'field_595b74be15f19'),
(1090, 106, 'color', ''),
(1091, 106, '_color', 'field_595b74f315f1a'),
(1092, 106, 'text_color', ''),
(1093, 106, '_text_color', 'field_595b750215f1b'),
(1094, 106, 'image', '852'),
(1095, 106, '_image', 'field_595b751015f1c'),
(1096, 106, 'listing_type', 'a:1:{i:0;s:3:\"785\";}'),
(1097, 106, '_listing_type', 'field_5a04e1d7362f5'),
(1098, 106, '_landing_page', ''),
(1099, 106, '__landing_page', 'field_5b4158c76e7dd'),
(1100, 108, 'icon_type', 'icon'),
(1101, 108, '_icon_type', 'field_5a32118560854'),
(1102, 108, 'icon', 'fa fa-tree'),
(1103, 108, '_icon', 'field_595b74be15f19'),
(1104, 108, 'color', ''),
(1105, 108, '_color', 'field_595b74f315f1a'),
(1106, 108, 'text_color', ''),
(1107, 108, '_text_color', 'field_595b750215f1b'),
(1108, 108, 'image', '880'),
(1109, 108, '_image', 'field_595b751015f1c'),
(1110, 108, 'listing_type', 'a:1:{i:0;s:3:\"879\";}'),
(1111, 108, '_listing_type', 'field_5a04e1d7362f5'),
(1112, 108, '_landing_page', ''),
(1113, 108, '__landing_page', 'field_5b4158c76e7dd'),
(1114, 109, 'icon_type', 'icon'),
(1115, 109, '_icon_type', 'field_5a32118560854'),
(1116, 109, 'icon', 'fa fa-store-alt'),
(1117, 109, '_icon', 'field_595b74be15f19'),
(1118, 109, 'color', ''),
(1119, 109, '_color', 'field_595b74f315f1a'),
(1120, 109, 'text_color', ''),
(1121, 109, '_text_color', 'field_595b750215f1b'),
(1122, 109, 'image', '408'),
(1123, 109, '_image', 'field_595b751015f1c'),
(1124, 109, 'listing_type', 'a:1:{i:0;s:3:\"879\";}'),
(1125, 109, '_listing_type', 'field_5a04e1d7362f5'),
(1126, 109, '_landing_page', ''),
(1127, 109, '__landing_page', 'field_5b4158c76e7dd'),
(1128, 110, 'icon_type', 'icon'),
(1129, 110, '_icon_type', 'field_5a32118560854'),
(1130, 110, 'icon', 'mi local_movies'),
(1131, 110, '_icon', 'field_595b74be15f19'),
(1132, 110, 'color', ''),
(1133, 110, '_color', 'field_595b74f315f1a'),
(1134, 110, 'text_color', ''),
(1135, 110, '_text_color', 'field_595b750215f1b'),
(1136, 110, 'image', '886'),
(1137, 110, '_image', 'field_595b751015f1c'),
(1138, 110, 'listing_type', 'a:1:{i:0;s:3:\"879\";}'),
(1139, 110, '_listing_type', 'field_5a04e1d7362f5'),
(1140, 110, '_landing_page', ''),
(1141, 110, '__landing_page', 'field_5b4158c76e7dd'),
(1142, 111, 'icon_type', 'icon'),
(1143, 111, '_icon_type', 'field_5a32118560854'),
(1144, 111, 'icon', 'fa fa-golf-ball'),
(1145, 111, '_icon', 'field_595b74be15f19'),
(1146, 111, 'color', ''),
(1147, 111, '_color', 'field_595b74f315f1a'),
(1148, 111, 'text_color', ''),
(1149, 111, '_text_color', 'field_595b750215f1b'),
(1150, 111, 'image', '887'),
(1151, 111, '_image', 'field_595b751015f1c'),
(1152, 111, 'listing_type', 'a:1:{i:0;s:3:\"879\";}'),
(1153, 111, '_listing_type', 'field_5a04e1d7362f5'),
(1154, 111, '_landing_page', ''),
(1155, 111, '__landing_page', 'field_5b4158c76e7dd'),
(1156, 112, 'icon_type', 'icon'),
(1157, 112, '_icon_type', 'field_5a32118560854'),
(1158, 112, 'icon', 'icon-water-droplet'),
(1159, 112, '_icon', 'field_595b74be15f19'),
(1160, 112, 'color', ''),
(1161, 112, '_color', 'field_595b74f315f1a'),
(1162, 112, 'text_color', ''),
(1163, 112, '_text_color', 'field_595b750215f1b'),
(1164, 112, 'image', '888'),
(1165, 112, '_image', 'field_595b751015f1c'),
(1166, 112, 'listing_type', 'a:1:{i:0;s:3:\"879\";}'),
(1167, 112, '_listing_type', 'field_5a04e1d7362f5'),
(1168, 112, '_landing_page', ''),
(1169, 112, '__landing_page', 'field_5b4158c76e7dd'),
(1170, 109, 'listings_full_count', '{\"place\":1}'),
(1171, 94, 'listings_full_count', '{\"overnatningssted\":1,\"place\":3,\"spisested\":1}'),
(1172, 98, 'listings_full_count', '{\"lodging\":1}'),
(1173, 111, 'listings_full_count', '{\"place\":1}'),
(1174, 91, 'listings_full_count', '{\"overnatningssted\":1,\"place\":1,\"spisested\":1}'),
(1175, 96, 'listings_full_count', '{\"overnatningssted\":1,\"place\":1}'),
(1176, 108, 'listings_full_count', '{\"place\":1}'),
(1177, 89, 'listings_full_count', '{\"overnatningssted\":1,\"place\":1,\"spisested\":1}'),
(1178, 116, 'icon_type', 'icon'),
(1179, 116, '_icon_type', 'field_5a32118560854'),
(1180, 116, 'icon', ''),
(1181, 116, '_icon', 'field_595b74be15f19'),
(1182, 116, 'color', ''),
(1183, 116, '_color', 'field_595b74f315f1a'),
(1184, 116, 'text_color', ''),
(1185, 116, '_text_color', 'field_595b750215f1b'),
(1186, 116, 'image', ''),
(1187, 116, '_image', 'field_595b751015f1c'),
(1188, 116, 'listing_type', ''),
(1189, 116, '_listing_type', 'field_5a04e1d7362f5'),
(1190, 116, '_landing_page', ''),
(1191, 116, '__landing_page', 'field_5b4158c76e7dd'),
(1192, 117, 'icon_type', 'icon'),
(1193, 117, '_icon_type', 'field_5a32118560854'),
(1194, 117, 'icon', ''),
(1195, 117, '_icon', 'field_595b74be15f19'),
(1196, 117, 'color', ''),
(1197, 117, '_color', 'field_595b74f315f1a'),
(1198, 117, 'text_color', ''),
(1199, 117, '_text_color', 'field_595b750215f1b'),
(1200, 117, 'image', ''),
(1201, 117, '_image', 'field_595b751015f1c'),
(1202, 117, 'listing_type', ''),
(1203, 117, '_listing_type', 'field_5a04e1d7362f5'),
(1204, 117, '_landing_page', ''),
(1205, 117, '__landing_page', 'field_5b4158c76e7dd'),
(1206, 118, 'icon_type', 'icon'),
(1207, 118, '_icon_type', 'field_5a32118560854'),
(1208, 118, 'icon', ''),
(1209, 118, '_icon', 'field_595b74be15f19'),
(1210, 118, 'color', ''),
(1211, 118, '_color', 'field_595b74f315f1a'),
(1212, 118, 'text_color', ''),
(1213, 118, '_text_color', 'field_595b750215f1b'),
(1214, 118, 'image', ''),
(1215, 118, '_image', 'field_595b751015f1c'),
(1216, 118, 'listing_type', ''),
(1217, 118, '_listing_type', 'field_5a04e1d7362f5'),
(1218, 118, '_landing_page', ''),
(1219, 118, '__landing_page', 'field_5b4158c76e7dd'),
(1220, 121, 'order', '0'),
(1221, 121, 'product_count_product_cat', '0'),
(1222, 121, 'icon_type', 'icon'),
(1223, 121, '_icon_type', 'field_5a32118560854'),
(1224, 121, 'icon', ''),
(1225, 121, '_icon', 'field_595b74be15f19'),
(1226, 121, 'color', ''),
(1227, 121, '_color', 'field_595b74f315f1a'),
(1228, 121, 'text_color', ''),
(1229, 121, '_text_color', 'field_595b750215f1b'),
(1230, 121, 'image', ''),
(1231, 121, '_image', 'field_595b751015f1c'),
(1232, 121, 'listing_type', ''),
(1233, 121, '_listing_type', 'field_5a04e1d7362f5'),
(1234, 121, '_landing_page', ''),
(1235, 121, '__landing_page', 'field_5b4158c76e7dd'),
(1236, 121, 'display_type', ''),
(1237, 121, 'thumbnail_id', '1456'),
(1238, 121, '_seopress_titles_title', ''),
(1239, 121, '_seopress_titles_desc', ''),
(1240, 121, '_seopress_robots_canonical', ''),
(1241, 121, '_seopress_social_fb_title', ''),
(1242, 121, '_seopress_social_fb_desc', ''),
(1243, 121, '_seopress_social_fb_img', ''),
(1244, 121, '_seopress_social_twitter_title', ''),
(1245, 121, '_seopress_social_twitter_desc', ''),
(1246, 121, '_seopress_social_twitter_img', ''),
(1247, 121, '_seopress_redirections_type', '301'),
(1248, 121, '_seopress_redirections_value', ''),
(1249, 15, 'icon_type', 'icon'),
(1250, 15, '_icon_type', 'field_5a32118560854'),
(1251, 15, 'icon', ''),
(1252, 15, '_icon', 'field_595b74be15f19'),
(1253, 15, 'color', ''),
(1254, 15, '_color', 'field_595b74f315f1a'),
(1255, 15, 'text_color', ''),
(1256, 15, '_text_color', 'field_595b750215f1b'),
(1257, 15, 'image', ''),
(1258, 15, '_image', 'field_595b751015f1c'),
(1259, 15, 'listing_type', ''),
(1260, 15, '_listing_type', 'field_5a04e1d7362f5'),
(1261, 15, '_landing_page', ''),
(1262, 15, '__landing_page', 'field_5b4158c76e7dd'),
(1263, 15, 'display_type', ''),
(1264, 15, 'thumbnail_id', '1456'),
(1265, 15, '_seopress_titles_title', ''),
(1266, 15, '_seopress_titles_desc', ''),
(1267, 15, '_seopress_robots_canonical', ''),
(1268, 15, '_seopress_social_fb_title', ''),
(1269, 15, '_seopress_social_fb_desc', ''),
(1270, 15, '_seopress_social_fb_img', ''),
(1271, 15, '_seopress_social_twitter_title', ''),
(1272, 15, '_seopress_social_twitter_desc', ''),
(1273, 15, '_seopress_social_twitter_img', ''),
(1274, 15, '_seopress_redirections_type', '301'),
(1275, 15, '_seopress_redirections_value', ''),
(1277, 103, 'listings_full_count', '{\"restaurant\":1}'),
(1278, 95, 'listings_full_count', '{\"spisested\":1}'),
(1280, 123, 'icon_type', 'icon'),
(1281, 123, '_icon_type', 'field_5a32118560854'),
(1282, 123, 'icon', 'fa fa-city'),
(1283, 123, '_icon', 'field_595b74be15f19'),
(1284, 123, 'color', ''),
(1285, 123, '_color', 'field_595b74f315f1a'),
(1286, 123, 'text_color', ''),
(1287, 123, '_text_color', 'field_595b750215f1b'),
(1288, 123, 'image', '2039'),
(1289, 123, '_image', 'field_595b751015f1c'),
(1290, 123, 'listing_type', 'a:1:{i:0;s:4:\"2015\";}'),
(1291, 123, '_listing_type', 'field_5a04e1d7362f5'),
(1292, 123, '_landing_page', ''),
(1293, 123, '__landing_page', 'field_5b4158c76e7dd'),
(1294, 124, 'icon_type', 'icon'),
(1295, 124, '_icon_type', 'field_5a32118560854'),
(1296, 124, 'icon', 'fa fa-city'),
(1297, 124, '_icon', 'field_595b74be15f19'),
(1298, 124, 'color', ''),
(1299, 124, '_color', 'field_595b74f315f1a'),
(1300, 124, 'text_color', ''),
(1301, 124, '_text_color', 'field_595b750215f1b'),
(1302, 124, 'image', '2038'),
(1303, 124, '_image', 'field_595b751015f1c'),
(1304, 124, 'listing_type', 'a:1:{i:0;s:4:\"2015\";}'),
(1305, 124, '_listing_type', 'field_5a04e1d7362f5'),
(1306, 124, '_landing_page', ''),
(1307, 124, '__landing_page', 'field_5b4158c76e7dd'),
(1308, 125, 'icon_type', 'icon'),
(1309, 125, '_icon_type', 'field_5a32118560854'),
(1310, 125, 'icon', 'fa fa-city'),
(1311, 125, '_icon', 'field_595b74be15f19'),
(1312, 125, 'color', ''),
(1313, 125, '_color', 'field_595b74f315f1a'),
(1314, 125, 'text_color', ''),
(1315, 125, '_text_color', 'field_595b750215f1b'),
(1316, 125, 'image', '2037'),
(1317, 125, '_image', 'field_595b751015f1c'),
(1318, 125, 'listing_type', 'a:1:{i:0;s:4:\"2015\";}'),
(1319, 125, '_listing_type', 'field_5a04e1d7362f5'),
(1320, 125, '_landing_page', ''),
(1321, 125, '__landing_page', 'field_5b4158c76e7dd'),
(1322, 124, '_seopress_titles_title', ''),
(1323, 124, '_seopress_titles_desc', ''),
(1324, 124, '_seopress_robots_breadcrumbs', ''),
(1325, 124, '_seopress_robots_canonical', ''),
(1326, 124, '_seopress_social_fb_title', ''),
(1327, 124, '_seopress_social_fb_desc', ''),
(1328, 124, '_seopress_social_fb_img', ''),
(1329, 124, '_seopress_social_twitter_title', ''),
(1330, 124, '_seopress_social_twitter_desc', ''),
(1331, 124, '_seopress_social_twitter_img', ''),
(1332, 124, '_seopress_redirections_type', '301'),
(1333, 124, '_seopress_redirections_value', ''),
(1334, 123, '_seopress_titles_title', ''),
(1335, 123, '_seopress_titles_desc', ''),
(1336, 123, '_seopress_robots_breadcrumbs', ''),
(1337, 123, '_seopress_robots_canonical', ''),
(1338, 123, '_seopress_social_fb_title', ''),
(1339, 123, '_seopress_social_fb_desc', ''),
(1340, 123, '_seopress_social_fb_img', ''),
(1341, 123, '_seopress_social_twitter_title', ''),
(1342, 123, '_seopress_social_twitter_desc', ''),
(1343, 123, '_seopress_social_twitter_img', ''),
(1344, 123, '_seopress_redirections_type', '301'),
(1345, 123, '_seopress_redirections_value', ''),
(1346, 126, 'icon_type', 'icon'),
(1347, 126, '_icon_type', 'field_5a32118560854'),
(1348, 126, 'icon', 'fa fa-city'),
(1349, 126, '_icon', 'field_595b74be15f19'),
(1350, 126, 'color', ''),
(1351, 126, '_color', 'field_595b74f315f1a'),
(1352, 126, 'text_color', ''),
(1353, 126, '_text_color', 'field_595b750215f1b'),
(1354, 126, 'image', '2036'),
(1355, 126, '_image', 'field_595b751015f1c'),
(1356, 126, 'listing_type', 'a:1:{i:0;s:4:\"2015\";}'),
(1357, 126, '_listing_type', 'field_5a04e1d7362f5'),
(1358, 126, '_landing_page', ''),
(1359, 126, '__landing_page', 'field_5b4158c76e7dd'),
(1360, 127, 'icon_type', 'icon'),
(1361, 127, '_icon_type', 'field_5a32118560854'),
(1362, 127, 'icon', 'mi markunread_mailbox'),
(1363, 127, '_icon', 'field_595b74be15f19'),
(1364, 127, 'color', ''),
(1365, 127, '_color', 'field_595b74f315f1a'),
(1366, 127, 'text_color', ''),
(1367, 127, '_text_color', 'field_595b750215f1b'),
(1368, 127, 'image', ''),
(1369, 127, '_image', 'field_595b751015f1c'),
(1370, 127, 'listing_type', 'a:1:{i:0;s:4:\"2015\";}'),
(1371, 127, '_listing_type', 'field_5a04e1d7362f5'),
(1372, 127, '_landing_page', ''),
(1373, 127, '__landing_page', 'field_5b4158c76e7dd'),
(1374, 128, 'icon_type', 'icon'),
(1375, 128, '_icon_type', 'field_5a32118560854'),
(1376, 128, 'icon', 'fa fa-swimming-pool'),
(1377, 128, '_icon', 'field_595b74be15f19'),
(1378, 128, 'color', ''),
(1379, 128, '_color', 'field_595b74f315f1a'),
(1380, 128, 'text_color', ''),
(1381, 128, '_text_color', 'field_595b750215f1b'),
(1382, 128, 'image', ''),
(1383, 128, '_image', 'field_595b751015f1c'),
(1384, 128, 'listing_type', 'a:4:{i:0;s:3:\"586\";i:1;s:4:\"2015\";i:2;s:3:\"879\";i:3;s:4:\"3564\";}'),
(1385, 128, '_listing_type', 'field_5a04e1d7362f5'),
(1386, 128, '_landing_page', ''),
(1387, 128, '__landing_page', 'field_5b4158c76e7dd'),
(1388, 125, '_seopress_titles_title', ''),
(1389, 125, '_seopress_titles_desc', ''),
(1390, 125, '_seopress_robots_breadcrumbs', ''),
(1391, 125, '_seopress_robots_canonical', ''),
(1392, 125, '_seopress_social_fb_title', ''),
(1393, 125, '_seopress_social_fb_desc', ''),
(1394, 125, '_seopress_social_fb_img', ''),
(1395, 125, '_seopress_social_twitter_title', ''),
(1396, 125, '_seopress_social_twitter_desc', ''),
(1397, 125, '_seopress_social_twitter_img', ''),
(1398, 125, '_seopress_redirections_type', '301'),
(1399, 125, '_seopress_redirections_value', ''),
(1400, 124, 'listings_full_count', '{\"neighborhood\":1}'),
(1401, 127, 'listings_full_count', '{\"neighborhood\":1}'),
(1402, 128, 'listings_full_count', '{\"neighborhood\":1}'),
(1403, 126, '_seopress_titles_title', ''),
(1404, 126, '_seopress_titles_desc', ''),
(1405, 126, '_seopress_robots_breadcrumbs', ''),
(1406, 126, '_seopress_robots_canonical', ''),
(1407, 126, '_seopress_social_fb_title', ''),
(1408, 126, '_seopress_social_fb_desc', ''),
(1409, 126, '_seopress_social_fb_img', ''),
(1410, 126, '_seopress_social_twitter_title', ''),
(1411, 126, '_seopress_social_twitter_desc', ''),
(1412, 126, '_seopress_social_twitter_img', ''),
(1413, 126, '_seopress_redirections_type', '301'),
(1414, 126, '_seopress_redirections_value', ''),
(1415, 106, 'listings_full_count', '{\"overnatningssted\":1}'),
(1416, 56, '_seopress_titles_title', ''),
(1417, 56, '_seopress_titles_desc', ''),
(1418, 56, '_seopress_robots_breadcrumbs', ''),
(1419, 56, '_seopress_robots_canonical', ''),
(1420, 56, '_seopress_social_fb_title', ''),
(1421, 56, '_seopress_social_fb_desc', ''),
(1422, 56, '_seopress_social_fb_img', ''),
(1423, 56, '_seopress_social_twitter_title', ''),
(1424, 56, '_seopress_social_twitter_desc', ''),
(1425, 56, '_seopress_social_twitter_img', ''),
(1426, 56, '_seopress_redirections_type', '301'),
(1427, 56, '_seopress_redirections_value', ''),
(1428, 57, '_seopress_titles_title', ''),
(1429, 57, '_seopress_titles_desc', ''),
(1430, 57, '_seopress_robots_breadcrumbs', ''),
(1431, 57, '_seopress_robots_canonical', ''),
(1432, 57, '_seopress_social_fb_title', ''),
(1433, 57, '_seopress_social_fb_desc', ''),
(1434, 57, '_seopress_social_fb_img', ''),
(1435, 57, '_seopress_social_twitter_title', ''),
(1436, 57, '_seopress_social_twitter_desc', ''),
(1437, 57, '_seopress_social_twitter_img', ''),
(1438, 57, '_seopress_redirections_type', '301'),
(1439, 57, '_seopress_redirections_value', ''),
(1440, 67, '_seopress_titles_title', ''),
(1441, 67, '_seopress_titles_desc', ''),
(1442, 67, '_seopress_robots_breadcrumbs', ''),
(1443, 67, '_seopress_robots_canonical', ''),
(1444, 67, '_seopress_social_fb_title', ''),
(1445, 67, '_seopress_social_fb_desc', ''),
(1446, 67, '_seopress_social_fb_img', ''),
(1447, 67, '_seopress_social_twitter_title', ''),
(1448, 67, '_seopress_social_twitter_desc', ''),
(1449, 67, '_seopress_social_twitter_img', ''),
(1450, 67, '_seopress_redirections_type', '301'),
(1451, 67, '_seopress_redirections_value', ''),
(1452, 51, '_seopress_titles_title', ''),
(1453, 51, '_seopress_titles_desc', ''),
(1454, 51, '_seopress_robots_breadcrumbs', ''),
(1455, 51, '_seopress_robots_canonical', ''),
(1456, 51, '_seopress_social_fb_title', ''),
(1457, 51, '_seopress_social_fb_desc', ''),
(1458, 51, '_seopress_social_fb_img', ''),
(1459, 51, '_seopress_social_twitter_title', ''),
(1460, 51, '_seopress_social_twitter_desc', ''),
(1461, 51, '_seopress_social_twitter_img', ''),
(1462, 51, '_seopress_redirections_type', '301'),
(1463, 51, '_seopress_redirections_value', ''),
(1464, 63, '_seopress_titles_title', ''),
(1465, 63, '_seopress_titles_desc', ''),
(1466, 63, '_seopress_robots_breadcrumbs', ''),
(1467, 63, '_seopress_robots_canonical', ''),
(1468, 63, '_seopress_social_fb_title', ''),
(1469, 63, '_seopress_social_fb_desc', ''),
(1470, 63, '_seopress_social_fb_img', ''),
(1471, 63, '_seopress_social_twitter_title', ''),
(1472, 63, '_seopress_social_twitter_desc', ''),
(1473, 63, '_seopress_social_twitter_img', ''),
(1474, 63, '_seopress_redirections_type', '301'),
(1475, 63, '_seopress_redirections_value', ''),
(1476, 84, '_seopress_titles_title', ''),
(1477, 84, '_seopress_titles_desc', ''),
(1478, 84, '_seopress_robots_breadcrumbs', ''),
(1479, 84, '_seopress_robots_canonical', ''),
(1480, 84, '_seopress_social_fb_title', ''),
(1481, 84, '_seopress_social_fb_desc', ''),
(1482, 84, '_seopress_social_fb_img', ''),
(1483, 84, '_seopress_social_twitter_title', ''),
(1484, 84, '_seopress_social_twitter_desc', ''),
(1485, 84, '_seopress_social_twitter_img', ''),
(1486, 84, '_seopress_redirections_type', '301'),
(1487, 84, '_seopress_redirections_value', ''),
(1488, 58, '_seopress_titles_title', ''),
(1489, 58, '_seopress_titles_desc', ''),
(1490, 58, '_seopress_robots_breadcrumbs', ''),
(1491, 58, '_seopress_robots_canonical', ''),
(1492, 58, '_seopress_social_fb_title', ''),
(1493, 58, '_seopress_social_fb_desc', ''),
(1494, 58, '_seopress_social_fb_img', ''),
(1495, 58, '_seopress_social_twitter_title', ''),
(1496, 58, '_seopress_social_twitter_desc', ''),
(1497, 58, '_seopress_social_twitter_img', ''),
(1498, 58, '_seopress_redirections_type', '301'),
(1499, 58, '_seopress_redirections_value', ''),
(1500, 68, '_seopress_titles_title', ''),
(1501, 68, '_seopress_titles_desc', ''),
(1502, 68, '_seopress_robots_breadcrumbs', ''),
(1503, 68, '_seopress_robots_canonical', ''),
(1504, 68, '_seopress_social_fb_title', ''),
(1505, 68, '_seopress_social_fb_desc', ''),
(1506, 68, '_seopress_social_fb_img', ''),
(1507, 68, '_seopress_social_twitter_title', ''),
(1508, 68, '_seopress_social_twitter_desc', ''),
(1509, 68, '_seopress_social_twitter_img', ''),
(1510, 68, '_seopress_redirections_type', '301'),
(1511, 68, '_seopress_redirections_value', ''),
(1512, 82, '_seopress_titles_title', ''),
(1513, 82, '_seopress_titles_desc', ''),
(1514, 82, '_seopress_robots_breadcrumbs', ''),
(1515, 82, '_seopress_robots_canonical', ''),
(1516, 82, '_seopress_social_fb_title', ''),
(1517, 82, '_seopress_social_fb_desc', ''),
(1518, 82, '_seopress_social_fb_img', ''),
(1519, 82, '_seopress_social_twitter_title', ''),
(1520, 82, '_seopress_social_twitter_desc', ''),
(1521, 82, '_seopress_social_twitter_img', ''),
(1522, 82, '_seopress_redirections_type', '301'),
(1523, 82, '_seopress_redirections_value', ''),
(1524, 54, '_seopress_titles_title', ''),
(1525, 54, '_seopress_titles_desc', ''),
(1526, 54, '_seopress_robots_breadcrumbs', ''),
(1527, 54, '_seopress_robots_canonical', ''),
(1528, 54, '_seopress_social_fb_title', ''),
(1529, 54, '_seopress_social_fb_desc', ''),
(1530, 54, '_seopress_social_fb_img', ''),
(1531, 54, '_seopress_social_twitter_title', ''),
(1532, 54, '_seopress_social_twitter_desc', ''),
(1533, 54, '_seopress_social_twitter_img', ''),
(1534, 54, '_seopress_redirections_type', '301'),
(1535, 54, '_seopress_redirections_value', ''),
(1536, 59, '_seopress_titles_title', ''),
(1537, 59, '_seopress_titles_desc', ''),
(1538, 59, '_seopress_robots_breadcrumbs', ''),
(1539, 59, '_seopress_robots_canonical', ''),
(1540, 59, '_seopress_social_fb_title', ''),
(1541, 59, '_seopress_social_fb_desc', ''),
(1542, 59, '_seopress_social_fb_img', ''),
(1543, 59, '_seopress_social_twitter_title', ''),
(1544, 59, '_seopress_social_twitter_desc', ''),
(1545, 59, '_seopress_social_twitter_img', ''),
(1546, 59, '_seopress_redirections_type', '301'),
(1547, 59, '_seopress_redirections_value', ''),
(1548, 69, '_seopress_titles_title', ''),
(1549, 69, '_seopress_titles_desc', ''),
(1550, 69, '_seopress_robots_breadcrumbs', ''),
(1551, 69, '_seopress_robots_canonical', ''),
(1552, 69, '_seopress_social_fb_title', ''),
(1553, 69, '_seopress_social_fb_desc', ''),
(1554, 69, '_seopress_social_fb_img', ''),
(1555, 69, '_seopress_social_twitter_title', ''),
(1556, 69, '_seopress_social_twitter_desc', ''),
(1557, 69, '_seopress_social_twitter_img', ''),
(1558, 69, '_seopress_redirections_type', '301'),
(1559, 69, '_seopress_redirections_value', ''),
(1560, 55, '_seopress_titles_title', ''),
(1561, 55, '_seopress_titles_desc', ''),
(1562, 55, '_seopress_robots_breadcrumbs', ''),
(1563, 55, '_seopress_robots_canonical', ''),
(1564, 55, '_seopress_social_fb_title', ''),
(1565, 55, '_seopress_social_fb_desc', ''),
(1566, 55, '_seopress_social_fb_img', ''),
(1567, 55, '_seopress_social_twitter_title', ''),
(1568, 55, '_seopress_social_twitter_desc', ''),
(1569, 55, '_seopress_social_twitter_img', ''),
(1570, 55, '_seopress_redirections_type', '301'),
(1571, 55, '_seopress_redirections_value', ''),
(1572, 64, '_seopress_titles_title', ''),
(1573, 64, '_seopress_titles_desc', ''),
(1574, 64, '_seopress_robots_breadcrumbs', ''),
(1575, 64, '_seopress_robots_canonical', ''),
(1576, 64, '_seopress_social_fb_title', ''),
(1577, 64, '_seopress_social_fb_desc', ''),
(1578, 64, '_seopress_social_fb_img', ''),
(1579, 64, '_seopress_social_twitter_title', ''),
(1580, 64, '_seopress_social_twitter_desc', ''),
(1581, 64, '_seopress_social_twitter_img', ''),
(1582, 64, '_seopress_redirections_type', '301'),
(1583, 64, '_seopress_redirections_value', ''),
(1584, 95, '_seopress_titles_title', ''),
(1585, 95, '_seopress_titles_desc', ''),
(1586, 95, '_seopress_robots_breadcrumbs', ''),
(1587, 95, '_seopress_robots_canonical', ''),
(1588, 95, '_seopress_social_fb_title', ''),
(1589, 95, '_seopress_social_fb_desc', ''),
(1590, 95, '_seopress_social_fb_img', ''),
(1591, 95, '_seopress_social_twitter_title', ''),
(1592, 95, '_seopress_social_twitter_desc', ''),
(1593, 95, '_seopress_social_twitter_img', ''),
(1594, 95, '_seopress_redirections_type', '301'),
(1595, 95, '_seopress_redirections_value', ''),
(1596, 78, '_seopress_titles_title', ''),
(1597, 78, '_seopress_titles_desc', ''),
(1598, 78, '_seopress_robots_breadcrumbs', ''),
(1599, 78, '_seopress_robots_canonical', ''),
(1600, 78, '_seopress_social_fb_title', ''),
(1601, 78, '_seopress_social_fb_desc', ''),
(1602, 78, '_seopress_social_fb_img', ''),
(1603, 78, '_seopress_social_twitter_title', ''),
(1604, 78, '_seopress_social_twitter_desc', ''),
(1605, 78, '_seopress_social_twitter_img', ''),
(1606, 78, '_seopress_redirections_type', '301'),
(1607, 78, '_seopress_redirections_value', ''),
(1608, 53, '_seopress_titles_title', ''),
(1609, 53, '_seopress_titles_desc', ''),
(1610, 53, '_seopress_robots_breadcrumbs', ''),
(1611, 53, '_seopress_robots_canonical', '');
INSERT INTO `cchp_termmeta` (`meta_id`, `term_id`, `meta_key`, `meta_value`) VALUES
(1612, 53, '_seopress_social_fb_title', ''),
(1613, 53, '_seopress_social_fb_desc', ''),
(1614, 53, '_seopress_social_fb_img', ''),
(1615, 53, '_seopress_social_twitter_title', ''),
(1616, 53, '_seopress_social_twitter_desc', ''),
(1617, 53, '_seopress_social_twitter_img', ''),
(1618, 53, '_seopress_redirections_type', '301'),
(1619, 53, '_seopress_redirections_value', ''),
(1620, 81, '_seopress_titles_title', ''),
(1621, 81, '_seopress_titles_desc', ''),
(1622, 81, '_seopress_robots_breadcrumbs', ''),
(1623, 81, '_seopress_robots_canonical', ''),
(1624, 81, '_seopress_social_fb_title', ''),
(1625, 81, '_seopress_social_fb_desc', ''),
(1626, 81, '_seopress_social_fb_img', ''),
(1627, 81, '_seopress_social_twitter_title', ''),
(1628, 81, '_seopress_social_twitter_desc', ''),
(1629, 81, '_seopress_social_twitter_img', ''),
(1630, 81, '_seopress_redirections_type', '301'),
(1631, 81, '_seopress_redirections_value', ''),
(1632, 128, '_seopress_titles_title', ''),
(1633, 128, '_seopress_titles_desc', ''),
(1634, 128, '_seopress_robots_breadcrumbs', ''),
(1635, 128, '_seopress_robots_canonical', ''),
(1636, 128, '_seopress_social_fb_title', ''),
(1637, 128, '_seopress_social_fb_desc', ''),
(1638, 128, '_seopress_social_fb_img', ''),
(1639, 128, '_seopress_social_twitter_title', ''),
(1640, 128, '_seopress_social_twitter_desc', ''),
(1641, 128, '_seopress_social_twitter_img', ''),
(1642, 128, '_seopress_redirections_type', '301'),
(1643, 128, '_seopress_redirections_value', ''),
(1644, 96, '_seopress_titles_title', ''),
(1645, 96, '_seopress_titles_desc', ''),
(1646, 96, '_seopress_robots_breadcrumbs', ''),
(1647, 96, '_seopress_robots_canonical', ''),
(1648, 96, '_seopress_social_fb_title', ''),
(1649, 96, '_seopress_social_fb_desc', ''),
(1650, 96, '_seopress_social_fb_img', ''),
(1651, 96, '_seopress_social_twitter_title', ''),
(1652, 96, '_seopress_social_twitter_desc', ''),
(1653, 96, '_seopress_social_twitter_img', ''),
(1654, 96, '_seopress_redirections_type', '301'),
(1655, 96, '_seopress_redirections_value', ''),
(1656, 79, '_seopress_titles_title', ''),
(1657, 79, '_seopress_titles_desc', ''),
(1658, 79, '_seopress_robots_breadcrumbs', ''),
(1659, 79, '_seopress_robots_canonical', ''),
(1660, 79, '_seopress_social_fb_title', ''),
(1661, 79, '_seopress_social_fb_desc', ''),
(1662, 79, '_seopress_social_fb_img', ''),
(1663, 79, '_seopress_social_twitter_title', ''),
(1664, 79, '_seopress_social_twitter_desc', ''),
(1665, 79, '_seopress_social_twitter_img', ''),
(1666, 79, '_seopress_redirections_type', '301'),
(1667, 79, '_seopress_redirections_value', ''),
(1668, 52, '_seopress_titles_title', ''),
(1669, 52, '_seopress_titles_desc', ''),
(1670, 52, '_seopress_robots_breadcrumbs', ''),
(1671, 52, '_seopress_robots_canonical', ''),
(1672, 52, '_seopress_social_fb_title', ''),
(1673, 52, '_seopress_social_fb_desc', ''),
(1674, 52, '_seopress_social_fb_img', ''),
(1675, 52, '_seopress_social_twitter_title', ''),
(1676, 52, '_seopress_social_twitter_desc', ''),
(1677, 52, '_seopress_social_twitter_img', ''),
(1678, 52, '_seopress_redirections_type', '301'),
(1679, 52, '_seopress_redirections_value', ''),
(1680, 66, '_seopress_titles_title', ''),
(1681, 66, '_seopress_titles_desc', ''),
(1682, 66, '_seopress_robots_breadcrumbs', ''),
(1683, 66, '_seopress_robots_canonical', ''),
(1684, 66, '_seopress_social_fb_title', ''),
(1685, 66, '_seopress_social_fb_desc', ''),
(1686, 66, '_seopress_social_fb_img', ''),
(1687, 66, '_seopress_social_twitter_title', ''),
(1688, 66, '_seopress_social_twitter_desc', ''),
(1689, 66, '_seopress_social_twitter_img', ''),
(1690, 66, '_seopress_redirections_type', '301'),
(1691, 66, '_seopress_redirections_value', ''),
(1692, 153, 'happyfiles_position', '0'),
(1693, 151, 'happyfiles_position', '1'),
(1694, 155, 'happyfiles_position', '2'),
(1695, 159, 'happyfiles_position', '3'),
(1696, 157, 'happyfiles_position', '4'),
(1697, 152, 'happyfiles_position', '5'),
(1698, 160, 'happyfiles_position', '6'),
(1699, 154, 'happyfiles_position', '7'),
(1701, 162, 'happyfiles_position', '9'),
(1702, 161, 'happyfiles_position', '10'),
(1703, 156, 'happyfiles_position', '11'),
(1709, 56, '_seopress_social_fb_img_attachment_id', ''),
(1710, 56, '_seopress_social_fb_img_width', ''),
(1711, 56, '_seopress_social_fb_img_height', ''),
(1712, 56, '_seopress_social_twitter_img_attachment_id', ''),
(1713, 56, '_seopress_social_twitter_img_width', ''),
(1714, 56, '_seopress_social_twitter_img_height', ''),
(1715, 56, '_seopress_redirections_logged_status', 'both'),
(1716, 57, '_seopress_social_fb_img_attachment_id', ''),
(1717, 57, '_seopress_social_fb_img_width', ''),
(1718, 57, '_seopress_social_fb_img_height', ''),
(1719, 57, '_seopress_social_twitter_img_attachment_id', ''),
(1720, 57, '_seopress_social_twitter_img_width', ''),
(1721, 57, '_seopress_social_twitter_img_height', ''),
(1722, 57, '_seopress_redirections_logged_status', 'both'),
(1723, 67, '_seopress_social_fb_img_attachment_id', ''),
(1724, 67, '_seopress_social_fb_img_width', ''),
(1725, 67, '_seopress_social_fb_img_height', ''),
(1726, 67, '_seopress_social_twitter_img_attachment_id', ''),
(1727, 67, '_seopress_social_twitter_img_width', ''),
(1728, 67, '_seopress_social_twitter_img_height', ''),
(1729, 67, '_seopress_redirections_logged_status', 'both'),
(1730, 51, '_seopress_social_fb_img_attachment_id', ''),
(1731, 51, '_seopress_social_fb_img_width', ''),
(1732, 51, '_seopress_social_fb_img_height', ''),
(1733, 51, '_seopress_social_twitter_img_attachment_id', ''),
(1734, 51, '_seopress_social_twitter_img_width', ''),
(1735, 51, '_seopress_social_twitter_img_height', ''),
(1736, 51, '_seopress_redirections_logged_status', 'both'),
(1737, 63, '_seopress_social_fb_img_attachment_id', ''),
(1738, 63, '_seopress_social_fb_img_width', ''),
(1739, 63, '_seopress_social_fb_img_height', ''),
(1740, 63, '_seopress_social_twitter_img_attachment_id', ''),
(1741, 63, '_seopress_social_twitter_img_width', ''),
(1742, 63, '_seopress_social_twitter_img_height', ''),
(1743, 63, '_seopress_redirections_logged_status', 'both'),
(1744, 84, '_seopress_social_fb_img_attachment_id', ''),
(1745, 84, '_seopress_social_fb_img_width', ''),
(1746, 84, '_seopress_social_fb_img_height', ''),
(1747, 84, '_seopress_social_twitter_img_attachment_id', ''),
(1748, 84, '_seopress_social_twitter_img_width', ''),
(1749, 84, '_seopress_social_twitter_img_height', ''),
(1750, 84, '_seopress_redirections_logged_status', 'both'),
(1751, 58, '_seopress_social_fb_img_attachment_id', ''),
(1752, 58, '_seopress_social_fb_img_width', ''),
(1753, 58, '_seopress_social_fb_img_height', ''),
(1754, 58, '_seopress_social_twitter_img_attachment_id', ''),
(1755, 58, '_seopress_social_twitter_img_width', ''),
(1756, 58, '_seopress_social_twitter_img_height', ''),
(1757, 58, '_seopress_redirections_logged_status', 'both'),
(1758, 80, '_seopress_titles_title', ''),
(1759, 80, '_seopress_titles_desc', ''),
(1760, 80, '_seopress_robots_breadcrumbs', ''),
(1761, 80, '_seopress_robots_canonical', ''),
(1762, 80, '_seopress_social_fb_title', ''),
(1763, 80, '_seopress_social_fb_desc', ''),
(1764, 80, '_seopress_social_fb_img', ''),
(1765, 80, '_seopress_social_fb_img_attachment_id', ''),
(1766, 80, '_seopress_social_fb_img_width', ''),
(1767, 80, '_seopress_social_fb_img_height', ''),
(1768, 80, '_seopress_social_twitter_title', ''),
(1769, 80, '_seopress_social_twitter_desc', ''),
(1770, 80, '_seopress_social_twitter_img', ''),
(1771, 80, '_seopress_social_twitter_img_attachment_id', ''),
(1772, 80, '_seopress_social_twitter_img_width', ''),
(1773, 80, '_seopress_social_twitter_img_height', ''),
(1774, 80, '_seopress_redirections_type', '301'),
(1775, 80, '_seopress_redirections_logged_status', 'both'),
(1776, 80, '_seopress_redirections_value', ''),
(1777, 68, '_seopress_social_fb_img_attachment_id', ''),
(1778, 68, '_seopress_social_fb_img_width', ''),
(1779, 68, '_seopress_social_fb_img_height', ''),
(1780, 68, '_seopress_social_twitter_img_attachment_id', ''),
(1781, 68, '_seopress_social_twitter_img_width', ''),
(1782, 68, '_seopress_social_twitter_img_height', ''),
(1783, 68, '_seopress_redirections_logged_status', 'both'),
(1784, 82, '_seopress_social_fb_img_attachment_id', ''),
(1785, 82, '_seopress_social_fb_img_width', ''),
(1786, 82, '_seopress_social_fb_img_height', ''),
(1787, 82, '_seopress_social_twitter_img_attachment_id', ''),
(1788, 82, '_seopress_social_twitter_img_width', ''),
(1789, 82, '_seopress_social_twitter_img_height', ''),
(1790, 82, '_seopress_redirections_logged_status', 'both'),
(1791, 54, '_seopress_social_fb_img_attachment_id', ''),
(1792, 54, '_seopress_social_fb_img_width', ''),
(1793, 54, '_seopress_social_fb_img_height', ''),
(1794, 54, '_seopress_social_twitter_img_attachment_id', ''),
(1795, 54, '_seopress_social_twitter_img_width', ''),
(1796, 54, '_seopress_social_twitter_img_height', ''),
(1797, 54, '_seopress_redirections_logged_status', 'both'),
(1798, 59, '_seopress_social_fb_img_attachment_id', ''),
(1799, 59, '_seopress_social_fb_img_width', ''),
(1800, 59, '_seopress_social_fb_img_height', ''),
(1801, 59, '_seopress_social_twitter_img_attachment_id', ''),
(1802, 59, '_seopress_social_twitter_img_width', ''),
(1803, 59, '_seopress_social_twitter_img_height', ''),
(1804, 59, '_seopress_redirections_logged_status', 'both'),
(1805, 69, '_seopress_social_fb_img_attachment_id', ''),
(1806, 69, '_seopress_social_fb_img_width', ''),
(1807, 69, '_seopress_social_fb_img_height', ''),
(1808, 69, '_seopress_social_twitter_img_attachment_id', ''),
(1809, 69, '_seopress_social_twitter_img_width', ''),
(1810, 69, '_seopress_social_twitter_img_height', ''),
(1811, 69, '_seopress_redirections_logged_status', 'both'),
(1812, 55, '_seopress_social_fb_img_attachment_id', ''),
(1813, 55, '_seopress_social_fb_img_width', ''),
(1814, 55, '_seopress_social_fb_img_height', ''),
(1815, 55, '_seopress_social_twitter_img_attachment_id', ''),
(1816, 55, '_seopress_social_twitter_img_width', ''),
(1817, 55, '_seopress_social_twitter_img_height', ''),
(1818, 55, '_seopress_redirections_logged_status', 'both'),
(1819, 60, '_seopress_titles_title', ''),
(1820, 60, '_seopress_titles_desc', ''),
(1821, 60, '_seopress_robots_breadcrumbs', ''),
(1822, 60, '_seopress_robots_canonical', ''),
(1823, 60, '_seopress_social_fb_title', ''),
(1824, 60, '_seopress_social_fb_desc', ''),
(1825, 60, '_seopress_social_fb_img', ''),
(1826, 60, '_seopress_social_fb_img_attachment_id', ''),
(1827, 60, '_seopress_social_fb_img_width', ''),
(1828, 60, '_seopress_social_fb_img_height', ''),
(1829, 60, '_seopress_social_twitter_title', ''),
(1830, 60, '_seopress_social_twitter_desc', ''),
(1831, 60, '_seopress_social_twitter_img', ''),
(1832, 60, '_seopress_social_twitter_img_attachment_id', ''),
(1833, 60, '_seopress_social_twitter_img_width', ''),
(1834, 60, '_seopress_social_twitter_img_height', ''),
(1835, 60, '_seopress_redirections_type', '301'),
(1836, 60, '_seopress_redirections_logged_status', 'both'),
(1837, 60, '_seopress_redirections_value', ''),
(1838, 64, '_seopress_social_fb_img_attachment_id', ''),
(1839, 64, '_seopress_social_fb_img_width', ''),
(1840, 64, '_seopress_social_fb_img_height', ''),
(1841, 64, '_seopress_social_twitter_img_attachment_id', ''),
(1842, 64, '_seopress_social_twitter_img_width', ''),
(1843, 64, '_seopress_social_twitter_img_height', ''),
(1844, 64, '_seopress_redirections_logged_status', 'both'),
(1845, 95, '_seopress_social_fb_img_attachment_id', ''),
(1846, 95, '_seopress_social_fb_img_width', ''),
(1847, 95, '_seopress_social_fb_img_height', ''),
(1848, 95, '_seopress_social_twitter_img_attachment_id', ''),
(1849, 95, '_seopress_social_twitter_img_width', ''),
(1850, 95, '_seopress_social_twitter_img_height', ''),
(1851, 95, '_seopress_redirections_logged_status', 'both'),
(1852, 78, '_seopress_social_fb_img_attachment_id', ''),
(1853, 78, '_seopress_social_fb_img_width', ''),
(1854, 78, '_seopress_social_fb_img_height', ''),
(1855, 78, '_seopress_social_twitter_img_attachment_id', ''),
(1856, 78, '_seopress_social_twitter_img_width', ''),
(1857, 78, '_seopress_social_twitter_img_height', ''),
(1858, 78, '_seopress_redirections_logged_status', 'both'),
(1859, 53, '_seopress_social_fb_img_attachment_id', ''),
(1860, 53, '_seopress_social_fb_img_width', ''),
(1861, 53, '_seopress_social_fb_img_height', ''),
(1862, 53, '_seopress_social_twitter_img_attachment_id', ''),
(1863, 53, '_seopress_social_twitter_img_width', ''),
(1864, 53, '_seopress_social_twitter_img_height', ''),
(1865, 53, '_seopress_redirections_logged_status', 'both'),
(1866, 81, '_seopress_social_fb_img_attachment_id', ''),
(1867, 81, '_seopress_social_fb_img_width', ''),
(1868, 81, '_seopress_social_fb_img_height', ''),
(1869, 81, '_seopress_social_twitter_img_attachment_id', ''),
(1870, 81, '_seopress_social_twitter_img_width', ''),
(1871, 81, '_seopress_social_twitter_img_height', ''),
(1872, 81, '_seopress_redirections_logged_status', 'both'),
(1873, 66, '_seopress_social_fb_img_attachment_id', ''),
(1874, 66, '_seopress_social_fb_img_width', ''),
(1875, 66, '_seopress_social_fb_img_height', ''),
(1876, 66, '_seopress_social_twitter_img_attachment_id', ''),
(1877, 66, '_seopress_social_twitter_img_width', ''),
(1878, 66, '_seopress_social_twitter_img_height', ''),
(1879, 66, '_seopress_redirections_logged_status', 'both'),
(1880, 128, '_seopress_social_fb_img_attachment_id', ''),
(1881, 128, '_seopress_social_fb_img_width', ''),
(1882, 128, '_seopress_social_fb_img_height', ''),
(1883, 128, '_seopress_social_twitter_img_attachment_id', ''),
(1884, 128, '_seopress_social_twitter_img_width', ''),
(1885, 128, '_seopress_social_twitter_img_height', ''),
(1886, 128, '_seopress_redirections_logged_status', 'both'),
(1887, 96, '_seopress_social_fb_img_attachment_id', ''),
(1888, 96, '_seopress_social_fb_img_width', ''),
(1889, 96, '_seopress_social_fb_img_height', ''),
(1890, 96, '_seopress_social_twitter_img_attachment_id', ''),
(1891, 96, '_seopress_social_twitter_img_width', ''),
(1892, 96, '_seopress_social_twitter_img_height', ''),
(1893, 96, '_seopress_redirections_logged_status', 'both'),
(1894, 79, '_seopress_social_fb_img_attachment_id', ''),
(1895, 79, '_seopress_social_fb_img_width', ''),
(1896, 79, '_seopress_social_fb_img_height', ''),
(1897, 79, '_seopress_social_twitter_img_attachment_id', ''),
(1898, 79, '_seopress_social_twitter_img_width', ''),
(1899, 79, '_seopress_social_twitter_img_height', ''),
(1900, 79, '_seopress_redirections_logged_status', 'both'),
(1901, 83, '_seopress_titles_title', ''),
(1902, 83, '_seopress_titles_desc', ''),
(1903, 83, '_seopress_robots_breadcrumbs', ''),
(1904, 83, '_seopress_robots_canonical', ''),
(1905, 83, '_seopress_social_fb_title', ''),
(1906, 83, '_seopress_social_fb_desc', ''),
(1907, 83, '_seopress_social_fb_img', ''),
(1908, 83, '_seopress_social_fb_img_attachment_id', ''),
(1909, 83, '_seopress_social_fb_img_width', ''),
(1910, 83, '_seopress_social_fb_img_height', ''),
(1911, 83, '_seopress_social_twitter_title', ''),
(1912, 83, '_seopress_social_twitter_desc', ''),
(1913, 83, '_seopress_social_twitter_img', ''),
(1914, 83, '_seopress_social_twitter_img_attachment_id', ''),
(1915, 83, '_seopress_social_twitter_img_width', ''),
(1916, 83, '_seopress_social_twitter_img_height', ''),
(1917, 83, '_seopress_redirections_type', '301'),
(1918, 83, '_seopress_redirections_logged_status', 'both'),
(1919, 83, '_seopress_redirections_value', ''),
(1920, 52, '_seopress_social_fb_img_attachment_id', ''),
(1921, 52, '_seopress_social_fb_img_width', ''),
(1922, 52, '_seopress_social_fb_img_height', ''),
(1923, 52, '_seopress_social_twitter_img_attachment_id', ''),
(1924, 52, '_seopress_social_twitter_img_width', ''),
(1925, 52, '_seopress_social_twitter_img_height', ''),
(1926, 52, '_seopress_redirections_logged_status', 'both'),
(1927, 94, '_seopress_titles_title', ''),
(1928, 94, '_seopress_titles_desc', ''),
(1929, 94, '_seopress_robots_breadcrumbs', ''),
(1930, 94, '_seopress_robots_canonical', ''),
(1931, 94, '_seopress_social_fb_title', ''),
(1932, 94, '_seopress_social_fb_desc', ''),
(1933, 94, '_seopress_social_fb_img', ''),
(1934, 94, '_seopress_social_fb_img_attachment_id', ''),
(1935, 94, '_seopress_social_fb_img_width', ''),
(1936, 94, '_seopress_social_fb_img_height', ''),
(1937, 94, '_seopress_social_twitter_title', ''),
(1938, 94, '_seopress_social_twitter_desc', ''),
(1939, 94, '_seopress_social_twitter_img', ''),
(1940, 94, '_seopress_social_twitter_img_attachment_id', ''),
(1941, 94, '_seopress_social_twitter_img_width', ''),
(1942, 94, '_seopress_social_twitter_img_height', ''),
(1943, 94, '_seopress_redirections_type', '301'),
(1944, 94, '_seopress_redirections_logged_status', 'both'),
(1945, 94, '_seopress_redirections_value', '');

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_terms`
--

CREATE TABLE `cchp_terms` (
  `term_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(200) NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_terms`
--

INSERT INTO `cchp_terms` (`term_id`, `name`, `slug`, `term_group`) VALUES
(1, 'Charlotte', 'charlotte', 0),
(2, 'simple', 'simple', 0),
(3, 'grouped', 'grouped', 0),
(4, 'variable', 'variable', 0),
(5, 'external', 'external', 0),
(6, 'exclude-from-search', 'exclude-from-search', 0),
(7, 'exclude-from-catalog', 'exclude-from-catalog', 0),
(8, 'featured', 'featured', 0),
(9, 'outofstock', 'outofstock', 0),
(10, 'rated-1', 'rated-1', 0),
(11, 'rated-2', 'rated-2', 0),
(12, 'rated-3', 'rated-3', 0),
(13, 'rated-4', 'rated-4', 0),
(14, 'rated-5', 'rated-5', 0),
(15, 'Charlotte Store', 'charlotte-store', 0),
(28, 'page', 'page', 0),
(29, 'header', 'header', 0),
(30, 'section', 'section', 0),
(31, 'popup', 'popup', 0),
(32, 'footer', 'footer', 0),
(33, 'subscription', 'subscription', 0),
(34, 'Variable Subscription', 'variable-subscription', 0),
(35, 'job_package_subscription', 'job_package_subscription', 0),
(36, 'Brew Pub', 'brew-pub', 0),
(38, 'Hotel', 'hotel', 0),
(39, 'Concert', 'concert', 0),
(41, 'Ballantyne', 'ballantyne', 0),
(51, 'Bike Parking', 'bike-parking', 0),
(52, 'Street Parking', 'street-parking', 0),
(53, 'Parking Garage', 'parking-garage', 0),
(54, 'Free WiFi', 'free-wifi', 0),
(55, 'Military Discount', 'military-discount', 0),
(56, 'Accepts Apple Pay', 'accepts-apple-pay', 0),
(57, 'Accepts Credit Cards', 'accepts-credit-cards', 0),
(58, 'Dog Friendly', 'dog-friendly', 0),
(59, 'Kid Friendly', 'kid-friendly', 0),
(60, 'Near Train Stop', 'near-train-stop', 0),
(62, 'Personal Seating', 'personal-seating', 0),
(63, 'BYOB', 'byob', 0),
(64, 'Non-Smoking', 'non-smoking', 0),
(65, 'Smoking Permitted', 'smoking-permitted', 0),
(66, 'Public Bathrooms', 'public-bathrooms', 0),
(67, 'Alcohol Served', 'alcohol-served', 0),
(68, 'Food Vendors', 'food-vendors', 0),
(69, 'Live Music', 'live-music', 0),
(70, 'Tee', 'tee', 0),
(71, 'T-Shirt', 't-shirt', 0),
(72, 'product-archive', 'product-archive', 0),
(73, 'Bottle', 'bottle', 0),
(74, 'hat', 'hat', 0),
(75, 'polo', 'polo', 0),
(76, 'shirt', 'shirt', 0),
(77, 'product', 'product', 0),
(78, 'On-Site Restaurant', 'on-site-restaurant', 0),
(79, 'SPA', 'spa', 0),
(80, 'Fitness Center', 'fitness-center', 0),
(81, 'Private Pool', 'private-pool', 0),
(82, 'Free Breakfast', 'free-breakfast', 0),
(83, 'Starbucks Coffee', 'starbucks-coffee', 0),
(84, 'Conference Rooms', 'conference-rooms', 0),
(85, 'Coffee House', 'coffee-house', 0),
(86, 'Happy Hour', 'happy-hour', 0),
(89, 'Dilworth', 'dilworth', 0),
(91, 'NoDA', 'noda', 0),
(93, 'Conference', 'conference', 0),
(94, 'Wheelchair Accessible', 'wheelchair-accessible', 0),
(95, 'Offers Delivery', 'offers-delivery', 0),
(96, 'Reservations', 'reservations', 0),
(97, 'WooCommerce', 'woocommerce', 0),
(98, 'Airbnb', 'airbnb', 0),
(99, 'Cabin', 'cabin', 0),
(100, 'Movie in the Park', 'movie-in-the-park', 0),
(101, 'Street Festival', 'street-festival', 0),
(102, 'Burger Joint', 'burger-joint', 0),
(103, 'Pizza', 'pizza', 0),
(104, 'Seafood', 'seafood', 0),
(105, 'Resort', 'resort', 0),
(106, 'Bed &amp; Breakfast', 'bed-breakfast', 0),
(107, 'single', 'single', 0),
(108, 'Park', 'park', 0),
(109, 'Shop', 'shop', 0),
(110, 'Movie Theater', 'movie-theater', 0),
(111, 'Golf Course', 'golf-course', 0),
(112, 'Water Park', 'water-park', 0),
(113, 'Concert', 'concert', 0),
(114, 'Brew Pub', 'brew-pub', 0),
(115, 'Gutenberg', 'gutenberg', 0),
(116, 'Hotel', 'hotel', 0),
(117, 'Conference', 'conference', 0),
(118, 'Happy Hour', 'happy-hour', 0),
(119, 'archive', 'archive', 0),
(120, 'Elementor', 'elementor', 0),
(121, 'Charlotte Promotions', 'charlotte-promotions', 0),
(122, 'promotion_package', 'promotion_package', 0),
(123, 'Urban Core', 'urban-core', 0),
(124, 'Suburb', 'suburb', 0),
(125, 'Subdivision', 'subdivision', 0),
(126, 'Rural Area', 'rural-area', 0),
(127, 'Post Office', 'post-office', 0),
(128, 'Public Pool', 'public-pool', 0),
(129, 'WP Media Folder Root', 'wp-media-folder-root', 0),
(151, 'Core Website', 'core-website', 0),
(152, 'Listing 101', 'listing-101', 0),
(153, 'Branding', 'branding', 0),
(154, 'Regions', 'regions', 0),
(155, 'DEMOs', 'demos', 0),
(156, 'Testimonials', 'testimonials', 0),
(157, 'How It Works', 'how-it-works', 0),
(159, 'Get Started', 'get-started', 0),
(160, 'Listing Categories', 'listing-categories', 0),
(161, 'Store', 'store', 0),
(162, 'Single Listings', 'single-listings', 0),
(163, 'widget', 'widget', 0),
(164, 'Primary', 'primary', 0);

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_term_relationships`
--

CREATE TABLE `cchp_term_relationships` (
  `object_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `term_order` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_term_relationships`
--

INSERT INTO `cchp_term_relationships` (`object_id`, `term_taxonomy_id`, `term_order`) VALUES
(46, 29, 0),
(50, 29, 0),
(77, 30, 0),
(80, 30, 0),
(92, 31, 0),
(108, 31, 0),
(122, 32, 0),
(138, 30, 0),
(155, 3, 0),
(155, 6, 0),
(155, 7, 0),
(155, 15, 0),
(156, 7, 0),
(156, 15, 0),
(156, 35, 0),
(160, 7, 0),
(160, 15, 0),
(160, 35, 0),
(161, 7, 0),
(161, 15, 0),
(161, 35, 0),
(212, 161, 0),
(301, 151, 0),
(358, 159, 0),
(408, 159, 0),
(413, 159, 0),
(428, 159, 0),
(441, 151, 0),
(453, 32, 0),
(465, 32, 0),
(477, 32, 0),
(493, 31, 0),
(535, 31, 0),
(542, 36, 1),
(542, 41, 1),
(542, 51, 4),
(542, 52, 15),
(542, 53, 13),
(542, 54, 7),
(542, 55, 10),
(542, 56, 1),
(542, 57, 2),
(542, 58, 6),
(542, 59, 8),
(542, 60, 11),
(542, 63, 5),
(542, 64, 12),
(542, 66, 14),
(542, 67, 3),
(542, 69, 9),
(546, 28, 0),
(558, 30, 0),
(563, 30, 0),
(577, 30, 0),
(580, 30, 0),
(583, 51, 3),
(583, 52, 17),
(583, 53, 12),
(583, 54, 7),
(583, 55, 9),
(583, 57, 1),
(583, 59, 8),
(583, 64, 10),
(583, 66, 14),
(583, 67, 2),
(583, 78, 11),
(583, 79, 15),
(583, 80, 5),
(583, 81, 13),
(583, 82, 6),
(583, 83, 16),
(583, 84, 4),
(583, 91, 1),
(583, 98, 1),
(585, 39, 1),
(585, 41, 1),
(585, 51, 4),
(585, 52, 17),
(585, 53, 14),
(585, 54, 8),
(585, 55, 11),
(585, 56, 1),
(585, 57, 2),
(585, 58, 6),
(585, 59, 9),
(585, 60, 12),
(585, 62, 15),
(585, 63, 5),
(585, 64, 13),
(585, 66, 16),
(585, 67, 3),
(585, 68, 7),
(585, 69, 10),
(591, 155, 0),
(592, 155, 0),
(593, 155, 0),
(607, 29, 0),
(613, 29, 0),
(625, 29, 0),
(635, 28, 0),
(652, 162, 0),
(653, 2, 0),
(653, 14, 0),
(653, 15, 0),
(653, 70, 0),
(653, 71, 0),
(654, 161, 0),
(665, 2, 0),
(665, 15, 0),
(665, 73, 0),
(666, 161, 0),
(667, 2, 0),
(667, 15, 0),
(667, 74, 0),
(667, 75, 0),
(667, 76, 0),
(668, 161, 0),
(674, 77, 0),
(682, 77, 0),
(703, 77, 0),
(727, 77, 0),
(745, 72, 0),
(761, 155, 0),
(768, 155, 0),
(769, 155, 0),
(770, 155, 0),
(780, 155, 0),
(784, 155, 0),
(792, 155, 0),
(793, 155, 0),
(794, 155, 0),
(795, 155, 0),
(796, 155, 0),
(797, 155, 0),
(798, 155, 0),
(799, 51, 3),
(799, 52, 11),
(799, 54, 5),
(799, 55, 7),
(799, 56, 1),
(799, 57, 2),
(799, 58, 4),
(799, 59, 6),
(799, 60, 8),
(799, 64, 9),
(799, 66, 10),
(799, 85, 1),
(799, 89, 1),
(800, 155, 0),
(801, 155, 0),
(802, 155, 0),
(803, 155, 0),
(804, 51, 4),
(804, 52, 11),
(804, 54, 6),
(804, 56, 1),
(804, 57, 2),
(804, 58, 5),
(804, 60, 8),
(804, 64, 9),
(804, 66, 10),
(804, 67, 3),
(804, 69, 7),
(804, 86, 1),
(804, 89, 1),
(805, 155, 0),
(806, 155, 0),
(808, 155, 0),
(809, 155, 0),
(810, 41, 1),
(810, 51, 1),
(810, 52, 11),
(810, 53, 8),
(810, 54, 4),
(810, 60, 5),
(810, 64, 6),
(810, 66, 9),
(810, 68, 2),
(810, 78, 7),
(810, 82, 3),
(810, 83, 10),
(810, 93, 1),
(811, 155, 0),
(814, 155, 0),
(815, 155, 0),
(816, 155, 0),
(818, 155, 0),
(825, 29, 0),
(831, 97, 0),
(832, 97, 0),
(833, 97, 0),
(834, 97, 0),
(835, 97, 0),
(836, 97, 0),
(837, 97, 0),
(838, 97, 0),
(842, 38, 1),
(842, 51, 4),
(842, 52, 19),
(842, 53, 14),
(842, 54, 8),
(842, 55, 10),
(842, 56, 1),
(842, 57, 2),
(842, 59, 9),
(842, 60, 11),
(842, 64, 12),
(842, 66, 16),
(842, 67, 3),
(842, 78, 13),
(842, 79, 17),
(842, 80, 6),
(842, 81, 15),
(842, 82, 7),
(842, 83, 18),
(842, 84, 5),
(842, 89, 1),
(843, 155, 0),
(844, 155, 0),
(845, 155, 0),
(846, 155, 0),
(849, 155, 0),
(850, 160, 0),
(852, 160, 0),
(853, 160, 0),
(854, 160, 0),
(855, 160, 0),
(856, 160, 0),
(857, 160, 0),
(858, 160, 0),
(859, 160, 0),
(863, 107, 0),
(864, 153, 0),
(872, 107, 0),
(880, 160, 0),
(886, 160, 0),
(887, 160, 0),
(888, 160, 0),
(891, 41, 1),
(891, 51, 3),
(891, 52, 7),
(891, 55, 4),
(891, 56, 1),
(891, 57, 2),
(891, 60, 5),
(891, 64, 6),
(891, 94, 8),
(891, 109, 1),
(892, 155, 0),
(893, 155, 0),
(894, 155, 0),
(896, 155, 0),
(897, 155, 0),
(898, 51, 4),
(898, 52, 10),
(898, 54, 5),
(898, 55, 6),
(898, 56, 1),
(898, 57, 2),
(898, 60, 7),
(898, 64, 8),
(898, 67, 3),
(898, 91, 1),
(898, 94, 11),
(898, 96, 9),
(898, 111, 1),
(899, 160, 0),
(900, 160, 0),
(902, 155, 0),
(903, 155, 0),
(905, 155, 0),
(907, 159, 0),
(908, 159, 0),
(909, 155, 0),
(910, 155, 0),
(911, 155, 0),
(912, 155, 0),
(917, 51, 1),
(917, 52, 7),
(917, 53, 5),
(917, 58, 2),
(917, 59, 3),
(917, 60, 4),
(917, 66, 6),
(917, 89, 1),
(917, 94, 8),
(917, 108, 1),
(918, 160, 0),
(919, 155, 0),
(920, 155, 0),
(932, 107, 0),
(941, 115, 0),
(941, 116, 0),
(958, 107, 0),
(964, 107, 0),
(966, 151, 0),
(967, 29, 0),
(969, 107, 0),
(998, 107, 0),
(1000, 107, 0),
(1003, 107, 0),
(1040, 107, 0),
(1057, 107, 0),
(1066, 107, 0),
(1076, 107, 0),
(1078, 107, 0),
(1085, 107, 0),
(1087, 107, 0),
(1089, 107, 0),
(1107, 155, 0),
(1108, 155, 0),
(1109, 155, 0),
(1114, 107, 0),
(1157, 107, 0),
(1184, 113, 0),
(1184, 115, 0),
(1198, 153, 0),
(1205, 153, 0),
(1218, 118, 0),
(1218, 120, 0),
(1230, 1, 0),
(1230, 114, 0),
(1230, 120, 0),
(1272, 119, 0),
(1279, 119, 0),
(1291, 119, 0),
(1293, 119, 0),
(1390, 157, 0),
(1403, 157, 0),
(1410, 157, 0),
(1416, 157, 0),
(1429, 157, 0),
(1434, 157, 0),
(1454, 7, 0),
(1454, 121, 0),
(1454, 122, 0),
(1456, 153, 0),
(1457, 7, 0),
(1457, 121, 0),
(1457, 122, 0),
(1458, 7, 0),
(1458, 121, 0),
(1458, 122, 0),
(1464, 157, 0),
(1510, 152, 0),
(1512, 152, 0),
(1513, 152, 0),
(1514, 152, 0),
(1515, 152, 0),
(1516, 152, 0),
(1517, 152, 0),
(1518, 152, 0),
(1519, 152, 0),
(1521, 152, 0),
(1612, 156, 0),
(1615, 156, 0),
(1616, 156, 0),
(1625, 31, 0),
(1728, 119, 0),
(1840, 30, 0),
(1938, 154, 0),
(1968, 154, 0),
(1972, 51, 4),
(1972, 52, 13),
(1972, 54, 7),
(1972, 55, 8),
(1972, 56, 1),
(1972, 57, 2),
(1972, 58, 6),
(1972, 60, 9),
(1972, 63, 5),
(1972, 64, 10),
(1972, 66, 12),
(1972, 67, 3),
(1972, 91, 1),
(1972, 94, 14),
(1972, 95, 11),
(1972, 103, 1),
(1973, 155, 0),
(1974, 155, 0),
(1975, 155, 0),
(1976, 155, 0),
(1977, 155, 0),
(1979, 51, 3),
(1979, 52, 12),
(1979, 57, 1),
(1979, 58, 4),
(1979, 59, 6),
(1979, 60, 8),
(1979, 62, 10),
(1979, 66, 11),
(1979, 67, 2),
(1979, 68, 5),
(1979, 69, 7),
(1979, 78, 9),
(1979, 91, 1),
(1979, 94, 13),
(1979, 101, 1),
(1980, 155, 0),
(1981, 155, 0),
(1982, 155, 0),
(1983, 155, 0),
(1992, 154, 0),
(1997, 155, 0),
(1998, 155, 0),
(1999, 155, 0),
(2003, 107, 0),
(2011, 107, 0),
(2017, 41, 1),
(2017, 52, 6),
(2017, 60, 1),
(2017, 66, 3),
(2017, 83, 5),
(2017, 124, 1),
(2017, 127, 2),
(2017, 128, 4),
(2026, 155, 0),
(2027, 155, 0),
(2028, 155, 0),
(2029, 41, 1),
(2029, 51, 3),
(2029, 52, 11),
(2029, 54, 5),
(2029, 55, 7),
(2029, 57, 1),
(2029, 58, 4),
(2029, 59, 6),
(2029, 64, 8),
(2029, 67, 2),
(2029, 78, 9),
(2029, 94, 12),
(2029, 96, 10),
(2029, 106, 1),
(2030, 155, 0),
(2031, 155, 0),
(2032, 155, 0),
(2033, 155, 0),
(2034, 155, 0),
(2036, 154, 0),
(2037, 154, 0),
(2038, 154, 0),
(2039, 154, 0),
(2048, 154, 0),
(2059, 154, 0),
(2061, 153, 0),
(2070, 153, 0),
(2086, 154, 0),
(2097, 153, 0),
(2099, 154, 0),
(2255, 107, 0),
(2256, 107, 0),
(2276, 107, 0),
(2418, 28, 0),
(2423, 151, 0),
(2424, 28, 0),
(2426, 28, 0),
(2609, 119, 0),
(2630, 28, 0),
(2735, 163, 0),
(2750, 30, 0),
(2771, 28, 0),
(2785, 28, 0),
(2788, 28, 0),
(2792, 28, 0),
(2801, 28, 0),
(2805, 28, 0),
(2812, 28, 0),
(2817, 28, 0),
(2825, 28, 0),
(2831, 28, 0),
(2834, 28, 0),
(2858, 30, 0),
(3024, 28, 0),
(3112, 29, 0),
(3143, 164, 0),
(3144, 164, 0),
(3145, 164, 0),
(3146, 164, 0),
(3147, 164, 0),
(3148, 164, 0),
(3149, 164, 0),
(3295, 29, 0),
(3306, 77, 0),
(3456, 28, 0);

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_term_taxonomy`
--

CREATE TABLE `cchp_term_taxonomy` (
  `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL,
  `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `taxonomy` varchar(32) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `parent` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `count` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_term_taxonomy`
--

INSERT INTO `cchp_term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES
(1, 1, 'category', '', 0, 1),
(2, 2, 'product_type', '', 0, 3),
(3, 3, 'product_type', '', 0, 1),
(4, 4, 'product_type', '', 0, 0),
(5, 5, 'product_type', '', 0, 0),
(6, 6, 'product_visibility', '', 0, 1),
(7, 7, 'product_visibility', '', 0, 7),
(8, 8, 'product_visibility', '', 0, 0),
(9, 9, 'product_visibility', '', 0, 0),
(10, 10, 'product_visibility', '', 0, 0),
(11, 11, 'product_visibility', '', 0, 0),
(12, 12, 'product_visibility', '', 0, 0),
(13, 13, 'product_visibility', '', 0, 0),
(14, 14, 'product_visibility', '', 0, 1),
(15, 15, 'product_cat', '', 0, 7),
(28, 28, 'elementor_library_type', '', 0, 15),
(29, 29, 'elementor_library_type', '', 0, 2),
(30, 30, 'elementor_library_type', '', 0, 6),
(31, 31, 'elementor_library_type', '', 0, 4),
(32, 32, 'elementor_library_type', '', 0, 1),
(33, 33, 'product_type', '', 0, 0),
(34, 34, 'product_type', '', 0, 0),
(35, 35, 'product_type', '', 0, 3),
(36, 36, 'job_listing_category', '', 0, 1),
(38, 38, 'job_listing_category', '', 0, 1),
(39, 39, 'job_listing_category', '', 0, 0),
(41, 41, 'region', '', 0, 4),
(51, 51, 'case27_job_listing_tags', '', 0, 9),
(52, 52, 'case27_job_listing_tags', '', 0, 10),
(53, 53, 'case27_job_listing_tags', '', 0, 4),
(54, 54, 'case27_job_listing_tags', '', 0, 7),
(55, 55, 'case27_job_listing_tags', '', 0, 8),
(56, 56, 'case27_job_listing_tags', '', 0, 6),
(57, 57, 'case27_job_listing_tags', '', 0, 8),
(58, 58, 'case27_job_listing_tags', '', 0, 5),
(59, 59, 'case27_job_listing_tags', '', 0, 6),
(60, 60, 'case27_job_listing_tags', '', 0, 8),
(62, 62, 'case27_job_listing_tags', '', 0, 0),
(63, 63, 'case27_job_listing_tags', '', 0, 2),
(64, 64, 'case27_job_listing_tags', '', 0, 8),
(65, 65, 'case27_job_listing_tags', '', 0, 0),
(66, 66, 'case27_job_listing_tags', '', 0, 7),
(67, 67, 'case27_job_listing_tags', '', 0, 6),
(68, 68, 'case27_job_listing_tags', '', 0, 0),
(69, 69, 'case27_job_listing_tags', '', 0, 1),
(70, 70, 'product_tag', '', 0, 1),
(71, 71, 'product_tag', '', 0, 1),
(72, 72, 'elementor_library_type', '', 0, 1),
(73, 73, 'product_tag', '', 0, 1),
(74, 74, 'product_tag', '', 0, 1),
(75, 75, 'product_tag', '', 0, 1),
(76, 76, 'product_tag', '', 0, 1),
(77, 77, 'elementor_library_type', '', 0, 1),
(78, 78, 'case27_job_listing_tags', '', 0, 3),
(79, 79, 'case27_job_listing_tags', '', 0, 2),
(80, 80, 'case27_job_listing_tags', '', 0, 2),
(81, 81, 'case27_job_listing_tags', '', 0, 2),
(82, 82, 'case27_job_listing_tags', '', 0, 2),
(83, 83, 'case27_job_listing_tags', '', 0, 3),
(84, 84, 'case27_job_listing_tags', '', 0, 2),
(85, 85, 'job_listing_category', '', 0, 1),
(86, 86, 'job_listing_category', '', 0, 0),
(89, 89, 'region', '', 0, 3),
(91, 91, 'region', '', 0, 3),
(93, 93, 'job_listing_category', '', 0, 0),
(94, 94, 'case27_job_listing_tags', '', 0, 5),
(95, 95, 'case27_job_listing_tags', '', 0, 1),
(96, 96, 'case27_job_listing_tags', '', 0, 2),
(97, 97, 'nav_menu', '', 0, 8),
(98, 98, 'job_listing_category', '', 0, 1),
(99, 99, 'job_listing_category', '', 0, 0),
(100, 100, 'job_listing_category', '', 0, 0),
(101, 101, 'job_listing_category', '', 0, 0),
(102, 102, 'job_listing_category', '', 0, 0),
(103, 103, 'job_listing_category', '', 0, 1),
(104, 104, 'job_listing_category', '', 0, 0),
(105, 105, 'job_listing_category', '', 0, 0),
(106, 106, 'job_listing_category', '', 0, 1),
(107, 107, 'elementor_library_type', '', 0, 2),
(108, 108, 'job_listing_category', '', 0, 1),
(109, 109, 'job_listing_category', '', 0, 1),
(110, 110, 'job_listing_category', '', 0, 0),
(111, 111, 'job_listing_category', '', 0, 1),
(112, 112, 'job_listing_category', '', 0, 0),
(113, 113, 'category', '', 0, 1),
(114, 114, 'category', '', 0, 1),
(115, 115, 'post_tag', '', 0, 2),
(116, 116, 'category', '', 0, 1),
(117, 117, 'category', '', 0, 0),
(118, 118, 'category', '', 0, 1),
(119, 119, 'elementor_library_type', '', 0, 1),
(120, 120, 'post_tag', '', 0, 2),
(121, 121, 'product_cat', '', 0, 3),
(122, 122, 'product_type', '', 0, 3),
(123, 123, 'job_listing_category', 'The most common name for living in the heart of a city is “downtown,” but the media have introduced another term, “urban core.”', 0, 0),
(124, 124, 'job_listing_category', 'There are as many different descriptions of the suburbs as there are neighborhoods within them. One thing most can agree on is that the suburbs are located outside of the urban core.', 0, 1),
(125, 125, 'job_listing_category', 'They may be located in the suburbs or near the urban core. Subdivisions typically offer residents amenities and what is offered depends on region, developer, and the price of the homes.', 0, 0),
(126, 126, 'job_listing_category', '', 0, 0),
(127, 127, 'case27_job_listing_tags', '', 0, 1),
(128, 128, 'case27_job_listing_tags', '', 0, 1),
(129, 129, 'wpmf-category', '', 0, 0),
(151, 151, 'happyfiles_category', '', 0, 4),
(152, 152, 'happyfiles_category', '', 0, 10),
(153, 153, 'happyfiles_category', '', 0, 7),
(154, 154, 'happyfiles_category', '', 0, 11),
(155, 155, 'happyfiles_category', '', 0, 71),
(156, 156, 'happyfiles_category', '', 0, 3),
(157, 157, 'happyfiles_category', '', 0, 7),
(159, 159, 'happyfiles_category', '', 0, 6),
(160, 160, 'happyfiles_category', '', 0, 16),
(161, 161, 'happyfiles_category', '', 0, 4),
(162, 162, 'happyfiles_category', '', 0, 1),
(163, 163, 'elementor_library_type', '', 0, 1),
(164, 164, 'nav_menu', '', 0, 7);

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_usermeta`
--

CREATE TABLE `cchp_usermeta` (
  `umeta_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_usermeta`
--

INSERT INTO `cchp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
(56, 3, 'nickname', 'MyListing Club'),
(57, 3, 'first_name', 'MyListing'),
(58, 3, 'last_name', 'Club'),
(60, 3, 'rich_editing', 'true'),
(61, 3, 'syntax_highlighting', 'true'),
(62, 3, 'comment_shortcuts', 'false'),
(63, 3, 'admin_color', 'default'),
(64, 3, 'use_ssl', '0'),
(65, 3, 'show_admin_bar_front', 'false'),
(66, 3, 'locale', ''),
(67, 3, 'cchp_capabilities', 'a:1:{s:13:\"administrator\";b:1;}'),
(68, 3, 'cchp_user_level', '10'),
(69, 3, 'dismissed_wp_pointers', 'theme_editor_notice,plugin_editor_notice'),
(71, 3, 'wc_last_active', '1668729600'),
(73, 3, 'cchp_dashboard_quick_press_last_post_id', '3473'),
(74, 3, 'community-events-location', 'a:1:{s:2:\"ip\";s:21:\"2600:1700:5eb4:4400::\";}'),
(77, 3, '_woocommerce_tracks_anon_id', 'woo:D6cYLGMRef+N9cVXwrxzTPFx'),
(95, 3, 'cchp_elementor_connect_common_data', 'a:6:{s:9:\"client_id\";s:32:\"K691y9c7ts299Lt7VQfvQtszbXFGjyMQ\";s:11:\"auth_secret\";s:32:\"oqHj7tIOICeSMvVy4MSYVViXeuG1vcD6\";s:12:\"access_token\";s:32:\"85hCuOSTwpElxbNeiAbp4nimjpJTGtAT\";s:19:\"access_token_secret\";s:32:\"kOmQF6GeMAoPTydnSYfHU2rf9LFq3fPu\";s:10:\"token_type\";s:6:\"bearer\";s:4:\"user\";O:8:\"stdClass\":1:{s:5:\"email\";s:19:\"ryan@mylisting.club\";}}'),
(96, 3, 'elementor_introduction', 'a:3:{s:19:\"colorPickerDropping\";b:1;s:10:\"rightClick\";b:1;s:13:\"popupSettings\";b:1;}'),
(97, 3, 'billing_first_name', 'MyListing'),
(98, 3, 'billing_last_name', 'Club'),
(99, 3, 'billing_company', ''),
(100, 3, 'billing_address_1', '111 W. First St.'),
(101, 3, 'billing_address_2', ''),
(102, 3, 'billing_city', 'Charlotte'),
(103, 3, 'billing_postcode', '28277'),
(104, 3, 'billing_country', 'US'),
(105, 3, 'billing_state', 'NC'),
(106, 3, 'billing_phone', '111-222-3333'),
(107, 3, 'billing_email', 'mylistingclubstarter@gmail.com'),
(108, 3, 'shipping_first_name', ''),
(109, 3, 'shipping_last_name', ''),
(110, 3, 'shipping_company', ''),
(111, 3, 'shipping_address_1', ''),
(112, 3, 'shipping_address_2', ''),
(113, 3, 'shipping_city', ''),
(114, 3, 'shipping_postcode', ''),
(115, 3, 'shipping_country', ''),
(116, 3, 'shipping_state', ''),
(117, 3, 'last_update', '1638913353'),
(118, 3, 'cchp_user-settings', 'editor=tinymce&libraryContent=browse&urlbutton=none&imgsize=large&advImgDetails=show&posts_list_mode=list'),
(119, 3, 'cchp_user-settings-time', '1657113878'),
(120, 3, 'cchp_media_library_mode', 'list'),
(136, 3, 'closedpostboxes_dashboard', 'a:0:{}'),
(137, 3, 'metaboxhidden_dashboard', 'a:13:{i:0;s:20:\"e-dashboard-overview\";i:1;s:21:\"dashboard_site_health\";i:2;s:18:\"dashboard_activity\";i:3;s:28:\"mylisting_stats_visits_chart\";i:4;s:21:\"mylisting_stats_views\";i:5;s:25:\"mylisting_stats_countries\";i:6;s:25:\"mylisting_stats_platforms\";i:7;s:24:\"mylisting_stats_browsers\";i:8;s:25:\"mylisting_stats_referrers\";i:9;s:36:\"woocommerce_dashboard_recent_reviews\";i:10;s:28:\"woocommerce_dashboard_status\";i:11;s:21:\"dashboard_quick_press\";i:12;s:17:\"dashboard_primary\";}'),
(167, 3, 'closedpostboxes_product', 'a:0:{}'),
(168, 3, 'metaboxhidden_product', 'a:1:{i:0;s:17:\"permalink-manager\";}'),
(176, 3, 'closedpostboxes_case27_listing_type', 'a:0:{}'),
(177, 3, 'metaboxhidden_case27_listing_type', 'a:0:{}'),
(179, 3, '_case27_user_bookmarks', 'a:1:{i:0;i:842;}'),
(181, 3, 'managenav-menuscolumnshidden', 'a:4:{i:0;s:11:\"link-target\";i:1;s:15:\"title-attribute\";i:2;s:3:\"xfn\";i:3;s:11:\"description\";}'),
(182, 3, 'metaboxhidden_nav-menus', 'a:7:{i:0;s:21:\"add-post-type-product\";i:1;s:12:\"add-post_tag\";i:2;s:24:\"add-job_listing_category\";i:3;s:10:\"add-region\";i:4;s:27:\"add-case27_job_listing_tags\";i:5;s:15:\"add-product_cat\";i:6;s:15:\"add-product_tag\";}'),
(185, 3, 'closedpostboxes_job_listing', 'a:0:{}'),
(186, 3, 'metaboxhidden_job_listing', 'a:1:{i:0;s:17:\"permalink-manager\";}'),
(187, 3, 'meta-box-order_job_listing', 'a:4:{s:15:\"acf_after_title\";s:0:\"\";s:4:\"side\";s:160:\"submitdiv,mylisting_expiry_metabox,mylisting_package_metabox,cts_listing_promotion_settings,mylisting_verification_metabox,mylisting_author_metabox,postimagediv\";s:6:\"normal\";s:53:\"job_listing_data,slugdiv,commentstatusdiv,commentsdiv\";s:8:\"advanced\";s:0:\"\";}'),
(188, 3, 'screen_layout_job_listing', '2'),
(189, 3, 'edit_case27_job_listing_tags_per_page', '50'),
(190, 3, 'upload_per_page', '200'),
(191, 3, 'mla_entries_per_page', '200'),
(205, 3, 'closedpostboxes_theme-tools_page_theme-general-settings', 'a:0:{}'),
(206, 3, 'metaboxhidden_theme-tools_page_theme-general-settings', 'a:0:{}'),
(210, 3, 'elementor_admin_notices', 'a:3:{s:16:\"rate_us_feedback\";s:4:\"true\";s:21:\"elementor_dev_promote\";s:4:\"true\";s:20:\"experiment_promotion\";s:4:\"true\";}'),
(212, 3, 'rocketcdn_dismiss_notice', '1'),
(215, 3, 'shipping_method', ''),
(216, 3, 'cchp__stripe_customer_id', 'cus_HNJZiXS2fn5ryX'),
(217, 3, 'paying_customer', '1'),
(219, 3, 'nav_menu_recently_edited', '164'),
(223, 3, 'social_links', 'a:0:{}'),
(226, 3, 'edit_job_listing_per_page', '50'),
(268, 3, 'closedpostboxes_page', 'a:0:{}'),
(269, 3, 'metaboxhidden_page', 'a:0:{}'),
(310, 3, 'happyfiles_category_state', 'a:3:{s:19:\"happyfiles_category\";s:3:\"all\";s:18:\"hf_cat_job_listing\";s:3:\"all\";s:11:\"hf_cat_post\";s:3:\"all\";}'),
(333, 3, 'ignore_code_snippets_survey_message', '1'),
(636, 3, 'edit_elementor_library_per_page', '200'),
(1339, 3, 'description', ''),
(1726, 3, 'dismissed_update_notice', '1'),
(3209, 3, 'users_per_page', '200'),
(3218, 3, 'admin2020_preferences', 'a:3:{s:8:\"darkmode\";s:5:\"false\";s:14:\"screen_options\";s:4:\"true\";s:13:\"menu_collapse\";s:4:\"true\";}'),
(3220, 126, 'nickname', 'ticketgolnet'),
(3221, 126, 'first_name', 'travel'),
(3222, 126, 'last_name', 'gol'),
(3223, 126, 'description', ''),
(3224, 126, 'rich_editing', 'true'),
(3225, 126, 'syntax_highlighting', 'true'),
(3226, 126, 'comment_shortcuts', 'false'),
(3227, 126, 'admin_color', 'fresh'),
(3228, 126, 'use_ssl', '0'),
(3229, 126, 'show_admin_bar_front', 'true'),
(3230, 126, 'locale', ''),
(3231, 126, 'cchp_capabilities', 'a:1:{s:8:\"customer\";b:1;}'),
(3232, 126, 'cchp_user_level', '0'),
(3233, 126, 'dismissed_wp_pointers', ''),
(3235, 126, 'mylisting_google_account_id', 'ticketgolnet@gmail.com'),
(3236, 126, 'mylisting_google_account_name', 'travel gol'),
(3237, 126, 'mylisting_google_account_picture', 'https://lh4.googleusercontent.com/-j1JfW-QHKSI/AAAAAAAAAAI/AAAAAAAAAAA/AMZuucm5b9Bvbyq19ybn-Wu9kW76UXYmJw/s96-c/photo.jpg'),
(3238, 126, 'mylisting_profile_picture', 'google'),
(3239, 126, 'session_tokens', 'a:1:{s:64:\"93d93df8e221c7f5b3c7863c84ddbfc216a478532613dc4ec526f485b324d314\";a:4:{s:10:\"expiration\";i:1607368280;s:2:\"ip\";s:11:\"47.60.47.40\";s:2:\"ua\";s:118:\"Mozilla/5.0 (Linux; Android 8.0.0; AGS2-L09) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36\";s:5:\"login\";i:1607195480;}}'),
(3240, 126, 'wc_last_active', '1607126400'),
(3250, 127, 'nickname', 'codeoga'),
(3251, 127, 'first_name', 'Code'),
(3252, 127, 'last_name', 'Oga'),
(3253, 127, 'description', ''),
(3254, 127, 'rich_editing', 'true'),
(3255, 127, 'syntax_highlighting', 'true'),
(3256, 127, 'comment_shortcuts', 'false'),
(3257, 127, 'admin_color', 'fresh'),
(3258, 127, 'use_ssl', '0'),
(3259, 127, 'show_admin_bar_front', 'true'),
(3260, 127, 'locale', ''),
(3261, 127, 'cchp_capabilities', 'a:1:{s:8:\"customer\";b:1;}'),
(3262, 127, 'cchp_user_level', '0'),
(3264, 127, 'mylisting_google_account_id', 'codeoga@gmail.com'),
(3265, 127, 'mylisting_google_account_name', 'Code Oga'),
(3266, 127, 'mylisting_google_account_picture', 'https://lh3.googleusercontent.com/-gSUrpEomu7c/AAAAAAAAAAI/AAAAAAAAAAA/AMZuucnH2iKRsDZ_DWcv5LQezL3c1d1Cxg/s96-c/photo.jpg'),
(3267, 127, 'mylisting_profile_picture', 'google'),
(3268, 127, 'session_tokens', 'a:1:{s:64:\"b03b2a4375422e622078bd6e91189333946be63b607f955649b59fb232988921\";a:4:{s:10:\"expiration\";i:1607625123;s:2:\"ip\";s:37:\"2601:c3:4281:c540:6c4e:ded7:4f14:6bfe\";s:2:\"ua\";s:120:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36\";s:5:\"login\";i:1607452323;}}'),
(3269, 127, 'wc_last_active', '1607472000'),
(3276, 127, '_order_count', '0'),
(3458, 3, 'rocket_rocketcdn_cta_hidden', '1'),
(4209, 3, 'elementor_preferences', 'a:1:{s:8:\"ui_theme\";s:4:\"dark\";}'),
(4605, 3, 'edit_job_listing_category_per_page', '40'),
(5506, 3, 'session_tokens', 'a:2:{s:64:\"a344b182cb405cb3f8221ce7dcb1871b6d17ce652e1cfc9f11ae8e7d87660e60\";a:4:{s:10:\"expiration\";i:1668973744;s:2:\"ip\";s:39:\"2600:1700:5eb4:4400:c3dc:556c:ed84:f1ba\";s:2:\"ua\";s:111:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36\";s:5:\"login\";i:1668800944;}s:64:\"6c21be639de18da896da32d1ef8d8325cb39c0537c8e6db0edaa86e4fdc8e5aa\";a:4:{s:10:\"expiration\";i:1668974292;s:2:\"ip\";s:39:\"2600:1700:5eb4:4400:c3dc:556c:ed84:f1ba\";s:2:\"ua\";s:111:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36\";s:5:\"login\";i:1668801492;}}'),
(5780, 3, '_wcs_subscription_ids_cache', 'a:0:{}'),
(6812, 3, 'dismissed_download_directories_sync_complete_notice', '1'),
(7037, 3, 'meta-box-order_product', 'a:3:{s:4:\"side\";s:84:\"submitdiv,postimagediv,woocommerce-product-images,product_catdiv,tagsdiv-product_tag\";s:6:\"normal\";s:55:\"woocommerce-product-data,postcustom,slugdiv,postexcerpt\";s:8:\"advanced\";s:0:\"\";}'),
(7213, 279, 'nickname', 'info@wucw.dk'),
(7214, 279, 'first_name', ''),
(7215, 279, 'last_name', ''),
(7216, 279, 'description', ''),
(7217, 279, 'rich_editing', 'true'),
(7218, 279, 'syntax_highlighting', 'true'),
(7219, 279, 'comment_shortcuts', 'false'),
(7220, 279, 'admin_color', 'fresh'),
(7221, 279, 'use_ssl', '0'),
(7222, 279, 'show_admin_bar_front', 'true'),
(7223, 279, 'locale', ''),
(7224, 279, 'cchp_capabilities', 'a:1:{s:13:\"administrator\";b:1;}'),
(7225, 279, 'cchp_user_level', '10'),
(7226, 279, '_wcs_subscription_ids_cache', 'a:0:{}'),
(7227, 279, 'dismissed_wp_pointers', ''),
(7228, 279, 'last_update', '1668801935'),
(7229, 279, 'default_password_nag', ''),
(7230, 279, 'session_tokens', 'a:4:{s:64:\"37d038522cbc8e7e37317b34746d50e6d4ef1c8393d2bd571f7ef3992c8fad24\";a:4:{s:10:\"expiration\";i:1670054050;s:2:\"ip\";s:13:\"178.20.216.31\";s:2:\"ua\";s:45:\"WordPress/6.1.1; https://mainwp1.wpsupport.dk\";s:5:\"login\";i:1669881250;}s:64:\"684314cdc5c9ff36ae438392be1d3dca81e7901dd601f5801122415dfa33287b\";a:4:{s:10:\"expiration\";i:1670167942;s:2:\"ip\";s:13:\"178.20.216.31\";s:2:\"ua\";s:45:\"WordPress/6.1.1; https://mainwp1.wpsupport.dk\";s:5:\"login\";i:1669995142;}s:64:\"f4cc5944a490bde414a73ea7b94bad4226051b223d00f11cbc228969803c317b\";a:4:{s:10:\"expiration\";i:1670167951;s:2:\"ip\";s:13:\"178.20.216.31\";s:2:\"ua\";s:60:\"Mozilla/5.0 (compatible; MainWP/4.3.0.1; +http://mainwp.com)\";s:5:\"login\";i:1669995151;}s:64:\"b0159b012d0976c4a9ed00b7286a3c820f796afed13ef4fd7ba4624fc38e480c\";a:4:{s:10:\"expiration\";i:1670167951;s:2:\"ip\";s:13:\"178.20.216.31\";s:2:\"ua\";s:60:\"Mozilla/5.0 (compatible; MainWP/4.3.0.1; +http://mainwp.com)\";s:5:\"login\";i:1669995151;}}'),
(7231, 279, 'wc_last_active', '1669507200'),
(7233, 279, '_woocommerce_tracks_anon_id', 'woo:odmhpuaV6AWKUVwcGj5h3hZJ'),
(7234, 279, 'cchp_dashboard_quick_press_last_post_id', '3593'),
(7235, 279, '_woocommerce_persistent_cart_1', 'a:1:{s:4:\"cart\";a:0:{}}'),
(7236, 279, 'community-events-location', 'a:1:{s:2:\"ip\";s:10:\"87.60.75.0\";}'),
(7237, 280, 'nickname', 'Spisesteder.dk'),
(7238, 280, 'first_name', ''),
(7239, 280, 'last_name', ''),
(7240, 280, 'description', ''),
(7241, 280, 'rich_editing', 'true'),
(7242, 280, 'syntax_highlighting', 'true'),
(7243, 280, 'comment_shortcuts', 'false'),
(7244, 280, 'admin_color', 'fresh'),
(7245, 280, 'use_ssl', '0'),
(7246, 280, 'show_admin_bar_front', 'true'),
(7247, 280, 'locale', ''),
(7248, 280, 'cchp_capabilities', 'a:1:{s:6:\"editor\";b:1;}'),
(7249, 280, 'cchp_user_level', '7'),
(7250, 280, '_wcs_subscription_ids_cache', 'a:0:{}'),
(7251, 280, 'dismissed_wp_pointers', ''),
(7252, 279, 'elementor_admin_notices', 'a:1:{s:16:\"rate_us_feedback\";s:4:\"true\";}'),
(7253, 279, 'tgmpa_dismissed_notice_case27', '1'),
(7254, 279, 'closedpostboxes_dashboard', 'a:0:{}'),
(7255, 279, 'metaboxhidden_dashboard', 'a:6:{i:0;s:20:\"e-dashboard-overview\";i:1;s:25:\"mylisting_stats_countries\";i:2;s:25:\"mylisting_stats_platforms\";i:3;s:24:\"mylisting_stats_browsers\";i:4;s:21:\"dashboard_quick_press\";i:5;s:17:\"dashboard_primary\";}'),
(7256, 279, 'meta-box-order_dashboard', 'a:4:{s:6:\"normal\";s:211:\"e-dashboard-overview,mylisting_stats_visits_chart,mylisting_stats_views,mylisting_stats_countries,mylisting_stats_platforms,mylisting_stats_browsers,mylisting_stats_referrers,woocommerce_dashboard_recent_reviews\";s:4:\"side\";s:109:\"dashboard_right_now,wpa_dashboard_widget,seopress_ga_dashboard_widget,dashboard_quick_press,dashboard_primary\";s:7:\"column3\";s:40:\"dashboard_site_health,dashboard_activity\";s:7:\"column4\";s:0:\"\";}'),
(7257, 279, 'meta-box-order_product', 'a:3:{s:4:\"side\";s:84:\"submitdiv,postimagediv,woocommerce-product-images,product_catdiv,tagsdiv-product_tag\";s:6:\"normal\";s:55:\"woocommerce-product-data,postcustom,slugdiv,postexcerpt\";s:8:\"advanced\";s:0:\"\";}'),
(7258, 279, 'cchp_user-settings', 'posts_list_mode=list'),
(7259, 279, 'cchp_user-settings-time', '1668979800'),
(7260, 279, 'edit_case27_job_listing_tags_per_page', '200'),
(7261, 279, 'closedpostboxes_job_listing', 'a:0:{}'),
(7262, 279, 'metaboxhidden_job_listing', 'a:3:{i:0;s:17:\"permalink-manager\";i:1;s:20:\"litespeed_meta_boxes\";i:2;s:7:\"slugdiv\";}');

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_users`
--

CREATE TABLE `cchp_users` (
  `ID` bigint(20) UNSIGNED NOT NULL,
  `user_login` varchar(60) NOT NULL DEFAULT '',
  `user_pass` varchar(255) NOT NULL DEFAULT '',
  `user_nicename` varchar(50) NOT NULL DEFAULT '',
  `user_email` varchar(100) NOT NULL DEFAULT '',
  `user_url` varchar(100) NOT NULL DEFAULT '',
  `user_registered` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `user_activation_key` varchar(255) NOT NULL DEFAULT '',
  `user_status` int(11) NOT NULL DEFAULT 0,
  `display_name` varchar(250) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_users`
--

INSERT INTO `cchp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES
(3, 'MyListing Club', '$P$Bk88lhwh0dRr.Ju7caYKrG07h1pQ9X.', 'mylisting-club', 'mylistingclubstarter@gmail.com', '', '2020-04-29 12:12:12', '', 0, 'MyListing Club'),
(279, 'info@wucw.dk', '$P$BToazAtiGdNHVI7yPRFFg.EJPJXoxa/', 'infowucw-dk', 'info@wucw.dk', '', '2022-11-18 20:05:35', '', 0, 'info@wucw.dk'),
(280, 'Spisesteder.dk', '$P$Bj6EAWYsDXw5LDxi7IG8UzFBHtbSZQ0', 'spisesteder-dk', 'info@spisesteder.dk', '', '2022-11-18 21:02:30', '', 0, 'Spisesteder.dk');

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wcs_payment_retries`
--

CREATE TABLE `cchp_wcs_payment_retries` (
  `retry_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `status` varchar(255) NOT NULL,
  `date_gmt` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `rule_raw` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_admin_notes`
--

CREATE TABLE `cchp_wc_admin_notes` (
  `note_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(20) NOT NULL,
  `locale` varchar(20) NOT NULL,
  `title` longtext NOT NULL,
  `content` longtext NOT NULL,
  `icon` varchar(200) NOT NULL DEFAULT 'info',
  `content_data` longtext DEFAULT NULL,
  `status` varchar(200) NOT NULL,
  `source` varchar(200) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `date_reminder` datetime DEFAULT NULL,
  `is_snoozable` tinyint(1) NOT NULL DEFAULT 0,
  `layout` varchar(20) NOT NULL DEFAULT '',
  `image` varchar(200) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0,
  `is_read` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_wc_admin_notes`
--

INSERT INTO `cchp_wc_admin_notes` (`note_id`, `name`, `type`, `locale`, `title`, `content`, `icon`, `content_data`, `status`, `source`, `date_created`, `date_reminder`, `is_snoozable`, `layout`, `image`, `is_deleted`, `is_read`) VALUES
(2, 'wc-admin-wc-helper-connection', 'info', 'en_US', 'Connect to WooCommerce.com', 'Connect to get important product notifications and updates.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2020-03-11 15:43:55', NULL, 0, '', NULL, 0, 1),
(3, 'wc-admin-add-first-product', 'info', 'en_US', 'Add your first product', 'Grow your revenue by adding products to your store. Add products manually, import from a sheet, or migrate from another platform.', 'product', '{}', 'unactioned', 'woocommerce-admin', '2020-03-11 15:44:06', NULL, 0, '', NULL, 0, 1),
(4, 'wc-admin-mobile-app', 'info', 'en_US', 'Install Woo mobile app', 'Install the WooCommerce mobile app to manage orders, receive sales notifications, and view key metrics — wherever you are.', 'phone', '{}', 'unactioned', 'woocommerce-admin', '2020-03-14 09:56:57', NULL, 0, '', NULL, 0, 1),
(6, 'wc-admin-usage-tracking-opt-in', 'info', 'en_US', 'Help WooCommerce improve with usage tracking', 'Gathering usage data allows us to improve WooCommerce. Your store will be considered as we evaluate new features, judge the quality of an update, or determine if an improvement makes sense. You can always visit the <a href=\"https://charlotte.spisesteder.dk/wp-admin/admin.php?page=wc-settings&#038;tab=advanced&#038;section=woocommerce_com\" target=\"_blank\">Settings</a> and choose to stop sharing data. <a href=\"https://woocommerce.com/usage-tracking\" target=\"_blank\">Read more</a> about what data we collect.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2020-03-18 15:45:52', NULL, 0, '', NULL, 0, 1),
(8, 'wc-admin-facebook-extension', 'info', 'en_US', 'Market on Facebook', 'Grow your business by targeting the right people and driving sales with Facebook. You can install this free extension now.', 'thumbs-up', '{}', 'unactioned', 'woocommerce-admin', '2020-05-05 15:44:03', NULL, 0, '', NULL, 0, 1),
(9, 'wc-admin-onboarding-email-marketing', 'info', 'en_US', 'Tips, product updates, and inspiration', 'We\'re here for you — get tips, product updates, and inspiration straight to your mailbox.', 'mail', '{}', 'unactioned', 'woocommerce-admin', '2020-05-09 15:44:04', NULL, 0, '', NULL, 0, 1),
(10, 'wc-admin-woocommerce-payments', 'marketing', 'en_US', 'Prøv det nye betalingssystem', 'Accepter sikre kredit- og debitkort (betalingskort) på dit websted. Administrer transaktioner uden at forlade dit WordPress kontrolpanel. Kun muligt med <strong>WooCommerce Payments</strong>.<br><br>Når du klikker på \"Gå i gang\", accepterer du vores <a href=\"https://wordpress.com/tos/\" target=\"_blank\"> Servicebetingelser </a>', 'credit-card', '{}', 'unactioned', 'woocommerce-admin', '2020-05-17 15:44:07', NULL, 0, 'plain', NULL, 0, 1),
(14, 'wc-admin-store-notice-giving-feedback-2', 'info', 'en_US', 'Give feedback', 'Now that you’ve chosen us as a partner, our goal is to make sure we\'re providing the right tools to meet your needs. We\'re looking forward to having your feedback on the store setup experience so we can improve it in the future.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2020-07-15 15:44:46', NULL, 0, 'plain', '', 0, 1),
(17, 'wc-admin-real-time-order-alerts', 'info', 'en_US', 'Get real-time order alerts anywhere', 'Get notifications about store activity, including new orders and product reviews directly on your mobile devices with the Woo app.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2020-08-19 15:44:08', NULL, 0, 'plain', '', 0, 1),
(18, 'wc-update-db-reminder', 'update', 'en_US', 'Opdatering af WooCommerce database er udført', 'WooCommerce databaseopdatering er færdig. Tak for at du opdaterede til den nyeste version!', 'info', '{}', 'unactioned', 'woocommerce-core', '2021-09-16 15:02:36', NULL, 0, 'plain', '', 0, 1),
(19, 'wc-admin-insight-first-sale', 'survey', 'en_US', 'Did you know?', 'A WooCommerce powered store needs on average 31 days to get the first sale. You\'re on the right track! Do you find this type of insight useful?', 'info', '{}', 'unactioned', 'woocommerce-admin', '2020-08-25 15:44:08', NULL, 0, 'plain', '', 0, 1),
(21, 'ecomm-need-help-setting-up-your-store', 'info', 'en_US', 'Need help setting up your Store?', 'Schedule a free 30-min <a href=\"https://wordpress.com/support/concierge-support/\">quick start session</a> and get help from our specialists. We’re happy to walk through setup steps, show you around the WordPress.com dashboard, troubleshoot any issues you may have, and help you the find the features you need to accomplish your goals for your site.', 'info', '{}', 'pending', 'woocommerce.com', '2020-11-16 00:07:11', NULL, 0, 'plain', '', 0, 1),
(22, 'woocommerce-services', 'info', 'en_US', 'WooCommerce Shipping & Tax', 'WooCommerce Shipping &amp; Tax helps get your store “ready to sell” as quickly as possible. You create your products. We take care of tax calculation, payment processing, and shipping label printing! Learn more about the extension that you just installed.', 'info', '{}', 'pending', 'woocommerce.com', '2020-11-16 00:07:11', NULL, 0, 'plain', '', 0, 1),
(23, 'ecomm-unique-shopping-experience', 'info', 'en_US', 'For a shopping experience as unique as your customers', 'Product Add-Ons allow your customers to personalize products while they’re shopping on your online store. No more follow-up email requests—customers get what they want, before they’re done checking out. Learn more about this extension that comes included in your plan.', 'info', '{}', 'pending', 'woocommerce.com', '2020-11-16 00:07:11', NULL, 0, 'plain', '', 0, 1),
(25, 'wc-admin-manage-orders-on-the-go', 'info', 'en_US', 'Udfør dine indkomne ordre på farten', 'Find ordrer, kundeinfo og udfør refunderinger med et klik med Woo appen.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2020-12-17 15:44:27', NULL, 0, 'plain', '', 0, 1),
(26, 'stripe-apple-pay-marketing-guide-holiday-2020', 'marketing', 'en_US', 'Boost sales with Apple Pay!', 'Now that you accept Apple Pay® with Stripe, you can increase conversion rates by letting your customers know that Apple Pay is available. Here’s a marketing guide to help you get started.', 'info', '{}', 'unactioned', 'woocommerce-gateway-stripe', '2020-12-24 12:11:42', NULL, 0, 'plain', '', 0, 1),
(27, 'wc-admin-new-sales-record', 'info', 'en_US', 'Ny salgsrekord!', 'Juhuu, januar 26, 2021 var din rekorddag for salg! Nettosalg var $65 og slog den tidligere rekord med $20 sat på august 25, 2020.', 'info', '{\"old_record_date\":\"2020-08-25\",\"old_record_amt\":20,\"new_record_date\":\"2021-01-26\",\"new_record_amt\":65}', 'unactioned', 'woocommerce-admin', '2021-01-27 15:44:36', NULL, 0, 'plain', '', 0, 1),
(28, 'wc-admin-performance-on-mobile', 'info', 'en_US', 'Spor din webshops performance på mobil', 'Overvåg dit salg og de bedst sælgende varer med Woo app\'en.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2021-02-15 15:44:37', NULL, 0, 'plain', '', 0, 1),
(29, 'wc-admin-manage-store-activity-from-home-screen', 'info', 'en_US', 'New! Manage your store activity from the Home screen', 'Start your day knowing the next steps you need to take with your orders, products, and customer feedback.<br /><br />Read more about how to use the activity panels on the Home screen.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2021-02-16 15:29:06', NULL, 0, 'plain', '', 0, 1),
(30, 'wc-admin-insight-first-product-and-payment', 'survey', 'en_US', 'Insight', 'More than 80% of new merchants add the first product and have at least one payment method set up during the first week. We\'re here to help your business succeed! Do you find this type of insight useful?', 'info', '{}', 'unactioned', 'woocommerce-admin', '2021-02-16 15:44:27', NULL, 0, 'plain', '', 0, 1),
(31, 'wc-admin-edit-products-on-the-move', 'info', 'en_US', 'Redigér varer undervejs', 'Redigér og opret nye varer fra dine mobile devices med Woo app\'en', 'info', '{}', 'unactioned', 'woocommerce-admin', '2021-05-27 13:02:11', NULL, 0, 'plain', '', 0, 1),
(32, 'wc-refund-returns-page', 'info', 'en_US', 'Setup a Refund and Returns Policy page to boost your store\'s credibility.', 'We have created a sample draft Refund and Returns Policy page for you. Please have a look and update it to fit your store.', 'info', '{}', 'unactioned', 'woocommerce-core', '2021-08-25 14:00:59', NULL, 0, 'plain', '', 0, 0),
(33, 'wc-admin-orders-milestone', 'info', 'en_US', 'Congratulations on processing 10 orders!', 'You\'ve hit the 10 orders milestone! Look at you go. Browse some WooCommerce success stories for inspiration.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2021-11-30 21:44:42', NULL, 0, 'plain', '', 0, 0),
(34, 'wc-admin-update-store-details', 'info', 'en_US', 'Redigér dine webshopinformationer, hvis du har brug for det', 'Godt arbejde med at færdiggøre din webshopprofil. Hvis det bliver nødvendigt, kan du til enhver tid gå tilbage og redigere informationerne, som du netop har delt.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2021-12-21 15:44:55', NULL, 0, 'plain', '', 0, 0),
(35, 'wc-admin-launch-checklist', 'info', 'en_US', 'Klar til at lancere din webshop?', 'For at sikre, at du aldrig får den angstprovokerende \"hvad glemte jeg\" følelse, har vi sammensat den essentielle pre-launch tjekliste.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2022-03-09 15:44:16', NULL, 0, 'plain', '', 0, 0),
(36, 'wc-admin-navigation-nudge', 'info', 'en_US', 'You now have access to the WooCommerce navigation', 'We’re introducing a new navigation for a more intuitive and improved user experience. You can enable the beta version of the new experience in the Advanced Settings. Enable it now for your store.', 'info', '{}', 'unactioned', 'woocommerce-admin', '2022-04-21 15:44:42', NULL, 0, 'plain', '', 0, 0),
(37, 'wc-stripe-upe-availability-note', 'info', 'en_US', 'Boost your sales with the new payment experience in Stripe', 'Get early access to an improved checkout experience, now available to select merchants. <a href=\"https://woocommerce.com/document/stripe/#new-checkout-experience\" target=\"_blank\">Learn more</a>.', 'info', '{}', 'unactioned', 'woocommerce-gateway-stripe', '2022-11-13 12:18:29', NULL, 0, 'plain', '', 0, 0);

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_admin_note_actions`
--

CREATE TABLE `cchp_wc_admin_note_actions` (
  `action_id` bigint(20) UNSIGNED NOT NULL,
  `note_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `query` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `actioned_text` varchar(255) NOT NULL,
  `nonce_action` varchar(255) DEFAULT NULL,
  `nonce_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_wc_admin_note_actions`
--

INSERT INTO `cchp_wc_admin_note_actions` (`action_id`, `note_id`, `name`, `label`, `query`, `status`, `is_primary`, `actioned_text`, `nonce_action`, `nonce_name`) VALUES
(2, 2, 'connect', 'Connect', '?page=wc-addons&section=helper', 'actioned', 0, '', NULL, NULL),
(3, 3, 'add-a-product', 'Add a product', 'https://charlotte.spisesteder.dk/wp-admin/post-new.php?post_type=product', 'actioned', 1, '', NULL, NULL),
(4, 4, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/', 'actioned', 0, '', NULL, NULL),
(7, 6, 'tracking-opt-in', 'Activate usage tracking', '', 'actioned', 1, '', NULL, NULL),
(9, 8, 'learn-more', 'Learn more', 'https://woocommerce.com/products/facebook/', 'unactioned', 0, '', NULL, NULL),
(10, 8, 'install-now', 'Install now', '', 'unactioned', 1, '', NULL, NULL),
(11, 9, 'yes-please', 'Yes please!', 'https://woocommerce.us8.list-manage.com/subscribe/post?u=2c1434dc56f9506bf3c3ecd21&amp;id=13860df971&amp;SIGNUPPAGE=plugin', 'actioned', 0, '', NULL, NULL),
(17, 14, 'share-feedback', 'Share feedback', 'https://automattic.survey.fm/new-onboarding-survey', 'actioned', 0, '', NULL, NULL),
(20, 17, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/?utm_source=inbox', 'actioned', 0, '', NULL, NULL),
(45, 19, 'affirm-insight-first-sale', 'Yes', '', 'actioned', 0, 'Thanks for your feedback', NULL, NULL),
(46, 19, 'deny-insight-first-sale', 'No', '', 'actioned', 0, 'Thanks for your feedback', NULL, NULL),
(1376, 26, 'marketing-guide', 'See marketing guide', 'https://developer.apple.com/apple-pay/marketing/', 'actioned', 0, '', NULL, NULL),
(1743, 29, 'learn-more', 'Learn more', 'https://docs.woocommerce.com/document/home-screen/?utm_source=inbox', 'actioned', 1, '', NULL, NULL),
(1760, 30, 'affirm-insight-first-product-and-payment', 'Yes', '', 'actioned', 0, 'Thanks for your feedback', NULL, NULL),
(2497, 21, 'set-up-concierge', 'Schedule free session', 'https://wordpress.com/me/concierge', 'actioned', 1, '', NULL, NULL),
(2498, 22, 'learn-more', 'Learn more', 'https://docs.woocommerce.com/document/woocommerce-shipping-and-tax/?utm_source=inbox', 'unactioned', 1, '', NULL, NULL),
(2499, 23, 'learn-more-ecomm-unique-shopping-experience', 'Learn more', 'https://docs.woocommerce.com/document/product-add-ons/?utm_source=inbox', 'actioned', 1, '', NULL, NULL),
(2522, 32, 'notify-refund-returns-page', 'Edit page', 'https://charlotte.spisesteder.dk/wp-admin/post.php?post=3231&action=edit', 'actioned', 0, '', NULL, NULL),
(3025, 33, 'browse', 'Browse', 'https://woocommerce.com/success-stories/?utm_source=inbox&utm_medium=product', 'actioned', 0, '', NULL, NULL),
(3436, 36, 'enable-navigation', 'Enable in Settings', 'https://charlotte.spisesteder.dk/wp-admin/admin.php?page=wc-settings&tab=advanced&section=features', 'actioned', 0, '', NULL, NULL),
(3546, 37, 'wc-stripe-upe-availability-note', 'Enable in your store', '?page=wc-settings&tab=checkout&section=stripe&panel=settings&highlight=enable-upe', 'unactioned', 0, '', NULL, NULL),
(3693, 31, 'learn-more', 'Lær mere', 'https://woocommerce.com/mobile/?utm_source=inbox&utm_medium=product', 'actioned', 0, '', NULL, NULL),
(3694, 35, 'learn-more', 'Lær mere', 'https://woocommerce.com/posts/pre-launch-checklist-the-essentials/?utm_source=inbox&utm_medium=product', 'actioned', 0, '', NULL, NULL),
(3695, 25, 'learn-more', 'Lær mere', 'https://woocommerce.com/mobile/?utm_source=inbox&utm_medium=product', 'actioned', 0, '', NULL, NULL),
(3696, 27, 'view-report', 'Se rapport', '?page=wc-admin&path=/analytics/revenue&period=custom&compare=previous_year&after=2021-01-26&before=2021-01-26', 'actioned', 0, '', NULL, NULL),
(3697, 28, 'learn-more', 'Lær mere', 'https://woocommerce.com/mobile/?utm_source=inbox&utm_medium=product', 'actioned', 0, '', NULL, NULL),
(4043, 18, 'update-db_done', 'Mange tak!', 'https://charlotte.spisesteder.dk/wp-admin/plugins.php?_detect_plugins_updates=yes&wc-hide-notice=update', 'actioned', 0, 'woocommerce_hide_notices_nonce', 'woocommerce_hide_notices_nonce', '_wc_notice_nonce'),
(4044, 34, 'update-store-details', 'Opdater webshopinformationer', 'http://charlotte.spisesteder.dk/wp-admin/admin.php?page=wc-admin&path=/setup-wizard', 'actioned', 0, '', NULL, NULL),
(4045, 10, 'learn-more', 'Lær mere', 'https://woocommerce.com/payments/?utm_medium=product', 'unactioned', 0, '', NULL, NULL),
(4046, 10, 'get-started', 'Begynd', 'http://charlotte.spisesteder.dk/wp-admin/admin.php?page=wc-admin&action=setup-woocommerce-payments', 'actioned', 0, '', 'setup-woocommerce-payments', '');

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_category_lookup`
--

CREATE TABLE `cchp_wc_category_lookup` (
  `category_tree_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_wc_category_lookup`
--

INSERT INTO `cchp_wc_category_lookup` (`category_tree_id`, `category_id`) VALUES
(15, 15),
(121, 121);

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_customer_lookup`
--

CREATE TABLE `cchp_wc_customer_lookup` (
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `username` varchar(60) NOT NULL DEFAULT '',
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `date_last_active` timestamp NULL DEFAULT NULL,
  `date_registered` timestamp NULL DEFAULT NULL,
  `country` char(2) NOT NULL DEFAULT '',
  `postcode` varchar(20) NOT NULL DEFAULT '',
  `city` varchar(100) NOT NULL DEFAULT '',
  `state` varchar(100) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_download_log`
--

CREATE TABLE `cchp_wc_download_log` (
  `download_log_id` bigint(20) UNSIGNED NOT NULL,
  `timestamp` datetime NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_ip_address` varchar(100) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_order_coupon_lookup`
--

CREATE TABLE `cchp_wc_order_coupon_lookup` (
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `coupon_id` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `discount_amount` double NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_order_product_lookup`
--

CREATE TABLE `cchp_wc_order_product_lookup` (
  `order_item_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `variation_id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date_created` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `product_qty` int(11) NOT NULL,
  `product_net_revenue` double NOT NULL DEFAULT 0,
  `product_gross_revenue` double NOT NULL DEFAULT 0,
  `coupon_amount` double NOT NULL DEFAULT 0,
  `tax_amount` double NOT NULL DEFAULT 0,
  `shipping_amount` double NOT NULL DEFAULT 0,
  `shipping_tax_amount` double NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_order_stats`
--

CREATE TABLE `cchp_wc_order_stats` (
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `num_items_sold` int(11) NOT NULL DEFAULT 0,
  `total_sales` double NOT NULL DEFAULT 0,
  `tax_total` double NOT NULL DEFAULT 0,
  `shipping_total` double NOT NULL DEFAULT 0,
  `net_total` double NOT NULL DEFAULT 0,
  `returning_customer` tinyint(1) DEFAULT NULL,
  `status` varchar(200) NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_order_tax_lookup`
--

CREATE TABLE `cchp_wc_order_tax_lookup` (
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `tax_rate_id` bigint(20) UNSIGNED NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `shipping_tax` double NOT NULL DEFAULT 0,
  `order_tax` double NOT NULL DEFAULT 0,
  `total_tax` double NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_product_attributes_lookup`
--

CREATE TABLE `cchp_wc_product_attributes_lookup` (
  `product_id` bigint(20) NOT NULL,
  `product_or_parent_id` bigint(20) NOT NULL,
  `taxonomy` varchar(32) NOT NULL,
  `term_id` bigint(20) NOT NULL,
  `is_variation_attribute` tinyint(1) NOT NULL,
  `in_stock` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_product_download_directories`
--

CREATE TABLE `cchp_wc_product_download_directories` (
  `url_id` bigint(20) UNSIGNED NOT NULL,
  `url` varchar(256) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Data dump for tabellen `cchp_wc_product_download_directories`
--

INSERT INTO `cchp_wc_product_download_directories` (`url_id`, `url`, `enabled`) VALUES
(1, 'file:///www/mylistingclubstarter3_203/public/wp-content/uploads/woocommerce_uploads/', 0),
(2, 'https://charlotte.spisesteder.dk/wp-content/uploads/woocommerce_uploads/', 0);

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_product_meta_lookup`
--

CREATE TABLE `cchp_wc_product_meta_lookup` (
  `product_id` bigint(20) NOT NULL,
  `sku` varchar(100) DEFAULT '',
  `virtual` tinyint(1) DEFAULT 0,
  `downloadable` tinyint(1) DEFAULT 0,
  `min_price` decimal(19,4) DEFAULT NULL,
  `max_price` decimal(19,4) DEFAULT NULL,
  `onsale` tinyint(1) DEFAULT 0,
  `stock_quantity` double DEFAULT NULL,
  `stock_status` varchar(100) DEFAULT 'instock',
  `rating_count` bigint(20) DEFAULT 0,
  `average_rating` decimal(3,2) DEFAULT 0.00,
  `total_sales` bigint(20) DEFAULT 0,
  `tax_status` varchar(100) DEFAULT 'taxable',
  `tax_class` varchar(100) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_wc_product_meta_lookup`
--

INSERT INTO `cchp_wc_product_meta_lookup` (`product_id`, `sku`, `virtual`, `downloadable`, `min_price`, `max_price`, `onsale`, `stock_quantity`, `stock_status`, `rating_count`, `average_rating`, `total_sales`, `tax_status`, `tax_class`) VALUES
(155, '', 0, 0, 5.0000, 10.0000, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(156, '', 1, 0, 0.0000, 0.0000, 0, NULL, 'instock', 0, 0.00, 48, 'taxable', ''),
(160, '', 1, 0, 5.0000, 5.0000, 0, NULL, 'instock', 0, 0.00, 13, 'taxable', ''),
(161, '', 1, 0, 10.0000, 10.0000, 0, NULL, 'instock', 0, 0.00, 7, 'taxable', ''),
(653, '', 0, 0, 15.0000, 15.0000, 0, NULL, 'instock', 1, 5.00, 7, 'taxable', ''),
(665, '', 0, 0, 11.0000, 11.0000, 0, NULL, 'instock', 0, 0.00, 6, 'taxable', ''),
(667, '', 0, 0, 28.0000, 28.0000, 0, NULL, 'instock', 0, 0.00, 5, 'taxable', ''),
(1454, '', 1, 0, 5.0000, 5.0000, 0, NULL, 'instock', 0, 0.00, 1, 'taxable', ''),
(1457, '', 1, 0, 10.0000, 10.0000, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', ''),
(1458, '', 1, 0, 15.0000, 15.0000, 0, NULL, 'instock', 0, 0.00, 0, 'taxable', '');

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_rate_limits`
--

CREATE TABLE `cchp_wc_rate_limits` (
  `rate_limit_id` bigint(20) UNSIGNED NOT NULL,
  `rate_limit_key` varchar(200) NOT NULL,
  `rate_limit_expiry` bigint(20) UNSIGNED NOT NULL,
  `rate_limit_remaining` smallint(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_reserved_stock`
--

CREATE TABLE `cchp_wc_reserved_stock` (
  `order_id` bigint(20) NOT NULL,
  `product_id` bigint(20) NOT NULL,
  `stock_quantity` double NOT NULL DEFAULT 0,
  `timestamp` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `expires` datetime NOT NULL DEFAULT '1999-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_tax_rate_classes`
--

CREATE TABLE `cchp_wc_tax_rate_classes` (
  `tax_rate_class_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL DEFAULT '',
  `slug` varchar(200) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_wc_tax_rate_classes`
--

INSERT INTO `cchp_wc_tax_rate_classes` (`tax_rate_class_id`, `name`, `slug`) VALUES
(1, 'Reduced rate', 'reduced-rate'),
(2, 'Zero rate', 'zero-rate');

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wc_webhooks`
--

CREATE TABLE `cchp_wc_webhooks` (
  `webhook_id` bigint(20) UNSIGNED NOT NULL,
  `status` varchar(200) NOT NULL,
  `name` text NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `delivery_url` text NOT NULL,
  `secret` text NOT NULL,
  `topic` varchar(200) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `date_modified_gmt` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `api_version` smallint(4) NOT NULL,
  `failure_count` smallint(10) NOT NULL DEFAULT 0,
  `pending_delivery` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_api_keys`
--

CREATE TABLE `cchp_woocommerce_api_keys` (
  `key_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `description` varchar(200) DEFAULT NULL,
  `permissions` varchar(10) NOT NULL,
  `consumer_key` char(64) NOT NULL,
  `consumer_secret` char(43) NOT NULL,
  `nonces` longtext DEFAULT NULL,
  `truncated_key` char(7) NOT NULL,
  `last_access` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_attribute_taxonomies`
--

CREATE TABLE `cchp_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint(20) UNSIGNED NOT NULL,
  `attribute_name` varchar(200) NOT NULL,
  `attribute_label` varchar(200) DEFAULT NULL,
  `attribute_type` varchar(20) NOT NULL,
  `attribute_orderby` varchar(20) NOT NULL,
  `attribute_public` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `cchp_woocommerce_downloadable_product_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `download_id` varchar(36) NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `order_key` varchar(200) NOT NULL,
  `user_email` varchar(200) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `downloads_remaining` varchar(9) DEFAULT NULL,
  `access_granted` datetime NOT NULL DEFAULT '1999-01-01 00:00:00',
  `access_expires` datetime DEFAULT NULL,
  `download_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_log`
--

CREATE TABLE `cchp_woocommerce_log` (
  `log_id` bigint(20) UNSIGNED NOT NULL,
  `timestamp` datetime NOT NULL,
  `level` smallint(4) NOT NULL,
  `source` varchar(200) NOT NULL,
  `message` longtext NOT NULL,
  `context` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_order_itemmeta`
--

CREATE TABLE `cchp_woocommerce_order_itemmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `order_item_id` bigint(20) UNSIGNED NOT NULL,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_order_items`
--

CREATE TABLE `cchp_woocommerce_order_items` (
  `order_item_id` bigint(20) UNSIGNED NOT NULL,
  `order_item_name` text NOT NULL,
  `order_item_type` varchar(200) NOT NULL DEFAULT '',
  `order_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_payment_tokenmeta`
--

CREATE TABLE `cchp_woocommerce_payment_tokenmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `payment_token_id` bigint(20) UNSIGNED NOT NULL,
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_woocommerce_payment_tokenmeta`
--

INSERT INTO `cchp_woocommerce_payment_tokenmeta` (`meta_id`, `payment_token_id`, `meta_key`, `meta_value`) VALUES
(57, 15, 'last4', '4242'),
(58, 15, 'expiry_year', '2022'),
(59, 15, 'expiry_month', '05'),
(60, 15, 'card_type', 'visa');

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_payment_tokens`
--

CREATE TABLE `cchp_woocommerce_payment_tokens` (
  `token_id` bigint(20) UNSIGNED NOT NULL,
  `gateway_id` varchar(200) NOT NULL,
  `token` text NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `type` varchar(200) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Data dump for tabellen `cchp_woocommerce_payment_tokens`
--

INSERT INTO `cchp_woocommerce_payment_tokens` (`token_id`, `gateway_id`, `token`, `user_id`, `type`, `is_default`) VALUES
(15, 'stripe', 'src_1K4BQiE9s89MF2pX9YCVdtWh', 3, 'CC', 1);

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_sessions`
--

CREATE TABLE `cchp_woocommerce_sessions` (
  `session_id` bigint(20) UNSIGNED NOT NULL,
  `session_key` char(32) NOT NULL,
  `session_value` longtext NOT NULL,
  `session_expiry` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_shipping_zones`
--

CREATE TABLE `cchp_woocommerce_shipping_zones` (
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `zone_name` varchar(200) NOT NULL,
  `zone_order` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_shipping_zone_locations`
--

CREATE TABLE `cchp_woocommerce_shipping_zone_locations` (
  `location_id` bigint(20) UNSIGNED NOT NULL,
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `location_code` varchar(200) NOT NULL,
  `location_type` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_shipping_zone_methods`
--

CREATE TABLE `cchp_woocommerce_shipping_zone_methods` (
  `zone_id` bigint(20) UNSIGNED NOT NULL,
  `instance_id` bigint(20) UNSIGNED NOT NULL,
  `method_id` varchar(200) NOT NULL,
  `method_order` bigint(20) UNSIGNED NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_tax_rates`
--

CREATE TABLE `cchp_woocommerce_tax_rates` (
  `tax_rate_id` bigint(20) UNSIGNED NOT NULL,
  `tax_rate_country` varchar(2) NOT NULL DEFAULT '',
  `tax_rate_state` varchar(200) NOT NULL DEFAULT '',
  `tax_rate` varchar(8) NOT NULL DEFAULT '',
  `tax_rate_name` varchar(200) NOT NULL DEFAULT '',
  `tax_rate_priority` bigint(20) UNSIGNED NOT NULL,
  `tax_rate_compound` int(1) NOT NULL DEFAULT 0,
  `tax_rate_shipping` int(1) NOT NULL DEFAULT 1,
  `tax_rate_order` bigint(20) UNSIGNED NOT NULL,
  `tax_rate_class` varchar(200) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_woocommerce_tax_rate_locations`
--

CREATE TABLE `cchp_woocommerce_tax_rate_locations` (
  `location_id` bigint(20) UNSIGNED NOT NULL,
  `location_code` varchar(200) NOT NULL,
  `tax_rate_id` bigint(20) UNSIGNED NOT NULL,
  `location_type` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wpae_blocked_ip`
--

CREATE TABLE `cchp_wpae_blocked_ip` (
  `id` int(11) NOT NULL,
  `spammer_ip` varchar(20) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wpae_spammer_ip`
--

CREATE TABLE `cchp_wpae_spammer_ip` (
  `id` int(11) NOT NULL,
  `wp_system` varchar(20) NOT NULL,
  `spammer_ip` varchar(20) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wpae_spam_data`
--

CREATE TABLE `cchp_wpae_spam_data` (
  `id` int(11) NOT NULL,
  `wp_system` varchar(20) NOT NULL,
  `spam_data` text NOT NULL,
  `spammer_ip` varchar(20) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wpae_submission_id`
--

CREATE TABLE `cchp_wpae_submission_id` (
  `id` int(11) NOT NULL,
  `submission_id` varchar(30) NOT NULL,
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wpvivid_options`
--

CREATE TABLE `cchp_wpvivid_options` (
  `option_id` bigint(20) UNSIGNED NOT NULL,
  `option_name` varchar(191) NOT NULL DEFAULT '',
  `option_value` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wpvivid_scan_result`
--

CREATE TABLE `cchp_wpvivid_scan_result` (
  `id` bigint(20) NOT NULL,
  `path` text NOT NULL,
  `from_post` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur-dump for tabellen `cchp_wpvivid_unused_uploads_files`
--

CREATE TABLE `cchp_wpvivid_unused_uploads_files` (
  `id` bigint(20) NOT NULL,
  `path` text NOT NULL,
  `folder` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Begrænsninger for dumpede tabeller
--

--
-- Indeks for tabel `cchp_actionscheduler_actions`
--
ALTER TABLE `cchp_actionscheduler_actions`
  ADD PRIMARY KEY (`action_id`),
  ADD KEY `hook` (`hook`),
  ADD KEY `status` (`status`),
  ADD KEY `scheduled_date_gmt` (`scheduled_date_gmt`),
  ADD KEY `args` (`args`),
  ADD KEY `group_id` (`group_id`),
  ADD KEY `last_attempt_gmt` (`last_attempt_gmt`),
  ADD KEY `claim_id` (`claim_id`),
  ADD KEY `claim_id_status_scheduled_date_gmt` (`claim_id`,`status`,`scheduled_date_gmt`);

--
-- Indeks for tabel `cchp_actionscheduler_claims`
--
ALTER TABLE `cchp_actionscheduler_claims`
  ADD PRIMARY KEY (`claim_id`),
  ADD KEY `date_created_gmt` (`date_created_gmt`);

--
-- Indeks for tabel `cchp_actionscheduler_groups`
--
ALTER TABLE `cchp_actionscheduler_groups`
  ADD PRIMARY KEY (`group_id`),
  ADD KEY `slug` (`slug`(191));

--
-- Indeks for tabel `cchp_actionscheduler_logs`
--
ALTER TABLE `cchp_actionscheduler_logs`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `action_id` (`action_id`),
  ADD KEY `log_date_gmt` (`log_date_gmt`);

--
-- Indeks for tabel `cchp_commentmeta`
--
ALTER TABLE `cchp_commentmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `comment_id` (`comment_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indeks for tabel `cchp_comments`
--
ALTER TABLE `cchp_comments`
  ADD PRIMARY KEY (`comment_ID`),
  ADD KEY `comment_post_ID` (`comment_post_ID`),
  ADD KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  ADD KEY `comment_date_gmt` (`comment_date_gmt`),
  ADD KEY `comment_parent` (`comment_parent`),
  ADD KEY `comment_author_email` (`comment_author_email`(10)),
  ADD KEY `woo_idx_comment_type` (`comment_type`);

--
-- Indeks for tabel `cchp_e_events`
--
ALTER TABLE `cchp_e_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `created_at_index` (`created_at`);

--
-- Indeks for tabel `cchp_e_notes`
--
ALTER TABLE `cchp_e_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `route_url_index` (`route_url`(191)),
  ADD KEY `post_id_index` (`post_id`),
  ADD KEY `element_id_index` (`element_id`),
  ADD KEY `parent_id_index` (`parent_id`),
  ADD KEY `author_id_index` (`author_id`),
  ADD KEY `status_index` (`status`),
  ADD KEY `is_resolved_index` (`is_resolved`),
  ADD KEY `is_public_index` (`is_public`),
  ADD KEY `created_at_index` (`created_at`),
  ADD KEY `updated_at_index` (`updated_at`),
  ADD KEY `last_activity_at_index` (`last_activity_at`);

--
-- Indeks for tabel `cchp_e_notes_users_relations`
--
ALTER TABLE `cchp_e_notes_users_relations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type_index` (`type`),
  ADD KEY `note_id_index` (`note_id`),
  ADD KEY `user_id_index` (`user_id`);

--
-- Indeks for tabel `cchp_e_submissions`
--
ALTER TABLE `cchp_e_submissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `hash_id_unique_index` (`hash_id`),
  ADD KEY `main_meta_id_index` (`main_meta_id`),
  ADD KEY `hash_id_index` (`hash_id`),
  ADD KEY `type_index` (`type`),
  ADD KEY `post_id_index` (`post_id`),
  ADD KEY `element_id_index` (`element_id`),
  ADD KEY `campaign_id_index` (`campaign_id`),
  ADD KEY `user_id_index` (`user_id`),
  ADD KEY `user_ip_index` (`user_ip`),
  ADD KEY `status_index` (`status`),
  ADD KEY `is_read_index` (`is_read`),
  ADD KEY `created_at_gmt_index` (`created_at_gmt`),
  ADD KEY `updated_at_gmt_index` (`updated_at_gmt`),
  ADD KEY `created_at_index` (`created_at`),
  ADD KEY `updated_at_index` (`updated_at`),
  ADD KEY `referer_index` (`referer`),
  ADD KEY `referer_title_index` (`referer_title`);

--
-- Indeks for tabel `cchp_e_submissions_actions_log`
--
ALTER TABLE `cchp_e_submissions_actions_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `submission_id_index` (`submission_id`),
  ADD KEY `action_name_index` (`action_name`),
  ADD KEY `status_index` (`status`),
  ADD KEY `created_at_gmt_index` (`created_at_gmt`),
  ADD KEY `updated_at_gmt_index` (`updated_at_gmt`),
  ADD KEY `created_at_index` (`created_at`),
  ADD KEY `updated_at_index` (`updated_at`);

--
-- Indeks for tabel `cchp_e_submissions_values`
--
ALTER TABLE `cchp_e_submissions_values`
  ADD PRIMARY KEY (`id`),
  ADD KEY `submission_id_index` (`submission_id`),
  ADD KEY `key_index` (`key`);

--
-- Indeks for tabel `cchp_links`
--
ALTER TABLE `cchp_links`
  ADD PRIMARY KEY (`link_id`),
  ADD KEY `link_visible` (`link_visible`);

--
-- Indeks for tabel `cchp_litespeed_avatar`
--
ALTER TABLE `cchp_litespeed_avatar`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `md5` (`md5`),
  ADD KEY `dateline` (`dateline`);

--
-- Indeks for tabel `cchp_litespeed_url`
--
ALTER TABLE `cchp_litespeed_url`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `url` (`url`(191)),
  ADD KEY `cache_tags` (`cache_tags`(191));

--
-- Indeks for tabel `cchp_litespeed_url_file`
--
ALTER TABLE `cchp_litespeed_url_file`
  ADD PRIMARY KEY (`id`),
  ADD KEY `filename` (`filename`),
  ADD KEY `type` (`type`),
  ADD KEY `url_id_2` (`url_id`,`vary`,`type`),
  ADD KEY `filename_2` (`filename`,`expired`),
  ADD KEY `url_id` (`url_id`,`expired`);

--
-- Indeks for tabel `cchp_ms_snippets`
--
ALTER TABLE `cchp_ms_snippets`
  ADD PRIMARY KEY (`id`);

--
-- Indeks for tabel `cchp_mylisting_events`
--
ALTER TABLE `cchp_mylisting_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `listing_id` (`listing_id`),
  ADD KEY `start_date` (`start_date`),
  ADD KEY `end_date` (`end_date`),
  ADD KEY `repeat_end` (`repeat_end`),
  ADD KEY `field_key` (`field_key`);

--
-- Indeks for tabel `cchp_mylisting_locations`
--
ALTER TABLE `cchp_mylisting_locations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `listing_id` (`listing_id`),
  ADD KEY `lat` (`lat`),
  ADD KEY `lng` (`lng`);

--
-- Indeks for tabel `cchp_mylisting_messages`
--
ALTER TABLE `cchp_mylisting_messages`
  ADD PRIMARY KEY (`message_id`),
  ADD KEY `sender_id` (`sender_id`),
  ADD KEY `receiver_id` (`receiver_id`),
  ADD KEY `send_time` (`send_time`),
  ADD KEY `seen` (`seen`),
  ADD KEY `listing_id` (`listing_id`);

--
-- Indeks for tabel `cchp_mylisting_relations`
--
ALTER TABLE `cchp_mylisting_relations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parent_listing_id` (`parent_listing_id`),
  ADD KEY `child_listing_id` (`child_listing_id`),
  ADD KEY `field_key` (`field_key`),
  ADD KEY `item_order` (`item_order`);

--
-- Indeks for tabel `cchp_mylisting_visits`
--
ALTER TABLE `cchp_mylisting_visits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_VIEWS_LISTING_ID` (`listing_id`),
  ADD KEY `fingerprint` (`fingerprint`),
  ADD KEY `time` (`time`),
  ADD KEY `ref_domain` (`ref_domain`),
  ADD KEY `ref_url` (`ref_url`);

--
-- Indeks for tabel `cchp_mylisting_workhours`
--
ALTER TABLE `cchp_mylisting_workhours`
  ADD PRIMARY KEY (`id`),
  ADD KEY `listing_id` (`listing_id`),
  ADD KEY `start` (`start`),
  ADD KEY `end` (`end`);

--
-- Indeks for tabel `cchp_options`
--
ALTER TABLE `cchp_options`
  ADD PRIMARY KEY (`option_id`),
  ADD UNIQUE KEY `option_name` (`option_name`),
  ADD KEY `autoload` (`autoload`);

--
-- Indeks for tabel `cchp_postmeta`
--
ALTER TABLE `cchp_postmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `post_id` (`post_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indeks for tabel `cchp_posts`
--
ALTER TABLE `cchp_posts`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `post_name` (`post_name`(191)),
  ADD KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
  ADD KEY `post_parent` (`post_parent`),
  ADD KEY `post_author` (`post_author`);

--
-- Indeks for tabel `cchp_seopress_significant_keywords`
--
ALTER TABLE `cchp_seopress_significant_keywords`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_post_id` (`post_id`),
  ADD KEY `idx_word` (`word`);

--
-- Indeks for tabel `cchp_snippets`
--
ALTER TABLE `cchp_snippets`
  ADD PRIMARY KEY (`id`);

--
-- Indeks for tabel `cchp_termmeta`
--
ALTER TABLE `cchp_termmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `term_id` (`term_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indeks for tabel `cchp_terms`
--
ALTER TABLE `cchp_terms`
  ADD PRIMARY KEY (`term_id`),
  ADD KEY `slug` (`slug`(191)),
  ADD KEY `name` (`name`(191));

--
-- Indeks for tabel `cchp_term_relationships`
--
ALTER TABLE `cchp_term_relationships`
  ADD PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  ADD KEY `term_taxonomy_id` (`term_taxonomy_id`);

--
-- Indeks for tabel `cchp_term_taxonomy`
--
ALTER TABLE `cchp_term_taxonomy`
  ADD PRIMARY KEY (`term_taxonomy_id`),
  ADD UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  ADD KEY `taxonomy` (`taxonomy`);

--
-- Indeks for tabel `cchp_usermeta`
--
ALTER TABLE `cchp_usermeta`
  ADD PRIMARY KEY (`umeta_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indeks for tabel `cchp_users`
--
ALTER TABLE `cchp_users`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `user_login_key` (`user_login`),
  ADD KEY `user_nicename` (`user_nicename`),
  ADD KEY `user_email` (`user_email`);

--
-- Indeks for tabel `cchp_wcs_payment_retries`
--
ALTER TABLE `cchp_wcs_payment_retries`
  ADD PRIMARY KEY (`retry_id`),
  ADD KEY `order_id` (`order_id`);

--
-- Indeks for tabel `cchp_wc_admin_notes`
--
ALTER TABLE `cchp_wc_admin_notes`
  ADD PRIMARY KEY (`note_id`);

--
-- Indeks for tabel `cchp_wc_admin_note_actions`
--
ALTER TABLE `cchp_wc_admin_note_actions`
  ADD PRIMARY KEY (`action_id`),
  ADD KEY `note_id` (`note_id`);

--
-- Indeks for tabel `cchp_wc_category_lookup`
--
ALTER TABLE `cchp_wc_category_lookup`
  ADD PRIMARY KEY (`category_tree_id`,`category_id`);

--
-- Indeks for tabel `cchp_wc_customer_lookup`
--
ALTER TABLE `cchp_wc_customer_lookup`
  ADD PRIMARY KEY (`customer_id`),
  ADD UNIQUE KEY `user_id` (`user_id`),
  ADD KEY `email` (`email`);

--
-- Indeks for tabel `cchp_wc_download_log`
--
ALTER TABLE `cchp_wc_download_log`
  ADD PRIMARY KEY (`download_log_id`),
  ADD KEY `permission_id` (`permission_id`),
  ADD KEY `timestamp` (`timestamp`);

--
-- Indeks for tabel `cchp_wc_order_coupon_lookup`
--
ALTER TABLE `cchp_wc_order_coupon_lookup`
  ADD PRIMARY KEY (`order_id`,`coupon_id`),
  ADD KEY `coupon_id` (`coupon_id`),
  ADD KEY `date_created` (`date_created`);

--
-- Indeks for tabel `cchp_wc_order_product_lookup`
--
ALTER TABLE `cchp_wc_order_product_lookup`
  ADD PRIMARY KEY (`order_item_id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `date_created` (`date_created`);

--
-- Indeks for tabel `cchp_wc_order_stats`
--
ALTER TABLE `cchp_wc_order_stats`
  ADD PRIMARY KEY (`order_id`),
  ADD KEY `date_created` (`date_created`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `status` (`status`(191));

--
-- Indeks for tabel `cchp_wc_order_tax_lookup`
--
ALTER TABLE `cchp_wc_order_tax_lookup`
  ADD PRIMARY KEY (`order_id`,`tax_rate_id`),
  ADD KEY `tax_rate_id` (`tax_rate_id`),
  ADD KEY `date_created` (`date_created`);

--
-- Indeks for tabel `cchp_wc_product_attributes_lookup`
--
ALTER TABLE `cchp_wc_product_attributes_lookup`
  ADD PRIMARY KEY (`product_or_parent_id`,`term_id`,`product_id`,`taxonomy`),
  ADD KEY `is_variation_attribute_term_id` (`is_variation_attribute`,`term_id`);

--
-- Indeks for tabel `cchp_wc_product_download_directories`
--
ALTER TABLE `cchp_wc_product_download_directories`
  ADD PRIMARY KEY (`url_id`),
  ADD KEY `url` (`url`(191));

--
-- Indeks for tabel `cchp_wc_product_meta_lookup`
--
ALTER TABLE `cchp_wc_product_meta_lookup`
  ADD PRIMARY KEY (`product_id`),
  ADD KEY `virtual` (`virtual`),
  ADD KEY `downloadable` (`downloadable`),
  ADD KEY `stock_status` (`stock_status`),
  ADD KEY `stock_quantity` (`stock_quantity`),
  ADD KEY `onsale` (`onsale`),
  ADD KEY `min_max_price` (`min_price`,`max_price`);

--
-- Indeks for tabel `cchp_wc_rate_limits`
--
ALTER TABLE `cchp_wc_rate_limits`
  ADD PRIMARY KEY (`rate_limit_id`),
  ADD UNIQUE KEY `rate_limit_key` (`rate_limit_key`(191));

--
-- Indeks for tabel `cchp_wc_reserved_stock`
--
ALTER TABLE `cchp_wc_reserved_stock`
  ADD PRIMARY KEY (`order_id`,`product_id`);

--
-- Indeks for tabel `cchp_wc_tax_rate_classes`
--
ALTER TABLE `cchp_wc_tax_rate_classes`
  ADD PRIMARY KEY (`tax_rate_class_id`),
  ADD UNIQUE KEY `slug` (`slug`(191));

--
-- Indeks for tabel `cchp_wc_webhooks`
--
ALTER TABLE `cchp_wc_webhooks`
  ADD PRIMARY KEY (`webhook_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indeks for tabel `cchp_woocommerce_api_keys`
--
ALTER TABLE `cchp_woocommerce_api_keys`
  ADD PRIMARY KEY (`key_id`),
  ADD KEY `consumer_key` (`consumer_key`),
  ADD KEY `consumer_secret` (`consumer_secret`);

--
-- Indeks for tabel `cchp_woocommerce_attribute_taxonomies`
--
ALTER TABLE `cchp_woocommerce_attribute_taxonomies`
  ADD PRIMARY KEY (`attribute_id`),
  ADD KEY `attribute_name` (`attribute_name`(20));

--
-- Indeks for tabel `cchp_woocommerce_downloadable_product_permissions`
--
ALTER TABLE `cchp_woocommerce_downloadable_product_permissions`
  ADD PRIMARY KEY (`permission_id`),
  ADD KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`),
  ADD KEY `download_order_product` (`download_id`,`order_id`,`product_id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `user_order_remaining_expires` (`user_id`,`order_id`,`downloads_remaining`,`access_expires`);

--
-- Indeks for tabel `cchp_woocommerce_log`
--
ALTER TABLE `cchp_woocommerce_log`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `level` (`level`);

--
-- Indeks for tabel `cchp_woocommerce_order_itemmeta`
--
ALTER TABLE `cchp_woocommerce_order_itemmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `order_item_id` (`order_item_id`),
  ADD KEY `meta_key` (`meta_key`(32));

--
-- Indeks for tabel `cchp_woocommerce_order_items`
--
ALTER TABLE `cchp_woocommerce_order_items`
  ADD PRIMARY KEY (`order_item_id`),
  ADD KEY `order_id` (`order_id`);

--
-- Indeks for tabel `cchp_woocommerce_payment_tokenmeta`
--
ALTER TABLE `cchp_woocommerce_payment_tokenmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `payment_token_id` (`payment_token_id`),
  ADD KEY `meta_key` (`meta_key`(32));

--
-- Indeks for tabel `cchp_woocommerce_payment_tokens`
--
ALTER TABLE `cchp_woocommerce_payment_tokens`
  ADD PRIMARY KEY (`token_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indeks for tabel `cchp_woocommerce_sessions`
--
ALTER TABLE `cchp_woocommerce_sessions`
  ADD PRIMARY KEY (`session_id`),
  ADD UNIQUE KEY `session_key` (`session_key`);

--
-- Indeks for tabel `cchp_woocommerce_shipping_zones`
--
ALTER TABLE `cchp_woocommerce_shipping_zones`
  ADD PRIMARY KEY (`zone_id`);

--
-- Indeks for tabel `cchp_woocommerce_shipping_zone_locations`
--
ALTER TABLE `cchp_woocommerce_shipping_zone_locations`
  ADD PRIMARY KEY (`location_id`),
  ADD KEY `location_id` (`location_id`),
  ADD KEY `location_type_code` (`location_type`(10),`location_code`(20));

--
-- Indeks for tabel `cchp_woocommerce_shipping_zone_methods`
--
ALTER TABLE `cchp_woocommerce_shipping_zone_methods`
  ADD PRIMARY KEY (`instance_id`);

--
-- Indeks for tabel `cchp_woocommerce_tax_rates`
--
ALTER TABLE `cchp_woocommerce_tax_rates`
  ADD PRIMARY KEY (`tax_rate_id`),
  ADD KEY `tax_rate_country` (`tax_rate_country`),
  ADD KEY `tax_rate_state` (`tax_rate_state`(2)),
  ADD KEY `tax_rate_class` (`tax_rate_class`(10)),
  ADD KEY `tax_rate_priority` (`tax_rate_priority`);

--
-- Indeks for tabel `cchp_woocommerce_tax_rate_locations`
--
ALTER TABLE `cchp_woocommerce_tax_rate_locations`
  ADD PRIMARY KEY (`location_id`),
  ADD KEY `tax_rate_id` (`tax_rate_id`),
  ADD KEY `location_type_code` (`location_type`(10),`location_code`(20));

--
-- Indeks for tabel `cchp_wpae_blocked_ip`
--
ALTER TABLE `cchp_wpae_blocked_ip`
  ADD PRIMARY KEY (`id`);

--
-- Indeks for tabel `cchp_wpae_spammer_ip`
--
ALTER TABLE `cchp_wpae_spammer_ip`
  ADD PRIMARY KEY (`id`);

--
-- Indeks for tabel `cchp_wpae_spam_data`
--
ALTER TABLE `cchp_wpae_spam_data`
  ADD PRIMARY KEY (`id`);

--
-- Indeks for tabel `cchp_wpae_submission_id`
--
ALTER TABLE `cchp_wpae_submission_id`
  ADD PRIMARY KEY (`id`);

--
-- Indeks for tabel `cchp_wpvivid_options`
--
ALTER TABLE `cchp_wpvivid_options`
  ADD PRIMARY KEY (`option_id`),
  ADD UNIQUE KEY `option_name` (`option_name`);

--
-- Indeks for tabel `cchp_wpvivid_scan_result`
--
ALTER TABLE `cchp_wpvivid_scan_result`
  ADD PRIMARY KEY (`id`);

--
-- Indeks for tabel `cchp_wpvivid_unused_uploads_files`
--
ALTER TABLE `cchp_wpvivid_unused_uploads_files`
  ADD PRIMARY KEY (`id`);

--
-- Brug ikke AUTO_INCREMENT for slettede tabeller
--

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_actionscheduler_actions`
--
ALTER TABLE `cchp_actionscheduler_actions`
  MODIFY `action_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17156;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_actionscheduler_claims`
--
ALTER TABLE `cchp_actionscheduler_claims`
  MODIFY `claim_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=939046;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_actionscheduler_groups`
--
ALTER TABLE `cchp_actionscheduler_groups`
  MODIFY `group_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_actionscheduler_logs`
--
ALTER TABLE `cchp_actionscheduler_logs`
  MODIFY `log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51299;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_commentmeta`
--
ALTER TABLE `cchp_commentmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_comments`
--
ALTER TABLE `cchp_comments`
  MODIFY `comment_ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=395;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_e_events`
--
ALTER TABLE `cchp_e_events`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_e_notes`
--
ALTER TABLE `cchp_e_notes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_e_notes_users_relations`
--
ALTER TABLE `cchp_e_notes_users_relations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_e_submissions`
--
ALTER TABLE `cchp_e_submissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_e_submissions_actions_log`
--
ALTER TABLE `cchp_e_submissions_actions_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_e_submissions_values`
--
ALTER TABLE `cchp_e_submissions_values`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_links`
--
ALTER TABLE `cchp_links`
  MODIFY `link_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_litespeed_avatar`
--
ALTER TABLE `cchp_litespeed_avatar`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_litespeed_url`
--
ALTER TABLE `cchp_litespeed_url`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_litespeed_url_file`
--
ALTER TABLE `cchp_litespeed_url_file`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_ms_snippets`
--
ALTER TABLE `cchp_ms_snippets`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_mylisting_events`
--
ALTER TABLE `cchp_mylisting_events`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_mylisting_locations`
--
ALTER TABLE `cchp_mylisting_locations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_mylisting_messages`
--
ALTER TABLE `cchp_mylisting_messages`
  MODIFY `message_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_mylisting_relations`
--
ALTER TABLE `cchp_mylisting_relations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=268;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_mylisting_visits`
--
ALTER TABLE `cchp_mylisting_visits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13975;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_mylisting_workhours`
--
ALTER TABLE `cchp_mylisting_workhours`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_options`
--
ALTER TABLE `cchp_options`
  MODIFY `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1085472;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_postmeta`
--
ALTER TABLE `cchp_postmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40301;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_posts`
--
ALTER TABLE `cchp_posts`
  MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3594;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_seopress_significant_keywords`
--
ALTER TABLE `cchp_seopress_significant_keywords`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1121;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_snippets`
--
ALTER TABLE `cchp_snippets`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_termmeta`
--
ALTER TABLE `cchp_termmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1946;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_terms`
--
ALTER TABLE `cchp_terms`
  MODIFY `term_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=165;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_term_taxonomy`
--
ALTER TABLE `cchp_term_taxonomy`
  MODIFY `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=165;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_usermeta`
--
ALTER TABLE `cchp_usermeta`
  MODIFY `umeta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7266;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_users`
--
ALTER TABLE `cchp_users`
  MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=281;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wcs_payment_retries`
--
ALTER TABLE `cchp_wcs_payment_retries`
  MODIFY `retry_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wc_admin_notes`
--
ALTER TABLE `cchp_wc_admin_notes`
  MODIFY `note_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wc_admin_note_actions`
--
ALTER TABLE `cchp_wc_admin_note_actions`
  MODIFY `action_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4047;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wc_customer_lookup`
--
ALTER TABLE `cchp_wc_customer_lookup`
  MODIFY `customer_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=121;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wc_download_log`
--
ALTER TABLE `cchp_wc_download_log`
  MODIFY `download_log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wc_product_download_directories`
--
ALTER TABLE `cchp_wc_product_download_directories`
  MODIFY `url_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wc_rate_limits`
--
ALTER TABLE `cchp_wc_rate_limits`
  MODIFY `rate_limit_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wc_tax_rate_classes`
--
ALTER TABLE `cchp_wc_tax_rate_classes`
  MODIFY `tax_rate_class_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wc_webhooks`
--
ALTER TABLE `cchp_wc_webhooks`
  MODIFY `webhook_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_api_keys`
--
ALTER TABLE `cchp_woocommerce_api_keys`
  MODIFY `key_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_attribute_taxonomies`
--
ALTER TABLE `cchp_woocommerce_attribute_taxonomies`
  MODIFY `attribute_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_downloadable_product_permissions`
--
ALTER TABLE `cchp_woocommerce_downloadable_product_permissions`
  MODIFY `permission_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_log`
--
ALTER TABLE `cchp_woocommerce_log`
  MODIFY `log_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_order_itemmeta`
--
ALTER TABLE `cchp_woocommerce_order_itemmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1352;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_order_items`
--
ALTER TABLE `cchp_woocommerce_order_items`
  MODIFY `order_item_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_payment_tokenmeta`
--
ALTER TABLE `cchp_woocommerce_payment_tokenmeta`
  MODIFY `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_payment_tokens`
--
ALTER TABLE `cchp_woocommerce_payment_tokens`
  MODIFY `token_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_sessions`
--
ALTER TABLE `cchp_woocommerce_sessions`
  MODIFY `session_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_shipping_zones`
--
ALTER TABLE `cchp_woocommerce_shipping_zones`
  MODIFY `zone_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_shipping_zone_locations`
--
ALTER TABLE `cchp_woocommerce_shipping_zone_locations`
  MODIFY `location_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_shipping_zone_methods`
--
ALTER TABLE `cchp_woocommerce_shipping_zone_methods`
  MODIFY `instance_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_tax_rates`
--
ALTER TABLE `cchp_woocommerce_tax_rates`
  MODIFY `tax_rate_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_woocommerce_tax_rate_locations`
--
ALTER TABLE `cchp_woocommerce_tax_rate_locations`
  MODIFY `location_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wpae_blocked_ip`
--
ALTER TABLE `cchp_wpae_blocked_ip`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wpae_spammer_ip`
--
ALTER TABLE `cchp_wpae_spammer_ip`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wpae_spam_data`
--
ALTER TABLE `cchp_wpae_spam_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wpae_submission_id`
--
ALTER TABLE `cchp_wpae_submission_id`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wpvivid_options`
--
ALTER TABLE `cchp_wpvivid_options`
  MODIFY `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wpvivid_scan_result`
--
ALTER TABLE `cchp_wpvivid_scan_result`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- Tilføj AUTO_INCREMENT i tabel `cchp_wpvivid_unused_uploads_files`
--
ALTER TABLE `cchp_wpvivid_unused_uploads_files`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- Begrænsninger for dumpede tabeller
--

--
-- Begrænsninger for tabel `cchp_mylisting_events`
--
ALTER TABLE `cchp_mylisting_events`
  ADD CONSTRAINT `cchp_mylisting_events_ibfk_1` FOREIGN KEY (`listing_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE;

--
-- Begrænsninger for tabel `cchp_mylisting_locations`
--
ALTER TABLE `cchp_mylisting_locations`
  ADD CONSTRAINT `cchp_mylisting_locations_ibfk_1` FOREIGN KEY (`listing_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE;

--
-- Begrænsninger for tabel `cchp_mylisting_relations`
--
ALTER TABLE `cchp_mylisting_relations`
  ADD CONSTRAINT `cchp_mylisting_relations_ibfk_1` FOREIGN KEY (`parent_listing_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE,
  ADD CONSTRAINT `cchp_mylisting_relations_ibfk_2` FOREIGN KEY (`child_listing_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE;

--
-- Begrænsninger for tabel `cchp_mylisting_visits`
--
ALTER TABLE `cchp_mylisting_visits`
  ADD CONSTRAINT `FK_VIEWS_LISTING_ID` FOREIGN KEY (`listing_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE;

--
-- Begrænsninger for tabel `cchp_mylisting_workhours`
--
ALTER TABLE `cchp_mylisting_workhours`
  ADD CONSTRAINT `cchp_mylisting_workhours_ibfk_1` FOREIGN KEY (`listing_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE;
COMMIT;

