Attachment 41825 Details for Bug 9468 – Bug 9468: sample SUGGEST_FORMAT values

[patch] Bug 9468: sample SUGGEST_FORMAT values

Bug-9468-sample-SUGGESTFORMAT-values.patch (text/plain), 2.08 KB, created by Kyle M Hall (khall) on 2015-08-24 10:47:57 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2015-08-24 10:47:57 UTC

Size: 2.08 KB

patch

obsolete

>From 8cc87a2da1cb6590b6590a60db7c3b5c69721819 Mon Sep 17 00:00:00 2001
>From: Galen Charlton <gmc@esilibrary.com>
>Date: Mon, 5 May 2014 00:30:24 +0000
>Subject: [PATCH] Bug 9468: sample SUGGEST_FORMAT values
>
>This patch adds some sample values for the SUGGEST_FORMAT
>authorized value list for new installations.
>
>To test
>-------
>[1] Verify that the new SQL inserts added by this patch work.
>
>Signed-off-by: Galen Charlton <gmc@esilibrary.com>
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>---
> installer/data/mysql/en/optional/auth_val.sql |    7 +++++++
> 1 files changed, 7 insertions(+), 0 deletions(-)
>
>diff --git a/installer/data/mysql/en/optional/auth_val.sql b/installer/data/mysql/en/optional/auth_val.sql
>index 35d3ff6..bfc6fec 100644
>--- a/installer/data/mysql/en/optional/auth_val.sql
>+++ b/installer/data/mysql/en/optional/auth_val.sql
>@@ -4,6 +4,13 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST
> INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Library Copy Lost');
> INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
> 
>+-- Desired formats for requesting new materials
>+INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book');
>+INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print');
>+INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
>+INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
>+INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
>+
> -- availability statuses
> INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
> INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
>-- 
>1.7.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 9468: 14801 | 16647 | 16674 | 19086 | 21759 | 21760 | 22714 | 22715 | 27932 | 27933 | 27934 | 27935 | 37100 | 37101 | 37102 | 37103 | 38097 | 38163 | 38164 | 38165 | 38166 | 38167 | 38168 | 41822 | 41823 | 41824 | 41825 | 41826 | 41827 | 41828 | 41936 | 41937 | 41938 | 41939 | 41940 | 41941 | 41942 | 41943 | 44504 | 44505 | 44506 | 44507 | 44508 | 44509 | 44510