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

(-)a/installer/data/mysql/kohastructure.sql (-5 / +4 lines)
Lines 469-478 CREATE TABLE collections_tracking ( Link Here
469
--
469
--
470
470
471
DROP TABLE IF EXISTS `branch_borrower_circ_rules`;
471
DROP TABLE IF EXISTS `branch_borrower_circ_rules`;
472
CREATE TABLE `branch_borrower_circ_rules` (
472
CREATE TABLE `branch_borrower_circ_rules` ( -- includes default circulation rules for patron categories found under "Checkout limit by patron category"
473
  `branchcode` VARCHAR(10) NOT NULL,
473
  `branchcode` VARCHAR(10) NOT NULL, -- the branch this rule applies to (branches.branchcode)
474
  `categorycode` VARCHAR(10) NOT NULL,
474
  `categorycode` VARCHAR(10) NOT NULL, -- the patron category this rule applies to (categories.categorycode)
475
  `maxissueqty` int(4) default NULL,
475
  `maxissueqty` int(4) default NULL, -- the maximum number of checkouts this patron category can have at this branch
476
  PRIMARY KEY (`categorycode`, `branchcode`),
476
  PRIMARY KEY (`categorycode`, `branchcode`),
477
  CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
477
  CONSTRAINT `branch_borrower_circ_rules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
478
    ON DELETE CASCADE ON UPDATE CASCADE,
478
    ON DELETE CASCADE ON UPDATE CASCADE,
479
- 

Return to bug 6716