[Koha-bugs] [Bug 1505] Primary Key on borrowernumber

[bugzilla-daemon at pippin.metavore.com]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1505


paul.poulain at free.fr changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         AssignedTo|paul.poulain at free.fr        |jmf at liblime.com




------- Comment #2 from paul.poulain at free.fr  2007-10-26 09:31 -------
#1 is fixed for borrowers table
(patch 5d91cca026dbf2d620a2c02c24018ddbe227b4e6)

I don't understand #2 : aqbookfund table is :
CREATE TABLE `aqbookfund` (
  `bookfundid` varchar(10) NOT NULL default '',
  `bookfundname` mediumtext,
  `bookfundgroup` varchar(5) default NULL,
  `branchcode` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`bookfundid`,`branchcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


which means we have a pk on bookfundid+branchcode. that mean b+b must be
unique.
bookfundid can be duplicated, and branchcode as well.
So, for me, it's how it should be.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.