message: #548 - update existing DBs with new columns
diff: @@ -412,6 +412,27 @@ CREATE OR REPLACE PROCEDURE
  END;
  $$
  +CREATE OR REPLACE PROCEDURE
  + add_routes_monitoring_urls_to_environments()
  +
  + BEGIN
  +
  + IF NOT EXISTS(
  + SELECT NULL
  + FROM INFORMATION_SCHEMA.COLUMNS
  + WHERE table_name = 'environment'
  + AND table_schema = 'infrastructure'
  + AND column_name = 'lagoon_route'
  + ) THEN
  + ALTER TABLE `environment` ADD `lagoon_route` varchar(300);
  + ALTER TABLE `environment` ADD `lagoon_routes` text;
  + ALTER TABLE `environment` ADD `monitoring_urls` text;
  +
  + END IF;
  +
  + END;
  +$$
  +
  DELIMITER ;
  CALL add_production_environment_to_project;
  @@ -427,4 +448,5 @@ CALL add_storagecalc_to_project();
  CALL add_project_pattern_to_openshift();
  CALL add_subfolder_to_project();
  CALL delete_project_pattern_from_openshift();
  -CALL add_openshift_project_pattern_to_project()
  +CALL add_openshift_project_pattern_to_project();
  +CALL add_routes_monitoring_urls_to_environments();
  