Bugzilla – Attachment 134581 Details for
Bug 23681
Make patron restrictions user definable
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23681: Add debarment_types
Bug-23681-Add-debarmenttypes.patch (text/plain), 5.66 KB, created by
Martin Renvoize (ashimema)
on 2022-05-04 11:41:55 UTC
(
hide
)
Description:
Bug 23681: Add debarment_types
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2022-05-04 11:41:55 UTC
Size:
5.66 KB
patch
obsolete
>From 3da2aa3f807187cad0f1966b60bc2ae8ac78c5b4 Mon Sep 17 00:00:00 2001 >From: Andrew Isherwood <andrew.isherwood@ptfs-europe.com> >Date: Tue, 1 Oct 2019 14:58:22 +0100 >Subject: [PATCH] Bug 23681: Add debarment_types > >This patch adds the table debarment_types and changes >borrower_debarments.type to be a foreign key to it > >Signed-off-by: Benjamin Veasey <B.T.Veasey@lboro.ac.uk> >Sponsored-by: Loughborough University >--- > .../bug_23681_add_debarment_types.perl | 33 +++++++++++++++++++ > .../en/mandatory/patron_restrictions.sql | 5 +++ > .../en/mandatory/patron_restrictions.txt | 1 + > installer/data/mysql/kohastructure.sql | 13 ++++++-- > 4 files changed, 50 insertions(+), 2 deletions(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_23681_add_debarment_types.perl > create mode 100644 installer/data/mysql/en/mandatory/patron_restrictions.sql > create mode 100644 installer/data/mysql/en/mandatory/patron_restrictions.txt > >diff --git a/installer/data/mysql/atomicupdate/bug_23681_add_debarment_types.perl b/installer/data/mysql/atomicupdate/bug_23681_add_debarment_types.perl >new file mode 100644 >index 0000000000..4fc862c954 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_23681_add_debarment_types.perl >@@ -0,0 +1,33 @@ >+$DBversion = 'XXX'; >+ >+if ( CheckVersion( $DBversion ) ) { >+ >+ if ( !TableExists( 'debarment_types' ) ) { >+ $dbh->do( q| >+ CREATE TABLE debarment_types ( >+ code varchar(50) NOT NULL PRIMARY KEY, >+ display_text text NOT NULL, >+ ronly tinyint(1) NOT NULL DEFAULT 0, >+ dflt tinyint(1) NOT NULL DEFAULT 0 >+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+ | ); >+ $dbh->do( q| >+ INSERT INTO debarment_types (code, display_text, ronly, dflt) VALUES >+ ('MANUAL', 'Manual', 1, 1), >+ ('OVERDUES', 'Overdues', 1, 0), >+ ('SUSPENSION', 'Suspension', 1, 0), >+ ('DISCHARGE', 'Discharge', 1, 0); >+ |); >+ } >+ $dbh->do( q| >+ ALTER TABLE borrower_debarments >+ MODIFY COLUMN type varchar(50) NOT NULL >+ | ); >+ $dbh->do( q| >+ ALTER TABLE borrower_debarments >+ ADD CONSTRAINT borrower_debarments_ibfk_2 FOREIGN KEY (type) REFERENCES debarment_types(code) ON DELETE NO ACTION ON UPDATE CASCADE; >+ | ); >+ >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 23681 - Add debarment_types)\n"; >+} >diff --git a/installer/data/mysql/en/mandatory/patron_restrictions.sql b/installer/data/mysql/en/mandatory/patron_restrictions.sql >new file mode 100644 >index 0000000000..a6eedf27a9 >--- /dev/null >+++ b/installer/data/mysql/en/mandatory/patron_restrictions.sql >@@ -0,0 +1,5 @@ >+INSERT INTO debarment_types (code, display_text, ronly, dflt) VALUES >+ ('MANUAL', 'Manual', 1, 1), >+ ('OVERDUES', 'Overdues', 1, 0), >+ ('SUSPENSION', 'Suspension', 1, 0), >+ ('DISCHARGE', 'Discharge', 1, 0); >diff --git a/installer/data/mysql/en/mandatory/patron_restrictions.txt b/installer/data/mysql/en/mandatory/patron_restrictions.txt >new file mode 100644 >index 0000000000..b17a7c1270 >--- /dev/null >+++ b/installer/data/mysql/en/mandatory/patron_restrictions.txt >@@ -0,0 +1 @@ >+Default Koha system patron restriction types >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 3afb0455cc..126ab37ed9 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1183,14 +1183,15 @@ CREATE TABLE `borrower_debarments` ( > `borrower_debarment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique key for the restriction', > `borrowernumber` int(11) NOT NULL COMMENT 'foreign key for borrowers.borrowernumber for patron who is restricted', > `expiration` date DEFAULT NULL COMMENT 'expiration date of the restriction', >- `type` enum('SUSPENSION','OVERDUES','MANUAL','DISCHARGE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'MANUAL' COMMENT 'type of restriction', >+ `type` varchar(50) NOT NULL COMMENT 'type of restriction, FK to debarment_types.code', > `comment` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'comments about the restriction', > `manager_id` int(11) DEFAULT NULL COMMENT 'foreign key for borrowers.borrowernumber for the librarian managing the restriction', > `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date the restriction was added', > `updated` timestamp NULL DEFAULT NULL COMMENT 'date the restriction was updated', > PRIMARY KEY (`borrower_debarment_id`), > KEY `borrowernumber` (`borrowernumber`), >- CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE >+ CONSTRAINT `borrower_debarments_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, >+ CONSTRAINT `borrower_debarments_ibfk_2` FOREIGN KEY (`type`) REFERENCES `debarment_types` (`code`) ON DELETE NO ACTION ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > >@@ -2020,6 +2021,14 @@ CREATE TABLE `collections_tracking` ( > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > >+DROP TABLE IF EXISTS `debarment_types`; >+CREATE TABLE debarment_types ( >+ code varchar(50) NOT NULL PRIMARY KEY, >+ display_text text NOT NULL, >+ ronly tinyint(1) NOT NULL DEFAULT 0, >+ dflt tinyint(1) NOT NULL DEFAULT 0 >+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+ > -- > -- Table structure for table `columns_settings` > -- >-- >2.20.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 23681
:
93769
|
93770
|
93771
|
93772
|
93773
|
93774
|
93775
|
93776
|
93777
|
93778
|
93779
|
93780
|
93781
|
93782
|
93783
|
93784
|
93785
|
93786
|
94862
|
94863
|
94864
|
94865
|
94866
|
94867
|
94868
|
94869
|
94870
|
94896
|
94897
|
94898
|
94899
|
94900
|
94901
|
94902
|
94903
|
94904
|
95148
|
95255
|
95256
|
95257
|
95258
|
95259
|
95260
|
95261
|
95262
|
95263
|
95264
|
99893
|
99894
|
99895
|
99896
|
99897
|
99898
|
99899
|
99900
|
99901
|
99902
|
130373
|
130374
|
130375
|
130376
|
130377
|
130378
|
130379
|
130380
|
130381
|
130382
|
130383
|
130384
|
132302
|
132303
|
132304
|
132305
|
132306
|
132307
|
132308
|
132309
|
132310
|
132311
|
132312
|
132313
|
132314
|
132315
|
132316
|
132318
|
132319
|
132320
|
134512
|
134513
|
134514
|
134515
|
134516
|
134517
|
134518
|
134519
|
134520
|
134521
|
134522
|
134523
|
134524
|
134525
|
134526
|
134527
|
134528
|
134529
|
134580
|
134581
|
134582
|
134583
|
134584
|
134585
|
134586
|
134587
|
134588
|
134589
|
134590
|
134591
|
134592
|
134593
|
134594
|
134595
|
134596
|
134597
|
134598
|
134599
|
134600
|
134601
|
134602
|
134684
|
134685
|
134686
|
134687
|
134688
|
134689
|
134690
|
134691
|
134692
|
134693
|
134694
|
134696
|
134697
|
134698
|
134699
|
134700
|
134701
|
134702
|
134703
|
134704
|
134705
|
134706
|
134707
|
134708
|
136716
|
136717
|
136718
|
136719
|
136720
|
136721
|
136722
|
136723
|
136724
|
136725
|
136726
|
136727
|
136728
|
136729
|
136730
|
136731
|
136732
|
136733
|
136734
|
136735
|
136736
|
136737
|
136738
|
136739
|
137066
|
137067
|
137068
|
137069
|
137070
|
137071
|
137072
|
137073
|
137074
|
137075
|
137076
|
137077
|
137078
|
137079
|
137080
|
137081
|
137082
|
137083
|
137084
|
137085
|
137086
|
137087
|
137088
|
137089
|
137090
|
137091
|
137092
|
137093
|
137094
|
137102
|
137103
|
137104
|
137105
|
137106
|
137107
|
137108
|
137109
|
137110
|
137111
|
137112
|
137113
|
137114
|
137115
|
137116
|
137117
|
137118
|
137119
|
137120
|
137121
|
137122
|
137123
|
137124
|
137125
|
137126
|
137127
|
137128
|
137129
|
137130
|
139250
|
139251
|
139252
|
139253
|
139254
|
139255
|
139256
|
139257
|
139258
|
139259
|
139260
|
139261
|
139262
|
139263
|
139264
|
139265
|
139266
|
139267
|
139268
|
139269
|
139270
|
139271
|
139272
|
139273
|
139509
|
139512
|
139649
|
139717
|
139768
|
139769
|
139770
|
139771
|
139772
|
139773
|
139774
|
139775
|
139776
|
139777
|
139778
|
139779
|
139780
|
139781
|
139782
|
139783
|
139784
|
139785
|
139786
|
139787
|
139788
|
139789
|
139790
|
139791
|
139792
|
139793
|
139794
|
139795