public static function build_upgrade($old_output_prefix, $old_composite_file, $old_db_doc, $old_files, $new_output_prefix, $new_composite_file, $new_db_doc, $new_files)
{
// place the upgrade files with the new_files set
$upgrade_prefix = $new_output_prefix . '_upgrade';
// mysql5_diff needs these to intelligently create SQL difference statements in dependency order
dbsteward::info("Calculating old table foreign key dependency order..");
mysql5_diff::$old_table_dependency = xml_parser::table_dependency_order($old_db_doc);
dbsteward::info("Calculating new table foreign key dependency order..");
mysql5_diff::$new_table_dependency = xml_parser::table_dependency_order($new_db_doc);
mysql5_diff::diff_doc($old_composite_file, $new_composite_file, $old_db_doc, $new_db_doc, $upgrade_prefix);
return $new_db_doc;
}
