Hi, On Fri, Apr 12, 2013 at 11:21 PM, Manos PETRIDIS <egpetridis@yahoo.com> wrote:
Should that be the case, I wonder if such a unique index on systempreferences.variable. would be welcome as a permanent feature. Unless all sql scripts check for already existing entries so that they perform an update instead of insert, the index would at least ensure that no duplicates are created. [snip] Do you agree or have I got it wrong?
I agree that having a unique constraint on systempreferences.variable column makes sense. I've opened bug 10039 [1] for this proposal. [1] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10039 Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org