Quick SQLite-specific question... Say, if I create this table...

CREATE TABLE foo (
    foo_id INTEGER PRIMARY KEY,
    fname TEXT,
    lname TEXT
);

...will SQLite automatically create a primary key index for the foo_id column or do I have to manually create that index? I'm asking because sqlite_master is not showing an index...

sqlite> SELECT * FROM sqlite_master;
type   name  tbl_name  rootpage  sql                                                                    
-----  ----  --------  --------  -----------------------------------------------------------------------
table  foo   foo       2         CREATE TABLE foo (
foo_id INTEGER PRIMARY KEY,
fname TEXT,
lname TEXT
)

However, if I create a similar table with a PRIMARY KEY (without an INTEGER column)...

CREATE TABLE bar (
    bar_id TEXT PRIMARY KEY,
    fname TEXT,
    lname TEXT
);

...then, the primary key index is automatically created by SQLite...

sqlite> select * from sqlite_master;
type   name                    tbl_name         rootpage  sql
-----  ----  --------  --------  -----------------------------------------------------------------------
table  bar                     bar              516381    CREATE TABLE bar (
    bar_id TEXT PRIMARY KEY,
    fname TEXT,
    lname TEXT
)                                                                                                             
index  sqlite_autoindex_bar_1  bar              516382