if BackupPC_burnArchiveCLI complains about consistency error in backup_parts,

[BackupPC.git] / sql / 02d_archive.sql

diff --git a/sql/02d_archive.sql b/sql/02d_archive.sql
index 50656e9..b3c1696 100644 (file)
--- a/sql/02d_archive.sql
+++ b/sql/02d_archive.sql
@@ -7,3 +7,10 @@ create table archive (
        date            timestamp default now(),
        primary key(id)
 );
+
+create table archive_backup
+(
+       archive_id      int not null references archive(id) on delete cascade,
+       backup_id       int not null references backups(id),
+       primary key(archive_id, backup_id)
+);