br-office-suite/database/migrations/015_document_item_deleted_at_backfill.sql
2026-05-10 10:46:05 +02:00

6 lines
177 B
SQL

ALTER TABLE IF EXISTS document_item
ADD COLUMN IF NOT EXISTS deleted_at TIMESTAMPTZ;
CREATE INDEX IF NOT EXISTS idx_document_item_deleted_at
ON document_item (deleted_at);