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

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml (-17 / +16 lines)
Lines 32748-32754 sql_statements: Link Here
32748
                       '154','253','353','453','553','668','671','676',
32748
                       '154','253','353','453','553','668','671','676',
32749
                       '684','685','686','687','753','754',
32749
                       '684','685','686','687','753','754',
32750
                       '761','763','764','765','766','768') AND
32750
                       '761','763','764','765','766','768') AND
32751
     tagfield NOT IN ('110','111','130','148','150','151','155','162',
32751
     tagfield NOT IN ('110','111','130','147','148','150','151','155','162',
32752
                      '180','181','182','185','034','640','641','642',
32752
                      '180','181','182','185','034','640','641','642',
32753
                      '643','644','645','646');"
32753
                      '643','644','645','646');"
32754
32754
Lines 32762-32768 sql_statements: Link Here
32762
                       '154','253','353','453','553','668','671','676',
32762
                       '154','253','353','453','553','668','671','676',
32763
                       '684','685','686','687','753','754',
32763
                       '684','685','686','687','753','754',
32764
                       '761','763','764','765','766','768') AND
32764
                       '761','763','764','765','766','768') AND
32765
     tagfield NOT IN ('110','111','130','148','150','151','155','162',
32765
     tagfield NOT IN ('110','111','130','147','148','150','151','155','162',
32766
                     '180','181','182','185','034','640','641','642',
32766
                     '180','181','182','185','034','640','641','642',
32767
                     '643','644','645','646');"
32767
                     '643','644','645','646');"
32768
32768
Lines 32775-32781 sql_statements: Link Here
32775
                       '154','253','353','453','553','668','671','676',
32775
                       '154','253','353','453','553','668','671','676',
32776
                       '684','685','686','687','753','754',
32776
                       '684','685','686','687','753','754',
32777
                       '761','763','764','765','766','768') AND
32777
                       '761','763','764','765','766','768') AND
32778
     tagfield NOT IN ( '100','111','130','148','150','151','155','162',
32778
     tagfield NOT IN ( '100','111','130','147','148','150','151','155','162',
32779
                       '180','181','182','185','034','640','641','642',
32779
                       '180','181','182','185','034','640','641','642',
32780
                       '643','644','645','646');"
32780
                       '643','644','645','646');"
32781
32781
Lines 32789-32795 sql_statements: Link Here
32789
                       '154','253','353','453','553','668','671','676',
32789
                       '154','253','353','453','553','668','671','676',
32790
                       '684','685','686','687','753','754',
32790
                       '684','685','686','687','753','754',
32791
                       '761','763','764','765','766','768') AND
32791
                       '761','763','764','765','766','768') AND
32792
     tagfield NOT IN ( '100','111','130','148','150','151','155','162',
32792
     tagfield NOT IN ( '100','111','130','147','148','150','151','155','162',
32793
                       '180','181','182','185','034','640','641','642',
32793
                       '180','181','182','185','034','640','641','642',
32794
                       '643','644','645','646');"
32794
                       '643','644','645','646');"
32795
32795
Lines 32802-32808 sql_statements: Link Here
32802
                       '154','253','353','453','553','668','671','676',
32802
                       '154','253','353','453','553','668','671','676',
32803
                       '684','685','686','687','753','754',
32803
                       '684','685','686','687','753','754',
32804
                       '761','763','764','765','766','768') AND
32804
                       '761','763','764','765','766','768') AND
32805
     tagfield NOT IN ( '100','110','130','148','150','151','155','162',
32805
     tagfield NOT IN ( '100','110','130','147','148','150','151','155','162',
32806
                       '180','181','182','185','640','641','642','643',
32806
                       '180','181','182','185','640','641','642','643',
32807
                       '644','645','646');"
32807
                       '644','645','646');"
32808
32808
Lines 32816-32822 sql_statements: Link Here
32816
                       '154','253','353','453','553','668','671','676',
32816
                       '154','253','353','453','553','668','671','676',
32817
                       '684','685','686','687','753','754',
32817
                       '684','685','686','687','753','754',
32818
                       '761','763','764','765','766','768') AND
