-- Migration 002: Supabase Auth integration
-- Supabase Auth manages passwords; password_hash is no longer required.

ALTER TABLE users ALTER COLUMN password_hash DROP NOT NULL;
ALTER TABLE users ALTER COLUMN password_hash SET DEFAULT NULL;