CREATE TABLE `wplc_wc_activecampaign` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `synced_to_ac` tinyint(4) NOT NULL DEFAULT '0',
  `customer_id` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `customer_email` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `customer_first_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `customer_last_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `last_access_time` datetime DEFAULT NULL,
  `order_date` datetime DEFAULT NULL,
  `user_ref_json` mediumtext COLLATE utf8mb4_unicode_520_ci,
  `customer_ref_json` longtext COLLATE utf8mb4_unicode_520_ci,
  `cart_ref_json` longtext COLLATE utf8mb4_unicode_520_ci,
  `cart_totals_ref_json` mediumtext COLLATE utf8mb4_unicode_520_ci,
  `removed_cart_contents_ref_json` longtext COLLATE utf8mb4_unicode_520_ci,
  `activecampaignfwc_order_external_uuid` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `ac_externalcheckoutid` varchar(155) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `wc_order_id` int(11) DEFAULT NULL,
  `ac_order_id` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `abandoned_date` datetime DEFAULT NULL,
  `ac_customer_id` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ac_externalcheckoutid_UNIQUE` (`ac_externalcheckoutid`),
  KEY `synced_to_ac_last_access_time` (`last_access_time`,`synced_to_ac`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

INSERT INTO `wplc_wc_activecampaign` VALUES (2,1,'14','admin@dubdelivery.club','Braeden','Ellis','2022-10-14 13:58:44','2022-10-14 09:05:58',NULL,NULL,NULL,NULL,NULL,'634969736868f2.92496702','43850448a69f7ae0880541df630484a7',1094,'2',NULL,'5');
INSERT INTO `wplc_wc_activecampaign` VALUES (3,1,'14','admin@dubdelivery.club','Braeden','Ellis','2022-10-14 16:29:47','2022-10-14 11:35:48',NULL,NULL,NULL,NULL,NULL,'63496cc6895568.09327420','d067a2954016562b76984f02c1ce2665',1095,'3',NULL,'5');
INSERT INTO `wplc_wc_activecampaign` VALUES (11,1,'0','rreiffenberger@fallstechnology.group','Ryan','Reiffenberger',NULL,'2022-12-18 09:53:46',NULL,NULL,NULL,NULL,NULL,NULL,'da0112806f9bc2957b026cb0291b2b3b',1117,NULL,NULL,NULL);
INSERT INTO `wplc_wc_activecampaign` VALUES (13,21,'1','wordpress@fallstech.group','Falls Tech Group','System Administrator','2023-11-19 00:08:38',NULL,'{\"data\":{\"ID\":\"1\",\"user_login\":\"ftgadmin\",\"user_nicename\":\"ftgadmin\",\"user_email\":\"wordpress@fallstech.group\",\"user_url\":\"http:\\/\\/www.fallstech.group\",\"user_registered\":\"2022-02-15 21:27:30\",\"user_activation_key\":\"\",\"user_status\":\"0\",\"display_name\":\"ftgadmin\"},\"ID\":1,\"caps\":{\"administrator\":true},\"cap_key\":\"wplc_capabilities\",\"roles\":[\"administrator\"],\"allcaps\":{\"switch_themes\":true,\"edit_themes\":true,\"activate_plugins\":true,\"edit_plugins\":true,\"edit_users\":true,\"edit_files\":true,\"manage_options\":true,\"moderate_comments\":true,\"manage_categories\":true,\"manage_links\":true,\"upload_files\":true,\"import\":true,\"unfiltered_html\":true,\"edit_posts\":true,\"edit_others_posts\":true,\"edit_published_posts\":true,\"publish_posts\":true,\"edit_pages\":true,\"read\":true,\"level_10\":true,\"level_9\":true,\"level_8\":true,\"level_7\":true,\"level_6\":true,\"level_5\":true,\"level_4\":true,\"level_3\":true,\"level_2\":true,\"level_1\":true,\"level_0\":true,\"edit_others_pages\":true,\"edit_published_pages\":true,\"publish_pages\":true,\"delete_pages\":true,\"delete_others_pages\":true,\"delete_published_pages\":true,\"delete_posts\":true,\"delete_others_posts\":true,\"delete_published_posts\":true,\"delete_private_posts\":true,\"edit_private_posts\":true,\"read_private_posts\":true,\"delete_private_pages\":true,\"edit_private_pages\":true,\"read_private_pages\":true,\"delete_users\":true,\"create_users\":true,\"unfiltered_upload\":true,\"edit_dashboard\":true,\"update_plugins\":true,\"delete_plugins\":true,\"install_plugins\":true,\"update_themes\":true,\"install_themes\":true,\"update_core\":true,\"list_users\":true,\"remove_users\":true,\"promote_users\":true,\"edit_theme_options\":true,\"delete_themes\":true,\"export\":true,\"copy_posts\":true,\"manage_woocommerce\":true,\"view_woocommerce_reports\":true,\"edit_product\":true,\"read_product\":true,\"delete_product\":true,\"edit_products\":true,\"edit_others_products\":true,\"publish_products\":true,\"read_private_products\":true,\"delete_products\":true,\"delete_private_products\":true,\"delete_published_products\":true,\"delete_others_products\":true,\"edit_private_products\":true,\"edit_published_products\":true,\"manage_product_terms\":true,\"edit_product_terms\":true,\"delete_product_terms\":true,\"assign_product_terms\":true,\"edit_shop_order\":true,\"read_shop_order\":true,\"delete_shop_order\":true,\"edit_shop_orders\":true,\"edit_others_shop_orders\":true,\"publish_shop_orders\":true,\"read_private_shop_orders\":true,\"delete_shop_orders\":true,\"delete_private_shop_orders\":true,\"delete_published_shop_orders\":true,\"delete_others_shop_orders\":true,\"edit_private_shop_orders\":true,\"edit_published_shop_orders\":true,\"manage_shop_order_terms\":true,\"edit_shop_order_terms\":true,\"delete_shop_order_terms\":true,\"assign_shop_order_terms\":true,\"edit_shop_coupon\":true,\"read_shop_coupon\":true,\"delete_shop_coupon\":true,\"edit_shop_coupons\":true,\"edit_others_shop_coupons\":true,\"publish_shop_coupons\":true,\"read_private_shop_coupons\":true,\"delete_shop_coupons\":true,\"delete_private_shop_coupons\":true,\"delete_published_shop_coupons\":true,\"delete_others_shop_coupons\":true,\"edit_private_shop_coupons\":true,\"edit_published_shop_coupons\":true,\"manage_shop_coupon_terms\":true,\"edit_shop_coupon_terms\":true,\"delete_shop_coupon_terms\":true,\"assign_shop_coupon_terms\":true,\"ag_manage_restrictions\":true,\"ag_manage_appearance\":true,\"ag_manage_advanced\":true,\"ag_manage_messaging\":true,\"ag_manage_settings\":true,\"ag_manage_set_content_restriction\":true,\"ag_manage_set_content_bypass\":true,\"ag_manage_set_custom_age\":true,\"aioseo_manage_seo\":true,\"aioseo_page_analysis\":true,\"aioseo_page_general_settings\":true,\"aioseo_page_advanced_settings\":true,\"aioseo_page_schema_settings\":true,\"aioseo_page_social_settings\":true,\"ag_manage_content\":true,\"ag_manage_set_content\":true,\"ag_manage_tools\":true,\"ag_export\":true,\"ag_import\":true,\"ag_hard_reset\":true,\"edit_membership_plan\":true,\"read_membership_plan\":true,\"delete_membership_plan\":true,\"edit_membership_plans\":true,\"edit_others_membership_plans\":true,\"delete_membership_plans\":true,\"publish_membership_plans\":true,\"read_private_membership_plans\":true,\"delete_private_membership_plans\":true,\"delete_published_membership_plans\":true,\"delete_others_membership_plans\":true,\"edit_private_membership_plans\":true,\"edit_published_membership_plans\":true,\"edit_user_membership\":true,\"read_user_membership\":true,\"delete_user_membership\":true,\"edit_user_memberships\":true,\"edit_others_user_memberships\":true,\"delete_user_memberships\":true,\"publish_user_memberships\":true,\"read_private_user_memberships\":true,\"delete_private_user_memberships\":true,\"delete_published_user_memberships\":true,\"delete_others_user_memberships\":true,\"edit_private_user_memberships\":true,\"edit_published_user_memberships\":true,\"manage_woocommerce_membership_plans\":true,\"manage_woocommerce_user_memberships\":true,\"wpcode_edit_snippets\":true,\"wpcode_activate_snippets\":true,\"delete_szbdzones\":true,\"delete_others_szbdzones\":true,\"delete_private_szbdzones\":true,\"delete_published_szbdzones\":true,\"edit_szbdzones\":true,\"edit_others_szbdzones\":true,\"edit_private_szbdzones\":true,\"edit_published_szbdzones\":true,\"publish_szbdzones\":true,\"read_private_szbdzones\":true,\"administrator\":true},\"filter\":null}','{\"id\":1,\"date_created\":{\"date\":\"2022-02-15 21:27:30.000000\",\"timezone_type\":3,\"timezone\":\"America\\/Chicago\"},\"date_modified\":{\"date\":\"2023-06-13 13:17:15.000000\",\"timezone_type\":3,\"timezone\":\"America\\/Chicago\"},\"email\":\"wordpress@fallstech.group\",\"first_name\":\"Falls Tech Group\",\"last_name\":\"System Administrator\",\"display_name\":\"ftgadmin\",\"role\":\"administrator\",\"username\":\"ftgadmin\",\"billing\":{\"first_name\":\"Ryan\",\"last_name\":\"Reiffenberger\",\"company\":\"\",\"address_1\":\"3200 South Westbrooke Lane\",\"address_2\":\"#100\",\"city\":\"Sioux Falls\",\"postcode\":\"57106\",\"country\":\"US\",\"state\":\"SD\",\"email\":\"ryan@ftghost.net\",\"phone\":\"6053107208\"},\"shipping\":{\"first_name\":\"Ryan\",\"last_name\":\"Reiffenberger\",\"company\":\"\",\"address_1\":\"3200 South Westbrooke Lane\",\"address_2\":\"#100\",\"city\":\"Sioux Falls\",\"postcode\":\"57106\",\"country\":\"US\",\"state\":\"SD\",\"phone\":\"605-310-7208\"},\"is_paying_customer\":true,\"meta_data\":[{\"id\":18,\"key\":\"community-events-location\",\"value\":{\"ip\":\"24.124.43.0\"}},{\"id\":20,\"key\":\"fl_assistant_state\",\"value\":{\"appOrder\":[],\"window\":{\"origin\":[1,0],\"width\":520,\"isHidden\":true,\"hiddenAppearance\":\"\"},\"appearance\":{\"brightness\":\"light\"},\"history\":{\"index\":4,\"entries\":[{\"pathname\":\"\\/fl-home\",\"search\":\"\",\"hash\":\"\",\"key\":\"i66ly9\"},{\"pathname\":\"\\/libraries\",\"search\":\"\",\"hash\":\"\",\"key\":\"y3dno6\"},{\"pathname\":\"\\/libraries\\/2402\",\"search\":\"\",\"hash\":\"\",\"key\":\"n9mgeg\"},{\"pathname\":\"\\/libraries\",\"search\":\"\",\"hash\":\"\",\"key\":\"skm04i\"},{\"pathname\":\"\\/fl-cloud-connect\",\"search\":\"\",\"hash\":\"\",\"key\":\"6zdvj2\"}]},\"searchHistory\":[],\"shouldShowInAdmin\":true,\"isAppHidden\":false,\"shortcuts\":[]}},{\"id\":21,\"key\":\"_fl_builder_launched\",\"value\":\"1\"},{\"id\":22,\"key\":\"_yoast_wpseo_profile_updated\",\"value\":\"1644965414\"},{\"id\":24,\"key\":\"fl_builder_user_settings\",\"value\":{\"skin\":\"light\",\"lightbox\":{\"width\":\"821\",\"height\":\"816\",\"top\":\"9px\",\"left\":\"926px\"},\"pinned\":{\"width\":\"380\",\"position\":\"\"}}},{\"id\":28,\"key\":\"managenav-menuscolumnshidden\",\"value\":[\"link-target\",\"css-classes\",\"xfn\",\"description\",\"title-attribute\"]},{\"id\":31,\"key\":\"wc_last_active\",\"value\":\"1700352000\"},{\"id\":34,\"key\":\"nav_menu_recently_edited\",\"value\":\"7\"},{\"id\":35,\"key\":\"spbc_browser_sign\",\"value\":\"8bd719fbb0f6839b399be1b2514f1a0b\"},{\"id\":36,\"key\":\"spbc_browser_sign__updated\",\"value\":\"1672873470\"},{\"id\":37,\"key\":\"spbc_user_agent\",\"value\":\"Mozilla\\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\\/537.36 (KHTML, like Gecko) Chrome\\/108.0.0.0 Safari\\/537.36\"},{\"id\":69,\"key\":\"_wcs_subscription_ids_cache\",\"value\":[]},{\"id\":270,\"key\":\"meta-box-order_product\",\"value\":{\"side\":\"age_gate,submitdiv,postimagediv,woocommerce-product-images,product_catdiv,tagsdiv-product_tag\",\"normal\":\"woocommerce-product-data,aioseo-settings,postcustom,slugdiv,postexcerpt,wc-memberships-product-memberships-data\",\"advanced\":\"\"}},{\"id\":271,\"key\":\"screen_layout_product\",\"value\":\"2\"},{\"id\":343,\"key\":\"meta-box-order_shop_order\",\"value\":{\"side\":\"woocommerce-order-actions,litespeed_meta_boxes,wcusage_affiliate_info,woo-order-auto-print-meta\",\"normal\":\"woocommerce-order-data,woocommerce-order-items,woocommerce-order-downloads,postcustom\",\"advanced\":\"woocommerce-order-notes\"}},{\"id\":344,\"key\":\"screen_layout_shop_order\",\"value\":\"2\"},{\"id\":345,\"key\":\"_wc_plugin_framework_square_dismissed_messages\",\"value\":{\"connect\":true,\"wc-square-apple-pay-file-missing\":true,\"set-location\":true}},{\"id\":384,\"key\":\"shipping_method\",\"value\":[\"local_pickup:8\"]},{\"id\":415,\"key\":\"jetpack_tracks_wpcom_id\",\"value\":\"130672632\"},{\"id\":418,\"key\":\"edit_shop_order_per_page\",\"value\":\"20\"},{\"id\":436,\"key\":\"account_status\",\"value\":\"approved\"},{\"id\":437,\"key\":\"um_member_directory_data\",\"value\":{\"account_status\":\"approved\",\"hide_in_members\":false,\"profile_photo\":false,\"cover_photo\":false,\"verified\":false}},{\"id\":445,\"key\":\"um_user_profile_url_slug_user_login\",\"value\":\"ftgadmin\"},{\"id\":491,\"key\":\"woocommerce_admin_task_list_tracked_started_tasks\",\"value\":\"{\\\"marketing\\\":1,\\\"appearance\\\":1}\"},{\"id\":565,\"key\":\"dismissed_update_notice\",\"value\":\"1\"},{\"id\":566,\"key\":\"dismissed_download_directories_sync_complete_notice\",\"value\":\"1\"},{\"id\":584,\"key\":\"wc_pb_dismissed_notices\",\"value\":[\"welcome\"]},{\"id\":596,\"key\":\"pp_lite_review_dismiss\",\"value\":\"true\"},{\"id\":682,\"key\":\"edit_page_per_page\",\"value\":\"20\"},{\"id\":692,\"key\":\"activecampaign_for_woocommerce_ac_customer_id\",\"value\":\"1\"},{\"id\":763,\"key\":\"_aioseo_plugin_review_dismissed\",\"value\":\"3\"},{\"id\":811,\"key\":\"tgmpa_dismissed_notice_wpcore\",\"value\":\"1\"},{\"id\":815,\"key\":\"_wc_memberships_show_admin_restricted_content_notice\",\"value\":\"no\"},{\"id\":861,\"key\":\"edit_product_per_page\",\"value\":\"100\"},{\"id\":862,\"key\":\"_wc_square_credit_card_payment_tokens\",\"value\":[]},{\"id\":863,\"key\":\"wc_square_customer_id\",\"value\":\"\"},{\"id\":866,\"key\":\"aioseo_profiles_same_username\",\"value\":{\"enable\":false,\"username\":\"\",\"included\":[\"facebookPageUrl\",\"twitterUrl\",\"pinterestUrl\",\"instagramUrl\",\"youtubeUrl\",\"linkedinUrl\"]}},{\"id\":867,\"key\":\"aioseo_facebook_page_url\",\"value\":\"\"},{\"id\":868,\"key\":\"aioseo_twitter_url\",\"value\":\"\"},{\"id\":869,\"key\":\"aioseo_instagram_url\",\"value\":\"\"},{\"id\":870,\"key\":\"aioseo_pinterest_url\",\"value\":\"\"},{\"id\":871,\"key\":\"aioseo_youtube_url\",\"value\":\"\"},{\"id\":872,\"key\":\"aioseo_linkedin_url\",\"value\":\"\"},{\"id\":873,\"key\":\"aioseo_tumblr_url\",\"value\":\"\"},{\"id\":874,\"key\":\"aioseo_yelp_page_url\",\"value\":\"\"},{\"id\":875,\"key\":\"aioseo_sound_cloud_url\",\"value\":\"\"},{\"id\":876,\"key\":\"aioseo_wikipedia_url\",\"value\":\"\"},{\"id\":877,\"key\":\"aioseo_myspace_url\",\"value\":\"\"},{\"id\":878,\"key\":\"aioseo_profiles_additional_urls\",\"value\":\"\"},{\"id\":882,\"key\":\"_wc_plugin_framework_memberships_dismissed_messages\",\"value\":{\"membership-plan-created\":true,\"user-membership-created\":true}},{\"id\":1021,\"key\":\"wds_dismissed_messages\",\"value\":{\"yoast-seo-import\":true}},{\"id\":1030,\"key\":\"woocommerce_admin_variable_product_tour_shown\",\"value\":\"\\\"yes\\\"\"},{\"id\":1031,\"key\":\"activecampaign_for_woocommerce_external_checkout_id\",\"value\":\"6488bdf902acf3.24846116\"},{\"id\":1032,\"key\":\"wpcode_snippet_activate_notice_shown\",\"value\":\"1\"}]}','{\"6239cf5800c8a13bf8f8d994a94979f5\":{\"key\":\"6239cf5800c8a13bf8f8d994a94979f5\",\"product_id\":2365,\"variation_id\":2366,\"variation\":{\"attribute_pa_gift-00-flower\":\"flower-7-grams\"},\"quantity\":2,\"data_hash\":\"d4815fca7d03ac994a9ed75af2e71fda\",\"line_tax_data\":{\"subtotal\":{\"2\":2.1699999999999999289457264239899814128875732421875},\"total\":{\"2\":2.1699999999999999289457264239899814128875732421875}},\"line_subtotal\":35,\"line_subtotal_tax\":2.1699999999999999289457264239899814128875732421875,\"line_total\":35,\"line_tax\":2.1699999999999999289457264239899814128875732421875,\"data\":{}}}','{\"subtotal\":\"70\",\"subtotal_tax\":4.339999999999999857891452847979962825775146484375,\"shipping_total\":\"0\",\"shipping_tax\":0,\"shipping_taxes\":[],\"discount_total\":0,\"discount_tax\":0,\"cart_contents_total\":\"70\",\"cart_contents_tax\":4.339999999999999857891452847979962825775146484375,\"cart_contents_taxes\":{\"2\":4.339999999999999857891452847979962825775146484375},\"fee_total\":\"0\",\"fee_tax\":0,\"fee_taxes\":[],\"total\":\"74.34\",\"total_tax\":4.339999999999999857891452847979962825775146484375}','{\"518a462f86859887b90a6e105c18c141\":{\"key\":\"518a462f86859887b90a6e105c18c141\",\"product_id\":1615,\"variation_id\":1865,\"variation\":{\"attribute_pa_gift-00-pre-roll\":\"gift-1-gram-pre-roll\"},\"quantity\":10,\"data_hash\":\"2532100d29a9ee73053b6872ea5c3079\",\"line_tax_data\":{\"subtotal\":{\"2\":3.100000000000000088817841970012523233890533447265625},\"total\":{\"2\":3.100000000000000088817841970012523233890533447265625}},\"line_subtotal\":50,\"line_subtotal_tax\":3.100000000000000088817841970012523233890533447265625,\"line_total\":50,\"line_tax\":3.100000000000000088817841970012523233890533447265625}}','655951f459d230.75401673','fda1a8e40e01f16d86a689fe66851fcc',NULL,'12','2023-11-19 01:08:38','1');


