-- -- Table structure for table brand -- DROP TABLE IF EXISTS brand; CREATE TABLE brand ( id int NOT NULL , brand varchar(50) NOT NULL, PRIMARY KEY (id) ); -- -- Content of table brand -- insert into brand (id,brand) values (1,'Jaguar'); insert into brand (id,brand) values (2,'Land Rover'); insert into brand (id,brand) values (3,'BMW'); insert into brand (id,brand) values (4,'Mercedes'); insert into brand (id,brand) values (5,'Hyundai'); insert into brand (id,brand) values (6,'Chevrolet'); insert into brand (id,brand) values (7,'Jeep'); insert into brand (id,brand) values (8,'Chrysler'); insert into brand (id,brand) values (9,'Toyota'); insert into brand (id,brand) values (10,'Honda'); insert into brand (id,brand) values (11,'Opel'); insert into brand (id,brand) values (12,'Saab'); insert into brand (id,brand) values (13,'Volkswagen'); insert into brand (id,brand) values (14,'Porsche'); insert into brand (id,brand) values (15,'Ford'); -- -- Table structure for table car -- DROP TABLE IF EXISTS car; CREATE TABLE car ( id int NOT NULL , model_id int NOT NULL, new_used_id int NOT NULL, garage_id int NOT NULL, mileage int NOT NULL, color varchar(20) NOT NULL, date date , price double, PRIMARY KEY (id) ); -- -- Content of table brand -- insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (1,1,1,7,0,'green','2006-08-07',78000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (2,1,2,7,45678,'black','1995-03-03',15000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (3,1,1,7,0,'black','2006-08-07',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (4,1,1,7,0,'blue','2006-08-07',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (5,1,1,7,0,'silver','2006-08-07',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (6,1,2,7,12000,'silver','2006-08-07',12500.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (7,2,2,7,10000,'red','2006-08-07',13500.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (8,1,1,7,0,'green','2006-08-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (9,1,1,7,0,'silver','2006-08-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (10,1,2,7,45000,'silver','1995-03-03',3500.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (11,1,2,1,45000,'black','1995-03-03',10700.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (12,2,2,1,25000,'pink','1995-03-03',6500.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (13,2,1,7,0,'blue','2006-08-08',56000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (14,2,1,7,0,'black','2006-08-08',56000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (15,2,1,7,0,'green','2006-08-08',56000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (16,3,1,7,0,'blue','2006-08-08',125000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (17,3,1,7,0,'black','2006-08-08',125000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (18,3,2,7,78000,'black','1995-03-03',21000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (19,3,2,6,50000,'black','1995-03-03',25000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (20,4,1,7,0,'black','2006-08-08',150000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (21,4,1,7,0,'red','2006-08-08',150000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (22,4,1,7,0,'blue','2006-08-08',150000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (23,4,1,7,0,'green','2006-08-08',150000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (24,4,2,7,12300,'green','2005-07-03',88900.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (25,4,2,7,5000,'green','2005-07-03',136000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (26,5,1,7,0,'green','2006-08-08',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (27,5,1,7,0,'greenblack','2006-08-08',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (28,5,1,7,0,'black','2006-08-08',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (29,5,1,7,0,'red','2006-08-08',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (30,5,1,7,0,'yellow','2006-08-08',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (31,5,2,7,50000,'brown','1995-03-03',8000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (32,5,2,7,30000,'brown','1995-03-03',10000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (33,5,2,3,30000,'brown','1995-03-03',10000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (34,5,2,8,30000,'brown','1995-03-03',10000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (35,6,1,2,0,'green','2006-08-08',54000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (36,6,1,2,0,'black','2006-08-08',54000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (37,6,1,2,0,'blue','2006-08-08',54000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (38,6,1,2,0,'silver','2006-08-08',54000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (39,6,2,2,8000,'silver','2005-07-03',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (40,6,2,2,15000,'black','2005-06-30',15000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (41,6,2,8,15000,'black','2005-06-30',15000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (42,7,1,2,0,'black','2006-08-08',58000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (43,7,1,2,0,'blue','2006-08-08',58000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (44,7,1,2,0,'black','2006-08-08',58000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (45,7,1,2,0,'yellow','2006-08-08',58000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (46,7,1,2,0,'silver','2006-08-08',58000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (47,7,2,2,8000,'silver','2005-07-03',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (48,7,2,1,9000,'black','2005-07-03',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (49,8,1,2,0,'black','2006-08-08',57000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (50,8,1,2,0,'blue','2006-08-08',57000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (51,8,1,2,0,'silver','2006-08-08',57000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (52,8,1,2,0,'green','2006-08-08',57000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (53,8,2,2,34000,'green','1995-03-03',17000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (54,8,2,1,34000,'green','1995-03-03',17000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (55,8,2,7,12000,'blue','2005-07-03',47000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (56,9,1,2,0,'blue','2006-08-08',78000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (57,9,1,2,0,'black','2006-08-08',78000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (58,9,1,2,0,'green','2006-08-08',78000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (59,9,1,2,0,'silver','2006-08-08',78000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (60,9,1,2,0,'red','2006-08-08',78000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (61,9,2,2,10000,'red','2005-07-03',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (62,9,2,2,15000,'black','2005-07-03',43000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (63,9,2,4,15000,'black','2005-07-03',43000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (64,9,2,4,75000,'green','1995-03-03',13000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (65,10,1,2,0,'green','2006-08-08',89000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (66,10,1,2,0,'black','2006-08-08',89000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (67,10,1,2,0,'blue','2006-08-08',89000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (68,10,1,2,0,'red','2006-08-08',89000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (69,10,1,2,0,'silver','2006-08-08',89000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (70,10,2,2,23500,'yellow','2006-08-08',19000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (71,11,1,2,0,'black','2006-08-08',178000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (72,11,2,2,2000,'black','2004-08-08',108000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (73,11,1,2,0,'blue','2006-08-08',178000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (74,11,1,2,0,'silver','2006-08-08',178000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (75,12,1,2,0,'silver','2006-08-08',148000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (76,12,1,2,0,'blue','2006-08-08',148000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (77,12,1,2,0,'black','2006-08-08',148000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (78,12,2,2,35000,'black','2003-08-08',88000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (79,12,2,5,30000,'blue','2003-08-08',98000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (80,13,1,2,0,'blue','2006-08-08',108000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (81,13,1,2,0,'black','2006-08-08',108000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (82,13,1,2,0,'red','2006-08-08',108000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (83,17,1,2,0,'blue','2006-08-08',158000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (84,17,1,2,0,'black','2006-08-08',158000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (85,17,1,2,0,'black','2006-08-08',158000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (86,17,1,2,0,'silver','2006-08-08',158000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (87,18,1,8,0,'silver','2006-08-08',34000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (88,18,1,8,0,'red','2006-08-08',34000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (89,18,1,8,0,'blue','2006-08-08',34000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (90,18,1,8,0,'black','2006-08-08',34000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (91,18,1,8,0,'grey','2006-08-08',34000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (92,18,1,8,0,'yellow','2006-08-08',34000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (93,18,2,8,10000,'blue','2004-08-08',24000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (94,18,2,3,10000,'blue','2004-08-08',24000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (95,18,2,3,20000,'blue','2003-08-08',18000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (96,19,2,3,25000,'blue','2003-08-08',22000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (97,19,2,3,125000,'red','1994-08-08',2000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (98,19,1,8,0,'red','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (99,19,1,8,0,'blue','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (100,19,1,8,0,'yellow','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (101,19,1,8,0,'lightblue','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (102,19,1,8,0,'green','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (103,19,1,8,0,'pink','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (104,20,1,8,0,'black','2006-08-08',39000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (105,20,1,8,0,'silver','2006-08-08',39000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (106,20,2,4,18000,'silver','2005-08-08',29000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (107,20,2,4,23500,'black','2005-08-08',29000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (108,21,1,8,0,'black','2006-08-08',36000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (109,21,1,8,0,'blue','2006-08-08',36000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (110,21,1,8,0,'lightgreen','2006-08-08',36000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (111,21,1,8,0,'brown','2006-08-08',36000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (112,21,1,8,0,'gold','2006-08-08',36000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (113,21,1,8,0,'blue','2006-08-08',36000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (114,21,2,8,1000,'blue','2005-08-08',32000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (115,21,2,8,15000,'blue','2004-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (116,22,1,8,0,'blue','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (117,22,1,8,0,'yellow','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (118,22,1,8,0,'silver','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (119,22,1,8,0,'grey','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (120,22,1,8,0,'cyan','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (121,22,1,8,0,'brown','2006-08-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (122,23,1,8,0,'brown','2006-08-08',29000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (123,23,1,8,0,'orange','2006-08-08',29000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (124,23,1,8,0,'blue','2006-08-08',29000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (125,23,1,8,0,'occre','2006-08-08',29000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (126,23,1,8,0,'red','2006-08-08',29000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (127,23,1,8,0,'white','2006-08-08',29000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (128,24,1,8,0,'white','2006-08-08',32000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (129,24,1,8,0,'silver','2006-08-08',32000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (130,24,1,8,0,'red','2006-08-08',32000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (131,24,1,8,0,'blue','2006-08-08',32000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (132,24,1,8,0,'black','2006-08-08',32000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (133,24,2,2,15000,'black','2002-06-08',16000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (134,24,2,2,16000,'red','2003-06-08',18000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (135,25,1,8,0,'red','2006-08-08',39000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (136,25,1,8,0,'silver','2006-08-08',39000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (137,25,1,8,0,'black','2006-08-08',39000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (138,26,1,8,0,'black','2006-08-08',59000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (139,27,1,8,0,'blue','2006-08-08',60000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (140,27,1,8,0,'red','2006-08-08',60000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (141,27,1,8,0,'silver','2006-08-08',60000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (142,27,2,6,25000,'blue','2003-11-08',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (143,34,1,8,0,'blue','2006-08-08',123000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (144,34,1,8,0,'black','2006-08-08',123000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (145,34,1,8,0,'silver','2006-08-08',123000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (146,34,1,8,0,'white','2006-08-08',123000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (147,34,1,8,0,'red','2006-08-08',123000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (148,38,2,8,34500,'blue','2002-08-08',67000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (149,39,2,8,28000,'black','2003-08-08',37000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (150,39,1,8,0,'black','2006-08-08',48000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (151,39,1,8,0,'blue','2006-08-08',48000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (152,39,1,8,0,'silver','2006-08-08',48000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (153,40,1,1,0,'silver','2006-08-08',88000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (154,40,1,1,0,'black','2006-08-08',88000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (155,41,1,1,0,'black','2006-08-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (156,41,1,1,0,'green','2006-08-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (157,41,1,1,0,'silver','2006-08-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (158,41,1,1,0,'blue','2006-08-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (159,41,2,1,15000,'blue','2005-05-08',25000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (160,41,2,1,18000,'red','2005-05-08',24000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (161,42,1,1,0,'red','2006-08-08',32000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (162,42,1,1,0,'blue','2006-08-08',32000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (163,42,1,1,0,'black','2006-08-08',32000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (164,45,1,1,0,'black','2006-08-08',68000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (165,45,1,1,0,'silver','2006-08-08',68000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (166,45,1,1,0,'white','2006-08-08',68000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (167,45,1,1,0,'red','2006-08-08',68000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (168,46,1,1,0,'red','2006-08-08',89000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (169,46,1,1,0,'black','2006-08-08',89000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (170,48,1,1,0,'black','2006-08-08',59000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (171,48,1,1,0,'blue','2006-08-08',59000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (172,54,1,3,0,'blue','2006-08-08',43000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (173,54,1,3,0,'silver','2006-08-08',43000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (174,54,1,3,0,'black','2006-08-08',43000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (175,54,1,3,0,'red','2006-08-08',43000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (176,54,2,3,15000,'red','2005-11-08',33000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (177,54,2,12,18000,'red','2005-11-08',33000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (178,55,1,9,0,'red','2006-11-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (179,55,1,9,0,'black','2006-11-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (180,55,1,9,0,'yellow','2006-11-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (181,56,1,9,0,'blue','2006-11-08',55000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (182,56,1,9,0,'red','2006-11-08',55000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (183,56,1,9,0,'orange','2006-11-08',55000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (184,57,1,9,0,'red','2006-11-08',15000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (185,57,1,9,0,'pink','2006-11-08',15000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (186,57,1,9,0,'lightblue','2006-11-08',15000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (187,58,1,9,0,'black','2006-11-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (188,58,1,9,0,'blue','2006-11-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (189,58,1,9,0,'red','2006-11-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (190,59,1,10,0,'red','2006-11-08',13000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (191,59,1,10,0,'blue','2006-11-08',13000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (192,59,1,10,0,'white','2006-11-08',13000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (193,60,1,10,0,'white','2006-11-08',15000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (194,60,1,10,0,'red','2006-11-08',15000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (195,60,1,10,0,'black','2006-11-08',15000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (196,61,1,10,0,'black','2006-11-08',16000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (197,61,1,10,0,'yellow','2006-11-08',16000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (198,61,1,10,0,'blue','2006-11-08',16000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (199,62,1,13,0,'blue','2006-11-08',36000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (200,62,1,13,0,'red','2006-11-08',36000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (201,62,1,13,0,'brown','2006-11-08',36000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (202,63,1,13,0,'brown','2006-11-08',46000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (203,63,1,13,0,'blue','2006-11-08',46000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (204,63,1,13,0,'silver','2006-11-08',46000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (205,64,1,13,0,'black','2006-11-08',55000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (206,64,1,13,0,'blue','2006-11-08',55000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (207,64,1,13,0,'green','2006-11-08',55000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (208,65,1,13,0,'grey','2006-11-08',85000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (209,65,1,12,0,'grey','2006-11-08',85000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (210,65,1,13,0,'black','2006-11-08',85000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (211,66,1,13,0,'black','2006-11-08',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (212,66,1,13,0,'blue','2006-11-08',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (213,66,1,13,0,'silver','2006-11-08',45000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (214,67,1,13,0,'silver','2006-11-08',48000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (215,67,1,13,0,'red','2006-11-08',48000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (216,67,1,13,0,'black','2006-11-08',48000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (217,68,1,13,0,'green','2006-11-08',38000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (218,73,1,9,0,'silver','2006-11-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (219,73,1,9,0,'blue','2006-11-08',28000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (220,72,1,9,0,'blue','2006-11-08',26000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (221,72,1,9,0,'black','2006-11-08',26000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (222,74,1,9,0,'black','2006-11-08',34000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (223,74,1,9,0,'blue','2006-11-08',34000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (224,75,1,9,0,'blue','2006-11-08',54000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (225,76,2,9,25000,'pink','2006-11-08',14000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (226,77,2,6,25000,'yellow','2003-11-08',4000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (227,77,1,6,0,'black','2006-08-08',14000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (228,77,1,6,0,'red','2006-08-08',14000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (229,80,1,6,0,'red','2006-08-08',18000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (230,80,1,6,0,'silver','2006-08-08',18000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (231,89,1,10,0,'silver','2006-08-08',18000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (232,89,1,10,0,'black','2006-08-08',18000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (233,89,1,10,0,'red','2006-08-08',18000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (234,97,1,12,0,'red','2006-08-08',38000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (235,97,1,12,0,'silver','2006-08-08',38000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (236,97,1,12,0,'black','2006-08-08',38000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (237,106,1,12,0,'black','2006-08-08',38000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (238,106,1,12,0,'black','2006-08-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (239,106,1,12,0,'red','2006-08-08',35000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (240,111,1,12,0,'black','2006-08-08',55000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (241,111,1,12,0,'black','2006-08-08',155000.0); insert into car (id,model_id,new_used_id,garage_id,mileage,color,date,price) values (242,120,1,5,0,'blue','2006-08-08',23400.0); -- -- Table structure for table employe -- DROP TABLE IF EXISTS employe; CREATE TABLE employe ( id int NOT NULL , person_id int NOT NULL, funktion_id int NOT NULL, garage_id int NOT NULL, PRIMARY KEY (id) ); -- -- Content of table employe -- insert into employe (id,person_id,funktion_id,garage_id) values (1,3,3,2); insert into employe (id,person_id,funktion_id,garage_id) values (2,3,3,1); insert into employe (id,person_id,funktion_id,garage_id) values (3,1,1,1); insert into employe (id,person_id,funktion_id,garage_id) values (4,4,1,2); insert into employe (id,person_id,funktion_id,garage_id) values (5,7,2,2); insert into employe (id,person_id,funktion_id,garage_id) values (6,2,1,2); insert into employe (id,person_id,funktion_id,garage_id) values (7,1,3,2); insert into employe (id,person_id,funktion_id,garage_id) values (8,6,1,1); insert into employe (id,person_id,funktion_id,garage_id) values (9,2,4,2); insert into employe (id,person_id,funktion_id,garage_id) values (10,8,3,2); insert into employe (id,person_id,funktion_id,garage_id) values (11,2,1,12); insert into employe (id,person_id,funktion_id,garage_id) values (12,3,1,4); insert into employe (id,person_id,funktion_id,garage_id) values (13,2,3,4); insert into employe (id,person_id,funktion_id,garage_id) values (14,4,2,4); insert into employe (id,person_id,funktion_id,garage_id) values (15,6,4,4); insert into employe (id,person_id,funktion_id,garage_id) values (16,6,1,5); insert into employe (id,person_id,funktion_id,garage_id) values (17,1,2,5); insert into employe (id,person_id,funktion_id,garage_id) values (18,4,3,5); insert into employe (id,person_id,funktion_id,garage_id) values (19,2,3,6); insert into employe (id,person_id,funktion_id,garage_id) values (20,1,2,6); insert into employe (id,person_id,funktion_id,garage_id) values (21,3,4,6); insert into employe (id,person_id,funktion_id,garage_id) values (22,3,3,7); insert into employe (id,person_id,funktion_id,garage_id) values (23,6,2,7); insert into employe (id,person_id,funktion_id,garage_id) values (24,7,1,7); insert into employe (id,person_id,funktion_id,garage_id) values (25,7,3,8); insert into employe (id,person_id,funktion_id,garage_id) values (26,2,2,8); insert into employe (id,person_id,funktion_id,garage_id) values (27,5,1,8); insert into employe (id,person_id,funktion_id,garage_id) values (28,5,3,9); insert into employe (id,person_id,funktion_id,garage_id) values (29,4,1,9); insert into employe (id,person_id,funktion_id,garage_id) values (30,6,4,9); insert into employe (id,person_id,funktion_id,garage_id) values (31,6,3,10); insert into employe (id,person_id,funktion_id,garage_id) values (32,3,1,10); insert into employe (id,person_id,funktion_id,garage_id) values (33,2,4,10); insert into employe (id,person_id,funktion_id,garage_id) values (34,8,2,10); insert into employe (id,person_id,funktion_id,garage_id) values (35,2,3,12); insert into employe (id,person_id,funktion_id,garage_id) values (36,1,1,12); insert into employe (id,person_id,funktion_id,garage_id) values (37,3,4,12); insert into employe (id,person_id,funktion_id,garage_id) values (38,5,3,13); insert into employe (id,person_id,funktion_id,garage_id) values (39,4,1,13); insert into employe (id,person_id,funktion_id,garage_id) values (40,7,2,13); -- -- Table structure for table funktion -- DROP TABLE IF EXISTS funktion; CREATE TABLE funktion ( id int NOT NULL , funktion varchar(50) NOT NULL, PRIMARY KEY (id) ); -- -- Content of table funktion -- insert into funktion (id, funktion ) values (1,'Sales'); insert into funktion (id, funktion ) values (2,'Marketing'); insert into funktion (id, funktion ) values (3,'CEO'); insert into funktion (id, funktion ) values (4,'Technic'); -- -- Table structure for table garage -- DROP TABLE IF EXISTS garage; CREATE TABLE garage ( id int NOT NULL, name varchar(50) NOT NULL, street varchar(50) default NULL, zip varchar(10) default NULL, city varchar(50) default NULL, email varchar(50) default NULL, phone varchar(20) default NULL, PRIMARY KEY (id) ); -- -- Content of table garage -- insert into garage (id, name, street, zip, city, email, phone) values (1,'Parkgarage','Parkway 12','5000','Aarau','info@parkgarage.ws','033 541 78 96'); insert into garage (id, name, street, zip, city, email, phone) values (2,'Garage Stevenson','La luna negra','12547 ','Monte di Amore','info@monteamore.it','0444 885 21 74'); insert into garage (id, name, street, zip, city, email, phone) values (3,'New Lane Cars','Telegraphhill 12','56789','San Antonio','info@newlanecars.com','001 254 89 632 45'); insert into garage (id, name, street, zip, city, email, phone) values (4,'Blue Ford','Gardenway','12342','Coverhill','info@blueford.coverhill.com','0478 364 14 88'); insert into garage (id, name, street, zip, city, email, phone) values (5,'Red Ford','Gardenway','12342','Coverhill','info@blueford.coverhill.com','0478 364 14 89'); insert into garage (id, name, street, zip, city, email, phone) values (6,'Honda Automobiles','Airport','778899','Zuerich','info@honad-automobiles.at','044 88 32 11'); insert into garage (id, name, street, zip, city, email, phone) values (7,'Land Rover Austria','Innerer Ring','447788','Vienna','info@landrover.at','044 77 55 22'); insert into garage (id, name, street, zip, city, email, phone) values (8,'Greenpark BMW','El Camino Real','345221','Niederbuchsitten','info@greenparkbmw.ch','044 874 52 14'); insert into garage (id, name, street, zip, city, email, phone) values (9,'Auto HUG','Stationsstrasse 23','8456','Raeterschen','info@autohug.biz','052 342 12 78'); insert into garage (id, name, street, zip, city, email, phone) values (10,'Autohaus Moeller','Adam Opel Strasse 12','87444','Dortmund','info@moeller.org','0478 521 722 11'); insert into garage (id, name, street, zip, city, email, phone) values (12,'BLAG','Im Stadion 4','8021','Zuerich','verkauf@amag.biz','044 368 58 41'); insert into garage (id, name, street, zip, city, email, phone) values (13,'Maison des Autombiles','Av. de Clichy 34','1000','Lausanne','vente-auto@wanadoo.fr',''); -- -- Table structure for table make -- DROP TABLE IF EXISTS make; CREATE TABLE make ( id int NOT NULL , make varchar(50) NOT NULL, PRIMARY KEY (id) ); -- -- Content of table make -- insert into make ( id,make) values (1,'Automobile'); insert into make ( id,make) values (2,'Sport Utility Vehicle'); insert into make ( id,make) values (3,'Truck'); insert into make ( id,make) values (4,'Van'); insert into make ( id,make) values (5,'Convertible'); insert into make ( id,make) values (6,'Coupe'); -- -- Table structure for table model -- DROP TABLE IF EXISTS model; CREATE TABLE model ( id int NOT NULL , brand_id int NOT NULL, make_id int NOT NULL, model varchar(50) NOT NULL, cylinders int NOT NULL default 4, capacity double default NULL, fuel varchar(10) default NULL, doors int NOT NULL, PRIMARY KEY (id) ); -- -- Content of table model -- insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (1,2,2,'Defender',4,2.5,'diesel',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (2,2,2,'Discovery',6,4.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (3,2,2,'Range Rover',8,4.2,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (4,2,2,'Range Rover Sport',8,4.2,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (5,2,2,'Freelander',4,2.0,'diesel',3); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (6,1,1,'X-Type',4,2.2,'diesel',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (7,1,1,'X-Type Classic',6,2.5,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (8,1,1,'X-Type Sport',6,3.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (9,1,1,'S-Type Classic',6,2.7,'diesel',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (10,1,1,'S-Type Executive',6,3.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (11,1,1,'S-Type 4.2 V8 Executive',8,4.2,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (12,1,1,'XJ6 Executive 2.7',6,2.7,'diesel',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (13,1,1,'XJ6 Sovereign 2.7',6,2.7,'diesel',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (14,1,1,'XJ8 Sovereign 4.2',8,4.2,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (15,1,1,'XJ8 4.2 V8 Supercharged',8,4.2,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (16,1,6,'XK Coupe',8,4.2,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (17,1,5,'XK Convertible',8,4.2,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (18,3,1,'116i',4,1.6,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (19,3,1,'118i',4,2.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (20,3,1,'118d',4,2.0,'diesel',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (21,3,1,'120d',4,2.0,'diesel',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (22,3,1,'120i',4,2.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (23,3,1,'130i',4,3.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (24,3,1,'318i',4,2.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (25,3,1,'320i',4,2.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (26,3,1,'325i',6,2.5,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (27,3,1,'330i',6,3.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (28,3,6,'320ci',6,2.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (29,3,6,'330ci',6,3.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (30,3,5,'320ci',6,2.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (31,3,5,'330ci',6,3.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (32,3,1,'525i',6,2.5,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (33,3,1,'540i',8,4.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (34,3,6,'630i',6,3.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (35,3,5,'630i',6,3.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (36,3,5,'630i',6,3.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (37,3,2,'X5 3.0i',6,3.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (38,3,2,'X5 4.4i',8,4.4,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (39,3,2,'X3 2.5i',6,2.5,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (40,4,2,'G500',8,5.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (41,4,6,'A200',4,2.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (42,4,1,'A170',4,1.7,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (43,4,1,'C230',6,2.5,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (44,4,1,'C350',8,3.5,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (45,4,1,'S350',6,3.5,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (46,4,1,'S500',8,5.5,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (47,4,5,'CLK200',4,1.8,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (48,4,5,'CLK350',6,3.5,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (49,4,5,'SLK200',4,1.8,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (54,5,2,'Santa Fe',6,2.7,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (51,4,5,'SLK350',6,3.5,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (52,4,2,'ML350',6,3.5,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (53,4,2,'ML500',8,5.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (55,5,2,'Tucson',4,2.0,'diesel',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (56,5,2,'Terracan',6,2.9,'diesel',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (57,5,1,'Atos',4,1.1,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (58,5,1,'Sonata',6,2.4,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (59,6,1,'Matiz S',3,0.8,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (60,6,1,'Kalos',4,1.15,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (61,6,1,'Nubira',4,1.8,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (62,7,5,'Wrangler',4,2.5,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (63,7,2,'Cherokee',6,3.7,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (64,7,2,'Grand Cherokee',6,3.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (65,7,2,'Commander',8,4.7,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (66,8,6,'Crossfire Coupe',6,3.2,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (67,8,5,'Crossfire Convertible',6,3.2,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (68,8,1,'PT Cruiser',4,1.6,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (69,8,1,'Sebring',6,2.7,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (70,8,1,'300C',6,3.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (71,8,1,'Voyager',6,2.5,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (72,9,1,'Corolla',4,1.6,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (73,9,1,'Avensis',4,2.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (74,9,1,'Previa',6,2.4,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (75,9,2,'Land Cruiser',6,3.0,'diesel',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (76,9,2,'RAV4',4,2.2,'diesel',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (77,10,1,'Jazz 1.2i cool',4,1.2,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (78,10,1,'Jazz 1.4i LsS',4,1.4,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (79,10,1,'Civic 3D',4,2.0,'gasoline',3); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (80,10,1,'Civic 5D 1.8i',4,1.8,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (81,10,1,'Civic 5D 2.2 i-CDTi',4,2.2,'diesel',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (82,10,2,'CR-V 2.0i 4WD',4,2.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (83,10,2,'CR-V 2.2 i-CDTi 4WD',4,2.2,'diesel',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (84,10,4,'FR-V 1.7i',4,1.7,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (85,10,4,'FR-V 2.2 i-CDTi',4,2.2,'diesel',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (86,10,1,'Accord',4,2.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (87,10,1,'Legend',6,3.5,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (88,10,5,'S200',4,2.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (89,11,1,'Astra GTC 1.4.i',4,1.4,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (90,11,1,'Astra GTC 1.8. ECOTEC',4,1.8,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (91,11,5,'Astra TwinTop',4,1.8,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (92,11,1,'Corsa',4,1.4,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (93,11,1,'Signum',4,2.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (94,11,4,'Zafira',4,2.0,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (95,11,5,'Tigra TwinTop',4,1.6,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (96,12,1,'93Linear',4,2.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (97,12,1,'93 Arc',4,1.8,'gasoline',0); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (98,12,1,'93 Arc',4,1.8,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (99,12,1,'93 Aero',6,2.8,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (100,12,1,'95 Arc',4,2.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (101,12,1,'95 Aero',4,2.3,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (102,13,1,'Polo Trendline',4,1.2,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (103,13,1,'Beetle',4,1.6,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (104,13,1,'Golf',4,1.6,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (105,13,5,'Eos',4,1.6,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (106,13,1,'Passat',4,2.0,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (107,13,1,'Touran',4,1.6,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (108,13,2,'Touareg',8,4.2,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (109,13,1,'Phaeton',8,4.2,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (110,14,5,'Boxster',6,2.7,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (111,14,5,'Boxster S',6,3.2,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (112,14,6,'Cayman S',6,3.4,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (113,14,6,'911 Carrera',6,3.6,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (114,14,5,'911 Carrera CAbriolet',6,3.6,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (115,14,2,'Cayenne',6,3.2,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (116,14,2,'Cayenne',6,3.2,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (117,15,5,'Focus Cabriolet',4,2.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (118,15,1,'Fiesta ST',4,2.0,'gasoline',2); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (119,15,1,'Fusion',4,1.6,'gasoline',5); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (120,15,1,'Focus',4,1.6,'gasoline',3); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (121,15,1,'Mondeo',4,1.8,'gasoline',4); insert into model (id,brand_id, make_id, model,cylinders, capacity, fuel, doors) values (122,15,2,'Maverick',6,3.0,'gasoline',5); -- -- Table structure for table new_used -- DROP TABLE IF EXISTS new_used; CREATE TABLE new_used ( id int NOT NULL, value char(5) default NULL, PRIMARY KEY (id) ); -- -- Content of table new_used -- insert into new_used (id,value) values (1,'new'); insert into new_used (id,value) values (2,'used'); -- -- Table structure for table person -- DROP TABLE IF EXISTS person; CREATE TABLE person ( id int NOT NULL , firstname varchar(50) NOT NULL, lastname varchar(50) NOT NULL, phone varchar(20) default NULL, garage_id int NOT NULL, PRIMARY KEY (id) ); -- -- Content of table person -- insert into person (id,firstname,lastname, phone, garage_id) values (1,'Fredy','Fischer','044 398 45 78',1); insert into person (id,firstname,lastname, phone, garage_id) values (2,'Peter','Gantenbein','058 41 93 54',2); insert into person (id,firstname,lastname, phone, garage_id) values (3,'Franz','Meier','0478 555 98 23',3); insert into person (id,firstname,lastname, phone, garage_id) values (4,'John','Doolittle','012 817 52 36',5); insert into person (id,firstname,lastname, phone, garage_id) values (5,'Frank','Masterson','047 852 64 82',6); insert into person (id,firstname,lastname, phone, garage_id) values (6,'Claudia','Di Roberto','078 962 41 52',6); insert into person (id,firstname,lastname, phone, garage_id) values (7,'Katrin','Mueller','071 523 64 12',7); insert into person (id,firstname,lastname, phone, garage_id) values (8,'Roberta','Stevenson','045 125 78 93',80);