Using this snippet of a subclassed SQLiteOpenHelper, modify creates table code to add a TEXT field "COMPANY_NAME"

Android Data Persistence Creating an SQLite Table Challenges 1 thru 3

http://teamtreehouse.com/library/android-data-persistence/using-sqlite-for-structured-data/creating-a-sqlite-table

I had no idea how to add a text field to a Create Table string for SQLite!

However, after several hours of going through the SQLite documentation

(the Treehouse videos were only vaguely useful at best, talking about MEMES_TABLEs -- not CREATE_CAR_MAKERS tables),

I finally came up with some randomly permutated (trial and error) code, which (after many attempts and java parsing errors) finally (luckily) seemed to pass:

public class AutoSQLiteHelper extends SQLiteOpenHelper {
  public static final String COMPANY_NAME = "NAME";
  public static final String CREATE_CAR_MAKERS = 
 "CREATE TABLE CAR_MAKERS ( _id INTEGER PRIMARY KEY, COMPANY_NAME TEXT)";

  public static final String CAR_NAME = "CARNAME";
    public static final String CREATE_CAR_MODELS = 
 "CREATE TABLE CAR_MODELS ( _id INTEGER PRIMARY KEY AUTOINCREMENT, CAR_NAME TEXT)";


  @Override
  public void onCreate(SQLiteDatabase database) {
    database.execSQL(CREATE_CAR_MAKERS);
    database.execSQL(CREATE_CAR_MODELS);
  }
}

Even searching for SQLiteOpenHelper failed to give an hint what I was supposed to do and the video before the challenge didn't spell out anything for AutoSQLiteHelper, so good luck to anyone who tries to get something out of this challenge without being an advanced expert in SQLite,

(which this Android Data Persistence course doesn't accomplish).