TP_Intergiciel/db.sql at main · PHugues/TP_Intergiciel · GitHub

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
CREATE DATABASE covid19
    WITH
    OWNER = postgres
    ENCODING = 'UTF8'
    CONNECTION LIMIT = -1;

\c covid19

CREATE TABLE IF NOT EXISTS world (
    NewConfirmed INT NOT NULL,
    TotalConfirmed INT NOT NULL,
    NewDeaths INT NOT NULL,
    TotalDeaths INT NOT NULL,
    NewRecovered INT NOT NULL,
    TotalRecovered INT NOT NULL,
    Datemaj TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS countries (
    Country VARCHAR(200) NOT NULL,
    CountryCode VARCHAR(6) NOT NULL,
    Slug VARCHAR(200) NOT NULL,
    NewConfirmed INT NOT NULL,
    TotalConfirmed INT NOT NULL,
    NewDeaths INT NOT NULL,
    TotalDeaths INT NOT NULL,
    NewRecovered INT NOT NULL,
    TotalRecovered INT NOT NULL,
    Datemaj TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP
);