-----------------------------------------------------------
---                                                     ---
---     FILE:    HTM_DDL.HTML                           ---
---     AUTHOR:  G.BIRCHALL                             ---
---     DATE:    19/NOV/2007                            ---
---                                                     ---
---     INTRODUCTION:  DB2 comes with a module that     ---
---     creates and populates the SAMPLE database.      ---
---                                                     ---
---     A simplified version of the DDL and DML         ---
---     that DB2 uses is provided below. The code       ---
---     is complete - except for the following:         ---
---                                                     ---
---     - No RI rules created.                          ---
---     - No triggers created.                          ---
---     - No views created.                             ---
---     - Only 250 rows (out of 10,000) inserted        ---
---       into the EMPMDC table.                        ---
---     - No BLOB, CLOB, DBCLOB, or XML column          ---
---       values inserted.                              ---
---                                                     ---
---     NOTE:  I've used a table qualifier of FRED.     ---
---     Change or remove as you wish.                   ---
---                                                     ---
-----------------------------------------------------------


DROP ALIAS FRED.DEPT;
DROP ALIAS FRED.EMP;
DROP ALIAS FRED.EMPACT;
DROP ALIAS FRED.EMP_ACT;
DROP ALIAS FRED.PROJ;

DROP TABLE FRED.ACT;
DROP TABLE FRED.CATALOG;
DROP TABLE FRED.CL_SCHED;
DROP TABLE FRED.CUSTOMER;
DROP TABLE FRED.DATA_FILE_NAMES;
DROP TABLE FRED.DEPARTMENT;
DROP TABLE FRED.EMPLOYEE;
DROP TABLE FRED.EMPMDC;
DROP TABLE FRED.EMPPROJACT;
DROP TABLE FRED.EMP_PHOTO;
DROP TABLE FRED.EMP_RESUME;
DROP TABLE FRED.INVENTORY;
DROP TABLE FRED.IN_TRAY;
DROP TABLE FRED.ORG;
DROP TABLE FRED.PRODUCT;
DROP TABLE FRED.PRODUCTSUPPLIER;
DROP TABLE FRED.PROJACT;
DROP TABLE FRED.PROJECT;
DROP TABLE FRED.PURCHASEORDER;
DROP TABLE FRED.SALES;
DROP TABLE FRED.STAFF;
DROP TABLE FRED.SUPPLIERS;

CREATE TABLE FRED.ACT
(ACTNO            SMALLINT            NOT NULL
,ACTKWD           CHARACTER(6)        NOT NULL
,ACTDESC          VARCHAR(20)         NOT NULL)
IN USERSPACE1;

ALTER TABLE FRED.ACT
ADD CONSTRAINT PK_ACT PRIMARY KEY
(ACTNO);

CREATE UNIQUE INDEX FRED.XACT2 ON FRED.ACT
(ACTNO            ASC
,ACTKWD           ASC)
ALLOW REVERSE SCANS;

CREATE TABLE FRED.CATALOG
(NAME             VARCHAR(128)        NOT NULL
,CATLOG           XML)
IN IBMDB2SAMPLEXML;

ALTER TABLE FRED.CATALOG
ADD CONSTRAINT PK_CATALOG PRIMARY KEY
(NAME);

CREATE TABLE FRED.CL_SCHED
(CLASS_CODE       CHARACTER(7)
,DAY              SMALLINT
,STARTING         TIME
,ENDING           TIME)
IN USERSPACE1;

CREATE TABLE FRED.CUSTOMER
(CID              BIGINT              NOT NULL
,INFO             XML
,HISTORY          XML)
IN IBMDB2SAMPLEXML;

ALTER TABLE FRED.CUSTOMER
ADD CONSTRAINT PK_CUSTOMER PRIMARY KEY
(CID);

CREATE UNIQUE INDEX FRED.CUST_CID_XMLIDX ON FRED.CUSTOMER
(INFO             ASC)
GENERATE KEY USING XMLPATTERN
'declare default element namespace "http://posample.org"; /customerinfo/@Cid'
AS SQL DOUBLE
ALLOW REVERSE SCANS;

CREATE INDEX FRED.CUST_NAME_XMLIDX ON FRED.CUSTOMER
(INFO             ASC)
GENERATE KEY USING XMLPATTERN
'declare default element namespace "http://posample.org"; /customerinfo/name'
AS SQL VARCHAR  (50)
ALLOW REVERSE SCANS;

CREATE INDEX FRED.CUST_PHONES_XMLIDX ON FRED.CUSTOMER
(INFO             ASC)
GENERATE KEY USING XMLPATTERN
'declare default element namespace "http://posample.org"; /customerinfo/phone'
AS SQL VARCHAR  (25)
ALLOW REVERSE SCANS;

CREATE INDEX FRED.CUST_PHONET_XMLIDX ON FRED.CUSTOMER
(INFO             ASC)
GENERATE KEY USING XMLPATTERN
'declare default element namespace "http://posample.org"; /customerinfo/phone/@type'
AS SQL VARCHAR  (25)
ALLOW REVERSE SCANS;

CREATE TABLE FRED.DATA_FILE_NAMES
(DATA_FILE_NAME   VARCHAR(40)         NOT NULL
,DB2_TABLE_NAME   VARCHAR(40)         NOT NULL
,EXPORT_FILE_NAM  CHARACTER(8)        NOT NULL)
IN IBMDB2SAMPLEREL;

CREATE TABLE FRED.DEPARTMENT
(DEPTNO           CHARACTER(3)        NOT NULL
,DEPTNAME         VARCHAR(36)         NOT NULL
,MGRNO            CHARACTER(6)
,ADMRDEPT         CHARACTER(3)        NOT NULL
,LOCATION         CHARACTER(16))
IN USERSPACE1;

ALTER TABLE FRED.DEPARTMENT
ADD CONSTRAINT PK_DEPARTMENT PRIMARY KEY
(DEPTNO);

CREATE INDEX FRED.XDEPT2 ON FRED.DEPARTMENT
(MGRNO            ASC)
ALLOW REVERSE SCANS;

CREATE INDEX FRED.XDEPT3 ON FRED.DEPARTMENT
(ADMRDEPT         ASC)
ALLOW REVERSE SCANS;

CREATE ALIAS FRED.DEPT FOR FRED.DEPARTMENT;

CREATE TABLE FRED.EMPLOYEE
(EMPNO            CHARACTER(6)        NOT NULL
,FIRSTNME         VARCHAR(12)         NOT NULL
,MIDINIT          CHARACTER(1)
,LASTNAME         VARCHAR(15)         NOT NULL
,WORKDEPT         CHARACTER(3)
,PHONENO          CHARACTER(4)
,HIREDATE         DATE
,JOB              CHARACTER(8)
,EDLEVEL          SMALLINT            NOT NULL
,SEX              CHARACTER(1)
,BIRTHDATE        DATE
,SALARY           DECIMAL(9,2)
,BONUS            DECIMAL(9,2)
,COMM             DECIMAL(9,2))
IN USERSPACE1;

