vernedeng commented on code in PR #8100: URL: https://github.com/apache/inlong/pull/8100#discussion_r1209770774
########## inlong-manager/manager-web/sql/apache_inlong_manager.sql: ########## @@ -580,6 +580,29 @@ CREATE TABLE IF NOT EXISTS `user_role` ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='User Role Table'; +-- ---------------------------- +-- Table structure for inlong_user_role +-- ---------------------------- +CREATE TABLE IF NOT EXISTS `inlong_user_role` +( + `id` int(11) NOT NULL AUTO_INCREMENT, + `user_name` varchar(256) NOT NULL COMMENT 'Username', + `role_code` varchar(256) NOT NULL COMMENT 'User role code', + `disabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Whether to disabled, 0: enabled, 1: disabled', + `is_deleted` int(11) DEFAULT '0' COMMENT 'Whether to delete, 0 is not deleted, if greater than 0, delete', + `creator` varchar(256) NOT NULL COMMENT 'Creator name', + `modifier` varchar(256) DEFAULT NULL COMMENT 'Modifier name', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Create time', + `modify_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Modify time', + `version` int(11) NOT NULL DEFAULT '1' COMMENT 'Version number, which will be incremented by 1 after modification', + PRIMARY KEY (`id`), + UNIQUE KEY `unique_user_role` (`user_name`, `role_code`, `is_deleted`) Review Comment: fixed, thx -- 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...@inlong.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
