-- ----------------------------

-- Table structure for `user_subscribe`

-- ----------------------------

CREATE TABLE `user_subscribe` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',

`code` varchar(255) DEFAULT '' COMMENT '订阅地址唯一识别码',

`times` int(11) NOT NULL DEFAULT '0' COMMENT '地址请求次数',

`created_at` datetime DEFAULT NULL COMMENT '创建时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------

-- Table structure for `user_subscribe_log`

-- ----------------------------

CREATE TABLE `user_subscribe_log` (

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

`sid` int(11) DEFAULT NULL COMMENT '对应user_subscribe的id',

`request_ip` varchar(20) DEFAULT NULL COMMENT '请求IP',

`request_time` datetime DEFAULT NULL COMMENT '请求时间',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;