数据库字典

CREATE TABLE `cms_ad` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) DEFAULT '0',
  `name` varchar(50) DEFAULT '',
  `pic` varchar(255) DEFAULT '',
  `url` varchar(255) DEFAULT '',
  `ordnum` int(10) unsigned DEFAULT '0',
  `isshow` smallint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_ad_group` (
  `gid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gname` varchar(50) DEFAULT '',
  `gnum` int(10) DEFAULT '0',
  `gkey` varchar(50) DEFAULT '',
  PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_admin` (
  `adminid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `adminname` varchar(50) DEFAULT '',
  `adminpass` varchar(50) DEFAULT '',
  `penname` varchar(20) DEFAULT '',
  `pid` int(10) DEFAULT '0',
  `logintimes` int(10) DEFAULT '0',
  `lastlogindate` bigint(10) DEFAULT '0',
  `lastloginip` varchar(50) DEFAULT '',
  `readonly` smallint(1) DEFAULT '0',
  `islock` smallint(1) DEFAULT '0',
  PRIMARY KEY (`adminid`),
  KEY `adminname` (`adminname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_admin_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT '',
  `url` varchar(255) DEFAULT '',
  `msg` varchar(255) DEFAULT '',
  `ip` varchar(50) DEFAULT '',
  `createdate` bigint(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_admin_login_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `loginname` varchar(50) DEFAULT '',
  `loginip` varchar(50) DEFAULT '',
  `logindate` bigint(10) DEFAULT '0',
  `loginmsg` varchar(255) DEFAULT '',
  `loginstate` smallint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_admin_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT '',
  `cname` varchar(50) DEFAULT '',
  `aname` varchar(50) DEFAULT '',
  `dname` varchar(255) DEFAULT '',
  `icon` varchar(50) DEFAULT '',
  `followid` int(10) DEFAULT '0',
  `ordnum` int(10) DEFAULT '0',
  `islock` smallint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_admin_part` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT '',
  `ordnum` int(10) DEFAULT '0',
  `page_list` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_alias` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `alias` varchar(50) DEFAULT '',
  `app` varchar(50) DEFAULT '',
  `sid` int(10) DEFAULT '0',
  `types` int(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `alias` (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_auth` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ckey` varchar(50) DEFAULT '',
  `cval` text,
  `cdate` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_class` (
  `cateid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `followid` int(10) DEFAULT '0',
  `cate_name` varchar(50) DEFAULT '' COMMENT '栏目名称',
  `cate_type` smallint(2) DEFAULT '0' COMMENT '栏目类型',
  `cate_url` varchar(255) DEFAULT '' COMMENT '别名、网址',
  `cate_filter` varchar(255) DEFAULT '',
  `cate_pay` smallint(1) DEFAULT '0' COMMENT '收费方式（0：不收费，2：内容收费，3：下载收费，4：视频收费）',
  `cate_page` int(10) DEFAULT '20' COMMENT '分页数量',
  `cate_order` int(10) DEFAULT '0' COMMENT '排序',
  `cate_title` varchar(255) DEFAULT '',
  `cate_key` varchar(255) DEFAULT '',
  `cate_desc` varchar(255) DEFAULT '',
  `cate_list` varchar(255) DEFAULT '' COMMENT '自定义：列表模板',
  `cate_show` varchar(255) DEFAULT '' COMMENT '自定义：内容页模板',
  `cate_pic` varchar(255) DEFAULT '' COMMENT '栏目图片',
  `cate_en` varchar(255) DEFAULT '' COMMENT '栏目英文',
  `ispost` smallint(1) DEFAULT '0' COMMENT '是否允许投稿',
  `isgroup` smallint(1) DEFAULT '0' COMMENT '是否开启组图功能',
  `ismenu` smallint(1) DEFAULT '0' COMMENT '是否导航显示',
  `isnew` smallint(1) DEFAULT '0' COMMENT '是否新窗口',
  PRIMARY KEY (`cateid`),
  KEY `order` (`cate_order`,`cateid`),
  KEY `where` (`followid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_comment` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) DEFAULT '0' COMMENT '内容ID',
  `parentid` int(10) DEFAULT '0',
  `userid` int(10) unsigned DEFAULT '0',
  `postip` varchar(255) DEFAULT '',
  `postdate` bigint(10) DEFAULT '0',
  `postcity` varchar(20) DEFAULT '',
  `content` text,
  `sonnum` int(10) DEFAULT '0' COMMENT '子评论数量',
  `likenum` int(10) DEFAULT '0' COMMENT '点赞数量',
  `state` smallint(1) DEFAULT '0' COMMENT '状态：（1：显示，0：不显示）',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gid` int(10) DEFAULT '0',
  `ckey` varchar(50) DEFAULT '',
  `ctitle` varchar(50) DEFAULT '',
  `cvalue` text,
  `ordnum` int(10) DEFAULT '0',
  `ctype` int(10) DEFAULT '0',
  `dvalue` text,
  `dtext` text,
  `rtype` smallint(1) DEFAULT '0',
  `utype` smallint(1) DEFAULT '0',
  `islock` smallint(1) DEFAULT '0',
  `issys` smallint(1) DEFAULT '0',
  `ishide` smallint(1) DEFAULT '0',
  `field_table` varchar(255) DEFAULT '',
  `field_join` varchar(510) DEFAULT '',
  `field_where` varchar(510) DEFAULT '',
  `field_order` varchar(510) DEFAULT '',
  `field_value` varchar(255) DEFAULT '',
  `field_label` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `ckey` (`ckey`),
  KEY `gid` (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_config_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gname` varchar(50) DEFAULT '',
  `ordnum` int(10) DEFAULT '0',
  `gkey` varchar(50) DEFAULT '',
  `islock` smallint(1) DEFAULT '0',
  `types` int(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_data` (
  `dataid` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` bigint(10) unsigned DEFAULT '0' COMMENT '内容ID',
  `tags` varchar(255) DEFAULT '',
  `tagslist` varchar(510) DEFAULT '',
  `show_title` varchar(510) DEFAULT '',
  `show_key` varchar(510) DEFAULT '',
  `show_desc` varchar(510) DEFAULT '',
  `show_theme` varchar(255) DEFAULT '',
  `piclist` text,
  `intro` varchar(510) DEFAULT '',
  `content` mediumtext,
  `videourl` varchar(510) DEFAULT '',
  `downurl` varchar(510) DEFAULT '',
  `demourl` varchar(510) DEFAULT '',
  `video_type` smallint(1) DEFAULT '0',
  `video_data` text,
  `down_type` smallint(1) DEFAULT '0',
  `panurl` varchar(510) DEFAULT '',
  `panpass` varchar(20) DEFAULT '',
  PRIMARY KEY (`dataid`),
  KEY `cid` (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_field` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mid` int(10) DEFAULT '0',
  `field_title` varchar(50) DEFAULT '',
  `field_key` varchar(50) DEFAULT '',
  `field_type` int(5) DEFAULT '0',
  `field_length` int(10) DEFAULT '0',
  `field_upload_type` int(10) DEFAULT '0',
  `field_default` varchar(255) DEFAULT '',
  `field_list` text,
  `field_sql` varchar(255) DEFAULT '',
  `field_tips` varchar(255) DEFAULT '',
  `field_rule` int(10) DEFAULT '0',
  `field_radio` int(10) DEFAULT '0',
  `field_editor` int(10) DEFAULT '0',
  `field_group` int(10) DEFAULT '0',
  `field_filter` int(10) DEFAULT '0',
  `field_table` varchar(50) DEFAULT '',
  `field_join` varchar(255) DEFAULT '',
  `field_where` varchar(255) DEFAULT '',
  `field_order` varchar(255) DEFAULT '',
  `field_value` varchar(50) DEFAULT '',
  `field_label` varchar(50) DEFAULT '',
  `ordnum` int(10) DEFAULT '0',
  `isshow` smallint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '1：图片，2：音频，3：视频，4：其他文件',
  `gid` int(10) DEFAULT '0',
  `file_url` varchar(255) DEFAULT '',
  `file_name` varchar(255) DEFAULT '' COMMENT '文件名',
  `file_ext` varchar(50) DEFAULT '' COMMENT '后缀',
  `file_size` int(10) DEFAULT '0',
  `file_type` int(10) DEFAULT '0' COMMENT '1：图片，2：视频，3：其他',
  `file_local` varchar(50) DEFAULT '',
  `file_update` bigint(10) DEFAULT '0' COMMENT '上传的日期',
  `file_ip` varchar(50) DEFAULT '' COMMENT '上传者IP',
  `file_adminid` int(10) DEFAULT '0',
  `userid` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `type` (`file_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_file_group` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gname` varchar(50) DEFAULT '',
  `ordnum` int(10) DEFAULT '0',
  `islock` smallint(1) DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_filter` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT '',
  `ordnum` int(10) DEFAULT '0',
  `islock` smallint(1) DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_filter_list` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) DEFAULT '0',
  `name` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_link` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT '',
  `url` varchar(255) DEFAULT '',
  `ordnum` int(10) DEFAULT '0',
  `isshow` smallint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_order` (
  `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `order_no` varchar(50) DEFAULT '' COMMENT '订单编号',
  `order_total` decimal(10,2) DEFAULT '0.00' COMMENT '订单应付总金额',
  `goods_total` decimal(10,2) DEFAULT '0.00' COMMENT '商品总金额',
  `cost_total` decimal(10,2) DEFAULT '0.00' COMMENT '代金券金额',
  `cost_id` int(10) DEFAULT '0' COMMENT '代金券ID',
  `order_money` decimal(10,2) DEFAULT '0.00' COMMENT '抵扣的佣金',
  `goods_money` decimal(10,2) DEFAULT '0.00' COMMENT '商品佣金（总）',
  `ispay` smallint(1) DEFAULT '0' COMMENT '是否付款',
  `paydate` bigint(10) DEFAULT '0' COMMENT '付款日期',
  `payway` varchar(50) DEFAULT '' COMMENT '付款方式：（支付后直接返回）',
  `trade_no` varchar(510) DEFAULT '' COMMENT '订单交易号',
  `order_type` smallint(1) DEFAULT '0' COMMENT '订单类型（1：内容，2：购买会员）',
  `goods_id` int(10) DEFAULT '0' COMMENT '内容ID或会员组ID',
  `isdown` smallint(1) DEFAULT '0' COMMENT '是否为下载(1：是，0：否)',
  `userid` int(10) unsigned DEFAULT '0',
  `userkey` varchar(255) DEFAULT '' COMMENT '游客key',
  `postcity` varchar(255) DEFAULT '',
  `postip` varchar(255) DEFAULT '',
  `createdate` bigint(10) DEFAULT '0',
  `comefrom` smallint(1) DEFAULT '0' COMMENT '订单来源（1：PC，2：手机，3：微信）',
  `remark` varchar(255) DEFAULT '',
  `isdel` smallint(1) DEFAULT '0',
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_order_list` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `orderid` int(10) unsigned DEFAULT '0' COMMENT '订单编号',
  `goods_id` int(10) unsigned DEFAULT '0' COMMENT '商品ID',
  `goods_skuid` int(10) DEFAULT '0' COMMENT '规格ID',
  `goods_name` varchar(510) CHARACTER SET utf8 DEFAULT '' COMMENT '商品名称',
  `goods_sku` varchar(255) CHARACTER SET utf8 DEFAULT '' COMMENT '商品SKU',
  `goods_pic` varchar(255) DEFAULT '',
  `goods_num` int(10) DEFAULT '0' COMMENT '购买数量',
  `goods_price` decimal(10,2) DEFAULT '0.00',
  `goods_version` smallint(1) DEFAULT '0',
  `userid` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_page` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(10) DEFAULT NULL,
  `piclist` text,
  `content` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_plug` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT '' COMMENT '名称',
  `root` varchar(100) DEFAULT '' COMMENT '路径',
  `icon` varchar(255) DEFAULT '',
  `intro` varchar(510) DEFAULT '',
  `type` varchar(50) DEFAULT '' COMMENT '插件类型',
  `hook` smallint(1) DEFAULT '0' COMMENT '是否有hook',
  `version` varchar(50) DEFAULT '' COMMENT '当前版本',
  `author` varchar(255) DEFAULT '',
  `url` varchar(255) DEFAULT '',
  `config` text COMMENT '配置数据',
  `admin` smallint(1) unsigned DEFAULT '0',
  `state` smallint(1) DEFAULT '0' COMMENT '状态（1：启用，0：禁用）',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_show` (
  `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  `classid` int(10) DEFAULT '0',
  `title` varchar(255) DEFAULT '',
  `pic` varchar(255) DEFAULT '',
  `ispic` smallint(1) DEFAULT '0',
  `price` decimal(10,2) DEFAULT '0.00',
  `money` decimal(10,2) DEFAULT '0.00' COMMENT '佣金',
  `vsales` int(10) unsigned DEFAULT '0',
  `tsales` int(10) unsigned DEFAULT '0',
  `alias` varchar(50) DEFAULT '',
  `isnice` smallint(1) DEFAULT '0',
  `isshow` smallint(2) DEFAULT '0',
  `isauto` smallint(1) DEFAULT '0',
  `isallow` smallint(1) DEFAULT '0' COMMENT '是否允许评论',
  `ordnum` int(10) DEFAULT '0',
  `hits` int(10) unsigned DEFAULT '0',
  `love` int(10) unsigned DEFAULT '0',
  `filter` varchar(255) DEFAULT '',
  `createdate` bigint(10) DEFAULT '0',
  `lastupdate` bigint(10) DEFAULT '0',
  `adminid` int(10) DEFAULT '0',
  `userid` int(10) unsigned DEFAULT '0',
  `reason` varchar(255) DEFAULT '' COMMENT '拒绝的原因',
  `reward` smallint(1) DEFAULT '0' COMMENT '是否已经发放奖励',
  `payway` smallint(1) DEFAULT '1',
  `discount` varchar(510) DEFAULT '[]',
  `vipgroup` varchar(255) DEFAULT '',
  `sideid` varchar(255) DEFAULT '',
  `isurl` smallint(1) DEFAULT '0',
  `url` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `where1` (`isshow`,`classid`),
  KEY `where2` (`isshow`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_sms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mobile` varchar(20) DEFAULT '',
  `code` varchar(20) DEFAULT '' COMMENT '短信验证码',
  `type` varchar(20) DEFAULT '' COMMENT '型类：reg,login,getpass等',
  `enddate` bigint(10) DEFAULT '0' COMMENT '失效时间（可选）',
  `state` smallint(1) DEFAULT '0' COMMENT '是否已经使用（1：是，0：否）',
  `postip` varchar(255) DEFAULT '',
  `postdate` bigint(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_tags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT '',
  `isshow` smallint(1) DEFAULT '0',
  `seo_title` varchar(255) DEFAULT '',
  `seo_key` varchar(255) DEFAULT '',
  `seo_desc` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_token` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `token` text,
  `type` varchar(50) DEFAULT '',
  `createdate` bigint(10) DEFAULT '0',
  `overdate` bigint(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_upload` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(50) DEFAULT '',
  `name` varchar(32) DEFAULT '',
  `val` varchar(510) DEFAULT '',
  `part` text,
  `rand` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user` (
  `atid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `umobile` varchar(11) DEFAULT '',
  `upass` varchar(32) DEFAULT '',
  `uid` int(10) DEFAULT '0' COMMENT '会员组ID',
  `pid` int(10) DEFAULT '0' COMMENT '父ID',
  `uname` varchar(50) DEFAULT '' COMMENT '昵称（必须唯一）',
  `uface` varchar(255) DEFAULT '' COMMENT '头像',
  `uintro` varchar(510) DEFAULT '',
  `amount` decimal(10,2) DEFAULT '0.00' COMMENT '累计消费金额',
  `invoice` decimal(10,2) DEFAULT '0.00' COMMENT '已开票金额',
  `umoney` decimal(10,2) DEFAULT '0.00' COMMENT '佣金',
  `fmoney` decimal(10,2) DEFAULT '0.00' COMMENT '冻结的佣金',
  `tmoney` decimal(10,2) DEFAULT '0.00' COMMENT '总计提现的佣金',
  `percent` int(3) DEFAULT '0' COMMENT '投稿收入百分比',
  `regdate` bigint(10) DEFAULT '0' COMMENT '注册的日期',
  `regip` varchar(255) DEFAULT '' COMMENT '注册的IP',
  `islock` smallint(1) DEFAULT '0',
  `isauth` smallint(1) DEFAULT '1',
  `iscash` smallint(1) DEFAULT '1',
  `logintimes` int(10) DEFAULT '0' COMMENT '登录次数',
  `lastloginip` varchar(255) DEFAULT '' COMMENT '最后登录IP',
  `lastlogindate` bigint(10) DEFAULT '0' COMMENT '最后登录日期',
  `enddate` bigint(10) unsigned DEFAULT '0',
  PRIMARY KEY (`atid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user_auth` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `type` smallint(1) DEFAULT '0' COMMENT '认证类型（1：个人，2：公司）',
  `name` varchar(20) DEFAULT '',
  `idcard` varchar(30) DEFAULT '' COMMENT '身份证号码',
  `postdate` bigint(10) DEFAULT '0',
  `state` smallint(1) DEFAULT '1' COMMENT '审核结果（1：待审，2：成功，3：失败）',
  `msg` varchar(255) DEFAULT '',
  `times` int(10) DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user_bill` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `money` decimal(10,2) DEFAULT '0.00' COMMENT '发票金额',
  `company` varchar(510) DEFAULT '',
  `idnumber` varchar(255) DEFAULT '' COMMENT '纳税人识别号',
  `blank` varchar(510) DEFAULT '' COMMENT '开户银行',
  `blanknum` varchar(255) DEFAULT '',
  `address` varchar(510) DEFAULT '' COMMENT '公司地址',
  `tel` varchar(20) DEFAULT '',
  `postdate` bigint(10) DEFAULT '0',
  `downurl` varchar(255) DEFAULT '' COMMENT '发票下载地址',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user_buy` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `userkey` varchar(255) DEFAULT '',
  `cid` int(10) DEFAULT '0',
  `cprice` decimal(10,2) DEFAULT '0.00',
  `postdate` bigint(10) DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user_cash` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `orderid` varchar(255) DEFAULT '',
  `userid` int(10) unsigned DEFAULT '0',
  `money` decimal(10,2) DEFAULT '0.00',
  `name` varchar(20) DEFAULT '' COMMENT '支付宝姓名',
  `alipay` varchar(255) DEFAULT '' COMMENT '支付宝账号',
  `postdate` bigint(10) DEFAULT '0',
  `state` smallint(1) DEFAULT '0' COMMENT '状态（1：待处理，2：成功，3：失败）',
  `remark` varchar(255) DEFAULT '' COMMENT '拒绝的原因',
  `type` smallint(1) DEFAULT '0' COMMENT '提现方式：（1：手工提现，2：支付宝接口）',
  `trade_no` varchar(255) DEFAULT '' COMMENT '付款交易号',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user_down` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `userkey` varchar(255) DEFAULT '',
  `cid` int(10) DEFAULT '0',
  `num` int(10) DEFAULT '1' COMMENT '下载次数',
  `postdate` bigint(10) DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user_group` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT '',
  `isupgrade` smallint(1) DEFAULT '0' COMMENT '是否允许自动升级',
  `upvalue` int(10) DEFAULT '0' COMMENT '自动升级消费金额',
  `freenum` int(10) DEFAULT '0' COMMENT '每天免费下载文件个数',
  `price` decimal(10,2) DEFAULT '0.00' COMMENT '价格',
  `type` smallint(1) DEFAULT '0' COMMENT '有效期类型（1：天，2：月，3：年，4：永久有效）',
  `num` int(10) DEFAULT '0' COMMENT '有效期',
  `upload` smallint(1) DEFAULT '0' COMMENT '是否允许上传文件',
  `post` smallint(1) DEFAULT '0' COMMENT '是否允许投稿',
  `ordnum` int(10) DEFAULT '0' COMMENT '是否允许投稿',
  `discount` decimal(10,2) DEFAULT '100.00',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user_login` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `type` varchar(50) DEFAULT '',
  `openid` varchar(255) DEFAULT '',
  `unionid` varchar(255) DEFAULT '',
  `binddate` bigint(10) DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user_love` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `cid` int(10) DEFAULT '0',
  `lovedate` bigint(10) DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `cms_user_money` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `money` decimal(10,2) DEFAULT '0.00',
  `oldmoney` decimal(10,2) DEFAULT '0.00',
  `newmoney` decimal(10,2) DEFAULT '0.00',
  `type` smallint(1) DEFAULT '0' COMMENT '1:增加，2：减少',
  `title` varchar(255) DEFAULT '',
  `createdate` bigint(10) DEFAULT '0',
  PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;