##    Brian Platz
##    CS85 Section 1643
##    Professor Geddes
##    May 5, 2012
##    Assignment: 
##       Write the SQL DML statements to populate the tables. 
##       Insert at least 2 rows into each table. 
##       Save your statements in a file called premierePopulate.sql.txt.

##    salesrep(salesID, lname, fname, address, comtot, comrate)
##    customer(custID, name, address, balance, climit, salesRep)
##    inventory(partID, itemDesc, count, class, whouse, cost)
##    custOrder(orderID, oDate, customer)
##    orderitem(orderNo, lineID, part, quant, quote)

USE premiere;

INSERT INTO salesrep VALUES (
	11, "Ant", "Adam", "1001 Main Street", 300.04, 0.05 
);
INSERT INTO salesrep VALUES (
	12, "Chaplin", "Charlie", "123 Elm Street", 0.0, 0.02
);
INSERT INTO salesrep VALUES (
	13, "Day", "Doris", "456 Cedar Street", 123.45, 0.03
);

INSERT INTO customer VALUES (
	101, "Barbara Billingley", "789 Mapleton Drive", 123.45, 500.01, 1
);
INSERT INTO customer VALUES (
	102, "Dom DeLuise", "1111 Oak Street", 678.91, 1500.01, 2
);

INSERT INTO inventory VALUES (
	1203, "Eureka vacuum cleaner", 3, "HH", 12, 88.88
);
INSERT INTO inventory VALUES (
	3102, "Fruit Basket", 5, "FO", 14, 7.34
);

INSERT INTO custOrder VALUES (
	301, 2012-02-14, 1
);
INSERT INTO custOrder VALUES (
	302, 2012-04-01, 2
);

INSERT INTO orderitem VALUES (
	301, 10001, 1203, 13, 123.97
);
INSERT INTO orderitem VALUES (
	301, 10002, 3102, 1, 12.49
);
INSERT INTO orderitem VALUES (
	302, 10003, 3102, 127, 14.99
);
INSERT INTO orderitem VALUES (
	302, 10004, 1203, 1, 99.99
);