MCM Algorithms Table 7. Database Procedures Name Input Output Description Integer number of rows Removes a row Record ID for affected. 0 means that from delete_IncidentLog deletion no deletion occured. INCIDENT_LOG RecordID (integer), FobID (integer), Description (string), Integer number of rows Updates an ResponseTime affected. 0 means that INCIDENT_LOG update_IncidentLog (integer) no update occured. row. FobID (integer), Creates a new row Description (string), integer number of rows in ResponseTime affected. 0 means that INCIDENT_LOG create_IncidentLog (integer) the create failed. table Gets all Incidents logged to the select_incidentLog_All none record set database Gets the record with select_incidentLog_RecordID RecordID (integer) record set (one row) the ID provided. StartDate Gets all incidents logged between (datetime), EndDate (inclusive) the dates select_incidentLog_Dates (datetime) record set provided.
Table 7. MCM Algorithms Database Procedures Name Input Output Description delete_IncidentLog Record ID for deletion Integer number of rows affected. 0 means that no deletion occured. Removes a row from INCIDENT_LOG update_IncidentLog RecordID (integer), FobID (integer), Description (string), ResponseTime (integer) Integer number of rows affected. 0 means that no update occured. Updates an INCIDENT_LOG row. create_IncidentLog FobID (integer), Description (string), ResponseTime (integer) integer number of rows affected. 0 means that the create failed. Creates a new row in INCIDENT_LOG table select_incidentLog_All none record set Gets all Incidents logged to the database select_incidentLog_RecordID RecordID (integer) record set (one row) Gets the record with the ID provided. select_incidentLog_Dates StartDate record set Gets all incidents logged between (inclusive) the dates provided. (datetime), EndDate (datetime)