Why is the sql query not working?

Question

MySQL

I want to add a new field in the wp_posts table when activating the plugin in WordPress.

register_activation_hook( __FILE__, 'wfm_create_field' );
function wfm_create_field(){
    global $wpdb;

    $query = "ALTER TABLE $wpdb->posts ADD 'wfm_views' INT NOT NULL DEFAULT '0'";

    $wpdb->query($query);
}

Here is the request from phpmyadmin

ALTER TABLE `wp_posts` ADD `wfm_veiws` INT(100) NOT NULL DEFAULT '0' AFTER `comment_count`;

And it gives an error incorrect default value
Here is the data

and here is the error

How to solve?
Thanks in advance.

Answer 1

Issue resolved.
Changed the entry
Removed quotes from wfm_views.
The only question left is why this code in phpmyadmin does not work?
And I found a solution to this question
. It worked only after I set the default value for post_date post_date_gmt post_date_modified post_date_modified_gmt.