Wordpress required plugin functions with create and delete a database table 15.11.19

register_activation_hook( __FILE__, 'foo_activate' );
function foo_activate()
{
  global $wpdb;
  $db_table = $wpdb->prefix . 'foo';
  $collate = '';

if ( $wpdb->has_cap( 'collation' ) ):
    $collate = $wpdb->get_charset_collate();
  endif;

$sql = '';
  $sql .= "CREATE TABLE IF NOT EXISTS {$db_table} ";
  $sql .= "(`id` INT(10) AUTO_INCREMENT PRIMARY KEY";
  $sql .= ",`fingerprint` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ";
  $sql .= ",`expire_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00')  {$collate}";
  //var_dump($sql);exit;                                                                                                                                                                                                                       
  dbDelta( $sql );

}

register_deactivation_hook( __FILE__, 'foo_deactivate' );
function foo_deactivate()
{
}

register_uninstall_hook( __FILE__, 'foo_uninstall' );
function foo_uninstall()
{
 global $wpdb;
 $db_table = $wpdb->prefix . 'foo';
 $wpdb->query( "DROP TABLE IF EXISTS {$db_table}" );
 delete_option("my_plugin_db_version");
}

https://wordpress.stackexchange.com/questions/169145/delete-tables-from-database-when-deleting-plugin

Anonymous

Wordpress required plugin functions with create and delete a database table 15.11.19

Information Epoch 1773158548