# 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
-- ----------------------------
