[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