CREATE TABLE user_bind
(
id
bigint(20) unsigned NOT NULL AUTO_INCREMENT,
game_id
int(11) unsigned NOT NULL,
user_id
bigint(20) NOT NULL,
mobile_num
varchar(50) NOT NULL,
ext_info
json NOT NULL,
create_time
datetime NOT NULL,
update_time
datetime NOT NULL COMMENT ‘’,
db_updated
datetime DEFAULT NULL COMMENT ‘表更新时间’,
PRIMARY KEY (id
),
UNIQUE KEY uniq
(game_id
,user_id
),
UNIQUE KEY idx_user_game
(user_id
,game_id
),
KEY game_mobile
(game_id
,mobile_num
)
) ENGINE=InnoDB AUTO_INCREMENT=594408952 DEFAULT CHARSET=utf8mb4
mysql数据(部分)
通过dm同步到tidb数据 部分转为base64 部分没有转(tidb)