Index: openacs-4/packages/simulation/sql/postgresql/simulation-content-types-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/sql/postgresql/simulation-content-types-create.sql,v
diff -u -N -r1.15 -r1.16
--- openacs-4/packages/simulation/sql/postgresql/simulation-content-types-create.sql	18 Dec 2003 15:19:20 -0000	1.15
+++ openacs-4/packages/simulation/sql/postgresql/simulation-content-types-create.sql	18 Dec 2003 16:12:17 -0000	1.16
@@ -261,7 +261,7 @@
 ----------------------------------------------------------------------
 -- sim_message
 ----------------------------------------------------------------------
--- # TODO: conststrain to_role_id and from_role_id
+-- # TODO: foreign constraints for to_role_id and from_role_id
 
 select content_type__create_type(
     'sim_message',                 -- content_type
@@ -313,3 +313,40 @@
     0,                            -- min_n
     10                            -- max_n
 );
+
+----------------------------------------------------------------------
+-- sim_case
+----------------------------------------------------------------------
+-- # TODO: foreign constraint for workflow_id
+
+select content_type__create_type(
+    'sim_case',                 -- content_type
+    'content_revision',            -- supertype
+    'Sim Case',                 -- pretty_name,
+    'Sim Cases',                -- pretty_plural
+    'sim_cases',                -- table_name
+    'case_id',                  -- id_column
+    null                           -- name_method
+);
+
+select content_type__create_attribute(
+    'sim_case',                    -- content_type
+    'workflow_id',                 -- attribute_name
+    'integer',                     -- datatype
+    'Workflow',                    -- pretty_name
+    'Workflows',                   -- pretty_plural
+    1,                             -- sort_order
+    null,                          -- default_value
+    'integer'                      -- column_spec
+);
+
+select content_type__create_attribute(
+    'sim_case',                    -- content_type
+    'sort_order',                  -- attribute_name
+    'integer',                     -- datatype
+    'Sort order',                  -- pretty_name
+    'Sort orders',                 -- pretty_plural
+    2,                             -- sort_order
+    null,                          -- default_value
+    'integer'                      -- column_spec
+);