所以我试图建立一个数据库，用于在add_menu_page(). I\'m using this on a custom parent theme

现在我已经有了这个（目前在我的functions.php):

function countriesDB_init()
{
    global $wpdb;
    $table_name = $wpdb->prefix . \'designitcountries\';

    //create table (if it doesnt exist)

    $charset_collate = $wpdb->get_charset_collate();

    $sql = "CREATE TABLE" . " " . $table_name . "(
  id mediumint(9) NOT NULL AUTO_INCREMENT,
  time datetime DEFAULT \'0000-00-00 00:00:00\' NOT NULL,
  name tinytext NOT NULL,
  text text NOT NULL,
  url varchar(55) DEFAULT \'\' NOT NULL,
  PRIMARY KEY  (id)
) $charset_collate;";

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

        $name = \'Sukru Kintas\';
        $title = \'President\';
        $country = \'World all hapkido association\';

        $wpdb->insert(
            $table_name,
            array(
                \'time\' => current_time(\'mysql\'),
                \'title\' => $title,
                \'name\' => $name,
                \'country\' => $country
            )
        );
}
do_action( \'after_switch_theme\', \'countriesDB_init\' );

WP_DEBUG log

WordPress database-fout: [Table \'ID203293_lacroix.wp_designitcountries\' doesn\'t exist]
SELECT COUNT(word) AS occurrence, word FROM `wp_designitcountries` GROUP BY word ORDER BY occurrence DESC

WordPress database-fout: [Table \'ID203293_lacroix.wp_designitcountries\' doesn\'t exist]
SELECT COUNT(word) AS occurrence, word FROM `wp_designitcountries` GROUP BY word ORDER BY occurrence DESC

WordPress database-fout: [Table \'ID203293_lacroix.wp_designitcountries\' doesn\'t exist]
SELECT COUNT(word) AS occurrence, word FROM `wp_designitcountries` GROUP BY word ORDER BY occurrence DESC

WordPress database-fout: [Table \'ID203293_lacroix.wp_designitcountries\' doesn\'t exist]
SELECT COUNT(word) AS occurrence, word FROM `wp_designitcountries` GROUP BY word ORDER BY occurrence DESC

WordPress database-fout: [Table \'ID203293_lacroix.wp_designitcountries\' doesn\'t exist]
SELECT COUNT(word) AS occurrence, word FROM `wp_designitcountries` GROUP BY word ORDER BY occurrence DESC

WordPress database-fout: [Table \'ID203293_lacroix.wp_designitcountries\' doesn\'t exist]
SELECT COUNT(word) AS occurrence, word FROM `wp_designitcountries` GROUP BY word ORDER BY occurrence DESC