text: ALTER TABLE game_player_map ADD is_button_random BOOLEAN DEFAULT FALSE NOT NULL;
  
  DROP VIEW IF EXISTS button_view;
  CREATE VIEW button_view
  AS SELECT b.id, b.name, b.recipe, b.tourn_legal, b.btn_special,
            b.flavor_text, s.name AS set_name, s.id AS set_id
  FROM button AS b
  LEFT JOIN buttonset AS s
  ON b.set_id = s.id
  ORDER BY b.set_id, b.id;
  
  DROP VIEW IF EXISTS game_player_view;
  CREATE VIEW game_player_view
  AS SELECT
      m.game_id,
      m.player_id,
      m.button_id,
      m.alt_recipe,
      m.position,
      m.did_win_initiative,
      m.is_awaiting_action,
      m.n_rounds_won,
      m.n_rounds_lost,
      m.n_rounds_drawn,
      m.handicap,
      m.is_player_hidden,
      m.last_action_time,
      m.was_game_dismissed,
      m.is_button_random,
      p.name_ingame AS player_name,
      p.autopass,
      b.name AS button_name,
      g.n_target_wins
  FROM game_player_map AS m
  LEFT JOIN player AS p
  ON m.player_id = p.id
  LEFT JOIN button AS b
  ON m.button_id = b.id
  LEFT JOIN game AS g
  ON m.game_id = g.id;
  