-- +-------------------------------------------------+
-- © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
-- +-------------------------------------------------+
-- $Id: data_test.sql,v 1.26 2016-03-30 09:04:52 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_',0x613A31313A7B733A31313A2267656E6572655F6C69656E223B4E3B733A343A226D657265223B4E3B733A353A2266696C6C65223B4E3B733A31313A226E6F746963655F6D657265223B4E3B733A31323A226E6F746963655F66696C6C65223B4E3B733A383A226172745F6C696E6B223B733A313A2231223B733A393A2262756C6C5F6C696E6B223B733A313A2231223B733A31303A22706572696F5F6C696E6B223B733A313A2231223B733A31313A2262756C6C6574696E616765223B4E3B733A31303A226E6F746963655F617274223B4E3B733A31323A226E6F746963655F706572696F223B4E3B7D,'À 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 `empr`
--

INSERT INTO `empr` (`id_empr`, `empr_cb`, `empr_nom`, `empr_prenom`, `empr_adr1`, `empr_adr2`, `empr_cp`, `empr_ville`, `empr_pays`, `empr_mail`, `empr_tel1`, `empr_tel2`, `empr_prof`, `empr_year`, `empr_categ`, `empr_codestat`, `empr_creation`, `empr_modif`, `empr_sexe`, `empr_login`, `empr_password`, `empr_password_is_encrypted`, `empr_digest`, `empr_date_adhesion`, `empr_date_expiration`, `empr_msg`, `empr_lang`, `empr_ldap`, `type_abt`, `last_loan_date`, `empr_location`, `date_fin_blocage`, `total_loans`, `empr_statut`, `cle_validation`, `empr_sms`, `empr_subscription_action`) VALUES (1,'100001','Chewbacca','\"Chewie\"','Millenium Faucon','Deuxième tourelle gauche','01000','StarwarsTown','','','','','Pilote',1900,1,4,'2004-01-21 00:00:00','2010-07-30',1,'100001','66fK1ya07b0zE',1,'6ba07f894495f5259da5187909a96782','2004-01-21','2010-08-24','','fr_FR',0,0,NULL,1,'0000-00-00',0,1,'',0,NULL);
INSERT INTO `empr` (`id_empr`, `empr_cb`, `empr_nom`, `empr_prenom`, `empr_adr1`, `empr_adr2`, `empr_cp`, `empr_ville`, `empr_pays`, `empr_mail`, `empr_tel1`, `empr_tel2`, `empr_prof`, `empr_year`, `empr_categ`, `empr_codestat`, `empr_creation`, `empr_modif`, `empr_sexe`, `empr_login`, `empr_password`, `empr_password_is_encrypted`, `empr_digest`, `empr_date_adhesion`, `empr_date_expiration`, `empr_msg`, `empr_lang`, `empr_ldap`, `type_abt`, `last_loan_date`, `empr_location`, `date_fin_blocage`, `total_loans`, `empr_statut`, `cle_validation`, `empr_sms`, `empr_subscription_action`) VALUES (2,'100002','Solo','Han','Millenium Faucon','Cabine du commandant','01000','StarWarsTown','','','','','',1960,7,6,'2004-01-21 00:00:00','2010-07-30',1,'hsolo','66tNOU78zIeKs',1,'8ae973fd9cc3019e97ba5792b59cbfe1','2004-01-21','2010-11-21','','fr_FR',0,0,NULL,1,'0000-00-00',0,1,'',0,NULL);
INSERT INTO `empr` (`id_empr`, `empr_cb`, `empr_nom`, `empr_prenom`, `empr_adr1`, `empr_adr2`, `empr_cp`, `empr_ville`, `empr_pays`, `empr_mail`, `empr_tel1`, `empr_tel2`, `empr_prof`, `empr_year`, `empr_categ`, `empr_codestat`, `empr_creation`, `empr_modif`, `empr_sexe`, `empr_login`, `empr_password`, `empr_password_is_encrypted`, `empr_digest`, `empr_date_adhesion`, `empr_date_expiration`, `empr_msg`, `empr_lang`, `empr_ldap`, `type_abt`, `last_loan_date`, `empr_location`, `date_fin_blocage`, `total_loans`, `empr_statut`, `cle_validation`, `empr_sms`, `empr_subscription_action`) VALUES (3,'100003','Skywalker','Luke','','','01000','StarWarsTown','','','','','',1970,7,4,'2004-01-21 00:00:00','2010-07-30',1,'lskywalker','66rAoPFfiCXR6',1,'14bf4f3376ad2dea43dc86aaa851fba0','2004-01-21','2011-12-30','','fr_FR',0,0,NULL,1,'0000-00-00',0,1,'',0,NULL);
INSERT INTO `empr` (`id_empr`, `empr_cb`, `empr_nom`, `empr_prenom`, `empr_adr1`, `empr_adr2`, `empr_cp`, `empr_ville`, `empr_pays`, `empr_mail`, `empr_tel1`, `empr_tel2`, `empr_prof`, `empr_year`, `empr_categ`, `empr_codestat`, `empr_creation`, `empr_modif`, `empr_sexe`, `empr_login`, `empr_password`, `empr_password_is_encrypted`, `empr_digest`, `empr_date_adhesion`, `empr_date_expiration`, `empr_msg`, `empr_lang`, `empr_ldap`, `type_abt`, `last_loan_date`, `empr_location`, `date_fin_blocage`, `total_loans`, `empr_statut`, `cle_validation`, `empr_sms`, `empr_subscription_action`) VALUES (4,'100004','Leia','Princess','','','01000','StarWarsTown','','','','','',1972,7,6,'2004-01-21 00:00:00','2010-07-30',2,'100004','664AVSx68x6lU',1,'5dc042aa55344459e5ae4e6cbeebdd0c','2004-01-21','2010-11-20','','fr_FR',0,0,NULL,1,'0000-00-00',0,1,'',0,NULL);
INSERT INTO `empr` (`id_empr`, `empr_cb`, `empr_nom`, `empr_prenom`, `empr_adr1`, `empr_adr2`, `empr_cp`, `empr_ville`, `empr_pays`, `empr_mail`, `empr_tel1`, `empr_tel2`, `empr_prof`, `empr_year`, `empr_categ`, `empr_codestat`, `empr_creation`, `empr_modif`, `empr_sexe`, `empr_login`, `empr_password`, `empr_password_is_encrypted`, `empr_digest`, `empr_date_adhesion`, `empr_date_expiration`, `empr_msg`, `empr_lang`, `empr_ldap`, `type_abt`, `last_loan_date`, `empr_location`, `date_fin_blocage`, `total_loans`, `empr_statut`, `cle_validation`, `empr_sms`, `empr_subscription_action`) VALUES (5,'100005','Kenobi','Obiwan','','','01000','StarWarsTown','','','','','',1930,7,6,'2004-01-21 00:00:00','2010-07-30',1,'100005','66v0F2AcmeRqs',1,'6e6ff49173cd0f5d48efe6c70f5c340f','2004-01-21','2010-09-20','','fr_FR',0,0,NULL,1,'0000-00-00',0,1,'',0,NULL);
INSERT INTO `empr` (`id_empr`, `empr_cb`, `empr_nom`, `empr_prenom`, `empr_adr1`, `empr_adr2`, `empr_cp`, `empr_ville`, `empr_pays`, `empr_mail`, `empr_tel1`, `empr_tel2`, `empr_prof`, `empr_year`, `empr_categ`, `empr_codestat`, `empr_creation`, `empr_modif`, `empr_sexe`, `empr_login`, `empr_password`, `empr_password_is_encrypted`, `empr_digest`, `empr_date_adhesion`, `empr_date_expiration`, `empr_msg`, `empr_lang`, `empr_ldap`, `type_abt`, `last_loan_date`, `empr_location`, `date_fin_blocage`, `total_loans`, `empr_statut`, `cle_validation`, `empr_sms`, `empr_subscription_action`) VALUES (6,'100000','ROBERT','Eric','PMB Services','','72500','CHATEAU DU LOIR','','erobert@sigb.net','02 43 440 660','','Développeur PMB',0,3,3,'2004-01-21 00:00:00','2010-08-03',1,'erobert','666klmc51umJo',1,'8a8d1959357bd3b3b77769f571701be8','2004-01-21','2011-12-20','','fr_FR',0,0,NULL,1,'0000-00-00',0,1,'',0,NULL);
INSERT INTO `empr` (`id_empr`, `empr_cb`, `empr_nom`, `empr_prenom`, `empr_adr1`, `empr_adr2`, `empr_cp`, `empr_ville`, `empr_pays`, `empr_mail`, `empr_tel1`, `empr_tel2`, `empr_prof`, `empr_year`, `empr_categ`, `empr_codestat`, `empr_creation`, `empr_modif`, `empr_sexe`, `empr_login`, `empr_password`, `empr_password_is_encrypted`, `empr_digest`, `empr_date_adhesion`, `empr_date_expiration`, `empr_msg`, `empr_lang`, `empr_ldap`, `type_abt`, `last_loan_date`, `empr_location`, `date_fin_blocage`, `total_loans`, `empr_statut`, `cle_validation`, `empr_sms`, `empr_subscription_action`) VALUES (7,'100007','TETART','Florent','PMB Services','','72500','CHATEAU DU LOIR','','ftetart@sigb.net','','','Développeur PMB',1972,7,3,'2004-01-21 00:00:00','2010-07-30',1,'ftetart','66ezBGWSe7LGI',1,'0f50ce7b51ce4e04a5cf318a26be4ec9','2004-01-21','2011-03-20','','fr_FR',0,0,NULL,1,'0000-00-00',0,1,'',0,NULL);

