INSERT INTO `rob_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES
(4024, 312, 'abt_description', 'A true example of success and breaking the poverty curse displays itself in the Roberta Hoskie story. Roberta was born in New Haven, CT. She was a single teenage mother that faced homelessness, then became a serial entrepreneur who has touched over 7,000 homes. Roberta is a real estate broker, real estate investor, author, and powerful inspirational speaker.\r\n\r\nRoberta Hoskie is the founder of RH Enterprises which comprises Outreach Realty Servicing, Outreach School of Real Estate, 1000 Black Families homeownership program, and is the Chieftain of an international faith-based sisterhood, The Ms.Millionaire Mindset Sisterhood.\r\n\r\nPoverty Curse Broken: The Roberta Hoskie story and her contributions to economic, political, and social repair reaches and impacts globally. She has received countless awards and recognition from local and international media and government outlets.\r\n\r\nDr. Roberta Hoskie holds a Doctorate of Divinity, a Doctorate of Theology from Heart Bible Institute, and an Honorary Doctorate in Community Development from LADC Institute.\r\n\r\nHer God-given purpose is to help as many people as possible break what we have deemed as the Poverty Curse, Live in the State of Abundance, and Develop a Millionaire Mindset.\r\n\r\nRoberta provides more transparency about her life in an inspiring story of hope and beating the odds in her memoir, “Poverty Curse Broken: The Roberta Hoskie story”.'),
(4025, 312, '_abt_description', 'field_62a6d920c6578'),
(4026, 312, 'abt_button', 'a:3:{s:5:\"title\";s:9:\"read more\";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4027, 312, '_abt_button', 'field_62a6d936c6579'),
(4028, 312, 'feat_title', 'Featured Coaching'),
(4029, 312, '_feat_title', 'field_62a6dbacc5d96'),
(4030, 312, 'feat_subtitle', 'Connect with Roberta Hoskie to Break the Poverty Curse over your life and the lives of others!'),
(4031, 312, '_feat_subtitle', 'field_62a6dbc8c5d97'),
(4032, 312, 'feat_button', 'a:3:{s:5:\"title\";s:10:\"View More \";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4033, 312, '_feat_button', 'field_62a6dbe2c5d98'),
(4034, 312, 'bulurb_box_0_box_image', '237'),
(4035, 312, '_bulurb_box_0_box_image', 'field_62a6dc1ec5d9a'),
(4036, 312, 'bulurb_box_0_box_title', 'Real Estate Coaching'),
(4037, 312, '_bulurb_box_0_box_title', 'field_62a6dc2ec5d9b'),
(4038, 312, 'bulurb_box_0_box_subtitle', 'Create Wealth by investing in Real Estate!'),
(4039, 312, '_bulurb_box_0_box_subtitle', 'field_62a6dc39c5d9c'),
(4040, 312, 'bulurb_box_1_box_image', '234'),
(4041, 312, '_bulurb_box_1_box_image', 'field_62a6dc1ec5d9a'),
(4042, 312, 'bulurb_box_1_box_title', 'Business Coaching'),
(4043, 312, '_bulurb_box_1_box_title', 'field_62a6dc2ec5d9b'),
(4044, 312, 'bulurb_box_1_box_subtitle', 'Take your Business to the Next Level!'),
(4045, 312, '_bulurb_box_1_box_subtitle', 'field_62a6dc39c5d9c'),
(4046, 312, 'bulurb_box_2_box_image', '236'),
(4047, 312, '_bulurb_box_2_box_image', 'field_62a6dc1ec5d9a'),
(4048, 312, 'bulurb_box_2_box_title', 'Mindset Coaching'),
(4049, 312, '_bulurb_box_2_box_title', 'field_62a6dc2ec5d9b'),
(4050, 312, 'bulurb_box_2_box_subtitle', 'Harness the Power of your Mind to Transform your Life!'),
(4051, 312, '_bulurb_box_2_box_subtitle', 'field_62a6dc39c5d9c'),
(4052, 312, 'bulurb_box_3_box_image', '235'),
(4053, 312, '_bulurb_box_3_box_image', 'field_62a6dc1ec5d9a'),
(4054, 312, 'bulurb_box_3_box_title', 'Homeownership Program'),
(4055, 312, '_bulurb_box_3_box_title', 'field_62a6dc2ec5d9b'),
(4056, 312, 'bulurb_box_3_box_subtitle', 'Start your Process to Homeownership and Generational Wealth!'),
(4057, 312, '_bulurb_box_3_box_subtitle', 'field_62a6dc39c5d9c'),
(4058, 312, 'bulurb_box', '4'),
(4059, 312, '_bulurb_box', 'field_62a6dc0bc5d99'),
(4060, 312, 'bulurb_box_0_feat_url', 'https://wp.localserverweb.com/robertahoskie/package/real-estate-coaching/'),
(4061, 312, '_bulurb_box_0_feat_url', 'field_62a6dcfaaa19f'),
(4062, 312, 'bulurb_box_1_feat_url', 'https://wp.localserverweb.com/robertahoskie/package/business-coaching/'),
(4063, 312, '_bulurb_box_1_feat_url', 'field_62a6dcfaaa19f'),
(4064, 312, 'bulurb_box_2_feat_url', 'https://wp.localserverweb.com/robertahoskie/package/mindset-coaching/'),
(4065, 312, '_bulurb_box_2_feat_url', 'field_62a6dcfaaa19f'),
(4066, 312, 'bulurb_box_3_feat_url', 'https://wp.localserverweb.com/robertahoskie/package/1000-black-families-homeownership-program/'),
(4067, 312, '_bulurb_box_3_feat_url', 'field_62a6dcfaaa19f'),
(4068, 312, 'pack_title', 'Coaching packages'),
(4069, 312, '_pack_title', 'field_62a6e2e976c9c'),
(4070, 312, 'pack_subtitle', 'Book a Coaching Consultation with Roberta Hoskie today!'),
(4071, 312, '_pack_subtitle', 'field_62a6e30476c9d'),
(4072, 312, 'pack_button', 'a:3:{s:5:\"title\";s:9:\"View More\";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4073, 312, '_pack_button', 'field_62a6e33276c9e'),
(4074, 312, 'title', 'gallery'),
(4075, 312, '_title', 'field_62a6e66cf2c20'),
(4076, 312, 'subtitle', ''),
(4077, 312, '_subtitle', 'field_62a6e677f2c21'),
(4078, 312, 'gall_button', 'a:3:{s:5:\"title\";s:9:\"View More\";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4079, 312, '_gall_button', 'field_62a6e6c6f2c22'),
(4080, 312, 'web_title', 'Roberta Hoskie brands'),
(4081, 312, '_web_title', 'field_62a71509850ee'),
(4082, 312, 'web_subtitle', 'Learn more about other brands connected to Roberta Hoskie'),
(4083, 312, '_web_subtitle', 'field_62a71517850ef'),
(4084, 312, 'slider_0_logo_image', '29'),
(4085, 312, '_slider_0_logo_image', 'field_62a7154a850f1'),
(4086, 312, 'slider_1_logo_image', '28'),
(4087, 312, '_slider_1_logo_image', 'field_62a7154a850f1'),
(4088, 312, 'slider_2_logo_image', '298'),
(4089, 312, '_slider_2_logo_image', 'field_62a7154a850f1'),
(4090, 312, 'slider', '4'),
(4091, 312, '_slider', 'field_62a71522850f0'),
(4092, 312, 'explore_button', 'a:3:{s:5:\"title\";s:12:\"Explore More\";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4093, 312, '_explore_button', 'field_62a716a903b52'),
(4094, 312, 'what_background_image', '26'),
(4095, 312, '_what_background_image', 'field_62a71a05fb4f8'),
(4096, 312, 'what_title', 'Poverty Curse Broken: Success Stories'),
(4097, 312, '_what_title', 'field_62a71a25fb4f9'),
(4098, 312, 'what_description', 'Roberta is on a mission to impact generations of individuals who want to break the poverty curse over their lives.\r\nHere are some testimonials of individuals whose lives she has helped transform.'),
(4099, 312, '_what_description', 'field_62a71a30fb4fa'),
(4100, 312, 'article_title', 'Media'),
(4101, 312, '_article_title', 'field_62a72099b5918'),
(4102, 312, 'article_subtitle', ''),
(4103, 312, '_article_subtitle', 'field_62a720a9b5919'),
(4104, 312, 'article_button', 'a:3:{s:5:\"title\";s:9:\"MORE NEWS\";s:3:\"url\";s:50:\"https://wp.localserverweb.com/robertahoskie/media/\";s:6:\"target\";s:0:\"\";}'),
(4105, 312, '_article_button', 'field_62a720bab591a'),
(4106, 312, 'slider_0_web_url', 'https://www.connectwithroberta.com/'),
(4107, 312, '_slider_0_web_url', 'field_62a82bb915f9a'),
(4108, 312, 'slider_1_web_url', 'https://1000blackfamilies.com'),
(4109, 312, '_slider_1_web_url', 'field_62a82bb915f9a'),
(4110, 312, 'slider_2_web_url', 'https://www.mmsisterhood.com'),
(4111, 312, '_slider_2_web_url', 'field_62a82bb915f9a'),
(4112, 312, 'slider_3_logo_image', '299'),
(4113, 312, '_slider_3_logo_image', 'field_62a7154a850f1'),
(4114, 312, 'slider_3_web_url', 'https://www.connectwithroberta.com/'),
(4115, 312, '_slider_3_web_url', 'field_62a82bb915f9a'),
(4116, 46, '_wp_old_date', '2022-06-17'),
(4117, 47, '_wp_old_date', '2022-06-17'),
(4118, 48, '_wp_old_date', '2022-06-17'),
(4119, 228, '_wp_old_date', '2022-06-17'),
(4120, 227, '_wp_old_date', '2022-06-17'),
(4121, 226, '_wp_old_date', '2022-06-17'),
(4122, 225, '_wp_old_date', '2022-06-17'),
(4123, 277, '_wp_old_date', '2022-06-17'),
(4124, 275, '_wp_old_date', '2022-06-17'),
(4125, 286, '_wp_old_date', '2022-06-17'),
(4126, 276, '_wp_old_date', '2022-06-17'),
(4127, 314, 'bacakground_image', '305'),
(4128, 314, '_bacakground_image', 'field_62a6d643f73ec'),
(4129, 314, 'banner_title', 'When we understand that thought causes it all,<span style=\"background: -webkit-linear-gradient(48deg, #b92c23, #181514 110%); -webkit-text-fill-color: transparent; -webkit-background-clip: text; background-clip: text;\"> we will then know that there aren’t any limits </span>, except the limits we impose ourselves  -Dr. Roberta Hoskie'),
(4130, 314, '_banner_title', 'field_62a6d669f73ed'),
(4131, 314, 'description', ''),
(4132, 314, '_description', 'field_62a6d694f73ef'),
(4133, 314, 'button', ''),
(4134, 314, '_button', 'field_62a6d6cff73f0'),
(4135, 314, 'abt_image', '19'),
(4136, 314, '_abt_image', 'field_62a6d8eec6576'),
(4137, 314, 'abt_title', 'About Dr. Roberta Hoskie'),
(4138, 314, '_abt_title', 'field_62a6d911c6577'),
(4139, 314, 'abt_description', 'A true example of success and breaking the poverty curse displays itself in the Roberta Hoskie story. Roberta was born in New Haven, CT. She was a single teenage mother that faced homelessness, then became a serial entrepreneur who has touched over 7,000 homes. Roberta is a real estate broker, real estate investor, author, and powerful inspirational speaker.\r\n\r\nRoberta Hoskie is the founder of RH Enterprises which comprises Outreach Realty Servicing, Outreach School of Real Estate, 1000 Black Families homeownership program, and is the Chieftain of an international faith-based sisterhood, The Ms.Millionaire Mindset Sisterhood.\r\n\r\nPoverty Curse Broken: The Roberta Hoskie story and her contributions to economic, political, and social repair reaches and impacts globally. She has received countless awards and recognition from local and international media and government outlets.\r\n\r\nDr. Roberta Hoskie holds a Doctorate of Divinity, a Doctorate of Theology from Heart Bible Institute, and an Honorary Doctorate in Community Development from LADC Institute.\r\n\r\nHer God-given purpose is to help as many people as possible break what we have deemed as the Poverty Curse, Live in the State of Abundance, and Develop a Millionaire Mindset.\r\n\r\nRoberta provides more transparency about her life in an inspiring story of hope and beating the odds in her memoir, “Poverty Curse Broken: The Roberta Hoskie story”.'),
(4140, 314, '_abt_description', 'field_62a6d920c6578'),
(4141, 314, 'abt_button', 'a:3:{s:5:\"title\";s:9:\"read more\";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4142, 314, '_abt_button', 'field_62a6d936c6579'),
(4143, 314, 'feat_title', 'Featured Coaching'),
(4144, 314, '_feat_title', 'field_62a6dbacc5d96'),
(4145, 314, 'feat_subtitle', 'Connect with Roberta https://robertahoskie.com/Hoskie to Break the Poverty Curse over your life and the lives of others!'),
(4146, 314, '_feat_subtitle', 'field_62a6dbc8c5d97'),
(4147, 314, 'feat_button', 'a:3:{s:5:\"title\";s:10:\"View More \";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4148, 314, '_feat_button', 'field_62a6dbe2c5d98'),
(4149, 314, 'bulurb_box_0_box_image', '237'),
(4150, 314, '_bulurb_box_0_box_image', 'field_62a6dc1ec5d9a'),
(4151, 314, 'bulurb_box_0_box_title', 'Real Estate Coaching'),
(4152, 314, '_bulurb_box_0_box_title', 'field_62a6dc2ec5d9b'),
(4153, 314, 'bulurb_box_0_box_subtitle', 'Create Wealth by investing in Real Estate!'),
(4154, 314, '_bulurb_box_0_box_subtitle', 'field_62a6dc39c5d9c'),
(4155, 314, 'bulurb_box_1_box_image', '234'),
(4156, 314, '_bulurb_box_1_box_image', 'field_62a6dc1ec5d9a'),
(4157, 314, 'bulurb_box_1_box_title', 'Business Coaching'),
(4158, 314, '_bulurb_box_1_box_title', 'field_62a6dc2ec5d9b'),
(4159, 314, 'bulurb_box_1_box_subtitle', 'Take your Business to the Next Level!'),
(4160, 314, '_bulurb_box_1_box_subtitle', 'field_62a6dc39c5d9c'),
(4161, 314, 'bulurb_box_2_box_image', '236'),
(4162, 314, '_bulurb_box_2_box_image', 'field_62a6dc1ec5d9a'),
(4163, 314, 'bulurb_box_2_box_title', 'Mindset Coaching'),
(4164, 314, '_bulurb_box_2_box_title', 'field_62a6dc2ec5d9b'),
(4165, 314, 'bulurb_box_2_box_subtitle', 'Harness the Power of your Mind to Transform your Life!'),
(4166, 314, '_bulurb_box_2_box_subtitle', 'field_62a6dc39c5d9c'),
(4167, 314, 'bulurb_box_3_box_image', '235'),
(4168, 314, '_bulurb_box_3_box_image', 'field_62a6dc1ec5d9a'),
(4169, 314, 'bulurb_box_3_box_title', 'Homeownership Program'),
(4170, 314, '_bulurb_box_3_box_title', 'field_62a6dc2ec5d9b'),
(4171, 314, 'bulurb_box_3_box_subtitle', 'Start your Process to Homeownership and Generational Wealth!'),
(4172, 314, '_bulurb_box_3_box_subtitle', 'field_62a6dc39c5d9c'),
(4173, 314, 'bulurb_box', '4'),
(4174, 314, '_bulurb_box', 'field_62a6dc0bc5d99'),
(4175, 314, 'bulurb_box_0_feat_url', 'https://robertahoskie.com/real-estate-coaching/'),
(4176, 314, '_bulurb_box_0_feat_url', 'field_62a6dcfaaa19f'),
(4177, 314, 'bulurb_box_1_feat_url', 'https://robertahoskie.com/business-coaching/'),
(4178, 314, '_bulurb_box_1_feat_url', 'field_62a6dcfaaa19f'),
(4179, 314, 'bulurb_box_2_feat_url', 'https://robertahoskie.com/mindset-coaching/'),
(4180, 314, '_bulurb_box_2_feat_url', 'field_62a6dcfaaa19f'),
(4181, 314, 'bulurb_box_3_feat_url', 'https://robertahoskie.com/package/1000-black-families-homeownership-program/'),
(4182, 314, '_bulurb_box_3_feat_url', 'field_62a6dcfaaa19f'),
(4183, 314, 'pack_title', 'Coaching packages'),
(4184, 314, '_pack_title', 'field_62a6e2e976c9c'),
(4185, 314, 'pack_subtitle', 'Book a Coaching Consultation with Roberta Hoskie today!'),
(4186, 314, '_pack_subtitle', 'field_62a6e30476c9d'),
(4187, 314, 'pack_button', 'a:3:{s:5:\"title\";s:9:\"View More\";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4188, 314, '_pack_button', 'field_62a6e33276c9e'),
(4189, 314, 'title', 'gallery'),
(4190, 314, '_title', 'field_62a6e66cf2c20'),
(4191, 314, 'subtitle', ''),
(4192, 314, '_subtitle', 'field_62a6e677f2c21'),
(4193, 314, 'gall_button', 'a:3:{s:5:\"title\";s:9:\"View More\";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4194, 314, '_gall_button', 'field_62a6e6c6f2c22'),
(4195, 314, 'web_title', 'Roberta Hoskie brands'),
(4196, 314, '_web_title', 'field_62a71509850ee'),
(4197, 314, 'web_subtitle', 'Learn more about other brands connected to Roberta Hoskie'),
(4198, 314, '_web_subtitle', 'field_62a71517850ef'),
(4199, 314, 'slider_0_logo_image', '29'),
(4200, 314, '_slider_0_logo_image', 'field_62a7154a850f1'),
(4201, 314, 'slider_1_logo_image', '28'),
(4202, 314, '_slider_1_logo_image', 'field_62a7154a850f1'),
(4203, 314, 'slider_2_logo_image', '298'),
(4204, 314, '_slider_2_logo_image', 'field_62a7154a850f1'),
(4205, 314, 'slider', '4'),
(4206, 314, '_slider', 'field_62a71522850f0'),
(4207, 314, 'explore_button', 'a:3:{s:5:\"title\";s:12:\"Explore More\";s:3:\"url\";s:1:\"#\";s:6:\"target\";s:0:\"\";}'),
(4208, 314, '_explore_button', 'field_62a716a903b52'),
(4209, 314, 'what_background_image', '26'),
(4210, 314, '_what_background_image', 'field_62a71a05fb4f8'),
(4211, 314, 'what_title', 'Poverty Curse Broken: Success Stories'),
(4212, 314, '_what_title', 'field_62a71a25fb4f9'),
(4213, 314, 'what_description', 'Roberta is on a mission to impact generations of individuals who want to break the poverty curse over their lives.\r\nHere are some testimonials of individuals whose lives she has helped transform.'),
(4214, 314, '_what_description', 'field_62a71a30fb4fa'),
(4215, 314, 'article_title', 'Media'),
(4216, 314, '_article_title', 'field_62a72099b5918'),
(4217, 314, 'article_subtitle', ''),
(4218, 314, '_article_subtitle', 'field_62a720a9b5919'),
(4219, 314, 'article_button', 'a:3:{s:5:\"title\";s:9:\"MORE NEWS\";s:3:\"url\";s:32:\"https://robertahoskie.com/media/\";s:6:\"target\";s:0:\"\";}'),
(4220, 314, '_article_button', 'field_62a720bab591a'),
(4221, 314, 'slider_0_web_url', 'https://www.connectwithroberta.com/'),
(4222, 314, '_slider_0_web_url', 'field_62a82bb915f9a'),
(4223, 314, 'slider_1_web_url', 'https://1000blackfamilies.com'),
(4224, 314, '_slider_1_web_url', 'field_62a82bb915f9a'),
(4225, 314, 'slider_2_web_url', 'https://www.mmsisterhood.com'),
(4226, 314, '_slider_2_web_url', 'field_62a82bb915f9a'),
(4227, 314, 'slider_3_logo_image', '299'),
(4228, 314, '_slider_3_logo_image', 'field_62a7154a850f1'),
(4229, 314, 'slider_3_web_url', 'https://www.connectwithroberta.com/'),
(4230, 314, '_slider_3_web_url', 'field_62a82bb915f9a'),
(4231, 315, '_edit_lock', '1655562361:1'),
(4232, 316, '_wp_attached_file', '2022/06/cropped-logo-1.png'),
(4233, 316, '_wp_attachment_context', 'site-icon'),
(4234, 316, '_wp_attachment_metadata', 'a:6:{s:5:\"width\";i:512;s:6:\"height\";i:512;s:4:\"file\";s:26:\"2022/06/cropped-logo-1.png\";s:8:\"filesize\";i:16488;s:5:\"sizes\";a:10:{s:6:\"medium\";a:5:{s:4:\"file\";s:26:\"cropped-logo-1-300x300.png\";s:5:\"width\";i:300;s:6:\"height\";i:300;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:46128;}s:9:\"thumbnail\";a:5:{s:4:\"file\";s:26:\"cropped-logo-1-150x150.png\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:17445;}s:21:\"woocommerce_thumbnail\";a:6:{s:4:\"file\";s:26:\"cropped-logo-1-300x300.png\";s:5:\"width\";i:300;s:6:\"height\";i:300;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:46128;s:9:\"uncropped\";b:0;}s:29:\"woocommerce_gallery_thumbnail\";a:5:{s:4:\"file\";s:26:\"cropped-logo-1-100x100.png\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:9918;}s:12:\"shop_catalog\";a:5:{s:4:\"file\";s:26:\"cropped-logo-1-300x300.png\";s:5:\"width\";i:300;s:6:\"height\";i:300;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:46128;}s:14:\"shop_thumbnail\";a:5:{s:4:\"file\";s:26:\"cropped-logo-1-100x100.png\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:9918;}s:13:\"site_icon-270\";a:5:{s:4:\"file\";s:26:\"cropped-logo-1-270x270.png\";s:5:\"width\";i:270;s:6:\"height\";i:270;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:40520;}s:13:\"site_icon-192\";a:5:{s:4:\"file\";s:26:\"cropped-logo-1-192x192.png\";s:5:\"width\";i:192;s:6:\"height\";i:192;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:17847;}s:13:\"site_icon-180\";a:5:{s:4:\"file\";s:26:\"cropped-logo-1-180x180.png\";s:5:\"width\";i:180;s:6:\"height\";i:180;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:22001;}s:12:\"site_icon-32\";a:5:{s:4:\"file\";s:24:\"cropped-logo-1-32x32.png\";s:5:\"width\";i:32;s:6:\"height\";i:32;s:9:\"mime-type\";s:9:\"image/png\";s:8:\"filesize\";i:1611;}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}'),
(4235, 315, '_wp_trash_meta_status', 'publish'),
(4236, 315, '_wp_trash_meta_time', '1655562381'),
(4237, 68, '_wp_old_date', '2022-06-13'),
(4238, 69, '_wp_old_date', '2022-06-13'),
(4239, 70, '_wp_old_date', '2022-06-13'),
(4240, 71, '_wp_old_date', '2022-06-13'),
(4241, 64, '_wp_old_date', '2022-06-13'),
(4242, 63, '_wp_old_date', '2022-06-13'),
(4243, 65, '_wp_old_date', '2022-06-13'),
(4244, 66, '_wp_old_date', '2022-06-13'),
(4245, 67, '_wp_old_date', '2022-06-13'),
(4246, 317, '_edit_last', '1'),
(4247, 317, '_edit_lock', '1655565234:1'),
(4248, 317, '_wp_page_template', 'page-templates/full-width.php'),
(4249, 319, '_wp_attached_file', '2022/06/404-banner.jpg'),
(4250, 319, '_wp_attachment_metadata', 'a:6:{s:5:\"width\";i:974;s:6:\"height\";i:300;s:4:\"file\";s:22:\"2022/06/404-banner.jpg\";s:8:\"filesize\";i:41199;s:5:\"sizes\";a:10:{s:6:\"medium\";a:5:{s:4:\"file\";s:21:\"404-banner-300x92.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:92;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:2981;}s:9:\"thumbnail\";a:5:{s:4:\"file\";s:22:\"404-banner-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:4401;}s:12:\"medium_large\";a:5:{s:4:\"file\";s:22:\"404-banner-768x237.jpg\";s:5:\"width\";i:768;s:6:\"height\";i:237;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:10899;}s:14:\"post-thumbnail\";a:5:{s:4:\"file\";s:22:\"404-banner-624x192.jpg\";s:5:\"width\";i:624;s:6:\"height\";i:192;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:7999;}s:21:\"woocommerce_thumbnail\";a:6:{s:4:\"file\";s:22:\"404-banner-300x300.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:300;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:10513;s:9:\"uncropped\";b:0;}s:18:\"woocommerce_single\";a:5:{s:4:\"file\";s:22:\"404-banner-600x185.jpg\";s:5:\"width\";i:600;s:6:\"height\";i:185;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:7906;}s:29:\"woocommerce_gallery_thumbnail\";a:5:{s:4:\"file\";s:22:\"404-banner-100x100.jpg\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:2676;}s:12:\"shop_catalog\";a:5:{s:4:\"file\";s:22:\"404-banner-300x300.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:300;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:10513;}s:11:\"shop_single\";a:5:{s:4:\"file\";s:22:\"404-banner-600x185.jpg\";s:5:\"width\";i:600;s:6:\"height\";i:185;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:7906;}s:14:\"shop_thumbnail\";a:5:{s:4:\"file\";s:22:\"404-banner-100x100.jpg\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:2676;}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:0:\"\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}}'),
(4251, 322, '_wp_attached_file', '2022/06/3747371-scaled.jpg'),
(4252, 322, '_wp_attachment_metadata', 'a:7:{s:5:\"width\";i:2560;s:6:\"height\";i:1707;s:4:\"file\";s:26:\"2022/06/3747371-scaled.jpg\";s:8:\"filesize\";i:200632;s:5:\"sizes\";a:13:{s:6:\"medium\";a:5:{s:4:\"file\";s:19:\"3747371-300x200.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:200;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:11277;}s:5:\"large\";a:5:{s:4:\"file\";s:20:\"3747371-1024x683.jpg\";s:5:\"width\";i:1024;s:6:\"height\";i:683;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:57297;}s:9:\"thumbnail\";a:5:{s:4:\"file\";s:19:\"3747371-150x150.jpg\";s:5:\"width\";i:150;s:6:\"height\";i:150;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:6334;}s:12:\"medium_large\";a:5:{s:4:\"file\";s:19:\"3747371-768x512.jpg\";s:5:\"width\";i:768;s:6:\"height\";i:512;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:38756;}s:9:\"1536x1536\";a:5:{s:4:\"file\";s:21:\"3747371-1536x1024.jpg\";s:5:\"width\";i:1536;s:6:\"height\";i:1024;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:98377;}s:9:\"2048x2048\";a:5:{s:4:\"file\";s:21:\"3747371-2048x1365.jpg\";s:5:\"width\";i:2048;s:6:\"height\";i:1365;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:145990;}s:14:\"post-thumbnail\";a:5:{s:4:\"file\";s:19:\"3747371-624x416.jpg\";s:5:\"width\";i:624;s:6:\"height\";i:416;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:29750;}s:21:\"woocommerce_thumbnail\";a:6:{s:4:\"file\";s:19:\"3747371-300x300.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:300;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:15409;s:9:\"uncropped\";b:0;}s:18:\"woocommerce_single\";a:5:{s:4:\"file\";s:19:\"3747371-600x400.jpg\";s:5:\"width\";i:600;s:6:\"height\";i:400;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:28273;}s:29:\"woocommerce_gallery_thumbnail\";a:5:{s:4:\"file\";s:19:\"3747371-100x100.jpg\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:3865;}s:12:\"shop_catalog\";a:5:{s:4:\"file\";s:19:\"3747371-300x300.jpg\";s:5:\"width\";i:300;s:6:\"height\";i:300;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:15409;}s:11:\"shop_single\";a:5:{s:4:\"file\";s:19:\"3747371-600x400.jpg\";s:5:\"width\";i:600;s:6:\"height\";i:400;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:28273;}s:14:\"shop_thumbnail\";a:5:{s:4:\"file\";s:19:\"3747371-100x100.jpg\";s:5:\"width\";i:100;s:6:\"height\";i:100;s:9:\"mime-type\";s:10:\"image/jpeg\";s:8:\"filesize\";i:3865;}}s:10:\"image_meta\";a:12:{s:8:\"aperture\";s:1:\"0\";s:6:\"credit\";s:0:\"\";s:6:\"camera\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:17:\"created_timestamp\";s:1:\"0\";s:9:\"copyright\";s:38:\"Freepik Company S.L. - www.freepik.com\";s:12:\"focal_length\";s:1:\"0\";s:3:\"iso\";s:1:\"0\";s:13:\"shutter_speed\";s:1:\"0\";s:5:\"title\";s:0:\"\";s:11:\"orientation\";s:1:\"0\";s:8:\"keywords\";a:0:{}}s:14:\"original_image\";s:11:\"3747371.jpg\";}'),
(4253, 317, '_wp_trash_meta_status', 'publish'),
(4254, 317, '_wp_trash_meta_time', '1655565382'),
(4255, 317, '_wp_desired_post_slug', 'about-us'),
(4256, 327, '_edit_last', '1'),
(4257, 327, '_wp_page_template', '404.php'),
(4258, 327, '_edit_lock', '1655565571:1'),
(4259, 72, '_wp_old_date', '2022-06-13'),
(4260, 73, '_wp_old_date', '2022-06-13'),
(4261, 74, '_wp_old_date', '2022-06-13'),
(4262, 75, '_wp_old_date', '2022-06-13'),
(4263, 76, '_wp_old_date', '2022-06-13'),
(4264, 77, '_wp_old_date', '2022-06-13'),
(4265, 78, '_wp_old_date', '2022-06-13'),
(4266, 79, '_wp_old_date', '2022-06-13'),
(4267, 329, '_edit_lock', '1655566595:1'),
(4268, 329, '_wp_trash_meta_status', 'publish'),
(4269, 329, '_wp_trash_meta_time', '1655566609');

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

--
-- Table structure for table `rob_termmeta`
--

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

--
-- Dumping data for table `rob_termmeta`
--

INSERT INTO `rob_termmeta` (`meta_id`, `term_id`, `meta_key`, `meta_value`) VALUES
(1, 21, 'product_count_product_cat', '1'),
(2, 21, 'display_type', ''),
(3, 21, 'thumbnail_id', '0');

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

--
-- Table structure for table `rob_terms`
--

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

--
-- Dumping data for table `rob_terms`
--

INSERT INTO `rob_terms` (`term_id`, `name`, `slug`, `term_group`) VALUES
(1, 'Uncategorized', 'uncategorized', 0),
(2, 'robertahoskie-child', 'robertahoskie-child', 0),
(3, 'main_menu', 'main_menu', 0),
(4, 'Usefull Links', 'usefull-links', 0),
(5, 'categories', 'categories', 0),
(6, 'Websites', 'websites', 0),
(7, 'Support', 'support', 0),
(8, 'simple', 'simple', 0),
(9, 'grouped', 'grouped', 0),
(10, 'variable', 'variable', 0),
(11, 'external', 'external', 0),
(12, 'exclude-from-search', 'exclude-from-search', 0),
(13, 'exclude-from-catalog', 'exclude-from-catalog', 0),
(14, 'featured', 'featured', 0),
(15, 'outofstock', 'outofstock', 0),
(16, 'rated-1', 'rated-1', 0),
(17, 'rated-2', 'rated-2', 0),
(18, 'rated-3', 'rated-3', 0),
(19, 'rated-4', 'rated-4', 0),
(20, 'rated-5', 'rated-5', 0),
(21, 'Book', 'book', 0);

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

--
-- Table structure for table `rob_term_relationships`
--

CREATE TABLE `rob_term_relationships` (
  `object_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `term_order` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `rob_term_relationships`
