Wordpress插件数据库创建-如何在插件激活时向表中添加多个“唯一键”

global $wpdb;
$table_name = $wpdb->prefix . 'your_table_name';
$charset_collate = $wpdb->get_charset_collate();

$sql = "CREATE TABLE $table_name (
    id mediumint(9) NOT NULL AUTO_INCREMENT,
    column1 varchar(255) NOT NULL,
    column2 varchar(255) NOT NULL,
    UNIQUE KEY id (id),
    UNIQUE KEY column1 (column1),
    UNIQUE KEY column2 (column2),
    PRIMARY KEY  (id)
) $charset_collate;";

require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
dbDelta( $sql );

global $wpdb;
$table_name = $wpdb->prefix . 'your_table_name';

$data = array(
    'column1' => 'value1',
    'column2' => 'value2'
);

$wpdb->insert( $table_name, $data );