INSERT INTO TST_EXTRAS ( EXT_ID, EXT_NAME ) VALUES ( 
5, 'Klimaanlage'); 
INSERT INTO TST_EXTRAS ( EXT_ID, EXT_NAME ) VALUES ( 
6, 'Automatikgetriebe'); 
commit;
 
INSERT INTO TST_VERMIETER ( VRM_ID, VRM_NAME ) VALUES (
2, 'Juris used Cars');
INSERT INTO TST_VERMIETER ( VRM_ID, VRM_NAME ) VALUES (
3, 'Karls Luxuskutschen');
INSERT INTO TST_VERMIETER ( VRM_ID, VRM_NAME ) VALUES (
4, 'Yamatos Joghurtbecher');
commit;


INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
11, 'Wolga', 2); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
12, 'Lada', 2); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
13, 'Wartburg', 2); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
14, 'Tschaika', 2); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
15, 'Skoda', 2); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
16, 'Mercedes', 3); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
17, 'Rolls Royce', 3); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
18, 'Maybach', 3); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
19, 'Bentley', 3); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
20, 'Ferrari', 3); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
21, 'Toyota', 4); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
22, 'Honda', 4); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
23, 'Mazda', 4); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
24, 'Nissan', 4); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
25, 'Suzuki', 4); 
INSERT INTO TST_FAHRZEUGE ( FHZ_ID, FHZ_NAME, FHZ_VRM_ID ) VALUES ( 
26, 'Lexus', 4); 
commit;
 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
27, 16, 5); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
28, 16, 6); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
29, 18, 5); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
30, 19, 5); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
31, 19, 6); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
32, 17, 5); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
33, 21, 5); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
34, 24, 5); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
35, 26, 5); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
36, 26, 6); 
INSERT INTO TST_FHZ_EXT_INT ( FEI_ID, FEI_FHZ_ID, FEI_EXT_ID ) VALUES ( 
37, 11, 6); 
commit;