pinakes/migrations/sqlite/V5__integrity_and_saved_searches.sql

-- Integrity tracking columns
ALTER TABLE media_items ADD COLUMN last_verified_at TEXT;
ALTER TABLE media_items ADD COLUMN integrity_status TEXT DEFAULT 'unverified';

-- Saved searches
CREATE TABLE IF NOT EXISTS saved_searches (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    query TEXT NOT NULL,
    sort_order TEXT,
    created_at TEXT NOT NULL
);