create-drop-custom-table-wordpress

<?php
// Создание
function create_custom_table()
{
    global $wpdb;
    require_once ABSPATH . 'wp-admin/includes/upgrade.php';
    $table_name = $wpdb->prefix . 'test_table';
    $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate}";
    $sql = "CREATE TABLE {$table_name} (
        id  bigint(20) unsigned NOT NULL auto_increment,
        address varchar(255) NOT NULL default '',
        alert varchar(20) NOT NULL default '',
        meta longtext NOT NULL default '',
        PRIMARY KEY  (id),
        KEY alert (alert)
    )
    {$charset_collate}";
    dbDelta($sql);
}
create_custom_table();
    
// Создание
function drop_custom_table()
{
    global $wpdb;
    $table_name = $wpdb->prefix . 'test_table';
    $wpdb->query("DROP TABLE IF EXISTS {$table_name} ");
}
drop_custom_table();