schema1.out

derby database source code.good for you.

ij> -- SQL Test Suite, V6.0, Schema Definition, schema1.std
-- 59-byte ID
-- TEd Version #
-- date_time print
-- ***************************************************************
-- ****** THIS FILE SHOULD BE RUN UNDER AUTHORIZATION ID HU ******
-- ***************************************************************
-- This file defines the base tables used in most of the tests.
-- This is a standard schema definition.
  CREATE SCHEMA
--O  AUTHORIZATION HU;
  HU;
0 rows inserted/updated/deleted
ij> set schema hu;
0 rows inserted/updated/deleted
ij> CREATE TABLE BASE_TESTREPORT
   (TESTNO   CHAR(4),
    RESULT   CHAR(4),
    TESTTYPE  CHAR(3));
0 rows inserted/updated/deleted
ij> CREATE TABLE HU.ECCO (C1 CHAR(2));
0 rows inserted/updated/deleted
ij> CREATE TABLE STAFF
   (EMPNUM   CHAR(3) NOT NULL UNIQUE,
    EMPNAME  CHAR(20),
    GRADE    DECIMAL(4),
    CITY     CHAR(15));
0 rows inserted/updated/deleted
ij> CREATE TABLE PROJ
   (PNUM     CHAR(3) NOT NULL UNIQUE,
    PNAME    CHAR(20),
    PTYPE    CHAR(6),
    BUDGET   DECIMAL(9),
    CITY     CHAR(15)) ;
0 rows inserted/updated/deleted
ij> CREATE TABLE WORKS
   (EMPNUM   CHAR(3) NOT NULL,
    PNUM     CHAR(3) NOT NULL,
    HOURS    DECIMAL(5),
--O    UNIQUE(EMPNUM,PNUM))
    constraint worksc1 UNIQUE(EMPNUM,PNUM)
    );
0 rows inserted/updated/deleted
ij> CREATE TABLE FIPS1
   (FIPS_TEST CHAR(20));
0 rows inserted/updated/deleted
ij> CREATE TABLE STAFF1 (EMPNUM    CHAR(3) NOT NULL,
                EMPNAME  CHAR(20),
                GRADE DECIMAL(4),
                CITY   CHAR(15));
0 rows inserted/updated/deleted
ij> CREATE TABLE PROJ1 (PNUM    CHAR(3) NOT NULL UNIQUE,
                PNAME  CHAR(20),
                PTYPE  CHAR(6),
                BUDGET DECIMAL(9),
                CITY   CHAR(15));
0 rows inserted/updated/deleted
ij> CREATE TABLE WORKS1(EMPNUM    CHAR(3) NOT NULL,
                PNUM    CHAR(3) NOT NULL,
                HOURS   DECIMAL(5),
--O                UNIQUE(EMPNUM, PNUM))
                constraint works1c1 UNIQUE(EMPNUM, PNUM)
                );
0 rows inserted/updated/deleted
ij> CREATE TABLE STAFF3 (EMPNUM    CHAR(3) NOT NULL,
                EMPNAME  CHAR(20),
                GRADE DECIMAL(4),
                CITY   CHAR(15));
0 rows inserted/updated/deleted
ij> CREATE TABLE STAFF4 (EMPNUM    CHAR(3) NOT NULL,
                EMPNAME  CHAR(20),
                GRADE DECIMAL(4),
                CITY   CHAR(15));
0 rows inserted/updated/deleted
ij> -- we use the keyword BIGINT, so I have changed
  -- the name of this table.
  CREATE TABLE LONGINTTAB (LONG_INT DECIMAL(15));
0 rows inserted/updated/deleted
ij> CREATE TABLE TEMP_S
     (EMPNUM  CHAR(3),
      GRADE DECIMAL(4),
      CITY CHAR(15));
