wangwangwangBoy commented on issue #12703:
URL:
https://github.com/apache/shardingsphere/issues/12703#issuecomment-927224923
> > @RaigorJiang I compared it with template. Still no problem is found, the
attachment is my project, can you help me see it? thanks
>
> I will check it later.
thank you ,here is my table building statement ：
CREATE TABLE `environment_supervise_device_data` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`value` VARCHAR(255) NULL DEFAULT NULL COMMENT '可以是值也可以是json串' COLLATE
'utf8_general_ci',
`unit` VARCHAR(255) NULL DEFAULT NULL COMMENT '单位' COLLATE
'utf8_general_ci',
`env_attribute_type` VARCHAR(255) NULL DEFAULT NULL COMMENT '环境监测类型'
COLLATE 'utf8_general_ci',
`create_date` DATETIME NOT NULL,
`project_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
`tenant_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
`device_id` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
`environment_supervise_alarm_data_id` VARCHAR(255) NULL DEFAULT NULL
COLLATE 'utf8_general_ci',
`wind_direction` VARCHAR(20) NULL DEFAULT NULL COMMENT '风向' COLLATE
'utf8_general_ci',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_project_id` (`project_id`) USING BTREE,
INDEX `idx_env_attribute_type` (`env_attribute_type`) USING BTREE,
INDEX `idx_tenant_id` (`tenant_id`) USING BTREE,
INDEX `idx_environment_device_create_date` (`create_date`) USING BTREE,
INDEX `index_environment_supervise_alarm_data_id`
(`environment_supervise_alarm_data_id`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;
--
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]
