INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000001, 15.36, 25 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000002, 42.22, 6 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000003, 106.89, 79 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000004, 67.74, 72 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000005, 234.53, 65 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000006, 0.00, 0 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000007, 7.54, 44 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000008, 18.99, 30);

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000009, 55.12, 15 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(00000000010, 122.43, 90 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000011, 76.88, 52 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000012, 0.00, 40 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000013, 146.76, 42 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000014, 32.67, 87 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000015, 89.68, 15 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000016, 30.99, 85 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000017, 179.87, 21 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000018, 0.00, 64 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000019, 23.45, 0 );

INSERT INTO ACCOUNT
	(AccountID, Balance, Rewards Points)
	values
	(0000000020, 66.87, 55 );

//////////////////////////////////////////////////////////////////////

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000001, rcastro@gmail.com, Ramon, Castro , 847-487-4256, 0000000001  );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000002 , mbuehrle@gmail.com, Mark, Buehrle, 219-345-2334, 0000000002 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000003 , adunn@gmail.com, Adam, Dunn, 847-487-9010, 0000000003 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000004 , pkonerko@gmail.com, Paul, Konerko, 312-456-2221, 0000000004 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000005 , jpierre@gmail.com, Juan, Pierre, 630-654-1134, 0000000005 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000006 , lmill@gmail.com, Lastings, Milledge, 312-879-5464, 0000000006 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000007 , mteahen@gmail.com, Mark, Teahen, 224-324-7654, 0000000007 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000008 , arios@gmail.com, Alex, Rios, 312-487-3543, 0000000008 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000009 , bmorel@gmail.com, Brent, Morel, 312-456-9787, 0000000009 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000010 , gbeckham@gmail.com, Gordon, Beckham, 224-487-9433, 0000000010 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000011 , blillibridge@gmail.com, Brent, Lillibridge, 312-909-4545, 0000000011 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000012 , aramirez@gmail.com, Alexei, Ramirez, 847-764-2344, 0000000012 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000013 , ovizquel@gmail.com, Omar, Vizquel, 301-966-4342, 0000000013 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000014 , jcrain@gmail.com, Jesse, Crain, 301-455-7643, 0000000014 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000015 , mthornton@gmail.com, Matt, Thornton, 312-334-2343, 0000000015 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000016 , kcofield@gmail.com, Kyle, Cofield, 847-487-7464, 0000000016 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000017 , fdolsi@gmail.com, Freddy, Dolsi, 312-433-4554, 0000000017 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000018 , sgartrell@gmail.com, Stefan, Gartrell, 224-744-7612, 0000000018 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000019 , njones@gmail.com, Nathan, Jones, 847-487-2174, 0000000019 );

INSERT INTO CUSTOMER
	(CustomerID, Email, FirstName, LastName, HomePhone, AccountID)
	values
	(0000000020 , jnunez@gmail.com, Jhonny, Nunez, 212-543-5634, 0000000020 );

/////////////////////////////////////////////////////////////////////////////////

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000001, Home, 432 Dempsy Dr, Chicago, IL, 60639, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000002, Home, 1123 Rockefellar Ave, Chicago, IL, 60613, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000003, Home, 768 Hale Dr, Hawthorne Woods, IL, 60060, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000004, Home, 400 Main St, Libertyville, IL, 60048, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000005, Business, 3423 Eerie Dr, Chicago, IL, 60611, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000006, Home, 2350 Barnswallow Dr, Barrington, IL, 60010, US, none );

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000007, Home, 432 Chicago Dr, Rockford, IL, 61112, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000008, Business, 765 Syracuse Dr, Lake Forest, IL, 60045, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000009, Business, 301 Sunset Ave, Chicago, IL, 60011, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000010, Home, 4321 Diversity Dr, Chicago, IL, 60012, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000011, Home, 6540 Park Ave, Lake Forest, IL, 60045, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000012, Home, 6543 Michigan Dr, Chicago, IL, 60611, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000013, Home, 45 Wilshire Dr, Rockford, IL, 61112, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000014, Business, 65 Northwestern Dr, Lake Forest, IL, 60045, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000015, Home, 345 Cicero Dr, Chicago, IL, 60616, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000016, Business, 455 Hawthorne Dr, Hawthorne Woods, IL, 60060, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000017, Home, 4345 Bergen St, Roskilde, none, none, Denmark, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000018, Home, 404 Superior Ave, Chicago, IL, 60611, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000019, Home, 32 Chapel Dr, Chicago, IL, 60614, US, none);

INSERT INTO CUSTOMERADDRESS
	(CustomerID, AddressType, AddressLine1, City, State, ZipCode, Country, AddressLine2)
	values
	(0000000020, Home, 470 Cole Ave, Wauconda, IL, 60084, US, none);

////////////////////////////////////////////////////////////////////////////////////

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000001, 0000000030);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000002, 0000000046);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000003, 0000000032);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000004, 0000000043);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000005, 0000000041);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000006, 0000000034);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000007, 0000000035);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000008, 0000000030);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000009, 0000000036);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000010, 0000000047);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000011, 0000000037);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000012, 0000000039);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000013, 0000000033);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000014, 0000000044);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000015, 0000000039);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000016, 0000000037);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000017, 0000000046);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000018, 0000000049);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000019, 0000000030);

INSERT INTO ORDERLINE
	(OrderID, CustomerID, ItemID)
	values
	(varchar 10, 0000000020, 0000000038);

///////////////////////////////////////////////////////////////////

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000030, White Polo, Durable polo shirt made of 100% cotton, 200, 39.99, 11/15/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000031, Orange V Neck Shirt, Classic V neck design shirt, 75, 19.99, 2/4/11 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000032, Striped Shirt, Cotton striped dress shirt, 45, 49.50, 3/5/11 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000033, Skinny Fit Jeans, Resin rinsed skinny jeans, 75, 59.95, 4/3/11 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000034, Woven Summer Fedora, Wool weaved gray fedora, 50, 24.45, 3/15/11 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000035, End On End Tie, Silver silk tie, 25, 19.99, 2/15/11 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000036, Leather Belt, Brown leather belt, 60, 29.99, 6/13/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000037, Mockneck Sweater, Navy Mockneck Sweater, 30, 49.99, 5/12/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000038, Slub Knit Cardigan, Cotton knit cardigan, 80, 44.95, 10/20/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000039, Pinstripe Blazer, Navy blazer with white pinstripes, 25, 98.99, 11/22/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000040, Shaker Crewneck Sweater, Cotton crewneck sweater gray, 75, 29.99, 1/25/11 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000041, Fatigue Jacket, Durable gray fatigue jacket, 45, 89.50, 2/12/11 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000042, Pigment Dyed Polo, Red pigment dyed polo, 50, 34.95, 5/20/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000043, Long Sleeved Pique Polo, Black long sleeved polo, 65, 22.99, 6/12/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000044, Gap Logo Boxers, Gap logo boxers white, 50, 14.99, 1/15/11 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000045, Loose Fit Jeans, Loose fit denim jeans, 200, 39.99, 10/12/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000046, Banker button down shirt, Button down shirt dress shirt, 100, 34.99, 7/14/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000047, Logo Graphic Tee, Logo Graphic t-shirt, 200, 19.99, 6/20/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000048, Original Khaki, The original khaki by gap, 300, 39.99, 9/24/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000049, Twead Jacket, High quality tan twead jacket, 75, 89.99, 10/19/10 );

INSERT INTO ITEM
	(ItemID, ItemName, ItemDescription, QuantityOnHand, ItemPrice, PurchaseDate)
	values
	(0000000050, Leather Bomber Jacket, Medium grain dark leather jacket, 100, 129.99, 10/12/10 );