From: Mark Wooding <mdw@distorted.org.uk>
Date: Mon, 28 Jan 2013 10:44:29 +0000 (+0000)
Subject: update-bkp-index.in: The tuple (host, fs, date) is not unique.
X-Git-Tag: 1.0.0~10
X-Git-Url: https://git.distorted.org.uk/~mdw/rsync-backup/commitdiff_plain/3c6aedd9800e02f0cceb0cf4fff6a0b782b2416e

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 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