· 7 years ago · Sep 24, 2018, 01:20 PM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.6
6-- Dumped by pg_dump version 10.4 (Debian 10.4-2.pgdg90+1)
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 client_min_messages = warning;
16SET row_security = off;
17
18--
19-- Name: gotrue; Type: SCHEMA; Schema: -; Owner: gotrue
20--
21
22CREATE SCHEMA gotrue;
23
24
25ALTER SCHEMA gotrue OWNER TO gotrue;
26
27--
28-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
29--
30
31CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
32
33
34--
35-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
36--
37
38COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
39
40
41SET default_tablespace = '';
42
43SET default_with_oids = false;
44
45--
46-- Name: audit_log_entries; Type: TABLE; Schema: gotrue; Owner: gotrue
47--
48
49CREATE TABLE gotrue.audit_log_entries (
50 instance_id character varying(255),
51 id character varying(255) NOT NULL,
52 payload json,
53 created_at timestamp with time zone
54);
55
56
57ALTER TABLE gotrue.audit_log_entries OWNER TO gotrue;
58
59--
60-- Name: instances; Type: TABLE; Schema: gotrue; Owner: gotrue
61--
62
63CREATE TABLE gotrue.instances (
64 id character varying(255) NOT NULL,
65 uuid character varying(255),
66 raw_base_config text,
67 created_at timestamp with time zone,
68 updated_at timestamp with time zone
69);
70
71
72ALTER TABLE gotrue.instances OWNER TO gotrue;
73
74--
75-- Name: refresh_tokens; Type: TABLE; Schema: gotrue; Owner: gotrue
76--
77
78CREATE TABLE gotrue.refresh_tokens (
79 instance_id character varying(255),
80 id bigint NOT NULL,
81 token character varying(255),
82 user_id character varying(255),
83 revoked boolean,
84 created_at timestamp with time zone,
85 updated_at timestamp with time zone
86);
87
88
89ALTER TABLE gotrue.refresh_tokens OWNER TO gotrue;
90
91--
92-- Name: refresh_tokens_id_seq; Type: SEQUENCE; Schema: gotrue; Owner: gotrue
93--
94
95CREATE SEQUENCE gotrue.refresh_tokens_id_seq
96 START WITH 1
97 INCREMENT BY 1
98 NO MINVALUE
99 NO MAXVALUE
100 CACHE 1;
101
102
103ALTER TABLE gotrue.refresh_tokens_id_seq OWNER TO gotrue;
104
105--
106-- Name: refresh_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: gotrue; Owner: gotrue
107--
108
109ALTER SEQUENCE gotrue.refresh_tokens_id_seq OWNED BY gotrue.refresh_tokens.id;
110
111
112--
113-- Name: schema_migration; Type: TABLE; Schema: gotrue; Owner: gotrue
114--
115
116CREATE TABLE gotrue.schema_migration (
117 version character varying(255) NOT NULL
118);
119
120
121ALTER TABLE gotrue.schema_migration OWNER TO gotrue;
122
123--
124-- Name: users; Type: TABLE; Schema: gotrue; Owner: gotrue
125--
126
127CREATE TABLE gotrue.users (
128 instance_id character varying(255),
129 id character varying(255) NOT NULL,
130 aud character varying(255),
131 role character varying(255),
132 email character varying(255),
133 encrypted_password character varying(255),
134 confirmed_at timestamp with time zone,
135 invited_at timestamp with time zone,
136 confirmation_token character varying(255),
137 confirmation_sent_at timestamp with time zone,
138 recovery_token character varying(255),
139 recovery_sent_at timestamp with time zone,
140 email_change_token character varying(255),
141 email_change character varying(255),
142 email_change_sent_at timestamp with time zone,
143 last_sign_in_at timestamp with time zone,
144 raw_app_meta_data json,
145 raw_user_meta_data json,
146 is_super_admin boolean,
147 created_at timestamp with time zone,
148 updated_at timestamp with time zone
149);
150
151
152ALTER TABLE gotrue.users OWNER TO gotrue;
153
154--
155-- Name: refresh_tokens id; Type: DEFAULT; Schema: gotrue; Owner: gotrue
156--
157
158ALTER TABLE ONLY gotrue.refresh_tokens ALTER COLUMN id SET DEFAULT nextval('gotrue.refresh_tokens_id_seq'::regclass);
159
160
161--
162-- Data for Name: audit_log_entries; Type: TABLE DATA; Schema: gotrue; Owner: gotrue
163--
164
165COPY gotrue.audit_log_entries (instance_id, id, payload, created_at) FROM stdin;
166\.
167
168
169--
170-- Data for Name: instances; Type: TABLE DATA; Schema: gotrue; Owner: gotrue
171--
172
173COPY gotrue.instances (id, uuid, raw_base_config, created_at, updated_at) FROM stdin;
174\.
175
176
177--
178-- Data for Name: refresh_tokens; Type: TABLE DATA; Schema: gotrue; Owner: gotrue
179--
180
181COPY gotrue.refresh_tokens (instance_id, id, token, user_id, revoked, created_at, updated_at) FROM stdin;
182\.
183
184
185--
186-- Data for Name: schema_migration; Type: TABLE DATA; Schema: gotrue; Owner: gotrue
187--
188
189COPY gotrue.schema_migration (version) FROM stdin;
19020171026211738
19120171026211808
19220171026211834
19320180103212743
19420180108183307
19520180119214651
19620180125194653
197\.
198
199
200--
201-- Data for Name: users; Type: TABLE DATA; Schema: gotrue; Owner: gotrue
202--
203
204COPY gotrue.users (instance_id, id, aud, role, email, encrypted_password, confirmed_at, invited_at, confirmation_token, confirmation_sent_at, recovery_token, recovery_sent_at, email_change_token, email_change, email_change_sent_at, last_sign_in_at, raw_app_meta_data, raw_user_meta_data, is_super_admin, created_at, updated_at) FROM stdin;
205\.
206
207
208--
209-- Name: refresh_tokens_id_seq; Type: SEQUENCE SET; Schema: gotrue; Owner: gotrue
210--
211
212SELECT pg_catalog.setval('gotrue.refresh_tokens_id_seq', 1, true);
213
214
215--
216-- Name: audit_log_entries idx_16496_primary; Type: CONSTRAINT; Schema: gotrue; Owner: gotrue
217--
218
219ALTER TABLE ONLY gotrue.audit_log_entries
220 ADD CONSTRAINT idx_16496_primary PRIMARY KEY (id);
221
222
223--
224-- Name: instances idx_16502_primary; Type: CONSTRAINT; Schema: gotrue; Owner: gotrue
225--
226
227ALTER TABLE ONLY gotrue.instances
228 ADD CONSTRAINT idx_16502_primary PRIMARY KEY (id);
229
230
231--
232-- Name: refresh_tokens idx_16510_primary; Type: CONSTRAINT; Schema: gotrue; Owner: gotrue
233--
234
235ALTER TABLE ONLY gotrue.refresh_tokens
236 ADD CONSTRAINT idx_16510_primary PRIMARY KEY (id);
237
238
239--
240-- Name: users idx_16520_primary; Type: CONSTRAINT; Schema: gotrue; Owner: gotrue
241--
242
243ALTER TABLE ONLY gotrue.users
244 ADD CONSTRAINT idx_16520_primary PRIMARY KEY (id);
245
246
247--
248-- Name: idx_16496_audit_logs_instance_id_idx; Type: INDEX; Schema: gotrue; Owner: gotrue
249--
250
251CREATE INDEX idx_16496_audit_logs_instance_id_idx ON gotrue.audit_log_entries USING btree (instance_id);
252
253
254--
255-- Name: idx_16510_refresh_tokens_instance_id_idx; Type: INDEX; Schema: gotrue; Owner: gotrue
256--
257
258CREATE INDEX idx_16510_refresh_tokens_instance_id_idx ON gotrue.refresh_tokens USING btree (instance_id);
259
260
261--
262-- Name: idx_16510_refresh_tokens_instance_id_user_id_idx; Type: INDEX; Schema: gotrue; Owner: gotrue
263--
264
265CREATE INDEX idx_16510_refresh_tokens_instance_id_user_id_idx ON gotrue.refresh_tokens USING btree (instance_id, user_id);
266
267
268--
269-- Name: idx_16510_refresh_tokens_token_idx; Type: INDEX; Schema: gotrue; Owner: gotrue
270--
271
272CREATE INDEX idx_16510_refresh_tokens_token_idx ON gotrue.refresh_tokens USING btree (token);
273
274
275--
276-- Name: idx_16517_version_idx; Type: INDEX; Schema: gotrue; Owner: gotrue
277--
278
279CREATE UNIQUE INDEX idx_16517_version_idx ON gotrue.schema_migration USING btree (version);
280
281
282--
283-- Name: idx_16520_users_instance_id_email_idx; Type: INDEX; Schema: gotrue; Owner: gotrue
284--
285
286CREATE INDEX idx_16520_users_instance_id_email_idx ON gotrue.users USING btree (instance_id, email);
287
288
289--
290-- Name: idx_16520_users_instance_id_idx; Type: INDEX; Schema: gotrue; Owner: gotrue
291--
292
293CREATE INDEX idx_16520_users_instance_id_idx ON gotrue.users USING btree (instance_id);
294
295
296--
297-- PostgreSQL database dump complete
298--