[Koha-bugs] [Bug 18887] Introduce new table 'circulation_rules', use for 'max_holds' rules

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Oct 25 15:30:22 CEST 2018


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18887

--- Comment #143 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
I have found a bug in the structure of the table.

circulation_rules:
  PRIMARY KEY (`id`),
  UNIQUE KEY `branchcode` (`branchcode`,`categorycode`,`itemtype`,`rule_name`),

issuingrules:
PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`),

The difference between UNIQUE and PRIMARY keys is that UNIQUE accept duplicated
NULL values.
So the DBMS will not raised an error if we try to insert several times the same
rule.

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list