ALTER TABLE FRED.EMPLOYEE
ADD CONSTRAINT PK_EMPLOYEE PRIMARY KEY
(EMPNO);

CREATE INDEX FRED.XEMP2 ON FRED.EMPLOYEE
(WORKDEPT         ASC)
ALLOW REVERSE SCANS;

CREATE ALIAS FRED.EMP FOR FRED.EMPLOYEE;

CREATE TABLE FRED.EMPMDC
(EMPNO            INTEGER
,DEPT             INTEGER
,DIV              INTEGER)
IN IBMDB2SAMPLEREL;

CREATE TABLE FRED.EMPPROJACT
(EMPNO            CHARACTER(6)        NOT NULL
,PROJNO           CHARACTER(6)        NOT NULL
,ACTNO            SMALLINT            NOT NULL
,EMPTIME          DECIMAL(5,2)
,EMSTDATE         DATE
,EMENDATE         DATE)
IN USERSPACE1;

CREATE ALIAS FRED.EMPACT FOR FRED.EMPPROJACT;

CREATE ALIAS FRED.EMP_ACT FOR FRED.EMPPROJACT;

CREATE TABLE FRED.EMP_PHOTO
(EMPNO            CHARACTER(6)        NOT NULL
,PHOTO_FORMAT     VARCHAR(10)         NOT NULL
,PICTURE          BLOB(102400))
IN USERSPACE1;

ALTER TABLE FRED.EMP_PHOTO
ADD CONSTRAINT PK_EMP_PHOTO PRIMARY KEY
(EMPNO
,PHOTO_FORMAT);

CREATE TABLE FRED.EMP_RESUME
(EMPNO            CHARACTER(6)        NOT NULL
,RESUME_FORMAT    VARCHAR(10)         NOT NULL
,RESUME           CLOB(5120))
IN USERSPACE1;

ALTER TABLE FRED.EMP_RESUME
ADD CONSTRAINT PK_EMP_RESUME PRIMARY KEY
(EMPNO
,RESUME_FORMAT);

CREATE TABLE FRED.INVENTORY
(PID              VARCHAR(10)         NOT NULL
,QUANTITY         INTEGER
,LOCATION         VARCHAR(128))
IN IBMDB2SAMPLEXML;

ALTER TABLE FRED.INVENTORY
ADD CONSTRAINT PK_INVENTORY PRIMARY KEY
(PID);

CREATE TABLE FRED.IN_TRAY
(RECEIVED         TIMESTAMP
,SOURCE           CHARACTER(8)
,SUBJECT          CHARACTER(64)
,NOTE_TEXT        VARCHAR(3000))
IN USERSPACE1;

CREATE TABLE FRED.ORG
(DEPTNUMB         SMALLINT            NOT NULL
,DEPTNAME         VARCHAR(14)
,MANAGER          SMALLINT
,DIVISION         VARCHAR(10)
,LOCATION         VARCHAR(13))
IN USERSPACE1;

CREATE TABLE FRED.PRODUCT
(PID              VARCHAR(10)         NOT NULL
,NAME             VARCHAR(128)
,PRICE            DECIMAL(30,2)
,PROMOPRICE       DECIMAL(30,2)
,PROMOSTART       DATE
,PROMOEND         DATE
,DESCRIPTION      XML)
IN IBMDB2SAMPLEXML;

ALTER TABLE FRED.PRODUCT
ADD CONSTRAINT PK_PRODUCT PRIMARY KEY
(PID);

CREATE INDEX FRED.PROD_DETAIL_XMLIDX ON FRED.PRODUCT
(DESCRIPTION      ASC)
GENERATE KEY USING XMLPATTERN
'declare default element namespace "http://posample.org"; /product/description/detail'
AS SQL VARCHAR   HASHED
ALLOW REVERSE SCANS;

CREATE INDEX FRED.PROD_NAME_XMLIDX ON FRED.PRODUCT
(DESCRIPTION      ASC)
GENERATE KEY USING XMLPATTERN
'declare default element namespace "http://posample.org"; /product/description/name'
AS SQL VARCHAR  (128)
ALLOW REVERSE SCANS;

CREATE TABLE FRED.PRODUCTSUPPLIER
(PID              VARCHAR(10)         NOT NULL
,SID              VARCHAR(10)         NOT NULL)
IN IBMDB2SAMPLEXML;

CREATE TABLE FRED.PROJACT
(PROJNO           CHARACTER(6)        NOT NULL
,ACTNO            SMALLINT            NOT NULL
,ACSTAFF          DECIMAL(5,2)
,ACSTDATE         DATE                NOT NULL
,ACENDATE         DATE)
IN USERSPACE1;

ALTER TABLE FRED.PROJACT
ADD CONSTRAINT PK_PROJACT PRIMARY KEY
(PROJNO
,ACTNO
,ACSTDATE);

CREATE TABLE FRED.PROJECT
(PROJNO           CHARACTER(6)        NOT NULL
,PROJNAME         VARCHAR(24)         NOT NULL
,DEPTNO           CHARACTER(3)        NOT NULL
,RESPEMP          CHARACTER(6)        NOT NULL
,PRSTAFF          DECIMAL(5,2)
,PRSTDATE         DATE
,PRENDATE         DATE
,MAJPROJ          CHARACTER(6))
IN USERSPACE1;

ALTER TABLE FRED.PROJECT
ADD CONSTRAINT PK_PROJECT PRIMARY KEY
(PROJNO);

CREATE INDEX FRED.XPROJ2 ON FRED.PROJECT
(RESPEMP          ASC)
ALLOW REVERSE SCANS;

CREATE ALIAS FRED.PROJ FOR FRED.PROJECT;

CREATE TABLE FRED.PURCHASEORDER
(POID             BIGINT              NOT NULL
,STATUS           VARCHAR(10)         NOT NULL
,CUSTID           BIGINT
,ORDERDATE        DATE
,PORDER           XML
,COMMENTS         VARCHAR(1000))
IN IBMDB2SAMPLEXML;

ALTER TABLE FRED.PURCHASEORDER
ADD CONSTRAINT PK_PURCHASEORDER PRIMARY KEY
(POID);

CREATE INDEX FRED.PO_CID_XMLIDX ON FRED.PURCHASEORDER
(PORDER           ASC)
GENERATE KEY USING XMLPATTERN
'declare default element namespace "http://posample.org"; /PurchaseOrder/@Cid'
AS SQL DOUBLE
ALLOW REVERSE SCANS;

