Index: openacs-4/packages/ams/sql/postgresql/ams-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/ams-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ams/sql/postgresql/ams-create.sql	22 Oct 2004 01:16:15 -0000	1.2
+++ openacs-4/packages/ams/sql/postgresql/ams-create.sql	27 Oct 2004 02:04:18 -0000	1.3
@@ -160,7 +160,7 @@
 --------------------------------------------------------------------
 
 
-create sequence ams_options_id_seq;
+create sequence ams_options_seq;
 create table ams_options (
         option_id               integer
                                 constraint ams_options_option_id_nn not null
@@ -170,7 +170,8 @@
                                 constraint ams_options_ams_attribute_id_nn references ams_attributes (ams_attribute_id),
         option                  varchar(200)
                                 constraint ams_options_option_nn not null,
-        sort_order              integer,
+        sort_order              integer
+                                constraint ams_options_sort_order not null,
         unique (ams_attribute_id,sort_order)
 );