From 5b3aa3ac6d57c17148614152e502ac1176598cb0 Mon Sep 17 00:00:00 2001
From: zyf <2786722087@qq.com>
Date: 星期二, 18 三月 2025 11:24:34 +0800
Subject: [PATCH] sql文件，自行导入

---
 Server/张怡帆/SQL文件/AI_datas.sql |   89 ++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 89 insertions(+), 0 deletions(-)

diff --git "a/Server/\345\274\240\346\200\241\345\270\206/SQL\346\226\207\344\273\266/AI_datas.sql" "b/Server/\345\274\240\346\200\241\345\270\206/SQL\346\226\207\344\273\266/AI_datas.sql"
new file mode 100644
index 0000000..5bc14b6
--- /dev/null
+++ "b/Server/\345\274\240\346\200\241\345\270\206/SQL\346\226\207\344\273\266/AI_datas.sql"
@@ -0,0 +1,89 @@
+-- --------------------------------------------------------
+-- 涓绘満:                           localhost
+-- 鏈嶅姟鍣ㄧ増鏈�:                        8.0.41 - 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 */;
+
+
+-- 瀵煎嚭 ai_datas 鐨勬暟鎹簱缁撴瀯
+CREATE DATABASE IF NOT EXISTS `ai_datas` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
+USE `ai_datas`;
+
+-- 瀵煎嚭  琛� ai_datas.dept 缁撴瀯
+CREATE TABLE IF NOT EXISTS `dept` (
+  `Department_id` int NOT NULL,
+  `dname` varchar(50) NOT NULL,
+  `leader` varchar(255) NOT NULL,
+  PRIMARY KEY (`Department_id`),
+  UNIQUE KEY `dname` (`dname`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+
+-- 鏁版嵁瀵煎嚭琚彇娑堥�夋嫨銆�
+
+-- 瀵煎嚭  琛� ai_datas.deviceinfo 缁撴瀯
+CREATE TABLE IF NOT EXISTS `deviceinfo` (
+  `DeviceID` int NOT NULL AUTO_INCREMENT,
+  `DeviceName` varchar(50) NOT NULL,
+  `DeviceIP` varchar(20) NOT NULL,
+  PRIMARY KEY (`DeviceID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+
+-- 鏁版嵁瀵煎嚭琚彇娑堥�夋嫨銆�
+
+-- 瀵煎嚭  琛� ai_datas.role 缁撴瀯
+CREATE TABLE IF NOT EXISTS `role` (
+  `R_id` int NOT NULL,
+  `R_name` varchar(50) NOT NULL,
+  PRIMARY KEY (`R_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+
+-- 鏁版嵁瀵煎嚭琚彇娑堥�夋嫨銆�
+
+-- 瀵煎嚭  琛� ai_datas.user 缁撴瀯
+CREATE TABLE IF NOT EXISTS `user` (
+  `id` int NOT NULL AUTO_INCREMENT,
+  `username` varchar(50) NOT NULL,
+  `password` varchar(255) NOT NULL,
+  `phone` varchar(11) DEFAULT NULL,
+  `role` varchar(20) DEFAULT NULL,
+  `Department_id` int DEFAULT NULL,
+  `Clock_time_start` datetime DEFAULT NULL,
+  `Clock_time_end` datetime DEFAULT NULL,
+  `Is_delete` tinyint DEFAULT '0',
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `username` (`username`),
+  KEY `Department_id` (`Department_id`),
+  CONSTRAINT `user_ibfk_1` FOREIGN KEY (`Department_id`) REFERENCES `dept` (`Department_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+
+-- 鏁版嵁瀵煎嚭琚彇娑堥�夋嫨銆�
+
+-- 瀵煎嚭  琛� ai_datas.videostorage 缁撴瀯
+CREATE TABLE IF NOT EXISTS `videostorage` (
+  `VideoID` int NOT NULL AUTO_INCREMENT,
+  `DeviceID` int DEFAULT NULL,
+  `StartTime` datetime NOT NULL,
+  `EndTime` datetime NOT NULL,
+  `VideoPath` varchar(255) NOT NULL,
+  PRIMARY KEY (`VideoID`),
+  KEY `DeviceID` (`DeviceID`),
+  CONSTRAINT `videostorage_ibfk_1` FOREIGN KEY (`DeviceID`) REFERENCES `deviceinfo` (`DeviceID`)
+) 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) */;

--
Gitblit v1.8.0