Index: openacs-4/packages/imsld/sql/postgresql/imsld-status-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/Attic/imsld-status-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/imsld/sql/postgresql/imsld-status-create.sql	12 Jan 2006 14:55:25 -0000	1.5
+++ openacs-4/packages/imsld/sql/postgresql/imsld-status-create.sql	13 Jan 2006 14:43:16 -0000	1.6
@@ -12,23 +12,30 @@
                             constraint imsld_stat_imsldid_fk
                             references imsld_imslds
                             not null,
+    play_id                 integer
+                            constraint imsld_stat_pl_fk  
+                            references imsld_plays,
+    act_id                 integer
+                            constraint imsld_stat_act_fk  
+                            references imsld_acts,
     role_part_id            integer
                             constraint imsld_stat_rp_fk  
-                            references imsld_role_parts
-                            not null,
+                            references imsld_role_parts,
     completed_id            integer
                             constraint imsld_stat_aid_fk
-                            references cr_revisions     -- reference to an learning_activity OR support_activity OR a
-                            not null,                   -- ctivity_structure OR environment
+                            references cr_revisions     -- reference to a learning_activity OR support_activity OR
+                            not null,                   -- activity_structure OR environment OR role_part OR act OR play
     user_id                 integer
                             constraint imsld_stat_user_fk  
                             references users
                             not null,
     type                    varchar(20)
-                            check (type in ('learning','support','structure','resource')),
+                            check (type in ('learning','support','structure','act','role-part','play')),
     finished_date           timestamptz
                             default current_timestamp
-                            not null
+                            not null,
+    constraint imsld_status_un
+    unique (completed_id,user_id)
 );
 
 create index imsld_stat_imsld_idx on imsld_status_user(imsld_id);