CREATE INDEX FRED.PO_PRODS_XMLIDX ON FRED.PURCHASEORDER
(PORDER           ASC)
GENERATE KEY USING XMLPATTERN
'declare default element namespace "http://posample.org"; /PurchaseOrder/itemlist/item/product/@pid'
AS SQL DOUBLE
ALLOW REVERSE SCANS;

CREATE INDEX FRED.PO_ZIP_XMLIDX ON FRED.PURCHASEORDER
(PORDER           ASC)
GENERATE KEY USING XMLPATTERN
'declare default element namespace "http://posample.org"; /PurchaseOrder/customerAdr/addr/pcode-zip'
AS SQL VARCHAR  (16)
ALLOW REVERSE SCANS;

CREATE TABLE FRED.SALES
(SALES_DATE       DATE
,SALES_PERSON     VARCHAR(15)
,REGION           VARCHAR(15)
,SALES            INTEGER)
IN USERSPACE1;

CREATE TABLE FRED.STAFF
(ID               SMALLINT            NOT NULL
,NAME             VARCHAR(9)
,DEPT             SMALLINT
,JOB              CHARACTER(5)
,YEARS            SMALLINT
,SALARY           DECIMAL(7,2)
,COMM             DECIMAL(7,2))
IN USERSPACE1;

CREATE TABLE FRED.SUPPLIERS
(SID              VARCHAR(10)         NOT NULL
,ADDR             XML)
IN IBMDB2SAMPLEXML;

ALTER TABLE FRED.SUPPLIERS
ADD CONSTRAINT PK_PRODUCTSUPPLIER PRIMARY KEY
(SID);

-- DELETE FROM FRED.ACT;
-- DELETE FROM FRED.CL_SCHED;
-- DELETE FROM FRED.CUSTOMER;
-- DELETE FROM FRED.DATA_FILE_NAMES;
-- DELETE FROM FRED.DEPARTMENT;
-- DELETE FROM FRED.EMPLOYEE;
-- DELETE FROM FRED.EMPMDC;
-- DELETE FROM FRED.EMPPROJACT;
-- DELETE FROM FRED.EMP_PHOTO;
-- DELETE FROM FRED.EMP_RESUME;
-- DELETE FROM FRED.INVENTORY;
-- DELETE FROM FRED.IN_TRAY;
-- DELETE FROM FRED.ORG;
-- DELETE FROM FRED.PRODUCT;
-- DELETE FROM FRED.PROJACT;
-- DELETE FROM FRED.PROJECT;
-- DELETE FROM FRED.PURCHASEORDER;
-- DELETE FROM FRED.SALES;
-- DELETE FROM FRED.STAFF;

INSERT INTO FRED.ACT VALUES
(10,'MANAGE','MANAGE/ADVISE'),
(20,'ECOST','ESTIMATE COST'),
(30,'DEFINE','DEFINE SPECS'),
(40,'LEADPR','LEAD PROGRAM/DESIGN'),
(50,'SPECS','WRITE SPECS'),
(60,'LOGIC','DESCRIBE LOGIC'),
(70,'CODE','CODE PROGRAMS'),
(80,'TEST','TEST PROGRAMS'),
(90,'ADMQS','ADM QUERY SYSTEM'),
(100,'TEACH','TEACH CLASSES'),
(110,'COURSE','DEVELOP COURSES'),
(120,'STAFF','PERS AND STAFFING'),
(130,'OPERAT','OPER COMPUTER SYS'),
(140,'MAINT','MAINT SOFTWARE SYS'),
(150,'ADMSYS','ADM OPERATING SYS'),
(160,'ADMDB','ADM DATA BASES'),
(170,'ADMDC','ADM DATA COMM'),
(180,'DOC','DOCUMENT');

INSERT INTO FRED.CL_SCHED VALUES
('042:BF',4,'12:10:00','14:00:00'),
('553:MJA',1,'10:30:00','11:00:00'),
('543:CWM',3,'09:10:00','10:30:00'),
('778:RES',2,'12:10:00','14:00:00'),
('044:HD',3,'17:12:30','18:00:00');

INSERT INTO FRED.CUSTOMER VALUES
(1000,null,null),
(1001,null,null),
(1002,null,null),
(1003,null,null),
(1004,null,null),
(1005,null,null);

INSERT INTO FRED.DATA_FILE_NAMES VALUES
('MFD_ROLLUP_REPORT_EXCLUDE_ENTITIES','MFD_ROLLUP_REPORT_EXCLUDE_ENTITIES','MFDZR103'),
('SCOPE_FIELDS','SCOPE_FIELDS','SCOPE105'),
('FMR_SECTOR_HIST','FMR_SECTOR_HIST','FMRZS091'),
('LOOKUP_LIST_HIST','LOOKUP_LIST_HIST','LOOKU101'),
('TRADE_TYPE_HIST','TRADE_TYPE_HIST','TRADE114'),
('SOURCE_SYSTEM_HIST','SOURCE_SYSTEM_HIST','SOURC107'),
('GL_PRODUCT','GL_PRODUCT','GLZPR095'),
('GL_TRANS_CODE_HIST','GL_TRANS_CODE_HIST','GLZTR097'),
('FMR_MAJOR_PRODUCT_HIST','FMR_MAJOR_PRODUCT_HIST','FMRZM090'),
('FEED_HIST_DATA','FEED_HIST_DATA','FEEDZ087'),
('FEED_TRADE_TYPE_VIEW','FEED_TRADE_TYPE_TO_VIEW','FEEDZ088'),
('GL_SUB_PRODUCT','GL_SUB_PRODUCT','GLZSU096'),
('LEGAL_COPER_HIST','LEGAL_COPER_HIST','LEGAL098'),
('LEGAL_ENTITY_HIST','LEGAL_ENTITY_HIST','LEGAL099'),
('WS_USER_LIST','WS_USER_LIST','WSZUS118'),
('LEGAL_ORACLE_HIST','LEGAL_ORACLE_HIST','LEGAL100'),
('FMR_BUSINESS_UNIT_HIST','FMR_BUSINESS_UNIT_HIST','FMRZB089'),
('GL_NATURAL_ACCOUNT_HIST','GL_NATURAL_ACCOUNT_HIST','GLZNA094'),
('COST_CENTER_HIST','COST_CENTER_HIST','COSTZ082'),
('TBXFSWAP','TBXFSWAP','TBXFS142'),
('DEAL_SUMMARY','DEAL_SUMMARY','DEALZ086'),
('TRADES','TRADES','TRADE115'),
('TRADE_PROFILE','TRADE_PROFILE','TRADE113'),
('PORTFOLIO_PROFILE','PORTFOLIO_PROFILE','PORTF104'),
('DEAL_EXPOSURE','DEAL_EXPOSURE','DEALZ085'),
('TRADE_EXPOSURE','TRADE_EXPOSURE','TRADE110'),
('V1EMPLOY_ARC_HR_DATA','V1EMPLOY_ARC_HR_DATA','V1EMP117'),
('TBCPTRTG_HIST_DATA','TBCPTRTG_HIST_DATA','TBCPT108'),
('CPT_FUNCTION_RATINGS_HIST','CPT_FUNCTION_RATINGS_HIST','CPTZF084'),
('PROCESSING_STACK','PROCESSING_STACK','PROCE140'),
('COUNTERPARTY_HIST','COUNTERPARTY_HIST','COUNT083'),
('BOOK_HIST','BOOK_HIST','BOOKZ081'),
('MFD_MARKING','MFD_MARKING','MFDZM102'),
('GL_ARCTIC_SCOPE','GL_ARCTIC_SCOPE','GLZAR093'),
('TRADE_INDICATIVES_HIST','TRADE_INDICATIVES_HIST','TRADE111'),
('GL_ACCOUNT_BALANCE_HIST','',''),
('BALANCEHIST','BALANCE_HIST','BALAN121'),
('TBSECDT','',''),
('XREF_TRADE_HIST','XREF_TRADE_HIST','XREFZ119'),
('TRADE_INDICATIVES_SEARCH_HIST','TRADE_INDICATIVES_SEARCH_HIST','TRADE112'),
('REPOSITORY','',''),
('SNAPSHOT_IMPORT','SNAPSHOT_IMPORT','SNAPS106'),
('TRADES_GLACIER_HIST','TRADES_GLACIER_HIST','TRADE116');

