gsd_cn/source/gsd/db/gsdDB.sql

/*
 Navicat MySQL Data Transfer

 Source Server         : apollo
 Source Server Type    : MySQL
 Source Server Version : 50738
 Source Host           : 192.168.31.174:13306
 Source Schema         : gsdDB

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

 Date: 13/05/2022 10:57:19
*/
# Create Database

CREATE DATABASE IF NOT EXISTS gsdDB DEFAULT CHARACTER SET = utf8mb4;
Use gsdDB;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for DeviceList
-- ----------------------------
DROP TABLE IF EXISTS `DeviceList`;
CREATE TABLE `DeviceList`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `DeviceId` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `DeviceToken` tinyint(255) NOT NULL,
  `DeviceType` tinyint(255) NOT NULL,
  `ServerIp` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ServerCname` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ServerCpwd` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `UpdateTime` datetime(0) NOT NULL,
  `ISDELETE` int(255) NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for HistoryVideo
-- ----------------------------
DROP TABLE IF EXISTS `HistoryVideo`;
CREATE TABLE `HistoryVideo`  (
  `Id` bigint(11) NOT NULL AUTO_INCREMENT,
  `fileName` varchar(900) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `UpdateTime` datetime(0) NOT NULL,
  `ISDELETE` int(255) NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for InferData
-- ----------------------------
DROP TABLE IF EXISTS `InferData`;
CREATE TABLE `InferData`  (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ClassId` int(11) NOT NULL,
  `Num` int(11) NOT NULL,
  `Remark` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `ImageBase64` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `WarningTime` datetime(0) NOT NULL,
  `VideoPath` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `attr1` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `attr2` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `attr3` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `Warn` tinyint(255) NOT NULL,
  `uuid` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `ISDELETE` int(11) NOT NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;