Lines 485-492
CREATE TABLE `branch_borrower_circ_rules` (
Link Here
|
485 |
-- |
485 |
-- |
486 |
|
486 |
|
487 |
DROP TABLE IF EXISTS `default_borrower_circ_rules`; |
487 |
DROP TABLE IF EXISTS `default_borrower_circ_rules`; |
488 |
CREATE TABLE `default_borrower_circ_rules` ( |
488 |
CREATE TABLE `default_borrower_circ_rules` ( -- default checkout rules found under "Default checkout, hold and return policy" |
489 |
`categorycode` VARCHAR(10) NOT NULL, |
489 |
`categorycode` VARCHAR(10) NOT NULL, -- patron category this rul |
490 |
`maxissueqty` int(4) default NULL, |
490 |
`maxissueqty` int(4) default NULL, |
491 |
PRIMARY KEY (`categorycode`), |
491 |
PRIMARY KEY (`categorycode`), |
492 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
492 |
CONSTRAINT `borrower_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`) |
Lines 1536-1545
CREATE TABLE `patroncards` (
Link Here
|
1536 |
-- |
1536 |
-- |
1537 |
|
1537 |
|
1538 |
DROP TABLE IF EXISTS `patronimage`; |
1538 |
DROP TABLE IF EXISTS `patronimage`; |
1539 |
CREATE TABLE `patronimage` ( |
1539 |
CREATE TABLE `patronimage` ( -- information related to patron images |
1540 |
`cardnumber` varchar(16) NOT NULL, |
1540 |
`cardnumber` varchar(16) NOT NULL, -- the cardnumber of the patron this image is attached to (borrowers.cardnumber) |
1541 |
`mimetype` varchar(15) NOT NULL, |
1541 |
`mimetype` varchar(15) NOT NULL, -- the format of the image (png, jpg, etc) |
1542 |
`imagefile` mediumblob NOT NULL, |
1542 |
`imagefile` mediumblob NOT NULL, -- the image |
1543 |
PRIMARY KEY (`cardnumber`), |
1543 |
PRIMARY KEY (`cardnumber`), |
1544 |
CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
1544 |
CONSTRAINT `patronimage_fk1` FOREIGN KEY (`cardnumber`) REFERENCES `borrowers` (`cardnumber`) ON DELETE CASCADE ON UPDATE CASCADE |
1545 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1545 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1546 |
- |
|
|