From 544d6f77a5c1252f491c8b1cdb85d47f13659552 Mon Sep 17 00:00:00 2001 From: wangky <m1561510467@163.com> Date: 星期二, 05 十一月 2024 15:05:27 +0800 Subject: [PATCH] 1 --- ~$表.docx | 0 kunlun.sql | 55 ++++++++++++++++++++++++++++++++++--------------------- 2 files changed, 34 insertions(+), 21 deletions(-) diff --git a/kunlun110401.sql b/kunlun.sql similarity index 83% rename from kunlun110401.sql rename to kunlun.sql index 816d293..aa88b37 100644 --- a/kunlun110401.sql +++ b/kunlun.sql @@ -31,24 +31,29 @@ -- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.data_info 鐨勬暟鎹細~0 rows (澶х害) --- 瀵煎嚭 琛� mayi_kunlun.devices_management 缁撴瀯 -CREATE TABLE IF NOT EXISTS `devices_management` ( - `id` int NOT NULL, +-- 瀵煎嚭 琛� mayi_kunlun.devices_management_info 缁撴瀯 +CREATE TABLE IF NOT EXISTS `devices_management_info` ( + `id` int NOT NULL AUTO_INCREMENT, `devices_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `devices_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `devices_serial_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `devices_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `area` varchar(50) DEFAULT NULL, `longitude` double DEFAULT NULL, `latitude` double DEFAULT NULL, - `purchasing_time` datetime DEFAULT NULL, - `install_time` datetime DEFAULT NULL, + `purchasing_time` varchar(50) DEFAULT NULL, + `install_time` varchar(50) DEFAULT NULL, `manufacturer` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `mark_name` varchar(50) DEFAULT NULL, - `mark_time` datetime DEFAULT NULL, + `mark_time` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; --- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.devices_management 鐨勬暟鎹細~0 rows (澶х害) +-- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.devices_management_info 鐨勬暟鎹細~3 rows (澶х害) +INSERT INTO `devices_management_info` (`id`, `devices_name`, `devices_type`, `devices_serial_number`, `devices_status`, `area`, `longitude`, `latitude`, `purchasing_time`, `install_time`, `manufacturer`, `mark_name`, `mark_time`) VALUES + (2, '12', '3', '2', '2', '3', 4, 6, '6', '3', '3', NULL, NULL), + (3, '3', '1', '3', '3', '1', 2, 5, '6', '3', '6', NULL, NULL), + (4, '10', '1', '3', '3', '1', 2, 5, '9', '3', '6', NULL, NULL); -- 瀵煎嚭 琛� mayi_kunlun.month_info 缁撴瀯 CREATE TABLE IF NOT EXISTS `month_info` ( @@ -112,6 +117,16 @@ -- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.role_info 鐨勬暟鎹細~0 rows (澶х害) +-- 瀵煎嚭 琛� mayi_kunlun.student 缁撴瀯 +CREATE TABLE IF NOT EXISTS `student` ( + `id` int NOT NULL AUTO_INCREMENT, + `name` varchar(50) DEFAULT NULL, + `age` int DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.student 鐨勬暟鎹細~0 rows (澶х害) + -- 瀵煎嚭 琛� mayi_kunlun.threshold_info 缁撴瀯 CREATE TABLE IF NOT EXISTS `threshold_info` ( `id` int NOT NULL AUTO_INCREMENT, @@ -128,19 +143,21 @@ -- 瀵煎嚭 琛� mayi_kunlun.user_info 缁撴瀯 CREATE TABLE IF NOT EXISTS `user_info` ( `id` int NOT NULL AUTO_INCREMENT, - `department` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, - `user_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `department` varchar(50) DEFAULT NULL, + `user_name` varchar(32) DEFAULT NULL, `password` varchar(32) DEFAULT NULL, - `user_no` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, + `user_no` varchar(10) DEFAULT NULL, `age` int DEFAULT NULL, `sex` varchar(10) DEFAULT NULL, - `role_id` int DEFAULT NULL, `email` varchar(32) DEFAULT NULL, `telephone` varchar(32) DEFAULT NULL, `status` int DEFAULT NULL, + `role_id` int DEFAULT NULL, `login_time` datetime DEFAULT NULL, `register_time` datetime DEFAULT NULL, - PRIMARY KEY (`id`) + PRIMARY KEY (`id`), + KEY `role_id` (`role_id`), + CONSTRAINT `user_info_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `role_info` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.user_info 鐨勬暟鎹細~0 rows (澶х害) @@ -155,13 +172,9 @@ `c_filepath` varchar(256) NOT NULL, `uploader` char(64) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; --- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.version_file 鐨勬暟鎹細~3 rows (澶х害) -INSERT INTO `version_file` (`id`, `version_id`, `filename`, `fliesize`, `s_filepath`, `c_filepath`, `uploader`) VALUES - (1, '1.3', '1.jpd', 12555, './versoin', './2', ''), - (2, '1.4', '2.jpd', 1255, './', './2', ''), - (3, '1.5', '3.jpd', 122, './', './2', ''); +-- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.version_file 鐨勬暟鎹細~0 rows (澶х害) -- 瀵煎嚭 琛� mayi_kunlun.version_info 缁撴瀯 CREATE TABLE IF NOT EXISTS `version_info` ( @@ -171,9 +184,9 @@ `version_description` char(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', `version_creatime` datetime NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; --- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.version_info 鐨勬暟鎹細~3 rows (澶х害) +-- 姝ｅ湪瀵煎嚭琛� mayi_kunlun.version_info 鐨勬暟鎹細~2 rows (澶х害) INSERT INTO `version_info` (`id`, `version_id`, `version_id_old`, `version_description`, `version_creatime`) VALUES (1, '1.3', '1.3', '225', '2024-10-29 15:47:00'), (2, '1.4', '1.4', '226', '2024-10-30 02:47:30'), diff --git "a/~$\350\241\250.docx" "b/~$\350\241\250.docx" new file mode 100644 index 0000000..8b245e2 --- /dev/null +++ "b/~$\350\241\250.docx" Binary files differ -- Gitblit v1.8.0