CREATE TABLE acs_mail_bodies ( body_id integer PRIMARY KEY NOT NULL, body_reply_to integer, body_from integer, body_date timestamptz, header_message_id varchar(1000) NOT NULL, header_reply_to varchar(1000), header_subject text(-5), header_from text(-5), header_to text(-5), content_item_id integer, ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT acs_mail_bodies_body_id_fk REFERENCES parties (), CONSTRAINT acs_mail_bodies_body_id_pk REFERENCES parties (), CONSTRAINT acs_mail_bodies_reply_to_fk REFERENCES parties (), CONSTRAINT acs_mail_bodies_body_from_fk REFERENCES parties (), CONSTRAINT acs_mail_bodies_content_iid_fk REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_mail_bodies_body_id_pk REFERENCES acs_mail_gc_objects (), CONSTRAINT acs_mail_bodies_body_from_fk REFERENCES acs_mail_gc_objects (), CONSTRAINT acs_mail_bodies_body_id_fk REFERENCES acs_mail_gc_objects (), CONSTRAINT acs_mail_bodies_content_iid_fk REFERENCES acs_mail_gc_objects (), CONSTRAINT acs_mail_bodies_reply_to_fk REFERENCES acs_mail_gc_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_mail_bodies_reply_to_fk REFERENCES acs_objects (), CONSTRAINT acs_mail_bodies_content_iid_fk REFERENCES acs_objects (), CONSTRAINT acs_mail_bodies_body_id_pk REFERENCES acs_objects (), CONSTRAINT acs_mail_bodies_body_id_fk REFERENCES acs_objects (), CONSTRAINT acs_mail_bodies_body_from_fk REFERENCES acs_objects () ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT acs_mail_bodies_reply_to_fk REFERENCES acs_mail_bodies (), CONSTRAINT acs_mail_bodies_body_from_fk REFERENCES acs_mail_bodies (), CONSTRAINT acs_mail_bodies_body_id_fk REFERENCES acs_mail_bodies (), CONSTRAINT acs_mail_bodies_body_id_pk REFERENCES acs_mail_bodies (), CONSTRAINT acs_mail_bodies_content_iid_fk REFERENCES acs_mail_bodies () ); CREATE INDEX acs_mail_bodies_body_from_idx ON acs_mail_bodies (body_from); CREATE INDEX acs_mail_bodies_body_reply_idx ON acs_mail_bodies (body_reply_to); CREATE UNIQUE INDEX acs_mail_bodies_h_m_id_un ON acs_mail_bodies (header_message_id); CREATE INDEX acs_mail_bodies_item_id_idx ON acs_mail_bodies (content_item_id); CREATE TRIGGER RI_ConstraintTrigger_c_340339 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340340 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340344 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340345 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340349 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340350 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340352 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340353 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340354 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340355 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340357 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340358 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340367 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340368 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to acs_mail_bodies: --acs_mail_bodies(acs_mail_bodies_body_from_fk) --acs_mail_bodies(acs_mail_bodies_body_id_fk) --acs_mail_bodies(acs_mail_bodies_body_id_pk) --acs_mail_bodies(acs_mail_bodies_content_iid_fk) --acs_mail_bodies(acs_mail_bodies_reply_to_fk) --acs_mail_body_headers(acs_mail_bodies_body_from_fk) --acs_mail_body_headers(acs_mail_bodies_body_id_fk) --acs_mail_body_headers(acs_mail_bodies_body_id_pk) --acs_mail_body_headers(acs_mail_bodies_content_iid_fk) --acs_mail_body_headers(acs_mail_bodies_reply_to_fk) --acs_mail_links(acs_mail_bodies_body_from_fk) --acs_mail_links(acs_mail_bodies_body_id_fk) --acs_mail_links(acs_mail_bodies_body_id_pk) --acs_mail_links(acs_mail_bodies_content_iid_fk) --acs_mail_links(acs_mail_bodies_reply_to_fk) -- Table size: 0 bytes -- Table rows: 0
Begin main content
