INSERT INTO cars (name) VALUES ('SLK (R171)');
INSERT INTO cars (name) VALUES ('SL (R230)');
INSERT INTO cars (name) VALUES ('SLK (R170)');

INSERT INTO subassemblies (name,filename_image,scale_image,pos_x,pos_y,pos_z,dir_x,dir_y,dir_z) VALUES ('Linke Tuer','/home/dcag/images/tl_subassembly.png',300,5,10,20,10,12,20);
INSERT INTO subassemblies (name,filename_image,scale_image,pos_x,pos_y,pos_z,dir_x,dir_y,dir_z) VALUES ('Rechte Tuer','/home/dcag/images/tr_subassembly.png',300,20,30,10,50,10,30);
INSERT INTO subassemblies (name,filename_image,scale_image,pos_x,pos_y,pos_z,dir_x,dir_y,dir_z) VALUES ('Linker Kotfluegel vorne','/home/dcag/images/lkv_subassembly.png',300,12,60,20,75,64,14);
INSERT INTO subassemblies (name,filename_image,scale_image,pos_x,pos_y,pos_z,dir_x,dir_y,dir_z) VALUES ('Rechter Kotfluegel vorne','/home/dcag/images/rkv_subassembly.png',300,5,10,10,0,84,12);
INSERT INTO subassemblies (name,filename_image,scale_image,pos_x,pos_y,pos_z,dir_x,dir_y,dir_z) VALUES ('Linker Kotfluegel hinten','/home/dcag/images/lkh_subassembly.png',300,90,65,12,11,75,29);
INSERT INTO subassemblies (name,filename_image,scale_image,pos_x,pos_y,pos_z,dir_x,dir_y,dir_z) VALUES ('Rechter Kotfluegel hinten','/home/dcag/images/rkh_subassembly.png',300,5,12,55,12,56,12);


INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (607169,10,50,5,1,1,'Achse 3, Roboter 5','Herr Meier, Tel: 1234');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (600061,20,70,10,1,1,'Achse 3, Roboter 5','Herr Meier, Tel: 1234');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (600049,30,20,7,1,1,'Achse 3, Roboter 6','Herr Meier, Tel: 1234');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (607145,60,55,25,2,2,'Achse 1, Roboter 3','Herr Scholz, Tel: 4232');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (617169,10,50,30,2,2,'Achse 1, Roboter 4','Herr Scholz, Tel: 4232');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (600008,90,11,25,2,2,'Achse 1, Roboter 3','Herr Scholz, Tel: 4232');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (600007,70,10,25,2,2,'Achse 1, Roboter 3','Herr Scholz, Tel: 4232');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (600006,50,10,45,2,2,'Achse 1, Roboter 3','Herr Scholz, Tel: 4232');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (600005,30,10,15,2,2,'Achse 2, Roboter 4','Herr Scholz, Tel: 4232');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (600004,20,35,15,2,2,'Achse 1, Roboter 6','Herr Scholz, Tel: 4232');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (600003,10,25,15,2,2,'Achse 1, Roboter 1','Herr Scholz, Tel: 4232');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (611169,10,50,5,1,3,'Achse 1, Roboter 2','Herr Nicolas, Tel: 1211');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (611269,10,50,5,1,3,'Achse 1, Roboter 2','Herr Nicolas, Tel: 1211');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (611179,70,10,55,1,4,'Achse 1, Roboter 2','Herr Nicolas, Tel: 1211');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (611189,17,51,45,1,5,'Achse 1, Roboter 2','Herr Nicolas, Tel: 1211');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (611119,10,50,5,3,1,'Achse 3, Roboter 5','Herr Meier, Tel: 1234');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (601169,10,20,15,3,6,'Achse 3, Roboter 5','Herr Meier, Tel: 1234');
INSERT INTO weldpoints (name,x,y,z,cartype,subassembly,axe_robot,technician_tel) VALUES (607119,10,50,5,1,4,'Achse 3, Roboter 5','Herr Meier, Tel: 1234');

INSERT INTO usedweldpoints (name,marked) VALUES (600005,true);
INSERT INTO usedweldpoints (name,marked) VALUES (600049,true);
INSERT INTO usedweldpoints (name,marked) VALUES (600061,false);
INSERT INTO usedweldpoints (name,marked) VALUES (607119,true);
INSERT INTO usedweldpoints (name,marked) VALUES (607145,false);
INSERT INTO usedweldpoints (name,marked) VALUES (607169,false);
INSERT INTO usedweldpoints (name,marked) VALUES (611119,false);
INSERT INTO usedweldpoints (name,marked) VALUES (611169,false);
