https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33905 --- Comment #34 from Jonathan Druart <jonathan.druart@gmail.com> --- (In reply to David Cook from comment #30)
CREATE TABLE test_identifiers ( borrowernumber int(11) NOT NULL, identifier varchar(75) NOT NULL, CONSTRAINT t_ids UNIQUE (identifier), PRIMARY KEY (borrowernumber,identifier) );
CREATE TABLE test_borrowers ( borrowernumber int(11) NOT NULL AUTO_INCREMENT, cardnumber varchar(32) DEFAULT NULL, userid varchar(75) DEFAULT NULL, CONSTRAINT t_cardnumber FOREIGN KEY (borrowernumber,cardnumber) REFERENCES test_identifiers (borrowernumber,identifier), CONSTRAINT t_userid FOREIGN KEY (borrowernumber,userid) REFERENCES test_identifiers (borrowernumber,identifier) );
Great idea, I love it! -- You are receiving this mail because: You are watching all bug changes.