Ellis improvement

CREATE EVENT IF NOT EXISTS EV_DELETE_BOOKING_REQUEST_LOCK_EXPIRED
ON SCHEDULE EVERY 1 MINUTE
DO
DELETE FROM BK_BOOKING_REQUEST_LOCK
WHERE LAST_UPDATE_DATETIME < NOW - INTERVAL 2 MINUTE;

Please test on dev

Test case:

1/ Booking API
- Test normal booking
- Send 2 requests booking with same seller booking code at the same time.
--> the results of the two requests must be same.
2/ Cancel API
- Test normal cancel
- Send 2 requests cancel with same seller booking code at the same time.
--> If request 1 success, request 2 return: Booking already canceled
--> If request 1 failed, request 2 retry return failed

curl --location 'https://dev-api-ota-v2.ohmyhotel.com/channel/ota/v2.0/reservation/book' \
--header 'Authorization;' \
--header 'Signature;' \
--header 'Content-Type: application/json' \
--data-raw '{
"nationalityCode": "KR",
"language": "KO",
"channelBookingCode": "AAV014",
"contactPerson": {
"name": "ohmyhotelTest",
"email": "It6@ohmyhotel.com",
"countryPhoneCode": "+84",
"mobileNo": "911180438"
},
"hotelCode": 803104,
"checkInDate": "2025-07-29",
"checkOutDate": "2025-07-30",
"roomTypeCode": "D_109116",
"ratePlanCode": "804382|2^0",
"freeBreakfastName": null,
"rooms": [ {
"roomNo": 1,
"guests": [ {
"lastName": "Ohmyhotel",
"firstName": "Test4",
"gender": "M"
}, {
"lastName": "Ohmyhotel",
"firstName": "Test3",
"gender": "M"
}
]
}
],
"requests": [ {
"code": "BRQ01",
"comment": ""
}
],
"rateType": "standard_rate",
"totalNetAmount": 40.29
}'

curl --location 'https://dev-api-ota-v2.ohmyhotel.com/channel/ota/v2.0/reservation/book/AAV014/cancel' \
--header 'Signature;' \
--header 'Authorization;'

(The request takes around 50 seconds when tried to book a cancelled item again)

I updated, please test this case on dev @Kyle Pham

Please test on staging!!!!!!!

please test on staging!