Skip to content
Snippets Groups Projects

Resolve "Ajouter un compteur de visites"

Merged Olivier Maury requested to merge 89-ajouter-un-compteur-de-visites into main
9 files
+ 195
5
Compare changes
  • Side-by-side
  • Inline
Files
9
+ 10
0
@@ -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,
Loading