-- -- An audit table (populated by a trigger on cr_items.live_revision) -- that is used to keep track of the publication history of an item. -- CREATE TABLE cr_item_publish_audit ( item_id integer, old_revision integer, new_revision integer, old_status varchar(40), new_status varchar(40), publish_date timestamptz NOT NULL, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_item_publish_audit_item_fk REFERENCES cr_items (), CONSTRAINT cr_item_publish_audit_nrev_fk REFERENCES cr_items (), CONSTRAINT cr_item_publish_audit_orev_fk REFERENCES cr_items () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_item_publish_audit_orev_fk REFERENCES cr_revisions (), CONSTRAINT cr_item_publish_audit_nrev_fk REFERENCES cr_revisions (), CONSTRAINT cr_item_publish_audit_item_fk REFERENCES cr_revisions () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_item_publish_audit_orev_fk REFERENCES cr_revisions (), CONSTRAINT cr_item_publish_audit_item_fk REFERENCES cr_revisions (), CONSTRAINT cr_item_publish_audit_nrev_fk REFERENCES cr_revisions () ); CREATE INDEX cr_item_publish_audit_idx ON cr_item_publish_audit (item_id); CREATE INDEX cr_item_publish_audit_nrev_idx ON cr_item_publish_audit (new_revision); CREATE INDEX cr_item_publish_audit_orev_idx ON cr_item_publish_audit (old_revision); CREATE TRIGGER RI_ConstraintTrigger_c_341304 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341305 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341309 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341310 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341314 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341315 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 1,695,744 bytes -- Table rows: 19,669
Begin main content
