xiaoti2 commented on issue #37264: URL: https://github.com/apache/shardingsphere/issues/37264#issuecomment-3605243191
DDL： CREATE TABLE `device_ota_upgrade_record` ( 'id' bigint unsigned NOT NULL COMMENT 'primary key' 'device_id' bigint unsigned NOT NULL COMMENT 'device ID' 'device_name' varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'Device name' 'ota_task_id' bigint unsigned NOT NULL COMMENT 'OTA upgrade task ID' `device_curr_firmware_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT "Current firmware version of the device" 'state' tinyint NOT NULL COMMENT 'ota upgrade status 1: Pending push 2: Pushed 3: Upgrade in progress 4: Upgrade Successful 5: Upgrade Failed 6: Cancelled ' 'describe' varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'Upgrade information note' 'product_id' bigint unsigned DEFAULT NULL COMMENT 'product ID, added on 2022-08-04' `upgrade_firmware_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT "Upgraded firmware version, added on August 4,2022. 'created_time' bigint unsigned NOT NULL COMMENT 'creation time' 'last_modified_time' bigint unsigned NOT NULL COMMENT 'Last updated time' 'start_time' bigint unsigned DEFAULT NULL COMMENT 'Download or upgrade start time' 'end_time' bigint unsigned DEFAULT NULL COMMENT 'Download or upgrade end time' 'error_code' int DEFAULT NULL COMMENT 'error code' 'detail_code' int DEFAULT NULL COMMENT 'detail error code' 'firmware_id' bigint DEFAULT NULL COMMENT 'firmware id' 'product_unique_id' varchar(16) DEFAULT NULL COMMENT 'product id (string)' PRIMARY KEY (`id`) USING BTREE, KEY `ota_task_id_index` (`ota_task_id`) USING BTREE, KEY `device_ota_upgrade_record_ota_task_id_device_id_index` (`ota_task_id`,`device_id`) USING BTREE, KEY `device_ota_upgrade_upgrade_firmware_index` (`product_id`,`upgrade_firmware_version`,`device_id`) USING BTREE, KEY `device_ota_upgrade_firmware_version_index` (`product_id`,`upgrade_firmware_version`,`device_name`) USING BTREE, KEY `device_ota_upgrade_record_device_id_state_index` (`device_id`,`state`) USING BTREE ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT=' Device Firmware Upgrade record '; -- 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]
