Parent Directory | Revision Log
create archive_backup also
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 | ); |
ViewVC Help | |
Powered by ViewVC 1.1.26 |