If it was in any way enforceable, the approach of the more serious airlines (e.g. KLM, BA, Finnair) to drinking would be the most sensible one:
Tolerance of a few drinks, especially with dinner on a long-haul, but zero tolerance for disruptive alcohol-fuelled behaviour resulting in bans.