
INSERT INTO `was_hub_milestone_action` (`action_label`, `action_type`, `action_uri`) 
VALUES
('View Class 1 Here', 'POPUP', 'classes/series/laying-the-groundwork-for-your-bootcamp-business/getting-rolling-with-your-new-bootcamp-business'),
('View Class 3 Here', 'POPUP', 'classes/series/laying-the-groundwork-for-your-bootcamp-business/creating-your-about-me-post-using-our-designer');
('View Class 2 Here', 'POPUP', 'classes/series/laying-the-groundwork-for-your-bootcamp-business/how-the-make-money-online-process-really-works'),
('View Class 4 Here', 'POPUP', 'classes/series/laying-the-groundwork-for-your-bootcamp-business/going-live-with-your-business-and-brand'),
('Learn How Here', 'POPUP', 'classes/series/creating-your-brand-design-and-high-ranking-keyword-rich-content/keyword-research-with-jaaxy'),
('Learn How Here', 'POPUP', 'classes/series/creating-your-brand-design-and-high-ranking-keyword-rich-content/creating-images-with-ai'),
('Learn How Here', 'POPUP', 'classes/series/creating-your-brand-design-and-high-ranking-keyword-rich-content/optimizing-your-design-and-user-experience'),
('Learn How Here', 'POPUP', 'classes/series/building-your-brand-design-and-high-ranking-keyword-rich-content/wa-affiliate-program-walk-through'),
('Learn How Here', 'POPUP', 'classes/series/growth-building-rankings-and-momentum-in-your-business/harnessing-website-speed-for-better-user-engagement'),
('Learn How Here', 'POPUP', 'classes/series/growth-building-rankings-and-momentum-in-your-business/integrating-ai-and-chatgpt-in-your-business'),
('Learn How Here', 'POPUP', 'classes/series/growth-building-rankings-and-momentum-in-your-business/perfecting-on-page-seo-elements'),
('Learn How Here', 'POPUP', 'classes/series/make-money-social-media-and-getting-ready-to-scale/introduction-to-the-world-of-social-media'),
('Learn How Here', 'POPUP', 'classes/series/make-money-social-media-and-getting-ready-to-scale/scaling-and-building-out-your-thriving-business'),
('Learn How Here', 'POPUP', 'classes/series/make-money-social-media-and-getting-ready-to-scale/generating-buzz-with-shareable-content'),
('Learn How Here', 'POPUP', 'classes/series/make-money-social-media-and-getting-ready-to-scale/understanding-the-affiliate-marketing-financials'),
('Learn How Here', 'POPUP', 'classes/series/promoting-wa-social-media-and-getting-ready-to-scale/a-full-intro-to-affiliate-marketing'),
('Learn How Here', 'POPUP', 'classes/series/promoting-wa-social-media-and-getting-ready-to-scale/using-affiliate-links-disclaimers'),
('Learn How Here', 'POPUP', 'classes/series/make-money-social-media-and-getting-ready-to-scale/leveraging-wealthy-affiliates-training-modules'),
('Learn How Here', 'POPUP', 'classes/series/promoting-wa-social-media-and-getting-ready-to-scale/setting-up-your-branded-profiles-on-social-media');

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'make_money_process' AS slug,
  'How To Make Money' AS title,
  'Learn how the Make Money Online process works and how to start earning revenue from your website' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/laying-the-groundwork-for-your-bootcamp-business/how-the-make-money-online-process-really-works'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'upgrade_membership' AS slug,
  'Go Live' AS title,
  'Go Live with your business! Become visible to Search Engines and connect with potential customers to start earning money from your website' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/laying-the-groundwork-for-your-bootcamp-business/going-live-with-your-business-and-brand'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'research_and_add_writing_task' AS slug,
  'Keyword Research' AS title,
  'Find low competition keywords for your content using our research platform Jaaxy.' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/creating-your-brand-design-and-high-ranking-keyword-rich-content/keyword-research-with-jaaxy'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'create_image_using_ai' AS slug,
  'Create AI Image' AS title,
  'Create a relevant image to enhance your published content using AI' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/creating-your-brand-design-and-high-ranking-keyword-rich-content/creating-images-with-ai'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'create_top_menu' AS slug,
  'Add Website Menu' AS title,
  'Add a top menu for optimal navigation on your website' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/creating-your-brand-design-and-high-ranking-keyword-rich-content/optimizing-your-design-and-user-experience'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'website_speed' AS slug,
  'Website Speed' AS title,
  'Check your website speed. Learn how to optimize for a blazing fast and engaging user experience that will earn you the highest possible Search Engine rankings' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/growth-building-rankings-and-momentum-in-your-business/harnessing-website-speed-for-better-user-engagement'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'learn_ai' AS slug,
  'Learn AI' AS title,
  'Integrate AI and ChatGPT into your business' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/growth-building-rankings-and-momentum-in-your-business/integrating-ai-and-chatgpt-in-your-business'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'internal_linking' AS slug,
  'Internal Linking' AS title,
  'Perfect your on-page SEO. Learn how to interlink your content for optimal rankings.' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/growth-building-rankings-and-momentum-in-your-business/perfecting-on-page-seo-elements'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'request_indexing' AS slug,
  'Request Indexing' AS title,
  'Request Indexing of your content in Google Search Console.' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'kyle/blog/how-to-request-indexing-in-google-through-search-console'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'social_media_intro' AS slug,
  'Social Media' AS title,
  'Use social media as an amplification tool and choose platforms that are aligned with your audience.' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/make-money-social-media-and-getting-ready-to-scale/introduction-to-the-world-of-social-media'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'share_on_social_media' AS slug,
  'Social Share' AS title,
  'Setup your Business profiles on Social Media Networks to begin sharing your content' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/make-money-social-media-and-getting-ready-to-scale/generating-buzz-with-shareable-content'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'calculate_affiliate_goals' AS slug,
  'Affiliate Goals' AS title,
  'Understand and set your affiliate marketing financial and revenue goals.' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/make-money-social-media-and-getting-ready-to-scale/understanding-the-affiliate-marketing-financials'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'watch_scaling_business' AS slug,
  'Business Growth' AS title,
  'Scale and build out your thriving online business.' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/make-money-social-media-and-getting-ready-to-scale/scaling-and-building-out-your-thriving-business'
