[GitHub] [cloudstack] SadiJr commented on a diff in pull request #7236: [Usage] Create network billing

["SadiJr (via GitHub)" <gi...@apache.org>]

SadiJr commented on code in PR #7236:
URL: https://github.com/apache/cloudstack/pull/7236#discussion_r1303382761


##########
engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql:
##########
@@ -180,3 +180,19 @@ CREATE TABLE `cloud`.`vm_scheduled_job` (
 -- Add support for different cluster types for kubernetes
 ALTER TABLE `cloud`.`kubernetes_cluster` ADD COLUMN `cluster_type` varchar(64) DEFAULT 'CloudManaged' COMMENT 'type of cluster';
 ALTER TABLE `cloud`.`kubernetes_cluster` MODIFY COLUMN `kubernetes_version_id` bigint unsigned NULL COMMENT 'the ID of the Kubernetes version of this Kubernetes cluster';
+
+-- Create table to network billing #7236
+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,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB CHARSET=utf8;
+
+ALTER TABLE `cloud_usage`.`cloud_usage` ADD COLUMN state VARCHAR(100) DEFAULT NULL;

Review Comment:
   Done, thanks.



-- 
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-unsubscribe@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org