Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- PostgreSQL database dump
- --
- -- Dumped from database version 9.6.11
- -- Dumped by pg_dump version 9.6.11
- SET statement_timeout = 0;
- SET lock_timeout = 0;
- SET idle_in_transaction_session_timeout = 0;
- SET client_encoding = 'UTF8';
- SET standard_conforming_strings = on;
- SELECT pg_catalog.set_config('search_path', '', false);
- SET check_function_bodies = false;
- SET client_min_messages = warning;
- SET row_security = off;
- --
- -- Name: DATABASE postgres; Type: COMMENT; Schema: -; Owner: postgres
- --
- COMMENT ON DATABASE postgres IS 'default administrative connection database';
- --
- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
- --
- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
- --
- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
- --
- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
- SET default_tablespace = '';
- SET default_with_oids = false;
- --
- -- Name: comments; Type: TABLE; Schema: public; Owner: postgres
- --
- CREATE TABLE public.comments (
- id integer NOT NULL,
- post_id integer NOT NULL,
- parent_id integer,
- author character varying(36) NOT NULL,
- date timestamp with time zone DEFAULT now(),
- content character varying(2048) NOT NULL,
- deleted boolean DEFAULT false
- );
- ALTER TABLE public.comments OWNER TO postgres;
- --
- -- Name: comments_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE public.comments_id_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.comments_id_seq OWNER TO postgres;
- --
- -- Name: comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE public.comments_id_seq OWNED BY public.comments.id;
- --
- -- Name: posts; Type: TABLE; Schema: public; Owner: postgres
- --
- CREATE TABLE public.posts (
- id integer NOT NULL,
- title character varying(120) NOT NULL,
- author character varying(36) NOT NULL,
- date timestamp with time zone DEFAULT now(),
- metadata text NOT NULL,
- snippet text NOT NULL,
- content text NOT NULL
- );
- ALTER TABLE public.posts OWNER TO postgres;
- --
- -- Name: posts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
- --
- CREATE SEQUENCE public.posts_id_seq
- START WITH 1
- INCREMENT BY 1
- NO MINVALUE
- NO MAXVALUE
- CACHE 1;
- ALTER TABLE public.posts_id_seq OWNER TO postgres;
- --
- -- Name: posts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
- --
- ALTER SEQUENCE public.posts_id_seq OWNED BY public.posts.id;
- --
- -- Name: users; Type: TABLE; Schema: public; Owner: postgres
- --
- CREATE TABLE public.users (
- username character varying(36) NOT NULL,
- email character varying(255) NOT NULL,
- password character varying(255) NOT NULL
- );
- ALTER TABLE public.users OWNER TO postgres;
- --
- -- Name: comments id; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.comments ALTER COLUMN id SET DEFAULT nextval('public.comments_id_seq'::regclass);
- --
- -- Name: posts id; Type: DEFAULT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.posts ALTER COLUMN id SET DEFAULT nextval('public.posts_id_seq'::regclass);
- --
- -- Data for Name: comments; Type: TABLE DATA; Schema: public; Owner: postgres
- --
- COPY public.comments (id, post_id, parent_id, author, date, content, deleted) FROM stdin;
- 3 1 2 33333333333 2019-02-07 02:06:05.743828+03 33333333333 f
- 6 1 5 66666666666 2019-02-07 02:06:28.221934+03 66666666666 f
- 7 1 2 7777777777777 2019-02-07 02:06:45.734158+03 777777777777777 f
- 8 1 \N 888888888 2019-02-07 02:07:01.267083+03 8888888888 f
- 9 1 \N 99999999999 2019-02-07 02:07:06.950668+03 99999999999 f
- 10 1 9 10101010 2019-02-07 02:07:16.425395+03 10101010 f
- 11 1 10 11 11 11 2019-02-07 02:07:31.071393+03 11 11 11 f
- 23 2 22 level7 2019-02-07 11:03:54.623249+03 level7 f
- 24 2 23 level8 2019-02-07 11:04:12.241839+03 level8 f
- 25 2 19 level4 2019-02-07 11:04:50.110743+03 level4 f
- 26 2 24 level9 2019-02-07 11:12:27.809736+03 level9 f
- 27 2 26 level9 2019-02-07 11:12:35.638239+03 level9 f
- 28 2 27 level10 2019-02-07 11:12:47.875638+03 level10 f
- 29 2 28 level10 2019-02-07 11:12:55.829989+03 level10 f
- 30 2 29 level10 2019-02-07 11:13:06.111864+03 level10 f
- 31 2 30 level11 2019-02-07 11:13:29.777985+03 level11 f
- 32 2 31 level11 2019-02-07 11:13:43.607098+03 level11 f
- 33 2 32 level12 2019-02-07 11:13:54.759942+03 level12 f
- 34 2 33 level13 2019-02-07 11:15:07.926286+03 level13 f
- 35 2 34 level14 2019-02-07 11:15:22.850474+03 level14 f
- 36 2 35 level15 2019-02-07 11:15:51.433744+03 level15 f
- 37 2 36 level16 2019-02-07 11:16:29.640644+03 level16 f
- 38 2 37 level17 2019-02-07 11:17:13.000062+03 level17 f
- 39 2 38 level18 2019-02-07 11:19:46.221815+03 level18 f
- 40 2 39 level18 2019-02-07 11:20:10.637804+03 level18 f
- 41 2 \N level0 2019-02-07 11:20:53.402039+03 level0 f
- 42 2 41 level1 2019-02-07 11:21:09.242073+03 level1 f
- 43 2 42 level2 2019-02-07 11:21:16.80833+03 level2 f
- 44 2 43 level3 2019-02-07 11:21:23.012851+03 level3 f
- 45 2 44 level4 2019-02-07 11:21:29.079756+03 level4 f
- 46 2 45 level5 2019-02-07 11:21:38.951397+03 level5 f
- 47 2 \N levle0 2019-02-07 11:22:02.450715+03 level0 f
- 48 2 47 level1 2019-02-07 11:22:08.353634+03 level1 f
- 49 2 48 level2 2019-02-07 11:22:13.592835+03 level2 f
- 50 2 49 level3 2019-02-07 11:22:19.927872+03 level3 f
- 51 2 50 level4 2019-02-07 11:22:25.612957+03 level4 f
- 52 2 51 level5 2019-02-07 11:22:52.350518+03 level5 f
- 53 2 \N level0 2019-02-07 11:24:31.447031+03 level0 f
- 54 2 53 level2 2019-02-07 11:25:09.137062+03 level1 f
- 55 2 54 level3 2019-02-07 11:25:15.108437+03 level3 f
- 56 2 55 level5 2019-02-07 11:25:20.773315+03 level4 f
- 57 2 56 level5 2019-02-07 11:25:29.522842+03 level5 f
- 58 2 57 level6 2019-02-07 11:25:40.35503+03 level6 f
- 59 2 \N level0 2019-02-07 11:28:23.025267+03 level0 f
- 60 2 59 level1 2019-02-07 11:28:46.121629+03 level1 f
- 61 2 60 level2 2019-02-07 11:31:22.206013+03 level2 f
- 62 2 \N levle0 2019-02-07 11:31:33.740258+03 level0 f
- 63 2 62 level1 2019-02-07 11:31:39.779064+03 level1 f
- 64 2 63 level2 2019-02-07 11:32:02.627417+03 level2 f
- 65 2 64 level3 2019-02-07 11:33:25.753981+03 level3 f
- 66 2 \N level0 2019-02-07 11:35:16.358808+03 level0 f
- 67 2 66 level1 2019-02-07 11:35:23.085013+03 level1 f
- 68 2 \N level0 2019-02-07 11:38:00.634161+03 level0 f
- 69 2 68 level1 2019-02-07 11:38:05.913588+03 level1 f
- 70 2 \N level0 2019-02-07 11:40:29.514803+03 level0 f
- 71 2 70 level1 2019-02-07 11:40:36.106624+03 level1 f
- 72 2 71 level2 2019-02-07 11:40:42.529202+03 level2 f
- 73 2 \N levle0 2019-02-07 11:41:58.201383+03 level0 f
- 74 2 \N level0 2019-02-07 11:42:58.956097+03 level0 f
- 75 2 74 level1 2019-02-07 11:43:10.941172+03 level1 f
- 76 2 75 level2 2019-02-07 11:43:52.308413+03 level2 f
- 77 2 76 level3 2019-02-07 11:44:09.162195+03 level3 f
- 78 2 77 level3 2019-02-07 11:44:17.847031+03 level3 f
- 79 2 78 level3 2019-02-07 11:44:28.733696+03 level3 f
- 80 2 79 level3 2019-02-07 11:44:35.776304+03 level3 f
- 81 2 \N level0 2019-02-07 12:35:55.189785+03 level0 f
- 82 2 \N level0 2019-02-07 12:36:47.724286+03 level0 f
- 83 2 \N level0 2019-02-07 12:37:49.797067+03 level0 f
- 84 2 \N level0 2019-02-07 12:38:24.565164+03 level0 f
- 85 2 84 level1 2019-02-07 12:42:14.227161+03 level1 f
- 86 2 85 level2 2019-02-07 12:42:18.99595+03 level2 f
- 87 2 86 level3 2019-02-07 12:42:24.994774+03 level3 f
- 88 2 87 level4 2019-02-07 12:42:30.304767+03 level4 f
- 89 2 88 level5 2019-02-07 12:42:34.434509+03 level5 f
- 90 2 89 level6 2019-02-07 12:42:40.751569+03 level6 f
- 91 2 89 level7 2019-02-07 12:42:46.317887+03 level7 f
- 92 2 91 level8 2019-02-07 12:42:51.597641+03 level8 f
- 93 2 92 level10 2019-02-07 12:44:25.725416+03 level10 f
- 94 2 91 level9 2019-02-07 12:44:27.888126+03 level9 f
- 95 2 93 level12 2019-02-07 12:44:47.62122+03 level12 f
- 96 2 94 level13 2019-02-07 12:44:58.384019+03 level13 f
- 97 2 96 level14 2019-02-07 12:45:05.825171+03 level14 f
- 98 2 97 level15 2019-02-07 12:45:13.197888+03 level15 f
- 99 2 98 level16 2019-02-07 12:46:24.953988+03 level16 f
- 100 2 99 level17 2019-02-07 12:50:58.101216+03 <b>level16</b>, level17 f
- 101 2 100 level18 2019-02-07 12:51:55.120594+03 <b>level17</b>, level18 f
- 102 2 101 level19 2019-02-07 12:53:17.062221+03 level19 f
- 103 2 33 level14 2019-02-07 12:54:49.586367+03 level14 f
- 104 2 17 выавыыва 2019-02-07 12:56:17.194162+03 ыавпвыаыва f
- 105 2 102 level20 2019-02-07 13:00:02.19291+03 <b>level19</b>, level20 f
- 106 2 105 level21 2019-02-07 13:00:33.355513+03 <b>level20</b>, <script>alert('Uv been pwned')</script> f
- 107 2 106 <script>alert('Uv')</script> 2019-02-07 13:03:35.807632+03 <b>level21</b>, <script>alert('Uv been pwned')</script> f
- 108 2 17 sdfcdsfds 2019-02-07 13:12:18.041145+03 sdfsdfcsdfc f
- 109 2 17 sdfscsxsdcs 2019-02-07 13:12:59.211444+03 sdfsdfceewfr f
- 110 2 17 sdffcsdvsfrsfr 2019-02-07 13:13:51.20004+03 dsfsdxwefw f
- 111 2 17 fcwfdwdwd 2019-02-07 13:14:53.848747+03 sdfxwwewef f
- 112 2 17 ewdsdfdasf 2019-02-07 13:15:01.053711+03 sdfcsdxwxe f
- 113 2 17 dsfcwefdewd 2019-02-07 13:15:06.754601+03 dsfsdfwefw f
- 20 2 19 level4 2019-02-07 11:03:33.920659+03 Содержимое этого комментария было удалено t
- 22 2 21 level6 2019-02-07 11:03:43.765608+03 Содержимое этого комментария было удалено t
- 13 1 12 13 13 13 2019-02-07 02:07:50.662212+03 Содержимое этого комментария было удалено t
- 12 1 11 12 12 12 2019-02-07 02:07:41.277423+03 Содержимое этого комментария было удалено t
- 2 1 \N 2222222222 2019-02-07 02:05:59.592599+03 Содержимое этого комментария было удалено t
- 5 1 2 555555555 2019-02-07 02:06:21.00403+03 Содержимое этого комментария было удалено t
- 114 2 17 ecvecwxdsd 2019-02-07 13:15:41.484829+03 sdfxewf f
- 115 2 17 sdfsdfdsf 2019-02-07 13:17:34.269696+03 sdfdxw f
- 116 2 \N level 0 1 2019-02-07 13:44:07.593003+03 level 0 1 f
- 117 2 116 level 0 2 2019-02-07 13:44:35.674244+03 level 0 2 f
- 118 2 117 level 0 3 2019-02-07 13:44:58.090649+03 level 0 3 f
- 120 2 119 level 0 2 2019-02-07 13:50:18.160353+03 level 0 2 f
- 121 2 120 level 0 3 2019-02-07 13:50:23.811623+03 level 0 3 f
- 19 2 18 level3 2019-02-07 11:03:27.830069+03 Содержимое этого комментария было удалено t
- 21 2 20 level5 2019-02-07 11:03:38.535957+03 Содержимое этого комментария было удалено t
- 131 2 17 dsfsdf 2019-02-07 16:38:15.244235+03 sdfsdfs f
- 132 2 17 sdfsdfds 2019-02-07 16:38:20.347587+03 sdfsdfsd f
- 18 2 17 level2 2019-02-07 11:03:21.978387+03 Содержимое этого комментария было удалено t
- 17 2 \N level1 2019-02-07 11:03:12.705866+03 Содержимое этого комментария было удаленоываыв t
- 133 1 13 14 14 14 2019-02-09 18:01:54.882718+03 Содержимое этого комментария было удалено t
- 122 2 \N sdfdfsdfsdfdsfdsfdsf 2019-02-07 15:28:41.177424+03 Содержимое этого комментария было удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое этого комментария было удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое этого комментария было удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое этого комментария было удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое этого комментария было удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое этого комментария было удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое этого комментария было удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjddddddСодержимое этого комментария было удаленоsdsdfdsfdssdffdgfdgsdfsdfsdfdsfdsdsfsljfdhsfhfsjdhfkjdddddd t
- 119 2 \N level 0 1 2019-02-07 13:49:25.059652+03 level 0 1sdfsd f
- 123 2 119 wefwefwf 2019-02-07 16:16:00.714222+03 sdfdsdsf f
- 124 2 119 sdcsdcsdfc 2019-02-07 16:16:13.992854+03 sdfdsfsdfcwefd f
- 125 2 119 sddsxwwsdfsdf 2019-02-07 16:19:15.067851+03 dffdssfdvcdfvfdvfsg f
- 126 2 122 уцавцувуцацу 2019-02-07 16:22:02.711657+03 ываываыва f
- 127 2 126 sdfsfsfsd 2019-02-07 16:23:46.245729+03 sdfdsxwqef f
- 128 2 127 sffsgsgdfg 2019-02-07 16:24:12.786375+03 sfdgfgfg f
- 130 2 128 dsfsdfsd 2019-02-07 16:25:43.502755+03 sdfsdsdfdsfsdfsdfsdfsdf f
- 129 2 128 sdfcsdacxsdf 2019-02-07 16:25:36.398731+03 Содержимое этого комментария было удалено t
- \.
- --
- -- Name: comments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
- --
- SELECT pg_catalog.setval('public.comments_id_seq', 136, true);
- --
- -- Data for Name: posts; Type: TABLE DATA; Schema: public; Owner: postgres
- --
- COPY public.posts (id, title, author, date, metadata, snippet, content) FROM stdin;
- 1 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
- \.
- --
- -- Name: posts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
- --
- SELECT pg_catalog.setval('public.posts_id_seq', 1, true);
- --
- -- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
- --
- COPY public.users (username, email, password) FROM stdin;
- msajdfk239 msajdfk239@gmail.com $2a$10$oJHvTo84B0N8VXFe4XS3g.Lqnl/NrWrkLSaXE1l/m8zY64RQR/l9q
- dsfsdx2243 dsfsdx2243@gmail.com $2a$10$LDwmt9IprhP8i698wPjscOEhJKbLzd7yLGM8Qjk2Pc6IkEdEamOoq
- dfsfs1314 dfsfs1314@gmail.com $2a$10$TcD4YArsbM9kXHuiK55sMeGP3/2YHVd.GL3eKqYNCOP2rNMdFNjaW
- admin131 admin131@gmail.com $2a$10$MUsQ0fuK4YnMZusKG3nxyunQphVM4Gt47YyZnc1y1C.FEh9hmEUDW
- \.
- --
- -- Name: comments comments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.comments
- ADD CONSTRAINT comments_pkey PRIMARY KEY (id);
- --
- -- Name: posts posts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
- --
- ALTER TABLE ONLY public.posts
- ADD CONSTRAINT posts_pkey PRIMARY KEY (id);
- --
- -- Name: emailindex; Type: INDEX; Schema: public; Owner: postgres
- --
- CREATE UNIQUE INDEX emailindex ON public.users USING btree (email);
- --
- -- Name: idindex; Type: INDEX; Schema: public; Owner: postgres
- --
- CREATE UNIQUE INDEX idindex ON public.comments USING btree (id);
- --
- -- Name: loginindex; Type: INDEX; Schema: public; Owner: postgres
- --
- CREATE UNIQUE INDEX loginindex ON public.users USING btree (username);
- --
- -- Name: postidindex; Type: INDEX; Schema: public; Owner: postgres
- --
- CREATE INDEX postidindex ON public.comments USING btree (post_id);
- --
- -- PostgreSQL database dump complete
- --
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement