update-bkp-index.in: The tuple (host, fs, date) is not unique.

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

diff --git a/update-bkp-index.in b/update-bkp-index.in
index 23b64bd..4aa799b 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