Unique fields cannot be unlimited length in MySQL
Raised by Josef Lundman: https://groups.google.com/d/topic/openrem/Qd117-eoebY/discussion
UniqueEquipmentNames has almost all text fields. MySQL cannot use these if uniqueness is required: http://stackoverflow.com/a/1827099
- Option 1: Limit the length of each field, convert them to char fields
- Option 2: Create an SHA hash of each field on edit, and make them unique together instead.
David Platten: what do you think?