table.sql

Create TABLE IF NOT EXISTS genre 
(
    idGen Int not null primary key, 
    nom varchar(20)
);

Create TABLE IF NOT EXISTS film 
(
    tconst varchar(20) not null primary key,
    primaryTitle varchar(100),
    isAdult int,
    startYear int,
    runtimeMinutes int,
    averageRating float,
    numVotes int,
    titleFR varchar(250)
);

Create TABLE IF NOT EXISTS Utilisateur
(
    login varchar(20) not null primary key,
    mdp varchar(30) not null,
    dateNais date not null default (current_date)

);