INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`, `num_classement`, `proc_notice_tpl`, `proc_notice_tpl_field`) VALUES
(340, 'Liste des exemplaires pour une ou plusieurs sections par propriétaire', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f707269e974616972652c206c6f636174696f6e5f6c6962656c6c65206173204c6f63616c69736174696f6e2c2073656374696f6e5f6c6962656c6c652061732053656374696f6e2c207374617475745f6c6962656c6c65206173205374617475742c206578706c5f636f746520617320436f74652c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652c2069662861302e617574686f725f6964206973206e6f74206e756c6c2c434f4e4341542861302e617574686f725f6e616d652c202720272c2061302e617574686f725f72656a657465292c2727292061732027417574657572207072696e636970616c272c2065645f6e616d6520617320456469746575722c206e312e796561722061732022416e6ee965206427e9646974696f6e222c206578706c5f63622061732022436f64652d626172726573222c206578706c5f7072697820617320507269782066726f6d206578656d706c6169726573206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f6964206c656674206a6f696e20646f63735f6c6f636174696f6e206f6e206578706c5f6c6f636174696f6e3d69646c6f636174696f6e206c656674206a6f696e20646f63735f73656374696f6e206f6e206578706c5f73656374696f6e3d696473656374696f6e206c656674206a6f696e207075626c697368657273206f6e206e312e6564315f69643d65645f6964206c656674206a6f696e20726573706f6e736162696c697479206173207230206f6e20286e312e6e6f746963655f69643d72302e726573706f6e736162696c6974795f6e6f7469636520616e642072302e726573706f6e736162696c6974795f747970653d3029206c656674206a6f696e20617574686f7273206173206130206f6e2061302e617574686f725f69643d72302e726573706f6e736162696c6974795f617574686f72206c656674206a6f696e20646f63735f737461747574206f6e206578706c5f7374617475743d6964737461747574206c656674206a6f696e206c656e64657273206f6e206578706c5f6f776e65723d69646c656e64657220776865726520696473656374696f6e20696e2028212173656374696f6e7321212920616e64206578706c5f6f776e65723d2121707265746575722121206f726465722062792073656374696f6e5f6c6962656c6c652c206578706c5f636f74652c206578706c5f6362, '', '1', '<?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>select idsection, section_libelle from docs_section</QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="preteur" 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>', 16, 0, ''),
(341, 'Liste des exemplaires par statut', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f707269e974616972652c206c6f636174696f6e5f6c6962656c6c65206173204c6f63616c69736174696f6e2c2073656374696f6e5f6c6962656c6c652061732053656374696f6e2c207374617475745f6c6962656c6c65206173205374617475742c206578706c5f636f746520617320436f74652c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652c2069662861302e617574686f725f6964206973206e6f74206e756c6c2c434f4e4341542861302e617574686f725f6e616d652c202720272c2061302e617574686f725f72656a657465292c2727292061732027417574657572207072696e636970616c272c2065645f6e616d6520617320456469746575722c206e312e796561722061732022416e6ee965206427e9646974696f6e222c206578706c5f63622061732022436f64652d626172726573222c206578706c5f7072697820617320507269782066726f6d206578656d706c6169726573206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f6964206c656674206a6f696e20646f63735f6c6f636174696f6e206f6e206578706c5f6c6f636174696f6e3d69646c6f636174696f6e206c656674206a6f696e20646f63735f73656374696f6e206f6e206578706c5f73656374696f6e3d696473656374696f6e206c656674206a6f696e207075626c697368657273206f6e206e312e6564315f69643d65645f6964206c656674206a6f696e20726573706f6e736162696c697479206173207230206f6e20286e312e6e6f746963655f69643d72302e726573706f6e736162696c6974795f6e6f7469636520616e642072302e726573706f6e736162696c6974795f747970653d3029206c656674206a6f696e20617574686f7273206173206130206f6e2061302e617574686f725f69643d72302e726573706f6e736162696c6974795f617574686f72206c656674206a6f696e20646f63735f737461747574206f6e206578706c5f7374617475743d6964737461747574206c656674206a6f696e206c656e64657273206f6e206578706c5f6f776e65723d69646c656e646572207768657265206578706c5f7374617475743d2121706172616d312121206f72646572206279206578706c5f636f7465, '', '1', '<?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>select idstatut,statut_libelle from docs_statut</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE="">Choisissez un statut</UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 16, 0, ''),
(342, 'Nombre d''exemplaires par propriétaire, section', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f707269e974616972652c2073656374696f6e5f6c6962656c6c652061732053656374696f6e2c20636f756e74282a29206173204e6f6d6272652066726f6d206578656d706c61697265732c206c656e646572732c20646f63735f73656374696f6e207768657265206578706c5f6f776e65723d69646c656e64657220616e6420696473656374696f6e3d6578706c5f73656374696f6e2067726f7570206279206c656e6465725f6c6962656c6c652c2073656374696f6e5f6c6962656c6c65206f7264657220627920312c32, '', '1', '', 16, 0, ''),
(343, 'Liste des emprunteurs avec nom prénom et ville', 0x53656c65637420656d70725f6e6f6d206173204e6f6d2c20656d70725f7072656e6f6d206173205072e96e6f6d2c20656d70725f76696c6c652061732056696c6c652066726f6d20656d7072206f7264657220627920332c312c32, '', '1', '', 17, 0, ''),
(344, 'Liste des lecteurs par type d''abonnement', 0x53656c65637420656d70725f6e6f6d204153204e6f6d2c20656d70725f7072656e6f6d20415320275072e96e6f6d272c20656d70725f76696c6c652041532056696c6c652066726f6d20656d707220574845524520747970655f6162743d2121747970655f61626f6e6e656d656e742121204f5244455220425920312c322c33, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="type_abonnement" MANDATORY="yes">\n  <ALIAS><![CDATA[type d''abonnement :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[SELECT id_type_abt, type_abt_libelle FROM type_abts ORDER BY 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 17, 0, ''),
(345, 'Liste des lecteurs par catégories', 0x73656c656374206c6962656c6c6520617320436174e9676f7269652c20656d70725f6e6f6d206173204e6f6d2c20656d70725f7072656e6f6d206173205072e96e6f6d2c20656d70725f796561722061732022416e6ee965206465206e61697373616e6365222066726f6d20656d70722c20656d70725f63617465672077686572652069645f63617465675f656d70723d656d70725f6361746567206f72646572206279206c6962656c6c652c20656d70725f6e6f6d2c20656d70725f7072656e6f6d, '', '1', '', 17, 0, ''),
(347, 'Liste des lecteurs avec multiples informations', 0x53454c45435420656d70725f6e6f6d206173204e6f6d2c20656d70725f7072656e6f6d206173205072e96e6f6d2c20656d70725f6164723120617320224164726573736520286c69676e65203129222c20656d70725f6164723220617320224164726573736520286c69676e65203229222c20656d70725f63702061732022436f646520506f7374616c222c20656d70725f76696c6c652061732056696c6c652c20656d70725f7061797320617320506179732c20656d70725f796561722061732022416e6ee965206465206e61697373616e6365222c20656d70725f7061797320617320506179732c20656d70725f6d61696c206173204d61696c2c20656d70725f74656c31206173202254e96ce970686f6e65222c20656d70725f74656c32206173202241757472652074e96ce970686f6e65222c20656d70725f70726f662061732050726f66657373696f6e2c20656d70725f7365786520617320536578652c20656d70725f646174655f6164686573696f6e20617320224461746520616468e973696f6e222c20656d70725f646174655f65787069726174696f6e2061732022446174652065787069726174696f6e222c20656d70725f6d7367206173204d6573736167652c20747970655f6162745f6c6962656c6c6520617320225479706520642761626f6e6e656d656e74222046524f4d20656d7072206a6f696e20747970655f61627473206f6e20747970655f6162743d69645f747970655f616274206f7264657220627920312c32, '', '1', '', 17, 0, ''),
(348, 'Liste des lecteurs par sexe', 0x73656c65637420636f6e63617428273c6120687265663d2e2f636972632e7068703f63617465673d7072657426666f726d5f63623d272c656d70725f63622c273e272c656d70725f63622c273c2f613e27292061732027436f64652d626172726573272c20656d70725f6e6f6d206173204e6f6d2c20656d70725f7072656e6f6d206173205072e96e6f6d2c206c6f636174696f6e5f6c6962656c6c65206173204c6f63616c69736174696f6e2c2043415345207768656e2028656d70725f736578653d3129207468656e2027486f6d6d6527207768656e2028656d70725f736578653d3229207468656e202746656d6d652720656c736520274e2f412720454e4420617320536578652066726f6d20656d7072206c656674206a6f696e20646f63735f6c6f636174696f6e206f6e20656d70725f6c6f636174696f6e3d69646c6f636174696f6e206f7264657220627920536578652c206c6f636174696f6e5f6c6962656c6c652c20656d70725f6e6f6d, '', '1', '', 17, 0, ''),
(349, 'Liste des lecteurs par tranche d''âge', 0x53454c4543542069645f656d70722c20656d70725f6e6f6d204153204e6f6d2c20656d70725f7072656e6f6d20415320225072e96e6f6d222c20656d70725f796561722041532022416e6ee965206465206e61697373616e6365222046524f4d20656d707220574845524520656d70725f79656172203e3d21216e6169737331212120414e4420656d70725f79656172203c3d21216e61697373322121204f5244455220425920342c32, 'les années renseignées sont comprises dans la recherche', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="naiss1" MANDATORY="yes">\n  <ALIAS><![CDATA[année de départ :]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>4</SIZE>\r\n <MAXSIZE>4</MAXSIZE>\r\n</OPTIONS> \n </FIELD>\n <FIELD NAME="naiss2" MANDATORY="yes">\n  <ALIAS><![CDATA[année de fin :]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>4</SIZE>\r\n <MAXSIZE>4</MAXSIZE>\r\n</OPTIONS> \n </FIELD>\n</FIELDS>', 17, 0, ''),
(350, 'Liste de lecteurs par ville', 0x53454c45435420656d70725f6e6f6d206173204e6f6d2c20656d70725f7072656e6f6d206173205072e96e6f6d2c20656d70725f76696c6c652061732056696c6c652046524f4d20656d707220574845524520656d70725f76696c6c653d22212176696c6c6c65212122204f5244455220425920312c32, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="villle" MANDATORY="yes">\n  <ALIAS><![CDATA[Ville]]></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>', 17, 0, ''),
(351, 'Liste des transactions par emprunteur', 0x73656c65637420656d70725f7072656e6f6d20617320225072e96e6f6d222c20656d70725f6e6f6d20617320224e6f6d22202c206361736520747970655f636f6d7074655f6964207768656e20273127207468656e202241626f6e6e656d656e7422207768656e20273227207468656e2022416d656e646522207768656e20273327207468656e20225072ea742220656e6420617320225479706520646520636f6d707465222c20646174655f666f726d617428646174655f656e7267742c202725642d256d2d25592729206173202244617465222c2063617365207768656e2073656e733d273127207468656e20274372e96469742720656c7365202744e96269742720656e64206173202244e96269742f4372e9646974222c20286d6f6e74616e742a73656e732920617320224d6f6e74616e74222c20636f6d6d656e74616972652061732022436f6d6d656e746169726573222066726f6d207472616e73616374696f6e732c20636f6d707465732c20656d707220776865726520636f6d7074655f69643d69645f636f6d70746520616e642069645f656d70723d70726f7072696f5f696420616e6420696628272121656d70722121273d2730272c202731272c2069645f656d70723d272121656d70722121272920616e64206966282121747970636f6d21213d2730272c202731272c20747970655f636f6d7074655f69643d2121747970636f6d21212920616e6420646174655f666f726d617428646174655f656e7267742c20272559256d25642729203e3d20646174655f666f726d617428272121646174655f64656275742121272c20272559256d2564272920616e6420646174655f666f726d617428646174655f656e7267742c20272559256d25642729203c3d20646174655f666f726d617428272121646174655f66696e2121272c20272559256d25642729206f7264657220627920656d70725f6e6f6d2c20656d70725f7072656e6f6d2c20747970655f636f6d7074655f69642c20646174655f656e7267742064657363, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="typcom" MANDATORY="yes">\n  <ALIAS><![CDATA[Type de compte]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR="list">\r\n <MULTIPLE>no</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE="1"><![CDATA[Abonnement]]></ITEM>\r\n  <ITEM VALUE="2"><![CDATA[Amende]]></ITEM>\r\n  <ITEM VALUE="3"><![CDATA[Prêt]]></ITEM>\r\n </ITEMS>\r\n <UNSELECT_ITEM VALUE="0"><![CDATA[Tous]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="empr" MANDATORY="yes">\n  <ALIAS><![CDATA[Emprunteur]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>select id_empr, concat(empr_nom,'' '',empr_prenom) from empr order by empr_nom</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE="0">Tous</UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="date_debut" MANDATORY="yes">\n  <ALIAS><![CDATA[Date début]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR="date_box"></OPTIONS>\n </FIELD>\n <FIELD NAME="date_fin" MANDATORY="yes">\n  <ALIAS><![CDATA[Date fin]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR="date_box"></OPTIONS>\n </FIELD>\n</FIELDS>', 17, 0, ''),
(352, 'Liste des documents jamais prêtés', 0x53454c454354206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652c20636f6e63617428224c4956524520222c74697431292061732054697472652046524f4d206e6f7469636573206a6f696e206578656d706c6169726573206f6e206578706c5f6e6f746963653d6e6f746963655f6964204c454654204a4f494e20707265745f61726368697665204f4e206172635f6578706c5f6e6f74696365203d206e6f746963655f6964207768657265206172635f6578706c5f6964204953204e554c4c20414e44206578706c5f6964204953204e4f54204e554c4c20554e494f4e2053454c454354206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652c20636f6e6361742822504552494f20222c746974312c2022204e756de9726f203a20222c62756c6c6574696e5f6e756d65726f292061732054697472652046524f4d202862756c6c6574696e7320494e4e4552204a4f494e206e6f7469636573204f4e2062756c6c6574696e732e62756c6c6574696e5f6e6f74696365203d206e6f74696365732e6e6f746963655f69642920494e4e4552204a4f494e206578656d706c6169726573206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964204c454654204a4f494e20707265745f61726368697665204f4e206578706c5f6964203d206172635f6578706c5f696420574845524520707265745f617263686976652e6172635f6964204973204e756c6c, '', '1', '', 19, 0, ''),
(353, 'Liste des documents les moins empruntés', 0x53454c4543542079656172286172635f64656275742920415320416e6ee9652c20746974312041532054697472652c20434f554e54282a29204153206e625f666f69732046524f4d20707265745f617263686976652c206e6f7469636573205748455245206172635f6578706c5f6e6f746963653d6e6f746963655f696420414e442079656172286172635f6465627574293d272121706172616d5f616e6e65652121272047524f5550204259206172635f6578706c5f6e6f74696365204f52444552204259206e625f666f6973, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param_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>', 19, 0, ''),
(354, 'Liste des documents les plus empruntés', 0x53454c4543542079656172286172635f64656275742920415320416e6ee9652c20746974312041532054697472652c20434f554e54282a29204153206e625f666f69732046524f4d20707265745f617263686976652c206e6f7469636573205748455245206172635f6578706c5f6e6f746963653d6e6f746963655f696420414e442079656172286172635f6465627574293d272121706172616d5f616e6e65652121272047524f5550204259206172635f6578706c5f6e6f74696365204f52444552204259206e625f666f69732044455343, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param_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>', 19, 0, ''),
(355, 'Liste des prêts en cours par localisation', 0x73656c656374206578706c5f63622061732022436f64652d626172726573222c206966286578706c5f6e6f746963653e302c6966286e312e746974343d22222c6e312e746974312c636f6e636174286e312e746974312c22203a20222c6e312e7469743429292c636f6e636174286e706572696f2e746974312c22202f20222c62756c6c6574696e5f6e756d65726f29292061732054697472652c20636f6e63617428617574686f725f6e616d652c222c20222c617574686f725f72656a65746529206173204175746575722c20636f6e63617428656d70725f63622c22203a20222c656d70725f6e6f6d2c222c20222c656d70725f7072656e6f6d2920617320456d7072756e746575722c20444154455f464f524d415428707265745f646174652c202225642f256d2f25592229206173202244617465206465207072ea74222c20444154455f464f524d415428707265745f7265746f75722c202225642f256d2f25592229206173202244617465206465207265746f7572207072e97675222066726f6d2070726574206c656674206a6f696e206578656d706c6169726573206f6e20707265745f69646578706c3d6578706c5f6964206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20726573706f6e736162696c697479206f6e20726573706f6e736162696c6974795f6e6f746963653d6e312e6e6f746963655f696420616e6420726573706f6e736162696c6974795f747970653d3020206c656674206a6f696e20617574686f7273206f6e20617574686f725f69643d726573706f6e736162696c6974795f617574686f72206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e706572696f206f6e2062756c6c6574696e5f6e6f746963653d6e706572696f2e6e6f746963655f6964206c656674206a6f696e20656d7072206f6e2069645f656d70723d707265745f6964656d707220776865726520656d70725f6c6f636174696f6e20696e202821216c6f63616c69736174696f6e212129206f7264657220627920707265745f7265746f7572204153432c20656d70725f6e6f6d204153432c20656d70725f7072656e6f6d20415343, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="localisation" MANDATORY="yes">\n  <ALIAS><![CDATA[localisation]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\n <QUERY><![CDATA[select idlocation, location_libelle from docs_location order by 2]]></QUERY>\n <MULTIPLE>yes</MULTIPLE>\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\n</OPTIONS>\n </FIELD>\n</FIELDS>', 19, 0, ''),
(356, 'Liste des prêts en cours par localisation et section', 0x73656c65637420636f6e63617428273c6120687265663d2e2f636972632e7068703f63617465673d766973755f657826666f726d5f63625f6578706c3d272c6578706c5f63622c273e272c6578706c5f63622c273c2f613e27292061732022436f64652d6261727265222c6578706c5f636f746520617320436f74652c20636f6e636174286966286e6f74696365735f6d2e6e6f746963655f6964206973206e6f74206e756c6c2c636f6e63617428273c6120687265663d2e2f636174616c6f672e7068703f63617465673d697362642669643d272c6e6f74696365735f6d2e6e6f746963655f69642c273e27292c636f6e63617428273c6120687265663d2e2f636174616c6f672e7068703f63617465673d73657269616c73267375623d62756c6c6574696e61676526616374696f6e3d766965772662756c5f69643d272c62756c6c6574696e5f69642c273e2729292c69666e756c6c286e6f74696365735f6d2e746974312c6e6f74696365735f732e74697431292c2720272c69666e756c6c2862756c6c6574696e5f6e756d65726f2c2727292c2720272c69666e756c6c286d656e74696f6e5f646174652c2727292c273c2f613e27292061732054697472652c2073656374696f6e5f6c6962656c6c652061732053656374696f6e2c206c6f636174696f6e5f6c6962656c6c65206173204c6f63616c69736174696f6e2c20636f6e63617428273c6120687265663d2e2f636972632e7068703f63617465673d7072657426666f726d5f63623d272c656d70725f63622c273e272c656d70725f6e6f6d2c20272c20272c656d70725f7072656e6f6d2c273c2f613e272920617320456d7072756e746575722c20646174655f666f726d617428707265745f646174652c2225642d256d2d2559222920617320536f727469652c20646174655f666f726d617428707265745f7265746f75722c2225642d256d2d25592229206173205265746f75722046524f4d202828286578656d706c6169726573204c454654204a4f494e206e6f7469636573204153206e6f74696365735f6d204f4e206578706c5f6e6f74696365203d206e6f74696365735f6d2e6e6f746963655f69642029204c454654204a4f494e2062756c6c6574696e73204f4e206578706c5f62756c6c6574696e203d2062756c6c6574696e732e62756c6c6574696e5f696429204c454654204a4f494e206e6f7469636573204153206e6f74696365735f73204f4e2062756c6c6574696e5f6e6f74696365203d206e6f74696365735f732e6e6f746963655f696429206c656674206a6f696e20646f63735f73656374696f6e206f6e206578706c5f73656374696f6e3d696473656374696f6e206c656674206a6f696e20646f63735f6c6f636174696f6e206f6e206578706c5f6c6f636174696f6e3d69646c6f636174696f6e206c656674206a6f696e2070726574206f6e206578706c5f69643d707265745f69646578706c206c656674206a6f696e20656d7072206f6e20707265745f6964656d70723d69645f656d7072207768657265206578706c5f6c6f636174696f6e20696e2028212163686f69786c6f636121212920616e64206578706c5f73656374696f6e20696e2028212163686f697873656374696f6e21212920616e642069645f656d7072206973206e6f74206e756c6c206f72646572206279203620415343, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="choixloca" MANDATORY="yes">\n  <ALIAS><![CDATA[Localisation(s) :]]></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="choixsection" 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 order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 19, 0, ''),
(357, 'Attribuer pour un utilisateur les mêmes droits sur les paniers en partie catalogue que ceux d''un autre utilisateur', 0x555044415445206361646469650d0a534554206175746f7269736174696f6e733d434f4e434154286175746f7269736174696f6e732c2720272c2721217573657261726174746163686572212127290d0a574845524520286175746f7269736174696f6e733d222121757365726d6f64656c65212122200d0a4f52206175746f7269736174696f6e73204c494b4520222121757365726d6f64656c65212120252220200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c652121202522200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c65212122290d0a414e4420286175746f7269736174696f6e73213d2221217573657261726174746163686572212122200d0a414e44206175746f7269736174696f6e73204e4f54204c494b45202221217573657261726174746163686572212120252220200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121202522200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121222029, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="userarattacher" MANDATORY="yes">\n  <ALIAS><![CDATA[Attribution des droits à l''utilisateur (Destination) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="usermodele" MANDATORY="yes">\n  <ALIAS><![CDATA[Sélectionner l''utilisateur dont les droits sont à dupliquer (Source) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 2, 0, ''),
(358, 'Attribuer pour un utilisateur les mêmes droits sur les paniers en partie circulation que ceux d''un autre utilisateur', 0x55504441544520656d70725f6361646469650d0a534554206175746f7269736174696f6e733d434f4e434154286175746f7269736174696f6e732c2720272c2721217573657261726174746163686572212127290d0a574845524520286175746f7269736174696f6e733d222121757365726d6f64656c65212122200d0a4f52206175746f7269736174696f6e73204c494b4520222121757365726d6f64656c65212120252220200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c652121202522200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c65212122290d0a414e4420286175746f7269736174696f6e73213d2221217573657261726174746163686572212122200d0a414e44206175746f7269736174696f6e73204e4f54204c494b45202221217573657261726174746163686572212120252220200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121202522200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121222029, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="userarattacher" MANDATORY="yes">\n  <ALIAS><![CDATA[Attribution des droits à l''utilisateur (Destination) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="usermodele" MANDATORY="yes">\n  <ALIAS><![CDATA[Sélectionner l''utilisateur dont les droits sont à dupliquer (Source) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 2, 0, ''),
(359, 'Attribuer pour un utilisateur les mêmes droits sur les procédures de paniers en partie catalogue que ceux d''un autre utilisateur', 0x555044415445206361646469655f70726f63730d0a534554206175746f7269736174696f6e733d434f4e434154286175746f7269736174696f6e732c2720272c2721217573657261726174746163686572212127290d0a574845524520286175746f7269736174696f6e733d222121757365726d6f64656c65212122200d0a4f52206175746f7269736174696f6e73204c494b4520222121757365726d6f64656c65212120252220200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c652121202522200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c65212122290d0a414e4420286175746f7269736174696f6e73213d2221217573657261726174746163686572212122200d0a414e44206175746f7269736174696f6e73204e4f54204c494b45202221217573657261726174746163686572212120252220200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121202522200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121222029, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="userarattacher" MANDATORY="yes">\n  <ALIAS><![CDATA[Attribution des droits à l''utilisateur (Destination) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="usermodele" MANDATORY="yes">\n  <ALIAS><![CDATA[Sélectionner l''utilisateur dont les droits sont à dupliquer (Source) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 2, 0, ''),
(360, 'Attribuer pour un utilisateur les mêmes droits sur les procédures de paniers en partie circulation que ceux d''un autre utilisateur', 0x55504441544520656d70725f6361646469655f70726f63730d0a534554206175746f7269736174696f6e733d434f4e434154286175746f7269736174696f6e732c2720272c2721217573657261726174746163686572212127290d0a574845524520286175746f7269736174696f6e733d222121757365726d6f64656c65212122200d0a4f52206175746f7269736174696f6e73204c494b4520222121757365726d6f64656c65212120252220200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c652121202522200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c65212122290d0a414e4420286175746f7269736174696f6e73213d2221217573657261726174746163686572212122200d0a414e44206175746f7269736174696f6e73204e4f54204c494b45202221217573657261726174746163686572212120252220200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121202522200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121222029, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="userarattacher" MANDATORY="yes">\n  <ALIAS><![CDATA[Attribution des droits à l''utilisateur (Destination) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="usermodele" MANDATORY="yes">\n  <ALIAS><![CDATA[Sélectionner l''utilisateur dont les droits sont à dupliquer (Source) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 2, 0, ''),
(361, 'Attribuer pour un utilisateur les mêmes droits sur les statistiques que ceux d''un autre utilisateur', 0x5550444154452070726f63730d0a534554206175746f7269736174696f6e733d434f4e434154286175746f7269736174696f6e732c2720272c2721217573657261726174746163686572212127290d0a574845524520286175746f7269736174696f6e733d222121757365726d6f64656c65212122200d0a4f52206175746f7269736174696f6e73204c494b4520222121757365726d6f64656c65212120252220200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c652121202522200d0a4f52206175746f7269736174696f6e73204c494b45202225202121757365726d6f64656c65212122290d0a414e4420286175746f7269736174696f6e73213d2221217573657261726174746163686572212122200d0a414e44206175746f7269736174696f6e73204e4f54204c494b45202221217573657261726174746163686572212120252220200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121202522200d0a414e44206175746f7269736174696f6e73204e4f54204c494b4520222520212175736572617261747461636865722121222029, '', '1', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="userarattacher" MANDATORY="yes">\n  <ALIAS><![CDATA[Attribution des droits à l''utilisateur (Destination) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="usermodele" MANDATORY="yes">\n  <ALIAS><![CDATA[Sélectionner l''utilisateur dont les droits sont à dupliquer (Source) :]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT userid, username FROM users ORDER BY 2</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 2, 0, ''),
(1, 'Lista ejemplares / estado', 0x73656c656374206578706c5f636f746520617320436f74652c206578706c5f63622061732022436f64652d626172726573222c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652066726f6d206578656d706c6169726573206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f6964207768657265206578706c5f7374617475743d2121706172616d312121206f72646572206279206578706c5f636f7465, 'Lista parametrada de ejempalres por estado', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[Estado]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idstatut,statut_libelle from docs_statut]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[Selecciona un estado]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 0, 0, ''),
(2, 'Recuento ejemplares / estado', 0x73656c656374207374617475745f6c6962656c6c65206173205374617475742c20636f756e74282a29206173204e6f6d6272652066726f6d206578656d706c61697265732c20646f63735f7374617475742077686572652069647374617475743d6578706c5f7374617475742067726f7570206279207374617475745f6c6962656c6c65206f72646572206279206964737461747574, 'Número de ejemplares por estado de ejemplar', '1 4 3 2', NULL, 0, 0, ''),
(3, 'Recuento ejemplares / propietario / estado', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f707269e974616972652c207374617475745f6c6962656c6c65206173205374617475742c20636f756e74282a29206173204e6f6d6272652066726f6d206578656d706c61697265732c206c656e646572732c20646f63735f737461747574207768657265206578706c5f6f776e65723d69646c656e64657220616e64206578706c5f7374617475743d69647374617475742067726f7570206279206c656e6465725f6c6962656c6c652c7374617475745f6c6962656c6c65206f72646572206279206c656e6465725f6c6962656c6c652c7374617475745f6c6962656c6c6520, 'Número de ejemplares por propietario y por estado de ejemplar', '1 4 3 2', NULL, 0, 0, ''),
(4, 'Lista de ejemplare de un propietario / estado', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f707269e974616972652c207374617475745f6c6962656c6c65206173205374617475742c206578706c5f636f746520617320436f74652c206578706c5f63622061732022436f64652d626172726573222c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652066726f6d206578656d706c61697265732c20646f63735f7374617475742c206c656e64657273206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f6964207768657265206578706c5f7374617475743d2121737461747574212120616e64206578706c5f6f776e65723d212150726f707269657461697265212120616e64206578706c5f7374617475743d696473746174757420616e64206578706c5f6f776e65723d69646c656e646572206f72646572206279206c656e6465725f6c6962656c6c652c207374617475745f6c6962656c6c652c206578706c5f636f74652c206578706c5f636220, 'Lista de ejemplares de un propietari por estado, signatura, código de barras, título  (práctico para hacer listas de documentos no marcados antes de una importación)', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="statut" MANDATORY="yes">\n  <ALIAS><![CDATA[Estado]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>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[Propietario]]></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, ''),
(5, 'Recuento ejemplares / sección', 0x73656c6563742073656374696f6e5f6c6962656c6c652061732053656374696f6e2c20636f756e74282a29206173204e6f6d6272652066726f6d206578656d706c61697265732c20646f63735f73656374696f6e20776865726520696473656374696f6e3d6578706c5f73656374696f6e2067726f757020627920696473656374696f6e2c2073656374696f6e5f6c6962656c6c65206f7264657220627920696473656374696f6e, 'Número de ejemplares por sección', '1 4 3 2', NULL, 0, 0, ''),
(6, 'Lista de ejemplares para una o más secciones por propietario', 0x73656c6563742073656374696f6e5f6c6962656c6c652061732053656374696f6e2c206578706c5f636f746520617320436f74652c206578706c5f63622061732022436f64652d626172726573222c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652066726f6d206578656d706c61697265732c20646f63735f73656374696f6e2c206c656e64657273206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f696420776865726520696473656374696f6e20696e2028212173656374696f6e7321212920616e64206578706c5f6f776e65723d212170726574657572212120616e64206578706c5f73656374696f6e3d696473656374696f6e20616e64206578706c5f6f776e65723d69646c656e646572206f726465722062792073656374696f6e5f6c6962656c6c652c206578706c5f636f74652c206578706c5f636220, 'Lista de ejemplares de una o más secciones para un propietario', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="sections" MANDATORY="yes">\n  <ALIAS><![CDATA[Sección(es)]]></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[Propietario]]></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[Escoge un propietario]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 0, 0, ''),
(7, 'Estado : Recuento ejemplares / proprietario', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f707269e974616972652c20636f756e74282a29206173204e6f6d6272652066726f6d206578656d706c61697265732c206c656e646572732077686572652069646c656e6465723d6578706c5f6f776e65722067726f7570206279206578706c5f6f776e65722c206c656e6465725f6c6962656c6c65, 'Núm de ejemmplares por propietario de ejemplar', '1 4 3 2', NULL, 0, 0, ''),
(8, 'Lista ejemplares para un propietario', 0x73656c656374206578706c5f636f746520617320436f74652c206578706c5f63622061732022436f64652d626172726573222c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652066726f6d206578656d706c61697265732c20646f63735f7374617475742c206c656e64657273206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f6964207768657265206578706c5f6f776e65723d212170726f707269657461697265212120616e64206578706c5f7374617475743d696473746174757420616e64206578706c5f6f776e65723d69646c656e646572206f7264657220627920206578706c5f636f74652c206578706c5f636220, 'Lista de los ejemplares para un propietario ordenados por signatura y código de barras', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="proprietaire" MANDATORY="yes">\n  <ALIAS><![CDATA[Propiétario]]></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="">Escoge un propietario</UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 0, 0, ''),
(9, 'Recuento usuarios / categoría', 0x73656c656374206c6962656c6c6520617320436174e9676f7269652c20636f756e74282a2920617320274e6f6d627265206c65637465757273272066726f6d20656d70722c20656d70725f63617465672077686572652069645f63617465675f656d70723d656d70725f63617465672067726f7570206279206c6962656c6c65206f72646572206279206c6962656c6c65, 'Número de usuarios por categoría', '1 4 3 2', NULL, 0, 0, ''),
(10, 'Lista usuarios / categorías', 0x73656c656374206c6962656c6c6520617320436174e9676f7269652c20656d70725f6e6f6d206173204e6f6d2c20656d70725f7072656e6f6d206173205072e96e6f6d2c20656d70725f796561722061732022416e6ee965206465206e61697373616e6365222066726f6d20656d70722c20656d70725f63617465672077686572652069645f63617465675f656d70723d656d70725f6361746567206f72646572206279206c6962656c6c652c20656d70725f6e6f6d2c20656d70725f7072656e6f6d, 'Lista de usuarios por categorías de usuario, usuario', '1 2', NULL, 0, 0, ''),
(11, 'Estadísticas : Recuento de préstamos / categorías de usuarios en un año', 0x53454c4543542043415345205748454e206c6962656c6c65204953204e554c4c205448454e202220436174e9676f726965206465206c6563746575727320696e636f6e6e75652220454c5345206c6962656c6c6520454e4420617320436174e9676f7269652c20636f756e74282a2920617320224e6f6d627265206465207072ea7473222046524f4d20707265745f61726368697665204c454654204a4f494e20656d70725f6361746567204f4e2069645f63617465675f656d7072203d206172635f656d70725f63617465672077686572652079656172286172635f646562757429203d20272121706172616d312121272067726f7570206279206172635f656d70725f6361746567206f7264657220627920436174e9676f726965, 'Número de préstamos por categoría de usuarios en un año', '1 5 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[año]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS></OPTIONS>\n </FIELD>\n <FIELD NAME="mois" MANDATORY="yes">\n  <ALIAS><![CDATA[mes]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR="list">\r\n <MULTIPLE>yes</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE="1"><![CDATA[Enero]]></ITEM>\r\n  <ITEM VALUE="2"><![CDATA[Febrero]]></ITEM>\r\n  <ITEM VALUE="3"><![CDATA[Marzo]]></ITEM>\r\n  <ITEM VALUE="4"><![CDATA[Abril]]></ITEM>\r\n  <ITEM VALUE="5"><![CDATA[Mayo]]></ITEM>\r\n  <ITEM VALUE="6"><![CDATA[Junio]]></ITEM>\r\n  <ITEM VALUE="7"><![CDATA[Julio]]></ITEM>\r\n  <ITEM VALUE="8"><![CDATA[Agosto]]></ITEM>\r\n  <ITEM VALUE="9"><![CDATA[Septiembre]]></ITEM>\r\n  <ITEM VALUE="10"><![CDATA[Octubre]]></ITEM>\r\n  <ITEM VALUE="11"><![CDATA[Noviembre]]></ITEM>\r\n  <ITEM VALUE="12"><![CDATA[Diciembre]]></ITEM>\r\n </ITEMS>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>', 0, 0, ''),
(12, 'Estadísticas : Recuento de usuarios / edad', 0x53454c4543542043415345205748454e2020282121706172616d312121202d20656d70725f7965617229203c3d203133205448454e2027204a757371756520313320616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e313320616e6420282121706172616d312121202d20656d70725f79656172293c3d3234205448454e2027313420e020323420616e7327205748454e20282121706172616d312121202d20656d70725f79656172293e323420616e6420282121706172616d312121202d20656d70725f79656172293c3d3539205448454e2027323520e020353920616e7327205748454e20282121706172616d312121202d20656d70725f79656172293e3539205448454e2027363020616e7320657420706c7573272020454c5345202765727265757220737572206167652720454e4420617320225472616e636865206427e26765222c20636f756e74282a29206173204e6f6d6272652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121706172616d312121206f72207965617228656d70725f646174655f6164686573696f6e293d2121706172616d312121292067726f75702062792031, 'Núm. de usuarios por franjas de edad en un año', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[Año de cálculo]]></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[Categoría]]></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, ''),
(13, 'Estadísticas : Recuento de usuarios / sexo / edad', 0x53454c4543542063617365207768656e20656d70725f736578653d273127207468656e2027486f6d6d657327207768656e20656d70725f736578653d273227207468656e202746656d6d65732720656c736520276572726575722073757220736578652720656e6420617320536578652c2043415345205748454e2020282121706172616d312121202d20656d70725f7965617229203c3d203133205448454e20274a757371756520313320616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e313320616e6420282121706172616d312121202d20656d70725f7965617229203c3d203234205448454e2027313420e020323420616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e323420616e6420282121706172616d312121202d20656d70725f7965617229203c3d203539205448454e2027323520e020353920616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e3539205448454e2027363020616e7320657420706c7573272020454c5345202765727265757220737572206167652720454e4420617320225472616e636865206427e26765222c20636f756e74282a29206173204e6f6d6272652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121706172616d312121206f72207965617228656d70725f646174655f6164686573696f6e293d2121706172616d312121292067726f757020627920736578652c2032, 'Núm. de usuarios por sexo y por franja de edad para un año', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[Año de cálculo]]></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[Categoría]]></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, ''),
(14, 'Estadísticas : Recuento de usuarios / población / categoría', 0x73656c65637420656d70725f76696c6c652061732056696c6c652c20636f756e74282a29206173204e6272652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121616e6e65652121206f72207965617228656d70725f646174655f6164686573696f6e293d2121616e6e65652121292067726f757020627920656d70725f76696c6c65206f7264657220627920656d70725f76696c6c65, 'Número de usuarios por población de residencia para una o más categorías', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="categorie" MANDATORY="yes">\n  <ALIAS><![CDATA[Categoria]]></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[Año de cálculo]]></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, 'Estadísticas : Recuento de préstamos por mes', 0x53454c4543542079656172286172635f64656275742920617320416e6ee9652c206d6f6e7468286172635f646562757429206173204d6f69732c20636f756e74282a2920617320224e6f6d627265206465207072ea7473222046524f4d20707265745f617263686976652077686572652079656172286172635f646562757429203d20272121706172616d312121272067726f757020627920312c2032206f7264657220627920312c2032, 'Número total de préstamos para un año', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[Año de cálculo]]></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, ''),
(16, 'Estadísticas : Recuento de préstamos / sección para un año', 0x53454c4543542043415345205748454e2073656374696f6e5f6c6962656c6c65204953204e554c4c205448454e20222053656374696f6e207375707072696de9652220454c53452073656374696f6e5f6c6962656c6c6520454e442061732053656374696f6e2c20636f756e74282a2920617320224e6f6d627265206465207072ea7473222046524f4d20707265745f61726368697665204c454654204a4f494e20646f63735f73656374696f6e204f4e20696473656374696f6e203d206172635f6578706c5f73656374696f6e2077686572652079656172286172635f646562757429203d20272121706172616d312121272067726f7570206279206172635f6578706c5f73656374696f6e206f726465722062792053656374696f6e, 'Número de préstamos por sección para un año', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[año]]></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[mes]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR="list">\r\n <MULTIPLE>yes</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE="1"><![CDATA[Enero]]></ITEM>\r\n  <ITEM VALUE="2"><![CDATA[Febrero]]></ITEM>\r\n  <ITEM VALUE="3"><![CDATA[Marzo]]></ITEM>\r\n  <ITEM VALUE="4"><![CDATA[Abril]]></ITEM>\r\n  <ITEM VALUE="5"><![CDATA[Mayo]]></ITEM>\r\n  <ITEM VALUE="6"><![CDATA[Junio]]></ITEM>\r\n  <ITEM VALUE="7"><![CDATA[Julio]]></ITEM>\r\n  <ITEM VALUE="8"><![CDATA[Août]]></ITEM>\r\n  <ITEM VALUE="9"><![CDATA[Septiembre]]></ITEM>\r\n  <ITEM VALUE="10"><![CDATA[Octubre]]></ITEM>\r\n  <ITEM VALUE="11"><![CDATA[Noviembre]]></ITEM>\r\n  <ITEM VALUE="12"><![CDATA[Diciembre]]></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
(362,'LLIUREX_RENOV:Canvi de data de finalització de l\'abonament ','Update empr set empr_date_expiration=\'!!date!!\' where empr_date_expiration<curdate()', 'Acció per a renovar als usuaris que tenen caducat l\'abonament','1','<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n<FIELDS>\n <FIELD NAME=\"date\" MANDATORY=\"yes\">\n  <ALIAS><![CDATA[Seleccione la nova data de caducitat:]]></ALIAS>\n  <TYPE>date_box</TYPE>\n<OPTIONS FOR=\"date_box\"></OPTIONS>\n </FIELD>\n</FIELDS>',20,0,'');


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `procs_classements`
--

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

--
-- Volcar la base de datos para la tabla `procs_classements`
--

INSERT INTO `procs_classements` (`idproc_classement`, `libproc_classement`) VALUES
(2, 'Autorisations'),
(5, 'Statistiques DLL'),
(9, 'Statistiques - lecteurs'),
(14, 'Statistiques - exemplaires'),
(15, 'Statistiques - prêts'),
(16, 'Listes - exemplaires'),
(17, 'Listes - lecteurs'),
(18, 'Actions - Nettoyage'),
(19, 'Listes - prêts'),
(20, 'Migration');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `publisher_custom`
--

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

--
--  Volcar la base de datos para la tabla `publisher_custom`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `publisher_custom_lists`
--

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

--
--  Volcar la base de datos para la tabla `publisher_custom_lists`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `publisher_custom_values`
--

CREATE TABLE `publisher_custom_values` (
  `publisher_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `publisher_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `publisher_custom_small_text` varchar(255) DEFAULT NULL,
  `publisher_custom_text` text,
  `publisher_custom_integer` int(11) DEFAULT NULL,
  `publisher_custom_date` date DEFAULT NULL,
  `publisher_custom_float` float DEFAULT NULL,
  KEY `editorial_custom_champ` (`publisher_custom_champ`),
  KEY `editorial_custom_origine` (`publisher_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
