-- OPTIONAL ROLLBACK. BACK UP FIRST: this permanently deletes all SaaS subscription,
-- payment, webhook, admin, email, and audit records created after the upgrade.
-- It does not remove existing users/customers/invoices/payments/expenses.
DROP TABLE IF EXISTS email_reminders;
DROP TABLE IF EXISTS email_verification_tokens;
DROP TABLE IF EXISTS password_resets;
DROP TABLE IF EXISTS email_logs;
DROP TABLE IF EXISTS webhook_events;
DROP TABLE IF EXISTS subscription_payments;
DROP TABLE IF EXISTS subscriptions;
DROP TABLE IF EXISTS plans;
DROP TABLE IF EXISTS audit_logs;
DROP TABLE IF EXISTS admin_users;
DROP TABLE IF EXISTS app_settings;
ALTER TABLE users DROP COLUMN email_verified_at, DROP COLUMN account_status;