View | Details | Raw Unified | Return to bug 6716
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-7 / +6 lines)
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
- 

Return to bug 6716