-- Add avatar_url column to users table
ALTER TABLE users ADD COLUMN IF NOT EXISTS avatar_url VARCHAR(255);

-- Create index for faster lookups
CREATE INDEX IF NOT EXISTS idx_users_avatar ON users(avatar_url);

COMMENT ON COLUMN users.avatar_url IS 'URL or path to user avatar image';