LIMIT 1;

-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'watch_learn_more_with_wa' AS slug,
  'Next Steps' AS title,
  'Leverage the vast amount of training modules here at Wealthy Affiliate to constantly stay current and ensure growth for your business.' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/make-money-social-media-and-getting-ready-to-scale/leveraging-wealthy-affiliates-training-modules'
LIMIT 1;


-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'affiliate_program_walkthrough' AS slug,
  'Affiliate Program Walkthrough' AS title,
  'Watch a walkthrough of the WA Affiliate Program' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/building-your-brand-design-and-high-ranking-keyword-rich-content/wa-affiliate-program-walk-through'
LIMIT 1;


-- Insert for a new milestone under the "Bootcamp" hub type
INSERT INTO `was_hub_milestone` (`business_type_id`, `milestone_order`, `slug`, `title`, `description`, `milestone_action_id`)
SELECT 
  2 AS business_type_id,
  0 AS milestone_order,
  'join_your_first_affiliate_program' AS slug,
  'Your WA Affiliate Link' AS title,
  'Get your WA Affiliate link to start building your recurring revenue stream' AS description,
  milestone_action_id
FROM was_hub_milestone_action
WHERE action_uri = 'classes/series/promoting-wa-social-media-and-getting-ready-to-scale/a-full-intro-to-affiliate-marketing'
LIMIT 1;

-- Slug: add_affiliate_disclosure_page, affiliate_links (s4class2)
UPDATE
	was_hub_milestone m 
	JOIN was_hub_milestone_action ma on ma.action_uri = 'classes/series/promoting-wa-social-media-and-getting-ready-to-scale/using-affiliate-links-disclaimers' 
SET
	m.milestone_action_id = ma.milestone_action_id
WHERE
	slug IN('add_affiliate_disclosure_page', 'affiliate_links')
  AND business_type_id = 2;

-- Slugs: create_facebook_page, first_facebook_page_post, first_x_com_post, first_pinterest_post (S4class4)
UPDATE
	was_hub_milestone m 
	JOIN was_hub_milestone_action ma on ma.action_uri = 'classes/series/promoting-wa-social-media-and-getting-ready-to-scale/setting-up-your-branded-profiles-on-social-media' 
