UPDATE `tbloptions_static` SET value = 'Credit Card via Authorize.net (AIM)' WHERE name = 'paymentmethod_authorize_aim_label';
UPDATE `tbloptions` SET value = 'Credit Card via Authorize.net (AIM)' WHERE name = 'paymentmethod_authorize_aim_label';

UPDATE `tbloptions_static` SET value = 'Credit Card via Authorize.net (SIM)' WHERE name = 'paymentmethod_authorize_sim_label';
UPDATE `tbloptions` SET value = 'Credit Card via Authorize.net (SIM)' WHERE name = 'paymentmethod_authorize_sim_label';

UPDATE `tbloptions_static` SET value = 'Credit Card via Stripe Ideal' WHERE name = 'paymentmethod_stripe_ideal_label';
UPDATE `tbloptions` SET value = 'Credit Card via Stripe Ideal' WHERE name = 'paymentmethod_stripe_ideal_label';

UPDATE `tblpayment_modes_static` SET active = 0 WHERE name NOT IN ('Cash', 'Check', 'Money order');
UPDATE `tblpayment_modes` SET active = 0 WHERE name NOT IN ('Cash', 'Check', 'Money order');
ALTER TABLE `tbltenant_plan_changes_history` ADD `added_on` DATETIME NULL DEFAULT NULL AFTER `plan_promotional_off_stripe_coupon`;
CREATE TABLE tbltenant_plan_cancel_history (
    uniquecode VARCHAR(191) NOT NULL,
    tenant_id BIGINT NOT NULL,
    plan_id INT NOT NULL,
    stripe_subscription_id VARCHAR(191) NOT NULL,
    tenant_plan_changes_history_code VARCHAR(191) NOT NULL,
    stripe_response LONGTEXT,
    added_on DATETIME NOT NULL
);