Bugzilla – Attachment 122366 Details for
Bug 20472
Add digital scan as optional format to Article Requests
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 20472: Add new fields article_requests.format and urls
Bug-20472-Add-new-fields-articlerequestsformat-and.patch (text/plain), 1.41 KB, created by
Marcel de Rooy
on 2021-06-24 09:31:46 UTC
(
hide
)
Description:
Bug 20472: Add new fields article_requests.format and urls
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2021-06-24 09:31:46 UTC
Size:
1.41 KB
patch
obsolete
>From c9295204ab0d8b1cc741648f1e5ff64d5ba79af3 Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Mon, 26 Mar 2018 14:41:06 +0200 >Subject: [PATCH] Bug 20472: Add new fields article_requests.format and urls >Content-Type: text/plain; charset=utf-8 > >The field 'format' will allow to make a distinction between requests for >photocopies and digital scans. >The field 'urls' will be used to save the URLs that allow the client to >download the scanned materials. > >Test plan: >Run new install or upgrade existing install with atomic update. > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > installer/data/mysql/atomicupdate/bug_20472a.perl | 9 +++++++++ > 1 file changed, 9 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_20472a.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_20472a.perl b/installer/data/mysql/atomicupdate/bug_20472a.perl >new file mode 100644 >index 0000000000..a789245112 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_20472a.perl >@@ -0,0 +1,9 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ $dbh->do(q| >+ ALTER TABLE article_requests >+ ADD COLUMN `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY' AFTER notes, >+ ADD COLUMN `urls` MEDIUMTEXT AFTER format >+ |); >+ NewVersion( $DBversion, 20472, "Add columns format and urls in article_requests table"); >+} >-- >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 20472
:
107506
|
107507
|
107508
|
107509
|
107510
|
107511
|
107512
|
111473
|
111474
|
111475
|
111476
|
111477
|
111478
|
111479
|
122366
|
122367
|
122368
|
122369
|
122370
|
122371
|
122372
|
122373
|
122374
|
122375
|
122376
|
122377
|
122378
|
122379
|
122382
|
122383
|
122699
|
122700
|
122701
|
122702
|
122703
|
122704
|
122705
|
122706
|
122775
|
122781