CREATE TABLE acs_mail_links ( mail_link_id integer PRIMARY KEY NOT NULL, body_id integer NOT NULL, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_mail_links_body_id_fk REFERENCES acs_mail_bodies (), CONSTRAINT acs_mail_links_ml_id_fk REFERENCES acs_mail_bodies (), CONSTRAINT acs_mail_links_ml_id_pk REFERENCES acs_mail_bodies () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_mail_links_ml_id_pk REFERENCES acs_objects (), CONSTRAINT acs_mail_links_body_id_fk REFERENCES acs_objects (), CONSTRAINT acs_mail_links_ml_id_fk REFERENCES acs_objects () ); CREATE INDEX acs_mail_links_body_id_idx ON acs_mail_links (body_id); CREATE TRIGGER RI_ConstraintTrigger_c_340369 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340370 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340374 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340375 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340402 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340403 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to acs_mail_links: --acs_mail_queue_messages(acs_mail_links_body_id_fk) --acs_mail_queue_messages(acs_mail_links_ml_id_fk) --acs_mail_queue_messages(acs_mail_links_ml_id_pk) -- Table size: 0 bytes -- Table rows: 0
Begin main content
