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

--- Comment #143 from Jonathan Druart <[email protected]> 
---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to