--- trunk/bin/BackupPC_updatedb	2005/11/08 20:24:45	234
+++ trunk/bin/BackupPC_updatedb	2005/11/10 15:07:10	235
@@ -350,6 +350,17 @@
 			iso_size bigint default -1
 		);
 
+		create table backup_parts (
+			id serial,
+			backup_id int references backups(id),
+			part_nr int not null check (part_nr > 0),
+			tar_size bigint not null check (tar_size > 0),
+			size bigint not null check (size > 0),
+			md5 text not null,
+			items int not null check (items > 0),
+			date timestamp default now(),
+			primary key(id)
+		);
 	});
 
 	print "creating indexes: ";
@@ -368,6 +379,7 @@
 		files:size
 		archive:dvd_nr
 		archive_burned:archive_id
+		backup_parts:backup_id,part_nr
 	)) {
 		do_index($index);
 	}