INSERT INTO FRED.DEPARTMENT VALUES
('A00','SPIFFY COMPUTER SERVICE DIV.','000010','A00',null),
('B01','PLANNING','000020','A00',null),
('C01','INFORMATION CENTER','000030','A00',null),
('D01','DEVELOPMENT CENTER',null,'A00',null),
('D11','MANUFACTURING SYSTEMS','000060','D01',null),
('D21','ADMINISTRATION SYSTEMS','000070','D01',null),
('E01','SUPPORT SERVICES','000050','A00',null),
('E11','OPERATIONS','000090','E01',null),
('E21','SOFTWARE SUPPORT','000100','E01',null),
('F22','BRANCH OFFICE F2',null,'E01',null),
('G22','BRANCH OFFICE G2',null,'E01',null),
('H22','BRANCH OFFICE H2',null,'E01',null),
('I22','BRANCH OFFICE I2',null,'E01',null),
('J22','BRANCH OFFICE J2',null,'E01',null);

INSERT INTO FRED.EMPLOYEE VALUES
('000010','CHRISTINE','I','HAAS','A00','3978','1995-01-01','PRES',18,'F','1963-08-24',152750.00,1000.00,4220.00),
('000020','MICHAEL','L','THOMPSON','B01','3476','2003-10-10','MANAGER',18,'M','1978-02-02',94250.00,800.00,3300.00),
('000030','SALLY','A','KWAN','C01','4738','2005-04-05','MANAGER',20,'F','1971-05-11',98250.00,800.00,3060.00),
('000050','JOHN','B','GEYER','E01','6789','1979-08-17','MANAGER',16,'M','1955-09-15',80175.00,800.00,3214.00),
('000060','IRVING','F','STERN','D11','6423','2003-09-14','MANAGER',16,'M','1975-07-07',72250.00,500.00,2580.00),
('000070','EVA','D','PULASKI','D21','7831','2005-09-30','MANAGER',16,'F','2003-05-26',96170.00,700.00,2893.00),
('000090','EILEEN','W','HENDERSON','E11','5498','2000-08-15','MANAGER',16,'F','1971-05-15',89750.00,600.00,2380.00),
('000100','THEODORE','Q','SPENSER','E21','0972','2000-06-19','MANAGER',14,'M','1980-12-18',86150.00,500.00,2092.00),
('000110','VINCENZO','G','LUCCHESSI','A00','3490','1988-05-16','SALESREP',19,'M','1959-11-05',66500.00,900.00,3720.00),
('000120','SEAN','','O''CONNELL','A00','2167','1993-12-05','CLERK',14,'M','1972-10-18',49250.00,600.00,2340.00),
('000130','DELORES','M','QUINTANA','C01','4578','2001-07-28','ANALYST',16,'F','1955-09-15',73800.00,500.00,1904.00),
('000140','HEATHER','A','NICHOLLS','C01','1793','2006-12-15','ANALYST',18,'F','1976-01-19',68420.00,600.00,2274.00),
('000150','BRUCE','','ADAMSON','D11','4510','2002-02-12','DESIGNER',16,'M','1977-05-17',55280.00,500.00,2022.00),
('000160','ELIZABETH','R','PIANKA','D11','3782','2006-10-11','DESIGNER',17,'F','1980-04-12',62250.00,400.00,1780.00),
('000170','MASATOSHI','J','YOSHIMURA','D11','2890','1999-09-15','DESIGNER',16,'M','1981-01-05',44680.00,500.00,1974.00),
('000180','MARILYN','S','SCOUTTEN','D11','1682','2003-07-07','DESIGNER',17,'F','1979-02-21',51340.00,500.00,1707.00),
('000190','JAMES','H','WALKER','D11','2986','2004-07-26','DESIGNER',16,'M','1982-06-25',50450.00,400.00,1636.00),
('000200','DAVID','','BROWN','D11','4501','2002-03-03','DESIGNER',16,'M','1971-05-29',57740.00,600.00,2217.00),
('000210','WILLIAM','T','JONES','D11','0942','1998-04-11','DESIGNER',17,'M','2003-02-23',68270.00,400.00,1462.00),
('000220','JENNIFER','K','LUTZ','D11','0672','1998-08-29','DESIGNER',18,'F','1978-03-19',49840.00,600.00,2387.00),
('000230','JAMES','J','JEFFERSON','D21','2094','1996-11-21','CLERK',14,'M','1980-05-30',42180.00,400.00,1774.00),
('000240','SALVATORE','M','MARINO','D21','3780','2004-12-05','CLERK',17,'M','2002-03-31',48760.00,600.00,2301.00),
('000250','DANIEL','S','SMITH','D21','0961','1999-10-30','CLERK',15,'M','1969-11-12',49180.00,400.00,1534.00),
('000260','SYBIL','P','JOHNSON','D21','8953','2005-09-11','CLERK',16,'F','1976-10-05',47250.00,300.00,1380.00),
('000270','MARIA','L','PEREZ','D21','9001','2006-09-30','CLERK',15,'F','2003-05-26',37380.00,500.00,2190.00),
('000280','ETHEL','R','SCHNEIDER','E11','8997','1997-03-24','OPERATOR',17,'F','1976-03-28',36250.00,500.00,2100.00),
('000290','JOHN','R','PARKER','E11','4502','2006-05-30','OPERATOR',12,'M','1985-07-09',35340.00,300.00,1227.00),
('000300','PHILIP','X','SMITH','E11','2095','2002-06-19','OPERATOR',14,'M','1976-10-27',37750.00,400.00,1420.00),
('000310','MAUDE','F','SETRIGHT','E11','3332','1994-09-12','OPERATOR',12,'F','1961-04-21',35900.00,300.00,1272.00),
('000320','RAMLAL','V','MEHTA','E21','9990','1995-07-07','FIELDREP',16,'M','1962-08-11',39950.00,400.00,1596.00),
('000330','WING','','LEE','E21','2103','2006-02-23','FIELDREP',14,'M','1971-07-18',45370.00,500.00,2030.00),
('000340','JASON','R','GOUNOT','E21','5698','1977-05-05','FIELDREP',16,'M','1956-05-17',43840.00,500.00,1907.00),
('200010','DIAN','J','HEMMINGER','A00','3978','1995-01-01','SALESREP',18,'F','1973-08-14',46500.00,1000.00,4220.00),
('200120','GREG','','ORLANDO','A00','2167','2002-05-05','CLERK',14,'M','1972-10-18',39250.00,600.00,2340.00),
('200140','KIM','N','NATZ','C01','1793','2006-12-15','ANALYST',18,'F','1976-01-19',68420.00,600.00,2274.00),
('200170','KIYOSHI','','YAMAMOTO','D11','2890','2005-09-15','DESIGNER',16,'M','1981-01-05',64680.00,500.00,1974.00),
('200220','REBA','K','JOHN','D11','0672','2005-08-29','DESIGNER',18,'F','1978-03-19',69840.00,600.00,2387.00),
('200240','ROBERT','M','MONTEVERDE','D21','3780','2004-12-05','CLERK',17,'M','1984-03-31',37760.00,600.00,2301.00),
('200280','EILEEN','R','SCHWARTZ','E11','8997','1997-03-24','OPERATOR',17,'F','1966-03-28',46250.00,500.00,2100.00),
('200310','MICHELLE','F','SPRINGER','E11','3332','1994-09-12','OPERATOR',12,'F','1961-04-21',35900.00,300.00,1272.00),
('200330','HELENA','','WONG','E21','2103','2006-02-23','FIELDREP',14,'F','1971-07-18',35370.00,500.00,2030.00),
('200340','ROY','R','ALONZO','E21','5698','1997-07-05','FIELDREP',16,'M','1956-05-17',31840.00,500.00,1907.00);

