trunk/sql/07_backup_parts.sql

drop table backup_parts;

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)
);

-- ensure that backup part has unique numbers
create unique index backup_part_nr on backup_parts(backup_id,part_nr);

1	dpavlin	235	drop table backup_parts;
2
3			create table backup_parts (
4			id serial,
5			backup_id int references backups(id),
6			part_nr int not null check (part_nr > 0),
7			tar_size bigint not null check (tar_size > 0),
8			size bigint not null check (size > 0),
9			md5 text not null,
10			items int not null check (items > 0),
11			date timestamp default now(),
12			primary key(id)
13			);
14
15			-- ensure that backup part has unique numbers
16			create unique index backup_part_nr on backup_parts(backup_id,part_nr);
17