jiliangzhifu2017/标段关注人.sql

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;