weizhouapache commented on code in PR #9504:
URL: https://github.com/apache/cloudstack/pull/9504#discussion_r1952523968
##########
engine/schema/src/main/resources/META-INF/db/schema-42010to42100.sql:
##########
@@ -37,3 +37,37 @@ WHERE rp.rule = 'quotaStatement'
AND NOT EXISTS(SELECT 1 FROM cloud.role_permissions rp_ WHERE rp.role_id =
rp_.role_id AND rp_.rule = 'quotaCreditsList');
CALL `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.host', 'last_mgmt_server_id',
'bigint unsigned DEFAULT NULL COMMENT "last management server this host is
connected to" AFTER `mgmt_server_id`');
+
+
+-- Create user token_keypairs table for apikey/secretkey tokens
+CREATE TABLE IF NOT EXISTS `cloud`.`api_keypair` (
+ `id` bigint(20) unsigned NOT NULL auto_increment,
+ `uuid` varchar(40) UNIQUE NOT NULL,
+ `name` varchar(255) NOT NULL,
+ `domain_id` bigint(20) unsigned NOT NULL,
+ `account_id` bigint(20) unsigned NOT NULL,
+ `user_id` bigint(20) unsigned NOT NULL,
+ `start_date` datetime,
+ `end_date` datetime,
+ `description` varchar(100),
+ `api_key` varchar(255) NOT NULL,
+ `secret_key` varchar(255) NOT NULL,
+ `created` datetime NOT NULL,
+ `removed` datetime,
+ PRIMARY KEY (`id`),
+ CONSTRAINT `fk_api_keypair__user_id` FOREIGN KEY(`user_id`) REFERENCES
`cloud`.`user`(`id`),
+ CONSTRAINT `fk_api_keypair__account_id` FOREIGN KEY(`account_id`)
REFERENCES `cloud`.`account`(`id`),
+ CONSTRAINT `fk_api_keypair__domain_id` FOREIGN KEY(`domain_id`) REFERENCES
`cloud`.`domain`(`id`)
+ );
+
+CREATE TABLE IF NOT EXISTS `cloud`.`keypair_permissions` (
Review Comment:
to avoid confusion, may be better to use `api_keypair_permissions`
--
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
