title: android sqlite create statement not working
body: <p>this code checks if a database exists and if not opens it and creates a table. but afterwards, trying to read from the table causes a no such table exception.</p>
  
  <pre><code>public class MuscleActivity extends AppCompatActivity {
  
  SQLiteDatabase fitnessdb;
  
  @Override
  protected void onCreate(Bundle savedInstanceState) {
      super.onCreate(savedInstanceState);
      setContentView(R.layout.activity_muscle);
      if (!getApplicationContext().getDatabasePath("fitnessdb").exists()) ;
      {
          createDB();
      }
      Cursor resultSet = fitnessdb.rawQuery("SELECT * FROM exercises", null);
      resultSet.moveToFirst();
      Log.d("stat", resultSet.getString(0));
  }
  
  
  public void createDB() {
      fitnessdb = openOrCreateDatabase("fitnessdb", MODE_PRIVATE, null);
      fitnessdb.execSQL("CREATE TABLE IF NOT EXISTS \"exercices\" (\"_id\"\tINTEGER PRIMARY KEY AUTOINCREMENT,\"name\" TEXT,\"muscle_group\" TEXT,\"reps\" INTEGER,\"img1\"\tTEXT,\"img2\" TEXT,\"info\"\tTEXT);");
  }
  }
  </code></pre>