NotAShelf
f5371a30bb
Signed-off-by: NotAShelf <raf@notashelf.dev> Change-Id: Ic186f9bf08683a14562bbe43743c04706a6a6964
11 lines
475 B
SQL
11 lines
475 B
SQL
-- V18: File Management (Rename, Move, Trash)
|
|
-- Adds soft delete support for trash/recycle bin functionality
|
|
|
|
-- Add deleted_at column for soft delete (trash)
|
|
ALTER TABLE media_items ADD COLUMN deleted_at TIMESTAMPTZ;
|
|
|
|
-- Index for efficient trash queries
|
|
CREATE INDEX idx_media_deleted_at ON media_items(deleted_at);
|
|
|
|
-- Partial index for listing non-deleted items (most common query pattern)
|
|
CREATE INDEX idx_media_not_deleted ON media_items(id) WHERE deleted_at IS NULL;
|