--  Volcar la base de datos para la tabla `publisher_custom_values`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `publishers`
--

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

--
-- Volcar la base de datos para la tabla `publishers`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `quotas`
--

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

--
-- Volcar la base de datos para la tabla `quotas`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `quotas_finance`
--

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

--
-- Volcar la base de datos para la tabla `quotas_finance`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `quotas_opac_views`
--

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

--
-- Volcar la base de datos para la tabla `quotas_opac_views`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `rapport_demandes`
--

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

--
-- Volcar la base de datos para la tabla `rapport_demandes`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `rdfstore_index`
--

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


--
-- Dolcar la base de datos para la tabla `rdfstore_index`
--

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `recouvrements`
--

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

--
-- Volcar la base de datos para la tabla `recouvrements`
--

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `resa`
--

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

--
-- Volcar la base de datos para la tabla `resa`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `resa_archive`
--

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

--
-- Volcar la base de datos para la tabla `resa_archive`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `resa_loc`
--

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

--
-- Volcar la base de datos para la tabla `resa_loc`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `resa_planning`
--

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

--
-- Volcar la base de datos para la tabla `resa_planning`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `resa_ranger`
--

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

--
-- Volcar la base de datos para la tabla `resa_ranger`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `responsability`
--

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

--
-- Volcar la base de datos para la tabla `responsability`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `rss_content`
--

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

