EDcNjGX7

1create table if not exists Project (
2	id int(10) NOT NULL,
3	name varchar(255),
4	active int(1),
5	PRIMARY KEY(id)
6);
7
8create table if not exists Job (
9	id int(10) NOT NULL,
10	id_project int(10),
11	position varchar(255),
12	date datetime,
13	PRIMARY KEY(id)
14);
15
16insert into Project values(1, 'name_1', 0);
17insert into Project values(2, 'name_2', 1);
18insert into Project values(3, 'name_3', 1);
19
20insert into Job values(1, 1, 'position_1', '2018-01-10 23:18:25.303');
21insert into Job values(2, 2, 'position_2', '2018-11-01 15:12:53.233');
22insert into Job values(3, 3, 'position%_1', '2018-11-01 15:18:03.267');
23insert into Job values(4, 3, 'position_3', '2018-08-30 18:53:49.877');