新秀网络验证数据库对照表 ver6.6
版本升级过程中，如遇到字段缺失，请对照下表进行添加。有需求二次开发的可按此数据库进行调用。CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_actions` (
`id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL,
`typekey` int(10) UNSIGNED NOT NULL COMMENT '0key1管理key',
`groups` varchar(255) NOT NULL COMMENT '用户组设置',
`name` varchar(255) NOT NULL,
`actions` varchar(255) 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) NOT NULL DEFAULT '0' COMMENT '每秒调用次数',
`hnum` int(10) NOT NULL DEFAULT '0' COMMENT '1小时内最多调用次数',
`dnum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '24小时',
`nums` bigint(16) NOT NULL COMMENT '总调用次数',
`do` int(10) NOT NULL DEFAULT '0' COMMENT '0不处理、1踢下线、2封号、3封IP',
`ips` longtext NOT NULL COMMENT 'IP黑名单',
`url` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_fields` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL,
`text1` longtext NOT NULL,
`text2` longtext NOT NULL,
`text3` longtext NOT NULL,
`text4` longtext NOT NULL,
`text5` longtext NOT NULL,
`text6` longtext NOT NULL,
`text7` longtext NOT NULL,
`text8` longtext NOT NULL,
`text9` longtext NOT NULL,
`text10` longtext NOT NULL,
`text11` longtext NOT NULL,
`text12` longtext NOT NULL,
`text13` longtext NOT NULL,
`text14` longtext NOT NULL,
`text15` longtext NOT NULL,
`text16` longtext NOT NULL,
`text17` longtext NOT NULL,
`text18` longtext NOT NULL,
`text19` longtext NOT NULL,
`text20` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_globals` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT,
`text1` longtext NOT NULL,
`text2` longtext NOT NULL,
`text3` longtext NOT NULL,
`text4` longtext NOT NULL,
`text5` longtext NOT NULL,
`text6` longtext NOT NULL,
`text7` longtext NOT NULL,
`text8` longtext NOT NULL,
`text9` longtext NOT NULL,
`text10` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_jiaoyi` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT 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 '交易动作',
`dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '提交时间',
`cleardateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '过期时间',
`useddateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '交易时间',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '购买者uid',
PRIMARY KEY (`id`),
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_members` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL COMMENT '绑定用户',
`username` char(15) NOT NULL DEFAULT '' COMMENT '绑定用户名',
`grouptitle` varchar(255) NOT NULL DEFAULT '' COMMENT '当前用户组名',
`makeuid` int(10) unsigned NOT NULL COMMENT '制卡代理uid',
`sgin` varchar(255) NOT NULL COMMENT '固定卡密',
`price` int(10) unsigned NOT NULL COMMENT '面值',
`type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '0未激活1激活',
`typename` varchar(255) NOT NULL DEFAULT '默认分类' COMMENT '分类',
`status` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '0正常1禁止',
`changes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '换绑次数',
`code` varchar(255) NOT NULL COMMENT '机器码绑定',
`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 '卡号过期时间',
`groupid` int(10) unsigned NOT NULL COMMENT '当前用户组id',
`groupline` int(10) unsigned NOT NULL COMMENT '用户组过期时间',
`clearline` int(10) unsigned NOT NULL COMMENT '激活时间',
`crons` int(10) unsigned NOT NULL COMMENT '心跳包次数',
`phone` varchar(255) NOT NULL COMMENT '手机号',
`qq` varchar(255) NOT NULL COMMENT 'QQopenid',
`weixin` varchar(255) NOT NULL COMMENT '微信绑定id',
`safe` varchar(255) NOT NULL COMMENT '安全码',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_recharge` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单id',
`typeid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '1支付宝2微信0其他',
`orderid` varchar(255) NOT NULL COMMENT '订单交易号',
`type` tinyint(1) DEFAULT NULL COMMENT '充值项目名称',
`makeruid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '充值者uid',
`account` varchar(255) NOT NULL COMMENT '支付账号',
`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 DEFAULT '0' COMMENT '交易动作0未完成、1已完成',
`dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '充值时间',
`cleardateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '积分充值成功时间',
`makertext` text NOT NULL COMMENT '充值备注',
`admintext` text NOT NULL COMMENT '积分充值备注',
PRIMARY KEY (`id`),
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_tixian` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT 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 NOT NULL COMMENT '提现备注',
`alipay` varchar(255) NOT NULL COMMENT '支付宝',
`weixin` varchar(255) NOT NULL COMMENT '微信',
`admindateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '交易时间',
`admintext` varchar(255) NOT NULL COMMENT '处理备注',
PRIMARY KEY (`id`),
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_token` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned DEFAULT NULL,
`username` char(15) DEFAULT NULL,
`ip1` tinyint(3) unsigned DEFAULT NULL,
`ip2` tinyint(3) unsigned DEFAULT NULL,
`ip3` tinyint(3) unsigned DEFAULT NULL,
`ip4` tinyint(3) unsigned DEFAULT NULL,
`groupid` tinyint(3) unsigned DEFAULT NULL COMMENT '会员组id',
`adminid` tinyint(3) unsigned DEFAULT NULL COMMENT '管理组id',
`token` varchar(1000) DEFAULT NULL COMMENT '验证token',
`tokens` mediumtext 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 '登录次数',
PRIMARY KEY (`id`),
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_set` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT,
`text1` longtext NOT NULL,
`text2` longtext NOT NULL,
`text3` longtext NOT NULL,
`text4` longtext NOT NULL,
`text5` longtext NOT NULL,
`text6` longtext NOT NULL,
`text7` longtext NOT NULL,
`text8` longtext NOT NULL,
`text9` longtext NOT NULL,
`text10` longtext NOT NULL,
`text11` longtext NOT NULL,
`text12` longtext NOT NULL,
`text13` longtext NOT NULL,
`text14` longtext NOT NULL,
`text15` longtext NOT NULL,
`text16` longtext NOT NULL,
`text17` longtext NOT NULL,
`text18` longtext NOT NULL,
`text19` longtext NOT NULL,
`text20` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_phone_log` (
`id` BIGINT(16) NOT NULL AUTO_INCREMENT,
`type` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=验证码1=发短信2=登录',
`phone` varchar(11) NOT NULL COMMENT '手机号',
`code` varchar(255) NOT NULL COMMENT '验证码',
`content` varchar(255) NOT NULL COMMENT '短信内容',
`template` varchar(255) 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) NOT NULL COMMENT 'ip地址',
PRIMARY KEY (`id`),
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_email_log` (
`id` BIGINT(16) NOT NULL AUTO_INCREMENT,
`type` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=验证码1=发邮件2=登录',
`email` varchar(50) NOT NULL COMMENT '邮箱地址',
`code` varchar(255) NOT NULL COMMENT '验证码',
`content` varchar(255) NOT NULL COMMENT '短信内容',
`template` varchar(255) 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) NOT NULL COMMENT 'ip地址',
PRIMARY KEY (`id`),
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_codepays` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT,
`pay_uid` int(11) unsigned NOT NULL COMMENT '用户uid',
`pay_id` varchar(50) 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) NOT NULL COMMENT '流水号',
`param` varchar(200) DEFAULT NULL COMMENT '自定义参数1为时间充值，其他都是积分',
`pay_time` bigint(11) NOT NULL DEFAULT '0' COMMENT '付款时间',
`pay_tag` varchar(100) 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) NOT NULL COMMENT '邀请码',
`cards` varchar(255) 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 '更新时间',
PRIMARY KEY (`id`),
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_sign` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT,
`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) NOT NULL COMMENT '固定卡密',
`price` int(10) unsigned NOT NULL COMMENT '面值',
`typename` varchar(255) 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 '激活时间',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_sign_log` (
`id` BIGINT(16) NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) NOT NULL DEFAULT '0' COMMENT '提卡uid',
`price` int(10) unsigned NOT NULL COMMENT '面值',
`cardrule` varchar(255) NOT NULL DEFAULT '' COMMENT '卡号规则',
`extcreditskey` int(10) unsigned NOT NULL COMMENT '积分类型',
`extcreditsval` int(10) unsigned NOT NULL COMMENT '积分值',
`info` text NOT NULL COMMENT '备注信息',
`dateline` int(10) NOT NULL DEFAULT '0' COMMENT '操作日期',
`description` text NOT NULL COMMENT '提卡类型',
`num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '购买数量',
PRIMARY KEY (`id`),
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_license` (
`id` BIGINT(16) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL COMMENT '授权分类',
`uid` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL COMMENT '用户名',
`time` int(10) unsigned NOT NULL COMMENT '到期时间',
`times` int(10) unsigned NOT NULL COMMENT '更新时间',
`groupid` int(10) unsigned NOT NULL COMMENT '用户组id',
`domain` varchar(255) NOT NULL COMMENT '域名',
`license` varchar(1000) NOT NULL COMMENT '授权码',
`status` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_credits_log` (
`id` BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '日志id',
`uid` bigint(16) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所属用户uid',
`username` text NOT NULL,
`operation` text 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(100) NOT NULL COMMENT '标题',
`text` text NOT NULL COMMENT '内容',
`sgin` text NOT NULL COMMENT '签名',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_payjss` (
`id` BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '日志id',
`uid` bigint(16) UNSIGNED NOT NULL COMMENT '用户uid',
`status` int(1) UNSIGNED NOT NULL COMMENT '状态码1发起支付2已支付',
`orderid` varchar(255) NOT NULL COMMENT '用户生成的订单号原样返回',
`price` int(16) UNSIGNED NOT NULL COMMENT '支付金额元',
`ip` varchar(255) NOT NULL COMMENT 'ip',
`types` int(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '充值类型1为微信2为支付宝3其他',
`payjs_order_id` varchar(255) NOT NULL COMMENT 'PAYJS 平台订单号',
`attach` varchar(255) NOT NULL COMMENT '用户自定义数据\r\n',
`return_code` int(1) UNSIGNED NOT NULL COMMENT '订单提交成功',
`transaction_id` varchar(255) NOT NULL COMMENT '微信用户手机显示订单号',
`submitdate` varchar(255) NOT NULL COMMENT '下单时间',
`time_end` varchar(255) NOT NULL COMMENT '支付成功时间',
`openid` varchar(255) NOT NULL COMMENT '用户OPENID标示，本参数没有实际意义，旨在方便用户端区分不同用户',
`mchid` varchar(255) NOT NULL COMMENT 'PAYJS 商户号',
`pay_type` int(1) NOT NULL DEFAULT '0' COMMENT '支付类型。1积分充值2时间充值3购买卡密',
`sign` varchar(255) NOT NULL COMMENT '数据签名',
`pay_log` varchar(255) 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) NOT NULL COMMENT '邀请码',
`cards` varchar(255) NOT NULL COMMENT '激活卡号',
`kami` varchar(255) NOT NULL COMMENT '购买卡密',
`body` varchar(255) NOT NULL COMMENT '支付商品名称',
`texts` text NOT NULL COMMENT '提交参数',
`nums` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '查询次数',
PRIMARY KEY (`id`)
)ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `pre_xinxiu_network_cache` (
`id` BIGINT(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`cache_uid` int(10) UNSIGNED NOT NULL COMMENT '发布uid',
`cache_type` longtext NOT NULL COMMENT '分类',
`cache_key` longtext NOT NULL,
`cache_vlaue` longtext NOT NULL,
`cache_time` int(11) UNSIGNED NOT NULL,
`cache_groupid` longtext NOT NULL COMMENT '用户组',
`cache_credist` longtext NOT NULL COMMENT '积分',
`cache_rule` longtext NOT NULL COMMENT '规则',
`cache_start` int(11) UNSIGNED NOT NULL COMMENT '状态0是开启1是关闭',
`cache_text` longtext NOT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
内容详细，大力支持。
页:
[1]