#Add Addresses: Customers, Supplier, Shipping Company, and myself
insert into Address
	(Address_Recipient_Name, Address_Line_1, Postal_Code, City, Province, IsPOBox)
values
	('First Customer', '123 Address Lane', 'A0A0A0', 'Citytown', 'ON', 1);
insert into Address
	(Address_Recipient_Name, Address_Line_1, Postal_Code, City, Province)
values
	('My Own Business', '234 ECommerce Street', 'C3C3C3', 'Businessville', 'NS');
insert into Address
(	Address_Recipient_Name, Address_Line_1, Address_Line_2, Postal_Code, City, Province, IsPOBox)
values
	('First Customer', '900 Fakey Drive', 'Unit #F', 'Z9Z9Z9', 'Fakerton', 'FK', 0);
insert into Address
	(Address_Recipient_Name, Address_Line_1, Postal_Code, City, Province)
values
	('Second Customer', '222 Secunda Private', 'B2B2B2', 'Townsville', 'AB');
insert into Address
	(Address_Recipient_Name, Address_Line_1, Postal_Code, City, Province, IsPOBox)
values
	('Acme Supplies Company', '555 Sourcing Avenue', 'S5S5S5', 'Megatown', 'BC', 1);
insert into Address
	(Address_Recipient_Name, Address_Line_1, Address_Line_2, Postal_Code, City, Province)
values
	('Shipsters Express', '777 Going Place', 'Second Floor, Unit 277', 'L7L7L7', 'Gonerton', 'MB');

#Add Customers
insert into Customer
	(Cust_First_Name, Cust_Last_Name, Cust_Email, Cust_Phone_No)
values
	('First', 'Customer', 'firstyfakey@netstuff.com', '111-111-1111');
insert into Customer
	(Cust_First_Name, Cust_Last_Name, Cust_Email, Cust_Phone_No)
values
	('Second', 'Customer', 'SecundusII@myemail.com', '222-222-2222');

#Add Suppliers
insert into Supplier
	(Supplier_Co_Name, Contact_Name, Supplier_Email, Supplier_Phone_No, Supplier_Address_ID)
values
	('Acme Supplies Company', 'Betsy McAcmeson', 'betsy@acmesupplies.com', '555-555-5555', 5);

#Add Products
insert into Product
	(Prod_Name, Prod_Desc, Prod_Price, Prod_Quant)
values
	('Superior Thingy', 'Its better than everyone elses', 49.99, 45);
insert into Product
	(Prod_Name, Prod_Desc, Prod_Price, Prod_Quant)
values
	('Best Whatsit', 'So much better than the other ones', 99.99, 32);
insert into Product
	(Prod_Name, Prod_Desc, Prod_Price, Prod_Quant)
values
	('Highest Ranked Stuff', 'Performs better than the leading version', 74.99, 17);
insert into Product
	(Prod_Name, Prod_Desc, Prod_Price, Prod_Quant)
values
	('Premium Doodad', 'Luxury at its finest', 19.99, 61);
insert into Product
	(Prod_Name, Prod_Price)
values
	('Test Item', 99.99);
insert into Product
(Prod_Name, Prod_Desc, Prod_Price)
values
('Newfangled Whizbang', 'Newest and whizziest', 34.99);

#Add Shipping Company
insert into ShippingCompany
	(Ship_Co_Name, Ship_Co_Email, Ship_Co_Phone_No, Ship_Co_Address_ID)
values
	('Shipsters Express', 'info@shipsters.ca', '777-777-7777', 6);

#Add Payment Types: Customers and myself
insert into PaymentType
	(Card_Type, Cardholder_Name, Card_No, Card_Exp_Date, Card_Security, Billing_Address_ID)
values
	('Visa', 'First Customer', 'xxxxxxxxxxxx', '1121', '111', 1);
insert into PaymentType
	(Card_Type, Cardholder_Name, Card_No, Card_Exp_Date, Card_Security, Billing_Address_ID)
values
	('Amex', 'Second Secundus', '123123123123', '1222', '222', 4);
insert into PaymentType
	(Card_Type, Cardholder_Name, Card_No, Card_Exp_Date, Card_Security, Billing_Address_ID)
