[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 '每秒調用次數',
`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;