DB_51Aspx/userlogin.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL5.7
 Source Server Type    : MySQL
 Source Server Version : 50739 (5.7.39)
 Source Host           : localhost:3306
 Source Schema         : userlogin

 Target Server Type    : MySQL
 Target Server Version : 50739 (5.7.39)
 File Encoding         : 65001

 Date: 10/05/2024 22:21:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for loginfo
-- ----------------------------
DROP TABLE IF EXISTS `loginfo`;
CREATE TABLE `loginfo`  (
  `LogId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '日志主键',
  `CategoryId` int(11) NULL DEFAULT NULL COMMENT '分类Id',
  `SourceObjectId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源对象主键',
  `SourceContentJson` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源日志内容',
  `OperateTime` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '操作时间',
  `OperateUserId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户Id',
  `OperateAccount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户',
  `OperateTypeId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作类型Id',
  `OperateType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作类型',
  `Module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系统功能',
  `IPAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
  `IPAddressName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'IP地址所在城市',
  `Host` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主机',
  `Browser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览器',
  `ExecuteResult` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行结果状态',
  `ExecuteResultJson` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行结果信息',
  `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `DeleteMark` int(11) NULL DEFAULT NULL COMMENT '删除标记',
  `EnabledMark` int(11) NULL DEFAULT NULL COMMENT '有效标志',
  PRIMARY KEY (`LogId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统日志' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of loginfo
-- ----------------------------
INSERT INTO `loginfo` VALUES ('2530485e-d039-4601-adf6-24fd741fc477', 1, NULL, NULL, '2018-07-10 15:53:40', '1', 'admin(Admin)', '1', '登录', 'Chinaz', '127.0.0.1', NULL, 'DESKTOP-5TH661G', 'Firefox 61.0', '1', '登录成功', NULL, 0, 1);
INSERT INTO `loginfo` VALUES ('6febb441-9475-4c83-aad5-72c9ae6b4b88', 1, NULL, NULL, '2024-05-10 22:11:57', '1', 'admin()', NULL, '用户登陆', '登陆模块', '169.254.13.78', NULL, 'localhost', 'Chrome 124.0', '1', '登录成功', NULL, 0, 1);
INSERT INTO `loginfo` VALUES ('8a5f06b7-e76c-4042-b9a4-ac296ed9cca4', 1, NULL, NULL, '2024-05-10 22:14:11', '1', 'admin()', NULL, '用户登陆', '登陆模块', '169.254.13.78', NULL, 'localhost', 'Chrome 124.0', '1', '登录成功', NULL, 0, 1);
INSERT INTO `loginfo` VALUES ('a4f810b3-62ca-4997-99df-84ac4cd8e096', 1, NULL, NULL, '2024-05-10 22:18:24', '1', 'admin()', NULL, '用户登陆', '登陆模块', '169.254.13.78', NULL, 'localhost', 'Chrome 124.0', '1', '登录成功', NULL, 0, 1);
INSERT INTO `loginfo` VALUES ('e7604b2a-c7a1-4ff4-b727-1c18e7bd4318', 1, NULL, NULL, '2024-05-10 22:17:31', '1', 'admin()', NULL, '退出登陆', '登陆模块', NULL, NULL, NULL, NULL, '1', '退出系统', NULL, 0, 1);
INSERT INTO `loginfo` VALUES ('f3ccbde9-0837-4c33-8f3f-4301508bc7b9', 1, NULL, NULL, '2024-05-10 22:16:43', '1', 'admin()', NULL, '用户登陆', '登陆模块', '169.254.13.78', NULL, 'localhost', 'Chrome 124.0', '1', '登录成功', NULL, 0, 1);
INSERT INTO `loginfo` VALUES ('fcc65d74-3bd8-4b63-9c53-9aee86cf8be4', 1, NULL, NULL, '2024-05-10 22:19:59', '1', 'admin()', NULL, '退出登陆', '登陆模块', NULL, NULL, NULL, NULL, '1', '退出系统', NULL, 0, 1);

-- ----------------------------
-- Table structure for usersinfo
-- ----------------------------