Device/SERVER/Meter_Service/database/vbdsm_meter.sql

/*
 Navicat Premium Data Transfer

 Source Server         : L_104
 Source Server Type    : MySQL
 Source Server Version : 50743
 Source Host           : 192.168.0.104:3306
 Source Schema         : vbdsm_meter

 Target Server Type    : MySQL
 Target Server Version : 50743
 File Encoding         : 65001

 Date: 15/10/2024 13:14:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_app_api_info
-- ----------------------------
DROP TABLE IF EXISTS `t_app_api_info`;
CREATE TABLE `t_app_api_info`  (
  `app_id` int(11) NOT NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`app_id`, `type`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_app_api_info
-- ----------------------------
INSERT INTO `t_app_api_info` VALUES (1000, 'GetDevices', '/Device/MockList');
INSERT INTO `t_app_api_info` VALUES (1000, 'SendCmd', '/device/sendCmd');
INSERT INTO `t_app_api_info` VALUES (1001, 'GetDevices', '/device/getList');
INSERT INTO `t_app_api_info` VALUES (1002, 'GetDevices', '/GetDevs');
INSERT INTO `t_app_api_info` VALUES (1002, 'SendCmd', '/SendCmd');

-- ----------------------------
-- Table structure for t_app_info
-- ----------------------------
DROP TABLE IF EXISTS `t_app_info`;
CREATE TABLE `t_app_info`  (
  `app_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `app_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_delete` int(11) NOT NULL,
  PRIMARY KEY (`app_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1003 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_app_info
-- ----------------------------
INSERT INTO `t_app_info` VALUES (1000, 'TEST', 'TEST', 'http://meter.yue.shvber.com:4031', 0);
INSERT INTO `t_app_info` VALUES (1001, 'DEMO', 'TEST', 'http://shvber.com', 1);
INSERT INTO `t_app_info` VALUES (1002, 'TEST01', 'W98FWTQE2Y97U3RXSD6IMX0QCI0WEUK8', 'http://shvber.com', 1);

-- ----------------------------
-- Table structure for t_meter_calc_param
-- ----------------------------
DROP TABLE IF EXISTS `t_meter_calc_param`;
CREATE TABLE `t_meter_calc_param`  (
  `id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `time` int(20) NULL DEFAULT NULL,
  `sum_power` float(10, 2) NULL DEFAULT NULL,
  `max_power` float(10, 2) NULL DEFAULT NULL,
  `count` int(11) NULL DEFAULT NULL,
  `tps` float NULL DEFAULT NULL,
  `tqs` float NULL DEFAULT NULL,
  `fps` float NULL DEFAULT NULL,
  `fqs` float NULL DEFAULT NULL,
  `tpe` float NULL DEFAULT NULL,
  `tqe` float NULL DEFAULT NULL,
  `fpe` float NULL DEFAULT NULL,
  `fqe` float NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_meter_calc_param
-- ----------------------------
INSERT INTO `t_meter_calc_param` VALUES ('2024031185256281581', 20240312, 13.44, 1.12, 25, 212.8, 0, 0, 4.8, 1.60001, 0, 0, 0);

SET FOREIGN_KEY_CHECKS = 1;