Disable foreign key checks when dropping tables inside wp_uninitialize_site() function

[naveen17797]

By default when removing the tables from a subsite, if the table has foreign key constraint it wont drop the table resulting in tables not being removed.

so this line should be changed from this to

	foreach ( (array) $drop_tables as $table ) {
		$wpdb->query( "DROP TABLE IF EXISTS `$table`" ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
	}

<?php

    $wpdb->query('SET FOREIGN_KEY_CHECKS=0;');
        foreach ( (array) $drop_tables as $table ) {
                $wpdb->query( "DROP TABLE IF EXISTS `$table`" ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
        }
    $wpdb->query('SET FOREIGN_KEY_CHECKS=1;');

or any other better alternative.

Link to track ticket: https://core.trac.wordpress.org/ticket/57385