-- +-------------------------------------------------+
-- © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
-- +-------------------------------------------------+
-- $Id: data_test.sql,v 1.14 2016-03-30 09:04:51 mbertin Exp $

--
-- Host: localhost    Database: bibli
-- ------------------------------------------------------


--
-- Table structure for table `entrepot_source_2`
--

CREATE TABLE `entrepot_source_2` (
  `connector_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `source_id` int(11) unsigned NOT NULL DEFAULT '0',
  `ref` varchar(220) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `date_import` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ufield` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_ind` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `usubfield` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_order` int(10) unsigned NOT NULL DEFAULT '0',
  `subfield_order` int(10) unsigned NOT NULL DEFAULT '0',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `i_value` text COLLATE utf8_unicode_ci NOT NULL,
  `recid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `search_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`connector_id`,`source_id`,`ref`,`ufield`,`usubfield`,`field_order`,`subfield_order`,`search_id`),
  KEY `usubfield` (`usubfield`),
  KEY `ufield_2` (`ufield`,`usubfield`),
  KEY `recid_2` (`recid`,`ufield`,`usubfield`),
  KEY `source_id` (`source_id`),
  KEY `i_recid_source_id` (`recid`,`source_id`),
  KEY `i_ref` (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `entrepot_source_4`
--

CREATE TABLE `entrepot_source_4` (
  `connector_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `source_id` int(11) unsigned NOT NULL DEFAULT '0',
  `ref` varchar(220) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `date_import` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ufield` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_ind` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `usubfield` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_order` int(10) unsigned NOT NULL DEFAULT '0',
  `subfield_order` int(10) unsigned NOT NULL DEFAULT '0',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `i_value` text COLLATE utf8_unicode_ci NOT NULL,
  `recid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `search_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`connector_id`,`source_id`,`ref`,`ufield`,`usubfield`,`field_order`,`subfield_order`,`search_id`),
  KEY `usubfield` (`usubfield`),
  KEY `ufield_2` (`ufield`,`usubfield`),
  KEY `recid_2` (`recid`,`ufield`,`usubfield`),
  KEY `source_id` (`source_id`),
  KEY `i_recid_source_id` (`recid`,`source_id`),
  KEY `i_ref` (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Table structure for table `entrepot_source_5`
--

CREATE TABLE `entrepot_source_5` (
  `connector_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `source_id` int(11) unsigned NOT NULL DEFAULT '0',
  `ref` varchar(220) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `date_import` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ufield` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_ind` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `usubfield` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field_order` int(10) unsigned NOT NULL DEFAULT '0',
  `subfield_order` int(10) unsigned NOT NULL DEFAULT '0',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `i_value` text COLLATE utf8_unicode_ci NOT NULL,
  `recid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `search_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`connector_id`,`source_id`,`ref`,`ufield`,`usubfield`,`field_order`,`subfield_order`,`search_id`),
  KEY `usubfield` (`usubfield`),
  KEY `ufield_2` (`ufield`,`usubfield`),
  KEY `recid_2` (`recid`,`ufield`,`usubfield`),
  KEY `source_id` (`source_id`),
  KEY `i_recid_source_id` (`recid`,`source_id`),
  KEY `i_ref` (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `analysis`
--

INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (1,33);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (1,35);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (1,36);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (1,37);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (1,38);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (1,39);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (1,40);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (1,41);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (2,25);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (2,26);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (2,29);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (2,30);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (2,31);
INSERT INTO `analysis` (`analysis_bulletin`, `analysis_notice`) VALUES (2,32);

--
-- Dumping data for table `authors`
--

INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (1,'70','Souton','Dominique','',0,'',' souton dominique ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (2,'70','Herzhaft','Gérard','',0,'http://perso.wanadoo.fr/cielj/charte/annuaire/herzhaft.htm',' herzhaft gerard ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (3,'70','Oppel','Jean-Hugues','1957-....',0,'http://www.ricochet-jeunes.org/auteur.asp?name=Oppel&surname=Jean-Hugues',' oppel jean hugues ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (4,'70','Zimmermann','Daniel','1935-2000',0,'http://www.humanite.presse.fr/journal/2000-12-08/2000-12-08-236014',' zimmermann daniel ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (5,'70','Causse','Rolande','1939-....',0,'http://www.ricochet-jeunes.org/auteur.asp?name=Causse&surname=Rolande',' causse rolande ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (6,'70','Riou','Jean-Michel','',0,'',' riou jean michel ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (7,'70','Taylor','Mildred D.','',0,'http://falcon.jmu.edu/~ramseyil/taylor.htm',' taylor mildred d ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (8,'70','Vassallo-Villaneau','Rose-Marie','1946-....',0,'',' vassallo villaneau rose marie ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (9,'70','Adamov','Philippe','1956-....',0,'http://www.lambiek.net/fr/adamov_philippe.html',' adamov philippe ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (10,'70','Lamquet','Chris','1954-....',0,'',' lamquet chris ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (11,'70','Gallié','Mathieu','',0,'',' gallie mathieu ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (12,'70','Andréaé','Jean-Baptiste','',0,'',' andreae jean baptiste ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (13,'70','Geerts','André','1955-....',0,'',' geerts andre ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (14,'70','Robin','Christian','1961-....',0,'',' robin christian ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (15,'70','Got','Yves','1939-....',0,'',' got yves ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (16,'70','Nuridsany','Claude','1946-....',0,'',' nuridsany claude ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (17,'70','Pérennou','Marie','1946-....',0,'',' perennou marie ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (18,'70','Overdulve','Cornelis Marinus','1929-....',0,'',' overdulve cornelis marinus ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (19,'71','Editions Michelin','','',0,'',' editions michelin ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (20,'70','Brouwers','Pierre','',0,'',' brouwers pierre ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (21,'70','Loyola','Annabel','',0,'',' loyola annabel ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (22,'70','Brouwers','Magali','',0,'',' brouwers magali ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (23,'70','Reuter','Philippe','',0,'',' reuter philippe ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (24,'71','Conseil général du Maine-et-Loire (CG49)','','',0,'',' conseil general du maine et loire cg49 ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (25,'70','Prigent','Daniel','',0,'',' prigent daniel ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (26,'70','Hunot','Jean-Yves','',0,'',' hunot jean yves ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (27,'71','Altaïr productions multimédia','','',0,'',' altair productions multimedia ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (28,'70','Rezay','Guillaume de','',0,'',' rezay guillaume de ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (30,'71','sound-fishing.net','','',0,'',' sound fishing net ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (31,'70','Bride','Philip','',0,'',' bride philip ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (32,'70','Marion','Alain','',0,'',' marion alain ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (33,'70','Favulier','Jacques','',0,'',' favulier jacques ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (34,'70','Cassini de Thury','César-François','',0,'',' cassini de thury cesar francois ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (35,'70','Fraxler','Hans','',0,'',' fraxler hans ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (36,'70','Bourrier','Théodore','',0,'',' bourrier theodore ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (37,'70','Robinson','Patrick','',0,'',' robinson patrick ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (38,'70','Langlois-Chassaignon','Claudie','1937-....',0,'',' langlois chassaignon claudie ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (39,'70','Orieux','Eugène','1823-1901',0,'',' orieux eugene ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (40,'70','Pichard','Georges','1920-2003',0,'',' pichard georges ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (41,'70','Zola','Émile','1840-1902',0,'',' zola emile ',NULL,'','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (42,'70','Allen','David','1945-....',0,'',' allen david ','','','','','','',0);
INSERT INTO `authors` (`author_id`, `author_type`, `author_name`, `author_rejete`, `author_date`, `author_see`, `author_web`, `index_author`, `author_comment`, `author_lieu`, `author_ville`, `author_pays`, `author_subdivision`, `author_numero`, `author_import_denied`) VALUES (43,'70','Delannoy','Claude','1946-....',0,'',' delannoy claude ','','','','','','',0);

--
-- Dumping data for table `bannette_abon`
--

INSERT INTO `bannette_abon` (`num_bannette`, `num_empr`, `actif`, `bannette_mail`) VALUES (1,5,0,'');
INSERT INTO `bannette_abon` (`num_bannette`, `num_empr`, `actif`, `bannette_mail`) VALUES (1,4,0,'');
INSERT INTO `bannette_abon` (`num_bannette`, `num_empr`, `actif`, `bannette_mail`) VALUES (1,3,0,'');
INSERT INTO `bannette_abon` (`num_bannette`, `num_empr`, `actif`, `bannette_mail`) VALUES (1,2,0,'');

--
-- Dumping data for table `bannette_contenu`
--

INSERT INTO `bannette_contenu` (`num_bannette`, `num_notice`, `date_ajout`) VALUES (1,6,'2012-11-30 10:51:43');

--
-- Dumping data for table `bannette_equation`
--

INSERT INTO `bannette_equation` (`num_bannette`, `num_equation`) VALUES (1,1);

--
-- Dumping data for table `bannettes`
--

INSERT INTO `bannettes` (`id_bannette`, `num_classement`, `nom_bannette`, `comment_gestion`, `comment_public`, `entete_mail`, `date_last_remplissage`, `date_last_envoi`, `proprio_bannette`, `bannette_auto`, `periodicite`, `diffusion_email`, `categorie_lecteurs`, `nb_notices_diff`, `num_panier`, `limite_type`, `limite_nombre`, `update_type`, `typeexport`, `prefixe_fichier`, `param_export`, `piedpage_mail`, `notice_tpl`, `group_type`, `group_pperso`, `display_notice_in_every_group`, `statut_not_account`, `archive_number`, `document_generate`, `document_notice_tpl`, `document_insert_docnum`, `document_group`, `document_add_summary`, `groupe_lecteurs`, `bannette_opac_accueil`, `bannette_tpl_num`, `bannette_aff_notice_number`) VALUES (1,2,'Nouveautés romans policiers','Bannette contenant les nouveautés de la bibliothèque dans la section \"Romans policiers\"','Nouveautés romans policiers','Bonjour,\r\n\r\nVoici les derniers ouvrages policiers/thrillers/détectives de la bibliothèque.\r\nEn vous connectant sur votre compte du site web de la bibliothèque vous aurez la possibilité d\'en voir plus et de réserver votre préféré.','2012-11-30 11:51:43','1970-01-01 00:00:00',0,1,30,1,7,5,0,'',0,'C','','prefix_',0x[BLOB],'À bientôt,\r\n\r\nBien cordialement,\r\n\r\nL\'équipe de la bibliothèque.',4,0,0,0,0,1,0,0,0,0,0,0,0,0,1);

--
-- Dumping data for table `bulletins`
--

INSERT INTO `bulletins` (`bulletin_id`, `bulletin_numero`, `bulletin_notice`, `mention_date`, `date_date`, `bulletin_titre`, `index_titre`, `bulletin_cb`, `num_notice`) VALUES (1,'277',24,'','2004-08-04','','  ','',0);
INSERT INTO `bulletins` (`bulletin_id`, `bulletin_numero`, `bulletin_notice`, `mention_date`, `date_date`, `bulletin_titre`, `index_titre`, `bulletin_cb`, `num_notice`) VALUES (2,'278',24,'','2004-08-04','','  ','',60);

--
-- Dumping data for table `caddie_content`
--

INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (5,17,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (5,19,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (6,1,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (6,2,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (5,42,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (5,46,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (7,44,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (7,47,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (5,41,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (5,32,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (5,49,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (7,50,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (7,48,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (7,51,'','',NULL);
INSERT INTO `caddie_content` (`caddie_id`, `object_id`, `content`, `blob_type`, `flag`) VALUES (5,25,'','',NULL);

--
-- Dumping data for table `collections`
--

INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (1,'Médium',1,'',' medium ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (2,'Collection dirigée par Claude Gutman',2,'',' collection dirigee par claude gutman ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (3,'Mini souris noire',3,'',' mini souris noire ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (4,'Nouvelles',4,'',' nouvelles ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (5,'Les |uns, les autres',3,'',' uns autres ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (6,'Sueurs froides',5,'',' sueurs froides ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (7,'Castor poche',6,'',' castor poche ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (8,'Dayak.',7,'',' dayak ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (11,'Paroles',10,'',' paroles ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (12,'LOCAL',13,'',' local ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (13,'DVD guides',14,'',' dvd guides ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (14,'Collection Folio benjamin',21,'',' collection folio benjamin ','','',0);
INSERT INTO `collections` (`collection_id`, `collection_name`, `collection_parent`, `collection_issn`, `index_coll`, `collection_web`, `collection_comment`, `authority_import_denied`) VALUES (15,'BD adultes',24,'',' bd adultes ','','',0);

--
-- Dumping data for table `connectors_categ`
--

INSERT INTO `connectors_categ` (`connectors_categ_id`, `connectors_categ_name`, `opac_expanded`) VALUES (1,'Bibliothèques publiques',1);

--
-- Dumping data for table `connectors_categ_sources`
--

INSERT INTO `connectors_categ_sources` (`num_categ`, `num_source`) VALUES (1,2);

--
-- Dumping data for table `connectors_sources`
--

INSERT INTO `connectors_sources` (`source_id`, `id_connector`, `parameters`, `comment`, `name`, `repository`, `timeout`, `retry`, `ttl`, `opac_allowed`, `rep_upload`, `upload_doc_num`, `enrichment`, `opac_affiliate_search`, `opac_selected`, `type_enrichment_allowed`, `ico_notice`, `last_sync_date`) VALUES (2,'z3950','a:10:{s:3:\"url\";s:12:\"z3950.bnf.fr\";s:10:\"z3950_base\";s:9:\"TOUT-UTF8\";s:11:\"z3950_login\";s:5:\"Z3950\";s:14:\"z3950_password\";s:9:\"Z3950_BNF\";s:17:\"z3950_max_notices\";s:3:\"100\";s:12:\"z3950_format\";s:7:\"unimarc\";s:10:\"z3950_port\";s:4:\"2211\";s:13:\"z3950_convert\";s:1:\"0\";s:12:\"z3950_profil\";s:6:\"simple\";s:10:\"z3950_bib1\";a:546:{s:19:\"bib1_200a_BOOLEAN_0\";s:1:\"4\";s:19:\"bib1_200a_BOOLEAN_1\";s:1:\"3\";s:19:\"bib1_200a_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_200a_BOOLEAN_3\";s:1:\"2\";s:19:\"bib1_200a_BOOLEAN_4\";s:0:\"\";s:19:\"bib1_200a_BOOLEAN_5\";s:0:\"\";s:21:\"bib1_200a_STARTWITH_0\";s:1:\"4\";s:21:\"bib1_200a_STARTWITH_1\";s:1:\"3\";s:21:\"bib1_200a_STARTWITH_2\";s:0:\"\";s:21:\"bib1_200a_STARTWITH_3\";s:1:\"1\";s:21:\"bib1_200a_STARTWITH_4\";s:0:\"\";s:21:\"bib1_200a_STARTWITH_5\";s:0:\"\";s:19:\"bib1_200a_ENDWITH_0\";s:1:\"4\";s:19:\"bib1_200a_ENDWITH_1\";s:0:\"\";s:19:\"bib1_200a_ENDWITH_2\";s:0:\"\";s:19:\"bib1_200a_ENDWITH_3\";s:0:\"\";s:19:\"bib1_200a_ENDWITH_4\";s:0:\"\";s:19:\"bib1_200a_ENDWITH_5\";s:0:\"\";s:17:\"bib1_200a_EXACT_0\";s:1:\"4\";s:17:\"bib1_200a_EXACT_1\";s:1:\"3\";s:17:\"bib1_200a_EXACT_2\";s:0:\"\";s:17:\"bib1_200a_EXACT_3\";s:1:\"1\";s:17:\"bib1_200a_EXACT_4\";s:0:\"\";s:17:\"bib1_200a_EXACT_5\";s:0:\"\";s:18:\"bib1_XXX_BOOLEAN_0\";s:4:\"1016\";s:18:\"bib1_XXX_BOOLEAN_1\";s:1:\"3\";s:18:\"bib1_XXX_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_XXX_BOOLEAN_3\";s:1:\"2\";s:18:\"bib1_XXX_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_XXX_BOOLEAN_5\";s:0:\"\";s:18:\"bib1_7XX_BOOLEAN_0\";s:4:\"1003\";s:18:\"bib1_7XX_BOOLEAN_1\";s:1:\"3\";s:18:\"bib1_7XX_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_7XX_BOOLEAN_3\";s:1:\"2\";s:18:\"bib1_7XX_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_7XX_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_7XX_STARTWITH_0\";s:4:\"1003\";s:20:\"bib1_7XX_STARTWITH_1\";s:1:\"3\";s:20:\"bib1_7XX_STARTWITH_2\";s:0:\"\";s:20:\"bib1_7XX_STARTWITH_3\";s:1:\"1\";s:20:\"bib1_7XX_STARTWITH_4\";s:0:\"\";s:20:\"bib1_7XX_STARTWITH_5\";s:0:\"\";s:18:\"bib1_7XX_ENDWITH_0\";s:4:\"1003\";s:18:\"bib1_7XX_ENDWITH_1\";s:0:\"\";s:18:\"bib1_7XX_ENDWITH_2\";s:0:\"\";s:18:\"bib1_7XX_ENDWITH_3\";s:0:\"\";s:18:\"bib1_7XX_ENDWITH_4\";s:0:\"\";s:18:\"bib1_7XX_ENDWITH_5\";s:0:\"\";s:16:\"bib1_7XX_EXACT_0\";s:4:\"1003\";s:16:\"bib1_7XX_EXACT_1\";s:1:\"3\";s:16:\"bib1_7XX_EXACT_2\";s:0:\"\";s:16:\"bib1_7XX_EXACT_3\";s:1:\"1\";s:16:\"bib1_7XX_EXACT_4\";s:0:\"\";s:16:\"bib1_7XX_EXACT_5\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_0\";s:9:\"1018,1020\";s:19:\"bib1_210c_BOOLEAN_1\";s:1:\"3\";s:19:\"bib1_210c_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_3\";s:1:\"2\";s:19:\"bib1_210c_BOOLEAN_4\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_5\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_0\";s:9:\"1018,1020\";s:21:\"bib1_210c_STARTWITH_1\";s:1:\"3\";s:21:\"bib1_210c_STARTWITH_2\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_3\";s:1:\"1\";s:21:\"bib1_210c_STARTWITH_4\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_5\";s:0:\"\";s:19:\"bib1_210c_ENDWITH_0\";s:9:\"1018,1020\";s:19:\"bib1_210c_ENDWITH_1\";s:0:\"\";s:19:\"bib1_210c_ENDWITH_2\";s:0:\"\";s:19:\"bib1_210c_ENDWITH_3\";s:0:\"\";s:19:\"bib1_210c_ENDWITH_4\";s:0:\"\";s:19:\"bib1_210c_ENDWITH_5\";s:0:\"\";s:17:\"bib1_210c_EXACT_0\";s:9:\"1018,1020\";s:17:\"bib1_210c_EXACT_1\";s:1:\"3\";s:17:\"bib1_210c_EXACT_2\";s:0:\"\";s:17:\"bib1_210c_EXACT_3\";s:1:\"1\";s:17:\"bib1_210c_EXACT_4\";s:0:\"\";s:17:\"bib1_210c_EXACT_5\";s:0:\"\";s:29:\"bib1_210d_CONTAINS_AT_LEAST_0\";s:0:\"\";s:29:\"bib1_210d_CONTAINS_AT_LEAST_1\";s:0:\"\";s:29:\"bib1_210d_CONTAINS_AT_LEAST_2\";s:0:\"\";s:29:\"bib1_210d_CONTAINS_AT_LEAST_3\";s:0:\"\";s:29:\"bib1_210d_CONTAINS_AT_LEAST_4\";s:0:\"\";s:29:\"bib1_210d_CONTAINS_AT_LEAST_5\";s:0:\"\";s:24:\"bib1_210d_CONTAINS_ALL_0\";s:0:\"\";s:24:\"bib1_210d_CONTAINS_ALL_1\";s:0:\"\";s:24:\"bib1_210d_CONTAINS_ALL_2\";s:0:\"\";s:24:\"bib1_210d_CONTAINS_ALL_3\";s:0:\"\";s:24:\"bib1_210d_CONTAINS_ALL_4\";s:0:\"\";s:24:\"bib1_210d_CONTAINS_ALL_5\";s:0:\"\";s:21:\"bib1_210d_STARTWITH_0\";s:0:\"\";s:21:\"bib1_210d_STARTWITH_1\";s:1:\"3\";s:21:\"bib1_210d_STARTWITH_2\";s:0:\"\";s:21:\"bib1_210d_STARTWITH_3\";s:1:\"1\";s:21:\"bib1_210d_STARTWITH_4\";s:0:\"\";s:21:\"bib1_210d_STARTWITH_5\";s:0:\"\";s:19:\"bib1_210d_ENDWITH_0\";s:0:\"\";s:19:\"bib1_210d_ENDWITH_1\";s:0:\"\";s:19:\"bib1_210d_ENDWITH_2\";s:0:\"\";s:19:\"bib1_210d_ENDWITH_3\";s:0:\"\";s:19:\"bib1_210d_ENDWITH_4\";s:0:\"\";s:19:\"bib1_210d_ENDWITH_5\";s:0:\"\";s:17:\"bib1_210d_EXACT_0\";s:0:\"\";s:17:\"bib1_210d_EXACT_1\";s:1:\"3\";s:17:\"bib1_210d_EXACT_2\";s:0:\"\";s:17:\"bib1_210d_EXACT_3\";s:1:\"1\";s:17:\"bib1_210d_EXACT_4\";s:0:\"\";s:17:\"bib1_210d_EXACT_5\";s:0:\"\";s:14:\"bib1_210d_EQ_0\";s:0:\"\";s:14:\"bib1_210d_EQ_1\";s:1:\"3\";s:14:\"bib1_210d_EQ_2\";s:0:\"\";s:14:\"bib1_210d_EQ_3\";s:1:\"1\";s:14:\"bib1_210d_EQ_4\";s:0:\"\";s:14:\"bib1_210d_EQ_5\";s:0:\"\";s:14:\"bib1_210d_LT_0\";s:0:\"\";s:14:\"bib1_210d_LT_1\";s:1:\"1\";s:14:\"bib1_210d_LT_2\";s:0:\"\";s:14:\"bib1_210d_LT_3\";s:1:\"1\";s:14:\"bib1_210d_LT_4\";s:0:\"\";s:14:\"bib1_210d_LT_5\";s:0:\"\";s:14:\"bib1_210d_GT_0\";s:0:\"\";s:14:\"bib1_210d_GT_1\";s:1:\"5\";s:14:\"bib1_210d_GT_2\";s:0:\"\";s:14:\"bib1_210d_GT_3\";s:1:\"1\";s:14:\"bib1_210d_GT_4\";s:0:\"\";s:14:\"bib1_210d_GT_5\";s:0:\"\";s:16:\"bib1_210d_LTEQ_0\";s:0:\"\";s:16:\"bib1_210d_LTEQ_1\";s:0:\"\";s:16:\"bib1_210d_LTEQ_2\";s:0:\"\";s:16:\"bib1_210d_LTEQ_3\";s:0:\"\";s:16:\"bib1_210d_LTEQ_4\";s:0:\"\";s:16:\"bib1_210d_LTEQ_5\";s:0:\"\";s:16:\"bib1_210d_GTEQ_0\";s:0:\"\";s:16:\"bib1_210d_GTEQ_1\";s:1:\"4\";s:16:\"bib1_210d_GTEQ_2\";s:0:\"\";s:16:\"bib1_210d_GTEQ_3\";s:1:\"1\";s:16:\"bib1_210d_GTEQ_4\";s:0:\"\";s:16:\"bib1_210d_GTEQ_5\";s:0:\"\";s:23:\"bib1_225a410t_BOOLEAN_0\";s:1:\"5\";s:23:\"bib1_225a410t_BOOLEAN_1\";s:1:\"3\";s:23:\"bib1_225a410t_BOOLEAN_2\";s:0:\"\";s:23:\"bib1_225a410t_BOOLEAN_3\";s:1:\"2\";s:23:\"bib1_225a410t_BOOLEAN_4\";s:0:\"\";s:23:\"bib1_225a410t_BOOLEAN_5\";s:0:\"\";s:25:\"bib1_225a410t_STARTWITH_0\";s:1:\"5\";s:25:\"bib1_225a410t_STARTWITH_1\";s:1:\"3\";s:25:\"bib1_225a410t_STARTWITH_2\";s:0:\"\";s:25:\"bib1_225a410t_STARTWITH_3\";s:1:\"1\";s:25:\"bib1_225a410t_STARTWITH_4\";s:0:\"\";s:25:\"bib1_225a410t_STARTWITH_5\";s:0:\"\";s:23:\"bib1_225a410t_ENDWITH_0\";s:1:\"5\";s:23:\"bib1_225a410t_ENDWITH_1\";s:0:\"\";s:23:\"bib1_225a410t_ENDWITH_2\";s:0:\"\";s:23:\"bib1_225a410t_ENDWITH_3\";s:0:\"\";s:23:\"bib1_225a410t_ENDWITH_4\";s:0:\"\";s:23:\"bib1_225a410t_ENDWITH_5\";s:0:\"\";s:21:\"bib1_225a410t_EXACT_0\";s:1:\"5\";s:21:\"bib1_225a410t_EXACT_1\";s:1:\"3\";s:21:\"bib1_225a410t_EXACT_2\";s:0:\"\";s:21:\"bib1_225a410t_EXACT_3\";s:1:\"1\";s:21:\"bib1_225a410t_EXACT_4\";s:0:\"\";s:21:\"bib1_225a410t_EXACT_5\";s:0:\"\";s:23:\"bib1_225i411t_BOOLEAN_0\";s:0:\"\";s:23:\"bib1_225i411t_BOOLEAN_1\";s:1:\"3\";s:23:\"bib1_225i411t_BOOLEAN_2\";s:0:\"\";s:23:\"bib1_225i411t_BOOLEAN_3\";s:1:\"2\";s:23:\"bib1_225i411t_BOOLEAN_4\";s:0:\"\";s:23:\"bib1_225i411t_BOOLEAN_5\";s:0:\"\";s:25:\"bib1_225i411t_STARTWITH_0\";s:0:\"\";s:25:\"bib1_225i411t_STARTWITH_1\";s:1:\"3\";s:25:\"bib1_225i411t_STARTWITH_2\";s:0:\"\";s:25:\"bib1_225i411t_STARTWITH_3\";s:1:\"1\";s:25:\"bib1_225i411t_STARTWITH_4\";s:0:\"\";s:25:\"bib1_225i411t_STARTWITH_5\";s:0:\"\";s:23:\"bib1_225i411t_ENDWITH_0\";s:0:\"\";s:23:\"bib1_225i411t_ENDWITH_1\";s:0:\"\";s:23:\"bib1_225i411t_ENDWITH_2\";s:0:\"\";s:23:\"bib1_225i411t_ENDWITH_3\";s:0:\"\";s:23:\"bib1_225i411t_ENDWITH_4\";s:0:\"\";s:23:\"bib1_225i411t_ENDWITH_5\";s:0:\"\";s:21:\"bib1_225i411t_EXACT_0\";s:0:\"\";s:21:\"bib1_225i411t_EXACT_1\";s:1:\"3\";s:21:\"bib1_225i411t_EXACT_2\";s:0:\"\";s:21:\"bib1_225i411t_EXACT_3\";s:1:\"1\";s:21:\"bib1_225i411t_EXACT_4\";s:0:\"\";s:21:\"bib1_225i411t_EXACT_5\";s:0:\"\";s:19:\"bib1_461t_BOOLEAN_0\";s:1:\"5\";s:19:\"bib1_461t_BOOLEAN_1\";s:1:\"3\";s:19:\"bib1_461t_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_461t_BOOLEAN_3\";s:1:\"2\";s:19:\"bib1_461t_BOOLEAN_4\";s:0:\"\";s:19:\"bib1_461t_BOOLEAN_5\";s:0:\"\";s:21:\"bib1_461t_STARTWITH_0\";s:1:\"5\";s:21:\"bib1_461t_STARTWITH_1\";s:1:\"3\";s:21:\"bib1_461t_STARTWITH_2\";s:0:\"\";s:21:\"bib1_461t_STARTWITH_3\";s:1:\"1\";s:21:\"bib1_461t_STARTWITH_4\";s:0:\"\";s:21:\"bib1_461t_STARTWITH_5\";s:0:\"\";s:19:\"bib1_461t_ENDWITH_0\";s:1:\"5\";s:19:\"bib1_461t_ENDWITH_1\";s:0:\"\";s:19:\"bib1_461t_ENDWITH_2\";s:0:\"\";s:19:\"bib1_461t_ENDWITH_3\";s:0:\"\";s:19:\"bib1_461t_ENDWITH_4\";s:0:\"\";s:19:\"bib1_461t_ENDWITH_5\";s:0:\"\";s:17:\"bib1_461t_EXACT_0\";s:1:\"5\";s:17:\"bib1_461t_EXACT_1\";s:1:\"3\";s:17:\"bib1_461t_EXACT_2\";s:0:\"\";s:17:\"bib1_461t_EXACT_3\";s:1:\"1\";s:17:\"bib1_461t_EXACT_4\";s:0:\"\";s:17:\"bib1_461t_EXACT_5\";s:0:\"\";s:14:\"bib1_461t_EQ_0\";s:1:\"5\";s:14:\"bib1_461t_EQ_1\";s:1:\"3\";s:14:\"bib1_461t_EQ_2\";s:0:\"\";s:14:\"bib1_461t_EQ_3\";s:1:\"1\";s:14:\"bib1_461t_EQ_4\";s:0:\"\";s:14:\"bib1_461t_EQ_5\";s:0:\"\";s:21:\"bib1_010a_STARTWITH_0\";s:8:\"7,8,1214\";s:21:\"bib1_010a_STARTWITH_1\";s:1:\"3\";s:21:\"bib1_010a_STARTWITH_2\";s:0:\"\";s:21:\"bib1_010a_STARTWITH_3\";s:1:\"1\";s:21:\"bib1_010a_STARTWITH_4\";s:0:\"\";s:21:\"bib1_010a_STARTWITH_5\";s:0:\"\";s:19:\"bib1_500a_BOOLEAN_0\";s:0:\"\";s:19:\"bib1_500a_BOOLEAN_1\";s:1:\"3\";s:19:\"bib1_500a_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_500a_BOOLEAN_3\";s:1:\"2\";s:19:\"bib1_500a_BOOLEAN_4\";s:0:\"\";s:19:\"bib1_500a_BOOLEAN_5\";s:0:\"\";s:21:\"bib1_500a_STARTWITH_0\";s:0:\"\";s:21:\"bib1_500a_STARTWITH_1\";s:1:\"3\";s:21:\"bib1_500a_STARTWITH_2\";s:0:\"\";s:21:\"bib1_500a_STARTWITH_3\";s:1:\"1\";s:21:\"bib1_500a_STARTWITH_4\";s:0:\"\";s:21:\"bib1_500a_STARTWITH_5\";s:0:\"\";s:19:\"bib1_500a_ENDWITH_0\";s:0:\"\";s:19:\"bib1_500a_ENDWITH_1\";s:0:\"\";s:19:\"bib1_500a_ENDWITH_2\";s:0:\"\";s:19:\"bib1_500a_ENDWITH_3\";s:0:\"\";s:19:\"bib1_500a_ENDWITH_4\";s:0:\"\";s:19:\"bib1_500a_ENDWITH_5\";s:0:\"\";s:17:\"bib1_500a_EXACT_0\";s:0:\"\";s:17:\"bib1_500a_EXACT_1\";s:1:\"3\";s:17:\"bib1_500a_EXACT_2\";s:0:\"\";s:17:\"bib1_500a_EXACT_3\";s:1:\"1\";s:17:\"bib1_500a_EXACT_4\";s:0:\"\";s:17:\"bib1_500a_EXACT_5\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_0\";s:2:\"63\";s:18:\"bib1_300_BOOLEAN_1\";s:1:\"3\";s:18:\"bib1_300_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_3\";s:1:\"2\";s:18:\"bib1_300_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_300_STARTWITH_0\";s:2:\"63\";s:20:\"bib1_300_STARTWITH_1\";s:1:\"3\";s:20:\"bib1_300_STARTWITH_2\";s:0:\"\";s:20:\"bib1_300_STARTWITH_3\";s:1:\"1\";s:20:\"bib1_300_STARTWITH_4\";s:0:\"\";s:20:\"bib1_300_STARTWITH_5\";s:0:\"\";s:18:\"bib1_300_ENDWITH_0\";s:2:\"63\";s:18:\"bib1_300_ENDWITH_1\";s:0:\"\";s:18:\"bib1_300_ENDWITH_2\";s:0:\"\";s:18:\"bib1_300_ENDWITH_3\";s:0:\"\";s:18:\"bib1_300_ENDWITH_4\";s:0:\"\";s:18:\"bib1_300_ENDWITH_5\";s:0:\"\";s:16:\"bib1_300_EXACT_0\";s:2:\"63\";s:16:\"bib1_300_EXACT_1\";s:1:\"3\";s:16:\"bib1_300_EXACT_2\";s:0:\"\";s:16:\"bib1_300_EXACT_3\";s:1:\"1\";s:16:\"bib1_300_EXACT_4\";s:0:\"\";s:16:\"bib1_300_EXACT_5\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_0\";s:2:\"62\";s:18:\"bib1_327_BOOLEAN_1\";s:1:\"3\";s:18:\"bib1_327_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_3\";s:1:\"2\";s:18:\"bib1_327_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_327_STARTWITH_0\";s:2:\"62\";s:20:\"bib1_327_STARTWITH_1\";s:1:\"3\";s:20:\"bib1_327_STARTWITH_2\";s:0:\"\";s:20:\"bib1_327_STARTWITH_3\";s:1:\"1\";s:20:\"bib1_327_STARTWITH_4\";s:0:\"\";s:20:\"bib1_327_STARTWITH_5\";s:0:\"\";s:18:\"bib1_327_ENDWITH_0\";s:2:\"62\";s:18:\"bib1_327_ENDWITH_1\";s:0:\"\";s:18:\"bib1_327_ENDWITH_2\";s:0:\"\";s:18:\"bib1_327_ENDWITH_3\";s:0:\"\";s:18:\"bib1_327_ENDWITH_4\";s:0:\"\";s:18:\"bib1_327_ENDWITH_5\";s:0:\"\";s:16:\"bib1_327_EXACT_0\";s:2:\"62\";s:16:\"bib1_327_EXACT_1\";s:1:\"3\";s:16:\"bib1_327_EXACT_2\";s:0:\"\";s:16:\"bib1_327_EXACT_3\";s:1:\"1\";s:16:\"bib1_327_EXACT_4\";s:0:\"\";s:16:\"bib1_327_EXACT_5\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_0\";s:5:\"62,63\";s:18:\"bib1_330_BOOLEAN_1\";s:1:\"3\";s:18:\"bib1_330_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_3\";s:1:\"2\";s:18:\"bib1_330_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_330_STARTWITH_0\";s:5:\"62,63\";s:20:\"bib1_330_STARTWITH_1\";s:1:\"3\";s:20:\"bib1_330_STARTWITH_2\";s:0:\"\";s:20:\"bib1_330_STARTWITH_3\";s:1:\"1\";s:20:\"bib1_330_STARTWITH_4\";s:0:\"\";s:20:\"bib1_330_STARTWITH_5\";s:0:\"\";s:18:\"bib1_330_ENDWITH_0\";s:5:\"62,63\";s:18:\"bib1_330_ENDWITH_1\";s:0:\"\";s:18:\"bib1_330_ENDWITH_2\";s:0:\"\";s:18:\"bib1_330_ENDWITH_3\";s:0:\"\";s:18:\"bib1_330_ENDWITH_4\";s:0:\"\";s:18:\"bib1_330_ENDWITH_5\";s:0:\"\";s:16:\"bib1_330_EXACT_0\";s:5:\"62,63\";s:16:\"bib1_330_EXACT_1\";s:1:\"3\";s:16:\"bib1_330_EXACT_2\";s:0:\"\";s:16:\"bib1_330_EXACT_3\";s:1:\"1\";s:16:\"bib1_330_EXACT_4\";s:0:\"\";s:16:\"bib1_330_EXACT_5\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_0\";s:5:\"62,63\";s:18:\"bib1_3XX_BOOLEAN_1\";s:1:\"3\";s:18:\"bib1_3XX_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_3\";s:1:\"2\";s:18:\"bib1_3XX_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_0\";s:5:\"62,63\";s:20:\"bib1_3XX_STARTWITH_1\";s:1:\"3\";s:20:\"bib1_3XX_STARTWITH_2\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_3\";s:1:\"1\";s:20:\"bib1_3XX_STARTWITH_4\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_5\";s:0:\"\";s:18:\"bib1_3XX_ENDWITH_0\";s:5:\"62,63\";s:18:\"bib1_3XX_ENDWITH_1\";s:0:\"\";s:18:\"bib1_3XX_ENDWITH_2\";s:0:\"\";s:18:\"bib1_3XX_ENDWITH_3\";s:0:\"\";s:18:\"bib1_3XX_ENDWITH_4\";s:0:\"\";s:18:\"bib1_3XX_ENDWITH_5\";s:0:\"\";s:16:\"bib1_3XX_EXACT_0\";s:5:\"62,63\";s:16:\"bib1_3XX_EXACT_1\";s:1:\"3\";s:16:\"bib1_3XX_EXACT_2\";s:0:\"\";s:16:\"bib1_3XX_EXACT_3\";s:1:\"1\";s:16:\"bib1_3XX_EXACT_4\";s:0:\"\";s:16:\"bib1_3XX_EXACT_5\";s:0:\"\";s:18:\"bib1_60X_BOOLEAN_0\";s:2:\"21\";s:18:\"bib1_60X_BOOLEAN_1\";s:1:\"3\";s:18:\"bib1_60X_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_60X_BOOLEAN_3\";s:1:\"2\";s:18:\"bib1_60X_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_60X_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_60X_STARTWITH_0\";s:2:\"21\";s:20:\"bib1_60X_STARTWITH_1\";s:1:\"3\";s:20:\"bib1_60X_STARTWITH_2\";s:0:\"\";s:20:\"bib1_60X_STARTWITH_3\";s:1:\"1\";s:20:\"bib1_60X_STARTWITH_4\";s:0:\"\";s:20:\"bib1_60X_STARTWITH_5\";s:0:\"\";s:18:\"bib1_60X_ENDWITH_0\";s:2:\"21\";s:18:\"bib1_60X_ENDWITH_1\";s:0:\"\";s:18:\"bib1_60X_ENDWITH_2\";s:0:\"\";s:18:\"bib1_60X_ENDWITH_3\";s:0:\"\";s:18:\"bib1_60X_ENDWITH_4\";s:0:\"\";s:18:\"bib1_60X_ENDWITH_5\";s:0:\"\";s:16:\"bib1_60X_EXACT_0\";s:2:\"21\";s:16:\"bib1_60X_EXACT_1\";s:1:\"3\";s:16:\"bib1_60X_EXACT_2\";s:0:\"\";s:16:\"bib1_60X_EXACT_3\";s:1:\"1\";s:16:\"bib1_60X_EXACT_4\";s:0:\"\";s:16:\"bib1_60X_EXACT_5\";s:0:\"\";s:23:\"bib1_676a686a_BOOLEAN_0\";s:0:\"\";s:23:\"bib1_676a686a_BOOLEAN_1\";s:1:\"3\";s:23:\"bib1_676a686a_BOOLEAN_2\";s:0:\"\";s:23:\"bib1_676a686a_BOOLEAN_3\";s:1:\"2\";s:23:\"bib1_676a686a_BOOLEAN_4\";s:0:\"\";s:23:\"bib1_676a686a_BOOLEAN_5\";s:0:\"\";s:25:\"bib1_676a686a_STARTWITH_0\";s:0:\"\";s:25:\"bib1_676a686a_STARTWITH_1\";s:1:\"3\";s:25:\"bib1_676a686a_STARTWITH_2\";s:0:\"\";s:25:\"bib1_676a686a_STARTWITH_3\";s:1:\"1\";s:25:\"bib1_676a686a_STARTWITH_4\";s:0:\"\";s:25:\"bib1_676a686a_STARTWITH_5\";s:0:\"\";s:23:\"bib1_676a686a_ENDWITH_0\";s:0:\"\";s:23:\"bib1_676a686a_ENDWITH_1\";s:0:\"\";s:23:\"bib1_676a686a_ENDWITH_2\";s:0:\"\";s:23:\"bib1_676a686a_ENDWITH_3\";s:0:\"\";s:23:\"bib1_676a686a_ENDWITH_4\";s:0:\"\";s:23:\"bib1_676a686a_ENDWITH_5\";s:0:\"\";s:21:\"bib1_676a686a_EXACT_0\";s:0:\"\";s:21:\"bib1_676a686a_EXACT_1\";s:1:\"3\";s:21:\"bib1_676a686a_EXACT_2\";s:0:\"\";s:21:\"bib1_676a686a_EXACT_3\";s:1:\"1\";s:21:\"bib1_676a686a_EXACT_4\";s:0:\"\";s:21:\"bib1_676a686a_EXACT_5\";s:0:\"\";s:18:\"bib1_610_BOOLEAN_0\";s:2:\"21\";s:18:\"bib1_610_BOOLEAN_1\";s:1:\"3\";s:18:\"bib1_610_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_610_BOOLEAN_3\";s:1:\"2\";s:18:\"bib1_610_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_610_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_610_STARTWITH_0\";s:2:\"21\";s:20:\"bib1_610_STARTWITH_1\";s:1:\"3\";s:20:\"bib1_610_STARTWITH_2\";s:0:\"\";s:20:\"bib1_610_STARTWITH_3\";s:1:\"1\";s:20:\"bib1_610_STARTWITH_4\";s:0:\"\";s:20:\"bib1_610_STARTWITH_5\";s:0:\"\";s:18:\"bib1_610_ENDWITH_0\";s:2:\"21\";s:18:\"bib1_610_ENDWITH_1\";s:0:\"\";s:18:\"bib1_610_ENDWITH_2\";s:0:\"\";s:18:\"bib1_610_ENDWITH_3\";s:0:\"\";s:18:\"bib1_610_ENDWITH_4\";s:0:\"\";s:18:\"bib1_610_ENDWITH_5\";s:0:\"\";s:16:\"bib1_610_EXACT_0\";s:2:\"21\";s:16:\"bib1_610_EXACT_1\";s:1:\"3\";s:16:\"bib1_610_EXACT_2\";s:0:\"\";s:16:\"bib1_610_EXACT_3\";s:1:\"1\";s:16:\"bib1_610_EXACT_4\";s:0:\"\";s:16:\"bib1_610_EXACT_5\";s:0:\"\";s:14:\"bib1_101a_EQ_0\";s:2:\"54\";s:14:\"bib1_101a_EQ_1\";s:1:\"3\";s:14:\"bib1_101a_EQ_2\";s:0:\"\";s:14:\"bib1_101a_EQ_3\";s:1:\"1\";s:14:\"bib1_101a_EQ_4\";s:0:\"\";s:14:\"bib1_101a_EQ_5\";s:0:\"\";s:14:\"bib1_101c_EQ_0\";s:0:\"\";s:14:\"bib1_101c_EQ_1\";s:1:\"3\";s:14:\"bib1_101c_EQ_2\";s:0:\"\";s:14:\"bib1_101c_EQ_3\";s:1:\"1\";s:14:\"bib1_101c_EQ_4\";s:0:\"\";s:14:\"bib1_101c_EQ_5\";s:0:\"\";s:12:\"bib1_bl_EQ_0\";s:4:\"1021\";s:12:\"bib1_bl_EQ_1\";s:1:\"3\";s:12:\"bib1_bl_EQ_2\";s:0:\"\";s:12:\"bib1_bl_EQ_3\";s:1:\"1\";s:12:\"bib1_bl_EQ_4\";s:0:\"\";s:12:\"bib1_bl_EQ_5\";s:0:\"\";s:12:\"bib1_dt_EQ_0\";s:4:\"1031\";s:12:\"bib1_dt_EQ_1\";s:1:\"3\";s:12:\"bib1_dt_EQ_2\";s:0:\"\";s:12:\"bib1_dt_EQ_3\";s:1:\"1\";s:12:\"bib1_dt_EQ_4\";s:0:\"\";s:12:\"bib1_dt_EQ_5\";s:0:\"\";s:19:\"bib1_FORBIDDEN_EQ_0\";N;s:19:\"bib1_FORBIDDEN_EQ_1\";N;s:19:\"bib1_FORBIDDEN_EQ_2\";N;s:19:\"bib1_FORBIDDEN_EQ_3\";N;s:19:\"bib1_FORBIDDEN_EQ_4\";N;s:19:\"bib1_FORBIDDEN_EQ_5\";N;s:25:\"bib1_FORBIDDEN_CONTAINS_0\";N;s:25:\"bib1_FORBIDDEN_CONTAINS_1\";N;s:25:\"bib1_FORBIDDEN_CONTAINS_2\";N;s:25:\"bib1_FORBIDDEN_CONTAINS_3\";N;s:25:\"bib1_FORBIDDEN_CONTAINS_4\";N;s:25:\"bib1_FORBIDDEN_CONTAINS_5\";N;s:26:\"bib1_FORBIDDEN_STARTWITH_0\";N;s:26:\"bib1_FORBIDDEN_STARTWITH_1\";N;s:26:\"bib1_FORBIDDEN_STARTWITH_2\";N;s:26:\"bib1_FORBIDDEN_STARTWITH_3\";N;s:26:\"bib1_FORBIDDEN_STARTWITH_4\";N;s:26:\"bib1_FORBIDDEN_STARTWITH_5\";N;s:22:\"bib1_FORBIDDEN_EXACT_0\";N;s:22:\"bib1_FORBIDDEN_EXACT_1\";N;s:22:\"bib1_FORBIDDEN_EXACT_2\";N;s:22:\"bib1_FORBIDDEN_EXACT_3\";N;s:22:\"bib1_FORBIDDEN_EXACT_4\";N;s:22:\"bib1_FORBIDDEN_EXACT_5\";N;s:24:\"bib1_FORBIDDEN_ENDWITH_0\";N;s:24:\"bib1_FORBIDDEN_ENDWITH_1\";N;s:24:\"bib1_FORBIDDEN_ENDWITH_2\";N;s:24:\"bib1_FORBIDDEN_ENDWITH_3\";N;s:24:\"bib1_FORBIDDEN_ENDWITH_4\";N;s:24:\"bib1_FORBIDDEN_ENDWITH_5\";N;s:34:\"bib1_FORBIDDEN_CONTAINS_AT_LEAST_0\";N;s:34:\"bib1_FORBIDDEN_CONTAINS_AT_LEAST_1\";N;s:34:\"bib1_FORBIDDEN_CONTAINS_AT_LEAST_2\";N;s:34:\"bib1_FORBIDDEN_CONTAINS_AT_LEAST_3\";N;s:34:\"bib1_FORBIDDEN_CONTAINS_AT_LEAST_4\";N;s:34:\"bib1_FORBIDDEN_CONTAINS_AT_LEAST_5\";N;s:29:\"bib1_FORBIDDEN_CONTAINS_ALL_0\";N;s:29:\"bib1_FORBIDDEN_CONTAINS_ALL_1\";N;s:29:\"bib1_FORBIDDEN_CONTAINS_ALL_2\";N;s:29:\"bib1_FORBIDDEN_CONTAINS_ALL_3\";N;s:29:\"bib1_FORBIDDEN_CONTAINS_ALL_4\";N;s:29:\"bib1_FORBIDDEN_CONTAINS_ALL_5\";N;s:19:\"bib1_FORBIDDEN_LT_0\";N;s:19:\"bib1_FORBIDDEN_LT_1\";N;s:19:\"bib1_FORBIDDEN_LT_2\";N;s:19:\"bib1_FORBIDDEN_LT_3\";N;s:19:\"bib1_FORBIDDEN_LT_4\";N;s:19:\"bib1_FORBIDDEN_LT_5\";N;s:19:\"bib1_FORBIDDEN_GT_0\";N;s:19:\"bib1_FORBIDDEN_GT_1\";N;s:19:\"bib1_FORBIDDEN_GT_2\";N;s:19:\"bib1_FORBIDDEN_GT_3\";N;s:19:\"bib1_FORBIDDEN_GT_4\";N;s:19:\"bib1_FORBIDDEN_GT_5\";N;s:21:\"bib1_FORBIDDEN_LTEQ_0\";N;s:21:\"bib1_FORBIDDEN_LTEQ_1\";N;s:21:\"bib1_FORBIDDEN_LTEQ_2\";N;s:21:\"bib1_FORBIDDEN_LTEQ_3\";N;s:21:\"bib1_FORBIDDEN_LTEQ_4\";N;s:21:\"bib1_FORBIDDEN_LTEQ_5\";N;s:21:\"bib1_FORBIDDEN_GTEQ_0\";N;s:21:\"bib1_FORBIDDEN_GTEQ_1\";N;s:21:\"bib1_FORBIDDEN_GTEQ_2\";N;s:21:\"bib1_FORBIDDEN_GTEQ_3\";N;s:21:\"bib1_FORBIDDEN_GTEQ_4\";N;s:21:\"bib1_FORBIDDEN_GTEQ_5\";N;s:12:\"bib1_dc_EQ_0\";s:2:\"30\";s:12:\"bib1_dc_EQ_1\";s:1:\"3\";s:12:\"bib1_dc_EQ_2\";s:0:\"\";s:12:\"bib1_dc_EQ_3\";s:1:\"1\";s:12:\"bib1_dc_EQ_4\";s:0:\"\";s:12:\"bib1_dc_EQ_5\";s:0:\"\";s:12:\"bib1_dc_LT_0\";s:2:\"30\";s:12:\"bib1_dc_LT_1\";s:1:\"1\";s:12:\"bib1_dc_LT_2\";s:0:\"\";s:12:\"bib1_dc_LT_3\";s:1:\"1\";s:12:\"bib1_dc_LT_4\";s:0:\"\";s:12:\"bib1_dc_LT_5\";s:0:\"\";s:12:\"bib1_dc_GT_0\";s:2:\"30\";s:12:\"bib1_dc_GT_1\";s:1:\"5\";s:12:\"bib1_dc_GT_2\";s:0:\"\";s:12:\"bib1_dc_GT_3\";s:1:\"1\";s:12:\"bib1_dc_GT_4\";s:0:\"\";s:12:\"bib1_dc_GT_5\";s:0:\"\";s:14:\"bib1_dc_LTEQ_0\";s:2:\"30\";s:14:\"bib1_dc_LTEQ_1\";s:0:\"\";s:14:\"bib1_dc_LTEQ_2\";s:0:\"\";s:14:\"bib1_dc_LTEQ_3\";s:0:\"\";s:14:\"bib1_dc_LTEQ_4\";s:0:\"\";s:14:\"bib1_dc_LTEQ_5\";s:0:\"\";s:14:\"bib1_dc_GTEQ_0\";s:2:\"30\";s:14:\"bib1_dc_GTEQ_1\";s:1:\"4\";s:14:\"bib1_dc_GTEQ_2\";s:0:\"\";s:14:\"bib1_dc_GTEQ_3\";s:1:\"1\";s:14:\"bib1_dc_GTEQ_4\";s:0:\"\";s:14:\"bib1_dc_GTEQ_5\";s:0:\"\";s:20:\"bib1_856u_CONTAINS_0\";s:0:\"\";s:20:\"bib1_856u_CONTAINS_1\";s:0:\"\";s:20:\"bib1_856u_CONTAINS_2\";s:0:\"\";s:20:\"bib1_856u_CONTAINS_3\";s:0:\"\";s:20:\"bib1_856u_CONTAINS_4\";s:0:\"\";s:20:\"bib1_856u_CONTAINS_5\";s:0:\"\";s:20:\"bib1_463v_CONTAINS_0\";s:0:\"\";s:20:\"bib1_463v_CONTAINS_1\";s:0:\"\";s:20:\"bib1_463v_CONTAINS_2\";s:0:\"\";s:20:\"bib1_463v_CONTAINS_3\";s:0:\"\";s:20:\"bib1_463v_CONTAINS_4\";s:0:\"\";s:20:\"bib1_463v_CONTAINS_5\";s:0:\"\";}}','','BnF',2,45,3,1800,1,0,1,0,0,0,'a:0:{}','','0000-00-00 00:00:00');
INSERT INTO `connectors_sources` (`source_id`, `id_connector`, `parameters`, `comment`, `name`, `repository`, `timeout`, `retry`, `ttl`, `opac_allowed`, `rep_upload`, `upload_doc_num`, `enrichment`, `opac_affiliate_search`, `opac_selected`, `type_enrichment_allowed`, `ico_notice`, `last_sync_date`) VALUES (4,'wikipedia','a:0:{}','','Wikipédia',2,5,3,1800,0,0,1,1,0,0,'a:2:{i:0;s:4:\"wiki\";i:1;s:3:\"bio\";}','','0000-00-00 00:00:00');
INSERT INTO `connectors_sources` (`source_id`, `id_connector`, `parameters`, `comment`, `name`, `repository`, `timeout`, `retry`, `ttl`, `opac_allowed`, `rep_upload`, `upload_doc_num`, `enrichment`, `opac_affiliate_search`, `opac_selected`, `type_enrichment_allowed`, `ico_notice`, `last_sync_date`) VALUES (5,'google_book','a:2:{s:5:\"width\";i:500;s:6:\"height\";i:500;}','','Google Book',2,5,3,1800,1,0,0,1,0,0,'a:1:{i:0;s:5:\"books\";}','','0000-00-00 00:00:00');

--
-- Dumping data for table `entrepot_source_2`
--


--
-- Dumping data for table `entrepot_source_4`
--


--
-- Dumping data for table `entrepot_source_5`
--


--
-- Dumping data for table `equations`
--

INSERT INTO `equations` (`id_equation`, `num_classement`, `nom_equation`, `comment_equation`, `requete`, `proprio_equation`) VALUES (1,3,'Nouveautés policiers adultes','',0x[BLOB],0);

--
-- Dumping data for table `exemplaires`
--

INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (1,'33700004388761',1,0,1,'JR SOU',13,1,1,11,'2004-08-03','0000-00-00','','',1,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (2,'22020295067',2,0,1,'JR HER',13,1,7,11,'2004-08-03','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (3,'33700003413727',3,0,1,'ER OPP',12,1,1,11,'2004-08-03','0000-00-00','','',2,6,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (4,'33700003470461',4,0,1,'R ZIM',24,1,1,12,'2004-08-03','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:25:04',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (5,'33700003719453',5,0,1,'JR CAU',13,1,1,11,'2004-08-04','0000-00-00','','',1,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:44:44',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (6,'33700003550072',6,0,1,'RX RIO',21,11,7,12,'2004-08-04','0000-00-00','Reliure bibliographique très abîmée. Comparer coût réparation et rééquipement. ','',1,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:44:29',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (7,'33700004389030',7,0,1,'JRK TAY',13,1,7,11,'2004-08-04','2004-08-04','','EUR 3,8',1,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:44:44',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (8,'33700004389026',7,0,1,'JRK TAY',13,1,1,11,'2004-08-04','0000-00-00','','EUR 3,8',1,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:44:44',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (9,'33700003669468',8,0,1,'BD ADA',16,1,7,12,'2004-08-04','2004-08-04','','EUR 11,',2,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:25:04',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (10,'33700003669484',9,0,1,'BD ADA',16,1,1,12,'2004-08-04','0000-00-00','','',1,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:44:29',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (11,'33700003669485',10,0,1,'BD ADA',26,12,1,12,'2004-08-04','2004-08-04','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (12,'33700004243164',11,0,1,'JBD LAM',17,1,1,12,'2004-08-04','2004-08-04','','10,40 €',2,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:44:29',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (13,'33700003868672',12,0,1,'JBD GAL',20,1,1,11,'2004-08-04','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (14,'33700004243347',13,0,1,'EBD GEE',17,1,1,11,'2004-08-04','0000-00-00','','',1,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:44:44',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (15,'33700003453202',14,0,1,'J 808 PAR',25,1,1,11,'2004-08-04','0000-00-00','','',1,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:44:44',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (16,'33700004118010',15,0,1,'582 NUR',10,1,1,12,'2004-08-04','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (17,'33700003286792',16,0,1,'967 OVE',10,1,1,12,'2004-08-04','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:44:29',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (18,'3370000451290',18,0,14,'DVD TF1',10,1,1,12,'2004-08-04','0000-00-00','vérifier la présence du livret avant de prêter','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (19,'3370000451291',17,0,16,'910 MIC',10,1,1,12,'2004-08-04','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (20,'3370000451292',19,0,17,'CDROM LOI',10,1,1,12,'2004-08-04','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (21,'3370000451294',0,2,18,'MAG GEO',10,1,7,12,'2004-08-04','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:25:04',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (22,'3370000451293',0,1,18,'MAG GEO',10,1,1,12,'2004-08-04','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:25:04',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (23,'3370000451295',42,0,15,'MANUSCRIPT',18,13,1,12,'2004-08-04','2004-08-04','Document sorti du fond ancien','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (24,'3370000451296',44,0,13,'CD COC',10,13,1,12,'2004-08-04','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (25,'3370000451301',46,0,13,'780 BRI',10,1,7,10,'2004-08-04','0000-00-00','','',1,0,'2005-08-10','2005-01-01 00:00:00','2005-08-10 11:59:36',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (26,'3370000451298',47,0,15,'590 RUS',10,13,1,12,'2004-08-05','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (27,'3370000451299',48,0,15,'680 FAV',10,13,1,12,'2004-08-05','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (28,'3370000451300',50,0,1,'JR COC',13,1,1,12,'2004-08-05','0000-00-00','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (29,'3370000451302',51,0,1,'590 BOU',10,1,1,12,'2004-08-05','2004-08-05','','',2,0,NULL,'2005-01-01 00:00:00','2005-08-10 11:25:04',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (30,'33700004500167',53,0,1,'RK ROB',10,1,1,12,'2004-08-05','2004-08-05','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (32,'6438646236',2,0,1,'R HER',13,1,1,12,'2004-09-13','2004-09-13','','',2,0,NULL,'2005-01-01 00:00:00','2005-06-22 12:15:28',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (33,'12',58,0,1,'658.4 ALL',10,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-11-30 14:57:31','2012-11-30 13:57:31',0,0,0,'',1,0,0,0);
INSERT INTO `exemplaires` (`expl_id`, `expl_cb`, `expl_notice`, `expl_bulletin`, `expl_typdoc`, `expl_cote`, `expl_section`, `expl_statut`, `expl_location`, `expl_codestat`, `expl_date_depot`, `expl_date_retour`, `expl_note`, `expl_prix`, `expl_owner`, `expl_lastempr`, `last_loan_date`, `create_date`, `update_date`, `type_antivol`, `transfert_location_origine`, `transfert_statut_origine`, `expl_comment`, `expl_nbparts`, `expl_retloc`, `expl_abt_num`, `transfert_section_origine`) VALUES (34,'16',59,0,1,'005.1 DEL',10,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-11-30 15:03:41','2012-11-30 14:03:41',0,0,0,'',1,0,0,0);

--
-- Dumping data for table `explnum`
--

INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (1,42,0,'Reproduction basse qualité','image/jpeg','',0x[BLOB],0x[BLOB],'jpg','charte.jpg',0,'','',0,'',1);
INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (2,42,0,'Retranscription','text/plain','',0x[BLOB],'','txt','charte.txt',0,'','',0,'',1);
INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (3,42,0,'Sceau','image/gif','',0x[BLOB],0x[BLOB],'GIF','chartesceau.GIF',0,'','',0,'',1);
INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (4,42,0,'contre-sceau','image/gif','',0x[BLOB],0x[BLOB],'GIF','chartecontresceau.GIF',0,'','',0,'',1);
INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (5,46,0,'Adagio En Sol Mineur (Albinoni T.)','URL','http://multimedia.fnac.com/multimedia/asp/audio.asp?Z=L%27Adagio+d%27Albinoni&Y=346265&T=Adagio+En+Sol+Mineur+%28Albinoni+T%2E%29&N=Albinoni&P=Tomaso&M=Forlane&E=3399240165271&V=1&I=1&G=E&audio=/1/7/2/3399240165271A01.ra','','','','',0,'','',0,'',1);
INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (6,46,0,'Pochette','URL','http://multimedia.fnac.com/multimedia/images_produits/grandes/1/7/2/3399240165271.JPG',NULL,'','',NULL,0,'','',0,'',1);
INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (7,46,0,'Canon En Re Majeur (Pachelbel J.)','URL','http://multimedia.fnac.com/multimedia/asp/audio.asp?Z=L%27Adagio+d%27Albinoni&Y=346265&T=Canon+En+Re+Majeur+%28Pachelbel+J%2E%29&N=Albinoni&P=Tomaso&M=Forlane&E=3399240165271&V=1&I=6&G=E&audio=/1/7/2/3399240165271A06.ra',NULL,'','',NULL,0,'','',0,'',1);
INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (8,46,0,'Choral N 6 Tire De La Cantata Bwv 147 \'\'Jesus Que Ma Joie Demeure\'\' (Bach J.S.)','URL','http://multimedia.fnac.com/multimedia/asp/audio.asp?Z=L%27Adagio+d%27Albinoni&Y=346265&T=Choral+N+6+Tire+De+La+Cantata+Bwv+147+%27%27Jesus+Que+Ma+Joie+De&N=Albinoni&P=Tomaso&M=Forlane&E=3399240165271&V=1&I=5&G=E&audio=/1/7/2/3399240165271A05.ra',NULL,'','',NULL,0,'','',0,'',1);
INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (9,47,0,'reproduction basse qualité','image/gif','',0x[BLOB],0x[BLOB],'gif','scan.gif',0,'','',0,'',1);
INSERT INTO `explnum` (`explnum_id`, `explnum_notice`, `explnum_bulletin`, `explnum_nom`, `explnum_mimetype`, `explnum_url`, `explnum_data`, `explnum_vignette`, `explnum_extfichier`, `explnum_nomfichier`, `explnum_statut`, `explnum_index_sew`, `explnum_index_wew`, `explnum_repertoire`, `explnum_path`, `explnum_docnum_statut`) VALUES (10,48,0,'photo','image/gif','',0x[BLOB],0x[BLOB],'gif','scan2.gif',0,'','',0,'',1);

--
