Re: [sqlite] Best way to ALTER COLUMN ADD multiple tables if the columns don't already exist

2019-04-23 Thread Jens Alfke
> On Apr 22, 2019, at 6:37 PM, Tommy Lane wrote: > > How would I go about updating an existing table to also have a > parent integer and child integer column. Use `pragma user_version` to get/set a schema version number in your database. It defaults to zero. Associate each schema chang

[sqlite] Best way to ALTER COLUMN ADD multiple tables if the columns don't already exist

2019-04-22 Thread Tommy Lane
Hi all, I'm still working on this journal app and ran across a need to update our table schema, I want my entries to be _essentially_ immutable. My solution to this problem is a linked list type dependency where each entry has a parent and a child, which corresponds to an entry's past and f