CREATE TABLE workflow_actions ( action_id integer PRIMARY KEY NOT NULL, workflow_id integer NOT NULL, sort_order integer NOT NULL, short_name varchar(100) NOT NULL, pretty_name varchar(200) NOT NULL, pretty_past_tense varchar(200), description text(-5), description_mime_type varchar(200), edit_fields varchar(4000), assigned_role integer, always_enabled_p bool DEFAULT false, timeout interval, parent_action_id integer, trigger_type varchar(50) DEFAULT 'user'::character varying, ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT wf_acns_assigned_role_fk REFERENCES workflow_roles (), CONSTRAINT wf_acns_parent_action_fk REFERENCES workflow_roles (), CONSTRAINT wf_acns_pk REFERENCES workflow_roles (), CONSTRAINT wf_acns_trigger_type_ck REFERENCES workflow_roles (), CONSTRAINT wf_acns_workflow_id_fk REFERENCES workflow_roles (), CONSTRAINT wf_actions_pretty_name_un REFERENCES workflow_roles (), CONSTRAINT wf_actions_short_name_un REFERENCES workflow_roles () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_acns_assigned_role_fk REFERENCES workflow_actions (), CONSTRAINT wf_acns_parent_action_fk REFERENCES workflow_actions (), CONSTRAINT wf_acns_pk REFERENCES workflow_actions (), CONSTRAINT wf_acns_trigger_type_ck REFERENCES workflow_actions (), CONSTRAINT wf_acns_workflow_id_fk REFERENCES workflow_actions (), CONSTRAINT wf_actions_pretty_name_un REFERENCES workflow_actions (), CONSTRAINT wf_actions_short_name_un REFERENCES workflow_actions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT wf_actions_short_name_un REFERENCES workflows (), CONSTRAINT wf_acns_assigned_role_fk REFERENCES workflows (), CONSTRAINT wf_acns_parent_action_fk REFERENCES workflows (), CONSTRAINT wf_acns_pk REFERENCES workflows (), CONSTRAINT wf_acns_trigger_type_ck REFERENCES workflows (), CONSTRAINT wf_acns_workflow_id_fk REFERENCES workflows (), CONSTRAINT wf_actions_pretty_name_un REFERENCES workflows () ); CREATE UNIQUE INDEX wf_actions_pretty_name_un ON workflow_actions (workflow_id, parent_action_id, pretty_name); CREATE UNIQUE INDEX wf_actions_short_name_un ON workflow_actions (workflow_id, short_name); CREATE TRIGGER RI_ConstraintTrigger_a_343122 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343123 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343132 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343133 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343142 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343143 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343154 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343155 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343157 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343158 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343159 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343160 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343164 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343165 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343232 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343233 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343262 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343263 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343417 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343418 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343427 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343428 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343437 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343438 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to workflow_actions: --workflow_action_allowed_roles(wf_acns_assigned_role_fk) --workflow_action_allowed_roles(wf_acns_parent_action_fk) --workflow_action_allowed_roles(wf_acns_pk) --workflow_action_allowed_roles(wf_acns_trigger_type_ck) --workflow_action_allowed_roles(wf_acns_workflow_id_fk) --workflow_action_allowed_roles(wf_actions_pretty_name_un) --workflow_action_allowed_roles(wf_actions_short_name_un) --workflow_action_callbacks(wf_acns_assigned_role_fk) --workflow_action_callbacks(wf_acns_parent_action_fk) --workflow_action_callbacks(wf_acns_pk) --workflow_action_callbacks(wf_acns_trigger_type_ck) --workflow_action_callbacks(wf_acns_workflow_id_fk) --workflow_action_callbacks(wf_actions_pretty_name_un) --workflow_action_callbacks(wf_actions_short_name_un) --workflow_action_privileges(wf_acns_assigned_role_fk) --workflow_action_privileges(wf_acns_parent_action_fk) --workflow_action_privileges(wf_acns_pk) --workflow_action_privileges(wf_acns_trigger_type_ck) --workflow_action_privileges(wf_acns_workflow_id_fk) --workflow_action_privileges(wf_actions_pretty_name_un) --workflow_action_privileges(wf_actions_short_name_un) --workflow_actions(wf_acns_assigned_role_fk) --workflow_actions(wf_acns_parent_action_fk) --workflow_actions(wf_acns_pk) --workflow_actions(wf_acns_trigger_type_ck) --workflow_actions(wf_acns_workflow_id_fk) --workflow_actions(wf_actions_pretty_name_un) --workflow_actions(wf_actions_short_name_un) --workflow_case_enabled_actions(wf_acns_assigned_role_fk) --workflow_case_enabled_actions(wf_acns_parent_action_fk) --workflow_case_enabled_actions(wf_acns_pk) --workflow_case_enabled_actions(wf_acns_trigger_type_ck) --workflow_case_enabled_actions(wf_acns_workflow_id_fk) --workflow_case_enabled_actions(wf_actions_pretty_name_un) --workflow_case_enabled_actions(wf_actions_short_name_un) --workflow_case_log(wf_acns_assigned_role_fk) --workflow_case_log(wf_acns_parent_action_fk) --workflow_case_log(wf_acns_pk) --workflow_case_log(wf_acns_trigger_type_ck) --workflow_case_log(wf_acns_workflow_id_fk) --workflow_case_log(wf_actions_pretty_name_un) --workflow_case_log(wf_actions_short_name_un) --workflow_fsm_action_en_in_st(wf_acns_assigned_role_fk) --workflow_fsm_action_en_in_st(wf_acns_parent_action_fk) --workflow_fsm_action_en_in_st(wf_acns_pk) --workflow_fsm_action_en_in_st(wf_acns_trigger_type_ck) --workflow_fsm_action_en_in_st(wf_acns_workflow_id_fk) --workflow_fsm_action_en_in_st(wf_actions_pretty_name_un) --workflow_fsm_action_en_in_st(wf_actions_short_name_un) --workflow_fsm_actions(wf_acns_assigned_role_fk) --workflow_fsm_actions(wf_acns_parent_action_fk) --workflow_fsm_actions(wf_acns_pk) --workflow_fsm_actions(wf_acns_trigger_type_ck) --workflow_fsm_actions(wf_acns_workflow_id_fk) --workflow_fsm_actions(wf_actions_pretty_name_un) --workflow_fsm_actions(wf_actions_short_name_un) --workflow_fsm_states(wf_acns_assigned_role_fk) --workflow_fsm_states(wf_acns_parent_action_fk) --workflow_fsm_states(wf_acns_pk) --workflow_fsm_states(wf_acns_trigger_type_ck) --workflow_fsm_states(wf_acns_workflow_id_fk) --workflow_fsm_states(wf_actions_pretty_name_un) --workflow_fsm_states(wf_actions_short_name_un) -- Table size: 8,192 bytes -- Table rows: 28
Begin main content