INSERT INTO FRED.EMPMDC VALUES
(0,1,1),
(10,1,1),
(20,1,1),
(30,1,1),
(40,1,1),
(50,1,1),
(60,1,1),
(70,1,1),
(80,1,1),
(90,1,1),
(100,1,1),
(110,1,1),
(120,1,1),
(130,1,1),
(140,1,1),
(150,1,1),
(160,1,1),
(170,1,1),
(180,1,1),
(190,1,1),
(200,1,1),
(210,1,1),
(220,1,1),
(230,1,1),
(240,1,1),
(250,1,1),
(260,1,1),
(270,1,1),
(280,1,1),
(290,1,1),
(300,1,1),
(310,1,1),
(320,1,1),
(330,1,1),
(340,1,1),
(350,1,1),
(360,1,1),
(370,1,1),
(380,1,1),
(390,1,1),
(400,1,1),
(410,1,1),
(420,1,1),
(430,1,1),
(440,1,1),
(450,1,1),
(460,1,1),
(470,1,1),
(480,1,1),
(490,1,1),
(500,1,1),
(510,1,1),
(520,1,1),
(530,1,1),
(540,1,1),
(550,1,1),
(560,1,1),
(570,1,1),
(580,1,1),
(590,1,1),
(600,1,1),
(610,1,1),
(620,1,1),
(630,1,1),
(640,1,1),
(650,1,1),
(660,1,1),
(670,1,1),
(680,1,1),
(690,1,1),
(700,1,1),
(710,1,1),
(720,1,1),
(730,1,1),
(740,1,1),
(750,1,1),
(760,1,1),
(770,1,1),
(780,1,1),
(790,1,1),
(800,1,1),
(810,1,1),
(820,1,1),
(830,1,1),
(840,1,1),
(850,1,1),
(860,1,1),
(870,1,1),
(880,1,1),
(890,1,1),
(900,1,1),
(910,1,1),
(920,1,1),
(930,1,1),
(940,1,1),
(950,1,1),
(960,1,1),
(970,1,1),
(980,1,1),
(990,1,1),
(1000,1,1),
(1010,1,1),
(1020,1,1),
(1030,1,1),
(1040,1,1),
(1050,1,1),
(1060,1,1),
(1070,1,1),
(1080,1,1),
(1090,1,1),
(1100,1,1),
(1110,1,1),
(1120,1,1),
(1130,1,1),
(1140,1,1),
(1150,1,1),
(1160,1,1),
(1170,1,1),
(1180,1,1),
(1190,1,1),
(1200,1,1),
(1210,1,1),
(1220,1,1),
(1230,1,1),
(1240,1,1),
(1250,1,1),
(1260,1,1),
(1270,1,1),
(1280,1,1),
(1290,1,1),
(1300,1,1),
(1310,1,1),
(1320,1,1),
(1330,1,1),
(1340,1,1),
(1350,1,1),
(1360,1,1),
(1370,1,1),
(1380,1,1),
(1390,1,1),
(1400,1,1),
(1410,1,1),
(1420,1,1),
(1430,1,1),
(1440,1,1),
(1450,1,1),
(1460,1,1),
(1470,1,1),
(1480,1,1),
(1490,1,1),
(1500,1,1),
(1510,1,1),
(1520,1,1),
(1530,1,1),
(1540,1,1),
(1550,1,1),
(1560,1,1),
(1570,1,1),
(1580,1,1),
(1590,1,1),
(1600,1,1),
(1610,1,1),
(1620,1,1),
(1630,1,1),
(1640,1,1),
(1650,1,1),
(1660,1,1),
(1670,1,1),
(1680,1,1),
(1690,1,1),
(1700,1,1),
(1710,1,1),
(1720,1,1),
(1730,1,1),
(1740,1,1),
(1750,1,1),
(1760,1,1),
(1770,1,1),
(1780,1,1),
(1790,1,1),
(1800,1,1),
(1810,1,1),
(1820,1,1),
(1830,1,1),
(1840,1,1),
(1850,1,1),
(1860,1,1),
(1870,1,1),
(1880,1,1),
(1890,1,1),
(1900,1,1),
(1910,1,1),
(1920,1,1),
(1930,1,1),
(1940,1,1),
(1950,1,1),
(1960,1,1),
(1970,1,1),
(1980,1,1),
(1990,1,1),
(2000,1,1),
(2010,1,1),
(2020,1,1),
(2030,1,1),
(2040,1,1),
(2050,1,1),
(2060,1,1),
(2070,1,1),
(2080,1,1),
(2090,1,1),
(2100,1,1),
(2110,1,1),
(2120,1,1),
(2130,1,1),
(2140,1,1),
(2150,1,1),
(2160,1,1),
(2170,1,1),
(2180,1,1),
(2190,1,1),
(2200,1,1),
(2210,1,1),
(2220,1,1),
(2230,1,1),
(2240,1,1),
(2250,1,1),
(2260,1,1),
(2270,1,1),
(2280,1,1),
(2290,1,1),
(2300,1,1),
(2310,1,1),
(2320,1,1),
(2330,1,1),
(2340,1,1),
(2350,1,1),
(2360,1,1),
(2370,1,1),
(2380,1,1),
(2390,1,1),
(2400,1,1),
(2410,1,1),
(2420,1,1),
(2430,1,1),
(2440,1,1),
(2450,1,1),
(2460,1,1),
(2470,1,1),
(2480,1,1),
(2490,1,1);

