schema1.out

derby database source code.good for you.

--O                UNIQUE(COL1,COL2,COL3,COL4,COL5,COL6));
                constraint t8c1 UNIQUE(COL1,COL2,COL3,COL4,COL5,COL6));
0 rows inserted/updated/deleted
ij> CREATE TABLE T118(STR118 CHAR(118) NOT NULL UNIQUE);
0 rows inserted/updated/deleted
ij> CREATE TABLE T4(STR110 CHAR(110) NOT NULL,
                NUM6   NUMERIC(6) NOT NULL,
                COL3   CHAR(10),COL4 CHAR(20),
--O                UNIQUE(STR110,NUM6))
                constraint t4c1 UNIQUE(STR110,NUM6)
                );
0 rows inserted/updated/deleted
ij> CREATE TABLE T12(COL1 CHAR(1), COL2 CHAR(2),
                 COL3 CHAR(4), COL4 CHAR(6),
                 COL5 CHAR(8), COL6 CHAR(10),
                 COL7 CHAR(20), COL8 CHAR(30),
                 COL9 CHAR(40), COL10 CHAR(50),
                 COL11 INTEGER, COL12 INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
                         DOLLARS INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE SV (NUMTEST NUMERIC(8,3));
0 rows inserted/updated/deleted
ij> CREATE TABLE JJ_20 (FLOATTEST  FLOAT(20));
0 rows inserted/updated/deleted
ij> CREATE TABLE PP_15 (NUMTEST  DECIMAL(15,15));
0 rows inserted/updated/deleted
ij> CREATE TABLE PP_7  (NUMTEST  DECIMAL(15,7));
0 rows inserted/updated/deleted
ij> CREATE TABLE P15_15 (NUMTEST  NUMERIC(15,15));
0 rows inserted/updated/deleted
ij> CREATE TABLE P15_7 (NUMTEST  NUMERIC(15,7));
0 rows inserted/updated/deleted
ij> CREATE TABLE TEMP_OBSERV
               (YEAR_OBSERV  NUMERIC(4),
                CITY         CHAR(10),
                MAX_TEMP     NUMERIC(5,2),
                MIN_TEMP     NUMERIC(5,2));
0 rows inserted/updated/deleted
ij> CREATE TABLE TOKENS
    (PROG_NO INT, TOKEN_NO INT);
0 rows inserted/updated/deleted
ij> CREATE TABLE WHICH_SCHEMA1 (C1 CHAR (50));
0 rows inserted/updated/deleted
ij> -- ************* create view statements follow *************
   CREATE VIEW TESTREPORT AS
    SELECT TESTNO, RESULT, TESTTYPE
    FROM BASE_TESTREPORT;
0 rows inserted/updated/deleted
ij> CREATE VIEW CELSIUS_OBSERV (CITY, YEAR_OBSERV, MIN_C, MAX_C)
      AS SELECT CITY, YEAR_OBSERV, (MIN_TEMP - 32) * 5 / 9,
                (MAX_TEMP - 32) * 5 / 9
         FROM TEMP_OBSERV;
0 rows inserted/updated/deleted
ij> CREATE VIEW MULTI_YEAR_OBSERV (CITY, HIGH, LOW)
      AS SELECT CITY, AVG(MAX_TEMP), AVG(MIN_TEMP)
            FROM TEMP_OBSERV
            GROUP BY CITY;
0 rows inserted/updated/deleted
ij> CREATE VIEW EXTREME_TEMPS (YEAR_OBSERV, HIGH, LOW)
      AS SELECT YEAR_OBSERV, MAX(MAX_TEMP), MIN(MIN_TEMP)
            FROM TEMP_OBSERV
            GROUP BY YEAR_OBSERV;
0 rows inserted/updated/deleted
ij> CREATE VIEW SET_TEST (EMP1, EMP_AVG, EMP_MAX) AS
           SELECT STAFF.EMPNUM, AVG(HOURS), MAX(HOURS)
           FROM STAFF, WORKS
           GROUP BY STAFF.EMPNUM;
0 rows inserted/updated/deleted
ij> CREATE VIEW DUP_COL (EMP1, PNO, HOURS, HOURS_2) AS
           SELECT EMPNUM, PNUM, HOURS, HOURS * 2
           FROM WORKS;
0 rows inserted/updated/deleted
ij> CREATE VIEW STAFFV1
           AS SELECT * FROM STAFF
              WHERE  GRADE >= 12;
0 rows inserted/updated/deleted
ij> CREATE VIEW STAFFV2
           AS SELECT * FROM STAFF
              WHERE  GRADE >= 12
--0           WITH CHECK OPTION
    ;
0 rows inserted/updated/deleted
ij> CREATE VIEW STAFFV2_VIEW
           AS SELECT * 
              FROM   STAFFV2
              WHERE  CITY = 'Vienna';
0 rows inserted/updated/deleted
ij> CREATE VIEW DOMAIN_VIEW
           AS SELECT *
              FROM   WORKS
              WHERE  EMPNUM = 'E1' AND HOURS = 80
                  OR EMPNUM = 'E2' AND HOURS = 40
                  OR EMPNUM = 'E4' AND HOURS = 20
--0              WITH CHECK OPTION
			  ;
0 rows inserted/updated/deleted
ij> CREATE VIEW STAFF2
           AS SELECT * 
              FROM   STAFF
--0           WITH CHECK OPTION
	;
0 rows inserted/updated/deleted
ij> CREATE VIEW STAFF_WORKS_DESIGN (NAME,COST,PROJECT)
    AS SELECT EMPNAME,HOURS*2*GRADE,PNAME
     FROM   PROJ,STAFF,WORKS
     WHERE  STAFF.EMPNUM=WORKS.EMPNUM
        AND WORKS.PNUM=PROJ.PNUM
        AND PTYPE='Design';
0 rows inserted/updated/deleted
ij> CREATE VIEW SUBSP (EMPNUM,PNUM,HOURS)
     AS SELECT EMPNUM,PNUM,HOURS
        FROM   WORKS
        WHERE  EMPNUM='E3'
--0     WITH CHECK OPTION
	 ;
0 rows inserted/updated/deleted
ij> CREATE VIEW TEMP_SS(EMPNUM,GRADE,CITY)
     AS SELECT EMPNUM,GRADE,CITY
        FROM   STAFF
        WHERE  GRADE > 12
--0     WITH CHECK OPTION
	 ;
0 rows inserted/updated/deleted
ij> CREATE VIEW V_WORKS1                
           AS SELECT * FROM WORKS       
              WHERE HOURS > 15          
--0           WITH CHECK OPTION
		   ;
0 rows inserted/updated/deleted
ij> CREATE VIEW V_WORKS2                
           AS SELECT * FROM V_WORKS1    
              WHERE EMPNUM = 'E1'       
                 OR EMPNUM = 'E6';
0 rows inserted/updated/deleted
ij> CREATE VIEW V_WORKS3                
           AS SELECT * FROM V_WORKS2    
              WHERE PNUM = 'P2'         
                 OR PNUM = 'P7'         
--0           WITH CHECK OPTION       
		   ;
0 rows inserted/updated/deleted
ij> CREATE VIEW UPDATE_VIEW1   
            AS SELECT ALL CITY
                     FROM PROJ;
0 rows inserted/updated/deleted
ij> CREATE VIEW UPDATE_VIEW2 
            AS SELECT HOURS, EMPNUM, PNUM
                     FROM WORKS
                     WHERE HOURS IN (10, 20, 40);
0 rows inserted/updated/deleted
ij> CREATE VIEW UPDATE_VIEW3  
            AS SELECT *
                     FROM WORKS
                     WHERE PNUM BETWEEN 'P2' AND 'P4'
                     AND EMPNUM NOT BETWEEN 'E2' AND 'E3';
0 rows inserted/updated/deleted
ij> CREATE VIEW UPDATE_VIEW4  
            AS SELECT PNUM, EMPNUM 
                     FROM WORKS
                     WHERE PNUM LIKE '_2%';
0 rows inserted/updated/deleted
ij> CREATE VIEW UPDATE_VIEW5 
            AS SELECT *
                     FROM STAFF
                     WHERE EMPNAME IS NOT NULL AND CITY IS NULL;
0 rows inserted/updated/deleted
ij> CREATE VIEW UPDATE_VIEW6 
            AS SELECT EMPNAME, CITY, GRADE
                     FROM STAFF
                     WHERE EMPNAME >= 'Betty' AND EMPNUM < 'E35'
                       OR CITY <= 'Deale' AND GRADE > 12
                       OR GRADE = 13 AND CITY <> 'Akron';
0 rows inserted/updated/deleted
ij> CREATE VIEW UPDATE_VIEW7 
            AS SELECT EMPNAME, CITY, GRADE
                     FROM STAFFV2
                     WHERE EMPNAME >= 'Betty' AND EMPNUM < 'E35'
                       OR CITY <= 'Deale' AND GRADE > 12
                       OR GRADE = 13 AND CITY <> 'Akron';
0 rows inserted/updated/deleted
ij> CREATE VIEW UPDATE_VIEW8 
            AS SELECT MYTABLE.EMPNUM, MYTABLE.EMPNAME
                     FROM STAFF MYTABLE
                     WHERE MYTABLE.GRADE = 12;
0 rows inserted/updated/deleted
ij> CREATE VIEW UPDATE_VIEW9 
            AS SELECT EMPNAME, CITY, GRADE
                     FROM STAFF
                     WHERE NOT EMPNAME >= 'Betty' AND EMPNUM <= 'E35'
                       OR NOT (CITY <= 'Deale') AND GRADE > 9
                       AND NOT (GRADE = 13 AND CITY <> 'Akron')
                       OR NOT CITY IN ('Vienna','New York','Deale');
0 rows inserted/updated/deleted
ij> CREATE VIEW VSTAFF3 AS SELECT * FROM STAFF3;
0 rows inserted/updated/deleted
ij> disconnect;
ij> exit;