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