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

(-)a/installer/data/mysql/atomicupdate/housebound_tables.sql (-8 / +12 lines)
Lines 36-52 CREATE TABLE IF NOT EXISTS `housebound_visit` ( Link Here
36
    ON UPDATE CASCADE ON DELETE CASCADE
36
    ON UPDATE CASCADE ON DELETE CASCADE
37
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
37
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
38
38
39
CREATE TABLE IF NOT EXISTS `housebound_role` (
40
  `borrowernumber_id` int(11) NOT NULL, -- borrowernumber link
41
  `housebound_chooser` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound chooser volunteer
42
  `housebound_deliverer` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound deliverer volunteer
43
  PRIMARY KEY (`borrowernumber_id`),
44
  CONSTRAINT `houseboundrole_bnfk`
45
    FOREIGN KEY (`borrowernumber_id`)
46
    REFERENCES `borrowers` (`borrowernumber`)
47
    ON UPDATE CASCADE ON DELETE CASCADE
48
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
49
39
INSERT IGNORE INTO systempreferences
50
INSERT IGNORE INTO systempreferences
40
       (variable,value,options,explanation,type) VALUES
51
       (variable,value,options,explanation,type) VALUES
41
       ('HouseboundModule',0,'',
52
       ('HouseboundModule',0,'',
42
       'If ON, enable housebound module functionality.','YesNo');
53
       'If ON, enable housebound module functionality.','YesNo');
43
54
44
INSERT IGNORE INTO authorised_values (category, authorised_value, lib) VALUES
55
INSERT IGNORE INTO authorised_values (category, authorised_value, lib) VALUES
45
       ('HSBND_FREQ','EW','Every week'),
56
       ('HSBND_FREQ','EW','Every week');
46
       ('HSBND_ROLE','CHO','Chooser'),
47
       ('HSBND_ROLE','DEL','Deliverer');
48
49
INSERT IGNORE INTO borrower_attribute_types
50
       (code, description, repeatable, opac_display, staff_searchable,
51
       authorised_value_category, display_checkout) values
52
       ('HSBND', 'Housebound role', 1, 1, 1, 'HSBND_ROLE', 1);
(-)a/installer/data/mysql/en/mandatory/auth_values.sql (-4 / +1 lines)
Lines 1-6 Link Here
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');
4
       ('HSBND_FREQ','EW','Every week'),
5
       ('HSBND_ROLE','CHO','Chooser'),
6
       ('HSBND_ROLE','DEL','Deliverer');
(-)a/installer/data/mysql/en/mandatory/patron_attributes.sql (-4 lines)
Lines 1-4 Link Here
1
INSERT INTO borrower_attribute_types
2
       (code, description, repeatable, opac_display, staff_searchable,
3
       authorised_value_category, display_checkout) values
4
       ('HSBND', 'Housebound role', 1, 1, 1, 'HSBND_ROLE', 1);
(-)a/installer/data/mysql/en/mandatory/patron_attributes.txt (-2 lines)
Lines 1-2 Link Here
1
Default Koha system extended patron attributes:
2
* HSBND - Allow assignment of different housebound roles for volunteers
(-)a/installer/data/mysql/kohastructure.sql (-1 / +16 lines)
Lines 3858-3863 CREATE TABLE `housebound_visit` ( Link Here
3858
    ON UPDATE CASCADE ON DELETE CASCADE
3858
    ON UPDATE CASCADE ON DELETE CASCADE
3859
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3859
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3860
3860
3861
--
3862
-- Table structure for table `housebound_role`
3863
--
3864
3865
DROP TABLE IF EXISTS `housebound_role`;
3866
CREATE TABLE IF NOT EXISTS `housebound_role` (
3867
  `borrowernumber_id` int(11) NOT NULL, -- borrowernumber link
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
3870
  PRIMARY KEY (`borrowernumber_id`),
3871
  CONSTRAINT `houseboundvisit_bnfk`
3872
    FOREIGN KEY (`borrowernumber_id`)
3873
    REFERENCES `borrowers` (`borrowernumber`)
3874
    ON UPDATE CASCADE ON DELETE CASCADE
3875
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3876
3861
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3877
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3862
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3878
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3863
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3879
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3864
- 

Return to bug 5670