-- Quickstart essential data for PMB 
-- 2010-Sep-21 17:57:26
-- $Id: feed_essential.sql,v 1.23 2010-09-21 15:58:19 touraine37 Exp $
set names 'utf8';

--
-- Dumping data for table `caddie`
--
INSERT INTO `caddie` (`idcaddie`, `name`, `type`, `comment`, `autorisations`) VALUES (1,'Notices pour exposition','NOTI','Placer dans ce panier les notices de l\'expo virtuelle','1 2');
INSERT INTO `caddie` (`idcaddie`, `name`, `type`, `comment`, `autorisations`) VALUES (2,'Notices pour retour BDP','NOTI','Remplir ce panier à l\'issue du pointage des exemplaires en retour','1 2');
INSERT INTO `caddie` (`idcaddie`, `name`, `type`, `comment`, `autorisations`) VALUES (3,'Exemplaires pour retour BDP','EXPL','Placer dans ce panier les exemplaires de documents à rendre à la BDP','1 2');
INSERT INTO `caddie` (`idcaddie`, `name`, `type`, `comment`, `autorisations`) VALUES (4,'Notices en doublons sur titre','NOTI','Doublons sur le premier titre','1 2');
INSERT INTO `caddie` (`idcaddie`, `name`, `type`, `comment`, `autorisations`) VALUES (8,'Exemple de panier d\'exemplaires','EXPL','','1 4 3 2');
INSERT INTO `caddie` (`idcaddie`, `name`, `type`, `comment`, `autorisations`) VALUES (5,'Loire - Notices pour thème du mois','NOTI','','1 4');
INSERT INTO `caddie` (`idcaddie`, `name`, `type`, `comment`, `autorisations`) VALUES (6,'Loire - Bulletins contenant des articles pour expo mois','BULL','','1 4');
INSERT INTO `caddie` (`idcaddie`, `name`, `type`, `comment`, `autorisations`) VALUES (7,'Cochon - notices pour exposition mois prochain','NOTI','','1');

