kumSdjws

1--
2-- PostgreSQL database dump
3--
4
5SET statement_timeout = 0;
6SET client_encoding = 'UTF8';
7SET standard_conforming_strings = on;
8SET check_function_bodies = false;
9SET client_min_messages = warning;
10
11--
12-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
13--
14
15CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
16
17
18--
19-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
20--
21
22COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
23
24
25SET search_path = public, pg_catalog;
26
27SET default_tablespace = '';
28
29SET default_with_oids = false;
30
31--
32-- Name: connection_pool; Type: TABLE; Schema: public; Owner: root; Tablespace: 
33--
34
35CREATE TABLE connection_pool (
36    id bigint NOT NULL,
37    created bigint,
38    updated bigint,
39    active boolean DEFAULT true NOT NULL,
40    wallet character varying(255) NOT NULL,
41    name character varying(255) NOT NULL,
42    url character varying(255) NOT NULL,
43    password character varying(255) NOT NULL,
44    crypto_currency_id bigint NOT NULL
45);
46
47
48ALTER TABLE public.connection_pool OWNER TO root;
49
50--
51-- Name: connection_pool_id_seq; Type: SEQUENCE; Schema: public; Owner: root
52--
53
54CREATE SEQUENCE connection_pool_id_seq
55    START WITH 1
56    INCREMENT BY 1
57    NO MINVALUE
58    NO MAXVALUE
59    CACHE 1;
60
61
62ALTER TABLE public.connection_pool_id_seq OWNER TO root;
63
64--
65-- Name: connection_pool_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
66--
67
68ALTER SEQUENCE connection_pool_id_seq OWNED BY connection_pool.id;
69
70
71--
72-- Name: cpu; Type: TABLE; Schema: public; Owner: root; Tablespace: 
73--
74
75CREATE TABLE cpu (
76    id bigint NOT NULL,
77    created bigint NOT NULL,
78    updated bigint NOT NULL,
79    name character varying(255),
80    processor_serial_number character varying(255)
81);
82
83
84ALTER TABLE public.cpu OWNER TO root;
85
86--
87-- Name: cpu_id_seq; Type: SEQUENCE; Schema: public; Owner: root
88--
89
90CREATE SEQUENCE cpu_id_seq
91    START WITH 1
92    INCREMENT BY 1
93    NO MINVALUE
94    NO MAXVALUE
95    CACHE 1;
96
97
98ALTER TABLE public.cpu_id_seq OWNER TO root;
99
100--
101-- Name: cpu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
102--
103
104ALTER SEQUENCE cpu_id_seq OWNED BY cpu.id;
105
106
107--
108-- Name: crypto_currency; Type: TABLE; Schema: public; Owner: root; Tablespace: 
109--
110
111CREATE TABLE crypto_currency (
112    id bigint NOT NULL,
113    created bigint NOT NULL,
114    updated bigint NOT NULL,
115    active boolean NOT NULL,
116    name character varying(255) NOT NULL,
117    abbreviation character varying(255) NOT NULL,
118    algorithm character varying(255) NOT NULL,
119    rate numeric DEFAULT 0
120);
121
122
123ALTER TABLE public.crypto_currency OWNER TO root;
124
125--
126-- Name: crypto_currency_id_seq; Type: SEQUENCE; Schema: public; Owner: root
127--
128
129CREATE SEQUENCE crypto_currency_id_seq
130    START WITH 1
131    INCREMENT BY 1
132    NO MINVALUE
133    NO MAXVALUE
134    CACHE 1;
135
136
137ALTER TABLE public.crypto_currency_id_seq OWNER TO root;
138
139--
140-- Name: crypto_currency_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
141--
142
143ALTER SEQUENCE crypto_currency_id_seq OWNED BY crypto_currency.id;
144
145
146--
147-- Name: databasechangelog; Type: TABLE; Schema: public; Owner: root; Tablespace: 
148--
149
150CREATE TABLE databasechangelog (
151    id character varying(255) NOT NULL,
152    author character varying(255) NOT NULL,
153    filename character varying(255) NOT NULL,
154    dateexecuted timestamp without time zone NOT NULL,
155    orderexecuted integer NOT NULL,
156    exectype character varying(10) NOT NULL,
157    md5sum character varying(35),
158    description character varying(255),
159    comments character varying(255),
160    tag character varying(255),
161    liquibase character varying(20),
162    contexts character varying(255),
163    labels character varying(255),
164    deployment_id character varying(10)
165);
166
167
168ALTER TABLE public.databasechangelog OWNER TO root;
169
170--
171-- Name: databasechangeloglock; Type: TABLE; Schema: public; Owner: root; Tablespace: 
172--
173
174CREATE TABLE databasechangeloglock (
175    id integer NOT NULL,
176    locked boolean NOT NULL,
177    lockgranted timestamp without time zone,
178    lockedby character varying(255)
179);
180
181
182ALTER TABLE public.databasechangeloglock OWNER TO root;
183
184--
185-- Name: gpu; Type: TABLE; Schema: public; Owner: root; Tablespace: 
186--
187
188CREATE TABLE gpu (
189    id bigint NOT NULL,
190    created bigint NOT NULL,
191    updated bigint NOT NULL,
192    name character varying(255),
193    ram_gb character varying(255) NOT NULL,
194    architecture character varying(255) NOT NULL,
195    hardware_id bigint NOT NULL
196);
197
198
199ALTER TABLE public.gpu OWNER TO root;
200
201--
202-- Name: gpu_id_seq; Type: SEQUENCE; Schema: public; Owner: root
203--
204
205CREATE SEQUENCE gpu_id_seq
206    START WITH 1
207    INCREMENT BY 1
208    NO MINVALUE
209    NO MAXVALUE
210    CACHE 1;
211
212
213ALTER TABLE public.gpu_id_seq OWNER TO root;
214
215--
216-- Name: gpu_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
217--
218
219ALTER SEQUENCE gpu_id_seq OWNED BY gpu.id;
220
221
222--
223-- Name: hardware; Type: TABLE; Schema: public; Owner: root; Tablespace: 
224--
225
226CREATE TABLE hardware (
227    id bigint NOT NULL,
228    created bigint NOT NULL,
229    updated bigint NOT NULL,
230    baseboard_serial_number character varying(255),
231    os_type character varying(255) NOT NULL,
232    ram_id bigint NOT NULL,
233    cpu_id bigint NOT NULL
234);
235
236
237ALTER TABLE public.hardware OWNER TO root;
238
239--
240-- Name: hardware_id_seq; Type: SEQUENCE; Schema: public; Owner: root
241--
242
243CREATE SEQUENCE hardware_id_seq
244    START WITH 1
245    INCREMENT BY 1
246    NO MINVALUE
247    NO MAXVALUE
248    CACHE 1;
249
250
251ALTER TABLE public.hardware_id_seq OWNER TO root;
252
253--
254-- Name: hardware_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
255--
256
257ALTER SEQUENCE hardware_id_seq OWNED BY hardware.id;
258
259
260--
261-- Name: miner; Type: TABLE; Schema: public; Owner: root; Tablespace: 
262--
263
264CREATE TABLE miner (
265    id bigint NOT NULL,
266    created bigint,
267    updated bigint,
268    active boolean DEFAULT true NOT NULL,
269    username character varying(255),
270    password character varying(255),
271    miner_type character varying(255) NOT NULL,
272    miner_status character varying(255) NOT NULL,
273    hardware_key character varying(255) NOT NULL,
274    miner_profile_id bigint,
275    hardware_id bigint,
276    miner_country character varying(255),
277    hashrate bigint,
278    balance numeric DEFAULT 0
279);
280
281
282ALTER TABLE public.miner OWNER TO root;
283
284--
285-- Name: miner_id_seq; Type: SEQUENCE; Schema: public; Owner: root
286--
287
288CREATE SEQUENCE miner_id_seq
289    START WITH 1
290    INCREMENT BY 1
291    NO MINVALUE
292    NO MAXVALUE
293    CACHE 1;
294
295
296ALTER TABLE public.miner_id_seq OWNER TO root;
297
298--
299-- Name: miner_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
300--
301
302ALTER SEQUENCE miner_id_seq OWNED BY miner.id;
303
304
305--
306-- Name: miner_profile; Type: TABLE; Schema: public; Owner: root; Tablespace: 
307--
308
309CREATE TABLE miner_profile (
310    id bigint NOT NULL,
311    created bigint NOT NULL,
312    updated bigint NOT NULL,
313    email character varying(255) NOT NULL,
314    name character varying(255),
315    birth_date date,
316    phone character varying(255),
317    country character varying(255)
318);
319
320
321ALTER TABLE public.miner_profile OWNER TO root;
322
323--
324-- Name: miner_profile_id_seq; Type: SEQUENCE; Schema: public; Owner: root
325--
326
327CREATE SEQUENCE miner_profile_id_seq
328    START WITH 1
329    INCREMENT BY 1
330    NO MINVALUE
331    NO MAXVALUE
332    CACHE 1;
333
334
335ALTER TABLE public.miner_profile_id_seq OWNER TO root;
336
337--
338-- Name: miner_profile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
339--
340
341ALTER SEQUENCE miner_profile_id_seq OWNED BY miner_profile.id;
342
343
344--
345-- Name: network_card; Type: TABLE; Schema: public; Owner: root; Tablespace: 
346--
347
348CREATE TABLE network_card (
349    id bigint NOT NULL,
350    created bigint NOT NULL,
351    updated bigint NOT NULL,
352    name character varying(255),
353    mac_address character varying(255) NOT NULL,
354    ip_v4 character varying(255) NOT NULL,
355    ip_v6 character varying(255),
356    hardware_id bigint
357);
358
359
360ALTER TABLE public.network_card OWNER TO root;
361
362--
363-- Name: network_card_id_seq; Type: SEQUENCE; Schema: public; Owner: root
364--
365
366CREATE SEQUENCE network_card_id_seq
367    START WITH 1
368    INCREMENT BY 1
369    NO MINVALUE
370    NO MAXVALUE
371    CACHE 1;
372
373
374ALTER TABLE public.network_card_id_seq OWNER TO root;
375
376--
377-- Name: network_card_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
378--
379
380ALTER SEQUENCE network_card_id_seq OWNED BY network_card.id;
381
382
383--
384-- Name: notification; Type: TABLE; Schema: public; Owner: root; Tablespace: 
385--
386
387CREATE TABLE notification (
388    id bigint NOT NULL,
389    created bigint NOT NULL,
390    updated bigint NOT NULL,
391    title character varying(127) NOT NULL,
392    body character varying(1023) NOT NULL,
393    active boolean NOT NULL,
394    miner_id bigint NOT NULL
395);
396
397
398ALTER TABLE public.notification OWNER TO root;
399
400--
401-- Name: notification_id_seq; Type: SEQUENCE; Schema: public; Owner: root
402--
403
404CREATE SEQUENCE notification_id_seq
405    START WITH 1
406    INCREMENT BY 1
407    NO MINVALUE
408    NO MAXVALUE
409    CACHE 1;
410
411
412ALTER TABLE public.notification_id_seq OWNER TO root;
413
414--
415-- Name: notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
416--
417
418ALTER SEQUENCE notification_id_seq OWNED BY notification.id;
419
420
421--
422-- Name: ram; Type: TABLE; Schema: public; Owner: root; Tablespace: 
423--
424
425CREATE TABLE ram (
426    id bigint NOT NULL,
427    created bigint NOT NULL,
428    updated bigint NOT NULL,
429    total character varying(255)
430);
431
432
433ALTER TABLE public.ram OWNER TO root;
434
435--
436-- Name: ram_id_seq; Type: SEQUENCE; Schema: public; Owner: root
437--
438
439CREATE SEQUENCE ram_id_seq
440    START WITH 1
441    INCREMENT BY 1
442    NO MINVALUE
443    NO MAXVALUE
444    CACHE 1;
445
446
447ALTER TABLE public.ram_id_seq OWNER TO root;
448
449--
450-- Name: ram_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
451--
452
453ALTER SEQUENCE ram_id_seq OWNED BY ram.id;
454
455
456--
457-- Name: rom; Type: TABLE; Schema: public; Owner: root; Tablespace: 
458--
459
460CREATE TABLE rom (
461    id bigint NOT NULL,
462    created bigint NOT NULL,
463    updated bigint NOT NULL,
464    size character varying(255),
465    model character varying(255),
466    name character varying(255),
467    serial character varying(255),
468    hardware_id bigint NOT NULL
469);
470
471
472ALTER TABLE public.rom OWNER TO root;
473
474--
475-- Name: rom_id_seq; Type: SEQUENCE; Schema: public; Owner: root
476--
477
478CREATE SEQUENCE rom_id_seq
479    START WITH 1
480    INCREMENT BY 1
481    NO MINVALUE
482    NO MAXVALUE
483    CACHE 1;
484
485
486ALTER TABLE public.rom_id_seq OWNER TO root;
487
488--
489-- Name: rom_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: root
490--
491
492ALTER SEQUENCE rom_id_seq OWNED BY rom.id;
493
494
495--
496-- Name: id; Type: DEFAULT; Schema: public; Owner: root
497--
498
499ALTER TABLE ONLY connection_pool ALTER COLUMN id SET DEFAULT nextval('connection_pool_id_seq'::regclass);
500
501
502--
503-- Name: id; Type: DEFAULT; Schema: public; Owner: root
504--
505
506ALTER TABLE ONLY cpu ALTER COLUMN id SET DEFAULT nextval('cpu_id_seq'::regclass);
507
508
509--
510-- Name: id; Type: DEFAULT; Schema: public; Owner: root
511--
512
513ALTER TABLE ONLY crypto_currency ALTER COLUMN id SET DEFAULT nextval('crypto_currency_id_seq'::regclass);
514
515
516--
517-- Name: id; Type: DEFAULT; Schema: public; Owner: root
518--
519
520ALTER TABLE ONLY gpu ALTER COLUMN id SET DEFAULT nextval('gpu_id_seq'::regclass);
521
522
523--
524-- Name: id; Type: DEFAULT; Schema: public; Owner: root
525--
526
527ALTER TABLE ONLY hardware ALTER COLUMN id SET DEFAULT nextval('hardware_id_seq'::regclass);
528
529
530--
531-- Name: id; Type: DEFAULT; Schema: public; Owner: root
532--
533
534ALTER TABLE ONLY miner ALTER COLUMN id SET DEFAULT nextval('miner_id_seq'::regclass);
535
536
537--
538-- Name: id; Type: DEFAULT; Schema: public; Owner: root
539--
540
541ALTER TABLE ONLY miner_profile ALTER COLUMN id SET DEFAULT nextval('miner_profile_id_seq'::regclass);
542
543
544--
545-- Name: id; Type: DEFAULT; Schema: public; Owner: root
546--
547
548ALTER TABLE ONLY network_card ALTER COLUMN id SET DEFAULT nextval('network_card_id_seq'::regclass);
549
550
551--
552-- Name: id; Type: DEFAULT; Schema: public; Owner: root
553--
554
555ALTER TABLE ONLY notification ALTER COLUMN id SET DEFAULT nextval('notification_id_seq'::regclass);
556
557
558--
559-- Name: id; Type: DEFAULT; Schema: public; Owner: root
560--
561
562ALTER TABLE ONLY ram ALTER COLUMN id SET DEFAULT nextval('ram_id_seq'::regclass);
563
564
565--
566-- Name: id; Type: DEFAULT; Schema: public; Owner: root
567--
568
569ALTER TABLE ONLY rom ALTER COLUMN id SET DEFAULT nextval('rom_id_seq'::regclass);
570
571
572--
573-- Data for Name: connection_pool; Type: TABLE DATA; Schema: public; Owner: root
574--
575
576INSERT INTO connection_pool (id, created, updated, active, wallet, name, url, password, crypto_currency_id) VALUES (70, 1531048075124, 1531841046911, false, 'sdfsdf', 'QA_test2', 'sdfsdf', 'sdfsdfsd', 5);
577INSERT INTO connection_pool (id, created, updated, active, wallet, name, url, password, crypto_currency_id) VALUES (71, 1531054759619, 1531842191005, true, '4AjGN6U3oHW15bZsYP1yx5URGmJx785GKdwRvV6waB12Eb88zzQYGRPaPDQdUA6LXqSMzyJtYq7iX3SeShChPXGRTVnAGCb', 'XMR_xmrpool', 'stratum+tcp://xmrpool.eu:3333', 'x', 5);
578INSERT INTO connection_pool (id, created, updated, active, wallet, name, url, password, crypto_currency_id) VALUES (68, 1531057956111, 1531840919767, false, '0x13E8a6A781243f559468012532941ad279C67F80', 'ETH_stratumsphere', 'stratum1+tcp://main-eu1.stratum.vip:17895', 'x', 4);
579INSERT INTO connection_pool (id, created, updated, active, wallet, name, url, password, crypto_currency_id) VALUES (84, 1531914527678, 1531928172450, false, 'qwe', 'QA_test3', 'qwe', 'qwewss', 4);
580INSERT INTO connection_pool (id, created, updated, active, wallet, name, url, password, crypto_currency_id) VALUES (67, 1531243927176, 1531940027892, false, 'gaimin_wallet', 'ETH_newpool', 'ethpoolurl', 'x', 4);
581INSERT INTO connection_pool (id, created, updated, active, wallet, name, url, password, crypto_currency_id) VALUES (69, 1531057116955, 1531940031397, true, '0x13E8a6A781243f559468012532941ad279C67F80', 'ETH_ethpooll', 'stratum1+tcp://eu1.ethpool.org:3333', 'x', 4);
582
583
584--
585-- Name: connection_pool_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
586--
587
588SELECT pg_catalog.setval('connection_pool_id_seq', 84, true);
589
590
591--
592-- Data for Name: cpu; Type: TABLE DATA; Schema: public; Owner: root
593--
594
595INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (1, 1530556016240, 1530556016240, 'Intel(R) Core(TM) i7-5500U CPU @ 2.40GHz', 'BFEBFBFF000306D4');
596INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (2, 1530559326363, 1530559326363, 'Intel(R) Core(TM) i7 CPU       Q 740  @ 1.73GHz', 'BFEBFBFF000106E5');
597INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (3, 1530789650101, 1530789650101, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
598INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (4, 1530799371286, 1530799371286, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
599INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (5, 1530923799662, 1530923799662, 'Intel(R) Core(TM) i5-6400 CPU @ 2.70GHz', 'BFEBFBFF000506E3');
600INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (6, 1531076207421, 1531076207421, 'Intel(R) Core(TM) i7-7700K CPU @ 4.20GHz', 'BFEBFBFF000906E9');
601INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (7, 1531155711585, 1531155711585, 'Intel(R) Pentium(R) CPU 2117U @ 1.80GHz', 'BFEBFBFF000306A9');
602INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (8, 1531225960762, 1531225960762, 'Intel(R) Core(TM) i5-7500 CPU @ 3.40GHz', 'BFEBFBFF000906E9');
603INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (9, 1531253338496, 1531253338496, 'Intel(R) Core(TM) i5-6400 CPU @ 2.70GHz', 'BFEBFBFF000506E3');
604INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (10, 1531258094738, 1531258094738, 'Intel(R) Core(TM) i5-4460  CPU @ 3.20GHz', 'BFEBFBFF000306C3');
605INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (11, 1531311386182, 1531311386182, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
606INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (12, 1531393798241, 1531393798241, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
607INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (13, 1531454606599, 1531454606599, 'Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz', 'BFEBFBFF000806E9');
608INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (14, 1531490631562, 1531490631562, 'AMD Ryzen 5 2500U with Radeon Vega Mobile Gfx  ', '178BFBFF00810F10');
609INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (15, 1531494417453, 1531494417453, 'Intel(R) Core(TM) i5-6400 CPU @ 2.70GHz', 'BFEBFBFF000506E3');
610INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (16, 1531507004407, 1531507004407, 'Intel(R) Core(TM) i5-6400 CPU @ 2.70GHz', 'BFEBFBFF000506E3');
611INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (17, 1531842898840, 1531842898840, 'Intel(R) Core(TM) i5-6500 CPU @ 3.20GHz', 'BFEBFBFF000506E3');
612INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (18, 1531997595913, 1531997595913, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
613INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (19, 1531997783079, 1531997783079, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
614INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (21, 1532012458136, 1532012458136, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
615INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (22, 1532012548938, 1532012548938, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
616INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (23, 1532086577569, 1532086577569, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
617INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (24, 1532086639353, 1532086639353, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
618INSERT INTO cpu (id, created, updated, name, processor_serial_number) VALUES (25, 1532087050461, 1532087050461, 'Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz', 'BFEBFBFF000406E3');
619
620
621--
622-- Name: cpu_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
623--
624
625SELECT pg_catalog.setval('cpu_id_seq', 25, true);
626
627
628--
629-- Data for Name: crypto_currency; Type: TABLE DATA; Schema: public; Owner: root
630--
631
632INSERT INTO crypto_currency (id, created, updated, active, name, abbreviation, algorithm, rate) VALUES (4, 1531317343312, 1531940022546, false, 'ETHEREUM', 'ETH', 'EHASH', 489.83);
633INSERT INTO crypto_currency (id, created, updated, active, name, abbreviation, algorithm, rate) VALUES (5, 1531317343312, 1531940022556, true, 'MONERO', 'XMR', 'CRYPTONIGHT', 145.11);
634
635
636--
637-- Name: crypto_currency_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
638--
639
640SELECT pg_catalog.setval('crypto_currency_id_seq', 5, true);
641
642
643--
644-- Data for Name: databasechangelog; Type: TABLE DATA; Schema: public; Owner: root
645--
646
647INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1528288169566', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.192696', 1, 'EXECUTED', '7:dbde369bc0d80d10e32e3443649e5e98', 'createTable tableName=miner_profile', '', NULL, '3.5.4', NULL, NULL, '0534428066');
648INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529158554044', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.260952', 2, 'EXECUTED', '7:25d4680bb769c483d20c3a032fd9077e', 'createTable tableName=ram', '', NULL, '3.5.4', NULL, NULL, '0534428066');
649INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529159085109', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.347498', 3, 'EXECUTED', '7:5c1bae45d6d0fcec106965fca6f4c630', 'createTable tableName=cpu', '', NULL, '3.5.4', NULL, NULL, '0534428066');
650INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1528288212046', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.446983', 4, 'EXECUTED', '7:030b1bb3f750e155039885faa61943c2', 'createTable tableName=hardware', '', NULL, '3.5.4', NULL, NULL, '0534428066');
651INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1528288185807', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.546045', 5, 'EXECUTED', '7:1df64f705b46786dce768d9945bb35d0', 'createTable tableName=network_card', '', NULL, '3.5.4', NULL, NULL, '0534428066');
652INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529158387847', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.641074', 6, 'EXECUTED', '7:9d50306a209e3f3c49046fa64da9d2b7', 'createTable tableName=gpu', '', NULL, '3.5.4', NULL, NULL, '0534428066');
653INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529227500246', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.682411', 7, 'EXECUTED', '7:5a98811aba6de5fd9929ec0750182268', 'createTable tableName=rom', '', NULL, '3.5.4', NULL, NULL, '0534428066');
654INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1528288224993', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.701776', 8, 'EXECUTED', '7:953e4d8a25c633f54185919ca932095e', 'createTable tableName=miner', '', NULL, '3.5.4', NULL, NULL, '0534428066');
655INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529235868964', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.738823', 9, 'EXECUTED', '7:d0a9780f1da4515e26701f28d0f0f927', 'addColumn tableName=miner', '', NULL, '3.5.4', NULL, NULL, '0534428066');
656INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529249041028', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.761645', 10, 'EXECUTED', '7:429a5afb240df52911544a0aa8d0105c', 'createTable tableName=connection_pool', '', NULL, '3.5.4', NULL, NULL, '0534428066');
657INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529314983451', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.772393', 11, 'EXECUTED', '7:bc24c174ed151785e65c229832b3babc', 'createTable tableName=crypto_currency_pool', '', NULL, '3.5.4', NULL, NULL, '0534428066');
658INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529316754016', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.776812', 12, 'EXECUTED', '7:6956502faf815b57cf4ec0f604ec82f9', 'addColumn tableName=miner_profile', '', NULL, '3.5.4', NULL, NULL, '0534428066');
659INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529569727345', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.784718', 13, 'EXECUTED', '7:5392f504494faa03af2f7a347f352e7f', 'dropTable tableName=crypto_currency_pool', '', NULL, '3.5.4', NULL, NULL, '0534428066');
660INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1529570053984', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.795932', 14, 'EXECUTED', '7:335cb5fac1972fc6e43bf63728022030', 'addColumn tableName=connection_pool', '', NULL, '3.5.4', NULL, NULL, '0534428066');
661INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1530523738313', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.805132', 15, 'EXECUTED', '7:86c0342f755e44d52929564f88294836', 'renameColumn newColumnName=os_type, oldColumnName=manufacture, tableName=hardware', '', NULL, '3.5.4', NULL, NULL, '0534428066');
662INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1530524180139', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-02 12:27:08.80868', 16, 'EXECUTED', '7:c24295e5a8217fbf51a5934ef985008c', 'addColumn tableName=miner', '', NULL, '3.5.4', NULL, NULL, '0534428066');
663INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1530612205184', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-03 13:06:23.826728', 17, 'EXECUTED', '7:80eeb9e613a3345db42c3c6ead008c27', 'modifyDataType columnName=hashrate, tableName=miner', '', NULL, '3.5.4', NULL, NULL, '0612382673');
664INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1530714872150', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-05 13:08:19.497059', 18, 'EXECUTED', '7:f467ef7d6fd7bacee356b81d1ac652cb', 'createTable tableName=notification', '', NULL, '3.5.4', NULL, NULL, '0796099302');
665INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1531296969939', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-12 15:08:02.760952', 19, 'EXECUTED', '7:7b2d54c33d37b16e46336124e3a8a204', 'createTable tableName=crypto_currency', '', NULL, '3.5.4', NULL, NULL, '1408082514');
666INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1531317343312', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-12 15:08:02.815736', 20, 'EXECUTED', '7:af5e48045538829cacebb70e77309e6c', 'dropColumn columnName=crypto_currency, tableName=connection_pool', '', NULL, '3.5.4', NULL, NULL, '1408082514');
667INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1531320735148', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-12 15:16:59.632338', 21, 'EXECUTED', '7:fbde2b52caeff3b68b9d22616d9b0b7c', 'addColumn tableName=connection_pool', '', NULL, '3.5.4', NULL, NULL, '1408619549');
668INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1531826437006', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-17 11:58:54.369394', 22, 'EXECUTED', '7:a7feef84aba045c250cdc4af02380828', 'insert tableName=crypto_currency; insert tableName=crypto_currency', '', NULL, '3.5.4', NULL, NULL, '1828734273');
669INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1531852265888', 'rholovakha', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-17 21:34:07.970841', 23, 'EXECUTED', '7:a25e079b3209ea1e8cd4ecccfb3564db', 'addColumn tableName=crypto_currency', '', NULL, '3.5.4', NULL, NULL, '1852448185');
670INSERT INTO databasechangelog (id, author, filename, dateexecuted, orderexecuted, exectype, md5sum, description, comments, tag, liquibase, contexts, labels, deployment_id) VALUES ('1531904496421', 'malyshev', 'classpath:/db/changelog/db.changelog-master.yaml', '2018-07-18 12:02:58.772729', 24, 'EXECUTED', '7:eeda69ebe8046b107f92f4bfb40e437b', 'addColumn tableName=miner', '', NULL, '3.5.4', NULL, NULL, '1904576256');
671
672
673--
674-- Data for Name: databasechangeloglock; Type: TABLE DATA; Schema: public; Owner: root
675--
676
677INSERT INTO databasechangeloglock (id, locked, lockgranted, lockedby) VALUES (1, false, NULL, NULL);
678
679
680--
681-- Data for Name: gpu; Type: TABLE DATA; Schema: public; Owner: root
682--
683
684INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (1, 1530556016319, 1530556016319, 'Intel(R) HD Graphics 5500', '1Gb', 'Intel(R) HD Graphics Family', 1);
685INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (2, 1530559326366, 1530559326366, 'NVIDIA GeForce GTX 460M', '1Gb', 'GeForce GTX 460M', 2);
686INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (3, 1530789650200, 1530789650200, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 3);
687INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (4, 1530799371306, 1530799371306, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 4);
688INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (5, 1530923799719, 1530923799719, 'Intel(R) HD Graphics 530', '1Gb', 'Intel(R) HD Graphics Family', 5);
689INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (6, 1531076207458, 1531076207458, 'NVIDIA GeForce GTX 1070', '3Gb', 'GeForce GTX 1070', 6);
690INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (7, 1531155711626, 1531155711626, 'Intel(R) HD Graphics', '2Gb', 'Intel(R) HD Graphics Family', 7);
691INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (8, 1531225960785, 1531225960785, 'Intel(R) HD Graphics 630', '1Gb', 'Intel(R) HD Graphics Family', 8);
692INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (9, 1531253338538, 1531253338538, 'Intel(R) HD Graphics 530', '1Gb', 'Intel(R) HD Graphics Family', 9);
693INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (10, 1531258094761, 1531258094761, 'NVIDIA GeForce GTX 960', '2Gb', 'GeForce GTX 960', 10);
694INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (11, 1531311386240, 1531311386240, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 11);
695INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (12, 1531393798288, 1531393798288, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 12);
696INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (13, 1531454606993, 1531454606993, 'Intel(R) HD Graphics 620', '1Gb', 'Intel(R) HD Graphics Family', 13);
697INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (14, 1531490631572, 1531490631572, 'AMD Radeon(TM) Vega 8 Mobile Graphics', '0Gb', 'AMD Radeon Graphics Processor (0x15DD)', 14);
698INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (15, 1531494417468, 1531494417468, 'Intel(R) HD Graphics 530', '1Gb', 'Intel(R) HD Graphics Family', 15);
699INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (16, 1531507004455, 1531507004455, 'Intel(R) HD Graphics 530', '1Gb', 'Intel(R) HD Graphics Family', 16);
700INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (17, 1531842898887, 1531842898887, 'NVIDIA GeForce GTX 1060 6GB', '3Gb', 'GeForce GTX 1060 6GB', 17);
701INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (18, 1531997595965, 1531997595965, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 18);
702INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (19, 1531997783085, 1531997783085, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 19);
703INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (21, 1532012458138, 1532012458138, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 21);
704INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (22, 1532012548942, 1532012548942, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 22);
705INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (23, 1532086577592, 1532086577592, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 23);
706INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (24, 1532086639359, 1532086639359, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 24);
707INSERT INTO gpu (id, created, updated, name, ram_gb, architecture, hardware_id) VALUES (25, 1532087050472, 1532087050472, 'Intel(R) HD Graphics 520', '1Gb', 'Intel(R) HD Graphics Family', 25);
708
709
710--
711-- Name: gpu_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
712--
713
714SELECT pg_catalog.setval('gpu_id_seq', 25, true);
715
716
717--
718-- Data for Name: hardware; Type: TABLE DATA; Schema: public; Owner: root
719--
720
721INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (1, 1530556016240, 1530556016240, '/30NZK32/CN129635240446/', 'WINDOWS', 1, 1);
722INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (2, 1530559326363, 1530559326363, 'BSN12345678901234567', 'WINDOWS', 2, 2);
723INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (3, 1530789650101, 1530789650101, '/3465VB2/CN7620665B00A8/', 'WINDOWS', 3, 3);
724INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (4, 1530799371286, 1530799371286, '/DCPBVB2/CN7620665E00EL/', 'WINDOWS', 4, 4);
725INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (5, 1530923799662, 1530923799662, '150749106805802', 'WINDOWS', 5, 5);
726INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (6, 1531076207421, 1531076207421, '161189930902633', 'WINDOWS', 6, 6);
727INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (7, 1531155711585, 1531155711585, 'BSN12345678901234567', 'WINDOWS', 7, 7);
728INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (8, 1531225960761, 1531225960761, '/8759XH2/CN7220071A00R2/', 'WINDOWS', 8, 8);
729INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (9, 1531253338496, 1531253338496, '150749106805802', 'WINDOWS', 9, 9);
730INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (10, 1531258094738, 1531258094738, '131017490501293', 'WINDOWS', 10, 10);
731INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (11, 1531311386181, 1531311386181, '/3GW1ZB2/CN7620667N00LQ/', 'WINDOWS', 11, 11);
732INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (12, 1531393798241, 1531393798241, '/8LPBVB2/CN7620665E00HL/', 'WINDOWS', 12, 12);
733INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (13, 1531454606599, 1531454606599, 'L3HF7BX027J', 'WINDOWS', 13, 13);
734INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (14, 1531490631562, 1531490631562, 'PGVDB0B8JAR23J', 'WINDOWS', 14, 14);
735INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (15, 1531494417453, 1531494417453, '                    ', 'WINDOWS', 15, 15);
736INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (16, 1531507004407, 1531507004407, '                    ', 'WINDOWS', 16, 16);
737INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (17, 1531842898840, 1531842898840, '160881310120745', 'WINDOWS', 17, 17);
738INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (18, 1531997595913, 1531997595913, '/3465VB2/CN7620665B00A8/', 'WINDOWS', 18, 18);
739INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (19, 1531997783079, 1531997783079, '/3465VB2/CN7620665B00A8/', 'WINDOWS', 19, 19);
740INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (21, 1532012458136, 1532012458136, '/3465VB2/CN7620665B00A8/', 'WINDOWS', 21, 21);
741INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (22, 1532012548938, 1532012548938, '/3465VB2/CN7620665B00A8/', 'WINDOWS', 22, 22);
742INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (23, 1532086577569, 1532086577569, '/3465VB2/CN7620665B00A8/', 'WINDOWS', 23, 23);
743INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (24, 1532086639353, 1532086639353, '/3465VB2/CN7620665B00A8/', 'WINDOWS', 24, 24);
744INSERT INTO hardware (id, created, updated, baseboard_serial_number, os_type, ram_id, cpu_id) VALUES (25, 1532087050461, 1532087050461, '/3465VB2/CN7620665B00A8/', 'WINDOWS', 25, 25);
745
746
747--
748-- Name: hardware_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
749--
750
751SELECT pg_catalog.setval('hardware_id_seq', 25, true);
752
753
754--
755-- Data for Name: miner; Type: TABLE DATA; Schema: public; Owner: root
756--
757
758INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (23, 1532086577565, 1532086577565, true, NULL, NULL, 'NEW', 'OFFLINE', 'asads', NULL, 23, 'Country(id=null, name=N/A, isoCode=--, phonePrefix=null, currency=null)', 0, 0);
759INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (5, 1530923799662, 1531041673566, true, NULL, NULL, 'NEW', 'OFFLINE', '150749106805802BFEBFBFF000506E350:5a:3a:09:ba:7a', NULL, 5, NULL, 0, 0);
760INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (7, 1531155711584, 1531155774047, true, NULL, NULL, 'MINER', 'OFFLINE', 'BSN12345678901234567BFEBFBFF000306A924:fd:52:c5:3d:7f', NULL, 7, NULL, 0, 0);
761INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (6, 1531076207420, 1531244095398, true, NULL, 'calvin', 'MINER', 'OFFLINE', '161189930902633BFEBFBFF000906E92c:4d:54:55:35:ac', 3, 6, NULL, 0, 0);
762INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (17, 1531842898840, 1531842915403, true, NULL, NULL, 'MINER', 'OFFLINE', '160881310120745BFEBFBFF000506E300:50:56:c0:00:0800:50:56:c0:00:010a:00:27:00:00:0b38:d5:47:1a:c2:2b', NULL, 17, NULL, 0, 0);
763INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (16, 1531507004387, 1531507018126, true, NULL, NULL, 'MINER', 'OFFLINE', '                    BFEBFBFF000506E300:23:24:c5:65:56', NULL, 16, NULL, 0, 0);
764INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (18, 1531997595910, 1531997719824, true, NULL, NULL, 'NEW', 'OFFLINE', '', NULL, 18, NULL, 0, 0);
765INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (1, 1530789650094, 1531926470701, true, NULL, '', 'NEW', 'OFFLINE', '123', NULL, NULL, NULL, 0, 0);
766INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (19, 1531997783079, 1532000938240, true, NULL, NULL, 'MINER', 'OFFLINE', '645', NULL, 19, NULL, 0, 0);
767INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (10, 1531258094738, 1531258119151, true, NULL, NULL, 'MINER', 'OFFLINE', '131017490501293BFEBFBFF000306C3bc:ee:7b:87:02:8b', NULL, 10, NULL, 0, 0);
768INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (9, 1531253338495, 1531253396672, true, NULL, '12345678', 'MINER', 'OFFLINE', '150749106805802BFEBFBFF000506E330:5a:3a:09:ba:7c', 4, 9, NULL, 0, 0);
769INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (15, 1531494417453, 1531494432596, true, NULL, NULL, 'MINER', 'OFFLINE', '                    BFEBFBFF000506E34c:cc:6a:70:95:d7', NULL, 15, NULL, 0, 0);
770INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (2, 1530559326363, 1530559370348, true, NULL, NULL, 'MINER', 'OFFLINE', 'BSN12345678901234567BFEBFBFF000106E5', NULL, 2, NULL, 0, 0);
771INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (24, 1532086639353, 1532086643970, true, NULL, NULL, 'NEW', 'OFFLINE', 'adldklas', NULL, 24, 'Country(id=null, name=N/A, isoCode=--, phonePrefix=null, currency=null)', 0, 0);
772INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (8, 1531225960761, 1531938376399, true, NULL, '1qaz2wsx', 'NEW', 'OFFLINE', '/8759XH2/CN7220071A00R2/BFEBFBFF000906E948:4d:7e:ef:59:9d', 9, 8, NULL, 0, 0);
773INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (21, 1532012458136, 1532012458136, true, NULL, NULL, 'NEW', 'OFFLINE', '87678643', NULL, 21, 'Ukraine', 0, 0);
774INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (25, 1532087050461, 1532091363834, true, NULL, '', 'MINER', 'OFFLINE', '/3465VB2/CN7620665B00A8/BFEBFBFF000406E300:db:df:e4:d6:53', 10, 25, 'Country(id=null, name=Ukraine, isoCode=UA, phonePrefix=null, currency=null)', 0, 0);
775INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (4, 1530799371271, 1532092407253, true, NULL, '', 'MINER', 'ACTIVE', '/DCPBVB2/CN7620665E00EL/BFEBFBFF000406E300:db:df:f0:d7:91', 8, 4, NULL, 0, 0);
776INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (13, 1531454606511, 1531454622542, true, NULL, NULL, 'MINER', 'OFFLINE', 'L3HF7BX027JBFEBFBFF000806E928:c6:3f:d2:c4:31', NULL, 13, NULL, 0, 0);
777INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (12, 1531393798240, 1531393863864, true, NULL, 'lovdkfjhnk', 'MINER', 'OFFLINE', '/8LPBVB2/CN7620665E00HL/BFEBFBFF000406E300:db:df:f0:6d:24', 5, 12, NULL, 0, 0);
778INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (14, 1531490631562, 1531490647006, true, NULL, NULL, 'MINER', 'OFFLINE', 'PGVDB0B8JAR23J178BFBFF00810F105c:ea:1d:6f:e2:49', NULL, 14, NULL, 0, 0);
779INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (11, 1531311386172, 1532012438852, true, NULL, NULL, 'MINER', 'OFFLINE', '42332423', NULL, 11, NULL, 0, 0);
780INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (20, 1530556016239, 1532013676814, true, NULL, NULL, 'MINER', 'OFFLINE', '/30NZK32/CN129635240446/BFEBFBFF000306D4ac:d1:b8:bf:33:e3', 1, 1, 'America', 0, 0.0000952777243752794);
781INSERT INTO miner (id, created, updated, active, username, password, miner_type, miner_status, hardware_key, miner_profile_id, hardware_id, miner_country, hashrate, balance) VALUES (22, 1532012548938, 1532086426988, true, NULL, NULL, 'MINER', 'OFFLINE', 'asdsda', NULL, 22, 'Ukraine', 0, 0);
782
783
784--
785-- Name: miner_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
786--
787
788SELECT pg_catalog.setval('miner_id_seq', 25, true);
789
790
791--
792-- Data for Name: miner_profile; Type: TABLE DATA; Schema: public; Owner: root
793--
794
795INSERT INTO miner_profile (id, created, updated, email, name, birth_date, phone, country) VALUES (1, 123, 123, 'test@email.com', 'Vasiliy', '2018-07-10', '+38094444444', 'America');
796INSERT INTO miner_profile (id, created, updated, email, name, birth_date, phone, country) VALUES (3, 1531224123522, 1531224123522, 'calvin@gmail.com', 'Calvin', NULL, '', 'Netherlands');
797INSERT INTO miner_profile (id, created, updated, email, name, birth_date, phone, country) VALUES (4, 1531253396668, 1531253396668, 'amirjaber@gmail.com', 'Amir', '1941-02-03', '1231231231231', 'Antarctica');
798INSERT INTO miner_profile (id, created, updated, email, name, birth_date, phone, country) VALUES (5, 1531393863811, 1531393863811, 'vitali@rogmax.com', 'Vitali', '1994-02-03', '234394832947', 'Ukraine');
799INSERT INTO miner_profile (id, created, updated, email, name, birth_date, phone, country) VALUES (6, 1531911603437, 1531911603437, '', '', NULL, '454454654656576', 'Vanuatu');
800INSERT INTO miner_profile (id, created, updated, email, name, birth_date, phone, country) VALUES (7, 1531925319528, 1531925319528, 'fgfdsfdsf54sdf@sada.com', '', NULL, '99900565464454', NULL);
801INSERT INTO miner_profile (id, created, updated, email, name, birth_date, phone, country) VALUES (8, 1531935807949, 1531935807949, 'denys@rogmax.com', 'Denys Pavlogradskyi', '1987-10-02', '380930000959', 'Ukraine');
802INSERT INTO miner_profile (id, created, updated, email, name, birth_date, phone, country) VALUES (9, 1531938376398, 1531938376398, 'buki.b.n@gmail.com', 'Buki Ben Natan', '1969-12-26', '972543060016', 'Israel');
803INSERT INTO miner_profile (id, created, updated, email, name, birth_date, phone, country) VALUES (10, 1532090621954, 1532090621954, 'amir@jaber.com', 'Amirrrrrrrrrrrrrrrrrrrrrr', NULL, '', NULL);
804
805
806--
807-- Name: miner_profile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
808--
809
810SELECT pg_catalog.setval('miner_profile_id_seq', 10, true);
811
812
813--
814-- Data for Name: network_card; Type: TABLE DATA; Schema: public; Owner: root
815--
816
817INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (1, 1530556016322, 1530556016322, 'Dell Wireless 1560 802.11ac', 'ac:d1:b8:bf:33:e3', '192.168.0.103', 'fe80:0:0:0:3c02:3fb:a23:137e', 1);
818INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (23, 1532012458139, 1532012458139, 'Intel(R) Dual Band Wireless-AC 3165', '00:db:df:e4:d6:53', '192.168.31.197', 'fe80:0:0:0:2c2f:bc9a:a044:917e', 21);
819INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (3, 1530799371307, 1530799371307, 'Intel(R) Dual Band Wireless-AC 3165', '00:db:df:f0:d7:91', '192.168.31.207', 'fe80:0:0:0:f8ab:6938:cda0:8c59', 4);
820INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (4, 1530923799740, 1530923799740, 'Realtek PCIe GbE Family Controller', '50:5a:3a:09:ba:7a', '192.168.0.109', 'fe80:0:0:0:a8f0:5bb7:cbff:1b55', 5);
821INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (5, 1531076207463, 1531076207463, 'Intel(R) Ethernet Connection (2) I219-V', '2c:4d:54:55:35:ac', '92.35.77.7', 'fe80:0:0:0:b007:3165:da25:7653', 6);
822INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (6, 1531155711638, 1531155711638, 'Qualcomm Atheros AR9485 Wireless Network Adapter', '24:fd:52:c5:3d:7f', '192.168.10.242', 'fe80:0:0:0:7c2a:78ea:4780:568c', 7);
823INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (7, 1531225960793, 1531225960793, 'Realtek PCIe GBE Family Controller', '48:4d:7e:ef:59:9d', '192.168.1.10', 'fe80:0:0:0:f8de:30b7:8eb:51cd', 8);
824INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (8, 1531253338542, 1531253338542, 'Realtek PCIe GbE Family Controller', '30:5a:3a:09:ba:7c', '192.168.0.110', 'fe80:0:0:0:c:de20:9c2f:688', 9);
825INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (9, 1531258094763, 1531258094763, 'Realtek PCIe GBE Family Controller', 'bc:ee:7b:87:02:8b', '192.168.2.63', 'fe80:0:0:0:1caf:d4fc:b563:132', 10);
826INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (10, 1531311386243, 1531311386243, 'Intel(R) Dual Band Wireless-AC 3165', 'b8:81:98:57:76:dc', '192.168.31.173', 'fe80:0:0:0:6837:c0db:cafd:9bd0', 11);
827INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (11, 1531393798307, 1531393798307, 'Intel(R) Dual Band Wireless-AC 3165', '00:db:df:f0:6d:24', '192.168.31.198', 'fe80:0:0:0:cd31:8e72:f686:e442', 12);
828INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (12, 1531454606995, 1531454606995, 'Intel(R) Dual Band Wireless-AC 8265', '28:c6:3f:d2:c4:31', '192.168.1.16', 'fe80:0:0:0:dcba:8ee4:d9cb:2a1b', 13);
829INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (13, 1531490631574, 1531490631574, 'Realtek RTL8822BE 802.11ac PCIe Adapter', '5c:ea:1d:6f:e2:49', '192.168.1.94', 'fe80:0:0:0:3c3b:15cb:4d04:1133', 14);
830INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (14, 1531494417470, 1531494417470, 'Realtek PCIe GBE Family Controller', '4c:cc:6a:70:95:d7', '192.168.2.238', 'fe80:0:0:0:cde1:7003:329e:e59b', 15);
831INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (15, 1531507004457, 1531507004457, 'Realtek PCIe GBE Family Controller', '00:23:24:c5:65:56', '192.168.2.82', 'fe80:0:0:0:91da:b047:dcab:18e9', 16);
832INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (16, 1531842898901, 1531842898901, 'VirtualBox Host-Only Ethernet Adapter #2', '0a:00:27:00:00:0b', '192.168.56.1', 'fe80:0:0:0:2c59:69cc:e8aa:cc1c', 17);
833INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (17, 1531842898904, 1531842898904, 'VMware Virtual Ethernet Adapter for VMnet8', '00:50:56:c0:00:08', '192.168.119.1', 'fe80:0:0:0:6859:daef:f173:1236', 17);
834INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (18, 1531842898905, 1531842898905, 'Realtek PCIe GBE Family Controller', '38:d5:47:1a:c2:2b', '192.168.0.34', 'fe80:0:0:0:2d9f:89f4:2be9:295b', 17);
835INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (19, 1531842898905, 1531842898905, 'VMware Virtual Ethernet Adapter for VMnet1', '00:50:56:c0:00:01', '192.168.157.1', 'fe80:0:0:0:80ca:8813:db0e:69b6', 17);
836INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (24, 1532012548942, 1532012548942, 'Intel(R) Dual Band Wireless-AC 3165', '00:db:df:e4:d6:53', '192.168.31.197', 'fe80:0:0:0:2c2f:bc9a:a044:917e', 22);
837INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (25, 1532086577593, 1532086577593, 'Intel(R) Dual Band Wireless-AC 3165', '00:db:df:e4:d6:53', '192.168.31.197', 'fe80:0:0:0:2c2f:bc9a:a044:917e', 23);
838INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (26, 1532086639360, 1532086639360, 'Intel(R) Dual Band Wireless-AC 3165', '00:db:df:e4:d6:53', '192.168.31.197', 'fe80:0:0:0:2c2f:bc9a:a044:917e', 24);
839INSERT INTO network_card (id, created, updated, name, mac_address, ip_v4, ip_v6, hardware_id) VALUES (27, 1532087050473, 1532087050473, 'Intel(R) Dual Band Wireless-AC 3165', '00:db:df:e4:d6:53', '192.168.31.197', 'fe80:0:0:0:2c2f:bc9a:a044:917e', 25);
840
841
842--
843-- Name: network_card_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
844--
845
846SELECT pg_catalog.setval('network_card_id_seq', 27, true);
847
848
849--
850-- Data for Name: notification; Type: TABLE DATA; Schema: public; Owner: root
851--
852
853INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (431, 1532007581039, 1532007581039, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
854Please download new version X.Y for using all new features.', true, 5);
855INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (432, 1532007581051, 1532007581051, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
856Please download new version X.Y for using all new features.', true, 4);
857INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (433, 1532007581051, 1532007581051, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
858Please download new version X.Y for using all new features.', true, 2);
859INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (434, 1532007581052, 1532007581052, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
860Please download new version X.Y for using all new features.', true, 7);
861INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (435, 1532007581052, 1532007581052, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
862Please download new version X.Y for using all new features.', true, 6);
863INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (436, 1532007581053, 1532007581053, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
864Please download new version X.Y for using all new features.', true, 17);
865INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (437, 1532007581056, 1532007581056, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
866Please download new version X.Y for using all new features.', true, 16);
867INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (438, 1532007581056, 1532007581056, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
868Please download new version X.Y for using all new features.', true, 1);
869INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (439, 1532007581057, 1532007581057, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
870Please download new version X.Y for using all new features.', true, 18);
871INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (440, 1532007581057, 1532007581057, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
872Please download new version X.Y for using all new features.', true, 20);
873INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (441, 1532007581057, 1532007581057, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
874Please download new version X.Y for using all new features.', true, 9);
875INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (442, 1532007581058, 1532007581058, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
876Please download new version X.Y for using all new features.', true, 19);
877INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (443, 1532007581058, 1532007581058, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
878Please download new version X.Y for using all new features.', true, 8);
879INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (444, 1532007581058, 1532007581058, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
880Please download new version X.Y for using all new features.', true, 10);
881INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (445, 1532007581059, 1532007581059, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
882Please download new version X.Y for using all new features.', true, 13);
883INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (446, 1532007581059, 1532007581059, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
884Please download new version X.Y for using all new features.', true, 12);
885INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (447, 1532007581059, 1532007581059, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
886Please download new version X.Y for using all new features.', true, 11);
887INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (448, 1532007581060, 1532007581060, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
888Please download new version X.Y for using all new features.', true, 15);
889INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (449, 1532007581060, 1532007581060, 'Please Update Your APP Version!', 'Your currently version Gaimin.Miner is X.Y.
890Please download new version X.Y for using all new features.', true, 14);
891INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (354, 1531938126043, 1531938126043, 'Welcome to Gaimin Community!', 'Congratulations!
892
893Now You are a member of Gaimin Community! 
894
895The power of community builds customer loyalty and huge brand awareness.
896We dedicate significant funding to building and giving back to the community.
897Our own marketplace for community members.
898Planned sponsorship of esports team to build community, identity, and prestige.
899Creates powerful social proof.
900Builds massive influence.
901Events, prizes, games, rewards, recognition.', true, 1);
902INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (346, 1531938126040, 1531938126040, 'Welcome to Gaimin Community!', 'Congratulations!
903
904Now You are a member of Gaimin Community! 
905
906The power of community builds customer loyalty and huge brand awareness.
907We dedicate significant funding to building and giving back to the community.
908Our own marketplace for community members.
909Planned sponsorship of esports team to build community, identity, and prestige.
910Creates powerful social proof.
911Builds massive influence.
912Events, prizes, games, rewards, recognition.', true, 6);
913INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (341, 1531938126038, 1531938126038, 'Welcome to Gaimin Community!', 'Congratulations!
914
915Now You are a member of Gaimin Community! 
916
917The power of community builds customer loyalty and huge brand awareness.
918We dedicate significant funding to building and giving back to the community.
919Our own marketplace for community members.
920Planned sponsorship of esports team to build community, identity, and prestige.
921Creates powerful social proof.
922Builds massive influence.
923Events, prizes, games, rewards, recognition.', true, 16);
924INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (351, 1531938126042, 1531938126042, 'Welcome to Gaimin Community!', 'Congratulations!
925
926Now You are a member of Gaimin Community! 
927
928The power of community builds customer loyalty and huge brand awareness.
929We dedicate significant funding to building and giving back to the community.
930Our own marketplace for community members.
931Planned sponsorship of esports team to build community, identity, and prestige.
932Creates powerful social proof.
933Builds massive influence.
934Events, prizes, games, rewards, recognition.', true, 13);
935INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (350, 1531938126042, 1531938126042, 'Welcome to Gaimin Community!', 'Congratulations!
936
937Now You are a member of Gaimin Community! 
938
939The power of community builds customer loyalty and huge brand awareness.
940We dedicate significant funding to building and giving back to the community.
941Our own marketplace for community members.
942Planned sponsorship of esports team to build community, identity, and prestige.
943Creates powerful social proof.
944Builds massive influence.
945Events, prizes, games, rewards, recognition.', true, 5);
946INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (345, 1531938126040, 1531938126040, 'Welcome to Gaimin Community!', 'Congratulations!
947
948Now You are a member of Gaimin Community! 
949
950The power of community builds customer loyalty and huge brand awareness.
951We dedicate significant funding to building and giving back to the community.
952Our own marketplace for community members.
953Planned sponsorship of esports team to build community, identity, and prestige.
954Creates powerful social proof.
955Builds massive influence.
956Events, prizes, games, rewards, recognition.', true, 10);
957INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (349, 1531938126041, 1531938126041, 'Welcome to Gaimin Community!', 'Congratulations!
958
959Now You are a member of Gaimin Community! 
960
961The power of community builds customer loyalty and huge brand awareness.
962We dedicate significant funding to building and giving back to the community.
963Our own marketplace for community members.
964Planned sponsorship of esports team to build community, identity, and prestige.
965Creates powerful social proof.
966Builds massive influence.
967Events, prizes, games, rewards, recognition.', true, 12);
968INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (348, 1531938126041, 1531938126041, 'Welcome to Gaimin Community!', 'Congratulations!
969
970Now You are a member of Gaimin Community! 
971
972The power of community builds customer loyalty and huge brand awareness.
973We dedicate significant funding to building and giving back to the community.
974Our own marketplace for community members.
975Planned sponsorship of esports team to build community, identity, and prestige.
976Creates powerful social proof.
977Builds massive influence.
978Events, prizes, games, rewards, recognition.', true, 20);
979INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (344, 1531938126039, 1531938126039, 'Welcome to Gaimin Community!', 'Congratulations!
980
981Now You are a member of Gaimin Community! 
982
983The power of community builds customer loyalty and huge brand awareness.
984We dedicate significant funding to building and giving back to the community.
985Our own marketplace for community members.
986Planned sponsorship of esports team to build community, identity, and prestige.
987Creates powerful social proof.
988Builds massive influence.
989Events, prizes, games, rewards, recognition.', true, 9);
990INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (347, 1531938126040, 1531938126040, 'Welcome to Gaimin Community!', 'Congratulations!
991
992Now You are a member of Gaimin Community! 
993
994The power of community builds customer loyalty and huge brand awareness.
995We dedicate significant funding to building and giving back to the community.
996Our own marketplace for community members.
997Planned sponsorship of esports team to build community, identity, and prestige.
998Creates powerful social proof.
999Builds massive influence.
1000Events, prizes, games, rewards, recognition.', true, 11);
1001INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (340, 1531938126037, 1531938126037, 'Welcome to Gaimin Community!', 'Congratulations!
1002
1003Now You are a member of Gaimin Community! 
1004
1005The power of community builds customer loyalty and huge brand awareness.
1006We dedicate significant funding to building and giving back to the community.
1007Our own marketplace for community members.
1008Planned sponsorship of esports team to build community, identity, and prestige.
1009Creates powerful social proof.
1010Builds massive influence.
1011Events, prizes, games, rewards, recognition.', true, 15);
1012INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (343, 1531938126039, 1531938126039, 'Welcome to Gaimin Community!', 'Congratulations!
1013
1014Now You are a member of Gaimin Community! 
1015
1016The power of community builds customer loyalty and huge brand awareness.
1017We dedicate significant funding to building and giving back to the community.
1018Our own marketplace for community members.
1019Planned sponsorship of esports team to build community, identity, and prestige.
1020Creates powerful social proof.
1021Builds massive influence.
1022Events, prizes, games, rewards, recognition.', true, 7);
1023INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (342, 1531938126038, 1531938126038, 'Welcome to Gaimin Community!', 'Congratulations!
1024
1025Now You are a member of Gaimin Community! 
1026
1027The power of community builds customer loyalty and huge brand awareness.
1028We dedicate significant funding to building and giving back to the community.
1029Our own marketplace for community members.
1030Planned sponsorship of esports team to build community, identity, and prestige.
1031Creates powerful social proof.
1032Builds massive influence.
1033Events, prizes, games, rewards, recognition.', true, 17);
1034INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (339, 1531938126035, 1531938126035, 'Welcome to Gaimin Community!', 'Congratulations!
1035
1036Now You are a member of Gaimin Community! 
1037
1038The power of community builds customer loyalty and huge brand awareness.
1039We dedicate significant funding to building and giving back to the community.
1040Our own marketplace for community members.
1041Planned sponsorship of esports team to build community, identity, and prestige.
1042Creates powerful social proof.
1043Builds massive influence.
1044Events, prizes, games, rewards, recognition.', true, 8);
1045INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (338, 1531938126033, 1531938126033, 'Welcome to Gaimin Community!', 'Congratulations!
1046
1047Now You are a member of Gaimin Community! 
1048
1049The power of community builds customer loyalty and huge brand awareness.
1050We dedicate significant funding to building and giving back to the community.
1051Our own marketplace for community members.
1052Planned sponsorship of esports team to build community, identity, and prestige.
1053Creates powerful social proof.
1054Builds massive influence.
1055Events, prizes, games, rewards, recognition.', true, 2);
1056INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (353, 1531938126043, 1531938126043, 'Welcome to Gaimin Community!', 'Congratulations!
1057
1058Now You are a member of Gaimin Community! 
1059
1060The power of community builds customer loyalty and huge brand awareness.
1061We dedicate significant funding to building and giving back to the community.
1062Our own marketplace for community members.
1063Planned sponsorship of esports team to build community, identity, and prestige.
1064Creates powerful social proof.
1065Builds massive influence.
1066Events, prizes, games, rewards, recognition.', true, 4);
1067INSERT INTO notification (id, created, updated, title, body, active, miner_id) VALUES (352, 1531938126043, 1531938126043, 'Welcome to Gaimin Community!', 'Congratulations!
1068
1069Now You are a member of Gaimin Community! 
1070
1071The power of community builds customer loyalty and huge brand awareness.
1072We dedicate significant funding to building and giving back to the community.
1073Our own marketplace for community members.
1074Planned sponsorship of esports team to build community, identity, and prestige.
1075Creates powerful social proof.
1076Builds massive influence.
1077Events, prizes, games, rewards, recognition.', true, 14);
1078
1079
1080--
1081-- Name: notification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1082--
1083
1084SELECT pg_catalog.setval('notification_id_seq', 449, true);
1085
1086
1087--
1088-- Data for Name: ram; Type: TABLE DATA; Schema: public; Owner: root
1089--
1090
1091INSERT INTO ram (id, created, updated, total) VALUES (1, 1530556016243, 1530556016243, '7,91 Gb');
1092INSERT INTO ram (id, created, updated, total) VALUES (2, 1530559326364, 1530559326364, '15.93 Gb');
1093INSERT INTO ram (id, created, updated, total) VALUES (3, 1530789650113, 1530789650113, '15.86 Gb');
1094INSERT INTO ram (id, created, updated, total) VALUES (4, 1530799371303, 1530799371303, '15.86 Gb');
1095INSERT INTO ram (id, created, updated, total) VALUES (5, 1530923799685, 1530923799685, '15,89 Gb');
1096INSERT INTO ram (id, created, updated, total) VALUES (6, 1531076207434, 1531076207434, '15.94 Gb');
1097INSERT INTO ram (id, created, updated, total) VALUES (7, 1531155711603, 1531155711603, '11.89 Gb');
1098INSERT INTO ram (id, created, updated, total) VALUES (8, 1531225960771, 1531225960771, '7.73 Gb');
1099INSERT INTO ram (id, created, updated, total) VALUES (9, 1531253338508, 1531253338509, '15.89 Gb');
1100INSERT INTO ram (id, created, updated, total) VALUES (10, 1531258094743, 1531258094743, '7.94 Gb');
1101INSERT INTO ram (id, created, updated, total) VALUES (11, 1531311386225, 1531311386225, '15.86 Gb');
1102INSERT INTO ram (id, created, updated, total) VALUES (12, 1531393798266, 1531393798266, '15.86 Gb');
1103INSERT INTO ram (id, created, updated, total) VALUES (13, 1531454606980, 1531454606980, '15.86 Gb');
1104INSERT INTO ram (id, created, updated, total) VALUES (14, 1531490631565, 1531490631565, '7.65 Gb');
1105INSERT INTO ram (id, created, updated, total) VALUES (15, 1531494417457, 1531494417457, '7.91 Gb');
1106INSERT INTO ram (id, created, updated, total) VALUES (16, 1531507004427, 1531507004427, '7.91 Gb');
1107INSERT INTO ram (id, created, updated, total) VALUES (17, 1531842898852, 1531842898852, '15.94 Gb');
1108INSERT INTO ram (id, created, updated, total) VALUES (18, 1531997595933, 1531997595933, '15.86 Gb');
1109INSERT INTO ram (id, created, updated, total) VALUES (19, 1531997783081, 1531997783081, '15.86 Gb');
1110INSERT INTO ram (id, created, updated, total) VALUES (21, 1532012458136, 1532012458136, '15.86 Gb');
1111INSERT INTO ram (id, created, updated, total) VALUES (22, 1532012548939, 1532012548939, '15.86 Gb');
1112INSERT INTO ram (id, created, updated, total) VALUES (23, 1532086577588, 1532086577588, '15.86 Gb');
1113INSERT INTO ram (id, created, updated, total) VALUES (24, 1532086639355, 1532086639355, '15.86 Gb');
1114INSERT INTO ram (id, created, updated, total) VALUES (25, 1532087050470, 1532087050470, '15.86 Gb');
1115
1116
1117--
1118-- Name: ram_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1119--
1120
1121SELECT pg_catalog.setval('ram_id_seq', 25, true);
1122
1123
1124--
1125-- Data for Name: rom; Type: TABLE DATA; Schema: public; Owner: root
1126--
1127
1128INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (1, 1530556016324, 1530556016324, '238,47 Gb', 'SAMSUNG SSD PM851 M.2 2280 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', 'S1D3NYAF803399', 1);
1129INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (2, 1530559326369, 1530559326369, '465.76 Gb', 'ST9500420AS (Standard disk drives)', '\\.\PHYSICALDRIVE1', '5VJ8PDLY', 2);
1130INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (3, 1530559326370, 1530559326370, '476.94 Gb', 'Samsung SSD 850 PRO 512GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', 'S250NX0H411028R', 2);
1131INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (4, 1530789650205, 1530789650205, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161309400049', 3);
1132INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (5, 1530799371317, 1530799371317, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161317403971', 4);
1133INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (6, 1530923799744, 1530923799744, '931,51 Gb', 'ST1000DM010-2EP102 (Standard disk drives)', '\\.\PHYSICALDRIVE0', 'Z9APQ914', 5);
1134INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (7, 1530923799753, 1530923799753, '931,51 Gb', 'ST1000DM003-1SB10C (Standard disk drives)', '\\.\PHYSICALDRIVE1', 'Z9A0EG41', 5);
1135INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (8, 1530923799754, 1530923799754, '223,57 Gb', 'KINGSTON SA400S37240G (Standard disk drives)', '\\.\PHYSICALDRIVE2', '50026B777804258F', 5);
1136INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (9, 1531076207470, 1531076207470, '465.76 Gb', 'NVMe Samsung SSD 960 SCSI Disk Device (Standard disk drives)', '\\.\PHYSICALDRIVE0', '0025_3851_71B0_954D.', 6);
1137INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (10, 1531155711642, 1531155711642, '698.64 Gb', 'HGST HTS541075A9E680 (Standard disk drives)', '\\.\PHYSICALDRIVE0', 'J81100A9G0XAYH', 7);
1138INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (11, 1531225960800, 1531225960800, '238.47 Gb', 'SanDisk X400 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '170266420956', 8);
1139INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (12, 1531253338544, 1531253338544, '223.57 Gb', 'KINGSTON SA400S37240G (Standard disk drives)', '\\.\PHYSICALDRIVE2', '50026B777804258F', 9);
1140INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (13, 1531253338560, 1531253338560, '931.51 Gb', 'ST1000DM010-2EP102 (Standard disk drives)', '\\.\PHYSICALDRIVE0', 'Z9APQ914', 9);
1141INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (14, 1531253338561, 1531253338561, '931.51 Gb', 'ST1000DM003-1SB10C (Standard disk drives)', '\\.\PHYSICALDRIVE1', 'Z9A0EG41', 9);
1142INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (15, 1531258094780, 1531258094780, '1863.01 Gb', 'ST2000DM001-1ER164 (Standard disk drives)', '\\.\PHYSICALDRIVE0', 'Z4Z2DG7A', 10);
1143INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (16, 1531258094784, 1531258094784, '1862.98 Gb', 'WD Elements 10B8 USB Device (Standard disk drives)', '\\.\PHYSICALDRIVE1', 'WXL1AA5AX3Y2', 10);
1144INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (17, 1531311386245, 1531311386245, '238.47 Gb', 'TOSHIBA THNSNK256GCS8 SATA 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '763S11M0TQFV', 11);
1145INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (18, 1531393798317, 1531393798317, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161312403013', 12);
1146INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (19, 1531454606999, 1531454606999, '953.86 Gb', 'SAMSUNG MZVLB1T0HALR-000L7 (Standard disk drives)', '\\.\PHYSICALDRIVE0', '0025_388B_7101_0A39.', 13);
1147INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (20, 1531490631575, 1531490631575, '931.51 Gb', 'TOSHIBA DT01ACA100 (Standard disk drives)', '\\.\PHYSICALDRIVE0', '48BVY3PNS', 14);
1148INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (21, 1531490631575, 1531490631575, '119.24 Gb', 'SK hynix BC501 HFM128GDJTNG-8310A (Standard disk drives)', '\\.\PHYSICALDRIVE1', 'ACE4_2E81_700C_E24A.', 14);
1149INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (22, 1531494417471, 1531494417471, '931.51 Gb', 'WDC WD10EZEX-08WN4A0 (Standard disk drives)', '\\.\PHYSICALDRIVE0', 'WD-WCC6Y5HK8T0E', 15);
1150INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (23, 1531494417472, 1531494417472, '1862.98 Gb', 'WD Elements 10B8 USB Device (Standard disk drives)', '\\.\PHYSICALDRIVE1', 'WXL1AA5AX3Y2', 15);
1151INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (24, 1531507004459, 1531507004459, '931.51 Gb', 'WDC WD10EZEX-08WN4A0 (Standard disk drives)', '\\.\PHYSICALDRIVE0', 'WD-WCC6Y4PPHL2N', 16);
1152INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (25, 1531842898911, 1531842898911, '28.83 Gb', 'Kingston DataTraveler 2.0 USB Device (Стандартные дисковые накопители)', '\\.\PHYSICALDRIVE1', '1BC164F16D59', 17);
1153INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (26, 1531842898914, 1531842898914, '465.76 Gb', 'Samsung SSD 850 EVO 500GB (Стандартные дисковые накопители)', '\\.\PHYSICALDRIVE0', 'S2R9NX0HA24043P', 17);
1154INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (27, 1531997595993, 1531997595993, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161309400049', 18);
1155INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (28, 1531997783087, 1531997783087, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161309400049', 19);
1156INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (30, 1532012458140, 1532012458140, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161309400049', 21);
1157INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (31, 1532012548943, 1532012548943, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161309400049', 22);
1158INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (32, 1532086577594, 1532086577594, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161309400049', 23);
1159INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (33, 1532086639361, 1532086639361, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161309400049', 24);
1160INSERT INTO rom (id, created, updated, size, model, name, serial, hardware_id) VALUES (34, 1532087050474, 1532087050474, '238.47 Gb', 'SanDisk Z400s 2.5 7MM 256GB (Standard disk drives)', '\\.\PHYSICALDRIVE0', '161309400049', 25);
1161
1162
1163--
1164-- Name: rom_id_seq; Type: SEQUENCE SET; Schema: public; Owner: root
1165--
1166
1167SELECT pg_catalog.setval('rom_id_seq', 34, true);
1168
1169
1170--
1171-- Name: crypto_currency_name_key; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1172--
1173
1174ALTER TABLE ONLY crypto_currency
1175    ADD CONSTRAINT crypto_currency_name_key UNIQUE (name);
1176
1177
1178--
1179-- Name: miner_hardware_key_key; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1180--
1181
1182ALTER TABLE ONLY miner
1183    ADD CONSTRAINT miner_hardware_key_key UNIQUE (hardware_key);
1184
1185
1186--
1187-- Name: pk_connection_pool; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1188--
1189
1190ALTER TABLE ONLY connection_pool
1191    ADD CONSTRAINT pk_connection_pool PRIMARY KEY (id);
1192
1193
1194--
1195-- Name: pk_cpu; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1196--
1197
1198ALTER TABLE ONLY cpu
1199    ADD CONSTRAINT pk_cpu PRIMARY KEY (id);
1200
1201
1202--
1203-- Name: pk_crypto_currency; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1204--
1205
1206ALTER TABLE ONLY crypto_currency
1207    ADD CONSTRAINT pk_crypto_currency PRIMARY KEY (id);
1208
1209
1210--
1211-- Name: pk_databasechangeloglock; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1212--
1213
1214ALTER TABLE ONLY databasechangeloglock
1215    ADD CONSTRAINT pk_databasechangeloglock PRIMARY KEY (id);
1216
1217
1218--
1219-- Name: pk_gpu; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1220--
1221
1222ALTER TABLE ONLY gpu
1223    ADD CONSTRAINT pk_gpu PRIMARY KEY (id);
1224
1225
1226--
1227-- Name: pk_hardware; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1228--
1229
1230ALTER TABLE ONLY hardware
1231    ADD CONSTRAINT pk_hardware PRIMARY KEY (id);
1232
1233
1234--
1235-- Name: pk_miner; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1236--
1237
1238ALTER TABLE ONLY miner
1239    ADD CONSTRAINT pk_miner PRIMARY KEY (id);
1240
1241
1242--
1243-- Name: pk_miner_profile; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1244--
1245
1246ALTER TABLE ONLY miner_profile
1247    ADD CONSTRAINT pk_miner_profile PRIMARY KEY (id);
1248
1249
1250--
1251-- Name: pk_network_card; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1252--
1253
1254ALTER TABLE ONLY network_card
1255    ADD CONSTRAINT pk_network_card PRIMARY KEY (id);
1256
1257
1258--
1259-- Name: pk_notification; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1260--
1261
1262ALTER TABLE ONLY notification
1263    ADD CONSTRAINT pk_notification PRIMARY KEY (id);
1264
1265
1266--
1267-- Name: pk_ram; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1268--
1269
1270ALTER TABLE ONLY ram
1271    ADD CONSTRAINT pk_ram PRIMARY KEY (id);
1272
1273
1274--
1275-- Name: pk_rom; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace: 
1276--
1277
1278ALTER TABLE ONLY rom
1279    ADD CONSTRAINT pk_rom PRIMARY KEY (id);
1280
1281
1282--
1283-- Name: fk__miner_notification; Type: FK CONSTRAINT; Schema: public; Owner: root
1284--
1285
1286ALTER TABLE ONLY notification
1287    ADD CONSTRAINT fk__miner_notification FOREIGN KEY (miner_id) REFERENCES miner(id);
1288
1289
1290--
1291-- Name: fk_cpu_pc; Type: FK CONSTRAINT; Schema: public; Owner: root
1292--
1293
1294ALTER TABLE ONLY hardware
1295    ADD CONSTRAINT fk_cpu_pc FOREIGN KEY (cpu_id) REFERENCES cpu(id);
1296
1297
1298--
1299-- Name: fk_miner_miner_profile; Type: FK CONSTRAINT; Schema: public; Owner: root
1300--
1301
1302ALTER TABLE ONLY miner
1303    ADD CONSTRAINT fk_miner_miner_profile FOREIGN KEY (miner_profile_id) REFERENCES miner_profile(id);
1304
1305
1306--
1307-- Name: fk_miner_pc; Type: FK CONSTRAINT; Schema: public; Owner: root
1308--
1309
1310ALTER TABLE ONLY miner
1311    ADD CONSTRAINT fk_miner_pc FOREIGN KEY (hardware_id) REFERENCES hardware(id);
1312
1313
1314--
1315-- Name: fk_pc_info_user_network; Type: FK CONSTRAINT; Schema: public; Owner: root
1316--
1317
1318ALTER TABLE ONLY gpu
1319    ADD CONSTRAINT fk_pc_info_user_network FOREIGN KEY (hardware_id) REFERENCES hardware(id);
1320
1321
1322--
1323-- Name: fk_pc_network_card; Type: FK CONSTRAINT; Schema: public; Owner: root
1324--
1325
1326ALTER TABLE ONLY network_card
1327    ADD CONSTRAINT fk_pc_network_card FOREIGN KEY (hardware_id) REFERENCES hardware(id);
1328
1329
1330--
1331-- Name: fk_pc_rom; Type: FK CONSTRAINT; Schema: public; Owner: root
1332--
1333
1334ALTER TABLE ONLY rom
1335    ADD CONSTRAINT fk_pc_rom FOREIGN KEY (hardware_id) REFERENCES hardware(id);
1336
1337
1338--
1339-- Name: fk_pool_crypto_currency; Type: FK CONSTRAINT; Schema: public; Owner: root
1340--
1341
1342ALTER TABLE ONLY connection_pool
1343    ADD CONSTRAINT fk_pool_crypto_currency FOREIGN KEY (crypto_currency_id) REFERENCES crypto_currency(id);
1344
1345
1346--
1347-- Name: fk_ram_pc; Type: FK CONSTRAINT; Schema: public; Owner: root
1348--
1349
1350ALTER TABLE ONLY hardware
1351    ADD CONSTRAINT fk_ram_pc FOREIGN KEY (ram_id) REFERENCES ram(id);
1352
1353
1354--
1355-- Name: public; Type: ACL; Schema: -; Owner: postgres
1356--
1357
1358REVOKE ALL ON SCHEMA public FROM PUBLIC;
1359REVOKE ALL ON SCHEMA public FROM postgres;
1360GRANT ALL ON SCHEMA public TO postgres;
1361GRANT ALL ON SCHEMA public TO PUBLIC;
1362
1363
1364--
1365-- PostgreSQL database dump complete
1366--