yzySrv/db/21-01/21-01-12.sql

-- ljy

CREATE TABLE `log_goods_convert`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role_id` bigint(20) NOT NULL COMMENT '玩家id',
  `goods_id` bigint(20) NOT NULL COMMENT '原物品ID',
  `rewards` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '获得物品',
  `time` int(11) NOT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '物品转换日志' ROW_FORMAT = Dynamic;