Index: openacs-4/packages/assessment/sql/postgresql/assessment-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-create.sql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/assessment/sql/postgresql/assessment-create.sql	20 Jul 2004 18:11:15 -0000	1.10
+++ openacs-4/packages/assessment/sql/postgresql/assessment-create.sql	5 Aug 2004 11:11:34 -0000	1.11
@@ -5,6 +5,6 @@
 -- @creation-date 2004-07-20
 --
 
-\i assessment-item-create.sql
 \i assessment-item-type-create.sql
+\i assessment-item-create.sql
 \i assessment-section-create.sql
Index: openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql	5 Aug 2004 10:33:43 -0000	1.6
+++ openacs-4/packages/assessment/sql/postgresql/assessment-item-create.sql	5 Aug 2004 11:11:34 -0000	1.7
@@ -61,6 +61,13 @@
 			check (percent_score <= 100)	
 );
 
+create table as_messages (
+	message_id	integer
+			constraint as_messages_message_id_pk
+			primary key,
+	message		varchar(500)
+);
+
 create table as_item_help_map (
 	as_item_id		integer
 		constraint as_item_help_map_as_item_id_fk
@@ -70,8 +77,3 @@
 		references as_messages (message_id),
 	sort_order	integer
 );
-
-create table as_messages (
-	message_id	integer,
-	message		varchar(500)
-);
Index: openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql	5 Aug 2004 10:33:43 -0000	1.2
+++ openacs-4/packages/assessment/sql/postgresql/assessment-section-create.sql	5 Aug 2004 11:11:34 -0000	1.3
@@ -46,7 +46,7 @@
 	instructions	text,
 	enabled_p	char(1) default 'f'
 			constraint as_sections_enable_p_ck
-			check (enable_p in ('t','f')), 
+			check (enabled_p in ('t','f')), 
 	-- Maybe this isnt really useful
 	required_p	char(1) default 't'
 			constraint as_sections_required_p_ck