350 |
iso_size bigint default -1 |
iso_size bigint default -1 |
351 |
); |
); |
352 |
|
|
353 |
|
create table backup_parts ( |
354 |
|
id serial, |
355 |
|
backup_id int references backups(id), |
356 |
|
part_nr int not null check (part_nr > 0), |
357 |
|
tar_size bigint not null check (tar_size > 0), |
358 |
|
size bigint not null check (size > 0), |
359 |
|
md5 text not null, |
360 |
|
items int not null check (items > 0), |
361 |
|
date timestamp default now(), |
362 |
|
primary key(id) |
363 |
|
); |
364 |
}); |
}); |
365 |
|
|
366 |
print "creating indexes: "; |
print "creating indexes: "; |
379 |
files:size |
files:size |
380 |
archive:dvd_nr |
archive:dvd_nr |
381 |
archive_burned:archive_id |
archive_burned:archive_id |
382 |
|
backup_parts:backup_id,part_nr |
383 |
)) { |
)) { |
384 |
do_index($index); |
do_index($index); |
385 |
} |
} |