-- MySQL dump 10.10
--
-- Host: localhost    Database: car
-- ------------------------------------------------------
-- Server version	5.0.22-standard
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,ANSI' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table "brand"
--

DROP TABLE IF EXISTS "brand";
CREATE TABLE "brand" (
  "id" int(11) NOT NULL auto_increment,
  "brand" varchar(50) NOT NULL,
  PRIMARY KEY  ("id")
);

--
-- Dumping data for table "brand"
--


/*!40000 ALTER TABLE "brand" DISABLE KEYS */;
LOCK TABLES "brand" WRITE;
INSERT INTO "brand" VALUES (1,'Jaguar'),(2,'Land Rover'),(3,'BMW'),(4,'Mercedes'),(5,'Hyundai'),(6,'Chevrolet'),(7,'Jeep'),(8,'Chrysler'),(9,'Toyota'),(10,'Honda'),(11,'Opel'),(12,'Saab'),(13,'Volkswagen'),(14,'Porsche'),(15,'Ford');
UNLOCK TABLES;
/*!40000 ALTER TABLE "brand" ENABLE KEYS */;

--
-- Table structure for table "car"
--

DROP TABLE IF EXISTS "car";
CREATE TABLE "car" (
  "id" int(11) NOT NULL auto_increment,
  "model_id" int(11) NOT NULL,
  "new_used_id" int(11) NOT NULL,
  "garage_id" int(11) NOT NULL,
  "mileage" int(11) NOT NULL,
  "color" varchar(20) NOT NULL,
  "date" date default NULL,
  "price" double default NULL,
  PRIMARY KEY  ("id")
);

--
-- Dumping data for table "car"
--


