ALTER TABLE `t_emind_station`
|
ADD COLUMN `platform_name` varchar(100) NOT NULL DEFAULT '利普芯' COMMENT '平台名称' AFTER `commissioning_time`,
|
ADD COLUMN `source_type` tinyint NOT NULL DEFAULT 1 COMMENT '数据来源（1远端同步，2手工新增）' AFTER `platform_name`,
|
ADD COLUMN `management_deleted` tinyint NOT NULL DEFAULT 0 COMMENT '管理删除（0正常，1已删除）' AFTER `source_type`,
|
ADD KEY `idx_emind_station_management` (`management_deleted`, `platform_name`);
|
