To insert into the salesRep table:

INSERT INTO `mcclaina_phpSMCclass`.`salesRep` (
`salesRepKeyId` ,
`repNumber` ,
`repFirstName` ,
`repLastName` ,
`repAddress` ,
`repComissionTotal` ,
`repComissionRate`
)
VALUES (
NULL , 
'0', 
'Admin', 
'Admin', 
'1234 Admin Lane, Admin, AK 12345', 
'2000', 
'20'
);



To insert into the customer table:

INSERT INTO `mcclaina_phpSMCclass`.`customer` (
`customerId` ,
`customerNumber` ,
`customerName` ,
`customerAddress` ,
`customerBalance` ,
`customerCreditLimit` ,
`repNumber`
)
VALUES (
NULL , 
'1', 
'Sammy Spacey', 
'1234 Sammy Lane, Spacey, CA 12345', 
'1000', 
'2000', 
'1'
);



To insert into the inventoryItem table:

INSERT INTO `mcclaina_phpSMCclass`.`inventoryItem` (
`itemId` ,
`itemNumber` ,
`itemDescription` ,
`itemUnitsInStock` ,
`itemClass`,
`itemWarehouseLocation`,
`itemUnitPrice`
)
VALUES (
NULL , 
'1', 
'This item is freaking awesome! And it\'s made from the sweat of little unicorns...', 
'36', 
'AW', 
'alaska', 
'400'
);



To insert into the orderCustomerRecord table:

INSERT INTO `mcclaina_phpSMCclass`.`orderCustomerRecord` (
`orderId` ,
`orderNumber` ,
`orderDate` ,
`customerNumber`
)
VALUES (
NULL , 
'1000', 
'04-18-2014', 
'1'
);



To insert into the orderInventoryRecord table:

INSERT INTO `mcclaina_phpSMCclass`.`orderInventoryRecord` (
`orderInvId` ,
`orderInvNumber` ,
`orderInvTotalUnits` ,
`orderInvQuotedPrice`
)
VALUES (
NULL , 
'1', 
'5', 
'400.50'
);