text: -- Drop table data for the workflow package, part of the OpenACS system.
  --
  -- @author Lars Pind (lars@collaboraid.biz)
  -- @author Peter Marklund (peter@collaboraid.biz)
  -- @creation-date 9 Januar 2003
  --
  -- This is free software distributed under the terms of the GNU Public
  -- License.  Full text of the license is available from the GNU Project:
  -- http://www.fsf.org/copyleft/gpl.html
  
  -- Delete workflow data first
  create function inline_0 ()
  returns integer as '
  declare
          row     record;
  begin
          for row in select workflow_id from workflows
          loop
                  perform workflow__delete(row.workflow_id);
          end loop;
  
          return 1;
  end;' language 'plpgsql';
  select inline_0 ();
  drop function inline_0();
  
  -- Drop the workflow object type
  create function inline_0 ()
  returns integer as '
  begin
          perform acs_object_type__drop_type(''workflow_lite'', ''t'');
  
          return 1;
  end;' language 'plpgsql';
  select inline_0 ();
  drop function inline_0();
  
  -- Drop all tables
  drop view wf_case_assigned_user_actions;
  drop view wf_case_assigned_party_actions;
  drop view workflow_case_assigned_actions;
  drop table workflow_case_fsm;
  drop view workflow_case_role_user_map;
  drop view workflow_user_deputy_map;
  drop table workflow_deputies;
  drop table workflow_case_role_party_map;
  drop table workflow_case_log_data;
  drop table workflow_case_log;
  
  select content_type__drop_type (
    'workflow_case_log_entry',         -- content_type
    't',                               -- drop_children_p
    't'                                -- drop_table_p
  );
  
  drop table workflow_case_action_assignees;
  drop table workflow_case_enabled_actions;
  drop table workflow_cases;
  drop table workflow_case_parent_action;
  drop table workflow_fsm_action_en_in_st;
  drop table workflow_fsm_actions;
  drop table workflow_initial_action;
  drop table workflow_fsm_states;
  drop table workflow_action_child_role_map;
  drop table workflow_action_callbacks;
  drop table workflow_action_privileges;
  drop table workflow_action_allowed_roles;
  drop table workflow_actions;
  drop table workflow_role_callbacks;
  drop table workflow_role_allowed_parties;
  drop table workflow_role_default_parties;
  drop table workflow_roles;
  drop table workflow_callbacks;
  drop table workflows;
  
  -- Drop sequences
  drop sequence workflow_roles_seq;
  drop sequence workflow_actions_seq;
  drop sequence workflow_fsm_states_seq;
  drop sequence workflow_cases_seq;
  