def create_table(db, table, cols):

    '''Creates a table.

    * The first column becomes the primary key.

    * Each column gets an index.

    @param cols [sql_gen.TypedCol,...] The column names and types.

    '''

    table = sql_gen.as_Table(table)

    pkey = cols.pop(0)

    str_ = 'CREATE TABLE '+table.to_str(db)+' (\n'

    str_ += '    '+pkey.to_str(db)+' NOT NULL PRIMARY KEY\n'

    for col in cols: str_ += '    , '+col.to_str(db)+'\n'

    str_ += ');\n'

    run_query(db, str_, cacheable=True, log_level=2)

    for col in cols: add_index(db, sql_gen.Col(col.name, table))