0.9.9 - Tabellen, die beim Update Probleme gemacht haben

[crispp]

Vielleicht hilft es jemandem: die folgenden Tabellen (in den SQL-Statements ablesbar) haben bei mir beim Update einiger Mandanten Probleme gemacht - durch die Modifikationen, die nach und nach eingespielt werden müssen, war das Update dann möglich - sauber sind die Datenbanken dadurch dann aber nicht.

alter table isys_catp_ip_list
add CONSTRAINT isys_catp_ip_list_ibfk_2 FOREIGN KEY (isys_catp_ip_list__isys_ip_assignment__id) REFERENCES isys_ip_assignment (isys_ip_assignment__id) ON DELETE NO ACTION ON UPDATE NO ACTION;

alter table isys_catp_ip_list
add  CONSTRAINT isys_catp_ip_list_ibfk_1 FOREIGN KEY (isys_catp_ip_list__isys_catp_ip__id) REFERENCES isys_catp_ip (isys_catp_ip__id) ON DELETE NO ACTION ON UPDATE NO ACTION;

DROP TABLE IF EXISTS isys_catg_odep_list;
SET @saved_cs_client    = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE isys_catg_odep_list (
  isys_catg_odep_list__id int(10) unsigned NOT NULL auto_increment,
  isys_catg_odep_list__isys_catg_odep__id int(10) unsigned default '0',
  isys_catg_odep_list__isys_dependency__id int(10) unsigned default NULL,
  isys_catg_odep_list__title varchar(255) collate utf8_unicode_ci default NULL,
  isys_catg_odep_list__description text collate utf8_unicode_ci,
  isys_catg_odep_list__status int(10) unsigned default '2',
  isys_catg_odep_list__property int(10) unsigned default '0',
  PRIMARY KEY  (isys_catg_odep_list__id),
  KEY isys_catg_odep_list_FKIndex1 (isys_catg_odep_list__isys_dependency__id),
  KEY isys_catg_odep_list_FKIndex2 (isys_catg_odep_list__isys_catg_odep__id),
  CONSTRAINT isys_catg_odep_list_ibfk_1 FOREIGN KEY (isys_catg_odep_list__isys_dependency__id) REFERENCES isys_dependency (isys_dependency__id) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT isys_catg_odep_list_ibfk_2 FOREIGN KEY (isys_catg_odep_list__isys_catg_odep__id) REFERENCES isys_catg_odep (isys_catg_odep__id) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=744 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET character_set_client = @saved_cs_client;

alter table isys_dependency
add  CONSTRAINT isys_dependency_ibfk_1 FOREIGN KEY (isys_dependency__isys_obj__id__slave) REFERENCES isys_obj (isys_obj__id)  ON DELETE NO ACTION ON UPDATE NO ACTION;

alter table isys_dependency
add  CONSTRAINT isys_dependency_ibfk_2 FOREIGN KEY (isys_dependency__isys_obj__id__master) REFERENCES isys_obj (isys_obj__id) ON DELETE NO ACTION 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;

alter table isys_file_version
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_cats_lic_group
add  CONSTRAINT isys_cats_lic_group_ibfk_1 FOREIGN KEY (isys_cats_lic_group__isys_cats_lic_list__id) REFERENCES isys_cats_lic_list (isys_cats_lic_list__id) ON DELETE NO ACTION ON UPDATE NO ACTION

alter table isys_cats_group_list
ADD column isys_cats_group_list__isys_cats_distributor__id INT( 10 ) NOT NULL

alter table isys_cats_group_list
add  KEY isys_cats_group_list__isys_cats_distributor__id__FKIndex (isys_cats_group_list__isys_cats_distributor__id)

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)

alter table isys_file_version
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_nagios_contacts
add  CONSTRAINT isys_nagios_contacts__isys_person_intern__id__FK FOREIGN KEY (isys_nagios_contacts__isys_person_intern__id) REFERENCES isys_person_intern (isys_person_intern__id) ON DELETE NO ACTION ON UPDATE NO ACTION;

alter table isys_catg_nagios_list
add  CONSTRAINT isys_catg_nagios_list__isys_nagios_ndo__ndodb_id__FK FOREIGN KEY (isys_catg_nagios_list__isys_nagios_ndo__ndodb_id) REFERENCES isys_nagios_ndo (isys_nagios_ndo__ndodb_id) ON DELETE NO ACTION ON UPDATE NO ACTION;

alter table isys_catg_nagios_list
add  CONSTRAINT isys_catg_nagios_list__notification_period__FK FOREIGN KEY (isys_catg_nagios_list__notification_period) REFERENCES isys_nagios_timeperiods (isys_nagios_timeperiods__id) ON DELETE SET NULL;

[rgarcia]

Siehe hier im dem Thread ist alles bereits besprochen worden:
http://www.i-doit.org/forum/index.php/topic,1356.0.html