Acq Providers: Unique constraint on name/code is case sensitive

[Tiffany Little]

Tested on both the new Angular Providers as well as the <3.5 providers interface.

The unique constraint on the text field for both name and code on providers is case sensitive. It should be case insensitive. I can create a provider with code 'INGRAM' and then I can turn around and create another provider named 'Ingram' at the same org unit and that works. Those should be considered equal and I should be blocked from creating the mixed case Ingram.

[Christine Morgan (cmorgan-z)]

Confirmed in 3.6.1

[Galen Charlton (gmc)]

Marking this as a wishlist item, and noting that there are some lurking implementation dragons, including:

- If we add a constraint, dealing with existing vendor codes that would violate that constraint during upgrade
- warnings and/or reports of overlapping vendor codes would be easier to implement, but wouldn't provide as strong a guarantee as a database constraint
- Discussing consistency with the rest of Evergreen, since at present there are no coded fields to my knowledge that have a case-intensive uniqueness constraint. There are other bugs requesting that certain fields be made case-insensitive, e.g., bug 1744153 (usernames), bug 1548328 (circ modifiers) bug 1869896 (barcodes, although I think dragons _really_ reside there). There are also several bugs requesting case-insensitive filtering and sorting, although that's really a different class of issues.

Upshot: I'm sympathetic to this idea, but I think it would warrant broader discussion.