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

CREATE TABLE `wp_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',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

INSERT INTO `wp_term_relationships` VALUES (1,1,0),(14,18,0),(14,22,0),(15,19,0),(15,22,0),(79,4,0),(79,8,0),(79,28,0),(79,31,0),(79,40,0),(79,43,0),(79,44,0),(79,47,0),(86,2,0),(86,28,0),(86,42,0),(86,44,0),(86,47,0),(86,49,0),(95,2,0),(95,28,0),(95,30,0),(95,47,0),(109,2,0),(109,8,0),(109,28,0),(109,47,0),(112,2,0),(112,31,0),(112,39,0),(115,2,0),(115,36,0),(115,39,0),(121,2,0),(121,29,0),(121,39,0),(132,4,0),(132,29,0),(132,31,0),(132,36,0),(132,39,0),(132,40,0),(142,4,0),(142,29,0),(142,31,0),(142,36,0),(142,39,0),(142,44,0),(157,2,0),(157,28,0),(157,47,0),(160,4,0),(160,8,0),(160,28,0),(160,30,0),(160,31,0),(160,32,0),(160,44,0),(160,47,0),(169,4,0),(169,8,0),(169,28,0),(169,29,0),(169,36,0),(169,44,0),(169,47,0),(194,2,0),(194,37,0),(194,38,0),(194,46,0),(194,47,0),(194,48,0),(209,4,0),(209,31,0),(209,36,0),(209,37,0),(209,38,0),(209,40,0),(209,47,0),(209,48,0),(209,49,0),(210,4,0),(210,31,0),(210,37,0),(210,38,0),(210,40,0),(210,43,0),(210,47,0),(210,48,0),(210,49,0),(211,4,0),(211,29,0),(211,31,0),(211,36,0),(211,37,0),(211,38,0),(211,40,0),(211,43,0),(211,47,0),(211,48,0),(212,4,0),(212,31,0),(212,36,0),(212,37,0),(212,38,0),(212,47,0),(229,2,0),(229,8,0),(229,23,0),(229,24,0),(229,25,0),(229,26,0),(229,31,0),(229,47,0),(242,2,0),(242,23,0),(242,24,0),(242,25,0),(242,26,0),(242,31,0),(242,47,0),(247,2,0),(247,8,0),(247,23,0),(247,24,0),(247,25,0),(247,26,0),(247,31,0),(247,35,0),(247,47,0),(252,2,0),(252,8,0),(252,23,0),(252,24,0),(252,25,0),(252,26,0),(252,31,0),(252,47,0),(266,52,0),(267,52,0),(307,2,0),(307,30,0),(307,39,0),(316,4,0),(316,29,0),(316,31,0),(316,36,0),(316,39,0),(316,44,0),(324,2,0),(324,24,0),(324,25,0),(324,26,0),(324,27,0),(324,31,0),(324,39,0),(340,2,0),(340,24,0),(340,25,0),(340,26,0),(340,27,0),(340,30,0),(340,39,0),(345,2,0),(345,24,0),(345,25,0),(345,26,0),(345,27,0),(345,31,0),(345,39,0),(349,2,0),(349,8,0),(349,24,0),(349,25,0),(349,26,0),(349,27,0),(349,31,0),(349,39,0),(360,4,0),(360,8,0),(360,31,0),(360,36,0),(360,39,0),(360,44,0),(361,2,0),(361,31,0),(361,39,0),(361,44,0),(362,2,0),(362,8,0),(362,39,0),(375,4,0),(375,29,0),(375,31,0),(375,36,0),(375,44,0),(375,47,0),(387,53,0),(388,53,0),(389,53,0),(423,53,0),(425,53,0),(659,51,0),(660,51,0),(661,51,0),(662,51,0),(663,51,0),(665,50,0),(666,50,0),(667,50,0),(668,50,0),(669,50,0),(671,52,0),(3917,54,0),(4430,55,0),(4491,52,0),(4501,54,0),(4575,54,0),(4576,54,0),(4579,54,0),(4584,54,0),(4608,2,0),(4608,14,0),(4608,28,0),(4619,1,0),(4621,56,0),(4623,56,0),(4630,2,0),(4630,14,0),(4630,28,0),(4632,2,0),(4632,14,0),(4632,28,0),(4649,2,0),(4649,14,0),(4649,28,0);

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

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

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

INSERT INTO `wp_term_taxonomy` VALUES (1,1,'category','',0,1),(2,2,'product_type','',0,4),(3,3,'product_type','',0,0),(4,4,'product_type','',0,0),(5,5,'product_type','',0,0),(6,6,'product_visibility','',0,0),(7,7,'product_visibility','',0,0),(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,4),(15,15,'product_cat','',0,0),(16,16,'cartflows_step_type','',0,0),(17,17,'cartflows_step_type','',0,0),(18,18,'cartflows_step_type','',0,1),(19,19,'cartflows_step_type','',0,1),(20,20,'cartflows_step_type','',0,0),(21,21,'cartflows_step_type','',0,0),(22,22,'cartflows_step_flow','',0,2),(23,23,'pa_size','',0,0),(24,24,'pa_size','',0,0),(25,25,'pa_size','',0,0),(26,26,'pa_size','',0,0),(27,27,'pa_size','',0,0),(28,28,'product_cat','\r\n\r\nNam nec tellus a odio tincidunt auctor a ornare odio. Sed non mauris vitae erat consequat auctor eu in elit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Mauris in erat justo. Nullam ac urna eu felis dapibus condimentum sit amet a augue. Sed non neque elit sed ut.\r\n\r\n\r\n',0,4),(29,29,'pa_color','',0,0),(30,30,'pa_color','',0,0),(31,31,'pa_color','',0,0),(32,32,'pa_color','',0,0),(33,33,'pa_color','',0,0),(34,34,'pa_color','',0,0),(35,35,'pa_color','',0,0),(36,36,'pa_color','',0,0),(37,37,'pa_size','',0,0),(38,38,'pa_size','',0,0),(39,39,'product_cat','\r\n\r\n\r\nNam nec tellus a odio tincidunt auctor a ornare odio. Sed non mauris vitae erat consequat auctor eu in elit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Mauris in erat justo. Nullam ac urna eu felis dapibus condimentum sit amet a augue. Sed non neque elit sed ut.\r\n\r\n\r\n',0,0),(40,40,'pa_color','',0,0),(41,41,'elementor_library_type','',0,0),(42,42,'pa_color','',0,0),(43,43,'pa_color','',0,0),(44,44,'pa_color','',0,0),(45,45,'elementor_library_type','',0,0),(46,46,'pa_color','',0,0),(47,47,'product_cat','\r\nNam nec tellus a odio tincidunt auctor a ornare odio. Sed non mauris vitae erat consequat auctor eu in elit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Mauris in erat justo. Nullam ac urna eu felis dapibus condimentum sit amet a augue. Sed non neque elit sed ut.\r\n\r\n\r\n',0,0),(48,48,'pa_size','',0,0),(49,49,'pa_color','',0,0),(50,50,'nav_menu','',0,5),(51,51,'nav_menu','',0,5),(52,52,'nav_menu','',0,4),(53,53,'nav_menu','',0,5),(54,54,'nav_menu','',0,6),(55,55,'wp_theme','',0,1),(56,56,'elementor_library_type','',0,0);

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

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

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

INSERT INTO `wp_termmeta` VALUES (1,23,'_astra_sites_imported_term','1'),(2,24,'_astra_sites_imported_term','1'),(3,25,'_astra_sites_imported_term','1'),(4,26,'_astra_sites_imported_term','1'),(5,27,'_astra_sites_imported_term','1'),(6,28,'order','0'),(7,28,'_astra_sites_imported_term','1'),(8,29,'_astra_sites_imported_term','1'),(9,30,'_astra_sites_imported_term','1'),(10,31,'_astra_sites_imported_term','1'),(11,32,'_astra_sites_imported_term','1'),(12,33,'_astra_sites_imported_term','1'),(13,34,'_astra_sites_imported_term','1'),(14,35,'_astra_sites_imported_term','1'),(15,36,'_astra_sites_imported_term','1'),(16,37,'_astra_sites_imported_term','1'),(17,38,'_astra_sites_imported_term','1'),(18,39,'order','0'),(19,39,'_astra_sites_imported_term','1'),(20,40,'_astra_sites_imported_term','1'),(21,41,'_astra_sites_imported_term','1'),(22,42,'_astra_sites_imported_term','1'),(23,43,'_astra_sites_imported_term','1'),(24,44,'_astra_sites_imported_term','1'),(25,45,'_astra_sites_imported_term','1'),(26,46,'_astra_sites_imported_term','1'),(27,47,'order','0'),(28,47,'_astra_sites_imported_term','1'),(29,48,'_astra_sites_imported_term','1'),(30,49,'_astra_sites_imported_term','1'),(31,50,'_astra_sites_imported_term','1'),(32,51,'_astra_sites_imported_term','1'),(33,52,'_astra_sites_imported_term','1'),(34,53,'_astra_sites_imported_term','1'),(35,54,'_astra_sites_imported_term','1'),(36,28,'product_count_product_cat','4'),(37,47,'product_count_product_cat','0'),(38,39,'product_count_product_cat','0'),(39,39,'thumbnail_id','499'),(40,47,'thumbnail_id','4468'),(41,28,'display_type',''),(42,28,'thumbnail_id','4469'),(43,47,'display_type','');

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

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

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

INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',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,'Uncategorized','uncategorized',0),(16,'Landing','landing',0),(17,'Optin (Woo)','optin',0),(18,'Checkout (Woo)','checkout',0),(19,'Thank You (Woo)','thankyou',0),(20,'Upsell (Woo)','upsell',0),(21,'Downsell (Woo)','downsell',0),(22,'flow-13','flow-13',0),(23,'30','30',0),(24,'32','32',0),(25,'34','34',0),(26,'36','36',0),(27,'38','38',0),(28,'SKIN CARE','skin-care',0),(29,'Aqua','aqua',0),(30,'Black','black',0),(31,'Blue','blue',0),(32,'Brown','brown',0),(33,'Dark Green','dark-green',0),(34,'Dark Purple','dark-purple',0),(35,'Gray','gray',0),(36,'Green','green',0),(37,'L','l',0),(38,'M','m',0),(39,'M. DEVICE','m-device',0),(40,'Orange','orange',0),(41,'page','page',0),(42,'Pink','pink',0),(43,'Purple','purple',0),(44,'Red','red',0),(45,'section','section',0),(46,'White','white',0),(47,'NUTRITION','nutrition',0),(48,'XL','xl',0),(49,'Yellow','yellow',0),(50,'For Her','for-her',0),(51,'For Him','for-him',0),(52,'Main Menu','main-menu',0),(53,'Quick Links','quick-links',0),(54,'Secondary Menu','secondary-menu',0),(55,'astra','astra',0),(56,'product','product',0);

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

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

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



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

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

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

INSERT INTO `wp_users` VALUES (1,'mars2029','$P$BlYNWQP8h8FAyPrgIDgn1JbaxKCGmH.','mars2029','mars2029kr@gmail.com','https://usa.ugenebio.com','2023-09-17 02:27:20','',0,'mars2029'),(7,'ugenebio','$P$B/bzwbx0Ez1uoOUempPNz3JOVWuxST0','ugenebio','support@ugenebio.com','','2023-09-24 07:03:13','1695538993:$P$BQlkDyPqZMIgtLMDV4d06uTcydbxqL.',0,'ugenebio'),(8,'seokwon00','$P$BjxtUIYv5NrM6r147eB0FjVpFbHldc.','seokwon00','kimseokwon00@gmail.com','','2023-09-26 04:06:16','1695701176:$P$BtP29TnoG7Wls3OgUCCTLAntMIQY.X.',0,'seokwon00'),(9,'Seokwon000','$P$BEP8apWugcmrAp1MKuWymRzZgdZYaH1','seokwon000','abraham.kim@operion.us','','2023-09-26 05:03:04','1695704585:$P$B1ti86omOZloMNB5mnozU9gG8SiNxG1',0,'Seokwon000'),(10,'marstest','$P$B1O1wQu3QboioX/KUDSlPn1D2jF28s0','marstest','jnkim184@gmail.com','','2023-10-02 17:35:28','1696268128:$P$Bo25r7MQOkuSoLE97MZkahS8sYns1j/',0,'marstest'),(11,'test1','$P$Ba4z/5ANNAhOMYBDWEa7kKDyMfj.0/1','test1','test1@asd.com','','2023-10-06 15:30:23','1696606223:$P$BRqIcxPGqaTpePT.OwVp3beC5kIV2F0',0,'test1'),(12,'test2','$P$BtUXYHad6XOd50nfYByiyW.y50g4y0.','test2','test2mars2029@asdfg.com','','2023-10-06 22:45:20','1696632320:$P$B1c3MVWmoy9jfaa/SLGa2E/VOCLBPY.',0,'test2'),(13,'test3','$P$BJuIiGm7YzVUrYqgbBuRM7H2syWj1C.','test3','tset@gamc.com','','2023-10-07 00:49:01','1696639741:$P$BljYrdUZxkLpgV6fKfmXm26H.gliFq.',0,'test3'),(14,'test4','$P$BScJx0cPTWvaqf0PhhmsA0Hg60u18J/','test4','test@gad.com','','2023-10-07 02:12:13','1696644733:$P$BhMyvxZ864a82Z4HJftTKHtBnrdaw20',0,'test4'),(15,'test1_1','$P$BWabYPOOaRy8jbixVHLL8TwXJj4wIf/','test1_1','test123@agasd.com','','2023-10-07 02:13:18','1696644798:$P$BlGMXm.RXlYG9A.4ms10kikO0lYubv0',0,'test1_1'),(16,'test5','$P$BhDTfQCoTh5L40QqTTlobNRilI1aLy1','test5','test2@gmail.com','','2023-10-07 05:04:24','1696655064:$P$BjpybV2PWp8WZkOU2WNiriV6Mqeb1v0',0,'test5'),(17,'test10','$P$BZiVKGp3VHpX9RqJaosCmHBdARIovp/','test10','test20@gma.com','','2023-10-10 05:07:45','1696914465:$P$BVXh45h29mwQjAz3yj0ja1SRG6qCRJ/',0,'test10');

--
-- Table structure for table `wp_wc_admin_note_actions`
--

CREATE TABLE `wp_wc_admin_note_actions` (
  `action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `note_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `query` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `actioned_text` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `nonce_action` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `nonce_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`action_id`),
  KEY `note_id` (`note_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9654 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_admin_note_actions`
--

INSERT INTO `wp_wc_admin_note_actions` VALUES (603,58,'visit-the-theme-marketplace','Visit the theme marketplace','https://woocommerce.com/product-category/themes/?utm_source=inbox&utm_medium=product','actioned','',NULL,NULL),(604,59,'day-after-first-product','Learn more','https://woocommerce.com/document/woocommerce-customizer/?utm_source=inbox&utm_medium=product','actioned','',NULL,NULL),(691,60,'connect','Connect','?page=wc-addons&section=helper','unactioned','',NULL,NULL),(950,61,'learn-more','Learn more','https://woocommerce.com/posts/pre-launch-checklist-the-essentials/?utm_source=inbox&utm_medium=product','actioned','',NULL,NULL),(951,62,'learn-more','Learn more','https://woocommerce.com/mobile/?utm_medium=product','actioned','',NULL,NULL),(1220,66,'view-payment-gateways','Learn more','https://woocommerce.com/product-category/woocommerce-extensions/payment-gateways/?utm_medium=product','actioned','',NULL,NULL),(2212,68,'tracking-opt-in','Activate usage tracking','','actioned','',NULL,NULL),(2305,70,'learn-more','Learn more','https://woocommerce.com/document/managing-orders/?utm_source=inbox&utm_medium=product','actioned','',NULL,NULL),(7798,69,'learn-more','Learn more','https://woocommerce.com/payments/?utm_medium=product','unactioned','',NULL,NULL),(7799,69,'get-started','Get started','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-admin&action=setup-woocommerce-payments','actioned','','setup-woocommerce-payments',''),(8055,63,'wc_admin_BNPL_WCPay_Q3_2023','Enable buy now, pay later','https://woocommerce.com/?post_type=documentation&p=18734002212927&preview=true&utm_source=inbox_note&utm_medium=product&utm_campaign=wc_admin_BNPL_WCPay_Q3_2023','actioned','',NULL,NULL),(8056,64,'wc_admin_afterpay_WCPay_Q3_2023','Enable buy now, pay later','https://woocommerce.com/?post_type=documentation&p=18734002212927&preview=true&utm_source=inbox_note&utm_medium=product&utm_campaign=wc_admin_afterpay_WCPay_Q3_2023','actioned','',NULL,NULL),(9566,1,'wayflyer_bnpl_q4_2021','Level up with funding','https://woocommerce.com/products/wayflyer/?utm_source=inbox_note&utm_medium=product&utm_campaign=wayflyer_bnpl_q4_2021','actioned','',NULL,NULL),(9567,2,'wc_shipping_mobile_app_usps_q4_2021','Get WooCommerce Shipping','https://woocommerce.com/woocommerce-shipping/?utm_source=inbox_note&utm_medium=product&utm_campaign=wc_shipping_mobile_app_usps_q4_2021','actioned','',NULL,NULL),(9568,3,'learn-more','Learn more','https://docs.woocommerce.com/document/woocommerce-shipping-and-tax/?utm_source=inbox','unactioned','',NULL,NULL),(9569,4,'learn-more','Learn more','https://woocommerce.com/posts/ecommerce-shipping-solutions-guide/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','actioned','',NULL,NULL),(9570,5,'optimizing-the-checkout-flow','Learn more','https://woocommerce.com/posts/optimizing-woocommerce-checkout?utm_source=inbox_note&utm_medium=product&utm_campaign=optimizing-the-checkout-flow','actioned','',NULL,NULL),(9571,6,'qualitative-feedback-from-new-users','Share feedback','https://automattic.survey.fm/wc-pay-new','actioned','',NULL,NULL),(9572,7,'share-feedback','Share feedback','http://automattic.survey.fm/paypal-feedback','unactioned','',NULL,NULL),(9573,8,'get-started','Get started','https://woocommerce.com/products/google-listings-and-ads?utm_source=inbox_note&utm_medium=product&utm_campaign=get-started','actioned','',NULL,NULL),(9574,9,'update-wc-subscriptions-3-0-15','View latest version','https://usa.ugenebio.com/wp-admin/&page=wc-addons&section=helper','actioned','',NULL,NULL),(9575,10,'update-wc-core-5-4-0','How to update WooCommerce','https://docs.woocommerce.com/document/how-to-update-woocommerce/','actioned','',NULL,NULL),(9576,13,'ppxo-pps-install-paypal-payments-1','View upgrade guide','https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/','actioned','',NULL,NULL),(9577,14,'ppxo-pps-install-paypal-payments-2','View upgrade guide','https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/','actioned','',NULL,NULL),(9578,15,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','unactioned','',NULL,NULL),(9579,15,'dismiss','Dismiss','','actioned','',NULL,NULL),(9580,16,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','unactioned','',NULL,NULL),(9581,16,'dismiss','Dismiss','','actioned','',NULL,NULL),(9582,17,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','unactioned','',NULL,NULL),(9583,17,'dismiss','Dismiss','','actioned','',NULL,NULL),(9584,18,'learn-more','Learn more','https://woocommerce.com/posts/critical-vulnerability-detected-july-2021/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more','unactioned','',NULL,NULL),(9585,18,'dismiss','Dismiss','','actioned','',NULL,NULL),(9586,19,'share-feedback','Share feedback','https://automattic.survey.fm/store-management','unactioned','',NULL,NULL),(9587,20,'learn-more','Learn more','https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/','unactioned','',NULL,NULL),(9588,20,'woocommerce-core-paypal-march-2022-dismiss','Dismiss','','actioned','',NULL,NULL),(9589,21,'learn-more','Learn more','https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/','unactioned','',NULL,NULL),(9590,21,'dismiss','Dismiss','','actioned','',NULL,NULL),(9591,22,'pinterest_03_2022_update','Update Instructions','https://woocommerce.com/document/pinterest-for-woocommerce/?utm_source=inbox_note&utm_medium=product&utm_campaign=pinterest_03_2022_update#section-3','actioned','',NULL,NULL),(9592,23,'store_setup_survey_survey_q2_2022_share_your_thoughts','Tell us how it’s going','https://automattic.survey.fm/store-setup-survey-2022','actioned','',NULL,NULL),(9593,24,'learn-more','Find out more','https://developer.woocommerce.com/2022/08/09/woocommerce-payments-3-9-4-4-5-1-security-releases/','unactioned','',NULL,NULL),(9594,24,'dismiss','Dismiss','','actioned','',NULL,NULL),(9595,25,'learn-more','Find out more','https://developer.woocommerce.com/2022/08/09/woocommerce-payments-3-9-4-4-5-1-security-releases/','unactioned','',NULL,NULL),(9596,25,'dismiss','Dismiss','','actioned','',NULL,NULL),(9597,26,'needs-update-eway-payment-gateway-rin-action-button-2022-12-20','See available updates','https://usa.ugenebio.com/wp-admin/update-core.php','unactioned','',NULL,NULL),(9598,26,'needs-update-eway-payment-gateway-rin-dismiss-button-2022-12-20','Dismiss','#','actioned','',NULL,NULL),(9599,27,'updated-eway-payment-gateway-rin-action-button-2022-12-20','See all updates','https://usa.ugenebio.com/wp-admin/update-core.php','unactioned','',NULL,NULL),(9600,27,'updated-eway-payment-gateway-rin-dismiss-button-2022-12-20','Dismiss','#','actioned','',NULL,NULL),(9601,28,'share-navigation-survey-feedback','Share feedback','https://automattic.survey.fm/new-ecommerce-plan-navigation','actioned','',NULL,NULL),(9602,29,'woopay-beta-merchantrecruitment-activate-04MAY23','Activate WooPay','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','actioned','',NULL,NULL),(9603,29,'woopay-beta-merchantrecruitment-activate-learnmore-04MAY23','Learn More','https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-activate-learnmore-04MAY23','unactioned','',NULL,NULL),(9604,30,'woocommerce-wcpay-march-2023-update-needed-button','See Blog Post','https://developer.woocommerce.com/2023/03/23/critical-vulnerability-detected-in-woocommerce-payments-what-you-need-to-know','unactioned','',NULL,NULL),(9605,30,'woocommerce-wcpay-march-2023-update-needed-dismiss-button','Dismiss','#','actioned','',NULL,NULL),(9606,31,'tap_to_pay_iphone_q2_2023_no_wcpay','Simplify my payments','https://woocommerce.com/products/woocommerce-payments/?utm_source=inbox_note&utm_medium=product&utm_campaign=tap_to_pay_iphone_q2_2023_no_wcpay','actioned','',NULL,NULL),(9607,32,'extension-settings','See available updates','https://usa.ugenebio.com/wp-admin/update-core.php','unactioned','',NULL,NULL),(9608,32,'dismiss','Dismiss','#','actioned','',NULL,NULL),(9609,33,'woopay-beta-merchantrecruitment-update-WCPay-04MAY23','Update WooCommerce Payments','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','unactioned','',NULL,NULL),(9610,33,'woopay-beta-merchantrecruitment-update-activate-04MAY23','Activate WooPay','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','actioned','',NULL,NULL),(9611,34,'woopay-beta-existingmerchants-noaction-documentation-27APR23','Documentation','https://woocommerce.com/document/woopay-merchant-documentation/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-existingmerchants-noaction-documentation-27APR23','actioned','',NULL,NULL),(9612,35,'woopay-beta-existingmerchants-update-WCPay-27APR23','Update WooCommerce Payments','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','actioned','',NULL,NULL),(9613,36,'woopay-beta-merchantrecruitment-short-activate-04MAY23','Activate WooPay','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','actioned','',NULL,NULL),(9614,36,'woopay-beta-merchantrecruitment-short-activate-learnmore-04MAY23','Learn More','https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-04MAY23','actioned','',NULL,NULL),(9615,37,'woopay-beta-merchantrecruitment-short-update-WCPay-04MAY23','Update WooCommerce Payments','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','unactioned','',NULL,NULL),(9616,37,'woopay-beta-merchantrecruitment-short-update-activate-04MAY23','Activate WooPay','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','actioned','',NULL,NULL),(9617,38,'woopay-beta-merchantrecruitment-short-activate-06MAY23-TESTA','Activate WooPay Test A','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','unactioned','',NULL,NULL),(9618,38,'woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTA','Learn More','https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTA','unactioned','',NULL,NULL),(9619,39,'woopay-beta-merchantrecruitment-short-activate-06MAY23-TESTB','Activate WooPay Test B','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','unactioned','',NULL,NULL),(9620,39,'woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTA','Learn More','https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTA','unactioned','',NULL,NULL),(9621,40,'woopay-beta-merchantrecruitment-short-activate-06MAY23-TESTC','Activate WooPay Test C','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','unactioned','',NULL,NULL),(9622,40,'woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTC','Learn More','https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTC','unactioned','',NULL,NULL),(9623,41,'woopay-beta-merchantrecruitment-short-activate-06MAY23-TESTD','Activate WooPay Test D','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','unactioned','',NULL,NULL),(9624,41,'woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTD','Learn More','https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-06MAY23-TESTD','unactioned','',NULL,NULL),(9625,42,'woopay-beta-merchantrecruitment-short-activate-button-09MAY23','Activate WooPay','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','unactioned','',NULL,NULL),(9626,42,'woopay-beta-merchantrecruitment-short-activate-learnmore-button2-09MAY23','Learn More','https://woocommerce.com/woopay-businesses/?utm_source=inbox_note&utm_medium=product&utm_campaign=woopay-beta-merchantrecruitment-short-activate-learnmore-button2-09MAY23','unactioned','',NULL,NULL),(9627,43,'woopay-beta-merchantrecruitment-short-update-WCPay-09MAY23','Update WooCommerce Payments','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','unactioned','',NULL,NULL),(9628,43,'woopay-beta-merchantrecruitment-short-update-activate-09MAY23','Activate WooPay','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&method=platform_checkout','unactioned','',NULL,NULL),(9629,44,'woocommerce-WCStripe-May-2023-updated-needed-Plugin-Settings','See available updates','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','unactioned','',NULL,NULL),(9630,44,'woocommerce-WCStripe-May-2023-updated-needed-Plugin-Settings-dismiss','Dismiss','#','actioned','',NULL,NULL),(9631,45,'woocommerce-WCPayments-June-2023-updated-needed-Plugin-Settings','See available updates','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','unactioned','',NULL,NULL),(9632,45,'woocommerce-WCPayments-June-2023-updated-needed-Dismiss','Dismiss','#','actioned','',NULL,NULL),(9633,46,'woocommerce-WCSubscriptions-June-2023-updated-needed-Plugin-Settings','See available updates','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','unactioned','',NULL,NULL),(9634,46,'woocommerce-WCSubscriptions-June-2023-updated-needed-dismiss','Dismiss','#','actioned','',NULL,NULL),(9635,47,'woocommerce-WCReturnsWarranty-June-2023-updated-needed','See available updates','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','unactioned','',NULL,NULL),(9636,47,'woocommerce-WCReturnsWarranty-June-2023-updated-needed','Dismiss','#','actioned','',NULL,NULL),(9637,48,'woocommerce-WCOPC-June-2023-updated-needed','See available updates','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','actioned','',NULL,NULL),(9638,48,'woocommerce-WCOPC-June-2023-updated-needed','Dismiss','https://usa.ugenebio.com/wp-admin/#','actioned','',NULL,NULL),(9639,49,'woocommerce-WCGC-July-2023-update-needed','See available updates','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','unactioned','',NULL,NULL),(9640,49,'woocommerce-WCGC-July-2023-update-needed','Dismiss','#','actioned','',NULL,NULL),(9641,50,'learn-more','Learn more','https://woocommerce.com/document/fedex/?utm_medium=product&utm_source=inbox_note&utm_campaign=learn-more#july-2023-api-outage','unactioned','',NULL,NULL),(9642,51,'plugin-list','See available updates','https://usa.ugenebio.com/wp-admin/plugins.php?plugin_status=all','unactioned','',NULL,NULL),(9643,51,'dismiss','Dismiss','https://usa.ugenebio.com/wp-admin/admin.php?page=wc-admin','actioned','',NULL,NULL),(9644,52,'woocommerce-WCStripe-Aug-2023-update-needed','See available updates','https://usa.ugenebio.com/wp-admin/update-core.php?','unactioned','',NULL,NULL),(9645,52,'dismiss','Dismiss','#','actioned','',NULL,NULL),(9646,53,'dismiss','Dismiss','#','actioned','',NULL,NULL),(9647,54,'woocommerce-WooPayments-Aug-2023-update-needed','See available updates','https://usa.ugenebio.com/wp-admin/update-core.php?','unactioned','',NULL,NULL),(9648,54,'dismiss','Dismiss','#','actioned','',NULL,NULL),(9649,55,'dismiss','Dismiss','#','actioned','',NULL,NULL),(9650,56,'avalara_q3-2023_noAvaTax','Automate my sales tax','https://woocommerce.com/products/woocommerce-avatax/?utm_source=inbox_note&utm_medium=product&utm_campaign=avalara_q3-2023_noAvaTax','unactioned','',NULL,NULL),(9651,57,'woo-activation-survey-blockers-survey-button-22AUG23','Take our short survey','https://woocommerce.survey.fm/getting-started-with-woo','unactioned','',NULL,NULL),(9652,65,'woocommerce-usermeta-Sept2023-productvendors','See available updates','https://usa.ugenebio.com/wp-admin/plugins.php','unactioned','',NULL,NULL),(9653,65,'dismiss','Dismiss','https://usa.ugenebio.com/wp-admin/#','actioned','',NULL,NULL);

--
-- Table structure for table `wp_wc_admin_notes`
--

CREATE TABLE `wp_wc_admin_notes` (
  `note_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `locale` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `title` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `content_data` longtext COLLATE utf8mb4_unicode_520_ci,
  `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `source` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_reminder` datetime DEFAULT NULL,
  `is_snoozable` tinyint(1) NOT NULL DEFAULT '0',
  `layout` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `image` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `icon` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'info',
  PRIMARY KEY (`note_id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_admin_notes`
--

INSERT INTO `wp_wc_admin_notes` VALUES (1,'wayflyer_bnpl_q4_2021','marketing','en_US','Grow your business with funding through Wayflyer','Fast, flexible financing to boost cash flow and help your business grow – one fee, no interest rates, penalties, equity, or personal guarantees. Based on your store’s performance, Wayflyer provides funding and analytical insights to invest in your business.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(2,'wc_shipping_mobile_app_usps_q4_2021','marketing','en_US','Print and manage your shipping labels with WooCommerce Shipping and the WooCommerce Mobile App','Save time by printing, purchasing, refunding, and tracking shipping labels generated by <a href=\"https://woocommerce.com/woocommerce-shipping/\">WooCommerce Shipping</a> – all directly from your mobile device!','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(3,'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.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(4,'your-first-product','info','en_US','Your first product','That’s huge! You’re well on your way to building a successful online store — now it’s time to think about how you’ll fulfill your orders.<br /><br />Read our shipping guide to learn best practices and options for putting together your shipping strategy. And for WooCommerce stores in the United States, you can print discounted shipping labels via USPS with <a href=\"https://href.li/?https://woocommerce.com/shipping\" target=\"_blank\">WooCommerce Shipping</a>.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(5,'wc-admin-optimizing-the-checkout-flow','info','en_US','Optimizing the checkout flow','It’s crucial to get your store’s checkout as smooth as possible to avoid losing sales. Let’s take a look at how you can optimize the checkout experience for your shoppers.','{}','unactioned','woocommerce.com','2023-09-23 18:51:22',NULL,0,'plain','',0,0,'info'),(6,'wc-payments-qualitative-feedback','info','en_US','WooCommerce Payments setup - let us know what you think','Congrats on enabling WooCommerce Payments for your store. Please share your feedback in this 2 minute survey to help us improve the setup process.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(7,'share-your-feedback-on-paypal','info','en_US','Share your feedback on PayPal','Share your feedback in this 2 minute survey about how we can make the process of accepting payments more useful for your store.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(8,'google_listings_and_ads_install','marketing','en_US','Drive traffic and sales with Google','Reach online shoppers to drive traffic and sales for your store by showcasing products across Google, for free or with ads.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(9,'wc-subscriptions-security-update-3-0-15','info','en_US','WooCommerce Subscriptions security update!','We recently released an important security update to WooCommerce Subscriptions. To ensure your site’s data is protected, please upgrade <strong>WooCommerce Subscriptions to version 3.0.15</strong> or later.<br /><br />Click the button below to view and update to the latest Subscriptions version, or log in to <a href=\"https://woocommerce.com/my-dashboard\">WooCommerce.com Dashboard</a> and navigate to your <strong>Downloads</strong> page.<br /><br />We recommend always using the latest version of WooCommerce Subscriptions, and other software running on your site, to ensure maximum security.<br /><br />If you have any questions we are here to help — just <a href=\"https://woocommerce.com/my-account/create-a-ticket/\">open a ticket</a>.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(10,'woocommerce-core-update-5-4-0','info','en_US','Update to WooCommerce 5.4.1 now','WooCommerce 5.4.1 addresses a checkout issue discovered in WooCommerce 5.4. We recommend upgrading to WooCommerce 5.4.1 as soon as possible.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(11,'wcpay-promo-2020-11','marketing','en_US','wcpay-promo-2020-11','wcpay-promo-2020-11','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(12,'wcpay-promo-2020-12','marketing','en_US','wcpay-promo-2020-12','wcpay-promo-2020-12','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(13,'ppxo-pps-upgrade-paypal-payments-1','info','en_US','Get the latest PayPal extension for WooCommerce','Heads up! There’s a new PayPal on the block!<br /><br />Now is a great time to upgrade to our latest <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">PayPal extension</a> to continue to receive support and updates with PayPal.<br /><br />Get access to a full suite of PayPal payment methods, extensive currency and country coverage, and pay later options with the all-new PayPal extension for WooCommerce.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(14,'ppxo-pps-upgrade-paypal-payments-2','info','en_US','Upgrade your PayPal experience!','Get access to a full suite of PayPal payment methods, extensive currency and country coverage, offer subscription and recurring payments, and the new PayPal pay later options.<br /><br />Start using our <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">latest PayPal today</a> to continue to receive support and updates.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(15,'woocommerce-core-sqli-july-2021-need-to-update','update','en_US','Action required: Critical vulnerabilities in WooCommerce','In response to a critical vulnerability identified on July 13, 2021, we are working with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br />Our investigation into this vulnerability is ongoing, but <strong>we wanted to let you know now about the importance of updating immediately</strong>.<br /><br />For more information on which actions you should take, as well as answers to FAQs, please urgently review our blog post detailing this issue.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(16,'woocommerce-blocks-sqli-july-2021-need-to-update','update','en_US','Action required: Critical vulnerabilities in WooCommerce Blocks','In response to a critical vulnerability identified on July 13, 2021, we are working with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br />Our investigation into this vulnerability is ongoing, but <strong>we wanted to let you know now about the importance of updating immediately</strong>.<br /><br />For more information on which actions you should take, as well as answers to FAQs, please urgently review our blog post detailing this issue.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(17,'woocommerce-core-sqli-july-2021-store-patched','update','en_US','Solved: Critical vulnerabilities patched in WooCommerce','In response to a critical vulnerability identified on July 13, 2021, we worked with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br /><strong>Your store has been updated to the latest secure version(s)</strong>. For more information and answers to FAQs, please review our blog post detailing this issue.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(18,'woocommerce-blocks-sqli-july-2021-store-patched','update','en_US','Solved: Critical vulnerabilities patched in WooCommerce Blocks','In response to a critical vulnerability identified on July 13, 2021, we worked with the WordPress Plugins Team to deploy software updates to stores running WooCommerce (versions 3.3 to 5.5) and the WooCommerce Blocks feature plugin (versions 2.5 to 5.5).<br /><br /><strong>Your store has been updated to the latest secure version(s)</strong>. For more information and answers to FAQs, please review our blog post detailing this issue.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(19,'habit-moment-survey','marketing','en_US','We’re all ears! Share your experience so far with WooCommerce','We’d love your input to shape the future of WooCommerce together. Feel free to share any feedback, ideas or suggestions that you have.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(20,'woocommerce-core-paypal-march-2022-updated','update','en_US','Security auto-update of WooCommerce','<strong>Your store has been updated to the latest secure version of WooCommerce</strong>. We worked with WordPress to deploy PayPal Standard security updates for stores running WooCommerce (version 3.5 to 6.3). It’s recommended to disable PayPal Standard, and use <a href=\"https://woocommerce.com/products/woocommerce-paypal-payments/\" target=\"_blank\">PayPal Payments</a> to accept PayPal.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(21,'woocommerce-core-paypal-march-2022-updated-nopp','update','en_US','Security auto-update of WooCommerce','<strong>Your store has been updated to the latest secure version of WooCommerce</strong>. We worked with WordPress to deploy security updates related to PayPal Standard payment gateway for stores running WooCommerce (version 3.5 to 6.3).','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(22,'pinterest_03_2022_update','marketing','en_US','Your Pinterest for WooCommerce plugin is out of date!','Update to the latest version of Pinterest for WooCommerce to continue using this plugin and keep your store connected with Pinterest. To update, visit <strong>Plugins &gt; Installed Plugins</strong>, and click on “update now” under Pinterest for WooCommerce.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(23,'store_setup_survey_survey_q2_2022','survey','en_US','How is your store setup going?','Our goal is to make sure you have all the right tools to start setting up your store in the smoothest way possible.\r\nWe’d love to know if we hit our mark and how we can improve. To collect your thoughts, we made a 2-minute survey.','{}','unactioned','woocommerce.com','2023-09-24 03:58:28',NULL,0,'plain','',0,0,'info'),(24,'woocommerce-payments-august-2022-need-to-update','update','en_US','Action required: Please update WooCommerce Payments','An updated secure version of WooCommerce Payments is available – please ensure that you’re using the latest patch version. For more information on what action you need to take, please review the article below.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(25,'woocommerce-payments-august-2022-store-patched','update','en_US','WooCommerce Payments has been automatically updated','You’re now running the latest secure version of WooCommerce Payments. We’ve worked with the WordPress Plugins team to deploy a security update to stores running WooCommerce Payments (version 3.9 to 4.5). For further information, please review the article below.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(26,'needs-update-eway-payment-gateway-rin-2022-12-20','update','en_US','Security vulnerability patched in WooCommerce Eway Gateway','In response to a potential vulnerability identified in WooCommerce Eway Gateway versions 3.1.0 to 3.5.0, we’ve worked to deploy security fixes and have released an updated version.\r\nNo external exploits have been detected, but we recommend you update to your latest supported version 3.1.26, 3.2.3, 3.3.1, 3.4.6, or 3.5.1','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(27,'updated-eway-payment-gateway-rin-2022-12-20','update','en_US','WooCommerce Eway Gateway has been automatically updated','Your store is now running the latest secure version of WooCommerce Eway Gateway. We worked with the WordPress Plugins team to deploy a software update to stores running WooCommerce Eway Gateway (versions 3.1.0 to 3.5.0) in response to a security vulnerability that was discovered.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(28,'ecomm-wc-navigation-survey-2023','info','en_US','Navigating WooCommerce on WordPress.com','We are improving the WooCommerce navigation on WordPress.com and would love your help to make it better! Please share your experience with us in this 2-minute survey.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(29,'woopay-beta-merchantrecruitment-04MAY23','info','en_US','Increase conversions with WooPay — our fastest checkout yet','WooPay, a new express checkout feature built into WooCommerce Payments, is now available —and we’re inviting you to be one of the first to try it. \r\n<br><br>\r\nBoost conversions by offering your customers a simple, secure way to pay with a single click.\r\n<br><br>\r\nGet started in seconds.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(30,'woocommerce-wcpay-march-2023-update-needed','update','en_US','Action required: Security update for WooCommerce Payments','<strong>Your store requires a security update for WooCommerce Payments</strong>. Please update to the latest version of WooCommerce Payments immediately to address a potential vulnerability discovered on March 22. For more information on how to update, visit this WooCommerce Developer Blog Post.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(31,'tap_to_pay_iphone_q2_2023_no_wcpay','marketing','en_US','Accept in-person contactless payments on your iPhone','Tap to Pay on iPhone and WooCommerce Payments is quick, secure, and simple to set up — no extra terminals or card readers are needed. Accept contactless debit and credit cards, Apple Pay, and other NFC digital wallets in person.','{}','unactioned','woocommerce.com','2023-09-18 20:29:14',NULL,0,'plain','',0,1,'info'),(32,'woocommerce-WCPreOrders-april-2023-update-needed','update','en_US','Action required: Security update of WooCommerce Pre-Orders extension','<strong>Your store requires a security update for the WooCommerce Pre-Orders extension</strong>. Please update the WooCommerce Pre-Orders extension immediately to address a potential vulnerability discovered on April 11.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(33,'woopay-beta-merchantrecruitment-update-04MAY23','info','en_US','Increase conversions with WooPay — our fastest checkout yet','WooPay, a new express checkout feature built into WooCommerce Payments, is now available — and you’re invited to try it. \r\n<br /><br />\r\nBoost conversions by offering your customers a simple, secure way to pay with a single click.\r\n<br /><br />\r\nUpdate WooCommerce Payments to get started.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(34,'woopay-beta-existingmerchants-noaction-27APR23','info','en_US','WooPay is back!','Thanks for previously trying WooPay, the express checkout feature built into WooCommerce Payments. We’re excited to announce that WooPay availability has resumed. No action is required on your part.\r\n<br /><br />\r\nYou can now continue boosting conversions by offering your customers a simple, secure way to pay with a single click.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(35,'woopay-beta-existingmerchants-update-27APR23','info','en_US','WooPay is back!','Thanks for previously trying WooPay, the express checkout feature built into WooCommerce Payments. We’re excited to announce that WooPay availability has resumed.\r\n<br /><br />\r\n\r\nUpdate to the latest WooCommerce Payments version to continue boosting conversions by offering your customers a simple, secure way to pay with a single click.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(36,'woopay-beta-merchantrecruitment-short-04MAY23','info','en_US','Increase conversions with WooPay — our fastest checkout yet','Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(37,'woopay-beta-merchantrecruitment-short-update-04MAY23','info','en_US','Increase conversions with WooPay — our fastest checkout yet','Be one of the first to try WooPay, our new express checkout feature. <br>Boost conversions by letting customers pay with a single click. <br><br>Update to the latest version of WooCommerce Payments to get started.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(38,'woopay-beta-merchantrecruitment-short-06MAY23-TESTA','info','en_US','Increase conversions with WooPay — our fastest checkout yet','Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(39,'woopay-beta-merchantrecruitment-short-06MAY23-TESTB','info','en_US','Increase conversions with WooPay — our fastest checkout yet','Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(40,'woopay-beta-merchantrecruitment-short-06MAY23-TESTC','info','en_US','Increase conversions with WooPay — our fastest checkout yet','Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(41,'woopay-beta-merchantrecruitment-short-06MAY23-TESTD','info','en_US','Increase conversions with WooPay — our fastest checkout yet','Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(42,'woopay-beta-merchantrecruitment-short-09MAY23','info','en_US','Increase conversions with WooPay — our fastest checkout yet','Be one of the first to try WooPay, a new express checkout feature for WooCommerce Payments. \r\n<br><br>\r\nBoost conversions by letting customers pay with a single click.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(43,'woopay-beta-merchantrecruitment-short-update-09MAY23','info','en_US','Increase conversions with WooPay — our fastest checkout yet','Be one of the first to try WooPay, our new express checkout feature. <br>Boost conversions by letting customers pay with a single click. <br><br>Update to the latest version of WooCommerce Payments to get started.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(44,'woocommerce-WCstripe-May-2023-updated-needed','update','en_US','Action required: Security update of WooCommerce Stripe plugin','<strong>Your store requires a security update for the WooCommerce Stripe plugin</strong>. Please update the WooCommerce Stripe plugin immediately to address a potential vulnerability.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(45,'woocommerce-WCPayments-June-2023-updated-needed','update','en_US','Action required: Security update of WooCommerce Payments','<strong>Your store requires a security update for the WooCommerce Payments plugin</strong>. Please update the WooCommerce Payments plugin immediately to address a potential vulnerability.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(46,'woocommerce-WCSubscriptions-June-2023-updated-needed','marketing','en_US','Action required: Security update of WooCommerce Subscriptions','<strong>Your store requires a security update for the WooCommerce Subscriptions plugin</strong>. Please update the WooCommerce Subscriptions plugin immediately to address a potential vulnerability.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(47,'woocommerce-WCReturnsWarranty-June-2023-updated-needed','update','en_US','Action required: Security update of WooCommerce Returns and Warranty Requests extension','<strong>Your store requires a security update for the Returns and Warranty Requests extension</strong>.  Please update to the latest version of the WooCommerce Returns and Warranty Requests extension immediately to address a potential vulnerability discovered on May 31.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(48,'woocommerce-WCOPC-June-2023-updated-needed','update','en_US','Action required: Security update of WooCommerce One Page Checkout','<strong>Your shop requires a security update to address a vulnerability in the WooCommerce One Page Checkout extension</strong>. The fix for this vulnerability was released for this extension on June 13th. Please update immediately.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(49,'woocommerce-WCGC-July-2023-update-needed','update','en_US','Action required: Security update of WooCommerce GoCardless Extension','<strong>Your shop requires a security update to address a vulnerability in the WooCommerce GoCardless extension</strong>. The fix for this vulnerability was released on July 4th. Please update immediately.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(50,'woocommerce-shipping-fedex-api-outage-2023-07-16','warning','en_US','Scheduled FedEx API outage — July 2023','On July 16 there will be a full outage of the FedEx API from 04:00 to 08:00 AM UTC. Due to planned maintenance by FedEx, you\'ll be unable to provide FedEx shipping rates during this time. Follow the link below for more information and recommendations on how to minimize impact.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(51,'wcship-2023-07-hazmat-update-needed','update','en_US','Action required: USPS HAZMAT compliance update for WooCommerce Shipping & Tax extension','<strong>Your store requires an update for the WooCommerce Shipping extension</strong>. Please update to the latest version of the WooCommerce Shipping &amp; Tax extension immediately to ensure compliance with new USPS HAZMAT rules currently in effect.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(52,'woocommerce-WCStripe-Aug-2023-update-needed','update','en_US','Action required: Security update for WooCommerce Stripe plugin','<strong>Your shop requires an important security update for the  WooCommerce Stripe plugin</strong>. The fix for this vulnerability was released on July 31. Please update immediately.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(53,'woocommerce-WCStripe-Aug-2023-security-updated','update','en_US','Security update of WooCommerce Stripe plugin','<strong>Your store has been updated to the latest secure version of the WooCommerce Stripe plugin</strong>. This update was released on July 31.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(54,'woocommerce-WooPayments-Aug-2023-update-needed','update','en_US','Action required: Security update for WooPayments (WooCommerce Payments) plugin','<strong>Your shop requires an important security update for the WooPayments (WooCommerce Payments) extension</strong>. The fix for this vulnerability was released on July 31. Please update immediately.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(55,'woocommerce-WooPayments-Aug-2023-security-updated','update','en_US','Security update of WooPayments (WooCommerce Payments) plugin','<strong>Your store has been updated to the more secure version of WooPayments (WooCommerce Payments)</strong>. This update was released on July 31.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(56,'avalara_q3-2023_noAvaTax','marketing','en_US','Automatically calculate VAT in real time','Take the effort out of determining tax rates and sell confidently across borders with automated tax management from Avalara AvaTax— including built-in VAT calculation when you sell into or across the EU and UK. Save time and stay compliant when you let Avalara do the heavy lifting.','{}','pending','woocommerce.com','2023-09-17 03:57:43',NULL,0,'plain','',0,0,'info'),(57,'woo-activation-survey-blockers-22AUG23','info','en_US','How can we help you get that first sale?','Your feedback is vital. Please take a minute to share your experience of setting up your new store and whether anything is preventing you from making those first few sales. Together, we can make Woo even better!','{}','unactioned','woocommerce.com','2023-09-17 04:01:23',NULL,0,'plain','',0,1,'info'),(58,'wc-admin-choosing-a-theme','marketing','en_US','Choosing a theme?','Check out the themes that are compatible with WooCommerce and choose one aligned with your brand and business needs.','[]','unactioned','woocommerce-admin','2023-09-18 04:40:12',NULL,0,'plain','',0,1,'info'),(59,'wc-admin-customizing-product-catalog','info','en_US','How to customize your product catalog','You want your product catalog and images to look great and align with your brand. This guide will give you all the tips you need to get your products looking great in your store.','[]','unactioned','woocommerce-admin','2023-09-18 04:40:12',NULL,0,'plain','',0,1,'info'),(60,'wc-admin-wc-helper-connection','info','en_US','Connect to WooCommerce.com','Connect to get important product notifications and updates.','[]','unactioned','woocommerce-admin','2023-09-18 19:42:47',NULL,0,'plain','',0,1,'info'),(61,'wc-admin-launch-checklist','info','en_US','Ready to launch your store?','To make sure you never get that sinking \"what did I forget\" feeling, we\'ve put together the essential pre-launch checklist.','[]','unactioned','woocommerce-admin','2023-09-19 04:13:20',NULL,0,'plain','',0,0,'info'),(62,'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.','[]','unactioned','woocommerce-admin','2023-09-19 04:13:20',NULL,0,'plain','',0,0,'info'),(63,'wc_admin_BNPL_WCPay_Q3_2023','marketing','en_US','Afterpay and Affirm have arrived in WooCommerce Payments!','Give your customers more power with buy now, pay later from Afterpay and Affirm — now included as part of WooCommerce Payments! With this new integration, you can quickly offer a checkout option that converts sales and boosts average order value, all from within the same payments dashboard you already know.','[]','pending','woocommerce.com','2023-09-19 04:13:20',NULL,0,'plain','',0,0,'info'),(64,'wc_admin_afterpay_WCPay_Q3_2023','marketing','en_US','Afterpay has arrived in WooCommerce Payments!','Give your customers more power with buy now, pay later from Afterpay — now included as part of WooCommerce Payments! With this new integration, you can quickly offer a checkout option that converts sales and boosts average order value, all from within the same payments dashboard you already know.','[]','pending','woocommerce.com','2023-09-19 04:13:20',NULL,0,'plain','',0,0,'info'),(65,'woocommerce-usermeta-Sept2023-productvendors','update','en_US','Your store requires a security update','<strong>Your shop needs an update to address a vulnerability in WooCommerce.</strong> The fix was released on Sept 15. Please update WooCommerce to the latest version immediately. <a href=\"https://developer.woocommerce.com/2023/09/16/woocommerce-vulnerability-reintroduced-from-7-0-1/\" />Read our developer update</a> for more information.','{}','pending','woocommerce.com','2023-09-20 04:24:30',NULL,0,'plain','',0,0,'info'),(66,'wc-admin-onboarding-payments-reminder','info','en_US','Start accepting payments on your store!','Take payments with the provider that’s right for you - choose from 100+ payment gateways for WooCommerce.','[]','unactioned','woocommerce-admin','2023-09-22 04:00:22',NULL,0,'plain','',0,0,'info'),(68,'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://usa.ugenebio.com/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?utm_medium=product\" target=\"_blank\">Read more</a> about what data we collect.','[]','unactioned','woocommerce-admin','2023-09-24 03:58:28',NULL,0,'plain','',0,0,'info'),(69,'wc-admin-woocommerce-payments','marketing','en_US','Try the new way to get paid','Securely accept credit and debit cards on your site. Manage transactions without leaving your WordPress dashboard. Only with <strong>WooPayments</strong>.<br><br>By clicking \"Get started\", you agree to our <a href=\"https://wordpress.com/tos/\" target=\"_blank\">Terms of Service</a>','[]','unactioned','woocommerce-admin','2023-09-24 03:58:28',NULL,0,'plain','',0,0,'info'),(70,'wc-admin-orders-milestone','info','en_US','First order received','Congratulations on getting your first order! Now is a great time to learn how to manage your orders.','{\"current_milestone\":1}','unactioned','woocommerce-admin','2023-09-24 06:58:57',NULL,0,'plain','',0,0,'info');

--
-- Table structure for table `wp_wc_category_lookup`
--

CREATE TABLE `wp_wc_category_lookup` (
  `category_tree_id` bigint(20) unsigned NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`category_tree_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_category_lookup`
--

INSERT INTO `wp_wc_category_lookup` VALUES (15,15),(28,28),(39,39),(47,47);

--
-- Table structure for table `wp_wc_customer_lookup`
--

CREATE TABLE `wp_wc_customer_lookup` (
  `customer_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `username` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `first_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `date_last_active` timestamp NULL DEFAULT NULL,
  `date_registered` timestamp NULL DEFAULT NULL,
  `country` char(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `postcode` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `city` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `state` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`customer_id`),
  UNIQUE KEY `user_id` (`user_id`),
  KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_customer_lookup`
--

INSERT INTO `wp_wc_customer_lookup` VALUES (2,1,'mars2029','Dong','Kim','mars2029kr@gmail.com','2023-09-24 11:23:51','2023-09-17 07:27:20','US','75234','little elm','TX'),(3,10,'marstest','Dong','kim','jnkim184@gmail.com','2023-10-02 22:36:51','2023-10-02 22:35:28','US','75234','little elm','TX'),(4,8,'seokwon00','Seokwon','Kim','kimseokwon00@gmail.com','2023-10-04 23:53:09','2023-09-26 09:06:16','US','92602','Irvine','CA');

--
-- Table structure for table `wp_wc_download_log`
--

CREATE TABLE `wp_wc_download_log` (
  `download_log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `permission_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `user_ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  PRIMARY KEY (`download_log_id`),
  KEY `permission_id` (`permission_id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_download_log`
--


--
-- Table structure for table `wp_wc_order_addresses`
--

CREATE TABLE `wp_wc_order_addresses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `address_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `first_name` text COLLATE utf8mb4_unicode_520_ci,
  `last_name` text COLLATE utf8mb4_unicode_520_ci,
  `company` text COLLATE utf8mb4_unicode_520_ci,
  `address_1` text COLLATE utf8mb4_unicode_520_ci,
  `address_2` text COLLATE utf8mb4_unicode_520_ci,
  `city` text COLLATE utf8mb4_unicode_520_ci,
  `state` text COLLATE utf8mb4_unicode_520_ci,
  `postcode` text COLLATE utf8mb4_unicode_520_ci,
  `country` text COLLATE utf8mb4_unicode_520_ci,
  `email` varchar(320) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `phone` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `address_type_order_id` (`address_type`,`order_id`),
  KEY `order_id` (`order_id`),
  KEY `email` (`email`(191)),
  KEY `phone` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_addresses`
--


--
-- Table structure for table `wp_wc_order_coupon_lookup`
--

CREATE TABLE `wp_wc_order_coupon_lookup` (
  `order_id` bigint(20) unsigned NOT NULL,
  `coupon_id` bigint(20) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `discount_amount` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`order_id`,`coupon_id`),
  KEY `coupon_id` (`coupon_id`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_coupon_lookup`
--


--
-- Table structure for table `wp_wc_order_operational_data`
--

CREATE TABLE `wp_wc_order_operational_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `created_via` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `woocommerce_version` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `prices_include_tax` tinyint(1) DEFAULT NULL,
  `coupon_usages_are_counted` tinyint(1) DEFAULT NULL,
  `download_permission_granted` tinyint(1) DEFAULT NULL,
  `cart_hash` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `new_order_email_sent` tinyint(1) DEFAULT NULL,
  `order_key` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `order_stock_reduced` tinyint(1) DEFAULT NULL,
  `date_paid_gmt` datetime DEFAULT NULL,
  `date_completed_gmt` datetime DEFAULT NULL,
  `shipping_tax_amount` decimal(26,8) DEFAULT NULL,
  `shipping_total_amount` decimal(26,8) DEFAULT NULL,
  `discount_tax_amount` decimal(26,8) DEFAULT NULL,
  `discount_total_amount` decimal(26,8) DEFAULT NULL,
  `recorded_sales` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_id` (`order_id`),
  KEY `order_key` (`order_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_operational_data`
--


--
-- Table structure for table `wp_wc_order_product_lookup`
--

CREATE TABLE `wp_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 '0000-00-00 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',
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`),
  KEY `product_id` (`product_id`),
  KEY `customer_id` (`customer_id`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_product_lookup`
--

INSERT INTO `wp_wc_order_product_lookup` VALUES (1,4657,4649,0,2,'2023-09-24 01:23:51',1,100,106.25,0,6.25,0,0),(2,4657,4630,0,2,'2023-09-24 01:23:51',1,100,106.25,0,6.25,0,0),(3,4657,4632,0,2,'2023-09-24 01:23:51',1,100,106.25,0,6.25,0,0),(15,4667,4632,0,3,'2023-10-02 12:36:51',1,100,106.25,0,6.25,0,0),(18,4668,4608,0,4,'2023-10-04 13:53:09',1,140,150.5,0,10.5,0,0);

--
-- Table structure for table `wp_wc_order_stats`
--

CREATE TABLE `wp_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 '0000-00-00 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_paid` datetime DEFAULT '0000-00-00 00:00:00',
  `date_completed` datetime DEFAULT '0000-00-00 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) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `customer_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`order_id`),
  KEY `date_created` (`date_created`),
  KEY `customer_id` (`customer_id`),
  KEY `status` (`status`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_stats`
--

INSERT INTO `wp_wc_order_stats` VALUES (4657,0,'2023-09-24 01:23:51','2023-09-24 06:23:51','2023-09-24 01:23:51',NULL,3,318.75,18.75,0,300,0,'wc-processing',2),(4667,0,'2023-10-02 12:36:51','2023-10-02 17:36:51','2023-10-02 12:45:46',NULL,1,106.25,6.25,0,100,0,'wc-processing',3),(4668,0,'2023-10-04 13:53:09','2023-10-04 18:53:09',NULL,NULL,1,150.5,10.5,0,140,0,'wc-processing',4);

--
-- Table structure for table `wp_wc_order_tax_lookup`
--

CREATE TABLE `wp_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 '0000-00-00 00:00:00',
  `shipping_tax` double NOT NULL DEFAULT '0',
  `order_tax` double NOT NULL DEFAULT '0',
  `total_tax` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`order_id`,`tax_rate_id`),
  KEY `tax_rate_id` (`tax_rate_id`),
  KEY `date_created` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_order_tax_lookup`
--

INSERT INTO `wp_wc_order_tax_lookup` VALUES (4657,43,'2023-09-24 01:23:51',0,18.75,18.75),(4667,43,'2023-10-02 12:36:51',0,6.25,6.25),(4668,5,'2023-10-04 13:53:09',0,10.5,10.5);

--
-- Table structure for table `wp_wc_orders`
--

CREATE TABLE `wp_wc_orders` (
  `id` bigint(20) unsigned NOT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `currency` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `tax_amount` decimal(26,8) DEFAULT NULL,
  `total_amount` decimal(26,8) DEFAULT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `billing_email` varchar(320) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `date_created_gmt` datetime DEFAULT NULL,
  `date_updated_gmt` datetime DEFAULT NULL,
  `parent_order_id` bigint(20) unsigned DEFAULT NULL,
  `payment_method` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `payment_method_title` text COLLATE utf8mb4_unicode_520_ci,
  `transaction_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `ip_address` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_520_ci,
  `customer_note` text COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `date_created` (`date_created_gmt`),
  KEY `customer_id_billing_email` (`customer_id`,`billing_email`(171)),
  KEY `billing_email` (`billing_email`(191)),
  KEY `type_status_date` (`type`,`status`,`date_created_gmt`),
  KEY `parent_order_id` (`parent_order_id`),
  KEY `date_updated` (`date_updated_gmt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_orders`
--


--
-- Table structure for table `wp_wc_orders_meta`
--

CREATE TABLE `wp_wc_orders_meta` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` text COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`id`),
  KEY `meta_key_value` (`meta_key`(100),`meta_value`(82)),
  KEY `order_id_meta_key_meta_value` (`order_id`,`meta_key`(100),`meta_value`(82))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_orders_meta`
--


--
-- Table structure for table `wp_wc_product_attributes_lookup`
--

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

--
-- Dumping data for table `wp_wc_product_attributes_lookup`
--


--
-- Table structure for table `wp_wc_product_download_directories`
--

CREATE TABLE `wp_wc_product_download_directories` (
  `url_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(256) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`url_id`),
  KEY `url` (`url`(191))
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_product_download_directories`
--

INSERT INTO `wp_wc_product_download_directories` VALUES (1,'file:///home4/ugenebio/usa.ugenebio.com/wp-content/uploads/woocommerce_uploads/',1),(2,'https://usa.ugenebio.com/wp-content/uploads/woocommerce_uploads/',1);

--
-- Table structure for table `wp_wc_product_meta_lookup`
--

CREATE TABLE `wp_wc_product_meta_lookup` (
  `product_id` bigint(20) NOT NULL,
  `sku` varchar(100) COLLATE utf8mb4_unicode_520_ci 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) COLLATE utf8mb4_unicode_520_ci 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) COLLATE utf8mb4_unicode_520_ci DEFAULT 'taxable',
  `tax_class` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',
  PRIMARY KEY (`product_id`),
  KEY `virtual` (`virtual`),
  KEY `downloadable` (`downloadable`),
  KEY `stock_status` (`stock_status`),
  KEY `stock_quantity` (`stock_quantity`),
  KEY `onsale` (`onsale`),
  KEY `min_max_price` (`min_price`,`max_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_product_meta_lookup`
--

INSERT INTO `wp_wc_product_meta_lookup` VALUES (79,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,126,'taxable',NULL),(86,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,31,'taxable',NULL),(95,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,87,'taxable',NULL),(109,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,66,'taxable',NULL),(112,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,77,'taxable',NULL),(115,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,9,'taxable',NULL),(121,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,49,'taxable',NULL),(132,NULL,0,0,40.0000,45.0000,0,NULL,'instock',0,NULL,9,'taxable',NULL),(142,NULL,0,0,40.0000,46.0000,0,NULL,'instock',0,NULL,54,'taxable',NULL),(157,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,34,'taxable',NULL),(160,NULL,0,0,150.0000,180.0000,0,NULL,'instock',0,NULL,101568,'taxable',NULL),(169,NULL,0,0,150.0000,170.0000,0,NULL,'instock',0,NULL,105,'taxable',NULL),(194,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,14,'taxable',NULL),(209,NULL,0,0,25.0000,27.0000,0,NULL,'instock',0,NULL,7,'taxable',NULL),(210,NULL,0,0,25.0000,28.0000,0,NULL,'instock',0,NULL,11,'taxable',NULL),(211,NULL,0,0,30.0000,34.0000,0,NULL,'instock',0,NULL,5,'taxable',NULL),(212,NULL,0,0,25.0000,28.0000,0,NULL,'instock',0,NULL,29,'taxable',NULL),(229,NULL,0,0,130.0000,130.0000,1,NULL,'instock',0,NULL,118,'taxable',NULL),(242,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,8,'taxable',NULL),(247,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,373,'taxable',NULL),(252,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,273,'taxable',NULL),(307,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,1222443,'taxable',NULL),(316,NULL,0,0,250.0000,290.0000,0,NULL,'instock',0,NULL,98,'taxable',NULL),(324,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,2000043,'taxable',NULL),(340,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,9,'taxable',NULL),(345,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,86,'taxable',NULL),(349,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,2698,'taxable',NULL),(360,NULL,0,0,200.0000,240.0000,0,NULL,'instock',0,NULL,10000949,'taxable',NULL),(361,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,11,'taxable',NULL),(362,NULL,0,0,120.0000,120.0000,1,NULL,'instock',0,NULL,191478,'taxable',NULL),(375,NULL,0,0,175.0000,200.0000,0,NULL,'instock',0,NULL,22,'taxable',NULL),(4038,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4040,NULL,0,0,170.0000,170.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4041,NULL,0,0,180.0000,180.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4061,NULL,0,0,25.0000,25.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4066,NULL,0,0,26.0000,26.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4069,NULL,0,0,27.0000,27.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4072,NULL,0,0,28.0000,28.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4077,NULL,0,0,25.0000,25.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4078,NULL,0,0,26.0000,26.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4079,NULL,0,0,27.0000,27.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4081,NULL,0,0,30.0000,30.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4082,NULL,0,0,31.0000,31.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4083,NULL,0,0,32.0000,32.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4084,NULL,0,0,33.0000,33.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4085,NULL,0,0,34.0000,34.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4087,NULL,0,0,28.0000,28.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4088,NULL,0,0,27.0000,27.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4089,NULL,0,0,26.0000,26.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4090,NULL,0,0,25.0000,25.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4091,NULL,0,0,150.0000,150.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4092,NULL,0,0,160.0000,160.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4093,NULL,0,0,170.0000,170.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4099,NULL,0,0,100.0000,100.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4100,NULL,0,0,110.0000,110.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4101,NULL,0,0,120.0000,120.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4102,NULL,0,0,140.0000,140.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4103,NULL,0,0,40.0000,40.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4104,NULL,0,0,42.0000,42.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4105,NULL,0,0,44.0000,44.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4106,NULL,0,0,45.0000,45.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4107,NULL,0,0,200.0000,200.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4108,NULL,0,0,220.0000,220.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4109,NULL,0,0,240.0000,240.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4110,NULL,0,0,250.0000,250.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4111,NULL,0,0,265.0000,265.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4112,NULL,0,0,275.0000,275.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4113,NULL,0,0,290.0000,290.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4115,NULL,0,0,40.0000,40.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4116,NULL,0,0,42.0000,42.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4117,NULL,0,0,44.0000,44.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4118,NULL,0,0,46.0000,46.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4119,NULL,0,0,185.0000,185.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4120,NULL,0,0,175.0000,175.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4121,NULL,0,0,200.0000,200.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4122,NULL,0,0,195.0000,195.0000,0,NULL,'instock',0,NULL,0,'taxable','parent'),(4608,'c10002',0,0,140.0000,140.0000,1,99,'instock',1,5.00,1,'taxable',''),(4630,'c10001',0,0,100.0000,100.0000,0,99,'instock',1,5.00,1,'taxable',''),(4632,'c10004',0,0,100.0000,100.0000,0,98,'instock',1,5.00,2,'taxable',''),(4649,'c10003',0,0,100.0000,100.0000,0,99,'instock',1,5.00,1,'taxable','');

--
-- Table structure for table `wp_wc_rate_limits`
--

CREATE TABLE `wp_wc_rate_limits` (
  `rate_limit_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `rate_limit_key` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `rate_limit_expiry` bigint(20) unsigned NOT NULL,
  `rate_limit_remaining` smallint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rate_limit_id`),
  UNIQUE KEY `rate_limit_key` (`rate_limit_key`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_rate_limits`
--


--
-- Table structure for table `wp_wc_reserved_stock`
--

CREATE TABLE `wp_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 '0000-00-00 00:00:00',
  `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`order_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_reserved_stock`
--


--
-- Table structure for table `wp_wc_tax_rate_classes`
--

CREATE TABLE `wp_wc_tax_rate_classes` (
  `tax_rate_class_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`tax_rate_class_id`),
  UNIQUE KEY `slug` (`slug`(191))
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_tax_rate_classes`
--

INSERT INTO `wp_wc_tax_rate_classes` VALUES (1,'Reduced rate','reduced-rate'),(2,'Zero rate','zero-rate');

--
-- Table structure for table `wp_wc_webhooks`
--

CREATE TABLE `wp_wc_webhooks` (
  `webhook_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `delivery_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `secret` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `topic` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 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',
  PRIMARY KEY (`webhook_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wc_webhooks`
--


--
-- Table structure for table `wp_woocommerce_api_keys`
--

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

--
-- Dumping data for table `wp_woocommerce_api_keys`
--


--
-- Table structure for table `wp_woocommerce_attribute_taxonomies`
--

CREATE TABLE `wp_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `attribute_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `attribute_label` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `attribute_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `attribute_orderby` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `attribute_public` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`attribute_id`),
  KEY `attribute_name` (`attribute_name`(20))
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_attribute_taxonomies`
--

INSERT INTO `wp_woocommerce_attribute_taxonomies` VALUES (1,'size','size','select','menu_order',0),(2,'color','color','select','menu_order',0);

--
-- Table structure for table `wp_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `wp_woocommerce_downloadable_product_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `download_id` varchar(36) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `order_key` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_email` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `downloads_remaining` varchar(9) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `access_granted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `access_expires` datetime DEFAULT NULL,
  `download_count` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`permission_id`),
  KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`),
  KEY `download_order_product` (`download_id`,`order_id`,`product_id`),
  KEY `order_id` (`order_id`),
  KEY `user_order_remaining_expires` (`user_id`,`order_id`,`downloads_remaining`,`access_expires`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_downloadable_product_permissions`
--


--
-- Table structure for table `wp_woocommerce_log`
--

CREATE TABLE `wp_woocommerce_log` (
  `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` datetime NOT NULL,
  `level` smallint(4) NOT NULL,
  `source` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `context` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`log_id`),
  KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_log`
--


--
-- Table structure for table `wp_woocommerce_order_itemmeta`
--

CREATE TABLE `wp_woocommerce_order_itemmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_item_id` bigint(20) unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `order_item_id` (`order_item_id`),
  KEY `meta_key` (`meta_key`(32))
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_order_itemmeta`
--

INSERT INTO `wp_woocommerce_order_itemmeta` VALUES (1,1,'_product_id','4649'),(2,1,'_variation_id','0'),(3,1,'_qty','1'),(4,1,'_tax_class',''),(5,1,'_line_subtotal','100'),(6,1,'_line_subtotal_tax','6.25'),(7,1,'_line_total','100'),(8,1,'_line_tax','6.25'),(9,1,'_line_tax_data','a:2:{s:5:\"total\";a:1:{i:43;s:4:\"6.25\";}s:8:\"subtotal\";a:1:{i:43;s:4:\"6.25\";}}'),(10,2,'_product_id','4630'),(11,2,'_variation_id','0'),(12,2,'_qty','1'),(13,2,'_tax_class',''),(14,2,'_line_subtotal','100'),(15,2,'_line_subtotal_tax','6.25'),(16,2,'_line_total','100'),(17,2,'_line_tax','6.25'),(18,2,'_line_tax_data','a:2:{s:5:\"total\";a:1:{i:43;s:4:\"6.25\";}s:8:\"subtotal\";a:1:{i:43;s:4:\"6.25\";}}'),(19,3,'_product_id','4632'),(20,3,'_variation_id','0'),(21,3,'_qty','1'),(22,3,'_tax_class',''),(23,3,'_line_subtotal','100'),(24,3,'_line_subtotal_tax','6.25'),(25,3,'_line_total','100'),(26,3,'_line_tax','6.25'),(27,3,'_line_tax_data','a:2:{s:5:\"total\";a:1:{i:43;s:4:\"6.25\";}s:8:\"subtotal\";a:1:{i:43;s:4:\"6.25\";}}'),(28,4,'method_id','local_pickup'),(29,4,'instance_id','2'),(30,4,'cost','0.00'),(31,4,'total_tax','0'),(32,4,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(33,4,'Items','Mineral Rich Mud Mask &times; 1, Ugenebio Skincare System &times; 1, Phytoplatelet Serum &times; 1'),(34,5,'rate_id','43'),(35,5,'label','TX State Tax'),(36,5,'compound',''),(37,5,'tax_amount','18.75'),(38,5,'shipping_tax_amount','0'),(39,5,'rate_percent','6.25'),(40,1,'_reduced_stock','1'),(41,2,'_reduced_stock','1'),(42,3,'_reduced_stock','1'),(106,15,'_product_id','4632'),(107,15,'_variation_id','0'),(108,15,'_qty','1'),(109,15,'_tax_class',''),(110,15,'_line_subtotal','100'),(111,15,'_line_subtotal_tax','6.25'),(112,15,'_line_total','100'),(113,15,'_line_tax','6.25'),(114,15,'_line_tax_data','a:2:{s:5:\"total\";a:1:{i:43;s:4:\"6.25\";}s:8:\"subtotal\";a:1:{i:43;s:4:\"6.25\";}}'),(115,16,'method_id','free_shipping'),(116,16,'instance_id','1'),(117,16,'cost','0.00'),(118,16,'total_tax','0'),(119,16,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(120,16,'Items','Phytoplatelet Serum &times; 1'),(121,17,'rate_id','43'),(122,17,'label','TX State Tax'),(123,17,'compound',''),(124,17,'tax_amount','6.25'),(125,17,'shipping_tax_amount','0'),(126,17,'rate_percent','6.25'),(127,15,'_reduced_stock','1'),(128,18,'_product_id','4608'),(129,18,'_variation_id','0'),(130,18,'_qty','1'),(131,18,'_tax_class',''),(132,18,'_line_subtotal','140'),(133,18,'_line_subtotal_tax','10.5'),(134,18,'_line_total','140'),(135,18,'_line_tax','10.5'),(136,18,'_line_tax_data','a:2:{s:5:\"total\";a:1:{i:5;s:4:\"10.5\";}s:8:\"subtotal\";a:1:{i:5;s:4:\"10.5\";}}'),(137,19,'method_id','free_shipping'),(138,19,'instance_id','1'),(139,19,'cost','0.00'),(140,19,'total_tax','0'),(141,19,'taxes','a:1:{s:5:\"total\";a:0:{}}'),(142,19,'Items','Puritox Deep Pore (Cleansing Cream) &times; 1'),(143,20,'rate_id','5'),(144,20,'label','CA State Tax'),(145,20,'compound',''),(146,20,'tax_amount','10.5'),(147,20,'shipping_tax_amount','0'),(148,20,'rate_percent','7.5'),(149,18,'_reduced_stock','1');

--
-- Table structure for table `wp_woocommerce_order_items`
--

CREATE TABLE `wp_woocommerce_order_items` (
  `order_item_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_item_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `order_item_type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `order_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`order_item_id`),
  KEY `order_id` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_order_items`
--

INSERT INTO `wp_woocommerce_order_items` VALUES (1,'Mineral Rich Mud Mask','line_item',4657),(2,'Ugenebio Skincare System','line_item',4657),(3,'Phytoplatelet Serum','line_item',4657),(4,'Local pickup','shipping',4657),(5,'US-TX-TX STATE TAX-1','tax',4657),(15,'Phytoplatelet Serum','line_item',4667),(16,'Free shipping','shipping',4667),(17,'US-TX-TX STATE TAX-1','tax',4667),(18,'Puritox Deep Pore (Cleansing Cream)','line_item',4668),(19,'Free shipping','shipping',4668),(20,'US-CA-CA STATE TAX-1','tax',4668);

--
-- Table structure for table `wp_woocommerce_payment_tokenmeta`
--

CREATE TABLE `wp_woocommerce_payment_tokenmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payment_token_id` bigint(20) unsigned NOT NULL,
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `payment_token_id` (`payment_token_id`),
  KEY `meta_key` (`meta_key`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_payment_tokenmeta`
--


--
-- Table structure for table `wp_woocommerce_payment_tokens`
--

CREATE TABLE `wp_woocommerce_payment_tokens` (
  `token_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gateway_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `token` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `type` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`token_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_payment_tokens`
--


--
-- Table structure for table `wp_woocommerce_sessions`
--

CREATE TABLE `wp_woocommerce_sessions` (
  `session_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `session_key` char(32) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `session_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `session_expiry` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`session_id`),
  UNIQUE KEY `session_key` (`session_key`)
) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_sessions`
--

INSERT INTO `wp_woocommerce_sessions` VALUES (237,'1','a:11:{s:4:\"cart\";s:882:\"a:2:{s:32:\"205c3608ecb984c1f5f5d2f52c934428\";a:11:{s:3:\"key\";s:32:\"205c3608ecb984c1f5f5d2f52c934428\";s:10:\"product_id\";i:4649;s:12:\"variation_id\";i:0;s:9:\"variation\";a:0:{}s:8:\"quantity\";i:1;s:9:\"data_hash\";s:32:\"b5c1d5ca8bae6d4896cf1807cdf763f0\";s:13:\"line_tax_data\";a:2:{s:8:\"subtotal\";a:1:{i:43;d:6.25;}s:5:\"total\";a:1:{i:43;d:6.25;}}s:13:\"line_subtotal\";d:100;s:17:\"line_subtotal_tax\";d:6.25;s:10:\"line_total\";d:100;s:8:\"line_tax\";d:6.25;}s:32:\"3cfacd1beeeb00db3c2afc128dc13b7c\";a:11:{s:3:\"key\";s:32:\"3cfacd1beeeb00db3c2afc128dc13b7c\";s:10:\"product_id\";i:4608;s:12:\"variation_id\";i:0;s:9:\"variation\";a:0:{}s:8:\"quantity\";i:1;s:9:\"data_hash\";s:32:\"b5c1d5ca8bae6d4896cf1807cdf763f0\";s:13:\"line_tax_data\";a:2:{s:8:\"subtotal\";a:1:{i:43;d:8.75;}s:5:\"total\";a:1:{i:43;d:8.75;}}s:13:\"line_subtotal\";d:140;s:17:\"line_subtotal_tax\";d:8.75;s:10:\"line_total\";d:140;s:8:\"line_tax\";d:8.75;}}\";s:11:\"cart_totals\";s:409:\"a:15:{s:8:\"subtotal\";s:3:\"240\";s:12:\"subtotal_tax\";d:15;s:14:\"shipping_total\";s:1:\"0\";s:12:\"shipping_tax\";d:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";d:0;s:12:\"discount_tax\";d:0;s:19:\"cart_contents_total\";s:3:\"240\";s:17:\"cart_contents_tax\";d:15;s:19:\"cart_contents_taxes\";a:1:{i:43;d:15;}s:9:\"fee_total\";s:1:\"0\";s:7:\"fee_tax\";d:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";s:6:\"255.00\";s:9:\"total_tax\";d:15;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";s:22:\"shipping_for_package_0\";s:1150:\"a:2:{s:12:\"package_hash\";s:40:\"wc_ship_6757223b01d989af9d9edcf938a1f84e\";s:5:\"rates\";a:3:{s:15:\"free_shipping:1\";O:16:\"WC_Shipping_Rate\":2:{s:7:\"\0*\0data\";a:6:{s:2:\"id\";s:15:\"free_shipping:1\";s:9:\"method_id\";s:13:\"free_shipping\";s:11:\"instance_id\";i:1;s:5:\"label\";s:13:\"Free shipping\";s:4:\"cost\";s:4:\"0.00\";s:5:\"taxes\";a:0:{}}s:12:\"\0*\0meta_data\";a:1:{s:5:\"Items\";s:78:\"Mineral Rich Mud Mask &times; 1, Puritox Deep Pore (Cleansing Cream) &times; 1\";}}s:14:\"local_pickup:2\";O:16:\"WC_Shipping_Rate\":2:{s:7:\"\0*\0data\";a:6:{s:2:\"id\";s:14:\"local_pickup:2\";s:9:\"method_id\";s:12:\"local_pickup\";s:11:\"instance_id\";i:2;s:5:\"label\";s:12:\"Local pickup\";s:4:\"cost\";s:4:\"0.00\";s:5:\"taxes\";a:0:{}}s:12:\"\0*\0meta_data\";a:1:{s:5:\"Items\";s:78:\"Mineral Rich Mud Mask &times; 1, Puritox Deep Pore (Cleansing Cream) &times; 1\";}}s:11:\"flat_rate:3\";O:16:\"WC_Shipping_Rate\":2:{s:7:\"\0*\0data\";a:6:{s:2:\"id\";s:11:\"flat_rate:3\";s:9:\"method_id\";s:9:\"flat_rate\";s:11:\"instance_id\";i:3;s:5:\"label\";s:8:\"Next Day\";s:4:\"cost\";s:5:\"25.00\";s:5:\"taxes\";a:0:{}}s:12:\"\0*\0meta_data\";a:1:{s:5:\"Items\";s:78:\"Mineral Rich Mud Mask &times; 1, Puritox Deep Pore (Cleansing Cream) &times; 1\";}}}}\";s:25:\"previous_shipping_methods\";s:92:\"a:1:{i:0;a:3:{i:0;s:15:\"free_shipping:1\";i:1;s:14:\"local_pickup:2\";i:2;s:11:\"flat_rate:3\";}}\";s:23:\"chosen_shipping_methods\";s:33:\"a:1:{i:0;s:15:\"free_shipping:1\";}\";s:22:\"shipping_method_counts\";s:14:\"a:1:{i:0;i:3;}\";s:8:\"customer\";s:890:\"a:27:{s:2:\"id\";s:1:\"1\";s:13:\"date_modified\";s:25:\"2023-10-06T13:26:53-05:00\";s:8:\"postcode\";s:5:\"75234\";s:4:\"city\";s:10:\"little elm\";s:9:\"address_1\";s:16:\"1234 Street Addr\";s:7:\"address\";s:16:\"1234 Street Addr\";s:9:\"address_2\";s:0:\"\";s:5:\"state\";s:2:\"TX\";s:7:\"country\";s:2:\"US\";s:17:\"shipping_postcode\";s:5:\"75234\";s:13:\"shipping_city\";s:10:\"little elm\";s:18:\"shipping_address_1\";s:16:\"1234 Street Addr\";s:16:\"shipping_address\";s:16:\"1234 Street Addr\";s:18:\"shipping_address_2\";s:0:\"\";s:14:\"shipping_state\";s:2:\"TX\";s:16:\"shipping_country\";s:2:\"US\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:10:\"first_name\";s:4:\"Dong\";s:9:\"last_name\";s:3:\"Kim\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:9:\"123456789\";s:5:\"email\";s:20:\"mars2029kr@gmail.com\";s:19:\"shipping_first_name\";s:4:\"Dong\";s:18:\"shipping_last_name\";s:3:\"Kim\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";}\";}',1697077403),(238,'17','a:7:{s:8:\"customer\";s:782:\"a:27:{s:2:\"id\";s:2:\"17\";s:13:\"date_modified\";s:25:\"2023-10-10T00:07:45-05:00\";s:8:\"postcode\";s:0:\"\";s:4:\"city\";s:0:\"\";s:9:\"address_1\";s:0:\"\";s:7:\"address\";s:0:\"\";s:9:\"address_2\";s:0:\"\";s:5:\"state\";s:2:\"TX\";s:7:\"country\";s:2:\"US\";s:17:\"shipping_postcode\";s:0:\"\";s:13:\"shipping_city\";s:0:\"\";s:18:\"shipping_address_1\";s:0:\"\";s:16:\"shipping_address\";s:0:\"\";s:18:\"shipping_address_2\";s:0:\"\";s:14:\"shipping_state\";s:0:\"\";s:16:\"shipping_country\";s:0:\"\";s:13:\"is_vat_exempt\";s:0:\"\";s:19:\"calculated_shipping\";s:0:\"\";s:10:\"first_name\";s:11:\"Dong ki Kim\";s:9:\"last_name\";s:0:\"\";s:7:\"company\";s:0:\"\";s:5:\"phone\";s:0:\"\";s:5:\"email\";s:14:\"test20@gma.com\";s:19:\"shipping_first_name\";s:11:\"Dong ki Kim\";s:18:\"shipping_last_name\";s:0:\"\";s:16:\"shipping_company\";s:0:\"\";s:14:\"shipping_phone\";s:0:\"\";}\";s:4:\"cart\";s:6:\"a:0:{}\";s:11:\"cart_totals\";s:367:\"a:15:{s:8:\"subtotal\";i:0;s:12:\"subtotal_tax\";i:0;s:14:\"shipping_total\";i:0;s:12:\"shipping_tax\";i:0;s:14:\"shipping_taxes\";a:0:{}s:14:\"discount_total\";i:0;s:12:\"discount_tax\";i:0;s:19:\"cart_contents_total\";i:0;s:17:\"cart_contents_tax\";i:0;s:19:\"cart_contents_taxes\";a:0:{}s:9:\"fee_total\";i:0;s:7:\"fee_tax\";i:0;s:9:\"fee_taxes\";a:0:{}s:5:\"total\";i:0;s:9:\"total_tax\";i:0;}\";s:15:\"applied_coupons\";s:6:\"a:0:{}\";s:22:\"coupon_discount_totals\";s:6:\"a:0:{}\";s:26:\"coupon_discount_tax_totals\";s:6:\"a:0:{}\";s:21:\"removed_cart_contents\";s:6:\"a:0:{}\";}',1697087266);

--
-- Table structure for table `wp_woocommerce_shipping_zone_locations`
--

CREATE TABLE `wp_woocommerce_shipping_zone_locations` (
  `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_id` bigint(20) unsigned NOT NULL,
  `location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `location_id` (`location_id`),
  KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_shipping_zone_locations`
--

INSERT INTO `wp_woocommerce_shipping_zone_locations` VALUES (1,1,'US','country');

--
-- Table structure for table `wp_woocommerce_shipping_zone_methods`
--

CREATE TABLE `wp_woocommerce_shipping_zone_methods` (
  `zone_id` bigint(20) unsigned NOT NULL,
  `instance_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `method_id` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `method_order` bigint(20) unsigned NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`instance_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_shipping_zone_methods`
--

INSERT INTO `wp_woocommerce_shipping_zone_methods` VALUES (1,1,'free_shipping',1,1),(1,2,'local_pickup',2,1),(1,3,'flat_rate',3,1);

--
-- Table structure for table `wp_woocommerce_shipping_zones`
--

CREATE TABLE `wp_woocommerce_shipping_zones` (
  `zone_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `zone_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `zone_order` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`zone_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_shipping_zones`
--

INSERT INTO `wp_woocommerce_shipping_zones` VALUES (1,'United States (US)',0);

--
-- Table structure for table `wp_woocommerce_tax_rate_locations`
--

CREATE TABLE `wp_woocommerce_tax_rate_locations` (
  `location_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `location_code` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `tax_rate_id` bigint(20) unsigned NOT NULL,
  `location_type` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`location_id`),
  KEY `tax_rate_id` (`tax_rate_id`),
  KEY `location_type_code` (`location_type`(10),`location_code`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_tax_rate_locations`
--


--
-- Table structure for table `wp_woocommerce_tax_rates`
--

CREATE TABLE `wp_woocommerce_tax_rates` (
  `tax_rate_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tax_rate_country` varchar(2) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate_state` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate` varchar(8) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `tax_rate_name` varchar(200) COLLATE utf8mb4_unicode_520_ci 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) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`tax_rate_id`),
  KEY `tax_rate_country` (`tax_rate_country`),
  KEY `tax_rate_state` (`tax_rate_state`(2)),
  KEY `tax_rate_class` (`tax_rate_class`(10)),
  KEY `tax_rate_priority` (`tax_rate_priority`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_woocommerce_tax_rates`
--

INSERT INTO `wp_woocommerce_tax_rates` VALUES (1,'US','AK','0.0000','AK State Tax',1,0,0,0,''),(2,'US','AL','4.0000','AL State Tax',1,0,0,1,''),(3,'US','AR','6.5000','AR State Tax',1,0,0,2,''),(4,'US','AZ','5.6000','AZ State Tax',1,0,0,3,''),(5,'US','CA','7.5000','CA State Tax',1,0,0,4,''),(6,'US','CO','2.9000','CO State Tax',1,0,0,5,''),(7,'US','CT','6.3500','CT State Tax',1,0,0,6,''),(8,'US','DE','0.0000','DE State Tax',1,0,0,7,''),(9,'US','FL','6.0000','FL State Tax',1,0,0,8,''),(10,'US','GA','4.0000','GA State Tax',1,0,0,9,''),(11,'US','HI','4.0000','HI State Tax',1,0,0,10,''),(12,'US','IA','6.0000','IA State Tax',1,0,0,11,''),(13,'US','ID','6.0000','ID State Tax',1,0,0,12,''),(14,'US','IL','6.2500','IL State Tax',1,0,0,13,''),(15,'US','IN','7.0000','IN State Tax',1,0,0,14,''),(16,'US','KS','6.1500','KS State Tax',1,0,0,15,''),(17,'US','KY','6.0000','KY State Tax',1,0,0,16,''),(18,'US','LA','4.0000','LA State Tax',1,0,0,17,''),(19,'US','MA','6.2500','MA State Tax',1,0,0,18,''),(20,'US','MD','6.0000','MD State Tax',1,0,0,19,''),(21,'US','ME','5.5000','ME State Tax',1,0,0,20,''),(22,'US','MI','6.0000','MI State Tax',1,0,0,21,''),(23,'US','MN','6.8800','MN State Tax',1,0,0,22,''),(24,'US','MO','4.2300','MO State Tax',1,0,0,23,''),(25,'US','MS','7.0000','MS State Tax',1,0,0,24,''),(26,'US','MT','0.0000','MT State Tax',1,0,0,25,''),(27,'US','NC','4.7500','NC State Tax',1,0,0,26,''),(28,'US','ND','5.0000','ND State Tax',1,0,0,27,''),(29,'US','NE','5.5000','NE State Tax',1,0,0,28,''),(30,'US','NH','0.0000','NH State Tax',1,0,0,29,''),(31,'US','NJ','7.0000','NJ State Tax',1,0,0,30,''),(32,'US','NM','5.1300','NM State Tax',1,0,0,31,''),(33,'US','NV','6.8500','NV State Tax',1,0,0,32,''),(34,'US','NY','4.0000','NY State Tax',1,0,0,33,''),(35,'US','OH','5.7500','OH State Tax',1,0,0,34,''),(36,'US','OK','4.5000','OK State Tax',1,0,0,35,''),(37,'US','OR','0.0000','OR State Tax',1,0,0,36,''),(38,'US','PA','6.0000','PA State Tax',1,0,0,37,''),(39,'US','RI','7.0000','RI State Tax',1,0,0,38,''),(40,'US','SC','6.0000','SC State Tax',1,0,0,39,''),(41,'US','SD','4.0000','SD State Tax',1,0,0,40,''),(42,'US','TN','7.0000','TN State Tax',1,0,0,41,''),(43,'US','TX','6.2500','TX State Tax',1,0,0,42,''),(44,'US','UT','5.9500','UT State Tax',1,0,0,43,''),(45,'US','VA','5.3000','VA State Tax',1,0,0,44,''),(46,'US','VT','6.0000','VT State Tax',1,0,0,45,''),(47,'US','WA','6.5000','WA State Tax',1,0,0,46,''),(48,'US','WI','5.0000','WI State Tax',1,0,0,47,''),(49,'US','WV','6.0000','WV State Tax',1,0,0,48,''),(50,'US','WY','4.0000','WY State Tax',1,0,0,49,'');

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

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

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


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

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

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


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

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

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

INSERT INTO `wp_wpforms_tasks_meta` VALUES (1,'wpforms_process_forms_locator_scan','W10=','2023-09-17 03:59:05'),(4,'wpforms_process_forms_locator_scan','W10=','2023-09-17 03:59:20'),(17,'wpforms_admin_addons_cache_update','W10=','2023-09-24 02:29:34'),(19,'wpforms_builder_help_cache_update','W10=','2023-09-24 06:28:45'),(20,'wpforms_admin_builder_templates_cache_update','W10=','2023-09-24 06:28:45'),(25,'wpforms_process_forms_locator_scan','W10=','2023-09-27 03:16:50'),(36,'wpforms_admin_addons_cache_update','W10=','2023-10-02 17:50:08'),(37,'wpforms_admin_builder_templates_cache_update','W10=','2023-10-02 17:50:08');

--
-- Table structure for table `wp_wpmailsmtp_debug_events`
--

CREATE TABLE `wp_wpmailsmtp_debug_events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` text COLLATE utf8mb4_unicode_520_ci,
  `initiator` text COLLATE utf8mb4_unicode_520_ci,
  `event_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_wpmailsmtp_debug_events`
--

INSERT INTO `wp_wpmailsmtp_debug_events` VALUES (1,'Mailer: Other SMTP\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.','{\"file\":\"\\/home4\\/ugenebio\\/usa.ugenebio.com\\/wp-content\\/plugins\\/wpforms-lite\\/includes\\/emails\\/class-emails.php\",\"line\":438}',0,'2023-09-24 02:37:26'),(2,'Mailer: Other SMTP\r\nSMTP Error: The following recipients failed: email@example.com: \"Sorry, you are sending to/from an address that has been blacklisted\"','{\"file\":\"\\/home4\\/ugenebio\\/usa.ugenebio.com\\/wp-content\\/plugins\\/wpforms-lite\\/includes\\/emails\\/class-emails.php\",\"line\":438}',0,'2023-09-24 02:37:26'),(3,'Mailer: Other SMTP\r\nPHPMailer was able to connect to SMTP server but failed while trying to send an email.','{\"file\":\"\\/home4\\/ugenebio\\/usa.ugenebio.com\\/wp-content\\/plugins\\/wpforms-lite\\/includes\\/emails\\/class-emails.php\",\"line\":438}',0,'2023-09-24 11:27:57'),(4,'Mailer: Other SMTP\r\nSMTP Error: The following recipients failed: email@example.com: \"Sorry, you are sending to/from an address that has been blacklisted\"','{\"file\":\"\\/home4\\/ugenebio\\/usa.ugenebio.com\\/wp-content\\/plugins\\/wpforms-lite\\/includes\\/emails\\/class-emails.php\",\"line\":438}',0,'2023-09-24 11:27:57');

--
-- Table structure for table `wp_wpmailsmtp_tasks_meta`
--

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

--
-- Dumping data for table `wp_wpmailsmtp_tasks_meta`
--

INSERT INTO `wp_wpmailsmtp_tasks_meta` VALUES (1,'wp_mail_smtp_admin_notifications_update','W10=','2023-09-17 04:01:38');

--
-- Table structure for table `wp_xyz_ips_short_code`
--

CREATE TABLE `wp_xyz_ips_short_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(1000) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `short_code` varchar(2000) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wp_xyz_ips_short_code`
--

INSERT INTO `wp_xyz_ips_short_code` VALUES (1,'Genealogy','<?php\r\n\r\n$current_user_id = get_current_user_id();\r\n$login_user_mb_multy = get_user_meta($current_user_id ,\'mb_multy\' );\r\n\r\n\r\n$user_admin_check = get_userdata($current_user_id );\r\n$user_admin_check_role = $user_admin_check ->roles[0];\r\nif( $user_admin_check_role == \"administrator\"){\r\n    $login_user_mb_multy[0]  = \'101\';\r\n}\r\n\r\n//print_r($login_user_mb_multy );\r\n\r\nif(empty($login_user_mb_multy )){\r\n   $result_data = \"\";\r\n}else{\r\n$querys = \"select\r\n      t1.id as user_id_code,\r\n	   ifnull(max(case when `meta_key` = \'mb_multy\' then meta_value end),\'\') as id,\r\n       ifnull(max(case when `meta_key` = \'mb_multy_parent\' then meta_value end),\'\') as parent,\r\n       \'\' as description, \r\n       t1.user_email as email,\r\n       \'\' as groupTitleColor, \r\n       \'\' as image, \r\n       \'\' as itemTitleColor, \r\n       ifnull(max(case when `meta_key` = \'xoo_aff_phone\' then meta_value end),\'\') as phone,        \r\n       concat(ifnull(max(case when `meta_key` = \'first_name\' then meta_value end),\'\'),\' \', ifnull(max(case when `meta_key` = \'last_name\' then meta_value end),\'\') ,\' (\',user_login,\')\') as title , \r\n       concat(ifnull(max(case when `meta_key` = \'first_name\' then meta_value end),\'\'),\' \', ifnull(max(case when `meta_key` = \'last_name\' then meta_value end),\'\')) as label,\r\n       ifnull(max(case when `meta_key` = \'wp_capabilities\' then meta_value end),\'\') as level\r\nfrom wp_users t1 left join\r\n     wp_usermeta t2\r\n     on t1.id = t2.user_id\r\nwhere t1.id in (SELECT user_id FROM wp_usermeta WHERE meta_key = \'mb_multy\' and meta_value like  concat(\'\".$login_user_mb_multy[0].\"\',\'%\'))\r\ngroup by t1.user_login;\";\r\n\r\n$result= $wpdb->get_results( $querys  );\r\n\r\n\r\n\r\nforeach($result as $row){  \r\n $user_meta = get_userdata($row->user_id_code);\r\n $row->level = $user_meta->roles[0];\r\n\r\nif( $row->level == \'member\'){\r\n			$row->description = \"Member\";\r\n			$row->groupTitleColor = \"#81b2ff\";\r\n			$row->itemTitleColor = \"#81b2ff\";\r\n			$row->image = \"/img/graph/s.png\";\r\n\r\n		}else if( $row->level == \'merchant\'){\r\n			$row->description = \"Merchant\";\r\n			$row->groupTitleColor = \"#4169e1\";\r\n			$row->itemTitleColor = \"#4169e1\";\r\n			$row->image = \"/img/graph/m.png\";\r\n\r\n		}else if( $row->level == \'builder\'){\r\n			$row->description = \"Builder\";\r\n			$row->groupTitleColor = \"#c57f7f\";\r\n			$row->itemTitleColor = \"#c57f7f\";\r\n			$row->image = \"/img/graph/b.png\";\r\n				\r\n		}else if( $row->level == \'regional\'){\r\n			$row->description = \"Regional\";\r\n			$row->groupTitleColor = \"#4b0082\";\r\n			$row->itemTitleColor = \"#4b0082\";\r\n			$row->image = \"/img/graph/r.png\";\r\n				\r\n		}else if( $row->level == \'national\'){\r\n			$row->description = \"National\";\r\n			$row->groupTitleColor = \"#e64848\";\r\n			$row->itemTitleColor = \"#e64848\";\r\n			$row->image = \"/img/graph/n.png\";\r\n			\r\n		}else if( $row->level == \'global\'){\r\n			$row->description = \"Global\";\r\n			$row->groupTitleColor = \"#000000\";\r\n			$row->itemTitleColor = \"#000000\";\r\n			$row->image = \"/img/graph/g.png\";\r\n			\r\n		}else if( $row->level == \'administrator\'){\r\n			$row->description = \"Administrator\";\r\n			$row->groupTitleColor = \"#ff0000\";\r\n			$row->itemTitleColor = \"#ff0000\";\r\n			$row->image = \"/img/graph/a.png\";\r\n			\r\n		}else{\r\n			$row->description = \"ETC\";\r\n			$row->groupTitleColor = \"#808000\";\r\n			$row->itemTitleColor = \"#808000\";\r\n			$row->image = \"/img/graph/x.png\";\r\n		}\r\n }\r\n\r\n$result_data =  json_encode($result);\r\n//print_r($resultx );\r\n}\r\n\r\n?>\r\n<html>\r\n<head>\r\n    <title>My Genealogy </title>\r\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\r\n    <script type=\"text/javascript\" src=\"/js/prigraph/js/jquery/jquery-1.9.1.js\"></script>\r\n    <script type=\"text/javascript\" src=\"/js/prigraph/js/jquery/jquery-ui-1.10.2.custom.min.js\"></script>\r\n    <link href=\"/js/prigraph/js/jquery/ui-lightness/jquery-ui-1.10.2.custom.css\" media=\"screen\" rel=\"stylesheet\" type=\"text/css\" />\r\n<link href=\"/css/bootstrap.min.css\" rel=\"stylesheet\">\r\n<link href=\"/css/font-awesome.min.css\" rel=\"stylesheet\">\r\n    <!-- jQuery UI Layout -->\r\n    <script type=\"text/javascript\" src=\"/js/prigraph/jquerylayout/jquery.layout-latest.min.js\"></script>\r\n    <link rel=\"stylesheet\" type=\"text/css\" href=\"/js/prigraph/jquerylayout/layout-default-latest.css\" />\r\n\r\n    <script type=\"text/javascript\">\r\n        jQuery(document).ready(function () {\r\n            jQuery(\'body\').layout(\r\n			{\r\n			    center__paneSelector: \"#contentpanel\"\r\n			});\r\n        });\r\n    </script>\r\n\r\n    <!-- header -->\r\n\r\n\r\n    <!-- # include file=\"src/src.primitives.html\"-->\r\n\r\n    \r\n    <link href=\"/js/prigraph/css/primitives.latest.css?2100\" media=\"screen\" rel=\"stylesheet\" type=\"text/css\" />    \r\n    <link href=\"/js/prigraph/css/bporgeditor.latest.css?2100\" media=\"screen\" rel=\"stylesheet\" type=\"text/css\" />    \r\n    \r\n    <script  type=\"text/javascript\" src=\"/js/prigraph/js/primitives.min.js?2100\"></script>\r\n    <script type=\"text/javascript\" src=\"/js/prigraph/js/bporgeditor.min.js?2100\"></script>\r\n        \r\n        \r\n\r\n    <script type=\"text/javascript\" >\r\n    	\r\n\r\n    var data = <?php echo $result_data; ?>\r\n    </script>\r\n\r\n    <script type=\"text/javascript\">\r\n    \r\n   \r\n        var orgDiagram = null;\r\n        var treeItems = {};\r\n\r\n        jQuery(document).ready(function () {\r\n            jQuery.ajaxSetup({\r\n                cache: false\r\n            });\r\n\r\n            jQuery(\'#contentpanel\').layout(\r\n			{\r\n			    center__paneSelector: \"#centerpanel\"\r\n			\r\n				, north__size: 107\r\n				, north__slidable:false	// OVERRIDE the pane-default of \'slidable=true\'\r\n				, north__paneSelector: \"#westpanel\"\r\n				, north__resizable: true\r\n				, center__onresize: function () {\r\n				    if (orgDiagram != null) {\r\n				        jQuery(\"#centerpanel\").orgDiagram(\"update\", primitives.common.UpdateMode.Refresh);\r\n				    }\r\n				}\r\n			});\r\n\r\n            function ContainsKeyValue(obj, key, value) {\r\n                if (obj[key] == value)\r\n                    return { exist: true, json: obj };\r\n\r\n                for (all in obj) {\r\n                    if (obj[all] != null && obj[all][key] == value)\r\n                        return { exist: true, json: obj[all] };\r\n\r\n                    if (typeof obj[all] == \"object\" && obj[all] != null) {\r\n                        var found = ContainsKeyValue(obj[all], key, value);\r\n                        if (found.exist == true)\r\n                            return { exist: true, json: found.json };\r\n                    }\r\n                }\r\n                return { exist: false, json: null };\r\n            }\r\n\r\n            /* Page Fit Mode */\r\n            var pageFitModes = jQuery(\"#pageFitMode\");\r\n            for (var key in primitives.common.PageFitMode) {\r\n                var value = primitives.common.PageFitMode[key];\r\n                pageFitModes.append(jQuery(\"<label style=\'font-weight:normal;margin-left:7px;\'><input name=\'pageFitMode\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.PageFitMode.FitToPage ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=pageFitMode]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n\r\n            /* Orientation Type */\r\n         /*    var orientationTypes = jQuery(\"#orientationType\");\r\n            for (var key in primitives.common.OrientationType) {\r\n                var value = primitives.common.OrientationType[key];\r\n                orientationTypes.append(jQuery(\"<br/><label><input name=\'orientationType\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.OrientationType.Top ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=orientationType]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            }); */\r\n\r\n           /* Vertical Alignmnet */\r\n         /*     var verticalAlignments = jQuery(\"#verticalAlignment\");\r\n            for (var key in primitives.common.VerticalAlignmentType) {\r\n                var value = primitives.common.VerticalAlignmentType[key];\r\n                verticalAlignments.append(jQuery(\"<br/><label><input name=\'verticalAlignment\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.VerticalAlignmentType.Middle ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=verticalAlignment]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n            */\r\n            /* Horizontal Alignmnet */\r\n          /*    var horizontalAlignments = jQuery(\"#horizontalAlignment\");\r\n            for (var key in primitives.common.HorizontalAlignmentType) {\r\n                var value = primitives.common.HorizontalAlignmentType[key];\r\n                horizontalAlignments.append(jQuery(\"<br/><label><input name=\'horizontalAlignment\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.HorizontalAlignmentType.Center ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            }; */\r\n\r\n            jQuery(\"input:radio[name=horizontalAlignment]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n\r\n            /* Minimal Visibility */\r\n          /*   var pageFitModes = jQuery(\"#minimalVisibility\");\r\n            for (var key in primitives.common.Visibility) {\r\n                var value = primitives.common.Visibility[key];\r\n                pageFitModes.append(jQuery(\"<br/><label><input name=\'minimalVisibility\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.Visibility.Dot ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=minimalVisibility]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n */\r\n            /* Selection Path Mode */\r\n            var selectionPathModes = jQuery(\"#selectionPathMode\");\r\n            for (var key in primitives.common.SelectionPathMode) {\r\n                var value = primitives.common.SelectionPathMode[key];\r\n                selectionPathModes.append(jQuery(\"<br/><label><input name=\'selectionPathMode\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.SelectionPathMode.FullStack ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=selectionPathMode]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n\r\n            /* Leaves Placement Type */\r\n        /*     var leavesPlacementType = jQuery(\"#leavesPlacementType\");\r\n            for (var key in primitives.common.ChildrenPlacementType) {\r\n                var value = primitives.common.ChildrenPlacementType[key];\r\n                leavesPlacementType.append(jQuery(\"<br/><label><input name=\'leavesPlacementType\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.ChildrenPlacementType.Horizontal ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=leavesPlacementType]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n */\r\n            /* Has Selector Check Box*/\r\n          /*   var hasSelectorCheckbox = jQuery(\"#hasSelectorCheckbox\");\r\n            for (var key in primitives.common.Enabled) {\r\n                var value = primitives.common.Enabled[key];\r\n                hasSelectorCheckbox.append(jQuery(\"<br/><label><input name=\'hasSelectorCheckbox\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.Enabled.True ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=hasSelectorCheckbox]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            }); */\r\n\r\n            /* Has User Buttons */\r\n            var hasButtons = jQuery(\"#hasButtons\");\r\n            for (var key in primitives.common.Enabled) {\r\n                var value = primitives.common.Enabled[key];\r\n                hasButtons.append(jQuery(\"<br/><label><input name=\'hasButtons\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.Enabled.Auto ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=hasButtons]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n\r\n            /* Items Group By Type */\r\n       /*      var arrowsDirections = jQuery(\"#arrowsDirection\");\r\n            for (var key in primitives.common.GroupByType) {\r\n                var value = primitives.common.GroupByType[key];\r\n                arrowsDirections.append(jQuery(\"<br/><label><input name=\'arrowsDirection\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.GroupByType.None ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=arrowsDirection]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            }); */\r\n\r\n            /* Connector Type */\r\n      /*       var connectorTypes = jQuery(\"#connectorType\");\r\n            for (var key in primitives.common.ConnectorType) {\r\n                var value = primitives.common.ConnectorType[key];\r\n                connectorTypes.append(jQuery(\"<br/><label><input name=\'connectorType\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.ConnectorType.Squared ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n */\r\n          /*   jQuery(\"input:radio[name=connectorType]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n */\r\n            /* Connectors Elbows Type */\r\n           /*  var elbowTypes = jQuery(\"#elbowType\");\r\n            for (var key in primitives.common.ElbowType) {\r\n                var value = primitives.common.ElbowType[key];\r\n                elbowTypes.append(jQuery(\"<br/><label><input name=\'elbowType\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.ElbowType.None ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=elbowType]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n */\r\n            // lineType\r\n         /*    var connectorShapeType = jQuery(\"#lineType\");\r\n            for (var key in primitives.common.LineType) {\r\n                var value = primitives.common.LineType[key];\r\n                connectorShapeType.append(jQuery(\"<br/><label><input name=\'lineType\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.LineType.Solid ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=lineType]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            }); */\r\n\r\n            // color\r\n           /*  var color = jQuery(\"<select></select>\");\r\n            jQuery(\"#color\").append(color);\r\n            for (var key in primitives.common.Colors) {\r\n                var value = primitives.common.Colors[key];\r\n                color.append(jQuery(\"<option value=\'\" + value + \"\' \" + (value == primitives.common.Colors.Silver ? \"selected\" : \"\") + \" >\" + key + \"</option>\"));\r\n            };\r\n\r\n            jQuery(\"#color\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n */\r\n            // minimizedItemCornerRadius\r\n            var minimizedItemCornerRadiuses = [\"NULL\", 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10];\r\n            var minimizedItemCornerRadius = jQuery(\"<select></select>\");\r\n            jQuery(\"#minimizedItemCornerRadius\").append(minimizedItemCornerRadius);\r\n            for (var index = 0; index < minimizedItemCornerRadiuses.length; index += 1) {\r\n                var value = minimizedItemCornerRadiuses[index];\r\n                minimizedItemCornerRadius.append(jQuery(\"<option value=\'\" + (value == \"NULL\" ? -1 : value) + \"\' \" + (value == \"NULL\" ? \"selected\" : \"\") + \" >\" + value + \"</option>\"));\r\n            };\r\n\r\n            jQuery(\"#minimizedItemCornerRadius\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Redraw);\r\n            });\r\n\r\n            // minimizedItemSize\r\n            var minimizedItemSizes = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 14, 16, 18, 20, 30, 40];\r\n            var minimizedItemSize = jQuery(\"<select></select>\");\r\n            jQuery(\"#minimizedItemSize\").append(minimizedItemSize);\r\n            for (var index = 0; index < minimizedItemSizes.length; index += 1) {\r\n                var value = minimizedItemSizes[index];\r\n                minimizedItemSize.append(jQuery(\"<option value=\'\" + value + \"\' \" + (value == 4 ? \"selected\" : \"\") + \" >\" + value + \"</option>\"));\r\n            };\r\n\r\n            jQuery(\"#minimizedItemSize\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Redraw);\r\n            });\r\n\r\n            // highlightPadding\r\n            var highlightPaddings = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10];\r\n            var highlightPadding = jQuery(\"<select></select>\");\r\n            jQuery(\"#highlightPadding\").append(highlightPadding);\r\n            for (var index = 0; index < highlightPaddings.length; index += 1) {\r\n                var value = highlightPaddings[index];\r\n                highlightPadding.append(jQuery(\"<option value=\'\" + value + \"\' \" + (value == 2 ? \"selected\" : \"\") + \" >\" + value + \"</option>\"));\r\n            };\r\n\r\n            jQuery(\"#highlightPadding\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Redraw);\r\n            });\r\n\r\n            // Intervals\r\n            var intervalNames = [\"normalLevelShift\", \"dotLevelShift\", \"lineLevelShift\", \"normalItemsInterval\", \"dotItemsInterval\", \"lineItemsInterval\", \"cousinsIntervalMultiplier\"];\r\n            var intervals = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 14, 16, 18, 20, 30, 40];\r\n            var defaultConfig = new primitives.orgdiagram.Config();\r\n            defaultConfig.dotItemsInterval = 2;\r\n            \r\n            for (var intervalIndex = 0; intervalIndex < intervalNames.length; intervalIndex++) {\r\n                var intervalName = intervalNames[intervalIndex];\r\n                var intervalSelector = jQuery(\"<select></select>\");\r\n                jQuery(\"#\" + intervalName).append(intervalSelector);\r\n                for (var index = 0; index < intervals.length; index += 1) {\r\n                    var value = intervals[index];\r\n                    var defaultValue = defaultConfig[intervalName];\r\n\r\n                    intervalSelector.append(jQuery(\"<option value=\'\" + value + \"\' \" + (value == defaultValue ? \"selected\" : \"\") + \" >\" + value + \"</option>\"));\r\n                };\r\n\r\n                jQuery(\"#\" + intervalName).change(function () {\r\n                    Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n                });\r\n            }\r\n\r\n            // lineWidth\r\n         /*    var lineWidths = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10];\r\n            var lineWidth = jQuery(\"<select></select>\");\r\n            jQuery(\"#lineWidth\").append(lineWidth);\r\n            for (var index = 0; index < lineWidths.length; index += 1) {\r\n                var value = lineWidths[index];\r\n                lineWidth.append(jQuery(\"<option value=\'\" + value + \"\' \" + (value == 1 ? \"selected\" : \"\") + \" >\" + value + \"</option>\"));\r\n            };\r\n\r\n            jQuery(\"#lineWidth\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            }); */\r\n\r\n            /* Show Labels */\r\n      /*       var showLabels = jQuery(\"#showLabels\");\r\n            for (var key in primitives.common.Enabled) {\r\n                var value = primitives.common.Enabled[key];\r\n                showLabels.append(jQuery(\"<br/><label><input name=\'showLabels\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.Enabled.Auto ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=showLabels]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n */\r\n            /* Label Orientations */\r\n         /*    var labelOrientations = jQuery(\"#labelOrientation\");\r\n            for (var key in primitives.text.TextOrientationType) {\r\n                var value = primitives.text.TextOrientationType[key];\r\n                labelOrientations.append(jQuery(\"<br/><label><input name=\'labelOrientation\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.text.TextOrientationType.Horizontal ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=labelOrientation]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            }); */\r\n\r\n            /* Label Placement */\r\n          /*   var labelPlacements = jQuery(\"#labelPlacement\");\r\n            for (var key in primitives.common.PlacementType) {\r\n                var value = primitives.common.PlacementType[key];\r\n                labelPlacements.append(jQuery(\"<br/><label><input name=\'labelPlacement\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.PlacementType.Top ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=labelPlacement]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Refresh);\r\n            });\r\n */\r\n            /* Graphics Type */\r\n            var graphicsType = jQuery(\"#graphicsType\");\r\n            for (var key in primitives.common.GraphicsType) {\r\n                var value = primitives.common.GraphicsType[key];\r\n                graphicsType.append(jQuery(\"<br/><label><input name=\'graphicsType\' type=\'radio\' value=\'\" + value + \"\' \" + (value == primitives.common.GraphicsType.SVG ? \"checked\" : \"\") + \" />\" + key + \"</label>\"));\r\n            };\r\n\r\n            jQuery(\"input:radio[name=graphicsType]\").change(function () {\r\n                Update(jQuery(\"#centerpanel\"), primitives.common.UpdateMode.Recreate);\r\n            });\r\n\r\n            /* Setup & Run */\r\n            Setup(jQuery(\"#centerpanel\"));\r\n\r\n            /* Load data */\r\n            LoadData(jQuery(\"#centerpanel\"));\r\n        });\r\n\r\n        function Setup(selector) {\r\n            orgDiagram = selector.orgDiagram(GetOrgDiagramConfig());\r\n\r\n            ShowGraphicsType(selector.orgDiagram(\"option\", \"actualGraphicsType\"));\r\n        }\r\n\r\n        function LoadData(selector) {\r\n            var index, len;\r\n            for (index = 0, len = data.length; index < len; index += 1) {\r\n                treeItems[data[index].id] = data[index];\r\n            }\r\n\r\n            /* set template for cursor item */\r\n            data[0].templateName = \"contactTemplate\";\r\n\r\n            selector.orgDiagram(\"option\", {\r\n                items: data,\r\n                cursorItem: 0\r\n            });\r\n            selector.orgDiagram(\"update\");\r\n        }\r\n\r\n\r\n        function Update(selector, updateMode) {\r\n            selector.orgDiagram(\"option\", GetOrgDiagramConfig());\r\n            selector.orgDiagram(\"update\", updateMode);\r\n\r\n            ShowGraphicsType(selector.orgDiagram(\"option\", \"actualGraphicsType\"));\r\n        }\r\n\r\n        function GetOrgDiagramConfig() {\r\n            /* var graphicsType = parseInt(jQuery(\"input:radio[name=graphicsType]:checked\").val(), 10); */\r\n            var pageFitMode = parseInt(jQuery(\"input:radio[name=pageFitMode]:checked\").val(), 10);\r\n        /*     var orientationType = parseInt(jQuery(\"input:radio[name=orientationType]:checked\").val(), 10); */\r\n          /*   var minimalVisibility = parseInt(jQuery(\"input:radio[name=minimalVisibility]:checked\").val(), 10); */\r\n/*             var selectionPathMode = parseInt(jQuery(\"input:radio[name=selectionPathMode]:checked\").val(), 10); */\r\n         /*    var leavesPlacementType = parseInt(jQuery(\"input:radio[name=leavesPlacementType]:checked\").val(), 10); */\r\n           // var hasSelectorCheckbox = parseInt(jQuery(\"input:radio[name=hasSelectorCheckbox]:checked\").val(), 10);\r\n            //var hasButtons = parseInt(jQuery(\"input:radio[name=hasButtons]:checked\").val(), 10);\r\n         //   var verticalAlignment = parseInt(jQuery(\"input:radio[name=verticalAlignment]:checked\").val(), 10);\r\n            var horizontalAlignment = parseInt(jQuery(\"input:radio[name=horizontalAlignment]:checked\").val(), 10);\r\n       /*      var connectorType = parseInt(jQuery(\"input:radio[name=connectorType]:checked\").val(), 10); */\r\n           /*  var elbowType = parseInt(jQuery(\"input:radio[name=elbowType]:checked\").val(), 10); */\r\n            \r\n            \r\n         //   var showLabels = parseInt(jQuery(\"input:radio[name=showLabels]:checked\").val(), 10);\r\n\r\n            var labelOrientation = parseInt(jQuery(\"input:radio[name=labelOrientation]:checked\").val(), 10);\r\n           /*  var labelPlacement = parseInt(jQuery(\"input:radio[name=labelPlacement]:checked\").val(), 10); */\r\n          /*   var color = jQuery(\"#color option:selected\").val(); */\r\n         /*    var lineWidth = parseInt(jQuery(\"#lineWidth option:selected\").val(), 10); */\r\n            /* var lineType = parseInt(jQuery(\"input:radio[name=lineType]:checked\").val(), 10); */\r\n          //  var arrowsDirection = parseInt(jQuery(\"input:radio[name=arrowsDirection]:checked\").val(), 10);\r\n\r\n\r\n            var minimizedItemCornerRadius = parseInt(jQuery(\"#minimizedItemCornerRadius option:selected\").val(), 10);\r\n            minimizedItemCornerRadius = minimizedItemCornerRadius == -1 ? null : minimizedItemCornerRadius;\r\n\r\n            var minimizedItemSize = parseInt(jQuery(\"#minimizedItemSize option:selected\").val(), 10);\r\n            var highlightPadding = parseInt(jQuery(\"#highlightPadding option:selected\").val(), 10);\r\n\r\n          /*   var normalLevelShift = parseInt(jQuery(\"#normalLevelShift option:selected\").val(), 10);\r\n            var dotLevelShift = parseInt(jQuery(\"#dotLevelShift option:selected\").val(), 10); */\r\n           /*  var lineLevelShift = parseInt(jQuery(\"#lineLevelShift option:selected\").val(), 10); */\r\n            /* var normalItemsInterval = parseInt(jQuery(\"#normalItemsInterval option:selected\").val(), 10); */\r\n            /* var dotItemsInterval = parseInt(jQuery(\"#dotItemsInterval option:selected\").val(), 10); */\r\n            /* var lineItemsInterval = parseInt(jQuery(\"#lineItemsInterval option:selected\").val(), 10); */\r\n            /* var cousinsIntervalMultiplier = parseInt(jQuery(\"#cousinsIntervalMultiplier option:selected\").val(), 10); */\r\n\r\n            var buttons = [];\r\n            buttons.push(new primitives.orgdiagram.ButtonConfig(\"delete\", \"ui-icon-close\", \"Delete\"));\r\n            buttons.push(new primitives.orgdiagram.ButtonConfig(\"properties\", \"ui-icon-gear\", \"Info\"));\r\n            buttons.push(new primitives.orgdiagram.ButtonConfig(\"add\", \"ui-icon-person\", \"Add\"));\r\n\r\n            var templates = [\r\n                getContactTemplate(2, 4, 2),\r\n                getRegularTemplate(),\r\n                getLoaderTemplate()\r\n            ];\r\n\r\n            return {\r\n                graphicsType: 0,\r\n                pageFitMode: pageFitMode,\r\n                orientationType: 0,\r\n                verticalAlignment: 0,\r\n                horizontalAlignment: 0,\r\n                arrowsDirection: 0,\r\n                connectorType: 0,\r\n                elbowType: 0,\r\n                minimalVisibility: 2,\r\n                hasSelectorCheckbox: 2,\r\n                selectionPathMode: 1,\r\n                leavesPlacementType: 0,\r\n                hasButtons: 2,\r\n                buttons: buttons,\r\n                templates: templates,\r\n                onButtonClick: onButtonClick,\r\n                onCursorChanging: onCursorChanging,\r\n                onCursorChanged: onCursorChanged,\r\n                onMouseClick: onMouseClick,\r\n                onMouseDblClick: onMouseDblClick,\r\n                onHighlightChanging: onHighlightChanging,\r\n                onHighlightChanged: onHighlightChanged,\r\n                onSelectionChanged: onSelectionChanged,\r\n                onItemRender: onTemplateRender,\r\n                itemTitleFirstFontColor: primitives.common.Colors.White,\r\n                itemTitleSecondFontColor: primitives.common.Colors.White,\r\n                showLabels: 2,\r\n                labelOrientation: 0,\r\n                labelPlacement: 2,\r\n                labelOffset: 2,\r\n                linesType: 0,\r\n                linesColor: \"#c0c0c0\",\r\n                linesWidth: 1,\r\n                defaultTemplateName: \"regularTemplate\",\r\n                normalLevelShift: 20,\r\n                dotLevelShift: 20,\r\n                lineLevelShift: 10,\r\n                normalItemsInterval: 10,\r\n                dotItemsInterval: 2,\r\n                lineItemsInterval: 2, \r\n                cousinsIntervalMultiplier: 5\r\n            };\r\n        }\r\n\r\n        \r\n        function getRegularTemplate() {\r\n            var result = new primitives.orgdiagram.TemplateConfig();\r\n            result.name = \"regularTemplate\";\r\n\r\n            result.itemSize = new primitives.common.Size(180, 90);\r\n            result.minimizedItemSize = new primitives.common.Size(4, 4);\r\n            result.highlightPadding = new primitives.common.Thickness(2, 2, 2, 2);\r\n\r\n\r\n            var itemTemplate = jQuery(\r\n              \'<div class=\"bp-item bp-corner-all bt-item-frame\">\'\r\n                + \'<div name=\"titleBackground\" class=\"bp-item bp-corner-all bp-title-frame\" style=\"top: 2px; left: 2px; width: 176px; height: 18px; overflow: hidden; text-align:center;\">\'\r\n                    + \'<div name=\"title\" class=\"bp-item bp-title\" style=\"top: 2px; left: 2px; width: 172px; height: 14px; font-size: 12px; overflow: hidden;\">\'\r\n                    + \'</div>\'\r\n                + \'</div>\'\r\n                + \'<div class=\"bp-item bp-photo-frame\" style=\"top: 22px; left: 2px; width: 50px; height: 60px; overflow: hidden;\">\'\r\n                    + \'<img name=\"photo\" style=\"height:60px; width:50px;\" />\'\r\n                + \'</div>\'\r\n                + \'<div class=\"bp-item\" style=\"top: 22px; left: 56px; width: 118px; height: 13px; font-size: 11px;\"><a name=\"email\" href=\"\" target=\"_top\"></a></div>\'\r\n                + \'<div name=\"description\" class=\"bp-item\" style=\"top: 37px; left: 56px; width: 118px; height: 39px; font-size: 11px; overflow: hidden;\"></div>\'\r\n            + \'</div>\'\r\n            ).css({\r\n                width: result.itemSize.width + \"px\",\r\n                height: result.itemSize.height + \"px\"\r\n            }).addClass(\"bp-item bp-corner-all bt-item-frame\");\r\n            result.itemTemplate = itemTemplate.wrap(\'<div>\').parent().html();\r\n\r\n            var highlightTemplate = jQuery(\"<div></div>\")\r\n                .css({\r\n                    position: \"absolute\",\r\n                    overflow: \"visible\",\r\n                    width: (result.itemSize.width + result.highlightPadding.left + result.highlightPadding.right) + \"px\",\r\n                    height: (result.itemSize.height + result.highlightPadding.top + result.highlightPadding.bottom) + \"px\",\r\n                    \"border-style\": \"solid\",\r\n                    \"border-width\": \"1px\"\r\n                }).addClass(\"bp-item2 bp-corner-all bp-cursor-frame\");\r\n\r\n            highlightTemplate.append(\"<div name=\'badge\' class=\'bp-badge2 bp-item\' style=\'top:45px; left:114px; z-index: 1000; background-color:green; color: white;\'></div>\");\r\n\r\n            result.highlightTemplate = highlightTemplate.wrap(\'<div>\').parent().html();\r\n\r\n            return result;\r\n        }\r\n\r\n        function getLoaderTemplate() {\r\n            var result = new primitives.orgdiagram.TemplateConfig();\r\n            result.name = \"loaderTemplate\";\r\n\r\n            result.itemSize = new primitives.common.Size(32, 32);\r\n            result.minimizedItemSize = new primitives.common.Size(4, 4);\r\n            result.highlightPadding = new primitives.common.Thickness(2, 2, 2, 2);\r\n\r\n\r\n            var itemTemplate = jQuery(\r\n              \'<div class=\"bp-item2\">\'\r\n                + \"<div name=\'badge\' class=\'bp-badge2 bp-item\' style=\'top:0px; left:6px; background-color:green; color: white;\'></div>\"\r\n            + \'</div>\'\r\n            ).css({\r\n                width: result.itemSize.width + \"px\",\r\n                height: result.itemSize.height + \"px\"\r\n            }).addClass(\"bp-item\");\r\n            result.itemTemplate = itemTemplate.wrap(\'<div>\').parent().html();\r\n\r\n            var highlightTemplate = jQuery(\"<div></div>\")\r\n                .css({\r\n                    position: \"absolute\",\r\n                    overflow: \"hidden\",\r\n                    \"border-style\": \"none\"\r\n                });\r\n\r\n            result.highlightTemplate = highlightTemplate.wrap(\'<div>\').parent().html();\r\n\r\n            return result;\r\n        }\r\n        \r\n    /*     function getDefaultTemplate(minimizedItemCornerRadius, minimizedItemSize, highlightPadding) {\r\n            var result = new primitives.orgdiagram.TemplateConfig();\r\n            result.name = \"defaultTemplate\";\r\n\r\n            // If we don;t change anything in template all its properties assigned to default values\r\n            // So we change only default dot size and corner radius\r\n            result.minimizedItemSize = new primitives.common.Size(minimizedItemSize, minimizedItemSize);\r\n            result.minimizedItemCornerRadius = minimizedItemCornerRadius;\r\n            result.highlightPadding = new primitives.common.Thickness(highlightPadding, highlightPadding, highlightPadding, highlightPadding);\r\n\r\n            return result;\r\n        }\r\n */\r\n        function getContactTemplate(minimizedItemCornerRadius, minimizedItemSize, highlightPadding) {\r\n            var result = new primitives.orgdiagram.TemplateConfig();\r\n            result.name = \"contactTemplate\";\r\n\r\n            result.itemSize = new primitives.common.Size(220, 120);\r\n            result.minimizedItemSize = new primitives.common.Size(minimizedItemSize, minimizedItemSize);\r\n            result.minimizedItemCornerRadius = minimizedItemCornerRadius;\r\n            result.highlightPadding = new primitives.common.Thickness(highlightPadding, highlightPadding, highlightPadding, highlightPadding);\r\n\r\n\r\n            var itemTemplate = jQuery(\r\n			  \'<div class=\"bp-item bp-corner-all bt-item-frame\">\'\r\n				+ \'<div name=\"titleBackground\" class=\"bp-item bp-corner-all bp-title-frame\" style=\"top: 2px; left: 2px; width: 216px; height: 20px;\">\'\r\n					+ \'<div name=\"title\" class=\"bp-item bp-title\" style=\"top: 3px; left: 6px; width: 208px; height: 18px;\">\'\r\n					+ \'</div>\'\r\n				+ \'</div>\'\r\n				+ \'<div class=\"bp-item bp-photo-frame\" style=\"top: 26px; left: 2px; width: 50px; height: 60px;\">\'\r\n					+ \'<img name=\"photo\" style=\"height: 60px; width:50px;\" />\'\r\n				+ \'</div>\'\r\n				+ \'<div name=\"phone\" class=\"bp-item\" style=\"top: 26px; left: 56px; width: 162px; height: 18px; font-size: 12px;\"></div>\'\r\n                + \'<div class=\"bp-item\" style=\"top: 44px; left: 56px; width: 162px; height: 18px; font-size: 12px;\"><a name=\"email\" href=\"\" target=\"_top\"></a></div>\'\r\n				+ \'<div name=\"description\" class=\"bp-item\" style=\"top: 62px; left: 56px; width: 162px; height: 36px; font-size: 10px;\"></div>\'\r\n			+ \'</div>\'\r\n			).css({\r\n			    width: result.itemSize.width + \"px\",\r\n			    height: result.itemSize.height + \"px\"\r\n			}).addClass(\"bp-item bp-corner-all bt-item-frame\");\r\n            result.itemTemplate = itemTemplate.wrap(\'<div>\').parent().html();\r\n\r\n            return result;\r\n        }\r\n\r\n        \r\n        function onTemplateRender(event, data) {\r\n            switch (data.renderingMode) {\r\n                case primitives.common.RenderingMode.Create:\r\n                    data.element.find(\"[name=email]\").click(function (e) {\r\n                        /* Block mouse click propogation in order to avoid layout updates before server postback*/\r\n                        primitives.common.stopPropagation(e);\r\n                    });\r\n                    /* Initialize widgets here */\r\n                    break;\r\n                case primitives.common.RenderingMode.Update:\r\n                    /* Update widgets here */\r\n                    break;\r\n            }\r\n\r\n            var itemConfig = data.context,\r\n                itemTitleColor = itemConfig.itemTitleColor != null ? itemConfig.itemTitleColor : primitives.common.Colors.RoyalBlue;\r\n\r\n       \r\n                data.element.find(\"[name=photo]\").attr({ \"src\": itemConfig.image });\r\n                data.element.find(\"[name=titleBackground]\").css({ \"background\": itemTitleColor });\r\n                data.element.find(\"[name=email]\").attr({ \"href\": (\"mailto:\" + itemConfig.email ) });\r\n\r\n                var fields = [\"title\", \"description\", \"phone\", \"email\"];\r\n                for (var index = 0; index < fields.length; index += 1) {\r\n                    var field = fields[index];\r\n\r\n                    var element = data.element.find(\"[name=\" + field + \"]\");\r\n                    if (element.text() != itemConfig[field]) {\r\n                        element.text(itemConfig[field]);\r\n                    }\r\n                }\r\n           \r\n            if (data.templateName == \"loaderTemplate\") {\r\n                var itemConfig = data.context;\r\n\r\n                var badge = data.element.find(\"[name=badge]\");\r\n                badge.text(itemConfig[\'childrencount\']);\r\n                badge.css({ \"background-color\": itemConfig.itemTitleColor });\r\n            }\r\n\r\n        }\r\n\r\n        function onSelectionChanged(e, data) {\r\n            var selectedItems = jQuery(\"#centerpanel\").orgDiagram(\"option\", \"selectedItems\");\r\n            var message = \"\";\r\n            for (var index = 0; index < selectedItems.length; index += 1) {\r\n                var itemConfig = treeItems[selectedItems[index]];\r\n                if (message != \"\") {\r\n                    message += \", \";\r\n                }\r\n                message += \"<b>\'\" + itemConfig.title + \"\'</b>\";\r\n            }\r\n            message += (data.parentItem != null ? \" Parent item <b>\'\" + data.parentItem.title + \"\'\" : \"\");\r\n            jQuery(\"#southpanel\").empty().append(\"User selected following items: \" + message);\r\n        }\r\n\r\n        function onHighlightChanging(e, data) {\r\n            var message = (data.context != null) ? \"User is hovering mouse over item <b>\'\" + data.context.title + \"\'</b>.\" : \"\";\r\n            message += (data.parentItem != null ? \" Parent item <b>\'\" + data.parentItem.title + \"\'\" : \"\");\r\n\r\n            jQuery(\"#southpanel\").empty().append(message);\r\n        }\r\n\r\n        function onHighlightChanged(e, data) {\r\n            var message = (data.context != null) ? \"User hovers mouse over item <b>\'\" + data.context.title + \"\'</b>.\" : \"\";\r\n            message += (data.parentItem != null ? \" Parent item <b>\'\" + data.parentItem.title + \"\'\" : \"\");\r\n\r\n            jQuery(\"#southpanel\").empty().append(message);\r\n        }\r\n\r\n        function onCursorChanging(e, data) {\r\n            var message = \"User is clicking on item \'\" + data.context.title + \"\'.\";\r\n            message += (data.parentItem != null ? \" Parent item <b>\'\" + data.parentItem.title + \"\'\" : \"\");\r\n\r\n            jQuery(\"#southpanel\").empty().append(message);\r\n\r\n            data.oldContext.templateName = null;\r\n            data.context.templateName = \"contactTemplate\";\r\n        }\r\n\r\n        function onCursorChanged(e, data) {\r\n            var message = \"User clicked on item \'\" + data.context.title + \"\'.\";\r\n            message += (data.parentItem != null ? \" Parent item <b>\'\" + data.parentItem.title + \"\'\" : \"\");\r\n            jQuery(\"#southpanel\").empty().append(message);\r\n        }\r\n\r\n        function onButtonClick(e, data) {\r\n            var message = \"User clicked <b>\'\" + data.name + \"\'</b> button for item <b>\'\" + data.context.title + \"\'</b>.\";\r\n            message += (data.parentItem != null ? \" Parent item <b>\'\" + data.parentItem.title + \"\'\" : \"\");\r\n            jQuery(\"#southpanel\").empty().append(message);\r\n        }\r\n\r\n        function onMouseClick(e, data) {\r\n            var message = \"User clicked item <b>\'\" + data.context.title + \"\'</b>.\";\r\n            message += (data.parentItem != null ? \" Parent item <b>\'\" + data.parentItem.title + \"\'\" : \"\");\r\n            jQuery(\"#southpanel\").empty().append(message);\r\n        }\r\n\r\n        function onMouseDblClick(e, data) {\r\n            var message = \"User double clicked item <b>\'\" + data.context.title + \"\'</b>.\";\r\n            message += (data.parentItem != null ? \" Parent item <b>\'\" + data.parentItem.title + \"\'\" : \"\");\r\n            jQuery(\"#southpanel\").empty().append(message);\r\n        }\r\n\r\n        function ShowGraphicsType(graphicsType) {\r\n            var result = null;\r\n\r\n            switch (graphicsType) {\r\n                case primitives.common.GraphicsType.SVG:\r\n                    result = \"SVG\";\r\n                    break;\r\n                case primitives.common.GraphicsType.Canvas:\r\n                    result = \"Canvas\";\r\n                    break;\r\n                case primitives.common.GraphicsType.VML:\r\n                    result = \"VML\";\r\n                    break;\r\n            }\r\n            jQuery(\"#actualGraphicsType\").empty().append(\"Graphics Type: \" + result);\r\n        }\r\n\r\n    </script>\r\n    <!-- /header -->\r\n</head>\r\n<body style=\"font-size: 12px\">\r\n    <div id=\"contentpanel\" style=\"padding: 0px;  padding-top:30px;\">\r\n        <!--bpcontent-->\r\n        <div id=\"westpanel\" style=\"background-color:#FBFBFB;padding: 5px; margin: 0px; border-style: solid; font-size: 12px; border-color: grey; border-width: 1px;  -webkit-overflow-scrolling: touch;\">\r\n            <div style=\"float:left\">\r\n            	<h4>\r\n            	<img src=\"/img/ugenebio-logox.png\" style=\"width:150px\"/> My Genealogy</h4> \r\n            	\r\n            	<p id=\"pageFitMode\"><b>Page Fit Mode</b> </p> \r\n            	 \r\n            </div>\r\n           <div style=\"float:right\">     <br/><br/>\r\n           <a class=\"btn btn-danger\" href=\"javascript:window.close();\" style=\"float:right; margin-right:20px;\">\r\n 														 <i class=\"fa fa-close fa-lg\"></i> Close Window</a>\r\n           \r\n           </div>\r\n           \r\n        </div>\r\n        \r\n        <div id=\"centerpanel\" style=\"overflow: hidden; padding: 0px; margin: 0px; border: 0px;\">\r\n        </div>\r\n    <!--     <div id=\"southpanel\">\r\n        </div> -->\r\n        <!--/bpcontent-->\r\n    </div>\r\n</body>\r\n</html>','[xyz-ips snippet=\"Genealogy\"]',1);
/*!50112 PREPARE s FROM @disable_bulk_load */;
/*!50112 EXECUTE s */;
/*!50112 DEALLOCATE PREPARE s */;


