http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10039 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #1 from David Cook <dcook@prosentient.com.au> --- (In reply to comment #0)
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.
Perhaps I'm confused, but isn't systempreference.variable already the primary key of the systempreference table, which automatically makes it unique? If I look at my DB or kohastructure.sql (at line 2008 of master), it says it's the primary key, and if I try to insert sysprefs using updatedatabase.pl, sysprefs.sql, or manually with a query editor, it always prevents duplication. Am I missing something? -- You are receiving this mail because: You are watching all bug changes.