sina-video/sql.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 5446
#
# https://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 8.0.13)
# Database: video
# Generation Time: 2022-07-05 13:59:37 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table awards_base_postage_region
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_base_postage_region`;

CREATE TABLE `awards_base_postage_region` (
                                              `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                              `pid` int(10) unsigned DEFAULT '0' COMMENT '上级PID',
                                              `first` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '首字母',
                                              `short` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '区域简称',
                                              `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '区域名称',
                                              `level` tinyint(4) DEFAULT '0' COMMENT '区域层级',
                                              `pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '区域拼音',
                                              `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '区域邮编',
                                              `status` tinyint(3) unsigned DEFAULT '1' COMMENT '使用状态',
                                              `lng` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '所在经度',
                                              `lat` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '所在纬度',
                                              PRIMARY KEY (`id`) USING BTREE,
                                              KEY `idx_base_postage_region_pid` (`pid`) USING BTREE,
                                              KEY `idx_base_postage_region_name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='数据-快递-区域';



# Dump of table awards_base_user_message
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_base_user_message`;

CREATE TABLE `awards_base_user_message` (
                                            `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                            `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '消息类型',
                                            `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '消息名称',
                                            `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '消息内容',
                                            `num_read` bigint(20) DEFAULT '0' COMMENT '阅读次数',
                                            `sort` bigint(20) unsigned DEFAULT '0' COMMENT '排序权重',
                                            `status` tinyint(3) unsigned DEFAULT '1' COMMENT '消息状态(1使用,0禁用)',
                                            `deleted` tinyint(3) unsigned DEFAULT '0' COMMENT '删除状态',
                                            `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                            PRIMARY KEY (`id`) USING BTREE,
                                            KEY `idx_base_user_message_type` (`type`) USING BTREE,
                                            KEY `idx_base_user_message_status` (`status`) USING BTREE,
                                            KEY `idx_base_user_message_deleted` (`deleted`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='数据-基础-通知';



# Dump of table awards_system_auth
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_auth`;

CREATE TABLE `awards_system_auth` (
                                      `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                      `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '权限名称',
                                      `utype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '身份权限',
                                      `desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注说明',
                                      `sort` bigint(20) unsigned DEFAULT '0' COMMENT '排序权重',
                                      `status` tinyint(3) unsigned DEFAULT '1' COMMENT '权限状态(1使用,0禁用)',
                                      `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                      PRIMARY KEY (`id`) USING BTREE,
                                      KEY `idx_system_auth_status` (`status`) USING BTREE,
                                      KEY `idx_system_auth_title` (`title`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='系统-权限';



# Dump of table awards_system_auth_node
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_auth_node`;

CREATE TABLE `awards_system_auth_node` (
                                           `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                           `auth` bigint(20) unsigned DEFAULT '0' COMMENT '角色',
                                           `node` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '节点',
                                           PRIMARY KEY (`id`) USING BTREE,
                                           KEY `idx_system_auth_auth` (`auth`) USING BTREE,
                                           KEY `idx_system_auth_node` (`node`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='系统-授权';



# Dump of table awards_system_base
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_base`;

CREATE TABLE `awards_system_base` (
                                      `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                      `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '数据类型',
                                      `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '数据代码',
                                      `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '数据名称',
                                      `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '数据内容',
                                      `sort` bigint(20) DEFAULT '0' COMMENT '排序权重',
                                      `status` tinyint(1) DEFAULT '1' COMMENT '数据状态(0禁用,1启动)',
                                      `deleted` tinyint(1) DEFAULT '0' COMMENT '删除状态(0正常,1已删)',
                                      `deleted_at` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '删除时间',
                                      `deleted_by` bigint(20) DEFAULT '0' COMMENT '删除用户',
                                      `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                      PRIMARY KEY (`id`) USING BTREE,
                                      KEY `idx_system_base_type` (`type`) USING BTREE,
                                      KEY `idx_system_base_code` (`code`) USING BTREE,
                                      KEY `idx_system_base_name` (`name`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='系统-字典';



# Dump of table awards_system_config
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_config`;

CREATE TABLE `awards_system_config` (
                                        `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                        `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '配置分类',
                                        `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '配置名称',
                                        `value` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '配置内容',
                                        PRIMARY KEY (`id`) USING BTREE,
                                        KEY `idx_system_config_type` (`type`) USING BTREE,
                                        KEY `idx_system_config_name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='系统-配置';



# Dump of table awards_system_data
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_data`;

CREATE TABLE `awards_system_data` (
                                      `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                      `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '配置名',
                                      `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '配置值',
                                      PRIMARY KEY (`id`) USING BTREE,
                                      KEY `idx_system_data_name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='系统-数据';



# Dump of table awards_system_menu
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_menu`;

CREATE TABLE `awards_system_menu` (
                                      `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                      `pid` bigint(20) unsigned DEFAULT '0' COMMENT '上级ID',
                                      `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '菜单名称',
                                      `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '菜单图标',
                                      `node` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '节点代码',
                                      `url` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '链接节点',
                                      `params` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '链接参数',
                                      `target` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '_self' COMMENT '打开方式',
                                      `sort` int(10) unsigned DEFAULT '0' COMMENT '排序权重',
                                      `status` tinyint(3) unsigned DEFAULT '1' COMMENT '状态(0:禁用,1:启用)',
                                      `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                      PRIMARY KEY (`id`) USING BTREE,
                                      KEY `idx_system_menu_status` (`status`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='系统-菜单';



# Dump of table awards_system_notice
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_notice`;

CREATE TABLE `awards_system_notice` (
                                        `id` int(11) NOT NULL AUTO_INCREMENT,
                                        `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知标题',
                                        `content` varchar(10000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知详细内容',
                                        `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知链接',
                                        `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
                                        `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
                                        `created_by` bigint(20) NOT NULL DEFAULT '0' COMMENT '创建人',
                                        PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;



# Dump of table awards_system_oplog
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_oplog`;

CREATE TABLE `awards_system_oplog` (
                                       `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                       `node` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '当前操作节点',
                                       `geoip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作者IP地址',
                                       `action` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作行为名称',
                                       `content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作内容描述',
                                       `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作人用户名',
                                       `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                       PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='系统-日志';



# Dump of table awards_system_queue
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_queue`;

CREATE TABLE `awards_system_queue` (
                                       `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                       `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '任务编号',
                                       `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '任务名称',
                                       `command` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '执行指令',
                                       `exec_pid` bigint(20) DEFAULT '0' COMMENT '执行进程',
                                       `exec_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '执行参数',
                                       `exec_time` bigint(20) DEFAULT '0' COMMENT '执行时间',
                                       `exec_desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '执行描述',
                                       `enter_time` decimal(20,4) DEFAULT '0.0000' COMMENT '开始时间',
                                       `outer_time` decimal(20,4) DEFAULT '0.0000' COMMENT '结束时间',
                                       `loops_time` bigint(20) DEFAULT '0' COMMENT '循环时间',
                                       `attempts` bigint(20) DEFAULT '0' COMMENT '执行次数',
                                       `rscript` tinyint(1) DEFAULT '1' COMMENT '任务类型(0单例,1多例)',
                                       `status` tinyint(1) DEFAULT '1' COMMENT '任务状态(1新任务,2处理中,3成功,4失败)',
                                       `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                       PRIMARY KEY (`id`) USING BTREE,
                                       KEY `idx_system_queue_code` (`code`) USING BTREE,
                                       KEY `idx_system_queue_title` (`title`) USING BTREE,
                                       KEY `idx_system_queue_status` (`status`) USING BTREE,
                                       KEY `idx_system_queue_rscript` (`rscript`) USING BTREE,
                                       KEY `idx_system_queue_create_at` (`create_at`) USING BTREE,
                                       KEY `idx_system_queue_exec_time` (`exec_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='系统-任务';



# Dump of table awards_system_user
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_system_user`;

CREATE TABLE `awards_system_user` (
                                      `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                      `usertype` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户类型',
                                      `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户账号',
                                      `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户密码',
                                      `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户昵称',
                                      `headimg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像地址',
                                      `authorize` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '权限授权',
                                      `contact_qq` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '联系QQ',
                                      `contact_mail` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '联系邮箱',
                                      `contact_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '联系手机',
                                      `login_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '登录地址',
                                      `login_at` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '登录时间',
                                      `login_num` bigint(20) DEFAULT '0' COMMENT '登录次数',
                                      `describe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '备注说明',
                                      `status` tinyint(1) DEFAULT '1' COMMENT '状态(0禁用,1启用)',
                                      `sort` bigint(20) DEFAULT '0' COMMENT '排序权重',
                                      `is_deleted` tinyint(1) DEFAULT '0' COMMENT '删除(1删除,0未删)',
                                      `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
                                      PRIMARY KEY (`id`) USING BTREE,
                                      KEY `idx_system_user_status` (`status`) USING BTREE,
                                      KEY `idx_system_user_username` (`username`) USING BTREE,
                                      KEY `idx_system_user_deleted` (`is_deleted`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='系统-用户';



# Dump of table awards_user_info
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_user_info`;

CREATE TABLE `awards_user_info` (
                                    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                    `uid` bigint(20) DEFAULT '0' COMMENT '用户ID',
                                    `portrait` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户头像',
                                    `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户昵称',
                                    `create_at` int(11) DEFAULT '0',
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table awards_user_task
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_user_task`;

CREATE TABLE `awards_user_task` (
                                    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                    `uid` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户ID',
                                    `date` date NOT NULL DEFAULT '1970-01-01' COMMENT '日期',
                                    `finish_state` tinyint(4) NOT NULL DEFAULT '0' COMMENT '品牌任务整体完成状态 1 已完成 0 未完成',
                                    `follow_state` tinyint(4) NOT NULL DEFAULT '0' COMMENT '关注完成状态 0 未完成 1已完成',
                                    `forward_state` tinyint(4) NOT NULL DEFAULT '0' COMMENT '转发完成状态 0 未完成 1已完成',
                                    `view_state` tinyint(4) NOT NULL DEFAULT '0' COMMENT '浏览完成状态 0 未完成 1已完成',
                                    `finish_add_votes` tinyint(4) NOT NULL DEFAULT '0' COMMENT '完成品牌任务后是否已经加票 0 未加票 1已加票',
                                    `share_add_votes` tinyint(4) NOT NULL DEFAULT '0' COMMENT '完成分享后是否已加票 0 未加票 1已加票',
                                    PRIMARY KEY (`id`) USING BTREE,
                                    UNIQUE KEY `uniq_uid_date` (`uid`,`date`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户品牌任务状态表，记录用户每天品牌任务的完成状态';



# Dump of table awards_user_task_log
# ------------------------------------------------------------

DROP TABLE IF EXISTS `awards_user_task_log`;

CREATE TABLE `awards_user_task_log` (
                                        `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                                        `uid` bigint(20) DEFAULT '0' COMMENT '用户ID',
                                        `date` date DEFAULT '1970-01-01' COMMENT '参加活动日期',
                                        `duration` int(11) DEFAULT '0' COMMENT '参与时间',
                                        `number` int(11) DEFAULT '0' COMMENT '获取数据',
                                        `create_at` int(11) DEFAULT '0',
                                        PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;




/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;