From ac562cafb774d26ef64d428d63dc1d9d7b052546 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Tue, 22 Feb 2011 21:58:17 +0100 Subject: [PATCH] BZ1883 follow-up solve comment 10 from nengard: This patch added these types only on upgrade. We need them to be added to new installs to. --- installer/data/mysql/en/optional/auth_val.sql | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/en/optional/auth_val.sql b/installer/data/mysql/en/optional/auth_val.sql index 12856d0..4c81325 100644 --- a/installer/data/mysql/en/optional/auth_val.sql +++ b/installer/data/mysql/en/optional/auth_val.sql @@ -51,3 +51,7 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUA -- custom borrower notes INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Address Notes'); + +-- OPAC Suggestions reasons +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','The copy on the shelf is damaged','The copy on the shelf is damaged'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Upcoming title by popular author','Upcoming title by popular author'); -- 1.7.1