title: Update a database table without losing data in Android
body: <p>I have some basic questions about mobile app database management. I have searched for it but can not find answers to my questions.</p>
  
  <p>Suppose that I have a <strong>Sports</strong> table including some sport names which will be same for every user. When a user does a sport, the workout will be added to the <strong>Workouts</strong> table. So, Workouts table is spesific for every user. </p>
  
  <p><strong>1. Tables in a user's phone</strong></p>
  
  <p><a href="https://i.stack.imgur.com/lssYX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lssYX.png" alt="enter image description here"></a>
  So, what if I want to add 1 more sport in Sports table and release an update? I can update Sports table in <strong>onUpgrade</strong> method. </p>
  
  <p><strong>2. New version of Sports table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/e1pCK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/e1pCK.png" alt="enter image description here"></a></p>
  
  <p><strong>Question:</strong> Do <strong>Workouts</strong> tables in <strong>everyone's</strong> phone change according to the new <strong>Sports</strong> table? (Remember that <strong>Workouts</strong> table is different for every user)</p>
  
  <p><a href="https://i.stack.imgur.com/ah7lw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ah7lw.png" alt="enter image description here"></a></p>
  
  <p>I know this was a really long post for this question but I wanted to explain everything. Thank you in advance.</p>