Index: openacs-4/packages/imsld/sql/postgresql/imsld-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/imsld-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/imsld/sql/postgresql/imsld-create.sql	21 Sep 2005 14:39:55 -0000	1.4
+++ openacs-4/packages/imsld/sql/postgresql/imsld-create.sql	27 Sep 2005 11:05:08 -0000	1.5
@@ -537,7 +537,8 @@
                                 references cr_items,    --imsld_time_limits
     on_completion_id            integer 
                                 constraint imsld_plays_oncomp_fk 
-                                references cr_items     --imsld_on_completion
+                                references cr_items,    --imsld_on_completion
+    sort_order                  integer
 );
 
 create index imsld_plays_meth_id_idx on imsld_plays(method_id);
@@ -566,7 +567,8 @@
     identifier          varchar(100),
     on_completion_id    integer  
                         constraint imsld_acts_oncomp_fk  
-                        references cr_items     --imsld_on_completion
+                        references cr_items,    --imsld_on_completion
+    sort_order          integer
 );
 
 create index imsld_acts_play_id_idx on imsld_acts(play_id);
@@ -603,7 +605,8 @@
                             references cr_items,    --imsld_activity_structures
     environment_id          integer
                             constraint imsld_rp_envid_fk   
-                            references cr_items     --imsld_environments
+                            references cr_items,    --imsld_environments
+    sort_order              integer
 );
 
 create index imsld_rp_act_id_idx on imsld_role_parts(act_id);
@@ -649,4 +652,6 @@
 
 Feedback are items that are mapped to this table with the imsld_feedback_rel.';
 
-\i imsld-cp-create.sql
\ No newline at end of file
+\i imsld-cp-create.sql
+
+\i imsld-status-create.sql
\ No newline at end of file
