Index: openacs-4/packages/imsld/sql/postgresql/imsld-production-delivery-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/imsld-production-delivery-create.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/imsld/sql/postgresql/imsld-production-delivery-create.sql	20 Jun 2006 19:20:38 -0000	1.3
+++ openacs-4/packages/imsld/sql/postgresql/imsld-production-delivery-create.sql	22 Jun 2006 10:56:53 -0000	1.4
@@ -8,17 +8,22 @@
 --
 
 create table imsld_runs (
-    run_id      integer
-                constraint imsld_run_fk
-                references acs_objects
-                on delete cascade
-                constraint imsld_run_pk
-                primary key,
-    imsld_id    integer
-                constraint imsld_run_imsld_id_fk
-                references imsld_imslds
-                not null,
-    status      varchar(15)
+    run_id          integer
+                    constraint imsld_run_fk
+                    references acs_objects
+                    on delete cascade
+                    constraint imsld_run_pk
+                    primary key,
+    imsld_id        integer
+                    constraint imsld_run_imsld_id_fk
+                    references imsld_imslds
+                    not null,
+    status          varchar(15),
+    creation_date   timestamptz
+                    not null,
+    status_date     timestamptz
+                    default current_timestamp
+                    not null
 );
 
 create index imsld_run_imsld_idx on imsld_runs(imsld_id);