trunk/sql/08_files_fk_backups.sql

create index files_backupnum on files(backupnum) ;

-- cleanup, just in case
delete from files where (shareid,backupnum) not in (select shareid,num from backups) ;

create unique index backups_share_num on backups(shareid,num) ;
alter table files add foreign key (shareid,backupnum) references backups(shareid,num) on delete cascade;

1	create index files_backupnum on files(backupnum) ;
2
3	-- cleanup, just in case
4	delete from files where (shareid,backupnum) not in (select shareid,num from backups) ;
5
6	create unique index backups_share_num on backups(shareid,num) ;
7	alter table files add foreign key (shareid,backupnum) references backups(shareid,num) on delete cascade;
8