title: How to update your android sql database without crashing the app
body: <p>My Database is currently at version 1 , I however have an app on the app store and I added a column for my new updates and I know I have to update my database or else when I sent my app for updates it will crash other users apps, how do I upgrade my database safely without crashing the app, I tried running the old version on my phone and the new upgrade using this code after I incremented but it keeps crashing without an error code. How can I upgrade my Database without destroying other users installed app on the app store safely?</p>
  
  <p>My Database Class:</p>
  
  <pre><code>Error:
  
       Caused by: android.database.sqlite.SQLiteException: table items already exists (code 1): , while compiling: CREATE TABLE items (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, type TEXT NOT NULL, logo INTEGER NOT NULL DEFAULT 0, color INTEGER NOT NULL DEFAULT 0, created_date DATE NOT NULL DEFAULT CURRENT_TIMESTAMP);
          #################################################################
          Error Code : 1 (SQLITE_ERROR)
          Caused By : SQL(query) error or missing database.
              (table items already exists (code 1): , while compiling: CREATE TABLE items (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, type TEXT NOT NULL, logo INTEGER NOT NULL DEFAULT 0, color INTEGER NOT NULL DEFAULT 0, created_date DATE NOT NULL DEFAULT CURRENT_TIMESTAMP);)
          #################################################################
  </code></pre>