icingaweb2/schema/pgsql-upgrades/2.5.0.sql

-- SPDX-FileCopyrightText: 2018 Icinga GmbH <https://icinga.com>
-- SPDX-License-Identifier: GPL-3.0-or-later

ALTER TABLE "icingaweb_group_membership" ALTER COLUMN "username" TYPE character varying(254);
ALTER TABLE "icingaweb_user" ALTER COLUMN "name" TYPE character varying(254);
ALTER TABLE "icingaweb_user_preference" ALTER COLUMN "username" TYPE character varying(254);
License source files as GPL-3.0-or-later Add SPDX license headers and mark source files as GPL-3.0-or-later to preserve the option to relicense under later GPL versions. 2026-03-26 12:46:27 -04:00			`-- SPDX-FileCopyrightText: 2018 Icinga GmbH <https://icinga.com>`
			`-- SPDX-License-Identifier: GPL-3.0-or-later`
Schema: Increase length of username columns In order to support usernames with domains, the length of the username columns is now 254 which also supports email addresses as usernames. refs #2153 2017-06-07 09:52:41 -04:00
			`ALTER TABLE "icingaweb_group_membership" ALTER COLUMN "username" TYPE character varying(254);`
			`ALTER TABLE "icingaweb_user" ALTER COLUMN "name" TYPE character varying(254);`
			`ALTER TABLE "icingaweb_user_preference" ALTER COLUMN "username" TYPE character varying(254);`