0 rows inserted/updated/deleted
ij> CREATE TABLE TMP (T1 CHAR (10), T2 DECIMAL(2), T3 CHAR (10));
0 rows inserted/updated/deleted
ij> CREATE TABLE AA (CHARTEST     CHAR(20));
0 rows inserted/updated/deleted
ij> CREATE TABLE BB (CHARTEST     CHAR);
0 rows inserted/updated/deleted
ij> CREATE TABLE CC (CHARTEST     CHARACTER(20));
0 rows inserted/updated/deleted
ij> CREATE TABLE DD (CHARTEST     CHARACTER);
0 rows inserted/updated/deleted
ij> CREATE TABLE EE (INTTEST     INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE FF (INTTEST     INT);
0 rows inserted/updated/deleted
ij> CREATE TABLE GG (REALTEST     REAL);
0 rows inserted/updated/deleted
ij> CREATE TABLE HH (SMALLTEST  SMALLINT);
0 rows inserted/updated/deleted
ij> CREATE TABLE II (DOUBLETEST  DOUBLE PRECISION);
0 rows inserted/updated/deleted
ij> CREATE TABLE JJ (FLOATTEST  FLOAT);
0 rows inserted/updated/deleted
ij> CREATE TABLE KK (FLOATTEST  FLOAT(32));
0 rows inserted/updated/deleted
ij> CREATE TABLE LL (NUMTEST  NUMERIC(13,6));
0 rows inserted/updated/deleted
ij> CREATE TABLE MM (NUMTEST  NUMERIC);
0 rows inserted/updated/deleted
ij> CREATE TABLE MM2 (NUMTEST NUMERIC(10));
0 rows inserted/updated/deleted
ij> CREATE TABLE NN (NUMTEST  NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE OO (NUMTEST  NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE PP (NUMTEST  DECIMAL(13,6));
0 rows inserted/updated/deleted
ij> CREATE TABLE QQ (NUMTEST  DECIMAL);
0 rows inserted/updated/deleted
ij> CREATE TABLE RR (NUMTEST  DECIMAL(8));
0 rows inserted/updated/deleted
ij> CREATE TABLE SS (NUMTEST  DEC(13,6));
0 rows inserted/updated/deleted
ij> CREATE TABLE P1 (NUMTEST  NUMERIC(1));
0 rows inserted/updated/deleted
ij> CREATE TABLE P7 (NUMTEST  NUMERIC(7));
0 rows inserted/updated/deleted
ij> CREATE TABLE P12 (NUMTEST  NUMERIC(12));
0 rows inserted/updated/deleted
ij> CREATE TABLE P15 (NUMTEST  NUMERIC(15));
0 rows inserted/updated/deleted
ij> CREATE TABLE VTABLE
         (COL1   INTEGER,
          COL2   INTEGER,
          COL3   INTEGER,
          COL4   INTEGER,
          COL5   DECIMAL(7,2));
0 rows inserted/updated/deleted
ij> CREATE TABLE UPUNIQ (NUMKEY  DECIMAL(3) NOT NULL UNIQUE,
                           COL2    CHAR(2));
0 rows inserted/updated/deleted
ij> CREATE TABLE TEXT80  (TEXXT CHAR(80));
0 rows inserted/updated/deleted
ij> CREATE TABLE TEXT132  (TEXXT CHAR(132));
0 rows inserted/updated/deleted
ij> CREATE TABLE TEXT240  (TEXXT CHAR(240));
0 rows inserted/updated/deleted
ij> CREATE TABLE TEXT256  (TEXXT VARCHAR(256));
0 rows inserted/updated/deleted
ij> CREATE TABLE TEXT512  (TEXXT VARCHAR(512));
0 rows inserted/updated/deleted
ij> CREATE TABLE TEXT1024  (TEXXT VARCHAR(1024));
0 rows inserted/updated/deleted
ij> -- The following tables are used to test the limitations (12-14-88)
  CREATE TABLE T240(STR240 CHAR(240));
0 rows inserted/updated/deleted
ij> CREATE TABLE DEC15(COL1 DECIMAL(15,7));
0 rows inserted/updated/deleted
ij> CREATE TABLE FLO15(COL1 FLOAT(15));
0 rows inserted/updated/deleted
ij> CREATE TABLE INT10(COL1 INTEGER, COL2 SMALLINT);
0 rows inserted/updated/deleted
ij> CREATE TABLE T100(C1 CHAR(2),C2 CHAR(2),C3 CHAR(2),C4 CHAR(2),
                C5 CHAR(2),C6 CHAR(2),C7 CHAR(2),C8 CHAR(2),
                C9 CHAR(2),C10 CHAR(2),C11 CHAR(2),C12 CHAR(2),
                C13 CHAR(2),C14 CHAR(2),C15 CHAR(2),C16 CHAR(2),
                C17 CHAR(2),C18 CHAR(2),C19 CHAR(2),C20 CHAR(2),
                C21 CHAR(2),C22 CHAR(2),C23 CHAR(2),C24 CHAR(2),
                C25 CHAR(2),C26 CHAR(2),C27 CHAR(2),C28 CHAR(2),
                C29 CHAR(2),C30 CHAR(2),C31 CHAR(2),C32 CHAR(2),
                C33 CHAR(2),C34 CHAR(2),C35 CHAR(2),C36 CHAR(2),
                C37 CHAR(2),C38 CHAR(2),C39 CHAR(2),C40 CHAR(2),
                C41 CHAR(2),C42 CHAR(2),C43 CHAR(2),C44 CHAR(2),
                C45 CHAR(2),C46 CHAR(2),C47 CHAR(2),C48 CHAR(2),
                C49 CHAR(2),C50 CHAR(2),C51 CHAR(2),C52 CHAR(2),
                C53 CHAR(2),C54 CHAR(2),C55 CHAR(2),C56 CHAR(2),
                C57 CHAR(2),C58 CHAR(2),C59 CHAR(2),C60 CHAR(2),
                C61 CHAR(2),C62 CHAR(2),C63 CHAR(2),C64 CHAR(2),
                C65 CHAR(2),C66 CHAR(2),C67 CHAR(2),C68 CHAR(2),
                C69 CHAR(2),C70 CHAR(2),C71 CHAR(2),C72 CHAR(2),
                C73 CHAR(2),C74 CHAR(2),C75 CHAR(2),C76 CHAR(2),
                C77 CHAR(2),C78 CHAR(2),C79 CHAR(2),C80 CHAR(2),
                C81 CHAR(2),C82 CHAR(2),C83 CHAR(2),C84 CHAR(2),
                C85 CHAR(2),C86 CHAR(2),C87 CHAR(2),C88 CHAR(2),
                C89 CHAR(2),C90 CHAR(2),C91 CHAR(2),C92 CHAR(2),
                C93 CHAR(2),C94 CHAR(2),C95 CHAR(2),C96 CHAR(2),
                C97 CHAR(2),C98 CHAR(2),C99 CHAR(2),C100 CHAR(2));
0 rows inserted/updated/deleted
ij> CREATE TABLE T2000(STR110 CHAR(110),STR120 CHAR(120),
                   STR130 CHAR(130),STR140 CHAR(140),
                   STR150 CHAR(150),STR160 CHAR(160),
                   STR170 CHAR(170),STR180 CHAR(180),
                   STR190 CHAR(190),STR200 CHAR(200),
                   STR210 CHAR(210),STR216 CHAR(216));
0 rows inserted/updated/deleted
ij> CREATE TABLE T8(COL1 CHAR(2) NOT NULL,COL2 CHAR(4) NOT NULL,
                COL3 CHAR(6) NOT NULL,COL4 CHAR(8) NOT NULL,
                COL5 CHAR(10) NOT NULL,COL6 CHAR(12) NOT NULL,
                COL7 CHAR(14),COL8 CHAR(16),