-- Production deployment SQL for rollover enhancements
-- Run this directly in your MySQL database to add the rollover_date column

-- Check if rollover_requests table exists
SELECT 'Checking rollover_requests table...' as status;

-- Add rollover_date column if it doesn't exist
ALTER TABLE rollover_requests 
ADD COLUMN IF NOT EXISTS rollover_date DATE NULL 
COMMENT 'Preferred rollover date';

-- Verify the column was added
SELECT 'rollover_date column added successfully!' as status;

-- Show the table structure to confirm
DESCRIBE rollover_requests;

-- Optional: Create a migration record (if you want to track it)
INSERT IGNORE INTO django_migrations (app, name, applied) 
VALUES ('loans', '0018_add_rollover_date_field', NOW());

SELECT 'Migration record created!' as status;