java - Updating an application in Playstore

Question

I'm new to android development, I developed an application that has a form (name, address) stored in a SQLite database, that's for the first version. In the second version I add an email field. I would like to ask how I did to make the update for the data stored on the first version are not destroyed when I made an upgrad to the second version.

Thank you!

Answer 1

If you're using the SQLHelper class, update the version, and in the onUpdate function perform an ALTER TABLE sql command to add the email field. You'll have to make it a nullable field, as the existing rows won't have it. Then, if you have it, send UPDATE commands to add the emails to the rows.