--

INSERT INTO `rob_term_relationships` (`object_id`, `term_taxonomy_id`, `term_order`) VALUES
(1, 1, 0),
(8, 2, 0),
(46, 3, 0),
(47, 3, 0),
(48, 3, 0),
(63, 4, 0),
(64, 4, 0),
(65, 4, 0),
(66, 4, 0),
(67, 4, 0),
(68, 5, 0),
(69, 5, 0),
(70, 5, 0),
(71, 5, 0),
(72, 6, 0),
(73, 6, 0),
(74, 6, 0),
(75, 6, 0),
(76, 7, 0),
(77, 7, 0),
(78, 7, 0),
(79, 7, 0),
(165, 1, 0),
(167, 1, 0),
(177, 8, 0),
(177, 21, 0),
(178, 8, 0),
(178, 21, 0),
(179, 8, 0),
(179, 21, 0),
(181, 8, 0),
(181, 21, 0),
(225, 3, 0),
(226, 3, 0),
(227, 3, 0),
(228, 3, 0),
(275, 3, 0),
(276, 3, 0),
(277, 3, 0),
(286, 3, 0);

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

--
-- Table structure for table `rob_term_taxonomy`
--

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

--
-- Dumping data for table `rob_term_taxonomy`
--

INSERT INTO `rob_term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES
(1, 1, 'category', '', 0, 3),
(2, 2, 'wp_theme', '', 0, 1),
(3, 3, 'nav_menu', '', 0, 11),
(4, 4, 'nav_menu', '', 0, 5),
(5, 5, 'nav_menu', '', 0, 4),
(6, 6, 'nav_menu', '', 0, 4),
(7, 7, 'nav_menu', '', 0, 4),
(8, 8, 'product_type', '', 0, 1),
(9, 9, 'product_type', '', 0, 0),
(10, 10, 'product_type', '', 0, 0),
(11, 11, 'product_type', '', 0, 0),
(12, 12, 'product_visibility', '', 0, 0),
(13, 13, 'product_visibility', '', 0, 0),
(14, 14, 'product_visibility', '', 0, 0),
(15, 15, 'product_visibility', '', 0, 0),
(16, 16, 'product_visibility', '', 0, 0),
(17, 17, 'product_visibility', '', 0, 0),
(18, 18, 'product_visibility', '', 0, 0),
(19, 19, 'product_visibility', '', 0, 0),
(20, 20, 'product_visibility', '', 0, 0),
(21, 21, 'product_cat', '', 0, 1);

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

--
-- Table structure for table `rob_usermeta`
--

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

--
-- Dumping data for table `rob_usermeta`
--

INSERT INTO `rob_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES
(1, 1, 'nickname', 'wpadmin'),
(2, 1, 'first_name', ''),
(3, 1, 'last_name', ''),
(4, 1, 'description', ''),
(5, 1, 'rich_editing', 'true'),
(6, 1, 'syntax_highlighting', 'true'),
(7, 1, 'comment_shortcuts', 'false'),
(8, 1, 'admin_color', 'fresh'),
(9, 1, 'use_ssl', '0'),
(10, 1, 'show_admin_bar_front', 'true'),
(11, 1, 'locale', ''),
(12, 1, 'rob_capabilities', 'a:1:{s:13:\"administrator\";b:1;}'),
(13, 1, 'rob_user_level', '10'),
(14, 1, 'dismissed_wp_pointers', 'text_widget_custom_html,theme_editor_notice'),
(15, 1, 'show_welcome_panel', '1'),
(17, 1, 'rob_dashboard_quick_press_last_post_id', '313'),
(18, 1, 'community-events-location', 'a:1:{s:2:\"ip\";s:13:\"103.141.167.0\";}'),
(19, 1, 'managenav-menuscolumnshidden', 'a:1:{i:0;s:15:\"title-attribute\";}'),
(20, 1, 'metaboxhidden_nav-menus', 'a:0:{}'),
(21, 1, 'rob_user-settings', 'libraryContent=browse&editor=html&posts_list_mode=list'),
(22, 1, 'rob_user-settings-time', '1656091317'),
(23, 1, 'closedpostboxes_acf-field-group', 'a:0:{}'),
(24, 1, 'metaboxhidden_acf-field-group', 'a:1:{i:0;s:7:\"slugdiv\";}'),
(26, 1, 'nav_menu_recently_edited', '6'),
(27, 1, 'closedpostboxes_nav-menus', 'a:0:{}'),
(28, 1, 'closedpostboxes_toplevel_page_theme-general-settings', 'a:2:{i:0;s:23:\"acf-group_62a33f3c21001\";i:1;s:23:\"acf-group_62a6e9bc8e56e\";}'),
(29, 1, 'metaboxhidden_toplevel_page_theme-general-settings', 'a:0:{}'),
(30, 1, 'closedpostboxes_post', 'a:0:{}'),
(31, 1, 'metaboxhidden_post', 'a:5:{i:0;s:23:\"acf-group_62a33f3c21001\";i:1;s:23:\"acf-group_62a6e9bc8e56e\";i:2;s:23:\"acf-group_62a6d638cffde\";i:3;s:23:\"acf-group_62a7191c667a6\";i:4;s:13:\"trackbacksdiv\";}'),
(32, 1, '_woocommerce_tracks_anon_id', 'woo:uJLxukWZPx8LUAMDM+jeIYyO'),
(33, 1, 'wc_last_active', '1656028800'),
(35, 1, '_woocommerce_persistent_cart_1', 'a:1:{s:4:\"cart\";a:3:{s:32:\"8f53295a73878494e9bc8dd6c3c7104f\";a:11:{s:3:\"key\";s:32:\"8f53295a73878494e9bc8dd6c3c7104f\";s:10:\"product_id\";i:179;s:12:\"variation_id\";i:0;s:9:\"variation\";a:0:{}s:8:\"quantity\";i:16;s:9:\"data_hash\";s:32:\"b5c1d5ca8bae6d4896cf1807cdf763f0\";s:13:\"line_tax_data\";a:2:{s:8:\"subtotal\";a:0:{}s:5:\"total\";a:0:{}}s:13:\"line_subtotal\";d:9584;s:17:\"line_subtotal_tax\";i:0;s:10:\"line_total\";d:9584;s:8:\"line_tax\";i:0;}s:32:\"8f85517967795eeef66c225f7883bdcb\";a:11:{s:3:\"key\";s:32:\"8f85517967795eeef66c225f7883bdcb\";s:10:\"product_id\";i:178;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:0:{}s:5:\"total\";a:0:{}}s:13:\"line_subtotal\";d:599;s:17:\"line_subtotal_tax\";i:0;s:10:\"line_total\";d:599;s:8:\"line_tax\";i:0;}s:32:\"96da2f590cd7246bbde0051047b0d6f7\";a:11:{s:3:\"key\";s:32:\"96da2f590cd7246bbde0051047b0d6f7\";s:10:\"product_id\";i:177;s:12:\"variation_id\";i:0;s:9:\"variation\";a:0:{}s:8:\"quantity\";i:3;s:9:\"data_hash\";s:32:\"b5c1d5ca8bae6d4896cf1807cdf763f0\";s:13:\"line_tax_data\";a:2:{s:8:\"subtotal\";a:0:{}s:5:\"total\";a:0:{}}s:13:\"line_subtotal\";d:291;s:17:\"line_subtotal_tax\";i:0;s:10:\"line_total\";d:291;s:8:\"line_tax\";i:0;}}}'),
(37, 1, 'meta-box-order_post', 'a:4:{s:15:\"acf_after_title\";s:0:\"\";s:4:\"side\";s:85:\"submitdiv,formatdiv,categorydiv,acf-group_62a824f5a864e,tagsdiv-post_tag,postimagediv\";s:6:\"normal\";s:168:\"acf-group_62a33f3c21001,acf-group_62a6e9bc8e56e,acf-group_62a6d638cffde,acf-group_62a7191c667a6,postexcerpt,trackbacksdiv,commentstatusdiv,commentsdiv,slugdiv,authordiv\";s:8:\"advanced\";s:0:\"\";}'),
(38, 1, 'screen_layout_post', '2'),
(42, 1, 'closedpostboxes_package', 'a:0:{}'),
(43, 1, 'metaboxhidden_package', 'a:5:{i:0;s:23:\"acf-group_62a33f3c21001\";i:1;s:23:\"acf-group_62a6e9bc8e56e\";i:2;s:23:\"acf-group_62a6d638cffde\";i:3;s:23:\"acf-group_62a7191c667a6\";i:4;s:7:\"slugdiv\";}'),
(44, 1, 'tribe_setDefaultNavMenuBoxes', '1'),
(45, 1, 'ecfg_activated_on', '1656066564'),
(48, 1, 'tribe-dismiss-notice-time-archive-slug-conflict', '1655561057'),
(49, 1, 'tribe-dismiss-notice', 'archive-slug-conflict');

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

