wolfboys commented on code in PR #3537: URL: https://github.com/apache/incubator-streampark/pull/3537#discussion_r1536999643
########## streampark-console/streampark-console-service/src/main/assembly/script/schema/mysql-schema.sql: ########## @@ -556,4 +556,97 @@ create table if not exists `t_resource` ( `modify_time` datetime not null default current_timestamp on update current_timestamp comment 'modify time' ); + +-- ---------------------------- +-- table structure for t_spark_env +-- ---------------------------- +drop table if exists `t_spark_env`; +create table `t_spark_env` ( + `id` bigint not null auto_increment comment 'id', + `spark_name` varchar(128) collate utf8mb4_general_ci not null comment 'spark instance name', + `spark_home` varchar(255) collate utf8mb4_general_ci not null comment 'spark home path', + `version` varchar(64) collate utf8mb4_general_ci not null comment 'spark version', + `scala_version` varchar(64) collate utf8mb4_general_ci not null comment 'scala version of spark', + `spark_conf` text collate utf8mb4_general_ci not null comment 'spark-conf', + `is_default` tinyint not null default 0 comment 'whether default version or not', + `description` varchar(255) collate utf8mb4_general_ci default null comment 'description', + `create_time` datetime not null default current_timestamp comment 'create time', Review Comment: `default current_timestamp` has syntax compatibility issue, change to : `default null` ########## streampark-console/streampark-console-service/src/main/assembly/script/schema/mysql-schema.sql: ########## @@ -556,4 +556,97 @@ create table if not exists `t_resource` ( `modify_time` datetime not null default current_timestamp on update current_timestamp comment 'modify time' ); + +-- ---------------------------- +-- table structure for t_spark_env +-- ---------------------------- +drop table if exists `t_spark_env`; +create table `t_spark_env` ( + `id` bigint not null auto_increment comment 'id', + `spark_name` varchar(128) collate utf8mb4_general_ci not null comment 'spark instance name', + `spark_home` varchar(255) collate utf8mb4_general_ci not null comment 'spark home path', + `version` varchar(64) collate utf8mb4_general_ci not null comment 'spark version', + `scala_version` varchar(64) collate utf8mb4_general_ci not null comment 'scala version of spark', + `spark_conf` text collate utf8mb4_general_ci not null comment 'spark-conf', + `is_default` tinyint not null default 0 comment 'whether default version or not', + `description` varchar(255) collate utf8mb4_general_ci default null comment 'description', + `create_time` datetime not null default current_timestamp comment 'create time', + primary key (`id`) using btree, + unique key `un_env_name` (`spark_name`) using btree +) engine=innodb auto_increment=100000 default charset=utf8mb4 collate=utf8mb4_general_ci; + + +-- ---------------------------- +-- Table structure for t_spark_app +-- ---------------------------- +drop table if exists `t_spark_app`; +create table `t_spark_app` ( + `id` bigint not null auto_increment, + `team_id` bigint not null, + `job_type` tinyint default null, + `execution_mode` tinyint default null, + `resource_from` tinyint default null, + `project_id` bigint default null, + `job_name` varchar(255) collate utf8mb4_general_ci default null, + `module` varchar(255) collate utf8mb4_general_ci default null, + `jar` varchar(255) collate utf8mb4_general_ci default null, + `jar_check_sum` bigint default null, + `main_class` varchar(255) collate utf8mb4_general_ci default null, + `args` text collate utf8mb4_general_ci, + `options` text collate utf8mb4_general_ci, + `hot_params` text collate utf8mb4_general_ci, + `user_id` bigint default null, + `app_id` varchar(64) collate utf8mb4_general_ci default null, + `app_type` tinyint default null, + `duration` bigint default null, + `job_id` varchar(64) collate utf8mb4_general_ci default null, + `job_manager_url` varchar(255) collate utf8mb4_general_ci default null, + `version_id` bigint default null, + `cluster_id` varchar(45) collate utf8mb4_general_ci default null, + `k8s_name` varchar(63) collate utf8mb4_general_ci default null, + `k8s_namespace` varchar(63) collate utf8mb4_general_ci default null, + `spark_image` varchar(128) collate utf8mb4_general_ci default null, + `state` int default null, + `restart_size` int default null, + `restart_count` int default null, + `cp_threshold` int default null, + `cp_max_failure_interval` int default null, + `cp_failure_rate_interval` int default null, + `cp_failure_action` tinyint default null, + `dynamic_properties` text collate utf8mb4_general_ci, + `description` varchar(255) collate utf8mb4_general_ci default null, + `resolve_order` tinyint default null, + `k8s_rest_exposed_type` tinyint default null, + `jm_memory` int default null, + `tm_memory` int default null, + `total_task` int default null, + `total_tm` int default null, + `total_slot` int default null, + `available_slot` int default null, + `option_state` tinyint default null, + `tracking` tinyint default null, + `create_time` datetime not null default current_timestamp comment 'create time', Review Comment: default current_timestamp -> default null -- 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]
