mirror of
https://github.com/Wisser/Jailer.git
synced 2026-01-02 09:19:44 -06:00
25 lines
1.8 KiB
SQL
25 lines
1.8 KiB
SQL
-- generated by Jailer, Wed Dec 19 08:13:53 CET 2018 from wisser@desktop
|
|
--
|
|
-- Extraction Model: EMPLOYEE where T.NAME='SCOTT' (Demo.csv)
|
|
-- Database URL: jdbc:db2://localhost:50001/wisser
|
|
-- Database User: scott
|
|
-- Exported Rows: 16
|
|
-- DEPARTMENT 2
|
|
-- EMPLOYEE 3
|
|
-- PROJECT 2
|
|
-- PROJECT_PARTICIPATION 2
|
|
-- ROLE 2
|
|
-- SALARYGRADE 5
|
|
|
|
|
|
|
|
Insert into SALARYGRADE(GRADE, LOSAL, HISAL) values (1, 700, 1200), (2, 1201, 1400), (3, 1401, 2000), (4, 2001, 3000), (5, 3001, 9999);
|
|
Insert into ROLE(ROLE_ID, DESCRIPTION) values (100, 'Developer'), (102, 'Project manager');
|
|
Insert into PROJECT(PROJECTNO, DESCRIPTION, START_DATE, END_DATE) values (1001, 'Development of Novel Magnetic Suspension System', '2006-01-01', '2007-08-13'), (1003, 'Foundation of Quantum Technology', '2007-02-24', '2008-07-31');
|
|
Insert into DEPARTMENT(DEPTNO, NAME, LOCATION) values (20, 'RESEARCH', 'DALLAS'), (10, 'ACCOUNTING', 'NEW YORK');
|
|
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO) values (7839, 'KING', 'PRESIDENT', null, '1981-11-17', 5000.00, null, 10);
|
|
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO) values (7566, 'JONES', 'MANAGER', 7839, '1981-04-02', 2975.00, null, 20);
|
|
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO) values (7788, 'SCOTT', 'ANALYST', 7566, '1982-12-09', 3000.00, null, 20);
|
|
Insert into PROJECT_PARTICIPATION(PROJECTNO, EMPNO, START_DATE, END_DATE, ROLE_ID) values (1003, 7566, '2007-02-24', '2008-07-31', 102);
|
|
Insert into PROJECT_PARTICIPATION(PROJECTNO, EMPNO, START_DATE, END_DATE, ROLE_ID) values (1001, 7788, '2006-05-15', '2006-11-01', 100);
|