maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_unit_delete(integer, character varying)
Parameters
Name
Type
Mode
_idclient
integer
IN
_alias
character varying
IN
Definition
DECLARE _idunit int := 0; BEGIN SELECT idunit INTO _idunit FROM unit WHERE idclient = _idclient AND alias = _alias LIMIT 1; DELETE FROM vehicle WHERE idunit = _idunit; DELETE FROM unit_unitgroup WHERE idunit = _idunit; UPDATE device SET idunit = null WHERE idunit = _idunit; DELETE FROM unit_report WHERE idunit = _idunit; DELETE FROM current_geofence WHERE idunit = _idunit; DELETE FROM unit WHERE idunit = _idunit; RETURN true; END;