· 7 years ago · Dec 07, 2018, 07:44 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.2.0
6-- Dumped by pg_dump version 9.2.0
7-- Started on 2012-09-28 22:35:53
8
9SET statement_timeout = 0;
10SET client_encoding = 'UTF8';
11SET standard_conforming_strings = on;
12SET check_function_bodies = false;
13SET client_min_messages = warning;
14
15--
16-- TOC entry 177 (class 3079 OID 11727)
17-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
18--
19
20CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
21
22
23--
24-- TOC entry 1981 (class 0 OID 0)
25-- Dependencies: 177
26-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
27--
28
29COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
30
31
32SET search_path = public, pg_catalog;
33
34--
35-- TOC entry 520 (class 1247 OID 16396)
36-- Name: player_role; Type: TYPE; Schema: public; Owner: hockey_user
37--
38
39CREATE TYPE player_role AS ENUM (
40 'goalkeeper',
41 'forward',
42 'defenseman'
43);
44
45
46ALTER TYPE public.player_role OWNER TO hockey_user;
47
48--
49-- TOC entry 523 (class 1247 OID 16404)
50-- Name: stick_hold; Type: TYPE; Schema: public; Owner: hockey_user
51--
52
53CREATE TYPE stick_hold AS ENUM (
54 'left',
55 'right'
56);
57
58
59ALTER TYPE public.stick_hold OWNER TO hockey_user;
60
61SET default_tablespace = '';
62
63SET default_with_oids = false;
64
65--
66-- TOC entry 174 (class 1259 OID 24632)
67-- Name: arr_test; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
68--
69
70CREATE TABLE arr_test (
71 id integer NOT NULL,
72 arr character varying(255)[]
73);
74
75
76ALTER TABLE public.arr_test OWNER TO postgres;
77
78--
79-- TOC entry 173 (class 1259 OID 24630)
80-- Name: arr_test_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
81--
82
83CREATE SEQUENCE arr_test_id_seq
84 START WITH 1
85 INCREMENT BY 1
86 NO MINVALUE
87 NO MAXVALUE
88 CACHE 1;
89
90
91ALTER TABLE public.arr_test_id_seq OWNER TO postgres;
92
93--
94-- TOC entry 1982 (class 0 OID 0)
95-- Dependencies: 173
96-- Name: arr_test_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
97--
98
99ALTER SEQUENCE arr_test_id_seq OWNED BY arr_test.id;
100
101
102--
103-- TOC entry 1983 (class 0 OID 0)
104-- Dependencies: 173
105-- Name: arr_test_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
106--
107
108SELECT pg_catalog.setval('arr_test_id_seq', 6, true);
109
110
111--
112-- TOC entry 172 (class 1259 OID 16451)
113-- Name: h_out; Type: TABLE; Schema: public; Owner: hockey_user; Tablespace:
114--
115
116CREATE TABLE h_out (
117 first_name character(10),
118 second_name character(10),
119 role player_role,
120 number integer,
121 salary numeric
122);
123
124
125ALTER TABLE public.h_out OWNER TO hockey_user;
126
127--
128-- TOC entry 176 (class 1259 OID 24641)
129-- Name: multidim_arr_test; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
130--
131
132CREATE TABLE multidim_arr_test (
133 id integer NOT NULL,
134 arr integer[]
135);
136
137
138ALTER TABLE public.multidim_arr_test OWNER TO postgres;
139
140--
141-- TOC entry 175 (class 1259 OID 24639)
142-- Name: multidim_arr_test_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
143--
144
145CREATE SEQUENCE multidim_arr_test_id_seq
146 START WITH 1
147 INCREMENT BY 1
148 NO MINVALUE
149 NO MAXVALUE
150 CACHE 1;
151
152
153ALTER TABLE public.multidim_arr_test_id_seq OWNER TO postgres;
154
155--
156-- TOC entry 1984 (class 0 OID 0)
157-- Dependencies: 175
158-- Name: multidim_arr_test_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
159--
160
161ALTER SEQUENCE multidim_arr_test_id_seq OWNED BY multidim_arr_test.id;
162
163
164--
165-- TOC entry 1985 (class 0 OID 0)
166-- Dependencies: 175
167-- Name: multidim_arr_test_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
168--
169
170SELECT pg_catalog.setval('multidim_arr_test_id_seq', 6, true);
171
172
173--
174-- TOC entry 168 (class 1259 OID 16409)
175-- Name: players; Type: TABLE; Schema: public; Owner: hockey_user; Tablespace:
176--
177
178CREATE TABLE players (
179 id integer NOT NULL,
180 first_name character(10),
181 second_name character(10),
182 birthday_date date,
183 height integer,
184 weight numeric,
185 CONSTRAINT players_height_range CHECK (((height < 220) AND (height > 150)))
186);
187
188
189ALTER TABLE public.players OWNER TO hockey_user;
190
191--
192-- TOC entry 169 (class 1259 OID 16415)
193-- Name: players_info; Type: TABLE; Schema: public; Owner: hockey_user; Tablespace:
194--
195
196CREATE TABLE players_info (
197 id integer NOT NULL,
198 role player_role,
199 number integer,
200 size integer,
201 hold stick_hold
202);
203
204
205ALTER TABLE public.players_info OWNER TO hockey_user;
206
207--
208-- TOC entry 170 (class 1259 OID 16418)
209-- Name: players_info2; Type: TABLE; Schema: public; Owner: hockey_user; Tablespace:
210--
211
212CREATE TABLE players_info2 (
213 id integer NOT NULL,
214 salary numeric,
215 bonus numeric,
216 fine numeric
217);
218
219
220ALTER TABLE public.players_info2 OWNER TO hockey_user;
221
222--
223-- TOC entry 171 (class 1259 OID 16424)
224-- Name: players_stat; Type: TABLE; Schema: public; Owner: hockey_user; Tablespace:
225--
226
227CREATE TABLE players_stat (
228 id integer NOT NULL,
229 goals integer,
230 passes integer,
231 fine_time integer,
232 play_time integer
233);
234
235
236ALTER TABLE public.players_stat OWNER TO hockey_user;
237
238--
239-- TOC entry 1954 (class 2604 OID 24635)
240-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
241--
242
243ALTER TABLE ONLY arr_test ALTER COLUMN id SET DEFAULT nextval('arr_test_id_seq'::regclass);
244
245
246--
247-- TOC entry 1955 (class 2604 OID 24644)
248-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
249--
250
251ALTER TABLE ONLY multidim_arr_test ALTER COLUMN id SET DEFAULT nextval('multidim_arr_test_id_seq'::regclass);
252
253
254--
255-- TOC entry 1972 (class 0 OID 24632)
256-- Dependencies: 174
257-- Data for Name: arr_test; Type: TABLE DATA; Schema: public; Owner: postgres
258--
259
260INSERT INTO arr_test VALUES (2, '{fewfwf,eqerq,e343f}');
261INSERT INTO arr_test VALUES (3, '{1we}');
262INSERT INTO arr_test VALUES (4, '{efefqfq}');
263INSERT INTO arr_test VALUES (5, '{dfa,kuil,e343f}');
264INSERT INTO arr_test VALUES (1, '{45,54,32}');
265INSERT INTO arr_test VALUES (6, '{0,9,8,9}');
266
267
268--
269-- TOC entry 1971 (class 0 OID 16451)
270-- Dependencies: 172
271-- Data for Name: h_out; Type: TABLE DATA; Schema: public; Owner: hockey_user
272--
273
274INSERT INTO h_out VALUES ('player1 ', 'player1_ ', 'goalkeeper', 15, 20000);
275INSERT INTO h_out VALUES ('player2 ', 'player2_ ', 'goalkeeper', 25, 23000);
276INSERT INTO h_out VALUES ('player3 ', 'player3_ ', 'forward', 47, 20500);
277INSERT INTO h_out VALUES ('player4 ', 'player4_ ', 'forward', 32, 21000);
278INSERT INTO h_out VALUES ('player5 ', 'player5_ ', 'forward', 10, 22000);
279INSERT INTO h_out VALUES ('player6 ', 'player6_ ', 'forward', 55, 21000);
280INSERT INTO h_out VALUES ('player7 ', 'player7_ ', 'defenseman', 73, 22200);
281INSERT INTO h_out VALUES ('player8 ', 'player8_ ', 'defenseman', 62, 23500);
282INSERT INTO h_out VALUES ('player9 ', 'player9_ ', 'defenseman', 63, 20200);
283INSERT INTO h_out VALUES ('player10 ', 'player10_ ', 'defenseman', 99, 25200);
284
285
286--
287-- TOC entry 1973 (class 0 OID 24641)
288-- Dependencies: 176
289-- Data for Name: multidim_arr_test; Type: TABLE DATA; Schema: public; Owner: postgres
290--
291
292INSERT INTO multidim_arr_test VALUES (1, '{{1,2},{3,4}}');
293INSERT INTO multidim_arr_test VALUES (3, '{{1},{45}}');
294INSERT INTO multidim_arr_test VALUES (4, '{{5,NULL,NULL},{46,11,46}}');
295INSERT INTO multidim_arr_test VALUES (5, '{{68,NULL},{23,13}}');
296INSERT INTO multidim_arr_test VALUES (6, '{{31},{11}}');
297INSERT INTO multidim_arr_test VALUES (2, '{{1134,NULL},{6,7},{8,9}}');
298
299
300--
301-- TOC entry 1967 (class 0 OID 16409)
302-- Dependencies: 168
303-- Data for Name: players; Type: TABLE DATA; Schema: public; Owner: hockey_user
304--
305
306INSERT INTO players VALUES (1, 'player1 ', 'player1_ ', '2012-09-10', 170, 100);
307INSERT INTO players VALUES (3, 'player3 ', 'player3_ ', '2008-09-10', 168, 93);
308INSERT INTO players VALUES (5, 'player5 ', 'player5_ ', '2006-09-10', 183, NULL);
309INSERT INTO players VALUES (7, 'player7 ', 'player7_ ', '2005-09-10', 169, NULL);
310INSERT INTO players VALUES (9, 'player9 ', 'player9_ ', '2009-09-10', 189, NULL);
311INSERT INTO players VALUES (10, 'player10 ', 'player10_ ', '2010-10-10', 177, NULL);
312INSERT INTO players VALUES (8, 'player8 ', 'player8_ ', '2007-08-10', 185, NULL);
313INSERT INTO players VALUES (6, 'player6 ', 'player6_ ', '2012-11-10', 176, NULL);
314INSERT INTO players VALUES (4, 'player4 ', 'player4_ ', '2007-05-10', 185, NULL);
315INSERT INTO players VALUES (2, 'player2 ', 'player2_ ', '2009-03-10', 175, NULL);
316
317
318--
319-- TOC entry 1968 (class 0 OID 16415)
320-- Dependencies: 169
321-- Data for Name: players_info; Type: TABLE DATA; Schema: public; Owner: hockey_user
322--
323
324INSERT INTO players_info VALUES (1, 'goalkeeper', 15, 41, 'left');
325INSERT INTO players_info VALUES (3, 'forward', 47, 44, 'right');
326INSERT INTO players_info VALUES (4, 'forward', 32, 45, 'right');
327INSERT INTO players_info VALUES (5, 'forward', 10, 44, 'left');
328INSERT INTO players_info VALUES (7, 'defenseman', 73, 43, 'right');
329INSERT INTO players_info VALUES (8, 'defenseman', 62, 44, 'right');
330INSERT INTO players_info VALUES (9, 'forward', 63, 41, 'left');
331INSERT INTO players_info VALUES (10, 'forward', 99, 43, 'right');
332INSERT INTO players_info VALUES (6, 'forward', 55, 46, 'left');
333INSERT INTO players_info VALUES (2, 'defenseman', 25, 43, 'right');
334
335
336--
337-- TOC entry 1969 (class 0 OID 16418)
338-- Dependencies: 170
339-- Data for Name: players_info2; Type: TABLE DATA; Schema: public; Owner: hockey_user
340--
341
342INSERT INTO players_info2 VALUES (1, 20000, 5000, 1000);
343INSERT INTO players_info2 VALUES (2, 23000, 1000, 0);
344INSERT INTO players_info2 VALUES (3, 20500, 7000, 3000);
345INSERT INTO players_info2 VALUES (4, 21000, 4000, 1000);
346INSERT INTO players_info2 VALUES (5, 22000, 0, 500);
347INSERT INTO players_info2 VALUES (6, 21000, 500, 1500);
348INSERT INTO players_info2 VALUES (7, 22200, 1600, 500);
349INSERT INTO players_info2 VALUES (8, 23500, 900, 2600);
350INSERT INTO players_info2 VALUES (9, 20200, 5500, 1600);
351INSERT INTO players_info2 VALUES (10, 25200, 2500, 600);
352
353
354--
355-- TOC entry 1970 (class 0 OID 16424)
356-- Dependencies: 171
357-- Data for Name: players_stat; Type: TABLE DATA; Schema: public; Owner: hockey_user
358--
359
360INSERT INTO players_stat VALUES (1, 0, 10, 0, 100);
361INSERT INTO players_stat VALUES (2, 1, 2, 100, 500);
362INSERT INTO players_stat VALUES (3, 10, 3, 50, 1500);
363INSERT INTO players_stat VALUES (4, 15, 2, 150, 2500);
364INSERT INTO players_stat VALUES (5, 9, 8, 60, 2000);
365INSERT INTO players_stat VALUES (6, 16, 2, 70, 2600);
366INSERT INTO players_stat VALUES (7, 10, 4, 150, 3000);
367INSERT INTO players_stat VALUES (8, 6, 3, 900, 4000);
368INSERT INTO players_stat VALUES (9, 4, 8, 100, 2000);
369INSERT INTO players_stat VALUES (10, 2, 1, 0, 900);
370
371
372--
373-- TOC entry 1961 (class 2606 OID 16432)
374-- Name: players_info2_pk; Type: CONSTRAINT; Schema: public; Owner: hockey_user; Tablespace:
375--
376
377ALTER TABLE ONLY players_info2
378 ADD CONSTRAINT players_info2_pk PRIMARY KEY (id);
379
380
381--
382-- TOC entry 1959 (class 2606 OID 16430)
383-- Name: players_info_pk; Type: CONSTRAINT; Schema: public; Owner: hockey_user; Tablespace:
384--
385
386ALTER TABLE ONLY players_info
387 ADD CONSTRAINT players_info_pk PRIMARY KEY (id);
388
389
390--
391-- TOC entry 1957 (class 2606 OID 16428)
392-- Name: players_pk; Type: CONSTRAINT; Schema: public; Owner: hockey_user; Tablespace:
393--
394
395ALTER TABLE ONLY players
396 ADD CONSTRAINT players_pk PRIMARY KEY (id);
397
398
399--
400-- TOC entry 1963 (class 2606 OID 16434)
401-- Name: players_stat_pk; Type: CONSTRAINT; Schema: public; Owner: hockey_user; Tablespace:
402--
403
404ALTER TABLE ONLY players_stat
405 ADD CONSTRAINT players_stat_pk PRIMARY KEY (id);
406
407
408--
409-- TOC entry 1965 (class 2606 OID 16440)
410-- Name: players_info2_players_fk; Type: FK CONSTRAINT; Schema: public; Owner: hockey_user
411--
412
413ALTER TABLE ONLY players_info2
414 ADD CONSTRAINT players_info2_players_fk FOREIGN KEY (id) REFERENCES players(id);
415
416
417--
418-- TOC entry 1964 (class 2606 OID 16435)
419-- Name: players_info_players_fk; Type: FK CONSTRAINT; Schema: public; Owner: hockey_user
420--
421
422ALTER TABLE ONLY players_info
423 ADD CONSTRAINT players_info_players_fk FOREIGN KEY (id) REFERENCES players(id);
424
425
426--
427-- TOC entry 1966 (class 2606 OID 16445)
428-- Name: players_stat_players_fk; Type: FK CONSTRAINT; Schema: public; Owner: hockey_user
429--
430
431ALTER TABLE ONLY players_stat
432 ADD CONSTRAINT players_stat_players_fk FOREIGN KEY (id) REFERENCES players(id);
433
434
435--
436-- TOC entry 1980 (class 0 OID 0)
437-- Dependencies: 5
438-- Name: public; Type: ACL; Schema: -; Owner: postgres
439--
440
441REVOKE ALL ON SCHEMA public FROM PUBLIC;
442REVOKE ALL ON SCHEMA public FROM postgres;
443GRANT ALL ON SCHEMA public TO postgres;
444GRANT ALL ON SCHEMA public TO PUBLIC;
445
446
447-- Completed on 2012-09-28 22:35:53
448
449--
450-- PostgreSQL database dump complete
451--