SQLite Forum

New version of app, more columns for same table
Sorry -- that was not my intention. The question was unclear for multiple reasons.

Section 2.1 in the page I linked says: "A record might have fewer values than the number of columns in the corresponding table. This can happen, for example, after an ALTER TABLE ... ADD COLUMN SQL statement has increased the number of columns in the table schema without modifying preexisting rows in the table. Missing values at the end of the record are filled in using the default value for the corresponding columns defined in the table schema."

That seems to touch upon several elements within your first post.