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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 3868-3874 CREATE TABLE IF NOT EXISTS `housebound_role` ( Link Here
3868
  `housebound_chooser` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound chooser volunteer
3868
  `housebound_chooser` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound chooser volunteer
3869
  `housebound_deliverer` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound deliverer volunteer
3869
  `housebound_deliverer` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound deliverer volunteer
3870
  PRIMARY KEY (`borrowernumber_id`),
3870
  PRIMARY KEY (`borrowernumber_id`),
3871
  CONSTRAINT `houseboundvisit_bnfk`
3871
  CONSTRAINT `houseboundrole_bnfk`
3872
    FOREIGN KEY (`borrowernumber_id`)
3872
    FOREIGN KEY (`borrowernumber_id`)
3873
    REFERENCES `borrowers` (`borrowernumber`)
3873
    REFERENCES `borrowers` (`borrowernumber`)
3874
    ON UPDATE CASCADE ON DELETE CASCADE
3874
    ON UPDATE CASCADE ON DELETE CASCADE
3875
- 

Return to bug 5670