CREATE TABLE acs_sc_msg_types ( msg_type_id integer PRIMARY KEY NOT NULL, msg_type_name varchar(100), ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_sc_msg_types_id_fk REFERENCES acs_objects (), CONSTRAINT acs_sc_msg_types_pk REFERENCES acs_objects () ); CREATE UNIQUE INDEX acs_sc_msg_types_name_un ON acs_sc_msg_types (msg_type_name); CREATE TRIGGER RI_ConstraintTrigger_a_340567 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340568 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340572 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340573 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340579 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340580 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340587 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340588 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340597 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340598 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to acs_sc_msg_types: --acs_sc_msg_type_elements(acs_sc_msg_types_id_fk) --acs_sc_msg_type_elements(acs_sc_msg_types_pk) --acs_sc_operations(acs_sc_msg_types_id_fk) --acs_sc_operations(acs_sc_msg_types_pk) -- Table size: 16,384 bytes -- Table rows: 158
Begin main content
