CREATE TABLE acs_sc_msg_type_elements ( msg_type_id integer NOT NULL, element_name varchar(100) NOT NULL, element_msg_type_id integer NOT NULL, element_msg_type_isset_p bool, element_pos integer, CONSTRAINT acs_sc_msg_type_el_emti_id_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_msg_type_el_mtype_id_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_msg_type_el_un REFERENCES acs_sc_msg_types () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_sc_msg_type_el_un REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_msg_type_el_emti_id_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_msg_type_el_mtype_id_fk REFERENCES acs_sc_msg_types () ); CREATE UNIQUE INDEX acs_sc_msg_type_el_un ON acs_sc_msg_type_elements (msg_type_id, element_name, element_msg_type_id); CREATE TRIGGER RI_ConstraintTrigger_c_340569 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340570 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340574 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340575 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 16,384 bytes -- Table rows: 202
Begin main content
