create table player (
p_id INT AUTO_INCREMENT PRIMARY KEY,
p_name VARCHAR(40),
p_password VARCHAR(255),
p_email VARCHAR(255));
insert into player (p_name, p_password, p_email)
values
('john','12345678','john@dow.game'),
('jane','12345678','jane@djung.le');
select * from player;
create table vehicle(
v_id INT AUTO_INCREMENT PRIMARY KEY,
v_typ VARCHAR(20),
v_manufactuer VARCHAR(20),
v_model VARCHAR(20)
);
insert into vehicle (v_typ, v_manufactuer, v_model)
values
( 'PKW', 'Mercedes', '200'),
( 'Traktor', 'K-700', 'VEB');
select * from vehicle;
create table player_vehicle(
pv_id INT AUTO_INCREMENT PRIMARY KEY,
p_id INT,
v_id INT,
v_licensenumber VARCHAR(40),
FOREIGN KEY(p_id)
REFERENCES player(p_id),
FOREIGN KEY(v_id)
REFERENCES vehicle(v_id));
insert into player_vehicle (p_id, v_id, v_licensenumber)
values
(1, 1, 'B-DG-100'),
(1, 2, 'B-DG-101'),
(2, 1, 'B-DG-101');
select * from player_vehicle;
select * from player p, player_vehicle pv, vehicle v
where p.p_id = pv.p_id
and pv.v_id = v.v_id;