Making Executable Sqlite Comands Android

While learning the basics of Sqlite I continue to stumble across the same problem of understanding how sqlite comands are writen in android The sqlite commands are writen and exectuted like this...

    private static final String DATABASE_CREATE = "create table " 
      + TABLE_TODO
      + "(" 
      + COLUMN_ID + " integer primary key autoincrement, " 
      + COLUMN_CATEGORY + " text not null, " 
      + COLUMN_SUMMARY + " text not null," 
      + COLUMN_DESCRIPTION
      + " text not null" 
      + ");";

  public static void onCreate(SQLiteDatabase database) {
    database.execSQL(DATABASE_CREATE);
  }

However on the sqlite documentation they show something like this

The data in the picture seems to greatly differ from the information given in the code.

Am I just reading the picture wrong, and if so can anyone explain to me how commands like this are setup or point me towards resources that explain how theses commands are setup.