· 9 years ago · Dec 27, 2016, 11:50 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.5.5
6-- Dumped by pg_dump version 9.5.5
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET client_encoding = 'UTF8';
11SET standard_conforming_strings = on;
12SET check_function_bodies = false;
13SET client_min_messages = warning;
14SET row_security = off;
15
16SET search_path = public, pg_catalog;
17
18ALTER TABLE ONLY public.conseiller DROP CONSTRAINT pk_id;
19ALTER TABLE ONLY public.person DROP CONSTRAINT "PERSON_pkey";
20ALTER TABLE ONLY public."PARAM_AGIOS" DROP CONSTRAINT "PARAM_AGIOS_pkey";
21ALTER TABLE public.conseiller ALTER COLUMN id_pers DROP DEFAULT;
22DROP SEQUENCE public.seq_id_param;
23DROP SEQUENCE public.conseiller_id_pers_seq;
24DROP TABLE public.conseiller;
25DROP SEQUENCE public."PERSON_ID_PERS_seq";
26DROP TABLE public.person;
27DROP TABLE public."PARAM_AGIOS";
28DROP EXTENSION plpgsql;
29DROP SCHEMA public;
30--
31-- Name: postgres; Type: COMMENT; Schema: -; Owner: postgres
32--
33
34COMMENT ON DATABASE postgres IS 'default administrative connection database';
35
36
37--
38-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
39--
40
41CREATE SCHEMA public;
42
43
44ALTER SCHEMA public OWNER TO postgres;
45
46--
47-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
48--
49
50COMMENT ON SCHEMA public IS 'standard public schema';
51
52
53--
54-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
55--
56
57CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
58
59
60--
61-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
62--
63
64COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
65
66
67SET search_path = public, pg_catalog;
68
69SET default_tablespace = '';
70
71SET default_with_oids = false;
72
73--
74-- Name: PARAM_AGIOS; Type: TABLE; Schema: public; Owner: postgres
75--
76
77CREATE TABLE "PARAM_AGIOS" (
78 "ID_AGIOS" integer NOT NULL,
79 "BEGIN_MT" double precision,
80 "LAST_MT" double precision,
81 "NB_DAYS" integer,
82 "RATE_AGIOS" double precision,
83 "ID_CAT" integer
84);
85
86
87ALTER TABLE "PARAM_AGIOS" OWNER TO postgres;
88
89--
90-- Name: person; Type: TABLE; Schema: public; Owner: postgres
91--
92
93CREATE TABLE person (
94 id_pers integer NOT NULL,
95 first_name character(20),
96 name character(20) NOT NULL
97);
98
99
100ALTER TABLE person OWNER TO postgres;
101
102--
103-- Name: PERSON_ID_PERS_seq; Type: SEQUENCE; Schema: public; Owner: postgres
104--
105
106CREATE SEQUENCE "PERSON_ID_PERS_seq"
107 START WITH 1
108 INCREMENT BY 1
109 NO MINVALUE
110 NO MAXVALUE
111 CACHE 1;
112
113
114ALTER TABLE "PERSON_ID_PERS_seq" OWNER TO postgres;
115
116--
117-- Name: PERSON_ID_PERS_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
118--
119
120ALTER SEQUENCE "PERSON_ID_PERS_seq" OWNED BY person.id_pers;
121
122
123--
124-- Name: conseiller; Type: TABLE; Schema: public; Owner: postgres
125--
126
127CREATE TABLE conseiller (
128 id_pers integer NOT NULL,
129 first_name character varying(40) NOT NULL,
130 name character varying(40) NOT NULL,
131 email character varying(40) NOT NULL
132);
133
134
135ALTER TABLE conseiller OWNER TO postgres;
136
137--
138-- Name: conseiller_id_pers_seq; Type: SEQUENCE; Schema: public; Owner: postgres
139--
140
141CREATE SEQUENCE conseiller_id_pers_seq
142 START WITH 1
143 INCREMENT BY 1
144 NO MINVALUE
145 NO MAXVALUE
146 CACHE 1;
147
148
149ALTER TABLE conseiller_id_pers_seq OWNER TO postgres;
150
151--
152-- Name: conseiller_id_pers_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
153--
154
155ALTER SEQUENCE conseiller_id_pers_seq OWNED BY conseiller.id_pers;
156
157
158--
159-- Name: seq_id_param; Type: SEQUENCE; Schema: public; Owner: postgres
160--
161
162CREATE SEQUENCE seq_id_param
163 START WITH 1
164 INCREMENT BY 1
165 NO MINVALUE
166 NO MAXVALUE
167 CACHE 1;
168
169
170ALTER TABLE seq_id_param OWNER TO postgres;
171
172--
173-- Name: id_pers; Type: DEFAULT; Schema: public; Owner: postgres
174--
175
176ALTER TABLE ONLY conseiller ALTER COLUMN id_pers SET DEFAULT nextval('conseiller_id_pers_seq'::regclass);
177
178
179--
180-- Data for Name: PARAM_AGIOS; Type: TABLE DATA; Schema: public; Owner: postgres
181--
182
183COPY "PARAM_AGIOS" ("ID_AGIOS", "BEGIN_MT", "LAST_MT", "NB_DAYS", "RATE_AGIOS", "ID_CAT") FROM stdin;
184102 0 100 10 0.0199999995529651642 1
185103 0 100 10 0.0199999995529651642 1
186104 0 100 10 0.0199999995529651642 1
187105 0 100 10 0.0199999995529651642 1
188150 6 37 18 0.0339679121971130371 1
189151 9 0 10 0.0730327963829040527 1
190\.
191
192
193--
194-- Name: PERSON_ID_PERS_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
195--
196
197SELECT pg_catalog.setval('"PERSON_ID_PERS_seq"', 3, true);
198
199
200--
201-- Data for Name: conseiller; Type: TABLE DATA; Schema: public; Owner: postgres
202--
203
204COPY conseiller (id_pers, first_name, name, email) FROM stdin;
2051 anthony perault anthony.perault@orange.fr
206\.
207
208
209--
210-- Name: conseiller_id_pers_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
211--
212
213SELECT pg_catalog.setval('conseiller_id_pers_seq', 1, true);
214
215
216--
217-- Data for Name: person; Type: TABLE DATA; Schema: public; Owner: postgres
218--
219
220COPY person (id_pers, first_name, name) FROM stdin;
2211 Baptiste SARDA
2222 Van DUONG
2233 Zouhair HAJJI
2244 Baptiste SARDA
2255 Mouna Izouggarhan
2266 Florian LESGUER
2277 Coline MARIN
2288 Aicha DIOP
2299 Anthony PERAULT
23010 Jacques PAUL
231\.
232
233
234--
235-- Name: seq_id_param; Type: SEQUENCE SET; Schema: public; Owner: postgres
236--
237
238SELECT pg_catalog.setval('seq_id_param', 4, true);
239
240
241--
242-- Name: PARAM_AGIOS_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
243--
244
245ALTER TABLE ONLY "PARAM_AGIOS"
246 ADD CONSTRAINT "PARAM_AGIOS_pkey" PRIMARY KEY ("ID_AGIOS");
247
248
249--
250-- Name: PERSON_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
251--
252
253ALTER TABLE ONLY person
254 ADD CONSTRAINT "PERSON_pkey" PRIMARY KEY (id_pers);
255
256
257--
258-- Name: pk_id; Type: CONSTRAINT; Schema: public; Owner: postgres
259--
260
261ALTER TABLE ONLY conseiller
262 ADD CONSTRAINT pk_id PRIMARY KEY (id_pers);
263
264
265--
266-- Name: public; Type: ACL; Schema: -; Owner: postgres
267--
268
269REVOKE ALL ON SCHEMA public FROM PUBLIC;
270REVOKE ALL ON SCHEMA public FROM postgres;
271GRANT ALL ON SCHEMA public TO postgres;
272GRANT ALL ON SCHEMA public TO PUBLIC;
273
274
275--
276-- PostgreSQL database dump complete
277--