-- INSERT TEST DATA INSERT INTO CH13_DEPARTMENT (NAME, LOCATION) VALUES ('Management', 'Kranj'); INSERT INTO CH13_DEPARTMENT (NAME, LOCATION) VALUES ('Research', 'Warshaw'); INSERT INTO CH13_DEPARTMENT (NAME, LOCATION) VALUES ('Marketing', 'Varaždin'); INSERT INTO CH13_DEPARTMENT (NAME, LOCATION) VALUES ('Production', 'Linz'); INSERT INTO CH13_DEPARTMENT (NAME, LOCATION) VALUES ('Accounting', 'Thessaloniki'); INSERT INTO CH13_DEPARTMENT (NAME, LOCATION) VALUES ('Development', 'Linz'); INSERT INTO CH13_ROLE (NAME, DESCRIPTION) VALUES ('Viewer', 'This role has a privilege to read news'); INSERT INTO CH13_ROLE (NAME, DESCRIPTION) VALUES ('Publisher', 'This role has a privilege to publish and read news'); INSERT INTO CH13_ROLE (NAME, DESCRIPTION) VALUES ('Manager', 'This role has a privilege to update data, publish and read news'); INSERT INTO CH13_EMPLOYEE (FIRST_NAME, LAST_NAME, BIRTH_DATE, EMAIL, MANAGER_ID, DEPARTMENT_ID) VALUES ('Janez', 'Novak', '01/01/1964', 'janez.novak@beeapex.eu', null, '10'); INSERT INTO CH13_EMPLOYEE (FIRST_NAME, LAST_NAME, BIRTH_DATE, EMAIL, MANAGER_ID, DEPARTMENT_ID) VALUES ('Petra', 'Kovac', '05/05/1975', 'petra.kovac@beeapex.eu', '1', '10'); INSERT INTO CH13_EMPLOYEE (FIRST_NAME, LAST_NAME, BIRTH_DATE, EMAIL, MANAGER_ID, DEPARTMENT_ID) VALUES ('Drew', 'Cooper', '12/06/1999', 'drew.cooper@beeapex.eu', '1', '20'); INSERT INTO CH13_EMPLOYEE (FIRST_NAME, LAST_NAME, BIRTH_DATE, EMAIL, MANAGER_ID, DEPARTMENT_ID) VALUES ('Regina', 'Palmer', '11/01/2000', 'regina.palmer@beeapex.eu', '1', '30'); INSERT INTO CH13_EMPLOYEE (FIRST_NAME, LAST_NAME, BIRTH_DATE, EMAIL, MANAGER_ID, DEPARTMENT_ID) VALUES ('Adam', 'Salt', '05/04/1998', 'adam.salt@beeapex.eu', '1', '40'); INSERT INTO CH13_EMPLOYEE (FIRST_NAME, LAST_NAME, BIRTH_DATE, EMAIL, MANAGER_ID, DEPARTMENT_ID) VALUES ('Sofia', 'Gordon', '12/06/1961', 'sofia.gordon@beeapex.eu', '1', '50'); INSERT INTO CH13_EMPLOYEE (FIRST_NAME, LAST_NAME, BIRTH_DATE, EMAIL, MANAGER_ID, DEPARTMENT_ID) VALUES ('Michael', 'Wilson', '03/12/1985', 'michael.wilson@beeapex.eu', '1', '60'); INSERT INTO CH13_EMPLOYEE (FIRST_NAME, LAST_NAME, BIRTH_DATE, EMAIL, MANAGER_ID, DEPARTMENT_ID) VALUES ('Norma', 'Butler', '07/18/1988', 'norma.butler@beeapex.eu', '5', '40'); INSERT INTO CH13_EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID, START_DATE, END_DATE) VALUES (1,30,'01/01/2020', NULL); INSERT INTO CH13_EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID, START_DATE, END_DATE) VALUES (2,20,'01/01/2020', NULL); INSERT INTO CH13_EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID, START_DATE, END_DATE) VALUES (3,10,'01/01/2020', NULL); INSERT INTO CH13_EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID, START_DATE, END_DATE) VALUES (4,10,'01/01/2020', '12/31/2020'); INSERT INTO CH13_EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID, START_DATE, END_DATE) VALUES (4,20,'01/01/2021', NULL); INSERT INTO CH13_EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID, START_DATE, END_DATE) VALUES (5,30,'01/01/2020', NULL); INSERT INTO CH13_EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID, START_DATE, END_DATE) VALUES (6,10,'01/01/2020', NULL); INSERT INTO CH13_EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID, START_DATE, END_DATE) VALUES (7,10,'01/01/2020', NULL); INSERT INTO CH13_EMPLOYEE_ROLE (EMPLOYEE_ID, ROLE_ID, START_DATE, END_DATE) VALUES (8,10,'01/01/2020', NULL); INSERT INTO CH13_NEWS (TITLE, DESCRIPTION, TIMESTAMP, VALID_TO, EMPLOYEE_ID) VALUES ('First news online', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse eu mi sit amet turpis venenatis placerat. Vivamus a purus aliquet, semper eros a, ultricies eros. Pellentesque lorem erat, consectetur sed metus aliquet, ullamcorper posuere ex.', '01/01/2022', null, 1); INSERT INTO CH13_NEWS (TITLE, DESCRIPTION, TIMESTAMP, VALID_TO, EMPLOYEE_ID) VALUES ('Welcome to the company', 'Praesent finibus arcu sit amet ante sagittis, ut efficitur purus consequat. Ut venenatis libero velit, vel malesuada lorem auctor id. Mauris iaculis porttitor lectus, id porttitor enim facilisis vel.', '01/01/2022', null, 1); INSERT INTO CH13_NEWS (TITLE, DESCRIPTION, TIMESTAMP, VALID_TO, EMPLOYEE_ID) VALUES ('Teambuilding event', 'Donec eget cursus ex, a semper mauris. Vivamus suscipit risus nec felis egestas vulputate. Sed nisi massa, tincidunt vitae arcu id, venenatis egestas ligula. Ut vehicula suscipit euismod.', '01/01/2022', null, 1);