yzySrv/db/20-12/20-12-26.sql

-- ljy
-- 七日目标
-- 2020-12-25

-- 七日目标日志
CREATE TABLE `log_seven_days_goal`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role_id` bigint(20) NOT NULL COMMENT '玩家id',
  `type` tinyint(2) NOT NULL COMMENT '操作类型，1领取任务奖励2领取积分奖励3领取技能奖励',
  `grade` varchar(127) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '档次',
  `reward` varchar(511) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '奖励',
  `time` int(11) NOT NULL COMMENT '领取时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '七日目标日志' ROW_FORMAT = Dynamic;