Bugzilla – Attachment 56298 Details for
Bug 5670
Housebound Readers Module
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 5670: [QA Followup] Abandon Extended Patron Attr.
Bug-5670-QA-Followup-Create-housebound-roles-table.patch (text/plain), 5.70 KB, created by
Alex Sassmannshausen
on 2016-10-12 15:48:20 UTC
(
hide
)
Description:
Bug 5670: [QA Followup] Abandon Extended Patron Attr.
Filename:
MIME Type:
Creator:
Alex Sassmannshausen
Created:
2016-10-12 15:48:20 UTC
Size:
5.70 KB
patch
obsolete
>From 740ba446e3346537cfa1b2dc1ca0972a377af67e Mon Sep 17 00:00:00 2001 >From: Alex Sassmannshausen <alex.sassmannshausen@ptfs-europe.com> >Date: Mon, 10 Oct 2016 12:37:50 +0200 >Subject: [PATCH] Bug 5670: [QA Followup] Create housebound roles table. > >* installer/data/mysql/atomicupdate/housebound_tables.sql (housebound_role): > New table. >* installer/data/mysql/kohastructure.sql (housebound_role): New table. >* installer/data/mysql/en/mandatory/auth_values.sql: Remove HSBND_ROLE entries. >* installer/data/mysql/en/mandatory/patron_attributes.sql: Remove > HSBND_ROLE entry. >* installer/data/mysql/en/mandatory/patron_attributes.txt: Remove > explanatory text. >--- > .../data/mysql/atomicupdate/housebound_tables.sql | 20 ++++++++++++-------- > installer/data/mysql/en/mandatory/auth_values.sql | 5 +---- > .../data/mysql/en/mandatory/patron_attributes.sql | 4 ---- > .../data/mysql/en/mandatory/patron_attributes.txt | 2 -- > installer/data/mysql/kohastructure.sql | 16 ++++++++++++++++ > 5 files changed, 29 insertions(+), 18 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/housebound_tables.sql b/installer/data/mysql/atomicupdate/housebound_tables.sql >index 3219ade..49c3237 100644 >--- a/installer/data/mysql/atomicupdate/housebound_tables.sql >+++ b/installer/data/mysql/atomicupdate/housebound_tables.sql >@@ -36,17 +36,21 @@ CREATE TABLE IF NOT EXISTS `housebound_visit` ( > ON UPDATE CASCADE ON DELETE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > >+CREATE TABLE IF NOT EXISTS `housebound_role` ( >+ `borrowernumber_id` int(11) NOT NULL, -- borrowernumber link >+ `housebound_chooser` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound chooser volunteer >+ `housebound_deliverer` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound deliverer volunteer >+ PRIMARY KEY (`borrowernumber_id`), >+ CONSTRAINT `houseboundrole_bnfk` >+ FOREIGN KEY (`borrowernumber_id`) >+ REFERENCES `borrowers` (`borrowernumber`) >+ ON UPDATE CASCADE ON DELETE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ > INSERT IGNORE INTO systempreferences > (variable,value,options,explanation,type) VALUES > ('HouseboundModule',0,'', > 'If ON, enable housebound module functionality.','YesNo'); > > INSERT IGNORE INTO authorised_values (category, authorised_value, lib) VALUES >- ('HSBND_FREQ','EW','Every week'), >- ('HSBND_ROLE','CHO','Chooser'), >- ('HSBND_ROLE','DEL','Deliverer'); >- >-INSERT IGNORE INTO borrower_attribute_types >- (code, description, repeatable, opac_display, staff_searchable, >- authorised_value_category, display_checkout) values >- ('HSBND', 'Housebound role', 1, 1, 1, 'HSBND_ROLE', 1); >+ ('HSBND_FREQ','EW','Every week'); >diff --git a/installer/data/mysql/en/mandatory/auth_values.sql b/installer/data/mysql/en/mandatory/auth_values.sql >index 511b096..26328ef 100644 >--- a/installer/data/mysql/en/mandatory/auth_values.sql >+++ b/installer/data/mysql/en/mandatory/auth_values.sql >@@ -1,6 +1,3 @@ > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No'); > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes'); >-INSERT INTO authorised_values (category, authorised_value, lib) VALUES >- ('HSBND_FREQ','EW','Every week'), >- ('HSBND_ROLE','CHO','Chooser'), >- ('HSBND_ROLE','DEL','Deliverer'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); >diff --git a/installer/data/mysql/en/mandatory/patron_attributes.sql b/installer/data/mysql/en/mandatory/patron_attributes.sql >index 89845ad..e69de29 100644 >--- a/installer/data/mysql/en/mandatory/patron_attributes.sql >+++ b/installer/data/mysql/en/mandatory/patron_attributes.sql >@@ -1,4 +0,0 @@ >-INSERT INTO borrower_attribute_types >- (code, description, repeatable, opac_display, staff_searchable, >- authorised_value_category, display_checkout) values >- ('HSBND', 'Housebound role', 1, 1, 1, 'HSBND_ROLE', 1); >diff --git a/installer/data/mysql/en/mandatory/patron_attributes.txt b/installer/data/mysql/en/mandatory/patron_attributes.txt >index c2d0d4f..e69de29 100644 >--- a/installer/data/mysql/en/mandatory/patron_attributes.txt >+++ b/installer/data/mysql/en/mandatory/patron_attributes.txt >@@ -1,2 +0,0 @@ >-Default Koha system extended patron attributes: >-* HSBND - Allow assignment of different housebound roles for volunteers >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index f2c40b8..d1fe986 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3845,6 +3845,22 @@ CREATE TABLE `housebound_visit` ( > ON UPDATE CASCADE ON DELETE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > >+-- >+-- Table structure for table `housebound_role` >+-- >+ >+DROP TABLE IF EXISTS `housebound_role`; >+CREATE TABLE IF NOT EXISTS `housebound_role` ( >+ `borrowernumber_id` int(11) NOT NULL, -- borrowernumber link >+ `housebound_chooser` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound chooser volunteer >+ `housebound_deliverer` tinyint(1) NOT NULL DEFAULT 0, -- set to 1 to indicate this patron is a housebound deliverer volunteer >+ PRIMARY KEY (`borrowernumber_id`), >+ CONSTRAINT `houseboundvisit_bnfk` >+ FOREIGN KEY (`borrowernumber_id`) >+ REFERENCES `borrowers` (`borrowernumber`) >+ ON UPDATE CASCADE ON DELETE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; >+ > /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; > /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; > /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; >-- >2.10.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 5670
:
3038
|
22162
|
22163
|
22164
|
22165
|
26816
|
27288
|
50930
|
51377
|
51875
|
54384
|
54385
|
55326
|
55334
|
55335
|
55336
|
55734
|
55735
|
55736
|
55737
|
55738
|
55739
|
55865
|
55866
|
55867
|
55890
|
55891
|
56298
|
56299
|
56300
|
56301
|
56302
|
56308
|
56337
|
56341
|
56346
|
56347
|
56348
|
56349
|
56350
|
56351
|
56352
|
56353
|
56354
|
56355
|
56356
|
56357
|
56358
|
56359
|
56360
|
56361
|
56362
|
56363
|
56364
|
56365
|
56366
|
56367
|
56368
|
56369
|
56580
|
56581
|
56582
|
56583
|
56584
|
56585
|
56586
|
56587
|
56588
|
56589
|
56590
|
56591
|
56592
|
56593
|
56594
|
56595
|
56596
|
56597
|
56598
|
56599
|
56600
|
56601
|
56602
|
56603
|
56604
|
56605
|
56606