Index: openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql,v
diff -u -N -r1.29.2.3 -r1.29.2.4
--- openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql	2 Nov 2006 07:17:11 -0000	1.29.2.3
+++ openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql	2 Nov 2006 10:44:12 -0000	1.29.2.4
@@ -206,21 +206,21 @@
 comment on table sim_cases is 'The object behind a simulation case.';
 
 create table sim_messages_trash (
-  message_id            integer         constraint sim_trash_id_nn
+  message_id            integer         constraint sim_messages_trash _id_nn
                                         not null
-                                        constraint sim_trash_id_fk
+                                        constraint sim_messages_trash _id_fk
                                         references sim_messages,
-  role_id               integer         constraint sim_trash_role_nn
+  role_id               integer         constraint sim_messages_trash _role_nn
                                         not null,
-  case_id               integer         constraint sim_trash_case_nn
+  case_id               integer         constraint sim_messages_trash _case_nn
                                         not null,
   PRIMARY KEY (message_id, role_id, case_id)
 );
 
 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
+  object_id             integer         constraint sim_pt_id_nn
                                         not null
                                         constraint sim_pt_object_id_fk
                                         references acs_objects ON DELETE CASCADE,