--
-- Host: localhost    Database: pmb
-- ------------------------------------------------------


--
-- Table structure for table `abo_liste_lecture`
--

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

--
-- Dumping data for table `abo_liste_lecture`
--


--
-- Table structure for table `abts_abts`
--

CREATE TABLE `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',
  `prix` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  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;

--
-- Dumping data for table `abts_abts`
--


--
-- Table structure for table `abts_abts_modeles`
--

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

--
-- Dumping data for table `abts_abts_modeles`
--


--
-- Table structure for table `abts_grille_abt`
--

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

--
-- Dumping data for table `abts_grille_abt`
--


--
-- Table structure for table `abts_grille_modele`
--

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

--
-- Dumping data for table `abts_grille_modele`
--


--
-- Table structure for table `abts_modeles`
--

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

--
-- Dumping data for table `abts_modeles`
--


--
-- Table structure for table `abts_periodicites`
--

CREATE TABLE `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 AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `abts_periodicites`
--

INSERT INTO `abts_periodicites` VALUES (5,'Bimestral',2,1,30,10,0),(4,'Mensual',1,1,15,5,0),(3,'Bimensual',14,0,10,5,0),(2,'Semanal',7,0,4,2,0),(1,'Diario',1,0,2,1,0),(6,'Trimestral',3,1,30,10,0),(7,'Quatrimestral',4,1,30,10,0),(8,'Semestral',6,1,30,10,0),(9,'Anual',1,2,30,10,0);

--
-- Table structure for table `acces_profiles`
--

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

--
-- Dumping data for table `acces_profiles`
--


--
-- Table structure for table `acces_rights`
--

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

--
-- Dumping data for table `acces_rights`
--


--
-- Table structure for table `actes`
--

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

--
-- Dumping data for table `actes`
--


--
-- Table structure for table `admin_session`
--

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

--
-- Dumping data for table `admin_session`
--


--
-- Table structure for table `analysis`
--

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

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


--
-- Table structure for table `arch_emplacement`
--

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `arch_emplacement`
--

INSERT INTO `arch_emplacement` VALUES (1,'Estantería');

--
-- Table structure for table `arch_statut`
--

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `arch_statut`
--

INSERT INTO `arch_statut` VALUES (1,'Consultable en el sitio','Consultable en el sitio',1,0,1,'statutnot2');

--
-- Table structure for table `arch_type`
--

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `arch_type`
--

INSERT INTO `arch_type` VALUES (1,'Revista');

--
-- Table structure for table `audit`
--

CREATE TABLE `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,
  `type_user` int(1) unsigned NOT NULL DEFAULT '0',
  `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;

--
-- Dumping data for table `audit`
--


--
-- Table structure for table `aut_link`
--

CREATE TABLE `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`),
  KEY `i_from` (`aut_link_from`,`aut_link_from_num`),
  KEY `i_to` (`aut_link_to`,`aut_link_to_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `aut_link`
--


--
-- Table structure for table `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) 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',
  `comment` blob NOT NULL,
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `author_custom`
--


--
-- Table structure for table `author_custom_lists`
--