values
	('Mastercard', 'Business Owner', '9876543210', '0125', '000', 2);
#Add Inbound Shipping Details
insert into InboundShipping
	(In_Ship_Co, In_Ship_Address, In_Ship_Cost)
values
	(1, 6, 130.24);
insert into InboundShipping
	(In_Ship_Co, In_Ship_Address, In_Ship_Cost)
values
	(1, 6, 224.24);
insert into InboundShipping
	(In_Ship_Co, In_Ship_Address, In_Ship_Cost)
values
	(1, 6, 35.04);

#Add Purchase Orders - Details
insert into PurchaseOrderDetails
	(PO_Pay_ID, PO_Supplier_ID, Subtotal_Prods, PO_Total, PO_Ship_Details, Order_Received)
values
	(3, 1, 1225.00, 1355.24, 1, 1);
insert into PurchaseOrderDetails
	(PO_Pay_ID, PO_Supplier_ID, Subtotal_Prods, PO_Total, PO_Ship_Details, Order_Received)
values
	(3, 1, 2882.00, 3106.24, 2, 1);
insert into purchaseorderdetails
	(PO_Pay_ID, PO_Supplier_ID, Subtotal_Prods, PO_Total, PO_Ship_Details)
values
	(3, 1, 120.00, 155.04, 3);

#Add Purchase Orders - Items
insert into PurchaseOrderItems
	(PO_No, Prod_ID, Prod_Quant)
values
	(1, 1, 5);
insert into PurchaseOrderItems
	(PO_No, Prod_ID, Prod_Quant)
values
	(1, 2, 9);
insert into PurchaseOrderItems
	(PO_No, Prod_ID, Prod_Quant)
values
	(1, 3, 17);
insert into PurchaseOrderItems
	(PO_No, Prod_ID, Prod_Quant)
values
	(2, 1, 40);
insert into PurchaseOrderItems
	(PO_No, Prod_ID, Prod_Quant)
values
	(2, 2, 23);
insert into PurchaseOrderItems
	(PO_No, Prod_ID, Prod_Quant)
values
	(2, 4, 61);
insert into PurchaseOrderItems
	(PO_No, Prod_ID, Prod_Quant)
values
	(3, 6, 6);

#Add Outbound Shipping Details
insert into OutboundShipping
	(Out_Ship_Co, Out_Ship_Address, Out_Ship_Cost)
values
	(1, 1, 10.00);
insert into OutboundShipping
	(Out_Ship_Co, Out_Ship_Address, Out_Ship_Cost)
values
	(1, 3, 36.53);
insert into OutboundShipping
	(Out_Ship_Co, Out_Ship_Address, Out_Ship_Cost)
values
	(1, 4, 10.00);

#Add Invoices - Details
insert into InvoiceDetails
	(Inv_Pay_ID, Inv_Cust_ID, Subtotal_Prods, Inv_Total, Inv_Ship_Details, Order_Status)
values
	(1, 1, 99.99, 109.00, 1, 'Complete');
insert into InvoiceDetails
	(Inv_Pay_ID, Inv_Cust_ID, Subtotal_Prods, Inv_Total, Inv_Ship_Details, Order_Status)
values
	(2, 2, 94.98, 104.98, 3, 'In Transit');
insert into InvoiceDetails
	(Inv_Pay_ID, Inv_Cust_ID, Subtotal_Prods, Inv_Total, Inv_Ship_Details, Order_Status)
values
	(1, 1, 724.90, 761.43, 2, 'Pending');

#Add Invoices - Items
insert into InvoiceItems
	(Inv_No, Prod_ID, Prod_Quant)
values
	(1, 2, 1);
insert into InvoiceItems
	(Inv_No, Prod_ID, Prod_Quant)
values
	(2, 3, 1);
insert into InvoiceItems
	(Inv_No, Prod_ID, Prod_Quant)
values
	(2, 4, 1);
insert into InvoiceItems
	(Inv_No, Prod_ID, Prod_Quant)
values
	(3, 1, 3);
insert into InvoiceItems
	(Inv_No, Prod_ID, Prod_Quant)
values
	(3, 2, 2);
insert into InvoiceItems
	(Inv_No, Prod_ID, Prod_Quant)
values
	(3, 3, 5);