· 7 years ago · Mar 04, 2019, 09:02 PM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.11
6-- Dumped by pg_dump version 9.6.11
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 client_min_messages = warning;
16SET row_security = off;
17
18--
19-- Name: DATABASE postgres; Type: COMMENT; Schema: -; Owner: postgres
20--
21
22COMMENT ON DATABASE postgres IS 'default administrative connection database';
23
24
25--
26-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
27--
28
29CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
30
31
32--
33-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
34--
35
36COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
37
38
39SET default_tablespace = '';
40
41SET default_with_oids = false;
42
43--
44-- Name: comments; Type: TABLE; Schema: public; Owner: postgres
45--
46
47CREATE TABLE public.comments (
48 id integer NOT NULL,
49 post_id integer NOT NULL,
50 parent_id integer,
51 author character varying(36) NOT NULL,
52 date timestamp with time zone DEFAULT now(),
53 content character varying(2048) NOT NULL,
54 deleted boolean DEFAULT false
55);
56
57
58ALTER TABLE public.comments OWNER TO postgres;
59
60--
61-- Name: comments_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
62--
63
64CREATE SEQUENCE public.comments_id_seq
65 START WITH 1
66 INCREMENT BY 1
67 NO MINVALUE
68 NO MAXVALUE
69 CACHE 1;
70
71
72ALTER TABLE public.comments_id_seq OWNER TO postgres;
73
74--
75-- Name: comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
76--
77
78ALTER SEQUENCE public.comments_id_seq OWNED BY public.comments.id;
79
80
81--
82-- Name: posts; Type: TABLE; Schema: public; Owner: postgres
83--
84
85CREATE TABLE public.posts (
86 id integer NOT NULL,
87 title character varying(120) NOT NULL,
88 author character varying(36) NOT NULL,
89 date timestamp with time zone DEFAULT now(),
90 metadata text NOT NULL,
91 snippet text NOT NULL,
92 content text NOT NULL
93);
94
95
96ALTER TABLE public.posts OWNER TO postgres;
97
98--
99-- Name: posts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
100--
101
102CREATE SEQUENCE public.posts_id_seq
103 START WITH 1
104 INCREMENT BY 1
105 NO MINVALUE
106 NO MAXVALUE
107 CACHE 1;
108
109
110ALTER TABLE public.posts_id_seq OWNER TO postgres;
111
112--
113-- Name: posts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
114--
115
116ALTER SEQUENCE public.posts_id_seq OWNED BY public.posts.id;
117
118
119--
120-- Name: users; Type: TABLE; Schema: public; Owner: postgres
121--
122
123CREATE TABLE public.users (
124 username character varying(36) NOT NULL,
125 email character varying(255) NOT NULL,
126 password character varying(255) NOT NULL
127);
128
129
130ALTER TABLE public.users OWNER TO postgres;
131
132--
133-- Name: comments id; Type: DEFAULT; Schema: public; Owner: postgres
134--
135
136ALTER TABLE ONLY public.comments ALTER COLUMN id SET DEFAULT nextval('public.comments_id_seq'::regclass);
137
138
139--
140-- Name: posts id; Type: DEFAULT; Schema: public; Owner: postgres
141--
142
143ALTER TABLE ONLY public.posts ALTER COLUMN id SET DEFAULT nextval('public.posts_id_seq'::regclass);
144
145
146--
147-- Data for Name: comments; Type: TABLE DATA; Schema: public; Owner: postgres
148--
149
150COPY public.comments (id, post_id, parent_id, author, date, content, deleted) FROM stdin;
1513 1 2 33333333333 2019-02-07 02:06:05.743828+03 33333333333 f
1526 1 5 66666666666 2019-02-07 02:06:28.221934+03 66666666666 f
1537 1 2 7777777777777 2019-02-07 02:06:45.734158+03 777777777777777 f
1548 1 \N 888888888 2019-02-07 02:07:01.267083+03 8888888888 f
1559 1 \N 99999999999 2019-02-07 02:07:06.950668+03 99999999999 f
15610 1 9 10101010 2019-02-07 02:07:16.425395+03 10101010 f
15711 1 10 11 11 11 2019-02-07 02:07:31.071393+03 11 11 11 f
15823 2 22 level7 2019-02-07 11:03:54.623249+03 level7 f
15924 2 23 level8 2019-02-07 11:04:12.241839+03 level8 f
16025 2 19 level4 2019-02-07 11:04:50.110743+03 level4 f
16126 2 24 level9 2019-02-07 11:12:27.809736+03 level9 f
16227 2 26 level9 2019-02-07 11:12:35.638239+03 level9 f
16328 2 27 level10 2019-02-07 11:12:47.875638+03 level10 f
16429 2 28 level10 2019-02-07 11:12:55.829989+03 level10 f
16530 2 29 level10 2019-02-07 11:13:06.111864+03 level10 f
16631 2 30 level11 2019-02-07 11:13:29.777985+03 level11 f
16732 2 31 level11 2019-02-07 11:13:43.607098+03 level11 f
16833 2 32 level12 2019-02-07 11:13:54.759942+03 level12 f
16934 2 33 level13 2019-02-07 11:15:07.926286+03 level13 f
17035 2 34 level14 2019-02-07 11:15:22.850474+03 level14 f
17136 2 35 level15 2019-02-07 11:15:51.433744+03 level15 f
17237 2 36 level16 2019-02-07 11:16:29.640644+03 level16 f
17338 2 37 level17 2019-02-07 11:17:13.000062+03 level17 f
17439 2 38 level18 2019-02-07 11:19:46.221815+03 level18 f
17540 2 39 level18 2019-02-07 11:20:10.637804+03 level18 f
17641 2 \N level0 2019-02-07 11:20:53.402039+03 level0 f
17742 2 41 level1 2019-02-07 11:21:09.242073+03 level1 f
17843 2 42 level2 2019-02-07 11:21:16.80833+03 level2 f
17944 2 43 level3 2019-02-07 11:21:23.012851+03 level3 f
18045 2 44 level4 2019-02-07 11:21:29.079756+03 level4 f
18146 2 45 level5 2019-02-07 11:21:38.951397+03 level5 f
18247 2 \N levle0 2019-02-07 11:22:02.450715+03 level0 f
18348 2 47 level1 2019-02-07 11:22:08.353634+03 level1 f
18449 2 48 level2 2019-02-07 11:22:13.592835+03 level2 f
18550 2 49 level3 2019-02-07 11:22:19.927872+03 level3 f
18651 2 50 level4 2019-02-07 11:22:25.612957+03 level4 f
18752 2 51 level5 2019-02-07 11:22:52.350518+03 level5 f
18853 2 \N level0 2019-02-07 11:24:31.447031+03 level0 f
18954 2 53 level2 2019-02-07 11:25:09.137062+03 level1 f
19055 2 54 level3 2019-02-07 11:25:15.108437+03 level3 f
19156 2 55 level5 2019-02-07 11:25:20.773315+03 level4 f
19257 2 56 level5 2019-02-07 11:25:29.522842+03 level5 f
19358 2 57 level6 2019-02-07 11:25:40.35503+03 level6 f
19459 2 \N level0 2019-02-07 11:28:23.025267+03 level0 f
19560 2 59 level1 2019-02-07 11:28:46.121629+03 level1 f
19661 2 60 level2 2019-02-07 11:31:22.206013+03 level2 f
19762 2 \N levle0 2019-02-07 11:31:33.740258+03 level0 f
19863 2 62 level1 2019-02-07 11:31:39.779064+03 level1 f
19964 2 63 level2 2019-02-07 11:32:02.627417+03 level2 f
20065 2 64 level3 2019-02-07 11:33:25.753981+03 level3 f
20166 2 \N level0 2019-02-07 11:35:16.358808+03 level0 f
20267 2 66 level1 2019-02-07 11:35:23.085013+03 level1 f
20368 2 \N level0 2019-02-07 11:38:00.634161+03 level0 f
20469 2 68 level1 2019-02-07 11:38:05.913588+03 level1 f
20570 2 \N level0 2019-02-07 11:40:29.514803+03 level0 f
20671 2 70 level1 2019-02-07 11:40:36.106624+03 level1 f
20772 2 71 level2 2019-02-07 11:40:42.529202+03 level2 f
20873 2 \N levle0 2019-02-07 11:41:58.201383+03 level0 f
20974 2 \N level0 2019-02-07 11:42:58.956097+03 level0 f
21075 2 74 level1 2019-02-07 11:43:10.941172+03 level1 f
21176 2 75 level2 2019-02-07 11:43:52.308413+03 level2 f
21277 2 76 level3 2019-02-07 11:44:09.162195+03 level3 f
21378 2 77 level3 2019-02-07 11:44:17.847031+03 level3 f
21479 2 78 level3 2019-02-07 11:44:28.733696+03 level3 f
21580 2 79 level3 2019-02-07 11:44:35.776304+03 level3 f
21681 2 \N level0 2019-02-07 12:35:55.189785+03 level0 f
21782 2 \N level0 2019-02-07 12:36:47.724286+03 level0 f
21883 2 \N level0 2019-02-07 12:37:49.797067+03 level0 f
21984 2 \N level0 2019-02-07 12:38:24.565164+03 level0 f
22085 2 84 level1 2019-02-07 12:42:14.227161+03 level1 f
22186 2 85 level2 2019-02-07 12:42:18.99595+03 level2 f
22287 2 86 level3 2019-02-07 12:42:24.994774+03 level3 f
22388 2 87 level4 2019-02-07 12:42:30.304767+03 level4 f
22489 2 88 level5 2019-02-07 12:42:34.434509+03 level5 f
22590 2 89 level6 2019-02-07 12:42:40.751569+03 level6 f
22691 2 89 level7 2019-02-07 12:42:46.317887+03 level7 f
22792 2 91 level8 2019-02-07 12:42:51.597641+03 level8 f
22893 2 92 level10 2019-02-07 12:44:25.725416+03 level10 f
22994 2 91 level9 2019-02-07 12:44:27.888126+03 level9 f
23095 2 93 level12 2019-02-07 12:44:47.62122+03 level12 f
23196 2 94 level13 2019-02-07 12:44:58.384019+03 level13 f
23297 2 96 level14 2019-02-07 12:45:05.825171+03 level14 f
23398 2 97 level15 2019-02-07 12:45:13.197888+03 level15 f
23499 2 98 level16 2019-02-07 12:46:24.953988+03 level16 f
235100 2 99 level17 2019-02-07 12:50:58.101216+03 <b>level16</b>, level17 f
236101 2 100 level18 2019-02-07 12:51:55.120594+03 <b>level17</b>, level18 f
237102 2 101 level19 2019-02-07 12:53:17.062221+03 level19 f
238103 2 33 level14 2019-02-07 12:54:49.586367+03 level14 f
239104 2 17 выавыыва 2019-02-07 12:56:17.194162+03 ыавпвыаыва f
240105 2 102 level20 2019-02-07 13:00:02.19291+03 <b>level19</b>, level20 f
241106 2 105 level21 2019-02-07 13:00:33.355513+03 <b>level20</b>, <script>alert('Uv been pwned')</script> f
242107 2 106 <script>alert('Uv')</script> 2019-02-07 13:03:35.807632+03 <b>level21</b>, <script>alert('Uv been pwned')</script> f
243108 2 17 sdfcdsfds 2019-02-07 13:12:18.041145+03 sdfsdfcsdfc f
244109 2 17 sdfscsxsdcs 2019-02-07 13:12:59.211444+03 sdfsdfceewfr f
245110 2 17 sdffcsdvsfrsfr 2019-02-07 13:13:51.20004+03 dsfsdxwefw f
246111 2 17 fcwfdwdwd 2019-02-07 13:14:53.848747+03 sdfxwwewef f
247112 2 17 ewdsdfdasf 2019-02-07 13:15:01.053711+03 sdfcsdxwxe f
248113 2 17 dsfcwefdewd 2019-02-07 13:15:06.754601+03 dsfsdfwefw f
24920 2 19 level4 2019-02-07 11:03:33.920659+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
25022 2 21 level6 2019-02-07 11:03:43.765608+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
25113 1 12 13 13 13 2019-02-07 02:07:50.662212+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
25212 1 11 12 12 12 2019-02-07 02:07:41.277423+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
2532 1 \N 2222222222 2019-02-07 02:05:59.592599+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
2545 1 2 555555555 2019-02-07 02:06:21.00403+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
255114 2 17 ecvecwxdsd 2019-02-07 13:15:41.484829+03 sdfxewf f
256115 2 17 sdfsdfdsf 2019-02-07 13:17:34.269696+03 sdfdxw f
257116 2 \N level 0 1 2019-02-07 13:44:07.593003+03 level 0 1 f
258117 2 116 level 0 2 2019-02-07 13:44:35.674244+03 level 0 2 f
259118 2 117 level 0 3 2019-02-07 13:44:58.090649+03 level 0 3 f
260120 2 119 level 0 2 2019-02-07 13:50:18.160353+03 level 0 2 f
261121 2 120 level 0 3 2019-02-07 13:50:23.811623+03 level 0 3 f
26219 2 18 level3 2019-02-07 11:03:27.830069+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
26321 2 20 level5 2019-02-07 11:03:38.535957+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
264131 2 17 dsfsdf 2019-02-07 16:38:15.244235+03 sdfsdfs f
265132 2 17 sdfsdfds 2019-02-07 16:38:20.347587+03 sdfsdfsd f
26618 2 17 level2 2019-02-07 11:03:21.978387+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
26717 2 \N level1 2019-02-07 11:03:12.705866+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удаленоываыв t
268133 1 13 14 14 14 2019-02-09 18:01:54.882718+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
269122 2 \N sdfdfsdfsdfdsfdsfdsf 2019-02-07 15:28:41.177424+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjdddddd t
270119 2 \N level 0 1 2019-02-07 13:49:25.059652+03 level 0 1sdfsd f
271123 2 119 wefwefwf 2019-02-07 16:16:00.714222+03 sdfdsdsf f
272124 2 119 sdcsdcsdfc 2019-02-07 16:16:13.992854+03 sdfdsfsdfcwefd f
273125 2 119 sddsxwwsdfsdf 2019-02-07 16:19:15.067851+03 dffdssfdvcdfvfdvfsg f
274126 2 122 уцавцувуцацу 2019-02-07 16:22:02.711657+03 ываываыва f
275127 2 126 sdfsfsfsd 2019-02-07 16:23:46.245729+03 sdfdsxwqef f
276128 2 127 sffsgsgdfg 2019-02-07 16:24:12.786375+03 sfdgfgfg f
277130 2 128 dsfsdfsd 2019-02-07 16:25:43.502755+03 sdfsdsdfdsfsdfsdfsdfsdf f
278129 2 128 sdfcsdacxsdf 2019-02-07 16:25:36.398731+03 Содержимое Ñтого ÐºÐ¾Ð¼Ð¼ÐµÐ½Ñ‚Ð°Ñ€Ð¸Ñ Ð±Ñ‹Ð»Ð¾ удалено t
279\.
280
281
282--
283-- Name: comments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
284--
285
286SELECT pg_catalog.setval('public.comments_id_seq', 136, true);
287
288
289--
290-- Data for Name: posts; Type: TABLE DATA; Schema: public; Owner: postgres
291--
292
293COPY public.posts (id, title, author, date, metadata, snippet, content) FROM stdin;
2941 test post msajdfk239 2019-02-09 17:54:44.001904+03 {"description":"test post","keywords":["test"," post"]} test post oh yeah test post oh yeah test post oh yeah test post oh yeah test post oh yeah test post oh yeah
295\.
296
297
298--
299-- Name: posts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
300--
301
302SELECT pg_catalog.setval('public.posts_id_seq', 1, true);
303
304
305--
306-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
307--
308
309COPY public.users (username, email, password) FROM stdin;
310msajdfk239 msajdfk239@gmail.com $2a$10$oJHvTo84B0N8VXFe4XS3g.Lqnl/NrWrkLSaXE1l/m8zY64RQR/l9q
311dsfsdx2243 dsfsdx2243@gmail.com $2a$10$LDwmt9IprhP8i698wPjscOEhJKbLzd7yLGM8Qjk2Pc6IkEdEamOoq
312dfsfs1314 dfsfs1314@gmail.com $2a$10$TcD4YArsbM9kXHuiK55sMeGP3/2YHVd.GL3eKqYNCOP2rNMdFNjaW
313admin131 admin131@gmail.com $2a$10$MUsQ0fuK4YnMZusKG3nxyunQphVM4Gt47YyZnc1y1C.FEh9hmEUDW
314\.
315
316
317--
318-- Name: comments comments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
319--
320
321ALTER TABLE ONLY public.comments
322 ADD CONSTRAINT comments_pkey PRIMARY KEY (id);
323
324
325--
326-- Name: posts posts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
327--
328
329ALTER TABLE ONLY public.posts
330 ADD CONSTRAINT posts_pkey PRIMARY KEY (id);
331
332
333--
334-- Name: emailindex; Type: INDEX; Schema: public; Owner: postgres
335--
336
337CREATE UNIQUE INDEX emailindex ON public.users USING btree (email);
338
339
340--
341-- Name: idindex; Type: INDEX; Schema: public; Owner: postgres
342--
343
344CREATE UNIQUE INDEX idindex ON public.comments USING btree (id);
345
346
347--
348-- Name: loginindex; Type: INDEX; Schema: public; Owner: postgres
349--
350
351CREATE UNIQUE INDEX loginindex ON public.users USING btree (username);
352
353
354--
355-- Name: postidindex; Type: INDEX; Schema: public; Owner: postgres
356--
357
358CREATE INDEX postidindex ON public.comments USING btree (post_id);
359
360
361--
362-- PostgreSQL database dump complete
363--