aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_booking_departure_change
Parameters
Name
Type
Mode
Definition
declare BEGIN UPDATE folio f SET close_date = new.departure WHERE f.booking_id = new.id and f.folio_type = 'B' and f.close_date <> new.departure; RETURN NULL; END