(cloudstack) branch main updated: Update nw_rate & mc_rate to int unsigned to allow rates > 65Gbps (#13380)

[harikrishna]

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

harikrishna-patnala 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 e63b7da74ce Update nw_rate & mc_rate to int unsigned to allow rates > 
65Gbps (#13380)
e63b7da74ce is described below

commit e63b7da74cea0c38cf50b9784f625f76a0c86925
Author: Pearl Dsilva <pearl1...@gmail.com>
AuthorDate: Mon Jul 6 03:42:14 2026 -0400

    Update nw_rate & mc_rate to int unsigned to allow rates > 65Gbps (#13380)
    
    * update column type
    
    * Apply suggestion from @DaanHoogland
    
    Co-authored-by: dahn <d...@onecht.net>
    
    ---------
    
    Co-authored-by: Daan Hoogland <d...@onecht.net>
    Co-authored-by: Pearl Dsilva <pearl1...@gmail.com>
    Co-authored-by: Wei Zhou <weiz...@apache.org>
    Co-authored-by: Harikrishna <harikrishna.patn...@gmail.com>
---
 .../src/main/resources/META-INF/db/schema-42210to42300.sql       | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git 
a/engine/schema/src/main/resources/META-INF/db/schema-42210to42300.sql 
b/engine/schema/src/main/resources/META-INF/db/schema-42210to42300.sql
index 97c40115b5a..3c434136961 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-42210to42300.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-42210to42300.sql
@@ -457,6 +457,15 @@ CALL `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.gui_themes', 
'login_base_domain', 'T
 -- Add description for secondary IP addresses
 CALL `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.nic_secondary_ips', 'description', 
'VARCHAR(2048) DEFAULT NULL');
 
+--- Change nw_rate and mc_rate column types from smallint unsigned to int 
unsigned to support larger rate values
+ALTER TABLE `cloud`.`service_offering`
+    MODIFY COLUMN `nw_rate` int unsigned DEFAULT 200 COMMENT 'network rate 
throttle mbits/s',
+    MODIFY COLUMN `mc_rate` int unsigned DEFAULT 10 COMMENT 'mcast rate 
throttle mbits/s';
+
+ALTER TABLE `cloud`.`network_offerings`
+    MODIFY COLUMN `nw_rate` int unsigned COMMENT 'network rate throttle 
mbits/s',
+    MODIFY COLUMN `mc_rate` int unsigned COMMENT 'mcast rate throttle mbits/s';
+
 -- Soft delete port forwarding, load balancing and firewall rules
 CALL `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.firewall_rules', 'removed', 
'datetime DEFAULT NULL');
 CALL `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.load_balancer_vm_map', 'removed', 
'datetime DEFAULT NULL');