Hi, On Fri, Apr 12, 2013 at 11:21 PM, Manos PETRIDIS <[email protected]> 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: [email protected] 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 [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
