From cfa62dd99309e6377ed2a007bc3b3d80767e0079 Mon Sep 17 00:00:00 2001 From: 宗玛帝 <1006520659@qq.com> Date: 星期六, 03 八月 2024 10:35:51 +0800 Subject: [PATCH] Merge branch 'master' of ssh://115.28.86.8:29418/~admin/ef-p_pro_24_07_23 --- Client/胡宵/log/历史查询分析_胡宵_2024.8.1.doc | 0 Client/何小豪/code/quanxian.sql | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Client/何小豪/code/Permissions.rar | 0 Client/何小豪/code/test_tcp_server_0620.rar | 0 Server/吴泽林/log/日报_吴泽林_0801.doc | 0 Server/杜润昆/log/日报_杜润昆_0802.doc | 0 Client/胡宵/log/~WRL3045.tmp | 0 7 files changed, 56 insertions(+), 0 deletions(-) diff --git "a/Client/\344\275\225\345\260\217\350\261\252/code/Permissions.rar" "b/Client/\344\275\225\345\260\217\350\261\252/code/Permissions.rar" new file mode 100644 index 0000000..1e44c85 --- /dev/null +++ "b/Client/\344\275\225\345\260\217\350\261\252/code/Permissions.rar" Binary files differ diff --git "a/Client/\344\275\225\345\260\217\350\261\252/code/quanxian.sql" "b/Client/\344\275\225\345\260\217\350\261\252/code/quanxian.sql" new file mode 100644 index 0000000..210dae1 --- /dev/null +++ "b/Client/\344\275\225\345\260\217\350\261\252/code/quanxian.sql" @@ -0,0 +1,56 @@ +-- -------------------------------------------------------- +-- 涓绘満: 127.0.0.1 +-- 鏈嶅姟鍣ㄧ増鏈�: 8.0.37 - MySQL Community Server - GPL +-- 鏈嶅姟鍣ㄦ搷浣滅郴缁�: Win64 +-- HeidiSQL 鐗堟湰: 12.6.0.6765 +-- -------------------------------------------------------- + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET NAMES utf8 */; +/*!50503 SET NAMES utf8mb4 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + + +-- 瀵煎嚭 uesr 鐨勬暟鎹簱缁撴瀯 +DROP DATABASE IF EXISTS `uesr`; +CREATE DATABASE IF NOT EXISTS `uesr` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; +USE `uesr`; + +-- 瀵煎嚭 琛� uesr.permissions 缁撴瀯 +DROP TABLE IF EXISTS `permissions`; +CREATE TABLE IF NOT EXISTS `permissions` ( + `user_id` int NOT NULL COMMENT '鐢ㄦ埛id', + `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '鐢ㄦ埛鍚�', + `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '瑙掕壊', + KEY `FK_permissions_roles` (`role`), + CONSTRAINT `FK_permissions_roles` FOREIGN KEY (`role`) REFERENCES `roles` (`role`) ON DELETE SET NULL ON UPDATE SET NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- 鏁版嵁瀵煎嚭琚彇娑堥�夋嫨銆� + +-- 瀵煎嚭 琛� uesr.roles 缁撴瀯 +DROP TABLE IF EXISTS `roles`; +CREATE TABLE IF NOT EXISTS `roles` ( + `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '瑙掕壊', + `Permissions_admin` tinyint unsigned DEFAULT '0' COMMENT '鏉冮檺绠＄悊鏉冮檺', + `Permissions_query` tinyint unsigned DEFAULT '0' COMMENT '鍘嗗彶鏌ヨ鍒嗘瀽鏉冮檺', + `Permissions_alert` tinyint unsigned DEFAULT '0' COMMENT '璀︽姤绠＄悊鏉冮檺', + `Permissions_Log` tinyint unsigned DEFAULT '0' COMMENT '鏃ュ織鏌ヨ鏉冮檺', + `Permissions_map` tinyint unsigned DEFAULT '0' COMMENT '鍦板浘鏍囨敞鏉冮檺', + `Permissions_produce` tinyint unsigned DEFAULT '0' COMMENT '鐢熶骇璁″垝鏉冮檺', + `Permissions_equipment` tinyint unsigned DEFAULT '0' COMMENT '璁惧绠＄悊鏉冮檺', + `Permissions_version` tinyint unsigned DEFAULT '0' COMMENT '鐗堟湰绠＄悊鏉冮檺', + KEY `role` (`role`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- 鏁版嵁瀵煎嚭琚彇娑堥�夋嫨銆� + +/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; +/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; +/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */; diff --git "a/Client/\344\275\225\345\260\217\350\261\252/code/test_tcp_server_0620.rar" "b/Client/\344\275\225\345\260\217\350\261\252/code/test_tcp_server_0620.rar" new file mode 100644 index 0000000..093f5c5 --- /dev/null +++ "b/Client/\344\275\225\345\260\217\350\261\252/code/test_tcp_server_0620.rar" Binary files differ diff --git "a/Client/\350\203\241\345\256\265/log/~WRL1624.tmp" "b/Client/\350\203\241\345\256\265/log/~WRL3045.tmp" similarity index 83% rename from "Client/\350\203\241\345\256\265/log/~WRL1624.tmp" rename to "Client/\350\203\241\345\256\265/log/~WRL3045.tmp" index 10f383e..f5576a6 100644 --- "a/Client/\350\203\241\345\256\265/log/~WRL1624.tmp" +++ "b/Client/\350\203\241\345\256\265/log/~WRL3045.tmp" Binary files differ diff --git "a/Client/\350\203\241\345\256\265/log/~WRL1624.tmp" "b/Client/\350\203\241\345\256\265/log/\345\216\206\345\217\262\346\237\245\350\257\242\345\210\206\346\236\220_\350\203\241\345\256\265_2024.8.1.doc" similarity index 80% copy from "Client/\350\203\241\345\256\265/log/~WRL1624.tmp" copy to "Client/\350\203\241\345\256\265/log/\345\216\206\345\217\262\346\237\245\350\257\242\345\210\206\346\236\220_\350\203\241\345\256\265_2024.8.1.doc" index 10f383e..3d300fb 100644 --- "a/Client/\350\203\241\345\256\265/log/~WRL1624.tmp" +++ "b/Client/\350\203\241\345\256\265/log/\345\216\206\345\217\262\346\237\245\350\257\242\345\210\206\346\236\220_\350\203\241\345\256\265_2024.8.1.doc" Binary files differ diff --git "a/Server/\345\220\264\346\263\275\346\236\227/log/\346\227\245\346\212\245_\345\220\264\346\263\275\346\236\227_0801.doc" "b/Server/\345\220\264\346\263\275\346\236\227/log/\346\227\245\346\212\245_\345\220\264\346\263\275\346\236\227_0801.doc" new file mode 100644 index 0000000..eb6c5df --- /dev/null +++ "b/Server/\345\220\264\346\263\275\346\236\227/log/\346\227\245\346\212\245_\345\220\264\346\263\275\346\236\227_0801.doc" Binary files differ diff --git "a/Server/\346\235\234\346\266\246\346\230\206/log/\346\227\245\346\212\245_\346\235\234\346\266\246\346\230\206_0802.doc" "b/Server/\346\235\234\346\266\246\346\230\206/log/\346\227\245\346\212\245_\346\235\234\346\266\246\346\230\206_0802.doc" new file mode 100644 index 0000000..acdec9d --- /dev/null +++ "b/Server/\346\235\234\346\266\246\346\230\206/log/\346\227\245\346\212\245_\346\235\234\346\266\246\346\230\206_0802.doc" Binary files differ -- Gitblit v1.8.0