CREATE TABLE `iec_104_point` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eqmid` int(11) DEFAULT NULL,
  `field` varchar(45) DEFAULT NULL,
  `stype` varchar(45) DEFAULT NULL COMMENT '类型 1:遥信 2:遥测',
  `sadr` int(11) DEFAULT NULL COMMENT '点位',
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `n_sensor`
ADD COLUMN `sdk_type` INT NULL COMMENT '1:大华 2:海康' AFTER `tm_type`;
