新秀网络验证数据库对照表X3.5 - ver1.7
---- 表的结构 `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;
页:
[1]