RDBC/macros/demobld.mysql

0001 DROP TABLE EMP;
0002 DROP TABLE DEPT;
0003 DROP TABLE BONUS;
0004 DROP TABLE SALGRADE;
0005 DROP TABLE DUMMY;
0006
0007 CREATE TABLE EMP
0008        (EMPNO DECIMAL(4) NOT NULL,
0009         ENAME VARCHAR(10),
0010         JOB VARCHAR(9),
0011         MGR DECIMAL(4),
0012         HIREDATE DATE,
0013         SAL DECIMAL(7,2),
0014         COMM DECIMAL(7,2),
0015         DEPTNO DECIMAL(2));
0016
0017 INSERT INTO EMP VALUES
0018         (7369,'SMITH','CLERK',7902,'17-DEC-80',800,NULL,20);
0019 INSERT INTO EMP VALUES
0020         (7499,'ALLEN','SALESMAN',7698,'20-FEB-81',1600,300,30);
0021 INSERT INTO EMP VALUES
0022         (7521,'WARD','SALESMAN',7698,'22-FEB-81',1250,500,30);
0023 INSERT INTO EMP VALUES
0024         (7566,'JONES','MANAGER',7839,'2-APR-81',2975,NULL,20);
0025 INSERT INTO EMP VALUES
0026         (7654,'MARTIN','SALESMAN',7698,'28-SEP-81',1250,1400,30);
0027 INSERT INTO EMP VALUES
0028         (7698,'BLAKE','MANAGER',7839,'1-MAY-81',2850,NULL,30);
0029 INSERT INTO EMP VALUES
0030         (7782,'CLARK','MANAGER',7839,'9-JUN-81',2450,NULL,10);
0031 INSERT INTO EMP VALUES
0032         (7788,'SCOTT','ANALYST',7566,'09-DEC-82',3000,NULL,20);
0033 INSERT INTO EMP VALUES
0034         (7839,'KING','PRESIDENT',NULL,'17-NOV-81',5000,NULL,10);
0035 INSERT INTO EMP VALUES
0036         (7844,'TURNER','SALESMAN',7698,'8-SEP-81',1500,0,30);
0037 INSERT INTO EMP VALUES
0038         (7876,'ADAMS','CLERK',7788,'12-JAN-83',1100,NULL,20);
0039 INSERT INTO EMP VALUES
0040         (7900,'JAMES','CLERK',7698,'3-DEC-81',950,NULL,30);
0041 INSERT INTO EMP VALUES
0042         (7902,'FORD','ANALYST',7566,'3-DEC-81',3000,NULL,20);
0043 INSERT INTO EMP VALUES
0044         (7934,'MILLER','CLERK',7782,'23-JAN-82',1300,NULL,10);
0045
0046 CREATE TABLE DEPT
0047        (DEPTNO DECIMAL(2),
0048         DNAME VARCHAR(14),
0049         LOC VARCHAR(13) );
0050
0051 INSERT INTO DEPT VALUES
0052         (10,'ACCOUNTING','NEW YORK');
0053 INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');
0054 INSERT INTO DEPT VALUES
0055         (30,'SALES','CHICAGO');
0056 INSERT INTO DEPT VALUES
0057         (40,'OPERATIONS','BOSTON');
0058
0059 CREATE TABLE BONUS
0060         (
0061         ENAME VARCHAR(10),
0062         JOB VARCHAR(9),
0063         SAL DECIMAL,
0064         COMM DECIMAL
0065         );
0066
0067 CREATE TABLE SALGRADE
0068       ( GRADE DECIMAL,
0069         LOSAL DECIMAL,
0070         HISAL DECIMAL );
0071
0072 INSERT INTO SALGRADE VALUES (1,700,1200);
0073 INSERT INTO SALGRADE VALUES (2,1201,1400);
0074 INSERT INTO SALGRADE VALUES (3,1401,2000);
0075 INSERT INTO SALGRADE VALUES (4,2001,3000);
0076 INSERT INTO SALGRADE VALUES (5,3001,9999);
0077
0078 CREATE TABLE DUMMY
0079       ( DUMMY DECIMAL );
0080
0081 INSERT INTO DUMMY VALUES (0);