新秀网络验证数据库对照表X3.5 - ver2.0

admin · 发表于 2024-9-10 18:05:57

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区

您需要登录才可以下载或查看，没有账号？立即注册

×

数据库有问题的，可以直接复制代码，执行SQL代码，全部清空所有表，重新创建新表。

[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.xinxiuvip.com/thread-499-1-1.html', '', '', ''),
(2, '初始模块', NULL, '', 0, '用户登录（初始化）', 'login_user', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-498-1-1.html', '', '', ''),
(3, '初始模块', NULL, '', 0, '卡号登录（初始化）', 'login_cards', 0, 0, 0, 0, 0, 6, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-538-1-1.html', '', '', ''),
(4, '初始模块', NULL, '', 0, '获取软件配置信息', 'login_config', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-496-1-1.html', '', '', ''),
(5, '初始模块', NULL, '', 0, '获取指定用户信息', 'get_user_info', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-504-1-1.html', '', '', ''),
(6, '初始模块', NULL, '', 0, '检测用户名是否合法', 'user_is_username', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-500-1-1.html', '', '', ''),
(7, '初始模块', NULL, '', 0, '检查邮箱是否可注册', 'user_is_email', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-501-1-1.html', '', '', ''),
(8, '初始模块', NULL, '', 0, '验证客户端md5签名', 'login_md5', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-505-1-1.html', '', '', ''),
(9, '初始模块', NULL, '', 0, '获取服务器当前时间', 'user_times', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-508-1-1.html', '', '', ''),
(10, '初始模块', NULL, '', 0, '获取在线人数', 'login_counts', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-514-1-1.html', '', '', ''),
(11, '用户模块', NULL, '', 0, '获取用户基本信息(DZ)', 'get_user_info', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-517-1-1.html', '', '', ''),
(12, '用户模块', NULL, '', 0, '获取用户扩展信息(DZ)', 'user_count', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-518-1-1.html', '', '', ''),
(13, '用户模块', NULL, '', 0, '获取用户头像地址(DZ)', 'user_avatar', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-519-1-1.html', '', '', ''),
(14, '用户模块', NULL, '', 0, '获取激活用户信息（新秀）', 'user_members', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-520-1-1.html', '', '', ''),
(15, '用户模块', NULL, '', 0, '修改用户密码、邮箱', 'user_edit_password', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-502-1-1.html', '', '', ''),
(16, '用户模块', NULL, '', 0, '修改用户名', 'user_set_name', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-503-1-1.html', '', '', ''),
(17, '用户模块', NULL, '', 0, '安全码验证、修改', 'user_safe', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-506-1-1.html', '', '', ''),
(18, '用户模块', NULL, '', 0, '找回密码(email)', 'email_set_password', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-507-1-1.html', '', '', ''),
(19, '用户模块', NULL, '', 0, '读取远程变量(服务器)', 'login_get_globals', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-509-1-1.html', '', '', ''),
(20, '用户模块', NULL, '', 0, '机器码解码', 'user_del_codes', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-512-1-1.html', '', '', ''),
(21, '用户模块', NULL, '', 0, '心跳包(绑定机器码)', 'user_crons', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-513-1-1.html', '', '', ''),
(22, '用户模块', NULL, '', 0, '注销登录', 'login_exit', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-515-1-1.html', '', '', ''),
(23, '用户模块', NULL, '', 0, '利用安全码修改密码', 'safe_set_password', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-516-1-1.html', '', '', ''),
(24, '用户模块', NULL, '', 0, '设置私人变量', 'user_set_fields', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-521-1-1.html', '', '', ''),
(25, '用户模块', NULL, '', 0, '读取私人变量', 'user_get_fields', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-522-1-1.html', '', '', ''),
(26, '用户模块', NULL, '', 0, '验证安全码', 'user_get_safe', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-523-1-1.html', '', '', ''),
(27, '用户模块', NULL, '', 0, '免登同步接口', 'send_url', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-533-1-1.html', '', '', ''),
(28, '用户模块', NULL, '', 0, 'Cookies转token', 'send_cookies', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-534-1-1.html', '', '', ''),
(29, '积分模块', NULL, '', 0, '减积分（软件积分）', 'user_credist', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-527-1-1.html', '', '', ''),
(30, '积分模块', NULL, '', 0, '增积分（软件积分）', 'user_credist_add', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-528-1-1.html', '', '', ''),
(31, '充值模块', NULL, '', 0, '卡密充值', 'card_user', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-535-1-1.html', '', '', ''),
(32, '充值模块', NULL, '', 0, '卡密查询', 'card_user', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-536-1-1.html', '', '', ''),
(33, '充值模块', NULL, '', 0, '卡密充值(DZ卡密)', 'card_credists', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-537-1-1.html', '', '', ''),
(34, '管理模块', NULL, '', 0, '扣积分(增强版) ', 'user_credists_lower', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-530-1-1.html', '', '', ''),
(35, '管理模块', NULL, '', 0, '增积分(增强版) ', 'user_credists_add', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-531-1-1.html', '', '', ''),
(36, '管理模块', NULL, '', 0, '邮件发送(DZ内置) ', 'send_mail', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-532-1-1.html', '', '', ''),
(37, '管理模块', NULL, '', 0, '设置远程变量(服务器) ', 'login_set_globals', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/thread-539-1-1.html', '', '', ''),
(38, '初始模块', NULL, '', 0, '获取内存变量（外部）', 'external', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 'http://www.xinxiuvip.com/thread-540-1-1.html', '', '', ''),
(40, '管理模块', NULL, '', 0, '删除会员', 'del_member', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/forum.php?mod=viewthread&tid=632', '', '', ''),
(41, '管理模块', NULL, '', 0, '删除主题', 'del_thread', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/forum.php?mod=viewthread&tid=631', '', '', ''),
(42, '管理模块', NULL, '', 0, '删除帖子', 'del_post', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/forum.php?mod=viewthread&tid=630', '', '', ''),
(43, '管理模块', NULL, '', 0, '发送系统通知', 'send_notice', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.com/forum.php?mod=viewthread&tid=633', '', '', ''),
(44, '管理模块', NULL, '', 0, '获取未读系统通知', 'notice_checknew', 0, 0, 0, 0, 0, 0, NULL, NULL, 0, '', 'http://www.xinxiuvip.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;

账号		自动登录	找回密码
密码			立即注册

[接口开发] 新秀网络验证数据库对照表X3.5 - ver2.0

马上注册，结交更多好友，享用更多功能，让你轻松玩转社区