text: 
  -- Users
  INSERT INTO trainingtool.user (username, pnr, role, firstname, lastname, sector, managername, function) 
  	VALUES ('admin', 'LPS001', 'MEMBER:ADMIN', 'AdminFirstname', 'AdminLastname',  null, null, 'Application Admin');
  INSERT INTO trainingtool.user (username, pnr, role, firstname, lastname, sector, managername, function) 
  	VALUES ('training', 'LPS002', 'MEMBER:TRAINING', 'TrainingFirstname', 'TrainingLastname', null, null, 'Training Team');
  INSERT INTO trainingtool.user (username, pnr, role, firstname, lastname, sector, managername, function) 
  	VALUES ('hr', 'LPS003', 'MEMBER:MANAGER:HR', 'HrFirstname', 'HrLastname', null, null, 'HR Team');
  INSERT INTO trainingtool.user (username, pnr, role, firstname, lastname, sector, phone_number, managername, function) 
  	VALUES ('manager', 'LPS004', 'MEMBER:MANAGER', 'MgrFirstname', 'MgrLastname', 'Energy & Utilities (E&U)', '+32 (0)475 12 34 56', 'hr', 'DIRECTOR CONSULTING SERVICES');
  INSERT INTO trainingtool.user (username, pnr, role, firstname, lastname, sector, phone_number, managername, function) 
  	VALUES ('john', 'LPS005', 'MEMBER', 'John', 'Doe', 'Energy & Utilities (E&U)', '0477123456', 'hr', 'JUNIOR CONSULTANT'); -- id = 5
  	
  -- Registration
  INSERT INTO trainingtool.registration (created_by, status, user_id, provider, ssin, title, description, url, start_date, end_date, period, total_hour, location, price) 
  	VALUES('john', 'DRAFT', 5, 'CEVORA', '85073003328', 'Thymeleaf', 'Thymeleaf replaces JSP','http://www.thymeleaf.org', '2020-11-01', '2020-11-01', 'DAY', 8, 'VIRTUAL', '3.14');
  INSERT INTO trainingtool.registration (created_by, status, user_id, provider, provider_other, title, description, url, start_date, end_date, period, total_hour, location, price) 
  	VALUES('manager', 'DRAFT', 5, 'OTHER', 'MOOC', 'Kubernetes', 'Open source tool from Google','http://www.kubernetes.org', '2020-11-10', '2020-11-11', 'EVENING', 16, 'CLASSROOM', '1500.00');
  
  
  INSERT INTO trainingtool.registration (created_by, status, user_id, provider, ssin, title, description, url, start_date, end_date, period, total_hour, location, price) 
  	VALUES('john', 'SUBMITTED_TO_MANAGER', 5, 'CEVORA', '85073003328', 'Demo1', 'Thymeleaf replaces JSP','http://www.thymeleaf.org', '2020-11-01', '2020-11-01', 'DAY', 8, 'VIRTUAL', '3.14');
  INSERT INTO trainingtool.registration (created_by, status, user_id, provider, ssin, title, description, url, start_date, end_date, period, total_hour, location, price) 
  	VALUES('john', 'SUBMITTED_TO_HR', 5, 'CEVORA', '85073003328', 'Demo2', 'Thymeleaf replaces JSP','http://www.thymeleaf.org', '2020-11-01', '2020-11-01', 'DAY', 8, 'VIRTUAL', '3.14');
  INSERT INTO trainingtool.registration (created_by, status, user_id, provider, ssin, title, description, url, start_date, end_date, period, total_hour, location, price) 
  	VALUES('john', 'SUBMITTED_TO_TRAINING', 5, 'CEVORA', '85073003328', 'Demo3', 'Thymeleaf replaces JSP','http://www.thymeleaf.org', '2020-11-01', '2020-11-01', 'DAY', 8, 'VIRTUAL', '3.14');
  INSERT INTO trainingtool.registration (created_by, status, user_id, provider, ssin, title, description, url, start_date, end_date, period, total_hour, location, price) 
  	VALUES('john', 'SUBMITTED_TO_PROVIDER', 5, 'CEVORA', '85073003328', 'Demo4', 'Thymeleaf replaces JSP','http://www.thymeleaf.org', '2020-11-01', '2020-11-01', 'DAY', 8, 'VIRTUAL', '3.14');
  INSERT INTO trainingtool.registration (created_by, status, user_id, provider, ssin, title, description, url, start_date, end_date, period, total_hour, location, price) 
  	VALUES('john', 'REFUSED_BY_HR', 5, 'CEVORA', '85073003328', 'Demo5', 'Thymeleaf replaces JSP','http://www.thymeleaf.org', '2020-11-01', '2020-11-01', 'DAY', 8, 'VIRTUAL', '3.14');
  INSERT INTO trainingtool.registration (created_by, status, user_id, provider, ssin, title, description, url, start_date, end_date, period, total_hour, location, price) 
  	VALUES('john', 'REFUSED_BY_PROVIDER', 5, 'CEVORA', '85073003328', 'Demo5', 'Thymeleaf replaces JSP','http://www.thymeleaf.org', '2020-11-01', '2020-11-01', 'DAY', 8, 'VIRTUAL', '3.14');
  
  INSERT INTO trainingtool.registration (created_by, status, user_id, provider, ssin, title, description, url, start_date, end_date, period, total_hour, location, price) 
  	VALUES('manager', 'DRAFT', 4, 'CEVORA', '85073003328', 'Thymeleaf', 'Thymeleaf replaces JSP','http://www.thymeleaf.org', '2020-11-01', '2020-11-01', 'DAY', 8, 'VIRTUAL', '3.14');
  