Parent Directory | Revision Log
cleanup files and add foreign key
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 |
ViewVC Help | |
Powered by ViewVC 1.1.26 |