From f6e685e1b7aa5b3c94b16c28fbf1eb512db2e2df Mon Sep 17 00:00:00 2001 From: jhc <2991879965@qq.com> Date: 星期二, 19 十一月 2024 17:09:07 +0800 Subject: [PATCH] 更新数据库表和数据库 --- zhulongAI.sql | 24 ++++++++++++++++++------ 1 files changed, 18 insertions(+), 6 deletions(-) diff --git a/zhulongAI.sql b/zhulongAI.sql index 5582f33..4f41675 100644 --- a/zhulongAI.sql +++ b/zhulongAI.sql @@ -40,7 +40,6 @@ `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 '鎽勫儚澶寸紪鐮�', @@ -48,12 +47,25 @@ `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 '鍘傚', + `notes` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '澶囨敞', + `live_url` varchar(128) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鎽勫儚澶寸鐞嗚〃'; -- 姝ｅ湪瀵煎嚭琛� zhulongai.camera_mark_manage 鐨勬暟鎹細~0 rows (澶х害) + +-- 瀵煎嚭 琛� zhulongai.camera_url 缁撴瀯 +CREATE TABLE IF NOT EXISTS `camera_url` ( + `id` int DEFAULT NULL, + `camera_name` varchar(128) DEFAULT NULL, + `file_name` varchar(128) DEFAULT NULL, + `local_url` varchar(128) DEFAULT NULL, + KEY `id` (`id`), + CONSTRAINT `FK_camera_url_camera_mark_manage` FOREIGN KEY (`id`) REFERENCES `camera_mark_manage` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- 姝ｅ湪瀵煎嚭琛� zhulongai.camera_url 鐨勬暟鎹細~0 rows (澶х害) -- 瀵煎嚭 琛� zhulongai.parsed_logs 缁撴瀯 CREATE TABLE IF NOT EXISTS `parsed_logs` ( @@ -76,12 +88,12 @@ 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 '鍘嗗彶鏌ヨ鍔熻兘', + `per_manage` 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)鍒嗗埆瀵瑰簲鏃犳潈闄愶紝鍙煡鐪嬶紝鍙煡鐪嬩慨鏀�', + `query_history` int DEFAULT NULL COMMENT '鍘嗗彶鍥炴斁鍔熻兘', + `clockin_manage` int DEFAULT NULL COMMENT '鎵撳崱绠＄悊', `image_input` int DEFAULT NULL COMMENT '鍥惧儚褰曞叆绠＄悊', - `version_manage` int DEFAULT NULL COMMENT '鐗堟湰绠＄悊', + `camera_manage` int DEFAULT NULL COMMENT '鎽勫儚澶寸鐞�', `admin` int DEFAULT NULL COMMENT '瓒呯骇绠＄悊鍛�', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='瑙掕壊鏉冮檺琛�'; -- Gitblit v1.8.0