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) );