-- +-------------------------------------------------+
-- © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
-- +-------------------------------------------------+
-- $Id: bibli.sql,v 1.72 2014-03-17 10:32:29 abacarisse Exp $

--
-- Host: localhost    Database: pmb410
-- ------------------------------------------------------




--
-- Base de datos: `pmb4.1 v5.14`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `abo_liste_lecture`
--

CREATE TABLE IF NOT EXISTS `abo_liste_lecture` (
  `num_empr` int(8) unsigned NOT NULL DEFAULT '0',
  `num_liste` int(8) unsigned NOT NULL DEFAULT '0',
  `etat` int(1) unsigned NOT NULL DEFAULT '0',
  `commentaire` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`num_empr`,`num_liste`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `abo_liste_lecture`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `abts_abts`
--

CREATE TABLE IF NOT EXISTS `abts_abts` (
  `abt_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `abt_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `base_modele_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `base_modele_id` int(11) NOT NULL DEFAULT '0',
  `num_notice` int(11) NOT NULL DEFAULT '0',
  `date_debut` date NOT NULL DEFAULT '0000-00-00',
  `date_fin` date NOT NULL DEFAULT '0000-00-00',
  `fournisseur` int(11) NOT NULL DEFAULT '0',
  `destinataire` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cote` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `typdoc_id` int(11) NOT NULL DEFAULT '0',
  `exemp_auto` int(11) NOT NULL DEFAULT '0',
  `location_id` int(11) NOT NULL DEFAULT '0',
  `section_id` int(11) NOT NULL DEFAULT '0',
  `lender_id` int(11) NOT NULL DEFAULT '0',
  `statut_id` int(11) NOT NULL DEFAULT '0',
  `codestat_id` int(11) NOT NULL DEFAULT '0',
  `type_antivol` int(11) NOT NULL DEFAULT '0',
  `duree_abonnement` int(11) NOT NULL DEFAULT '0',
  `abt_numeric` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`abt_id`),
  KEY `index_num_notice` (`num_notice`),
  KEY `i_date_fin` (`date_fin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `abts_abts`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `abts_abts_modeles`
--

CREATE TABLE IF NOT EXISTS `abts_abts_modeles` (
 `modele_id` int(11) NOT NULL DEFAULT '0',
  `abt_id` int(11) NOT NULL DEFAULT '0',
  `num` int(11) NOT NULL DEFAULT '0',
  `vol` int(11) NOT NULL DEFAULT '0',
  `tome` int(11) NOT NULL DEFAULT '0',
  `delais` int(11) NOT NULL DEFAULT '0',
  `critique` int(11) NOT NULL DEFAULT '0',
  `num_statut_general` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`modele_id`,`abt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Volcar la base de datos para la tabla `abts_abts_modeles`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `abts_grille_abt`
--

CREATE TABLE IF NOT EXISTS `abts_grille_abt` (
  `id_bull` int(11) NOT NULL AUTO_INCREMENT,
  `num_abt` int(10) unsigned NOT NULL DEFAULT '0',
  `date_parution` date NOT NULL DEFAULT '0000-00-00',
  `modele_id` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `nombre` int(11) NOT NULL DEFAULT '0',
  `numero` int(11) NOT NULL DEFAULT '0',
  `ordre` int(11) NOT NULL DEFAULT '0',
  `state` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_bull`),
  KEY `num_abt` (`num_abt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `abts_grille_abt`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `abts_grille_modele`
--

CREATE TABLE IF NOT EXISTS `abts_grille_modele` (
   `num_modele` int(10) unsigned NOT NULL DEFAULT '0',
  `date_parution` date NOT NULL DEFAULT '0000-00-00',
  `type_serie` int(11) NOT NULL DEFAULT '0',
  `numero` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `nombre_recu` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`num_modele`,`date_parution`,`type_serie`),
  KEY `num_modele` (`num_modele`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `abts_grille_modele`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `abts_modeles`
--

CREATE TABLE IF NOT EXISTS `abts_modeles` (
  `modele_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `modele_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `num_notice` int(10) unsigned NOT NULL DEFAULT '0',
  `num_periodicite` int(10) unsigned NOT NULL DEFAULT '0',
  `duree_abonnement` int(11) NOT NULL DEFAULT '0',
  `date_debut` date DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  `days` varchar(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1111111',
  `day_month` varchar(31) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1111111111111111111111111111111',
  `week_month` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '111111',
  `week_year` varchar(54) COLLATE utf8_unicode_ci NOT NULL DEFAULT '111111111111111111111111111111111111111111111111111111',
  `month_year` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '111111111111',
  `num_cycle` int(11) NOT NULL DEFAULT '0',
  `num_combien` int(11) NOT NULL DEFAULT '0',
  `num_increment` int(11) NOT NULL DEFAULT '0',
  `num_date_unite` int(11) NOT NULL DEFAULT '0',
  `num_increment_date` int(11) NOT NULL DEFAULT '0',
  `num_depart` int(11) NOT NULL DEFAULT '0',
  `vol_actif` int(11) NOT NULL DEFAULT '0',
  `vol_increment` int(11) NOT NULL DEFAULT '0',
  `vol_date_unite` int(11) NOT NULL DEFAULT '0',
  `vol_increment_numero` int(11) NOT NULL DEFAULT '0',
  `vol_increment_date` int(11) NOT NULL DEFAULT '0',
  `vol_cycle` int(11) NOT NULL DEFAULT '0',
  `vol_combien` int(11) NOT NULL DEFAULT '0',
  `vol_depart` int(11) NOT NULL DEFAULT '0',
  `tom_actif` int(11) NOT NULL DEFAULT '0',
  `tom_increment` int(11) NOT NULL DEFAULT '0',
  `tom_date_unite` int(11) NOT NULL DEFAULT '0',
  `tom_increment_numero` int(11) NOT NULL DEFAULT '0',
  `tom_increment_date` int(11) NOT NULL DEFAULT '0',
  `tom_cycle` int(11) NOT NULL DEFAULT '0',
  `tom_combien` int(11) NOT NULL DEFAULT '0',
  `tom_depart` int(11) NOT NULL DEFAULT '0',
  `format_aff` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `format_periode` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`modele_id`),
  KEY `num_notice` (`num_notice`),
  KEY `num_periodicite` (`num_periodicite`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `abts_modeles`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `abts_periodicites`
--

CREATE TABLE IF NOT EXISTS `abts_periodicites` (
  `periodicite_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `duree` int(11) NOT NULL DEFAULT '0',
  `unite` int(11) NOT NULL DEFAULT '0',
  `retard_periodicite` int(4) DEFAULT '0',
  `seuil_periodicite` int(4) DEFAULT '0',
  `consultation_duration` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`periodicite_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Volcar la base de datos para la tabla `abts_periodicites`
--

INSERT INTO `abts_periodicites` (`periodicite_id`, `libelle`, `duree`, `unite`, `retard_periodicite`, `seuil_periodicite`, `consultation_duration`) VALUES
(5, 'Bimestriel', 2, 1, 30, 10, 0),
(4, 'Mensuel', 1, 1, 15, 5, 0),
(3, 'Bimensuel', 14, 0, 10, 5, 0),
(2, 'Hebdomadaire', 7, 0, 4, 2, 0),
(1, 'Quotidien', 1, 0, 2, 1, 0),
(6, 'Trimestriel', 3, 1, 30, 10, 0),
(7, 'Quadrimestriel', 4, 1, 30, 10, 0),
(8, 'Semestriel', 6, 1, 30, 10, 0),
(9, 'Annuel', 1, 2, 30, 10, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `acces_profiles`
--

CREATE TABLE IF NOT EXISTS `acces_profiles` (
   `prf_id` int(2) unsigned NOT NULL AUTO_INCREMENT,
  `prf_type` int(1) unsigned NOT NULL DEFAULT '1',
  `prf_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `prf_rule` blob NOT NULL,
  `prf_hrule` text COLLATE utf8_unicode_ci NOT NULL,
  `prf_used` int(2) unsigned NOT NULL DEFAULT '0',
  `dom_num` int(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`prf_id`),
  KEY `prf_type` (`prf_type`),
  KEY `prf_name` (`prf_name`),
  KEY `dom_num` (`dom_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `acces_profiles`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `acces_rights`
--

CREATE TABLE IF NOT EXISTS `acces_rights` (
  `dom_num` int(2) unsigned NOT NULL DEFAULT '0',
  `usr_prf_num` int(2) unsigned NOT NULL DEFAULT '0',
  `res_prf_num` int(2) unsigned NOT NULL DEFAULT '0',
  `dom_rights` int(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`dom_num`,`usr_prf_num`,`res_prf_num`),
  KEY `dom_num` (`dom_num`),
  KEY `usr_prf_num` (`usr_prf_num`),
  KEY `res_prf_num` (`res_prf_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `acces_rights`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `actes`
--

CREATE TABLE IF NOT EXISTS `actes` (
  `id_acte` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `date_acte` date NOT NULL DEFAULT '0000-00-00',
  `numero` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type_acte` int(3) unsigned NOT NULL DEFAULT '0',
  `statut` int(3) unsigned NOT NULL DEFAULT '0',
  `date_paiement` date NOT NULL DEFAULT '0000-00-00',
  `num_paiement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `num_entite` int(5) unsigned NOT NULL DEFAULT '0',
  `num_fournisseur` int(5) unsigned NOT NULL DEFAULT '0',
  `num_contact_livr` int(8) unsigned NOT NULL DEFAULT '0',
  `num_contact_fact` int(8) unsigned NOT NULL DEFAULT '0',
  `num_exercice` int(8) unsigned NOT NULL DEFAULT '0',
  `commentaires` text COLLATE utf8_unicode_ci NOT NULL,
  `reference` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `index_acte` text COLLATE utf8_unicode_ci NOT NULL,
  `devise` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `commentaires_i` text COLLATE utf8_unicode_ci NOT NULL,
  `date_valid` date NOT NULL DEFAULT '0000-00-00',
  `date_ech` date NOT NULL DEFAULT '0000-00-00',
  `nom_acte` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_acte`),
  KEY `num_fournisseur` (`num_fournisseur`),
  KEY `date` (`date_acte`),
  KEY `num_entite` (`num_entite`),
  KEY `numero` (`numero`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `actes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `admin_session`
--

CREATE TABLE IF NOT EXISTS `admin_session` (
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `session` blob,
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `admin_session`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `analysis`
--

CREATE TABLE IF NOT EXISTS `analysis` (
  `analysis_bulletin` int(8) unsigned NOT NULL DEFAULT '0',
  `analysis_notice` int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`analysis_bulletin`,`analysis_notice`),
  KEY `analysis_notice` (`analysis_notice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `analysis`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `arch_emplacement`
--

CREATE TABLE IF NOT EXISTS `arch_emplacement` (
  `archempla_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `archempla_libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`archempla_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Volcar la base de datos para la tabla `arch_emplacement`
--

INSERT INTO `arch_emplacement` (`archempla_id`, `archempla_libelle`) VALUES
(1, 'Présentoir');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `arch_statut`
--

CREATE TABLE IF NOT EXISTS `arch_statut` (
   `archstatut_id` int(8) NOT NULL AUTO_INCREMENT,
  `archstatut_gestion_libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `archstatut_opac_libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `archstatut_visible_opac` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `archstatut_visible_opac_abon` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `archstatut_visible_gestion` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `archstatut_class_html` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`archstatut_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Volcar la base de datos para la tabla `arch_statut`
--

INSERT INTO `arch_statut` (`archstatut_id`, `archstatut_gestion_libelle`, `archstatut_opac_libelle`, `archstatut_visible_opac`, `archstatut_visible_opac_abon`, `archstatut_visible_gestion`, `archstatut_class_html`) VALUES
(1, 'Consultable sur place', 'Consultable sur place', 1, 0, 1, 'statutnot2');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `arch_type`
--

CREATE TABLE IF NOT EXISTS `arch_type` (
 `archtype_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `archtype_libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`archtype_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Volcar la base de datos para la tabla `arch_type`
--

INSERT INTO `arch_type` (`archtype_id`, `archtype_libelle`) VALUES
(1, 'Revue');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `audit`
--

CREATE TABLE IF NOT EXISTS `audit` (
  `type_obj` int(1) NOT NULL DEFAULT '0',
  `object_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(8) unsigned NOT NULL DEFAULT '0',
  `user_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type_modif` int(1) NOT NULL DEFAULT '1',
  `quand` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `info` text COLLATE utf8_unicode_ci NOT NULL,
  KEY `type_obj` (`type_obj`),
  KEY `object_id` (`object_id`),
  KEY `user_id` (`user_id`),
  KEY `type_modif` (`type_modif`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `audit`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `aut_link`
--

CREATE TABLE IF NOT EXISTS `aut_link` (
  `aut_link_from` int(2) NOT NULL DEFAULT '0',
  `aut_link_from_num` int(11) NOT NULL DEFAULT '0',
  `aut_link_to` int(2) NOT NULL DEFAULT '0',
  `aut_link_to_num` int(11) NOT NULL DEFAULT '0',
  `aut_link_type` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `aut_link_reciproc` int(1) NOT NULL DEFAULT '0',
  `aut_link_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`aut_link_from`,`aut_link_from_num`,`aut_link_to`,`aut_link_to_num`,`aut_link_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `aut_link`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `author_custom`
--

CREATE TABLE `author_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_type` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `titre` varchar(255) DEFAULT NULL,
  `type` varchar(10) NOT NULL DEFAULT 'text',
  `datatype` varchar(10) NOT NULL DEFAULT '',
  `options` text,
  `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=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcar la base de datos para la tabla `aut_link`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `author_custom_lists`
--

CREATE TABLE `author_custom_lists` (
  `author_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `author_custom_list_value` varchar(255) DEFAULT NULL,
  `author_custom_list_lib` varchar(255) DEFAULT NULL,
  `ordre` int(11) DEFAULT NULL,
  KEY `editorial_custom_champ` (`author_custom_champ`),
  KEY `editorial_champ_list_value` (`author_custom_champ`,`author_custom_list_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcar la base de datos para la tabla `author_custom_lists`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `author_custom_values`
--

CREATE TABLE `author_custom_values` (
  `author_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `author_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `author_custom_small_text` varchar(255) DEFAULT NULL,
  `author_custom_text` text,
  `author_custom_integer` int(11) DEFAULT NULL,
  `author_custom_date` date DEFAULT NULL,
  `author_custom_float` float DEFAULT NULL,
  KEY `editorial_custom_champ` (`author_custom_champ`),
  KEY `editorial_custom_origine` (`author_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `author_custom_values`
--


-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `authorities_sources`
--

CREATE TABLE IF NOT EXISTS `authorities_sources` (
 `id_authority_source` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_authority` int(10) unsigned NOT NULL DEFAULT '0',
  `authority_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `authority_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `num_origin_authority` int(10) unsigned NOT NULL DEFAULT '0',
  `authority_favorite` int(10) unsigned NOT NULL DEFAULT '0',
  `import_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `update_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id_authority_source`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `authorities_sources`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `authors`
--

CREATE TABLE IF NOT EXISTS `authors` (
   `author_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `author_type` enum('70','71','72') COLLATE utf8_unicode_ci NOT NULL DEFAULT '70',
  `author_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author_rejete` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author_see` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `author_web` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `index_author` text COLLATE utf8_unicode_ci,
  `author_comment` text COLLATE utf8_unicode_ci,
  `author_lieu` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author_ville` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author_pays` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author_subdivision` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author_numero` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author_import_denied` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`author_id`),
  KEY `author_see` (`author_see`),
  KEY `author_name` (`author_name`),
  KEY `author_rejete` (`author_rejete`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `authors`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `avis`
--

CREATE TABLE IF NOT EXISTS `avis` (
  `id_avis` mediumint(8) NOT NULL AUTO_INCREMENT,
  `num_empr` mediumint(8) NOT NULL DEFAULT '0',
  `num_notice` mediumint(8) NOT NULL DEFAULT '0',
  `note` int(3) DEFAULT NULL,
  `sujet` text COLLATE utf8_unicode_ci,
  `commentaire` text COLLATE utf8_unicode_ci,
  `dateajout` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `valide` int(1) unsigned NOT NULL DEFAULT '0',
  `avis_rank` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_avis`),
  KEY `avis_num_notice` (`num_notice`),
  KEY `avis_num_empr` (`num_empr`),
  KEY `avis_note` (`note`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `avis`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `bannette_abon`
--

CREATE TABLE IF NOT EXISTS `bannette_abon` (
 `num_bannette` int(9) unsigned NOT NULL DEFAULT '0',
  `num_empr` int(9) unsigned NOT NULL DEFAULT '0',
  `actif` int(1) unsigned NOT NULL DEFAULT '0',
  `bannette_mail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`num_bannette`,`num_empr`),
  KEY `i_num_empr` (`num_empr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `bannette_abon`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `bannette_contenu`
--

CREATE TABLE IF NOT EXISTS `bannette_contenu` (
 `num_bannette` int(9) unsigned NOT NULL DEFAULT '0',
  `num_notice` int(9) unsigned NOT NULL DEFAULT '0',
  `date_ajout` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`num_bannette`,`num_notice`),
  KEY `date_ajout` (`date_ajout`),
  KEY `i_num_notice` (`num_notice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `bannette_contenu`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `bannette_equation`
--

CREATE TABLE IF NOT EXISTS `bannette_equation` (
 `num_bannette` int(9) unsigned NOT NULL DEFAULT '0',
  `num_equation` int(9) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_bannette`,`num_equation`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `bannette_equation`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `bannette_exports`
--

CREATE TABLE IF NOT EXISTS `bannette_exports` (
 `num_bannette` int(11) unsigned NOT NULL DEFAULT '0',
  `export_format` int(3) NOT NULL DEFAULT '0',
  `export_data` longblob NOT NULL,
  `export_nomfichier` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  PRIMARY KEY (`num_bannette`,`export_format`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `bannette_exports`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla`bannette_facettes`
--


CREATE TABLE `bannette_facettes` (
  `num_ban_facette` int(10) unsigned NOT NULL DEFAULT '0',
  `ban_facette_critere` int(5) NOT NULL DEFAULT '0',
  `ban_facette_ss_critere` int(5) NOT NULL DEFAULT '0',
  `ban_facette_order` int(1) NOT NULL DEFAULT '0',
  KEY `bannette_facettes_key` (`num_ban_facette`,`ban_facette_critere`,`ban_facette_ss_critere`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `bannette_facettes`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `bannettes`
--

CREATE TABLE IF NOT EXISTS `bannettes` (
 `id_bannette` int(9) unsigned NOT NULL AUTO_INCREMENT,
  `num_classement` int(8) unsigned NOT NULL DEFAULT '1',
  `nom_bannette` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment_gestion` text COLLATE utf8_unicode_ci NOT NULL,
  `comment_public` text COLLATE utf8_unicode_ci NOT NULL,
  `entete_mail` text COLLATE utf8_unicode_ci NOT NULL,
  `date_last_remplissage` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_last_envoi` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `proprio_bannette` int(9) unsigned NOT NULL DEFAULT '0',
  `bannette_auto` int(1) unsigned NOT NULL DEFAULT '0',
  `periodicite` int(3) unsigned NOT NULL DEFAULT '7',
  `diffusion_email` int(1) unsigned NOT NULL DEFAULT '0',
  `categorie_lecteurs` int(8) unsigned NOT NULL DEFAULT '0',
  `nb_notices_diff` int(4) unsigned NOT NULL DEFAULT '0',
  `num_panier` int(8) unsigned NOT NULL DEFAULT '0',
  `limite_type` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `limite_nombre` int(6) NOT NULL DEFAULT '0',
  `update_type` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'C',
  `typeexport` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `prefixe_fichier` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `param_export` blob NOT NULL,
  `piedpage_mail` text COLLATE utf8_unicode_ci NOT NULL,
  `notice_tpl` int(10) unsigned NOT NULL DEFAULT '0',
  `group_type` int(10) unsigned NOT NULL DEFAULT '0',
  `group_pperso` int(10) unsigned NOT NULL DEFAULT '0',
  `statut_not_account` int(1) unsigned NOT NULL DEFAULT '0',
  `archive_number` int(10) unsigned NOT NULL DEFAULT '0',
  `document_generate` int(10) unsigned NOT NULL DEFAULT '0',
  `document_notice_tpl` int(10) unsigned NOT NULL DEFAULT '0',
  `document_insert_docnum` int(10) unsigned NOT NULL DEFAULT '0',
  `document_group` int(10) unsigned NOT NULL DEFAULT '0',
  `document_add_summary` int(10) unsigned NOT NULL DEFAULT '0',
  `groupe_lecteurs` int(8) unsigned NOT NULL DEFAULT '0',
  `bannette_opac_accueil` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_bannette`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `bannettes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla`bannettes_descriptors`
--


CREATE TABLE `bannettes_descriptors` (
  `num_bannette` int(11) NOT NULL DEFAULT '0',
  `num_noeud` int(11) NOT NULL DEFAULT '0',
  `bannette_descriptor_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_bannette`,`num_noeud`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `bannettes_descriptors`
--

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `budgets`
--

CREATE TABLE IF NOT EXISTS `budgets` (
 `id_budget` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `num_entite` int(5) unsigned NOT NULL DEFAULT '0',
  `num_exercice` int(8) unsigned NOT NULL DEFAULT '0',
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `commentaires` text COLLATE utf8_unicode_ci,
  `montant_global` float(8,2) unsigned NOT NULL DEFAULT '0.00',
  `seuil_alerte` int(3) unsigned NOT NULL DEFAULT '100',
  `statut` int(3) unsigned NOT NULL DEFAULT '0',
  `type_budget` int(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_budget`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `budgets`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `bulletins`
--

CREATE TABLE IF NOT EXISTS `bulletins` (
  `bulletin_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `bulletin_numero` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bulletin_notice` int(8) NOT NULL DEFAULT '0',
  `mention_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `date_date` date NOT NULL DEFAULT '0000-00-00',
  `bulletin_titre` text COLLATE utf8_unicode_ci,
  `index_titre` text COLLATE utf8_unicode_ci,
  `bulletin_cb` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `num_notice` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`bulletin_id`),
  KEY `bulletin_numero` (`bulletin_numero`),
  KEY `bulletin_notice` (`bulletin_notice`),
  KEY `date_date` (`date_date`),
  KEY `i_num_notice` (`num_notice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `bulletins`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cache_amendes`
--

CREATE TABLE IF NOT EXISTS `cache_amendes` (
  `id_empr` int(10) unsigned NOT NULL DEFAULT '0',
  `cache_date` date NOT NULL DEFAULT '0000-00-00',
  `data_amendes` blob NOT NULL,
  KEY `id_empr` (`id_empr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `cache_amendes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `caddie`
--

CREATE TABLE IF NOT EXISTS `caddie` (
  `idcaddie` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NOTI',
  `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `autorisations` mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`idcaddie`),
  KEY `caddie_type` (`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

--
-- Volcar la base de datos para la tabla `caddie`
--

INSERT INTO `caddie` (`idcaddie`, `name`, `type`, `comment`, `autorisations`) VALUES
(1, 'Registros para exposición', 'NOTI', 'Incluir en esta cesta los registros de la exposición virtual', '1 2'),
(2, 'Registros a devolver a BDP', 'NOTI', 'Llenar esta cesta como control de los registros que se han de devolver', '1 2'),
(3, 'Ejemplares a devolver a BDP', 'EXPL', 'Llenar esta cesta con los ejemplares de los documentos a devolver a la BDP', '1 2'),
(4, 'Registros con el título duplicado', 'NOTI', 'Duplicados del primer título', '1 2'),
(8, 'Ejemplo de cesta de ejemplares', 'EXPL', '', '1 4 3 2'),
(5, 'Loire - Registros para el tema del mes', 'NOTI', '', '1 4'),
(6, 'Loire - Números que contienen los artículos para la exposición del mes', 'BULL', '', '1 4'),
(7, 'Cochon - registros para la exposición del mes próximo', 'NOTI', '', '1');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `caddie_content`
--

CREATE TABLE IF NOT EXISTS `caddie_content` (
  `caddie_id` int(8) unsigned NOT NULL DEFAULT '0',
  `object_id` int(10) unsigned NOT NULL DEFAULT '0',
  `content` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `blob_type` varchar(100) COLLATE utf8_unicode_ci DEFAULT '',
  `flag` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`caddie_id`,`object_id`,`content`),
  KEY `object_id` (`object_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `caddie_content`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `caddie_procs`
--

CREATE TABLE IF NOT EXISTS `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` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `autorisations` mediumtext COLLATE utf8_unicode_ci,
  `parameters` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`idproc`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=40 ;

--
-- Volcar la base de datos para la tabla `caddie_procs`
--

INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES
(1, 'SELECT', 'Registros por autor', 0x53454c454354206e6f746963655f6964206173206f626a6563745f69642c20274e4f544927206173206f626a6563745f747970652046524f4d206e6f74696365732c20617574686f72732c20726573706f6e736162696c69747920574845524520617574686f725f6e616d65206c696b652027252121637269746572652121252720414e4420617574686f725f69643d726573706f6e736162696c6974795f617574686f7220414e44206e6f746963655f69643d726573706f6e736162696c6974795f6e6f746963650d0a, 'Selección de registros dónde el nombre del autor contiene ciertas letras', '1 2 3', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="critere" MANDATORY="yes">\n  <ALIAS><![CDATA[Caracteres incluidos en el apellido]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>25</SIZE>\r\n <MAXSIZE>25</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(2, 'SELECT', 'Registros duplicados', 0x6372656174652054454d504f52415259205441424c4520746d702053454c45435420746974312046524f4d206e6f74696365732047524f5550204259207469743120484156494e4720636f756e74282a293e310d0a53454c454354206e6f746963655f6964206173206f626a6563745f69642c20274e4f544927206173206f626a6563745f747970652046524f4d206e6f74696365732c20746d70207748455245206e6f74696365732e746974313d746d702e74697431, 'Selección de los registros duplicados por el título principal', '1 2 3', NULL),
(3, 'SELECT', 'EXPL por sección / propietario', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d206578656d706c6169726573207768657265206578706c5f73656374696f6e20696e2028212173656374696f6e21212920616e64206578706c5f6f776e65723d212170726f7072696f2121, 'Selección de ejemplares por sección y por propietario', '1 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="section" MANDATORY="yes">\n  <ALIAS><![CDATA[Sección]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idsection, section_libelle from docs_section order by section_libelle]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="proprio" MANDATORY="yes">\n  <ALIAS><![CDATA[Proprietario]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>select idlender, lender_libelle from lenders order by lender_libelle</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(4, 'SELECT', 'EXPL que la signatura comienza por', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d206578656d706c6169726573207768657265206578706c5f636f7465206c696b6520272121636f6d6d655f636f746521212527, 'Selección de ejemplares a partir del inicio de su signatura', '1 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="comme_cote" MANDATORY="no">\n  <ALIAS><![CDATA[Inicio de la signatura]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>20</SIZE>\r\n <MAXSIZE>20</MAXSIZE>\r\n</OPTIONS> \n </FIELD>\n</FIELDS>'),
(6, 'SELECT', 'Nunca prestados', 0x53454c454354206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652c20636f6e63617428224c4956524520222c74697431292061732054697472652046524f4d206e6f7469636573206a6f696e206578656d706c6169726573206f6e206578706c5f6e6f746963653d6e6f746963655f6964204c454654204a4f494e20707265745f61726368697665204f4e206172635f6578706c5f6e6f74696365203d206e6f746963655f6964207768657265206172635f6578706c5f6964204953204e554c4c20414e44206578706c5f6964204953204e4f54204e554c4c20554e494f4e2053454c454354206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652c20636f6e6361742822504552494f20222c746974312c2022204e756de9726f203a20222c62756c6c6574696e5f6e756d65726f292061732054697472652046524f4d202862756c6c6574696e7320494e4e4552204a4f494e206e6f7469636573204f4e2062756c6c6574696e732e62756c6c6574696e5f6e6f74696365203d206e6f74696365732e6e6f746963655f69642920494e4e4552204a4f494e206578656d706c6169726573206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964204c454654204a4f494e20707265745f61726368697665204f4e206578706c5f6964203d206172635f6578706c5f696420574845524520707265745f617263686976652e6172635f6964204973204e756c6c, 'Añade a una cesta los ejemplares que nunca se han prestado', '1 2', NULL),
(7, 'SELECT', 'Selección de ejemplares por estado', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d206578656d706c6169726573207768657265206578706c5f73746174757420696e20282121737461747574212129, '', '1 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="statut" MANDATORY="yes">\n  <ALIAS><![CDATA[estado]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idstatut, statut_libelle from docs_statut]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(8, 'SELECT', 'Selección de ejemplares por localización, sección, estado, propietario', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d206578656d706c6169726573207768657265206578706c5f73656374696f6e20696e2028212173656374696f6e21212920616e64206578706c5f6c6f636174696f6e20696e202821216c6f636174696f6e21212920616e64206578706c5f73746174757420696e2028212173746174757421212920616e64206578706c5f6f776e65723d212170726f7072696f21212020, '', '1 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="section" MANDATORY="yes">\n  <ALIAS><![CDATA[Sección]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idsection, section_libelle from docs_section order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="location" MANDATORY="yes">\n  <ALIAS><![CDATA[Localización]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idlocation, location_libelle from docs_location order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="statut" MANDATORY="yes">\n  <ALIAS><![CDATA[Estado]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idstatut, statut_libelle from docs_statut order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="proprio" MANDATORY="yes">\n  <ALIAS><![CDATA[Proprietario]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idlender, lender_libelle from lenders order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(10, 'ACTION', 'Déplacement des bulletins d''un panier vers un autre périodique', 0x7570646174652062756c6c6574696e73207365742062756c6c6574696e5f6e6f746963653d21216e65775f706572696f21212077686572652062756c6c6574696e5f696420696e20284341444449452842554c4c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_perio" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouveau périodique]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select notice_id, tit1 from notices where niveau_biblio=''s'' and niveau_hierar=''1'' order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(11, 'SELECT', 'Sélection / pointage des bulletins sans articles', 0x73656c6563742064697374696e63742062756c6c6574696e5f6964206173206f626a6563745f69642c2742554c4c27206173206f626a6563745f747970652066726f6d2062756c6c6574696e73206c656674206a6f696e20616e616c79736973206f6e20616e616c797369735f62756c6c6574696e3d62756c6c6574696e5f696420776865726520616e616c797369735f62756c6c6574696e206973206e756c6c, '', ' 1 ', ''),
(13, 'SELECT', 'Sélection / pointage de bulletins par date', 0x73656c6563742062756c6c6574696e5f6964206173206f626a6563745f69642c202742554c4c27206173206f626a6563745f747970652066726f6d2062756c6c6574696e7320776865726520646174655f646174653e272121646174656421212720414e4420646174655f646174653c2721216461746566212127, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="dated" MANDATORY="yes">\n  <ALIAS><![CDATA[date de début :]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR="date_box"></OPTIONS>\n </FIELD>\n <FIELD NAME="datef" MANDATORY="yes">\n  <ALIAS><![CDATA[date de fin :]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR="date_box"></OPTIONS>\n </FIELD>\n</FIELDS>'),
(14, 'ACTION', 'Changement de code statistique des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f636f6465737461743d2721216e65775f636f646573746174212127207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_codestat" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouveau code statistique]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idcode, codestat_libelle from docs_codestat order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(16, 'ACTION', 'Changement de date de dépôt des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f646174655f6465706f743d2721216e65775f646174655f6465706f74212127207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_date_depot" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouvelle date de dépôt]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR="date_box"></OPTIONS> \n </FIELD>\n</FIELDS>'),
(18, 'ACTION', 'Changement de date de retour des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f646174655f7265746f75723d2721216e65775f646174655f7265746f7572212127207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_date_retour" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouvelle date de retour]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR="date_box"></OPTIONS> \n </FIELD>\n</FIELDS>'),
(19, 'ACTION', 'Changement de localisation des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f6c6f636174696f6e3d2721216e65775f6c6f636174696f6e212127207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_location" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouvelle localisation]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idlocation, location_libelle from docs_location order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(20, 'ACTION', 'Changement de message des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f6e6f74653d2721216e65775f6e6f7465212127207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_note" MANDATORY="no">\n  <ALIAS><![CDATA[Nouveau message]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>25</SIZE>\r\n <MAXSIZE>255</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(21, 'ACTION', 'Changement d''une partie de la cote des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f636f74653d7265706c616365286578706c5f636f74652c202721216d6f7469665f312121272c202721216d6f7469665f3221212729207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="motif_1" MANDATORY="no">\n  <ALIAS><![CDATA[Remplacer]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>10</SIZE>\r\n <MAXSIZE>10</MAXSIZE>\r\n</OPTIONS> \n </FIELD>\n <FIELD NAME="motif_2" MANDATORY="no">\n  <ALIAS><![CDATA[Par]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>10</SIZE>\r\n <MAXSIZE>10</MAXSIZE>\r\n</OPTIONS> \n </FIELD>\n</FIELDS>'),
(22, 'ACTION', 'Changement de prix des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f707269783d2721216e65775f70726978212127207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_prix" MANDATORY="no">\n  <ALIAS><![CDATA[Nouveau prix]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>10</SIZE>\r\n <MAXSIZE>255</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(23, 'ACTION', 'Changement de section des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f73656374696f6e3d2721216e65775f73656374696f6e212127207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_section" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouvelle section]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idsection, section_libelle from docs_section order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(24, 'ACTION', 'Changement de statut des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f7374617475743d2721216e65775f737461747574212127207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_statut" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouveau statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idstatut, statut_libelle from docs_statut order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(25, 'ACTION', 'Changement de support des exemplaires d''un panier', 0x757064617465206578656d706c616972657320736574206578706c5f747970646f633d2721216e65775f747970646f63212127207768657265206578706c5f696420696e2028434144444945284558504c2929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_typdoc" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouveau support]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idtyp_doc, tdoc_libelle from docs_type order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(26, 'SELECT', 'Sélection / Pointage des exemplaires en cours de prêt', 0x53454c45435420707265745f69646578706c206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d2070726574, '', ' 1 ', ''),
(27, 'SELECT', 'Sélection d''exemplaires à partir d''un fichier de code-barres', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d206578656d706c6169726573207768657265206578706c5f636220696e2028212166696368696572212129, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="fichier" MANDATORY="yes">\n  <ALIAS><![CDATA[fichier]]></ALIAS>\n  <TYPE>file_box</TYPE>\n<OPTIONS FOR="file_box">\r\n <METHOD>1</METHOD>\r\n <TEMP_TABLE_NAME></TEMP_TABLE_NAME>\r\n <DATA_TYPE>1</DATA_TYPE>\r\n</OPTIONS> \n </FIELD>\n</FIELDS>'),
(30, 'ACTION', 'Changement de l''indexation décimale des notices d''un panier', 0x757064617465206e6f746963657320736574206e6f74696365732e696e646578696e743d2721216e6f7576656c6c655f696e6465786174696f6e21212720207768657265206e6f746963655f696420696e2028434144444945284e4f54492929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="nouvelle_indexation" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouvelle indexation]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select indexint_id, concat(indexint_name,'' '', indexint_comment) from indexint order by indexint_name]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(31, 'ACTION', 'Changement de statut des notices d''un panier', 0x757064617465206e6f746963657320736574207374617475743d2721216e65775f737461747574212127207768657265206e6f746963655f696420696e2028434144444945284e4f54492929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_statut" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouveau statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select id_notice_statut, gestion_libelle from notice_statut order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(32, 'ACTION', 'Changement de type de document des notices d''un panier', 0x757064617465206e6f74696365732073657420747970646f633d21216e65775f747970646f632121207768657265206e6f746963655f696420696e2028434144444945284e4f54492929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_typdoc" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouveau type de document]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR="list">\r\n <MULTIPLE>no</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE="b"><![CDATA[texte manuscrit]]></ITEM>\r\n  <ITEM VALUE="c"><![CDATA[partition musicale imprimée]]></ITEM>\r\n  <ITEM VALUE="d"><![CDATA[partition musicale manuscrite]]></ITEM>\r\n  <ITEM VALUE="e"><![CDATA[document cartographique imprimé]]></ITEM>\r\n  <ITEM VALUE="f"><![CDATA[document cartographique manuscrit]]></ITEM>\r\n  <ITEM VALUE="g"><![CDATA[document projeté ou vidéo]]></ITEM>\r\n  <ITEM VALUE="i"><![CDATA[enregistrement sonore non musical]]></ITEM>\r\n  <ITEM VALUE="j"><![CDATA[enregistrement sonore musical]]></ITEM>\r\n  <ITEM VALUE="k"><![CDATA[document graphique à deux dimensions]]></ITEM>\r\n  <ITEM VALUE="l"><![CDATA[document électronique]]></ITEM>\r\n  <ITEM VALUE="m"><![CDATA[document multimédia]]></ITEM>\r\n  <ITEM VALUE="r"><![CDATA[objet à 3 dimensions, artefacts, ...]]></ITEM>\r\n </ITEMS>\r\n <UNSELECT_ITEM VALUE="a"><![CDATA[texte imprimé]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(33, 'ACTION', 'Copie des auteurs des notices mères d''un panier vers leurs notices filles', 0x494e534552542069676e6f726520494e544f20726573706f6e736162696c6974792028726573706f6e736162696c6974795f617574686f722c20726573706f6e736162696c6974795f6e6f746963652c20726573706f6e736162696c6974795f747970652c20726573706f6e736162696c6974795f666f6e6374696f6e29200d0a53454c454354200d0a72322e726573706f6e736162696c6974795f617574686f722c206e756d5f6e6f746963652c2072322e726573706f6e736162696c6974795f747970652c2072322e726573706f6e736162696c6974795f666f6e6374696f6e200d0a46524f4d206e6f74696365735f72656c6174696f6e73204a4f494e20726573706f6e736162696c697479207232204f4e206c696e6b65645f6e6f74696365203d2072322e726573706f6e736162696c6974795f6e6f74696365207768657265206c696e6b65645f6e6f7469636520494e2028434144444945284e4f54492929, 'Ne rajoute des auteurs qu''aux notices filles qui n''ont pas déjà d''auteurs définis.', ' 1 ', ''),
(34, 'SELECT', 'Sélection / pointage des notices ayant des notices filles', 0x73656c6563742064697374696e6374206c696e6b65645f6e6f74696365206173206f626a6563745f69642c20274e4f544927206173206f626a6563745f747970652066726f6d206e6f74696365735f72656c6174696f6e73, '', ' 1 ', ''),
(35, 'SELECT', 'Sélection / pointage des notices ayant une notice mère', 0x73656c6563742064697374696e6374206e756d5f6e6f74696365206173206f626a6563745f69642c20274e4f544927206173206f626a6563745f747970652066726f6d206e6f74696365735f72656c6174696f6e73, '', ' 1 ', ''),
(36, 'SELECT', 'Sélection / pointage de notices par type de document et statut', 0x53454c4543542044495354494e4354206e6f746963655f6964206173206f626a6563745f69642c20224e4f544922206173206f626a6563745f747970652046524f4d206e6f746963657320776865726520747970646f63203d2121747970655f646f63212120616e6420737461747574203d272121737461747574212127, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="type_doc" MANDATORY="yes">\n  <ALIAS><![CDATA[Type de document]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR="list">\r\n <MULTIPLE>no</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE="a"><![CDATA[texte imprimé]]></ITEM>\r\n  <ITEM VALUE="b"><![CDATA[texte manuscrit]]></ITEM>\r\n  <ITEM VALUE="c"><![CDATA[partition musicale imprimée]]></ITEM>\r\n  <ITEM VALUE="d"><![CDATA[partition musicale manuscrite]]></ITEM>\r\n  <ITEM VALUE="e"><![CDATA[document cartographique imprimé]]></ITEM>\r\n  <ITEM VALUE="f"><![CDATA[document cartographique manuscrit]]></ITEM>\r\n  <ITEM VALUE="g"><![CDATA[document projeté ou vidéo]]></ITEM>\r\n  <ITEM VALUE="i"><![CDATA[enregistrement sonore non musical]]></ITEM>\r\n  <ITEM VALUE="j"><![CDATA[enregistrement sonore musical]]></ITEM>\r\n  <ITEM VALUE="k"><![CDATA[document graphique à deux dimensions]]></ITEM>\r\n  <ITEM VALUE="l"><![CDATA[document électronique]]></ITEM>\r\n  <ITEM VALUE="m"><![CDATA[document multimédia]]></ITEM>\r\n  <ITEM VALUE="r"><![CDATA[objet à 3 dimensions, artefacts, ...]]></ITEM>\r\n </ITEMS>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="statut" MANDATORY="yes">\n  <ALIAS><![CDATA[Statut notice]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>select id_notice_statut, gestion_libelle from notice_statut order by 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(37, 'SELECT', 'Sélection / pointage des notices sans notice-fille ni notice-mère', 0x53454c4543542044495354494e4354206e6f746963655f6964206173206f626a6563745f69642c20224e4f544922206173206f626a6563745f747970652046524f4d20606e6f746963657360206c656674206a6f696e206e6f74696365735f72656c6174696f6e73206e7231206f6e206e72312e6e756d5f6e6f746963653d6e6f746963655f6964206c656674206a6f696e206e6f74696365735f72656c6174696f6e73206e7232206f6e206e72322e6c696e6b65645f6e6f746963653d6e6f746963655f6964207768657265206e72312e6e756d5f6e6f74696365206973206e756c6c20616e64206e72322e6c696e6b65645f6e6f74696365206973206e756c6c, '', ' 1 ', ''),
(39, 'SELECT', 'Sélection des exemplaires non empruntés depuis une certaine date', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c274558504c276173206f626a6563745f747970652046524f4d206578656d706c616972657320776865726520646174655f666f726d6174286c6173745f6c6f616e5f646174652c272559256d25642729203c20646174655f666f726d6174282721216461742121272c272559256d25642729, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="dat" MANDATORY="yes">\n  <ALIAS><![CDATA[Date dernier prêt <]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR="date_box"></OPTIONS>\n </FIELD>\n</FIELDS>'),
(5, 'ACTION', 'Cambio de estado de los ejemplares', 0x757064617465206578656d706c616972657320736574206578706c5f7374617475743d21216e6f75766561755f7374617475742121207768657265206578706c5f696420696e2028434144444945284558504c2929, 'Permite cambiar el estado de los ejemplares de una cesta', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="nouveau_statut" MANDATORY="yes">\n  <ALIAS><![CDATA[nouveau_statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT idstatut, statut_libelle FROM docs_statut</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(9, 'ACTION', 'Cambiar la sección de los ejemplares', 0x757064617465206578656d706c616972657320736574206578706c5f73656374696f6e3d21216e6f7576656c6c655f73656374696f6e2121207768657265206578706c5f696420696e2028434144444945284558504c2929, '', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="nouvelle_section" MANDATORY="yes">\n  <ALIAS><![CDATA[nueva sección]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select * from docs_section order by section_libelle]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[Escoge una sección]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cashdesk`
--

CREATE TABLE `cashdesk` (
  `cashdesk_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cashdesk_name` varchar(255) NOT NULL DEFAULT '',
  `cashdesk_autorisations` varchar(255) NOT NULL DEFAULT '',
  `cashdesk_transactypes` varchar(255) NOT NULL DEFAULT '',
  `cashdesk_cashbox` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cashdesk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `caddie_procs`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cashdesk_locations`
--

CREATE TABLE `cashdesk_locations` (
  `cashdesk_loc_cashdesk_num` int(10) unsigned NOT NULL DEFAULT '0',
  `cashdesk_loc_num` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cashdesk_loc_cashdesk_num`,`cashdesk_loc_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `cashdesk_locations`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cashdesk_sections`
--

CREATE TABLE `cashdesk_sections` (
  `cashdesk_section_cashdesk_num` int(10) unsigned NOT NULL DEFAULT '0',
  `cashdesk_section_num` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cashdesk_section_cashdesk_num`,`cashdesk_section_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `cashdesk_sections`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla  `categ_custom`
--

CREATE TABLE `categ_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_type` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `titre` varchar(255) DEFAULT NULL,
  `type` varchar(10) NOT NULL DEFAULT 'text',
  `datatype` varchar(10) NOT NULL DEFAULT '',
  `options` text,
  `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=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `categ_custom`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla  `categ_custom_lists`
--

CREATE TABLE `categ_custom_lists` (
  `categ_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `categ_custom_list_value` varchar(255) DEFAULT NULL,
  `categ_custom_list_lib` varchar(255) DEFAULT NULL,
  `ordre` int(11) DEFAULT NULL,
  KEY `editorial_custom_champ` (`categ_custom_champ`),
  KEY `editorial_champ_list_value` (`categ_custom_champ`,`categ_custom_list_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `categ_custom_lists`
--

-- --------------------------------------------------------

--
--  Estructura de tabla para la tabla `categ_custom_values`
--

CREATE TABLE `categ_custom_values` (
  `categ_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `categ_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `categ_custom_small_text` varchar(255) DEFAULT NULL,
  `categ_custom_text` text,
  `categ_custom_integer` int(11) DEFAULT NULL,
  `categ_custom_date` date DEFAULT NULL,
  `categ_custom_float` float DEFAULT NULL,
  KEY `editorial_custom_champ` (`categ_custom_champ`),
  KEY `editorial_custom_origine` (`categ_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcar la base de datos para la tabla `categ_custom_values`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
 `num_thesaurus` int(3) unsigned NOT NULL DEFAULT '1',
  `num_noeud` int(9) unsigned NOT NULL DEFAULT '0',
  `langue` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr_FR',
  `libelle_categorie` text COLLATE utf8_unicode_ci NOT NULL,
  `note_application` text COLLATE utf8_unicode_ci NOT NULL,
  `comment_public` text COLLATE utf8_unicode_ci NOT NULL,
  `comment_voir` text COLLATE utf8_unicode_ci NOT NULL,
  `index_categorie` text COLLATE utf8_unicode_ci NOT NULL,
  `path_word_categ` text COLLATE utf8_unicode_ci NOT NULL,
  `index_path_word_categ` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`num_noeud`,`langue`),
  KEY `categ_langue` (`langue`),
  KEY `libelle_categorie` (`libelle_categorie`(5))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `categories`
--

INSERT INTO `categories` (`num_thesaurus`, `num_noeud`, `langue`, `libelle_categorie`, `note_application`, `comment_public`, `comment_voir`, `index_categorie`, `path_word_categ`, `index_path_word_categ`) VALUES
(1, 3, 'fr_FR', '~termes non classés', '', '', '', ' termes non classes ', '', ''),
(1, 2, 'fr_FR', '~termes orphelins', '', '', '', ' termes orphelins ', '', ''),
(1, 2, 'es_ES', '~descripotres no clasificados', '', '', '', ' descriptores no clasificados ', '', ''),
(1, 3, 'es_ES', '~descriptores huérfanos', '', '', '', ' descriptores huérfanos ', '', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `classements`
--

CREATE TABLE IF NOT EXISTS `classements` (
 `id_classement` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `type_classement` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'BAN',
  `nom_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_classement`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Volcar la base de datos para la tabla `classements`
--

INSERT INTO `classements` (`id_classement`, `type_classement`, `nom_classement`) VALUES
(1, '', '_NON CLASSE_'),
(2, 'BAN', 'Nouveautés'),
(3, 'EQU', 'Nouveautés');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms`
--

CREATE TABLE IF NOT EXISTS `cms` (
 `id_cms` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cms_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cms_comment` text COLLATE utf8_unicode_ci NOT NULL,
  `cms_opac_default` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_cms`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_articles`
--

CREATE TABLE IF NOT EXISTS `cms_articles` (
  `id_article` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `article_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `article_resume` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `article_contenu` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `article_logo` mediumblob NOT NULL,
  `article_publication_state` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `article_start_date` datetime DEFAULT NULL,
  `article_end_date` datetime DEFAULT NULL,
  `num_section` int(11) NOT NULL DEFAULT '0',
  `article_num_type` int(10) unsigned NOT NULL DEFAULT '0',
  `article_creation_date` date DEFAULT NULL,
  `article_order` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id_article`),
  KEY `i_cms_article_title` (`article_title`),
  KEY `i_cms_article_publication_state` (`article_publication_state`),
  KEY `i_cms_article_num_parent` (`num_section`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_articles`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_articles_descriptors`
--

CREATE TABLE IF NOT EXISTS `cms_articles_descriptors` (
  `num_article` int(11) NOT NULL DEFAULT '0',
  `num_noeud` int(11) NOT NULL DEFAULT '0',
  `article_descriptor_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_article`,`num_noeud`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `cms_articles_descriptors`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_build`
--

CREATE TABLE IF NOT EXISTS `cms_build` (
  `id_build` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `build_version_num` int(11) NOT NULL DEFAULT '0',
  `build_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'cadre',
  `build_fixed` int(11) NOT NULL DEFAULT '0',
  `build_obj` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `build_page` int(11) NOT NULL DEFAULT '0',
  `build_parent` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `build_child_before` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `build_child_after` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `build_css` text COLLATE utf8_unicode_ci NOT NULL,
  `build_div` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_build`),
  KEY `cms_build_index` (`build_version_num`,`build_obj`),
  KEY `i_build_parent_build_version_num` (`build_parent`,`build_version_num`),
  KEY `i_build_obj_build_version_num` (`build_obj`,`build_version_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_build`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_cache_cadres`
--

CREATE TABLE `cms_cache_cadres` (
  `cache_cadre_hash` varchar(32) NOT NULL,
  `cache_cadre_type_content` varchar(30) NOT NULL,
  `cache_cadre_create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cache_cadre_content` mediumtext NOT NULL,
  PRIMARY KEY (`cache_cadre_hash`,`cache_cadre_type_content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcar la base de datos para la tabla `cms_cache_cadres`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_cadre_content`
--

CREATE TABLE IF NOT EXISTS `cms_cadre_content` (
  `id_cadre_content` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cadre_content_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cadre_content_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cadre_content_object` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cadre_content_num_cadre` int(10) unsigned NOT NULL DEFAULT '0',
  `cadre_content_data` text COLLATE utf8_unicode_ci NOT NULL,
  `cadre_content_num_cadre_content` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_cadre_content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_cadre_content`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `cms_cadres`
--

CREATE TABLE IF NOT EXISTS `cms_cadres` (
  `id_cadre` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cadre_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cadre_object` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cadre_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cadre_fixed` int(11) NOT NULL DEFAULT '0',
  `cadre_styles` text COLLATE utf8_unicode_ci NOT NULL,
  `cadre_dom_parent` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cadre_dom_after` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cadre_url` text COLLATE utf8_unicode_ci NOT NULL,
  `cadre_memo_url` int(11) NOT NULL DEFAULT '0',
  `cadre_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cadre_modcache` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'get_post_view',
  PRIMARY KEY (`id_cadre`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_cadres`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `cms_collections`
--

CREATE TABLE `cms_collections` (
  `id_collection` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `collection_title` varchar(255) NOT NULL DEFAULT '',
  `collection_description` text NOT NULL,
  `collection_num_parent` int(11) NOT NULL DEFAULT '0',
  `collection_num_storage` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_collection`),
  KEY `i_cms_collection_title` (`collection_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



--
-- Volcar la base de datos para la tabla `cms_collections`
--


--
-- Estructura de tabla para la tabla `cms_documents`
--

CREATE TABLE `cms_documents` (
  `id_document` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `document_title` varchar(255) NOT NULL DEFAULT '',
  `document_description` text NOT NULL,
  `document_filename` varchar(255) NOT NULL DEFAULT '',
  `document_mimetype` varchar(100) NOT NULL DEFAULT '',
  `document_filesize` int(11) NOT NULL DEFAULT '0',
  `document_vignette` mediumblob NOT NULL,
  `document_url` text NOT NULL,
  `document_path` varchar(255) NOT NULL DEFAULT '',
  `document_create_date` date NOT NULL DEFAULT '0000-00-00',
  `document_num_storage` int(11) NOT NULL DEFAULT '0',
  `document_type_object` varchar(255) NOT NULL DEFAULT '',
  `document_num_object` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_document`),
  KEY `i_cms_document_title` (`document_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `cms_documents`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_documents_links`
--

CREATE TABLE `cms_documents_links` (
  `document_link_type_object` varchar(255) NOT NULL DEFAULT '',
  `document_link_num_object` int(11) NOT NULL DEFAULT '0',
  `document_link_num_document` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`document_link_type_object`,`document_link_num_object`,`document_link_num_document`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcar la base de datos para la tabla `cms_documents_links`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_editorial_custom`
--

CREATE TABLE IF NOT EXISTS `cms_editorial_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_type` int(10) unsigned NOT NULL DEFAULT '0',
  `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`),
  KEY `i_num_type` (`num_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_editorial_custom`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_editorial_custom_lists`
--

CREATE TABLE IF NOT EXISTS `cms_editorial_custom_lists` (
  `cms_editorial_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `cms_editorial_custom_list_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cms_editorial_custom_list_lib` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ordre` int(11) DEFAULT NULL,
  KEY `editorial_custom_champ` (`cms_editorial_custom_champ`),
  KEY `editorial_champ_list_value` (`cms_editorial_custom_champ`,`cms_editorial_custom_list_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `cms_editorial_custom_lists`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_editorial_custom_values`
--

CREATE TABLE IF NOT EXISTS `cms_editorial_custom_values` (
  `cms_editorial_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `cms_editorial_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `cms_editorial_custom_small_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cms_editorial_custom_text` text COLLATE utf8_unicode_ci,
  `cms_editorial_custom_integer` int(11) DEFAULT NULL,
  `cms_editorial_custom_date` date DEFAULT NULL,
  `cms_editorial_custom_float` float DEFAULT NULL,
  KEY `editorial_custom_champ` (`cms_editorial_custom_champ`),
  KEY `editorial_custom_origine` (`cms_editorial_custom_origine`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `cms_editorial_custom_values`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_editorial_fields_global_index`
--

CREATE TABLE IF NOT EXISTS `cms_editorial_fields_global_index` (
  `num_obj` int(10) unsigned NOT NULL DEFAULT '0',
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code_champ` int(3) NOT NULL DEFAULT '0',
  `code_ss_champ` int(3) NOT NULL DEFAULT '0',
  `ordre` int(4) NOT NULL DEFAULT '0',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `pond` int(4) NOT NULL DEFAULT '100',
  `lang` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`num_obj`,`type`,`code_champ`,`code_ss_champ`,`ordre`),
  KEY `i_value` (`value`(300))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `cms_editorial_fields_global_index`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_editorial_publications_states`
--

CREATE TABLE IF NOT EXISTS `cms_editorial_publications_states` (
  `id_publication_state` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `editorial_publication_state_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `editorial_publication_state_opac_show` int(1) NOT NULL DEFAULT '0',
  `editorial_publication_state_auth_opac_show` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_publication_state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_editorial_publications_states`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_editorial_types`
--

CREATE TABLE IF NOT EXISTS `cms_editorial_types` (
 `id_editorial_type` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `editorial_type_element` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `editorial_type_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `editorial_type_comment` text COLLATE utf8_unicode_ci NOT NULL,
  `editorial_type_extension` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_editorial_type`),
  KEY `i_editorial_type_element` (`editorial_type_element`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Volcar la base de datos para la tabla `cms_editorial_types`
--

INSERT INTO `cms_editorial_types` (`id_editorial_type`, `editorial_type_element`, `editorial_type_label`, `editorial_type_comment`, `editorial_type_extension`) VALUES
(1, 'article_generic', 'CP pour Article', '', ''),
(2, 'section_generic', 'CP pour Rubrique', '', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_editorial_words_global_index`
--

CREATE TABLE IF NOT EXISTS `cms_editorial_words_global_index` (
  `num_obj` int(10) unsigned NOT NULL DEFAULT '0',
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code_champ` int(11) NOT NULL DEFAULT '0',
  `code_ss_champ` int(11) NOT NULL DEFAULT '0',
  `num_word` int(11) NOT NULL DEFAULT '0',
  `pond` int(11) NOT NULL DEFAULT '100',
  `position` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`num_obj`,`type`,`code_champ`,`code_ss_champ`,`num_word`,`position`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `cms_editorial_words_global_index`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_hash`
--

CREATE TABLE IF NOT EXISTS `cms_hash` (
 `hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `cms_hash`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_managed_modules`
--

CREATE TABLE IF NOT EXISTS `cms_managed_modules` (
  `managed_module_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `managed_module_box` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`managed_module_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `cms_managed_modules`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_modules_extensions_datas`
--

CREATE TABLE IF NOT EXISTS `cms_modules_extensions_datas` (
 `id_extension_datas` int(10) NOT NULL AUTO_INCREMENT,
  `extension_datas_module` varchar(255) NOT NULL DEFAULT '',
  `extension_datas_type` varchar(255) NOT NULL DEFAULT '',
  `extension_datas_type_element` varchar(255) NOT NULL DEFAULT '',
  `extension_datas_num_element` int(10) NOT NULL DEFAULT '0',
  `extension_datas_datas` blob,
  PRIMARY KEY (`id_extension_datas`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_modules_extensions_datas`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_pages`
--

CREATE TABLE IF NOT EXISTS `cms_pages` (
 `id_page` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `page_hash` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `page_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `page_description` text COLLATE utf8_unicode_ci NOT NULL,
  `page_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_page`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_pages`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_pages_env`
--

CREATE TABLE IF NOT EXISTS `cms_pages_env` (
 `page_env_num_page` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `page_env_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `page_env_id_selector` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`page_env_num_page`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_pages_env`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_sections`
--

CREATE TABLE IF NOT EXISTS `cms_sections` (
   `id_section` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `section_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `section_resume` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `section_logo` mediumblob NOT NULL,
  `section_publication_state` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `section_start_date` datetime DEFAULT NULL,
  `section_end_date` datetime DEFAULT NULL,
  `section_num_parent` int(11) NOT NULL DEFAULT '0',
  `section_num_type` int(10) unsigned NOT NULL DEFAULT '0',
  `section_creation_date` date DEFAULT NULL,
  `section_order` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id_section`),
  KEY `i_cms_section_title` (`section_title`),
  KEY `i_cms_section_publication_state` (`section_publication_state`),
  KEY `i_cms_section_num_parent` (`section_num_parent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_sections`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_sections_descriptors`
--

CREATE TABLE IF NOT EXISTS `cms_sections_descriptors` (
  `num_section` int(11) NOT NULL DEFAULT '0',
  `num_noeud` int(11) NOT NULL DEFAULT '0',
  `section_descriptor_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_section`,`num_noeud`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `cms_sections_descriptors`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_vars`
--

CREATE TABLE IF NOT EXISTS `cms_vars` (
  `id_var` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `var_num_page` int(10) unsigned NOT NULL DEFAULT '0',
  `var_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `var_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_var`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_vars`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cms_version`
--

CREATE TABLE IF NOT EXISTS `cms_version` (
  `id_version` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `version_cms_num` int(10) unsigned NOT NULL DEFAULT '0',
  `version_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `version_comment` text COLLATE utf8_unicode_ci NOT NULL,
  `version_public` int(10) unsigned NOT NULL DEFAULT '0',
  `version_user` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_version`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `cms_version`
--


-- --------------------------------------------------------

--
--  Estructura de tabla para la tabla `collection_custom`
--

CREATE TABLE `collection_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_type` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `titre` varchar(255) DEFAULT NULL,
  `type` varchar(10) NOT NULL DEFAULT 'text',
  `datatype` varchar(10) NOT NULL DEFAULT '',
  `options` text,
  `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=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcar la base de datos para la tabla `collection_custom`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `collection_custom_lists`
--


CREATE TABLE `collection_custom_lists` (
  `collection_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `collection_custom_list_value` varchar(255) DEFAULT NULL,
  `collection_custom_list_lib` varchar(255) 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=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `collection_custom_lists`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabl `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) DEFAULT NULL,
  `collection_custom_text` text,
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `collection_custom_values`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `collections`
--

CREATE TABLE IF NOT EXISTS `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` text COLLATE utf8_unicode_ci,
  `collection_web` text COLLATE utf8_unicode_ci NOT NULL,
  `collection_comment` text 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `collections`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `collections_state`
--

CREATE TABLE IF NOT EXISTS `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` text 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` text COLLATE utf8_unicode_ci NOT NULL,
  `collstate_note` text 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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `collections_state`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `collstate_custom`
--

CREATE TABLE IF NOT EXISTS `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` text 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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `collstate_custom`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `collstate_custom_lists`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `collstate_custom_lists`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `collstate_custom_values`
--

CREATE TABLE IF NOT EXISTS `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` text 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;

--
-- Volcar la base de datos para la tabla `collstate_custom_values`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `comptes`
--

CREATE TABLE IF NOT EXISTS `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` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_compte`),
  KEY `i_cpt_proprio_id` (`proprio_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `comptes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors`
--

CREATE TABLE IF NOT EXISTS `connectors` (
  `connector_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `parameters` text 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;

--
-- Volcar la base de datos para la tabla `connectors`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_categ`
--

CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `connectors_categ`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_categ_sources`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `connectors_categ_sources`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_out`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `connectors_out`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_out_oai_tokens`
--

CREATE TABLE IF NOT EXISTS `connectors_out_oai_tokens` (
   `connectors_out_oai_token_token` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `connectors_out_oai_token_environnement` text 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;

--
-- Volcar la base de datos para la tabla `connectors_out_oai_tokens`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_out_setcache_values`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `connectors_out_setcache_values`
--

--
-- Estructura de tabla para la tabla `connectors_out_setcaches`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `connectors_out_setcaches`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_out_setcateg_sets`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `connectors_out_setcateg_sets`
--



-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_out_setcategs`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `connectors_out_setcategs`
--


-- --------------------------------------------------------



--
-- Estructura de tabla para la tabla `connectors_out_sets`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `connectors_out_sets`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_out_sources`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `connectors_out_sources`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_out_sources_esgroups`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `connectors_out_sources_esgroups`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `connectors_sources`
--

CREATE TABLE IF NOT EXISTS `connectors_sources` (
 `source_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_connector` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `parameters` mediumtext 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` text COLLATE utf8_unicode_ci NOT NULL,
  `ico_notice` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`source_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `connectors_sources`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `coordonnees`
--

CREATE TABLE IF NOT EXISTS `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(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `commentaires` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_contact`),
  KEY `i_num_entite` (`num_entite`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `coordonnees`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `demandes`
--

CREATE TABLE IF NOT EXISTS `demandes` (
 `id_demande` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_demandeur` mediumint(8) 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` text 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',
  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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `demandes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `demandes_actions`
--

CREATE TABLE IF NOT EXISTS `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` text 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` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `actions_type_user` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `actions_read` int(1) 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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `demandes_actions`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `demandes_notes`
--

CREATE TABLE IF NOT EXISTS `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` text COLLATE utf8_unicode_ci NOT NULL,
  `date_note` date NOT NULL DEFAULT '0000-00-00',
  `num_action` int(10) NOT NULL DEFAULT '0',
  `num_note_parent` int(10) NOT NULL DEFAULT '0',
  `notes_num_user` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `notes_type_user` tinyint(4) 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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `demandes_notes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `demandes_theme`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `demandes_theme`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `demandes_type`
--

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

--
-- Volcar la base de datos para la tabla `demandes_type`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `demandes_users`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `demandes_users`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `docs_codestat`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

--
-- Volcar la base de datos para la tabla `docs_codestat`
--

INSERT INTO `docs_codestat` (`idcode`, `codestat_libelle`, `statisdoc_codage_import`, `statisdoc_owner`) VALUES
(10, 'Indeterminado', 'u', 0),
(11, 'Jóvenes', 'j', 0),
(12, 'Adultos', 'a', 0);

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `docs_location`
--

CREATE TABLE IF NOT EXISTS `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` text 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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Volcar la base de datos para la tabla `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, 'Biblioteca principal', '', 2, 'images/site/bib_princ.jpg', 1, 'Biblioteca test de PMB', 'PMB Services', '24 & 26, place des Halles', '72500', 'CHATEAU DU LOIR', '', 'Francia', '02 43 440 660', 'pmb@sigb.net', 'http://www.sigb.net/', 'logo_default.jpg', '', 9999, 0, 0, '', 0, 0, 0),
(2, 'Reserva', '', 2, '', 0, 'Biblioteca test de PMB', '', '', '', '', '', '', '', 'pmb@sigb.net', 'http://www.sigb.net', 'logo_default.jpg', '', 9999, 0, 0, '', 0, 0, 0),
(7, 'Bibliobús', '', 2, 'images/site/bibliobus.jpg', 1, 'Biblioteca test de PMB', 'rue de la culture', '', '72500', 'Château du loir', '', 'Francia', '02 43 440 660', 'pmb@sigb.net', 'http://www.sigb.net', 'logo_default.jpg', '', 9999, 0, 0, '', 0, 0, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `docs_section`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ;

--
-- Volcar la base de datos para la tabla `docs_section`
--

INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES
(10, 'Documentales', '', 2, 'images/site/documentaire.jpg', 1),
(11, 'Documentales Infantiles', '', 2, 'images/site/documentaire.jpg', 1),
(12, 'Novelas Infantiles', '', 2, 'images/site/enfants.jpg', 1),
(13, 'Novelas Juveniles', '', 2, 'images/site/sec3.jpg', 1),
(16, 'Cómics Adultos', '', 2, 'images/site/sec1.jpg', 1),
(17, 'Cómics Infantiles', '', 2, 'images/site/enfants.jpg', 1),
(18, 'H (Historia local)', '', 2, 'images/site/histoire.jpg', 1),
(19, 'FR (Fondo Regional)', '', 2, 'images/site/sec4.jpg', 1),
(20, 'Cómics Juveniles', '', 2, 'images/site/sec3.jpg', 1),
(21, 'Novelas policíacas', '', 2, 'images/site/sec1.jpg', 1),
(23, 'Novelas letra grande', '', 2, 'images/site/large_vue.jpg', 1),
(24, 'Novelas & Novelas extranjeras', '', 2, 'images/site/sec1.jpg', 1),
(25, 'Documentales Juveniles', '', 2, 'images/site/documentaire.jpg', 1),
(26, 'Cuentos Infantiles', '', 2, 'images/site/enfants.jpg', 1);

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `docs_statut`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

--
-- Volcar la base de datos para la tabla `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, 'Documento en buen estado', '', 1, '', 0, 0, 1, 1),
(2, 'En curso de importación/adquisición', '', 0, '', 0, 1, 1, 0),
(11, 'Deteriorado', '', 0, '', 0, 1, 1, 0),
(12, 'Perdido', '', 0, '', 0, 1, 1, 0),
(13, 'Consulta en sala', '', 0, '', 0, 1, 1, 0),
(14, 'En depósito', '', 0, '', 0, 1, 1, 0);

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `docs_type`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;

--
-- Volcar la base de datos para la tabla `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, 'Libro', 14, 15, 2, '', '0.00', 1),
(12, 'Cinta de vídeo', 14, 15, 2, '', '0.00', 1),
(13, 'CD audio', 14, 15, 2, '', '0.00', 1),
(14, 'DVD', 5, 15, 2, '', '0.00', 1),
(15, 'Obra de arte', 5, 15, 2, '', '0.00', 1),
(16, 'Tarjetas y planos', 31, 15, 2, '', '0.00', 1),
(17, 'Cederrones', 10, 5, 2, '', '0.00', 1),
(18, 'Publicaciones peródicas', 8, 5, 0, '', '0.00', 1);

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `docsloc_section`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `docsloc_section`
--

INSERT INTO `docsloc_section` (`num_section`, `num_location`, `num_pclass`) VALUES
(10, 1, 0),
(10, 7, 0),
(11, 1, 0),
(11, 7, 0),
(12, 1, 0),
(12, 7, 0),
(13, 1, 0),
(13, 7, 0),
(16, 1, 0),
(16, 7, 0),
(17, 1, 0),
(17, 7, 0),
(18, 1, 0),
(18, 7, 0),
(19, 1, 0),
(19, 7, 0),
(20, 1, 0),
(20, 7, 0),
(21, 1, 0),
(21, 7, 0),
(23, 1, 0),
(23, 7, 0),
(24, 1, 0),
(24, 7, 0),
(25, 1, 0),
(25, 7, 0),
(26, 1, 0),
(26, 7, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `dsi_archive`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `dsi_archive`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `editions_states`
--

CREATE TABLE IF NOT EXISTS `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` text COLLATE utf8_unicode_ci NOT NULL,
  `editions_state_fieldslist` text COLLATE utf8_unicode_ci NOT NULL,
  `editions_state_fieldsparams` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_editions_state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `editions_states`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr`
--

CREATE TABLE IF NOT EXISTS `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_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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `empr`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_caddie`
--

CREATE TABLE IF NOT EXISTS `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` mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`idemprcaddie`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Volcar la base de datos para la tabla `empr_caddie`
--

INSERT INTO `empr_caddie` (`idemprcaddie`, `name`, `comment`, `autorisations`) VALUES
(1, 'Panier de lecteurs', '', '1');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_caddie_content`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `empr_caddie_content`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_caddie_procs`
--

CREATE TABLE IF NOT EXISTS `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` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `autorisations` mediumtext COLLATE utf8_unicode_ci,
  `parameters` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`idproc`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=23 ;

--
-- Volcar la base de datos para la tabla `empr_caddie_procs`
--

INSERT INTO `empr_caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES
(1, 'ACTION', 'Changement de localisation des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f6c6f636174696f6e3d2721216e65775f6c6f636174696f6e2121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_location" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouvelle localisation]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idlocation, location_libelle from docs_location order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(2, 'ACTION', 'Changement de catégorie des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f63617465673d2721216e65775f63617465672121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_categ" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouvelle catégorie]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select id_categ_empr, libelle from empr_categ order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(3, 'ACTION', 'Changement de ville des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f76696c6c653d2721216e65775f76696c6c652121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_ville" MANDATORY="no">\n  <ALIAS><![CDATA[Nouvelle Ville]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>25</SIZE>\r\n <MAXSIZE>255</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(4, 'ACTION', 'Changement de code postal des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f63703d2721216e65775f63702121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_cp" MANDATORY="no">\n  <ALIAS><![CDATA[Nouveau code postal]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>10</SIZE>\r\n <MAXSIZE>10</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(5, 'ACTION', 'Changement de pays des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f706179733d2721216e65775f706179732121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_pays" MANDATORY="no">\n  <ALIAS><![CDATA[Nouveau pays]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>25</SIZE>\r\n <MAXSIZE>255</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(6, 'ACTION', 'Changement de statut des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f7374617475743d2721216e6f75766561755f7374617475742121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="nouveau_statut" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouveau statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idstatut, statut_libelle from empr_statut order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(7, 'ACTION', 'Changement de code statistique des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f636f6465737461743d2721216e65775f636f6465737461742121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_codestat" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouveau code statistique]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idcode, libelle from empr_codestat order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(8, 'ACTION', 'Changement de mot de passe des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f70617373776f72643d2721216e65775f70617373776f72642121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_password" MANDATORY="no">\n  <ALIAS><![CDATA[Nouveau mot de passe]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>10</SIZE>\r\n <MAXSIZE>10</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(9, 'ACTION', 'Changement de date de début d''adhésion des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f646174655f6164686573696f6e3d2721216e65775f646174655f6164686573696f6e2121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_date_adhesion" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouvelle date de début d''adhésion]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR="date_box"></OPTIONS> \n </FIELD>\n</FIELDS>'),
(10, 'ACTION', 'Changement de date de fin d''adhésion des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f646174655f65787069726174696f6e3d2721216e65775f646174655f65787069726174696f6e2121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_date_expiration" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouvelle date de fin d''adhésion]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR="date_box"></OPTIONS> \n </FIELD>\n</FIELDS>'),
(11, 'ACTION', 'Changement de sexe des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f736578653d21216e65775f7365786521212077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_sexe" MANDATORY="yes">\n  <ALIAS><![CDATA[Nouveau sexe]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR="list">\r\n <MULTIPLE>no</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE="1"><![CDATA[Masculin]]></ITEM>\r\n  <ITEM VALUE="2"><![CDATA[Féminin]]></ITEM>\r\n  <ITEM VALUE="0"><![CDATA[Indéterminé]]></ITEM>\r\n </ITEMS>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(14, 'ACTION', 'Changement de message des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f6d73673d2721216e65775f6d73672121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_msg" MANDATORY="no">\n  <ALIAS><![CDATA[Nouveau message]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>25</SIZE>\r\n <MAXSIZE>255</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(16, 'SELECT', 'Sélection / pointage des lecteurs sans email', 0x73656c6563742069645f656d7072206173206f626a6563745f69642066726f6d20656d7072207768657265207472696d28656d70725f6d61696c293d2727, '', ' 1 ', NULL),
(18, 'ACTION', 'Abonnement des lecteurs d''un panier à une bannette publique (DSI)', 0x696e7365727420696e746f2062616e6e657474655f61626f6e20286e756d5f62616e6e657474652c206e756d5f656d70722c206163746966292073656c65637420212162616e6e6574746521212c2069645f656d70722c20312066726f6d20656d70722077686572652069645f656d707220696e202843414444494528454d5052292920, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="bannette" MANDATORY="yes">\n  <ALIAS><![CDATA[bannette]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select id_bannette, nom_bannette from bannettes where proprio_bannette=0 order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(19, 'ACTION', 'Désabonnement des lecteurs d''un panier d''une bannette publique (DSI)', 0x64656c6574652066726f6d2062616e6e657474655f61626f6e207768657265206e756d5f62616e6e657474653d212162616e6e65747465212120616e64206e756d5f656d70723d69645f656d707220616e642061637469663d312077686572652069645f656d707220696e202843414444494528454d5052292920, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="bannette" MANDATORY="yes">\n  <ALIAS><![CDATA[bannette]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select id_bannette, nom_bannette from bannettes where proprio_bannette=0 order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(21, 'ACTION', 'Changement de profession des lecteurs d''un panier', 0x75706461746520656d70722073657420656d70725f70726f663d2721216e65775f70726f662121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_prof" MANDATORY="no">\n  <ALIAS><![CDATA[Nouvelle profession]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>25</SIZE>\r\n <MAXSIZE>255</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>'),
(22, 'ACTION', 'Changement de type d''abonnement des lecteurs d''un panier', 0x75706461746520656d70722073657420747970655f6162743d2721216e65775f747970655f6162742121272077686572652069645f656d707220696e202843414444494528454d50522929, '', ' 1 ', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="new_type_abt" MANDATORY="no">\n  <ALIAS><![CDATA[Nouveau type d''abonnement]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select id_type_abt, type_abt_libelle from type_abts order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE="0"><![CDATA[Non défini]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_categ`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Volcar la base de datos para la tabla `empr_categ`
--

INSERT INTO `empr_categ` (`id_categ_empr`, `libelle`, `duree_adhesion`, `tarif_abt`, `age_min`, `age_max`) VALUES
(1, 'Niños', 365, '0.00', 0, 0),
(2, 'Jubilados', 365, '0.00', 0, 0),
(3, 'Empleados', 365, '0.00', 0, 0),
(4, 'Sin empleo', 365, '0.00', 0, 0),
(5, 'Alumnos de secundaria/Estudiantes', 365, '0.00', 0, 0),
(6, 'Colegiales', 365, '0.00', 0, 0),
(7, 'Adultos', 365, '0.00', 0, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_codestat`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Volcar la base de datos para la tabla `empr_codestat`
--

INSERT INTO `empr_codestat` (`idcode`, `libelle`) VALUES
(2, 'Comunidad de Municipios'),
(3, 'Municipio'),
(4, 'Departamento'),
(5, 'Europa'),
(6, 'Fuera de Europa'),
(7, 'Francia');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_custom`
--

CREATE TABLE IF NOT EXISTS `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` 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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `empr_custom`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_custom_lists`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `empr_custom_lists`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_custom_values`
--

CREATE TABLE IF NOT EXISTS `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` text 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;

--
-- Volcar la base de datos para la tabla `empr_custom_values`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_grilles`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `empr_grilles`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_groupe`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `empr_groupe`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empr_statut`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Volcar la base de datos para la tabla `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),
(2, 'Interdit', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `empty_words_calculs`
--

CREATE TABLE IF NOT EXISTS `empty_words_calculs` (
  `id_calcul` int(9) unsigned NOT NULL AUTO_INCREMENT,
  `date_calcul` date NOT NULL DEFAULT '0000-00-00',
  `php_empty_words` text 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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `empty_words_calculs`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `entites`
--

CREATE TABLE IF NOT EXISTS `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` text 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` mediumtext 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` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_entite`),
  KEY `raison_sociale` (`raison_sociale`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `entites`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `entrepots_localisations`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `entrepots_localisations`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `equations`
--

CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `equations`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `error_log`
--

CREATE TABLE IF NOT EXISTS `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` text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `error_log`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_cache`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `es_cache`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_cache_blob`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `es_cache_blob`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_cache_int`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `es_cache_int`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_converted_cache`
--

CREATE TABLE IF NOT EXISTS `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` text 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;

--
-- Volcar la base de datos para la tabla `es_converted_cache`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_esgroup_esusers`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `es_esgroup_esusers`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_esgroups`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `es_esgroups`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_esusers`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `es_esusers`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_methods`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `es_methods`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_methods_users`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `es_methods_users`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_searchcache`
--

CREATE TABLE IF NOT EXISTS `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` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`es_searchcache_searchid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `es_searchcache`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `es_searchsessions`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `es_searchsessions`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `etagere`
--

CREATE TABLE IF NOT EXISTS `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` mediumtext COLLATE utf8_unicode_ci,
  `id_tri` int(11) NOT NULL,
  PRIMARY KEY (`idetagere`),
  KEY `i_id_tri` (`id_tri`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Volcar la base de datos para la tabla `etagere`
--

INSERT INTO `etagere` (`idetagere`, `name`, `comment`, `validite`, `validite_date_deb`, `validite_date_fin`, `visible_accueil`, `autorisations`, `id_tri`) VALUES
(3, 'Loire', 0x4578706f736974696f6e207669727475656c6c6520737572206c61204c6f697265, 1, '0000-00-00', '0000-00-00', 1, '1 4 3 2', 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `etagere_caddie`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `etagere_caddie`
--

INSERT INTO `etagere_caddie` (`etagere_id`, `caddie_id`) VALUES
(3, 5);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `exemplaires`
--

CREATE TABLE IF NOT EXISTS `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` tinytext 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` text 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',
  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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `exemplaires`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `exemplaires_temp`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `exemplaires_temp`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `exercices`
--

CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `exercices`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `expl_custom`
--

CREATE TABLE IF NOT EXISTS `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` 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 AUTO_INCREMENT=5 ;

--
-- Volcar la base de datos para la tabla `expl_custom`
--

INSERT INTO `expl_custom` (`idchamp`, `name`, `titre`, `type`, `datatype`, `options`, `multiple`, `obligatoire`, `ordre`, `search`, `export`, `exclusion_obligatoire`, `pond`, `opac_sort`) VALUES
(2, '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[Saisissez une valeur]]></UNSELECT_ITEM>\r\n <DEFAULT_VALUE></DEFAULT_VALUE>\r\n <CHECKBOX_NB_ON_LINE></CHECKBOX_NB_ON_LINE>\r\n</OPTIONS>', 0, 0, 2, 0, 1, 0, 100, 0),
(3, 'date_acquisition', 'Date d''acquisition', 'date_box', 'date', '<OPTIONS FOR="date_box">\r\n <DEFAULT_TODAY>yes</DEFAULT_TODAY>\r\n</OPTIONS> ', 0, 0, 3, 0, 1, 0, 100, 0),
(4, 'date_pilon', 'Date de pilon', 'date_box', 'date', '<OPTIONS FOR="date_box">\r\n <DEFAULT_TODAY>yes</DEFAULT_TODAY>\r\n</OPTIONS> ', 0, 0, 4, 0, 1, 0, 100, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `expl_custom_lists`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Volcar la base de datos para la tabla `expl_custom_lists`
--

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

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `expl_custom_values`
--

CREATE TABLE IF NOT EXISTS `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` text 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;

--
-- Volcar la base de datos para la tabla `expl_custom_values`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `explnum`
--

CREATE TABLE IF NOT EXISTS `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` text COLLATE utf8_unicode_ci NOT NULL,
  `explnum_data` mediumblob,
  `explnum_vignette` mediumblob,
  `explnum_extfichier` varchar(20) COLLATE utf8_unicode_ci DEFAULT '',
  `explnum_nomfichier` text COLLATE utf8_unicode_ci,
  `explnum_statut` int(5) unsigned NOT NULL DEFAULT '0',
  `explnum_index_sew` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `explnum_index_wew` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `explnum_repertoire` int(8) NOT NULL DEFAULT '0',
  `explnum_path` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`explnum_id`),
  KEY `explnum_notice` (`explnum_notice`),
  KEY `explnum_bulletin` (`explnum_bulletin`),
  KEY `explnum_repertoire` (`explnum_repertoire`),
  FULLTEXT KEY `i_f_explnumwew` (`explnum_index_wew`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `explnum`
--


-- --------------------------------------------------------



--
-- Estructura de tabla para la tabla `explnum_doc`
--

CREATE TABLE IF NOT EXISTS `explnum_doc` (
  `id_explnum_doc` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `explnum_doc_nomfichier` text COLLATE utf8_unicode_ci NOT NULL,
  `explnum_doc_mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `explnum_doc_data` mediumblob NOT NULL,
  `explnum_doc_extfichier` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `explnum_doc_url` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_explnum_doc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `explnum_doc`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `explnum_doc_actions`
--

CREATE TABLE IF NOT EXISTS `explnum_doc_actions` (
 `num_explnum_doc` int(10) NOT NULL DEFAULT '0',
  `num_action` int(10) NOT NULL DEFAULT '0',
  `prive` int(1) NOT NULL DEFAULT '0',
  `rapport` int(1) NOT NULL DEFAULT '0',
  `num_explnum` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_explnum_doc`,`num_action`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `explnum_doc_actions`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `explnum_doc_sugg`
--

CREATE TABLE IF NOT EXISTS `explnum_doc_sugg` (
 `num_explnum_doc` int(10) NOT NULL DEFAULT '0',
  `num_suggestion` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_explnum_doc`,`num_suggestion`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `explnum_doc_sugg`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `explnum_location`
--

CREATE TABLE IF NOT EXISTS `explnum_location` (
 `num_explnum` int(10) NOT NULL DEFAULT '0',
  `num_location` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_explnum`,`num_location`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `explnum_location`
--

-- --------------------------------------------------------

--
--  Estructura de tabla para la tabla `explnum_segments`
--

CREATE TABLE `explnum_segments` (
  `explnum_segment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `explnum_segment_explnum_num` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_segment_speaker_num` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_segment_start` double NOT NULL DEFAULT '0',
  `explnum_segment_duration` double NOT NULL DEFAULT '0',
  `explnum_segment_end` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`explnum_segment_id`),
  KEY `i_ensg_explnum_num` (`explnum_segment_explnum_num`),
  KEY `i_ensg_speaker` (`explnum_segment_speaker_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `explnum_segments`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `explnum_speakers`
--

CREATE TABLE `explnum_speakers` (
  `explnum_speaker_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `explnum_speaker_explnum_num` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_speaker_speaker_num` varchar(10) NOT NULL DEFAULT '',
  `explnum_speaker_gender` varchar(1) DEFAULT '',
  `explnum_speaker_author` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`explnum_speaker_id`),
  KEY `i_ensk_explnum_num` (`explnum_speaker_explnum_num`),
  KEY `i_ensk_author` (`explnum_speaker_author`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `explnum_speakers`
--

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `external_count`
--

CREATE TABLE IF NOT EXISTS `external_count` (
  `rid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `recid` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `source_id` int(11) NOT NULL,
  PRIMARY KEY (`rid`),
  KEY `recid` (`recid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `external_count`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `facettes`
--

CREATE TABLE IF NOT EXISTS `facettes` (
  `id_facette` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `facette_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `facette_critere` int(5) NOT NULL DEFAULT '0',
  `facette_ss_critere` int(5) NOT NULL DEFAULT '0',
  `facette_nb_result` int(2) NOT NULL DEFAULT '0',
  `facette_visible` tinyint(1) NOT NULL DEFAULT '0',
  `facette_type_sort` int(1) NOT NULL DEFAULT '0',
  `facette_order_sort` int(1) NOT NULL DEFAULT '0',
  `facette_order` int(11) NOT NULL DEFAULT '1',
  `facette_limit_plus` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_facette`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- Volcar la base de datos para la tabla `facettes`
--

INSERT INTO `facettes` (`id_facette`, `facette_name`, `facette_critere`, `facette_ss_critere`, `facette_nb_result`, `facette_visible`, `facette_type_sort`, `facette_order_sort`, `facette_order`, `facette_limit_plus`) VALUES
(1, 'Catégories', 25, 1, 50, 1, 0, 1, 1, 0),
(2, 'Localisation', 90, 4, 0, 1, 1, 0, 1, 0),
(3, 'Mot-clé', 17, 1, 50, 1, 0, 1, 1, 0),
(4, 'Section', 90, 3, 0, 1, 1, 0, 1, 0),
(5, 'Type de document', 31, 1, 0, 0, 1, 0, 1, 0),
(6, 'Type de notice', 32, 1, 0, 1, 1, 0, 1, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `fiche`
--

CREATE TABLE IF NOT EXISTS `fiche` (
  `id_fiche` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `infos_global` text COLLATE utf8_unicode_ci NOT NULL,
  `index_infos_global` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_fiche`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `fiche`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `frais`
--

CREATE TABLE IF NOT EXISTS `frais` (
 `id_frais` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `condition_frais` text COLLATE utf8_unicode_ci NOT NULL,
  `montant` float(8,2) unsigned NOT NULL DEFAULT '0.00',
  `num_cp_compta` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `num_tva_achat` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `index_libelle` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id_frais`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `frais`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `gestfic0_custom`
--

CREATE TABLE IF NOT EXISTS `gestfic0_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 AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `gestfic0_custom`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `gestfic0_custom_lists`
--

CREATE TABLE IF NOT EXISTS `gestfic0_custom_lists` (
   `gestfic0_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `gestfic0_custom_list_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gestfic0_custom_list_lib` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ordre` int(11) DEFAULT NULL,
  KEY `gestfic0_custom_champ` (`gestfic0_custom_champ`),
  KEY `gestfic0_champ_list_value` (`gestfic0_custom_champ`,`gestfic0_custom_list_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `gestfic0_custom_lists`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `gestfic0_custom_values`
--

CREATE TABLE IF NOT EXISTS `gestfic0_custom_values` (
   `gestfic0_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `gestfic0_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `gestfic0_custom_small_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gestfic0_custom_text` text COLLATE utf8_unicode_ci,
  `gestfic0_custom_integer` int(11) DEFAULT NULL,
  `gestfic0_custom_date` date DEFAULT NULL,
  `gestfic0_custom_float` float DEFAULT NULL,
  KEY `gestfic0_custom_champ` (`gestfic0_custom_champ`),
  KEY `gestfic0_custom_origine` (`gestfic0_custom_origine`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `gestfic0_custom_values`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `grilles`
--

CREATE TABLE IF NOT EXISTS `grilles` (
   `grille_typdoc` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  `grille_niveau_biblio` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'm',
  `grille_localisation` mediumint(8) NOT NULL DEFAULT '0',
  `descr_format` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`grille_typdoc`,`grille_niveau_biblio`,`grille_localisation`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `grilles`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `groupe`
--

CREATE TABLE IF NOT EXISTS `groupe` (
  `id_groupe` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `libelle_groupe` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `resp_groupe` int(6) unsigned DEFAULT '0',
  `lettre_rappel` int(1) unsigned NOT NULL DEFAULT '0',
  `mail_rappel` int(1) unsigned NOT NULL DEFAULT '0',
  `lettre_rappel_show_nomgroup` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_groupe`),
  UNIQUE KEY `libelle_groupe` (`libelle_groupe`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `groupe`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `groupexpl`
--

CREATE TABLE IF NOT EXISTS `groupexpl` (
  `id_groupexpl` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `groupexpl_resp_expl_num` int(10) unsigned NOT NULL DEFAULT '0',
  `groupexpl_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `groupexpl_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `groupexpl_location` int(10) unsigned NOT NULL DEFAULT '0',
  `groupexpl_statut_resp` int(10) unsigned NOT NULL DEFAULT '0',
  `groupexpl_statut_others` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_groupexpl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `groupexpl`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `groupexpl_expl`
--

CREATE TABLE IF NOT EXISTS `groupexpl_expl` (
   `groupexpl_num` int(10) unsigned NOT NULL DEFAULT '0',
  `groupexpl_expl_num` int(10) unsigned NOT NULL DEFAULT '0',
  `groupexpl_checked` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`groupexpl_num`,`groupexpl_expl_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `groupexpl_expl`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `harvest_field`
--

CREATE TABLE IF NOT EXISTS `harvest_field` (
   `id_harvest_field` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_harvest_profil` int(10) unsigned NOT NULL DEFAULT '0',
  `harvest_field_xml_id` int(10) unsigned NOT NULL DEFAULT '0',
  `harvest_field_first_flag` int(10) unsigned NOT NULL DEFAULT '0',
  `harvest_field_order` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_harvest_field`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `harvest_field`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `harvest_profil`
--

CREATE TABLE IF NOT EXISTS `harvest_profil` (
  `id_harvest_profil` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `harvest_profil_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_harvest_profil`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `harvest_profil`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `harvest_profil_import`
--

CREATE TABLE IF NOT EXISTS `harvest_profil_import` (
 `id_harvest_profil_import` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `harvest_profil_import_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_harvest_profil_import`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `harvest_profil_import`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `harvest_profil_import_field`
--

CREATE TABLE IF NOT EXISTS `harvest_profil_import_field` (
 `num_harvest_profil_import` int(10) unsigned NOT NULL DEFAULT '0',
  `harvest_profil_import_field_xml_id` int(10) unsigned NOT NULL DEFAULT '0',
  `harvest_profil_import_field_flag` int(10) unsigned NOT NULL DEFAULT '0',
  `harvest_profil_import_field_order` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_harvest_profil_import`,`harvest_profil_import_field_xml_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `harvest_profil_import_field`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `harvest_search_field`
--

CREATE TABLE IF NOT EXISTS `harvest_search_field` (
  `num_harvest_profil` int(10) unsigned NOT NULL DEFAULT '0',
  `num_source` int(10) unsigned NOT NULL DEFAULT '0',
  `num_field` int(10) unsigned NOT NULL DEFAULT '0',
  `num_ss_field` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_harvest_profil`,`num_source`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `harvest_search_field`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `harvest_src`
--

CREATE TABLE IF NOT EXISTS `harvest_src` (
   `id_harvest_src` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_harvest_field` int(10) unsigned NOT NULL DEFAULT '0',
  `num_source` int(10) unsigned NOT NULL DEFAULT '0',
  `harvest_src_unimacfield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `harvest_src_unimacsubfield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `harvest_src_pmb_unimacfield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `harvest_src_pmb_unimacsubfield` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `harvest_src_prec_flag` int(10) unsigned NOT NULL DEFAULT '0',
  `harvest_src_order` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_harvest_src`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `harvest_src`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `import_marc`
--

CREATE TABLE IF NOT EXISTS `import_marc` (
  `id_import` bigint(5) unsigned NOT NULL AUTO_INCREMENT,
  `notice` longblob NOT NULL,
  `origine` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
  `no_notice` int(10) unsigned DEFAULT '0',
  `encoding` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_import`),
  KEY `i_nonot_orig` (`no_notice`,`origine`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `import_marc`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `indexint`
--

CREATE TABLE IF NOT EXISTS `indexint` (
  `indexint_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `indexint_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `indexint_comment` text COLLATE utf8_unicode_ci NOT NULL,
  `index_indexint` text COLLATE utf8_unicode_ci,
  `num_pclass` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`indexint_id`),
  UNIQUE KEY `indexint_name` (`indexint_name`,`num_pclass`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `indexint`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `indexint_custom`
--

CREATE TABLE `indexint_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_type` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `titre` varchar(255) DEFAULT NULL,
  `type` varchar(10) NOT NULL DEFAULT 'text',
  `datatype` varchar(10) NOT NULL DEFAULT '',
  `options` text,
  `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=InnoDB DEFAULT CHARSET=utf8;



--
-- Volcar la base de datos para la tabla `indexint_custom`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `indexint_custom_lists`
--

CREATE TABLE `indexint_custom_lists` (
  `indexint_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `indexint_custom_list_value` varchar(255) DEFAULT NULL,
  `indexint_custom_list_lib` varchar(255) DEFAULT NULL,
  `ordre` int(11) DEFAULT NULL,
  KEY `editorial_custom_champ` (`indexint_custom_champ`),
  KEY `editorial_champ_list_value` (`indexint_custom_champ`,`indexint_custom_list_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



--
-- Volcar la base de datos para la tabla `indexint_custom_lists`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `indexint_custom_values`
--

CREATE TABLE `indexint_custom_values` (
  `indexint_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `indexint_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `indexint_custom_small_text` varchar(255) DEFAULT NULL,
  `indexint_custom_text` text,
  `indexint_custom_integer` int(11) DEFAULT NULL,
  `indexint_custom_date` date DEFAULT NULL,
  `indexint_custom_float` float DEFAULT NULL,
  KEY `editorial_custom_champ` (`indexint_custom_champ`),
  KEY `editorial_custom_origine` (`indexint_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `indexint_custom_values`
--

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `infopages`
--

CREATE TABLE IF NOT EXISTS `infopages` (
 `id_infopage` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content_infopage` longblob NOT NULL,
  `title_infopage` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `valid_infopage` tinyint(1) NOT NULL DEFAULT '1',
  `restrict_infopage` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_infopage`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Volcar la base de datos para la tabla `infopages`
--

INSERT INTO `infopages` (`id_infopage`, `content_infopage`, `title_infopage`, `valid_infopage`, `restrict_infopage`) VALUES
(1, 0x[encoded data, 4804 characters], 'Actu rencontres', 1, 0),
(2, 0x[encoded data, 5172 characters], 'PMB Version 4.0', 1, 0),
(6, 0x3c7461626c653e0d0a3c74723e0d0a3c7464202077696474683d22353230223e0d0a3c696672616d652077696474683d2235303022206865696768743d2234353022206672616d65626f726465723d223022207363726f6c6c696e673d226e6f22206d617267696e6865696768743d223022206d617267696e77696474683d223022207372633d2268747470733a2f2f6d6170732e676f6f676c652e66722f6d6170733f713d706d622b736572766963657326616d703b6f653d7574662d3826616d703b61713d7426616d703b636c69656e743d66697265666f782d6126616d703b69653d5554463826616d703b686c3d667226616d703b68713d706d622b736572766963657326616d703b686e6561723d4368254333254132746561752d64752d4c6f69722c2b5361727468652c2b506179732b64652b6c612b4c6f69726526616d703b6c6c3d34372e3638343033332c302e34323830343826616d703b73706e3d302e3031383939372c302e30323139353626616d703b743d6d26616d703b6f75747075743d656d626564223e3c2f696672616d653e3c6272202f3e3c736d616c6c3e3c6120687265663d2268747470733a2f2f6d6170732e676f6f676c652e66722f6d6170733f713d706d622b736572766963657326616d703b6f653d7574662d3826616d703b61713d7426616d703b636c69656e743d66697265666f782d6126616d703b69653d5554463826616d703b686c3d667226616d703b68713d706d622b736572766963657326616d703b686e6561723d4368254333254132746561752d64752d4c6f69722c2b5361727468652c2b506179732b64652b6c612b4c6f69726526616d703b6c6c3d34372e3638343033332c302e34323830343826616d703b73706e3d302e3031383939372c302e30323139353626616d703b743d6d26616d703b736f757263653d656d62656422207374796c653d22636f6c6f723a233030303046463b746578742d616c69676e3a6c656674223e416772616e646972206c6520706c616e3c2f613e3c2f736d616c6c3e0d0a3c2f74643e0d0a3c7464207374796c653d22666f6e742d73697a653a20313570783b223e0d0a504d422053657276696365733c6272202f3e0d0a5a41206465204d6f6e7420737572204c6f69723c6272202f3e0d0a4250203130203032333c6272202f3e0d0a373220353030204368e274656175206475204c6f69723c6272202f3e0d0a3c6272202f3e0d0a3c623e54e96c203a202b3333202830293220343320343430203636303c2f623e3c6272202f3e0d0a3c6272202f3e0d0a3c623e4d61696c203a20706d6240736967622e6e65743c2f623e3c6272202f3e0d0a3c6272202f3e0d0a7777772e736967622e6e65740d0a3c2f74643e0d0a3c2f74723e0d0a3c2f7461626c653e, 'Nous trouver', 1, 0),
(7, 0x[encoded data, 15778 characters], 'Mentions légales', 1, 0),
(3, 0x[encoded data, 4952 characters], 'Aide en ligne', 1, 0),
(4, 0x3c68333e43616c656e646f632c206c276167656e646120636f6c6c61626f7261746966206465732070726f73206465206c27696e666f2d646f633c2f68333e0d0a0d0a3c696672616d65207372633d22687474703a2f2f7777772e676f6f676c652e636f6d2f63616c656e6461722f656d6265643f63747a3d4575726f70652f506172697322207374796c653d22626f726465723a2030222077696474683d2238303022206865696768743d2236303022206672616d65626f726465723d223022207363726f6c6c696e673d226e6f223e3c2f696672616d653e0d0a3c6272202f3e0d0a3c6120687265663d22687474703a2f2f6c616269626170707269766f697365652e776f726470726573732e636f6d2f323030392f30312f32372f63616c656e646f632d6c6167656e64612d636f6c6c61626f72617469662d6465732d70726f732d64652d6c696e666f2d646f632f22207461726765743d225f626c616e6b223e706c7573206427696e666f73207375722043616c656e646f633c2f613e, 'Consulter Calendoc', 1, 0),
(5, 0x3c703e3c623e4173747563653c2f623e207574696c6973657a20646573206775696c6c656d65747320706f757220636865726368657220756e6520737569746520646520636172616374266567726176653b726573203a202671756f743b72266561637574653b766f6c7574696f6e206672616e2663636564696c3b616973652671756f743b3c2f703e, 'aide sous la recherche simple', 1, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `lenders`
--

CREATE TABLE IF NOT EXISTS `lenders` (
 `idlender` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `lender_libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`idlender`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Volcar la base de datos para la tabla `lenders`
--

INSERT INTO `lenders` (`idlender`, `lender_libelle`) VALUES
(1, 'BDP'),
(2, 'Fondo propio');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `liens_actes`
--

CREATE TABLE IF NOT EXISTS `liens_actes` (
 `num_acte` int(8) unsigned NOT NULL DEFAULT '0',
  `num_acte_lie` int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_acte`,`num_acte_lie`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `liens_actes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `lignes_actes`
--

CREATE TABLE IF NOT EXISTS `lignes_actes` (
  `id_ligne` int(15) unsigned NOT NULL AUTO_INCREMENT,
  `type_ligne` int(3) unsigned NOT NULL DEFAULT '0',
  `num_acte` int(8) unsigned NOT NULL DEFAULT '0',
  `lig_ref` int(15) unsigned NOT NULL DEFAULT '0',
  `num_acquisition` int(12) unsigned NOT NULL DEFAULT '0',
  `num_rubrique` int(8) unsigned NOT NULL DEFAULT '0',
  `num_produit` int(8) unsigned NOT NULL DEFAULT '0',
  `num_type` int(8) unsigned NOT NULL DEFAULT '0',
  `libelle` text COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `prix` float(8,2) NOT NULL DEFAULT '0.00',
  `tva` float(8,2) unsigned NOT NULL DEFAULT '0.00',
  `nb` int(5) unsigned NOT NULL DEFAULT '1',
  `date_ech` date NOT NULL DEFAULT '0000-00-00',
  `date_cre` date NOT NULL DEFAULT '0000-00-00',
  `statut` int(3) unsigned NOT NULL DEFAULT '0',
  `remise` float(8,2) NOT NULL DEFAULT '0.00',
  `index_ligne` text COLLATE utf8_unicode_ci NOT NULL,
  `ligne_ordre` smallint(2) unsigned NOT NULL DEFAULT '0',
  `debit_tva` smallint(2) unsigned NOT NULL DEFAULT '0',
  `commentaires_gestion` text COLLATE utf8_unicode_ci NOT NULL,
  `commentaires_opac` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_ligne`),
  KEY `num_acte` (`num_acte`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `lignes_actes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `lignes_actes_relances`
--

CREATE TABLE IF NOT EXISTS `lignes_actes_relances` (
 `num_ligne` int(10) unsigned NOT NULL,
  `date_relance` date NOT NULL DEFAULT '0000-00-00',
  `type_ligne` int(3) unsigned NOT NULL DEFAULT '0',
  `num_acte` int(8) unsigned NOT NULL DEFAULT '0',
  `lig_ref` int(15) unsigned NOT NULL DEFAULT '0',
  `num_acquisition` int(12) unsigned NOT NULL DEFAULT '0',
  `num_rubrique` int(8) unsigned NOT NULL DEFAULT '0',
  `num_produit` int(8) unsigned NOT NULL DEFAULT '0',
  `num_type` int(8) unsigned NOT NULL DEFAULT '0',
  `libelle` text COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `prix` float(8,2) NOT NULL DEFAULT '0.00',
  `tva` float(8,2) unsigned NOT NULL DEFAULT '0.00',
  `nb` int(5) unsigned NOT NULL DEFAULT '1',
  `date_ech` date NOT NULL DEFAULT '0000-00-00',
  `date_cre` date NOT NULL DEFAULT '0000-00-00',
  `statut` int(3) unsigned NOT NULL DEFAULT '1',
  `remise` float(8,2) NOT NULL DEFAULT '0.00',
  `index_ligne` text COLLATE utf8_unicode_ci NOT NULL,
  `ligne_ordre` smallint(2) unsigned NOT NULL DEFAULT '0',
  `debit_tva` smallint(2) unsigned NOT NULL DEFAULT '0',
  `commentaires_gestion` text COLLATE utf8_unicode_ci NOT NULL,
  `commentaires_opac` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`num_ligne`,`date_relance`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `lignes_actes_relances`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `lignes_actes_statuts`
--

CREATE TABLE IF NOT EXISTS `lignes_actes_statuts` (
 `id_statut` int(3) NOT NULL AUTO_INCREMENT,
  `libelle` text COLLATE utf8_unicode_ci NOT NULL,
  `relance` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_statut`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Volcar la base de datos para la tabla `lignes_actes_statuts`
--

INSERT INTO `lignes_actes_statuts` (`id_statut`, `libelle`, `relance`) VALUES
(1, 'Traitement normal', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `linked_mots`
--

CREATE TABLE IF NOT EXISTS `linked_mots` (
 `num_mot` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `num_linked_mot` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `type_lien` tinyint(1) NOT NULL DEFAULT '1',
  `ponderation` float NOT NULL DEFAULT '1',
  PRIMARY KEY (`num_mot`,`num_linked_mot`,`type_lien`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `linked_mots`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `log_expl_retard`
--

CREATE TABLE IF NOT EXISTS `log_expl_retard` (
  `id_log` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date_log` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `titre` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `expl_id` int(11) NOT NULL DEFAULT '0',
  `expl_cb` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `date_pret` date NOT NULL DEFAULT '0000-00-00',
  `date_retour` date NOT NULL DEFAULT '0000-00-00',
  `amende` decimal(16,2) NOT NULL DEFAULT '0.00',
  `num_log_retard` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_log`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `log_expl_retard`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `log_retard`
--

CREATE TABLE IF NOT EXISTS `log_retard` (
 `id_log` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date_log` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `niveau_reel` int(1) NOT NULL DEFAULT '0',
  `niveau_suppose` int(1) NOT NULL DEFAULT '0',
  `amende_totale` decimal(16,2) NOT NULL DEFAULT '0.00',
  `frais` decimal(16,2) NOT NULL DEFAULT '0.00',
  `idempr` int(11) NOT NULL DEFAULT '0',
  `log_printed` int(1) unsigned NOT NULL DEFAULT '0',
  `log_mail` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_log`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `log_retard`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `logopac`
--

CREATE TABLE IF NOT EXISTS `logopac` (
 `id_log` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `date_log` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `url_demandee` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `url_referente` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `get_log` blob NOT NULL,
  `post_log` blob NOT NULL,
  `num_session` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `server_log` blob NOT NULL,
  `empr_carac` blob NOT NULL,
  `empr_doc` blob NOT NULL,
  `empr_expl` blob NOT NULL,
  `nb_result` blob NOT NULL,
  `gen_stat` blob NOT NULL,
  PRIMARY KEY (`id_log`),
  KEY `lopac_date_log` (`date_log`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `logopac`
--

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `mailtpl`
--

CREATE TABLE IF NOT EXISTS `mailtpl` (
  `id_mailtpl` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mailtpl_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mailtpl_objet` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mailtpl_tpl` text COLLATE utf8_unicode_ci NOT NULL,
  `mailtpl_users` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_mailtpl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `mailtpl`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `mots`
--

CREATE TABLE IF NOT EXISTS `mots` (
 `id_mot` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `mot` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_mot`),
  UNIQUE KEY `mot` (`mot`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `mots`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `noeuds`
--

CREATE TABLE IF NOT EXISTS `noeuds` (
 `id_noeud` int(9) unsigned NOT NULL AUTO_INCREMENT,
  `autorite` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `num_parent` int(9) unsigned NOT NULL DEFAULT '0',
  `num_renvoi_voir` int(9) unsigned NOT NULL DEFAULT '0',
  `visible` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  `num_thesaurus` int(3) unsigned NOT NULL DEFAULT '0',
  `path` text COLLATE utf8_unicode_ci NOT NULL,
  `authority_import_denied` int(10) unsigned NOT NULL DEFAULT '0',
  `not_use_in_indexation` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_noeud`),
  KEY `num_parent` (`num_parent`),
  KEY `num_thesaurus` (`num_thesaurus`),
  KEY `autorite` (`autorite`),
  KEY `key_path` (`path`(333)),
  KEY `i_num_renvoi_voir` (`num_renvoi_voir`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Volcar la base de datos para la tabla `noeuds`
--

INSERT INTO `noeuds` (`id_noeud`, `autorite`, `num_parent`, `num_renvoi_voir`, `visible`, `num_thesaurus`, `path`, `authority_import_denied`, `not_use_in_indexation`) VALUES
(1, 'TOP', 0, 0, '0', 1, '', 0, 0),
(2, 'NONCLASSES', 1, 0, '0', 1, '', 0, 0),
(3, 'ORPHELINS', 1, 0, '0', 1, '', 0, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notice_statut`
--

CREATE TABLE IF NOT EXISTS `notice_statut` (
 `id_notice_statut` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `gestion_libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `opac_libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notice_visible_opac` tinyint(1) NOT NULL DEFAULT '1',
  `notice_visible_gestion` tinyint(1) NOT NULL DEFAULT '1',
  `expl_visible_opac` tinyint(1) NOT NULL DEFAULT '1',
  `class_html` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `notice_visible_opac_abon` tinyint(1) NOT NULL DEFAULT '0',
  `expl_visible_opac_abon` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_visible_opac` int(1) unsigned NOT NULL DEFAULT '1',
  `explnum_visible_opac_abon` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_notice_statut`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Volcar la base de datos para la tabla `notice_statut`
--

INSERT INTO `notice_statut` (`id_notice_statut`, `gestion_libelle`, `opac_libelle`, `notice_visible_opac`, `notice_visible_gestion`, `expl_visible_opac`, `class_html`, `notice_visible_opac_abon`, `expl_visible_opac_abon`, `explnum_visible_opac`, `explnum_visible_opac_abon`) VALUES
(1, 'Sin estado', '', 1, 1, 1, 'statutnot1', 0, 0, 1, 0),
(2, 'Préstamo rápido', '', 0, 1, 1, 'statutnot2', 1, 0, 1, 0),
(3, 'Pedido', 'commandé', 1, 1, 1, 'statutnot4', 0, 0, 1, 0),
(4, 'En cours d''import / saisie', '', 0, 1, 0, 'statutnot10', 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notice_tpl`
--

CREATE TABLE IF NOT EXISTS `notice_tpl` (
  `notpl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `notpl_name` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `notpl_code` text COLLATE utf8_unicode_ci NOT NULL,
  `notpl_comment` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `notpl_id_test` int(10) unsigned NOT NULL DEFAULT '0',
  `notpl_show_opac` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`notpl_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;

--
-- Volcar la base de datos para la tabla `notice_tpl`
--

INSERT INTO `notice_tpl` (`notpl_id`, `notpl_name`, `notpl_code`, `notpl_comment`, `notpl_id_test`, `notpl_show_opac`) VALUES
(5, 'Template d''affichage personnalisé sans vignette', '', 'Template d''affichage personnalisé sans vignette', 58, 1),
(4, 'Template d''affichage personnalisé', '', '', 58, 0),
(6, 'Bibliographie', '', 'PMB Services', 58, 0);

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `notice_tplcode`
--

CREATE TABLE IF NOT EXISTS `notice_tplcode` (
 `num_notpl` int(10) unsigned NOT NULL DEFAULT '0',
  `notplcode_localisation` mediumint(8) NOT NULL DEFAULT '0',
  `notplcode_typdoc` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  `notplcode_niveau_biblio` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'm',
  `notplcode_niveau_hierar` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `nottplcode_code` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`num_notpl`,`notplcode_localisation`,`notplcode_typdoc`,`notplcode_niveau_biblio`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notice_tplcode`
--

INSERT INTO `notice_tplcode` (`num_notpl`, `notplcode_localisation`, `notplcode_typdoc`, `notplcode_niveau_biblio`, `notplcode_niveau_hierar`, `nottplcode_code`) VALUES
(5, 0, '0', '0', '0', '<table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>\r\n<h2>\r\n#title();\r\n</h2>\r\n\r\n\r\n<p class="resume">\r\n#resume();\r\n</p>\r\n<p class="source">\r\n\r\n#b_empty(#author();#b_empty(#author_1();, - );, - );\r\n#if(#is_article();,\r\n#nom_revue();#a_empty(#numero_bulletin();, - ); - #date_bulletin();,\r\n#b_empty(#publisher();, - ); #year_publication(););\r\n#a_empty(#note();,<br />);\r\n</p>\r\n<br />\r\n<p class="resume">\r\n#contenu();\r\n</p>\r\n#expl_num();\r\n</td>\r\n</tr>\r\n</table>'),
(4, 0, '0', '0', '0', '<table width="100%" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>\r\n<h2>\r\n#title();\r\n</h2>\r\n\r\n\r\n<p class="resume">\r\n#resume();\r\n</p>\r\n<p class="source">\r\n\r\n#b_empty(#author();#b_empty(#author_1();, - );, - );\r\n#if(#is_article();,\r\n#nom_revue();#a_empty(#numero_bulletin();, - ); - #date_bulletin();,\r\n#b_empty(#publisher();, - ); #year_publication(););\r\n#a_empty(#note();,<br />);\r\n</p>\r\n<br />\r\n<p class="resume">\r\n#contenu();\r\n</p>\r\n#expl_num();\r\n</td>\r\n<td>\r\n#str_replace(&,&amp;,#img(););\r\n</td>\r\n</tr>\r\n</table>'),
(6, 0, '0', 'a', '0', '#str_replace(\\, .,.,#b_empty(#authors_by_type_with_tpl(1,3,\\, ,\\, ,0,1,70\\,71\\,72,{name}\\, {rejete});,#ifequal(#lastchr(#authors_by_type_with_tpl(1,3,\\, ,\\, ,0,1,70\\,71\\,72,{name}\\, {rejete}););,., ,. );););\r\n\r\n&laquo; #title();#a_empty(#complement_title();, : );#a_empty(#parallel_title();, = ); &raquo;#ifequal(#lastchr(#title();#a_empty(#complement_title();, : );#a_empty(#parallel_title();, = ););,.,,#ifequal(#lastchr(#title();#a_empty(#complement_title();, : );#a_empty(#parallel_title();, = ););,!,,#ifequal(#lastchr(#title();#a_empty(#complement_title();, : );#a_empty(#parallel_title();, = ););,?,,.););); \r\n\r\n<i>#nom_revue();</i>#a_empty(#numero_bulletin();,\\, );#not_empty(#date_bulletin();, (#if(#extract_path((.*) [(],#date_bulletin(););,#extract_path((.*) [(],#date_bulletin(););,#date_bulletin(););));#not_empty(#page();,\\, #if(#extract_path(^[0-9](.*),#page(););,p. #page();,#page(););#ifequal(#lastchr(#page(););,.,,.););'),
(6, 0, '0', '0', '0', '#str_replace(\\, .,.,#b_empty(#authors_by_type_with_tpl(1,3,\\, ,\\, ,0,1,70\\,71\\,72,{name}\\, {rejete});,#ifequal(#lastchr(#authors_by_type_with_tpl(1,3,\\, ,\\, ,0,1,70\\,71\\,72,{name}\\, {rejete}););,., ,. );););\r\n\r\n<i>#title();#a_empty(#complement_title();, : );#a_empty(#parallel_title();, = );#ifequal(#lastchr(#title();#a_empty(#complement_title();, : );#a_empty(#parallel_title();, = ););,.,,#ifequal(#lastchr(#title();#a_empty(#complement_title();, : );#a_empty(#parallel_title();, = ););,!,,#ifequal(#lastchr(#title();#a_empty(#complement_title();, : );#a_empty(#parallel_title();, = ););,?,,.););); </i>\r\n\r\n#mention_edition();#ifequal(#lastchr(#mention_edition(););,., ,#not_empty(#mention_edition();,. ););#publisher();#a_empty(#year_publication();,\\, );#ifequal(#lastchr(#publisher();#a_empty(#year_publication();,\\, ););,.,,#not_empty(#publisher();#a_empty(#year_publication();,\\, );,.););\r\n\r\n #page();\r\n\r\n#not_empty(#collection();, (#if(#extract_path((.*)\\, ISSN,#collection(););,#extract_path((.*)\\, ISSN,#collection(););,#collection(););#a_empty(#notice_field(nocoll);, ; );) );');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices`
--

CREATE TABLE IF NOT EXISTS `notices` (
  `notice_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `typdoc` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  `tit1` text COLLATE utf8_unicode_ci,
  `tit2` text COLLATE utf8_unicode_ci,
  `tit3` text COLLATE utf8_unicode_ci,
  `tit4` text COLLATE utf8_unicode_ci,
  `tparent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `tnvol` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ed1_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ed2_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `coll_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `subcoll_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `year` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nocoll` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mention_edition` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `npages` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ill` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `size` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accomp` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `n_gen` text COLLATE utf8_unicode_ci NOT NULL,
  `n_contenu` text COLLATE utf8_unicode_ci NOT NULL,
  `n_resume` text COLLATE utf8_unicode_ci NOT NULL,
  `lien` text COLLATE utf8_unicode_ci NOT NULL,
  `eformat` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `index_l` text COLLATE utf8_unicode_ci NOT NULL,
  `indexint` int(8) unsigned NOT NULL DEFAULT '0',
  `index_serie` tinytext COLLATE utf8_unicode_ci,
  `index_matieres` text COLLATE utf8_unicode_ci NOT NULL,
  `niveau_biblio` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'm',
  `niveau_hierar` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `origine_catalogage` int(8) unsigned NOT NULL DEFAULT '1',
  `prix` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `index_n_gen` text COLLATE utf8_unicode_ci,
  `index_n_contenu` text COLLATE utf8_unicode_ci,
  `index_n_resume` text COLLATE utf8_unicode_ci,
  `index_sew` text COLLATE utf8_unicode_ci,
  `index_wew` text COLLATE utf8_unicode_ci,
  `statut` int(5) NOT NULL DEFAULT '1',
  `commentaire_gestion` text COLLATE utf8_unicode_ci NOT 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,
  `signature` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `thumbnail_url` mediumblob NOT NULL,
  `date_parution` date NOT NULL DEFAULT '0000-00-00',
  `opac_visible_bulletinage` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `indexation_lang` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`notice_id`),
  KEY `typdoc` (`typdoc`),
  KEY `tparent_id` (`tparent_id`),
  KEY `ed1_id` (`ed1_id`),
  KEY `ed2_id` (`ed2_id`),
  KEY `coll_id` (`coll_id`),
  KEY `subcoll_id` (`subcoll_id`),
  KEY `cb` (`code`),
  KEY `indexint` (`indexint`),
  KEY `sig_index` (`signature`),
  KEY `i_notice_n_biblio` (`niveau_biblio`),
  KEY `i_notice_n_hierar` (`niveau_hierar`),
  KEY `notice_eformat` (`eformat`),
  KEY `i_date_parution` (`date_parution`),
  KEY `i_not_statut` (`statut`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `notices`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_authorities_sources`
--

CREATE TABLE IF NOT EXISTS `notices_authorities_sources` (
`num_authority_source` int(10) unsigned NOT NULL DEFAULT '0',
  `num_notice` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_authority_source`,`num_notice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notices_authorities_sources`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_categories`
--

CREATE TABLE IF NOT EXISTS `notices_categories` (
 `notcateg_notice` int(9) unsigned NOT NULL DEFAULT '0',
  `num_noeud` int(9) unsigned NOT NULL DEFAULT '0',
  `num_vedette` int(3) unsigned NOT NULL DEFAULT '0',
  `ordre_vedette` int(3) unsigned NOT NULL DEFAULT '1',
  `ordre_categorie` smallint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`notcateg_notice`,`num_noeud`,`num_vedette`),
  KEY `num_noeud` (`num_noeud`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notices_categories`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_custom`
--

CREATE TABLE IF NOT EXISTS `notices_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 '1',
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `notices_custom`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_custom_lists`
--

CREATE TABLE IF NOT EXISTS `notices_custom_lists` (
 `notices_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `notices_custom_list_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notices_custom_list_lib` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ordre` int(11) DEFAULT NULL,
  KEY `notices_custom_champ` (`notices_custom_champ`),
  KEY `i_ncl_lv` (`notices_custom_list_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notices_custom_lists`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_custom_values`
--

CREATE TABLE IF NOT EXISTS `notices_custom_values` (
  `notices_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `notices_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `notices_custom_small_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `notices_custom_text` text COLLATE utf8_unicode_ci,
  `notices_custom_integer` int(11) DEFAULT NULL,
  `notices_custom_date` date DEFAULT NULL,
  `notices_custom_float` float DEFAULT NULL,
  KEY `notices_custom_champ` (`notices_custom_champ`),
  KEY `notices_custom_origine` (`notices_custom_origine`),
  KEY `i_ncv_st` (`notices_custom_small_text`),
  KEY `i_ncv_t` (`notices_custom_text`(255)),
  KEY `i_ncv_i` (`notices_custom_integer`),
  KEY `i_ncv_d` (`notices_custom_date`),
  KEY `i_ncv_f` (`notices_custom_float`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notices_custom_values`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_externes`
--

CREATE TABLE IF NOT EXISTS `notices_externes` (
  `num_notice` int(11) NOT NULL DEFAULT '0',
  `recid` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`num_notice`),
  KEY `i_recid` (`recid`),
  KEY `i_notice_recid` (`num_notice`,`recid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notices_externes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_fields_global_index`
--

CREATE TABLE IF NOT EXISTS `notices_fields_global_index` (
`id_notice` mediumint(8) NOT NULL DEFAULT '0',
  `code_champ` int(3) NOT NULL DEFAULT '0',
  `code_ss_champ` int(3) NOT NULL DEFAULT '0',
  `ordre` int(4) NOT NULL DEFAULT '0',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `pond` int(4) NOT NULL DEFAULT '100',
  `lang` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `authority_num` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_notice`,`code_champ`,`code_ss_champ`,`lang`,`ordre`),
  KEY `i_value` (`value`(300)),
  KEY `i_code_champ_code_ss_champ` (`code_champ`,`code_ss_champ`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
/*!50100 PARTITION BY KEY (code_champ,code_ss_champ)
PARTITIONS 50 */;

--
-- Volcar la base de datos para la tabla `notices_fields_global_index`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_global_index`
--

CREATE TABLE IF NOT EXISTS `notices_global_index` (
`num_notice` mediumint(8) NOT NULL DEFAULT '0',
  `no_index` mediumint(8) NOT NULL DEFAULT '0',
  `infos_global` text COLLATE utf8_unicode_ci NOT NULL,
  `index_infos_global` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`num_notice`,`no_index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notices_global_index`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_langues`
--

CREATE TABLE IF NOT EXISTS `notices_langues` (
 `num_notice` int(8) unsigned NOT NULL DEFAULT '0',
  `type_langue` int(1) unsigned NOT NULL DEFAULT '0',
  `code_langue` char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ordre_langue` smallint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_notice`,`type_langue`,`code_langue`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notices_langues`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_mots_global_index`
--

CREATE TABLE IF NOT EXISTS `notices_mots_global_index` (
  `id_notice` mediumint(8) NOT NULL DEFAULT '0',
  `code_champ` int(3) NOT NULL DEFAULT '0',
  `code_ss_champ` int(3) NOT NULL DEFAULT '0',
  `num_word` int(10) unsigned NOT NULL DEFAULT '0',
  `pond` int(4) NOT NULL DEFAULT '100',
  `position` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_notice`,`code_champ`,`num_word`,`position`,`code_ss_champ`),
  KEY `code_champ` (`code_champ`),
  KEY `i_id_mot` (`num_word`,`id_notice`),
  KEY `i_code_champ_code_ss_champ_num_word` (`code_champ`,`code_ss_champ`,`num_word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
/*!50100 PARTITION BY KEY (code_champ,code_ss_champ)
PARTITIONS 50 */;

--
-- Volcar la base de datos para la tabla `notices_mots_global_index`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_relations`
--

CREATE TABLE IF NOT EXISTS `notices_relations` (
 `num_notice` bigint(20) unsigned NOT NULL DEFAULT '0',
  `linked_notice` bigint(20) unsigned NOT NULL DEFAULT '0',
  `relation_type` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rank` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num_notice`,`linked_notice`),
  KEY `linked_notice` (`linked_notice`),
  KEY `relation_type` (`relation_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notices_relations`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notices_titres_uniformes`
--

CREATE TABLE IF NOT EXISTS `notices_titres_uniformes` (
  `ntu_num_notice` int(9) unsigned NOT NULL DEFAULT '0',
  `ntu_num_tu` int(9) unsigned NOT NULL DEFAULT '0',
  `ntu_titre` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ntu_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ntu_sous_vedette` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ntu_langue` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ntu_version` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ntu_mention` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ntu_ordre` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ntu_num_notice`,`ntu_num_tu`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `notices_titres_uniformes`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `offres_remises`
--

CREATE TABLE IF NOT EXISTS `offres_remises` (
 `num_fournisseur` int(5) unsigned NOT NULL DEFAULT '0',
  `num_produit` int(8) unsigned NOT NULL DEFAULT '0',
  `remise` float(4,2) unsigned NOT NULL DEFAULT '0.00',
  `condition_remise` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`num_fournisseur`,`num_produit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `offres_remises`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `opac_filters`
--

CREATE TABLE IF NOT EXISTS `opac_filters` (
 `opac_filter_view_num` int(10) unsigned NOT NULL DEFAULT '0',
  `opac_filter_path` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `opac_filter_param` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`opac_filter_view_num`,`opac_filter_path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `opac_filters`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `opac_liste_lecture`
--

CREATE TABLE IF NOT EXISTS `opac_liste_lecture` (
 `id_liste` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `nom_liste` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` text COLLATE utf8_unicode_ci,
  `notices_associees` blob NOT NULL,
  `public` int(1) NOT NULL DEFAULT '0',
  `num_empr` int(8) unsigned NOT NULL DEFAULT '0',
  `read_only` int(1) NOT NULL DEFAULT '0',
  `confidential` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_liste`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `opac_liste_lecture`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `opac_sessions`
--

CREATE TABLE IF NOT EXISTS `opac_sessions` (
 `empr_id` int(10) unsigned NOT NULL DEFAULT '0',
  `session` blob,
  `date_rec` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`empr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `opac_sessions`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `opac_views`
--

CREATE TABLE IF NOT EXISTS `opac_views` (
 `opac_view_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `opac_view_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `opac_view_query` text COLLATE utf8_unicode_ci NOT NULL,
  `opac_view_human_query` text COLLATE utf8_unicode_ci NOT NULL,
  `opac_view_param` text COLLATE utf8_unicode_ci NOT NULL,
  `opac_view_visible` int(1) unsigned NOT NULL DEFAULT '0',
  `opac_view_comment` text COLLATE utf8_unicode_ci NOT NULL,
  `opac_view_last_gen` datetime DEFAULT NULL,
  `opac_view_ttl` int(11) NOT NULL DEFAULT '86400',
  PRIMARY KEY (`opac_view_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `opac_views`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `opac_views_empr`
--

CREATE TABLE IF NOT EXISTS `opac_views_empr` (
`emprview_view_num` int(10) unsigned NOT NULL DEFAULT '0',
  `emprview_empr_num` int(10) unsigned NOT NULL DEFAULT '0',
  `emprview_default` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`emprview_view_num`,`emprview_empr_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `opac_views_empr`
--

-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `origin_authorities`
--

CREATE TABLE IF NOT EXISTS `origin_authorities` (
`id_origin_authorities` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `origin_authorities_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `origin_authorities_country` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `origin_authorities_diffusible` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_origin_authorities`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Volcar la base de datos para la tabla `origin_authorities`
--

INSERT INTO `origin_authorities` (`id_origin_authorities`, `origin_authorities_name`, `origin_authorities_country`, `origin_authorities_diffusible`) VALUES
(1, 'Catalogue Interne', 'FR', 1),
(2, 'BnF', 'FR', 1);

-- --------------------------------------------------------



--
-- Estructura de tabla para la tabla `origine_notice`
--

CREATE TABLE IF NOT EXISTS `origine_notice` (
 `orinot_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `orinot_nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `orinot_pays` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'FR',
  `orinot_diffusion` int(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`orinot_id`),
  KEY `orinot_nom` (`orinot_nom`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Volcar la base de datos para la tabla `origine_notice`
--

INSERT INTO `origine_notice` (`orinot_id`, `orinot_nom`, `orinot_pays`, `orinot_diffusion`) VALUES
(3, 'Catalogage interne', 'FR', 1),
(2, 'BnF', 'ES', 1),
(1, 'Catalogación interna', 'ES', 1),
(4, 'FR-751131015', 'FR', 1);

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `ouvertures`
--

CREATE TABLE IF NOT EXISTS `ouvertures` (
   `date_ouverture` date NOT NULL DEFAULT '0000-00-00',
  `ouvert` int(1) NOT NULL DEFAULT '1',
  `commentaire` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `num_location` int(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`date_ouverture`,`num_location`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `ouvertures`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `paiements`
--

CREATE TABLE IF NOT EXISTS `paiements` (
  `id_paiement` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `commentaire` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_paiement`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `paiements`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `param_subst`
--