/*!40000 ALTER TABLE "car" DISABLE KEYS */;
LOCK TABLES "car" WRITE;
INSERT INTO "car" VALUES (1,1,1,7,0,'green','2006-08-07',78000),(2,1,2,7,45678,'black','1995-03-03',15000),(3,1,1,7,0,'black','2006-08-07',45000),(4,1,1,7,0,'blue','2006-08-07',45000),(5,1,1,7,0,'silver','2006-08-07',45000),(6,1,2,7,12000,'silver','2006-08-07',12500),(7,2,2,7,10000,'red','2006-08-07',13500),(8,1,1,7,0,'green','2006-08-08',35000),(9,1,1,7,0,'silver','2006-08-08',35000),(10,1,2,7,45000,'silver','1995-03-03',3500),(11,1,2,1,45000,'black','1995-03-03',10700),(12,2,2,1,25000,'pink','1995-03-03',6500),(13,2,1,7,0,'blue','2006-08-08',56000),(14,2,1,7,0,'black','2006-08-08',56000),(15,2,1,7,0,'green','2006-08-08',56000),(16,3,1,7,0,'blue','2006-08-08',125000),(17,3,1,7,0,'black','2006-08-08',125000),(18,3,2,7,78000,'black','1995-03-03',21000),(19,3,2,6,50000,'black','1995-03-03',25000),(20,4,1,7,0,'black','2006-08-08',150000),(21,4,1,7,0,'red','2006-08-08',150000),(22,4,1,7,0,'blue','2006-08-08',150000),(23,4,1,7,0,'green','2006-08-08',150000),(24,4,2,7,12300,'green','2005-07-03',88900),(25,4,2,7,5000,'green','2005-07-03',136000),(26,5,1,7,0,'green','2006-08-08',45000),(27,5,1,7,0,'greenblack','2006-08-08',45000),(28,5,1,7,0,'black','2006-08-08',45000),(29,5,1,7,0,'red','2006-08-08',45000),(30,5,1,7,0,'yellow','2006-08-08',45000),(31,5,2,7,50000,'brown','1995-03-03',8000),(32,5,2,7,30000,'brown','1995-03-03',10000),(33,5,2,3,30000,'brown','1995-03-03',10000),(34,5,2,8,30000,'brown','1995-03-03',10000),(35,6,1,2,0,'green','2006-08-08',54000),(36,6,1,2,0,'black','2006-08-08',54000),(37,6,1,2,0,'blue','2006-08-08',54000),(38,6,1,2,0,'silver','2006-08-08',54000),(39,6,2,2,8000,'silver','2005-07-03',35000),(40,6,2,2,15000,'black','2005-06-30',15000),(41,6,2,8,15000,'black','2005-06-30',15000),(42,7,1,2,0,'black','2006-08-08',58000),(43,7,1,2,0,'blue','2006-08-08',58000),(44,7,1,2,0,'black','2006-08-08',58000),(45,7,1,2,0,'yellow','2006-08-08',58000),(46,7,1,2,0,'silver','2006-08-08',58000),(47,7,2,2,8000,'silver','2005-07-03',28000),(48,7,2,1,9000,'black','2005-07-03',28000),(49,8,1,2,0,'black','2006-08-08',57000),(50,8,1,2,0,'blue','2006-08-08',57000),(51,8,1,2,0,'silver','2006-08-08',57000),(52,8,1,2,0,'green','2006-08-08',57000),(53,8,2,2,34000,'green','1995-03-03',17000),(54,8,2,1,34000,'green','1995-03-03',17000),(55,8,2,7,12000,'blue','2005-07-03',47000),(56,9,1,2,0,'blue','2006-08-08',78000),(57,9,1,2,0,'black','2006-08-08',78000),(58,9,1,2,0,'green','2006-08-08',78000),(59,9,1,2,0,'silver','2006-08-08',78000),(60,9,1,2,0,'red','2006-08-08',78000),(61,9,2,2,10000,'red','2005-07-03',28000),(62,9,2,2,15000,'black','2005-07-03',43000),(63,9,2,4,15000,'black','2005-07-03',43000),(64,9,2,4,75000,'green','1995-03-03',13000),(65,10,1,2,0,'green','2006-08-08',89000),(66,10,1,2,0,'black','2006-08-08',89000),(67,10,1,2,0,'blue','2006-08-08',89000),(68,10,1,2,0,'red','2006-08-08',89000),(69,10,1,2,0,'silver','2006-08-08',89000),(70,10,2,2,23500,'yellow','2006-08-08',19000),(71,11,1,2,0,'black','2006-08-08',178000),(72,11,2,2,2000,'black','2004-08-08',108000),(73,11,1,2,0,'blue','2006-08-08',178000),(74,11,1,2,0,'silver','2006-08-08',178000),(75,12,1,2,0,'silver','2006-08-08',148000),(76,12,1,2,0,'blue','2006-08-08',148000),(77,12,1,2,0,'black','2006-08-08',148000),(78,12,2,2,35000,'black','2003-08-08',88000),(79,12,2,5,30000,'blue','2003-08-08',98000),(80,13,1,2,0,'blue','2006-08-08',108000),(81,13,1,2,0,'black','2006-08-08',108000),(82,13,1,2,0,'red','2006-08-08',108000),(83,17,1,2,0,'blue','2006-08-08',158000),(84,17,1,2,0,'black','2006-08-08',158000),(85,17,1,2,0,'black','2006-08-08',158000),(86,17,1,2,0,'silver','2006-08-08',158000),(87,18,1,8,0,'silver','2006-08-08',34000),(88,18,1,8,0,'red','2006-08-08',34000),(89,18,1,8,0,'blue','2006-08-08',34000),(90,18,1,8,0,'black','2006-08-08',34000),(91,18,1,8,0,'grey','2006-08-08',34000),(92,18,1,8,0,'yellow','2006-08-08',34000),(93,18,2,8,10000,'blue','2004-08-08',24000),(94,18,2,3,10000,'blue','2004-08-08',24000),(95,18,2,3,20000,'blue','2003-08-08',18000),(96,19,2,3,25000,'blue','2003-08-08',22000),(97,19,2,3,125000,'red','1994-08-08',2000),(98,19,1,8,0,'red','2006-08-08',28000),(99,19,1,8,0,'blue','2006-08-08',28000),(100,19,1,8,0,'yellow','2006-08-08',28000),(101,19,1,8,0,'lightblue','2006-08-08',28000),(102,19,1,8,0,'green','2006-08-08',28000),(103,19,1,8,0,'pink','2006-08-08',28000),(104,20,1,8,0,'black','2006-08-08',39000),(105,20,1,8,0,'silver','2006-08-08',39000),(106,20,2,4,18000,'silver','2005-08-08',29000),(107,20,2,4,23500,'black','2005-08-08',29000),(108,21,1,8,0,'black','2006-08-08',36000),(109,21,1,8,0,'blue','2006-08-08',36000),(110,21,1,8,0,'lightgreen','2006-08-08',36000),(111,21,1,8,0,'brown','2006-08-08',36000),(112,21,1,8,0,'gold','2006-08-08',36000),(113,21,1,8,0,'blue','2006-08-08',36000),(114,21,2,8,1000,'blue','2005-08-08',32000),(115,21,2,8,15000,'blue','2004-08-08',28000),(116,22,1,8,0,'blue','2006-08-08',28000),(117,22,1,8,0,'yellow','2006-08-08',28000),(118,22,1,8,0,'silver','2006-08-08',28000),(119,22,1,8,0,'grey','2006-08-08',28000),(120,22,1,8,0,'cyan','2006-08-08',28000),(121,22,1,8,0,'brown','2006-08-08',28000),(122,23,1,8,0,'brown','2006-08-08',29000),(123,23,1,8,0,'orange','2006-08-08',29000),(124,23,1,8,0,'blue','2006-08-08',29000),(125,23,1,8,0,'occre','2006-08-08',29000),(126,23,1,8,0,'red','2006-08-08',29000),(127,23,1,8,0,'white','2006-08-08',29000),(128,24,1,8,0,'white','2006-08-08',32000),(129,24,1,8,0,'silver','2006-08-08',32000),(130,24,1,8,0,'red','2006-08-08',32000),(131,24,1,8,0,'blue','2006-08-08',32000),(132,24,1,8,0,'black','2006-08-08',32000),(133,24,2,2,15000,'black','2002-06-08',16000),(134,24,2,2,16000,'red','2003-06-08',18000),(135,25,1,8,0,'red','2006-08-08',39000),(136,25,1,8,0,'silver','2006-08-08',39000),(137,25,1,8,0,'black','2006-08-08',39000),(138,26,1,8,0,'black','2006-08-08',59000),(139,27,1,8,0,'blue','2006-08-08',60000),(140,27,1,8,0,'red','2006-08-08',60000),(141,27,1,8,0,'silver','2006-08-08',60000),(142,27,2,6,25000,'blue','2003-11-08',45000),(143,34,1,8,0,'blue','2006-08-08',123000),(144,34,1,8,0,'black','2006-08-08',123000),(145,34,1,8,0,'silver','2006-08-08',123000),(146,34,1,8,0,'white','2006-08-08',123000),(147,34,1,8,0,'red','2006-08-08',123000),(148,38,2,8,34500,'blue','2002-08-08',67000),(149,39,2,8,28000,'black','2003-08-08',37000),(150,39,1,8,0,'black','2006-08-08',48000),(151,39,1,8,0,'blue','2006-08-08',48000),(152,39,1,8,0,'silver','2006-08-08',48000),(153,40,1,1,0,'silver','2006-08-08',88000),(154,40,1,1,0,'black','2006-08-08',88000),(155,41,1,1,0,'black','2006-08-08',35000),(156,41,1,1,0,'green','2006-08-08',35000),(157,41,1,1,0,'silver','2006-08-08',35000),(158,41,1,1,0,'blue','2006-08-08',35000),(159,41,2,1,15000,'blue','2005-05-08',25000),(160,41,2,1,18000,'red','2005-05-08',24000),(161,42,1,1,0,'red','2006-08-08',32000),(162,42,1,1,0,'blue','2006-08-08',32000),(163,42,1,1,0,'black','2006-08-08',32000),(164,45,1,1,0,'black','2006-08-08',68000),(165,45,1,1,0,'silver','2006-08-08',68000),(166,45,1,1,0,'white','2006-08-08',68000),(167,45,1,1,0,'red','2006-08-08',68000),(168,46,1,1,0,'red','2006-08-08',89000),(169,46,1,1,0,'black','2006-08-08',89000),(170,48,1,1,0,'black','2006-08-08',59000),(171,48,1,1,0,'blue','2006-08-08',59000),(172,54,1,3,0,'blue','2006-08-08',43000),(173,54,1,3,0,'silver','2006-08-08',43000),(174,54,1,3,0,'black','2006-08-08',43000),(175,54,1,3,0,'red','2006-08-08',43000),(176,54,2,3,15000,'red','2005-11-08',33000),(177,54,2,12,18000,'red','2005-11-08',33000),(178,55,1,9,0,'red','2006-11-08',35000),(179,55,1,9,0,'black','2006-11-08',35000),(180,55,1,9,0,'yellow','2006-11-08',35000),(181,56,1,9,0,'blue','2006-11-08',55000),(182,56,1,9,0,'red','2006-11-08',55000),(183,56,1,9,0,'orange','2006-11-08',55000),(184,57,1,9,0,'red','2006-11-08',15000),(185,57,1,9,0,'pink','2006-11-08',15000),(186,57,1,9,0,'lightblue','2006-11-08',15000),(187,58,1,9,0,'black','2006-11-08',35000),(188,58,1,9,0,'blue','2006-11-08',35000),(189,58,1,9,0,'red','2006-11-08',35000),(190,59,1,10,0,'red','2006-11-08',13000),(191,59,1,10,0,'blue','2006-11-08',13000),(192,59,1,10,0,'white','2006-11-08',13000),(193,60,1,10,0,'white','2006-11-08',15000),(194,60,1,10,0,'red','2006-11-08',15000),(195,60,1,10,0,'black','2006-11-08',15000),(196,61,1,10,0,'black','2006-11-08',16000),(197,61,1,10,0,'yellow','2006-11-08',16000),(198,61,1,10,0,'blue','2006-11-08',16000),(199,62,1,13,0,'blue','2006-11-08',36000),(200,62,1,13,0,'red','2006-11-08',36000),(201,62,1,13,0,'brown','2006-11-08',36000),(202,63,1,13,0,'brown','2006-11-08',46000),(203,63,1,13,0,'blue','2006-11-08',46000),(204,63,1,13,0,'silver','2006-11-08',46000),(205,64,1,13,0,'black','2006-11-08',55000),(206,64,1,13,0,'blue','2006-11-08',55000),(207,64,1,13,0,'green','2006-11-08',55000),(208,65,1,13,0,'grey','2006-11-08',85000),(209,65,1,12,0,'grey','2006-11-08',85000),(210,65,1,13,0,'black','2006-11-08',85000),(211,66,1,13,0,'black','2006-11-08',45000),(212,66,1,13,0,'blue','2006-11-08',45000),(213,66,1,13,0,'silver','2006-11-08',45000),(214,67,1,13,0,'silver','2006-11-08',48000),(215,67,1,13,0,'red','2006-11-08',48000),(216,67,1,13,0,'black','2006-11-08',48000),(217,68,1,13,0,'green','2006-11-08',38000),(218,73,1,9,0,'silver','2006-11-08',28000),(219,73,1,9,0,'blue','2006-11-08',28000),(220,72,1,9,0,'blue','2006-11-08',26000),(221,72,1,9,0,'black','2006-11-08',26000),(222,74,1,9,0,'black','2006-11-08',34000),(223,74,1,9,0,'blue','2006-11-08',34000),(224,75,1,9,0,'blue','2006-11-08',54000),(225,76,2,9,25000,'pink','2006-11-08',14000),(226,77,2,6,25000,'yellow','2003-11-08',4000),(227,77,1,6,0,'black','2006-08-08',14000),(228,77,1,6,0,'red','2006-08-08',14000),(229,80,1,6,0,'red','2006-08-08',18000),(230,80,1,6,0,'silver','2006-08-08',18000),(231,89,1,10,0,'silver','2006-08-08',18000),(232,89,1,10,0,'black','2006-08-08',18000),(233,89,1,10,0,'red','2006-08-08',18000),(234,97,1,12,0,'red','2006-08-08',38000),(235,97,1,12,0,'silver','2006-08-08',38000),(236,97,1,12,0,'black','2006-08-08',38000),(237,106,1,12,0,'black','2006-08-08',38000),(238,106,1,12,0,'black','2006-08-08',35000),(239,106,1,12,0,'red','2006-08-08',35000),(240,111,1,12,0,'black','2006-08-08',55000),(241,111,1,12,0,'black','2006-08-08',155000),(242,120,1,5,0,'blue','2006-08-08',23400);
UNLOCK TABLES;
/*!40000 ALTER TABLE "car" ENABLE KEYS */;

