wc_update_352_drop_download_log_fk() WC 1.0
Drop the fk_wc_download_log_permission_id FK as we use a new one with the table and blog prefix for MS compatability.
No Hooks.
Return
null.
Usage
wc_update_352_drop_download_log_fk();
Code of wc_update_352_drop_download_log_fk() wc update 352 drop download log fk WC 5.0.0
function wc_update_352_drop_download_log_fk() {
global $wpdb;
$results = $wpdb->get_results(
"SELECT CONSTRAINT_NAME
FROM information_schema.TABLE_CONSTRAINTS
WHERE CONSTRAINT_SCHEMA = '{$wpdb->dbname}'
AND CONSTRAINT_NAME = 'fk_wc_download_log_permission_id'
AND CONSTRAINT_TYPE = 'FOREIGN KEY'
AND TABLE_NAME = '{$wpdb->prefix}wc_download_log'"
);
// We only need to drop the old key as WC_Install::create_tables() takes care of creating the new FK.
if ( $results ) {
$wpdb->query( "ALTER TABLE {$wpdb->prefix}wc_download_log DROP FOREIGN KEY fk_wc_download_log_permission_id" ); // phpcs:ignore WordPress.WP.PreparedSQL.NotPrepared
}
}