From 5a232b1d42e518ba4c9db92863830a031b156552 Mon Sep 17 00:00:00 2001
From: dpavlin <dpavlin@8392b6e1-25fa-0310-8288-cc32f8e212ea>
Date: Tue, 31 Jan 2006 22:11:58 +0000
Subject: [PATCH]  r9174@llin:  dpavlin | 2006-01-31 23:09:48 +0100  make
 backup_parts_backup_id_part_nr unique

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@330 8392b6e1-25fa-0310-8288-cc32f8e212ea
---
 bin/BackupPC_updatedb               | 2 +-
 sql/10_fix_backup_parts_part_nr.sql | 4 ++++
 2 files changed, 5 insertions(+), 1 deletion(-)
 create mode 100644 sql/10_fix_backup_parts_part_nr.sql

diff --git a/bin/BackupPC_updatedb b/bin/BackupPC_updatedb
index 3657d28..6f778ca 100755
--- a/bin/BackupPC_updatedb
+++ b/bin/BackupPC_updatedb
@@ -368,7 +368,7 @@ if ($opt{c}) {
 		files:size
 		archive:dvd_nr
 		archive_burned:archive_id
-		backup_parts:backup_id,part_nr
+		backup_parts:backup_id,part_nr:unique
 	)) {
 		do_index($index);
 	}
diff --git a/sql/10_fix_backup_parts_part_nr.sql b/sql/10_fix_backup_parts_part_nr.sql
new file mode 100644
index 0000000..56bc999
--- /dev/null
+++ b/sql/10_fix_backup_parts_part_nr.sql
@@ -0,0 +1,4 @@
+-- fix index on backup_parts/part_nr
+
+drop index backup_parts_backup_id_part_nr ;
+create unique index backup_parts_backup_id_part_nr on backup_parts(backup_id,part_nr) ;
-- 
2.20.1