找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 388|回复: 0

[接口开发] 新秀网络验证数据库对照表X3.5 - ver1.7

[复制链接]
发表于 2024-9-10 18:05:57 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区

您需要 登录 才可以下载或查看,没有账号?立即注册

×
[PHP] 纯文本查看 复制代码
--
-- 表的结构 `pre_xinxiuvip_network_actions`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_actions`;
CREATE TABLE `pre_xinxiuvip_network_actions` (
  `id` bigint(16) UNSIGNED NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `typekey` int(10) UNSIGNED DEFAULT NULL COMMENT '0key1管理key',
  `groups` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户组设置',
  `extcredits` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'extcredits积分类型',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接口方法',
  `status` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0打开1关闭',
  `islogs` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0开启1关闭',
  `snum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '每秒调用次数',
  `hnum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1小时内最多调用次数',
  `dnum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '24小时',
  `nums` bigint(16) UNSIGNED NOT NULL DEFAULT '0' COMMENT '总调用次数',
  `zjf` int(10) UNSIGNED DEFAULT NULL COMMENT '增积分',
  `kjf` int(10) UNSIGNED DEFAULT NULL COMMENT '减积分',
  `do` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0不处理、1踢下线、2封号、3封IP',
  `ips` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'IP黑名单',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ziduan` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '返回字段',
  `remarks` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注',
  `moment` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '临时存储'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_actions_logs`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_actions_logs`;
CREATE TABLE `pre_xinxiuvip_network_actions_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` bigint(20) UNSIGNED NOT NULL COMMENT '用户uid',
  `apikey` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '传输密钥或管理密钥',
  `isapi` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actions` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `errcode` int(3) UNSIGNED NOT NULL,
  `isget` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ispost` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` int(10) UNSIGNED NOT NULL,
  `fromip` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `output` longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_cache`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_cache`;
