6qJuc0A9

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