32818
                       '761','763','764','765','766','768') AND
32819
     tagfield NOT IN ( '100','110','130','148','150','151','155','162',
32819
     tagfield NOT IN ( '100','110','130','147','148','150','151','155','162',
32820
                       '180','181','182','185','640','641','642','643',
32820
                       '180','181','182','185','640','641','642','643',
32821
                       '644','645','646');"
32821
                       '644','645','646');"
32822
32822
Lines 32829-32835 sql_statements: Link Here
32829
                       '154','253','353','453','553','668','671','676',
32829
                       '154','253','353','453','553','668','671','676',
32830
                       '684','685','686','687','753','754',
32830
                       '684','685','686','687','753','754',
32831
                       '761','763','764','765','766','768') AND
32831
                       '761','763','764','765','766','768') AND
32832
     tagfield NOT IN ( '100','110','111','148','150','151','155','162',
32832
     tagfield NOT IN ( '100','110','111','147','148','150','151','155','162',
32833
                       '180','181','182','185');"
32833
                       '180','181','182','185');"
32834
32834
32835
  - "INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
32835
  - "INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
Lines 32842-32848 sql_statements: Link Here
32842
                       '154','253','353','453','553','668','671','676',
32842
                       '154','253','353','453','553','668','671','676',
32843
                       '684','685','686','687','753','754',
32843
                       '684','685','686','687','753','754',
32844
                       '761','763','764','765','766','768') AND
32844
                       '761','763','764','765','766','768') AND
32845
     tagfield NOT IN ( '100','110','111','148','150','151','155','162',
32845
     tagfield NOT IN ( '100','110','111','147','148','150','151','155','162',
32846
                       '180','181','182','185');"
32846
                       '180','181','182','185');"
32847
32847
32848
  # CHRONOLOGICAL TERMS AUTHORITY FIELDS/SUBFIELDS. X48
32848
  # CHRONOLOGICAL TERMS AUTHORITY FIELDS/SUBFIELDS. X48
Lines 32854-32860 sql_statements: Link Here
32854
                       '154','253','353','453','553','668','671','676',
32854
                       '154','253','353','453','553','668','671','676',
32855
                       '684','685','686','687','753','754',
32855
                       '684','685','686','687','753','754',
32856
                       '761','763','764','765','766','768') AND
32856
                       '761','763','764','765','766','768') AND
32857
     tagfield NOT IN ( '100','110','111','130','150','151','155','162',
32857
     tagfield NOT IN ( '100','110','111','130','147','150','151','155','162',
32858
                       '180','181','185','014','020','022','031','640',
32858
                       '180','181','185','014','020','022','031','640',
32859
                       '641','642','643','644','645','646');"
32859
                       '641','642','643','644','645','646');"
32860
32860
Lines 32868-32874 sql_statements: Link Here
32868
                       '154','253','353','453','553','668','671','676',
32868
                       '154','253','353','453','553','668','671','676',
32869
                       '684','685','686','687','753','754',
32869
                       '684','685','686','687','753','754',
32870
                       '761','763','764','765','766','768') AND
32870
                       '761','763','764','765','766','768') AND
32871
     tagfield NOT IN ( '100','110','111','130','150','151','155','162',
32871
     tagfield NOT IN ( '100','110','111','130','147','150','151','155','162',
32872
                       '180','181','185','014','020','022','031','640',
32872
                       '180','181','185','014','020','022','031','640',
32873
                       '641','642','643','644','645','646');"
32873
                       '641','642','643','644','645','646');"
32874
32874
Lines 32881-32887 sql_statements: Link Here
32881
                       '154','253','353','453','553','668','671','676',
32881
                       '154','253','353','453','553','668','671','676',
32882
                       '684','685','686','687','753','754',
32882
                       '684','685','686','687','753','754',
32883
                       '761','763','764','765','766','768') AND
32883
                       '761','763','764','765','766','768') AND
