/[BackupPC]/trunk/sql/02d_archive.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/sql/02d_archive.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 179 by dpavlin, Tue Oct 11 19:16:51 2005 UTC revision 180 by dpavlin, Tue Oct 11 19:31:51 2005 UTC
# Line 7  create table archive ( Line 7  create table archive (
7          date            timestamp default now(),          date            timestamp default now(),
8          primary key(id)          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    );
Legend:
Removed from v.179  
changed lines
  Added in v.180
  ViewVC Help
Powered by ViewVC 1.1.26