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	dpavlin	277	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