1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
| insert into Formation values
(1,1)
, (2,2)
, (3,3)
;
select '' as Formation, * from Formation ;
insert into Monstre values
(1,'m1')
, (2,'m2')
, (3,'m3')
, (4,'m4')
, (5,'m5')
;
select '' as Monstre,* from Monstre ;
insert into Agreger values
(1,1)
, (1,2)
, (1,3)
, (2,1)
, (2,3)
, (2,4)
, (3,2)
, (3,5)
;
select '' as Agreger,* from Agreger ;
insert into Frenesie values
(1,'f1')
, (2,'f2')
, (3,'f3')
, (4,'f4')
, (5,'f5')
;
select '' as Frenesie, * from Frenesie ;
insert into Utilisateur values
(1,'u1')
, (2,'u2')
, (3,'u3')
;
select '' as Utilisateur, * from Utilisateur ;
insert into Rencontrer values
(1,1)
, (1,2)
, (2,1)
, (2,2)
, (2,3)
;
select '' as Rencontrer, * from Rencontrer ;
insert into Acquerir values
(1,1)
, (1,3)
, (2,1)
, (2,4)
, (3,2)
, (1,5) UFM ne sera pas daccord
;
select '' as Acquerir, * from Acquerir ;
insert into UFM values
(1,1,1)
, (1,1,3)
;
select '' as UFM, * from UFM ; -- ok
insert into UFM values
(1,3,5) -- délinquant : lutilisateur 1 na pas rencontré la formation 3
;
select '' as UFM, * from UFM ; -- ko |
Partager