字段	类型	长度	备注
r_id	int	10	r_id(主键)
r_mid	int	10	推荐商家id(外键)
r_begintime	datetime	4	推荐开始时间
r_endtime	datetime	4	推荐结束时间
r_url	varchar	255	推荐商家的url
r_image	varchar	255	推荐商家图片
r_content	varchar	255	推荐内容

DROP TABLE IF EXISTS `recommend`;
CREATE TABLE `recommend` (
  `r_id` int(10) NOT NULL AUTO_INCREMENT,
  `r_mid` int(10) NOT NULL,
  `r_begintime` datetime(4) NOT NULL,
  `r_endtime` datetime(4) NOT NULL,
  `r_url` varchar(255) COLLATE utf8_bin DEFAULT '',
  `r_image` varchar(255) COLLATE utf8_bin DEFAULT '',
  `r_content` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`r_id`),
  KEY `r_mid` (`r_mid`),
  CONSTRAINT `r_mid` FOREIGN KEY (`r_mid`) REFERENCES `merchant` (`m_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;