trunk/sql/02d_archive.sql

create table archive (
        id              serial,
        dvd_nr          int not null,
        total_size      bigint default -1,
        note            text,
        username        varchar(20) not null,
        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)
);
1	create table archive (
2	id serial,
3	dvd_nr int not null,
4	total_size bigint default -1,
5	note text,
6	username varchar(20) not null,
7	date timestamp default now(),
8	primary key(id)
9	);
10
11	create table archive_backup
12	(
13	archive_id int not null references archive(id) on delete cascade,
14	backup_id int not null references backups(id),
15	primary key(archive_id, backup_id)
16	);