Index: openacs-4/packages/download/sql/postgresql/download-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/postgresql/download-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/download/sql/postgresql/download-create.sql	10 May 2001 20:32:55 -0000	1.1
+++ openacs-4/packages/download/sql/postgresql/download-create.sql	14 May 2001 20:31:08 -0000	1.2
@@ -68,6 +68,8 @@
 -- Each download module will support certain archive types, we need to indicate
 -- what those types are.
 create sequence download_archive_type_seq;
+create view download_archive_type_sequence as 
+	   select nextval('download_archive_type_seq') as nextval;
 create table download_archive_types (
     archive_type_id integer
                     constraint download_archive_types_pk 
@@ -85,6 +87,8 @@
 ';
 
 create sequence download_reasons_seq;
+create view download_reasons_sequence as 
+	   select nextval('download_reasons_seq') as nextval;
 create table download_reasons (
     download_reason_id integer
                        constraint download_archive_reasons_pk 
@@ -140,7 +144,9 @@
 );
 
 --When a piece of metadata has a fixed set of responses
-create sequence download_md_choice_id_sequence start 1;
+create sequence download_md_choice_id_seq start 1;
+create view download_md_choice_id_sequence as 
+	   select nextval('download_md_choice_id_seq') as nextval;
 
 create table download_metadata_choices (
 	choice_id	integer 
@@ -253,6 +259,8 @@
 
 -- We want to collect statistics on downloads.
 create sequence download_downloads_seq;
+create view download_downloads_sequence as 
+	   select nextval('download_downloads_seq') as nextval;
 create table download_downloads (
     download_id   integer 
                   constraint download_downloads_id_pk