r124@klaxLaptop: klax | 2005-09-15 15:46:19 +0200

[BackupPC.git] / sql / workflow_schema.sql

diff --git a/sql/workflow_schema.sql b/sql/workflow_schema.sql
index 8ed7886..26cd3db 100644 (file)
--- a/sql/workflow_schema.sql
+++ b/sql/workflow_schema.sql
@@ -1,3 +1,8 @@
+alter table backups 
+       add column id int;
+create sequence backupsseq;
+update backups set id=nextVal('backupsseq');
+
 create table archive
 (
        id                      int not null,
@@ -8,6 +13,9 @@ create table archive
        primary key(id)
 );
 
+create sequence archive_id_seq;
+create sequence dvd_nr;
+
 create table archive_backup
 (
        archive_id      int not null,