reset sequence

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@139 8392b6e1-25fa-0310-8288-cc32f8e212ea

diff --git a/sql/workflow_schema.sql b/sql/workflow_schema.sql
index 26cd3db..8e6aae8 100644 (file)
--- a/sql/workflow_schema.sql
+++ b/sql/workflow_schema.sql
@@ -1,6 +1,7 @@
 alter table backups 
        add column id int;
 create sequence backupsseq;
+select setval('backupsseq', 1, false);
 update backups set id=nextVal('backupsseq');
 
 create table archive