maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
tg_fw_update_device()
Parameters
Name
Type
Mode
Definition
DECLARE BEGIN IF NOT EXISTS (SELECT 1 FROM firmware_app.fw_device WHERE iddevice = NEW.iddevice) THEN INSERT INTO firmware_app.fw_device(iddevice) SELECT NEW.iddevice; END IF; IF TG_OP = 'UPDATE' THEN UPDATE firmware_app.fw_device SET app_id = NEW.app_id WHERE iddevice = NEW.iddevice; UPDATE firmware_app.fw_device SET jpod_firmware = NEW.jpod_firmware WHERE iddevice = NEW.iddevice; UPDATE firmware_app.fw_device SET jpod_script = NEW.jpod_script WHERE iddevice = NEW.iddevice; UPDATE public.device SET firmware = NEW.firmware WHERE iddevice = NEW.iddevice; UPDATE public.device SET script_version = NEW.script_version WHERE iddevice = NEW.iddevice; END IF; RETURN NULL; END;