API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 5th, 2016
469
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.56 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO person(p_id,firstName,lastName,phone,email,address)
  2. VALUES('100001','Alan','Smithee','562-267-1236','asmithee@gmail.com','2315 Fremont st'),
  3. ('100002','Ruben','Marin','323-788-2100','rmarin@gmail.com','3317 Wilton st'),
  4. ('100003','Daniel','Jacobo','562-563-1536','djacobo@gmail.com','15 Spring st'),
  5. ('100004','Conor','Mcgregor','562-734-8362','NotoriusMMA@gmail.com','21 Irish Blvd'),
  6. ('100005','Anderson','Silva','562-973-8374','SpiderSilva@gmail.com','23 goat st'),
  7. ('100006','George','St. Pierre','562-342-9348','gsp@gmail.com','43 French Ave'),
  8. ('100007','Jon','Jones','562-623-1236','boneJones@gmail.com','15 clean Rd'),
  9. ('100008','Dominic','Cruz','562-267-8935','dcruz@gmail.com','23 small st'),
  10. ('100009','Marcus','Fenix','562-267-8325','Dfenix@gmail.com','25 Locust st'),
  11. ('100010','Karl','Marx','562-352-0835','Marx@gmail.com','2315 Free st'),
  12. ('100011','Dean','Lister','562-352-1236','boogieman@gmail.com','78 Low st'),
  13. ('100012','Alan','Rickman','562-985-1247','arickman@gmail.com','34 Deep st'),
  14. ('100013','David','Tennant','562-847-9385','dt10@gmail.com','2315 Tardis Rd'),
  15. ('100014','Matt','Smith','562-853-1236','MS11@gmail.com','2315 Tardis Rd'),
  16. ('900001','Mimi','Opkins','562-935-3425','mimi.opkins@csulb.edu','2315 Bellflower Blvd'),
  17. ('900002','Alvaro','Monge','562-265-1221','alvaro.monge@csulb.edu','2315 Bellflower Blvd'),
  18. ('900003','Dave','Brown','714-347-1236','dave.brown@gmail.com','231 Freeman st'),
  19. ('900004','Steve','Jobs','714-253-1536','Steve@apple.com','43 Apple Rd'),
  20. ('900005','Bill','Gates','714-567-4536','Bill@hotmail.com','453 Windows Ave'),
  21. ('900006','Steve','Woz','714-347-1265','TheWoz@gmail.com','896 Apple Rd');
  22.  
  23. INSERT INTO customer(c_id,initalDate)
  24. VALUES('100001','2001-01-01'),
  25. ('100002','2001-01-01'),
  26. ('100003','2005-05-14'),
  27. ('100004','2005-03-11'),
  28. ('100005','2007-07-22'),
  29. ('100006','2009-08-16'),
  30. ('100007','2010-10-31'),
  31. ('100008','2011-11-11'),
  32. ('100009','2012-03-22'),
  33. ('100010','2011-11-15'),
  34. ('100011','2013-07-17'),
  35. ('100012','2015-03-07'),
  36. ('100013','2016-12-01'),
  37. ('100014','2016-12-02');
  38.  
  39. INSERT INTO corporation(c_id,corpName)
  40. VALUES('100013','RideShare inc'),
  41. ('100014','Call-A-Cab');
  42.  
  43. INSERT INTO address(c_id,address,addresstype)
  44. VALUES('100013','123 Redondo Ave','billing'),
  45. ('100013','344 Anaheim st','Delivery'),
  46. ('100014','354 Spring st','Billing'),
  47. ('100014','231 Redondo Ave','Pickup');
  48.  
  49. INSERT INTO prospective(c_id,isViable)
  50. VALUES('100011',TRUE),
  51. ('100012',FALSE);
  52.  
  53. INSERT INTO contact(prospective,deal,expirationDate,dateSent,isSpecialTaken)
  54. VALUES('100011','Oil','2016-12-01','2017-01-31',TRUE),
  55. ('100012','$50','2016-12-04','2017-01-31',FALSE);
  56.  
  57. INSERT INTO premier(c_id,monthlyFee,isOverdueForMaint)
  58. VALUES('100001',14.95,FALSE),
  59. ('100002',20.00,FALSE),
  60. ('100003',14.95,FALSE),
  61. ('100004',25.00,TRUE),
  62. ('100005',14.95,FALSE);
  63.  
  64. INSERT INTO steady(c_id,loyaltyPoints)
  65. VALUES('100006',20),
  66. ('100007',15),
  67. ('100008',10),
  68. ('100009',30),
  69. ('100010',0);
  70.  
  71. INSERT INTO premier_reward(c_id,rewardType,isUsed)
  72. VALUES('100001','10% disc.',FALSE),
  73. ('100002','10% disc.',FALSE),
  74. ('100003','15% disc.',TRUE),
  75. ('100004','10% disc.',FALSE),
  76. ('100005','10% disc.',TRUE);
  77.  
  78. INSERT INTO steady_reward(c_id,rewardType,isUsed)
  79. VALUES('100006','5% disc.','FALSE'),
  80. ('100007','5% disc.','FALSE'),
  81. ('100008','NONE','FALSE'),
  82. ('100009','5% disc.','TRUE'),
  83. ('100010','NONE','FALSE');
  84.  
  85. INSERT INTO reminder(appointmentDate,appointmentTime,customer)
  86. VALUES('2016-12-16','3:00','100008'),
  87. ('2016-12-16','4:00','100010');
  88.  
  89.  
  90. INSERT INTO employee(e_id,startDate,hourlyWage)
  91. VALUES('900001','1999-01-01',13.50),
  92. ('900002','1999-01-01',13.50),
  93. ('900003','1999-01-01',13.50),
  94. ('900004','1999-01-01',13.50),
  95. ('900005','1999-01-01',13.50),
  96. ('900006','1999-01-01',13.50);
  97.  
  98. INSERT INTO service_tech(e_id)
  99. VALUES('900001'),
  100. ('900003'),
  101. ('900002');
  102.  
  103. INSERT INTO mechanic(e_id)
  104. VALUES('900002'),
  105. ('900004'),
  106. ('900005'),
  107. ('900006');
  108.  
  109. INSERT INTO certifications(e_ID,certType,certPlace)
  110. VALUES('900001','ASE','LBCC'),
  111. ('900001','DMC','LBCC'),
  112. ('900002','ASE','Cerritos'),
  113. ('900003','ASE','Cypress'),
  114. ('900004','ASE','Downey'),
  115. ('900005','ASE','OC'),
  116. ('900006','ASE','LBCC');
  117.  
  118. INSERT INTO skills(skill)
  119. VALUES('hoist op.'),
  120. ('Head Mach'),
  121. ('Ring Rep.'),
  122. ('Brakes'),
  123. ('Trans.'),
  124. ('Engine');
  125.  
  126. INSERT INTO mechanic_skills(e_id,skill)
  127. VALUES('900001','Engine'),
  128. ('900001','Transmission'),
  129. ('900002','Brakes'),
  130. ('900003','hoist op.'),
  131. ('900004','Engine');
  132.  
  133. INSERT INTO mentor_pairing(mentor_id,mentee_id,skillTaught,startDate,stopDate)
  134. VALUES('900001','900005','Engine','2016-01-16','2016-12-01'),
  135. ('900002','900006','Breaks','2015-12-16','2016-12-13');
  136.  
  137. INSERT INTO vehicle(v_id,c_id,make,model,maintInterval,mileage,estYearMile,isOver100k,maintPackage)
  138. VALUES('200000','100001','Toyota','Camry',60000,75000,4500,FALSE, 'Transmission n Rings'),
  139. ('200001','100002','Pontac','Trams Am',45000,140000,35000,TRUE, 'Brakes n Engine'),
  140. ('200002','100003','Honda','Civic',75000,87000,45000,FALSE, 'Brakes n Engine'),
  141. ('200003','100004','Kia','Soul',50000,75000,45000,FALSE, 'hoist op n head mach'),
  142. ('200004','100005','Volks','Jetta',80000,75000,45000,FALSE, 'Brakes n Engine'),
  143. ('200005','100006','Chevy','Silverado',30000,75000,45000,FALSE, 'Brakes n Engine'),
  144. ('200006','100007','Ford','Mustang',70000,75000,45000,FALSE, 'hoist op n head mach'),
  145. ('200007','100008','Ford','Focus',90000,75000,45000,FALSE, 'hoist op n head mach'),
  146. ('200008','100009','Ford','Fiesta',90000,75000,45000,FALSE, 'hoist op n head mach'),
  147. ('200009','100010','Chevy','Malibu',40000,75000,45000,FALSE, 'Transmission n Rings'),
  148. ('200010','100011','Toyota','Camry',60000,75000,45000,FALSE, 'Brakes n Engine'),
  149. ('200011','100012','Honda','Civic',75000,75000,45000,FALSE, 'Brakes n Engine'),
  150. ('200012','100013','Toyota','Camry',60000,75000,45000,FALSE, 'Transmission n Rings'),
  151. ('200013','100014','Toyota','Camry',60000,75000,45000,FALSE, 'Transmission n Rings');
  152.  
  153.  
  154.  
  155. INSERT INTO maintenance_package(packageName)
  156. VALUES('Transmission n Rings'),
  157. ('Brakes n Engine'),
  158. ('hoist op n head mach');
  159.  
  160. INSERT INTO skills_required(skill,mechWorking,service)
  161. VALUES('Trans.','900001','Rebuild'),
  162. ('Engine','900004','Replacement'),
  163. ('Engine','900001','Rebuild'),
  164. ('Engine','900004','Maint.');
  165.  
  166. INSERT INTO maintenance_item(mechWorking,service,price)
  167. VALUES('900001','hoist op',129.00),
  168. ('900004','Head Mach',349.00),
  169. ('900003','Trans.',800.00),
  170. ('900002','Engine',1200.00),
  171. ('900004','Brakes',125.00),
  172. ('900004','Ring Rep.',75.00);
  173.  
  174. INSERT INTO package_item(mechWorking, service, packageName)
  175. VALUES('900003', 'Ring Rep.', 'Transmission n Rings'),
  176. ('900003', 'Engine', 'Brakes n Engine'),
  177. ('900004', 'Trans.', 'Transmission n Rings'),
  178. ('900004', 'Engine', 'Brakes n Engine'),
  179. ('900004', 'Brakes', 'Brakes n Engine'),
  180. ('900001', 'hoist op.', 'hoist op n head mach'),
  181. ('900001', 'Head Mach', 'hoist op n head mach');
  182.  
  183. INSERT INTO package_item(mechWorking, service, packageName)
  184. VALUES('900006', 'Brakes','Brakes n Engine'),
  185. ('900006', 'Engine','Brakes n Engine');
  186.  
  187. INSERT INTO service_line(v_id, mechWorking, timeTaken, service, packageName, servDate)
  188. VALUES('200003', '900001', '00:30:00','hoist op.', 'hoist op n head mach','2014-10-01'),
  189. ('200003', '900001','00:45:00','Head Mach', 'hoist op n head mach','2014-10-01'),
  190. ('200011','900004','03:00:00','Trans.', 'Transmission n Rings','2016-02-20'),
  191. ('200011','900004','01:00:00','Engine', 'Brakes n Engine','2016-02-20'),
  192. ('200011','900004','01:15:00','Brakes', 'Brakes n Engine','2016-02-20'),
  193. ('200000','900003','01:00:00','Ring Rep.', 'Transmission n Rings','2016-01-15'),
  194. ('200000','900003','01:30:00','Engine', 'Brakes n Engine','2016-01-15');
  195. INSERT INTO service_line(v_id, mechWorking, timeTaken, service, packageName, servDate)
  196. VALUES('200009', '900001', '00:30:00', 'Trans.', 'Transmission n Rings', '2016-05-28'),
  197. ('200009', '900001', '01:30:00', 'Ring Rep.', 'Transmission n Rings', '2016-05-28');
  198. INSERT INTO service_line(v_id, mechWorking, timeTaken, service, packageName, servDate)
  199. VALUES('200010', '900006', '02:30:00', 'Brakes', 'Brakes n Engine', '2016-06-02'),
  200. ('200010', '900006', '03:00:00', 'Engine', 'Brakes n Engine', '2016-06-02');
  201.  
  202. INSERT INTO service_visit(v_id,technician,servDate)
  203. VALUES('200003','900001','2014-10-01'),
  204. ('200011','900002','2016-02-20'),
  205. ('200009', '900002', '2016-05-28'),
  206. ('200000','900003','2016-01-15');
  207. INSERT INTO service_visit(v_id,technician,servDate)
  208. VALUES('200009', '900002', '2016-05-28');
  209. INSERT INTO service_visit(v_id,technician,servDate)
  210. VALUES('200010', '900001', '2016-06-02');
  211. INSERT INTO service_visit(v_id,technician,servDate)
  212. VALUES('200007', '900001', '2011-06-02'),
  213. ('200006', '900003','2010-07-14');
  214. INSERT INTO service_visit(v_id,technician,servDate)
  215. VALUES('200010', '900001', '2012-06-02');
  216.  
  217. INSERT INTO skills_required(mechWorking,service,skill)
  218. VALUES('900001','brake change','Brakes');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!