-- -- i-doit 0.9.8-3 mandator dump -- -------- ERROR #1452 - Cannot add or update a child row: a foreign key constraint fails (`idoit_mandant`.`#sql-529_387`, CONSTRAINT `isys_catg_application_list_ibfk_2` FOREIGN KEY (`isys_catg_application_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE NO ACTI) ALTER TABLE `isys_catg_application_list` ADD CONSTRAINT `isys_catg_application_list_ibfk_1` FOREIGN KEY (`isys_catg_application_list__isys_catg_application__id`) REFERENCES `isys_catg_application` (`isys_catg_application__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_application_list_ibfk_2` FOREIGN KEY (`isys_catg_application_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ------- ------- ERROR #1452 - Cannot add or update a child row: a foreign key constraint fails (`idoit_mandant`.`#sql-529_38b`, CONSTRAINT `isys_catg_distributor_ibfk_34` FOREIGN KEY (`isys_catg_distributor__isys_catg_virtual_machine__id`) REFERENCES `isys_catg_virtual_machine` (`isys_ca) ALTER TABLE `isys_catg_distributor` ADD CONSTRAINT `isys_catg_distributor_ibfk_1` FOREIGN KEY (`isys_catg_distributor__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_10` FOREIGN KEY (`isys_catg_distributor__isys_catg_stor__id`) REFERENCES `isys_catg_stor` (`isys_catg_stor__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_11` FOREIGN KEY (`isys_catg_distributor__isys_catg_file__id`) REFERENCES `isys_catg_file` (`isys_catg_file__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_12` FOREIGN KEY (`isys_catg_distributor__isys_catg_model__id`) REFERENCES `isys_catg_model` (`isys_catg_model__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_13` FOREIGN KEY (`isys_catg_distributor__isys_catg_cpu__id`) REFERENCES `isys_catg_cpu` (`isys_catg_cpu__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_14` FOREIGN KEY (`isys_catg_distributor__isys_catg_global__id`) REFERENCES `isys_catg_global` (`isys_catg_global__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_15` FOREIGN KEY (`isys_catg_distributor__isys_catg_backup__id`) REFERENCES `isys_catg_backup` (`isys_catg_backup__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_16` FOREIGN KEY (`isys_catg_distributor__isys_catg_maintenance__id`) REFERENCES `isys_catg_maintenance` (`isys_catg_maintenance__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_17` FOREIGN KEY (`isys_catg_distributor__isys_catg_contact__id`) REFERENCES `isys_catg_contact` (`isys_catg_contact__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_18` FOREIGN KEY (`isys_catg_distributor__isys_catg_emergency_plan__id`) REFERENCES `isys_catg_emergency_plan` (`isys_catg_emergency_plan__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_19` FOREIGN KEY (`isys_catg_distributor__isys_catg_application__id`) REFERENCES `isys_catg_application` (`isys_catg_application__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_2` FOREIGN KEY (`isys_catg_distributor__isys_catg_netp__id`) REFERENCES `isys_catg_netp` (`isys_catg_netp__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_21` FOREIGN KEY (`isys_catg_distributor__isys_catg_logb__id`) REFERENCES `isys_catg_logb` (`isys_catg_logb__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_22` FOREIGN KEY (`isys_catg_distributor__isys_catg_odep__id`) REFERENCES `isys_catg_odep` (`isys_catg_odep__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_23` FOREIGN KEY (`isys_catg_distributor__isys_catg_image__id`) REFERENCES `isys_catg_image` (`isys_catg_image__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_24` FOREIGN KEY (`isys_catg_distributor__isys_catg_location__id`) REFERENCES `isys_catg_location` (`isys_catg_location__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_25` FOREIGN KEY (`isys_catg_distributor__isys_catg_manual__id`) REFERENCES `isys_catg_manual` (`isys_catg_manual__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_26` FOREIGN KEY (`isys_catg_distributor__isys_catg_controller__id`) REFERENCES `isys_catg_controller` (`isys_catg_controller__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_27` FOREIGN KEY (`isys_catg_distributor__isys_catg_lic__id`) REFERENCES `isys_catg_lic` (`isys_catg_lic__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_28` FOREIGN KEY (`isys_catg_distributor__isys_catg_idic__id`) REFERENCES `isys_catg_idic` (`isys_catg_idic__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_29` FOREIGN KEY (`isys_catg_distributor__isys_catg_overview__id`) REFERENCES `isys_catg_overview` (`isys_catg_overview__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_3` FOREIGN KEY (`isys_catg_distributor__isys_catg_power_consumer__id`) REFERENCES `isys_catg_power_consumer` (`isys_catg_power_consumer__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_30` FOREIGN KEY (`isys_catg_distributor__isys_catg_workflow__id`) REFERENCES `isys_catg_workflow` (`isys_catg_workflow__id`), ADD CONSTRAINT `isys_catg_distributor_ibfk_31` FOREIGN KEY (`isys_catg_distributor__isys_catg_virtual__id`) REFERENCES `isys_catg_virtual` (`isys_catg_virtual__id`), ADD CONSTRAINT `isys_catg_distributor_ibfk_32` FOREIGN KEY (`isys_catg_distributor__isys_catg_graphic__id`) REFERENCES `isys_catg_graphic` (`isys_catg_graphic__id`), ADD CONSTRAINT `isys_catg_distributor_ibfk_33` FOREIGN KEY (`isys_catg_distributor__isys_catg_sound__id`) REFERENCES `isys_catg_sound` (`isys_catg_sound__id`), ADD CONSTRAINT `isys_catg_distributor_ibfk_34` FOREIGN KEY (`isys_catg_distributor__isys_catg_virtual_machine__id`) REFERENCES `isys_catg_virtual_machine` (`isys_catg_virtual_machine__id`), ADD CONSTRAINT `isys_catg_distributor_ibfk_4` FOREIGN KEY (`isys_catg_distributor__isys_catg_access__id`) REFERENCES `isys_catg_access` (`isys_catg_access__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_5` FOREIGN KEY (`isys_catg_distributor__isys_catg_memory__id`) REFERENCES `isys_catg_memory` (`isys_catg_memory__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_6` FOREIGN KEY (`isys_catg_distributor__isys_catg_ui__id`) REFERENCES `isys_catg_ui` (`isys_catg_ui__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_7` FOREIGN KEY (`isys_catg_distributor__isys_catg_formfactor__id`) REFERENCES `isys_catg_formfactor` (`isys_catg_formfactor__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_distributor_ibfk_8` FOREIGN KEY (`isys_catg_distributor__isys_catg_netv__id`) REFERENCES `isys_catg_netv` (`isys_catg_netv__id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ------- ------- ERROR #1452 - Cannot add or update a child row: a foreign key constraint fails (`idoit_mandant`.`#sql-529_393`, CONSTRAINT `isys_catg_global_list_ibfk_5` FOREIGN KEY (`isys_catg_global_list__isys_contact__id`) REFERENCES `isys_contact` (`isys_contact__id`) ON DELETE SET N) ALTER TABLE `isys_catg_global_list` ADD CONSTRAINT `isys_catg_global_list_ibfk_1` FOREIGN KEY (`isys_catg_global_list__isys_purpose__id`) REFERENCES `isys_purpose` (`isys_purpose__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_global_list_ibfk_2` FOREIGN KEY (`isys_catg_global_list__isys_catg_global__id`) REFERENCES `isys_catg_global` (`isys_catg_global__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_global_list_ibfk_3` FOREIGN KEY (`isys_catg_global_list__isys_catg_global_category__id`) REFERENCES `isys_catg_global_category` (`isys_catg_global_category__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_global_list_ibfk_4` FOREIGN KEY (`isys_catg_global_list__isys_guarantee_period_unit__id`) REFERENCES `isys_guarantee_period_unit` (`isys_guarantee_period_unit__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_catg_global_list_ibfk_5` FOREIGN KEY (`isys_catg_global_list__isys_contact__id`) REFERENCES `isys_contact` (`isys_contact__id`) ON DELETE SET NULL ON UPDATE NO ACTION; ------- ------- ERROR ALTER TABLE `isys_cats_access_point_list` ADD CONSTRAINT `isys_cats_access_point_list_ibfk_6` FOREIGN KEY (`isys_cats_access_point_list__isys_cats_distributor__id`) REFERENCES `idoit_data`.`isys_cats_distributor` (`isys_cats_distributor__id`), ADD CONSTRAINT `isys_cats_access_point_list_ibfk_1` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_standard__id`) REFERENCES `isys_wlan_standard` (`isys_wlan_standard__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_cats_access_point_list_ibfk_2` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_channel__id`) REFERENCES `isys_wlan_channel` (`isys_wlan_channel__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_cats_access_point_list_ibfk_3` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_function__id`) REFERENCES `isys_wlan_function` (`isys_wlan_function__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_cats_access_point_list_ibfk_4` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_encryption__id`) REFERENCES `isys_wlan_encryption` (`isys_wlan_encryption__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_cats_access_point_list_ibfk_5` FOREIGN KEY (`isys_cats_access_point_list__isys_wlan_auth__id`) REFERENCES `isys_wlan_auth` (`isys_wlan_auth__id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ------- ------- ERROR #1452 - Cannot add or update a child row: a foreign key constraint fails (`idoit_mandant`.`#sql-529_3e1`, CONSTRAINT `isys_cats_group_list__isys_cats_distributor__id__FK` FOREIGN KEY (`isys_cats_group_list__isys_cats_distributor__id`) REFERENCES `isys_cats_distribut) ALTER TABLE `isys_cats_group_list` ADD CONSTRAINT `isys_cats_group_list__isys_cats_distributor__id__FK` FOREIGN KEY (`isys_cats_group_list__isys_cats_distributor__id`) REFERENCES `isys_cats_distributor` (`isys_cats_distributor__id`), ADD CONSTRAINT `isys_cats_group_list__isys_obj__id__FK` FOREIGN KEY (`isys_cats_group_list__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE SET NULL; ------- ------- ERROR #1452 - Cannot add or update a child row: a foreign key constraint fails (`idoit_mandant`.`#sql-529_3e5`, CONSTRAINT `isys_cats_pobj_list_ibfk_1` FOREIGN KEY (`isys_cats_pobj_list__isys_pobj_type__id`) REFERENCES `isys_pobj_type` (`isys_pobj_type__id`) ON DELETE NO ) ALTER TABLE `isys_cats_pobj_list` ADD CONSTRAINT `isys_cats_pobj_list_ibfk_1` FOREIGN KEY (`isys_cats_pobj_list__isys_pobj_type__id`) REFERENCES `isys_pobj_type` (`isys_pobj_type__id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ------- ------- ERROR #1452 - Cannot add or update a child row: a foreign key constraint fails (`idoit_mandant`.`#sql-529_3ef`, CONSTRAINT `isys_cats_prt_list_ibfk_1` FOREIGN KEY (`isys_cats_prt_list__isys_cats_prt_type__id`) REFERENCES `isys_cats_prt_type` (`isys_cats_prt_type__id`) ON ) ALTER TABLE `isys_cats_prt_list` ADD CONSTRAINT `isys_cats_prt_list_ibfk_3` FOREIGN KEY (`isys_cats_prt_list__isys_cats_prt_paper__id`) REFERENCES `isys_cats_prt_paper` (`isys_cats_prt_paper__id`) ON DELETE SET NULL, ADD CONSTRAINT `isys_cats_prt_list_ibfk_1` FOREIGN KEY (`isys_cats_prt_list__isys_cats_prt_type__id`) REFERENCES `isys_cats_prt_type` (`isys_cats_prt_type__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_cats_prt_list_ibfk_2` FOREIGN KEY (`isys_cats_prt_list__isys_cats_prt_emulation__id`) REFERENCES `isys_cats_prt_emulation` (`isys_cats_prt_emulation__id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ------- ------- ERROR ALTER TABLE `isys_cats_prt_list_2_isys_ps_queue` ADD CONSTRAINT `isys_cats_prt_list_2_isys_ps_queue_ibfk_1` FOREIGN KEY (`isys_cats_prt_list_2_isys_ps_queue__isys_ps_queue__id`) REFERENCES `isys_ps_queue` (`isys_ps_queue__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_cats_prt_list_2_isys_ps_queue_ibfk_2` FOREIGN KEY (`isys_cats_prt_list_2_isys_ps_queue__isys_cats_prt_list__id`) REFERENCES `isys_cats_prt_list` (`isys_cats_prt_list__id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ------- ------- ERROR ALTER TABLE `isys_cats_san_list` ADD CONSTRAINT `isys_cats_san_list_ibfk_1` FOREIGN KEY (`isys_cats_san_list__isys_stor_unit__id`) REFERENCES `isys_stor_unit` (`isys_stor_unit__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_cats_san_list_ibfk_2` FOREIGN KEY (`isys_cats_san_list__isys_memory_unit__id`) REFERENCES `idoit_data`.`isys_memory_unit` (`isys_memory_unit__id`) ON DELETE SET NULL ON UPDATE NO ACTION; ------- ALTER TABLE `isys_contact_data_item` ADD CONSTRAINT `isys_contact_data_item_ibfk_5` FOREIGN KEY (`isys_contact_data_item__isys_organisation_intern_iop__id`) REFERENCES `isys_organisation_intern_iop` (`isys_organisation_intern_iop__id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `isys_contact_data_item_ibfk_1` FOREIGN KEY (`isys_contact_data_item__isys_group__id`) REFERENCES `isys_group` (`isys_group__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_contact_data_item_ibfk_2` FOREIGN KEY (`isys_contact_data_item__isys_person_extern__id`) REFERENCES `isys_person_extern` (`isys_person_extern__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_contact_data_item_ibfk_3` FOREIGN KEY (`isys_contact_data_item__isys_person_intern__id`) REFERENCES `isys_person_intern` (`isys_person_intern__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_contact_data_item_ibfk_4` FOREIGN KEY (`isys_contact_data_item__isys_contact__id`) REFERENCES `isys_contact` (`isys_contact__id`) ON DELETE CASCADE ON UPDATE NO ACTION; ALTER TABLE `isys_file_version` ADD CONSTRAINT `isys_file_version_ibfk_1` FOREIGN KEY (`isys_file_version__isys_file_physical__id`) REFERENCES `isys_file_physical` (`isys_file_physical__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_file_version_ibfk_2` FOREIGN KEY (`isys_file_version__isys_obj__id`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE `isys_group_2_isys_module` ADD CONSTRAINT `isys_group_2_isys_module_ibfk_1` FOREIGN KEY (`isys_group_2_isys_module__isys_module__id`) REFERENCES `isys_module` (`isys_module__id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `isys_group_2_isys_module_ibfk_2` FOREIGN KEY (`isys_group_2_isys_module__isys_role__id`) REFERENCES `isys_role` (`isys_role__id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `isys_group_2_isys_module_ibfk_3` FOREIGN KEY (`isys_group_2_isys_module__isys_group__id`) REFERENCES `isys_group` (`isys_group__id`) ON DELETE CASCADE ON UPDATE NO ACTION; ALTER TABLE `isys_group_2_isys_user_session` ADD CONSTRAINT `isys_group_2_isys_user_session_ibfk_1` FOREIGN KEY (`isys_group_2_isys_user_session__isys_group__id`) REFERENCES `isys_group` (`isys_group__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_group_2_isys_user_session_ibfk_2` FOREIGN KEY (`isys_group_2_isys_user_session__isys_user_session__id`) REFERENCES `isys_user_session` (`isys_user_session__id`) ON DELETE CASCADE ON UPDATE NO ACTION; ALTER TABLE `isys_obj_type` ADD CONSTRAINT `isys_obj_type_ibfk_3` FOREIGN KEY (`isys_obj_type__default_template`) REFERENCES `isys_obj` (`isys_obj__id`) ON DELETE SET NULL ON UPDATE SET NULL, ALTER TABLE `isys_person_extern` ADD CONSTRAINT `isys_person_extern_ibfk_1` FOREIGN KEY (`isys_person_extern__isys_source_extern__id`) REFERENCES `isys_source_extern` (`isys_source_extern__id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE `isys_user_setting` ADD CONSTRAINT `isys_user_setting_ibfk_1` FOREIGN KEY (`isys_user_setting__isys_person_extern__id`) REFERENCES `isys_person_extern` (`isys_person_extern__id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `isys_user_setting_ibfk_2` FOREIGN KEY (`isys_user_setting__isys_person_intern__id`) REFERENCES `isys_person_intern` (`isys_person_intern__id`) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE `isys_workflow_action_parameter` ADD CONSTRAINT `isys_workflow_action_parameter_ibfk_2` FOREIGN KEY (`isys_workflow_action_parameter__isys_wf_template_parameter__id`) REFERENCES `isys_workflow_template_parameter` (`isys_workflow_template_parameter__id`), ADD CONSTRAINT `isys_workflow_action_parameter_ibfk_1` FOREIGN KEY (`isys_workflow_action_parameter__isys_workflow_action__id`) REFERENCES `isys_workflow_action` (`isys_workflow_action__id`);