INSERT INTO EQUIP_CLASS VALUES('OFF', 'Office Copier');
INSERT INTO EQUIP_CLASS VALUES('MIX', 'Concrete Mix');
INSERT INTO EQUIP_CLASS VALUES('TRU', 'Wood Trusses');
INSERT INTO EQUIP_CLASS VALUES('FRM', 'Framing');
INSERT INTO EQUIP_CLASS VALUES('STF', 'Steel Framing');
INSERT INTO EQUIP_CLASS VALUES('FLD', 'Front Loader');
INSERT INTO EQUIP_CLASS VALUES('CRA', 'Overhead Lift');

INSERT INTO SALESPERSON VALUES('13', 'Walter Chan');
INSERT INTO SALESPERSON VALUES('20', 'Joe Shoelly');
INSERT INTO SALESPERSON VALUES('23', 'Oliv Gardenor');

INSERT INTO EQUIPMENT VALUES('P100', 'Blue Print Model HP2959', 'OFF');
INSERT INTO EQUIPMENT VALUES('CMT2', 'Concrete Mixer', 'MIX');
INSERT INTO EQUIPMENT VALUES('A100', '50 X 60 Rofing', 'TRU');
INSERT INTO EQUIPMENT VALUES('A137', '2X4X8 Poplar', 'FRM');
INSERT INTO EQUIPMENT VALUES('STL10', 'Front Steel Loader', 'STF');
INSERT INTO EQUIPMENT VALUES('ST22', 'Stone Crusher', 'MIX');
INSERT INTO EQUIPMENT VALUES('FL660', 'Front Loading Device', 'FLD');
INSERT INTO EQUIPMENT VALUES('CRA11', '120 Overhead Crane', 'CRA');

INSERT INTO CUSTOMER VALUES('46', 'Wells', 'Laurie', '112 Apple Rd, Toronto', '(416)289-4417', 124728121, '23');
INSERT INTO CUSTOMER VALUES('52', 'MacDonn', 'Ronald', '1 Big Mac Rd, Totonto', '(800)448-9000', 218647113, '20');
INSERT INTO CUSTOMER VALUES('83', 'Duley', 'Tom', '3 Hanghead Dr, Markham', '(416)229-4104', 199565716, '13');
INSERT INTO CUSTOMER VALUES('103', 'Jeanne', 'Jeanne', '2 Youngalive St. Toronto', '(416)664-3121', 214796188, '23');

INSERT INTO INVOICE VALUES('CCI-44720', '2013-02-17', '23', '103');
INSERT INTO INVOICE VALUES('CCI-44721', '2013-02-18', '13', '83');
INSERT INTO INVOICE VALUES('CCI-44722', '2013-02-18', '23', '46');
INSERT INTO INVOICE VALUES('CCI-44723', '2013-02-18', '20', '52');

INSERT INTO INVOICE_EQUIPMENT VALUES('CCI-44720', 'P100', 2, 420);
INSERT INTO INVOICE_EQUIPMENT VALUES('CCI-44720', 'CMT2', 20, 4000);
INSERT INTO INVOICE_EQUIPMENT VALUES('CCI-44721', 'A100', 48, 1200);
INSERT INTO INVOICE_EQUIPMENT VALUES('CCI-44721', 'A137', 1000, 7500);
INSERT INTO INVOICE_EQUIPMENT VALUES('CCI-44721', 'P100', 4, 840);
INSERT INTO INVOICE_EQUIPMENT VALUES('CCI-44721', 'STL10', 3, 1500);
INSERT INTO INVOICE_EQUIPMENT VALUES('CCI-44722', 'ST22', 1, 950);
INSERT INTO INVOICE_EQUIPMENT VALUES('CCI-44722', 'FL660', 1, 450);
INSERT INTO INVOICE_EQUIPMENT VALUES('CCI-44723', 'CRA11', 3, 9000);