RelationalDesign: polnenje.sql

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