ALTER TABLE `tbltenant_plan_information` CHANGE `plan_purchase_frequency` `plan_purchase_frequency` ENUM('monthly','yearly','1_year','2_year','3_year') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbltenant_plan_information` ADD `scheduled_subscription_details` MEDIUMTEXT NULL DEFAULT NULL AFTER `stripe_subscription_id`;

ALTER TABLE `tbltenant_plan_changes_history` CHANGE `plan_purchase_frequency` `plan_purchase_frequency` ENUM('monthly','yearly','1_year','2_year','3_year') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL;
ALTER TABLE `tbltenant_plan_changes_history` ADD `scheduled_subscription_details` MEDIUMTEXT NULL DEFAULT NULL AFTER `stripe_subscription_id`;

-- checkout.session.completed - Webhook Event

INSERT INTO tblonboarding_steps_static (`id`, `code_name`, `name`, `description`, `skip_text`, `icon`, `order`, `parent`, `percentage`, `button_text`) VALUES (NULL, 'grandfather_campaign', 'Grandfather Me In Please!', 'Our Plans & Pricing is changing. You can lock in our current pricing/plans for LIFE & Save An Additional 30%!', 'No Thanks. I\'ll pick a new plan on Jan 14th', 'configure_payment_methods.png', '1', NULL, '0.00', 'Grand Father Me In Now!');

INSERT INTO tbltenant_onboarding_steps (tenant_id, onboarding_steps_static_id, STATUS, added_on, updated_on)
SELECT id, 23, 0, UTC_TIMESTAMP(), UTC_TIMESTAMP() FROM tbltenants;

UPDATE tblonboarding_steps_static SET description = 'No Thanks. I\'ll pick a new plan on Jan 14th', 'configure_payment_methods.png' WHERE code_name = 'grandfather_campaign';