/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50540
Source Host : localhost:3306
Source Database : douyin_s
Target Server Type : MYSQL
Target Server Version : 50540
File Encoding : 65001
Date: 2020-09-23 17:26:27
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for sx_ad
-- ----------------------------
DROP TABLE IF EXISTS `sx_ad`;
CREATE TABLE `sx_ad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`url` varchar(255) NOT NULL,
`img` varchar(255) DEFAULT NULL,
`video` varchar(255) DEFAULT NULL,
`type` int(1) NOT NULL COMMENT '1图片 2视频 3任务广告 4影视详细广告',
`hide` int(1) NOT NULL,
`time` int(11) NOT NULL,
`content` varchar(255) DEFAULT NULL COMMENT '广告描述',
`type_url` int(1) NOT NULL COMMENT '0外网 1内网',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='广告系统
-- ----------------------------
-- Records of sx_ad
-- ----------------------------
-- ----------------------------
-- Table structure for sx_administrator
-- ----------------------------
DROP TABLE IF EXISTS `sx_administrator`;
CREATE TABLE `sx_administrator` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL COMMENT '对应 admin_type 主键',
`user` varchar(255) DEFAULT NULL COMMENT '账户',
`password` varchar(255) DEFAULT NULL COMMENT '密码',
`password_s` varchar(255) DEFAULT NULL,
`hide` int(2) NOT NULL COMMENT '0 禁止 1显示',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='管理员账户
-- ----------------------------
-- Records of sx_administrator
-- ----------------------------
-- ----------------------------
-- Table structure for sx_admin_type
-- ----------------------------
DROP TABLE IF EXISTS `sx_admin_type`;
CREATE TABLE `sx_admin_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL COMMENT '管理昵称',
`data` text COMMENT '菜单id',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='角色管理
-- ----------------------------
-- Records of sx_admin_type
-- ----------------------------
-- ----------------------------
-- Table structure for sx_ad_jili
-- ----------------------------
DROP TABLE IF EXISTS `sx_ad_jili`;
CREATE TABLE `sx_ad_jili` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`key` varchar(100) NOT NULL,
`status` int(1) NOT NULL COMMENT '0 失败 1成功',
`jinbi` int(11) NOT NULL COMMENT '奖励金币',
`trans_id` varchar(255) DEFAULT NULL COMMENT '完成观看的唯一交易ID',
`content` varchar(100) DEFAULT NULL COMMENT '说明',
`get` varchar(255) NOT NULL,
`ip` varchar(100) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='激励广告记录
-- ----------------------------
-- Records of sx_ad_jili
-- ----------------------------
-- ----------------------------
-- Table structure for sx_ad_tongji_click
-- ----------------------------
DROP TABLE IF EXISTS `sx_ad_tongji_click`;
CREATE TABLE `sx_ad_tongji_click` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`ip` varchar(100) DEFAULT NULL,
`time` int(11) NOT NULL,
`ad_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of sx_ad_tongji_click
-- ----------------------------
-- ----------------------------
-- Table structure for sx_ad_tongji_zhanshi
-- ----------------------------
DROP TABLE IF EXISTS `sx_ad_tongji_zhanshi`;
CREATE TABLE `sx_ad_tongji_zhanshi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`ip` varchar(100) DEFAULT NULL,
`time` int(11) NOT NULL,
`ad_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of sx_ad_tongji_zhanshi
-- ----------------------------
-- ----------------------------
-- Table structure for sx_article
-- ----------------------------
DROP TABLE IF EXISTS `sx_article`;
CREATE TABLE `sx_article` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`data` text,
`hide` int(1) NOT NULL COMMENT '0禁止 1正常 2审核 3失败',
`time` int(11) NOT NULL,
`content` varchar(255) DEFAULT NULL COMMENT '内容',
`uid` int(11) NOT NULL,
`channel` varchar(255) DEFAULT NULL COMMENT '1图文 2视频',
`typeid` int(11) NOT NULL COMMENT '分类id',
`click` int(11) NOT NULL COMMENT '访问次数',
`img` varchar(255) DEFAULT NULL COMMENT '缩略图',
`zan_num` int(11) NOT NULL,
`ping_num` int(11) NOT NULL,
`fx_num` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of sx_article
-- ----------------------------
-- ----------------------------
-- Table structure for sx_article_ping
-- ----------------------------
DROP TABLE IF EXISTS `sx_article_ping`;
CREATE TABLE `sx_article_ping` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vid` int(11) NOT NULL COMMENT '内容id',
`uid` int(11) NOT NULL COMMENT '用户id',
`content` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '评论内容',
`zan_num` int(11) NOT NULL COMMENT '点赞数量',
`huifu_num` int(11) NOT NULL COMMENT '回复数量',
`hide` int(11) NOT NULL COMMENT '0不显示 1正常 2审核 3未通过',
`time` int(11) NOT NULL COMMENT '发布时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='评论列表';
-- ----------------------------
-- Records of sx_article_ping
-- ----------------------------
-- ----------------------------
-- Table structure for sx_article_ping_huifu
-- ----------------------------
DROP TABLE IF EXISTS `sx_article_ping_huifu`;
CREATE TABLE `sx_article_ping_huifu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ping_id` int(11) NOT NULL COMMENT '评论id',
`uid` int(11) NOT NULL COMMENT '用户id',
`content` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '回复内容',
`zan_num` int(11) NOT NULL COMMENT '点赞数量',
`hide` int(11) NOT NULL COMMENT '0不显示 1正常 2审核 3未通过',
`time` int(11) NOT NULL COMMENT '回复时间',
`huifu_id` int(11) NOT NULL COMMENT '回复id',
`huifu_uid` int(11) NOT NULL COMMENT '回复用户id',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='评论回复内容列表';
-- ----------------------------
-- Records of sx_article_ping_huifu
-- ----------------------------
-- ----------------------------
-- Table structure for sx_article_ping_huifu_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_article_ping_huifu_zan`;
CREATE TABLE `sx_article_ping_huifu_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`huifu_id` int(11) NOT NULL COMMENT '回复id',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞回复';
-- ----------------------------
-- Records of sx_article_ping_huifu_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_article_ping_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_article_ping_zan`;
CREATE TABLE `sx_article_ping_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`ping_id` int(11) NOT NULL COMMENT '评论id',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞评论';
-- ----------------------------
-- Records of sx_article_ping_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_article_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_article_zan`;
CREATE TABLE `sx_article_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`vid` int(11) NOT NULL COMMENT '视频ID',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞视频';
-- ----------------------------
-- Records of sx_article_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_caiji_id
-- ----------------------------
DROP TABLE IF EXISTS `sx_caiji_id`;
CREATE TABLE `sx_caiji_id` (
`item_id` varchar(255) NOT NULL,
`vid` int(11) NOT NULL,
`type` int(1) NOT NULL COMMENT '0视频 1社区'
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='采集ID，用途判断采集ID重复问题';
-- ----------------------------
-- Records of sx_caiji_id
-- ----------------------------
-- ----------------------------
-- Table structure for sx_category
-- ----------------------------
DROP TABLE IF EXISTS `sx_category`;
CREATE TABLE `sx_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tid` int(11) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`controller` varchar(255) DEFAULT NULL,
`function` varchar(255) DEFAULT NULL,
`icon` varchar(255) DEFAULT NULL,
`get` varchar(255) DEFAULT NULL,
`des` int(11) DEFAULT NULL COMMENT '排序 数字越大越靠前',
`hide` int(2) DEFAULT NULL COMMENT '0隐藏 1显示',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='后台菜单管理
-- ----------------------------
-- Records of sx_category
-- ----------------------------
-- ----------------------------
-- Table structure for sx_channel
-- ----------------------------
DROP TABLE IF EXISTS `sx_channel`;
CREATE TABLE `sx_channel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of sx_channel
-- ----------------------------
-- ----------------------------
-- Table structure for sx_code
-- ----------------------------
DROP TABLE IF EXISTS `sx_code`;
CREATE TABLE `sx_code` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
`username` varchar(255) DEFAULT NULL COMMENT '账户或UID',
`code` varchar(100) DEFAULT NULL COMMENT '验证码',
`type` int(11) unsigned zerofill NOT NULL COMMENT '1验证成功 0未验证',
`maturity` varchar(255) DEFAULT NULL COMMENT '验证码有效期',
`time` int(11) DEFAULT NULL COMMENT '发送时间',
`content` varchar(255) DEFAULT NULL COMMENT '验证码说明',
`ip` varchar(255) DEFAULT NULL COMMENT 'IP地区',
`system` text COMMENT '记录当前操作版本',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='验证码
-- ----------------------------
-- Records of sx_code
-- ----------------------------
-- ----------------------------
-- Table structure for sx_dashang
-- ----------------------------
DROP TABLE IF EXISTS `sx_dashang`;
CREATE TABLE `sx_dashang` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL COMMENT '字段表 video视频打款 article文章打赏',
`vid` int(11) NOT NULL,
`money` int(11) NOT NULL,
`uid` int(11) NOT NULL COMMENT '打赏礼物用户',
`time` int(11) NOT NULL,
`liwu_id` int(11) NOT NULL,
`data` text,
`uid_s` int(11) NOT NULL COMMENT '接受礼物用户',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='打赏';
-- ----------------------------
-- Records of sx_dashang
-- ----------------------------
-- ----------------------------
-- Table structure for sx_dingdan
-- ----------------------------
DROP TABLE IF EXISTS `sx_dingdan`;
CREATE TABLE `sx_dingdan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`code` varchar(255) DEFAULT NULL COMMENT '订单号',
`money` int(11) NOT NULL COMMENT 'type=1钻石 2VIP',
`type` int(1) NOT NULL COMMENT '1钻石 2VIP 3购买商品',
`data` text COMMENT '支付成功回调数据',
`s` int(1) NOT NULL COMMENT '0未支付 1支付成功 2支付成功回调失败，3支付失败',
`time` int(11) NOT NULL COMMENT '提交状态',
`channel` varchar(10) DEFAULT NULL COMMENT '支付渠道',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='支付订单';
-- ----------------------------
-- Records of sx_dingdan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang`;
CREATE TABLE `sx_fang` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL COMMENT '标题',
`content` text COMMENT '简介',
`img` varchar(255) DEFAULT NULL COMMENT '背影',
`pingfen` varchar(10) DEFAULT NULL COMMENT '评分',
`ping_num` int(11) NOT NULL COMMENT '评论',
`zan_num` int(11) NOT NULL COMMENT '点赞',
`click` int(11) NOT NULL COMMENT '播放次数',
`time` int(11) NOT NULL COMMENT '添加时间',
`zhuyan` varchar(50) DEFAULT NULL COMMENT '主演',
`daoyan` varchar(50) DEFAULT NULL COMMENT '导演',
`bieming` varchar(50) DEFAULT NULL COMMENT '别名',
`name_1` varchar(255) NOT NULL COMMENT '地区',
`name_2` varchar(255) NOT NULL COMMENT '类型',
`name_3` varchar(255) NOT NULL COMMENT '时间',
`type` int(11) NOT NULL COMMENT '频道ID',
`url_data` text NOT NULL COMMENT '视频地址',
`quanji` int(11) NOT NULL COMMENT '是否已完结 0未设置 1完结 2未完',
`url_type` varchar(255) DEFAULT NULL COMMENT '视频来源 1自定义 2优酷',
`hide` int(1) NOT NULL COMMENT '1已发布 2审核中 3未发布',
`title_text` varchar(255) DEFAULT NULL COMMENT '短语',
`tuijian` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of sx_fang
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_jubao
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_jubao`;
CREATE TABLE `sx_fang_jubao` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(255) NOT NULL,
`mobile` varchar(100) NOT NULL,
`time` int(11) NOT NULL,
`ip` varchar(255) DEFAULT NULL,
`vid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='影视反馈报错';
-- ----------------------------
-- Records of sx_fang_jubao
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_name
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_name`;
CREATE TABLE `sx_fang_name` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(10) DEFAULT NULL,
`des` int(11) NOT NULL,
`hide` int(1) NOT NULL,
`type` int(11) NOT NULL COMMENT '频道ID 对应表fang_type',
`name` int(11) NOT NULL COMMENT '字段id 对应表fang_name_type',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='字段管理';
-- ----------------------------
-- Records of sx_fang_name
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_name_type
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_name_type`;
CREATE TABLE `sx_fang_name_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(10) DEFAULT NULL,
`des` int(11) NOT NULL,
`hide` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='字段分类';
-- ----------------------------
-- Records of sx_fang_name_type
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_ping
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_ping`;
CREATE TABLE `sx_fang_ping` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vid` int(11) NOT NULL COMMENT '内容id',
`uid` int(11) NOT NULL COMMENT '用户id',
`content` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '评论内容',
`zan_num` int(11) NOT NULL COMMENT '点赞数量',
`huifu_num` int(11) NOT NULL COMMENT '回复数量',
`hide` int(11) NOT NULL COMMENT '0不显示 1正常 2审核 3未通过',
`time` int(11) NOT NULL COMMENT '发布时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='评论列表';
-- ----------------------------
-- Records of sx_fang_ping
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_ping_huifu
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_ping_huifu`;
CREATE TABLE `sx_fang_ping_huifu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ping_id` int(11) NOT NULL COMMENT '评论id',
`uid` int(11) NOT NULL COMMENT '用户id',
`content` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '回复内容',
`zan_num` int(11) NOT NULL COMMENT '点赞数量',
`hide` int(11) NOT NULL COMMENT '0不显示 1正常 2审核 3未通过',
`time` int(11) NOT NULL COMMENT '回复时间',
`huifu_id` int(11) NOT NULL COMMENT '回复id',
`huifu_uid` int(11) NOT NULL COMMENT '回复用户id',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='评论回复内容列表';
-- ----------------------------
-- Records of sx_fang_ping_huifu
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_ping_huifu_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_ping_huifu_zan`;
CREATE TABLE `sx_fang_ping_huifu_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`huifu_id` int(11) NOT NULL COMMENT '回复id',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞回复';
-- ----------------------------
-- Records of sx_fang_ping_huifu_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_ping_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_ping_zan`;
CREATE TABLE `sx_fang_ping_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`ping_id` int(11) NOT NULL COMMENT '评论id',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞评论';
-- ----------------------------
-- Records of sx_fang_ping_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_slide
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_slide`;
CREATE TABLE `sx_fang_slide` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL,
`img` varchar(255) DEFAULT NULL,
`des` int(11) NOT NULL,
`hide` int(1) NOT NULL,
`time` int(11) NOT NULL,
`url` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='影视轮播图';
-- ----------------------------
-- Records of sx_fang_slide
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_type
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_type`;
CREATE TABLE `sx_fang_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL,
`des` int(11) NOT NULL,
`hide` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='影视频道';
-- ----------------------------
-- Records of sx_fang_type
-- ----------------------------
-- ----------------------------
-- Table structure for sx_fang_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_fang_zan`;
CREATE TABLE `sx_fang_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`vid` int(11) NOT NULL COMMENT '视频ID',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞视频';
-- ----------------------------
-- Records of sx_fang_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_hongbao_list
-- ----------------------------
DROP TABLE IF EXISTS `sx_hongbao_list`;
CREATE TABLE `sx_hongbao_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`money` int(11) NOT NULL COMMENT '100 = 1元',
`time` int(11) NOT NULL,
`uid_s` int(11) NOT NULL COMMENT '好友助力红包',
`deviceId` varchar(255) DEFAULT NULL COMMENT '口令',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='红包记录列表';
-- ----------------------------
-- Records of sx_hongbao_list
-- ----------------------------
-- ----------------------------
-- Table structure for sx_hongbao_tixian
-- ----------------------------
DROP TABLE IF EXISTS `sx_hongbao_tixian`;
CREATE TABLE `sx_hongbao_tixian` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`time_s` int(11) NOT NULL COMMENT '红包开始',
`time` int(11) NOT NULL,
`hide` int(1) NOT NULL COMMENT '0未审核 1已打款 2审核种',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='红包提现';
-- ----------------------------
-- Records of sx_hongbao_tixian
-- ----------------------------
-- ----------------------------
-- Table structure for sx_jinbi_money
-- ----------------------------
DROP TABLE IF EXISTS `sx_jinbi_money`;
CREATE TABLE `sx_jinbi_money` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`money` int(11) NOT NULL COMMENT '提现金额',
`hide` int(1) NOT NULL,
`type` int(11) NOT NULL COMMENT '1新手专享 2看视频专享 3邀请专享 4连续登录',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='提现金额列表';
-- ----------------------------
-- Records of sx_jinbi_money
-- ----------------------------
-- ----------------------------
-- Table structure for sx_jinbi_records
-- ----------------------------
DROP TABLE IF EXISTS `sx_jinbi_records`;
CREATE TABLE `sx_jinbi_records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户id',
`content` varchar(255) NOT NULL COMMENT '奖励说明',
`jinbi` int(11) NOT NULL COMMENT '奖励金币',
`type` int(1) NOT NULL COMMENT '0无 1增 2减',
`ip` varchar(100) NOT NULL COMMENT 'IP地区',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='金币奖励记录';
-- ----------------------------
-- Records of sx_jinbi_records
-- ----------------------------
-- ----------------------------
-- Table structure for sx_jinbi_records_1
-- ----------------------------
DROP TABLE IF EXISTS `sx_jinbi_records_1`;
CREATE TABLE `sx_jinbi_records_1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户id',
`content` varchar(255) NOT NULL COMMENT '奖励说明',
`jinbi` int(11) NOT NULL COMMENT '奖励金币',
`type` int(1) NOT NULL COMMENT '0无 1增 2减',
`ip` varchar(100) NOT NULL COMMENT 'IP地区',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `content` (`content`),
KEY `type` (`type`),
KEY `jinbi` (`jinbi`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='金币奖励记录';
-- ----------------------------
-- Records of sx_jinbi_records_1
-- ----------------------------
-- ----------------------------
-- Table structure for sx_jinbi_time
-- ----------------------------
DROP TABLE IF EXISTS `sx_jinbi_time`;
CREATE TABLE `sx_jinbi_time` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`jinbi` int(11) NOT NULL,
`time` int(11) NOT NULL,
`s` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='倒计时奖励';
-- ----------------------------
-- Records of sx_jinbi_time
-- ----------------------------
-- ----------------------------
-- Table structure for sx_jinbi_time_ad
-- ----------------------------
DROP TABLE IF EXISTS `sx_jinbi_time_ad`;
CREATE TABLE `sx_jinbi_time_ad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`jinbi_time_id` int(11) NOT NULL COMMENT 'jinbi_time 表主键',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='倒计时浮云金币';
-- ----------------------------
-- Records of sx_jinbi_time_ad
-- ----------------------------
-- ----------------------------
-- Table structure for sx_jinbi_tixian
-- ----------------------------
DROP TABLE IF EXISTS `sx_jinbi_tixian`;
CREATE TABLE `sx_jinbi_tixian` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '提现用户id',
`money` int(11) NOT NULL COMMENT '提现金额',
`jinbi` int(11) NOT NULL COMMENT '扣除金币',
`pay` int(1) NOT NULL COMMENT '1 支付宝 2微信',
`hide` int(1) NOT NULL COMMENT '1通过 2审核中 3失败 0禁止',
`band_data` text NOT NULL COMMENT 'jinbi_tixian_band对应表数据',
`time` int(11) NOT NULL COMMENT '提现时间',
`content` varchar(255) DEFAULT NULL COMMENT '备注',
`jinbi_money_id` int(11) NOT NULL COMMENT 'jinbi_money主键',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户提现列表';
-- ----------------------------
-- Records of sx_jinbi_tixian
-- ----------------------------
-- ----------------------------
-- Table structure for sx_jinbi_tixian_band
-- ----------------------------
DROP TABLE IF EXISTS `sx_jinbi_tixian_band`;
CREATE TABLE `sx_jinbi_tixian_band` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户id',
`pay` int(1) NOT NULL COMMENT '1支付宝 2微信',
`data` varchar(255) DEFAULT NULL COMMENT '账户',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='提现账户数据';
-- ----------------------------
-- Records of sx_jinbi_tixian_band
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member
-- ----------------------------
DROP TABLE IF EXISTS `sx_member`;
CREATE TABLE `sx_member` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nickname` varchar(30) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '用户昵称',
`mobile` char(11) DEFAULT NULL COMMENT '手机号码',
`img` varchar(100) DEFAULT NULL COMMENT '头像',
`qianming` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '签名',
`password` varchar(32) DEFAULT NULL COMMENT 'md5密码',
`password_s` varchar(50) DEFAULT NULL COMMENT '明文密码',
`hide` int(1) NOT NULL COMMENT '0禁止 1正常 ',
`create_ip` varchar(50) DEFAULT NULL,
`update_ip` varchar(50) DEFAULT NULL,
`create_time` int(11) DEFAULT NULL,
`update_time` int(11) DEFAULT NULL,
`age` int(1) NOT NULL COMMENT '0 不设置 1男 2女',
`province` varchar(20) DEFAULT NULL COMMENT '省',
`city` varchar(20) DEFAULT NULL COMMENT '城市',
`area` varchar(20) DEFAULT NULL COMMENT '区域',
`birthday` int(11) NOT NULL COMMENT '生日',
`datu` varchar(100) DEFAULT NULL COMMENT '大图',
`jinbi` int(11) NOT NULL COMMENT '金币',
`s1` int(11) NOT NULL COMMENT '一级',
`s2` int(11) NOT NULL COMMENT '二级',
`s3` int(11) NOT NULL COMMENT '三级',
`yqm` varchar(100) DEFAULT NULL COMMENT '邀请码',
`haoma` int(11) NOT NULL COMMENT '抖音号码',
`zhibo_zuan` int(11) NOT NULL COMMENT '直播钻石',
`vip_time` int(11) NOT NULL COMMENT '超过现在时间已开通VIP',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户管理
-- ----------------------------
-- Records of sx_member
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_band
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_band`;
CREATE TABLE `sx_member_band` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`code` varchar(200) NOT NULL COMMENT '唯一的openid',
`time` int(11) NOT NULL COMMENT '时间',
`type` varchar(255) DEFAULT NULL COMMENT '类型',
`info` text COMMENT '回调json',
`unionid` varchar(255) DEFAULT NULL COMMENT '如果开发者拥有多个移动应用、网站应用和公众帐号，可通过获取用户基本信息中的unionid来区分用户的唯一性',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='第三方登录密钥
-- ----------------------------
-- Records of sx_member_band
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_caiji
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_caiji`;
CREATE TABLE `sx_member_caiji` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(2) NOT NULL COMMENT '1=皮皮虾 2=最右',
`uid` int(11) NOT NULL COMMENT '用户id',
`user_id` varchar(255) DEFAULT NULL COMMENT '采集用户的唯一id',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='采集用户唯一id的数据';
-- ----------------------------
-- Records of sx_member_caiji
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_guanzhu
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_guanzhu`;
CREATE TABLE `sx_member_guanzhu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`gz_uid` int(11) NOT NULL COMMENT '被关注用户ID',
`time` int(11) NOT NULL COMMENT '关注时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=
-- ----------------------------
-- Records of sx_member_guanzhu
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_lahei
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_lahei`;
CREATE TABLE `sx_member_lahei` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '拉黑用户',
`time` int(11) NOT NULL,
`uid_s` int(11) NOT NULL COMMENT '被拉黑用户',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户拉黑功能';
-- ----------------------------
-- Records of sx_member_lahei
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_shiming
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_shiming`;
CREATE TABLE `sx_member_shiming` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户id',
`name` varchar(10) DEFAULT NULL COMMENT '姓名',
`sfz_shou` varchar(100) DEFAULT NULL COMMENT '身份证手持',
`sfz_l` varchar(100) DEFAULT NULL COMMENT '身份证正面',
`sfz_r` varchar(100) DEFAULT NULL COMMENT '身份证反面',
`sfz` varchar(100) DEFAULT NULL COMMENT '身份证号码',
`sex` int(1) NOT NULL COMMENT '1男 2女',
`address` varchar(255) DEFAULT NULL COMMENT '身份证地址',
`birthday` int(11) NOT NULL COMMENT '出生日',
`hide` int(1) NOT NULL COMMENT '1正常 2审核 3未审核',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='身份证实名认证';
-- ----------------------------
-- Records of sx_member_shiming
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_xiaoxi
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_xiaoxi`;
CREATE TABLE `sx_member_xiaoxi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL COMMENT '对应表',
`vid` int(11) NOT NULL COMMENT '视频id',
`time` int(11) NOT NULL,
`uid` int(11) NOT NULL COMMENT '接受消息的用户id',
`uid_s` int(11) NOT NULL COMMENT '给发送消息的操作用户',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='消息\r\nvideo的vid是video主键id\r\nvideo_ping的vid是video主键id\r\nvideo_ping_huifu的vid是video_ping主键id\r\nmember_guanzhu的vid为空';
-- ----------------------------
-- Records of sx_member_xiaoxi
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_xiaoxi_fensi
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_xiaoxi_fensi`;
CREATE TABLE `sx_member_xiaoxi_fensi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '接受消息的用户id',
`uid_s` int(11) NOT NULL COMMENT '给发送消息的操作用户',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='粉丝消息';
-- ----------------------------
-- Records of sx_member_xiaoxi_fensi
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_xiaoxi_ping
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_xiaoxi_ping`;
CREATE TABLE `sx_member_xiaoxi_ping` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL COMMENT '对应表',
`vid` int(11) NOT NULL COMMENT '视频id',
`time` int(11) NOT NULL,
`uid` int(11) NOT NULL COMMENT '接受消息的用户id',
`uid_s` int(11) NOT NULL COMMENT '给发送消息的操作用户',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='点赞消息';
-- ----------------------------
-- Records of sx_member_xiaoxi_ping
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_xiaoxi_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_xiaoxi_zan`;
CREATE TABLE `sx_member_xiaoxi_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL COMMENT '对应表',
`vid` int(11) NOT NULL COMMENT '视频id',
`time` int(11) NOT NULL,
`uid` int(11) NOT NULL COMMENT '接受消息的用户id',
`uid_s` int(11) NOT NULL COMMENT '给发送消息的操作用户',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='点赞消息';
-- ----------------------------
-- Records of sx_member_xiaoxi_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_yijian
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_yijian`;
CREATE TABLE `sx_member_yijian` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content` varchar(255) DEFAULT NULL,
`images` varchar(255) DEFAULT NULL,
`lianxi` varchar(255) DEFAULT NULL COMMENT '可能是QQ、邮箱、手机',
`time` int(11) NOT NULL,
`ip` varchar(255) DEFAULT NULL,
`uid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='意见反馈
-- ----------------------------
-- Records of sx_member_yijian
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_zhibo
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_zhibo`;
CREATE TABLE `sx_member_zhibo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '第三方房间号，可用于传入客户系统自带房间号或其他唯一标示，不可重复，否则将会失败',
`roomName` varchar(100) DEFAULT NULL COMMENT '主播室名称',
`anchorPwd` varchar(100) DEFAULT NULL COMMENT '主播登录密码',
`assistPwd` varchar(100) DEFAULT NULL COMMENT '助理登录密码',
`userPwd` varchar(100) DEFAULT NULL COMMENT '用户登录密码',
`anchorDesc` varchar(255) DEFAULT NULL COMMENT '直播描述',
`contentDesc` varchar(255) DEFAULT NULL COMMENT '分享描述',
`creator` varchar(255) DEFAULT NULL COMMENT '创建者',
`maxOnlineNum` int(11) NOT NULL COMMENT '允许在线人数,0或不传表示无限制',
`firstIndustry` varchar(100) DEFAULT NULL COMMENT '大范围行业,如金融',
`secondIndustry` varchar(100) DEFAULT NULL COMMENT '小范围行业,如银行',
`roomId` int(11) NOT NULL COMMENT '房间id',
`type_id` int(11) NOT NULL COMMENT '分类id',
`img_l` varchar(255) DEFAULT NULL COMMENT '横图版面',
`img_r` varchar(255) DEFAULT NULL COMMENT '竖图版面',
`create_time` int(11) NOT NULL COMMENT '创建时间',
`update_time` int(11) NOT NULL COMMENT '最后更新时间',
`des` int(11) NOT NULL COMMENT '排序',
`hide` int(1) NOT NULL COMMENT '0 未开始 1开始',
`renqi` int(11) NOT NULL COMMENT '人气',
`shop_id` int(11) NOT NULL COMMENT '商品ID',
PRIMARY KEY (`id`),
KEY `update_time` (`update_time`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户直播';
-- ----------------------------
-- Records of sx_member_zhibo
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_zhibo_liwu
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_zhibo_liwu`;
CREATE TABLE `sx_member_zhibo_liwu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL,
`money` int(11) DEFAULT NULL,
`img` varchar(255) DEFAULT NULL,
`des` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='直播礼物';
-- ----------------------------
-- Records of sx_member_zhibo_liwu
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_zhibo_liwu_list
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_zhibo_liwu_list`;
CREATE TABLE `sx_member_zhibo_liwu_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '钻石',
`uid_zhu` int(11) NOT NULL COMMENT '主播用户id',
`money` int(11) NOT NULL COMMENT '钻石',
`liwu_id` int(11) NOT NULL COMMENT '礼物id',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`),
KEY `zhu_uid` (`uid_zhu`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户发给主播礼物记录列表';
-- ----------------------------
-- Records of sx_member_zhibo_liwu_list
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_zhibo_money_records
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_zhibo_money_records`;
CREATE TABLE `sx_member_zhibo_money_records` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`money` int(11) NOT NULL,
`type` int(1) NOT NULL COMMENT '1增 2减',
`time` int(11) NOT NULL,
`content` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户钻石消费明细';
-- ----------------------------
-- Records of sx_member_zhibo_money_records
-- ----------------------------
-- ----------------------------
-- Table structure for sx_member_zhibo_type
-- ----------------------------
DROP TABLE IF EXISTS `sx_member_zhibo_type`;
CREATE TABLE `sx_member_zhibo_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL,
`tid` int(11) NOT NULL,
`des` int(10) NOT NULL COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='直播分类';
-- ----------------------------
-- Records of sx_member_zhibo_type
-- ----------------------------
-- ----------------------------
-- Table structure for sx_msg
-- ----------------------------
DROP TABLE IF EXISTS `sx_msg`;
CREATE TABLE `sx_msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of sx_msg
-- ----------------------------
-- ----------------------------
-- Table structure for sx_page
-- ----------------------------
DROP TABLE IF EXISTS `sx_page`;
CREATE TABLE `sx_page` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL COMMENT '标题',
`text` text COMMENT '内容',
`time` int(11) NOT NULL COMMENT '发布时间',
`des` int(5) NOT NULL COMMENT '排序 数字越大越靠前',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='单页内容
-- ----------------------------
-- Records of sx_page
-- ----------------------------
-- ----------------------------
-- Table structure for sx_qiandao
-- ----------------------------
DROP TABLE IF EXISTS `sx_qiandao`;
CREATE TABLE `sx_qiandao` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`ip` varchar(100) NOT NULL,
`tianshu` int(11) NOT NULL COMMENT '连续天数',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='会员签到记录';
-- ----------------------------
-- Records of sx_qiandao
-- ----------------------------
-- ----------------------------
-- Table structure for sx_renwu
-- ----------------------------
DROP TABLE IF EXISTS `sx_renwu`;
CREATE TABLE `sx_renwu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL COMMENT '标题',
`msg` varchar(255) DEFAULT NULL COMMENT '任务介绍',
`des` int(11) NOT NULL,
`jinbi` int(11) NOT NULL COMMENT '奖励金币',
`url` varchar(100) NOT NULL COMMENT 'APP内链接地址',
`type` int(11) NOT NULL COMMENT '分组ID',
`hide` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='任务
-- ----------------------------
-- Records of sx_renwu
-- ----------------------------
-- ----------------------------
-- Table structure for sx_renwu_list
-- ----------------------------
DROP TABLE IF EXISTS `sx_renwu_list`;
CREATE TABLE `sx_renwu_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`renwu_id` int(11) NOT NULL COMMENT 'renwu表对应主键ID',
`uid` int(11) NOT NULL COMMENT '用户主键ID',
`time` int(11) NOT NULL,
`jinbi` int(11) NOT NULL COMMENT '金币',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='任务列表
-- ----------------------------
-- Records of sx_renwu_list
-- ----------------------------
-- ----------------------------
-- Table structure for sx_renwu_type
-- ----------------------------
DROP TABLE IF EXISTS `sx_renwu_type`;
CREATE TABLE `sx_renwu_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL COMMENT '分组标题',
`des` int(11) NOT NULL,
`hide` int(1) NOT NULL COMMENT '0隐藏 1显示',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='任务分类
-- ----------------------------
-- Records of sx_renwu_type
-- ----------------------------
-- ----------------------------
-- Table structure for sx_shop_dingdan
-- ----------------------------
DROP TABLE IF EXISTS `sx_shop_dingdan`;
CREATE TABLE `sx_shop_dingdan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`shop_id` int(11) NOT NULL,
`dizhi` varchar(255) NOT NULL,
`dingdan_id` int(11) NOT NULL COMMENT '对应_dingdan的表主键',
`s` int(1) NOT NULL COMMENT ' 0未付款 1已付款 2已发货 3已确认 4退货退货 5取消订单',
`num` int(11) NOT NULL COMMENT '商品数量',
`kuaidi` varchar(100) DEFAULT NULL,
`danhao` varchar(100) DEFAULT NULL,
`liuyan` varchar(255) DEFAULT NULL,
`shop_uid` int(11) NOT NULL COMMENT '店家UID',
`shop_data` text COMMENT '商品快照',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户商品订单
-- ----------------------------
-- Records of sx_shop_dingdan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_shop_dizhi
-- ----------------------------
DROP TABLE IF EXISTS `sx_shop_dizhi`;
CREATE TABLE `sx_shop_dizhi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`xingming` varchar(20) DEFAULT NULL COMMENT '姓名收件人',
`mobile` char(11) NOT NULL COMMENT '收件手机号码',
`diqu` varchar(100) DEFAULT NULL,
`dizhi` varchar(100) DEFAULT NULL,
`tags` varchar(10) DEFAULT NULL COMMENT '标签',
`moren` int(1) NOT NULL COMMENT '0不默认 1默认',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='商品收货地址
-- ----------------------------
-- Records of sx_shop_dizhi
-- ----------------------------
-- ----------------------------
-- Table structure for sx_shop_list
-- ----------------------------
DROP TABLE IF EXISTS `sx_shop_list`;
CREATE TABLE `sx_shop_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL COMMENT '第三方商品链接',
`content` text COMMENT '商品详细',
`hide` int(1) NOT NULL COMMENT '0禁止 1正常 2审核 3未审核',
`money` decimal(10,2) NOT NULL COMMENT '商品价格',
`typeid` int(11) NOT NULL COMMENT '商品分类id',
`img` varchar(100) DEFAULT NULL COMMENT '商品封面',
`img_list` text COMMENT '商品轮播图',
`num` int(11) NOT NULL COMMENT '商品数量',
`click` int(11) NOT NULL COMMENT '访问量',
`time` int(11) NOT NULL,
`vid` int(11) NOT NULL COMMENT '关联视频',
`shop_data` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='商品链接';
-- ----------------------------
-- Records of sx_shop_list
-- ----------------------------
-- ----------------------------
-- Table structure for sx_shop_typeid
-- ----------------------------
DROP TABLE IF EXISTS `sx_shop_typeid`;
CREATE TABLE `sx_shop_typeid` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL,
`hide` int(1) NOT NULL COMMENT '0不显示 1显示',
`des` int(11) NOT NULL COMMENT '数字越大越靠前',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品分类';
-- ----------------------------
-- Records of sx_shop_typeid
-- ----------------------------
-- ----------------------------
-- Table structure for sx_shop_user
-- ----------------------------
DROP TABLE IF EXISTS `sx_shop_user`;
CREATE TABLE `sx_shop_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`title` varchar(10) DEFAULT NULL,
`content` varchar(100) DEFAULT NULL,
`img` varchar(255) DEFAULT NULL,
`mobile` int(11) NOT NULL COMMENT '电话',
`hide` int(11) NOT NULL COMMENT '0禁止 1正常 2审核 3未审核',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户商铺信息';
-- ----------------------------
-- Records of sx_shop_user
-- ----------------------------
-- ----------------------------
-- Table structure for sx_typeid
-- ----------------------------
DROP TABLE IF EXISTS `sx_typeid`;
CREATE TABLE `sx_typeid` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL,
`hide` int(1) NOT NULL,
`des` int(11) NOT NULL,
`type` int(1) NOT NULL COMMENT '1短视频栏目 2社区栏目',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='分类栏目';
-- ----------------------------
-- Records of sx_typeid
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video
-- ----------------------------
DROP TABLE IF EXISTS `sx_video`;
CREATE TABLE `sx_video` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户id',
`content` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '描述或标题',
`url` varchar(255) DEFAULT NULL COMMENT '视频地址',
`img` varchar(255) DEFAULT NULL COMMENT '背影图片',
`zan_num` int(11) NOT NULL COMMENT '点赞数量',
`ping_num` int(11) NOT NULL COMMENT '评论数量',
`click` int(11) NOT NULL COMMENT '播放数量',
`fx_num` int(11) NOT NULL COMMENT '分享数量',
`hide` int(11) NOT NULL COMMENT '0禁止 1显示 2审核 3拒绝',
`time` int(11) NOT NULL COMMENT '发布时间',
`city` varchar(20) DEFAULT NULL COMMENT '城市名称',
`tuijian` int(1) NOT NULL COMMENT '1显示推荐 0不显示',
`money` int(11) NOT NULL COMMENT '付费视频',
`shop_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='视频列表
-- ----------------------------
-- Records of sx_video
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_avinfo
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_avinfo`;
CREATE TABLE `sx_video_avinfo` (
`vid` int(11) NOT NULL,
`duration` varchar(11) NOT NULL,
`width` int(11) NOT NULL,
`height` int(11) NOT NULL,
`size` int(11) NOT NULL,
`data` text NOT NULL,
KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='视频信息
-- ----------------------------
-- Records of sx_video_avinfo
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_click
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_click`;
CREATE TABLE `sx_video_click` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`vid` int(11) NOT NULL,
`time` int(11) NOT NULL,
`duration` varchar(11) NOT NULL,
`s` int(1) NOT NULL COMMENT '0 未看完 1已看完',
PRIMARY KEY (`id`),
KEY `uid` (`uid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='观看视频的播放用户';
-- ----------------------------
-- Records of sx_video_click
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_jubao
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_jubao`;
CREATE TABLE `sx_video_jubao` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`vid` int(11) NOT NULL,
`time` int(11) NOT NULL,
`content` varchar(255) DEFAULT NULL COMMENT '举报说明',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT=
-- ----------------------------
-- Records of sx_video_jubao
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_money
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_money`;
CREATE TABLE `sx_video_money` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`vid` int(11) NOT NULL,
`money` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='付费视频记录
-- ----------------------------
-- Records of sx_video_money
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_ping
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_ping`;
CREATE TABLE `sx_video_ping` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vid` int(11) NOT NULL COMMENT '内容id',
`uid` int(11) NOT NULL COMMENT '用户id',
`content` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '评论内容',
`zan_num` int(11) NOT NULL COMMENT '点赞数量',
`huifu_num` int(11) NOT NULL COMMENT '回复数量',
`hide` int(11) NOT NULL COMMENT '0不显示 1正常 2审核 3未通过',
`time` int(11) NOT NULL COMMENT '发布时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='评论列表';
-- ----------------------------
-- Records of sx_video_ping
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_ping_huifu
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_ping_huifu`;
CREATE TABLE `sx_video_ping_huifu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ping_id` int(11) NOT NULL COMMENT '评论id',
`uid` int(11) NOT NULL COMMENT '用户id',
`content` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '回复内容',
`zan_num` int(11) NOT NULL COMMENT '点赞数量',
`hide` int(11) NOT NULL COMMENT '0不显示 1正常 2审核 3未通过',
`time` int(11) NOT NULL COMMENT '回复时间',
`huifu_id` int(11) NOT NULL COMMENT '回复id',
`huifu_uid` int(11) NOT NULL COMMENT '回复用户id',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='评论回复内容列表';
-- ----------------------------
-- Records of sx_video_ping_huifu
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_ping_huifu_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_ping_huifu_zan`;
CREATE TABLE `sx_video_ping_huifu_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`huifu_id` int(11) NOT NULL COMMENT '回复id',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞回复';
-- ----------------------------
-- Records of sx_video_ping_huifu_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_ping_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_ping_zan`;
CREATE TABLE `sx_video_ping_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`ping_id` int(11) NOT NULL COMMENT '评论id',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞评论';
-- ----------------------------
-- Records of sx_video_ping_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_shoucang
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_shoucang`;
CREATE TABLE `sx_video_shoucang` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`vid` int(11) NOT NULL COMMENT '视频ID',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞视频
-- ----------------------------
-- Records of sx_video_shoucang
-- ----------------------------
-- ----------------------------
-- Table structure for sx_video_zan
-- ----------------------------
DROP TABLE IF EXISTS `sx_video_zan`;
CREATE TABLE `sx_video_zan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL COMMENT '用户ID',
`vid` int(11) NOT NULL COMMENT '视频ID',
`time` int(11) NOT NULL COMMENT '时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='点赞视频';
-- ----------------------------
-- Records of sx_video_zan
-- ----------------------------
-- ----------------------------
-- Table structure for sx_vip_pay
-- ----------------------------
DROP TABLE IF EXISTS `sx_vip_pay`;
CREATE TABLE `sx_vip_pay` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`money` int(11) NOT NULL,
`time` int(11) NOT NULL,
`content` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='用户订单
-- ----------------------------
-- Records of sx_vip_pay
-- ----------------------------
-- ----------------------------
-- Table structure for sx_yaoqing_records
-- ----------------------------
DROP TABLE IF EXISTS `sx_yaoqing_records`;
CREATE TABLE `sx_yaoqing_records` (
`uid` int(11) DEFAULT NULL COMMENT '用户ID',
`content` text COMMENT '奖励说明',
`money` int(11) NOT NULL COMMENT '奖励金额',
`time` int(11) NOT NULL,
`type` int(2) NOT NULL COMMENT '0金额 1金币',
`data` int(2) NOT NULL COMMENT '0加 1减',
`ip` varchar(100) NOT NULL COMMENT '记录用户IP地区',
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='邀请记录
-- ----------------------------
-- Records of sx_yaoqing_records
-- ----------------------------
