建表语句:
CREATE TABLE `player` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `player_id` bigint unsigned NOT NULL, `nickname` varchar(50) NOT NULL DEFAULT '', `avatar` varchar(255) NOT NULL DEFAULT '', `gender` tinyint unsigned NOT NULL DEFAULT '0', `coin_balance` int unsigned NOT NULL DEFAULT '0' COMMENT '金币余额', `password` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '', `status` tinyint unsigned NOT NULL DEFAULT '0', `created_at` int unsigned NOT NULL, `last_sign_at` double(10,3) NOT NULL DEFAULT '0.000', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='玩家信息表';
解析
解析结果: