insert into Person values ('0001','James','Blancaflor','1234 Random, Lakewood','562-884-2097','djblanc360@gmail.com');
insert into Person values ('0002','Emil','Evangelista','1234 Basic, Long Beach','555-555-5555','emil.evangelista@gmail.com');
insert into Person values ('0003','Andrew','Thai','45678 Made Up, Long Beach','666-666-6666','andrew.thai@gmail.com');
insert into Person values ('0004','Rayan','Aoun','9123 Something, Long Beach','777-777-7777','rayan.aoun@hotmail.com');
insert into Person values ('0005','Daryl','Blancaflor','1234 Random, Lakewood','562-529-5213', null);
insert into Person values ('0006','Nicole','Leigh','4567 Random, Westminster','888-888-8888','thenicoleleigh@hot.com');
insert into Person values ('0007','Marie','Madorie','7890 Basic, Garden Grove','999-999-9999','marie.madorie@gmail.com');
insert into Person values ('0008','Jenna','Kay','1234 Not Real, Westminster','567-890-1234','jenna.kay@yahoo.com');
insert into Person values ('0009','Victoria','Nguyen','5678 Fake, Los Angeles','123-456-7890','viccy@gmail.com');
insert into Person values ('0010','Tiffany','Marie','1122 Not Really, Irvine','111-111-1111','tiffany.marie@gmail.com');
insert into Person values ('0011','Trinity','Dang','3344 Something, Westminster','222-222-2222','trinity.dang@gmail.com');
insert into Person values ('0012','Jessica','Wong','5566 Lol, Huntington Beach','33-333-3333','jessica.wong@gmail.com');
insert into Person values ('0013','Vicky','Li','7788 Made Up, Los Angeles','444-444-4444','vickybaybee@yahoo.com');
insert into Person values ('0014','Barbara','Gonzo','639 Getouttatown, Los Angeles','748-838-3499','barbGonz@yahoo.com');
insert into Person values ('0015','Bill','Bandy','228 Anytown, Los Angeles','330-475-9838','billbandy@yahoo.com');
insert into Person values ('0016','Sarah','Chavez','7209 What, Los Angeles','442-948-1422','sarbae@yahoo.com');
insert into Person values ('0017','Craig','Mac','1345 SmallPlace, Los Angeles','672-232-0191','craigmac@yahoo.com');
insert into Person values ('0018','Ronald','Jenkins','6739 StuntVille, Los Angeles','827-535-9837','rj@yahoo.com');
insert into Person values ('0019','Tyler','Han','1923 Bosco, Los Angeles','321-734-9203','bananaman@yahoo.com');
insert into Person values ('0020','Bobby','Wen','7722 KingFisherWay, Los Angeles','983-028-2382','BobbyBlu@yahoo.com');
insert into Person values ('0021','Rishabh','Shah','6523 Sudra, Calcutta','827-829-4143','ShahBish@yahoo.com');


insert into Customers values ('0009');
insert into Customers values ('0010');
insert into Customers values ('0011');
insert into Customers values ('0012');


insert into Appointments values ('0001','2015-04-11');
insert into Appointments values ('0002','2015-09-22');
insert into Appointments values ('0003','2016-03-10');
insert into Appointments values ('0004','2016-06-30');
insert into Appointments values ('0005','2016-01-17');


insert into Prospective (person_ID, times_contacted, dead_prospect) values ('0009','0',false);
insert into Prospective (person_ID, times_contacted, dead_prospect) values ('0010','1',false);
insert into Prospective (person_ID, times_contacted, dead_prospect) values ('0011','2',false);
insert into Prospective (person_ID, times_contacted, dead_prospect) values ('0012','3',true);


insert into Current_Customers values ('0001','1994-02-13');
insert into Current_Customers values ('0002','2011-02-13');
insert into Current_Customers values ('0003','2011-06-22');
insert into Current_Customers values ('0004','2010-03-14');
insert into Current_Customers values ('0005','1994-02-13');
insert into Current_Customers values ('0006','2011-02-13');
insert into Current_Customers values ('0007','2011-06-22');
insert into Current_Customers values ('0008','2010-03-14');



insert into Steady (person_ID, loyalty_points) values ('0001','10');
insert into Steady (person_ID, loyalty_points) values ('0002','20');
insert into Steady (person_ID, loyalty_points) values ('0003','40');
insert into Steady (person_ID, loyalty_points) values ('0004','60');


insert into Premier values ('0005','3000','50');
insert into Premier values ('0006','4800','80');
insert into Premier values ('0007','4500','75');
insert into Premier values ('0008','2400','40');



insert into Employee values ('0014','3500');
insert into Employee values ('0015','2500');
insert into Employee values ('0016','4500');
insert into Employee values ('0017','1500');
insert into Employee values ('0018','5500');


insert into Mechanic (person_ID,certification) values ('0016','Brakes');
insert into Mechanic (person_ID,certification) values ('0017','Suspension');
insert into Mechanic (person_ID,certification) values ('0018','Engine Repair');
insert into Mechanic (person_ID,certification) values ('0019',null);
insert into Mechanic (person_ID,certification) values ('0020','Heating/AC');
insert into Mechanic (person_ID,certification) values ('0021',null);


insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0001','1HGCM82633A004352','toyota','xA','2005','100000','D2892321');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0002','1FTWX32Y08ED82667','honda','accord','2040','342','G9644617');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0003','1HD1BSY391Y070400','bmw','650i','2004','76532324','Q7478171');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0004','1FV6HFAC5RL406449','toyota','tc','2022','67745','E3402494');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0004','WDCGG0EBXDG110761','toyota','xA','2007','300000','E3402494');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0005','1FALP52UXNA218752','bmw','sedan','2009','800000','D1578186');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0005','1GTEK19V11E110046','honda','civic','2043','200000','D1578186');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0006','3HAJTSKN4CL661193','toyota','xb','2078','600000','F5621489');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0007','JKAKZCP24XB597556','toyota','ia','2025','864434000','H6003745');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0008','WBAPL5C53BA713480','audi','hybrid','2005','765342332','S4024632');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0009','3D6WH46LX9G520799','porsche','cayenne','2008','3455746','S7934207');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0009','1FVHA6CK35LV78829','mercedes-benz','s class','2003','87545','S7934207');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0009','4T1BK3DB0CUU39949','volkswagon','beetle','2001','978655','S7934207');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0010','SALTK15441A216026','audi','allroad','2005','1400000','A5731633');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0011','1GKGC26N7SJ765485','dodge','avalanche','2003','400000','G4083008');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0012','WDDFH34X79J301809','dodge','durango','2009','900000','A2870846');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0012','1GBHC34R8TE228683','jeep','grand cherokee','2004','14323445','A2870846');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0013','JTDBE30K520090505','bmw','M6','2002','45432345','O1073644');
insert into Vehicle (person_ID, VIN, make, model, yearof, mileage, license_plate) values ('0013','1HTMMAAR8AH179287','bmw','gran coupe','2006','65434','O1073644');