Attachment 14007 Details for Bug 9101 – Bug 9101: Add REPORT_GROUP to sample data

[patch] Bug 9101: Add REPORT_GROUP to sample data

Bug-9101-Add-REPORTGROUP-to-sample-data.patch (text/plain), 3.31 KB, created by Paul Poulain on 2012-12-11 18:24:03 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Paul Poulain

Created: 2012-12-11 18:24:03 UTC

Size: 3.31 KB

patch

obsolete

>From 8e8c8f1356de035fc8f817d040038627a9e09f4b Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <Katrin.Fischer.83@web.de>
>Date: Sat, 17 Nov 2012 20:45:13 +0100
>Subject: [PATCH] Bug 9101: Add REPORT_GROUP to sample data
>
>To test:
>Option 1) Run the English and German web installer and check authorised values
>have been added correctly.
>
>Option 2) Run SQL code from auth_val.sql for German and English against your
>database and check the authorised values have been added correctly.
>
>Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
>Signed-off-by: Paul Poulain <paul.poulain@biblibre.com>
>---
> installer/data/mysql/de-DE/optional/auth_val.sql |    7 +++++++
> installer/data/mysql/en/optional/auth_val.sql    |    7 +++++++
> 2 files changed, 14 insertions(+)
>
>diff --git a/installer/data/mysql/de-DE/optional/auth_val.sql b/installer/data/mysql/de-DE/optional/auth_val.sql
>index ed45274..3c45e08 100644
>--- a/installer/data/mysql/de-DE/optional/auth_val.sql
>+++ b/installer/data/mysql/de-DE/optional/auth_val.sql
>@@ -50,3 +50,10 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_N
> -- OPAC Suggestions reasons
> INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','Vorhandenes Exemplar ist beschÃ¤digt','Vorhandenes Exemplar ist beschÃ¤digt');
> INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Neuerscheinung von bekanntem Verfasser','Neuerscheinung von bekanntem Verfasser');
>+
>+-- Report groups
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Ausleihe');
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Katalog');
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Benutzer');
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Erwerbung');
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'GebÃ¼hren');
>diff --git a/installer/data/mysql/en/optional/auth_val.sql b/installer/data/mysql/en/optional/auth_val.sql
>index e1c7917..db6df3d 100644
>--- a/installer/data/mysql/en/optional/auth_val.sql
>+++ b/installer/data/mysql/en/optional/auth_val.sql
>@@ -50,3 +50,10 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_N
> -- 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');
>+
>+-- Report groups
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Circulation');
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Catalog');
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Patrons');
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisitions');
>+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Accounts');
>-- 
>1.7.9.5

Actions: View | Diff | Splinter Review

Attachments on bug 9101: 13500 | 13501 | 13596 | 14007