Files
app__cliphoard/migrations/002_unique_content.sql

10 lines
208 B
SQL

DELETE FROM entries
WHERE id NOT IN (
SELECT MAX(id)
FROM entries
GROUP BY content_hash, content
);
CREATE UNIQUE INDEX IF NOT EXISTS entries_content_dedup
ON entries(content_hash, content);