def add_columns(header, c, clear=False):
    """
    add any missing columns to the samples table
    """
    for column in header:
        try:
            c.execute('ALTER TABLE samples ADD COLUMN {0} TEXT'.format(column))
        except:
            pass
        if clear:
            c.execute('UPDATE samples set {0} = NULL;'.format(column))