32884
     tagfield NOT IN ( '100','110','111','130','148','151','155','162',
32884
     tagfield NOT IN ( '100','110','111','130','147','148','151','155','162',
32885
                       '181','182','185','014','020','022','031','640',
32885
                       '181','182','185','014','020','022','031','640',
32886
                       '641','642','643','644','645','646');"
32886
                       '641','642','643','644','645','646');"
32887
32887
Lines 32895-32901 sql_statements: Link Here
32895
                       '154','253','353','453','553','668','671','676',
32895
                       '154','253','353','453','553','668','671','676',
32896
                       '684','685','686','687','753','754',
32896
                       '684','685','686','687','753','754',
32897
                       '761','763','764','765','766','768') AND
32897
                       '761','763','764','765','766','768') AND
32898
     tagfield NOT IN ( '100','110','111','130','148','151','155','162',
32898
     tagfield NOT IN ( '100','110','111','130','147','148','151','155','162',
32899
                       '181','182','185','014','020','022','031','640',
32899
                       '181','182','185','014','020','022','031','640',
32900
                       '641','642','643','644','645','646');"
32900
                       '641','642','643','644','645','646');"
32901
32901
Lines 32908-32914 sql_statements: Link Here
32908
                       '154','253','353','453','553','668','671','676',
32908
                       '154','253','353','453','553','668','671','676',
32909
                       '684','685','686','687','753','754',
32909
                       '684','685','686','687','753','754',
32910
                       '761','763','764','765','766','768') AND
32910
                       '761','763','764','765','766','768') AND
32911
     tagfield NOT IN ( '100','110','111','130','148','150','155','162',
32911
     tagfield NOT IN ( '100','110','111','130','147','148','150','155','162',
32912
                       '180','182','185','014','020','022','031','640',
32912
                       '180','182','185','014','020','022','031','640',
32913
                       '641','642','643','644','645','646');"
32913
                       '641','642','643','644','645','646');"
32914
32914
Lines 32922-32928 sql_statements: Link Here
32922
                       '154','253','353','453','553','668','671','676',
32922
                       '154','253','353','453','553','668','671','676',
32923
                       '684','685','686','687','753','754',
32923
                       '684','685','686','687','753','754',
32924
                       '761','763','764','765','766','768') AND
32924
                       '761','763','764','765','766','768') AND
32925
     tagfield NOT IN ( '100','110','111','130','148','150','155','162',
32925
     tagfield NOT IN ( '100','110','111','130','147','148','150','155','162',
32926
                       '180','182','185','014','020','022','031','640',
32926
                       '180','182','185','014','020','022','031','640',
32927
                       '641','642','643','644','645','646');"
32927
                       '641','642','643','644','645','646');"
32928
32928
Lines 32935-32941 sql_statements: Link Here
32935
                       '154','253','353','453','553','668','671','676',
32935
                       '154','253','353','453','553','668','671','676',
32936
                       '684','685','686','687','753','754',
32936
                       '684','685','686','687','753','754',
32937
                       '761','763','764','765','766','768') AND
32937
                       '761','763','764','765','766','768') AND
32938
     tagfield NOT IN ( '100','110','111','130','148','150','151','162',
32938
     tagfield NOT IN ( '100','110','111','130','147','148','150','151','162',
32939
                       '180','181','182','014','020','022','031','640',
32939
                       '180','181','182','014','020','022','031','640',
32940
                       '641','642','643','644','645','646');"
32940
                       '641','642','643','644','645','646');"
32941
32941
Lines 32949-32954 sql_statements: Link Here
32949
                       '154','253','353','453','553','668','671','676',
32949
                       '154','253','353','453','553','668','671','676',
32950
                       '684','685','686','687','753','754',
32950
                       '684','685','686','687','753','754',
32951
                       '761','763','764','765','766','768') AND
32951
                       '761','763','764','765','766','768') AND
32952
     tagfield NOT IN ( '100','110','111','130','148','150','151','162',
32952
     tagfield NOT IN ( '100','110','111','130','147','148','150','151','162',
32953
                       '180','181','182','014','020','022','031','640',
32953
                       '180','181','182','014','020','022','031','640',
32954
                       '641','642','643','644','645','646');"
32954
                       '641','642','643','644','645','646');"
32955
- 

Return to bug 33138