-- 重建 mom-chdl 全部外键(只在缺失时添加) -- 生成时间: 2026-10-30 SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ge_bytearray' AND CONSTRAINT_NAME='ACT_FK_BYTEARR_DEPL'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_id_membership' AND CONSTRAINT_NAME='ACT_FK_MEMB_GROUP'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_id_membership' AND CONSTRAINT_NAME='ACT_FK_MEMB_USER'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_id_priv_mapping' AND CONSTRAINT_NAME='ACT_FK_PRIV_MAPPING'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_procdef_info' AND CONSTRAINT_NAME='ACT_FK_INFO_JSON_BA'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_procdef_info' AND CONSTRAINT_NAME='ACT_FK_INFO_PROCDEF'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_re_model' AND CONSTRAINT_NAME='ACT_FK_MODEL_DEPLOYMENT'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_re_model' AND CONSTRAINT_NAME='ACT_FK_MODEL_SOURCE'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_re_model' AND CONSTRAINT_NAME='ACT_FK_MODEL_SOURCE_EXTRA'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_deadletter_job' AND CONSTRAINT_NAME='ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_deadletter_job' AND CONSTRAINT_NAME='ACT_FK_DEADLETTER_JOB_EXCEPTION'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_deadletter_job' AND CONSTRAINT_NAME='ACT_FK_DEADLETTER_JOB_EXECUTION'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_deadletter_job' AND CONSTRAINT_NAME='ACT_FK_DEADLETTER_JOB_PROC_DEF'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_deadletter_job' AND CONSTRAINT_NAME='ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_event_subscr' AND CONSTRAINT_NAME='ACT_FK_EVENT_EXEC'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_execution' AND CONSTRAINT_NAME='ACT_FK_EXE_PARENT'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_execution' AND CONSTRAINT_NAME='ACT_FK_EXE_PROCDEF'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_execution' AND CONSTRAINT_NAME='ACT_FK_EXE_PROCINST'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_execution' AND CONSTRAINT_NAME='ACT_FK_EXE_SUPER'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_external_job' AND CONSTRAINT_NAME='ACT_FK_EXTERNAL_JOB_CUSTOM_VALUES'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_external_job' AND CONSTRAINT_NAME='ACT_FK_EXTERNAL_JOB_EXCEPTION'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_identitylink' AND CONSTRAINT_NAME='ACT_FK_ATHRZ_PROCEDEF'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_identitylink' AND CONSTRAINT_NAME='ACT_FK_IDL_PROCINST'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_identitylink' AND CONSTRAINT_NAME='ACT_FK_TSKASS_TASK'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_job' AND CONSTRAINT_NAME='ACT_FK_JOB_CUSTOM_VALUES'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_job' AND CONSTRAINT_NAME='ACT_FK_JOB_EXCEPTION'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_job' AND CONSTRAINT_NAME='ACT_FK_JOB_EXECUTION'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_job' AND CONSTRAINT_NAME='ACT_FK_JOB_PROC_DEF'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_job' AND CONSTRAINT_NAME='ACT_FK_JOB_PROCESS_INSTANCE'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_suspended_job' AND CONSTRAINT_NAME='ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_suspended_job' AND CONSTRAINT_NAME='ACT_FK_SUSPENDED_JOB_EXCEPTION'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_suspended_job' AND CONSTRAINT_NAME='ACT_FK_SUSPENDED_JOB_EXECUTION'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_suspended_job' AND CONSTRAINT_NAME='ACT_FK_SUSPENDED_JOB_PROC_DEF'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_suspended_job' AND CONSTRAINT_NAME='ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_task' AND CONSTRAINT_NAME='ACT_FK_TASK_EXE'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_task' AND CONSTRAINT_NAME='ACT_FK_TASK_PROCDEF'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_task' AND CONSTRAINT_NAME='ACT_FK_TASK_PROCINST'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_timer_job' AND CONSTRAINT_NAME='ACT_FK_TIMER_JOB_CUSTOM_VALUES'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_timer_job' AND CONSTRAINT_NAME='ACT_FK_TIMER_JOB_EXCEPTION'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_timer_job' AND CONSTRAINT_NAME='ACT_FK_TIMER_JOB_EXECUTION'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_timer_job' AND CONSTRAINT_NAME='ACT_FK_TIMER_JOB_PROC_DEF'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_timer_job' AND CONSTRAINT_NAME='ACT_FK_TIMER_JOB_PROCESS_INSTANCE'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_variable' AND CONSTRAINT_NAME='ACT_FK_VAR_BYTEARRAY'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_variable' AND CONSTRAINT_NAME='ACT_FK_VAR_EXE'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='act_ru_variable' AND CONSTRAINT_NAME='ACT_FK_VAR_PROCINST'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='flw_event_resource' AND CONSTRAINT_NAME='FLW_FK_EVENT_RSRC_DPL'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='flw_ru_batch_part' AND CONSTRAINT_NAME='FLW_FK_BATCH_PART_PARENT'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='qrtz_blob_triggers' AND CONSTRAINT_NAME='qrtz_blob_triggers_ibfk_1'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='qrtz_cron_triggers' AND CONSTRAINT_NAME='qrtz_cron_triggers_ibfk_1'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='qrtz_simple_triggers' AND CONSTRAINT_NAME='qrtz_simple_triggers_ibfk_1'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='qrtz_simprop_triggers' AND CONSTRAINT_NAME='qrtz_simprop_triggers_ibfk_1'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st; SET @exists = (SELECT COUNT(*) FROM information_schema.TABLE_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='mom-chdl' AND TABLE_NAME='qrtz_triggers' AND CONSTRAINT_NAME='qrtz_triggers_ibfk_1'); SET @s = IF(@exists = 0, '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', 'SELECT 1'); PREPARE st FROM @s; EXECUTE st; DEALLOCATE PREPARE st;