From 38b96e0637bc5c5b3b6342b2c1e7ef24e64f0369 Mon Sep 17 00:00:00 2001 From: hexiaohao <1634696506@qq.com> Date: 星期五, 02 八月 2024 15:40:22 +0800 Subject: [PATCH] 代码 --- Client/何小豪/code/quanxian.sql | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Client/何小豪/code/Permissions.rar | 0 Client/何小豪/code/test_tcp_server_0620.rar | 0 3 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 -- Gitblit v1.8.0