X-Git-Url: https://git.distorted.org.uk/~mdw/rsync-backup/blobdiff_plain/1c9c923af8ab55f91a9875d135e7189395302334..3c6aedd9800e02f0cceb0cf4fff6a0b782b2416e:/update-bkp-index.in

diff --git a/update-bkp-index.in b/update-bkp-index.in
index 23b64bd..4aa799b 100644
--- a/update-bkp-index.in
+++ b/update-bkp-index.in
@@ -52,7 +52,8 @@ CREATE TABLE idx (
 	fs TEXT NOT NULL,
 	date TEXT NOT NULL,
 	vol TEXT NOT NULL,
-	PRIMARY KEY (host, fs, date));
+	PRIMARY KEY (host, fs, vol, date));
+CREATE INDEX idx_byhostfsdate ON idx (host, fs, date);
 CREATE INDEX idx_byvol ON idx (vol);
 EOF