国产精品爱啪在线线免费观看_97视频精品_欧美精品一区二区在线播放_国产欧美久久一区二区三区

 找回密碼
 立即注冊

QQ登錄

只需一步，快速開始

搜索
查看: 4090|回復: 0

[內(nèi)置擴展] 新秀網(wǎng)絡驗證數(shù)據(jù)庫對照表3.5

[復制鏈接]
1#
發(fā)表于 2024-4-1 07:18:01 | 只看該作者 |倒序瀏覽 |閱讀模式

馬上注冊，結(jié)交更多好友，享用更多功能，讓你輕松玩轉(zhuǎn)社區(qū)

您需要 登錄 才可以下載或查看，沒有賬號？立即注冊

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

--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用戶組設置',
  `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關(guān)閉',
  `islogs` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0開啟1關(guān)閉',
  `snum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '每秒調(diào)用次數(shù)',
  `hnum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1小時內(nèi)最多調(diào)用次數(shù)',
  `dnum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '24小時',
  `nums` bigint(16) UNSIGNED NOT NULL DEFAULT '0' COMMENT '總調(diào)用次數(shù)',
  `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;

--
-- 轉(zhuǎn)存表中的數(shù)據(jù) `pre_xinxiuvip_network_actions`
--

INSERT INTO `pre_xinxiuvip_network_actions` (`id`, `type`, `typekey`, `groups`, `name`, `actions`, `status`, `islogs`, `snum`, `hnum`, `dnum`, `nums`, `zjf`, `kjf`, `do`, `ips`, `url`, `ziduan`, `remarks`, `moment`) VALUES
(1, '初始模塊', NULL, '', '用戶注冊（UC+DISCUZ自動激活）', 'login_register', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-499-1-1.html', '', '', ''),
(2, '初始模塊', NULL, '', '用戶登錄（初始化）', 'login_user', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-498-1-1.html', '', '', ''),
(3, '初始模塊', NULL, '', '卡號登錄（初始化）', 'login_cards', 0, 0, 0, 0, 0, 6, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-538-1-1.html', '', '', ''),
(4, '初始模塊', NULL, '', '獲取軟件配置信息', 'login_config', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-496-1-1.html', '', '', ''),
(5, '初始模塊', NULL, '', '獲取指定用戶信息', 'get_user_info', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-504-1-1.html', '', '', ''),
(6, '初始模塊', NULL, '', '檢測用戶名是否合法', 'user_is_username', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-500-1-1.html', '', '', ''),
(7, '初始模塊', NULL, '', '檢查郵箱是否可注冊', 'user_is_email', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-501-1-1.html', '', '', ''),
(8, '初始模塊', NULL, '', '驗證客戶端md5簽名', 'login_md5', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-505-1-1.html', '', '', ''),
(9, '初始模塊', NULL, '', '獲取服務器當前時間', 'user_times', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-508-1-1.html', '', '', ''),
(10, '初始模塊', NULL, '', '獲取在線人數(shù)', 'login_counts', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-514-1-1.html', '', '', ''),
(11, '用戶模塊', NULL, '', '獲取用戶基本信息(DZ)', 'get_user_info', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-517-1-1.html', '', '', ''),
(12, '用戶模塊', NULL, '', '獲取用戶擴展信息(DZ)', 'user_count', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-518-1-1.html', '', '', ''),
(13, '用戶模塊', NULL, '', '獲取用戶頭像地址(DZ)', 'user_avatar', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-519-1-1.html', '', '', ''),
(14, '用戶模塊', NULL, '', '獲取激活用戶信息（新秀）', 'user_members', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-520-1-1.html', '', '', ''),
(15, '用戶模塊', NULL, '', '修改用戶密碼、郵箱', 'user_edit_password', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-502-1-1.html', '', '', ''),
(16, '用戶模塊', NULL, '', '修改用戶名', 'user_set_name', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-503-1-1.html', '', '', ''),
(17, '用戶模塊', NULL, '', '安全碼驗證、修改', 'user_safe', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-506-1-1.html', '', '', ''),
(18, '用戶模塊', NULL, '', '找回密碼(email)', 'email_set_password', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-507-1-1.html', '', '', ''),
(19, '用戶模塊', NULL, '', '讀取遠程變量(服務器)', 'login_get_globals', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-509-1-1.html', '', '', ''),
(20, '用戶模塊', NULL, '', '機器碼解碼', 'user_del_codes', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-512-1-1.html', '', '', ''),
(21, '用戶模塊', NULL, '', '心跳包(綁定機器碼)', 'user_crons', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-513-1-1.html', '', '', ''),
(22, '用戶模塊', NULL, '', '注銷登錄', 'login_exit', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-515-1-1.html', '', '', ''),
(23, '用戶模塊', NULL, '', '利用安全碼修改密碼', 'safe_set_password', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-516-1-1.html', '', '', ''),
(24, '用戶模塊', NULL, '', '設置私人變量', 'user_set_fields', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-521-1-1.html', '', '', ''),
(25, '用戶模塊', NULL, '', '讀取私人變量', 'user_get_fields', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-522-1-1.html', '', '', ''),
(26, '用戶模塊', NULL, '', '驗證安全碼', 'user_get_safe', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-523-1-1.html', '', '', ''),
(27, '用戶模塊', NULL, '', '免登同步接口', 'send_url', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-533-1-1.html', '', '', ''),
(28, '用戶模塊', NULL, '', 'Cookies轉(zhuǎn)token', 'send_cookies', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-534-1-1.html', '', '', ''),
(29, '積分模塊', NULL, '', '減積分（軟件積分）', 'user_credist', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-527-1-1.html', '', '', ''),
(30, '積分模塊', NULL, '', '增積分（軟件積分）', 'user_credist_add', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-528-1-1.html', '', '', ''),
(31, '充值模塊', NULL, '', '卡密充值', 'card_user', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-535-1-1.html', '', '', ''),
(32, '充值模塊', NULL, '', '卡密查詢', 'card_user', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-536-1-1.html', '', '', ''),
(33, '充值模塊', NULL, '', '卡密充值(DZ卡密)', 'card_credists', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-537-1-1.html', '', '', ''),
(34, '管理模塊', NULL, '', '扣積分(增強版) ', 'user_credists_lower', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-530-1-1.html', '', '', ''),
(35, '管理模塊', NULL, '', '增積分(增強版) ', 'user_credists_add', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-531-1-1.html', '', '', ''),
(36, '管理模塊', NULL, '', '郵件發(fā)送(DZ內(nèi)置) ', 'send_mail', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-532-1-1.html', '', '', ''),
(37, '管理模塊', NULL, '', '設置遠程變量(服務器) ', 'login_set_globals', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-539-1-1.html', '', '', ''),
(38, '初始模塊', NULL, '', '獲取內(nèi)存變量（外部）', 'external', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-540-1-1.html', '', '', '');

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_actions`
--
ALTER TABLE `pre_xinxiuvip_network_actions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `type` (`type`),
  ADD KEY `typekey` (`typekey`),
  ADD KEY `groups` (`groups`),
  ADD KEY `status` (`status`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_actions`
