-- (Reverted) We no longer track processed/updated_at on playlists

-- Fix ONLY user_id column type from bigint to varchar  
-- (company_id should stay as bigint)
USE BigPond;

-- Fix playlists table
ALTER TABLE playlists 
MODIFY COLUMN user_id VARCHAR(255);

-- Fix direct_integration_uploads table
ALTER TABLE direct_integration_uploads 
MODIFY COLUMN user_id VARCHAR(255);

-- Verify the changes
SELECT 'playlists table:' as table_name;
DESCRIBE playlists;

SELECT 'direct_integration_uploads table:' as table_name;  
DESCRIBE direct_integration_uploads;
