macksonmu commented on code in PR #1831: URL: https://github.com/apache/incubator-streampark/pull/1831#discussion_r996293095
########## streampark-console/streampark-console-service/src/assembly/script/upgrade/mysql/1.2.4.sql: ########## @@ -201,5 +205,21 @@ alter table `t_user` modify `username` varchar(255) collate utf8mb4_general_ci not null comment 'user name', add unique key `un_username` (`username`) using btree; +drop table if exists `t_variable`; +create table `t_variable` ( + `id` bigint not null auto_increment, + `variable_code` varchar(100) collate utf8mb4_general_ci not null comment 'Variable code is used for parameter names passed to the program or as placeholders', + `variable_value` text collate utf8mb4_general_ci not null comment 'The specific value corresponding to the variable', + `variable_name` varchar(100) collate utf8mb4_general_ci not null comment 'The name of the variable is used for simple display and for searching', + `description` text collate utf8mb4_general_ci default null comment 'More detailed description of variables, only for display, not involved in program logic', + `creator` bigint collate utf8mb4_general_ci not null comment 'user_id of creator', + `team_id` bigint collate utf8mb4_general_ci not null comment 'team id', + `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', + primary key (`id`) using btree, + unique key `un_team_vcode_inx` (`team_id`,`variable_code`) using btree, + unique key `un_team_vname_inx` (`team_id`,`variable_name`) using btree Review Comment: Sorry, I missed that, I'll deal with it right away -- 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]
