API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
200
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.99 KB | None | 0 0
raw download clone embed print report
  1. /*DriversLicense date*/
  2. INSERT INTO DriversLicense VALUES ('A00000000000000', 'John Doe', '11 Insert Here Street', '1990-01-01', 7.1, 'M', '99999999999', 'Jack Doe');
  3. INSERT INTO DriversLicense VALUES ('A00000000000001', 'Jane Doe', '11 Insert Here Street', '1989-01-01', 5.0, 'F', '99999999999', 'Jack Doe');
  4. INSERT INTO DriversLicense VALUES ('A00000000000002', 'Bob Bill', '56 Quack Street', '1970-04-08', 5.5, 'F', '88888888888', 'Jane Smith');
  5. INSERT INTO DriversLicense VALUES ('A00000000000003', 'John Doe', '11 Insert Here Street', '1990-01-01', 7.1, 'M', '99999999999', 'Jack Doe');
  6. INSERT INTO DriversLicense VALUES ('A00000000000004', 'Anakin Skywalker', '77 Tatooine Drive', '1977-05-25', 6.1, 'M', '1111111111', 'Shmi Skywalker');
  7. INSERT INTO DriversLicense VALUES ('A00000000000005', 'Obi Wan Kenobi', '34 Stewjon Avenue', '1989-12-05', 5.9, 'M', '2222222222', 'Qui Gon Jinn');
  8. INSERT INTO DriversLicense VALUES ('A00000000000006', 'Asajj Ventress', '83 Dathomir Street', '1993-07-18', 5.8, 'F', '3333333333', 'Count Dooku');
  9. INSERT INTO DriversLicense VALUES ('A00000000000007', 'Plo Koon', '15 Dorin Drive', '1998-02-22', 6.1, 'M', '4444444444', 'Ahsoka Tano');
  10. INSERT INTO DriversLicense VALUES ('A00000000000008', 'Aurra Sing', '24 Quack Street', '1983-12-18', 6.0, 'F', '5555555555', 'Cad Bane');
  11. INSERT INTO DriversLicense VALUES ('A00000000000009', 'Jyn Errso', '98 Eadu Drive', '1974-09-20', 5.7, 'F', '6666666666', 'Galen Errso');
  12. INSERT INTO DriversLicense VALUES ('A00000000000010', 'Galen Errso', '98 Eadu Drive', '1968-10-28', 6.0, 'M', '7777777777', 'Jyn Errso');
  13. INSERT INTO DriversLicense VALUES ('A00000000000011', 'Luke Skywalker', '77 Tatooine Drive', '1999-01-05', 5.6, 'M', '8888888881', 'Anakin Skywalker');
  14. INSERT INTO DriversLicense VALUES ('A00000000000012', 'Leia Organa', '5 Alderaan Street', '1979-03-13', 4.9, 'F', '1010101010', 'Bail Organa');
  15. INSERT INTO DriversLicense VALUES ('A00000000000013', 'Maz Kanata', '13 Takodana Avenue', '1965-11-8', 4.0, 'F', '1111111112', 'Han Solo');
  16. INSERT INTO DriversLicense VALUES ('A00000000000014', 'Han Solo', '80 Corellia Drive', '1983-05-10', 5.9, 'M', '1212121212', 'Maz Kanata');
  17. INSERT INTO DriversLicense VALUES ('A00000000000015', 'Hera Syndulla', '66 Quack Street', '1994-09-08', 5.8, 'F', '1313131313', 'Kanan Jarrus');
  18. INSERT INTO DriversLicense VALUES ('A00000000000016', 'Lando Calrissian', '17 Cloud Avenue', '1983-05-19', 5.8, 'M', '1111111112', 'Han Solo');
  19. INSERT INTO DriversLicense VALUES ('A00000000000017', 'Nien Nunb', '19 Sullust Street', '1973-11-01', 5.2, 'M', '1414141414', 'Lando Calrissian');
  20. INSERT INTO DriversLicense VALUES ('A00000000000018', 'Ezra Bridger', '16 Lothal Street', '1996-10-13', 5.7, 'M', '1313131313', 'Kanan Jarrus');
  21. INSERT INTO DriversLicense VALUES ('A00000000000019', 'Thrawn Thras', '14 Death Star Street', '1988-01-18', 7.3, 'M', '8888888881', 'Anakin Skywalker');
  22. COMMIT;
  23.  
  24. /*LicenseClass Data*/
  25. INSERT INTO LicenseClass VALUES('A');
  26. INSERT INTO LicenseClass VALUES('B');
  27. INSERT INTO LicenseClass VALUES('C');
  28. INSERT INTO LicenseClass VALUES('D');
  29. INSERT INTO LicenseClass VALUES('E');
  30. INSERT INTO LicenseClass VALUES('F');
  31. INSERT INTO LicenseClass VALUES('G');
  32. INSERT INTO LicenseClass VALUES('M');
  33. COMMIT;
  34.  
  35. /*VehicleCategory Data*/
  36. INSERT INTO VehicleCategory VALUES ('0000000000','Tractor-Trailer',10000.0,60.0,18,18);
  37. INSERT INTO VehicleCategory VALUES ('0000000001','Regular Bus,with design capacity more than 24 passenger ',4600.0,50.0,4,4);
  38. INSERT INTO VehicleCategory VALUES ('0000000002','Any truck or motor vehicle combination exceeding 11000kg with towed vehicle<4600kg',15600.0,50.0,4,4);
  39. INSERT INTO VehicleCategory VALUES ('0000000003','School purpose bus with max 24-passenger capacity',4600.0,50.0,4,4);
  40. INSERT INTO VehicleCategory VALUES ('0000000004','Regular bus with max 24-passenger capacity and ambulances',4600.0,50.0,4,4);
  41. INSERT INTO VehicleCategory VALUES ('0000000005','Car, van, or small truck ',11000.0,10.0,4,4);
  42. INSERT INTO VehicleCategory VALUES ('0000000006','Motorcycle',2500.0,5.0,2,2);
  43. INSERT INTO VehicleCategory VALUES ('0000000007','3 Wheeled Motorcycle', 2500.0,5.0,3,3);
  44. INSERT INTO VehicleCategory VALUES ('0000000008','School-purpose Bus,with design capacity more than 24 passenger ',4600.0,50.0,4,4);
  45. COMMIT;
  46.  
  47. /*Model Data*/
  48. INSERT INTO Model VALUES ('Tesla', 2014,'Model S', '0000000005', 2100, 16.325, 4);
  49. INSERT INTO Model VALUES ('Tesla', 2015,'Model X', '0000000005', 2400, 16.525, 4);
  50. INSERT INTO Model VALUES ('Tesla', 2017,'Model 3', '0000000005', 2200, 15.4, 4);
  51. INSERT INTO Model VALUES ('Peterbilt', 2017,'Model 579', '0000000000', 7000, 48, 5);
  52. INSERT INTO Model VALUES ('Peterbilt', 2015,'Model 325', '0000000000', 3100, 30, 3 );
  53. INSERT INTO Model VALUES ('New Flyer', 2015,'Xcelsior', '0000000001', 3500, 35, 3);
  54. INSERT INTO Model VALUES ('Blue Bus', 2014,'TR Series', '0000000003', 3200, 32, 3);
  55. INSERT INTO Model VALUES ('IC Buses', 2015,'CE Series', '0000000003', 3258, 33, 3);
  56. INSERT INTO Model VALUES ('IC Buses', 2016,'RE Series', '0000000003', 3400, 34, 3);
  57. INSERT INTO Model VALUES ('IC Buses', 2014,'T Series', '0000000004', 2600, 28, 2);
  58. INSERT INTO Model VALUES ('EBus', 2015,'GH Series', '0000000004', 2500, 25, 2);
  59. INSERT INTO Model VALUES ('Ducati', 2015,'Scramble classic', '0000000006', 181, 7, 2);
  60. INSERT INTO Model VALUES ('Ducati', 2014,'Hyperstrada', '0000000006', 204, 7, 2);
  61. INSERT INTO Model VALUES ('Ford', 2017,'Fiesta', '0000000005', 1800, 13, 4);
  62. INSERT INTO Model VALUES ('Mercedes', 2017, 'Maybach S550 4Matic', '0000000005', 2267, 17.8, 4);
  63. INSERT INTO Model VALUES ('Maserati', 2016,'Levante', '0000000005', 2110, 16.4, 4);
  64. INSERT INTO Model VALUES ('Daimler', 2015,'Setra', '0000000001', 3000, 35, 3);
  65. INSERT INTO Model VALUES ('Jaguar', 2016,'F-Type', '0000000005', 2000, 14.66, 4);
  66. INSERT INTO Model VALUES ('Toyota', 2017,'Corolla', '0000000005', 2100, 14.25, 4);
  67. INSERT INTO Model VALUES ('Hyundai', 2016,'Santa fe', '0000000005', 2001, 14.75, 4);
  68. COMMIT;
  69.  
  70. /*Vehicle Data*/
  71.  
  72. INSERT INTO Vehicle VALUES('00000000000000000',NULL,'Tesla',2014,'Model S');
  73. INSERT INTO Vehicle VALUES('00000000000000001','A00000000000003','Tesla',2014,'Model S');
  74. INSERT INTO Vehicle VALUES('00000000000000002',NULL,'Tesla',2014,'Model S');
  75. INSERT INTO Vehicle VALUES('00000000000000003',NULL,'Tesla',2014,'Model S');
  76. INSERT INTO Vehicle VALUES('00000000000000004',NULL,'Tesla',2015,'Model X');
  77. INSERT INTO Vehicle VALUES('00000000000000005',NULL,'Tesla',2017,'Model 3');
  78. INSERT INTO Vehicle VALUES('00000000000000006','A00000000000002','Peterbilt',2017,'Model 579');
  79. INSERT INTO Vehicle VALUES('00000000000000007',NULL,'Peterbilt',2017,'Model 579');
  80. INSERT INTO Vehicle VALUES('00000000000000008',NULL,'Peterbilt',2015,'Model 325');
  81. INSERT INTO Vehicle VALUES('00000000000000009','A00000000000003','New Flyer',2015,'Xcelsior');
  82. INSERT INTO Vehicle VALUES('00000000000000010',NULL,'Blue Bus',2014,'TR Series');
  83. INSERT INTO Vehicle VALUES('00000000000000011',NULL,'Blue Bus',2014,'TR Series');
  84. INSERT INTO Vehicle VALUES('00000000000000012','A00000000000015','Blue Bus',2014,'TR Series');
  85. INSERT INTO Vehicle VALUES('00000000000000013',NULL,'IC Buses',2015,'CE Series');
  86. INSERT INTO Vehicle VALUES('00000000000000014','A00000000000014','IC Buses',2015,'CE Series');
  87. INSERT INTO Vehicle VALUES('00000000000000015',NULL,'IC Buses',2016,'RE Series');
  88. INSERT INTO Vehicle VALUES('00000000000000016',NULL,'IC Buses',2014,'T Series');
  89. INSERT INTO Vehicle VALUES('00000000000000017',NULL,'Ducati',2015,'Scramble classic');
  90. INSERT INTO Vehicle VALUES('00000000000000018',NULL,'Ducati',2014,'Hyperstrada');
  91. INSERT INTO Vehicle VALUES('00000000000000019','A00000000000017','Ford',2017,'Fiesta');
  92. INSERT INTO Vehicle VALUES('00000000000000020',NULL,'Mercedes',2017,'Maybach S550 4Matic');
  93. INSERT INTO Vehicle VALUES('00000000000000021',NULL,'Mercedes',2017,'Maybach S550 4Matic');
  94. INSERT INTO Vehicle VALUES('00000000000000030','A00000000000019','Mercedes',2017,'Maybach S550 4Matic');
  95. INSERT INTO Vehicle VALUES('00000000000000031',NULL,'Maserati',2016,'Levante');
  96. INSERT INTO Vehicle VALUES('00000000000000022',NULL,'Maserati',2016,'Levante');
  97. INSERT INTO Vehicle VALUES('00000000000000023',NULL,'Daimler',2015,'Setra');
  98. INSERT INTO Vehicle VALUES('00000000000000024',NULL,'Daimler',2015,'Setra');
  99. INSERT INTO Vehicle VALUES('00000000000000025',NULL,'Jaguar',2016,'F-Type');
  100. INSERT INTO Vehicle VALUES('00000000000000026',NULL,'Jaguar',2016,'F-Type');
  101. INSERT INTO Vehicle VALUES('00000000000000027',NULL,'Jaguar',2016,'F-Type');
  102. INSERT INTO Vehicle VALUES('00000000000000028',NULL,'Toyota',2017,'Corolla');
  103. INSERT INTO Vehicle VALUES('00000000000000029',NULL,'Hyundai',2016,'Santa fe');
  104. COMMIT;
  105.  
  106. /*LicensePlate*/
  107. INSERT INTO LicensePlate VALUES('AAAA111','2010-01-01','2005-01-01','A00000000000003');
  108. INSERT INTO LicensePlate VALUES('AAAA112','2021-01-01','2016-01-01','A00000000000001');
  109. INSERT INTO LicensePlate VALUES('AAAA113','2022-05-02','2016-05-02','A00000000000001');
  110. INSERT INTO LicensePlate VALUES('AAAA114','2018-01-01','2013-01-01','A00000000000002');
  111. INSERT INTO LicensePlate VALUES('AAAA115',NULL,NULL,NULL);
  112. INSERT INTO LicensePlate VALUES('AAAA116',NULL,NULL,NULL);
  113. INSERT INTO LicensePlate VALUES('AAAA117',NULL,NULL,NULL);
  114. INSERT INTO LicensePlate VALUES('AAAA118','2012-03-01','2017-03-01','A00000000000003');
  115. INSERT INTO LicensePlate VALUES('AAAA119',NULL,NULL,NULL);
  116. INSERT INTO LicensePlate VALUES('AAAA120',NULL,NULL,NULL);
  117. INSERT INTO LicensePlate VALUES('AB',NULL,NULL,NULL);
  118. INSERT INTO LicensePlate VALUES('IAMBOB','2020-09-09','2015-09-09','A00000000000002');
  119. INSERT INTO LicensePlate VALUES('OP121P','2020-08-01','2015-08-01','A00000000000019');
  120. INSERT INTO LicensePlate VALUES('AAAA121',NULL,NULL,NULL);
  121. INSERT INTO LicensePlate VALUES('AAAA122',NULL,NULL,NULL);
  122. INSERT INTO LicensePlate VALUES('AAAA123',NULL,NULL,NULL);
  123. INSERT INTO LicensePlate VALUES('AAAA124',NULL,NULL,NULL);
  124. INSERT INTO LicensePlate VALUES('AAAA125',NULL,NULL,NULL);
  125. INSERT INTO LicensePlate VALUES('AAAA126',NULL,NULL,NULL);
  126. INSERT INTO LicensePlate VALUES('AAAA127',NULL,NULL,NULL);
  127. INSERT INTO LicensePlate VALUES('$$$$$',NULL,NULL,NULL);
  128. INSERT INTO LicensePlate VALUES('AAAA129',NULL,NULL,NULL);
  129. INSERT INTO LicensePlate VALUES('AAAA130',NULL,NULL,NULL);
  130. INSERT INTO LicensePlate VALUES('AAAA131',NULL,NULL,NULL);
  131. INSERT INTO LicensePlate VALUES('3P32',NULL,NULL,NULL);
  132. INSERT INTO LicensePlate VALUES('AAAA132',NULL,NULL,NULL);
  133. INSERT INTO LicensePlate VALUES('AAAA133',NULL,NULL,NULL);
  134. INSERT INTO LicensePlate VALUES('AAAA134',NULL,NULL,NULL);
  135. INSERT INTO LicensePlate VALUES('AAAA135',NULL,NULL,NULL);
  136. INSERT INTO LicensePlate VALUES('AAAA136',NULL,NULL,NULL);
  137. INSERT INTO LicensePlate VALUES('AAAA137',NULL,NULL,NULL);
  138. INSERT INTO LicensePlate VALUES('AAAA138',NULL,NULL,NULL);
  139. INSERT INTO LicensePlate VALUES('AAAA139','2020-08-01','2015-08-01','A00000000000017');
  140. INSERT INTO LicensePlate VALUES('AAAA140','2020-08-01','2015-08-01','A00000000000014');
  141. INSERT INTO LicensePlate VALUES('AAAA141','2020-08-01','2015-08-01','A00000000000015');
  142. COMMIT;
  143.  
  144. /*BelongsTo Data*/
  145.  
  146. INSERT INTO BelongsTo VALUES('00000000000000001','AAAA112');
  147. INSERT INTO BelongsTo VALUES('00000000000000006','AAAA114');
  148. INSERT INTO BelongsTo VALUES('00000000000000019','OP121P');
  149. INSERT INTO BelongsTo VALUES('00000000000000009','AAAA118');
  150. INSERT INTO BelongsTo VALUES('00000000000000014','AAAA114');
  151.  
  152.  
  153. /*FarmPlate Data*/
  154. INSERT INTO FarmPlate VALUES('AAAA111','00000000000000000000');
  155. INSERT INTO FarmPlate VALUES('AAAA115','00000000000000000001');
  156. INSERT INTO FarmPlate VALUES('AAAA118','00000000000000000002');
  157. INSERT INTO FarmPlate VALUES('$$$$$','00000000000000000003');
  158. INSERT INTO FarmPlate VALUES('3P32','00000000000000000004');
  159. INSERT INTO FarmPlate VALUES('AAAA129','00000000000000000004');
  160. INSERT INTO FarmPlate VALUES('AAAA114','00000000000000000005');
  161. COMMIT;
  162.  
  163. /*Classes Data*/
  164. INSERT INTO Classes VALUES('A00000000000000','G',NULL,'2017-01-01','2022-01-01');
  165. INSERT INTO Classes VALUES('A00000000000000','M',1,'2016-01-01','2021-01-01');
  166. INSERT INTO Classes VALUES('A00000000000001','M',2,'2016-01-01','2021-01-01');
  167. INSERT INTO Classes VALUES('A00000000000002','G',NULL,'2017-01-01','2022-01-01');
  168. INSERT INTO Classes VALUES('A00000000000002','A',NULL,'2017-05-06','2022-05-06');
  169. INSERT INTO Classes VALUES('A00000000000003','G',NULL,'2010-06-01','2015-06-01');
  170. INSERT INTO Classes VALUES('A00000000000004','G',NULL,'2017-07-25','2022-07-25');
  171. INSERT INTO Classes VALUES('A00000000000004','A',NULL,'2010-02-20','2015-02-20');
  172. INSERT INTO Classes VALUES('A00000000000005','G',2,'2014-10-21','2019-10-21');
  173. INSERT INTO Classes VALUES('A00000000000005','B',NULL,'2017-01-01','2022-01-01');
  174. INSERT INTO Classes VALUES('A00000000000006','G',NULL,'2017-01-01','2022-01-01');
  175. INSERT INTO Classes VALUES('A00000000000006','M',NULL,'2017-01-01','2022-01-01');
  176. INSERT INTO Classes VALUES('A00000000000006','F',NULL,'2017-01-01','2022-01-01');
  177. INSERT INTO Classes VALUES('A00000000000007','G',NULL,'2017-01-01','2022-01-01');
  178. INSERT INTO Classes VALUES('A00000000000008','M',NULL,'2017-01-01','2022-01-01');
  179. INSERT INTO Classes VALUES('A00000000000009','G',NULL,'2017-01-01','2022-01-01');
  180. INSERT INTO Classes VALUES('A00000000000009','C',NULL,'2017-01-01','2022-01-01');
  181. INSERT INTO Classes VALUES('A00000000000009','E',NULL,'2017-01-01','2022-01-01');
  182. INSERT INTO Classes VALUES('A00000000000010','G',NULL,'2017-01-01','2022-01-01');
  183. INSERT INTO Classes VALUES('A00000000000010','D',NULL,'2017-01-01','2022-01-01');
  184. INSERT INTO Classes VALUES('A00000000000011','G',NULL,'2017-01-01','2022-01-01');
  185. INSERT INTO Classes VALUES('A00000000000011','F',NULL,'2017-01-01','2022-01-01');
  186. INSERT INTO Classes VALUES('A00000000000012','G',2,'2017-01-01','2022-01-01');
  187. INSERT INTO Classes VALUES('A00000000000013','G',1,'2017-01-01','2022-01-01');
  188. INSERT INTO Classes VALUES('A00000000000014','G',1,'2017-01-01','2022-01-01');
  189. INSERT INTO Classes VALUES('A00000000000015','G',NULL,'2017-01-01','2022-01-01');
  190. INSERT INTO Classes VALUES('A00000000000016','G',NULL,'2017-01-01','2022-01-01');
  191. INSERT INTO Classes VALUES('A00000000000017','G',NULL,'2017-01-01','2022-01-01');
  192. INSERT INTO Classes VALUES('A00000000000018','G',NULL,'2017-01-01','2022-01-01');
  193. INSERT INTO Classes VALUES('A00000000000019','G',NULL,'2017-01-01','2022-01-01');
  194. COMMIT;
  195.  
  196. /*AllowedToBeDriven Data*/
  197. INSERT INTO AllowedToBeDriven VALUES('A','0000000000');
  198. INSERT INTO AllowedToBeDriven VALUES('A','0000000002');
  199. INSERT INTO AllowedToBeDriven VALUES('A','0000000005');
  200. INSERT INTO AllowedToBeDriven VALUES('B','0000000008');
  201. INSERT INTO AllowedToBeDriven VALUES('B','0000000001');
  202. INSERT INTO AllowedToBeDriven VALUES('B','0000000002');
  203. INSERT INTO AllowedToBeDriven VALUES('B','0000000003');
  204. INSERT INTO AllowedToBeDriven VALUES('B','0000000004');
  205. INSERT INTO AllowedToBeDriven VALUES('B','0000000005');
  206. INSERT INTO AllowedToBeDriven VALUES('C','0000000001');
  207. INSERT INTO AllowedToBeDriven VALUES('C','0000000002');
  208. INSERT INTO AllowedToBeDriven VALUES('C','0000000004');
  209. INSERT INTO AllowedToBeDriven VALUES('C','0000000005');
  210. INSERT INTO AllowedToBeDriven VALUES('D','0000000002');
  211. INSERT INTO AllowedToBeDriven VALUES('D','0000000005');
  212. INSERT INTO AllowedToBeDriven VALUES('E','0000000003');
  213. INSERT INTO AllowedToBeDriven VALUES('E','0000000004');
  214. INSERT INTO AllowedToBeDriven VALUES('E','0000000005');
  215. INSERT INTO AllowedToBeDriven VALUES('F','0000000004');
  216. INSERT INTO AllowedToBeDriven VALUES('F','0000000005');
  217. INSERT INTO AllowedToBeDriven VALUES('G','0000000005');
  218. INSERT INTO AllowedToBeDriven VALUES('M','0000000006');
  219. INSERT INTO AllowedToBeDriven VALUES('M','0000000007');
  220. COMMIT;
  221.  
  222. /*DealerPlate Data*/
  223. INSERT INTO DealerPlate VALUES('AAAA137','Glactic Empire','1231231666');
  224. INSERT INTO DealerPlate VALUES('AAAA138','First Order','1551551668');
  225. INSERT INTO DealerPlate VALUES('AAAA139','Sith','1237771666');
  226. INSERT INTO DealerPlate VALUES('AAAA140','Jedi','12315436666');
  227. INSERT INTO DealerPlate VALUES('AAAA141','The Max Rebo Band','12312316222');
  228. INSERT INTO DealerPlate VALUES('AAAA133','xX_Kanjiklub_Xx123','12333216222');
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!