Sqlite database not accessible after change of bundle identifier

Noticed the strangest behavior today.

After I changed the bundle identifier in my XCode project, the sqlite database no longer had the tables I'd created before. Changing the bundle identifier back made the tables accessible again. Even from the command line interface they had disappeared.

The way to resolve it was to re-enter the data :\

Not sure why this happened or how it could be easier to migrate the data over yet. I need to investigate this more.

2 Column (or multiple columns) Primary Key in Sqlite

To create a table with 2 (or multiple/more) column primary keys in sqlite:

CREATE TABLE table1 (column1 INTEGER, column2 INTEGER, column3 VARCHAR(255), PRIMARY KEY (column1, column2));