select pretty_name from acs_object_types
select object_type from acs_object_types
select constraint_name from user_constraints
create table $workflow_cases_table (
case_id integer primary key
constraint $workflow_cases_constraint
references wf_cases on delete cascade
)
insert into wf_places (place_key, workflow_key, place_name, sort_order)
values ('[db_quote $task($transition_key,input_place_key)]', '[db_quote $workflow_key]',
'[db_quote "Ready to $task($transition_key,task_name)"]', [expr $counter+1])
insert into wf_places (place_key, workflow_key, place_name, sort_order)
values ('end', '[db_quote $workflow_key]', 'Process finished', [expr $num_tasks+1])
insert into wf_transitions (transition_key, transition_name, workflow_key, sort_order, trigger_type)
values ('[db_quote $transition_key]', '[db_quote $task($transition_key,task_name)]',
'[db_quote $workflow_key]', [expr $counter+1], 'user')
insert into wf_arcs (workflow_key, transition_key, place_key, direction)
values ('[db_quote $workflow_key]', '[db_quote $transition_key]',
'[db_quote $task($transition_key,input_place_key)]', 'in')
insert into wf_arcs (workflow_key, transition_key, place_key, direction)
values ('[db_quote $workflow_key]', '[db_quote $transition_key]',
'[db_quote $task($transition_key,output_place_key)]', 'out')
insert into wf_arcs (workflow_key, transition_key, place_key, direction, guard_callback, guard_description)
values ('[db_quote $workflow_key]', '[db_quote $transition_key]',
'[db_quote $false_place]', 'out', '#', '[db_quote "Not $task($transition_key,loop_question)"]')
insert into wf_transition_assignment_map (workflow_key, transition_key, assign_transition_key)
values ('[db_quote $workflow_key]', '[db_quote $assigning_transition_key]', '[db_quote $transition_key]')
insert into wf_context_transition_info (context_key, workflow_key, transition_key, estimated_minutes)
values ('default', '[db_quote $workflow_key]', '[db_quote $transition_key]', $task_time)
drop table $workflow_cases_table