Index: openacs-4/packages/simulation/sql/postgresql/simulation-content-types-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/simulation-content-types-create.sql,v diff -u -N -r1.23.2.1 -r1.23.2.2 --- openacs-4/packages/simulation/sql/postgresql/simulation-content-types-create.sql 31 Oct 2006 10:13:02 -0000 1.23.2.1 +++ openacs-4/packages/simulation/sql/postgresql/simulation-content-types-create.sql 4 Dec 2006 14:18:42 -0000 1.23.2.2 @@ -325,3 +325,18 @@ 10 -- max_n ); + +create table sim_messages_trash ( + message_id integer constraint sim_messages_trash_id_nn + not null + constraint sim_messages_trash_id_fk + references sim_messages, + role_id integer constraint sim_messages_trash_role_nn + not null, + 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.'; + 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.5 -r1.29.2.6 --- openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql 4 Dec 2006 11:37:39 -0000 1.29.2.5 +++ openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql 4 Dec 2006 14:18:42 -0000 1.29.2.6 @@ -205,20 +205,6 @@ comment on table sim_cases is 'The object behind a simulation case.'; -create table sim_messages_trash ( - message_id integer constraint sim_messages_trash_id_nn - not null - constraint sim_messages_trash_id_fk - references sim_messages, - role_id integer constraint sim_messages_trash_role_nn - not null, - 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_pt_id_nn not null