--
-- Dumping data for table `caddie_procs`
--
INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (1,'SELECT','Notices par auteur',0x53454C454354206E6F746963655F6964206173206F626A6563745F69642C20274E4F544927206173206F626A6563745F747970652046524F4D206E6F74696365732C20617574686F72732C20726573706F6E736162696C69747920574845524520617574686F725F6E616D65206C696B652027252121637269746572652121252720414E4420617574686F725F69643D726573706F6E736162696C6974795F617574686F7220414E44206E6F746963655F69643D726573706F6E736162696C6974795F6E6F746963650D0A,'Sélection des notices dont le nom de l\'auteur contient certaines lettres','1 2 3','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"critere\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Caractères contenus dans le nom]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR=\"text\">\r\n <SIZE>25</SIZE>\r\n <MAXSIZE>25</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (2,'SELECT','Notices en doublons',0x6372656174652054454D504F52415259205441424C4520746D702053454C45435420746974312046524F4D206E6F7469636573205748455245206E69766561755F6269626C696F3D276D2720414E4420747970646F6320213D276C272047524F5550204259207469743120484156494E4720636F756E74282A293E313B0D0A53454C454354206E6F746963655F6964206173206F626A6563745F69642C20274E4F544927206173206F626A6563745F747970652046524F4D206E6F74696365732C20746D70205748455245206E6F74696365732E746974313D746D702E7469743120414E44206E69766561755F6269626C696F3D276D2720414E4420747970646F6320213D276C27,'Sélection des notices en doublons sur le premier titre','1 2 3',NULL);
INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (3,'SELECT','EXPL par section / propriétaire',0x73656C656374206578706C5F6964206173206F626A6563745F69642C20274558504C27206173206F626A6563745F747970652066726F6D206578656D706C6169726573207768657265206578706C5F73656374696F6E20696E2028212173656374696F6E21212920616E64206578706C5F6F776E65723D212170726F7072696F2121,'Sélection d\'exemplaires par section par propriétaire','1 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"section\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Section]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select idsection, section_libelle from docs_section order by section_libelle]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME=\"proprio\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Propriétaire]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select idlender, lender_libelle from lenders order by lender_libelle</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (4,'SELECT','EXPL où cote commence par',0x73656C656374206578706C5F6964206173206F626A6563745F69642C20274558504C27206173206F626A6563745F747970652066726F6D206578656D706C6169726573207768657265206578706C5F636F7465206C696B6520272121636F6D6D655F636F746521212527,'Sélection d\'exemplaire à partir du début de cote','1 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"comme_cote\" MANDATORY=\"no\">\n  <ALIAS><![CDATA[Début de la cote]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR=\"text\">\r\n <SIZE>20</SIZE>\r\n <MAXSIZE>20</MAXSIZE>\r\n</OPTIONS> \n </FIELD>\n</FIELDS>');
INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (5,'ACTION','Changement de statut des exemplaires',0x757064617465206578656D706C616972657320736574206578706C5F7374617475743D21216E6F75766561755F7374617475742121207768657265206578706C5F696420696E2028434144444945284558504C2929,'Permet de changer le statut des exemplaires d\'un panier','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"nouveau_statut\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[nouveau_statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>SELECT idstatut, statut_libelle FROM docs_statut</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (6,'SELECT','Jamais prêtés',0x53454C454354206578706C5F6964206173206F626A6563745F69642C20274558504C27206173206F626A6563745F747970652C20636F6E63617428224C4956524520222C74697431292061732054697472652046524F4D206E6F7469636573206A6F696E206578656D706C6169726573206F6E206578706C5F6E6F746963653D6E6F746963655F6964204C454654204A4F494E20707265745F61726368697665204F4E206172635F6578706C5F6E6F74696365203D206E6F746963655F6964207768657265206172635F6578706C5F6964204953204E554C4C20414E44206578706C5F6964204953204E4F54204E554C4C20554E494F4E2053454C454354206578706C5F6964206173206F626A6563745F69642C20274558504C27206173206F626A6563745F747970652C20636F6E6361742822504552494F20222C746974312C2022204E756DE9726F203A20222C62756C6C6574696E5F6E756D65726F292061732054697472652046524F4D202862756C6C6574696E7320494E4E4552204A4F494E206E6F7469636573204F4E2062756C6C6574696E732E62756C6C6574696E5F6E6F74696365203D206E6F74696365732E6E6F746963655F69642920494E4E4552204A4F494E206578656D706C6169726573206F6E206578706C5F62756C6C6574696E3D62756C6C6574696E5F6964204C454654204A4F494E20707265745F61726368697665204F4E206578706C5F6964203D206172635F6578706C5F696420574845524520707265745F617263686976652E6172635F6964204973204E756C6C,'Ajoute dans un panier les exemplaires jamais prêtés','1 2',NULL);
INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (7,'SELECT','Sélection d\'exemplaires par statut',0x73656C656374206578706C5F6964206173206F626A6563745F69642C20274558504C27206173206F626A6563745F747970652066726F6D206578656D706C6169726573207768657265206578706C5F73746174757420696E20282121737461747574212129,'','1 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"statut\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select idstatut, statut_libelle from docs_statut]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (8,'SELECT','Sélection d\'exemplaires par localisation, section, statut, propriétaire',0x73656C656374206578706C5F6964206173206F626A6563745F69642C20274558504C27206173206F626A6563745F747970652066726F6D206578656D706C6169726573207768657265206578706C5F73656374696F6E20696E2028212173656374696F6E21212920616E64206578706C5F6C6F636174696F6E20696E202821216C6F636174696F6E21212920616E64206578706C5F73746174757420696E2028212173746174757421212920616E64206578706C5F6F776E65723D212170726F7072696F21212020,'','1 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"section\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Section]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select idsection, section_libelle from docs_section order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME=\"location\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Localisation]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select idlocation, location_libelle from docs_location order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME=\"statut\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select idstatut, statut_libelle from docs_statut order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME=\"proprio\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Propriétaire]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select idlender, lender_libelle from lenders order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `caddie_procs` (`idproc`, `type`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (9,'ACTION','Changement de section des exemplaires',0x757064617465206578656D706C616972657320736574206578706C5F73656374696F6E3D21216E6F7576656C6C655F73656374696F6E2121207768657265206578706C5F696420696E2028434144444945284558504C2929,'','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"nouvelle_section\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[nouvelle section]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select * from docs_section order by section_libelle]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[Choisissez une section]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');

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

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

--
-- Dumping data for table `docs_location`
--
INSERT INTO `docs_location` (`idlocation`, `location_libelle`, `locdoc_codage_import`, `locdoc_owner`, `location_pic`, `location_visible_opac`, `name`, `adr1`, `adr2`, `cp`, `town`, `state`, `country`, `phone`, `email`, `website`, `logo`, `commentaire`, `transfert_ordre`, `transfert_statut_defaut`, `num_infopage`, `css_style`) VALUES (1,'Bibliothèque principale','',2,'images/site/bib_princ.jpg',1,'Bibliothèque test de PMB','PMB Services','ZI de Mont/Loir','72500','CHATEAU DU LOIR','','France','02 43 440 660','pmb@sigb.net','http://www.sigb.net/','logo_default.jpg','',9999,0,0,'');
INSERT INTO `docs_location` (`idlocation`, `location_libelle`, `locdoc_codage_import`, `locdoc_owner`, `location_pic`, `location_visible_opac`, `name`, `adr1`, `adr2`, `cp`, `town`, `state`, `country`, `phone`, `email`, `website`, `logo`, `commentaire`, `transfert_ordre`, `transfert_statut_defaut`, `num_infopage`, `css_style`) VALUES (2,'Réserve','',2,'',0,'Bibliothèque test de PMB','','','','','','','','pmb@sigb.net','http://www.sigb.net','logo_default.jpg','',9999,0,0,'');
INSERT INTO `docs_location` (`idlocation`, `location_libelle`, `locdoc_codage_import`, `locdoc_owner`, `location_pic`, `location_visible_opac`, `name`, `adr1`, `adr2`, `cp`, `town`, `state`, `country`, `phone`, `email`, `website`, `logo`, `commentaire`, `transfert_ordre`, `transfert_statut_defaut`, `num_infopage`, `css_style`) VALUES (7,'Bibliobus','',2,'images/site/bibliobus.jpg',1,'Bibliothèque test de PMB','Bibliobus','','72500','Château du loir','','France','02 43 440 660','pmb@sigb.net','http://www.sigb.net','logo_default.jpg','',9999,0,0,'');

--
-- Dumping data for table `docs_section`
--
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (10,'Documentaires','',2,'images/site/documentaire.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (11,'Documentaires Enfants','',2,'images/site/documentaire.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (12,'Romans Enfants','',2,'images/site/enfants.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (13,'Romans Jeunes','',2,'images/site/sec3.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (16,'Bande-dessinée Adultes','',2,'images/site/sec1.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (17,'Bande-dessinée Enfants','',2,'images/site/enfants.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (18,'H (Histoire locale)','',2,'images/site/histoire.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (19,'FR (Fonds Régional)','',2,'images/site/sec4.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (20,'Bande-dessinée Jeunes','',2,'images/site/sec3.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (21,'Romans policiers','',2,'images/site/sec1.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (23,'Romans Large vue','',2,'images/site/large_vue.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (24,'Romans & Romans étrangers','',2,'images/site/sec1.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (25,'Documentaires Jeunes','',2,'images/site/documentaire.jpg',1);
INSERT INTO `docs_section` (`idsection`, `section_libelle`, `sdoc_codage_import`, `sdoc_owner`, `section_pic`, `section_visible_opac`) VALUES (26,'Albums Enfants','',2,'images/site/enfants.jpg',1);

--
-- Dumping data for table `docs_statut`
--
INSERT INTO `docs_statut` (`idstatut`, `statut_libelle`, `pret_flag`, `statusdoc_codage_import`, `statusdoc_owner`, `transfert_flag`) VALUES (1,'Document en bon état',1,'',0,1);
INSERT INTO `docs_statut` (`idstatut`, `statut_libelle`, `pret_flag`, `statusdoc_codage_import`, `statusdoc_owner`, `transfert_flag`) VALUES (2,'En cours d\'import/saisie',0,'',0,1);
INSERT INTO `docs_statut` (`idstatut`, `statut_libelle`, `pret_flag`, `statusdoc_codage_import`, `statusdoc_owner`, `transfert_flag`) VALUES (11,'Détérioré',0,'',0,1);
INSERT INTO `docs_statut` (`idstatut`, `statut_libelle`, `pret_flag`, `statusdoc_codage_import`, `statusdoc_owner`, `transfert_flag`) VALUES (12,'Perdu',0,'',0,1);
INSERT INTO `docs_statut` (`idstatut`, `statut_libelle`, `pret_flag`, `statusdoc_codage_import`, `statusdoc_owner`, `transfert_flag`) VALUES (13,'Consultation sur place',0,'',0,1);
INSERT INTO `docs_statut` (`idstatut`, `statut_libelle`, `pret_flag`, `statusdoc_codage_import`, `statusdoc_owner`, `transfert_flag`) VALUES (14,'En dépôt',0,'',0,1);

--
-- Dumping data for table `docs_type`
--
INSERT INTO `docs_type` (`idtyp_doc`, `tdoc_libelle`, `duree_pret`, `duree_resa`, `tdoc_owner`, `tdoc_codage_import`, `tarif_pret`) VALUES (1,'Livre',14,15,2,'','0.00');
INSERT INTO `docs_type` (`idtyp_doc`, `tdoc_libelle`, `duree_pret`, `duree_resa`, `tdoc_owner`, `tdoc_codage_import`, `tarif_pret`) VALUES (12,'Cassette vidéo',14,15,2,'','0.00');
INSERT INTO `docs_type` (`idtyp_doc`, `tdoc_libelle`, `duree_pret`, `duree_resa`, `tdoc_owner`, `tdoc_codage_import`, `tarif_pret`) VALUES (13,'CD audio',14,15,2,'','0.00');
INSERT INTO `docs_type` (`idtyp_doc`, `tdoc_libelle`, `duree_pret`, `duree_resa`, `tdoc_owner`, `tdoc_codage_import`, `tarif_pret`) VALUES (14,'DVD',5,15,2,'','0.00');
INSERT INTO `docs_type` (`idtyp_doc`, `tdoc_libelle`, `duree_pret`, `duree_resa`, `tdoc_owner`, `tdoc_codage_import`, `tarif_pret`) VALUES (15,'Oeuvre d\'art',5,15,2,'','0.00');
INSERT INTO `docs_type` (`idtyp_doc`, `tdoc_libelle`, `duree_pret`, `duree_resa`, `tdoc_owner`, `tdoc_codage_import`, `tarif_pret`) VALUES (16,'Cartes et plans',31,15,2,'','0.00');
INSERT INTO `docs_type` (`idtyp_doc`, `tdoc_libelle`, `duree_pret`, `duree_resa`, `tdoc_owner`, `tdoc_codage_import`, `tarif_pret`) VALUES (17,'Cédéroms',10,5,2,'','0.00');
INSERT INTO `docs_type` (`idtyp_doc`, `tdoc_libelle`, `duree_pret`, `duree_resa`, `tdoc_owner`, `tdoc_codage_import`, `tarif_pret`) VALUES (18,'Périodique',8,5,0,'','0.00');

--
-- Dumping data for table `empr_categ`
--
INSERT INTO `empr_categ` (`id_categ_empr`, `libelle`, `duree_adhesion`, `tarif_abt`) VALUES (1,'Enfants',365,'0.00');
INSERT INTO `empr_categ` (`id_categ_empr`, `libelle`, `duree_adhesion`, `tarif_abt`) VALUES (2,'Retraité',365,'0.00');
INSERT INTO `empr_categ` (`id_categ_empr`, `libelle`, `duree_adhesion`, `tarif_abt`) VALUES (3,'Employés',365,'0.00');
INSERT INTO `empr_categ` (`id_categ_empr`, `libelle`, `duree_adhesion`, `tarif_abt`) VALUES (4,'Sans emploi',365,'0.00');
INSERT INTO `empr_categ` (`id_categ_empr`, `libelle`, `duree_adhesion`, `tarif_abt`) VALUES (5,'Lycéens/étudiants',365,'0.00');
INSERT INTO `empr_categ` (`id_categ_empr`, `libelle`, `duree_adhesion`, `tarif_abt`) VALUES (6,'Collégiens',365,'0.00');
INSERT INTO `empr_categ` (`id_categ_empr`, `libelle`, `duree_adhesion`, `tarif_abt`) VALUES (7,'Adultes',365,'0.00');

--
-- Dumping data for table `empr_codestat`
--
INSERT INTO `empr_codestat` (`idcode`, `libelle`) VALUES (2,'Communauté de Communes');
INSERT INTO `empr_codestat` (`idcode`, `libelle`) VALUES (3,'Commune');
INSERT INTO `empr_codestat` (`idcode`, `libelle`) VALUES (4,'Département');
INSERT INTO `empr_codestat` (`idcode`, `libelle`) VALUES (5,'Europe');
INSERT INTO `empr_codestat` (`idcode`, `libelle`) VALUES (6,'Hors europe');
INSERT INTO `empr_codestat` (`idcode`, `libelle`) VALUES (7,'France');

--
-- Dumping data for table `etagere`
--
INSERT INTO `etagere` (`idetagere`, `name`, `comment`, `validite`, `validite_date_deb`, `validite_date_fin`, `visible_accueil`, `autorisations`) VALUES (3,'Loire',0x4578706F736974696F6E207669727475656C6C6520737572206C61204C6F697265,1,'0000-00-00','0000-00-00',1,'1 4 3 2');

--
-- Dumping data for table `etagere_caddie`
--
INSERT INTO `etagere_caddie` (`etagere_id`, `caddie_id`) VALUES (3,5);

--
-- Dumping data for table `procs`
--
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`, `num_classement`, `proc_notice_tpl`, `proc_notice_tpl_field`) VALUES (1,'Liste exemplaires / statut',0x73656C656374206578706C5F636F746520617320436F74652C206578706C5F63622061732022436F64652D626172726573222C2043415345205748454E206578706C5F6E6F746963653E30205448454E20636F6E6361742843415345205748454E2073657269655F6E616D65204953204E4F54204E554C4C205448454E20434F4E4341542873657269655F6E616D652C2022203A20222920454C534520222220454E442C206E312E746974312920454C534520434F4E434154286E322E746974312C2220222C62756C6C6574696E5F6E756D65726F2C2220222920454E442061732054697472652066726F6D206578656D706C6169726573206C656674206A6F696E206E6F7469636573206E31206F6E206578706C5F6E6F746963653D6E312E6E6F746963655F6964206C656674206A6F696E20736572696573206F6E206E312E74706172656E745F69643D73657269655F6964206C656674206A6F696E2062756C6C6574696E73206F6E206578706C5F62756C6C6574696E3D62756C6C6574696E5F6964206C656674206A6F696E206E6F7469636573206E32206F6E2062756C6C6574696E5F6E6F746963653D6E322E6E6F746963655F6964207768657265206578706C5F7374617475743D2121706172616D312121206F72646572206279206578706C5F636F7465,'Liste paramétrée d\'exemplaires par statut ','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"param1\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select idstatut,statut_libelle from docs_statut]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[Choisissez un statut]]></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 (2,'Comptage exemplaires / statut',0x73656C656374207374617475745F6C6962656C6C65206173205374617475742C20636F756E74282A29206173204E6F6D6272652066726F6D206578656D706C61697265732C20646F63735F7374617475742077686572652069647374617475743D6578706C5F7374617475742067726F7570206279207374617475745F6C6962656C6C65206F72646572206279206964737461747574,'Nombre d\'exemplaires par statut d\'exemplaire','1 4 3 2',NULL,0,0,'');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`, `num_classement`, `proc_notice_tpl`, `proc_notice_tpl_field`) VALUES (3,'Comptage  exemplaires / propriétaire / statut',0x73656C656374206C656E6465725F6C6962656C6C652061732050726F707269E974616972652C207374617475745F6C6962656C6C65206173205374617475742C20636F756E74282A29206173204E6F6D6272652066726F6D206578656D706C61697265732C206C656E646572732C20646F63735F737461747574207768657265206578706C5F6F776E65723D69646C656E64657220616E64206578706C5F7374617475743D69647374617475742067726F7570206279206C656E6465725F6C6962656C6C652C7374617475745F6C6962656C6C65206F72646572206279206C656E6465725F6C6962656C6C652C7374617475745F6C6962656C6C6520,'Nombre d\'exemplaires par propriétaire et par statut d\'exemplaire','1 4 3 2',NULL,0,0,'');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`, `num_classement`, `proc_notice_tpl`, `proc_notice_tpl_field`) VALUES (4,'Liste exemplaires d\'un propriétaire / statut',0x73656C656374206C656E6465725F6C6962656C6C652061732050726F707269E974616972652C207374617475745F6C6962656C6C65206173205374617475742C206578706C5F636F746520617320436F74652C206578706C5F63622061732022436F64652D626172726573222C2043415345205748454E206578706C5F6E6F746963653E30205448454E20636F6E6361742843415345205748454E2073657269655F6E616D65204953204E4F54204E554C4C205448454E20434F4E4341542873657269655F6E616D652C2022203A20222920454C534520222220454E442C206E312E746974312920454C534520434F4E434154286E322E746974312C2220222C62756C6C6574696E5F6E756D65726F2C2220222920454E442061732054697472652066726F6D20646F63735F7374617475742C206C656E646572732C206578656D706C6169726573206C656674206A6F696E206E6F7469636573206E31206F6E206578706C5F6E6F746963653D6E312E6E6F746963655F6964206C656674206A6F696E20736572696573206F6E206E312E74706172656E745F69643D73657269655F6964206C656674206A6F696E2062756C6C6574696E73206F6E206578706C5F62756C6C6574696E3D62756C6C6574696E5F6964206C656674206A6F696E206E6F7469636573206E32206F6E2062756C6C6574696E5F6E6F746963653D6E322E6E6F746963655F6964207768657265206578706C5F7374617475743D2121737461747574212120616E64206578706C5F6F776E65723D212150726F707269657461697265212120616E64206578706C5F7374617475743D696473746174757420616E64206578706C5F6F776E65723D69646C656E646572206F72646572206279206C656E6465725F6C6962656C6C652C207374617475745F6C6962656C6C652C206578706C5F636F74652C206578706C5F636220,'Liste d\'exemplaires d\'un propriétaire par statut, cote, code-barre, titre (pratique pour lister les documents non pointés après l\'import)','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"statut\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select idstatut, statut_libelle from docs_statut</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME=\"Proprietaire\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Proprietaire]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select idlender, lender_libelle from lenders</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 (5,'Comptage exemplaires / section',0x73656C6563742073656374696F6E5F6C6962656C6C652061732053656374696F6E2C20636F756E74282A29206173204E6F6D6272652066726F6D206578656D706C61697265732C20646F63735F73656374696F6E20776865726520696473656374696F6E3D6578706C5F73656374696F6E2067726F757020627920696473656374696F6E2C2073656374696F6E5F6C6962656C6C65206F7264657220627920696473656374696F6E,'Nombre d\'exemplaires par section','1 4 3 2',NULL,0,0,'');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`, `num_classement`, `proc_notice_tpl`, `proc_notice_tpl_field`) VALUES (6,'Liste exemplaires pour une ou plusieurs sections par propriétaire',0x73656C6563742073656374696F6E5F6C6962656C6C652061732053656374696F6E2C206578706C5F636F746520617320436F74652C206578706C5F63622061732022436F64652D626172726573222C2043415345205748454E206578706C5F6E6F746963653E30205448454E20636F6E6361742843415345205748454E2073657269655F6E616D65204953204E4F54204E554C4C205448454E20434F4E4341542873657269655F6E616D652C2022203A20222920454C534520222220454E442C206E312E746974312920454C534520434F4E434154286E322E746974312C2220222C62756C6C6574696E5F6E756D65726F2C2220222920454E442061732054697472652066726F6D20646F63735F73656374696F6E2C206C656E646572732C206578656D706C6169726573206C656674206A6F696E206E6F7469636573206E31206F6E206578706C5F6E6F746963653D6E312E6E6F746963655F6964206C656674206A6F696E20736572696573206F6E206E312E74706172656E745F69643D73657269655F6964206C656674206A6F696E2062756C6C6574696E73206F6E206578706C5F62756C6C6574696E3D62756C6C6574696E5F6964206C656674206A6F696E206E6F7469636573206E32206F6E2062756C6C6574696E5F6E6F746963653D6E322E6E6F746963655F696420776865726520696473656374696F6E20696E2028212173656374696F6E7321212920616E64206578706C5F6F776E65723D212170726574657572212120616E64206578706C5F73656374696F6E3D696473656374696F6E20616E64206578706C5F6F776E65723D69646C656E646572206F726465722062792073656374696F6E5F6C6962656C6C652C206578706C5F636F74652C206578706C5F636220,'Liste des exemplaires ayant une ou plusieurs sections particulières pour un prêteur','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"sections\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Section(s)]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select idsection, section_libelle from docs_section]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME=\"preteur\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Prêteur]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY><![CDATA[select idlender, lender_libelle from lenders order by idlender]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[Choisissez un prêteur]]></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 (7,'Stat : Compte exemplaires / propriétaire',0x73656C656374206C656E6465725F6C6962656C6C652061732050726F707269E974616972652C20636F756E74282A29206173204E6F6D6272652066726F6D206578656D706C61697265732C206C656E646572732077686572652069646C656E6465723D6578706C5F6F776E65722067726F7570206279206578706C5F6F776E65722C206C656E6465725F6C6962656C6C65,'Nbre d\'exemplaires par propriétaire d\'exemplaire','1 4 3 2',NULL,0,0,'');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`, `num_classement`, `proc_notice_tpl`, `proc_notice_tpl_field`) VALUES (8,'Liste exemplaires pour un propriétaire',0x73656C656374206578706C5F636F746520617320436F74652C206578706C5F63622061732022436F64652D626172726573222C2043415345205748454E206578706C5F6E6F746963653E30205448454E20636F6E6361742843415345205748454E2073657269655F6E616D65204953204E4F54204E554C4C205448454E20434F4E4341542873657269655F6E616D652C2022203A20222920454C534520222220454E442C206E312E746974312920454C534520434F4E434154286E322E746974312C2220222C62756C6C6574696E5F6E756D65726F2C2220222920454E442061732054697472652066726F6D20646F63735F7374617475742C206C656E646572732C206578656D706C6169726573206C656674206A6F696E206E6F7469636573206E31206F6E206578706C5F6E6F746963653D6E312E6E6F746963655F6964206C656674206A6F696E20736572696573206F6E206E312E74706172656E745F69643D73657269655F6964206C656674206A6F696E2062756C6C6574696E73206F6E206578706C5F62756C6C6574696E3D62756C6C6574696E5F6964206C656674206A6F696E206E6F7469636573206E32206F6E2062756C6C6574696E5F6E6F746963653D6E322E6E6F746963655F6964207768657265206578706C5F6F776E65723D212170726F707269657461697265212120616E64206578706C5F7374617475743D696473746174757420616E64206578706C5F6F776E65723D69646C656E646572206F7264657220627920206578706C5F636F74652C206578706C5F636220,'Liste des exemplaires pour un propriétaire trié par cote et code-barre','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"proprietaire\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Propriétaire]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select idlender, lender_libelle from lenders order by idlender</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\">Choisissez un prêteur</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 (9,'Comptage lecteurs / catégorie',0x73656C656374206C6962656C6C6520617320436174E9676F7269652C20636F756E74282A2920617320274E6F6D627265206C65637465757273272066726F6D20656D70722C20656D70725F63617465672077686572652069645F63617465675F656D70723D656D70725F63617465672067726F7570206279206C6962656C6C65206F72646572206279206C6962656C6C65,'Nombre de lecteurs par catégorie','1 4 3 2',NULL,0,0,'');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`, `num_classement`, `proc_notice_tpl`, `proc_notice_tpl_field`) VALUES (10,'Liste lecteurs / catégories',0x73656C656374206C6962656C6C6520617320436174E9676F7269652C20656D70725F6E6F6D206173204E6F6D2C20656D70725F7072656E6F6D206173205072E96E6F6D2C20656D70725F796561722061732022416E6EE965206465206E61697373616E6365222066726F6D20656D70722C20656D70725F63617465672077686572652069645F63617465675F656D70723D656D70725F6361746567206F72646572206279206C6962656C6C652C20656D70725F6E6F6D2C20656D70725F7072656E6F6D,'Liste des lecteurs par catégorie de lecteur, lecteur','1 2',NULL,0,0,'');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`, `num_classement`, `proc_notice_tpl`, `proc_notice_tpl_field`) VALUES (11,'Stat : Compte prêts / catégories de lecteurs pour une année',0x53454C4543542043415345205748454E206C6962656C6C65204953204E554C4C205448454E202220436174E9676F726965206465206C6563746575727320696E636F6E6E75652220454C5345206C6962656C6C6520454E4420617320436174E9676F7269652C20636F756E74282A2920617320224E6F6D627265206465207072EA7473222046524F4D20707265745F61726368697665204C454654204A4F494E20656D70725F6361746567204F4E2069645F63617465675F656D7072203D206172635F656D70725F63617465672077686572652079656172286172635F646562757429203D20272121706172616D312121272067726F7570206279206172635F656D70725F6361746567206F7264657220627920436174E9676F726965,'Nombre de prêt par catégorie de lecteurs pour une année','1 5 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"param1\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[année]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS></OPTIONS>\n </FIELD>\n <FIELD NAME=\"mois\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[mois]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR=\"list\">\r\n <MULTIPLE>yes</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE=\"1\"><![CDATA[Janvier]]></ITEM>\r\n  <ITEM VALUE=\"2\"><![CDATA[Février]]></ITEM>\r\n  <ITEM VALUE=\"3\"><![CDATA[Mars]]></ITEM>\r\n  <ITEM VALUE=\"4\"><![CDATA[Avril]]></ITEM>\r\n  <ITEM VALUE=\"5\"><![CDATA[Mai]]></ITEM>\r\n  <ITEM VALUE=\"6\"><![CDATA[Juin]]></ITEM>\r\n  <ITEM VALUE=\"7\"><![CDATA[Juillet]]></ITEM>\r\n  <ITEM VALUE=\"8\"><![CDATA[Août]]></ITEM>\r\n  <ITEM VALUE=\"9\"><![CDATA[Septembre]]></ITEM>\r\n  <ITEM VALUE=\"10\"><![CDATA[Octobre]]></ITEM>\r\n  <ITEM VALUE=\"11\"><![CDATA[Novembre]]></ITEM>\r\n  <ITEM VALUE=\"12\"><![CDATA[Décembre]]></ITEM>\r\n </ITEMS>\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 (12,'Stat : Compte lecteurs / âge',0x53454C4543542043415345205748454E2020282121706172616D312121202D20656D70725F7965617229203C3D203133205448454E2027204A757371756520313320616E7327205748454E20282121706172616D312121202D20656D70725F7965617229203E313320616E6420282121706172616D312121202D20656D70725F79656172293C3D3234205448454E2027313420E020323420616E7327205748454E20282121706172616D312121202D20656D70725F79656172293E323420616E6420282121706172616D312121202D20656D70725F79656172293C3D3539205448454E2027323520E020353920616E7327205748454E20282121706172616D312121202D20656D70725F79656172293E3539205448454E2027363020616E7320657420706C7573272020454C5345202765727265757220737572206167652720454E4420617320225472616E636865206427E26765222C20636F756E74282A29206173204E6F6D6272652066726F6D20656D707220776865726520656D70725F636174656720696E2028212163617465676F72696521212920616E6420287965617228656D70725F646174655F65787069726174696F6E293D2121706172616D312121206F72207965617228656D70725F646174655F6164686573696F6E293D2121706172616D312121292067726F75702062792031,'Nbre de lecteurs par tranche d\'age pour une année','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"param1\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Année de calcul]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR=\"text\">\r\n <SIZE>5</SIZE>\r\n <MAXSIZE>4</MAXSIZE>\r\n</OPTIONS> \n </FIELD>\n <FIELD NAME=\"categorie\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Catégorie]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select id_categ_empr, libelle from empr_categ order by libelle</QUERY>\r\n <MULTIPLE>yes</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 (13,'Stat : Compte lecteurs / sexe / âge',0x53454C4543542063617365207768656E20656D70725F736578653D273127207468656E2027486F6D6D657327207768656E20656D70725F736578653D273227207468656E202746656D6D65732720656C736520276572726575722073757220736578652720656E6420617320536578652C2043415345205748454E2020282121706172616D312121202D20656D70725F7965617229203C3D203133205448454E20274A757371756520313320616E7327205748454E20282121706172616D312121202D20656D70725F7965617229203E313320616E6420282121706172616D312121202D20656D70725F7965617229203C3D203234205448454E2027313420E020323420616E7327205748454E20282121706172616D312121202D20656D70725F7965617229203E323420616E6420282121706172616D312121202D20656D70725F7965617229203C3D203539205448454E2027323520E020353920616E7327205748454E20282121706172616D312121202D20656D70725F7965617229203E3539205448454E2027363020616E7320657420706C7573272020454C5345202765727265757220737572206167652720454E4420617320225472616E636865206427E26765222C20636F756E74282A29206173204E6F6D6272652066726F6D20656D707220776865726520656D70725F636174656720696E2028212163617465676F72696521212920616E6420287965617228656D70725F646174655F65787069726174696F6E293D2121706172616D312121206F72207965617228656D70725F646174655F6164686573696F6E293D2121706172616D312121292067726F757020627920736578652C2032,'Nbre de lecteurs par sexe et tranche d\'âge pour une année','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"param1\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Année de calcul]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR=\"text\">\r\n <SIZE>5</SIZE>\r\n <MAXSIZE>4</MAXSIZE>\r\n</OPTIONS> \n </FIELD>\n <FIELD NAME=\"categorie\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Catégorie]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select id_categ_empr, libelle from empr_categ order by libelle</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 (14,'Stat : Compte lecteurs / ville / catégorie',0x73656C65637420656D70725F76696C6C652061732056696C6C652C20636F756E74282A29206173204E6272652066726F6D20656D707220776865726520656D70725F636174656720696E2028212163617465676F72696521212920616E6420287965617228656D70725F646174655F65787069726174696F6E293D2121616E6E65652121206F72207965617228656D70725F646174655F6164686573696F6E293D2121616E6E65652121292067726F757020627920656D70725F76696C6C65206F7264657220627920656D70725F76696C6C65,'Nbre de lecteurs par ville de résidence pour une ou plusieurs catégorie','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"categorie\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Catégorie]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR=\"query_list\">\r\n <QUERY>select id_categ_empr, libelle from empr_categ order by libelle</QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME=\"annee\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Année de calcul]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR=\"text\">\r\n <SIZE>5</SIZE>\r\n <MAXSIZE>4</MAXSIZE>\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 (15,'Stat : Compte prêts par mois',0x53454C4543542079656172286172635F64656275742920617320416E6EE9652C206D6F6E7468286172635F646562757429206173204D6F69732C20636F756E74282A2920617320224E6F6D627265206465207072EA7473222046524F4D20707265745F617263686976652077686572652079656172286172635F646562757429203D20272121706172616D312121272067726F757020627920312C2032206F7264657220627920312C2032,'Nbre total de prêts pour une année','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"param1\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Année de calcul]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR=\"text\">\r\n <SIZE>5</SIZE>\r\n <MAXSIZE>4</MAXSIZE>\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 (16,'Stat : Compte prêts / section pour une année',0x53454C4543542043415345205748454E2073656374696F6E5F6C6962656C6C65204953204E554C4C205448454E20222053656374696F6E207375707072696DE9652220454C53452073656374696F6E5F6C6962656C6C6520454E442061732053656374696F6E2C20636F756E74282A2920617320224E6F6D627265206465207072EA7473222046524F4D20707265745F61726368697665204C454654204A4F494E20646F63735F73656374696F6E204F4E20696473656374696F6E203D206172635F6578706C5F73656374696F6E2077686572652079656172286172635F646562757429203D20272121706172616D312121272067726F7570206279206172635F6578706C5F73656374696F6E206F726465722062792053656374696F6E,'Nombre de prêts par section pour une année','1 4 3 2','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"param1\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[année]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR=\"text\">\r\n <SIZE>20</SIZE>\r\n <MAXSIZE>255</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME=\"mois\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[mois]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR=\"list\">\r\n <MULTIPLE>yes</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE=\"1\"><![CDATA[Janvier]]></ITEM>\r\n  <ITEM VALUE=\"2\"><![CDATA[Février]]></ITEM>\r\n  <ITEM VALUE=\"3\"><![CDATA[Mars]]></ITEM>\r\n  <ITEM VALUE=\"4\"><![CDATA[Avril]]></ITEM>\r\n  <ITEM VALUE=\"5\"><![CDATA[Mai]]></ITEM>\r\n  <ITEM VALUE=\"6\"><![CDATA[Juin]]></ITEM>\r\n  <ITEM VALUE=\"7\"><![CDATA[Juillet]]></ITEM>\r\n  <ITEM VALUE=\"8\"><![CDATA[Août]]></ITEM>\r\n  <ITEM VALUE=\"9\"><![CDATA[Septembre]]></ITEM>\r\n  <ITEM VALUE=\"10\"><![CDATA[Octobre]]></ITEM>\r\n  <ITEM VALUE=\"11\"><![CDATA[Novembre]]></ITEM>\r\n  <ITEM VALUE=\"12\"><![CDATA[Décembre]]></ITEM>\r\n </ITEMS>\r\n <UNSELECT_ITEM VALUE=\"\"><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>',0,0,'');

--
-- END OF ESSENTIAL
--