--
-- Volcar la base de datos para la tabla `rss_content`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `rss_flux`
--

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

--
-- Volcar la base de datos para la tabla `rss_flux`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `rss_flux_content`
--

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

--
-- Volcar la base de datos para la tabla `rss_flux_content`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `rubriques`
--

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

--
-- Volcar la base de datos para la tabla `rubriques`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sauv_lieux`
--

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

--
-- Volcar la base de datos para la tabla `sauv_lieux`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sauv_log`
--

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

--
-- Volcar la base de datos para la tabla `sauv_log`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sauv_sauvegardes`
--

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

--
-- Volcar la base de datos para la tabla `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, 'todo', 'bibli', '7', '', '1,3', 0, 'internal::', 0, '', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sauv_tables`
--

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

--
-- Volcar la base de datos para la tabla `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'),
(2, 'Autoridades', 'authors,categories,collections,noeuds,publishers,responsability,series,sub_collections,thesaurus,voir_aussi'),
(3, 'Ninguna utilidad', 'error_log,import_marc,old_categories,old_notices_categories,sessions'),
(4, 'Z3950', 'z_attr,z_bib,z_notices,z_query'),
(5, 'Usuarios', 'empr,empr_categ,empr_codestat,empr_custom,empr_custom_lists,empr_custom_values,empr_groupe,expl_custom_values,groupe,pret,pret_archive,resa'),
(6, 'Aplicación', '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'),
(7, 'TODO', 'actes,admin_session,analysis,audit,authors,bannette_abon,bannette_contenu,bannette_equation,bannette_exports,bannettes,budgets,bulletins,caddie,caddie_content,caddie_procs,categories,classements,collections,comptes,coordonnees,docs_codestat,docs_location,docs_section,docs_statut,docs_type,docsloc_section,empr,empr_categ,empr_codestat,empr_custom,empr_custom_lists,empr_custom_values,empr_groupe,entites,equations,error_log,etagere,etagere_caddie,exemplaires,exercices,expl_custom,expl_custom_lists,expl_custom_values,explnum,frais,groupe,import_marc,indexint,lenders,liens_actes,lignes_actes,noeuds,notice_statut,notices,notices_categories,notices_custom,notices_custom_lists,notices_custom_values,notices_global_index,offres_remises,opac_sessions,origine_notice,ouvertures,paiements,parametres,pret,pret_archive,procs,publishers,quotas,quotas_finance,recouvrements,resa,resa_ranger,responsability,rss_content,rss_flux,rss_flux_content,rubriques,sauv_lieux,sauv_log,sauv_sauvegardes,sauv_tables,series,sessions,sub_collections,suggestions,suggestions_origine,thesaurus,transactions,tva_achats,type_abts,type_comptes,types_produits,users,voir_aussi,z_attr,z_bib,z_notices,z_query'),
(9, 'Cestas', 'caddie_procs,caddie,caddie_content'),
(10, 'DSI', 'bannette_abon,bannette_contenu,bannette_equation,bannettes,classements,equations,rss_content,rss_flux,rss_flux_content'),
(11, 'Finanzas', 'comptes,quotas_finance,recouvrements,transactions,type_abts,type_comptes');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `search_cache`
--

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

