Hello DongInn, I have a question about cascaded deletions in INNODB:
Suppose we have: - in table Packages a record: (id=1, package=apitest, version=1.0, ...) - in Node_Package_Status a linked record: (old style, to avoid rants ;-) (node_id=10, package_id=1, current,error,requested,curr,status,ex_status, selected,errorMsg,client_nodes) [listed all fields, which are mostly unused. I think less but with clear meaning would be nicer] Packages.id and Node_Package_Status.package_id are linked through INNO-DB. Does the ON DELETION CASCADE mean that when I delete the record with id=1 in Packages the corresponding record (package_id=1) in the Node_Package_Status table? Do we want that? IMO this would be wrong behavior, as it means that if for some reason the record in Packages is deleted (for example when adding a record with new version), we lose the valid record in Node_Package_Status and nobody can tell that the apitest package was selected/installed on that particular node. Thanks, best regards, Erich ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Oscar-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/oscar-devel
