Skip to content

Instantly share code, notes, and snippets.

@pmauduit
Created November 10, 2017 14:11
Show Gist options
  • Save pmauduit/d242b148e6481e71af64ac8764cca749 to your computer and use it in GitHub Desktop.
Save pmauduit/d242b148e6481e71af64ac8764cca749 to your computer and use it in GitHub Desktop.
categories GN geor
INSERT INTO categories VALUES (1, 'maps');
INSERT INTO categories VALUES (2, 'datasets');
INSERT INTO categories VALUES (3, 'interactiveResources');
INSERT INTO categories VALUES (4, 'applications');
INSERT INTO categories VALUES (5, 'caseStudies');
INSERT INTO categories VALUES (6, 'proceedings');
INSERT INTO categories VALUES (7, 'photo');
INSERT INTO categories VALUES (8, 'audioVideo');
INSERT INTO categories VALUES (9, 'directories');
INSERT INTO categories VALUES (10, 'otherResources');
INSERT INTO categories VALUES (11, 'z3950Servers');
INSERT INTO categories VALUES (12, 'registers');
INSERT INTO categories VALUES (13, 'physicalSamples');
INSERT INTO categoriesdes VALUES (1, 'eng', 'Maps & graphics');
INSERT INTO categoriesdes VALUES (2, 'eng', 'Datasets');
INSERT INTO categoriesdes VALUES (3, 'eng', 'Interactive resources');
INSERT INTO categoriesdes VALUES (4, 'eng', 'Applications');
INSERT INTO categoriesdes VALUES (5, 'eng', 'Case studies, best practices');
INSERT INTO categoriesdes VALUES (6, 'eng', 'Conference proceedings');
INSERT INTO categoriesdes VALUES (7, 'eng', 'Photo');
INSERT INTO categoriesdes VALUES (8, 'eng', 'Audio/Video');
INSERT INTO categoriesdes VALUES (9, 'eng', 'Directories');
INSERT INTO categoriesdes VALUES (10, 'eng', 'Other information resources');
INSERT INTO categoriesdes VALUES (11, 'eng', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'eng', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'eng', 'Physical Samples');
INSERT INTO categoriesdes VALUES (2, 'fre', 'Jeux de données');
INSERT INTO categoriesdes VALUES (1, 'fre', 'Cartes & graphiques');
INSERT INTO categoriesdes VALUES (7, 'fre', 'Photographies');
INSERT INTO categoriesdes VALUES (10, 'fre', 'Autres ressources');
INSERT INTO categoriesdes VALUES (5, 'fre', 'Etude de cas, meilleures pratiques');
INSERT INTO categoriesdes VALUES (8, 'fre', 'Vidéo/Audio');
INSERT INTO categoriesdes VALUES (9, 'fre', 'Répertoires');
INSERT INTO categoriesdes VALUES (4, 'fre', 'Applications');
INSERT INTO categoriesdes VALUES (3, 'fre', 'Ressources interactives');
INSERT INTO categoriesdes VALUES (6, 'fre', 'Conférences');
INSERT INTO categoriesdes VALUES (11, 'fre', 'Serveurs Z3950');
INSERT INTO categoriesdes VALUES (12, 'fre', 'Annuaires');
INSERT INTO categoriesdes VALUES (13, 'fre', 'Echantillons physiques');
INSERT INTO categoriesdes VALUES (1, 'ger', 'Karten & Grafiken');
INSERT INTO categoriesdes VALUES (2, 'ger', 'Datensets');
INSERT INTO categoriesdes VALUES (3, 'ger', 'Interaktive Resourcen');
INSERT INTO categoriesdes VALUES (4, 'ger', 'Applikationen');
INSERT INTO categoriesdes VALUES (5, 'ger', 'Fallstudien');
INSERT INTO categoriesdes VALUES (6, 'ger', 'Konferenz Ergebnisse');
INSERT INTO categoriesdes VALUES (7, 'ger', 'Photo');
INSERT INTO categoriesdes VALUES (8, 'ger', 'Audio/Video');
INSERT INTO categoriesdes VALUES (9, 'ger', 'Verzeichnisse');
INSERT INTO categoriesdes VALUES (10, 'ger', 'Andere Resourcen');
INSERT INTO categoriesdes VALUES (11, 'ger', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'ger', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'ger', 'Physischen Proben');
INSERT INTO categoriesdes VALUES (2, 'spa', 'Conjuntos de datos');
INSERT INTO categoriesdes VALUES (3, 'spa', 'Recursos interactivos');
INSERT INTO categoriesdes VALUES (5, 'spa', 'Casos de Uso, buenas prácticas');
INSERT INTO categoriesdes VALUES (4, 'spa', 'Aplicaciones');
INSERT INTO categoriesdes VALUES (6, 'spa', 'Resúmenes de conferencias');
INSERT INTO categoriesdes VALUES (7, 'spa', 'Fotografías');
INSERT INTO categoriesdes VALUES (9, 'spa', 'Directorios');
INSERT INTO categoriesdes VALUES (8, 'spa', 'Audio/Vídeo');
INSERT INTO categoriesdes VALUES (10, 'spa', 'Otros recursos de información');
INSERT INTO categoriesdes VALUES (1, 'spa', 'Mapas & gráficos');
INSERT INTO categoriesdes VALUES (11, 'spa', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'spa', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'spa', 'Muestras físicas');
INSERT INTO categoriesdes VALUES (1, 'cat', 'Mapes i gràfics');
INSERT INTO categoriesdes VALUES (2, 'cat', 'Conjunts de dades');
INSERT INTO categoriesdes VALUES (3, 'cat', 'Recursos interactius');
INSERT INTO categoriesdes VALUES (4, 'cat', 'Aplicacions');
INSERT INTO categoriesdes VALUES (5, 'cat', 'Casos d''ús, bones pràctiques');
INSERT INTO categoriesdes VALUES (6, 'cat', 'Actes de conferències');
INSERT INTO categoriesdes VALUES (7, 'cat', 'Foto');
INSERT INTO categoriesdes VALUES (8, 'cat', 'Àudio/Vídeo');
INSERT INTO categoriesdes VALUES (9, 'cat', 'Directoris');
INSERT INTO categoriesdes VALUES (10, 'cat', 'Altres recursos d''informació');
INSERT INTO categoriesdes VALUES (11, 'cat', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'cat', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'cat', 'Physical Samples');
INSERT INTO categoriesdes VALUES (1, 'rus', 'Карты и графика');
INSERT INTO categoriesdes VALUES (2, 'rus', 'Наборы данных');
INSERT INTO categoriesdes VALUES (3, 'rus', 'Интерактивные ресурсы');
INSERT INTO categoriesdes VALUES (4, 'rus', 'Компьютерные программы');
INSERT INTO categoriesdes VALUES (5, 'rus', 'Практические ситуации');
INSERT INTO categoriesdes VALUES (6, 'rus', 'Материалы конференций');
INSERT INTO categoriesdes VALUES (7, 'rus', 'Фотографии');
INSERT INTO categoriesdes VALUES (8, 'rus', 'Аудио/Видео');
INSERT INTO categoriesdes VALUES (9, 'rus', 'Каталоги/справочники');
INSERT INTO categoriesdes VALUES (10, 'rus', 'Другие ресурсы');
INSERT INTO categoriesdes VALUES (11, 'rus', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'rus', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'rus', 'Физические образцы');
INSERT INTO categoriesdes VALUES (1, 'por', 'Mapas & Graficos');
INSERT INTO categoriesdes VALUES (2, 'por', 'Datasets');
INSERT INTO categoriesdes VALUES (3, 'por', 'Fontes Interactivas');
INSERT INTO categoriesdes VALUES (4, 'por', 'Aplicações');
INSERT INTO categoriesdes VALUES (5, 'por', 'Estudos de Caso, Boas Praticas');
INSERT INTO categoriesdes VALUES (6, 'por', 'Procedimentos de Validação');
INSERT INTO categoriesdes VALUES (7, 'por', 'Foto');
INSERT INTO categoriesdes VALUES (8, 'por', 'Audio/Video');
INSERT INTO categoriesdes VALUES (9, 'por', 'Directorios');
INSERT INTO categoriesdes VALUES (10, 'por', 'Outra Informação sobre Fontes');
INSERT INTO categoriesdes VALUES (11, 'por', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'por', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'por', 'Amostras físicas');
INSERT INTO categoriesdes VALUES (1, 'chi', 'Maps & graphics');
INSERT INTO categoriesdes VALUES (2, 'chi', 'Datasets');
INSERT INTO categoriesdes VALUES (3, 'chi', 'Interactive resources');
INSERT INTO categoriesdes VALUES (4, 'chi', 'Applications');
INSERT INTO categoriesdes VALUES (5, 'chi', 'Case studies, best practices');
INSERT INTO categoriesdes VALUES (6, 'chi', 'Conference proceedings');
INSERT INTO categoriesdes VALUES (7, 'chi', 'Photo');
INSERT INTO categoriesdes VALUES (8, 'chi', 'Audio/Video');
INSERT INTO categoriesdes VALUES (9, 'chi', 'Directories');
INSERT INTO categoriesdes VALUES (10, 'chi', 'Other information resources');
INSERT INTO categoriesdes VALUES (11, 'chi', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'chi', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'chi', 'Physical Samples');
INSERT INTO categoriesdes VALUES (1, 'dut', 'Kaarten & afbeeldingen');
INSERT INTO categoriesdes VALUES (2, 'dut', 'Datasets');
INSERT INTO categoriesdes VALUES (3, 'dut', 'Interactieve kaarten');
INSERT INTO categoriesdes VALUES (4, 'dut', 'Toepassingen');
INSERT INTO categoriesdes VALUES (5, 'dut', 'Case studies, best practices');
INSERT INTO categoriesdes VALUES (6, 'dut', 'Conferentie handelingen');
INSERT INTO categoriesdes VALUES (7, 'dut', 'Fotos');
INSERT INTO categoriesdes VALUES (8, 'dut', 'Audio/Video');
INSERT INTO categoriesdes VALUES (9, 'dut', 'Catalogi');
INSERT INTO categoriesdes VALUES (10, 'dut', 'Andere informatie bronnen');
INSERT INTO categoriesdes VALUES (11, 'dut', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'dut', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'dut', 'Physical Samples');
INSERT INTO categoriesdes VALUES (1, 'nor', 'Kart og grafikk');
INSERT INTO categoriesdes VALUES (2, 'nor', 'Datasett');
INSERT INTO categoriesdes VALUES (3, 'nor', 'Interakive ressurser');
INSERT INTO categoriesdes VALUES (4, 'nor', 'Applikasjoner');
INSERT INTO categoriesdes VALUES (5, 'nor', 'Studier og anbefalinger');
INSERT INTO categoriesdes VALUES (6, 'nor', 'Konferanseresultater');
INSERT INTO categoriesdes VALUES (7, 'nor', 'Fotografier');
INSERT INTO categoriesdes VALUES (8, 'nor', 'Audio/Video');
INSERT INTO categoriesdes VALUES (9, 'nor', 'Kataloger');
INSERT INTO categoriesdes VALUES (10, 'nor', 'Andre ressurser');
INSERT INTO categoriesdes VALUES (11, 'nor', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'nor', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'nor', 'Physical Samples');
INSERT INTO categoriesdes VALUES (1, 'fin', 'Kartat & kuvat');
INSERT INTO categoriesdes VALUES (2, 'fin', 'Tietoaineistot');
INSERT INTO categoriesdes VALUES (3, 'fin', 'Vuorovaikutteiset resurssit');
INSERT INTO categoriesdes VALUES (4, 'fin', 'Sovellukset');
INSERT INTO categoriesdes VALUES (5, 'fin', 'Esimerkkitapaukset, parhaat käytännöt');
INSERT INTO categoriesdes VALUES (6, 'fin', 'Konferenssijulkaisut');
INSERT INTO categoriesdes VALUES (7, 'fin', 'Valokuvat');
INSERT INTO categoriesdes VALUES (8, 'fin', 'Äänitteet / Videot');
INSERT INTO categoriesdes VALUES (9, 'fin', 'Hakemistot');
INSERT INTO categoriesdes VALUES (10, 'fin', 'Other information resources');
INSERT INTO categoriesdes VALUES (11, 'fin', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'fin', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'fin', 'Fyysisiä näytteitä');
INSERT INTO categoriesdes VALUES (1, 'ara', 'Maps & graphics');
INSERT INTO categoriesdes VALUES (2, 'ara', 'Datasets');
INSERT INTO categoriesdes VALUES (3, 'ara', 'Interactive resources');
INSERT INTO categoriesdes VALUES (4, 'ara', 'Applications');
INSERT INTO categoriesdes VALUES (5, 'ara', 'Case studies, best practices');
INSERT INTO categoriesdes VALUES (6, 'ara', 'Conference proceedings');
INSERT INTO categoriesdes VALUES (7, 'ara', 'Photo');
INSERT INTO categoriesdes VALUES (8, 'ara', 'Audio/Video');
INSERT INTO categoriesdes VALUES (9, 'ara', 'Directories');
INSERT INTO categoriesdes VALUES (10, 'ara', 'Other information resources');
INSERT INTO categoriesdes VALUES (11, 'ara', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'ara', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'ara', 'Physical Samples');
INSERT INTO categoriesdes VALUES (1, 'ita', 'Mappe e grafici');
INSERT INTO categoriesdes VALUES (2, 'ita', 'Datasets');
INSERT INTO categoriesdes VALUES (3, 'ita', 'Risorse interattive');
INSERT INTO categoriesdes VALUES (4, 'ita', 'Applicazioni');
INSERT INTO categoriesdes VALUES (5, 'ita', 'Casi di studio');
INSERT INTO categoriesdes VALUES (6, 'ita', 'Atti di conferenze');
INSERT INTO categoriesdes VALUES (7, 'ita', 'Fotografie');
INSERT INTO categoriesdes VALUES (8, 'ita', 'Audio/Video');
INSERT INTO categoriesdes VALUES (9, 'ita', 'Archivi');
INSERT INTO categoriesdes VALUES (10, 'ita', 'Altre risorse di informazione');
INSERT INTO categoriesdes VALUES (11, 'ita', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'ita', 'Registri');
INSERT INTO categoriesdes VALUES (13, 'ita', 'campioni fisici');
INSERT INTO categoriesdes VALUES (1, 'tur', 'Haritalar & grafikler');
INSERT INTO categoriesdes VALUES (2, 'tur', 'Verisetleri');
INSERT INTO categoriesdes VALUES (3, 'tur', 'Interaktif kaynaklar');
INSERT INTO categoriesdes VALUES (4, 'tur', 'Uygulamalar');
INSERT INTO categoriesdes VALUES (5, 'tur', 'Örnek çalışmalar, başarılı uygulamalar');
INSERT INTO categoriesdes VALUES (6, 'tur', 'Konferans bildirileri');
INSERT INTO categoriesdes VALUES (7, 'tur', 'Fotoğraf');
INSERT INTO categoriesdes VALUES (8, 'tur', 'Ses/Video');
INSERT INTO categoriesdes VALUES (9, 'tur', 'Dizinler');
INSERT INTO categoriesdes VALUES (10, 'tur', 'Diğer bilgi kaynakları');
INSERT INTO categoriesdes VALUES (11, 'tur', 'Z3950 Sunucular');
INSERT INTO categoriesdes VALUES (12, 'tur', 'Kayıtlar');
INSERT INTO categoriesdes VALUES (13, 'tur', 'Fiziksel Örnekleri');
INSERT INTO categoriesdes VALUES (1, 'vie', 'Maps & graphics');
INSERT INTO categoriesdes VALUES (2, 'vie', 'Datasets');
INSERT INTO categoriesdes VALUES (3, 'vie', 'Interactive resources');
INSERT INTO categoriesdes VALUES (4, 'vie', 'Applications');
INSERT INTO categoriesdes VALUES (5, 'vie', 'Case studies, best practices');
INSERT INTO categoriesdes VALUES (6, 'vie', 'Conference proceedings');
INSERT INTO categoriesdes VALUES (7, 'vie', 'Photo');
INSERT INTO categoriesdes VALUES (8, 'vie', 'Audio/Video');
INSERT INTO categoriesdes VALUES (9, 'vie', 'Directories');
INSERT INTO categoriesdes VALUES (10, 'vie', 'Other information resources');
INSERT INTO categoriesdes VALUES (11, 'vie', 'Z3950 Servers');
INSERT INTO categoriesdes VALUES (12, 'vie', 'Registers');
INSERT INTO categoriesdes VALUES (13, 'vie', 'Physical Samples');
INSERT INTO categoriesdes VALUES (1, 'pol', 'Mapy i grafika');
INSERT INTO categoriesdes VALUES (2, 'pol', 'Zbiory danych');
INSERT INTO categoriesdes VALUES (3, 'pol', 'Źródła interaktywne');
INSERT INTO categoriesdes VALUES (4, 'pol', 'Aplikacje');
INSERT INTO categoriesdes VALUES (5, 'pol', 'Badania, najlepsze praktyki');
INSERT INTO categoriesdes VALUES (6, 'pol', 'Materiały konferencyjne');
INSERT INTO categoriesdes VALUES (7, 'pol', 'Zdjęcia');
INSERT INTO categoriesdes VALUES (8, 'pol', 'Audio/Wideo');
INSERT INTO categoriesdes VALUES (9, 'pol', 'Katalogi');
INSERT INTO categoriesdes VALUES (10, 'pol', 'Inne źródła informacji');
INSERT INTO categoriesdes VALUES (11, 'pol', 'Serwery Z3950');
INSERT INTO categoriesdes VALUES (12, 'pol', 'Rejestry');
INSERT INTO categoriesdes VALUES (13, 'pol', 'Physical Samples');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment