Bugzilla – Attachment 56217 Details for
Bug 17216
Add a new table to store authorized value categories
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[PASSED QA] Bug 17216: Move the AV cat list file to the top level
PASSED-QA-Bug-17216-Move-the-AV-cat-list-file-to-t.patch (text/plain), 4.93 KB, created by
Katrin Fischer
on 2016-10-11 15:37:56 UTC
(
hide
)
Description:
[PASSED QA] Bug 17216: Move the AV cat list file to the top level
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2016-10-11 15:37:56 UTC
Size:
4.93 KB
patch
obsolete
>From 99427a9aa28f11fd52ae9440f416393e4f3b060d Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Tue, 27 Sep 2016 13:44:13 +0100 >Subject: [PATCH] [PASSED QA] Bug 17216: Move the AV cat list file to the top > level > >This way it will get used for any languages. > >Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de> >--- > C4/Installer.pm | 3 ++ > installer/data/mysql/en/mandatory/auth_values.sql | 29 ------------ > .../Obligatoire/framework_DEFAULT.sql | 6 +++ > installer/data/mysql/mandatory/auth_val_cat.sql | 51 ++++++++++++++++++++++ > 4 files changed, 60 insertions(+), 29 deletions(-) > create mode 100644 installer/data/mysql/mandatory/auth_val_cat.sql > >diff --git a/C4/Installer.pm b/C4/Installer.pm >index f5af971..719e6b2 100644 >--- a/C4/Installer.pm >+++ b/C4/Installer.pm >@@ -301,6 +301,9 @@ sub load_sql_in_order { > # Make sure subtag_registry.sql is loaded second > my $subtag_registry = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/mandatory/subtag_registry.sql"; > unshift(@fnames, $subtag_registry); >+ # Make sure authorised value categories are loaded at the beginning >+ my $av_cat = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/mandatory/auth_val_cat.sql"; >+ unshift(@fnames, $av_cat); > # Make sure the global sysprefs.sql file is loaded first > my $globalsysprefs = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/sysprefs.sql"; > unshift(@fnames, $globalsysprefs); >diff --git a/installer/data/mysql/en/mandatory/auth_values.sql b/installer/data/mysql/en/mandatory/auth_values.sql >index 74b917d..d7fb280 100644 >--- a/installer/data/mysql/en/mandatory/auth_values.sql >+++ b/installer/data/mysql/en/mandatory/auth_values.sql >@@ -1,31 +1,2 @@ > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No'); > INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes'); >-INSERT IGNORE INTO authorised_value_categories( category_name ) >- VALUES >- ('Asort1'), >- ('Asort2'), >- ('Bsort1'), >- ('Bsort2'), >- ('SUGGEST'), >- ('DAMAGED'), >- ('LOST'), >- ('REPORT_GROUP'), >- ('REPORT_SUBGROUP'), >- ('DEPARTMENT'), >- ('TERM'), >- ('SUGGEST_STATUS'), >- ('ITEMTYPECAT'); >-INSERT IGNORE INTO authorised_value_categories( category_name ) >- VALUES >- ('branches'), >- ('itemtypes'), >- ('cn_source'); >- >-INSERT IGNORE INTO authorised_value_categories( category_name ) >- VALUES >- ('WITHDRAWN'), >- ('RESTRICTED'), >- ('NOT_LOAN'), >- ('CCODE'), >- ('LOC'), >- ('STACK'); >diff --git a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql >index befaece..89a48b1 100644 >--- a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql >+++ b/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql >@@ -31,6 +31,12 @@ INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('MULT' > INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('PERI', 'Périodique'); > INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('WEB', 'Ressource web'); > >+-- >+-- Add some AV categories specific to this file >+-- >+ >+INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('statut'), ('genre'), ('public'), ('local'), ('pcdm'); >+ > -- > -- Contenu de la table `marc_tag_structure` > -- >diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql >new file mode 100644 >index 0000000..5584a3d >--- /dev/null >+++ b/installer/data/mysql/mandatory/auth_val_cat.sql >@@ -0,0 +1,51 @@ >+INSERT IGNORE INTO authorised_value_categories( category_name ) >+ VALUES >+ (''), >+ ('Asort1'), >+ ('Asort2'), >+ ('Bsort1'), >+ ('Bsort2'), >+ ('SUGGEST'), >+ ('SUGGEST_STATUS'), >+ ('SUGGEST_FORMAT'), >+ ('DAMAGED'), >+ ('LOST'), >+ ('REPORT_GROUP'), >+ ('REPORT_SUBGROUP'), >+ ('DEPARTMENT'), >+ ('TERM'), >+ ('ITEMTYPECAT'); >+INSERT IGNORE INTO authorised_value_categories( category_name ) >+ VALUES >+ ('branches'), >+ ('itemtypes'), >+ ('cn_source'); >+ >+INSERT IGNORE INTO authorised_value_categories( category_name ) >+ VALUES >+ ('WITHDRAWN'), >+ ('RESTRICTED'), >+ ('NOT_LOAN'), >+ ('CCODE'), >+ ('LOC'), >+ ('MANUAL_INV'), >+ ('BOR_NOTES'), >+ ('OPAC_SUG'), >+ ('SIP_MEDIA_TYPE'), >+ ('ORDER_CANCELLATION_REASON'), >+ ('RELTERMS'), >+ ('YES_NO'), >+ ('LANG'), >+ ('HINGS_UT'), >+ ('HINGS_PF'), >+ ('HINGS_C'), >+ ('HINGS_AS'), >+ ('HINGS_RD'), >+ ('STACK'); >+ >+-- UNIMARC specific? >+INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES >+ ('ETAT'), >+ ('CAND'), >+ ('COUNTRY'), >+ ('qualif'); >-- >2.7.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 17216
:
54979
|
54980
|
54981
|
54982
|
54983
|
54984
|
54985
|
54987
|
54988
|
54989
|
54990
|
54991
|
54992
|
54993
|
55003
|
55004
|
55005
|
55008
|
55009
|
55010
|
55011
|
55021
|
55022
|
55023
|
55024
|
55025
|
55026
|
55027
|
55028
|
55029
|
55030
|
55031
|
55032
|
55047
|
55207
|
55208
|
55209
|
55210
|
55211
|
55212
|
55213
|
55214
|
55215
|
55216
|
55217
|
55218
|
55365
|
55366
|
55367
|
55368
|
55369
|
55370
|
55371
|
55372
|
55373
|
55374
|
55375
|
55376
|
55692
|
55693
|
55835
|
55840
|
56202
|
56203
|
56204
|
56205
|
56206
|
56207
|
56208
|
56209
|
56210
|
56211
|
56212
|
56213
|
56214
|
56215
|
56216
| 56217 |
56619
|
57729