--
-- Table structure for table "employe"
--

DROP TABLE IF EXISTS "employe";
CREATE TABLE "employe" (
  "id" int(11) NOT NULL auto_increment,
  "person_id" int(11) NOT NULL,
  "function_id" int(11) NOT NULL,
  "garage_id" int(11) NOT NULL,
  PRIMARY KEY  ("id")
);

--
-- Dumping data for table "employe"
--


/*!40000 ALTER TABLE "employe" DISABLE KEYS */;
LOCK TABLES "employe" WRITE;
INSERT INTO "employe" VALUES (1,3,3,2),(2,3,3,1),(3,1,1,1),(4,4,1,2),(5,7,2,2),(6,2,1,2),(7,1,3,2),(8,6,1,1),(9,2,4,2),(10,8,3,2),(11,2,1,12),(12,3,1,4),(13,2,3,4),(14,4,2,4),(15,6,4,4),(16,6,1,5),(17,1,2,5),(18,4,3,5),(19,2,3,6),(20,1,2,6),(21,3,4,6),(22,3,3,7),(23,6,2,7),(24,7,1,7),(25,7,3,8),(26,2,2,8),(27,5,1,8),(28,5,3,9),(29,4,1,9),(30,6,4,9),(31,6,3,10),(32,3,1,10),(33,2,4,10),(34,8,2,10),(35,2,3,12),(36,1,1,12),(37,3,4,12),(38,5,3,13),(39,4,1,13),(40,7,2,13);
UNLOCK TABLES;
/*!40000 ALTER TABLE "employe" ENABLE KEYS */;

