Skip to content

Instantly share code, notes, and snippets.

@manchumahara
Created September 7, 2017 21:33
Show Gist options
  • Save manchumahara/aaecec06d1b4280ff746f5c673ec54bf to your computer and use it in GitHub Desktop.
Save manchumahara/aaecec06d1b4280ff746f5c673ec54bf to your computer and use it in GitHub Desktop.
global $wpdb;
//old name
$table_booking_logs_old = $wpdb->prefix . 'rbookinglogs';
$table_branch_manager_old = $wpdb->prefix . 'branch_manager';
//new name
$table_booking_logs = $wpdb->prefix . 'cbxrbooking_log_manager';
$table_branch_manager = $wpdb->prefix . 'cbxrbooking_branch_manager';
//start name process
//rename log table
if($wpdb->get_var("SHOW TABLES LIKE '$table_booking_logs_old'") === $table_booking_logs_old) {
//Your code here
$wpdb->query("RENAME TABLE $table_booking_logs_old TO $table_booking_logs");
}
//rename branch manager table
if($wpdb->get_var("SHOW TABLES LIKE '$table_branch_manager_old'") === $table_branch_manager_old) {
//Your code here
$wpdb->query("RENAME TABLE $table_branch_manager_old TO $table_branch_manager");
}
//end rename process
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment