Attachment 78161 Details for Bug 7534 – Bug 7534: Add new column "pickup_location" to branches

[patch] Bug 7534: Add new column "pickup_location" to branches

Bug-7534-Add-new-column-pickuplocation-to-branches.patch (text/plain), 2.51 KB, created by Nick Clemens (kidclamp) on 2018-08-25 19:08:03 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2018-08-25 19:08:03 UTC

Size: 2.51 KB

patch

obsolete

>From ca357b938fbdf9b0a498051974a0d25aa96771cb Mon Sep 17 00:00:00 2001
>From: Lari Taskula <lari.taskula@jns.fi>
>Date: Tue, 7 Feb 2017 19:02:57 +0200
>Subject: [PATCH] Bug 7534: Add new column "pickup_location" to branches
>
>This patch adds a new column "pickup_location" for each library. This value
>defines whether a library can be used as a pickup location or not.
>
>For extended configurability, this flag could perhaps be considered as a part
>of issuing rules, but as of now, this patch only offers a simple flag into
>each library. This method also allows easy way for REST API to determine valid
>pickup locations by querying the /libraries endpoint.
>
>To test:
>1. perl installer/data/mysql/updatedatabase.pl
>2. Observe
>DEV atomic update: bug_7534.perl
>Upgrade to XXX done (Bug 7534 - Let libraries have configuration for pickup locations)
>
>https://bugs.koha-community.org/show_bug.cgi?id=7354
>
>Signed-off-by: Koha Team AMU <axelle.clarisse@univ-amu.fr>
>---
> installer/data/mysql/atomicupdate/bug_7534.perl | 7 +++++++
> installer/data/mysql/kohastructure.sql          | 1 +
> 2 files changed, 8 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_7534.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_7534.perl b/installer/data/mysql/atomicupdate/bug_7534.perl
>new file mode 100644
>index 0000000..0cf94c8
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_7534.perl
>@@ -0,0 +1,7 @@
>+$DBversion = 'XXX';  # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do( "ALTER TABLE branches ADD COLUMN pickup_location TINYINT(1) not null default 1" );
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 7534 - Let libraries have configuration for pickup locations)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index a15d416..7ed1705 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -267,6 +267,7 @@ CREATE TABLE `branches` ( -- information about your libraries or branches are st
>   opac_info MEDIUMTEXT, -- HTML that displays in OPAC
>   `geolocation` VARCHAR(255) default NULL, -- geolocation of your library
>   `marcorgcode` VARCHAR(16) default NULL, -- MARC Organization Code, see http://www.loc.gov/marc/organizations/orgshome.html, when empty defaults to syspref MARCOrgCode
>+  `pickup_location` tinyint(1) NOT NULL default 1, -- the ability to act as a pickup location
>   PRIMARY KEY (`branchcode`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> 
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 7534: 60014 | 60015 | 60016 | 60017 | 60018 | 60022 | 60023 | 60781 | 60794 | 60795 | 60796 | 60797 | 60798 | 60799 | 60878 | 60879 | 60880 | 60881 | 60882 | 60883 | 61044 | 61045 | 61046 | 61047 | 61273 | 61274 | 61275 | 61276 | 61277 | 61278 | 61279 | 61280 | 77847 | 77848 | 77849 | 77850 | 77851 | 77852 | 77853 | 77854 | 77855 | 77856 | 78160 | 78161 | 78162 | 78163 | 78164 | 78165 | 78166 | 78167 | 78168 | 78169 | 78170 | 78171 | 78477 | 78478 | 78479 | 78480 | 78481 | 78482 | 78483 | 78484 | 78485 | 78486 | 78487 | 78488 | 78489 | 78495 | 78540 | 78548 | 84852