S170 Field Naming Fix Report

Date: 2026-04-04 | Standard: Dieu 33 §2.2

Changes

kb_documents_history

• snapshot_at → date_updated (overwritten on UPSERT)
• Added date_created (set once on INSERT, preserved on UPSERT)
• Index idx_kb_history_time auto-renamed to use date_updated

kb_audit_log

• logged_at → date_created (immutable audit entries)
• Index idx_kb_audit_time auto-renamed to use date_created

Functions updated

• fn_kb_snapshot: INSERT sets both date_created + date_updated, ON CONFLICT only updates date_updated
• fn_kb_audit: uses DEFAULT for date_created (no code change needed)
• fn_kb_restore: no timestamp references (unchanged)

View recreated

• v_kb_recent_changes: DROP + CREATE with date_created

Scripts updated

• dot-kb-verify.sh: 3 refs logged_at → date_created
• dot-kb-restore.sh: 2 refs snapshot_at → date_updated

Verification

• UPSERT test: date_created preserved, date_updated changed
• dot-kb-verify: all 7 checks run
• No old column names (snapshot_at/logged_at) remain anywhere