Files
new-ast-admin/sql/mnt_deploy_history.sql
2024-10-16 11:15:07 +08:00

39 lines
1.3 KiB
SQL

/*
Navicat Premium Data Transfer
Source Server : 远程
Source Server Type : MySQL
Source Server Version : 50744 (5.7.44)
Source Host : 8.137.112.156:3307
Source Schema : crm
Target Server Type : MySQL
Target Server Version : 50744 (5.7.44)
File Encoding : 65001
Date: 18/09/2024 15:03:19
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for mnt_deploy_history
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy_history`;
CREATE TABLE `mnt_deploy_history` (
`history_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'ID',
`app_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '应用名称',
`deploy_date` datetime NOT NULL COMMENT '部署日期',
`deploy_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '部署用户',
`ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '服务器IP',
`deploy_id` bigint(20) NULL DEFAULT NULL COMMENT '部署编号',
PRIMARY KEY (`history_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '部署历史管理' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of mnt_deploy_history
-- ----------------------------
SET FOREIGN_KEY_CHECKS = 1;