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.11 -r1.12
--- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	15 Dec 2003 15:28:20 -0000	1.11
+++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	16 Dec 2003 09:15:54 -0000	1.12
@@ -12,7 +12,7 @@
     sim_type              varchar(20)   constraint sim_simulations_type_ck
                                           check (sim_type in ('dev_template','ready_template','dev_sim','casting_sim','live_sim')),
     enroll_type           varchar(20)   constraint sim_simulations_enroll_type_ck
-                                        check (enroll_type in ('invite','open')),
+                                        check (enroll_type in ('closed','open')),
     casting_type          varchar(20)   constraint sim_simulations_casting_type_ck
                                         check (casting_type in ('auto','group','open')),
     enroll_start          timestamptz,
@@ -90,6 +90,8 @@
     party_id            integer         constraint sim_party_sim_map_party_fk
                                         references parties
                                         on delete cascade,
+    type                varchar(20)     constraint sim_party_sim_map_type_ck
+                                        (check type in ('enrolled', 'invited', 'auto-enroll')),    
     constraint sim_party_sim_map_pk
     primary key (simulation_id, party_id)
 );
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.11 -r1.12
--- openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql	15 Dec 2003 15:28:20 -0000	1.11
+++ openacs-4/packages/simulation/sql/postgresql/simulation-tables-create.sql	16 Dec 2003 09:15:54 -0000	1.12
@@ -12,7 +12,7 @@
     sim_type              varchar(20)   constraint sim_simulations_type_ck
                                           check (sim_type in ('dev_template','ready_template','dev_sim','casting_sim','live_sim')),
     enroll_type           varchar(20)   constraint sim_simulations_enroll_type_ck
-                                        check (enroll_type in ('invite','open')),
+                                        check (enroll_type in ('closed','open')),
     casting_type          varchar(20)   constraint sim_simulations_casting_type_ck
                                         check (casting_type in ('auto','group','open')),
     enroll_start          timestamptz,
@@ -90,6 +90,8 @@
     party_id            integer         constraint sim_party_sim_map_party_fk
                                         references parties
                                         on delete cascade,
+    type                varchar(20)     constraint sim_party_sim_map_type_ck
+                                        (check type in ('enrolled', 'invited', 'auto-enroll')),    
     constraint sim_party_sim_map_pk
     primary key (simulation_id, party_id)
 );