sqlite> create table foo (pk integer primary key not null, bar text);
sqlite> insert into foo values (10,'ten');
sqlite> insert into foo values (20,'twenty');
sqlite> select rowid, pk, bar from foo;
10|10|ten
20|20|twenty
sqlite> insert into foo values ('thirty','thirty');
Error: datatype mismatch
sqlite> insert into foo values (30,30);
sqlite> select rowid, pk, bar from foo;
10|10|ten
20|20|twenty
30|30|30

sqlite> alter table foo add column baz integer;
sqlite> insert into foo values (40,40,'forty');
sqlite> select rowid, pk, bar, baz from foo;
10|10|ten|
20|20|twenty|
30|30|30|
40|40|40|forty