--
-- Table structure for table "function"
--

DROP TABLE IF EXISTS "function";
CREATE TABLE "function" (
  "id" int(11) NOT NULL auto_increment,
  "function" varchar(50) NOT NULL,
  PRIMARY KEY  ("id")
);

--
-- Dumping data for table "function"
--


/*!40000 ALTER TABLE "function" DISABLE KEYS */;
LOCK TABLES "function" WRITE;
INSERT INTO "function" VALUES (1,'Sales'),(2,'Marketing'),(3,'CEO'),(4,'Technic');
UNLOCK TABLES;
/*!40000 ALTER TABLE "function" ENABLE KEYS */;

--
-- Table structure for table "garage"
--

DROP TABLE IF EXISTS "garage";
CREATE TABLE "garage" (
  "id" int(11) NOT NULL auto_increment,
  "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")
);

--
-- Dumping data for table "garage"
--


/*!40000 ALTER TABLE "garage" DISABLE KEYS */;
LOCK TABLES "garage" WRITE;
INSERT INTO "garage" VALUES (1,'Parkgarage','Parkway 12','5000','Aarau','info@parkgarage.ws','033 541 78 96'),(2,'Garage Stevenson','La luna negra','12547 ','Monte di Amore','info@monteamore.it','0444 885 21 74'),(3,'New Lane Cars','Telegraphhill 12','56789','San Antonio','info@newlanecars.com','001 254 89 632 45'),(4,'Blue Ford','Gardenway','12342','Coverhill','info@blueford.coverhill.com','0478 364 14 88'),(5,'Red Ford','Gardenway','12342','Coverhill','info@blueford.coverhill.com','0478 364 14 89'),(6,'Honda Automobiles','Airport','778899','Zuerich','info@honad-automobiles.at','044 88 32 11'),(7,'Land Rover Austria','Innerer Ring','447788','Vienna','info@landrover.at','044 77 55 22'),(8,'Greenpark BMW','El Camino Real','345221','Niederbuchsitten','info@greenparkbmw.ch','044 874 52 14'),(9,'Auto HUG','Stationsstrasse 23','8456','Raeterschen','info@autohug.biz','052 342 12 78'),(10,'Autohaus Moeller','Adam Opel Strasse 12','87444','Dortmund','info@moeller.org','0478 521 722 11'),(12,'BLAG','Im Stadion 4','8021','Zuerich','verkauf@amag.biz','044 368 58 41'),(13,'Maison des Autombiles','Av. de Clichy 34','1000','Lausanne','vente-auto@wanadoo.fr','');
UNLOCK TABLES;
/*!40000 ALTER TABLE "garage" ENABLE KEYS */;

