· 6 years ago · Dec 29, 2019, 05:26 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)
6-- Dumped by pg_dump version 10.10 (Ubuntu 10.10-0ubuntu0.18.04.1)
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET xmloption = content;
16SET client_min_messages = warning;
17SET row_security = off;
18
19--
20-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
21--
22
23CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
24
25
26--
27-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
28--
29
30COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
31
32
33SET default_tablespace = '';
34
35SET default_with_oids = false;
36
37--
38-- Name: Comptes; Type: TABLE; Schema: public; Owner: postgres
39--
40
41CREATE TABLE public."Comptes" (
42 "Id" bigint NOT NULL,
43 "ID_Compte" text,
44 "Email" text,
45 "Domaine" text,
46 "IP" text,
47 "Phone" text,
48 "Login" text,
49 "Name" text,
50 "Pwd" text,
51 "Process" text,
52 "Societe" text
53);
54
55
56ALTER TABLE public."Comptes" OWNER TO postgres;
57
58--
59-- Name: Compte_Id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
60--
61
62CREATE SEQUENCE public."Compte_Id_seq"
63 START WITH 1
64 INCREMENT BY 1
65 NO MINVALUE
66 NO MAXVALUE
67 CACHE 1;
68
69
70ALTER TABLE public."Compte_Id_seq" OWNER TO postgres;
71
72--
73-- Name: Compte_Id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
74--
75
76ALTER SEQUENCE public."Compte_Id_seq" OWNED BY public."Comptes"."Id";
77
78
79--
80-- Name: Compte_Phone_seq; Type: SEQUENCE; Schema: public; Owner: postgres
81--
82
83CREATE SEQUENCE public."Compte_Phone_seq"
84 AS integer
85 START WITH 1
86 INCREMENT BY 1
87 NO MINVALUE
88 NO MAXVALUE
89 CACHE 1;
90
91
92ALTER TABLE public."Compte_Phone_seq" OWNER TO postgres;
93
94--
95-- Name: Compte_Phone_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
96--
97
98ALTER SEQUENCE public."Compte_Phone_seq" OWNED BY public."Comptes"."Phone";
99
100
101--
102-- Name: Domaines; Type: TABLE; Schema: public; Owner: postgres
103--
104
105CREATE TABLE public."Domaines" (
106 "Id" bigint NOT NULL,
107 "Extension" text,
108 "Pays" text,
109 "Type" text,
110 "TLD_Manager" text
111);
112
113
114ALTER TABLE public."Domaines" OWNER TO postgres;
115
116--
117-- Name: Domaine_Id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
118--
119
120CREATE SEQUENCE public."Domaine_Id_seq"
121 START WITH 1
122 INCREMENT BY 1
123 NO MINVALUE
124 NO MAXVALUE
125 CACHE 1;
126
127
128ALTER TABLE public."Domaine_Id_seq" OWNER TO postgres;
129
130--
131-- Name: Domaine_Id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
132--
133
134ALTER SEQUENCE public."Domaine_Id_seq" OWNED BY public."Domaines"."Id";
135
136
137--
138-- Name: Keyword; Type: TABLE; Schema: public; Owner: postgres
139--
140
141CREATE TABLE public."Keyword" (
142 "Id" bigint NOT NULL,
143 "Id_Compte" text,
144 "Keyword" text
145);
146
147
148ALTER TABLE public."Keyword" OWNER TO postgres;
149
150--
151-- Name: Keyword_Id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
152--
153
154CREATE SEQUENCE public."Keyword_Id_seq"
155 START WITH 1
156 INCREMENT BY 1
157 NO MINVALUE
158 NO MAXVALUE
159 CACHE 1;
160
161
162ALTER TABLE public."Keyword_Id_seq" OWNER TO postgres;
163
164--
165-- Name: Keyword_Id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
166--
167
168ALTER SEQUENCE public."Keyword_Id_seq" OWNED BY public."Keyword"."Id";
169
170
171--
172-- Name: Logs_BDD; Type: TABLE; Schema: public; Owner: postgres
173--
174
175CREATE TABLE public."Logs_BDD" (
176 "Id" bigint NOT NULL,
177 "Table" text,
178 "Date_Integration" text,
179 "Source" text,
180 "Domaine" text,
181 "Date_Hack" text,
182 "Prix" text,
183 "Description" text,
184 "URL" text,
185 "Pays" text,
186 "Category" text,
187 "Ficher" text
188);
189
190
191ALTER TABLE public."Logs_BDD" OWNER TO postgres;
192
193--
194-- Name: Logs_BDD_Id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
195--
196
197CREATE SEQUENCE public."Logs_BDD_Id_seq"
198 START WITH 1
199 INCREMENT BY 1
200 NO MINVALUE
201 NO MAXVALUE
202 CACHE 1;
203
204
205ALTER TABLE public."Logs_BDD_Id_seq" OWNER TO postgres;
206
207--
208-- Name: Logs_BDD_Id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
209--
210
211ALTER SEQUENCE public."Logs_BDD_Id_seq" OWNED BY public."Logs_BDD"."Id";
212
213
214--
215-- Name: Pastebin; Type: TABLE; Schema: public; Owner: postgres
216--
217
218CREATE TABLE public."Pastebin" (
219 "Id" bigint NOT NULL,
220 "Id_Compte" text,
221 "Id_Keyword" text,
222 "Date_Scrap" text,
223 "URL" text,
224 "Contenu" text,
225 "User" text,
226 "Date_Pathebin" text
227);
228
229
230ALTER TABLE public."Pastebin" OWNER TO postgres;
231
232--
233-- Name: Rapports; Type: TABLE; Schema: public; Owner: postgres
234--
235
236CREATE TABLE public."Rapports" (
237 id bigint NOT NULL,
238 "ID_Table" text,
239 "Date_Heure" text,
240 "Resultat" text,
241 "Id_Compte" text,
242 "Email" text,
243 "Pwd" text,
244 "IP" text,
245 "Pwd_MD5" text,
246 "Domaine" text,
247 "ID_Compte" text,
248 "Raison" text,
249 "Trouve" text DEFAULT 1,
250 "Texte" text,
251 "Type" text
252);
253
254
255ALTER TABLE public."Rapports" OWNER TO postgres;
256
257--
258-- Name: Rapport_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
259--
260
261CREATE SEQUENCE public."Rapport_id_seq"
262 START WITH 1
263 INCREMENT BY 1
264 NO MINVALUE
265 NO MAXVALUE
266 CACHE 1;
267
268
269ALTER TABLE public."Rapport_id_seq" OWNER TO postgres;
270
271--
272-- Name: Rapport_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
273--
274
275ALTER SEQUENCE public."Rapport_id_seq" OWNED BY public."Rapports".id;
276
277
278--
279-- Name: Comptes Id; Type: DEFAULT; Schema: public; Owner: postgres
280--
281
282ALTER TABLE ONLY public."Comptes" ALTER COLUMN "Id" SET DEFAULT nextval('public."Compte_Id_seq"'::regclass);
283
284
285--
286-- Name: Domaines Id; Type: DEFAULT; Schema: public; Owner: postgres
287--
288
289ALTER TABLE ONLY public."Domaines" ALTER COLUMN "Id" SET DEFAULT nextval('public."Domaine_Id_seq"'::regclass);
290
291
292--
293-- Name: Keyword Id; Type: DEFAULT; Schema: public; Owner: postgres
294--
295
296ALTER TABLE ONLY public."Keyword" ALTER COLUMN "Id" SET DEFAULT nextval('public."Keyword_Id_seq"'::regclass);
297
298
299--
300-- Name: Logs_BDD Id; Type: DEFAULT; Schema: public; Owner: postgres
301--
302
303ALTER TABLE ONLY public."Logs_BDD" ALTER COLUMN "Id" SET DEFAULT nextval('public."Logs_BDD_Id_seq"'::regclass);
304
305
306--
307-- Name: Rapports id; Type: DEFAULT; Schema: public; Owner: postgres
308--
309
310ALTER TABLE ONLY public."Rapports" ALTER COLUMN id SET DEFAULT nextval('public."Rapport_id_seq"'::regclass);
311
312
313--
314-- Name: Comptes Compte_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
315--
316
317ALTER TABLE ONLY public."Comptes"
318 ADD CONSTRAINT "Compte_pkey" PRIMARY KEY ("Id");
319
320
321--
322-- Name: Domaines Domaine_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
323--
324
325ALTER TABLE ONLY public."Domaines"
326 ADD CONSTRAINT "Domaine_pkey" PRIMARY KEY ("Id");
327
328
329--
330-- Name: Keyword Keyword_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
331--
332
333ALTER TABLE ONLY public."Keyword"
334 ADD CONSTRAINT "Keyword_pkey" PRIMARY KEY ("Id");
335
336
337--
338-- Name: Logs_BDD Logs_BDD_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
339--
340
341ALTER TABLE ONLY public."Logs_BDD"
342 ADD CONSTRAINT "Logs_BDD_pkey" PRIMARY KEY ("Id");
343
344
345--
346-- Name: Pastebin Pastebin_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
347--
348
349ALTER TABLE ONLY public."Pastebin"
350 ADD CONSTRAINT "Pastebin_pkey" PRIMARY KEY ("Id");
351
352
353--
354-- Name: Rapports Rapport_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
355--
356
357ALTER TABLE ONLY public."Rapports"
358 ADD CONSTRAINT "Rapport_pkey" PRIMARY KEY (id);
359
360
361--
362-- PostgreSQL database dump complete
363--