https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33905
--- Comment #34 from Jonathan Druart <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
