On 26 Feb 2016, at 2:22pm, Tristan Seligmann <mithrandi at mithrandi.net> wrote:
> PRAGMA writable_schema=on; > UPDATE sqlite_master SET sql='CREATE TABLE some_table_name (..., storeID > INTEGER PRIMARY KEY)' WHERE tbl_name='some_table_name'; I thought I knew where it was documented but I can't find it at the moment. The idea is that if you have given the column an explicit name (in your case 'storeID') then you might be referring to it in your code, so SQLite shouldn't change the values. That should work correctly in the current and all future versions of SQLite3. It's an assumption lots of programmers make. Simon.
