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
|
CREATE TABLE JOUEUR (
code int not null,
nom char(50) not null,
prenom char(50) not null,
/* patatipatata */
CONSTRAINT pk_joueur PRIMARY KEY (code))
CREATE TABLE APTITUDE (
code int not null,
nom char(30) not null,
typeA tinyint not null,
CONSTRAINT pk_aptitude PRIMARY KEY (code))
CREATE TABLE POSSEDER (
codeJoueur int not null,
codeAptitude int not null,
note int not null,
CONSTRAINT pk_posseder PRIMARY KEY (codeJoueur,codeAptitude),
CONSTRAINT fk_posseder_joueur FOREIGN KEY (codeJoueur) REFERENCES JOUEUR (code),
CONSTRAINT fk_posseder_aptitude FOREIGN KEY (codeAptitude) REFERENCES APTITUDE (code))
INSERT INTO JOUEUR VALUES (1,'Ardeois','Romuald')
INSERT INTO JOUEUR VALUES (2,'Mélaise','Pierre')
INSERT INTO APTITUDE VALUES (1,'Passe',1)
INSERT INTO APTITUDE VALUES (2,'Tir',1)
INSERT INTO APTITUDE VALUES (3,'Tacle',1)
INSERT INTO APTITUDE VALUES (4,'Marquage',1)
INSERT INTO APTITUDE VALUES (5,'Tête',1)
INSERT INTO APTITUDE VALUES (6,'Dribble',1)
INSERT INTO APTITUDE VALUES (7,'Centre',1)
INSERT INTO APTITUDE VALUES (8,'Combativité',2)
INSERT INTO APTITUDE VALUES (9,'Collectif',2)
INSERT INTO APTITUDE VALUES (10,'Créativité',2)
INSERT INTO APTITUDE VALUES (11,'Influence',2)
INSERT INTO APTITUDE VALUES (12,'Placement',2)
INSERT INTO APTITUDE VALUES (13,'Vitesse',3)
INSERT INTO APTITUDE VALUES (14,'Force',3)
INSERT INTO APTITUDE VALUES (15,'Saut',3)
INSERT INTO APTITUDE VALUES (16,'Plongeon',4)
INSERT INTO APTITUDE VALUES (17,'Réactivité',4)
INSERT INTO APTITUDE VALUES (18,'Arrêt aérien',4)
INSERT INTO POSSEDER VALUES (1,1,14)
INSERT INTO POSSEDER VALUES (1,2,19)
INSERT INTO POSSEDER VALUES (1,5,20)
INSERT INTO POSSEDER VALUES (1,6,16)
INSERT INTO POSSEDER VALUES (1,8,12)
INSERT INTO POSSEDER VALUES (1,9,14)
INSERT INTO POSSEDER VALUES (1,10,9)
INSERT INTO POSSEDER VALUES (1,11,7)
INSERT INTO POSSEDER VALUES (1,12,10)
INSERT INTO POSSEDER VALUES (1,13,13)
INSERT INTO POSSEDER VALUES (1,14,16)
INSERT INTO POSSEDER VALUES (1,15,14)
INSERT INTO POSSEDER VALUES (2,1,12)
INSERT INTO POSSEDER VALUES (2,3,15)
INSERT INTO POSSEDER VALUES (2,4,20)
INSERT INTO POSSEDER VALUES (2,6,11)
INSERT INTO POSSEDER VALUES (2,8,16)
INSERT INTO POSSEDER VALUES (2,9,11)
INSERT INTO POSSEDER VALUES (2,10,5)
INSERT INTO POSSEDER VALUES (2,11,9)
INSERT INTO POSSEDER VALUES (2,12,13)
INSERT INTO POSSEDER VALUES (2,13,15)
INSERT INTO POSSEDER VALUES (2,14,18)
INSERT INTO POSSEDER VALUES (2,15,11) |
Partager