--
-- PostgreSQL database dump
--

-- SET statement_timeout = 0;
-- SET client_encoding = 'UTF8';
-- SET standard_conforming_strings = on;
-- SET check_function_bodies = false;
-- SET client_min_messages = warning;

-- SET search_path = openads, pg_catalog;

--
-- Data for Name: demande_nature; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO demande_nature (demande_nature, code, libelle, description) VALUES (1, 'NOUV', 'Nouveau dossier', 'Une demande de nature ''Nouveau dossier'' doit donner lieu à la création d''un dossier d''autorisation');
INSERT INTO demande_nature (demande_nature, code, libelle, description) VALUES (2, 'EXIST', 'Dossier existant', 'Une demande de nature ''Dossier existant'' doit être reliée à un dossier d''autorisation existant');


--
-- Name: demande_nature_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('demande_nature_seq', 3, false);


--
-- Data for Name: demande_type; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (1, 'DI', 'Dépôt Initial', '', 1, 1, 1, 1, '', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (2, 'DI', 'Dépôt Initial', '', 1, 1, 6, 2, '', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (3, 'DI', 'Dépôt Initial', '', 1, 1, 11, 3, '', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (4, 'DI', 'Dépôt Initial', '', 1, 1, 16, 4, '', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (5, 'DI', 'Dépôt Initial', '', 1, 1, 21, 5, '', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (6, 'DI', 'Dépôt Initial', '', 1, 1, 26, 6, '', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (7, 'DI', 'Dépôt Initial', '', 1, 1, 31, 7, '', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (9, 'DT', 'Demande de transfert', '', 2, 1, 3, 1, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (10, 'DT', 'Demande de transfert', '', 2, 1, 8, 2, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (11, 'DT', 'Demande de transfert', '', 2, 1, 13, 3, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (12, 'DT', 'Demande de transfert', '', 2, 1, 18, 4, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (13, 'DT', 'Demande de transfert', '', 2, 1, 23, 5, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (14, 'DT', 'Demande de transfert', '', 2, 1, 28, 6, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (15, 'DT', 'Demande de transfert', '', 2, 1, 33, 7, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (16, 'DT', 'Demande de transfert', '', 2, 1, 38, 8, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (17, 'DM', 'Demande de modification', '', 2, 1, 2, 1, 'avec_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (18, 'DM', 'Demande de modification', '', 2, 1, 7, 2, 'avec_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (19, 'DM', 'Demande de modification', '', 2, 1, 12, 3, 'avec_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (20, 'DM', 'Demande de modification', '', 2, 1, 17, 4, 'avec_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (21, 'DM', 'Demande de modification', '', 2, 1, 22, 5, 'avec_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (22, 'DM', 'Demande de modification', '', 2, 1, 27, 6, 'avec_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (23, 'DM', 'Demande de modification', '', 2, 1, 32, 7, 'avec_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (24, 'DM', 'Demande de modification', '', 2, 1, 37, 8, 'avec_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (25, 'DAACT', 'Déclaration attestant l''achèvement et la conformité des travaux', '', 2, 1, 4, 1, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (26, 'DAACT', 'Déclaration attestant l''achèvement et la conformité des travaux', '', 2, 1, 9, 2, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (27, 'DAACT', 'Déclaration attestant l''achèvement et la conformité des travaux', '', 2, 1, 14, 3, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (28, 'DAACT', 'Déclaration attestant l''achèvement et la conformité des travaux', '', 2, 1, 19, 4, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (29, 'DAACT', 'Déclaration attestant l''achèvement et la conformité des travaux', '', 2, 1, 24, 5, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (30, 'DAACT', 'Déclaration attestant l''achèvement et la conformité des travaux', '', 2, 1, 29, 6, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (31, 'DAACT', 'Déclaration attestant l''achèvement et la conformité des travaux', '', 2, 1, 34, 7, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (33, 'DOC', 'Demande d''ouverture de chantier', '', 2, 1, 5, 1, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (34, 'DOC', 'Demande d''ouverture de chantier', '', 2, 1, 10, 2, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (35, 'DOC', 'Demande d''ouverture de chantier', '', 2, 1, 15, 3, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (36, 'DOC', 'Demande d''ouverture de chantier', '', 2, 1, 20, 4, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (37, 'DOC', 'Demande d''ouverture de chantier', '', 2, 1, 25, 5, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (38, 'DOC', 'Demande d''ouverture de chantier', '', 2, 1, 30, 6, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (39, 'DOC', 'Demande d''ouverture de chantier', '', 2, 1, 35, 7, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (40, 'DOC', 'Demande d''ouverture de chantier', '', 2, 1, 40, 8, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (32, 'DAACT', 'Déclaration attestant l''achèvement et la conformité des travaux', '', 2, 1, 39, 8, 'sans_recup', true, 1);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (8, 'DI', 'Dépôt Initial', '', 1, 1, 36, 8, '', true, 95);
INSERT INTO demande_type (demande_type, code, libelle, description, demande_nature, groupe, dossier_instruction_type, dossier_autorisation_type_detaille, contraintes, qualification, evenement) VALUES (41, 'DPC', 'Dépôt de pièces complémentaire', '', 2, 5, NULL, 8, NULL, false, 91);


--
-- Name: demande_type_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('demande_type_seq', 42, false);


--
-- Data for Name: lien_demande_type_etat; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO lien_demande_type_etat (lien_demande_type_etat, demande_type, etat) VALUES (1, 18, 'accepter');
INSERT INTO lien_demande_type_etat (lien_demande_type_etat, demande_type, etat) VALUES (2, 17, 'accepter');
INSERT INTO lien_demande_type_etat (lien_demande_type_etat, demande_type, etat) VALUES (3, 19, 'accepter');
INSERT INTO lien_demande_type_etat (lien_demande_type_etat, demande_type, etat) VALUES (4, 20, 'accepter');
INSERT INTO lien_demande_type_etat (lien_demande_type_etat, demande_type, etat) VALUES (5, 21, 'accepter');
INSERT INTO lien_demande_type_etat (lien_demande_type_etat, demande_type, etat) VALUES (6, 22, 'accepter');
INSERT INTO lien_demande_type_etat (lien_demande_type_etat, demande_type, etat) VALUES (7, 23, 'accepter');
INSERT INTO lien_demande_type_etat (lien_demande_type_etat, demande_type, etat) VALUES (8, 24, 'accepter');


--
-- Name: lien_demande_type_etat_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

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


--
-- PostgreSQL database dump complete
--

