Is there a better solution to create a database table for a WordPress Plugin? How can I simplify this query? What code improvements could be made in this code? Any ideas would be great.register_activation_hook(__FILE__, 'my_plugin_create_db');function my_plugin_create_db() {    global $wpdb;    $name = 'my_table';    $charset_collate = $wpdb->get_charset_collate();    $table_name = $wpdb->prefix . $name;    $sql = CREATE TABLE $table_name(            . id int(9) NOT NULL AUTO_INCREMENT,            . time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,            . views int(9) NOT NULL,            . clicks int(9) NOT NULL,            . UNIQUE KEY id (id)            . )$charset_collate;;    require_once( ABSPATH . 'wp-admin/includes/upgrade.php');    dbDelta($sql);}
Database table for WordPress plugin
javascript;mysql;wordpress