taxbaik/db/migrations/V011__ExtendInquiryStatus.sql

-- 문의 상태 5단계로 확장 + 처리 메모 컬럼 추가
-- 기존: new, contacted, completed
-- 신규: new(신규), consulting(상담중), contracted(계약완료), rejected(거절), closed(종결)

UPDATE inquiries SET status = 'consulting' WHERE status = 'contacted';
UPDATE inquiries SET status = 'closed'     WHERE status = 'completed';

ALTER TABLE inquiries ADD COLUMN IF NOT EXISTS admin_memo TEXT;
ALTER TABLE inquiries ADD COLUMN IF NOT EXISTS updated_at TIMESTAMPTZ DEFAULT NOW();