-- Dumping data for table `collection_custom`
--


--
-- Table structure for table `collection_custom_lists`
--

CREATE TABLE collection_custom_lists (
  collection_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  collection_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  collection_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY editorial_custom_champ (collection_custom_champ),
  KEY editorial_champ_list_value (collection_custom_champ,collection_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collection_custom_lists`
--


--
-- Table structure for table `collection_custom_values`
--

CREATE TABLE collection_custom_values (
  collection_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  collection_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  collection_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  collection_custom_text text COLLATE utf8_unicode_ci,
  collection_custom_integer int(11) DEFAULT NULL,
  collection_custom_date date DEFAULT NULL,
  collection_custom_float float DEFAULT NULL,
  KEY editorial_custom_champ (collection_custom_champ),
  KEY editorial_custom_origine (collection_custom_origine),
  KEY i_ccv_st (collection_custom_small_text),
  KEY i_ccv_t (collection_custom_text(255)),
  KEY i_ccv_i (collection_custom_integer),
  KEY i_ccv_d (collection_custom_date),
  KEY i_ccv_f (collection_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collection_custom_values`
--


--
-- Table structure for table `collections`
--

CREATE TABLE collections (
  collection_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  collection_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  collection_parent mediumint(8) unsigned NOT NULL DEFAULT '0',
  collection_issn varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  index_coll mediumtext COLLATE utf8_unicode_ci,
  collection_web mediumtext COLLATE utf8_unicode_ci NOT NULL,
  collection_comment mediumtext COLLATE utf8_unicode_ci NOT NULL,
  authority_import_denied int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (collection_id),
  KEY collection_name (collection_name),
  KEY collection_parent (collection_parent)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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 (4,'Écoutez lire',13,'',' ecoutez lire ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (5,'Collection dirigée par Henri Gougaud',6,'',' collection dirigee par henri gougaud ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (6,'Un Livre, un cd',9,'1766-148X',' livre cd ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (7,'Crea.jeunesse',6,'',' crea jeunesse ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (8,'Bayou',13,'',' bayou ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (9,'Fragments',15,'',' fragments ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (10,'L.d.p.jeunesse',17,'',' p jeunesse ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (12,'Sagesse d\'un métier',19,'',' sagesse metier ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (13,'Le métier de',20,'',' metier ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (14,'Que sais-je ?',21,'',' que sais je ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (16,'Collection Série noire',13,'',' collection serie noire ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (17,'Folio cadet',23,'',' folio cadet ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (18,'Les encyclopes',26,'',' encyclopes ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (19,'À petits petons',9,'',' petits petons ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (20,'Kididoc',29,'',' kididoc ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (21,'Folio',13,'',' folio ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (24,'Littérature étrangère',35,'',' litterature etrangere ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (25,'Revue dada',36,'',' revue dada ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (26,'Album',37,'',' album ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (27,'Mes Premières Découvertes de la Musique',38,'',' mes premieres decouvertes musique ','','',0);
INSERT INTO collections (collection_id, collection_name, collection_parent, collection_issn, index_coll, collection_web, collection_comment, authority_import_denied) VALUES (28,'Collection Warner',40,'',' collection warner ','','',0);

--
-- Table structure for table `collections_state`
--

CREATE TABLE collections_state (
  collstate_id int(8) NOT NULL AUTO_INCREMENT,
  id_serial mediumint(8) unsigned NOT NULL DEFAULT '0',
  location_id smallint(5) unsigned NOT NULL DEFAULT '0',
  state_collections mediumtext COLLATE utf8_unicode_ci NOT NULL,
  collstate_emplacement int(8) unsigned NOT NULL DEFAULT '0',
  collstate_type int(8) unsigned NOT NULL DEFAULT '0',
  collstate_origine varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  collstate_cote varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  collstate_archive varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  collstate_statut int(8) unsigned NOT NULL DEFAULT '0',
  collstate_lacune mediumtext COLLATE utf8_unicode_ci NOT NULL,
  collstate_note mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (collstate_id),
  KEY i_colls_arc (collstate_archive),
  KEY i_colls_empl (collstate_emplacement),
  KEY i_colls_type (collstate_type),
  KEY i_colls_orig (collstate_origine),
  KEY i_colls_cote (collstate_cote),
  KEY i_colls_stat (collstate_statut),
  KEY i_colls_serial (id_serial),
  KEY i_colls_loc (location_id)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collections_state`
--

INSERT INTO collections_state (collstate_id, id_serial, location_id, state_collections, collstate_emplacement, collstate_type, collstate_origine, collstate_cote, collstate_archive, collstate_statut, collstate_lacune, collstate_note) VALUES (2,124,1,'T. 28, n° 5, 1983 -',4,2,'','','',3,'','');
INSERT INTO collections_state (collstate_id, id_serial, location_id, state_collections, collstate_emplacement, collstate_type, collstate_origine, collstate_cote, collstate_archive, collstate_statut, collstate_lacune, collstate_note) VALUES (3,120,1,'N° 393, 2011 ; N° 402, 2012 - ',2,1,'','PER GEO','',1,'','');
INSERT INTO collections_state (collstate_id, id_serial, location_id, state_collections, collstate_emplacement, collstate_type, collstate_origine, collstate_cote, collstate_archive, collstate_statut, collstate_lacune, collstate_note) VALUES (4,129,1,'2012 -',1,1,'','PER J GEO','',1,'','');
INSERT INTO collections_state (collstate_id, id_serial, location_id, state_collections, collstate_emplacement, collstate_type, collstate_origine, collstate_cote, collstate_archive, collstate_statut, collstate_lacune, collstate_note) VALUES (5,132,1,'1 année',1,1,'','PER STU','',1,'','');

--
-- Table structure for table `collstate_custom`
--

CREATE TABLE collstate_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` mediumtext COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) NOT NULL DEFAULT '0',
  search int(11) NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  exclusion_obligatoire int(1) unsigned NOT NULL DEFAULT '0',
  pond int(11) NOT NULL DEFAULT '100',
  opac_sort int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collstate_custom`
--


--
-- Table structure for table `collstate_custom_lists`
--

CREATE TABLE collstate_custom_lists (
  collstate_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  collstate_custom_list_value varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  collstate_custom_list_lib varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ordre int(11) NOT NULL DEFAULT '0',
  KEY collstate_custom_champ (collstate_custom_champ),
  KEY i_ccl_lv (collstate_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collstate_custom_lists`
--


--
-- Table structure for table `collstate_custom_values`
--

CREATE TABLE collstate_custom_values (
  collstate_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  collstate_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  collstate_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  collstate_custom_text mediumtext COLLATE utf8_unicode_ci,
  collstate_custom_integer int(11) DEFAULT NULL,
  collstate_custom_date date DEFAULT NULL,
  collstate_custom_float float DEFAULT NULL,
  KEY collstate_custom_champ (collstate_custom_champ),
  KEY collstate_custom_origine (collstate_custom_origine),
  KEY i_ccv_st (collstate_custom_small_text),
  KEY i_ccv_t (collstate_custom_text(255)),
  KEY i_ccv_i (collstate_custom_integer),
  KEY i_ccv_d (collstate_custom_date),
  KEY i_ccv_f (collstate_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collstate_custom_values`
--


--
-- Table structure for table `comptes`
--

CREATE TABLE comptes (
  id_compte int(8) unsigned NOT NULL AUTO_INCREMENT,
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  type_compte_id int(10) unsigned NOT NULL DEFAULT '0',
  solde decimal(16,2) DEFAULT '0.00',
  prepay_mnt decimal(16,2) NOT NULL DEFAULT '0.00',
  proprio_id int(10) unsigned NOT NULL DEFAULT '0',
  droits mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_compte),
  KEY i_cpt_proprio_id (proprio_id)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `comptes`
--

INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (1,'Created on 2012-10-24',2,0.00,0.00,9,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (2,'Created on 2012-10-24',1,0.00,0.00,9,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (3,'Created on 2012-10-24',1,0.00,0.00,10,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (4,'Created on 2012-10-24',2,0.00,0.00,10,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (5,'Created on 2012-10-24',1,0.00,0.00,6,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (6,'Created on 2012-10-24',2,0.00,0.00,6,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (7,'Created on 2012-10-24',1,0.00,0.00,1,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (8,'Created on 2012-10-24',2,0.00,0.00,1,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (9,'Created on 2012-10-24',1,0.00,0.00,5,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (10,'Created on 2012-10-24',2,0.00,0.00,5,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (11,'Created on 2012-10-24',1,0.00,0.00,4,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (12,'Created on 2012-10-24',2,0.00,0.00,4,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (13,'Created on 2012-10-24',1,0.00,0.00,2,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (14,'Created on 2012-10-24',2,0.00,0.00,2,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (15,'Created on 2012-11-20',1,0.00,0.00,7,'');
INSERT INTO comptes (id_compte, libelle, type_compte_id, solde, prepay_mnt, proprio_id, droits) VALUES (16,'Created on 2012-11-20',2,0.00,0.00,7,'');

--
-- Table structure for table `connectors`
--

CREATE TABLE connectors (
  connector_id varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  parameters mediumtext COLLATE utf8_unicode_ci NOT NULL,
  repository int(11) NOT NULL DEFAULT '0',
  timeout int(11) NOT NULL DEFAULT '5',
  retry int(11) NOT NULL DEFAULT '3',
  ttl int(11) NOT NULL DEFAULT '1440',
  PRIMARY KEY (connector_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors`
--


--
-- Table structure for table `connectors_categ`
--

CREATE TABLE connectors_categ (
  connectors_categ_id smallint(5) NOT NULL AUTO_INCREMENT,
  connectors_categ_name varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  opac_expanded smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (connectors_categ_id)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO connectors_categ (connectors_categ_id, connectors_categ_name, opac_expanded) VALUES (1,'Catalogues de bibliothèques',1);
INSERT INTO connectors_categ (connectors_categ_id, connectors_categ_name, opac_expanded) VALUES (2,'Sources non disponibles pour la recherche externe',0);
INSERT INTO connectors_categ (connectors_categ_id, connectors_categ_name, opac_expanded) VALUES (3,'Bases de données et archives ouvertes',1);

--
-- Table structure for table `connectors_categ_sources`
--

CREATE TABLE connectors_categ_sources (
  num_categ smallint(6) NOT NULL DEFAULT '0',
  num_source smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (num_categ,num_source),
  KEY i_num_source (num_source)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO connectors_categ_sources (num_categ, num_source) VALUES (1,5);
INSERT INTO connectors_categ_sources (num_categ, num_source) VALUES (1,6);
INSERT INTO connectors_categ_sources (num_categ, num_source) VALUES (2,1);
INSERT INTO connectors_categ_sources (num_categ, num_source) VALUES (2,2);
INSERT INTO connectors_categ_sources (num_categ, num_source) VALUES (2,3);
INSERT INTO connectors_categ_sources (num_categ, num_source) VALUES (2,4);
INSERT INTO connectors_categ_sources (num_categ, num_source) VALUES (3,7);
INSERT INTO connectors_categ_sources (num_categ, num_source) VALUES (3,8);

--
-- Table structure for table `connectors_out`
--

CREATE TABLE connectors_out (
  connectors_out_id int(11) NOT NULL AUTO_INCREMENT,
  connectors_out_config longblob NOT NULL,
  PRIMARY KEY (connectors_out_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out`
--


--
-- Table structure for table `connectors_out_oai_deleted_records`
--

CREATE TABLE connectors_out_oai_deleted_records (
  num_set int(11) unsigned NOT NULL DEFAULT '0',
  num_notice int(11) unsigned NOT NULL DEFAULT '0',
  deletion_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (num_set,num_notice)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out_oai_deleted_records`
--


--
-- Table structure for table `connectors_out_oai_tokens`
--

CREATE TABLE connectors_out_oai_tokens (
  connectors_out_oai_token_token varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  connectors_out_oai_token_environnement mediumtext COLLATE utf8_unicode_ci NOT NULL,
  connectors_out_oai_token_expirationdate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (connectors_out_oai_token_token)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out_oai_tokens`
--


--
-- Table structure for table `connectors_out_setcache_values`
--

CREATE TABLE connectors_out_setcache_values (
  connectors_out_setcache_values_cachenum int(11) NOT NULL DEFAULT '0',
  connectors_out_setcache_values_value int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (connectors_out_setcache_values_cachenum,connectors_out_setcache_values_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out_setcache_values`
--


--
-- Table structure for table `connectors_out_setcaches`
--

CREATE TABLE connectors_out_setcaches (
  connectors_out_setcache_id int(11) NOT NULL AUTO_INCREMENT,
  connectors_out_setcache_setnum int(11) NOT NULL DEFAULT '0',
  connectors_out_setcache_lifeduration int(4) NOT NULL DEFAULT '0',
  connectors_out_setcache_lifeduration_unit enum('seconds','minutes','hours','days','weeks','months') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'seconds',
  connectors_out_setcache_lastupdatedate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (connectors_out_setcache_id),
  UNIQUE KEY connectors_out_setcache_setnum (connectors_out_setcache_setnum)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out_setcaches`
--


--
-- Table structure for table `connectors_out_setcateg_sets`
--

CREATE TABLE connectors_out_setcateg_sets (
  connectors_out_setcategset_setnum int(11) NOT NULL,
  connectors_out_setcategset_categnum int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (connectors_out_setcategset_setnum,connectors_out_setcategset_categnum)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out_setcateg_sets`
--


--
-- Table structure for table `connectors_out_setcategs`
--

CREATE TABLE connectors_out_setcategs (
  connectors_out_setcateg_id int(11) NOT NULL AUTO_INCREMENT,
  connectors_out_setcateg_name varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (connectors_out_setcateg_id),
  UNIQUE KEY connectors_out_setcateg_name (connectors_out_setcateg_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out_setcategs`
--


--
-- Table structure for table `connectors_out_sets`
--

CREATE TABLE connectors_out_sets (
  connector_out_set_id int(11) NOT NULL AUTO_INCREMENT,
  connector_out_set_caption varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  connector_out_set_type int(4) NOT NULL DEFAULT '0',
  connector_out_set_config longblob NOT NULL,
  being_refreshed int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (connector_out_set_id),
  UNIQUE KEY connector_out_set_caption (connector_out_set_caption)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out_sets`
--


--
-- Table structure for table `connectors_out_sources`
--

CREATE TABLE connectors_out_sources (
  connectors_out_source_id int(11) NOT NULL AUTO_INCREMENT,
  connectors_out_sources_connectornum int(11) NOT NULL DEFAULT '0',
  connectors_out_source_name varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  connectors_out_source_comment varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  connectors_out_source_config longblob NOT NULL,
  PRIMARY KEY (connectors_out_source_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out_sources`
--


--
-- Table structure for table `connectors_out_sources_esgroups`
--

CREATE TABLE connectors_out_sources_esgroups (
  connectors_out_source_esgroup_sourcenum int(11) NOT NULL DEFAULT '0',
  connectors_out_source_esgroup_esgroupnum int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (connectors_out_source_esgroup_sourcenum,connectors_out_source_esgroup_esgroupnum)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `connectors_out_sources_esgroups`
--


--
-- Table structure for table `connectors_sources`
--

CREATE TABLE connectors_sources (
  source_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  id_connector varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  parameters longtext COLLATE utf8_unicode_ci NOT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  repository int(11) NOT NULL DEFAULT '0',
  timeout int(11) NOT NULL DEFAULT '5',
  retry int(11) NOT NULL DEFAULT '3',
  ttl int(11) NOT NULL DEFAULT '1440',
  opac_allowed int(3) unsigned NOT NULL DEFAULT '0',
  rep_upload int(11) NOT NULL DEFAULT '0',
  upload_doc_num int(11) NOT NULL DEFAULT '1',
  enrichment int(11) NOT NULL DEFAULT '0',
  opac_affiliate_search int(11) NOT NULL DEFAULT '0',
  opac_selected int(3) unsigned NOT NULL DEFAULT '0',
  type_enrichment_allowed mediumtext COLLATE utf8_unicode_ci NOT NULL,
  ico_notice varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  last_sync_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (source_id)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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 (1,'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');
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,'babelio','a:0:{}','','Babélio',2,5,3,1800,1,0,1,1,0,0,'a:2:{i:0;s:8:\"citation\";i:1;s:8:\"critique\";}','','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 (3,'wikipedia','a:0:{}','','Wikipédia',2,5,3,1800,1,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 (4,'youtube','a:0:{}','','YouTube',2,5,3,1800,1,0,1,1,0,0,'a:1:{i:0;s:7:\"youtube\";}','','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,'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:11:\"very_simple\";s:10:\"z3950_bib1\";a:546:{s:19:\"bib1_200a_BOOLEAN_0\";s:1:\"4\";s:19:\"bib1_200a_BOOLEAN_1\";s:0:\"\";s:19:\"bib1_200a_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_200a_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_200a_STARTWITH_2\";s:0:\"\";s:21:\"bib1_200a_STARTWITH_3\";s:0:\"\";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:0:\"\";s:17:\"bib1_200a_EXACT_2\";s:0:\"\";s:17:\"bib1_200a_EXACT_3\";s:0:\"\";s:17:\"bib1_200a_EXACT_4\";s:0:\"\";s:17:\"bib1_200a_EXACT_5\";s:0:\"\";s:18:\"bib1_XXX_BOOLEAN_0\";s:25:\"4,5,1003,7,8,1214,1018,21\";s:18:\"bib1_XXX_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_XXX_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_XXX_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:18:\"bib1_7XX_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_7XX_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:20:\"bib1_7XX_STARTWITH_2\";s:0:\"\";s:20:\"bib1_7XX_STARTWITH_3\";s:0:\"\";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:0:\"\";s:16:\"bib1_7XX_EXACT_2\";s:0:\"\";s:16:\"bib1_7XX_EXACT_3\";s:0:\"\";s:16:\"bib1_7XX_EXACT_4\";s:0:\"\";s:16:\"bib1_7XX_EXACT_5\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_0\";s:4:\"1018\";s:19:\"bib1_210c_BOOLEAN_1\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_3\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_4\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_5\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_0\";s:4:\"1018\";s:21:\"bib1_210c_STARTWITH_1\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_2\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_3\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_4\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_5\";s:0:\"\";s:19:\"bib1_210c_ENDWITH_0\";s:4:\"1018\";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:4:\"1018\";s:17:\"bib1_210c_EXACT_1\";s:0:\"\";s:17:\"bib1_210c_EXACT_2\";s:0:\"\";s:17:\"bib1_210c_EXACT_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_210d_STARTWITH_2\";s:0:\"\";s:21:\"bib1_210d_STARTWITH_3\";s:0:\"\";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:0:\"\";s:17:\"bib1_210d_EXACT_2\";s:0:\"\";s:17:\"bib1_210d_EXACT_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_210d_EQ_2\";s:0:\"\";s:14:\"bib1_210d_EQ_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_210d_LT_2\";s:0:\"\";s:14:\"bib1_210d_LT_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_210d_GT_2\";s:0:\"\";s:14:\"bib1_210d_GT_3\";s:0:\"\";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:0:\"\";s:16:\"bib1_210d_GTEQ_2\";s:0:\"\";s:16:\"bib1_210d_GTEQ_3\";s:0:\"\";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:0:\"\";s:23:\"bib1_225a410t_BOOLEAN_2\";s:0:\"\";s:23:\"bib1_225a410t_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:25:\"bib1_225a410t_STARTWITH_2\";s:0:\"\";s:25:\"bib1_225a410t_STARTWITH_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_225a410t_EXACT_2\";s:0:\"\";s:21:\"bib1_225a410t_EXACT_3\";s:0:\"\";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:0:\"\";s:23:\"bib1_225i411t_BOOLEAN_2\";s:0:\"\";s:23:\"bib1_225i411t_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:25:\"bib1_225i411t_STARTWITH_2\";s:0:\"\";s:25:\"bib1_225i411t_STARTWITH_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_225i411t_EXACT_2\";s:0:\"\";s:21:\"bib1_225i411t_EXACT_3\";s:0:\"\";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:0:\"\";s:19:\"bib1_461t_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_461t_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_461t_STARTWITH_2\";s:0:\"\";s:21:\"bib1_461t_STARTWITH_3\";s:0:\"\";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:0:\"\";s:17:\"bib1_461t_EXACT_2\";s:0:\"\";s:17:\"bib1_461t_EXACT_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_461t_EQ_2\";s:0:\"\";s:14:\"bib1_461t_EQ_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_010a_STARTWITH_2\";s:0:\"\";s:21:\"bib1_010a_STARTWITH_3\";s:0:\"\";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:0:\"\";s:19:\"bib1_500a_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_500a_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_500a_STARTWITH_2\";s:0:\"\";s:21:\"bib1_500a_STARTWITH_3\";s:0:\"\";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:0:\"\";s:17:\"bib1_500a_EXACT_2\";s:0:\"\";s:17:\"bib1_500a_EXACT_3\";s:0:\"\";s:17:\"bib1_500a_EXACT_4\";s:0:\"\";s:17:\"bib1_500a_EXACT_5\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_0\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_3\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_300_STARTWITH_0\";s:0:\"\";s:20:\"bib1_300_STARTWITH_1\";s:0:\"\";s:20:\"bib1_300_STARTWITH_2\";s:0:\"\";s:20:\"bib1_300_STARTWITH_3\";s:0:\"\";s:20:\"bib1_300_STARTWITH_4\";s:0:\"\";s:20:\"bib1_300_STARTWITH_5\";s:0:\"\";s:18:\"bib1_300_ENDWITH_0\";s:0:\"\";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:0:\"\";s:16:\"bib1_300_EXACT_1\";s:0:\"\";s:16:\"bib1_300_EXACT_2\";s:0:\"\";s:16:\"bib1_300_EXACT_3\";s:0:\"\";s:16:\"bib1_300_EXACT_4\";s:0:\"\";s:16:\"bib1_300_EXACT_5\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_0\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_3\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_327_STARTWITH_0\";s:0:\"\";s:20:\"bib1_327_STARTWITH_1\";s:0:\"\";s:20:\"bib1_327_STARTWITH_2\";s:0:\"\";s:20:\"bib1_327_STARTWITH_3\";s:0:\"\";s:20:\"bib1_327_STARTWITH_4\";s:0:\"\";s:20:\"bib1_327_STARTWITH_5\";s:0:\"\";s:18:\"bib1_327_ENDWITH_0\";s:0:\"\";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:0:\"\";s:16:\"bib1_327_EXACT_1\";s:0:\"\";s:16:\"bib1_327_EXACT_2\";s:0:\"\";s:16:\"bib1_327_EXACT_3\";s:0:\"\";s:16:\"bib1_327_EXACT_4\";s:0:\"\";s:16:\"bib1_327_EXACT_5\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_0\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_3\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_330_STARTWITH_0\";s:0:\"\";s:20:\"bib1_330_STARTWITH_1\";s:0:\"\";s:20:\"bib1_330_STARTWITH_2\";s:0:\"\";s:20:\"bib1_330_STARTWITH_3\";s:0:\"\";s:20:\"bib1_330_STARTWITH_4\";s:0:\"\";s:20:\"bib1_330_STARTWITH_5\";s:0:\"\";s:18:\"bib1_330_ENDWITH_0\";s:0:\"\";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:0:\"\";s:16:\"bib1_330_EXACT_1\";s:0:\"\";s:16:\"bib1_330_EXACT_2\";s:0:\"\";s:16:\"bib1_330_EXACT_3\";s:0:\"\";s:16:\"bib1_330_EXACT_4\";s:0:\"\";s:16:\"bib1_330_EXACT_5\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_0\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_3\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_0\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_1\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_2\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_3\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_4\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_5\";s:0:\"\";s:18:\"bib1_3XX_ENDWITH_0\";s:0:\"\";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:0:\"\";s:16:\"bib1_3XX_EXACT_1\";s:0:\"\";s:16:\"bib1_3XX_EXACT_2\";s:0:\"\";s:16:\"bib1_3XX_EXACT_3\";s:0:\"\";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:0:\"\";s:18:\"bib1_60X_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_60X_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:20:\"bib1_60X_STARTWITH_2\";s:0:\"\";s:20:\"bib1_60X_STARTWITH_3\";s:0:\"\";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:0:\"\";s:16:\"bib1_60X_EXACT_2\";s:0:\"\";s:16:\"bib1_60X_EXACT_3\";s:0:\"\";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:0:\"\";s:23:\"bib1_676a686a_BOOLEAN_2\";s:0:\"\";s:23:\"bib1_676a686a_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:25:\"bib1_676a686a_STARTWITH_2\";s:0:\"\";s:25:\"bib1_676a686a_STARTWITH_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_676a686a_EXACT_2\";s:0:\"\";s:21:\"bib1_676a686a_EXACT_3\";s:0:\"\";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:0:\"\";s:18:\"bib1_610_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_610_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:20:\"bib1_610_STARTWITH_2\";s:0:\"\";s:20:\"bib1_610_STARTWITH_3\";s:0:\"\";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:0:\"\";s:16:\"bib1_610_EXACT_2\";s:0:\"\";s:16:\"bib1_610_EXACT_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_101a_EQ_2\";s:0:\"\";s:14:\"bib1_101a_EQ_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_101c_EQ_2\";s:0:\"\";s:14:\"bib1_101c_EQ_3\";s:0:\"\";s:14:\"bib1_101c_EQ_4\";s:0:\"\";s:14:\"bib1_101c_EQ_5\";s:0:\"\";s:12:\"bib1_bl_EQ_0\";s:0:\"\";s:12:\"bib1_bl_EQ_1\";s:0:\"\";s:12:\"bib1_bl_EQ_2\";s:0:\"\";s:12:\"bib1_bl_EQ_3\";s:0:\"\";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:0:\"\";s:12:\"bib1_dt_EQ_2\";s:0:\"\";s:12:\"bib1_dt_EQ_3\";s:0:\"\";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:0:\"\";s:12:\"bib1_dc_EQ_1\";s:0:\"\";s:12:\"bib1_dc_EQ_2\";s:0:\"\";s:12:\"bib1_dc_EQ_3\";s:0:\"\";s:12:\"bib1_dc_EQ_4\";s:0:\"\";s:12:\"bib1_dc_EQ_5\";s:0:\"\";s:12:\"bib1_dc_LT_0\";s:0:\"\";s:12:\"bib1_dc_LT_1\";s:0:\"\";s:12:\"bib1_dc_LT_2\";s:0:\"\";s:12:\"bib1_dc_LT_3\";s:0:\"\";s:12:\"bib1_dc_LT_4\";s:0:\"\";s:12:\"bib1_dc_LT_5\";s:0:\"\";s:12:\"bib1_dc_GT_0\";s:0:\"\";s:12:\"bib1_dc_GT_1\";s:0:\"\";s:12:\"bib1_dc_GT_2\";s:0:\"\";s:12:\"bib1_dc_GT_3\";s:0:\"\";s:12:\"bib1_dc_GT_4\";s:0:\"\";s:12:\"bib1_dc_GT_5\";s:0:\"\";s:14:\"bib1_dc_LTEQ_0\";s:0:\"\";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:0:\"\";s:14:\"bib1_dc_GTEQ_1\";s:0:\"\";s:14:\"bib1_dc_GTEQ_2\";s:0:\"\";s:14:\"bib1_dc_GTEQ_3\";s:0:\"\";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_461v_CONTAINS_0\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_1\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_2\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_3\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_4\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_5\";s:0:\"\";}}','','BnF',2,15,3,1800,1,0,1,0,0,1,'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 (6,'z3950','a:10:{s:3:\"url\";s:20:\"carmin.sudoc.abes.fr\";s:10:\"z3950_base\";s:15:\"ABES-Z39-PUBLIC\";s:11:\"z3950_login\";s:0:\"\";s:14:\"z3950_password\";s:0:\"\";s:17:\"z3950_max_notices\";s:3:\"100\";s:12:\"z3950_format\";s:7:\"UNIMARC\";s:10:\"z3950_port\";s:3:\"210\";s:13:\"z3950_convert\";s:1:\"0\";s:12:\"z3950_profil\";s:11:\"very_simple\";s:10:\"z3950_bib1\";a:546:{s:19:\"bib1_200a_BOOLEAN_0\";s:1:\"4\";s:19:\"bib1_200a_BOOLEAN_1\";s:0:\"\";s:19:\"bib1_200a_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_200a_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_200a_STARTWITH_2\";s:0:\"\";s:21:\"bib1_200a_STARTWITH_3\";s:0:\"\";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:0:\"\";s:17:\"bib1_200a_EXACT_2\";s:0:\"\";s:17:\"bib1_200a_EXACT_3\";s:0:\"\";s:17:\"bib1_200a_EXACT_4\";s:0:\"\";s:17:\"bib1_200a_EXACT_5\";s:0:\"\";s:18:\"bib1_XXX_BOOLEAN_0\";s:25:\"4,5,1003,7,8,1214,1018,21\";s:18:\"bib1_XXX_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_XXX_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_XXX_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:18:\"bib1_7XX_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_7XX_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:20:\"bib1_7XX_STARTWITH_2\";s:0:\"\";s:20:\"bib1_7XX_STARTWITH_3\";s:0:\"\";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:0:\"\";s:16:\"bib1_7XX_EXACT_2\";s:0:\"\";s:16:\"bib1_7XX_EXACT_3\";s:0:\"\";s:16:\"bib1_7XX_EXACT_4\";s:0:\"\";s:16:\"bib1_7XX_EXACT_5\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_0\";s:4:\"1018\";s:19:\"bib1_210c_BOOLEAN_1\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_3\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_4\";s:0:\"\";s:19:\"bib1_210c_BOOLEAN_5\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_0\";s:4:\"1018\";s:21:\"bib1_210c_STARTWITH_1\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_2\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_3\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_4\";s:0:\"\";s:21:\"bib1_210c_STARTWITH_5\";s:0:\"\";s:19:\"bib1_210c_ENDWITH_0\";s:4:\"1018\";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:4:\"1018\";s:17:\"bib1_210c_EXACT_1\";s:0:\"\";s:17:\"bib1_210c_EXACT_2\";s:0:\"\";s:17:\"bib1_210c_EXACT_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_210d_STARTWITH_2\";s:0:\"\";s:21:\"bib1_210d_STARTWITH_3\";s:0:\"\";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:0:\"\";s:17:\"bib1_210d_EXACT_2\";s:0:\"\";s:17:\"bib1_210d_EXACT_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_210d_EQ_2\";s:0:\"\";s:14:\"bib1_210d_EQ_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_210d_LT_2\";s:0:\"\";s:14:\"bib1_210d_LT_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_210d_GT_2\";s:0:\"\";s:14:\"bib1_210d_GT_3\";s:0:\"\";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:0:\"\";s:16:\"bib1_210d_GTEQ_2\";s:0:\"\";s:16:\"bib1_210d_GTEQ_3\";s:0:\"\";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:0:\"\";s:23:\"bib1_225a410t_BOOLEAN_2\";s:0:\"\";s:23:\"bib1_225a410t_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:25:\"bib1_225a410t_STARTWITH_2\";s:0:\"\";s:25:\"bib1_225a410t_STARTWITH_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_225a410t_EXACT_2\";s:0:\"\";s:21:\"bib1_225a410t_EXACT_3\";s:0:\"\";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:0:\"\";s:23:\"bib1_225i411t_BOOLEAN_2\";s:0:\"\";s:23:\"bib1_225i411t_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:25:\"bib1_225i411t_STARTWITH_2\";s:0:\"\";s:25:\"bib1_225i411t_STARTWITH_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_225i411t_EXACT_2\";s:0:\"\";s:21:\"bib1_225i411t_EXACT_3\";s:0:\"\";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:0:\"\";s:19:\"bib1_461t_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_461t_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_461t_STARTWITH_2\";s:0:\"\";s:21:\"bib1_461t_STARTWITH_3\";s:0:\"\";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:0:\"\";s:17:\"bib1_461t_EXACT_2\";s:0:\"\";s:17:\"bib1_461t_EXACT_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_461t_EQ_2\";s:0:\"\";s:14:\"bib1_461t_EQ_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_010a_STARTWITH_2\";s:0:\"\";s:21:\"bib1_010a_STARTWITH_3\";s:0:\"\";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:0:\"\";s:19:\"bib1_500a_BOOLEAN_2\";s:0:\"\";s:19:\"bib1_500a_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_500a_STARTWITH_2\";s:0:\"\";s:21:\"bib1_500a_STARTWITH_3\";s:0:\"\";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:0:\"\";s:17:\"bib1_500a_EXACT_2\";s:0:\"\";s:17:\"bib1_500a_EXACT_3\";s:0:\"\";s:17:\"bib1_500a_EXACT_4\";s:0:\"\";s:17:\"bib1_500a_EXACT_5\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_0\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_3\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_300_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_300_STARTWITH_0\";s:0:\"\";s:20:\"bib1_300_STARTWITH_1\";s:0:\"\";s:20:\"bib1_300_STARTWITH_2\";s:0:\"\";s:20:\"bib1_300_STARTWITH_3\";s:0:\"\";s:20:\"bib1_300_STARTWITH_4\";s:0:\"\";s:20:\"bib1_300_STARTWITH_5\";s:0:\"\";s:18:\"bib1_300_ENDWITH_0\";s:0:\"\";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:0:\"\";s:16:\"bib1_300_EXACT_1\";s:0:\"\";s:16:\"bib1_300_EXACT_2\";s:0:\"\";s:16:\"bib1_300_EXACT_3\";s:0:\"\";s:16:\"bib1_300_EXACT_4\";s:0:\"\";s:16:\"bib1_300_EXACT_5\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_0\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_3\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_327_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_327_STARTWITH_0\";s:0:\"\";s:20:\"bib1_327_STARTWITH_1\";s:0:\"\";s:20:\"bib1_327_STARTWITH_2\";s:0:\"\";s:20:\"bib1_327_STARTWITH_3\";s:0:\"\";s:20:\"bib1_327_STARTWITH_4\";s:0:\"\";s:20:\"bib1_327_STARTWITH_5\";s:0:\"\";s:18:\"bib1_327_ENDWITH_0\";s:0:\"\";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:0:\"\";s:16:\"bib1_327_EXACT_1\";s:0:\"\";s:16:\"bib1_327_EXACT_2\";s:0:\"\";s:16:\"bib1_327_EXACT_3\";s:0:\"\";s:16:\"bib1_327_EXACT_4\";s:0:\"\";s:16:\"bib1_327_EXACT_5\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_0\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_3\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_330_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_330_STARTWITH_0\";s:0:\"\";s:20:\"bib1_330_STARTWITH_1\";s:0:\"\";s:20:\"bib1_330_STARTWITH_2\";s:0:\"\";s:20:\"bib1_330_STARTWITH_3\";s:0:\"\";s:20:\"bib1_330_STARTWITH_4\";s:0:\"\";s:20:\"bib1_330_STARTWITH_5\";s:0:\"\";s:18:\"bib1_330_ENDWITH_0\";s:0:\"\";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:0:\"\";s:16:\"bib1_330_EXACT_1\";s:0:\"\";s:16:\"bib1_330_EXACT_2\";s:0:\"\";s:16:\"bib1_330_EXACT_3\";s:0:\"\";s:16:\"bib1_330_EXACT_4\";s:0:\"\";s:16:\"bib1_330_EXACT_5\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_0\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_1\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_3\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_4\";s:0:\"\";s:18:\"bib1_3XX_BOOLEAN_5\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_0\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_1\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_2\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_3\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_4\";s:0:\"\";s:20:\"bib1_3XX_STARTWITH_5\";s:0:\"\";s:18:\"bib1_3XX_ENDWITH_0\";s:0:\"\";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:0:\"\";s:16:\"bib1_3XX_EXACT_1\";s:0:\"\";s:16:\"bib1_3XX_EXACT_2\";s:0:\"\";s:16:\"bib1_3XX_EXACT_3\";s:0:\"\";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:0:\"\";s:18:\"bib1_60X_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_60X_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:20:\"bib1_60X_STARTWITH_2\";s:0:\"\";s:20:\"bib1_60X_STARTWITH_3\";s:0:\"\";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:0:\"\";s:16:\"bib1_60X_EXACT_2\";s:0:\"\";s:16:\"bib1_60X_EXACT_3\";s:0:\"\";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:0:\"\";s:23:\"bib1_676a686a_BOOLEAN_2\";s:0:\"\";s:23:\"bib1_676a686a_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:25:\"bib1_676a686a_STARTWITH_2\";s:0:\"\";s:25:\"bib1_676a686a_STARTWITH_3\";s:0:\"\";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:0:\"\";s:21:\"bib1_676a686a_EXACT_2\";s:0:\"\";s:21:\"bib1_676a686a_EXACT_3\";s:0:\"\";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:0:\"\";s:18:\"bib1_610_BOOLEAN_2\";s:0:\"\";s:18:\"bib1_610_BOOLEAN_3\";s:0:\"\";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:0:\"\";s:20:\"bib1_610_STARTWITH_2\";s:0:\"\";s:20:\"bib1_610_STARTWITH_3\";s:0:\"\";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:0:\"\";s:16:\"bib1_610_EXACT_2\";s:0:\"\";s:16:\"bib1_610_EXACT_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_101a_EQ_2\";s:0:\"\";s:14:\"bib1_101a_EQ_3\";s:0:\"\";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:0:\"\";s:14:\"bib1_101c_EQ_2\";s:0:\"\";s:14:\"bib1_101c_EQ_3\";s:0:\"\";s:14:\"bib1_101c_EQ_4\";s:0:\"\";s:14:\"bib1_101c_EQ_5\";s:0:\"\";s:12:\"bib1_bl_EQ_0\";s:0:\"\";s:12:\"bib1_bl_EQ_1\";s:0:\"\";s:12:\"bib1_bl_EQ_2\";s:0:\"\";s:12:\"bib1_bl_EQ_3\";s:0:\"\";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:0:\"\";s:12:\"bib1_dt_EQ_2\";s:0:\"\";s:12:\"bib1_dt_EQ_3\";s:0:\"\";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:0:\"\";s:12:\"bib1_dc_EQ_1\";s:0:\"\";s:12:\"bib1_dc_EQ_2\";s:0:\"\";s:12:\"bib1_dc_EQ_3\";s:0:\"\";s:12:\"bib1_dc_EQ_4\";s:0:\"\";s:12:\"bib1_dc_EQ_5\";s:0:\"\";s:12:\"bib1_dc_LT_0\";s:0:\"\";s:12:\"bib1_dc_LT_1\";s:0:\"\";s:12:\"bib1_dc_LT_2\";s:0:\"\";s:12:\"bib1_dc_LT_3\";s:0:\"\";s:12:\"bib1_dc_LT_4\";s:0:\"\";s:12:\"bib1_dc_LT_5\";s:0:\"\";s:12:\"bib1_dc_GT_0\";s:0:\"\";s:12:\"bib1_dc_GT_1\";s:0:\"\";s:12:\"bib1_dc_GT_2\";s:0:\"\";s:12:\"bib1_dc_GT_3\";s:0:\"\";s:12:\"bib1_dc_GT_4\";s:0:\"\";s:12:\"bib1_dc_GT_5\";s:0:\"\";s:14:\"bib1_dc_LTEQ_0\";s:0:\"\";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:0:\"\";s:14:\"bib1_dc_GTEQ_1\";s:0:\"\";s:14:\"bib1_dc_GTEQ_2\";s:0:\"\";s:14:\"bib1_dc_GTEQ_3\";s:0:\"\";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_461v_CONTAINS_0\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_1\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_2\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_3\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_4\";s:0:\"\";s:20:\"bib1_461v_CONTAINS_5\";s:0:\"\";}}','','Sudoc',2,15,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 (7,'oai','a:6:{s:3:\"url\";s:33:\"http://oai.bnf.fr/oai2/OAIHandler\";s:14:\"clean_base_url\";s:1:\"1\";s:4:\"sets\";a:1:{i:0;s:22:\"gallica:corpus:afrique\";}s:7:\"formats\";s:6:\"oai_dc\";s:11:\"del_deleted\";s:1:\"0\";s:13:\"xsl_transform\";N;}','','Gallica',1,5,3,1800,1,0,1,0,1,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 (8,'entrez','a:4:{s:15:\"entrez_database\";s:0:\"\";s:17:\"entrez_maxresults\";i:100;s:15:\"entrez_operator\";i:2;s:13:\"xsl_transform\";N;}','','PubMed',2,5,3,1800,1,0,1,0,0,0,'a:0:{}','','0000-00-00 00:00:00');

--
-- Table structure for table `coordonnees`
--

CREATE TABLE coordonnees (
  id_contact int(8) unsigned NOT NULL AUTO_INCREMENT,
  type_coord int(1) unsigned NOT NULL DEFAULT '0',
  num_entite int(5) unsigned NOT NULL DEFAULT '0',
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  contact varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  adr1 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  adr2 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  cp varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ville varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  etat varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  pays varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tel1 varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tel2 varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  fax varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  email varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  commentaires mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (id_contact),
  KEY i_num_entite (num_entite)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `coordonnees`
--


--
-- Table structure for table `demandes`
--

CREATE TABLE demandes (
  id_demande int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_demandeur int(10) unsigned NOT NULL DEFAULT '0',
  theme_demande int(3) NOT NULL DEFAULT '0',
  type_demande int(3) NOT NULL DEFAULT '0',
  etat_demande int(3) NOT NULL DEFAULT '0',
  date_demande date NOT NULL DEFAULT '0000-00-00',
  date_prevue date NOT NULL DEFAULT '0000-00-00',
  deadline_demande date NOT NULL DEFAULT '0000-00-00',
  titre_demande varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  sujet_demande mediumtext COLLATE utf8_unicode_ci NOT NULL,
  progression mediumint(3) NOT NULL DEFAULT '0',
  num_user_cloture mediumint(3) NOT NULL DEFAULT '0',
  num_notice int(10) NOT NULL DEFAULT '0',
  dmde_read_gestion int(1) unsigned NOT NULL DEFAULT '0',
  reponse_finale text COLLATE utf8_unicode_ci,
  dmde_read_opac int(1) unsigned NOT NULL DEFAULT '0',
  demande_note_num int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_demande),
  KEY i_num_demandeur (num_demandeur),
  KEY i_date_demande (date_demande),
  KEY i_deadline_demande (deadline_demande)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demandes`
--


--
-- Table structure for table `demandes_actions`
--

CREATE TABLE demandes_actions (
  id_action int(10) unsigned NOT NULL AUTO_INCREMENT,
  type_action int(3) NOT NULL DEFAULT '0',
  statut_action int(3) NOT NULL DEFAULT '0',
  sujet_action varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  detail_action mediumtext COLLATE utf8_unicode_ci NOT NULL,
  date_action date NOT NULL DEFAULT '0000-00-00',
  deadline_action date NOT NULL DEFAULT '0000-00-00',
  temps_passe float DEFAULT NULL,
  cout mediumint(3) NOT NULL DEFAULT '0',
  progression_action mediumint(3) NOT NULL DEFAULT '0',
  prive_action int(1) NOT NULL DEFAULT '0',
  num_demande int(10) NOT NULL DEFAULT '0',
  actions_num_user int(10) unsigned NOT NULL DEFAULT '0',
  actions_type_user tinyint(4) unsigned NOT NULL DEFAULT '0',
  actions_read_opac int(11) NOT NULL DEFAULT '0',
  actions_read_gestion int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_action),
  KEY i_date_action (date_action),
  KEY i_deadline_action (deadline_action),
  KEY i_num_demande (num_demande),
  KEY i_actions_user (actions_num_user,actions_type_user)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demandes_actions`
--


--
-- Table structure for table `demandes_custom`
--

CREATE TABLE demandes_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` text COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) DEFAULT NULL,
  search int(1) unsigned NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  exclusion_obligatoire int(1) unsigned NOT NULL DEFAULT '0',
  pond int(11) NOT NULL DEFAULT '100',
  opac_sort int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demandes_custom`
--


--
-- Table structure for table `demandes_custom_lists`
--

CREATE TABLE demandes_custom_lists (
  demandes_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  demandes_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  demandes_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY i_demandes_custom_champ (demandes_custom_champ),
  KEY i_demandes_champ_list_value (demandes_custom_champ,demandes_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demandes_custom_lists`
--


--
-- Table structure for table `demandes_custom_values`
--

CREATE TABLE demandes_custom_values (
  demandes_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  demandes_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  demandes_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  demandes_custom_text text COLLATE utf8_unicode_ci,
  demandes_custom_integer int(11) DEFAULT NULL,
  demandes_custom_date date DEFAULT NULL,
  demandes_custom_float float DEFAULT NULL,
  KEY i_demandes_custom_champ (demandes_custom_champ),
  KEY i_demandes_custom_origine (demandes_custom_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demandes_custom_values`
--


--
-- Table structure for table `demandes_notes`
--

CREATE TABLE demandes_notes (
  id_note int(10) unsigned NOT NULL AUTO_INCREMENT,
  prive int(1) NOT NULL DEFAULT '0',
  rapport int(1) NOT NULL DEFAULT '0',
  contenu mediumtext COLLATE utf8_unicode_ci NOT NULL,
  date_note datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  num_action int(10) NOT NULL DEFAULT '0',
  num_note_parent int(10) NOT NULL DEFAULT '0',
  notes_num_user int(10) unsigned NOT NULL DEFAULT '0',
  notes_type_user tinyint(4) unsigned NOT NULL DEFAULT '0',
  notes_read_gestion int(1) unsigned NOT NULL DEFAULT '0',
  notes_read_opac int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_note),
  KEY i_date_note (date_note),
  KEY i_num_action (num_action),
  KEY i_num_note_parent (num_note_parent),
  KEY i_notes_user (notes_num_user,notes_type_user)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demandes_notes`
--


--
-- Table structure for table `demandes_theme`
--

CREATE TABLE demandes_theme (
  id_theme int(10) unsigned NOT NULL AUTO_INCREMENT,
  libelle_theme varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_theme)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demandes_theme`
--


--
-- Table structure for table `demandes_type`
--

CREATE TABLE demandes_type (
  id_type int(10) unsigned NOT NULL AUTO_INCREMENT,
  libelle_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  allowed_actions text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_type)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demandes_type`
--


--
-- Table structure for table `demandes_users`
--

CREATE TABLE demandes_users (
  num_user int(10) NOT NULL DEFAULT '0',
  num_demande int(10) NOT NULL DEFAULT '0',
  date_creation date NOT NULL DEFAULT '0000-00-00',
  users_statut int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (num_user,num_demande)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demandes_users`
--


--
-- Table structure for table `docs_codestat`
--

CREATE TABLE docs_codestat (
  idcode smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  codestat_libelle varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  statisdoc_codage_import char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  statisdoc_owner mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (idcode),
  KEY statisdoc_owner (statisdoc_owner)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docs_codestat`
--

INSERT INTO docs_codestat (idcode, codestat_libelle, statisdoc_codage_import, statisdoc_owner) VALUES (10,'Indéterminé','u',0);
INSERT INTO docs_codestat (idcode, codestat_libelle, statisdoc_codage_import, statisdoc_owner) VALUES (11,'Jeunes','j',0);
INSERT INTO docs_codestat (idcode, codestat_libelle, statisdoc_codage_import, statisdoc_owner) VALUES (12,'Adultes','a',0);

--
-- Table structure for table `docs_location`
--

CREATE TABLE docs_location (
  idlocation smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  location_libelle varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  locdoc_codage_import varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  locdoc_owner mediumint(8) unsigned NOT NULL DEFAULT '0',
  location_pic varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  location_visible_opac tinyint(1) NOT NULL DEFAULT '1',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  adr1 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  adr2 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  cp varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  town varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  state varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  country varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  phone varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  email varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  website varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  logo varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  commentaire mediumtext COLLATE utf8_unicode_ci NOT NULL,
  transfert_ordre smallint(2) unsigned NOT NULL DEFAULT '9999',
  transfert_statut_defaut smallint(5) unsigned NOT NULL DEFAULT '0',
  num_infopage int(6) unsigned NOT NULL DEFAULT '0',
  css_style varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_num int(11) NOT NULL DEFAULT '0',
  surloc_used tinyint(1) NOT NULL DEFAULT '0',
  show_a2z int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (idlocation),
  KEY locdoc_owner (locdoc_owner)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docs_location`
--

INSERT INTO docs_location (idlocation, location_libelle, locdoc_codage_import, locdoc_owner, location_pic, location_visible_opac, name, adr1, adr2, cp, town, state, country, phone, email, website, logo, commentaire, transfert_ordre, transfert_statut_defaut, num_infopage, css_style, surloc_num, surloc_used, show_a2z) VALUES (1,'Bibliothèque PMB Services','',0,'',1,'Bibliothèque test de PMB','PMB Services','ZI de Mont/Loir','72500','CHATEAU DU LOIR','','France','02 43 440 660','pmb@sigb.net','http://www.sigb.net/','logo_default.jpg','',9999,0,0,'',0,0,0);

--
-- Table structure for table `docs_section`
--

CREATE TABLE docs_section (
  idsection smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  section_libelle varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  sdoc_codage_import varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  sdoc_owner mediumint(8) unsigned NOT NULL DEFAULT '0',
  section_pic varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  section_visible_opac tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (idsection),
  KEY sdoc_owner (sdoc_owner)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docs_section`
--

INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (10,'Documentaires','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (30,'Réserve','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (13,'Romans Jeunes','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (16,'Bandes-dessinées Adultes','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (31,'Revues','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (19,'Fonds Régional','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (20,'Bandes-dessinées Jeunes','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (29,'Vidéothèque','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (23,'Romans Large vue','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (24,'Romans Adultes','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (26,'Albums','',0,'',1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (28,'Discothèque','',0,'',1);

--
-- Table structure for table `docs_statut`
--

CREATE TABLE docs_statut (
  idstatut smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  statut_libelle varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  statut_libelle_opac varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  pret_flag tinyint(4) NOT NULL DEFAULT '1',
  statusdoc_codage_import char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  statusdoc_owner mediumint(8) unsigned NOT NULL DEFAULT '0',
  transfert_flag tinyint(4) unsigned NOT NULL DEFAULT '1',
  statut_visible_opac tinyint(1) unsigned NOT NULL DEFAULT '1',
  statut_allow_resa int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (idstatut),
  KEY statusdoc_owner (statusdoc_owner)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docs_statut`
--

INSERT INTO docs_statut (idstatut, statut_libelle, statut_libelle_opac, pret_flag, statusdoc_codage_import, statusdoc_owner, transfert_flag, statut_visible_opac, statut_allow_resa) VALUES (1,'Empruntable','',1,'',0,0,1,1);
INSERT INTO docs_statut (idstatut, statut_libelle, statut_libelle_opac, pret_flag, statusdoc_codage_import, statusdoc_owner, transfert_flag, statut_visible_opac, statut_allow_resa) VALUES (2,'En cours d\'import/saisie','En traitement',0,'',0,0,1,1);
INSERT INTO docs_statut (idstatut, statut_libelle, statut_libelle_opac, pret_flag, statusdoc_codage_import, statusdoc_owner, transfert_flag, statut_visible_opac, statut_allow_resa) VALUES (11,'En réparation','En réparation',0,'',0,0,1,0);
INSERT INTO docs_statut (idstatut, statut_libelle, statut_libelle_opac, pret_flag, statusdoc_codage_import, statusdoc_owner, transfert_flag, statut_visible_opac, statut_allow_resa) VALUES (12,'Perdu','',0,'',0,0,0,0);
INSERT INTO docs_statut (idstatut, statut_libelle, statut_libelle_opac, pret_flag, statusdoc_codage_import, statusdoc_owner, transfert_flag, statut_visible_opac, statut_allow_resa) VALUES (13,'Consultation sur place','Consultation sur place',0,'',0,0,1,0);
INSERT INTO docs_statut (idstatut, statut_libelle, statut_libelle_opac, pret_flag, statusdoc_codage_import, statusdoc_owner, transfert_flag, statut_visible_opac, statut_allow_resa) VALUES (15,'Pilon','',0,'',0,0,0,0);

--
-- Table structure for table `docs_type`
--

CREATE TABLE docs_type (
  idtyp_doc int(5) unsigned NOT NULL AUTO_INCREMENT,
  tdoc_libelle varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  duree_pret smallint(6) NOT NULL DEFAULT '31',
  duree_resa int(6) unsigned NOT NULL DEFAULT '15',
  tdoc_owner mediumint(8) unsigned NOT NULL DEFAULT '0',
  tdoc_codage_import varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tarif_pret decimal(16,2) NOT NULL DEFAULT '0.00',
  short_loan_duration int(6) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (idtyp_doc)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docs_type`
--

INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret, short_loan_duration) VALUES (1,'Livre',14,15,0,'',0.00,1);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret, short_loan_duration) VALUES (19,'Livre audio',31,15,0,'',0.00,1);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret, short_loan_duration) VALUES (13,'CD',14,15,0,'',0.00,1);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret, short_loan_duration) VALUES (14,'DVD',5,15,0,'',0.00,1);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret, short_loan_duration) VALUES (21,'Livre-CD',31,15,0,'',0.00,1);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret, short_loan_duration) VALUES (20,'Jeu',31,15,0,'',0.00,1);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret, short_loan_duration) VALUES (18,'Revue',8,5,0,'',0.00,1);

--
-- Table structure for table `docsloc_section`
--

CREATE TABLE docsloc_section (
  num_section int(5) unsigned NOT NULL DEFAULT '0',
  num_location int(5) unsigned NOT NULL DEFAULT '0',
  num_pclass int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (num_section,num_location)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docsloc_section`
--

INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (10,1,1);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (13,1,-1);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (16,1,-1);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (19,1,-1);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (20,1,-1);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (31,1,0);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (23,1,-1);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (24,1,-1);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (26,1,-1);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (28,1,-1);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (30,1,0);
INSERT INTO docsloc_section (num_section, num_location, num_pclass) VALUES (29,1,-1);

--
-- Table structure for table `docwatch_categories`
--

CREATE TABLE docwatch_categories (
  id_category int(10) unsigned NOT NULL AUTO_INCREMENT,
  category_title varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  category_num_parent int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_category)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docwatch_categories`
--


--
-- Table structure for table `docwatch_datasources`
--

CREATE TABLE docwatch_datasources (
  id_datasource int(10) unsigned NOT NULL AUTO_INCREMENT,
  datasource_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  datasource_title varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  datasource_ttl int(10) unsigned NOT NULL DEFAULT '0',
  datasource_last_date datetime DEFAULT NULL,
  datasource_parameters mediumtext COLLATE utf8_unicode_ci NOT NULL,
  datasource_num_category int(10) unsigned NOT NULL DEFAULT '0',
  datasource_default_interesting int(10) unsigned NOT NULL DEFAULT '0',
  datasource_clean_html int(10) unsigned NOT NULL DEFAULT '1',
  datasource_num_watch int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_datasource),
  KEY i_docwatch_datasource_title (datasource_title)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docwatch_datasources`
--


--
-- Table structure for table `docwatch_items`
--

CREATE TABLE docwatch_items (
  id_item int(10) unsigned NOT NULL AUTO_INCREMENT,
  item_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  item_title varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  item_summary mediumtext COLLATE utf8_unicode_ci NOT NULL,
  item_content mediumtext COLLATE utf8_unicode_ci NOT NULL,
  item_added_date datetime DEFAULT NULL,
  item_publication_date datetime DEFAULT NULL,
  item_hash varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  item_url varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  item_logo_url varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  item_status int(10) unsigned NOT NULL DEFAULT '0',
  item_interesting int(10) unsigned NOT NULL DEFAULT '0',
  item_num_article int(10) unsigned NOT NULL DEFAULT '0',
  item_num_section int(10) unsigned NOT NULL DEFAULT '0',
  item_num_notice int(10) unsigned NOT NULL DEFAULT '0',
  item_num_datasource int(10) unsigned NOT NULL DEFAULT '0',
  item_num_watch int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_item),
  KEY i_docwatch_item_type (item_type),
  KEY i_docwatch_item_title (item_title),
  KEY i_docwatch_item_num_article (item_num_article),
  KEY i_docwatch_item_num_section (item_num_section),
  KEY i_docwatch_item_num_notice (item_num_notice),
  KEY i_docwatch_item_num_watch (item_num_watch)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docwatch_items`
--


--
-- Table structure for table `docwatch_items_descriptors`
--

CREATE TABLE docwatch_items_descriptors (
  num_item int(10) unsigned NOT NULL DEFAULT '0',
  num_noeud int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (num_item,num_noeud)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docwatch_items_descriptors`
--


--
-- Table structure for table `docwatch_items_tags`
--

CREATE TABLE docwatch_items_tags (
  num_item int(10) unsigned NOT NULL DEFAULT '0',
  num_tag int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (num_item,num_tag)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docwatch_items_tags`
--


--
-- Table structure for table `docwatch_selectors`
--

CREATE TABLE docwatch_selectors (
  id_selector int(10) unsigned NOT NULL AUTO_INCREMENT,
  selector_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  selector_num_datasource int(10) unsigned NOT NULL DEFAULT '0',
  selector_parameters mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_selector)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docwatch_selectors`
--


--
-- Table structure for table `docwatch_tags`
--

CREATE TABLE docwatch_tags (
  id_tag int(10) unsigned NOT NULL AUTO_INCREMENT,
  tag_title varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_tag)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docwatch_tags`
--


--
-- Table structure for table `docwatch_watches`
--

CREATE TABLE docwatch_watches (
  id_watch int(10) unsigned NOT NULL AUTO_INCREMENT,
  watch_title varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  watch_owner int(10) unsigned NOT NULL DEFAULT '0',
  watch_allowed_users varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  watch_num_category int(10) unsigned NOT NULL DEFAULT '0',
  watch_last_date datetime DEFAULT NULL,
  watch_ttl int(10) unsigned NOT NULL DEFAULT '0',
  watch_desc text COLLATE utf8_unicode_ci NOT NULL,
  watch_logo_url varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  watch_record_default_type char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  watch_record_default_status int(10) unsigned NOT NULL DEFAULT '0',
  watch_article_default_parent int(10) unsigned NOT NULL DEFAULT '0',
  watch_article_default_content_type int(10) unsigned NOT NULL DEFAULT '0',
  watch_article_default_publication_status int(10) unsigned NOT NULL DEFAULT '0',
  watch_section_default_parent int(10) unsigned NOT NULL DEFAULT '0',
  watch_section_default_content_type int(10) unsigned NOT NULL DEFAULT '0',
  watch_section_default_publication_status int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_watch),
  KEY i_docwatch_watch_title (watch_title)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `docwatch_watches`
--


--
-- Table structure for table `dsi_archive`
--

CREATE TABLE dsi_archive (
  num_banette_arc int(10) unsigned NOT NULL DEFAULT '0',
  num_notice_arc int(10) unsigned NOT NULL DEFAULT '0',
  date_diff_arc date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (num_banette_arc,num_notice_arc,date_diff_arc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dsi_archive`
--


--
-- Table structure for table `editions_states`
--

CREATE TABLE editions_states (
  id_editions_state int(10) unsigned NOT NULL AUTO_INCREMENT,
  editions_state_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  editions_state_num_classement int(11) NOT NULL DEFAULT '0',
  editions_state_used_datasource varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  editions_state_comment mediumtext COLLATE utf8_unicode_ci NOT NULL,
  editions_state_fieldslist mediumtext COLLATE utf8_unicode_ci NOT NULL,
  editions_state_fieldsparams mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_editions_state)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `editions_states`
--


--
-- Table structure for table `empr`
--

CREATE TABLE empr (
  id_empr int(10) unsigned NOT NULL AUTO_INCREMENT,
  empr_cb varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  empr_nom varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_prenom varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_adr1 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_adr2 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_cp varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_ville varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_pays varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_mail varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_tel1 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_tel2 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_prof varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_year int(4) unsigned NOT NULL DEFAULT '0',
  empr_categ smallint(5) unsigned NOT NULL DEFAULT '0',
  empr_codestat smallint(5) unsigned NOT NULL DEFAULT '0',
  empr_creation datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  empr_modif date NOT NULL DEFAULT '0000-00-00',
  empr_sexe tinyint(3) unsigned NOT NULL DEFAULT '0',
  empr_login varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_password varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_password_is_encrypted int(1) NOT NULL DEFAULT '0',
  empr_digest varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_date_adhesion date DEFAULT NULL,
  empr_date_expiration date DEFAULT NULL,
  empr_msg text COLLATE utf8_unicode_ci,
  empr_lang varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr_FR',
  empr_ldap tinyint(1) unsigned DEFAULT '0',
  type_abt int(1) NOT NULL DEFAULT '0',
  last_loan_date date DEFAULT NULL,
  empr_location int(6) unsigned NOT NULL DEFAULT '1',
  date_fin_blocage date NOT NULL DEFAULT '0000-00-00',
  total_loans bigint(20) unsigned NOT NULL DEFAULT '0',
  empr_statut bigint(20) unsigned NOT NULL DEFAULT '1',
  cle_validation varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  empr_sms int(1) unsigned NOT NULL DEFAULT '0',
  empr_subscription_action text COLLATE utf8_unicode_ci,
  PRIMARY KEY (id_empr),
  UNIQUE KEY empr_cb (empr_cb),
  KEY empr_nom (empr_nom),
  KEY empr_date_adhesion (empr_date_adhesion),
  KEY empr_date_expiration (empr_date_expiration),
  KEY i_empr_categ (empr_categ),
  KEY i_empr_codestat (empr_codestat),
  KEY i_empr_location (empr_location),
  KEY i_empr_statut (empr_statut),
  KEY i_empr_typabt (type_abt)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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,8,4,'2012-10-22 00:00:00','2012-10-24',1,'100001','1',0,'','2012-10-22','2013-10-22','','fr_FR',0,0,'2012-11-20',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,4,'2012-10-22 00:00:00','2012-10-24',1,'hsolo','hsolo',0,'','2012-10-22','2013-10-22','','fr_FR',0,0,'0000-00-00',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,'2012-10-22 00:00:00','2012-10-22',1,'lskywalker','lskywalker',0,'','2012-10-22','2013-10-22','','fr_FR',0,0,'0000-00-00',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,4,'2012-10-22 00:00:00','2012-10-24',2,'100004','4',0,'','2012-10-22','2013-10-22','','fr_FR',0,0,'0000-00-00',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,4,'2012-10-22 00:00:00','2012-10-24',1,'100005','5',0,'','2012-10-22','2013-10-22','','fr_FR',0,0,'0000-00-00',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,7,3,'2012-10-22 00:00:00','2012-10-24',1,'erobert','1967',0,'','2012-10-22','2013-10-22','','fr_FR',0,0,'0000-00-00',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,'2012-10-22 00:00:00','2012-10-22',1,'ftetart','727272',0,'','2012-10-22','2013-10-22','','fr_FR',0,0,'2012-11-20',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 (10,'100008','BENARD','Camille','PMB Services','','72500','CHATEAU DU LOIR','','cbenard@sigb.net','','','Formatrice',1985,7,3,'2012-10-24 10:58:04','2012-10-24',2,'cbenard','1985',0,'','2012-10-24','2013-10-24','','fr_FR',0,0,'2012-11-20',1,'0000-00-00',0,1,'',0,NULL);

--
-- Table structure for table `empr_caddie`
--

CREATE TABLE empr_caddie (
  idemprcaddie int(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  autorisations longtext COLLATE utf8_unicode_ci,
  empr_caddie_classement varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idemprcaddie)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_caddie`
--

INSERT INTO empr_caddie (idemprcaddie, name, comment, autorisations, empr_caddie_classement) VALUES (2,'Exemple de panier de lecteurs','','1','');

--
-- Table structure for table `empr_caddie_content`
--

CREATE TABLE empr_caddie_content (
  empr_caddie_id int(8) unsigned NOT NULL DEFAULT '0',
  object_id int(10) unsigned NOT NULL DEFAULT '0',
  flag varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (empr_caddie_id,object_id),
  KEY object_id (object_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_caddie_content`
--

INSERT INTO empr_caddie_content (empr_caddie_id, object_id, flag) VALUES (1,1,'');

--
-- Table structure for table `empr_caddie_procs`
--

CREATE TABLE empr_caddie_procs (
  idproc smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SELECT',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  requete blob NOT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  autorisations longtext COLLATE utf8_unicode_ci,
  parameters mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (idproc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_caddie_procs`
--


--
-- Table structure for table `empr_categ`
--

CREATE TABLE empr_categ (
  id_categ_empr smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  duree_adhesion int(10) unsigned DEFAULT '365',
  tarif_abt decimal(16,2) NOT NULL DEFAULT '0.00',
  age_min int(3) unsigned NOT NULL DEFAULT '0',
  age_max int(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_categ_empr)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_categ`
--

INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt, age_min, age_max) VALUES (7,'Individuel payant',365,10.00,0,0);
INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt, age_min, age_max) VALUES (8,'Individuel gratuit',365,0.00,0,0);
INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt, age_min, age_max) VALUES (9,'Personnel',365,0.00,0,0);
INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt, age_min, age_max) VALUES (10,'Collectivité',365,0.00,0,0);

--
-- Table structure for table `empr_codestat`
--

CREATE TABLE empr_codestat (
  idcode smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'DEFAULT',
  PRIMARY KEY (idcode)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_codestat`
--

INSERT INTO empr_codestat (idcode, libelle) VALUES (3,'Commune');
INSERT INTO empr_codestat (idcode, libelle) VALUES (4,'Hors commune');

--
-- Table structure for table `empr_custom`
--

CREATE TABLE empr_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` mediumtext COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) DEFAULT NULL,
  search int(1) unsigned NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  exclusion_obligatoire int(1) unsigned NOT NULL DEFAULT '0',
  pond int(11) NOT NULL DEFAULT '100',
  opac_sort int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_custom`
--

INSERT INTO empr_custom (idchamp, name, titre, type, datatype, options, multiple, obligatoire, ordre, search, export, exclusion_obligatoire, pond, opac_sort) VALUES (1,'cp_commentaire','Commentaire','comment','text','<OPTIONS FOR=\"comment\">\r\n <COLS>100</COLS>\r\n <ROWS>4</ROWS>\r\n <MAXSIZE>1000</MAXSIZE>\r\n</OPTIONS> ',0,0,1,0,0,0,100,0);

--
-- Table structure for table `empr_custom_lists`
--

CREATE TABLE empr_custom_lists (
  empr_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  empr_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  empr_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY empr_custom_champ (empr_custom_champ),
  KEY i_ecl_lv (empr_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_custom_lists`
--


--
-- Table structure for table `empr_custom_values`
--

CREATE TABLE empr_custom_values (
  empr_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  empr_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  empr_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  empr_custom_text mediumtext COLLATE utf8_unicode_ci,
  empr_custom_integer int(11) DEFAULT NULL,
  empr_custom_date date DEFAULT NULL,
  empr_custom_float float DEFAULT NULL,
  KEY empr_custom_champ (empr_custom_champ),
  KEY empr_custom_origine (empr_custom_origine),
  KEY i_ecv_st (empr_custom_small_text),
  KEY i_ecv_t (empr_custom_text(255)),
  KEY i_ecv_i (empr_custom_integer),
  KEY i_ecv_d (empr_custom_date),
  KEY i_ecv_f (empr_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_custom_values`
--


--
-- Table structure for table `empr_grilles`
--

CREATE TABLE empr_grilles (
  empr_grille_categ int(5) NOT NULL DEFAULT '0',
  empr_grille_location int(5) NOT NULL DEFAULT '0',
  empr_grille_format longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (empr_grille_categ,empr_grille_location)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_grilles`
--


--
-- Table structure for table `empr_groupe`
--

CREATE TABLE empr_groupe (
  empr_id int(6) unsigned NOT NULL DEFAULT '0',
  groupe_id int(6) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (empr_id,groupe_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_groupe`
--

INSERT INTO empr_groupe (empr_id, groupe_id) VALUES (10,0);

--
-- Table structure for table `empr_statut`
--

CREATE TABLE empr_statut (
  idstatut smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  statut_libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  allow_loan tinyint(4) NOT NULL DEFAULT '1',
  allow_loan_hist tinyint(4) unsigned NOT NULL DEFAULT '0',
  allow_book tinyint(4) NOT NULL DEFAULT '1',
  allow_opac tinyint(4) NOT NULL DEFAULT '1',
  allow_dsi tinyint(4) NOT NULL DEFAULT '1',
  allow_dsi_priv tinyint(4) NOT NULL DEFAULT '1',
  allow_sugg tinyint(4) NOT NULL DEFAULT '1',
  allow_dema tinyint(4) unsigned NOT NULL DEFAULT '1',
  allow_prol tinyint(4) NOT NULL DEFAULT '1',
  allow_avis tinyint(4) unsigned NOT NULL DEFAULT '1',
  allow_tag tinyint(4) unsigned NOT NULL DEFAULT '1',
  allow_pwd tinyint(4) unsigned NOT NULL DEFAULT '1',
  allow_liste_lecture tinyint(4) unsigned NOT NULL DEFAULT '0',
  allow_self_checkout tinyint(4) unsigned NOT NULL DEFAULT '0',
  allow_self_checkin tinyint(4) unsigned NOT NULL DEFAULT '0',
  allow_serialcirc int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (idstatut)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empr_statut`
--

INSERT INTO empr_statut (idstatut, statut_libelle, allow_loan, allow_loan_hist, allow_book, allow_opac, allow_dsi, allow_dsi_priv, allow_sugg, allow_dema, allow_prol, allow_avis, allow_tag, allow_pwd, allow_liste_lecture, allow_self_checkout, allow_self_checkin, allow_serialcirc) VALUES (1,'Actif',1,0,1,1,1,1,1,1,1,1,1,1,1,0,0,0);
INSERT INTO empr_statut (idstatut, statut_libelle, allow_loan, allow_loan_hist, allow_book, allow_opac, allow_dsi, allow_dsi_priv, allow_sugg, allow_dema, allow_prol, allow_avis, allow_tag, allow_pwd, allow_liste_lecture, allow_self_checkout, allow_self_checkin, allow_serialcirc) VALUES (2,'Interdit',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `empty_words_calculs`
--

CREATE TABLE empty_words_calculs (
  id_calcul int(9) unsigned NOT NULL AUTO_INCREMENT,
  date_calcul date NOT NULL DEFAULT '0000-00-00',
  php_empty_words mediumtext COLLATE utf8_unicode_ci NOT NULL,
  nb_notices_calcul mediumint(8) unsigned NOT NULL DEFAULT '0',
  archive_calcul tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_calcul)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `empty_words_calculs`
--


--
-- Table structure for table `entites`
--

CREATE TABLE entites (
  id_entite int(5) unsigned NOT NULL AUTO_INCREMENT,
  type_entite int(3) unsigned NOT NULL DEFAULT '0',
  num_bibli int(5) unsigned NOT NULL DEFAULT '0',
  raison_sociale varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  commentaires mediumtext COLLATE utf8_unicode_ci,
  siret varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  naf varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  rcs varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tva varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_cp_client varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_cp_compta varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  site_web varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  logo varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  autorisations longtext COLLATE utf8_unicode_ci NOT NULL,
  num_frais int(8) unsigned NOT NULL DEFAULT '0',
  num_paiement int(8) unsigned NOT NULL DEFAULT '0',
  index_entite mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_entite),
  KEY raison_sociale (raison_sociale)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `entites`
--


--
-- Table structure for table `entrepot_source_1`
--

CREATE TABLE entrepot_source_1 (
  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` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  i_value mediumtext 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 `entrepot_source_1`
--


--
-- 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` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  i_value mediumtext 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 `entrepot_source_2`
--


--
-- Table structure for table `entrepot_source_3`
--

CREATE TABLE entrepot_source_3 (
  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` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  i_value mediumtext 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 `entrepot_source_3`
--


--
-- 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` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  i_value mediumtext 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 `entrepot_source_4`
--


--
-- 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` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  i_value mediumtext 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 `entrepot_source_5`
--


--
-- Table structure for table `entrepot_source_6`
--

CREATE TABLE entrepot_source_6 (
  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` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  i_value mediumtext 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 `entrepot_source_6`
--


--
-- Table structure for table `entrepot_source_7`
--

CREATE TABLE entrepot_source_7 (
  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` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  i_value mediumtext 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 `entrepot_source_7`
--


--
-- Table structure for table `entrepot_source_8`
--

CREATE TABLE entrepot_source_8 (
  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` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  i_value mediumtext 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 `entrepot_source_8`
--


--
-- Table structure for table `entrepots_localisations`
--

CREATE TABLE entrepots_localisations (
  loc_id int(11) NOT NULL AUTO_INCREMENT,
  loc_code varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  loc_libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  loc_visible tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (loc_id),
  UNIQUE KEY loc_code (loc_code)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `entrepots_localisations`
--


--
-- Table structure for table `equations`
--

CREATE TABLE equations (
  id_equation int(9) unsigned NOT NULL AUTO_INCREMENT,
  num_classement int(8) unsigned NOT NULL DEFAULT '1',
  nom_equation text COLLATE utf8_unicode_ci NOT NULL,
  comment_equation varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  requete blob NOT NULL,
  proprio_equation int(9) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_equation)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `error_log`
--

CREATE TABLE error_log (
  error_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  error_origin varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  error_text mediumtext COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `error_log`
--


--
-- Table structure for table `es_cache`
--

CREATE TABLE es_cache (
  escache_groupname varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  escache_unique_id varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  escache_value int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (escache_groupname,escache_unique_id,escache_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_cache`
--


--
-- Table structure for table `es_cache_blob`
--

CREATE TABLE es_cache_blob (
  es_cache_objectref varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_cache_objecttype int(11) NOT NULL DEFAULT '0',
  es_cache_objectformat varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_cache_owner varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_cache_creationdate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  es_cache_expirationdate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  es_cache_content mediumblob NOT NULL,
  PRIMARY KEY (es_cache_objectref,es_cache_objecttype,es_cache_objectformat,es_cache_owner),
  KEY cache_index (es_cache_owner,es_cache_objectformat,es_cache_objecttype)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_cache_blob`
--


--
-- Table structure for table `es_cache_int`
--

CREATE TABLE es_cache_int (
  es_cache_objectref varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_cache_objecttype int(11) NOT NULL DEFAULT '0',
  es_cache_objectformat varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_cache_owner varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_cache_creationdate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  es_cache_expirationdate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  es_cache_content int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (es_cache_objectref,es_cache_objecttype,es_cache_objectformat,es_cache_owner),
  KEY cache_index (es_cache_owner,es_cache_objectformat,es_cache_objecttype)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_cache_int`
--


--
-- Table structure for table `es_converted_cache`
--

CREATE TABLE es_converted_cache (
  es_converted_cache_objecttype int(11) NOT NULL DEFAULT '0',
  es_converted_cache_objectref int(11) NOT NULL DEFAULT '0',
  es_converted_cache_format varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_converted_cache_value mediumtext COLLATE utf8_unicode_ci NOT NULL,
  es_converted_cache_bestbefore datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (es_converted_cache_objecttype,es_converted_cache_objectref,es_converted_cache_format)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_converted_cache`
--


--
-- Table structure for table `es_esgroup_esusers`
--

CREATE TABLE es_esgroup_esusers (
  esgroupuser_groupnum int(11) NOT NULL DEFAULT '0',
  esgroupuser_usertype int(4) NOT NULL DEFAULT '0',
  esgroupuser_usernum int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (esgroupuser_usernum,esgroupuser_groupnum,esgroupuser_usertype)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_esgroup_esusers`
--


--
-- Table structure for table `es_esgroups`
--

CREATE TABLE es_esgroups (
  esgroup_id int(11) NOT NULL AUTO_INCREMENT,
  esgroup_name varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  esgroup_fullname varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  esgroup_pmbusernum int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (esgroup_id),
  UNIQUE KEY esgroup_name (esgroup_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_esgroups`
--


--
-- Table structure for table `es_esusers`
--

CREATE TABLE es_esusers (
  esuser_id int(11) NOT NULL AUTO_INCREMENT,
  esuser_username varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  esuser_password varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  esuser_fullname varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  esuser_groupnum int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (esuser_id),
  UNIQUE KEY esuser_username (esuser_username)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_esusers`
--


--
-- Table structure for table `es_methods`
--

CREATE TABLE es_methods (
  id_method int(10) unsigned NOT NULL AUTO_INCREMENT,
  groupe varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  method varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  available smallint(5) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (id_method)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_methods`
--


--
-- Table structure for table `es_methods_users`
--

CREATE TABLE es_methods_users (
  num_method int(10) unsigned NOT NULL DEFAULT '0',
  num_user int(10) unsigned NOT NULL DEFAULT '0',
  anonymous smallint(6) DEFAULT '0',
  PRIMARY KEY (num_method,num_user)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_methods_users`
--


--
-- Table structure for table `es_searchcache`
--

CREATE TABLE es_searchcache (
  es_searchcache_searchid varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_searchcache_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  es_searchcache_serializedsearch mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (es_searchcache_searchid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_searchcache`
--


--
-- Table structure for table `es_searchsessions`
--

CREATE TABLE es_searchsessions (
  es_searchsession_id varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_searchsession_searchnum varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_searchsession_searchrealm varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  es_searchsession_pmbuserid int(11) NOT NULL DEFAULT '-1',
  es_searchsession_opacemprid int(11) NOT NULL DEFAULT '-1',
  es_searchsession_lastseendate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (es_searchsession_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `es_searchsessions`
--


--
-- Table structure for table `etagere`
--

CREATE TABLE etagere (
  idetagere int(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` blob NOT NULL,
  validite int(1) unsigned NOT NULL DEFAULT '0',
  validite_date_deb date NOT NULL DEFAULT '0000-00-00',
  validite_date_fin date NOT NULL DEFAULT '0000-00-00',
  visible_accueil int(1) unsigned NOT NULL DEFAULT '1',
  autorisations longtext COLLATE utf8_unicode_ci,
  id_tri int(11) NOT NULL,
  thumbnail_url mediumblob NOT NULL,
  etagere_classement varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idetagere),
  KEY i_id_tri (id_tri)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `etagere`
--

INSERT INTO etagere (idetagere, name, comment, validite, validite_date_deb, validite_date_fin, visible_accueil, autorisations, id_tri, thumbnail_url, etagere_classement) VALUES (3,'Nouveautés','',1,'0000-00-00','0000-00-00',0,'1',0,'','');
INSERT INTO etagere (idetagere, name, comment, validite, validite_date_deb, validite_date_fin, visible_accueil, autorisations, id_tri, thumbnail_url, etagere_classement) VALUES (4,'Nouveautés fiction adultes','',1,'0000-00-00','0000-00-00',0,'1',0,'','');
INSERT INTO etagere (idetagere, name, comment, validite, validite_date_deb, validite_date_fin, visible_accueil, autorisations, id_tri, thumbnail_url, etagere_classement) VALUES (5,'Nouveautés fiction jeunesse','',1,'0000-00-00','0000-00-00',0,'1',0,'','');
INSERT INTO etagere (idetagere, name, comment, validite, validite_date_deb, validite_date_fin, visible_accueil, autorisations, id_tri, thumbnail_url, etagere_classement) VALUES (6,'Nouveautés documentaires','',1,'0000-00-00','0000-00-00',0,'1',0,'','');
INSERT INTO etagere (idetagere, name, comment, validite, validite_date_deb, validite_date_fin, visible_accueil, autorisations, id_tri, thumbnail_url, etagere_classement) VALUES (7,'Nouveautés CD','',1,'0000-00-00','0000-00-00',0,'1',0,'','');
INSERT INTO etagere (idetagere, name, comment, validite, validite_date_deb, validite_date_fin, visible_accueil, autorisations, id_tri, thumbnail_url, etagere_classement) VALUES (8,'Nouveautés DVD','',1,'0000-00-00','0000-00-00',0,'1',0,'','');
INSERT INTO etagere (idetagere, name, comment, validite, validite_date_deb, validite_date_fin, visible_accueil, autorisations, id_tri, thumbnail_url, etagere_classement) VALUES (9,'Nouveautés périodiques','',1,'0000-00-00','0000-00-00',0,'1',0,'','');

--
-- Table structure for table `etagere_caddie`
--

CREATE TABLE etagere_caddie (
  etagere_id int(8) unsigned NOT NULL DEFAULT '0',
  caddie_id int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (etagere_id,caddie_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `etagere_caddie`
--

INSERT INTO etagere_caddie (etagere_id, caddie_id) VALUES (3,12);
INSERT INTO etagere_caddie (etagere_id, caddie_id) VALUES (4,13);
INSERT INTO etagere_caddie (etagere_id, caddie_id) VALUES (5,14);
INSERT INTO etagere_caddie (etagere_id, caddie_id) VALUES (6,15);
INSERT INTO etagere_caddie (etagere_id, caddie_id) VALUES (7,16);
INSERT INTO etagere_caddie (etagere_id, caddie_id) VALUES (8,17);
INSERT INTO etagere_caddie (etagere_id, caddie_id) VALUES (9,18);

--
-- Table structure for table `exemplaires`
--

CREATE TABLE exemplaires (
  expl_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  expl_cb varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  expl_notice int(10) unsigned NOT NULL DEFAULT '0',
  expl_bulletin int(10) unsigned NOT NULL DEFAULT '0',
  expl_typdoc int(5) unsigned NOT NULL DEFAULT '0',
  expl_cote varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  expl_section smallint(5) unsigned NOT NULL DEFAULT '0',
  expl_statut smallint(5) unsigned NOT NULL DEFAULT '0',
  expl_location smallint(5) unsigned NOT NULL DEFAULT '0',
  expl_codestat smallint(5) unsigned NOT NULL DEFAULT '0',
  expl_date_depot date NOT NULL DEFAULT '0000-00-00',
  expl_date_retour date NOT NULL DEFAULT '0000-00-00',
  expl_note text COLLATE utf8_unicode_ci NOT NULL,
  expl_prix varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  expl_owner mediumint(8) unsigned NOT NULL DEFAULT '0',
  expl_lastempr int(10) unsigned NOT NULL DEFAULT '0',
  last_loan_date date DEFAULT NULL,
  create_date datetime NOT NULL DEFAULT '2005-01-01 00:00:00',
  update_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  type_antivol int(1) unsigned NOT NULL DEFAULT '0',
  transfert_location_origine smallint(5) unsigned NOT NULL DEFAULT '0',
  transfert_statut_origine smallint(5) unsigned NOT NULL DEFAULT '0',
  expl_comment mediumtext COLLATE utf8_unicode_ci,
  expl_nbparts int(8) unsigned NOT NULL DEFAULT '1',
  expl_retloc smallint(5) unsigned NOT NULL DEFAULT '0',
  expl_abt_num int(10) unsigned NOT NULL DEFAULT '0',
  transfert_section_origine smallint(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (expl_id),
  UNIQUE KEY expl_cb (expl_cb),
  KEY expl_typdoc (expl_typdoc),
  KEY expl_cote (expl_cote),
  KEY expl_notice (expl_notice),
  KEY expl_codestat (expl_codestat),
  KEY expl_owner (expl_owner),
  KEY expl_bulletin (expl_bulletin),
  KEY i_expl_location (expl_location),
  KEY i_expl_section (expl_section),
  KEY i_expl_statut (expl_statut),
  KEY i_expl_lastempr (expl_lastempr)
) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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 (70,'000034',89,0,1,'640 BEL',10,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:51:07','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (69,'000033',90,0,1,'910 J NAN',10,1,1,11,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:50:05','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (68,'000032',95,0,1,'A COR',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:47:57','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (67,'000031',95,0,1,'A COR',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:47:46','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (66,'000030',91,0,1,'A GOU',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:47:29','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (64,'000028',93,0,1,'A GAY',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:46:15','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (65,'000029',92,0,1,'BD J GUE',20,1,1,11,'0000-00-00','0000-00-00','','',1,0,'2012-11-20','2012-10-24 15:46:57','2015-05-18 09:14:16',0,1,1,'',1,0,0,20);
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 (63,'000027',93,0,1,'A GAY',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:46:03','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (62,'000026',94,0,1,'580 J GUI',10,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:44:59','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (61,'000025',95,0,1,'A COR',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:42:34','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (60,'000024',96,0,1,'640 J LOU',10,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:41:59','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (59,'000023',97,0,1,'640 J SER',10,1,1,11,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:40:56','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (58,'000022',98,0,1,'640 J TEY',10,1,1,11,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:40:04','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (57,'000021',99,0,1,'740 FRE',10,1,1,11,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:37:53','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (56,'000020',100,0,1,'740 J FRE',10,1,1,11,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:36:34','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (55,'000019',101,0,1,'A BRA',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:35:11','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (54,'000018',102,0,1,'A GRA',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:34:08','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (52,'000016',104,0,1,'RX PRA',24,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:31:12','2015-05-18 09:14:16',0,1,1,'',1,0,0,24);
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 (53,'000017',103,0,1,'RX BRA',24,1,1,12,'0000-00-00','0000-00-00','','',2,0,'2012-11-20','2012-10-24 15:32:35','2015-05-18 09:14:16',0,1,1,'',1,0,0,24);
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 (51,'000015',105,0,1,'RX PRA',24,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:30:15','2015-05-18 09:14:16',0,1,1,'',1,0,0,24);
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 (50,'000014',106,0,1,'P BUR',10,1,1,12,'0000-00-00','0000-00-00','','',2,0,'2012-11-20','2012-10-24 15:28:12','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (49,'000013',107,0,18,'700 J TIM',10,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:24:29','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (48,'000012',108,0,1,'700 DEB',10,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:22:58','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (47,'000011',109,0,1,'780 J SIL',10,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:21:13','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (46,'000010',119,0,13,'9.1 AMA',28,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:15:23','2015-05-18 09:14:16',0,1,1,'',1,0,0,28);
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 (45,'000009',118,0,13,'9.1 KEI',28,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:12:02','2015-05-18 09:14:16',0,1,1,'',1,0,0,28);
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 (44,'000008',117,0,13,'9.1 TRA',28,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:10:29','2015-05-18 09:14:16',0,1,1,'',1,0,0,28);
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 (43,'000007',116,0,13,'9.1 LO',28,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:08:49','2015-05-18 09:14:16',0,1,1,'',1,0,0,28);
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 (42,'000006',115,0,13,'9.1 MAK',28,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:06:05','2015-05-18 09:14:16',0,1,1,'',1,0,0,28);
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 (41,'000005',114,0,14,'DVDJ CHAR',29,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:00:33','2015-05-18 09:14:16',0,1,1,'',1,0,0,29);
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 (38,'000002',112,0,14,'DVD BIG',29,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 14:55:48','2015-05-18 09:14:16',0,1,1,'',1,0,0,29);
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 (39,'000003',111,0,14,'DVD BEE',29,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 14:56:07','2015-05-18 09:14:16',0,1,1,'',1,0,0,29);
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 (40,'000004',113,0,14,'DVDJ NOC',29,1,1,11,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 14:58:15','2015-05-18 09:14:16',0,1,1,'',1,0,0,29);
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 (37,'000001',110,0,14,'DVD EDW',29,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 14:49:39','2015-05-18 09:14:16',0,1,1,'',1,0,0,29);
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 (71,'000036',88,0,1,'020 BON',10,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:53:02','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (72,'000037',87,0,1,'RJ MAH',13,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:53:51','2015-05-18 09:14:16',0,1,1,'',1,0,0,13);
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 (73,'000038',86,0,1,'RP BEI',24,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:54:44','2015-05-18 09:14:16',0,1,1,'',1,0,0,24);
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 (74,'000039',85,0,1,'JR BRI',13,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:56:03','2015-05-18 09:14:16',0,1,1,'',1,0,0,13);
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 (75,'000040',84,0,1,'020 PAL',10,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:56:41','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (76,'000041',83,0,1,'020 ASS',10,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:57:56','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (77,'000042',83,0,1,'020 ASS',30,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 15:58:06','2015-05-18 09:14:16',0,1,1,'',1,0,0,30);
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 (78,'000044',82,0,1,'020 MEL',10,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 15:58:46','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (79,'000045',81,0,1,'RJP HEI',13,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:00:11','2015-05-18 09:14:16',0,1,1,'',1,0,0,13);
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 (80,'000046',80,0,1,'RJ GUD',13,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:01:15','2015-05-18 09:14:16',0,1,1,'',1,0,0,13);
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 (81,'000047',79,0,1,'A GRA',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:03:09','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (82,'000048',78,0,1,'R MAR',24,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 16:04:11','2015-05-18 09:14:16',0,1,1,'',1,0,0,24);
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 (83,'000049',77,0,1,'R MAB',24,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:04:54','2015-05-18 09:14:16',0,1,1,'',1,0,0,24);
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 (84,'000050',76,0,1,'BD ABO',16,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:05:39','2015-05-18 09:14:16',0,1,1,'',1,0,0,16);
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 (85,'000051',75,0,1,'BD ABO',16,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:06:17','2015-05-18 09:14:16',0,1,1,'',1,0,0,16);
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 (86,'000052',74,0,1,'A DEB',26,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:07:32','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (87,'000053',74,0,1,'A DEB',26,1,1,11,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 16:07:46','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (88,'000054',73,0,1,'A DED',26,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:08:33','2015-05-18 09:14:16',0,1,1,'',1,0,0,26);
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 (89,'000056',72,0,21,'780 J GRO',10,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:10:14','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (90,'000057',71,0,1,'960 DEP',10,1,1,12,'0000-00-00','0000-00-00','','',1,0,'2012-11-20','2012-10-24 16:11:51','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (91,'000058',70,0,1,'960 ZAI',10,1,1,12,'0000-00-00','0000-00-00','','',1,0,NULL,'2012-10-24 16:13:32','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (92,'000059',69,0,1,'C BAA',10,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:14:22','2015-05-18 09:14:16',0,1,1,'',1,0,0,10);
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 (93,'000060',68,0,19,'RA BLI',24,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 16:15:37','2015-05-18 09:14:16',0,1,1,'',1,0,0,24);
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 (94,'P000002',0,5,18,'PER GEO',31,1,1,12,'0000-00-00','0000-00-00','','',2,0,'2012-11-20','2012-10-24 17:27:03','2015-05-18 09:14:16',0,1,1,'',0,0,0,31);
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 (95,'P000003',0,4,18,'PER GEO',31,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 17:27:22','2015-05-18 09:14:16',0,1,1,'',0,0,0,31);
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 (96,'P000004',0,9,18,'PER J GEO',31,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 18:12:58','2015-05-18 09:14:16',0,1,1,'',0,0,0,31);
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 (97,'P000005',0,10,18,'PER J GEO',31,1,1,11,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-24 18:14:42','2015-05-18 09:14:16',0,1,1,'',0,0,0,31);
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 (98,'P000006',0,11,18,'PER STU',31,1,1,12,'0000-00-00','0000-00-00','','',2,0,NULL,'2012-10-25 09:23:28','2015-05-18 09:14:16',0,1,1,'',0,0,0,31);

--
-- Table structure for table `exemplaires_temp`
--

CREATE TABLE exemplaires_temp (
  cb varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  sess varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  UNIQUE KEY cb (cb)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `exemplaires_temp`
--


--
-- Table structure for table `exercices`
--

CREATE TABLE exercices (
  id_exercice int(8) unsigned NOT NULL AUTO_INCREMENT,
  num_entite int(5) unsigned NOT NULL DEFAULT '0',
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  date_debut date NOT NULL DEFAULT '2006-01-01',
  date_fin date NOT NULL DEFAULT '2006-01-01',
  statut int(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (id_exercice)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `exercices`
--


--
-- Table structure for table `expl_custom`
--

CREATE TABLE expl_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` mediumtext COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) DEFAULT NULL,
  search int(1) unsigned NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  exclusion_obligatoire int(1) unsigned NOT NULL DEFAULT '0',
  pond int(11) NOT NULL DEFAULT '100',
  opac_sort int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `expl_custom`
--

INSERT INTO expl_custom (idchamp, name, titre, type, datatype, options, multiple, obligatoire, ordre, search, export, exclusion_obligatoire, pond, opac_sort) VALUES (1,'cp_date_acquisition','Date d\'acquisition','date_box','date','<OPTIONS FOR=\"date_box\"></OPTIONS> ',0,0,1,0,1,0,100,0);
INSERT INTO expl_custom (idchamp, name, titre, type, datatype, options, multiple, obligatoire, ordre, search, export, exclusion_obligatoire, pond, opac_sort) VALUES (2,'cp_date_pilon','Date de pilon','date_box','date','<OPTIONS FOR=\"date_box\">\r\n <DEFAULT_TODAY>yes</DEFAULT_TODAY>\r\n</OPTIONS> ',0,0,2,0,1,0,100,0);
INSERT INTO expl_custom (idchamp, name, titre, type, datatype, options, multiple, obligatoire, ordre, search, export, exclusion_obligatoire, pond, opac_sort) VALUES (3,'cp_origine','Origine','list','small_text','<OPTIONS FOR=\"list\">\r\n <MULTIPLE>no</MULTIPLE>\r\n <AUTORITE>no</AUTORITE>\r\n <CHECKBOX>no</CHECKBOX>\r\n <NUM_AUTO>no</NUM_AUTO>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[Choisissez une origine]]></UNSELECT_ITEM>\r\n <DEFAULT_VALUE></DEFAULT_VALUE>\r\n <CHECKBOX_NB_ON_LINE></CHECKBOX_NB_ON_LINE>\r\n</OPTIONS>',0,0,3,0,1,0,100,0);

--
-- Table structure for table `expl_custom_lists`
--

CREATE TABLE expl_custom_lists (
  expl_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  expl_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  expl_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY expl_custom_champ (expl_custom_champ),
  KEY i_excl_lv (expl_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `expl_custom_lists`
--

INSERT INTO expl_custom_lists (expl_custom_champ, expl_custom_list_value, expl_custom_list_lib, ordre) VALUES (3,'ACH','Achat',1);
INSERT INTO expl_custom_lists (expl_custom_champ, expl_custom_list_value, expl_custom_list_lib, ordre) VALUES (3,'DON','Don',2);
INSERT INTO expl_custom_lists (expl_custom_champ, expl_custom_list_value, expl_custom_list_lib, ordre) VALUES (3,'DEP','Dépôt',3);

--
-- Table structure for table `expl_custom_values`
--

CREATE TABLE expl_custom_values (
  expl_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  expl_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  expl_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  expl_custom_text mediumtext COLLATE utf8_unicode_ci,
  expl_custom_integer int(11) DEFAULT NULL,
  expl_custom_date date DEFAULT NULL,
  expl_custom_float float DEFAULT NULL,
  KEY expl_custom_champ (expl_custom_champ),
  KEY expl_custom_origine (expl_custom_origine),
  KEY i_excv_st (expl_custom_small_text),
  KEY i_excv_t (expl_custom_text(255)),
  KEY i_excv_i (expl_custom_integer),
  KEY i_excv_d (expl_custom_date),
  KEY i_excv_f (expl_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `expl_custom_values`
--

INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,37,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,37,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,41,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,38,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,39,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,39,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,40,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,41,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,42,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,42,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,43,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,44,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,44,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,45,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,46,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,46,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,47,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,47,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,48,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,49,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,49,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,50,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,50,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,51,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,52,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,53,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,53,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,52,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,54,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,54,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,55,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,55,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,56,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,57,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,56,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,58,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,59,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,58,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,60,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,60,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,61,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,61,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,62,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,62,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,63,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,63,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,64,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,64,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,65,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,66,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,66,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,67,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,67,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,68,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,68,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,69,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,70,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,70,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,71,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,71,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,72,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,72,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,73,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,73,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,74,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,74,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,75,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,76,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,76,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,77,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,77,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,78,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,79,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,79,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,80,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,80,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,81,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,81,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,82,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,83,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,83,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,84,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,84,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,85,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,85,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,86,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,86,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,87,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,88,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,88,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,89,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,89,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,90,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,91,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,91,'DEP',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,92,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,92,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,93,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,93,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,94,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,94,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,95,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,95,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,96,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,96,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,97,NULL,NULL,NULL,'2012-10-24',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,97,'ACH',NULL,NULL,NULL,NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (1,98,NULL,NULL,NULL,'2012-10-25',NULL);
INSERT INTO expl_custom_values (expl_custom_champ, expl_custom_origine, expl_custom_small_text, expl_custom_text, expl_custom_integer, expl_custom_date, expl_custom_float) VALUES (3,98,'ACH',NULL,NULL,NULL,NULL);

--
-- Table structure for table `explnum`
--

CREATE TABLE explnum (
  explnum_id int(11) unsigned NOT NULL AUTO_INCREMENT,
  explnum_notice mediumint(8) unsigned NOT NULL DEFAULT '0',
  explnum_bulletin int(8) unsigned NOT NULL DEFAULT '0',
  explnum_nom varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  explnum_mimetype varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  explnum_url mediumtext COLLATE utf8_unicode_ci NOT NULL,
  explnum_data mediumblob,
  explnum_vignette mediumblob,
  explnum_extfichier varchar(20) COLLATE utf8_unicode_ci DEFAULT '',
  explnum_nomfichier mediumtext COLLATE utf8_unicode_ci,
  explnum_statut int(5) unsigned NOT NULL DEFAULT '0',
  explnum_index_sew longtext COLLATE utf8_unicode_ci NOT NULL,
  explnum_index_wew longtext COLLATE utf8_unicode_ci NOT NULL,
  explnum_repertoire int(8) NOT NULL DEFAULT '0',
  explnum_path mediumtext COLLATE utf8_unicode_ci NOT NULL,
  explnum_docnum_statut smallint(5) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (explnum_id),
  KEY explnum_notice (explnum_notice),
  KEY explnum_bulletin (explnum_bulletin),
  KEY explnum_repertoire (explnum_repertoire),
  KEY i_explnum_nomfichier (explnum_nomfichier(30)),
  FULLTEXT KEY i_f_explnumwew (explnum_index_wew)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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 (4,125,0,'Lire l\'article en ligne','URL','http://bbf.enssib.fr/consulter/bbf-2010-06-0041-010','','','','',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,126,0,'Lire l\'article en ligne','URL','http://bbf.enssib.fr/consulter/bbf-2010-06-0020-004','','','','',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 (15,127,0,'Lire l\'article en ligne','URL','http://bbf.enssib.fr/consulter/bbf-2012-05-0056-011','','','','',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,135,0,'Ebook format E-pub','application/epub+zip','',0x[encoded data, 287794 characters]