數據字典 · 競拍系統

# MYSQL數據字典說明數據庫表前綴 fx_ 。需要改前綴自行在數據操作重命名，同時在文件數據配置修改prefix前綴 ## 數據庫注釋 SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `fx_admin` -- ---------------------------- DROP TABLE IF EXISTS `fx_admin`; CREATE TABLE `fx_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` int(11) NOT NULL COMMENT '0禁止 1超級管理員 2管理員 3信息員', `name` varchar(100) NOT NULL COMMENT '賬戶', `password` varchar(255) NOT NULL, `create_time` int(11) NOT NULL COMMENT '首次創建賬戶時間', `update_time` int(11) NOT NULL COMMENT '修改用戶更新時間', `create_ip` varchar(255) NOT NULL COMMENT '首次創建賬戶IP地區', `update_ip` varchar(255) NOT NULL COMMENT '修改用戶更新時間', `hide` int(11) NOT NULL COMMENT '0禁止 1正常', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='管理員信息'; -- ---------------------------- -- Records of fx_admin -- ---------------------------- -- ---------------------------- -- Records of fx_admin_log -- ---------------------------- -- ---------------------------- -- Table structure for `fx_admin_type` -- ---------------------------- DROP TABLE IF EXISTS `fx_admin_type`; CREATE TABLE `fx_admin_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL COMMENT '名稱', `data` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='管理員權限菜單ID'; -- ---------------------------- -- Records of fx_admin_type -- ---------------------------- -- ---------------------------- -- Table structure for `fx_article` -- ---------------------------- DROP TABLE IF EXISTS `fx_article`; CREATE TABLE `fx_article` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL COMMENT '標題', `typeid` int(11) NOT NULL COMMENT '欄目', `content` text NOT NULL, `time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文章內容'; -- ---------------------------- -- Records of fx_article -- ---------------------------- -- ---------------------------- -- Table structure for `fx_category` -- ---------------------------- DROP TABLE IF EXISTS `fx_category`; CREATE TABLE `fx_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL COMMENT '標題', `icon` varchar(25) NOT NULL COMMENT '圖標', `tid` int(11) NOT NULL COMMENT '下級關聯', `des` int(11) NOT NULL COMMENT '排序', `controller` varchar(11) NOT NULL COMMENT '控制器', `function` varchar(11) NOT NULL COMMENT '函數', `hideleft` int(10) NOT NULL COMMENT '左邊菜單 0不顯示，1顯示', `hideright` int(10) NOT NULL COMMENT '右邊菜單 0不顯示，1顯示', `get` varchar(255) DEFAULT NULL COMMENT '網址get變量', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='后臺菜單分類'; -- ---------------------------- -- Records of fx_category -- ---------------------------- -- ---------------------------- -- Table structure for `fx_code` -- ---------------------------- DROP TABLE IF EXISTS `fx_code`; CREATE TABLE `fx_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 fx_code -- ---------------------------- -- ---------------------------- -- Table structure for `fx_dingdan` -- ---------------------------- DROP TABLE IF EXISTS `fx_dingdan`; CREATE TABLE `fx_dingdan` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shopid` int(11) NOT NULL, `uid` int(11) NOT NULL, `money` int(11) NOT NULL, `dingdan` varchar(255) NOT NULL, `kuaidi` int(11) NOT NULL COMMENT '快遞公司', `danhao` int(11) NOT NULL COMMENT '快遞單號', `data` int(11) NOT NULL COMMENT '1已付款 2已發貨 3已完成', `time` int(11) NOT NULL, `pay_record` int(11) NOT NULL COMMENT '支付記錄ID', `typePay` int(2) NOT NULL COMMENT '1競拍商品 2差價商品', `dizhiData` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='競拍訂單'; -- ---------------------------- -- Records of fx_dingdan -- ---------------------------- -- ---------------------------- -- Table structure for `fx_jifen_fenxiang` -- ---------------------------- DROP TABLE IF EXISTS `fx_jifen_fenxiang`; CREATE TABLE `fx_jifen_fenxiang` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT '用戶ID', `type` varchar(111) NOT NULL COMMENT '分享類型', `money` int(11) NOT NULL COMMENT '積分', `time` int(11) NOT NULL COMMENT '分享時間，用途判斷每天是否分享', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='分享到第三方平臺用戶獎勵的判斷'; -- ---------------------------- -- Records of fx_jifen_fenxiang -- ---------------------------- -- ---------------------------- -- Table structure for `fx_jifen_records` -- ---------------------------- DROP TABLE IF EXISTS `fx_jifen_records`; CREATE TABLE `fx_jifen_records` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用戶', `uid` int(11) NOT NULL, `money` varchar(111) NOT NULL COMMENT '積分明細', `content` text NOT NULL COMMENT '積分描述', `time` int(11) NOT NULL COMMENT '時間', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='積分記錄'; -- ---------------------------- -- Records of fx_jifen_records -- ---------------------------- -- ---------------------------- -- Table structure for `fx_mall_dingdan` -- ---------------------------- DROP TABLE IF EXISTS `fx_mall_dingdan`; CREATE TABLE `fx_mall_dingdan` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shopid` int(11) NOT NULL COMMENT '商城ID', `uid` int(11) NOT NULL COMMENT '用戶ID', `money` int(11) NOT NULL COMMENT '積分價格', `dingdan` varchar(255) NOT NULL COMMENT '訂單號碼', `kuaidi` int(11) NOT NULL COMMENT '快遞公司', `danhao` int(11) NOT NULL COMMENT '快遞單號', `data` int(11) NOT NULL COMMENT '1已付款 2已發貨 3已完成 ', `time` int(11) NOT NULL, `dizhiData` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商城訂單'; -- ---------------------------- -- Records of fx_mall_dingdan -- ---------------------------- -- ---------------------------- -- Table structure for `fx_mall_list` -- ---------------------------- DROP TABLE IF EXISTS `fx_mall_list`; CREATE TABLE `fx_mall_list` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL COMMENT '標題', `typeid` int(11) NOT NULL COMMENT '分類ID', `image` varchar(255) NOT NULL COMMENT '縮略圖', `images` text NOT NULL COMMENT '產品圖片', `money` decimal(11,0) NOT NULL COMMENT '商品價格', `jifen` decimal(11,0) NOT NULL COMMENT '積分兌換', `paibi` decimal(11,0) NOT NULL COMMENT '拍幣兌換', `yongjin` decimal(11,0) NOT NULL COMMENT '用盡兌換', `num` int(11) NOT NULL COMMENT '商品數量', `text` text NOT NULL COMMENT '商品詳細', `des` int(11) NOT NULL COMMENT '商品排序數字越大越靠前', `jdurl` varchar(255) NOT NULL COMMENT '京東商品地址', `create_time` int(11) NOT NULL COMMENT '添加商品', `update_time` int(11) NOT NULL COMMENT '更新時間', `hide` int(11) NOT NULL, `num_pay` int(11) NOT NULL COMMENT '銷售記錄', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of fx_mall_list -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member` -- ---------------------------- DROP TABLE IF EXISTS `fx_member`; CREATE TABLE `fx_member` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主鍵', `nickname` varchar(100) NOT NULL COMMENT '昵稱', `password` char(32) NOT NULL COMMENT '密碼(MD5加密)', `mobile` char(11) NOT NULL COMMENT '手機', `img` varchar(255) NOT NULL COMMENT '頭像地址', `money` decimal(11,0) NOT NULL COMMENT '賬戶余額', `money_zeng` decimal(11,0) NOT NULL, `hide` int(11) NOT NULL COMMENT '0禁止 1正常', `create_time` int(11) NOT NULL COMMENT '首次創建賬戶時間', `update_time` int(11) NOT NULL COMMENT '修改用戶更新時間', `create_ip` varchar(255) NOT NULL COMMENT '首次創建賬戶IP地區', `update_ip` varchar(255) NOT NULL COMMENT '修改用戶更新時間', `jiqiren` int(2) NOT NULL COMMENT '1機器人', `yongjin` decimal(11,0) NOT NULL COMMENT '傭金', `s1` int(11) NOT NULL COMMENT '師父', `s2` int(11) NOT NULL COMMENT '祖師爺', `yqm` varchar(110) NOT NULL COMMENT '邀請碼', `jifen` decimal(11,0) NOT NULL COMMENT '積分', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用戶信息'; -- ---------------------------- -- Records of fx_member -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member_band` -- ---------------------------- DROP TABLE IF EXISTS `fx_member_band`; CREATE TABLE `fx_member_band` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `code` varchar(200) NOT NULL, `time` int(11) NOT NULL, `type` varchar(255) DEFAULT NULL, `info` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='第三方登錄密鑰'; -- ---------------------------- -- Records of fx_member_band -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member_category` -- ---------------------------- DROP TABLE IF EXISTS `fx_member_category`; CREATE TABLE `fx_member_category` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主鍵', `tid` int(11) unsigned zerofill NOT NULL, `title` varchar(255) DEFAULT NULL COMMENT '標題', `img` varchar(255) DEFAULT NULL COMMENT '分類圖標', `content` varchar(255) DEFAULT NULL COMMENT '描述說明', `controller` varchar(255) DEFAULT NULL COMMENT '控制器文件', `function` varchar(255) DEFAULT NULL COMMENT '類型方法', `des` int(11) DEFAULT NULL COMMENT '排序數字大越靠前', `hide` int(11) DEFAULT NULL COMMENT '0隱藏 1顯示', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用戶中心導航分類'; -- ---------------------------- -- Records of fx_member_category -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member_config` -- ---------------------------- DROP TABLE IF EXISTS `fx_member_config`; CREATE TABLE `fx_member_config` ( `name` varchar(100) NOT NULL COMMENT '字段值', `title` varchar(100) NOT NULL COMMENT '字段標題', `content` varchar(255) NOT NULL COMMENT '字段說明', `text` text NOT NULL COMMENT '字段內容', `type` varchar(255) DEFAULT NULL COMMENT '類型' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='會員配置'; -- ---------------------------- -- Records of fx_member_config -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member_dizhi` -- ---------------------------- DROP TABLE IF EXISTS `fx_member_dizhi`; CREATE TABLE `fx_member_dizhi` ( `id` int(11) NOT NULL AUTO_INCREMENT, `xingming` varchar(100) NOT NULL, `mobile` varchar(100) NOT NULL, `diqu` varchar(100) NOT NULL, `dizhi` varchar(255) DEFAULT NULL, `qq` varchar(100) NOT NULL, `alipay` varchar(100) NOT NULL, `emall` varchar(100) NOT NULL, `moren` int(2) NOT NULL COMMENT '1默認 0不默認', `create_time` int(11) NOT NULL, `update_time` int(11) NOT NULL, `uid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='會員收貨地址'; -- ---------------------------- -- Records of fx_member_dizhi -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member_money` -- ---------------------------- DROP TABLE IF EXISTS `fx_member_money`; CREATE TABLE `fx_member_money` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT '0拍幣 1贈幣', `money` varchar(11) NOT NULL, `content` varchar(255) NOT NULL, `time` int(11) NOT NULL, `ip` varchar(110) NOT NULL, `type` int(2) NOT NULL COMMENT '0拍幣 1贈幣 2元', `shopid` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='金額記錄'; -- ---------------------------- -- Records of fx_member_money -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member_records` -- ---------------------------- DROP TABLE IF EXISTS `fx_member_records`; CREATE TABLE `fx_member_records` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主鍵', `uid` int(11) DEFAULT NULL COMMENT '會員uid', `money` int(11) DEFAULT NULL, `type` varchar(11) DEFAULT NULL, `text` text COMMENT '內容說明', `data` varchar(255) DEFAULT NULL COMMENT '金額來源說明', `time` int(11) DEFAULT NULL COMMENT '操作時間', `ip` varchar(100) DEFAULT NULL COMMENT '操作IP地區', `system` varchar(250) DEFAULT NULL COMMENT '操作系統', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='會員記錄'; -- ---------------------------- -- Records of fx_member_records -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member_shoplist` -- ---------------------------- DROP TABLE IF EXISTS `fx_member_shoplist`; CREATE TABLE `fx_member_shoplist` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) DEFAULT NULL, `shopid` int(11) DEFAULT NULL, `type` int(11) DEFAULT NULL COMMENT ' 1正在拍 2我拍中 3未拍中', `dingdan` int(11) NOT NULL COMMENT '付款訂單ID 訂單表：dingdan 用途判斷競拍是否付款 4待付款 5已付款 ', `time` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `uid` (`uid`) USING BTREE, KEY `type` (`uid`,`type`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='我的競拍記錄'; -- ---------------------------- -- Records of fx_member_shoplist -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member_tixian` -- ---------------------------- DROP TABLE IF EXISTS `fx_member_tixian`; CREATE TABLE `fx_member_tixian` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT '用戶id', `money` decimal(11,0) NOT NULL COMMENT '提現金額', `shouxufei` varchar(11) NOT NULL COMMENT '提現手續費', `xingming` varchar(222) NOT NULL COMMENT '支付寶姓名', `user` varchar(222) NOT NULL COMMENT '支付寶賬戶', `qq` int(111) NOT NULL COMMENT 'QQ號碼', `mobile` varchar(111) NOT NULL COMMENT '電話號碼', `hide` int(111) NOT NULL COMMENT '1正常 2審核 3拒絕', `time` int(11) NOT NULL COMMENT '時間', PRIMARY KEY (`id`), KEY `uid` (`uid`) USING BTREE, KEY `hide` (`hide`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of fx_member_tixian -- ---------------------------- -- ---------------------------- -- Table structure for `fx_member_yongjin` -- ---------------------------- DROP TABLE IF EXISTS `fx_member_yongjin`; CREATE TABLE `fx_member_yongjin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT '獎勵用戶傭金', `money` decimal(11,0) NOT NULL COMMENT '傭金百分單位', `s1` int(11) unsigned zerofill NOT NULL COMMENT '徒弟', `s2` int(11) unsigned zerofill NOT NULL COMMENT '徒孫', `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='邀請獎勵用戶記錄'; -- ---------------------------- -- Records of fx_member_yongjin -- ---------------------------- -- ---------------------------- -- Table structure for `fx_pay` -- ---------------------------- DROP TABLE IF EXISTS `fx_pay`; CREATE TABLE `fx_pay` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) DEFAULT NULL COMMENT '支付名稱', `img` varchar(255) DEFAULT NULL COMMENT '支付圖標', `content` varchar(255) DEFAULT NULL COMMENT '支付說明', `type` varchar(255) DEFAULT NULL COMMENT '支付場景', `hide` int(11) DEFAULT NULL COMMENT '開關', `des` int(11) DEFAULT NULL, `qudao` varchar(255) DEFAULT NULL COMMENT '渠道編碼', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='支付列表，需要先在beecloud配置才能使用支付'; -- ---------------------------- -- Records of fx_pay -- ---------------------------- -- ---------------------------- -- Table structure for `fx_pay_record` -- ---------------------------- DROP TABLE IF EXISTS `fx_pay_record`; CREATE TABLE `fx_pay_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT '會員ID', `code` varchar(255) NOT NULL COMMENT '訂單號', `money` int(11) NOT NULL COMMENT '金額單位分', `status` int(2) NOT NULL COMMENT '0未付款 1已付款', `type` varchar(11) NOT NULL COMMENT '支付渠道ID', `create_time` int(11) NOT NULL COMMENT '付款前時間', `update_time` int(11) NOT NULL COMMENT '付款后時間', `ip` varchar(255) NOT NULL COMMENT 'IP讀取', `system` varchar(255) NOT NULL COMMENT '操作系統', `datainfo` text NOT NULL COMMENT 'beecloud回調返回參數', `payname` varchar(11) NOT NULL COMMENT '消費類型：充值，競拍付款，差價付款', `shopDataPay` text NOT NULL COMMENT '商品數據，用途差價，競拍商品付款的數據操作', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of fx_pay_record -- ---------------------------- -- ---------------------------- -- Table structure for `fx_qiandao_time` -- ---------------------------- DROP TABLE IF EXISTS `fx_qiandao_time`; CREATE TABLE `fx_qiandao_time` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `time` int(11) NOT NULL, `ip` varchar(100) NOT NULL, `money_zeng` int(11) NOT NULL, `tianshu` int(11) NOT NULL COMMENT '連續天數', PRIMARY KEY (`id`), KEY `uid` (`uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='會員簽到記錄'; -- ---------------------------- -- Records of fx_qiandao_time -- ---------------------------- -- ---------------------------- -- Table structure for `fx_sdk` -- ---------------------------- DROP TABLE IF EXISTS `fx_sdk`; CREATE TABLE `fx_sdk` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(111) DEFAULT NULL, `type` varchar(111) DEFAULT NULL, `hide` int(2) DEFAULT NULL COMMENT '0隱藏 1開啟', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of fx_sdk -- ---------------------------- -- ---------------------------- -- Table structure for `fx_shaidan` -- ---------------------------- DROP TABLE IF EXISTS `fx_shaidan`; CREATE TABLE `fx_shaidan` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sid` int(11) NOT NULL, `content` text NOT NULL, `images` text NOT NULL, `time` int(11) NOT NULL, `click` int(11) NOT NULL, `shopid` int(11) NOT NULL, `hide` int(11) NOT NULL COMMENT '1顯示 0不顯示', `uid` int(11) NOT NULL, `shopData` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='曬單'; -- ---------------------------- -- Records of fx_shaidan -- ---------------------------- -- ---------------------------- -- Table structure for `fx_shoplist` -- ---------------------------- DROP TABLE IF EXISTS `fx_shoplist`; CREATE TABLE `fx_shoplist` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sid` int(11) NOT NULL, `title` varchar(255) NOT NULL, `money` int(11) NOT NULL, `typeid` int(11) NOT NULL, `image` varchar(255) NOT NULL, `images` text NOT NULL, `qipaijia` int(11) NOT NULL COMMENT '起拍價', `shouxufei` int(11) NOT NULL COMMENT '競拍需要扣除的拍幣', `daojishi` int(11) NOT NULL COMMENT '競拍倒計時', `jiajia` int(11) NOT NULL COMMENT '加價幅度', `tuibi` int(11) NOT NULL COMMENT '退幣比例', `hide` int(2) NOT NULL, `des` int(11) NOT NULL, `qishu` int(11) NOT NULL, `zonggongqishu` int(11) NOT NULL, `jingpai_uid` int(11) NOT NULL COMMENT '獲得用戶', `jingpai_money` int(11) NOT NULL COMMENT '最終競拍價格', `create_time` int(11) NOT NULL, `update_time` int(11) NOT NULL, `kaishitime` int(11) NOT NULL, `kaishimiao` int(11) NOT NULL, `chajia` int(2) NOT NULL COMMENT '差價購買 1支持差價 0不支持', `jingpai_username` varchar(11) NOT NULL, `jingpai_daojishi` int(11) NOT NULL, `jiqiren` int(2) NOT NULL COMMENT '1開啟機器人，0不開啟機器人', `jiqiren_tingzhi` int(11) NOT NULL COMMENT '機器人刷多少次數停止', `jiqiren_tingzhi_k` int(11) NOT NULL COMMENT '機器人次數開始', `jiqiren_tingzhi_j` int(11) NOT NULL COMMENT '機器人次數開始', `num_j` int(11) NOT NULL COMMENT '機器人參與記錄', `num_z` int(11) NOT NULL COMMENT '真實用戶參與記錄', `jingpai_uids` int(11) NOT NULL COMMENT '競拍用戶UID', `userData` text COMMENT '用戶數據', `jiqiren_bizhong` int(11) DEFAULT NULL COMMENT '必中', `recommend` int(2) DEFAULT NULL COMMENT '新手推薦 0不顯示 1顯示', `jdurl` varchar(255) DEFAULT NULL COMMENT '京東商品地址', `bodyId` int(11) NOT NULL COMMENT '商品詳細的ID', `jingjiqiren_zhenshi` int(11) NOT NULL COMMENT '真實競拍多少次停止', PRIMARY KEY (`id`), KEY `title` (`title`) USING BTREE, KEY `hide` (`hide`) USING BTREE, KEY `typeid` (`typeid`) USING BTREE, KEY `jingpai_uid` (`jingpai_uid`,`hide`) USING BTREE, KEY `sid` (`sid`,`hide`,`jingpai_uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品'; -- ---------------------------- -- Records of fx_shoplist -- ---------------------------- -- ---------------------------- -- Table structure for `fx_shoplist_body` -- ---------------------------- DROP TABLE IF EXISTS `fx_shoplist_body`; CREATE TABLE `fx_shoplist_body` ( `sid` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品sid', `body` text COMMENT '商品詳細ID', PRIMARY KEY (`sid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品詳細內容'; -- ---------------------------- -- Records of fx_shoplist_body -- ---------------------------- -- ---------------------------- -- Table structure for `fx_shoplist_record` -- ---------------------------- DROP TABLE IF EXISTS `fx_shoplist_record`; CREATE TABLE `fx_shoplist_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shopid` int(11) NOT NULL, `uid` int(11) NOT NULL, `money` int(11) NOT NULL, `ip` varchar(222) NOT NULL, `time` int(11) NOT NULL, `daojishi` int(11) NOT NULL, `jiqiren` int(2) NOT NULL COMMENT '1是機器人', `typepaibi` int(2) NOT NULL COMMENT '0拍幣 1贈幣', `userData` text, PRIMARY KEY (`id`), KEY `time` (`time`,`shopid`) USING BTREE, KEY `shopid` (`shopid`,`uid`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of fx_shoplist_record -- ---------------------------- -- ---------------------------- -- Table structure for `fx_slide` -- ---------------------------- DROP TABLE IF EXISTS `fx_slide`; CREATE TABLE `fx_slide` ( `id` int(11) NOT NULL AUTO_INCREMENT, `img` text NOT NULL COMMENT '圖片數組', `url` varchar(255) NOT NULL COMMENT '跳轉', `des` int(11) NOT NULL COMMENT '1顯示 0隱藏', `hide` int(11) unsigned zerofill NOT NULL, `urltype` int(2) NOT NULL, `title` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='輪播圖'; -- ---------------------------- -- Records of fx_slide -- ---------------------------- -- ---------------------------- -- Table structure for `fx_temp` -- ---------------------------- DROP TABLE IF EXISTS `fx_temp`; CREATE TABLE `fx_temp` ( `name` varchar(100) NOT NULL COMMENT '字段值', `title` varchar(100) NOT NULL COMMENT '字段標題', `content` varchar(255) NOT NULL COMMENT '字段說明', `text` text NOT NULL COMMENT '字段內容' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='會員配置'; -- ---------------------------- -- Records of fx_temp -- ---------------------------- -- ---------------------------- -- Table structure for `fx_tousu` -- ---------------------------- DROP TABLE IF EXISTS `fx_tousu`; CREATE TABLE `fx_tousu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dianhua` varchar(255) NOT NULL, `content` text NOT NULL, `uid` int(11) NOT NULL, `time` int(11) NOT NULL, `ip` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='投訴建議'; -- ---------------------------- -- Records of fx_tousu -- ---------------------------- -- ---------------------------- -- Table structure for `fx_typeid` -- ---------------------------- DROP TABLE IF EXISTS `fx_typeid`; CREATE TABLE `fx_typeid` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL COMMENT '欄目標題', `des` int(5) NOT NULL COMMENT '排序', `hide` int(2) NOT NULL COMMENT '0隱藏 1顯示', `create_time` int(11) NOT NULL COMMENT '創建日期', `update_time` int(11) NOT NULL COMMENT '更新日期', `type` int(2) DEFAULT NULL COMMENT '0文章 1商品 2商城', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='分類欄目'; -- ---------------------------- -- Records of fx_typeid -- ---------------------------- -- ---------------------------- -- Table structure for `fx_zhuanpan_cishu` -- ---------------------------- DROP TABLE IF EXISTS `fx_zhuanpan_cishu`; CREATE TABLE `fx_zhuanpan_cishu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL COMMENT '用戶ID', `content` text NOT NULL COMMENT '描述', `cishu` varchar(111) NOT NULL COMMENT '數量', `time` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='轉盤次數記錄'; -- ---------------------------- -- Records of fx_zhuanpan_cishu -- ---------------------------- -- ---------------------------- -- Table structure for `fx_zhuanpan_member` -- ---------------------------- DROP TABLE IF EXISTS `fx_zhuanpan_member`; CREATE TABLE `fx_zhuanpan_member` ( `uid` int(11) NOT NULL, `cishu` int(11) unsigned zerofill NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='轉盤用戶記錄'; -- ---------------------------- -- Records of fx_zhuanpan_member -- ---------------------------- -- ---------------------------- -- Table structure for `fx_zhuanpan_records` -- ---------------------------- DROP TABLE IF EXISTS `fx_zhuanpan_records`; CREATE TABLE `fx_zhuanpan_records` ( `id` int(11) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL, `content` text, `time` int(11) DEFAULT NULL, `ip` varchar(250) DEFAULT NULL COMMENT '用戶IP', `username` varchar(250) DEFAULT NULL COMMENT '用戶名稱', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='轉盤記錄'; -- ---------------------------- -- Records of fx_zhuanpan_records -- ---------------------------- -- ---------------------------- -- Table structure for `fx_zidongchujia` -- ---------------------------- DROP TABLE IF EXISTS `fx_zidongchujia`; CREATE TABLE `fx_zidongchujia` ( `uid` int(11) NOT NULL, `chujia` int(11) NOT NULL, `shopid` int(11) NOT NULL, `shengyu` int(11) NOT NULL, `jiqiren` int(2) NOT NULL COMMENT '1 是機器人' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='自動出價'; -- ---------------------------- -- Records of fx_zidongchujia -- ----------------------------