· 8 years ago · Feb 02, 2018, 03:14 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
113INSERT INTO gallery VALUES (2, 'Prime Minister Visits the School', NULL);
114INSERT INTO gallery VALUES (3, 'Our Students at Ministry of Education', NULL);
115INSERT INTO gallery VALUES (4, 'test', NULL);
116INSERT INTO gallery VALUES (5, 'this is another test', NULL);
117INSERT INTO gallery VALUES (6, 'Lorem Ipsum', NULL);
118INSERT INTO gallery VALUES (7, 'Test Title', NULL);
119INSERT INTO gallery VALUES (8, 'this is abother test', NULL);
120INSERT INTO gallery VALUES (9, 'And another one', NULL);
121INSERT INTO gallery VALUES (10, 'Finally the last one', NULL);
122INSERT INTO gallery VALUES (1, 'Visit to Garni', '1.JPG');
123
124
125--
126-- Data for Name: news; Type: TABLE DATA; Schema: public; Owner: hharutyunyan
127--
128
129INSERT INTO news VALUES (3, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
130INSERT INTO news VALUES (4, 'test article 1', 'this is just a test article', 'short for test', false, '2017-11-12', NULL, NULL);
131INSERT INTO news VALUES (5, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
132INSERT INTO news VALUES (6, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
133INSERT INTO news VALUES (7, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
134INSERT INTO news VALUES (13, 'test article 1', 'this is just a test article', 'short for test', false, '2017-11-12', NULL, NULL);
135INSERT INTO news VALUES (14, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
136INSERT INTO news VALUES (15, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
137INSERT INTO news VALUES (16, 'test article 1', 'this is just a test article', 'short for test', false, '2017-11-12', NULL, NULL);
138INSERT INTO news VALUES (17, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
139INSERT INTO news VALUES (19, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
140INSERT INTO news VALUES (20, 'test article 1', 'this is just a test article', 'short for test', false, '2017-11-12', NULL, NULL);
141INSERT INTO news VALUES (21, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
142INSERT INTO news VALUES (22, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
143INSERT INTO news VALUES (23, 'test article 1', 'this is just a test article', 'short for test', false, '2017-11-12', NULL, NULL);
144INSERT INTO news VALUES (24, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
145INSERT INTO news VALUES (25, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
146INSERT INTO news VALUES (26, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
147INSERT INTO news VALUES (27, 'test article 1', 'this is just a test article', 'short for test', false, '2017-11-12', NULL, NULL);
148INSERT INTO news VALUES (28, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
149INSERT INTO news VALUES (29, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
150INSERT INTO news VALUES (30, 'test article 1', 'this is just a test article', 'short for test', false, '2017-11-12', NULL, NULL);
151INSERT INTO news VALUES (31, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
152INSERT INTO news VALUES (32, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
153INSERT INTO news VALUES (40, '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.', true, '2017-11-16', NULL, '40.jpg');
154INSERT INTO news VALUES (39, 'test', '<p>this</p><p>is </p><p>&nbsp; an enhacned&nbsp;&nbsp;&nbsp; :D </p><p>test<br></p>', 'test', true, '2017-11-16', NULL, '39.jpg');
155INSERT INTO news VALUES (1, 'test article 1', 'this is just a test article this ijhk kjhjkh kjh jkh kjh kj', 'short for test', false, '2017-11-12', NULL, NULL);
156INSERT INTO news VALUES (2, 'test article 2', 'this is the example of an article jhjhjhjhj', 'short', true, '2017-11-10', NULL, NULL);
157INSERT INTO news VALUES (18, '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', true, '2017-11-10', NULL, NULL);
158INSERT INTO news VALUES (33, 'test article 2', 'this is the example of an article', 'short', true, '2017-11-10', NULL, NULL);
159INSERT INTO news VALUES (35, 'test from MS', 'test <br>', 'test', false, '2017-11-16', NULL, '35.png');
160INSERT INTO news VALUES (36, 'test ', '<p>this is </p><p>a </p><p>enhanced </p><p> test<br></p>', 'this is a test', false, '2017-11-16', NULL, NULL);
161INSERT INTO news VALUES (37, 'test ', 'this is another test<br>', 'this is a test', false, '2017-11-16', NULL, NULL);
162INSERT INTO news VALUES (38, 'test', 'test', 'test', false, '2017-11-16', NULL, NULL);
163INSERT INTO news VALUES (41, 'test', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod
164tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim
165veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea
166commodo consequat. Duis aute irure dolor in reprehenderit in voluptate
167velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint
168occaecat cupidatat non proident, sunt in culpa qui officia deserunt
169mollit anim id est laborum.</p>', 'test', true, '2017-11-16', NULL, '41.jpg');
170
171
172--
173-- Name: news_id_seq; Type: SEQUENCE SET; Schema: public; Owner: hharutyunyan
174--
175
176SELECT pg_catalog.setval('news_id_seq', 41, true);
177
178
179--
180-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: hharutyunyan
181--
182
183INSERT INTO users VALUES (1, 'hharutyunyan', '8abd4dea44e15a13f7fcaa8de53ae5d1f017d9b0');
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--