API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 4th, 2017
808
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 71.79 KB | None | 0 0
raw download clone embed print report
  1. -- Drop
  2. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'MACHINISTRULE')
  3. DROP TABLE MACHINISTRULE;
  4. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'MACHINIST')
  5. DROP TABLE MACHINIST;
  6. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'CLEANER')
  7. DROP TABLE CLEANER;
  8. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'MANAGER')
  9. DROP TABLE MANAGER;
  10. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'TECHNICIAN')
  11. DROP TABLE TECHNICIAN;
  12. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'EMPLOYEE')
  13. DROP TABLE EMPLOYEE;
  14. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'REPAIRRULE')
  15. DROP TABLE REPAIRRULE;
  16. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'CLEANINGRULE')
  17. DROP TABLE CLEANINGRULE;
  18. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'REPAIR')
  19. DROP TABLE REPAIR;
  20. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'CLEANING')
  21. DROP TABLE CLEANING;
  22. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'TRAM')
  23. DROP TABLE TRAM;
  24. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'TRAMTYPE')
  25. DROP TABLE TRAMTYPE;
  26. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'SECTOR')
  27. DROP TABLE SECTOR;
  28. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'TRACK')
  29. DROP TABLE TRACK;
  30. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'LOGIN')
  31. DROP TABLE LOGIN;
  32. IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'DEPOT')
  33. DROP TABLE DEPOT;
  34.  
  35. -- Create
  36. CREATE TABLE DEPOT
  37. (
  38. DepotID int IDENTITY(1,1),
  39. Name varchar(255) UNIQUE NOT null,
  40. Adress varchar(255) UNIQUE NOT null,
  41. Location varchar(255) UNIQUE NOT null,
  42. CONSTRAINT PK_depot PRIMARY KEY (DepotID)
  43. );
  44. CREATE TABLE LOGIN
  45. (
  46. LoginID int IDENTITY(1,1),
  47. Username varchar(255) UNIQUE NOT null,
  48. Password varchar(255) NOT null,
  49. CONSTRAINT PK_Log PRIMARY KEY (LoginID)
  50. );
  51. CREATE TABLE TRACK
  52. (
  53. Tracknumber int NOT null UNIQUE,
  54. DepotID int NOT null,
  55. Length int NOT null,
  56. Linenumber varchar(255),
  57. CONSTRAINT PK_Track PRIMARY KEY (Tracknumber),
  58. CONSTRAINT FK_Dep FOREIGN KEY (DepotID) REFERENCES DEPOT(DepotID) ON DELETE CASCADE
  59. );
  60. CREATE TABLE TRAMTYPE
  61. (
  62. Tramtype varchar(255) NOT null UNIQUE,
  63. Length int NOT null,
  64. CONSTRAINT PK_TramType PRIMARY KEY (Tramtype)
  65. );
  66. CREATE TABLE TRAM
  67. (
  68. TramNumber int UNIQUE,
  69. Tramtype varchar(255) NOT null,
  70. Railbound bit NOT null,
  71. Controller bit NOT null,
  72. Linenumber varchar(255) NOT null,
  73. Status varchar(255) NOT null,
  74. RFIDtag varchar(255) NOT null,
  75. LastBigClean date,
  76. LastSmallClean date,
  77. LastSmallService date,
  78. LastBigService date,
  79. Entry time,
  80. Depart time,
  81. CONSTRAINT PK_Tram PRIMARY KEY (TramNumber),
  82. CONSTRAINT FK_TramType FOREIGN KEY (Tramtype) REFERENCES TRAMTYPE(Tramtype) ON DELETE CASCADE
  83. );
  84. CREATE TABLE SECTOR
  85. (
  86. SectorID int IDENTITY(1,1),
  87. Sectornumber int NOT null,
  88. Tracknumber int NOT null,
  89. RGB varchar(255),
  90. Reservation int,
  91. Blocked bit DEFAULT(0),
  92. Tramnumber int,
  93. CONSTRAINT PK_Sec PRIMARY KEY (SectorID),
  94. CONSTRAINT FK_Curtram FOREIGN KEY (Tramnumber) REFERENCES TRAM(TramNumber) ON DELETE CASCADE,
  95. CONSTRAINT FK_Track FOREIGN KEY (Tracknumber) REFERENCES TRACK(Tracknumber) ON DELETE CASCADE
  96. );
  97. CREATE TABLE CLEANING
  98. (
  99. CleaningID int IDENTITY(1,1),
  100. CleanDate date NOT null,
  101. CleanType varchar(255),
  102. CONSTRAINT PK_Clean PRIMARY KEY (CleaningID),
  103. CONSTRAINT CK_CleanType CHECK (CleanType IN ('SmallCleanService', 'BigCleanService'))
  104. );
  105. CREATE TABLE REPAIR
  106. (
  107. RepairID int IDENTITY(1,1),
  108. RepairDate date NOT null,
  109. Comment varchar(255) NOT null,
  110. ServiceType varchar(255),
  111. CONSTRAINT PK_RepairID PRIMARY KEY (RepairID),
  112. CONSTRAINT CK_ServiceType CHECK (ServiceType IN ('SmallMaintanceService', 'BigMaintanceService'))
  113. );
  114. CREATE TABLE CLEANINGRULE
  115. (
  116. TramNumber int,
  117. CleaningID int,
  118. CONSTRAINT FK_CleaningTram FOREIGN KEY (TramNumber) REFERENCES TRAM(TramNumber) ON DELETE CASCADE,
  119. CONSTRAINT FK_Cleaning FOREIGN KEY (CleaningID) REFERENCES CLEANING(CleaningID) ON DELETE CASCADE,
  120. CONSTRAINT PK_TramCleaning PRIMARY KEY(TramNumber,CleaningID)
  121. );
  122. CREATE TABLE REPAIRRULE
  123. (
  124. TramNumber int,
  125. RepairID int,
  126. CONSTRAINT FK_RepairTram FOREIGN KEY (TramNumber) REFERENCES TRAM(TramNumber) ON DELETE CASCADE,
  127. CONSTRAINT FK_Repair FOREIGN KEY (RepairID) REFERENCES REPAIR(RepairID) ON DELETE CASCADE,
  128. CONSTRAINT PK_TramRepair PRIMARY KEY(TramNumber,RepairID)
  129. );
  130. CREATE TABLE EMPLOYEE
  131. (
  132. EmployeeID int IDENTITY(1,1),
  133. DepotID int NOT null,
  134. Firstname varchar(255) NOT null,
  135. Lastname varchar(255) NOT null,
  136. "Function" varchar(255) NOT null,
  137. Adress varchar(255) NOT null,
  138. Location varchar(255) NOT null,
  139. Email varchar(255) NOT null UNIQUE,
  140. CONSTRAINT PK_Emp PRIMARY KEY (EmployeeID),
  141. CONSTRAINT FK_DepEmp FOREIGN KEY (DepotID) REFERENCES DEPOT(DepotID) ON DELETE CASCADE,
  142. CONSTRAINT FK_LoginID FOREIGN KEY (EmployeeID) REFERENCES LOGIN(LoginID) ON DELETE NO ACTION,
  143. CONSTRAINT CK_EmployeeFunction CHECK ("Function" IN ('Cleaner', 'DepotManager', 'Manager', 'Machinist', 'Technician'))
  144. );
  145. CREATE TABLE TECHNICIAN
  146. (
  147. TechnicianID int IDENTITY(1,1),
  148. RepairID int,
  149. EmployeeID int NOT null,
  150. CONSTRAINT PK_Tech PRIMARY KEY (TechnicianID),
  151. CONSTRAINT FK_RepTech FOREIGN KEY (RepairID) REFERENCES REPAIR(RepairID) ON DELETE CASCADE,
  152. CONSTRAINT FK_EmpTech FOREIGN KEY (EmployeeID) REFERENCES EMPLOYEE(EmployeeID) ON DELETE CASCADE
  153. );
  154. CREATE TABLE CLEANER
  155. (
  156. CleanerID int IDENTITY(1,1),
  157. CleaningID int,
  158. EmployeeID int NOT null,
  159. HeadCleaner bit NOT null,
  160. CONSTRAINT PK_Cleaner PRIMARY KEY (CleanerID),
  161. CONSTRAINT FK_CleanCleaner FOREIGN KEY (CleaningID) REFERENCES CLEANING(CleaningID) ON DELETE CASCADE,
  162. CONSTRAINT FK_EmpClean FOREIGN KEY (EmployeeID) REFERENCES EMPLOYEE(EmployeeID) ON DELETE CASCADE
  163. );
  164. CREATE TABLE MANAGER
  165. (
  166. ManagerID int IDENTITY(1,1),
  167. DepotID int NOT null,
  168. EmployeeID int NOT null,
  169. Depotmanager bit NOT null,
  170. CONSTRAINT PK_Manager PRIMARY KEY (ManagerID),
  171. CONSTRAINT FK_DepMan FOREIGN KEY (DepotID) REFERENCES DEPOT(DepotID) ON DELETE CASCADE,
  172. CONSTRAINT FK_EmpMan FOREIGN KEY (EmployeeID) REFERENCES EMPLOYEE(EmployeeID) ON DELETE NO ACTION
  173. );
  174. CREATE TABLE MACHINIST
  175. (
  176. MachinistID int IDENTITY(1,1),
  177. EmployeeID int,
  178. CONSTRAINT PK_Machinist PRIMARY KEY (MachinistID),
  179. CONSTRAINT FK_EmpMach FOREIGN KEY (EmployeeID) REFERENCES EMPLOYEE(EmployeeID) ON DELETE CASCADE
  180. );
  181. CREATE TABLE MACHINISTRULE
  182. (
  183. MachinistRuleID int IDENTITY(1,1),
  184. MachinistID int,
  185. TramNumber int,
  186. CONSTRAINT PK_MachinistRule PRIMARY KEY (MachinistRuleID),
  187. CONSTRAINT FK_EmpMachRule FOREIGN KEY (MachinistID) REFERENCES MACHINIST(MachinistID) ON DELETE CASCADE,
  188. CONSTRAINT FK_MachTram FOREIGN KEY (TramNumber) REFERENCES TRAM(TramNumber) ON DELETE NO ACTION
  189. );
  190.  
  191. -- Depot
  192. insert into DEPOT (Name, Adress, Location) values ('Remise Havenstraat', 'Havenstraat', 'Amsterdam');
  193.  
  194. -- Login - Data
  195. insert into LOGIN (Username, Password) values ('manager', 'test');
  196. insert into LOGIN (Username, Password) values ('depotmanager', 'test');
  197. insert into LOGIN (Username, Password) values ('technician', 'test');
  198. insert into LOGIN (Username, Password) values ('cleaner', 'test');
  199. insert into LOGIN (Username, Password) values ('machinist', 'test');
  200. -- Login - Generated
  201. insert into LOGIN (Username, Password) values ('amurray0', 'dHglhiG');
  202. insert into LOGIN (Username, Password) values ('bward1', 'YKaiTcXh');
  203. insert into LOGIN (Username, Password) values ('lrobertson2', 'LGOkvWyMpH');
  204. insert into LOGIN (Username, Password) values ('rburns3', 'mbvBf3');
  205. insert into LOGIN (Username, Password) values ('hhawkins4', 'XcG1j86Gtp6');
  206. insert into LOGIN (Username, Password) values ('gromero5', '6BQjoPAz7');
  207. insert into LOGIN (Username, Password) values ('jpeters6', 'o49ySOXetRZ');
  208. insert into LOGIN (Username, Password) values ('fhoward7', 'kfCamZjJo0');
  209. insert into LOGIN (Username, Password) values ('sburton8', 'CdLeskhqW');
  210. insert into LOGIN (Username, Password) values ('vlarson9', 'CDPLrUTsMoVq');
  211. insert into LOGIN (Username, Password) values ('thansena', 'YtmUmjDyYV2u');
  212. insert into LOGIN (Username, Password) values ('dspencerb', 'uhcISYkc');
  213. insert into LOGIN (Username, Password) values ('tpetersonc', '8TkzIx2JXHSL');
  214. insert into LOGIN (Username, Password) values ('jbennettd', 'LAGSHKYnRt');
  215. insert into LOGIN (Username, Password) values ('darnolde', 'HkMk2lOf2v1');
  216. insert into LOGIN (Username, Password) values ('ehuntf', 'uYXibRGs');
  217. insert into LOGIN (Username, Password) values ('wmorrisong', 'xcuVlsi');
  218. insert into LOGIN (Username, Password) values ('cperryh', '2D3PWKs');
  219. insert into LOGIN (Username, Password) values ('jharti', 'tQMQAg');
  220. insert into LOGIN (Username, Password) values ('lhansonj', 'AF2xvUabt');
  221. insert into LOGIN (Username, Password) values ('bsimmonsk', 'tmHyeO');
  222. insert into LOGIN (Username, Password) values ('eburnsl', 'UsNOivWJH');
  223. insert into LOGIN (Username, Password) values ('jhowellm', 'WaHrpgnqovm');
  224. insert into LOGIN (Username, Password) values ('nharveyn', 'gwIQPbcPtOv');
  225. insert into LOGIN (Username, Password) values ('cbradleyo', 'RzwmDDAi');
  226. insert into LOGIN (Username, Password) values ('jsanchezp', 'yCIdhp7');
  227. insert into LOGIN (Username, Password) values ('ehernandezq', 'PP4tS9UQ2');
  228. insert into LOGIN (Username, Password) values ('rbellr', 'Gjy8Cb57');
  229. insert into LOGIN (Username, Password) values ('rchapmans', '31rBciS3');
  230. insert into LOGIN (Username, Password) values ('smooret', 'YoOZMn');
  231. insert into LOGIN (Username, Password) values ('swilliamsonu', 'aKmLmZwdAjn');
  232. insert into LOGIN (Username, Password) values ('gporterv', 'mPZzA2mdwex');
  233. insert into LOGIN (Username, Password) values ('kgutierrezw', 'Fh48lbn');
  234. insert into LOGIN (Username, Password) values ('rpetersonx', 'yvSTpBbI');
  235. insert into LOGIN (Username, Password) values ('klongy', 'GoOvjzajm');
  236. insert into LOGIN (Username, Password) values ('rsimmonsz', 'Ac8zUhkP');
  237. insert into LOGIN (Username, Password) values ('agarrett10', 'TOvfcOueKkO');
  238. insert into LOGIN (Username, Password) values ('sjackson11', 'U11Abdfeniv');
  239. insert into LOGIN (Username, Password) values ('jmurphy12', 'ZiZsCkdg');
  240. insert into LOGIN (Username, Password) values ('tfrazier13', 'wG7zwikolN');
  241. insert into LOGIN (Username, Password) values ('jbailey14', 'GL35iJyU59');
  242. insert into LOGIN (Username, Password) values ('egilbert15', '11BZNMkNyxGb');
  243. insert into LOGIN (Username, Password) values ('ddiaz16', 'QzWlWZ');
  244. insert into LOGIN (Username, Password) values ('agutierrez17', 'HZpE3mNp5mL');
  245. insert into LOGIN (Username, Password) values ('falvarez18', 'm1YR9MbSKqC');
  246.  
  247. -- Data
  248. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('38','1','4','2');
  249. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('37','1','4','5');
  250. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('36','1','4','1');
  251. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('35','1','4','16/24');
  252. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('34','1','4','2');
  253. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('33','1','4','16/24');
  254. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('32','1','4','10');
  255. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('31','1','3',null);
  256. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('30','1','3','16/24');
  257. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('40','1','7',null);
  258. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('41','1','4','10');
  259. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('42','1','4','55');
  260. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('43','1','4','1');
  261. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('44','1','4','13');
  262. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('45','1','9','17');
  263. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('58','1','5',null);
  264. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('57','1','8','16/24');
  265. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('56','1','8','5');
  266. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('55','1','8','2');
  267. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('54','1','7','5');
  268. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('53','1','7','13');
  269. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('52','1','7','17');
  270. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('51','1','6',null);
  271. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('64','1','5',null);
  272. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('63','1','4','2');
  273. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('62','1','3',null);
  274. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('61','1','3',null);
  275. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('74','1','5',null);
  276. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('75','1','4',null);
  277. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('76','1','5',null);
  278. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('77','1','5',null);
  279. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('12','1','1',null);
  280. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('13','1','1',null);
  281. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('14','1','1',null);
  282. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('15','1','1',null);
  283. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('16','1','1',null);
  284. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('17','1','1',null);
  285. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('18','1','1',null);
  286. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('19','1','1',null);
  287. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('20','1','1',null);
  288. insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('21','1','1',null);
  289.  
  290. -- Sectors
  291. insert into SECTOR (Sectornumber, Tracknumber) values ('1', '38');
  292. insert into SECTOR (Sectornumber, Tracknumber) values ('2', '38');
  293. insert into SECTOR (Sectornumber, Tracknumber) values ('3', '38');
  294. insert into SECTOR (Sectornumber, Tracknumber) values ('4', '38');
  295. insert into SECTOR (Sectornumber, Tracknumber) values ('1', '37');
  296. insert into SECTOR (Sectornumber, Tracknumber) values ('2', '37');
  297. insert into SECTOR (Sectornumber, Tracknumber) values ('3', '37');
  298. insert into SECTOR (Sectornumber, Tracknumber) values ('4', '37');
  299. insert into SECTOR (Sectornumber, Tracknumber) values ('1', '36');
  300. insert into SECTOR (Sectornumber, Tracknumber) values ('2', '36');
  301. insert into SECTOR (Sectornumber, Tracknumber) values ('3', '36');
  302. insert into SECTOR (Sectornumber, Tracknumber) values ('4', '36');
  303. insert into SECTOR (Sectornumber, Tracknumber) values ('1', '35');
  304. insert into SECTOR (Sectornumber, Tracknumber) values ('2', '35');
  305. insert into SECTOR (Sectornumber, Tracknumber) values ('3', '35');
  306. insert into SECTOR (Sectornumber, Tracknumber) values ('4', '35');
  307. insert into SECTOR (Sectornumber, Tracknumber) values (1, '34');
  308. insert into SECTOR (Sectornumber, Tracknumber) values (2, '34');
  309. insert into SECTOR (Sectornumber, Tracknumber) values (3, '34');
  310. insert into SECTOR (Sectornumber, Tracknumber) values (4, '34');
  311. insert into SECTOR (Sectornumber, Tracknumber) values (1, '33');
  312. insert into SECTOR (Sectornumber, Tracknumber) values (2, '33');
  313. insert into SECTOR (Sectornumber, Tracknumber) values (3, '33');
  314. insert into SECTOR (Sectornumber, Tracknumber) values (4, '33');
  315. insert into SECTOR (Sectornumber, Tracknumber) values (1, '32');
  316. insert into SECTOR (Sectornumber, Tracknumber) values (2, '32');
  317. insert into SECTOR (Sectornumber, Tracknumber) values (3, '32');
  318. insert into SECTOR (Sectornumber, Tracknumber) values (4, '32');
  319. insert into SECTOR (Sectornumber, Tracknumber) values (1, '31');
  320. insert into SECTOR (Sectornumber, Tracknumber) values (2, '31');
  321. insert into SECTOR (Sectornumber, Tracknumber) values (3, '31');
  322. insert into SECTOR (Sectornumber, Tracknumber) values (1, '30');
  323. insert into SECTOR (Sectornumber, Tracknumber) values (2, '30');
  324. insert into SECTOR (Sectornumber, Tracknumber) values (3, '30');
  325. insert into SECTOR (Sectornumber, Tracknumber) values (1, '40');
  326. insert into SECTOR (Sectornumber, Tracknumber) values (2, '40');
  327. insert into SECTOR (Sectornumber, Tracknumber) values (3, '40');
  328. insert into SECTOR (Sectornumber, Tracknumber) values (4, '40');
  329. insert into SECTOR (Sectornumber, Tracknumber) values (5, '40');
  330. insert into SECTOR (Sectornumber, Tracknumber) values (6, '40');
  331. insert into SECTOR (Sectornumber, Tracknumber) values (7, '40');
  332. insert into SECTOR (Sectornumber, Tracknumber) values (1, '41');
  333. insert into SECTOR (Sectornumber, Tracknumber) values (2, '41');
  334. insert into SECTOR (Sectornumber, Tracknumber) values (3, '41');
  335. insert into SECTOR (Sectornumber, Tracknumber) values (4, '41');
  336. insert into SECTOR (Sectornumber, Tracknumber) values (1, '42');
  337. insert into SECTOR (Sectornumber, Tracknumber) values (2, '42');
  338. insert into SECTOR (Sectornumber, Tracknumber) values (3, '42');
  339. insert into SECTOR (Sectornumber, Tracknumber) values (4, '42');
  340. insert into SECTOR (Sectornumber, Tracknumber) values (1, '43');
  341. insert into SECTOR (Sectornumber, Tracknumber) values (2, '43');
  342. insert into SECTOR (Sectornumber, Tracknumber) values (3, '43');
  343. insert into SECTOR (Sectornumber, Tracknumber) values (4, '43');
  344. insert into SECTOR (Sectornumber, Tracknumber) values (1, '44');
  345. insert into SECTOR (Sectornumber, Tracknumber) values (2, '44');
  346. insert into SECTOR (Sectornumber, Tracknumber) values (3, '44');
  347. insert into SECTOR (Sectornumber, Tracknumber) values (4, '44');
  348. insert into SECTOR (Sectornumber, Tracknumber) values (1, '45');
  349. insert into SECTOR (Sectornumber, Tracknumber) values (2, '45');
  350. insert into SECTOR (Sectornumber, Tracknumber) values (3, '45');
  351. insert into SECTOR (Sectornumber, Tracknumber) values (4, '45');
  352. insert into SECTOR (Sectornumber, Tracknumber) values (5, '45');
  353. insert into SECTOR (Sectornumber, Tracknumber) values (6, '45');
  354. insert into SECTOR (Sectornumber, Tracknumber) values (7, '45');
  355. insert into SECTOR (Sectornumber, Tracknumber) values (8, '45');
  356. insert into SECTOR (Sectornumber, Tracknumber) values (9, '45');
  357. insert into SECTOR (Sectornumber, Tracknumber) values (1, '58');
  358. insert into SECTOR (Sectornumber, Tracknumber) values (2, '58');
  359. insert into SECTOR (Sectornumber, Tracknumber) values (3, '58');
  360. insert into SECTOR (Sectornumber, Tracknumber) values (4, '58');
  361. insert into SECTOR (Sectornumber, Tracknumber) values (5, '58');
  362. insert into SECTOR (Sectornumber, Tracknumber) values (1, '57');
  363. insert into SECTOR (Sectornumber, Tracknumber) values (2, '57');
  364. insert into SECTOR (Sectornumber, Tracknumber) values (3, '57');
  365. insert into SECTOR (Sectornumber, Tracknumber) values (4, '57');
  366. insert into SECTOR (Sectornumber, Tracknumber) values (5, '57');
  367. insert into SECTOR (Sectornumber, Tracknumber) values (6, '57');
  368. insert into SECTOR (Sectornumber, Tracknumber) values (7, '57');
  369. insert into SECTOR (Sectornumber, Tracknumber) values (8, '57');
  370. insert into SECTOR (Sectornumber, Tracknumber) values (1, '56');
  371. insert into SECTOR (Sectornumber, Tracknumber) values (2, '56');
  372. insert into SECTOR (Sectornumber, Tracknumber) values (3, '56');
  373. insert into SECTOR (Sectornumber, Tracknumber) values (4, '56');
  374. insert into SECTOR (Sectornumber, Tracknumber) values (5, '56');
  375. insert into SECTOR (Sectornumber, Tracknumber) values (6, '56');
  376. insert into SECTOR (Sectornumber, Tracknumber) values (7, '56');
  377. insert into SECTOR (Sectornumber, Tracknumber) values (8, '56');
  378. insert into SECTOR (Sectornumber, Tracknumber) values (1, '55');
  379. insert into SECTOR (Sectornumber, Tracknumber) values (2, '55');
  380. insert into SECTOR (Sectornumber, Tracknumber) values (3, '55');
  381. insert into SECTOR (Sectornumber, Tracknumber) values (4, '55');
  382. insert into SECTOR (Sectornumber, Tracknumber) values (5, '55');
  383. insert into SECTOR (Sectornumber, Tracknumber) values (6, '55');
  384. insert into SECTOR (Sectornumber, Tracknumber) values (7, '55');
  385. insert into SECTOR (Sectornumber, Tracknumber) values (8, '55');
  386. insert into SECTOR (Sectornumber, Tracknumber) values (1, '54');
  387. insert into SECTOR (Sectornumber, Tracknumber) values (2, '54');
  388. insert into SECTOR (Sectornumber, Tracknumber) values (3, '54');
  389. insert into SECTOR (Sectornumber, Tracknumber) values (4, '54');
  390. insert into SECTOR (Sectornumber, Tracknumber) values (5, '54');
  391. insert into SECTOR (Sectornumber, Tracknumber) values (6, '54');
  392. insert into SECTOR (Sectornumber, Tracknumber) values (7, '54');
  393. insert into SECTOR (Sectornumber, Tracknumber) values (1, '53');
  394. insert into SECTOR (Sectornumber, Tracknumber) values (2, '53');
  395. insert into SECTOR (Sectornumber, Tracknumber) values (3, '53');
  396. insert into SECTOR (Sectornumber, Tracknumber) values (4, '53');
  397. insert into SECTOR (Sectornumber, Tracknumber) values (5, '53');
  398. insert into SECTOR (Sectornumber, Tracknumber) values (6, '53');
  399. insert into SECTOR (Sectornumber, Tracknumber) values (7, '53');
  400. insert into SECTOR (Sectornumber, Tracknumber) values (1, '52');
  401. insert into SECTOR (Sectornumber, Tracknumber) values (2, '52');
  402. insert into SECTOR (Sectornumber, Tracknumber) values (3, '52');
  403. insert into SECTOR (Sectornumber, Tracknumber) values (4, '52');
  404. insert into SECTOR (Sectornumber, Tracknumber) values (5, '52');
  405. insert into SECTOR (Sectornumber, Tracknumber) values (6, '52');
  406. insert into SECTOR (Sectornumber, Tracknumber) values (7, '52');
  407. insert into SECTOR (Sectornumber, Tracknumber) values (1, '51');
  408. insert into SECTOR (Sectornumber, Tracknumber) values (2, '51');
  409. insert into SECTOR (Sectornumber, Tracknumber) values (3, '51');
  410. insert into SECTOR (Sectornumber, Tracknumber) values (4, '51');
  411. insert into SECTOR (Sectornumber, Tracknumber) values (5, '51');
  412. insert into SECTOR (Sectornumber, Tracknumber) values (6, '51');
  413. insert into SECTOR (Sectornumber, Tracknumber) values (1, '64');
  414. insert into SECTOR (Sectornumber, Tracknumber) values (2, '64');
  415. insert into SECTOR (Sectornumber, Tracknumber) values (3, '64');
  416. insert into SECTOR (Sectornumber, Tracknumber) values (4, '64');
  417. insert into SECTOR (Sectornumber, Tracknumber) values (5, '64');
  418. insert into SECTOR (Sectornumber, Tracknumber) values (1, '63');
  419. insert into SECTOR (Sectornumber, Tracknumber) values (2, '63');
  420. insert into SECTOR (Sectornumber, Tracknumber) values (3, '63');
  421. insert into SECTOR (Sectornumber, Tracknumber) values (4, '63');
  422. insert into SECTOR (Sectornumber, Tracknumber) values (1, '62');
  423. insert into SECTOR (Sectornumber, Tracknumber) values (2, '62');
  424. insert into SECTOR (Sectornumber, Tracknumber) values (3, '62');
  425. insert into SECTOR (Sectornumber, Tracknumber) values (1, '61');
  426. insert into SECTOR (Sectornumber, Tracknumber) values (2, '61');
  427. insert into SECTOR (Sectornumber, Tracknumber) values (3, '61');
  428. insert into SECTOR (Sectornumber, Tracknumber) values (1, '74');
  429. insert into SECTOR (Sectornumber, Tracknumber) values (2, '74');
  430. insert into SECTOR (Sectornumber, Tracknumber) values (3, '74');
  431. insert into SECTOR (Sectornumber, Tracknumber) values (4, '74');
  432. insert into SECTOR (Sectornumber, Tracknumber) values (5, '74');
  433. insert into SECTOR (Sectornumber, Tracknumber) values (1, '75');
  434. insert into SECTOR (Sectornumber, Tracknumber) values (2, '75');
  435. insert into SECTOR (Sectornumber, Tracknumber) values (3, '75');
  436. insert into SECTOR (Sectornumber, Tracknumber) values (4, '75');
  437. insert into SECTOR (Sectornumber, Tracknumber) values (1, '76');
  438. insert into SECTOR (Sectornumber, Tracknumber) values (2, '76');
  439. insert into SECTOR (Sectornumber, Tracknumber) values (3, '76');
  440. insert into SECTOR (Sectornumber, Tracknumber) values (4, '76');
  441. insert into SECTOR (Sectornumber, Tracknumber) values (5, '76');
  442. insert into SECTOR (Sectornumber, Tracknumber) values (1, '77');
  443. insert into SECTOR (Sectornumber, Tracknumber) values (2, '77');
  444. insert into SECTOR (Sectornumber, Tracknumber) values (3, '77');
  445. insert into SECTOR (Sectornumber, Tracknumber) values (4, '77');
  446. insert into SECTOR (Sectornumber, Tracknumber) values (5, '77');
  447. insert into SECTOR (Sectornumber, Tracknumber) values (1, '12');
  448. insert into SECTOR (Sectornumber, Tracknumber) values (1, '13');
  449. insert into SECTOR (Sectornumber, Tracknumber) values (1, '14');
  450. insert into SECTOR (Sectornumber, Tracknumber) values (1, '15');
  451. insert into SECTOR (Sectornumber, Tracknumber) values (1, '16');
  452. insert into SECTOR (Sectornumber, Tracknumber) values (1, '17');
  453. insert into SECTOR (Sectornumber, Tracknumber) values (1, '18');
  454. insert into SECTOR (Sectornumber, Tracknumber) values (1, '19');
  455. insert into SECTOR (Sectornumber, Tracknumber) values (1, '20');
  456. insert into SECTOR (Sectornumber, Tracknumber) values (1, '21');
  457.  
  458. -- TramType
  459. insert into TRAMTYPE (Tramtype, Length) values ('Combino','1');
  460. insert into TRAMTYPE (Tramtype, Length) values ('11G','1');
  461. insert into TRAMTYPE (Tramtype, Length) values ('DKCombino','1');
  462. insert into TRAMTYPE (Tramtype, Length) values ('12G','1');
  463. insert into TRAMTYPE (Tramtype, Length) values ('Education','1');
  464.  
  465. -- Tram - Combino
  466. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2001, 'Combino', 0, 10, 0, 'Duty', 'a', '2008-10-15', '2008-10-15','05:30', '00:35');
  467. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2002, 'Combino', 0, 17, 0, 'Duty', 'ab', '2008-10-05', '2008-09-16', null, null);
  468. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2003, 'Combino', 0, 2, 0, 'Duty', 'ac', '2008-10-16', '2008-09-18', '06:48', '00:56');
  469. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2004, 'Combino', 0, 10, 0, 'Duty', 'ad', '2008-09-24', '2008-08-28', '05:31', '01:05');
  470. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2005, 'Combino', 0, 17, 0, 'Duty', 'ae', '2008-09-21', '2008-09-21', '06:32', '21:39');
  471. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2006, 'Combino', 0, 13, 0, 'Duty', 'af', '2008-09-19', '2008-07-24', '05:56', '18:06');
  472. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2007, 'Combino', 0, 1, 0, 'Duty', 'ag', '2008-10-22', '2008-09-21', '06:44', '18:13');
  473. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2008, 'Combino', 0, 2, 0, 'Duty', 'ah', '2008-10-24', '2008-09-23', null, null);
  474. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2009, 'Combino', 0, 1, 0, 'Duty', 'ai', '2008-10-01', '2008-08-03', '07:03', '01:12');
  475. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2010, 'Combino', 0, 13, 0, 'Duty', 'aj', '2008-10-02', '2008-09-03', '07:14', '18:27');
  476. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2011, 'Combino', 0, 17, 0, 'Duty', 'ak', '2008-10-23', '2008-08-28', null, null);
  477. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2012, 'Combino', 0, 17, 0, 'Duty', 'al', '2008-10-12', '2008-08-24', '07:32', '19:49');
  478. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2013, 'Combino', 0, 17, 0, 'Duty', 'am', '2008-10-05', '2008-9-11', '07:15', '10:35');
  479. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2014, 'Combino', 0, 10, 0, 'Duty', 'an', '2008-10-10', '2008-07-30', '05:46', '19:39');
  480. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2015, 'Combino', 0, 13, 0, 'Duty', 'ao', '2008-10-14', '2008-08-17', null, null);
  481. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2016, 'Combino', 0, 17, 0, 'Duty', 'ap', '2008-10-23', '2008-10-23', '06:28', '09:40');
  482. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2017, 'Combino', 0, 2, 0, 'Duty', 'aq', '2008-10-02', '2008-09-12', '06:06', '00:42');
  483. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2018, 'Combino', 0, 2, 0, 'Duty', 'ar', '2008-10-15', '2008-09-17', '07:17', '10:22');
  484. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2019, 'Combino', 0, 2, 0, 'Duty', 'as', '2008-06-05', '2008-06-05', null, null);
  485. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2020, 'Combino', 0, 17, 0, 'Duty', 'at', '2008-10-05', '2008-09-12', '06:14', '01:00');
  486. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2021, 'Combino', 0, 13, 0, 'Duty', 'au', '2008-10-23', '2008-09-16', null, null);
  487. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2022, 'Combino', 0, 17, 0, 'Duty', 'av', '2008-10-24', '2008-08-10', '07:05', '17:50');
  488. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2023, 'Combino', 0, 1, 0, 'Duty', 'aw', '2008-10-08', '2008-09-04', '06:34', '18:54');
  489. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2024, 'Combino', 0, 1, 0, 'Duty', 'ax', '2008-10-20', '2008-09-10', '06:18', '01:03');
  490. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2025, 'Combino', 0, 2, 0, 'Duty', 'ay', '2008-10-14', '2008-08-08', '06:52', '00:54');
  491. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2026, 'Combino', 0, 17, 0, 'Duty', 'az', '2008-09-25', '2008-08-19', '06:24', '01:11');
  492. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2027, 'Combino', 0, 17, 0, 'Duty', 'b', '2008-10-08', '2008-09-16', '05:46', '01:14');
  493. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2028, 'Combino', 0, 17, 0, 'Duty', 'ba', '2008-10-22', '2008-10-22', '07:07', '00:46');
  494. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2029, 'Combino', 0, 1, 0, 'Duty', 'bb', '2008-09-28', '2008-09-28', '06:28', '00:29');
  495. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2030, 'Combino', 0, 13, 0, 'Duty', 'bc', '2008-10-19', '2008-09-28', '06:35', '18:56');
  496. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2031, 'Combino', 0, 2, 0, 'Duty', 'bd', '2008-10-22', '2008-10-09', '05:51', '00:22');
  497. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2032, 'Combino', 0, 10, 0, 'Duty', 'be', '2008-10-03', '2008-09-10', '06:01', '01:01');
  498. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2033, 'Combino', 0, 1, 0, 'Duty', 'bf', '2008-09-30', '2008-08-03', '05:33', '20:40');
  499. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2034, 'Combino', 0, 1, 0, 'Duty', 'bg', '2008-09-24', '2008-08-13', '07:05', '20:18');
  500. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2035, 'Combino', 0, 1, 0, 'Duty', 'bh', '2008-10-09', '2008-10-09', '06:44', '21:47');
  501. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2036, 'Combino', 0, 10, 0, 'Duty', 'bi', '2008-09-09', '2008-09-09', null, null);
  502. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2037, 'Combino', 0, 10, 0, 'Duty', 'a1', '2008-10-16', '2008-9-21', '05:45', '19:09');
  503. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2038, 'Combino', 0, 17, 0, 'Duty', 'a2', '2008-10-10', '2008-10-10', null, null);
  504. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2039, 'Combino', 0, 10, 0, 'Duty', 'a3', '2008-10-01', '2008-9-12', null, null);
  505. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2040, 'Combino', 0, 13, 0, 'Duty', 'a4', '2008-9-30', '2008-8-29', '06:58', '01:22');
  506. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2041, 'Combino', 0, 1, 0, 'Duty', 'a5', '2008-10-20', '2008-8-26', '07:30', '10:25');
  507. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2042, 'Combino', 0, 2, 0, 'Duty', 'a6', '2008-10-09', '2008-8-08', '06:34', '23:42');
  508. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2043, 'Combino', 0, 10, 0, 'Duty', 'a7', '2008-10-05', '2008-10-05', '06:03', '09:23');
  509. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2044, 'Combino', 0, 17, 0, 'Duty', 'a8', '2008-10-20', '2008-10-19', '06:57', '10:16');
  510. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2045, 'Combino', 0, 13, 0, 'Duty', 'a9', '2008-10-07', '2008-9-03', '05:41', '10:00');
  511. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2046, 'Combino', 0, 13, 0, 'Duty', 'a10', '2008-10-09', '2008-9-07', '06:57', '01:07');
  512. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2047, 'Combino', 0, 17, 0, 'Duty', 'a11', '2008-9-04', '2008-9-04', '07:44', '00:39');
  513. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2048, 'Combino', 0, 13, 0, 'Duty', 'a12', '2008-10-07', '2008-8-20', '07:12', '00:11');
  514. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2049, 'Combino', 0, 2, 0, 'Duty', 'a13', '2008-10-10', '2008-10-10', null, null);
  515. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2050, 'Combino', 0, 10, 0, 'Duty', 'a14', '2008-9-28', '2008-8-26', null, null);
  516. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2051, 'Combino', 0, 2, 0, 'Duty', 'a15', '2008-10-07', '2008-9-07', '06:21', '17:44');
  517. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2052, 'Combino', 0, 1, 0, 'Duty', 'a16', '2008-9-25', '2008-7-01', '05:59', '00:37');
  518. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2053, 'Combino', 0, 1, 0, 'Duty', 'a17', '2008-10-20', '2008-10-20', '05:31', '18:40');
  519. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2054, 'Combino', 0, 2, 0, 'Duty', 'a18', '2008-10-15', '2008-8-03', '06:58', '22:42');
  520. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2055, 'Combino', 0, 2, 0, 'Duty', 'a19', '2008-10-12', '2008-9-02', '07:32', '09:14');
  521. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2056, 'Combino', 0, 13, 0, 'Duty', 'a20', '2008-10-01', '2008-8-15', '06:11', '23:19');
  522. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2057, 'Combino', 0, 1, 0, 'Duty', 'a21', '2008-10-12', '2008-8-21', '05:48', '23:39');
  523. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2058, 'Combino', 0, 10, 0, 'Duty', 'a22', '2008-10-01', '2008-8-07', null, null);
  524. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2059, 'Combino', 0, 1, 0, 'Duty', 'a23', '2008-10-02', '2008-9-09', '05:26', '09:29');
  525. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2060, 'Combino', 0, 17, 0, 'Duty', 'a24', '2008-10-15', '2008-9-12', '06:46', '10:05');
  526. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2061, 'Combino', 0, 1, 0, 'Duty', 'a25', '2008-10-03', '2008-8-10', '06:36', '00:59');
  527. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2062, 'Combino', 0, 2, 0, 'Duty', 'a26', '2008-10-10', '2008-9-17', '07:11', '20:46');
  528. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2063, 'Combino', 0, 2, 0, 'Duty', 'a27', '2008-10-08', '2008-9-18', '06:38', '18:02');
  529. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2064, 'Combino', 0, 1, 0, 'Duty', 'a28', '2008-10-23', '2008-9-19', '06:48', '10:23');
  530. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2065, 'Combino', 0, 2, 0, 'Duty', 'a29', '2008-10-17', '2008-9-23', '05:36', '01:05');
  531. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2066, 'Combino', 0, 1, 0, 'Duty', 'a30', '2008-10-12', '2008-10-12', '07:19', '01:26');
  532. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2067, 'Combino', 0, 13, 0, 'Duty', 'a31', '2008-10-02', '2008-10-17', '06:42', '00:55');
  533. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2068, 'Combino', 0, 1, 0, 'Duty', 'a32', '2008-10-24', '2008-10-24', '07:07', '18:09');
  534. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2069, 'Combino', 0, 2, 0, 'Duty', 'a33', '2008-9-19', '2008-9-19', '07:07', '20:16');
  535. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2070, 'Combino', 0, 13, 0, 'Duty', 'a34', '2008-9-24', '2008-8-11', '07:03', '00:50');
  536. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2071, 'Combino', 0, 17, 0, 'Duty', 'a35', '2008-10-17', '2008-10-17', null, null);
  537. insert into TRAM (Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values (2072, 'Combino', 0, 10, 0, 'Duty', 'a36', '2008-10-22', '2008-9-14', '07:03', '09:32');
  538.  
  539. -- Tram - DK Combino
  540. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('2201', 'DKCombino', '0', '1', '5', 'Remise', 'xXyyyyyXx', '2008-10-19', '2008-10-19', '18:45', '07:15');
  541. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('2202', 'DKCombino', '0', '1', '5', 'Remise', 'xXyyyyyyXx', '2008-10-24', '2008-09-20', '17:57', '06:21');
  542. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('2203', 'DKCombino', '0', '1', '5', 'Remise', 'xXyyyyyyyXx', '2008-10-24', '2008-09-20', '20:09', '06:56');
  543. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('2204', 'DKCombino', '0', '1', '5', 'Remise', 'xXyyyyyyyyXx', '2008-10-10', '2008-07-20', '20:50', '07:29');
  544.  
  545. -- Tram - 11G
  546. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('901', '11G', '1', '5', '1', 'Duty', 'a', '2008-09-25', '2008-09-04', '07:16', '10:26');
  547. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('902', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-16', '2008-08-27', '05:36', '01:16');
  548. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('903', '11G', '1', '5', '1', 'Duty', 'a', '2008-09-30', '2008-08-12', '05:51', '01:02');
  549. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('904', '11G', '1', '5', '1', 'Duty', 'a', '2008-08-29', '2008-07-03', '07:33', '00:50');
  550. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('905', '11G', '1', '5', '1', 'Duty', 'a', '2008-09-25', '2008-09-16', '06:59', '01:03');
  551. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('906', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-09', '2008-10-14', '07:02', '00:42');
  552. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('907', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-03', '2008-10-03', '06:53', '00:02');
  553. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('908', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-01', '2008-07-20', '07:18', '18:00');
  554. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('909', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-19', '2008-09-03', '06:57', '18:20');
  555. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('910', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-14', '2008-10-14', null, null);
  556. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('911', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-22', '2008-10-22', '07:15', '00:44');
  557. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('912', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-03', '2008-08-31', '05:21', '19:47');
  558. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('913', '11G', '1', '5', '1', 'Duty', 'a', '2008-08-28', '2008-08-28', null, null);
  559. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('914', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-08', '2008-09-11', null, null);
  560. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('915', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-19', '2008-08-31', '07:14', '20:00');
  561. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('916', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-16', '2008-09-17', '07:05', '00:52');
  562. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('917', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-17', '2008-08-07', '06:42', '00:32');
  563. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('918', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-05', '2008-09-11', null, null);
  564. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('919', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-23', '2008-10-23', '07:34', '09:19');
  565. insert into TRAM(Tramnumber, Tramtype, Railbound, Linenumber, Controller, Status, RFIDtag, LastSmallClean, LastBigClean, Depart, Entry) values ('920', '11G', '1', '5', '1', 'Duty', 'a', '2008-10-02', '2008-09-03', '05:58', '20:37');
  566.  
  567. -- Tram - 12G
  568. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('817', '12G', '0', '1', '16/24', 'Remise', 'xXyyXx', '2008-08-08', '2008-08-24', null, null);
  569. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('818', '12G', '0', '1', '16/24', 'Duty', 'xXyyyXx', '2008-10-05', '2008-10-16', '20:36', '6:43');
  570. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('819', '12G', '0', '1', '16/24', 'Remise', 'xXyzyXx', '2008-10-05', '2008-09-08', null, null);
  571. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('820', '12G', '0', '1', '16/24', 'Duty', 'xXyzzyXx', '2008-10-19', '2008-10-19', '1:11', '6:31');
  572. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('821', '12G', '0', '1', '16/24', 'Remise', 'xXyzzzyXx', '2008-10-16', '2008-9-14', null, null);
  573. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('822', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzyXx', '2008-08-22', '2008-08-22', '00:24', '05:42');
  574. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('823', '12G', '0', '1', '16/24', 'Remise', 'xXyzzzzzyXx', '2008-10-24', '2008-10-24', null, null);
  575. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('824', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzyXx', '2008-10-20', '2008-10-02', '00:57', '06:22');
  576. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('825', '12G', '0', '1', '16/24', 'Remise', 'xXyzzzzzzzyXx', '2008-10-07', '2008-08-24', null, null);
  577. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('826', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzyXx', '2008-10-17', '2008-09-18', '17:50', '07:12');
  578. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('827', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzyXx', '2008-08-05', '2008-08-05', '10:05', '06:55');
  579. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('828', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzyXx', '2008-08-15', '2008-08-15', '18:53', '06:40');
  580. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('829', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzyXx', '2008-08-21', '2008-08-21', '18:43', '06:12');
  581. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('830', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzzyXx', '2008-10-15', '2008-08-29', '19:31', '06:29');
  582. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('831', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzzzyXx', '2008-10-12', '2008-10-12', '00:29', '06:39');
  583. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('832', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzzzzyXx', '2008-10-08', '2008-10-09', '22:20', '07:08');
  584. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('833', '12G', '0', '1', '16/24', 'Remise', 'xXyzzzzzzzzzzzzzzzyXx', '2008-10-17', '2008-09-21', null, null);
  585. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('834', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzzzzzzyXx', '2008-10-05', '2008-09-07', '00:59', '07:00');
  586. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('835', '12G', '0', '1', '16/24', 'Remise', 'xXyzzzzzzzzzzzzzzzzzyXx', '2008-10-15', '2008-10-12', null, null);
  587. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('836', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzzzzzzzzyXx', '2008-10-08', '2008-07-20', '20:19', '07:06');
  588. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('837', '12G', '0', '1', '16/24', 'Remise', 'xXyzzzzzzzzzzzzzzzzzzzyXx', '2008-10-05', '2008-08-31', null, null);
  589. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('838', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzzzzzzzzzzyXx', '2008-10-02', '2008-09-07', '18:03', '07:03');
  590. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('839', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzzzzzzzzzzzyXx', '2008-09-10', '2008-09-21', '18:13', '05:57');
  591. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('840', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzzzzzzzzzzzzyXx', '2008-07-25', '2008-07-25', '00:14', '06:17');
  592. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('841', '12G', '0', '1', '16/24', 'Duty', 'xXyzzzzzzzzzzzzzzzzzzzzzzzyXx', '2008-10-14', '2008-10-14', '18:30', '06:48');
  593.  
  594. -- Tram - Education
  595. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('809', 'Education', '0', '0', 'ocv', 'Duty', 'xXxXx', '2008-06-25', '2008-06-26', null, null);
  596. insert into TRAM (TramNumber, Tramtype, Railbound, Controller, Linenumber, Status, RFIDtag, LastSmallClean, LastBigClean, Entry, Depart) values ('816', 'Education', '0', '0', 'ocv', 'Duty', 'xXyXx', '2008-07-27', '2008-07-27', null, null);
  597.  
  598. -- Cleaning
  599. insert into CLEANING (CleanDate, CleanType) values ('2017-03-31', 'BigCleanService');
  600. insert into CLEANING (CleanDate, CleanType) values ('2016-04-12', 'SmallCleanService');
  601. insert into CLEANING (CleanDate, CleanType) values ('2017-03-01', 'BigCleanService');
  602. insert into CLEANING (CleanDate, CleanType) values ('2017-01-30', 'SmallCleanService');
  603. insert into CLEANING (CleanDate, CleanType) values ('2016-08-18', 'BigCleanService');
  604. insert into CLEANING (CleanDate, CleanType) values ('2016-05-09', 'SmallCleanService');
  605. insert into CLEANING (CleanDate, CleanType) values ('2016-05-03', 'BigCleanService');
  606. insert into CLEANING (CleanDate, CleanType) values ('2017-05-11', 'SmallCleanService');
  607. insert into CLEANING (CleanDate, CleanType) values ('2017-06-20', 'BigCleanService');
  608. insert into CLEANING (CleanDate, CleanType) values ('2017-07-28', 'SmallCleanService');
  609.  
  610. -- Repair
  611. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-06-20', 'Wiel kapot', 'SmallMaintenanceService');
  612. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-02-26', 'Wiel kapot', 'BigMaintenanceService');
  613. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-02-24', 'Wiel kapot', 'SmallMaintenanceService');
  614. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-05-03', 'Raam kapot', 'BigMaintenanceService');
  615. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-02-12', 'Motor kapot', 'SmallMaintenanceService');
  616. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-04-17', 'Raam kapot', 'BigMaintenanceService');
  617. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-06-01', 'Raam kapot', 'SmallMaintenanceService');
  618. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-10-12', 'Deur kapot', 'BigMaintenanceService');
  619. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-08-23', 'Wiel kapot', 'SmallMaintenanceService');
  620. insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-08-05', 'Motor kapot', 'BigMaintenanceService');
  621.  
  622. -- CleaningRule
  623. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2001','1');
  624. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2002','2');
  625. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2003','3');
  626. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2004','4');
  627. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2005','5');
  628. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2006','6');
  629. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2007','7');
  630. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2008','8');
  631. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2009','9');
  632. insert into CLEANINGRULE (TramNumber, CleaningID) values ('2010','10');
  633.  
  634. -- RepairRule
  635. insert into REPAIRRULE (TramNumber, RepairID) values ('2011','1');
  636. insert into REPAIRRULE (TramNumber, RepairID) values ('2012','2');
  637. insert into REPAIRRULE (TramNumber, RepairID) values ('2013','3');
  638. insert into REPAIRRULE (TramNumber, RepairID) values ('2014','4');
  639. insert into REPAIRRULE (TramNumber, RepairID) values ('2015','5');
  640. insert into REPAIRRULE (TramNumber, RepairID) values ('2016','6');
  641. insert into REPAIRRULE (TramNumber, RepairID) values ('2017','7');
  642. insert into REPAIRRULE (TramNumber, RepairID) values ('2018','8');
  643. insert into REPAIRRULE (TramNumber, RepairID) values ('2019','9');
  644. insert into REPAIRRULE (TramNumber, RepairID) values ('2020','10');
  645.  
  646. -- Employee - Data
  647. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Tom', 'de Wildt', 'Manager', 'Roerdomp 21', 'Sint-Michielsgestel', 'Tomdewildt@ziggo.nl');
  648. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Simon', 'van Someren', 'Depotmanager', 'Avondrood 16', 'Deurne', 'Simonvansomeren@outlock.com');
  649. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Liwei', 'Hu', 'Technician', 'Gitaarstraat 4', 'Venray', 'Liweihu12@gmail.com');
  650. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Roberto', 'de Wolff', 'Cleaner', 'Udenstraat 2', 'Uden', 'Roberto.dewolff@student.fontys.nl');
  651. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Luc', 'Urlings', 'Machinist', 'Hunsstraat 43a', 'Voerendaal', 'Luc.urlings@student.fontys.nl');
  652. -- Employee - Generated
  653. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Terry', 'Coleman', 'Machinist', '467 Leroy Center', 'Colca', 'tcoleman0@goodreads.com');
  654. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Arthur', 'Nichols', 'Depotmanager', '9 Crescent Oaks Street', 'Bardiyah', 'anichols@yellowbook.com');
  655. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Amy', 'Harper', 'Cleaner', '46386 Scott Center', 'Kala Dondra', 'aharper2@omniture.com');
  656. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Amanda', 'Mills', 'Machinist', '3 Merrick Way', 'Vidnoye', 'amills3@yahoo.com');
  657. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Roy', 'James', 'Technician', '72638 Manley Court', 'Santa Maria Chiquimula', 'rjames4@mail.ru');
  658. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Andrea', 'Howard', 'Cleaner', '529 Bunting Hill', 'El Banco', 'ahoward5@wordpress.com');
  659. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Joan', 'Matthews', 'Technician', '04 Westerfield Place', 'General Belgrano', 'jmatthews6@bluehost.com');
  660. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Theresa', 'Mcdonald', 'Machinist', '02 Michigan Point', 'Volokolamsk', 'tmcdonald7@multiply.com');
  661. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Diana', 'Ellis', 'Machinist', '9 Swallow Alley', 'San Cristabal', 'dellis8@bigcartel.com');
  662. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Carolyn', 'Gray', 'Depotmanager', '6 Express Point', 'Sharm el-Sheikh', 'cgray9@icq.com');
  663. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Sandra', 'Murphy', 'Machinist', '7 Village Parkway', 'Hoves', 'smurphya@elpais.com');
  664. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Judith', 'Wells', 'Cleaner', '04539 Vernon Parkway', 'Vetrino', 'jwellsb@sciencedaily.com');
  665. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Jeffrey', 'Stone', 'Technician', '347 Arrowood Park', 'Puchong', 'jstonec@nih.gov');
  666. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Willie', 'Chapman', 'Machinist', '256 Leroy Drive', 'Laibin', 'wchapmand@google.co.jp');
  667. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Henry', 'Hughes', 'Depotmanager', '0 Debs Way', 'Canhas', 'hhughese@house.gov');
  668. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Juan', 'Dean', 'Machinist', '57424 Merry Crossing', 'Santa Cruz', 'jdeanf@google.com.br');
  669. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Bobby', 'Rice', 'Cleaner', '0 Longview Terrace', 'Klatakan', 'briceg@mediafire.com');
  670. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Joan', 'Stevens', 'Cleaner', '3 Coolidge Lane', 'Mufushan', 'jstevensh@cbc.ca');
  671. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'James', 'Gilbert', 'Depotmanager', '67 Golf Course Avenue', 'Aylmer', 'jgilberti@discovery.com');
  672. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Billy', 'Gonzales', 'Technician', '27640 Luster Park', 'Ayna', 'bgonzalesj@archive.org');
  673. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Alan', 'Howard', 'Cleaner', '5 Washington Avenue', 'Cuamba', 'ahowardk@java.com');
  674. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Kathleen', 'Hill', 'Depotmanager', '67690 Hintze Pass', 'Pamiatkowo', 'khilll@joomla.org');
  675. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Janet', 'Burns', 'Technician', '6 Lukken Road', 'Villeneuve-la-Garenne', 'jburnsm@jugem.jp');
  676. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Sara', 'Carroll', 'Cleaner', '306 Surrey Center', 'Kuching', 'scarrolln@sogou.com');
  677. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Harry', 'Gray', 'Machinist', '783 Sullivan Plaza', 'Vilaka', 'hgrayo@instagram.com');
  678. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Joyce', 'Perry', 'Cleaner', '0572 Dayton Lane', 'Shuanggang', 'jperryp@time.com');
  679. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Michael', 'Alvarez', 'Depotmanager', '5339 Fuller Point', 'Xam Nua', 'malvarezq@nhs.uk');
  680. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Karen', 'Washington', 'Machinist', '0964 Emmet Terrace', 'Nyakhachava', 'kwashingtonr@wordpress.org');
  681. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'George', 'Ryan', 'Cleaner', '8078 Melvin Center', 'Urpay', 'gryans@un.org');
  682. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Antonio', 'Perkins', 'Depotmanager', '774 Lotheville Place', 'Phatthana Nikhom', 'aperkinst@ed.gov');
  683. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Stephen', 'Nguyen', 'Depotmanager', '8 Linden Parkway', 'Nerkin Getashen', 'snguyenu@ovh.net');
  684. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Cynthia', 'Hunter', 'Depotmanager', '0789 Evergreen Alley', 'Loreto', 'chunterv@salon.com');
  685. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Rose', 'Grant', 'Depotmanager', '92296 Ruskin Hill', 'Lam Plai Mat', 'rgrantw@ftc.gov');
  686. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Ernest', 'Morales', 'Machinist', '8399 Susan Plaza', 'Madamba', 'emoralesx@wiley.com');
  687. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Shawn', 'Powell', 'Technician', '0727 Washington Avenue', 'Port Glaud', 'spowelly@squarespace.com');
  688. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Chris', 'Alvarez', 'Depotmanager', '32926 Lakeland Avenue', 'Mburukullu', 'calvarezz@dailymail.co.uk');
  689. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Stephen', 'Taylor', 'Machinist', '64 Springview Center', 'Thala', 'staylor0@jiathis.com');
  690. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Shirley', 'Harris', 'Cleaner', '289 Sunbrook Trail', 'Nirasaki', 'sharris@surveymonkey.com');
  691. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Henry', 'Vasquez', 'Machinist', '66 Sunnyside Center', 'Zhuji', 'hvasquez2@omniture.com');
  692. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Randy', 'Lawrence', 'Cleaner', '30799 Sutherland Place', 'Puerto Quijarro', 'rlawrence3@sogou.com');
  693. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Carol', 'Perry', 'Machinist', '66923 Vera Point', 'Bongsri', 'cperry4@thetimes.co.uk');
  694. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Chris', 'Woods', 'Depotmanager', '7942 Elka Crossing', 'Ronninge', 'cwoods5@spotify.com');
  695. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Keith', 'Lane', 'Cleaner', '6759 New Castle Alley', 'Sacramento', 'klane6@blogs.com');
  696. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Jack', 'Hudson', 'Depotmanager', '393 Crowley Circle', 'Willemstad', 'jhudson7@tmall.com');
  697. insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Eric', 'Hunt', 'Technician', '39 Gulseth Court', 'Kobenhavn', 'ehunt8@oaic.gov.au');
  698.  
  699. -- Technician
  700. insert into TECHNICIAN (RepairID, EmployeeID) values ('1','3');
  701. insert into TECHNICIAN (RepairID, EmployeeID) values ('2','10');
  702. insert into TECHNICIAN (RepairID, EmployeeID) values ('3','12');
  703. insert into TECHNICIAN (RepairID, EmployeeID) values ('4','18');
  704. insert into TECHNICIAN (RepairID, EmployeeID) values ('5','25');
  705. insert into TECHNICIAN (RepairID, EmployeeID) values ('6','28');
  706. insert into TECHNICIAN (RepairID, EmployeeID) values ('7','40');
  707. insert into TECHNICIAN (RepairID, EmployeeID) values ('8','50');
  708. insert into TECHNICIAN (RepairID, EmployeeID) values ('9','3');
  709. insert into TECHNICIAN (RepairID, EmployeeID) values ('10','10');
  710.  
  711. -- Cleaner
  712. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('1','4','1');
  713. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('2','8','0');
  714. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('3','11','0');
  715. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('4','17','0');
  716. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('5','22','0');
  717. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('6','23','0');
  718. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('7','26','0');
  719. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('8','29','0');
  720. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('9','31','0');
  721. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('10','34','0');
  722. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values (null,'43','0');
  723. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values (null,'45','0');
  724. insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values (null,'48','0');
  725.  
  726. -- Manager
  727. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','1','1');
  728. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','2','0');
  729. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','7','0');
  730. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','15','0');
  731. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','20','0');
  732. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','24','0');
  733. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','27','0');
  734. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','32','0');
  735. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','35','0');
  736. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','36','0');
  737. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','37','0');
  738. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','38','0');
  739. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','41','0');
  740. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','47','0');
  741. insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','49','0');
  742.  
  743. -- Machinist
  744. insert into MACHINIST (EmployeeID) values ('5');
  745. insert into MACHINIST (EmployeeID) values ('6');
  746. insert into MACHINIST (EmployeeID) values ('9');
  747. insert into MACHINIST (EmployeeID) values ('13');
  748. insert into MACHINIST (EmployeeID) values ('14');
  749. insert into MACHINIST (EmployeeID) values ('16');
  750. insert into MACHINIST (EmployeeID) values ('19');
  751. insert into MACHINIST (EmployeeID) values ('21');
  752. insert into MACHINIST (EmployeeID) values ('30');
  753. insert into MACHINIST (EmployeeID) values ('33');
  754. insert into MACHINIST (EmployeeID) values ('39');
  755. insert into MACHINIST (EmployeeID) values ('42');
  756. insert into MACHINIST (EmployeeID) values ('44');
  757. insert into MACHINIST (EmployeeID) values ('46');
  758.  
  759. -- MachinistRule
  760. insert into MACHINISTRULE (MachinistID, TramNumber) values ('1','2001');
  761. insert into MACHINISTRULE (MachinistID, TramNumber) values ('2','2002');
  762. insert into MACHINISTRULE (MachinistID, TramNumber) values ('3','2003');
  763. insert into MACHINISTRULE (MachinistID, TramNumber) values ('4','2004');
  764. insert into MACHINISTRULE (MachinistID, TramNumber) values ('5','2005');
  765. insert into MACHINISTRULE (MachinistID, TramNumber) values ('6','2006');
  766. insert into MACHINISTRULE (MachinistID, TramNumber) values ('7','2007');
  767. insert into MACHINISTRULE (MachinistID, TramNumber) values ('8','2008');
  768. insert into MACHINISTRULE (MachinistID, TramNumber) values ('9','2009');
  769. insert into MACHINISTRULE (MachinistID, TramNumber) values ('10','2010');
  770. insert into MACHINISTRULE (MachinistID, TramNumber) values ('11','2011');
  771. insert into MACHINISTRULE (MachinistID, TramNumber) values ('12','2012');
  772. insert into MACHINISTRULE (MachinistID, TramNumber) values ('13','2013');
  773. insert into MACHINISTRULE (MachinistID, TramNumber) values ('14','2014');
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!