|
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 |
- |
|
|