Clean up left over indices and alembic columns for migration 222 to 224

[margrietpalm]

• Several _alembic_tmp tables are not cleaned up correctly
  • [ ] _alembic_tmp_dry_weather_flow
  • [ ] _alembic_tmp_dry_weather_flow_map
  • [ ] _alembic_tmp_memory_control
  • [ ] _alembic_tmp_surface
  • [ ] _alembic_tmp_surface_map
  • [ ] _alembic_tmp_v2_connection_nodes
  • [ ] _alembic_tmp_v2_cross_section_location
• Several spatial index related tables are in the spatialite without being recognized as such by QGIS (normally they are hidden). Seems to be some sort of remnant of something?
  • [ ] idx_v2_connection_nodes_the_geom_linestring
  • [ ] idx_v2_connection_nodes_the_geom_linestring_node
  • [ ] idx_v2_connection_nodes_the_geom_linestring_parent
  • [ ] idx_v2_connection_nodes_the_geom_linestring_rowid

[margrietpalm]

All these issues automagically diseappeared with all previous fixes (double check before closing!)

[leendertvanwolfswinkel]

I still see the issue with threedi-schema 0.224.1. Using this sqlite: supermodel_Assen_langzame_afvoer.zip

[margrietpalm]

In my qgis, with the 0.224.2.dev2 I see this on an upgraded version of the abovementioned model:

and

sqlite> select COUNT(name) from sqlite_master where name LIKE '\_%' ESCAPE '\';
0