Do we have any documentation on how to create a new table on an existing database and add a new column in sqlite sqlx rust?

[LeafWarrior]

Hi guys, I've been searching for days yet again. I can't find the answer.

I'm trying to figure out how to create a new table from my existing sqlite database and add a foreign key to my existing table (referencing the new table).

I've read somewhere that you need to update the schema version number but there's hardly any syntaxes for it online.

Any help would be much appreciated.

I'm using sqlx sqlite for my database, rust for backed and javascript for frontend.