/* Navicat Premium Data Transfer Source Server : 本地 Source Server Type : MySQL Source Server Version : 50724 Source Host : localhost:3306 Source Schema : ry-vue Target Server Type : MySQL Target Server Version : 50724 File Encoding : 65001 Date: 30/11/2021 11:07:18 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for topology -- ---------------------------- DROP TABLE IF EXISTS `topology`; CREATE TABLE `topology` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '组态名称', `created_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `alter_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间', `switch_it` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0表示关闭,1表示开启', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 113 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组态表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for images -- ---------------------------- DROP TABLE IF EXISTS `images`; CREATE TABLE `images` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'url', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组态图片表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;