From 92a3491b7df5706d1bf4cff690909f71e53be6e0 Mon Sep 17 00:00:00 2001 From: tipaul Date: Tue, 16 Nov 2004 13:38:11 +0000 Subject: [PATCH] sql datas for authorities --- .../english/authorities_normal_marc21.sql | 17 ----------------- .../english/authorities_normal_marc21.txt | 1 + .../french/authorites_norme_unimarc.sql | 19 ------------------- .../french/authorites_norme_unimarc.txt | 2 ++ 4 files changed, 3 insertions(+), 36 deletions(-) create mode 100644 misc/sql-datas/english/authorities_normal_marc21.txt create mode 100644 misc/sql-datas/french/authorites_norme_unimarc.txt diff --git a/misc/sql-datas/english/authorities_normal_marc21.sql b/misc/sql-datas/english/authorities_normal_marc21.sql index d03468803a..c5d23efc63 100644 --- a/misc/sql-datas/english/authorities_normal_marc21.sql +++ b/misc/sql-datas/english/authorities_normal_marc21.sql @@ -1,14 +1,3 @@ --- MySQL dump 8.23 --- --- Host: localhost Database: Koha ---------------------------------------------------------- --- Server version 3.23.58 - --- --- Dumping data for table `auth_subfield_structure` --- - - INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','010','a','LC control number','',0,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','010','z','Canceled/invalid LC control number','',1,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','010','8','Field link and sequence number','',1,0,0,NULL,NULL,NULL); @@ -1196,12 +1185,6 @@ INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblib INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','880','7','Same as associated field','',1,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','880','8','Same as associated field','',1,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','880','9','Same as associated field','',1,0,0,NULL,NULL,NULL); - --- --- Dumping data for table `auth_tag_structure` --- - - INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('','010','LIBRARY OF CONGRESS CONTROL NUMBER','',0,0,NULL); INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('','014','LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM','',1,0,NULL); INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('','016','National Bibliographic Agency Control Number','',1,0,NULL); diff --git a/misc/sql-datas/english/authorities_normal_marc21.txt b/misc/sql-datas/english/authorities_normal_marc21.txt new file mode 100644 index 0000000000..828b5f74b9 --- /dev/null +++ b/misc/sql-datas/english/authorities_normal_marc21.txt @@ -0,0 +1 @@ +Authority structure for MARC21, in english \ No newline at end of file diff --git a/misc/sql-datas/french/authorites_norme_unimarc.sql b/misc/sql-datas/french/authorites_norme_unimarc.sql index 006081cbbd..59b07e818f 100644 --- a/misc/sql-datas/french/authorites_norme_unimarc.sql +++ b/misc/sql-datas/french/authorites_norme_unimarc.sql @@ -1,17 +1,3 @@ -# phpMyAdmin MySQL-Dump -# version 2.4.0 -# http://www.phpmyadmin.net/ (download page) -# -# Serveur: localhost -# Généré le : Mercredi 18 Août 2004 à 17:31 -# Version du serveur: 4.0.18 -# Version de PHP: 4.3.4 -# Base de données: `EMN` - -# -# Contenu de la table `auth_subfield_structure` -# - INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('', '035', 'a', 'Numéro de contrôle système', '', 0, 0, 0, NULL, NULL, NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('', '035', 'z', 'Numéro de contrôle annulé ou erroné', '', 1, 0, 0, NULL, NULL, NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('', '100', 'a', 'Données générale de traitement', '', 0, 0, 0, NULL, NULL, NULL); @@ -691,11 +677,6 @@ INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblib INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('', '001', '@', 'tag 001', '', 0, 0, 0, '', NULL, ''); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('', '005', '@', 'tag 005', '', 0, 0, -1, '', NULL, ''); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('', '015', '@', 'tag 015', '', 0, 0, -1, '', NULL, ''); - -# -# Contenu de la table `auth_tag_structure` -# - INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('', '001', 'Identificateur de la notice', '', 0, 0, NULL); INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('', '005', 'Identificateur de la version', '', 0, 0, NULL); INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('', '015', '(ISADN)', '', 0, 0, NULL); diff --git a/misc/sql-datas/french/authorites_norme_unimarc.txt b/misc/sql-datas/french/authorites_norme_unimarc.txt new file mode 100644 index 0000000000..f45d8ca5dc --- /dev/null +++ b/misc/sql-datas/french/authorites_norme_unimarc.txt @@ -0,0 +1,2 @@ +Authority structure for UNIMARC, in french +Structure des autorités UNIMARC, en Français. A utiliser pour définir les différentes grilles d'autorités (NP, NC, CO...) qui ne sont pas fournies actuellement. \ No newline at end of file -- 2.39.5