Johannes Meyer 9cff754602 pgsql: Add table icingaweb_schema
Co-authored-by: Eric Lippmann <eric.lippmann@icinga.com>
2022-06-30 13:26:58 +02:00

11 lines
275 B
SQL

CREATE TABLE "icingaweb_schema" (
"id" serial,
"version" smallint NOT NULL,
"timestamp" int NOT NULL,
CONSTRAINT pk_icingaweb_schema PRIMARY KEY ("id")
);
INSERT INTO icingaweb_schema ("version", "timestamp")
VALUES (6, extract(epoch from now()));