INSERT INTO FRED.EMPPROJACT VALUES
('000010','AD3100',10,0.50,'2002-01-01','2002-07-01'),
('000070','AD3110',10,1.00,'2002-01-01','2003-02-01'),
('000230','AD3111',60,1.00,'2002-01-01','2002-03-15'),
('000230','AD3111',60,0.50,'2002-03-15','2002-04-15'),
('000230','AD3111',70,0.50,'2002-03-15','2002-10-15'),
('000230','AD3111',80,0.50,'2002-04-15','2002-10-15'),
('000230','AD3111',180,0.50,'2002-10-15','2003-01-01'),
('000240','AD3111',70,1.00,'2002-02-15','2002-09-15'),
('000240','AD3111',80,1.00,'2002-09-15','2003-01-01'),
('000250','AD3112',60,1.00,'2002-01-01','2002-02-01'),
('000250','AD3112',60,0.50,'2002-02-01','2002-03-15'),
('000250','AD3112',60,1.00,'2003-01-01','2003-02-01'),
('000250','AD3112',70,0.50,'2002-02-01','2002-03-15'),
('000250','AD3112',70,1.00,'2002-03-15','2002-08-15'),
('000250','AD3112',70,0.25,'2002-08-15','2002-10-15'),
('000250','AD3112',80,0.25,'2002-08-15','2002-10-15'),
('000250','AD3112',80,0.50,'2002-10-15','2002-12-01'),
('000250','AD3112',180,0.50,'2002-08-15','2003-01-01'),
('000260','AD3113',70,0.50,'2002-06-15','2002-07-01'),
('000260','AD3113',70,1.00,'2002-07-01','2003-02-01'),
('000260','AD3113',80,1.00,'2002-01-01','2002-03-01'),
('000260','AD3113',80,0.50,'2002-03-01','2002-04-15'),
('000260','AD3113',180,0.50,'2002-03-01','2002-04-15'),
('000260','AD3113',180,1.00,'2002-04-15','2002-06-01'),
('000260','AD3113',180,1.00,'2002-06-01','2002-07-01'),
('000270','AD3113',60,0.50,'2002-03-01','2002-04-01'),
('000270','AD3113',60,1.00,'2002-04-01','2002-09-01'),
('000270','AD3113',60,0.25,'2002-09-01','2002-10-15'),
('000270','AD3113',70,0.75,'2002-09-01','2002-10-15'),
('000270','AD3113',70,1.00,'2002-10-15','2003-02-01'),
('000270','AD3113',80,1.00,'2002-01-01','2002-03-01'),
('000270','AD3113',80,0.50,'2002-03-01','2002-04-01'),
('000030','IF1000',10,0.50,'2002-06-01','2003-01-01'),
('000130','IF1000',90,1.00,'2002-10-01','2003-01-01'),
('000130','IF1000',100,0.50,'2002-10-01','2003-01-01'),
('000140','IF1000',90,0.50,'2002-10-01','2003-01-01'),
('000030','IF2000',10,0.50,'2002-01-01','2003-01-01'),
('000140','IF2000',100,1.00,'2002-01-01','2002-03-01'),
('000140','IF2000',100,0.50,'2002-03-01','2002-07-01'),
('000140','IF2000',110,0.50,'2002-03-01','2002-07-01'),
('000140','IF2000',110,0.50,'2002-10-01','2003-01-01'),
('000010','MA2100',10,0.50,'2002-01-01','2002-11-01'),
('000110','MA2100',20,1.00,'2002-01-01','2003-03-01'),
('000010','MA2110',10,1.00,'2002-01-01','2003-02-01'),
('000200','MA2111',50,1.00,'2002-01-01','2002-06-15'),
('000200','MA2111',60,1.00,'2002-06-15','2003-02-01'),
('000220','MA2111',40,1.00,'2002-01-01','2003-02-01'),
('000150','MA2112',60,1.00,'2002-01-01','2002-07-15'),
('000150','MA2112',180,1.00,'2002-07-15','2003-02-01'),
('000170','MA2112',60,1.00,'2002-01-01','2003-06-01'),
('000170','MA2112',70,1.00,'2002-06-01','2003-02-01'),
('000190','MA2112',70,1.00,'2002-01-01','2002-10-01'),
('000190','MA2112',80,1.00,'2002-10-01','2003-10-01'),
('000160','MA2113',60,1.00,'2002-07-15','2003-02-01'),
('000170','MA2113',80,1.00,'2002-01-01','2003-02-01'),
('000180','MA2113',70,1.00,'2002-04-01','2002-06-15'),
('000210','MA2113',80,0.50,'2002-10-01','2003-02-01'),
('000210','MA2113',180,0.50,'2002-10-01','2003-02-01'),
('000050','OP1000',10,0.25,'2002-01-01','2003-02-01'),
('000090','OP1010',10,1.00,'2002-01-01','2003-02-01'),
('000280','OP1010',130,1.00,'2002-01-01','2003-02-01'),
('000290','OP1010',130,1.00,'2002-01-01','2003-02-01'),
('000300','OP1010',130,1.00,'2002-01-01','2003-02-01'),
('000310','OP1010',130,1.00,'2002-01-01','2003-02-01'),
('000050','OP2010',10,0.75,'2002-01-01','2003-02-01'),
('000100','OP2010',10,1.00,'2002-01-01','2003-02-01'),
('000320','OP2011',140,0.75,'2002-01-01','2003-02-01'),
('000320','OP2011',150,0.25,'2002-01-01','2003-02-01'),
('000330','OP2012',140,0.25,'2002-01-01','2003-02-01'),
('000330','OP2012',160,0.75,'2002-01-01','2003-02-01'),
('000340','OP2013',140,0.50,'2002-01-01','2003-02-01'),
('000340','OP2013',170,0.50,'2002-01-01','2003-02-01'),
('000020','PL2100',30,1.00,'2002-01-01','2002-09-15');

