[cloudstack] branch main updated: engine-schema: fix schema change for #6960 (#7579)

[rohit]

This is an automated email from the ASF dual-hosted git repository.

rohit pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudstack.git


The following commit(s) were added to refs/heads/main by this push:
     new 841fd725601 engine-schema: fix schema change for #6960 (#7579)
841fd725601 is described below

commit 841fd725601a7add8363e8f400e2509fe1fdd8a8
Author: Abhishek Kumar <abhishek.mr...@gmail.com>
AuthorDate: Thu Jun 1 17:32:42 2023 +0530

    engine-schema: fix schema change for #6960 (#7579)
    
    Signed-off-by: Abhishek Kumar <abhishek.mr...@gmail.com>
---
 engine/schema/src/main/resources/META-INF/db/schema-41800to41810.sql | 3 ---
 engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql | 2 ++
 2 files changed, 2 insertions(+), 3 deletions(-)

diff --git 
a/engine/schema/src/main/resources/META-INF/db/schema-41800to41810.sql 
b/engine/schema/src/main/resources/META-INF/db/schema-41800to41810.sql
index 2bd19fe2cc6..b3600522f99 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41800to41810.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41800to41810.sql
@@ -19,9 +19,6 @@
 -- Schema upgrade from 4.18.0.0 to 4.18.1.0
 --;
 
--- create_public_parameter_on_roles. #6960
-ALTER TABLE `cloud`.`roles` ADD COLUMN `public_role` tinyint(1) NOT NULL 
DEFAULT '1' COMMENT 'Indicates whether the role will be visible to all users 
(public) or only to root admins (private). If this parameter is not specified 
during the creation of the role its value will be defaulted to true (public).';
-
 -- Add Windows Server 2022 guest OS and mappings
 CALL ADD_GUEST_OS_AND_HYPERVISOR_MAPPING (6, 'Windows Server 2022 (64-bit)', 
'KVM', 'default', 'Windows Server 2022 (64-bit)');
 CALL ADD_GUEST_OS_AND_HYPERVISOR_MAPPING (6, 'Windows Server 2022 (64-bit)', 
'VMware', '7.0', 'windows2019srvNext_64Guest');
diff --git 
a/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql 
b/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
index 23d607768ac..1cb4f6c9ea3 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
@@ -135,3 +135,5 @@ CREATE VIEW `cloud`.`async_job_view` AS
 UPDATE `cloud`.`console_session` SET removed=now();
 -- Modify acquired column in console_session to datetime type
 ALTER TABLE `cloud`.`console_session` DROP `acquired`, ADD `acquired` datetime 
COMMENT 'When the session was acquired' AFTER `host_id`;
+-- create_public_parameter_on_roles. #6960
+ALTER TABLE `cloud`.`roles` ADD COLUMN `public_role` tinyint(1) NOT NULL 
DEFAULT '1' COMMENT 'Indicates whether the role will be visible to all users 
(public) or only to root admins (private). If this parameter is not specified 
during the creation of the role its value will be defaulted to true (public).';