12 lines
865 B
SQL
12 lines
865 B
SQL
INSERT INTO players(licence_number,last_name,first_name,category,usual_team_id) VALUES
|
|
('DEMO-AMIL','AMIL','Riyad','Senior',1),
|
|
('DEMO-002','MARTIN','Lucas','Senior',2),
|
|
('DEMO-003','DUPONT','Hugo','U20',3),
|
|
('DEMO-004','BERNARD','Théo','Senior',4);
|
|
INSERT INTO sanctions(player_id,sanction_type,status,effective_date,matches_required,label,external_ref) VALUES
|
|
((SELECT id FROM players WHERE licence_number='DEMO-AMIL'),'commission','official','2026-05-25',1,'CAS PÉDAGOGIQUE - 1 match ferme','DEMO-DEC-AMIL');
|
|
INSERT INTO matches(fff_match_id,team_id,match_date,opponent,competition,status,counts_for_purge) VALUES
|
|
('DEMO-E3-3105',3,'2026-05-31','Adversaire pédagogique','Championnat','played',1),
|
|
('DEMO-E1-0706',1,'2026-06-07','Adversaire E1','Championnat','scheduled',0),
|
|
('DEMO-E3-0706',3,'2026-06-07','Adversaire E3','Championnat','scheduled',0);
|