-- --------------------------------------------------------
|
-- 主机: 127.0.0.1
|
-- 服务器版本: 8.3.0 - 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 */;
|
|
|
-- 导出 mayi_kunlun 的数据库结构
|
CREATE DATABASE IF NOT EXISTS `mayi_kunlun` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
|
USE `mayi_kunlun`;
|
|
-- 导出 表 mayi_kunlun.data_info 结构
|
CREATE TABLE IF NOT EXISTS `data_info` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`device_name` varchar(50) DEFAULT NULL,
|
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`data` float DEFAULT NULL,
|
`time` varchar(50) DEFAULT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='数据';
|
|
-- 正在导出表 mayi_kunlun.data_info 的数据：~2 rows (大约)
|
INSERT INTO `data_info` (`id`, `device_name`, `type`, `data`, `time`) VALUES
|
(1, '刘', '但是', 1, '1'),
|
(2, '王', ' 的', 2, '2');
|
|
-- 导出 表 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` 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` varchar(50) DEFAULT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- 正在导出表 mayi_kunlun.devices_management_info 的数据：~5 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
|
(6, '6', '6', '6', '6', '8', 8, 8, '8', '8', '8', NULL, NULL),
|
(7, '1', '4', '4', '2', '6', 6, 9, '9', '2', '2', NULL, NULL),
|
(8, '1', '2', '3', '2', '3', 2, 2, '3', '3', '1', NULL, NULL),
|
(9, '10', '2', '3', '2', '3', 2, 2, '3', '3', '1', NULL, NULL),
|
(10, '6', '5', '5', '5', '5', 5, 5, '5', '5', '5', NULL, NULL);
|
|
-- 导出 表 mayi_kunlun.month_info 结构
|
CREATE TABLE IF NOT EXISTS `month_info` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`date` char(20) NOT NULL,
|
`A_output` double NOT NULL,
|
`B_output` double NOT NULL,
|
`C_output` double NOT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='产量表';
|
|
-- 正在导出表 mayi_kunlun.month_info 的数据：~0 rows (大约)
|
|
-- 导出 表 mayi_kunlun.parsed_logs 结构
|
CREATE TABLE IF NOT EXISTS `parsed_logs` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`time_stamp` varchar(50) NOT NULL DEFAULT '0',
|
`device_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`level` varchar(16) NOT NULL,
|
`content` varchar(256) NOT NULL,
|
`user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`file_name` varchar(64) NOT NULL,
|
`problem_line` int NOT NULL,
|
`function_name` varchar(64) NOT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- 正在导出表 mayi_kunlun.parsed_logs 的数据：~2 rows (大约)
|
INSERT INTO `parsed_logs` (`id`, `time_stamp`, `device_id`, `level`, `content`, `user_id`, `file_name`, `problem_line`, `function_name`) VALUES
|
(1, '2024-05-10 10:05:06', '5', '5', '5', '5', '5', 7, '5'),
|
(2, '2020-05-01 11:05:02', '2', '3', '6', '3', '1', 2, '3');
|
|
-- 导出 表 mayi_kunlun.production_plan 结构
|
CREATE TABLE IF NOT EXISTS `production_plan` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`plan_id` int NOT NULL,
|
`plan_name` varchar(50) DEFAULT NULL,
|
`start_date` char(20) DEFAULT NULL,
|
`closing_date` char(20) DEFAULT NULL,
|
`production_name` varchar(50) DEFAULT NULL,
|
`planned_production` double DEFAULT NULL,
|
`actual_production` double DEFAULT NULL,
|
`progress` double DEFAULT NULL,
|
`finish_ontime` int DEFAULT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- 正在导出表 mayi_kunlun.production_plan 的数据：~0 rows (大约)
|
|
-- 导出 表 mayi_kunlun.role_info 结构
|
CREATE TABLE IF NOT EXISTS `role_info` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`permission_type` varchar(100) DEFAULT NULL,
|
`query_history` int DEFAULT '0',
|
`logger_search` int DEFAULT '0',
|
`map_mark` int DEFAULT '0',
|
`dev_manage` int DEFAULT '0',
|
`product_plan` int DEFAULT '0',
|
`warning_manage` int DEFAULT '0',
|
`version_manage` int DEFAULT '0',
|
`admin` int DEFAULT '0',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- 正在导出表 mayi_kunlun.role_info 的数据：~0 rows (大约)
|
|
-- 导出 表 mayi_kunlun.threshold_info 结构
|
CREATE TABLE IF NOT EXISTS `threshold_info` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`device_name` varchar(50) DEFAULT NULL,
|
`type` varchar(50) DEFAULT NULL,
|
`min` float DEFAULT NULL,
|
`max` float DEFAULT NULL,
|
`time` varchar(50) DEFAULT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='阈值';
|
|
-- 正在导出表 mayi_kunlun.threshold_info 的数据：~0 rows (大约)
|
|
-- 导出 表 mayi_kunlun.user_info 结构
|
CREATE TABLE IF NOT EXISTS `user_info` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`department` varchar(50) DEFAULT NULL,
|
`user_name` varchar(32) DEFAULT NULL,
|
`password` varchar(32) DEFAULT NULL,
|
`user_no` varchar(10) DEFAULT NULL,
|
`age` int DEFAULT NULL,
|
`sex` varchar(10) 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`),
|
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 (大约)
|
|
-- 导出 表 mayi_kunlun.version_file 结构
|
CREATE TABLE IF NOT EXISTS `version_file` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`version_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
`filename` char(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
`fliesize` bigint NOT NULL DEFAULT (0),
|
`s_filepath` varchar(256) NOT NULL,
|
`c_filepath` varchar(256) NOT NULL,
|
`uploader` char(64) NOT NULL DEFAULT '',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- 正在导出表 mayi_kunlun.version_file 的数据：~0 rows (大约)
|
|
-- 导出 表 mayi_kunlun.version_info 结构
|
CREATE TABLE IF NOT EXISTS `version_info` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`version_id` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
`version_id_old` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '',
|
`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;
|
|
-- 正在导出表 mayi_kunlun.version_info 的数据：~3 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'),
|
(3, '1.5', '1.5', '227', '2024-11-01 15:48:18');
|
|
-- 导出 表 mayi_kunlun.warning_info 结构
|
CREATE TABLE IF NOT EXISTS `warning_info` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`device_name` varchar(50) NOT NULL DEFAULT '',
|
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`des` varchar(50) NOT NULL,
|
`warning_data` float NOT NULL,
|
`time` varchar(50) NOT NULL DEFAULT '',
|
`status` varchar(50) NOT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='警报数据';
|
|
-- 正在导出表 mayi_kunlun.warning_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) */;
|
<<<<<<< HEAD
|
<<<<<<< HEAD
|
z
|
=======
|
SELECT id,devices_name,longitude,latitude,devices_status FROM devices_management;
|
>>>>>>> 2e420a0a40cc3fcc62bcb42ee6a25f4ad4f22dd3
|
=======
|
>>>>>>> d4c3d3a2b8a3e1507ca835870073df807cdb87df
|
