CREATE TABLE Adherent(
    id_patient  INT PRIMARY KEY,
    nom VARCHAR(50) NOT NULL,
    prenom VARCHAR(50) NOT NULL,
    email VARCHAR (50) UNIQUE NOT NULL,
    date_inscription DATE
)Engine = InnodB;

CREATE TABLE Livre (
    id_livre INT PRIMARY KEY,
    titre VARCHAR(50) NOT NULL,
    auteur VARCHAR (50) NOT NULL,
    isbn VARCHAR (50) UNIQUE NOT NULL, 
    disponible BOOLEAN DEFAULT '1' 
)Engine = InnodB;

CREATE TABLE Patient (
    id_patient      INT          PRIMARY KEY,
    nom             VARCHAR(30)  NOT NULL,
    prenom          VARCHAR(30)  NOT NULL,
    date_naissance  DATE
);

INSERT INTO Patient (id_patient, nom, prenom, date_naissance) VALUES
(1, 'Martin',               'Louise',  '1958-04-17'),
(2, 'Bernard',              'Paul',    '1972-11-02'),
(3, 'Dubois',               'Emma',    '1985-06-23'),
(4, 'Thomas',               'Jules',   '1991-01-30'),
(5, 'Robert',               'Inès',    '2003-09-14'),
(6, 'Le Goff-Kerjean',      'Yann',    '1966-08-05');

ALTER TABLE Patient
ADD COLUMN telephone VARCHAR(15);

ALTER TABLE Patient
ADD COLUMN numero_secu VARCHAR (15) NOT NULL; 

ALTER TABLE Patient
MODIFY COLUMN nom VARCHAR(80);