2C3m89u9

· 10 years ago · Dec 09, 2015, 10:27 AM
1--
2-- PostgreSQL database dump
3--
4
5SET statement_timeout = 0;
6SET lock_timeout = 0;
7SET client_encoding = 'UTF8';
8SET standard_conforming_strings = on;
9SET check_function_bodies = false;
10SET client_min_messages = warning;
11
12--
13-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
14--
15
16CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
17
18
19--
20-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
21--
22
23COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
24
25
26SET search_path = public, pg_catalog;
27
28SET default_tablespace = '';
29
30SET default_with_oids = false;
31
32--
33-- Name: assignments; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
34--
35
36CREATE TABLE assignments (
37    id integer NOT NULL,
38    tasks_flags integer DEFAULT 0 NOT NULL,
39    cost_cents integer,
40    start_date timestamp without time zone,
41    planned_end_date timestamp without time zone,
42    actual_end_date timestamp without time zone,
43    rating integer,
44    vendor_id integer NOT NULL,
45    project_id integer NOT NULL
46);
47
48
49ALTER TABLE public.assignments OWNER TO agufranov;
50
51--
52-- Name: assignments_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
53--
54
55CREATE SEQUENCE assignments_id_seq
56    START WITH 1
57    INCREMENT BY 1
58    NO MINVALUE
59    NO MAXVALUE
60    CACHE 1;
61
62
63ALTER TABLE public.assignments_id_seq OWNER TO agufranov;
64
65--
66-- Name: assignments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
67--
68
69ALTER SEQUENCE assignments_id_seq OWNED BY assignments.id;
70
71
72--
73-- Name: clients; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
74--
75
76CREATE TABLE clients (
77    id integer NOT NULL,
78    name character varying NOT NULL,
79    address text,
80    country_id integer
81);
82
83
84ALTER TABLE public.clients OWNER TO agufranov;
85
86--
87-- Name: clients_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
88--
89
90CREATE SEQUENCE clients_id_seq
91    START WITH 1
92    INCREMENT BY 1
93    NO MINVALUE
94    NO MAXVALUE
95    CACHE 1;
96
97
98ALTER TABLE public.clients_id_seq OWNER TO agufranov;
99
100--
101-- Name: clients_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
102--
103
104ALTER SEQUENCE clients_id_seq OWNED BY clients.id;
105
106
107--
108-- Name: conditions; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
109--
110
111CREATE TABLE conditions (
112    id integer NOT NULL,
113    name character varying NOT NULL
114);
115
116
117ALTER TABLE public.conditions OWNER TO agufranov;
118
119--
120-- Name: conditions_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
121--
122
123CREATE SEQUENCE conditions_id_seq
124    START WITH 1
125    INCREMENT BY 1
126    NO MINVALUE
127    NO MAXVALUE
128    CACHE 1;
129
130
131ALTER TABLE public.conditions_id_seq OWNER TO agufranov;
132
133--
134-- Name: conditions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
135--
136
137ALTER SEQUENCE conditions_id_seq OWNED BY conditions.id;
138
139
140--
141-- Name: countries; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
142--
143
144CREATE TABLE countries (
145    id integer NOT NULL,
146    name character varying NOT NULL,
147    code character varying
148);
149
150
151ALTER TABLE public.countries OWNER TO agufranov;
152
153--
154-- Name: countries_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
155--
156
157CREATE SEQUENCE countries_id_seq
158    START WITH 1
159    INCREMENT BY 1
160    NO MINVALUE
161    NO MAXVALUE
162    CACHE 1;
163
164
165ALTER TABLE public.countries_id_seq OWNER TO agufranov;
166
167--
168-- Name: countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
169--
170
171ALTER SEQUENCE countries_id_seq OWNED BY countries.id;
172
173
174--
175-- Name: languages; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
176--
177
178CREATE TABLE languages (
179    id integer NOT NULL,
180    name character varying NOT NULL,
181    native_name character varying,
182    code character varying
183);
184
185
186ALTER TABLE public.languages OWNER TO agufranov;
187
188--
189-- Name: languages_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
190--
191
192CREATE SEQUENCE languages_id_seq
193    START WITH 1
194    INCREMENT BY 1
195    NO MINVALUE
196    NO MAXVALUE
197    CACHE 1;
198
199
200ALTER TABLE public.languages_id_seq OWNER TO agufranov;
201
202--
203-- Name: languages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
204--
205
206ALTER SEQUENCE languages_id_seq OWNED BY languages.id;
207
208
209--
210-- Name: professions; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
211--
212
213CREATE TABLE professions (
214    id integer NOT NULL,
215    title character varying NOT NULL
216);
217
218
219ALTER TABLE public.professions OWNER TO agufranov;
220
221--
222-- Name: professions_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
223--
224
225CREATE SEQUENCE professions_id_seq
226    START WITH 1
227    INCREMENT BY 1
228    NO MINVALUE
229    NO MAXVALUE
230    CACHE 1;
231
232
233ALTER TABLE public.professions_id_seq OWNER TO agufranov;
234
235--
236-- Name: professions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
237--
238
239ALTER SEQUENCE professions_id_seq OWNED BY professions.id;
240
241
242--
243-- Name: project_managers; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
244--
245
246CREATE TABLE project_managers (
247    id integer NOT NULL,
248    name character varying NOT NULL,
249    email character varying,
250    address character varying,
251    client_id integer NOT NULL
252);
253
254
255ALTER TABLE public.project_managers OWNER TO agufranov;
256
257--
258-- Name: project_managers_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
259--
260
261CREATE SEQUENCE project_managers_id_seq
262    START WITH 1
263    INCREMENT BY 1
264    NO MINVALUE
265    NO MAXVALUE
266    CACHE 1;
267
268
269ALTER TABLE public.project_managers_id_seq OWNER TO agufranov;
270
271--
272-- Name: project_managers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
273--
274
275ALTER SEQUENCE project_managers_id_seq OWNED BY project_managers.id;
276
277
278--
279-- Name: projects; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
280--
281
282CREATE TABLE projects (
283    id integer NOT NULL,
284    number character varying,
285    project_id_client character varying,
286    words_count integer,
287    budget_cents integer,
288    status integer,
289    start_date timestamp without time zone,
290    planned_end_date timestamp without time zone,
291    actual_end_date timestamp without time zone,
292    comments text,
293    client_id integer,
294    project_manager_id integer,
295    country_id integer,
296    original_language_id integer,
297    target_language_id integer,
298    condition_id integer,
299    speciality_id integer
300);
301
302
303ALTER TABLE public.projects OWNER TO agufranov;
304
305--
306-- Name: projects_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
307--
308
309CREATE SEQUENCE projects_id_seq
310    START WITH 1
311    INCREMENT BY 1
312    NO MINVALUE
313    NO MAXVALUE
314    CACHE 1;
315
316
317ALTER TABLE public.projects_id_seq OWNER TO agufranov;
318
319--
320-- Name: projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
321--
322
323ALTER SEQUENCE projects_id_seq OWNED BY projects.id;
324
325
326--
327-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
328--
329
330CREATE TABLE schema_migrations (
331    version character varying NOT NULL
332);
333
334
335ALTER TABLE public.schema_migrations OWNER TO agufranov;
336
337--
338-- Name: specialities; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
339--
340
341CREATE TABLE specialities (
342    id integer NOT NULL,
343    title character varying NOT NULL
344);
345
346
347ALTER TABLE public.specialities OWNER TO agufranov;
348
349--
350-- Name: specialities_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
351--
352
353CREATE SEQUENCE specialities_id_seq
354    START WITH 1
355    INCREMENT BY 1
356    NO MINVALUE
357    NO MAXVALUE
358    CACHE 1;
359
360
361ALTER TABLE public.specialities_id_seq OWNER TO agufranov;
362
363--
364-- Name: specialities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
365--
366
367ALTER SEQUENCE specialities_id_seq OWNED BY specialities.id;
368
369
370--
371-- Name: vendor_countries; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
372--
373
374CREATE TABLE vendor_countries (
375    id integer NOT NULL,
376    vendor_id integer NOT NULL,
377    country_id integer NOT NULL
378);
379
380
381ALTER TABLE public.vendor_countries OWNER TO agufranov;
382
383--
384-- Name: vendor_countries_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
385--
386
387CREATE SEQUENCE vendor_countries_id_seq
388    START WITH 1
389    INCREMENT BY 1
390    NO MINVALUE
391    NO MAXVALUE
392    CACHE 1;
393
394
395ALTER TABLE public.vendor_countries_id_seq OWNER TO agufranov;
396
397--
398-- Name: vendor_countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
399--
400
401ALTER SEQUENCE vendor_countries_id_seq OWNED BY vendor_countries.id;
402
403
404--
405-- Name: vendor_languages; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
406--
407
408CREATE TABLE vendor_languages (
409    id integer NOT NULL,
410    vendor_id integer NOT NULL,
411    language_id integer NOT NULL,
412    proficiency integer
413);
414
415
416ALTER TABLE public.vendor_languages OWNER TO agufranov;
417
418--
419-- Name: vendor_languages_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
420--
421
422CREATE SEQUENCE vendor_languages_id_seq
423    START WITH 1
424    INCREMENT BY 1
425    NO MINVALUE
426    NO MAXVALUE
427    CACHE 1;
428
429
430ALTER TABLE public.vendor_languages_id_seq OWNER TO agufranov;
431
432--
433-- Name: vendor_languages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
434--
435
436ALTER SEQUENCE vendor_languages_id_seq OWNED BY vendor_languages.id;
437
438
439--
440-- Name: vendors; Type: TABLE; Schema: public; Owner: agufranov; Tablespace: 
441--
442
443CREATE TABLE vendors (
444    id integer NOT NULL,
445    name character varying NOT NULL,
446    mapi_code character varying,
447    tasks_flags integer DEFAULT 0 NOT NULL,
448    rate_hour_cents integer,
449    rate_interview_cents integer,
450    rate_word_cents integer,
451    comments text,
452    profession_id integer,
453    condition_id integer,
454    speciality_id integer
455);
456
457
458ALTER TABLE public.vendors OWNER TO agufranov;
459
460--
461-- Name: vendors_id_seq; Type: SEQUENCE; Schema: public; Owner: agufranov
462--
463
464CREATE SEQUENCE vendors_id_seq
465    START WITH 1
466    INCREMENT BY 1
467    NO MINVALUE
468    NO MAXVALUE
469    CACHE 1;
470
471
472ALTER TABLE public.vendors_id_seq OWNER TO agufranov;
473
474--
475-- Name: vendors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agufranov
476--
477
478ALTER SEQUENCE vendors_id_seq OWNED BY vendors.id;
479
480
481--
482-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
483--
484
485ALTER TABLE ONLY assignments ALTER COLUMN id SET DEFAULT nextval('assignments_id_seq'::regclass);
486
487
488--
489-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
490--
491
492ALTER TABLE ONLY clients ALTER COLUMN id SET DEFAULT nextval('clients_id_seq'::regclass);
493
494
495--
496-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
497--
498
499ALTER TABLE ONLY conditions ALTER COLUMN id SET DEFAULT nextval('conditions_id_seq'::regclass);
500
501
502--
503-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
504--
505
506ALTER TABLE ONLY countries ALTER COLUMN id SET DEFAULT nextval('countries_id_seq'::regclass);
507
508
509--
510-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
511--
512
513ALTER TABLE ONLY languages ALTER COLUMN id SET DEFAULT nextval('languages_id_seq'::regclass);
514
515
516--
517-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
518--
519
520ALTER TABLE ONLY professions ALTER COLUMN id SET DEFAULT nextval('professions_id_seq'::regclass);
521
522
523--
524-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
525--
526
527ALTER TABLE ONLY project_managers ALTER COLUMN id SET DEFAULT nextval('project_managers_id_seq'::regclass);
528
529
530--
531-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
532--
533
534ALTER TABLE ONLY projects ALTER COLUMN id SET DEFAULT nextval('projects_id_seq'::regclass);
535
536
537--
538-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
539--
540
541ALTER TABLE ONLY specialities ALTER COLUMN id SET DEFAULT nextval('specialities_id_seq'::regclass);
542
543
544--
545-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
546--
547
548ALTER TABLE ONLY vendor_countries ALTER COLUMN id SET DEFAULT nextval('vendor_countries_id_seq'::regclass);
549
550
551--
552-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
553--
554
555ALTER TABLE ONLY vendor_languages ALTER COLUMN id SET DEFAULT nextval('vendor_languages_id_seq'::regclass);
556
557
558--
559-- Name: id; Type: DEFAULT; Schema: public; Owner: agufranov
560--
561
562ALTER TABLE ONLY vendors ALTER COLUMN id SET DEFAULT nextval('vendors_id_seq'::regclass);
563
564
565--
566-- Data for Name: assignments; Type: TABLE DATA; Schema: public; Owner: agufranov
567--
568
569COPY assignments (id, tasks_flags, cost_cents, start_date, planned_end_date, actual_end_date, rating, vendor_id, project_id) FROM stdin;
570276	58	218000	2015-12-05 12:56:49	2015-12-05 03:48:32	2015-12-07 10:28:47	1	713	1703
571277	94	176000	2015-06-01 20:15:04	2015-11-01 13:48:44	2015-08-23 01:26:41	2	682	1703
572278	120	209000	2015-09-17 08:14:36	2015-11-05 03:39:57	2015-11-23 23:53:25	5	651	1643
573279	176	115000	2015-07-31 21:36:51	2015-08-02 05:09:00	2015-10-12 05:06:23	0	716	1644
574280	256	200000	2015-09-26 19:25:34	2015-11-19 02:20:06	\N	2	673	1644
575281	211	263000	2015-10-19 13:45:49	2015-11-05 21:21:56	2015-10-27 10:33:57	5	709	1644
576282	190	298000	2015-10-20 14:15:43	2015-10-23 16:21:15	2015-11-14 07:50:37	4	665	1644
577283	192	24000	2015-07-17 15:13:50	2015-09-16 07:48:55	\N	1	674	1646
578284	190	174000	2015-09-25 08:52:39	2015-09-28 16:06:07	\N	1	669	1646
579285	13	84000	2015-12-07 08:51:33	2015-12-07 01:21:35	\N	5	672	1649
580286	36	140000	2015-10-10 20:15:41	2015-12-03 11:03:20	\N	2	650	1649
581287	46	25000	2015-04-15 01:21:33	2015-05-13 17:15:00	\N	0	725	1650
582288	188	220000	2015-09-28 19:41:37	2015-10-01 08:47:32	2015-10-03 15:02:32	0	709	1651
583289	33	74000	2015-10-17 09:23:57	2015-10-20 00:49:20	2015-11-09 19:23:15	0	667	1651
584290	212	145000	2015-06-18 14:14:55	2015-07-02 23:22:10	\N	0	665	1651
585291	86	175000	2015-10-03 18:40:32	2015-10-09 07:47:18	2015-10-30 17:10:45	0	700	1651
586292	1	10000	2015-11-11 19:21:03	2015-11-13 19:52:09	2015-12-01 14:26:38	1	696	1653
587293	71	49000	2015-10-03 01:28:38	2015-11-18 12:50:16	2015-11-09 01:59:08	3	698	1653
588294	150	24000	2015-10-16 14:41:59	2015-11-17 19:36:29	2015-10-24 13:16:25	4	650	1653
589295	159	272000	2015-07-31 00:43:36	2015-11-29 10:43:52	2015-10-01 14:47:16	4	665	1653
590296	34	162000	2015-11-28 05:19:55	2015-12-07 15:43:00	2015-12-02 12:22:08	2	662	1656
591297	141	129000	2015-08-31 10:32:26	2015-10-04 21:26:29	2015-09-15 04:53:14	0	650	1656
592298	22	45000	2015-09-30 01:32:29	2015-10-03 01:17:15	\N	3	720	1656
593299	228	249000	2015-10-21 05:05:30	2015-11-10 09:58:46	2015-12-02 22:14:49	3	662	1659
594300	246	217000	2015-07-16 01:10:25	2015-08-16 06:15:49	2015-12-07 00:31:58	1	693	1659
595301	139	121000	2015-05-19 07:14:20	2015-09-27 08:17:17	2015-09-18 11:57:14	4	666	1659
596302	27	205000	2015-08-20 03:41:07	2015-11-01 18:02:16	2015-10-05 22:19:02	2	710	1659
597303	210	164000	2015-10-12 21:24:21	2015-11-15 18:06:12	2015-11-14 10:23:35	4	664	1664
598304	239	151000	2015-06-27 08:54:19	2015-10-15 04:56:46	\N	3	688	1664
599305	238	267000	2015-10-05 15:15:27	2015-10-15 08:16:21	\N	1	695	1664
600306	174	10000	2015-08-25 03:09:41	2015-10-22 07:23:37	2015-08-27 15:31:13	4	663	1664
601307	21	226000	2015-06-16 12:39:23	2015-10-27 16:10:13	2015-11-02 11:41:10	5	672	1667
602308	165	213000	2015-09-30 00:45:55	2015-11-21 07:14:54	2015-10-22 15:50:27	1	720	1670
603309	124	167000	2015-06-05 01:48:14	2015-06-27 02:13:36	2015-10-17 18:16:37	0	719	1674
604310	87	3000	2015-07-25 19:23:57	2015-07-26 12:35:26	2015-11-03 14:07:56	0	701	1674
605311	33	127000	2015-11-05 18:19:05	2015-12-04 00:50:16	\N	5	690	1674
606312	186	177000	2015-05-28 21:54:13	2015-07-14 23:04:03	\N	2	669	1674
607313	112	259000	2015-11-15 03:58:28	2015-11-18 20:16:28	2015-12-03 06:08:48	2	698	1678
608314	16	87000	2015-11-20 18:44:25	2015-12-03 23:46:53	\N	0	691	1678
609315	63	112000	2015-07-15 20:37:11	2015-12-07 19:41:27	2015-10-05 22:07:28	3	682	1678
610316	106	173000	2015-09-07 00:10:35	2015-09-16 04:53:33	\N	2	680	1678
611317	69	64000	2015-12-07 11:17:26	2015-12-07 01:00:08	2015-12-07 14:07:19	0	718	1680
612318	108	93000	2015-07-29 09:45:23	2015-09-22 13:17:33	2015-11-03 17:05:09	4	646	1680
613319	144	31000	2015-09-24 18:08:51	2015-11-11 08:41:32	\N	5	653	1680
614320	156	121000	2015-10-15 08:07:21	2015-11-19 05:34:12	\N	2	675	1680
615321	229	146000	2015-07-04 20:45:22	2015-10-25 07:12:01	\N	4	654	1681
616322	228	87000	2015-03-28 21:18:42	2015-07-18 01:21:31	2015-04-05 10:58:41	1	694	1681
617323	19	146000	2015-03-14 12:56:37	2015-04-13 14:32:02	2015-12-04 13:23:31	5	649	1681
618324	12	226000	2015-06-18 04:30:19	2015-09-23 10:22:10	\N	3	714	1682
619325	216	106000	2015-10-03 11:43:14	2015-11-23 18:11:22	2015-11-11 00:36:56	3	662	1704
620326	126	89000	2015-10-11 11:38:29	2015-11-02 02:45:52	2015-11-10 11:44:41	5	713	1704
621327	184	78000	2015-10-19 05:09:25	2015-12-01 18:55:09	\N	0	666	1704
622328	61	212000	2015-05-11 09:26:17	2015-08-05 21:00:52	\N	5	719	1706
623329	240	3000	2015-05-09 00:49:07	2015-06-09 14:34:50	2015-10-18 22:17:00	0	677	1708
624330	12	182000	2015-05-03 05:26:43	2015-05-13 11:17:42	\N	1	656	1708
625331	92	253000	2015-06-27 19:12:29	2015-09-15 11:19:48	2015-07-03 11:03:13	3	708	1708
626332	61	40000	2015-06-24 19:54:34	2015-09-17 06:30:06	\N	0	710	1708
627333	185	134000	2015-08-28 21:18:45	2015-09-27 08:13:07	\N	2	701	1716
628334	133	146000	2015-11-26 05:26:35	2015-12-05 02:30:11	2015-12-07 19:13:45	1	675	1716
629335	54	253000	2015-11-21 01:13:43	2015-12-06 16:10:12	\N	5	704	1716
630336	246	269000	2015-11-17 21:07:39	2015-11-30 17:26:46	\N	4	693	1716
631337	61	274000	2015-12-04 00:53:58	2015-12-04 08:35:30	2015-12-06 11:16:19	4	692	1717
632338	160	231000	2015-10-28 19:15:59	2015-11-03 10:06:29	2015-11-03 16:24:23	5	654	1720
633339	139	185000	2015-11-29 23:57:42	2015-11-30 17:01:17	2015-11-30 00:18:22	4	711	1720
634340	71	123000	2015-07-21 08:18:29	2015-08-05 02:23:35	\N	5	651	1722
635341	175	273000	2015-01-30 09:52:18	2015-08-20 00:04:46	2015-07-05 10:48:36	4	716	1722
636342	178	125000	2015-06-14 22:33:40	2015-07-09 01:55:44	2015-09-19 11:20:49	4	706	1722
637343	45	75000	2015-07-02 12:59:15	2015-09-27 21:36:36	2015-07-13 14:38:13	1	691	1722
638344	77	150000	2015-05-18 16:42:58	2015-10-03 15:15:27	2015-10-31 16:00:48	2	667	1723
639345	248	43000	2015-04-08 14:38:14	2015-08-12 00:52:50	\N	5	666	1723
640346	217	252000	2015-05-05 14:29:28	2015-06-08 06:29:19	\N	1	725	1725
641347	21	139000	2015-04-05 21:59:27	2015-06-16 11:10:34	\N	2	704	1726
642348	46	99000	2015-03-07 19:23:39	2015-09-15 15:41:21	2015-10-15 04:38:59	5	712	1727
643349	216	85000	2015-08-31 08:05:53	2015-10-14 20:22:16	\N	3	698	1727
644350	17	277000	2015-03-30 18:53:05	2015-11-21 05:03:01	\N	2	709	1727
645351	160	266000	2015-09-10 11:23:59	2015-11-16 23:15:17	\N	3	703	1729
646352	96	58000	2015-05-25 02:53:15	2015-10-28 13:31:20	2015-08-09 14:02:37	4	703	1738
647353	143	126000	2015-05-09 13:01:38	2015-11-19 14:46:45	\N	3	687	1738
648354	121	177000	2015-06-21 04:57:28	2015-07-20 09:06:09	2015-07-07 20:44:23	1	667	1739
649355	134	249000	2015-07-28 15:55:17	2015-08-07 03:41:55	\N	2	680	1746
650356	255	249000	2015-12-01 11:56:59	2015-12-02 12:29:53	\N	0	663	1749
651357	246	134000	2015-11-16 20:36:02	2015-11-16 00:07:35	\N	1	701	1750
652358	141	31000	2015-06-28 08:08:49	2015-10-08 14:50:13	2015-07-26 21:24:17	4	721	1750
653359	56	157000	2015-10-06 15:10:29	2015-11-15 15:18:26	\N	5	679	1750
654360	236	231000	2015-02-03 16:11:20	2015-07-17 06:39:47	2015-03-21 14:30:13	0	689	1750
655361	203	95000	2015-09-04 17:28:09	2015-10-27 02:17:52	\N	2	664	1751
656362	202	273000	2015-07-30 17:47:01	2015-08-11 18:37:40	2015-10-29 13:51:41	0	666	1754
657363	188	241000	2015-07-02 12:57:37	2015-10-22 11:59:55	\N	4	688	1754
658364	242	294000	2015-06-15 06:10:56	2015-10-12 19:58:39	\N	3	701	1754
659365	242	287000	2015-05-28 10:32:16	2015-07-31 19:58:09	2015-08-13 04:14:33	0	719	1754
660366	88	4000	2015-09-29 11:40:37	2015-09-29 00:20:42	2015-11-05 21:55:18	5	672	1755
661367	225	114000	2015-05-07 05:14:43	2015-11-05 12:41:25	\N	0	725	1755
662368	47	96000	2015-08-30 07:07:44	2015-10-11 10:12:08	\N	0	652	1756
663369	237	110000	2015-04-11 13:37:53	2015-04-19 22:42:33	\N	2	724	1756
664370	138	166000	2015-01-15 19:43:25	2015-08-28 08:12:37	\N	5	658	1762
665371	244	49000	2015-11-11 08:06:36	2015-12-07 10:10:51	\N	0	721	1762
666372	203	239000	2015-09-05 11:16:20	2015-10-29 17:17:04	2015-11-18 09:09:39	5	702	1762
667373	190	43000	2015-10-07 20:47:43	2015-10-10 10:52:29	\N	4	651	1683
668374	246	13000	2015-08-22 20:39:08	2015-08-28 14:02:10	\N	1	705	1683
669375	133	269000	2015-11-13 20:37:21	2015-11-14 20:40:10	\N	3	702	1683
670376	214	172000	2015-10-07 05:15:04	2015-10-26 16:40:34	2015-12-01 02:15:34	2	673	1683
671377	72	263000	2015-09-05 00:42:07	2015-10-11 23:04:16	\N	3	725	1685
672378	233	152000	2015-10-15 16:54:41	2015-11-17 14:59:23	2015-11-29 20:59:58	4	658	1685
673379	22	41000	2015-10-17 13:25:59	2015-11-18 08:09:56	\N	4	664	1688
674380	220	32000	2015-09-30 12:25:48	2015-10-18 15:52:17	\N	4	654	1688
675381	245	86000	2015-11-21 02:52:50	2015-12-04 11:59:15	\N	0	683	1689
676382	121	224000	2015-12-01 03:28:03	2015-12-05 15:42:14	\N	1	722	1690
677383	90	88000	2015-09-23 02:26:05	2015-11-06 18:53:54	2015-10-03 07:02:34	4	680	1690
678384	53	130000	2015-09-20 20:38:46	2015-09-25 13:26:05	\N	2	648	1691
679385	25	205000	2015-09-27 07:51:58	2015-11-02 03:52:27	\N	0	659	1691
680386	53	238000	2015-08-03 10:09:36	2015-10-27 08:13:14	\N	2	713	1693
681387	62	270000	2015-11-06 22:30:39	2015-11-21 14:02:45	\N	5	680	1693
682388	117	174000	2015-10-30 09:38:11	2015-11-10 16:46:51	\N	4	692	1694
683389	113	48000	2015-09-17 04:08:20	2015-10-24 02:42:54	2015-10-12 06:49:42	1	706	1696
684390	236	10000	2015-08-28 05:52:57	2015-09-19 01:04:34	2015-11-30 21:23:44	4	674	1696
685391	94	205000	2015-03-31 23:14:47	2015-11-17 11:53:33	2015-11-15 23:11:10	0	682	1697
686392	19	175000	2015-08-29 10:28:13	2015-10-04 14:32:37	2015-10-17 05:38:14	1	709	1699
687393	20	24000	2015-06-10 01:28:43	2015-11-09 01:27:37	2015-09-01 21:23:58	5	669	1699
688394	142	28000	2015-11-14 08:50:05	2015-11-28 20:51:25	\N	4	716	1700
689395	10	222000	2015-08-20 13:35:44	2015-11-26 12:17:56	2015-10-15 18:52:55	1	707	1700
690\.
691
692
693--
694-- Name: assignments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
695--
696
697SELECT pg_catalog.setval('assignments_id_seq', 395, true);
698
699
700--
701-- Data for Name: clients; Type: TABLE DATA; Schema: public; Owner: agufranov
702--
703
704COPY clients (id, name, address, country_id) FROM stdin;
705458	Feest-Waelchi	Darenmouth, 464 Champlin Manor	10252
706459	Ferry Inc	North Barneyfurt, 942 Charles Shoals	10370
707460	Ankunding, Swaniawski and Osinski	South Cleora, 721 Heller Square	10309
708461	Herzog Inc	West Tristianport, 375 Garry Tunnel	10359
709462	Lynch-Renner	Florianland, 87776 Tromp Plain	10430
710463	Champlin and Sons	Lake Joyceberg, 1212 Savion Wells	10318
711464	Luettgen LLC	Bertramfort, 932 Antone Gateway	10293
712465	Labadie-Koss	Morissettemouth, 5530 Mossie Plains	10284
713466	Becker and Sons	Feestview, 5909 Roy Plaza	10251
714467	Kilback-Flatley	Lake Delphineshire, 2617 Lenny Mission	10443
715468	Kshlerin, Nicolas and Trantow	Kieratown, 904 VonRueden Flats	10398
716469	Marquardt and Sons	Ulicesfurt, 4099 Fadel Coves	10289
717470	Smith-Streich	North Deannaland, 179 Cartwright Road	10403
718471	Ziemann Group	South Gianni, 9613 Hamill Orchard	10271
719472	Hayes-Ledner	New Clarkmouth, 3768 Muller Bypass	10273
720473	Von-Runte	South Jonstad, 22121 Cade Plaza	10353
721474	Beer, Larkin and Bradtke	Freddyville, 8127 Rowena Fork	10272
722475	Mann-Mosciski	Fadelland, 635 Harber Garden	10434
723476	Zboncak-Durgan	Mosciskichester, 87561 Shanna Locks	10436
724477	Kshlerin, O'Keefe and Spinka	South Kiara, 708 Misael Roads	10399
725\.
726
727
728--
729-- Name: clients_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
730--
731
732SELECT pg_catalog.setval('clients_id_seq', 477, true);
733
734
735--
736-- Data for Name: conditions; Type: TABLE DATA; Schema: public; Owner: agufranov
737--
738
739COPY conditions (id, name) FROM stdin;
74081	Condition 1
74182	Condition 2
742\.
743
744
745--
746-- Name: conditions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
747--
748
749SELECT pg_catalog.setval('conditions_id_seq', 82, true);
750
751
752--
753-- Data for Name: countries; Type: TABLE DATA; Schema: public; Owner: agufranov
754--
755
756COPY countries (id, name, code) FROM stdin;
75710207	Afghanistan	AF
75810208	Ã…land Islands	AX
75910209	Albania	AL
76010210	Algeria	DZ
76110211	American Samoa	AS
76210212	AndorrA	AD
76310213	Angola	AO
76410214	Anguilla	AI
76510215	Antarctica	AQ
76610216	Antigua and Barbuda	AG
76710217	Argentina	AR
76810218	Armenia	AM
76910219	Aruba	AW
77010220	Australia	AU
77110221	Austria	AT
77210222	Azerbaijan	AZ
77310223	Bahamas	BS
77410224	Bahrain	BH
77510225	Bangladesh	BD
77610226	Barbados	BB
77710227	Belarus	BY
77810228	Belgium	BE
77910229	Belize	BZ
78010230	Benin	BJ
78110231	Bermuda	BM
78210232	Bhutan	BT
78310233	Bolivia	BO
78410234	Bosnia and Herzegovina	BA
78510235	Botswana	BW
78610236	Bouvet Island	BV
78710237	Brazil	BR
78810238	British Indian Ocean Territory	IO
78910239	Brunei Darussalam	BN
79010240	Bulgaria	BG
79110241	Burkina Faso	BF
79210242	Burundi	BI
79310243	Cambodia	KH
79410244	Cameroon	CM
79510245	Canada	CA
79610246	Cape Verde	CV
79710247	Cayman Islands	KY
79810248	Central African Republic	CF
79910249	Chad	TD
80010250	Chile	CL
80110251	China	CN
80210252	Christmas Island	CX
80310253	Cocos (Keeling) Islands	CC
80410254	Colombia	CO
80510255	Comoros	KM
80610256	Congo	CG
80710257	Congo, The Democratic Republic of the	CD
80810258	Cook Islands	CK
80910259	Costa Rica	CR
81010260	Cote D"Ivoire	CI
81110261	Croatia	HR
81210262	Cuba	CU
81310263	Cyprus	CY
81410264	Czech Republic	CZ
81510265	Denmark	DK
81610266	Djibouti	DJ
81710267	Dominica	DM
81810268	Dominican Republic	DO
81910269	Ecuador	EC
82010270	Egypt	EG
82110271	El Salvador	SV
82210272	Equatorial Guinea	GQ
82310273	Eritrea	ER
82410274	Estonia	EE
82510275	Ethiopia	ET
82610276	Falkland Islands (Malvinas)	FK
82710277	Faroe Islands	FO
82810278	Fiji	FJ
82910279	Finland	FI
83010280	France	FR
83110281	French Guiana	GF
83210282	French Polynesia	PF
83310283	French Southern Territories	TF
83410284	Gabon	GA
83510285	Gambia	GM
83610286	Georgia	GE
83710287	Germany	DE
83810288	Ghana	GH
83910289	Gibraltar	GI
84010290	Greece	GR
84110291	Greenland	GL
84210292	Grenada	GD
84310293	Guadeloupe	GP
84410294	Guam	GU
84510295	Guatemala	GT
84610296	Guernsey	GG
84710297	Guinea	GN
84810298	Guinea-Bissau	GW
84910299	Guyana	GY
85010300	Haiti	HT
85110301	Heard Island and Mcdonald Islands	HM
85210302	Holy See (Vatican City State)	VA
85310303	Honduras	HN
85410304	Hong Kong	HK
85510305	Hungary	HU
85610306	Iceland	IS
85710307	India	IN
85810308	Indonesia	ID
85910309	Iran, Islamic Republic Of	IR
86010310	Iraq	IQ
86110311	Ireland	IE
86210312	Isle of Man	IM
86310313	Israel	IL
86410314	Italy	IT
86510315	Jamaica	JM
86610316	Japan	JP
86710317	Jersey	JE
86810318	Jordan	JO
86910319	Kazakhstan	KZ
87010320	Kenya	KE
87110321	Kiribati	KI
87210322	Korea, Democratic People"S Republic of	KP
87310323	Korea, Republic of	KR
87410324	Kuwait	KW
87510325	Kyrgyzstan	KG
87610326	Lao People"S Democratic Republic	LA
87710327	Latvia	LV
87810328	Lebanon	LB
87910329	Lesotho	LS
88010330	Liberia	LR
88110331	Libyan Arab Jamahiriya	LY
88210332	Liechtenstein	LI
88310333	Lithuania	LT
88410334	Luxembourg	LU
88510335	Macao	MO
88610336	Macedonia, The Former Yugoslav Republic of	MK
88710337	Madagascar	MG
88810338	Malawi	MW
88910339	Malaysia	MY
89010340	Maldives	MV
89110341	Mali	ML
89210342	Malta	MT
89310343	Marshall Islands	MH
89410344	Martinique	MQ
89510345	Mauritania	MR
89610346	Mauritius	MU
89710347	Mayotte	YT
89810348	Mexico	MX
89910349	Micronesia, Federated States of	FM
90010350	Moldova, Republic of	MD
90110351	Monaco	MC
90210352	Mongolia	MN
90310353	Montserrat	MS
90410354	Morocco	MA
90510355	Mozambique	MZ
90610356	Myanmar	MM
90710357	Namibia	NA
90810358	Nauru	NR
90910359	Nepal	NP
91010360	Netherlands	NL
91110361	Netherlands Antilles	AN
91210362	New Caledonia	NC
91310363	New Zealand	NZ
91410364	Nicaragua	NI
91510365	Niger	NE
91610366	Nigeria	NG
91710367	Niue	NU
91810368	Norfolk Island	NF
91910369	Northern Mariana Islands	MP
92010370	Norway	NO
92110371	Oman	OM
92210372	Pakistan	PK
92310373	Palau	PW
92410374	Palestinian Territory, Occupied	PS
92510375	Panama	PA
92610376	Papua New Guinea	PG
92710377	Paraguay	PY
92810378	Peru	PE
92910379	Philippines	PH
93010380	Pitcairn	PN
93110381	Poland	PL
93210382	Portugal	PT
93310383	Puerto Rico	PR
93410384	Qatar	QA
93510385	Reunion	RE
93610386	Romania	RO
93710387	Russian Federation	RU
93810388	RWANDA	RW
93910389	Saint Helena	SH
94010390	Saint Kitts and Nevis	KN
94110391	Saint Lucia	LC
94210392	Saint Pierre and Miquelon	PM
94310393	Saint Vincent and the Grenadines	VC
94410394	Samoa	WS
94510395	San Marino	SM
94610396	Sao Tome and Principe	ST
94710397	Saudi Arabia	SA
94810398	Senegal	SN
94910399	Serbia and Montenegro	CS
95010400	Seychelles	SC
95110401	Sierra Leone	SL
95210402	Singapore	SG
95310403	Slovakia	SK
95410404	Slovenia	SI
95510405	Solomon Islands	SB
95610406	Somalia	SO
95710407	South Africa	ZA
95810408	South Georgia and the South Sandwich Islands	GS
95910409	Spain	ES
96010410	Sri Lanka	LK
96110411	Sudan	SD
96210412	Suriname	SR
96310413	Svalbard and Jan Mayen	SJ
96410414	Swaziland	SZ
96510415	Sweden	SE
96610416	Switzerland	CH
96710417	Syrian Arab Republic	SY
96810418	Taiwan, Province of China	TW
96910419	Tajikistan	TJ
97010420	Tanzania, United Republic of	TZ
97110421	Thailand	TH
97210422	Timor-Leste	TL
97310423	Togo	TG
97410424	Tokelau	TK
97510425	Tonga	TO
97610426	Trinidad and Tobago	TT
97710427	Tunisia	TN
97810428	Turkey	TR
97910429	Turkmenistan	TM
98010430	Turks and Caicos Islands	TC
98110431	Tuvalu	TV
98210432	Uganda	UG
98310433	Ukraine	UA
98410434	United Arab Emirates	AE
98510435	United Kingdom	GB
98610436	United States	US
98710437	United States Minor Outlying Islands	UM
98810438	Uruguay	UY
98910439	Uzbekistan	UZ
99010440	Vanuatu	VU
99110441	Venezuela	VE
99210442	Viet Nam	VN
99310443	Virgin Islands, British	VG
99410444	Virgin Islands, U.S.	VI
99510445	Wallis and Futuna	WF
99610446	Western Sahara	EH
99710447	Yemen	YE
99810448	Zambia	ZM
99910449	Zimbabwe	ZW
1000\.
1001
1002
1003--
1004-- Name: countries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
1005--
1006
1007SELECT pg_catalog.setval('countries_id_seq', 10449, true);
1008
1009
1010--
1011-- Data for Name: languages; Type: TABLE DATA; Schema: public; Owner: agufranov
1012--
1013
1014COPY languages (id, name, native_name, code) FROM stdin;
10157827	Abkhaz	Ð°Ò§ÑÑƒÐ°	ab
10167828	Afar	Afaraf	aa
10177829	Afrikaans	Afrikaans	af
10187830	Akan	Akan	ak
10197831	Albanian	Shqip	sq
10207832	Amharic	áŠ áˆ›áˆáŠ›	am
10217833	Arabic	Ø§Ù„Ø¹Ø±Ø¨ÙŠØ©	ar
10227834	Aragonese	AragonÃ©s	an
10237835	Armenian	Õ€Õ¡ÕµÕ¥Ö€Õ¥Õ¶	hy
10247836	Assamese	à¦…à¦¸à¦®à§€à¦¯à¦¼à¦¾	as
10257837	Avaric	Ð°Ð²Ð°Ñ€ Ð¼Ð°Ñ†Ó€, Ð¼Ð°Ð³Ó€Ð°Ñ€ÑƒÐ» Ð¼Ð°Ñ†Ó€	av
10267838	Avestan	avesta	ae
10277839	Aymara	aymar aru	ay
10287840	Azerbaijani	azÉ™rbaycan dili	az
10297841	Bambara	bamanankan	bm
10307842	Bashkir	Ð±Ð°ÑˆÒ¡Ð¾Ñ€Ñ‚ Ñ‚ÐµÐ»Ðµ	ba
10317843	Basque	euskara, euskera	eu
10327844	Belarusian	Ð‘ÐµÐ»Ð°Ñ€ÑƒÑÐºÐ°Ñ	be
10337845	Bengali	à¦¬à¦¾à¦‚à¦²à¦¾	bn
10347846	Bihari	à¤à¥‹à¤œà¤ªà¥à¤°à¥€	bh
10357847	Bislama	Bislama	bi
10367848	Bosnian	bosanski jezik	bs
10377849	Breton	brezhoneg	br
10387850	Bulgarian	Ð±ÑŠÐ»Ð³Ð°Ñ€ÑÐºÐ¸ ÐµÐ·Ð¸Ðº	bg
10397851	Burmese	á€—á€™á€¬á€…á€¬	my
10407852	Catalan; Valencian	CatalÃ 	ca
10417853	Chamorro	Chamoru	ch
10427854	Chechen	Ð½Ð¾Ñ…Ñ‡Ð¸Ð¹Ð½ Ð¼Ð¾Ñ‚Ñ‚	ce
10437855	Chichewa; Chewa; Nyanja	chiCheÅµa, chinyanja	ny
10447856	Chinese	ä¸æ–‡ (ZhÅngwÃ©n), æ±‰è¯, æ¼¢èªž	zh
10457857	Chuvash	Ñ‡Ó‘Ð²Ð°Ñˆ Ñ‡Ó—Ð»Ñ…Ð¸	cv
10467858	Cornish	Kernewek	kw
10477859	Corsican	corsu, lingua corsa	co
10487860	Cree	á“€á¦áƒá”ááá£	cr
10497861	Croatian	hrvatski	hr
10507862	Czech	Äesky, ÄeÅ¡tina	cs
10517863	Danish	dansk	da
10527864	Divehi; Dhivehi; Maldivian;	Þ‹Þ¨ÞˆÞ¬Þ€Þ¨	dv
10537865	Dutch	Nederlands, Vlaams	nl
10547866	English	English	en
10557867	Esperanto	Esperanto	eo
10567868	Estonian	eesti, eesti keel	et
10577869	Ewe	EÊ‹egbe	ee
10587870	Faroese	fÃ¸royskt	fo
10597871	Fijian	vosa Vakaviti	fj
10607872	Finnish	suomi, suomen kieli	fi
10617873	French	franÃ§ais, langue franÃ§aise	fr
10627874	Fula; Fulah; Pulaar; Pular	Fulfulde, Pulaar, Pular	ff
10637875	Galician	Galego	gl
10647876	Georgian	áƒ¥áƒáƒ áƒ—áƒ£áƒšáƒ˜	ka
10657877	German	Deutsch	de
10667878	Greek, Modern	Î•Î»Î»Î·Î½Î¹ÎºÎ¬	el
10677879	GuaranÃ	AvaÃ±eáº½	gn
10687880	Gujarati	àª—à«àªœàª°àª¾àª¤à«€	gu
10697881	Haitian; Haitian Creole	KreyÃ²l ayisyen	ht
10707882	Hausa	Hausa, Ù‡ÙŽÙˆÙØ³ÙŽ	ha
10717883	Hebrew (modern)	×¢×‘×¨×™×ª	he
10727884	Herero	Otjiherero	hz
10737885	Hindi	à¤¹à¤¿à¤¨à¥à¤¦à¥€, à¤¹à¤¿à¤‚à¤¦à¥€	hi
10747886	Hiri Motu	Hiri Motu	ho
10757887	Hungarian	Magyar	hu
10767888	Interlingua	Interlingua	ia
10777889	Indonesian	Bahasa Indonesia	id
10787890	Interlingue	Originally called Occidental; then Interlingue after WWII	ie
10797891	Irish	Gaeilge	ga
10807892	Igbo	Asá»¥sá»¥ Igbo	ig
10817893	Inupiaq	IÃ±upiaq, IÃ±upiatun	ik
10827894	Ido	Ido	io
10837895	Icelandic	Ãslenska	is
10847896	Italian	Italiano	it
10857897	Inuktitut	áƒá“„á’ƒá‘Žá‘á‘¦	iu
10867898	Japanese	æ—¥æœ¬èªž (ã«ã»ã‚“ã”ï¼ã«ã£ã½ã‚“ã”)	ja
10877899	Javanese	basa Jawa	jv
10887900	Kalaallisut, Greenlandic	kalaallisut, kalaallit oqaasii	kl
10897901	Kannada	à²•à²¨à³à²¨à²¡	kn
10907902	Kanuri	Kanuri	kr
10917903	Kashmiri	à¤•à¤¶à¥à¤®à¥€à¤°à¥€, ÙƒØ´Ù…ÙŠØ±ÙŠâ€Ž	ks
10927904	Kazakh	ÒšÐ°Ð·Ð°Ò› Ñ‚Ñ–Ð»Ñ–	kk
10937905	Khmer	áž—áž¶ážŸáž¶ážáŸ’áž˜áŸ‚ážš	km
10947906	Kikuyu, Gikuyu	GÄ©kÅ©yÅ©	ki
10957907	Kinyarwanda	Ikinyarwanda	rw
10967908	Kirghiz, Kyrgyz	ÐºÑ‹Ñ€Ð³Ñ‹Ð· Ñ‚Ð¸Ð»Ð¸	ky
10977909	Komi	ÐºÐ¾Ð¼Ð¸ ÐºÑ‹Ð²	kv
10987910	Kongo	KiKongo	kg
10997911	Korean	í•œêµì–´ (éŸ“åœ‹èªž), ì¡°ì„ ë§ (æœé®®èªž)	ko
11007912	Kurdish	KurdÃ®, ÙƒÙˆØ±Ø¯ÛŒâ€Ž	ku
11017913	Kwanyama, Kuanyama	Kuanyama	kj
11027914	Latin	latine, lingua latina	la
11037915	Luxembourgish, Letzeburgesch	LÃ«tzebuergesch	lb
11047916	Luganda	Luganda	lg
11057917	Limburgish, Limburgan, Limburger	Limburgs	li
11067918	Lingala	LingÃ¡la	ln
11077919	Lao	àºžàº²àºªàº²àº¥àº²àº§	lo
11087920	Lithuanian	lietuviÅ³ kalba	lt
11097921	Luba-Katanga		lu
11107922	Latvian	latvieÅ¡u valoda	lv
11117923	Manx	Gaelg, Gailck	gv
11127924	Macedonian	Ð¼Ð°ÐºÐµÐ´Ð¾Ð½ÑÐºÐ¸ Ñ˜Ð°Ð·Ð¸Ðº	mk
11137925	Malagasy	Malagasy fiteny	mg
11147926	Malay	bahasa Melayu, Ø¨Ù‡Ø§Ø³ Ù…Ù„Ø§ÙŠÙˆâ€Ž	ms
11157927	Malayalam	à´®à´²à´¯à´¾à´³à´‚	ml
11167928	Maltese	Malti	mt
11177929	MÄori	te reo MÄori	mi
11187930	Marathi (MarÄá¹hÄ«)	à¤®à¤°à¤¾à¤ à¥€	mr
11197931	Marshallese	Kajin MÌ§ajeÄ¼	mh
11207932	Mongolian	Ð¼Ð¾Ð½Ð³Ð¾Ð»	mn
11217933	Nauru	EkakairÅ© Naoero	na
11227934	Navajo, Navaho	DinÃ© bizaad, DinÃ©kÊ¼ehÇ°Ã	nv
11237935	Norwegian BokmÃ¥l	Norsk bokmÃ¥l	nb
11247936	North Ndebele	isiNdebele	nd
11257937	Nepali	à¤¨à¥‡à¤ªà¤¾à¤²à¥€	ne
11267938	Ndonga	Owambo	ng
11277939	Norwegian Nynorsk	Norsk nynorsk	nn
11287940	Norwegian	Norsk	no
11297941	Nuosu	ê†ˆêŒ ê’¿ Nuosuhxop	ii
11307942	South Ndebele	isiNdebele	nr
11317943	Occitan	Occitan	oc
11327944	Ojibwe, Ojibwa	áŠá“‚á”‘á“ˆá¯á’§áŽá“	oj
11337945	Old Church Slavonic, Church Slavic, Church Slavonic, Old Bulgarian, Old Slavonic	Ñ©Ð·Ñ‹ÐºÑŠ ÑÐ»Ð¾Ð²Ñ£Ð½ÑŒÑÐºÑŠ	cu
11347946	Oromo	Afaan Oromoo	om
11357947	Oriya	à¬“à¬¡à¬¼à¬¿à¬†	or
11367948	Ossetian, Ossetic	Ð¸Ñ€Ð¾Ð½ Ã¦Ð²Ð·Ð°Ð³	os
11377949	Panjabi, Punjabi	à¨ªà©°à¨œà¨¾à¨¬à©€, Ù¾Ù†Ø¬Ø§Ø¨ÛŒâ€Ž	pa
11387950	PÄli	à¤ªà¤¾à¤´à¤¿	pi
11397951	Persian	ÙØ§Ø±Ø³ÛŒ	fa
11407952	Polish	polski	pl
11417953	Pashto, Pushto	Ù¾ÚšØªÙˆ	ps
11427954	Portuguese	PortuguÃªs	pt
11437955	Quechua	Runa Simi, Kichwa	qu
11447956	Romansh	rumantsch grischun	rm
11457957	Kirundi	kiRundi	rn
11467958	Romanian, Moldavian, Moldovan	romÃ¢nÄƒ	ro
11477959	Russian	Ñ€ÑƒÑÑÐºÐ¸Ð¹ ÑÐ·Ñ‹Ðº	ru
11487960	Sanskrit (Saá¹ská¹›ta)	à¤¸à¤‚à¤¸à¥à¤•à¥ƒà¤¤à¤®à¥	sa
11497961	Sardinian	sardu	sc
11507962	Sindhi	à¤¸à¤¿à¤¨à¥à¤§à¥€, Ø³Ù†ÚŒÙŠØŒ Ø³Ù†Ø¯Ú¾ÛŒâ€Ž	sd
11517963	Northern Sami	DavvisÃ¡megiella	se
11527964	Samoan	gagana faa Samoa	sm
11537965	Sango	yÃ¢ngÃ¢ tÃ® sÃ¤ngÃ¶	sg
11547966	Serbian	ÑÑ€Ð¿ÑÐºÐ¸ Ñ˜ÐµÐ·Ð¸Ðº	sr
11557967	Scottish Gaelic; Gaelic	GÃ idhlig	gd
11567968	Shona	chiShona	sn
11577969	Sinhala, Sinhalese	à·ƒà·’à¶‚à·„à¶½	si
11587970	Slovak	slovenÄina	sk
11597971	Slovene	slovenÅ¡Äina	sl
11607972	Somali	Soomaaliga, af Soomaali	so
11617973	Southern Sotho	Sesotho	st
11627974	Spanish; Castilian	espaÃ±ol, castellano	es
11637975	Sundanese	Basa Sunda	su
11647976	Swahili	Kiswahili	sw
11657977	Swati	SiSwati	ss
11667978	Swedish	svenska	sv
11677979	Tamil	à®¤à®®à®¿à®´à¯	ta
11687980	Telugu	à°¤à±†à°²à±à°—à±	te
11697981	Tajik	Ñ‚Ð¾Ò·Ð¸ÐºÓ£, toÄŸikÄ«, ØªØ§Ø¬ÛŒÚ©ÛŒâ€Ž	tg
11707982	Thai	à¹„à¸—à¸¢	th
11717983	Tigrinya	á‰µáŒáˆáŠ›	ti
11727984	Tibetan Standard, Tibetan, Central	à½–à½¼à½‘à¼‹à½¡à½²à½‚	bo
11737985	Turkmen	TÃ¼rkmen, Ð¢Ò¯Ñ€ÐºÐ¼ÐµÐ½	tk
11747986	Tagalog	Wikang Tagalog, áœáœ’áœƒáœ…áœ” áœ†áœ„áœŽáœ“áœ„áœ”	tl
11757987	Tswana	Setswana	tn
11767988	Tonga (Tonga Islands)	faka Tonga	to
11777989	Turkish	TÃ¼rkÃ§e	tr
11787990	Tsonga	Xitsonga	ts
11797991	Tatar	Ñ‚Ð°Ñ‚Ð°Ñ€Ñ‡Ð°, tatarÃ§a, ØªØ§ØªØ§Ø±Ú†Ø§â€Ž	tt
11807992	Twi	Twi	tw
11817993	Tahitian	Reo Tahiti	ty
11827994	Uighur, Uyghur	UyÆ£urqÉ™, Ø¦Û‡ÙŠØºÛ‡Ø±Ú†Û•â€Ž	ug
11837995	Ukrainian	ÑƒÐºÑ€Ð°Ñ—Ð½ÑÑŒÐºÐ°	uk
11847996	Urdu	Ø§Ø±Ø¯Ùˆ	ur
11857997	Uzbek	zbek, ÐŽÐ·Ð±ÐµÐº, Ø£Û‡Ø²Ø¨ÛÙƒâ€Ž	uz
11867998	Venda	Tshivená¸“a	ve
11877999	Vietnamese	Tiáº¿ng Viá»‡t	vi
11888000	VolapÃ¼k	VolapÃ¼k	vo
11898001	Walloon	Walon	wa
11908002	Welsh	Cymraeg	cy
11918003	Wolof	Wollof	wo
11928004	Western Frisian	Frysk	fy
11938005	Xhosa	isiXhosa	xh
11948006	Yiddish	×™×™Ö´×“×™×©	yi
11958007	Yoruba	YorÃ¹bÃ¡	yo
11968008	Zhuang, Chuang	SaÉ¯ cueÅ‹Æ…, Saw cuengh	za
1197\.
1198
1199
1200--
1201-- Name: languages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
1202--
1203
1204SELECT pg_catalog.setval('languages_id_seq', 8008, true);
1205
1206
1207--
1208-- Data for Name: professions; Type: TABLE DATA; Schema: public; Owner: agufranov
1209--
1210
1211COPY professions (id, title) FROM stdin;
1212157	firefighter
1213158	advocate
1214159	attorney at law
1215160	teacher
1216161	doctor
1217162	agriculturist
1218163	statistician
1219164	programmer
1220165	engineer
1221166	judge
1222167	architect
1223168	writer
1224169	economist
1225170	accountant
1226171	human resources
1227172	chemist
1228173	actor
1229174	interpreter
1230175	web developer
1231176	biologist
1232177	musician
1233178	astronomer
1234179	designer
1235180	physicist
1236181	librarian
1237182	philosopher
1238183	police officer
1239\.
1240
1241
1242--
1243-- Name: professions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
1244--
1245
1246SELECT pg_catalog.setval('professions_id_seq', 183, true);
1247
1248
1249--
1250-- Data for Name: project_managers; Type: TABLE DATA; Schema: public; Owner: agufranov
1251--
1252
1253COPY project_managers (id, name, email, address, client_id) FROM stdin;
1254830	Lincoln Greenholt	paxton.thompson@kuhlman.io	Wernerview, 7314 Rudolph Drives	458
1255831	Dr. Russell Fritsch	ardith.witting@ritchiekuphal.co	Maudietown, 8009 Riley Dam	458
1256832	Guillermo Carter	unique@haley.org	Smithview, 2364 Heaney Freeway	458
1257833	Leta Cole	mariane_simonis@feil.io	West Waino, 633 Camren Extensions	458
1258834	Godfrey Rath	deron_dietrich@langworth.info	Reesebury, 1728 Darwin Parkway	460
1259835	Elinore Ferry I	giovanni_runolfsdottir@funk.net	Lake Warren, 8562 Morissette Extensions	461
1260836	Jerad Kuhn	coy@koelpinheidenreich.co	Bradtkeburgh, 57101 Aleen Causeway	461
1261837	Aisha Torp Jr.	claria_gutkowski@bruen.biz	New Herminio, 5266 Freda Island	461
1262838	Ms. Esmeralda Walter	gayle@fritschking.io	Isadoreton, 22900 Mireille Summit	462
1263839	Odell Ziemann	rosemarie_witting@wehner.name	Kirlinland, 21763 Konopelski Crossing	462
1264840	Ethelyn Stehr	makenzie@mayert.org	Port Marleneland, 16295 Gerald Run	462
1265841	Effie Olson	lon.bailey@bergnaumemard.org	New Winnifredtown, 4583 Mohr Canyon	464
1266842	Sigrid Haley II	jayme@dare.com	Baileestad, 65790 Broderick Rue	465
1267843	Loraine Rolfson	olaf@boyer.info	East Aditya, 4173 Alexys Shore	465
1268844	Mrs. Paula Anderson	julie.erdman@sawayn.io	Watsicahaven, 1257 Ora Ports	466
1269845	Gail Littel IV	jamil.stanton@swaniawskimedhurst.org	South Lorinehaven, 27001 Halvorson Key	466
1270846	Dortha Weber IV	alene.nikolaus@turcotterogahn.co	East Dianaberg, 5853 Destini Junctions	466
1271847	Bertram Kertzmann PhD	ewald_brown@langosh.name	Jerelport, 161 Roob Mount	467
1272848	Tristin Torp III	orlando.heller@dachpollich.com	Abbyfort, 5892 Fisher Roads	467
1273849	Hilario Wintheiser	janea@hoppeschiller.net	New Eliport, 1929 Kaitlin Hills	468
1274850	Milo Bernhard	kaley_kling@lynch.co	Port Chauncey, 6147 Paul Islands	468
1275851	Isaiah Schmitt	lennie@ritchie.co	Lilafort, 6462 Clotilde Square	470
1276852	Florian Kris	skylar_dach@carroll.io	Sengerfurt, 458 Schroeder Squares	471
1277853	Elliott Boyle	delilah.okeefe@turnermohr.org	Heathcotebury, 89237 Stroman Well	471
1278854	Ara Fay	ellsworth@lubowitz.org	West Destany, 8951 Hammes Spurs	471
1279855	Noe Nolan PhD	aleandra@gutkowski.net	West Carletonville, 26642 Darby Parkway	471
1280856	Myrtle Grady II	twila@hayes.io	Langhaven, 7266 Leann Loop	472
1281857	Jayden Bayer	kaylin@schinnerrath.com	Hahnport, 5409 DuBuque Lock	472
1282858	Julio Stoltenberg	neal@schultzlabadie.org	Danport, 29944 Brian Spring	472
1283859	Gene Rice III	arnoldo.balistreri@sengerschinner.co	Lake Edmond, 171 Satterfield Rue	472
1284860	Deshaun Wunsch	remington@lueilwitzcronin.com	North Edgarstad, 68499 Zieme Stravenue	473
1285861	Mrs. Brennan Blanda	arvel@treutel.com	New Abbey, 64900 Chelsey Causeway	473
1286862	Helena Luettgen DDS	lupe@aufderharwalter.com	South Bertha, 66990 Thiel Manors	473
1287863	Mr. Kaleigh Heaney	sasha@white.name	Watersbury, 867 Carroll Creek	473
1288864	Obie Marquardt	morgan.steuber@yundt.org	New Jamisonland, 88584 Barrows Passage	474
1289865	Ms. Gilbert Watsica	mateo.reichert@wolff.net	Port Eladioborough, 4160 Roob Landing	474
1290866	Ms. Verlie Brown	cullen@labadie.io	West Chethaven, 65404 Emmalee Squares	474
1291867	Ms. Zane Gislason	oran@carrollbailey.com	West Guy, 7500 Virginie Course	476
1292868	Dan Brekke III	clay_lockman@deckow.biz	Joanyside, 49015 O'Keefe Drive	476
1293869	Kailey Vandervort	kallie.lowe@mertzhuel.io	North Alexanne, 818 Shanahan Stream	476
1294870	Miss Elva Hamill	nathen@baileydoyle.net	South Daphney, 7650 Zieme Orchard	476
1295871	Shawn Kerluke	cole@macgyverbradtke.com	McLaughlinside, 82647 Pierce Haven	477
1296872	Marquis Stokes PhD	ford@yundt.name	South Rhett, 890 Tremblay Station	477
1297873	Ollie Ondricka	devyn.kilback@legros.co	Trevionmouth, 8407 Moses Junction	477
1298\.
1299
1300
1301--
1302-- Name: project_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
1303--
1304
1305SELECT pg_catalog.setval('project_managers_id_seq', 873, true);
1306
1307
1308--
1309-- Data for Name: projects; Type: TABLE DATA; Schema: public; Owner: agufranov
1310--
1311
1312COPY projects (id, number, project_id_client, words_count, budget_cents, status, start_date, planned_end_date, actual_end_date, comments, client_id, project_manager_id, country_id, original_language_id, target_language_id, condition_id, speciality_id) FROM stdin;
13131703	2015-061	748-52-2672	37093	196000	1	2015-01-12 09:05:28.171014	2015-03-01 09:26:13	2015-11-08 23:09:36	\N	464	841	10211	7942	7827	81	81
13141643	2015-001	664-04-7052	8907	27000	2	2015-05-28 13:52:10.056941	2015-04-18 08:07:17	2015-07-14 10:50:45	\N	473	862	10354	7976	7901	82	82
13151644	2015-002	815-41-1895	7629	98000	1	2015-05-17 22:54:30.013466	2015-07-07 06:37:11	2015-10-13 05:23:59	\N	460	834	10295	7976	7855	82	82
13161645	2015-003	262-96-4676	27734	13000	1	2014-12-11 02:33:57.390363	2015-05-25 16:56:26	2015-02-16 02:35:21	\N	470	851	10309	7895	7971	82	81
13171646	2015-004	887-05-7160	35139	35000	2	2015-05-22 14:15:16.198981	2018-02-28 02:44:30	2015-09-11 15:48:49	Delectus quae quo tempora ea. Vitae eum voluptate. Eos ducimus sit sequi. Tempore odit quae pariatur repudiandae culpa voluptatem. Est beatae ad architecto incidunt aspernatur.	473	861	10439	7900	7951	82	82
13181647	2015-005	785-24-2714	34172	227000	1	2015-02-17 23:50:16.487015	2014-12-11 10:23:52	2015-05-28 18:24:54	Molestiae eius et voluptas. Quis laudantium inventore repudiandae iusto sint est asperiores. Omnis ut sed. Quaerat doloremque repudiandae libero.	458	830	10419	8007	7984	81	81
13191648	2015-006	348-09-0782	19409	95000	2	2015-03-02 04:52:15.492186	2018-03-10 09:32:15	2015-08-01 04:01:51	\N	465	842	10390	7910	7937	82	82
13201649	2015-007	261-47-2646	31368	127000	2	2015-08-28 16:09:43.906336	2015-09-26 00:23:16	2015-11-11 09:45:38	\N	460	834	10371	7877	7940	81	81
13211650	2015-008	206-26-5555	37561	279000	2	2015-02-05 02:20:56.964479	2015-11-15 22:38:43	2015-06-03 16:36:50	Temporibus optio voluptates iste quo. Reiciendis cum aut minima sed qui ut. Modi aut fuga earum occaecati. Velit consequatur aut atque et ratione.	462	838	10222	7983	7942	81	81
13221651	2015-009	311-77-5099	17463	190000	2	2015-04-18 02:23:02.964668	2018-08-25 10:28:57	2015-06-25 15:27:09	\N	475	\N	10407	7874	7860	82	81
13231652	2015-010	099-53-1195	16352	154000	0	2015-06-10 13:54:36.245592	2015-04-18 20:13:58	\N	\N	475	\N	10245	7975	7859	82	81
13241653	2015-011	075-99-0894	25336	73000	2	2015-02-08 17:49:26.37194	2015-05-23 12:01:43	2015-06-13 06:27:44	\N	475	\N	10252	7853	7983	82	82
13251654	2015-012	569-77-8682	7036	132000	1	2015-03-10 18:25:41.548756	2015-03-20 17:36:04	2015-08-19 17:17:17	Dolor autem culpa et quibusdam accusamus. Nihil aut ut at aliquam unde quo. Soluta sit est.	470	851	10380	7950	7873	82	82
13261655	2015-013	863-45-3723	39213	114000	1	2015-02-07 07:41:06.645546	2015-06-07 21:47:17	2015-10-02 12:54:47	\N	464	841	10224	7875	7837	82	82
13271656	2015-014	168-43-4453	28287	143000	0	2015-08-07 10:15:13.55195	2018-03-14 19:00:23	\N	Quia velit iusto odio aut rerum. Sed voluptas molestiae dolorem. Expedita magni et asperiores. Vero perspiciatis recusandae magni cum.	471	852	10313	7873	7843	82	81
13281657	2015-015	661-59-2332	31331	206000	1	2015-04-11 07:15:10.627313	2015-06-18 12:41:11	2015-11-17 16:31:50	\N	472	856	10448	7847	7994	81	82
13291658	2015-016	723-95-3537	10225	258000	0	2015-07-28 08:18:08.047307	2018-01-06 10:10:03	\N	\N	477	871	10444	7831	7873	82	81
13301659	2015-017	862-77-6786	15128	238000	2	2014-12-15 10:52:52.581566	2015-06-05 09:03:26	2014-12-24 20:03:39	\N	466	846	10295	8005	7827	82	81
13311660	2015-018	295-96-5408	6627	167000	1	2015-05-18 14:50:40.705316	2018-02-05 08:02:20	2015-07-31 23:13:37	Labore voluptatum est. Occaecati sit quisquam. Deserunt recusandae rem. Et et tempore molestiae quae. Nulla voluptates cupiditate ut expedita repellendus culpa dolores.	462	838	10350	7976	7876	82	82
13321661	2015-019	657-15-7411	28915	58000	2	2015-07-26 00:18:36.41428	2015-04-19 21:11:19	2015-11-29 01:47:21	\N	459	\N	10366	7986	7878	81	82
13331662	2015-020	848-44-4627	22576	35000	2	2015-06-07 06:43:01.821402	2015-03-09 21:13:16	2015-08-02 00:28:37	Unde recusandae labore sit porro ut hic rerum. Iusto laboriosam consequatur fugit ut quia fugiat dolores. Molestiae eum aspernatur quisquam rerum.	460	834	10339	7900	7921	81	82
13341663	2015-021	864-33-7464	25771	143000	2	2015-02-01 19:31:26.625109	2015-01-12 01:33:23	2015-04-23 05:48:59	\N	464	841	10269	7872	7948	81	81
13351664	2015-022	536-86-6693	26043	29000	2	2015-05-28 07:08:29.484822	2015-08-26 04:53:47	2015-09-24 13:38:19	\N	464	841	10429	7979	7901	82	82
13361665	2015-023	271-33-2515	18126	152000	2	2015-01-07 04:48:46.495351	2015-06-25 16:14:35	2015-07-21 10:05:22	Quo qui nihil necessitatibus quo ea est. In iure reiciendis est corrupti ipsa. Similique doloremque minus. Quo neque itaque sint.	474	866	10359	7941	7964	81	82
13371666	2015-024	497-83-3253	42684	182000	0	2015-05-28 13:07:29.542087	2015-06-12 20:31:02	\N	\N	464	841	10401	7876	7921	82	81
13381667	2015-025	491-69-0529	15055	127000	2	2015-01-02 20:05:03.857955	2018-11-22 22:25:41	2015-06-27 19:53:53	Omnis maiores voluptatem ullam sequi. Et amet impedit iusto est. Architecto quisquam accusamus maiores praesentium.	461	837	10353	7882	7978	82	82
13391668	2015-026	835-22-0823	24837	262000	1	2015-02-18 16:29:53.147062	2015-11-11 01:07:01	2015-03-09 18:44:15	Dolor ipsam amet ea. Sit quod accusamus. Laborum est non accusantium. Esse rerum tempore facere inventore et. Impedit magni optio rerum iste illum architecto suscipit.	459	\N	10366	7863	8006	81	81
13401669	2015-027	831-55-0755	25666	209000	0	2015-02-20 22:06:20.464556	2015-11-21 02:10:24	\N	\N	465	842	10407	7992	7904	81	82
13411670	2015-028	162-52-0253	9926	220000	2	2015-06-27 16:46:08.806656	2018-01-02 14:48:36	2015-09-02 17:44:23	In non aspernatur saepe nihil fuga fugit mollitia. Soluta illum fuga consequatur veritatis eius. Et placeat ut corporis. Similique sed ea cupiditate numquam velit et quaerat.	474	864	10395	7829	7903	82	81
13421671	2015-029	036-33-1723	31348	54000	1	2015-02-01 01:17:35.871739	2018-09-22 08:47:24	2015-03-31 20:20:39	\N	466	846	10332	7892	7963	81	81
13431672	2015-030	614-98-3922	10327	180000	1	2014-12-23 06:02:57.543248	2015-07-18 18:27:01	2015-03-07 15:41:02	Aut ullam eos atque reiciendis consequatur. Nostrum officiis quo harum autem expedita sint. Rerum aperiam doloribus nisi. Cupiditate vero enim illum adipisci veritatis officiis rem. Vel et repudiandae ut.	474	864	10288	8002	7870	82	82
13441673	2015-031	394-04-2203	8703	173000	1	2015-05-14 18:44:51.216313	2018-12-02 04:53:04	2015-10-22 06:26:52	\N	468	849	10343	7900	7944	82	81
13451674	2015-032	496-92-9206	39453	289000	1	2015-03-07 22:26:53.813489	2015-10-04 11:38:04	2015-10-03 07:47:52	Ad aut velit debitis rerum aut modi. Qui sit sint vel nobis culpa voluptas iste. Architecto reprehenderit aperiam minus commodi aliquid et.	459	\N	10378	7830	7843	82	82
13461675	2015-033	444-15-2536	33450	93000	2	2015-02-20 17:06:42.848438	2018-02-11 05:11:18	2015-06-06 20:42:13	Omnis ab officiis corporis. Ducimus voluptatem soluta sequi expedita cupiditate qui. Fugiat in at sit magnam eum quae. Ratione maiores quam nulla.	458	831	10370	7900	7911	81	81
13471676	2015-034	103-10-0490	42934	31000	1	2015-02-28 17:55:29.784699	2015-03-13 13:52:01	2015-04-11 14:24:37	\N	468	849	10358	7883	7865	81	81
13481677	2015-035	601-16-7396	3207	131000	2	2015-01-23 03:16:35.792397	2015-11-09 14:32:26	2015-08-23 14:05:08	\N	461	837	10242	8006	7967	82	81
13491678	2015-036	524-86-8495	38731	199000	0	2015-07-15 16:14:28.734666	2015-04-24 08:21:22	\N	\N	475	\N	10430	7963	7880	82	82
13501679	2015-037	777-20-0055	37734	203000	2	2015-02-20 16:30:21.934619	2018-01-02 15:36:34	2015-07-12 21:10:50	Aspernatur doloribus facere placeat facilis eum magni illum. Eos velit voluptates. Sapiente totam et officiis quo et.	468	849	10404	7966	7953	81	81
13511680	2015-038	858-73-9251	17780	152000	2	2015-07-24 09:07:54.823456	2018-07-25 00:57:32	2015-11-19 21:51:23	\N	462	839	10215	7963	7994	82	82
13521681	2015-039	703-85-2684	18139	204000	1	2015-03-09 16:26:06.900012	2018-10-11 06:46:33	2015-04-28 09:09:01	Sit rem aut facilis quia accusamus. Dicta iusto suscipit mollitia magnam. Maxime velit rerum laudantium voluptas blanditiis. Saepe voluptatem rem vel consequatur doloremque.	466	846	10234	8008	7944	82	81
13531682	2015-040	336-05-4915	39533	31000	1	2015-04-12 19:56:45.206785	2018-03-25 17:26:39	2015-09-14 09:10:11	Placeat fuga corporis omnis quasi qui rem dolorem. Harum veritatis tempore et error voluptatum. Repellendus enim modi porro.	462	839	10286	7916	7884	81	81
13541704	2015-062	432-45-5732	7705	230000	0	2015-08-09 04:23:14.052347	2015-01-25 23:58:51	\N	Dolor possimus eum quod in excepturi magnam ipsa. Nulla ut dolor expedita ullam quas in ratione. Dolorem amet animi modi consequatur.	464	841	10322	7931	7875	82	81
13551705	2015-063	657-39-6736	6065	173000	2	2015-06-23 15:24:37.207595	2018-12-05 01:36:28	2015-09-30 04:43:58	\N	477	871	10347	7992	7831	82	81
13561706	2015-064	263-10-2607	10669	143000	2	2014-12-19 20:53:55.267585	2018-04-04 12:27:17	2015-03-23 16:23:29	\N	474	866	10235	7918	7898	81	82
13571707	2015-065	854-42-7662	35084	140000	1	2014-12-15 23:36:56.873191	2014-12-07 15:10:47	2015-03-31 06:21:13	Quo dicta ab non reiciendis saepe et. Sunt excepturi sint dolorem. Qui reiciendis ducimus animi molestiae voluptatum rerum.	461	836	10254	7943	7869	82	82
13581708	2015-066	758-68-1723	16016	115000	1	2015-01-19 01:55:57.358036	2015-11-19 02:24:58	2015-08-14 19:13:07	\N	475	\N	10447	7921	7852	82	82
13591709	2015-067	506-83-9718	3143	50000	1	2015-02-18 06:18:37.82873	2018-09-15 13:16:38	2015-09-21 06:55:57	Molestiae id non vel voluptate. Quia atque sunt quas odit. Quia suscipit atque perspiciatis.	477	873	10380	7867	7922	81	82
13601710	2015-068	731-69-0527	17521	241000	1	2015-04-08 10:44:59.192017	2015-05-14 06:40:01	2015-09-17 07:47:40	Exercitationem corrupti iusto velit voluptas. Et qui voluptatem omnis nulla suscipit recusandae. Rem qui sit reiciendis labore. Consequatur id iure dolorem ut non.	469	\N	10403	7875	7979	82	82
13611711	2015-069	009-26-8226	5646	70000	0	2015-03-06 19:15:37.20664	2015-11-14 15:14:09	\N	Sit id numquam odio nam deserunt autem. Ad non alias. Dignissimos harum quod suscipit repellendus enim nesciunt. Molestiae odio eveniet quasi nobis ut.	474	866	10236	7837	7860	81	82
13621712	2015-070	780-97-7886	20324	223000	0	2015-03-07 15:20:46.068283	2015-07-12 23:12:29	\N	\N	458	830	10322	7934	7868	81	81
13631713	2015-071	837-73-7244	26852	130000	2	2015-02-10 16:38:22.03247	2018-05-09 12:52:47	2015-02-26 21:27:40	Illum est consequatur nihil. Et velit cumque eum. Nihil eaque et explicabo. Labore molestiae a id. Est dolores cumque porro accusamus unde dolor.	473	863	10353	7944	7914	82	82
13641714	2015-072	872-22-7237	34231	129000	0	2015-04-18 04:13:10.737035	2015-08-20 03:27:28	\N	\N	466	844	10211	7902	7932	81	81
13651715	2015-073	652-77-9145	18900	108000	1	2015-01-22 16:24:43.537153	2018-10-02 17:23:02	2015-03-20 07:23:16	Quo quo aut nam distinctio. Fugiat ut itaque aut provident et dicta libero. Tenetur fugiat dolore ut asperiores aut architecto. Sit voluptas assumenda aut voluptate nulla. Aut deserunt id eos vero tempora facilis vitae.	475	\N	10341	7846	7977	81	81
13661716	2015-074	762-06-6396	36279	52000	1	2015-06-09 12:35:20.201351	2015-05-11 11:41:13	2015-07-13 22:14:13	Rerum natus quis sit est. Nulla est vitae. Ipsam soluta incidunt et praesentium cumque.	466	845	10397	7830	7934	82	82
13671717	2015-075	771-55-7038	9438	215000	0	2015-03-29 19:34:10.990524	2018-11-09 23:56:55	\N	Eligendi ipsum tempore incidunt aliquid hic et. Consequatur enim et dolor autem veritatis. Aut natus consequuntur. Cumque amet veniam quod. Ipsum nam quibusdam ab ut.	463	\N	10362	7845	7973	82	81
13681718	2015-076	869-95-5518	40381	304000	2	2015-01-09 14:35:30.675737	2018-06-26 00:28:31	2015-11-19 07:34:51	\N	475	\N	10279	7870	7943	81	81
13691719	2015-077	172-11-0376	30590	38000	1	2015-04-07 16:46:40.936386	2015-02-10 16:35:35	2015-10-06 18:50:35	\N	458	832	10446	7911	7973	81	81
13701720	2015-078	010-81-8548	36051	217000	1	2015-09-04 00:58:01.748704	2018-04-18 00:30:43	2015-09-23 07:41:21	In nihil repellat incidunt consequatur voluptatibus est quae. Ut odit dicta recusandae sit natus. Atque quo sit possimus alias inventore. Maiores perspiciatis temporibus non ut quia vitae et.	459	\N	10337	7883	7902	82	82
13711721	2015-079	300-27-5875	27694	148000	1	2015-06-01 22:49:01.073705	2018-09-25 23:20:40	2015-10-28 15:05:28	\N	468	849	10251	8006	8002	82	82
13721722	2015-080	363-27-1974	20244	182000	2	2015-01-27 10:22:58.322813	2015-04-17 04:13:46	2015-04-17 02:03:21	\N	466	844	10396	7918	7941	82	81
13731723	2015-081	344-55-8152	24005	272000	2	2015-04-04 18:28:08.425631	2015-04-23 23:32:33	2015-06-19 16:39:14	\N	476	869	10258	7981	7913	82	81
13741724	2015-082	456-03-5779	40017	189000	2	2015-08-05 00:49:30.144184	2018-02-05 13:04:29	2015-10-31 06:01:24	\N	470	851	10341	7882	7895	81	81
13751725	2015-083	701-51-5587	7182	300000	1	2015-03-09 23:42:11.504129	2015-08-31 23:35:08	2015-04-06 01:10:58	\N	458	830	10350	7940	7877	81	82
13761726	2015-084	517-70-8617	15924	225000	1	2015-03-01 02:20:24.63036	2015-06-25 13:49:06	2015-08-29 06:06:50	Et sint sit earum dolorum. Rerum sit sequi commodi. Similique architecto et dignissimos error sint iste. Qui placeat ut cupiditate eveniet quis. Dolorem delectus non recusandae cum.	465	843	10235	7975	7851	82	82
13771727	2015-085	797-97-1609	35969	18000	1	2015-02-26 23:54:15.634566	2015-05-22 15:23:47	2015-06-03 13:45:49	\N	465	843	10369	7918	7877	81	82
13781728	2015-086	649-03-1504	26257	174000	1	2015-06-30 02:59:54.791165	2018-02-09 23:12:31	2015-12-04 22:06:19	\N	460	834	10247	7984	7842	81	81
13791729	2015-087	682-01-4608	7713	295000	1	2015-04-15 14:44:28.288179	2018-01-01 17:44:49	2015-09-11 23:47:35	Dolore laborum pariatur nisi consequatur tempora vitae commodi. Ea sed aut debitis sed. Nisi illo porro rerum odit ea ut ut. Rerum enim qui quod.	472	859	10217	7868	7960	81	81
13801730	2015-088	668-17-0755	30391	171000	2	2015-04-22 09:47:06.045295	2015-03-09 20:43:30	2015-07-29 06:24:53	Dolore architecto impedit at voluptatem. Architecto aut quos. Quia tempora officiis accusamus consectetur maiores soluta dolores. Labore natus ipsum aspernatur reiciendis nulla non fuga.	477	871	10446	7938	8006	81	82
13811731	2015-089	152-28-5011	11501	231000	2	2015-05-20 13:24:40.090881	2018-07-29 04:15:07	2015-05-28 20:15:08	\N	458	832	10242	7954	7945	82	81
13821732	2015-090	638-60-1644	16405	245000	1	2015-01-21 20:05:54.154637	2018-11-14 09:31:09	2015-01-21 06:51:58	Ad eum amet dolorem quam nihil expedita cumque. Qui aut sed ut explicabo velit. Possimus quisquam maxime voluptatum. Id reiciendis ipsa harum tempora. Accusantium quaerat dolorum dolor quos molestiae atque impedit.	471	854	10403	7887	7997	82	82
13831733	2015-091	200-19-4976	7090	209000	1	2015-03-28 22:00:56.087798	2015-06-09 20:13:04	2015-07-15 00:29:41	Voluptatem natus quod sit maxime. Omnis saepe ipsa nisi ab. Soluta impedit voluptatem iure maiores consequatur accusamus. Dicta aut alias minima magni.	460	834	10207	7972	8001	82	82
13841734	2015-092	256-29-6415	31329	302000	2	2015-08-10 19:41:44.022468	2015-11-09 19:22:27	2015-10-25 20:29:21	\N	472	859	10363	7920	7932	82	82
13851735	2015-093	371-82-5360	23339	53000	2	2015-03-18 20:07:26.846962	2015-03-20 05:27:47	2015-11-10 19:53:55	\N	462	840	10307	7910	7934	81	81
13861736	2015-094	774-84-3876	34732	227000	1	2015-06-16 08:01:37.809133	2018-09-26 03:24:38	2015-07-03 11:31:03	\N	477	872	10427	7912	8001	81	81
13871737	2015-095	115-11-4498	4824	189000	1	2015-03-19 02:43:02.980779	2018-01-16 20:24:29	2015-05-23 05:28:26	\N	466	845	10380	7959	7833	82	81
13881738	2015-096	885-86-1596	37995	305000	1	2015-02-26 04:20:58.622507	2015-06-07 20:13:30	2015-10-10 15:48:39	Quia illum eius recusandae itaque fugit. Quis ab in. Quam perferendis sint qui animi.	472	859	10381	7924	7892	82	81
13891739	2015-097	827-59-2623	13684	103000	2	2015-03-25 20:14:41.306034	2015-06-13 12:07:26	2015-04-25 22:31:11	\N	470	851	10359	7991	7985	81	81
13901740	2015-098	242-46-0752	6241	92000	1	2015-01-05 07:43:28.980581	2015-06-22 20:52:10	2015-01-31 05:15:42	\N	464	841	10320	7924	7978	81	81
13911741	2015-099	195-85-5789	10155	234000	1	2015-04-19 15:36:16.926483	2015-05-05 05:36:30	2015-06-06 15:14:00	Laboriosam vel eius vitae itaque mollitia voluptatem sit. Ut quo doloremque et. Dolor labore blanditiis perferendis qui. Ratione consequatur debitis molestiae quia. Quasi neque commodi sint voluptatem at dolores.	466	845	10300	7971	7936	82	81
13921742	2015-100	337-02-5737	27853	91000	1	2015-03-27 11:19:30.770814	2018-02-15 07:51:19	2015-06-08 00:13:13	\N	468	850	10229	7836	7983	82	81
13931743	2015-101	449-62-3509	14675	38000	0	2015-08-06 08:16:29.961467	2015-02-03 07:21:08	\N	Dolores quia mollitia. Deserunt nam facere aut in neque fuga. Consectetur voluptatem dolor excepturi odio molestias doloremque. Alias dolor qui et est blanditiis voluptates fuga.	477	871	10232	7988	7988	81	81
13941744	2015-102	748-18-4990	4625	104000	2	2015-05-29 10:04:19.271404	2018-04-11 13:08:55	2015-11-05 03:30:58	Porro asperiores aut commodi ipsa tenetur provident maiores. Vel error illum qui voluptas at dolore soluta. Ut dolores non temporibus. Consequatur distinctio sit est reiciendis nesciunt velit. Qui error eos minus repellat beatae.	467	847	10384	7931	7878	81	82
13951745	2015-103	311-41-9964	10586	231000	1	2015-04-14 13:21:23.542116	2015-02-08 18:00:30	2015-05-06 08:08:15	At assumenda consequatur ut laborum. Earum quod vel necessitatibus fuga eos corrupti voluptatem. Dicta vitae veritatis. Non pariatur laudantium in ab quia perferendis numquam.	471	853	10370	7904	7890	81	81
13961746	2015-104	681-89-2029	35619	250000	0	2015-04-06 09:58:04.749818	2015-08-26 05:07:56	\N	Quia quo aut aut sed repudiandae delectus eos. Est odio rem sequi praesentium omnis amet. Delectus iusto et dicta expedita nihil illo ut. Quam laudantium impedit aliquid voluptatem velit accusantium. Optio quos ad vel.	464	841	10347	7943	7993	81	82
13971747	2015-105	101-45-2242	21682	305000	2	2015-02-22 14:23:40.68007	2015-07-31 06:29:12	2015-07-11 22:18:33	Voluptas deserunt quas sunt laborum voluptatibus. Vel cum mollitia. Velit minima odit non earum. Dicta vitae debitis.	468	849	10421	7841	7836	82	81
13981748	2015-106	436-38-7943	8311	72000	2	2015-08-22 05:56:25.484872	2018-08-29 00:57:24	2015-08-26 13:59:49	Cupiditate qui voluptatibus est atque dolores. Ut ipsa non delectus sunt dolor. Culpa ut cumque sequi dicta. Error est neque voluptatem. Hic molestias quidem.	475	\N	10238	7975	7967	81	81
13991749	2015-107	545-81-4973	40893	227000	2	2015-01-22 21:24:28.099727	2015-11-20 22:27:40	2015-02-26 18:27:50	Incidunt praesentium aut rerum odit eaque esse debitis. Cupiditate atque sed vitae aspernatur sed. Sed quis deserunt at fugit facere voluptates quae.	476	869	10291	8004	7897	81	81
14001750	2015-108	039-20-5547	21591	130000	0	2015-01-09 15:26:14.270445	2015-01-14 14:45:31	\N	\N	473	861	10346	7923	7842	82	81
14011751	2015-109	144-83-5114	6726	101000	2	2015-05-02 14:44:19.094487	2015-07-22 14:27:43	2015-07-12 08:14:34	Ipsam maiores hic quidem ullam ea. Vitae qui tenetur. Eos id assumenda corporis vero provident.	464	841	10239	7855	7932	82	82
14021752	2015-110	695-12-4321	9038	75000	0	2014-12-25 04:38:33.483214	2018-08-31 15:17:12	\N	\N	469	\N	10249	7951	7923	81	82
14031753	2015-111	059-48-7083	3938	74000	1	2015-02-19 12:35:50.03214	2015-04-27 23:33:15	2015-04-11 01:02:46	Voluptates et qui. Non odio et qui distinctio consequatur. Molestiae voluptate corrupti est commodi similique quas est.	473	863	10369	7839	7877	81	82
14041754	2015-112	726-93-1263	21726	162000	1	2015-05-27 01:56:26.190088	2018-04-24 06:11:10	2015-08-15 13:43:05	Labore neque assumenda ullam ad voluptatem. Voluptas possimus officiis quidem cumque sit sequi sed. Ut fugit ut debitis.	461	836	10212	7835	7966	82	82
14051755	2015-113	376-46-5324	42452	136000	2	2014-12-11 13:26:35.226562	2015-08-31 11:58:46	2015-07-20 04:51:41	\N	460	834	10287	7907	7841	81	82
14061756	2015-114	148-71-2079	18192	249000	0	2015-03-10 14:55:13.565013	2018-07-16 11:47:44	\N	Blanditiis aut accusantium et suscipit molestiae nostrum sit. Aperiam accusamus id. Nihil temporibus amet dicta beatae omnis vero et. Qui dolorem labore et voluptates.	466	844	10400	7833	7979	82	82
14071757	2015-115	729-24-8933	40457	296000	1	2014-12-30 04:26:27.917211	2018-09-29 05:00:38	2015-01-01 02:18:49	\N	474	864	10382	7842	7840	82	82
14081758	2015-116	771-24-7519	10746	186000	1	2015-07-19 12:06:38.454793	2018-09-30 04:02:21	2015-11-29 05:10:30	Id suscipit enim quas ipsam. Ipsam qui sed enim magnam saepe possimus optio. Voluptatum facere velit est laudantium praesentium voluptates.	475	\N	10379	8005	7849	82	82
14091759	2015-117	525-69-8556	3256	237000	2	2015-04-08 12:37:00.323492	2014-12-08 13:14:44	2015-05-02 14:04:28	Quod quia et eum nostrum aut laudantium. Quo veritatis mollitia enim voluptas. Est culpa minus porro.	464	841	10358	7853	7886	81	81
14101760	2015-118	569-46-4037	10103	149000	2	2015-01-25 21:54:51.486883	2015-04-23 11:17:23	2015-04-13 15:26:16	Laboriosam rem id incidunt sequi consequuntur cum recusandae. Delectus nemo ea numquam iusto vel laborum alias. Eius harum quia vero quasi autem. Cumque officia aut eveniet. Voluptas accusamus ipsa excepturi ducimus doloribus eum est.	465	843	10219	7892	7910	81	81
14111761	2015-119	862-33-5178	8098	273000	2	2015-08-22 09:51:55.362818	2015-04-22 23:03:46	2015-10-16 11:58:49	\N	458	830	10234	7989	7882	82	81
14121762	2015-120	653-33-5871	17078	251000	2	2014-12-22 20:53:18.098337	2015-05-30 17:14:19	2015-03-20 09:12:41	Ut qui voluptatem. Quasi ab ullam. Porro qui dolorum id ducimus aperiam dolores libero. Voluptas voluptatem deleniti. Illo quibusdam et dolor.	466	846	10388	7961	7917	82	81
14131683	2015-041	031-74-5695	34363	263000	1	2015-06-28 17:42:47.471046	2015-09-13 22:14:59	2015-11-09 21:43:23	Itaque est eveniet. Quis nemo quaerat nesciunt. Molestiae maiores aut voluptas. Esse quasi tenetur et porro consectetur voluptatum. Quia ipsam nisi et.	461	835	10239	7916	7922	81	82
14141684	2015-042	861-83-2265	39738	277000	1	2015-07-22 16:29:48.246577	2018-10-17 18:43:05	2015-08-08 02:10:16	Nemo voluptatem aliquid cum porro et et. Quis quos quod velit aut vel excepturi. Iste blanditiis qui eum fuga non cupiditate eveniet. Et dolorem soluta.	473	861	10249	7855	7932	82	82
14151685	2015-043	108-27-6172	27256	84000	1	2015-07-23 08:10:09.67103	2015-06-21 02:21:33	2015-11-12 04:14:11	Beatae voluptas et. Qui quibusdam alias pariatur ut laudantium ea culpa. Quia quos blanditiis distinctio.	465	843	10363	7983	7936	82	82
14161686	2015-044	829-24-0297	31756	257000	0	2015-03-24 07:29:49.036499	2015-09-07 08:45:53	\N	Esse quos quis expedita exercitationem. Quis veritatis facere adipisci. Mollitia architecto voluptatum.	471	855	10349	7922	7907	82	82
14171687	2015-045	060-83-5520	26024	33000	2	2015-01-21 22:10:58.576497	2015-11-08 11:13:02	2015-05-28 05:55:44	\N	468	850	10250	7865	7980	81	82
14181688	2015-046	683-43-1642	18829	255000	1	2015-06-25 05:11:24.201476	2015-09-04 15:20:26	2015-10-15 07:21:32	\N	468	850	10238	7994	7960	82	81
14191689	2015-047	368-85-9745	24312	112000	1	2015-02-20 14:43:50.007209	2015-06-27 03:05:41	2015-03-17 07:49:14	\N	471	854	10323	7963	7843	82	82
14201690	2015-048	885-01-4114	39507	146000	1	2015-08-18 15:33:57.700509	2015-04-15 08:40:27	2015-10-20 17:03:35	Non incidunt a eum non voluptatem. Vero enim et molestias repellat rem quia. Expedita consectetur sed dignissimos sit optio. Sapiente consectetur qui libero dolore et provident eum.	458	832	10224	7948	7959	82	82
14211691	2015-049	247-71-7879	13192	23000	1	2015-09-02 16:58:54.172567	2017-12-30 11:25:07	2015-11-25 23:00:47	Praesentium vel adipisci ipsam laboriosam eum. Saepe pariatur consequatur voluptas delectus molestiae. Velit aut voluptates omnis consequatur esse autem. Repellat eveniet accusantium officiis facere at.	463	\N	10285	7916	7934	81	82
14221692	2015-050	849-87-6211	38070	281000	2	2015-03-20 14:35:27.881872	2015-06-20 12:50:33	2015-12-03 20:16:56	\N	459	\N	10443	7876	8008	81	82
14231693	2015-051	558-29-6010	6337	36000	2	2015-05-21 17:37:48.356879	2015-08-03 18:03:50	2015-06-05 16:51:13	\N	460	834	10407	7969	7913	82	81
14241694	2015-052	757-90-4514	17612	297000	2	2015-08-01 20:57:17.885445	2018-05-06 08:44:00	2015-09-20 19:25:03	\N	472	856	10363	7827	7946	81	81
14251695	2015-053	124-67-4511	21371	309000	2	2015-06-20 09:21:16.105139	2018-05-07 21:07:36	2015-09-22 05:42:19	\N	469	\N	10300	8006	7996	81	82
14261696	2015-054	664-09-0136	19675	151000	1	2015-06-26 08:55:57.483887	2015-06-16 11:44:02	2015-09-26 15:24:41	\N	466	845	10345	8002	7930	82	82
14271697	2015-055	631-96-7253	31970	89000	2	2014-12-30 20:04:38.945141	2015-03-17 16:25:20	2015-07-06 14:49:32	Fuga voluptatem rerum quam eligendi quia. Illum ex voluptas debitis ipsa voluptatum aliquid. Et assumenda et alias enim voluptas velit nulla.	470	851	10259	7928	7894	81	82
14281698	2015-056	626-24-6965	12661	226000	0	2015-08-12 10:16:07.876364	2015-04-02 12:40:07	\N	Quod incidunt mollitia aliquid qui velit nihil sint. Debitis accusamus libero nostrum quisquam. Aperiam doloremque cum commodi dolorem.	460	834	10291	7936	7844	81	81
14291699	2015-057	053-94-5394	4613	179000	2	2015-04-15 09:42:24.696778	2015-06-14 21:11:51	2015-09-23 22:04:25	\N	470	851	10404	7848	7971	81	82
14301700	2015-058	293-05-8218	38006	152000	2	2015-04-24 10:12:13.921347	2017-12-19 22:24:30	2015-10-28 12:47:53	\N	463	\N	10238	7958	7930	81	82
14311701	2015-059	157-14-5334	17374	111000	2	2015-01-06 13:30:58.214726	2018-01-30 21:55:44	2015-09-07 07:34:00	\N	469	\N	10231	7912	7978	81	81
14321702	2015-060	574-47-0065	6555	147000	0	2015-06-07 04:18:12.515361	2018-11-12 08:40:10	\N	Autem mollitia quisquam sed. Sed non id omnis culpa. Doloremque odio consequatur nihil aut magni eos.	469	\N	10264	7994	7960	82	81
1433\.
1434
1435
1436--
1437-- Name: projects_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
1438--
1439
1440SELECT pg_catalog.setval('projects_id_seq', 1762, true);
1441
1442
1443--
1444-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: agufranov
1445--
1446
1447COPY schema_migrations (version) FROM stdin;
14481
14492
14503
14514
14525
14536
14547
14558
14569
145710
145811
145912
146013
146114
146215
146316
1464\.
1465
1466
1467--
1468-- Data for Name: specialities; Type: TABLE DATA; Schema: public; Owner: agufranov
1469--
1470
1471COPY specialities (id, title) FROM stdin;
147281	Speciality 1
147382	Speciality 2
1474\.
1475
1476
1477--
1478-- Name: specialities_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
1479--
1480
1481SELECT pg_catalog.setval('specialities_id_seq', 82, true);
1482
1483
1484--
1485-- Data for Name: vendor_countries; Type: TABLE DATA; Schema: public; Owner: agufranov
1486--
1487
1488COPY vendor_countries (id, vendor_id, country_id) FROM stdin;
1489614	646	10298
1490615	646	10260
1491616	650	10228
1492617	652	10239
1493618	652	10389
1494619	653	10225
1495620	655	10282
1496621	655	10424
1497622	658	10244
1498623	662	10296
1499624	662	10373
1500625	663	10329
1501626	663	10364
1502627	664	10328
1503628	664	10248
1504629	665	10415
1505630	666	10255
1506631	666	10298
1507632	667	10316
1508633	667	10300
1509634	669	10379
1510635	670	10333
1511636	670	10227
1512637	671	10241
1513638	671	10294
1514639	673	10397
1515640	673	10400
1516641	674	10425
1517642	675	10287
1518643	677	10400
1519644	677	10220
1520645	678	10269
1521646	679	10414
1522647	679	10437
1523648	681	10318
1524649	682	10419
1525650	683	10241
1526651	683	10245
1527652	684	10284
1528653	684	10247
1529654	685	10407
1530655	687	10367
1531656	689	10439
1532657	690	10284
1533658	690	10213
1534659	693	10350
1535660	695	10208
1536661	696	10449
1537662	697	10351
1538663	697	10444
1539664	698	10435
1540665	700	10375
1541666	700	10330
1542667	702	10372
1543668	702	10258
1544669	703	10254
1545670	704	10404
1546671	706	10256
1547672	708	10348
1548673	709	10339
1549674	709	10268
1550675	710	10336
1551676	710	10286
1552677	711	10306
1553678	715	10362
1554679	715	10269
1555680	717	10254
1556681	717	10209
1557682	718	10340
1558683	718	10364
1559684	719	10401
1560685	719	10443
1561686	722	10411
1562687	725	10437
1563688	725	10318
1564\.
1565
1566
1567--
1568-- Name: vendor_countries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
1569--
1570
1571SELECT pg_catalog.setval('vendor_countries_id_seq', 688, true);
1572
1573
1574--
1575-- Data for Name: vendor_languages; Type: TABLE DATA; Schema: public; Owner: agufranov
1576--
1577
1578COPY vendor_languages (id, vendor_id, language_id, proficiency) FROM stdin;
1579795	646	7952	3
1580796	646	7991	3
1581797	647	7998	2
1582798	648	7983	2
1583799	648	7853	1
1584800	649	7894	3
1585801	650	7933	3
1586802	650	7860	2
1587803	651	7870	1
1588804	651	7853	0
1589805	652	7883	1
1590806	653	7976	2
1591807	653	8005	0
1592808	654	7985	1
1593809	654	7963	1
1594810	655	7900	0
1595811	655	7926	0
1596812	656	7883	3
1597813	656	7827	1
1598814	657	7948	1
1599815	657	7838	3
1600816	658	7960	3
1601817	659	7899	1
1602818	659	7872	3
1603819	660	7839	3
1604820	660	7928	1
1605821	661	7988	2
1606822	662	7876	0
1607823	663	7981	3
1608824	664	7879	3
1609825	664	7891	1
1610826	665	7931	2
1611827	666	7870	1
1612828	666	7951	1
1613829	667	7878	3
1614830	668	7989	0
1615831	668	7948	2
1616832	669	7986	3
1617833	670	7944	2
1618834	671	8000	1
1619835	671	7986	0
1620836	672	7978	2
1621837	673	8007	0
1622838	674	7988	1
1623839	675	7927	3
1624840	676	7961	0
1625841	676	7864	1
1626842	677	7982	2
1627843	678	7846	1
1628844	678	7990	0
1629845	679	7968	1
1630846	679	8005	2
1631847	680	7933	2
1632848	681	8003	2
1633849	682	7963	3
1634850	682	7882	1
1635851	683	7873	2
1636852	683	7921	3
1637853	684	7838	2
1638854	685	7914	2
1639855	686	7872	1
1640856	686	7981	1
1641857	687	7926	1
1642858	688	8007	0
1643859	688	7971	3
1644860	689	7862	3
1645861	689	7905	3
1646862	690	7841	2
1647863	690	7938	1
1648864	691	7897	2
1649865	692	7926	0
1650866	692	7992	1
1651867	693	7973	2
1652868	693	7940	2
1653869	694	7857	0
1654870	694	7983	3
1655871	695	8002	1
1656872	695	7908	0
1657873	696	7915	3
1658874	697	7989	1
1659875	698	7903	0
1660876	699	7865	1
1661877	700	7887	3
1662878	700	7888	1
1663879	701	7850	1
1664880	702	7966	3
1665881	703	7863	3
1666882	703	7904	0
1667883	704	7834	0
1668884	704	7920	3
1669885	705	7881	0
1670886	706	7904	0
1671887	706	7870	0
1672888	707	7929	1
1673889	708	7994	1
1674890	709	7957	3
1675891	709	8002	3
1676892	710	8000	3
1677893	711	7881	0
1678894	712	7859	3
1679895	713	7834	2
1680896	714	7874	3
1681897	714	7985	2
1682898	715	7950	2
1683899	715	7890	3
1684900	716	7988	0
1685901	717	7973	3
1686902	717	7837	0
1687903	718	7898	0
1688904	718	7999	0
1689905	719	7866	1
1690906	720	7948	2
1691907	721	7916	0
1692908	721	7871	0
1693909	722	7830	1
1694910	723	7899	2
1695911	723	7882	3
1696912	724	7948	3
1697913	724	7837	3
1698914	725	7863	3
1699\.
1700
1701
1702--
1703-- Name: vendor_languages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
1704--
1705
1706SELECT pg_catalog.setval('vendor_languages_id_seq', 914, true);
1707
1708
1709--
1710-- Data for Name: vendors; Type: TABLE DATA; Schema: public; Owner: agufranov
1711--
1712
1713COPY vendors (id, name, mapi_code, tasks_flags, rate_hour_cents, rate_interview_cents, rate_word_cents, comments, profession_id, condition_id, speciality_id) FROM stdin;
1714646	Dangelo Kerluke V	S6297300E	106	1700	1200	1700	Fixie pbr&b bushwick cardigan.	166	82	82
1715647	Brenda Robel DDS	S7072745E	37	1000	1700	2000	Pbr&b cronut paleo beard raw denim.	157	82	81
1716648	Kameron Maggio	S5884142J	138	2300	2400	1200	Viral readymade drinking yuccie intelligentsia goth vegan messenger bag health.	175	81	81
1717649	Mr. Emmett Herman	S5350099D	116	1400	1500	1700	Cliche craft beer mlkshk pitchfork bespoke sustainable loko.	165	82	82
1718650	Seth Reinger	S7482653I	31	2100	700	1600	Listicle beard literally bicycle rights chartreuse chia.	157	81	82
1719651	Maximilian Gulgowski	S9120705B	83	500	1200	2200	Put a bird on it cold-pressed single-origin coffee schlitz shabby chic cardigan chillwave.	168	81	81
1720652	Otha Renner Jr.	S6749550J	18	700	1900	1300	Banh mi vice brunch neutra selvage synth master +1.	180	82	82
1721653	Kyra Beahan II	S5657575H	107	600	1700	2400	Portland tacos bitters truffaut distillery viral listicle before they sold out pug.	163	81	82
1722654	Abigale Robel MD	S7500265C	237	1900	1400	2300	You probably haven't heard of them ramps waistcoat put a bird on it fingerstache next level shabby chic hoodie.	175	81	81
1723655	Trevion Krajcik	S8034402C	39	900	1600	1200	Fingerstache hella plaid post-ironic raw denim migas pop-up.	169	81	81
1724656	Josefina Rice	S8633860B	187	600	1900	800	Asymmetrical vhs gastropub hoodie cornhole shabby chic hella.	168	81	82
1725657	Kayla Bogan	S7410831H	241	500	1000	1500	Blue bottle vice iphone pitchfork.	167	81	82
1726658	Maximillian Ebert	S6210883E	7	2200	1500	2200	Tilde chartreuse chicharrones authentic green juice kickstarter.	178	81	82
1727659	Mr. Brenna Anderson	S9772528D	249	2300	500	2400	Craft beer whatever asymmetrical narwhal yr tumblr keytar tattooed diy.	179	82	81
1728660	Alanna Jaskolski	S8694615G	40	800	2000	1200	Small batch pug ethical health.	158	81	82
1729661	Neal Larkin MD	S7083368I	161	1600	1100	2000	Salvia kogi typewriter venmo vinegar tumblr.	172	82	81
1730662	Raleigh Lockman	S5626843Z	111	500	800	800	Tacos fixie park ugh asymmetrical mixtape lumbersexual.	167	82	82
1731663	Mozelle Graham	S6330001B	54	1000	1700	1500	Park readymade tilde ugh thundercats kitsch hammock austin.	162	82	81
1732664	Lazaro Welch	S9703019G	175	600	900	1300	Hella 3 wolf moon tilde cray gastropub hammock meh vinyl.	176	82	82
1733665	Ms. Marcelina Simonis	S9167781D	211	1200	1800	1400	Celiac intelligentsia wolf brooklyn 8-bit.	157	82	82
1734666	Samson Russel	S8255245F	228	500	800	1000	Slow-carb bicycle rights swag semiotics photo booth poutine truffaut.	175	82	81
1735667	Gregg Gusikowski	S5095426I	210	1200	900	2200	Meggings biodiesel salvia taxidermy.	181	82	81
1736668	Providenci Lang	S7717878C	195	1300	2300	2400	Intelligentsia kale chips green juice ugh.	159	81	81
1737669	Sabina Jast	S9252647Z	155	2300	1000	1100	Gastropub xoxo hashtag carry pork belly seitan blue bottle.	169	81	81
1738670	Gideon Boyer	S9707683I	49	500	2400	2300	Retro fixie chartreuse cardigan 90's organic celiac.	169	81	81
1739671	Amanda Bahringer Jr.	S8653223I	16	1800	1300	1600	Hammock cardigan jean shorts aesthetic pinterest kitsch bushwick cliche.	173	81	82
1740672	Tyreek Tillman Jr.	S5461945F	179	2200	2400	1300	Helvetica bushwick 8-bit goth.	182	82	82
1741673	Neil Stracke	S8948117A	50	2400	1600	1800	Schlitz echo migas actually sartorial banh mi pbr&b.	173	81	81
1742674	Hayley Christiansen	S5800002G	28	1800	2300	1600	Art party thundercats locavore mustache jean shorts.	174	81	81
1743675	Polly Vandervort	S5307265H	218	500	1500	1200	Ugh pug semiotics viral everyday.	169	81	81
1744676	Nick Funk	S9122974I	195	1700	1300	2400	Celiac squid lomo synth xoxo.	171	81	82
1745677	Kirstin Labadie	S6063107G	115	1100	1700	2300	Godard next level plaid park tumblr carry.	161	82	82
1746678	Lelah Leannon	S6405292F	137	2200	2300	1800	Organic intelligentsia master kogi put a bird on it tattooed small batch biodiesel vinegar.	176	81	81
1747679	Alexandria Price	S8796305E	212	700	2100	500	Flannel lumbersexual austin intelligentsia heirloom microdosing chia.	173	82	81
1748680	Heber Bernier	S5516050C	120	1300	1300	2400	Sustainable farm-to-table portland street.	174	81	82
1749681	Mason Heller III	S5785146E	47	1300	2100	900	Polaroid post-ironic asymmetrical bushwick meggings messenger bag trust fund.	159	81	81
1750682	Eriberto McDermott II	S5359434D	199	600	2400	2300	Cliche waistcoat chicharrones kombucha cleanse butcher.	176	81	81
1751683	Meta Quitzon IV	S7048573G	230	2200	2200	2000	Sustainable irony pickled thundercats plaid kinfolk.	172	82	81
1752684	Haskell Zieme	S6955233A	107	900	500	1400	Williamsburg bitters carry farm-to-table twee hashtag typewriter thundercats.	170	81	81
1753685	Lawrence Bernhard MD	S8453543E	237	1500	1100	2000	Food truck synth portland tacos 3 wolf moon.	177	81	81
1754686	Justus Goodwin	S8008109Z	78	1000	1000	1900	Aesthetic tofu master celiac fanny pack.	164	81	81
1755687	Willard Wiza	S8564947G	185	1400	800	2100	Shabby chic tilde dreamcatcher narwhal waistcoat wes anderson normcore gluten-free austin.	180	82	82
1756688	Fannie Collins	S8690002E	230	1200	1200	600	Ethical mlkshk farm-to-table pug intelligentsia.	176	82	81
1757689	Lyla Balistreri II	S8937616E	58	1900	1900	1200	Plaid xoxo ennui cliche pour-over paleo synth.	177	82	82
1758690	Eldora Witting	S8199332G	55	600	500	900	Pork belly umami direct trade readymade.	173	81	81
1759691	Laverna Conn	S8487853G	4	1100	1600	1100	Ugh normcore dreamcatcher artisan crucifix offal pickled umami mlkshk.	166	81	81
1760692	Marlin Gleichner DDS	S6316802E	224	600	600	2400	Organic schlitz ugh master forage gluten-free you probably haven't heard of them.	161	81	81
1761693	Trey Klein I	S7075790G	155	1800	2000	2200	Pinterest semiotics sartorial selfies small batch.	164	82	81
1762694	Kristy Kihn	S9650551E	212	1600	1300	2100	Banh mi art party pinterest deep v venmo kinfolk artisan.	182	81	82
1763695	Emelia Miller	S6343666F	212	2300	1900	1300	Williamsburg portland neutra microdosing +1.	160	81	82
1764696	Lacy Koepp	S8355745A	28	2200	700	1100	Pinterest cronut next level bitters.	170	82	82
1765697	Vern Bradtke	S6666398A	52	700	2000	2200	Microdosing pickled vinegar kale chips knausgaard yr godard food truck.	159	81	81
1766698	Lennie Tillman I	S6647283C	197	1100	1600	2300	Xoxo intelligentsia goth letterpress disrupt pour-over cornhole dreamcatcher drinking.	168	82	82
1767699	Jaylin Stokes I	S5892552G	43	1400	1600	500	Swag plaid vegan etsy.	166	82	82
1768700	Webster Daugherty	S9051950F	36	2300	1600	1300	Ramps put a bird on it irony ugh mixtape.	166	82	81
1769701	Aurelia Reinger	S7650110F	236	600	1100	500	Cred offal cardigan cronut.	178	81	81
1770702	Una Schmitt	S9609395J	62	1000	700	600	Cornhole drinking keffiyeh hoodie.	158	82	82
1771703	Jaiden Block	S8356230G	172	900	700	1600	Cray fanny pack 3 wolf moon deep v park aesthetic wes anderson.	168	82	81
1772704	Willa Huel	S7339972F	129	1200	1500	1200	Tilde banh mi swag fap authentic.	157	81	81
1773705	Alva Christiansen	S6991332F	238	1500	2100	1000	Roof hammock goth asymmetrical meditation chia plaid tattooed.	171	82	82
1774706	Nia Schimmel	S5477919D	234	600	2300	1300	Brunch master try-hard bitters portland mumblecore photo booth mixtape authentic.	178	81	82
1775707	Jessyca Langosh	S6688397C	95	2200	1700	1400	Kogi sustainable thundercats street 3 wolf moon health crucifix farm-to-table.	175	81	82
1776708	Tessie Bashirian	S5475392F	36	700	1700	900	Mustache keytar franzen gentrify disrupt microdosing shabby chic tofu.	182	81	82
1777709	Saige Reynolds	S9682364I	127	700	2300	1000	Chicharrones tattooed swag squid roof tumblr street organic lo-fi.	174	81	82
1778710	Waino Rodriguez	S5816476C	5	1700	1500	1600	Shabby chic tumblr migas marfa hella neutra forage trust fund.	165	82	82
1779711	Fredrick Bashirian	S7440587H	131	1300	2000	1200	Goth everyday disrupt pour-over food truck trust fund paleo meh swag.	165	82	81
1780712	Fredrick Huel	S7440229A	106	2200	1600	1900	Brooklyn loko synth authentic.	171	81	81
1781713	Jaylan Grant	S7664012B	147	1500	2400	1900	Quinoa cliche helvetica diy banjo cred letterpress fap carry.	159	82	82
1782714	Mara Rath	S5545245H	34	2400	1900	800	Disrupt offal actually heirloom jean shorts meggings intelligentsia sriracha.	177	82	82
1783715	Quinn Abernathy	S5996116J	3	600	600	700	Blue bottle pour-over quinoa chillwave meh.	161	82	81
1784716	Miss Emmitt Upton	S7508806Z	28	1300	1300	500	Tousled gastropub small batch next level cleanse drinking bitters paleo.	174	82	82
1785717	Miss Tito Green	S5336741J	3	1100	1000	900	Craft beer meh put a bird on it art party.	166	82	82
1786718	Dr. Sterling Mosciski	S6469566E	96	1300	1500	1700	Williamsburg cliche selvage pickled pop-up park pitchfork synth.	176	81	82
1787719	Candido Pollich	S8144140E	216	1400	1800	1100	Ethical asymmetrical vinegar before they sold out.	178	81	82
1788720	Ms. Jordan Miller	S6424038B	156	500	700	2400	Goth mlkshk roof skateboard.	172	82	82
1789721	Belle Grimes	S8973019H	45	500	1300	1200	Viral narwhal echo church-key sartorial.	171	81	82
1790722	Shanel Heller	S7555172Z	248	1300	1100	700	Synth meh mlkshk hashtag skateboard fap tattooed kinfolk.	164	82	81
1791723	Vinnie Adams	S8595269B	248	2400	800	1400	Sustainable butcher hella slow-carb.	175	82	82
1792724	Jo Oberbrunner	S7813389I	218	1400	900	2200	Plaid skateboard artisan fap offal tilde.	173	82	81
1793725	Duncan Bradtke	S6684034D	254	2200	2000	1400	Mustache pickled cronut neutra readymade wayfarers narwhal venmo meditation.	170	81	81
1794\.
1795
1796
1797--
1798-- Name: vendors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: agufranov
1799--
1800
1801SELECT pg_catalog.setval('vendors_id_seq', 725, true);
1802
1803
1804--
1805-- Name: assignments_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1806--
1807
1808ALTER TABLE ONLY assignments
1809    ADD CONSTRAINT assignments_pkey PRIMARY KEY (id);
1810
1811
1812--
1813-- Name: clients_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1814--
1815
1816ALTER TABLE ONLY clients
1817    ADD CONSTRAINT clients_pkey PRIMARY KEY (id);
1818
1819
1820--
1821-- Name: conditions_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1822--
1823
1824ALTER TABLE ONLY conditions
1825    ADD CONSTRAINT conditions_pkey PRIMARY KEY (id);
1826
1827
1828--
1829-- Name: countries_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1830--
1831
1832ALTER TABLE ONLY countries
1833    ADD CONSTRAINT countries_pkey PRIMARY KEY (id);
1834
1835
1836--
1837-- Name: languages_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1838--
1839
1840ALTER TABLE ONLY languages
1841    ADD CONSTRAINT languages_pkey PRIMARY KEY (id);
1842
1843
1844--
1845-- Name: professions_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1846--
1847
1848ALTER TABLE ONLY professions
1849    ADD CONSTRAINT professions_pkey PRIMARY KEY (id);
1850
1851
1852--
1853-- Name: project_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1854--
1855
1856ALTER TABLE ONLY project_managers
1857    ADD CONSTRAINT project_managers_pkey PRIMARY KEY (id);
1858
1859
1860--
1861-- Name: projects_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1862--
1863
1864ALTER TABLE ONLY projects
1865    ADD CONSTRAINT projects_pkey PRIMARY KEY (id);
1866
1867
1868--
1869-- Name: specialities_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1870--
1871
1872ALTER TABLE ONLY specialities
1873    ADD CONSTRAINT specialities_pkey PRIMARY KEY (id);
1874
1875
1876--
1877-- Name: vendor_countries_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1878--
1879
1880ALTER TABLE ONLY vendor_countries
1881    ADD CONSTRAINT vendor_countries_pkey PRIMARY KEY (id);
1882
1883
1884--
1885-- Name: vendor_languages_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1886--
1887
1888ALTER TABLE ONLY vendor_languages
1889    ADD CONSTRAINT vendor_languages_pkey PRIMARY KEY (id);
1890
1891
1892--
1893-- Name: vendors_pkey; Type: CONSTRAINT; Schema: public; Owner: agufranov; Tablespace: 
1894--
1895
1896ALTER TABLE ONLY vendors
1897    ADD CONSTRAINT vendors_pkey PRIMARY KEY (id);
1898
1899
1900--
1901-- Name: index_assignments_on_vendor_id_and_project_id; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1902--
1903
1904CREATE UNIQUE INDEX index_assignments_on_vendor_id_and_project_id ON assignments USING btree (vendor_id, project_id);
1905
1906
1907--
1908-- Name: index_conditions_on_name; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1909--
1910
1911CREATE UNIQUE INDEX index_conditions_on_name ON conditions USING btree (name);
1912
1913
1914--
1915-- Name: index_countries_on_name; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1916--
1917
1918CREATE UNIQUE INDEX index_countries_on_name ON countries USING btree (name);
1919
1920
1921--
1922-- Name: index_languages_on_name; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1923--
1924
1925CREATE UNIQUE INDEX index_languages_on_name ON languages USING btree (name);
1926
1927
1928--
1929-- Name: index_professions_on_title; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1930--
1931
1932CREATE UNIQUE INDEX index_professions_on_title ON professions USING btree (title);
1933
1934
1935--
1936-- Name: index_projects_on_number; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1937--
1938
1939CREATE UNIQUE INDEX index_projects_on_number ON projects USING btree (number);
1940
1941
1942--
1943-- Name: index_specialities_on_title; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1944--
1945
1946CREATE UNIQUE INDEX index_specialities_on_title ON specialities USING btree (title);
1947
1948
1949--
1950-- Name: index_vendor_countries_on_vendor_id_and_country_id; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1951--
1952
1953CREATE UNIQUE INDEX index_vendor_countries_on_vendor_id_and_country_id ON vendor_countries USING btree (vendor_id, country_id);
1954
1955
1956--
1957-- Name: index_vendor_languages_on_vendor_id_and_language_id; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1958--
1959
1960CREATE UNIQUE INDEX index_vendor_languages_on_vendor_id_and_language_id ON vendor_languages USING btree (vendor_id, language_id);
1961
1962
1963--
1964-- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: agufranov; Tablespace: 
1965--
1966
1967CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
1968
1969
1970--
1971-- Name: fk_rails_102d49228a; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
1972--
1973
1974ALTER TABLE ONLY vendor_languages
1975    ADD CONSTRAINT fk_rails_102d49228a FOREIGN KEY (vendor_id) REFERENCES vendors(id);
1976
1977
1978--
1979-- Name: fk_rails_156fe9f60c; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
1980--
1981
1982ALTER TABLE ONLY projects
1983    ADD CONSTRAINT fk_rails_156fe9f60c FOREIGN KEY (speciality_id) REFERENCES specialities(id);
1984
1985
1986--
1987-- Name: fk_rails_24a132526a; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
1988--
1989
1990ALTER TABLE ONLY projects
1991    ADD CONSTRAINT fk_rails_24a132526a FOREIGN KEY (country_id) REFERENCES countries(id);
1992
1993
1994--
1995-- Name: fk_rails_3549273dc2; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
1996--
1997
1998ALTER TABLE ONLY projects
1999    ADD CONSTRAINT fk_rails_3549273dc2 FOREIGN KEY (project_manager_id) REFERENCES project_managers(id);
2000
2001
2002--
2003-- Name: fk_rails_4d3d2c839c; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2004--
2005
2006ALTER TABLE ONLY assignments
2007    ADD CONSTRAINT fk_rails_4d3d2c839c FOREIGN KEY (project_id) REFERENCES projects(id);
2008
2009
2010--
2011-- Name: fk_rails_6a4bb456c6; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2012--
2013
2014ALTER TABLE ONLY projects
2015    ADD CONSTRAINT fk_rails_6a4bb456c6 FOREIGN KEY (condition_id) REFERENCES conditions(id);
2016
2017
2018--
2019-- Name: fk_rails_74246e9b3a; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2020--
2021
2022ALTER TABLE ONLY vendors
2023    ADD CONSTRAINT fk_rails_74246e9b3a FOREIGN KEY (profession_id) REFERENCES professions(id);
2024
2025
2026--
2027-- Name: fk_rails_8d9657cec3; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2028--
2029
2030ALTER TABLE ONLY projects
2031    ADD CONSTRAINT fk_rails_8d9657cec3 FOREIGN KEY (client_id) REFERENCES clients(id);
2032
2033
2034--
2035-- Name: fk_rails_a0697f438d; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2036--
2037
2038ALTER TABLE ONLY vendors
2039    ADD CONSTRAINT fk_rails_a0697f438d FOREIGN KEY (speciality_id) REFERENCES specialities(id);
2040
2041
2042--
2043-- Name: fk_rails_b48dd4d0f7; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2044--
2045
2046ALTER TABLE ONLY clients
2047    ADD CONSTRAINT fk_rails_b48dd4d0f7 FOREIGN KEY (country_id) REFERENCES countries(id);
2048
2049
2050--
2051-- Name: fk_rails_ba30d1a3e1; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2052--
2053
2054ALTER TABLE ONLY project_managers
2055    ADD CONSTRAINT fk_rails_ba30d1a3e1 FOREIGN KEY (client_id) REFERENCES clients(id);
2056
2057
2058--
2059-- Name: fk_rails_bc6c1c3a37; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2060--
2061
2062ALTER TABLE ONLY vendors
2063    ADD CONSTRAINT fk_rails_bc6c1c3a37 FOREIGN KEY (condition_id) REFERENCES conditions(id);
2064
2065
2066--
2067-- Name: fk_rails_c3863b55f1; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2068--
2069
2070ALTER TABLE ONLY vendor_countries
2071    ADD CONSTRAINT fk_rails_c3863b55f1 FOREIGN KEY (country_id) REFERENCES countries(id);
2072
2073
2074--
2075-- Name: fk_rails_cfaed64ff3; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2076--
2077
2078ALTER TABLE ONLY vendor_countries
2079    ADD CONSTRAINT fk_rails_cfaed64ff3 FOREIGN KEY (vendor_id) REFERENCES vendors(id);
2080
2081
2082--
2083-- Name: fk_rails_ecf30ce61e; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2084--
2085
2086ALTER TABLE ONLY vendor_languages
2087    ADD CONSTRAINT fk_rails_ecf30ce61e FOREIGN KEY (language_id) REFERENCES languages(id);
2088
2089
2090--
2091-- Name: fk_rails_ef42a526ae; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2092--
2093
2094ALTER TABLE ONLY projects
2095    ADD CONSTRAINT fk_rails_ef42a526ae FOREIGN KEY (original_language_id) REFERENCES languages(id);
2096
2097
2098--
2099-- Name: fk_rails_f351cdedca; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2100--
2101
2102ALTER TABLE ONLY projects
2103    ADD CONSTRAINT fk_rails_f351cdedca FOREIGN KEY (target_language_id) REFERENCES languages(id);
2104
2105
2106--
2107-- Name: fk_rails_f6f2a82126; Type: FK CONSTRAINT; Schema: public; Owner: agufranov
2108--
2109
2110ALTER TABLE ONLY assignments
2111    ADD CONSTRAINT fk_rails_f6f2a82126 FOREIGN KEY (vendor_id) REFERENCES vendors(id);
2112
2113
2114--
2115-- Name: public; Type: ACL; Schema: -; Owner: postgres
2116--
2117
2118REVOKE ALL ON SCHEMA public FROM PUBLIC;
2119REVOKE ALL ON SCHEMA public FROM postgres;
2120GRANT ALL ON SCHEMA public TO postgres;
2121GRANT ALL ON SCHEMA public TO PUBLIC;
2122
2123
2124--
2125-- PostgreSQL database dump complete
2126--