how to insert and get unique id in sqlite for each row?

$cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS people (id integer primary key autoincrement, firstname text,middlename text, lastname text)");