I have also been where you are and I know of the terrible guilt you are talking about. You would just love, and would give anything to turn the clock back, and not have these terrible things happen.
But this is not going to help. You need to focus on the positives and live in the knowledge that you have made a mistake (and you would not have otherwise made this mistake had it not been for the alcohol) but draw a line under this and move on from it.
I personally, have come to realise that everytime I have a drink, my day/night ends in disaster, there is always a drama and this only happens when I have a drink. I have had people tell me I am a nicer, funnier, wittier person without a drink and that I seem to disappear into myself when I have a drink. My good friends will tell me the truth and I value that, so for me, alcohol had to go.
You are certainly not alone in this, there are thousands of people out there who experience the same but at least you had the courage to come on here and chat about it. Well done you!!
I wish you all the luck in the world and hope everything works out for you. Enjoy your holiday, look forward to it and look to the future now, stop beating yourself up and enjoy your life!!!
XXX