Index: openacs-4/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b5-1.1.0b1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/upgrade/Attic/upgrade-1.0.0b5-1.1.0b1.sql,v
diff -u -N -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b5-1.1.0b1.sql	31 Oct 2006 21:10:13 -0000	1.1.2.1
+++ openacs-4/packages/simulation/sql/postgresql/upgrade/upgrade-1.0.0b5-1.1.0b1.sql	2 Nov 2006 07:17:11 -0000	1.1.2.2
@@ -1,4 +1,4 @@
-create table sim_trash (
+create table sim_messages_trash (
   message_id            integer         constraint sim_trash_id_nn
                                         not null
                                         constraint sim_trash_id_fk
@@ -10,4 +10,25 @@
   PRIMARY KEY (message_id, role_id, case_id)
 );
 
-comment on table sim_trash is 'For storing trashed messages per role per case.';
+comment on table sim_messages_trash is 'For storing trashed messages per role per case.';
+
+create table sim_portfolio_trash (
+  object_id             integer         constraint sim_trash_id_nn
+                                        not null
+                                        constraint sim_pt_object_id_fk
+                                        references acs_objects ON DELETE CASCADE,
+  role_id               integer         constraint sim_pt_role_nn
+                                        not null
+                                        constraint sim_pt_role_fk
+                                        REFERENCES workflow_roles ON DELETE CASCADE,
+  case_id               integer         constraint sim_pt_case_nn
+                                        not null
+                                        constraint sim_pt_case_fk
+                                        REFERENCES workflow_cases ON DELETE CASCADE,
+  PRIMARY KEY (object_id, role_id, case_id)
+);
+
+comment on table sim_portfolio_trash is 'For storing trashed portfolio documents per role per case.';
+
+alter table sim_case_role_object_map
+  add column title varchar(200);
\ No newline at end of file