-- Table structure for table `chat_groups`
--

CREATE TABLE `chat_groups` (
  `id_chat_group` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `chat_group_name` varchar(255) NOT NULL DEFAULT '',
  `chat_group_author_user_type` int(10) unsigned NOT NULL DEFAULT 0,
  `chat_group_author_user_num` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id_chat_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chat_groups`
--


--
-- Table structure for table `chat_messages`
--

CREATE TABLE `chat_messages` (
  `id_chat_message` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `chat_message_from_user_type` int(10) unsigned NOT NULL DEFAULT 0,
  `chat_message_from_user_num` int(10) unsigned NOT NULL DEFAULT 0,
  `chat_message_to_user_type` int(10) unsigned NOT NULL DEFAULT 0,
  `chat_message_to_user_num` int(10) unsigned NOT NULL DEFAULT 0,
  `chat_message_text` text NOT NULL,
  `chat_message_file` blob DEFAULT NULL,
  `chat_message_read` int(10) unsigned NOT NULL DEFAULT 0,
  `chat_message_date` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id_chat_message`),
  KEY `i_from_user_num` (`chat_message_from_user_num`,`chat_message_from_user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chat_messages`
--


--
-- Table structure for table `chat_users_groups`
--

CREATE TABLE `chat_users_groups` (
  `chat_user_group_num` int(10) unsigned NOT NULL DEFAULT 0,
  `chat_user_group_user_type` int(10) unsigned NOT NULL DEFAULT 0,
  `chat_user_group_user_num` int(10) unsigned NOT NULL DEFAULT 0,
  `chat_user_group_unread_messages_number` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`chat_user_group_num`,`chat_user_group_user_type`,`chat_user_group_user_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `chat_users_groups`
--


--
-- 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` int(10) unsigned NOT NULL DEFAULT 0,
  `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` datetime 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 DEFAULT NULL,
  `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,
  `filters` 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,
  `custom_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  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_dates`
--

CREATE TABLE `cms_editorial_custom_dates` (
  `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_date_type` int(11) DEFAULT NULL,
  `cms_editorial_custom_date_start` int(11) NOT NULL DEFAULT 0,
  `cms_editorial_custom_date_end` int(11) NOT NULL DEFAULT 0,
  `cms_editorial_custom_order` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`cms_editorial_custom_champ`,`cms_editorial_custom_origine`,`cms_editorial_custom_order`),
  KEY `cms_editorial_custom_champ` (`cms_editorial_custom_champ`),
  KEY `cms_editorial_custom_origine` (`cms_editorial_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cms_editorial_custom_dates`
--


--
-- 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` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
  `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`,`lang`),
  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 DEFAULT NULL,
  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` int(10) unsigned NOT NULL DEFAULT 0,
  `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` datetime 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 DEFAULT NULL,
  `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,
  `filters` 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,
  `custom_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `collection_custom_dates`
--

CREATE TABLE `collection_custom_dates` (
  `collection_custom_champ` int(10) unsigned NOT NULL DEFAULT 0,
  `collection_custom_origine` int(10) unsigned NOT NULL DEFAULT 0,
  `collection_custom_date_type` int(11) DEFAULT NULL,
  `collection_custom_date_start` int(11) NOT NULL DEFAULT 0,
  `collection_custom_date_end` int(11) NOT NULL DEFAULT 0,
  `collection_custom_order` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`collection_custom_champ`,`collection_custom_origine`,`collection_custom_order`),
  KEY `collection_custom_champ` (`collection_custom_champ`),
  KEY `collection_custom_origine` (`collection_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `collection_custom_dates`
--


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

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


--
-- Table structure for table `collstate_custom_dates`
--

CREATE TABLE `collstate_custom_dates` (
  `collstate_custom_champ` int(10) unsigned NOT NULL DEFAULT 0,
  `collstate_custom_origine` int(10) unsigned NOT NULL DEFAULT 0,
  `collstate_custom_date_type` int(11) DEFAULT NULL,
  `collstate_custom_date_start` int(11) NOT NULL DEFAULT 0,
  `collstate_custom_date_end` int(11) NOT NULL DEFAULT 0,
  `collstate_custom_order` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`collstate_custom_champ`,`collstate_custom_origine`,`collstate_custom_order`),
  KEY `collstate_custom_champ` (`collstate_custom_champ`),
  KEY `collstate_custom_origine` (`collstate_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `collstate_custom_dates`
--


--
-- 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 DEFAULT NULL,
  `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,
  `gestion_selected` int(1) 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 '',
  `object_message` text NOT NULL,
  `num_contact_form` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id_object`),
  KEY `i_num_contact_form` (`num_contact_form`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


--
-- Table structure for table `contact_forms`
--

CREATE TABLE `contact_forms` (
  `id_contact_form` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contact_form_label` varchar(255) NOT NULL DEFAULT '',
  `contact_form_desc` varchar(255) NOT NULL DEFAULT '',
  `contact_form_parameters` mediumtext NOT NULL,
  `contact_form_recipients` mediumtext NOT NULL,
  PRIMARY KEY (`id_contact_form`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contact_forms`
--

INSERT INTO `contact_forms` VALUES (1,'Formulaire de contact','','[]','[]');

--
-- 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,
  `area_opac_visibility` int(1) NOT NULL DEFAULT 1,
  `area_repo_template_authorities` varchar(255) NOT NULL DEFAULT '',
  `area_repo_template_records` varchar(255) NOT NULL DEFAULT '',
  `area_editing_entity` tinyint(4) NOT NULL DEFAULT 0,
  `area_logo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_area`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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


--
-- Table structure for table `contribution_area_clipboard`
--

CREATE TABLE `contribution_area_clipboard` (
  `id_clipboard` int(11) NOT NULL AUTO_INCREMENT,
  `datas` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id_clipboard`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contribution_area_clipboard`
--


--
-- Table structure for table `contribution_area_computed_fields`
--

CREATE TABLE `contribution_area_computed_fields` (
  `id_computed_fields` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `computed_fields_area_num` int(10) unsigned NOT NULL DEFAULT 0,
  `computed_fields_field_num` varchar(255) NOT NULL DEFAULT '',
  `computed_fields_template` text DEFAULT NULL,
  PRIMARY KEY (`id_computed_fields`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contribution_area_computed_fields`
--


--
-- Table structure for table `contribution_area_computed_fields_used`
--

CREATE TABLE `contribution_area_computed_fields_used` (
  `id_computed_fields_used` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `computed_fields_used_origine_field_num` int(10) unsigned NOT NULL DEFAULT 0,
  `computed_fields_used_label` text DEFAULT NULL,
  `computed_fields_used_num` varchar(255) NOT NULL DEFAULT '',
  `computed_fields_used_alias` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_computed_fields_used`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contribution_area_computed_fields_used`
--


--
-- 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,
  `form_comment` text 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 DEFAULT NULL,
  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 DEFAULT NULL,
  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 DEFAULT NULL,
  `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 DEFAULT NULL,
  `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,
  `filters` 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,
  `custom_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `demandes_custom_dates`
--

CREATE TABLE `demandes_custom_dates` (
  `demandes_custom_champ` int(10) unsigned NOT NULL DEFAULT 0,
  `demandes_custom_origine` int(10) unsigned NOT NULL DEFAULT 0,
  `demandes_custom_date_type` int(11) DEFAULT NULL,
  `demandes_custom_date_start` int(11) NOT NULL DEFAULT 0,
  `demandes_custom_date_end` int(11) NOT NULL DEFAULT 0,
  `demandes_custom_order` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`demandes_custom_champ`,`demandes_custom_origine`,`demandes_custom_order`),
  KEY `demandes_custom_champ` (`demandes_custom_champ`),
  KEY `demandes_custom_origine` (`demandes_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `demandes_custom_dates`
--


--
-- 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 DEFAULT NULL,
  `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,
  `section_libelle_opac` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `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_record_default_index_lang` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `watch_record_default_lang` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `watch_record_default_is_new` tinyint(1) 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 DEFAULT NULL,
  `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 DEFAULT NULL,
  `empr_pnb_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `empr_pnb_password_hint` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  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 DEFAULT NULL,
  `autorisations_all` int(1) NOT NULL DEFAULT 0,
  `empr_caddie_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `acces_rapide` int(11) NOT NULL DEFAULT 0,
  `favorite_color` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `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,'',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 DEFAULT NULL,
  `autorisations_all` int(1) NOT NULL DEFAULT 0,
  `parameters` text COLLATE utf8_unicode_ci DEFAULT NULL,
  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',0x75706461746520656D70722073657420656D70725F6C6F636174696F6E3D2721216E65775F6C6F636174696F6E2121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F63617465673D2721216E65775F63617465672121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F76696C6C653D2721216E65775F76696C6C652121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F63703D2721216E65775F63702121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F706179733D2721216E65775F706179732121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F7374617475743D2721216E6F75766561755F7374617475742121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F636F6465737461743D2721216E65775F636F6465737461742121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F70617373776F72643D2721216E65775F70617373776F72642121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F646174655F6164686573696F6E3D2721216E65775F646174655F6164686573696F6E2121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F646174655F65787069726174696F6E3D2721216E65775F646174655F65787069726174696F6E2121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F736578653D21216E65775F7365786521212077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F6D73673D2721216E65775F6D73672121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x73656C6563742069645F656D7072206173206F626A6563745F69642066726F6D20656D7072207768657265207472696D28656D70725F6D61696C293D2727,'',' 1 ',0,NULL),(18,'ACTION','Abonnement des lecteurs d\'un panier à une bannette publique (DSI)',0x696E7365727420696E746F2062616E6E657474655F61626F6E20286E756D5F62616E6E657474652C206E756D5F656D70722C206163746966292073656C65637420212162616E6E6574746521212C2069645F656D70722C20312066726F6D20656D70722077686572652069645F656D707220696E202843414444494528454D5052292920,'',' 1 ',0,'<?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)',0x64656C6574652066726F6D2062616E6E657474655F61626F6E207768657265206E756D5F62616E6E657474653D212162616E6E65747465212120616E64206E756D5F656D70723D69645F656D707220616E642061637469663D312077686572652069645F656D707220696E202843414444494528454D5052292920,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420656D70725F70726F663D2721216E65775F70726F662121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',0x75706461746520656D70722073657420747970655F6162743D2721216E65775F747970655F6162742121272077686572652069645F656D707220696E202843414444494528454D50522929,'',' 1 ',0,'<?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',3650,0.00,0,0),(2,'Jubilados',3650,0.00,0,0),(3,'Empleados',3650,0.00,0,0),(4,'Sin empleo',3650,0.00,0,0),(5,'Alumnos de secundaria/Estudiantes',3650,0.00,0,0),(6,'Colegiales',3650,0.00,0,0),(7,'Adultos',3650,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 DEFAULT NULL,
  `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,
  `filters` 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,
  `custom_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


--
-- Table structure for table `empr_custom_dates`
--

CREATE TABLE `empr_custom_dates` (
  `empr_custom_champ` int(10) unsigned NOT NULL DEFAULT 0,
  `empr_custom_origine` int(10) unsigned NOT NULL DEFAULT 0,
  `empr_custom_date_type` int(11) DEFAULT NULL,
  `empr_custom_date_start` int(11) NOT NULL DEFAULT 0,
  `empr_custom_date_end` int(11) NOT NULL DEFAULT 0,
  `empr_custom_order` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`empr_custom_champ`,`empr_custom_origine`,`empr_custom_order`),
  KEY `empr_custom_champ` (`empr_custom_champ`),
  KEY `empr_custom_origine` (`empr_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `empr_custom_dates`
--


--
-- 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 DEFAULT NULL,
  `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_devices`
--

CREATE TABLE `empr_devices` (
  `empr_num` int(10) unsigned NOT NULL DEFAULT 0,
  `device_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`empr_num`,`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `empr_devices`
--


--
-- 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 DEFAULT NULL,
  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_renewal_form_fields`
--

CREATE TABLE `empr_renewal_form_fields` (
  `empr_renewal_form_field_code` varchar(255) NOT NULL,
  `empr_renewal_form_field_display` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `empr_renewal_form_field_mandatory` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `empr_renewal_form_field_alterable` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `empr_renewal_form_field_explanation` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`empr_renewal_form_field_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `empr_renewal_form_fields`
--


--
-- 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,
  `allow_pnb` tinyint(4) 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,0),(2,'Interdit',0,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 DEFAULT NULL,
  `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 DEFAULT NULL
) 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(255) 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 DEFAULT NULL,
  `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',0x4578706F736974696F6E207669727475656C6C6520737572206C61204C6F697265,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,
  `etagere_caddie_filters` mediumtext COLLATE utf8_unicode_ci DEFAULT NULL,
  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,NULL);

--
-- 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 DEFAULT NULL,
  `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,
  `expl_pnb_flag` int(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`expl_id`),
  UNIQUE KEY `expl_cb` (`expl_cb`),
  KEY `expl_typdoc` (`expl_typdoc`),
  KEY `expl_cote` (`expl_cote`),
  KEY `expl_notice` (`expl_notice`),
  KEY `expl_codestat` (`expl_codestat`),
  KEY `expl_owner` (`expl_owner`),
  KEY `expl_bulletin` (`expl_bulletin`),
  KEY `i_expl_location` (`expl_location`),
  KEY `i_expl_section` (`expl_section`),
  KEY `i_expl_statut` (`expl_statut`),
  KEY `i_expl_lastempr` (`expl_lastempr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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 DEFAULT NULL,
  `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,
  `filters` 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,
  `custom_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM AUTO_INCREMENT=6 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,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,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,0,100,0,'',''),(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,0,100,0,'','');

--
-- Table structure for table `expl_custom_dates`
--

CREATE TABLE `expl_custom_dates` (
  `expl_custom_champ` int(10) unsigned NOT NULL DEFAULT 0,
  `expl_custom_origine` int(10) unsigned NOT NULL DEFAULT 0,
  `expl_custom_date_type` int(11) DEFAULT NULL,
  `expl_custom_date_start` int(11) NOT NULL DEFAULT 0,
  `expl_custom_date_end` int(11) NOT NULL DEFAULT 0,
  `expl_custom_order` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`expl_custom_champ`,`expl_custom_origine`,`expl_custom_order`),
  KEY `expl_custom_champ` (`expl_custom_champ`),
  KEY `expl_custom_origine` (`expl_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `expl_custom_dates`
--


--
-- 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),(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 DEFAULT NULL,
  `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 DEFAULT NULL,
  `explnum_vignette` mediumblob DEFAULT NULL,
  `explnum_extfichier` varchar(20) COLLATE utf8_unicode_ci DEFAULT '',
  `explnum_nomfichier` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `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 '',
  `explnum_create_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `explnum_update_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `explnum_file_size` int(11) NOT NULL DEFAULT 0,
  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)),
  KEY `i_e_explnum_signature` (`explnum_signature`),
  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 DEFAULT NULL,
  `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,
  `filters` 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,
  `custom_classement` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`idchamp`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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,0,100,0,'','');

--
-- Table structure for table `explnum_custom_dates`
--

CREATE TABLE `explnum_custom_dates` (
  `explnum_custom_champ` int(10) unsigned NOT NULL DEFAULT 0,
  `explnum_custom_origine` int(10) unsigned NOT NULL DEFAULT 0,
  `explnum_custom_date_type` int(11) DEFAULT NULL,
  `explnum_custom_date_start` int(11) NOT NULL DEFAULT 0,
  `explnum_custom_date_end` int(11) NOT NULL DEFAULT 0,
  `explnum_custom_order` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`explnum_custom_champ`,`explnum_custom_origine`,`explnum_custom_order`),
  KEY `explnum_custom_champ` (`explnum_custom_champ`),
  KEY `explnum_custom_origine` (`explnum_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `explnum_custom_dates`
--


--
-- 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 DEFAULT NULL,
  `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 DEFAULT NULL,
  `explnum_licence_profile_quotation_rights` text DEFAULT NULL,
  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 DEFAULT NULL,
  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,
  `explnum_thumbnail_visible_opac_override` tinyint(1) unsigned 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,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_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'notices',
  `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_datatype_sort` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'alpha',
  `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,'notices','Categorías',25,1,50,0,1,0,1,'alpha',1,0,''),(2,'notices','Localización',90,4,0,0,1,1,0,'alpha',1,0,''),(3,'notices','Palabra clave',17,1,50,0,1,0,1,'alpha',1,0,''),(4,'notices','Sección',90,3,0,0,1,1,0,'alpha',1,0,''),(5,'notices','Tipo de documento',31,1,0,0,0,1,0,'alpha',1,0,''),(6,'notices','Tipo de registro',32,1,0,0,1,1,0,'alpha',1,0,'');

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

CREATE TABLE `facettes_external` (
  `id_facette` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `facette_type` varchar(255) NOT NULL DEFAULT 'notices',
  `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_datatype_sort` varchar(255) NOT NULL DEFAULT 'alpha',
  `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`
--


--
-- Table structure for table `faq_questions_words_global_index`
--

CREATE TABLE `faq_questions_words_global_index` (
  `id_faq_question` int(10) 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_faq_question`,`code_champ`,`code_ss_champ`,`num_word`,`position`,`field_position`),
  KEY `code_champ` (`code_champ`),
  KEY `i_id_mot` (`num_word`,`id_faq_question`),
  KEY `i_code_champ_code_ss_champ_num_word` (`code_champ`,`code_ss_champ`,`num_word`),
  KEY `i_num_word` (`num_word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `faq_questions_words_global_index`
--


--
-- Table structure for table `faq_themes`
--

CREATE TABLE `faq_themes` (
  `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 `faq_themes`
--


--
-- Table structure for table `faq_types`
--

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

--
-- Dumping data for table `faq_types`
--


--
-- Table structure for table `fiche`
--

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

--
-- Dumping data for table `fiche`
--


--
-- Table structure for table `frais`
--

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

--
-- Dumping data for table `frais`
--


--
-- Table structure for table `frbr_cadres`
--

CREATE TABLE `frbr_cadres` (
  `id_cadre` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cadre_name` varchar(255) NOT NULL DEFAULT '',
  `cadre_comment` text NOT NULL,
  `cadre_object` varchar(255) NOT NULL DEFAULT '',
  `cadre_css_class` varchar(255) NOT NULL DEFAULT '',
  `cadre_num_datanode` int(10) unsigned NOT NULL DEFAULT 0,
  `cadre_num_page` int(10) unsigned NOT NULL DEFAULT 0,
  `cadre_visible_in_graph` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `cadre_datanodes_path` varchar(255) DEFAULT NULL,
  `cadre_display_empty_template` tinyint(1) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id_cadre`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_cadres`
--


--
-- Table structure for table `frbr_cadres_content`
--

CREATE TABLE `frbr_cadres_content` (
  `id_cadre_content` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cadre_content_type` varchar(255) NOT NULL DEFAULT '',
  `cadre_content_object` varchar(255) NOT NULL DEFAULT '',
  `cadre_content_num_cadre` int(10) unsigned NOT NULL DEFAULT 0,
  `cadre_content_data` text NOT NULL,
  PRIMARY KEY (`id_cadre_content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_cadres_content`
--


--
-- Table structure for table `frbr_cataloging_categories`
--

CREATE TABLE `frbr_cataloging_categories` (
  `id_cataloging_category` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cataloging_category_title` varchar(255) NOT NULL DEFAULT '',
  `cataloging_category_num_parent` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id_cataloging_category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_cataloging_categories`
--


--
-- Table structure for table `frbr_cataloging_datanodes`
--

CREATE TABLE `frbr_cataloging_datanodes` (
  `id_cataloging_datanode` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cataloging_datanode_title` varchar(255) NOT NULL DEFAULT '',
  `cataloging_datanode_comment` text NOT NULL,
  `cataloging_datanode_owner` int(10) unsigned NOT NULL DEFAULT 0,
  `cataloging_datanode_allowed_users` varchar(255) NOT NULL DEFAULT '',
  `cataloging_datanode_num_category` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id_cataloging_datanode`),
  KEY `i_cataloging_datanode_title` (`cataloging_datanode_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_cataloging_datanodes`
--


--
-- Table structure for table `frbr_cataloging_items`
--

CREATE TABLE `frbr_cataloging_items` (
  `num_cataloging_item` int(10) unsigned NOT NULL,
  `type_cataloging_item` varchar(255) NOT NULL DEFAULT '',
  `cataloging_item_num_user` int(10) unsigned NOT NULL DEFAULT 0,
  `cataloging_item_added_date` datetime DEFAULT NULL,
  `cataloging_item_num_datanode` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`num_cataloging_item`,`type_cataloging_item`,`cataloging_item_num_datanode`),
  KEY `i_cataloging_item_num_datanode` (`cataloging_item_num_datanode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_cataloging_items`
--


--
-- Table structure for table `frbr_datanodes`
--

CREATE TABLE `frbr_datanodes` (
  `id_datanode` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `datanode_name` varchar(255) NOT NULL DEFAULT '',
  `datanode_comment` text NOT NULL,
  `datanode_object` varchar(255) NOT NULL DEFAULT '',
  `datanode_num_page` int(10) unsigned NOT NULL DEFAULT 0,
  `datanode_num_parent` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id_datanode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_datanodes`
--


--
-- Table structure for table `frbr_datanodes_content`
--

CREATE TABLE `frbr_datanodes_content` (
  `id_datanode_content` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `datanode_content_type` varchar(255) NOT NULL DEFAULT '',
  `datanode_content_object` varchar(255) NOT NULL DEFAULT '',
  `datanode_content_num_datanode` int(10) unsigned NOT NULL DEFAULT 0,
  `datanode_content_data` text NOT NULL,
  PRIMARY KEY (`id_datanode_content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_datanodes_content`
--


--
-- Table structure for table `frbr_managed_entities`
--

CREATE TABLE `frbr_managed_entities` (
  `managed_entity_name` varchar(255) NOT NULL DEFAULT '',
  `managed_entity_box` text NOT NULL,
  PRIMARY KEY (`managed_entity_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_managed_entities`
--


--
-- Table structure for table `frbr_pages`
--

CREATE TABLE `frbr_pages` (
  `id_page` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `page_name` varchar(255) NOT NULL DEFAULT '',
  `page_comment` text NOT NULL,
  `page_entity` varchar(255) NOT NULL DEFAULT '',
  `page_parameters` text NOT NULL,
  `page_opac_views` varchar(255) NOT NULL DEFAULT '',
  `page_order` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id_page`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_pages`
--


--
-- Table structure for table `frbr_pages_content`
--

CREATE TABLE `frbr_pages_content` (
  `id_page_content` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `page_content_type` varchar(255) NOT NULL DEFAULT '',
  `page_content_object` varchar(255) NOT NULL DEFAULT '',
  `page_content_num_page` int(10) unsigned NOT NULL DEFAULT 0,
  `page_content_data` text NOT NULL,
  PRIMARY KEY (`id_page_content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_pages_content`
--


--
-- Table structure for table `frbr_place`
--

CREATE TABLE `frbr_place` (
  `place_num_page` int(10) unsigned NOT NULL DEFAULT 0,
  `place_num_cadre` int(10) unsigned NOT NULL DEFAULT 0,
  `place_cadre_type` varchar(255) NOT NULL DEFAULT '',
  `place_visibility` int(1) NOT NULL DEFAULT 0,
  `place_order` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`place_num_page`,`place_num_cadre`,`place_cadre_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `frbr_place`
--


--
-- Table structure for table `gestfic0_custom`
--

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

--
-- Dumping data for table `gestfic0_custom`
--


--
-- Table structure for table `gestfic0_custom_lists`
--

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

--
-- Dumping data for table `gestfic0_custom_lists`
--


--
-- Table structure for table `gestfic0_custom_values`
--

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

--
-- Dumping data for table `gestfic0_custom_values`
--


--
-- Table structure for table `grids_generic`
--

CREATE TABLE `grids_generic` (
  `grid_generic_type` varchar(32) NOT NULL DEFAULT '',
  `grid_generic_filter` varchar(255) NOT NULL DEFAULT '',
  `grid_generic_data` mediumblob NOT NULL,
  PRIMARY KEY (`grid_generic_type`,`grid_generic_filter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `grids_generic`
--

INSERT INTO `grids_generic` VALUES ('auteurs','70',0x5B7B226E6F64654964223A22656C30222C226C6162656C223A225A6F6E65207061722064753030653966617574222C226973457870616E6461626C65223A66616C73652C2273686F774C6162656C223A66616C73652C2276697369626C65223A747275652C22656C656D656E7473223A5B7B226E6F64654964223A22656C304368696C645F30222C2276697369626C65223A747275652C22636C6173734E616D65223A22726F77227D2C7B226E6F64654964223A22656C304368696C645F315F61222C2276697369626C65223A747275652C22636C6173734E616D65223A22636F6C6F6E6E6532227D2C7B226E6F64654964223A22656C304368696C645F315F62222C2276697369626C65223A747275652C22636C6173734E616D65223A22636F6C6F6E6E655F7375697465227D2C7B226E6F64654964223A22656C304368696C645F32222C2276697369626C65223A747275652C22636C6173734E616D65223A22726F77227D2C7B226E6F64654964223A22656C304368696C645F33222C2276697369626C65223A66616C73652C22636C6173734E616D65223A22726F77227D2C7B226E6F64654964223A22656C304368696C645F345F61222C2276697369626C65223A66616C73652C22636C6173734E616D65223A22636F6C6F6E6E6532227D2C7B226E6F64654964223A22656C304368696C645F345F62222C2276697369626C65223A66616C73652C22636C6173734E616D65223A22636F6C6F6E6E655F7375697465227D2C7B226E6F64654964223A22656C304368696C645F355F61222C2276697369626C65223A66616C73652C22636C6173734E616D65223A22636F6C6F6E6E6532227D2C7B226E6F64654964223A22656C304368696C645F355F62222C2276697369626C65223A66616C73652C22636C6173734E616D65223A22636F6C6F6E6E655F7375697465227D2C7B226E6F64654964223A22656C304368696C645F36222C2276697369626C65223A747275652C22636C6173734E616D65223A22726F77227D2C7B226E6F64654964223A22656C304368696C645F37222C2276697369626C65223A747275652C22636C6173734E616D65223A22726F77227D2C7B226E6F64654964223A22656C304368696C645F38222C2276697369626C65223A747275652C22636C6173734E616D65223A22726F77227D2C7B226E6F64654964223A22656C364368696C645F33222C2276697369626C65223A747275652C22636C6173734E616D65223A22726F77227D2C7B226E6F64654964223A22656C304368696C645F39222C2276697369626C65223A747275652C22636C6173734E616D65223A22726F77227D2C7B226E6F64654964223A22656C374368696C645F30222C2276697369626C65223A747275652C22636C6173734E616D65223A22726F77227D5D7D5D);

--
-- Table structure for table `grilles`
--

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

--
-- Dumping data for table `grilles`
--


--
-- Table structure for table `groupe`
--

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

--
-- Dumping data for table `groupe`
--


--
-- Table structure for table `groupexpl`
--

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

--
-- Dumping data for table `groupexpl`
--


--
-- Table structure for table `groupexpl_expl`
--

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

--
-- Dumping data for table `groupexpl_expl`
--


--
-- Table structure for table `harvest_field`
--

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

--
-- Dumping data for table `harvest_field`
--


--
-- Table structure for table `harvest_profil`
--

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

--
-- Dumping data for table `harvest_profil`
--


--
-- Table structure for table `harvest_profil_import`
--

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

--
-- Dumping data for table `harvest_profil_import`
--


--
-- Table structure for table `harvest_profil_import_field`
--

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

--
-- Dumping data for table `harvest_profil_import_field`
--


--
-- Table structure for table `harvest_search_field`
--

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

--
-- Dumping data for table `harvest_search_field`
--


--
-- Table structure for table `harvest_src`
--

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

--
-- Dumping data for table `harvest_src`
--


--
-- Table structure for table `import_marc`
--

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

--
-- Dumping data for table `import_marc`
--


--
-- Table structure for table `index_concept`
--

CREATE TABLE `index_concept` (
  `num_object` int(10) unsigned NOT NULL,
  `type_object` int(10) unsigned NOT NULL,
  `num_concept` int(10) unsigned NOT NULL,
  `order_concept` int(10) unsigned NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `comment_visible_opac` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`num_object`,`type_object`,`num_concept`),
  KEY `i_num_concept_type_object` (`num_concept`,`type_object`),
  KEY `i_type_object_num_object` (`type_object`,`num_object`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `index_concept`
--


--
-- Table structure for table `indexation_stack`
--

CREATE TABLE `indexation_stack` (
  `indexation_stack_entity_id` int(8) unsigned NOT NULL DEFAULT 0,
  `indexation_stack_entity_type` int(3) unsigned NOT NULL DEFAULT 0,
  `indexation_stack_datatype` varchar(255) NOT NULL DEFAULT '',
  `indexation_stack_timestamp` bigint(20) NOT NULL DEFAULT 0,
  `indexation_stack_parent_id` int(8) unsigned NOT NULL DEFAULT 0,
  `indexation_stack_parent_type` int(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`indexation_stack_entity_id`,`indexation_stack_entity_type`,`indexation_stack_datatype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `indexation_stack`
--


--
-- Table structure for table `indexint`
--

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

--
-- Dumping data for table `indexint`
--


--
-- Table structure for table `indexint_custom`
--

CREATE TABLE `indexint_custom` (
  `idchamp` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `num_type` int(10) unsigned NOT NULL DEFAULT 0,
  `name` varchar(255) 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 DEFAULT NULL,
  `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,
  `filters` 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,
  `custom_classement` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`idchamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `indexint_custom`
--


--
-- Table structure for table `indexint_custom_dates`
--

CREATE TABLE `indexint_custom_dates` (
  `indexint_custom_champ` int(10) unsigned NOT NULL DEFAULT 0,
  `indexint_custom_origine` int(10) unsigned NOT NULL DEFAULT 0,
  `indexint_custom_date_type` int(11) DEFAULT NULL,
  `indexint_custom_date_start` int(11) NOT NULL DEFAULT 0,
  `indexint_custom_date_end` int(11) NOT NULL DEFAULT 0,
  `indexint_custom_order` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`indexint_custom_champ`,`indexint_custom_origine`,`indexint_custom_order`),
  KEY `indexint_custom_champ` (`indexint_custom_champ`),
  KEY `indexint_custom_origine` (`indexint_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `indexint_custom_dates`
--


--
-- Table structure for table `indexint_custom_lists`
--

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

--
-- Dumping data for table `indexint_custom_lists`
--


--
-- Table structure for table `indexint_custom_values`
--

CREATE TABLE `indexint_custom_values` (
  `indexint_custom_champ` int(10) unsigned NOT NULL DEFAULT 0,
  `indexint_custom_origine` int(10) unsigned NOT NULL DEFAULT 0,
  `indexint_custom_small_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `indexint_custom_text` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `indexint_custom_integer` int(11) DEFAULT NULL,
  `indexint_custom_date` date DEFAULT NULL,
  `indexint_custom_float` float DEFAULT NULL,
  `indexint_custom_order` int(11) NOT NULL DEFAULT 0,
  KEY `editorial_custom_champ` (`indexint_custom_champ`),
  KEY `editorial_custom_origine` (`indexint_custom_origine`),
  KEY `i_icv_st` (`indexint_custom_small_text`),
  KEY `i_icv_t` (`indexint_custom_text`(255)),
  KEY `i_icv_i` (`indexint_custom_integer`),
  KEY `i_icv_d` (`indexint_custom_date`),
  KEY `i_icv_f` (`indexint_custom_float`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `indexint_custom_values`
--


--
-- Table structure for table `infopages`
--

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

--
-- Dumping data for table `infopages`
--

INSERT INTO `infopages` VALUES (1,0x[encoded data, 4804 characters],'Actu rencontres',1,0,''),(2,0x[encoded data, 5282 characters],'PMB Version 4.0',1,0,''),(6,0x3C7461626C653E0D0A3C74723E0D0A3C7464202077696474683D22353230223E0D0A3C696672616D652077696474683D2235303022206865696768743D2234353022206672616D65626F726465723D223022207363726F6C6C696E673D226E6F22206D617267696E6865696768743D223022206D617267696E77696474683D223022207372633D2268747470733A2F2F6D6170732E676F6F676C652E66722F6D6170733F713D706D622B736572766963657326616D703B6F653D7574662D3826616D703B61713D7426616D703B636C69656E743D66697265666F782D6126616D703B69653D5554463826616D703B686C3D667226616D703B68713D706D622B736572766963657326616D703B686E6561723D4368254333254132746561752D64752D4C6F69722C2B5361727468652C2B506179732B64652B6C612B4C6F69726526616D703B6C6C3D34372E3638343033332C302E34323830343826616D703B73706E3D302E3031383939372C302E30323139353626616D703B743D6D26616D703B6F75747075743D656D626564223E3C2F696672616D653E3C6272202F3E3C736D616C6C3E3C6120687265663D2268747470733A2F2F6D6170732E676F6F676C652E66722F6D6170733F713D706D622B736572766963657326616D703B6F653D7574662D3826616D703B61713D7426616D703B636C69656E743D66697265666F782D6126616D703B69653D5554463826616D703B686C3D667226616D703B68713D706D622B736572766963657326616D703B686E6561723D4368254333254132746561752D64752D4C6F69722C2B5361727468652C2B506179732B64652B6C612B4C6F69726526616D703B6C6C3D34372E3638343033332C302E34323830343826616D703B73706E3D302E3031383939372C302E30323139353626616D703B743D6D26616D703B736F757263653D656D62656422207374796C653D22636F6C6F723A233030303046463B746578742D616C69676E3A6C656674223E416772616E646972206C6520706C616E3C2F613E3C2F736D616C6C3E0D0A3C2F74643E0D0A3C7464207374796C653D22666F6E742D73697A653A20313570783B223E0D0A504D422053657276696365733C6272202F3E0D0A5A41206465204D6F6E7420737572204C6F69723C6272202F3E0D0A4250203130203032333C6272202F3E0D0A373220353030204368C3A274656175206475204C6F69723C6272202F3E0D0A3C6272202F3E0D0A3C623E54C3A96C203A202B3333202830293220343320343430203636303C2F623E3C6272202F3E0D0A3C6272202F3E0D0A3C623E4D61696C203A20706D6240736967622E6E65743C2F623E3C6272202F3E0D0A3C6272202F3E0D0A7777772E736967622E6E65740D0A3C2F74643E0D0A3C2F74723E0D0A3C2F7461626C653E,'Nous trouver',1,0,''),(7,0x[encoded data, 16176 characters],'Mentions légales',1,0,''),(3,0x[encoded data, 4952 characters],'Aide en ligne',1,0,''),(4,0x3C68333E43616C656E646F632C206C276167656E646120636F6C6C61626F7261746966206465732070726F73206465206C27696E666F2D646F633C2F68333E0D0A0D0A3C696672616D65207372633D22687474703A2F2F7777772E676F6F676C652E636F6D2F63616C656E6461722F656D6265643F63747A3D4575726F70652F506172697322207374796C653D22626F726465723A2030222077696474683D2238303022206865696768743D2236303022206672616D65626F726465723D223022207363726F6C6C696E673D226E6F223E3C2F696672616D653E0D0A3C6272202F3E0D0A3C6120687265663D22687474703A2F2F6C616269626170707269766F697365652E776F726470726573732E636F6D2F323030392F30312F32372F63616C656E646F632D6C6167656E64612D636F6C6C61626F72617469662D6465732D70726F732D64652D6C696E666F2D646F632F22207461726765743D225F626C616E6B223E706C7573206427696E666F73207375722043616C656E646F633C2F613E,'Consulter Calendoc',1,0,''),(5,0x3C703E3C623E4173747563653C2F623E207574696C6973657A20646573206775696C6C656D65747320706F757220636865726368657220756E6520737569746520646520636172616374266567726176653B726573203A202671756F743B72266561637574653B766F6C7574696F6E206672616E2663636564696C3B616973652671756F743B3C2F703E,'aide sous la recherche simple',1,0,'');

--
