hsato03 commented on code in PR #7236:
URL: https://github.com/apache/cloudstack/pull/7236#discussion_r1576575935
##########
engine/schema/src/main/resources/META-INF/db/schema-41900to41910.sql:
##########
@@ -31,6 +31,18 @@ SET usage_unit = 'IOPS', updated_on = NOW()
WHERE effective_on = '2010-05-04 00:00:00'
AND name IN ('VM_DISK_IO_READ', 'VM_DISK_IO_WRITE');
+-- PR #7236 - [Usage] Create network billing
+CREATE TABLE IF NOT EXISTS `cloud_usage`.`usage_networks` (
+ `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
+ `network_offering_id` bigint(20) unsigned NOT NULL,
+ `zone_id` bigint(20) unsigned NOT NULL,
+ `network_id` bigint(20) unsigned NOT NULL,
+ `account_id` bigint(20) unsigned NOT NULL,
+ `domain_id` bigint(20) unsigned NOT NULL,
+ `state` varchar(100) DEFAULT NULL,
+ `removed` datetime DEFAULT NULL,
+ `created` datetime NOT NULL,
+
Review Comment:
I think there are some constraints that need to be stated here.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
