Bug: Code Example Chapter 10 Earthquake 3

05-07 10:00:31.243: ERROR/AndroidRuntime(346): java.lang.RuntimeException: Unable to get provider com.paad.earthquake.EarthquakeProvider: android.database.sqlite.SQLiteException: near "link": syntax error: create table earthquakes (_id integer primary key autoincrement, date INTEGER, details TEXT, latitude FLOAT, longitude FLOAT, magnitude FLOAT) link TEXT);

Solution:
In the class EarthquakeProvider:
Line 230, remove the ')' to fix the bug

in EarthquakeProvider.java
see:
private static class earthquakeDatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_CREATE =
"create table " + EARTHQUAKE_TABLE + " ("
+ KEY_ID + " integer primary key autoincrement, "
+ KEY_DATE + " INTEGER, "
+ KEY_DETAILS + " TEXT, "
+ KEY_LOCATION_LAT + " FLOAT, "
+ KEY_LOCATION_LNG + " FLOAT, "
+ KEY_MAGNITUDE + " FLOAT), " <<<< the ")" shouldn't be there
+ KEY_LINK + " TEXT);";

Fixed fragment:
private static class earthquakeDatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_CREATE =
"create table " + EARTHQUAKE_TABLE + " ("
+ KEY_ID + " integer primary key autoincrement, "
+ KEY_DATE + " INTEGER, "
+ KEY_DETAILS + " TEXT, "
+ KEY_LOCATION_LAT + " FLOAT, "
+ KEY_LOCATION_LNG + " FLOAT, "
+ KEY_MAGNITUDE + " FLOAT, "
+ KEY_LINK + " TEXT);";


Also requires a reference (for local Eclipse build) to Google APIs: maps.jar