數據字典 · 速翔視頻系統

/* 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 -- ----------------------------