title: Sugar ORM Migration: Create new table drops/re-creates existing tables
body: <p>I used SugarORM in my application's first release.
  Now, I'm working on the 2nd release, which has new tables added to DB.</p>
  
  <p>According to SugarORM <a href="http://satyan.github.io/sugar/migration.html" rel="noreferrer">documentation</a> "Sugar will automatically create tables for new entities, so your migration script only needs to cater for alterations to existing tables."</p>
  
  <p>Here's what I done:</p>
  
  <ol>
  <li>Increased the DB version in the AndroidManifest <code>&lt;meta-data android:name="VERSION" android:value="2" /&gt;</code></li>
  <li>Created the new record class. <code>public class NewModel extends SugarRecord&lt;NewModel&gt;</code></li>
  </ol>
  
  <p>When ran the app, Sugar created the new table, but unfortunately, it also dropped/created existing tables, erasing all data saved locally!</p>
  
  <p>I also tried to create the new table myself, by adding a migration script file <code>2.sql</code> which contains my <code>CREATE TABLE NEW_MODEL</code> statement. Unfortunately too, it threw an exception "Table already exists" because Sugar created the new table and then tried to run my script!</p>
  
  <p>Any suggestions?</p>