[Koha-bugs] [Bug 10039] New: the systempreferences.variable column should be a unique key

[bugzilla-daemon at bugs.koha-community.org]

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 at gmail.com
          Reporter: gmcharlt at 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.