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.26 -r1.27
--- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	11 Mar 2004 12:13:41 -0000	1.26
+++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	20 Apr 2004 21:12:22 -0000	1.27
@@ -15,20 +15,28 @@
                                         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,
-    enroll_end            timestamptz,
+    enroll_start                        timestamptz,
+    enroll_end                          timestamptz,
     constraint sim_simulations_enroll_end_after_start_end_ck
       check (enroll_end >= enroll_start),
-    case_start            timestamptz,
-    case_end              timestamptz,
-    send_start_note_date  timestamptz,
+    case_start                          timestamptz,
+    case_end                            timestamptz,
+    send_start_note_date                timestamptz,
     constraint sim_simulations_case_end_after_start_ck
       check (case_end >= case_start),
-    show_contacts_p       boolean default 't'
-      constraint sim_show_contacts_p_ck
-        check(show_contacts_p in ('t','f'))
-      constraint sim_show_contacts_p_nn
-        not null
+    show_contacts_p                     boolean default 't'
+    constraint sim_show_contacts_p_ck
+      check(show_contacts_p in ('t','f'))
+    constraint sim_show_contacts_p_nn
+      not null,
+    show_states_p                       boolean default 't'
+    constraint sim_show_states_p_ck
+      check(show_states_p in ('t','f'))
+    constraint sim_show_states_p_nn
+      not null,
+    stylesheet                          integer
+                                        constraint sim_simulations_ss_fk
+                                        references cr_items(item_id)                                        
 );
 
 select acs_object_type__create_type (
@@ -133,7 +141,10 @@
                                         references parties
                                         on delete cascade,
     type                varchar(20)     constraint sim_party_sim_map_type_ck
-                                        check (type in ('enrolled', 'invited', 'auto_enroll')),    
+                                        check (type in ('enrolled', 'invited', 'auto_enroll')),
+    multiple_cases_p    boolean         constraint sim_party_sim_map_mcp_nn
+                                        not null
+                                        default 'f',
     constraint sim_party_sim_map_pk
     primary key (simulation_id, party_id, type)
 );
