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.4 -r1.29.2.5 --- openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql 2 Nov 2006 10:44:12 -0000 1.29.2.4 +++ openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql 4 Dec 2006 11:37:39 -0000 1.29.2.5 @@ -162,7 +162,7 @@ references workflow_cases on delete cascade, order_n integer, - title varchar(200) + title varchar(200), relation_tag varchar(100), entry_id integer constraint scrom_case_log_fk references workflow_case_log, @@ -206,13 +206,13 @@ 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 + message_id integer constraint sim_messages_trash_id_nn not null - constraint sim_messages_trash _id_fk + constraint sim_messages_trash_id_fk references sim_messages, - role_id integer constraint sim_messages_trash _role_nn + role_id integer constraint sim_messages_trash_role_nn not null, - case_id integer constraint sim_messages_trash _case_nn + case_id integer constraint sim_messages_trash_case_nn not null, PRIMARY KEY (message_id, role_id, case_id) );