View | Details | Raw Unified | Return to bug 17216
Collapse All | Expand All

(-)a/C4/Installer.pm (+3 lines)
Lines 301-306 sub load_sql_in_order { Link Here
301
    # Make sure subtag_registry.sql is loaded second
301
    # Make sure subtag_registry.sql is loaded second
302
    my $subtag_registry = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/mandatory/subtag_registry.sql";
302
    my $subtag_registry = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/mandatory/subtag_registry.sql";
303
    unshift(@fnames, $subtag_registry);
303
    unshift(@fnames, $subtag_registry);
304
    # Make sure authorised value categories are loaded at the beginning
305
    my $av_cat = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/mandatory/auth_val_cat.sql";
306
    unshift(@fnames, $av_cat);
304
    # Make sure the global sysprefs.sql file is loaded first
307
    # Make sure the global sysprefs.sql file is loaded first
305
    my $globalsysprefs = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/sysprefs.sql";
308
    my $globalsysprefs = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/sysprefs.sql";
306
    unshift(@fnames, $globalsysprefs);
309
    unshift(@fnames, $globalsysprefs);
(-)a/installer/data/mysql/en/mandatory/auth_values.sql (-29 lines)
Lines 1-31 Link Here
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
3
INSERT IGNORE INTO authorised_value_categories( category_name )
4
    VALUES
5
    ('Asort1'),
6
    ('Asort2'),
7
    ('Bsort1'),
8
    ('Bsort2'),
9
    ('SUGGEST'),
10
    ('DAMAGED'),
11
    ('LOST'),
12
    ('REPORT_GROUP'),
13
    ('REPORT_SUBGROUP'),
14
    ('DEPARTMENT'),
15
    ('TERM'),
16
    ('SUGGEST_STATUS'),
17
    ('ITEMTYPECAT');
18
INSERT IGNORE INTO authorised_value_categories( category_name )
19
    VALUES
20
    ('branches'),
21
    ('itemtypes'),
22
    ('cn_source');
23
24
INSERT IGNORE INTO authorised_value_categories( category_name )
25
    VALUES
26
    ('WITHDRAWN'),
27
    ('RESTRICTED'),
28
    ('NOT_LOAN'),
29
    ('CCODE'),
30
    ('LOC'),
31
    ('STACK');
(-)a/installer/data/mysql/fr-FR/marcflavour/unimarc_lecture_pub/Obligatoire/framework_DEFAULT.sql (+6 lines)
Lines 31-36 INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('MULT' Link Here
31
INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('PERI', 'Périodique');
31
INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('PERI', 'Périodique');
32
INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('WEB', 'Ressource web');
32
INSERT INTO `biblio_framework` (`frameworkcode`, `frameworktext`) VALUES ('WEB', 'Ressource web');
33
33
34
--
35
-- Add some AV categories specific to this file
36
--
37
38
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('statut'), ('genre'), ('public'), ('local'), ('pcdm');
39
34
-- 
40
-- 
35
-- Contenu de la table `marc_tag_structure`
41
-- Contenu de la table `marc_tag_structure`
36
-- 
42
-- 
(-)a/installer/data/mysql/mandatory/auth_val_cat.sql (-1 / +51 lines)
Line 0 Link Here
0
- 
1
INSERT IGNORE INTO authorised_value_categories( category_name )
2
    VALUES
3
    (''),
4
    ('Asort1'),
5
    ('Asort2'),
6
    ('Bsort1'),
7
    ('Bsort2'),
8
    ('SUGGEST'),
9
    ('SUGGEST_STATUS'),
10
    ('SUGGEST_FORMAT'),
11
    ('DAMAGED'),
12
    ('LOST'),
13
    ('REPORT_GROUP'),
14
    ('REPORT_SUBGROUP'),
15
    ('DEPARTMENT'),
16
    ('TERM'),
17
    ('ITEMTYPECAT');
18
INSERT IGNORE INTO authorised_value_categories( category_name )
19
    VALUES
20
    ('branches'),
21
    ('itemtypes'),
22
    ('cn_source');
23
24
INSERT IGNORE INTO authorised_value_categories( category_name )
25
    VALUES
26
    ('WITHDRAWN'),
27
    ('RESTRICTED'),
28
    ('NOT_LOAN'),
29
    ('CCODE'),
30
    ('LOC'),
31
    ('MANUAL_INV'),
32
    ('BOR_NOTES'),
33
    ('OPAC_SUG'),
34
    ('SIP_MEDIA_TYPE'),
35
    ('ORDER_CANCELLATION_REASON'),
36
    ('RELTERMS'),
37
    ('YES_NO'),
38
    ('LANG'),
39
    ('HINGS_UT'),
40
    ('HINGS_PF'),
41
    ('HINGS_C'),
42
    ('HINGS_AS'),
43
    ('HINGS_RD'),
44
    ('STACK');
45
46
-- UNIMARC specific?
47
INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
48
    ('ETAT'),
49
    ('CAND'),
50
    ('COUNTRY'),
51
    ('qualif');

Return to bug 17216