代码拉取完成,页面将自动刷新
/*
Navicat Premium Data Transfer
Source Server : 99v66
Source Server Type : MySQL
Source Server Version : 80022
Source Host : localhost:3306
Source Schema : rjgl
Target Server Type : MySQL
Target Server Version : 80022
File Encoding : 65001
Date: 01/07/2021 08:29:52
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for applys
-- ----------------------------
DROP TABLE IF EXISTS `applys`;
CREATE TABLE `applys` (
`aid` int(0) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '应用名称',
`mold` tinyint(0) NOT NULL COMMENT '收费类型 1扣时 2扣点',
`login` tinyint(0) NOT NULL COMMENT '登录限制 1免登陆 2单点登录 3多点登录',
`bin` tinyint(0) NOT NULL COMMENT '设备限制 1不绑定 2绑定机器码 3绑定IP',
`msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '远程数据',
`state` tinyint(0) NOT NULL COMMENT '应用状态 1=可用 2=禁止使用',
`time` int(0) NOT NULL,
PRIMARY KEY (`aid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for keys
-- ----------------------------
DROP TABLE IF EXISTS `keys`;
CREATE TABLE `keys` (
`kid` int(0) NOT NULL AUTO_INCREMENT,
`cdk` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`mold` tinyint(0) NOT NULL COMMENT '卡密类型 1扣时 2扣点',
`point` tinyint(0) NOT NULL COMMENT '点数',
`day` tinyint(0) NOT NULL COMMENT '小时数',
`aid` int(0) NOT NULL COMMENT '对应软件',
`uid` int(0) NOT NULL COMMENT '使用者UID',
`cread_time` int(0) NOT NULL COMMENT '创建时间',
`use_time` int(0) NOT NULL COMMENT '使用时间',
`state` tinyint(0) NOT NULL COMMENT '1=可用 2=不可用',
PRIMARY KEY (`kid`) USING BTREE,
UNIQUE INDEX `uni_cdk`(`cdk`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for power
-- ----------------------------
DROP TABLE IF EXISTS `power`;
CREATE TABLE `power` (
`pid` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键',
`uid` int(0) NOT NULL COMMENT '账户ID',
`aid` int(0) NOT NULL COMMENT '应用ID',
`kid` int(0) NOT NULL COMMENT '卡密ID',
`day` bigint(0) NOT NULL COMMENT '到期时间',
`point` int(0) NOT NULL COMMENT '剩余点数',
`ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '首次登陆IP',
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '首次登陆机器码',
`state` tinyint(0) NOT NULL COMMENT '1=可用 2=不可用',
`time` int(0) NOT NULL COMMENT '登陆时间',
PRIMARY KEY (`pid`) USING BTREE,
INDEX `inx_uid`(`uid`, `aid`, `kid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`uid` int(0) NOT NULL AUTO_INCREMENT,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`pwd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`state` tinyint(0) NOT NULL COMMENT '账户状态 1=可用 2=不可用',
`time` int(0) NOT NULL,
`uptime` int(0) NOT NULL COMMENT '改密时间,强退时间 用于作废之前的token',
PRIMARY KEY (`uid`) USING BTREE,
UNIQUE INDEX `uni_user`(`user`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。