From 8ca6cc32b2c789a3149861159ad258f2cb9491e3 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 28 Apr 2024 14:39:39 +0200 Subject: Adding upstream version 2.11.4. Signed-off-by: Daniel Baumann --- schema/mysql-upgrades/2.11.0.sql | 33 +++++++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 schema/mysql-upgrades/2.11.0.sql (limited to 'schema/mysql-upgrades/2.11.0.sql') diff --git a/schema/mysql-upgrades/2.11.0.sql b/schema/mysql-upgrades/2.11.0.sql new file mode 100644 index 0000000..99f18cf --- /dev/null +++ b/schema/mysql-upgrades/2.11.0.sql @@ -0,0 +1,33 @@ +ALTER TABLE `icingaweb_group` ROW_FORMAT=DYNAMIC; +ALTER TABLE `icingaweb_group_membership` ROW_FORMAT=DYNAMIC; +ALTER TABLE `icingaweb_user` ROW_FORMAT=DYNAMIC; +ALTER TABLE `icingaweb_user_preference` ROW_FORMAT=DYNAMIC; +ALTER TABLE `icingaweb_rememberme` ROW_FORMAT=DYNAMIC; + +ALTER TABLE `icingaweb_group` CONVERT TO CHARACTER SET utf8mb4; +ALTER TABLE `icingaweb_group_membership` CONVERT TO CHARACTER SET utf8mb4; +ALTER TABLE `icingaweb_user` CONVERT TO CHARACTER SET utf8mb4; +ALTER TABLE `icingaweb_user_preference` CONVERT TO CHARACTER SET utf8mb4; + +ALTER TABLE `icingaweb_group` + MODIFY COLUMN `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL; +ALTER TABLE `icingaweb_group_membership` + MODIFY COLUMN `username` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL; +ALTER TABLE `icingaweb_user` + MODIFY COLUMN `name` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL; + +ALTER TABLE `icingaweb_user_preference` + MODIFY COLUMN `username` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL, + MODIFY COLUMN `section` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, + MODIFY COLUMN `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL; + +CREATE TABLE icingaweb_schema ( + id int unsigned NOT NULL AUTO_INCREMENT, + version smallint unsigned NOT NULL, + timestamp int unsigned NOT NULL, + + PRIMARY KEY (id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC; + +INSERT INTO icingaweb_schema (version, timestamp) + VALUES (6, UNIX_TIMESTAMP()); -- cgit v1.2.3