/[BackupPC]/trunk/sql/workflow_schema.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/workflow_schema.sql

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

revision 120 by iklaric, Thu Sep 15 13:54:28 2005 UTC revision 121 by iklaric, Thu Sep 15 13:54:29 2005 UTC
# Line 1  Line 1 
1    alter table backups
2            add column id int;
3    create sequence backupsseq;
4    update backups set id=nextVal('backupsseq');
5    
6  create table archive  create table archive
7  (  (
8          id                      int not null,          id                      int not null,
# Line 8  create table archive Line 13  create table archive
13          primary key(id)          primary key(id)
14  );  );
15    
16    create sequence archive_id_seq;
17    create sequence dvd_nr;
18    
19  create table archive_backup  create table archive_backup
20  (  (
21          archive_id      int not null,          archive_id      int not null,
Legend:
Removed from v.120  
changed lines
  Added in v.121
  ViewVC Help
Powered by ViewVC 1.1.26