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