· 8 years ago · Feb 02, 2018, 03:12 PM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.3
6-- Dumped by pg_dump version 9.6.3
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;
13SET check_function_bodies = false;
14SET client_min_messages = warning;
15SET row_security = off;
16
17--
18-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
19--
20
21CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
22
23
24--
25-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
26--
27
28COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
29
30
31SET search_path = public, pg_catalog;
32
33SET default_tablespace = '';
34
35SET default_with_oids = false;
36
37--
38-- Name: gallery; Type: TABLE; Schema: public; Owner: hharutyunyan
39--
40
41CREATE TABLE gallery (
42 id integer NOT NULL,
43 description character varying(255),
44 image character varying(255)
45);
46
47
48ALTER TABLE gallery OWNER TO hharutyunyan;
49
50--
51-- Name: news; Type: TABLE; Schema: public; Owner: hharutyunyan
52--
53
54CREATE TABLE news (
55 id integer NOT NULL,
56 title character varying(255) NOT NULL,
57 text text NOT NULL,
58 short text NOT NULL,
59 is_published boolean DEFAULT false,
60 date_published date NOT NULL,
61 last_edited date,
62 image character varying(255)
63);
64
65
66ALTER TABLE news OWNER TO hharutyunyan;
67
68--
69-- Name: news_id_seq; Type: SEQUENCE; Schema: public; Owner: hharutyunyan
70--
71
72CREATE SEQUENCE news_id_seq
73 START WITH 1
74 INCREMENT BY 1
75 NO MINVALUE
76 NO MAXVALUE
77 CACHE 1;
78
79
80ALTER TABLE news_id_seq OWNER TO hharutyunyan;
81
82--
83-- Name: news_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: hharutyunyan
84--
85
86ALTER SEQUENCE news_id_seq OWNED BY news.id;
87
88
89--
90-- Name: users; Type: TABLE; Schema: public; Owner: hharutyunyan
91--
92
93CREATE TABLE users (
94 id integer NOT NULL,
95 login character varying NOT NULL,
96 password character varying NOT NULL
97);
98
99
100ALTER TABLE users OWNER TO hharutyunyan;
101
102--
103-- Name: news id; Type: DEFAULT; Schema: public; Owner: hharutyunyan
104--
105
106ALTER TABLE ONLY news ALTER COLUMN id SET DEFAULT nextval('news_id_seq'::regclass);
107
108
109--
110-- Data for Name: gallery; Type: TABLE DATA; Schema: public; Owner: hharutyunyan
111--
112
113COPY gallery (id, description, image) FROM stdin;
1142 Prime Minister Visits the School \N
1153 Our Students at Ministry of Education \N
1164 test \N
1175 this is another test \N
1186 Lorem Ipsum \N
1197 Test Title \N
1208 this is abother test \N
1219 And another one \N
12210 Finally the last one \N
1231 Visit to Garni 1.JPG
124\.
125
126
127--
128-- Data for Name: news; Type: TABLE DATA; Schema: public; Owner: hharutyunyan
129--
130
131COPY news (id, title, text, short, is_published, date_published, last_edited, image) FROM stdin;
1323 test article 2 this is the example of an article short t 2017-11-10 \N \N
1334 test article 1 this is just a test article short for test f 2017-11-12 \N \N
1345 test article 2 this is the example of an article short t 2017-11-10 \N \N
1356 test article 2 this is the example of an article short t 2017-11-10 \N \N
1367 test article 2 this is the example of an article short t 2017-11-10 \N \N
13713 test article 1 this is just a test article short for test f 2017-11-12 \N \N
13814 test article 2 this is the example of an article short t 2017-11-10 \N \N
13915 test article 2 this is the example of an article short t 2017-11-10 \N \N
14016 test article 1 this is just a test article short for test f 2017-11-12 \N \N
14117 test article 2 this is the example of an article short t 2017-11-10 \N \N
14219 test article 2 this is the example of an article short t 2017-11-10 \N \N
14320 test article 1 this is just a test article short for test f 2017-11-12 \N \N
14421 test article 2 this is the example of an article short t 2017-11-10 \N \N
14522 test article 2 this is the example of an article short t 2017-11-10 \N \N
14623 test article 1 this is just a test article short for test f 2017-11-12 \N \N
14724 test article 2 this is the example of an article short t 2017-11-10 \N \N
14825 test article 2 this is the example of an article short t 2017-11-10 \N \N
14926 test article 2 this is the example of an article short t 2017-11-10 \N \N
15027 test article 1 this is just a test article short for test f 2017-11-12 \N \N
15128 test article 2 this is the example of an article short t 2017-11-10 \N \N
15229 test article 2 this is the example of an article short t 2017-11-10 \N \N
15330 test article 1 this is just a test article short for test f 2017-11-12 \N \N
15431 test article 2 this is the example of an article short t 2017-11-10 \N \N
15532 test article 2 this is the example of an article short t 2017-11-10 \N \N
15640 test thisa bjsdkf <br> Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. t 2017-11-16 \N 40.jpg
15739 test <p>this</p><p>is </p><p>&nbsp; an enhacned&nbsp;&nbsp;&nbsp; :D </p><p>test<br></p> test t 2017-11-16 \N 39.jpg
1581 test article 1 this is just a test article this ijhk kjhjkh kjh jkh kjh kj short for test f 2017-11-12 \N \N
1592 test article 2 this is the example of an article jhjhjhjhj short t 2017-11-10 \N \N
16018 test article 2 <p>this is the example of an article this </p><p><br></p><p>is </p><p> a</p><p>gete <br></p> short t 2017-11-10 \N \N
16133 test article 2 this is the example of an article short t 2017-11-10 \N \N
16235 test from MS test <br> test f 2017-11-16 \N 35.png
16336 test <p>this is </p><p>a </p><p>enhanced </p><p> test<br></p> this is a test f 2017-11-16 \N \N
16437 test this is another test<br> this is a test f 2017-11-16 \N \N
16538 test test test f 2017-11-16 \N \N
16641 test <p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod \r\ntempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim \r\nveniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea \r\ncommodo consequat. Duis aute irure dolor in reprehenderit in voluptate \r\nvelit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint \r\noccaecat cupidatat non proident, sunt in culpa qui officia deserunt \r\nmollit anim id est laborum.</p> test t 2017-11-16 \N 41.jpg
167\.
168
169
170--
171-- Name: news_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hharutyunyan
172--
173
174SELECT pg_catalog.setval('news_id_seq', 41, true);
175
176
177--
178-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: hharutyunyan
179--
180
181COPY users (id, login, password) FROM stdin;
1821 hharutyunyan 8abd4dea44e15a13f7fcaa8de53ae5d1f017d9b0
183\.
184
185
186--
187-- Name: gallery gallery_pkey; Type: CONSTRAINT; Schema: public; Owner: hharutyunyan
188--
189
190ALTER TABLE ONLY gallery
191 ADD CONSTRAINT gallery_pkey PRIMARY KEY (id);
192
193
194--
195-- Name: news news_pkey; Type: CONSTRAINT; Schema: public; Owner: hharutyunyan
196--
197
198ALTER TABLE ONLY news
199 ADD CONSTRAINT news_pkey PRIMARY KEY (id);
200
201
202--
203-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: hharutyunyan
204--
205
206ALTER TABLE ONLY users
207 ADD CONSTRAINT users_pkey PRIMARY KEY (id, login);
208
209
210--
211-- Name: gallery; Type: ACL; Schema: public; Owner: hharutyunyan
212--
213
214GRANT SELECT,UPDATE ON TABLE gallery TO zartonk;
215
216
217--
218-- Name: news; Type: ACL; Schema: public; Owner: hharutyunyan
219--
220
221GRANT SELECT,INSERT,UPDATE ON TABLE news TO zartonk;
222
223
224--
225-- Name: news_id_seq; Type: ACL; Schema: public; Owner: hharutyunyan
226--
227
228GRANT ALL ON SEQUENCE news_id_seq TO zartonk;
229
230
231--
232-- Name: users; Type: ACL; Schema: public; Owner: hharutyunyan
233--
234
235GRANT ALL ON TABLE users TO zartonk;
236
237
238--
239-- PostgreSQL database dump complete
240--