新秀網(wǎng)絡驗證數(shù)據(jù)庫對照表 ver6.6

admin

版本升級過程中，如遇到字段缺失，請對照下表進行添加。有需求二次開發(fā)的可按此數(shù)據(jù)庫進行調用。

[PHP] 純文本查看 復制代碼

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 '每秒調用次數(shù)',
  `hnum` int(10) NOT NULL DEFAULT '0' COMMENT '1小時內最多調用次數(shù)',
  `dnum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '24小時',
  `nums` bigint(16) NOT NULL COMMENT '總調用次數(shù)',
  `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 '換綁次數(shù)',
  `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 '多開登錄數(shù)量',
  `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 '心跳包次數(shù)',
  `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 '提現(xiàn)備注',
  `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數(shù)組',
  `tnum` int(10) unsigned DEFAULT '0' COMMENT '被踢下線次數(shù)',
  `lastactivity` int(10) unsigned DEFAULT NULL COMMENT '最后活動時間',
  `loginint` int(10) unsigned NOT NULL COMMENT '登錄次數(shù)',
  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=發(fā)短信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 '回執(zhí)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=發(fā)郵件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 '回執(zhí)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 '自定義參數(shù)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 '訂單狀態(tài)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 '創(chuàng)建時間',
  `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 '多開登錄數(shù)量',
  `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 '卡號規(guī)則',
  `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 '購買數(shù)量',
  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 '狀態(tài)碼1發(fā)起支付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 '用戶自定義數(shù)據(jù)\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標示，本參數(shù)沒有實際意義，旨在方便用戶端區(qū)分不同用戶',
  `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 '數(shù)據(jù)簽名',
  `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 '提交參數(shù)',
  `nums` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '查詢次數(shù)',
   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 '發(fā)布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 '規(guī)則',
  `cache_start` int(11) UNSIGNED NOT NULL COMMENT '狀態(tài)0是開啟1是關閉',
  `cache_text` longtext NOT NULL COMMENT '備注',
   PRIMARY KEY (`id`)
) ENGINE=MyISAM;

halifax

內容詳細，大力支持。