API tools faq
paste
yoga1290

DB Lab data (MySQL)

yoga1290
Dec 17th, 2011
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 6.92 KB | None | 0 0
raw download clone embed print report diff
  1. -- Screen-shot of my on-the-cloud database: http://yfrog.com/h265ynp :P
  2. -- ...This file is just the exported data from the database lab, have fun!!
  3.  
  4. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  5. --  File created - «·√Õœ-œÌ”„»—-11-2011  
  6. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  7.  
  8. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  9. --  DDL for Table BONUS
  10. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  11.  
  12.   CREATE TABLE BONUS
  13.    (    ENAME VARCHAR(10),
  14.     JOB VARCHAR(9),
  15.     SAL INT,
  16.     COMM INT
  17.    ) ;
  18.  
  19. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  20. --  DDL for Table EMP
  21. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  22.  
  23.   CREATE TABLE EMP
  24.    (    EMPNO INT(4,0),
  25.     ENAME VARCHAR(10),
  26.     JOB VARCHAR(9),
  27.     MGR INT(4,0),
  28.     HIREDATE DATE,
  29.     SAL INT(7,2),
  30.     COMM INT(7,2),
  31.     DEPTNO INT(2,0),
  32.      CONSTRAINT PK_EMP PRIMARY KEY (EMPNO) ENABLE,
  33.      CONSTRAINT FK_DEPTNO FOREIGN KEY (DEPTNO)
  34.       REFERENCES DEPT (DEPTNO) ENABLE
  35.    ) ;
  36.  
  37. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  38. --  DDL for Table DEPT
  39. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  40.  
  41.   CREATE TABLE DEPT
  42.    (    DEPTNO INT(2,0),
  43.     DNAME VARCHAR(14),
  44.     LOC VARCHAR(13),
  45.      CONSTRAINT PK_DEPT PRIMARY KEY (DEPTNO) ENABLE
  46.    ) ;
  47.  
  48. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  49. --  DDL for Table SALGRADE
  50. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  51.  
  52.   CREATE TABLE SALGRADE
  53.    (    GRADE INT,
  54.     LOSAL INT,
  55.     HISAL INT
  56.    ) ;
  57.  
  58. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  59. --  Constraints for Table EMP
  60. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  61.  
  62.   ALTER TABLE EMP ADD CONSTRAINT PK_EMP PRIMARY KEY (EMPNO) ENABLE;
  63.  
  64. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  65. --  Constraints for Table DEPT
  66. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  67.  
  68.   ALTER TABLE DEPT ADD CONSTRAINT PK_DEPT PRIMARY KEY (DEPTNO) ENABLE;
  69.  
  70. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  71. --  DDL for Index PK_EMP
  72. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  73.  
  74.   CREATE UNIQUE INDEX PK_EMP ON EMP (EMPNO)
  75.   ;
  76.  
  77. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  78. --  DDL for Index PK_DEPT
  79. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  80.  
  81.   CREATE UNIQUE INDEX PK_DEPT ON DEPT (DEPTNO)
  82.   ;
  83.  
  84. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  85. --  Ref Constraints for Table EMP
  86. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
  87.  
  88.   ALTER TABLE EMP ADD CONSTRAINT FK_DEPTNO FOREIGN KEY (DEPTNO)
  89.       REFERENCES DEPT (DEPTNO) ENABLE;
  90.  
  91. ---------------------------------------------------
  92. --   DATA FOR TABLE BONUS
  93. --   FILTER = none used
  94. ---------------------------------------------------
  95. REM INSERTING INTO BONUS
  96.  
  97. ---------------------------------------------------
  98. --   END DATA FOR TABLE BONUS
  99. ---------------------------------------------------
  100.  
  101. ---------------------------------------------------
  102. --   DATA FOR TABLE EMP
  103. --   FILTER = none used
  104. ---------------------------------------------------
  105. REM INSERTING INTO EMP
  106. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7369,'SMITH','CLERK',7902,to_timestamp('1980-12-17 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),800,NULL,20);
  107. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7499,'ALLEN','SALESMAN',7698,to_timestamp('1981-02-20 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1600,300,30);
  108. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7521,'WARD','SALESMAN',7698,to_timestamp('1981-02-22 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1250,500,30);
  109. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7566,'JONES','MANAGER',7839,to_timestamp('1981-04-02 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),2975,NULL,20);
  110. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7654,'MARTIN','SALESMAN',7698,to_timestamp('1981-09-28 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1250,1400,30);
  111. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7698,'BLAKE','MANAGER',7839,to_timestamp('1981-05-01 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),2850,NULL,30);
  112. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7782,'CLARK','MANAGER',7839,to_timestamp('1981-06-09 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),2450,NULL,10);
  113. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7788,'SCOTT','ANALYST',7566,to_timestamp('1987-04-19 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),3000,NULL,20);
  114. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7839,'KING','PRESIDENT',NULL,to_timestamp('1981-11-17 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),5000,NULL,10);
  115. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7844,'TURNER','SALESMAN',7698,to_timestamp('1981-09-08 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1500,0,30);
  116. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7876,'ADAMS','CLERK',7788,to_timestamp('1987-05-23 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1100,NULL,20);
  117. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7900,'JAMES','CLERK',7698,to_timestamp('1981-12-03 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),950,NULL,30);
  118. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7902,'FORD','ANALYST',7566,to_timestamp('1981-12-03 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),3000,NULL,20);
  119. INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7934,'MILLER','CLERK',7782,to_timestamp('1982-01-23 00:00:00.0','DD/MM/RR HH12:MI:SSXFF PM'),1300,NULL,10);
  120.  
  121. ---------------------------------------------------
  122. --   END DATA FOR TABLE EMP
  123. ---------------------------------------------------
  124.  
  125. ---------------------------------------------------
  126. --   DATA FOR TABLE DEPT
  127. --   FILTER = none used
  128. ---------------------------------------------------
  129. REM INSERTING INTO DEPT
  130. INSERT INTO DEPT (DEPTNO,DNAME,LOC) VALUES (10,'ACCOUNTING','NEW YORK');
  131. INSERT INTO DEPT (DEPTNO,DNAME,LOC) VALUES (20,'RESEARCH','DALLAS');
  132. INSERT INTO DEPT (DEPTNO,DNAME,LOC) VALUES (30,'SALES','CHICAGO');
  133. INSERT INTO DEPT (DEPTNO,DNAME,LOC) VALUES (40,'OPERATIONS','BOSTON');
  134.  
  135. ---------------------------------------------------
  136. --   END DATA FOR TABLE DEPT
  137. ---------------------------------------------------
  138.  
  139. ---------------------------------------------------
  140. --   DATA FOR TABLE SALGRADE
  141. --   FILTER = none used
  142. ---------------------------------------------------
  143. REM INSERTING INTO SALGRADE
  144. INSERT INTO SALGRADE (GRADE,LOSAL,HISAL) VALUES (1,700,1200);
  145. INSERT INTO SALGRADE (GRADE,LOSAL,HISAL) VALUES (2,1201,1400);
  146. INSERT INTO SALGRADE (GRADE,LOSAL,HISAL) VALUES (3,1401,2000);
  147. INSERT INTO SALGRADE (GRADE,LOSAL,HISAL) VALUES (4,2001,3000);
  148. INSERT INTO SALGRADE (GRADE,LOSAL,HISAL) VALUES (5,3001,9999);
  149.  
  150. ---------------------------------------------------
  151. --   END DATA FOR TABLE SALGRADE
  152. ---------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!