@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		if      (oldVersion == DATABASE_VERSION_1 && newVersion == DATABASE_VERSION_2) { upgradeSchema_DBv1_To_DBv2(db); } //TODO
		else if (oldVersion == DATABASE_VERSION_1 && newVersion == DATABASE_VERSION_3) { upgradeSchema_DBv1_to_DBv3(db); } //TODO
		else if (oldVersion == DATABASE_VERSION_1 && newVersion == DATABASE_VERSION_4) { upgradeSchema_DBv1_to_DBv4(db); }
		else if (oldVersion == DATABASE_VERSION_1 && newVersion == DATABASE_VERSION_5) { upgradeSchema_DBv1_To_DBv5(db); }
		else if (oldVersion == DATABASE_VERSION_2 && newVersion == DATABASE_VERSION_3) { upgradeSchema_DBv2_To_DBv3(db); }
		else if (oldVersion == DATABASE_VERSION_2 && newVersion == DATABASE_VERSION_4) { upgradeSchema_DBv2_To_DBv4(db); } //TODO
		else if (oldVersion == DATABASE_VERSION_2 && newVersion == DATABASE_VERSION_5) { upgradeSchema_DBv2_To_DBv5(db); }
		else if (oldVersion == DATABASE_VERSION_3 && newVersion == DATABASE_VERSION_4) { upgradeSchema_DBv3_To_DBv4(db); }
		else if (oldVersion == DATABASE_VERSION_3 && newVersion == DATABASE_VERSION_5) { upgradeSchema_DBv3_To_DBv5(db); }
		else if (oldVersion == DATABASE_VERSION_4 && newVersion == DATABASE_VERSION_5) { upgradeSchema_DBv4_To_DBv5(db); }
 		fillData(db);
	}

	private void upgradeSchema_DBv1_to_DBv3(SQLiteDatabase db){
		upgradeSchema_DBv1_To_DBv2(db);
		upgradeSchema_DBv2_To_DBv3(db);
	}

	private void upgradeSchema_DBv1_to_DBv4(SQLiteDatabase db){
		upgradeSchema_DBv1_to_DBv3(db);
		upgradeSchema_DBv3_To_DBv4(db);
	}

	private void upgradeSchema_DBv2_To_DBv4(SQLiteDatabase db){
		upgradeSchema_DBv2_To_DBv3(db);
		upgradeSchema_DBv3_To_DBv4(db);
	}

	private void upgradeSchema_DBv1_To_DBv5(SQLiteDatabase db){
		upgradeSchema_DBv1_to_DBv4(db);
		upgradeSchema_DBv4_To_DBv5(db);
	}

	private void upgradeSchema_DBv2_To_DBv5(SQLiteDatabase db){
		upgradeSchema_DBv2_To_DBv4(db);
		upgradeSchema_DBv4_To_DBv5(db);
	}

	private void upgradeSchema_DBv3_To_DBv5(SQLiteDatabase db){
		upgradeSchema_DBv3_To_DBv4(db);
		upgradeSchema_DBv4_To_DBv5(db);
	}

	private void upgradeSchema_DBv3_To_DBv4(SQLiteDatabase db){
		// do nothing - only Inventory refresh
	}

	private void upgradeSchema_DBv4_To_DBv5(SQLiteDatabase db){
		// do nothing - only Inventory refresh
	}

	// this upgrade associated with new game areas - slot and bonus areas.
	// So it was added for Areas - opened texture path, closed texture path, area type and additional texture for bonus area map
	// for GameStat - bonusAreaOpen (to handle unlocked bonus area), slotLevel, slotPoints and sign of free spin availability
	private void upgradeSchema_DBv2_To_DBv3(SQLiteDatabase db){
		upgradeAreasToV3(db);
		upgradeGamestatToV3(db);
	}

	private void upgradeAreasToV3(SQLiteDatabase db){
		db.execSQL(String.format(AREAS_ALTER_TABLE2, DBHelper.AREAS_OPEN_PATH));
		db.execSQL(String.format(AREAS_ALTER_TABLE2, DBHelper.AREAS_CLOSED_PATH));
		db.execSQL(String.format("alter table %s add column %s integer", DBHelper.AREAS_TABLE, DBHelper.AREAS_TYPE));
		db.execSQL(String.format(AREAS_ALTER_TABLE2, DBHelper.AREAS_ADD_TEXTURE));
	}

	private void upgradeGamestatToV3(SQLiteDatabase db){
		String gamestatAlterPattern = "alter table "+GAMESTAT_TABLE+" add column %s integer default %d";
		db.execSQL(String.format(gamestatAlterPattern, GAMESTAT_BONUS_AREA_OPEN, -1));
		db.execSQL(String.format(gamestatAlterPattern, GAMESTAT_SLOT_CURRENT_LEVEL, 1));
		db.execSQL(String.format(gamestatAlterPattern, GAMESTAT_SLOT_POINTS, 0));
		db.execSQL(String.format(gamestatAlterPattern, GAMESTAT_SLOT_FREE_SPIN, 1));
	}

	// this upgrade associated with languages support. Most of changes is additional columns for translations. Also tutorials changed.
	private void upgradeSchema_DBv1_To_DBv2(SQLiteDatabase db) {
		upgradeAreasTODBVer2(db);
		upgradeLevelsTODBVer2(db);
		upgradeCollectionsTODBVer2(db);
		upgradeInventoryTODBVer2(db);
		upgradeHintsTODBVer2(db);
		upgradeTutorialsTableToDBV2(db);
	}

	private void upgradeAreasTODBVer2(SQLiteDatabase db) {
		String s;
		s = AREAS_ALTER_TABLE2.replace("%s", AREAS_NAME_GE);
		db.execSQL(s);
		s = AREAS_ALTER_TABLE2.replace("%s", AREAS_NAME_FR);
		db.execSQL(s);
		s = AREAS_ALTER_TABLE2.replace("%s", AREAS_NAME_IT);
		db.execSQL(s);
		s = AREAS_ALTER_TABLE2.replace("%s", AREAS_NAME_PO);
		db.execSQL(s);
		s = AREAS_ALTER_TABLE2.replace("%s", AREAS_NAME_SP);
		db.execSQL(s);
	}

	private void upgradeLevelsTODBVer2(SQLiteDatabase db) {
		String s;
		s = LEVELS_ALTER_TABLE2.replace("%s", LEVELS_NAME_GE);
		db.execSQL(s);
		s = LEVELS_ALTER_TABLE2.replace("%s", LEVELS_NAME_FR);
		db.execSQL(s);
		s = LEVELS_ALTER_TABLE2.replace("%s", LEVELS_NAME_IT);
		db.execSQL(s);
		s = LEVELS_ALTER_TABLE2.replace("%s", LEVELS_NAME_PO);
		db.execSQL(s);
		s = LEVELS_ALTER_TABLE2.replace("%s", LEVELS_NAME_SP);
		db.execSQL(s);
	}

	private void upgradeCollectionsTODBVer2(SQLiteDatabase db) {
		String s;
		s = COLLECTIONS_ALTER_TABLE2.replace("%s", COLLECTIONS_NAME_GE);
		db.execSQL(s);
		s = COLLECTIONS_ALTER_TABLE2.replace("%s", COLLECTIONS_NAME_FR);
		db.execSQL(s);
		s = COLLECTIONS_ALTER_TABLE2.replace("%s", COLLECTIONS_NAME_IT);
		db.execSQL(s);
		s = COLLECTIONS_ALTER_TABLE2.replace("%s", COLLECTIONS_NAME_PO);
		db.execSQL(s);
		s = COLLECTIONS_ALTER_TABLE2.replace("%s", COLLECTIONS_NAME_SP);
		db.execSQL(s);
	}

	private void upgradeInventoryTODBVer2(SQLiteDatabase db) {
		String s;
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_POPUP_RU);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_POPUP_EN);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_NAME_GE);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_DESC_GE);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_POPUP_GE);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_NAME_FR);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_DESC_FR);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_POPUP_FR);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_NAME_IT);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_DESC_IT);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_POPUP_IT);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_NAME_PO);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_DESC_PO);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_POPUP_PO);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_NAME_SP);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_DESC_SP);
		db.execSQL(s);
		s = INVENTORY_ALTER_TABLE2.replace("%s", INVENTORY_POPUP_SP);
		db.execSQL(s);
	}

	private void upgradeHintsTODBVer2(SQLiteDatabase db) {
		String s;
		s = HINTS_ALTER_TABLE2.replace("%s", HINTS_NAME_GE);
		db.execSQL(s);
		s = HINTS_ALTER_TABLE2.replace("%s", HINTS_NAME_FR);
		db.execSQL(s);
		s = HINTS_ALTER_TABLE2.replace("%s", HINTS_NAME_IT);
		db.execSQL(s);
		s = HINTS_ALTER_TABLE2.replace("%s", HINTS_NAME_PO);
		db.execSQL(s);
		s = HINTS_ALTER_TABLE2.replace("%s", HINTS_NAME_SP);
		db.execSQL(s);
	}

	private void upgradeTutorialsTableToDBV2(SQLiteDatabase db){
		String s = null;
		s = "alter table "+TUTORIALS_TABLE+" add column "+TUTORIALS_CONDITION+" text";
		db.execSQL(s);
		s = "alter table "+TUTORIALS_TABLE+" add column "+TUTORIALS_TEXT_CONDITION_TRUE+" text";
		db.execSQL(s);
		s = "alter table "+TUTORIALS_TABLE+" add column "+TUTORIALS_TEXT_CONDITION_FALSE+" text";
		db.execSQL(s);
		s = "alter table "+TUTORIALS_TABLE+" add column "+TUTORIALS_AD+" text";
		db.execSQL(s);
		s = "alter table "+TUTORIALS_TABLE+" add column "+TUTORIALS_SPOTLIGHT+" text";
		db.execSQL(s);
		s = "alter table "+TUTORIALS_TABLE+" add column "+TUTORIALS_AVAIL_AFTER+" integer";
		db.execSQL(s);
		s = "delete from tutorials";
		db.execSQL(s);
	}