-- Add profile picture columns to users table
ALTER TABLE users
ADD COLUMN profile_picture VARCHAR(255) NULL,
ADD COLUMN profile_updated_at DATETIME NULL,
ADD INDEX idx_profile (profile_picture);

-- Create uploads directory structure
-- Note: This needs to be done manually or through PHP
-- mkdir -p uploads/profile_pictures
-- chmod 755 uploads/profile_pictures
