init-db.sql

CREATE TABLE employe (
    numemp VARCHAR(3) PRIMARY KEY,
    nom VARCHAR(20),
    prenom VARCHAR(20)
);

CREATE TABLE projet (
    numprojet VARCHAR(3) PRIMARY KEY,
    description VARCHAR(30),
    budget DECIMAL(10, 2)
);

CREATE TABLE affectation (
    numemp VARCHAR(3),
    numprojet VARCHAR(3),
    heures INT,
    PRIMARY KEY (numemp, numprojet),
    FOREIGN KEY (numemp) REFERENCES employe(numemp),
    FOREIGN KEY (numprojet) REFERENCES projet(numprojet)
);

INSERT INTO employe VALUES ('E01', 'Dupont', 'Marie');
INSERT INTO employe VALUES ('E02', 'Durand', 'Paul');
INSERT INTO employe VALUES ('E03', 'Martin', 'Julie');

INSERT INTO projet VALUES ('P01', 'Intranet', 10000.00);
INSERT INTO projet VALUES ('P02', 'Extranet', 15000.00);
INSERT INTO projet VALUES ('P03', 'Site Web', 20000.00);

INSERT INTO affectation VALUES ('E01', 'P01', 30);
INSERT INTO affectation VALUES ('E02', 'P01', 40);
INSERT INTO affectation VALUES ('E01', 'P02', 20);
INSERT INTO affectation VALUES ('E03', 'P02', 25);
INSERT INTO affectation VALUES ('E01', 'P03', 10);
INSERT INTO affectation VALUES ('E02', 'P03', 15);
INSERT INTO affectation VALUES ('E03', 'P03', 35);