INSERT INTO FRED.EMP_PHOTO VALUES
('000130','bitmap',null),
('000130','gif',null),
('000140','bitmap',null),
('000140','gif',null),
('000150','bitmap',null),
('000150','gif',null),
('000190','bitmap',null),
('000190','gif',null);

INSERT INTO FRED.EMP_RESUME VALUES
('000130','ascii',null),
('000130','html',null),
('000140','ascii',null),
('000140','html',null),
('000150','ascii',null),
('000150','html',null),
('000190','ascii',null),
('000190','html',null);

INSERT INTO FRED.INVENTORY VALUES
('100-100-01',5,null),
('100-101-01',25,'Store'),
('100-103-01',55,'Store'),
('100-201-01',99,'Warehouse');

INSERT INTO FRED.IN_TRAY VALUES
('1988-12-25 17:12:30.0','BADAMSON','FWD: Fantastic year! 4th Quarter Bonus.',null),
('1988-12-23 08:53:58.0','ISTERN','FWD: Fantastic year! 4th Quarter Bonus.',null),
('1988-12-22 14:07:21.136421','CHAAS','Fantastic year! 4th Quarter Bonus.',null);

INSERT INTO FRED.ORG VALUES
(10,'Head Office',160,'Corporate','New York'),
(15,'New England',50,'Eastern','Boston'),
(20,'Mid Atlantic',10,'Eastern','Washington'),
(38,'South Atlantic',30,'Eastern','Atlanta'),
(42,'Great Lakes',100,'Midwest','Chicago'),
(51,'Plains',140,'Midwest','Dallas'),
(66,'Pacific',270,'Western','San Francisco'),
(84,'Mountain',290,'Western','Denver');

INSERT INTO FRED.PRODUCT VALUES
('100-100-01','Snow Shovel, Basic 22 inch',9.99,7.25,'2004-11-19','2004-12-19',null),
('100-101-01','Snow Shovel, Deluxe 24 inch',19.99,15.99,'2005-12-18','2006-02-28',null),
('100-103-01','Snow Shovel, Super Deluxe 26 inch',49.99,39.99,'2005-12-22','2006-02-22',null),
('100-201-01','Ice Scraper, Windshield 4 inch',3.99,null,null,null,null);

INSERT INTO FRED.PROJACT VALUES
('AD3100',10,null,'2002-01-01',null),
('AD3110',10,null,'2002-01-01',null),
('AD3111',60,null,'2002-01-01',null),
('AD3111',60,null,'2002-03-15',null),
('AD3111',70,null,'2002-03-15',null),
('AD3111',80,null,'2002-04-15',null),
('AD3111',180,null,'2002-10-15',null),
('AD3111',70,null,'2002-02-15',null),
('AD3111',80,null,'2002-09-15',null),
('AD3112',60,null,'2002-01-01',null),
('AD3112',60,null,'2002-02-01',null),
('AD3112',60,null,'2003-01-01',null),
('AD3112',70,null,'2002-02-01',null),
('AD3112',70,null,'2002-03-15',null),
('AD3112',70,null,'2002-08-15',null),
('AD3112',80,null,'2002-08-15',null),
('AD3112',80,null,'2002-10-15',null),
('AD3112',180,null,'2002-08-15',null),
('AD3113',70,null,'2002-06-15',null),
('AD3113',70,null,'2002-07-01',null),
('AD3113',80,null,'2002-01-01',null),
('AD3113',80,null,'2002-03-01',null),
('AD3113',180,null,'2002-03-01',null),
('AD3113',180,null,'2002-04-15',null),
('AD3113',180,null,'2002-06-01',null),
('AD3113',60,null,'2002-03-01',null),
('AD3113',60,null,'2002-04-01',null),
('AD3113',60,null,'2002-09-01',null),
('AD3113',70,null,'2002-09-01',null),
('AD3113',70,null,'2002-10-15',null),
('IF1000',10,null,'2002-06-01',null),
('IF1000',90,null,'2002-10-01',null),
('IF1000',100,null,'2002-10-01',null),
('IF2000',10,null,'2002-01-01',null),
('IF2000',100,null,'2002-01-01',null),
('IF2000',100,null,'2002-03-01',null),
('IF2000',110,null,'2002-03-01',null),
('IF2000',110,null,'2002-10-01',null),
('MA2100',10,null,'2002-01-01',null),
('MA2100',20,null,'2002-01-01',null),
('MA2110',10,null,'2002-01-01',null),
('MA2111',50,null,'2002-01-01',null),
('MA2111',60,null,'2002-06-15',null),
('MA2111',40,null,'2002-01-01',null),
('MA2112',60,null,'2002-01-01',null),
('MA2112',180,null,'2002-07-15',null),
('MA2112',70,null,'2002-06-01',null),
('MA2112',70,null,'2002-01-01',null),
('MA2112',80,null,'2002-10-01',null),
('MA2113',60,null,'2002-07-15',null),
('MA2113',80,null,'2002-01-01',null),
('MA2113',70,null,'2002-04-01',null),
('MA2113',80,null,'2002-10-01',null),
('MA2113',180,null,'2002-10-01',null),
('OP1000',10,null,'2002-01-01',null),
('OP1010',10,null,'2002-01-01',null),
('OP1010',130,null,'2002-01-01',null),
('OP2010',10,null,'2002-01-01',null),
('OP2011',140,null,'2002-01-01',null),
('OP2011',150,null,'2002-01-01',null),
('OP2012',140,null,'2002-01-01',null),
('OP2012',160,null,'2002-01-01',null),
('OP2013',140,null,'2002-01-01',null),
('OP2013',170,null,'2002-01-01',null),
('PL2100',30,null,'2002-01-01',null);

