Bugzilla – Attachment 98128 Details for
Bug 23590
Add the ability to change the manager of a suggestion and notify the new manager
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23590: Add atomic update file
Bug-23590-Add-atomic-update-file.patch (text/plain), 1.63 KB, created by
Jonathan Druart
on 2020-01-30 09:32:06 UTC
(
hide
)
Description:
Bug 23590: Add atomic update file
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2020-01-30 09:32:06 UTC
Size:
1.63 KB
patch
obsolete
>From 1c22c7bb721b5c86794033b531db7fbaff9ef9dc Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Wed, 13 Nov 2019 15:55:19 +0100 >Subject: [PATCH] Bug 23590: Add atomic update file > >Sponsored-by: BULAC - http://www.bulac.fr/ >--- > installer/data/mysql/atomicupdate/bug_23590.perl | 21 +++++++++++++++++++++ > 1 file changed, 21 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_23590.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_23590.perl b/installer/data/mysql/atomicupdate/bug_23590.perl >new file mode 100644 >index 0000000000..cb6d48d2e4 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_23590.perl >@@ -0,0 +1,21 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ if( !column_exists( 'suggestions', 'lastmodificationby' ) ) { >+ $dbh->do(q| >+ ALTER TABLE suggestions ADD COLUMN lastmodificationby INT(11) DEFAULT NULL AFTER rejecteddate >+ |); >+ >+ $dbh->do(q| >+ ALTER TABLE suggestions ADD CONSTRAINT `suggestions_ibfk_lastmodificationby` FOREIGN KEY (`lastmodificationby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE >+ |); >+ } >+ if( !column_exists( 'suggestions', 'lastmodificationdate' ) ) { >+ $dbh->do(q| >+ ALTER TABLE suggestions ADD COLUMN lastmodificationdate DATE DEFAULT NULL >+ |); >+ } >+ >+ # Always end with this (adjust the bug info) >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 23590 - Add lastmodificationby and lastmodificationdate to the suggestions table)\n"; >+} >-- >2.11.0
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 23590
:
95162
|
95163
|
95164
|
95165
|
95166
|
95167
|
95168
|
95169
|
95317
|
95318
|
95319
|
95320
|
95321
|
95322
|
95323
|
95324
|
95398
|
95399
|
95407
|
95408
|
95420
|
95421
|
95422
|
95423
|
95424
|
95425
|
95426
|
95427
|
95428
|
95429
|
95430
|
95431
|
95487
|
95488
|
95489
|
95490
|
95491
|
95492
|
95493
|
95494
|
95495
|
95496
|
95497
|
95498
|
98119
|
98120
|
98121
|
98122
|
98123
|
98124
|
98126
|
98127
|
98128
|
98129
|
98130
|
98131
|
98240
|
98267
|
98268
|
98279
|
100788
|
100789
|
100790
|
100791
|
100792
|
100793
|
100794
|
100795
|
100796
|
100797
|
100798
|
100799
|
100800
|
100801
|
100802
|
100803
|
100804
|
100846
|
100847
|
100848
|
100849
|
100850
|
100851
|
100852
|
100853
|
101539
|
101548
|
101588
|
101589
|
101590
|
101591
|
101592
|
101593
|
101594
|
101595
|
101596
|
101597
|
101598
|
101599
|
101600
|
101601
|
101602
|
101603
|
101604
|
101605
|
101606
|
101695