SET
	m.milestone_action_id = ma.milestone_action_id
WHERE
	slug IN('create_facebook_page', 'first_facebook_page_post', 'first_x_com_post', 'first_pinterest_post')
  AND business_type_id = 2;


UPDATE
	was_hub_milestone m 
	JOIN was_hub_milestone_action ma on ma.action_uri = 'classes/series/laying-the-groundwork-for-your-bootcamp-business/getting-rolling-with-your-new-bootcamp-business' 
SET
	m.milestone_action_id = ma.milestone_action_id
WHERE
	slug = 'training_intro'
  AND business_type_id = 2;

UPDATE
	was_hub_milestone m 
	JOIN was_hub_milestone_action ma on ma.action_uri = 'classes/series/laying-the-groundwork-for-your-bootcamp-business/creating-your-about-me-post-using-our-designer' 
SET
	m.milestone_action_id = ma.milestone_action_id
WHERE
	slug = 'about_me'
  AND business_type_id = 2;



UPDATE was_hub_milestone SET milestone_order = 1  WHERE slug = 'choose_to_promote_wa'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 2  WHERE slug = 'create_brand'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 3  WHERE slug = 'build_website'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 4  WHERE slug = 'training_intro'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 5  WHERE slug = 'make_money_process'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 6  WHERE slug = 'about_me'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 7  WHERE slug = 'upgrade_membership'  AND business_type_id = 2;

UPDATE was_hub_milestone SET milestone_order = 8  WHERE slug = 'register_domain'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 9  WHERE slug = 'add_logo'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 10 WHERE slug = 'privacy_policy'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 11 WHERE slug = 'affiliate_program_walkthrough'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 12 WHERE slug = 'setup_wa_profile'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 13 WHERE slug = 'join_live_chat'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 14 WHERE slug = 'research_and_add_writing_task'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 15 WHERE slug = 'publish_wa_review'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 16 WHERE slug = 'create_top_menu'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 17 WHERE slug = '7x_posts'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 18 WHERE slug = 'first_website_comment'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 19 WHERE slug = 'create_domain_specific_email_address'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 20 WHERE slug = 'create_gravatar'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 21 WHERE slug = 'create_new_website_user'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 22 WHERE slug = 'add_featured_images_to_all_posts'  AND business_type_id = 2;

UPDATE was_hub_milestone SET milestone_order = 23 WHERE slug = 'first_niche_article'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 24 WHERE slug = 'create_image_using_ai'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 25 WHERE slug = 'setup_seo_framework'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 26 WHERE slug = 'setup_google_site_kit'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 27 WHERE slug = 'website_speed'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 28 WHERE slug = 'learn_ai'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 29 WHERE slug = 'internal_linking'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 30 WHERE slug = 'request_indexing'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 31 WHERE slug = 'add_youtube_video_to_your_website'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 32 WHERE slug = '15x_posts'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 33 WHERE slug = 'join_application_based_program'  AND business_type_id = 2;

UPDATE was_hub_milestone SET milestone_order = 34 WHERE slug = 'join_your_first_affiliate_program'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 35 WHERE slug = 'add_affiliate_disclosure_page'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 36 WHERE slug = 'social_media_intro'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 37 WHERE slug = 'join_facebook'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 38 WHERE slug = 'create_facebook_page'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 39 WHERE slug = 'first_facebook_page_post'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 40 WHERE slug = 'join_x_com'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 41 WHERE slug = 'first_x_com_post'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 42 WHERE slug = 'join_pinterest'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 43 WHERE slug = 'first_pinterest_post'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 44 WHERE slug = 'share_on_social_media'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 45 WHERE slug = 'explore_appearance_themes_of_your_website'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 46 WHERE slug = 'calculate_affiliate_goals'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 47 WHERE slug = 'apply_for_google_adsense'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 48 WHERE slug = 'watch_scaling_business'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 49 WHERE slug = 'watch_learn_more_with_wa'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 50 WHERE slug = '25x_posts'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 51 WHERE slug = 'create_new_categories_in_hubs'  AND business_type_id = 2;
UPDATE was_hub_milestone SET milestone_order = 52 WHERE slug = '50x_posts'  AND business_type_id = 2;

DELETE FROM was_hub_milestone 
WHERE business_type_id = 2
	AND slug in('first_review_page', 'affiliate_links');