Index: openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/sql/postgresql/Attic/simulation-drop.sql,v
diff -u -r1.14 -r1.15
--- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql	1 Dec 2003 15:15:08 -0000	1.14
+++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-drop.sql	16 Dec 2003 15:59:47 -0000	1.15
@@ -5,6 +5,7 @@
 --drop independent tables
 drop table sim_party_sim_map;
 drop table sim_tasks;
+drop table sim_role_group_map;
 drop table sim_roles;
 select acs_object_type__drop_type(
 	   'simulation',
Index: openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/sql/postgresql/Attic/simulation-tables-create.sql,v
diff -u -r1.13 -r1.14
--- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	16 Dec 2003 15:45:42 -0000	1.13
+++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	16 Dec 2003 15:59:48 -0000	1.14
@@ -54,6 +54,20 @@
 
 comment on table sim_roles is 'Each record is a role within a simulation template to be played by one or more users or a computer agent when the template is instantiated into cases.';
   
+create table sim_role_group_map (
+    role_id             integer         constraint sim_role_group_map_ri_fk
+                                        references workflow_roles(role_id)
+                                        on delete cascade,
+    party_id            integer         constraint sim_role_group_map_party_fk
+                                        references parties
+                                        on delete cascade,
+    group_size          integer         default 1,
+    constraint sim_role_group_map_pk
+    primary key(role_id, party_id)
+);
+
+comment on table sim_role_group_map is 'Each record defines a group of users to be cast into a role in groups of group_size';
+
 create table sim_tasks (
     task_id             integer         constraint sim_tasks_fk
                                         references workflow_actions
Index: openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql,v
diff -u -r1.14 -r1.15
--- openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql	1 Dec 2003 15:15:08 -0000	1.14
+++ openacs-4/packages/simulation/sql/postgresql/simulation-drop.sql	16 Dec 2003 15:59:47 -0000	1.15
@@ -5,6 +5,7 @@
 --drop independent tables
 drop table sim_party_sim_map;
 drop table sim_tasks;
+drop table sim_role_group_map;
 drop table sim_roles;
 select acs_object_type__drop_type(
 	   'simulation',
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 -r1.13 -r1.14
--- openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql	16 Dec 2003 15:45:42 -0000	1.13
+++ openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql	16 Dec 2003 15:59:48 -0000	1.14
@@ -54,6 +54,20 @@
 
 comment on table sim_roles is 'Each record is a role within a simulation template to be played by one or more users or a computer agent when the template is instantiated into cases.';
   
+create table sim_role_group_map (
+    role_id             integer         constraint sim_role_group_map_ri_fk
+                                        references workflow_roles(role_id)
+                                        on delete cascade,
+    party_id            integer         constraint sim_role_group_map_party_fk
+                                        references parties
+                                        on delete cascade,
+    group_size          integer         default 1,
+    constraint sim_role_group_map_pk
+    primary key(role_id, party_id)
+);
+
+comment on table sim_role_group_map is 'Each record defines a group of users to be cast into a role in groups of group_size';
+
 create table sim_tasks (
     task_id             integer         constraint sim_tasks_fk
                                         references workflow_actions