Creating a database in my plugin not working

You have syntax error. You don’t need single quote for column name.

You can use phpmyadmin to test MySQL queries.

$sql = "CREATE TABLE IF NOT EXISTS $table_name (
    id INT(6) NOT NULL AUTO_INCREMENT ,
    user_id TEXT NOT NULL,
    full_name TEXT NOT NULL,
    email TEXT NOT NULL,
    invoiceNumber TEXT NOT NULL,
    plan_type TEXT NOT NULL,
    date TEXT NOT NULL,
    membership_type TEXT NOT NULL,
    plan_price INT NOT NULL,
    currency TEXT NOT NULL,
    payment_method TEXT NOT NULL,
    status TEXT NOT NULL,
    PRIMARY KEY  (id)
    )";