--
-- Volcar la base de datos para la tabla `search_cache`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `search_perso`
--

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

--
-- Volcar la base de datos para la tabla `search_perso`
--

INSERT INTO `search_perso` (`search_id`, `num_user`, `search_name`, `search_shortname`, `search_query`, `search_human`, `search_directlink`) VALUES
(1, 1, 'Contrôle import et pointage BDP', 'BDP', 'a:4:{s:6:"SEARCH";a:3:{i:0;s:4:"f_50";i:1;s:4:"f_16";i:2;s:4:"f_30";}i:0;a:5:{s:6:"SEARCH";s:4:"f_50";s:2:"OP";s:2:"EQ";s:5:"FIELD";a:1:{i:0;s:0:"";}s:5:"INTER";N;s:8:"FIELDVAR";N;}i:1;a:5:{s:6:"SEARCH";s:4:"f_16";s:2:"OP";s:2:"EQ";s:5:"FIELD";N;s:5:"INTER";s:3:"and";s:8:"FIELDVAR";N;}i:2;a:5:{s:6:"SEARCH";s:4:"f_30";s:2:"OP";s:2:"EQ";s:5:"FIELD";N;s:5:"INTER";s:3:"and";s:8:"FIELDVAR";N;}}', ' <i><strong>Date de cr&eacute;ation</strong> = ()</i> <strong>Et</strong> <i><strong>Localisation</strong> = ()</i> <strong>Et</strong> <i><strong>Statut</strong> = ()</i> ', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `search_persopac`
--

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

--
-- Volcar la base de datos para la tabla `search_persopac`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `search_persopac_empr_categ`
--

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

--
-- Volcar la base de datos para la tabla `search_persopac_empr_categ`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `serialcirc`
--

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

--
-- Volcar la base de datos para la tabla `serialcirc`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `serialcirc_ask`
--

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

--
-- Volcar la base de datos para la tabla `serialcirc_ask`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `serialcirc_circ`
--

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

--
-- Volcar la base de datos para la tabla `serialcirc_circ`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `serialcirc_copy`
--

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

--
-- Volcar la base de datos para la tabla `serialcirc_copy`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `serialcirc_diff`
--

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

--
-- Volcar la base de datos para la tabla `serialcirc_diff`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `serialcirc_expl`
--

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

--
-- Volcar la base de datos para la tabla `serialcirc_expl`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `serialcirc_group`
--

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

--
-- Volcar la base de datos para la tabla `serialcirc_group`
--


-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `serie_custom`
--

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


--
-- Volcar la base de datos para la tabla `serie_custom`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `serie_custom_lists`
--

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



--
-- Volcar la base de datos para la tabla `serie_custom_lists`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `serie_custom_values`
--

CREATE TABLE `serie_custom_values` (
  `serie_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `serie_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `serie_custom_small_text` varchar(255) DEFAULT NULL,
  `serie_custom_text` text,
  `serie_custom_integer` int(11) DEFAULT NULL,
  `serie_custom_date` date DEFAULT NULL,
  `serie_custom_float` float DEFAULT NULL,
  KEY `editorial_custom_champ` (`serie_custom_champ`),
  KEY `editorial_custom_origine` (`serie_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `serie_custom_values`
--

-- -------------------------------------------------


--
-- Estructura de tabla para la tabla `series`
--

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

--
-- Volcar la base de datos para la tabla `series`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sessions`
--

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

--
-- Volcar la base de datos para la tabla `sessions`
--

INSERT INTO `sessions` (`SESSID`, `login`, `IP`, `SESSstart`, `LastOn`, `SESSNAME`) VALUES
('1148609339', 'admin', '10.0.0.245', '1361351364', '1361352115', 'PhpMyBibli');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `source_sync`
--

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

--
-- Volcar la base de datos para la tabla `source_sync`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `sources_enrichment`
--

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

--
-- Volcar la base de datos para la tabla `sources_enrichment`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `statopac`
--

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

--
-- Volcar la base de datos para la tabla `statopac`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `statopac_request`
--

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

--
-- Volcar la base de datos para la tabla `statopac_request`
--

INSERT INTO `statopac_request` (`idproc`, `name`, `requete`, `comment`, `parameters`, `num_vue`, `autorisations`) VALUES
(1, 'Nombre de visites par date', 0x73656c656374206461746520617320446174652c20636f756e742864697374696e63742869645f73657373696f6e292920617320274e6f6d6272652064652073657373696f6e732064697374696e63746573272066726f6d2056554528292067726f75702062792064617465206f72646572206279206461746520617363, 'Distingue les sessions', '', 1, ''),
(2, 'Nombre de visites par date (adresses IP)', 0x73656c656374206461746520617320446174652c20616472657373655f4950206173202741647265737365204950272c20636f756e742864697374696e63742869645f73657373696f6e292920617320274e6f6d6272652064652076697369746573272066726f6d2056554528292067726f757020627920646174652c20616472657373655f4950, 'Distingue les adresses IP', '', 1, ''),
(3, 'Mots saisis', 0x73656c656374206d6f74735f73616973697320617320274d6f747320736169736973272c20636f756e74282a2920617320274e6f6d62726520646520666f6973272066726f6d2056554528292067726f7570206279206d6f74735f736169736973, 'Liste les différents mots saisis en recherche.', '', 2, ''),
(4, 'Exports', 0x73656c65637420706167655f737562747970655f746578742c20636f756e742869645f6c69676e6529206173206e625f6578706f72742066726f6d20565545282920776865726520706167655f737562747970653d3830332067726f7570206279206e756d5f73657373696f6e, 'Nombre d''exports lancés depuis l''OPAC', '', 3, ''),
(5, 'Impressions de paniers', 0x73656c65637420706167655f737562747970655f746578742c20636f756e742869645f6c69676e6529206173204e6f6d6272652066726f6d20565545282920776865726520706167655f737562747970653d3830322067726f7570206279206e756d5f73657373696f6e, 'Impressions de paniers lancées depuis l''OPAC', '', 3, ''),
(6, 'Première page affichée', 0x73656c65637420706167655f737562747970655f746578742c20636f756e742869645f6c69676e652920617320274e6f6d62726520646520666f6973272066726f6d2056554528292077686572652075726c5f6f726967696e653d27272067726f75702062792031206f7264657220627920322064657363, 'Première page affichée (quand un lecteur arrive sur l''OPAC) trié par fréquence', '', 3, ''),
(7, 'DSI', 0x73656c65637420636f756e742864697374696e6374286e756d5f73657373696f6e2929206173204e6f6d6272652066726f6d20565545282920776865726520706167655f7375627479706520696e202827373036272c27373037272c273730382729, 'Nombre de lecteurs utilisant la DSI dans l''OPAC', '', 4, ''),
(8, 'Mots les plus cherchés', 0x73656c656374206d6f74735f7361697369732c20636f756e742869645f6c69676e652920617320274e6f6d62726520646520666f6973272066726f6d205655452829207768657265206d6f74735f736169736973213d272720616e64206d6f74735f736169736973206973206e6f74206e756c6c2067726f7570206279206d6f74735f736169736973206f7264657220627920322064657363, 'Affiche les mots les plus saisis dans l''OPAC', '', 2, ''),
(9, 'Recherche multi-critères', 0x73656c656374206d756c74695f6c6162656c2c206d756c74695f636f6e74656e742c206d756c74695f7469746c652c20636f756e74283129206173204e6f6d6272652066726f6d205655452829207768657265206d756c74695f6c6162656c213d2727206f72206d756c74695f636f6e74656e74213d27272067726f7570206279206d756c74695f6c6162656c2c206d756c74695f636f6e74656e74206f72646572206279204e6f6d6272652064657363, 'Recherches multi-critères triées par fréquence', '', 2, ''),
(10, 'Recherches réussies ou non', 0x73656c656374206d6f74735f7361697369732c206d756c74695f636f6e74656e742c206d756c74695f7469746c652c206966286e625f726573756c742c6e625f726573756c742c27617563756e2072e973756c74617427292061732052e973756c746174732066726f6d20565545282920776865726520706167655f7479706520696e20282732272c2733272c2734272920616e6420286d6f74735f736169736973213d2727206f72206d756c74695f636f6e74656e74213d272729206f726465722062792052e973756c7461747320617363, 'Affiche les recherches et précise si elle a affiché des résultats ou non', '', 2, ''),
(11, 'Types de recherche', 0x73656c6563742063617365207768656e20706167655f737562747970653d313031207468656e20275265636865726368652073696d706c6527207768656e20706167655f737562747970653d313032207468656e2027526563686572636865206d756c74692d63726974e872657327207768656e20706167655f737562747970653d313033207468656e202752656368657263686520706172207465726d657327207768656e20706167655f737562747970653d313034207468656e20275265636865726368652065787465726e6527207768656e20706167655f737562747970653d313035207468656e202752656368657263686520706172207461677327207768656e20706167655f737562747970653d313036207468656e2027526563686572636865207072e964e966696e696527207768656e20706167655f737562747970653d313037207468656e202252656368657263686520737572206c6120706167652064276163637565696c2220656c736520706167655f7375627479706520656e64206173205265636865726368652c20636f756e742869645f6c69676e6529206173204e6f6d6272652066726f6d20565545282920776865726520706167655f747970653d27312720616e6420706167655f73756274797065213d27383033272067726f75702062792031206f7264657220627920322064657363, 'Affiche les types de recherches réalisées dans l''OPAC triés par fréquence', '', 2, ''),
(12, 'Consultations des infopages', 0x73656c656374207469746c655f696e666f7061676520617320496e666f706167652c20636f756e742864697374696e63742069645f6c69676e652920617320224e6f6d62726520642761666669636861676573222066726f6d2056554528292c20696e666f706167657320776865726520496e666f70616765206c696b652027252f6f7061632f696e6465782e7068703f6c766c3d696e666f706167657326706167657369643d252720616e642069645f696e666f706167653d737562737472696e675f696e64657828496e666f706167652c27706167657369643d272c2d31292067726f75702062792031, '', '', 5, ''),
(13, 'Fréquentation des sections', 0x73656c6563742073656374696f6e5f6c6962656c6c652061732053656374696f6e2c20636f756e742864697374696e63742069645f6c69676e652920617320274e6f6d62726520646520766973697465732064616e732063657474652073656374696f6e272066726f6d2056554528292c20646f63735f73656374696f6e2077686572652075726c5f61736b6564206c696b652027256c766c3d73656374696f6e5f736565266c6f636174696f6e3d252720616e6420696473656374696f6e3d737562737472696e675f696e6465782875726c5f61736b65642c272669643d272c2d31292067726f75702062792031, '', '', 1, '');

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `statopac_vue_1`
--

CREATE TABLE IF NOT EXISTS `statopac_vue_1` (
`id_ligne` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `id_session` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `adresse_IP` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `url_asked` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_ligne`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `statopac_vue_1`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `statopac_vue_2`
--

CREATE TABLE IF NOT EXISTS `statopac_vue_2` (
 `id_ligne` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `mots_saisis` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_subtype` int(11) NOT NULL,
  `pages_subtype_txt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_type` int(11) NOT NULL,
  `nb_result` int(11) NOT NULL,
  `multi_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `multi_content` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `multi_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_ligne`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `statopac_vue_2`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `statopac_vue_3`
--

CREATE TABLE IF NOT EXISTS `statopac_vue_3` (
 `id_ligne` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `num_session` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` datetime NOT NULL,
  `date` date NOT NULL,
  `url_target` text COLLATE utf8_unicode_ci NOT NULL,
  `url_origine` text COLLATE utf8_unicode_ci NOT NULL,
  `page_subtype` int(11) NOT NULL,
  `page_subtype_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_type` int(11) NOT NULL,
  `page_type_text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
   PRIMARY KEY (`id_ligne`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `statopac_vue_3`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `statopac_vue_4`
--

CREATE TABLE IF NOT EXISTS `statopac_vue_4` (
 `id_ligne` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_subtype` int(11) NOT NULL,
  `pages_subtype_txt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `num_session` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `age` int(11) NOT NULL,
  `groupe` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `statut` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ville` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_ligne`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `statopac_vue_4`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `statopac_vue_5`
--

CREATE TABLE IF NOT EXISTS `statopac_vue_5` (
`id_ligne` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `Infopage` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_ligne`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `statopac_vue_5`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `statopac_vues`
--

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

--
-- Volcar la base de datos para la tabla `statopac_vues`
--

INSERT INTO `statopac_vues` (`id_vue`, `date_consolidation`, `nom_vue`, `comment`, `date_debut_log`, `date_fin_log`) VALUES
(1, '2011-06-15 10:06:24', 'Statistiques visites', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, '2011-06-15 10:06:24', 'Recherches', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, '2011-06-15 10:06:24', 'Navigation', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, '2011-06-15 10:06:24', 'Lecteurs', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, '2011-06-15 10:06:24', 'Infopages', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `statopac_vues_col`
--

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

--
-- Volcar la base de datos para la tabla `statopac_vues_col`
--

INSERT INTO `statopac_vues_col` (`id_col`, `nom_col`, `expression`, `num_vue`, `ordre`, `filtre`, `datatype`, `maj_flag`) VALUES
(1, 'id_session', '#num_session();', 1, 1, '', 'small_text', 0),
(2, 'date', '#date();', 1, 2, '', 'date', 0),
(3, 'adresse_IP', '#adresse_ip();', 1, 3, '', 'small_text', 0),
(4, 'date', '#date();', 2, 1, '', 'date', 0),
(5, 'mots_saisis', '#mots_saisis();', 2, 2, '', 'small_text', 0),
(6, 'num_session', '#num_session();', 3, 1, '', 'small_text', 0),
(7, 'timestamp', '#timestamp();', 3, 2, '', 'datetime', 0),
(8, 'date', '#date();', 3, 3, '', 'date', 0),
(9, 'url_target', '#url_asked();', 3, 4, '', 'text', 0),
(10, 'url_origine', '#url_ori();', 3, 5, '', 'text', 0),
(11, 'page_subtype', '#sous_type_page();', 3, 6, '', 'integer', 0),
(12, 'page_subtype_text', '#sous_type_page_lib();', 3, 7, '', 'small_text', 0),
(13, 'page_type', '#type_page();', 3, 8, '', 'integer', 0),
(14, 'page_type_text', '#type_page_lib();', 3, 9, '', 'small_text', 0),
(15, 'location', '#empr_location();', 3, 10, '', 'small_text', 0),
(16, 'location', '#empr_location();', 4, 1, '', 'small_text', 0),
(17, 'page_subtype', '#sous_type_page();', 4, 2, '', 'integer', 0),
(18, 'pages_subtype_txt', '#sous_type_page_lib();', 4, 3, '', 'small_text', 0),
(19, 'date', '#date();', 4, 4, '', 'date', 0),
(20, 'num_session', '#num_session();', 4, 5, '', 'small_text', 0),
(21, 'age', '#empr_age();', 4, 6, '', 'integer', 0),
(22, 'groupe', '#empr_groupe();', 4, 7, '', 'small_text', 0),
(23, 'code statistique', '#empr_codestat();', 4, 8, '', 'small_text', 0),
(24, 'statut', '#empr_statut();', 4, 9, '', 'small_text', 0),
(25, 'ville', '#empr_ville();', 4, 10, '', 'small_text', 0),
(26, 'page_subtype', '#sous_type_page();', 2, 3, '', 'integer', 0),
(27, 'pages_subtype_txt', '#sous_type_page_txt();', 2, 4, '', 'small_text', 0),
(28, 'page_type', '#type_page();', 2, 5, '', 'integer', 0),
(29, 'nb_result', '#nb_total();', 2, 6, '', 'integer', 0),
(30, 'multi_label', '#multi_libelle();', 2, 7, '', 'small_text', 0),
(31, 'multi_content', '#multi_contenu();', 2, 8, '', 'small_text', 0),
(32, 'multi_title', '#multi_intitule();', 2, 9, '', 'small_text', 0),
(33, 'Infopage', '#url_asked();', 5, 1, '', 'small_text', 0),
(34, 'url_asked', '#url_asked();', 1, 4, '', 'small_text', 0);

-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `storages`
--

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


--
--  Volcar la base de datos para la tabla `storages`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sub_collections`
--

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

--
-- Volcar la base de datos para la tabla `sub_collections`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla`subcollection_custom`
--

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


--
--  Volcar la base de datos para la tabla `subcollection_custom`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `subcollection_custom_lists`
--

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


--
-- Volcar la base de datos para la tabla `subcollection_custom_lists`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `subcollection_custom_values`
--

CREATE TABLE `subcollection_custom_values` (
  `subcollection_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `subcollection_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `subcollection_custom_small_text` varchar(255) DEFAULT NULL,
  `subcollection_custom_text` text,
  `subcollection_custom_integer` int(11) DEFAULT NULL,
  `subcollection_custom_date` date DEFAULT NULL,
  `subcollection_custom_float` float DEFAULT NULL,
  KEY `editorial_custom_champ` (`subcollection_custom_champ`),
  KEY `editorial_custom_origine` (`subcollection_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `subcollection_custom_values`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `suggestions`
--

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

--
-- Volcar la base de datos para la tabla `suggestions`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `suggestions_categ`
--

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

--
-- Volcar la base de datos para la tabla `suggestions_categ`
--

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

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `suggestions_origine`
--

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

--
-- Volcar la base de datos para la tabla `suggestions_origine`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `suggestions_source`
--

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

--
-- Volcar la base de datos para la tabla `suggestions_source`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sur_location`
--

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

--
-- Volcar la base de datos para la tabla `sur_location`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `taches`
--

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

--
-- Volcar la base de datos para la tabla `taches`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `taches_docnum`
--

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

--
-- Volcar la base de datos para la tabla `taches_docnum`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `taches_type`
--

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

--
-- Volcar la base de datos para la tabla `taches_type`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tags`
--

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

--
-- Volcar la base de datos para la tabla `tags`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `thesaurus`
--

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

--
-- Volcar la base de datos para la tabla `thesaurus`
--

INSERT INTO `thesaurus` (`id_thesaurus`, `libelle_thesaurus`, `langue_defaut`, `active`, `opac_active`, `num_noeud_racine`) VALUES
(1, 'Tesauro n°1', 'es_ES', '1', '1', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `titres_uniformes`
--

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

--
-- Volcar la base de datos para la tabla `titres_uniformes`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `transacash`
--

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

--
-- Volcar la base de datos para la tabla `transacash`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `transactions`
--

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

--
-- Volcar la base de datos para la tabla `transactions`
--


-- --------------------------------------------------------

--
-- TEstructura de tabla para la tabla `transactype`
--

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


--
--  Volcar la base de datos para la tabla `transactype`
--
-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `transferts`
--

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

--
-- Volcar la base de datos para la tabla `transferts`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `transferts_demande`
--

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

--
-- Volcar la base de datos para la tabla `transferts_demande`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `transferts_source`
--

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


--
-- Volcar la base de datos para la tabla ``transferts_source`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `translation`
--

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

--
-- Volcar la base de datos para la tabla `translation`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tris`
--

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

--
-- Volcar la base de datos para la tabla `tris`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tu_custom`
--

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

--
-- Volcar la base de datos para la tabla`tu_custom`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tu_custom_lists`
--


CREATE TABLE `tu_custom_lists` (
  `tu_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `tu_custom_list_value` varchar(255) DEFAULT NULL,
  `tu_custom_list_lib` varchar(255) DEFAULT NULL,
  `ordre` int(11) DEFAULT NULL,
  KEY `editorial_custom_champ` (`tu_custom_champ`),
  KEY `editorial_champ_list_value` (`tu_custom_champ`,`tu_custom_list_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla`tu_custom_lists`
--

-- --------------------------------------------------------

--
--  Estructura de tabla para la tabla `tu_custom_values`
--

CREATE TABLE `tu_custom_values` (
  `tu_custom_champ` int(10) unsigned NOT NULL DEFAULT '0',
  `tu_custom_origine` int(10) unsigned NOT NULL DEFAULT '0',
  `tu_custom_small_text` varchar(255) DEFAULT NULL,
  `tu_custom_text` text,
  `tu_custom_integer` int(11) DEFAULT NULL,
  `tu_custom_date` date DEFAULT NULL,
  `tu_custom_float` float DEFAULT NULL,
  KEY `editorial_custom_champ` (`tu_custom_champ`),
  KEY `editorial_custom_origine` (`tu_custom_origine`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Volcar la base de datos para la tabla `tu_custom_values`
--

-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `tu_distrib`
--

CREATE TABLE IF NOT EXISTS `tu_distrib` (
 `distrib_num_tu` int(9) unsigned NOT NULL DEFAULT '0',
  `distrib_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `distrib_ordre` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`distrib_num_tu`,`distrib_ordre`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `tu_distrib`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tu_ref`
--

CREATE TABLE IF NOT EXISTS `tu_ref` (
 `ref_num_tu` int(9) unsigned NOT NULL DEFAULT '0',
  `ref_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ref_ordre` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ref_num_tu`,`ref_ordre`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `tu_ref`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tu_subdiv`
--

CREATE TABLE IF NOT EXISTS `tu_subdiv` (
 `subdiv_num_tu` int(9) unsigned NOT NULL DEFAULT '0',
  `subdiv_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `subdiv_ordre` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`subdiv_num_tu`,`subdiv_ordre`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `tu_subdiv`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tva_achats`
--

CREATE TABLE IF NOT EXISTS `tva_achats` (
`id_tva` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `taux_tva` float(4,2) unsigned NOT NULL DEFAULT '0.00',
  `num_cp_compta` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_tva`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `tva_achats`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `type_abts`
--

CREATE TABLE IF NOT EXISTS `type_abts` (
   `id_type_abt` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `type_abt_libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `prepay` int(1) unsigned NOT NULL DEFAULT '0',
  `prepay_deflt_mnt` decimal(16,2) NOT NULL DEFAULT '0.00',
  `tarif` decimal(16,2) NOT NULL DEFAULT '0.00',
  `commentaire` text COLLATE utf8_unicode_ci NOT NULL,
  `caution` decimal(16,2) NOT NULL DEFAULT '0.00',
  `localisations` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_type_abt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `type_abts`
--


-- --------------------------------------------------------


--
-- Estructura de tabla para la tabla `type_comptes`
--

CREATE TABLE IF NOT EXISTS `type_comptes` (
`id_type_compte` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type_acces` int(8) unsigned NOT NULL DEFAULT '0',
  `acces_id` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_type_compte`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `type_comptes`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `types_produits`
--

CREATE TABLE IF NOT EXISTS `types_produits` (
 `id_produit` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `num_cp_compta` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `num_tva_achat` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_produit`),
  KEY `libelle` (`libelle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `types_produits`
--


--
-- Estructura de tabla para la tabla `upload_repertoire`
--

CREATE TABLE IF NOT EXISTS `upload_repertoire` (
`repertoire_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `repertoire_nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `repertoire_url` text COLLATE utf8_unicode_ci NOT NULL,
  `repertoire_path` text COLLATE utf8_unicode_ci NOT NULL,
  `repertoire_navigation` int(1) NOT NULL DEFAULT '0',
  `repertoire_hachage` int(1) NOT NULL DEFAULT '0',
  `repertoire_subfolder` int(8) NOT NULL DEFAULT '0',
  `repertoire_utf8` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`repertoire_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `upload_repertoire`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users`
--

CREATE TABLE IF NOT EXISTS `users` (
 `userid` int(5) NOT NULL AUTO_INCREMENT,
  `create_dt` date NOT NULL DEFAULT '0000-00-00',
  `last_updated_dt` date NOT NULL DEFAULT '0000-00-00',
  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pwd` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_digest` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `nom` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `prenom` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rights` int(8) unsigned NOT NULL DEFAULT '0',
  `user_lang` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'fr_FR',
  `nb_per_page_search` int(10) unsigned NOT NULL DEFAULT '4',
  `nb_per_page_select` int(10) unsigned NOT NULL DEFAULT '10',
  `nb_per_page_gestion` int(10) unsigned NOT NULL DEFAULT '20',
  `param_popup_ticket` smallint(1) unsigned NOT NULL DEFAULT '0',
  `param_sounds` smallint(1) unsigned NOT NULL DEFAULT '1',
  `param_rfid_activate` int(1) NOT NULL DEFAULT '1',
  `param_licence` int(1) unsigned NOT NULL DEFAULT '0',
  `deflt_notice_statut` int(6) unsigned NOT NULL DEFAULT '1',
  `deflt_integration_notice_statut` int(6) NOT NULL DEFAULT '1',
  `xmlta_indexation_lang` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `deflt_docs_type` int(6) unsigned NOT NULL DEFAULT '1',
  `deflt_lenders` int(6) unsigned NOT NULL DEFAULT '0',
  `deflt_styles` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
  `deflt_docs_statut` int(6) unsigned DEFAULT '0',
  `deflt_docs_codestat` int(6) unsigned DEFAULT '0',
  `value_deflt_lang` varchar(20) COLLATE utf8_unicode_ci DEFAULT 'fre',
  `value_deflt_fonction` varchar(20) COLLATE utf8_unicode_ci DEFAULT '070',
  `value_deflt_relation` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  `value_deflt_relation_serial` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value_deflt_relation_bulletin` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value_deflt_relation_analysis` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `deflt_docs_location` int(6) unsigned DEFAULT '0',
  `deflt_collstate_location` int(6) unsigned DEFAULT '0',
  `deflt_resas_location` int(6) unsigned DEFAULT '0',
  `deflt_docs_section` int(6) unsigned DEFAULT '0',
  `value_deflt_module` varchar(30) COLLATE utf8_unicode_ci DEFAULT 'circu',
  `user_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `user_alert_resamail` int(1) unsigned NOT NULL DEFAULT '0',
  `user_alert_demandesmail` int(1) unsigned NOT NULL DEFAULT '0',
  `user_alert_subscribemail` int(1) unsigned NOT NULL DEFAULT '0',
  `deflt2docs_location` int(6) unsigned NOT NULL DEFAULT '0',
  `deflt_empr_statut` bigint(20) unsigned NOT NULL DEFAULT '1',
  `deflt_thesaurus` int(3) unsigned NOT NULL DEFAULT '1',
  `deflt_import_thesaurus` int(11) NOT NULL DEFAULT '1',
  `value_prefix_cote` tinyblob NOT NULL,
  `xmlta_doctype` char(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'a',
  `xmlta_doctype_serial` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `xmlta_doctype_bulletin` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `xmlta_doctype_analysis` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `speci_coordonnees_etab` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `value_email_bcc` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value_deflt_antivol` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `explr_invisible` text COLLATE utf8_unicode_ci,
  `explr_visible_mod` text COLLATE utf8_unicode_ci,
  `explr_visible_unmod` text COLLATE utf8_unicode_ci,
  `deflt3bibli` int(5) unsigned NOT NULL DEFAULT '0',
  `deflt3exercice` int(8) unsigned NOT NULL DEFAULT '0',
  `deflt3rubrique` int(8) unsigned NOT NULL DEFAULT '0',
  `deflt3dev_statut` int(3) NOT NULL DEFAULT '-1',
  `deflt3cde_statut` int(3) NOT NULL DEFAULT '-1',
  `deflt3liv_statut` int(3) NOT NULL DEFAULT '-1',
  `deflt3fac_statut` int(3) NOT NULL DEFAULT '-1',
  `deflt3sug_statut` int(3) NOT NULL DEFAULT '-1',
  `environnement` mediumblob NOT NULL,
  `param_allloc` int(1) unsigned NOT NULL DEFAULT '0',
  `grp_num` int(10) unsigned DEFAULT '0',
  `deflt_arch_statut` int(6) unsigned NOT NULL DEFAULT '0',
  `deflt_arch_emplacement` int(6) unsigned NOT NULL DEFAULT '0',
  `deflt_arch_type` int(6) unsigned NOT NULL DEFAULT '0',
  `deflt_upload_repertoire` int(8) NOT NULL DEFAULT '0',
  `deflt3lgstatdev` int(3) NOT NULL DEFAULT '1',
  `deflt3lgstatcde` int(3) NOT NULL DEFAULT '1',
  `deflt3receptsugstat` int(3) NOT NULL DEFAULT '32',
  `deflt_short_loan_activate` int(1) unsigned NOT NULL DEFAULT '0',
  `deflt_cashdesk` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Volcar la base de datos para la tabla `users`
--

INSERT INTO `users` (`userid`, `create_dt`, `last_updated_dt`, `username`, `pwd`, `user_digest`, `nom`, `prenom`, `rights`, `user_lang`, `nb_per_page_search`, `nb_per_page_select`, `nb_per_page_gestion`, `param_popup_ticket`, `param_sounds`, `param_rfid_activate`, `param_licence`, `deflt_notice_statut`, `deflt_integration_notice_statut`, `deflt_docs_type`, `deflt_lenders`, `deflt_styles`, `deflt_docs_statut`, `deflt_docs_codestat`, `value_deflt_lang`, `value_deflt_fonction`, `value_deflt_relation`, `deflt_docs_location`, `deflt_collstate_location`, `deflt_resas_location`, `deflt_docs_section`, `value_deflt_module`, `user_email`, `user_alert_resamail`, `user_alert_demandesmail`, `deflt2docs_location`, `deflt_empr_statut`, `deflt_thesaurus`, `deflt_import_thesaurus`, `value_prefix_cote`, `xmlta_doctype`, `xmlta_doctype_serial`, `xmlta_doctype_bulletin`, `xmlta_doctype_analysis`, `speci_coordonnees_etab`, `value_email_bcc`, `value_deflt_antivol`, `explr_invisible`, `explr_visible_mod`, `explr_visible_unmod`, `deflt3bibli`, `deflt3exercice`, `deflt3rubrique`, `deflt3dev_statut`, `deflt3cde_statut`, `deflt3liv_statut`, `deflt3fac_statut`, `deflt3sug_statut`, `environnement`, `param_allloc`, `grp_num`, `deflt_arch_statut`, `deflt_arch_emplacement`, `deflt_arch_type`, `deflt_upload_repertoire`, `deflt3lgstatdev`, `deflt3lgstatcde`, `deflt3receptsugstat`) VALUES
(1, '2002-07-28', '2013-02-20', 'admin', '*4ACFE3202A5FF5CF467898FC58AAB1D615029441', '', 'Super User', '', 2303, 'es_ES', 20, 10, 20, 0, 1, 1, 1, 1, 1, 1, 2, 'light', 1, 12, 'spa', '070', 'a', 1, 0, 0, 10, 'admin', 'pmb@sigb.net', 1, 0, 1, 1, 1, 1, '', 'a', 'a', '0', '0', '', '', '0', '0', '0', '0', 0, 0, 0, -1, -1, -1, -1, -1, '', 0, 0, 1, 1, 1, 0, 1, 1, 32),
(2, '2004-01-21', '2005-08-10', 'circ', '*32C97A536D5B9EE7B026D62958A8F14C92C9D1D3', '', 'Becario', '', 1, 'es_ES', 10, 10, 20, 0, 1, 1, 0, 1, 1, 1, 1, 'vert_et_parme', 1, 10, 'spa', '070', 'a', 1, 0, 0, 26, 'circu', '', 0, 0, 1, 1, 1, 1, '', 'a', '', '', '', '', '', '0', NULL, NULL, NULL, 0, 0, 0, -1, -1, -1, -1, -1, '', 0, 0, 0, 0, 0, 0, 1, 1, 32),
(3, '2004-01-21', '2005-08-10', 'cat', '*FD98809C60DD51B6B380DB17B72F9A9E2FE1928F', '', 'Bibliotecario auxiliar', '', 7, 'es_ES', 10, 10, 20, 0, 1, 1, 0, 1, 1, 1, 1, 'default', 1, 10, 'spa', '070', 'a', 1, 0, 0, 26, 'catal', '', 0, 0, 1, 1, 1, 1, '', 'a', '', '', '', '', '', '0', NULL, NULL, NULL, 0, 0, 0, -1, -1, -1, -1, -1, '', 0, 0, 0, 0, 0, 0, 1, 1, 32),
(4, '2004-01-21', '2005-08-10', 'bib', '*09EC8C1768A5648B27E281FECD36C0BE342B7217', '', 'Bibliotecario', '', 23, 'es_ES', 10, 10, 20, 0, 1, 1, 0, 1, 1, 1, 1, 'default', 13, 12, 'spa', '070', 'a', 7, 0, 0, 26, 'circu', '', 0, 0, 1, 1, 1, 1, '', 'a', '', '', '', '', '', '0', NULL, NULL, NULL, 0, 0, 0, -1, -1, -1, -1, -1, '', 0, 0, 0, 0, 0, 0, 1, 1, 32);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users_groups`
--

CREATE TABLE IF NOT EXISTS `users_groups` (
`grp_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `grp_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`grp_id`),
  KEY `i_users_groups_grp_name` (`grp_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `users_groups`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `visionneuse_params`
--

CREATE TABLE IF NOT EXISTS `visionneuse_params` (
`visionneuse_params_id` int(11) NOT NULL AUTO_INCREMENT,
  `visionneuse_params_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `visionneuse_params_parameters` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`visionneuse_params_id`),
  UNIQUE KEY `visionneuse_params_class` (`visionneuse_params_class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `visionneuse_params`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `voir_aussi`
--

CREATE TABLE IF NOT EXISTS `voir_aussi` (
 `num_noeud_orig` int(9) unsigned NOT NULL DEFAULT '0',
  `num_noeud_dest` int(9) unsigned NOT NULL DEFAULT '0',
  `langue` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment_voir_aussi` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`num_noeud_orig`,`num_noeud_dest`,`langue`),
  KEY `num_noeud_dest` (`num_noeud_dest`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `voir_aussi`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `words`
--

CREATE TABLE IF NOT EXISTS `words` (
`id_word` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `word` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `lang` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `double_metaphone` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `stem` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_word`),
  UNIQUE KEY `i_word_lang` (`word`,`lang`),
  KEY `i_stem_lang` (`stem`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `words`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `z_attr`
--

CREATE TABLE IF NOT EXISTS `z_attr` (
`attr_bib_id` int(6) unsigned NOT NULL DEFAULT '0',
  `attr_libelle` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `attr_attr` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`attr_bib_id`,`attr_libelle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Volcar la base de datos para la tabla `z_attr`
--

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

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `z_bib`
--

CREATE TABLE IF NOT EXISTS `z_bib` (
 `bib_id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `bib_nom` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `search_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `port` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `base` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `format` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `auth_user` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `auth_pass` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sutrs_lang` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fichier_func` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`bib_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=22 ;

--
-- Volcar la base de datos para la tabla `z_bib`
--

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

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `z_notices`
--

CREATE TABLE IF NOT EXISTS `z_notices` (
 `znotices_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `znotices_query_id` int(11) DEFAULT NULL,
  `znotices_bib_id` int(6) unsigned DEFAULT '0',
  `isbd` text COLLATE utf8_unicode_ci,
  `isbn` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `titre` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `auteur` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `z_marc` longblob NOT NULL,
  PRIMARY KEY (`znotices_id`),
  KEY `idx_z_notices_idq` (`znotices_query_id`),
  KEY `idx_z_notices_isbn` (`isbn`),
  KEY `idx_z_notices_titre` (`titre`),
  KEY `idx_z_notices_auteur` (`auteur`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `z_notices`
--


-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `z_query`
--

CREATE TABLE IF NOT EXISTS `z_query` (
 `zquery_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `search_attr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zquery_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`zquery_id`),
  KEY `zquery_date` (`zquery_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Volcar la base de datos para la tabla `z_query`
--

