INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (866,'gestion_acces','empr_docnum','0','Gestion des droits d\'accès des emprunteurs aux documents numériques\n0 : Non.\n1 : Oui.','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (867,'gestion_acces','empr_docnum_def','0','Valeur par défaut en modification de document numérique pour les droits d\'accès emprunteurs - documents numériques\n0 : Recalculer.\n1 : Choisir.','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (868,'pmb','map_activate','0','Activation du géoréférencement','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (869,'pmb','map_max_holds','250,0','Dans l\'ordre donné séparé par une virgule: Nombre limite d\'emprises affichées, mode de clustering \nValeurs possibles pour le mode :\n\n0 => Clustering standard avec augmentation dynamique des seuils jusqu\'a atteindre le nombre maximum d\'emprises affichées\n\n1 => Clusterisation de toutes les emprises','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (881,'opac','map_holds_record_color','#D6A40F','Couleur des emprises associées à des notices','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (870,'pmb','map_holds_record_color','#D6A40F','Couleur des emprises associées à des notices','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (871,'pmb','map_holds_authority_color','#D60F0F','Couleur des emprises associées à des autorités','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (872,'pmb','map_base_layer_type','OSM','Fonds de carte à utiliser.\nValeurs possibles :\nOSM           => Open Street Map\nWMS           => The Web Map Server base layer type selector.\nGOOGLE        => Google\nARCGIS        =>The ESRI ARCGis base layer selector.\n','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (873,'pmb','map_base_layer_params','','Structure JSON à passer au fond de carte\nexemple :\n{\n \"name\": \"Nom du fond de carte\",\n \"url\": \"url du fond de carte\",\n \"options\":{\n  \"layers\": \"MONDE_MOD1\"\n }\n}','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (874,'pmb','map_size_search_edition','800*480','Taille de la carte en saisie de recherche','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (875,'pmb','map_size_search_result','800*480','Taille de la carte en résultat de recherche','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (876,'pmb','map_size_notice_view','800*480','Taille de la carte en visualisation de notice','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (877,'pmb','map_size_notice_edition','800*480','Taille de la carte en édition de notice','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (878,'opac','map_activate','0','Activation du géoréférencement','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (879,'pmb','editorial_dojo_editor','1','Activation de l\'éditeur DoJo dans le contenu éditorial:\n 0 : non \n 1 : oui','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (880,'opac','map_max_holds','250,0','Dans l\'ordre donné séparé par une virgule: Nombre limite d\'emprises affichées, mode de clustering \nValeurs possibles pour le mode :\n\n0 => Clustering standard avec augmentation dynamique des seuils jusqu\'a atteindre le nombre maximum d\'emprises affichées\n\n1 => Clusterisation de toutes les emprises','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (882,'opac','map_holds_authority_color','#D60F0F','Couleur des emprises associées à des autorités','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (883,'opac','map_size_search_edition','800*480','Taille de la carte en saisie de recherche','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (884,'opac','map_size_search_result','800*480','Taille de la carte en résultat de recherche','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (885,'opac','map_size_notice_view','800*480','Taille de la carte en visualisation de notice','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (886,'opac','map_base_layer_type','OSM','Fonds de carte à utiliser.\nValeurs possibles :\nOSM           => Open Street Map\nWMS           => The Web Map Server base layer type selector.\nGOOGLE        => Google\nARCGIS        =>The ESRI ARCGis base layer selector.\n','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (887,'opac','map_base_layer_params','','Structure JSON à passer au fond de carte\nexemple :\n{\n \"name\": \"Nom du fond de carte\",\n \"url\": \"url du fond de carte\",\n \"options\":{\n  \"layers\": \"MONDE_MOD1\"\n }\n}','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (888,'pmb','nomenclature_record_children_link','','Type de relation entre une notice de nomenclature et ses notices filles.','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (889,'pmb','nomenclature_activate','0','Activation des nomenclatures:\n 0 : non \n 1 : oui','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (890,'demandes','email_generic','','Information par un email générique de l\'évolution des demandes.\n 1,adrmail@mail.fr : Envoi une copie uniquement pour toutes les nouvelles demandes\n 2,adrmail@mail.fr : Envoi une copie uniquement des mails envoyés aux personnes affectées\n 3,adrmail@mail.fr : Envoi une copie dans les 2 cas précédents\n ','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (891,'opac','demandes_affichage_simplifie','0','Active le format simplifié des demandes en Opac:\n 0 : non \n 1 : oui','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (892,'opac','demandes_no_action','0','Interdire l\'ajout d\'une action en Opac:\n 0 : non \n 1 : oui','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (893,'pmb','map_hold_ratio_min','4','Ratio minimum d\'occupation en pourcentage d\'une emprise pour s\'afficher','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (894,'pmb','map_hold_ratio_max','75','Ratio maximum d\'occupation en pourcentage d\'une emprise pour s\'afficher','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (895,'pmb','map_hold_distance','10','Rapport de distance entre deux points pour les agréger','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (896,'opac','modules_search_concept','0','Recherche dans les concepts : \n 0 : interdite, \n 1 : autorisée, \n 2 : autorisée et validée par défaut','c_recherche',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (897,'opac','map_hold_ratio_min','4','Ratio minimum d\'occupation en pourcentage d\'une emprise pour s\'afficher','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (898,'opac','map_hold_ratio_max','75','Ratio maximum d\'occupation en pourcentage d\'une emprise pour s\'afficher','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (899,'opac','map_hold_distance','10','Rapport de distance entre deux points pour les agréger','map',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (900,'opac','script_analytics','','Code Javascript d\'analyse d\'audience (Par exemple pour Google Analytics, XiTi,..).','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (901,'opac','accessibility','1','Accessibilité activée.\n 0 : Non.\n 1 : Oui.','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (902,'pmb','newrecord_timeshift','0','Nombre de jours de conservation des notices en tant que nouveauté.','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (903,'opac','notices_format_django_directory','','Nom du répertoire de templates django à utiliser en affichage de notice.\nLaisser vide pour utiliser le common.','e_aff_notice',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (904,'opac','allow_download_docnums','1','Autoriser le téléchargement des documents numériques.\n 0 : Non.\n 1 : Individuellement (un par un).\n 2 : Archive ZIP.','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (905,'opac','notices_display_modes','','Nom du fichier xml de paramétrage du choix du mode d\'affichage des notices à l\'OPAC.\nPar défaut : display_modes_exemple.xml dans /opac_css/includes/records/','d_aff_recherche',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (906,'opac','url_more_about_cookies','','Lien pour en savoir plus sur l\'utilisation des cookies et des traceurs','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (907,'opac','authorities_templates_folder','./includes/templates/authorities/common','Repertoire des templates utilisés pour l\'affichage des autorités en OPAC','',1);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (908,'dsi','private_bannette_notices_template','0','Id du template de notice utilisé par défaut en diffusion de bannettes privées. Si vide ou à 0, le template classique est utilisé.','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (909,'cms','active_image_cache','1','Activer la mise en cache des vignettes du contenu éditorial.\r\n 0: non \r\n 1:Oui \r\nAttention, si l\'OPAC ne se trouve pas sur le même serveur que la gestion, la purge du cache ne peut pas se faire automatiquement','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (910,'opac','empr_password_salt','05718e96fefeb25b595a3d310dc5bedf','Phrase pour le hashage des mots de passe emprunteurs','a_general',1);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (911,'pmb','notices_show_dates','0','Afficher les dates des notices ? \n 0 : Aucune date.\n 1 : Date de création et modification.','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (912,'opac','compress_css','0','Activer la compilation et la compression des feuilles de styles.\n0: Non\n1: Oui','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (913,'pmb','resa_planning_toresa','10','Délai d\'alerte pour le transfert des prévisions en réservations (en jours). ','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (914,'pmb','serialcirc_simple_print_script','','Script de construction d\'étiquette de circulation simplifiée de périodique','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (915,'opac','max_results_on_a_page','500','Nombre maximum de notices à afficher sur une page, utile notamment quand la navigation est désactivée','d_aff_recherche',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (916,'pmb','mail_adresse_from','','Adresse d\'expédition des emails. Ce paramètre permet de forcer le From des mails envoyés par PMB. Le reply-to reste inchangé (mail de l\'utilisateur en DSI ou relance, mail de la localisation ou paramètre opac_biblio_mail à défaut).\nFormat : adresse_email;libellé\nExemple : pmb@sigb.net;PMB Services','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (917,'opac','mail_adresse_from','','Adresse d\'expédition des emails. Ce paramètre permet de forcer le From des mails envoyés par PMB. Le reply-to reste inchangé (mail de l\'utilisateur en DSI ou relance, mail de la localisation ou paramètre opac_biblio_mail à défaut).\nFormat : adresse_email;libellé\nExemple : pmb@sigb.net;PMB Services','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (918,'opac','pret_prolongation_blocage','0','Bloquer la prolongation s\'il y a un niveau de relance validé sur le prêt ?\n0 : Non 1 : Oui','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (919,'opac','empr_export_loans','0','Afficher sur le compte emprunteur un bouton permettant d\'exporter les prêts dans un tableur ?\n0 : Non 1 : Oui','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (920,'opac','cookies_consent','1','Afficher le bandeau d\'acceptation des cookies et des traceurs ? \n0 : Non 1 : Oui','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (921,'pmb','collstate_data','','Colonne des états des collections, dans l\'ordre donné, séparé par des virgules : location_libelle,emplacement_libelle,cote,type_libelle,statut_opac_libelle,origine,state_collections,archive,lacune,surloc_libelle,note,#n : id des champs personnalisés\nLes valeurs possibles sont les propriétés de la classe PHP \"pmb/classes/collstate.class.php\".','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (922,'opac','quick_access','1','Activer le sélecteur d\'accès rapide ? \n0 : Non 1 : Oui','a_general',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (923,'pmb','resa_alert_localized','0','Si les lecteurs sont localisés, restreindre les notifications par email des nouvelles réservations aux utilisateurs selon le site de gestion des lecteurs par défaut ? \n0 : Non 1 : Oui','',0);
INSERT INTO parametres (id_param, type_param, sstype_param, valeur_param, comment_param, section_param, gestion) VALUES (924,'pmb','catalog_verif_js_integration','','Script de vérification de saisie de notice en intégration','',0);

--
-- Table structure for table `pclassement`
--

CREATE TABLE pclassement (
  id_pclass int(10) unsigned NOT NULL AUTO_INCREMENT,
  name_pclass varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  typedoc varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_pclass)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pclassement`
--

INSERT INTO pclassement (id_pclass, name_pclass, typedoc) VALUES (1,'Dewey 100','abcdefgijklmr');

--
-- Table structure for table `perio_relance`
--

CREATE TABLE perio_relance (
  rel_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  rel_abt_num int(10) unsigned NOT NULL DEFAULT '0',
  rel_date_parution date NOT NULL DEFAULT '0000-00-00',
  rel_libelle_numero varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  rel_comment_gestion text COLLATE utf8_unicode_ci NOT NULL,
  rel_comment_opac text COLLATE utf8_unicode_ci NOT NULL,
  rel_nb int(10) unsigned NOT NULL DEFAULT '0',
  rel_date date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (rel_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `perio_relance`
--


--
-- Table structure for table `planificateur`
--

CREATE TABLE planificateur (
  id_planificateur int(11) unsigned NOT NULL AUTO_INCREMENT,
  num_type_tache int(11) NOT NULL,
  libelle_tache varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  desc_tache varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  num_user int(11) NOT NULL,
  param text COLLATE utf8_unicode_ci,
  statut tinyint(1) unsigned DEFAULT '0',
  rep_upload int(8) DEFAULT NULL,
  path_upload text COLLATE utf8_unicode_ci,
  perio_heure varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  perio_minute varchar(28) COLLATE utf8_unicode_ci DEFAULT '01',
  perio_jour_mois varchar(128) COLLATE utf8_unicode_ci DEFAULT '*',
  perio_jour varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  perio_mois varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  calc_next_heure_deb varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  calc_next_date_deb date DEFAULT NULL,
  PRIMARY KEY (id_planificateur)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `planificateur`
--


--
-- Table structure for table `pret`
--

CREATE TABLE pret (
  pret_idempr int(10) unsigned NOT NULL DEFAULT '0',
  pret_idexpl int(10) unsigned NOT NULL DEFAULT '0',
  pret_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  pret_retour date DEFAULT NULL,
  pret_arc_id int(10) unsigned NOT NULL DEFAULT '0',
  niveau_relance int(1) NOT NULL DEFAULT '0',
  date_relance date DEFAULT '0000-00-00',
  printed int(1) NOT NULL DEFAULT '0',
  retour_initial date DEFAULT '0000-00-00',
  cpt_prolongation int(1) NOT NULL DEFAULT '0',
  pret_temp varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  short_loan_flag int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (pret_idexpl),
  KEY i_pret_idempr (pret_idempr),
  KEY i_pret_arc_id (pret_arc_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret`
--

INSERT INTO pret (pret_idempr, pret_idexpl, pret_date, pret_retour, pret_arc_id, niveau_relance, date_relance, printed, retour_initial, cpt_prolongation, pret_temp, short_loan_flag) VALUES (7,94,'2012-11-20 09:33:31','2013-01-01',4,0,'0000-00-00',0,'2012-12-11',1,'',0);
INSERT INTO pret (pret_idempr, pret_idexpl, pret_date, pret_retour, pret_arc_id, niveau_relance, date_relance, printed, retour_initial, cpt_prolongation, pret_temp, short_loan_flag) VALUES (7,90,'2012-11-20 09:34:17','2012-12-11',5,0,'0000-00-00',0,'2012-12-11',0,'',0);
INSERT INTO pret (pret_idempr, pret_idexpl, pret_date, pret_retour, pret_arc_id, niveau_relance, date_relance, printed, retour_initial, cpt_prolongation, pret_temp, short_loan_flag) VALUES (1,53,'2012-11-20 09:34:36','2012-12-11',6,0,'0000-00-00',0,'2012-12-11',0,'',0);

--
-- Table structure for table `pret_archive`
--

CREATE TABLE pret_archive (
  arc_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  arc_debut datetime DEFAULT '0000-00-00 00:00:00',
  arc_fin datetime DEFAULT NULL,
  arc_id_empr int(10) unsigned NOT NULL DEFAULT '0',
  arc_empr_cp varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_empr_ville varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_empr_prof varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_empr_year int(4) unsigned DEFAULT '0',
  arc_empr_categ smallint(5) unsigned DEFAULT '0',
  arc_empr_codestat smallint(5) unsigned DEFAULT '0',
  arc_empr_sexe tinyint(3) unsigned DEFAULT '0',
  arc_empr_statut int(10) unsigned NOT NULL DEFAULT '1',
  arc_empr_location int(6) unsigned NOT NULL DEFAULT '0',
  arc_type_abt int(6) unsigned NOT NULL DEFAULT '0',
  arc_expl_typdoc int(5) unsigned DEFAULT '0',
  arc_expl_cote varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_expl_statut smallint(5) unsigned DEFAULT '0',
  arc_expl_location smallint(5) unsigned DEFAULT '0',
  arc_expl_location_origine int(10) unsigned NOT NULL DEFAULT '0',
  arc_expl_location_retour int(10) unsigned NOT NULL DEFAULT '0',
  arc_expl_codestat smallint(5) unsigned DEFAULT '0',
  arc_expl_owner mediumint(8) unsigned DEFAULT '0',
  arc_expl_section int(5) unsigned NOT NULL DEFAULT '0',
  arc_expl_id int(10) unsigned NOT NULL DEFAULT '0',
  arc_expl_notice int(10) unsigned NOT NULL DEFAULT '0',
  arc_expl_bulletin int(10) unsigned NOT NULL DEFAULT '0',
  arc_groupe varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  arc_niveau_relance int(1) unsigned DEFAULT '0',
  arc_date_relance date NOT NULL DEFAULT '0000-00-00',
  arc_printed int(1) unsigned DEFAULT '0',
  arc_cpt_prolongation int(1) unsigned DEFAULT '0',
  arc_short_loan_flag int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (arc_id),
  KEY i_pa_expl_id (arc_expl_id),
  KEY i_pa_idempr (arc_id_empr),
  KEY i_pa_expl_notice (arc_expl_notice),
  KEY i_pa_expl_bulletin (arc_expl_bulletin),
  KEY i_pa_arc_fin (arc_fin),
  KEY i_pa_arc_empr_categ (arc_empr_categ),
  KEY i_pa_arc_expl_location (arc_expl_location)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret_archive`
--

INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (1,'2012-08-05 16:00:57','2012-10-24 10:47:37',0,'','','',0,7,2,0,1,1,0,1,'RK ROB',1,1,0,0,12,2,10,30,53,0,'',0,'0000-00-00',0,1,0);
INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (4,'2012-11-20 09:33:31','2012-12-11 00:00:00',0,'72500','CHATEAU DU LOIR','Développeur PMB',1972,7,3,1,1,1,0,18,'PER GEO',1,1,0,0,12,2,31,94,0,5,'',0,'0000-00-00',0,0,0);
INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (5,'2012-11-20 09:34:17','2012-12-11 00:00:00',0,'72500','CHATEAU DU LOIR','Développeur PMB',1972,7,3,1,1,1,0,1,'960 DEP',1,1,0,0,12,1,10,90,71,0,'',0,'0000-00-00',0,0,0);
INSERT INTO pret_archive (arc_id, arc_debut, arc_fin, arc_id_empr, arc_empr_cp, arc_empr_ville, arc_empr_prof, arc_empr_year, arc_empr_categ, arc_empr_codestat, arc_empr_sexe, arc_empr_statut, arc_empr_location, arc_type_abt, arc_expl_typdoc, arc_expl_cote, arc_expl_statut, arc_expl_location, arc_expl_location_origine, arc_expl_location_retour, arc_expl_codestat, arc_expl_owner, arc_expl_section, arc_expl_id, arc_expl_notice, arc_expl_bulletin, arc_groupe, arc_niveau_relance, arc_date_relance, arc_printed, arc_cpt_prolongation, arc_short_loan_flag) VALUES (6,'2012-11-20 09:34:36','2012-12-11 00:00:00',0,'01000','StarwarsTown','Pilote',1900,8,4,1,1,1,0,1,'RX BRA',1,1,0,0,12,2,24,53,103,0,'',0,'0000-00-00',0,0,0);

--
-- Table structure for table `pret_custom`
--

CREATE TABLE pret_custom (
  idchamp int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  titre varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `options` text COLLATE utf8_unicode_ci,
  multiple int(11) NOT NULL DEFAULT '0',
  obligatoire int(11) NOT NULL DEFAULT '0',
  ordre int(11) DEFAULT NULL,
  search int(1) unsigned NOT NULL DEFAULT '0',
  export int(1) unsigned NOT NULL DEFAULT '0',
  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',
  PRIMARY KEY (idchamp)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret_custom`
--


--
-- Table structure for table `pret_custom_lists`
--

CREATE TABLE pret_custom_lists (
  pret_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  pret_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  pret_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY i_pret_custom_champ (pret_custom_champ),
  KEY i_pret_champ_list_value (pret_custom_champ,pret_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret_custom_lists`
--


--
-- Table structure for table `pret_custom_values`
--

CREATE TABLE pret_custom_values (
  pret_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  pret_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  pret_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  pret_custom_text text COLLATE utf8_unicode_ci,
  pret_custom_integer int(11) DEFAULT NULL,
  pret_custom_date date DEFAULT NULL,
  pret_custom_float float DEFAULT NULL,
  KEY i_pret_custom_champ (pret_custom_champ),
  KEY i_pret_custom_origine (pret_custom_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pret_custom_values`
--


--
-- Table structure for table `procs`
--

CREATE TABLE procs (
  idproc smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  requete blob NOT NULL,
  `comment` tinytext COLLATE utf8_unicode_ci NOT NULL,
  autorisations mediumtext COLLATE utf8_unicode_ci,
  parameters text COLLATE utf8_unicode_ci,
  num_classement int(5) unsigned NOT NULL DEFAULT '0',
  proc_notice_tpl int(2) unsigned NOT NULL DEFAULT '0',
  proc_notice_tpl_field varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idproc),
  KEY idproc (idproc)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `procs`
--

INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (33,'Portail : Liste des articles par date de création',0x53454C4543540D0A69645F61727469636C6520415320224964656E74696669616E74222C0D0A61727469636C655F6372656174696F6E5F64617465204153202244617465206465206372C3A96174696F6E222C0D0A61727469636C655F7469746C6520415320225469747265206465206C2761727469636C65222C0D0A49464E554C4C28434F4E434154287275625F362E73656374696F6E5F7469746C652C27203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C7275625F312E73656374696F6E5F7469746C65292929292920415320225275627269717565220D0A0D0A46524F4D20636D735F61727469636C65730D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F31204F4E20286E756D5F73656374696F6E3D7275625F312E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F32204F4E20287275625F312E73656374696F6E5F6E756D5F706172656E743D7275625F322E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F33204F4E20287275625F322E73656374696F6E5F6E756D5F706172656E743D7275625F332E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F34204F4E20287275625F332E73656374696F6E5F6E756D5F706172656E743D7275625F342E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F35204F4E20287275625F342E73656374696F6E5F6E756D5F706172656E743D7275625F352E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F36204F4E20287275625F352E73656374696F6E5F6E756D5F706172656E743D7275625F362E69645F73656374696F6E29200D0A0D0A4F5244455220425920312044455343,'','1','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"choix_type\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Choisissez un type de contenu :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select id_editorial_type, editorial_type_label from cms_editorial_types where editorial_type_element=\'article\' order by 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (34,'Portail : Liste des articles selon le rédacteur',0x53454C4543540D0A49464E554C4C28434F4E434154287275625F362E73656374696F6E5F7469746C652C27203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C7275625F312E73656374696F6E5F7469746C65292929292920415320225275627269717565222C0D0A61727469636C655F7469746C6520415320225469747265206465206C2761727469636C65222C0D0A69645F61727469636C6520415320224964656E74696669616E74222C0D0A61727469636C655F6372656174696F6E5F64617465204153202244617465206465206372C3A96174696F6E222C0D0A646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F64617465204153202244617465206465206D69736520C3A0206A6F757222200D0A0D0A46524F4D20636D735F61727469636C65730D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F31204F4E20286E756D5F73656374696F6E3D7275625F312E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F32204F4E20287275625F312E73656374696F6E5F6E756D5F706172656E743D7275625F322E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F33204F4E20287275625F322E73656374696F6E5F6E756D5F706172656E743D7275625F332E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F34204F4E20287275625F332E73656374696F6E5F6E756D5F706172656E743D7275625F342E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F35204F4E20287275625F342E73656374696F6E5F6E756D5F706172656E743D7275625F352E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F36204F4E20287275625F352E73656374696F6E5F6E756D5F706172656E743D7275625F362E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F656469746F7269616C5F637573746F6D5F76616C75657320415320646174655F6D616A204F4E202869645F61727469636C653D646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F6F726967696E6520414E4420646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F6368616D703D3437290D0A4A4F494E20636D735F656469746F7269616C5F637573746F6D5F76616C75657320415320726564616374657572204F4E202869645F61727469636C653D7265646163746575722E636D735F656469746F7269616C5F637573746F6D5F6F726967696E6520414E44207265646163746575722E636D735F656469746F7269616C5F637573746F6D5F6368616D703D3436290D0A0D0A5748455245207265646163746575722E636D735F656469746F7269616C5F637573746F6D5F696E74656765723D212163686F69785F72656461637465757221210D0A0D0A4F524445522042592031,'','1','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"choix_redacteur\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Choisissez un utilisateur :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[SELECT userid, username FROM users ORDER BY 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (35,'Portail : Liste des articles selon le type de contenu',0x53454C4543540D0A49464E554C4C28434F4E434154287275625F362E73656374696F6E5F7469746C652C27203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C7275625F312E73656374696F6E5F7469746C65292929292920415320225275627269717565222C0D0A61727469636C655F7469746C6520415320225469747265206465206C2761727469636C65222C0D0A69645F61727469636C6520415320224964656E74696669616E74222C0D0A61727469636C655F6372656174696F6E5F64617465204153202244617465206465206372C3A96174696F6E22200D0A0D0A46524F4D20636D735F61727469636C65730D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F31204F4E20286E756D5F73656374696F6E3D7275625F312E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F32204F4E20287275625F312E73656374696F6E5F6E756D5F706172656E743D7275625F322E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F33204F4E20287275625F322E73656374696F6E5F6E756D5F706172656E743D7275625F332E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F34204F4E20287275625F332E73656374696F6E5F6E756D5F706172656E743D7275625F342E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F35204F4E20287275625F342E73656374696F6E5F6E756D5F706172656E743D7275625F352E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F36204F4E20287275625F352E73656374696F6E5F6E756D5F706172656E743D7275625F362E69645F73656374696F6E29200D0A0D0A57484552452061727469636C655F6E756D5F747970653D212163686F69785F7479706521210D0A0D0A4F524445522042592031,'','1','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"choix_type\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Choisissez un type de contenu :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select id_editorial_type, editorial_type_label from cms_editorial_types where editorial_type_element=\'article\' order by 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (36,'Portail : Liste des rubriques par date de création',0x53454C454354200D0A7275625F302E69645F73656374696F6E20415320224964656E74696669616E74222C0D0A7275625F302E73656374696F6E5F6372656174696F6E5F64617465204153202244617465206465206372C3A96174696F6E222C0D0A7275625F302E73656374696F6E5F7469746C6520415320225469747265206465206C61207275627269717565222C0D0A43415345205748454E207275625F302E73656374696F6E5F6E756D5F706172656E743D30205448454E2027526163696E652720454C5345200D0A49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F362E73656374696F6E5F7469746C652C27203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C434F4E4341542827526163696E65203E20272C7275625F312E73656374696F6E5F7469746C6529292929292920454E442041532022527562726971756520706172656E746522200D0A0D0A46524F4D20636D735F73656374696F6E73204153207275625F300D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F31204F4E20287275625F302E73656374696F6E5F6E756D5F706172656E743D7275625F312E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F32204F4E20287275625F312E73656374696F6E5F6E756D5F706172656E743D7275625F322E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F33204F4E20287275625F322E73656374696F6E5F6E756D5F706172656E743D7275625F332E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F34204F4E20287275625F332E73656374696F6E5F6E756D5F706172656E743D7275625F342E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F35204F4E20287275625F342E73656374696F6E5F6E756D5F706172656E743D7275625F352E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F36204F4E20287275625F352E73656374696F6E5F6E756D5F706172656E743D7275625F362E69645F73656374696F6E29200D0A0D0A4F5244455220425920312044455343,'','1','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"choix_type\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Choisissez un type de contenu :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select id_editorial_type, editorial_type_label from cms_editorial_types where editorial_type_element=\'section\' order by 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (37,'Portail : Liste des rubriques selon le rédacteur',0x53454C454354200D0A43415345205748454E207275625F302E73656374696F6E5F6E756D5F706172656E743D30205448454E2027526163696E652720454C5345200D0A49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F362E73656374696F6E5F7469746C652C27203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C434F4E4341542827526163696E65203E20272C7275625F312E73656374696F6E5F7469746C6529292929292920454E442041532022527562726971756520706172656E7465222C0D0A7275625F302E73656374696F6E5F7469746C6520415320225469747265206465206C61207275627269717565222C0D0A7275625F302E69645F73656374696F6E20415320224964656E74696669616E74222C0D0A7275625F302E73656374696F6E5F6372656174696F6E5F64617465204153202244617465206465206372C3A96174696F6E222C0D0A646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F64617465204153202244617465206465206D69736520C3A0206A6F757222200D0A0D0A46524F4D20636D735F73656374696F6E73204153207275625F300D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F31204F4E20287275625F302E73656374696F6E5F6E756D5F706172656E743D7275625F312E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F32204F4E20287275625F312E73656374696F6E5F6E756D5F706172656E743D7275625F322E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F33204F4E20287275625F322E73656374696F6E5F6E756D5F706172656E743D7275625F332E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F34204F4E20287275625F332E73656374696F6E5F6E756D5F706172656E743D7275625F342E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F35204F4E20287275625F342E73656374696F6E5F6E756D5F706172656E743D7275625F352E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F36204F4E20287275625F352E73656374696F6E5F6E756D5F706172656E743D7275625F362E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F656469746F7269616C5F637573746F6D5F76616C75657320415320646174655F6D616A204F4E20287275625F302E69645F73656374696F6E3D646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F6F726967696E6520414E4420646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F6368616D703D3438290D0A4A4F494E20636D735F656469746F7269616C5F637573746F6D5F76616C75657320415320726564616374657572204F4E20287275625F302E69645F73656374696F6E3D7265646163746575722E636D735F656469746F7269616C5F637573746F6D5F6F726967696E6520414E44207265646163746575722E636D735F656469746F7269616C5F637573746F6D5F6368616D703D3435290D0A0D0A5748455245207265646163746575722E636D735F656469746F7269616C5F637573746F6D5F696E74656765723D212163686F69785F72656461637465757221210D0A0D0A4F524445522042592031,'','1','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"choix_redacteur\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Choisissez un utilisateur :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[SELECT userid, username FROM users ORDER BY 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (38,'Portail : Liste des rubriques selon le type de contenu',0x53454C454354200D0A43415345205748454E207275625F302E73656374696F6E5F6E756D5F706172656E743D30205448454E2027526163696E652720454C5345200D0A49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F362E73656374696F6E5F7469746C652C27203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C434F4E4341542827526163696E65203E20272C7275625F312E73656374696F6E5F7469746C6529292929292920454E442041532022527562726971756520706172656E7465222C0D0A7275625F302E73656374696F6E5F7469746C6520415320225469747265206465206C61207275627269717565222C0D0A7275625F302E69645F73656374696F6E20415320224964656E74696669616E74222C0D0A7275625F302E73656374696F6E5F6372656174696F6E5F64617465204153202244617465206465206372C3A96174696F6E22200D0A0D0A46524F4D20636D735F73656374696F6E73204153207275625F300D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F31204F4E20287275625F302E73656374696F6E5F6E756D5F706172656E743D7275625F312E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F32204F4E20287275625F312E73656374696F6E5F6E756D5F706172656E743D7275625F322E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F33204F4E20287275625F322E73656374696F6E5F6E756D5F706172656E743D7275625F332E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F34204F4E20287275625F332E73656374696F6E5F6E756D5F706172656E743D7275625F342E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F35204F4E20287275625F342E73656374696F6E5F6E756D5F706172656E743D7275625F352E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F36204F4E20287275625F352E73656374696F6E5F6E756D5F706172656E743D7275625F362E69645F73656374696F6E29200D0A0D0A5748455245207275625F302E73656374696F6E5F6E756D5F747970653D212163686F69785F7479706521210D0A0D0A4F524445522042592031,'','1','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"choix_type\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Choisissez un type de contenu :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select id_editorial_type, editorial_type_label from cms_editorial_types where editorial_type_element=\'section\' order by 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (39,'Portail : Vider le cache portail',0x5452554E4341544520636D735F63616368655F636164726573,'','1','',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (41,'Portail : Liste des articles selon les cadres de la page d\'accueil',0x53454C4543540D0A49464E554C4C28434F4E434154287275625F362E73656374696F6E5F7469746C652C27203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E434154287275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C7275625F312E73656374696F6E5F7469746C65292929292920415320225275627269717565222C0D0A61727469636C655F7469746C6520415320225469747265206465206C2761727469636C65222C0D0A69645F61727469636C6520415320224964656E74696669616E74222C0D0A61727469636C655F6372656174696F6E5F64617465204153202244617465206465206372C3A96174696F6E222C0D0A646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F64617465204153202244617465206465206D69736520C3A0206A6F757222200D0A0D0A46524F4D20636D735F61727469636C65730D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F31204F4E20286E756D5F73656374696F6E3D7275625F312E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F32204F4E20287275625F312E73656374696F6E5F6E756D5F706172656E743D7275625F322E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F33204F4E20287275625F322E73656374696F6E5F6E756D5F706172656E743D7275625F332E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F34204F4E20287275625F332E73656374696F6E5F6E756D5F706172656E743D7275625F342E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F35204F4E20287275625F342E73656374696F6E5F6E756D5F706172656E743D7275625F352E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F36204F4E20287275625F352E73656374696F6E5F6E756D5F706172656E743D7275625F362E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F656469746F7269616C5F637573746F6D5F76616C75657320415320646174655F6D616A204F4E202869645F61727469636C653D646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F6F726967696E6520414E4420646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F6368616D703D3437290D0A4A4F494E20636D735F656469746F7269616C5F637573746F6D5F76616C756573204153206361647265735F6163637565696C204F4E202869645F61727469636C653D6361647265735F6163637565696C2E636D735F656469746F7269616C5F637573746F6D5F6F726967696E6520414E44206361647265735F6163637565696C2E636D735F656469746F7269616C5F637573746F6D5F6368616D703D3336290D0A0D0A5748455245206361647265735F6163637565696C2E636D735F656469746F7269616C5F637573746F6D5F696E74656765723D212163686F69785F636164726521210D0A0D0A4F524445522042592031,'','','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"choix_cadre\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Choisissez un cadre :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[SELECT cms_editorial_custom_list_value, cms_editorial_custom_list_lib FROM cms_editorial_custom_lists WHERE cms_editorial_custom_champ=36 ORDER BY 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (40,'Portail : Supprimer des versions du CMS',0x44454C45544520636D735F76657273696F6E2C20636D735F6275696C640D0A46524F4D20636D735F76657273696F6E0D0A4A4F494E20636D735F6275696C64204F4E202869645F76657273696F6E3D6275696C645F76657273696F6E5F6E756D29200D0A57484552452076657273696F6E5F64617465213D272121646174655F76657273696F6E212127,'Attention, il faut sélectionner la version à conserver !!','1','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"date_version\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[SÃ©lectionnez la version <span style=\"color:red;font-weight:bold;\">A CONSERVER</span> :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select version_date, version_date from cms_version where version_cms_num=1 order by 2 desc]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (42,'Portail : Liste des rubriques selon les cadres de la page d\'accueil',0x53454C454354200D0A43415345205748454E207275625F302E73656374696F6E5F6E756D5F706172656E743D30205448454E2027526163696E652720454C5345200D0A49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F362E73656374696F6E5F7469746C652C27203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F352E73656374696F6E5F7469746C652C27203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F342E73656374696F6E5F7469746C652C27203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F332E73656374696F6E5F7469746C652C27203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C49464E554C4C28434F4E4341542827526163696E65203E20272C7275625F322E73656374696F6E5F7469746C652C27203E20272C7275625F312E73656374696F6E5F7469746C65292C434F4E4341542827526163696E65203E20272C7275625F312E73656374696F6E5F7469746C6529292929292920454E442041532022527562726971756520706172656E7465222C0D0A7275625F302E73656374696F6E5F7469746C6520415320225469747265206465206C61207275627269717565222C0D0A7275625F302E69645F73656374696F6E20415320224964656E74696669616E74222C0D0A7275625F302E73656374696F6E5F6372656174696F6E5F64617465204153202244617465206465206372C3A96174696F6E222C0D0A646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F64617465204153202244617465206465206D69736520C3A0206A6F757222200D0A0D0A46524F4D20636D735F73656374696F6E73204153207275625F300D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F31204F4E20287275625F302E73656374696F6E5F6E756D5F706172656E743D7275625F312E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F32204F4E20287275625F312E73656374696F6E5F6E756D5F706172656E743D7275625F322E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F33204F4E20287275625F322E73656374696F6E5F6E756D5F706172656E743D7275625F332E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F34204F4E20287275625F332E73656374696F6E5F6E756D5F706172656E743D7275625F342E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F35204F4E20287275625F342E73656374696F6E5F6E756D5F706172656E743D7275625F352E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F73656374696F6E73204153207275625F36204F4E20287275625F352E73656374696F6E5F6E756D5F706172656E743D7275625F362E69645F73656374696F6E29200D0A4C454654204A4F494E20636D735F656469746F7269616C5F637573746F6D5F76616C75657320415320646174655F6D616A204F4E20287275625F302E69645F73656374696F6E3D646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F6F726967696E6520414E4420646174655F6D616A2E636D735F656469746F7269616C5F637573746F6D5F6368616D703D3438290D0A4A4F494E20636D735F656469746F7269616C5F637573746F6D5F76616C756573204153206361647265735F6163637565696C204F4E20287275625F302E69645F73656374696F6E3D6361647265735F6163637565696C2E636D735F656469746F7269616C5F637573746F6D5F6F726967696E6520414E44206361647265735F6163637565696C2E636D735F656469746F7269616C5F637573746F6D5F6368616D703D3431290D0A0D0A5748455245206361647265735F6163637565696C2E636D735F656469746F7269616C5F637573746F6D5F696E74656765723D212163686F69785F636164726521210D0A0D0A4F524445522042592031,'','','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"choix_cadre\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Choisissez un cadre :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[SELECT cms_editorial_custom_list_value, cms_editorial_custom_list_lib FROM cms_editorial_custom_lists WHERE cms_editorial_custom_champ=41 ORDER BY 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters, num_classement, proc_notice_tpl, proc_notice_tpl_field) VALUES (43,'Portail purge Css !! ALL !!',0x75706461746520636D735F6275696C6420736574206275696C645F6373733D2727207768657265206275696C645F76657273696F6E5F6E756D3D212169642121,'','1','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"id\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[id]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select id_version, id_version from cms_version order by id_version desc]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');

--
-- Table structure for table `procs_classements`
--

CREATE TABLE procs_classements (
  idproc_classement smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  libproc_classement varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (idproc_classement)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `procs_classements`
--

INSERT INTO procs_classements (idproc_classement, libproc_classement) VALUES (1,'Statistiques collections');
INSERT INTO procs_classements (idproc_classement, libproc_classement) VALUES (2,'Statistiques lecteurs');
INSERT INTO procs_classements (idproc_classement, libproc_classement) VALUES (3,'Statistiques prêts');
INSERT INTO procs_classements (idproc_classement, libproc_classement) VALUES (4,'Listes');
INSERT INTO procs_classements (idproc_classement, libproc_classement) VALUES (5,'Portail Pagéo');

--
-- Table structure for table `publisher_custom`
--

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

--
-- Dumping data for table `publisher_custom`
--


--
-- Table structure for table `publisher_custom_lists`
--

CREATE TABLE publisher_custom_lists (
  publisher_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  publisher_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  publisher_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY editorial_custom_champ (publisher_custom_champ),
  KEY editorial_champ_list_value (publisher_custom_champ,publisher_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `publisher_custom_lists`
--


--
-- Table structure for table `publisher_custom_values`
--

CREATE TABLE publisher_custom_values (
  publisher_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  publisher_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  publisher_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  publisher_custom_text text COLLATE utf8_unicode_ci,
  publisher_custom_integer int(11) DEFAULT NULL,
  publisher_custom_date date DEFAULT NULL,
  publisher_custom_float float DEFAULT NULL,
  KEY editorial_custom_champ (publisher_custom_champ),
  KEY editorial_custom_origine (publisher_custom_origine),
  KEY i_pcv_st (publisher_custom_small_text),
  KEY i_pcv_t (publisher_custom_text(255)),
  KEY i_pcv_i (publisher_custom_integer),
  KEY i_pcv_d (publisher_custom_date),
  KEY i_pcv_f (publisher_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `publisher_custom_values`
--


--
-- Table structure for table `publishers`
--

CREATE TABLE publishers (
  ed_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  ed_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_adr1 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_adr2 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_cp varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_ville varchar(96) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_pays varchar(96) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ed_web varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  index_publisher text COLLATE utf8_unicode_ci,
  ed_comment text COLLATE utf8_unicode_ci,
  PRIMARY KEY (ed_id),
  KEY ed_name (ed_name),
  KEY ed_ville (ed_ville)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `publishers`
--

INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (6,'Seuil','','','','Paris','','',' seuil paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (7,'les Éd. du Toucan','','','','[Issy-les-Moulineaux]','','',' les ed du toucan issy les moulineaux ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (8,'Hazan','','','','[Vanves]','','',' hazan vanves ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (9,'Didier jeunesse','','','','Paris','','',' didier jeunesse paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (11,'Pastel','','','','[Bruxelles]','','',' pastel bruxelles ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (12,'l\'école des loisirs','','','','Paris','','',' l ecole des loisirs paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (13,'Gallimard','','','','Paris','','',' gallimard paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (14,'Serpent à plumes','','','','Paris','','',' serpent a plumes paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (15,'Vents d\'ailleurs','','','','La Roque-d\'Anthéron','','',' vents d ailleurs la roque d antheron ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (16,'Kaléidoscope','','','','Paris','','',' kaleidoscope paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (17,'Hachette Jeunesse','','','','','','',' hachette jeunesse ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (18,'Circonflexe','','','','[Paris]','','',' circonflexe paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (19,'l\'Oeil neuf éd.','','','','Paris','','',' l oeil neuf ed paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (20,'Éd. du Cercle de la librairie','','','','[Paris]','','',' ed du cercle de la librairie paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (21,'Presses universitaires de France','','','','Paris','','',' presses universitaires de france paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (22,'Casterman','','','','','','',' casterman ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (23,'Gallimard jeunesse','','','','[Paris]','','',' gallimard jeunesse paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (24,'Denoël','','','','[Paris]','','',' denoel paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (25,'Éd. First','','','','Paris','','',' ed first paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (26,'Milan','','','','Toulouse','','',' milan toulouse ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (27,'Éd. du Rouergue','','','','Rodez','','',' ed du rouergue rodez ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (28,'Gallimard jeunesse - Giboulées','','','','[Paris]','','',' gallimard jeunesse giboulees paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (29,'Nathan','','','','','','',' nathan ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (30,'Éd. Lito','','','','Champigny-sur-Marne','','',' ed lito champigny sur marne ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (31,'Rue du monde','','','','[Voisins-le-Bretonneux]','','',' rue du monde voisins le bretonneux ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (32,'Mila éd.','','','','[Paris]','','',' mila ed paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (33,'l\'École des loisirs-Loulou & Cie','','','','Paris','','',' l ecole des loisirs loulou cie paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (34,'l\'Atalante','','','','Nantes','','',' l atalante nantes ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (35,'10-18','','','','','','',' 10 18 ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (36,'Arola','','','','','','',' arola ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (37,'Cah cinema','','','','','','',' cah cinema ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (38,'Gallimard Jeunesse Musique','','','','','','',' gallimard jeunesse musique ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (39,'Twentieth century Fox','','','','Paris','','',' twentieth century fox paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (40,'Warner home video','','','','Neuilly-sur-Seine','','',' warner home video neuilly sur seine ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (41,'Columbia Tristar home video','','','','Boulogne-Billancourt','','',' columbia tristar home video boulogne billancourt ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (42,'Manteca','','','','','','',' manteca ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (43,'AZ','','','','Paris','','',' az paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (44,'Universal music jazz France','','','','','','',' universal music jazz france ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (45,'Universal Polydor','','','','','','',' universal polydor ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (46,'Because music','','','','Paris','','',' because music paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (47,'Participations éditions presse','','','','Paris','','',' participations editions presse paris ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (48,'ENSSIB','','','','Villeurbanne','','',' enssib villeurbanne ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (49,'Éd. Grains de sel','','','','Lyon','','',' ed grains de sel lyon ','');
INSERT INTO publishers (ed_id, ed_name, ed_adr1, ed_adr2, ed_cp, ed_ville, ed_pays, ed_web, index_publisher, ed_comment) VALUES (50,'Studio magazine','','','','Paris','','',' studio magazine paris ','');

--
-- Table structure for table `quotas`
--

CREATE TABLE quotas (
  quota_type int(10) unsigned NOT NULL DEFAULT '0',
  constraint_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  elements int(10) unsigned NOT NULL DEFAULT '0',
  `value` float DEFAULT NULL,
  PRIMARY KEY (quota_type,constraint_type,elements)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `quotas`
--

INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'MAX',0,10);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'DEFAULT',0,5);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'FORCE_LEND',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'MAX_QUOTA',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',17,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',3,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',1,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (1,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'DEFAULT',0,21);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',17,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',3,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',1,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (2,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'DEFAULT',0,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'FORCE_LEND',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',17,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',3,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',1,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (64,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'DEFAULT',0,21);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',17,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',3,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',1,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (128,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'MAX',0,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'DEFAULT',0,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'FORCE_LEND',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'MAX_QUOTA',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',20,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',6,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',4,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (4,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'DEFAULT',0,7);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',20,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',6,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',4,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (8,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'MAX',0,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'DEFAULT',0,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'FORCE_LEND',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'MAX_QUOTA',0,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',24,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',10,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',8,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (16,'PRIORITY',2,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'MAX',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'MIN',0,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'DEFAULT',0,7);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'CONFLICT',0,4);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',24,0);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',16,1);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',10,2);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',8,3);
INSERT INTO quotas (quota_type, constraint_type, elements, value) VALUES (32,'PRIORITY',2,4);

--
-- Table structure for table `quotas_finance`
--

CREATE TABLE quotas_finance (
  quota_type int(10) unsigned NOT NULL DEFAULT '0',
  constraint_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  elements int(10) unsigned NOT NULL DEFAULT '0',
  `value` float DEFAULT NULL,
  PRIMARY KEY (quota_type,constraint_type,elements)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `quotas_finance`
--


--
-- Table structure for table `quotas_opac_views`
--

CREATE TABLE quotas_opac_views (
  quota_type int(10) unsigned NOT NULL DEFAULT '0',
  constraint_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  elements int(10) unsigned NOT NULL DEFAULT '0',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (quota_type,constraint_type,elements)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `quotas_opac_views`
--


--
-- Table structure for table `rapport_demandes`
--

CREATE TABLE rapport_demandes (
  id_item int(10) unsigned NOT NULL AUTO_INCREMENT,
  contenu text COLLATE utf8_unicode_ci NOT NULL,
  num_note int(10) NOT NULL DEFAULT '0',
  num_demande int(10) NOT NULL DEFAULT '0',
  ordre mediumint(3) NOT NULL DEFAULT '0',
  `type` mediumint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_item)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rapport_demandes`
--


--
-- Table structure for table `rdfstore_g2t`
--

CREATE TABLE rdfstore_g2t (
  g mediumint(8) unsigned NOT NULL,
  t mediumint(8) unsigned NOT NULL,
  UNIQUE KEY gt (g,t),
  KEY tg (t,g)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_g2t`
--


--
-- Table structure for table `rdfstore_id2val`
--

CREATE TABLE rdfstore_id2val (
  id mediumint(8) unsigned NOT NULL,
  misc tinyint(1) NOT NULL DEFAULT '0',
  val text COLLATE utf8_unicode_ci NOT NULL,
  val_type tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY id (id,val_type),
  KEY v (val(64))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_id2val`
--


--
-- Table structure for table `rdfstore_index`
--

CREATE TABLE rdfstore_index (
  num_triple int(10) unsigned NOT NULL DEFAULT '0',
  subject_uri text COLLATE utf8_unicode_ci NOT NULL,
  subject_type text COLLATE utf8_unicode_ci NOT NULL,
  predicat_uri text COLLATE utf8_unicode_ci NOT NULL,
  num_object int(10) unsigned NOT NULL DEFAULT '0',
  object_val text COLLATE utf8_unicode_ci NOT NULL,
  object_index text COLLATE utf8_unicode_ci NOT NULL,
  object_lang char(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (num_object)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rdfstore_index`
--


--
-- Table structure for table `rdfstore_o2val`
--

CREATE TABLE rdfstore_o2val (
  id mediumint(8) unsigned NOT NULL,
  misc tinyint(1) NOT NULL DEFAULT '0',
  val_hash char(32) COLLATE utf8_unicode_ci NOT NULL,
  val text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY id (id),
  KEY vh (val_hash),
  KEY v (val(64))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_o2val`
--


--
-- Table structure for table `rdfstore_s2val`
--

CREATE TABLE rdfstore_s2val (
  id mediumint(8) unsigned NOT NULL,
  misc tinyint(1) NOT NULL DEFAULT '0',
  val_hash char(32) COLLATE utf8_unicode_ci NOT NULL,
  val text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY id (id),
  KEY vh (val_hash)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_s2val`
--


--
-- Table structure for table `rdfstore_setting`
--

CREATE TABLE rdfstore_setting (
  k char(32) COLLATE utf8_unicode_ci NOT NULL,
  val text COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY k (k)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_setting`
--


--
-- Table structure for table `rdfstore_triple`
--

CREATE TABLE rdfstore_triple (
  t mediumint(8) unsigned NOT NULL,
  s mediumint(8) unsigned NOT NULL,
  p mediumint(8) unsigned NOT NULL,
  o mediumint(8) unsigned NOT NULL,
  o_lang_dt mediumint(8) unsigned NOT NULL,
  o_comp char(35) COLLATE utf8_unicode_ci NOT NULL,
  s_type tinyint(1) NOT NULL DEFAULT '0',
  o_type tinyint(1) NOT NULL DEFAULT '0',
  misc tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY t (t),
  KEY sp (s,p),
  KEY os (o,s),
  KEY po (p,o),
  KEY misc (misc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci DELAY_KEY_WRITE=1;

--
-- Dumping data for table `rdfstore_triple`
--


--
-- Table structure for table `recouvrements`
--

CREATE TABLE recouvrements (
  recouvr_id int(16) unsigned NOT NULL AUTO_INCREMENT,
  empr_id int(10) unsigned NOT NULL DEFAULT '0',
  id_expl int(10) unsigned NOT NULL DEFAULT '0',
  date_rec date NOT NULL DEFAULT '0000-00-00',
  libelle varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  montant decimal(16,2) DEFAULT '0.00',
  recouvr_type int(2) unsigned NOT NULL DEFAULT '0',
  date_pret datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_relance1 datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_relance2 datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_relance3 datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (recouvr_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `recouvrements`
--


--
-- Table structure for table `resa`
--

CREATE TABLE resa (
  id_resa mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  resa_idempr int(10) unsigned NOT NULL DEFAULT '0',
  resa_idnotice mediumint(8) unsigned NOT NULL DEFAULT '0',
  resa_idbulletin int(8) unsigned NOT NULL DEFAULT '0',
  resa_date datetime DEFAULT NULL,
  resa_date_debut date NOT NULL DEFAULT '0000-00-00',
  resa_date_fin date NOT NULL DEFAULT '0000-00-00',
  resa_cb varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resa_confirmee int(1) unsigned NOT NULL DEFAULT '0',
  resa_loc_retrait smallint(5) unsigned NOT NULL DEFAULT '0',
  resa_arc int(10) unsigned NOT NULL DEFAULT '0',
  resa_planning_id_resa int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_resa),
  KEY resa_date_fin (resa_date_fin),
  KEY resa_date (resa_date),
  KEY resa_cb (resa_cb),
  KEY i_idbulletin (resa_idbulletin),
  KEY i_idnotice (resa_idnotice)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resa`
--


--
-- Table structure for table `resa_archive`
--

CREATE TABLE resa_archive (
  resarc_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  resarc_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  resarc_debut date NOT NULL DEFAULT '0000-00-00',
  resarc_fin date NOT NULL DEFAULT '0000-00-00',
  resarc_idnotice int(10) unsigned NOT NULL DEFAULT '0',
  resarc_idbulletin int(10) unsigned NOT NULL DEFAULT '0',
  resarc_confirmee int(1) unsigned DEFAULT '0',
  resarc_cb varchar(14) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_loc_retrait smallint(5) unsigned DEFAULT '0',
  resarc_from_opac int(1) unsigned DEFAULT '0',
  resarc_anulee int(1) unsigned DEFAULT '0',
  resarc_pretee int(1) unsigned DEFAULT '0',
  resarc_arcpretid int(10) unsigned NOT NULL DEFAULT '0',
  resarc_id_empr int(10) unsigned NOT NULL DEFAULT '0',
  resarc_empr_cp varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_empr_ville varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_empr_prof varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_empr_year int(4) unsigned DEFAULT '0',
  resarc_empr_categ smallint(5) unsigned DEFAULT '0',
  resarc_empr_codestat smallint(5) unsigned DEFAULT '0',
  resarc_empr_sexe tinyint(3) unsigned DEFAULT '0',
  resarc_empr_location int(6) unsigned NOT NULL DEFAULT '1',
  resarc_expl_nb int(5) unsigned DEFAULT '0',
  resarc_expl_typdoc int(5) unsigned DEFAULT '0',
  resarc_expl_cote varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  resarc_expl_statut smallint(5) unsigned DEFAULT '0',
  resarc_expl_location smallint(5) unsigned DEFAULT '0',
  resarc_expl_codestat smallint(5) unsigned DEFAULT '0',
  resarc_expl_owner mediumint(8) unsigned DEFAULT '0',
  resarc_expl_section int(5) unsigned NOT NULL DEFAULT '0',
  resarc_resa_planning_id_resa int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (resarc_id),
  KEY i_pa_idempr (resarc_id_empr),
  KEY i_pa_notice (resarc_idnotice),
  KEY i_pa_bulletin (resarc_idbulletin),
  KEY i_pa_resarc_date (resarc_date)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resa_archive`
--

INSERT INTO resa_archive (resarc_id, resarc_date, resarc_debut, resarc_fin, resarc_idnotice, resarc_idbulletin, resarc_confirmee, resarc_cb, resarc_loc_retrait, resarc_from_opac, resarc_anulee, resarc_pretee, resarc_arcpretid, resarc_id_empr, resarc_empr_cp, resarc_empr_ville, resarc_empr_prof, resarc_empr_year, resarc_empr_categ, resarc_empr_codestat, resarc_empr_sexe, resarc_empr_location, resarc_expl_nb, resarc_expl_typdoc, resarc_expl_cote, resarc_expl_statut, resarc_expl_location, resarc_expl_codestat, resarc_expl_owner, resarc_expl_section, resarc_resa_planning_id_resa) VALUES (1,'2016-02-10 16:16:40','0000-00-00','0000-00-00',90,0,0,'',0,1,1,0,0,11,'','','',0,10,3,0,1,1,0,'',0,0,0,0,0,0);

--
-- Table structure for table `resa_loc`
--

CREATE TABLE resa_loc (
  resa_loc int(8) unsigned NOT NULL DEFAULT '0',
  resa_emprloc int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (resa_loc,resa_emprloc),
  KEY i_resa_emprloc (resa_emprloc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resa_loc`
--


--
-- Table structure for table `resa_planning`
--

CREATE TABLE resa_planning (
  id_resa mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  resa_idempr mediumint(8) unsigned NOT NULL DEFAULT '0',
  resa_idnotice mediumint(8) unsigned NOT NULL DEFAULT '0',
  resa_idbulletin int(8) unsigned NOT NULL DEFAULT '0',
  resa_date datetime DEFAULT NULL,
  resa_date_debut date NOT NULL DEFAULT '0000-00-00',
  resa_date_fin date NOT NULL DEFAULT '0000-00-00',
  resa_validee int(1) unsigned NOT NULL DEFAULT '0',
  resa_confirmee int(1) unsigned NOT NULL DEFAULT '0',
  resa_loc_retrait int(5) unsigned NOT NULL DEFAULT '0',
  resa_qty int(5) unsigned NOT NULL DEFAULT '1',
  resa_remaining_qty int(5) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (id_resa),
  KEY resa_date_fin (resa_date_fin),
  KEY resa_date (resa_date)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resa_planning`
--


--
-- Table structure for table `resa_ranger`
--

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

--
-- Dumping data for table `resa_ranger`
--


--
-- Table structure for table `responsability`
--

CREATE TABLE responsability (
  responsability_author mediumint(8) unsigned NOT NULL DEFAULT '0',
  responsability_notice mediumint(8) unsigned NOT NULL DEFAULT '0',
  responsability_fonction varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  responsability_type mediumint(1) unsigned NOT NULL DEFAULT '0',
  responsability_ordre smallint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (responsability_author,responsability_notice,responsability_fonction),
  KEY responsability_notice (responsability_notice)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `responsability`
--

INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (19,73,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (15,71,'440',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (18,72,'250',2,2);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (17,72,'440',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (16,72,'070',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (13,69,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (12,68,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (14,70,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (11,68,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (20,74,'440',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (22,75,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (21,75,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (22,76,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (21,76,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (23,77,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (26,78,'730',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (25,78,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (24,78,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (27,79,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (29,80,'',1,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (28,80,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (30,81,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (31,82,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (33,83,'651',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (32,83,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (34,84,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (35,85,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (37,86,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (36,86,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (41,87,'730',2,2);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (40,87,'730',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (39,87,'440',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (38,87,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (42,88,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (45,89,'440',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (44,89,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (43,89,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (46,90,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (47,91,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (48,92,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (50,93,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (49,93,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (51,94,'',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (52,95,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (53,96,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (55,97,'440',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (54,97,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (57,98,'651',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (56,98,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (59,99,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (58,99,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (59,100,'070',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (58,100,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (60,101,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (27,102,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (63,103,'730',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (62,103,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (61,103,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (65,104,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (64,104,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (65,105,'730',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (64,105,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,106,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (68,108,'',1,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (69,109,'440',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (71,110,'',2,1);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (70,110,'005',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,110,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (72,111,'005',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,111,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (73,112,'0',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,112,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,113,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (70,114,'005',2,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (66,114,'300',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (74,115,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (75,116,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (76,117,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (77,118,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (78,119,'590',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (79,124,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (80,125,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (81,126,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (82,127,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (83,128,'070',0,0);
INSERT INTO responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES (84,132,'651',0,0);

--
-- Table structure for table `responsability_tu`
--

CREATE TABLE responsability_tu (
  responsability_tu_author_num int(10) unsigned NOT NULL DEFAULT '0',
  responsability_tu_num int(10) unsigned NOT NULL DEFAULT '0',
  responsability_tu_fonction char(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  responsability_tu_type int(10) unsigned NOT NULL DEFAULT '0',
  responsability_tu_ordre smallint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (responsability_tu_author_num,responsability_tu_num,responsability_tu_fonction),
  KEY responsability_tu_author (responsability_tu_author_num),
  KEY responsability_tu_num (responsability_tu_num)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `responsability_tu`
--


--
-- Table structure for table `rss_content`
--

CREATE TABLE rss_content (
  rss_id int(10) unsigned NOT NULL DEFAULT '0',
  rss_content longblob NOT NULL,
  rss_content_parse longblob NOT NULL,
  rss_last timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (rss_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rss_content`
--

INSERT INTO rss_content (rss_id, rss_content, rss_content_parse, rss_last) VALUES (120,0x[encoded data, 38494 characters],0x[encoded data, 32478 characters],'2012-10-25 07:29:11');

--
-- Table structure for table `rss_flux`
--

CREATE TABLE rss_flux (
  id_rss_flux int(9) unsigned NOT NULL AUTO_INCREMENT,
  nom_rss_flux varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  link_rss_flux blob NOT NULL,
  descr_rss_flux blob NOT NULL,
  lang_rss_flux varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr',
  copy_rss_flux blob NOT NULL,
  editor_rss_flux varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  webmaster_rss_flux varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ttl_rss_flux int(9) unsigned NOT NULL DEFAULT '60',
  img_url_rss_flux blob NOT NULL,
  img_title_rss_flux blob NOT NULL,
  img_link_rss_flux blob NOT NULL,
  format_flux blob NOT NULL,
  rss_flux_content longblob NOT NULL,
  rss_flux_last timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  export_court_flux tinyint(1) unsigned NOT NULL DEFAULT '0',
  tpl_rss_flux int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_rss_flux)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rss_flux`
--


--
-- Table structure for table `rss_flux_content`
--

CREATE TABLE rss_flux_content (
  num_rss_flux int(9) unsigned NOT NULL DEFAULT '0',
  type_contenant char(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'BAN',
  num_contenant int(9) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (num_rss_flux,type_contenant,num_contenant)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rss_flux_content`
--


--
-- Table structure for table `rubriques`
--

CREATE TABLE rubriques (
  id_rubrique int(8) unsigned NOT NULL AUTO_INCREMENT,
  num_budget int(8) unsigned NOT NULL DEFAULT '0',
  num_parent int(8) unsigned NOT NULL DEFAULT '0',
  libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  commentaires text COLLATE utf8_unicode_ci NOT NULL,
  montant float(8,2) unsigned NOT NULL DEFAULT '0.00',
  num_cp_compta varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  autorisations mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_rubrique)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rubriques`
--


--
-- Table structure for table `sauv_lieux`
--

CREATE TABLE sauv_lieux (
  sauv_lieu_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  sauv_lieu_nom varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_lieu_url varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_lieu_protocol varchar(10) COLLATE utf8_unicode_ci DEFAULT 'file',
  sauv_lieu_host varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_lieu_login varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_lieu_password varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (sauv_lieu_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sauv_lieux`
--


--
-- Table structure for table `sauv_log`
--

CREATE TABLE sauv_log (
  sauv_log_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  sauv_log_start_date date DEFAULT NULL,
  sauv_log_file varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_log_succeed int(11) DEFAULT '0',
  sauv_log_messages mediumtext COLLATE utf8_unicode_ci,
  sauv_log_userid int(11) DEFAULT NULL,
  PRIMARY KEY (sauv_log_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sauv_log`
--


--
-- Table structure for table `sauv_sauvegardes`
--

CREATE TABLE sauv_sauvegardes (
  sauv_sauvegarde_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  sauv_sauvegarde_nom varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_sauvegarde_file_prefix varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_sauvegarde_tables mediumtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_lieux mediumtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_users mediumtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_compress int(11) DEFAULT '0',
  sauv_sauvegarde_compress_command mediumtext COLLATE utf8_unicode_ci,
  sauv_sauvegarde_crypt int(11) DEFAULT '0',
  sauv_sauvegarde_key1 varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_sauvegarde_key2 varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (sauv_sauvegarde_id)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sauv_sauvegardes`
--

INSERT INTO sauv_sauvegardes (sauv_sauvegarde_id, sauv_sauvegarde_nom, sauv_sauvegarde_file_prefix, sauv_sauvegarde_tables, sauv_sauvegarde_lieux, sauv_sauvegarde_users, sauv_sauvegarde_compress, sauv_sauvegarde_compress_command, sauv_sauvegarde_crypt, sauv_sauvegarde_key1, sauv_sauvegarde_key2) VALUES (1,'tout','full','1','','1',0,'internal::',0,'','');

--
-- Table structure for table `sauv_tables`
--

CREATE TABLE sauv_tables (
  sauv_table_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  sauv_table_nom varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  sauv_table_tables text COLLATE utf8_unicode_ci,
  PRIMARY KEY (sauv_table_id),
  UNIQUE KEY sauv_table_nom (sauv_table_nom)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sauv_tables`
--

INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (1,'TOUT','abo_liste_lecture,abts_abts,abts_abts_modeles,abts_grille_abt,abts_grille_modele,abts_modeles,abts_periodicites,acces_profiles,acces_rights,actes,admin_session,analysis,arch_emplacement,arch_statut,arch_type,audit,aut_link,author_custom,author_custom_lists,author_custom_values,authorities_sources,authors,authperso,authperso_authorities,authperso_custom,authperso_custom_lists,authperso_custom_values,avis,bannette_abon,bannette_contenu,bannette_equation,bannette_exports,bannette_facettes,bannette_tpl,bannettes,bannettes_descriptors,budgets,bulletins,cache_amendes,caddie,caddie_content,caddie_procs,cashdesk,cashdesk_locations,cashdesk_sections,categ_custom,categ_custom_lists,categ_custom_values,categories,classements,cms,cms_articles,cms_articles_descriptors,cms_build,cms_cache_cadres,cms_cadre_content,cms_cadres,cms_collections,cms_documents,cms_documents_links,cms_editorial_custom,cms_editorial_custom_lists,cms_editorial_custom_values,cms_editorial_fields_global_index,cms_editorial_publications_states,cms_editorial_types,cms_editorial_words_global_index,cms_hash,cms_managed_modules,cms_modules_extensions_datas,cms_pages,cms_pages_env,cms_sections,cms_sections_descriptors,cms_vars,cms_version,collection_custom,collection_custom_lists,collection_custom_values,collections,collections_state,collstate_custom,collstate_custom_lists,collstate_custom_values,comptes,connectors,connectors_categ,connectors_categ_sources,connectors_out,connectors_out_oai_deleted_records,connectors_out_oai_tokens,connectors_out_setcache_values,connectors_out_setcaches,connectors_out_setcateg_sets,connectors_out_setcategs,connectors_out_sets,connectors_out_sources,connectors_out_sources_esgroups,connectors_sources,coordonnees,demandes,demandes_actions,demandes_custom,demandes_custom_lists,demandes_custom_values,demandes_notes,demandes_theme,demandes_type,demandes_users,docs_codestat,docs_location,docs_section,docs_statut,docs_type,docsloc_section,docwatch_categories,docwatch_datasources,docwatch_items,docwatch_items_descriptors,docwatch_items_tags,docwatch_selectors,docwatch_tags,docwatch_watches,dsi_archive,editions_states,empr,empr_caddie,empr_caddie_content,empr_caddie_procs,empr_categ,empr_codestat,empr_custom,empr_custom_lists,empr_custom_values,empr_grilles,empr_groupe,empr_passwords,empr_statut,empty_words_calculs,entites,entrepot_source_1,entrepot_source_3,entrepot_source_4,entrepot_source_5,entrepot_source_6,entrepot_source_7,entrepots_localisations,equations,error_log,es_cache,es_cache_blob,es_cache_int,es_converted_cache,es_esgroup_esusers,es_esgroups,es_esusers,es_methods,es_methods_users,es_searchcache,es_searchsessions,etagere,etagere_caddie,exemplaires,exemplaires_temp,exercices,expl_custom,expl_custom_lists,expl_custom_values,explnum,explnum_doc,explnum_doc_actions,explnum_doc_sugg,explnum_location,explnum_segments,explnum_speakers,explnum_statut,external_count,facettes,faq_questions,faq_questions_categories,faq_questions_fields_global_index,faq_questions_words_global_index,faq_themes,faq_types,fiche,frais,gestfic0_custom,gestfic0_custom_lists,gestfic0_custom_values,grilles,groupe,groupexpl,groupexpl_expl,harvest_field,harvest_profil,harvest_profil_import,harvest_profil_import_field,harvest_search_field,harvest_src,import_marc,index_concept,indexint,indexint_custom,indexint_custom_lists,indexint_custom_values,infopages,lenders,liens_actes,lignes_actes,lignes_actes_relances,lignes_actes_statuts,linked_mots,log_expl_retard,log_retard,logopac,mailtpl,map_echelles,map_emprises,map_hold_areas,map_projections,map_refs,mots,noeuds,nomenclature_children_records,nomenclature_exotic_instruments,nomenclature_exotic_other_instruments,nomenclature_families,nomenclature_formations,nomenclature_instruments,nomenclature_musicstands,nomenclature_notices_nomenclatures,nomenclature_types,nomenclature_voices,nomenclature_workshops,nomenclature_workshops_instruments,notice_onglet,notice_statut,notice_tpl,notice_tplcode,notices,notices_authorities_sources,notices_authperso,notices_categories,notices_custom,notices_custom_lists,notices_custom_values,notices_externes,notices_fields_global_index,notices_global_index,notices_langues,notices_mots_global_index,notices_relations,notices_titres_uniformes,offres_remises,onto_uri,ontology_g2t,ontology_id2val,ontology_o2val,ontology_s2val,ontology_setting,ontology_triple,opac_filters,opac_liste_lecture,opac_sessions,opac_views,opac_views_empr,origin_authorities,origine_notice,ouvertures,paiements,param_subst,parametres,pclassement,perio_relance,planificateur,pret,pret_archive,pret_custom,pret_custom_lists,pret_custom_values,procs,procs_classements,publisher_custom,publisher_custom_lists,publisher_custom_values,publishers,quotas,quotas_finance,quotas_opac_views,rapport_demandes,rdfstore_g2t,rdfstore_id2val,rdfstore_index,rdfstore_o2val,rdfstore_s2val,rdfstore_setting,rdfstore_triple,recouvrements,resa,resa_archive,resa_loc,resa_planning,resa_ranger,responsability,responsability_tu,rss_content,rss_flux,rss_flux_content,rubriques,sauv_lieux,sauv_log,sauv_sauvegardes,sauv_tables,search_cache,search_perso,search_persopac,search_persopac_empr_categ,serialcirc,serialcirc_ask,serialcirc_circ,serialcirc_copy,serialcirc_diff,serialcirc_expl,serialcirc_group,serialcirc_tpl,serie_custom,serie_custom_lists,serie_custom_values,series,sessions,shorturls,skos_fields_global_index,skos_words_global_index,source_sync,sources_enrichment,statopac,statopac_request,statopac_vues,statopac_vues_col,storages,sub_collections,subcollection_custom,subcollection_custom_lists,subcollection_custom_values,suggestions,suggestions_categ,suggestions_origine,suggestions_source,sur_location,taches,taches_docnum,taches_type,tags,thesaurus,titres_uniformes,transacash,transactions,transactype,transferts,transferts_demande,transferts_source,translation,tris,tu_custom,tu_custom_lists,tu_custom_values,tu_distrib,tu_ref,tu_subdiv,tva_achats,type_abts,type_comptes,types_produits,upload_repertoire,users,users_groups,vedette,vedette_link,vedette_object,visionneuse_params,voir_aussi,words,z_attr,z_bib,z_notices,z_query');

--
-- Table structure for table `search_cache`
--

CREATE TABLE search_cache (
  object_id varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  delete_on_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `value` mediumblob NOT NULL,
  PRIMARY KEY (object_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_cache`
--


--
-- Table structure for table `search_perso`
--

CREATE TABLE search_perso (
  search_id int(8) unsigned NOT NULL AUTO_INCREMENT,
  num_user int(8) unsigned NOT NULL DEFAULT '0',
  search_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_shortname varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_query text COLLATE utf8_unicode_ci NOT NULL,
  search_human text COLLATE utf8_unicode_ci NOT NULL,
  search_directlink tinyint(1) unsigned NOT NULL DEFAULT '0',
  autorisations mediumtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (search_id)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_perso`
--


--
-- Table structure for table `search_persopac`
--

CREATE TABLE search_persopac (
  search_id int(8) unsigned NOT NULL AUTO_INCREMENT,
  num_empr int(8) unsigned NOT NULL DEFAULT '0',
  search_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_shortname varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  search_query text COLLATE utf8_unicode_ci NOT NULL,
  search_human text COLLATE utf8_unicode_ci NOT NULL,
  search_directlink tinyint(1) unsigned NOT NULL DEFAULT '0',
  search_limitsearch tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (search_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_persopac`
--


--
-- Table structure for table `search_persopac_empr_categ`
--

CREATE TABLE search_persopac_empr_categ (
  id_categ_empr int(11) NOT NULL DEFAULT '0',
  id_search_persopac int(11) NOT NULL DEFAULT '0',
  KEY i_id_s_persopac (id_search_persopac),
  KEY i_id_categ_empr (id_categ_empr)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `search_persopac_empr_categ`
--


--
-- Table structure for table `serialcirc`
--

CREATE TABLE serialcirc (
  id_serialcirc int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_abt int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_type int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_virtual int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_duration int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_checked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_retard_mode int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_allow_resa int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_allow_copy int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_allow_send_ask int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_allow_subscription int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_duration_before_send int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_statut_circ int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_statut_circ_after int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_state int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_tpl text COLLATE utf8_unicode_ci NOT NULL,
  serialcirc_piedpage text COLLATE utf8_unicode_ci NOT NULL,
  serialcirc_no_ret int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_sort_diff text COLLATE utf8_unicode_ci NOT NULL,
  serialcirc_simple int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_serialcirc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc`
--


--
-- Table structure for table `serialcirc_ask`
--

CREATE TABLE serialcirc_ask (
  id_serialcirc_ask int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_ask_perio int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_ask_serialcirc int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_ask_empr int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_ask_type int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_ask_statut int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_ask_date date NOT NULL DEFAULT '0000-00-00',
  serialcirc_ask_comment text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_serialcirc_ask)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_ask`
--


--
-- Table structure for table `serialcirc_circ`
--

CREATE TABLE serialcirc_circ (
  id_serialcirc_circ int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_circ_diff int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_circ_expl int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_circ_empr int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_circ_serialcirc int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_order int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_subscription int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_hold_asked int(11) NOT NULL DEFAULT '0',
  serialcirc_circ_ret_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_trans_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_trans_doc_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_circ_expected_date datetime DEFAULT NULL,
  serialcirc_circ_pointed_date datetime DEFAULT NULL,
  PRIMARY KEY (id_serialcirc_circ)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_circ`
--


--
-- Table structure for table `serialcirc_copy`
--

CREATE TABLE serialcirc_copy (
  id_serialcirc_copy int(11) NOT NULL AUTO_INCREMENT,
  num_serialcirc_copy_empr int(11) NOT NULL DEFAULT '0',
  num_serialcirc_copy_bulletin int(11) NOT NULL DEFAULT '0',
  serialcirc_copy_analysis text COLLATE utf8_unicode_ci,
  serialcirc_copy_date date NOT NULL DEFAULT '0000-00-00',
  serialcirc_copy_state int(11) NOT NULL DEFAULT '0',
  serialcirc_copy_comment text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_serialcirc_copy)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_copy`
--


--
-- Table structure for table `serialcirc_diff`
--

CREATE TABLE serialcirc_diff (
  id_serialcirc_diff int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_diff_serialcirc int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_diff_empr_type int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_diff_type_diff int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_diff_empr int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_diff_group_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  serialcirc_diff_duration int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_diff_order int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_serialcirc_diff)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_diff`
--


--
-- Table structure for table `serialcirc_expl`
--

CREATE TABLE serialcirc_expl (
  id_serialcirc_expl int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_expl_id int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_expl_serialcirc int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_bulletine_date date NOT NULL DEFAULT '0000-00-00',
  serialcirc_expl_state_circ int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_expl_serialcirc_diff int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_ret_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_trans_asked int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_trans_doc_asked int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_expl_current_empr int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_expl_start_date date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (id_serialcirc_expl)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_expl`
--


--
-- Table structure for table `serialcirc_group`
--

CREATE TABLE serialcirc_group (
  id_serialcirc_group int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_serialcirc_group_diff int(10) unsigned NOT NULL DEFAULT '0',
  num_serialcirc_group_empr int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_group_responsable int(10) unsigned NOT NULL DEFAULT '0',
  serialcirc_group_order int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_serialcirc_group)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_group`
--


--
-- Table structure for table `serialcirc_tpl`
--

CREATE TABLE serialcirc_tpl (
  serialcirctpl_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  serialcirctpl_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  serialcirctpl_comment varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  serialcirctpl_tpl text COLLATE utf8_unicode_ci NOT NULL,
  serialcirctpl_piedpage text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (serialcirctpl_id)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serialcirc_tpl`
--

INSERT INTO serialcirc_tpl (serialcirctpl_id, serialcirctpl_name, serialcirctpl_comment, serialcirctpl_tpl, serialcirctpl_piedpage) VALUES (1,'Template PMB','','a:3:{i:0;a:3:{s:4:\"type\";s:4:\"name\";s:2:\"id\";s:1:\"0\";s:5:\"label\";N;}i:1;a:3:{s:4:\"type\";s:5:\"ville\";s:2:\"id\";s:1:\"0\";s:5:\"label\";N;}i:2;a:3:{s:4:\"type\";s:5:\"libre\";s:2:\"id\";s:1:\"0\";s:5:\"label\";s:9:\"SIGNATURE\";}}','');

--
-- Table structure for table `serie_custom`
--

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

--
-- Dumping data for table `serie_custom`
--


--
-- Table structure for table `serie_custom_lists`
--

CREATE TABLE serie_custom_lists (
  serie_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  serie_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  serie_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY editorial_custom_champ (serie_custom_champ),
  KEY editorial_champ_list_value (serie_custom_champ,serie_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serie_custom_lists`
--


--
-- Table structure for table `serie_custom_values`
--

CREATE TABLE serie_custom_values (
  serie_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  serie_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  serie_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  serie_custom_text text COLLATE utf8_unicode_ci,
  serie_custom_integer int(11) DEFAULT NULL,
  serie_custom_date date DEFAULT NULL,
  serie_custom_float float DEFAULT NULL,
  KEY editorial_custom_champ (serie_custom_champ),
  KEY editorial_custom_origine (serie_custom_origine),
  KEY i_scv_st (serie_custom_small_text),
  KEY i_scv_t (serie_custom_text(255)),
  KEY i_scv_i (serie_custom_integer),
  KEY i_scv_d (serie_custom_date),
  KEY i_scv_f (serie_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `serie_custom_values`
--


--
-- Table structure for table `series`
--

CREATE TABLE series (
  serie_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  serie_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  serie_index text COLLATE utf8_unicode_ci,
  PRIMARY KEY (serie_id)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `series`
--

INSERT INTO series (serie_id, serie_name, serie_index) VALUES (1,'Aya de Yopougon',' aya yopougon ');
INSERT INTO series (serie_id, serie_name, serie_index) VALUES (2,'Jojo',' jojo ');
INSERT INTO series (serie_id, serie_name, serie_index) VALUES (3,'Les annales du disque-monde',' annales disque monde ');

--
-- Table structure for table `sessions`
--

CREATE TABLE sessions (
  SESSID varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  login varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  IP varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  SESSstart varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  LastOn varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  SESSNAME varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  notifications text COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `shorturls`
--

CREATE TABLE shorturls (
  id_shorturl int(10) unsigned NOT NULL AUTO_INCREMENT,
  shorturl_hash varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  shorturl_last_access datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  shorturl_context text COLLATE utf8_unicode_ci NOT NULL,
  shorturl_type varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  shorturl_action varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_shorturl)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `shorturls`
--


--
-- Table structure for table `skos_fields_global_index`
--

CREATE TABLE skos_fields_global_index (
  id_item 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_item,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 `skos_fields_global_index`
--


--
-- Table structure for table `skos_words_global_index`
--

CREATE TABLE skos_words_global_index (
  id_item 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_item,code_champ,num_word,position,code_ss_champ),
  KEY code_champ (code_champ),
  KEY i_id_mot (num_word,id_item),
  KEY i_code_champ_code_ss_champ_num_word (code_champ,code_ss_champ,num_word)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `skos_words_global_index`
--


--
-- Table structure for table `source_sync`
--

CREATE TABLE source_sync (
  source_id int(10) unsigned NOT NULL DEFAULT '0',
  nrecu varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  ntotal varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  message varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  date_sync datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  percent int(10) unsigned NOT NULL DEFAULT '0',
  env text COLLATE utf8_unicode_ci NOT NULL,
  cancel int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (source_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `source_sync`
--

INSERT INTO source_sync (source_id, nrecu, ntotal, message, date_sync, percent, env, cancel) VALUES (5,'','','','2012-12-11 18:55:08',0,'',2);

--
-- Table structure for table `sources_enrichment`
--

CREATE TABLE sources_enrichment (
  source_enrichment_num int(11) NOT NULL DEFAULT '0',
  source_enrichment_typnotice varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  source_enrichment_typdoc varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  source_enrichment_params text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (source_enrichment_num,source_enrichment_typnotice,source_enrichment_typdoc),
  KEY i_s_enrichment_typnoti (source_enrichment_typnotice),
  KEY i_s_enrichment_typdoc (source_enrichment_typdoc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sources_enrichment`
--

INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (2,'m','','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (3,'m','','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (3,'m','g','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (4,'m','g','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (3,'m','j','');
INSERT INTO sources_enrichment (source_enrichment_num, source_enrichment_typnotice, source_enrichment_typdoc, source_enrichment_params) VALUES (4,'m','j','');

--
-- Table structure for table `statopac`
--

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

--
-- Dumping data for table `statopac`
--


--
-- Table structure for table `statopac_request`
--

CREATE TABLE statopac_request (
  idproc int(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  requete blob NOT NULL,
  `comment` tinytext COLLATE utf8_unicode_ci NOT NULL,
  parameters text COLLATE utf8_unicode_ci NOT NULL,
  num_vue mediumint(8) NOT NULL DEFAULT '0',
  autorisations mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (idproc)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `statopac_request`
--


--
-- Table structure for table `statopac_vues`
--

CREATE TABLE statopac_vues (
  id_vue int(8) unsigned NOT NULL AUTO_INCREMENT,
  date_consolidation datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  nom_vue varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` tinytext COLLATE utf8_unicode_ci NOT NULL,
  date_debut_log datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_fin_log datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (id_vue)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `statopac_vues`
--


--
-- Table structure for table `statopac_vues_col`
--

CREATE TABLE statopac_vues_col (
  id_col int(8) unsigned NOT NULL AUTO_INCREMENT,
  nom_col varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  expression varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_vue mediumint(8) NOT NULL DEFAULT '0',
  ordre mediumint(8) NOT NULL DEFAULT '0',
  filtre varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  datatype varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  maj_flag int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (id_col)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `statopac_vues_col`
--


--
-- Table structure for table `storages`
--

CREATE TABLE storages (
  id_storage int(10) unsigned NOT NULL AUTO_INCREMENT,
  storage_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  storage_class varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  storage_params text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (id_storage),
  KEY i_storage_class (storage_class)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `storages`
--

INSERT INTO storages (id_storage, storage_name, storage_class, storage_params) VALUES (1,'portefolio','upload_folder_storage','a:1:{s:6:\"id_rep\";s:1:\"1\";}');

--
-- Table structure for table `sub_collections`
--

CREATE TABLE sub_collections (
  sub_coll_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  sub_coll_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  sub_coll_parent mediumint(9) unsigned NOT NULL DEFAULT '0',
  sub_coll_issn varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  index_sub_coll text COLLATE utf8_unicode_ci,
  subcollection_web text COLLATE utf8_unicode_ci NOT NULL,
  subcollection_comment text COLLATE utf8_unicode_ci NOT NULL,
  authority_import_denied int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (sub_coll_id),
  KEY sub_coll_name (sub_coll_name)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sub_collections`
--

INSERT INTO sub_collections (sub_coll_id, sub_coll_name, sub_coll_parent, sub_coll_issn, index_sub_coll, subcollection_web, subcollection_comment, authority_import_denied) VALUES (1,'Science-fiction',21,'',' science fiction ','','',0);
INSERT INTO sub_collections (sub_coll_id, sub_coll_name, sub_coll_parent, sub_coll_issn, index_sub_coll, subcollection_web, subcollection_comment, authority_import_denied) VALUES (2,'Fantastique',28,'',' fantastique ','','',0);

--
-- Table structure for table `subcollection_custom`
--

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

--
-- Dumping data for table `subcollection_custom`
--


--
-- Table structure for table `subcollection_custom_lists`
--

CREATE TABLE subcollection_custom_lists (
  subcollection_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  subcollection_custom_list_value varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  subcollection_custom_list_lib varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  ordre int(11) DEFAULT NULL,
  KEY editorial_custom_champ (subcollection_custom_champ),
  KEY editorial_champ_list_value (subcollection_custom_champ,subcollection_custom_list_value)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subcollection_custom_lists`
--


--
-- Table structure for table `subcollection_custom_values`
--

CREATE TABLE subcollection_custom_values (
  subcollection_custom_champ int(10) unsigned NOT NULL DEFAULT '0',
  subcollection_custom_origine int(10) unsigned NOT NULL DEFAULT '0',
  subcollection_custom_small_text varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  subcollection_custom_text text COLLATE utf8_unicode_ci,
  subcollection_custom_integer int(11) DEFAULT NULL,
  subcollection_custom_date date DEFAULT NULL,
  subcollection_custom_float float DEFAULT NULL,
  KEY editorial_custom_champ (subcollection_custom_champ),
  KEY editorial_custom_origine (subcollection_custom_origine),
  KEY i_scv_st (subcollection_custom_small_text),
  KEY i_scv_t (subcollection_custom_text(255)),
  KEY i_scv_i (subcollection_custom_integer),
  KEY i_scv_d (subcollection_custom_date),
  KEY i_scv_f (subcollection_custom_float)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `subcollection_custom_values`
--


--
-- Table structure for table `suggestions`
--

CREATE TABLE suggestions (
  id_suggestion int(12) unsigned NOT NULL AUTO_INCREMENT,
  titre tinytext COLLATE utf8_unicode_ci NOT NULL,
  editeur varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  auteur varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  prix float(8,2) unsigned NOT NULL DEFAULT '0.00',
  commentaires text COLLATE utf8_unicode_ci,
  commentaires_gestion text COLLATE utf8_unicode_ci,
  statut int(3) unsigned NOT NULL DEFAULT '0',
  num_produit int(8) NOT NULL DEFAULT '0',
  num_entite int(5) NOT NULL DEFAULT '0',
  index_suggestion text COLLATE utf8_unicode_ci NOT NULL,
  nb int(5) unsigned NOT NULL DEFAULT '1',
  date_creation date NOT NULL DEFAULT '0000-00-00',
  date_decision date NOT NULL DEFAULT '0000-00-00',
  num_rubrique int(8) unsigned NOT NULL DEFAULT '0',
  num_fournisseur int(5) unsigned NOT NULL DEFAULT '0',
  num_notice int(8) unsigned NOT NULL DEFAULT '0',
  url_suggestion varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_categ int(12) NOT NULL DEFAULT '1',
  sugg_location smallint(5) unsigned NOT NULL DEFAULT '0',
  sugg_source int(8) NOT NULL DEFAULT '0',
  date_publication varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  notice_unimarc blob NOT NULL,
  PRIMARY KEY (id_suggestion)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suggestions`
--


--
-- Table structure for table `suggestions_categ`
--

CREATE TABLE suggestions_categ (
  id_categ int(12) NOT NULL AUTO_INCREMENT,
  libelle_categ varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_categ)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suggestions_categ`
--

INSERT INTO suggestions_categ (id_categ, libelle_categ) VALUES (1,'catégorie par défaut');

--
-- Table structure for table `suggestions_origine`
--

CREATE TABLE suggestions_origine (
  origine varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_suggestion int(12) unsigned NOT NULL DEFAULT '0',
  type_origine int(3) unsigned NOT NULL DEFAULT '0',
  date_suggestion date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (origine,num_suggestion,type_origine),
  KEY i_origine (origine,type_origine)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suggestions_origine`
--


--
-- Table structure for table `suggestions_source`
--

CREATE TABLE suggestions_source (
  id_source int(8) unsigned NOT NULL AUTO_INCREMENT,
  libelle_source varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_source)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `suggestions_source`
--


--
-- Table structure for table `sur_location`
--

CREATE TABLE sur_location (
  surloc_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  surloc_libelle varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_pic varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_visible_opac tinyint(1) unsigned NOT NULL DEFAULT '1',
  surloc_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_adr1 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_adr2 varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_cp varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_town varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_state varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_country varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_phone varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_email varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_website varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_logo varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  surloc_comment text COLLATE utf8_unicode_ci NOT NULL,
  surloc_num_infopage int(6) unsigned NOT NULL DEFAULT '0',
  surloc_css_style varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (surloc_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sur_location`
--


--
-- Table structure for table `taches`
--

CREATE TABLE taches (
  id_tache int(11) unsigned NOT NULL AUTO_INCREMENT,
  num_planificateur int(11) DEFAULT NULL,
  start_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  end_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  msg_statut blob,
  commande int(8) NOT NULL DEFAULT '0',
  next_state int(8) NOT NULL DEFAULT '0',
  msg_commande blob,
  indicat_progress int(3) DEFAULT NULL,
  rapport text COLLATE utf8_unicode_ci,
  id_process int(8) DEFAULT NULL,
  PRIMARY KEY (id_tache)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `taches`
--


--
-- Table structure for table `taches_docnum`
--

CREATE TABLE taches_docnum (
  id_tache_docnum int(11) unsigned NOT NULL AUTO_INCREMENT,
  tache_docnum_nomfichier varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  tache_docnum_mimetype varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  tache_docnum_data mediumblob NOT NULL,
  tache_docnum_extfichier varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  tache_docnum_repertoire int(8) DEFAULT NULL,
  tache_docnum_path text COLLATE utf8_unicode_ci NOT NULL,
  num_tache int(11) NOT NULL,
  PRIMARY KEY (id_tache_docnum)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `taches_docnum`
--


--
-- Table structure for table `taches_type`
--

CREATE TABLE taches_type (
  id_type_tache int(11) unsigned NOT NULL,
  parameters text COLLATE utf8_unicode_ci NOT NULL,
  timeout int(11) NOT NULL DEFAULT '5',
  histo_day int(11) NOT NULL DEFAULT '7',
  histo_number int(11) NOT NULL DEFAULT '3',
  restart_on_failure int(1) unsigned NOT NULL DEFAULT '0',
  alert_mail_on_failure varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  PRIMARY KEY (id_type_tache)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `taches_type`
--


--
-- Table structure for table `tags`
--

CREATE TABLE tags (
  id_tag mediumint(8) NOT NULL AUTO_INCREMENT,
  libelle varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  num_notice mediumint(8) NOT NULL DEFAULT '0',
  user_code varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  dateajout timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id_tag)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tags`
--


--
-- Table structure for table `thesaurus`
--

CREATE TABLE thesaurus (
  id_thesaurus int(3) unsigned NOT NULL AUTO_INCREMENT,
  libelle_thesaurus varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  langue_defaut varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr_FR',
  active char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  opac_active char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
  num_noeud_racine int(9) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_thesaurus),
  UNIQUE KEY libelle_thesaurus (libelle_thesaurus)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `thesaurus`
--

INSERT INTO thesaurus (id_thesaurus, libelle_thesaurus, langue_defaut, active, opac_active, num_noeud_racine) VALUES (1,'Agneaux','fr_FR','1','1',1);

--
-- Table structure for table `titres_uniformes`
--

CREATE TABLE titres_uniformes (
  tu_id int(9) unsigned NOT NULL AUTO_INCREMENT,
  tu_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_tonalite varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_comment text COLLATE utf8_unicode_ci NOT NULL,
  index_tu text COLLATE utf8_unicode_ci NOT NULL,
  tu_import_denied int(10) unsigned NOT NULL DEFAULT '0',
  tu_num_author bigint(11) unsigned NOT NULL DEFAULT '0',
  tu_forme varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_date varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_date_date date NOT NULL DEFAULT '0000-00-00',
  tu_sujet text COLLATE utf8_unicode_ci NOT NULL,
  tu_lieu varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_histoire text COLLATE utf8_unicode_ci,
  tu_caracteristique text COLLATE utf8_unicode_ci,
  tu_public varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_contexte text COLLATE utf8_unicode_ci,
  tu_coordonnees varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_equinoxe varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_completude int(2) unsigned NOT NULL DEFAULT '0',
  tu_tonalite_marclist varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tu_forme_marclist varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (tu_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `titres_uniformes`
--


--
-- Table structure for table `transacash`
--

CREATE TABLE transacash (
  transacash_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  transacash_empr_num int(10) unsigned NOT NULL DEFAULT '0',
  transacash_desk_num int(10) unsigned NOT NULL DEFAULT '0',
  transacash_user_num int(10) unsigned NOT NULL DEFAULT '0',
  transacash_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  transacash_sold float NOT NULL DEFAULT '0',
  transacash_collected float NOT NULL DEFAULT '0',
  transacash_rendering float NOT NULL DEFAULT '0',
  PRIMARY KEY (transacash_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transacash`
--


--
-- Table structure for table `transactions`
--

CREATE TABLE transactions (
  id_transaction int(10) unsigned NOT NULL AUTO_INCREMENT,
  compte_id int(8) unsigned NOT NULL DEFAULT '0',
  user_id int(10) unsigned NOT NULL DEFAULT '0',
  user_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  machine varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  date_enrgt datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  date_prevue date DEFAULT NULL,
  date_effective date DEFAULT NULL,
  montant decimal(16,2) NOT NULL DEFAULT '0.00',
  sens int(1) NOT NULL DEFAULT '0',
  realisee int(1) NOT NULL DEFAULT '0',
  commentaire text COLLATE utf8_unicode_ci,
  encaissement int(1) NOT NULL DEFAULT '0',
  transactype_num int(10) unsigned NOT NULL DEFAULT '0',
  cashdesk_num int(10) unsigned NOT NULL DEFAULT '0',
  transacash_num int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_transaction)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO transactions (id_transaction, compte_id, user_id, user_name, machine, date_enrgt, date_prevue, date_effective, montant, sens, realisee, commentaire, encaissement, transactype_num, cashdesk_num, transacash_num) VALUES (1,1,1,'admin','127.0.0.1','2012-10-24 10:47:37','2012-10-24',NULL,2.85,-1,0,'Amende exemplaire 30',0,0,0,0);

--
-- Table structure for table `transactype`
--

CREATE TABLE transactype (
  transactype_id int(10) unsigned NOT NULL AUTO_INCREMENT,
  transactype_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  transactype_quick_allowed int(10) unsigned NOT NULL DEFAULT '0',
  transactype_unit_price float NOT NULL DEFAULT '0',
  PRIMARY KEY (transactype_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transactype`
--


--
-- Table structure for table `transferts`
--

CREATE TABLE transferts (
  id_transfert int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_notice int(10) unsigned NOT NULL DEFAULT '0',
  num_bulletin int(10) unsigned NOT NULL DEFAULT '0',
  date_creation date NOT NULL,
  type_transfert int(5) unsigned NOT NULL DEFAULT '0',
  etat_transfert tinyint(3) unsigned NOT NULL DEFAULT '0',
  origine int(5) unsigned NOT NULL DEFAULT '0',
  origine_comp varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `source` smallint(5) unsigned DEFAULT NULL,
  destinations varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  date_retour date DEFAULT NULL,
  motif varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (id_transfert),
  KEY etat_transfert (etat_transfert)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transferts`
--


--
-- Table structure for table `transferts_demande`
--

CREATE TABLE transferts_demande (
  id_transfert_demande int(10) unsigned NOT NULL AUTO_INCREMENT,
  num_transfert int(10) unsigned NOT NULL DEFAULT '0',
  date_creation date NOT NULL,
  sens_transfert tinyint(3) unsigned NOT NULL DEFAULT '0',
  num_location_source smallint(5) unsigned NOT NULL DEFAULT '0',
  num_location_dest smallint(5) unsigned NOT NULL DEFAULT '0',
  num_expl int(10) unsigned NOT NULL DEFAULT '0',
  etat_demande tinyint(3) unsigned NOT NULL DEFAULT '0',
  date_visualisee date DEFAULT NULL,
  date_envoyee date DEFAULT NULL,
  date_reception date DEFAULT NULL,
  motif_refus varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  statut_origine int(10) unsigned NOT NULL DEFAULT '0',
  section_origine int(10) unsigned NOT NULL DEFAULT '0',
  resa_trans int(8) unsigned NOT NULL DEFAULT '0',
  resa_arc_trans int(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (id_transfert_demande),
  KEY num_transfert (num_transfert),
  KEY num_location_source (num_location_source),
  KEY num_location_dest (num_location_dest),
  KEY num_expl (num_expl)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transferts_demande`
--


--
-- Table structure for table `transferts_source`
--

CREATE TABLE transferts_source (
  trans_source_numexpl int(10) unsigned NOT NULL DEFAULT '0',
  trans_source_numloc int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (trans_source_numexpl)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `transferts_source`
--


--
-- Table structure for table `translation`
--

CREATE TABLE translation (
  trans_table varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  trans_field varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  trans_lang varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  trans_num int(8) unsigned NOT NULL DEFAULT '0',
  trans_text varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (trans_table,trans_field,trans_lang,trans_num),
  KEY i_lang (trans_lang)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `translation`
--


--
-- Table structure for table `tris`
--

CREATE TABLE tris (
  id_tri int(4) NOT NULL AUTO_INCREMENT,
  tri_par varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  nom_tri varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  tri_reference varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'notices',
  PRIMARY KEY (id_tri)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tris`
--

INSERT INTO tris (id_tri, tri_par, nom_tri, tri_reference) VALUES (3,'d_num_6,c_text_28','','notices');

--
-- Table structure for table `tu_custom`
--

