游客订阅信用圈
数据库：ucs
表名：tb_company_credit_circle_bind_wechat
CREATE TABLE `tb_company_credit_circle_bind_wechat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`company_name_digest` varchar(32) NOT NULL,
`wx_openid` varchar(255) NOT NULL,
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `digest_open_id` (`company_name_digest`,`wx_openid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8