new_contents: import sqlite3
  import json
  
  conn = sqlite3.connect('nflpool.sqlite')
  cur = conn.cursor()
  
  # Do some setup
  cur.executescript('''
  DROP TABLE IF EXISTS picks;
  
  CREATE TABLE picks (
      firstname    TEXT NOT NULL,
      lastname    TEXT NOT NULL,
      id  INTEGER NOT NULL PRIMARY KEY UNIQUE,
      season TEXT NOT NULL UNIQUE,
      email TEXT NOT NULL UNIQUE,
      timestamp TEXT NOT NULL,
      afc_east_first_pick TEXT NOT NULL,
      afc_east_second_pick TEXT NOT NULL,
      afc_east_last_pick TEXT NOT NULL,
      afc_north_first_pick TEXT NOT NULL,
      afc_north_second_pick TEXT NOT NULL,
      afc_north_last_pick TEXT NOT NULL,
      afc_south_first_pick TEXT NOT NULL,
      afc_south_second_pick TEXT NOT NULL,
      afc_south_last_pick TEXT NOT NULL,
      afc_west_first_pick TEXT NOT NULL,
      afc_west_second_pick TEXT NOT NULL,
      afc_west_last_pick TEXT NOT NULL,
      nfc_east_first_pick TEXT NOT NULL,
      nfc_east_second_pick TEXT NOT NULL,
      nfc_east_last_pick TEXT NOT NULL,
      nfc_north_first_pick TEXT NOT NULL,
      nfc_north_second_pick TEXT NOT NULL,
      nfc_north_last_pick TEXT NOT NULL,
      nfc_south_first_pick TEXT NOT NULL,
      nfc_south_second_pick TEXT NOT NULL,
      nfc_south_last_pick TEXT NOT NULL,
      nfc_west_first_pick TEXT NOT NULL,
      nfc_west_second_pick TEXT NOT NULL,
      nfc_west_last_pick TEXT NOT NULL,
      afc_wildcard1_pick TEXT NOT NULL,
      afc_wildcard2_pick TEXT NOT NULL,
      nfc_wildcard1_pick TEXT NOT NULL,
      nfc_wildcard2_pick TEXT NOT NULL,
      afc_rushing_leader_pick TEXT NOT NULL,
      afc_passing_leader_pick TEXT NOT NULL,
      afc_receiving_leader_pick TEXT NOT NULL,
      afc_sacks_leader_pick TEXT NOT NULL,
      afc_int_leader_pick TEXT NOT NULL,
      nfc_rushing_leader_pick TEXT NOT NULL,
      nfc_passing_leader_pick TEXT NOT NULL,
      nfc_receiving_leader_pick TEXT NOT NULL,
      nfc_sacks_leader_pick TEXT NOT NULL,
      nfc_int_leader_pick TEXT NOT NULL,
      afc_pf_pick TEXT NOT NULL,
      nfc_pf_pick TEXT NOT NULL,
      tiebreaker_pick TEXT NOT NULL
  
  
  )
  
  ''')
  conn.commit()
  conn.close()
  
  # TODO Make primary key autoincrement - or can email be used as the key?
  
subject: Add create_player_picks_table.py to create the table to store all of the picks by each player in NFLPool