
CREATE TABLE gaulois (
    gauno numeric(3,0) PRIMARY KEY,
    nom character varying(15) NOT NULL,           
    sexe character(1),
    metier character varying(15),                 
    vilno numeric(2,0),                           
    CONSTRAINT ck_sexe CHECK (sexe ='M' or sexe='F') 
);

INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (102, 'Idefix', NULL, 'gardien', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (1, 'Diagnostix', 'M', 'druide', 5);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (2, 'Alambix', 'M', 'commercant', 3);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (3, 'Pourquepix', 'M', 'commercant', 3);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (4, 'Pronostix', 'M', 'commercant', 3);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (5, 'Bainpuplix', 'M', 'commercant', 3);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (16, 'Laringolix', 'M', 'druide', 2);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (6, 'Coquelus', 'M', 'fabricant roues', 4);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (7, 'Pronostix', 'M', 'druide', 4);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (8, 'Caius Laius', 'M', 'garcon de bains', 4);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (9, 'Gracchus', 'M', 'garcon de bains', 4);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (10, 'Tomatojus', 'M', 'garcon de bains', 4);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (11, 'Caliguliminix', 'M', 'guide', 1);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (12, 'Cetyounix', 'M', 'guerrier', 1);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (13, 'Zebigbos', 'M', 'chef', 4);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (14, 'Hypotenus', 'M', 'garcon de bains', 5);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (15, 'Otorino', 'M', 'druide', 1);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (17, 'Vercingetorix', 'M', 'chef gaulois', 2);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (18, 'Jolitorax', 'M', 'guerrier', 10);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (19, 'Mac Anoterapix', 'M', 'guerrier', 10);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (20, 'Cassivellaunos', 'M', 'chef', 11);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (21, 'Bouilleurdecrus', 'M', 'aubergiste', 1);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (22, 'Angine', 'F', 'aubergiste', 1);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (23, 'Coriza', 'F', 'ecoliere', 1);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (24, 'Marjolaine', 'F', 'druide', 4);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (100, 'Asterix', 'M', 'guerrier', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (101, 'Obelix', 'M', 'livreur menhirs', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (103, 'Abraracourcix', 'M', 'chef', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (104, 'Bonemine', 'F', 'femme du chef', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (105, 'Agecanonix', 'M', 'retraite', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (106, 'Jolifleur', 'F', NULL, 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (107, 'Ordralfabetix', 'M', 'poissonnier', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (108, 'Ielosubmarine', 'F', 'poissonniere', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (109, 'Panoramix', 'M', 'druide', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (110, 'Assurancetourix', 'M', 'barde', 8);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (25, 'Aplusbegalix', 'M', 'chef', 6);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (26, 'Catedralgotix', 'M', 'ecolier', 6);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (27, 'Berlix', 'M', 'professeur', 6);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (28, 'Amnesix', 'M', 'druide', 9);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (29, 'Boufiltre', 'F', 'aide druide', 9);
INSERT INTO gaulois (gauno, nom, sexe, metier, vilno) VALUES (30, 'Industrichimix', 'M', 'ecolier', 6);









CREATE TABLE village (
    vilno numeric(2,0) PRIMARY KEY,
    nom character varying(20) NOT NULL,
    nbhutte numeric(3,0),
    chef numeric(3,0)
);


INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (1, 'Lutece', 734, NULL);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (3, 'Gergovie', 45, NULL);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (5, 'Aquae Calidae', 15, NULL);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (7, 'Clairmont', 458, NULL);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (9, 'Illkirch les bains', 35, NULL);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (12, 'Fantome', 17, NULL);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (2, 'Alesia', 568, 17);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (4, 'Borvo', 5, 13);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (6, 'Serum', 356, 25);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (8, 'Village gaulois', 15, 103);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (10, 'Lugdunum', 87, 18);
INSERT INTO village (vilno, nom, nbhutte, chef) VALUES (11, 'Uderzoville', 8, 20);

ALTER TABLE village
    ADD FOREIGN KEY (chef) REFERENCES gaulois(gauno);

ALTER TABLE gaulois
    ADD FOREIGN KEY (vilno) REFERENCES village(vilno);




CREATE TABLE camp (
    campno numeric(6,0) PRIMARY KEY,
    nom character varying(40),
    nbtente numeric(6,0),
    nblegio numeric(6,0)
);


INSERT INTO camp (campno, nom, nbtente, nblegio) VALUES (1, 'BABAORUM', 456, 2500);
INSERT INTO camp (campno, nom, nbtente, nblegio) VALUES (2, 'PETITBONUM', 300, 2000);
INSERT INTO camp (campno, nom, nbtente, nblegio) VALUES (3, 'LAUDANUM', 150, 500);
INSERT INTO camp (campno, nom, nbtente, nblegio) VALUES (4, 'AQUARIUM', 530, 2895);

CREATE TABLE potion (
    potno numeric(3,0) PRIMARY KEY,
    nom character varying(20),
    effet character varying(40),
    duree numeric(3,0)
);


INSERT INTO potion (potno, nom, effet, duree) VALUES (1, 'Invincibilite', 'Donne une force colossale', 2);
INSERT INTO potion (potno, nom, effet, duree) VALUES (2, 'Invisibilite', 'Rend invisible', 1);
INSERT INTO potion (potno, nom, effet, duree) VALUES (3, 'Genuis', 'Rend intelligent', 1);
INSERT INTO potion (potno, nom, effet, duree) VALUES (4, 'Jouvence', 'Rajeunit de 10 ans', 5);
INSERT INTO potion (potno, nom, effet, duree) VALUES (5, 'Gentil', 'Rend gentil', 2);
INSERT INTO potion (potno, nom, effet, duree) VALUES (6, 'Dodo', 'Fait dormir profondement', 3);
INSERT INTO potion (potno, nom, effet, duree) VALUES (7, 'Aphrodisiaque', '... rend inapte au combat', 1);

CREATE TABLE druide_potion (
    gauno numeric(3,0) NOT NULL,
    potno numeric(3,0) NOT NULL,
    CONSTRAINT pk_druide_potion PRIMARY KEY (gauno, potno),
    CONSTRAINT fk_druide_potion_gauno FOREIGN KEY (gauno) REFERENCES gaulois(gauno),
    CONSTRAINT fk_druide_potion_potno FOREIGN KEY (potno) REFERENCES potion(potno)
);


INSERT INTO druide_potion (gauno, potno) VALUES (1, 5);
INSERT INTO druide_potion (gauno, potno) VALUES (109, 1);
INSERT INTO druide_potion (gauno, potno) VALUES (109, 2);
INSERT INTO druide_potion (gauno, potno) VALUES (109, 3);
INSERT INTO druide_potion (gauno, potno) VALUES (109, 4);
INSERT INTO druide_potion (gauno, potno) VALUES (109, 5);
INSERT INTO druide_potion (gauno, potno) VALUES (109, 6);
INSERT INTO druide_potion (gauno, potno) VALUES (109, 7);
INSERT INTO druide_potion (gauno, potno) VALUES (16, 4);
INSERT INTO druide_potion (gauno, potno) VALUES (16, 7);
INSERT INTO druide_potion (gauno, potno) VALUES (7, 7);
INSERT INTO druide_potion (gauno, potno) VALUES (7, 1);
INSERT INTO druide_potion (gauno, potno) VALUES (15, 2);
INSERT INTO druide_potion (gauno, potno) VALUES (15, 3);
INSERT INTO druide_potion (gauno, potno) VALUES (15, 4);
INSERT INTO druide_potion (gauno, potno) VALUES (15, 5);
INSERT INTO druide_potion (gauno, potno) VALUES (15, 6);
INSERT INTO druide_potion (gauno, potno) VALUES (15, 7);
INSERT INTO druide_potion (gauno, potno) VALUES (28, 1);
INSERT INTO druide_potion (gauno, potno) VALUES (28, 3);
INSERT INTO druide_potion (gauno, potno) VALUES (28, 5);
INSERT INTO druide_potion (gauno, potno) VALUES (28, 7);
INSERT INTO druide_potion (gauno, potno) VALUES (24, 1);
INSERT INTO druide_potion (gauno, potno) VALUES (24, 4);
INSERT INTO druide_potion (gauno, potno) VALUES (24, 7);
INSERT INTO druide_potion (gauno, potno) VALUES (106, 4);
INSERT INTO druide_potion (gauno, potno) VALUES (27, 3);

CREATE TABLE absorption (
    gauno numeric(3,0) NOT NULL,
    potno numeric(3,0) NOT NULL,
    dateab date NOT NULL,
    doses numeric(3,0),
    CONSTRAINT pk_absorption PRIMARY KEY (gauno, potno, dateab),
    CONSTRAINT fk_absorption_gauno FOREIGN KEY (gauno) REFERENCES gaulois(gauno),
    CONSTRAINT fk_absorption_potno FOREIGN KEY (potno) REFERENCES potion(potno)
);


INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (1, 1, '0020-05-15', 3);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (1, 2, '0022-04-20', 15);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (1, 3, '0026-11-14', 33);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (5, 4, '0026-05-12', 7);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (100, 1, '0021-06-16', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (101, 1, '0021-06-16', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (103, 1, '0021-06-16', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (104, 1, '0021-06-16', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (105, 1, '0021-06-16', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (106, 1, '0021-06-16', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (107, 1, '0021-06-16', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (108, 1, '0021-06-16', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (110, 1, '0021-06-16', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (100, 1, '0024-04-01', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (101, 1, '0024-04-01', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (103, 1, '0024-04-01', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (104, 1, '0024-04-01', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (105, 1, '0024-04-01', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (106, 1, '0024-04-01', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (107, 1, '0024-04-01', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (108, 1, '0024-04-01', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (110, 1, '0024-04-01', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (100, 1, '0023-10-09', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (101, 1, '0023-10-09', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (103, 1, '0023-10-09', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (104, 1, '0023-10-09', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (105, 1, '0023-10-09', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (106, 1, '0023-10-09', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (107, 1, '0023-10-09', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (108, 1, '0023-10-09', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (110, 1, '0023-10-09', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (100, 1, '0021-12-05', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (101, 1, '0021-12-05', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (103, 1, '0021-12-05', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (104, 1, '0021-12-05', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (105, 1, '0021-12-05', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (106, 1, '0021-12-05', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (107, 1, '0021-12-05', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (108, 1, '0021-12-05', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (110, 1, '0021-12-05', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (100, 1, '0026-02-13', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (101, 1, '0026-02-13', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (103, 1, '0026-02-13', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (104, 1, '0026-02-13', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (105, 1, '0026-02-13', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (106, 1, '0026-02-13', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (107, 1, '0026-02-13', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (108, 1, '0026-02-13', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (110, 1, '0026-02-13', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (13, 1, '0022-12-12', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (24, 1, '0022-12-12', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (2, 3, '0020-01-10', 4);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (3, 5, '0022-06-05', 2);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (18, 7, '0024-02-28', 7);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (14, 2, '0028-02-29', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (22, 4, '0027-12-24', 8);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (23, 4, '0022-05-10', 3);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (24, 4, '0027-07-20', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (104, 4, '0026-05-10', 3);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (106, 4, '0024-03-19', 7);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (108, 4, '0025-05-03', 1);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (3, 1, '0020-01-10', 2);
INSERT INTO absorption (gauno, potno, dateab, doses) VALUES (3, 3, '0020-01-10', 2);

CREATE TABLE bataille (
    batno numeric(3,0) PRIMARY KEY,
    nom character varying(20),
    vilno numeric(2,0) NOT NULL,
    campno numeric(6,0) NOT NULL,
    datebat date,
    duree integer,
    CONSTRAINT fk_bataille_campno FOREIGN KEY (campno) REFERENCES camp(campno),
    CONSTRAINT fk_bataille_vilno FOREIGN KEY (vilno) REFERENCES village(vilno)
);

INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (1, 'alesia', 5, 1, '0020-05-15', 2);
INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (5, 'gergovie', 8, 1, '0021-06-16', 1);
INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (6, 'poisson d avril', 8, 1, '0024-04-01', 1);
INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (2, NULL, 5, 2, '0022-04-20', 3);
INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (3, NULL, 4, 3, '0025-12-12', 1);
INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (4, NULL, 4, 3, '0027-05-03', 5);
INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (7, NULL, 8, 2, '0023-10-09', 1);
INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (8, NULL, 8, 3, '0021-12-05', 1);
INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (9, NULL, 8, 4, '0026-02-13', 1);
INSERT INTO bataille (batno, nom, vilno, campno, datebat, duree) VALUES (10, NULL, 1, 3, '0022-10-02', 3);

CREATE TABLE trophee (
    gauno numeric(3,0) NOT NULL,
    batno numeric(3,0) NOT NULL,
    grade character varying(20) NOT NULL,
    nbcasque numeric(3,0),
    CONSTRAINT pk_trophee PRIMARY KEY (gauno, batno, grade),
    CONSTRAINT fk_trophee_batno FOREIGN KEY (batno) REFERENCES bataille(batno),
    CONSTRAINT fk_trophee_gauno FOREIGN KEY (gauno) REFERENCES gaulois(gauno)
);


INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (100, 5, 'Tribun', 1);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (100, 5, 'Decurion', 4);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (100, 5, 'Legionnaire', 57);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (101, 5, 'Centurion', 1);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (101, 5, 'Decurion', 2);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (101, 5, 'Legionnaire', 52);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (103, 5, 'Legionnaire', 13);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (105, 5, 'Legionnaire', 5);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (107, 5, 'Legionnaire', 6);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (100, 6, 'Legionnaire', 21);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (101, 6, 'Centurion', 1);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (101, 6, 'Legionnaire', 34);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (103, 6, 'Legionnaire', 11);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (105, 6, 'Legionnaire', 4);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (107, 6, 'Legionnaire', 9);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (110, 6, 'Decurion', 2);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (20, 6, 'Decurion', 2);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (20, 6, 'Legionnaire', 19);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (14, 1, 'Centurion', 1);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (14, 1, 'Legionnaire', 14);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (13, 3, 'Tribun', 1);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (13, 3, 'Centurion', 1);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (13, 3, 'Legionnaire', 57);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (24, 3, 'Decurion', 3);
INSERT INTO trophee (gauno, batno, grade, nbcasque) VALUES (24, 3, 'Legionnaire', 38);

