Bugzilla – Attachment 95457 Details for
Bug 23260
Anonymize (remove) patron data from items_last_borrower
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23260: Make borrowernumber nullable in items_last_borrower
Bug-23260-Make-borrowernumber-nullable-in-itemslas.patch (text/plain), 1.86 KB, created by
Agustín Moyano
on 2019-11-15 17:13:00 UTC
(
hide
)
Description:
Bug 23260: Make borrowernumber nullable in items_last_borrower
Filename:
MIME Type:
Creator:
Agustín Moyano
Created:
2019-11-15 17:13:00 UTC
Size:
1.86 KB
patch
obsolete
>From b3ba3b43f7261b9d23fcfeef9fff595fec82f01f Mon Sep 17 00:00:00 2001 >From: Agustin Moyano <agustinmoyano@theke.io> >Date: Mon, 16 Sep 2019 17:47:44 -0300 >Subject: [PATCH] Bug 23260: Make borrowernumber nullable in > items_last_borrower > >This patch alters table structure to make borrowernumber nullable > >Sponsored-by: Northeast Kansas Library System >--- > installer/data/mysql/atomicupdate/bug_23260.perl | 8 ++++++++ > installer/data/mysql/kohastructure.sql | 2 +- > 2 files changed, 9 insertions(+), 1 deletion(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_23260.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_23260.perl b/installer/data/mysql/atomicupdate/bug_23260.perl >new file mode 100644 >index 0000000000..b758f58b33 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_23260.perl >@@ -0,0 +1,8 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ # you can use $dbh here like: >+ $dbh->do( "ALTER TABLE items_last_borrower MODIFY COLUMN `borrowernumber` int(11) default NULL" ); >+ >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 23260 - make borrowernumber from items_last_borrower nullable)\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 67495ab962..0b8ee7dae9 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1726,7 +1726,7 @@ CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r > CREATE TABLE IF NOT EXISTS `items_last_borrower` ( > `id` int(11) NOT NULL AUTO_INCREMENT, > `itemnumber` int(11) NOT NULL, >- `borrowernumber` int(11) NOT NULL, >+ `borrowernumber` int(11) default NULL, > `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, > PRIMARY KEY (`id`), > UNIQUE KEY `itemnumber` (`itemnumber`), >-- >2.17.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 23260
:
92863
|
92864
|
93052
|
94858
|
94859
|
95033
|
95457
|
95458
|
95459
|
95460
|
95651
|
95698
|
95699
|
95700
|
95701
|
95769
|
95770
|
95771
|
95772
|
96791
|
97841
|
97842
|
98044
|
98053
|
98054
|
98064
|
98282
|
98349
|
98352
|
112734
|
112735
|
112736
|
112737
|
112738
|
112739
|
112740
|
112741
|
112742
|
112743
|
117974
|
117975
|
117976
|
117977
|
117978
|
117979
|
117980
|
117981
|
117982
|
117983
|
120522
|
120523
|
120524
|
120525
|
120526
|
120527
|
120528
|
120529
|
120530
|
120531
|
122963
|
122964
|
122965
|
122966
|
122967
|
122968
|
122969
|
122970
|
122971
|
122972
|
145175
|
145176
|
145177
|
145178
|
145179
|
145180
|
145181
|
145182
|
145183
|
145184
|
157106
|
157107
|
157108
|
157109
|
157110
|
157111
|
157112
|
157113
|
157114
|
157115
|
157116
|
159291
|
159292
|
159293
|
159294
|
159298
|
159299
|
159300
|
159301
|
164129
|
164130
|
164131
|
164132
|
164133