Create table with dbDelta,can’t put any DEFAULT data

by

  1. It appears as though you’re altering the users table – this is a WordPress core table (if using the wp_ prefix) and this is probably not a good idea – create a separate table with an ID foreign key to avoid potential problems.
  2. Use $wpdb->prefix to get the prefix that’s actually being used on a given WordPress installation (you can’t depend upon it being wp_, it’s configurable)

  3. dbDelta() is very particular but it should accept a default value; assign the results of dbDelta() to a variable to see what’s happening:

    $result = dbDelta($game_1);
var_dump( $result );