INSERT INTO FRED.PROJECT VALUES
('AD3100','ADMIN SERVICES','D01','000010',6.50,'2002-01-01','2003-02-01',null),
('AD3110','GENERAL ADMIN SYSTEMS','D21','000070',6.00,'2002-01-01','2003-02-01','AD3100'),
('AD3111','PAYROLL PROGRAMMING','D21','000230',2.00,'2002-01-01','2003-02-01','AD3110'),
('AD3112','PERSONNEL PROGRAMMING','D21','000250',1.00,'2002-01-01','2003-02-01','AD3110'),
('AD3113','ACCOUNT PROGRAMMING','D21','000270',2.00,'2002-01-01','2003-02-01','AD3110'),
('IF1000','QUERY SERVICES','C01','000030',2.00,'2002-01-01','2003-02-01',null),
('IF2000','USER EDUCATION','C01','000030',1.00,'2002-01-01','2003-02-01',null),
('MA2100','WELD LINE AUTOMATION','D01','000010',12.00,'2002-01-01','2003-02-01',null),
('MA2110','W L PROGRAMMING','D11','000060',9.00,'2002-01-01','2003-02-01','MA2100'),
('MA2111','W L PROGRAM DESIGN','D11','000220',2.00,'2002-01-01','1982-12-01','MA2110'),
('MA2112','W L ROBOT DESIGN','D11','000150',3.00,'2002-01-01','1982-12-01','MA2110'),
('MA2113','W L PROD CONT PROGS','D11','000160',3.00,'2002-02-15','1982-12-01','MA2110'),
('OP1000','OPERATION SUPPORT','E01','000050',6.00,'2002-01-01','2003-02-01',null),
('OP1010','OPERATION','E11','000090',5.00,'2002-01-01','2003-02-01','OP1000'),
('OP2000','GEN SYSTEMS SERVICES','E01','000050',5.00,'2002-01-01','2003-02-01',null),
('OP2010','SYSTEMS SUPPORT','E21','000100',4.00,'2002-01-01','2003-02-01','OP2000'),
('OP2011','SCP SYSTEMS SUPPORT','E21','000320',1.00,'2002-01-01','2003-02-01','OP2010'),
('OP2012','APPLICATIONS SUPPORT','E21','000330',1.00,'2002-01-01','2003-02-01','OP2010'),
('OP2013','DB/DC SUPPORT','E21','000340',1.00,'2002-01-01','2003-02-01','OP2010'),
('PL2100','WELD LINE PLANNING','B01','000020',1.00,'2002-01-01','2002-09-15','MA2100');

INSERT INTO FRED.PURCHASEORDER VALUES
(5000,'Unshipped',1002,'2006-02-18',null,null),
(5001,'Shipped',1003,'2005-02-03',null,null),
(5002,'Shipped',1001,'2004-02-29',null,null),
(5003,'Shipped',1002,'2005-02-28',null,null),
(5004,'Shipped',1005,'2005-11-18',null,null),
(5006,'Shipped',1002,'2006-03-01',null,null);

INSERT INTO FRED.SALES VALUES
('2005-12-31','LUCCHESSI','Ontario-South',1),
('2005-12-31','LEE','Ontario-South',3),
('2005-12-31','LEE','Quebec',1),
('2005-12-31','LEE','Manitoba',2),
('2005-12-31','GOUNOT','Quebec',1),
('2006-03-29','LUCCHESSI','Ontario-South',3),
('2006-03-29','LUCCHESSI','Quebec',1),
('2006-03-29','LEE','Ontario-South',2),
('1996-03-29','LEE','Ontario-North',2),
('2006-03-29','LEE','Quebec',3),
('2006-03-29','LEE','Manitoba',5),
('2006-03-29','GOUNOT','Ontario-South',3),
('2006-03-29','GOUNOT','Quebec',1),
('2006-03-29','GOUNOT','Manitoba',7),
('2006-03-30','LUCCHESSI','Ontario-South',1),
('2006-03-30','LUCCHESSI','Quebec',2),
('2006-03-30','LUCCHESSI','Manitoba',1),
('2006-03-30','LEE','Ontario-South',7),
('2006-03-30','LEE','Ontario-North',3),
('2006-03-30','LEE','Quebec',7),
('2006-03-30','LEE','Manitoba',4),
('2006-03-30','GOUNOT','Ontario-South',2),
('2006-03-30','GOUNOT','Quebec',18),
('2006-03-31','GOUNOT','Manitoba',1),
('2006-03-31','LUCCHESSI','Manitoba',1),
('2006-03-31','LEE','Ontario-South',14),
('2006-03-31','LEE','Ontario-North',3),
('2006-03-31','LEE','Quebec',7),
('2006-03-31','LEE','Manitoba',3),
('2006-03-31','GOUNOT','Ontario-South',2),
('2006-03-31','GOUNOT','Quebec',1),
('2006-04-01','LUCCHESSI','Ontario-South',3),
('2006-04-01','LUCCHESSI','Manitoba',1),
('2006-04-01','LEE','Ontario-South',8),
('2006-04-01','LEE','Ontario-North',null),
('2006-04-01','LEE','Quebec',8),
('2006-04-01','LEE','Manitoba',9),
('2006-04-01','GOUNOT','Ontario-South',3),
('2006-04-01','GOUNOT','Ontario-North',1),
('2006-04-01','GOUNOT','Quebec',3),
('2006-04-01','GOUNOT','Manitoba',7);

INSERT INTO FRED.STAFF VALUES
(10,'Sanders',20,'Mgr',7,98357.50,null),
(20,'Pernal',20,'Sales',8,78171.25,612.45),
(30,'Marenghi',38,'Mgr',5,77506.75,null),
(40,'O''Brien',38,'Sales',6,78006.00,846.55),
(50,'Hanes',15,'Mgr',10,80659.80,null),
(60,'Quigley',38,'Sales',null,66808.30,650.25),
(70,'Rothman',15,'Sales',7,76502.83,1152.00),
(80,'James',20,'Clerk',null,43504.60,128.20),
(90,'Koonitz',42,'Sales',6,38001.75,1386.70),
(100,'Plotz',42,'Mgr',7,78352.80,null),
(110,'Ngan',15,'Clerk',5,42508.20,206.60),
(120,'Naughton',38,'Clerk',null,42954.75,180.00),
(130,'Yamaguchi',42,'Clerk',6,40505.90,75.60),
(140,'Fraye',51,'Mgr',6,91150.00,null),
(150,'Williams',51,'Sales',6,79456.50,637.65),
(160,'Molinare',10,'Mgr',7,82959.20,null),
(170,'Kermisch',15,'Clerk',4,42258.50,110.10),
(180,'Abrahams',38,'Clerk',3,37009.75,236.50),
(190,'Sneider',20,'Clerk',8,34252.75,126.50),
(200,'Scoutten',42,'Clerk',null,41508.60,84.20),
(210,'Lu',10,'Mgr',10,90010.00,null),
(220,'Smith',51,'Sales',7,87654.50,992.80),
(230,'Lundquist',51,'Clerk',3,83369.80,189.65),
(240,'Daniels',10,'Mgr',5,79260.25,null),
(250,'Wheeler',51,'Clerk',6,74460.00,513.30),
(260,'Jones',10,'Mgr',12,81234.00,null),
(270,'Lea',66,'Mgr',9,88555.50,null),
(280,'Wilson',66,'Sales',9,78674.50,811.50),
(290,'Quill',84,'Mgr',10,89818.00,null),
(300,'Davis',84,'Sales',5,65454.50,806.10),
(310,'Graham',66,'Sales',13,71000.00,200.30),
(320,'Gonzales',66,'Sales',4,76858.20,844.00),
(330,'Burke',66,'Clerk',1,49988.00,55.50),
(340,'Edwards',84,'Sales',7,67844.00,1285.00),
(350,'Gafney',84,'Clerk',5,43030.50,188.00);