Index: openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql	5 Jun 2008 17:40:03 -0000	1.9
+++ openacs-4/packages/imsld/sql/postgresql/imsld-level-a-create.sql	4 Jul 2008 15:31:27 -0000	1.10
@@ -638,6 +638,7 @@
                                 constraint imsld_compa_pk   
                                 primary key, 
     time_in_seconds             integer,
+    time_string	 		varchar(30),
     user_choice_p               char(1) 
                                 check (user_choice_p in ('t','f')),
     when_last_act_completed_p   char(1)   
@@ -750,13 +751,9 @@
 create table imsld_scheduled_time_limits (
     activity_id	integer
                 constraint imsld_sche_tl_act_id_fk
-            	references cr_revisions
-                constraint imsld_sche_tl_act_id_pk
-		primary key,
-    time	integer,
-    due_date	date
+            	references cr_revisions,
+    time	integer
 );
 
 comment on table imsld_scheduled_time_limits is '
 This table stores the schedule time of time_lmit for the different structures.';
-
Index: openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-1.2d-1.3d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-1.2d-1.3d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-1.2d-1.3d.sql	4 Jul 2008 15:31:27 -0000	1.1
@@ -0,0 +1,22 @@
+-- 
+-- 
+-- 
+-- @author Derick Leony (derick@inv.it.uc3m.es)
+-- @creation-date 2008-05-27
+-- @arch-tag: d0c4be23-0d6b-401b-86cb-05cffab500e4
+-- @cvs-id $Id: upgrade-1.2d-1.3d.sql,v 1.1 2008/07/04 15:31:27 derickl Exp $
+--
+
+create table imsld_scheduled_time_limits (
+    activity_id	integer
+                constraint imsld_sche_tl_act_id_fk
+            	references cr_revisions
+                constraint imsld_sche_tl_act_id_pk
+		primary key,
+    time	integer,
+    due_date	date
+);
+
+comment on table imsld_scheduled_time_limits is '
+This table stores the schedule time of time_lmit for the different structures.';
+
Index: openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-1.3d-1.4d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-1.3d-1.4d.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/imsld/sql/postgresql/upgrade/upgrade-1.3d-1.4d.sql	4 Jul 2008 15:31:27 -0000	1.1
@@ -0,0 +1,15 @@
+-- 
+-- 
+-- 
+-- @author Derick Leony (derick@inv.it.uc3m.es)
+-- @creation-date 2008-06-10
+-- @arch-tag: 822367a3-8d73-4ea7-b1ff-763d1f47903a
+-- @cvs-id $Id: upgrade-1.3d-1.4d.sql,v 1.1 2008/07/04 15:31:27 derickl Exp $
+--
+
+alter table imsld_complete_acts add time_string varchar(30);
+
+alter table imsld_scheduled_time_limits drop column due_date;
+alter table imsld_scheduled_time_limits drop constraint imsld_sche_tl_act_id_pk;
+alter table imsld_scheduled_time_limits drop constraint imsld_sche_tl_act_id_fk;
+alter table imsld_scheduled_time_limits add constraint imsld_sche_tl_act_id_fk foreign key (activity_id) references cr_items;