duplicati/Duplicati/Library/Main/Database/Database schema/14. Create Index on DeletedBlock.sql

3 lines
No EOL
203 B
SQL

CREATE INDEX "DeletedBlockHashSize" ON "DeletedBlock" ("Hash", "Size");
CREATE UNIQUE INDEX "DeletedBlockHashVolumeID" ON "DeletedBlock" ("Hash", "Size", "VolumeID");
UPDATE "Version" SET "Version" = 14;