icingaweb2/schema/pgsql-upgrades/2.11.0.sql

14 lines
386 B
MySQL
Raw Permalink Normal View History

-- SPDX-FileCopyrightText: 2022 Icinga GmbH <https://icinga.com>
-- SPDX-License-Identifier: GPL-3.0-or-later
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()));