private static class DbHelper extends SQLiteOpenHelper{

public DbHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
// TODO Auto-generated constructor stub
}

@Override
public void onCreate(SQLiteDatabase db) { //Wird nur EINMAL durchlaufen beim allerersten Start
// TODO Auto-generated method stub
db.execSQL("CREATE TABLE " + DATABASE_TABLE1 + " (" +
KEY_ROWIDP + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_NAME + " TEXT NOT NULL, " +
KEY_NICK + " TEXT NOT NULL, " +
KEY_POS1 + " TEXT NOT NULL, " +
KEY_ONFI + " BOOLEAN DEFAULT FALSE);"
);
db.execSQL("CREATE TABLE " + DATABASE_TABLE2 + " (" +
KEY_ROWIDS + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_ROWIDP + " INTEGER NOT NULL, " +
// " FOREIGN KEY (" + KEY_ROWIDP + ") REFERENCES " + DATABASE_TABLE1 + " (" + KEY_ROWIDP + ")" +
KEY_OPP + " TEXT NOT NULL, " +
KEY_GDATE + " TEXT DEFAULT 0, " +
KEY_GSET + " INTEGER NOT NULL, " +
KEY_AT_A + " INTEGER DEFAULT 0, " +
KEY_AT_P + " INTEGER DEFAULT 0, " +
KEY_AT_N + " INTEGER DEFAULT 0, " + // v10-11 changed from KEY_AT_N to KEY_AT_N
KEY_AT_F + " INTEGER DEFAULT 0, " +
KEY_RC_A + " INTEGER DEFAULT 0, " +
KEY_RC_P + " INTEGER DEFAULT 0, " +
KEY_AT_N + " INTEGER DEFAULT 0, " + // v10-11 changed from KEY_AT_N to KEY_AT_N
KEY_RC_F + " INTEGER DEFAULT 0, " +
KEY_DF_A + " INTEGER DEFAULT 0, " +
KEY_DF_P + " INTEGER DEFAULT 0, " +
KEY_AT_N + " INTEGER DEFAULT 0, " + // v10-11 changed from KEY_AT_N to KEY_AT_N
KEY_DF_F + " INTEGER DEFAULT 0, " +
KEY_BL_A + " INTEGER DEFAULT 0, " +
KEY_BL_P + " INTEGER DEFAULT 0, " +
KEY_AT_N + " INTEGER DEFAULT 0, " + // v10-11 changed from KEY_AT_N to KEY_AT_N
KEY_BL_F + " INTEGER DEFAULT 0, " +
KEY_SE_A + " INTEGER DEFAULT 0, " +
KEY_SE_P + " INTEGER DEFAULT 0, " +
KEY_AT_N + " INTEGER DEFAULT 0, " + // v10-11 changed from KEY_AT_N to KEY_AT_N
KEY_SE_F + " INTEGER DEFAULT 0, " +
KEY_AT_B + " INTEGER DEFAULT 0, " + // v10-11 added
KEY_AT_B + " INTEGER DEFAULT 0, " + // v10-11 added
KEY_AT_B + " INTEGER DEFAULT 0, " + // v10-11 added
KEY_AT_B + " INTEGER DEFAULT 0, " + // v10-11 added
KEY_AT_B + " INTEGER DEFAULT 0);" // v10-11 added
);
db.execSQL("CREATE TABLE " + DATABASE_TABLE3 + " (" +
KEY_E_TYP0 + " TEXT NOT NULL, " +
KEY_E_TYP1 + " TEXT NOT NULL, " +
KEY_E_NAME + " TEXT NOT NULL, " +
KEY_E03 + " TEXT, " +
KEY_E04 + " TEXT, " +
KEY_E05 + " TEXT, " +
KEY_E06 + " TEXT, " +
KEY_E07 + " TEXT, " +
KEY_E08 + " TEXT, " +
KEY_E09 + " TEXT, " +
KEY_E10 + " TEXT, " +
KEY_E11 + " TEXT, " +
KEY_E12 + " TEXT, " +
KEY_E13 + " TEXT, " +
KEY_E14 + " TEXT, " +
KEY_E15 + " TEXT, " +
KEY_E16 + " TEXT, " +
KEY_E17 + " TEXT, " +
KEY_E18 + " TEXT, " +
KEY_E19 + " TEXT);"
);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
if (oldVersion < 9){
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE1);
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE2);
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE3);
onCreate(db);
} else {
switch (oldVersion){
case 9:
db.execSQL("CREATE TABLE " + DATABASE_TABLE3 + " (" +
KEY_E_TYP0 + " TEXT NOT NULL, " +
KEY_E_TYP1 + " TEXT NOT NULL, " +
KEY_E_NAME + " TEXT NOT NULL, " +
KEY_E03 + " TEXT, " +
KEY_E04 + " TEXT, " +
KEY_E05 + " TEXT, " +
KEY_E06 + " TEXT, " +
KEY_E07 + " TEXT, " +
KEY_E08 + " TEXT, " +
KEY_E09 + " TEXT, " +
KEY_E10 + " TEXT, " +
KEY_E11 + " TEXT, " +
KEY_E12 + " TEXT, " +
KEY_E13 + " TEXT, " +
KEY_E14 + " TEXT, " +
KEY_E15 + " TEXT, " +
KEY_E16 + " TEXT, " +
KEY_E17 + " TEXT, " +
KEY_E18 + " TEXT, " +
KEY_E19 + " TEXT);"
);
case 10:
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " ADD " + KEY_AT_B + " INTEGER DEFAULT 0");
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " ADD " + KEY_RC_B + " INTEGER DEFAULT 0");
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " ADD " + KEY_DF_B + " INTEGER DEFAULT 0");
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " ADD " + KEY_BL_B + " INTEGER DEFAULT 0");
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " ADD " + KEY_SE_B + " INTEGER DEFAULT 0");
/*
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " CHANGE " + KEY_AT_N + " " + KEY_AT_G + " INTEGER DEFAULT 0");
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " CHANGE " + KEY_RC_N + " " + KEY_RC_G + " INTEGER DEFAULT 0");
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " CHANGE " + KEY_DF_N + " " + KEY_DF_G + " INTEGER DEFAULT 0");
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " CHANGE " + KEY_BL_N + " " + KEY_BL_G + " INTEGER DEFAULT 0");
db.execSQL("ALTER TABLE " + DATABASE_TABLE2 + " CHANGE " + KEY_SE_N + " " + KEY_SE_G + " INTEGER DEFAULT 0");
*/
}
}
}
}
public TeamDB(Context c) {
unserContext = c;
}
public TeamDB open() throws SQLException{
unserHelferlein = new DbHelper(unserContext);
unsreDatenbank = unserHelferlein.getWritableDatabase();
return this;
}
public void close(){
unserHelferlein.close();
}