aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_register_guests_update_registered_flag
Parameters
Name
Type
Mode
Definition
DECLARE v_booking_id int; BEGIN select booking_id into v_booking_id from registration where id = IIF(TG_OP='DELETE', OLD.register_id, NEW.register_id); IF v_booking_id is not null THEN CASE TG_OP WHEN 'INSERT' THEN update booking_guests bg set registered = True, register_id = NEW.register_id where bg.booking_id = v_booking_id and bg.guest_id = NEW.guest_id and bg.registered = False; WHEN 'DELETE' THEN update booking_guests bg set registered = False where bg.booking_id = v_booking_id and bg.guest_id = OLD.guest_id and bg.registered = True; END CASE; END IF; RETURN NULL; END