-- -- Extends the acs_messages table to hold item level data. -- CREATE TABLE general_comments ( comment_id integer PRIMARY KEY NOT NULL, -- -- The id of the object to associate message with -- object_id integer, -- -- This feature is not complete. The purpose is to allow separation of -- comments into categories. -- category varchar(1000), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT general_comments_comment_id_fk REFERENCES acs_messages (), CONSTRAINT general_comments_object_id_fk REFERENCES acs_messages (), CONSTRAINT general_comments_pk REFERENCES acs_messages () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT general_comments_pk REFERENCES acs_objects (), CONSTRAINT general_comments_comment_id_fk REFERENCES acs_objects (), CONSTRAINT general_comments_object_id_fk REFERENCES acs_objects () ); CREATE INDEX general_comments_object_id_idx ON general_comments (object_id); CREATE TRIGGER RI_ConstraintTrigger_c_342459 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342460 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342464 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342465 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342992 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342993 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to general_comments: --trackback_pings(general_comments_comment_id_fk) --trackback_pings(general_comments_object_id_fk) --trackback_pings(general_comments_pk) -- Table size: 8,192 bytes -- Table rows: 225
Begin main content
