1 | insert into clubs ( clubid, clubname)
|
---|
2 | values ( '1', 'PSG'), ('2','Barcelona'), ('3','Real_Madrid'), ('4','Bayern_Munchen');
|
---|
3 |
|
---|
4 | insert into players( playerid, playername, clubid)
|
---|
5 | values ( '1', 'Mbappe', '1'), ('2','Lewandowski','2'), ('3','Vinicius_JR', '3'), ('4','Mane','4');
|
---|
6 |
|
---|
7 | insert into stadiums( stadiumid , stadiumName, clubid)
|
---|
8 | values ( '1', 'San_Siro', '1'), ('2','Park_of_Prince','2'), ('3','Santiago_Bernabeu', '3');
|
---|
9 |
|
---|
10 | insert into injuries ( injuryid, playerid, injurytype, injurydate)
|
---|
11 | values ( '1','1', 'broken_leg', '2023-06-01'), ( '2','2', 'broken_ankle', '2023-04-21'), ( '3','3', 'ligament', '2023-11-09');
|
---|
12 |
|
---|
13 | insert into cards( cardid, playerid, cardtype, carddate)
|
---|
14 | values ( '1','1', 'yellow', '2023-12-09'), ( '2','2', 'yellow', '2023-12-21'), ( '3','3', 'red', '2023-12-15');
|
---|
15 |
|
---|
16 | insert into Ratings (ID, Rating1, Rating2)
|
---|
17 | values (1, 4, 5);
|
---|
18 |
|
---|
19 | insert into Users (ID, Username, Password1, Email)
|
---|
20 | values (1, 'David', 'password12345', 'david@mail.com');
|
---|
21 |
|
---|
22 |
|
---|
23 |
|
---|
24 |
|
---|
25 |
|
---|
26 |
|
---|