--
ALTER TABLE `pre_xinxiuvip_network_actions`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_actions_logs`
--
ALTER TABLE `pre_xinxiuvip_network_actions_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `time` (`time`),
  ADD KEY `apikey` (`apikey`),
  ADD KEY `isapi` (`isapi`),
  ADD KEY `actions` (`actions`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_actions_logs`
--
ALTER TABLE `pre_xinxiuvip_network_actions_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '發(fā)布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 '規(guī)則',
  `cache_start` int(10) UNSIGNED NOT NULL COMMENT '狀態(tài)0是開啟1是關(guān)閉',
  `cache_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_cache`
--
ALTER TABLE `pre_xinxiuvip_network_cache`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cache_type` (`cache_type`),
  ADD KEY `cache_key` (`cache_key`),
  ADD KEY `cache_uid` (`cache_uid`),
  ADD KEY `cache_groupid` (`cache_groupid`),
  ADD KEY `cache_start` (`cache_start`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_cache`
--
ALTER TABLE `pre_xinxiuvip_network_cache`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id';
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '發(fā)布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 '規(guī)則',
  `cache_start` int(10) UNSIGNED NOT NULL COMMENT '狀態(tài)0是開啟1是關(guān)閉',
  `cache_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_cache_external`
--
ALTER TABLE `pre_xinxiuvip_network_cache_external`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cache_type` (`cache_type`),
  ADD KEY `cache_uid` (`cache_uid`),
  ADD KEY `cache_groupid` (`cache_groupid`),
  ADD KEY `cache_start` (`cache_start`),
  ADD KEY `cache_key` (`cache_key`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_cache_external`
--
ALTER TABLE `pre_xinxiuvip_network_cache_external`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id';
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '自定義參數(shù)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 '訂單狀態(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) 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 '創(chuàng)建時間',
  `up_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時間'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_codepays`
--
ALTER TABLE `pre_xinxiuvip_network_codepays`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pay_uid` (`pay_uid`),
  ADD KEY `pay_id` (`pay_id`),
  ADD KEY `pay_no` (`pay_no`),
  ADD KEY `status` (`status`),
  ADD KEY `codes` (`codes`),
  ADD KEY `codes_2` (`codes`),
  ADD KEY `cards` (`cards`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_codepays`
--
ALTER TABLE `pre_xinxiuvip_network_codepays`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;




--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '內(nèi)容',
  `sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '簽名'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_credits_log`
--
ALTER TABLE `pre_xinxiuvip_network_credits_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `username` (`username`),
  ADD KEY `operation` (`operation`),
  ADD KEY `dateline` (`dateline`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_credits_log`
--
ALTER TABLE `pre_xinxiuvip_network_credits_log`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '日志id';
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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=發(fā)郵件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 '短信內(nèi)容',
  `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;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_email_log`
--
ALTER TABLE `pre_xinxiuvip_network_email_log`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `type` (`type`),
  ADD KEY `dateline` (`dateline`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_email_log`
--
ALTER TABLE `pre_xinxiuvip_network_email_log`
  MODIFY `id` bigint(16) NOT NULL AUTO_INCREMENT;
COMMIT;

--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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='私人變量';

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_fields`
--
ALTER TABLE `pre_xinxiuvip_network_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_fields`
--
ALTER TABLE `pre_xinxiuvip_network_fields`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;





--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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;

--
-- 轉(zhuǎn)存表中的數(shù)據(jù) `pre_xinxiuvip_network_globals`
--

INSERT INTO `pre_xinxiuvip_network_globals` (`id`, `text1`, `text2`, `text3`, `text4`, `text5`, `text6`, `text7`, `text8`, `text9`, `text10`) VALUES
(1, '', '', '', '', '', '', '', '', '', ''),
(2, '', '', '', '', '', '', '', '', '', ''),
(3, '', '', '', '', '', '', '', '', '', ''),
(4, '', '', '', '', '', '', '', '', '', ''),
(5, '', '', '', '', '', '', '', '', '', '');

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_globals`
--
ALTER TABLE `pre_xinxiuvip_network_globals`
  ADD PRIMARY KEY (`id`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_globals`
--
ALTER TABLE `pre_xinxiuvip_network_globals`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '狀態(tài)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 '卡內(nèi)剩余時間',
  `credits` int(10) UNSIGNED NOT NULL COMMENT '卡內(nèi)剩余積分',
  `buycredits` int(10) UNSIGNED NOT NULL COMMENT '剩余交易積分',
  `tokens` int(10) UNSIGNED NOT NULL COMMENT '多開登錄數(shù)量',
  `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;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_kahao`
--
ALTER TABLE `pre_xinxiuvip_network_kahao`
  ADD PRIMARY KEY (`id`),
  ADD KEY `制作者uid` (`makeuid`),
  ADD KEY `用戶uid` (`uid`) USING BTREE,
  ADD KEY `types` (`types`),
  ADD KEY `status` (`status`),
  ADD KEY `typename` (`typename`),
  ADD KEY `sgins` (`sgin`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_kahao`
--
ALTER TABLE `pre_xinxiuvip_network_kahao`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;



--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '狀態(tài)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 '卡內(nèi)剩余時間',
  `credits` int(10) UNSIGNED NOT NULL COMMENT '卡內(nèi)剩余積分',
  `buycredits` int(10) UNSIGNED NOT NULL COMMENT '剩余交易積分',
  `tokens` int(10) UNSIGNED NOT NULL COMMENT '多開登錄數(shù)量',
  `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;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_kami`
--
ALTER TABLE `pre_xinxiuvip_network_kami`
  ADD PRIMARY KEY (`id`),
  ADD KEY `制作者uid` (`makeuid`),
  ADD KEY `用戶uid` (`uid`) USING BTREE,
  ADD KEY `sgin` (`sgin`),
  ADD KEY `types` (`types`),
  ADD KEY `typename` (`typename`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_kami`
--
ALTER TABLE `pre_xinxiuvip_network_kami`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '官網(wǎng)授權(quán)用戶uid',
  `typename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授權(quán)分類',
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '官網(wǎng)授權(quán)用戶名',
  `groupname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授權(quán)用戶組名',
  `groupid` int(10) UNSIGNED NOT NULL COMMENT '授權(quán)用戶組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 '授權(quán)域名',
  `licenses` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授權(quán)碼',
  `states` tinyint(1) UNSIGNED NOT NULL COMMENT '授權(quán)狀態(tài)0正常1禁止	',
  `remarks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_licenses`
--
ALTER TABLE `pre_xinxiuvip_network_licenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `typename` (`typename`),
  ADD KEY `username` (`username`),
  ADD KEY `groupname` (`groupname`),
  ADD KEY `groupid` (`groupid`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_licenses`
--
ALTER TABLE `pre_xinxiuvip_network_licenses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_log`
--
ALTER TABLE `pre_xinxiuvip_network_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `apikey` (`apikey`),
  ADD KEY `isapi` (`isapi`),
  ADD KEY `actions` (`actions`),
  ADD KEY `errcode` (`errcode`),
  ADD KEY `time` (`time`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_log`
--
ALTER TABLE `pre_xinxiuvip_network_log`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;



--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '換綁次數(shù)',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL 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 '激活時間',
  `freezeline` int(10) UNSIGNED NOT NULL COMMENT '凍結(jié)時間',
  `crons` int(10) UNSIGNED NOT NULL COMMENT '心跳包次數(shù)',
  `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;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_members`
--
ALTER TABLE `pre_xinxiuvip_network_members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `email` (`email`),
  ADD KEY `username` (`username`),
  ADD KEY `uid` (`uid`),
  ADD KEY `sgin` (`sgin`),
  ADD KEY `phone` (`phone`),
  ADD KEY `qq` (`qq`),
  ADD KEY `weixin` (`weixin`),
  ADD KEY `safe` (`safe`),
  ADD KEY `groupid` (`groupid`),
  ADD KEY `status` (`status`),
  ADD KEY `code` (`code`),
  ADD KEY `changes` (`changes`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_members`
--
ALTER TABLE `pre_xinxiuvip_network_members`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;



--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '狀態(tài)碼1發(fā)起支付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 '用戶自定義數(shù)據(jù)',
  `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標示，本參數(shù)沒有實際意義，旨在方便用戶端區(qū)分不同用戶',
  `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 '數(shù)據(jù)簽名',
  `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 '提交參數(shù)',
  `nums` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '查詢次數(shù)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_payjss`
--
ALTER TABLE `pre_xinxiuvip_network_payjss`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `status` (`status`),
  ADD KEY `orderid` (`orderid`),
  ADD KEY `payjs_order_id` (`payjs_order_id`),
  ADD KEY `sign` (`sign`),
  ADD KEY `codes` (`codes`),
  ADD KEY `cards` (`cards`),
  ADD KEY `kami` (`kami`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_payjss`
--
ALTER TABLE `pre_xinxiuvip_network_payjss`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '日志id';
COMMIT;



--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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=發(fā)短信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 '短信內(nèi)容',
  `template` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ip地址'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_phone_log`
--
ALTER TABLE `pre_xinxiuvip_network_phone_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `phone` (`phone`),
  ADD KEY `type` (`type`),
  ADD KEY `dateline` (`dateline`),
  ADD KEY `BizId` (`BizId`),
  ADD KEY `RequestId` (`RequestId`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_phone_log`
--
ALTER TABLE `pre_xinxiuvip_network_phone_log`
  MODIFY `id` bigint(16) NOT NULL AUTO_INCREMENT;
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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;

--
-- 轉(zhuǎn)存表中的數(shù)據(jù) `pre_xinxiuvip_network_set`
--

INSERT INTO `pre_xinxiuvip_network_set` (`id`, `text1`, `text2`, `text3`, `text4`, `text5`, `text6`, `text7`, `text8`, `text9`, `text10`, `text11`, `text12`, `text13`, `text14`, `text15`, `text16`, `text17`, `text18`, `text19`, `text20`) VALUES
(1, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(2, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(3, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(4, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(5, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(6, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(7, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(8, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(9, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(10, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_set`
--
ALTER TABLE `pre_xinxiuvip_network_set`
  ADD PRIMARY KEY (`id`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_set`
--
ALTER TABLE `pre_xinxiuvip_network_set`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '卡內(nèi)剩余時間',
  `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 '激活時間'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_sign`
--
ALTER TABLE `pre_xinxiuvip_network_sign`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `makeuid` (`makeuid`),
  ADD KEY `sgin` (`sgin`),
  ADD KEY `typename` (`typename`),
  ADD KEY `type` (`type`),
  ADD KEY `status` (`status`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_sign`
--
ALTER TABLE `pre_xinxiuvip_network_sign`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '卡號規(guī)則',
  `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 '購買數(shù)量'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_sign_log`
--
ALTER TABLE `pre_xinxiuvip_network_sign_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `price` (`price`),
  ADD KEY `dateline` (`dateline`),
  ADD KEY `extcreditskey` (`extcreditskey`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_sign_log`
--
ALTER TABLE `pre_xinxiuvip_network_sign_log`
  MODIFY `id` bigint(16) NOT NULL AUTO_INCREMENT;
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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 '提現(xiàn)備注',
  `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;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_tixian`
--
ALTER TABLE `pre_xinxiuvip_network_tixian`
  ADD PRIMARY KEY (`id`),
  ADD KEY `typeid` (`typeid`),
  ADD KEY `makeruid` (`makeruid`),
  ADD KEY `extcreditskey` (`extcreditskey`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_tixian`
--
ALTER TABLE `pre_xinxiuvip_network_tixian`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '訂單id';
COMMIT;


--
-- 數(shù)據(jù)庫： `demo35_xinxiuvip`
--

-- --------------------------------------------------------

--
-- 表的結(jié)構(gòu) `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數(shù)組',
  `tnum` int(10) UNSIGNED DEFAULT '0' COMMENT '被踢下線次數(shù)',
  `lastactivity` int(10) UNSIGNED DEFAULT NULL COMMENT '最后活動時間',
  `loginint` int(10) UNSIGNED NOT NULL COMMENT '登錄次數(shù)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 轉(zhuǎn)儲表的索引
--

--
-- 表的索引 `pre_xinxiuvip_network_token`
--
ALTER TABLE `pre_xinxiuvip_network_token`
  ADD PRIMARY KEY (`id`),
  ADD KEY `uid` (`uid`),
  ADD KEY `username` (`username`),
  ADD KEY `groupid` (`groupid`),
  ADD KEY `adminid` (`adminid`),
  ADD KEY `username_2` (`username`);

--
-- 在導出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `pre_xinxiuvip_network_token`
--
ALTER TABLE `pre_xinxiuvip_network_token`
  MODIFY `id` bigint(16) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;



?>

帖子永久地址： 

新秀網(wǎng)絡驗證系統(tǒng) - 論壇版權(quán)1、本主題所有言論和圖片純屬會員個人意見，與本論壇立場無關(guān)
2、本站所有主題由該帖子作者發(fā)表，該帖子作者與新秀網(wǎng)絡驗證系統(tǒng)享有帖子相關(guān)版權(quán)
3、其他單位或個人使用、轉(zhuǎn)載或引用本文時必須同時征得該帖子作者和新秀網(wǎng)絡驗證系統(tǒng)的同意
4、帖子作者須承擔一切因本文發(fā)表而直接或間接導致的民事或刑事法律責任
5、本帖部分內(nèi)容轉(zhuǎn)載自其它媒體，但并不代表本站贊同其觀點和對其真實性負責
6、如本帖侵犯到任何版權(quán)問題，請立即告知本站，本站將及時予與刪除并致以最深的歉意
7、新秀網(wǎng)絡驗證系統(tǒng)管理員和版主有權(quán)不事先通知發(fā)貼者而刪除本文
您需要登錄后才可以回帖 登錄 | 立即注冊

本版積分規(guī)則

QQ|Archiver|手機版|新秀網(wǎng)絡驗證系統(tǒng)API[軟著登字第13061951號] ( 豫ICP備2021033257號-1 )

GMT+8, 2025-7-1 18:39 , Processed in 0.202981 second(s), 43 queries , Redis On.

Powered by Discuz! X3.5 Licensed

© 2001-2025 Discuz! Team.

快速回復 返回頂部 返回列表