From 2334d6b75903189348b27859b2778badafa79528 Mon Sep 17 00:00:00 2001 From: wangky <m1561510467@163.com> Date: 星期六, 16 十一月 2024 15:20:57 +0800 Subject: [PATCH] Merge branch 'master' of ssh://115.28.86.8:29418/~admin/烛龙AI_1111_07.17 --- Client/马渝杭/document/打卡识别管理功能需求.docx | 0 Client/宋昊昳/log/日志_宋昊昳_1116.doc | 0 zhulongAI.sql | 143 +++++++++++++++++++++++++++++++++++++++++++++++ Client/马渝杭/log/20241115烛龙AII日报.doc | 0 Client/黎弘霖/log/摄像头标注管理_黎弘霖_1116.doc | 0 5 files changed, 143 insertions(+), 0 deletions(-) diff --git "a/Client/\345\256\213\346\230\212\346\230\263/log/\346\227\245\345\277\227_\345\256\213\346\230\212\346\230\263_1116.doc" "b/Client/\345\256\213\346\230\212\346\230\263/log/\346\227\245\345\277\227_\345\256\213\346\230\212\346\230\263_1116.doc" new file mode 100644 index 0000000..be89c52 --- /dev/null +++ "b/Client/\345\256\213\346\230\212\346\230\263/log/\346\227\245\345\277\227_\345\256\213\346\230\212\346\230\263_1116.doc" Binary files differ diff --git "a/Client/\351\251\254\346\270\235\346\235\255/document/\346\211\223\345\215\241\350\257\206\345\210\253\347\256\241\347\220\206\345\212\237\350\203\275\351\234\200\346\261\202.docx" "b/Client/\351\251\254\346\270\235\346\235\255/document/\346\211\223\345\215\241\350\257\206\345\210\253\347\256\241\347\220\206\345\212\237\350\203\275\351\234\200\346\261\202.docx" index daadb26..ee02b95 100644 --- "a/Client/\351\251\254\346\270\235\346\235\255/document/\346\211\223\345\215\241\350\257\206\345\210\253\347\256\241\347\220\206\345\212\237\350\203\275\351\234\200\346\261\202.docx" +++ "b/Client/\351\251\254\346\270\235\346\235\255/document/\346\211\223\345\215\241\350\257\206\345\210\253\347\256\241\347\220\206\345\212\237\350\203\275\351\234\200\346\261\202.docx" Binary files differ diff --git "a/Client/\351\251\254\346\270\235\346\235\255/log/20241115\347\203\233\351\276\231AII\346\227\245\346\212\245.doc" "b/Client/\351\251\254\346\270\235\346\235\255/log/20241115\347\203\233\351\276\231AII\346\227\245\346\212\245.doc" new file mode 100644 index 0000000..de8101d --- /dev/null +++ "b/Client/\351\251\254\346\270\235\346\235\255/log/20241115\347\203\233\351\276\231AII\346\227\245\346\212\245.doc" Binary files differ diff --git "a/Client/\351\273\216\345\274\230\351\234\226/log/\346\221\204\345\203\217\345\244\264\346\240\207\346\263\250\347\256\241\347\220\206_\351\273\216\345\274\230\351\234\226_1116.doc" "b/Client/\351\273\216\345\274\230\351\234\226/log/\346\221\204\345\203\217\345\244\264\346\240\207\346\263\250\347\256\241\347\220\206_\351\273\216\345\274\230\351\234\226_1116.doc" new file mode 100644 index 0000000..c823194 --- /dev/null +++ "b/Client/\351\273\216\345\274\230\351\234\226/log/\346\221\204\345\203\217\345\244\264\346\240\207\346\263\250\347\256\241\347\220\206_\351\273\216\345\274\230\351\234\226_1116.doc" Binary files differ diff --git a/zhulongAI.sql b/zhulongAI.sql new file mode 100644 index 0000000..5582f33 --- /dev/null +++ b/zhulongAI.sql @@ -0,0 +1,143 @@ +-- -------------------------------------------------------- +-- 涓绘満: 127.0.0.1 +-- 鏈嶅姟鍣ㄧ増鏈�: 8.0.39 - 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 */; + + +-- 瀵煎嚭 zhulongai 鐨勬暟鎹簱缁撴瀯 +CREATE DATABASE IF NOT EXISTS `zhulongai` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; +USE `zhulongai`; + +-- 瀵煎嚭 琛� zhulongai.attendance_record 缁撴瀯 +CREATE TABLE IF NOT EXISTS `attendance_record` ( + `record_id` int NOT NULL AUTO_INCREMENT COMMENT '鎵撳崱璁板綍鐨勫敮涓�鏍囪瘑', + `user_id` int DEFAULT NULL COMMENT '鍏宠仈鐨勭敤鎴稩D', + `timestamp` datetime NOT NULL COMMENT '鎵撳崱鏃堕棿', + `status` varchar(20) DEFAULT NULL COMMENT '鎵撳崱鐘舵�侊紙鎴愬姛/澶辫触锛�', + PRIMARY KEY (`record_id`), + KEY `FK_attendance_record_user_info` (`user_id`), + CONSTRAINT `FK_attendance_record_user_info` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`role_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鐢ㄦ埛鎵撳崱璁板綍琛�'; + +-- 姝ｅ湪瀵煎嚭琛� zhulongai.attendance_record 鐨勬暟鎹細~0 rows (澶х害) + +-- 瀵煎嚭 琛� zhulongai.camera_mark_manage 缁撴瀯 +CREATE TABLE IF NOT EXISTS `camera_mark_manage` ( + `id` int NOT NULL AUTO_INCREMENT, + `camera_name` varchar(50) NOT NULL COMMENT '鎽勫儚澶村悕绉�', + `area` varchar(128) NOT NULL COMMENT '鍦板尯', + `status` varchar(50) NOT NULL COMMENT '鐘舵��', + `ip` varchar(50) NOT NULL COMMENT 'ip', + `mark_time` varchar(50) NOT NULL COMMENT '鏍囨敞鏃堕棿', + `mark_status` varchar(50) NOT NULL COMMENT '鏍囨敞鐘舵��', + `buy_time` varchar(50) NOT NULL COMMENT '璐拱鏃堕棿', + `install_time` varchar(50) NOT NULL COMMENT '瀹夎鏃堕棿', + `camera_number` varchar(50) NOT NULL COMMENT '鎽勫儚澶寸紪鐮�', + `camera_type` varchar(50) NOT NULL COMMENT '鎽勫儚澶寸被鍨�', + `longitude` double NOT NULL COMMENT '缁忓害', + `latitude` double NOT NULL COMMENT '绾害', + `belong_to` varchar(50) NOT NULL COMMENT '鎵�灞炵粍缁�/閮ㄩ棬', + `url` varchar(128) NOT NULL COMMENT '缃戝潃', + `factory` varchar(128) NOT NULL COMMENT '鍘傚', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鎽勫儚澶寸鐞嗚〃'; + +-- 姝ｅ湪瀵煎嚭琛� zhulongai.camera_mark_manage 鐨勬暟鎹細~0 rows (澶х害) + +-- 瀵煎嚭 琛� zhulongai.parsed_logs 缁撴瀯 +CREATE TABLE IF NOT EXISTS `parsed_logs` ( + `id` int NOT NULL AUTO_INCREMENT COMMENT '涓婚敭锛岃嚜澧�', + `time_stamp` varchar(64) DEFAULT NULL COMMENT '鏃堕棿鎴�', + `camera_id` varchar(64) NOT NULL COMMENT '鎽勫儚澶碔D', + `level` varchar(64) DEFAULT NULL COMMENT '鏃ュ織绾у埆', + `module` varchar(64) DEFAULT NULL COMMENT '鍔熻兘妯″潡', + `content` varchar(256) DEFAULT NULL COMMENT '鏃ュ織鍐呭', + `user_id` varchar(32) DEFAULT NULL COMMENT '鐢ㄦ埛ID', + `file_name` varchar(64) DEFAULT NULL COMMENT '闂鏂囦欢鍚�', + `problem_line` int DEFAULT NULL COMMENT '闂琛屾暟', + `function_name` varchar(32) DEFAULT NULL COMMENT '闂鍑芥暟鍚�', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鏃ュ織琛�'; + +-- 姝ｅ湪瀵煎嚭琛� zhulongai.parsed_logs 鐨勬暟鎹細~0 rows (澶х害) + +-- 瀵煎嚭 琛� zhulongai.role_info 缁撴瀯 +CREATE TABLE IF NOT EXISTS `role_info` ( + `id` int NOT NULL AUTO_INCREMENT COMMENT '瑙掕壊琛ㄤ富閿嚜澧瀒d', + `permission_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '瑙掕壊绫诲瀷', + `query_history` int DEFAULT NULL COMMENT '鍘嗗彶鏌ヨ鍔熻兘', + `logger_search` int DEFAULT NULL COMMENT '鏃ュ織鏌ヨ鍔熻兘', + `camera_mark` int DEFAULT NULL COMMENT '鎽勫儚澶存爣娉�', + `dev_manage` int DEFAULT NULL COMMENT '鎽勫儚澶磋澶囩鐞�(0,1,2)鍒嗗埆瀵瑰簲鏃犳潈闄愶紝鍙煡鐪嬶紝鍙煡鐪嬩慨鏀�', + `image_input` int DEFAULT NULL COMMENT '鍥惧儚褰曞叆绠＄悊', + `version_manage` int DEFAULT NULL COMMENT '鐗堟湰绠＄悊', + `admin` int DEFAULT NULL COMMENT '瓒呯骇绠＄悊鍛�', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='瑙掕壊鏉冮檺琛�'; + +-- 姝ｅ湪瀵煎嚭琛� zhulongai.role_info 鐨勬暟鎹細~0 rows (澶х害) + +-- 瀵煎嚭 琛� zhulongai.user_info 缁撴瀯 +CREATE TABLE IF NOT EXISTS `user_info` ( + `id` int NOT NULL AUTO_INCREMENT COMMENT 'id(鑷)', + `department` varchar(50) DEFAULT NULL COMMENT '鍛樺伐鎵�鍦ㄩ儴闂�', + `user_name` varchar(32) DEFAULT NULL COMMENT '鐢ㄦ埛鍚�(鍞竴閿�)', + `password` varchar(255) DEFAULT NULL COMMENT '鐢ㄦ埛瀵嗙爜', + `user_no` varchar(10) DEFAULT NULL COMMENT '宸ュ彿锛堣嚜鍔ㄧ敓鎴愶級', + `age` int NOT NULL COMMENT '鍛樺伐骞撮緞', + `sex` varchar(10) NOT NULL DEFAULT '' COMMENT '鍛樺伐鎬у埆', + `role_id` int DEFAULT NULL COMMENT '瑙掕壊id锛屽閿叧鑱旇鑹茶〃鐨勪富閿�', + `email` varchar(32) DEFAULT NULL COMMENT '鐢靛瓙閭', + `telephone` varchar(32) NOT NULL DEFAULT '' COMMENT '鐢佃瘽鍙风爜', + `status` int DEFAULT NULL COMMENT '鐢ㄦ埛鐘舵�侊紙1鍦ㄨ亴銆�0绂昏亴锛�', + `login_time` datetime DEFAULT NULL COMMENT '鐧诲綍鏃堕棿', + `register_time` datetime DEFAULT NULL COMMENT '娉ㄥ唽鏃堕棿', + `dir` varchar(50) DEFAULT NULL COMMENT '鐓х墖鎵�鍦ㄧ洰褰�', + PRIMARY KEY (`id`), + KEY `role_id` (`role_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鐢ㄦ埛淇℃伅琛�'; + +-- 姝ｅ湪瀵煎嚭琛� zhulongai.user_info 鐨勬暟鎹細~0 rows (澶х害) + +-- 瀵煎嚭 琛� zhulongai.version_file 缁撴瀯 +CREATE TABLE IF NOT EXISTS `version_file` ( + `id` int NOT NULL AUTO_INCREMENT, + `version_id` char(64) DEFAULT NULL COMMENT '鐗堟湰鍙�', + `filename` char(128) DEFAULT NULL COMMENT '鏂囦欢鍚�', + `fliesize` bigint DEFAULT NULL COMMENT '鏂囦欢澶у皬', + `s_filepath` varchar(50) DEFAULT NULL COMMENT '鏈嶅姟绔矾寰�', + `c_filepath` varchar(50) DEFAULT NULL COMMENT '瀹㈡埛绔矾寰�', + `uploader` char(64) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鐗堟湰鏇存柊琛�'; + +-- 姝ｅ湪瀵煎嚭琛� zhulongai.version_file 鐨勬暟鎹細~0 rows (澶х害) + +-- 瀵煎嚭 琛� zhulongai.version_info 缁撴瀯 +CREATE TABLE IF NOT EXISTS `version_info` ( + `id` int NOT NULL AUTO_INCREMENT, + `version_id` char(64) DEFAULT NULL COMMENT '鐗堟湰鍙�', + `version_id_old` char(64) DEFAULT NULL COMMENT '鏃х増鐗堟湰鍙�', + `version_description` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '鐗堟湰鎻忚堪', + `version_creatime` datetime DEFAULT NULL COMMENT '鐗堟湰鍒涘缓', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鐗堟湰鏇存柊琛�'; + +-- 姝ｅ湪瀵煎嚭琛� zhulongai.version_info 鐨勬暟鎹細~0 rows (澶х害) + +/*!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) */; -- Gitblit v1.8.0