Release 1.1.2.

[rsync-backup] / update-bkp-index.in

diff --git a/update-bkp-index.in b/update-bkp-index.in
index 23b64bd56a6c4b9c8b5835147360f5d7a37b0360..4aa799b90584a24c3ead1ab96442827f1a85b6a1 100644 (file)
--- 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