Bugzilla – Attachment 111473 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), 2.26 KB, created by
Marcel de Rooy
on 2020-10-12 08:00:20 UTC
(
hide
)
Description:
Bug 20472: Add new fields article_requests.format and urls
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2020-10-12 08:00:20 UTC
Size:
2.26 KB
patch
obsolete
>From e41f9c403683b61bb7d0cca3ebc1cf8b77844f13 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 +++++++++ > installer/data/mysql/kohastructure.sql | 2 ++ > 2 files changed, 11 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"); >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index c7e584e1e6..90c786f600 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -4078,6 +4078,8 @@ CREATE TABLE `article_requests` ( > `patron_notes` MEDIUMTEXT, > `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') NOT NULL DEFAULT 'PENDING', > `notes` MEDIUMTEXT, >+ `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', >+ `urls` MEDIUMTEXT, -- One or more URLs for downloading scanned articles, separated by semicolons > `created_on` timestamp NULL DEFAULT NULL, -- Be careful with two timestamps in one table not allowing NULL > `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, > PRIMARY KEY (`id`), >-- >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 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