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	dpavlin	179	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	dpavlin	180
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			);