VsNscuKz

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),
19  dataZam date,
20  FOREIGN KEY (Samochody_id) REFERENCES samochody (id)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8;