· 8 years ago · Dec 15, 2017, 06:34 PM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.5
6-- Dumped by pg_dump version 9.6.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;
13SET check_function_bodies = false;
14SET client_min_messages = warning;
15SET row_security = off;
16
17--
18-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
19--
20
21CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
22
23
24--
25-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
26--
27
28COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
29
30
31SET search_path = public, pg_catalog;
32
33SET default_tablespace = '';
34
35SET default_with_oids = false;
36
37--
38-- Name: SequelizeMeta; Type: TABLE; Schema: public; Owner: coinberg
39--
40
41CREATE TABLE "SequelizeMeta" (
42 name character varying(255) NOT NULL
43);
44
45
46ALTER TABLE "SequelizeMeta" OWNER TO coinberg;
47
48--
49-- Name: asset_tags; Type: TABLE; Schema: public; Owner: coinberg
50--
51
52CREATE TABLE asset_tags (
53 id integer NOT NULL,
54 "assetId" character varying(255) NOT NULL,
55 "tagId" integer NOT NULL,
56 "createdAt" timestamp with time zone NOT NULL,
57 "updatedAt" timestamp with time zone NOT NULL
58);
59
60
61ALTER TABLE asset_tags OWNER TO coinberg;
62
63--
64-- Name: asset_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: coinberg
65--
66
67CREATE SEQUENCE asset_tags_id_seq
68 START WITH 1
69 INCREMENT BY 1
70 NO MINVALUE
71 NO MAXVALUE
72 CACHE 1;
73
74
75ALTER TABLE asset_tags_id_seq OWNER TO coinberg;
76
77--
78-- Name: asset_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: coinberg
79--
80
81ALTER SEQUENCE asset_tags_id_seq OWNED BY asset_tags.id;
82
83
84--
85-- Name: assets; Type: TABLE; Schema: public; Owner: coinberg
86--
87
88CREATE TABLE assets (
89 id character varying(255) NOT NULL,
90 name character varying(255) NOT NULL,
91 symbol character varying(255) NOT NULL,
92 rank integer,
93 synced boolean,
94 "isClone" boolean,
95 "parentCloneId" character varying(255),
96 "isAsset" boolean,
97 "parentAssetId" character varying(255),
98 "isProxy" boolean,
99 "hasGithub" boolean,
100 github character varying(255),
101 "hasTelegram" boolean,
102 telegram character varying(255),
103 "isMaintained" boolean,
104 "idCmc" character varying(255),
105 "createdAt" timestamp with time zone NOT NULL,
106 "updatedAt" timestamp with time zone NOT NULL,
107 description character varying(255),
108 "hasReddit" boolean,
109 reddit character varying(255)
110);
111
112
113ALTER TABLE assets OWNER TO coinberg;
114
115--
116-- Name: news; Type: TABLE; Schema: public; Owner: coinberg
117--
118
119CREATE TABLE news (
120 id integer NOT NULL,
121 "assetId" character varying(255) NOT NULL,
122 source character varying(255) NOT NULL,
123 date timestamp with time zone NOT NULL,
124 data json NOT NULL,
125 type character varying(255),
126 "createdAt" timestamp with time zone NOT NULL,
127 "updatedAt" timestamp with time zone NOT NULL,
128 "externalId" character varying(255)
129);
130
131
132ALTER TABLE news OWNER TO coinberg;
133
134--
135-- Name: news_id_seq; Type: SEQUENCE; Schema: public; Owner: coinberg
136--
137
138CREATE SEQUENCE news_id_seq
139 START WITH 1
140 INCREMENT BY 1
141 NO MINVALUE
142 NO MAXVALUE
143 CACHE 1;
144
145
146ALTER TABLE news_id_seq OWNER TO coinberg;
147
148--
149-- Name: news_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: coinberg
150--
151
152ALTER SEQUENCE news_id_seq OWNED BY news.id;
153
154
155--
156-- Name: tags; Type: TABLE; Schema: public; Owner: coinberg
157--
158
159CREATE TABLE tags (
160 id integer NOT NULL,
161 name character varying(255) NOT NULL,
162 "createdAt" timestamp with time zone NOT NULL,
163 "updatedAt" timestamp with time zone NOT NULL
164);
165
166
167ALTER TABLE tags OWNER TO coinberg;
168
169--
170-- Name: tags_id_seq; Type: SEQUENCE; Schema: public; Owner: coinberg
171--
172
173CREATE SEQUENCE tags_id_seq
174 START WITH 1
175 INCREMENT BY 1
176 NO MINVALUE
177 NO MAXVALUE
178 CACHE 1;
179
180
181ALTER TABLE tags_id_seq OWNER TO coinberg;
182
183--
184-- Name: tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: coinberg
185--
186
187ALTER SEQUENCE tags_id_seq OWNED BY tags.id;
188
189
190--
191-- Name: timeseries; Type: TABLE; Schema: public; Owner: coinberg
192--
193
194CREATE TABLE timeseries (
195 id integer NOT NULL,
196 "assetId" character varying(255) NOT NULL,
197 date timestamp with time zone NOT NULL,
198 mcap double precision,
199 btc double precision,
200 vol double precision,
201 "createdAt" timestamp with time zone NOT NULL,
202 "updatedAt" timestamp with time zone NOT NULL
203);
204
205
206ALTER TABLE timeseries OWNER TO coinberg;
207
208--
209-- Name: timeseries_id_seq; Type: SEQUENCE; Schema: public; Owner: coinberg
210--
211
212CREATE SEQUENCE timeseries_id_seq
213 START WITH 1
214 INCREMENT BY 1
215 NO MINVALUE
216 NO MAXVALUE
217 CACHE 1;
218
219
220ALTER TABLE timeseries_id_seq OWNER TO coinberg;
221
222--
223-- Name: timeseries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: coinberg
224--
225
226ALTER SEQUENCE timeseries_id_seq OWNED BY timeseries.id;
227
228
229--
230-- Name: asset_tags id; Type: DEFAULT; Schema: public; Owner: coinberg
231--
232
233ALTER TABLE ONLY asset_tags ALTER COLUMN id SET DEFAULT nextval('asset_tags_id_seq'::regclass);
234
235
236--
237-- Name: news id; Type: DEFAULT; Schema: public; Owner: coinberg
238--
239
240ALTER TABLE ONLY news ALTER COLUMN id SET DEFAULT nextval('news_id_seq'::regclass);
241
242
243--
244-- Name: tags id; Type: DEFAULT; Schema: public; Owner: coinberg
245--
246
247ALTER TABLE ONLY tags ALTER COLUMN id SET DEFAULT nextval('tags_id_seq'::regclass);
248
249
250--
251-- Name: timeseries id; Type: DEFAULT; Schema: public; Owner: coinberg
252--
253
254ALTER TABLE ONLY timeseries ALTER COLUMN id SET DEFAULT nextval('timeseries_id_seq'::regclass);
255
256
257--
258-- Name: SequelizeMeta SequelizeMeta_pkey; Type: CONSTRAINT; Schema: public; Owner: coinberg
259--
260
261ALTER TABLE ONLY "SequelizeMeta"
262 ADD CONSTRAINT "SequelizeMeta_pkey" PRIMARY KEY (name);
263
264
265--
266-- Name: asset_tags asset_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: coinberg
267--
268
269ALTER TABLE ONLY asset_tags
270 ADD CONSTRAINT asset_tags_pkey PRIMARY KEY (id);
271
272
273--
274-- Name: assets assets_pkey; Type: CONSTRAINT; Schema: public; Owner: coinberg
275--
276
277ALTER TABLE ONLY assets
278 ADD CONSTRAINT assets_pkey PRIMARY KEY (id);
279
280
281--
282-- Name: news news_externalId_key; Type: CONSTRAINT; Schema: public; Owner: coinberg
283--
284
285ALTER TABLE ONLY news
286 ADD CONSTRAINT "news_externalId_key" UNIQUE ("externalId");
287
288
289--
290-- Name: news news_pkey; Type: CONSTRAINT; Schema: public; Owner: coinberg
291--
292
293ALTER TABLE ONLY news
294 ADD CONSTRAINT news_pkey PRIMARY KEY (id);
295
296
297--
298-- Name: tags tags_pkey; Type: CONSTRAINT; Schema: public; Owner: coinberg
299--
300
301ALTER TABLE ONLY tags
302 ADD CONSTRAINT tags_pkey PRIMARY KEY (id);
303
304
305--
306-- Name: timeseries timeseries_pkey; Type: CONSTRAINT; Schema: public; Owner: coinberg
307--
308
309ALTER TABLE ONLY timeseries
310 ADD CONSTRAINT timeseries_pkey PRIMARY KEY (id);
311
312
313--
314-- Name: asset_tags asset_tags_assetId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: coinberg
315--
316
317ALTER TABLE ONLY asset_tags
318 ADD CONSTRAINT "asset_tags_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES assets(id) DEFERRABLE;
319
320
321--
322-- Name: asset_tags asset_tags_tagId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: coinberg
323--
324
325ALTER TABLE ONLY asset_tags
326 ADD CONSTRAINT "asset_tags_tagId_fkey" FOREIGN KEY ("tagId") REFERENCES tags(id) DEFERRABLE;
327
328
329--
330-- Name: assets assets_parentAssetId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: coinberg
331--
332
333ALTER TABLE ONLY assets
334 ADD CONSTRAINT "assets_parentAssetId_fkey" FOREIGN KEY ("parentAssetId") REFERENCES assets(id) DEFERRABLE;
335
336
337--
338-- Name: assets assets_parentCloneId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: coinberg
339--
340
341ALTER TABLE ONLY assets
342 ADD CONSTRAINT "assets_parentCloneId_fkey" FOREIGN KEY ("parentCloneId") REFERENCES assets(id) DEFERRABLE;
343
344
345--
346-- Name: news news_assetId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: coinberg
347--
348
349ALTER TABLE ONLY news
350 ADD CONSTRAINT "news_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES assets(id) DEFERRABLE;
351
352
353--
354-- Name: timeseries timeseries_assetId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: coinberg
355--
356
357ALTER TABLE ONLY timeseries
358 ADD CONSTRAINT "timeseries_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES assets(id) DEFERRABLE;
359
360
361--
362-- PostgreSQL database dump complete
363--