store filename in backup_parts
[BackupPC.git] / bin / BackupPC_ASA_SearchUpdate
index 2a93dcd..e691bd8 100755 (executable)
@@ -304,6 +304,7 @@ if ($opt->create) {
                        md5 text not null,
                        items int not null check (items > 0),
                        date timestamp default now(),
+                       filename text not null,
                        primary key(id)
                );
 
@@ -357,8 +358,6 @@ if ($opt->create) {
                $dbh->do( qq{ CREATE SEQUENCE $seq } );
        }
 
-=for later
-
        print " creating triggers ";
        $dbh->do( <<__END_OF_TRIGGER__ );
 
@@ -420,8 +419,6 @@ create trigger do_backup_backup_parts_check
 
 __END_OF_TRIGGER__
 
-=cut
-
        print "...\n";
 
        $dbh->commit;