-----------------------------------------------------------
--- ---
--- 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);