-- -- Keeps track of actions performed on objects, e.g. banning a user, -- starting or finishing a workflow task, etc. -- CREATE TABLE journal_entries ( journal_id integer PRIMARY KEY NOT NULL, object_id integer, action varchar(100), action_pretty text(-5), msg text(-5), CONSTRAINT journal_entries_journal_id_fk REFERENCES acs_objects (), CONSTRAINT journal_entries_object_fk REFERENCES acs_objects (), CONSTRAINT journal_entries_pk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT journal_entries_pk REFERENCES acs_objects (), CONSTRAINT journal_entries_journal_id_fk REFERENCES acs_objects (), CONSTRAINT journal_entries_object_fk REFERENCES acs_objects () ); CREATE INDEX journal_entries_object_idx ON journal_entries (object_id); CREATE TRIGGER RI_ConstraintTrigger_c_342539 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342540 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342544 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342545 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343192 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343193 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343532 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343533 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343537 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343538 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343542 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343543 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343552 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343553 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to journal_entries: --wf_attribute_value_audit(journal_entries_journal_id_fk) --wf_attribute_value_audit(journal_entries_object_fk) --wf_attribute_value_audit(journal_entries_pk) --wf_tokens(journal_entries_journal_id_fk) --wf_tokens(journal_entries_object_fk) --wf_tokens(journal_entries_pk) -- Table size: 0 bytes -- Table rows: 0
Begin main content
