shwstppr commented on code in PR #7397:
URL: https://github.com/apache/cloudstack/pull/7397#discussion_r1173701105
##########
engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql:
##########
@@ -131,3 +131,37 @@ CREATE VIEW `cloud`.`async_job_view` AS
left join
`cloud`.`autoscale_vmgroups` ON async_job.instance_id =
autoscale_vmgroups.id;
+--TODO: Create indexes
+DROP TABLE IF EXISTS `cloud`.`vm_schedule`;
+CREATE TABLE `cloud`.`vm_schedule` (
+ `id` bigint unsigned NOT NULL auto_increment COMMENT 'id',
+ `vm_id` bigint unsigned NOT NULL,
+ `uuid` varchar(40) NOT NULL COMMENT 'schedule uuid',
+ `name` varchar(255) NOT NULL COMMENT 'name of the vm schedule',
+ `description` varchar(1024) COMMENT 'description of the vm schedule',
+ `schedule` varchar(255) NOT NULL COMMENT 'schedule frequency in cron format',
+ `timezone` varchar(100) NOT NULL COMMENT 'the timezone in which the schedule
time is specified',
+ `action` varchar(20) NOT NULL COMMENT 'action to perform',
+ `enabled` int(1) NOT NULL COMMENT 'Enabled or disabled',
+ `start_date` datetime NOT NULL COMMENT 'start time for this usage item',
+ `end_date` datetime COMMENT 'end time for this usage item',
+ `created` datetime NOT NULL COMMENT 'date created',
Review Comment:
re-check comments. Some may not be making sense
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