--
-- Table structure for table "make"
--

DROP TABLE IF EXISTS "make";
CREATE TABLE "make" (
  "id" int(11) NOT NULL auto_increment,
  "make" varchar(50) NOT NULL,
  PRIMARY KEY  ("id")
);

--
-- Dumping data for table "make"
--


/*!40000 ALTER TABLE "make" DISABLE KEYS */;
LOCK TABLES "make" WRITE;
INSERT INTO "make" VALUES (1,'Automobile'),(2,'Sport Utility Vehicle'),(3,'Truck'),(4,'Van'),(5,'Convertible'),(6,'Coupe');
UNLOCK TABLES;
/*!40000 ALTER TABLE "make" ENABLE KEYS */;

--
-- Table structure for table "model"
--

DROP TABLE IF EXISTS "model";
CREATE TABLE "model" (
  "id" int(11) NOT NULL auto_increment,
  "brand_id" int(11) NOT NULL,
  "make_id" int(11) NOT NULL,
  "model" varchar(50) NOT NULL,
  "cylinders" int(11) NOT NULL default '4',
  "capacity" double default NULL,
  "fuel" varchar(10) default NULL,
  "doors" int(11) NOT NULL,
  PRIMARY KEY  ("id")
);

--
-- Dumping data for table "model"
--


