--------------------------------------------------------------------------------
-- Jeu de données
--
-- Ce fichier contient l'initialisation d'un jeu de données à destination de
-- trois environnements distincts :
--   * l'environnement de développement,
--   * l'environnement de démonstration,
--   * l'environnement de tests.
--
-- @package openscrutin
-- @version SVN : $Id$
--------------------------------------------------------------------------------

--
-- PostgreSQL database dump
--

--
-- Data for Name: canton; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO canton (canton, libelle) VALUES ('T', 'Tous canton');


--
-- Data for Name: bureau; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO bureau (bureau, libelle, canton, adresse1, adresse2, cp, ville) VALUES ('C', 'Centralisation', 'T', '', '', '', '');
INSERT INTO bureau (bureau, libelle, canton, adresse1, adresse2, cp, ville) VALUES ('T', 'Tous Bureaux', 'T', '', '', '', '');
INSERT INTO bureau (bureau, libelle, canton, adresse1, adresse2, cp, ville) VALUES ('01', 'Hotel de ville', 'T', 'Place de la republique', '', '13200', 'ARLES');
INSERT INTO bureau (bureau, libelle, canton, adresse1, adresse2, cp, ville) VALUES ('02', 'Ecole Jules Valles', 'T', 'Ecole des Garcons', '', '13200', 'ARLES');


--
-- Data for Name: scrutin; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO scrutin (scrutin, libelle, tour, canton, date_scrutin, solde, convocation_agent, convocation_president) VALUES ('MUN08-1', 'Municipales 1er Tour', '1', 'T', '2008-10-19', false, 'Salle des Pas Perdus le 18/10/2008 à 15 heures', 'Salle du conseil le 18/10/2008 à 20 heures');
INSERT INTO scrutin (scrutin, libelle, tour, canton, date_scrutin, solde, convocation_agent, convocation_president) VALUES ('MUN08-2', 'Municipales 2eme Tour', '2', 'T', '2008-10-26', false, '25 Octobre 2008 Salle des Pas Perdus', '25 Octobre 2008 Salle du conseil');


--
-- Data for Name: candidat; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO candidat (candidat, nom, scrutin) VALUES (1, 'Durant Paul', 'MUN08-1');
INSERT INTO candidat (candidat, nom, scrutin) VALUES (2, 'Dupont Pierre', 'MUN08-1');
INSERT INTO candidat (candidat, nom, scrutin) VALUES (3, 'Dupont Pierre', 'MUN08-2');
INSERT INTO candidat (candidat, nom, scrutin) VALUES (4, 'Durant Paul', 'MUN08-2');


--
-- Data for Name: elu; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO elu (elu, nom, prenom, nomjf, date_naissance, lieu_naissance, adresse, cp, ville) VALUES (10001, 'LEMAIRE', 'paul', '', '2012-01-01', '', 'rue de la charité', '13200', 'ARLES');
INSERT INTO elu (elu, nom, prenom, nomjf, date_naissance, lieu_naissance, adresse, cp, ville) VALUES (10002, 'LADJOINT', 'josette', '', '2012-01-01', '', 'rue du temple', '13200', 'ARLES');
INSERT INTO elu (elu, nom, prenom, nomjf, date_naissance, lieu_naissance, adresse, cp, ville) VALUES (10003, 'LECONSEILLER', 'jules', '', '2012-01-01', '', 'rue de la liberté', '13200', 'ARLES');
INSERT INTO elu (elu, nom, prenom, nomjf, date_naissance, lieu_naissance, adresse, cp, ville) VALUES (10004, 'POLO', 'Walter', '', '2012-01-01', '', 'impasse de la révolution', '13200', 'ARLES');


--
-- Data for Name: affectation; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO affectation (affectation, elu, scrutin, periode, poste, bureau, note, decision, candidat) VALUES (1, 10002, 'MUN08-1', 'journee', 'PRESIDENT', '01', '', true, 2);
INSERT INTO affectation (affectation, elu, scrutin, periode, poste, bureau, note, decision, candidat) VALUES (2, 10003, 'MUN08-1', 'journee', 'PRESIDENT SUPPLEANT', '01', '', true, 2);
INSERT INTO affectation (affectation, elu, scrutin, periode, poste, bureau, note, decision, candidat) VALUES (3, 10001, 'MUN08-1', 'journee', 'PRESIDENT', '02', '', true, 2);
INSERT INTO affectation (affectation, elu, scrutin, periode, poste, bureau, note, decision, candidat) VALUES (4, 10004, 'MUN08-1', 'journee', 'DELEGUE TITULAIRE', '01', '', true, 1);
INSERT INTO affectation (affectation, elu, scrutin, periode, poste, bureau, note, decision, candidat) VALUES (5, 10001, 'MUN08-2', 'journee', 'PRESIDENT', '02', 'transfert MUN08-1', false, 3);
INSERT INTO affectation (affectation, elu, scrutin, periode, poste, bureau, note, decision, candidat) VALUES (6, 10002, 'MUN08-2', 'journee', 'PRESIDENT', '01', 'transfert MUN08-1', false, 4);
INSERT INTO affectation (affectation, elu, scrutin, periode, poste, bureau, note, decision, candidat) VALUES (7, 10004, 'MUN08-2', 'journee', 'DELEGUE TITULAIRE', '01', 'transfert MUN08-1', false, 3);


