@Override public void onUpgrade(SQLiteDatabase db) { Utils.log("Doing MigrationHelper 5 Upgrade"); try { ProductGroupDao.createTable(db, true); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.StocksORS.columnName, "INTEGER"); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.StocksZinc.columnName, "INTEGER"); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.StocksACTs.columnName, "INTEGER"); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.StocksRDT.columnName, "INTEGER"); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.StocksAmox.columnName, "INTEGER"); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.MinORSPrice.columnName, "TEXT"); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.MinZincPrice.columnName, "TEXT"); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.MinACTPrice.columnName, "TEXT"); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.MinRDTPrice.columnName, "TEXT"); executeAlterQuery( db, AdhockSaleDao.TABLENAME, AdhockSaleDao.Properties.MinAmoxPrice.columnName, "TEXT"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.StocksORS.columnName, "INTEGER"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.StocksZinc.columnName, "INTEGER"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.StocksACTs.columnName, "INTEGER"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.StocksRDT.columnName, "INTEGER"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.StocksAmox.columnName, "INTEGER"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.MinORSPrice.columnName, "TEXT"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.MinZincPrice.columnName, "TEXT"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.MinACTPrice.columnName, "TEXT"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.MinRDTPrice.columnName, "TEXT"); executeAlterQuery(db, SaleDao.TABLENAME, SaleDao.Properties.MinAmoxPrice.columnName, "TEXT"); } catch (Exception ex) { Utils.log("Error doing 6 upgrade -> " + ex.getMessage()); ex.printStackTrace(); } }