mem__advisor_text.localized_text < CONSTRAINT `FK8032F71A19435E5` FOREIGN KEY (`template_id`) REFERENCES `template_meta` (`hib_id`) --- > CONSTRAINT `FK8032F71A19435E5` FOREIGN KEY (`template_id`) REFERENCES `template_meta` (`hib_id`), > CONSTRAINT `FK_r46asdpcsjjg3hli0bc3p3d7p` FOREIGN KEY (`template_id`) REFERENCES `template_meta` (`hib_id`) mem__advisors.app_identity_path < KEY `FK82FFF16843088B` (`for_schedule_id`), < CONSTRAINT `FK82FFF16843088B` FOREIGN KEY (`for_schedule_id`) REFERENCES `advisor_schedules` (`schedule_id`) --- > KEY `FK_7xbq2i81hgo0xlvnb6rr77s21` (`for_schedule_id`), > CONSTRAINT `FK82FFF16843088B` FOREIGN KEY (`for_schedule_id`) REFERENCES `advisor_schedules` (`schedule_id`), > CONSTRAINT `FK_7xbq2i81hgo0xlvnb6rr77s21` FOREIGN KEY (`for_schedule_id`) REFERENCES `advisor_schedules` (`schedule_id`) mem__config.asset_notes < CONSTRAINT `FK5EEBA8B2C7C17194` FOREIGN KEY (`hid`) REFERENCES `noted_assets` (`hid`) --- > CONSTRAINT `FK5EEBA8B2C7C17194` FOREIGN KEY (`hid`) REFERENCES `noted_assets` (`hid`), > CONSTRAINT `FK_rkoucn4pkfmrv2q7om1kt6y5h` FOREIGN KEY (`hid`) REFERENCES `noted_assets` (`hid`) mem__config.user_preferences < CONSTRAINT `FK199BD084E7EE2CFB` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) --- > CONSTRAINT `FK199BD084E7EE2CFB` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`), > CONSTRAINT `FK_qy8dkrkc8b34dcgwoq2km43rd` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`) mem__events.advisor_scopes_advisorcategoryids < CONSTRAINT `FKF0CB0DB962CAB4` FOREIGN KEY (`advisor_scopes_id`) REFERENCES `advisor_scopes` (`id`) --- > CONSTRAINT `FKF0CB0DB962CAB4` FOREIGN KEY (`advisor_scopes_id`) REFERENCES `advisor_scopes` (`id`), > CONSTRAINT `FK_d6st9ft0agdpfro46utm2i4cy` FOREIGN KEY (`advisor_scopes_id`) REFERENCES `advisor_scopes` (`id`) mem__events.advisor_scopes_advisorclassids < CONSTRAINT `FK650AF1BF962CAB4` FOREIGN KEY (`advisor_scopes_id`) REFERENCES `advisor_scopes` (`id`) --- > CONSTRAINT `FK650AF1BF962CAB4` FOREIGN KEY (`advisor_scopes_id`) REFERENCES `advisor_scopes` (`id`), > CONSTRAINT `FK_nbtdy9dfol7o11vydh8wkqgx7` FOREIGN KEY (`advisor_scopes_id`) REFERENCES `advisor_scopes` (`id`) mem__events.assets_scopes_subjects 831c837 < KEY `FK5AF41BABDEEB2076` (`matches_id`), --- > KEY `FK_nno943443b64tl2lsluwwqgs3` (`matches_id`), 833c839,841 < CONSTRAINT `FK5AF41BABDEEB2076` FOREIGN KEY (`matches_id`) REFERENCES `subjects` (`id`) --- > CONSTRAINT `FK5AF41BABDEEB2076` FOREIGN KEY (`matches_id`) REFERENCES `subjects` (`id`), > CONSTRAINT `FK_nno943443b64tl2lsluwwqgs3` FOREIGN KEY (`matches_id`) REFERENCES `subjects` (`id`), > CONSTRAINT `FK_pshsagsjmaybuxy7hqtd8fme8` FOREIGN KEY (`assets_scopes_id`) REFERENCES `assets_scopes` (`id`) mem__events.auto_close_actions < CONSTRAINT `FKE486E726D985BDD2` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`) --- > CONSTRAINT `FKE486E726D985BDD2` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`), > CONSTRAINT `FK_ps4da86da1r992icubgpfks0k` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`) mem__events.event_chain_heads 875,876d883 < KEY `FK39ED0D7044A6E191` (`mostCurrentEvent_id`), < KEY `FK39ED0D70896A4633` (`fixedBy_id`), 878a886,887 > KEY `FK_ci3r5scgpf2goyah3vvr2pw69` (`fixedBy_id`), > KEY `FK_83tu5o4kb502wmchwn00iq651` (`mostCurrentEvent_id`), 880,881c889,892 < CONSTRAINT `FK39ED0D70896A4633` FOREIGN KEY (`fixedBy_id`) REFERENCES `fixers` (`id`) --- > CONSTRAINT `FK39ED0D70896A4633` FOREIGN KEY (`fixedBy_id`) REFERENCES `fixers` (`id`), > CONSTRAINT `FK_83tu5o4kb502wmchwn00iq651` FOREIGN KEY (`mostCurrentEvent_id`) REFERENCES `events` (`id`), > CONSTRAINT `FK_ci3r5scgpf2goyah3vvr2pw69` FOREIGN KEY (`fixedBy_id`) REFERENCES `fixers` (`id`) mem__events.events_subjects 931c942 < KEY `FKB676CD2D4D38A5DD` (`subject_id`), --- > KEY `FK_4gve6o318fn48jb5x0qc1kmqb` (`subject_id`), 933c944,945 < CONSTRAINT `FKB676CD2D74554C1C` FOREIGN KEY (`events_id`) REFERENCES `events` (`id`) --- > CONSTRAINT `FKB676CD2D74554C1C` FOREIGN KEY (`events_id`) REFERENCES `events` (`id`), > CONSTRAINT `FK_4gve6o318fn48jb5x0qc1kmqb` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) mem__events.group_scopes_groupids 976c988,989 < CONSTRAINT `FK5844F9998F845D4E` FOREIGN KEY (`group_scopes_id`) REFERENCES `group_scopes` (`id`) --- > CONSTRAINT `FK5844F9998F845D4E` FOREIGN KEY (`group_scopes_id`) REFERENCES `group_scopes` (`id`), > CONSTRAINT `FK_qlrbpcxd36pfmsuq3u9a4g61u` FOREIGN KEY (`group_scopes_id`) REFERENCES `group_scopes` (`id`) mem__events.policy_actions 1014,1015c1027,1029 < KEY `FK60A642F0A9BCBDD` (`eventAction_id`), < CONSTRAINT `FK60A642F0A9BCBDD` FOREIGN KEY (`eventAction_id`) REFERENCES `actions` (`id`) --- > KEY `FK_881tmq5khp4rqj5uvrakq2bba` (`eventAction_id`), > CONSTRAINT `FK60A642F0A9BCBDD` FOREIGN KEY (`eventAction_id`) REFERENCES `actions` (`id`), > CONSTRAINT `FK_881tmq5khp4rqj5uvrakq2bba` FOREIGN KEY (`eventAction_id`) REFERENCES `actions` (`id`) mem__events.routed_policy_actions 1038,1041c1052,1055 < KEY `FKC5545C746D36871E` (`assetsScope_id`), < KEY `FKC5545C7474955EEA` (`statusScope_id`), < KEY `FKC5545C74F7113CB8` (`groupScope_id`), < KEY `FKC5545C742D980056` (`advisorClassScope_id`), --- > KEY `FK_sldglj9y9upn25178p8yl75m9` (`advisorClassScope_id`), > KEY `FK_tcgwgy5ynw22riyhups6cmoby` (`assetsScope_id`), > KEY `FK_2yg1vowrun5uydcrm5xtu5s1m` (`groupScope_id`), > KEY `FK_66l04pon3sy0b1xb12x8ms9mo` (`statusScope_id`), 1045c1059,1063 < CONSTRAINT `FKC5545C74F7113CB8` FOREIGN KEY (`groupScope_id`) REFERENCES `group_scopes` (`id`) --- > CONSTRAINT `FKC5545C74F7113CB8` FOREIGN KEY (`groupScope_id`) REFERENCES `group_scopes` (`id`), > CONSTRAINT `FK_2yg1vowrun5uydcrm5xtu5s1m` FOREIGN KEY (`groupScope_id`) REFERENCES `group_scopes` (`id`), > CONSTRAINT `FK_66l04pon3sy0b1xb12x8ms9mo` FOREIGN KEY (`statusScope_id`) REFERENCES `status_scopes` (`id`), > CONSTRAINT `FK_sldglj9y9upn25178p8yl75m9` FOREIGN KEY (`advisorClassScope_id`) REFERENCES `advisor_scopes` (`id`), > CONSTRAINT `FK_tcgwgy5ynw22riyhups6cmoby` FOREIGN KEY (`assetsScope_id`) REFERENCES `assets_scopes` (`id`) mem__events.routed_policy_actions_policy_actions 1062c1080,1082 < CONSTRAINT `FKC3135E1BFDA138CF` FOREIGN KEY (`routed_policy_actions_id`) REFERENCES `routed_policy_actions` (`id`) --- > CONSTRAINT `FKC3135E1BFDA138CF` FOREIGN KEY (`routed_policy_actions_id`) REFERENCES `routed_policy_actions` (`id`), > CONSTRAINT `FK_lhf4jhbp4l9ufte86hnc2s29t` FOREIGN KEY (`routed_policy_actions_id`) REFERENCES `routed_policy_actions` (`id`), > CONSTRAINT `FK_pidqa05g2cxvw08lmu71n4gr0` FOREIGN KEY (`policyActions_id`) REFERENCES `policy_actions` (`id`) mem__events.script_actions 1077c1097 < KEY `FK88A9C58953AC5D9D` (`namedScript_id`), --- > KEY `FK_qbaryln8f3y8gr1ku5jdfbk20` (`namedScript_id`), 1079c1099,1101 < CONSTRAINT `FK88A9C589D985BDD2` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`) --- > CONSTRAINT `FK88A9C589D985BDD2` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`), > CONSTRAINT `FK_qbaryln8f3y8gr1ku5jdfbk20` FOREIGN KEY (`namedScript_id`) REFERENCES `named_scripts` (`id`), > CONSTRAINT `FK_rew1t2mccsfvjc6mhifnmo0sm` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`) mem__events.script_executions 1097,1098c1119,1120 < KEY `FK563D004FDDD1EA0D` (`forScript_id`), < KEY `FK563D004FB038B807` (`forAction_super_id`), --- > KEY `FK_fnutx4n3xpim1cll88s48is3i` (`forAction_super_id`), > KEY `FK_3fa881rtyb4jr69x98vyeydw8` (`forScript_id`), 1100c1122,1124 < CONSTRAINT `FK563D004FDDD1EA0D` FOREIGN KEY (`forScript_id`) REFERENCES `named_scripts` (`id`) --- > CONSTRAINT `FK563D004FDDD1EA0D` FOREIGN KEY (`forScript_id`) REFERENCES `named_scripts` (`id`), > CONSTRAINT `FK_3fa881rtyb4jr69x98vyeydw8` FOREIGN KEY (`forScript_id`) REFERENCES `named_scripts` (`id`), > CONSTRAINT `FK_fnutx4n3xpim1cll88s48is3i` FOREIGN KEY (`forAction_super_id`) REFERENCES `script_actions` (`super_id`) mem__events.script_logs 1118,1119c1142,1144 < KEY `FKED1174A3F0D4E5BD` (`execution_id`), < CONSTRAINT `FKED1174A3F0D4E5BD` FOREIGN KEY (`execution_id`) REFERENCES `script_executions` (`id`) --- > KEY `FK_55sf55cav3bx23mi95sks5bgf` (`execution_id`), > CONSTRAINT `FKED1174A3F0D4E5BD` FOREIGN KEY (`execution_id`) REFERENCES `script_executions` (`id`), > CONSTRAINT `FK_55sf55cav3bx23mi95sks5bgf` FOREIGN KEY (`execution_id`) REFERENCES `script_executions` (`id`) mem__events.smtp_action_log_failed_targets 1134c1159 < KEY `FK40FAF15BAB350DEE` (`failedTargets_id`), --- > KEY `FK_m909b7ogbpbnmkxsu08jl3qwm` (`failedTargets_id`), 1136c1161,1163 < CONSTRAINT `FK40FAF15BAB350DEE` FOREIGN KEY (`failedTargets_id`) REFERENCES `action_log_smtp_targets` (`id`) --- > CONSTRAINT `FK40FAF15BAB350DEE` FOREIGN KEY (`failedTargets_id`) REFERENCES `action_log_smtp_targets` (`id`), > CONSTRAINT `FK_2cdfe0tav6sswiy10uu8svk1e` FOREIGN KEY (`smtp_action_logs_super_id`) REFERENCES `smtp_action_logs` (`super_id`), > CONSTRAINT `FK_m909b7ogbpbnmkxsu08jl3qwm` FOREIGN KEY (`failedTargets_id`) REFERENCES `action_log_smtp_targets` (`id`) mem__events.smtp_action_log_success_targets 1151c1178 < KEY `FK6867BDCB271C3A34` (`successTargets_id`), --- > KEY `FK_5sgo5qdcnh24d4nhe83c6hkrr` (`successTargets_id`), 1153c1180,1182 < CONSTRAINT `FK6867BDCBA5A2F7EF` FOREIGN KEY (`smtp_action_logs_super_id`) REFERENCES `smtp_action_logs` (`super_id`) --- > CONSTRAINT `FK6867BDCBA5A2F7EF` FOREIGN KEY (`smtp_action_logs_super_id`) REFERENCES `smtp_action_logs` (`super_id`), > CONSTRAINT `FK_5sgo5qdcnh24d4nhe83c6hkrr` FOREIGN KEY (`successTargets_id`) REFERENCES `action_log_smtp_targets` (`id`), > CONSTRAINT `FK_qylv196bgl1nx28btws71imy4` FOREIGN KEY (`smtp_action_logs_super_id`) REFERENCES `smtp_action_logs` (`super_id`) mem__events.smtp_action_logs 1167c1196,1197 < CONSTRAINT `FK8213EDAFB47FAB17` FOREIGN KEY (`super_id`) REFERENCES `action_logs` (`id`) --- > CONSTRAINT `FK8213EDAFB47FAB17` FOREIGN KEY (`super_id`) REFERENCES `action_logs` (`id`), > CONSTRAINT `FK_d9tqgpstfb60ipxafjqkrwkox` FOREIGN KEY (`super_id`) REFERENCES `action_logs` (`id`) mem__events.smtp_actions 1182c1212,1213 < CONSTRAINT `FKB0B52814D985BDD2` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`) --- > CONSTRAINT `FKB0B52814D985BDD2` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`), > CONSTRAINT `FK_d0nhwx9lbxbe737vy4n24jglq` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`) mem__events.smtp_actions_emailtargets 1197c1228,1229 < CONSTRAINT `FK55C20811859BDC47` FOREIGN KEY (`smtp_actions_super_id`) REFERENCES `smtp_actions` (`super_id`) --- > CONSTRAINT `FK55C20811859BDC47` FOREIGN KEY (`smtp_actions_super_id`) REFERENCES `smtp_actions` (`super_id`), > CONSTRAINT `FK_r1ae5ybqmdrbtug4wevfw4qcg` FOREIGN KEY (`smtp_actions_super_id`) REFERENCES `smtp_actions` (`super_id`) mem__events.snmp_action_logs 1214c1246,1247 < CONSTRAINT `FKAEDED497B47FAB17` FOREIGN KEY (`super_id`) REFERENCES `action_logs` (`id`) --- > CONSTRAINT `FKAEDED497B47FAB17` FOREIGN KEY (`super_id`) REFERENCES `action_logs` (`id`), > CONSTRAINT `FK_9v2vxq0aff50nub2ua3k8penn` FOREIGN KEY (`super_id`) REFERENCES `action_logs` (`id`) mem__events.snmp_actions 1228c1261,1262 < CONSTRAINT `FK9797C2FCD985BDD2` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`) --- > CONSTRAINT `FK9797C2FCD985BDD2` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`), > CONSTRAINT `FK_380hn2g7xiwv094bjmygillqu` FOREIGN KEY (`super_id`) REFERENCES `actions` (`id`) mem__events.status_scopes_statuses 1257c1291,1292 < CONSTRAINT `FK2F1A1173A374AEC0` FOREIGN KEY (`status_scopes_id`) REFERENCES `status_scopes` (`id`) --- > CONSTRAINT `FK2F1A1173A374AEC0` FOREIGN KEY (`status_scopes_id`) REFERENCES `status_scopes` (`id`), > CONSTRAINT `FK_mjiwgew3sods6ph70e4aag972` FOREIGN KEY (`status_scopes_id`) REFERENCES `status_scopes` (`id`)