The scary thing to me about that setup is how the global value is updated. Every individual script must successfully increment the value to avoid duplicate keys.
Really hope they had a “get key” stored procedure to handle that.
Really hope they had a “get key” stored procedure to handle that.