Resolve "Ajouter un compteur de visites"

Closes #89 (closed)

sql/schema.tables.sql

@@ -203,6 +203,16 @@ COMMENT ON COLUMN dailyvalue.computedvalue IS 'Value of the indicator.';
 COMMENT ON COLUMN dailyvalue.comparedvalue IS 'Value of the indicator compared to the normal.';
 CREATE INDEX IF NOT EXISTS "IX_dailyvalue" ON dailyvalue USING btree (date, cell);
 
+CREATE TABLE IF NOT EXISTS dailyvisit(
+    id SERIAL,
+    date DATE NOT NULL,
+    environment VARCHAR NOT NULL,
+    number INTEGER NOT NULL,
+    CONSTRAINT "PK_dailyvisit" PRIMARY KEY (id),
+    CONSTRAINT "UK_dailyvisit" UNIQUE (date, environment)
+);
+COMMENT ON TABLE dailyvisit IS 'Number of visits per day.';
+
 CREATE OR REPLACE VIEW v_i18n
 AS SELECT l.languagetag,
     i.i18nkey,