http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10039 Bug ID: 10039 Summary: the systempreferences.variable column should be a unique key Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt@gmail.com Reporter: gmcharlt@gmail.com Existing code assumes that the systempreference.variable column is a unique key, but this isn't enforced at the database level. This should be tightened up to avoid potential bugs if multiple rows for the same system preference slip in. One consequence of making systempreferences.variable a UK is that scripts (including upgrade scripts) that insert sysprefs should avoid spurious UK violation errors. -- You are receiving this mail because: You are watching all bug changes.