/*!40000 ALTER TABLE "model" DISABLE KEYS */;
LOCK TABLES "model" WRITE;
INSERT INTO "model" VALUES (1,2,2,'Defender',4,2.5,'diesel',4),(2,2,2,'Discovery',6,4,'gasoline',5),(3,2,2,'Range Rover',8,4.2,'gasoline',5),(4,2,2,'Range Rover Sport',8,4.2,'gasoline',5),(5,2,2,'Freelander',4,2,'diesel',3),(6,1,1,'X-Type',4,2.2,'diesel',4),(7,1,1,'X-Type Classic',6,2.5,'gasoline',4),(8,1,1,'X-Type Sport',6,3,'gasoline',4),(9,1,1,'S-Type Classic',6,2.7,'diesel',4),(10,1,1,'S-Type Executive',6,3,'gasoline',4),(11,1,1,'S-Type  4.2 V8 Executive',8,4.2,'gasoline',4),(12,1,1,'XJ6 Executive 2.7',6,2.7,'diesel',4),(13,1,1,'XJ6 Sovereign  2.7',6,2.7,'diesel',4),(14,1,1,'XJ8 Sovereign  4.2',8,4.2,'gasoline',4),(15,1,1,'XJ8  4.2 V8 Supercharged',8,4.2,'gasoline',4),(16,1,6,'XK Coupe',8,4.2,'gasoline',2),(17,1,5,'XK Convertible',8,4.2,'gasoline',2),(18,3,1,'116i',4,1.6,'gasoline',5),(19,3,1,'118i',4,2,'gasoline',5),(20,3,1,'118d',4,2,'diesel',5),(21,3,1,'120d',4,2,'diesel',5),(22,3,1,'120i',4,2,'gasoline',5),(23,3,1,'130i',4,3,'gasoline',5),(24,3,1,'318i',4,2,'gasoline',4),(25,3,1,'320i',4,2,'gasoline',4),(26,3,1,'325i',6,2.5,'gasoline',4),(27,3,1,'330i',6,3,'gasoline',4),(28,3,6,'320ci',6,2,'gasoline',2),(29,3,6,'330ci',6,3,'gasoline',2),(30,3,5,'320ci',6,2,'gasoline',2),(31,3,5,'330ci',6,3,'gasoline',2),(32,3,1,'525i',6,2.5,'gasoline',4),(33,3,1,'540i',8,4,'gasoline',4),(34,3,6,'630i',6,3,'gasoline',2),(35,3,5,'630i',6,3,'gasoline',2),(36,3,5,'630i',6,3,'gasoline',2),(37,3,2,'X5 3.0i',6,3,'gasoline',5),(38,3,2,'X5 4.4i',8,4.4,'gasoline',5),(39,3,2,'X3 2.5i',6,2.5,'gasoline',5),(40,4,2,'G500',8,5,'gasoline',5),(41,4,6,'A200',4,2,'gasoline',2),(42,4,1,'A170',4,1.7,'gasoline',5),(43,4,1,'C230',6,2.5,'gasoline',4),(44,4,1,'C350',8,3.5,'gasoline',4),(45,4,1,'S350',6,3.5,'gasoline',4),(46,4,1,'S500',8,5.5,'gasoline',4),(47,4,5,'CLK200',4,1.8,'gasoline',2),(48,4,5,'CLK350',6,3.5,'gasoline',2),(49,4,5,'SLK200',4,1.8,'gasoline',2),(54,5,2,'Santa Fe',6,2.7,'gasoline',5),(51,4,5,'SLK350',6,3.5,'gasoline',2),(52,4,2,'ML350',6,3.5,'gasoline',5),(53,4,2,'ML500',8,5,'gasoline',5),(55,5,2,'Tucson',4,2,'diesel',5),(56,5,2,'Terracan',6,2.9,'diesel',5),(57,5,1,'Atos',4,1.1,'gasoline',5),(58,5,1,'Sonata',6,2.4,'gasoline',4),(59,6,1,'Matiz S',3,0.8,'gasoline',4),(60,6,1,'Kalos',4,1.15,'gasoline',5),(61,6,1,'Nubira',4,1.8,'gasoline',4),(62,7,5,'Wrangler',4,2.5,'gasoline',2),(63,7,2,'Cherokee',6,3.7,'gasoline',5),(64,7,2,'Grand Cherokee',6,3,'gasoline',5),(65,7,2,'Commander',8,4.7,'gasoline',5),(66,8,6,'Crossfire Coupe',6,3.2,'gasoline',2),(67,8,5,'Crossfire Convertible',6,3.2,'gasoline',2),(68,8,1,'PT Cruiser',4,1.6,'gasoline',5),(69,8,1,'Sebring',6,2.7,'gasoline',4),(70,8,1,'300C',6,3,'gasoline',4),(71,8,1,'Voyager',6,2.5,'gasoline',4),(72,9,1,'Corolla',4,1.6,'gasoline',5),(73,9,1,'Avensis',4,2,'gasoline',5),(74,9,1,'Previa',6,2.4,'gasoline',5),(75,9,2,'Land Cruiser',6,3,'diesel',5),(76,9,2,'RAV4',4,2.2,'diesel',5),(77,10,1,'Jazz 1.2i cool',4,1.2,'gasoline',5),(78,10,1,'Jazz 1.4i LsS',4,1.4,'gasoline',5),(79,10,1,'Civic 3D',4,2,'gasoline',3),(80,10,1,'Civic 5D 1.8i',4,1.8,'gasoline',5),(81,10,1,'Civic 5D 2.2 i-CDTi',4,2.2,'diesel',5),(82,10,2,'CR-V 2.0i 4WD',4,2,'gasoline',5),(83,10,2,'CR-V 2.2 i-CDTi 4WD',4,2.2,'diesel',5),(84,10,4,'FR-V 1.7i',4,1.7,'gasoline',4),(85,10,4,'FR-V 2.2 i-CDTi',4,2.2,'diesel',4),(86,10,1,'Accord',4,2,'gasoline',4),(87,10,1,'Legend',6,3.5,'gasoline',4),(88,10,5,'S200',4,2,'gasoline',2),(89,11,1,'Astra GTC 1.4.i',4,1.4,'gasoline',4),(90,11,1,'Astra GTC 1.8. ECOTEC',4,1.8,'gasoline',4),(91,11,5,'Astra TwinTop',4,1.8,'gasoline',2),(92,11,1,'Corsa',4,1.4,'gasoline',2),(93,11,1,'Signum',4,2,'gasoline',5),(94,11,4,'Zafira',4,2,'gasoline',5),(95,11,5,'Tigra TwinTop',4,1.6,'gasoline',2),(96,12,1,'93Linear',4,2,'gasoline',4),(97,12,1,'93 Arc',4,1.8,'gasoline',0),(98,12,1,'93 Arc',4,1.8,'gasoline',4),(99,12,1,'93 Aero',6,2.8,'gasoline',4),(100,12,1,'95 Arc',4,2,'gasoline',4),(101,12,1,'95 Aero',4,2.3,'gasoline',4),(102,13,1,'Polo Trendline',4,1.2,'gasoline',4),(103,13,1,'Beetle',4,1.6,'gasoline',4),(104,13,1,'Golf',4,1.6,'gasoline',4),(105,13,5,'Eos',4,1.6,'gasoline',2),(106,13,1,'Passat',4,2,'gasoline',4),(107,13,1,'Touran',4,1.6,'gasoline',5),(108,13,2,'Touareg',8,4.2,'gasoline',5),(109,13,1,'Phaeton',8,4.2,'gasoline',4),(110,14,5,'Boxster',6,2.7,'gasoline',2),(111,14,5,'Boxster S',6,3.2,'gasoline',2),(112,14,6,'Cayman S',6,3.4,'gasoline',2),(113,14,6,'911 Carrera',6,3.6,'gasoline',2),(114,14,5,'911 Carrera CAbriolet',6,3.6,'gasoline',2),(115,14,2,'Cayenne',6,3.2,'gasoline',5),(116,14,2,'Cayenne',6,3.2,'gasoline',5),(117,15,5,'Focus Cabriolet',4,2,'gasoline',2),(118,15,1,'Fiesta ST',4,2,'gasoline',2),(119,15,1,'Fusion',4,1.6,'gasoline',5),(120,15,1,'Focus',4,1.6,'gasoline',3),(121,15,1,'Mondeo',4,1.8,'gasoline',4),(122,15,2,'Maverick',6,3,'gasoline',5);
UNLOCK TABLES;
/*!40000 ALTER TABLE "model" ENABLE KEYS */;

