alter table fly_hash_block add column tth char(24);
update fly_hash_block set tth = (select tth from fly_hash fh where fh.id = fly_hash_block.tth_id) where tth is null;
delete from fly_hash_block where tth is null;
create unique index if not exists iu_fly_hash_block_tth on fly_hash_block(tth);
drop table fly_hash;

#define FLYLINKDC_USE_FAST_CONVERT
		if (is_table_exists("fly_hash"))
		{
			CFlyLog l_convert_log("[SQLite DB convert]");
#ifdef FLYLINKDC_USE_FAST_CONVERT
			m_flySQLiteDB.executenonquery("pragma synchronous=OFF;");
			m_flySQLiteDB.executenonquery("pragma journal_mode=MEMORY;");
#endif
			safeAlter("ALTER TABLE fly_hash_block add column tth char(24)");
			l_convert_log.step(m_flySQLiteDB.executenonquery("update fly_hash_block set tth = (select tth from fly_hash fh where fh.id = fly_hash_block.tth_id) where tth is null"));
			l_convert_log.step(m_flySQLiteDB.executenonquery("delete from fly_hash_block where tth is null"));
			l_convert_log.step(m_flySQLiteDB.executenonquery("CREATE UNIQUE INDEX IF NOT EXISTS iu_fly_hash_block_tth ON fly_hash_block(tth)"));
			l_convert_log.step(m_flySQLiteDB.executenonquery("drop table fly_hash"));
#ifdef FLYLINKDC_USE_FAST_CONVERT
			if (!g_UseSynchronousOff)
			{
				m_flySQLiteDB.executenonquery("pragma synchronous=FULL;");
			}
			if (!(g_DisableSQLJournal || BOOLSETTING(SQLITE_USE_JOURNAL_MEMORY)))
			{
				if (g_UseWALJournal)
				    m_flySQLiteDB.executenonquery("pragma journal_mode=WAL;");
				else
				   m_flySQLiteDB.executenonquery("pragma journal_mode=PERSIST;");
			}
#endif
		}