-- +-------------------------------------------------+
-- © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net y colaboradores (ver www.sigb.net)
-- +-------------------------------------------------+
-- $Id: feed_essential.sql,v 1.2 2008-07-07 12:48:10 ngantier Exp $
-- 
-- Conteúdo da tabela `caddie`
-- 

INSERT INTO caddie (idcaddie, name, type, comment, autorisations) VALUES (1, 'Registos para exposição', 'NOTI', 'Incluir neste cesto os registos da exposição virtual', '1 2');
INSERT INTO caddie (idcaddie, name, type, comment, autorisations) VALUES (2, 'Registos a devolver à BDP', 'NOTI', 'Encher este cesto como controlo dos registos que se vão devolver', '1 2');
INSERT INTO caddie (idcaddie, name, type, comment, autorisations) VALUES (3, 'Exemplares a devolver à BDP', 'EXPL', 'Encher este cesto com os exemplares dos documentos a devolver à BDP', '1 2');
INSERT INTO caddie (idcaddie, name, type, comment, autorisations) VALUES (4, 'Registos com o título duplicado', 'NOTI', 'Duplicados do primeiro título', '1 2');
INSERT INTO caddie (idcaddie, name, type, comment, autorisations) VALUES (8, 'Exemplo de cesto de exemplares', 'EXPL', '', '1 4 3 2');
INSERT INTO caddie (idcaddie, name, type, comment, autorisations) VALUES (5, 'Loire - Registos para o tema do mês', 'NOTI', '', '1 4');
INSERT INTO caddie (idcaddie, name, type, comment, autorisations) VALUES (6, 'Loire - Números que contém os artigos para a exposição do mês', 'BULL', '', '1 4');
INSERT INTO caddie (idcaddie, name, type, comment, autorisations) VALUES (7, 'Cochon - registos para a exposição do próximo mês', 'NOTI', '', '1');

-- 
-- Conteúdo da tabela `caddie_procs`
-- 

