-- 重建外键:显式限定库名 mom-chdl,避免解析到 ruoyi-vue-pro SET FOREIGN_KEY_CHECKS = 0; ALTER TABLE `mom-chdl`.`act_ge_bytearray` DROP FOREIGN KEY `ACT_FK_BYTEARR_DEPL`; ALTER TABLE `mom-chdl`.`act_ge_bytearray` ADD CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `mom-chdl`.`act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_id_membership` DROP FOREIGN KEY `ACT_FK_MEMB_GROUP`; ALTER TABLE `mom-chdl`.`act_id_membership` ADD CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `mom-chdl`.`act_id_group` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_id_membership` DROP FOREIGN KEY `ACT_FK_MEMB_USER`; ALTER TABLE `mom-chdl`.`act_id_membership` ADD CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `mom-chdl`.`act_id_user` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_id_priv_mapping` DROP FOREIGN KEY `ACT_FK_PRIV_MAPPING`; ALTER TABLE `mom-chdl`.`act_id_priv_mapping` ADD CONSTRAINT `ACT_FK_PRIV_MAPPING` FOREIGN KEY (`PRIV_ID_`) REFERENCES `mom-chdl`.`act_id_priv` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_procdef_info` DROP FOREIGN KEY `ACT_FK_INFO_JSON_BA`; ALTER TABLE `mom-chdl`.`act_procdef_info` ADD CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_procdef_info` DROP FOREIGN KEY `ACT_FK_INFO_PROCDEF`; ALTER TABLE `mom-chdl`.`act_procdef_info` ADD CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `mom-chdl`.`act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_re_model` DROP FOREIGN KEY `ACT_FK_MODEL_DEPLOYMENT`; ALTER TABLE `mom-chdl`.`act_re_model` ADD CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `mom-chdl`.`act_re_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_re_model` DROP FOREIGN KEY `ACT_FK_MODEL_SOURCE`; ALTER TABLE `mom-chdl`.`act_re_model` ADD CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_re_model` DROP FOREIGN KEY `ACT_FK_MODEL_SOURCE_EXTRA`; ALTER TABLE `mom-chdl`.`act_re_model` ADD CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` DROP FOREIGN KEY `ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES`; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` ADD CONSTRAINT `ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` DROP FOREIGN KEY `ACT_FK_DEADLETTER_JOB_EXCEPTION`; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` ADD CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` DROP FOREIGN KEY `ACT_FK_DEADLETTER_JOB_EXECUTION`; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` ADD CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` DROP FOREIGN KEY `ACT_FK_DEADLETTER_JOB_PROC_DEF`; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` ADD CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `mom-chdl`.`act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` DROP FOREIGN KEY `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE`; ALTER TABLE `mom-chdl`.`act_ru_deadletter_job` ADD CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_event_subscr` DROP FOREIGN KEY `ACT_FK_EVENT_EXEC`; ALTER TABLE `mom-chdl`.`act_ru_event_subscr` ADD CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_execution` DROP FOREIGN KEY `ACT_FK_EXE_PARENT`; ALTER TABLE `mom-chdl`.`act_ru_execution` ADD CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_execution` DROP FOREIGN KEY `ACT_FK_EXE_PROCDEF`; ALTER TABLE `mom-chdl`.`act_ru_execution` ADD CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `mom-chdl`.`act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_execution` DROP FOREIGN KEY `ACT_FK_EXE_PROCINST`; ALTER TABLE `mom-chdl`.`act_ru_execution` ADD CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `mom-chdl`.`act_ru_execution` DROP FOREIGN KEY `ACT_FK_EXE_SUPER`; ALTER TABLE `mom-chdl`.`act_ru_execution` ADD CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_external_job` DROP FOREIGN KEY `ACT_FK_EXTERNAL_JOB_CUSTOM_VALUES`; ALTER TABLE `mom-chdl`.`act_ru_external_job` ADD CONSTRAINT `ACT_FK_EXTERNAL_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_external_job` DROP FOREIGN KEY `ACT_FK_EXTERNAL_JOB_EXCEPTION`; ALTER TABLE `mom-chdl`.`act_ru_external_job` ADD CONSTRAINT `ACT_FK_EXTERNAL_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_identitylink` DROP FOREIGN KEY `ACT_FK_ATHRZ_PROCEDEF`; ALTER TABLE `mom-chdl`.`act_ru_identitylink` ADD CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `mom-chdl`.`act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_identitylink` DROP FOREIGN KEY `ACT_FK_IDL_PROCINST`; ALTER TABLE `mom-chdl`.`act_ru_identitylink` ADD CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_identitylink` DROP FOREIGN KEY `ACT_FK_TSKASS_TASK`; ALTER TABLE `mom-chdl`.`act_ru_identitylink` ADD CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `mom-chdl`.`act_ru_task` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_job` DROP FOREIGN KEY `ACT_FK_JOB_CUSTOM_VALUES`; ALTER TABLE `mom-chdl`.`act_ru_job` ADD CONSTRAINT `ACT_FK_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_job` DROP FOREIGN KEY `ACT_FK_JOB_EXCEPTION`; ALTER TABLE `mom-chdl`.`act_ru_job` ADD CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_job` DROP FOREIGN KEY `ACT_FK_JOB_EXECUTION`; ALTER TABLE `mom-chdl`.`act_ru_job` ADD CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_job` DROP FOREIGN KEY `ACT_FK_JOB_PROC_DEF`; ALTER TABLE `mom-chdl`.`act_ru_job` ADD CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `mom-chdl`.`act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_job` DROP FOREIGN KEY `ACT_FK_JOB_PROCESS_INSTANCE`; ALTER TABLE `mom-chdl`.`act_ru_job` ADD CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` DROP FOREIGN KEY `ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES`; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` ADD CONSTRAINT `ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` DROP FOREIGN KEY `ACT_FK_SUSPENDED_JOB_EXCEPTION`; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` ADD CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` DROP FOREIGN KEY `ACT_FK_SUSPENDED_JOB_EXECUTION`; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` ADD CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` DROP FOREIGN KEY `ACT_FK_SUSPENDED_JOB_PROC_DEF`; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` ADD CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `mom-chdl`.`act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` DROP FOREIGN KEY `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE`; ALTER TABLE `mom-chdl`.`act_ru_suspended_job` ADD CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_task` DROP FOREIGN KEY `ACT_FK_TASK_EXE`; ALTER TABLE `mom-chdl`.`act_ru_task` ADD CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_task` DROP FOREIGN KEY `ACT_FK_TASK_PROCDEF`; ALTER TABLE `mom-chdl`.`act_ru_task` ADD CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `mom-chdl`.`act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_task` DROP FOREIGN KEY `ACT_FK_TASK_PROCINST`; ALTER TABLE `mom-chdl`.`act_ru_task` ADD CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_timer_job` DROP FOREIGN KEY `ACT_FK_TIMER_JOB_CUSTOM_VALUES`; ALTER TABLE `mom-chdl`.`act_ru_timer_job` ADD CONSTRAINT `ACT_FK_TIMER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_timer_job` DROP FOREIGN KEY `ACT_FK_TIMER_JOB_EXCEPTION`; ALTER TABLE `mom-chdl`.`act_ru_timer_job` ADD CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_timer_job` DROP FOREIGN KEY `ACT_FK_TIMER_JOB_EXECUTION`; ALTER TABLE `mom-chdl`.`act_ru_timer_job` ADD CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_timer_job` DROP FOREIGN KEY `ACT_FK_TIMER_JOB_PROC_DEF`; ALTER TABLE `mom-chdl`.`act_ru_timer_job` ADD CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `mom-chdl`.`act_re_procdef` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_timer_job` DROP FOREIGN KEY `ACT_FK_TIMER_JOB_PROCESS_INSTANCE`; ALTER TABLE `mom-chdl`.`act_ru_timer_job` ADD CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_variable` DROP FOREIGN KEY `ACT_FK_VAR_BYTEARRAY`; ALTER TABLE `mom-chdl`.`act_ru_variable` ADD CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `mom-chdl`.`act_ge_bytearray` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_variable` DROP FOREIGN KEY `ACT_FK_VAR_EXE`; ALTER TABLE `mom-chdl`.`act_ru_variable` ADD CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`act_ru_variable` DROP FOREIGN KEY `ACT_FK_VAR_PROCINST`; ALTER TABLE `mom-chdl`.`act_ru_variable` ADD CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `mom-chdl`.`act_ru_execution` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`flw_event_resource` DROP FOREIGN KEY `FLW_FK_EVENT_RSRC_DPL`; ALTER TABLE `mom-chdl`.`flw_event_resource` ADD CONSTRAINT `FLW_FK_EVENT_RSRC_DPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `mom-chdl`.`flw_event_deployment` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`flw_ru_batch_part` DROP FOREIGN KEY `FLW_FK_BATCH_PART_PARENT`; ALTER TABLE `mom-chdl`.`flw_ru_batch_part` ADD CONSTRAINT `FLW_FK_BATCH_PART_PARENT` FOREIGN KEY (`BATCH_ID_`) REFERENCES `mom-chdl`.`flw_ru_batch` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`qrtz_blob_triggers` DROP FOREIGN KEY `qrtz_blob_triggers_ibfk_1`; ALTER TABLE `mom-chdl`.`qrtz_blob_triggers` ADD CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `mom-chdl`.`qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`qrtz_cron_triggers` DROP FOREIGN KEY `qrtz_cron_triggers_ibfk_1`; ALTER TABLE `mom-chdl`.`qrtz_cron_triggers` ADD CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `mom-chdl`.`qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`qrtz_simple_triggers` DROP FOREIGN KEY `qrtz_simple_triggers_ibfk_1`; ALTER TABLE `mom-chdl`.`qrtz_simple_triggers` ADD CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `mom-chdl`.`qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`qrtz_simprop_triggers` DROP FOREIGN KEY `qrtz_simprop_triggers_ibfk_1`; ALTER TABLE `mom-chdl`.`qrtz_simprop_triggers` ADD CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `mom-chdl`.`qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `mom-chdl`.`qrtz_triggers` DROP FOREIGN KEY `qrtz_triggers_ibfk_1`; ALTER TABLE `mom-chdl`.`qrtz_triggers` ADD CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `mom-chdl`.`qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT; SET FOREIGN_KEY_CHECKS = 1;