# 
# 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');

# 
# Dumping data for table caddie_procs
# 

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 (6, 'ACTION', 'Retour BDP des exemplaires', 0x757064617465206578656d706c616972657320736574206578706c5f7374617475743d21216e6f75766561755f7374617475742121207768657265206578706c5f696420696e2028434144444945284558504c2929, 'Permet de changer le statut des exemplaires d''un panier', '1 2 3', '<?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 (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', 0x6372656174652054454d504f52415259205441424c4520746d702053454c45435420746974312046524f4d206e6f74696365732047524f5550204259207469743120484156494e4720636f756e74282a293e310d0a53454c454354206e6f746963655f6964206173206f626a6563745f69642c20274e4f544927206173206f626a6563745f747970652046524f4d206e6f74696365732c20746d70207748455245206e6f74696365732e746974313d746d702e74697431, '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 (7, '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 (8, '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 (9, '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>');

-- 
-- Contenu de la 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);

-- 
-- Contenu de la 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, logosmall) VALUES (1, 'Bibliothèque principale', '', 2, 'images/site/bib_princ.jpg', 1, 'Bibliothèque test de PMB', 'PMB Services', 'Le Gué Luneau', '37370', 'BUEIL EN TOURAINE', '', 'France', '02 47 24 89 29', 'pmb@sigb.net', 'http://www.sigb.net/', 'logo_default.jpg', 'logo_default_small.jpg');
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, logosmall) VALUES (2, 'Réserve', '', 2, '', 0, 'Bibliothèque test de PMB', 'rue de la culture', '', '37370', 'SimTown', '', 'France', '02 47 24 89 29', 'pmb@sigb.net', 'http://www.sigb.net', 'logo_default.jpg', 'logo_default_small.jpg');
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, logosmall) VALUES (7, 'Bibliobus', '', 2, 'images/site/bibliobus.jpg', 1, 'Bibliothèque test de PMB', 'rue de la culture', '', '37370', 'SimTown', '', 'France', '02 47 24 89 29', 'pmb@sigb.net', 'http://www.sigb.net', 'logo_default.jpg', 'logo_default_small.jpg');

-- 
-- Contenu de la 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);

-- 
-- Contenu de la table `docs_statut`
-- 

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

-- 
-- Contenu de la 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);

-- 
-- Contenu de la 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);

-- 
-- Contenu de la 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');

-- 
-- Contenu de la table `lenders`
-- 

INSERT INTO lenders (idlender, lender_libelle) VALUES (1, 'BDP');
INSERT INTO lenders (idlender, lender_libelle) VALUES (2, 'Fonds propre');

-- 
-- Contenu de la table `procs`
-- 

INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (1, 'Liste expl/statut', 0x73656c656374206578706c5f636f74652c206578706c5f63622c20746974312066726f6d206578656d706c61697265732c206e6f7469636573207768657265206578706c5f7374617475743d2121706172616d31212120616e64206578706c5f6e6f746963653d6e6f746963655f6964206f72646572206279206578706c5f636f7465, 'Liste paramétrée d''exemplaires par statut ', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (2, 'Comptage expl /statut', 0x73656c656374207374617475745f6c6962656c6c652066726f6d206578656d706c61697265732c20646f63735f7374617475742c20636f756e74282a29206173204e6272652077686572652069647374617475743d6578706c5f7374617475742067726f7570206279207374617475745f6c6962656c6c65206f72646572206279206964737461747574, 'Nombre d''exemplaires par statut d''exmplaire', '1 2', NULL);
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (3, 'Comptage expl /prêteur', 0x73656c656374206c656e6465725f6c6962656c6c652c20636f756e74282a29206173204e6272652066726f6d206578656d706c61697265732c206c656e64657273207768657265206578706c5f6f776e65723d69646c656e6465722067726f7570206279206c656e6465725f6c6962656c6c65206f72646572206279206c656e6465725f6c6962656c6c6520, 'Nombre d''exemplaires par prêteur', '1 2', NULL);
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (4, 'Comptage  expl /prêteur /statut', 0x73656c656374206c656e6465725f6c6962656c6c652c2069647374617475742c207374617475745f6c6962656c6c65202c20636f756e74282a29206173204e6272652066726f6d206578656d706c61697265732c206c656e646572732c20646f63735f737461747574207768657265206578706c5f6f776e65723d69646c656e64657220616e64206578706c5f7374617475743d69647374617475742067726f7570206279206c656e6465725f6c6962656c6c652c7374617475745f6c6962656c6c65206f72646572206279206c656e6465725f6c6962656c6c652c7374617475745f6c6962656c6c6520, 'Nombre d''exemplaires par prêteur et par statut d''exmplaire', '1 2', NULL);
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (5, 'Liste expl d''un prêteur /statut', 0x73656c656374206c656e6465725f6c6962656c6c652c207374617475745f6c6962656c6c652c206578706c5f636f74652c206578706c5f63622c20746974312066726f6d206578656d706c61697265732c206e6f74696365732c20646f63735f7374617475742c206c656e64657273207768657265206578706c5f7374617475743d2121737461747574212120616e64206578706c5f6f776e65723d212150726f707269657461697265212120616e64206578706c5f6e6f746963653d6e6f746963655f696420616e64206578706c5f7374617475743d696473746174757420616e64206578706c5f6f776e65723d69646c656e646572206f72646572206279206c656e6465725f6c6962656c6c652c207374617475745f6c6962656c6c652c206578706c5f636f74652c206578706c5f636220, '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 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (6, 'Comptage expl /section', 0x73656c65637420696473656374696f6e2c2073656374696f6e5f6c6962656c6c652c20636f756e74282a29206173204e6272652066726f6d206578656d706c61697265732c20646f63735f73656374696f6e20776865726520696473656374696f6e3d6578706c5f73656374696f6e2067726f757020627920696473656374696f6e2c2073656374696f6e5f6c6962656c6c65206f7264657220627920696473656374696f6e, 'Nombre d''exemplaires par section', '1 2', NULL);
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (7, 'Liste expl pour une ou plusieurs sections par prêteur', 0x73656c6563742073656374696f6e5f6c6962656c6c652c206578706c5f636f74652c206578706c5f63622c20746974312066726f6d206578656d706c61697265732c206e6f74696365732c20646f63735f73656374696f6e2c206c656e6465727320776865726520696473656374696f6e20696e2028212173656374696f6e7321212920616e64206578706c5f6f776e65723d212170726574657572212120616e64206578706c5f6e6f746963653d6e6f746963655f696420616e64206578706c5f73656374696f6e3d696473656374696f6e20616e64206578706c5f6f776e65723d69646c656e646572206f726465722062792073656374696f6e5f6c6962656c6c652c206578706c5f636f74652c206578706c5f636220, 'Liste des exemplaires ayant une ou plusieurs sections particulières pour un prêteur', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (8, 'Stat : Compte expl /propriétaire', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f7072696f2c20636f756e74282a29206173204e6272652066726f6d206578656d706c61697265732c206c656e646572732077686572652069646c656e6465723d6578706c5f6f776e65722067726f7570206279206578706c5f6f776e65722c206c656e6465725f6c6962656c6c65, 'Nbre d''exemplaires par propriétaire d''exemplaire', '1 2', NULL);
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (9, 'Liste expl du fonds propre', 0x73656c656374207374617475745f6c6962656c6c652c206578706c5f636f74652c206578706c5f63622c20746974312066726f6d206578656d706c61697265732c206e6f74696365732c20646f63735f737461747574207768657265206578706c5f6f776e65723d3020616e64206578706c5f6e6f746963653d6e6f746963655f696420616e64206578706c5f7374617475743d6964737461747574206f72646572206279207374617475745f6c6962656c6c652c206578706c5f636f74652c206578706c5f636220, 'Liste des exemplaires du fonds propre par statut, cote, code-barre, titre', '1 2', NULL);
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (10, 'Liste expl pour un prêteur', 0x73656c656374206578706c5f636f74652c206578706c5f63622c20746974312066726f6d206578656d706c61697265732c206e6f74696365732c20646f63735f7374617475742c206c656e64657273207768657265206578706c5f6f776e65723d212170726f707269657461697265212120616e64206578706c5f6e6f746963653d6e6f746963655f696420616e64206578706c5f7374617475743d696473746174757420616e64206578706c5f6f776e65723d69646c656e646572206f7264657220627920206578706c5f636f74652c206578706c5f636220, 'Liste des exemplaires pour 1 propriétaire trié par cote et code-barre', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (11, 'Comptage lecteurs /categ', 0x73656c656374206c6962656c6c652c20636f756e74282a2920617320274e627265206c65637465757273272066726f6d20656d70722c20656d70725f63617465672077686572652069645f63617465675f656d70723d656d70725f63617465672067726f7570206279206c6962656c6c65206f72646572206279206c6962656c6c65, 'Nombre de lecteurs par catégorie', '1 2', NULL);
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (13, 'Liste lecteurs /catégories', 0x73656c656374206c6962656c6c6520617320436174e9676f7269652c20656d70725f6e6f6d206173204e6f6d2c20656d70725f7072656e6f6d206173205072e96e6f6d2c20656d70725f7965617220617320446174654e61697373616e63652066726f6d20656d70722c20656d70725f63617465672077686572652069645f63617465675f656d70723d656d70725f6361746567206f72646572206279206c6962656c6c652c20656d70725f6e6f6d2c20656d70725f7072656e6f6d, 'Liste des lecteurs par catégorie de lecteur, lecteur', '1 2', NULL);
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (14, 'Prêts par catégories', 0x53454c45435420656d70725f63617465672e6c6962656c6c6520617320436174e9676f7269652c20656d70722e656d70725f6e6f6d206173204e6f6d2c20656d70722e656d70725f7072656e6f6d206173205072e96e6f6d2c20656d70722e656d70725f6362206173204e756de9726f2c206578656d706c61697265732e6578706c5f636220617320436f646542617272652c206e6f74696365732e746974312061732054697472652046524f4d20707265742c656d70722c656d70725f63617465672c6578656d706c61697265732c6e6f746963657320574845524520656d70725f63617465672e69645f63617465675f656d707220696e2028212163617465676f72696521212920616e6420656d70722e656d70725f6361746567203d20656d70725f63617465672e69645f63617465675f656d707220616e6420707265742e707265745f6964656d7072203d20656d70722e69645f656d707220616e6420707265742e707265745f69646578706c203d206578656d706c61697265732e6578706c5f696420616e64206578656d706c61697265732e6578706c5f6e6f74696365203d206e6f74696365732e6e6f746963655f6964206f7264657220627920312c322c332c36, 'Liste des exemplaires en prêt pour une ou plusieurs catégories de lecteurs', '1 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="categorie" MANDATORY="yes">\n  <ALIAS><![CDATA[categorie]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select id_categ_empr, libelle from empr_categ order by libelle]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (20, 'Liste fonds propre / statut', 0x73656c656374207374617475745f6c6962656c6c652c206578706c5f636f74652c206578706c5f63622c20746974312066726f6d206578656d706c61697265732c206e6f74696365732c20646f63735f737461747574207768657265206578706c5f6f776e65723d3020616e64206578706c5f6e6f746963653d6e6f746963655f696420616e64206578706c5f7374617475743d6964737461747574206f72646572206279207374617475745f6c6962656c6c652c206578706c5f636f74652c206578706c5f636220, 'Pointage fonds propre', '1 2', NULL);
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (21, 'Stat : Compte lecteurs /age', 0x53454c45435420636f756e74282a292c2043415345205748454e2020282121706172616d312121202d20656d70725f7965617229203c3d203133205448454e20274a757371756520313320616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e313320616e6420282121706172616d312121202d20656d70725f79656172293c3d3234205448454e2027313420e020323420616e7327205748454e20282121706172616d312121202d20656d70725f79656172293e323420616e6420282121706172616d312121202d20656d70725f79656172293c3d3539205448454e2027323520e020323920616e7327205748454e20282121706172616d312121202d20656d70725f79656172293e3539205448454e2027363020616e7320657420706c7573272020454c5345202765727265757220737572206167652720454e442061732063617465675f6167652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121706172616d312121206f72207965617228656d70725f646174655f6164686573696f6e293d2121706172616d312121292067726f75702062792063617465675f616765, 'Nbre de lecteurs par tranche d''age pour une année', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (22, 'Stat : Compte lecteurs /sexe /age', 0x53454c45435420636f756e74282a292c2063617365207768656e20656d70725f736578653d273127207468656e2027486f6d6d657327207768656e20656d70725f736578653d273227207468656e202746656d6d65732720656c736520276572726575722073757220736578652720656e6420617320536578652c2043415345205748454e2020282121706172616d312121202d20656d70725f7965617229203c3d203133205448454e20274a757371756520313320616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e313320616e6420282121706172616d312121202d20656d70725f7965617229203c3d203234205448454e2027313420e020323420616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e323420616e6420282121706172616d312121202d20656d70725f7965617229203c3d203539205448454e2027323520e020353920616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e3539205448454e2027363020616e7320657420706c7573272020454c5345202765727265757220737572206167652720454e442061732063617465675f6167652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121706172616d312121206f72207965617228656d70725f646174655f6164686573696f6e293d2121706172616d312121292067726f757020627920736578652c2063617465675f616765, 'Nbre de lecteurs par sexe et tranche d''age pour une année', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (23, 'Stat : Compte lecteurs /ville /catégorie', 0x73656c65637420656d70725f76696c6c652061732056696c6c652c20636f756e74282a29206173204e6272652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121616e6e65652121206f72207965617228656d70725f646174655f6164686573696f6e293d2121616e6e65652121292067726f757020627920656d70725f76696c6c65206f7264657220627920656d70725f76696c6c65, 'Nbre de lecteurs par ville de résidence pour une ou plusieurs catégorie', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (24, 'Stat : Compte élèves', 0x53454c45435420636f756e74282a29206173206e6272655f656c6576652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121616e6e65652121206f72207965617228656d70725f646174655f6164686573696f6e293d2121616e6e6565212129, 'Nbre de lecteurs ''Elève'' = catégorie à sélectionner ', '1 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="categorie" MANDATORY="yes">\n  <ALIAS><![CDATA[Catégorie de lecteurs]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select id_categ_empr, libelle from empr_categ order by libelle]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (25, 'Stat : Compte prêts pour élève ou profs', 0x53454c45435420636f756e74282a29206173206e6272655f707265745f656c6576652066726f6d20707265745f61726368697665207768657265206172635f656d70725f636174656720696e2028212163617465676f72696521212920616e642079656172286172635f646562757429203d20272121706172616d312121270d0a, 'Nbre de prêts pour les élèves de l''école ou pour les profs (prêts pour la classe) pour une année', '1 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><![CDATA[select id_categ_empr, libelle from empr_categ order by libelle]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (26, 'Stat : Compte prêts Documentaires E', 0x53454c4543542079656172286172635f64656275742920617320616e6e65652c206d6f6e746820286172635f646562757429206173206d6f69732c20636f756e74282a29206e625f707265745f446f63755f452046524f4d20707265745f6172636869766520776865726520286c65667420286172635f6578706c5f636f74652c32293d27452027206f72206c65667420286172635f6578706c5f636f74652c33293d2745422027206f72206c65667420286172635f6578706c5f636f74652c32293d27452e2729616e642079656172286172635f646562757429203d20272121706172616d312121272067726f757020627920616e6e65652c206d6f6973206f7264657220627920616e6e65652c206d6f6973, 'Nbre de prêts de documentaires Enfants pour une année', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (27, 'Stat : Compte prêts Fictions E', 0x53454c4543542079656172286172635f64656275742920617320616e6e65652c206d6f6e746820286172635f646562757429206173206d6f69732c20636f756e74282a29206e625f70726574735f66696374696f6e5f452046524f4d20707265745f6172636869766520776865726520286c65667420286172635f6578706c5f636f74652c33293d2745412027206f72206c65667420286172635f6578706c5f636f74652c33293d2745424427206f72206c65667420286172635f6578706c5f636f74652c33293d2745432027206f72206c65667420286172635f6578706c5f636f74652c33293d27455220272920616e642079656172286172635f646562757429203d20272121706172616d312121272067726f757020627920616e6e65652c206d6f6973206f7264657220627920616e6e65652c206d6f6973, 'Nbre de prêts de fictions Enfants pour une année', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (28, 'Stat : Compte prêts Fictions A', 0x53454c4543542079656172286172635f64656275742920617320616e6e65652c206d6f6e746820286172635f646562757429206173206d6f69732c20636f756e74282a29206e625f70726574735f66696374696f6e5f412046524f4d20707265745f6172636869766520776865726520286c65667420286172635f6578706c5f636f74652c31293d275227206f72206c65667420286172635f6578706c5f636f74652c33293d2742442027206f72206c65667420286172635f6578706c5f636f74652c32293d274a5227206f72206c65667420286172635f6578706c5f636f74652c33293d274a4244272920616e64206c65667420286172635f6578706c5f636f74652c33293c3e275245202720616e642079656172286172635f646562757429203d20272121706172616d312121272067726f757020627920616e6e65652c206d6f6973206f7264657220627920616e6e65652c206d6f6973, 'Nbre de prêts de fictions Jeunes ou Adultes pour une année', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (29, 'Stat : Compte prêts Documentaires A & J', 0x53454c4543542079656172286172635f64656275742920617320616e6e65652c206d6f6e746820286172635f646562757429206173206d6f69732c20636f756e74282a29206e625f70726574735f446f63755f412046524f4d20707265745f6172636869766520776865726520286c65667420286172635f6578706c5f636f74652c32293d27482027206f72206c65667420286172635f6578706c5f636f74652c32293d27422027206f72206c65667420286172635f6578706c5f636f74652c33293d2746522027206f72206c65667420286172635f6578706c5f636f74652c32293d274a2027206f72206c65667420286172635f6578706c5f636f74652c32293d274a2e27206f72206c656674286172635f6578706c5f636f74652c3129206265747765656e2027302720616e64202739272920616e642079656172286172635f646562757429203d20272121706172616d312121272067726f757020627920616e6e65652c206d6f6973206f7264657220627920616e6e65652c206d6f6973, 'Nbre de prêts de documentaires Jeunes ou Adultes pour une année', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (30, 'Stat : Compte prêts TOTAL (hors Pério)', 0x53454c4543542079656172286172635f64656275742920617320616e6e65652c206d6f6e746820286172635f646562757429206173206d6f69732c20636f756e74282a29206e625f70726574735f544f54414c2046524f4d20707265745f61726368697665207768657265206172635f6578706c5f636f7465206e6f74206c696b6520275020252720616e642079656172286172635f646562757429203d20272121706172616d312121272067726f757020627920616e6e65652c206d6f6973206f7264657220627920616e6e65652c206d6f6973, 'Nbre total de prêts hors périodiques pour une année', '1 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>');
INSERT INTO procs (idproc, name, requete, comment, autorisations, parameters) VALUES (31, 'Stat : Compte prêts Périodiques', 0x53454c4543542079656172286172635f64656275742920617320616e6e65652c206d6f6e746820286172635f646562757429206173206d6f69732c20636f756e74282a29206e625f70726574735f544f54414c2046524f4d20707265745f61726368697665207768657265206172635f6578706c5f636f7465206c696b6520275020252720616e642079656172286172635f646562757429203d20272121706172616d312121272067726f757020627920616e6e65652c206d6f6973206f7264657220627920616e6e65652c206d6f6973, 'Nbre de prêts de périodiques pour une année', '1 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>');

-- 
-- Contenu de la 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', 'bibli', '7', '', '1,3', 0, 'internal::', 0, '', '');

-- 
-- Contenu de la table `sauv_tables`
-- 

INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (1, 'Biblio', 'analysis,bulletins,docs_codestat,docs_location,docs_section,docs_statut,docs_type,exemplaires,notices,etagere_caddie,notices_custom,notices_custom_lists,notices_custom_values');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (2, 'Autorités', 'authors,collections,publishers,series,sub_collections,responsability');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (3, 'Aucune utilité', 'error_log,import_marc,sessions');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (4, 'Z3950', 'z_attr,z_bib,z_notices,z_query');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (5, 'Emprunteurs', 'empr,empr_categ,empr_codestat,empr_groupe,groupe,pret,pret_archive,resa,empr_custom,empr_custom_lists,empr_custom_values,expl_custom,expl_custom_lists,expl_custom_values');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (6, 'Application', 'categories,lenders,parametres,procs,sauv_lieux,sauv_log,sauv_sauvegardes,sauv_tables,users,explnum,indexint,notices_categories,origine_notice,quotas,etagere,resa_ranger,admin_session,opac_sessions,audit,notice_statut,ouvertures');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (7, 'TOUT', 'admin_session,analysis,audit,authors,bannette_abon,bannette_contenu,bannette_equation,bannettes,bulletins,caddie,caddie_content,caddie_procs,categories,classements,collections,comptes,docs_codestat,docs_location,docs_section,docs_statut,docs_type,empr,empr_categ,empr_codestat,empr_custom,empr_custom_lists,empr_custom_values,empr_groupe,equations,error_log,etagere,etagere_caddie,exemplaires,expl_custom,expl_custom_lists,expl_custom_values,explnum,groupe,import_marc,indexint,lenders,notice_statut,notices,notices_categories,notices_custom,notices_custom_lists,notices_custom_values,opac_sessions,origine_notice,ouvertures,parametres,pret,pret_archive,procs,publishers,quotas,quotas_finance,recouvrements,resa,resa_ranger,responsability,sauv_lieux,sauv_log,sauv_sauvegardes,sauv_tables,series,sessions,sub_collections,transactions,type_abts,type_comptes,users,z_attr,z_bib,z_notices,z_query');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (9, 'Caddies', 'caddie_procs,caddie,caddie_content');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (10, 'DSI', 'bannette_abon,bannette_contenu,bannette_equation,bannettes,classements,equations');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (11, 'Finance', 'comptes,quotas_finance,recouvrements,transactions,type_abts,type_comptes');

-- 
-- Contenu de la table `z_attr`
-- 

INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (2, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (2, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (2, 'auteur', '1003');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (2, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (3, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (3, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (3, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (3, 'auteur', '1003');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (5, 'auteur', '1004');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (5, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (5, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (5, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (7, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (7, 'auteur', '1003');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (7, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (7, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (8, 'auteur', '1');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (8, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (8, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (8, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (8, 'mots', '1016');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (10, 'auteur', '1003');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (10, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (10, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (10, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (12, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (12, 'auteur', '1003');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (12, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (12, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (11, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (11, 'auteur', '1003');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (11, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (11, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (15, 'auteur', '1003');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (15, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (15, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (15, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (17, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (17, 'auteur', '1003');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (17, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (17, 'titre', '4');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (21, 'sujet', '21');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (21, 'auteur', '1003');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (21, 'isbn', '7');
INSERT INTO z_attr (attr_bib_id, attr_libelle, attr_attr) VALUES (21, 'titre', '4');

-- 
-- Contenu de la table `z_bib`
-- 

INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (2, 'ENS Cachan', 'CATALOG', '138.231.48.2', '21210', 'ADVANCE', 'unimarc', '', '', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (3, 'BN France', 'CATALOG', 'z3950.bnf.fr', '2211', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1456', 'UNIMARC', 'Z3950', 'Z3950_BNF', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (5, 'Univ Lyon 2 SCD', 'CATALOG', 'scdinf.univ-lyon2.fr', '21210', 'ouvrages', 'unimarc', '', '', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (7, 'Univ Oxford', 'CATALOG', 'library.ox.ac.uk', '210', 'ADVANCE', 'usmarc', '', '', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (10, 'Univ Laval (QC)', 'CATALOG', 'ariane2.ulaval.ca', '2200', 'UNICORN', 'USMARC', '', '', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (11, 'Univ Lib Edinburgh', 'CATALOG', 'catalogue.lib.ed.ac.uk', '7090', 'voyager', 'USMARC', '', '', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (12, 'Library Of Congress', 'CATALOG', 'z3950.loc.gov', '7090', 'Voyager', 'USMARC', '', '', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (15, 'ENS Paris', 'CATALOG', 'halley.ens.fr', '210', 'INNOPAC', 'UNIMARC', '', '', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (17, 'Polytechnique Montréal', 'CATALOG', 'advance.biblio.polymtl.ca', '210', 'ADVANCE', 'USMARC', '', '', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (21, 'SUDOC', 'CATALOG', 'carmin.sudoc.abes.fr', '210', 'ABES-Z39-PUBLIC', 'UNIMARC', '', '', '');
INSERT INTO z_bib (bib_id, bib_nom, search_type, url, port, base, format, auth_user, auth_pass, sutrs_lang) VALUES (8, 'Univ Valenciennes', 'CATALOG', '195.221.187.151', '210', 'INNOPAC', 'UNIMARC', '', '', '');