From 5666778957639b6d4283c11ffd04719973ea44c1 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Jean-Andr=C3=A9=20Santoni?= Date: Fri, 30 Apr 2010 11:28:11 +0200 Subject: [PATCH] [MT3424] Converts COUNTRY authorised values to uppercase --- .../fr-FR/1-Obligatoire/authorised_values.sql | 490 +++++++++--------- installer/data/mysql/updatedatabase.pl | 8 + 2 files changed, 253 insertions(+), 245 deletions(-) diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql index 1dc11b5e42..2564c103ae 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql @@ -23,251 +23,251 @@ INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VA INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (648, 'ETAT', '5', 'En traitement'); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (805, 'CAND', 'Candidat descripteur', 'Candidat descripteur'); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (806, 'CAND', 'Rejeté', 'Mot clé abandonné'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (971, 'COUNTRY', 'an', 'Antilles Néerlandaises'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (975, 'COUNTRY', 'cr', 'Costa Rica'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (980, 'COUNTRY', 'er', 'Allemagne'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (981, 'COUNTRY', ' fr', ' France'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (984, 'COUNTRY', 'de', 'Allemagne'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (985, 'COUNTRY', 'cn', 'Chine'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (986, 'COUNTRY', 'in', 'Inde'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (987, 'COUNTRY', 'is', 'Islande'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (988, 'COUNTRY', 'nl', 'Pays Bas'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (995, 'COUNTRY', 'pa', 'Espagne'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (998, 'COUNTRY', 're', 'France'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1006, 'COUNTRY', 'es', 'Espagne'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1011, 'COUNTRY', 'us', ' EtatsUnis'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1015, 'COUNTRY', 'gb', ' GrandeBretagne'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1016, 'COUNTRY', 'ad', 'Andorre'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1018, 'COUNTRY', 'af', 'Afghanistan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1019, 'COUNTRY', 'al', 'Albanie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1020, 'COUNTRY', 'ag', 'AntiguaetBarbuda'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1021, 'COUNTRY', 'am', 'Arménie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1022, 'COUNTRY', 'ao', 'Angola'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1023, 'COUNTRY', 'aq', 'Antarctique'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1024, 'COUNTRY', 'ar', 'Argentine'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1025, 'COUNTRY', 'as', 'Samoa américaines'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1026, 'COUNTRY', 'at', 'Autriche'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1027, 'COUNTRY', 'au', 'Australie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1028, 'COUNTRY', 'aw', 'Aruba'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1029, 'COUNTRY', 'ax', 'Aland, îles d'''); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1030, 'COUNTRY', 'az', 'Azerbaïdjan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1031, 'COUNTRY', 'ba', 'BosnieHerzégovine'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1032, 'COUNTRY', 'bb', 'Barbade'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1033, 'COUNTRY', 'bd', 'Bangladesh'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1034, 'COUNTRY', 'be', 'Belgique'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1035, 'COUNTRY', 'bf', 'Burkina Faso'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1036, 'COUNTRY', 'bf', 'HauteVolta'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1037, 'COUNTRY', 'bg', 'Bulgarie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1038, 'COUNTRY', 'bh', 'Bahreïn'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1039, 'COUNTRY', 'bi', 'Burundi'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1040, 'COUNTRY', 'bj', 'Bénin'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1041, 'COUNTRY', 'bm', 'Bermudes'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1042, 'COUNTRY', 'bn', 'Brunéi'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1043, 'COUNTRY', 'bo', 'Bolivie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1044, 'COUNTRY', 'br', 'Brésil'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1045, 'COUNTRY', 'bs', 'Bahamas'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1046, 'COUNTRY', 'bt', 'Bhoutan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1047, 'COUNTRY', 'bv', 'Bouvet, île'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1048, 'COUNTRY', 'bw', 'Botswana'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1049, 'COUNTRY', 'by', 'Biélorussie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1050, 'COUNTRY', 'bz', 'Belize'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1051, 'COUNTRY', 'ca', 'Canada'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1052, 'COUNTRY', 'cc', 'Cocos, île des'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1053, 'COUNTRY', 'cc', 'Keeling'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1054, 'COUNTRY', 'cd', 'Zaïre'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1055, 'COUNTRY', 'cd', 'Congo'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1056, 'COUNTRY', 'cf', 'Centrafrique'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1057, 'COUNTRY', 'cg', 'Congo'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1058, 'COUNTRY', 'ch', ' Suisse'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1059, 'COUNTRY', 'ci', 'Côte d''Ivoire'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1060, 'COUNTRY', 'ck', 'Cook, îles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1061, 'COUNTRY', 'cl', 'Chili'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1062, 'COUNTRY', 'cm', 'Cameroun'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1063, 'COUNTRY', 'cs', 'SerbieetMonténégro'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1064, 'COUNTRY', 'cu', 'Cuba'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1065, 'COUNTRY', 'cv', 'CapVert'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1066, 'COUNTRY', 'cx', 'Christmas, île'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1067, 'COUNTRY', 'cy', 'Chypre'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1068, 'COUNTRY', 'cz', 'Tchèque, République'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1069, 'COUNTRY', 'dj', 'Djibouti'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1070, 'COUNTRY', 'dk', 'Danemark'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1071, 'COUNTRY', 'dm', 'Dominique'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1072, 'COUNTRY', 'do', 'Dominicaine, République'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1073, 'COUNTRY', 'dz', 'Algérie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1074, 'COUNTRY', 'ec', 'Equateur'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1075, 'COUNTRY', 'ee', 'Estonie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1076, 'COUNTRY', 'eg', 'Egypte'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1077, 'COUNTRY', 'eh', 'Sahara occidental'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1078, 'COUNTRY', 'fi', 'Finlande'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1079, 'COUNTRY', 'fj', 'Fidji'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1080, 'COUNTRY', 'fk', 'Falkland, îles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1081, 'COUNTRY', 'fm', 'Micronésie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1082, 'COUNTRY', 'fo', 'Féroé, îles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1083, 'COUNTRY', 'ga', 'Gabon'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1084, 'COUNTRY', 'gd', 'Grenade'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1085, 'COUNTRY', 'ge', 'Géorgie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1086, 'COUNTRY', 'gf', 'Guyane française'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1087, 'COUNTRY', 'gh', 'Ghana'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1088, 'COUNTRY', 'gi', 'Gibraltar'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1089, 'COUNTRY', 'gl', 'Groenland'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1090, 'COUNTRY', 'gm', 'Gambie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1091, 'COUNTRY', 'gn', 'Guinée'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1092, 'COUNTRY', 'gp', 'Guadeloupe'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1093, 'COUNTRY', 'gq', 'Guinée'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1094, 'COUNTRY', 'gq', 'Guinée équatoriale'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1095, 'COUNTRY', 'gr', 'Grèce'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1096, 'COUNTRY', 'gs', 'Géorgie du sud et les îles sandwich du Sud'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1097, 'COUNTRY', 'gt', 'Guatemala'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1098, 'COUNTRY', 'gu', 'Guam'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1099, 'COUNTRY', 'gw', 'GuinéeBissau'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1100, 'COUNTRY', 'gy', 'Guyana'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1101, 'COUNTRY', 'hk', 'HongKong'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1102, 'COUNTRY', 'hm', 'Heard et îles McDonald, île'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1103, 'COUNTRY', 'hn', 'Honduras'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1104, 'COUNTRY', 'hr', 'Croatie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1105, 'COUNTRY', 'ht', 'Haïti'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1106, 'COUNTRY', 'hu', 'Hongrie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1107, 'COUNTRY', 'id', 'Indonésie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1108, 'COUNTRY', 'ie', 'Irlande'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1109, 'COUNTRY', 'ii', 'intergouvernemental'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1110, 'COUNTRY', 'il', 'Israël'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1111, 'COUNTRY', 'iq', 'Iraq'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1112, 'COUNTRY', 'ir', 'Iran'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1113, 'COUNTRY', 'it', 'Italie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1114, 'COUNTRY', 'jm', 'Jamaïque'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1115, 'COUNTRY', 'jo', 'Jordanie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1116, 'COUNTRY', 'jp', 'Japon'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1117, 'COUNTRY', 'ke', 'Kenya'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1118, 'COUNTRY', 'kg', 'Kirghizistan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1119, 'COUNTRY', 'kh', 'Cambodge'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1120, 'COUNTRY', 'ki', 'Kiribati'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1121, 'COUNTRY', 'km', 'Comores'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1122, 'COUNTRY', 'kn', 'SaintKittsetNevis'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1123, 'COUNTRY', 'kp', 'Corée du Nord'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1124, 'COUNTRY', 'kr', 'Corée du Sud'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1125, 'COUNTRY', 'kw', 'Koweït'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1126, 'COUNTRY', 'ky', 'Caïmanes, îles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1127, 'COUNTRY', 'kz', 'Kazakhstan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1128, 'COUNTRY', 'la', 'Lao'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1129, 'COUNTRY', 'lb', 'Liban'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1130, 'COUNTRY', 'lc', 'SainteLucie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1131, 'COUNTRY', 'li', 'Liechtenstein'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1132, 'COUNTRY', 'lk', 'Sri Lanka'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1133, 'COUNTRY', 'lr', 'Libéria'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1134, 'COUNTRY', 'ls', 'Lesotho'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1135, 'COUNTRY', 'lt', 'Lituanie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1136, 'COUNTRY', 'lu', 'Luxembourg'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1137, 'COUNTRY', 'lv', 'Lettonie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1138, 'COUNTRY', 'ly', 'Lybie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1139, 'COUNTRY', 'ma', 'Maroc'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1140, 'COUNTRY', 'mc', 'Monaco'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1141, 'COUNTRY', 'md', 'Moldavie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1142, 'COUNTRY', 'mg', 'Madagascar'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1143, 'COUNTRY', 'mh', 'Marshall, îles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1144, 'COUNTRY', 'mk', 'Macédoine'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1145, 'COUNTRY', 'ml', 'Mali'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1146, 'COUNTRY', 'mm', 'Birmanie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1147, 'COUNTRY', 'mm', 'Myanmar'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1148, 'COUNTRY', 'mn', 'Mongolie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1149, 'COUNTRY', 'mo', 'Macao'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1150, 'COUNTRY', 'mp', 'Mariannes du Nord, îles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1151, 'COUNTRY', 'mq', 'Martinique'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1152, 'COUNTRY', 'mr', 'Mauritanie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1153, 'COUNTRY', 'ms', 'Montserrat'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1154, 'COUNTRY', 'mt', 'Malte'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1155, 'COUNTRY', 'mu', 'Maurice'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1156, 'COUNTRY', 'mv', 'Maldives'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1157, 'COUNTRY', 'mw', 'Malawi'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1158, 'COUNTRY', 'mx', 'Mexique'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1159, 'COUNTRY', 'my', 'Malaisie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1160, 'COUNTRY', 'mz', 'Mozambique'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1161, 'COUNTRY', 'na', 'Namibie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1162, 'COUNTRY', 'nc', 'NouvelleCalédonie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1163, 'COUNTRY', 'ne', 'Niger'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1164, 'COUNTRY', 'nf', 'Norfolk'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1166, 'COUNTRY', 'ni', 'Nicaragua'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1167, 'COUNTRY', 'no', 'Norvège'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1168, 'COUNTRY', 'np', 'Népal'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1169, 'COUNTRY', 'nr', 'Nauru'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1170, 'COUNTRY', 'nu', 'Nioué'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1171, 'COUNTRY', 'nz', 'NouvelleZélande'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1172, 'COUNTRY', 'om', 'Oman'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1173, 'COUNTRY', 'pe', 'Pérou'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1174, 'COUNTRY', 'pf', 'Polynésie française'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1175, 'COUNTRY', 'pg', 'Papouasie NouvelleGuinée'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1176, 'COUNTRY', 'ph', 'Philippines'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1177, 'COUNTRY', 'pk', 'Pakistan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1178, 'COUNTRY', 'pm', 'SaintPierreetMiquelon'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1179, 'COUNTRY', 'pn', 'Pitcairn'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1180, 'COUNTRY', 'pr', 'Porto Rico'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1181, 'COUNTRY', 'ps', 'Palestine'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1182, 'COUNTRY', 'pt', 'Portugal'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1183, 'COUNTRY', 'pw', 'Palau'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1184, 'COUNTRY', 'py', 'Paraguay'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1185, 'COUNTRY', 'qa', 'Qatar'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1186, 'COUNTRY', 'ro', 'Roumanie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1187, 'COUNTRY', 'ru', 'Russie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1188, 'COUNTRY', 'rw', 'Rwanda'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1189, 'COUNTRY', 'sa', 'Arabie saoudite'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1190, 'COUNTRY', 'sb', 'Salomon, îles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1191, 'COUNTRY', 'sc', 'Seychelles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1192, 'COUNTRY', 'sd', 'Soudan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1193, 'COUNTRY', 'se', 'Suède'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1194, 'COUNTRY', 'sg', 'Singapour'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1195, 'COUNTRY', 'sh', 'SainteHélène'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1196, 'COUNTRY', 'si', 'Slovénie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1197, 'COUNTRY', 'sj', 'Svalbard et île Jan Mayen'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1198, 'COUNTRY', 'sk', 'Slovaquie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1199, 'COUNTRY', 'sl', 'Sierra Leone'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1200, 'COUNTRY', 'sm', 'SaintMarin'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1201, 'COUNTRY', 'sn', 'Sénégal'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1202, 'COUNTRY', 'so', 'Somalie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1203, 'COUNTRY', 'sr', 'Suriname'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1204, 'COUNTRY', 'st', 'Sao ToméetPrincipe'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1205, 'COUNTRY', 'su', 'URSS'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1206, 'COUNTRY', 'sv', 'Salvador'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1207, 'COUNTRY', 'sy', 'Syrie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1208, 'COUNTRY', 'sz', 'Swaziland'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1209, 'COUNTRY', 'tc', 'Turks et Caïques, îles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1210, 'COUNTRY', 'td', 'Tchad'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1211, 'COUNTRY', 'tg', 'Togo'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1212, 'COUNTRY', 'th', 'Thaïlande'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1213, 'COUNTRY', 'tj', 'Tadjikistan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1214, 'COUNTRY', 'tk', 'Tokélau'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1215, 'COUNTRY', 'tl', 'Timor oriental'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1216, 'COUNTRY', 'tm', 'Turkménistan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1217, 'COUNTRY', 'tn', 'Tunisie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1218, 'COUNTRY', 'to', 'Tonga'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1219, 'COUNTRY', 'tr', 'Turquie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1220, 'COUNTRY', 'tt', 'TrinitéetTobago'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1221, 'COUNTRY', 'tv', 'Tuvalu'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1222, 'COUNTRY', 'tw', 'taïwan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1223, 'COUNTRY', 'tz', 'Tanzanie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1224, 'COUNTRY', 'ua', 'Ukraine'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1225, 'COUNTRY', 'ug', 'Ouganda'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1226, 'COUNTRY', 'um', 'îles mineures éloignées des Etatsunis'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1227, 'COUNTRY', 'uy', 'Uruguay'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1228, 'COUNTRY', 'uz', 'Ouzbékistan'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1229, 'COUNTRY', 'va', 'Vatican'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1230, 'COUNTRY', 'vc', 'SaintVincentetles Grenadines'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1231, 'COUNTRY', 've', 'Venezuela'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1232, 'COUNTRY', 'vg', 'Iles Vierges britanniques'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1233, 'COUNTRY', 'vi', 'Iles Vierges (Etatsunis)'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1234, 'COUNTRY', 'vn', 'Viet Nam'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1235, 'COUNTRY', 'vu', 'Vanuatu'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1236, 'COUNTRY', 'wf', 'Wallis et Futuna, îles'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1237, 'COUNTRY', 'ws', 'Samoa'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1238, 'COUNTRY', 'xc', 'Tchécoslovaquie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1239, 'COUNTRY', 'xd', 'Allemagne avant 1945'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1240, 'COUNTRY', 'xe', 'Europe'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1242, 'COUNTRY', 'xk', 'Corée avant 1948'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1243, 'COUNTRY', 'yd', 'Yémen'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1244, 'COUNTRY', 'Yu', 'Yougoslavie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1245, 'COUNTRY', 'za', 'Afrique du Sud'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1246, 'COUNTRY', 'zm', 'Zambie'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1247, 'COUNTRY', 'zw', 'Zimbabwe'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1248, 'COUNTRY', 'zz', 'multiple'); -INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1249, 'COUNTRY', 'ta', 'Italie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (971, 'COUNTRY', 'AN', 'Antilles Néerlandaises'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (975, 'COUNTRY', 'CR', 'Costa Rica'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (980, 'COUNTRY', 'ER', 'Allemagne'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (981, 'COUNTRY', 'FR', 'France'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (984, 'COUNTRY', 'DE', 'Allemagne'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (985, 'COUNTRY', 'CN', 'Chine'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (986, 'COUNTRY', 'IN', 'Inde'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (987, 'COUNTRY', 'IS', 'Islande'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (988, 'COUNTRY', 'NL', 'Pays Bas'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (995, 'COUNTRY', 'PA', 'Espagne'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (998, 'COUNTRY', 'RE', 'France'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1006, 'COUNTRY', 'ES', 'Espagne'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1011, 'COUNTRY', 'US', ' EtatsUnis'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1015, 'COUNTRY', 'GB', ' GrandeBretagne'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1016, 'COUNTRY', 'AD', 'Andorre'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1018, 'COUNTRY', 'AF', 'Afghanistan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1019, 'COUNTRY', 'AL', 'Albanie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1020, 'COUNTRY', 'AG', 'AntiguaetBarbuda'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1021, 'COUNTRY', 'AM', 'Arménie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1022, 'COUNTRY', 'AO', 'Angola'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1023, 'COUNTRY', 'AQ', 'Antarctique'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1024, 'COUNTRY', 'AR', 'Argentine'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1025, 'COUNTRY', 'AS', 'Samoa américaines'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1026, 'COUNTRY', 'AT', 'Autriche'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1027, 'COUNTRY', 'AU', 'Australie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1028, 'COUNTRY', 'AW', 'Aruba'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1029, 'COUNTRY', 'AX', 'Aland, îles d'''); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1030, 'COUNTRY', 'AZ', 'Azerbaïdjan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1031, 'COUNTRY', 'BA', 'BosnieHerzégovine'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1032, 'COUNTRY', 'BB', 'Barbade'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1033, 'COUNTRY', 'BD', 'Bangladesh'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1034, 'COUNTRY', 'BE', 'Belgique'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1035, 'COUNTRY', 'BF', 'Burkina Faso'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1036, 'COUNTRY', 'BF', 'HauteVolta'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1037, 'COUNTRY', 'BG', 'Bulgarie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1038, 'COUNTRY', 'BH', 'Bahreïn'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1039, 'COUNTRY', 'BI', 'Burundi'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1040, 'COUNTRY', 'BJ', 'Bénin'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1041, 'COUNTRY', 'BM', 'Bermudes'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1042, 'COUNTRY', 'BN', 'Brunéi'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1043, 'COUNTRY', 'BO', 'Bolivie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1044, 'COUNTRY', 'BR', 'Brésil'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1045, 'COUNTRY', 'BS', 'Bahamas'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1046, 'COUNTRY', 'BT', 'Bhoutan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1047, 'COUNTRY', 'BV', 'Bouvet, île'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1048, 'COUNTRY', 'BW', 'Botswana'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1049, 'COUNTRY', 'BY', 'Biélorussie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1050, 'COUNTRY', 'BZ', 'Belize'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1051, 'COUNTRY', 'CA', 'Canada'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1052, 'COUNTRY', 'CC', 'Cocos, île des'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1053, 'COUNTRY', 'CC', 'Keeling'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1054, 'COUNTRY', 'CD', 'Zaïre'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1055, 'COUNTRY', 'CD', 'Congo'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1056, 'COUNTRY', 'CF', 'Centrafrique'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1057, 'COUNTRY', 'CG', 'Congo'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1058, 'COUNTRY', 'CH', ' Suisse'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1059, 'COUNTRY', 'CI', 'Côte d''Ivoire'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1060, 'COUNTRY', 'CK', 'Cook, îles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1061, 'COUNTRY', 'CL', 'Chili'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1062, 'COUNTRY', 'CM', 'Cameroun'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1063, 'COUNTRY', 'CS', 'SerbieetMonténégro'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1064, 'COUNTRY', 'CU', 'Cuba'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1065, 'COUNTRY', 'CV', 'CapVert'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1066, 'COUNTRY', 'CX', 'Christmas, île'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1067, 'COUNTRY', 'CY', 'Chypre'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1068, 'COUNTRY', 'CZ', 'Tchèque, République'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1069, 'COUNTRY', 'DJ', 'Djibouti'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1070, 'COUNTRY', 'DK', 'Danemark'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1071, 'COUNTRY', 'DM', 'Dominique'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1072, 'COUNTRY', 'DO', 'Dominicaine, République'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1073, 'COUNTRY', 'DZ', 'Algérie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1074, 'COUNTRY', 'EC', 'Equateur'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1075, 'COUNTRY', 'EE', 'Estonie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1076, 'COUNTRY', 'EG', 'Egypte'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1077, 'COUNTRY', 'EH', 'Sahara occidental'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1078, 'COUNTRY', 'FI', 'Finlande'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1079, 'COUNTRY', 'FJ', 'Fidji'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1080, 'COUNTRY', 'FK', 'Falkland, îles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1081, 'COUNTRY', 'FM', 'Micronésie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1082, 'COUNTRY', 'FO', 'Féroé, îles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1083, 'COUNTRY', 'GA', 'Gabon'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1084, 'COUNTRY', 'GD', 'Grenade'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1085, 'COUNTRY', 'GE', 'Géorgie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1086, 'COUNTRY', 'GF', 'Guyane française'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1087, 'COUNTRY', 'GH', 'Ghana'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1088, 'COUNTRY', 'GI', 'Gibraltar'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1089, 'COUNTRY', 'GL', 'Groenland'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1090, 'COUNTRY', 'GM', 'Gambie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1091, 'COUNTRY', 'GN', 'Guinée'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1092, 'COUNTRY', 'GP', 'Guadeloupe'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1093, 'COUNTRY', 'GQ', 'Guinée'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1094, 'COUNTRY', 'GQ', 'Guinée équatoriale'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1095, 'COUNTRY', 'GR', 'Grèce'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1096, 'COUNTRY', 'GS', 'Géorgie du sud et les îles sandwich du Sud'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1097, 'COUNTRY', 'GT', 'Guatemala'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1098, 'COUNTRY', 'GU', 'Guam'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1099, 'COUNTRY', 'GW', 'GuinéeBissau'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1100, 'COUNTRY', 'GY', 'Guyana'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1101, 'COUNTRY', 'HK', 'HongKong'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1102, 'COUNTRY', 'HM', 'Heard et îles McDonald, île'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1103, 'COUNTRY', 'HN', 'Honduras'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1104, 'COUNTRY', 'HR', 'Croatie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1105, 'COUNTRY', 'HT', 'Haïti'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1106, 'COUNTRY', 'HU', 'Hongrie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1107, 'COUNTRY', 'ID', 'Indonésie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1108, 'COUNTRY', 'IE', 'Irlande'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1109, 'COUNTRY', 'II', 'intergouvernemental'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1110, 'COUNTRY', 'IL', 'Israël'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1111, 'COUNTRY', 'IQ', 'Iraq'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1112, 'COUNTRY', 'IR', 'Iran'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1113, 'COUNTRY', 'IT', 'Italie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1114, 'COUNTRY', 'JM', 'Jamaïque'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1115, 'COUNTRY', 'JO', 'Jordanie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1116, 'COUNTRY', 'JP', 'Japon'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1117, 'COUNTRY', 'KE', 'Kenya'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1118, 'COUNTRY', 'KG', 'Kirghizistan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1119, 'COUNTRY', 'KH', 'Cambodge'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1120, 'COUNTRY', 'KI', 'Kiribati'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1121, 'COUNTRY', 'KM', 'Comores'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1122, 'COUNTRY', 'KN', 'SaintKittsetNevis'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1123, 'COUNTRY', 'KP', 'Corée du Nord'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1124, 'COUNTRY', 'KR', 'Corée du Sud'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1125, 'COUNTRY', 'KW', 'Koweït'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1126, 'COUNTRY', 'KY', 'Caïmanes, îles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1127, 'COUNTRY', 'KZ', 'Kazakhstan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1128, 'COUNTRY', 'LA', 'Lao'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1129, 'COUNTRY', 'LB', 'Liban'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1130, 'COUNTRY', 'LC', 'SainteLucie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1131, 'COUNTRY', 'LI', 'Liechtenstein'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1132, 'COUNTRY', 'LK', 'Sri Lanka'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1133, 'COUNTRY', 'LR', 'Libéria'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1134, 'COUNTRY', 'LS', 'Lesotho'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1135, 'COUNTRY', 'LT', 'Lituanie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1136, 'COUNTRY', 'LU', 'Luxembourg'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1137, 'COUNTRY', 'LV', 'Lettonie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1138, 'COUNTRY', 'LY', 'Lybie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1139, 'COUNTRY', 'MA', 'Maroc'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1140, 'COUNTRY', 'MC', 'Monaco'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1141, 'COUNTRY', 'MD', 'Moldavie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1142, 'COUNTRY', 'MG', 'Madagascar'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1143, 'COUNTRY', 'MH', 'Marshall, îles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1144, 'COUNTRY', 'MK', 'Macédoine'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1145, 'COUNTRY', 'ML', 'Mali'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1146, 'COUNTRY', 'MM', 'Birmanie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1147, 'COUNTRY', 'MM', 'Myanmar'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1148, 'COUNTRY', 'MN', 'Mongolie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1149, 'COUNTRY', 'MO', 'Macao'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1150, 'COUNTRY', 'MP', 'Mariannes du Nord, îles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1151, 'COUNTRY', 'MQ', 'Martinique'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1152, 'COUNTRY', 'MR', 'Mauritanie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1153, 'COUNTRY', 'MS', 'Montserrat'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1154, 'COUNTRY', 'MT', 'Malte'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1155, 'COUNTRY', 'MU', 'Maurice'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1156, 'COUNTRY', 'MV', 'Maldives'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1157, 'COUNTRY', 'MW', 'Malawi'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1158, 'COUNTRY', 'MX', 'Mexique'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1159, 'COUNTRY', 'MY', 'Malaisie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1160, 'COUNTRY', 'MZ', 'Mozambique'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1161, 'COUNTRY', 'NA', 'Namibie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1162, 'COUNTRY', 'NC', 'NouvelleCalédonie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1163, 'COUNTRY', 'NE', 'Niger'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1164, 'COUNTRY', 'NF', 'Norfolk'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1166, 'COUNTRY', 'NI', 'Nicaragua'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1167, 'COUNTRY', 'NO', 'Norvège'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1168, 'COUNTRY', 'NP', 'Népal'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1169, 'COUNTRY', 'NR', 'Nauru'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1170, 'COUNTRY', 'NU', 'Nioué'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1171, 'COUNTRY', 'NZ', 'NouvelleZélande'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1172, 'COUNTRY', 'OM', 'Oman'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1173, 'COUNTRY', 'PE', 'Pérou'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1174, 'COUNTRY', 'PF', 'Polynésie française'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1175, 'COUNTRY', 'PG', 'Papouasie NouvelleGuinée'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1176, 'COUNTRY', 'PH', 'Philippines'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1177, 'COUNTRY', 'PK', 'Pakistan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1178, 'COUNTRY', 'PM', 'SaintPierreetMiquelon'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1179, 'COUNTRY', 'PN', 'Pitcairn'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1180, 'COUNTRY', 'PR', 'Porto Rico'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1181, 'COUNTRY', 'PS', 'Palestine'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1182, 'COUNTRY', 'PT', 'Portugal'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1183, 'COUNTRY', 'PW', 'Palau'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1184, 'COUNTRY', 'PY', 'Paraguay'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1185, 'COUNTRY', 'QA', 'Qatar'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1186, 'COUNTRY', 'RO', 'Roumanie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1187, 'COUNTRY', 'RU', 'Russie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1188, 'COUNTRY', 'RW', 'Rwanda'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1189, 'COUNTRY', 'SA', 'Arabie saoudite'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1190, 'COUNTRY', 'SB', 'Salomon, îles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1191, 'COUNTRY', 'SC', 'Seychelles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1192, 'COUNTRY', 'SD', 'Soudan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1193, 'COUNTRY', 'SE', 'Suède'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1194, 'COUNTRY', 'SG', 'Singapour'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1195, 'COUNTRY', 'SH', 'SainteHélène'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1196, 'COUNTRY', 'SI', 'Slovénie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1197, 'COUNTRY', 'SJ', 'Svalbard et île Jan Mayen'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1198, 'COUNTRY', 'SK', 'Slovaquie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1199, 'COUNTRY', 'SL', 'Sierra Leone'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1200, 'COUNTRY', 'SM', 'SaintMarin'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1201, 'COUNTRY', 'SN', 'Sénégal'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1202, 'COUNTRY', 'SO', 'Somalie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1203, 'COUNTRY', 'SR', 'Suriname'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1204, 'COUNTRY', 'ST', 'Sao ToméetPrincipe'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1205, 'COUNTRY', 'SU', 'URSS'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1206, 'COUNTRY', 'SV', 'Salvador'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1207, 'COUNTRY', 'SY', 'Syrie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1208, 'COUNTRY', 'SZ', 'Swaziland'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1209, 'COUNTRY', 'TC', 'Turks et Caïques, îles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1210, 'COUNTRY', 'TD', 'Tchad'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1211, 'COUNTRY', 'TG', 'Togo'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1212, 'COUNTRY', 'TH', 'Thaïlande'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1213, 'COUNTRY', 'TJ', 'Tadjikistan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1214, 'COUNTRY', 'TK', 'Tokélau'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1215, 'COUNTRY', 'TL', 'Timor oriental'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1216, 'COUNTRY', 'TM', 'Turkménistan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1217, 'COUNTRY', 'TN', 'Tunisie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1218, 'COUNTRY', 'TO', 'Tonga'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1219, 'COUNTRY', 'TR', 'Turquie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1220, 'COUNTRY', 'TT', 'TrinitéetTobago'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1221, 'COUNTRY', 'TV', 'Tuvalu'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1222, 'COUNTRY', 'TW', 'taïwan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1223, 'COUNTRY', 'TZ', 'Tanzanie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1224, 'COUNTRY', 'UA', 'Ukraine'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1225, 'COUNTRY', 'UG', 'Ouganda'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1226, 'COUNTRY', 'UM', 'îles mineures éloignées des Etatsunis'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1227, 'COUNTRY', 'UY', 'Uruguay'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1228, 'COUNTRY', 'UZ', 'Ouzbékistan'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1229, 'COUNTRY', 'VA', 'Vatican'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1230, 'COUNTRY', 'VC', 'SaintVincentetles Grenadines'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1231, 'COUNTRY', 'VE', 'Venezuela'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1232, 'COUNTRY', 'VG', 'Iles Vierges britanniques'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1233, 'COUNTRY', 'VI', 'Iles Vierges (Etatsunis)'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1234, 'COUNTRY', 'VN', 'Viet Nam'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1235, 'COUNTRY', 'VU', 'Vanuatu'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1236, 'COUNTRY', 'WF', 'Wallis et Futuna, îles'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1237, 'COUNTRY', 'WS', 'Samoa'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1238, 'COUNTRY', 'XC', 'Tchécoslovaquie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1239, 'COUNTRY', 'XD', 'Allemagne avant 1945'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1240, 'COUNTRY', 'XE', 'Europe'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1242, 'COUNTRY', 'XK', 'Corée avant 1948'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1243, 'COUNTRY', 'YD', 'Yémen'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1244, 'COUNTRY', 'YU', 'Yougoslavie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1245, 'COUNTRY', 'ZA', 'Afrique du Sud'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1246, 'COUNTRY', 'ZM', 'Zambie'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1247, 'COUNTRY', 'ZW', 'Zimbabwe'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1248, 'COUNTRY', 'ZZ', 'multiple'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1249, 'COUNTRY', 'TA', 'Italie'); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1718, 'qualif', '370', 'Réalisateur'); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1845, 'qualif', '673', ' Directeur'); INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (1846, 'qualif', '605', 'Présentateur'); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 3c1c287145..8d7844e5b3 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -1959,6 +1959,14 @@ END_SQL print "Upgrade to $DBversion done (warning added to OPACShelfBrowser system preference)\n"; SetVersion ($DBversion); } + +$DBversion = "3.00.00.108"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("UPDATE authorised_values SET authorised_value=UPPER(authorised_value) WHERE category='COUNTRY'"); + print "Upgrade to $DBversion done (Converts COUNTRY authorised values to uppercase)\n"; + SetVersion ($DBversion); +} + if (C4::Context->preference("Version") =~/3\.00/) { my $perllibdir=C4::Context->config('intranetdir'); my $return=do qq($perllibdir/installer/data/mysql/updatedatabase30.pl); -- 2.39.5