· 9 years ago · Nov 29, 2016, 10:54 PM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.5.5
6-- Dumped by pg_dump version 9.5.5
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET client_encoding = 'UTF8';
11SET standard_conforming_strings = on;
12SET check_function_bodies = false;
13SET client_min_messages = warning;
14SET row_security = off;
15
16--
17-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
18--
19
20CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
21
22
23--
24-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
25--
26
27COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
28
29
30SET search_path = public, pg_catalog;
31
32SET default_tablespace = '';
33
34SET default_with_oids = false;
35
36--
37-- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: kyle
38--
39
40CREATE TABLE ar_internal_metadata (
41 key character varying NOT NULL,
42 value character varying,
43 created_at timestamp without time zone NOT NULL,
44 updated_at timestamp without time zone NOT NULL
45);
46
47
48ALTER TABLE ar_internal_metadata OWNER TO kyle;
49
50--
51-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: kyle
52--
53
54CREATE TABLE schema_migrations (
55 version character varying NOT NULL
56);
57
58
59ALTER TABLE schema_migrations OWNER TO kyle;
60
61--
62-- Name: tokens; Type: TABLE; Schema: public; Owner: kyle
63--
64
65CREATE TABLE tokens (
66 id integer NOT NULL,
67 token_type integer,
68 token character varying,
69 secret character varying,
70 user_id integer,
71 created_at timestamp without time zone NOT NULL,
72 updated_at timestamp without time zone NOT NULL
73);
74
75
76ALTER TABLE tokens OWNER TO kyle;
77
78--
79-- Name: tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: kyle
80--
81
82CREATE SEQUENCE tokens_id_seq
83 START WITH 1
84 INCREMENT BY 1
85 NO MINVALUE
86 NO MAXVALUE
87 CACHE 1;
88
89
90ALTER TABLE tokens_id_seq OWNER TO kyle;
91
92--
93-- Name: tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kyle
94--
95
96ALTER SEQUENCE tokens_id_seq OWNED BY tokens.id;
97
98
99--
100-- Name: users; Type: TABLE; Schema: public; Owner: kyle
101--
102
103CREATE TABLE users (
104 id integer NOT NULL,
105 created_at timestamp without time zone NOT NULL,
106 updated_at timestamp without time zone NOT NULL,
107 uuid character varying,
108 iam_uuid character varying
109);
110
111
112ALTER TABLE users OWNER TO kyle;
113
114--
115-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: kyle
116--
117
118CREATE SEQUENCE users_id_seq
119 START WITH 1
120 INCREMENT BY 1
121 NO MINVALUE
122 NO MAXVALUE
123 CACHE 1;
124
125
126ALTER TABLE users_id_seq OWNER TO kyle;
127
128--
129-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kyle
130--
131
132ALTER SEQUENCE users_id_seq OWNED BY users.id;
133
134
135--
136-- Name: id; Type: DEFAULT; Schema: public; Owner: kyle
137--
138
139ALTER TABLE ONLY tokens ALTER COLUMN id SET DEFAULT nextval('tokens_id_seq'::regclass);
140
141
142--
143-- Name: id; Type: DEFAULT; Schema: public; Owner: kyle
144--
145
146ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
147
148
149--
150-- Data for Name: ar_internal_metadata; Type: TABLE DATA; Schema: public; Owner: kyle
151--
152
153COPY ar_internal_metadata (key, value, created_at, updated_at) FROM stdin;
154environment development 2016-10-10 18:49:21.815583 2016-10-10 18:49:21.815583
155\.
156
157
158--
159-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: kyle
160--
161
162COPY schema_migrations (version) FROM stdin;
16320161010184204
16420161010201117
16520161021015444
16620161021022755
16720161128214011
168\.
169
170
171--
172-- Data for Name: tokens; Type: TABLE DATA; Schema: public; Owner: kyle
173--
174
175COPY tokens (id, token_type, token, secret, user_id, created_at, updated_at) FROM stdin;
17618 0 3d8d441386ee8548e9a23291d34eedd75ede61aabf0161c578cdf8daf80b98ba \N 15 2016-10-21 02:39:13.274044 2016-10-21 02:39:13.274044
17719 1 db8899e9-c68e-476a-925d-601ab6140b10 17b58bd39634a40c8496219ce1daed6e 15 2016-10-21 02:39:14.31285 2016-10-21 02:39:14.31285
17820 0 test1 \N 16 2016-10-26 05:07:16.915477 2016-10-26 05:07:16.915477
17921 0 bullshit \N 17 2016-11-27 22:14:16.845306 2016-11-27 22:14:16.845306
180\.
181
182
183--
184-- Name: tokens_id_seq; Type: SEQUENCE SET; Schema: public; Owner: kyle
185--
186
187SELECT pg_catalog.setval('tokens_id_seq', 21, true);
188
189
190--
191-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: kyle
192--
193
194COPY users (id, created_at, updated_at, uuid, iam_uuid) FROM stdin;
19515 2016-10-21 02:39:13.266464 2016-10-22 03:56:49.005686 63b2cabe-8075-4777-a814-dcc54c54ccb7 \N
19616 2016-10-26 05:07:16.878854 2016-10-26 05:07:16.878854 9476e7b7-d68a-4a64-b07c-827327ffece1 \N
19717 2016-11-27 22:14:16.820618 2016-11-27 22:14:16.820618 8c50d6e9-de35-4c1f-88c9-aa5d66e6ddbe \N
198\.
199
200
201--
202-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: kyle
203--
204
205SELECT pg_catalog.setval('users_id_seq', 17, true);
206
207
208--
209-- Name: ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: kyle
210--
211
212ALTER TABLE ONLY ar_internal_metadata
213 ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);
214
215
216--
217-- Name: schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: kyle
218--
219
220ALTER TABLE ONLY schema_migrations
221 ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);
222
223
224--
225-- Name: tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: kyle
226--
227
228ALTER TABLE ONLY tokens
229 ADD CONSTRAINT tokens_pkey PRIMARY KEY (id);
230
231
232--
233-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: kyle
234--
235
236ALTER TABLE ONLY users
237 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
238
239
240--
241-- Name: public; Type: ACL; Schema: -; Owner: kyle
242--
243
244REVOKE ALL ON SCHEMA public FROM PUBLIC;
245REVOKE ALL ON SCHEMA public FROM kyle;
246GRANT ALL ON SCHEMA public TO kyle;
247GRANT ALL ON SCHEMA public TO PUBLIC;
248
249
250--
251-- PostgreSQL database dump complete
252--