[PHP] 純文本查看 復制代碼
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_actions`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_actions`;
CREATE TABLE `pre_xinxiuvip_network_actions` (
`id` bigint(16) UNSIGNED NOT NULL,
`type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`typekey` int(10) UNSIGNED DEFAULT NULL COMMENT '0key1管理key',
`groups` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用戶組設置',
`extcredits` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'extcredits積分類型',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`actions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接口方法',
`status` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0打開1關閉',
`islogs` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0開啟1關閉',
`snum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '每秒調用次數',
`hnum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '1小時內最多調用次數',
`dnum` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '24小時',
`nums` bigint(16) UNSIGNED NOT NULL DEFAULT '0' COMMENT '總調用次數',
`zjf` int(10) UNSIGNED DEFAULT NULL COMMENT '增積分',
`kjf` int(10) UNSIGNED DEFAULT NULL COMMENT '減積分',
`do` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0不處理、1踢下線、2封號、3封IP',
`ips` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'IP黑名單',
`url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`ziduan` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '返回字段',
`remarks` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注',
`moment` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '臨時存儲'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉存表中的數據 `pre_xinxiuvip_network_actions`
--
INSERT INTO `pre_xinxiuvip_network_actions` (`id`, `type`, `typekey`, `groups`, `extcredits`, `name`, `actions`, `status`, `islogs`, `snum`, `hnum`, `dnum`, `nums`, `zjf`, `kjf`, `do`, `ips`, `url`, `ziduan`, `remarks`, `moment`) VALUES
(1, '初始模塊', NULL, '', 0, '用戶注冊（UC+DISCUZ自動激活）', 'login_register', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-499-1-1.html', '', '', ''),
(2, '初始模塊', NULL, '', 0, '用戶登錄（初始化）', 'login_user', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-498-1-1.html', '', '', ''),
(3, '初始模塊', NULL, '', 0, '卡號登錄（初始化）', 'login_cards', 0, 0, 0, 0, 0, 6, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-538-1-1.html', '', '', ''),
(4, '初始模塊', NULL, '', 0, '獲取軟件配置信息', 'login_config', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-496-1-1.html', '', '', ''),
(5, '初始模塊', NULL, '', 0, '獲取指定用戶信息', 'get_user_info', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-504-1-1.html', '', '', ''),
(6, '初始模塊', NULL, '', 0, '檢測用戶名是否合法', 'user_is_username', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-500-1-1.html', '', '', ''),
(7, '初始模塊', NULL, '', 0, '檢查郵箱是否可注冊', 'user_is_email', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-501-1-1.html', '', '', ''),
(8, '初始模塊', NULL, '', 0, '驗證客戶端md5簽名', 'login_md5', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-505-1-1.html', '', '', ''),
(9, '初始模塊', NULL, '', 0, '獲取服務器當前時間', 'user_times', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-508-1-1.html', '', '', ''),
(10, '初始模塊', NULL, '', 0, '獲取在線人數', 'login_counts', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-514-1-1.html', '', '', ''),
(11, '用戶模塊', NULL, '', 0, '獲取用戶基本信息(DZ)', 'get_user_info', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-517-1-1.html', '', '', ''),
(12, '用戶模塊', NULL, '', 0, '獲取用戶擴展信息(DZ)', 'user_count', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-518-1-1.html', '', '', ''),
(13, '用戶模塊', NULL, '', 0, '獲取用戶頭像地址(DZ)', 'user_avatar', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-519-1-1.html', '', '', ''),
(14, '用戶模塊', NULL, '', 0, '獲取激活用戶信息（新秀）', 'user_members', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-520-1-1.html', '', '', ''),
(15, '用戶模塊', NULL, '', 0, '修改用戶密碼、郵箱', 'user_edit_password', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-502-1-1.html', '', '', ''),
(16, '用戶模塊', NULL, '', 0, '修改用戶名', 'user_set_name', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-503-1-1.html', '', '', ''),
(17, '用戶模塊', NULL, '', 0, '安全碼驗證、修改', 'user_safe', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-506-1-1.html', '', '', ''),
(18, '用戶模塊', NULL, '', 0, '找回密碼(email)', 'email_set_password', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-507-1-1.html', '', '', ''),
(19, '用戶模塊', NULL, '', 0, '讀取遠程變量(服務器)', 'login_get_globals', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-509-1-1.html', '', '', ''),
(20, '用戶模塊', NULL, '', 0, '機器碼解碼', 'user_del_codes', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-512-1-1.html', '', '', ''),
(21, '用戶模塊', NULL, '', 0, '心跳包(綁定機器碼)', 'user_crons', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-513-1-1.html', '', '', ''),
(22, '用戶模塊', NULL, '', 0, '注銷登錄', 'login_exit', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-515-1-1.html', '', '', ''),
(23, '用戶模塊', NULL, '', 0, '利用安全碼修改密碼', 'safe_set_password', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-516-1-1.html', '', '', ''),
(24, '用戶模塊', NULL, '', 0, '設置私人變量', 'user_set_fields', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-521-1-1.html', '', '', ''),
(25, '用戶模塊', NULL, '', 0, '讀取私人變量', 'user_get_fields', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-522-1-1.html', '', '', ''),
(26, '用戶模塊', NULL, '', 0, '驗證安全碼', 'user_get_safe', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-523-1-1.html', '', '', ''),
(27, '用戶模塊', NULL, '', 0, '免登同步接口', 'send_url', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-533-1-1.html', '', '', ''),
(28, '用戶模塊', NULL, '', 0, 'Cookies轉token', 'send_cookies', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-534-1-1.html', '', '', ''),
(29, '積分模塊', NULL, '', 0, '減積分（軟件積分）', 'user_credist', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-527-1-1.html', '', '', ''),
(30, '積分模塊', NULL, '', 0, '增積分（軟件積分）', 'user_credist_add', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-528-1-1.html', '', '', ''),
(31, '充值模塊', NULL, '', 0, '卡密充值', 'card_user', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-535-1-1.html', '', '', ''),
(32, '充值模塊', NULL, '', 0, '卡密查詢', 'card_user', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-536-1-1.html', '', '', ''),
(33, '充值模塊', NULL, '', 0, '卡密充值(DZ卡密)', 'card_credists', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-537-1-1.html', '', '', ''),
(34, '管理模塊', NULL, '', 0, '扣積分(增強版) ', 'user_credists_lower', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-530-1-1.html', '', '', ''),
(35, '管理模塊', NULL, '', 0, '增積分(增強版) ', 'user_credists_add', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-531-1-1.html', '', '', ''),
(36, '管理模塊', NULL, '', 0, '郵件發送(DZ內置) ', 'send_mail', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-532-1-1.html', '', '', ''),
(37, '管理模塊', NULL, '', 0, '設置遠程變量(服務器) ', 'login_set_globals', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/thread-539-1-1.html', '', '', ''),
(38, '初始模塊', NULL, '', 0, '獲取內存變量（外部）', 'external', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'http://www.5566wy.com/thread-540-1-1.html', '', '', ''),
(40, '管理模塊', NULL, '', 0, '刪除會員', 'del_member', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/forum.php?mod=viewthread&tid=632', '', '', ''),
(41, '管理模塊', NULL, '', 0, '刪除主題', 'del_thread', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/forum.php?mod=viewthread&tid=631', '', '', ''),
(42, '管理模塊', NULL, '', 0, '刪除帖子', 'del_post', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/forum.php?mod=viewthread&tid=630', '', '', ''),
(43, '管理模塊', NULL, '', 0, '發送系統通知', 'send_notice', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/forum.php?mod=viewthread&tid=633', '', '', ''),
(44, '管理模塊', NULL, '', 0, '獲取未讀系統通知', 'notice_checknew', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.5566wy.com/forum.php?mod=viewthread&tid=634', '', '', '');
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_actions`
--
ALTER TABLE `pre_xinxiuvip_network_actions`
ADD PRIMARY KEY (`id`),
ADD KEY `type` (`type`),
ADD KEY `typekey` (`typekey`),
ADD KEY `status` (`status`),
ADD KEY `actions` (`actions`);
--
-- 在導出的表使用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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_actions_logs`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_actions_logs`;
CREATE TABLE `pre_xinxiuvip_network_actions_logs` (
`id` bigint(20) UNSIGNED NOT NULL,
`uid` bigint(20) UNSIGNED NOT NULL COMMENT '用戶uid',
`apikey` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '傳輸密鑰或管理密鑰',
`isapi` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`actions` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`errcode` int(3) UNSIGNED NOT NULL,
`isget` text COLLATE utf8mb4_unicode_ci NOT NULL,
`ispost` text COLLATE utf8mb4_unicode_ci NOT NULL,
`time` int(10) UNSIGNED NOT NULL,
`fromip` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
`output` longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_cache`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_cache`;
CREATE TABLE `pre_xinxiuvip_network_cache` (
`id` bigint(16) UNSIGNED NOT NULL COMMENT 'id',
`cache_uid` int(10) UNSIGNED NOT NULL COMMENT '發布uid',
`cache_uids` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用戶uids',
`cache_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分類',
`cache_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '緩存密鑰',
`cache_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '緩存值',
`cache_time` int(10) UNSIGNED NOT NULL COMMENT '緩存時間',
`cahe_time_old` int(10) UNSIGNED NOT NULL COMMENT '到期時間',
`cache_groupid` int(10) UNSIGNED NOT NULL COMMENT '用戶組',
`cache_groupids` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用戶組ids',
`cache_credist` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '積分',
`cache_rule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '規則',
`cache_start` int(10) UNSIGNED NOT NULL COMMENT '狀態0是開啟1是關閉',
`cache_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_cache`
--
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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_cache_external`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_cache_external`;
CREATE TABLE `pre_xinxiuvip_network_cache_external` (
`id` bigint(16) UNSIGNED NOT NULL COMMENT 'id',
`cache_uid` int(10) UNSIGNED NOT NULL COMMENT '發布uid',
`cache_uids` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'uids',
`cache_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分類',
`cache_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '緩存密鑰',
`cache_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '緩存值',
`cache_time` int(10) UNSIGNED NOT NULL COMMENT '緩存時間',
`cahe_time_old` int(10) UNSIGNED NOT NULL COMMENT '到期時間',
`cache_groupid` int(10) UNSIGNED NOT NULL COMMENT '用戶組',
`cache_groupids` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用戶組ids',
`cache_credist` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '積分',
`cache_rule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '規則',
`cache_start` int(10) UNSIGNED NOT NULL COMMENT '狀態0是開啟1是關閉',
`cache_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_codepays`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_codepays`;
CREATE TABLE `pre_xinxiuvip_network_codepays` (
`id` bigint(16) UNSIGNED NOT NULL,
`pay_uid` int(11) UNSIGNED NOT NULL COMMENT '用戶uid',
`pay_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用戶ID或訂單ID',
`money` decimal(6,2) UNSIGNED NOT NULL COMMENT '實際金額',
`price` decimal(6,2) UNSIGNED NOT NULL COMMENT '原價',
`type` int(1) NOT NULL DEFAULT '1' COMMENT '支付方式',
`pay_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '流水號',
`param` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定義參數1為時間充值，其他都是積分',
`pay_time` bigint(11) NOT NULL DEFAULT '0' COMMENT '付款時間',
`pay_tag` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '金額的備注',
`status` int(1) NOT NULL DEFAULT '0' COMMENT '訂單狀態0失敗1成功',
`creditskey` int(1) UNSIGNED NOT NULL COMMENT '充值積分類型',
`creditsval` int(11) UNSIGNED NOT NULL COMMENT '充值積分值',
`signtime` int(11) UNSIGNED NOT NULL COMMENT '充值卡號時間',
`codes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邀請碼',
`cards` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '激活卡號',
`creat_time` bigint(11) NOT NULL DEFAULT '0' COMMENT '創建時間',
`up_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新時間'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_credits_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_credits_log`;
CREATE TABLE `pre_xinxiuvip_network_credits_log` (
`id` bigint(16) UNSIGNED NOT NULL COMMENT '日志id',
`uid` bigint(16) UNSIGNED NOT NULL DEFAULT '0' COMMENT '所屬用戶uid',
`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`operation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作類型',
`relatedid` int(10) UNSIGNED NOT NULL COMMENT '操作處理類型',
`dateline` int(10) UNSIGNED NOT NULL COMMENT '記錄時間',
`extcredits1` int(10) NOT NULL,
`extcredits2` int(10) NOT NULL,
`extcredits3` int(10) NOT NULL,
`extcredits4` int(10) NOT NULL,
`extcredits5` int(10) NOT NULL,
`extcredits6` int(10) NOT NULL,
`extcredits7` int(10) NOT NULL,
`extcredits8` int(10) NOT NULL,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '標題',
`text` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '內容',
`sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '簽名'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_email_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_email_log`;
CREATE TABLE `pre_xinxiuvip_network_email_log` (
`id` bigint(16) NOT NULL,
`type` int(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0=驗證碼1=發郵件2=登錄',
`email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '郵箱地址',
`code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '驗證碼',
`content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信內容',
`template` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信模版',
`dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
`oldtime` int(10) UNSIGNED NOT NULL COMMENT '過期時間',
`ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ip地址'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_fields`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_fields`;
CREATE TABLE `pre_xinxiuvip_network_fields` (
`id` bigint(16) UNSIGNED NOT NULL,
`uid` bigint(16) UNSIGNED NOT NULL,
`text1` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text2` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text3` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text4` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text5` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text6` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text7` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text8` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text9` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text10` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text11` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text12` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text13` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text14` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text15` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text16` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text17` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text18` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text19` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text20` longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='私人變量';
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_globals`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_globals`;
CREATE TABLE `pre_xinxiuvip_network_globals` (
`id` bigint(16) UNSIGNED NOT NULL,
`text1` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text2` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text3` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text4` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text5` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text6` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text7` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text8` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text9` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text10` longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉存表中的數據 `pre_xinxiuvip_network_globals`
--
INSERT INTO `pre_xinxiuvip_network_globals` (`id`, `text1`, `text2`, `text3`, `text4`, `text5`, `text6`, `text7`, `text8`, `text9`, `text10`) VALUES
(1, '', '', '', '', '', '', '', '', '', ''),
(2, '', '', '', '', '', '', '', '', '', ''),
(3, '', '', '', '', '', '', '', '', '', ''),
(4, '', '', '', '', '', '', '', '', '', ''),
(5, '', '', '', '', '', '', '', '', '', '');
--
-- 轉儲表的索引
--
--
-- 表的索引 `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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_kahao`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_kahao`;
CREATE TABLE `pre_xinxiuvip_network_kahao` (
`id` bigint(20) UNSIGNED NOT NULL,
`uid` bigint(20) UNSIGNED NOT NULL COMMENT '用戶uid',
`makeuid` bigint(20) UNSIGNED NOT NULL COMMENT '制卡者uid',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '狀態0正常1禁止',
`sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '固定卡號',
`types` tinyint(1) UNSIGNED NOT NULL COMMENT '卡號是否激活0為未激活1為激活',
`price` int(10) UNSIGNED NOT NULL COMMENT '面值',
`typename` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '卡號分類',
`sgintime` int(10) UNSIGNED NOT NULL COMMENT '卡內剩余時間',
`credits` int(10) UNSIGNED NOT NULL COMMENT '卡內剩余積分',
`buycredits` int(10) UNSIGNED NOT NULL COMMENT '剩余交易積分',
`tokens` int(10) UNSIGNED NOT NULL COMMENT '多開登錄數量',
`dateline` int(10) UNSIGNED NOT NULL COMMENT '卡號制作時間',
`clearline` int(10) UNSIGNED NOT NULL COMMENT '卡號激活時間',
`moment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '臨時存儲',
`remarks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_kami`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_kami`;
CREATE TABLE `pre_xinxiuvip_network_kami` (
`id` bigint(20) UNSIGNED NOT NULL,
`uid` bigint(20) UNSIGNED NOT NULL COMMENT '用戶uid',
`makeuid` bigint(20) UNSIGNED NOT NULL COMMENT '制卡者uid',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '狀態0正常1禁止',
`sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '固定卡密',
`types` tinyint(1) UNSIGNED NOT NULL COMMENT '卡密是否激活0為未激活1為激活',
`price` int(10) UNSIGNED NOT NULL COMMENT '面值',
`typename` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '卡密分類',
`sgintime` int(10) UNSIGNED NOT NULL COMMENT '卡內剩余時間',
`credits` int(10) UNSIGNED NOT NULL COMMENT '卡內剩余積分',
`buycredits` int(10) UNSIGNED NOT NULL COMMENT '剩余交易積分',
`tokens` int(10) UNSIGNED NOT NULL COMMENT '多開登錄數量',
`dateline` int(10) UNSIGNED NOT NULL COMMENT '卡密制作時間',
`clearline` int(10) UNSIGNED NOT NULL COMMENT '卡密激活時間',
`moment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '臨時存儲',
`remarks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_licenses`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_licenses`;
CREATE TABLE `pre_xinxiuvip_network_licenses` (
`id` bigint(20) UNSIGNED NOT NULL,
`uid` bigint(20) UNSIGNED NOT NULL COMMENT '官網授權用戶uid',
`typename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授權分類',
`username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '官網授權用戶名',
`groupname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授權用戶組名',
`groupid` int(10) UNSIGNED NOT NULL COMMENT '授權用戶組id',
`datetime` int(10) UNSIGNED NOT NULL COMMENT '到期時間',
`updatetime` int(10) UNSIGNED NOT NULL COMMENT '更新時間',
`domain` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授權域名',
`licenses` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '授權碼',
`states` tinyint(1) UNSIGNED NOT NULL COMMENT '授權狀態0正常1禁止 ',
`remarks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_log`;
CREATE TABLE `pre_xinxiuvip_network_log` (
`id` bigint(16) UNSIGNED NOT NULL,
`uid` smallint(5) UNSIGNED NOT NULL,
`apikey` char(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`isapi` char(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`actions` char(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`errcode` int(3) UNSIGNED DEFAULT NULL,
`isget` text COLLATE utf8mb4_unicode_ci,
`ispost` text COLLATE utf8mb4_unicode_ci,
`time` int(10) UNSIGNED DEFAULT NULL,
`fromip` char(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`output` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_members`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_members`;
CREATE TABLE `pre_xinxiuvip_network_members` (
`id` bigint(16) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL COMMENT '綁定用戶',
`username` char(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '綁定用戶名',
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`grouptitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '當前用戶組名',
`sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '固定卡號',
`status` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0正常1禁止',
`changes` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '換綁次數',
`code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '機器碼綁定',
`inttoken` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '多開登錄數量',
`dateline` int(10) UNSIGNED NOT NULL COMMENT '卡號過期時間',
`groupid` int(10) UNSIGNED NOT NULL COMMENT '當前用戶組id',
`groupline` int(10) UNSIGNED NOT NULL COMMENT '用戶組過期時間',
`clearline` int(10) UNSIGNED NOT NULL COMMENT '激活時間',
`freezeline` int(10) UNSIGNED NOT NULL COMMENT '凍結時間',
`crons` int(10) UNSIGNED NOT NULL COMMENT '心跳包次數',
`phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手機號',
`qq` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'QQopenid',
`weixin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信綁定id',
`douyin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '抖音綁定id',
`safe` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '安全碼',
`logincard` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '登錄密保卡',
`remarks` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注',
`moment` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '臨時存儲'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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 `douyin` (`douyin`),
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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_payjss`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_payjss`;
CREATE TABLE `pre_xinxiuvip_network_payjss` (
`id` bigint(16) UNSIGNED NOT NULL COMMENT '日志id',
`uid` bigint(16) UNSIGNED NOT NULL COMMENT '用戶uid',
`status` int(1) UNSIGNED NOT NULL COMMENT '狀態碼1發起支付2已支付',
`orderid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用戶生成的訂單號原樣返回',
`price` int(16) UNSIGNED NOT NULL COMMENT '支付金額元',
`ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ip',
`types` int(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '充值類型1為微信2為支付寶3其他',
`payjs_order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'PAYJS 平臺訂單號',
`attach` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用戶自定義數據',
`return_code` int(1) UNSIGNED NOT NULL COMMENT '訂單提交成功',
`transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信用戶手機顯示訂單號',
`submitdate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '下單時間',
`time_end` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '支付成功時間',
`openid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用戶OPENID標示，本參數沒有實際意義，旨在方便用戶端區分不同用戶',
`mchid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'PAYJS 商戶號',
`pay_type` int(1) NOT NULL DEFAULT '0' COMMENT '支付類型。1積分充值2時間充值3購買卡密',
`sign` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '數據簽名',
`pay_log` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '充值備注',
`creditskey` int(1) UNSIGNED NOT NULL COMMENT '充值積分類型',
`creditsval` int(11) UNSIGNED NOT NULL COMMENT '充值積分值',
`signtime` int(11) UNSIGNED NOT NULL COMMENT '充值卡號時間',
`codes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '邀請碼',
`cards` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '激活卡號',
`kami` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '購買卡密',
`body` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '支付商品名稱',
`texts` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '提交參數',
`nums` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '查詢次數'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_phone_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_phone_log`;
CREATE TABLE `pre_xinxiuvip_network_phone_log` (
`id` bigint(16) NOT NULL,
`type` int(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0=驗證碼1=發短信2=登錄',
`phone` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '手機號',
`code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '驗證碼',
`content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信內容',
`template` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '短信模版',
`BizId` int(10) UNSIGNED NOT NULL COMMENT '回執ID',
`RequestId` int(10) UNSIGNED NOT NULL COMMENT '請求id',
`dateline` int(10) UNSIGNED NOT NULL DEFAULT '0',
`oldtime` int(10) UNSIGNED NOT NULL COMMENT '過期時間',
`ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'ip地址'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_set`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_set`;
CREATE TABLE `pre_xinxiuvip_network_set` (
`id` bigint(16) UNSIGNED NOT NULL,
`text1` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text2` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text3` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text4` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text5` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text6` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text7` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text8` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text9` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text10` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text11` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text12` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text13` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text14` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text15` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text16` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text17` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text18` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text19` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`text20` longtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉存表中的數據 `pre_xinxiuvip_network_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, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
--
-- 轉儲表的索引
--
--
-- 表的索引 `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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_sign`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_sign`;
CREATE TABLE `pre_xinxiuvip_network_sign` (
`id` bigint(16) UNSIGNED NOT NULL,
`uid` int(10) UNSIGNED NOT NULL COMMENT '綁定用戶',
`makeuid` int(10) UNSIGNED NOT NULL COMMENT '制卡代理uid',
`type` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0未激活1激活',
`sgin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '固定卡密',
`price` int(10) UNSIGNED NOT NULL COMMENT '面值',
`typename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '默認分類' COMMENT '分類',
`status` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0正常1鎖定',
`times` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '卡內剩余時間',
`credits` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '剩余積分',
`buycredits` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '剩余交易積分',
`inttoken` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '多開登錄數量',
`dateline` int(10) UNSIGNED NOT NULL COMMENT '制作時間',
`clearline` int(10) UNSIGNED NOT NULL COMMENT '激活時間'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_sign`
--
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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_sign_log`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_sign_log`;
CREATE TABLE `pre_xinxiuvip_network_sign_log` (
`id` bigint(16) NOT NULL,
`uid` mediumint(8) NOT NULL DEFAULT '0' COMMENT '提卡uid',
`price` int(10) UNSIGNED NOT NULL COMMENT '面值',
`cardrule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '卡號規則',
`extcreditskey` int(10) UNSIGNED NOT NULL COMMENT '積分類型',
`extcreditsval` int(10) UNSIGNED NOT NULL COMMENT '積分值',
`info` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '備注信息',
`dateline` int(10) NOT NULL DEFAULT '0' COMMENT '操作日期',
`description` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '提卡類型',
`num` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '購買數量'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_tixian`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_tixian`;
CREATE TABLE `pre_xinxiuvip_network_tixian` (
`id` bigint(16) UNSIGNED NOT NULL COMMENT '訂單id',
`typeid` smallint(6) UNSIGNED NOT NULL DEFAULT '1' COMMENT '分類id',
`maketype` tinyint(1) NOT NULL DEFAULT '0' COMMENT '提交方法',
`makeruid` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT '提交uid',
`price` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT '交易面值',
`extcreditskey` tinyint(1) NOT NULL DEFAULT '0' COMMENT '積分種類',
`extcreditsval` int(10) NOT NULL DEFAULT '0' COMMENT '積分值',
`status` tinyint(1) UNSIGNED NOT NULL COMMENT '交易動作',
`uiddate` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '提交時間',
`uidtext` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '提現備注',
`alipay` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '支付寶',
`weixin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '微信',
`admindateline` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '交易時間',
`admintext` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '處理備注'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `pre_xinxiuvip_network_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;
--
-- 數據庫： `demo35_xinxiuvip`
--
-- --------------------------------------------------------
--
-- 表的結構 `pre_xinxiuvip_network_token`
--
DROP TABLE IF EXISTS `pre_xinxiuvip_network_token`;
CREATE TABLE `pre_xinxiuvip_network_token` (
`id` bigint(16) UNSIGNED NOT NULL,
`uid` mediumint(8) UNSIGNED DEFAULT NULL,
`username` char(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'IP地址',
`groupid` tinyint(3) UNSIGNED DEFAULT NULL COMMENT '會員組id',
`adminid` tinyint(3) UNSIGNED DEFAULT NULL COMMENT '管理組id',
`token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '驗證token',
`tokens` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'tokens數組',
`tnum` int(10) UNSIGNED DEFAULT '0' COMMENT '被踢下線次數',
`lastactivity` int(10) UNSIGNED DEFAULT NULL COMMENT '最后活動時間',
`loginint` int(10) UNSIGNED NOT NULL COMMENT '登錄次數'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- 轉儲表的索引
--
--
-- 表的索引 `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;