42 lines
1.9 KiB
MySQL
42 lines
1.9 KiB
MySQL
|
-- 1. 供应商
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `supplier` VARCHAR(50) DEFAULT NULL COMMENT '供应商' AFTER `brand`;
|
|||
|
|
|
|||
|
|
-- 2. 设备版本号
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `device_version` VARCHAR(50) DEFAULT NULL COMMENT '设备版本号' AFTER `specification`;
|
|||
|
|
|
|||
|
|
-- 3. 设备别称
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `device_alias` VARCHAR(50) DEFAULT NULL COMMENT '设备别称' AFTER `name`;
|
|||
|
|
|
|||
|
|
-- 4. 通信协议
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `protocol` VARCHAR(200) DEFAULT NULL COMMENT '通信协议' AFTER `iot_sn`;
|
|||
|
|
|
|||
|
|
-- 5. 功能描述
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `function_desc` TEXT DEFAULT NULL COMMENT '功能描述' AFTER `protocol`;
|
|||
|
|
|
|||
|
|
-- 6. 维护人
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `maintainer` VARCHAR(20) DEFAULT NULL COMMENT '维护人' AFTER `function_desc`;
|
|||
|
|
|
|||
|
|
-- 7. 联系电话
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `phone` VARCHAR(20) DEFAULT NULL COMMENT '联系电话' AFTER `maintainer`;
|
|||
|
|
|
|||
|
|
-- 8. 启用时间
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `start_time` DATETIME DEFAULT NULL COMMENT '启用时间' AFTER `phone`;
|
|||
|
|
|
|||
|
|
-- 9. 上次检修时间
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `maintain_time` DATETIME DEFAULT NULL COMMENT '上次检修时间' AFTER `start_time`;
|
|||
|
|
|
|||
|
|
-- 10. 检修周期（天）
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `maintain_period` INT DEFAULT NULL COMMENT '检修周期（天）' AFTER `maintain_time`;
|
|||
|
|
|
|||
|
|
-- 11. 数据是否上传（1=是，0=否）
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `data_upload` TINYINT(1) DEFAULT 1 COMMENT '数据是否上传（1=是，0=否）' AFTER `maintain_period`;
|
|||
|
|
|
|||
|
|
-- 12. 安装位置
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `install_location` VARCHAR(255) DEFAULT NULL COMMENT '安装位置' AFTER `data_upload`;
|
|||
|
|
|
|||
|
|
-- 13. 经度
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `longitude` DECIMAL(10,6) DEFAULT NULL COMMENT '经度' AFTER `install_location`;
|
|||
|
|
|
|||
|
|
-- 14. 纬度
|
|||
|
|
ALTER TABLE `dm_equipment` ADD COLUMN `latitude` DECIMAL(10,6) DEFAULT NULL COMMENT '纬度' AFTER `longitude`;
|