INSERT INTO caddie_procs (idproc, type, name, requete, comment, autorisations, parameters) VALUES (1, 'SELECT', 'Registos por autor', 0x53454c454354206e6f746963655f6964206173206f626a6563745f69642c20274e4f544927206173206f626a6563745f747970652046524f4d206e6f74696365732c20617574686f72732c20726573706f6e736162696c69747920574845524520617574686f725f6e616d65206c696b652027252121637269746572652121252720414e4420617574686f725f69643d726573706f6e736162696c6974795f617574686f7220414e44206e6f746963655f69643d726573706f6e736162696c6974795f6e6f746963650d0a, 'Selecção de registos de onde o nome do autor contém certas letras', '1 2 3', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="critere" MANDATORY="yes">\n  <ALIAS><![CDATA[Caracteres incluídos no apelido]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>25</SIZE>\r\n <MAXSIZE>25</MAXSIZE>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO caddie_procs (idproc, type, name, requete, comment, autorisations, parameters) VALUES (2, 'SELECT', 'Registos duplicados', 0x6372656174652054454d504f52415259205441424c4520746d702053454c45435420746974312046524f4d206e6f74696365732047524f5550204259207469743120484156494e4720636f756e74282a293e310d0a53454c454354206e6f746963655f6964206173206f626a6563745f69642c20274e4f544927206173206f626a6563745f747970652046524f4d206e6f74696365732c20746d70207748455245206e6f74696365732e746974313d746d702e74697431, 'Selecção dos registos duplicados pelo título principal', '1 2 3', NULL);
INSERT INTO caddie_procs (idproc, type, name, requete, comment, autorisations, parameters) VALUES (3, 'SELECT', 'EXPL por secção / proprietário', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d206578656d706c6169726573207768657265206578706c5f73656374696f6e20696e2028212173656374696f6e21212920616e64206578706c5f6f776e65723d212170726f7072696f2121, 'Selecção de exemplares por secção e por proprietário', '1 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="section" MANDATORY="yes">\n  <ALIAS><![CDATA[Sección]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idsection, section_libelle from docs_section order by section_libelle]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="proprio" MANDATORY="yes">\n  <ALIAS><![CDATA[Proprietario]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>select idlender, lender_libelle from lenders order by lender_libelle</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO caddie_procs (idproc, type, name, requete, comment, autorisations, parameters) VALUES (4, 'SELECT', 'EXPL que a assinatura começa por', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d206578656d706c6169726573207768657265206578706c5f636f7465206c696b6520272121636f6d6d655f636f746521212527, 'Selecção de exemplares a partir do início da sua assinatura', '1 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="comme_cote" MANDATORY="no">\n  <ALIAS><![CDATA[Início da assinatura]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS FOR="text">\r\n <SIZE>20</SIZE>\r\n <MAXSIZE>20</MAXSIZE>\r\n</OPTIONS> \n </FIELD>\n</FIELDS>');
INSERT INTO caddie_procs (idproc, type, name, requete, comment, autorisations, parameters) VALUES (5, 'ACTION', 'Cambio de estado dos exemplares', 0x757064617465206578656d706c616972657320736574206578706c5f7374617475743d21216e6f75766561755f7374617475742121207768657265206578706c5f696420696e2028434144444945284558504c2929, 'Permite mudar o estado dos exemplares de um cesto', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="nouveau_statut" MANDATORY="yes">\n  <ALIAS><![CDATA[nouveau_statut]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>SELECT idstatut, statut_libelle FROM docs_statut</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO caddie_procs (idproc, type, name, requete, comment, autorisations, parameters) VALUES (6, 'SELECT', 'Nunca prestados', 0x53454c454354206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652c20636f6e63617428224c4956524520222c74697431292061732054697472652046524f4d206e6f7469636573206a6f696e206578656d706c6169726573206f6e206578706c5f6e6f746963653d6e6f746963655f6964204c454654204a4f494e20707265745f61726368697665204f4e206172635f6578706c5f6e6f74696365203d206e6f746963655f6964207768657265206172635f6578706c5f6964204953204e554c4c20414e44206578706c5f6964204953204e4f54204e554c4c20554e494f4e2053454c454354206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652c20636f6e6361742822504552494f20222c746974312c2022204e756de9726f203a20222c62756c6c6574696e5f6e756d65726f292061732054697472652046524f4d202862756c6c6574696e7320494e4e4552204a4f494e206e6f7469636573204f4e2062756c6c6574696e732e62756c6c6574696e5f6e6f74696365203d206e6f74696365732e6e6f746963655f69642920494e4e4552204a4f494e206578656d706c6169726573206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964204c454654204a4f494e20707265745f61726368697665204f4e206578706c5f6964203d206172635f6578706c5f696420574845524520707265745f617263686976652e6172635f6964204973204e756c6c, 'Adiciona a um cesto os exemplares que nunca se emprestaram', '1 2', NULL);
INSERT INTO caddie_procs (idproc, type, name, requete, comment, autorisations, parameters) VALUES (7, 'SELECT', 'Selecção de exemplares por estado', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d206578656d706c6169726573207768657265206578706c5f73746174757420696e20282121737461747574212129, '', '1 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><![CDATA[select idstatut, statut_libelle from docs_statut]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO caddie_procs (idproc, type, name, requete, comment, autorisations, parameters) VALUES (8, 'SELECT', 'Selecção de exemplares por localização, secção, estado, proprietário', 0x73656c656374206578706c5f6964206173206f626a6563745f69642c20274558504c27206173206f626a6563745f747970652066726f6d206578656d706c6169726573207768657265206578706c5f73656374696f6e20696e2028212173656374696f6e21212920616e64206578706c5f6c6f636174696f6e20696e202821216c6f636174696f6e21212920616e64206578706c5f73746174757420696e2028212173746174757421212920616e64206578706c5f6f776e65723d212170726f7072696f21212020, '', '1 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="section" MANDATORY="yes">\n  <ALIAS><![CDATA[Sección]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idsection, section_libelle from docs_section order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="location" MANDATORY="yes">\n  <ALIAS><![CDATA[Localización]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idlocation, location_libelle from docs_location order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="statut" MANDATORY="yes">\n  <ALIAS><![CDATA[Estado]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idstatut, statut_libelle from docs_statut order by 2]]></QUERY>\r\n <MULTIPLE>yes</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n <FIELD NAME="proprio" MANDATORY="yes">\n  <ALIAS><![CDATA[Proprietario]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select idlender, lender_libelle from lenders order by 2]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO caddie_procs (idproc, type, name, requete, comment, autorisations, parameters) VALUES (9, 'ACTION', 'Mudar a secção dos exemplares', 0x757064617465206578656d706c616972657320736574206578706c5f73656374696f6e3d21216e6f7576656c6c655f73656374696f6e2121207768657265206578706c5f696420696e2028434144444945284558504c2929, '', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="nouvelle_section" MANDATORY="yes">\n  <ALIAS><![CDATA[nova secção]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY><![CDATA[select * from docs_section order by section_libelle]]></QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[Escolha uma secção]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');

-- 
-- Conteúdo da tabela `docs_codestat`
-- 

INSERT INTO docs_codestat (idcode, codestat_libelle, statisdoc_codage_import, statisdoc_owner) VALUES (10, 'Indeterminado', 'u', 0);
INSERT INTO docs_codestat (idcode, codestat_libelle, statisdoc_codage_import, statisdoc_owner) VALUES (11, 'Jovens', 'j', 0);
INSERT INTO docs_codestat (idcode, codestat_libelle, statisdoc_codage_import, statisdoc_owner) VALUES (12, 'Adultos', 'a', 0);

-- 
-- Conteúdo da tabela `docs_location`
-- 

INSERT INTO docs_location (idlocation, location_libelle, locdoc_codage_import, locdoc_owner, location_pic, location_visible_opac, name, adr1, adr2, cp, town, state, country, phone, email, website, logo, logosmall) VALUES (1, 'Biblioteca principal', '', 2, 'images/site/bib_princ.jpg', 1, 'Biblioteca teste de PMB', 'PMB Services', '24 & 26, place des Halles', '72500', 'CHATEAU DU LOIR', '', 'França', '02 43 440 660', 'pmb@sigb.net', 'http://www.sigb.net/', 'logo_default.jpg', 'logo_default_small.jpg');
INSERT INTO docs_location (idlocation, location_libelle, locdoc_codage_import, locdoc_owner, location_pic, location_visible_opac, name, adr1, adr2, cp, town, state, country, phone, email, website, logo, logosmall) VALUES (2, 'Reserva', '', 2, '', 0, 'Biblioteca teste de PMB', '', '', '', '', '', '', '', 'pmb@sigb.net', 'http://www.sigb.net', 'logo_default.jpg', 'logo_default_small.jpg');
INSERT INTO docs_location (idlocation, location_libelle, locdoc_codage_import, locdoc_owner, location_pic, location_visible_opac, name, adr1, adr2, cp, town, state, country, phone, email, website, logo, logosmall) VALUES (7, 'Bibliobús', '', 2, 'images/site/bibliobus.jpg', 1, 'Biblioteca teste de PMB', 'rue da culture', '', '72500', 'Château du loir', '', 'Francia', '02 43 440 660', 'pmb@sigb.net', 'http://www.sigb.net', 'logo_default.jpg', 'logo_default_small.jpg');

-- 
-- Conteúdo da tabela `docs_section`
-- 

INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (10, 'Documentários', '', 2, 'images/site/documentaire.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (11, 'Documentários Infantis', '', 2, 'images/site/documentaire.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (12, 'Novelas Infantis', '', 2, 'images/site/enfants.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (13, 'Novelas Juvenis', '', 2, 'images/site/sec3.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (16, 'BD Adultos', '', 2, 'images/site/sec1.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (17, 'BD Infantis', '', 2, 'images/site/enfants.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (18, 'H (História local)', '', 2, 'images/site/histoire.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (19, 'FR (Fundo Regional)', '', 2, 'images/site/sec4.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (20, 'BD Juvenis', '', 2, 'images/site/sec3.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (21, 'Novelas policiais', '', 2, 'images/site/sec1.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (23, 'Novelas letra grande', '', 2, 'images/site/large_vue.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (24, 'Novelas & Novelas estrangeiras', '', 2, 'images/site/sec1.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (25, 'Documentários Juvenis', '', 2, 'images/site/documentaire.jpg', 1);
INSERT INTO docs_section (idsection, section_libelle, sdoc_codage_import, sdoc_owner, section_pic, section_visible_opac) VALUES (26, 'Contos Infantis', '', 2, 'images/site/enfants.jpg', 1);

-- 
-- Conteúdo da tabela `docs_statut`
-- 

INSERT INTO docs_statut (idstatut, statut_libelle, pret_flag, statusdoc_codage_import, statusdoc_owner) VALUES (1, 'Documento em bom estado', 1, '', 0);
INSERT INTO docs_statut (idstatut, statut_libelle, pret_flag, statusdoc_codage_import, statusdoc_owner) VALUES (2, 'Em fase de importação/aquisição', 0, '', 0);
INSERT INTO docs_statut (idstatut, statut_libelle, pret_flag, statusdoc_codage_import, statusdoc_owner) VALUES (11, 'Deteriorado', 0, '', 0);
INSERT INTO docs_statut (idstatut, statut_libelle, pret_flag, statusdoc_codage_import, statusdoc_owner) VALUES (12, 'Perdido', 0, '', 0);
INSERT INTO docs_statut (idstatut, statut_libelle, pret_flag, statusdoc_codage_import, statusdoc_owner) VALUES (13, 'Consulta na sala', 0, '', 0);
INSERT INTO docs_statut (idstatut, statut_libelle, pret_flag, statusdoc_codage_import, statusdoc_owner) VALUES (14, 'Em depósito', 0, '', 0);

-- 
-- Conteúdo da tabela `docs_type`
-- 

INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret) VALUES (1, 'Livro', 14, 15, 2, '', 0.00);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret) VALUES (12, 'Fita de vídeo', 14, 15, 2, '', 0.00);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret) VALUES (13, 'CD audio', 14, 15, 2, '', 0.00);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret) VALUES (14, 'DVD', 5, 15, 2, '', 0.00);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret) VALUES (15, 'Obra de arte', 5, 15, 2, '', 0.00);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret) VALUES (16, 'Mapas e planos', 31, 15, 2, '', 0.00);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret) VALUES (17, 'CD-Roms', 10, 5, 2, '', 0.00);
INSERT INTO docs_type (idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, tarif_pret) VALUES (18, 'Publicações periódicas', 8, 5, 0, '', 0.00);

-- 
-- Conteúdo da tabela `docsloc_section`
-- 

INSERT INTO docsloc_section (num_section, num_location) VALUES (10, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (10, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (11, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (11, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (12, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (12, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (13, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (13, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (16, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (16, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (17, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (17, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (18, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (18, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (19, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (19, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (20, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (20, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (21, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (21, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (23, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (23, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (24, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (24, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (25, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (25, 7);
INSERT INTO docsloc_section (num_section, num_location) VALUES (26, 1);
INSERT INTO docsloc_section (num_section, num_location) VALUES (26, 7);

-- 
-- Conteúdo da tabela `empr_categ`
-- 

INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt) VALUES (1, 'Crianças', 365, 0.00);
INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt) VALUES (2, 'Reformados', 365, 0.00);
INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt) VALUES (3, 'Empregados', 365, 0.00);
INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt) VALUES (4, 'Desempregados', 365, 0.00);
INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt) VALUES (5, 'Alunos do secundário/Estudantes', 365, 0.00);
INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt) VALUES (6, 'Colegiais', 365, 0.00);
INSERT INTO empr_categ (id_categ_empr, libelle, duree_adhesion, tarif_abt) VALUES (7, 'Adultos', 365, 0.00);

-- 
-- Conteúdo da tabela `empr_codestat`
-- 

INSERT INTO empr_codestat (idcode, libelle) VALUES (2, 'Associação de Municipios');
INSERT INTO empr_codestat (idcode, libelle) VALUES (3, 'Município');
INSERT INTO empr_codestat (idcode, libelle) VALUES (4, 'Departamento');
INSERT INTO empr_codestat (idcode, libelle) VALUES (5, 'Europa');
INSERT INTO empr_codestat (idcode, libelle) VALUES (6, 'Fora de Europa');
INSERT INTO empr_codestat (idcode, libelle) VALUES (7, 'França');

-- 
-- Conteúdo da tabela `lenders`
-- 

INSERT INTO lenders (idlender, lender_libelle) VALUES (1, 'BDP');
INSERT INTO lenders (idlender, lender_libelle) VALUES (2, 'Fundo próprio');

-- 
-- Conteúdo da tabela `procs`
-- 

INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (1, 'Lista exemplares / estado', 0x73656c656374206578706c5f636f746520617320436f74652c206578706c5f63622061732022436f64652d626172726573222c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652066726f6d206578656d706c6169726573206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f6964207768657265206578706c5f7374617475743d2121706172616d312121206f72646572206279206578706c5f636f7465, 'Lista parametrizada de exemplares 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>');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (2, 'Recontagem exemplares / estado', 0x73656c656374207374617475745f6c6962656c6c65206173205374617475742c20636f756e74282a29206173204e6f6d6272652066726f6d206578656d706c61697265732c20646f63735f7374617475742077686572652069647374617475743d6578706c5f7374617475742067726f7570206279207374617475745f6c6962656c6c65206f72646572206279206964737461747574, 'Número de exemplares por estado de exemplar', '1 4 3 2', NULL);
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (3, 'Recontagem exemplares / proprietário / estado', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f707269e974616972652c207374617475745f6c6962656c6c65206173205374617475742c20636f756e74282a29206173204e6f6d6272652066726f6d206578656d706c61697265732c206c656e646572732c20646f63735f737461747574207768657265206578706c5f6f776e65723d69646c656e64657220616e64206578706c5f7374617475743d69647374617475742067726f7570206279206c656e6465725f6c6962656c6c652c7374617475745f6c6962656c6c65206f72646572206279206c656e6465725f6c6962656c6c652c7374617475745f6c6962656c6c6520, 'Número de exemplares por proprietário e por estado de exemplar', '1 4 3 2', NULL);
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (4, 'Lista de exemplares de um proprietário / estado', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f707269e974616972652c207374617475745f6c6962656c6c65206173205374617475742c206578706c5f636f746520617320436f74652c206578706c5f63622061732022436f64652d626172726573222c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652066726f6d206578656d706c61697265732c20646f63735f7374617475742c206c656e64657273206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f6964207768657265206578706c5f7374617475743d2121737461747574212120616e64206578706c5f6f776e65723d212150726f707269657461697265212120616e64206578706c5f7374617475743d696473746174757420616e64206578706c5f6f776e65723d69646c656e646572206f72646572206279206c656e6465725f6c6962656c6c652c207374617475745f6c6962656c6c652c206578706c5f636f74652c206578706c5f636220, 'Lista de exemplares de um proprietário por estado, assinatura, código de barras, título  (práctico para fazer listas de documentos não marcados antes de uma importação)', '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[Proprietário]]></ALIAS>\n  <TYPE>query_list</TYPE>\n<OPTIONS FOR="query_list">\r\n <QUERY>select idlender, lender_libelle from lenders</QUERY>\r\n <MULTIPLE>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (5, 'Recontagem exemplares / secção', 0x73656c6563742073656374696f6e5f6c6962656c6c652061732053656374696f6e2c20636f756e74282a29206173204e6f6d6272652066726f6d206578656d706c61697265732c20646f63735f73656374696f6e20776865726520696473656374696f6e3d6578706c5f73656374696f6e2067726f757020627920696473656374696f6e2c2073656374696f6e5f6c6962656c6c65206f7264657220627920696473656374696f6e, 'Número de exemplares por secção', '1 4 3 2', NULL);
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (6, 'Lista de exemplares para uma ou mais secções por proprietário', 0x73656c6563742073656374696f6e5f6c6962656c6c652061732053656374696f6e2c206578706c5f636f746520617320436f74652c206578706c5f63622061732022436f64652d626172726573222c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652066726f6d206578656d706c61697265732c20646f63735f73656374696f6e2c206c656e64657273206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f696420776865726520696473656374696f6e20696e2028212173656374696f6e7321212920616e64206578706c5f6f776e65723d212170726574657572212120616e64206578706c5f73656374696f6e3d696473656374696f6e20616e64206578706c5f6f776e65723d69646c656e646572206f726465722062792073656374696f6e5f6c6962656c6c652c206578706c5f636f74652c206578706c5f636220, 'Lista de exemplares de uma ou mais secções para um proprietário', '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 proprietário]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (7, 'Estado : Recontagem exemplares / proprietario', 0x73656c656374206c656e6465725f6c6962656c6c652061732050726f707269e974616972652c20636f756e74282a29206173204e6f6d6272652066726f6d206578656d706c61697265732c206c656e646572732077686572652069646c656e6465723d6578706c5f6f776e65722067726f7570206279206578706c5f6f776e65722c206c656e6465725f6c6962656c6c65, 'Núm de ejemmplares por proprietário de exemplar', '1 4 3 2', NULL);
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (8, 'Lista exemplares para um proprietário', 0x73656c656374206578706c5f636f746520617320436f74652c206578706c5f63622061732022436f64652d626172726573222c2043415345205748454e206578706c5f6e6f746963653e30205448454e20636f6e6361742843415345205748454e2073657269655f6e616d65204953204e4f54204e554c4c205448454e20434f4e4341542873657269655f6e616d652c2022203a20222920454c534520222220454e442c206e312e746974312920454c534520434f4e434154286e322e746974312c2220222c62756c6c6574696e5f6e756d65726f2c2220222920454e442061732054697472652066726f6d206578656d706c61697265732c20646f63735f7374617475742c206c656e64657273206c656674206a6f696e206e6f7469636573206e31206f6e206578706c5f6e6f746963653d6e312e6e6f746963655f6964206c656674206a6f696e20736572696573206f6e206e312e74706172656e745f69643d73657269655f6964206c656674206a6f696e2062756c6c6574696e73206f6e206578706c5f62756c6c6574696e3d62756c6c6574696e5f6964206c656674206a6f696e206e6f7469636573206e32206f6e2062756c6c6574696e5f6e6f746963653d6e322e6e6f746963655f6964207768657265206578706c5f6f776e65723d212170726f707269657461697265212120616e64206578706c5f7374617475743d696473746174757420616e64206578706c5f6f776e65723d69646c656e646572206f7264657220627920206578706c5f636f74652c206578706c5f636220, 'Lista dos exemplares para um proprietário ordenados por assinatura e 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 proprietário</UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (9, 'Recontagem utilizadores / categoria', 0x73656c656374206c6962656c6c6520617320436174e9676f7269652c20636f756e74282a2920617320274e6f6d627265206c65637465757273272066726f6d20656d70722c20656d70725f63617465672077686572652069645f63617465675f656d70723d656d70725f63617465672067726f7570206279206c6962656c6c65206f72646572206279206c6962656c6c65, 'Número de utilizadores por categoria', '1 4 3 2', NULL);
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (10, 'Lista utilizadores / categorias', 0x73656c656374206c6962656c6c6520617320436174e9676f7269652c20656d70725f6e6f6d206173204e6f6d2c20656d70725f7072656e6f6d206173205072e96e6f6d2c20656d70725f796561722061732022416e6ee965206465206e61697373616e6365222066726f6d20656d70722c20656d70725f63617465672077686572652069645f63617465675f656d70723d656d70725f6361746567206f72646572206279206c6962656c6c652c20656d70725f6e6f6d2c20656d70725f7072656e6f6d, 'Lista de utilizadores por categorias de utilizador, utilizador', '1 2', NULL);
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (11, 'Estatísticas : Recontagem de empréstimos / categorias de utilizadores em um ano', 0x53454c4543542043415345205748454e206c6962656c6c65204953204e554c4c205448454e202220436174e9676f726965206465206c6563746575727320696e636f6e6e75652220454c5345206c6962656c6c6520454e4420617320436174e9676f7269652c20636f756e74282a2920617320224e6f6d627265206465207072ea7473222046524f4d20707265745f61726368697665204c454654204a4f494e20656d70725f6361746567204f4e2069645f63617465675f656d7072203d206172635f656d70725f63617465672077686572652079656172286172635f646562757429203d20272121706172616d312121272067726f7570206279206172635f656d70725f6361746567206f7264657220627920436174e9676f726965, 'Número de empréstimos por categoria de utilizadores em um ano', '1 5 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[ano]]></ALIAS>\n  <TYPE>text</TYPE>\n<OPTIONS></OPTIONS>\n </FIELD>\n <FIELD NAME="mois" MANDATORY="yes">\n  <ALIAS><![CDATA[mês]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR="list">\r\n <MULTIPLE>yes</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE="1"><![CDATA[Janeiro]]></ITEM>\r\n  <ITEM VALUE="2"><![CDATA[Fevereiro]]></ITEM>\r\n  <ITEM VALUE="3"><![CDATA[Março]]></ITEM>\r\n  <ITEM VALUE="4"><![CDATA[Abril]]></ITEM>\r\n  <ITEM VALUE="5"><![CDATA[Maio]]></ITEM>\r\n  <ITEM VALUE="6"><![CDATA[Junho]]></ITEM>\r\n  <ITEM VALUE="7"><![CDATA[Julho]]></ITEM>\r\n  <ITEM VALUE="8"><![CDATA[Agosto]]></ITEM>\r\n  <ITEM VALUE="9"><![CDATA[Setembro]]></ITEM>\r\n  <ITEM VALUE="10"><![CDATA[Outubro]]></ITEM>\r\n  <ITEM VALUE="11"><![CDATA[Novembro]]></ITEM>\r\n  <ITEM VALUE="12"><![CDATA[Dezembro]]></ITEM>\r\n </ITEMS>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (12, 'Estatísticas : Recontagem de utilizadores / idade', 0x53454c4543542043415345205748454e2020282121706172616d312121202d20656d70725f7965617229203c3d203133205448454e2027204a757371756520313320616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e313320616e6420282121706172616d312121202d20656d70725f79656172293c3d3234205448454e2027313420e020323420616e7327205748454e20282121706172616d312121202d20656d70725f79656172293e323420616e6420282121706172616d312121202d20656d70725f79656172293c3d3539205448454e2027323520e020353920616e7327205748454e20282121706172616d312121202d20656d70725f79656172293e3539205448454e2027363020616e7320657420706c7573272020454c5345202765727265757220737572206167652720454e4420617320225472616e636865206427e26765222c20636f756e74282a29206173204e6f6d6272652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121706172616d312121206f72207965617228656d70725f646174655f6164686573696f6e293d2121706172616d312121292067726f75702062792031, 'Núm. de utilizadores por franjas de idade em um ano', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[Ano 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[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</FIELDS>');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (13, 'Estatísticas : Recontagem de utilizadores / sexo / idade', 0x53454c4543542063617365207768656e20656d70725f736578653d273127207468656e2027486f6d6d657327207768656e20656d70725f736578653d273227207468656e202746656d6d65732720656c736520276572726575722073757220736578652720656e6420617320536578652c2043415345205748454e2020282121706172616d312121202d20656d70725f7965617229203c3d203133205448454e20274a757371756520313320616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e313320616e6420282121706172616d312121202d20656d70725f7965617229203c3d203234205448454e2027313420e020323420616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e323420616e6420282121706172616d312121202d20656d70725f7965617229203c3d203539205448454e2027323520e020353920616e7327205748454e20282121706172616d312121202d20656d70725f7965617229203e3539205448454e2027363020616e7320657420706c7573272020454c5345202765727265757220737572206167652720454e4420617320225472616e636865206427e26765222c20636f756e74282a29206173204e6f6d6272652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121706172616d312121206f72207965617228656d70725f646174655f6164686573696f6e293d2121706172616d312121292067726f757020627920736578652c2032, 'Núm. de utilizadores por sexo e por faixa etária para um ano', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[Ano 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[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>no</MULTIPLE>\r\n <UNSELECT_ITEM VALUE=""></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (14, 'Estatísticas : Recontagem de utilizadores / população / categoria', 0x73656c65637420656d70725f76696c6c652061732056696c6c652c20636f756e74282a29206173204e6272652066726f6d20656d707220776865726520656d70725f636174656720696e2028212163617465676f72696521212920616e6420287965617228656d70725f646174655f65787069726174696f6e293d2121616e6e65652121206f72207965617228656d70725f646174655f6164686573696f6e293d2121616e6e65652121292067726f757020627920656d70725f76696c6c65206f7264657220627920656d70725f76696c6c65, 'Número de utilizadores por população de residencia para una o mais categorias', '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[Ano 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>');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (15, 'Estatísticas : Recontagem de empréstimos por mês', 0x53454c4543542079656172286172635f64656275742920617320416e6ee9652c206d6f6e7468286172635f646562757429206173204d6f69732c20636f756e74282a2920617320224e6f6d627265206465207072ea7473222046524f4d20707265745f617263686976652077686572652079656172286172635f646562757429203d20272121706172616d312121272067726f757020627920312c2032206f7264657220627920312c2032, 'Número total de empréstimos para um ano', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[Ano 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>');
INSERT INTO `procs` (`idproc`, `name`, `requete`, `comment`, `autorisations`, `parameters`) VALUES (16, 'Estatísticas : Recontagem de empréstimos / secção para um ano', 0x53454c4543542043415345205748454e2073656374696f6e5f6c6962656c6c65204953204e554c4c205448454e20222053656374696f6e207375707072696de9652220454c53452073656374696f6e5f6c6962656c6c6520454e442061732053656374696f6e2c20636f756e74282a2920617320224e6f6d627265206465207072ea7473222046524f4d20707265745f61726368697665204c454654204a4f494e20646f63735f73656374696f6e204f4e20696473656374696f6e203d206172635f6578706c5f73656374696f6e2077686572652079656172286172635f646562757429203d20272121706172616d312121272067726f7570206279206172635f6578706c5f73656374696f6e206f726465722062792053656374696f6e, 'Número de empréstimos por secção para um ano', '1 4 3 2', '<?xml version="1.0" encoding="iso-8859-1"?>\n<FIELDS>\n <FIELD NAME="param1" MANDATORY="yes">\n  <ALIAS><![CDATA[ano]]></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[mês]]></ALIAS>\n  <TYPE>list</TYPE>\n<OPTIONS FOR="list">\r\n <MULTIPLE>yes</MULTIPLE>\r\n <ITEMS>\r\n  <ITEM VALUE="1"><![CDATA[Janeiro]]></ITEM>\r\n  <ITEM VALUE="2"><![CDATA[Fevereiro]]></ITEM>\r\n  <ITEM VALUE="3"><![CDATA[Março]]></ITEM>\r\n  <ITEM VALUE="4"><![CDATA[Abril]]></ITEM>\r\n  <ITEM VALUE="5"><![CDATA[Maio]]></ITEM>\r\n  <ITEM VALUE="6"><![CDATA[Junho]]></ITEM>\r\n  <ITEM VALUE="7"><![CDATA[Julho]]></ITEM>\r\n  <ITEM VALUE="8"><![CDATA[Agosto]]></ITEM>\r\n  <ITEM VALUE="9"><![CDATA[Setembro]]></ITEM>\r\n  <ITEM VALUE="10"><![CDATA[Outubro]]></ITEM>\r\n  <ITEM VALUE="11"><![CDATA[Novembro]]></ITEM>\r\n  <ITEM VALUE="12"><![CDATA[Dezembro]]></ITEM>\r\n </ITEMS>\r\n <UNSELECT_ITEM VALUE=""><![CDATA[]]></UNSELECT_ITEM>\r\n</OPTIONS>\n </FIELD>\n</FIELDS>');
-- 
-- Conteúdo da tabela `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, '', '');

-- 
-- Conteúdo da tabela `sauv_tables`
-- 

INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (1, 'Biblio', 'analysis,bulletins,docs_codestat,docs_location,docs_section,docs_statut,docs_type,exemplaires,notices,etagere_caddie,notices_custom,notices_custom_lists,notices_custom_values');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (2, 'Autoridades', 'authors,categories,collections,noeuds,publishers,responsability,series,sub_collections,thesaurus,voir_aussi');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (3, 'Nenhuma utilidade', 'error_log,import_marc,old_categories,old_notices_categories,sessions');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (4, 'Z3950', 'z_attr,z_bib,z_notices,z_query');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (5, 'Utilizadores', 'empr,empr_categ,empr_codestat,empr_custom,empr_custom_lists,empr_custom_values,empr_groupe,expl_custom_values,groupe,pret,pret_archive,resa');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (6, 'Aplicação', 'categories,lenders,parametres,procs,sauv_lieux,sauv_log,sauv_sauvegardes,sauv_tables,users,explnum,indexint,notices_categories,origine_notice,quotas,etagere,resa_ranger,admin_session,opac_sessions,audit,notice_statut,ouvertures');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (7, 'TUDO', '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');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (9, 'Cestos', 'caddie_procs,caddie,caddie_content');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (10, 'DSI', 'bannette_abon,bannette_contenu,bannette_equation,bannettes,classements,equations,rss_content,rss_flux,rss_flux_content');
INSERT INTO sauv_tables (sauv_table_id, sauv_table_nom, sauv_table_tables) VALUES (11, 'Finanças', 'comptes,quotas_finance,recouvrements,transactions,type_abts,type_comptes');

-- 
-- Conteúdo da tabela `users`
-- 

INSERT INTO users (userid, create_dt, last_updated_dt, username, pwd, nom, prenom, rights, user_lang, nb_per_page_search, nb_per_page_select, nb_per_page_gestion, param_popup_ticket, param_sounds, param_licence, deflt_notice_statut, deflt_docs_type, deflt_lenders, deflt_styles, deflt_docs_statut, deflt_docs_codestat, value_deflt_lang, value_deflt_fonction, deflt_docs_location, deflt_docs_section, value_deflt_module, user_email, user_alert_resamail, deflt2docs_location, deflt_thesaurus, value_prefix_cote) VALUES (2, '2004-01-21', '2005-08-10', 'circ', password('circ'), 'Estagiário', '', 1, 'es_ES', 10, 10, 20, 0, 1, 0, 1, 1, 1, 'vert_et_parme', 1, 10, 'spa', '070', 1, 26, 'circu', '', 0, 1, 1, '');
INSERT INTO users (userid, create_dt, last_updated_dt, username, pwd, nom, prenom, rights, user_lang, nb_per_page_search, nb_per_page_select, nb_per_page_gestion, param_popup_ticket, param_sounds, param_licence, deflt_notice_statut, deflt_docs_type, deflt_lenders, deflt_styles, deflt_docs_statut, deflt_docs_codestat, value_deflt_lang, value_deflt_fonction, deflt_docs_location, deflt_docs_section, value_deflt_module, user_email, user_alert_resamail, deflt2docs_location, deflt_thesaurus, value_prefix_cote) VALUES (3, '2004-01-21', '2005-08-10', 'cat', password('cat'), 'Bibliotecário auxiliar', '', 7, 'es_ES', 10, 10, 20, 0, 1, 0, 1, 1, 1, 'default', 1, 10, 'spa', '070', 1, 26, 'catal', '', 0, 1, 1, '');
INSERT INTO users (userid, create_dt, last_updated_dt, username, pwd, nom, prenom, rights, user_lang, nb_per_page_search, nb_per_page_select, nb_per_page_gestion, param_popup_ticket, param_sounds, param_licence, deflt_notice_statut, deflt_docs_type, deflt_lenders, deflt_styles, deflt_docs_statut, deflt_docs_codestat, value_deflt_lang, value_deflt_fonction, deflt_docs_location, deflt_docs_section, value_deflt_module, user_email, user_alert_resamail, deflt2docs_location, deflt_thesaurus, value_prefix_cote) VALUES (4, '2004-01-21', '2005-08-10', 'bib', password('bib'), 'Bibliotecário', '', 23, 'es_ES', 10, 10, 20, 0, 1, 0, 1, 1, 1, 'default', 13, 12, 'spa', '070', 7, 26, 'circu', '', 0, 1, 1, '');

-- 
-- Conteúdo da tabela `z_attr`
-- 

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

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