7 lines
286 B
SQL
7 lines
286 B
SQL
CREATE INDEX IF NOT EXISTS webdav_retention_scan_idx
|
|
ON webdav_configs(manifest_retention_expires_at, retention_state)
|
|
WHERE manifest_retention_expires_at IS NOT NULL;
|
|
|
|
CREATE INDEX IF NOT EXISTS webdav_retention_job_dedupe_idx
|
|
ON webdav_sync_jobs(user_id, intent, path, status);
|