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

[bugzilla-daemon]

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


address@hidden changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         AssignedTo|address@hidden        |address@hidden




------- Comment #2 from address@hidden  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.