https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20581 --- Comment #159 from Andrew Isherwood <andrew.isherwood@ptfs-europe.com> --- Hmmm, prefixes feels like a hack. Using a composite primary key as you suggest might be a step in the right direction. However, as I understand it, to then use that as a foreign key in other tables would require each table to have a corresponding column for each of the authorised_values columns that comprise the key. As an aside, I'm not convinced the category and authorised_value columns do currently have any unique constraint on them. Looking at the schema, it looks like category, authorised_value and lib are defined as keys, but I can only think that was does to create indexes on them as there appears to be no unique constraints on them. Definitely worth a discussion I think... -- You are receiving this mail because: You are watching all bug changes.