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

So we must fix the schema, and include the volume name in the primary
key.  This is still early days, so I'm just going to break it.

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