Categories
android sqlite

Executing sql in android

I’m trying to create tables in sqlite android development. My problem is, only one table is beaing created but the other one is not.

Here’s how I create them.

    @Override
public void onCreate(SQLiteDatabase db)
{
try
{
db.execSQL(DATABASE_CREATE);
db.execSQL(DATABASE_CREATE2);
}
catch(SQLException e)
{
e.printStackTrace();
}
}

Variables:

private static final String DATABASE_CREATE =
"create table if not exists profiles (_id integer primary key autoincrement, "
+ "firstname VARCHAR not null, age VARCHAR not null, "
+ "heightft VARCHAR not null, heightin VARCHAR not null, weight VARCHAR not null, duration VARCHAR not null, bmi VARCHAR not null);";
private static final String DATABASE_CREATE2 =
"create table if not exists routines (_id integer primary key autoincrement, "
+ "weightclass VARCHAR not null, musclegroup VARCHAR not null, "
+ "exercise VARCHAR not null, numberofsets VARCHAR not null, numeberofrepitition VARCHAR not null, day VARCHAR not null);";

Any ideas on what the problem is? Thanks!

Update:

private static final String DATABASE_NAME = "fgtDB";
private static final String DATABASE_TABLE = "profiles";
private static final String DATABASE_TABLE2 = "routines";
private static final int DATABASE_VERSION = 2;
private static class DatabaseHelper extends SQLiteOpenHelper
{
DatabaseHelper(Context context)
{
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db)
{
try
{
db.execSQL(DATABASE_CREATE);
db.execSQL(DATABASE_CREATE2);
}
catch(SQLException e)
{
e.printStackTrace();
}
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
{
Log.w(TAG, "Upgrading database from version " + oldVersion
+ " to "
+ newVersion + ", which will destroy all old data");
db.execSQL("DROP TABLE IF EXISTS profiles");
onCreate(db);
}
}