Hi, On Fri, Apr 12, 2013 at 11:21 PM, Manos PETRIDIS <egpetri...@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: g...@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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha