"Fossies" - the Fresh Open Source Software Archive 
Member "icingaweb2-2.11.4/schema/mysql-upgrades/2.11.0.sql" (26 Jan 2023, 1489 Bytes) of package /linux/www/icingaweb2-2.11.4.tar.gz:
As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style:
standard) with prefixed line numbers.
Alternatively you can here
view or
download the uninterpreted source code file.
1 ALTER TABLE `icingaweb_group` ROW_FORMAT=DYNAMIC;
2 ALTER TABLE `icingaweb_group_membership` ROW_FORMAT=DYNAMIC;
3 ALTER TABLE `icingaweb_user` ROW_FORMAT=DYNAMIC;
4 ALTER TABLE `icingaweb_user_preference` ROW_FORMAT=DYNAMIC;
5 ALTER TABLE `icingaweb_rememberme` ROW_FORMAT=DYNAMIC;
6
7 ALTER TABLE `icingaweb_group` CONVERT TO CHARACTER SET utf8mb4;
8 ALTER TABLE `icingaweb_group_membership` CONVERT TO CHARACTER SET utf8mb4;
9 ALTER TABLE `icingaweb_user` CONVERT TO CHARACTER SET utf8mb4;
10 ALTER TABLE `icingaweb_user_preference` CONVERT TO CHARACTER SET utf8mb4;
11
12 ALTER TABLE `icingaweb_group`
13 MODIFY COLUMN `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL;
14 ALTER TABLE `icingaweb_group_membership`
15 MODIFY COLUMN `username` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL;
16 ALTER TABLE `icingaweb_user`
17 MODIFY COLUMN `name` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL;
18
19 ALTER TABLE `icingaweb_user_preference`
20 MODIFY COLUMN `username` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
21 MODIFY COLUMN `section` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
22 MODIFY COLUMN `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL;
23
24 CREATE TABLE icingaweb_schema (
25 id int unsigned NOT NULL AUTO_INCREMENT,
26 version smallint unsigned NOT NULL,
27 timestamp int unsigned NOT NULL,
28
29 PRIMARY KEY (id)
30 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
31
32 INSERT INTO icingaweb_schema (version, timestamp)
33 VALUES (6, UNIX_TIMESTAMP());