J4GY4MYg

1-- Drop
2IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'MACHINISTRULE')
3  DROP TABLE MACHINISTRULE;
4IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'MACHINIST')
5  DROP TABLE MACHINIST;
6IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'CLEANER')
7  DROP TABLE CLEANER;
8IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'MANAGER')
9  DROP TABLE MANAGER;
10IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'TECHNICIAN')
11  DROP TABLE TECHNICIAN;
12IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'EMPLOYEE')
13  DROP TABLE EMPLOYEE;
14IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'REPAIRRULE')
15  DROP TABLE REPAIRRULE;
16IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'CLEANINGRULE')
17  DROP TABLE CLEANINGRULE;
18IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'REPAIR')
19  DROP TABLE REPAIR;
20IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'CLEANING')
21  DROP TABLE CLEANING;
22IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'TRAM')
23  DROP TABLE TRAM;
24IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'TRAMTYPE')
25  DROP TABLE TRAMTYPE;
26IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'SECTOR')
27  DROP TABLE SECTOR;
28IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'TRACK')
29  DROP TABLE TRACK;
30IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'LOGIN')
31  DROP TABLE LOGIN;
32IF EXISTS (SELECT * FROM [INFORMATION_SCHEMA].TABLES WHERE TABLE_NAME = 'DEPOT')
33  DROP TABLE DEPOT;
34
35-- Create
36CREATE 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);
44CREATE 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);
51CREATE 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);
60CREATE TABLE TRAMTYPE
61(
62  Tramtype varchar(255) NOT null UNIQUE,
63  Length int NOT null,
64  CONSTRAINT PK_TramType PRIMARY KEY (Tramtype)
65);
66CREATE 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);
84CREATE 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);
97CREATE 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);
105CREATE 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);
114CREATE 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);
122CREATE 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);
130CREATE 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);
145CREATE 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);
154CREATE 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);
164CREATE 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);
174CREATE 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);
181CREATE 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
192insert into DEPOT (Name, Adress, Location) values ('Remise Havenstraat', 'Havenstraat', 'Amsterdam');
193
194-- Login - Data
195insert into LOGIN (Username, Password) values ('manager', 'test');
196insert into LOGIN (Username, Password) values ('depotmanager', 'test');
197insert into LOGIN (Username, Password) values ('technician', 'test');
198insert into LOGIN (Username, Password) values ('cleaner', 'test');
199insert into LOGIN (Username, Password) values ('machinist', 'test');
200-- Login - Generated
201insert into LOGIN (Username, Password) values ('amurray0', 'dHglhiG');
202insert into LOGIN (Username, Password) values ('bward1', 'YKaiTcXh');
203insert into LOGIN (Username, Password) values ('lrobertson2', 'LGOkvWyMpH');
204insert into LOGIN (Username, Password) values ('rburns3', 'mbvBf3');
205insert into LOGIN (Username, Password) values ('hhawkins4', 'XcG1j86Gtp6');
206insert into LOGIN (Username, Password) values ('gromero5', '6BQjoPAz7');
207insert into LOGIN (Username, Password) values ('jpeters6', 'o49ySOXetRZ');
208insert into LOGIN (Username, Password) values ('fhoward7', 'kfCamZjJo0');
209insert into LOGIN (Username, Password) values ('sburton8', 'CdLeskhqW');
210insert into LOGIN (Username, Password) values ('vlarson9', 'CDPLrUTsMoVq');
211insert into LOGIN (Username, Password) values ('thansena', 'YtmUmjDyYV2u');
212insert into LOGIN (Username, Password) values ('dspencerb', 'uhcISYkc');
213insert into LOGIN (Username, Password) values ('tpetersonc', '8TkzIx2JXHSL');
214insert into LOGIN (Username, Password) values ('jbennettd', 'LAGSHKYnRt');
215insert into LOGIN (Username, Password) values ('darnolde', 'HkMk2lOf2v1');
216insert into LOGIN (Username, Password) values ('ehuntf', 'uYXibRGs');
217insert into LOGIN (Username, Password) values ('wmorrisong', 'xcuVlsi');
218insert into LOGIN (Username, Password) values ('cperryh', '2D3PWKs');
219insert into LOGIN (Username, Password) values ('jharti', 'tQMQAg');
220insert into LOGIN (Username, Password) values ('lhansonj', 'AF2xvUabt');
221insert into LOGIN (Username, Password) values ('bsimmonsk', 'tmHyeO');
222insert into LOGIN (Username, Password) values ('eburnsl', 'UsNOivWJH');
223insert into LOGIN (Username, Password) values ('jhowellm', 'WaHrpgnqovm');
224insert into LOGIN (Username, Password) values ('nharveyn', 'gwIQPbcPtOv');
225insert into LOGIN (Username, Password) values ('cbradleyo', 'RzwmDDAi');
226insert into LOGIN (Username, Password) values ('jsanchezp', 'yCIdhp7');
227insert into LOGIN (Username, Password) values ('ehernandezq', 'PP4tS9UQ2');
228insert into LOGIN (Username, Password) values ('rbellr', 'Gjy8Cb57');
229insert into LOGIN (Username, Password) values ('rchapmans', '31rBciS3');
230insert into LOGIN (Username, Password) values ('smooret', 'YoOZMn');
231insert into LOGIN (Username, Password) values ('swilliamsonu', 'aKmLmZwdAjn');
232insert into LOGIN (Username, Password) values ('gporterv', 'mPZzA2mdwex');
233insert into LOGIN (Username, Password) values ('kgutierrezw', 'Fh48lbn');
234insert into LOGIN (Username, Password) values ('rpetersonx', 'yvSTpBbI');
235insert into LOGIN (Username, Password) values ('klongy', 'GoOvjzajm');
236insert into LOGIN (Username, Password) values ('rsimmonsz', 'Ac8zUhkP');
237insert into LOGIN (Username, Password) values ('agarrett10', 'TOvfcOueKkO');
238insert into LOGIN (Username, Password) values ('sjackson11', 'U11Abdfeniv');
239insert into LOGIN (Username, Password) values ('jmurphy12', 'ZiZsCkdg');
240insert into LOGIN (Username, Password) values ('tfrazier13', 'wG7zwikolN');
241insert into LOGIN (Username, Password) values ('jbailey14', 'GL35iJyU59');
242insert into LOGIN (Username, Password) values ('egilbert15', '11BZNMkNyxGb');
243insert into LOGIN (Username, Password) values ('ddiaz16', 'QzWlWZ');
244insert into LOGIN (Username, Password) values ('agutierrez17', 'HZpE3mNp5mL');
245insert into LOGIN (Username, Password) values ('falvarez18', 'm1YR9MbSKqC');
246
247-- Data
248insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('38','1','4','2');
249insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('37','1','4','5');
250insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('36','1','4','1');
251insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('35','1','4','16/24');
252insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('34','1','4','2');
253insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('33','1','4','16/24');
254insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('32','1','4','10');
255insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('31','1','3',null);
256insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('30','1','3','16/24');
257insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('40','1','7',null);
258insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('41','1','4','10');
259insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('42','1','4','55');
260insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('43','1','4','1');
261insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('44','1','4','13');
262insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('45','1','9','17');
263insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('58','1','5',null);
264insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('57','1','8','16/24');
265insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('56','1','8','5');
266insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('55','1','8','2');
267insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('54','1','7','5');
268insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('53','1','7','13');
269insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('52','1','7','17');
270insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('51','1','6',null);
271insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('64','1','5',null);
272insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('63','1','4','2');
273insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('62','1','3',null);
274insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('61','1','3',null);
275insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('74','1','5',null);
276insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('75','1','4',null);
277insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('76','1','5',null);
278insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('77','1','5',null);
279insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('12','1','1',null);
280insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('13','1','1',null);
281insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('14','1','1',null);
282insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('15','1','1',null);
283insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('16','1','1',null);
284insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('17','1','1',null);
285insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('18','1','1',null);
286insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('19','1','1',null);
287insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('20','1','1',null);
288insert into TRACK (Tracknumber, DepotID, Length, Linenumber) values ('21','1','1',null);
289
290-- Sectors
291insert into SECTOR (Sectornumber, Tracknumber) values ('1', '38');
292insert into SECTOR (Sectornumber, Tracknumber) values ('2', '38');
293insert into SECTOR (Sectornumber, Tracknumber) values ('3', '38');
294insert into SECTOR (Sectornumber, Tracknumber) values ('4', '38');
295insert into SECTOR (Sectornumber, Tracknumber) values ('1', '37');
296insert into SECTOR (Sectornumber, Tracknumber) values ('2', '37');
297insert into SECTOR (Sectornumber, Tracknumber) values ('3', '37');
298insert into SECTOR (Sectornumber, Tracknumber) values ('4', '37');
299insert into SECTOR (Sectornumber, Tracknumber) values ('1', '36');
300insert into SECTOR (Sectornumber, Tracknumber) values ('2', '36');
301insert into SECTOR (Sectornumber, Tracknumber) values ('3', '36');
302insert into SECTOR (Sectornumber, Tracknumber) values ('4', '36');
303insert into SECTOR (Sectornumber, Tracknumber) values ('1', '35');
304insert into SECTOR (Sectornumber, Tracknumber) values ('2', '35');
305insert into SECTOR (Sectornumber, Tracknumber) values ('3', '35');
306insert into SECTOR (Sectornumber, Tracknumber) values ('4', '35');
307insert into SECTOR (Sectornumber, Tracknumber) values (1, '34');
308insert into SECTOR (Sectornumber, Tracknumber) values (2, '34');
309insert into SECTOR (Sectornumber, Tracknumber) values (3, '34');
310insert into SECTOR (Sectornumber, Tracknumber) values (4, '34');
311insert into SECTOR (Sectornumber, Tracknumber) values (1, '33');
312insert into SECTOR (Sectornumber, Tracknumber) values (2, '33');
313insert into SECTOR (Sectornumber, Tracknumber) values (3, '33');
314insert into SECTOR (Sectornumber, Tracknumber) values (4, '33');
315insert into SECTOR (Sectornumber, Tracknumber) values (1, '32');
316insert into SECTOR (Sectornumber, Tracknumber) values (2, '32');
317insert into SECTOR (Sectornumber, Tracknumber) values (3, '32');
318insert into SECTOR (Sectornumber, Tracknumber) values (4, '32');
319insert into SECTOR (Sectornumber, Tracknumber) values (1, '31');
320insert into SECTOR (Sectornumber, Tracknumber) values (2, '31');
321insert into SECTOR (Sectornumber, Tracknumber) values (3, '31');
322insert into SECTOR (Sectornumber, Tracknumber) values (1, '30');
323insert into SECTOR (Sectornumber, Tracknumber) values (2, '30');
324insert into SECTOR (Sectornumber, Tracknumber) values (3, '30');
325insert into SECTOR (Sectornumber, Tracknumber) values (1, '40');
326insert into SECTOR (Sectornumber, Tracknumber) values (2, '40');
327insert into SECTOR (Sectornumber, Tracknumber) values (3, '40');
328insert into SECTOR (Sectornumber, Tracknumber) values (4, '40');
329insert into SECTOR (Sectornumber, Tracknumber) values (5, '40');
330insert into SECTOR (Sectornumber, Tracknumber) values (6, '40');
331insert into SECTOR (Sectornumber, Tracknumber) values (7, '40');
332insert into SECTOR (Sectornumber, Tracknumber) values (1, '41');
333insert into SECTOR (Sectornumber, Tracknumber) values (2, '41');
334insert into SECTOR (Sectornumber, Tracknumber) values (3, '41');
335insert into SECTOR (Sectornumber, Tracknumber) values (4, '41');
336insert into SECTOR (Sectornumber, Tracknumber) values (1, '42');
337insert into SECTOR (Sectornumber, Tracknumber) values (2, '42');
338insert into SECTOR (Sectornumber, Tracknumber) values (3, '42');
339insert into SECTOR (Sectornumber, Tracknumber) values (4, '42');
340insert into SECTOR (Sectornumber, Tracknumber) values (1, '43');
341insert into SECTOR (Sectornumber, Tracknumber) values (2, '43');
342insert into SECTOR (Sectornumber, Tracknumber) values (3, '43');
343insert into SECTOR (Sectornumber, Tracknumber) values (4, '43');
344insert into SECTOR (Sectornumber, Tracknumber) values (1, '44');
345insert into SECTOR (Sectornumber, Tracknumber) values (2, '44');
346insert into SECTOR (Sectornumber, Tracknumber) values (3, '44');
347insert into SECTOR (Sectornumber, Tracknumber) values (4, '44');
348insert into SECTOR (Sectornumber, Tracknumber) values (1, '45');
349insert into SECTOR (Sectornumber, Tracknumber) values (2, '45');
350insert into SECTOR (Sectornumber, Tracknumber) values (3, '45');
351insert into SECTOR (Sectornumber, Tracknumber) values (4, '45');
352insert into SECTOR (Sectornumber, Tracknumber) values (5, '45');
353insert into SECTOR (Sectornumber, Tracknumber) values (6, '45');
354insert into SECTOR (Sectornumber, Tracknumber) values (7, '45');
355insert into SECTOR (Sectornumber, Tracknumber) values (8, '45');
356insert into SECTOR (Sectornumber, Tracknumber) values (9, '45');
357insert into SECTOR (Sectornumber, Tracknumber) values (1, '58');
358insert into SECTOR (Sectornumber, Tracknumber) values (2, '58');
359insert into SECTOR (Sectornumber, Tracknumber) values (3, '58');
360insert into SECTOR (Sectornumber, Tracknumber) values (4, '58');
361insert into SECTOR (Sectornumber, Tracknumber) values (5, '58');
362insert into SECTOR (Sectornumber, Tracknumber) values (1, '57');
363insert into SECTOR (Sectornumber, Tracknumber) values (2, '57');
364insert into SECTOR (Sectornumber, Tracknumber) values (3, '57');
365insert into SECTOR (Sectornumber, Tracknumber) values (4, '57');
366insert into SECTOR (Sectornumber, Tracknumber) values (5, '57');
367insert into SECTOR (Sectornumber, Tracknumber) values (6, '57');
368insert into SECTOR (Sectornumber, Tracknumber) values (7, '57');
369insert into SECTOR (Sectornumber, Tracknumber) values (8, '57');
370insert into SECTOR (Sectornumber, Tracknumber) values (1, '56');
371insert into SECTOR (Sectornumber, Tracknumber) values (2, '56');
372insert into SECTOR (Sectornumber, Tracknumber) values (3, '56');
373insert into SECTOR (Sectornumber, Tracknumber) values (4, '56');
374insert into SECTOR (Sectornumber, Tracknumber) values (5, '56');
375insert into SECTOR (Sectornumber, Tracknumber) values (6, '56');
376insert into SECTOR (Sectornumber, Tracknumber) values (7, '56');
377insert into SECTOR (Sectornumber, Tracknumber) values (8, '56');
378insert into SECTOR (Sectornumber, Tracknumber) values (1, '55');
379insert into SECTOR (Sectornumber, Tracknumber) values (2, '55');
380insert into SECTOR (Sectornumber, Tracknumber) values (3, '55');
381insert into SECTOR (Sectornumber, Tracknumber) values (4, '55');
382insert into SECTOR (Sectornumber, Tracknumber) values (5, '55');
383insert into SECTOR (Sectornumber, Tracknumber) values (6, '55');
384insert into SECTOR (Sectornumber, Tracknumber) values (7, '55');
385insert into SECTOR (Sectornumber, Tracknumber) values (8, '55');
386insert into SECTOR (Sectornumber, Tracknumber) values (1, '54');
387insert into SECTOR (Sectornumber, Tracknumber) values (2, '54');
388insert into SECTOR (Sectornumber, Tracknumber) values (3, '54');
389insert into SECTOR (Sectornumber, Tracknumber) values (4, '54');
390insert into SECTOR (Sectornumber, Tracknumber) values (5, '54');
391insert into SECTOR (Sectornumber, Tracknumber) values (6, '54');
392insert into SECTOR (Sectornumber, Tracknumber) values (7, '54');
393insert into SECTOR (Sectornumber, Tracknumber) values (1, '53');
394insert into SECTOR (Sectornumber, Tracknumber) values (2, '53');
395insert into SECTOR (Sectornumber, Tracknumber) values (3, '53');
396insert into SECTOR (Sectornumber, Tracknumber) values (4, '53');
397insert into SECTOR (Sectornumber, Tracknumber) values (5, '53');
398insert into SECTOR (Sectornumber, Tracknumber) values (6, '53');
399insert into SECTOR (Sectornumber, Tracknumber) values (7, '53');
400insert into SECTOR (Sectornumber, Tracknumber) values (1, '52');
401insert into SECTOR (Sectornumber, Tracknumber) values (2, '52');
402insert into SECTOR (Sectornumber, Tracknumber) values (3, '52');
403insert into SECTOR (Sectornumber, Tracknumber) values (4, '52');
404insert into SECTOR (Sectornumber, Tracknumber) values (5, '52');
405insert into SECTOR (Sectornumber, Tracknumber) values (6, '52');
406insert into SECTOR (Sectornumber, Tracknumber) values (7, '52');
407insert into SECTOR (Sectornumber, Tracknumber) values (1, '51');
408insert into SECTOR (Sectornumber, Tracknumber) values (2, '51');
409insert into SECTOR (Sectornumber, Tracknumber) values (3, '51');
410insert into SECTOR (Sectornumber, Tracknumber) values (4, '51');
411insert into SECTOR (Sectornumber, Tracknumber) values (5, '51');
412insert into SECTOR (Sectornumber, Tracknumber) values (6, '51');
413insert into SECTOR (Sectornumber, Tracknumber) values (1, '64');
414insert into SECTOR (Sectornumber, Tracknumber) values (2, '64');
415insert into SECTOR (Sectornumber, Tracknumber) values (3, '64');
416insert into SECTOR (Sectornumber, Tracknumber) values (4, '64');
417insert into SECTOR (Sectornumber, Tracknumber) values (5, '64');
418insert into SECTOR (Sectornumber, Tracknumber) values (1, '63');
419insert into SECTOR (Sectornumber, Tracknumber) values (2, '63');
420insert into SECTOR (Sectornumber, Tracknumber) values (3, '63');
421insert into SECTOR (Sectornumber, Tracknumber) values (4, '63');
422insert into SECTOR (Sectornumber, Tracknumber) values (1, '62');
423insert into SECTOR (Sectornumber, Tracknumber) values (2, '62');
424insert into SECTOR (Sectornumber, Tracknumber) values (3, '62');
425insert into SECTOR (Sectornumber, Tracknumber) values (1, '61');
426insert into SECTOR (Sectornumber, Tracknumber) values (2, '61');
427insert into SECTOR (Sectornumber, Tracknumber) values (3, '61');
428insert into SECTOR (Sectornumber, Tracknumber) values (1, '74');
429insert into SECTOR (Sectornumber, Tracknumber) values (2, '74');
430insert into SECTOR (Sectornumber, Tracknumber) values (3, '74');
431insert into SECTOR (Sectornumber, Tracknumber) values (4, '74');
432insert into SECTOR (Sectornumber, Tracknumber) values (5, '74');
433insert into SECTOR (Sectornumber, Tracknumber) values (1, '75');
434insert into SECTOR (Sectornumber, Tracknumber) values (2, '75');
435insert into SECTOR (Sectornumber, Tracknumber) values (3, '75');
436insert into SECTOR (Sectornumber, Tracknumber) values (4, '75');
437insert into SECTOR (Sectornumber, Tracknumber) values (1, '76');
438insert into SECTOR (Sectornumber, Tracknumber) values (2, '76');
439insert into SECTOR (Sectornumber, Tracknumber) values (3, '76');
440insert into SECTOR (Sectornumber, Tracknumber) values (4, '76');
441insert into SECTOR (Sectornumber, Tracknumber) values (5, '76');
442insert into SECTOR (Sectornumber, Tracknumber) values (1, '77');
443insert into SECTOR (Sectornumber, Tracknumber) values (2, '77');
444insert into SECTOR (Sectornumber, Tracknumber) values (3, '77');
445insert into SECTOR (Sectornumber, Tracknumber) values (4, '77');
446insert into SECTOR (Sectornumber, Tracknumber) values (5, '77');
447insert into SECTOR (Sectornumber, Tracknumber) values (1, '12');
448insert into SECTOR (Sectornumber, Tracknumber) values (1, '13');
449insert into SECTOR (Sectornumber, Tracknumber) values (1, '14');
450insert into SECTOR (Sectornumber, Tracknumber) values (1, '15');
451insert into SECTOR (Sectornumber, Tracknumber) values (1, '16');
452insert into SECTOR (Sectornumber, Tracknumber) values (1, '17');
453insert into SECTOR (Sectornumber, Tracknumber) values (1, '18');
454insert into SECTOR (Sectornumber, Tracknumber) values (1, '19');
455insert into SECTOR (Sectornumber, Tracknumber) values (1, '20');
456insert into SECTOR (Sectornumber, Tracknumber) values (1, '21');
457
458-- TramType
459insert into TRAMTYPE (Tramtype, Length) values ('Combino','1');
460insert into TRAMTYPE (Tramtype, Length) values ('11G','1');
461insert into TRAMTYPE (Tramtype, Length) values ('DKCombino','1');
462insert into TRAMTYPE (Tramtype, Length) values ('12G','1');
463insert into TRAMTYPE (Tramtype, Length) values ('Education','1');
464
465-- Tram - Combino
466insert 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');
467insert 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);
468insert 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');
469insert 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');
470insert 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');
471insert 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');
472insert 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');
473insert 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);
474insert 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');
475insert 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');
476insert 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);
477insert 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');
478insert 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');
479insert 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');
480insert 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);
481insert 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');
482insert 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');
483insert 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');
484insert 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);
485insert 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');
486insert 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);
487insert 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');
488insert 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');
489insert 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');
490insert 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');
491insert 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');
492insert 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');
493insert 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');
494insert 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');
495insert 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');
496insert 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');
497insert 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');
498insert 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');
499insert 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');
500insert 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');
501insert 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);
502insert 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');
503insert 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);
504insert 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);
505insert 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');
506insert 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');
507insert 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');
508insert 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');
509insert 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');
510insert 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');
511insert 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');
512insert 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');
513insert 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');
514insert 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);
515insert 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);
516insert 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');
517insert 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');
518insert 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');
519insert 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');
520insert 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');
521insert 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');
522insert 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');
523insert 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);
524insert 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');
525insert 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');
526insert 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');
527insert 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');
528insert 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');
529insert 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');
530insert 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');
531insert 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');
532insert 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');
533insert 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');
534insert 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');
535insert 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');
536insert 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);
537insert 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
540insert 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');
541insert 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');
542insert 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');
543insert 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
546insert 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');
547insert 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');
548insert 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');
549insert 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');
550insert 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');
551insert 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');
552insert 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');
553insert 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');
554insert 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');
555insert 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);
556insert 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');
557insert 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');
558insert 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);
559insert 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);
560insert 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');
561insert 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');
562insert 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');
563insert 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);
564insert 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');
565insert 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
568insert 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);
569insert 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');
570insert 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);
571insert 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');
572insert 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);
573insert 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');
574insert 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);
575insert 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');
576insert 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);
577insert 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');
578insert 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');
579insert 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');
580insert 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');
581insert 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');
582insert 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');
583insert 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');
584insert 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);
585insert 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');
586insert 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);
587insert 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');
588insert 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);
589insert 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');
590insert 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');
591insert 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');
592insert 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
595insert 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);
596insert 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
599insert into CLEANING (CleanDate, CleanType) values ('2017-03-31', 'BigCleanService');
600insert into CLEANING (CleanDate, CleanType) values ('2016-04-12', 'SmallCleanService');
601insert into CLEANING (CleanDate, CleanType) values ('2017-03-01', 'BigCleanService');
602insert into CLEANING (CleanDate, CleanType) values ('2017-01-30', 'SmallCleanService');
603insert into CLEANING (CleanDate, CleanType) values ('2016-08-18', 'BigCleanService');
604insert into CLEANING (CleanDate, CleanType) values ('2016-05-09', 'SmallCleanService');
605insert into CLEANING (CleanDate, CleanType) values ('2016-05-03', 'BigCleanService');
606insert into CLEANING (CleanDate, CleanType) values ('2017-05-11', 'SmallCleanService');
607insert into CLEANING (CleanDate, CleanType) values ('2017-06-20', 'BigCleanService');
608insert into CLEANING (CleanDate, CleanType) values ('2017-07-28', 'SmallCleanService');
609
610-- Repair
611insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-06-20', 'Wiel kapot', 'SmallMaintenanceService');
612insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-02-26', 'Wiel kapot', 'BigMaintenanceService');
613insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-02-24', 'Wiel kapot', 'SmallMaintenanceService');
614insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-05-03', 'Raam kapot', 'BigMaintenanceService');
615insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-02-12', 'Motor kapot', 'SmallMaintenanceService');
616insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-04-17', 'Raam kapot', 'BigMaintenanceService');
617insert into REPAIR (RepairDate, Comment, ServiceType) values ('2016-06-01', 'Raam kapot', 'SmallMaintenanceService');
618insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-10-12', 'Deur kapot', 'BigMaintenanceService');
619insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-08-23', 'Wiel kapot', 'SmallMaintenanceService');
620insert into REPAIR (RepairDate, Comment, ServiceType) values ('2017-08-05', 'Motor kapot', 'BigMaintenanceService');
621
622-- CleaningRule
623insert into CLEANINGRULE (TramNumber, CleaningID) values ('2001','1');
624insert into CLEANINGRULE (TramNumber, CleaningID) values ('2002','2');
625insert into CLEANINGRULE (TramNumber, CleaningID) values ('2003','3');
626insert into CLEANINGRULE (TramNumber, CleaningID) values ('2004','4');
627insert into CLEANINGRULE (TramNumber, CleaningID) values ('2005','5');
628insert into CLEANINGRULE (TramNumber, CleaningID) values ('2006','6');
629insert into CLEANINGRULE (TramNumber, CleaningID) values ('2007','7');
630insert into CLEANINGRULE (TramNumber, CleaningID) values ('2008','8');
631insert into CLEANINGRULE (TramNumber, CleaningID) values ('2009','9');
632insert into CLEANINGRULE (TramNumber, CleaningID) values ('2010','10');
633
634-- RepairRule
635insert into REPAIRRULE (TramNumber, RepairID) values ('2011','1');
636insert into REPAIRRULE (TramNumber, RepairID) values ('2012','2');
637insert into REPAIRRULE (TramNumber, RepairID) values ('2013','3');
638insert into REPAIRRULE (TramNumber, RepairID) values ('2014','4');
639insert into REPAIRRULE (TramNumber, RepairID) values ('2015','5');
640insert into REPAIRRULE (TramNumber, RepairID) values ('2016','6');
641insert into REPAIRRULE (TramNumber, RepairID) values ('2017','7');
642insert into REPAIRRULE (TramNumber, RepairID) values ('2018','8');
643insert into REPAIRRULE (TramNumber, RepairID) values ('2019','9');
644insert into REPAIRRULE (TramNumber, RepairID) values ('2020','10');
645
646-- Employee - Data
647insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Tom', 'de Wildt', 'Manager', 'Roerdomp 21', 'Sint-Michielsgestel', 'Tomdewildt@ziggo.nl');
648insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Simon', 'van Someren', 'Depotmanager', 'Avondrood 16', 'Deurne', 'Simonvansomeren@outlock.com');
649insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Liwei', 'Hu', 'Technician', 'Gitaarstraat 4', 'Venray', 'Liweihu12@gmail.com');
650insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Roberto', 'de Wolff', 'Cleaner', 'Udenstraat 2', 'Uden', 'Roberto.dewolff@student.fontys.nl');
651insert 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
653insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Terry', 'Coleman', 'Machinist', '467 Leroy Center', 'Colca', 'tcoleman0@goodreads.com');
654insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Arthur', 'Nichols', 'Depotmanager', '9 Crescent Oaks Street', 'Bardiyah', 'anichols@yellowbook.com');
655insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Amy', 'Harper', 'Cleaner', '46386 Scott Center', 'Kala Dondra', 'aharper2@omniture.com');
656insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Amanda', 'Mills', 'Machinist', '3 Merrick Way', 'Vidnoye', 'amills3@yahoo.com');
657insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Roy', 'James', 'Technician', '72638 Manley Court', 'Santa Maria Chiquimula', 'rjames4@mail.ru');
658insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Andrea', 'Howard', 'Cleaner', '529 Bunting Hill', 'El Banco', 'ahoward5@wordpress.com');
659insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Joan', 'Matthews', 'Technician', '04 Westerfield Place', 'General Belgrano', 'jmatthews6@bluehost.com');
660insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Theresa', 'Mcdonald', 'Machinist', '02 Michigan Point', 'Volokolamsk', 'tmcdonald7@multiply.com');
661insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Diana', 'Ellis', 'Machinist', '9 Swallow Alley', 'San Cristabal', 'dellis8@bigcartel.com');
662insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Carolyn', 'Gray', 'Depotmanager', '6 Express Point', 'Sharm el-Sheikh', 'cgray9@icq.com');
663insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Sandra', 'Murphy', 'Machinist', '7 Village Parkway', 'Hoves', 'smurphya@elpais.com');
664insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Judith', 'Wells', 'Cleaner', '04539 Vernon Parkway', 'Vetrino', 'jwellsb@sciencedaily.com');
665insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Jeffrey', 'Stone', 'Technician', '347 Arrowood Park', 'Puchong', 'jstonec@nih.gov');
666insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Willie', 'Chapman', 'Machinist', '256 Leroy Drive', 'Laibin', 'wchapmand@google.co.jp');
667insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Henry', 'Hughes', 'Depotmanager', '0 Debs Way', 'Canhas', 'hhughese@house.gov');
668insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Juan', 'Dean', 'Machinist', '57424 Merry Crossing', 'Santa Cruz', 'jdeanf@google.com.br');
669insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Bobby', 'Rice', 'Cleaner', '0 Longview Terrace', 'Klatakan', 'briceg@mediafire.com');
670insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Joan', 'Stevens', 'Cleaner', '3 Coolidge Lane', 'Mufushan', 'jstevensh@cbc.ca');
671insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'James', 'Gilbert', 'Depotmanager', '67 Golf Course Avenue', 'Aylmer', 'jgilberti@discovery.com');
672insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Billy', 'Gonzales', 'Technician', '27640 Luster Park', 'Ayna', 'bgonzalesj@archive.org');
673insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Alan', 'Howard', 'Cleaner', '5 Washington Avenue', 'Cuamba', 'ahowardk@java.com');
674insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Kathleen', 'Hill', 'Depotmanager', '67690 Hintze Pass', 'Pamiatkowo', 'khilll@joomla.org');
675insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Janet', 'Burns', 'Technician', '6 Lukken Road', 'Villeneuve-la-Garenne', 'jburnsm@jugem.jp');
676insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Sara', 'Carroll', 'Cleaner', '306 Surrey Center', 'Kuching', 'scarrolln@sogou.com');
677insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Harry', 'Gray', 'Machinist', '783 Sullivan Plaza', 'Vilaka', 'hgrayo@instagram.com');
678insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Joyce', 'Perry', 'Cleaner', '0572 Dayton Lane', 'Shuanggang', 'jperryp@time.com');
679insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Michael', 'Alvarez', 'Depotmanager', '5339 Fuller Point', 'Xam Nua', 'malvarezq@nhs.uk');
680insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Karen', 'Washington', 'Machinist', '0964 Emmet Terrace', 'Nyakhachava', 'kwashingtonr@wordpress.org');
681insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'George', 'Ryan', 'Cleaner', '8078 Melvin Center', 'Urpay', 'gryans@un.org');
682insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Antonio', 'Perkins', 'Depotmanager', '774 Lotheville Place', 'Phatthana Nikhom', 'aperkinst@ed.gov');
683insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Stephen', 'Nguyen', 'Depotmanager', '8 Linden Parkway', 'Nerkin Getashen', 'snguyenu@ovh.net');
684insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Cynthia', 'Hunter', 'Depotmanager', '0789 Evergreen Alley', 'Loreto', 'chunterv@salon.com');
685insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Rose', 'Grant', 'Depotmanager', '92296 Ruskin Hill', 'Lam Plai Mat', 'rgrantw@ftc.gov');
686insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Ernest', 'Morales', 'Machinist', '8399 Susan Plaza', 'Madamba', 'emoralesx@wiley.com');
687insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Shawn', 'Powell', 'Technician', '0727 Washington Avenue', 'Port Glaud', 'spowelly@squarespace.com');
688insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Chris', 'Alvarez', 'Depotmanager', '32926 Lakeland Avenue', 'Mburukullu', 'calvarezz@dailymail.co.uk');
689insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Stephen', 'Taylor', 'Machinist', '64 Springview Center', 'Thala', 'staylor0@jiathis.com');
690insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Shirley', 'Harris', 'Cleaner', '289 Sunbrook Trail', 'Nirasaki', 'sharris@surveymonkey.com');
691insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Henry', 'Vasquez', 'Machinist', '66 Sunnyside Center', 'Zhuji', 'hvasquez2@omniture.com');
692insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Randy', 'Lawrence', 'Cleaner', '30799 Sutherland Place', 'Puerto Quijarro', 'rlawrence3@sogou.com');
693insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Carol', 'Perry', 'Machinist', '66923 Vera Point', 'Bongsri', 'cperry4@thetimes.co.uk');
694insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Chris', 'Woods', 'Depotmanager', '7942 Elka Crossing', 'Ronninge', 'cwoods5@spotify.com');
695insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Keith', 'Lane', 'Cleaner', '6759 New Castle Alley', 'Sacramento', 'klane6@blogs.com');
696insert into EMPLOYEE (DepotID, Firstname, Lastname, "Function", Adress, Location, Email) values ('1', 'Jack', 'Hudson', 'Depotmanager', '393 Crowley Circle', 'Willemstad', 'jhudson7@tmall.com');
697insert 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
700insert into TECHNICIAN (RepairID, EmployeeID) values ('1','3');
701insert into TECHNICIAN (RepairID, EmployeeID) values ('2','10');
702insert into TECHNICIAN (RepairID, EmployeeID) values ('3','12');
703insert into TECHNICIAN (RepairID, EmployeeID) values ('4','18');
704insert into TECHNICIAN (RepairID, EmployeeID) values ('5','25');
705insert into TECHNICIAN (RepairID, EmployeeID) values ('6','28');
706insert into TECHNICIAN (RepairID, EmployeeID) values ('7','40');
707insert into TECHNICIAN (RepairID, EmployeeID) values ('8','50');
708insert into TECHNICIAN (RepairID, EmployeeID) values ('9','3');
709insert into TECHNICIAN (RepairID, EmployeeID) values ('10','10');
710
711-- Cleaner
712insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('1','4','1');
713insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('2','8','0');
714insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('3','11','0');
715insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('4','17','0');
716insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('5','22','0');
717insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('6','23','0');
718insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('7','26','0');
719insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('8','29','0');
720insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('9','31','0');
721insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values ('10','34','0');
722insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values (null,'43','0');
723insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values (null,'45','0');
724insert into CLEANER (CleaningID, EmployeeID, HeadCleaner) values (null,'48','0');
725
726-- Manager
727insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','1','1');
728insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','2','0');
729insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','7','0');
730insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','15','0');
731insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','20','0');
732insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','24','0');
733insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','27','0');
734insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','32','0');
735insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','35','0');
736insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','36','0');
737insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','37','0');
738insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','38','0');
739insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','41','0');
740insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','47','0');
741insert into MANAGER (DepotID, EmployeeID, Depotmanager) values ('1','49','0');
742
743-- Machinist
744insert into MACHINIST (EmployeeID) values ('5');
745insert into MACHINIST (EmployeeID) values ('6');
746insert into MACHINIST (EmployeeID) values ('9');
747insert into MACHINIST (EmployeeID) values ('13');
748insert into MACHINIST (EmployeeID) values ('14');
749insert into MACHINIST (EmployeeID) values ('16');
750insert into MACHINIST (EmployeeID) values ('19');
751insert into MACHINIST (EmployeeID) values ('21');
752insert into MACHINIST (EmployeeID) values ('30');
753insert into MACHINIST (EmployeeID) values ('33');
754insert into MACHINIST (EmployeeID) values ('39');
755insert into MACHINIST (EmployeeID) values ('42');
756insert into MACHINIST (EmployeeID) values ('44');
757insert into MACHINIST (EmployeeID) values ('46');
758
759-- MachinistRule
760insert into MACHINISTRULE (MachinistID, TramNumber) values ('1','2001');
761insert into MACHINISTRULE (MachinistID, TramNumber) values ('2','2002');
762insert into MACHINISTRULE (MachinistID, TramNumber) values ('3','2003');
763insert into MACHINISTRULE (MachinistID, TramNumber) values ('4','2004');
764insert into MACHINISTRULE (MachinistID, TramNumber) values ('5','2005');
765insert into MACHINISTRULE (MachinistID, TramNumber) values ('6','2006');
766insert into MACHINISTRULE (MachinistID, TramNumber) values ('7','2007');
767insert into MACHINISTRULE (MachinistID, TramNumber) values ('8','2008');
768insert into MACHINISTRULE (MachinistID, TramNumber) values ('9','2009');
769insert into MACHINISTRULE (MachinistID, TramNumber) values ('10','2010');
770insert into MACHINISTRULE (MachinistID, TramNumber) values ('11','2011');
771insert into MACHINISTRULE (MachinistID, TramNumber) values ('12','2012');
772insert into MACHINISTRULE (MachinistID, TramNumber) values ('13','2013');
773insert into MACHINISTRULE (MachinistID, TramNumber) values ('14','2014');