X-Git-Url: http://git.rot13.org/?p=BackupPC.git;a=blobdiff_plain;f=bin%2FBackupPC_ASA_SearchUpdate;h=929e848dc85e76543c7f8bba20727ae77e37ecb7;hp=0e4df2f37c72719af123ab762288b9abbc42b58a;hb=06017d5181d9c62f8cbd1c6d58d831f54d7d4ad1;hpb=5b9aa3bc5fec586b44508ecaab8db9cb47f1c35b

diff --git a/bin/BackupPC_ASA_SearchUpdate b/bin/BackupPC_ASA_SearchUpdate
index 0e4df2f..929e848 100755
--- a/bin/BackupPC_ASA_SearchUpdate
+++ b/bin/BackupPC_ASA_SearchUpdate
@@ -249,12 +249,6 @@ if ($opt->create) {
 		do_index($index);
 	}
 
-	print " creating sequence: ";
-	foreach my $seq (qw/dvd_nr/) {
-		print "$seq ";
-		$dbh->do( qq{ CREATE SEQUENCE $seq } );
-	}
-
 	print "...\n";
 
 	$dbh->commit;
@@ -674,6 +668,8 @@ create table files (
 	primary key(id)
 );
 
+create sequence dvd_nr;
+
 create table archive (
 	id 		serial,
 	dvd_nr		int not null,
@@ -714,13 +710,40 @@ create table archive_burned (
 --from backups
 --join shares on backups.shareid=shares.id
 --join hosts on shares.hostid = hosts.id
---left outer join archive_backup on backups.id = archive_backup.backup_id
---left outer join archive on archive_backup.archive_id = archive.id
+--left outer join archive_backup_parts on backups.id = archive_backup_parts.backup_id
+--left outer join archive on archive_backup_parts.archive_id = archive.id
 --where backups.parts > 0 and size > 0
 --order by backups.date
 --;
 
 
+-- used by BackupPC_ASA_BurnArchiveMedia
+CREATE VIEW archive_backup_parts AS
+SELECT
+	backup_parts.backup_id,
+	archive_id,
+	dvd_nr,
+	backup_part_id,
+	hosts.name as host,
+	shares.name as share,
+	backups.num as num,
+	backups.date as date,
+	backup_parts.part_nr as part_nr,
+	backups.parts as parts,
+	backup_parts.size as size,
+	backup_parts.md5 as md5,
+	backup_parts.items,
+	backup_parts.filename
+FROM backup_parts
+JOIN archive_parts ON backup_parts.id = backup_part_id
+JOIN archive       ON archive_id = archive.id
+JOIN backups       ON backup_id = backups.id
+JOIN hosts         ON hostid = hosts.id
+JOIN shares        ON shareid = shares.id
+ORDER BY backup_id, part_nr
+;
+
+
 create or replace function backup_parts_check() returns trigger as '
 declare
 	b_parts	integer;