 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2018-03-20 23:05:56
+-- Dump completed on 2018-04-14 17:57:54

          p_dataCollectionId, p_imageNumber, p_spotTotal, p_goodBraggCandidates, 
          p_method1Res, p_method2Res, p_totalIntegratedSignal, p_dozorScore, p_driftFactor
        );
        SET p_id = LAST_INSERT_ID();
    ELSE
        
        
        UPDATE ImageQualityIndicators 
        SET
          spotTotal = IFNULL(p_spotTotal, spotTotal),

          c.sessionId = row_session_id;

      ELSE
        -- MYSQL_ERRNO=1643: ER_SIGNAL_NOT_FOUND: Unhandled user-defined not found condition
		SIGNAL SQLSTATE '45000' SET MYSQL_ERRNO=1643, MESSAGE_TEXT='Corresponding rows for p_proposalCode + p_proposalNumber + p_sessionNumber not found';
      END IF;
  END IF;
