-- -- A generic message which may be attached to any object in the system. -- CREATE TABLE acs_messages ( message_id integer PRIMARY KEY NOT NULL, -- -- Pointer to a message this message contains a reply to, for threading. -- reply_to integer, -- -- The date the message was sent (may be distinct from when it was created -- or published in the system.) -- sent_date timestamptz NOT NULL, -- -- The person who sent the message (may be distinct from the person who -- entered the message in the system.) -- sender integer, -- -- The RFC822 message-id of this message, for sending email. -- rfc822_id varchar(250) NOT NULL, tree_sortkey varbit(-5), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_messages_message_id_fk REFERENCES cr_items (), CONSTRAINT acs_messages_pk REFERENCES cr_items (), CONSTRAINT acs_messages_reply_to_fk REFERENCES cr_items (), CONSTRAINT acs_messages_sender_fk REFERENCES cr_items () ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT acs_messages_sender_fk REFERENCES acs_messages (), CONSTRAINT acs_messages_reply_to_fk REFERENCES acs_messages (), CONSTRAINT acs_messages_pk REFERENCES acs_messages (), CONSTRAINT acs_messages_message_id_fk REFERENCES acs_messages (), CONSTRAINT acs_messages_sender_fk REFERENCES parties (), CONSTRAINT acs_messages_message_id_fk REFERENCES parties (), CONSTRAINT acs_messages_pk REFERENCES parties (), CONSTRAINT acs_messages_reply_to_fk REFERENCES parties () ); CREATE INDEX acs_messages_reply_to_idx ON acs_messages (reply_to); CREATE UNIQUE INDEX acs_messages_rfc822_id_un ON acs_messages (rfc822_id); CREATE INDEX acs_messages_sender_idx ON acs_messages (sender); CREATE INDEX acs_messages_sent_idx ON acs_messages (sent_date); CREATE INDEX acs_messages_tree_skey_idx ON acs_messages (tree_sortkey); CREATE TRIGGER acs_message_insert_tr BEFORE INSERT FOR EACH ROW EXECUTE PROCEDURE acs_message_insert_tr (disabled) CREATE TRIGGER acs_message_update_tr AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE acs_message_update_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340414 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340415 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340417 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340418 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340419 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340420 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340424 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340425 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340652 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340653 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342457 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342458 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to acs_messages: --acs_messages(acs_messages_message_id_fk) --acs_messages(acs_messages_pk) --acs_messages(acs_messages_reply_to_fk) --acs_messages(acs_messages_sender_fk) --acs_messages_outgoing(acs_messages_message_id_fk) --acs_messages_outgoing(acs_messages_pk) --acs_messages_outgoing(acs_messages_reply_to_fk) --acs_messages_outgoing(acs_messages_sender_fk) --general_comments(acs_messages_message_id_fk) --general_comments(acs_messages_pk) --general_comments(acs_messages_reply_to_fk) --general_comments(acs_messages_sender_fk) -- Table size: 24,576 bytes -- Table rows: 225
Begin main content
