-- SQL Schema updates for Stripe Integration

-- Add Stripe related columns to the 'websites' table
ALTER TABLE `websites`
ADD COLUMN `stripe_customer_id` VARCHAR(255) NULL DEFAULT NULL AFTER `subscription_end_date`,
ADD COLUMN `stripe_subscription_id` VARCHAR(255) NULL DEFAULT NULL AFTER `stripe_customer_id`,
ADD COLUMN `stripe_payment_intent_id` VARCHAR(255) NULL DEFAULT NULL AFTER `stripe_subscription_id`;

/*
Instructions:
1. Connect to your MySQL server.
2. Select your database (e.g., USE ada_wizard;).
3. Execute the SQL command above to add the new columns to the 'websites' table.

Verification (optional):
DESCRIBE `websites`;
-- This will show the table structure, including the new columns.
*/
