Newer
Older
newfiber-termite / doc / upgrade.sql
@xiongkai xiongkai on 22 May 678 bytes 第二版优化
ALTER TABLE `newfiber_standard_termite`.`ter_project_info`
ADD COLUMN `production_users` VARCHAR(512) NULL COMMENT '生产人员' AFTER `field_explain`,
ADD COLUMN `install_users` VARCHAR(512) NULL COMMENT '安装人员' AFTER `production_users`,
ADD COLUMN `analysis_users` VARCHAR(512) NULL COMMENT '分析人员' AFTER `install_users`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_info`
ADD COLUMN `category` VARCHAR(32) NULL DEFAULT 'project' COMMENT '分类(生产 production | 项目 project)' AFTER `id`;

ALTER TABLE `newfiber_standard_termite`.`ter_project_info`
ADD COLUMN `center_point` VARCHAR(128) NULL COMMENT '地图中心点' AFTER `analysis_users`;