From b02c7bd00b0cd2583ce44d0bfc170aa146fa3824 Mon Sep 17 00:00:00 2001 From: Pedro Amorim Date: Thu, 20 Jul 2023 10:19:30 +0000 Subject: [PATCH] Bug 34587: Copy authorised value categories and authorised values to new installs (cherry picked from commit 338ae09e692420fe783da1699386b14891af62ab) Signed-off-by: Jessica Zairo Signed-off-by: Michaela Sieber Signed-off-by: Nick Clemens Signed-off-by: Tomas Cohen Arazi --- .../data/mysql/en/mandatory/auth_values.yml | 192 ++++++++++++++++++ .../data/mysql/mandatory/auth_val_cat.sql | 7 +- 2 files changed, 198 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/en/mandatory/auth_values.yml b/installer/data/mysql/en/mandatory/auth_values.yml index 2f5ed23e9e..b54cdb691b 100644 --- a/installer/data/mysql/en/mandatory/auth_values.yml +++ b/installer/data/mysql/en/mandatory/auth_values.yml @@ -263,6 +263,198 @@ tables: authorised_value: "audiobook" lib: "Audiobook" + - category: "ERM_REPORT_TYPES" + authorised_value: "PR" + lib: "PR - Platform master report" + + - category: "ERM_REPORT_TYPES" + authorised_value: "PR_P1" + lib: "PR_P1 - Platform usage" + + - category: "ERM_REPORT_TYPES" + authorised_value: "DR" + lib: "DR - Database master report" + + - category: "ERM_REPORT_TYPES" + authorised_value: "DR_D1" + lib: "DR_D1 - Database search and item usage" + + - category: "ERM_REPORT_TYPES" + authorised_value: "DR_D2" + lib: "DR_D2 - Database access denied" + + - category: "ERM_REPORT_TYPES" + authorised_value: "TR" + lib: "TR - Title master report" + + - category: "ERM_REPORT_TYPES" + authorised_value: "TR_B1" + lib: "TR_B1 - Book requests (excluding OA_Gold)" + + - category: "ERM_REPORT_TYPES" + authorised_value: "TR_B2" + lib: "TR_B2 - Book access denied" + + - category: "ERM_REPORT_TYPES" + authorised_value: "TR_B3" + lib: "TR_B3 - Book usage by access type" + + - category: "ERM_REPORT_TYPES" + authorised_value: "TR_J1" + lib: "TR_J1 - Journal requests (excluding OA_Gold)" + + - category: "ERM_REPORT_TYPES" + authorised_value: "TR_J2" + lib: "TR_J2 - Journal access denied" + + - category: "ERM_REPORT_TYPES" + authorised_value: "TR_J3" + lib: "TR_J3 - Journal usage by access type" + + - category: "ERM_REPORT_TYPES" + authorised_value: "TR_J4" + lib: "TR_J4 - Journal requests by YOP(excluding OA_Gold)" + + - category: "ERM_REPORT_TYPES" + authorised_value: "IR" + lib: "IR - Item master report" + + - category: "ERM_REPORT_TYPES" + authorised_value: "IR_A1" + lib: "IR_A1 - Journal article requests" + + - category: "ERM_REPORT_TYPES" + authorised_value: "IR_M1" + lib: "IR_M1 - Multimedia item requests" + + - category: "ERM_PLATFORM_REPORTS_METRICS" + authorised_value: "Searches_Platform" + lib: "Searches platform" + + - category: "ERM_PLATFORM_REPORTS_METRICS" + authorised_value: "Total_Item_Investigations" + lib: "Total item investigations" + + - category: "ERM_PLATFORM_REPORTS_METRICS" + authorised_value: "Total_Item_Requests" + lib: "Total item requests" + + - category: "ERM_PLATFORM_REPORTS_METRICS" + authorised_value: "Unique_Item_Investigations" + lib: "Unique item investigations" + + - category: "ERM_PLATFORM_REPORTS_METRICS" + authorised_value: "Unique_Item_Requests" + lib: "Unique item requests" + + - category: "ERM_PLATFORM_REPORTS_METRICS" + authorised_value: "Unique_Title_Investigations" + lib: "Unique title investigations" + + - category: "ERM_PLATFORM_REPORTS_METRICS" + authorised_value: "Unique_Title_Requests" + lib: "Unique title requests" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Searches_Automated" + lib: "Searches automated" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Searches_Federated" + lib: "Searches federated" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Searches_Regular" + lib: "Searches regular" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Total_Item_Investigations" + lib: "Total item investigations" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Total_Item_Requests" + lib: "Total item requests" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Unique_Item_Investigations" + lib: "Unique item investigations" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Unique_Item_Requests" + lib: "Unique item requests" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Unique_Title_Investigations" + lib: "Unique title investigations" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Unique_Title_Requests" + lib: "Unique title requests" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "No_License" + lib: "No license" + + - category: "ERM_DATABASE_REPORTS_METRICS" + authorised_value: "Limit_Exceeded" + lib: "Limit exceeded" + + - category: "ERM_TITLE_REPORTS_METRICS" + authorised_value: "Total_Item_Investigations" + lib: "Total item investigations" + + - category: "ERM_TITLE_REPORTS_METRICS" + authorised_value: "Total_Item_Requests" + lib: "Total item requests" + + - category: "ERM_TITLE_REPORTS_METRICS" + authorised_value: "Unique_Item_Investigations" + lib: "Unique item investigations" + + - category: "ERM_TITLE_REPORTS_METRICS" + authorised_value: "Unique_Item_Requests" + lib: "Unique item requests" + + - category: "ERM_TITLE_REPORTS_METRICS" + authorised_value: "Unique_Title_Investigations" + lib: "Unique title investigations" + + - category: "ERM_TITLE_REPORTS_METRICS" + authorised_value: "Unique_Title_Requests" + lib: "Unique title requests" + + - category: "ERM_TITLE_REPORTS_METRICS" + authorised_value: "Limit_Exceeded" + lib: "Limit exceeded" + + - category: "ERM_TITLE_REPORTS_METRICS" + authorised_value: "No_License" + lib: "No license" + + - category: "ERM_ITEM_REPORTS_METRICS" + authorised_value: "Total_Item_Investigations" + lib: "Total item investigations" + + - category: "ERM_ITEM_REPORTS_METRICS" + authorised_value: "Total_Item_Requests" + lib: "Total item requests" + + - category: "ERM_ITEM_REPORTS_METRICS" + authorised_value: "Unique_Item_Investigations" + lib: "Unique item investigations" + + - category: "ERM_ITEM_REPORTS_METRICS" + authorised_value: "Unique_Item_Requests" + lib: "Unique item requests" + + - category: "ERM_ITEM_REPORTS_METRICS" + authorised_value: "Limit_Exceeded" + lib: "Limit exceeded" + + - category: "ERM_ITEM_REPORTS_METRICS" + authorised_value: "No_License" + lib: "No license" + - category: "VENDOR_INTERFACE_TYPE" authorised_value: "ADMIN" lib: "Admin" diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql index 6c20dd427a..375ba87caf 100644 --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ b/installer/data/mysql/mandatory/auth_val_cat.sql @@ -89,4 +89,9 @@ VALUES ('ERM_AGREEMENT_LICENSE_LOCATION', 1), ('ERM_PACKAGE_TYPE', 1), ('ERM_PACKAGE_CONTENT_TYPE', 1), - ('ERM_TITLE_PUBLICATION_TYPE', 1); + ('ERM_TITLE_PUBLICATION_TYPE', 1), + ('ERM_REPORT_TYPES', 1), + ('ERM_PLATFORM_REPORTS_METRICS', 1), + ('ERM_DATABASE_REPORTS_METRICS', 1), + ('ERM_TITLE_REPORTS_METRICS', 1), + ('ERM_ITEM_REPORTS_METRICS', 1); -- 2.39.5