CREATE TABLE lang_message_keys ( message_key varchar(200) NOT NULL, package_key varchar(100) NOT NULL, description text(-5), object_id integer, PRIMARY KEY (message_key,package_key), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT lang_message_keys_fk REFERENCES apm_package_types (), CONSTRAINT lang_message_keys_object_id_fk REFERENCES apm_package_types (), CONSTRAINT lang_message_keys_pk REFERENCES apm_package_types () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT lang_message_keys_pk REFERENCES acs_objects (), CONSTRAINT lang_message_keys_fk REFERENCES acs_objects (), CONSTRAINT lang_message_keys_object_id_fk REFERENCES acs_objects () ); CREATE INDEX lang_message_keys_object_id_idx ON lang_message_keys (object_id); CREATE TRIGGER RI_ConstraintTrigger_c_342549 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342550 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342552 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342553 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342572 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342573 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_766242 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_766243 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to lang_message_keys: --lang_messages(lang_message_keys_fk) --lang_messages(lang_message_keys_object_id_fk) --lang_messages(lang_message_keys_pk) --lang_messages_audit(lang_message_keys_fk) --lang_messages_audit(lang_message_keys_object_id_fk) --lang_messages_audit(lang_message_keys_pk) -- Table size: 262,144 bytes -- Table rows: 4,333
Begin main content