CREATE TABLE `pre_xinxiuvip_network_cache` (
  `id` bigint(16) UNSIGNED NOT NULL COMMENT 'id',
  `cache_uid` int(10) UNSIGNED NOT NULL COMMENT '发布uid',
  `cache_uids` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户uids',
  `cache_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类',
  `cache_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '缓存密钥',
  `cache_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '缓存值',
  `cache_time` int(10) UNSIGNED NOT NULL COMMENT '缓存时间',
  `cahe_time_old` int(10) UNSIGNED NOT NULL COMMENT '到期时间',
  `cache_groupid` int(10) UNSIGNED NOT NULL COMMENT '用户组',
  `cache_groupids` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户组ids',
  `cache_credist` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '积分',
  `cache_rule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '规则',
  `cache_start` int(10) UNSIGNED NOT NULL COMMENT '状态0是开启1是关闭',
  `cache_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_cache_external`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_cache_external`;
CREATE TABLE `pre_xinxiuvip_network_cache_external` (
  `id` bigint(16) UNSIGNED NOT NULL COMMENT 'id',
  `cache_uid` int(10) UNSIGNED NOT NULL COMMENT '发布uid',
  `cache_uids` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'uids',
  `cache_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分类',
  `cache_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '缓存密钥',
  `cache_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '缓存值',
  `cache_time` int(10) UNSIGNED NOT NULL COMMENT '缓存时间',
  `cahe_time_old` int(10) UNSIGNED NOT NULL COMMENT '到期时间',
  `cache_groupid` int(10) UNSIGNED NOT NULL COMMENT '用户组',
  `cache_groupids` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户组ids',
  `cache_credist` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '积分',
  `cache_rule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '规则',
  `cache_start` int(10) UNSIGNED NOT NULL COMMENT '状态0是开启1是关闭',
  `cache_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_codepays`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_codepays`;
CREATE TABLE `pre_xinxiuvip_network_codepays` (
  `id` bigint(16) UNSIGNED NOT NULL,
  `pay_uid` int(11) UNSIGNED NOT NULL COMMENT '用户uid',
  `pay_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户ID或订单ID',
  `money` decimal(6,2) UNSIGNED NOT NULL COMMENT '实际金额',
  `price` decimal(6,2) UNSIGNED NOT NULL COMMENT '原价',
  `type` int(1) NOT NULL DEFAULT '1' COMMENT '支付方式',
  `pay_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流水号',
  `param` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义参数1为时间充值,其他都是积分',
  `pay_time` bigint(11) NOT NULL DEFAULT '0' COMMENT '付款时间',
  `pay_tag` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '金额的备注',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '订单状态0失败1成功',
  `creditskey` int(1) UNSIGNED NOT NULL COMMENT '充值积分类型',
  `creditsval` int(11) UNSIGNED NOT NULL COMMENT '充值积分值',
  `signtime` int(11) UNSIGNED NOT NULL COMMENT '充值卡号时间',
  `codes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邀请码',
  `cards` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '激活卡号',
  `creat_time` bigint(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `up_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_credits_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_credits_log`;
CREATE TABLE `pre_xinxiuvip_network_credits_log` (
  `id` bigint(16) UNSIGNED NOT NULL COMMENT '日志id',
  `uid` bigint(16) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所属用户uid',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `operation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作类型',
  `relatedid` int(10) UNSIGNED NOT NULL COMMENT '操作处理类型',
  `dateline` int(10) UNSIGNED NOT NULL COMMENT '记录时间',
  `extcredits1` int(10) NOT NULL,
  `extcredits2` int(10) NOT NULL,
  `extcredits3` int(10) NOT NULL,
  `extcredits4` int(10) NOT NULL,
  `extcredits5` int(10) NOT NULL,
  `extcredits6` int(10) NOT NULL,
  `extcredits7` int(10) NOT NULL,
  `extcredits8` int(10) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题',
  `text` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
  `sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '签名'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_email_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_email_log`;
CREATE TABLE `pre_xinxiuvip_network_email_log` (
  `id` bigint(16) NOT NULL,
  `type` int(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0=验证码1=发邮件2=登录',
  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邮箱地址',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '验证码',
  `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信内容',
  `template` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信模版',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `oldtime` int(10) UNSIGNED NOT NULL COMMENT '过期时间',
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ip地址'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_fields`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_fields`;
CREATE TABLE `pre_xinxiuvip_network_fields` (
  `id` bigint(16) UNSIGNED NOT NULL,
  `uid` bigint(16) UNSIGNED NOT NULL,
  `text1` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text2` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text3` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text4` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text5` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text6` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text7` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text8` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text9` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text10` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text11` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text12` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text13` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text14` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text15` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text16` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text17` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text18` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text19` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text20` longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='私人变量';

--
-- 表的结构 `pre_xinxiuvip_network_globals`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_globals`;
CREATE TABLE `pre_xinxiuvip_network_globals` (
  `id` bigint(16) UNSIGNED NOT NULL,
  `text1` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text2` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text3` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text4` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text5` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text6` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text7` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text8` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text9` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text10` longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_kahao`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_kahao`;
CREATE TABLE `pre_xinxiuvip_network_kahao` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` bigint(20) UNSIGNED NOT NULL COMMENT '用户uid',
  `makeuid` bigint(20) UNSIGNED NOT NULL COMMENT '制卡者uid',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态0正常1禁止',
  `sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '固定卡号',
  `types` tinyint(1) UNSIGNED NOT NULL COMMENT '卡号是否激活0为未激活1为激活',
  `price` int(10) UNSIGNED NOT NULL COMMENT '面值',
  `typename` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '卡号分类',
  `sgintime` int(10) UNSIGNED NOT NULL COMMENT '卡内剩余时间',
  `credits` int(10) UNSIGNED NOT NULL COMMENT '卡内剩余积分',
  `buycredits` int(10) UNSIGNED NOT NULL COMMENT '剩余交易积分',
  `tokens` int(10) UNSIGNED NOT NULL COMMENT '多开登录数量',
  `dateline` int(10) UNSIGNED NOT NULL COMMENT '卡号制作时间',
  `clearline` int(10) UNSIGNED NOT NULL COMMENT '卡号激活时间',
  `moment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '临时存储',
  `remarks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_kami`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_kami`;
CREATE TABLE `pre_xinxiuvip_network_kami` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` bigint(20) UNSIGNED NOT NULL COMMENT '用户uid',
  `makeuid` bigint(20) UNSIGNED NOT NULL COMMENT '制卡者uid',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态0正常1禁止',
  `sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '固定卡密',
  `types` tinyint(1) UNSIGNED NOT NULL COMMENT '卡密是否激活0为未激活1为激活',
  `price` int(10) UNSIGNED NOT NULL COMMENT '面值',
  `typename` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '卡密分类',
  `sgintime` int(10) UNSIGNED NOT NULL COMMENT '卡内剩余时间',
  `credits` int(10) UNSIGNED NOT NULL COMMENT '卡内剩余积分',
  `buycredits` int(10) UNSIGNED NOT NULL COMMENT '剩余交易积分',
  `tokens` int(10) UNSIGNED NOT NULL COMMENT '多开登录数量',
  `dateline` int(10) UNSIGNED NOT NULL COMMENT '卡密制作时间',
  `clearline` int(10) UNSIGNED NOT NULL COMMENT '卡密激活时间',
  `moment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '临时存储',
  `remarks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_licenses`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_licenses`;
CREATE TABLE `pre_xinxiuvip_network_licenses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uid` bigint(20) UNSIGNED NOT NULL COMMENT '官网授权用户uid',
  `typename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授权分类',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '官网授权用户名',
  `groupname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授权用户组名',
  `groupid` int(10) UNSIGNED NOT NULL COMMENT '授权用户组id',
  `datetime` int(10) UNSIGNED NOT NULL COMMENT '到期时间',
  `updatetime` int(10) UNSIGNED NOT NULL COMMENT '更新时间',
  `domain` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授权域名',
  `licenses` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授权码',
  `states` tinyint(1) UNSIGNED NOT NULL COMMENT '授权状态0正常1禁止	',
  `remarks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_log`;
CREATE TABLE `pre_xinxiuvip_network_log` (
  `id` bigint(16) UNSIGNED NOT NULL,
  `uid` smallint(5) UNSIGNED NOT NULL,
  `apikey` char(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isapi` char(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `actions` char(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `errcode` int(3) UNSIGNED DEFAULT NULL,
  `isget` text COLLATE utf8mb4_unicode_ci,
  `ispost` text COLLATE utf8mb4_unicode_ci,
  `time` int(10) UNSIGNED DEFAULT NULL,
  `fromip` char(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `output` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_members`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_members`;
CREATE TABLE `pre_xinxiuvip_network_members` (
  `id` bigint(16) UNSIGNED NOT NULL,
  `uid` int(10) UNSIGNED NOT NULL COMMENT '绑定用户',
  `username` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '绑定用户名',
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grouptitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '当前用户组名',
  `sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '固定卡号',
  `status` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0正常1禁止',
  `changes` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '换绑次数',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '机器码绑定',
  `inttoken` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '多开登录数量',
  `dateline` int(10) UNSIGNED NOT NULL COMMENT '卡号过期时间',
  `groupid` int(10) UNSIGNED NOT NULL COMMENT '当前用户组id',
  `groupline` int(10) UNSIGNED NOT NULL COMMENT '用户组过期时间',
  `clearline` int(10) UNSIGNED NOT NULL COMMENT '激活时间',
  `freezeline` int(10) UNSIGNED NOT NULL COMMENT '冻结时间',
  `crons` int(10) UNSIGNED NOT NULL COMMENT '心跳包次数',
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手机号',
  `qq` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'QQopenid',
  `weixin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信绑定id',
  `safe` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '安全码',
  `logincard` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '登录密保卡',
  `remarks` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注',
  `moment` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '临时存储'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_payjss`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_payjss`;
CREATE TABLE `pre_xinxiuvip_network_payjss` (
  `id` bigint(16) UNSIGNED NOT NULL COMMENT '日志id',
  `uid` bigint(16) UNSIGNED NOT NULL COMMENT '用户uid',
  `status` int(1) UNSIGNED NOT NULL COMMENT '状态码1发起支付2已支付',
  `orderid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户生成的订单号原样返回',
  `price` int(16) UNSIGNED NOT NULL COMMENT '支付金额元',
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ip',
  `types` int(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '充值类型1为微信2为支付宝3其他',
  `payjs_order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'PAYJS 平台订单号',
  `attach` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户自定义数据',
  `return_code` int(1) UNSIGNED NOT NULL COMMENT '订单提交成功',
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信用户手机显示订单号',
  `submitdate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '下单时间',
  `time_end` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '支付成功时间',
  `openid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户OPENID标示,本参数没有实际意义,旨在方便用户端区分不同用户',
  `mchid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'PAYJS 商户号',
  `pay_type` int(1) NOT NULL DEFAULT '0' COMMENT '支付类型。1积分充值2时间充值3购买卡密',
  `sign` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '数据签名',
  `pay_log` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '充值备注',
  `creditskey` int(1) UNSIGNED NOT NULL COMMENT '充值积分类型',
  `creditsval` int(11) UNSIGNED NOT NULL COMMENT '充值积分值',
  `signtime` int(11) UNSIGNED NOT NULL COMMENT '充值卡号时间',
  `codes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邀请码',
  `cards` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '激活卡号',
  `kami` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '购买卡密',
  `body` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '支付商品名称',
  `texts` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '提交参数',
  `nums` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '查询次数'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_phone_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_phone_log`;
CREATE TABLE `pre_xinxiuvip_network_phone_log` (
  `id` bigint(16) NOT NULL,
  `type` int(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0=验证码1=发短信2=登录',
  `phone` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手机号',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '验证码',
  `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信内容',
  `template` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信模版',
  `BizId` int(10) UNSIGNED NOT NULL COMMENT '回执ID',
  `RequestId` int(10) UNSIGNED NOT NULL COMMENT '请求id',
  `dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `oldtime` int(10) UNSIGNED NOT NULL COMMENT '过期时间',
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ip地址'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_set`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_set`;
CREATE TABLE `pre_xinxiuvip_network_set` (
  `id` bigint(16) UNSIGNED NOT NULL,
  `text1` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text2` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text3` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text4` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text5` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text6` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text7` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text8` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text9` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text10` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text11` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text12` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text13` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text14` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text15` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text16` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text17` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text18` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text19` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text20` longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_sign`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_sign`;
CREATE TABLE `pre_xinxiuvip_network_sign` (
  `id` bigint(16) UNSIGNED NOT NULL,
  `uid` int(10) UNSIGNED NOT NULL COMMENT '绑定用户',
  `makeuid` int(10) UNSIGNED NOT NULL COMMENT '制卡代理uid',
  `type` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0未激活1激活',
  `sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '固定卡密',
  `price` int(10) UNSIGNED NOT NULL COMMENT '面值',
  `typename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '默认分类' COMMENT '分类',
  `status` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0正常1锁定',
  `times` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '卡内剩余时间',
  `credits` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '剩余积分',
  `buycredits` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '剩余交易积分',
  `inttoken` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '多开登录数量',
  `dateline` int(10) UNSIGNED NOT NULL COMMENT '制作时间',
  `clearline` int(10) UNSIGNED NOT NULL COMMENT '激活时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_sign_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_sign_log`;
CREATE TABLE `pre_xinxiuvip_network_sign_log` (
  `id` bigint(16) NOT NULL,
  `uid` mediumint(8) NOT NULL DEFAULT '0' COMMENT '提卡uid',
  `price` int(10) UNSIGNED NOT NULL COMMENT '面值',
  `cardrule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '卡号规则',
  `extcreditskey` int(10) UNSIGNED NOT NULL COMMENT '积分类型',
  `extcreditsval` int(10) UNSIGNED NOT NULL COMMENT '积分值',
  `info` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注信息',
  `dateline` int(10) NOT NULL DEFAULT '0' COMMENT '操作日期',
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '提卡类型',
  `num` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '购买数量'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


--
-- 表的结构 `pre_xinxiuvip_network_tixian`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_tixian`;
CREATE TABLE `pre_xinxiuvip_network_tixian` (
  `id` bigint(16) UNSIGNED NOT NULL COMMENT '订单id',
  `typeid` smallint(6) UNSIGNED NOT NULL DEFAULT '1' COMMENT '分类id',
  `maketype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '提交方法',
  `makeruid` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT '提交uid',
  `price` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT '交易面值',
  `extcreditskey` tinyint(1) NOT NULL DEFAULT '0' COMMENT '积分种类',
  `extcreditsval` int(10) NOT NULL DEFAULT '0' COMMENT '积分值',
  `status` tinyint(1) UNSIGNED NOT NULL COMMENT '交易动作',
  `uiddate` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '提交时间',
  `uidtext` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '提现备注',
  `alipay` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '支付宝',
  `weixin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信',
  `admindateline` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '交易时间',
  `admintext` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '处理备注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 表的结构 `pre_xinxiuvip_network_token`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_token`;
CREATE TABLE `pre_xinxiuvip_network_token` (
  `id` bigint(16) UNSIGNED NOT NULL,
  `uid` mediumint(8) UNSIGNED DEFAULT NULL,
  `username` char(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'IP地址',
  `groupid` tinyint(3) UNSIGNED DEFAULT NULL COMMENT '会员组id',
  `adminid` tinyint(3) UNSIGNED DEFAULT NULL COMMENT '管理组id',
  `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '验证token',
  `tokens` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'tokens数组',
  `tnum` int(10) UNSIGNED DEFAULT '0' COMMENT '被踢下线次数',
  `lastactivity` int(10) UNSIGNED DEFAULT NULL COMMENT '最后活动时间',
  `loginint` int(10) UNSIGNED NOT NULL COMMENT '登录次数'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|新秀网络验证系统API[软著登字第13061951号] ( 豫ICP备2021033257号-1 )

GMT+8, 2024-10-9 11:34 , Processed in 0.259302 second(s), 43 queries , Redis On.

Powered by Discuz! X3.5 Licensed

© 2001-2024 Discuz! Team.

快速回复 返回顶部 返回列表