--
-- 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','',0x613A343A7B733A363A22534541524348223B613A333A7B693A303B733A343A22665F3137223B693A313B733A343A22665F3332223B693A323B733A343A22665F3138223B7D693A303B613A353A7B733A363A22534541524348223B733A343A22665F3137223B733A323A224F50223B733A323A224551223B733A353A224649454C44223B613A313A7B693A303B733A323A223231223B7D733A353A22494E544552223B4E3B733A383A224649454C44564152223B4E3B7D693A313B613A353A7B733A363A22534541524348223B733A343A22665F3332223B733A323A224F50223B733A323A224551223B733A353A224649454C44223B613A313A7B693A303B733A323A223132223B7D733A353A22494E544552223B733A333A22616E64223B733A383A224649454C44564152223B4E3B7D693A323B613A353A7B733A363A22534541524348223B733A343A22665F3138223B733A323A224F50223B733A323A224551223B733A353A224649454C44223B613A323A7B693A303B733A313A2231223B693A313B733A313A2232223B7D733A353A22494E544552223B733A333A22616E64223B733A383A224649454C44564152223B4E3B7D7D,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[encoded data, 77944 characters],0x[encoded data, 6140 characters],'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[encoded data, 5194 characters],'','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[encoded data, 68100 characters],0x[encoded data, 4472 characters],'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[encoded data, 73218 characters],0xFFD8FFE000104A46494600010100000100010000FFFE003E43524541544F523A2067642D6A7065672076312E3020287573696E6720494A47204A50454720763632292C2064656661756C74207175616C6974790AFFDB004300080606070605080707070909080A0C140D0C0B0B0C1912130F141D1A1F1E1D1A1C1C20242E2720222C231C1C2837292C30313434341F27393D38323C2E333432FFDB0043010909090C0B0C180D0D1832211C213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232FFC00011080064005303012200021101031101FFC4001F0000010501010101010100000000000000000102030405060708090A0BFFC400B5100002010303020403050504040000017D01020300041105122131410613516107227114328191A1082342B1C11552D1F02433627282090A161718191A25262728292A3435363738393A434445464748494A535455565758595A636465666768696A737475767778797A838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE1E2E3E4E5E6E7E8E9EAF1F2F3F4F5F6F7F8F9FAFFC4001F0100030101010101010101010000000000000102030405060708090A0BFFC400B51100020102040403040705040400010277000102031104052131061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A262728292A35363738393A434445464748494A535455565758595A636465666768696A737475767778797A82838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE2E3E4E5E6E7E8E9EAF2F3F4F5F6F7F8F9FAFFDA000C03010002110311003F00E112F82F0C1B0694DF26F1F31F5E9D2A99C6703F3A318151ECD17ED19A2B7F01EAD8FA8AB36F7B0330FDEA8EFCD62E001498149D243555A3B3D3DEDA42099D71D36EEAEFB4636B33DBA42E8760C9039AF0DDA3D2B7FE1CDECD61E30BA9E00BBBECE22E4FABA37F24358D4A1A5EE6B0ADADAC7BEDDF968A3F783918AE6D4C697324455173D80E86B4D754BE9B76E58F18C9E79FFF0057E06BC0BCEB98643B2E668F07A248462B9E952E7BA37A9539126CF659122B694C80FDECF41E956A18A491C176207F2ED5E28353D495768D42E80EC3CD3FE35613C43ADA001754B8C7A16C835ABC34BB99FD663D8F7B4F3F60DBB36E38C93FE145787FFC261E231C7F6BCDFF008EFF0085153F539F745FD6A3D8E6A968CD213DABBCF3C5A4E680734668011BD3AE69345D60E8FA94D721739907E00647F5A56214126B19C6F8463EF1E4D4CB6B151DCEEAEFE24EA130658822A1E9EA2B14392D9F51CD73B1C59DA08393C715D006C30EBC54538A5B1739396E3F903AF152264ED3F5FC6A35E49EBD7BD4C80F15B5CC4928A519C734503B19D516EED8CFE3D69D3BF951EEC558D22CE2BC908B891A356202EDC0C127AF3DB19A96EC34AE40BD39C52F6AE8F5BF04EADE1FB48AF66884F6128CADC439214E7A3E47CA7F4F426B9C9B11A966E050A49ABA0716B720BB7D96F21079DA718ACE842BBE3701B57FAFFF005AA2BDD47CD531C40E0F526AAC6D7072CAA483DE9495C69D8D78631E7A0EBCE6B582AEEE7AFA573DA75DFF00A5AA49C1EC6BA0539390288AB049DC917A9E6A45E42F279EF9A6C63E63E99EB52C63E41918C74AB2490103B9FCE8A9474FFEB51480CAB88834641C1A82099ADA58C80308E08FCEB41D3E5E40C67D6AB49176C1A1AB8D3B1E97E2BF112DCFC2AB1B627125C4E09F9B248193FE7E95E27A85FBCE3C927853CF3D6B7EE6E6EE6D363B163BE2858B463B8CD72B242E9295943039FCEB3845C742E7252D4D0D374D5920FB5DC2FEEC1C2AFF0078D5D2EB19015513690318E39ABB1A7FC4A6CC83F2302320632703FAD66C88C04ADD002A339CE3AD3DC43AE614BD89944291DD44A1D5D7E5122F7CFBF23F0A66937EEF3FD9A6C671F29ABFA7CAB03C533C3BC79132B670C06E42A0F3D30C54D73F6995D5632A3077E3AD5444CEC176824F1F854A9C2E081DAA14048233530C90055105A1900727F2A280B903A51406855294C74C8E2AE98FD87B531A223B5032908F049AA577671BE58A827D6B59A3E38AAF32E41CE280314CCD6B6E6277261CE549E76547E7C771942E003D79EB8F6ABD7100914A301CD503A7C3BF95207B1A86AC522C4F7F0D9D948B0CDBA6994215DA30AB90C41CF7242FFDF3F9E6E936EF2DE894FDC5E73EF55A3B5959F98D8B7500835B56933C6CB14919438E0E319A1340D3355324F5C55953900E38C567C5213260000FD6B42356D982300D5DC9242FCF5CD1471E828A34117DC019E950C87AFAD4CCE08C66AB3BF6C8C9A432263EB55A4F4E31533B8C9C1FAE2A076F97AF7EB4EC08ACCBCF4A88818AB0CCB9EB519C73CD160202BD194E08E41AD4B4BEB3B945B6D4E3DAB8C0B8887CCBF51DEA882368F5A6305A994132A32712C43A62441B7DEDB4AA7EE18C6D38FC4935791704A8977A81C12B8ACF8701C0F6ABB13FCC69460D3BDCA94EEAD627C81FC2A7F0A298B22E06473455D999E87207C63A89FF009636BFF7CB7FF154C6F165FB758ADFFEF96FF1A28A0067FC2537BFF3CADFFEF96FF1A69F12DE9EB1C1FF007C9FF1A28A06869F115D9FF96507FDF27FC693FE121BBFF9E70FFDF27FC68A2800FF008486EFFE79C1FF007C9FF1A4FEDFBBFF009E70FE47FC68A2801CBE23BB539F2A03F553FE3522F8A2F973FBAB7E7FD93FE34514C05FF84AAFBFE795BFFDF2DFE345145023FFD9,'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[encoded data, 39930 characters],0x[encoded data, 7418 characters],'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[encoded data, 4164 characters],0xFFD8FFE000104A46494600010100000100010000FFFE003E43524541544F523A2067642D6A7065672076312E3020287573696E6720494A47204A50454720763632292C2064656661756C74207175616C6974790AFFDB004300080606070605080707070909080A0C140D0C0B0B0C1912130F141D1A1F1E1D1A1C1C20242E2720222C231C1C2837292C30313434341F27393D38323C2E333432FFDB0043010909090C0B0C180D0D1832211C213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232FFC00011080064003403012200021101031101FFC4001F0000010501010101010100000000000000000102030405060708090A0BFFC400B5100002010303020403050504040000017D01020300041105122131410613516107227114328191A1082342B1C11552D1F02433627282090A161718191A25262728292A3435363738393A434445464748494A535455565758595A636465666768696A737475767778797A838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE1E2E3E4E5E6E7E8E9EAF1F2F3F4F5F6F7F8F9FAFFC4001F0100030101010101010101010000000000000102030405060708090A0BFFC400B51100020102040403040705040400010277000102031104052131061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A262728292A35363738393A434445464748494A535455565758595A636465666768696A737475767778797A82838485868788898A92939495969798999AA2A3A4A5A6A7A8A9AAB2B3B4B5B6B7B8B9BAC2C3C4C5C6C7C8C9CAD2D3D4D5D6D7D8D9DAE2E3E4E5E6E7E8E9EAF2F3F4F5F6F7F8F9FAFFDA000C03010002110311003F00F7D1C0A5E940E94C9E58EDE179A57091A02CCC7B0A00A5A96B16DA6B469207796438444C13FE7FC29D6DA8DBDCBBC6ADB6446DA5588CE6B8F651ABDF79F772BC3217F323DA5782380391E871D2896F2E4BD959DA452C8D2CF1C3722DE2690DBA9EACEF865047520D70C713294BDD5A1D4E8C631D773BCE3147D2A2B6816DADA3810B158D4282C724FD4D4BF5AEE4731F30FED1BFF250AC3FEC151FFE8D968A5FDA37FE4A169FFF0060A8FF00F46CB45023E9BB8B88AD6079E7609120CB31EC2B8DD67589751550A8D1D9AB6464F2E7D4FF00855EF1F7DA878703C0B218D2756B8D99E23C1C9207500ED3FF00EAAE1AF35810691636C3696B89F2AEE76A05E84E7A0C1619E7A570E2A72BF22D8EBC3C13F7BA9D335AAEB0B05A594AF0CA84B09A3C718C6739EDD8FD6BB1B3B486CAD9618940039660A0176EEC71DCF7355747D1E2D22DB62B99256FBF2118C9F41E833DAB4AB7A147D9AD7732AB5399E9B0528E693A9A77E55B989F307ED1DFF250AC3FEC151FFE8D968A3F68D39F88561C7FCC2A3FFD1B2D1401F4CDC5B25DDACB6F28FDDCC851C77C11835F32DF1D5F4AD59BC39AAC88CD6B2ED24F3DB82AD8CE0820F3EA38AFA7D7818F4AF20F8D9A1858F4FF00105BC6A92249E44EE01C9046518FB021867DC0ACAAC1491BD09B8CAC7A4786F555D67C3F677BBCB48630B36460F98386E3EB9AD6AF31F851AC79A6EAC77B6C9505C46A7180C301C67A9EA9F91AF4E14E94B9A09B26B43926D077F7A5A4A70C639AD0C8F983F68DFF00928561FF0060A8FF00F46CB451FB477FC942B0C7FD02A3FF00D1B2D1401F4FF359FAEE9A9AC6857FA6BE3FD26078D4B0C85623838F6383F855FCFBFE94BF85034ECEE784F821068D78AD297FB55A4B960FC10B9DB20C7E3DEBDD1791904115E4BE3AF0FB693E248F52B63B2CEFD8F98013F2CA4E589F66193F5CF1EBE9DA4DC0B8D2EDD836E611857C7660307F5AE1C3F342ACA127E6766279674E3523E85DC71413ED4003BD1F88AEE388F987F68DFF00928561FF0060A8FF00F46CB451FB46FF00C942B0FF00B0547FFA365A2803E9ECF1D6819140E2979A00E6FC75A5DC6A9E1A93EC71892E6D9C5C471E092E541040C77C138AC2F86DAC3DF457293BFCCCA8D1AE4E38E0F5EFCAE7E95E83EC6BC56DF514F0CF8EB5287C97564BC678D02F011893C67B156AE2C4A54E71ACBA6FE876E1FF00790952FB8F69F71464FAD229E38229DDBFC2BB4E23E60FDA37FE4A1587FD82A3FF00D1B2D147ED1DFF00250AC3FEC151FF00E8D968A00FA740A71E9D3349DE97F1FD28010F5AF32F8A762B0CFA46B02351E5BB412B648C83F328FA70FF009D7A70C9CF18E78AC8F136871788BC3D77A5CBF289D3E47FEE38E54FE60567561CF07134A53E49A9153C1FABC7A9E925166599ADDBCB2E0E77291953F91C7FC06BA23ED5E39F0AB59FB15C4969347B16E9D63624E3638DDB7F3E47D715EC5CE2B3C34AF4ECDEAB434C4C396A3B6CF53E61FDA3BFE4A1D87FD82A3FFD1B2D147ED1BFF250AC3FEC151FFE8D968AE839CFA79BAD0B451400EEF4DCF19A28A00F9CF539E7D1FE235FD95A4D22C2B7DB80CE3BEEED807049C57D150B168949EA4034515CD455AA4ADE5FA9D788D69C3E7FA1F31FED1DFF00250AC3FEC151FF00E8D9A8A28AE9390FFFD9,'gif','scan2.gif',0,'','',0,'',1);

--
