Monitoring integration list throws an exception on migrated installation from v1.1.0 to v1.2.1

[gianlucapiccolo]

Expected Behavior

When a monitoring integration is configured, the page /vspheredb/configuration/monitoring should show the monitoring integration list

Current Behavior

When a monitoring integration is configured, the page /vspheredb/configuration/monitoring throws an exception:
Oops, an error occurred! SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mc.id' in 'field list', query was: SELECT mc.source_type, mc.source_resource_name, mc.id, mc.priority, mc.host_property, mc.monitoring_host_property, mc.vm_property, mc.monitoring_vm_host_property FROM monitoring_connection AS mc ORDER BY priority ASC LIMIT 25 (Pdo.php:225)

Possible Solution

I think that this is caused from the missing id column in monitoring_connection table.
The monitoring_connection table in the schema/schema.sql file contains the id column but there is no alter table to add that column in the schema/mysql-migration/upgrade_*.sql or in the schema/legacy-mysql-changes/upgrade_*.sql files.

Steps to Reproduce (for bugs)

1. Upgrade from version 1.1.0 to 1.2.1
2. Add a monitoring integration
3. Load the /vspheredb/configuration/monitoring page

Your Environment

• Version/GIT-Hash of this module:
• Icinga Web 2 version: 2.8.5
• Operating System and version: 1.2.1
• Webserver, PHP versions: httpd, 7.3