DROP TABLE IF EXISTS `pre_user_weixin_relations`;
CREATE TABLE `pre_user_weixin_relations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) unsigned DEFAULT NULL,
  `unionid` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT '',
  `name` varchar(255) DEFAULT NULL,
  `create_time` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`userid`),
  KEY `openid` (`openid`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `pre_user_weixin_relations_copy`;
CREATE TABLE `pre_user_weixin_relations_copy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT NULL,
  `unionid` varchar(255) DEFAULT NULL,
  `openid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `create_time` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `phone` (`unionid`)
) ENGINE=MyISAM;