public static void ReplaceSystemsTable() { using (var slock = new SQLiteConnectionSystem.SchemaLock()) { using (var conn = new SQLiteConnectionSystem()) { DropSystemsTableIndexes(); using (var txn = conn.BeginTransaction()) { SQLiteDBClass.ExecuteQuery(conn, "DROP TABLE IF EXISTS Systems"); SQLiteDBClass.ExecuteQuery(conn, "DROP TABLE IF EXISTS EdsmSystems"); SQLiteDBClass.ExecuteQuery(conn, "DROP TABLE IF EXISTS SystemNames"); SQLiteDBClass.ExecuteQuery(conn, "ALTER TABLE EdsmSystems_temp RENAME TO EdsmSystems"); SQLiteDBClass.ExecuteQuery(conn, "ALTER TABLE SystemNames_temp RENAME TO SystemNames"); txn.Commit(); } SQLiteDBClass.ExecuteQuery(conn, "VACUUM"); CreateSystemsTableIndexes(); } } }