Bugzilla – Attachment 122781 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 kohastructure changes
Bug-20472-Add-kohastructure-changes.patch (text/plain), 1.15 KB, created by
Jonathan Druart
on 2021-07-12 13:37:40 UTC
(
hide
)
Description:
Bug 20472: Add kohastructure changes
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2021-07-12 13:37:40 UTC
Size:
1.15 KB
patch
obsolete
>From 2e5b598d26a99914c86fbd36028fab5656445e5d Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Mon, 12 Jul 2021 15:37:14 +0200 >Subject: [PATCH] Bug 20472: Add kohastructure changes > >--- > installer/data/mysql/kohastructure.sql | 2 ++ > 1 file changed, 2 insertions(+) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 70b7e5346ed..58dadc1541c 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -766,6 +766,8 @@ CREATE TABLE `article_requests` ( > `patron_notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, > `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING', > `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, >+ `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY', >+ `urls` MEDIUMTEXT, > `created_on` timestamp NULL DEFAULT NULL COMMENT '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.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