· 6 years ago · May 31, 2019, 08:14 PM
1--
2-- PostgreSQL database dump
3--
4
5SET statement_timeout = 0;
6SET lock_timeout = 0;
7SET client_encoding = 'UTF8';
8SET standard_conforming_strings = on;
9SET check_function_bodies = false;
10SET client_min_messages = warning;
11
12--
13-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
14--
15
16CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
17
18
19--
20-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
21--
22
23COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
24
25
26SET search_path = public, pg_catalog;
27
28SET default_tablespace = '';
29
30SET default_with_oids = false;
31
32--
33-- Name: account; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
34--
35
36CREATE TABLE account (
37 id integer NOT NULL,
38 auth_id character varying(40),
39 username character varying(30)
40);
41
42
43ALTER TABLE public.account OWNER TO postgres;
44
45--
46-- Name: account_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
47--
48
49CREATE SEQUENCE account_id_seq
50 START WITH 1
51 INCREMENT BY 1
52 NO MINVALUE
53 NO MAXVALUE
54 CACHE 1;
55
56
57ALTER TABLE public.account_id_seq OWNER TO postgres;
58
59--
60-- Name: account_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
61--
62
63ALTER SEQUENCE account_id_seq OWNED BY account.id;
64
65
66--
67-- Name: phone_number; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
68--
69
70CREATE TABLE phone_number (
71 id integer NOT NULL,
72 number character varying(40),
73 account_id integer
74);
75
76
77ALTER TABLE public.phone_number OWNER TO postgres;
78
79--
80-- Name: phone_number_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
81--
82
83CREATE SEQUENCE phone_number_id_seq
84 START WITH 1
85 INCREMENT BY 1
86 NO MINVALUE
87 NO MAXVALUE
88 CACHE 1;
89
90
91ALTER TABLE public.phone_number_id_seq OWNER TO postgres;
92
93--
94-- Name: phone_number_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
95--
96
97ALTER SEQUENCE phone_number_id_seq OWNED BY phone_number.id;
98
99
100--
101-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
102--
103
104ALTER TABLE ONLY account ALTER COLUMN id SET DEFAULT nextval('account_id_seq'::regclass);
105
106
107--
108-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
109--
110
111ALTER TABLE ONLY phone_number ALTER COLUMN id SET DEFAULT nextval('phone_number_id_seq'::regclass);
112
113
114--
115-- Data for Name: account; Type: TABLE DATA; Schema: public; Owner: postgres
116--
117
118COPY account (id, auth_id, username) FROM stdin;
1191 20S0KPNOIM azr1
1202 54P2EOKQ47 azr2
1213 9LLV6I4ZWI azr3
1224 YHWE3HDLPQ azr4
1235 6DLH8A25XZ azr5
124\.
125
126
127--
128-- Name: account_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
129--
130
131SELECT pg_catalog.setval('account_id_seq', 5, true);
132
133
134--
135-- Data for Name: phone_number; Type: TABLE DATA; Schema: public; Owner: postgres
136--
137
138COPY phone_number (id, number, account_id) FROM stdin;
1391 4924195509198 1
1402 4924195509196 1
1413 4924195509197 1
1424 4924195509195 1
1435 4924195509049 1
1446 4924195509012 1
1457 4924195509193 1
1468 4924195509029 1
1479 4924195509192 1
14810 4924195509194 1
14911 31297728125 1
15012 3253280312 1
15113 3253280311 1
15214 3253280315 1
15315 3253280313 1
15416 3253280329 1
15517 441224459508 1
15618 441224980086 1
15719 441224980087 1
15820 441224980096 1
15921 441224980098 1
16022 441224980099 1
16123 441224980100 1
16224 441224980094 2
16325 441224459426 2
16426 13605917249 2
16527 441224459548 2
16628 441224459571 2
16729 441224459598 2
16830 13605895047 2
16931 14433600975 2
17032 16052299352 2
17133 13602092244 2
17234 441224459590 2
17335 441224459620 2
17436 441224459660 2
17537 234568266473 2
17638 441224980091 2
17739 441224980092 2
17840 441224980089 2
17941 441224459482 2
18042 441224980093 2
18143 441887480051 2
18244 441873440028 2
18345 441873440017 3
18446 441970450009 3
18547 441235330075 3
18648 441235330053 3
18749 441235330044 3
18850 441235330078 3
18951 34881254103 3
19052 61871112946 3
19153 61871112915 3
19254 61881666904 3
19355 61881666939 3
19456 61871112913 3
19557 61871112901 3
19658 61871112938 3
19759 61871112934 3
19860 61871112902 3
19961 61881666926 4
20062 61871705936 4
20163 61871112920 4
20264 61881666923 4
20365 61871112947 4
20466 61871112948 4
20567 61871112921 4
20668 61881666914 4
20769 61881666942 4
20870 61871112922 4
20971 61871232393 4
21072 61871112916 5
21173 61881666921 5
21274 61871112905 5
21375 61871112937 5
21476 61361220301 5
21577 61871112931 5
21678 61871112939 5
21779 61871112940 5
218\.
219
220
221--
222-- Name: phone_number_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
223--
224
225SELECT pg_catalog.setval('phone_number_id_seq', 79, true);
226
227
228--
229-- Name: account_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
230--
231
232ALTER TABLE ONLY account
233 ADD CONSTRAINT account_pkey PRIMARY KEY (id);
234
235
236--
237-- Name: phone_number_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
238--
239
240ALTER TABLE ONLY phone_number
241 ADD CONSTRAINT phone_number_pkey PRIMARY KEY (id);
242
243
244--
245-- Name: phone_number_account_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
246--
247
248ALTER TABLE ONLY phone_number
249 ADD CONSTRAINT phone_number_account_id_fkey FOREIGN KEY (account_id) REFERENCES account(id);
250
251
252--
253-- Name: public; Type: ACL; Schema: -; Owner: postgres
254--
255
256REVOKE ALL ON SCHEMA public FROM PUBLIC;
257REVOKE ALL ON SCHEMA public FROM postgres;
258GRANT ALL ON SCHEMA public TO postgres;
259GRANT ALL ON SCHEMA public TO PUBLIC;
260
261
262--
263-- PostgreSQL database dump
264--