· 8 years ago · Jun 26, 2018, 08:00 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.5.12
6-- Dumped by pg_dump version 10.3
7
8-- Started on 2018-06-18 23:50:47 CEST
9
10SET statement_timeout = 0;
11SET lock_timeout = 0;
12SET idle_in_transaction_session_timeout = 0;
13SET client_encoding = 'UTF8';
14SET standard_conforming_strings = on;
15SELECT pg_catalog.set_config('search_path', '', false);
16SET check_function_bodies = false;
17SET client_min_messages = warning;
18SET row_security = off;
19
20--
21-- TOC entry 1 (class 3079 OID 12361)
22-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
23--
24
25CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
26
27
28--
29-- TOC entry 2299 (class 0 OID 0)
30-- Dependencies: 1
31-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
32--
33
34COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
35
36
37SET default_tablespace = '';
38
39SET default_with_oids = false;
40
41--
42-- TOC entry 182 (class 1259 OID 40802)
43-- Name: comment; Type: TABLE; Schema: public; Owner: server
44--
45
46CREATE TABLE public.comment (
47 content text,
48 "postedBy" text,
49 "repliesTo" integer,
50 "belongsTo" integer,
51 "numberReports" integer,
52 "numberVotes" integer,
53 id integer NOT NULL,
54 "createdAt" timestamp with time zone,
55 "updatedAt" timestamp with time zone
56);
57
58
59ALTER TABLE public.comment OWNER TO server;
60
61--
62-- TOC entry 181 (class 1259 OID 40800)
63-- Name: comment_id_seq; Type: SEQUENCE; Schema: public; Owner: server
64--
65
66CREATE SEQUENCE public.comment_id_seq
67 START WITH 1
68 INCREMENT BY 1
69 NO MINVALUE
70 NO MAXVALUE
71 CACHE 1;
72
73
74ALTER TABLE public.comment_id_seq OWNER TO server;
75
76--
77-- TOC entry 2300 (class 0 OID 0)
78-- Dependencies: 181
79-- Name: comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
80--
81
82ALTER SEQUENCE public.comment_id_seq OWNED BY public.comment.id;
83
84
85--
86-- TOC entry 202 (class 1259 OID 40919)
87-- Name: comment_reportedby__user_reportedcomments; Type: TABLE; Schema: public; Owner: server
88--
89
90CREATE TABLE public.comment_reportedby__user_reportedcomments (
91 id integer NOT NULL,
92 "comment_reportedBy" integer,
93 "user_reportedComments" text
94);
95
96
97ALTER TABLE public.comment_reportedby__user_reportedcomments OWNER TO server;
98
99--
100-- TOC entry 201 (class 1259 OID 40917)
101-- Name: comment_reportedby__user_reportedcomments_id_seq; Type: SEQUENCE; Schema: public; Owner: server
102--
103
104CREATE SEQUENCE public.comment_reportedby__user_reportedcomments_id_seq
105 START WITH 1
106 INCREMENT BY 1
107 NO MINVALUE
108 NO MAXVALUE
109 CACHE 1;
110
111
112ALTER TABLE public.comment_reportedby__user_reportedcomments_id_seq OWNER TO server;
113
114--
115-- TOC entry 2301 (class 0 OID 0)
116-- Dependencies: 201
117-- Name: comment_reportedby__user_reportedcomments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
118--
119
120ALTER SEQUENCE public.comment_reportedby__user_reportedcomments_id_seq OWNED BY public.comment_reportedby__user_reportedcomments.id;
121
122
123--
124-- TOC entry 204 (class 1259 OID 40930)
125-- Name: comment_votedby__user_votedcomments; Type: TABLE; Schema: public; Owner: server
126--
127
128CREATE TABLE public.comment_votedby__user_votedcomments (
129 id integer NOT NULL,
130 "comment_votedBy" integer,
131 "user_votedComments" text
132);
133
134
135ALTER TABLE public.comment_votedby__user_votedcomments OWNER TO server;
136
137--
138-- TOC entry 203 (class 1259 OID 40928)
139-- Name: comment_votedby__user_votedcomments_id_seq; Type: SEQUENCE; Schema: public; Owner: server
140--
141
142CREATE SEQUENCE public.comment_votedby__user_votedcomments_id_seq
143 START WITH 1
144 INCREMENT BY 1
145 NO MINVALUE
146 NO MAXVALUE
147 CACHE 1;
148
149
150ALTER TABLE public.comment_votedby__user_votedcomments_id_seq OWNER TO server;
151
152--
153-- TOC entry 2302 (class 0 OID 0)
154-- Dependencies: 203
155-- Name: comment_votedby__user_votedcomments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
156--
157
158ALTER SEQUENCE public.comment_votedby__user_votedcomments_id_seq OWNED BY public.comment_votedby__user_votedcomments.id;
159
160
161--
162-- TOC entry 184 (class 1259 OID 40813)
163-- Name: conversation; Type: TABLE; Schema: public; Owner: server
164--
165
166CREATE TABLE public.conversation (
167 user1 text,
168 user2 text,
169 "newMessage1" boolean,
170 "newMessage2" boolean,
171 "lastMessageTime" timestamp with time zone,
172 "lastMessageContent" text,
173 "blockedByUser1" boolean,
174 "blockedByUser2" boolean,
175 id integer NOT NULL,
176 "createdAt" timestamp with time zone,
177 "updatedAt" timestamp with time zone
178);
179
180
181ALTER TABLE public.conversation OWNER TO server;
182
183--
184-- TOC entry 183 (class 1259 OID 40811)
185-- Name: conversation_id_seq; Type: SEQUENCE; Schema: public; Owner: server
186--
187
188CREATE SEQUENCE public.conversation_id_seq
189 START WITH 1
190 INCREMENT BY 1
191 NO MINVALUE
192 NO MAXVALUE
193 CACHE 1;
194
195
196ALTER TABLE public.conversation_id_seq OWNER TO server;
197
198--
199-- TOC entry 2303 (class 0 OID 0)
200-- Dependencies: 183
201-- Name: conversation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
202--
203
204ALTER SEQUENCE public.conversation_id_seq OWNED BY public.conversation.id;
205
206
207--
208-- TOC entry 185 (class 1259 OID 40822)
209-- Name: currency; Type: TABLE; Schema: public; Owner: server
210--
211
212CREATE TABLE public.currency (
213 name text NOT NULL,
214 "rateToEur" text,
215 "createdAt" timestamp with time zone,
216 "updatedAt" timestamp with time zone
217);
218
219
220ALTER TABLE public.currency OWNER TO server;
221
222--
223-- TOC entry 187 (class 1259 OID 40832)
224-- Name: faq; Type: TABLE; Schema: public; Owner: server
225--
226
227CREATE TABLE public.faq (
228 question text,
229 answer text,
230 category text,
231 puntuation real,
232 "numberReports" integer,
233 id integer NOT NULL,
234 "createdAt" timestamp with time zone,
235 "updatedAt" timestamp with time zone
236);
237
238
239ALTER TABLE public.faq OWNER TO server;
240
241--
242-- TOC entry 186 (class 1259 OID 40830)
243-- Name: faq_id_seq; Type: SEQUENCE; Schema: public; Owner: server
244--
245
246CREATE SEQUENCE public.faq_id_seq
247 START WITH 1
248 INCREMENT BY 1
249 NO MINVALUE
250 NO MAXVALUE
251 CACHE 1;
252
253
254ALTER TABLE public.faq_id_seq OWNER TO server;
255
256--
257-- TOC entry 2304 (class 0 OID 0)
258-- Dependencies: 186
259-- Name: faq_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
260--
261
262ALTER SEQUENCE public.faq_id_seq OWNED BY public.faq.id;
263
264
265--
266-- TOC entry 206 (class 1259 OID 40941)
267-- Name: faq_reportedby__user_reportedfaq; Type: TABLE; Schema: public; Owner: server
268--
269
270CREATE TABLE public.faq_reportedby__user_reportedfaq (
271 id integer NOT NULL,
272 "faq_reportedBy" integer,
273 "user_reportedFaq" text
274);
275
276
277ALTER TABLE public.faq_reportedby__user_reportedfaq OWNER TO server;
278
279--
280-- TOC entry 205 (class 1259 OID 40939)
281-- Name: faq_reportedby__user_reportedfaq_id_seq; Type: SEQUENCE; Schema: public; Owner: server
282--
283
284CREATE SEQUENCE public.faq_reportedby__user_reportedfaq_id_seq
285 START WITH 1
286 INCREMENT BY 1
287 NO MINVALUE
288 NO MAXVALUE
289 CACHE 1;
290
291
292ALTER TABLE public.faq_reportedby__user_reportedfaq_id_seq OWNER TO server;
293
294--
295-- TOC entry 2305 (class 0 OID 0)
296-- Dependencies: 205
297-- Name: faq_reportedby__user_reportedfaq_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
298--
299
300ALTER SEQUENCE public.faq_reportedby__user_reportedfaq_id_seq OWNED BY public.faq_reportedby__user_reportedfaq.id;
301
302
303--
304-- TOC entry 189 (class 1259 OID 40843)
305-- Name: information; Type: TABLE; Schema: public; Owner: server
306--
307
308CREATE TABLE public.information (
309 category text,
310 title text,
311 content text,
312 url text,
313 type text,
314 "isTarifa" boolean,
315 id integer NOT NULL,
316 "createdAt" timestamp with time zone,
317 "updatedAt" timestamp with time zone
318);
319
320
321ALTER TABLE public.information OWNER TO server;
322
323--
324-- TOC entry 188 (class 1259 OID 40841)
325-- Name: information_id_seq; Type: SEQUENCE; Schema: public; Owner: server
326--
327
328CREATE SEQUENCE public.information_id_seq
329 START WITH 1
330 INCREMENT BY 1
331 NO MINVALUE
332 NO MAXVALUE
333 CACHE 1;
334
335
336ALTER TABLE public.information_id_seq OWNER TO server;
337
338--
339-- TOC entry 2306 (class 0 OID 0)
340-- Dependencies: 188
341-- Name: information_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
342--
343
344ALTER SEQUENCE public.information_id_seq OWNED BY public.information.id;
345
346
347--
348-- TOC entry 191 (class 1259 OID 40854)
349-- Name: languagecode; Type: TABLE; Schema: public; Owner: server
350--
351
352CREATE TABLE public.languagecode (
353 name text,
354 code text,
355 id integer NOT NULL,
356 "createdAt" timestamp with time zone,
357 "updatedAt" timestamp with time zone
358);
359
360
361ALTER TABLE public.languagecode OWNER TO server;
362
363--
364-- TOC entry 190 (class 1259 OID 40852)
365-- Name: languagecode_id_seq; Type: SEQUENCE; Schema: public; Owner: server
366--
367
368CREATE SEQUENCE public.languagecode_id_seq
369 START WITH 1
370 INCREMENT BY 1
371 NO MINVALUE
372 NO MAXVALUE
373 CACHE 1;
374
375
376ALTER TABLE public.languagecode_id_seq OWNER TO server;
377
378--
379-- TOC entry 2307 (class 0 OID 0)
380-- Dependencies: 190
381-- Name: languagecode_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
382--
383
384ALTER SEQUENCE public.languagecode_id_seq OWNED BY public.languagecode.id;
385
386
387--
388-- TOC entry 193 (class 1259 OID 40865)
389-- Name: message; Type: TABLE; Schema: public; Owner: server
390--
391
392CREATE TABLE public.message (
393 content text,
394 "user" text,
395 "belongsTo" integer,
396 id integer NOT NULL,
397 "createdAt" timestamp with time zone,
398 "updatedAt" timestamp with time zone
399);
400
401
402ALTER TABLE public.message OWNER TO server;
403
404--
405-- TOC entry 192 (class 1259 OID 40863)
406-- Name: message_id_seq; Type: SEQUENCE; Schema: public; Owner: server
407--
408
409CREATE SEQUENCE public.message_id_seq
410 START WITH 1
411 INCREMENT BY 1
412 NO MINVALUE
413 NO MAXVALUE
414 CACHE 1;
415
416
417ALTER TABLE public.message_id_seq OWNER TO server;
418
419--
420-- TOC entry 2308 (class 0 OID 0)
421-- Dependencies: 192
422-- Name: message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
423--
424
425ALTER SEQUENCE public.message_id_seq OWNED BY public.message.id;
426
427
428--
429-- TOC entry 195 (class 1259 OID 40876)
430-- Name: thread; Type: TABLE; Schema: public; Owner: server
431--
432
433CREATE TABLE public.thread (
434 title text,
435 content text,
436 category text,
437 "postedBy" text,
438 "numberReports" integer,
439 "numberVotes" integer,
440 id integer NOT NULL,
441 "createdAt" timestamp with time zone,
442 "updatedAt" timestamp with time zone
443);
444
445
446ALTER TABLE public.thread OWNER TO server;
447
448--
449-- TOC entry 194 (class 1259 OID 40874)
450-- Name: thread_id_seq; Type: SEQUENCE; Schema: public; Owner: server
451--
452
453CREATE SEQUENCE public.thread_id_seq
454 START WITH 1
455 INCREMENT BY 1
456 NO MINVALUE
457 NO MAXVALUE
458 CACHE 1;
459
460
461ALTER TABLE public.thread_id_seq OWNER TO server;
462
463--
464-- TOC entry 2309 (class 0 OID 0)
465-- Dependencies: 194
466-- Name: thread_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
467--
468
469ALTER SEQUENCE public.thread_id_seq OWNED BY public.thread.id;
470
471
472--
473-- TOC entry 210 (class 1259 OID 40963)
474-- Name: thread_reportedby__user_reports; Type: TABLE; Schema: public; Owner: server
475--
476
477CREATE TABLE public.thread_reportedby__user_reports (
478 id integer NOT NULL,
479 "thread_reportedBy" integer,
480 user_reports text
481);
482
483
484ALTER TABLE public.thread_reportedby__user_reports OWNER TO server;
485
486--
487-- TOC entry 209 (class 1259 OID 40961)
488-- Name: thread_reportedby__user_reports_id_seq; Type: SEQUENCE; Schema: public; Owner: server
489--
490
491CREATE SEQUENCE public.thread_reportedby__user_reports_id_seq
492 START WITH 1
493 INCREMENT BY 1
494 NO MINVALUE
495 NO MAXVALUE
496 CACHE 1;
497
498
499ALTER TABLE public.thread_reportedby__user_reports_id_seq OWNER TO server;
500
501--
502-- TOC entry 2310 (class 0 OID 0)
503-- Dependencies: 209
504-- Name: thread_reportedby__user_reports_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
505--
506
507ALTER SEQUENCE public.thread_reportedby__user_reports_id_seq OWNED BY public.thread_reportedby__user_reports.id;
508
509
510--
511-- TOC entry 208 (class 1259 OID 40952)
512-- Name: thread_votedby__user_votes; Type: TABLE; Schema: public; Owner: server
513--
514
515CREATE TABLE public.thread_votedby__user_votes (
516 id integer NOT NULL,
517 "thread_votedBy" integer,
518 user_votes text
519);
520
521
522ALTER TABLE public.thread_votedby__user_votes OWNER TO server;
523
524--
525-- TOC entry 207 (class 1259 OID 40950)
526-- Name: thread_votedby__user_votes_id_seq; Type: SEQUENCE; Schema: public; Owner: server
527--
528
529CREATE SEQUENCE public.thread_votedby__user_votes_id_seq
530 START WITH 1
531 INCREMENT BY 1
532 NO MINVALUE
533 NO MAXVALUE
534 CACHE 1;
535
536
537ALTER TABLE public.thread_votedby__user_votes_id_seq OWNER TO server;
538
539--
540-- TOC entry 2311 (class 0 OID 0)
541-- Dependencies: 207
542-- Name: thread_votedby__user_votes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
543--
544
545ALTER SEQUENCE public.thread_votedby__user_votes_id_seq OWNED BY public.thread_votedby__user_votes.id;
546
547
548--
549-- TOC entry 196 (class 1259 OID 40885)
550-- Name: user; Type: TABLE; Schema: public; Owner: server
551--
552
553CREATE TABLE public."user" (
554 email text NOT NULL,
555 username text,
556 password text,
557 name text,
558 surname text,
559 biography text,
560 birthday text,
561 country text,
562 rank text,
563 "profilePicture" integer,
564 "hasFacebook" boolean,
565 "hasGoogle" boolean,
566 deactivated boolean,
567 karma integer,
568 "canChangePassword" boolean,
569 "createdAt" timestamp with time zone,
570 "updatedAt" timestamp with time zone
571);
572
573
574ALTER TABLE public."user" OWNER TO server;
575
576--
577-- TOC entry 212 (class 1259 OID 40974)
578-- Name: user_blockedbyuser__user_blocksuser; Type: TABLE; Schema: public; Owner: server
579--
580
581CREATE TABLE public.user_blockedbyuser__user_blocksuser (
582 id integer NOT NULL,
583 "user_blocksUser" text,
584 "user_blockedByUser" text
585);
586
587
588ALTER TABLE public.user_blockedbyuser__user_blocksuser OWNER TO server;
589
590--
591-- TOC entry 211 (class 1259 OID 40972)
592-- Name: user_blockedbyuser__user_blocksuser_id_seq; Type: SEQUENCE; Schema: public; Owner: server
593--
594
595CREATE SEQUENCE public.user_blockedbyuser__user_blocksuser_id_seq
596 START WITH 1
597 INCREMENT BY 1
598 NO MINVALUE
599 NO MAXVALUE
600 CACHE 1;
601
602
603ALTER TABLE public.user_blockedbyuser__user_blocksuser_id_seq OWNER TO server;
604
605--
606-- TOC entry 2312 (class 0 OID 0)
607-- Dependencies: 211
608-- Name: user_blockedbyuser__user_blocksuser_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
609--
610
611ALTER SEQUENCE public.user_blockedbyuser__user_blocksuser_id_seq OWNED BY public.user_blockedbyuser__user_blocksuser.id;
612
613
614--
615-- TOC entry 200 (class 1259 OID 40908)
616-- Name: valorationfaq; Type: TABLE; Schema: public; Owner: server
617--
618
619CREATE TABLE public.valorationfaq (
620 faq integer,
621 "user" text,
622 valoration integer,
623 id integer NOT NULL,
624 "createdAt" timestamp with time zone,
625 "updatedAt" timestamp with time zone
626);
627
628
629ALTER TABLE public.valorationfaq OWNER TO server;
630
631--
632-- TOC entry 199 (class 1259 OID 40906)
633-- Name: valorationfaq_id_seq; Type: SEQUENCE; Schema: public; Owner: server
634--
635
636CREATE SEQUENCE public.valorationfaq_id_seq
637 START WITH 1
638 INCREMENT BY 1
639 NO MINVALUE
640 NO MAXVALUE
641 CACHE 1;
642
643
644ALTER TABLE public.valorationfaq_id_seq OWNER TO server;
645
646--
647-- TOC entry 2313 (class 0 OID 0)
648-- Dependencies: 199
649-- Name: valorationfaq_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
650--
651
652ALTER SEQUENCE public.valorationfaq_id_seq OWNED BY public.valorationfaq.id;
653
654
655--
656-- TOC entry 198 (class 1259 OID 40897)
657-- Name: word; Type: TABLE; Schema: public; Owner: server
658--
659
660CREATE TABLE public.word (
661 word text,
662 definition text,
663 id integer NOT NULL,
664 "createdAt" timestamp with time zone,
665 "updatedAt" timestamp with time zone
666);
667
668
669ALTER TABLE public.word OWNER TO server;
670
671--
672-- TOC entry 197 (class 1259 OID 40895)
673-- Name: word_id_seq; Type: SEQUENCE; Schema: public; Owner: server
674--
675
676CREATE SEQUENCE public.word_id_seq
677 START WITH 1
678 INCREMENT BY 1
679 NO MINVALUE
680 NO MAXVALUE
681 CACHE 1;
682
683
684ALTER TABLE public.word_id_seq OWNER TO server;
685
686--
687-- TOC entry 2314 (class 0 OID 0)
688-- Dependencies: 197
689-- Name: word_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: server
690--
691
692ALTER SEQUENCE public.word_id_seq OWNED BY public.word.id;
693
694
695--
696-- TOC entry 2094 (class 2604 OID 40805)
697-- Name: comment id; Type: DEFAULT; Schema: public; Owner: server
698--
699
700ALTER TABLE ONLY public.comment ALTER COLUMN id SET DEFAULT nextval('public.comment_id_seq'::regclass);
701
702
703--
704-- TOC entry 2103 (class 2604 OID 40922)
705-- Name: comment_reportedby__user_reportedcomments id; Type: DEFAULT; Schema: public; Owner: server
706--
707
708ALTER TABLE ONLY public.comment_reportedby__user_reportedcomments ALTER COLUMN id SET DEFAULT nextval('public.comment_reportedby__user_reportedcomments_id_seq'::regclass);
709
710
711--
712-- TOC entry 2104 (class 2604 OID 40933)
713-- Name: comment_votedby__user_votedcomments id; Type: DEFAULT; Schema: public; Owner: server
714--
715
716ALTER TABLE ONLY public.comment_votedby__user_votedcomments ALTER COLUMN id SET DEFAULT nextval('public.comment_votedby__user_votedcomments_id_seq'::regclass);
717
718
719--
720-- TOC entry 2095 (class 2604 OID 40816)
721-- Name: conversation id; Type: DEFAULT; Schema: public; Owner: server
722--
723
724ALTER TABLE ONLY public.conversation ALTER COLUMN id SET DEFAULT nextval('public.conversation_id_seq'::regclass);
725
726
727--
728-- TOC entry 2096 (class 2604 OID 40835)
729-- Name: faq id; Type: DEFAULT; Schema: public; Owner: server
730--
731
732ALTER TABLE ONLY public.faq ALTER COLUMN id SET DEFAULT nextval('public.faq_id_seq'::regclass);
733
734
735--
736-- TOC entry 2105 (class 2604 OID 40944)
737-- Name: faq_reportedby__user_reportedfaq id; Type: DEFAULT; Schema: public; Owner: server
738--
739
740ALTER TABLE ONLY public.faq_reportedby__user_reportedfaq ALTER COLUMN id SET DEFAULT nextval('public.faq_reportedby__user_reportedfaq_id_seq'::regclass);
741
742
743--
744-- TOC entry 2097 (class 2604 OID 40846)
745-- Name: information id; Type: DEFAULT; Schema: public; Owner: server
746--
747
748ALTER TABLE ONLY public.information ALTER COLUMN id SET DEFAULT nextval('public.information_id_seq'::regclass);
749
750
751--
752-- TOC entry 2098 (class 2604 OID 40857)
753-- Name: languagecode id; Type: DEFAULT; Schema: public; Owner: server
754--
755
756ALTER TABLE ONLY public.languagecode ALTER COLUMN id SET DEFAULT nextval('public.languagecode_id_seq'::regclass);
757
758
759--
760-- TOC entry 2099 (class 2604 OID 40868)
761-- Name: message id; Type: DEFAULT; Schema: public; Owner: server
762--
763
764ALTER TABLE ONLY public.message ALTER COLUMN id SET DEFAULT nextval('public.message_id_seq'::regclass);
765
766
767--
768-- TOC entry 2100 (class 2604 OID 40879)
769-- Name: thread id; Type: DEFAULT; Schema: public; Owner: server
770--
771
772ALTER TABLE ONLY public.thread ALTER COLUMN id SET DEFAULT nextval('public.thread_id_seq'::regclass);
773
774
775--
776-- TOC entry 2107 (class 2604 OID 40966)
777-- Name: thread_reportedby__user_reports id; Type: DEFAULT; Schema: public; Owner: server
778--
779
780ALTER TABLE ONLY public.thread_reportedby__user_reports ALTER COLUMN id SET DEFAULT nextval('public.thread_reportedby__user_reports_id_seq'::regclass);
781
782
783--
784-- TOC entry 2106 (class 2604 OID 40955)
785-- Name: thread_votedby__user_votes id; Type: DEFAULT; Schema: public; Owner: server
786--
787
788ALTER TABLE ONLY public.thread_votedby__user_votes ALTER COLUMN id SET DEFAULT nextval('public.thread_votedby__user_votes_id_seq'::regclass);
789
790
791--
792-- TOC entry 2108 (class 2604 OID 40977)
793-- Name: user_blockedbyuser__user_blocksuser id; Type: DEFAULT; Schema: public; Owner: server
794--
795
796ALTER TABLE ONLY public.user_blockedbyuser__user_blocksuser ALTER COLUMN id SET DEFAULT nextval('public.user_blockedbyuser__user_blocksuser_id_seq'::regclass);
797
798
799--
800-- TOC entry 2102 (class 2604 OID 40911)
801-- Name: valorationfaq id; Type: DEFAULT; Schema: public; Owner: server
802--
803
804ALTER TABLE ONLY public.valorationfaq ALTER COLUMN id SET DEFAULT nextval('public.valorationfaq_id_seq'::regclass);
805
806
807--
808-- TOC entry 2101 (class 2604 OID 40900)
809-- Name: word id; Type: DEFAULT; Schema: public; Owner: server
810--
811
812ALTER TABLE ONLY public.word ALTER COLUMN id SET DEFAULT nextval('public.word_id_seq'::regclass);
813
814
815--
816-- TOC entry 2260 (class 0 OID 40802)
817-- Dependencies: 182
818-- Data for Name: comment; Type: TABLE DATA; Schema: public; Owner: server
819--
820
821COPY public.comment (content, "postedBy", "repliesTo", "belongsTo", "numberReports", "numberVotes", id, "createdAt", "updatedAt") FROM stdin;
822�Qu� bien! i@k.com \N 3 0 0 2 2018-06-13 16:41:58+00 2018-06-13 16:41:58+00
823�Perfecto! i@k.com \N 3 0 0 3 2018-06-13 16:45:13+00 2018-06-13 16:45:13+00
824�Ahora te env�o un mensaje! i@k.com \N 3 0 0 4 2018-06-13 16:47:16+00 2018-06-13 16:47:16+00
825¡Genial! i@k.com \N 3 0 0 5 2018-06-13 17:05:45+00 2018-06-13 17:05:45+00
826I will be there! i@k.com \N 1 0 2 7 2018-06-13 18:45:55+00 2018-06-14 16:46:00+00
827Great plan! alex.armengou@gmail.com \N 1 1 2 1 2018-06-13 15:25:09+00 2018-06-14 16:46:02+00
828#7 +1 guillem.bonet@gmail.com \N 1 0 1 8 2018-06-14 16:50:00+00 2018-06-15 10:01:24+00
829That's great! i@k.com \N 1 0 2 9 2018-06-15 10:01:17+00 2018-06-15 14:40:05+00
830Qué interesante isakody@gmail.com \N 8 0 0 11 2018-06-15 14:45:02+00 2018-06-15 14:45:02+00
831You can come and live with me:$ eloiroca97@gmail.com \N 7 0 0 12 2018-06-15 14:55:06+00 2018-06-15 14:55:06+00
832I'm up for it! guillem.bonet@gmail.com \N 5 0 1 10 2018-06-15 13:20:47+00 2018-06-15 14:58:30+00
833Very interesting :) nuria@gmail.com \N 1 1 4 6 2018-06-13 18:06:57+00 2018-06-15 16:38:04+00
834#6 I'm interested i@k.com \N 1 0 0 13 2018-06-15 16:38:28+00 2018-06-15 16:38:28+00
835#14 bona a@mail.com \N 11 0 0 16 2018-06-15 20:59:15+00 2018-06-15 20:59:15+00
836eiii a@mail.com \N 11 0 2 15 2018-06-15 20:58:44+00 2018-06-16 12:19:48+00
837bona demo eloiroca97@gmail.com \N 11 2 1 14 2018-06-15 16:39:54+00 2018-06-16 12:19:58+00
838\.
839
840
841--
842-- TOC entry 2280 (class 0 OID 40919)
843-- Dependencies: 202
844-- Data for Name: comment_reportedby__user_reportedcomments; Type: TABLE DATA; Schema: public; Owner: server
845--
846
847COPY public.comment_reportedby__user_reportedcomments (id, "comment_reportedBy", "user_reportedComments") FROM stdin;
8481 1 nuria@gmail.com
8492 6 i@k.com
8503 14 a@mail.com
8514 14 nico@hotmail.com
852\.
853
854
855--
856-- TOC entry 2282 (class 0 OID 40930)
857-- Dependencies: 204
858-- Data for Name: comment_votedby__user_votedcomments; Type: TABLE DATA; Schema: public; Owner: server
859--
860
861COPY public.comment_votedby__user_votedcomments (id, "comment_votedBy", "user_votedComments") FROM stdin;
8621 1 alex@alex.cat
8632 6 nuria@gmail.com
8643 7 nuria@gmail.com
8654 6 alex.armengou@gmail.com
8665 7 guillem.bonet@gmail.com
8676 6 guillem.bonet@gmail.com
8687 1 guillem.bonet@gmail.com
8698 8 i@k.com
8709 9 i@k.com
87110 9 albacanete97@gmail.com
87211 10 eloiroca97@gmail.com
87312 6 i@k.com
87413 15 a@mail.com
87514 14 a@mail.com
87615 15 nico@hotmail.com
877\.
878
879
880--
881-- TOC entry 2262 (class 0 OID 40813)
882-- Dependencies: 184
883-- Data for Name: conversation; Type: TABLE DATA; Schema: public; Owner: server
884--
885
886COPY public.conversation (user1, user2, "newMessage1", "newMessage2", "lastMessageTime", "lastMessageContent", "blockedByUser1", "blockedByUser2", id, "createdAt", "updatedAt") FROM stdin;
887nuria@gmail.com guillem.bonet@gmail.com f f \N \N f f 3 2018-06-14 17:04:14+00 2018-06-14 17:04:15+00
888alex.armengou@gmail.com guillem.bonet@gmail.com f f 2018-06-15 13:33:32+00 😂 f f 5 2018-06-15 13:30:10+00 2018-06-15 13:33:58+00
889borjafruizdelgado@gmail.com nuria@gmail.com t f 2018-06-14 18:20:44+00 :( f t 4 2018-06-14 18:20:18+00 2018-06-15 14:53:42+00
890eloiroca97@gmail.com i@k.com f f 2018-06-15 20:25:12+00 todo correcto? f f 7 2018-06-15 14:59:04+00 2018-06-15 20:40:04+00
891albacanete97@gmail.com nuria@gmail.com t f 2018-06-15 20:27:57+00 I tu ets burra? f f 6 2018-06-15 14:42:54+00 2018-06-15 20:43:01+00
892a@mail.com eloiroca97@gmail.com f f \N \N f f 8 2018-06-15 21:03:04+00 2018-06-15 21:03:05+00
893nico@hotmail.com eloiroca97@gmail.com f f \N \N f f 9 2018-06-16 12:20:42+00 2018-06-16 12:20:44+00
894i@k.com nuria@gmail.com f f 2018-06-14 17:21:52+00 Ok, my mail is isakody@gmail.com. Thank you! t f 1 2018-06-13 18:12:41+00 2018-06-15 16:47:40+00
895alex@alex.cat alex.armengou@gmail.com f f 2018-06-14 16:58:06+00 Me alegro f t 2 2018-06-14 15:56:32+00 2018-06-15 20:24:56+00
896\.
897
898
899--
900-- TOC entry 2263 (class 0 OID 40822)
901-- Dependencies: 185
902-- Data for Name: currency; Type: TABLE DATA; Schema: public; Owner: server
903--
904
905COPY public.currency (name, "rateToEur", "createdAt", "updatedAt") FROM stdin;
906BTN 0.012738 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
907JPY 0.007809 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
908AUD 0.641338 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
909FKP 1.144963 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
910BSD 0.861704 2018-05-15 00:00:01+00 2018-06-17 00:00:02+00
911INR 0.012678 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
912PGK 0.274454 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
913ALL 0.008008 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
914MKD 0.016632 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
915BWP 0.083905 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
916CNY 0.134053 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
917JMD 0.006674 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
918LSL 0.064165 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
919XOF 0.001526 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
920RSD 0.008465 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
921COP 0.000298 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
922BZD 0.431876 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
923ANG 0.478488 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
924USD 0.861704 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
925MWK 0.001209 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
926CVE 0.009065 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
927BAM 0.510778 2018-05-15 00:00:01+00 2018-06-17 00:00:02+00
928MNT 0.000359 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
929CHF 0.864918 2018-05-15 12:00:00+00 2018-06-18 00:40:09+00
930HTG 0.013181 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
931SDG 0.048065 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
932KPW 0.000959 2018-05-15 12:00:00+00 2018-06-18 00:40:09+00
933MGA 0.000264 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
934PAB 0.863008 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
935QAR 0.236949 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
936PEN 0.263329 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
937CZK 0.03887 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
938DKK 0.13418 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
939VEF 0.000010813261 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
940ARS 0.030759 2018-05-15 00:00:01+00 2018-06-18 00:40:15+00
941JOD 1.21808 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
942KYD 1.05185 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
943KWD 2.856317 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
944RON 0.214589 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
945CAD 0.652854 2018-05-15 00:00:01+00 2018-06-17 12:00:01+00
946MUR 0.024708 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
947SAR 0.230086 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
948DZD 0.007379 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
949SRD 0.116124 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
950BYR 0.00004402542 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
951SGD 0.637581 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
952CDF 0.00055 2018-05-15 00:00:01+00 2018-06-17 12:00:01+00
953TOP 0.375123 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
954MDL 0.051566 2018-05-15 12:00:00+00 2018-06-18 00:40:09+00
955FJD 0.418404 2018-05-15 00:00:01+00 2018-06-17 12:00:01+00
956GMD 0.018424 2018-05-15 12:00:00+00 2018-06-18 00:40:09+00
957ISK 0.008008 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
958IDR 0.000061960527 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
959SCR 0.064215 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
960KRW 0.000782 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
961BOB 0.125955 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
962AZN 0.507789 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
963MMK 0.00064 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
964MAD 0.090505 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
965LKR 0.005402 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
966PYG 0.000153 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
967HRK 0.135731 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
968YER 0.003449 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
969BRL 0.231032 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
970AFN 0.01206 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
971NIO 0.02761 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
972NPR 0.007927 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
973KMF 0.002063 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
974THB 0.0264 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
975UAH 0.032727 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
976SBD 0.108954 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
977TRY 0.182352 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
978KES 0.008536 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
979LRD 0.006148 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
980DJF 0.004855 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
981GHS 0.18416 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
982HKD 0.109803 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
983NAD 0.064167 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
984UYU 0.027353 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
985XPF 0.008378 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
986NOK 0.105775 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
987MXN 0.041782 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
988TTD 0.128526 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
989GNF 0.000095755536 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
990EGP 0.04841 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
991RUB 0.013649 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
992ZMW 0.086775 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
993VND 0.000037770847 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
994GBP 1.144847 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
995TMT 0.252699 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
996SZL 0.064215 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
997BTC 5612.010676 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
998BYN 0.430774 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
999UZS 0.000109 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
1000TND 0.330277 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
1001ETB 0.031633 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
1002PLN 0.233429 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
1003BDT 0.010299 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
1004DOP 0.017472 2018-05-15 00:00:01+00 2018-06-17 12:00:02+00
1005KHR 0.000213 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
1006LVL 1.388613 2018-05-15 00:00:01+00 2018-06-17 12:00:02+00
1007PKR 0.007238 2018-05-15 12:00:00+00 2018-06-17 12:00:02+00
1008XDR 1.215904 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
1009AED 0.234624 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
1010MRO 0.00243 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1011VUV 0.007998 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
1012SHP 1.144659 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
1013TJS 0.09479 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
1014UGX 0.000225 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
1015CRC 0.001529 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1016MZN 0.014688 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1017STD 0.0000407982 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1018ERN 0.05757 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1019ZAR 0.06414 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1020SEK 0.098077 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1021XAF 0.001526 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1022EUR 1 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1023WST 0.335868 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1024IRR 0.000020361628 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1025BBD 0.430852 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1026HUF 0.003104 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1027NZD 0.598778 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1028BND 0.644166 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1029XCD 0.318724 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1030LYD 0.63552 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1031TZS 0.00038 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1032CUP 0.032517 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1033AMD 0.001787 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1034OMR 2.238751 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1035LAK 0.000103 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1036GIP 1.144659 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1037RWF 0.001014 2018-05-15 00:00:01+00 2018-06-17 00:00:01+00
1038MOP 0.106606 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
1039MVR 0.055343 2018-05-15 12:00:01+00 2018-06-17 12:00:01+00
1040KGS 0.012608 2018-05-15 12:00:00+00 2018-06-17 12:00:01+00
1041GEL 0.352174 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1042SOS 0.001536 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1043SYP 0.001675 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1044LBP 0.000573 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1045BIF 0.000493 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1046AWG 0.484719 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1047KZT 0.002564 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1048BHD 2.284824 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1049PHP 0.016144 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1050AOA 0.003568 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1051TWD 0.028636 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1052IQD 0.000729 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1053GYD 0.004184 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1054BGN 0.511562 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1055SLL 0.000109 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1056HNL 0.036166 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1057CLP 0.001364 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1058GTQ 0.117613 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1059ILS 0.238474 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1060MYR 0.215915 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1061NGN 0.00241 2018-05-15 00:00:01+00 2018-06-18 00:40:09+00
1062\.
1063
1064
1065--
1066-- TOC entry 2265 (class 0 OID 40832)
1067-- Dependencies: 187
1068-- Data for Name: faq; Type: TABLE DATA; Schema: public; Owner: server
1069--
1070
1071COPY public.faq (question, answer, category, puntuation, "numberReports", id, "createdAt", "updatedAt") FROM stdin;
1072With an offer of employment can I work in Spain? To work in Spain you need an authorization, you must be in your country to request it and for your concession you have to have an offer of employment. If you have a permanent residence, you will not need authorization. work 4 0 6 2018-06-13 19:34:49+00 2018-06-13 19:36:27+00
1073Do I need a high level of Spanish to study at a Spanish university? Yes, in most universities you will have to take a test to confirm your linguistic ability. Universities may also consider the student's résumé to verify your ability. education and formation 4 0 10 2018-06-13 19:38:06+00 2018-06-13 19:39:55+00
1074How long does the process of authorizing and validating of my studies in Spain take? Approximately three months from the time you apply to the final decision. education and formation 3 0 11 2018-06-13 19:38:18+00 2018-06-13 19:40:00+00
1075What requirements do I need to be able to do a Masters in a Spanish university? You must have a university degree and in some cases, you will need to authorize it with the equivalent Spanish degree through the "Ministry of Science and Innovation". education and formation 2 0 12 2018-06-13 19:38:33+00 2018-06-13 19:40:05+00
1076How much does it cost to do a Degree or a Masters in Spain? A Degree at a public university costs, on average, 1,000 euros per academic year.\nA Degree at a private university costs, on average, 6,300 euros per academic year.\nA Masters costs from 4,000 to 30,000 euros, depending on where you study, for how long you study etc. education and formation 4 0 14 2018-06-13 19:39:03+00 2018-06-13 19:40:14+00
1077What must a foreign worker do when arriving in Spain? After arriving in Spain, foreign workers must:\n- Register in the corresponding Social Security scheme.\n- Apply for a foreigner identity card.\nCitizens of the European Union and their family members, provided that the latter travel with or meet said citizens, are subject to a specific legal system based on the rights recognized in the Treaties. work 4.5 0 3 2018-06-13 19:33:45+00 2018-06-14 18:50:17+00
1078How long does it take to study for an Undergraduate Degree and for a Masters in Spain? It takes 4 or 5 years to study for an Undergraduate Degree and from 7 months to 2 years to study for a Masters. education and formation 3 1 13 2018-06-13 19:38:45+00 2018-06-14 19:33:42+00
1079Is it possible to get a grant for my studies? Although it is not impossible, a grant is very difficult to get. Ask eduSpain about the opportunities before you decide to start the application process. education and formation 3 1 15 2018-06-13 19:39:17+00 2018-06-14 19:34:00+00
1080What do I need to be able to study in Spain? A passport, which complies with official regulations, signed and valid for at least six months.\nA visa. You can apply for a student visa at the Spanish Embassy or Consulate in your country.\nIf you want to study in an official, certified program at a Spanish university leading to a degree, you must have documentation of your academic qualifications officially recognized in Spain. These documents are not required for Spanish language and culture courses or for any program not leading to a university degree. education and formation 4 1 9 2018-06-13 19:37:49+00 2018-06-14 19:34:08+00
1081How to study in Spain? Foreigners wishing to stay in Spain to study, carry out research, training or unpaid internship activities, participate in student exchanges, or perform volunteer services, must obtain the corresponding visa, which will include the initial authorization to stay in Spain. However, nationals of certain countries are exempted from the visa requirement provided that the duration of their stay in Spain does not exceed three months. education and formation 3 1 8 2018-06-13 19:37:09+00 2018-06-14 19:36:17+00
1082Does Spanish Law require any special documents before opening a business in your country? The answer to this question is very simple, but it requires following a difficult process due to all the different offices in which that business must be registered (the dreaded Spanish Bureacracy!). Everybody who comes to Spain from a country which belongs the European Union can stay here and start a business without any requirements except two: \r\n1. Register himself/herself and other family members at the Spanish Home Office by presenting the N.I.E. Application form, and;\r\n2. Fulfil all the legal and national obligations issued by the Spanish Authorities depending on the quality and features of the economic activity recently started. Both the Spanish Inland Revenue and the Spanish Social Security and the local Town Hall where that activity is going to be managed must be informed in order to have all the required legal licences to run the activity with no public penalties. work 4 2 2 2018-06-13 19:33:12+00 2018-06-14 19:48:07+00
1083How can I legalize a university degree / master's degree in a foreign country? Spanish academic documents need to be legalized or apostilled in order to be valid abroad. If the country to which you wish to present your degree or master is part of the Hague Convention of 1961, of Suppression of the Legalization Requirement in Foreign Public Documents, you must apostille this academic document in the Ministry of Justice (Plaza de Jacinto Benavente , No. 3. 28071 Madrid Tel. 902.007.214). In the case of a country that is not part of the Hague Apostille Convention, you must legalize it. education and formation 1 2 7 2018-06-13 19:35:36+00 2018-06-15 14:30:01+00
1084Who can apply for an authorization to work? The Spanish employer or employer wishing to hire you must apply for an authorization of residence and work for others by submitting your job offer to the Offices of foreigners, in the Work Areas of the delegations or sub-delegations of the Government of the province.\nThe foreign worker, when you are interested in applying for a residence and work authorization on your own or presenting the application for the renewal of authorizations. You must also do the procedure in the Offices of foreigners, in the Work Areas of the delegations or sub-delegations of the Government of the province. work 2.33332992 0 5 2018-06-13 19:34:33+00 2018-06-15 15:00:29+00
1085What should I do in case of an emergency? For emergencies, call 112 right away for an ambulance or police. All foreigners and citizens have a right to be served for emergency or urgent treatment in Spanish hospitals. health 5 1 17 2018-06-15 12:24:50+00 2018-06-15 14:34:12+00
1086What do I need to work in Spain? To carry out a work activity in Spain you must be over 16 years old and you will need a residence and work authorization.\nRequirements for residence and work permits\nYou will need a residence and work authorization. This authorization will allow you to reside in Spain in a legal manner and you can exercise a work activity on your own, ie start your own business or develop your professional activity or work in a dependent relationship as an employee.\nWhen you apply for the authorization for the first time, the national employment situation will be evaluated, meaning that no Spanish or community worker can occupy the job position of your job offer. work 4.5 1 4 2018-06-13 19:34:16+00 2018-06-15 11:14:20+00
1087How can I enter the municipal register? In order to enter the municipal register you must bring into you local town hall your passport or residence card and a document that proves you are living in that population, for example a rental contract public administration 0 0 19 2018-06-15 13:01:58+00 2018-06-15 13:01:58+00
1088When I am considered spanish resident? If you reside more than 183 days in Spain you are automatically considered Spanish resident. public administration 0 0 20 2018-06-15 13:28:12+00 2018-06-15 13:28:12+00
1089What should I do if I get robbed? The first thing you should do is go to the nearest police station and denounce the robbery. There they will ask you about what happened and they will need your documentation to proceed with the denouncement. justice 0 0 21 2018-06-15 13:40:57+00 2018-06-15 13:40:57+00
1090I have to attend a trial, can I access a lawyer for free? Yes, but only if you prove that family income does not exceed a certain limit. The income limits are given by the Spanish government and they are the following: 12.908 euros/year if you are not integrated in any familiar unit, 16.135 euros/year for a family with less than 4 members and 19.362 euros/year for a family with 4 or more members. justice 0 0 22 2018-06-15 13:59:02+00 2018-06-15 13:59:02+00
1091Is spanish healthcare system free? Yes, spanish has an universal healthcare system, but you must meet certain criteria to obtain coverage. In order to gain access to the Spanish National Health System (SNS) you must be registered in your local town hall and you must have a valid work contract. health 4 1 16 2018-06-15 12:22:51+00 2018-06-15 14:32:09+00
1092Is it allowed to drink alcohol in the street? No, it isn't allowed to drink alcohol in public roads. Fines can vary depending on the population you are in, in Barcelona it is fined from 30 to 100 euros off topic 5 0 18 2018-06-15 12:32:47+00 2018-06-15 16:42:18+00
1093If I work in Spain, will I loose the period I was working in my country? No, you will not. Most of EU countries have an agreement with Spain to share pensions. Therefore, if you have been working in Denmark for 30 years, and you have been working in Spain for the last 20 years, the Spanish Seguridad Social will provide you a pension of 50 years, in collaboration with Denmark. work 4.28570986 3 1 2018-06-13 19:32:49+00 2018-06-16 12:17:20+00
1094\.
1095
1096
1097--
1098-- TOC entry 2284 (class 0 OID 40941)
1099-- Dependencies: 206
1100-- Data for Name: faq_reportedby__user_reportedfaq; Type: TABLE DATA; Schema: public; Owner: server
1101--
1102
1103COPY public.faq_reportedby__user_reportedfaq (id, "faq_reportedBy", "user_reportedFaq") FROM stdin;
11041 2 i@k.com
11052 2 omarcruz11@hotmail.com
11063 13 omarcruz11@hotmail.com
11074 15 omarcruz11@hotmail.com
11085 9 omarcruz11@hotmail.com
11096 7 omarcruz11@hotmail.com
11107 8 omarcruz11@hotmail.com
11118 4 i@k.com
11129 7 alex.armengou@gmail.com
111310 17 omarcruz11@hotmail.com
111411 16 omarcruz11@hotmail.com
111512 1 i@k.com
111613 1 nuria@gmail.com
111714 1 nico@hotmail.com
1118\.
1119
1120
1121--
1122-- TOC entry 2267 (class 0 OID 40843)
1123-- Dependencies: 189
1124-- Data for Name: information; Type: TABLE DATA; Schema: public; Owner: server
1125--
1126
1127COPY public.information (category, title, content, url, type, "isTarifa", id, "createdAt", "updatedAt") FROM stdin;
1128tourism Map with the markets in the city [{ "tooltip": "Mercat de Sant Gervasi","latitude": "41.405663","longitude": "2.138554"},{ "tooltip": "Mercat de l'Abaceria Central","latitude": "41.40224","longitude": "2.159387"},{ "tooltip": "Mercat del Carmel","latitude": "41.42374","longitude": "2.155818"},{ "tooltip": "Mercat de La Mercè","latitude": "41.430483","longitude": "2.173608"},{ "tooltip":"Mercat d'Horta","latitude": "41.429625","longitude": "2.159617"},{ "tooltip": "Mercat del Guinardó","latitude": "41.419151","longitude": "2.179729"},{ "tooltip": "Mercat d'Hostafrancs","latitude": "41.375162","longitude": "2.143862"},{ "tooltip": "Mercat Encants Vells Fira de Bellcaire","latitude": "41.401063","longitude": "2.185677"},{ "tooltip": "Mercat del Fort Pienc","latitude": "41.395773","longitude": "2.182549"},{ "tooltip": "Mercat de Sarrià ","latitude": "41.399835","longitude": "2.120731"},{ "tooltip": "Mercat de La Concepció","latitude": "41.395591","longitude": "2.168974"},{ "tooltip": "Mercat de Les Tres Torres","latitude": "41.399944","longitude": "2.131289"},{ "tooltip": "Mercat de Les Corts","latitude": "41.384078","longitude": "2.129813"},{ "tooltip": "Mercat Encants Vells Fira de Bellcaire","latitude": "41.40131","longitude": "2.186752"},{ "tooltip": "Mercat de la Sagrada FamÃlia","latitude": "41.405718","longitude": "2.177037"},{ "tooltip": "Mercat del Poblenou - Unió","latitude": "41.401021","longitude": "2.205437"},{ "tooltip": "Mercat de Canyelles","latitude": "41.441988","longitude": "2.164435"},{ "tooltip": "Mercat del Clot","latitude": "41.407616","longitude": "2.188652"},{ "tooltip": "Mercat del Ninot","latitude": "41.387857","longitude": "2.15442"},{ "tooltip":"Mercat de La Trinitat","latitude": "41.448692","longitude": "2.184241"},{ "tooltip": "Mercat Dominical de Sant Antoni","latitude": "41.379822","longitude": "2.161426"},{ "tooltip": "Mercat de Santa Caterina","latitude": "41.386394","longitude": "2.178185"},{ "tooltip": "Mercat Encants de Sant Antoni","latitude": "41.381301","longitude": "2.163459"},{ "tooltip": "Mercat de La Guineueta","latitude": "41.438652","longitude": "2.170254"},{ "tooltip": "Mercat de la Llibertat","latitude": "41.399737","longitude": "2.153756"},{ "tooltip": "Mercat de Ciutat Meridiana","latitude": "41.461717","longitude": "2.17782"},{ "tooltip": "Mercat de l'Estrella","latitude": "41.409911","longitude": "2.164001"},{ "tooltip":"Mercat de Galvany","latitude": "41.396682","longitude": "2.143687"},{ "tooltip": "Mercat del Besòs","latitude": "41.419232","longitude": "2.215137"},{ "tooltip": "Mercat de Provençals","latitude": "41.419457","longitude": "2.196493"},{ "tooltip": "Mercat de les Flors *Les Rambles","latitude": "41.382986","longitude": "2.171956"},{ "tooltip": "Mercat de Sant MartÃ","latitude": "41.418656","longitude": "2.205331"},{ "tooltip": "Mercat de La Barceloneta","latitude": "41.380431","longitude": "2.189132"},{ "tooltip": "Mercat de Sant Antoni","latitude": "41.379777","longitude": "2.163244"},{ "tooltip": "Mercat de Sant Josep - La Boqueria","latitude": "41.382048","longitude": "2.172279"},{ "tooltip": "Mercat del Bon Pastor","latitude": "41.436245","longitude": "2.207849"},{ "tooltip": "Mercat de Felip II","latitude": "41.422026","longitude": "2.185101"},{ "tooltip": "Mercat de Sant Andreu","latitude": "41.433957","longitude": "2.191032"},{ "tooltip": "Mercat de Lesseps","latitude": "41.409132","longitude": "2.152066"},{ "tooltip": "Mercat de Sants","latitude":"41.374741","longitude": "2.133763"},{ "tooltip": "Mercat de Montserrat","latitude": "41.446325","longitude": "2.178797"},{ "tooltip": "Mercat de La Marina","latitude": "41.360378","longitude": "2.139198"},{ "tooltip": "Mercat de Vall d'Hebron -Teixonera","latitude": "41.424062","longitude": "2.14246"}] map f 5 2018-05-25 06:11:14+00 2018-05-25 06:11:14+00
1129culture Barcelona Culture Institute The Barcelona Culture Institute invites you to discover and participate in cultural events taking place in the city. Explore the wide range of activities on offer for people of all ages: cinema, shows, literature, music, performing arts, museums, cultural heritage, innovation, cultural programmes, festive holidays, traditions, and much more. On the Barcelona Cultura website, you’ll also find newsletters, publications, information on how to purchase tickets and rent venues, plus a comprehensive catalogue of cultural websites, among other services, so that you can enjoy the full spectrum of cultural activities on offer in the city and its neighbourhoods. http://lameva.barcelona.cat/barcelonacultura/en/ text f 7 2018-05-25 08:17:00+00 2018-05-25 08:17:00+00
1130off topic Wifi Hotspots Map [{ "tooltip": "Mercat de Sant Gervasi","latitude": "41.405663","longitude": "2.138554"},{ "tooltip": "Mercat de l'Abaceria Central","latitude": "41.40224","longitude": "2.159387"},{ "tooltip": "Mercat del Carmel","latitude": "41.42374","longitude": "2.155818"},{ "tooltip": "Mercat de La Mercè","latitude": "41.430483","longitude": "2.173608"},{ "tooltip":"Mercat d'Horta","latitude": "41.429625","longitude": "2.159617"},{ "tooltip": "Mercat del Guinardó","latitude": "41.419151","longitude": "2.179729"},{ "tooltip": "Mercat d'Hostafrancs","latitude": "41.375162","longitude": "2.143862"},{ "tooltip": "Mercat Encants Vells Fira de Bellcaire","latitude": "41.401063","longitude": "2.185677"},{ "tooltip": "Mercat del Fort Pienc","latitude": "41.395773","longitude": "2.182549"},{ "tooltip": "Mercat de Sarrià ","latitude": "41.399835","longitude": "2.120731"},{ "tooltip": "Mercat de La Concepció","latitude": "41.395591","longitude": "2.168974"},{ "tooltip": "Mercat de Les Tres Torres","latitude": "41.399944","longitude": "2.131289"},{ "tooltip": "Mercat de Les Corts","latitude": "41.384078","longitude": "2.129813"},{ "tooltip": "Mercat Encants Vells Fira de Bellcaire","latitude": "41.40131","longitude": "2.186752"},{ "tooltip": "Mercat de la Sagrada FamÃlia","latitude": "41.405718","longitude": "2.177037"},{ "tooltip": "Mercat del Poblenou - Unió","latitude": "41.401021","longitude": "2.205437"},{ "tooltip": "Mercat de Canyelles","latitude": "41.441988","longitude": "2.164435"},{ "tooltip": "Mercat del Clot","latitude": "41.407616","longitude": "2.188652"},{ "tooltip": "Mercat del Ninot","latitude": "41.387857","longitude": "2.15442"},{ "tooltip":"Mercat de La Trinitat","latitude": "41.448692","longitude": "2.184241"},{ "tooltip": "Mercat Dominical de Sant Antoni","latitude": "41.379822","longitude": "2.161426"},{ "tooltip": "Mercat de Santa Caterina","latitude": "41.386394","longitude": "2.178185"},{ "tooltip": "Mercat Encants de Sant Antoni","latitude": "41.381301","longitude": "2.163459"},{ "tooltip": "Mercat de La Guineueta","latitude": "41.438652","longitude": "2.170254"},{ "tooltip": "Mercat de la Llibertat","latitude": "41.399737","longitude": "2.153756"},{ "tooltip": "Mercat de Ciutat Meridiana","latitude": "41.461717","longitude": "2.17782"},{ "tooltip": "Mercat de l'Estrella","latitude": "41.409911","longitude": "2.164001"},{ "tooltip":"Mercat de Galvany","latitude": "41.396682","longitude": "2.143687"},{ "tooltip": "Mercat del Besòs","latitude": "41.419232","longitude": "2.215137"},{ "tooltip": "Mercat de Provençals","latitude": "41.419457","longitude": "2.196493"},{ "tooltip": "Mercat de les Flors *Les Rambles","latitude": "41.382986","longitude": "2.171956"},{ "tooltip": "Mercat de Sant MartÃ","latitude": "41.418656","longitude": "2.205331"},{ "tooltip": "Mercat de La Barceloneta","latitude": "41.380431","longitude": "2.189132"},{ "tooltip": "Mercat de Sant Antoni","latitude": "41.379777","longitude": "2.163244"},{ "tooltip": "Mercat de Sant Josep - La Boqueria","latitude": "41.382048","longitude": "2.172279"},{ "tooltip": "Mercat del Bon Pastor","latitude": "41.436245","longitude": "2.207849"},{ "tooltip": "Mercat de Felip II","latitude": "41.422026","longitude": "2.185101"},{ "tooltip": "Mercat de Sant Andreu","latitude": "41.433957","longitude": "2.191032"},{ "tooltip": "Mercat de Lesseps","latitude": "41.409132","longitude": "2.152066"},{ "tooltip": "Mercat de Sants","latitude":"41.374741","longitude": "2.133763"},{ "tooltip": "Mercat de Montserrat","latitude": "41.446325","longitude": "2.178797"},{ "tooltip": "Mercat de La Marina","latitude": "41.360378","longitude": "2.139198"},{ "tooltip": "Mercat de Vall d'Hebron -Teixonera","latitude": "41.424062","longitude": "2.14246"}] \N map f 9 2018-05-25 08:18:49+00 2018-05-25 08:18:49+00
1131housing Protecting the right to a home is everyone's business One thing we're clear about in Barcelona: housing is an essential right. It has to be, to ensure everyone has a decent standard of living. For this reason, Barcelona City Council is working hard on implementing a housing policy that addresses the current urgent situation and that acts on the specific issues that make it difficult for people to access housing in the city. The main aim is to make it easier for different social groups to access housing through innovative proposals, taking into account new challenges, such as the ageing population.\nWe are aware that, in order to extend this right to all, there is a need to change the often held perception of housing as an investment asset and instead to see it as an essential need. In order to carry out this task, the new municipal housing policy works with social entities, neighbourhood associations and professionals working in different areas within the housing sector: development of public sector rental flats, mobilisation of empty housing units, socially proactive and ecologically efficient renovation projects, promotion of cohousing as a new means of access and new concept of home, promotion of awareness-raising and dissemination campaigns, and promoting discipline to prevent antisocial uses of flats, among others.In order to achieve this new vision, drawn up within the Municipal Action Plan, a Plan for the Right to Housing in Barcelona 2016-2025 has been produced. \N text f 11 2018-05-25 08:24:10+00 2018-05-25 08:24:10+00
1132culture OV Cinemas in Barcelona (Original language cinemas) A trip to the cinema can be the perfect way to relax or disconnect for a couple of hours. Maybe you want to watch a movie in English but you don't know where.\nThroughout Barcelona there are "Version Original" cinemas or VO cines, as they are known locally. These cinemas show films in the language they were originally produced in - often times that is English, however other languages are also available e.g. French and German. If you are in search of the latest blockbuster, the Yelmo Icaria cinema (see below) is the place that you are most likely to find it. In general the version original language cinemas tend to offer a mixture of new releases and art house favourites.\n\nHere we give you a list with original language cinemas in Barcelona:\n-Cine Melies http://www.cinesmelies.com/\n-Renoir Floridablanca http://www.cinesrenoir.com/cartelera/cine/DE3A5F9A3B29A251\n-Cinemes Girona http://www.cinemesgirona.cat/\n-Yelmo Icaria http://www.yelmocines.es/\n-Filmoteca de Catalunya Cine http://www.filmoteca.cat/\n-Cinema Maldas http://www.cinemamalda.com/\n-Cines Verdi http://www.cines-verdi.com/ \N \N f 12 2018-05-25 08:26:56+00 2018-05-25 08:26:56+00
1133housing Municipal rent subsidies The aim of rent subsidies is twofold. Firstly, to keep people in their habitual abode, as this ensures they get to stay in familiar surroundings and prevents them from going through the trauma of losing their home. Secondly, when a person loses their habitual abode due to eviction and foreclosure processes, they are provided with a new rental contract and financial help.\nMunicipal rent subsidies are a financial support mechanism for tenants in financial difficulty who are struggling to meet their monthly rent payments. This financial help, which is awarded following mediation between the parties in question and the City Council, enables the tenant to keep their home and avoid social exclusion.\nThese subsidies are intended for anyone who lives in Barcelona who has a rental contract and that rented accommodation is their habitual abode and permanent home.\n \N text f 13 2018-05-25 08:27:57+00 2018-05-25 08:27:57+00
1134housing Mediation and advice services to ensure access to a decent home Barcelona City Council and the Generalitat of Catalonia, through the Barcelona Housing Consortium, offer citizens mediation and advice services to help ensure everyone has access to a decent home.\n\nThese information services help citizens to understand the situation they are in and ensure they receive the advice and support they need. The Housing Offices offer a mediation service between the property owner (landlord) and the tenant, in cases where, due to financial difficulties (non-payment, arrears, legal action) the tenant is at risk of being evicted. \N text f 14 2018-05-25 08:28:56+00 2018-05-25 08:28:56+00
1135housing Areas and neighbourhoods in the city with specific grants Renovation is one of the key tools for tackling social inequalities. Poorly maintained buildings can damage the health of residents and damage their homes. This leads to a deterioration in public space and has a negative impact on the quality of life of the community.\n\nFor this reason, the Barcelona Housing Consortium (Barcelona City Council and the Generalitat of Catalonia) offers renovation grants. These grants are for renovating the interior of the home, improving habitability and accessibility to ensure a healthy, efficient home.\n\nThe last call had a budget of 46.6 million euros for housing renovation grants, with the aim of guaranteeing decent housing for all citizens. The 2017 restoration grants included the following areas with special grants:\n\nTuró de la Peira\nSud-Oest del Besòs and Baró de Viver\nCan Clos\nCiutat Meridiana\nCiutat Vella (buildings included on the Pla Dintres and the Restoration and preservation are of Sant Ramon and Robador)\nIlla Eficient (streets Viladomat-Gran Via de les Corts Catalanes-Calà bria-Diputació)\nIn 2016, renovation grants were awarded to some 12.337 families in 790 buildings. Visit any of the Housing Offices for more information on housing renovation grants. \N text f 15 2018-05-25 08:29:58+00 2018-05-25 08:29:58+00
1136work Spanish retirement age Since 2013 the legal retirement age is 67 years or 65 years when you have credited 38 years and 6 months of quotation.\nThe total number of years quoted will be the sum of years registered in the spanish Social Security.\n\nThe complete information can be found in the link below:\nhttp://www.seg-social.es/Internet_1/Trabajadores/PrestacionesPension10935/Jubilacion/RegimenGeneral/Jubilacionordinaria/Requisitos/177422\n \N text f 16 2018-05-25 08:31:10+00 2018-05-25 08:31:10+00
1137work Requirements to work in Spanish territory if you aren't a Europe citizen You need to apply for an official authorization that allows you to work in Spain.\n\nThe requirements are the following:\n Not to be found irregularly in Spanish territory.\n Have no criminal records.\n Not to have prohibited entering in Spain.\n Not to be found, as the case may be, within the term of commitment of non-return to Spain that the foreigner has assumed upon voluntary return to his / her country of origin.\nThe conditions established in the work contract must be adjusted to those established by current regulations.\nPresent a contract signed by the employer and the worker that guarantees the worker a continuous activity during the period of validity of the authorization to reside and work.\nThe applicant employer must be enrolled in the Social Security system and be up to date with compliance of their tax obligations and Social Security.\nPossess the training and, where appropriate, the professional qualification legally required for the exercise of the profession.\n \N text f 17 2018-05-25 08:31:46+00 2018-05-25 08:31:46+00
1138work Working in Spanish territory as a EU citizen Regulation 492/2011 establishes, in its second paragraph, that "The free movement of workers within the Union must be ensured." The achievement of this objective implies the abolition, the workers of the Member States of any discrimination for the reason of being with right to employment, remuneration and other working conditions, as well as the right of these workers to perform a salaried activity, without prejudice to the limitations justified for reasons of public order, safety and public health ".\n\nThe right of the citizens implies the possibility of exercising a work activity even if it does not reside in the member state in which it lives. It goes, therefore, beyond the right to move, reside and work in the host State.\nThe EU free movement regime (EU citizens) also includes citizens of third countries like the Swiss Confederation.\n\nLong story short, EU citizens have full access to employment in Spanish national territory and also to bring with them their relatives only if they accomplish the EU legislation as well.\n \N text f 18 2018-05-25 08:32:28+00 2018-05-25 08:32:28+00
1139work The residence and work permit and the TIE To work in Spain, as in many other countries, a visa is required. If your intention is to stay for a time longer than 90 days (they do not have to be consecutive), you must process it. Depending on your country and the agreements you have established with Spain, it may be your turn to process a short-term visa (Schengen visa) first.\nThere are several types of visas or permits (study, work, residence and transit) and each one requires to fulfill a series of conditions. For anyone who requests, your passport must be in order at the time of the request.\nTo work, they will ask you for a residence and work permit . You must process it through the Consulate General of Spain in your country. If you are granted permission, it will be with respect to a specific geographical area and a specific occupation. It will be worth it for a year, but when it expires it can be extended.\nWhen you have a residence and work visa, you must apply for the Foreigner Identity Card (TIE) in the Provincial Immigration and Documentation Brigade of the region in which you are. \N text f 19 2018-05-25 08:32:57+00 2018-05-25 08:32:57+00
1140work The NIE and the Social Security number The foreign identity number (NIE) is the number that will identify you as a resident alien. You can request it from the General Directorate of the Police, if you are already in Spain in a regular situation, or through the consular office of Spain in your country.\nAnother document that you should know is the number of affiliation to the Social Security . It is required to be registered in the Social Security to make a work contract. You can carry out this procedure in an office of the Treasury of the Social Security, but it is convenient that you inform about conditions and requirements in the website of the Ministry of Employment and Social Security .\n \N text f 20 2018-05-25 08:33:22+00 2018-05-25 08:33:22+00
1141work Health in Spain In Spain, the National Health System (SNS) gives public coverage to members of the Social Security. Healthcare in Spain is a competence that is managed through the autonomous communities, there is no single body in which all the management is centralized. For this reason, when you are in Spain it is recommended that you go to the nearest health center. They will inform you about how to process the Individual Health Card .\nIf your country belongs to the European Union or has a bilateral agreement with Spain, as in the case of Morocco, Tunisia, Peru, Brazil or Chile, to receive health care it is sufficient that you present the European Health Card or the right certificate to the health care that corresponds to you according to your particular situation.\n \N text f 21 2018-05-25 08:34:06+00 2018-05-25 08:34:06+00
1142work Practical issues One of the first steps you must do as soon as you arrive in Spain is to register yourself, that is, to register in the Register , which accredits you as a resident of the municipality where you reside. For this you need to establish an address. It is not necessary that it be your property, it can be rented or the house of your relatives, if it is where you are going to stay to live. This procedure is carried out in the city council that corresponds to you.\nWhen renting an apartment , it is very possible that you request an endorsement that demonstrates that you will be able to face the rent payment. The usual thing is that they ask for the last payroll of your work. It is also common that they ask you for a month in advance for bail. When you change your address, they will return the deposit if the site is in the agreed conditions when the contract was signed. Another possibility is to rent a room in a shared apartment. In this case, the requirements are reduced.\nOpening a bank account is another of the first tasks that you must carry out as soon as you arrive. If you are resentful, they will ask for the NIE and, if you are not, you must present a certificate of non-residency, which is requested in a National Police station.\n \N text f 22 2018-05-25 08:34:39+00 2018-05-25 08:34:39+00
1143education and formation Study Rooms If you’ve got to study, Barcelona takes away the hard slog. There are a lot of places where you can go to study and make the best of your time. Here we give you some of the most interesting study rooms, and below you have an url to a map with locations of all the study rooms in the city ,with real time information that we recommend you to take a look.\n\nEixample\n— Sala de estudio Sagrada FamÃlia \n– Josep M. Ainaud de Lasarte\n C. Provença, 480 (Biblioteca Sagrada FamÃlia)\n— Sala de estudio Esquerra de l’Eixample\n C. Comte d’Urgell, 145 (Centro CÃvico Urgell)\n\nSants-Montjuïc\n— Sala de estudio Vapor Vell\n C. Joan Güell, 14-22 (Biblioteca Vapor Vell)\n— Sala de estudio Francesc Boix\n C. Blai, 34 (Biblioteca Francesc Boix)\n— Sala de estudio Francesc Candel\n C. Amnistia Internacional, 10 (Biblioteca Francesc Candel)\n\nLes Corts\n— Sala de estudio Riera Blanca\n C. Riera Blanca, 1-3 (Centro CÃvico Josep M. Trias i Peitx)\n— Sala de estudio Les Corts\n C. FÃgols, 23-25 (Espacio de Personas Mayores Les Corts)\n\nGrà cia\n— Sala de estudio Vila de Grà cia\n C. Torrent de l’Olla, 104 (Biblioteca Vila de Grà cia)\n— Sala de estudio Jaume Fuster\n Pl. Lesseps, 20 (Biblioteca Jaume Fuster)\n\nNou Barris\n— Sala de estudio Casa Basté\n Pº. Fabra i Puig, 274 (Centro CÃvico Can Basté)\n— Sala de estudio Les Roquetes\n C. VÃa Favència, 288 B (Biblioteca Las Roquetes)\n— Sala de estudio Nou Barris\n Pl. Major de Nou Barris, 2 (Biblioteca Nou Barris)\n— Sala de estudio Zona Nord\n C. Vallcivera, 3 bis (Biblioteca Zona Nord) http://ajuntament.barcelona.cat/joves/salesestudiintranet/mapa/ \N f 27 2018-05-25 09:03:44+00 2018-05-25 09:03:44+00
1144tourism Tariffs The scope of the Autoritat del Transport Metropolità integrated fare system covers a total of 253 municipalities, divided into six rings and various fare sectors. \nA single ticket permits the use of the transport needed to move from one place to another. It permits the change to the Barcelona suburban railway integrated network, Ferrocarrils de la Generalitat, the metro, bus and tram. \nAll tickets, as well as unlimited journey tickets, must be validated before boarding the train. Keep your ticket until you have left the station \nYou can use up to four different modes on each transfer, and time for transfers between them are:\n\n1 zona: 1 h 15 min\n\n2 zones: 1 h 30 min\n\n3 zones: 1 h 45min\n\n4 zones: 2 h\n\n5 zones: 2 h 15 min\n\n6 zones: 2 h 30 min\n null text t 28 2018-05-25 10:02:00+00 2018-06-17 01:59:59+00
1145\.
1146
1147
1148--
1149-- TOC entry 2269 (class 0 OID 40854)
1150-- Dependencies: 191
1151-- Data for Name: languagecode; Type: TABLE DATA; Schema: public; Owner: server
1152--
1153
1154COPY public.languagecode (name, code, id, "createdAt", "updatedAt") FROM stdin;
1155Italian it 230148 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1156Latvian lv 230158 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1157Norwegian no 230168 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1158Romanian ro 230176 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1159Spanish es 230186 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1160Thai th 230196 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1161Urdu ur 230202 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1162Irish ga 230146 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1163Latin la 230156 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1164Maltese mt 230166 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1165English en 230175 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1166French fr 230185 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1167Gujarati gu 230195 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1168Hindi hi 230201 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1169Korean ko 230154 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1170Malay ms 230164 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1171Portuguese pt 230174 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1172Slovenian sl 230184 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1173Telugu te 230194 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1174Yiddish yi 230208 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1175Arabic ar 230149 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1176Bulgarian bg 230159 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1177Czech cs 230169 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1178Estonian et 230179 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1179Galician gl 230187 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1180Haitian Creole ht 230197 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1181Hungarian hu 230203 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1182Azerbaijani az 230151 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1183Macedonian mk 230162 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1184Dutch nl 230173 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1185Finnish fi 230183 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1186Greek el 230193 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1187Icelandic is 230205 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1188Albanian sq 230147 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1189Belarusian be 230157 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1190Croatian hr 230167 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1191Esperanto eo 230177 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1192Swahili sw 230188 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1193Turkish tr 230198 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1194Vietnamese vi 230204 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1195Basque eu 230153 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1196Lithuanian lt 230160 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1197Persian fa 230170 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1198Serbian sr 230180 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1199Tamil ta 230192 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1200Indonesian id 230207 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1201Afrikaans af 230145 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1202Bengali bn 230155 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1203Chinese Traditional zh-TW 230165 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1204Russian ru 230178 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1205Georgian ka 230189 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1206Hebrew iw 230199 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1207Japanese ja 230150 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1208Chinese Simplified zh-CN 230163 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1209Polish pl 230172 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1210Slovak sk 230182 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1211Swedish sv 230190 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1212Ukrainian uk 230200 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1213Kannada kn 230152 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1214Catalan ca 230161 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1215Danish da 230171 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1216Filipino tl 230181 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1217German de 230191 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1218Welsh cy 230206 2018-06-14 02:59:59+00 2018-06-14 02:59:59+00
1219\.
1220
1221
1222--
1223-- TOC entry 2271 (class 0 OID 40865)
1224-- Dependencies: 193
1225-- Data for Name: message; Type: TABLE DATA; Schema: public; Owner: server
1226--
1227
1228COPY public.message (content, "user", "belongsTo", id, "createdAt", "updatedAt") FROM stdin;
1229Hi, I'm interested in the Spanish lessons. Can I get more info? Thanks! i@k.com 1 1 2018-06-13 18:15:25+00 2018-06-13 18:15:25+00
1230Hola alex@alex.cat 2 2 2018-06-14 15:56:40+00 2018-06-14 15:56:40+00
1231Cómo va el Erasmus? alex@alex.cat 2 3 2018-06-14 16:08:43+00 2018-06-14 16:08:43+00
1232Muy bien alex.armengou@gmail.com 2 4 2018-06-14 16:51:04+00 2018-06-14 16:51:04+00
1233Me alegro alex@alex.cat 2 5 2018-06-14 16:58:06+00 2018-06-14 16:58:06+00
1234I can send you more information by mail nuria@gmail.com 1 6 2018-06-14 17:12:43+00 2018-06-14 17:12:43+00
1235I promise we won't send you spam nuria@gmail.com 1 7 2018-06-14 17:16:13+00 2018-06-14 17:16:13+00
1236Ok, my mail is isakody@gmail.com. Thank you! i@k.com 1 8 2018-06-14 17:21:52+00 2018-06-14 17:21:52+00
1237te hate you la vida borjafruizdelgado@gmail.com 4 9 2018-06-14 18:20:34+00 2018-06-14 18:20:34+00
1238:( nuria@gmail.com 4 10 2018-06-14 18:20:44+00 2018-06-14 18:20:44+00
1239Hi alex.armengou@gmail.com 5 11 2018-06-15 13:30:18+00 2018-06-15 13:30:18+00
1240I am really interested in the language exchange alex.armengou@gmail.com 5 12 2018-06-15 13:31:32+00 2018-06-15 13:31:32+00
1241Ooh such a fast reply guillem.bonet@gmail.com 5 13 2018-06-15 13:32:33+00 2018-06-15 13:32:33+00
1242I was thinking about a coffe, you can practica your Spanish and I can practice my English ;) guillem.bonet@gmail.com 5 14 2018-06-15 13:33:24+00 2018-06-15 13:33:24+00
1243😂 guillem.bonet@gmail.com 5 15 2018-06-15 13:33:32+00 2018-06-15 13:33:32+00
1244hola Núria albacanete97@gmail.com 6 16 2018-06-15 14:43:04+00 2018-06-15 14:43:04+00
1245perquè el teu pais és Andorra i no Catalunya? albacanete97@gmail.com 6 17 2018-06-15 14:43:25+00 2018-06-15 14:43:25+00
1246os habéis rendio? albacanete97@gmail.com 6 18 2018-06-15 14:43:35+00 2018-06-15 14:43:35+00
1247hola :-) eloiroca97@gmail.com 7 19 2018-06-15 14:59:18+00 2018-06-15 14:59:18+00
1248soy el profe de ecsdi ;-) eloiroca97@gmail.com 7 20 2018-06-15 14:59:30+00 2018-06-15 14:59:30+00
1249encantada :-3 i@k.com 7 21 2018-06-15 15:01:22+00 2018-06-15 15:01:22+00
1250ahora si eloiroca97@gmail.com 7 22 2018-06-15 15:03:28+00 2018-06-15 15:03:28+00
1251hey eloiroca97@gmail.com 7 23 2018-06-15 16:36:01+00 2018-06-15 16:36:01+00
1252todo correcto? eloiroca97@gmail.com 7 24 2018-06-15 20:25:12+00 2018-06-15 20:25:12+00
1253I tu ets burra? nuria@gmail.com 6 25 2018-06-15 20:27:57+00 2018-06-15 20:27:57+00
1254\.
1255
1256
1257--
1258-- TOC entry 2273 (class 0 OID 40876)
1259-- Dependencies: 195
1260-- Data for Name: thread; Type: TABLE DATA; Schema: public; Owner: server
1261--
1262
1263COPY public.thread (title, content, category, "postedBy", "numberReports", "numberVotes", id, "createdAt", "updatedAt") FROM stdin;
1264Free Spanish lessons Send me a message for more information language nuria@gmail.com 0 1 4 2018-06-13 18:12:10+00 2018-06-13 18:13:28+00
1265Sónar 2018 Sónar is a three-day electronic and advanced music festival. It takes place in Barcelona June 14-16th culture alex.armengou@gmail.com 0 4 1 2018-06-13 15:24:45+00 2018-06-14 22:26:03+00
1266Where to find shared flats? Hi, I'm new to the city and I'm looking for a shared flat as rent prices are super high!\nCan anyone recommend me where to look? housing guillem.bonet@gmail.com 0 0 7 2018-06-15 13:25:40+00 2018-06-15 13:25:40+00
1267Language exchange I'm looking for a native English speaker to hang out, I can teach you Spanish while you teach me English!! language guillem.bonet@gmail.com 0 1 6 2018-06-15 13:23:11+00 2018-06-15 13:30:00+00
1268Free Jazz session in Parc Güell In the 22nd of June you can attend a Jazz session for free in Parc Güell.\nGili-Romero Hot Jazz Cats will be playing ;) culture guillem.bonet@gmail.com 0 0 8 2018-06-15 13:31:30+00 2018-06-15 13:31:30+00
1269Qué harÃas si te tocara la loterÃa? Pues eso off topic omarcruz11@hotmail.com 0 0 9 2018-06-15 14:33:30+00 2018-06-15 14:33:30+00
1270Hike and Calçotada! We’ll hike the mountain behind the city for breathtaking views, and when we’ve worked up an appetite, we’ll enjoy a huge local meal (if you’re here in the Spring, we’ll try traditional calçots!) culture i@k.com 0 2 5 2018-06-15 10:00:49+00 2018-06-15 14:58:32+00
1271Documentation needed to apply for a job What documents do I need to work in Spain? public administration albacanete97@gmail.com 0 1 10 2018-06-15 14:45:00+00 2018-06-15 17:46:32+00
1272Demo We are doing a demo culture i@k.com 1 3 11 2018-06-15 16:39:34+00 2018-06-15 20:59:00+00
1273\.
1274
1275
1276--
1277-- TOC entry 2288 (class 0 OID 40963)
1278-- Dependencies: 210
1279-- Data for Name: thread_reportedby__user_reports; Type: TABLE DATA; Schema: public; Owner: server
1280--
1281
1282COPY public.thread_reportedby__user_reports (id, "thread_reportedBy", user_reports) FROM stdin;
12831 11 a@mail.com
1284\.
1285
1286
1287--
1288-- TOC entry 2286 (class 0 OID 40952)
1289-- Dependencies: 208
1290-- Data for Name: thread_votedby__user_votes; Type: TABLE DATA; Schema: public; Owner: server
1291--
1292
1293COPY public.thread_votedby__user_votes (id, "thread_votedBy", user_votes) FROM stdin;
12941 4 nuria@gmail.com
12952 1 nuria@gmail.com
12963 1 i@k.com
12974 1 guillem.bonet@gmail.com
12985 1 alex.armengou@gmail.com
12996 5 guillem.bonet@gmail.com
13007 6 alex.armengou@gmail.com
13018 5 eloiroca97@gmail.com
13029 11 eloiroca97@gmail.com
130310 11 nuria@gmail.com
130411 10 nuria@gmail.com
130512 11 a@mail.com
1306\.
1307
1308
1309--
1310-- TOC entry 2274 (class 0 OID 40885)
1311-- Dependencies: 196
1312-- Data for Name: user; Type: TABLE DATA; Schema: public; Owner: server
1313--
1314
1315COPY public."user" (email, username, password, name, surname, biography, birthday, country, rank, "profilePicture", "hasFacebook", "hasGoogle", deactivated, karma, "canChangePassword", "createdAt", "updatedAt") FROM stdin;
1316omar5 Cr0s4k5 $2a$10$qc3/5iKUN56dImN6thq4uOrMpzndswJoz1iVeqQuDUl0mAnbNYNUC \N \N \N \N \N coal \N f f f 0 \N 2018-06-14 16:54:53+00 2018-06-14 16:54:53+00
1317guillem.bonet@gmail.com bunetz $2a$10$W5FuMj0Bv5AhG9/nC.lHK.16BZGs52UD1Pa2VWVvBIJlqAtuSL/T. Guillem Bonet I like trains 07/05/1997 Spain coal 8 f t f 320 \N 2018-06-14 16:44:57+00 2018-06-15 13:31:30+00
1318omarcruz11@hotmail.com Omar97 $2a$10$fq2oyEAG2GFZIwhBPUUpL.Ftzi98XgqXSX5iCiYsNbX4QMAWh29tS Omar Garcia \N 14/06/1997 Afghanistan coal 8 t f f 100 f 2018-06-14 19:32:46+00 2018-06-15 14:33:30+00
1319borjafruizdelgado@gmail.com soyUnaPatata $2a$10$k1RcCPhiOEv.ssS9jTQ2nuOsa0voSNj7Vy2t2CgUvDdbkXvZld4B. Borja Fernández Soy una patata frita con sal 01/06/1900 Israel coal 6 f f f 0 t 2018-06-14 18:19:28+00 2018-06-15 14:53:42+00
1320eloiroca97@gmail.com eloiiroca $2a$10$cPR1/8ud56HeBvtXmlB0VO3F2URsUJO90j5kJSUSdh7ArPrvd9RrS Eloi Roca Em dic eloi jeje 22/07/1997 Isle of Man coal 1 f t f 20 f 2018-06-15 14:32:43+00 2018-06-15 16:39:58+00
1321nico@hotmail.com nicotest $2a$10$aSokLBbw2Rr3Ny2tTM5QVeDEEmYa7vblnh446Lv8A8Bsi42QHNUl6 Nico Test \N 16/06/1992 Afghanistan coal 7 f f f 0 t 2018-06-16 12:12:15+00 2018-06-16 12:19:58+00
1322i@k.com isakody $2a$10$wJHR6.z6SS/WmgB2YeEije6oxgWn5sA3gfbtWIyEZDIW6XJLJr3Ma Isabel Codina Hello I'm Isabel 15/06/1988 Afghanistan coal 4 f f f 370 \N 2018-06-13 15:20:06+00 2018-06-15 16:47:13+00
1323isakody@gmail.com IsakodyMail $2a$10$lWIHWkTliZlKgjKTnq2DO.PJtkFlB0z8ay9tiH0GzDVE3KC/pW0mm Isabel Codina GarcÃa 14/06/1993 Belarus coal 7 f f f 10 t 2018-06-14 16:16:35+00 2018-06-15 16:48:48+00
1324nfrancisquelo2@gmail.com nico2 $2a$10$7P1dm4CkjVC66V5i8W4qoOASNn24Dg4ceNJ66.ji5CRNnxXonTU/2 Nicolás Francisquelo \N 02/09/1996 Argentina coal 3 t f f 0 f 2018-06-15 15:51:29+00 2018-06-15 15:51:29+00
1325eloi001@hotmail.es eloiete $2a$10$CxoaPwB9daIVhEYIIXxDGelO8DqtfaYkw2U1TgOqrEYUQPt/GNGhO Eloi Roca \N 19/06/1999 Afghanistan coal 7 t f f 0 f 2018-06-15 20:21:38+00 2018-06-15 20:21:38+00
1326alex@alex.cat alex $2a$10$IhI0ttKE1kjgQ7mMI6Ch8ennA0HUh.SNw96Sk9npHKMNHzIiGr2Da Alex Armengou \N 04/06/1919 Congo coal 5 f f f 0 \N 2018-06-13 15:33:57+00 2018-06-15 20:24:24+00
1327alex.armengou@gmail.com ram $2a$10$vfPD3.XcSvjI6yDftL4SHuQYCRYGKTF7RW5Tsgy4tKJ/yI3343cni Alex Armengou \N 01/08/1996 Argentina coal 2 t f f 110 \N 2018-06-13 15:14:41+00 2018-06-15 20:24:24+00
1328albacanete97@gmail.com alba $2a$10$7c.PeTxko274pVdM1EgfieWZthBITSH4sg.RFoQ11fAlEG0yPoOYW Alba Cañete 12/08/1997 Spain coal 4 f f f 100 t 2018-06-15 14:38:16+00 2018-06-15 20:27:36+00
1329nuria@gmail.com Nuria $2a$10$MsFgZfFJdvbp18adKfsVjONRN8Kmjy8YxjYjOYhewExkGOMHgg386 Nuria Bruch Hi! :) 16/10/1997 Andorra coal 3 f f f 110 \N 2018-06-13 15:19:20+00 2018-06-15 20:27:36+00
1330a@mail.com a $2a$10$JKRLzaVGiYLklzYOxSGbkONAedK6dpkiUdsKpTnbC65XTWiVIsmXC adria puigdellivol \N 15/06/1901 Mozambique coal 7 f f f 20 t 2018-06-15 20:57:22+00 2018-06-15 20:59:15+00
1331\.
1332
1333
1334--
1335-- TOC entry 2290 (class 0 OID 40974)
1336-- Dependencies: 212
1337-- Data for Name: user_blockedbyuser__user_blocksuser; Type: TABLE DATA; Schema: public; Owner: server
1338--
1339
1340COPY public.user_blockedbyuser__user_blocksuser (id, "user_blocksUser", "user_blockedByUser") FROM stdin;
13412 nuria@gmail.com borjafruizdelgado@gmail.com
13426 i@k.com nuria@gmail.com
13437 alex.armengou@gmail.com alex@alex.cat
1344\.
1345
1346
1347--
1348-- TOC entry 2278 (class 0 OID 40908)
1349-- Dependencies: 200
1350-- Data for Name: valorationfaq; Type: TABLE DATA; Schema: public; Owner: server
1351--
1352
1353COPY public.valorationfaq (faq, "user", valoration, id, "createdAt", "updatedAt") FROM stdin;
13541 guillem.bonet@gmail.com 4 1 2018-06-13 19:36:00+00 2018-06-13 19:36:00+00
13552 guillem.bonet@gmail.com 3 2 2018-06-13 19:36:06+00 2018-06-13 19:36:06+00
13563 guillem.bonet@gmail.com 4 3 2018-06-13 19:36:11+00 2018-06-13 19:36:11+00
13574 guillem.bonet@gmail.com 5 4 2018-06-13 19:36:17+00 2018-06-13 19:36:17+00
13585 guillem.bonet@gmail.com 3 5 2018-06-13 19:36:23+00 2018-06-13 19:36:23+00
13596 guillem.bonet@gmail.com 4 6 2018-06-13 19:36:27+00 2018-06-13 19:36:27+00
13607 guillem.bonet@gmail.com 1 7 2018-06-13 19:39:39+00 2018-06-13 19:39:39+00
13618 guillem.bonet@gmail.com 3 8 2018-06-13 19:39:44+00 2018-06-13 19:39:44+00
13629 guillem.bonet@gmail.com 4 9 2018-06-13 19:39:50+00 2018-06-13 19:39:50+00
136310 guillem.bonet@gmail.com 4 10 2018-06-13 19:39:55+00 2018-06-13 19:39:55+00
136411 guillem.bonet@gmail.com 3 11 2018-06-13 19:40:00+00 2018-06-13 19:40:00+00
136512 guillem.bonet@gmail.com 2 12 2018-06-13 19:40:05+00 2018-06-13 19:40:05+00
136613 guillem.bonet@gmail.com 3 13 2018-06-13 19:40:09+00 2018-06-13 19:40:09+00
136714 guillem.bonet@gmail.com 4 14 2018-06-13 19:40:14+00 2018-06-13 19:40:14+00
136815 guillem.bonet@gmail.com 3 15 2018-06-13 19:40:20+00 2018-06-13 19:40:20+00
13691 alex.armengou@gmail.com 3 16 2018-06-14 08:55:40+00 2018-06-14 08:55:44+00
13702 i@k.com 5 19 2018-06-14 17:06:01+00 2018-06-14 17:19:16+00
13711 nuria@gmail.com 5 17 2018-06-14 17:02:23+00 2018-06-14 18:33:11+00
13725 borjafruizdelgado@gmail.com 0 20 2018-06-14 18:48:08+00 2018-06-14 18:48:08+00
13733 borjafruizdelgado@gmail.com 5 21 2018-06-14 18:50:17+00 2018-06-14 18:50:17+00
13744 i@k.com 4 22 2018-06-15 11:12:54+00 2018-06-15 11:13:53+00
137516 omarcruz11@hotmail.com 4 23 2018-06-15 14:32:06+00 2018-06-15 14:32:06+00
137617 eloiroca97@gmail.com 5 24 2018-06-15 14:33:51+00 2018-06-15 14:34:12+00
13771 eloiroca97@gmail.com 5 25 2018-06-15 14:34:47+00 2018-06-15 14:35:07+00
13781 albacanete97@gmail.com 4 26 2018-06-15 15:00:18+00 2018-06-15 15:00:18+00
13795 albacanete97@gmail.com 4 27 2018-06-15 15:00:29+00 2018-06-15 15:00:29+00
138018 eloiroca97@gmail.com 5 28 2018-06-15 15:57:06+00 2018-06-15 15:57:06+00
13811 i@k.com 5 18 2018-06-14 17:05:23+00 2018-06-15 16:41:57+00
138218 nuria@gmail.com 5 29 2018-06-15 16:42:18+00 2018-06-15 16:42:18+00
13831 nico@hotmail.com 4 30 2018-06-16 12:14:53+00 2018-06-16 12:15:18+00
1384\.
1385
1386
1387--
1388-- TOC entry 2276 (class 0 OID 40897)
1389-- Dependencies: 198
1390-- Data for Name: word; Type: TABLE DATA; Schema: public; Owner: server
1391--
1392
1393COPY public.word (word, definition, id, "createdAt", "updatedAt") FROM stdin;
1394córrer la Seca i la Meca Have seen everything, travel a lot of world; Go from one place to another, walk a lot, make long trips. 1 2018-06-13 14:54:20+00 2018-06-13 14:54:20+00
1395Catarroja descoberta! Valencian expression that originally refers to the fact that, unwillingly, something that was wanted to be kept secret was revealed or made public. 2 2018-06-14 10:49:09+00 2018-06-14 10:49:09+00
1396baixar d’Arbeca Do not be up to date, get off the garden. 3 2018-06-15 08:28:19+00 2018-06-15 08:28:19+00
1397\.
1398
1399
1400--
1401-- TOC entry 2315 (class 0 OID 0)
1402-- Dependencies: 181
1403-- Name: comment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1404--
1405
1406SELECT pg_catalog.setval('public.comment_id_seq', 16, true);
1407
1408
1409--
1410-- TOC entry 2316 (class 0 OID 0)
1411-- Dependencies: 201
1412-- Name: comment_reportedby__user_reportedcomments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1413--
1414
1415SELECT pg_catalog.setval('public.comment_reportedby__user_reportedcomments_id_seq', 4, true);
1416
1417
1418--
1419-- TOC entry 2317 (class 0 OID 0)
1420-- Dependencies: 203
1421-- Name: comment_votedby__user_votedcomments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1422--
1423
1424SELECT pg_catalog.setval('public.comment_votedby__user_votedcomments_id_seq', 15, true);
1425
1426
1427--
1428-- TOC entry 2318 (class 0 OID 0)
1429-- Dependencies: 183
1430-- Name: conversation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1431--
1432
1433SELECT pg_catalog.setval('public.conversation_id_seq', 9, true);
1434
1435
1436--
1437-- TOC entry 2319 (class 0 OID 0)
1438-- Dependencies: 186
1439-- Name: faq_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1440--
1441
1442SELECT pg_catalog.setval('public.faq_id_seq', 22, true);
1443
1444
1445--
1446-- TOC entry 2320 (class 0 OID 0)
1447-- Dependencies: 205
1448-- Name: faq_reportedby__user_reportedfaq_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1449--
1450
1451SELECT pg_catalog.setval('public.faq_reportedby__user_reportedfaq_id_seq', 14, true);
1452
1453
1454--
1455-- TOC entry 2321 (class 0 OID 0)
1456-- Dependencies: 188
1457-- Name: information_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1458--
1459
1460SELECT pg_catalog.setval('public.information_id_seq', 28, true);
1461
1462
1463--
1464-- TOC entry 2322 (class 0 OID 0)
1465-- Dependencies: 190
1466-- Name: languagecode_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1467--
1468
1469SELECT pg_catalog.setval('public.languagecode_id_seq', 230208, true);
1470
1471
1472--
1473-- TOC entry 2323 (class 0 OID 0)
1474-- Dependencies: 192
1475-- Name: message_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1476--
1477
1478SELECT pg_catalog.setval('public.message_id_seq', 25, true);
1479
1480
1481--
1482-- TOC entry 2324 (class 0 OID 0)
1483-- Dependencies: 194
1484-- Name: thread_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1485--
1486
1487SELECT pg_catalog.setval('public.thread_id_seq', 11, true);
1488
1489
1490--
1491-- TOC entry 2325 (class 0 OID 0)
1492-- Dependencies: 209
1493-- Name: thread_reportedby__user_reports_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1494--
1495
1496SELECT pg_catalog.setval('public.thread_reportedby__user_reports_id_seq', 1, true);
1497
1498
1499--
1500-- TOC entry 2326 (class 0 OID 0)
1501-- Dependencies: 207
1502-- Name: thread_votedby__user_votes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1503--
1504
1505SELECT pg_catalog.setval('public.thread_votedby__user_votes_id_seq', 12, true);
1506
1507
1508--
1509-- TOC entry 2327 (class 0 OID 0)
1510-- Dependencies: 211
1511-- Name: user_blockedbyuser__user_blocksuser_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1512--
1513
1514SELECT pg_catalog.setval('public.user_blockedbyuser__user_blocksuser_id_seq', 7, true);
1515
1516
1517--
1518-- TOC entry 2328 (class 0 OID 0)
1519-- Dependencies: 199
1520-- Name: valorationfaq_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1521--
1522
1523SELECT pg_catalog.setval('public.valorationfaq_id_seq', 30, true);
1524
1525
1526--
1527-- TOC entry 2329 (class 0 OID 0)
1528-- Dependencies: 197
1529-- Name: word_id_seq; Type: SEQUENCE SET; Schema: public; Owner: server
1530--
1531
1532SELECT pg_catalog.setval('public.word_id_seq', 3, true);
1533
1534
1535--
1536-- TOC entry 2110 (class 2606 OID 40810)
1537-- Name: comment comment_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1538--
1539
1540ALTER TABLE ONLY public.comment
1541 ADD CONSTRAINT comment_pkey PRIMARY KEY (id);
1542
1543
1544--
1545-- TOC entry 2134 (class 2606 OID 40927)
1546-- Name: comment_reportedby__user_reportedcomments comment_reportedby__user_reportedcomments_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1547--
1548
1549ALTER TABLE ONLY public.comment_reportedby__user_reportedcomments
1550 ADD CONSTRAINT comment_reportedby__user_reportedcomments_pkey PRIMARY KEY (id);
1551
1552
1553--
1554-- TOC entry 2136 (class 2606 OID 40938)
1555-- Name: comment_votedby__user_votedcomments comment_votedby__user_votedcomments_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1556--
1557
1558ALTER TABLE ONLY public.comment_votedby__user_votedcomments
1559 ADD CONSTRAINT comment_votedby__user_votedcomments_pkey PRIMARY KEY (id);
1560
1561
1562--
1563-- TOC entry 2112 (class 2606 OID 40821)
1564-- Name: conversation conversation_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1565--
1566
1567ALTER TABLE ONLY public.conversation
1568 ADD CONSTRAINT conversation_pkey PRIMARY KEY (id);
1569
1570
1571--
1572-- TOC entry 2114 (class 2606 OID 40829)
1573-- Name: currency currency_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1574--
1575
1576ALTER TABLE ONLY public.currency
1577 ADD CONSTRAINT currency_pkey PRIMARY KEY (name);
1578
1579
1580--
1581-- TOC entry 2116 (class 2606 OID 40840)
1582-- Name: faq faq_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1583--
1584
1585ALTER TABLE ONLY public.faq
1586 ADD CONSTRAINT faq_pkey PRIMARY KEY (id);
1587
1588
1589--
1590-- TOC entry 2138 (class 2606 OID 40949)
1591-- Name: faq_reportedby__user_reportedfaq faq_reportedby__user_reportedfaq_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1592--
1593
1594ALTER TABLE ONLY public.faq_reportedby__user_reportedfaq
1595 ADD CONSTRAINT faq_reportedby__user_reportedfaq_pkey PRIMARY KEY (id);
1596
1597
1598--
1599-- TOC entry 2118 (class 2606 OID 40851)
1600-- Name: information information_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1601--
1602
1603ALTER TABLE ONLY public.information
1604 ADD CONSTRAINT information_pkey PRIMARY KEY (id);
1605
1606
1607--
1608-- TOC entry 2120 (class 2606 OID 40862)
1609-- Name: languagecode languagecode_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1610--
1611
1612ALTER TABLE ONLY public.languagecode
1613 ADD CONSTRAINT languagecode_pkey PRIMARY KEY (id);
1614
1615
1616--
1617-- TOC entry 2122 (class 2606 OID 40873)
1618-- Name: message message_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1619--
1620
1621ALTER TABLE ONLY public.message
1622 ADD CONSTRAINT message_pkey PRIMARY KEY (id);
1623
1624
1625--
1626-- TOC entry 2124 (class 2606 OID 40884)
1627-- Name: thread thread_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1628--
1629
1630ALTER TABLE ONLY public.thread
1631 ADD CONSTRAINT thread_pkey PRIMARY KEY (id);
1632
1633
1634--
1635-- TOC entry 2142 (class 2606 OID 40971)
1636-- Name: thread_reportedby__user_reports thread_reportedby__user_reports_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1637--
1638
1639ALTER TABLE ONLY public.thread_reportedby__user_reports
1640 ADD CONSTRAINT thread_reportedby__user_reports_pkey PRIMARY KEY (id);
1641
1642
1643--
1644-- TOC entry 2140 (class 2606 OID 40960)
1645-- Name: thread_votedby__user_votes thread_votedby__user_votes_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1646--
1647
1648ALTER TABLE ONLY public.thread_votedby__user_votes
1649 ADD CONSTRAINT thread_votedby__user_votes_pkey PRIMARY KEY (id);
1650
1651
1652--
1653-- TOC entry 2144 (class 2606 OID 40982)
1654-- Name: user_blockedbyuser__user_blocksuser user_blockedbyuser__user_blocksuser_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1655--
1656
1657ALTER TABLE ONLY public.user_blockedbyuser__user_blocksuser
1658 ADD CONSTRAINT user_blockedbyuser__user_blocksuser_pkey PRIMARY KEY (id);
1659
1660
1661--
1662-- TOC entry 2126 (class 2606 OID 40892)
1663-- Name: user user_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1664--
1665
1666ALTER TABLE ONLY public."user"
1667 ADD CONSTRAINT user_pkey PRIMARY KEY (email);
1668
1669
1670--
1671-- TOC entry 2128 (class 2606 OID 40894)
1672-- Name: user user_username_key; Type: CONSTRAINT; Schema: public; Owner: server
1673--
1674
1675ALTER TABLE ONLY public."user"
1676 ADD CONSTRAINT user_username_key UNIQUE (username);
1677
1678
1679--
1680-- TOC entry 2132 (class 2606 OID 40916)
1681-- Name: valorationfaq valorationfaq_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1682--
1683
1684ALTER TABLE ONLY public.valorationfaq
1685 ADD CONSTRAINT valorationfaq_pkey PRIMARY KEY (id);
1686
1687
1688--
1689-- TOC entry 2130 (class 2606 OID 40905)
1690-- Name: word word_pkey; Type: CONSTRAINT; Schema: public; Owner: server
1691--
1692
1693ALTER TABLE ONLY public.word
1694 ADD CONSTRAINT word_pkey PRIMARY KEY (id);
1695
1696
1697--
1698-- TOC entry 2298 (class 0 OID 0)
1699-- Dependencies: 7
1700-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
1701--
1702
1703REVOKE ALL ON SCHEMA public FROM PUBLIC;
1704REVOKE ALL ON SCHEMA public FROM postgres;
1705GRANT ALL ON SCHEMA public TO postgres;
1706GRANT ALL ON SCHEMA public TO PUBLIC;
1707
1708
1709-- Completed on 2018-06-18 23:51:58 CEST
1710
1711--
1712-- PostgreSQL database dump complete
1713--