--
-- Name: affectation_seq; Type: SEQUENCE SET; Schema: openscrutin; Owner: -
--

SELECT pg_catalog.setval('affectation_seq', 8, false);


--
-- Data for Name: grade; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO grade (grade, libelle) VALUES ('DT', 'Directeur Territorial');
INSERT INTO grade (grade, libelle) VALUES ('AB', 'Agent de bureau');


--
-- Data for Name: service; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO service (service, libelle) VALUES ('33500', 'Informatique');
INSERT INTO service (service, libelle) VALUES ('33510', 'Telecoms');


--
-- Data for Name: agent; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO agent (agent, nom, prenom, adresse, cp, ville, telephone, service, telephone_pro, grade) VALUES ('00100', 'MARTIN', 'Germaine', 'rue du temple', '13200', 'ARLES', '', '33500', '', 'AB');
INSERT INTO agent (agent, nom, prenom, adresse, cp, ville, telephone, service, telephone_pro, grade) VALUES ('00101', 'MAUSSAN', 'Pierre', 'rue de la mosquée', '13200', 'ARLES', '', '33500', '', 'AB');
INSERT INTO agent (agent, nom, prenom, adresse, cp, ville, telephone, service, telephone_pro, grade) VALUES ('00102', 'PINSON', 'Marie', 'rue de l eglise', '13200', 'ARLES', '', '33500', '', 'AB');
INSERT INTO agent (agent, nom, prenom, adresse, cp, ville, telephone, service, telephone_pro, grade) VALUES ('00104', 'GRAND', 'Paul', 'rue de la synagogue', '13200', 'ARLES', '', '33500', '', 'DT');


--
-- Name: candidat_seq; Type: SEQUENCE SET; Schema: openscrutin; Owner: -
--

SELECT pg_catalog.setval('candidat_seq', 5, false);


--
-- Data for Name: candidature; Type: TABLE DATA; Schema: openscrutin; Owner: -
--

INSERT INTO candidature (candidature, agent, scrutin, periode, poste, bureau, recuperation, note, decision, debut, fin) VALUES (1, '00104', 'MUN08-1', 'journee', 'SECRETAIRE', '01', true, '1ère demande : SECRETAIRE au bureau 01 pendant  journee', true, '07:00:00', '23:00:00');
INSERT INTO candidature (candidature, agent, scrutin, periode, poste, bureau, recuperation, note, decision, debut, fin) VALUES (2, '00100', 'MUN08-1', 'apres-midi', 'PLANTON', '01', true, '1ère demande : PLANTON au bureau 01 pendant  apres-midi', true, '13:00:00', '22:00:00');
INSERT INTO candidature (candidature, agent, scrutin, periode, poste, bureau, recuperation, note, decision, debut, fin) VALUES (3, '00101', 'MUN08-1', 'apres-midi', 'SECRETAIRE', '02', true, '1ère demande : SECRETAIRE au bureau 02 pendant  apres-midi', true, '13:00:00', '22:00:00');
INSERT INTO candidature (candidature, agent, scrutin, periode, poste, bureau, recuperation, note, decision, debut, fin) VALUES (4, '00102', 'MUN08-1', 'apres-midi', 'PLANTON', '02', true, '1ère demande : PLANTON au bureau 02 pendant  apres-midi', true, '13:00:00', '22:00:00');
INSERT INTO candidature (candidature, agent, scrutin, periode, poste, bureau, recuperation, note, decision, debut, fin) VALUES (5, '00101', 'MUN08-2', 'apres-midi', 'SECRETAIRE', '02', true, 'transfert MUN08-1', false, NULL, NULL);
INSERT INTO candidature (candidature, agent, scrutin, periode, poste, bureau, recuperation, note, decision, debut, fin) VALUES (6, '00104', 'MUN08-2', 'journee', 'SECRETAIRE', '01', true, 'transfert MUN08-1', true, '07:00:00', '23:00:00');
INSERT INTO candidature (candidature, agent, scrutin, periode, poste, bureau, recuperation, note, decision, debut, fin) VALUES (7, '00100', 'MUN08-2', 'apres-midi', 'PLANTON', '01', true, 'transfert MUN08-1', true, '13:00:00', '22:00:00');
INSERT INTO candidature (candidature, agent, scrutin, periode, poste, bureau, recuperation, note, decision, debut, fin) VALUES (8, '00102', 'MUN08-2', 'apres-midi', 'PLANTON', '02', true, 'transfert MUN08-1', false, NULL, NULL);


--
-- Name: candidature_seq; Type: SEQUENCE SET; Schema: openscrutin; Owner: -
--

SELECT pg_catalog.setval('candidature_seq', 9, false);


--
-- Name: elu_seq; Type: SEQUENCE SET; Schema: openscrutin; Owner: -
--

SELECT pg_catalog.setval('elu_seq', 10005, false);


--
-- PostgreSQL database dump complete
--