CREATE TABLE `author_custom_lists` (
  `author_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `author_custom_list_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author_custom_list_lib` varchar(255) COLLATE utf8_unicode_ci 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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `author_custom_lists`
--


--
-- Table structure for table `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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author_custom_text` text COLLATE utf8_unicode_ci,
  `author_custom_integer` int(11) DEFAULT NULL,
  `author_custom_date` date DEFAULT NULL,
  `author_custom_float` float DEFAULT NULL,
  `author_custom_order` int(11) NOT NULL DEFAULT '0',
  KEY `editorial_custom_champ` (`author_custom_champ`),
  KEY `editorial_custom_origine` (`author_custom_origine`),
  KEY `i_acv_st` (`author_custom_small_text`),
  KEY `i_acv_t` (`author_custom_text`(255)),
  KEY `i_acv_i` (`author_custom_integer`),
  KEY `i_acv_d` (`author_custom_date`),
  KEY `i_acv_f` (`author_custom_float`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `author_custom_values`
--


--
-- Table structure for table `authorities`
--

CREATE TABLE `authorities` (
  `id_authority` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_object` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `type_object` int(10) unsigned NOT NULL DEFAULT '0',
  `num_statut` int(2) unsigned NOT NULL DEFAULT '1',
  `thumbnail_url` mediumblob NOT NULL,
  PRIMARY KEY (`id_authority`),
  UNIQUE KEY `i_a_num_object_type_object` (`num_object`,`type_object`),
  KEY `i_a_num_statut` (`num_statut`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authorities`
--

INSERT INTO `authorities` VALUES (1,2,2,1,''),(2,3,2,1,'');

--
-- Table structure for table `authorities_caddie`
--

CREATE TABLE `authorities_caddie` (
  `idcaddie` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(20) NOT NULL DEFAULT '',
  `comment` varchar(255) NOT NULL DEFAULT '',
  `autorisations` mediumtext,
  `caddie_classement` varchar(255) NOT NULL DEFAULT '',
  `acces_rapide` int(11) NOT NULL DEFAULT '0',
  `creation_user_name` varchar(255) NOT NULL DEFAULT '',
  `creation_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`idcaddie`),
  KEY `caddie_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authorities_caddie`
--


--
-- Table structure for table `authorities_caddie_content`
--

CREATE TABLE `authorities_caddie_content` (
  `caddie_id` int(8) unsigned NOT NULL DEFAULT '0',
  `object_id` int(10) unsigned NOT NULL DEFAULT '0',
  `flag` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`caddie_id`,`object_id`),
  KEY `object_id` (`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authorities_caddie_content`
--


--
-- Table structure for table `authorities_caddie_procs`
--

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

--
-- Dumping data for table `authorities_caddie_procs`
--


--
-- Table structure for table `authorities_fields_global_index`
--

CREATE TABLE `authorities_fields_global_index` (
  `id_authority` int(10) unsigned NOT NULL DEFAULT '0',
  `type` int(5) unsigned NOT NULL DEFAULT '0',
  `code_champ` int(10) NOT NULL DEFAULT '0',
  `code_ss_champ` int(3) NOT NULL DEFAULT '0',
  `ordre` int(4) NOT NULL DEFAULT '0',
  `value` text NOT NULL,
  `pond` int(4) NOT NULL DEFAULT '100',
  `lang` varchar(10) NOT NULL DEFAULT '',
  `authority_num` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_authority`,`code_champ`,`code_ss_champ`,`ordre`),
  KEY `i_value` (`value`(300)),
  KEY `i_id_value` (`id_authority`,`value`(300)),
  KEY `i_code_champ_code_ss_champ` (`code_champ`,`code_ss_champ`),
  KEY `i_id_authority` (`id_authority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authorities_fields_global_index`
--


--
-- Table structure for table `authorities_sources`
--

CREATE TABLE `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`),
  KEY `i_num_authority_authority_type` (`num_authority`,`authority_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `authorities_sources`
--


--
-- Table structure for table `authorities_statuts`
--

CREATE TABLE `authorities_statuts` (
  `id_authorities_statut` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `authorities_statut_label` varchar(255) NOT NULL DEFAULT '',
  `authorities_statut_class_html` varchar(25) NOT NULL DEFAULT '',
  `authorities_statut_available_for` text,
  PRIMARY KEY (`id_authorities_statut`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authorities_statuts`
--

INSERT INTO `authorities_statuts` VALUES (1,'Estado por defecto','statutnot1','a:9:{i:0;s:1:\"1\";i:1;s:1:\"2\";i:2;s:1:\"3\";i:3;s:1:\"4\";i:4;s:1:\"5\";i:5;s:1:\"6\";i:6;s:1:\"8\";i:7;s:1:\"7\";i:8;s:2:\"10\";}');

--
-- Table structure for table `authorities_words_global_index`
--

CREATE TABLE `authorities_words_global_index` (
  `id_authority` int(10) unsigned NOT NULL DEFAULT '0',
  `type` int(5) unsigned NOT NULL DEFAULT '0',
  `code_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `code_ss_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `num_word` int(10) unsigned NOT NULL DEFAULT '0',
  `pond` int(10) unsigned NOT NULL DEFAULT '100',
  `position` int(10) unsigned NOT NULL DEFAULT '1',
  `field_position` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_authority`,`code_champ`,`code_ss_champ`,`num_word`,`position`,`field_position`),
  KEY `code_champ` (`code_champ`),
  KEY `i_id_mot` (`num_word`,`id_authority`),
  KEY `i_code_champ_code_ss_champ_num_word` (`code_champ`,`code_ss_champ`,`num_word`),
  KEY `i_num_word` (`num_word`),
  KEY `i_id_authority` (`id_authority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `authorities_words_global_index`
--


--
-- Table structure for table `authors`
--

CREATE TABLE `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`),
  KEY `i_author_type` (`author_type`),
  KEY `i_index_author_author_type` (`index_author`(333),`author_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `authperso`
--

CREATE TABLE `authperso` (
  `id_authperso` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `authperso_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `authperso_notice_onglet_num` int(10) unsigned NOT NULL DEFAULT '0',
  `authperso_isbd_script` text COLLATE utf8_unicode_ci NOT NULL,
  `authperso_view_script` text COLLATE utf8_unicode_ci NOT NULL,
  `authperso_opac_search` int(10) unsigned NOT NULL DEFAULT '0',
  `authperso_opac_multi_search` int(10) unsigned NOT NULL DEFAULT '0',
  `authperso_gestion_search` int(10) unsigned NOT NULL DEFAULT '0',
  `authperso_gestion_multi_search` int(10) unsigned NOT NULL DEFAULT '0',
  `authperso_comment` text COLLATE utf8_unicode_ci NOT NULL,
  `authperso_oeuvre_event` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_authperso`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `authperso`
--


--
-- Table structure for table `authperso_authorities`
--

CREATE TABLE `authperso_authorities` (
  `id_authperso_authority` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `authperso_authority_authperso_num` int(10) unsigned NOT NULL DEFAULT '0',
  `authperso_infos_global` text COLLATE utf8_unicode_ci NOT NULL,
  `authperso_index_infos_global` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_authperso_authority`),
  KEY `i_authperso_authority_authperso_num` (`authperso_authority_authperso_num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `authperso_authorities`
--


--
-- Table structure for table `authperso_custom`
--

CREATE TABLE `authperso_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `custom_prefixe` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `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',
  `comment` blob NOT NULL,
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `authperso_custom`
--


--
-- Table structure for table `authperso_custom_lists`
--

CREATE TABLE `authperso_custom_lists` (
  `authperso_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `authperso_custom_list_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `authperso_custom_list_lib` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ordre` int(11) DEFAULT NULL,
  KEY `editorial_custom_champ` (`authperso_custom_champ`),
  KEY `editorial_champ_list_value` (`authperso_custom_champ`,`authperso_custom_list_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `authperso_custom_lists`
--


--
-- Table structure for table `authperso_custom_values`
--

CREATE TABLE `authperso_custom_values` (
  `authperso_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `authperso_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `authperso_custom_small_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `authperso_custom_text` text COLLATE utf8_unicode_ci,
  `authperso_custom_integer` int(11) DEFAULT NULL,
  `authperso_custom_date` date DEFAULT NULL,
  `authperso_custom_float` float DEFAULT NULL,
  `authperso_custom_order` int(11) NOT NULL DEFAULT '0',
  KEY `editorial_custom_champ` (`authperso_custom_champ`),
  KEY `editorial_custom_origine` (`authperso_custom_origine`),
  KEY `i_acv_st` (`authperso_custom_small_text`),
  KEY `i_acv_t` (`authperso_custom_text`(255)),
  KEY `i_acv_i` (`authperso_custom_integer`),
  KEY `i_acv_d` (`authperso_custom_date`),
  KEY `i_acv_f` (`authperso_custom_float`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `authperso_custom_values`
--


--
-- Table structure for table `avis`
--

CREATE TABLE `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',
  `type_object` mediumint(8) NOT NULL,
  `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',
  `avis_private` int(1) unsigned NOT NULL DEFAULT '0',
  `avis_num_liste_lecture` int(8) 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;

--
-- Dumping data for table `avis`
--


--
-- Table structure for table `bannette_abon`
--

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

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


--
-- Table structure for table `bannette_contenu`
--

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

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


--
-- Table structure for table `bannette_empr_categs`
--

CREATE TABLE `bannette_empr_categs` (
  `empr_categ_num_bannette` int(10) unsigned NOT NULL DEFAULT '0',
  `empr_categ_num_categ` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`empr_categ_num_bannette`,`empr_categ_num_categ`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bannette_empr_categs`
--


--
-- Table structure for table `bannette_empr_groupes`
--

CREATE TABLE `bannette_empr_groupes` (
  `empr_groupe_num_bannette` int(10) unsigned NOT NULL DEFAULT '0',
  `empr_groupe_num_groupe` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`empr_groupe_num_bannette`,`empr_groupe_num_groupe`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bannette_empr_groupes`
--


--
-- Table structure for table `bannette_equation`
--

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

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


--
-- Table structure for table `bannette_exports`
--

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

--
-- Dumping data for table `bannette_exports`
--


--
-- Table structure for table `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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bannette_facettes`
--


--
-- Table structure for table `bannette_tpl`
--

CREATE TABLE `bannette_tpl` (
  `bannettetpl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bannettetpl_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bannettetpl_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `bannettetpl_tpl` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`bannettetpl_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bannette_tpl`
--

INSERT INTO `bannette_tpl` VALUES (1,'Template PMB','','{{info.header}}\r\n<br /><br />\r\n<div class=\"summary\">\r\n{% for sommaire in sommaires %}\r\n<a href=\"#[{{sommaire.level}}]\">\r\n{{sommaire.level}} - {{sommaire.title}}\r\n</a>\r\n<br />\r\n{% endfor %}\r\n</div>\r\n<hr>\r\n{% for sommaire in sommaires %}\r\n<a name=\"[{{sommaire.level}}]\" />\r\n<h1>{{sommaire.level}} - {{sommaire.title}}</h1>\r\n{% for record in sommaire.records %}\r\n{{record.render}}\r\n<hr>\r\n{% endfor %}\r\n<br />\r\n{% endfor %}\r\n{{info.footer}}');

--
-- Table structure for table `bannettes`
--

CREATE TABLE `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',
  `display_notice_in_every_group` 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',
  `bannette_tpl_num` int(6) unsigned NOT NULL DEFAULT '0',
  `bannette_aff_notice_number` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_bannette`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bannettes_descriptors`
--


--
-- Table structure for table `budgets`
--

CREATE TABLE `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` double(12,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;

--
-- Dumping data for table `budgets`
--


--
-- Table structure for table `bulletins`
--

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

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


--
-- Table structure for table `cache_amendes`
--

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

--
-- Dumping data for table `cache_amendes`
--


--
-- Table structure for table `caddie`
--

CREATE TABLE `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,
  `caddie_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `acces_rapide` int(11) NOT NULL DEFAULT '0',
  `creation_user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `creation_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`idcaddie`),
  KEY `caddie_type` (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `caddie`
--

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

--
-- Table structure for table `caddie_content`
--

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

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


--
-- Table structure for table `caddie_procs`
--

CREATE TABLE `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 AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `caddie_procs`
--

INSERT INTO `caddie_procs` VALUES (1,'SELECT','Registros por autor','SELECT notice_id as object_id, \'NOTI\' as object_type FROM notices, authors, responsability WHERE author_name like \'%!!critere!!%\' AND author_id=responsability_author AND notice_id=responsability_notice\r\n','Selección de registros dónde el nombre del autor contiene ciertas letras','1 2 3','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','create TEMPORARY TABLE tmp SELECT tit1 FROM notices GROUP BY tit1 HAVING count(*)>1\r\nSELECT notice_id as object_id, \'NOTI\' as object_type FROM notices, tmp wHERE notices.tit1=tmp.tit1','Selección de los registros duplicados por el título principal','1 2 3',NULL),(3,'SELECT','EXPL por sección / propietario','select expl_id as object_id, \'EXPL\' as object_type from exemplaires where expl_section in (!!section!!) and expl_owner=!!proprio!!','Selección de ejemplares por sección y por propietario','1 2','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','select expl_id as object_id, \'EXPL\' as object_type from exemplaires where expl_cote like \'!!comme_cote!!%\'','Selección de ejemplares a partir del inicio de su signatura','1 2','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','SELECT expl_id as object_id, \'EXPL\' as object_type, concat(\"LIVRE \",tit1) as Titre FROM notices join exemplaires on expl_notice=notice_id LEFT JOIN pret_archive ON arc_expl_notice = notice_id where arc_expl_id IS NULL AND expl_id IS NOT NULL UNION SELECT expl_id as object_id, \'EXPL\' as object_type, concat(\"PERIO \",tit1, \" Numéro : \",bulletin_numero) as Titre FROM (bulletins INNER JOIN notices ON bulletins.bulletin_notice = notices.notice_id) INNER JOIN exemplaires on expl_bulletin=bulletin_id LEFT JOIN pret_archive ON expl_id = arc_expl_id WHERE pret_archive.arc_id Is Null','Añade a una cesta los ejemplares que nunca se han prestado','1 2',NULL),(7,'SELECT','Selección de ejemplares por estado','select expl_id as object_id, \'EXPL\' as object_type from exemplaires where expl_statut in (!!statut!!)','','1 2','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','select expl_id as object_id, \'EXPL\' as object_type from exemplaires where expl_section in (!!section!!) and expl_location in (!!location!!) and expl_statut in (!!statut!!) and expl_owner=!!proprio!!  ','','1 2','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update bulletins set bulletin_notice=!!new_perio!! where bulletin_id in (CADDIE(BULL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','select distinct bulletin_id as object_id,\'BULL\' as object_type from bulletins left join analysis on analysis_bulletin=bulletin_id where analysis_bulletin is null','',' 1 ',''),(13,'SELECT','Sélection / pointage de bulletins par date','select bulletin_id as object_id, \'BULL\' as object_type from bulletins where date_date>\'!!dated!!\' AND date_date<\'!!datef!!\'','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_codestat=\'!!new_codestat!!\' where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_date_depot=\'!!new_date_depot!!\' where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_date_retour=\'!!new_date_retour!!\' where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_location=\'!!new_location!!\' where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_note=\'!!new_note!!\' where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_cote=replace(expl_cote, \'!!motif_1!!\', \'!!motif_2!!\') where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_prix=\'!!new_prix!!\' where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_section=\'!!new_section!!\' where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_statut=\'!!new_statut!!\' where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_typdoc=\'!!new_typdoc!!\' where expl_id in (CADDIE(EXPL))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','SELECT pret_idexpl as object_id, \'EXPL\' as object_type from pret','',' 1 ',''),(27,'SELECT','Sélection d\'exemplaires à partir d\'un fichier de code-barres','select expl_id as object_id, \'EXPL\' as object_type from exemplaires where expl_cb in (!!fichier!!)','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update notices set notices.indexint=\'!!nouvelle_indexation!!\'  where notice_id in (CADDIE(NOTI))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update notices set statut=\'!!new_statut!!\' where notice_id in (CADDIE(NOTI))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update notices set typdoc=!!new_typdoc!! where notice_id in (CADDIE(NOTI))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','INSERT ignore INTO responsability (responsability_author, responsability_notice, responsability_type, responsability_fonction) \r\nSELECT \r\nr2.responsability_author, num_notice, r2.responsability_type, r2.responsability_fonction \r\nFROM notices_relations JOIN responsability r2 ON linked_notice = r2.responsability_notice where linked_notice IN (CADDIE(NOTI))','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','select distinct linked_notice as object_id, \'NOTI\' as object_type from notices_relations','',' 1 ',''),(35,'SELECT','Sélection / pointage des notices ayant une notice mère','select distinct num_notice as object_id, \'NOTI\' as object_type from notices_relations','',' 1 ',''),(36,'SELECT','Sélection / pointage de notices par type de document et statut','SELECT DISTINCT notice_id as object_id, \"NOTI\" as object_type FROM notices where typdoc =!!type_doc!! and statut =\'!!statut!!\'','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','SELECT DISTINCT notice_id as object_id, \"NOTI\" as object_type FROM `notices` left join notices_relations nr1 on nr1.num_notice=notice_id left join notices_relations nr2 on nr2.linked_notice=notice_id where nr1.num_notice is null and nr2.linked_notice is null','',' 1 ',''),(39,'SELECT','Sélection des exemplaires non empruntés depuis une certaine date','select expl_id as object_id,\'EXPL\'as object_type FROM exemplaires where date_format(last_loan_date,\'%Y%m%d\') < date_format(\'!!dat!!\',\'%Y%m%d\')','','1','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_statut=!!nouveau_statut!! where expl_id in (CADDIE(EXPL))','Permite cambiar el estado de los ejemplares de una cesta','1 4 3 2','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update exemplaires set expl_section=!!nouvelle_section!! where expl_id in (CADDIE(EXPL))','','1 4 3 2','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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>');

--
-- Table structure for table `cashdesk`
--

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

--
-- Dumping data for table `cashdesk`
--


--
-- Table structure for table `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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cashdesk_locations`
--


--
-- Table structure for table `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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cashdesk_sections`
--


--
-- Table structure for table `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) 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',
  `comment` blob NOT NULL,
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `categ_custom`
--


--
-- Table structure for table `categ_custom_lists`
--

CREATE TABLE `categ_custom_lists` (
  `categ_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `categ_custom_list_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `categ_custom_list_lib` varchar(255) COLLATE utf8_unicode_ci 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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `categ_custom_lists`
--


--
-- Table structure for table `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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `categ_custom_text` text COLLATE utf8_unicode_ci,
  `categ_custom_integer` int(11) DEFAULT NULL,
  `categ_custom_date` date DEFAULT NULL,
  `categ_custom_float` float DEFAULT NULL,
  `categ_custom_order` int(11) NOT NULL DEFAULT '0',
  KEY `editorial_custom_champ` (`categ_custom_champ`),
  KEY `editorial_custom_origine` (`categ_custom_origine`),
  KEY `i_ccv_st` (`categ_custom_small_text`),
  KEY `i_ccv_t` (`categ_custom_text`(255)),
  KEY `i_ccv_i` (`categ_custom_integer`),
  KEY `i_ccv_d` (`categ_custom_date`),
  KEY `i_ccv_f` (`categ_custom_float`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `categ_custom_values`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `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)),
  KEY `i_num_thesaurus` (`num_thesaurus`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` 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 ','','');

--
-- Table structure for table `classements`
--

CREATE TABLE `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 '',
  `classement_opac_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `classement_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_classement`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classements`
--

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

--
-- Table structure for table `cms`
--

CREATE TABLE `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',
  `cms_opac_view_num` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_cms`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms`
--


--
-- Table structure for table `cms_articles`
--

CREATE TABLE `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',
  `article_update_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  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;

--
-- Dumping data for table `cms_articles`
--


--
-- Table structure for table `cms_articles_descriptors`
--

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

--
-- Dumping data for table `cms_articles_descriptors`
--


--
-- Table structure for table `cms_build`
--

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

--
-- Dumping data for table `cms_build`
--


--
-- Table structure for table `cms_cache_cadres`
--

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

--
-- Dumping data for table `cms_cache_cadres`
--


--
-- Table structure for table `cms_cadre_content`
--

CREATE TABLE `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`),
  KEY `i_cadre_content_num_cadre` (`cadre_content_num_cadre`),
  KEY `i_cadre_content_num_cadre_content_cadre_content_type` (`cadre_content_num_cadre_content`,`cadre_content_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_cadre_content`
--


--
-- Table structure for table `cms_cadres`
--

CREATE TABLE `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',
  `cadre_css_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_cadre`),
  KEY `i_cadre_memo_url` (`cadre_memo_url`),
  KEY `i_cadre_object` (`cadre_object`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_cadres`
--


--
-- Table structure for table `cms_collections`
--

CREATE TABLE `cms_collections` (
  `id_collection` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `collection_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `collection_description` text COLLATE utf8_unicode_ci 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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_collections`
--


--
-- Table structure for table `cms_documents`
--

CREATE TABLE `cms_documents` (
  `id_document` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `document_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `document_description` text COLLATE utf8_unicode_ci NOT NULL,
  `document_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `document_mimetype` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `document_filesize` int(11) NOT NULL DEFAULT '0',
  `document_vignette` mediumblob NOT NULL,
  `document_url` text COLLATE utf8_unicode_ci NOT NULL,
  `document_path` varchar(255) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `document_num_object` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_document`),
  KEY `i_cms_document_title` (`document_title`),
  KEY `i_document_num_object_document_type_object` (`document_num_object`,`document_type_object`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_documents`
--


--
-- Table structure for table `cms_documents_links`
--

CREATE TABLE `cms_documents_links` (
  `document_link_type_object` varchar(255) COLLATE utf8_unicode_ci 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`),
  KEY `i_document_link_num_document` (`document_link_num_document`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_documents_links`
--


--
-- Table structure for table `cms_editorial_custom`
--

CREATE TABLE `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',
  `comment` blob NOT NULL,
  PRIMARY KEY (`idchamp`),
  KEY `i_num_type` (`num_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_editorial_custom`
--


--
-- Table structure for table `cms_editorial_custom_lists`
--

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

--
-- Dumping data for table `cms_editorial_custom_lists`
--


--
-- Table structure for table `cms_editorial_custom_values`
--

CREATE TABLE `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,
  `cms_editorial_custom_order` int(11) NOT NULL DEFAULT '0',
  KEY `editorial_custom_champ` (`cms_editorial_custom_champ`),
  KEY `editorial_custom_origine` (`cms_editorial_custom_origine`),
  KEY `i_ccv_st` (`cms_editorial_custom_small_text`),
  KEY `i_ccv_t` (`cms_editorial_custom_text`(255)),
  KEY `i_ccv_i` (`cms_editorial_custom_integer`),
  KEY `i_ccv_d` (`cms_editorial_custom_date`),
  KEY `i_ccv_f` (`cms_editorial_custom_float`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_editorial_custom_values`
--


--
-- Table structure for table `cms_editorial_fields_global_index`
--

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

--
-- Dumping data for table `cms_editorial_fields_global_index`
--


--
-- Table structure for table `cms_editorial_publications_states`
--

CREATE TABLE `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',
  `editorial_publication_state_class_html` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_publication_state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_editorial_publications_states`
--


--
-- Table structure for table `cms_editorial_types`
--

CREATE TABLE `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,
  `editorial_type_permalink_num_page` int(11) NOT NULL DEFAULT '0',
  `editorial_type_permalink_var_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_editorial_type`),
  KEY `i_editorial_type_element` (`editorial_type_element`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_editorial_types`
--

INSERT INTO `cms_editorial_types` VALUES (1,'article_generic','CP pour Article','','',0,''),(2,'section_generic','CP pour Rubrique','','',0,'');

--
-- Table structure for table `cms_editorial_words_global_index`
--

CREATE TABLE `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`),
  KEY `i_num_word` (`num_word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_editorial_words_global_index`
--


--
-- Table structure for table `cms_hash`
--

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

--
-- Dumping data for table `cms_hash`
--


--
-- Table structure for table `cms_managed_modules`
--

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

--
-- Dumping data for table `cms_managed_modules`
--


--
-- Table structure for table `cms_modules_extensions_datas`
--

CREATE TABLE `cms_modules_extensions_datas` (
  `id_extension_datas` int(10) NOT NULL AUTO_INCREMENT,
  `extension_datas_module` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `extension_datas_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `extension_datas_type_element` varchar(255) COLLATE utf8_unicode_ci 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=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cms_modules_extensions_datas`
--


--
-- Table structure for table `cms_pages`
--

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

--
-- Dumping data for table `cms_pages`
--


--
-- Table structure for table `cms_pages_env`
--

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

--
-- Dumping data for table `cms_pages_env`
--


--
-- Table structure for table `cms_sections`
--

CREATE TABLE `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',
  `section_update_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  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;

--
-- Dumping data for table `cms_sections`
--


--
-- Table structure for table `cms_sections_descriptors`
--

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

--
-- Dumping data for table `cms_sections_descriptors`
--


--
-- Table structure for table `cms_toolkits`
--

CREATE TABLE `cms_toolkits` (
  `cms_toolkit_name` varchar(255) NOT NULL DEFAULT '',
  `cms_toolkit_active` int(1) NOT NULL DEFAULT '0',
  `cms_toolkit_data` text NOT NULL,
  `cms_toolkit_order` int(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cms_toolkit_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_toolkits`
--


--
-- Table structure for table `cms_vars`
--

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

--
-- Dumping data for table `cms_vars`
--


--
-- Table structure for table `cms_version`
--

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

--
-- Dumping data for table `cms_version`
--


--
-- Table structure for table `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) 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',
  `comment` blob NOT NULL,
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `collection_custom`
--


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

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

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


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

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

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


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

CREATE TABLE `collections` (
  `collection_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `collection_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `collection_parent` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `collection_issn` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `index_coll` 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;

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


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

CREATE TABLE `collections_state` (
  `collstate_id` int(8) NOT NULL AUTO_INCREMENT,
  `id_serial` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `location_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `state_collections` 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;

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


--
-- Table structure for table `collstate_bulletins`
--

CREATE TABLE `collstate_bulletins` (
  `collstate_bulletins_num_collstate` int(8) NOT NULL DEFAULT '0',
  `collstate_bulletins_num_bulletin` int(8) NOT NULL DEFAULT '0',
  `collstate_bulletins_order` int(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`collstate_bulletins_num_collstate`,`collstate_bulletins_num_bulletin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `collstate_bulletins`
--


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

CREATE TABLE `collstate_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `titre` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  `datatype` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` 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',
  `comment` blob NOT NULL,
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


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

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

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


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

CREATE TABLE `comptes` (
  `id_compte` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type_compte_id` int(10) unsigned NOT NULL DEFAULT '0',
  `solde` decimal(16,2) DEFAULT '0.00',
  `prepay_mnt` decimal(16,2) NOT NULL DEFAULT '0.00',
  `proprio_id` int(10) unsigned NOT NULL DEFAULT '0',
  `droits` 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;

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `connectors_sources` (
  `source_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_connector` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `parameters` 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 '',
  `last_sync_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `clean_html` int(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`source_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `contact_form_objects`
--

CREATE TABLE `contact_form_objects` (
  `id_object` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `object_label` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contact_form_objects`
--


--
-- Table structure for table `contribution_area_areas`
--

CREATE TABLE `contribution_area_areas` (
  `id_area` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `area_title` varchar(255) NOT NULL DEFAULT '',
  `area_comment` text NOT NULL,
  `area_color` varchar(10) NOT NULL DEFAULT '',
  `area_order` int(5) NOT NULL DEFAULT '0',
  `area_status` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_area`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contribution_area_areas`
--


--
-- Table structure for table `contribution_area_equations`
--

CREATE TABLE `contribution_area_equations` (
  `contribution_area_equation_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contribution_area_equation_name` varchar(255) NOT NULL DEFAULT '',
  `contribution_area_equation_type` varchar(255) NOT NULL DEFAULT '',
  `contribution_area_equation_query` text NOT NULL,
  `contribution_area_equation_human_query` text NOT NULL,
  PRIMARY KEY (`contribution_area_equation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contribution_area_equations`
--


--
-- Table structure for table `contribution_area_forms`
--

CREATE TABLE `contribution_area_forms` (
  `id_form` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `form_title` varchar(255) NOT NULL DEFAULT '',
  `form_type` varchar(255) NOT NULL DEFAULT '',
  `form_parameters` blob NOT NULL,
  PRIMARY KEY (`id_form`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contribution_area_forms`
--


--
-- Table structure for table `contribution_area_status`
--

CREATE TABLE `contribution_area_status` (
  `contribution_area_status_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contribution_area_status_gestion_libelle` varchar(255) NOT NULL DEFAULT '',
  `contribution_area_status_opac_libelle` varchar(255) NOT NULL DEFAULT '',
  `contribution_area_status_class_html` varchar(255) NOT NULL DEFAULT '',
  `contribution_area_status_available_for` text,
  PRIMARY KEY (`contribution_area_status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contribution_area_status`
--

INSERT INTO `contribution_area_status` VALUES (1,'Statut par défaut','Statut par défaut','statutnot1','a:10:{i:0;s:6:\"record\";i:1;s:6:\"author\";i:2;s:8:\"category\";i:3;s:9:\"publisher\";i:4;s:10:\"collection\";i:5;s:14:\"sub_collection\";i:6;s:5:\"serie\";i:7;s:4:\"work\";i:8;s:8:\"indexint\";i:9;s:7:\"concept\";}');

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

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

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


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

CREATE TABLE `demandes` (
  `id_demande` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_demandeur` int(10) unsigned NOT NULL DEFAULT '0',
  `theme_demande` int(3) NOT NULL DEFAULT '0',
  `type_demande` int(3) NOT NULL DEFAULT '0',
  `etat_demande` int(3) NOT NULL DEFAULT '0',
  `date_demande` date NOT NULL DEFAULT '0000-00-00',
  `date_prevue` date NOT NULL DEFAULT '0000-00-00',
  `deadline_demande` date NOT NULL DEFAULT '0000-00-00',
  `titre_demande` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sujet_demande` 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',
  `dmde_read_gestion` int(1) unsigned NOT NULL DEFAULT '0',
  `reponse_finale` text COLLATE utf8_unicode_ci,
  `dmde_read_opac` int(1) unsigned NOT NULL DEFAULT '0',
  `demande_note_num` int(10) unsigned NOT NULL DEFAULT '0',
  `num_linked_notice` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_demande`),
  KEY `i_num_demandeur` (`num_demandeur`),
  KEY `i_date_demande` (`date_demande`),
  KEY `i_deadline_demande` (`deadline_demande`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

CREATE TABLE `demandes_actions` (
  `id_action` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type_action` int(3) NOT NULL DEFAULT '0',
  `statut_action` int(3) NOT NULL DEFAULT '0',
  `sujet_action` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `detail_action` 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` int(10) unsigned NOT NULL DEFAULT '0',
  `actions_type_user` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `actions_read_opac` int(11) NOT NULL DEFAULT '0',
  `actions_read_gestion` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_action`),
  KEY `i_date_action` (`date_action`),
  KEY `i_deadline_action` (`deadline_action`),
  KEY `i_num_demande` (`num_demande`),
  KEY `i_actions_user` (`actions_num_user`,`actions_type_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

CREATE TABLE `docs_location` (
  `idlocation` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `location_libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `locdoc_codage_import` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `locdoc_owner` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `location_pic` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `location_visible_opac` tinyint(1) NOT NULL DEFAULT '1',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `adr1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `adr2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cp` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `town` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `state` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `country` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `phone` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `website` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `logo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `commentaire` 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 AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `docs_location` 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);

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

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

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

INSERT INTO `docs_section` 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);

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

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

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

INSERT INTO `docs_statut` 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);

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

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

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

INSERT INTO `docs_type` 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);

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

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

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

INSERT INTO `docsloc_section` 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);

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

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

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


--
-- Table structure for table `docwatch_datasource_monitoring_website`
--

CREATE TABLE `docwatch_datasource_monitoring_website` (
  `datasource_monitoring_website_num_datasource` int(10) unsigned NOT NULL DEFAULT '0',
  `datasource_monitoring_website_upload_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `datasource_monitoring_website_content` mediumtext NOT NULL,
  `datasource_monitoring_website_content_hash` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`datasource_monitoring_website_num_datasource`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `docwatch_datasource_monitoring_website`
--


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `editions_states` (
  `id_editions_state` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `editions_state_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `editions_state_num_classement` int(11) NOT NULL DEFAULT '0',
  `editions_state_used_datasource` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `editions_state_comment` 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;

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


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

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

--
-- Dumping data for table `empr`
--


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

CREATE TABLE `empr_caddie` (
  `idemprcaddie` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `autorisations` mediumtext COLLATE utf8_unicode_ci,
  `empr_caddie_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `acces_rapide` int(11) NOT NULL DEFAULT '0',
  `creation_user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `creation_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`idemprcaddie`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `empr_caddie` VALUES (1,'Panier de lecteurs','','1','',0,'','0000-00-00 00:00:00');

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

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

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


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

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

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

INSERT INTO `empr_caddie_procs` VALUES (1,'ACTION','Changement de localisation des lecteurs d\'un panier','update empr set empr_location=\'!!new_location!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_categ=\'!!new_categ!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_ville=\'!!new_ville!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_cp=\'!!new_cp!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_pays=\'!!new_pays!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_statut=\'!!nouveau_statut!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_codestat=\'!!new_codestat!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_password=\'!!new_password!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_date_adhesion=\'!!new_date_adhesion!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_date_expiration=\'!!new_date_expiration!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_sexe=!!new_sexe!! where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_msg=\'!!new_msg!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','select id_empr as object_id from empr where trim(empr_mail)=\'\'','',' 1 ',NULL),(18,'ACTION','Abonnement des lecteurs d\'un panier à une bannette publique (DSI)','insert into bannette_abon (num_bannette, num_empr, actif) select !!bannette!!, id_empr, 1 from empr where id_empr in (CADDIE(EMPR)) ','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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)','delete from bannette_abon where num_bannette=!!bannette!! and num_empr=id_empr and actif=1 where id_empr in (CADDIE(EMPR)) ','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set empr_prof=\'!!new_prof!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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','update empr set type_abt=\'!!new_type_abt!!\' where id_empr in (CADDIE(EMPR))','',' 1 ','<?xml version=\"1.0\" encoding=\"utf-8\"?>\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>');

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

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

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

INSERT INTO `empr_categ` 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);

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

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

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

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

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

CREATE TABLE `empr_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `titre` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  `datatype` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` 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',
  `comment` blob NOT NULL,
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `empr_statut` VALUES (1,'Actif',1,0,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0),(2,'Interdit',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `empr_temp`
--

CREATE TABLE `empr_temp` (
  `cb` varchar(255) NOT NULL,
  `sess` varchar(12) NOT NULL,
  UNIQUE KEY `cb` (`cb`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `empr_temp`
--


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

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

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


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

CREATE TABLE `entites` (
  `id_entite` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `type_entite` int(3) unsigned NOT NULL DEFAULT '0',
  `num_bibli` int(5) unsigned NOT NULL DEFAULT '0',
  `raison_sociale` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `commentaires` 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;

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

CREATE TABLE `es_converted_cache` (
  `es_converted_cache_objecttype` int(11) NOT NULL DEFAULT '0',
  `es_converted_cache_objectref` int(11) NOT NULL DEFAULT '0',
  `es_converted_cache_format` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `es_converted_cache_value` 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;

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `etagere` VALUES (3,'Loire','Exposition virtuelle sur la Loire',1,'0000-00-00','0000-00-00',1,'1 4 3 2',0,'','','');

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

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

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

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

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

CREATE TABLE `exemplaires` (
  `expl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `expl_cb` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expl_notice` int(10) unsigned NOT NULL DEFAULT '0',
  `expl_bulletin` int(10) unsigned NOT NULL DEFAULT '0',
  `expl_typdoc` int(5) unsigned NOT NULL DEFAULT '0',
  `expl_cote` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expl_section` smallint(5) unsigned NOT NULL DEFAULT '0',
  `expl_statut` smallint(5) unsigned NOT NULL DEFAULT '0',
  `expl_location` smallint(5) unsigned NOT NULL DEFAULT '0',
  `expl_codestat` smallint(5) unsigned NOT NULL DEFAULT '0',
  `expl_date_depot` date NOT NULL DEFAULT '0000-00-00',
  `expl_date_retour` date NOT NULL DEFAULT '0000-00-00',
  `expl_note` 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',
  `transfert_section_origine` smallint(5) NOT NULL DEFAULT '0',
  `expl_ref_num` int(10) 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;

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


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

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

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


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

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

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


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

CREATE TABLE `expl_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `titre` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  `datatype` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` 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',
  `comment` blob NOT NULL,
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `expl_custom` VALUES (2,'origine','Origen','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[Seleccione un valor]]></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','Fecha de compra/Data de compra','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','Fecha de expiración/Data d\'expiració','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,'');
INSERT INTO `expl_custom` VALUES (5,'Convocatoria','Incluir ejemplar en la convocatoria para el curso:','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=\"0\"><![CDATA[]]></UNSELECT_ITEM>\r\n <DEFAULT_VALUE></DEFAULT_VALUE>\r\n <CHECKBOX_NB_ON_LINE></CHECKBOX_NB_ON_LINE>\r\n</OPTIONS>',0,0,3,0,0,0,100,0,'');



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

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

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

INSERT INTO `expl_custom_lists` VALUES (2,'DEP','Dépôt',3),(2,'DON','Don',2),(2,'ACH','Achat',1);
INSERT INTO `expl_custom_lists` VALUES (5,'2019','2019',1),(5,'2020','2020',2),(5,'2021','2021',3),(5,'2022','2022',4),(5,'2023','2023',5),(5,'2024','2024',6),(5,'2025','2025',7);


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

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

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


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

CREATE TABLE `explnum` (
  `explnum_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `explnum_notice` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `explnum_bulletin` int(8) unsigned NOT NULL DEFAULT '0',
  `explnum_nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `explnum_mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `explnum_url` 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,
  `explnum_docnum_statut` smallint(5) unsigned NOT NULL DEFAULT '1',
  `explnum_signature` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`explnum_id`),
  KEY `explnum_notice` (`explnum_notice`),
  KEY `explnum_bulletin` (`explnum_bulletin`),
  KEY `explnum_repertoire` (`explnum_repertoire`),
  KEY `i_explnum_nomfichier` (`explnum_nomfichier`(30)),
  FULLTEXT KEY `i_f_explnumwew` (`explnum_index_wew`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `explnum_custom`
--

CREATE TABLE `explnum_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',
  `comment` blob NOT NULL,
  PRIMARY KEY (`idchamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_custom`
--

INSERT INTO `explnum_custom` VALUES (1,0,'Convocatoria','Incluir ejemplar en la convocatoria para el curso:','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=\"0\"><![CDATA[]]></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,0,0,100,0,'');

--
-- Table structure for table `explnum_custom_lists`
--

CREATE TABLE `explnum_custom_lists` (
  `explnum_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_custom_list_value` varchar(255) DEFAULT NULL,
  `explnum_custom_list_lib` varchar(255) DEFAULT NULL,
  `ordre` int(11) DEFAULT NULL,
  KEY `explnum_custom_champ` (`explnum_custom_champ`),
  KEY `explnum_champ_list_value` (`explnum_custom_champ`,`explnum_custom_list_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_custom_lists`
--

INSERT INTO `explnum_custom_lists` VALUES (1,'2019','2019',1),(1,'2020','2020',2),(1,'2021','2021',3),(1,'2022','2022',4),(1,'2023','2023',5),(1,'2024','2024',6),(1,'2025','2025',7);

--
-- Table structure for table `explnum_custom_values`
--

CREATE TABLE `explnum_custom_values` (
  `explnum_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_custom_small_text` varchar(255) DEFAULT NULL,
  `explnum_custom_text` text,
  `explnum_custom_integer` int(11) DEFAULT NULL,
  `explnum_custom_date` date DEFAULT NULL,
  `explnum_custom_float` float DEFAULT NULL,
  `explnum_custom_order` int(11) NOT NULL DEFAULT '0',
  KEY `explnum_custom_champ` (`explnum_custom_champ`),
  KEY `i_encv_st` (`explnum_custom_small_text`),
  KEY `i_encv_t` (`explnum_custom_text`(255)),
  KEY `i_encv_i` (`explnum_custom_integer`),
  KEY `i_encv_d` (`explnum_custom_date`),
  KEY `i_encv_f` (`explnum_custom_float`),
  KEY `explnum_custom_origine` (`explnum_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_custom_values`
--


--
-- Table structure for table `explnum_doc`
--

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

--
-- Dumping data for table `explnum_doc`
--


--
-- Table structure for table `explnum_doc_actions`
--

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

--
-- Dumping data for table `explnum_doc_actions`
--


--
-- Table structure for table `explnum_doc_sugg`
--

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

--
-- Dumping data for table `explnum_doc_sugg`
--


--
-- Table structure for table `explnum_lenders`
--

CREATE TABLE `explnum_lenders` (
  `explnum_lender_num_explnum` int(11) NOT NULL DEFAULT '0',
  `explnum_lender_num_lender` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`explnum_lender_num_explnum`,`explnum_lender_num_lender`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_lenders`
--


--
-- Table structure for table `explnum_licence`
--

CREATE TABLE `explnum_licence` (
  `id_explnum_licence` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `explnum_licence_label` varchar(255) DEFAULT '',
  `explnum_licence_uri` varchar(255) DEFAULT '',
  PRIMARY KEY (`id_explnum_licence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_licence`
--


--
-- Table structure for table `explnum_licence_profile_explnums`
--

CREATE TABLE `explnum_licence_profile_explnums` (
  `explnum_licence_profile_explnums_explnum_num` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_licence_profile_explnums_profile_num` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`explnum_licence_profile_explnums_explnum_num`,`explnum_licence_profile_explnums_profile_num`),
  KEY `i_elpe_explnum_profile_num` (`explnum_licence_profile_explnums_profile_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_licence_profile_explnums`
--


--
-- Table structure for table `explnum_licence_profile_rights`
--

CREATE TABLE `explnum_licence_profile_rights` (
  `explnum_licence_profile_num` int(11) NOT NULL DEFAULT '0',
  `explnum_licence_right_num` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`explnum_licence_profile_num`,`explnum_licence_right_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_licence_profile_rights`
--


--
-- Table structure for table `explnum_licence_profiles`
--

CREATE TABLE `explnum_licence_profiles` (
  `id_explnum_licence_profile` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `explnum_licence_profile_explnum_licence_num` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_licence_profile_label` varchar(255) DEFAULT '',
  `explnum_licence_profile_uri` varchar(255) DEFAULT '',
  `explnum_licence_profile_logo_url` varchar(255) DEFAULT '',
  `explnum_licence_profile_explanation` text,
  `explnum_licence_profile_quotation_rights` text,
  PRIMARY KEY (`id_explnum_licence_profile`),
  KEY `i_elp_explnum_licence_num` (`explnum_licence_profile_explnum_licence_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_licence_profiles`
--


--
-- Table structure for table `explnum_licence_rights`
--

CREATE TABLE `explnum_licence_rights` (
  `id_explnum_licence_right` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `explnum_licence_right_explnum_licence_num` int(10) unsigned NOT NULL DEFAULT '0',
  `explnum_licence_right_label` varchar(255) DEFAULT '',
  `explnum_licence_right_type` int(2) DEFAULT '0',
  `explnum_licence_right_logo_url` varchar(255) DEFAULT '',
  `explnum_licence_right_explanation` text,
  PRIMARY KEY (`id_explnum_licence_right`),
  KEY `i_elr_explnum_licence_num` (`explnum_licence_right_explnum_licence_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_licence_rights`
--


--
-- Table structure for table `explnum_location`
--

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

--
-- Dumping data for table `explnum_location`
--


--
-- Table structure for table `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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `explnum_segments`
--


--
-- Table structure for table `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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `explnum_speaker_gender` varchar(1) COLLATE utf8_unicode_ci 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=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `explnum_speakers`
--


--
-- Table structure for table `explnum_statut`
--

CREATE TABLE `explnum_statut` (
  `id_explnum_statut` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `gestion_libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `opac_libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `class_html` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `explnum_visible_opac` tinyint(1) NOT NULL DEFAULT '1',
  `explnum_visible_opac_abon` tinyint(1) NOT NULL DEFAULT '0',
  `explnum_consult_opac` tinyint(1) NOT NULL DEFAULT '1',
  `explnum_consult_opac_abon` tinyint(1) NOT NULL DEFAULT '0',
  `explnum_download_opac` tinyint(1) NOT NULL DEFAULT '1',
  `explnum_download_opac_abon` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_explnum_statut`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `explnum_statut`
--

INSERT INTO `explnum_statut` VALUES (1,'Sans statut particulier','','',1,0,1,0,1,0);

--
-- Table structure for table `external_count`
--

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

--
-- Dumping data for table `external_count`
--


--
-- Table structure for table `facettes`
--

CREATE TABLE `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_gestion` tinyint(1) 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',
  `facette_opac_views_num` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_facette`),
  KEY `i_facette_visible` (`facette_visible`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `facettes`
--

INSERT INTO `facettes` VALUES (1,'Categorías',25,1,50,0,1,0,1,1,0,''),(2,'Localización',90,4,0,0,1,1,0,1,0,''),(3,'Palabra clave',17,1,50,0,1,0,1,1,0,''),(4,'Sección',90,3,0,0,1,1,0,1,0,''),(5,'Tipo de documento',31,1,0,0,0,1,0,1,0,''),(6,'Tipo de registro',32,1,0,0,1,1,0,1,0,'');

--
-- Table structure for table `facettes_external`
--

CREATE TABLE `facettes_external` (
  `id_facette` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `facette_name` varchar(255) 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_gestion` tinyint(1) 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',
  `facette_opac_views_num` text NOT NULL,
  PRIMARY KEY (`id_facette`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `facettes_external`
--


--
-- Table structure for table `faq_questions`
--

CREATE TABLE `faq_questions` (
  `id_faq_question` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `faq_question_num_type` int(10) unsigned NOT NULL DEFAULT '0',
  `faq_question_num_theme` int(10) unsigned NOT NULL DEFAULT '0',
  `faq_question_num_demande` int(10) unsigned NOT NULL DEFAULT '0',
  `faq_question_question` text COLLATE utf8_unicode_ci NOT NULL,
  `faq_question_question_userdate` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `faq_question_question_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `faq_question_answer` text COLLATE utf8_unicode_ci NOT NULL,
  `faq_question_answer_userdate` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `faq_question_answer_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `faq_question_statut` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_faq_question`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `faq_questions`
--


--
-- Table structure for table `faq_questions_categories`
--

CREATE TABLE `faq_questions_categories` (
  `num_faq_question` int(10) unsigned NOT NULL DEFAULT '0',
  `num_categ` int(10) unsigned NOT NULL DEFAULT '0',
  `categ_order` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `i_faq_categ` (`num_faq_question`,`num_categ`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `faq_questions_categories`
--


--
-- Table structure for table `faq_questions_fields_global_index`
--

CREATE TABLE `faq_questions_fields_global_index` (
  `id_faq_question` int(10) unsigned NOT NULL DEFAULT '0',
  `code_champ` int(3) unsigned NOT NULL DEFAULT '0',
  `code_ss_champ` int(3) unsigned NOT NULL DEFAULT '0',
  `ordre` int(4) unsigned NOT NULL DEFAULT '0',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `pond` int(4) unsigned 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_faq_question`,`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;

--
-- Dumping data for table `faq_questions_fields_global_index`
--


--
