CREATE TABLE IF NOT EXISTS `jl_measure_concern` ( `mcid` mediumint(9) NOT NULL, `pid` mediumint(9) NOT NULL COMMENT '项目id', `stid` mediumint(9) NOT NULL COMMENT '标段类型id', `pmid` mediumint(9) NOT NULL COMMENT '标段id', `uid` mediumint(9) NOT NULL COMMENT '关注人id', `intime` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='标段关注人表'; ALTER TABLE `jl_measure_concern` ADD PRIMARY KEY (`mcid`); ALTER TABLE `jl_measure_concern` MODIFY `mcid` mediumint(9) NOT NULL AUTO_INCREMENT;COMMIT;