--
-- Table structure for table `rob_wc_admin_notes`
--

CREATE TABLE `rob_wc_admin_notes` (
  `note_id` bigint UNSIGNED NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `rob_wc_admin_notes`
--

INSERT INTO `rob_wc_admin_notes` (`note_id`, `name`, `type`, `locale`, `title`, `content`, `content_data`, `status`, `source`, `date_created`, `date_reminder`, `is_snoozable`, `layout`, `image`, `is_deleted`, `is_read`, `icon`) VALUES
(1, 'wc-refund-returns-page', 'info', 'en_US', 'Setup a Refund and Returns Policy page to boost your store\'s credibility.', 'We have created a sample draft Refund and Returns Policy page for you. Please have a look and update it to fit your store.', '{}', 'unactioned', 'woocommerce-core', '2022-06-13 12:13:01', NULL, 0, 'plain', '', 0, 0, 'info'),
(2, 'wc-admin-wc-helper-connection', 'info', 'en_US', 'Connect to WooCommerce.com', 'Connect to get important product notifications and updates.', '{}', 'unactioned', 'woocommerce-admin', '2022-06-13 12:13:02', NULL, 0, 'plain', '', 0, 0, 'info'),
(3, 'new_in_app_marketplace_2021', 'info', 'en_US', 'Customize your store with extensions', 'Check out our NEW Extensions tab to see our favorite extensions for customizing your store, and discover the most popular extensions in the WooCommerce Marketplace.', '{}', 'unactioned', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(4, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(5, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(6, 'wc_shipping_mobile_app_q4_2021', 'marketing', 'en_US', 'Print and manage your shipping labels with 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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(7, 'ecomm-need-help-setting-up-your-store', 'info', 'en_US', 'Need help setting up your Store?', 'Schedule a free 30-min <a href=\"https://wordpress.com/support/concierge-support/\">quick start session</a> and get help from our specialists. We’re happy to walk through setup steps, show you around the WordPress.com dashboard, troubleshoot any issues you may have, and help you the find the features you need to accomplish your goals for your site.', '{}', 'pending', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(8, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(9, 'ecomm-unique-shopping-experience', 'info', 'en_US', 'For a shopping experience as unique as your customers', 'Product Add-Ons allow your customers to personalize products while they\'re shopping on your online store. No more follow-up email requests—customers get what they want, before they\'re done checking out. Learn more about this extension that comes included in your plan.', '{}', 'pending', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(10, 'wc-admin-getting-started-in-ecommerce', 'info', 'en_US', 'Getting Started in eCommerce - webinar', 'We want to make eCommerce and this process of getting started as easy as possible for you. Watch this webinar to get tips on how to have our store up and running in a breeze.', '{}', 'pending', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(11, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(12, '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.', '{}', 'pending', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(13, 'wc-admin-first-five-things-to-customize', 'info', 'en_US', 'The first 5 things to customize in your store', 'Deciding what to start with first is tricky. To help you properly prioritize, we’ve put together this short list of the first few things you should customize in WooCommerce.', '{}', 'unactioned', 'woocommerce.com', '2022-06-15 16:24:43', NULL, 0, 'plain', '', 0, 0, 'info'),
(14, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(15, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(16, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(17, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(18, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(19, 'wcpay-promo-2020-11', 'marketing', 'en_US', 'wcpay-promo-2020-11', 'wcpay-promo-2020-11', '{}', 'pending', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(20, 'wcpay-promo-2020-12', 'marketing', 'en_US', 'wcpay-promo-2020-12', 'wcpay-promo-2020-12', '{}', 'pending', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(21, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(22, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(23, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(24, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(25, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(26, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(27, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(28, 'ecomm-wc-navigation-survey', 'info', 'en_US', 'We’d like your feedback on the WooCommerce navigation', 'We’re making improvements to the WooCommerce navigation and would love your feedback. Share your experience in this 2 minute survey.', '{}', 'pending', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(29, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(30, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(31, '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', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(32, 'setup_task_initiative_survey_q2_2022', 'survey', 'en_US', 'We want to know what matters most to you', 'Take 2 minutes to give us your input on what is important for you while setting up your store and help shape the future of WooCommerce together.', '{}', 'unactioned', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(33, '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', '2022-06-20 12:14:01', NULL, 0, 'plain', '', 0, 0, 'info'),
(34, 'wc-admin-EU-consumer-protection', 'marketing', 'en_US', 'Important changes to EU consumer protection laws', 'New regulations to help modernize and strengthen consumer protection laws in the European Union (EU) take effect on May 28, 2022. These rules impact all merchants selling to the EU, regardless of where their business is located. Further detailed information is available on the European Commission\'s official website.', '{}', 'unactioned', 'woocommerce.com', '2022-06-14 05:11:07', NULL, 0, 'plain', '', 0, 0, 'info'),
(35, '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', '2022-06-14 12:13:51', NULL, 0, 'plain', '', 0, 0, 'info'),
(36, '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', '2022-06-14 12:13:51', NULL, 0, 'plain', '', 0, 0, 'info'),
(37, 'wc-admin-insight-first-product-and-payment', 'survey', 'en_US', 'Insight', 'More than 80% of new merchants add the first product and have at least one payment method set up during the first week.<br><br>Do you find this type of insight useful?', '{}', 'unactioned', 'woocommerce-admin', '2022-06-14 12:13:51', NULL, 0, 'plain', '', 0, 0, 'info'),
(38, 'wc-admin-navigation-nudge', 'info', 'en_US', 'You now have access to the WooCommerce navigation', 'We’re introducing a new navigation for a more intuitive and improved user experience. You can enable the beta version of the new experience in the Advanced Settings. Enable it now for your store.', '{}', 'unactioned', 'woocommerce-admin', '2022-06-14 12:13:51', NULL, 0, 'plain', '', 0, 0, 'info'),
(39, 'wc-admin-complete-store-details', 'info', 'en_US', 'Add your store details to complete store setup', 'Complete your store details with important information for setup such as your store’s base address', '{}', 'unactioned', 'woocommerce-admin', '2022-06-14 12:13:51', NULL, 0, 'plain', '', 0, 0, 'info'),
(40, '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', '2022-06-15 16:24:42', NULL, 0, 'plain', '', 0, 0, 'info'),
(41, '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', '2022-06-15 16:24:42', NULL, 0, 'plain', '', 0, 0, 'info'),
(42, 'wc-admin-wisepad3', 'marketing', 'en_US', 'Take your business on the go in Canada with WooCommerce In-Person Payments', 'Quickly create new orders, accept payment in person for orders placed online, and automatically sync your inventory – no matter where your business takes you. With WooCommerce In-Person Payments and the WisePad 3 card reader, you can bring the power of your store anywhere.', '{}', 'pending', 'woocommerce.com', '2022-06-15 16:24:43', NULL, 0, 'plain', '', 0, 0, 'info'),
(43, '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', '2022-06-18 13:21:30', NULL, 0, 'plain', '', 0, 0, 'info'),
(44, '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>WooCommerce Payments</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', '2022-06-20 12:14:00', NULL, 0, 'plain', '', 0, 0, 'info'),
(45, 'wc-admin-insight-first-sale', 'survey', 'en_US', 'Did you know?', 'A WooCommerce powered store needs on average 31 days to get the first sale. You\'re on the right track! Do you find this type of insight useful?', '{}', 'unactioned', 'woocommerce-admin', '2022-06-20 12:14:00', NULL, 0, 'plain', '', 0, 0, 'info'),
(46, 'TikTok q2_2022', 'marketing', 'en_US', 'Give your store a stage on the world’s fastest-growing advertising channel', 'With TikTok for WooCommerce, you can sync your catalog, create videos, and track performance in front of TikTok’s one billion global users. Try the Smart Video Generator to make ads using your existing product images – no camera needed. Get $200 in ad credit from TikTok after a $20 spend (terms &amp; conditions apply).', '{}', 'unactioned', 'woocommerce.com', '2022-06-22 12:16:19', NULL, 0, 'plain', '', 0, 0, 'info');

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

--
-- Table structure for table `rob_wc_admin_note_actions`
--

CREATE TABLE `rob_wc_admin_note_actions` (
  `action_id` bigint UNSIGNED NOT NULL,
  `note_id` bigint 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `rob_wc_admin_note_actions`
--

INSERT INTO `rob_wc_admin_note_actions` (`action_id`, `note_id`, `name`, `label`, `query`, `status`, `actioned_text`, `nonce_action`, `nonce_name`) VALUES
(1, 1, 'notify-refund-returns-page', 'Edit page', 'https://wp.localserverweb.com/robertahoskie/wp-admin/post.php?post=176&action=edit', 'actioned', '', NULL, NULL),
(2, 2, 'connect', 'Connect', '?page=wc-addons&section=helper', 'unactioned', '', NULL, NULL),
(183, 35, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/pre-launch-checklist-the-essentials/?utm_source=inbox&utm_medium=product', 'actioned', '', NULL, NULL),
(184, 36, 'visit-the-theme-marketplace', 'Visit the theme marketplace', 'https://woocommerce.com/product-category/themes/?utm_source=inbox&utm_medium=product', 'actioned', '', NULL, NULL),
(185, 37, 'affirm-insight-first-product-and-payment', 'Yes', '', 'actioned', 'Thanks for your feedback', NULL, NULL),
(186, 37, 'affirm-insight-first-product-and-payment', 'No', '', 'actioned', 'Thanks for your feedback', NULL, NULL),
(225, 40, 'learn-more', 'Learn more', 'https://woocommerce.com/mobile/?utm_medium=product', 'actioned', '', NULL, NULL),
(226, 41, 'day-after-first-product', 'Learn more', 'https://woocommerce.com/document/woocommerce-customizer/?utm_source=inbox&utm_medium=product', 'actioned', '', NULL, NULL),
(523, 43, 'view-payment-gateways', 'Learn more', 'https://woocommerce.com/product-category/woocommerce-extensions/payment-gateways/?utm_medium=product', 'actioned', '', NULL, NULL),
(561, 38, 'enable-navigation', 'Enable in Settings', 'https://robertahoskie.com/wp-admin/admin.php?page=wc-settings&tab=advanced&section=features', 'actioned', '', NULL, NULL),
(562, 39, 'add-store-details', 'Add store details', 'https://robertahoskie.com/wp-admin/admin.php?page=wc-admin&path=/setup-wizard', 'actioned', '', NULL, NULL),
(600, 44, 'learn-more', 'Learn more', 'https://woocommerce.com/payments/?utm_medium=product', 'unactioned', '', NULL, NULL),
(601, 44, 'get-started', 'Get started', 'https://robertahoskie.com/wp-admin/admin.php?page=wc-admin&action=setup-woocommerce-payments', 'actioned', '', 'setup-woocommerce-payments', ''),
(602, 45, 'affirm-insight-first-sale', 'Yes', '', 'actioned', 'Thanks for your feedback', NULL, NULL),
(603, 45, 'deny-insight-first-sale', 'No', '', 'actioned', 'Thanks for your feedback', NULL, NULL),
(754, 3, 'browse_extensions', 'Browse extensions', 'https://robertahoskie.com/wp-admin/admin.php?page=wc-admin&page=wc-addons', 'unactioned', '', NULL, NULL),
(755, 4, '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),
(756, 5, '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),
(757, 6, 'wc_shipping_mobile_app_q4_2021', 'Get the WooCommerce Mobile App', 'https://woocommerce.com/mobile/?utm_source=inbox_note&utm_medium=product&utm_campaign=wc_shipping_mobile_app_q4_2021', 'actioned', '', NULL, NULL),
(758, 7, 'set-up-concierge', 'Schedule free session', 'https://wordpress.com/me/concierge', 'actioned', '', NULL, NULL),
(759, 8, 'learn-more', 'Learn more', 'https://docs.woocommerce.com/document/woocommerce-shipping-and-tax/?utm_source=inbox', 'unactioned', '', NULL, NULL),
(760, 9, 'learn-more-ecomm-unique-shopping-experience', 'Learn more', 'https://docs.woocommerce.com/document/product-add-ons/?utm_source=inbox', 'actioned', '', NULL, NULL),
(761, 10, 'watch-the-webinar', 'Watch the webinar', 'https://youtu.be/V_2XtCOyZ7o', 'actioned', '', NULL, NULL),
(762, 11, '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),
(763, 12, '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),
(764, 13, 'learn-more', 'Learn more', 'https://woocommerce.com/posts/first-things-customize-woocommerce/?utm_source=inbox_note&utm_medium=product&utm_campaign=learn-more', 'unactioned', '', NULL, NULL),
(765, 14, 'qualitative-feedback-from-new-users', 'Share feedback', 'https://automattic.survey.fm/wc-pay-new', 'actioned', '', NULL, NULL),
(766, 15, 'share-feedback', 'Share feedback', 'http://automattic.survey.fm/paypal-feedback', 'unactioned', '', NULL, NULL),
(767, 16, '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),
(768, 17, 'update-wc-subscriptions-3-0-15', 'View latest version', 'https://robertahoskie.com/wp-admin/admin.php?page=wc-admin&page=wc-addons&section=helper', 'actioned', '', NULL, NULL),
(769, 18, 'update-wc-core-5-4-0', 'How to update WooCommerce', 'https://docs.woocommerce.com/document/how-to-update-woocommerce/', 'actioned', '', NULL, NULL),
(770, 21, 'ppxo-pps-install-paypal-payments-1', 'View upgrade guide', 'https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/', 'actioned', '', NULL, NULL),
(771, 22, 'ppxo-pps-install-paypal-payments-2', 'View upgrade guide', 'https://docs.woocommerce.com/document/woocommerce-paypal-payments/paypal-payments-upgrade-guide/', 'actioned', '', NULL, NULL),
(772, 23, '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),
(773, 23, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(774, 24, '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),
(775, 24, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(776, 25, '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),
(777, 25, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(778, 26, '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),
(779, 26, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(780, 27, 'share-feedback', 'Share feedback', 'https://automattic.survey.fm/store-management', 'unactioned', '', NULL, NULL),
(781, 28, 'share-navigation-survey-feedback', 'Share feedback', 'https://automattic.survey.fm/feedback-on-woocommerce-navigation', 'actioned', '', NULL, NULL),
(782, 29, 'learn-more', 'Learn more', 'https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/', 'unactioned', '', NULL, NULL),
(783, 29, 'woocommerce-core-paypal-march-2022-dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(784, 30, 'learn-more', 'Learn more', 'https://developer.woocommerce.com/2022/03/10/woocommerce-3-5-10-6-3-1-security-releases/', 'unactioned', '', NULL, NULL),
(785, 30, 'dismiss', 'Dismiss', '', 'actioned', '', NULL, NULL),
(786, 31, '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),
(787, 32, 'setup_task_initiative_survey_q2_2022_share_your_input', 'Share your input', 'https://t.maze.co/87390007', 'actioned', '', NULL, NULL),
(788, 33, '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),
(789, 34, 'wc-admin-EU-consumer-protection', 'Learn more about these changes', 'https://ec.europa.eu/info/law/law-topic/consumer-protection-law/review-eu-consumer-law_en#guidance', 'actioned', '', NULL, NULL),
(790, 42, 'wc-admin-wisepad3', 'Grow my business offline', 'https://woocommerce.com/products/wisepad3-card-reader/?utm_source=inbox_note&utm_medium=product&utm_campaign=wc-admin-wisepad3', 'actioned', '', NULL, NULL),
(791, 46, 'TikTok q2_2022', 'Promote my products on TikTok', 'https://woocommerce.com/products/tiktok-for-woocommerce/?utm_source=inbox_note&utm_medium=product&utm_campaign=TikTok%20q2_2022', 'unactioned', '', NULL, NULL);

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

--
-- Table structure for table `rob_wc_category_lookup`
--

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

--
-- Dumping data for table `rob_wc_category_lookup`
--

INSERT INTO `rob_wc_category_lookup` (`category_tree_id`, `category_id`) VALUES
(21, 21);

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

--
-- Table structure for table `rob_wc_customer_lookup`
--

CREATE TABLE `rob_wc_customer_lookup` (
  `customer_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint 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 ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_wc_download_log`
--

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

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

--
-- Table structure for table `rob_wc_order_coupon_lookup`
--

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

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

--
-- Table structure for table `rob_wc_order_product_lookup`
--

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

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

--
-- Table structure for table `rob_wc_order_stats`
--

CREATE TABLE `rob_wc_order_stats` (
  `order_id` bigint UNSIGNED NOT NULL,
  `parent_id` bigint 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',
  `num_items_sold` int 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 UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_wc_order_tax_lookup`
--

CREATE TABLE `rob_wc_order_tax_lookup` (
  `order_id` bigint UNSIGNED NOT NULL,
  `tax_rate_id` bigint 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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_wc_product_attributes_lookup`
--

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

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

--
-- Table structure for table `rob_wc_product_download_directories`
--

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

--
-- Dumping data for table `rob_wc_product_download_directories`
--

INSERT INTO `rob_wc_product_download_directories` (`url_id`, `url`, `enabled`) VALUES
(1, 'file:///var/www/html/wp/robertahoskie/wp-content/uploads/woocommerce_uploads/', 1),
(2, 'https://wp.localserverweb.com/robertahoskie/wp-content/uploads/woocommerce_uploads/', 1);

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

--
-- Table structure for table `rob_wc_product_meta_lookup`
--

CREATE TABLE `rob_wc_product_meta_lookup` (
  `product_id` bigint 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 DEFAULT '0',
  `average_rating` decimal(3,2) DEFAULT '0.00',
  `total_sales` bigint DEFAULT '0',
  `tax_status` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'taxable',
  `tax_class` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `rob_wc_product_meta_lookup`
--

INSERT INTO `rob_wc_product_meta_lookup` (`product_id`, `sku`, `virtual`, `downloadable`, `min_price`, `max_price`, `onsale`, `stock_quantity`, `stock_status`, `rating_count`, `average_rating`, `total_sales`, `tax_status`, `tax_class`) VALUES
(177, '', 0, 0, '97.0000', '97.0000', 0, NULL, 'instock', 0, '0.00', 0, 'taxable', ''),
(178, '', 0, 0, '599.0000', '599.0000', 0, NULL, 'instock', 0, '0.00', 0, 'taxable', ''),
(179, '', 0, 0, '599.0000', '599.0000', 0, NULL, 'instock', 0, '0.00', 0, 'taxable', ''),
(181, '', 0, 0, '599.0000', '599.0000', 0, NULL, 'instock', 0, '0.00', 0, 'taxable', '');

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

--
-- Table structure for table `rob_wc_rate_limits`
--

CREATE TABLE `rob_wc_rate_limits` (
  `rate_limit_id` bigint UNSIGNED NOT NULL,
  `rate_limit_key` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `rate_limit_expiry` bigint UNSIGNED NOT NULL,
  `rate_limit_remaining` smallint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_wc_reserved_stock`
--

CREATE TABLE `rob_wc_reserved_stock` (
  `order_id` bigint NOT NULL,
  `product_id` bigint 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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_wc_tax_rate_classes`
--

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

--
-- Dumping data for table `rob_wc_tax_rate_classes`
--

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

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

--
-- Table structure for table `rob_wc_webhooks`
--

CREATE TABLE `rob_wc_webhooks` (
  `webhook_id` bigint UNSIGNED NOT NULL,
  `status` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `user_id` bigint 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 NOT NULL,
  `failure_count` smallint NOT NULL DEFAULT '0',
  `pending_delivery` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_woocommerce_api_keys`
--

CREATE TABLE `rob_woocommerce_api_keys` (
  `key_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_woocommerce_attribute_taxonomies`
--

CREATE TABLE `rob_woocommerce_attribute_taxonomies` (
  `attribute_id` bigint UNSIGNED NOT NULL,
  `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 NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_woocommerce_downloadable_product_permissions`
--

CREATE TABLE `rob_woocommerce_downloadable_product_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `download_id` varchar(36) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `product_id` bigint UNSIGNED NOT NULL,
  `order_id` bigint 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 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 UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_woocommerce_log`
--

CREATE TABLE `rob_woocommerce_log` (
  `log_id` bigint UNSIGNED NOT NULL,
  `timestamp` datetime NOT NULL,
  `level` smallint 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_woocommerce_order_itemmeta`
--

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

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

--
-- Table structure for table `rob_woocommerce_order_items`
--

CREATE TABLE `rob_woocommerce_order_items` (
  `order_item_id` bigint UNSIGNED NOT NULL,
  `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 UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_woocommerce_payment_tokenmeta`
--

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

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

--
-- Table structure for table `rob_woocommerce_payment_tokens`
--

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

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

--
-- Table structure for table `rob_woocommerce_shipping_zones`
--

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

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

--
-- Table structure for table `rob_woocommerce_shipping_zone_locations`
--

CREATE TABLE `rob_woocommerce_shipping_zone_locations` (
  `location_id` bigint UNSIGNED NOT NULL,
  `zone_id` bigint 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_woocommerce_shipping_zone_methods`
--

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

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

--
-- Table structure for table `rob_woocommerce_tax_rates`
--

CREATE TABLE `rob_woocommerce_tax_rates` (
  `tax_rate_id` bigint UNSIGNED NOT NULL,
  `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 UNSIGNED NOT NULL,
  `tax_rate_compound` int NOT NULL DEFAULT '0',
  `tax_rate_shipping` int NOT NULL DEFAULT '1',
  `tax_rate_order` bigint UNSIGNED NOT NULL,
  `tax_rate_class` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

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

--
-- Table structure for table `rob_woocommerce_tax_rate_locations`
--

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

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

--
-- Table structure for table `rob_wpmailsmtp_debug_events`
--

CREATE TABLE `rob_wpmailsmtp_debug_events` (
  `id` int UNSIGNED NOT NULL,
  `content` text COLLATE utf8mb4_unicode_520_ci,
  `initiator` text COLLATE utf8mb4_unicode_520_ci,
  `event_type` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `rob_wpmailsmtp_debug_events`
--

INSERT INTO `rob_wpmailsmtp_debug_events` (`id`, `content`, `initiator`, `event_type`, `created_at`) VALUES
(1, 'Mailer: Google / Gmail\r\n{\n  \"error\": {\n    \"code\": 429,\n    \"message\": \"User-rate limit exceeded.  Retry after 2022-06-19T18:45:04.019Z (Mail sending)\",\n    \"errors\": [\n      {\n        \"message\": \"User-rate limit exceeded.  Retry after 2022-06-19T18:45:04.019Z (Mail sending)\",\n        \"domain\": \"global\",\n        \"reason\": \"rateLimitExceeded\"\n      }\n    ],\n    \"status\": \"RESOURCE_EXHAUSTED\"\n  }\n}', '{\"file\":\"\\/var\\/www\\/html\\/wp\\/robertahoskie\\/wp-content\\/plugins\\/contact-form-7\\/includes\\/mail.php\",\"line\":194}', 0, '2022-06-19 18:30:04'),
(2, 'Mailer: Google / Gmail\r\n{\n  \"error\": {\n    \"code\": 429,\n    \"message\": \"User-rate limit exceeded.  Retry after 2022-06-22T10:46:32.772Z (Mail sending)\",\n    \"errors\": [\n      {\n        \"message\": \"User-rate limit exceeded.  Retry after 2022-06-22T10:46:32.772Z (Mail sending)\",\n        \"domain\": \"global\",\n        \"reason\": \"rateLimitExceeded\"\n      }\n    ],\n    \"status\": \"RESOURCE_EXHAUSTED\"\n  }\n}', '{\"file\":\"\\/var\\/www\\/html\\/wp\\/robertahoskie\\/wp-content\\/plugins\\/contact-form-7\\/includes\\/mail.php\",\"line\":194}', 0, '2022-06-22 10:31:32');

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

--
-- Table structure for table `rob_wpmailsmtp_tasks_meta`
--

CREATE TABLE `rob_wpmailsmtp_tasks_meta` (
  `id` bigint NOT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `data` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `rob_wpmailsmtp_tasks_meta`
--

INSERT INTO `rob_wpmailsmtp_tasks_meta` (`id`, `action`, `data`, `date`) VALUES
(1, 'wp_mail_smtp_summary_report_email', 'W10=', '2022-06-14 05:13:01'),
(2, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2022-06-14 05:23:49'),
(3, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2022-06-16 05:48:17'),
(4, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2022-06-17 09:10:01'),
(5, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2022-06-18 13:31:34'),
(6, 'wp_mail_smtp_admin_notifications_update', 'W10=', '2022-06-24 17:21:29');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `rob_actionscheduler_actions`
--
ALTER TABLE `rob_actionscheduler_actions`
  ADD PRIMARY KEY (`action_id`),
  ADD KEY `hook` (`hook`),
  ADD KEY `status` (`status`),
  ADD KEY `scheduled_date_gmt` (`scheduled_date_gmt`),
  ADD KEY `args` (`args`),
  ADD KEY `group_id` (`group_id`),
  ADD KEY `last_attempt_gmt` (`last_attempt_gmt`),
  ADD KEY `claim_id_status_scheduled_date_gmt` (`claim_id`,`status`,`scheduled_date_gmt`);

--
-- Indexes for table `rob_actionscheduler_claims`
--
ALTER TABLE `rob_actionscheduler_claims`
  ADD PRIMARY KEY (`claim_id`),
  ADD KEY `date_created_gmt` (`date_created_gmt`);

--
-- Indexes for table `rob_actionscheduler_groups`
--
ALTER TABLE `rob_actionscheduler_groups`
  ADD PRIMARY KEY (`group_id`),
  ADD KEY `slug` (`slug`(191));

--
-- Indexes for table `rob_actionscheduler_logs`
--
ALTER TABLE `rob_actionscheduler_logs`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `action_id` (`action_id`),
  ADD KEY `log_date_gmt` (`log_date_gmt`);

--
-- Indexes for table `rob_commentmeta`
--
ALTER TABLE `rob_commentmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `comment_id` (`comment_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indexes for table `rob_comments`
--
ALTER TABLE `rob_comments`
  ADD PRIMARY KEY (`comment_ID`),
  ADD KEY `comment_post_ID` (`comment_post_ID`),
  ADD KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
  ADD KEY `comment_date_gmt` (`comment_date_gmt`),
  ADD KEY `comment_parent` (`comment_parent`),
  ADD KEY `comment_author_email` (`comment_author_email`(10)),
  ADD KEY `woo_idx_comment_type` (`comment_type`);

--
-- Indexes for table `rob_links`
--
ALTER TABLE `rob_links`
  ADD PRIMARY KEY (`link_id`),
  ADD KEY `link_visible` (`link_visible`);

--
-- Indexes for table `rob_options`
--
ALTER TABLE `rob_options`
  ADD PRIMARY KEY (`option_id`),
  ADD UNIQUE KEY `option_name` (`option_name`),
  ADD KEY `autoload` (`autoload`);

--
-- Indexes for table `rob_postmeta`
--
ALTER TABLE `rob_postmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `post_id` (`post_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indexes for table `rob_termmeta`
--
ALTER TABLE `rob_termmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `term_id` (`term_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indexes for table `rob_terms`
--
ALTER TABLE `rob_terms`
  ADD PRIMARY KEY (`term_id`),
  ADD KEY `slug` (`slug`(191)),
  ADD KEY `name` (`name`(191));

--
-- Indexes for table `rob_term_relationships`
--
ALTER TABLE `rob_term_relationships`
  ADD PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  ADD KEY `term_taxonomy_id` (`term_taxonomy_id`);

--
-- Indexes for table `rob_term_taxonomy`
--
ALTER TABLE `rob_term_taxonomy`
  ADD PRIMARY KEY (`term_taxonomy_id`),
  ADD UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  ADD KEY `taxonomy` (`taxonomy`);

--
-- Indexes for table `rob_usermeta`
--
ALTER TABLE `rob_usermeta`
  ADD PRIMARY KEY (`umeta_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `meta_key` (`meta_key`(191));

--
-- Indexes for table `rob_wc_admin_notes`
--
ALTER TABLE `rob_wc_admin_notes`
  ADD PRIMARY KEY (`note_id`);

--
-- Indexes for table `rob_wc_admin_note_actions`
--
ALTER TABLE `rob_wc_admin_note_actions`
  ADD PRIMARY KEY (`action_id`),
  ADD KEY `note_id` (`note_id`);

--
-- Indexes for table `rob_wc_category_lookup`
--
ALTER TABLE `rob_wc_category_lookup`
  ADD PRIMARY KEY (`category_tree_id`,`category_id`);

--
-- Indexes for table `rob_wc_customer_lookup`
--
ALTER TABLE `rob_wc_customer_lookup`
  ADD PRIMARY KEY (`customer_id`),
  ADD UNIQUE KEY `user_id` (`user_id`),
  ADD KEY `email` (`email`);

--
-- Indexes for table `rob_wc_download_log`
--
ALTER TABLE `rob_wc_download_log`
  ADD PRIMARY KEY (`download_log_id`),
  ADD KEY `permission_id` (`permission_id`),
  ADD KEY `timestamp` (`timestamp`);

--
-- Indexes for table `rob_wc_order_coupon_lookup`
--
ALTER TABLE `rob_wc_order_coupon_lookup`
  ADD PRIMARY KEY (`order_id`,`coupon_id`),
  ADD KEY `coupon_id` (`coupon_id`),
  ADD KEY `date_created` (`date_created`);

--
-- Indexes for table `rob_wc_order_product_lookup`
--
ALTER TABLE `rob_wc_order_product_lookup`
  ADD PRIMARY KEY (`order_item_id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `date_created` (`date_created`);

--
-- Indexes for table `rob_wc_order_stats`
--
ALTER TABLE `rob_wc_order_stats`
  ADD PRIMARY KEY (`order_id`),
  ADD KEY `date_created` (`date_created`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `status` (`status`(191));

--
-- Indexes for table `rob_wc_order_tax_lookup`
--
ALTER TABLE `rob_wc_order_tax_lookup`
  ADD PRIMARY KEY (`order_id`,`tax_rate_id`),
  ADD KEY `tax_rate_id` (`tax_rate_id`),
  ADD KEY `date_created` (`date_created`);

--
-- Indexes for table `rob_wc_product_attributes_lookup`
--
ALTER TABLE `rob_wc_product_attributes_lookup`
  ADD PRIMARY KEY (`product_or_parent_id`,`term_id`,`product_id`,`taxonomy`),
  ADD KEY `is_variation_attribute_term_id` (`is_variation_attribute`,`term_id`);

--
-- Indexes for table `rob_wc_product_download_directories`
--
ALTER TABLE `rob_wc_product_download_directories`
  ADD PRIMARY KEY (`url_id`),
  ADD KEY `url` (`url`(191));

--
-- Indexes for table `rob_wc_product_meta_lookup`
--
ALTER TABLE `rob_wc_product_meta_lookup`
  ADD PRIMARY KEY (`product_id`),
  ADD KEY `virtual` (`virtual`),
  ADD KEY `downloadable` (`downloadable`),
  ADD KEY `stock_status` (`stock_status`),
  ADD KEY `stock_quantity` (`stock_quantity`),
  ADD KEY `onsale` (`onsale`),
  ADD KEY `min_max_price` (`min_price`,`max_price`);

--
-- Indexes for table `rob_wc_rate_limits`
--
ALTER TABLE `rob_wc_rate_limits`
  ADD PRIMARY KEY (`rate_limit_id`),
  ADD UNIQUE KEY `rate_limit_key` (`rate_limit_key`(191));

--
-- Indexes for table `rob_wc_reserved_stock`
--
ALTER TABLE `rob_wc_reserved_stock`
  ADD PRIMARY KEY (`order_id`,`product_id`);

--
-- Indexes for table `rob_wc_tax_rate_classes`
--
ALTER TABLE `rob_wc_tax_rate_classes`
  ADD PRIMARY KEY (`tax_rate_class_id`),
  ADD UNIQUE KEY `slug` (`slug`(191));

--
-- Indexes for table `rob_wc_webhooks`
--
ALTER TABLE `rob_wc_webhooks`
  ADD PRIMARY KEY (`webhook_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `rob_woocommerce_api_keys`
--
ALTER TABLE `rob_woocommerce_api_keys`
  ADD PRIMARY KEY (`key_id`),
  ADD KEY `consumer_key` (`consumer_key`),
  ADD KEY `consumer_secret` (`consumer_secret`);

--
-- Indexes for table `rob_woocommerce_attribute_taxonomies`
--
ALTER TABLE `rob_woocommerce_attribute_taxonomies`
  ADD PRIMARY KEY (`attribute_id`),
  ADD KEY `attribute_name` (`attribute_name`(20));

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

--
-- Indexes for table `rob_woocommerce_log`
--
ALTER TABLE `rob_woocommerce_log`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `level` (`level`);

--
-- Indexes for table `rob_woocommerce_order_itemmeta`
--
ALTER TABLE `rob_woocommerce_order_itemmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `order_item_id` (`order_item_id`),
  ADD KEY `meta_key` (`meta_key`(32));

--
-- Indexes for table `rob_woocommerce_order_items`
--
ALTER TABLE `rob_woocommerce_order_items`
  ADD PRIMARY KEY (`order_item_id`),
  ADD KEY `order_id` (`order_id`);

--
-- Indexes for table `rob_woocommerce_payment_tokenmeta`
--
ALTER TABLE `rob_woocommerce_payment_tokenmeta`
  ADD PRIMARY KEY (`meta_id`),
  ADD KEY `payment_token_id` (`payment_token_id`),
  ADD KEY `meta_key` (`meta_key`(32));

--
-- Indexes for table `rob_woocommerce_payment_tokens`
--
ALTER TABLE `rob_woocommerce_payment_tokens`
  ADD PRIMARY KEY (`token_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `rob_woocommerce_shipping_zones`
--
ALTER TABLE `rob_woocommerce_shipping_zones`
  ADD PRIMARY KEY (`zone_id`);

--
-- Indexes for table `rob_woocommerce_shipping_zone_locations`
--
ALTER TABLE `rob_woocommerce_shipping_zone_locations`
  ADD PRIMARY KEY (`location_id`),
  ADD KEY `location_id` (`location_id`),
  ADD KEY `location_type_code` (`location_type`(10),`location_code`(20));

--
-- Indexes for table `rob_woocommerce_shipping_zone_methods`
--
ALTER TABLE `rob_woocommerce_shipping_zone_methods`
  ADD PRIMARY KEY (`instance_id`);

--
-- Indexes for table `rob_woocommerce_tax_rates`
--
ALTER TABLE `rob_woocommerce_tax_rates`
  ADD PRIMARY KEY (`tax_rate_id`),
  ADD KEY `tax_rate_country` (`tax_rate_country`),
  ADD KEY `tax_rate_state` (`tax_rate_state`(2)),
  ADD KEY `tax_rate_class` (`tax_rate_class`(10)),
  ADD KEY `tax_rate_priority` (`tax_rate_priority`);

--
-- Indexes for table `rob_woocommerce_tax_rate_locations`
--
ALTER TABLE `rob_woocommerce_tax_rate_locations`
  ADD PRIMARY KEY (`location_id`),
  ADD KEY `tax_rate_id` (`tax_rate_id`),
  ADD KEY `location_type_code` (`location_type`(10),`location_code`(20));

--
-- Indexes for table `rob_wpmailsmtp_debug_events`
--
ALTER TABLE `rob_wpmailsmtp_debug_events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `rob_wpmailsmtp_tasks_meta`
--
ALTER TABLE `rob_wpmailsmtp_tasks_meta`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `rob_actionscheduler_actions`
--
ALTER TABLE `rob_actionscheduler_actions`
  MODIFY `action_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=204;

--
-- AUTO_INCREMENT for table `rob_actionscheduler_claims`
--
ALTER TABLE `rob_actionscheduler_claims`
  MODIFY `claim_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2536;

--
-- AUTO_INCREMENT for table `rob_actionscheduler_groups`
--
ALTER TABLE `rob_actionscheduler_groups`
  MODIFY `group_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `rob_actionscheduler_logs`
--
ALTER TABLE `rob_actionscheduler_logs`
  MODIFY `log_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=95;

--
-- AUTO_INCREMENT for table `rob_commentmeta`
--
ALTER TABLE `rob_commentmeta`
  MODIFY `meta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_comments`
--
ALTER TABLE `rob_comments`
  MODIFY `comment_ID` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `rob_links`
--
ALTER TABLE `rob_links`
  MODIFY `link_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_options`
--
ALTER TABLE `rob_options`
  MODIFY `option_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5854;

--
-- AUTO_INCREMENT for table `rob_postmeta`
--
ALTER TABLE `rob_postmeta`
  MODIFY `meta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4270;

--
-- AUTO_INCREMENT for table `rob_termmeta`
--
ALTER TABLE `rob_termmeta`
  MODIFY `meta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `rob_terms`
--
ALTER TABLE `rob_terms`
  MODIFY `term_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `rob_term_taxonomy`
--
ALTER TABLE `rob_term_taxonomy`
  MODIFY `term_taxonomy_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `rob_usermeta`
--
ALTER TABLE `rob_usermeta`
  MODIFY `umeta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `rob_wc_admin_notes`
--
ALTER TABLE `rob_wc_admin_notes`
  MODIFY `note_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `rob_wc_admin_note_actions`
--
ALTER TABLE `rob_wc_admin_note_actions`
  MODIFY `action_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=792;

--
-- AUTO_INCREMENT for table `rob_wc_customer_lookup`
--
ALTER TABLE `rob_wc_customer_lookup`
  MODIFY `customer_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_wc_download_log`
--
ALTER TABLE `rob_wc_download_log`
  MODIFY `download_log_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_wc_product_download_directories`
--
ALTER TABLE `rob_wc_product_download_directories`
  MODIFY `url_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `rob_wc_rate_limits`
--
ALTER TABLE `rob_wc_rate_limits`
  MODIFY `rate_limit_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_wc_tax_rate_classes`
--
ALTER TABLE `rob_wc_tax_rate_classes`
  MODIFY `tax_rate_class_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `rob_wc_webhooks`
--
ALTER TABLE `rob_wc_webhooks`
  MODIFY `webhook_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_api_keys`
--
ALTER TABLE `rob_woocommerce_api_keys`
  MODIFY `key_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_attribute_taxonomies`
--
ALTER TABLE `rob_woocommerce_attribute_taxonomies`
  MODIFY `attribute_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_downloadable_product_permissions`
--
ALTER TABLE `rob_woocommerce_downloadable_product_permissions`
  MODIFY `permission_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_log`
--
ALTER TABLE `rob_woocommerce_log`
  MODIFY `log_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_order_itemmeta`
--
ALTER TABLE `rob_woocommerce_order_itemmeta`
  MODIFY `meta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_order_items`
--
ALTER TABLE `rob_woocommerce_order_items`
  MODIFY `order_item_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_payment_tokenmeta`
--
ALTER TABLE `rob_woocommerce_payment_tokenmeta`
  MODIFY `meta_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_payment_tokens`
--
ALTER TABLE `rob_woocommerce_payment_tokens`
  MODIFY `token_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_shipping_zones`
--
ALTER TABLE `rob_woocommerce_shipping_zones`
  MODIFY `zone_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_shipping_zone_locations`
--
ALTER TABLE `rob_woocommerce_shipping_zone_locations`
  MODIFY `location_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_shipping_zone_methods`
--
ALTER TABLE `rob_woocommerce_shipping_zone_methods`
  MODIFY `instance_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_tax_rates`
--
ALTER TABLE `rob_woocommerce_tax_rates`
  MODIFY `tax_rate_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_woocommerce_tax_rate_locations`
--
ALTER TABLE `rob_woocommerce_tax_rate_locations`
  MODIFY `location_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rob_wpmailsmtp_debug_events`
--
ALTER TABLE `rob_wpmailsmtp_debug_events`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `rob_wpmailsmtp_tasks_meta`
--
ALTER TABLE `rob_wpmailsmtp_tasks_meta`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `rob_wc_download_log`
--
ALTER TABLE `rob_wc_download_log`
  ADD CONSTRAINT `fk_rob_wc_download_log_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `rob_woocommerce_downloadable_product_permissions` (`permission_id`) ON DELETE CASCADE;
COMMIT;

