BEGIN; ALTER TABLE users ADD COLUMN phone VARCHAR(20); UPDATE users SET phone = '000-000-0000' WHERE phone IS NULL; ALTER TABLE users ALTER COLUMN phone SET NOT NULL; CREATE INDEX idx_users_phone ON users(phone); COMMIT;