Cacher is the code snippet organizer for pro developers

@Override

public final static   String CREATE_BOOK_TABLE = "CREATE TABLE books ( " +
            "id INTEGER PRIMARY KEY AUTOINCREMENT, " +
            "title TEXT, " +
            "author TEXT, " +
            "sales INTEGER )";


public void onCreate(SQLiteDatabase db) {

    // create books table
    db.execSQL(CREATE_BOOK_TABLE);
}

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  db.execSQL("DROP TABLE IF EXISTS" + TABLE_TODO);
  onCreate(db);
}