Sqlite table and database migrations on Published app?

Hello! I have made some modifications on my SQLite DB tables locally.

Suppose, before the schema of a table was like this:

CREATE TABLE expenditures (id integer primary key, max_amount REAL not null);

And now I would like to change it to this:

CREATE TABLE expenditures (id integer primary key, max_amount TEXT not null);

Is there any way to run a method after a new update/upgrade on a production app (google play store)? That way I can alter the tables only once after the upgrade. Or is there any better way to handle database migrations on a published app?

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.