friendship-parent/doc/ddl/table/V5.0.sql

CREATE TABLE `friendship`.`banner_and_radio`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NULL COMMENT '标题',
  `img_url` varchar(255) NULL COMMENT '图片地址',
  `type` tinyint(2) NULL COMMENT '类型：0 banner 1 广播',
  `seq` int(2) NULL COMMENT '排序',
  `address` varchar(255) NULL COMMENT '跳转地址',
  `update_time` timestamp(0) NULL COMMENT '更新时间',
  `create_time` timestamp(0) NULL COMMENT '创建时间',
  `effective_time` timestamp(0) NULL COMMENT '生效时间',
  `status` int(2) NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 10010010;

-- 系统靓号
CREATE TABLE `friendship`.`pretty_account`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pretty_account` bigint(8) NULL COMMENT '靓号',
  `status` tinyint(2) NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1000 COMMENT = '有期靓号表';

-- 靓号绑定详情
CREATE TABLE `friendship`.`pretty_account_bind_detail`  (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `pretty_account` bigint(10) NULL DEFAULT NULL COMMENT '靓号',
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `create_time` timestamp(0) NULL DEFAULT NULL COMMENT '绑定时间',
  `remark` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '靓号绑定详情表' ROW_FORMAT = Dynamic;




CREATE TABLE `yingtao`.`user_draw_detail`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
  `record` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '抽奖记录json',
  `create_time` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户砸蛋记录表' ROW_FORMAT = Dynamic;