--
-- Table structure for table "new_used"
--

DROP TABLE IF EXISTS "new_used";
CREATE TABLE "new_used" (
  "id" int(11) NOT NULL auto_increment,
  "value" char(5) default NULL,
  PRIMARY KEY  ("id")
);

--
-- Dumping data for table "new_used"
--


/*!40000 ALTER TABLE "new_used" DISABLE KEYS */;
LOCK TABLES "new_used" WRITE;
INSERT INTO "new_used" VALUES (1,'new'),(2,'used');
UNLOCK TABLES;
/*!40000 ALTER TABLE "new_used" ENABLE KEYS */;

--
-- Table structure for table "person"
--

DROP TABLE IF EXISTS "person";
CREATE TABLE "person" (
  "id" int(11) NOT NULL auto_increment,
  "firstname" varchar(50) NOT NULL,
  "lastname" varchar(50) NOT NULL,
  "phone" varchar(20) default NULL,
  "garage_id" int(20) NOT NULL,
  PRIMARY KEY  ("id")
);

--
-- Dumping data for table "person"
--


/*!40000 ALTER TABLE "person" DISABLE KEYS */;
LOCK TABLES "person" WRITE;
INSERT INTO "person" VALUES (1,'Fredy','Fischer','044 398 45 78',1),(2,'Peter','Gantenbein','058 41 93 54',2),(3,'Franz','Meier','0478 555 98 23',3),(4,'John','Doolittle','012 817 52 36',5),(5,'Frank','Masterson','047 852 64 82',6),(6,'Claudia','Di Roberto','078 962 41 52',6),(7,'Katrin','Mueller','071 523 64 12',7),(8,'Roberta','Stevenson','045 125 78 93',80);
UNLOCK TABLES;
/*!40000 ALTER TABLE "person" ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

