/*修改表obj_Device,把字段类型channelNum改为TINYINT(3),默认值为8*/
alter table obj_Device change column channelNum channelNum TINYINT(3) NOT NULL DEFAULT 8;
alter table obj_Device change column channelNum channelNum TINYINT(3) NOT NULL DEFAULT 8;