Creating an SQLite table only if it doesn't already exist

You can use:

CREATE TABLE IF NOT EXISTS <name> (
  /* definition */
)

Which is supported by SQLite (http://www.sqlite.org/syntaxdiagrams.html#create-table-stmt)

CREATE TABLE IF NOT EXISTS ...

Use IF NOT EXISTS.