add-expirience-points.sql

-- to apply use: cat add-expirience-points.sql | docker exec -i vp-pg-master psql -Upostgres vp
COPY public.experience_point (id, deleted, filterable, description, name) FROM stdin;
53	f	t	Geekhub courses	GeekHub
54	f	t	SPD-University courses	SPD-University
55	f	t	Previous Job	Previous Job
57	f	t	Information about other courses	Other Courses
58	f	t	Certificates	Certification
59	f	t	Education	Education
61	f	t	\N	Foreign languages
\.

COPY public.experience_point_field (id, deleted, name, type, experience_point_id, filterable, required) FROM stdin;
54	f	Season	SELECT	53	t	t
55	f	Specialization	SELECT	53	t	t
56	f	Type	SELECT	53	t	t
57	f	Result	SELECT	53	t	t
58	f	Year of graduation	SELECT	54	t	t
59	f	Specialization	SELECT	54	t	t
60	f	Type	SELECT	54	t	t
61	f	Result	SELECT	54	t	t
62	f	Company name	TEXT_ONE_LINE	55	t	t
63	f	Experience in company	DATERANGE	55	t	t
64	f	Position	SELECT	55	t	t
72	f	Courses name	TEXT_ONE_LINE	57	t	t
73	f	Courses website	TEXT_ONE_LINE	57	f	f
74	f	Courses type	SELECT	57	f	f
75	f	Year of graduation	NUMBER	57	t	t
76	f	Specialization	SELECT	57	t	t
77	f	Type	SELECT	57	f	t
78	f	Result	SELECT	57	t	t
79	f	Comment	TEXT_ONE_LINE	57	f	t
80	f	Certificate name	TEXT_ONE_LINE	58	t	t
81	f	Year of certification	NUMBER	58	f	f
82	f	Comment	TEXT_ONE_LINE	58	f	t
83	f	University name	TEXT_ONE_LINE	59	t	t
84	f	Specialization	TEXT_ONE_LINE	59	t	t
85	f	Year of graduation	NUMBER	59	t	f
86	f	Diploma	SELECT	59	t	f
87	f	Average diploma score	NUMBER	59	t	f
88	f	Comment	TEXT_ONE_LINE	59	f	t
90	f	Language	MULTISELECT	61	t	f
91	f	Level	MULTISELECT	61	t	t
65	f	Comment	TEXT_ONE_LINE	55	f	f
\.

COPY public.experience_point_field_value (id, string, experience_point_field_id, is_custom, is_default, start_date, end_date, number, deleted) FROM stdin;
70	8	54	f	t	\N	\N	\N	f
71	7	54	f	f	\N	\N	\N	f
72	6	54	f	f	\N	\N	\N	f
73	5	54	f	f	\N	\N	\N	f
74	4	54	f	f	\N	\N	\N	f
75	3	54	f	f	\N	\N	\N	f
76	2	54	f	f	\N	\N	\N	f
77	1	54	f	f	\N	\N	\N	f
78	Java for Web	55	f	t	\N	\N	\N	f
79	Frontend + CMS	55	f	f	\N	\N	\N	f
80	Frontend + JS	55	f	f	\N	\N	\N	f
81	Ruby on Rails	55	f	f	\N	\N	\N	f
82	JavaScript	55	f	f	\N	\N	\N	f
83	Advanced PHP	55	f	f	\N	\N	\N	f
84	Quality Assurance	55	f	f	\N	\N	\N	f
85	Android	55	f	f	\N	\N	\N	f
86	Project Management	55	f	f	\N	\N	\N	f
87	Data Science & Python	55	f	f	\N	\N	\N	f
88	Student	56	f	t	\N	\N	\N	f
89	Free visitor	56	f	f	\N	\N	\N	f
90	Graduated	57	f	t	\N	\N	\N	f
91	Not graduated	57	f	f	\N	\N	\N	f
92	2018	58	f	t	\N	\N	\N	f
93	2017	58	f	f	\N	\N	\N	f
94	2016	58	f	f	\N	\N	\N	f
95	2015	58	f	f	\N	\N	\N	f
96	Java for Web	59	f	t	\N	\N	\N	f
97	Front-end	59	f	f	\N	\N	\N	f
98	Student	60	f	t	\N	\N	\N	f
99	Free visitor	60	f	f	\N	\N	\N	f
100	Graduated	61	f	t	\N	\N	\N	f
101	Not graduated	61	f	f	\N	\N	\N	f
102		62	f	t	\N	\N	\N	f
104	Front-end Developer	64	f	f	\N	\N	\N	f
105	QA	64	f	f	\N	\N	\N	f
106	Project Manager	64	f	f	\N	\N	\N	f
107	Data Scientist	64	f	f	\N	\N	\N	f
108	Career Advisor	64	f	f	\N	\N	\N	f
109	QA Automation	64	f	f	\N	\N	\N	f
110	DevOps	64	f	f	\N	\N	\N	f
111	HR	64	f	f	\N	\N	\N	f
112	Tech Lead	64	f	f	\N	\N	\N	f
113	Team Lead	64	f	f	\N	\N	\N	f
132		72	f	t	\N	\N	\N	f
133		73	f	t	\N	\N	\N	f
134	Offline courses	74	f	t	\N	\N	\N	f
135	Online courses	74	f	f	\N	\N	\N	f
136	\N	75	f	t	\N	\N	2018	f
137	Java Developer	76	f	t	\N	\N	\N	f
138	Front-end Developer	76	f	f	\N	\N	\N	f
139	QA	76	f	f	\N	\N	\N	f
140	Project Manager	76	f	f	\N	\N	\N	f
141	Data Scientist	76	f	f	\N	\N	\N	f
142	Career Advisor	76	f	f	\N	\N	\N	f
143	QA Automation	76	f	f	\N	\N	\N	f
144	DevOps	76	f	f	\N	\N	\N	f
145	HR	76	f	f	\N	\N	\N	f
146	Tech Lead	76	f	f	\N	\N	\N	f
147	Team Lead	76	f	f	\N	\N	\N	f
148	Student	77	f	t	\N	\N	\N	f
149	Free visitor	77	f	f	\N	\N	\N	f
150	Graduated	78	f	t	\N	\N	\N	f
151	Not graduated	78	f	f	\N	\N	\N	f
152		80	f	t	\N	\N	\N	f
153	\N	81	f	t	\N	\N	2018	f
154		83	f	t	\N	\N	\N	f
155		84	f	t	\N	\N	\N	f
156	\N	85	f	t	\N	\N	2018	f
157	Common	86	f	t	\N	\N	\N	f
158	Red	86	f	f	\N	\N	\N	f
159	\N	87	f	t	\N	\N	5	f
206	Kotlin Developer	76	f	t	\N	\N	\N	f
208	Quality Assurance	59	f	t	\N	\N	\N	f
160	eCreative	62	t	f	\N	\N	\N	f
161	\N	63	t	f	2018-01-24 22:00:00	2018-09-03 21:00:00	\N	f
162	Some comment	65	t	f	\N	\N	\N	f
202	Harvard	83	t	f	\N	\N	\N	f
203	JSON Writer	84	t	f	\N	\N	\N	f
204	\N	87	t	f	\N	\N	4.85	f
205	Some comment	88	t	f	\N	\N	\N	f
\.