--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.14
-- Dumped by pg_dump version 9.5.14

-- Started on 2019-12-16 12:11:06 CET

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 4014 (class 0 OID 406141)
-- Dependencies: 357
-- Data for Name: om_requete; Type: TABLE DATA; Schema: openresultat; Owner: francois
--

INSERT INTO openresultat.om_requete (om_requete, code, libelle, description, requete, merge_fields, type, classe, methode) VALUES (1, 'election', 'resultat de l election', NULL, 'select election.election as election,election.libelle as libelle,election.code as code,election.tour as tour,election.principal as principal,election.type_election as type_election,election.date as date,election.perimetre as perimetre from &DB_PREFIXEelection where election.election=''&idx''', '', 'objet', 'election', 'view_edition');
INSERT INTO openresultat.om_requete (om_requete, code, libelle, description, requete, merge_fields, type, classe, methode) VALUES (2, 'election', 'Requête ''election''', NULL, 'select election.libelle as libelle,election.code as code,election.tour as tour,election.principal as principal,election.type_election as type_election,election.date as date, 
inscrit, votant, nul, blanc, exprime
from &DB_PREFIXEelection 
left join  &DB_PREFIXEelection_cumul_bureau 
on election_cumul_bureau.election=election.election
where election.election=''&idx''', '', 'sql', NULL, NULL);


--
-- TOC entry 4012 (class 0 OID 406089)
-- Dependencies: 345
-- Data for Name: om_etat; Type: TABLE DATA; Schema: openresultat; Owner: francois
--

INSERT INTO openresultat.om_etat (om_etat, om_collectivite, id, libelle, actif, orientation, format, logo, logoleft, logotop, titre_om_htmletat, titreleft, titretop, titrelargeur, titrehauteur, titrebordure, corps_om_htmletatex, om_sql, se_font, se_couleurtexte, margeleft, margetop, margeright, margebottom, header_om_htmletat, header_offset, footer_om_htmletat, footer_offset) VALUES (1, 1, 'election', 'affichage des résultats', true, 'P', 'A4', NULL, 10, 25, '<p>[election.libelle]</p>', 105, 25, 95, 10, '0', '<p>[resultat]</p>', 1, 'helvetica', '0-0-0', 10, 25, 10, 25, '', 10, '<p style=''text-align: center; font-size: 8pt;''><em>Page &amp;numpage/&amp;nbpages</em></p>', 12);
INSERT INTO openresultat.om_etat (om_etat, om_collectivite, id, libelle, actif, orientation, format, logo, logoleft, logotop, titre_om_htmletat, titreleft, titretop, titrelargeur, titrehauteur, titrebordure, corps_om_htmletatex, om_sql, se_font, se_couleurtexte, margeleft, margetop, margeright, margebottom, header_om_htmletat, header_offset, footer_om_htmletat, footer_offset) VALUES (2, 1, 'proclamation', 'proclamation des resultats', true, 'P', 'A4', NULL, 10, 25, '<p>[code] </p>
<p>[principal]</p>
<p>[type_election]</p>', 105, 25, 95, 10, '0', '<p> </p>
<table border=''0'' style=''width: 500px;'' cellspacing=''2''>
<tbody>
<tr>
<td>Scrutin</td>
<td>[libelle]</td>
</tr>
<tr>
<td>tour</td>
<td>[tour]</td>
</tr>
<tr>
<td>date</td>
<td>[date]</td>
</tr>
</tbody>
</table>
<p> </p>
<table border=''1'' style=''width: 300px;'' cellspacing=''0'' cellpadding=''10''>
<tbody>
<tr>
<td>Inscrits</td>
<td>[inscrit]</td>
</tr>
<tr>
<td>votants</td>
<td>[votant]</td>
</tr>
</tbody>
</table>
<p> </p>
<table border=''1'' style=''width: 300px;'' cellpadding=''10''>
<tbody>
<tr>
<td>blancs</td>
<td>[blanc]</td>
</tr>
<tr>
<td>Nuls</td>
<td>[nul]</td>
</tr>
<tr>
<td>Exprimés</td>
<td>[exprime]</td>
</tr>
</tbody>
</table>
<p><br /> </p>
<p><span id=''candidat_resultat.election_candidat'' class=''mce_sousetat''>resultat par candidat</span></p>
<p> </p>', 2, 'helvetica', '0-0-0', 10, 25, 10, 25, '', 10, '<p style=''text-align: center; font-size: 8pt;''><em>Page &amp;numpage/&amp;nbpages</em></p>', 12);


--
-- TOC entry 4023 (class 0 OID 0)
-- Dependencies: 346
-- Name: om_etat_seq; Type: SEQUENCE SET; Schema: openresultat; Owner: francois
--

SELECT pg_catalog.setval('openresultat.om_etat_seq', 2, true);


--
-- TOC entry 4024 (class 0 OID 0)
-- Dependencies: 358
-- Name: om_requete_seq; Type: SEQUENCE SET; Schema: openresultat; Owner: francois
--

SELECT pg_catalog.setval('openresultat.om_requete_seq', 2, true);


--
-- TOC entry 4016 (class 0 OID 406183)
-- Dependencies: 369
-- Data for Name: om_sousetat; Type: TABLE DATA; Schema: openresultat; Owner: francois
--

INSERT INTO openresultat.om_sousetat (om_sousetat, om_collectivite, id, libelle, actif, titre, titrehauteur, titrefont, titreattribut, titretaille, titrebordure, titrealign, titrefond, titrefondcouleur, titretextecouleur, intervalle_debut, intervalle_fin, entete_flag, entete_fond, entete_orientation, entete_hauteur, entetecolone_bordure, entetecolone_align, entete_fondcouleur, entete_textecouleur, tableau_largeur, tableau_bordure, tableau_fontaille, bordure_couleur, se_fond1, se_fond2, cellule_fond, cellule_hauteur, cellule_largeur, cellule_bordure_un, cellule_bordure, cellule_align, cellule_fond_total, cellule_fontaille_total, cellule_hauteur_total, cellule_fondcouleur_total, cellule_bordure_total, cellule_align_total, cellule_fond_moyenne, cellule_fontaille_moyenne, cellule_hauteur_moyenne, cellule_fondcouleur_moyenne, cellule_bordure_moyenne, cellule_align_moyenne, cellule_fond_nbr, cellule_fontaille_nbr, cellule_hauteur_nbr, cellule_fondcouleur_nbr, cellule_bordure_nbr, cellule_align_nbr, cellule_numerique, cellule_total, cellule_moyenne, cellule_compteur, om_sql) VALUES (1, 1, 'candidat_resultat.election_candidat', 'resultat par candidat', true, 'liste candidat_resultat', 10, 'helvetica', 'B', 10, '0', 'L', '0', '255-255-255', '0-0-0', 0, 5, '1', '1', '0|0', 7, 'TLB|LTBR', 'C|C', '255-255-255', '0-0-0', 195, '1', 10, '0-0-0', '243-246-246', '255-255-255', '1', 7, '97,5|97,5', 'TLB|LTBR', 'TLB|LTBR', 'C|C', '1', 10, 15, '255-255-255', 'TLB|LTBR', 'C|C', '1', 10, 5, '212-219-219', 'TLB|LTBR', 'C|C', '1', 10, 7, '255-255-255', 'TLB|LTBR', 'C|C', '999|999', '0|0', '0|0', '0|0', 'select candidat.libelle as candidat,
candidat_resultat.resultat as resultat 
from &DB_PREFIXEcandidat_resultat 
left join &DB_PREFIXEelection_candidat on election_candidat.election_candidat=candidat_resultat.election_candidat
left join &DB_PREFIXEcandidat on candidat.candidat=election_candidat.candidat
where election_candidat.election=''&idx''');


--
-- TOC entry 4025 (class 0 OID 0)
-- Dependencies: 370
-- Name: om_sousetat_seq; Type: SEQUENCE SET; Schema: openresultat; Owner: francois
--

SELECT pg_catalog.setval('openresultat.om_sousetat_seq', 1, true);


-- Completed on 2019-12-16 12:11:06 CET

--
-- PostgreSQL database dump complete
--