0LZ3Evyv

1DROP TABLE IF EXISTS samochody;
2CREATE TABLE samochody (
3  id  int	PRIMARY KEY Auto_increment,
4  Marka varchar(25) NOT NULL,
5  Model varchar(25) NOT NULL,
6  Rocznik year(4) NOT NULL,
7  Kolor varchar(25) NOT NULL DEFAULT 'Czerwony',
8  Stan varchar(25) NOT NULL
9  
10) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11
12DROP TABLE IF EXISTS zamowienia;
13CREATE TABLE zamowienia (
14  id  int 	PRIMARY KEY Auto_increment,
15  Samochody_id int(11) NOT NULL,
16  Klient varchar(35) NOT NULL,
17  telefon varchar(9),
18  dataZam date,
19  FOREIGN KEY (Samochody_id) REFERENCES samochody (id)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8;