CREATE TABLE trafodion.persnl.project
( projcode       NUMERIC (4)  UNSIGNED NO DEFAULT                                     NOT NULL
, empnum         NUMERIC (4)  UNSIGNED NO DEFAULT                                     NOT NULL
, projdesc       VARCHAR (18)          DEFAULT ' '                                    NOT NULL
, start_date     DATE                  DEFAULT DATE '2011-07-01'                      NOT NULL
, ship_timestamp TIMESTAMP             DEFAULT TIMESTAMP '2011-08-01:12:00:00.000000' NOT NULL
, est_complete   INTERVAL DAY          DEFAULT INTERVAL '30' DAY                      NOT NULL
, PRIMARY KEY ( projcode, empnum )
) ;

INSERT INTO trafodion.persnl.project
VALUES
  ( 1000, 213, 'SALT LAKE CITY',    DATE '2011-04-10', TIMESTAMP '2011-04-21:08:15:00.00',   INTERVAL '15' DAY )
, ( 1000, 211, 'SALT LAKE CITY',    DATE '2011-04-10', TIMESTAMP '2011-04-21:08:15:00.00',   INTERVAL '15' DAY )
, ( 1000,  23, 'SALT LAKE CITY',    DATE '2011-04-10', TIMESTAMP '2011-04-21:08:15:00.00',   INTERVAL '15' DAY )
, ( 1000,   1, 'SALT LAKE CITY',    DATE '2011-04-10', TIMESTAMP '2011-04-21:08:15:00.00',   INTERVAL '15' DAY )
, ( 2000, 227, 'ROSS PRODUCTS',     DATE '2011-06-10', TIMESTAMP '2011-07-21:08:30:00.0000', INTERVAL '30' DAY )
, ( 2000, 109, 'ROSS PRODUCTS',     DATE '2011-06-10', TIMESTAMP '2011-07-21:08:30:00.0000', INTERVAL '30' DAY )
, ( 2000, 215, 'ROSS PRODUCTS',     DATE '2011-06-10', TIMESTAMP '2011-07-21:08:30:00.0000', INTERVAL '30' DAY )
, ( 2000,  65, 'ROSS PRODUCTS',     DATE '2011-06-10', TIMESTAMP '2011-07-21:08:30:00.0000', INTERVAL '30' DAY )
, ( 2500,  65, 'MONTANA TOOLS',     DATE '2011-10-10', TIMESTAMP '2011-12-21:09:00:00.0000', INTERVAL '60' DAY )
, ( 2500, 207, 'MONTANA TOOLS',     DATE '2011-10-10', TIMESTAMP '2011-12-21:09:00:00.0000', INTERVAL '60' DAY )
, ( 2500, 232, 'MONTANA TOOLS',     DATE '2011-10-10', TIMESTAMP '2011-12-21:09:00:00.0000', INTERVAL '60' DAY )
, ( 2500, 180, 'MONTANA TOOLS',     DATE '2011-10-10', TIMESTAMP '2011-12-21:09:00:00.0000', INTERVAL '60' DAY )
, ( 2500,  93, 'MONTANA TOOLS',     DATE '2011-10-10', TIMESTAMP '2011-12-21:09:00:00.0000', INTERVAL '60' DAY )
, ( 3000,  65, 'AHAUS TOOL/SUPPLY', DATE '2011-08-21', TIMESTAMP '2011-10-21:08:10:00.0000', INTERVAL '60' DAY )
, ( 3000, 221, 'AHAUS TOOL/SUPPLY', DATE '2011-08-21', TIMESTAMP '2011-10-21:08:10:00.0000', INTERVAL '60' DAY )
, ( 3000, 226, 'AHAUS TOOL/SUPPLY', DATE '2011-08-21', TIMESTAMP '2011-10-21:08:10:00.0000', INTERVAL '60' DAY )
, ( 3000, 224, 'AHAUS TOOL/SUPPLY', DATE '2011-08-21', TIMESTAMP '2011-10-21:08:10:00.0000', INTERVAL '60' DAY )
, ( 3000, 225, 'AHAUS TOOL/SUPPLY', DATE '2011-08-21', TIMESTAMP '2011-10-21:08:10:00.0000', INTERVAL '60' DAY )
, ( 4000,  75, 'THE WORKS',         DATE '2011-09-21', TIMESTAMP '2011-10-21:10:15:00.0000', INTERVAL '30' DAY )
, ( 4000,  29, 'THE WORKS',         DATE '2011-09-21', TIMESTAMP '2011-10-21:10:15:00.0000', INTERVAL '30' DAY )
, ( 4000, 231, 'THE WORKS',         DATE '2011-09-21', TIMESTAMP '2011-10-21:10:15:00.0000', INTERVAL '30' DAY )
, ( 4000, 228, 'THE WORKS',         DATE '2011-09-21', TIMESTAMP '2011-10-21:10:15:00.0000', INTERVAL '30' DAY )
, ( 4000, 223, 'THE WORKS',         DATE '2011-09-21', TIMESTAMP '2011-10-21:10:15:00.0000', INTERVAL '30' DAY )
, ( 4000, 568, 'THE WORKS',         DATE '2011-09-21', TIMESTAMP '2011-10-21:10:15:00.0000', INTERVAL '30' DAY )
, ( 5000,  65, 'ASIA PROJECT',      DATE '2011-09-28', TIMESTAMP '2011-10-28:09:25:01.1111', INTERVAL '30' DAY )
, ( 5000, 568, 'ASIA PROJECT',      DATE '2011-09-28', TIMESTAMP '2011-10-28:09:25:01.1111', INTERVAL '30' DAY )
, ( 5000, 557, 'ASIA PROJECT',      DATE '2011-09-28', TIMESTAMP '2011-10-28:09:25:01.1111', INTERVAL '30' DAY )
, ( 5000, 216, 'ASIA PROJECT',      DATE '2011-09-28', TIMESTAMP '2011-10-28:09:25:01.1111', INTERVAL '30' DAY )
, ( 5000, 203, 'ASIA PROJECT',      DATE '2011-09-28', TIMESTAMP '2011-10-28:09:25:01.1111', INTERVAL '30' DAY )
, ( 5000, 218, 'ASIA PROJECT',      DATE '2011-09-28', TIMESTAMP '2011-10-28:09:25:01.1111', INTERVAL '30' DAY )
;

UPDATE STATISTICS FOR TABLE trafodion.persnl.project ON EVERY COLUMN ;
