diff --git a/modules/miscutil/demo/democfgdata.sql b/modules/miscutil/demo/democfgdata.sql index a0fdd50ce..bd832efce 100644 --- a/modules/miscutil/demo/democfgdata.sql +++ b/modules/miscutil/demo/democfgdata.sql @@ -1,2379 +1,2379 @@ -- This file is part of Invenio. -- Copyright (C) 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010 CERN. -- -- Invenio is free software; you can redistribute it and/or -- modify it under the terms of the GNU General Public License as -- published by the Free Software Foundation; either version 2 of the -- License, or (at your option) any later version. -- -- Invenio is distributed in the hope that it will be useful, but -- WITHOUT ANY WARRANTY; without even the implied warranty of -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU -- General Public License for more details. -- -- You should have received a copy of the GNU General Public License -- along with Invenio; if not, write to the Free Software Foundation, Inc., -- 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA. INSERT INTO user VALUES (2,'jekyll@cds.cern.ch',AES_ENCRYPT(email,'j123ekyll'),'1',NULL,'jekyll',''); INSERT INTO user VALUES (3,'hyde@cds.cern.ch',AES_ENCRYPT(email,'h123yde'),'1',NULL,'hyde',''); INSERT INTO user VALUES (4,'dorian.gray@cds.cern.ch',AES_ENCRYPT(email,'d123orian'),'1',NULL,'dorian',''); -INSERT INTO user VALUES (5,'romeo.montague@cds.cern.ch',AES_ENCRYPT(email,'r123omeo'),'1','NULL','romeo',''); -INSERT INTO user VALUES (6,'juliet.capulet@cds.cern.ch',AES_ENCRYPT(email,'j123uliet'),'1','NULL','juliet',''); -INSERT INTO user VALUES (7,'benvolio.montague@cds.cern.ch',AES_ENCRYPT(email,'b123envolio'),'1','NULL','benvolio',''); -INSERT INTO user VALUES (8,'balthasar.montague@cds.cern.ch',AES_ENCRYPT(email,'b123althasar'),'1','NULL','balthasar',''); +INSERT INTO user VALUES (5,'romeo.montague@cds.cern.ch',AES_ENCRYPT(email,'r123omeo'),'1',NULL,'romeo',''); +INSERT INTO user VALUES (6,'juliet.capulet@cds.cern.ch',AES_ENCRYPT(email,'j123uliet'),'1',NULL,'juliet',''); +INSERT INTO user VALUES (7,'benvolio.montague@cds.cern.ch',AES_ENCRYPT(email,'b123envolio'),'1',NULL,'benvolio',''); +INSERT INTO user VALUES (8,'balthasar.montague@cds.cern.ch',AES_ENCRYPT(email,'b123althasar'),'1',NULL,'balthasar',''); INSERT INTO usergroup VALUES (1,'Theses viewers','Theses viewers internal group','VO','INTERNAL'); INSERT INTO usergroup VALUES (2,'montague-family','The Montague family.','VM','INTERNAL'); INSERT INTO user_usergroup VALUES (2,1,'M',NOW()); INSERT INTO user_usergroup VALUES (5,2,'A',NOW()); INSERT INTO user_usergroup VALUES (6,2,'M',NOW()); INSERT INTO user_usergroup VALUES (7,2,'M',NOW()); INSERT INTO collection VALUES (2,'Preprints','collection:PREPRINT',NULL,NULL); INSERT INTO collection VALUES (3,'Books','collection:BOOK',NULL,NULL); INSERT INTO collection VALUES (4,'Theses','collection:THESIS',NULL,NULL); INSERT INTO collection VALUES (5,'Reports','collection:REPORT',NULL,NULL); INSERT INTO collection VALUES (6,'Articles','collection:ARTICLE',NULL,NULL); INSERT INTO collection VALUES (8,'Pictures','collection:PICTURE',NULL,NULL); INSERT INTO collection VALUES (9,'CERN Divisions',NULL,NULL,NULL); INSERT INTO collection VALUES (10,'CERN Experiments',NULL,NULL,NULL); INSERT INTO collection VALUES (11,'Theoretical Physics (TH)','division:TH',NULL,NULL); INSERT INTO collection VALUES (12,'Experimental Physics (EP)','division:EP',NULL,NULL); INSERT INTO collection VALUES (13,'ISOLDE','experiment:ISOLDE',NULL,NULL); INSERT INTO collection VALUES (14,'ALEPH','experiment:ALEPH',NULL,NULL); INSERT INTO collection VALUES (15,'Articles & Preprints',NULL,NULL,NULL); INSERT INTO collection VALUES (16,'Books & Reports',NULL,NULL,NULL); INSERT INTO collection VALUES (17,'Multimedia & Arts',NULL,NULL,NULL); INSERT INTO collection VALUES (18,'Poetry','collection:POETRY',NULL,NULL); INSERT INTO collection VALUES (19,'Atlantis Times News','collection:ATLANTISTIMESNEWS',NULL,NULL); INSERT INTO collection VALUES (20,'Atlantis Times Arts','collection:ATLANTISTIMESARTS',NULL,NULL); INSERT INTO collection VALUES (21,'Atlantis Times Science','collection:ATLANTISTIMESSCIENCE',NULL,NULL); INSERT INTO collection VALUES (22,'Atlantis Times',NULL,NULL,NULL); INSERT INTO collection VALUES (23,'Atlantis Institute Books','hostedcollection:',NULL,NULL); INSERT INTO collection VALUES (24,'Atlantis Institute Articles','hostedcollection:',NULL,NULL); INSERT INTO clsMETHOD VALUES (1,'HEP','http://invenio-software.org/download/invenio-demo-site-files/HEP.rdf','High Energy Physics Taxonomy','0000-00-00 00:00:00'); INSERT INTO clsMETHOD VALUES (2,'NASA-subjects','http://invenio-software.org/download/invenio-demo-site-files/NASA-subjects.rdf','NASA Subjects','0000-00-00 00:00:00'); INSERT INTO collection_clsMETHOD VALUES (2,1); INSERT INTO collection_clsMETHOD VALUES (12,2); INSERT INTO collectionname VALUES (2,'en','ln','Preprints'); INSERT INTO collectionname VALUES (2,'fr','ln','Prétirages'); INSERT INTO collectionname VALUES (2,'de','ln','Preprints'); INSERT INTO collectionname VALUES (2,'es','ln','Preprints'); INSERT INTO collectionname VALUES (2,'ca','ln','Preprints'); INSERT INTO collectionname VALUES (2,'pl','ln','Preprinty'); INSERT INTO collectionname VALUES (2,'pt','ln','Preprints'); INSERT INTO collectionname VALUES (2,'it','ln','Preprint'); INSERT INTO collectionname VALUES (2,'ru','ln','Препринты'); INSERT INTO collectionname VALUES (2,'sk','ln','Preprinty'); INSERT INTO collectionname VALUES (2,'cs','ln','Preprinty'); INSERT INTO collectionname VALUES (2,'no','ln','Førtrykk'); INSERT INTO collectionname VALUES (2,'sv','ln','Preprints'); INSERT INTO collectionname VALUES (2,'el','ln','Προδημοσιεύσεις'); INSERT INTO collectionname VALUES (2,'uk','ln','Препринти'); INSERT INTO collectionname VALUES (2,'ja','ln','プレプリント'); INSERT INTO collectionname VALUES (2,'bg','ln','Препринти'); INSERT INTO collectionname VALUES (2,'hr','ln','Preprinti'); INSERT INTO collectionname VALUES (2,'zh_CN','ln','预印'); INSERT INTO collectionname VALUES (2,'zh_TW','ln','預印'); INSERT INTO collectionname VALUES (2,'hu','ln','Preprintek'); INSERT INTO collectionname VALUES (2,'af','ln','Pre-drukke'); INSERT INTO collectionname VALUES (2,'gl','ln','Preprints'); INSERT INTO collectionname VALUES (2,'ro','ln','Preprinturi'); INSERT INTO collectionname VALUES (2,'rw','ln','Preprints'); INSERT INTO collectionname VALUES (2,'ka','ln','პრეპრინტები'); INSERT INTO collectionname VALUES (3,'en','ln','Books'); INSERT INTO collectionname VALUES (3,'fr','ln','Livres'); INSERT INTO collectionname VALUES (3,'de','ln','Bücher'); INSERT INTO collectionname VALUES (3,'es','ln','Libros'); INSERT INTO collectionname VALUES (3,'ca','ln','Llibres'); INSERT INTO collectionname VALUES (3,'pl','ln','Książki'); INSERT INTO collectionname VALUES (3,'pt','ln','Livros'); INSERT INTO collectionname VALUES (3,'it','ln','Libri'); INSERT INTO collectionname VALUES (3,'ru','ln','Книги'); INSERT INTO collectionname VALUES (3,'sk','ln','Knihy'); INSERT INTO collectionname VALUES (3,'cs','ln','Knihy'); INSERT INTO collectionname VALUES (3,'no','ln','Bøker'); INSERT INTO collectionname VALUES (3,'sv','ln',''); INSERT INTO collectionname VALUES (3,'el','ln','Βιβλία'); INSERT INTO collectionname VALUES (3,'uk','ln','Книги'); INSERT INTO collectionname VALUES (3,'ja','ln','本'); INSERT INTO collectionname VALUES (3,'bg','ln','Книги'); INSERT INTO collectionname VALUES (3,'hr','ln','Knjige'); INSERT INTO collectionname VALUES (3,'zh_CN','ln','书本'); INSERT INTO collectionname VALUES (3,'zh_TW','ln','書本'); INSERT INTO collectionname VALUES (3,'hu','ln','Könyvek'); INSERT INTO collectionname VALUES (3,'af','ln','Boeke'); INSERT INTO collectionname VALUES (3,'gl','ln','Libros'); INSERT INTO collectionname VALUES (3,'ro','ln','Cărţi'); INSERT INTO collectionname VALUES (3,'rw','ln','Ibitabo'); INSERT INTO collectionname VALUES (3,'ka','ln','წიგნები'); INSERT INTO collectionname VALUES (4,'en','ln','Theses'); INSERT INTO collectionname VALUES (4,'fr','ln','Thèses'); INSERT INTO collectionname VALUES (4,'de','ln','Dissertationen'); INSERT INTO collectionname VALUES (4,'es','ln','Tesis'); INSERT INTO collectionname VALUES (4,'ca','ln','Tesis'); INSERT INTO collectionname VALUES (4,'pl','ln','Prace naukowe'); INSERT INTO collectionname VALUES (4,'pt','ln','Teses'); INSERT INTO collectionname VALUES (4,'it','ln','Tesi'); INSERT INTO collectionname VALUES (4,'ru','ln','Диссертации'); INSERT INTO collectionname VALUES (4,'sk','ln','Dizertácie'); INSERT INTO collectionname VALUES (4,'cs','ln','Disertace'); INSERT INTO collectionname VALUES (4,'no','ln','Avhandlinger'); INSERT INTO collectionname VALUES (4,'sv','ln',''); INSERT INTO collectionname VALUES (4,'el','ln','Διατριβές'); INSERT INTO collectionname VALUES (4,'uk','ln','Дисертації'); INSERT INTO collectionname VALUES (4,'ja','ln','説'); INSERT INTO collectionname VALUES (4,'bg','ln','Дисертации'); INSERT INTO collectionname VALUES (4,'hr','ln','Disertacije'); INSERT INTO collectionname VALUES (4,'zh_CN','ln','论文'); INSERT INTO collectionname VALUES (4,'zh_TW','ln','論文'); INSERT INTO collectionname VALUES (4,'hu','ln','Disszertációk'); INSERT INTO collectionname VALUES (4,'af','ln','Tesise'); INSERT INTO collectionname VALUES (4,'gl','ln','Teses'); INSERT INTO collectionname VALUES (4,'ro','ln','Teze'); INSERT INTO collectionname VALUES (4,'rw','ln','Igitabo ky\'ubushakashatsi'); -- ' INSERT INTO collectionname VALUES (4,'ka','ln','თეზისები'); INSERT INTO collectionname VALUES (5,'en','ln','Reports'); INSERT INTO collectionname VALUES (5,'fr','ln','Rapports'); INSERT INTO collectionname VALUES (5,'de','ln','Reports'); INSERT INTO collectionname VALUES (5,'es','ln','Informes'); INSERT INTO collectionname VALUES (5,'ca','ln','Informes'); INSERT INTO collectionname VALUES (5,'pl','ln','Raporty'); INSERT INTO collectionname VALUES (5,'pt','ln','Relatórios'); INSERT INTO collectionname VALUES (5,'it','ln','Rapporti'); INSERT INTO collectionname VALUES (5,'ru','ln','Рапорты'); INSERT INTO collectionname VALUES (5,'sk','ln','Správy'); INSERT INTO collectionname VALUES (5,'cs','ln','Zprávy'); INSERT INTO collectionname VALUES (5,'no','ln','Rapporter'); INSERT INTO collectionname VALUES (5,'sv','ln',''); INSERT INTO collectionname VALUES (5,'el','ln','Αναφορές'); INSERT INTO collectionname VALUES (5,'uk','ln','Звіти'); INSERT INTO collectionname VALUES (5,'ja','ln','レポート'); INSERT INTO collectionname VALUES (5,'bg','ln','Доклади'); INSERT INTO collectionname VALUES (5,'hr','ln','Izvještaji'); INSERT INTO collectionname VALUES (5,'zh_CN','ln','报告'); INSERT INTO collectionname VALUES (5,'zh_TW','ln','報告'); INSERT INTO collectionname VALUES (5,'hu','ln','Tanulmányok'); INSERT INTO collectionname VALUES (5,'af','ln','Verslae'); INSERT INTO collectionname VALUES (5,'gl','ln','Informes'); INSERT INTO collectionname VALUES (5,'ro','ln','Rapoarte'); INSERT INTO collectionname VALUES (5,'rw','ln','Raporo'); INSERT INTO collectionname VALUES (5,'ka','ln','რეპორტები'); INSERT INTO collectionname VALUES (6,'en','ln','Articles'); INSERT INTO collectionname VALUES (6,'fr','ln','Articles'); INSERT INTO collectionname VALUES (6,'de','ln','Artikel'); INSERT INTO collectionname VALUES (6,'es','ln','Articulos'); INSERT INTO collectionname VALUES (6,'ca','ln','Articles'); INSERT INTO collectionname VALUES (6,'pl','ln','Artykuły'); INSERT INTO collectionname VALUES (6,'pt','ln','Artigos'); INSERT INTO collectionname VALUES (6,'it','ln','Articoli'); INSERT INTO collectionname VALUES (6,'ru','ln','Статьи'); INSERT INTO collectionname VALUES (6,'sk','ln','Články'); INSERT INTO collectionname VALUES (6,'cs','ln','Články'); INSERT INTO collectionname VALUES (6,'no','ln','Artikler'); INSERT INTO collectionname VALUES (6,'sv','ln',''); INSERT INTO collectionname VALUES (6,'el','ln',"Άρθρα"); INSERT INTO collectionname VALUES (6,'uk','ln','Статті'); INSERT INTO collectionname VALUES (6,'ja','ln','記事'); INSERT INTO collectionname VALUES (6,'bg','ln','Статии'); INSERT INTO collectionname VALUES (6,'hr','ln','Članci'); INSERT INTO collectionname VALUES (6,'zh_CN','ln','文章'); INSERT INTO collectionname VALUES (6,'zh_TW','ln','文章'); INSERT INTO collectionname VALUES (6,'hu','ln','Cikkek'); INSERT INTO collectionname VALUES (6,'af','ln','Artikels'); INSERT INTO collectionname VALUES (6,'gl','ln','Artigos'); INSERT INTO collectionname VALUES (6,'ro','ln','Articole'); INSERT INTO collectionname VALUES (6,'rw','ln','Ikinyamakuru ky\'ubushakashatsi'); -- ' INSERT INTO collectionname VALUES (6,'ka','ln','სტატიები'); INSERT INTO collectionname VALUES (8,'en','ln','Pictures'); INSERT INTO collectionname VALUES (8,'fr','ln','Photos'); INSERT INTO collectionname VALUES (8,'de','ln','Fotos'); INSERT INTO collectionname VALUES (8,'es','ln','Imagenes'); INSERT INTO collectionname VALUES (8,'ca','ln','Imatges'); INSERT INTO collectionname VALUES (8,'pl','ln','Obrazy'); INSERT INTO collectionname VALUES (8,'pt','ln','Fotografias'); INSERT INTO collectionname VALUES (8,'it','ln','Foto'); INSERT INTO collectionname VALUES (8,'ru','ln','Фотографии'); INSERT INTO collectionname VALUES (8,'sk','ln','Fotografie'); INSERT INTO collectionname VALUES (8,'cs','ln','Fotografie'); INSERT INTO collectionname VALUES (8,'no','ln','Fotografier'); INSERT INTO collectionname VALUES (8,'sv','ln',''); INSERT INTO collectionname VALUES (8,'el','ln','Εικόνες'); INSERT INTO collectionname VALUES (8,'uk','ln','Зображення'); INSERT INTO collectionname VALUES (8,'ja','ln','映像'); INSERT INTO collectionname VALUES (8,'bg','ln','Снимки'); INSERT INTO collectionname VALUES (8,'hr','ln','Slike'); INSERT INTO collectionname VALUES (8,'zh_CN','ln','图片'); INSERT INTO collectionname VALUES (8,'zh_TW','ln','圖片'); INSERT INTO collectionname VALUES (8,'hu','ln','Képek'); INSERT INTO collectionname VALUES (8,'af','ln','Prente'); INSERT INTO collectionname VALUES (8,'gl','ln','Imaxes'); INSERT INTO collectionname VALUES (8,'ro','ln','Poze'); INSERT INTO collectionname VALUES (8,'rw','ln','Ifoto'); INSERT INTO collectionname VALUES (8,'ka','ln','სურათები'); INSERT INTO collectionname VALUES (9,'en','ln','CERN Divisions'); INSERT INTO collectionname VALUES (9,'fr','ln','Divisions du CERN'); INSERT INTO collectionname VALUES (9,'de','ln','Abteilungen des CERN'); INSERT INTO collectionname VALUES (9,'es','ln','Divisiones del CERN'); INSERT INTO collectionname VALUES (9,'ca','ln','Divisions del CERN'); INSERT INTO collectionname VALUES (9,'pl','ln','Działy CERN'); INSERT INTO collectionname VALUES (9,'pt','ln','Divisões do CERN'); INSERT INTO collectionname VALUES (9,'it','ln','Divisioni del CERN'); INSERT INTO collectionname VALUES (9,'ru','ln','Разделения CERNа'); INSERT INTO collectionname VALUES (9,'sk','ln','Oddelenia CERNu'); INSERT INTO collectionname VALUES (9,'cs','ln','Oddělení CERNu'); INSERT INTO collectionname VALUES (9,'no','ln','Divisjoner ved CERN'); INSERT INTO collectionname VALUES (9,'sv','ln',''); INSERT INTO collectionname VALUES (9,'el','ln','Τομείς του CERN'); INSERT INTO collectionname VALUES (9,'uk','ln','Підрозділи CERN'); INSERT INTO collectionname VALUES (9,'ja','ln','CERN 部'); INSERT INTO collectionname VALUES (9,'bg','ln','Отдели в CERN'); INSERT INTO collectionname VALUES (9,'hr','ln','Odjeli CERN-a'); INSERT INTO collectionname VALUES (9,'zh_CN','ln','CERN 分类'); INSERT INTO collectionname VALUES (9,'zh_TW','ln','CERN 分類'); INSERT INTO collectionname VALUES (9,'hu','ln','CERN részlegek'); INSERT INTO collectionname VALUES (9,'af','ln','CERN Afdelings'); INSERT INTO collectionname VALUES (9,'gl','ln','Divisións do CERN'); INSERT INTO collectionname VALUES (9,'ro','ln','Divizii CERN'); INSERT INTO collectionname VALUES (9,'rw','ln','Ishami ya CERN'); INSERT INTO collectionname VALUES (9,'ka','ln','ცერნის განყოფილებები'); INSERT INTO collectionname VALUES (10,'en','ln','CERN Experiments'); INSERT INTO collectionname VALUES (10,'fr','ln','Expériences du CERN'); INSERT INTO collectionname VALUES (10,'de','ln','Experimente des CERN'); INSERT INTO collectionname VALUES (10,'es','ln','Experimentos del CERN'); INSERT INTO collectionname VALUES (10,'ca','ln','Experiments del CERN'); INSERT INTO collectionname VALUES (10,'pl','ln','Eksperymenty CERN'); INSERT INTO collectionname VALUES (10,'pt','ln','Experimentos do CERN'); INSERT INTO collectionname VALUES (10,'it','ln','Esperimenti del CERN'); INSERT INTO collectionname VALUES (10,'ru','ln','Эксперименты CERNа'); INSERT INTO collectionname VALUES (10,'sk','ln','Experimenty CERNu'); INSERT INTO collectionname VALUES (10,'cs','ln','Experimenty CERNu'); INSERT INTO collectionname VALUES (10,'no','ln','Eksperimenter ved CERN'); INSERT INTO collectionname VALUES (10,'sv','ln',''); INSERT INTO collectionname VALUES (10,'el','ln','Πειράματα του CERN'); INSERT INTO collectionname VALUES (10,'uk','ln','Експерименти CERN'); INSERT INTO collectionname VALUES (10,'ja','ln','CERN の実験'); INSERT INTO collectionname VALUES (10,'bg','ln','Експерименти в CERN'); INSERT INTO collectionname VALUES (10,'hr','ln','Eksperimenti CERN-a'); INSERT INTO collectionname VALUES (10,'zh_CN','ln','CERN 实验'); INSERT INTO collectionname VALUES (10,'zh_TW','ln','CERN 實驗'); INSERT INTO collectionname VALUES (10,'hu','ln','CERN kísérletek'); INSERT INTO collectionname VALUES (10,'af','ln','CERN Experimente'); INSERT INTO collectionname VALUES (10,'gl','ln','Experimentos do CERN'); INSERT INTO collectionname VALUES (10,'ro','ln','Experimente CERN'); INSERT INTO collectionname VALUES (10,'rw','ln','Ubushakashatsi bwa CERN'); INSERT INTO collectionname VALUES (10,'ka','ln','ცერნის ექსპერემენტები'); INSERT INTO collectionname VALUES (11,'en','ln','Theoretical Physics (TH)'); INSERT INTO collectionname VALUES (11,'fr','ln','Physique Théorique (TH)'); INSERT INTO collectionname VALUES (11,'de','ln','Theoretische Physik (TH)'); INSERT INTO collectionname VALUES (11,'es','ln','Física teórica (TH)'); INSERT INTO collectionname VALUES (11,'ca','ln','Física teòrica (TH)'); INSERT INTO collectionname VALUES (11,'pl','ln','Fizyka Teoretyczna (TH)'); INSERT INTO collectionname VALUES (11,'pt','ln','Física Teórica (TH)'); INSERT INTO collectionname VALUES (11,'it','ln','Fisica Teorica (TH)'); INSERT INTO collectionname VALUES (11,'ru','ln','Теоретическая физика (TH)'); INSERT INTO collectionname VALUES (11,'sk','ln','Teoretická fyzika (TH)'); INSERT INTO collectionname VALUES (11,'cs','ln','Teoretická fyzika (TH)'); INSERT INTO collectionname VALUES (11,'no','ln','Teoretisk fysikk (TH)'); INSERT INTO collectionname VALUES (11,'sv','ln',''); INSERT INTO collectionname VALUES (11,'el','ln','Θεωρητική Φυσική (TH)'); INSERT INTO collectionname VALUES (11,'uk','ln','Теоретична фізика (TH)'); INSERT INTO collectionname VALUES (11,'ja','ln','理論的な物理学 (TH)'); INSERT INTO collectionname VALUES (11,'bg','ln','Теоретична физика (TH)'); INSERT INTO collectionname VALUES (11,'hr','ln','Teorijska fizika (TH)'); INSERT INTO collectionname VALUES (11,'zh_CN','ln','理论物理 (TH)'); INSERT INTO collectionname VALUES (11,'zh_TW','ln','理論物理 (TH)'); INSERT INTO collectionname VALUES (11,'hu','ln','Elméleti fizika (TH)'); INSERT INTO collectionname VALUES (11,'af','ln','Teoretiese Fisika (TH)'); INSERT INTO collectionname VALUES (11,'gl','ln','Física Teórica (TH)'); INSERT INTO collectionname VALUES (11,'ro','ln','Fizică Teoretică (TH)'); INSERT INTO collectionname VALUES (11,'rw','ln','Theoretical Physics (TH)'); INSERT INTO collectionname VALUES (11,'ka','ln','თეორიული ფიზიკა (თფ)'); INSERT INTO collectionname VALUES (12,'en','ln','Experimental Physics (EP)'); INSERT INTO collectionname VALUES (12,'fr','ln','Physique Expérimentale (EP)'); INSERT INTO collectionname VALUES (12,'de','ln','Experimentelle Physik (EP)'); INSERT INTO collectionname VALUES (12,'es','ln','Física experimental (FE)'); INSERT INTO collectionname VALUES (12,'ca','ln','Física experimental (EP)'); INSERT INTO collectionname VALUES (12,'pl','ln','Fizyka Doświadczalna (EP)'); INSERT INTO collectionname VALUES (12,'pt','ln','Física Experimental (EP)'); INSERT INTO collectionname VALUES (12,'it','ln','Fisica Sperimentale (EP)'); INSERT INTO collectionname VALUES (12,'ru','ln','Экспериментальная Физика (EP)'); INSERT INTO collectionname VALUES (12,'sk','ln','Experimentálna fyzika (EP)'); INSERT INTO collectionname VALUES (12,'cs','ln','Experimentální fyzika (EP)'); INSERT INTO collectionname VALUES (12,'no','ln','Eksperimentell fysikk (EP)'); INSERT INTO collectionname VALUES (12,'sv','ln',''); INSERT INTO collectionname VALUES (12,'el','ln','Πειραματική Φυσική (EP)'); INSERT INTO collectionname VALUES (12,'uk','ln','Експериментальна фізика (EP)'); INSERT INTO collectionname VALUES (12,'ja','ln','実験物理学 (EP)'); INSERT INTO collectionname VALUES (12,'bg','ln','Експериментална физика (EP)'); INSERT INTO collectionname VALUES (12,'hr','ln','Eksperimentalna fizika (EP)'); INSERT INTO collectionname VALUES (12,'zh_CN','ln','实验物理 (EP)'); INSERT INTO collectionname VALUES (12,'zh_TW','ln','實驗物理 (EP)'); INSERT INTO collectionname VALUES (12,'hu','ln','Kísérleti fizika (EP)'); INSERT INTO collectionname VALUES (12,'af','ln','Eksperimentele Fisika (EP)'); INSERT INTO collectionname VALUES (12,'gl','ln','Física Experimental (EP)'); INSERT INTO collectionname VALUES (12,'ro','ln','Fizică Experimentală (EP)'); INSERT INTO collectionname VALUES (12,'rw','ln','Experimental Physics (EP)'); INSERT INTO collectionname VALUES (12,'ka','ln','ექსპერიმენტული ფიზიკა (ეფ)'); INSERT INTO collectionname VALUES (13,'en','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'fr','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'de','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'es','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'ca','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'pl','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'pt','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'it','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'ru','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'sk','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'cs','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'no','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'sv','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'el','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'uk','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'ja','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'bg','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'hr','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'zh_CN','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'zh_TW','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'hu','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'af','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'gl','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'ro','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'rw','ln','ISOLDE'); INSERT INTO collectionname VALUES (13,'ka','ln','ISOLDE'); INSERT INTO collectionname VALUES (14,'en','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'fr','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'de','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'es','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'ca','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'pl','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'pt','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'it','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'ru','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'sk','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'cs','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'no','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'sv','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'el','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'uk','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'ja','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'bg','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'hr','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'zh_CN','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'zh_TW','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'hu','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'af','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'gl','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'ro','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'rw','ln','ALEPH'); INSERT INTO collectionname VALUES (14,'ka','ln','ALEPH'); INSERT INTO collectionname VALUES (15,'en','ln','Articles & Preprints'); INSERT INTO collectionname VALUES (15,'fr','ln','Articles et Prétirages'); INSERT INTO collectionname VALUES (15,'de','ln','Artikel & Preprints'); INSERT INTO collectionname VALUES (15,'es','ln','Articulos y preprints'); INSERT INTO collectionname VALUES (15,'ca','ln','Articles i preprints'); INSERT INTO collectionname VALUES (15,'pl','ln','Artykuły i Preprinty'); INSERT INTO collectionname VALUES (15,'pt','ln','Artigos e Preprints'); INSERT INTO collectionname VALUES (15,'it','ln','Articoli e Preprint'); INSERT INTO collectionname VALUES (15,'ru','ln','Статьи и Препринты'); INSERT INTO collectionname VALUES (15,'sk','ln','Články a Preprinty'); INSERT INTO collectionname VALUES (15,'cs','ln','Články a Preprinty'); INSERT INTO collectionname VALUES (15,'no','ln','Artikler og Førtrykk'); INSERT INTO collectionname VALUES (15,'sv','ln',''); INSERT INTO collectionname VALUES (15,'el','ln',"Άρθρα & Προδημοσιεύσεις"); INSERT INTO collectionname VALUES (15,'uk','ln','Статті та Препринти'); INSERT INTO collectionname VALUES (15,'ja','ln','記事及びプレプリント'); INSERT INTO collectionname VALUES (15,'bg','ln','Статии и Препринти'); INSERT INTO collectionname VALUES (15,'hr','ln','Članci i Preprinti'); INSERT INTO collectionname VALUES (15,'zh_CN','ln','文章和预印'); INSERT INTO collectionname VALUES (15,'zh_TW','ln','文章和預印'); INSERT INTO collectionname VALUES (15,'hu','ln','Cikkek és Preprintek'); INSERT INTO collectionname VALUES (15,'af','ln','Artikels & Pre-drukke'); INSERT INTO collectionname VALUES (15,'gl','ln','Artigos e Preprints'); INSERT INTO collectionname VALUES (15,'ro','ln','Articole şi Preprinturi'); INSERT INTO collectionname VALUES (15,'rw','ln','Ibinyamakuru'); INSERT INTO collectionname VALUES (15,'ka','ln','სტატიები და პრეპრინტები'); INSERT INTO collectionname VALUES (16,'en','ln','Books & Reports'); INSERT INTO collectionname VALUES (16,'fr','ln','Livres et Rapports'); INSERT INTO collectionname VALUES (16,'de','ln','Monographien & Reports'); INSERT INTO collectionname VALUES (16,'es','ln','Libros e informes'); INSERT INTO collectionname VALUES (16,'ca','ln','Llibres i informes'); INSERT INTO collectionname VALUES (16,'pl','ln','Książki i Raporty'); INSERT INTO collectionname VALUES (16,'pt','ln','Livros e Relatórios'); INSERT INTO collectionname VALUES (16,'it','ln','Libri e Rapporti'); INSERT INTO collectionname VALUES (16,'ru','ln','Книги и Рапорты'); INSERT INTO collectionname VALUES (16,'sk','ln','Knihy a Správy'); INSERT INTO collectionname VALUES (16,'cs','ln','Knihy a Zprávy'); INSERT INTO collectionname VALUES (16,'no','ln','Bøker og Rapporter'); INSERT INTO collectionname VALUES (16,'sv','ln',''); INSERT INTO collectionname VALUES (16,'el','ln','Βιβλία & Αναφορές'); INSERT INTO collectionname VALUES (16,'uk','ln','Книги та Звіти'); INSERT INTO collectionname VALUES (16,'ja','ln','本及びレポート'); INSERT INTO collectionname VALUES (16,'bg','ln','Книги и Доклади'); INSERT INTO collectionname VALUES (16,'hr','ln','Knjige i Izvještaji'); INSERT INTO collectionname VALUES (16,'zh_CN','ln','书本和报告'); INSERT INTO collectionname VALUES (16,'zh_TW','ln','書本和報告'); INSERT INTO collectionname VALUES (16,'hu','ln','Könyvek és tanulmányok'); INSERT INTO collectionname VALUES (16,'af','ln','Boeke & Verslae'); INSERT INTO collectionname VALUES (16,'gl','ln','Libros e Informes'); INSERT INTO collectionname VALUES (16,'ro','ln','Cărţi şi Rapoarte'); INSERT INTO collectionname VALUES (16,'rw','ln','Ibitabo & Raporo'); INSERT INTO collectionname VALUES (16,'ka','ln','წიგნები და მოხსენებები'); INSERT INTO collectionname VALUES (17,'en','ln','Multimedia & Arts'); INSERT INTO collectionname VALUES (17,'fr','ln','Multimédia et Arts'); INSERT INTO collectionname VALUES (17,'de','ln','Multimedia & Kunst'); INSERT INTO collectionname VALUES (17,'es','ln','Multimedia y artes'); INSERT INTO collectionname VALUES (17,'ca','ln','Multimèdia i arts'); INSERT INTO collectionname VALUES (17,'pl','ln','Multimedia i Sztuka'); INSERT INTO collectionname VALUES (17,'pt','ln','Multimédia e Artes'); INSERT INTO collectionname VALUES (17,'it','ln','Multimedia e Arti'); INSERT INTO collectionname VALUES (17,'ru','ln','Мультимедиа и Исскуство'); INSERT INTO collectionname VALUES (17,'sk','ln','Multimédia a Umenie'); INSERT INTO collectionname VALUES (17,'cs','ln','Multimédia a Umění'); INSERT INTO collectionname VALUES (17,'no','ln','Multimedia og Grafikk'); INSERT INTO collectionname VALUES (17,'sv','ln',''); INSERT INTO collectionname VALUES (17,'el','ln','Πολυμέσα & Τέχνες'); INSERT INTO collectionname VALUES (17,'uk','ln','Мультимедіа та Мистецтво'); INSERT INTO collectionname VALUES (17,'ja','ln','マルチメディア及び芸術'); INSERT INTO collectionname VALUES (17,'bg','ln','Мултимедия и Изкуства'); INSERT INTO collectionname VALUES (17,'hr','ln','Multimedija i Umjetnost'); INSERT INTO collectionname VALUES (17,'zh_CN','ln','多媒体和艺术'); INSERT INTO collectionname VALUES (17,'zh_TW','ln','多媒體和藝術'); INSERT INTO collectionname VALUES (17,'hu','ln','Multimédia és képzőművészet'); INSERT INTO collectionname VALUES (17,'af','ln','Multimedia & Kunste'); INSERT INTO collectionname VALUES (17,'gl','ln','Multimedia e Arte'); INSERT INTO collectionname VALUES (17,'ro','ln','Multimedia şi Arte'); INSERT INTO collectionname VALUES (17,'rw','ln','Multimedia & Arts'); INSERT INTO collectionname VALUES (17,'ka','ln','მულტიმედია და ხელოვნება'); INSERT INTO collectionname VALUES (18,'en','ln','Poetry'); INSERT INTO collectionname VALUES (18,'fr','ln','Poésie'); INSERT INTO collectionname VALUES (18,'de','ln','Poesie'); INSERT INTO collectionname VALUES (18,'es','ln','Poesía'); INSERT INTO collectionname VALUES (18,'ca','ln','Poesia'); INSERT INTO collectionname VALUES (18,'pl','ln','Poezja'); INSERT INTO collectionname VALUES (18,'pt','ln','Poesia'); INSERT INTO collectionname VALUES (18,'it','ln','Poesia'); INSERT INTO collectionname VALUES (18,'ru','ln','Поэзия'); INSERT INTO collectionname VALUES (18,'sk','ln','Poézia'); INSERT INTO collectionname VALUES (18,'cs','ln','Poezie'); INSERT INTO collectionname VALUES (18,'no','ln','Poesi'); INSERT INTO collectionname VALUES (18,'sv','ln',''); INSERT INTO collectionname VALUES (18,'el','ln','Ποίηση'); INSERT INTO collectionname VALUES (18,'uk','ln','Поезія'); INSERT INTO collectionname VALUES (18,'ja','ln','詩歌'); INSERT INTO collectionname VALUES (18,'bg','ln','Поезия'); INSERT INTO collectionname VALUES (18,'hr','ln','Poezija'); INSERT INTO collectionname VALUES (18,'zh_CN','ln','诗歌'); INSERT INTO collectionname VALUES (18,'zh_TW','ln','詩歌'); INSERT INTO collectionname VALUES (18,'hu','ln','Költészet'); INSERT INTO collectionname VALUES (18,'af','ln','Poësie'); INSERT INTO collectionname VALUES (18,'gl','ln','Poesía'); INSERT INTO collectionname VALUES (18,'ro','ln','Poezie'); INSERT INTO collectionname VALUES (18,'rw','ln','Umuvugo'); INSERT INTO collectionname VALUES (18,'ka','ln','პოეზია'); INSERT INTO collectionname VALUES (19,'en','ln','Atlantis Times News'); INSERT INTO collectionname VALUES (19,'fr','ln','Atlantis Times Actualités'); INSERT INTO collectionname VALUES (20,'en','ln','Atlantis Times Arts'); INSERT INTO collectionname VALUES (20,'fr','ln','Atlantis Times Arts'); INSERT INTO collectionname VALUES (21,'en','ln','Atlantis Times Science'); INSERT INTO collectionname VALUES (21,'fr','ln','Atlantis Times Science'); INSERT INTO collectionname VALUES (22,'en','ln','Atlantis Times'); INSERT INTO collectionname VALUES (22,'fr','ln','Atlantis Times'); INSERT INTO collectionname VALUES (23,'en','ln','Atlantis Institute Books'); INSERT INTO collectionname VALUES (23,'fr','ln','Atlantis Institute Books'); INSERT INTO collectionname VALUES (24,'en','ln','Atlantis Institute Articles'); INSERT INTO collectionname VALUES (24,'fr','ln','Atlantis Institute Articles'); INSERT INTO collection_collection VALUES (1,15,'r',60); INSERT INTO collection_collection VALUES (1,16,'r',40); INSERT INTO collection_collection VALUES (1,17,'r',30); -- INSERT INTO collection_collection VALUES (1,23,'r',20); -- INSERT INTO collection_collection VALUES (1,24,'r',10); INSERT INTO collection_collection VALUES (15,6,'r',20); INSERT INTO collection_collection VALUES (15,2,'r',10); INSERT INTO collection_collection VALUES (16,3,'r',30); INSERT INTO collection_collection VALUES (16,4,'r',20); INSERT INTO collection_collection VALUES (16,5,'r',10); INSERT INTO collection_collection VALUES (17,8,'r',30); INSERT INTO collection_collection VALUES (17,18,'r',20); INSERT INTO collection_collection VALUES (17,22,'r',10); INSERT INTO collection_collection VALUES (22,19,'r',30); INSERT INTO collection_collection VALUES (22,20,'r',20); INSERT INTO collection_collection VALUES (22,21,'r',10); INSERT INTO collection_collection VALUES (1,9,'v',20); INSERT INTO collection_collection VALUES (1,10,'v',10); INSERT INTO collection_collection VALUES (9,11,'r',10); INSERT INTO collection_collection VALUES (9,12,'r',20); INSERT INTO collection_collection VALUES (10,13,'r',10); INSERT INTO collection_collection VALUES (10,14,'r',20); INSERT INTO collection_example VALUES (1,1,1); INSERT INTO collection_example VALUES (1,5,2); INSERT INTO collection_example VALUES (1,8,3); INSERT INTO collection_example VALUES (1,7,5); INSERT INTO collection_example VALUES (1,6,4); INSERT INTO collection_example VALUES (1,4,6); INSERT INTO collection_example VALUES (1,3,7); INSERT INTO collection_example VALUES (1,13,50); INSERT INTO collection_example VALUES (1,2,8); INSERT INTO collection_example VALUES (2,1,1); INSERT INTO collection_example VALUES (2,5,2); INSERT INTO collection_example VALUES (2,8,3); INSERT INTO collection_example VALUES (2,7,5); INSERT INTO collection_example VALUES (2,6,4); INSERT INTO collection_example VALUES (2,4,6); INSERT INTO collection_example VALUES (2,3,7); INSERT INTO collection_example VALUES (2,2,8); INSERT INTO collection_example VALUES (3,6,30); INSERT INTO collection_example VALUES (3,17,10); INSERT INTO collection_example VALUES (3,18,20); INSERT INTO collection_example VALUES (4,1,1); INSERT INTO collection_example VALUES (4,5,2); INSERT INTO collection_example VALUES (4,8,3); INSERT INTO collection_example VALUES (4,7,5); INSERT INTO collection_example VALUES (4,6,4); INSERT INTO collection_example VALUES (4,4,6); INSERT INTO collection_example VALUES (4,3,7); INSERT INTO collection_example VALUES (4,2,8); INSERT INTO collection_example VALUES (5,1,1); INSERT INTO collection_example VALUES (5,5,2); INSERT INTO collection_example VALUES (5,8,3); INSERT INTO collection_example VALUES (5,7,5); INSERT INTO collection_example VALUES (5,6,4); INSERT INTO collection_example VALUES (5,4,6); INSERT INTO collection_example VALUES (5,3,7); INSERT INTO collection_example VALUES (5,2,8); INSERT INTO collection_example VALUES (6,1,10); INSERT INTO collection_example VALUES (6,5,20); INSERT INTO collection_example VALUES (6,8,30); INSERT INTO collection_example VALUES (6,0,27); INSERT INTO collection_example VALUES (6,4,40); INSERT INTO collection_example VALUES (6,3,60); INSERT INTO collection_example VALUES (6,2,80); INSERT INTO collection_example VALUES (8,14,10); INSERT INTO collection_example VALUES (8,15,20); INSERT INTO collection_example VALUES (8,16,30); INSERT INTO collection_example VALUES (15,0,27); INSERT INTO collection_example VALUES (15,1,1); INSERT INTO collection_example VALUES (15,2,8); INSERT INTO collection_example VALUES (15,3,60); INSERT INTO collection_example VALUES (15,4,40); INSERT INTO collection_example VALUES (15,5,2); INSERT INTO collection_example VALUES (15,6,4); INSERT INTO collection_example VALUES (15,7,5); INSERT INTO collection_example VALUES (15,8,3); INSERT INTO collection_example VALUES (16,1,1); INSERT INTO collection_example VALUES (16,2,8); INSERT INTO collection_example VALUES (16,3,7); INSERT INTO collection_example VALUES (16,4,6); INSERT INTO collection_example VALUES (16,5,2); INSERT INTO collection_example VALUES (16,6,4); INSERT INTO collection_example VALUES (16,7,5); INSERT INTO collection_example VALUES (16,8,3); INSERT INTO collection_example VALUES (17,14,10); INSERT INTO collection_example VALUES (17,15,20); INSERT INTO collection_example VALUES (17,16,30); INSERT INTO collection_example VALUES (1,19,0); INSERT INTO collection_example VALUES (15,19,0); INSERT INTO collection_example VALUES (16,19,0); INSERT INTO collection_field_fieldvalue VALUES (2,7,7,'seo',10,18); INSERT INTO collection_field_fieldvalue VALUES (2,7,6,'seo',10,19); INSERT INTO collection_field_fieldvalue VALUES (2,7,5,'seo',10,20); INSERT INTO collection_field_fieldvalue VALUES (2,7,4,'seo',10,21); INSERT INTO collection_field_fieldvalue VALUES (6,7,1,'seo',2,24); INSERT INTO collection_field_fieldvalue VALUES (6,7,2,'seo',2,23); INSERT INTO collection_field_fieldvalue VALUES (6,7,3,'seo',2,22); INSERT INTO collection_field_fieldvalue VALUES (6,7,4,'seo',2,21); INSERT INTO collection_field_fieldvalue VALUES (6,7,5,'seo',2,20); INSERT INTO collection_field_fieldvalue VALUES (6,7,6,'seo',2,19); INSERT INTO collection_field_fieldvalue VALUES (6,7,7,'seo',2,18); INSERT INTO collection_field_fieldvalue VALUES (6,7,8,'seo',2,17); INSERT INTO collection_field_fieldvalue VALUES (6,7,9,'seo',2,16); INSERT INTO collection_field_fieldvalue VALUES (6,7,10,'seo',2,15); INSERT INTO collection_field_fieldvalue VALUES (6,7,11,'seo',2,14); INSERT INTO collection_field_fieldvalue VALUES (6,7,12,'seo',2,13); INSERT INTO collection_field_fieldvalue VALUES (6,7,13,'seo',2,12); INSERT INTO collection_field_fieldvalue VALUES (6,7,14,'seo',2,11); INSERT INTO collection_field_fieldvalue VALUES (6,7,15,'seo',2,10); INSERT INTO collection_field_fieldvalue VALUES (6,7,16,'seo',2,9); INSERT INTO collection_field_fieldvalue VALUES (6,7,17,'seo',2,8); INSERT INTO collection_field_fieldvalue VALUES (6,7,18,'seo',2,7); INSERT INTO collection_field_fieldvalue VALUES (6,7,19,'seo',2,6); INSERT INTO collection_field_fieldvalue VALUES (6,7,20,'seo',2,5); INSERT INTO collection_field_fieldvalue VALUES (6,7,21,'seo',2,4); INSERT INTO collection_field_fieldvalue VALUES (6,7,22,'seo',2,3); INSERT INTO collection_field_fieldvalue VALUES (6,7,23,'seo',2,2); INSERT INTO collection_field_fieldvalue VALUES (6,7,24,'seo',2,1); INSERT INTO collection_field_fieldvalue VALUES (2,7,3,'seo',10,22); INSERT INTO collection_field_fieldvalue VALUES (2,7,2,'seo',10,23); INSERT INTO collection_field_fieldvalue VALUES (6,8,NULL,'sew',2,0); INSERT INTO collection_field_fieldvalue VALUES (2,7,1,'seo',10,24); INSERT INTO collection_field_fieldvalue VALUES (6,4,NULL,'sew',4,70); INSERT INTO collection_field_fieldvalue VALUES (6,2,NULL,'sew',3,70); INSERT INTO collection_field_fieldvalue VALUES (6,19,NULL,'sew',3,65); INSERT INTO collection_field_fieldvalue VALUES (6,5,NULL,'sew',1,70); INSERT INTO collection_field_fieldvalue VALUES (6,11,25,'seo',1,1); INSERT INTO collection_field_fieldvalue VALUES (6,11,26,'seo',1,2); INSERT INTO collection_field_fieldvalue VALUES (8,7,27,'seo',10,3); INSERT INTO collection_field_fieldvalue VALUES (8,7,28,'seo',10,1); INSERT INTO collection_field_fieldvalue VALUES (8,7,29,'seo',10,4); INSERT INTO collection_field_fieldvalue VALUES (8,7,30,'seo',10,2); INSERT INTO collection_field_fieldvalue VALUES (6,3,NULL,'sew',5,70); INSERT INTO collection_field_fieldvalue VALUES (2,7,8,'seo',10,17); INSERT INTO collection_field_fieldvalue VALUES (2,7,9,'seo',10,16); INSERT INTO collection_field_fieldvalue VALUES (2,7,10,'seo',10,15); INSERT INTO collection_field_fieldvalue VALUES (2,7,11,'seo',10,14); INSERT INTO collection_field_fieldvalue VALUES (2,7,12,'seo',10,13); INSERT INTO collection_field_fieldvalue VALUES (2,7,13,'seo',10,12); INSERT INTO collection_field_fieldvalue VALUES (2,7,14,'seo',10,11); INSERT INTO collection_field_fieldvalue VALUES (2,7,15,'seo',10,10); INSERT INTO collection_field_fieldvalue VALUES (2,7,16,'seo',10,9); INSERT INTO collection_field_fieldvalue VALUES (2,7,17,'seo',10,8); INSERT INTO collection_field_fieldvalue VALUES (2,7,18,'seo',10,7); INSERT INTO collection_field_fieldvalue VALUES (2,7,19,'seo',10,6); INSERT INTO collection_field_fieldvalue VALUES (2,7,20,'seo',10,5); INSERT INTO collection_field_fieldvalue VALUES (2,7,21,'seo',10,4); INSERT INTO collection_field_fieldvalue VALUES (2,7,22,'seo',10,3); INSERT INTO collection_field_fieldvalue VALUES (2,7,23,'seo',10,2); INSERT INTO collection_field_fieldvalue VALUES (2,7,24,'seo',10,1); INSERT INTO collection_field_fieldvalue VALUES (2,8,NULL,'sew',20,0); INSERT INTO collection_field_fieldvalue VALUES (2,4,NULL,'sew',40,70); INSERT INTO collection_field_fieldvalue VALUES (2,2,NULL,'sew',60,70); INSERT INTO collection_field_fieldvalue VALUES (2,5,NULL,'sew',30,70); INSERT INTO collection_field_fieldvalue VALUES (2,11,26,'seo',5,1); INSERT INTO collection_field_fieldvalue VALUES (2,3,NULL,'sew',50,70); INSERT INTO collection_field_fieldvalue VALUES (2,11,25,'seo',5,2); INSERT INTO collection_field_fieldvalue VALUES (2,11,32,'seo',5,0); INSERT INTO collection_field_fieldvalue VALUES (3,2,NULL,'sew',10,0); INSERT INTO collection_field_fieldvalue VALUES (3,3,NULL,'sew',20,0); INSERT INTO collection_field_fieldvalue VALUES (3,12,NULL,'sew',30,0); INSERT INTO collection_field_fieldvalue VALUES (4,4,NULL,'sew',30,0); INSERT INTO collection_field_fieldvalue VALUES (4,3,NULL,'sew',40,0); INSERT INTO collection_field_fieldvalue VALUES (4,12,NULL,'sew',10,0); INSERT INTO collection_field_fieldvalue VALUES (4,2,NULL,'sew',50,0); INSERT INTO collection_field_fieldvalue VALUES (4,6,NULL,'sew',20,0); INSERT INTO collection_field_fieldvalue VALUES (4,7,NULL,'seo',10,0); INSERT INTO collection_field_fieldvalue VALUES (4,7,12,'seo',10,2); INSERT INTO collection_field_fieldvalue VALUES (4,7,8,'seo',10,3); INSERT INTO collection_field_fieldvalue VALUES (4,7,10,'seo',10,1); INSERT INTO collection_field_fieldvalue VALUES (5,6,NULL,'sew',20,0); INSERT INTO collection_field_fieldvalue VALUES (5,12,NULL,'sew',10,0); INSERT INTO collection_field_fieldvalue VALUES (5,4,NULL,'sew',30,0); INSERT INTO collection_field_fieldvalue VALUES (5,3,NULL,'sew',40,0); INSERT INTO collection_field_fieldvalue VALUES (5,2,NULL,'sew',50,0); INSERT INTO collection_field_fieldvalue VALUES (5,7,NULL,'seo',10,0); INSERT INTO collection_field_fieldvalue VALUES (5,7,9,'seo',10,3); INSERT INTO collection_field_fieldvalue VALUES (5,7,12,'seo',10,2); INSERT INTO collection_field_fieldvalue VALUES (8,6,NULL,'sew',10,0); INSERT INTO collection_field_fieldvalue VALUES (8,2,NULL,'sew',50,0); INSERT INTO collection_field_fieldvalue VALUES (8,3,NULL,'sew',40,0); INSERT INTO collection_field_fieldvalue VALUES (8,5,NULL,'sew',20,0); INSERT INTO collection_field_fieldvalue VALUES (8,4,NULL,'sew',30,0); INSERT INTO collection_field_fieldvalue VALUES (1,2,NULL,'soo',40,0); INSERT INTO collection_field_fieldvalue VALUES (1,3,NULL,'soo',30,0); INSERT INTO collection_field_fieldvalue VALUES (1,6,NULL,'soo',20,0); INSERT INTO collection_field_fieldvalue VALUES (1,12,NULL,'soo',10,0); INSERT INTO collection_field_fieldvalue VALUES (3,2,NULL,'soo',40,0); INSERT INTO collection_field_fieldvalue VALUES (3,3,NULL,'soo',30,0); INSERT INTO collection_field_fieldvalue VALUES (3,15,NULL,'soo',20,0); INSERT INTO collection_field_fieldvalue VALUES (3,12,NULL,'soo',10,0); INSERT INTO collection_format VALUES (6,1,100); INSERT INTO collection_format VALUES (6,2,90); INSERT INTO collection_format VALUES (6,3,80); INSERT INTO collection_format VALUES (6,4,70); INSERT INTO collection_format VALUES (6,5,60); INSERT INTO collection_format VALUES (2,1,100); INSERT INTO collection_format VALUES (2,2,90); INSERT INTO collection_format VALUES (2,3,80); INSERT INTO collection_format VALUES (2,4,70); INSERT INTO collection_format VALUES (2,5,60); INSERT INTO collection_format VALUES (3,1,100); INSERT INTO collection_format VALUES (3,2,90); INSERT INTO collection_format VALUES (3,3,80); INSERT INTO collection_format VALUES (3,4,70); INSERT INTO collection_format VALUES (3,5,60); INSERT INTO collection_format VALUES (4,1,100); INSERT INTO collection_format VALUES (4,2,90); INSERT INTO collection_format VALUES (4,3,80); INSERT INTO collection_format VALUES (4,4,70); INSERT INTO collection_format VALUES (4,5,60); INSERT INTO collection_format VALUES (5,1,100); INSERT INTO collection_format VALUES (5,2,90); INSERT INTO collection_format VALUES (5,3,80); INSERT INTO collection_format VALUES (5,4,70); INSERT INTO collection_format VALUES (5,5,60); INSERT INTO collection_format VALUES (8,1,100); INSERT INTO collection_format VALUES (8,2,90); INSERT INTO collection_format VALUES (8,3,80); INSERT INTO collection_format VALUES (8,4,70); INSERT INTO collection_format VALUES (8,5,60); INSERT INTO collection_format VALUES (8,6,96); INSERT INTO collection_format VALUES (8,7,93); INSERT INTO collection_format VALUES (1,1,100); INSERT INTO collection_format VALUES (1,2,90); INSERT INTO collection_format VALUES (1,3,80); INSERT INTO collection_format VALUES (1,4,70); INSERT INTO collection_format VALUES (1,5,60); INSERT INTO collection_format VALUES (15,1,100); INSERT INTO collection_format VALUES (15,2,90); INSERT INTO collection_format VALUES (15,18,85); INSERT INTO collection_format VALUES (15,3,80); INSERT INTO collection_format VALUES (15,4,70); INSERT INTO collection_format VALUES (15,5,60); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,1,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,2,'en','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (6,3,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (6,49,'en','rt',95); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (6,4,'en','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (2,5,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (2,45,'en','rt',95); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (2,6,'en','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (3,7,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (3,46,'en','rt',95); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (3,8,'en','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (4,9,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (4,47,'en','rt',95); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (4,10,'en','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (5,11,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (5,48,'en','rt',95); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (8,14,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (8,50,'en','rt',95); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (9,15,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (10,16,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (11,17,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (12,18,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (13,19,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (14,20,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (15,21,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (15,51,'en','rt',95); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (16,22,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (16,52,'en','rt',95); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (17,23,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (17,53,'en','rt',95); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (18,24,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,25,'fr','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,26,'fr','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,27,'sk','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,28,'sk','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,29,'cs','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,30,'cs','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,31,'de','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,32,'de','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,33,'es','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,34,'es','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,35,'it','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,36,'it','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,37,'no','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,38,'no','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,39,'pt','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,40,'pt','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,41,'ru','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,42,'ru','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,43,'sv','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,44,'sv','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,54,'el','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,55,'el','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,56,'uk','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,57,'uk','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,58,'ca','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,59,'ca','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,60,'ja','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,61,'ja','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,62,'pl','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,63,'pl','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,64,'bg','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,65,'bg','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,66,'hr','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,67,'hr','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,68,'zh_CN','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,69,'zh_CN','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,70,'zh_TW','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,71,'zh_TW','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,72,'hu','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,73,'hu','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,74,'af','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,75,'af','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,76,'gl','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,77,'gl','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (19,78,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (20,78,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (21,78,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (22,78,'en','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,79,'ro','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,80,'ro','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,81,'rw','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,82,'rw','rt',90); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,83,'ka','rt',100); INSERT INTO collection_portalbox (id_collection,id_portalbox,ln,position,score) VALUES (1,84,'ka','rt',90); INSERT INTO example VALUES (1,'author search','author:"Ellis, J"'); INSERT INTO example VALUES (2,'word search','quantum'); INSERT INTO example VALUES (3,'wildcard word search','quant*'); INSERT INTO example VALUES (4,'phrase search','title:\'standard model\''); INSERT INTO example VALUES (5,'boolean search','quark -sigma +dense'); INSERT INTO example VALUES (6,'complex boolean search','author:draper title:electrical'); INSERT INTO example VALUES (7,'complex boolean search','author:ellis -muon* +abstract:\'dense quark matter\''); INSERT INTO example VALUES (8,'boolean search','ellis muon*'); INSERT INTO example VALUES (13,'reference search','references:"Theor. Math. Phys. 2 (1998) 231"'); INSERT INTO example VALUES (14,'phrase search','abstract:\'Higgs boson\''); INSERT INTO example VALUES (15,'wildcard word search','cal*'); INSERT INTO example VALUES (16,'keyword search','keyword:Nobel'); INSERT INTO example VALUES (17,'author search','author:Cole'); INSERT INTO example VALUES (18,'phrase search','title:\'nuclear electronics\''); INSERT INTO example VALUES (19,'combined search','supergravity and author:"Ellis, J" and year:1980->1990'); INSERT INTO fieldvalue VALUES (1,'Particle Physics','Particle Physics'); INSERT INTO fieldvalue VALUES (2,'Particle Physics - Experimental Results','Particle Physics - Experimental Results'); INSERT INTO fieldvalue VALUES (3,'Particle Physics - Phenomenology','Particle Physics - Phenomenology'); INSERT INTO fieldvalue VALUES (4,'Particle Physics - Theory','Particle Physics - Theory'); INSERT INTO fieldvalue VALUES (5,'Particle Physics - Lattice','Particle Physics - Lattice'); INSERT INTO fieldvalue VALUES (6,'Nuclear Physics','Nuclear Physics'); INSERT INTO fieldvalue VALUES (7,'General Relativity and Cosmology','General Relativity and Cosmology'); INSERT INTO fieldvalue VALUES (8,'General Theoretical Physics','General Theoretical Physics'); INSERT INTO fieldvalue VALUES (9,'Detectors and Experimental Techniques','Detectors and Experimental Techniques'); INSERT INTO fieldvalue VALUES (10,'Accelerators and Storage Rings','Accelerators and Storage Rings'); INSERT INTO fieldvalue VALUES (11,'Health Physics and Radiation Effects','Health Physics and Radiation Effects'); INSERT INTO fieldvalue VALUES (12,'Computing and Computers','Computing and Computers'); INSERT INTO fieldvalue VALUES (13,'Mathematical Physics and Mathematics','Mathematical Physics and Mathematics'); INSERT INTO fieldvalue VALUES (14,'Astrophysics and Astronomy','Astrophysics and Astronomy'); INSERT INTO fieldvalue VALUES (15,'Nonlinear Systems','Nonlinear Systems'); INSERT INTO fieldvalue VALUES (16,'Condensed Matter','Condensed Matter'); INSERT INTO fieldvalue VALUES (17,'Other Fields of Physics','Other Fields of Physics'); INSERT INTO fieldvalue VALUES (18,'Chemical Physics and Chemistry','Chemical Physics and Chemistry'); INSERT INTO fieldvalue VALUES (19,'Engineering','Engineering'); INSERT INTO fieldvalue VALUES (20,'Information Transfer and Management','Information Transfer and Management'); INSERT INTO fieldvalue VALUES (21,'Other Aspects of Science','Other Aspects of Science'); INSERT INTO fieldvalue VALUES (22,'Commerce, Economics, Social Science','Commerce, Economics, Social Science'); INSERT INTO fieldvalue VALUES (23,'Biography, Geography, History','Biography, Geography, History'); INSERT INTO fieldvalue VALUES (24,'Other Subjects','Other Subjects'); INSERT INTO fieldvalue VALUES (25,'CERN TH','TH'); INSERT INTO fieldvalue VALUES (26,'CERN PPE','PPE'); INSERT INTO fieldvalue VALUES (27,'Experiments and Tracks','Experiments and Tracks'); INSERT INTO fieldvalue VALUES (28,'Personalities and History of CERN','Personalities and History of CERN'); INSERT INTO fieldvalue VALUES (29,'Diagrams and Charts','Diagrams and Charts'); INSERT INTO fieldvalue VALUES (30,'Life at CERN','Life at CERN'); INSERT INTO fieldvalue VALUES (31,'CERN ETT','ETT'); INSERT INTO fieldvalue VALUES (32,'CERN EP','EP'); INSERT INTO oaiREPOSITORY VALUES (2,'CERN experimental papers','cern:experiment','','','c=;p1=CERN;f1=reportnumber;m1=a;p2=(EP|PPE);f2=division;m2=r;p3=;f3=;m3=;',NULL,'CERN','reportnumber','a','(EP|PPE)','division','r','','',''); INSERT INTO oaiREPOSITORY VALUES (3,'CERN theoretical papers','cern:theory','','','c=;p1=CERN;f1=reportnumber;m1=a;p2=TH;f2=division;m2=e;p3=;f3=;m3=;',NULL,'CERN','reportnumber','a','TH','division','e','','',''); INSERT INTO portalbox VALUES (1,'ABOUT THIS SITE','Welcome to the demo site of the Invenio, a free document server software coming from CERN. Please feel free to explore all the features of this demo site to the full.'); INSERT INTO portalbox VALUES (2,'SEE ALSO','Invenio
CERN'); INSERT INTO portalbox VALUES (3,'ABOUT ARTICLES','The Articles collection contains all the papers published in scientific journals by our staff. The collection starts from 1998.'); INSERT INTO portalbox VALUES (4,'SEE ALSO','arXiv.org
CDS
ChemWeb
MathSciNet'); INSERT INTO portalbox VALUES (5,'ABOUT PREPRINTS','The Preprints collection contains not-yet-published papers and research results obtained at the institute. The collection starts from 2001.'); INSERT INTO portalbox VALUES (6,'SEE ALSO','arXiv.org
CDS'); INSERT INTO portalbox VALUES (7,'ABOUT BOOKS','The Books collection contains monographs published by institute staff as well as pointers to interesting online e-books available in fulltext.'); INSERT INTO portalbox VALUES (8,'SEE ALSO','UV e-Books
Project Gutenberg'); INSERT INTO portalbox VALUES (9,'ABOUT THESES','The Theses collection contains all students\' theses defended at the institute. The collection starts from 1950.'); INSERT INTO portalbox VALUES (10,'SEE ALSO','NDLTD Theses
Thesis.DE'); INSERT INTO portalbox VALUES (11,'ABOUT REPORTS','The Reports collection contains miscellaneous technical reports, unpublished elsewhere. The collection starts from 1950.'); INSERT INTO portalbox VALUES (12,'TEST portal box','this is a test portal box'); INSERT INTO portalbox VALUES (13,'test','this is a test portal box'); INSERT INTO portalbox VALUES (14,'ABOUT PICTURES','The Pictures collection contains selected photographs and illustrations. Please note that photographs are copyrighted. The collection includes historical archive that starts from 1950.'); INSERT INTO portalbox VALUES (15,'ABOUT CERN DIVISIONS','These virtual collections present a specific point of view on the database content from CERN Divisions persective.'); INSERT INTO portalbox VALUES (16,'ABOUT CERN EXPERIMENTS','These virtual collections present a specific point of view on the database content from CERN Experiments persective.'); INSERT INTO portalbox VALUES (17,'ABOUT TH','This virtual collection groups together all the documents written by authors from CERN TH Division.'); INSERT INTO portalbox VALUES (18,'ABOUT EP','This virtual collection groups together all the documents written by authors from CERN EP Division.'); INSERT INTO portalbox VALUES (19,'ABOUT ISOLDE','This virtual collection groups together all the documents about ISOLDE CERN experiment.'); INSERT INTO portalbox VALUES (20,'ABOUT ALEPH','This virtual collection groups together all the documents about ALEPH CERN experiment.'); INSERT INTO portalbox VALUES (21,'ABOUT ARTICLES AND PREPRINTS','This collection groups together all published and non-published articles, many of which in electronic fulltext form.'); INSERT INTO portalbox VALUES (22,'ABOUT BOOKS AND REPORTS','This collection groups together all monograph-like publications, be they books, theses, reports, book chapters, proceedings, and so on.'); INSERT INTO portalbox VALUES (23,'ABOUT MULTIMEDIA & OUTREACH','This collection groups together all multimedia- and outreach- oriented material.'); INSERT INTO portalbox VALUES (24,'ABOUT POETRY','This collection presents poetry excerpts, mainly to demonstrate and test the treatment of various languages.

Vitrum edere possum; mihi non nocet.
Μπορώ να φάω σπασμένα γυαλιά χωρίς να πάθω τίποτα.
Pòdi manjar de veire, me nafrariá pas.
Ég get etið gler án þess að meiða mig.
Ic mæg glæs eotan ond hit ne hearmiað me.
ᛁᚳ᛫ᛗᚨᚷ᛫ᚷᛚᚨᛋ᛫ᛖᚩᛏᚪᚾ᛫ᚩᚾᛞ᛫ᚻᛁᛏ᛫ᚾᛖ᛫ᚻᛖᚪᚱᛗᛁᚪᚧ᛫ᛗᛖ᛬
⠊⠀⠉⠁⠝⠀⠑⠁⠞⠀⠛⠇⠁⠎⠎⠀⠁⠝⠙⠀⠊⠞⠀⠙⠕⠑⠎⠝⠞⠀⠓⠥⠗⠞⠀⠍⠑
Pot să mănânc sticlă și ea nu mă rănește.
Meg tudom enni az üveget, nem lesz tőle bajom.
Môžem jesť sklo. Nezraní ma.
אני יכול לאכול זכוכית וזה לא מזיק לי.
איך קען עסן גלאָז און עס טוט מיר נישט װײ.
أنا قادر على أكل الزجاج و هذا لا يؤلمني.
Я могу есть стекло, оно мне не вредит.
მინას ვჭამ და არა მტკივა.
Կրնամ ապակի ուտել և ինծի անհանգիստ չըներ։
मैं काँच खा सकता हूँ, मुझे उस से कोई पीडा नहीं होती.
काचं शक्नोम्यत्तुम् । नोपहिनस्ति माम् ॥
ฉันกินกระจกได้ แต่มันไม่ทำให้ฉันเจ็บ
Tôi có thể ăn thủy tinh mà không hại gì.
我能吞下玻璃而不伤身体。
私はガラスを食べられます。それは私を傷つけません。
나는 유리를 먹을 수 있어요. 그래도 아프지 않아요
(http://www.columbia.edu/kermit/utf8.html)'); INSERT INTO portalbox VALUES (25,'À PROPOS DE CE SITE','Bienvenue sur le site de démonstration de Invenio, un logiciel libre pour des serveurs des documents, venant du CERN. Veuillez explorer les possibilités de ce site de démonstration de tous ses côtés.'); INSERT INTO portalbox VALUES (26,'VOIR AUSSI','Invenio
CERN'); INSERT INTO portalbox VALUES (27,'O TÝCHTO STRÁNKACH','Vitajte na demonštračných stránkach Invenio, voľne dostupného softwaru pre dokumentové servery, pochádzajúceho z CERNu. Prehliadnite si možnosti našeho demonštračného serveru podla ľubovôle.'); INSERT INTO portalbox VALUES (28,'VIĎ TIEŽ','Invenio
CERN'); INSERT INTO portalbox VALUES (29,'O TĚCHTO STRÁNKÁCH','Vítejte na demonstračních stránkách Invenio, volně dostupného softwaru pro dokumentové servery, pocházejícího z CERNu. Prohlédněte si možnosti našeho demonstračního serveru podle libosti.'); INSERT INTO portalbox VALUES (30,'VIZ TÉŽ','Invenio
CERN'); INSERT INTO portalbox VALUES (31,'ÜBER DIESEN SEITEN','Willkommen Sie bei der Demo-Seite des Invenio, des Dokument Management Systems Software aus CERN. Hier können Sie den System gleich und frei ausprobieren.'); INSERT INTO portalbox VALUES (32,'SEHEN SIE AUCH','Invenio
CERN'); INSERT INTO portalbox VALUES (33,'ACERCA DE ESTAS PÁGINAS','Bienvenidos a las páginas de demostración de Invenio, un software gratuito desarrollado por el CERN que permite crear un servidor de documentos. Le invitamos a explorar a fondo todas las funcionalidades ofrecidas por estas páginas de demostración.'); INSERT INTO portalbox VALUES (34,'VEA TAMBIÉN','Invenio
CERN'); INSERT INTO portalbox VALUES (35,'A PROPOSITO DI QUESTO SITO','Benvenuti nel sito demo di Invenio, un software libero per server di documenti sviluppato al CERN. Vi invitiamo ad esplorare a fondo tutte le caratteristiche di questo sito demo.'); INSERT INTO portalbox VALUES (36,'VEDI ANCHE','Invenio
CERN'); INSERT INTO portalbox VALUES (37,'OM DENNE SIDEN','Velkommen til demosiden for Invenio, en gratis dokumentserver fra CERN. Vennligst føl deg fri til å utforske alle mulighetene i denne demoen til det fulle.'); INSERT INTO portalbox VALUES (38,'SE OGSÅ','Invenio
CERN'); INSERT INTO portalbox VALUES (39,'SOBRE ESTE SITE','Bem vindo ao site de demonstração do Invenio, um servidor de documentos livre desenvolvido pelo CERN. Sinta-se à vontade para explorar plenamente todos os recursos deste site demonstração.'); INSERT INTO portalbox VALUES (40,'VEJA TAMBÉM','Invenio
CERN'); INSERT INTO portalbox VALUES (41,'ОБ ЭТОМ САЙТЕ','Добро пожаловать на наш демонстрационный сайт Invenio. Invenio -- свободная программа для серверов документов, разработанная в CERNе. Пожалуйста пользуйтесь свободно этим сайтом.'); INSERT INTO portalbox VALUES (42,'СМОТРИТЕ ТАКЖЕ','Invenio
CERN'); INSERT INTO portalbox VALUES (43,'OM DENNA WEBBPLATS','Välkommen till demoinstallationen av Invenio, en fri programvara för hantering av dokument, från CERN. Välkommen att undersöka alla funktioner i denna installation.'); INSERT INTO portalbox VALUES (44,'SE ÄVEN','Invenio
CERN'); INSERT INTO portalbox VALUES (45,'SUBMIT PREPRINT','Submit a new preprint'); INSERT INTO portalbox VALUES (46,'SUBMIT BOOK','Submit a new book'); INSERT INTO portalbox VALUES (47,'SUBMIT THESIS','Submit a new thesis'); INSERT INTO portalbox VALUES (48,'SUBMIT REPORT','Submit a new report'); INSERT INTO portalbox VALUES (49,'SUBMIT ARTICLE','Submit a new article'); INSERT INTO portalbox VALUES (50,'SUBMIT PICTURE','Submit a new picture'); INSERT INTO portalbox VALUES (51,'SUBMIT NEW DOCUMENT','Submit a new article
Submit a new preprint'); INSERT INTO portalbox VALUES (52,'SUBMIT NEW DOCUMENT','Submit a new book
Submit a new thesis
Submit a new report'); INSERT INTO portalbox VALUES (53,'SUBMIT NEW DOCUMENT','Submit a new picture'); INSERT INTO portalbox VALUES (54,'ΣΧΕΤΙΚΑ ΜΕ ΤΗΝ ΣΕΛΙΔΑ','Καλως ήλθατε στον δικτυακό τόπο του Invenio, ενός δωρεάν εξυπηρετητή για έγγραφα προερχόμενο απο το CERN. Είστε ευπρόσδεκτοι να εξερευνήσετε σε βάθος τις δυνατότητες που σας παρέχει ο δικτυακός αυτός τόπος.'); INSERT INTO portalbox VALUES (55,'ΔΕΙΤΕ ΕΠΙΣΗΣ','Invenio
CERN'); INSERT INTO portalbox VALUES (56,'ПРО ЦЕЙ САЙТ','Ласкаво просимо до демонстраційного сайту Invenio, вільного програмного забезпечення, розробленого CERN. Випробуйте всі можливості цього демонстраційного сайту в повному обсязі.'); INSERT INTO portalbox VALUES (57,'ДИВИСЬ ТАКОЖ','Invenio
CERN'); INSERT INTO portalbox VALUES (58,'SOBRE AQUEST LLOC','Benvinguts al lloc de demo de Invenio, un servidor de documents lliure originat al CERN. Us convidem a explorar a fons totes les funcionalitats ofertes en aquestes pàgines de demostració.'); INSERT INTO portalbox VALUES (59,'VEGEU TAMBÉ','Invenio
CERN'); INSERT INTO portalbox VALUES (60,'この場所について','Invenioデモンストレーションの場所への歓迎, CERN から来る自由な文書のサーバーソフトウェア, このデモンストレーションの場所の特徴すべてを探検する自由の感じ'); INSERT INTO portalbox VALUES (61,'また見なさい','Invenio
CERN'); INSERT INTO portalbox VALUES (62,'O TEJ STRONIE','Witamy w wersji demo systemu Invenio, darmowego oprogramowania do obsługi serwera dokumentów, stworzonego w CERN. Zachęcamy do odkrywania wszelkich funkcjonalności oferowanych przez tę stronę.'); INSERT INTO portalbox VALUES (63,'ZOBACZ TAKŻE','Invenio
CERN'); INSERT INTO portalbox VALUES (64,'ЗА САЙТА','Добре дошли на демонстрационния сайт на Invenio, свободен софтуер за документни сървъри изработен в ЦЕРН. Чувствайте се свободни да изследвате всяка една от характеристиките на сайта.'); INSERT INTO portalbox VALUES (65,'ВИЖ СЪЩО','Invenio
CERN'); INSERT INTO portalbox VALUES (66,'O OVOM SITE-u','Dobrodošli na Invenio demo site. Invenio je slobodno dostupan poslužitelj dokumenata razvijen na CERN-u. Slobodno istražite sve mogućnosti ove aplikacije.'); INSERT INTO portalbox VALUES (67,'TAKOĐER POGLEDAJTE','Invenio
CERN'); INSERT INTO portalbox VALUES (68,'关于这个网站','欢迎来到Invenio 的示范网站！Invenio是一个由CERN开发的免费文件服务器软件。 要了解这网站所提供的各项特点, 请立刻行动，尽情探索。'); INSERT INTO portalbox VALUES (69,'参见','Invenio
CERN'); INSERT INTO portalbox VALUES (70,'關於這個網站', '歡迎來到Invenio 的示範網站！Invenio是一個由CERN開發的免費文件伺服器軟體。 要瞭解這網站所提供的各項特點, 請立刻行動，盡情探索。'); INSERT INTO portalbox VALUES (71,'參見','Invenio
CERN'); INSERT INTO portalbox VALUES (72,'IMPRESSZUM', 'Üdvözöljük a Invenio bemutatóoldalain! Ezt a szabad dokumentumkezelő szoftvert a CERN-ben fejlesztették. Fedezze fel bátran a tesztrendszer nyújtotta szolgáltatásokat!'); INSERT INTO portalbox VALUES (73,'LÁSD MÉG','Invenio
CERN'); INSERT INTO portalbox VALUES (74,'OMTRENT HIERDIE TUISTE', 'Welkom by die demo tuiste van Invenio, gratis dokument bediener sagteware wat deur CERN geskryf is. Voel vry om al die eienskappe van die demo te deursoek.'); INSERT INTO portalbox VALUES (75,'SIEN OOK','Invenio
CERN'); INSERT INTO portalbox VALUES (76,'ACERCA DESTE SITIO', 'Benvido ó sitio de demostración do Invenio, un software de servidor de documentos do CERN. Por favor síntete libre de explorar todas as características deste sitio de demostración.'); INSERT INTO portalbox VALUES (77,'VEXA TAMÉN','Invenio
CERN'); INSERT INTO portalbox VALUES (78,'ABOUT ATLANTIS TIMES','The \"Atlantis Times\" collections contain the articles from the \Atlantis Times journal.'); INSERT INTO portalbox VALUES (79,'DESPRE ACEST SITE', 'Bine aţi venit pe site-ul demo al Invenio, un software gratuit pentru servere de documente, creat de CERN. Nu ezitaţi să exploraţi din plin toate caracteristicile acestui site demo.'); INSERT INTO portalbox VALUES (80,'ALTE RESURSE','Invenio
CERN'); INSERT INTO portalbox VALUES (81,'IBYEREKERANYE N\'IYI WEB', 'Murakzaneza kuri web ya Invenio, iyi ni koranabuhanga y\'ubuntu ya kozwe na CERN. Bitimuntu afite uburenganzira bwo kuyigerageza no kuyikoresha.'); INSERT INTO portalbox VALUES (82,'REBA N\'IBI','Invenio
CERN'); -- ' INSERT INTO portalbox VALUES (83,'საიტის შესახებ', 'კეთილი იყოს თქვენი მობრძანება Invenio -ის სადემონსტრაციო საიტზე, თავისუფალი დოკუმენტების სერვერი CERN -ისაგან. გთხოვთ სრულად შეისწავლოთ სადემონსტრაციო საიტის შესაძლებლობები.'); INSERT INTO portalbox VALUES (84,'ასევე იხილეთ','Invenio
CERN'); -- ' INSERT INTO sbmCOLLECTION VALUES (36,'Document Types'); INSERT INTO sbmCOLLECTION_sbmCOLLECTION VALUES (0,36,1); INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'DEMOTHE',1); INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'DEMOPOE',2); INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'DEMOPIC',3); INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'DEMOART',4); INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'DEMOBOO',5); INSERT INTO sbmCOLLECTION_sbmDOCTYPE VALUES (36,'DEMOJRN',6); INSERT INTO sbmCATEGORIES (doctype,sname,lname,score) VALUES ('DEMOPIC','LIFE','Life at CERN',3); INSERT INTO sbmCATEGORIES (doctype,sname,lname,score) VALUES ('DEMOPIC','HIST','Personalities and History of CERN',2); INSERT INTO sbmCATEGORIES (doctype,sname,lname,score) VALUES ('DEMOPIC','EXP','Experiments',1); INSERT INTO sbmCATEGORIES (doctype,sname,lname,score) VALUES ('DEMOART','ARTICLE','Article',1); INSERT INTO sbmCATEGORIES (doctype,sname,lname,score) VALUES ('DEMOART','PREPRINT','Preprint',2); INSERT INTO sbmCATEGORIES (doctype,sname,lname,score) VALUES ('DEMOART','REPORT','Report',3); INSERT INTO sbmCATEGORIES (doctype,sname,lname,score) VALUES ('DEMOJRN','NEWS','News',2); INSERT INTO sbmCATEGORIES (doctype,sname,lname,score) VALUES ('DEMOJRN','ARTS','Arts',1); INSERT INTO sbmCATEGORIES (doctype,sname,lname,score) VALUES ('DEMOJRN','SCIENCE','Science',4); INSERT INTO sbmDOCTYPE VALUES ('Demo Picture Submission','DEMOPIC','2007-09-13','2007-10-17','

\r\nThe Demo Picture submission demonstrates a slightly more detailed submission type.
\r\nIt makes use of different categories (which in this case are used in the picture\'s reference number to better describe it) and creates icons for the submitted picture files. Records created with this submission are inserted into the ATLANTIS \"Pictures\" collection.\r\n

\r\n'); INSERT INTO sbmDOCTYPE VALUES ('Demo Thesis Submission','DEMOTHE','2008-03-02','2008-03-05','
\r\n
\r\nThe Demo Thesis submission demonstrates a very simple submission type.
\r\nIt has no categories, submits directly into the ATLANTIS \"Theses\" collection and also stamps full-text files.\r\n

\r\n'); INSERT INTO sbmDOCTYPE VALUES ('Demo Article Submission','DEMOART','2008-03-06','2008-03-06','

The Demo Article submission demonstrates a more complex submission type.

\r\nThe submission gives a document a category. This category is used in the document\'s reference number and also serves as a means to classify it into a specific ATLANTIS collection. Documents submitted into the \"Article\" category are inserted into the ATLANTIS \"Articles\" collection, documents categorized as \"Preprint\" are inserted into the ATLANTIS \"Preprints\" collection, and a document categorized as a \"Report\" is inserted into the ATLANTIS \"Reports\" collection.

\r\n'); INSERT INTO sbmDOCTYPE VALUES ('Demo Book Submission (Refereed)','DEMOBOO','2008-03-06','2008-03-06','

The Demo Book submission demonstrates a refereed submission.

\r\nWhen the details of a book are submitted by a user, they must be approved by a referee before the record is integrated into the ATLANTIS repository.
\r\nApproved books are integrated into the ATLANTIS \"Books\" collection.
\r\n'); INSERT INTO sbmDOCTYPE VALUES ('Demo Poetry Submission','DEMOPOE','2008-03-12','2008-03-12','

\r\nThe Demo Poetry submission demonstrates a simple submission type with a submission form split over two pages.
\r\nIt does not use categories. Records created with this submission are inserted into the ATLANTIS \"Poetry\" collection.\r\n

'); INSERT INTO sbmDOCTYPE VALUES ('Demo Journal Submission','DEMOJRN','2008-09-18','2008-09-18','The Demo Journal submission submits records that will be integrated into the demo "Atlantis Times" journal.
\r\n Makes use of FCKeditor to provide WYSIWYG HTML edition of the articles. Install it with make install-fckeditor-plugin.'); INSERT INTO sbmFIELD VALUES ('SBIDEMOPIC',1,1,'DEMOPIC_TITLE','

Submit an ATLANTIS picture:

*Picture Title:
','M','Picture Title','','2007-09-13','2007-10-04',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPIC',1,2,'DEMOPIC_PHOTOG','

Picture Author(s) or Photographers(s): (one per line)
','O','Photographer(s)','','2007-09-13','2007-09-13',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPIC',1,3,'DEMOPIC_DATE','

*Picture Date: (dd/mm/yyyy) ','M','Picture Date','DatCheckNew','2007-09-13','2007-10-04',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPIC',1,4,'DEMOPIC_KW','

Keywords:
(one keyword/key-phrase per line)
','O','Picture Keywords','','2007-09-13','2007-09-13',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPIC',1,5,'DEMOPIC_DESCR','

Picture Description:
','O','Picture Description','','2007-09-13','2007-09-13',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPIC',1,6,'DEMOPIC_ADD_RN','

Your picture will be given a reference number automatically.
However, if the picture has other reference numbers, please enter them here:
(one per line)
','O','Additional Reference Numbers','','2007-09-13','2007-09-13',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPIC',1,7,'DEMOPIC_NOTE','

Additional Comments or Notes about the Picture:
','O','Picture Notes or Comments','','2007-09-13','2007-09-13',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPIC',1,8,'Upload_Photos','

Select the photo(s) to upload:
','O','Picture File','','2007-09-13','2007-09-13',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPIC',1,9,'DEMOPIC_FINISH','

','O','','','2007-09-13','2007-09-13',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOPIC',1,1,'DEMOPIC_RN','

Modify a picture\'s bibliographic information:

*Picture Reference Number:  ','M','Reference Number','','2007-10-04','2007-10-04',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOPIC',1,2,'DEMOPIC_CHANGE','

*Choose the fields to be modified:
','M','Fields to Modify','','2007-10-04','2007-10-04',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOPIC',1,3,'DEMOPIC_CONT','

','O','','','2007-10-04','2007-10-04',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SRVDEMOPIC',1,1,'DEMOPIC_RN','

Revise/add pictures:

*Picture Reference Number:  ','M','Reference Number','','2009-04-09','2009-04-09',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SRVDEMOPIC',1,2,'DEMOPIC_CONT','

','O','','','2009-04-09','2009-04-09',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,1,'DEMOTHE_REP','

Submit an ATLANTIS Thesis:

Your thesis will be given a reference number automatically.
However, if it has other reference numbers, please enter them here:
(one per line)
','O','Other Report Numbers','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,2,'DEMOTHE_TITLE','

*Thesis Title:
','M','Title','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,3,'DEMOTHE_SUBTTL','

Thesis Subtitle (if any):
','O','Subtitle','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,4,'DEMOTHE_AU','

*Author of the Thesis: (one per line)
','M','Author(s)','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,5,'DEMOTHE_SUPERV','

Thesis Supervisor(s): (one per line)
','O','Thesis Supervisor(s)','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,6,'DEMOTHE_ABS','

*Abstract:
','M','Abstract','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,7,'DEMOTHE_NUMP','

Number of Pages: ','O','Number of Pages','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,8,'DEMOTHE_LANG','

*Language: ','M','Thesis Language','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,9,'DEMOTHE_PUBL','

*Thesis Publisher (or Institute): ','M','Thesis Publisher/University','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,10,'DEMOTHE_PLDEF',' at *Place/Town: ','M','Place of Thesis Defence','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,11,'DEMOTHE_DIPL','

*Diploma Awarded: ','M','Diploma Awarded','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,12,'DEMOTHE_DATE','

*Thesis Defence date (dd/mm/yyyy): ','M','Date of Thesis Defence','DatCheckNew','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,13,'DEMOTHE_UNIV','
*Awarding University: ','M','Awarding University','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,14,'DEMOTHE_PLACE',' at *Place/Town: ','M','Awarding University town','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,15,'DEMOTHE_FILE','

*Enter the full path to the source file to upload:
','M','Source File','','2008-03-02','2008-03-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOTHE',1,16,'DEMOTHE_END','


','O','','','2008-03-02','2008-03-02',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOTHE',1,1,'DEMOTHE_RN','

Modify a thesis\' bibliographic information:

*Thesis Reference Number:  ','M','Reference Number','','2008-03-05','2008-03-05',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOTHE',1,2,'DEMOTHE_CHANGE','

*Choose the fields to be modified:
','M','Fields to Modify','','2008-03-05','2008-03-05',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOTHE',1,3,'DEMOTHE_CONT','

','O','','','2008-03-05','2008-03-05',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,1,'DEMOART_REP','

Submit an ATLANTIS Article:

Your document will be given a reference number automatically.
However, if it has other reference numbers, please enter them here:
(one per line)
','O','Other Report Numbers','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,2,'DEMOART_TITLE','

*Document Title:
','M','Title','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,3,'DEMOART_AU','

*Author of the Document: (one per line)
','M','Author(s)','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,4,'DEMOART_ABS','

*Abstract:
','M','Abstract','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,5,'DEMOART_NUMP','

Number of Pages: ','O','Number of Pages','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,6,'DEMOART_LANG','

*Language: ','O','Language','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,7,'DEMOART_DATE','

*Date of Document: (dd/mm/yyyy) ','M','Date of Document','DatCheckNew','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,8,'DEMOART_KW','

Keywords/Key-phrases: (one per line)
','O','Keywords/Key-phrases','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,9,'DEMOART_NOTE','

Additional Notes or Comments:
','O','Notes/Comments','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,10,'DEMOART_FILE','

*Enter the full path to the source file to upload:
','M','Source File','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOART',1,11,'DEMOART_END','


','O','','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOART',1,1,'DEMOART_RN','

Modify an article\'s bibliographic information:

*Document Reference Number:  ','M','Reference Number','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOART',1,2,'DEMOART_CHANGE','

*Choose the fields to be modified:
','M','Fields to Modify','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOART',1,3,'DEMOART_CONT','

','O','','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,1,'DEMOBOO_REP','

Submit an ATLANTIS Book:

Your book will be given a reference number automatically.
However, if it has other reference numbers, please enter them here:
(one per line)
','O','Other Report Numbers','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,2,'DEMOBOO_TITLE','

*Book Title:
','M','Title','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,3,'DEMOBOO_AU','

*Author of the Book: (one per line)
','M','Author(s)','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,4,'DEMOBOO_ABS','

*Abstract:
','M','Abstract','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,5,'DEMOBOO_NUMP','

Number of Pages: ','O','Number of Pages','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,6,'DEMOBOO_LANG','

*Language: ','O','Language','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,7,'DEMOBOO_DATE','

*Date of the Book: (dd/mm/yyyy) ','M','Date of Document','DatCheckNew','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,8,'DEMOBOO_KW','

Keywords/Key-phrases: (one per line)
','O','Keywords/Key-phrases','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,9,'DEMOBOO_NOTE','

Additional Notes or Comments:
','O','Notes/Comments','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,10,'DEMOBOO_FILE','

Enter the full path to the source file to upload:
','O','Source File','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOBOO',1,11,'DEMOBOO_END','


','O','','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOBOO',1,1,'DEMOBOO_RN','

Modify a book\'s bibliographic information:

*Book Reference Number:  ','M','Reference Number','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOBOO',1,2,'DEMOBOO_CHANGE','

*Choose the fields to be modified:
','M','Fields to Modify','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOBOO',1,3,'DEMOBOO_CONT','

','O','','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('APPDEMOBOO',1,1,'DEMOBOO_RN','

Approve or reject an ATLANTIS book:

*Book Reference Number:  ','M','Reference Number','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('APPDEMOBOO',1,2,'DEMOBOO_DECSN','

*Decision:
\r\n','M','Decision','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('APPDEMOBOO',1,3,'DEMOBOO_COMNT','

Comments on Decision:
\r\n','O','Referee\'s Comments','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('APPDEMOBOO',1,4,'DEMOBOO_REGB','

','O','','','2008-03-07','2008-03-07',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPOE',1,1,'DEMOPOE_TITLE','

Submit an ATLANTIS Poem:

*Poem Title:
','M','>Title','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPOE',1,2,'DEMOPOE_AU','

*Author(s) of the Poem: (one per line)
','M','Author(s)','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPOE',1,3,'DEMOPOE_LANG','

*Poem Language: ','M','Language','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPOE',1,4,'DEMOPOE_YEAR','*Year of the Poem: ','M','Poem Year','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPOE',1,5,'DEMOPOE_DUMMY','','O','','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPOE',2,1,'DEMOPOE_ABS','


*Poem Text:
','M','Abstract','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOPOE',2,2,'DEMOPOE_END','


','O','','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOPOE',1,1,'DEMOPOE_RN','

Modify a poem\'s bibliographic information:

*Poem Reference Number:  ','M','Reference Number','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOPOE',1,2,'DEMOPOE_CHANGE','

*Choose the fields to be modified:
','M','Fields to Modify','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOPOE',1,3,'DEMOPOE_CONT','

','O','','','2008-03-12','2008-03-12',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,13,'DEMOJRN_ENDING','
','O','','','2009-02-20','2009-02-20',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOJRN',1,3,'DEMOJRN_CONT','

','O','','','2008-10-06','2009-01-09',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOJRN',1,2,'DEMOJRN_CHANGE','','O','','','2009-01-09','2009-01-09',NULL,NULL); INSERT INTO sbmFIELD VALUES ('MBIDEMOJRN',1,1,'DEMOJRN_RN','

Update a journal article:

*Document Reference Number:  ','M','','','2008-10-06','2008-10-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,3,'DEMOJRN_ISSUES','		*Order(s) (digit) and issue(s) (xx/YYYY) of the article:
','O','Order and issue numbers','','2009-02-20','2009-02-20',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,2,'DEMOJRN_TYPE','

Submit an Atlantis Times article:
*Status:
','O','Status:','','2009-02-20','2009-02-20',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,5,'DEMOJRN_EMAIL','

E-mail(s) of the author(s): (one per line)
','O','E-mail of the author(s): (one per line)','','2008-09-26','2009-01-09',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,9,'DEMOJRN_ABSF','
French article:
','O','French article:','','2008-09-26','2009-01-09',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,7,'DEMOJRN_TITLEF','

French title:
','O','French title:','','2008-09-26','2009-01-09',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,4,'DEMOJRN_AU','


Author(s): (one per line)
','O','Author(s)','','2008-09-26','2009-02-20',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,6,'DEMOJRN_TITLEE','


English title:
','O','English title:','','2008-09-26','2009-01-09',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,10,'DEMOJRN_IN','','O','Journal Name','','2008-09-26','2009-02-06',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,12,'DEMOJRN_END','
','O','','','2008-09-26','2009-02-20',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,8,'DEMOJRN_ABSE','

English article:
','O','English article:','','2008-11-04','2009-01-09',NULL,NULL); INSERT INTO sbmFIELD VALUES ('SBIDEMOJRN',1,14,'DEMOJRN_CATEG','','O','comboDEMOJRN-like for MBI','','2009-10-15','2009-10-15',NULL,NULL); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_TITLE',NULL,'245__a','T',NULL,5,60,NULL,NULL,NULL,'2007-09-13','2007-09-13',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_PHOTOG',NULL,'100__a','T',NULL,6,30,NULL,NULL,NULL,'2007-09-13','2007-09-19','

Picture Author(s) or Photographers(s)
(optional)(one per line):
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_DATE',NULL,'260__c','I',10,NULL,NULL,NULL,NULL,NULL,'2007-09-13','2007-09-19','

Date of the picture (dd/mm/yyyy): ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_KW',NULL,'6531_a','T',NULL,2,50,NULL,NULL,NULL,'2007-09-13','2007-09-13','

Keywords
(Optional, one keyword/key-phrase per line):
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_DESCR',NULL,'520__a','T',NULL,12,80,NULL,NULL,NULL,'2007-09-13','2007-09-13','

Picture Description:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_ADD_RN',NULL,'088__a','T',NULL,4,30,NULL,NULL,NULL,'2007-09-13','2007-09-13','

Additional Reference Numbers:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_NOTE',NULL,'500__a','T',NULL,6,60,NULL,NULL,NULL,'2007-09-13','2007-09-13','

Additional Comments or Notes about the Picture:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_FILE',NULL,'','F',40,NULL,NULL,NULL,NULL,NULL,'2007-09-13','2007-09-13',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_FINISH',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2007-09-13','2007-09-13',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_CHANGE',NULL,'','S',NULL,NULL,NULL,NULL,NULL,'','2007-10-04','2007-10-04',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_RN',NULL,'037__a','I',30,NULL,NULL,NULL,'DEMO-PICTURE---???',NULL,'2007-10-04','2007-10-04',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPIC_CONT',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2007-10-04','2007-10-04',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_REP',NULL,'088__a','T',NULL,4,30,NULL,NULL,NULL,'2008-03-02','2008-03-02','
Other Report Numbers (one per line):',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_TITLE',NULL,'245__a','T',NULL,5,60,NULL,NULL,NULL,'2008-03-02','2008-03-02','
Title:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_SUBTTL',NULL,'245__b','T',NULL,3,60,NULL,NULL,NULL,'2008-03-02','2008-03-02','

Thesis Subtitle (if any):
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_AU',NULL,'100__a','T',NULL,6,60,NULL,NULL,NULL,'2008-03-02','2008-03-02','
Authors:
(one per line):
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_SUPERV',NULL,'','T',NULL,6,60,NULL,NULL,NULL,'2008-03-02','2008-03-02','
Thesis Supervisor(s)
(one per line):
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_ABS',NULL,'520__a','T',NULL,12,80,NULL,NULL,NULL,'2008-03-02','2008-03-02','
Abstract:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_NUMP',NULL,'300__a','I',5,NULL,NULL,NULL,NULL,NULL,'2008-03-02','2008-03-06','
Number of Pages: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_LANG',NULL,'041__a','S',NULL,NULL,NULL,NULL,NULL,'','2008-03-02','2008-03-02','

Select the Language: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_PUBL',NULL,'','I',35,NULL,NULL,NULL,NULL,NULL,'2008-03-02','2008-03-02','
Thesis Publisher (or University): ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_PLDEF',NULL,'','I',20,NULL,NULL,NULL,NULL,NULL,'2008-03-02','2008-03-02','

Place of Thesis Defence:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_DIPL',NULL,'','S',NULL,NULL,NULL,NULL,NULL,'','2008-03-02','2008-03-02','

Diploma Awarded:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_DATE',NULL,'269__c','I',10,NULL,NULL,NULL,NULL,NULL,'2008-03-02','2008-03-02','
Date: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_UNIV',NULL,'502__b','I',30,NULL,NULL,NULL,NULL,NULL,'2008-03-02','2008-03-02','
Awarding University:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_PLACE',NULL,'','I',20,NULL,NULL,NULL,NULL,NULL,'2008-03-02','2008-03-02',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_FILE',NULL,'','F',60,NULL,NULL,NULL,NULL,NULL,'2008-03-02','2008-03-02',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_END',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-03-02','2008-03-02',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_RN',NULL,'037__a','I',30,NULL,NULL,NULL,'DEMO-THESIS--???',NULL,'2008-03-05','2008-03-05',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_CHANGE',NULL,'','S',NULL,NULL,NULL,NULL,NULL,'','2008-03-05','2008-03-06',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOTHE_CONT',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-03-05','2008-03-05',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_ABS',NULL,'520__a','T',NULL,12,80,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Abstract:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_AU',NULL,'100__a','T',NULL,6,60,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Authors: (one per line)
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_CHANGE',NULL,'','S',NULL,NULL,NULL,NULL,NULL,'','2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_CONT',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_DATE',NULL,'269__c','I',10,NULL,NULL,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Date: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_END',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_FILE',NULL,'','F',60,NULL,NULL,NULL,NULL,NULL,'2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_KW',NULL,'6531_a','T',NULL,4,50,NULL,NULL,NULL,'2008-03-07','2008-03-07','

Keywords:
(one keyword/key-phrase per line)
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_LANG',NULL,'041__a','S',NULL,NULL,NULL,NULL,NULL,'','2008-03-07','2008-03-07','

Select the Language: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_NOTE',NULL,'500__a','T',NULL,6,60,NULL,NULL,NULL,'2008-03-07','2008-03-07','

Additional Comments or Notes:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_NUMP',NULL,'300__a','I',5,NULL,NULL,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Number of Pages: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_REP',NULL,'088__a','T',NULL,4,30,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Other Report Numbers (one per line):',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_RN',NULL,'037__a','I',35,NULL,NULL,NULL,'DEMO---???',NULL,'2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOART_TITLE',NULL,'245__a','T',NULL,5,60,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Title:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_ABS',NULL,'520__a','T',NULL,12,80,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Abstract:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_AU',NULL,'100__a','T',NULL,6,60,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Authors: (one per line)
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_CHANGE',NULL,'','S',NULL,NULL,NULL,NULL,NULL,'','2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_CONT',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_DATE',NULL,'269__c','I',10,NULL,NULL,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Date: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_END',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_FILE',NULL,'','F',60,NULL,NULL,NULL,NULL,NULL,'2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_KW',NULL,'6531_a','T',NULL,4,50,NULL,NULL,NULL,'2008-03-07','2008-03-07','

Keywords:
(one keyword/key-phrase per line)
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_LANG',NULL,'041__a','S',NULL,NULL,NULL,NULL,NULL,'','2008-03-07','2008-03-07','

Select the Language: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_NOTE',NULL,'500__a','T',NULL,6,60,NULL,NULL,NULL,'2008-03-07','2008-03-07','

Additional Comments or Notes:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_NUMP',NULL,'300__a','I',5,NULL,NULL,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Number of Pages: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_REP',NULL,'088__a','T',NULL,4,30,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Other Report Numbers (one per line):',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_RN',NULL,'037__a','I',35,NULL,NULL,NULL,'DEMO-BOOK--???',NULL,'2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_TITLE',NULL,'245__a','T',NULL,5,60,NULL,NULL,NULL,'2008-03-07','2008-03-07','
Title:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_COMNT',NULL,'','T',NULL,6,60,NULL,NULL,NULL,'2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_DECSN',NULL,'','S',NULL,NULL,NULL,NULL,NULL,'\r\n','2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOBOO_REGB',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-03-07','2008-03-07',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_ABS',NULL,'520__a','T',NULL,20,80,NULL,NULL,NULL,'2008-03-12','2008-03-12','
Abstract:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_AU',NULL,'100__a','T',NULL,6,60,NULL,NULL,NULL,'2008-03-12','2008-03-12','
Authors: (one per line)
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_CHANGE',NULL,'','S',NULL,NULL,NULL,NULL,NULL,'\r\n','2008-03-12','2008-03-12',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_CONT',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-03-12','2008-03-12',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_DUMMY',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'


','2008-03-12','2008-03-12',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_END',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'

\r\n\r\n
','2008-03-12','2008-03-12',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_LANG',NULL,'041__a','S',NULL,NULL,NULL,NULL,NULL,'','2008-03-12','2008-03-12','

Select the Language: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_RN',NULL,'037__a','I',35,NULL,NULL,NULL,'DEMO-POETRY--???',NULL,'2008-03-12','2008-03-12',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_TITLE',NULL,'245__a','T',NULL,5,60,NULL,NULL,NULL,'2008-03-12','2008-03-12','
Title:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOPOE_YEAR',NULL,'909C0y','I',4,NULL,NULL,4,NULL,NULL,'2008-03-12','2008-03-12','

Year: ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_CHANGE',NULL,'','S',NULL,NULL,NULL,NULL,NULL,'','2009-01-09','2009-02-20',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_TYPE',NULL,'691__a','S',NULL,NULL,NULL,NULL,NULL,'[?]','2008-12-04','2009-02-20','

Update an Atlantis Times article:
*Status:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_AU',NULL,'100__a','T',NULL,4,60,NULL,NULL,NULL,'2008-09-23','2009-02-20','


Author(s): (one per line)
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_EMAIL',NULL,'859__a','T',NULL,4,60,NULL,NULL,NULL,'2008-09-23','2009-02-20','

E-mail(s) of the author(s): (one per line)
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_TITLEE',NULL,'245__a','T',NULL,5,60,NULL,NULL,NULL,'2008-09-23','2009-02-20','


English title:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_TITLEF',NULL,'246_1a','T',NULL,5,60,NULL,NULL,NULL,'2008-09-23','2009-02-20','

French title:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_ABSF',NULL,'590__b','R',NULL,100,90,NULL,NULL,'from invenio.htmlutils import get_html_text_editor\r\nfrom invenio.config import CFG_SITE_URL\r\nfrom invenio.search_engine import get_fieldvalues\r\nimport os\r\n\r\nif (\'modify\' in curdir) and not os.path.exists(\"%s/DEMOJRN_ABSF\" % curdir):\r\n try:\r\n content = get_fieldvalues(int(sysno), \'590__b\')[0]\r\n except:\r\n content = \'\'\r\nelif os.path.exists(\"%s/DEMOJRN_ABSE\" % curdir):\r\n content = file(\"%s/DEMOJRN_ABSE\" % curdir).read()\r\nelse:\r\n content = \'\'\r\n\r\ntext = get_html_text_editor(\"DEMOJRN_ABSF\", id=\"BulletinFCKEditor1\", content=content, toolbar_set=\"WebJournal\", width=\'522px\', height=\'700px\', file_upload_url=CFG_SITE_URL + \'/submit/attachfile\', custom_configurations_path=\'/fckeditor/journal-editor-config.js\')','2008-09-23','2009-02-23','
French Article:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_CONT',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-10-06','2008-10-06',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_END',NULL,'','D',NULL,NULL,NULL,NULL,NULL,'
\r\n\r\n
','2008-09-23','2009-02-20','
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_ISSUES',NULL,'','R',NULL,NULL,NULL,NULL,NULL,'from invenio.search_engine import get_fieldvalues\r\nfrom invenio.webjournal_utils import get_next_journal_issues, get_current_issue, get_journal_issue_grouping\r\nimport os\r\n\r\norders_and_issues = [(\'\',\'\')]*4\r\n\r\nif (\'modify\' in curdir) and not os.path.exists(\"%s/DEMOJRN_ISSUE1\" % curdir):\r\n try:\r\n orders = get_fieldvalues(int(sysno), \'773__c\')\r\n issues = get_fieldvalues(int(sysno), \'773__n\')\r\n orders_and_issues = zip(orders, issues) + orders_and_issues\r\n except:\r\n pass\r\nelif (\'running\' in curdir) and not os.path.exists(\"%s/DEMOJRN_ISSUE1\" % curdir):\r\n try:\r\n journal_name = \'AtlantisTimes\'\r\n current_issue = get_current_issue(\'en\', journal_name)\r\n nb_issues = get_journal_issue_grouping(journal_name)\r\n next_issue_numbers = get_next_journal_issues(current_issue, journal_name, nb_issues)\r\n orders_and_issues = zip([\'\']*4, next_issue_numbers) + orders_and_issues\r\n except:\r\n pass\r\nissues_fields = []\r\nsingle_issue_and_order_tmpl = \'\'\'\r\n\r\n\'\'\'\r\ni = 1\r\nfor order_and_issue in orders_and_issues[:4]:\r\n order = order_and_issue[0]\r\n issue = order_and_issue[1]\r\n issues_fields.append(single_issue_and_order_tmpl % (i, order, i, issue))\r\n i += 1\r\n\r\ntext = \'
\'.join(issues_fields)\r\n','2009-02-20','2009-02-23','		*Order(s) (digit) and issue(s) (xx/YYYY) of the article:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_RN',NULL,'037__a','I',35,NULL,NULL,NULL,'BUL---???',NULL,'2008-10-06','2009-02-20',NULL,NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_IN',NULL,'595__a','H',NULL,NULL,NULL,NULL,'Atlantis Times',NULL,'2008-09-23','2009-02-20',' ',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_ABSE',NULL,'520__b','R',NULL,100,90,NULL,NULL,'from invenio.htmlutils import get_html_text_editor\r\nfrom invenio.config import CFG_SITE_URL\r\nfrom invenio.search_engine import get_fieldvalues\r\nimport os\r\n\r\n\r\nif (\'modify\' in curdir) and not os.path.exists(\"%s/DEMOJRN_ABSE\" % curdir):\r\n try:\r\n content = get_fieldvalues(int(sysno), \'520__b\')[0]\r\n except:\r\n content = \'\'\r\nelif os.path.exists(\"%s/DEMOJRN_ABSE\" % curdir):\r\n content = file(\"%s/DEMOJRN_ABSE\" % curdir).read()\r\nelse:\r\n content = \'\'\r\n\r\ntext = get_html_text_editor(\"DEMOJRN_ABSE\",id=\"BulletinFCKEditor2\", content=content, toolbar_set=\"WebJournal\", width=\'522px\', height=\'700px\', file_upload_url=CFG_SITE_URL + \'/submit/attachfile\', custom_configurations_path=\'/fckeditor/journal-editor-config.js\')\r\n\r\n','2008-09-22','2009-02-23','

English Article:
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_ENDING',NULL,'','H',NULL,NULL,NULL,NULL,NULL,NULL,'2009-02-06','2009-02-20','
',NULL,0); INSERT INTO sbmFIELDDESC VALUES ('DEMOJRN_CATEG',NULL,'','R',NULL,NULL,NULL,NULL,NULL,'# Solve usual problem with submit/direct?.. links that bypass \r\n# the comboXXX (category selection) of the submission. Retrieve \r\n# the value, and set it (only in the case of MBI)\r\n\r\nfrom invenio.search_engine import get_fieldvalues\r\n\r\nif \"modify\" in curdir:\r\n try:\r\n comboDEMOJRNfile = file(\"%s/%s\" % (curdir,\'comboDEMOJRN\'), \'w\')\r\n report_number = get_fieldvalues(int(sysno), \'037__a\')[0]\r\n category = report_number.split(\'-\')[1]\r\n comboDEMOJRNfile.write(category)\r\n comboDEMOJRNfile.close()\r\n except:\r\n text = \'\'','2009-10-15','2009-10-15',NULL,NULL,0); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPIC','Mail_Submitter',70,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPIC','Print_Success',60,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPIC','Move_Photos_to_Storage',50,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPIC','Insert_Record',40,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPIC','Make_Record',30,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPIC','Report_Number_Generation',20,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPIC','Move_to_Done',80,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPIC','Create_Recid',10,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Get_Report_Number',10,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Get_Recid',20,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Is_Original_Submitter',30,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Create_Modify_Interface',40,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Get_Report_Number',10,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Get_Recid',20,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Is_Original_Submitter',30,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Make_Modify_Record',40,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Insert_Modify_Record',50,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Move_Photos_to_Storage',60,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Print_Success_MBI',70,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Send_Modify_Mail',80,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPIC','Move_to_Done',90,2); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Create_Upload_Files_Interface',40,1); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Is_Original_Submitter',30,1); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Get_Recid',20,1); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Get_Report_Number',10,1); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Move_to_Done',60,2); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Print_Success',50,2); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Mail_Submitter',40,2); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Move_Uploaded_Files_to_Storage',30,2); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Is_Original_Submitter',20,2); INSERT INTO sbmFUNCTIONS VALUES ('SRV','DEMOPIC','Get_Recid',10,2); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOTHE','Move_to_Done',90,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOTHE','Mail_Submitter',80,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOTHE','Make_Record',50,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOTHE','Insert_Record',60,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOTHE','Print_Success',70,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOTHE','Move_Files_to_Storage',40,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOTHE','Stamp_Uploaded_Files',30,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOTHE','Report_Number_Generation',20,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOTHE','Create_Recid',10,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Get_Report_Number',10,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Get_Recid',20,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Is_Original_Submitter',30,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Create_Modify_Interface',40,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Move_to_Done',80,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Send_Modify_Mail',70,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Print_Success_MBI',60,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Insert_Modify_Record',50,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Make_Modify_Record',40,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Is_Original_Submitter',30,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Get_Recid',20,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOTHE','Get_Report_Number',10,2); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOART','Print_Success',50,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOART','Insert_Record',40,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOART','Make_Record',30,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOART','Report_Number_Generation',20,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOART','Create_Recid',10,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOART','Mail_Submitter',60,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Create_Modify_Interface',40,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Get_Recid',20,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Is_Original_Submitter',30,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Get_Report_Number',10,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Move_to_Done',80,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Send_Modify_Mail',70,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Print_Success_MBI',60,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Insert_Modify_Record',50,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Make_Modify_Record',40,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Is_Original_Submitter',30,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Get_Recid',20,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOART','Get_Report_Number',10,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Create_Modify_Interface',40,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Get_Recid',20,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Is_Original_Submitter',30,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Get_Report_Number',10,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Move_to_Done',90,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Send_Modify_Mail',80,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Print_Success_MBI',70,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Move_Uploaded_Files_to_Storage',60,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Insert_Modify_Record',50,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Make_Modify_Record',40,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Is_Original_Submitter',30,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Get_Recid',20,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOBOO','Get_Report_Number',10,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Get_Report_Number',10,1); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Test_Status',20,1); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Is_Referee',30,1); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','CaseEDS',40,1); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Send_APP_Mail',90,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Print_Success_APP',80,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Update_Approval_DB',70,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Insert_Record',60,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Print_Success_APP',60,3); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Send_APP_Mail',70,3); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Move_From_Pending',20,3); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Get_Recid',30,3); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Get_Info',40,3); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Get_Report_Number',10,3); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Update_Approval_DB',50,3); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Move_to_Done',80,3); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOBOO','Move_to_Pending',90,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOBOO','Print_Success',80,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOBOO','Send_Approval_Request',70,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOBOO','Update_Approval_DB',60,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOBOO','Mail_Submitter',50,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOBOO','Move_Files_to_Storage',40,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOBOO','Make_Dummy_MARC_XML_Record',30,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOBOO','Report_Number_Generation',20,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOBOO','Create_Recid',10,1); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Make_Record',50,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Get_Info',40,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Get_Recid',30,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Move_From_Pending',20,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Get_Report_Number',10,2); INSERT INTO sbmFUNCTIONS VALUES ('APP','DEMOBOO','Move_to_Done',100,2); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPOE','Create_Recid',10,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPOE','Report_Number_Generation',20,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPOE','Make_Record',30,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPOE','Insert_Record',40,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPOE','Print_Success',50,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPOE','Mail_Submitter',60,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOPOE','Move_to_Done',70,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Get_Report_Number',10,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Get_Recid',20,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Is_Original_Submitter',30,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Create_Modify_Interface',40,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Move_to_Done',80,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Print_Success_MBI',60,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Insert_Modify_Record',50,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Make_Modify_Record',40,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Is_Original_Submitter',30,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Get_Recid',20,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOPOE','Get_Report_Number',10,2); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOJRN','Move_to_Done',80,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOJRN','Mail_Submitter',70,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOJRN','Print_Success',60,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOJRN','Insert_Record',50,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOJRN','Make_Record',40,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOJRN','Move_FCKeditor_Files_to_Storage',30,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOJRN','Report_Number_Generation',20,1); INSERT INTO sbmFUNCTIONS VALUES ('SBI','DEMOJRN','Create_Recid',10,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Get_Report_Number',10,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Get_Recid',20,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Create_Modify_Interface',30,1); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Move_to_Done',90,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Send_Modify_Mail',80,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Print_Success_MBI',70,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Move_Files_to_Storage',60,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Insert_Modify_Record',50,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Make_Modify_Record',40,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Move_FCKeditor_Files_to_Storage',30,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Get_Recid',20,2); INSERT INTO sbmFUNCTIONS VALUES ('MBI','DEMOJRN','Get_Report_Number',10,2); INSERT INTO sbmIMPLEMENT VALUES ('DEMOPIC','SBI','Y','SBIDEMOPIC',1,'2007-09-13','2007-10-04',1,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOPIC','MBI','Y','MBIDEMOPIC',1,'2007-10-04','2007-10-04',2,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOPIC','SRV','Y','SRVDEMOPIC',1,'2009-04-09','2009-04-09',3,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOTHE','SBI','Y','SBIDEMOTHE',1,'2008-03-02','2008-03-05',1,'','1',1,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOTHE','MBI','Y','MBIDEMOTHE',1,'2008-03-05','2008-03-05',2,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOART','SBI','Y','SBIDEMOART',1,'2008-03-06','2008-03-07',1,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOART','MBI','Y','MBIDEMOART',1,'2008-03-07','2008-03-07',2,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOBOO','SBI','Y','SBIDEMOBOO',1,'2008-03-06','2008-03-07',1,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOBOO','MBI','Y','MBIDEMOBOO',1,'2008-03-07','2008-03-07',2,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOBOO','APP','Y','APPDEMOBOO',1,'2002-05-06','2002-05-28',3,'0','0',0,1,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOPOE','SBI','Y','SBIDEMOPOE',2,'2008-03-12','2008-03-12',1,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOPOE','MBI','Y','MBIDEMOPOE',1,'2008-03-12','2008-03-12',2,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOJRN','SBI','Y','SBIDEMOJRN',1,'2008-09-18','2009-02-23',1,'','',0,0,''); INSERT INTO sbmIMPLEMENT VALUES ('DEMOJRN','MBI','Y','MBIDEMOJRN',1,'2008-09-18','2009-02-23',2,'','',0,0,''); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','addressesMBI',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','authorfile','DEMOPIC_PHOTOG'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','autorngen','Y'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','counterpath','lastid_DEMOPIC_categ_yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','createTemplate','DEMOPICcreate.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','documenttype','picture'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','edsrn','DEMOPIC_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','emailFile','SuE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','fieldnameMBI','DEMOPIC_CHANGE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','iconsize','180>,700>'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','modifyTemplate','DEMOPICmodify.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','newrnin','NEWRN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','paths_and_suffixes','{\"DEMOPIC_FILE\":\"\"}'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','rename','file:DEMOPIC_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','rnformat','DEMO-PICTURE-categ-yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','rnin','comboDEMOPIC'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','sourceDoc','photos'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','sourceTemplate','DEMOPIC.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','status','ADDED'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','titleFile','DEMOPIC_TITLE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','yeargen','AUTO'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','doctypes','DEMOPIC_FILE=Picture|Additional=Additional Document'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','canReviseDoctypes','*'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','maxFilesDoctypes','Additional=1'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','canNameNewFiles','1'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','canRenameDoctypes',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','canCommentDoctypes','*'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','canAddFormatDoctypes','DEMOPIC_FILE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','showLinks','1'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','keepDefault','1'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','restrictions','=Public|restricted_picture=Private'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','canRestrictDoctypes','*'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','canDeleteDoctypes','*'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','createIconDoctypes','*'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPIC','forceFileRevision',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','counterpath','lastid_DEMOTHE_yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','autorngen','Y'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','edsrn','DEMOTHE_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','rnformat','DEMO-THESIS-yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','yeargen','AUTO'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','rnin','comboDEMOTHE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','files_to_be_stamped','DEMOTHE_FILE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','latex_template','demo-stamp-left.tex'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','stamp','first'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','latex_template_vars','{\'REPORTNUMBER\':\'FILE:DEMOTHE_RN\',\'DATE\':\'FILE:DEMOTHE_DATE\'}'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','createTemplate','DEMOTHEcreate.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','sourceTemplate','DEMOTHE.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','documenttype','fulltext'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','iconsize','180>,700>'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','paths_and_suffixes','{\"DEMOTHE_FILE\":\"\"}'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','rename','file:DEMOTHE_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','newrnin',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','status','ADDED'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','authorfile','DEMOTHE_AU'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','emailFile','SuE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','titleFile','DEMOTHE_TITLE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','fieldnameMBI','DEMOTHE_CHANGE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','modifyTemplate','DEMOTHEmodify.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','addressesMBI',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOTHE','sourceDoc','Thesis'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','addressesMBI',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','authorfile','DEMOART_AU'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','autorngen','Y'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','counterpath','lastid_DEMOART_categ_yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','createTemplate','DEMOARTcreate.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','documenttype','fulltext'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','edsrn','DEMOART_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','emailFile','SuE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','fieldnameMBI','DEMOART_CHANGE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','iconsize','180'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','modifyTemplate','DEMOARTmodify.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','newrnin',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','paths_and_suffixes','{\"DEMOART_FILE\":\"\"}'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','rename','file:DEMOART_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','rnformat','DEMO-categ-yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','rnin','comboDEMOART'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','sourceDoc','Textual Document'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','sourceTemplate','DEMOART.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','status','ADDED'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','titleFile','DEMOART_TITLE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOART','yeargen','AUTO'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','autorngen','Y'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','counterpath','lastid_DEMOBOO_yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','edsrn','DEMOBOO_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','rnformat','DEMO-BOOK-yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','rnin','comboDEMOBOO'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','yeargen','AUTO'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','newrnin','NEWRN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','status','APPROVAL'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','authorfile','DEMOBOO_AU'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','emailFile','SuE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','titleFile','DEMOBOO_TITLE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','categformatDAM',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','addressesDAM',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','directory','DEMOBOO'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','fieldnameMBI','DEMOBOO_CHANGE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','modifyTemplate','DEMOBOOmodify.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','sourceTemplate','DEMOBOO.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','addressesMBI',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','sourceDoc','BOOK'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','casevalues','approve,reject'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','casesteps','2,3'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','casevariable','DEMOBOO_DECSN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','casedefault',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','categformatAPP',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','addressesAPP',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','createTemplate','DEMOBOOcreate.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','documenttype','fulltext'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','iconsize','180>,700>'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','paths_and_suffixes','{\"DEMOBOO_FILE\":\"\"}'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','rename','file:DEMOBOO_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','dummyrec_source_tpl','DEMOBOO.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','dummyrec_create_tpl','DEMOBOOcreate.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','decision_file','DEMOBOO_DECSN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','comments_file','DEMOBOO_COMNT'); INSERT INTO sbmPARAMETERS VALUES ('DEMOBOO','elementNameToDoctype','DEMOBOO_FILE=DEMOBOO_FILE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','addressesMBI',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','authorfile','DEMOPOE_AU'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','autorngen','Y'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','counterpath','lastid_DEMOPOE_yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','createTemplate','DEMOPOEcreate.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','edsrn','DEMOPOE_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','emailFile','SuE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','fieldnameMBI','DEMOPOE_CHANGE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','modifyTemplate','DEMOPOEmodify.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','newrnin',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','rnformat','DEMO-POETRY-yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','rnin','comboDEMOPOE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','sourceDoc','Poem'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','sourceTemplate','DEMOPOE.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','status','ADDED'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','titleFile','DEMOPOE_TITLE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOPOE','yeargen','AUTO'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','record_search_pattern','collection:ATLANTISTIMES*'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','paths_and_suffixes','{\'image\':\"image\", \'file\':\"file\", \'flash\':\"flash\", \'media\':\'media\'}'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','documenttype','picture'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','rename',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','addressesMBI',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','emailFile','SuE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','sourceTemplate','DEMOJRN.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','edsrn','DEMOJRN_RN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','modifyTemplate','DEMOJRNmodify.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','iconsize','300>'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','createTemplate','DEMOJRNcreate.tpl'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','newrnin',''); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','status','ADDED'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','titleFile','DEMOJRN_TITLEE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','authorfile','DEMOJRN_AU'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','fieldnameMBI','DEMOJRN_CHANGE'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','sourceDoc','Textual Document'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','autorngen','Y'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','counterpath','lastid_DEMOJRN_categ_yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','rnformat','BUL-categ-yy'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','rnin','comboDEMOJRN'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','yeargen','AUTO'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','input_fields','DEMOJRN_ABSE,DEMOJRN_ABSF'); INSERT INTO sbmPARAMETERS VALUES ('DEMOJRN','files','DEMOJRN_ABSE,DEMOJRN_ABSF'); INSERT INTO rnkMETHOD (id,name,last_updated) VALUES (2,'demo_jif','0000-00-00 00:00:00'); INSERT INTO collection_rnkMETHOD (id_collection,id_rnkMETHOD,score) VALUES (15,2,90); INSERT INTO rnkMETHOD (id,name,last_updated) VALUES (3,'citation','0000-00-00 00:00:00'); INSERT INTO collection_rnkMETHOD (id_collection,id_rnkMETHOD,score) VALUES (1,3,10); INSERT INTO collection_rnkMETHOD (id_collection,id_rnkMETHOD,score) VALUES (15,3,80); INSERT INTO rnkMETHOD (id,name,last_updated) VALUES (4,'citerank_citation_t','0000-00-00 00:00:00'); INSERT INTO collection_rnkMETHOD (id_collection,id_rnkMETHOD,score) VALUES (15,4,70); INSERT INTO rnkMETHOD (id,name,last_updated) VALUES (5,'citerank_pagerank_c','0000-00-00 00:00:00'); INSERT INTO collection_rnkMETHOD (id_collection,id_rnkMETHOD,score) VALUES (15,5,60); INSERT INTO rnkMETHOD (id,name,last_updated) VALUES (6,'citerank_pagerank_t','0000-00-00 00:00:00'); INSERT INTO collection_rnkMETHOD (id_collection,id_rnkMETHOD,score) VALUES (15,6,50); INSERT INTO externalcollection (id, name) VALUES (1, 'Amazon'); INSERT INTO externalcollection (id, name) VALUES (2, 'CERN EDMS'); INSERT INTO externalcollection (id, name) VALUES (3, 'CERN Indico'); INSERT INTO externalcollection (id, name) VALUES (4, 'CERN Intranet'); INSERT INTO externalcollection (id, name) VALUES (5, 'CiteSeer'); INSERT INTO externalcollection (id, name) VALUES (6, 'Google Books'); INSERT INTO externalcollection (id, name) VALUES (7, 'Google Scholar'); INSERT INTO externalcollection (id, name) VALUES (8, 'Google Web'); INSERT INTO externalcollection (id, name) VALUES (9, 'IEC'); INSERT INTO externalcollection (id, name) VALUES (10, 'IHS'); INSERT INTO externalcollection (id, name) VALUES (11, 'INSPEC'); INSERT INTO externalcollection (id, name) VALUES (12, 'ISO'); INSERT INTO externalcollection (id, name) VALUES (13, 'KISS Books/Journals'); INSERT INTO externalcollection (id, name) VALUES (14, 'KISS Preprints'); INSERT INTO externalcollection (id, name) VALUES (15, 'NEBIS'); INSERT INTO externalcollection (id, name) VALUES (16, 'SLAC Library Catalog'); INSERT INTO externalcollection (id, name) VALUES (17, 'SPIRES HEP'); INSERT INTO externalcollection (id, name) VALUES (18, 'Scirus'); INSERT INTO externalcollection (id, name) VALUES (19, 'Atlantis Institute Books'); INSERT INTO externalcollection (id, name) VALUES (20, 'Atlantis Institute Articles'); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (1,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,3,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,5,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,13,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,14,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,17,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,18,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (2,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (3,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (4,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (5,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,3,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,5,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,13,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,14,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,17,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,18,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (6,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (7,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (8,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (9,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (10,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (11,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (12,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (13,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (14,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,3,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,5,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,13,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,14,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,17,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,18,2); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (15,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (16,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (17,20,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,1,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,2,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,3,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,4,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,5,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,6,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,7,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,8,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,9,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,10,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,11,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,12,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,13,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,14,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,15,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,16,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,17,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,18,1); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,19,0); INSERT INTO collection_externalcollection (id_collection,id_externalcollection,type) VALUES (18,20,0); INSERT INTO knwKB VALUES ('1','DBCOLLID2COLL','DbCollID to Coll name correspondance.', NULL); INSERT INTO knwKB VALUES ('2','EJOURNALS','Knowledge base of all known electronic journals. Useful for reference linking.', NULL); INSERT INTO knwKB VALUES ('3','DBCOLLID2BIBTEX','Mapping between the 980 field and BibTeX entry types.', NULL); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('ARTICLE','Published Article', '1'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('PREPRINT','Preprint', '1'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('THESIS','Thesis', '1'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('BOOK','Book', '1'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('REPORT','Report', '1'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('PICTURE','Pictures', '1'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('AAS Photo Bull.','AAS Photo Bull.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Accredit. Qual. Assur.','Accredit. Qual. Assur.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Acoust. Phys.','Acoust. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Acoust. Res. Lett.','Acoust. Res. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Acta Astron.','Acta Astron.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Adv. Comput. Math.','Adv. Comput. Math.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Aequ. Math.','Aequ. Math.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Afr. Skies','Afr. Skies', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Algorithmica','Algorithmica', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Am. J. Phys.','Am. J. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Ann. Phys.','Ann. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Annu. Rev. Astron. Astrophys.','Annu. Rev. Astron. Astrophys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Annu. Rev. Earth Planet. Sci.','Annu. Rev. Earth Planet. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Appl. Phys. Lett.','Appl. Phys. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Appl. Phys., A','Appl. Phys., A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Appl. Phys., B','Appl. Phys., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Appl. Radiat. Isot.','Appl. Radiat. Isot.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Appl. Surf. Sci.','Appl. Surf. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Arch. Appl. Mech.','Arch. Appl. Mech.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Arch. Envir. Contam. Toxicol.','Arch. Envir. Contam. Toxicol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Arch. Rational Mech. Analys.','Arch. Rational Mech. Analys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astron. Astrophys. Rev.','Astron. Astrophys. Rev.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astron. Astrophys.','Astron. Astrophys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astron. Astrophys., Suppl.','Astron. Astrophys., Suppl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astron. J.','Astron. J.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astron. Lett.','Astron. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astron. Nachr.','Astron. Nachr.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astron. Rep.','Astron. Rep.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astropart. Phys.','Astropart. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astrophys. J.','Astrophys. J.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Astrophys. Norvegica','Astrophys. Norvegica', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Balt. Astron.','Balt. Astron.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Bioimaging','Bioimaging', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Biol. Cybern.','Biol. Cybern.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Bull. Astron. Belgrade','Bull. Astron. Belgrade', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Bull. Astron. Inst. Czech.','Bull. Astron. Inst. Czech.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Bull. Astron. Soc. India','Bull. Astron. Soc. India', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Bull. Eng. Geol. Environ.','Bull. Eng. Geol. Environ.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Bull. Environ. Contam. Toxicol.','Bull. Environ. Contam. Toxicol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Calc. Var. Partial Differ. Equ.','Calc. Var. Partial Differ. Equ.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Chaos','Chaos', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Chaos Solitons Fractals','Chaos Solitons Fractals', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Chem. Phys.','Chem. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Chem. Phys. Lett.','Chem. Phys. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Chin. Astron. Astrophys.','Chin. Astron. Astrophys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Chin. J. Astron. Astrophys.','Chin. J. Astron. Astrophys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Class. Quantum Gravity','Class. Quantum Gravity', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Clim. Dyn.','Clim. Dyn.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Colloid Polym. Sci.','Colloid Polym. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Combinatorica','Combinatorica', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Combust. Theory Model.','Combust. Theory Model.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Commun. Math. Phys.','Commun. Math. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Comment. Math. Helv.','Comment. Math. Helv.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Comput. Mech.','Comput. Mech.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Comput. Phys.','Comput. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Comput. Phys. Commun.','Comput. Phys. Commun.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Comput. Sci. Eng.','Comput. Sci. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Comput. Vis. Sci.','Comput. Vis. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Computing','Computing', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Constr. Approx.','Constr. Approx.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Contin. Mech. Thermodyn.','Contin. Mech. Thermodyn.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Contrib. Astron. Obs. Skaln. Pleso','Contrib. Astron. Obs. Skaln. Pleso', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Contrib. Astron. Obs. Skaln. Pleso Suppl.','Contrib. Astron. Obs. Skaln. Pleso Suppl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Cryogenics','Cryogenics', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Crystallogr. Rep.','Crystallogr. Rep.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Curr. Appl. Phys.','Curr. Appl. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Curr. Opin. Solid State Mater. Sci.','Curr. Opin. Solid State Mater. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Discret. Comput. Geom.','Discret. Comput. Geom.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Displays','Displays', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Distrib. Comput.','Distrib. Comput.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Distrib. Syst. Eng.','Distrib. Syst. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Dokl. Phys.','Dokl. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Electrochem. Solid State Lett.','Electrochem. Solid State Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Electron. Lett.','Electron. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Elem. Math.','Elem. Math.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Environ. Geol.','Environ. Geol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Environ. Manage.','Environ. Manage.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Eur. Biophys. J. Biophys. Lett.','Eur. Biophys. J. Biophys. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Eur. J. Phys.','Eur. J. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Eur. Phys. J., A','Eur. Phys. J., A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Eur. Phys. J., Appl. Phys.','Eur. Phys. J., Appl. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Eur. Phys. J., B','Eur. Phys. J., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Eur. Phys. J., C','Eur. Phys. J., C', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Eur. Phys. J., D','Eur. Phys. J., D', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Eur. Phys. J., E','Eur. Phys. J., E', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Europhys. Lett.','Europhys. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Europhys. News','Europhys. News', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Exp. Fluids','Exp. Fluids', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Few-Body Syst.','Few-Body Syst.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Finan. Stoch.','Finan. Stoch.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Fluid Dyn. Res.','Fluid Dyn. Res.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Geom. Funct. Anal.','Geom. Funct. Anal.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Heat Mass Transf.','Heat Mass Transf.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('High Energy Phys. Libr. Webzine','High Energy Phys. Libr. Webzine', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('High Perform. Polym.','High Perform. Polym.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Circ. Devices Syst.','IEE Proc., Circ. Devices Syst.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Commun.','IEE Proc., Commun.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Comput. Digit. Tech.','IEE Proc., Comput. Digit. Tech.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Control Theory Appl.','IEE Proc., Control Theory Appl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Electr. Power Appl.','IEE Proc., Electr. Power Appl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Gener. Transm. Distrib.','IEE Proc., Gener. Transm. Distrib.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Microw. Antennas Propag.','IEE Proc., Microw. Antennas Propag.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Optoelectron.','IEE Proc., Optoelectron.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Radar, Sonar Navig.','IEE Proc., Radar, Sonar Navig.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Sci. Meas. Technol.','IEE Proc., Sci. Meas. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Softw. Eng.','IEE Proc., Softw. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('IEE Proc., Vis. Image Signal Process.','IEE Proc., Vis. Image Signal Process.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Image Vis. Comput.','Image Vis. Comput.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Inform. Forsch. Entwickl.','Inform. Forsch. Entwickl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Inform. Spektr.','Inform. Spektr.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Infrared Phys. Technol.','Infrared Phys. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Int. J. Digit. Libr.','Int. J. Digit. Libr.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Int. J. Doc. Anal. Recogn.','Int. J. Doc. Anal. Recogn.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Int. J. Nonlinear Mech.','Int. J. Nonlinear Mech.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Int. J. Softw. Tools Technol. Transf.','Int. J. Softw. Tools Technol. Transf.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Invent. Math.','Invent. Math.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Inverse Probl.','Inverse Probl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Acoust. Soc. Am.','J. Acoust. Soc. Am.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Aerosp. Eng.','J. Aerosp. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Alloys. Compounds','J. Alloys. Compounds', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Am. Assoc. Var. Star Obs.','J. Am. Assoc. Var. Star Obs.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Appl. Mech.','J. Appl. Mech.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Appl. Phys.','J. Appl. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Atmos. Solar Terrest. Phys.','J. Atmos. Solar Terrest. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Br. Astron. Assoc.','J. Br. Astron. Assoc.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Chem. Phys.','J. Chem. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Classif.','J. Classif.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Comput. Inf. Sci. Eng.','J. Comput. Inf. Sci. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Constr. Eng. Manage.','J. Constr. Eng. Manage.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Cryptol.','J. Cryptol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Cryst. Growth','J. Cryst. Growth', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Dyn. Syst. Meas. Control','J. Dyn. Syst. Meas. Control', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Electrochem. Soc.','J. Electrochem. Soc.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Electron Spectrosc. Relat. Phen.','J. Electron Spectrosc. Relat. Phen.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Electron. Imaging','J. Electron. Imaging', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Electron. Packag.','J. Electron. Packag.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Energy Eng.','J. Energy Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Energy Resour. Technol.','J. Energy Resour. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Eng. Mater. Technol.','J. Eng. Mater. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Eng. Mech.','J. Eng. Mech.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Environ. Eng.','J. Environ. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Exp. Theor. Phys., JETP','J. Exp. Theor. Phys., JETP', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Fluids Eng.','J. Fluids Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Geom. Phys.','J. Geom. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Heat Transf.','J. Heat Transf.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. High Energy Phys.','J. High Energy Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Korean Astron. Soc.','J. Korean Astron. Soc.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Lumin.','J. Lumin.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Magn. Magn. Mater.','J. Magn. Magn. Mater.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Manage. Eng.','J. Manage. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Manuf. Sci. Eng.','J. Manuf. Sci. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Mater. Civ. Eng.','J. Mater. Civ. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Math. Biol.','J. Math. Biol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Math. Phys.','J. Math. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Mech. Des.','J. Mech. Des.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Micromech. Microeng.','J. Micromech. Microeng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Opt.','J. Opt.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys., A','J. Phys., A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys., B','J. Phys., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys., Condens. Matter','J. Phys., Condens. Matter', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys., D','J. Phys., D', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys., G','J. Phys., G', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys. I','J. Phys. I', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys. II','J. Phys. II', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys. III','J. Phys. III', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys. Chem. Ref. Data','J. Phys. Chem. Ref. Data', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Phys. Chem. Solids','J. Phys. Chem. Solids', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Quant. Spectrosc. Radiat. Transf.','J. Quant. Spectrosc. Radiat. Transf.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. R. Astron. Soc. Can.','J. R. Astron. Soc. Can.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Radio. Prot.','J. Radio. Prot.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Rheol.','J. Rheol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Solar Energy Eng.','J. Solar Energy Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Solid State Electrochem.','J. Solid State Electrochem.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Struct. Eng.','J. Struct. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Surv. Eng.','J. Surv. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Tribol.','J. Tribol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Turbomach.','J. Turbomach.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Vac. Sci. Technol.','J. Vac. Sci. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Vac. Sci. Technol., A','J. Vac. Sci. Technol., A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Vac. Sci. Technol., B','J. Vac. Sci. Technol., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('J. Vib. Acoust.','J. Vib. Acoust.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('JETP','JETP', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('JETP Lett.','JETP Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Low Temp. Phys.','Low Temp. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Mach. Vis. Appl.','Mach. Vis. Appl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Mater. Res. Innov.','Mater. Res. Innov.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Mater. Sci. Eng., B','Mater. Sci. Eng., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Math. Ann.','Math. Ann.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Math. Model. Numer. Anal.','Math. Model. Numer. Anal.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Math. Program.','Math. Program.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Math. Z.','Math. Z.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Meas. Sci. Technol.','Meas. Sci. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Med. Phys.','Med. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Meteorit. Planet. Sci.','Meteorit. Planet. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Microelectron. Eng.','Microelectron. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Micron','Micron', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Microsc. Microanal.','Microsc. Microanal.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Microsyst. Technol.','Microsyst. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Mon. Not. R. Astron. Soc.','Mon. Not. R. Astron. Soc.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Multim. Syst.','Multim. Syst.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nanotech.','Nanotech.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Naturwiss.','Naturwiss.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Network','Network', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('New Astron.','New Astron.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('New Astron. Rev.','New Astron. Rev.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nonlinearity','Nonlinearity', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nucl. Instrum. Methods Phys. Res., A','Nucl. Instrum. Methods Phys. Res., A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nucl. Instrum. Methods Phys. Res., B','Nucl. Instrum. Methods Phys. Res., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nucl. Phys. B, Proc. Suppl.','Nucl. Phys. B, Proc. Suppl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nucl. Phys., A','Nucl. Phys., A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nucl. Phys., B','Nucl. Phys., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Num. Math.','Num. Math.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nuovo Cimento, A','Nuovo Cimento, A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nuovo Cimento, B','Nuovo Cimento, B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nuovo Cimento, C','Nuovo Cimento, C', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Nuovo Cimento, D','Nuovo Cimento, D', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Obs.','Obs.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Opt. Commun.','Opt. Commun.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Opt. Eng.','Opt. Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Opt. Lasers Eng.','Opt. Lasers Eng.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Opt. Mater.','Opt. Mater.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Opt. Spectrosc.','Opt. Spectrosc.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. At. Nucl.','Phys. At. Nucl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Chem. Miner.','Phys. Chem. Miner.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Educ.','Phys. Educ.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Fluids','Phys. Fluids', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Fluids, A','Phys. Fluids, A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Fluids, B','Phys. Fluids, B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Lett., A','Phys. Lett., A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Lett., B','Phys. Lett., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Med. Biol.','Phys. Med. Biol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Part. Nucl.','Phys. Part. Nucl.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Plasmas','Phys. Plasmas', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rep.','Phys. Rep.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rev., A','Phys. Rev., A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rev., B','Phys. Rev., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rev., C','Phys. Rev., C', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rev., D','Phys. Rev., D', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rev., E','Phys. Rev., E', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rev., ser. 1','Phys. Rev., ser. 1', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rev. Lett.','Phys. Rev. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rev. Spec. Top. Accel. Beams','Phys. Rev. Spec. Top. Accel. Beams', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Rev.','Phys. Rev.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Phys. Solid State','Phys. Solid State', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Physica, A','Physica, A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Physica, B','Physica, B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Physica, C','Physica, C', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Physica, D','Physica, D', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Physica, E','Physica, E', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Physiol. Meas.','Physiol. Meas.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Planet. Space Sci.','Planet. Space Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Plasma Phys. Control. Fusion','Plasma Phys. Control. Fusion', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Plasma Phys. Rep.','Plasma Phys. Rep.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Plasma Sources Sci. Technol.','Plasma Sources Sci. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Polym. Bull.','Polym. Bull.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Powder Diffraction','Powder Diffraction', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Probab. Theory Relat. Fields','Probab. Theory Relat. Fields', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Proc. Astron. Soc. Aust.','Proc. Astron. Soc. Aust.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Proc. Nat. Acad. Sci.','Proc. Nat. Acad. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Prog. Cryst. Growth Charact. Mat.','Prog. Cryst. Growth Charact. Mat.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Prog. Part. Nucl. Phys.','Prog. Part. Nucl. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Prog. Quantum Electron.','Prog. Quantum Electron.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Prog. Surf. Sci.','Prog. Surf. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Program','Program', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Publ. Astron. Soc. Aust.','Publ. Astron. Soc. Aust.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Publ. Astron. Soc. Jpn.','Publ. Astron. Soc. Jpn.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Publ. Astron. Soc. Pac.','Publ. Astron. Soc. Pac.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Publ. Underst. Sci.','Publ. Underst. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Pure Appl. Opt.: J. Eur. Opt. Soc. P. A','Pure Appl. Opt.: J. Eur. Opt. Soc. P. A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Quantum Semiclass. Opt.: J. Eur. Opt. Soc. P. B','Quantum Semiclass. Opt.: J. Eur. Opt. Soc. P. B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Radiat. Environ. Biophys.','Radiat. Environ. Biophys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Radiat. Meas.','Radiat. Meas.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Radiat. Phys. Chem.','Radiat. Phys. Chem.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Radiologe','Radiologe', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Radioprotection','Radioprotection', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Rep. Math. Phys.','Rep. Math. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Rep. Prog. Phys.','Rep. Prog. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Res. Exp. Med.','Res. Exp. Med.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Rev. Mex. Astron. Astrofis.','Rev. Mex. Astron. Astrofis.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Rev. Mod. Phys.','Rev. Mod. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Rev. Sci. Instrum.','Rev. Sci. Instrum.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Sel. Math., New Ser.','Sel. Math., New Ser.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Semicond.','Semicond.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Semicond. Sci. Technol.','Semicond. Sci. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Shock Waves','Shock Waves', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('SIAM J. Appl. Math.','SIAM J. Appl. Math.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('SIAM J. Comput.','SIAM J. Comput.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('SIAM J. Math. Anal.','SIAM J. Math. Anal.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('SIAM J. Numer. Anal.','SIAM J. Numer. Anal.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('SIAM J. Optim.','SIAM J. Optim.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('SIAM Rev.','SIAM Rev.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Smart Mat. Struct.','Smart Mat. Struct.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Soft Comput.','Soft Comput.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Softw. Concepts Tools','Softw. Concepts Tools', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Solar Phys.','Solar Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Solid State Commun.','Solid State Commun.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Solid State Electron.','Solid State Electron.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Solid State Ion.','Solid State Ion.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Sov. Astron. Lett.','Sov. Astron. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Superconductor Science and Technology','Superconductor Science and Technology', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Surf. Coatings Techn.','Surf. Coatings Techn.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Surf. Sci.','Surf. Sci.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Surf. Sci. Rep.','Surf. Sci. Rep.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Surf. Sci. Spectra','Surf. Sci. Spectra', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Synth. Metals','Synth. Metals', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Syst. Fam.','Syst. Fam.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Tech. Phys.','Tech. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Tech. Phys. Lett.','Tech. Phys. Lett.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Theor. Comput. Fluid Dyn.','Theor. Comput. Fluid Dyn.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Theory Comput. Syst.','Theory Comput. Syst.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Thin Solid Films','Thin Solid Films', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Tribol. Int.','Tribol. Int.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Ultramicroscopy','Ultramicroscopy', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Vacuum','Vacuum', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('VLDB J.','VLDB J.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Virtual J. Nanoscale Sci. Technol.','Virtual J. Nanoscale Sci. Technol.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Virtual J. Biol. Phys. Res.','Virtual J. Biol. Phys. Res.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Vis. Comput.','Vis. Comput.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Wave Motion','Wave Motion', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Waves Random Media','Waves Random Media', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Wear','Wear', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Z. Angew. Math. Phys.','Z. Angew. Math. Phys.', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Z. Phys., A','Z. Phys., A', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Z. Phys., B','Z. Phys., B', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Z. Phys., C','Z. Phys., C', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('Zphys-e.C','Zphys-e.C', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('ATLAS eNews','ATLAS eNews', '2'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('PICTURE','unpublished', '3'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('PREPRINT','techreport', '3'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('ARTICLE','article', '3'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('REPORT','techreport', '3'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('BOOK','book', '3'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('THESIS','phdthesis', '3'); INSERT INTO knwKBRVAL (m_key,m_value,id_knwKB) VALUES ('POETRY','unpublished', '3'); -- crcLIBRARY demo data: INSERT INTO crcLIBRARY (name, address, email, phone, notes) VALUES ('Atlantis Main Library', 'CH-1211 Geneva 23', 'atlantis@cds.cern.ch', '1234567', ''); INSERT INTO crcLIBRARY (name, address, email, phone, notes) VALUES ('Atlantis HEP Library', 'CH-1211 Geneva 21', 'atlantis.hep@cds.cern.ch', '1234567', ''); -- crcITEM demo data: INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-34001', '34', '1', '', 'ABC-123', 'Book', '4 weeks', 'available', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-34002', '34', '2', '', 'HEP-12A', 'Book', '4 weeks', 'requested', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-33001', '33', '1', '', 'AZ.12-AK', 'Book', '4 weeks', 'on loan', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-32001', '32', '1', 'Reference', 'WDFG-54', 'Book', 'Not for loan', 'available', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-32002', '32', '2', '', 'RZ.612-MK', 'Book', '4 weeks', 'available', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-32003', '32', '1', '', 'RT-4654-E', 'Book', '4 weeks', 'missing', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-31001', '31', '2', '', '123LSKD', 'Book', '1 week', 'on loan', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-31002', '31', '1', '', 'QSQ452-S', 'Book', '1 week', 'available', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-30001', '30', '1', 'Reference', 'QSQS-52-S', 'Book', 'Not for loan', 'available', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-29001', '29', '1', '', 'AZD456-465', 'Book', '4 weeks', 'requested', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-28001', '28', '1', '', 'AZD5-456', 'Book', '4 weeks', 'available', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-27001', '27', '2', '', 'JLMQ-45-SQ', 'Book', '4 weeks', 'available', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-26001', '26', '1', '', 'AZD456-465', 'Book', '1 week', 'missing', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-25001', '25', '2', '', 'AGT-MLL5', 'Book', '4 weeks', 'on loan', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-24001', '24', '2', '', 'J56-475', 'Book', '4 weeks', 'available', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-23001', '23', '1', '', 'JHL-465.DS', 'Book', '4 weeks', 'requested', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-22001', '22', '1', '', 'AZD4E-865', 'Book', '1 week', 'requested', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); INSERT INTO crcITEM (barcode, id_bibrec, id_crcLIBRARY, collection, location, description, loan_period, status, creation_date, modification_date, number_of_requests) VALUES ('bc-21001', '21', '2', '', 'MLL-DS.63', 'Book', '4 weeks', 'available', '2008-07-21 00:00:00', '2008-07-21 00:00:00', '0'); -- crcLOAN demo data: INSERT INTO crcLOAN (id_crcBORROWER, id_bibrec, barcode, loaned_on, due_date, status, type, notes) VALUES ('4', '33', 'bc-33001', NOW(), NOW() + INTERVAL 30 DAY, 'on loan' ,'normal', ''); INSERT INTO crcLOAN (id_crcBORROWER, id_bibrec, barcode, loaned_on, due_date, status, type, notes) VALUES ('5', '31', 'bc-31001', NOW(), NOW() + INTERVAL 7 DAY, 'on loan' ,'normal', ''); INSERT INTO crcLOAN (id_crcBORROWER, id_bibrec, barcode, loaned_on, due_date, status, type, notes) VALUES ('5', '31', 'bc-25001', NOW(), NOW() + INTERVAL 30 DAY, 'on loan' ,'normal', ''); -- crcLOANREQUEST demo data: INSERT INTO crcLOANREQUEST (id_crcBORROWER, id_bibrec, barcode, period_of_interest_from, period_of_interest_to, status, notes, request_date) VALUES ('5', '34', 'bc-34002', NOW(), NOW() + INTERVAL 60 DAY, 'pending' , '', NOW()); INSERT INTO crcLOANREQUEST (id_crcBORROWER, id_bibrec, barcode, period_of_interest_from, period_of_interest_to, status, notes, request_date) VALUES ('6', '29', 'bc-29001', NOW(), NOW() + INTERVAL 45 DAY, 'pending' , '', NOW()); INSERT INTO crcLOANREQUEST (id_crcBORROWER, id_bibrec, barcode, period_of_interest_from, period_of_interest_to, status, notes, request_date) VALUES ('5', '33', 'bc-33001', NOW(), NOW() + INTERVAL 45 DAY, 'waiting' , '', NOW()); INSERT INTO crcLOANREQUEST (id_crcBORROWER, id_bibrec, barcode, period_of_interest_from, period_of_interest_to, status, notes, request_date) VALUES ('7', '22', 'bc-22001', NOW(), NOW() + INTERVAL 90 DAY, 'pending' , '', NOW()); -- crcBORROWER demo data: INSERT INTO crcBORROWER (name, email, phone, address, borrower_since, notes) VALUES ('Admin', 'admin@cds.cern.ch', '20003', '99-Z-019', '2008-07-21 00:00:00', ''); INSERT INTO crcBORROWER (name, email, phone, address, borrower_since, notes) VALUES ('Jekyll', 'jekyll@cds.cern.ch', '01234', '21-Z-019', '2008-07-21 00:00:00', ''); INSERT INTO crcBORROWER (name, email, phone, address, borrower_since, notes) VALUES ('Hyde', 'Hyde@cds.cern.ch', '01574', '22-Z-119', '2008-07-21 00:00:00', ''); INSERT INTO crcBORROWER (name, email, phone, address, borrower_since, notes) VALUES ('Dorian Gray', 'dorian.gray@cds.cern.ch', '33234', '38-Y-819', '2008-07-21 00:00:00', ''); INSERT INTO crcBORROWER (name, email, phone, address, borrower_since, notes) VALUES ('Romeo Montague', 'romeo.montague@cds.cern.ch', '93844', '98-W-859', '2008-07-21 00:00:00', ''); INSERT INTO crcBORROWER (name, email, phone, address, borrower_since, notes) VALUES ('Juliet Capulet', 'juliet.capulet@cds.cern.ch', '99874', '91-X-098', '2008-07-21 00:00:00', ''); INSERT INTO crcBORROWER (name, email, phone, address, borrower_since, notes) VALUES ('Benvolio Montague', 'benvolio.montague@cds.cern.ch', '32354', '93-P-019', '2008-07-21 00:00:00', ''); INSERT INTO crcBORROWER (name, email, phone, address, borrower_since, notes) VALUES ('Balthasar Montague', 'balthasar.montague@cds.cern.ch', '78644', '20-M-349', '2008-07-21 00:00:00', ''); -- switch on stemming for some indexes: UPDATE idxINDEX SET stemming_language='en' WHERE name IN ('global','abstract','keyword','title','fulltext'); -- exporting demo: INSERT INTO expJOB (jobname) VALUES ('sitemap'); INSERT INTO expJOB (jobname) VALUES ('googlescholar'); INSERT INTO expJOB (jobname) VALUES ('marcxml'); -- WebJournal demo: INSERT INTO jrnJOURNAL (id,name) VALUES(1,'AtlantisTimes'); INSERT INTO jrnISSUE (id_jrnJOURNAL,issue_number,issue_display,date_released,date_announced) VALUES (1,'02/2009','02-03/2009','2009-01-09','2009-01-09'); INSERT INTO jrnISSUE (id_jrnJOURNAL,issue_number,issue_display,date_released) VALUES (1,'03/2009','02-03/2009','2009-01-16'); -- end of file