                  AND column_name = 'openshift_project_name'
              )  THEN
       ALTER TABLE `environment` CHANGE `openshift_projectname` `openshift_project_name` varchar(100);
->>>>>>> master
 
     END IF;
 

$$

CREATE OR REPLACE PROCEDURE
<<<<<<< HEAD
  add_routes_monitoring_urls_to_environments()
=======
  rename_keyValue_to_key_value_in_ssh_key()
>>>>>>> master

  BEGIN

    IF NOT EXISTS(
              SELECT NULL
                FROM INFORMATION_SCHEMA.COLUMNS
<<<<<<< HEAD
              WHERE table_name = 'environment'
                AND table_schema = 'infrastructure'
                AND column_name = 'lagoon_route'

CALL add_subfolder_to_project();
CALL delete_project_pattern_from_openshift();
CALL add_openshift_project_pattern_to_project();
CALL add_routes_monitoring_urls_to_environments();
CALL rename_keyValue_to_key_value_in_ssh_key();
CALL rename_keyType_to_key_type_in_ssh_key();
CALL rename_openshift_projectname_in_environment();
