· 6 years ago · Jan 15, 2020, 04:28 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 11.5
6-- Dumped by pg_dump version 11.5
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 xmloption = content;
16SET client_min_messages = warning;
17SET row_security = off;
18
19--
20-- Name: adminpack; Type: EXTENSION; Schema: -; Owner: -
21--
22
23CREATE EXTENSION IF NOT EXISTS adminpack WITH SCHEMA pg_catalog;
24
25
26--
27-- Name: EXTENSION adminpack; Type: COMMENT; Schema: -; Owner: -
28--
29
30COMMENT ON EXTENSION adminpack IS 'administrative functions for PostgreSQL';
31
32
33SET default_tablespace = '';
34
35SET default_with_oids = false;
36
37--
38-- Name: company; Type: TABLE; Schema: public; Owner: -
39--
40
41CREATE TABLE public.company (
42 id integer NOT NULL,
43 name character varying(30) NOT NULL,
44 country_id integer NOT NULL
45);
46
47
48--
49-- Name: company_id_seq; Type: SEQUENCE; Schema: public; Owner: -
50--
51
52CREATE SEQUENCE public.company_id_seq
53 AS integer
54 START WITH 1
55 INCREMENT BY 1
56 NO MINVALUE
57 NO MAXVALUE
58 CACHE 1;
59
60
61--
62-- Name: company_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
63--
64
65ALTER SEQUENCE public.company_id_seq OWNED BY public.company.id;
66
67
68--
69-- Name: country; Type: TABLE; Schema: public; Owner: -
70--
71
72CREATE TABLE public.country (
73 id integer NOT NULL,
74 name character varying(20) NOT NULL
75);
76
77
78--
79-- Name: country_id_seq; Type: SEQUENCE; Schema: public; Owner: -
80--
81
82CREATE SEQUENCE public.country_id_seq
83 AS integer
84 START WITH 1
85 INCREMENT BY 1
86 NO MINVALUE
87 NO MAXVALUE
88 CACHE 1;
89
90
91--
92-- Name: country_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
93--
94
95ALTER SEQUENCE public.country_id_seq OWNED BY public.country.id;
96
97
98--
99-- Name: game; Type: TABLE; Schema: public; Owner: -
100--
101
102CREATE TABLE public.game (
103 id integer NOT NULL,
104 name character varying(40) NOT NULL,
105 release date NOT NULL,
106 company_id integer NOT NULL
107);
108
109
110--
111-- Name: game_id_seq; Type: SEQUENCE; Schema: public; Owner: -
112--
113
114CREATE SEQUENCE public.game_id_seq
115 AS integer
116 START WITH 1
117 INCREMENT BY 1
118 NO MINVALUE
119 NO MAXVALUE
120 CACHE 1;
121
122
123--
124-- Name: game_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
125--
126
127ALTER SEQUENCE public.game_id_seq OWNED BY public.game.id;
128
129
130--
131-- Name: company id; Type: DEFAULT; Schema: public; Owner: -
132--
133
134ALTER TABLE ONLY public.company ALTER COLUMN id SET DEFAULT nextval('public.company_id_seq'::regclass);
135
136
137--
138-- Name: country id; Type: DEFAULT; Schema: public; Owner: -
139--
140
141ALTER TABLE ONLY public.country ALTER COLUMN id SET DEFAULT nextval('public.country_id_seq'::regclass);
142
143
144--
145-- Name: game id; Type: DEFAULT; Schema: public; Owner: -
146--
147
148ALTER TABLE ONLY public.game ALTER COLUMN id SET DEFAULT nextval('public.game_id_seq'::regclass);
149
150
151--
152-- Data for Name: company; Type: TABLE DATA; Schema: public; Owner: -
153--
154
155INSERT INTO public.company (id, name, country_id) VALUES (1, 'Brainy Studio LLC', 5);
156INSERT INTO public.company (id, name, country_id) VALUES (2, 'CD Projekt RED', 6);
157INSERT INTO public.company (id, name, country_id) VALUES (3, 'Nintendo', 2);
158INSERT INTO public.company (id, name, country_id) VALUES (4, 'NCsoft', 4);
159INSERT INTO public.company (id, name, country_id) VALUES (9, 'Rockstar Games', 3);
160INSERT INTO public.company (id, name, country_id) VALUES (10, 'Electronic Arts', 3);
161INSERT INTO public.company (id, name, country_id) VALUES (11, 'Студия Носкова Сергея', 5);
162
163
164--
165-- Data for Name: country; Type: TABLE DATA; Schema: public; Owner: -
166--
167
168INSERT INTO public.country (id, name) VALUES (2, 'Japan');
169INSERT INTO public.country (id, name) VALUES (3, 'USA');
170INSERT INTO public.country (id, name) VALUES (4, 'South Korea');
171INSERT INTO public.country (id, name) VALUES (5, 'Russia');
172INSERT INTO public.country (id, name) VALUES (6, 'Poland');
173INSERT INTO public.country (id, name) VALUES (7, 'Ukraine ');
174
175
176--
177-- Data for Name: game; Type: TABLE DATA; Schema: public; Owner: -
178--
179
180INSERT INTO public.game (id, name, release, company_id) VALUES (1, 'WitchCraft', '2013-01-24', 1);
181INSERT INTO public.game (id, name, release, company_id) VALUES (3, 'TurnOn', '2016-06-01', 1);
182INSERT INTO public.game (id, name, release, company_id) VALUES (5, 'The Witcher', '2007-10-24', 2);
183INSERT INTO public.game (id, name, release, company_id) VALUES (6, 'The Witcher 2: Assassins of Kings', '2011-05-17', 2);
184INSERT INTO public.game (id, name, release, company_id) VALUES (7, 'The Witcher 3: Wild Hunt', '2015-05-19', 2);
185INSERT INTO public.game (id, name, release, company_id) VALUES (8, 'Mario Bros.', '1993-01-01', 3);
186INSERT INTO public.game (id, name, release, company_id) VALUES (9, 'The Legend of Zelda: Link''s Awakening', '2019-09-20', 3);
187INSERT INTO public.game (id, name, release, company_id) VALUES (10, 'Blade & Soul', '2012-06-30', 4);
188INSERT INTO public.game (id, name, release, company_id) VALUES (11, 'Grand Theft Auto V', '2013-09-17', 9);
189INSERT INTO public.game (id, name, release, company_id) VALUES (12, 'Red Dead Redemption 2', '2018-10-18', 9);
190INSERT INTO public.game (id, name, release, company_id) VALUES (13, 'Need for Speed: Underground 2', '2005-03-08', 10);
191INSERT INTO public.game (id, name, release, company_id) VALUES (14, 'Battlefield 3', '2011-10-25', 10);
192INSERT INTO public.game (id, name, release, company_id) VALUES (15, '7th Sector', '2019-03-05', 11);
193
194
195--
196-- Name: company_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
197--
198
199SELECT pg_catalog.setval('public.company_id_seq', 11, true);
200
201
202--
203-- Name: country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
204--
205
206SELECT pg_catalog.setval('public.country_id_seq', 7, true);
207
208
209--
210-- Name: game_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
211--
212
213SELECT pg_catalog.setval('public.game_id_seq', 15, true);
214
215
216--
217-- Name: company company_pk; Type: CONSTRAINT; Schema: public; Owner: -
218--
219
220ALTER TABLE ONLY public.company
221 ADD CONSTRAINT company_pk PRIMARY KEY (id);
222
223
224--
225-- Name: country country_pk; Type: CONSTRAINT; Schema: public; Owner: -
226--
227
228ALTER TABLE ONLY public.country
229 ADD CONSTRAINT country_pk PRIMARY KEY (id);
230
231
232--
233-- Name: game game_pk; Type: CONSTRAINT; Schema: public; Owner: -
234--
235
236ALTER TABLE ONLY public.game
237 ADD CONSTRAINT game_pk PRIMARY KEY (id);
238
239
240--
241-- Name: game_name_uindex; Type: INDEX; Schema: public; Owner: -
242--
243
244CREATE UNIQUE INDEX game_name_uindex ON public.game USING btree (name);
245
246
247--
248-- Name: company company_country_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
249--
250
251ALTER TABLE ONLY public.company
252 ADD CONSTRAINT company_country_id_fk FOREIGN KEY (country_id) REFERENCES public.country(id);
253
254
255--
256-- Name: game game_company_id_fk; Type: FK CONSTRAINT; Schema: public; Owner: -
257--
258
259ALTER TABLE ONLY public.game
260 ADD CONSTRAINT game_company_id_fk FOREIGN KEY (company_id) REFERENCES public.company(id);
261
262
263--
264-- PostgreSQL database dump complete
265--