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.18 -r1.19
--- openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	19 Dec 2003 09:24:27 -0000	1.18
+++ openacs-4/contrib/packages/simulation/sql/postgresql/simulation-tables-create.sql	19 Dec 2003 10:23:11 -0000	1.19
@@ -163,18 +163,20 @@
     null,                                   -- package_name
     'f',                                    -- abstract_p
     null,                                   -- type_extension_table
-    'acs_object__name'                      -- name_method
+    'sim_case__name'                        -- name_method
 );
       
 create table sim_cases (
-    sim_case_id         integer         constraint sim_case_fk
+    sim_case_id         integer         constraint sim_case_sci_fk
                                         references acs_objects
+                                        on delete cascade
                                         constraint sim_case_pk
                                         primary key,
-    workflow_id         integer         constraint sim_case_workflow_fk
-                                        references workflows,
-    sort_order          integer,
-    constraint sim_case_workflow_sort_order_un unique (workflow_id, sort_order)
+    label               varchar(200),
+    package_id          integer         constraint sim_case_pid_fk
+                                        references apm_packages(package_id)
+                                        constraint sim_case_pid_nn
+                                        not null
 );
 
 comment on table sim_cases is 'The object behind a simulation case.';