15 lines
317 B
SQL
15 lines
317 B
SQL
CREATE TABLE last_check (
|
|
last DATETIME
|
|
);
|
|
CREATE TABLE Villes (
|
|
code_INSEE SMALL INT PRIMARY KEY,
|
|
nom VARCHAR(255)
|
|
);
|
|
CREATE TABLE chiffres (
|
|
date DATETIME,
|
|
code_INSEE SMALL INT,
|
|
nombre INTEGER,
|
|
PRIMARY KEY( date, code_INSEE),
|
|
FOREIGN KEY(code_INSEE) REFERENCES Villes(code_INSEE)
|
|
);
|