mirror of
https://github.com/Icinga/icingaweb2.git
synced 2026-05-21 01:15:26 -04:00
662de28f85
Add SPDX license headers and mark source files as GPL-3.0-or-later to preserve the option to relicense under later GPL versions.
16 lines
615 B
SQL
16 lines
615 B
SQL
-- SPDX-FileCopyrightText: 2023 Icinga GmbH <https://icinga.com>
|
|
-- SPDX-License-Identifier: GPL-3.0-or-later
|
|
|
|
CREATE TYPE boolenum AS ENUM ('n', 'y');
|
|
|
|
ALTER TABLE icingaweb_schema
|
|
ALTER COLUMN timestamp TYPE bigint,
|
|
ALTER COLUMN version TYPE varchar(64),
|
|
ADD COLUMN success boolenum DEFAULT NULL,
|
|
ADD COLUMN reason text DEFAULT NULL,
|
|
ADD CONSTRAINT idx_icingaweb_schema_version UNIQUE (version);
|
|
|
|
UPDATE icingaweb_schema SET timestamp = timestamp * 1000, success = 'y';
|
|
|
|
INSERT INTO icingaweb_schema (version, timestamp, success, reason)
|
|
VALUES('2.12.0', EXTRACT(EPOCH FROM now()) * 1000, 'y', NULL);
|