H1kQZexR

1drop database if exists uzlet;
2
3create database uzlet
4	DEFAULT CHARACTER SET utf8
5	DEFAULT COLLATE utf8_general_ci;
6    
7use uzlet;
8
9create table autok(
10	id int primary key auto_increment,
11	isbn nvarchar(20),
12    marka nvarchar(300) not null,
13	ar int,
14    loero int,
15    gyartasiev int
16);
17
18insert into autok (isbn, marka, ar, loero, gyartasiev) values ('12345', 'BMW', '8000000', '200', 2013);
19insert into autok (isbn, marka, ar, loero, gyartasiev) values ('12345', 'Mercedes', '10000000', '300', 2016);
20insert into autok (isbn, marka, ar, loero, gyartasiev) values ('12345', 'Audi', '7500000', '250', 2015);
21insert into autok (isbn, marka, ar, loero, gyartasiev) values ('12345', 'BMW', '8200000', '180', 2014);
22insert into autok (isbn, marka, ar, loero, gyartasiev) values ('12345', 'Tesla', '15000000', '260', 2017);
23insert into autok (isbn, marka, ar, loero, gyartasiev) values ('12345', 'Audi', '10500000', '200', 2016);
24insert into autok (isbn, marka, ar, loero, gyartasiev) values ('12345', 'Tesla', '20000000', '300', 2017);
25
26insert into autok (isbn, marka, ar, loero, gyartasiev) values ('54321', 'Audi', '5000000', '150', 2010);
27insert into autok (isbn, marka, ar, loero, gyartasiev) values ('54321', 'BMW', '7500000', '170', 2018);
28insert into autok (isbn, marka, ar, loero, gyartasiev) values ('54321', 'Tesla', '25000000', '320', 2018);
29
30
31create table szemely(
32	id int  primary key auto_increment,
33    nev nvarchar(55) not null,
34    email nvarchar(45),
35    telefonszam nvarchar(45)    
36);
37
38insert into szemely (nev, email, telefonszam) values ('Szabó János', 'szabo.janos@gmail.com', '123456789');
39insert into szemely (nev, email, telefonszam) values ('Kis Gábor', 'kis.gabor@gmail.com', '987654321');
40insert into szemely (nev, email, telefonszam) values ('Nagy Páter', 'nagy.peter@gmail.com', '112345678');
41insert into szemely (nev, email, telefonszam) values ('Tóth Árpád', 'toth.arpad@gmail.com', '122345678');
42
43create table vasarlas(
44	id int primary key auto_increment,
45	szemelyid int not null,
46    autokid int not null,
47    datum date not null,
48        
49    foreign key (szemelyid) references szemely(id),
50    foreign key (autokid) references autok(id)
51);
52
53insert into vasarlas (szemelyid, autokid, datum) values (1, 1, 20180321); 
54insert into vasarlas (szemelyid, autokid, datum) values (1, 2, 20180210); 
55insert into vasarlas (szemelyid, autokid, datum) values (3, 3, 20170913); 
56insert into vasarlas (szemelyid, autokid, datum) values (3, 5, 20180419); 
57insert into vasarlas (szemelyid, autokid, datum) values (3, 6, 20180401); 
58insert into vasarlas (szemelyid, autokid, datum) values (1, 2, 20180110);